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

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

function getcustomerList($postData){

$response = array();

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

$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"=>$row->customer_id,"label"=>$row->customer_name.' - '.$row->phone_no);
       }

}

return $response;
  }

function getvendorList($postData){

$response = array();

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

$customerrecords = $this->db->query("SELECT * FROM vendor WHERE (vendor_name LIKE '%".$postData['search']."%' OR contact_no LIKE '%".$postData['search']."%')")->result();

foreach($customerrecords as $row ){
          $response[] = array("value"=>$row->vendor_id,"label"=>$row->vendor_name.' - '.$row->contact_no);
       }

}

return $response;
  }

/*public function get_ledger_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_ledgersubgroup_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledgersubgroup_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function create_ledger($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_ledger('".$data['ledger_sub_group_id']."','".$data['amount']."',".$data['status'].",'".$data['created_on']."',".$data['created_by'].",'".$data['ledger_date']."')");
    //$this->db->close();
    return $result;
  }
  public function get_approval_ledger_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_approval_ledger_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function approve_ledger($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL approve_ledger('".$data['ledger_id']."',".$data['status'].",'".$data['modified_on']."',".$data['modified_by'].")");
    //$this->db->close();
    return $result;
  }
  public function get_ledger_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_by_id('".$id."')")->row();
    //$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;
  }
  public function get_customer_view_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_view_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }*/
  public function get_customer_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_vendor()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_vendor()")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_location_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_list()")->result_array();
    //$this->db->close();
    return $result;
  }

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

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

public function get_ledgergroup_by_id($val)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledgergroup_by_id('".$val."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_ledger_list_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function create_ledger_list($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_ledger_list('".$data['ledger_list']."',".$data['status'].",'".$data['created_on']."',".$data['created_by'].",'".$data['type']."','".$data['account_attributes_id']."','".$data['location_id']."','".$data['remarks']."','".$data['opening_balance']."','".$data['ledger_code']."','".$data['crdr']."','".$data['tax_ledger_status']."')");
    //$this->db->close();
    return $result;
  }
  /*public function ledger_list_active($id, $data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL ledger_list_active(".$id.",".$data.")");
    //$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 checkLedgerUniqueEdit($val,$bid,$locid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkLedgerUniqueEdit('".$val."','".$bid."','".$locid."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function update_ledger_list($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_ledger_list('".$data['ledger_list']."',".$data['ledger_list_id'].",'".$data['modified_on']."',".$data['modified_by'].",'".$data['type']."','".$data['account_attributes_id']."','".$data['location_id']."','".$data['remarks']."','".$data['opening_balance']."','".$data['ledger_code']."','".$data['crdr']."','".$data['tax_ledger_status']."')");
    //$this->db->close();
    return $result;
  }
  public function ledger_list_delete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL ledger_list_delete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_ledger_details()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_details()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_amt_by_ledger_list_id($llid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_amt_by_ledger_list_id('".$llid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_receipt_oamt_by_ledger_list_id($llid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_oamt_by_ledger_list_id('".$llid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_amt_by_ledger_list_id($llid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_amt_by_ledger_list_id('".$llid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_oamt_by_ledger_list_id($llid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_oamt_by_ledger_list_id('".$llid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_voucher_amt_by_ledger_list_id($llid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_voucher_amt_by_ledger_list_id('".$llid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_ledgersubgroup_by_id($lsgid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledgersubgroup_by_id('".$lsgid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_ledger_details_view($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_details_view('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_view_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_view_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_view_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_view_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_view_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_view_by_id('".$cid."')")->row();
    //$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;
  }
  public function get_ledger_details_view_by_custom_date($fdate,$tdate,$id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_details_view_by_custom_date('".$fdate."','".$tdate."','".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_from_credit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_from_credit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_credit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_credit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_debit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_debit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_debit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_debit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_bank_by_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_bank_by_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_expense_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_expense_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_voucher_group()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_voucher_group()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_expense_voucher_group()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_expense_voucher_group()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_from_credit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_credit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_from_debit_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_debit_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_invoice_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_invoice_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_by_id($ajid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_id('".$ajid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function delete_tax_ledger_line_item_by_purid($purid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_tax_ledger_line_item_by_purid('".$purid."')");
    //$this->db->close();
    return $result;
  }
  public function get_so_invoice_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_invoice_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dir_invoice_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dir_invoice_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_payable_ledger_from_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payable_ledger_from_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_staff_expense_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_staff_expense_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_credit_note_by_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_note_by_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_note_by_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_note_by_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    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 get_deduction_ledger_from_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_deduction_ledger_from_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_allowance_ledger_from_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_allowance_ledger_from_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_fixed_asset_ledger_line_item_from_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_fixed_asset_ledger_line_item_from_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_credit_receipt_for_pl_by_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_receipt_for_pl_by_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_receipt_for_pl_by_ledger_list_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_receipt_for_pl_by_ledger_list_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Ledger_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation