customTrigger.js

//global variables
var dataTableTriggers = "undefined";
var dataTableIssues = "undefined";

var appWebUrl = window.location.protocol + "//" + window.location.host + _spPageContextInfo.webServerRelativeUrl;
var targetSiteUrl = _spPageContextInfo.siteAbsoluteUrl;
var digest = "";

var listName = "Triggers";
var targetSiteUrl = _spPageContextInfo.siteAbsoluteUrl;
var eTag;
var clientContext;
var website;
var uID;
var currentUser;
var lastModifiedDate;
var uProgram;
var uCompetency;
var uAdmin;
var uName;
var uPhase;
var uType;



SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady);

function sharePointReady() {
    clientContext = SP.ClientContext.get_current();
    website = clientContext.get_web();
    clientContext.load(website);
    currentUser = website.get_currentUser();
    clientContext.load(currentUser);
    clientContext.executeQueryAsync(onRequestSucceeded, onRequestFailed);
}
function onRequestSucceeded() {
    var longUserName = currentUser.get_loginName();
    var startIndex = longUserName.lastIndexOf('\\');
    var thisUser = longUserName.substr(startIndex + 1);
    if (thisUser == "system") {
        thisUser = "white_kris";
        console.log("user is system, but changing to Kris.white for testing");
    }

    getProfile(thisUser);
    currentUser = thisUser;

    console.log("onRequestSucceeded processing login for " + currentUser);
    myCustomPage(); //now setup the page
}
function onRequestFailed(sender, args) {
    console.log('unable to load client context' + sender + args);
}

function getProfile(user) {
    console.log("getting profile for : " + user);
    var executor = new SP.RequestExecutor(appWebUrl);
    var listname = "Profiles";
    var baseUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items?";
    var filterUrl = "$filter=Title eq '" + user + "'";
    var fullUrl = baseUrl + filterUrl;
    console.log(fullUrl);
    var requestHeaders = { "accept": "application/json;odata=verbose" };
    executor.executeAsync({
        url: fullUrl,
        method: "GET",
        headers: requestHeaders,
        success: successGetProfileHandler,
        error: errorGetProfileHandler
    });
}
function successGetProfileHandler(data) {
    var jsonObject = JSON.parse(data.body);
    $.each(jsonObject.d, function (index, results) {
        uType = results[0].UserProfileType;
        if (uType === "PEO") {
            uProgram = results[0].Program;
            $("#userProgram").val(uProgram);
        } else {
            uCompetency = jsonObject.d.Competency;
        }
        uAdmin = results[0].IsLeadership;
        if (uType === "Competency" && uAdmin === "Yes") {
            $("#userProgram").val("ALL");
        }
        if (uType === "Competency" && uAdmin === "No") {
            $("#userProgram").val(uCompetency);
        }

        uID = results[0].ID;
        uName = results[0].Title;

        $("#userAdmin").val(uAdmin);
        console.log("processing login js GetProfile... for " + uName);
        currentUser = uName;
        uPhase = results[0].Phase;
        $("#userPhase").val(uPhase);
        $("#tbCopyIssuePhase").val(uPhase);
        $("#tbAddIssuePhase").val(uPhase);
    });//end of data for each


    //UPDATE UI      
    $("#userID").val(uID);
    $("#userName").val(currentUser);
    if (uAdmin === "Yes") {
        $("#userProgram").val("All");
        $("#userPhase").val("ALL");
        $("#userAdmin").val("Yes");
    }
    if (uAdmin === "No" && uType === "PEO") {
        $("#userPhase").val(uPhase);
        $("#userAdmin").val("No");
    }
    //We need to get the value again to determine if they have Competency
    var programtext = $("#userProgram").val();
    var $element = $("#login");
    if ($element) {
        $element.attr('href', "../SitePages/Profile.aspx?Name=" + uName +
                                                  "&ProfileId=" + uID +
                                                    "&program=" + programtext);
    }
    $("#userName").val(currentUser);
    $("#userProgram").val(uProgram);
    programtext = $("#userProgram").val();
    $("#usrProgram").text(" |  " + programtext);
} //end of success
function errorGetProfileHandler(data) {
    console.log("login failed: " + data.errorCode + data.errorMessage);
}




function myCustomPage() {
    if (uAdmin == "Yes") {
        $("#ddlfilter").append($("<option></option>").attr("value", "selectall").text("Select All"));
    }
    $("#ddlfilter").append($("<option></option>").attr("value", "test").text("TMRR"));
    $("#ddlfilter").append($("<option></option>").attr("value", "development").text("E&MD"));
    $("#ddlfilter").append($("<option></option>").attr("value", "production").text("Production P&D"));
    $("#ddlfilter").append($("<option></option>").attr("value", "postproduction").text("Post Production P&D"));
    $("#ddlfilter").append($("<option></option>").attr("value", "fleetintroduction").text("Fleet Introduction P&D"));
    $("#ddlfilter").append($("<option></option>").attr("value", "sustainment").text("Sustainment O&S"));

    $("#ddlfilter")
      .on('change',
          function () {
              var colnumber = 0;
              var filter = this.value;
              if (filter === "selectall") {
                  window.location.reload();
              }
              if (filter === "development") {
                  colnumber = 2;
                  LoadTriggerDataTableByPhase(filter);

              }
              if (filter === "test") {
                  colnumber = 3;
                  LoadTriggerDataTableByPhase(filter);

              }
              if (filter === "production") {
                  colnumber = 4;
                  LoadTriggerDataTableByPhase(filter);

              }
              if (filter === "fleet introduction") {
                  colnumber = 5;
                  LoadTriggerDataTableByPhase(filter);
              }
              if (filter === "post production") {
                  colnumber = 6;
                  LoadTriggerDataTableByPhase(filter);
              } if (filter === "sustainment") {
                  colnumber = 7;
                  LoadTriggerDataTableByPhase(filter);
              };

              var dialogCopyPhase = filter;
              $("#tbCopyIssuePhase").val(dialogCopyPhase);


              dataTableTriggers
                      .column(colnumber)
                      .search("Y")
                      .draw();
          });

    //Get Name of New User

    console.log(currentUser);

    GetUserInfo(currentUser);



    $("#userName").val(currentUser);
    $("#digestmsg").val(digest);


    LoadTriggersDataTable();

    //EVENTS
    $("#triggers tbody")
        .on("click", "tr", function () {
            var triggerfilter = dataTableTriggers.row(this).data().Title;  //trigger title
            var rowtriggerdata = dataTableTriggers.row(this).data().TriggerDescription;
            $("#tbCopyTriggerTitle").val(triggerfilter);
            $("#tbAddTriggerTitle").val(triggerfilter);
            LoadIssuesDataTable(triggerfilter);
            showTriggerDescription(rowtriggerdata);
        });

    $("#issues tbody")
        .on("click",
            "tr",
            function () {
                var rowissuetitle = dataTableIssues.row(this).data().Title;
                var rowissuedata = dataTableIssues.row(this).data().IssueDescription;
                var mit60ddata = dataTableIssues.row(this).data().Mitigation60d;
                var mit66data = dataTableIssues.row(this).data().Mitigation66;
                var mit67data = dataTableIssues.row(this).data().Mitigation67;
                var mit68data = dataTableIssues.row(this).data().Mitigation68;
                showIssueDescription(rowissuedata);
                showMitigationDescription(mit60ddata, mit66data, mit67data, mit68data);
                $("#tbCopyIssueTitle").val(rowissuedata);
                $("#tbCopyIssueDescription").val(rowissuedata);
                $("#taCopyMitigation60d").val(mit60ddata);
                $("#taCopyMitigation66").val(mit66data);
                $("#taCopyMitigation67").val(mit67data);
                $("#taCopyMitigation68").val(mit68data);
            });

    //Copy form, Save button
    $("#btnCopyTo")
      .on("click",
          function () {
              var list = $("#ddlCopyTo").val();
              if (list == "Select List") {
                  $("#tbCopyStatusArea").val("You must select a category");
              } else {
                  CopyTo();
              }
          });



    //Copy form, SaveAndContinue button
    $("#btnSaveAndContinue")
      .on("click",
          function () {
              var list = $("#ddlCopyTo").val();
              if (list == "Select List") {
                  $("#tbCopyStatusArea").val("You must select a category");
              } else {
                  //for the copy form
                  SaveAndContinue();
              }
          });

    //Add form, Save button
    $("#btnAddTo")
      .on("click",
          function () {
              var list = $("#ddlAddTo").val();
              if (list == "Select List") {
                  $("#tbAddStatusArea").val("You must select a category");
              } else {
                  AddTo(list);
              }
          });

    //Add form, SaveAndContinue button
    $("#btnAddSaveAndContinue").on("click", function () {
        var list = $("#ddlAddTo").val();
        if (list == "Select List") {
            $("#tbAddStatusArea").val("You must select a category");
        } else {
            //for a blank form
            AddSaveAndContinue();
        }
    });

    $("#btnAddIssue").on("click", function () { // for a blank form
        var list = $("#ddlAddTo").val();
        if (list == "Select List") {
            $("#tbAddStatusArea").val("You must select a category");
        } else {
            AddTo(list);
        }
    });

    $("#btnAddCancel")
       .on("click",
       function () {
           $("#tbAddStausArea").val("");
           $("#tbCopyStausArea").val("");
           window.location.replace("Triggers.aspx");
       });

    GetDigest();

    $('#tbCopyMitigationStart').datepicker();
    $('#tbCopyMitigationEnd').datepicker();
    $('#tbAddMitigationStart').datepicker();
    $('#tbAddMitigationEnd').datepicker();

    LoadTriggersDataTable();
}//end of my custom page


//SETUP PAGE with Digest automatically
function GetDigest() {
    var scriptbase = targetSiteUrl + "/_layouts/15/";
    $.getScript(scriptbase + "SP.RequestExecutor.js", retrieveFormDigest);
}
//executor2 Update UI with Digest
function retrieveFormDigest() {
    digest = $("#__REQUESTDIGEST").val();
    var contextInfoUri = appWebUrl + "/_api/contextinfo";
    var executor2 = new SP.RequestExecutor(appWebUrl);
    executor2.executeAsync({
        url: contextInfoUri,
        method: "POST",
        headers: { "Accept": "application/json; odata=verbose" },
        success: successRetrieveDigest,
        error: errorRetrieveDigest
    });
}
function successRetrieveDigest(data) {
    console.log("digest is " + digest);
    $('#digestmsg').val(digest);
    retrieveLastModifiedDate();
}
function errorRetrieveDigest(data, errorCode, errorMessage) {
    var errMsg = "Error retrieving the form digest value: " + errorMessage;
    $("#error").val(errMsg);
}

