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/demo.sigmacomputers.in/public_html/arjun_erp/application/models

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: Accountreceipt_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Accountreceipt_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }

function getledgercustomerList($postData){

$response = array();

if(isset($postData['search']) ){

$ledgerrecords = $this->db->query("SELECT ll.*,l.location_name FROM ledger_list ll, location l WHERE ll.location_id = l.location_id AND (ll.ledger_list LIKE '%".$postData['search']."%' OR l.location_name LIKE '%".$postData['search']."%')")->result();

foreach($ledgerrecords as $row ){
          $response[] = array("value"=>'ledger-'.$row->ledger_list_id,"label"=>$row->location_name.' - '.$row->ledger_list);
       }

$customerrecords = $this->db->query("SELECT c.*,cp.phone_no FROM customer c, customer_phone cp WHERE cp.customer_id = c.customer_id AND (c.customer_name LIKE '%".$postData['search']."%' OR cp.phone_no LIKE '%".$postData['search']."%')")->result();

foreach($customerrecords as $row ){
          $response[] = array("value"=>'customer-'.$row->customer_id,"label"=>$row->customer_name.' - '.$row->phone_no);
       }

}

return $response;
  }

function getBillByCompany($postData,$finstart,$finend){

$response = array();

if(isset($postData['search']) ){

$so_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname,c.customer_id as cust_id FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id AND o.location_id='".$postData['cid']."' AND STR_TO_DATE(o.order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(o.order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') AND (c.customer_name LIKE '%".$postData['search']."%' OR o.order_no LIKE '%".$postData['search']."%') GROUP BY o.order_id ORDER BY o.order_id DESC")->result();

foreach($so_list as $row ){
          $soreceiptTot = $this->get_so_receipt_total_by_so_id($row->order_id);
          $cusDetails = $this->get_customer_contact_details($row->cust_id);
          $pno = $cusDetails->phone_no;
        if($soreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->order_id.'-SO',"label"=>$row->order_no.' - '.$row->customer_name.' - '.$pno);
        }
       }

$inv_list = $this->db->query("SELECT i.*,c.customer_name,c.customer_id as cust_id FROM invoice i,`order` o,customer c WHERE i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.order_id!=0 AND o.location_id='".$postData['cid']."' AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') AND (c.customer_name LIKE '%".$postData['search']."%' OR i.invoice_no LIKE '%".$postData['search']."%') ORDER BY i.invoice_id DESC")->result();

foreach($inv_list as $row ){
          $invreceiptTot = $this->get_inv_receipt_total_by_inv_id($row->invoice_id);
          $cusDetails = $this->get_customer_contact_details($row->cust_id);
          $pno = $cusDetails->phone_no;
        if($invreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->invoice_id.'-INVC',"label"=>$row->invoice_no.' - '.$row->customer_name.' - '.$pno);
        }
       }

$direct_invoice = $this->db->query("SELECT i.*,c.customer_name,c.customer_id as cust_id FROM invoice i,customer c WHERE i.customer_id = c.customer_id AND i.customer_id!=0 AND i.location_id='".$postData['cid']."' AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') AND (c.customer_name LIKE '%".$postData['search']."%' OR i.invoice_no LIKE '%".$postData['search']."%') ORDER BY i.invoice_id DESC")->result();

foreach($direct_invoice as $row ){
          $invreceiptTot = $this->get_inv_receipt_total_by_inv_id($row->invoice_id);
          $cusDetails = $this->get_customer_contact_details($row->cust_id);
          $pno = $cusDetails->phone_no;
        if($invreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->invoice_id.'-INV',"label"=>$row->invoice_no.' - '.$row->customer_name.' - '.$pno);
        }
       }

}

return $response;
  }

function getBillDetails($postData){

$response = array();

if(isset($postData['search']) ){

$so_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id AND (c.customer_name LIKE '%".$postData['search']."%' OR o.order_no LIKE '%".$postData['search']."%') GROUP BY o.order_id ORDER BY o.order_id DESC")->result();

foreach($so_list as $row ){
          $soreceiptTot = $this->get_so_receipt_total_by_so_id($row->order_id);
        if($soreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->order_id.'-SO',"label"=>$row->order_no.' - '.$row->customer_name);
        }
       }

$inv_list = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,`order` o,customer c WHERE i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.order_id!=0 AND (c.customer_name LIKE '%".$postData['search']."%' OR i.invoice_no LIKE '%".$postData['search']."%') ORDER BY i.invoice_id DESC")->result();

foreach($inv_list as $row ){
          $invreceiptTot = $this->get_inv_receipt_total_by_inv_id($row->invoice_id);
        if($invreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->invoice_id.'-INVC',"label"=>$row->invoice_no.' - '.$row->customer_name);
        }
       }

