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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Vendor_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function checkVendorUnique($val)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkVendorUnique('".$val."')")->row();
    //$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_vendor($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_vendor('".$data['vendor_name']."','".$data['owner_name']."','".$data['contact_no']."','".$data['address']."','".$data['gst_no']."','".$data['cin_no']."','".$data['pan_no']."',".$data['status'].",'".$data['created_on']."',".$data['created_by'].",".$data['state_id'].",".$data['vendor_type_id'].",".$data['vendor_category_id'].",'".$data['is_tds']."','".$data['tds_percent']."','".$data['is_register']."','".$data['opening_balance']."','".$data['crdr']."')");
    //$this->db->close();
    return $result;
  }
  public function vendor_active($id, $data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL vendor_active(".$id.",".$data.")");
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function checkVendorUniqueEdit($val,$bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkVendorUniqueEdit('".$val."','".$bid."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function update_vendor($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_vendor('".$data['vendor_name']."','".$data['owner_name']."','".$data['contact_no']."','".$data['address']."','".$data['gst_no']."','".$data['cin_no']."','".$data['pan_no']."',".$data['vendor_id'].",'".$data['modified_on']."',".$data['modified_by'].",".$data['state_id'].",".$data['vendor_type_id'].",".$data['vendor_category_id'].",'".$data['is_tds']."','".$data['tds_percent']."','".$data['is_register']."','".$data['opening_balance']."','".$data['crdr']."')");
    //$this->db->close();
    return $result;
  }
  public function vendor_delete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL vendor_delete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_vendorcategory_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendorcategory_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL vendor_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function create_vendor_opening_balance($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_vendor_opening_balance('".$data['vendor_id']."','".$data['location_id']."','".$data['opening_balance']."','".$data['crdr']."')");
    //$this->db->close();
    return $result;
  }
  public function get_vendor_opening_bal_by_vendor_loc_id($vid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_opening_bal_by_vendor_loc_id('".$vid."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function delete_vendor_opening_balance($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_vendor_opening_balance('".$id."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Vendor_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation