public static function getObjId($obj)
{
Assert::assert($obj);
$obj_class_name = get_class($obj);
$obj_id_field_name = CRUDFieldsAccess::getIdFieldName($obj_class_name);
return CRUDFieldsAccess::getObjectFieldValue($obj, $obj_id_field_name);
}
/**
* Возвращает одну страницу списка объектов указанного класса.
* Сортировка: TODO.
* Фильтры: массив $context_arr.
* Как определяется страница: см. Pager.
* @param $model_class_name Имя класса модели
* @param $context_arr array Массив пар "имя поля" - "значение поля"
* @return array Массив идентикаторов объектов.
*/
public static function getObjIdsArrForClassName($table_index_on_page, $model_class_name, $filters_arr, $order_by = '')
{
\OLOG\CheckClassInterfaces::exceptionIfClassNotImplementsInterface($model_class_name, \OLOG\Model\InterfaceLoad::class);
$page_size = Pager::getPageSize($table_index_on_page);
$start = Pager::getPageOffset($table_index_on_page);
$db_table_name = $model_class_name::DB_TABLE_NAME;
$db_id = $model_class_name::DB_ID;
$db_id_field_name = CRUDFieldsAccess::getIdFieldName($model_class_name);
$query_param_values_arr = array();
$where = ' 1 = 1 ';
foreach ($filters_arr as $filter_obj) {
/*
if ($filter_obj instanceof InterfaceCRUDTableFilter) {
$column_name = $filter_obj->getFieldName();
$operation_code = $filter_obj->getOperationCode();
$value = $filter_obj->getValue();
$column_name = preg_replace("/[^a-zA-Z0-9_]+/", "", $column_name);
switch ($operation_code) {
case CRUDTableFilter::FILTER_EQUAL:
$where .= ' and ' . $column_name . ' = ? ';
$query_param_values_arr[] = $value;
break;
case CRUDTableFilter::FILTER_IS_NULL:
$where .= ' and ' . $column_name . ' is null ';
break;
case CRUDTableFilter::FILTER_LIKE:
$where .= ' and ' . $column_name . ' like ? ';
$query_param_values_arr[] = '%' . $value . '%';
break;
case CRUDTableFilter::FILTER_IN:
if (count($value)) {
$in_placeholders_arr = [];
foreach ($value as $in_single_value) {
$in_placeholders_arr[] = '?';
$query_param_values_arr[] = $in_single_value;
}
$where .= ' and ' . $column_name . ' in (' . implode(', ', $in_placeholders_arr) . ') ';
}
break;
default:
throw new \Exception('unknown filter code');
}
} else
*/
if ($filter_obj instanceof InterfaceCRUDTableFilter2) {
list($filter_sql_condition, $filter_placeholder_values_arr) = $filter_obj->sqlConditionAndPlaceholderValue();
if ($filter_sql_condition != '') {
$where .= ' and ' . $filter_sql_condition;
}
$query_param_values_arr = array_merge($query_param_values_arr, $filter_placeholder_values_arr);
} elseif ($filter_obj instanceof InterfaceCRUDTableFilterInvisible) {
list($filter_sql_condition, $filter_placeholder_values_arr) = $filter_obj->sqlConditionAndPlaceholderValue();
if ($filter_sql_condition != '') {
$where .= ' and ' . $filter_sql_condition;
}
$query_param_values_arr = array_merge($query_param_values_arr, $filter_placeholder_values_arr);
} else {
throw new \Exception('filter doesnt implement InterfaceCRUDTableFilter nor InterfaceCRUDTableFilter2');
}
}
if ($order_by == '') {
$order_by = $db_id_field_name;
}
$obj_ids_arr = \OLOG\DB\DBWrapper::readColumn($db_id, "select " . $db_id_field_name . " from " . $db_table_name . ' where ' . $where . ' order by ' . $order_by . ' limit ' . intval($page_size) . ' offset ' . intval($start), $query_param_values_arr);
return $obj_ids_arr;
}