//Executor3 Update UI with last modified date
function retrieveLastModifiedDate() {

    var contextInfoUri = appWebUrl + "/_api/web/lastItemModifiedDate";
    var executor3 = new SP.RequestExecutor(appWebUrl);
    executor3.executeAsync({
        url: contextInfoUri,
        method: "POST",
        headers: { "Accept": "application/json; odata=verbose" },
        success: succRetrieveLastModifiedDate,
        error: errRetrieveLastModifiedDate
    });
}

function succRetrieveLastModifiedDate(data) {
    var month = "";
    var jsonObject = JSON.parse(data.body);
    lastModifiedDate = jsonObject.d.LastItemModifiedDate.substring(0, 10);
    console.log("Last Modified date: " + lastModifiedDate);
    $("#lastUpdated").text(" | " + "Last Updated: " + lastModifiedDate);
}
function errRetrieveLastModifiedDate(data, errorCode, errorMessage) {
    var errMsg = "Error retrieving the last modified date: " + errorMessage;
    $("#error").val(errMsg);
}

//Executor4 Load and filter Trigger Table based on user program and phase
function LoadTriggersDataTable() {
    // if (dataTableTriggers != "undefined") {
    //     dataTableTriggers.destroy();
    // }
    listname = "Triggers";
    var filterUrl = "";

    //check if Admin? They will see all triggers

    //dont filter any programs if Admin             
    if (uAdmin === "Yes") {
        filterUrl = "$top=1000";  //limit list to just 1000
    }
    if (uAdmin === "No" && uType === "PEO") {
        filterUrl = "$filter=Program eq '" + uProgram + "'&$top=1000";
        alert(uProgram);
    }
    //filter by Competency
    if (uAdmin === "No" && uType === "Competency") {
        filterUrl = "$filter=Program eq '" + uCompetency + "'&$top=1000";
        alert(uCompetency);
    }

    console.log("uProgram is" + uProgram);

    var executor4 = new SP.RequestExecutor(appWebUrl);
    var baseUrl = appWebUrl;
    var selectUrl = "/_api/web/Lists/getbyTitle('" + listname + "')/items?";

    var fullUrl = baseUrl + selectUrl + filterUrl;
    var requestHeaders = { "accept": "application/json;odata=verbose" };
    var listname = "Triggers";
    var usrProgram = $('#userProgram').val();
    var baseUrl = _spPageContextInfo.webAbsoluteUrl;
    var selectUrl = "/_api/web/Lists/getbyTitle('" + listname + "')/items";
    var fullUrl = baseUrl + selectUrl;
    $.ajax({
        url: fullUrl,
        type: "GET",
        dataType: "json",
        headers: requestHeaders,
        success: TriggersSuccHandler,
        error: TriggersErrHandler
    });
}

function TriggersSuccHandler(data) {
    if (dataTableTriggers != "undefined") {
        dataTableTriggers.destroy();
    }
    dataTableTriggers = $("#triggers")
        .DataTable({
            "bDestroy": true,
            select: { style: "single" },
            dom: 'Bfrtip',
            buttons: true,// ['copy', 'excel', 'pdf', 'print']
            "aaData": data.d.results,
            "aoColumns": [
                { "mData": "Title" },
                { "mData": "TriggerDescription" },
                { "mData": "Development" },
                { "mData": "Test" },
                { "mData": "Production" },
                { "mData": "FleetIntroduction" },
                { "mData": "PostProduction" },
                { "mData": "Sustainment" }
            ],
            scrollY: 300,
            columnDefs: [

                {   //trigger title
                    "targets": [0],
                    "visible": true,
                    "searchable": true
                }
                ,
                {   //trigger description
                    "targets": [1],
                    "visible": false,
                    "searchable": false
                }
                ,
                {   //dev
                    "targets": [2],
                    "visible": false,
                    "searchable": true
                },

                {    //test
                    "targets": [3],
                    "visible": false,
                    "searchable": true
                },
                {   //production
                    "targets": [4],
                    "visible": false,
                    "searchable": true
                },
                {   //fleet introduction
                    "targets": [5],
                    "visible": false,
                    "searchable": true
                },
                {   //postproduction
                    "targets": [6],
                    "visible": false,
                    "searchable": true
                },
                {   //sustainment
                    "targets": [7],
                    "visible": false,
                    "searchable": true
                }


            ],
            columns: [
                { name: "Title" },
                { name: "TriggerDescription" },
                { name: "Development" },
                { name: "Test" },
                { name: "Production" },
                { name: "FleetIntroduction" },
                { name: "PostProduction" },
                { name: "Sustainment" }
            ],
            "searching": true,
            "paging": true,
            "info": true
        });



}

function TriggersErrHandler(data, errCode, errMessage) {
    console.log("Error: " + errMessage);
}

//Executor5 Loads Issues based on the Trigger selected
function LoadIssuesDataTable(filter) {
    if (dataTableIssues !== "undefined") {
        dataTableIssues.destroy();
    }
    var executor5 = new SP.RequestExecutor(appWebUrl);
    var baseUrl = appWebUrl;
    var filterUrl = "";
    listname = "ProgramIssuesAndRisks";
    var selectUrl = "/_api/web/Lists/getbyTitle('" + listname + "')/items?";
    filterUrl = "$filter=Trigger eq '" + filter + "'";
    var fullUrl = baseUrl + selectUrl + filterUrl;
    var requestHeaders = { "accept": "application/json;odata=verbose" };
    $.ajax({
        url: fullUrl,
        type: "GET",
        dataType: "json",
        headers: requestHeaders,
        success: IssuesSuccHandler,
        error: IssuesErrHandler
    });
}
function IssuesSuccHandler(data) {
    dataTableIssues = $("#issues")
        .DataTable({
            "bDestroy": true,
            select: { style: "single" },
            "aaData": data.d.results,
            "aoColumns": [
                { "mData": "Title" },
                { "mData": "IssueDescription" },
                { "mData": "Trigger" },
                { "mData": "Mitigation60d" },
                { "mData": "Mitigation66" },
                { "mData": "Mitigation67" },
                { "mData": "Mitigation68" }
            ],
            dom: 'Bfrtip',
            buttons: true,
            fixedHeader: true,
            scrollY: 300,
            scrollX: true,
            columnDefs: [
                {
                    //Title issue
                    "targets": [0],
                    "visible": true,
                    "searchable": true
                },

                {
                    //Issue description
                    "targets": [1],
                    "visible": false,
                    "searchable": false
                },
                 {
                     //trigger
                     "targets": [2],
                     "visible": false,
                     "searchable": false
                 },
                 {
                     //Mitigation 6.0d
                     "targets": [3],
                     "visible": false,
                     "searchable": true
                 },
                {
                    //Mitigation 66
                    "targets": [4],
                    "visible": false,
                    "searchable": true
                },
                 {
                     //Mitigation 67
                     "targets": [5],
                     "visible": false,
                     "searchable": true
                 },
                {
                    //Mitigation 68
                    "targets": [6],
                    "visible": false,
                    "searchable": true
                }
            ],
            columns: [
                { name: "Title" },
                { name: "IssueDescription" },
                { name: "Trigger" },
                { name: "Mitigation 60d" },
                { name: "Mitigation 66" },
                { name: "Mitigation 67" },
                { name: "Mitigation 68" }
            ],
            "searching": true,
            "true": false,
            "true": false
        });
}
function IssuesErrHandler(data, errCode, errMessage) {
    console.log("Error: " + errMessage);
}

function clearDescriptionTable() {
    var oTable = $("#TriggerDescription").DataTable({});
    oTable
           .clear()
           .destroy();
}

function clearIssuesDescriptionTable() {
    var oTable2 = $("#IssueDescription").DataTable({
        scrollY: 400,
        scrollX: true
    });
    oTable2
       .clear()
        .destroy();
}

function clearMitigationDescriptionTable() {

    var oTable3 = $("#MitigationDescription").DataTable({
        scrollY: 200
    });
    oTable3
       .clear()
        .destroy();
}

function clearTriggersTable() {
    var oTable = $("#Triggers").DataTable({});
    oTable
           .clear()
           .destroy();
}


function showTriggerDescription(trigdesc) {
    var oTable = $("#TriggerDescription").DataTable({});
    oTable
       .clear()
       .destroy();

    $("#TriggerDescription").append("<tr class='added'><td>" + trigdesc + "</td>/tr>");
    $("#TriggerDescription").append("<tr class='added'><td>----------------------------</td></tr>");

}

function showIssueDescription(issdesc) {
    var oTable2 = $("#IssueDescription").DataTable({});
    oTable2
       .clear()
        .destroy();
    $("#IssueDescription").append("<tr class='added'><td>" + issdesc + "</td>/tr>");
    $("#IssueDescription").append("<tr class='added'><td>----------------------------</td></tr>");

}

function showMitigationDescription(mit60ddata, mit66data, mit67data, mit68data) {
    var oTable3 = $("#MitigationDescription").DataTable({});
    oTable3
       .clear()
       .destroy();

    console.log(mit60ddata, mit66data, mit67data, mit68data);
    if (mit60ddata) {
        $("#MitigationDescription").append("<tr class='added'><td>Mitigation 6.0d: " + mit60ddata + "</td>/tr>");
        $("#MitigationDescription").append("<tr class='added'><td>----------------------------</td></tr>");
    }
    if (mit66data) {
        $("#MitigationDescription").append("<tr class='added'><td>Mitigation 6.6" + mit66data + "</td>/tr>");
        $("#MitigationDescription").append("<tr class='added'><td>----------------------------</td></tr>");
    }
    if (mit67data) {
        $("#MitigationDescription").append("<tr class='added'><td>Mitigation 6.7d" + mit67data + "</td>/tr>");
        $("#MitigationDescription").append("<tr class='added'><td>----------------------------</td></tr>");
    }
    if (mit68data) {
        $("#MitigationDescription").append("<tr class='added'><td>Mitigation 6.8d" + mit68data + "</td>/tr>");
        $("#MitigationDescription").append("<tr class='added'><td>----------------------------</td></tr>");
    }
}

//Executor6 Get another copy of User Info?
function GetUserInfo(username) {
    var executor6 = new SP.RequestExecutor(appWebUrl);
    var listname = "Profiles";
    var baseUrl = appWebUrl;
    var selectUrl = "/_api/web/lists/getbytitle('" + listname + "')/items?";
    var filterUrl = "$filter=Title eq '" + username + "'";
    var fullUrl = baseUrl + selectUrl + filterUrl;
    var requestHeaders = { "accept": "application/json;odata=verbose" };

    executor6.executeAsync({
        url: fullUrl,
        method: "GET",
        headers: requestHeaders,
        success: successGetUserInfoHandler,
        error: errorGetUserInfoHandler
    });
}
function successGetUserInfoHandler(data) {
    var userID = "";
    var userDisplayName = "";
    var userLeadership = "";
    var userProgram = "";
    var userPhase = "";
    //load the select option for ddlProgram 
    var jsonObject = JSON.parse(data.body);
    var results = jsonObject.d.results;
    userID = results[0].ProfileID;

    $("#userID").val(userID);
    $("#ddlUser").text(currentUser);

    userLeadership = results[0].IsLeadership;

    $("#userAdmin").val(userLeadership);
    userProgram = results[0].Program;
    userPhase = results[0].Phase;

    $("#userProgram").val(userProgram);
    $("#userPhase").val(userPhase);


    //UPDATE UI  

    var $element = $("#login");
    if ($element) {
        $element.attr('href', "../SitePages/Profile.aspx?Name=" + currentUser + "&id=" + userID + "&program=" + userProgram);
    }

}
function errorGetUserInfoHandler(data, errCode, errMessage) {
    console.log("login failed: " + data.errorCode + data.errorMessage);
}


function CopySelectedIssueDialog() {
    $('#CopyIssue').modal();
}

function ShowAddTriggerDialog() {
    $('#AddTriggerDialog').modal();
}

//Executor7 Add Trigger 
function AddTrigger() {
    var dialogtriggertitle;
    var dialogtriggerdescription;
    var dialogtriggercbdevepment;
    var dialogtriggercbtest;
    var dialogtriggercbproduction;
    var dialogtriggercbpostproduction;
    var dialogtriggercbfleet;
    var dialogtriggercbsustainment;


    dialogtriggertitle = $("#tbAddDialogTriggerTitle").val();
    dialogtriggerdescription = $("#tbAddDialogTriggerDescription").val();

    if ($("#cbDevelopment").is(':checked')) {
        dialogtriggercbdevepment = "True";
    } else {
        dialogtriggercbdevepment = "False";
    }

    if ($("#cbTest").is(':checked')) {
        dialogtriggercbtest = "True";
    } else {
        dialogtriggercbtest = "False";
    }

    if ($("#cbProduction").is(':checked')) {
        dialogtriggercbproduction = "True";
    } else {
        dialogtriggercbproduction = "False";
    }

    if ($("#cbPostProduction").is(':checked')) {
        dialogtriggercbpostproduction = "True";
    } else {
        dialogtriggercbpostproduction = "False";
    }

    if ($("#cbFleetIntroduction").is(':checked')) {
        dialogtriggercbfleet = "True";
    } else {
        dialogtriggercbfleet = "False";
    }

    if ($("#cbSustainment").is(':checked')) {
        dialogtriggercbsustainment = "True";
    } else {
        dialogtriggercbsustainment = "False";
    }

    var listname = "Triggers";
    var executor7 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': dialogtriggertitle,
        'TriggerDescription': dialogtriggerdescription,
        'Development': dialogtriggercbdevepment,
        'Test': dialogtriggercbtest,
        'Production': dialogtriggercbproduction,
        'FleetIntroduction': dialogtriggercbfleet,
        'PostProduction': dialogtriggercbpostproduction,
        'Sustainment': dialogtriggercbsustainment
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };

    executor7.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successAddedTriggerHandler,
        error: errorAddedTriggerHandler
    });
}
function successAddedTriggerHandler() {
    $("#tbAddDialogStatus").val("Trigger Added");
}
function errorAddedTriggerHandler(data, errorCode, errorMessage) {
    $("#tbAddDialogStatus").val("Fialed to add Trigger : " + errorCode + errorMessage);
}

//Executor8  Copy Risk to My Program Risks
//Copy to Risk from pefilled dialog
function CopyToRisks() {
    var action = "copy";
    var listname = "MyProgramRisks";
    var trigger = $('#tbCopyTriggerTitle').val();
    var issue = $('#tbCopyIssueTitle').val();
    var phase = $('#tbCopyIssuePhase').val();
    var type = $('#tbCopyIssueType option:selected').val();
    var description = $('#tbCopyIssueDescription').val();
    var mitigation60d = $('#taCopyMitigation60d').val();
    var mitigation66 = $('#taCopyMitigation66').val();
    var mitigation67 = $('#taCopyMitigation67').val();
    var mitigation68 = $('#taCopyMitigation68').val();
    var mitigationStartDate = $('#tbCopyMitigationStart').val();
    var mitigationEndDate = $('#tbCopyMitigationEnd').val();
    var status = $('#ddlCopyIssueStatus').val();
    var likelihood = $('#tbCopyIssueLikelihood').val();
    var consequence = $('#tbCopyIssueConsequence').val();
    var executor8 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': issue,
        'Trigger': trigger,
        'Phase': phase,
        'IssueDescription': description,
        'Type1': type,
        'Mitigation60d': mitigation60d,
        'Mitigation66': mitigation66,
        'Mitigation67': mitigation67,
        'Mitigation68': mitigation68,
        'MitigationStart': mitigationStartDate,
        'MitigationEnd': mitigationEndDate,
        'Status': status,
        'Likelihood': likelihood,
        'Consequence': consequence
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };

    executor8.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successCopyToRiskHandler,
        error: errorCopyToRiskHandler
    });
}
function successCopyToRiskHandler() {
    $("#tbCopyStatusArea").val("Copied to My Program Risk");
    console.log("My Program Risk updated");
}
function errorCopyToRiskHandler(data, errorCode, errorMessage) {
    $("#tbCopyStatusArea").val("Copied to My Program Risk failed " + errorCode + errorMessage);
    console.log(errorCode + errorMessage);
}

//Executor9 Copy Issues to MyProgramIssues
//Copy to Issues from pefilled dialog
function CopyToIssues() {
    var action = "copy";
    var listname = "MyProgramIssues";
    var trigger = $('#tbCopyTriggerTitle').val();
    var issue = $('#tbCopyIssueTitle').val();
    var phase = $('#tbCopyIssuePhase').val();
    var type = $('#tbCopyIssueType option:selected').val();
    var description = $('#tbCopyIssueDescription').val();
    var mitigation60d = $('#taCopyMitigation60d').val();
    var mitigation66 = $('#taCopyMitigation66').val();
    var mitigation67 = $('#taCopyMitigation67').val();
    var mitigation68 = $('#taCopyMitigation68').val();
    var mitigationStartDate = $('#tbCopyMitigationStart').val();
    var mitigationEndDate = $('#tbCopyMitigationEnd').val();
    var status = $('#ddlCopyIssueStatus').val();
    var likelihood = $('#tbCopyIssueLikelihood').val();
    var consequence = $('#tbCopyIssueConsequence').val();
    var executor9 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': issue,
        'Trigger': trigger,
        'Phase': phase,
        'IssueDescription': description,
        'Type1': type,
        'Mitigation60d': mitigation60d,
        'Mitigation66': mitigation66,
        'Mitigation67': mitigation67,
        'Mitigation68': mitigation68,
        'MitigationStart': mitigationStartDate,
        'MitigationEnd': mitigationEndDate,
        'Status': status,
        'Likelihood': likelihood,
        'Consequence': consequence
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };
    executor9.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successCopyToIssuesHandler,
        error: errorCopyToIssuesHandler
    });

}
function successCopyToIssuesHandler() {
    $("#tbCopyStatusArea").val("Copied to My Program Issues.");
    console.log("My Program Issues updated");
}
function errorCopyToIssuesHandler(data, errorCode, errorMessage) {
    $("tbCopyStatusArea").val("My Program Issues failed " + errorCode + errorMessage);
    console.log(errorCode + errorMessage);
}

//Executor10
//Add to Risk from empty dialog
function AddToRisks() {
    var actionlist = list;
    var action = "add";
    var listname = "MyProgramRisks";
    var trigger = $('#tbAddTriggerTitle').val();
    var issue = $('#tbAddIssueTitle').val();
    var phase = $('#tbAddIssuePhase').val();
    var type = $('#tbAddIssueType option:selected').val();
    var description = $('#tbAddIssueDescription').val();
    var mitigation60d = $('#taAddMitigation60d').val();
    var mitigation66 = $('#taAddMitigation66').val();
    var mitigation67 = $('#taAddMitigation67').val();
    var mitigation68 = $('#taAddMitigation68').val();
    var mitigationStartDate = $('#tbAddMitigationStart').val();
    var mitigationEndDate = $('#tbAddMitigationEnd').val();
    var status = $('#ddlAddStatus').val();
    var likelihood = $('#tbAddIssueLikelihood option:selected').val();
    var consequence = $('#tbAddIssueConsequence option:selected').val();
    var executor10 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': issue,
        'Trigger': trigger,
        'Phase': phase,
        'IssueDescription': description,
        'Type1': type,
        'Mitigation60d': mitigation60d,
        'Mitigation66': mitigation66,
        'Mitigation67': mitigation67,
        'Mitigation68': mitigation68,
        'MitigationStart': mitigationStartDate,
        'MitigationEnd': mitigationEndDate,
        'Status': status,
        'Likelihood': likelihood,
        'Consequence': consequence
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };

    executor10.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successAddToRiskHandler,
        error: errorAddToRiskHandler
    });
}
function successAddToRiskHandler() {
    $("#tbAddStatusArea").val("My Program Risk updated");
}
function errorAddToRiskHandler(data, errorCode, errorMessage) {
    $("#tbAddStatusArea").val("My Program Risk failed " + errorCode + errorMessage);
    console.log(errorCode + errorMessage);
}

//Executor11
//Add to Issues from empty dialog
function AddToIssues() {
    var action = "add";
    var listname = "MyProgramIssues";
    var trigger = $('#tbAddTriggerTitle').val();
    var issue = $('#tbAddIssueTitle').val();
    var phase = $('#tbAddIssuePhase').val();
    var type = $('#tbAddIssueType option:selected').val();
    var description = $('#tbAddIssueDescription').val();
    var mitigation60d = $('#taAddMitigation60d').val();
    var mitigation66 = $('#taAddMitigation66').val();
    var mitigation67 = $('#taAddMitigation67').val();
    var mitigation68 = $('#taAddMitigation68').val();
    var mitigationStartDate = $('#tbAddMitigationStart').val();
    var mitigationEndDate = $('#tbAddMitigationEnd').val();
    var status = $('#ddlAddIssueStatus').val();
    var likelihood = $('#tbAddIssueLikelihood option:selected').val();
    var consequence = $('#tbAddIssueConsequence option:selected').val();
    var executor11 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': issue,
        'Trigger': trigger,
        'Phase': phase,
        'IssueDescription': description,
        'Type1': type,
        'Mitigation60d': mitigation60d,
        'Mitigation66': mitigation66,
        'Mitigation67': mitigation67,
        'Mitigation68': mitigation68,
        'MitigationStart': mitigationStartDate,
        'MitigationEnd': mitigationEndDate,
        'Status': status,
        'Likelihood': likelihood,
        'Consequence': consequence
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };

    executor11.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successAddToIssuesHandler,
        error: errorAddToIssuesHandler
    });



}
function successAddToIssuesHandler() {
    $("#tbAddStatusArea").val("My Program Issues updated");
}
function errorAddToIssuesHandler(data, errorCode, errorMessage) {
    $("#tbAddStatusArea").val("My Program Issues failed " + errorCode + errorMessage);
    console.log(errorCode + errorMessage);
}

