<?php include_once "/home/mari12/public_html/include/common.php"; //if (!isset($_SESSION["admin"])) exit(); global $db; $db2 = new DB($config['dbserver'], $config['dbname'], $config['dbuser'], $config['dbpassword']); function saveAveragePrices($start_date, $end_date) { global $db; global $db2; $prev_end_date = getNextDate($end_date, -1); $sql = "SELECT rooms, ROUND(AVG(price)) price_avr, ROUND(AVG(total_area),1) area_avr, \n\t\tROUND(AVG(price_m),1) price_m_avr \n\t\tFROM flat f, tenement t WHERE f.updated_on>='{$start_date}' \n\t\t\tAND f.updated_on<'{$end_date}' AND total_area > 29 AND total_area < 400\n\t\t\tAND f.price>1000000 AND f.price < 6000000 AND f.tenement_id=t.id\n\t\t\tAND f.status IN (2,6)\n\t\t\tAND t.city_id=0 \n\t\tGROUP BY rooms"; $db->query($sql); while ($row = $db->fetchRow()) { $sql2 = "INSERT INTO average_flat_price VALUES \n\t\t('{$prev_end_date}','{$row['rooms']}','{$row['price_avr']}','{$row['area_avr']}','{$row['price_m_avr']}')"; $db2->query($sql2); } } $start_date = '2014-03-17'; //Пн $db->query("DELETE FROM average_flat_price WHERE date>='{$start_date}'"); while ($start_date < date('Y-m-d')) { $end_date = getNextDate($start_date, 7); saveAveragePrices($start_date, $end_date); $start_date = $end_date; } $end_date = date('Y-m-d'); //$end_date = '2015-09-14'; $start_date = getNextDate($end_date, -7); //saveAveragePrices($start_date,$end_date);
$end_date = '2011-10-30'; //Вс $start_date = getNextDate($end_date, -6); //Пн //$prev_end_date = getNextDate($end_date,-1); $i = 0; while ($end_date < date("Y-m-d") && $i < 1000) { saveAveragePrices($start_date, $end_date); $start_date = getNextDate($start_date, 7); //Пн $end_date = getNextDate($start_date, 6); //Вс $i++; } if (dateDiff('now', $start_date) > 0) { saveAveragePrices(getNextDate($start_date, 1), date("Y-m-d")); } //ob_start(); header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=download.csv"); header("Pragma: no-cache"); header("Expires: 0"); echo $query = "SELECT * FROM _tmp_prices2"; $export = $db->query($query) or die("Sql error : " . mysql_error()); $fields = mysql_num_fields($export); $fp = fopen('php://output', 'w'); $header = []; for ($i = 0; $i < $fields; $i++) { $header[] = mysql_field_name($export, $i); } fputcsv($fp, $header);