public static function fromArray($arr, $dbInstance)
{
if (!is_a($dbInstance, "Database")) {
trigger_logikserror("Database ERROR, DBInstance should be an object of Database");
}
$table = null;
$cols = "";
$where = null;
$groupby = null;
$having = null;
$orderby = null;
$index = 0;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['having'])) {
$having = $arr['having'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limit'])) {
$limit = $arr['limit'];
}
if (isset($arr['index'])) {
$index = $arr['index'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols, $where);
//$objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx->_join($query, $condition, $as, $type);
}
}
$objx->_groupby($groupby, $having);
$objx->_orderby($orderby);
$objx->_limit($limit, $index);
return $objx;
}
public static function fromArray($arr, $dbInstance)
{
$table = null;
$cols = "";
$where = null;
$groupby = null;
$orderby = null;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limits'])) {
$limit = $arr['limits'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols);
$objx = $objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx = $objx->_join($query, $condition, $as, $type);
}
}
$objx = $objx->_groupby($groupby);
$objx = $objx->_orderby($orderby);
$objx = $objx->_limit($limit);
return $objx;
}