function GetItemTypeForListName(list) {
    return "SP.Data." + list.charAt(0).toUpperCase() + list.split(" ").join(" ").slice(1) + "ListItem";
}

//Executor12
//Add to Both Issues and Risks to Drafts from dialog
function SaveToDrafts(dtype, action) {
    listname = "MyProgramDrafts";
    var trigger = "";
    var issue = "";
    var phase = "";
    var type = "";
    var description = "";
    var mitigation60d = "";
    var mitigation66 = "";
    var mitigation67 = "";
    var mitigation68 = "";
    var mitigationStartDate = "";
    var mitigationEndDate = "";
    var status = "";
    var likelihood = "";
    var consequence = "";
    if (action == "add") {
        // Read contents of the Add Dialog
        trigger = $('#tbAddTriggerTitle').val();
        issue = $('#tbAddIssueTitle').val();
        phase = $('#tbAddIssuePhase').val();
        type = $('#tbAddIssueType option:selected').val();
        description = $('#tbAddIssueDescription').val();
        mitigation60D = $('#taAddMitigation60d').val();
        mitigation66 = $('#taAddMitigation66').val();
        mitigation67 = $('#taAddMitigation67').val();
        mitigation68 = $('#taAddMitigation68').val();
        mitigationStartDate = $('#tbAddMitigationStart').val();
        mitigationEndDate = $('#tbAddMitigationEnd').val();
        status = $('#ddlAddIssueStatus option:selected').val();
        likelihood = $('#tbAddIssueLikelihood option:selected').val();
        consequence = $('#tbAddIssueConsequence option:selected').val();
    }
    if (action == "copy") {
        //Read contents of the Copy Dialog
        trigger = $('#tbCopyTriggerTitle').val();
        issue = $('#tbCopyIssueTitle').val();
        phase = $('#tbCopyIssuePhase').val();
        type = $('#tbCopyIssueType option:selected').val();
        description = $('#tbCopyIssueDescription').val();
        mitigation60D = $('#taCopyMitigation60d').val();
        mitigation66 = $('#taCopyMitigation66').val();
        mitigation67 = $('#taCopyMitigation67').val();
        mitigation68 = $('#taCopyMitigation68').val();
        mitigationStartDate = $('#tbCopyMitigationStart').val();
        mitigationEndDate = $('#tbCopyMitigationEnd').val();
        status = $('#ddlCopyIssueStatus option:selected').val();
        likelihood = $('#tbCopyIssueLikelihood option:selected').val();
        consequence = $('#tbCopyIssueConsequence option:selected').val();
    }
    if (status == "Select Value") {
        status = "";
    }
    if (type == "Select Value") {
        type = "";
    }
    if (likelihood == "Select Value") {
        likelihood = "";
    }
    if (consequence == "Select Value") {
        consequence = "";
    }

    var executor12 = new SP.RequestExecutor(appWebUrl);
    var fullUrl = appWebUrl + "/_api/web/lists/getbytitle('" + listname + "')/items";
    var itemType = GetItemTypeForListName(listname);
    var requestBody = JSON.stringify({
        '__metadata': { 'type': itemType },
        'Title': issue,
        'Trigger': trigger,
        'Phase': phase,
        'IssueDescription': description,
        'Type1': type,
        'Mitigation60d': mitigation60d,
        'Mitigation66': mitigation66,
        'Mitigation67': mitigation67,
        'Mitigation68': mitigation68,
        'MitigationStart': mitigationStartDate,
        'MitigationEnd': mitigationEndDate,
        'Status': status,
        'Likelihood': likelihood,
        'Consequence': consequence
    });

    var requestHeaders = {
        "accept": "application/json;odata=verbose",
        "X-RequestDigest": digest,
        "X-HTTP-METHOD": "POST",
        "content-length": requestBody.length,
        "Content-Type": "application/json;odata=verbose"
    };

    executor12.executeAsync({
        url: fullUrl,
        method: "POST",
        body: requestBody,
        headers: requestHeaders,
        success: successSaveToDraftsHandler,
        error: errorSaveToDraftsHandler
    });

    if (action == "copy") {

        $("#tbCopyStatusArea").val("Draft Saved to My Program Drafts");
    }
    if (action == "add") {

        $("#tbAddStatusArea").val("Draft Saved to My Program Drafts");
    }



}
function successSaveToDraftsHandler(data, action) {
    if (action == "copy") {

        $("#tbCopyStatusArea").val("Draft Saved to My Program Drafts");
    }
    if (action == "add") {

        $("#tbAddStatusArea").val("Draft Saved to My Program Drafts");
    }
}
function errorSaveToDraftsHandler(data, action, errorCode, errorMessage) {
    if (action == "copy") {

        $("#tbCopyStatusArea").val("My Drafts was not updated " + errorCode + errorMessage);
    }
    if (action == "add") {

        $("#tbAddStatusArea").val("My Drafts was not updated " + errorCode + errorMessage);
    }
    console.log(errorCode + errorMessage);
}

