Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Products extends CI_Model
{
public function __construct()
{
parent::__construct();
}
//Count Product
public function count_product()
{
return $this->db->count_all("product_information");
}
//Product List Count
public function product_list_count($filter = null)
{
$this->db->select('product_information.product_id');
$this->db->from('product_information');
$this->db->join('supplier_information', 'product_information.supplier_id = supplier_information.supplier_id', 'left');
$this->db->join('product_category', 'product_category.category_id = product_information.category_id', 'left');
$this->db->join('unit', 'unit.unit_id = product_information.unit', 'left');
if(!empty($filter['product_name'])){
$this->db->like('product_information.product_name', $filter['product_name'],'both');
}
if(!empty($filter['supplier_id'])){
$this->db->where('product_information.supplier_id', $filter['supplier_id']);
}
if(!empty($filter['category_id'])){
$this->db->where('product_information.category_id', $filter['category_id']);
}
if(!empty($filter['unit_id'])){
$this->db->where('product_information.unit', $filter['unit_id']);
}
if(!empty($filter['model_no'])){
$this->db->like('product_information.product_model', $filter['model_no'],'both');
}
$this->db->group_by('product_information.product_id');
$query = $this->db->get();
return $query->num_rows();
}
//Product List
public function product_list($filter = null,$per_page = null, $page = null)
{
$is_aff = false;
if(check_module_status('affiliate_products') == 1){
$is_aff = true;
}
$this->db->select('
supplier_information.supplier_name,
product_information.product_id,
product_information.product_name,
product_information.product_model,
product_information.unit,
product_information.price,
product_information.supplier_price,
product_information.onsale_price,
product_information.image_thumb,
product_category.category_name,
unit.unit_short_name');
$this->db->from('product_information');
$this->db->join('supplier_information', 'product_information.supplier_id = supplier_information.supplier_id', 'left');
$this->db->join('product_category', 'product_category.category_id = product_information.category_id', 'left');
$this->db->join('unit', 'unit.unit_id = product_information.unit', 'left');
if(!empty($filter['product_name'])){
$this->db->like('product_information.product_name', $filter['product_name'],'both');
}
if(!empty($filter['supplier_id'])){
$this->db->where('product_information.supplier_id', $filter['supplier_id']);
}
if(!empty($filter['category_id'])){
$this->db->where('product_information.category_id', $filter['category_id']);
}
if(!empty($filter['unit_id'])){
$this->db->where('product_information.unit', $filter['unit_id']);
}
if(!empty($filter['model_no'])){
$this->db->like('product_information.product_model', $filter['model_no'],'both');
}
if($is_aff){
$this->db->where('product_information.is_affiliate IS NULL');
}
$this->db->limit($per_page, $page);
$this->db->order_by('product_information.product_name','asc');
$this->db->group_by('product_information.product_id');
$query = $this->db->get();
if ($query->num_rows() > 0){
return $query->result_array();
}
return false;
}
//get store wise product when product transfer to another store
public function get_product_list_by_store($store_id)
{
$query = $this->db->select('a.*')
->from('product_information a')
->join('transfer b', 'a.product_id = b.product_id')
->where('store_id=', $store_id)
->group_by('a.product_name')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
// Retrive Products
public function retrive_products($product_name)
{
$this->db->select('*');
$this->db->from('product_information');
$this->db->like('product_name', $product_name, 'both');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//All Product List
public function all_product_list()
{
$query = $this->db->select('
supplier_information.*,
product_information.*,
product_category.category_name,
unit.unit_short_name
')
->from('product_information')
->join('supplier_information', 'product_information.supplier_id = supplier_information.supplier_id', 'left')
->join('product_category', 'product_category.category_id = product_information.category_id', 'left')
->join('unit', 'unit.unit_id = product_information.unit', 'left')
->order_by('product_information.product_name', 'asc')
->group_by('product_information.product_id')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//All Supplier List
public function all_supplier_list()
{
$query = $this->db->select('supplier_information.*')
->from('supplier_information')
->order_by('supplier_information.supplier_name', 'asc')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//all_category_list
public function all_category_list()
{
$query = $this->db->select('product_category.*')
->from('product_category')
->order_by('product_category.category_name', 'asc')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//All Unit List
public function all_unit_list()
{
$query = $this->db->select('unit.*')
->from('unit')
->order_by('unit.unit_name', 'asc')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Tax selected item
public function tax_selected_item($tax_id)
{
$result = $this->db->select('*')
->from('tax_information')
->where('tax_id', $tax_id)
->get()
->result();
return $result;
}
//Product generator id check
public function product_id_check($product_id)
{
$query = $this->db->select('*')
->from('product_information')
->where('product_id', $product_id)
->get();
if ($query->num_rows() > 0) {
return true;
} else {
return false;
}
}
//Count Product
public function product_entry($data)
{
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('status', 1);
$this->db->where('product_model', $data['product_model']);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return FALSE;
} else {
$result = $this->db->insert('product_information', $data);
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('status', 1);
$query = $this->db->get();
foreach ($query->result() as $row) {
$json_product[] = array('label' => $row->product_name . "-(" . $row->product_model . ")", 'value' => $row->product_id);
}
$cache_file = './my-assets/js/admin_js/json/product.json';
$productList = json_encode($json_product);
file_put_contents($cache_file, $productList);
return $result;
}
}
//Retrieve Product Edit Data
public function retrieve_product_editdata($product_id)
{
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('product_id', $product_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Retrieve company Edit Data
public function retrieve_company()
{
$this->db->select('*');
$this->db->from('company_information');
$this->db->limit('1');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Update Categories
public function update_product($data, $product_id)
{
$this->db->where('product_id', $product_id);
$this->db->update('product_information', $data);
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('status', 1);
$query = $this->db->get();
foreach ($query->result() as $row) {
$json_product[] = array('label' => $row->product_name . "-(" . $row->product_model . ")", 'value' => $row->product_id);
}
$cache_file = './my-assets/js/admin_js/json/product.json';
$productList = json_encode($json_product);
file_put_contents($cache_file, $productList);
return true;
}
//Get variant prices
public function get_product_variant_prices($product_id)
{
$result = $this->db->select('*')
->from('product_variants')
->where('product_id', $product_id)
->get()->result();
return $result;
}
// Delete Product Item
public function delete_product($product_id)
{
#### Check product is using on system or not##########
# If this product is used any calculation you can't delete this product.
# but if not used you can delete it from the system.
$this->db->select('product_id');
$this->db->from('product_purchase_details');
$this->db->where('product_id', $product_id);
$query = $this->db->get();
$affected_row = $query->num_rows();
if ($affected_row == 0) {
//product image delete
$product_info = $this->db->select('image_large_details, image_thumb')->from('product_information')->where('product_id',$product_id)->get()->result();
if($product_info){
@unlink(FCPATH.$product_info->image_large_details);
@unlink(FCPATH.$product_info->image_thumb);
}
//product gallery image delete
$gallery_images = $this->db->select('image_url')->from('image_gallery')->where('product_id',$product_id)->get()->result();
if($gallery_images) {
foreach ($gallery_images as $gallery_image) {
@unlink(FCPATH.$gallery_image->image_url);
}
}
$this->db->where('product_id', $product_id);
$this->db->delete('image_gallery');
$this->db->where('product_id', $product_id);
$this->db->delete('product_information');
$this->session->set_userdata(array('message' => display('successfully_delete')));
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('status', 1);
$query = $this->db->get();
foreach ($query->result() as $row) {
$json_product[] = array('label' => $row->product_name . "-(" . $row->product_model . ")", 'value' => $row->product_id);
}
$cache_file = './my-assets/js/admin_js/json/product.json';
$productList = json_encode($json_product);
file_put_contents($cache_file, $productList);
redirect('dashboard/Cproduct/manage_product');
} else {
$this->session->set_userdata(array('error_message' => display('you_cant_delete_this_product')));
redirect('dashboard/Cproduct/manage_product');
}
}
//Product By Search
public function product_search_item($product_id)
{
$query = $this->db->select('
supplier_information.*,
product_information.*,
product_category.category_name,
unit.unit_short_name
')
->from('product_information')
->join('supplier_information', 'product_information.supplier_id = supplier_information.supplier_id', 'left')
->join('product_category', 'product_category.category_id = product_information.category_id', 'left')
->join('unit', 'unit.unit_id = product_information.unit', 'left')
->where('product_information.product_id', $product_id)
->order_by('product_information.product_name', 'desc')
->group_by('product_information.product_id')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//Duplicate Entry Checking
public function product_model_search($product_model)
{
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('product_model', $product_model);
$query = $this->db->get();
return $this->db->affected_rows();
}
//Product Details
public function product_details_info($product_id)
{
$this->db->select('*');
$this->db->from('product_information');
$this->db->where('product_id', $product_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
// Product Purchase Report
public function product_purchase_info($product_id)
{
$this->db->select('a.*,b.*,c.supplier_name, d.variant_name');
$this->db->from('product_purchase a');
$this->db->join('product_purchase_details b', 'b.purchase_id = a.purchase_id','left');
$this->db->join('supplier_information c', 'c.supplier_id = a.supplier_id','left');
$this->db->join('variant d', 'd.variant_id = b.variant_id','left');
$this->db->where('b.product_id', $product_id);
$this->db->order_by('a.purchase_id', 'asc');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
// Invoice Data for specific data
public function invoice_data($product_id)
{
$this->db->select('
a.*,
b.*,
sum(b.total_price) - (b.discount * b.quantity) as total_price,
c.customer_name,
d.variant_name
');
$this->db->from('invoice a');
$this->db->join('invoice_details b', 'b.invoice_id = a.invoice_id','left');
$this->db->join('customer_information c', 'c.customer_id = a.customer_id','left');
$this->db->join('variant d', 'd.variant_id = b.variant_id','left');
$this->db->where('b.product_id', $product_id);
$this->db->group_by('b.invoice_id');
$this->db->order_by('a.invoice_id', 'asc');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
public function previous_stock_data($product_id, $startdate)
{
$startdate .= " 00:00:00";
$this->db->select('date,sum(quantity) as quantity');
$this->db->from('product_report');
$this->db->where('product_id', $product_id);
$this->db->where('date <=', $startdate);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
}