https://t.me/RX1948
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //var/www/kanvakanva.com/public_html/application/models/Order_detail_m.php
<?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();
	}

}

https://t.me/RX1948 - 2025