Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/kumon/application/models

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: Api_model11.php

<?php
Class Api_model extends CI_Model {
	 private $menu_html;
 public function __construct()
 {
 parent::__construct();
 $this->menu_html = '';
 }
 
 function addRecord($main_table, $data,$member = 0 ) {		
		foreach ($data as $key => $value) {
			if($this->startsWith($key, 'tbl_')){
				$table_new = str_replace('tbl_','',$key);
				$sub_table_data[$table_new] = $value;
			} else {
				if (strpos($key,'_date') !== false) {
					$date_field = date("Y-m-d", strtotime($data[$key]));
					$main_data[$key] = $date_field;
				}else {
					$main_data[$key] = $value;
					//$main_data['ref_user_id'] = $data['ref_employee_id'];
					$main_data['added_date'] = date('Y-m-d H:i:s');
				}
			}
		}
		
		$this->db->insert($main_table, $main_data);
		$last_id = $this->db->insert_id();
		
		if (isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $value) {
				$new_table = $key;
				foreach ($value as $key => $value) {
					$value['ref_'.$main_table.'_id'] = $last_id;
					//$value['ref_user_id'] = $data['ref_employee_id'];
					$value['added_date'] = date('Y-m-d H:i:s');
					$new_data = $value;
					$this->db->insert($new_table, $new_data);
				}
			}
		}
 return $last_id;
 }
 
 
 function updateRecord($main_table,$data,$id){
		if(isset($data) && !empty($data)){
			foreach ($data as $key => $value) {
				if($this->startsWith($key, 'tbl_')){
					$table_new = str_replace('tbl_','',$key);
					$sub_table_data[$table_new] = $value;
				} else {
					if (strpos($key,'_date') !== false || strpos($key,'date_') !== false) {
						$date_field = date("Y-m-d H:i:s", strtotime($data[$key]));
						$main_data[$key] = $date_field;
					}elseif (strpos($key, '_time') !== false) {
						$date_field = date("H:i:s", strtotime($data[$key]));
						$main_data[$key] = $date_field;
					}else {
						$main_data[$key] = $value;
						//$main_data['ref_user_id'] = $data['ref_employee_id'];
						$main_data['added_date'] = date('Y-m-d H:i:s');
					}
				}
			}
		}
		
		$this->db->where($main_table . '_id', $id);
		$this->db->update($main_table, $main_data);
		
		// Update Sub Tabel data
		if(isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $val1) {
				$this->db->where('ref_'.$main_table.'_id', $id);
				$this->db->delete($key);
				$new_table = $key;
				foreach ($val1 as $key => $v1) {
					$sub_table_main_data = array();
 $sub_table_main_data['ref_'.$main_table.'_id'] = $id;
 foreach($v1 as $k2=>$v2){
						if (strpos($k2, '_date') !== false) {
							$date_field = date("Y-m-d H:i:s", strtotime($v1[$k2]));
							$sub_table_main_data[$k2] = $date_field;
						}else if(strpos($k2, '_time') !== false){
							$date_field = date("Y-m-d H:i:s", strtotime($v1[$k2]));
							$sub_table_main_data[$k2] = $date_field;
						}else{
							$sub_table_main_data[$k2] = $v1[$k2];
						}
					}					
 $value['user_id'] = $data['ref_employee_id'];
 $sub_table_main_data['added_date'] = date('Y-m-d H:i:s');
 $this->db->insert($new_table, $sub_table_main_data);
 }
			}
		}
		
		return $id;
 }
 
 function startsWith($string, $key)
 {
 // search backwards starting from haystack length characters from the end
 return $key === "" || strrpos($string, $key, -strlen($string)) !== FALSE;
 }
	
	
	
	function get_invoice_list($employee_id=0) {
		$sql = "SELECT i.invoice_id,
							i.invoice_no,
							DATE_FORMAT(i.invoice_date,'%d-%m-%Y') as invoice_date,
							i.grand_total,
							c.client_name
						FROM invoice AS i 
						LEFT JOIN client AS c ON c.client_id = i.ref_client_id 	
						LEFT JOIN employee AS e ON e.employee_id = i.ref_employee_id 	
						WHERE ";
		if($employee_id){
			$sql .= "i.ref_employee_id = ".$employee_id." AND ";
		}
		
		$sql .= " i.transaction_id = 0 AND i.delete_status = 0 ORDER BY i.invoice_id DESC";
 
 $query = $this->db->query( $sql );
 if ( $query->num_rows() >= 1 ) {
 return $query->result();
 } else {
 return false;
 }
 }
 
	function get_client_order_list($employee_id=0) {
		$sql = "SELECT i.client_order_id,
							i.client_order_no,
							DATE_FORMAT(i.client_order_date,'%d-%m-%Y') as client_order_date,
							i.grand_total,
							c.client_name
						FROM client_order AS i 
						LEFT JOIN client AS c ON c.client_id = i.ref_client_id 	
						LEFT JOIN employee AS e ON e.employee_id = i.ref_employee_id 	
						WHERE ";
		if($employee_id){
			$sql .= "i.ref_employee_id = ".$employee_id." AND ";
		}
		
		$sql .= " i.transaction_id = 0 AND i.delete_status = 0 ORDER BY i.client_order_id DESC";
 
 $query = $this->db->query( $sql );
 if ( $query->num_rows() >= 1 ) {
 return $query->result();
 } else {
 return false;
 }
 }
 function get_client_list($employee_id=0) {
		$sql = "SELECT 
						client_id,
						client_name										
					FROM client 
					WHERE ";
		if($employee_id){
			$sql .= "FIND_IN_SET('".$employee_id."',employee_id) AND ";
		}
		$sql .= " transaction_id = 0 AND delete_status = 0 ORDER BY client_name ASC";
 
 $query = $this->db->query( $sql );
 if ( $query->num_rows() >= 1 ) {
 return $query->result();
 } else {
 return false;
 }
 }
 
 
	function get_client_details($client_id=0) {

$sql =  "SELECT 
						c.client_id,
						c.client_name,										
						c.client_address_line1,										
						c.client_address_line2,										
						c.client_address_line3,										
						c.client_pincode,										
						ct.country_name,
						s.state_name,
						dt.district_name
					FROM client AS c 
					LEFT JOIN country AS ct ON ct.country_id = c.ref_country_id 
					LEFT JOIN state AS s ON s.state_id = c.ref_state_id 
					LEFT JOIN district AS dt ON dt.district_id = c.ref_district_id 
					WHERE c.client_id = '".$client_id."' AND ";
		$sql .= " c.transaction_id = 0 AND c.delete_status = 0 ORDER BY c.client_name ASC";
        
        $query = $this->db->query( $sql );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function check_login($user_name,$password){
		$query = $this->db->query("SELECT * FROM user WHERE user_name = '".$user_name."' AND password = '".MD5($password)."' AND status = 1 AND  delete_status = 0 AND transaction_id = 0");
		if ( $query->num_rows() == 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}

/*
 * Cr.Date : 07.12.2018
 * Up.Date : 07.12.2018
 * name    : get_pending_invoice_customer_count
 * @param  : employee_id
 * @return : Customer Count
 * 
 */
	function get_pending_invoice_customer_count()
	{
	    $sql = " SELECT count(DISTINCT ref_client_id) as total FROM client_invoice WHERE  delete_status = 0 AND transaction_id = 0 AND client_invoice_balance != 0 AND employee_id ";
	    
	    $query = $this->db->query( $sql );
	    if ( $query->num_rows() >= 1 ) {
		    return $query->result();
	    } else {
		    return false;
	    }

}
	
	
	
    function get_product_list(){
		$query = $this->db->query("SELECT product_id,product_name FROM product WHERE delete_status = 0 AND transaction_id = 0 ORDER BY product_name ASC");
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    function get_product_size($product_id){
		$query = $this->db->query("SELECT product_size_id,product_size_name FROM product_size WHERE ref_product_id = '".$product_id."' AND delete_status = 0 AND transaction_id = 0 ORDER BY product_size_name ASC");
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    function get_product_price($product_size_id){
		$query = $this->db->query("SELECT ps.*,p.product_name FROM product_size AS ps LEFT JOIN product AS p ON p.product_id = ps.ref_product_id  WHERE ps.product_size_id = '".$product_size_id."'  AND ps.delete_status = 0 AND ps.transaction_id = 0");
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    function get_data_source(){
		$query = $this->db->query("SELECT data_source_id,data_source_name FROM data_source WHERE delete_status = 0 AND transaction_id = 0 ORDER BY data_source_name ASC");
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    function get_contact_number_type(){
		$query = $this->db->query("SELECT contact_number_type_id,contact_number_type_name FROM contact_number_type WHERE delete_status = 0 AND transaction_id = 0 ORDER BY sort_order ASC");
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    function get_business_category(){
		$query = $this->db->query("SELECT business_category_id,business_category_name FROM business_category WHERE delete_status = 0 AND transaction_id = 0 ORDER BY business_category_name ASC");
		
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	
    
    function get_employee_details($employee_id){
		$query = $this->db->query("SELECT employee_id,employee_name FROM employee WHERE employee_id = '".$employee_id."' AND employee.delete_status = 0 AND employee.transaction_id = 0");
		
		if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	 function parentCheck($table,$cat_id)
    {
        $sql   = "select sponsor_employee_id from $table where ".$table."_id=$cat_id AND ref_employee_status_id = 1 AND delete_status = 0 AND transaction_id = 0 ";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            $res = $query->result();
            //echo $res[0]->product_parent_id;
            $id = 'sponsor_employee_id';
            return $res[0]->$id;
        } else {
            return false;
        }
    }
    function hasParent($table,$cat_id)
    {
        $rec_count = 1;
        do {
            $result = $this->parentCheck($table,$cat_id);
            $rec_count++;
            $cat_id = $result;
        } while ($result);
        return $rec_count;
    }
    
	
	 function render_menu($table,$parent_id)
    {
		//echo $item_id;
        $sql   = "select * from employee where 	ref_employee_status_id = 1 AND delete_status = 0 AND transaction_id = 0 AND sponsor_employee_id = $parent_id ORDER BY employee_name ASC";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            foreach ($query->result() as $key => $val) {
				$id = $table.'_id';
				$name = $table.'_name';
                if ($parent_id == 0){
                       $this->menu_html .=  $val->$id .',';
                }else {
					 $this->menu_html .= $val->$id .',';
                }
                $this->render_menu($table,$val->$id);
                //$this->menu_html .= ",";
            }
            return $this->menu_html;
        } else {
            return false;
        }
    }
    function get_employee_team_list($table,$employee_id=0)
    {
		//echo $item_id;
         $category = $this->render_menu($table,$employee_id);
      //  exit;
        return $category;
    }
    
    
    
	
    function update_password($id,$password){
	    $query = $this->db->query( "UPDATE user SET  password = '" . md5($password) . "' WHERE user_id = '" . $id . "'" );
	    return true;
    }	
	
	function update_firebase_token($user_id,$firebase_token){
		$query = $this->db->query( "UPDATE user SET firebase_token = '' WHERE firebase_token = '" . trim($firebase_token) . "'" );
		$query = $this->db->query( "UPDATE user SET firebase_token = '" . trim($firebase_token) . "' WHERE user_id = '" . $user_id . "'" );
		
		return true;
	}
	
	private function sendPushNotification($fields) {
        
        $url = 'https://fcm.googleapis.com/fcm/send';
 
        $headers = array(
            'Authorization: key=' . FIREBASE_API_KEY,
            'Content-Type: application/json'
        );
        // Open connection
        $ch = curl_init();
		
        // Set the url, number of POST vars, POST data
        curl_setopt($ch, CURLOPT_URL, $url);
 
        curl_setopt($ch, CURLOPT_POST, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 
        // Disabling SSL Certificate support temporarly
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
 
        curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($fields));
 
        $result = curl_exec($ch);
        
        if ($result === FALSE) {
            die('Curl failed: ' . curl_error($ch));
        }
 
        curl_close($ch);
 
        return $result;
    }

function getReminderList($user_id){
	$reminder_list = array();
	$reminder_list['cal_reminder_list'] = '';
	//$user_id = $this->session->userdata( SESSION_LOGIN . 'user_id' ); 
	$where = 'assigned_user_id = '.$user_id.' AND ref_status_id != 3'; 
	$order_by = 'general_reminder.completed_date ASC'; 
 $reminder = $this->getRecords('general_reminder', $where ,'',$order_by);
	//~ echo "<pre>";
	//~ echo $user_id;
	//~ print_r($reminder);
	//~ exit;
 $date = date( 'Y-m-d' );
 if ( isset( $reminder ) && !empty( $reminder ) )
 {
 foreach ( $reminder as $key => $val )
 {
	 $user = $this->Common_model->getDetails( 'user', 'user_id', $val->assigned_user_id );

$reminder_list['reminder_list'][] = (object) array(
                            'general_reminder_id' => $val->general_reminder_id,
                            'general_reminder_details' => $val->general_reminder_details,
                            'assigned_date' => $this->Common_model->getDateTimeFormat( $val->assigned_date ),
                            'completed_date' => $this->Common_model->getDateTimeFormat( $val->completed_date ),
                            'ref_priority_id' => $val->ref_priority_id,
                            'view_status' => $val->view_status,
                            'priority_name' => $val->priority_name,
                            'ref_status_id' => $val->ref_status_id,
                            'status_name' => $val->status_name,
                            'file_update_status' => $val->file_update_status,
                            'user_name' => $val->full_name,
                            'assigned_to' => $user[0]->full_name 
    );
                     
                    
                  
                  
	$json[] = array(
		    'id' => $val->general_reminder_id,
		    'start' => $val->assigned_date,
		    'end' => $val->completed_date,
		    'title' => $val->general_reminder_details,
		    'description' => $val->general_reminder_details,
		    'link' => $val->reference_link,
		    'event_link' => 'reminder/view/'.$val->general_reminder_id,
		    'textColor' => '#fff',
                    'color' => '#1f91f3' 
		);
		
	$reminder_list['cal_reminder_list'] = $json;
	//$reminder_list['cal_reminder_list'] = json_encode($json);
	//$general_reminder = json_encode($json);
              }
          }
          
		$reminder_list['today_reminder_count'] = 0;
		$reminder_list['past_reminder_count']  = 0;
	if ( isset( $reminder_list['reminder_today'] ) && !empty( $reminder_list['reminder_today'] ) )
		  {
	    $reminder_list['today_reminder_count'] = count( $reminder_list['reminder_today'] );
		  }
	if ( isset( $reminder_list['reminder_past'] ) && !empty( $reminder_list['reminder_past'] ) )
		  {
	    $reminder_list['past_reminder_count'] = count( $reminder_list['reminder_past'] );
		  }
	return  $reminder_list;
          
	 }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Api_model11.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation