| Server IP : 5.161.254.237 / Your IP : 216.73.216.185 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 order_model extends CI_Model
{
function __construct()
{
parent::__construct();
}
function get_orders($search=false, $sort_by='', $sort_order='DESC', $limit=0, $offset=0)
{
if ($search)
{
if(!empty($search->term))
{
//support multiple words
$term = explode(' ', $search->term);
foreach($term as $t)
{
$not = '';
$operator = 'OR';
if(substr($t,0,1) == '-')
{
$not = 'NOT ';
$operator = 'AND';
//trim the - sign off
$t = substr($t,1,strlen($t));
}
$like = '';
$like .= "( `order_number` ".$not."LIKE '%".$t."%' " ;
$like .= $operator." `bill_firstname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `bill_lastname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `ship_firstname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `ship_lastname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `status` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `notes` ".$not."LIKE '%".$t."%' )";
$this->db->where($like);
}
}
if(!empty($search->start_date))
{
$this->db->where('ordered_on >=',$search->start_date);
}
if(!empty($search->end_date))
{
//increase by 1 day to make this include the final day
//I tried <= but it did not function. Any ideas why?
$search->end_date = date('Y-m-d', strtotime($search->end_date)+86400);
$this->db->where('ordered_on <',$search->end_date);
}
}
if($limit>0)
{
$this->db->limit($limit, $offset);
}
if(!empty($sort_by))
{
$this->db->order_by($sort_by, $sort_order);
}
return $this->db->get('orders')->result();
}
function get_orders_count($search=false)
{
if ($search)
{
if(!empty($search->term))
{
//support multiple words
$term = explode(' ', $search->term);
foreach($term as $t)
{
$not = '';
$operator = 'OR';
if(substr($t,0,1) == '-')
{
$not = 'NOT ';
$operator = 'AND';
//trim the - sign off
$t = substr($t,1,strlen($t));
}
$like = '';
$like .= "( `order_number` ".$not."LIKE '%".$t."%' " ;
$like .= $operator." `bill_firstname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `bill_lastname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `ship_firstname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `ship_lastname` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `status` ".$not."LIKE '%".$t."%' ";
$like .= $operator." `notes` ".$not."LIKE '%".$t."%' )";
$this->db->where($like);
}
}
if(!empty($search->start_date))
{
$this->db->where('ordered_on >=',$search->start_date);
}
if(!empty($search->end_date))
{
$this->db->where('ordered_on <',$search->end_date);
}
}
return $this->db->count_all_results('orders');
}
//get an individual customers orders
function get_customer_orders($id, $offset=0)
{
$this->db->join('order_items', 'orders.id = order_items.order_id');
$this->db->order_by('ordered_on', 'DESC');
return $this->db->get_where('orders', array('customer_id'=>$id), 15, $offset)->result();
}
function count_customer_orders($id)
{
$this->db->where(array('customer_id'=>$id));
return $this->db->count_all_results('orders');
}
function get_order($id)
{
$this->db->where('id', $id);
$result = $this->db->get('orders');
$order = $result->row();
$order->contents = $this->get_items($order->id);
return $order;
}
function get_items($id)
{
$this->db->select('order_id, contents');
$this->db->where('order_id', $id);
$result = $this->db->get('order_items');
$items = $result->result_array();
$return = array();
$count = 0;
foreach($items as $item)
{
$item_content = unserialize($item['contents']);
//remove contents from the item array
unset($item['contents']);
$return[$count] = $item;
//merge the unserialized contents with the item array
$return[$count] = array_merge($return[$count], $item_content);
$count++;
}
return $return;
}
function delete($id)
{
$this->db->where('id', $id);
$this->db->delete('orders');
//now delete the order items
$this->db->where('order_id', $id);
$this->db->delete('order_items');
}
function save_order($data, $contents = false)
{
if (isset($data['id']))
{
$this->db->where('id', $data['id']);
$this->db->update('orders', $data);
$id = $data['id'];
// we don't need the actual order number for an update
$order_number = $id;
}
else
{
$this->db->insert('orders', $data);
$id = $this->db->insert_id();
//create a unique order number
//unix time stamp + unique id of the order just submitted.
$order = array('order_number'=> date('U').$id);
//update the order with this order id
$this->db->where('id', $id);
$this->db->update('orders', $order);
//return the order id we generated
$order_number = $order['order_number'];
}
//if there are items being submitted with this order add them now
if($contents)
{
// clear existing order items
$this->db->where('order_id', $id)->delete('order_items');
// update order items
foreach($contents as $item)
{
$save = array();
$save['contents'] = $item;
$item = unserialize($item);
$save['product_id'] = $item['id'];
$save['quantity'] = $item['quantity'];
$save['order_id'] = $id;
$this->db->insert('order_items', $save);
}
}
return $order_number;
}
function save_item($data)
{
if (isset($data['id']) && $data['id'] != 0)
{
$this->db->where('id', $data['id']);
$this->db->update('items', $data);
return $data['id'];
}
else
{
$this->db->insert('items', $data);
return $this->db->insert_id();
}
}
function get_best_sellers($start, $end)
{
if(!empty($start))
{
$this->db->where('ordered_on >=', $start);
}
if(!empty($end))
{
$this->db->where('ordered_on <', $end);
}
// just fetch a list of order id's
$orders = $this->db->select('id')->get('orders')->result();
$items = array();
foreach($orders as $order)
{
// get a list of product id's and quantities for each
$order_items = $this->db->select('product_id, quantity')->where('order_id', $order->id)->get('order_items')->result_array();
foreach($order_items as $i)
{
if(isset($items[$i['product_id']]))
{
$items[$i['product_id']] += $i['quantity'];
}
else
{
$items[$i['product_id']] = $i['quantity'];
}
}
}
arsort($items);
// don't need this anymore
unset($orders);
$return = array();
foreach($items as $key=>$quantity)
{
$product = $this->db->where('id', $key)->get('products')->row();
if($product)
{
$product->quantity_sold = $quantity;
}
else
{
$product = (object) array('sku'=>'Deleted', 'name'=>'Deleted', 'quantity_sold'=>$quantity);
}
$return[] = $product;
}
return $return;
}
function get_best_sellers_city($start, $end, $city)
{
if(!empty($start))
{
$this->db->where('ordered_on >=', $start);
}
if(!empty($end))
{
$this->db->where('ordered_on <', $end);
}
if(!empty($city))
{
$this->db->where('ship_city =', $city);
}
// just fetch a list of order id's
$orders = $this->db->select('id')->get('orders')->result();
$items = array();
foreach($orders as $order)
{
// get a list of product id's and quantities for each
$order_items = $this->db->select('product_id, quantity')->where('order_id', $order->id)->get('order_items')->result_array();
foreach($order_items as $i)
{
if(isset($items[$i['product_id']]))
{
$items[$i['product_id']] += $i['quantity'];
}
else
{
$items[$i['product_id']] = $i['quantity'];
}
}
}
arsort($items);
// don't need this anymore
unset($orders);
$return = array();
foreach($items as $key=>$quantity)
{
$product_order =$this->db->select('order_id')->where('product_id', $key)->get('order_items')->result_array();
$this->db->distinct();
$this->db->select('ship_city');
$this->db->from('orders');
$this->db->join('order_items', 'order_items.order_id = orders.id');
$this->db->where('product_id', $key);
$this->db->group_by('ship_city');
$city_sold = $this->db->get()->result_array();
$product = $this->db->where('id', $key)->get('products')->row();
if($product)
{
$product->quantity_sold = $quantity;
$product->city_sold = $city_sold;
}
else
{
$product = (object) array('sku'=>'Deleted', 'name'=>'Deleted', 'quantity_sold'=>$quantity);
$product->city_sold = $city_sold;
}
$return[] = $product;
}
return $return;
}
}