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

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

function getledgercustomervendorList($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);
       }

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

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

}

return $response;
  }

public function get_account_journal_by_date($date)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_date('".$date."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_employee_by_id($eid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_employee_by_id('".$eid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($vid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$vid."')")->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_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_phone_by_customer_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_phone_by_customer_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_category_by_atype_id($atid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_category_by_atype_id('".$atid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_attributes_by_acat_id($acid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_attributes_by_acat_id('".$acid."')")->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_active_employee()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_employee()")->result_array();
    //$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_vendor_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function create_accountjournal($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_accountjournal('".$data['account_journal_date']."','".$data['type']."','".$data['account_attributes_id']."','".$data['amount']."','".$data['paid_status']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['created_on']."',".$data['created_by'].",'".$data['vendor_id']."','".$data['others']."','".$data['attributes_id']."','".$data['remarks']."','".$data['location_id']."','".$data['ledger_list1_id']."','".$data['ledger_list2_id']."','".$data['ledger_list1_type']."','".$data['ledger_list2_type']."')");
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_by_date_and_aaid($date,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_date_and_aaid('".$date."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_by_daterange_and_aaid($fdate,$tdate,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_daterange_and_aaid('".$fdate."','".$tdate."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_by_id($acid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_by_id('".$acid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_accountjournal($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_accountjournal('".$data['account_journal_date']."','".$data['type']."','".$data['account_attributes_id']."','".$data['amount']."','".$data['paid_status']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['vendor_id']."','".$data['others']."','".$data['attributes_id']."','".$data['remarks']."','".$data['account_journal_id']."','".$data['location_id']."','".$data['ledger_list1_id']."','".$data['ledger_list2_id']."','".$data['ledger_list1_type']."','".$data['ledger_list2_type']."')");
    //$this->db->close();
    return $result;
  }
  public function accountjournal_delete($apid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL accountjournal_delete('".$apid."')");
    //$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 get_user_account_journal_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_journal_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_journal_by_daterange($fdate,$tdate,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_journal_by_daterange('".$fdate."','".$tdate."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_journal_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_journal_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_journal_by_daterange($fdate,$tdate,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_journal_by_daterange('".$fdate."','".$tdate."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_comp_id($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$punit."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_ledger_list_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function account_journal_approve($apid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL account_journal_approve('".$apid."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountjournal_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation