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