public static function Rendering($model, $columnsInfo, $filter, $perPage)
{
if ($filter != null) {
$whereCondition = '$model::';
$temp = [];
foreach ($columnsInfo as $key => $value) {
$temp = array_add($temp, $key, collect($value));
}
$columnsInfo = $temp;
$filter = Filter::Interpret($filter, $columnsInfo);
$operations = $filter['operations'];
$operands = $filter['operands'];
function find_key($alias, $columnsInfo)
{
foreach ($columnsInfo as $key => $col) {
if ($col->contains($alias)) {
return $key;
}
}
}
function add_condition(&$isFirst, &$whereCondition, $key, $value, $colInfo, $operations, &$i)
{
if ($isFirst) {
$whereCondition .= "where('" . $key . "','" . $value[0] . "')->";
$isFirst = FALSE;
} elseif ($operations != []) {
if ($operations[$i] == '&') {
$whereCondition .= "where('" . $key . "','" . $value[0] . "')->";
$i++;
} elseif ($operations[$i] == '|') {
$whereCondition .= "orWhere('" . $key . "','" . $value[0] . "')->";
$i++;
}
}
}
function add_condition_wherethrough(&$isFirst, &$whereCondition, $key, $value, $colInfo, $operations, &$i)
{
$wherethrough = $colInfo['wherethrough'];
$class = $colInfo['class'];
$el = $class::where($wherethrough['key'], $value)->get();
$id = $el->first()->{$wherethrough}['value'];
if ($isFirst) {
$whereCondition .= "where('" . $key . "','" . $id . "')->";
$isFirst = FALSE;
} elseif ($operations != []) {
if ($operations[$i] == '&') {
$whereCondition .= "where('" . $key . "','" . $id . "')->";
$i++;
} elseif ($operations[$i] == '|') {
$whereCondition .= "orWhere('" . $key . "','" . $id . "')->";
$i++;
}
}
}
$i = 0;
$isFirst = TRUE;
foreach ($operands as $item) {
$key = find_key(key($item), $columnsInfo);
if (!$columnsInfo[$key]->has('wherethrough')) {
add_condition($isFirst, $whereCondition, $key, array_values($item), $columnsInfo[$key], $operations, $i);
} else {
add_condition_wherethrough($isFirst, $whereCondition, $key, array_values($item), $columnsInfo[$key], $operations, $i);
}
}
// echo '<div style="direction: ltr">';
// \Symfony\Component\VarDumper\VarDumper::dump($operations);
// \Symfony\Component\VarDumper\VarDumper::dump($operands);
// \Symfony\Component\VarDumper\VarDumper::dump($columnsInfo);
// \Symfony\Component\VarDumper\VarDumper::dump($whereCondition);
// echo '</div>';
return eval('return ' . $whereCondition . "paginate({$perPage});");
} else {
return $model::paginate($perPage);
}
}
TOOLBAR_formmaker::_DEFAULT();
break;
}
switch ($task) {
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
case 'show_conditions':
show_conditions();
break;
case 'change_choices':
change_choices();
break;
case 'add_condition_fields':
add_condition_fields();
break;
case 'add_condition':
add_condition();
break;
case 'select_data_from_db':
select_data_from_db();
break;
case 'show_ip_info':
show_ip_info();
break;
case 'view_submissions':
view_submissions();
break;
case 'featured_plugins':
featured_plugins();
break;
case 'extensions':
extensions();
