require 'mvg_db.inc.php'; $geoServerStatus = true; $link = mysql_connect(dbHost, dbUser, dbPassword) or die('Could not connect: ' . mysql_error()); mysql_select_db(dbName) or die('Database does not exist'); $start = isset($_POST['start']) ? intval($_POST['start']) : 0; $limit = isset($_POST['limit']) ? intval($_POST['limit']) : 10; if ($start < 0) { $start = 0; } if ($end < $start) { $end = $start; } $sort = isset($_POST['sort']) ? format_mysql($_POST['sort']) : 'start'; $dir = isset($_POST['dir']) ? strtoupper($_POST['dir']) == 'ASC' ? 'ASC' : 'DESC' : 'DESC'; $cb = isset($_REQUEST['callback']) ? preg_replace('/[^\\w]/i', '-', $_REQUEST['callback']) : NULL; $filterWhere = getFilterCondition($_POST['filter']); // Set the end time for old flights which haven't received a stop $query = "SELECT id, end " . "FROM flight " . "WHERE end IS NULL "; $result = mysql_query($query) or die('Query error: ' . mysql_error()); if (mysql_num_rows($result)) { while ($flight = mysql_fetch_object($result)) { $query = "SELECT time, DATEDIFF(CURDATE(), time) AS delta " . "FROM point WHERE flightId={$flight->id} " . "HAVING delta > 1 " . "ORDER BY time DESC limit 0,1"; $result2 = mysql_query($query) or die('Query error: ' . mysql_error()); if (mysql_num_rows($result2) == 1) { $point = mysql_fetch_object($result2); $query = "UPDATE flight SET end='{$point->time}' WHERE id = {$flight->id}"; mysql_query($query) or die('Query error: ' . mysql_error()); } } } // Get the total number of flights
/** * filterProducts function * this funciton is to filter the products from the conditions specified by user, like category, brand, price range of products and outputs the json object for the product. * The funciton can be called from ajax method using action command 'product_filter' * @return void * @author Ankit Balyan - sf.ankit@gmail.com **/ function filterProducts() { global $wpdb; $table = "rw_products"; $user_id = isLogin(); $where = getFilterCondition($_POST); $results = array(); if (!isArvindUSer()) { $sql = "SELECT \n\t\t\t\t product.*, images.image_url\n\t\t\t\tFROM\n\t\t\t\t rw_products AS product\n\t\t\t\t LEFT OUTER JOIN\n\t\t\t\t rw_images AS images ON product.product_id = images.product_id\n\t\t\t\t AND images.thumnail_ind = 1\n\t\t\t\tLEFT OUTER JOIN\n \trw_brand_user_map AS user_brand ON user_brand.user_id = {$user_id}\n LEFT OUTER JOIN\n \trw_brands AS brand ON brand.brand_id = user_brand.brand_id\n OR brand.brand_parent_id = user_brand.brand_id\n\t where\n\t (product.brand_id = brand.brand_id\n\t or\n\t product.brand_id = brand.brand_parent_id)\n\t\t\t\tand {$where}"; } else { $sql = "SELECT \n\t\t\t\t product.*, images.image_url\n\t\t\t\tFROM\n\t\t\t\t rw_products AS product\n\t\t\t\t LEFT OUTER JOIN\n\t\t\t\t rw_images AS images ON product.product_id = images.product_id\n\t\t\t\t AND images.thumnail_ind = 1\n\t\t\t\t where {$where}"; } extract($_POST); if (isset($selecteBrandBox) && count($selecteBrandBox)) { $results['categories'] = getCategories(null, $selecteBrandBox); } $sql .= " GROUP BY product.product_id"; $sql .= " LIMIT 0,100"; $results['catelog'] = $wpdb->get_results($sql); //json_encode($results); header('Content-Type: application/json'); wp_send_json($results); }