//User press the Save Button on the Copy form
function CopyTo() {
    var list = $("#CopyIssue #ddlCopyTo").find("option:selected").text();
    if (list == "Risk") {
        CopyToRisks();
    }
    if (list == "Issue") {
        CopyToIssues();
    }
}


function AddTo(action) {

    if (action == "Risk") {
        AddToRisks();
    }
    if (action == "Issue") {
        AddToIssues();
    }

}


//Save to Drafts either Risk or Issues
function SaveAndContinue() {
    var drafttype = $("#CopyIssue #ddlCopyTo").text();
    SaveToDrafts(drafttype, "copy");
}

function AddSaveAndContinue() {
    var drafttype = $("#CopyIssue #ddlAddTo").val();
    SaveToDrafts(drafttype, "add");
}


//Executor4 Load and filter Trigger Table based on user program and phase
function LoadTriggersDataTableByPhase(phase) {
    if (dataTableTriggers != "undefined") {
        dataTableTriggers.destroy();
    }
    listname = "Triggers";
    var filterUrl = "";
    var filterPhase = "";

    //check if Admin? They will see all triggers
    if (phase == "development") {
        filterPhase = "$filter=Development eq '" + Y + "'";
    }
    if (phase == "test") {
        filterPhase = "$filter=test eq '" + Y + "'";
    }
    if (phase == "production") {
        filterPhase = "$filter=production eq '" + Y + "'";
    }
    if (phase == "postproduction") {
        filterPhase = "$filter=postproduction eq '" + Y + "'";
    }
    if (phase == "fleetintroduction") {
        filterPhase = "$filter=fleetintroduction eq '" + Y + "'";
    }
    if (phase == "sustainment") {
        filterPhase = "$filter=sustainment eq '" + Y + "'";
    }

    //dont filter any programs if Admin             
    if (uAdmin === "Yes") {
        filterProgram = "$top=1000";  //limit list to just 1000
        filterPhase = "and (Phase eq '" + phase + "')&$top=1000";
        filterUrl = filterProgram + filterPhase;

    }
    if (uAdmin === "No" && uType === "PEO") {
        filterProgram = "$filter=Program eq '" + uProgram + "'";
        filterPhase = "and (Phase eq '" + phase + "')&$top=1000";
        filterUrl = filterProgram + filterPhase;
    }
    //filter by Competency
    if (uAdmin === "No" && uType === "Competency") {
        filterProgram = "$filter=Program eq '" + uCompetency + "'";
        filterPhase = "and (Phase eq '" + phase + "')&$top=1000";
        filterUrl = filterProgram + filterPhase;
    }

    console.log("uProgram is" + uProgram);

    var executor4 = new SP.RequestExecutor(appWebUrl);
    var baseUrl = appWebUrl;
    var selectUrl = "/_api/web/Lists/getbyTitle('" + listname + "')/items?";

    var fullUrl = baseUrl + selectUrl + filterUrl;
    var requestHeaders = { "accept": "application/json;odata=verbose" };
    var listname = "Triggers";
    var usrProgram = $('#userProgram').val();
    var baseUrl = _spPageContextInfo.webAbsoluteUrl;
    var selectUrl = "/_api/web/Lists/getbyTitle('" + listname + "')/items";
    var fullUrl = baseUrl + selectUrl;
    $.ajax({
        url: fullUrl,
        type: "GET",
        dataType: "json",
        headers: requestHeaders,
        success: TriggersSuccHandler,
        error: TriggersErrHandler
    });
}

function TriggersSuccHandler(data) {
    if (dataTableTriggers != "undefined") {
        dataTableTriggers.destroy();
    }
    dataTableTriggers = $("#triggers")
        .DataTable({
            "bDestroy": true,
            select: { style: "single" },
            dom: 'Bfrtip',
            buttons: true,
            "aaData": data.d.results,
            "aoColumns": [
                { "mData": "Title" },
                { "mData": "TriggerDescription" },
                { "mData": "Development" },
                { "mData": "Test" },
                { "mData": "Production" },
                { "mData": "FleetIntroduction" },
                { "mData": "PostProduction" },
                { "mData": "Sustainment" }
            ],
            scrollY: 300,
            columnDefs: [

                {   //trigger title
                    "targets": [0],
                    "visible": true,
                    "searchable": true
                }
                ,
                {   //trigger description
                    "targets": [1],
                    "visible": false,
                    "searchable": false
                }
                ,
                {   //dev
                    "targets": [2],
                    "visible": false,
                    "searchable": true
                },

                {    //test
                    "targets": [3],
                    "visible": false,
                    "searchable": true
                },
                {   //production
                    "targets": [4],
                    "visible": false,
                    "searchable": true
                },
                {   //fleet introduction
                    "targets": [5],
                    "visible": false,
                    "searchable": true
                },
                {   //postproduction
                    "targets": [6],
                    "visible": false,
                    "searchable": true
                },
                {   //sustainment
                    "targets": [7],
                    "visible": false,
                    "searchable": true
                }


            ],
            columns: [
                { name: "Title" },
                { name: "TriggerDescription" },
                { name: "Development" },
                { name: "Test" },
                { name: "Production" },
                { name: "FleetIntroduction" },
                { name: "PostProduction" },
                { name: "Sustainment" }
            ],
            "searching": true,
            "paging": false,
            "info": false
        });



}

function TriggersErrHandler(data, errCode, errMessage) {
    console.log("Error: " + errMessage);
}

function ResetForm() {
    window.location.reload();

}