public static function buildPagerConditions(&$q, $criteria)
{
$conditions = $criteria[0];
$values = $criteria[1];
$joins = $criteria[2];
$route_join = 'm.MainGeoassociations';
$route_ltype = '';
$summit_join = 'm.MainGeoassociations';
$summit_ltype = '';
$hut_join = 'm.MainGeoassociations';
$hut_ltype = '';
$parking_join = 'm.MainGeoassociations';
$parking_ltype = '';
$site_join = 'm.MainGeoassociations';
$site_ltype = '';
$user_join = 'm.MainGeoassociations';
$user_ltype = '';
// join with area tables only if needed
if (isset($joins['join_area'])) {
Area::buildAreaPagerConditions($q, $joins, true);
}
// join with outing tables only if needed
if (isset($joins['join_outing'])) {
Outing::buildOutingPagerConditions($q, $joins, false, false, 'm.MainGeoassociations', '');
$route_join = 'lo.MainAssociation';
$route_ltype = 'ro';
$summit_join = 'lr.MainAssociation';
$summit_ltype = 'sr';
$hut_join = 'lr.MainAssociation';
$hut_ltype = 'hr';
$parking_join = 'lr.MainAssociation';
$parking_ltype = 'pr';
$site_join = 'lo.MainAssociation';
$site_ltype = 'to';
$user_join = 'lu.MainAssociations';
$user_ltype = 'uo';
}
// join with route tables only if needed
if (isset($joins['join_route'])) {
Route::buildRoutePagerConditions($q, $joins, false, false, $route_join, $route_ltype);
$summit_join = 'lr.MainAssociation';
$summit_ltype = 'sr';
$hut_join = 'lr.MainAssociation';
$hut_ltype = 'hr';
$parking_join = 'lr.MainAssociation';
$parking_ltype = 'pr';
}
// join with summit tables only if needed
if (isset($joins['join_summit'])) {
Summit::buildSummitPagerConditions($q, $joins, false, false, $summit_join, $summit_ltype);
}
// join with hut tables only if needed
if (isset($joins['join_hut'])) {
Hut::buildHutPagerConditions($q, $joins, false, false, $hut_join, $hut_ltype);
}
// join with parking tables only if needed
if (isset($joins['join_parking'])) {
Parking::buildParkingPagerConditions($q, $joins, false, false, $parking_join, $parking_ltype);
}
// join with site tables only if needed
if (isset($joins['join_site'])) {
Site::buildSitePagerConditions($q, $joins, false, false, $site_join, $site_ltype);
}
// join with product tables only if needed
if (isset($joins['join_product'])) {
Product::buildProductPagerConditions($q, $joins, false, false, 'm.MainGeoassociations', '');
}
// join with user tables only if needed
if (isset($joins['join_user'])) {
User::buildUserPagerConditions($q, $joins, false, false, $user_join, $user_ltype);
}
// join with image tables only if needed
if (isset($joins['join_image'])) {
Image::buildImagePagerConditions($q, $joins, false, '');
}
if (!empty($conditions)) {
$q->addWhere(implode(' AND ', $conditions), $values);
}
}
public static function buildPagerConditions(&$q, $criteria)
{
$conditions = $criteria[0];
$values = $criteria[1];
$joins = $criteria[2];
self::buildAreaIdPagerConditions($q, $joins);
// join with product tables only if needed
if (isset($joins['join_product'])) {
Product::buildProductPagerConditions($q, $joins, true);
}
// join with parkings tables only if needed
if (isset($joins['join_hut'])) {
$joins['join_parking'] = true;
$joins['post_parking'] = true;
}
if (isset($joins['join_parking'])) {
Parking::buildParkingPagerConditions($q, $joins, false, false, 'm.associations', 'pf', 'q');
// join with huts tables only if needed
if (isset($joins['join_hut'])) {
Hut::buildHutPagerConditions($q, $joins, false, true, 'lp.LinkedLinkedAssociation', 'ph');
}
}
// join with image tables only if needed
if (isset($joins['join_image'])) {
Image::buildImagePagerConditions($q, $joins, false, 'fi');
}
if (!empty($conditions)) {
$q->addWhere(implode(' AND ', $conditions), $values);
}
}
