<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class transaction_m extends MY_Model { 

	protected $_table_name = 'transaction';
	protected $_primary_key = 'id';
	protected $_order_by = 'id'; 
	private $website_product_ordering = NULL;

	public $rules = array(
		array(
			'field'   => 'id_warehouse',
			'label'   => 'ID Warehouse',
			'rules'   => 'trim|required'
		),  
		  array(
             'field'   => 'note',
             'label'   => 'note',
             'rules'   => 'trim'
          ),
    );

    public $pemesanan_rules = array(
		array(
			'field'   => 'supplier',
			'label'   => 'Supplier',
			'rules'   => 'trim|required'
		),  
		array(
			'field'   => 'syarat_pembayaran',
			'label'   => 'Syarat Pembayaran',
			'rules'   => 'trim|required'
		),
    );

    public $penerimaan_rules = array(
		array(
			'field'   => 'id_transaction',
			'label'   => 'ID Transaction',
			'rules'   => 'trim|required'
		),  
    );

    public $faktur_rules = array(
		array(
			'field'   => 'id_transaction_receiving',
			'label'   => 'ID Transaction Receiving',
			'rules'   => 'trim|required'
		),  
    );

	function __construct() {
		parent::__construct();
	}

    //function to display new product, where all fields are empty
	public function get_new() {
		$transaction = new stdClass();
		$transaction->warehouse_id 		= '';
		$transaction->no_transaksi 		= '';
		$transaction->transaction_message	= '';
		$transaction->transaction_file		= '';
		return $transaction;
	}

	function add_transaction($data) {
		$this->db->insert('transaction', $data);	
		return $this->db->insert_id();	
	}

	function get_current($id_transaction){
		$transaction = $this->db->select('*')->from('transaction')->where('id_transaction',$id_transaction)->get()->row();
		return $transaction;
	}

	function get_current_detail($id_transaction){
		$transaction = 
		$this->db->select('*')
		->from('transaction_detail')
		->where('id_transaction',$id_transaction)
		->get()
		->result();
		return $transaction;
	}

	function edit_transaction($id_transaction,$transaction) {
		$this->db->where('id_transaction', $id_transaction);
		$this->db->update('transaction', $transaction);	
	}

	function add_transaction_receiving($data) {
		$this->db->insert('transaction_receiving', $data);	
		return $this->db->insert_id();	
	}

	function add_transaction_faktur($data) {
		$this->db->insert('transaction_faktur', $data);	
		return $this->db->insert_id();	
	}


}