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.1 TB

🔧 Quick Actions

✏️ Editing: Productproperty_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Productproperty_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_product_property_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_property_list()")->result_array();
    //$this->db->close();
    return $result;
  }

//To Check property name Unique
    public function product_property_unique($name)
    {
        //$this->db->reconnect();
        $result = $this->db->query("CALL product_property_unique('".$name."')")->row();
        //$this->db->close();
        return $result;
    }

//To Insert property
    public function product_property_add($data)
    {
        //$this->db->reconnect();
        $result = $this->db->query("CALL product_property_add('".$data['name']."','".$data['created_by']."','".$data['created_on']."','".$data['status']."')");
        //$this->db->close();
        return $result;
    }

//To Check sub property name Unique
    public function product_subproperty_unique($name,$proid)
    {
        //$this->db->reconnect();
        $result = $this->db->query("CALL product_subproperty_unique('".$name."','".$proid."')")->row();
        //$this->db->close();
        return $result;
    }

//To Insert sub property
    public function product_subproperty_add($data)
    {
        //$this->db->reconnect();
        $result = $this->db->query("CALL product_subproperty_add('".$data['property_id']."','".$data['name']."','".$data['status']."','".$data['created_on']."','".$data['created_by']."')");
        //$this->db->close();
        return $result;
    }

//To Get property by id
    public function product_property_by_id($id)
    {
        //$this->db->reconnect();
        $result = $this->db->query("call product_property_by_id(".$id.")");
        $res = $result->result_array();
        //$this->db->close();
        return $res;
    }

//To Get sub property by id
    public function product_subproperty_by_id($id)
    {
        //$this->db->reconnect();
        $result = $this->db->query("call product_subproperty_by_id(".$id.")");
        $res = $result->result_array();
        //$this->db->close();
        return $res;
    }

//To Check sub property name Unique
    public function product_subproperty_edit_unique($name,$id,$pid)
    {
        //$this->db->reconnect();
        $result = $this->db->query("CALL product_subproperty_edit_unique('".$name."','".$id."','".$pid."')")->row();
        //$this->db->close();
        return $result;
    }

//To update property settings
    public function product_property_update($data)
    {
        //$this->db->reconnect();
        $result = $this->db->query("call product_property_update('".$data['name']."','".$data['modified_by']."','".$data['modified_on']."','".$data['pid']."')");
        //$this->db->close();
        return $result;
    }

//To Delete sub property 
    public function product_subproperty_delete($id)
    {
        //$this->db->reconnect();
        $result = $this->db->query("call product_subproperty_delete('".$id."')");
        //$this->db->close();
        return $result;
    }

//To update sub property 
    public function product_subproperty_update($data,$id)
    {
        //$this->db->reconnect();
        $result = $this->db->query("call product_subproperty_update('".$data['name']."','".$data['modified_by']."','".$data['modified_on']."','".$id."')");
        //$this->db->close();
        return $result;
    }

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Productproperty_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation