| Server IP : 79.136.114.73 / Your IP : 216.73.216.191 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/icad.astacus.se/project/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
?>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<table width="1249" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="186"><p><a href="companylist.php">START</a></p></td>
<td width="211"><a href="expiredaction.php">EXPIRED ACTIONS</a></td>
<td width="209"><a href="soonaction.php">SOON TO EXPIRE</a></td>
<td width="158"><a href="forgottenaction.php">COMPLETED</a></td>
<td width="255"><a href="missingdate.php">MISSING DELIVERY DATE</a></td>
<td width="230"><a href="dormancy.php">DORMANCY</a></td>
</tr>
</tbody>
</table>
<p>
<?php
$sql = "SELECT * FROM `CompanyAction` WHERE ToUser LIKE '%.se' group by CompanyId ORDER BY ToUser ";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$sql = "SELECT count(DISTINCT Completed) as Nbr, CompanyId, Completed FROM `CompanyAction` WHERE CompanyId = '".$row['CompanyId']."' ";
$result3 = mysql_query($sql);
while ($row3 = mysql_fetch_assoc($result3)){
$Nbr = $row3['Nbr'];
$CompanyFound = $row3['CompanyId'];
$D = $row3['Completed'];
}
if($Nbr == 1 && $D != 0){
$sql = "SELECT * FROM CompanyAction, Company WHERE Company.CompanyId = CompanyAction.CompanyId and Company.CompanyId = '".$CompanyFound."' and Company.Dormancy = 0 group by Company.CompanyId ";
$result2 = mysql_query($sql);
// echo($sql);
while ($row2 = mysql_fetch_assoc($result2)){
?>
<table width="880" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="80"><a href="historylog.php?companyId=<?php echo($row2['CompanyId']);?>" target="_new"><?php echo($row2['CompanyId']);?></a></td>
<td width="120"><?php echo($row2['TriggerDate']);?></td>
<td width="300"><?php echo($row2['ToUser']);?></td>
<td width="300"><?php echo($row2['clientId']);?></td>
<td width="80"></td>
</tr>
</tbody>
</table>
<?php
}
}
}
?>
</body>
</html>