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.

Relational Operator