Ejemplo n.º 1
0
 /**
  * Экстрактит все записи словаря внутри коллекции
  *
  * $collection = DicVal::extracts($collection);
  *
  * @param $elements
  * @param bool $unset
  * @param bool $extract_ids
  * @return Collection
  */
 public static function extracts($elements, $field = null, $unset = false, $extract_ids = true)
 {
     return DicLib::extracts($elements, $field, $unset, $extract_ids);
 }
Ejemplo n.º 2
0
<?php

return array('fields' => function () {
    return array('desc' => array('title' => 'Описание параметра', 'type' => 'textarea'));
}, 'hooks' => array('before_all' => function ($dic) {
}, 'before_index' => function ($dic) {
}, 'before_index_view' => function ($dic, $dicvals) {
    $dicvals->load('textfields');
    #Helper::tad($dicvals);
    $dicvals = DicLib::extracts($dicvals, null, true, true);
}), 'second_line_modifier' => function ($line, $dic, $dicval) {
    #$dicval->extract(true);
    return $dicval->slug . (isset($dicval->desc) && $dicval->desc ? ' &mdash; <i>' . $dicval->desc . '</i>' : '');
}, 'slug_label' => 'Системное имя параметра');
Ejemplo n.º 3
0
 /**
  * Возвращает записи из словаря по системному имени словаря и набору IDs нужных записей.
  * Третьим параметром можно передать метку, указывающую на необходимость сделать экстракт каждой записи.
  *
  * @param $slug
  * @param $val_ids
  * @param string $with
  * @param bool $extract
  * @param bool $unset
  * @return $this|Collection|\Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model|null|static
  */
 public static function valuesBySlugAndIds($slug, $val_ids, $with = 'all', $extract = true, $unset = true, $extract_ids = false)
 {
     $return = new Collection();
     #$dic = Dic::where('slug', $slug)->first();
     #$dic = @Config::get(self::$cache_key)['by_slug'][$slug];
     $dic = Dic::by_slug($slug);
     if (!is_object($dic) || !is_array($val_ids) || !count($val_ids)) {
         return $return;
     }
     $values = DicVal::where('dic_id', $dic->id)->where('version_of', NULL)->whereIn('id', $val_ids);
     if ($with == 'all') {
         $with = ['meta', 'fields', 'textfields', 'seo', 'related_dicvals'];
     } else {
         $with = (array) $with;
     }
     $db_remember_timeout = Config::get('app.settings.main.db_remember_timeout');
     if (count($with)) {
         ##
         ## Cache relations
         ##
         if (NULL != $db_remember_timeout && is_numeric($db_remember_timeout) && $db_remember_timeout > 0) {
             $temp = [];
             foreach ($with as $relation) {
                 $temp[$relation] = function ($query) use($db_remember_timeout) {
                     $query->remember($db_remember_timeout);
                 };
             }
             $with = $temp;
         }
         $values = $values->with($with);
     }
     ##
     ## Cache query
     ##
     if (NULL != $db_remember_timeout && is_numeric($db_remember_timeout) && $db_remember_timeout > 0) {
         $values->remember($db_remember_timeout);
     }
     $values = $values->get();
     #Helper::tad($values);
     if ($extract) {
         $values = DicLib::extracts($values, null, $unset, $extract_ids);
     }
     #Helper::tad($values);
     return $values;
 }
