|
Server IP : 172.26.0.195 / Your IP : 18.219.47.239 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/core/../models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Model Class For Handling All DB Operations Related To Grievance Logging
*
* @author Softpro India Pvt. Ltd.
*/
defined('BASEPATH') OR exit('No direct script access allowed');
class GrievanceLogManagement extends CI_Model {
function __construct() {
parent::__construct();
$this->load->database();
}
function createGrievanceLog(array $newGrievanceLogInfo) {
$this->db->insert('grievance_redressal_log', $newGrievanceLogInfo);
return $this->db->insert_id();
}
function getGrievanceLog($gm_id){
$this->db->select("*");
$this->db->from('grievance_redressal_log GRL');
$this->db->join('grievance_mst GM', 'GM.gm_id = GRL.gm_id');
$this->db->join('college_admins_and_users CAU', 'GRL.grl_action_taken_by = CAU.cau_id');
$this->db->where('GRL.gm_id', $gm_id);
$this->db->where('GRL.grl_delete_status', 'F');
$this->db->order_by('GRL.grl_action_taken_on asc');
return $this->db->get();
}
}