Exemplo n.º 1
0
 /**  
  * Executes list action.
  * Overrides documentsActions::executeList()
  */
 public function executeList()
 {
     // params in order to add images of linked summits, parkings, etc...
     $request_array = array();
     if ($this->hasRequestParameter('rsummits') && ($summit_ids = $this->getRequestParameter('rsummits'))) {
         if (!in_array($summit_ids, array('-', ' '))) {
             $request_array = array(explode('-', $summit_ids), 'sr', 'ri', 'si');
         }
     } elseif ($this->hasRequestParameter('rparkings') && ($parking_ids = $this->getRequestParameter('rparkings'))) {
         if (!in_array($parking_ids, array('-', ' '))) {
             $request_array = array(explode('-', $parking_ids), 'pr', 'ri', 'pi');
         }
     } elseif ($this->hasRequestParameter('rhuts') && ($hut_ids = $this->getRequestParameter('rhuts'))) {
         if (!in_array($hut_ids, array('-', ' '))) {
             $request_array = array(explode('-', $hut_ids), 'hr', 'ri', 'hi');
         }
     } elseif ($this->hasRequestParameter('oroutes') && ($route_ids = $this->getRequestParameter('oroutes'))) {
         if (!in_array($route_ids, array('-', ' '))) {
             $request_array = array(explode('-', $route_ids), 'ro', 'oi', 'ri');
         }
     } elseif ($this->hasRequestParameter('osites') && ($site_ids = $this->getRequestParameter('osites'))) {
         if (!in_array($site_ids, array('-', ' '))) {
             $request_array = array(explode('-', $site_ids), 'to', 'oi', 'ti');
         }
     }
     if (!empty($request_array)) {
         $ids = array_shift($request_array);
         $pager = new c2cDoctrinePager('Image', c2cTools::mobileVersion() ? sfConfig::get('app_list_mobile_maxline_number') : sfConfig::get('app_list_maxline_number'));
         $this->pager = $pager;
         $q = $pager->getQuery();
         $q->select('DISTINCT i.id, i.image_type, i.geom_wkt, i.filename, ii.name, ii.culture, ii.search_name')->from('Image i')->leftJoin('i.associations a ON i.id = a.linked_id')->leftJoin('i.ImageI18n ii')->where('(a.main_id IN (SELECT a2.linked_id FROM Association a2 WHERE a2.main_id IN (' . implode(',', $ids) . ') AND a2.type = ?) AND a.type = ?)' . ' OR (a.main_id IN (' . implode(',', $ids) . ') AND a.type = ?)', $request_array);
         $pager->setPage($this->getRequestParameter('page', 1));
         $pager->init();
         $nb_results = $pager->getNbResults();
         $this->nb_results = $nb_results;
         // deal with format
         if (isset($this->format)) {
             $format = $this->format;
         } else {
             $format = $this->getRequestParameter('format', 'list');
             $format = explode('-', $format);
             $this->format = $format;
         }
         if ($nb_results == 0 && !in_array('json', $format)) {
             $params_list = array_keys(c2cTools::getCriteriaRequestParameters());
             if (count($params_list) == 1) {
                 $param = reset($params_list);
                 if (strpos($param, 'nam') !== false) {
                     $this->query_string = $this->getRequestParameter($param);
                     $this->setTemplate('../../documents/templates/simplenoresult');
                 }
             }
         } else {
             $this->items = $pager->getResults('array');
         }
         $this->setPageTitle($this->__($this->getModuleName() . ' list'));
         $this->setTemplate('list');
     } else {
         parent::executeList();
         $nb_results = $this->nb_results;
         if ($nb_results == 0) {
             return;
         }
         $items = $this->query->execute(array(), Doctrine::FETCH_ARRAY);
         $this->items = Language::parseListItems($items, 'Image');
         $this->setTemplate('list');
     }
     if (in_array('json', $this->format)) {
         $this->setJsonResponse();
         $this->setTemplate('../../documents/templates/jsonlist');
     }
 }
 public static function browseId($model = 'Document', $sort, $criteria, $format = array(), $page = 1, $count = 0)
 {
     $conditions = $criteria[0];
     $values = $criteria[1];
     $joins = $criteria[2];
     $joins_order = $criteria[3];
     $joins_pager = $joins + $joins_order;
     $module = c2cTools::model2module($model);
     $mi = c2cTools::Model2Letter($model) . 'i';
     // orderby
     $sort = self::buildSortCriteria($model, $sort['orderby_params'], $sort['order_params'], $sort['npp'], $mi);
     // $npp
     $npp = $sort['npp'];
     // $all
     $all = false;
     if (isset($joins['all'])) {
         $all = $joins['all'];
     }
     // $field_list
     $field_list = call_user_func(array($model, 'buildFieldsList'), false, $mi, $format, $sort);
     // specific $conditions
     if ($module == 'outings' && in_array('cond', $format)) {
         $default_max_age = sfConfig::get('app_outings_recent_conditions_limit', '3W');
         $conditions[] = "age(date) < interval '{$default_max_age}'";
     }
     // $order_by
     $order_by = self::buildOrderby($field_list, $sort);
     // $nb_id
     $nb_id = 0;
     if (isset($joins['nb_id'])) {
         $nb_id = $joins['nb_id'];
     }
     // $pager_count
     if ($nb_id > 0) {
         $count = $nb_id;
     }
     if ($count > $npp) {
         $pager_count = 0;
     } else {
         $pager_count = $count;
     }
     // $independant_count
     $independant_count = !$pager_count && count($joins_pager) > count($joins);
     // create pager
     $pager = new c2cDoctrinePager($model, $npp, $pager_count, $independant_count);
     $pager->setPage($page);
     // independant count
     if ($independant_count) {
         $c = $pager->getCountQuery();
         $c->select('m.id')->from("{$model} m");
         $model::buildPagerConditions($c, $criteria);
     }
     // pager query
     $q = $pager->getQuery();
     $q->select(implode(',', $field_list))->from("{$model} m")->orderBy($order_by);
     if (!$all || !empty($joins_order)) {
         $criteria[2] = $joins_pager;
         $model::buildPagerConditions($q, $criteria);
     } else {
         $pager->simplifyCounter();
     }
     // execute pager query
     $pager->init();
     $count = $pager->getNbResults();
     if ($count == 0) {
         return array('pager' => null, 'nb_results' => 0, 'ids' => null);
     }
     // get ids
     $items = $pager->getResults('array');
     $ids = array();
     $where_ids = array();
     foreach ($items as $item) {
         $ids[] = $item['id'];
         $where_ids[] = '?';
     }
     $where_ids = implode(', ', $where_ids);
     $count_ids = count($ids);
     if ($count_ids == 1) {
         $where = ' = ' . $where_ids;
     } else {
         $where = ' IN ( ' . $where_ids . ' )';
     }
     return array('pager' => $pager, 'nb_results' => $count, 'ids' => $ids, 'where' => $where);
 }