MbrExHcuDMI.i

<?php

$HcuDMIi = new class()
{
  public function parms_parse($payload) {
      /*
       * parms_parse - explode parms into component values
       * called after reading record from database
       */

      list ($dmiloan) = explode(',', $payload);
      return array('dmiloan' => $dmiloan);
  }

  public function parms_validate($parms) {
      $dms_ok = array('dmiloan' => 'string');
      dms_import_v2($parms, "HCUPOST", $dms_ok);
      /*
       * parms_validate - check entries before attemtping db update
       *                  includes readying for db write
       *         called after form post, so import the needed form values
       */
      if (empty($parms['HCUPOST']['dmiloan'])) {
          $errors[] = 'Loan Number Required';
      } else {
          if (preg_match("/\D/", $parms['HCUPOST']['dmiloan']) || strlen($parms['HCUPOST']['dmiloan']) <> 10) {
              $errors[] = "Loan Number must be 10 digits";
          }
      }
      if (sizeof($errors)) {
          $payload[data] = '';
          $payload[errors] = $errors;
      } else {

          $payload[data] = "{$parms['HCUPOST']['dmiloan']}";
      }
      return $payload;
  }

  public function printTemplate()
  { ?>
      <span id="popupNotification"></span>
      <div id='gridMsg' style="width: 100%;"></div>
      <div id="window"></div>
      <div id="winErr"></div>
  <?php }

  public function printGlobals()
  { ?>
    var isCreating;
    var loanData= [];
    var accountData= [];
    var newRecord= {}, oldRecord= {};

    function updateLoanData(record, isOldRecord)
    {
      var data= loanData[record.accountnumber.trim()];
      if (data != null)
        for(var i=0; i!= data.length; i++)
        {
          if (data[i].loannumber.trim() == record.accounttype.trim())
          {
            data[i].extkeyid= isOldRecord ? 0 : record.keyid;
            break;
          }
        }
    }
  <?php }

  public function printInit($crudhost, $trustid, $fromUserHub=false)
  { ?>
      var windowTemplate= 'Delete loan number <strong>#= dmiloan #</strong> for member <strong>#= accountnumber #</strong>? </p>\
        <button class="k-button" id="yesButton">Yes</button>\
        <button class="k-button" id="noButton"> No</button>';

      var windowError= '#= Message #</p>\
        <button class="k-button" id="errCloseButton">Close</button>';

      windowTemplate = kendo.template(windowTemplate);
        var windowT = $("#window").kendoWindow({
          title: "Please Confirm",
          visible: false, //the window will not appear before its .open method is called
          width: "400px",
          modal: true,
          open: function() {
            if (window.activeWindows != null)
              window.activeWindows.push(this);
          },
          close: function() {
            if (window.activeWindows != null)
              window.activeWindows.pop();
          }
        }).data("kendoWindow");

      windowError = kendo.template(windowError);
        var winErr = $("#winErr").kendoWindow({
          title: "Error",
          visible: false, //the window will not appear before its .open method is called
          actions: ["Close"],
          modal: true,
          width: "400px",
          open: function() {
            if (window.activeWindows != null)
              window.activeWindows.push(this);
          },
          close: function() {
            if (window.activeWindows != null)
              window.activeWindows.pop();
          }
        }).data("kendoWindow");

        var popupNotification = $("#popupNotification").kendoNotification().data("kendoNotification");
        popupNotification.setOptions({
          appendTo: "body",
          stacking: 'up',
          autoHideAfter: 5000
        });

      var crudServiceBaseUrl = "<?php echo $crudhost; ?>?ft=534&trustid=<?php echo $trustid; ?>";
      <?php if ($fromUserHub) { ?>
        crudServiceBaseUrl+= "&userid=" + $("#selectedId").text();
      <?php } ?>
          dataSource = new kendo.data.DataSource({
           autoSync: false,
           batch: false,
           serverFiltering: false,
           serverPaging: false,
           page: 1,
           pageSize: 20,
           cache: false,
              transport: {
                  read:  {
                      type: "GET",
                      url: crudServiceBaseUrl + "&action=read",
                      dataType: "json"
                  },
                  update: {
                      type: "POST",
                      url: crudServiceBaseUrl + "&action=update",
                      dataType: "json"
                  },
                  destroy: {
                      type: "POST",
                      url: crudServiceBaseUrl + "&action=delete",
                      dataType: "json"
                  },
                  create: {
                      type: "POST",
                      url: crudServiceBaseUrl + "&action=new",
                      dataType: "json"
                  },
                  parameterMap: function(options, operation) {
                      if (operation !== "read" && options.models) {
                          return {models: kendo.stringify(options.models)};
                      } else if (operation === 'create' || operation === 'update' || operation === 'destroy') {
                          return options;
                      }
                  }
              },
        schema: {
              data: "homecuData",
              total: function(response)
              {
                return response.homecuData.length;
              },
              errors: function(response)
              {
                return response.homecuErrors != null && response.homecuErrors.length > 0 ? response.homecuErrors : null;
              },
              parse: function(response)
              {
                var returnValue= response.Results[0];
                if (returnValue.homecuInfo != null && returnValue.homecuInfo.length > 0)
                  popupNotification.show(returnValue.homecuInfo, "info");

                // Update loan data so that filters work.
                switch(returnValue.type)
                {
                  case "read":
                    loanData= returnValue.loanData;
                    accountData= returnValue.accountData;
                    break;
                  case "delete":
                    updateLoanData(oldRecord, true);
                    break;
                  case "new":
                    newRecord.keyid= returnValue.homecuData.keyid;
                    updateLoanData(newRecord, false);
                    break;
                  case "update":
                    if (oldRecord.accountnumber.trim() != newRecord.accountnumber.trim() || oldRecord.accounttype.trim() != newRecord.accounttype.trim())
                    {
                      updateLoanData(oldRecord, true);
                      updateLoanData(newRecord, false);
                    }
                    break;
                }
                return returnValue;
              },
                model: {
                  id: "keyid",
                  fields: {
                    keyid: {type: 'number'},
                    userid: {type: "number", editable: false},
                    accountnumber: {  type: 'string', validation: {required: { message: "Member Number Required" }}},
                    accounttype: { type: 'string', validation: {required: { message: "HCU Loan Number Required" }} },
                    parms: { type: 'string'},
                    dmiloan: { type: 'string', validation: {required: { message: "DMI Loan ID Required"}} }
                  }
              }
            },
            error: function(e)
            {
              grid.cancelRow();
              winErr.content(windowError({Message: e.errors.join("<br>")})); //send the err data object to the template and render it
              $("#winErr").closest(".k-window.k-widget").css({<?php printTopCenterCss(200, "", "jsGuts"); ?>});
              winErr.open();
            }
      });

          var grid= $("#gridMsg").kendoGrid({
              dataSource: dataSource,
              pageable: {
                pageSizes: [10, 20, 50],
                info: true,
                refresh: true,
                messages: {
                  display: "Showing {0}-{1} from {2} data items"
                }
              },
              filterable: true,
              sortable: true,
              batch: false,
              columns: [
                { field: "userid", title: "User"},
                { field:"accountnumber", title: "Member", width: "120px", editor: function(container, options) {
                  if (options.model.isNew())
                  {
                    options.model.userid= $("#selectedAccntId").text().trim();
                    options.model.accountnumber= $("#selectedAccnt").text().trim();
                    $(container).html(options.model.accountnumber);
                  }
                  else
                  {
                    var accountDDL= $("<div id='accountDDL'></div>").appendTo(container).kendoDropDownList({
                      dataSource: {
                        data: accountData
                      },
                      dataTextField: "accountnumber",
                      dataValueField: "accountnumber",
                      dataBound: function()
                      {
                        if (options.model.accountnumber > 0)
                          this.value(options.model.accountnumber.trim());
                        else
                          options.model.accountnumber= this.value(); // If defaulted to first
                      },
                      change: function()
                      {
                        options.model.dirty= true;
                        options.model.accountnumber= this.value();

                        var data= loanData[options.model.accountnumber.trim()];
                        if (data != null)
                          $("#hcuLoanDDL").data("kendoDropDownList").dataSource.data($.grep(data, function(n,i) { return n.extkeyid == 0 || n.extkeyid == options.model.keyid; }));
                      }
                    }).data("kendoDropDownList");
                  }
                }},
                  { field: "accounttype", title:"HCU Loan", width: "100px", editor: function(container, options) {
                    <?php if ($fromUserHub) { // These values are known if coming in through the user hub. ?>
                    if (options.model.isNew())
                    {
                      options.model.userid= $("#selectedAccntId").text().trim();
                      options.model.accountnumber= $("#selectedAccnt").text().trim();
                    }
                    <?php } ?>
                    var data= loanData[options.model.isNew() ? $("#selectedAccnt").text().trim() : options.model.accountnumber.trim()];
                    data= data == null ? [] : (options.model.isNew() ? $.grep(data, function(n,i) { return n.extkeyid == 0; })
                      : $.grep(data, function(n,i) { return n.extkeyid == 0 || n.extkeyid == options.model.keyid; }));

                    if (data.length > 0)
                    {
                      var loanDDL= $("<div id='hcuLoanDDL'></div>").appendTo(container).kendoDropDownList({
                        dataSource: {
                          data: data
                        },
                        dataTextField: "loannumber",
                        dataValueField: "loannumber",
                        dataBound: function()
                        {
                          if (options.model.accounttype != "")
                            this.value(options.model.accounttype.trim());
                          else
                            options.model.accounttype= this.value(); // If defaulted to first
                        },
                        change: function()
                        {
                          options.model.dirty= true;
                          options.model.accounttype= this.value();
                        }
                      }).data("kendoDropDownList");
                    }
                    else
                      $(container).text("No Loans!");
                  }},
                  { field: "dmiloan", title:"DMI Loan", width: "300px" },
                  { command: [{name: "edit", text: "Change"}, {name: "Delete"}], title: "&nbsp;", width: "200px" }],
            <?php if ($fromUserHub) { ?>
            toolbar: ["create"],
            <?php } else { ?>
            toolbar: [{name: "customCreate", text: "<span class='k-icon k-add'></span> Add New Record"}],
            <?php } ?>
            editable: "inline",
            edit: function(e)
            {
              oldRecord= {keyid: e.model.keyid, accounttype: e.model.accounttype, accountnumber: e.model.accountnumber};
            },
            save: function(e)
            {
              newRecord= {keyid: e.model.keyid, accounttype: e.model.accounttype, accountnumber: e.model.accountnumber};
            },
            noRecords: {
              template: "<tr><td colspan='<?php echo $fromUserHub ? 4 : 3; ?>'>No Records Found!</td></tr>"
            }
          }).data("kendoGrid");

        <?php if (!$fromUserHub) { ?>
        $("#gridMsg").on("click", ".k-grid-customCreate", function() {
            searchUser(function(dataItem) {
              grid.addRow(); // Should have the selected accnt and primary user in the variables ready for the edit function.
              $(".k-grid-edit-row .k-input:first").focus();
            });
            return false;
        });
        <?php } ?>

        $("#winErr").on("click", "#errCloseButton", function() {
          winErr.close();
          return false;
        });

        var deleteDataItem= null;
        $("#gridMsg").on("click", ".k-grid-Delete", function(e) {
           var tr = $(e.target).closest("tr"); //get the row for deletion
           deleteDataItem = grid.dataItem(tr); //get the row data so it can be referred later
           windowT.content(windowTemplate(deleteDataItem)); //send the row data object to the template and render it
           $("#window").closest(".k-window.k-widget").css({<?php printTopCenterCss(200, "", "jsGuts"); ?>});
           windowT.open();
           return false;
        });

        $("#window").on("click", "#yesButton", function() {
          dataSource.remove(deleteDataItem)  //prepare a "destroy" request
          dataSource.sync()  //actually send the request (might be omitted if the autoSync option is enabled in the dataSource)
          windowT.close();
          return false;
        });

        $("#window").on("click", "#noButton", function() {
          windowT.close();
          return false;
        });
  <?php }

  public function parms_disp4edit($findTab, $searchTab, $crudhost, $Cu, $trustid) {
      /*
       *       parms_disp4edit - layout screen for display / edit values
       */
      $this->printTemplate();
      printSearchTemplates($searchTab, $findTab);
      printExtKeyStyle();
      ?>

      <script>
        <?php // Library javascript functions
        getShowWaitFunctions();
        searchOutsideHub($searchTab, $findTab);
        $this->printGlobals(); ?>
        var activeWindows= [];


        $(document).ready(function() {
          <?php $this->printInit($crudhost, $trustid);
          printClickOverlayEvent();
          ?>
        });
      </script>
  <?php } // end parms_disp4edit
} // end class
?>