|
Server IP : 172.26.0.195 / Your IP : 3.144.252.58 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/../grievance/application/models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Model Class for Handling All DB Operations Related To Grievance Category Allotment
*
* @author Softpro India Pvt. Ltd.
*/
defined('BASEPATH') OR exit('No direct script access allowed');
class GCAllotManagement extends CI_Model {
function __construct() {
parent::__construct();
$this->load->database();
}
function makeNewAllotment(array $newAllotmentInfo) {
$this->db->insert('gcell_member_allot', $newAllotmentInfo);
return $this->db->insert_id();
}
function getAllottedGCToUser($cau_id){
$this->db->select("*");
$this->db->from('gcell_member_allot');
$this->db->where('cau_id', $cau_id);
return $this->db->get();
}
function deleteGCAllotMappingByUserId($cau_id) {
$this->db->where('cau_id', $cau_id);
$this->db->delete('gcell_member_allot');
}
function getAllottedGCToUserFullInfo($cau_id){
$this->db->select("*");
$this->db->from('gcell_member_allot GMA');
$this->db->join('grievance_cat_mst GCM','GMA.gcm_id = GCM.gcm_id');
$this->db->where('GMA.cau_id', $cau_id);
return $this->db->get();
}
}