$direct_invoice = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,customer c WHERE i.customer_id = c.customer_id AND i.customer_id!=0 AND (c.customer_name LIKE '%".$postData['search']."%' OR i.invoice_no LIKE '%".$postData['search']."%') ORDER BY i.invoice_id DESC")->result();

foreach($direct_invoice as $row ){
          $invreceiptTot = $this->get_inv_receipt_total_by_inv_id($row->invoice_id);
        if($invreceiptTot->amt<$row->grand_total){
          $response[] = array("value"=>$row->invoice_id.'-INV',"label"=>$row->invoice_no.' - '.$row->customer_name);
        }
       }

}

return $response;
  }
  function get_all_other_ledgers()
  {
    $result = $this->db->query("SELECT ll.*,l.location_name FROM ledger_list ll, location l WHERE ll.location_id = l.location_id")->result_array();
    
    return $result;
  }
  function get_all_other_customer()
  {
    $result = $this->db->query("SELECT c.*,cp.phone_no FROM customer c, customer_phone cp WHERE cp.customer_id = c.customer_id")->result_array();
    
    return $result;
  }
  public function get_account_order_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_order_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_view_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_view_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_view_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_view_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_by_date($date)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_by_date('".$date."')")->result_array();
    //$this->db->close();
    return $result;
  }
  /*public function create_accountreceipt($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_accountreceipt('".$data['account_receipt_date']."','".$data['user_type']."','".$data['user_id']."','".$data['payment_type']."','".$data['account_attributes_id']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['created_on']."',".$data['created_by'].")");
    //$this->db->close();
    return $result;
  }*/
  public function create_accountreceipt($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_accountreceipt('".$data['account_receipt_date']."','".$data['payment_type']."','".$data['expense_type']."','".$data['particulars']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['created_on']."',".$data['created_by'].",'".$data['user_id']."','".$data['user_type']."','".$data['ledger_list_id']."','".$data['remarks']."','".$data['parti_ledger_list_id']."','".$data['parti_ledger_list_type']."','".$data['amount']."')");
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_by_date_and_aaid($date,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_by_date_and_aaid('".$date."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_by_daterange_and_aaid($fdate,$tdate,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_by_daterange_and_aaid('".$fdate."','".$tdate."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_accountreceipt($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_accountreceipt('".$data['account_receipt_date']."','".$data['payment_type']."','".$data['expense_type']."','".$data['particulars']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['user_id']."','".$data['user_type']."','".$data['ledger_list_id']."','".$data['account_receipt_id']."','".$data['remarks']."','".$data['parti_ledger_list_id']."','".$data['parti_ledger_list_type']."','".$data['amount']."')");
    //$this->db->close();
    return $result;
  }
  public function get_ledger_list_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function accountreceipt_delete($arid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL accountreceipt_delete('".$arid."')");
    //$this->db->close();
    return $result;
  }
  public function get_so_receipt_total_by_so_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_receipt_total_by_so_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_inv_receipt_total_by_inv_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_inv_receipt_total_by_inv_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_receipt_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_receipt_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_receipt_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_receipt_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_direct_invoice($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_direct_invoice('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_ledger_list_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_ledger_list_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_location_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_location_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_direct_invoice($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_direct_invoice('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_ledger_list_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_ledger_list_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_location_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_location_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_order_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_order_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_invoice_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_invoice_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_invoice_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_invoice_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_invoice_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_invoice_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_view_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_view_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_direct_so_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_direct_so_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_active_financial_year()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_financial_year()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_financial_year_by_id($fyid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_financial_year_by_id('".$fyid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function account_receipt_approve($arid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL account_receipt_approve('".$arid."')");
    //$this->db->close();
    return $result;
  }

public function get_customer_contact_details($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_contact_details('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountreceipt_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation