Ontime/backendpanel/application/models/Profile_model.php

<?php

class Profile_model extends CI_model
{
    
    public function getRole()
    {
        return $this->db->get('admin_role')->result_array();
    }
    public function getRole1()
    {
        $this->db->select('admin_role.*');
        $this->db->from('admin_role');
        $this->db->where('admin_role.id != 1');
        return $this->db->get()->result_array();
    }
    public function tambahadmin($data)
    {
        $this->db->insert('admin', $data);
    }
    
    public function unblockuserbyid($id)
    {
        $this->db->set('status', 1);
        $this->db->where('id', $id);
        $this->db->update('admin');
    }
    public function blockuserbyid($id)
    {
        $this->db->set('status', 0);
        $this->db->where('id', $id);
        $this->db->update('admin');
    }
    public function getadmingedit($id)
    {
        $this->db->where('id', $id);
        return  $this->db->get('admin')->row_array();
    }
    public function ubahdataadmin($data)
    {
        $this->db->set('user_name', $data['user_name']);
        $this->db->set('nama',$data['nama']);
        $this->db->set('email', $data['email']);
        $this->db->set('image', $data['image']);
        $this->db->set('password', $data['password']);
        $this->db->where('id', $data['id']);
        $this->db->update('admin', $data);
    }

    public function hapus_pengguna($id)
    {
        $this->db->where('id', $id);
        $this->db->delete('admin');
    }
    public function getadmin()
    {
        
        $this->db->select('adm.*, ar.nama_role');
        $this->db->select('adm.*, rg.partner_region');
        $this->db->from('admin adm');
        $this->db->join('admin_role ar', 'ar.id = adm.admin_role', 'left');
        $this->db->join('partner_region rg', 'rg.id = adm.wilayah', 'left');
        // $this->db->where('amr.id_role', $data['admin_role']);
        return $this->db->get()->result_array();
        // return $this->db->get('admin')->result_array();
    }
    public function getadminRole()
    {
        return $this->db->get('admin_role')->result_array();
    }
    
     public function getRegion()
    {
        return $this->db->get('partner_region')->result_array();
    }
    public function tambahrole($data)
    {
        $this->db->insert('admin_role', $data);
    }

    public function getadminrolegedit($id)
    {
        $this->db->where('id', $id);
        return  $this->db->get('admin_role')->row_array();
    }

    public function editrole($data)
    {
        $this->db->set('nama_role', $data['nama_role']);
        $this->db->where('id', $data['id']);
        $this->db->update('admin_role', $data);
    }


    public function getadminRolePrivilage()
    {
        return $this->db->get('admin_privilage')->result_array();
    }
    
    public function getmenuSubPrifilage()
    {
        $url = 'Not';
        // $this->db->where('menu_utama',$url);
        // return  $this->db->get('admin_privilage')->row_array();
        $this->db->select('adm.id as id_adm_pri, adm.nama_fitur');
        $this->db->from('admin_privilage adm');
        $this->db->where('adm.url', $url);
        return $this->db->get()->result_array();
    }
    public function tambahprifilage($data)
    {
        $this->db->insert('admin_privilage', $data);
    }
    
    public function getadminPrifilagedit($id)
    {
        $this->db->where('id', $id);
        return  $this->db->get('admin_privilage')->row_array();
    }
    
    public function editprifilage($data)
    {
        $this->db->set('url', $data['url']);
        $this->db->set('nama_fitur', $data['nama_fitur']);
        $this->db->where('id', $data['id']);
        $this->db->update('admin_privilage', $data);
    }
    public function editprifilageSub($data)
    {
        $this->db->set('foregn', $data['foregn']);
        $this->db->set('url', $data['url']);
        $this->db->set('nama_fitur', $data['nama_fitur']);
        $this->db->where('id', $data['id']);
        $this->db->update('admin_privilage', $data);
    }

    
    public function getmenuPrifilage($id)
    {
        $this->db->where('id_role',$id);
        return  $this->db->get('admin_menu_role')->result_array();
    }

    public function deledemenurolprifilage($id)
    {
        $this->db->where('id', $id);
        $this->db->delete('admin_menu_role');
    }
    public function tambahmenurolprifilage($data)
    {
        $this->db->insert('admin_menu_role', $data);
    }

    
}