$value) { switch ($key) { case 'valutas': if ($value !== 'all') { $where['valutas:='] = $value; } break; case 'credits_min_period': // Process the period value based on dropdown selection if ($value === '1-359') { // Less than 360 months $where[] = "credits_max_period < 360"; } elseif ($value === '360') { // Exactly 360 months $where[] = "credits_min_period <= 360 AND credits_max_period >= 360"; } elseif ($value === '361-720') { // More than 360 months $where[] = "credits_min_period >= 361"; } break; case 'credits_min_prepayment': if ($value !== 'all') { $min_prepayment = floatval(str_replace(' ', '', $value)); } break; case 'credits_max_prepayment': if ($value !== 'all') { $max_prepayment = floatval(str_replace(' ', '', $value)); } break; } } } // Apply conditions based on prepayment values $conditions = array(); if ($min_prepayment !== null && $max_prepayment !== null) { // Check if the value is within the range between min and max $conditions[] = "(credits_min_prepayment <= " . (float)$max_prepayment . " AND credits_max_prepayment >= " . (float)$min_prepayment . ")"; } elseif ($min_prepayment !== null) { // Check if the value is exactly equal to min_prepayment $conditions[] = "credits_min_prepayment = " . (float)$min_prepayment; $conditions[] = "credits_max_prepayment = " . (float)$min_prepayment; } elseif ($max_prepayment !== null) { // Check if the value is exactly equal to max_prepayment $conditions[] = "credits_min_prepayment = " . (float)$max_prepayment; $conditions[] = "credits_max_prepayment = " . (float)$max_prepayment; } // Combine conditions with OR if (!empty($conditions)) { $where[] = "(" . implode(" OR ", $conditions) . ")"; } // Define filters $filters = [ 'credits_pledge_realestate' => ['Үл хөдлөх'], 'credits_coborrower' => ['Хамтран зээлдэгчтэй', 'Хамтран зээлдэгчгүй'], 'credits_realestate_insurance' => ['Тийм', 'Үгүй'], 'credits_realestate_category' => [ 'Ипотек', 'Орон сууц худалдан авах зээл', 'Ногоон зээл', 'Хувийн орон сууц', 'Авто зогсоол', 'Засвар' ], 'credits_borrower_category' => ['Цалингийн орлоготой', 'Хувиараа хөдөлмөр эрхлэгч', 'Бизнесийн орлоготой'] ]; // Handle default real estate category if (!isset($_POST['filter']['credits_realestate_category'])) { $_POST['filter']['credits_realestate_category'] = [$default_realestate_category]; } // Build filter conditions foreach ($filters as $key => $validValues) { $orConditions = buildOrConditions($key, $validValues); if (!empty($orConditions)) { $where[] = "(" . implode(" OR ", $orConditions) . ")"; } } // Prepare parameters for pdoResources $scriptProperties['where'] = $where; // Debugging: Output the final $where array //echo "Final where conditions:\n"; //print_r($where); // Execute the query $html = $modx->runSnippet('pdoResources', $scriptProperties); // Output the result echo $html;