| 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/ODLDDD_2/seo-mailing/tasks/ |
Upload File : |
<?php
$que = "SELECT *,
(SELECT count(id) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE ".$INFO['sql_tbl_prefix']."mail_user.id_task_unsubscribe = ".$INFO['sql_tbl_prefix']."mail_task.id) as count_uns
FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id = {$_GET['stat']} LIMIT 1";
$res = mysqli_query($db,$que) or exit("select advice error");
$task = mysqli_fetch_array($res);
$task_count = mysqli_fetch_array(mysqli_query($db,"SELECT count(*),
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE ".$INFO['sql_tbl_prefix']."mail_task_email.id_task = {$task['id']} AND ".$INFO['sql_tbl_prefix']."mail_task_email.status = 1 ) as send,
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE ".$INFO['sql_tbl_prefix']."mail_task_email.id_task = {$task['id']} AND ".$INFO['sql_tbl_prefix']."mail_task_email.status = 0 ) as nsend,
(SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE ".$INFO['sql_tbl_prefix']."mail_user.id_task_unsubscribe = {$task['id']}) as un
FROM ".$INFO['sql_tbl_prefix']."mail_task_email WHERE id_task = '".$task['id']."'"));
$open = mysqli_fetch_array(mysqli_query($db,"SELECT count(*) FROM ".$INFO['sql_tbl_prefix']."statistic_open WHERE id_task = '".$task['id']."'"));
?>
<div class="page-header">
<h3><?php echo __('Subject');?>: <?php echo $task['name']?> <?php if($task['cron_status']==1){?><span class="label">Planifier</span><?php }?></h3>
</div>
<table class="table table-bordered">
<tr>
<th class="span2"><?php echo __('Send Date');?></th>
<th><?php echo __('Email Subject');?></th>
<th><?php echo __('Sent From');?></th>
<th><?php echo __('Sent To');?></th>
<th><?php echo __('Opened By');?></th>
<th><?php echo __('Unsubscribed');?></th>
<th><?php echo __('Bounces');?></th>
</tr>
<tbody>
<tr class="font11">
<td><?php echo date("d.m.Y H:i:s", $task['ddate_start']);?></td>
<td><?php echo $task['name'];?></td>
<td><?php echo $_SET['email_from']?></td>
<td class="span1 center"><?php
if($task_count['send'] != 0) {$pr = $task_count['count(*)']*100/$task_count['send'];} else {$pr = 0;} ?>
<input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $task_count['send']?>" readonly="readonly">
</td>
<td class="span1 center">
<input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $open['count(*)']?>" readonly="readonly"></td>
<td class="span1 center">
<input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-min="0" data-max="<?php echo $task_count['count(*)']?>" data-step="1" data-readonly="true" value="<?php echo $task_count['un']?>" readonly="readonly"></td>
<td class="span1 center"><input class="knob" data-fgcolor="#3a87ad" data-thickness=".4" data-readonly="true" value="0" readonly="readonly"></td>
</tr>
</tbody>
</table>
</div>
</div>