���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() 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 Taxs extends CI_Model { public function __construct() { parent::__construct(); } //tax List public function tax_list() { $this->db->select('*'); $this->db->from('tax'); $this->db->order_by('tax_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //show only full of data has any row, that items. public function tax_list_except_empty() { $this->db->select('*'); $this->db->from('tax'); $this->db->where('tax_name !=',''); $this->db->where('status =',1); $this->db->order_by('tax_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Tax Product List public function tax_product_list() { $this->db->select('*'); $this->db->from('tax'); $this->db->join('tax_product_service','tax.tax_id = tax_product_service.tax_id'); $this->db->join('product_information','product_information.product_id = tax_product_service.product_id'); $this->db->order_by('tax_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Product List public function product_list() { $this->db->select('*'); $this->db->from('product_information'); $this->db->order_by('product_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //tax Search Item public function tax_search_item($tax_id) { $this->db->select('*'); $this->db->from('tax'); $this->db->where('tax_id',$tax_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Insert tax public function tax_entry($data) { $this->db->select('*'); $this->db->from('tax'); $this->db->where('tax_name',$data['tax_name']); $query = $this->db->get(); if ($query->num_rows() > 0) { return FALSE; }else{ $this->db->insert('tax',$data); return TRUE; } } //Insert tax product public function tax_product_entry($data) { $this->db->select('*'); $this->db->from('tax_product_service'); $this->db->where('tax_id',$data['tax_id']); $this->db->where('product_id',$data['product_id']); $query = $this->db->get(); if ($query->num_rows() > 0) { return FALSE; }else{ $this->db->insert('tax_product_service',$data); return TRUE; } } //Retrieve tax Edit Data public function retrieve_tax_editdata($t_p_s_id) { $this->db->select('*'); $this->db->from('tax'); $this->db->join('tax_product_service','tax.tax_id = tax_product_service.tax_id'); $this->db->join('product_information','product_information.product_id = tax_product_service.product_id'); $this->db->where('tax_product_service.t_p_s_id',$t_p_s_id); $this->db->order_by('tax_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Update tax Data public function tax_product_update($data,$t_p_s_id) { $this->db->where('t_p_s_id',$t_p_s_id); $result = $this->db->update('tax_product_service',$data); if ($result) { return TRUE; } return false; } //Selected product public function selected_product($product_id){ return $result = $this->db->select('*') ->from('product_information') ->where('product_id',$product_id) ->get() ->result(); } //Selected tax public function selected_tax($tax_id){ return $result = $this->db->select('*') ->from('tax') ->where('tax_id',$tax_id) ->get() ->result(); } //Update Taxs public function update_tax($data,$tax_id) { $this->db->where('tax_id',$tax_id); $result = $this->db->update('tax',$data); if ($result) { return true; } return false; } // Delete tax Item public function delete_tax($t_p_s_id) { $this->db->where('t_p_s_id',$t_p_s_id); $this->db->delete('tax_product_service'); return true; } }