|
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/laciasmara.com/public_html/shop/application/models/ |
Upload File : |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Invoice_detail_m extends MY_Model {
protected $_table_name = 'invoice_detail';
protected $_primary_key = 'id_invoice_detail';
protected $_order_by = 'id_invoice_detail';
public $rules = array(
array(
'field' => 'customer_id',
'label' => 'Customer',
'rules' => 'trim|required'
),
array(
'field' => 'marketplace_id',
'label' => 'Marketplace',
'rules' => 'trim|required'
),
);
function __construct() {
parent::__construct();
}
public function insertInvoiceDetail($insert_id,$product_id, $quantity,$purchase_price){
$data = array(
'invoice_id' => $insert_id ,
'product_id' => $product_id ,
'quantity' => $quantity,
'purchase_price' => $purchase_price
);
$this->db->insert('invoice_detail', $data);
}
public function getDetailInvoice($id) {
$this->db->select('products.title,product_details.sku, product_attributes_detail.attribute_detail , invoice_detail.quantity, invoice_detail.purchase_price');
$this->db->from('invoice_detail, products, product_details, product_combination, product_attributes_detail');
$this->db->where('invoice_id', $id );
$this->db->where('products.id_products = product_details.product_id and invoice_detail.product_id = product_details.id and product_details.id = invoice_detail.product_id and product_combination.product_details_id = product_details.id and product_combination.attribute_detail_id = product_attributes_detail.id' );
$this->db->order_by('id_invoice_detail');
$query = $this->db->get();
return $query->result_array();
}
}