aMemberDelete.prg

<?php
/**
 *  @package MemberHub
 *  @author MGHandy
 *
 *  @uses this script facilitates in deleting account transaction history
 *  for this member's sub accounts.
 *
 *  @uses view and select users in the user hub
 *  @uses view and selected user accounts in the member hub
 *
 *  @param operation    string: requested operation for this script
 *  @param payload      string: encryption for the selected member
 *  @param mAccount     string: operation= select member account, this
 *  is the requested member account to selected in the member hub.
 *
 *  @return json
 */
require_once("$admLibrary/aMemberSupport.i");

try {
  $admVars = array();
  $admOk = array(
    "operation" => array("filter" => FILTER_SANITIZE_STRING),
    "payload" => array("filter" => FILTER_SANITIZE_STRING),
    "mHistory" => array("filter" => FILTER_SANITIZE_STRING)
  );
  HCU_ImportVars($admVars, "MEMBER_DELETE", $admOk);

  $dOperation = isset($admVars["MEMBER_DELETE"]["operation"]) ? $admVars["MEMBER_DELETE"]["operation"] : null;
  $dPayload = isset($admVars["MEMBER_DELETE"]["payload"]) ? $admVars["MEMBER_DELETE"]["payload"] : null;
  $dHistory = isset($admVars["MEMBER_DELETE"]["mHistory"]) ? $admVars["MEMBER_DELETE"]["mHistory"] : null;

  $dMember = $dPayload ?
    MemberDecrypt($SYSENV, $Cu, $dPayload) :
    null;

  $dContext = $dPayload ?
    MemberContext($SYSENV, $Cu, $dMember['member']) :
    MemberContext($SYSENV, $Cu);

  $aryResult = array();
  $aryReply = array();

  switch ($dOperation) {
    case "":
      PrintMemberDelete();
      break;
    case "memberReadHistory":
      header('Content-type: application/json');

      $dHistory = MemberReadHistory($SYSENV, $dbh, $dContext);
      $aryResult['data']['history'] = $dHistory['history'];
      MemberReply($aryResult, $aryReply, $dOperation);
      break;
    case "memberDeleteHistory":
      header('Content-type: application/json');

      $dValidateHistory = MemberValidateHistory($SYSENV, $dContext, $dHistory);
      $dDelete = MemberDeleteHistory($SYSENV, $dbh, $dContext, $dValidateHistory);
      $dHistory = MemberReadHistory($SYSENV, $dbh, $dContext);

      $aryResult['info'] = isset($dDelete['message']) ? $dDelete['message'] : "";
      $aryResult['data']['history'] = $dHistory['history'];
      MemberReply($aryResult, $aryReply, $dOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $dOperation);
      break;
  }

} catch (Exception $e) {
  $aryReply['errors'][] = $e->getMessage();
  $aryResult['data'] = array();
  $aryResult['info'] = array();

  MemberReply($aryResult, $aryReply, $dOperation);
  exit;
}

function MemberValidateHistory($pEnv, $pContext, $pHistory) {
  $cuMember = $pContext['m_account'];

  $sList = html_entity_decode($pHistory, ENT_QUOTES);
  $dList = HCU_JsonDecode($sList);

  $dValidate = array();
  foreach ($dList as $action => $set) {
    $dValidate[$action] = array();

    foreach ($set as $key => $value) {
      $dValidate[$action][] = array(
        "_action" => "delete",
        "accounttype" => prep_save($value['aType'], 25)
      );
    }
  }

  return $dValidate;
}

