1#@!#!123s

: / home / ksclnmuac / public_html / cas / application / models / admin /
Filename : MenuManagement.php
back
<?php

/**
 * Model For Handling All DB Operations Related To Menus (Operation Groups)/Sub-menus (Operations)
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class MenuManagement extends CI_Model {

    function createNewOperationGroup($newOperationGroupInfo) {
        $this->db->insert('tbl_operation_group_new', $newOperationGroupInfo);
        return $this->db->insert_id();
    }

    function getAllOperationGroups() {
        $this->db->select("TOG.group_id,TOG.group_name,TOG.group_title,TOG.group_tooltip,TOG.group_icon,"
                . "TOG.group_slug_url,TOG.group_delete_status,TOG.group_active_status,"
                . "TOG.group_added_by,TOG.group_added_on,TOG.group_updated_by,TOG.group_updated_on,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('tbl_operation_group_new TOG');
        $this->db->join('tbl_staff_members TSMA', 'TOG.group_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'TOG.group_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->order_by("TOG.group_updated_on", "desc");
        return $this->db->get();
    }

    function getNonDeletedOperationGroups() {
        $this->db->select('*');
        $this->db->from('tbl_operation_group_new');
        $this->db->where('group_delete_status', "F");
        return $this->db->get();
    }

    function getNonDeletedActiveOperationGroups() {
        $this->db->select('*');
        $this->db->from('tbl_operation_group_new');
        $this->db->where('group_active_status', "T");
        $this->db->where('group_delete_status', "F");
        $this->db->order_by("group_name", "ASC");
        return $this->db->get();
    }

    function getOperationGroupInfoBy($group_id) {
        $this->db->select('*');
        $this->db->from('tbl_operation_group_new');
        $this->db->where('group_id', $group_id);
        return $this->db->get();
    }

    function getOperationGroupByName($group_name) {
        $this->db->select('*');
        $this->db->from('tbl_operation_group_new');
        $this->db->where('group_name', $group_name);
        return $this->db->get();
    }

    function isOperationGroupNameSafeUpdate($group_id, $group_name) {
        $this->db->select("*");
        $this->db->from('tbl_operation_group_new');
        $this->db->where('group_name', $group_name);
        $this->db->where('group_id != ' . $group_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return FALSE;
        } else {
            return TRUE;
        }
    }

    function getAllAssignedMainMenusByStaffMemeberId($smemberId) {
        $sql = "SELECT DISTINCT(TOG.group_name)main_menu_name,TUGF.ugfiles, TUGF.oprtn_id,TUGF.group_id,TOG.group_title,"
                . "TOG.group_tooltip,TOG.group_icon,TOG.group_slug_url FROM tbl_user_group_files TUGF, tbl_operation_group_new TOG WHERE "
                . "TUGF.smember_id = " . $smemberId . " AND TUGF.group_id = TOG.group_id AND TOG.group_active_status = 'T' "
                . "AND TOG.group_delete_status = 'F' GROUP BY TOG.group_name ORDER BY TOG.group_name ASC";
        return $this->db->query($sql);
    }

    function updateOperationGroupInfo(array $operationGroupUpdatedInfo) {
        $this->db->where('group_id', $operationGroupUpdatedInfo['group_id']);
        return $this->db->update('tbl_operation_group_new', $operationGroupUpdatedInfo);
    }

    /* Functions For Operations */

    function createNewOperation($newOperationInfo) {
        $this->db->insert('tbl_operations_new', $newOperationInfo);
        return $this->db->insert_id();
    }

    function getAllOperations() {
        $this->db->select("TOP.oprtn_id,TOP.oprtn_name,TOP.oprtn_title,TOP.oprtn_tooltip,TOP.oprtn_slug_url,TOP.oprtn_active_status,"
                . "TOP.oprtn_delete_status,TOP.oprtn_added_on,TOP.oprtn_updated_on,TOP.oprtn_hidden_status,"
                . "TOP.oprtn_added_by,TOP.oprtn_updated_by,TOG.group_name,TOG.group_icon,"
                . "CONCAT(TPRFLA.tprfl_firstname,' ',TPRFLA.tprfl_lastname) addedByAdmin,"
                . "CONCAT(TPRFLU.tprfl_firstname,' ',TPRFLU.tprfl_lastname) updatedByAdmin");
        $this->db->from('tbl_operations_new TOP');
        $this->db->join('tbl_operation_group_new TOG', 'TOP.group_id = TOG.group_id');
        $this->db->join('tbl_staff_members TSMA', 'TOP.oprtn_added_by = TSMA.smember_id');
        $this->db->join('tbl_profile TPRFLA', 'TSMA.smember_id = TPRFLA.tprfl_id');
        $this->db->join('tbl_staff_members TSMU', 'TOP.oprtn_updated_by = TSMU.smember_id');
        $this->db->join('tbl_profile TPRFLU', 'TSMU.smember_id = TPRFLU.tprfl_id');
        $this->db->order_by("TOP.oprtn_updated_on", "desc");
        return $this->db->get();
    }

    function getAllActiveNonDeletedOperationsUnderGroup($group_id) {
        $this->db->select('*');
        $this->db->from('tbl_operations_new');
        $this->db->where('oprtn_active_status', "T");
        $this->db->where('oprtn_delete_status', "F");
        $this->db->where('group_id', $group_id);
        $this->db->order_by("oprtn_name", "ASC");
        return $this->db->get();
    }

    function getOperationInfoBy($oprtn_id) {
        $this->db->select('*');
        $this->db->from('tbl_operations_new');
        $this->db->where('oprtn_id', $oprtn_id);
        return $this->db->get();
    }

    function getOperationByName($oprtn_name) {
        $this->db->select('*');
        $this->db->from('tbl_operations_new');
        $this->db->where('oprtn_name', $oprtn_name);
        return $this->db->get();
    }

    function isOperationNameSafeUpdate($oprtn_id, $oprtn_name) {
        $this->db->select("*");
        $this->db->from('tbl_operations_new');
        $this->db->where('oprtn_name', $oprtn_name);
        $this->db->where('oprtn_id != ' . $oprtn_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return FALSE;
        } else {
            return TRUE;
        }
    }

    function getAllAssignedSubMenusBy($group_id, $smemberId) {
        $sql = "SELECT TOP.oprtn_id, TOP.oprtn_name, TOP.oprtn_title, TOP.oprtn_tooltip, TOP.oprtn_slug_url, "
                . "TOP.oprtn_hidden_status FROM tbl_operations_new TOP, tbl_user_group_files TUGF WHERE TOP.oprtn_id = TUGF.oprtn_id "
                . "AND TOP.group_id = " . $group_id . " AND TUGF.smember_id = " . $smemberId . " AND TOP.oprtn_active_status = 'T' "
                . "AND TOP.oprtn_delete_status = 'F' ORDER BY TOP.oprtn_name ASC";
        return $this->db->query($sql);
    }

    function updateOperationInfo(array $operationUpdatedInfo) {
        $this->db->where('oprtn_id', $operationUpdatedInfo['oprtn_id']);
        return $this->db->update('tbl_operations_new', $operationUpdatedInfo);
    }

    /* Functions For Operations */

    /* Function For User Group Files */

    function isOperationGroupAssigned($group_id, $smember_id) {
        $this->db->select("*");
        $this->db->from('tbl_user_group_files');
        $this->db->where('group_id', $group_id);
        $this->db->where('smember_id', $smember_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return true;
        } else {
            return false;
        }
    }

    function isOperationAssigned($oprtn_id, $smember_id) {
        $this->db->select("*");
        $this->db->from('tbl_user_group_files');
        $this->db->where('oprtn_id', $oprtn_id);
        $this->db->where('smember_id', $smember_id);
        $result = $this->db->get()->result();
        if (sizeof($result)) {
            return true;
        } else {
            return false;
        }
    }
    
    function createNewUserGroupFilesRecordsMulti(array $newUserGroupFilesRecordsBatch) {
        $this->db->insert_batch('tbl_user_group_files', $newUserGroupFilesRecordsBatch);
        return $this->db->insert_id();
    }
    
    function deleteUserGroupFilesRecordsBy($smemberId) {
        $this->db->where("smember_id", $smemberId);
        $this->db->delete("tbl_user_group_files");
    }

    /* Function For User Group Files */
}