Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u506365997

Directory:

/home/u506365997/domains/creativeink.in/public_html/smartschoolonline/application/models

Free Space:

2.92 TB

🔧 Quick Actions

✏️ Editing: Rolepermission_model.php

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Rolepermission_model extends CI_Model {

public function __construct() {
        parent::__construct();
    }

/**
     * This funtion takes id as a parameter and will fetch the record.
     * If id is not provided, then it will fetch all the records form the table.
     * @param int $id
     * @return mixed
     */
    public function getPermissionByRole($role_id) {
        $this->db->select('`roles_permissions`.*, permission_category.id as permission_category_id,permission_category.name as permission_category_name,permission_category.short_code as permission_category_code');
        $this->db->from('roles_permissions');

$this->db->join('permission_category', 'permission_category.id=roles_permissions.perm_cat_id');
        $this->db->where('roles_permissions.role_id', $role_id);
        $query = $this->db->get();
        return $query->result();
    }

public function getInsertBatch($insert_array, $role_id, $delete_array) {

$this->db->trans_start();
        $this->db->trans_strict(FALSE);
        if (!empty($insert_array)) {

$this->db->insert_batch('role_permissions', $insert_array);
        }

# Updating data
        if (!empty($delete_array)) {
            $this->db->where('role_id', $role_id);
            $this->db->where_in('permission_id', $delete_array);
            $this->db->delete('role_permissions');
        }
        $this->db->trans_complete();

if ($this->db->trans_status() === FALSE) {

$this->db->trans_rollback();
            return FALSE;
        } else {

$this->db->trans_commit();
            return TRUE;
        }
    }

public function getPermissionWithSelectedByRole($role_id) {
        $sql = "SELECT permissions.*, role_permissions.id as `role_permission_id`,IF(role_permissions.id IS NULL,0,1) AS role_permission_state FROM `permissions` LEFT JOIN role_permissions on permissions.id=role_permissions.permission_id and role_permissions.role_id =$role_id";

$query = $this->db->query($sql);
        return $query->result();
    }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Rolepermission_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation