2nd post
fd.field('ProjectContactLookUp').ready().then(function() {
fd.field('ProjectContractorLookUp').$on('change', function(){
//alert(fd.field('ProjectContractorLookUp').value.LookupId);
filterProjectContacts();
readyAddContact();
fd.field('ProjectContactLookUp').value = null;
});
fd.field('ProjectContractorLookUp').ready().then(function(field){
filterProjectContacts(field.value);
});
});
fd.field('ProjectContractorLookUp').ready().then(filterProjectContractors);
fd.field('CustomerLookup').ready().then(orderCustomer);
fd.field('CustomerLookup').$on('change', function (customer) {
fd.field('Customer').value = customer.LookupValue;
});
fd.field('RespContact').ready().then(function() {
fd.field('RespContractor').$on('change', function(value3) {
filterRespPerson(value3);
fd.field('RespContact').value = null;
});
fd.field('RespContractor').ready().then(function(field) {
filterRespPerson(field.value);
});
});
$(fd.control('OpenItemsOIL').$el).find('.btn').hide();
$(fd.control('AllOil').$el).find('.btn').hide();
$(fd.control('PastDueOIL').$el).find('.btn').hide();
$(fd.control('PipeTest').$el).find('.btn').hide();
fd.control('PastDueOIL').$on('edit', function(editData) {
var perFilter = ''
editData.field('Responsible_x0020_Contractor').filter = 'Project/Id eq ' + fd.itemId;
editData.field('Responsible_x0020_Contractor').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').disabled = true;
editData.field('Responsible_x0020_Contractor').$on('change', function(value) {
if (!value) {
editData.field('Responsible_x0020_Person').value = null;
editData.field('Responsible_x0020_Person').disabled = true;
} else {
editData.field('Responsible_x0020_Person').disabled = false;
perFilter = "ProjectContractorId eq '" + value.Id + "'";
editData.field('Responsible_x0020_Person').filter = perFilter;
editData.field('Responsible_x0020_Person').widget.dataSource.read()
}
});
editData.field('Complete').$on('change', function(value) {
if (value) {
editData.field('MeetingCompleted').value = fd.itemId;
} else {
editData.field('MeetingCompleted').value = null;
}
});
});
fd.control('AllOil').$on('edit', function(editData) {
var perFilter = ''
editData.field('Responsible_x0020_Contractor').filter = 'Project/Id eq ' + fd.itemId;
editData.field('Responsible_x0020_Contractor').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').disabled = true;
editData.field('Responsible_x0020_Contractor').$on('change', function(value) {
if (!value) {
editData.field('Responsible_x0020_Person').value = null;
editData.field('Responsible_x0020_Person').disabled = true;
} else {
editData.field('Responsible_x0020_Person').disabled = false;
perFilter = "ProjectContractorId eq '" + value.Id + "'";
editData.field('Responsible_x0020_Person').filter = perFilter;
editData.field('Responsible_x0020_Person').widget.dataSource.read()
}
});
editData.field('Complete').$on('change', function(value) {
if (value) {
editData.field('MeetingCompleted').value = fd.itemId;
} else {
editData.field('MeetingCompleted').value = null;
}
});
});
fd.control('OpenItemsOIL').$on('edit', function(editData) {
var perFilter = ''
editData.field('Responsible_x0020_Contractor').filter = 'Project/Id eq ' + fd.itemId;
editData.field('Responsible_x0020_Contractor').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').useCustomFilterOnly = true;
editData.field('Responsible_x0020_Person').disabled = true;
editData.field('Responsible_x0020_Contractor').$on('change', function(value) {
if (!value) {
editData.field('Responsible_x0020_Person').value = null;
editData.field('Responsible_x0020_Person').disabled = true;
} else {
editData.field('Responsible_x0020_Person').disabled = false;
perFilter = "ProjectContractorId eq '" + value.Id + "'";
editData.field('Responsible_x0020_Person').filter = perFilter;
editData.field('Responsible_x0020_Person').widget.dataSource.read()
}
});
editData.field('Complete').$on('change', function(value) {
if (value) {
editData.field('MeetingCompleted').value = fd.itemId;
} else {
editData.field('MeetingCompleted').value = null;
}
});
});
fd.control('PhaseList').$on('edit', function(editData) {
editData.field('Modifier').filter = "Project/Id eq '" + fd.field("ID").value + "'";
editData.field('Modifier').useCustomFilterOnly = true;
editData.field('PhaseLU').$on('change', function(value) {
var phaseCopy = editData.field('PhaseLU').value.LookupValue
var phaseID = editData.field('PhaseLU').value.LookupId
editData.field('PhaseCopy').value = phaseCopy;
sp.web.lists.getByTitle('Phase List').items.getById(phaseID).select("Title", "Number").get().then( function (items) {
var phaseNum = items.Number;
editData.field('PhaseOrigNumber').value = phaseNum
editData.field('PhaseNumber').value = phaseNum
});
});
editData.field('Modifier').$on('change', function(value) {
if (editData.field('PhaseLU').value == null) {
alert('Please select the Phase first');
editData.field('Modifier').value = '';
editData.field('PhaseNumber').value = '';
} else {
if (value != null) {
var modID = editData.field('Modifier').value.LookupId;
var phaseValue = editData.field('PhaseLU').value.LookupValue;
var modValue = editData.field('Modifier').value.LookupValue;
editData.field('PhaseCopy').value = phaseValue + ', ' + modValue;
} else {
editData.field('PhaseCopy').value = editData.field('PhaseLU').value.LookupValue;
};
var t1 = editData.field('PhaseNumber').value;
var t2 = t1.substring(0,1);
var t3 = t1.substring(2,4);
sp.web.lists.getByTitle('ModPhaseAppends').items.getById(modID).select("Title", "Identifier/ID").expand("Identifier").get().then( function (item) {
var modiID = item.Identifier.ID
sp.web.lists.getByTitle('Modifier').items.getById(modiID).select("Title").get().then( function (itemM) {
editData.field('PhaseNumber').value = t2 + itemM.Title + t3;
});
});
}
});
});
if (dtDocs.widget) {
setRootFolder();
} else {
dtDocs.$on('ready', function() {
setRootFolder();
});
}
fd.control('AllRFIs').dialogOptions = {
width: 1024,
height: 720
}
fd.control('OpenPOs').dialogOptions = {
width: 1024,
height: 720
}
fd.control('DailyLog').dialogOptions = {
width: 1024,
height: 720
}
fd.control('PastDuePOs').dialogOptions = {
width: 1024,
height: 720
}
fd.control('ProjPresentation').dialogOptions = {
width: 1024,
height: 720
}
fd.control('MaterialPurchasing').dialogOptions = {
width: 1024,
height: 720
}
fd.control('EquipmentOrders').dialogOptions = {
width: 1024,
height: 720
}
fd.control('LateReturn').dialogOptions = {
width: 1024,
height: 720
}
fd.control('AllRentals').dialogOptions = {
width: 1024,
height: 720
}
fd.control('execMeetings').dialogOptions = {
width: 1024,
height: 720
}
fd.control('TimeSheet').dialogOptions = {
width: 1024,
height: 720
}
fd.control('PipeTest').dialogOptions = {
width: 1024,
height: 720
}
fd.control('Permits').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIs').dialogOptions = {
width: 1024,
height: 720
}
fd.control('progMeetings').dialogOptions = {
width: 1024,
height: 720
}
fd.control('PreJobConference').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIPastDue').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIDueInNextWeek').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIHighPriority').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIMoreInfo').dialogOptions = {
width: 1024,
height: 720
}
fd.control('RFIAnswered').dialogOptions = {
width: 1024,
height: 720
}
fd.control('Drawings').dialogOptions = {
width: 1024,
height: 720
}
fd.control('CategoryList').dialogOptions = {
width: 1024,
height: 720
}
fd.control('Fabrications').dialogOptions = {
width: 1024,
height: 720
}
function setRootFolder(){
dtDocs.rootFolder = String(combo);
}
fd.control('Submittals').dialogOptions = {
width: 1024,
height: 720
}
fd.control('PCOs').dialogOptions = {
width: 1280,
height: 720
}
$(fd.field('IsInFlow').$parent.$el).hide();
fd.control('Modifiers').ready().then(function(dt) {
dt.buttons[0].text = 'Add Modifier';
});
setInterval(styleExecMeeting, 1000);
styleExecMeeting();
setInterval(styleRFITables, 1000);
styleRFITables();
setInterval(styleOIL, 1000);
styleOIL();
function styleOIL () {
fd.control('AllOil').ready().then(function(dt) {
dt.buttons[0].text = 'Add Item';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].DateDue)
var d = b.diff(m, 'days');
//console.log('Complete: ' + value[i].Complete + ' Date Due: ' + b + ' Difference in Days: ' + d);
if (d < 0 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if ( d >= 0 && d <=7 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
};
});
fd.control('OpenItemsOIL').ready().then(function(dt) {
dt.buttons[0].text = 'Add Item';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].DateDue)
var d = b.diff(m, 'days');
if (d < 0 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if ( d >= 0 && d <=7 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
};
});
fd.control('PastDueOIL').ready().then(function(dt) {
dt.buttons[0].text = 'Add Item';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
console.log(value);
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].DateDue)
var d = b.diff(m, 'days');
if (d < 0 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if ( d >= 0 && d <=7 && value[i].Complete == 'No') {
$(row[i+1].cells[5]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
};
});
}
function styleRFITables () {
fd.control('AllRFIs').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
fd.control('RFIs').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
fd.control('RFIPastDue').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
fd.control('RFIDueInNextWeek').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
fd.control('RFIHighPriority').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
fd.control('RFIMoreInfo').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
var value = dt.widget.dataItems();
var row = $(dt.$el).find('tr');
if(value){
$.getScript('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.24.0/moment-with-locales.js')
.then(function() {
for (var i = 0; i < value.length; i++){
var m = moment(new Date());
var b = moment(value[i].Date_x0020_Due);
var d = b.diff(m, 'days');
if (d < 0 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #ff6666; background-color:#ffb3b3")
} else if (d >= 0 && d <= 7 && value[i].RFI_x0020_Status != '(3) Closed') {
$(row[i+1].cells[4]).attr("style","border-bottom:2px solid #66ff66; background-color:#b3ffb3")
}
}
});
}
});
}
$(fd.control('DailyLog').$el).find('.btn').hide();
fd.control('RFIAnswered').ready().then(function(dt) {
dt.buttons[0].text = 'Add RFI';
});
fd.control('MaterialPurchasing').ready().then(function(dt) {
dt.buttons[0].text = 'New Purchase Order';
});
fd.control('OpenPOs').ready().then(function(dt) {
dt.buttons[0].text = 'New Purchase Order';
});
fd.control('PastDuePOs').ready().then(function(dt) {
dt.buttons[0].text = 'New Purchase Order';
});
fd.control('EquipmentOrders').ready().then(function(dt) {
dt.buttons[0].text = 'Add Equipment';
});
fd.control('LateReturn').ready().then(function(dt) {
dt.buttons[0].text = 'Add Equipment';
});
fd.control('AllRentals').ready().then(function(dt) {
dt.buttons[0].text = 'Add Equipment';
});
fd.control('Submittals').ready().then(function(dt) {
dt.buttons[0].text = 'Log Submittal';
});
fd.control('TimeSheet').ready().then(function(dt) {
dt.buttons[0].text = 'Add Time Sheet';
});
});
fd.spSaved(function(result) {
result.RedirectUrl = null;
setTimeout(function(){ fd._showAlert(); }, 6000);
});