|
Server IP : 172.26.0.195 / Your IP : 3.144.38.184 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/../admission/application/logs/../models/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
* Description of EnquiryManagement
*
* @author Softpro India Pvt. Ltd
*/
class EnquiryManagement extends CI_Model{
//put your code here
function insertEnquiry($arr) {
$this->db->insert("adm_enquiry", $arr);
return $this->db->insert_id();
}
// function getEnquiry(){
// $this->db->select("*");
// $this->db->from("adm_enquiry");
// return $this->db->get();
// }
function getEnquiry($course = '', $startDate = '', $endDate = '') {
$this->db->select("*");
$this->db->from("adm_enquiry e");
$this->db->join("tbl_course_master c", "e.course_id=c.course_id");
if ($course != '') {
$this->db -> where("e.course_id", $course);
}
if ($startDate != '' && $endDate!='') {
$this->db -> where("e.enq_added_on BETWEEN '".$startDate."' AND '".$endDate."'");
}
if ($startDate == '' && $endDate!='') {
$this->db -> where("e.enq_added_on <= '". $endDate."'");
}
if ($startDate != '' && $endDate=='') {
$this->db -> where("e.enq_added_on >='". $startDate."'");
}
$this->db->order_by("e.enq_added_on", "DESC");
return $this->db->get();
}
}