| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/seo-mailing/settings/ |
Upload File : |
<?php
$query = "
SELECT DATE(FROM_UNIXTIME(".$INFO['sql_tbl_prefix']."mail_task.ddate_start)) date
,hours.hour
,SUM(IF(HOUR(FROM_UNIXTIME(".$INFO['sql_tbl_prefix']."mail_task.ddate_start))=hours.hour,1,0)) count_task
FROM ".$INFO['sql_tbl_prefix']."mail_task
INNER JOIN (SELECT 0 hour
UNION ALL SELECT 1
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT 7
UNION ALL SELECT 8
UNION ALL SELECT 9
UNION ALL SELECT 10
UNION ALL SELECT 11
UNION ALL SELECT 12
UNION ALL SELECT 13
UNION ALL SELECT 14
UNION ALL SELECT 15
UNION ALL SELECT 16
UNION ALL SELECT 17
UNION ALL SELECT 18
UNION ALL SELECT 19
UNION ALL SELECT 20
UNION ALL SELECT 21
UNION ALL SELECT 22
UNION ALL SELECT 23) hours
WHERE id_user = {$_GET['statistic']}
GROUP BY date,hours.hour";
$res = mysqli_query($db,$query) or exit("select advice error");
$hour_array = array(
"0" => "0:00:00 - 0:59:59",
"1" => "1:00:00 - 1:59:59",
"2" => "2:00:00 - 2:59:59",
"3" => "3:00:00 - 3:59:59",
"4" => "4:00:00 - 4:59:59",
"5" => "5:00:00 - 5:59:59",
"6" => "6:00:00 - 6:59:59",
"7" => "7:00:00 - 7:59:59",
"8" => "8:00:00 - 8:59:59",
"9" => "9:00:00 - 9:59:59",
"10" => "10:00:00 - 10:59:59",
"11" => "11:00:00 - 11:59:59",
"12" => "12:00:00 - 12:59:59",
"13" => "13:00:00 - 13:59:59",
"14" => "14:00:00 - 14:59:59",
"15" => "15:00:00 - 15:59:59",
"16" => "16:00:00 - 16:59:59",
"17" => "17:00:00 - 17:59:59",
"18" => "18:00:00 - 18:59:59",
"19" => "19:00:00 - 19:59:59",
"20" => "20:00:00 - 20:59:59",
"21" => "21:00:00 - 21:59:59",
"22" => "22:00:00 - 22:59:59",
"23" => "23:00:00 - 23:59:59",
);
if(mysqli_num_rows($res) > 0){?>
<table class="table">
<tr>
<th class="span2"><?php echo __('Date')?></th>
<th class="span2"><?php echo __('Hour')?></th>
<th><?php echo __('Count task')?></th>
</tr>
<?php while($task = mysqli_fetch_array($res)){?>
<tr class="font11">
<td><i class="icon-calendar"></i> <?php echo $task['date']?></td>
<td><i class="icon-time"></i> <?php echo $hour_array[$task['hour']]?></td>
<td><span class="label<?php if($task['count_task'] != 0 ){?> label-success<?php }?>"><?php echo $task['count_task']?></span></td>
</tr>
<?php } ?>
</table>
<?php }else{?>
<div class="alert alert-info">
</div>
<?php }?>