public static function buildSiteListCriteria(&$criteria, &$params_list, $is_module = false, $mid = 'm.id')
{
if (empty($params_list)) {
return null;
}
$conditions = $values = $joins = array();
if ($is_module) {
$m = 'm';
$m2 = 's';
$midi18n = $mid;
$join = null;
$join_id = null;
$join_idi18n = null;
$join_i18n = 'site_i18n';
} else {
$m = 't';
$m2 = 's';
$mid = array('l' . $m, $mid);
$midi18n = implode('.', $mid);
$join = 'site';
$join_id = $join . '_id';
$join_idi18n = $join . '_idi18n';
$join_i18n = $join . '_i18n';
}
$nb_id = 0;
$nb_name = 0;
if ($is_module) {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $mid, 'id', $join_id);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'lt.main_id', 'sites', 'site_id');
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'ltt.linked_id', 'subsites', 'subsite_id');
} else {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', $mid, 'sites', $join_id);
}
$has_id = $nb_id == 1;
if (!$has_id) {
if ($is_module) {
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Georef', $join, 'geom', $join);
}
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Around', $m2 . '.geom', 'tarnd', $join);
$nb_name = self::buildConditionItem($conditions, $values, $joins, $params_list, 'String', array($midi18n, 'ti.search_name'), $is_module ? array('tnam', 'name') : 'tnam', array($join_idi18n, $join_i18n), 'Site');
if ($nb_name === 'no_result') {
return $nb_name;
}
$nb_id += $nb_name;
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.elevation', 'talt', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, $m2, 'site_types'), 'ttyp', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, $m2, 'climbing_styles'), 'tcsty', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.equipment_rating', 'tprat', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.routes_quantity', 'rqua', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.mean_height', 'tmhei', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.mean_rating', 'tmrat', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, $m2, 'facings'), 'tfac', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, $m2, 'rock_types'), 'trock', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.children_proof', 'chil', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.rain_proof', 'rain', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'ti.culture', 'tcult', $join_i18n);
// book criteria
$nb_name = Book::buildBookListCriteria($criteria, $params_list, false, 't', 'main_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
// article criteria
$nb_name = Article::buildArticleListCriteria($criteria, $params_list, false, 't', 'linked_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
if (isset($criteria[2]['join_tbook']) || isset($criteria[2]['join_tarticle'])) {
$joins['join_site'] = true;
if (!$is_module) {
$joins['post_site'] = true;
}
}
}
if (!empty($conditions)) {
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
}
if (!empty($joins)) {
$joins['join_site'] = true;
}
if ($is_module && $nb_id) {
$joins['nb_id'] = $nb_id;
}
$criteria[2] += $joins;
return null;
}
public static function buildListCriteria($params_list)
{
$criteria = $conditions = $values = $joins = $joins_order = array();
$criteria[0] = array();
// conditions
$criteria[1] = array();
// values
$criteria[2] = array();
// joins
$criteria[3] = array();
// joins for order
// criteria for disabling personal filter
self::buildPersoCriteria($conditions, $values, $joins, $params_list, 'books');
// orderby criteria
$orderby_list = c2cTools::getRequestParameterArray(array('orderby', 'orderby2', 'orderby3'));
self::buildOrderCondition($joins_order, $orderby_list, array('bnam'), array('book_i18n', 'join_book'));
// return if no criteria
if (isset($joins['all']) || empty($params_list)) {
$criteria[0] = $conditions;
$criteria[1] = $values;
$criteria[2] = $joins;
$criteria[3] = $joins_order;
return $criteria;
}
// area criteria
self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', array('g', 'linked_id'), 'areas', 'area_id');
// book / article criteria
$has_name = Book::buildBookListCriteria($criteria, $params_list, true);
if ($has_name === 'no_result') {
return $has_name;
}
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Istring', 'm.author', 'auth', null);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Istring', 'm.editor', 'edit', null);
// linked doc criteria
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'lbd.linked_id', 'bdocs', 'bdoc');
// image criteria
$has_name = Image::buildImageListCriteria($criteria, $params_list, false);
if ($has_name === 'no_result') {
return $has_name;
}
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
$criteria[2] += $joins;
$criteria[3] += $joins_order;
return $criteria;
}
public static function buildParkingListCriteria(&$criteria, &$params_list, $is_module = false, $mid = 'm.id', $m = 'p')
{
if (empty($params_list)) {
return null;
}
$conditions = $values = $joins = array();
if ($is_module) {
$m = 'm';
$m2 = 'p';
$midi18n = $mid;
$join = null;
$join_id = null;
$join_idi18n = null;
$join_i18n = 'parking_i18n';
} else {
$m2 = $m;
$mid = array('l' . $m, $mid);
$midi18n = implode('.', $mid);
$join = 'parking';
$join_id = $join . '_id';
$join_idi18n = $join . '_idi18n';
$join_i18n = $join . '_i18n';
}
$nb_id = 0;
$nb_name = 0;
if ($is_module) {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $mid, 'id', $join_id);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'lp.main_id', 'parkings', 'parking_id');
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'lpp.linked_id', 'subparkings', 'subparking_id');
} else {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', $mid, 'parkings', $join_id);
}
$has_id = $nb_id == 1;
if (!$has_id) {
if ($is_module) {
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Georef', $join, 'geom', $join);
}
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Around', $m2 . '.geom', 'parnd', $join);
$nb_name = self::buildConditionItem($conditions, $values, $joins, $params_list, 'String', array($midi18n, 'pi.search_name'), $is_module ? array('pnam', 'name') : 'pnam', array($join_idi18n, $join_i18n), 'Parking');
if ($nb_name === 'no_result') {
return $nb_name;
}
$nb_id += $nb_name;
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.elevation', 'palt', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.public_transportation_rating', 'tp', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, $m2, 'public_transportation_types'), 'tpty', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'pi.culture', 'pcult', $join_i18n);
// book criteria
$nb_name = Book::buildBookListCriteria($criteria, $params_list, false, 'p', 'main_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
// article criteria
$nb_name = Article::buildArticleListCriteria($criteria, $params_list, false, 'p', 'linked_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
if (isset($criteria[2]['join_pbook']) || isset($criteria[2]['join_particle'])) {
$joins['join_parking'] = true;
if (!$is_module) {
$joins['post_parking'] = true;
}
}
}
if (!empty($conditions)) {
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
}
if (!empty($joins)) {
$joins['join_parking'] = true;
}
if ($is_module && $nb_id) {
$joins['nb_id'] = $nb_id;
}
$criteria[2] += $joins;
return null;
}
public static function buildListCriteria($params_list)
{
$criteria = $conditions = $values = $joins = $joins_order = array();
$criteria[0] = array();
// conditions
$criteria[1] = array();
// values
$criteria[2] = array();
// joins
$criteria[3] = array();
// joins for order
// criteria for disabling personal filter
self::buildPersoCriteria($conditions, $values, $joins, $params_list, 'articles');
// orderby criteria
$orderby_list = c2cTools::getRequestParameterArray(array('orderby', 'orderby2', 'orderby3'));
self::buildOrderCondition($joins_order, $orderby_list, array('cnam'), array('article_i18n', 'join_article'));
// area criteria
self::buildAreaCriteria($criteria, $params_list, 'a');
// return if no criteria
if (isset($joins['all']) || empty($params_list)) {
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
$criteria[2] += $joins;
$criteria[3] += $joins_order;
return $criteria;
}
// article criteria
$has_name = Article::buildArticleListCriteria($criteria, $params_list, true);
if ($has_name === 'no_result') {
return $has_name;
}
// linked document criteria
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'lcd.main_id', 'cdocs', 'cdoc');
// summit criteria
$has_name = Summit::buildSummitListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// hut criteria
$has_name = Hut::buildHutListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// parking criteria
$has_name = Parking::buildParkingListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// route criteria
$has_name = Route::buildRouteListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// site criteria
$has_name = Site::buildSiteListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// outing criteria
$has_name = Outing::buildOutingListCriteria($criteria, $params_list, false, 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// book criteria
$has_name = Book::buildBookListCriteria($criteria, $params_list, false, 'c', 'main_id');
if ($has_name === 'no_result') {
return $has_name;
}
// image criteria
$has_name = Image::buildImageListCriteria($criteria, $params_list, false);
if ($has_name === 'no_result') {
return $has_name;
}
// user criteria
self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', array('u', 'main_id'), 'users', 'user_id');
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
$criteria[2] += $joins;
$criteria[3] += $joins_order;
return $criteria;
}
public static function buildHutListCriteria(&$criteria, &$params_list, $is_module = false, $mid = 'm.id')
{
if (empty($params_list)) {
return null;
}
$conditions = $values = $joins = array();
if ($is_module) {
$m = 'm';
$m2 = 'h';
$midi18n = $mid;
$join = null;
$join_id = null;
$join_idi18n = null;
$join_i18n = 'hut_i18n';
} else {
$m = 'h';
$m2 = $m;
$mid = array('l' . $m, $mid);
$midi18n = implode('.', $mid);
$join = 'hut';
$join_id = $join . '_id';
$join_idi18n = $join . '_idi18n';
$join_i18n = $join . '_i18n';
}
$nb_id = 0;
$nb_name = 0;
if ($is_module) {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $mid, array('id', 'huts'), $join_id);
} else {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', $mid, 'huts', $join_id);
}
$has_id = $nb_id == 1;
if (!$has_id) {
if ($is_module) {
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, 'h', 'activities'), 'act', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Georef', $join, 'geom', $join);
}
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Around', $m2 . '.geom', 'harnd', $join);
$nb_name = self::buildConditionItem($conditions, $values, $joins, $params_list, 'String', array($midi18n, 'hi.search_name'), $is_module ? array('hnam', 'name') : 'hnam', array($join_idi18n, $join_i18n), 'Hut');
if ($nb_name === 'no_result') {
return $nb_name;
}
$nb_id += $nb_name;
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Array', array($m, 'h', 'activities'), 'hact', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.elevation', 'halt', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.shelter_type', 'htyp', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Bool', $m . '.is_staffed', 'hsta', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.staffed_capacity', 'hscap', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.unstaffed_capacity', 'hucap', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.has_unstaffed_matress', 'hmat', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.has_unstaffed_blanket', 'hbla', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.has_unstaffed_gas', 'hgas', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.has_unstaffed_wood', 'hwoo', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'hi.culture', 'hcult', $join_i18n);
// book criteria
$nb_name = Book::buildBookListCriteria($criteria, $params_list, false, 'h', 'main_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
// article criteria
$nb_name = Article::buildArticleListCriteria($criteria, $params_list, false, 'h', 'linked_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
if (isset($criteria[2]['join_hbook']) || isset($criteria[2]['join_harticle'])) {
$joins['join_hut'] = true;
if (!$is_module) {
$joins['post_hut'] = true;
}
}
}
if (!empty($conditions)) {
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
}
if (!empty($joins)) {
$joins['join_hut'] = true;
}
if ($is_module && $nb_id) {
$joins['nb_id'] = $nb_id;
}
$criteria[2] += $joins;
return null;
}
public static function buildSummitListCriteria(&$criteria, &$params_list, $is_module = false, $mid = 'm.id')
{
if (empty($params_list)) {
return null;
}
$conditions = $values = $joins = array();
if ($is_module) {
$m = 'm';
$m2 = 's';
$midi18n = $mid;
$join = null;
$join_id = null;
$join_idi18n = null;
$join_i18n = 'summit_i18n';
} else {
$m = 's';
$m2 = $m;
$mid = array('l' . $m, $mid);
$midi18n = implode('.', $mid);
$join = 'summit';
$join_id = $join . '_id';
$join_idi18n = $join . '_idi18n';
$join_i18n = $join . '_i18n';
}
$nb_id = 0;
$nb_name = 0;
if ($is_module) {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $mid, 'id', $join_id);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'ls.main_id', 'summits', 'summit_id');
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Id', 'lss.linked_id', 'subsummits', 'subsummit_id');
} else {
$nb_id = self::buildConditionItem($conditions, $values, $joins, $params_list, 'MultiId', $mid, 'summits', $join_id);
}
$has_id = $nb_id == 1;
if (!$has_id) {
if ($is_module) {
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Georef', $join, 'geom', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Istring', 'maps_info', 'mapinfo', $join);
}
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Around', $m2 . '.geom', 'sarnd', $join);
$nb_name = self::buildConditionItem($conditions, $values, $joins, $params_list, 'String', array($midi18n, 'si.search_name'), $is_module ? array('snam', 'name') : 'snam', array($join_idi18n, $join_i18n), 'Summit');
if ($nb_name === 'no_result') {
return $nb_name;
}
$nb_id += $nb_name;
self::buildConditionItem($conditions, $values, $joins, $params_list, 'Compare', $m . '.elevation', 'salt', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', $m . '.summit_type', 'styp', $join);
self::buildConditionItem($conditions, $values, $joins, $params_list, 'List', 'si.culture', 'scult', $join_i18n);
// book criteria
$nb_name = Book::buildBookListCriteria($criteria, $params_list, false, 's', 'main_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
// article criteria
$nb_name = Article::buildArticleListCriteria($criteria, $params_list, false, 's', 'linked_id');
if ($nb_name === 'no_result') {
return $nb_name;
}
if (isset($criteria[2]['join_sbook']) || isset($criteria[2]['join_sarticle'])) {
$joins['join_summit'] = true;
if (!$is_module) {
$joins['post_summit'] = true;
}
}
}
if (!empty($conditions)) {
$criteria[0] = array_merge($criteria[0], $conditions);
$criteria[1] = array_merge($criteria[1], $values);
}
if (!empty($joins)) {
$joins['join_summit'] = true;
}
if ($is_module && $nb_id) {
$joins['nb_id'] = $nb_id;
}
$criteria[2] += $joins;
return null;
}
