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: Creditdebit_model.php

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

function getinvoicelist($postData){

$response = array();

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

$invoice = $this->db->query("SELECT * FROM invoice WHERE invoice_no LIKE '%".$postData['search']."%'")->result();

foreach($invoice as $row ){
          $response[] = array("value"=>$row->invoice_id,"label"=>$row->invoice_no);
       }
       $response[] = array("value"=>'others',"label"=>'Others');

}

return $response;
  }

function getpurchaselist($postData){

$response = array();

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

$purchaselist = $this->db->query("SELECT * FROM purchase WHERE purchase_no LIKE '%".$postData['search']."%' AND status!=0")->result();

foreach($purchaselist as $row ){
          $response[] = array("value"=>'Purchase-'.$row->purchase_id,"label"=>$row->purchase_no);
       }

if($postData['credeb']=='Debit')
       {
         $expenselist = $this->db->query("SELECT * FROM expense WHERE expense_no LIKE '%".$postData['search']."%' AND status=0")->result();

foreach($expenselist as $row ){
            $response[] = array("value"=>'Expense-'.$row->expense_id,"label"=>$row->expense_no);
         }
       }

$response[] = array("value"=>'others',"label"=>'Others');

}

return $response;
  }

function getcustomerlist($postData){

$response = array();

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

$customerlist = $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($customerlist as $row ){
          $response[] = array("value"=>$row->customer_id,"label"=>$row->customer_name.' - '.$row->phone_no);
       }

}

return $response;
  }

public function get_customer_list()
  {    
    $result = $this->db->query("CALL get_customer_list()")->result_array();    
    return $result;
  }
  public function get_vendor_list()
  {    
    $result = $this->db->query("CALL get_vendor_list()")->result_array();    
    return $result;
  }
  public function get_full_invoice_list()
  {    
    $result = $this->db->query("CALL get_full_invoice_list()")->result_array();    
    return $result;
  }
  public function get_purchase_list()
  {    
    $result = $this->db->query("CALL get_purchase_list()")->result_array();    
    return $result;
  }
  public function get_credit_debit_list_by_date($cdate)
  {    
    $result = $this->db->query("CALL get_credit_debit_list_by_date('".$cdate."')")->result_array();    
    return $result;
  }
  public function get_credit_debit_list_by_daterange($fdate,$tdate)
  {    
    $result = $this->db->query("CALL get_credit_debit_list_by_daterange('".$fdate."','".$tdate."')")->result_array();    
    return $result;
  }
  public function get_invoice_by_invoice_id($iid)
  {    
    $result = $this->db->query("CALL get_invoice_by_invoice_id('".$iid."')")->row();    
    return $result;
  }
  public function get_purchase_by_id($purid)
  {    
    $result = $this->db->query("CALL get_purchase_by_id('".$purid."')")->row();    
    return $result;
  }
  public function get_customer_by_id($cid)
  {    
    $result = $this->db->query("CALL get_customer_by_id('".$cid."')")->row();    
    return $result;
  }
  public function get_vendor_by_id($vid)
  {    
    $result = $this->db->query("CALL get_vendor_by_id('".$vid."')")->row();    
    return $result;
  }
  public function create_creditdebit($data)
  {    
    $result = $this->db->query("CALL create_creditdebit('".$data['credit_debit_note_date']."','".$data['credit_debit']."','".$data['type_id']."','".$data['other_type']."','".$data['customer_id']."','".$data['vendor_id']."','".$data['particulars']."','".$data['ledger_list_id']."','".$data['amount']."','".$data['remarks']."','".$data['created_on']."',".$data['created_by'].",".$data['location_id'].",".$data['cr_dr'].",'".$data['debit_type']."')");    
    return $result;
  }
  public function creditdebit_delete($apid)
  {    
    $result = $this->db->query("CALL creditdebit_delete('".$apid."')");    
    return $result;
  }
  public function get_credit_debit_note_by_id($cdnid)
  {    
    $result = $this->db->query("CALL get_credit_debit_note_by_id('".$cdnid."')")->row();    
    return $result;
  }
  public function update_creditdebit($data)
  {    
    $result = $this->db->query("CALL update_creditdebit('".$data['credit_debit_note_date']."','".$data['credit_debit']."','".$data['type_id']."','".$data['other_type']."','".$data['customer_id']."','".$data['vendor_id']."','".$data['particulars']."','".$data['ledger_list_id']."','".$data['amount']."','".$data['remarks']."','".$data['modified_on']."',".$data['modified_by'].",".$data['credit_debit_note_id'].",".$data['location_id'].",".$data['cr_dr'].",'".$data['debit_type']."')");    
    return $result;
  }
  public function get_ledger_list_by_id($llid)
  {    
    $result = $this->db->query("CALL get_ledger_list_by_id('".$llid."')")->row();    
    return $result;
  }
  public function get_order_by_id($oid)
  {    
    $result = $this->db->query("CALL get_order_by_id('".$oid."')")->row();    
    return $result;
  }
  public function get_grn_by_id($gid)
  {    
    $result = $this->db->query("CALL get_grn_by_id('".$gid."')")->row();    
    return $result;
  }
  public function get_expense_by_id($cid)
  {    
    $result = $this->db->query("CALL get_expense_by_id('".$cid."')")->row();    
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Creditdebit_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation