????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.61 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 ACTION </a> <a href="expiredaction.php?sort=euro">€</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
if($_GET['sort'] != "euro"){
$sql = "SELECT * FROM CompanyAction, Company WHERE CompanyAction.CompanyId = Company.CompanyId and ToUser LIKE '%.se' AND Completed = 0 AND TriggerDate < '".date("Y-m-d")."' and Company.Dormancy = 0 ORDER BY ToUser, TriggerDate desc";
}else{
$date = strtotime(date("Y-m-d") .' -36 months');
$final=date('Y-m-d', $date);
$sql = "SELECT CompanyAction.TriggerDate, CompanyAction.CompanyId, CompanyAction.ToUser,CompanyAction.clientId, SUM(Project.STATOrderValue) as OrderValue FROM CompanyAction, Company, Project WHERE Project.CompanyId = Company.CompanyId and Project.statusChangedDate > '".$final."' and CompanyAction.CompanyId = Company.CompanyId and ToUser LIKE '%.se' AND Completed = 0 AND TriggerDate < '".date("Y-m-d")."' and Company.Dormancy = 0 GROUP BY CompanyAction.clientId ORDER BY ToUser, OrderValue desc";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$color = "#ffffff";
$sql = "SELECT * FROM `Project` WHERE ProjectStatusId = '15' and CompanyId = '".$row['CompanyId']."' ";
$result1 = mysql_query($sql);
while ($row1 = mysql_fetch_assoc($result1)){
$color = "#ff0000";
}
?>
<table width="1180" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr bgcolor="<?php echo($color);?>">
<td width="80"><a href="historylog.php?companyId=<?php echo($row['CompanyId']);?>" target="_new"><?php echo($row['CompanyId']);?></a></td>
<td width="120"><?php echo($row['TriggerDate']);?></td>
<td width="300"><?php echo($row['ToUser']);?></td>
<td width="300"><?php echo($row['clientId']);?></td>
<td width="300"><?php echo($row['OrderValue']);?> <?php if($_GET['sort']=="euro"){echo("€");}?></td>
<td width="80"></td>
</tr>
</tbody>
</table>
<?php
}
?>
</body>
</html>