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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Salesreport_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_code LIKE '%".$postData['search']."%' OR 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_code.' - '.$row->customer_name.' - '.$row->phone_no);
       }

}

return $response;
  }

public function get_active_location()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_location()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_category()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_category()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_list()")->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_active_rawmaterial_gsm()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_rawmaterial_gsm()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_rawmaterial_color()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_rawmaterial_color()")->result_array();
    //$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_basic_sales_report_list($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_basic_sales_report_list('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_basic_sales_register_invoice_list($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_basic_sales_register_invoice_list('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterialcategory_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterialcategory_list()")->result_array();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Salesreport_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation