aGroupDelete.prg

<?php
/**
 *  @package GroupHub
 *  @author MGHandy
 *
 *  @uses admin group delete
 *    * delete orphaned groups
 *    * delete users from group by going to user hub
 *
 *  @var string $sOperation: requested search action
 */

require_once("$admLibrary/aGroupSupport.i");

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

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

  // decrypt payload only if there is one
  // payload won't exist if operation is empty
  // operation empty means just load card content
  $dGroup = $dPayload ?
    GroupDecrypt($SYSENV, $Cu, $dPayload) :
    null;

  // load context depending on payload existence.
  $dContext = $dPayload ?
    GroupContext($SYSENV, $Cu, $dGroup['group']) :
    GroupContext($SYSENV, $Cu);

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

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

      $gDelete = GroupDelete($SYSENV, $dbh, $dContext);
      $aryResult['data']['group'] = $gDelete['group'];
      $aryResult['info'] = $gDelete['message'];
      GroupReply($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();

  GroupReply($aryResult, $aryReply, $dOperation);
}

function GroupDelete($pEnv, $pDbh, $pContext) {
  $gId = $pContext['g_id'];
  $pId = $pContext['p_id'];
  $cuTable = $pContext['cu_table'];
  $cuCode = $pContext['cu_code'];

  $sqlReturn = array();
  $sqlDelete = "
    DELETE FROM {$cuTable}group
    WHERE group_id = $gId
      AND profile_id = $pId
    RETURNING
      group_id AS g_id,
      profile_id AS p_id,
      group_name AS g_name";

  $sqlDeleteRs = db_query($sqlDelete, $pDbh);
  if (!$sqlDeleteRs) {
    $pEnv['logger']->error(db_last_error());
    throw new Exception("Failed to delete group.");
  }

  $sqlReturn['group'] = db_fetch_all($sqlDeleteRs)[0];
  $sqlReturn['message'] = "The following group has been deleted successfully:";
  return $sqlReturn;
}
?>

<?php function PrintGroupDelete() { ?>
<div id="gdDelete">
  <div class="hcu-template">
    <div class="hcu-edit-buttons k-state-default">
      <span class="hcu-icon-delete">
        <!--<a href="##" id="lnkDelete">
          <i class="fa fa-trash fa-lg"></i>
        </a>-->
      </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="gdInfo"></div>

<script type="text/x-kendo-template" id="gdOrphaned">
  <div class="col-sm-12">
    <p>You are about to remove this group from the system.</p>
    <p>Do you wish to continue?</p>
  </div>
</script>

<script type="text/x-kendo-template" id="gdFull">
  <div class="col-sm-12">
    <p>There are existing users in this group.</p>
    <p>Groups cannot be deleted if there are users.
    Use the Group Users card to view which users
    are still using this group.</p>
  </div>
</script>

<script type="text/javascript">
  var GroupDelete = function() {
    var gdCardContainer = null;
    var gdCardWindows = null;

    var gdCall = null;
    var gdGroup = null;
    var gdPayload = null;
    var gdAction = null;

    var gdDataSource = null;
    var gdDelete = null;
    var gdInfo = null;

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

      switch (windowId) {

      }

      gdCardWindows.push(this);
    }

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

      switch (gdAction) {
        case "deleteConfirm":
          EventPopWindow(windowId);
          var groupRequest = {
            operation: "groupDelete",
            payload: gdPayload
          };

          gdDataSource.transport.options.read.type = "POST";
          gdDataSource.read(groupRequest);
          break;
        default:
          EventPopWindow(windowId);
          break;
      }

      gdAction = null;
    }

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

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

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

    var InitDataSources = function() {
      gdDataSource = new kendo.data.DataSource({
        transport: {
          read: {
            url: "main.prg",
            dataType: "json",
            contentType: "application/x-www-form-urlencoded",
            type: "GET",
            data: {
              ft: "102106"
            },
            cache: false
          }
        },
        schema: {
          parse: function(response) {
            var results = null;
            var resultData = null;
            var resultOperation = null;

            // check for valid response
            if (response.hasOwnProperty("Results")) {
              results = response.Results;
              resultData = results.data;
            } else {
              gdInfo.content("Error Parsing Server");
              gdInfo.open();
              return [];
            }

            // check for errors
            if (results.hasOwnProperty("errors")) {
              gdInfo.content(results.errors);
              gdInfo.open();
              return [];
            }

            // valid response and no errors, clear group hub and show message
            var content = "";
            content += "<p>" + results.info + "</p>";
            content += "<p></p>";
            content += "<p><strong>" + gdGroup.g_name + "</strong></p>";

            gdInfo.content(content);
            gdInfo.open();

            gdCall("removeGroupInfo");
            gdCall("updateGroupResults", []);

            return [];
          }
        }
      });
    }

    var InitDataViews = function() {
      gdDelete = $("#gdDelete").kendoWindow({
        title: "Delete Group",
        modal: true,
        visible: false,
        resizable: false,
        minWidth: 300,
        maxWidth: 500,
        activate: EventOpenWindow,
        close: EventCloseWindow
      }).data("kendoWindow");

      gdInfo = $("#gdInfo").kendoDialog({
        title: "Delete Group",
        modal: true,
        visible: false,
        resizable: false,
        minWidth: 300,
        maxWidth: 300,
        show: EventOpenWindow,
        close: EventCloseWindow,
        actions: [
          { text: "Ok", primary: true }
        ]
      }).data("kendoDialog");
    }

    var InitDataActions = function() {
      $("#btnUpdate").off();
      $("#btnUpdate").on("click", function(e) {
        e.preventDefault();
        if (gdGroup.g_count == 0) {
          gdAction = "deleteConfirm";
          gdDelete.close();
        }
      });

      $("#lnkCancel").off();
      $("#lnkCancel").on("click", function(e) {
        e.preventDefault();
        gdAction = "deleteDeny";
        gdDelete.close();
      })
    }

    this.Open = function(windowStack) {
      gdCardWindows = windowStack;

      if (gdGroup.g_count == 0) {
        $("#gdDelete").prepend(
          $("#gdOrphaned").html()
        );
      } else {
        $("#gdDelete").prepend(
          $("#gdFull").html()
        );
      }

      var template= kendo.template($("#titleTemplate").html());
      gdGroup.cardTitle= "Delete Group";
      gdDelete.title(template(gdGroup));
      gdDelete.center();
      gdDelete.open();
    }

    this.Close = function() {
      gdDelete.destroy();
    }

    this.Data = function(payload, group) {
      gdPayload = payload;
      gdGroup = group;
    }

    this.Init = function(hubCall, carContainer) {
      gdCall = hubCall;
      gdCardContainer = carContainer;

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

      gdCall("GroupDelete", this);
    }
  }
</script>
<?php }