Composite Create Method
Composite Create is for building multiple join condition for table that have two or more primary key.
This method can be used properly with join_composite method, for joining the table .
class Blog_Model extends SENE_Model{ var $tbl = 'd_order'; var $tbl_as = 'dor'; var $tbl2 = 'b_seller'; var $tbl2_as = 'bs'; public function __construct(){ parent::__construct(); $this->db->from($this->tbl,$this->tbl_as); } private function __joinTbl2(){ $composites = array(); $composites[] = $this->db->composite_create("$this->tbl_as.nation_code","=","$this->tbl_as.nation_code"); $composites[] = $this->db->composite_create("$this->tbl_as.b_seller_id","=","$this->tbl_as.id"); return $composites; } public function getByOrderId($id){ $this->db->join_composite($this->tbl2,$this->tbl2_as,$this->__joinTbl2(),"inner"); $this->db->where_as("$this->tbl_as.id",$this->db->esc($id)); return $this->db->get_first(); } }
Parameters
composite_create method has 3 required parameters and will returned join composite object
COLUMN_NAME_1
Column name for first table.
Relational Operator
Value required for condition, value consists of "=","<>".
COLUMN_NAME_1
Column name for second table.