Пример #1
0
 public function applyDefaultEntriesSelectParams(array $params)
 {
     if ($this->primaryKeyFieldName != 'id') {
         unset(self::$defaultEntriesSelectParams['id']);
         self::$defaultEntriesSelectParams[$this->primaryKeyFieldName] = -1;
         self::$defaultEntriesSelectParams['orderBy'] = $this->primaryKeyFieldName;
     }
     if (isset($params['perPage']) && isset($params['current_page'])) {
         $params['currentPage'] = $params['current_page'] * $params['perPage'];
     }
     if (isset($params['fields']) && is_array($params['fields'])) {
         $params['fields'] = array_merge(array('id'), $params['fields']);
     }
     $params = array_merge(self::$defaultEntriesSelectParams, $params);
     // Is there a sort column?
     $tableColumns = array_flip(TableSchema::getTableColumns($this->table, null, true));
     if (array_key_exists('sort', $tableColumns)) {
         $params['orderBy'] = 'sort';
     }
     array_walk($params, array($this, 'castFloatIfNumeric'));
     return $params;
 }
 public function constructPreferences($user_id, $table, $preferences = null, $title = null)
 {
     if ($preferences) {
         $newPreferencesData = false;
         // @todo enforce non-empty set
         if (empty($preferences['columns_visible'])) {
             $newPreferencesData = true;
             $columns_visible = TableSchema::getTableColumns($table, 6);
             $preferences['columns_visible'] = implode(',', $columns_visible);
         }
         $preferencesDefaultsApplied = $this->applyDefaultPreferences($table, $preferences);
         if (count(array_diff($preferences, $preferencesDefaultsApplied))) {
             $newPreferencesData = true;
         }
         $preferences = $preferencesDefaultsApplied;
         if ($newPreferencesData) {
             $id = $this->addOrUpdateRecordByArray($preferences);
         }
         return $preferences;
     }
     $insert = new Insert($this->table);
     // User doesn't have any preferences for this table yet. Please create!
     $columns_visible = TableSchema::getTableColumns($table, 6);
     $data = array('user' => $user_id, 'columns_visible' => implode(',', $columns_visible), 'table_name' => $table, 'title' => $title);
     if (TableSchema::hasTableColumn($table, 'sort')) {
         $data['sort'] = 'sort';
     }
     $data = $this->applyDefaultPreferences($table, $data);
     $insert->values($data);
     $this->insertWith($insert);
     return $data;
 }