Join Composite Method

join_composite method purpose is for joining the table with multiple primary key.

We can achieved the conditions of joining multiple primary key with composite_create method.

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

join_composite method has 3 required parameters and will returned join composite object

Table Name 1

The table for joined with current table.

Alias of Table Name 1

The alias table for joined with current table.

Array of Join Composite Object

Value required from array of object from composite_create.

Join Method

Join method value. Default empty string. Value consist of, inner, outer, left, right.

This method available from Seme Framework version >= 3.2.1