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;
}
}
}