���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Customers extends CI_Model { public function __construct() { parent::__construct(); } //Count customer public function count_customer() { return $this->db->count_all("customer_information"); } //Customer List public function customer_list() { $this->db->select('*'); $this->db->from('customer_information'); $this->db->order_by('customer_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Country List public function country_list() { $this->db->select('*'); $this->db->from('countries'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Select City By Country ID List public function select_city_country_id($country_id) { $this->db->select('*'); $this->db->from('states'); $this->db->where('country_id',$country_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result(); } return false; } //Credit customer List public function credit_customer_list() { $query = $this->db->query(" select `customer_information`.`customer_name` AS `customer_name`, `customer_ledger`.`customer_id` AS `customer_id`, 'credit' AS `type`, sum(-(`customer_ledger`.`amount`)) AS `amount` from (`customer_ledger` join `customer_information` on((`customer_information`.`customer_id` = `customer_ledger`.`customer_id`))) where (isnull(`customer_ledger`.`receipt_no`) and (`customer_ledger`.`status` = 1)) group by `customer_ledger`.`customer_id` union all select `customer_information`.`customer_name` AS `customer_name`, `customer_ledger`.`customer_id` AS `customer_id`, 'debit' AS `type`,sum(`customer_ledger`.`amount`) AS `amount` from (`customer_ledger` join `customer_information` on((`customer_information`.`customer_id` = `customer_ledger`.`customer_id`))) where (isnull(`customer_ledger`.`invoice_no`) and (`customer_ledger`.`status` = 1)) group by `customer_ledger`.`customer_id`") ; if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Paid Customer list public function paid_customer_list() { $this->db->select('customer_information.*,sum(customer_transection_summary.amount) as customer_balance'); $this->db->from('customer_information'); $this->db->join('customer_transection_summary', 'customer_transection_summary.customer_id= customer_information.customer_id'); $this->db->where('customer_transection_summary.amount >',0); $this->db->group_by('customer_transection_summary.customer_id'); $this->db->limit('50'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Customer Search List public function customer_search_item($customer_id) { $this->db->select('customer_information.*,sum(customer_transection_summary.amount) as customer_balance'); $this->db->from('customer_information'); $this->db->join('customer_transection_summary', 'customer_transection_summary.customer_id= customer_information.customer_id'); $this->db->where('customer_information.customer_id',$customer_id); $this->db->group_by('customer_transection_summary.customer_id'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Count customer public function customer_entry($data) { $this->db->select('*'); $this->db->from('customer_information'); $this->db->where('customer_name',$data['customer_name']); $query = $this->db->get(); if ($query->num_rows() > 0) { return FALSE; }else{ $this->db->insert('customer_information',$data); $this->db->select('*'); $this->db->from('customer_information'); $this->db->order_by('customer_name','asc'); $query = $this->db->get(); foreach ($query->result() as $row) { $json_customer[] = array('label'=>$row->customer_name,'value'=>$row->customer_id); } $cache_file ='./my-assets/js/admin_js/json/customer.json'; $customerList = json_encode($json_customer); file_put_contents($cache_file,$customerList); return TRUE; } } //Customer Previous balance adjustment public function previous_balance_add($balance,$customer_id) { $this->load->library('auth'); $transaction_id=$this->auth->generator(10); $data=array( 'transaction_id'=> $transaction_id, 'customer_id' => $customer_id, 'invoice_no' => "NA", 'receipt_no' => NULL, 'amount' => $balance, 'description' => "Previous adjustment with software", 'payment_type' => "NA", 'cheque_no' => "NA", 'date' => date("m-d-Y"), 'status' => 1 ); $this->db->insert('customer_ledger',$data); } //Retrieve company Edit Data public function retrieve_company() { $this->db->select('*'); $this->db->from('company_information'); $this->db->limit('1'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer Edit Data public function retrieve_customer_editdata($customer_id) { $this->db->select('*'); $this->db->from('customer_information'); $this->db->where('customer_id',$customer_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer Personal Data public function customer_personal_data($customer_id) { $this->db->select('*'); $this->db->from('customer_information'); $this->db->where('customer_id',$customer_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer Invoice Data public function customer_invoice_data($customer_id) { $this->db->select('*'); $this->db->from('customer_ledger'); $this->db->where(array('customer_id'=>$customer_id,'receipt_no'=>NULL,'status'=>1)); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer Receipt Data public function customer_receipt_data($customer_id) { $this->db->select('*'); $this->db->from('customer_ledger'); $this->db->where(array('customer_id'=>$customer_id,'invoice_no'=>NULL,'status'=>1)); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer All data public function customerledger_tradational($customer_id) { $this->db->select('*'); $this->db->from('customer_ledger'); $this->db->where(array('customer_id'=>$customer_id,'status'=>1)); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Retrieve customer total information public function customer_transection_summary($customer_id) { $result=array(); $this->db->select_sum('amount','total_credit'); $this->db->from('customer_ledger'); $this->db->where(array('customer_id'=>$customer_id,'receipt_no'=>NULL,'status'=>1)); $query = $this->db->get(); if ($query->num_rows() > 0) { $result[]=$query->result_array(); } $this->db->select_sum('amount','total_debit'); $this->db->from('customer_ledger'); $this->db->where(array('customer_id'=>$customer_id,'status'=>1)); $this->db->where('receipt_no !=',NULL); $query = $this->db->get(); if ($query->num_rows() > 0) { $result[]=$query->result_array(); } return $result; } //Update Categories public function update_customer($data,$customer_id) { $this->db->where('customer_id',$customer_id); $this->db->update('customer_information',$data); $this->db->select('*'); $this->db->from('customer_information'); $this->db->order_by('customer_name','asc'); $query = $this->db->get(); foreach ($query->result() as $row) { $json_customer[] = array('label'=>$row->customer_name,'value'=>$row->customer_id); } $cache_file = './my-assets/js/admin_js/json/customer.json'; $customerList = json_encode($json_customer); file_put_contents($cache_file,$customerList); return true; } // Delete customer Item public function delete_customer($customer_id) { $result = $this->db->select('*') ->from('invoice') ->where('customer_id',$customer_id) ->get() ->num_rows(); if ($result > 0) { $this->session->set_userdata(array('error_message'=>display('you_cant_delete_this_customer'))); redirect('dashboard/Ccustomer/manage_customer'); }else{ $this->db->where('customer_id',$customer_id); $this->db->delete('customer_information'); $this->db->select('*'); $this->db->from('customer_information'); $query = $this->db->get(); foreach ($query->result() as $row) { $json_customer[] = array('label'=>$row->customer_name,'value'=>$row->customer_id); } $cache_file = './my-assets/js/admin_js/json/customer.json'; $customerList = json_encode($json_customer); file_put_contents($cache_file,$customerList); return true; } } public function customer_search_list($cat_id,$company_id) { $this->db->select('a.*,b.sub_category_name,c.category_name'); $this->db->from('customers a'); $this->db->join('customer_sub_category b','b.sub_category_id = a.sub_category_id'); $this->db->join('customer_category c','c.category_id = b.category_id'); $this->db->where('a.sister_company_id',$company_id); $this->db->where('c.category_id',$cat_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //get this data for recovery password public function get_user_info($email) { $this->db->select('*'); $this->db->from('customer_information'); $this->db->where('customer_email',$email); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); }else{ return false; } } //insert token to resent password public function set_token($precdat){ $this->db->set('token',$precdat['token']); $this->db->where('customer_email',$precdat['email']); $result = $this->db->update('customer_information'); if($result) { return true; }else{ return false; } } public function password_update($data){ $this->db->where('token',$data['token']); $result = $this->db->get('customer_information')->result(); if(empty($result) || empty($data['token'])){ return false; } $password = md5("gef".$data['password']); $this->db->set('password',$password); $this->db->where('token',$data['token']); $result = $this->db->update('customer_information'); if($result) { $this->db->update('customer_information', array('token' => ''), array('token' => $data['token'])); return true; }else{ return false; } } }