<?php

// Определяем текущуую дату
$date = isset ($_REQUEST['date']) ? func::checkin($_REQUEST['date']) : date("Y-m-d",core::$realtime);

$daten = date("Y-m-d",(strtotime($date)-3600*24*6));

$datup = date("Y-m-d",(strtotime($date)+3600*24*6));


if($datestart<=$daten) $datens = '<a href="?stat='.$stat.'&amp;order='.$order.'&amp;date='.$daten.'"><< '.$daten.'</a> | ';


if($date<date("Y-m-d",core::$realtime)) $dateup = '| <a href="?stat='.$stat.'&amp;order='.$order.'&amp;date='.$datup.'">'.$datup.' >></a>';

echo '<div class="col-md-12 col-sm-12 col-xs-12"><div class="panel panel-default">
<b>отчет:</b> Количество возвратов на сайт в течение разного времени
<div class="panel-heading">'.$datens.' <b>С '.$daten.' по '.$date.'</b> '.$dateup.'</div>';


// Проверяем есть ли в базе выбранная дата
$dates = core:: $db -> queryFetch("SELECT * FROM `top_count` WHERE `url`=? and date>=? LIMIT 1;", array($url,$daten));
if(!isset($dates['id'])){
echo "<br /><b>Статистики за выбранный вами периoд не найдено.</b><br />";

}else{


echo '<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-blu">
<div class="panel-heading"><b>График</b></div>';
?>
 <script>

var chart;


AmCharts.monthNames = ['Январь', 'Февраль', 'Март', 'Апрель', 'Май', 'Июнь', 'Июль', 'Август', 'Сентябрь', 'Октябрь', 'Ноябрь', 'Декабрь'];

AmCharts.shortMonthNames = ['Январь', 'Февраль', 'Март', 'Апрель', 'Май', 'Июнь', 'Июль', 'Август', 'Сентябрь', 'Октябрь', 'Ноябрь', 'Декабрь'];


var chart = AmCharts.makeChart("graph_dey", {
  "type": "serial",
  "theme": "light",
  "marginRight": 70,
  "dataProvider": [
     <?php

echo '{"times": "от 15 до 30 минут",';
echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '900' and `vozvrat` < '1800'and date >= '".$daten."' and date <= '".$date."';").',
"color": "#FF0F00"
},';

echo '{"times": "от 30 минут до 1 часа",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '1800' and `vozvrat` < '3600'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#FF6600"
    },';
echo '{"times": "от 1 до 3 часов",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '3600' and `vozvrat` < '".(3600*3)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#FF9E01"
 },';

echo '{"times": "от 3 до 12 часов",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*3)."' and `vozvrat` < '".(3600*12)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#FCD202"
 },';

echo '{"times": "от 12 часов до суток",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*12)."' and `vozvrat` < '".(3600*24)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#F8FF01"
 },';

echo '{"times": "от 1 до 3 дней",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*24)."' and `vozvrat` < '".(3600*24*3)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#B0DE09"
 },';

echo '{"times": "от 3 до 7 дней",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*24*3)."' and `vozvrat` < '".(3600*24*7)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#04D215"
 },';

echo '{"times": "от 7 до 14 дней",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*24*7)."' and `vozvrat` < '".(3600*24*14)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#0D8ECF"
 },';

echo '{"times": "от 14 до 31 дня",';
 echo '"vozvrat": '.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `vozvrat` >= '".(3600*24*14)."' and `vozvrat` < '".(3600*24*31)."'and date >= '".$daten."' and date <= '".$date."';").',
    "color": "#0D52D1"
    }';

     ?>
],
"valueAxes": [{
    "axisAlpha": 0,
    "position": "left"
  }],
  "startDuration": 1,
  "graphs": [{
    "balloonText": "<div style='margin:5px; font-size:19px;'>[[category]]: <b>[[value]]</b></div>",
    "fillColorsField": "color",
    "fillAlphas": 0.9,
    "lineAlpha": 0.2,
    "type": "column",
    "valueField": "vozvrat"
  }],
  "chartCursor": {
    "categoryBalloonEnabled": false,
    "cursorAlpha": 0,
    "zoomable": false
  },
  "categoryField": "times",
  "categoryAxis": {
    "gridPosition": "start",
    "labelRotation": 45
  },
  "export": {
    "enabled": true
  }

});





  </script>
   <!-- chart container -->
<div id="graph_dey" style="width: auto; height: 300px;"></div>

<?php


echo '</div></div>';

echo '<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-blu">';

echo '<div class="panel-heading"><b>Количество возвратов на сайт за 7 дней</b></div>
 <div class="table-responsive">
 <table class="table"><thead><tr><th>Время</th><th>Возвратов (суммарное)</th></tr></thead>
 <tbody> ';

 echo '<tr class="success"><td>от 15 до 30 минут</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '900' and `vozvrat` < '1800'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 30 минут до 1 часа</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '1800' and `vozvrat` < '3600'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 1 до 3 часов</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '3600' and `vozvrat` < '".(3600*3)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 3 до 12 часов</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*3)."' and `vozvrat` < '".(3600*12)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 12 часов до суток</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*12)."' and `vozvrat` < '".(3600*24)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 1 до 3 дней</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*24)."' and `vozvrat` < '".(3600*24*3)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 3 до 7 дней</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*24*3)."' and `vozvrat` < '".(3600*24*7)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 7 до 14 дней</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*24*7)."' and `vozvrat` < '".(3600*24*14)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';

 echo '<tr class="success"><td>от 14 до 31 дня</td><td>'.core:: $db -> querySingle("select count(*) as num from top_ip WHERE `url` = '".$url."' and `vozvrat` >= '".(3600*24*14)."' and `vozvrat` < '".(3600*24*31)."'and date >= '".$daten."' and date <= '".$date."';").'</td></tr> ';


  echo '</tbody>
 </table>
 </div>
';
echo '</div></div>';
}

?>