(function() {

  alert("you are in");

  //The app
  var dbid = "appid";

  //This is the time card table
  var dbidTable = "timecardtableid";

  //This is the rates table
  var dbidxTable = "ratestableid";

  //App token
  var myapptoken = "apptokenhere";

  $.ajaxSetup({
    data: {
      apptoken: myapptoken
    }
  }, {
    async: false
  });

  var csvData;
  var promiseD3 = $.getScript("https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.13/d3.min.js");

  var markup = '';
  markup += '<table>';
  markup += '  <tr>';
  markup += '    <td><label for=QBU_File><b>File</b></label></td>';
  markup += '    <td><input id=QBU_File name=QBU_File type=file></td>';
  markup += '  </tr>';
  markup += '</table>';

  var $mydialog = $("<div>").html(markup).dialog({
        title: "Select Time Card CSV file to Import",
        modal: true,
        autoOpen: false,
        width: 400,
        resizable: false,

        buttons: {
          Proceed: function() {
            $.post(dbidTable, {
              act: "API_ImportFromCSV",
              records_csv: csvData,
              clist: "171.28.29.30.31.32.89.41"
            }).then(function(xml) {
              document.location.href = dbidTable + "?a=td";
            });

            $(this).dialog("close");
          },

          Cancel: function() {
            $(this).dialog("close");
          }
        },

        open: function(event, ui) {
          $mydialog.show();
          $mydialog.html(markup);

          $("#QBU_File").on("change", function(e) {
              var file = e.target.files[0];
              var reader = new FileReader();
              reader.onload = function(e) {
                var contents = e.target.result;

                $.when(promiseD3).then(function(argsD3) {
                  alert("D3 was promised");
                  var data = d3.csv.parseRows(contents);

                  //For each row in the CSV file, query the rates table for the item id and find the latest record who's effective date is not greater than the invoice date                           _.each(data, function(item) {                                                                                             varInvDate = item[1];                                                                                                  varItemID = item[6];

                  processRecords(varItemID, varInvDate);
                });

                var csv = [];
                var index = 0;
              });
          }

          reader.readAsText(file);
        });
    },

    close: function(event, ui) {}

});

$mydialog.dialog("open");

function processRecords(vitem, vdate) {

  alert(vitem);
  alert(vdate);

  //This is a query on the rates table. We want to get the max effective date for the current itemID as compared to the current invoice date.

  //So we query for records with an effective date on or before the invoice date. The sort is descending on effective date, so the first record in the result set will be the on we want.

  //We need to take the Record ID from this first record and stamp it on the Related Record Id field on the time card table, which we are importing into.

  var promiseMaxEffDate = $.get(dbidxTable, {
    act: "API_DoQuery",
    query: "{'30'.EQ.'" + vitem + "'} AND {'45'.OBF.'" + vdate + "'}",
    clist: "45.3",
    slist: "45",
    includeRids: "1",
    options: "num-1.sortorder-D"
  });

  $.when(promiseMaxEffDate).then(function(argMaxEffDate) {
    alert("promiseMaxEffDate"); //Gets reference record id of the rates record for the itmeID/InvoiceDate
    //var refid = parseInt($("Record ID #", argMaxEffDate[0]).text() || "0", 10);               //alert("THEREFID " + refid);
  });

}


alert("you are out");

//Based on code from Dan Diebolt - phone number (734-985-0721)- email address (dandiebolt@yahoo.com) .

})();