Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/kanvakanva.com/public_html/application/models/ |
Upload File : |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Order_detail_m extends MY_Model { protected $_table_name = 'orders_detail'; protected $_primary_key = 'id_orders_detail'; protected $_order_by = 'id_orders_detail'; function __construct() { parent::__construct(); } function get_orders_detail($id_order) { $this->db->select('a.*,c.brand,c.id_district,c.kanva_group'); $this->db->from('orders_detail a'); $this->db->join('products b','a.item_id=b.id_products','left'); $this->db->join('brands c','b.brand_id=c.id_brands','left'); $this->db->where('a.orders_id', $id_order); $this->db->order_by('c.kanva_group desc, a.id_orders_detail,c.brand asc'); $query = $this->db->get(); return $query->result(); } function get_weight($id_order) { // SELECT od.item_name, p.id_products, ps.id_product_size, s.weight, sum(s.weight) as berat // FROM orders_detail od, products p, product_size ps, stocks s // WHERE od.orders_id = 1710 and od.item_id = p.id_products and od.size = ps.product_size and p.id_products = s.product_id and ps.id_product_size = s.size_id $this->db->select('sum(s.weight) as berat'); $this->db->from('orders_detail od, products p, product_size ps, stocks s'); $this->db->where('od.orders_id', $id_order); $this->db->where('od.item_id = p.id_products and od.size = ps.product_size and p.id_products = s.product_id and ps.id_product_size = s.size_id'); $query = $this->db->get(); return $query->row(); } }