0 And
dw_sn_field.fieldType = 7 And
dw_sn_page.pageActive = 1 And
dw_sn_field.fieldActive = 1 And
dw_sn_page.pageSite = ? And
dw_sn_value.valueDay > ?
Order By
dw_sn_value.valueDay Desc,
dw_dtarea.dtAreaOrder,
dw_dtarea.dtAreaText
";
if(!$query = mysqli_prepared_query($link, $sql, "is", array($_SESSION['userSite'], date('Y-m-d',strtotime("-1 year"))), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
echo "
| Date |
Tab |
Field |
Amount |
Reason |
";
$csv .= "Date,Tab,Field,Amount,Reason\r\n";
$prev = "";
$sum = 0;
foreach($query as $array){
if($array['pageText']!= $prev && $prev!=""){ //group by page (tab)
echo "
| |
".$sum." |
|
";
$sum = 0;
}
$prev = $array['pageText'];
$day = $array['valueDay'];
$p = $array['pageID'];
echo "
| ".date('d/m/y',strtotime($array['valueDay']))." |
".$array['pageText']." |
".$array['fieldTitle']." |
".$array['valueValue']." |
".$array['dtAreaText']." |
";
$csv .= date('d/m/y',strtotime($array['valueDay'])).",".
$array['pageText'].",".
$array['fieldTitle'].",".
$array['valueValue'].",".
$array['dtAreaText']."\r\n";
$sum += $array['valueValue'];
}
//write csv data
$csv_file = fopen("downtime".$_SESSION['userSite'].".csv","w");
fwrite($csv_file, $csv);
fclose($csv_file);
echo "
|
".$sum." |
|
";
?>