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/my-little-rocks.com/public_html/application/controllers

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: Api00.php

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Api extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model(array(
            'Api_model',
            'Dashboard/Dashboard_model',
            //'Common/Common_model',
            //'Project/project_model',
            'Lead/Lead_model'
        ));
      }
  
	// Index
    function index()
    {
		
    }
    
    // Login And Check for IMEI No
    function do_login()
    {
        $imei       = trim($_REQUEST['imei_no']);
        $user_name  = trim($_REQUEST['user_name']);
        $password   = trim($_REQUEST['password']);
             
        // Check for Login
		$res_user = $this->Api_model->check_login($user_name,$password);

if (isset($res_user) && !empty($res_user)) {
			if (empty($res_user[0]->imei_no)) {
				$this->Api_model->update_imei_no($imei, $user_name, $password);
				$this->login_success($res_user);
			} elseif ($res_user[0]->imei_no == $imei) {
				$this->login_success($res_user);
				} else {
					$data['status'] = 'Failure';
					$data['result'] = 'Invalid Device' ;
				}
		} else {
			$data['status'] = 'Failure';
			$data['result'] = 'Invalid User Name or Password' ;
		}
		echo json_encode($data);
		exit;
    }
    
    function login_success($res_user)
    {
		$employee_name           = '';
		$designation_name        = '';
		$employee_code           = '';
		$employee_designation_id = 0;
		
		$res_employee            = $this->Api_model->get_employee_details($res_user[0]->ref_employee_id);
		if (isset($res_employee) && !empty($res_employee)) {
			$employee_name           = $res_employee[0]->employee_name;
			$employee_code           = $res_employee[0]->employee_code;
			$employee_designation_id = $res_employee[0]->employee_designation_id;
			$designation_name        = $res_employee[0]->designation_name;
		}
		$data['status']   = 'success';
		$data['result'][] = array(
			'user_id' => $res_user[0]->user_id,
			'user_name' => $res_user[0]->user_name,
			'user_email' => $res_user[0]->email,
			'user_group_id' => $res_user[0]->ref_user_group_id,
			'employee_id' => $res_user[0]->ref_employee_id,
			'imei_no' => $res_user[0]->imei_no,
			'employee_name' => $employee_name,
			'employee_code' => $employee_code,
			'designation_id' => $employee_designation_id,
			'designation_name' => $designation_name
		);
		echo json_encode($data);
		exit;
	}
	
    function check_login_status()
    {
        if (isset($_REQUEST['user_id'])) {
            $user_id = trim($_REQUEST['user_id']);
        } else {
            $user_id = 0;
        }
        $res_user         = $this->Api_model->check_login_status($user_id);
        $data['response'] = array();
        if (isset($res_user) && !empty($res_user)) {
            $data['response']['status'] = 'success';
            $data['response']['result'] = array(
                'user_id' => $res_user[0]->user_id,
                'user_name' => $res_user[0]->user_name,
                'user_email' => $res_user[0]->email,
                'user_group_id' => $res_user[0]->ref_user_group_id,
                'employee_id' => $res_user[0]->ref_employee_id
            );
        } else {
            $data['response']['status'] = 'error';
            $data['response']['result'] = 'User logged out...';
        }
        echo json_encode($data);
        exit;
    }

function get_client_list()
    {
        $employee_id = $this->uri->segment(3);
        $res_client  = $this->Api_model->get_client_list($employee_id);

if(isset($res_client) && !empty($res_client)){
			foreach($res_client as $key => $val){
			$data['client'][] = array(
			'client_id'	=> $val->client_id,
			'client_name'	=> $val->client_name );
			}
		}
                    
        echo json_encode($data);
        exit;
    }
    
	function get_client_details()
	{
	$client_id = $this->uri->segment(3);
	$res_client = $this->Api_model->get_client_details($client_id);

if (isset($res_client) && !empty($res_client))
		{
		foreach($res_client as $key => $val)
			{
			$res_client_contact_numbers = $this->Common_model->getDetails('client_contact_numbers', 'ref_client_id', $val->client_id);
			if (isset($res_client_contact_numbers) && !empty($res_client_contact_numbers))
				{
				foreach($res_client_contact_numbers as $v1)
					{
					$client_contact_numbers[] = array(
						'contact_person' => $v1->contact_person,
						'contact_number_type_name' => $v1->contact_number_type_name,
						'std_code' => $v1->std_code,
						'contact_number' => $v1->contact_number
					);
					}
				}
			  else
				{
				$client_contact_numbers = null;
				}

$data['client'][] = array(
				'client_id' => $val->client_id,
				'client_name' => $val->client_name,
				'client_address_line1' => $val->client_address_line1,
				'client_address_line2' => $val->client_address_line2,
				'client_address_line3' => $val->client_address_line3,
				'client_pincode' => $val->client_pincode,
				'district_name' => $val->district_name,
				'state_name' => $val->state_name,
				'country_name' => $val->country_name,
				'client_contact_numbers' => $client_contact_numbers
			);
			}
		}
		//$data['summary'][] = $this->get_client_summary_count() ;
		
		$proforma_invoice = $this->Common_model->getDetails('proforma_invoice', 'ref_client_id', $client_id, 'added_date', 'DESC');
        if (isset($proforma_invoice) && !empty($proforma_invoice)) {
			$proforma_invoice_count = count($proforma_invoice) ;
		} else {
			$proforma_invoice_count = 0 ;
        }
        $product_sample_request = $this->Common_model->getDetails('product_sample_request', 'ref_client_id', $client_id, 'added_date', 'DESC');

if (isset($product_sample_request) && !empty($product_sample_request)) {
			$product_sample_request_count = count($product_sample_request);
        } else {
			$product_sample_request_count = 0 ;
        }
        $client_visit = $this->Common_model->getDetails('client_visit', 'ref_client_id', $client_id, 'client_visit_date', 'DESC');
        if (isset($client_visit) && !empty($client_visit)) {
			$client_visit_count = count($client_visit);
        } else {
			$client_visit_count = 0 ;
        }
        $complaint = $this->Common_model->getDetails('complaint', 'ref_client_id', $client_id, 'added_date', 'DESC');
        if (isset($complaint) && !empty($complaint)) {
			$complaint_count = count($complaint);
        } else {
			$complaint_count = 0 ;
        }

// In other Places ref as 'import_outstanding' but here ref as Tally Outstanding 
        $tally_outstanding = $this->Common_model->getDetails('client_outstanding','ref_client_id',$client_id, 'added_date', 'DESC');
        
        if (isset($tally_outstanding) && !empty($tally_outstanding)) {
			$tally_outstanding_count = count($tally_outstanding);
        } else {
			$tally_outstanding_count = 0 ;
        }
		    
        $client_pending_invoice = $this->Client_model->get_pending_purchase_order($client_id);
    
        
        if (isset($client_pending_invoice) && !empty($client_pending_invoice)) {
			$client_pending_invoice_count = count($client_pending_invoice);
        } else {
			$client_pending_invoice_count = 0 ;
        }

$data['client_dashboard_count'] = array(
			array(
			'transaction_id' => 'proforma_invoice',
			'transaction_name' => 'Proforma Invoice',
			'transaction_value' => $proforma_invoice_count
			),
			array(
			'transaction_id' => 'product_sample_request',
			'transaction_name' => 'Product Sample Request',
			'transaction_value' => $product_sample_request_count
			),
			array(
			'transaction_id' => 'client_visit',
			'transaction_name' => 'Client Visit',
			'transaction_value' => $client_visit_count
			),
			array(
			'transaction_id' => 'complaint',
			'transaction_name' => 'Complaint Count',
			'transaction_value' => $complaint_count
			),
			array(
			'transaction_id' => 'tally_outstanding',
			'transaction_name' => 'Tally Outstanding',
			'transaction_value' => $tally_outstanding_count
			),
			array(
			'transaction_id' => 'client_pending_invoice',
			'transaction_name' => 'Client Pending Invoice',
			'transaction_value' => $client_pending_invoice_count
			)
		);
		
	echo json_encode($data);
	exit;
	}
    
        
    function get_announcement()
    {
        $employee_id          = $this->uri->segment(3);
        $data['announcement'] = $this->Dashboard_model->get_announcement($employee_id);
        echo json_encode($data);
        exit;
    }
    
    function get_dashboard_over_all_summary()
    {
		$total_client = $this->Api_model->get_customer_count();

$pending_invoice_client_count = $this->Api_model->get_pending_invoice_customer_count();

//~ $pending_invoice_count = $this->Api_model->get_pending_invoice_count();
        //~ $pending_invoice_balance = $this->Api_model->get_pending_invoice_balance();
        //~ $expired_invoice = $this->Api_model->get_expired_invoice();
        //~ $expired_invoice_pending_amount = $this->Api_model->get_expired_invoice_pending_amount();

//~ if(!empty($total_client) && !empty($pending_invoice_client_count) && !empty($pending_invoice_count) && !empty($pending_invoice_balance) && !empty($expired_invoice) && !empty($expired_invoice_pending_amount)){
	//~ $data['over_all_summary'] = array(
	    //~ array(
	    //~ 'name' => 'Total Client',
	    //~ 'value' => $total_client[0]->total
		//~ ),
	    //~ array(
	    //~ 'name' => 'Pending Invoice Clients',
	    //~ 'value' => $pending_invoice_client_count[0]->total
		//~ ),
	    //~ array(
	    //~ 'name' => 'Pending Invoice',
	    //~ 'value' => $pending_invoice_client_count[0]->total_pending
		//~ ),
	    //~ array(
	    //~ 'name' => 'Pending Amount',
	    //~ 'value' => $pending_invoice_balance[0]->balance
		//~ ),
	    //~ array(
	    //~ 'name' => 'Over Due Invoice',
	    //~ 'value' => $expired_invoice[0]->expired_invoice
		//~ ),
	    //~ array(
	    //~ 'name' => 'Pending Amount',
	    //~ 'value' => $expired_invoice_pending_amount[0]->total
		//~ )
				    //~ );
		//~ }
	echo json_encode($data);
	exit;
	}
       
    
    function get_invoice_list()
    {
        $employee_id          = $this->uri->segment(3);
        $data['invoice_list'] = $this->Api_model->get_invoice_list($employee_id);
        echo json_encode($data);
        exit;
    }
    function get_invoice_details()
    {
        $invoice_id  = $this->uri->segment(3);
        $res_invoice = $this->Common_model->getDetails('invoice', 'invoice_id', $invoice_id);
        if (isset($res_invoice) && !empty($res_invoice)) {
            $data['invoice_details'][] = array(
                'client_name' => $res_invoice[0]->client_name,
                'invoice_no' => $res_invoice[0]->invoice_no,
                'invoice_date' => $res_invoice[0]->invoice_date,
                'sub_total' => $res_invoice[0]->sub_total,
                'discount_value' => $res_invoice[0]->discount_value,
                'discount_total' => $res_invoice[0]->discount_total,
                'gst_total' => $res_invoice[0]->gst_total,
                'extra_total' => $res_invoice[0]->extra_total,
                'p_and_f_total' => $res_invoice[0]->p_and_f_total,
                'round_off_type' => $res_invoice[0]->round_off_type,
                'round_off' => $res_invoice[0]->round_off,
                'grand_total' => $res_invoice[0]->grand_total,
                'invoice_details' => $res_invoice[0]->invoice_details
            );
        } else {
            $data['invoice_details'] = null;
        }
        $res_invoice_particulars = $this->Common_model->getDetails('invoice_particulars', 'ref_invoice_id', $invoice_id);
        if (isset($res_invoice_particulars) && !empty($res_invoice_particulars)) {
            foreach ($res_invoice_particulars as $key => $val) {
                $data['invoice_particulars'][] = array(
                    'product_name' => $val->product_name,
                    'product_size_name' => $val->product_size_name,
                    'price' => $val->price,
                    'qty' => $val->qty,
                    'total' => $val->total
                );
            }
        } else {
            $data['invoice_particulars'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function get_invoice_form()
    {
        $data['product'] = $this->Api_model->get_product_list();
        if (empty($data['product'])) {
            $data['product'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function add_invoice()
    {
        $po_particulars  = json_decode($_POST['invoice_product_particulars']);
        $data            = json_decode($_POST['invoice_details']);
        $invoice_details = (array) $data[0];
        $po_particulars  = (array) $po_particulars;
        $res             = $this->Api_model->addRecord('invoice', $invoice_details);
        if (isset($po_particulars) && !empty($po_particulars)) {
            foreach ($po_particulars as $val) {
                //if(!empty($val['qty'])){    
                $po_p_data                   = (array) $val;
                $po_p_data['ref_invoice_id'] = $res;
                echo '<pre>';
                print_r($po_p_data);
                echo '</pre>';
                exit;
                $this->Api_model->addRecord('invoice_particulars', $po_p_data);
                //}
            }
        }
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function get_order_form()
    {
        $data['product'] = $this->Api_model->get_product_list();
        if (empty($data['product'])) {
            $data['product'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function add_order()
    {
        $po_particulars = json_decode($_POST['client_order_product_particulars']);
        $data           = json_decode($_POST['client_order_details']);
        $order_details  = (array) $data[0];
        $po_particulars = (array) $po_particulars;
        $res            = $this->Api_model->addRecord('client_order', $order_details);
        if (isset($po_particulars) && !empty($po_particulars)) {
            foreach ($po_particulars as $val) {
                $po_p_data                        = (array) $val;
                $po_p_data['ref_client_order_id'] = $res;
                $this->Api_model->addRecord('client_order_particulars', $po_p_data);
            }
        }
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function get_client_order_list()
    {
        $employee_id               = $this->uri->segment(3);
        $data['client_order_list'] = $this->Api_model->get_client_order_list($employee_id);
        echo json_encode($data);
        exit;
    }
    function get_client_order_details()
    {
        $client_order_id  = $this->uri->segment(3);
        $res_client_order = $this->Common_model->getDetails('client_order', 'client_order_id', $client_order_id);
        echo '<pre>';
        print_r($res_client_order);
        echo '</pre>';
        exit;
        if (isset($res_client_order) && !empty($res_client_order)) {
            $data['client_order_details'][] = array(
                'client_name' => $res_client_order[0]->client_name,
                'client_order_no' => $res_client_order[0]->client_order_no,
                'client_order_date' => $res_client_order[0]->client_order_date,
                'sub_total' => $res_client_order[0]->sub_total,
                'discount_value' => $res_client_order[0]->discount_value,
                'discount_total' => $res_client_order[0]->discount_total,
                'gst_total' => $res_client_order[0]->gst_total,
                'extra_total' => $res_client_order[0]->extra_total,
                'p_and_f_total' => $res_client_order[0]->p_and_f_total,
                'round_off_type' => $res_client_order[0]->round_off_type,
                'round_off' => $res_client_order[0]->round_off,
                'grand_total' => $res_client_order[0]->grand_total,
                'client_order_details' => $res_client_order[0]->client_order_details
            );
        } else {
            $data['client_order_details'] = null;
        }
        $res_client_order_particulars = $this->Common_model->getDetails('client_order_particulars', 'ref_client_order_id', $client_order_id);
        if (isset($res_client_order_particulars) && !empty($res_client_order_particulars)) {
            foreach ($res_client_order_particulars as $key => $val) {
                $data['client_order_particulars'][] = array(
                    'product_name' => $val->product_name,
                    'product_size_name' => $val->product_size_name,
                    'price' => $val->price,
                    'qty' => $val->qty,
                    'total' => $val->total
                );
            }
        } else {
            $data['client_order_particulars'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function get_product_size()
    {
        $product_id           = $this->uri->segment(3);
        $data['product_size'] = $this->Api_model->get_product_size($product_id);
        if (empty($data['product_size'])) {
            $data['product_size'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function add_invoice_product()
    {
        $product_size_id   = $_REQUEST['product_size_id'];
        $product_qty       = $_REQUEST['product_qty'];
        $res_product_price = $this->Api_model->get_product_price($product_size_id);
        if (isset($res_product_price) && !empty($res_product_price)) {
            $data['product_details'][] = array(
                'product_id' => $res_product_price[0]->ref_product_id,
                'product_name' => $res_product_price[0]->product_name,
                'product_size_id' => $res_product_price[0]->product_size_id,
                'product_size_name' => $res_product_price[0]->product_size_name,
                'product_price' => $res_product_price[0]->product_price,
                'product_qty' => $product_qty,
                'product_total' => $product_qty * $res_product_price[0]->product_price
            );
        } else {
            $data['product'] = null;
        }
        echo json_encode($data);
        exit;
    }
    function get_district()
    {
        $state_id         = $this->uri->segment(3);
        $data['district'] = $this->Api_model->get_district($state_id);
        echo json_encode($data);
        exit;
    }
    function add_master_item()
    {
        $res_area = $this->Common_model->getFieldItemExist($_REQUEST['name'], $_REQUEST['field'], $_REQUEST['parent']);
        $res      = array();
        if ($res_area >= 1) {
            $res = 'exist';
        } else {
            $this->Common_model->addFieldItem($_REQUEST['name'], $_REQUEST['field'], $_REQUEST['parent']);
            $res['response'] = $this->Common_model->getFieldItem($_REQUEST['field']);
        }
        echo json_encode($res);
        exit;
    }
    function update_lead()
    {
        $l_data = json_decode($_POST['lead_details']);
        $data   = (array) $l_data[0];
        //$data['lead_sid'] = $this->Common_model->get_SID();
        $m_data = json_decode($_POST['contact_number']);
        if (isset($m_data) && !empty($m_data)) {
            foreach ($m_data as $key => $val) {
                $data['tbl_lead_contact_number'][] = (array) $val;
            }
        }
        $e_data = json_decode($_POST['contact_email']);
        if (isset($e_data) && !empty($e_data)) {
            foreach ($e_data as $key => $val) {
                $data['tbl_lead_contact_email'][] = (array) $val;
            }
        }
        $id = $data['ref_lead_id'];
        unset($data['ref_lead_id']);
        echo '<pre>';
        print_r($data);
        echo '</pre>';
        exit;
        $res_lead_id = $this->Api_model->updateRecord('lead', $data, $id);
        if ($res_lead_id) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function check_duplication()
    {
        if (isset($_REQUEST['name'])) {
            $res_name = $this->Common_model->getDetails('lead', 'lead_name', trim($_REQUEST['name']));
            if (isset($res_name) && !empty($res_name)) {
                $json['response'] = '1';
            } else {
                $json['response'] = '0';
            }
            echo json_encode($json);
            exit;
        } elseif (isset($_REQUEST['number'])) {
            $res_number = $this->Common_model->getDetails('lead_contact_number', 'contact_number', trim($_REQUEST['number']));
            if (isset($res_number) && !empty($res_number)) {
                $lead_name        = $this->Common_model->getDetails('lead', 'lead_id', $res_number[0]->ref_lead_id);
                $json['response'] = '1';
            } else {
                $json['response'] = '0';
            }
            echo json_encode($json);
            exit;
        } else {
            echo '<pre>';
            print_r($_REQUEST['email']);
            echo '</pre>';
            exit;
            $res_email = $this->Common_model->getDetails('lead_contact_email', 'email_id', trim($_REQUEST['email']));
            echo '<pre>';
            print_r($res_email);
            echo '</pre>';
            exit;
            if (isset($res_email) && !empty($res_email)) {
                //$lead_name = $this->Common_model->getDetails('lead','lead_id',$res_email[0]->ref_lead_id);
                $json['response'] = '1';
            } else {
                $json['response'] = '0';
            }
            echo json_encode($json);
            exit;
        }
    }
    function update_password()
    {
        $password = $_POST['password'];
        $user_id  = $_POST['user_id'];
        $res      = $this->Api_model->update_password($user_id, $password);
        if ($res) {
            $json['response'] = '1';
        } else {
            $json['response'] = '0';
        }
        echo json_encode($json);
        exit;
    }
    function delete_lead_project_visit()
    {
        $id  = $this->uri->segment(3);
        $res = $this->Common_model->removeRecord('lead_project_visit', 'lead_project_visit_id', $id);
        if ($res) {
            $json['response'] = '1';
        } else {
            $json['response'] = '0';
        }
        echo json_encode($json);
        exit;
    }
    function update_firebase_token()
    {
        $res = $this->Api_model->update_firebase_token($_POST['user_id'], $_POST['firebase_token']);
        if ($res) {
            $json['response'] = '1';
        } else {
            $json['response'] = '0';
        }
        echo json_encode($json);
        exit;
    }
    function get_project_list()
    {
        $project_list = $this->Common_model->getDetails('project', 'delete_status', '0');
        if (isset($project_list) && !empty($project_list)) {
            foreach ($project_list as $val) {
                $data['project_list'][] = array(
                    'project_id' => $val->project_id,
                    'project_name' => $val->project_name,
                    'project_start_date' => $val->project_start_date,
                    'project_end_date' => $val->project_end_date,
                    'priority_name' => $val->priority_name,
                    'status_name' => $val->status_name
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function get_project_details()
    {
        $id              = $this->uri->segment(3);
        $project_details = $this->Common_model->getDetails('project', 'project_id', $id);
        if (isset($project_details) && !empty($project_details)) {
            foreach ($project_details as $val) {
                $data['project_details'][] = array(
                    'project_id' => $val->project_id,
                    'project_name' => $val->project_name,
                    'project_description' => $val->project_description,
                    'project_start_date' => $val->project_start_date,
                    'project_end_date' => $val->project_end_date,
                    'user_name' => $val->user_name,
                    'priority_name' => $val->priority_name,
                    'status_name' => $val->status_name
                );
            }
        }
        $project_task_details = $this->Common_model->getDetails('project_task_list', 'ref_project_id', $id);
        if (isset($project_task_details) && !empty($project_task_details)) {
            foreach ($project_task_details as $val) {
                $data['project_task_list'][] = array(
                    'project_task_list_id' => $val->project_task_list_id,
                    'project_tasklist_name' => $val->project_task_list_name
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function get_project_task_details()
    {
        $id                   = $this->uri->segment(3);
        $project_task_details = $this->Common_model->getDetails('project_task', 'ref_project_task_list_id', $id);
        if (isset($project_task_details) && !empty($project_task_details)) {
            foreach ($project_task_details as $val) {
                $data['project_task_details'][] = array(
                    'project_task_id' => $val->project_task_id,
                    'project_task_name' => $val->project_task_name,
                    'project_task_description' => $val->project_task_description,
                    'project_task_start_date' => $val->project_task_start_date,
                    'project_task_end_date' => $val->project_task_end_date,
                    'reference_link' => $val->reference_link,
                    'reference_file' => $val->reference_file,
                    'project_name' => $val->project_name,
                    'project_task_list_name' => $val->project_task_list_name,
                    'priority_name' => $val->priority_name,
                    'status_name' => $val->status_name
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function get_project_task_comment_list()
    {
        $id                   = $this->uri->segment(3);
        $project_task_details = $this->Common_model->getDetails('project_task_comment', 'ref_project_task_id', $id);
        if (isset($project_task_details) && !empty($project_task_details)) {
            foreach ($project_task_details as $val) {
                $data['$project_task_details'][] = array(
                    'project_task_comment_id' => $val->project_task_comment_id,
                    'project_task_comment_details' => $val->project_task_comment_details,
                    'project_task_name' => $val->project_task_name,
                    'user_name' => $val->user_name
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function get_project_task_activity_list()
    {
        $id                    = $this->uri->segment(3);
        $project_task_activity = $this->Common_model->getDetails('project_timetracker', 'ref_project_task_id', $id);
        if (isset($project_task_activity) && !empty($project_task_activity)) {
            foreach ($project_task_activity as $val) {
                $data['project_task_activity'][] = array(
                    'project_timetracker_id' => $val->project_timetracker_id,
                    'start_time' => $val->start_time,
                    'end_time' => $val->end_time,
                    'project_name' => $val->project_name,
                    'project_task_name' => $val->project_task_name
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function add_comments()
    {
        $data         = json_decode($_POST['comments']);
        $add_comments = (array) $data[0];
        //$add_comments =  $_REQUEST;
        echo "<pre>";
        print_r($add_comments);
        exit;
        $res = $this->Api_model->addRecord('project_task_comment', $add_comments);
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function add_task_activity()
    {
        $data          = json_decode($_POST['task_activity']);
        $task_activity = (array) $data[0];
        //$task_activity = (array) $data[0];
        $res           = $this->Api_model->addRecord('project_timetracker', $task_activity);
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function announcement_list()
    {
        $employee_id  = $this->uri->segment(3);
        $res_mainlist = $this->Dashboard_model->get_announcement($employee_id);
        $announcement = array();
        if (isset($res_mainlist) && !empty($res_mainlist)) {
            foreach ($res_mainlist as $key => $val) {
                $data['announcement'][] = $val->announcement_details;
            }
        }
        echo json_encode($data);
        exit;
    }
   
  
    function get_client_summary_count()
    {
        //~ $client_id = $this->uri->segment(3);
 
        //~ $proforma_invoice = $this->Common_model->getDetails('proforma_invoice', 'ref_client_id', $client_id, 'added_date', 'DESC');
        //~ if (isset($proforma_invoice) && !empty($proforma_invoice)) {
			//~ $proforma_invoice_count = count($proforma_invoice) ;
		//~ } else {
			//~ $proforma_invoice_count = 0 ;
        //~ }
        //~ $product_sample_request = $this->Common_model->getDetails('product_sample_request', 'ref_client_id', $client_id, 'added_date', 'DESC');

//~ if (isset($product_sample_request) && !empty($product_sample_request)) {
			//~ $product_sample_request_count = count($product_sample_request);
        //~ } else {
			//~ $product_sample_request_count = 0 ;
        //~ }
        //~ $client_visit = $this->Common_model->getDetails('client_visit', 'ref_client_id', $client_id, 'client_visit_date', 'DESC');
        //~ if (isset($client_visit) && !empty($client_visit)) {
			//~ $client_visit_count = count($client_visit);
        //~ } else {
			//~ $client_visit_count = 0 ;
        //~ }
        //~ $complaint = $this->Common_model->getDetails('complaint', 'ref_client_id', $client_id, 'added_date', 'DESC');
        //~ if (isset($complaint) && !empty($complaint)) {
			//~ $complaint_count = count($complaint);
        //~ } else {
			//~ $complaint_count = 0 ;
        //~ }

//~ $data['client_dashboard_count'] = array(
			//~ array(
			//~ 'name' => 'Proforma Invoice',
			//~ 'value' => $proforma_invoice_count
			//~ ),
			//~ array(
			//~ 'name' => 'Product Sample Request',
			//~ 'value' => $product_sample_request_count
			//~ ),
			//~ array(
			//~ 'name' => 'Client visit',
			//~ 'value' => $client_visit_count
			//~ ),
			//~ array(
			//~ 'name' => 'Complaint Count',
			//~ 'value' => $complaint_count
			//~ )
		//~ );

//~ return $data;
 
    }
    
    function get_client_transaction_details()
    {
        $transaction_details = $this->uri->segment(3);
        $client_id = $this->uri->segment(4);
        //~ $client    = $this->Common_model->getDetails('client', 'client_id', $client_id);
        //~ if (isset($client) && !empty($client)) {
            //~ foreach ($client as $val) {
                //~ $data['client'][] = array(
                    //~ 'client_name' => $val->client_name
                //~ );
            //~ }
        //~ }
		
		switch($transaction_details) {
			case "proforma_invoice":
				$proforma_invoice = $this->Common_model->getDetails('proforma_invoice', 'ref_client_id', $client_id, 'added_date', 'DESC');
                
				if (isset($proforma_invoice) && !empty($proforma_invoice)) {
					foreach ($proforma_invoice as $val) {
						$data['proforma_invoice'][] = array(
							'proforma_invoice_code' => $val->proforma_invoice_code,
							'proforma_invoice_date' => $val->proforma_invoice_date,
							'supplier_name' => $val->supplier_name,
							'company_proforma' => $val->company_proforma,
							'grand_total' =>  $val->grand_total,
							'proforma_invoice_status_name' => $val->proforma_invoice_status_name
						);
					}
				}
				break;
			case "product_sample_request":
				$product_sample_request = $this->Common_model->getDetails('product_sample_request', 'ref_client_id', $client_id, 'added_date', 'DESC');

if (isset($product_sample_request) && !empty($product_sample_request)) {
					foreach ($product_sample_request as $val) {
						$data['product_sample_request'][] = array(
							'product_sample_request_code' => $val->product_sample_request_code,
							'product_sample_request_date' => $val->product_sample_request_date,
							'supplier_name' => $val->supplier_name,
							'product_request_status_name' => $val->product_request_status_name,
							'sample_request_category_name' => $val->sample_request_category_name
						);
					}
				}
				break;
			case "client_visit":
				$client_visit = $this->Common_model->getDetails('client_visit', 'ref_client_id', $client_id, 'client_visit_date', 'DESC');
				if (isset($client_visit) && !empty($client_visit)) {
					foreach ($client_visit as $val) {
						$data['client_visit'][] = array(
							'client_visit_date' => $val->client_visit_date,
							'client_visit_comments' => $val->client_visit_comments,
							'supplier_name' => $val->supplier_name,
							'client_visit_reminder_date' => $val->client_visit_reminder_date
						);
					}
				}
				break;
			case "complaint":
				$complaint = $this->Common_model->getDetails('complaint', 'ref_client_id', $client_id, 'added_date', 'DESC');
				if (isset($complaint) && !empty($complaint)) {
					foreach ($complaint as $val) {
						$data['complaint'][] = array(
							'complaint_no' => $val->complaint_no,
							'receipt_date' => $val->receipt_date,
							'supplier_name' => $val->supplier_name,
							'supplied_invoice_date' => $val->supplied_invoice_date,
							'supplied_invoice_no' => $val->supplied_invoice_no
						);
					}
				}
				break;
		}
        
        echo json_encode($data);
        exit;
    }
    
/*
 * 
 * name: get_clients_outstanding_list 
 *       Get MULTIPLE CLIENTS LIST Under An Employee
 * @param : employee_id
 * @return : clients_list
 * 
 */
    
    function get_clients_outstanding_list()
    {
	    $employee_id               = $this->uri->segment(3);
        $data['client_outstanding_list'] = $this->Dashboard_model->get_clients_outstanding_list($employee_id);
        echo json_encode($data);
        exit;		
	}
    
/*
 * 
 * name: get_client_outstanding_list 
 *       Get Outstanding List of a INDIVIDUAL Client
 * @param : employee_id
 * @return : outstanding list
 * 
 */
    function get_client_outstanding_list()
    {
	    $client_id               = $this->uri->segment(3);
        $data['client_outstanding_list'] = $this->Dashboard_model->get_client_outstanding_list($client_id);
        echo json_encode($data);
        exit;		
	}
	
 /*
 * 
 * name: get_client_pending_purchase_order_list 
 *       Get INDIVIDUAL Pending Purchase of a Client
 * @param : client_id
 * @return : pending purchase order
 * 
 */
    function get_client_pending_purchase_order_list()
    {
	    $client_id               = $this->uri->segment(3);
        $data['client_outstanding_list'] = $this->Client_model->get_pending_purchase_order($client_id);
        echo json_encode($data);
        exit;		
	}

$res         = $this->Api_model->addRecord('client_visit', $visit_entry);
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    
    function invoice_outstanding_reminder()
    {
        $res_purchase_order          = $this->Dashboard_model->get_pending_purchase_order();
        $client_pending_invoice_list = array();
        if (isset($res_purchase_order) && !empty($res_purchase_order)) {
            foreach ($res_purchase_order as $key => $val) {
                $client_pending_invoice_list[$val->client_name][$val->supplier_name][] = $val;
            }
        }
        $data['client_pending_invoice_list'] = $client_pending_invoice_list;
        echo json_encode($data);
        exit;
    }
    function get_invoice_outstanding_client_list()
    {
        $employee_id               = $this->uri->segment(3);
        $res_purchase_order         = $this->Dashboard_model->get_pending_client_purchase_order_by_employee($employee_id);
        $data['client_pending_invoice_list'] = $res_purchase_order;
        echo json_encode($data);
        exit;
    }
    
    function get_invoice_outstanding_supplier_list()
    {
        $client_id               = $this->uri->segment(3);
        $res_purchase_order         = $this->Dashboard_model->get_pending_supplier_purchase_order_by_client($client_id);
        $data['client_pending_invoice_list'] = $res_purchase_order;
        echo json_encode($data);
        exit;
    }
    
     function get_invoice_outstanding_list1()
    {
        $employee_id               = $this->uri->segment(3);
        $res_purchase_order         = $this->Dashboard_model->get_pending_purchase_order_by_employee($employee_id);
        $client_pending_invoice_list = array();
        if (isset($res_purchase_order) && !empty($res_purchase_order)) {
            foreach ($res_purchase_order as $key => $val) {
                $client_pending_invoice_list[$val->client_name][$val->supplier_name][] = $val;
            }
        }
        $data['client_pending_invoice_list'] = $client_pending_invoice_list;
        $data['client_pending_invoice_list'] = $res_purchase_order;
        echo json_encode($data);
        exit;
    }
    
    function get_client_invoice_outstanding_reminder()
    {
        $client_id               = $this->uri->segment(3);
        $res_purchase_order          = $this->Dashboard_model->get_client_pending_purchase_order($client_id);
        $client_pending_invoice_list = array();
        if (isset($res_purchase_order) && !empty($res_purchase_order)) {
            foreach ($res_purchase_order as $key => $val) {
                $client_pending_invoice_list[$val->client_name][$val->supplier_name][] = $val;
            }
        }
        $data['client_pending_invoice_list'] = $client_pending_invoice_list;
        echo json_encode($data);
        exit;
    }
    function client_outstanding_reminder_from_excel()
    {
        $employee_id             = $this->uri->segment(3);
        $res_mainlist            = $this->Common_model->getDetails('client_outstanding', 'ref_employee_id', $employee_id, 'client_name', 'ASC');
        $client_outstanding_list = array();
        if (isset($res_mainlist) && !empty($res_mainlist)) {
            foreach ($res_mainlist as $key => $val) {
                $client_outstanding_list[$val->client_name][$val->company_name][] = $val;
            }
        }
        $data['client_outstanding_list'] = $client_outstanding_list;
        echo json_encode($data);
        exit;
    }
    function product_feedback_reminder()
    {
        $client_feedback_reminder                        = $this->Dashboard_model->get_client_feedback_reminder();
        $data['client_today_feedback_reminder']          = $client_feedback_reminder['today'];
        $data['client_today_feedback_reminder_count']    = count($client_feedback_reminder['today']);
        $data['client_tomorrow_feedback_reminder']       = $client_feedback_reminder['tomorrow'];
        $data['client_tomorrow_feedback_reminder_count'] = count($client_feedback_reminder['tomorrow']);
        $data['client_nextweek_feedback_reminder']       = $client_feedback_reminder['next7days'];
        $data['client_nextweek_feedback_reminder_count'] = count($client_feedback_reminder['next7days']);
        $data['client_pastweek_feedback_reminder']       = $client_feedback_reminder['past7days'];
        $data['client_pastweek_feedback_reminder_count'] = count($client_feedback_reminder['past7days']);
        echo json_encode($data);
        exit;
    }
    function edit_product_sample_feedback_reminder()
    {
        $data                   = json_decode($_POST['product_sample_feedback_reminder']);
        $product_sample_request = (array) $data[0];
        $id                     = $product_sample_request['product_sample_request_id'];
        $res                    = $this->Api_model->updateRecord('product_sample_request', $product_sample_request, $id);
        if ($res) {
            $data1['response'] = '1';
        } else {
            $data1['response'] = '0';
        }
        echo json_encode($data1);
        exit;
    }
    function get_proforma_invoice_list()
    {
        $proforma_invoice = $this->Common_model->getDetails('proforma_invoice', 'delete_status', '0');
        if (isset($proforma_invoice) && !empty($proforma_invoice)) {
            foreach ($proforma_invoice as $val) {
                $data['proforma_invoice_list'][] = array(
                    'proforma_invoice_id' => $val->proforma_invoice_id,
                    'client_name' => $val->client_name,
                    'supplier_name' => $val->supplier_name,
                    'proforma_invoice_date' => $val->proforma_invoice_date,
                    'proforma_invoice_no' => $val->proforma_invoice_no,
                    'proforma_invoice_code' => $val->proforma_invoice_code,
                    'proforma_invoice_file' => $val->proforma_invoice_file,
                    'proforma_invoice_additional_details' => $val->proforma_invoice_additional_details,
                    'proforma_invoice_additional_details' => $val->proforma_invoice_additional_details,
                    'invoice_no' => $val->invoice_no,
                    'invoice_date' => $val->invoice_date,
                    'company_proforma_file' => $val->company_proforma_file
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    function get_product_sample_request_list()
    {
        $product_sample_request = $this->Common_model->getDetails('product_sample_request', 'delete_status', '0');
        if (isset($product_sample_request) && !empty($product_sample_request)) {
            foreach ($product_sample_request as $val) {
                $data['product_sample_request'][] = array(
                    'product_sample_request_id' => $val->product_sample_request_id,
                    'product_sample_request_code' => $val->product_sample_request_code,
                    'product_sample_request_no' => $val->product_sample_request_no,
                    'product_sample_request_date' => $val->product_sample_request_date,
                    'proforma_invoice_no' => $val->proforma_invoice_no,
                    'proforma_invoice_code' => $val->proforma_invoice_code,
                    'proforma_invoice_file' => $val->proforma_invoice_file,
                    'proforma_invoice_additional_details' => $val->proforma_invoice_additional_details,
                    'proforma_invoice_additional_details' => $val->proforma_invoice_additional_details,
                    'invoice_no' => $val->invoice_no,
                    'invoice_date' => $val->invoice_date,
                    'company_proforma_file' => $val->company_proforma_file
                );
            }
        }
        echo json_encode($data);
        exit;
    }
    
    function get_reminder_list()
    {
	$user_id = $this->uri->segment(3);
	$where = " assigned_user_id = ".$user_id." ";
	$order_by = 'ref_status_id ASC';
	$res_reminder = $this->Common_model->getRecords('general_reminder',$where,'',$order_by);

if(isset($res_reminder) && !empty($res_reminder)){
		foreach($res_reminder as $key => $val){
		    $data['reminder_list'][] = array(
				'general_reminder_id' => $val->general_reminder_id,
				'general_reminder_details' => $val->general_reminder_details,
				'assigned_date' => $this->Common_model->getDateFormat($val->assigned_date),
				'completed_date' => $this->Common_model->getDateFormat($val->completed_date),
				'ref_priority_id' => $val->ref_priority_id,
				'priority_name' => $val->priority_name,
				'ref_status_id' => $val->ref_status_id,
				'status_name' => $val->status_name
				);
			}
		}
		else
		{
		    $data['reminder_list'] = null;
		}
		echo json_encode($data);
		exit;
    }
    
        function get_reminder_history()
    {
	$id = $this->uri->segment(3);
	$reminder = $this->Common_model->getDetails('reminder_history','ref_general_reminder_id',$id);

if(isset($reminder) && !empty($reminder)){
	    foreach($reminder as $val){
		$date = $this->Common_model->getDateTimeFormat($val->added_date);
		$data['reminder_history'][] = array(
			'reminder_history_id' => $val->reminder_history_id,
			'details' => $val->details,
			'date' => $date
		);
	    }
	}

echo json_encode($data);
	 exit;
    
    }

function update_reminder_status()
    {
		$reminder = json_decode($_POST['reminder_status_details']);
		$data = (array) $reminder[0];
		
		$general_reminder_id = $data['general_reminder_id'];			
		unset($data['general_reminder_id']);			
		
		$res_reminder_id = $this->Api_model->updateRecord('general_reminder',$data,$general_reminder_id);

if($res_reminder_id){
				$data1['response'] = '1';
		}else{
				$data1['response'] = '0';
		}

echo json_encode($data1);
		exit;
    }

function add_reminder_comment()
    {
		
		$reminder = json_decode($_POST['reminder_details']);
		$data = (array) $reminder[0];
					
		$res_reminder_id = $this->Api_model->addRecord('reminder_history',$data);

if($res_reminder_id){
				$data1['response'] = '1';
		}else{
				$data1['response'] = '0';
		}

echo json_encode($data1);
		exit;
    }
  
      
    
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Api00.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation