aPromoList.prg

<?php
/**
 *  @package  UserFlags
 *  @author   MGHandy
 *
 *  @uses view list of credit union pop-up/promotions, reset promotions flag for
 *  all users for the creditu union, suppress promotions for specified users
 *  in the credit union.
 *
 *  @param operation  string  operation to perform
 *  @param promos     json    json array of promo document ids to reset
 *  @param accounts   json    json array of account number to suppress promos
 *
 *  @return aryReply  json    updated data set
 */
try {
  $admVars = array();
  $admOk = array(
    "operation" => array("filter" => FILTER_SANITIZE_STRING),
    "promos" => array("filter" => FILTER_SANITIZE_STRING),
    "accounts" => array("filter" => FILTER_SANITIZE_STRING)
  );
  HCU_ImportVars($admVars, "USERFLAGS", $admOk);

  $pOperation = isset($admVars['USERFLAGS']['operation']) ? $admVars['USERFLAGS']['operation'] : null;
  $pPromo = isset($admVars['USERFLAGS']['promos']) ? $admVars['USERFLAGS']['promos'] : null;
  $pAccounts = isset($admVars['USERFLAGS']['accounts']) ? $admVars['USERFLAGS']['accounts'] : null;

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

  switch ($pOperation) {
    case "":
      PrintPromoListContent();
      PromoRead($SYSENV, $dbh, $Cu);
      break;
    case "promoRead":
      header('Content-type: application/json');

      $rPromoList = PromoRead($SYSENV, $dbh, $Cu);
      if (HCU_array_key_exists("error", $rPromoList)) {
        $aryResult['error'] = $rPromoList['error'];
      } else {
        $aryResult['data']['promos'] = $rPromoList['promos'];
      }

      PromoReply($aryResult, $aryReply, $pOperation);
      break;
    case "promoReset":
      header('Content-type: application/json');

      $rPromoReset = PromoReset($SYSENV, $dbh, $Cu, $pPromo);
      if (HCU_array_key_exists("error", $rPromoReset)) {
        $aryResult['error'] = $rPromoReset['error'];
      } else {
        $aryResult['info'] = $rPromoReset['info'];
      }

      $rPromoList = PromoRead($SYSENV, $dbh, $Cu);
      if (HCU_array_key_exists("error", $rPromoList)) {
        $aryResult['error'] = $rPromoList['error'];
      } else {
        $aryResult['data']['promos'] = $rPromoList['promos'];
      }

      PromoReply($aryResult, $aryReply, $pOperation);
      break;
    case "promoSuppress":
      header('Content-type: application/json');

      $rAccountSet = PromoSuppress($SYSENV, $dbh, $Cu, $pAccounts);
      if (HCU_array_key_exists("error", $rAccountSet)) {
        $aryResult['error'] = $rAccountSet['error'];
      } else{
        $aryResult['info'] = $rAccountSet['info'];
      }

      $rPromoList = PromoRead($SYSENV, $dbh, $Cu);
      if (HCU_array_key_exists("error", $rPromoList)) {
        $aryResult['error'] = $rPromoList['error'];
      } else {
        $aryResult['data']['promos'] = $rPromoList['promos'];
      }

      PromoReply($aryResult, $aryReply, $pOperation);
      break;
    default:
      throw new Exception("Unknown server request: " . $pOperation);
      break;
  }

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

  PromoReply($aryResult, $aryReply, $pOperation);
}

/**
 * function GetTypeMap()
 * @return map of what is saved in the database and the display text.
 */
function GetTypeMap() {
  return array("N" => "None", "T" => "Terms of Use", "D" => "Notice/Disclaimer", "A" => "Promo/All Members", "E" => "Promo/No eStatements", "P" => "Promo/Persistent");
}

/**
 *  PromoReply
 *  @uses   return json data to client via ajax
 *
 *  @param  pResult     array   array of updated data/info or errors
 *  @param  pReply      array   array of necessary data returning to client
 *  @param  pOperation  string  operation performed on the server
 *
 *  @return pReply      json   json encoded data
 */
function PromoReply($pResult, $pReply, $pOperation) {
  $pReply['operation'] = $pOperation;
  if (isset($pResult['error']) && count($pResult['error'])) $pReply['error'] = $pResult['error'];
  if (isset($pResult['data']) && count($pResult['data'])) $pReply['data'] = $pResult['data'];
  if (isset($pResult['info']) && count($pResult['info'])) $pReply['info'] = $pResult['info'];

  print HCU_JsonEncode(array("Results" => $pReply));
}

/**
 *  PromoRead
 *  @uses   read list of pop-up promotions for the credit union
 *  and the number of users using each promotion.
 *
 *  @param  pEnv        array   environment variable
 *  @param  pDbh        array   database access
 *  @param  pCu         string  credit union code
 *
 *  @return sqlReturn   array   promotion list
 */
function PromoRead($pEnv, $pDbh, $pCu) {
  $sqlReturn = array();
  $sqlColumns = "
    d.docsid AS did,
    d.docsname AS dname,
    d.docstitle AS dtitle,
    d.docsdesc AS ddesc,
    d.docsresponsetype AS dresponse";
  $sqlSub = "
    SELECT COUNT(*)
    FROM cucmsresponse r
    WHERE r.docsid = d.docsid
      AND r.cu = '{$pCu}'
      AND r.responseon IS NOT NULL";
  $sqlSelect = "
    SELECT $sqlColumns, ($sqlSub) AS dcount
    FROM cucmsdocs d
    LEFT JOIN cucmsfrags f
      ON f.docsid = d.docsid
      AND f.cu = '{$pCu}'
    WHERE d.docsresponsetype IN ('D', 'A', 'E', 'P', 'T')
    ORDER BY array_position(array['D', 'A', 'E', 'P', 'T'], d.docsresponsetype::text), d.docsdesc";

  $sqlSelectRs = db_query($sqlSelect, $pDbh);
  if (!$sqlSelectRs) {
    $pEnv['logger']->error(db_last_error());
    $sqlReturn['error'][] = "Failed to read promos list.";
    return $sqlReturn;
  }

  $promos = db_fetch_all($sqlSelectRs);
  $promos = $promos === false ? array() : $promos;

  for($i = 0, $count = count($promos); $i != $count; $i++) {
    $type = trim($promos[$i]["dresponse"]);
    $typeText = HCU_array_key_value($type, GetTypeMap());
    $typeText = $typeText === false ? "" : $typeText;
    $promos[$i]["typeText"] = $typeText;
  }

  $sqlReturn['promos'] = $promos;
  return $sqlReturn;
}

/**
 *  PromoReset
 *  @uses   reset a the promo flag for a given list of promos
 *  for each user in the credit union.
 *
 *  @param  pEnv        array   environment variable
 *  @param  pDbh        array   database access
 *  @param  pCu         string  credit union code
 *  @param  pPromo     string  list of promos to reset
 *
 *  @return sqlReturn   array   information/updated data
 */
function PromoReset($pEnv, $pDbh, $pCu, $pPromo) {
  // decode html codes
  // replace square brackets with empty
  // replace double quotes with single quotes
  $promos = html_entity_decode($pPromo, ENT_QUOTES);
  $promos = str_replace(array('[', ']'), "", $promos);
  $promos = str_replace('"', "'", $promos);

  $sqlReturn = array();
  $sqlUpdate = "
    UPDATE cucmsresponse
    SET responseon = NULL
    WHERE cu = '{$pCu}'
      AND docsid IN ($promos)";
  $sqlUpdateRs = db_query($sqlUpdate, $pDbh);
  if (!$sqlUpdateRs) {
    $pEnv['logger']->error(db_last_error());
    $sqlReturn['error'][] = "Failed to reset selected promos.";
    return $sqlReturn;
  }

  $sqlReturn['info'][] = "Reset was successful.";
  $sqlReturn['promos'] = db_fetch_all($sqlUpdateRs);
  return $sqlReturn;
}

/**
 *  PromoSuppress
 *  @uses   suppress pop-up promos for a given list of users
 *  in the credit union.
 *
 *  @param  pEnv        array   environment variable
 *  @param  pDbh        array   database access
 *  @param  pCu         string  credit union code
 *  @param  pPromo     string  list of user accounts to suppress
 *
 *  @return sqlReturn   array   information/updated data
 */
function PromoSuppress($pEnv, $pDbh, $pCu, $pAccounts) {
  // decode html codes
  // replace square brackets with empty
  // replace double quotes with single quotes
  $accountsList = html_entity_decode($pAccounts, ENT_QUOTES);
  $accountsList = HCU_JsonDecode($accountsList);
  foreach ($accountsList as $key => $value) {
    $accountsList[$key] = trim($value);
  }
  $accounts = HCU_JsonEncode($accountsList);
  $accounts = str_replace(array('[', ']'), "", $accounts);
  $accounts = str_replace('"', "'", $accounts);

  $users = array();
  $accts = array();
  $docs = array();

  $sqlReturn = array();

  // check if user accounts exist
  $sql = "select distinct u.user_id, uc.accountnumber from {$pCu}user u
    inner join {$pCu}useraccounts uc on u.user_id = uc.user_id
    where uc.accountnumber in ($accounts)";
  $sqlRs = db_query($sql, $pDbh);
  if (!$sqlRs) {
    $pEnv['logger']->error(db_last_error());
    $sqlReturn['error'][] = "Failed to read user accounts.";
    return $sqlReturn;
  }
  $users = db_fetch_all($sqlRs);
  foreach ($accountsList as $key => $value) {
    $acct = trim($value);
    $found = false;

    $i = 0;
    while ($row = db_fetch_assoc($sqlRs, $i)) {
      $prim = trim($row['accountnumber']);
      if ($prim == $acct) {
        $found = true;
        break;
      }
      $i ++;
    }

    if (!$found) {
      $sqlReturn["error"][] = "Account number: $acct does not exist";
    }
  }

  if (HCU_array_key_exists("error", $sqlReturn)) {
    return $sqlReturn;
  }

  // check if any persistent promos exist
  $sqlColumns = "
    d.docsid";
  $sql = "
    SELECT $sqlColumns
    FROM cucmsdocs d
    LEFT JOIN cucmsfrags f
      ON f.docsid = d.docsid
      AND f.cu = '{$pCu}'
    WHERE d.docsresponsetype = 'P'";
  $sqlRs = db_query($sql, $pDbh);
  if (!$sqlRs) {
    $pEnv['logger']->error(db_last_error());
    $sqlReturn['error'][] = "Failed to read promos list.";
    return $sqlReturn;
  }
  $docs = db_fetch_all($sqlRs);
  if (db_num_rows($sqlRs) == 0) {
    $sqlReturn['error'][] = "No persistent promos currently exist.";
    return $sqlReturn;
  }

  // update tables
  $cu = prep_save($pCu);

  // multiple users can have the same primary account
  // this array is used to determine if the primary
  // account has already been suppressed.
  $sqlSuccess = array();
  for ($i = 0; $i < count($users); $i++) {
    $userId = intval($users[$i]['user_id']);
    $userAccount = prep_save($users[$i]['accountnumber']);
    $userFailed = false;

    for ($j = 0; $j < count($docs); $j++) {
      $docId = intval($docs[$j]['docsid']);

      $sqlColumns = "
        docsid, cu, accountnumber, responseon, user_id";
      $sqlValues = "
        $docId, '{$cu}', '$userAccount', current_date, $userId";
      $sql = "
        INSERT INTO cucmsresponse
        ($sqlColumns)
          (SELECT $sqlValues
          WHERE NOT EXISTS
            (SELECT $sqlColumns
            FROM cucmsresponse r
            WHERE r.docsid = $docId
              AND r.accountnumber = '$userAccount'
              AND r.cu = '{$cu}'))";

      $sqlRs = db_query($sql, $pDbh);
      if (!$sqlRs) {
        $pEnv['logger']->error(db_last_error());
        $userFailed = true;
      }

      if (db_affected_rows($sqlRs) == 0) {
        $sql = "
        UPDATE cucmsresponse
        SET responseon = current_date
        WHERE docsid = $docId
          AND user_id = $userId
          AND cu = '{$cu}'";
        $sqlRs = db_query($sql, $pDbh);
        if (!$sqlRs) {
          $pEnv['logger']->error(db_last_error());
          $userFailed = true;
        }
      }
    }

    if ($userFailed) {
      $sqlReturn['error'][] = "User account: $userAccount could not be excluded.";
    } else {
      if (!in_array($userAccount, $sqlSuccess)) {
        $sqlSuccess[] = $userAccount;
        $sqlReturn['info'][] = "User account: $userAccount excluded successfully.";
      }
    }
  }

  return $sqlReturn;
}
?>

<?php
/**
 *  PrintPromoListContent
 *  @uses   print all styles, html and javascript needed to
 *  display and interact with the page.
 */
?>
<?php function PrintPromoListContent() { ?>
<style type="text/css">
  .k-grid tbody tr,
  .k-grid tbody tr input[type="checkbox"],
  .k-grid thead tr input[type="checkbox"] {
    cursor: pointer;
  }
</style>

<div class="col-sm-12">
  <div class="well well-sm col-sm-12">
    <h2>Reset Pop-Ups and Promos</h2>

    <div class="hcu-secondary">
      <div class="vsgSecondary">
        <p>By default, Pop-up messages and User-Dismissible Login Promos are shown to all users. Users may dismiss the message or promo by specifying "Don't Tell Me Again".</p>
        <p>When you reset these flags, all users will see the related message or promo again, even if they previously checked "Don't Tell Me Again".</p>
      </div>
      <div class="small vsgSecondary">
        <span>Disabled rows indicate a pop-up message or promo that is not currently dismissed for any users.</span>
      </div>
    </div>

    <div class="" id="rfTable"></div>
    <div class="" style="margin-top: 7.5px; margin-bottom: 7.5px;">
      <button class="k-button k-primary" id="rfBtnReset">Reset Flags</button>
    </div>
  </div>

  <div class="well well-sm col-sm-12">
    <h3>Exclude From CU-Dismissible Login Promo</h3>
    <div class="hcu-secondary">
      <div class="vsgSecondary">
        <p>By default, the CU-Dismissible Login Promo is shown to all users. If you wish to exclude certain users from this promo, use the box below to enter their accounts. </p>
        <p>Insert the account numbers into this entry field, separated by a space or new line. <br>If the record does not exist or cannot be updated, an error will be displayed.</p>
      </div>
    </div>

    <div class="" >
      <textarea class="k-textbox hcu-all-100" id="rfExclude" rows="3"></textarea>
    </div>
    <div class="" style="margin-top: 7.5px; margin-bottom: 7.5px;">
      <button class="k-button k-primary" id="rfBtnSet">Set Flags</button>
    </div>

  </div>
</div>

<script type="text/javascript">
<?php getShowWaitFunctions(); ?>
  var rfDataSource = null;
  var rfTable = null;
  var rfTableData = null;
  var rfTooltip = null;

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

        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("error")) {
            hideWaitWindow();
            return [];
          }

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

          rfTableData = resultData.promos;
          rfTable.dataSource.data(rfTableData);

          return [];
        }
      }
    });
  }

  var InitDataViews = function() {
    rfTable = $("#rfTable").kendoGrid({
      autoBind: false,
      selectable: "row",
      dataSource: {
        data: []
      },
      noRecords: {
        template: "<span class=\"hcu-secondary\"><span class=\"vsgSecondary\">No Records Found</span></span>"
      },
      columns: [
        { title: "", width: "35px",
          template: "<input type=\"checkbox\" id=\"#=did#\" name=\"resetCheck\">",
          headerTemplate: "<input type=\"checkbox\" id=\"0\" name=\"resetCheck\">" },
        { field: "ddesc", title: "Description",
          attributes: { "class": "showEllipsis" } },
        { field: "typeText", title: "Type" , width: "200px", attributes: { "class": "hidden-xs" }, headerAttributes: { "class": "hidden-xs" } },
        { field: "dcount", title: "User Count", width: "100px" }
      ],
      change: function(e) {
        var row = this.select();
        var rowBox = row.find("input[type=\"checkbox\"]");
        rowBox.trigger("click");

        $(this.select()).removeClass('k-state-selected');
      },
      dataBound: function(e) {

        <?php // Also need to hide the col in the colgroup.  Otherwise, it wouldn't be hidden. ?>
        $("#rfTable colgroup").each(function() {
          $(this).find("col:eq(2)").addClass("hidden-xs");
        });

        // disable checkboxes if count is 0
        $("#rfTable tbody tr").each(function() {
          var dataItem = rfTable.dataItem(this);
          var count = dataItem.dcount;
          if (count == 0) {
            $(this).addClass("vsgDisabled");
            $(this).find("input[type=\"checkbox\"]").prop("disabled", true);
          }
        });

        // reset check all checkbox
        $("#rfTable input[id=\"0\"]").prop("checked", false);

        // add checkbox event
        $("#rfTable input[type=\"checkbox\"]").off();
        $("#rfTable input[type=\"checkbox\"]").on("click", function() {
          // if id = 0, select or deselect all other checkboxes
          // else, if all other boxes are checked, check the select all box
          var id = $(this).attr("id");
          var checked = $(this).prop("checked");


          if (id == 0) {
            $("#rfTable input[id!=\"0\"]:not(:disabled)").prop("checked", checked);
          } else {
            var disabled = $("#rfTable input[id!=\"0\"]:disabled");
            var enabled = $("#rfTable input[id!=\"0\"]:not(disabled)");
            var checked = $("#rfTable input[id!=\"0\"]:checked:not(disabled)");

            // must account for difference in having disabled checkboxes
            // length of grid data will be greater the the number of
            // enabled checkboxes if any are disabled.
            if (checked.length == rfTableData.length - disabled.length) {
              $("#rfTable input[id=\"0\"]").prop("checked", true);
            } else {
              $("#rfTable input[id=\"0\"]").prop("checked", false);
            }
          }
        });
      }
    }).data("kendoGrid");

    $("#rfBtnReset").on("click", function() {
      var boxes = $("#rfTable input:checked[id!=\"0\"]");
      var count = boxes.length;
      var grid = $("#rfTable").data("kendoGrid");
      var tosDisclosures = 0;
      var hasSignupDisclosure = false;

      if (count > 0) {
        var ids = [];
        boxes.each(function() {
          var row = $(this).closest("tr");
          var dataItem = grid.dataItem($(row));
          ids.push(dataItem.did);
          if (dataItem.dresponse == "T") {
            tosDisclosures++;
          }
          hasSignupDisclosure = hasSignupDisclosure || dataItem.dname == "signupDisclosure";
        });

        if (tosDisclosures > 0 || hasSignupDisclosure) {

          var message = "";

          if (tosDisclosures > 0) {
            var thisOrThese = count == 1 ? "this" : "these";
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
            message += "Be aware that resetting " + thisOrThese + " Terms of Use will erase all previous dates of acceptance by users.";
            message += "</div></div>";
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
            message += "Before resetting " + thisOrThese + " Terms of Use, HomeCU recommends that you download and retain the current \"Terms Accepted\" report in your admin site under ";
            message += "<a href='main.prg?ft=41&report=termsAccepted'>Reports &gt; User Settings Reports</a>.";
            message += "</div></div>";
          }

          if (hasSignupDisclosure) {
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>&nbsp;</div></div>";
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
            message += "Resetting the <b>Digital Banking Disclosure</b> will not show this disclosure to the user on their next login.  ";
            message += "To show users an updated disclosure we recommend using a marketing message with a link to the new disclosure.";
            message += "</div></div>";
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
            message += "To set up a marketing message in your admin site, go to "
            message += "<a href='main.prg?ft=37&page=edit'>Member Communications &gt; Marketing Messages &gt; New Marketing Message</a>.";
            message += "</div></div>";
            message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
            message += "If you have questions on setting on a marketing message, please contact HomeCU support for assistance.";
            message += "</div></div>";
          }

          message += "<div class='row'><div class='col-xs-12 hcuSpacer'>&nbsp;</div></div>";
          message += "<div class='row'><div class='col-xs-12 hcuSpacer'>";
          message += "Do you want to continue?";
          message += "</div></div>";

          var tosDialog = $("#tosDialog").data("kendoDialog");
          if (!tosDialog) {
            tosDialog = $("<div id='tosDialog'></div>").appendTo("body").kendoDialog({
              title: "Warning",
              maxWidth: 800,
              actions: [
                {text: "Cancel"},
                {text: "Confirm Reset", primary: true, action: function() {
                  var ids = $("#tosDialog").data("ids");
                  rfDataSource.transport.options.read.type = "POST";
                  rfDataSource.read({
                    operation: "promoReset",
                    promos: JSON.stringify(ids)
                  });
                }}
              ],
              visible: false
            }).data("kendoDialog");
          }

          $("#tosDialog").data("ids", ids);
          tosDialog.content(message).open();
        } else {
          rfDataSource.transport.options.read.type = "POST";
          rfDataSource.read({
            operation: "promoReset",
            promos: JSON.stringify(ids)
          });
        }

      }
    });

    $("#rfBtnSet").on("click", function() {
      var input = $("#rfExclude");
      var text = input.val();
      text = text.trim();

      if (text.trim().length > 0) {
        var accts = text.split(/\s+/);

        rfDataSource.transport.options.read.type = "POST";
        rfDataSource.read({
          operation: "promoSuppress",
          accounts: JSON.stringify(accts)
        });
      }
    });

    // USE THIS TO SELECT OVERFLOW IN JQUERY SELECTORS FOR TOOLTIP BELOW
    jQuery.extend(jQuery.expr[':'], {
      overflown: function (el) {
        return el.offsetHeight < el.scrollHeight || el.offsetWidth < el.scrollWidth;
      }
    });

    rfTooltip = homecuTooltip.defaults;
    rfTooltip.filter = ".showEllipsis:overflown";
    rfTooltip.content = function(e) {
      return $(e.target).text().trim();
    }
    $("#rfTable").kendoTooltip(rfTooltip);
  }

  $(document).ready(function() {
    InitDataSources();
    InitDataViews();

    rfDataSource.transport.options.read.type = "POST";
    rfDataSource.read({
      operation: "promoRead"
    });
  });
</script>
<?php }