| Server IP : 5.161.254.237 / Your IP : 216.73.216.93 Web Server : Apache System : Linux diamond.sialwebvps.com 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : stellasp ( 1131) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/stellasp/public_html/application/models/ |
Upload File : |
<?php
Class Product_model extends CI_Model
{
// we will store the group discount formula here
// and apply it to product prices as they are fetched
var $group_discount_formula = false;
function __construct()
{
parent::__construct();
// check for possible group discount
$customer = $this->session->userdata('customer');
if(isset($customer['group_discount_formula']))
{
$this->group_discount_formula = $customer['group_discount_formula'];
}
}
function product_autocomplete($name, $limit)
{
return $this->db->like('name', $name)->get('products', $limit)->result();
}
function products($data=array(), $return_count=false)
{
if(empty($data))
{
//if nothing is provided return the whole shabang
$this->get_all_products();
}
else
{
//grab the limit
if(!empty($data['rows']))
{
$this->db->limit($data['rows']);
}
//grab the offset
if(!empty($data['page']))
{
$this->db->offset($data['page']);
}
//do we order by something other than category_id?
if(!empty($data['order_by']))
{
//if we have an order_by then we must have a direction otherwise KABOOM
$this->db->order_by($data['order_by'], $data['sort_order']);
}
//do we have a search submitted?
if(!empty($data['term']))
{
$search = json_decode($data['term']);
//if we are searching dig through some basic fields
if(!empty($search->term))
{
$this->db->like('name', $search->term);
$this->db->or_like('description', $search->term);
$this->db->or_like('excerpt', $search->term);
$this->db->or_like('sku', $search->term);
}
if(!empty($search->category_id))
{
//lets do some joins to get the proper category products
$this->db->join('category_products', 'category_products.product_id=products.id', 'right');
$this->db->where('category_products.category_id', $search->category_id);
$this->db->order_by('sequence', 'ASC');
}
}
if($return_count)
{
return $this->db->count_all_results('products');
}
else
{
return $this->db->get('products')->result();
}
}
}
function get_products($category_id = false, $limit = false, $offset = false)
{
//if we are provided a category_id, then get products according to category
if ($category_id)
{
$result = $this->db->select('category_products.*')->from('category_products')->join('products', 'category_products.product_id=products.id')->where(array('category_id'=>$category_id, 'enabled'=>1))->order_by('products.sort_order', 'ASC')->limit($limit)->offset($offset)->get()->result();
//$this->db->order_by('sequence', 'ASC');
//$result = $this->db->get_where('category_products', array('enabled'=>1,'category_id'=>$category_id), $limit, $offset);
//$result = $result->result();
$contents = array();
$count = 0;
foreach ($result as $product)
{
$contents[$count] = $this->get_product($product->product_id);
$count++;
}
return $contents;
}
else
{
//sort by alphabetically by default
$this->db->order_by('name', 'ASC');
$result = $this->db->get('products');
//apply group discount
$return = $result->result();
if($this->group_discount_formula)
{
foreach($return as &$product) {
eval('$product->price=$product->price'.$this->group_discount_formula.';');
}
}
return $return;
}
}
function get_in_products()
{
//if we are provided a category_id, then get products according to category
//sort by alphabetically by default
$this->db->order_by('name', 'ASC');
$this->db->where('quantity <=', 5);
$result = $this->db->get('products');
//apply group discount
$return = $result->result();
if($this->group_discount_formula)
{
foreach($return as &$product) {
eval('$product->price=$product->price'.$this->group_discount_formula.';');
}
}
return $return;
}
function get_home_products()
{
//if we are provided a category_id, then get products according to category
//sort by alphabetically by default
$this->db->order_by('sort_order', 'ASC');
$this->db->where('favourite',1);
$this->db->limit(10, 0);
$result = $this->db->get('products');
//apply group discount
$return = $result->result();
if($this->group_discount_formula)
{
foreach($return as &$product) {
eval('$product->price=$product->price'.$this->group_discount_formula.';');
}
}
return $return;
}
function get_new_home_products()
{
//if we are provided a category_id, then get products according to category
//sort by alphabetically by default
$this->db->order_by('sort_order', 'ASC');
$this->db->where('arrival',1);
//$this->db->where('favourite',1);
$this->db->limit(10, 0);
$result = $this->db->get('products');
//apply group discount
$return = $result->result();
if($this->group_discount_formula)
{
foreach($return as &$product) {
eval('$product->price=$product->price'.$this->group_discount_formula.';');
}
}
return $return;
}
function get_new_products($offset = false)
{
//if we are provided a category_id, then get products according to category
//sort by alphabetically by default
$this->db->order_by('sort_order', 'ASC');
$this->db->where('arrival',1);
$result = $this->db->get('products');
//apply group discount
$return = $result->result();
if($this->group_discount_formula)
{
foreach($return as &$product) {
eval('$product->price=$product->price'.$this->group_discount_formula.';');
}
}
return $return;
}
function count_products($id)
{
return $this->db->select('product_id')->from('category_products')->join('products', 'category_products.product_id=products.id')->where(array('category_id'=>$id, 'enabled'=>1))->count_all_results();
}
function get_product($id, $sub=true)
{
$result = $this->db->get_where('products', array('id'=>$id))->row();
if(!$result)
{
return false;
}
$result->categories = $this->get_product_categories($result->id);
$result->categories_list = $this->get_product_categories_list($result->id);
// group discount?
if($this->group_discount_formula)
{
eval('$result->price=$result->price'.$this->group_discount_formula.';');
}
return $result;
}
function get_product_categories($id)
{
return $this->db->where('product_id', $id)->join('categories', 'category_id = categories.id')->get('category_products')->result();
//$cats = $this->db->where('product_id', $id)->get('category_products')->result();
//
// $categories = array();
// foreach ($cats as $c)
// {
// $categories[] = $c->category_id;
// }
// return $categories;
}
function get_product_categories_list($id)
{
$this->db->where('product_id', $id)->join('categories', 'category_id = categories.id')->get('category_products')->result();
$cats = $this->db->where('product_id', $id)->get('category_products')->result();
$categories = array();
foreach ($cats as $c)
{
$categories[] = $c->category_id;
}
return $categories;
}
function get_slug($id)
{
return $this->db->get_where('products', array('id'=>$id))->row()->slug;
}
function check_slug($str, $id=false)
{
$this->db->select('slug');
$this->db->from('products');
$this->db->where('slug', $str);
if ($id)
{
$this->db->where('id !=', $id);
}
$count = $this->db->count_all_results();
if ($count > 0)
{
return true;
}
else
{
return false;
}
}
function save($product, $options=false, $categories=false)
{
if ($product['id'])
{
$this->db->where('id', $product['id']);
$this->db->update('products', $product);
$id = $product['id'];
}
else
{
$this->db->insert('products', $product);
$id = $this->db->insert_id();
}
//loop through the product options and add them to the db
if($options !== false)
{
$obj =& get_instance();
$obj->load->model('Option_model');
// wipe the slate
$obj->Option_model->clear_options($id);
// save edited values
$count = 1;
foreach ($options as $option)
{
$values = $option['values'];
unset($option['values']);
$option['product_id'] = $id;
$option['sequence'] = $count;
$obj->Option_model->save_option($option, $values);
$count++;
}
}
if($categories !== false)
{
if($product['id'])
{
//get all the categories that the product is in
$cats = $this->get_product_categories_list($id);
//eliminate categories that products are no longer in
foreach($cats as $c)
{
if(!in_array($c, $categories))
{
$this->db->delete('category_products', array('product_id'=>$id,'category_id'=>$c));
}
}
//add products to new categories
foreach($categories as $c)
{
if(!in_array($c, $cats))
{
$this->db->insert('category_products', array('product_id'=>$id,'category_id'=>$c));
}
}
}
else
{
//new product add them all
foreach($categories as $c)
{
$this->db->insert('category_products', array('product_id'=>$id,'category_id'=>$c));
}
}
}
//return the product id
return $id;
}
function delete_product($id)
{
// delete product
$this->db->where('id', $id);
$this->db->delete('products');
//delete references in the product to category table
$this->db->where('product_id', $id);
$this->db->delete('category_products');
// delete coupon reference
$this->db->where('product_id', $id);
$this->db->delete('coupons_products');
}
function add_product_to_category($product_id, $optionlist_id, $sequence)
{
$this->db->insert('product_categories', array('product_id'=>$product_id, 'category_id'=>$category_id, 'sequence'=>$sequence));
}
function search_products($term, $limit=false, $offset=false)
{
$results = array();
//I know this is the round about way of doing things and is not the fastest. but it is thus far the easiest.
//this one counts the total number for our pagination
$this->db->like('name', $term);
$this->db->or_like('description', $term);
$this->db->or_like('excerpt', $term);
$this->db->or_like('sku', $term);
$results['count'] = $this->db->count_all_results('products');
//this one gets just the ones we need.
$this->db->like('name', $term);
$this->db->or_like('description', $term);
$this->db->or_like('excerpt', $term);
$this->db->or_like('sku', $term);
$results['products'] = $this->db->get('products', $limit, $offset)->result();
return $results;
}
// Build a cart-ready product array
function get_cart_ready_product($id, $quantity=false)
{
$db_product = $this->get_product($id);
if( ! $db_product)
{
return false;
}
$product = array();
if ($db_product->saleprice == 0.00) {
$product['price'] = $db_product->price;
}
else
{
$product['price'] = $db_product->saleprice;
}
$product['base_price'] = $product['price']; // price gets modified by options, show the baseline still...
$product['id'] = $db_product->id;
$product['slug'] = $db_product->slug;
$product['name'] = $db_product->name;
$product['sku'] = $db_product->sku;
$product['images'] = $db_product->images;
$product['excerpt'] = $db_product->excerpt;
$product['weight'] = $db_product->weight;
$product['shippable'] = $db_product->shippable;
$product['costpersqft'] = $db_product->costpersqft;
$product['taxable'] = $db_product->taxable;
$product['fixed_quantity'] = $db_product->fixed_quantity;
$product['track_stock'] = $db_product->track_stock;
$product['options'] = array();
// Some products have n/a quantity, such as downloadables
/*if (!$quantity || $quantity <= 0 || $db_product->fixed_quantity==1)
{
$product['quantity'] = 1;
} else {
$product['quantity'] = $quantity;
}*/
$product['quantity'] = $quantity;
// attach list of associated downloadables
$product['file_list'] = $this->Digital_Product_model->get_associations_by_product($id);
return $product;
}
public function get_current_product($category_id, $product_id) {
$this->db->select('*');
$this->db->from('category_products');
$this->db->where('category_id', $category_id);
$this->db->where('product_id', $product_id);
$query = $this->db->get();
return $query->row();
}
public function get_next_product($category_id, $current_product_id) {
$this->db->select('product_id');
$this->db->from('category_products');
$this->db->where('category_id', $category_id);
$this->db->where('product_id >', $current_product_id);
$this->db->order_by('product_id', 'ASC');
$this->db->limit(1);
$query = $this->db->get();
return $query->row();
}
public function get_previous_product($category_id, $current_product_id) {
$this->db->select('product_id');
$this->db->from('category_products');
$this->db->where('category_id', $category_id);
$this->db->where('product_id <', $current_product_id);
$this->db->order_by('product_id', 'DESC');
$this->db->limit(1);
$query = $this->db->get();
return $query->row();
}
function get_slug_product($id)
{
$this->db->select('slug');
$result = $this->db->get_where('products', array('id'=>$id))->row();
if(!$result)
{
return '';
}
return $result->slug;
}
}