Ejemplo n.º 4
0
 public function index($dic_id)
 {
     $dic = Dictionary::where(is_numeric($dic_id) ? 'id' : 'slug', $dic_id)->first();
     if (!$this->checkDicPermission($dic)) {
         App::abort(404);
     }
     $this->dicval_permission($dic, 'dicval_view');
     $dic->settings = json_decode($dic->settings, 1);
     $this->checkDicUrl($dic, $dic_id);
     $this->callHook('before_all', $dic);
     $this->callHook('before_index', $dic);
     ## Get element
     $elements = new DicVal();
     $tbl_dicval = $elements->getTable();
     $elements = $elements->where($tbl_dicval . '.dic_id', (int) $dic->id)->where($tbl_dicval . '.version_of', '=', NULL)->with('fields');
     #$elements = DB::table('dictionary_values')->where('dic_id', $dic->id)->select('dictionary_values.*');
     if (NULL !== ($filter = Input::get('filter'))) {
         #Helper::d($filter);
         if (isset($filter['fields']) && is_array($filter) && count($filter)) {
             $tbl_fields = new DicFieldVal();
             $tbl_fields = $tbl_fields->getTable();
             #Helper::d($filter['fields']);
             foreach ($filter['fields'] as $key => $value) {
                 $rand_tbl_alias = md5(rand(99999, 999999));
                 $elements = $elements->join($tbl_fields . ' AS ' . $rand_tbl_alias, function ($join) use($tbl_dicval, $tbl_fields, $key, $value, $rand_tbl_alias) {
                     $join->on($rand_tbl_alias . '.dicval_id', '=', $tbl_dicval . '.id')->where($rand_tbl_alias . '.key', '=', $key)->where($rand_tbl_alias . '.value', '=', $value);
                 })->addSelect($rand_tbl_alias . '.value AS ' . $key);
             }
         }
     }
     ## Ordering
     $sort_order = $dic->sort_order_reverse ? 'DESC' : 'ASC';
     #Helper::dd($dic->sort_by);
     /**
      * Кол-во элементов, подпадающих под условия, но без учета пагинации
      */
     $total_elements_current_selection = clone $elements;
     $total_elements_current_selection = (int) $total_elements_current_selection->count();
     #Helper::tad($total_elements_current_selection);
     switch ($dic->sort_by) {
         case '':
             /*
             $elements = $elements
                 ->orderBy($tbl_dicval.'.order', $sort_order)
                 ->orderBy($tbl_dicval.'.name', $sort_order);
             */
             $elements = $elements->orderBy(DB::raw('-' . $tbl_dicval . '.lft'), 'DESC')->orderBy($tbl_dicval . '.id', $sort_order);
             break;
         case 'name':
             $elements = $elements->orderBy($tbl_dicval . '.name', $sort_order);
             break;
         case 'slug':
             $elements = $elements->orderBy($tbl_dicval . '.slug', $sort_order);
             break;
         case 'created_at':
             $elements = $elements->orderBy($tbl_dicval . '.created_at', $sort_order);
             break;
         case 'updated_at':
             $elements = $elements->orderBy($tbl_dicval . '.updated_at', $sort_order);
             break;
         default:
             /**
              * ORDER BY по произвольному полю
              */
             /*
             #Helper::dd($dic->sort_by);
             #$dic->sort_by .= '2';
             $tbl_fields = (new DicFieldVal())->getTable();
             
             $rand_tbl_alias = md5(rand(99999, 999999));
             $elements = $elements
                 ->leftJoin($tbl_fields . ' AS ' . $rand_tbl_alias, function ($join) use ($tbl_dicval, $tbl_fields, $rand_tbl_alias, $dic, $sort_order) {
                     $join
                         ->on($rand_tbl_alias . '.dicval_id', '=', $tbl_dicval . '.id')
             
                     ;
                 })
                 ### !!! WHERE должно быть именно здесь, а не внутри JOIN-а !!! ###
                 ### !!! Иначе происходит неведомая хрень: dic_id = 'field' !!! ###
                 ->where($rand_tbl_alias . '.key', '=', $dic->sort_by)
                 ->addSelect($rand_tbl_alias . '.value AS ' . $dic->sort_by)
                 #->orderBy($dic->sort_by, $sort_order)
                 ->orderBy($rand_tbl_alias.'.value', $sort_order)
                 ->orderBy($tbl_dicval.'.created_at', 'DESC') ## default
             ;
             */
             $elements = $elements->order_by_field($dic->sort_by, $sort_order);
             break;
     }
     #Helper::tad($dic->pagination);
     ## Search
     $search_query = NULL;
     if (NULL !== ($search_query = Input::get('q'))) {
         $elements = $elements->where('name', 'LIKE', '%' . $search_query . '%')->orWhere('slug', 'LIKE', '%' . $search_query . '%');
     }
     ## Dic settings
     $dic_settings = Config::get('dic/' . $dic->slug);
     #Helper::dd($dic_settings);
     ## Sortable settings
     $sortable = $dic->sortable && $dic->pagination == 0 && $dic->sort_by == null ? true : false;
     ## Disable sortable without needable filter options
     if ($sortable && isset($dic_settings['disable_ordering_without_filter']) && $dic_settings['disable_ordering_without_filter']) {
         $dic_settings['disable_ordering_without_filter'] = (array) $dic_settings['disable_ordering_without_filter'];
         #Helper::ta($dic_settings['disable_ordering_without_filter']);
         if (count($dic_settings['disable_ordering_without_filter'])) {
             foreach ($dic_settings['disable_ordering_without_filter'] as $condition) {
                 if (!Input::get('filter.fields.' . $condition)) {
                     $sortable = false;
                     break;
                 }
             }
         }
     }
     ## Disable listing without needable filter options
     $listing = true;
     if (isset($dic_settings['disable_listing_without_filter']) && $dic_settings['disable_listing_without_filter']) {
         $dic_settings['disable_listing_without_filter']['fields'] = (array) $dic_settings['disable_listing_without_filter']['fields'];
         #Helper::ta($dic_settings['disable_listing_without_filter']['fields']);
         if (count($dic_settings['disable_listing_without_filter']['fields'])) {
             foreach ($dic_settings['disable_listing_without_filter']['fields'] as $condition) {
                 if (!Input::get('filter.fields.' . $condition)) {
                     $listing = false;
                     break;
                 }
             }
         }
     }
     if (isset($dic_settings['sortable']) && is_callable($dic_settings['sortable'])) {
         $sortable = $dic_settings['sortable']($dic, $elements);
     }
     ## Pagination
     if ($dic->pagination > 0) {
         $elements = $elements->paginate($dic->pagination);
     } else {
         $elements = $elements->get();
     }
     #Helper::tad($elements);
     #Helper::smartQueries(1);
     $elements_pagination = clone $elements;
     #Helper::tad($elements);
     DicLib::extracts($elements, null, true, true);
     #$elements = Dic::modifyKeys($elements, 'id');
     if (Config::get('debug') == 1 || Input::get('debug') == 1) {
         Helper::smartQueries(1);
         Helper::tad($elements);
     }
     $actions_column = false;
     if (Allow::action($this->module['group'], 'dicval_edit') || Allow::action($this->module['group'], 'dicval_delete') || isset($dic_settings['actions']) && is_callable($dic_settings['actions'])) {
         $actions_column = true;
     }
     $total_elements = DicVal::where('dic_id', $dic->id)->where('version_of', '=', NULL)->count();
     $this->callHook('before_index_view_create_edit', $dic, $elements);
     $this->callHook('before_index_view', $dic, $elements);
     $id_left_right = array();
     if (count($elements)) {
         foreach ($elements as $element) {
             $id_left_right[$element->id] = array();
             $id_left_right[$element->id]['left'] = $element->lft;
             $id_left_right[$element->id]['right'] = $element->rgt;
         }
     }
     $hierarchy = (new NestedSetModel())->get_hierarchy_from_id_left_right($id_left_right);
     #Helper::ta($dic);
     #Helper::tad($elements);
     #Helper::dd($hierarchy);
     #Helper::dd($dic_settings['actions']());
     #return View::make(Helper::acclayout());
     #return View::make($this->module['tpl'].'index_old', compact('elements', 'dic', 'dic_id', 'sortable', 'dic_settings', 'actions_column', 'total_elements', 'total_elements_current_selection'));
     return View::make($this->module['tpl'] . 'index', compact('elements', 'elements_pagination', 'hierarchy', 'dic', 'dic_id', 'sortable', 'dic_settings', 'actions_column', 'total_elements', 'total_elements_current_selection', 'search_query', 'listing'));
 }