function MemberDeleteHistory($pEnv, $pDbh, $pContext, $pHistory) {

  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $cuHistoryLoan = $pHistory['loan'];
  $cuHistoryDeposit = $pHistory['deposit'];

  $sqlReturn = array();
  $sqlDelete = "";
  $sqlDeleteRs = null;
  $sqlTrans = "";
  $sqlTransRs = null;

  try {
    // begin transaction
    $sqlTrans = "BEGIN TRANSACTION";
    $sqlTransRs = db_query($sqlTrans, $pDbh);

    // add sql for deposit deletions
    if (count($cuHistoryDeposit) > 0) {
      foreach ($cuHistoryDeposit as $key => $value) {
        $sqlDelete .= "
          DELETE FROM {$cuTable}accounthistory
          WHERE accountnumber = '$cuMember'
            AND accounttype = '{$value['accounttype']}';";
      }
    }

    // add sql for loan deletions
    if (count($cuHistoryLoan) > 0) {
      foreach ($cuHistoryLoan as $key => $value) {
        $sqlDelete .= "
          DELETE FROM {$cuTable}loanhistory
          WHERE accountnumber = '$cuMember'
            AND loannumber = '{$value['accounttype']}';";
      }
    }

    // delete query for deposit and loan accounts
    $sqlDeleteRs = db_query($sqlDelete, $pDbh);
    if (!$sqlDeleteRs) {
      $pEnv['logger']->error(db_last_error());
      throw new Exception("Failed to delete sub-account history.");
    }

    // commit transaction
    $sqlTrans = "COMMIT TRANSACTION";
    $sqlTransRs = db_query($sqlTrans, $pDbh);

  } catch (Exception $e) {
    // transaction failed
    $pEnv['logger']->error(db_last_error());

    // revert transaction
    $sqlTrans = "ROLLBACK TRANSACTION";
    $sqlTransRs = db_query($sqlTrans, $pDbh);
    throw new Exception($e->getMessage());
  }

  // send success message
  if (count($cuHistoryDeposit) > 0) { $sqlReturn['message'][] = "Deposit account history has been deleted successfully."; }
  if (count($cuHistoryLoan) > 0) { $sqlReturn['message'][] = "Loan account history has been deleted successfully.";}
  return $sqlReturn;
}

function MemberReadHistory($pEnv, $pDbh, $pContext) {
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];
  $cuMember = $pContext['m_account'];

  $sqlReturn = array();
  $sqlData = array();
  $sqlColumns = "
    DISTINCT ON (lb.loannumber) lb.loannumber AS a_type,
    lb.accountnumber AS a_number,
    lb.description AS a_desc,
    'Loan' AS a_record";
  $sqlSub = "
    SELECT COUNT(*)
    FROM {$cuTable}loanhistory lh
    WHERE lh.accountnumber = '$cuMember'
      AND lh.loannumber = lb.loannumber";
  $sqlSelect = "
    SELECT $sqlColumns, ($sqlSub) AS a_count
    FROM {$cuTable}loanbalance lb
    WHERE lb.accountnumber = '$cuMember'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read transaction history for loan accounts.");
  }
  $sqlData['loan'] = db_fetch_all($sqlSelectRs);

  $sqlColumns = "
    DISTINCT ON (ab.accounttype) ab.accounttype AS a_type,
    ab.accountnumber AS a_number,
    ab.description AS a_desc,
    'Deposit' AS a_record";
  $sqlSub = "
    SELECT COUNT(*)
    FROM {$cuTable}accounthistory ah
    WHERE ah.accountnumber = '$cuMember'
      AND ah.accounttype = ab.accounttype";
  $sqlSelect = "
    SELECT $sqlColumns, ($sqlSub) AS a_count
    FROM {$cuTable}accountbalance ab
    WHERE ab.accountnumber = '$cuMember'";
  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to read transaction history for deposit accounts.");
  }
  $sqlData['deposit'] = db_fetch_all($sqlSelectRs);
  $sqlData['history'] = array();

  if (is_array($sqlData['deposit'])) { $sqlData['history'] = array_merge($sqlData['history'], $sqlData['deposit']); }
  if (is_array($sqlData['loan'])) { $sqlData['history'] = array_merge($sqlData['history'], $sqlData['loan']); }

  $sqlReturn['history'] = $sqlData['history'];
  return $sqlReturn;
}

?>

<?php
/**
 *  @package PrintMemberDelete
 *  @uses print neccessary html/javascript to run the selected card
 */
