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 Receipts extends CI_Model {
public function __construct()
{
parent::__construct();
}
//Count receipt
public function count_receipt()
{
$this->db->select('receipt_no');
$this->db->from('customer_ledger');
$this->db->where('status',1);
$query = $this->db->get();
return $query->num_rows();
}
//receipt List
public function receipt_list($limit,$page)
{
$this->db->select('a.customer_id,a.customer_name,b.transaction_id,b.receipt_no,b.amount,b.date');
$this->db->from('customer_information a');
$this->db->join('customer_ledger b','b.customer_id = a.customer_id');
$this->db->where('b.status',1);
$this->db->where('b.receipt_no !=','');
$this->db->limit($limit, $page);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Search Receipt By Customer Name
public function search_receipt_item($customer_id)
{
$this->db->select('a.customer_id,a.customer_name,b.transaction_id,b.receipt_no,b.amount,b.date');
$this->db->from('customer_information a');
$this->db->join('customer_ledger b','b.customer_id = a.customer_id');
$this->db->where('b.status',1);
$this->db->where('b.receipt_no !=',0);
$this->db->where('a.customer_id',$customer_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Count receipt
public function receipt_entry($data)
{
$this->db->insert('customer_ledger',$data);
return true;
}
//Retrieve receipt Edit Data
public function retrieve_receipt_editdata($receipt_id)
{
$this->db->select('a.customer_id,a.customer_name,b.transaction_id,b.description,b.receipt_no,b.amount,b.date');
$this->db->from('customer_information a');
$this->db->join('customer_ledger b','b.customer_id = a.customer_id');
$this->db->where('b.receipt_no',$receipt_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Update Categories
public function update_receipt($receipt_id,$data)
{
$this->db->where('receipt_no',$receipt_id);
$this->db->update('customer_ledger',$data);
}
}