���� 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 Variants extends CI_Model { public function __construct() { parent::__construct(); } //customer List public function variant_list() { $this->db->select('*'); $this->db->from('variant'); $this->db->order_by('variant_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } public function category_wise_variant_list($cat_id) { $this->db->select('cv.variant_id,v.*'); $this->db->from('category_variant cv'); $this->db->where('cv.category_id =',$cat_id); $this->db->join('variant v','cv.variant_id = v.variant_id','left'); $this->db->order_by('v.variant_name','asc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //variant Search Item public function variant_search_item($variant_id) { $this->db->select('*'); $this->db->from('variant'); $this->db->where('variant_id',$variant_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Count customer public function variant_entry($data) { $this->db->select('*'); $this->db->from('variant'); $this->db->where('status',1); $this->db->where('variant_name',$data['variant_name']); $query = $this->db->get(); if ($query->num_rows() > 0) { return FALSE; }else{ $this->db->insert('variant',$data); return TRUE; } } //Retrieve customer Edit Data public function retrieve_variant_editdata($variant_id) { $this->db->select('*'); $this->db->from('variant'); $this->db->where('variant_id',$variant_id); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->result_array(); } return false; } //Update variants public function update_variant($data,$variant_id) { $this->db->where('variant_id',$variant_id); $result = $this->db->update('variant',$data); if ($result) { return true; } return false; } // Delete variant Item public function delete_variant($variant_id) { $this->db->where('variant_id',$variant_id); $this->db->delete('variant'); return true; } }