function PrintMemberDelete() { ?>
<div id="mdHistory">
  <div id="status"></div>

  <h3>Deposit Accounts</h3>
  <div id="mdGridDeposit"></div>
  &nbsp;
  <h3>Loan Accounts</h3>
  <div id="mdGridLoan"></div>

  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
      <span class="hcu-icon-delete">
      </span>
      <a href="##" id="lnkCancel">Cancel</a>
      &ensp;
      <a href="##" id="btnUpdate" class="k-button k-primary">
        <i class="fa fa-trash fa-lg"></i>
        Delete
      </a>
    </div>
  </div>
</div>

<div id="mdConfirm">
  <p>You are about to delete the transaction history for the selected accounts.</p>
  <p>Do you wish to continue?</p>
</div>
<?php
/**
 *  @package MemberDelete
 *  @uses this object is used to display and interact with the member related users
 *  feature.
 *
 *  @var Init               public: call to initialize data/view/action objects
 *  @var Open               public: call to open the mamber search module/window
 *  @var Close              public: call to close the member search module/window
 *  @var Data               public: call to load payload and member display into
 *   MemberRelated object for later use.
 *
 *  @var InitDataSources    private: initialize all data sources/objects
 *  @var InitDataViews      private: initialize all data views/objects
 *  @var InitDataActions    private: initialize all user actions on html.
 *
 *  @var EventOpenWindow    private: open kendoDialog/kendoWindow objects
 *  @var EventCloseWindow   private: close kendoDialog/kendoWindow objects
 *  @var EventPopWindow     private: remove the correct window from the window stack.
 *
 *  @var Info*              private: success/error message display.
 *
 *  @var Event*             private: other event functions explained by name.
 *    Some are entensions of kendo objects, others just help with events of html objects.
 *
 *  @var Validate*          private: validation functions for fors and other user
 *    input interactions.
 *
 *  @var Action*            private: these functions are calls from kendoDialog
 *    actions, each explained by function name.
 */

?>

<script type="text/javascript">
var MemberDelete = function() {
  var mdCardContainer = null;
  var mdCardWindows = null;

  var mdPayload = null;
  var mdCall = null;
  var mdAction = null;

  var mdDataSource = null;
  var mdHistory = null;
  var mdGridLoan = null;
  var mdGridDeposit = null;
  var mdGridDataLoan = null;
  var mdGridDataDeposit = null;
  var mdTooltip = null;

  var mdConfirm = null;
  var mdCancel = null;
  var mdDelete = null;

  var ValidateHistoryDirty = function() {
    var data = null;

    data = mdGridDeposit.dataSource.data();
    for (var i = 0; i < data.length; i++) {
      if (data[i].aDelete) { return true; }
    }

    data = mdGridLoan.dataSource.data();
    for (var i = 0; i < data.length; i++) {
      if (data[i].aDelete) { return true; }
    }

    return false;
  }

  var DataAccountsSort = function(data) {
    if (data.length < 2) {
      return data;
    }

    var middle = Math.floor(data.length / 2);
    var left = data.slice(0, middle);
    var right = data.slice(middle);

    return DataAccountsMerge(DataAccountsSort(left), DataAccountsSort(right));
  }

  var DataAccountsMerge = function(left, right) {
    var sort = [];
    var xLeft = 0;
    var xRight = 0;

    while (xLeft < left.length && xRight < right.length) {
      if (left[xLeft].aType < right[xRight].aType) {
        sort.push(left[xLeft++]);
      } else {
        sort.push(right[xRight++]);
      }
    }

    return sort.concat(left.slice(xLeft), right.slice(xRight));
  }

  var DataBuildHistory = function(data) {
    mdGridDataLoan = [];
    mdGridDataDeposit = [];
    for (var i = 0; i < data.length; i++) {
      var account = {
        aCount: parseInt(data[i].a_count),
        aDesc: data[i].a_desc ? data[i].a_desc.trim() : null,
        aNumber: data[i].a_number ? data[i].a_number.trim() : null,
        aRecord: data[i].a_record ? data[i].a_record.trim() : null,
        aType: data[i].a_type ? data[i].a_type.trim() : null,
        aDelete: false
      };

      if (account.aRecord == "Loan") {
        mdGridDataLoan.push(account);
      } else {
        mdGridDataDeposit.push(account);
      }
    }

    mdGridDataLoan = DataAccountsSort(mdGridDataLoan);
    mdGridDataDeposit = DataAccountsSort(mdGridDataDeposit);
    mdGridLoan.dataSource.data(mdGridDataLoan);
    mdGridDeposit.dataSource.data(mdGridDataDeposit);
    $("#dp_DFT").prop("checked", false);
    $("#ln_DFT").prop("checked", false);
  }

  var EventCheckBoxChange = function(e) {
    var box = $(e.target);
    var boxId = box.attr("id");
    var boxGrid = boxId.substring(0, 2);
    var boxType = boxId.substring(3, boxId.length);
    var boxValue = box.prop("checked");

    if (!boxValue) {
      $("input[id=" + boxGrid + "_DFT]").prop("checked", false);
    }

    if (boxType == "DFT") {
      $("input[id^=" + boxGrid + "_]:not(:disabled)").each(function(e) {
        if (e > 0) {
          $(this).prop("checked", boxValue);
          $(this).trigger("change");
        }
      });
    } else {
      var row = box.closest("tr");
      var rowItem = boxGrid == "dp" ?
        mdGridDeposit.dataItem(row) :
        mdGridLoan.dataItem(row);

      rowItem.aDelete = boxValue;
    }

    var rowCheckAll = true;
    $("input[id^=" + boxGrid + "_]").closest(".k-grid").find("tr").each(function(i) {
      var row = $(this);
      var rowItem = boxGrid == "dp" ?
        mdGridDeposit.dataItem(row) :
        mdGridLoan.dataItem(row);

      if (!rowItem.aDelete && rowItem.aCount > 0) { rowCheckAll = false; }
    });

    if (rowCheckAll) {
      $("#" + boxGrid + "_DFT").prop("checked", true);
    }
  }

  var EventOpenWindow = function(e) {
    var windowElement = this.element[0];
    var windowId = windowElement.id;

    switch (windowId) {

    }

    mdCardWindows.push(this);
  }

  var EventCloseWindow = function(e) {
    var windowElement = this.element[0];
    var windowId = windowElement.id;

    switch (mdAction) {
      case "historyDelete":
        e.preventDefault();
        if (ValidateHistoryDirty()) {
          mdConfirm.open();
        }
        break;
      case "deleteConfirm":
        var data = null;
        var memberData = {
          deposit: [], // deposit
          loan: [] // loan
        };

        data = mdGridDeposit.dataSource.data();
        for (var i = 0; i < data.length; i++) {
          var item = data[i];
          if (item.aDelete) {
            memberData.deposit.push(item);
          }
        }

        data = mdGridLoan.dataSource.data();
        for (var i = 0; i < data.length; i++) {
          var item = data[i];
          if (item.aDelete) {
            memberData.loan.push(item);
          }
        }

        var memberRequest = {
          operation: "memberDeleteHistory",
          payload: mdPayload,
          mHistory: JSON.stringify(memberData)
        }

        mdDataSource.transport.options.read.type = "POST";
        mdDataSource.read(memberRequest);

        EventPopWindow(windowId);
        break;
      default:
        EventPopWindow(windowId);
        if (windowId === "mdDelete") {
          // reset validator to hub script
          $.homecuValidator.setup({
            formStatusField: "formStatus"
          });
        }
        break;
    }

    mdAction = null;
  }

  var EventPopWindow = function(windowId) {
    var popIndex = -1;
    for (var i = 0; i < mdCardWindows.length; i++) {
      var openWindow = mdCardWindows[i].element[0];
      var openId = openWindow.id;

      if (openId == windowId) {
        popIndex = i;
        break;
      }
    }

    if (popIndex > -1) {
      mdCardWindows.splice(popIndex, 1);
    }
  }

  var InitDataSources = function() {
    mdDataSource = new kendo.data.DataSource({
      transport: {
        read: {
          url: "main.prg",
          dataType: "json",
          contentType: "application/x-www-form-urlencoded",
          type: "GET",
          data: {
            ft: "103107"
          },
          cache: false
        }
      },
      requestStart: function(request) {
        showWaitWindow();
      },
      requestEnd: function(response) {
        setTimeout(hideWaitWindow, 500);

        if (response.hasOwnProperty("response")) {
          if (response.response.hasOwnProperty("Results")) {
            var results = response.response.Results;

            if (results.hasOwnProperty("error")) {
              $.homecuValidator.homecuResetMessage = true;
              $.homecuValidator.displayMessage(results.error, $.homecuValidator.settings.statusError);
            } else if (results.hasOwnProperty("info")) {
              $.homecuValidator.homecuResetMessage = true;
              $.homecuValidator.displayMessage(results.info, $.homecuValidator.settings.statusSuccess);
            }
          } else {
            $.homecuValidator.displayMessage("Error Parsing Server", $.homecuValidator.settings.statusError);
          }
        } else {
          $.homecuValidator.displayMessage("Error Parsing Server", $.homecuValidator.settings.statusError);
        }
      },
      schema: {
        parse: function(response) {
          var results = null;
          var resultData = null;
          var resultOperation = null;

          if (response.hasOwnProperty("Results")) {
            results = response.Results;
            resultData = results.data;
            resultOperation = results.operation;
          }

          if (results.hasOwnProperty("errors")) {
            return [];
          }

          if (resultData == undefined || resultData == null) {
            return [];
          }

          setTimeout(function() {
            switch (resultOperation) {
              case "memberReadHistory":
                DataBuildHistory(resultData.history);
                mdMember.cardTitle= "Delete Account History";
                var template= kendo.template($("#titleTemplate").html());
                mdHistory.title(template(mdMember)).center().open();
                break;
              case "memberDeleteHistory":
                DataBuildHistory(resultData.history);
                break;
            }
          }, 500);
          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    mdHistory = $("#mdHistory").kendoWindow({
      title: "Delete History",
      minWidth: 300,
      maxWidth: 768,
      maxHeight: 900,
      modal: true,
      visible: false,
      resizable: false,
      activate: EventOpenWindow,
      close: EventCloseWindow,
      open: function(e) {
        this.wrapper.css({ top: 100 });
      }
    }).data("kendoWindow");

    mdGridDeposit = $("#mdGridDeposit").kendoGrid({
      dataSource: {
        data: []
      },
      dataBound: function() {
        $("#mdGridDeposit input[id^=dp_]").off();
        $("#mdGridDeposit input[id^=dp_]").on("change", EventCheckBoxChange);
        $(this.tbody).find("tr").each(function(i) {
          var rowData = mdGridDeposit.dataItem(this);
          var rowColumns = $(this).find("td");

          $(this).css("cursor", "pointer");
          $(this).css("background", "transparent");

          if (rowData.aCount == 0) {
            $(rowColumns[0]).find("input").attr("disabled", true);
            $(rowColumns[0]).addClass("vsgDisabled");
            $(rowColumns[1]).addClass("vsgDisabled");
            $(rowColumns[2]).addClass("vsgDisabled");
            $(rowColumns[3]).addClass("vsgDisabled");
          }
        });
      },
      change: function() {
        var row = $(this.select());
        row.removeClass("k-state-selected");
        row.find("input[id^=dp_]").trigger("click");
      },
      selectable: "row",
      noRecords: {
        template: "<span class=\"hcu-secondary\"><span class=\"vsgSecondary\">No Records Found</span></span>"
      },
      columns: [
        { field: "aDelete", width: "25px",
          template: "<input type=\"checkbox\" style=\"margin-top:-2px;\" id=\"dp_#=aType#\"/>",
          headerTemplate: "<input type=\"checkbox\" style=\"margin-top: -2px;\" id=\"dp_DFT\"/>" },
        { field: "aType", title: "Account", width: "150px" },
        { field: "aDesc", title: "Description",
          template: "#if(aDesc){# <span>#=aDesc#</span> #}else{# <span>(no description)</span> #}#" }
      ]
    }).data("kendoGrid");

    mdGridLoan = $("#mdGridLoan").kendoGrid({
      dataSource: {
        data: []
      },
      dataBound: function() {
        $("#mdGridLoan input[id^=ln_]").off();
        $("#mdGridLoan input[id^=ln_]").on("change", EventCheckBoxChange);
        $(this.tbody).find("tr").each(function(i) {
          var rowData = mdGridLoan.dataItem(this);
          var rowColumns = $(this).find("td");

          $(this).css("cursor", "pointer");
          $(this).css("background", "transparent");

          if (rowData.aCount == 0) {
            $(rowColumns[0]).find("input").attr("disabled", true);
            $(rowColumns[0]).addClass("vsgDisabled");
            $(rowColumns[1]).addClass("vsgDisabled");
            $(rowColumns[2]).addClass("vsgDisabled");
            $(rowColumns[3]).addClass("vsgDisabled");
          }
        });
      },
      change: function() {
        var row = $(this.select());
        row.removeClass("k-state-selected");
        row.find("input[id^=ln_]").trigger("click");
      },
      selectable: "row",
      noRecords: {
        template: "<span class=\"hcu-secondary\"><span class=\"vsgSecondary\">No Records Found</span></span>"
      },
      columns: [
        { field: "aDelete", width: "25px",
          template: "<input type=\"checkbox\" style=\"margin-top:-2px;\" id=\"ln_#=aType#\"/>",
          headerTemplate: "<input type=\"checkbox\" style=\"margin-top: -2px;\" id=\"ln_DFT\"/>" },
        { field: "aType", title: "Account", width: "150px" },
        { field: "aDesc", title: "Description",
          template: "#if(aDesc){# <span>#=aDesc#</span> #}else{# <span>(no description)</span> #}#" }
      ]
    }).data("kendoGrid");

    mdTooltip = homecuTooltip.defaults;
    mdTooltip.filter = ".vsgDisabled";
    mdTooltip.content = "This sub-account has no transaction history";
    $("#mdGridDeposit").kendoTooltip(mdTooltip);
    $("#mdGridLoan").kendoTooltip(mdTooltip);

    mdConfirm = $("#mdConfirm").kendoDialog({
      title: "Confirm Delete",
      minWidth: 300,
      maxWidth: 900,
      visible: false,
      resizable: false,
      show: EventOpenWindow,
      close: EventCloseWindow,
      actions: [
        { text: "No",
          action: function() { mdAction = "deleteDeny"; }
        },
        { text: "Yes", primary: true,
          action: function() { mdAction = "deleteConfirm"; }
        }
      ]
    }).data("kendoDialog");

    mdCancel = $("#lnkCancel");
    mdDelete = $("#btnUpdate");
    mdStatus = $("#mdStatus");
    mdStatus.hide();
  }

  var InitDataActions = function() {
    mdCancel.off();
    mdCancel.on("click", function() { mdAction = "historyCancel"; mdHistory.close(); });
    mdDelete.off();
    mdDelete.on("click", function() { mdAction = "historyDelete"; mdHistory.close(); });
  }

  this.Data = function(message, member) {
    mdPayload = message;
    mdMember = member;
  }

  this.Open = function(windowStack) {
    // setup validator
    $.homecuValidator.setup({
      formStatusField: "status",
    });

    mdCardWindows = windowStack;
    var memberRequest = {
      operation: "memberReadHistory",
      payload: mdPayload
    };

    mdDataSource.transport.options.read.type = "POST";
    mdDataSource.read(memberRequest);
  }

  this.Close = function() {
    mdHistory.destroy();
    mdConfirm.destroy();
  }

  this.Init = function(hubCall, cardContainer) {
    mdCall = hubCall;
    mdCardContainer = cardContainer;

    InitDataSources();
    InitDataViews();
    InitDataActions();

    mdCall("MemberDelete", this);
  }
}
</script>
<?php }