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; }