| Server IP : 79.136.114.73 / Your IP : 13.59.90.172 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, Company WHERE CompanyAction.CompanyId = Company.CompanyId and Completed = 0 AND TriggerDate >= '".date("Y-m-d")."' AND TriggerDate <= '".date('Y-m-d', strtotime("+1 week"))."' and Company.Dormancy = 0 ORDER BY ToUser, TriggerDate asc";
$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="880" 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="80"></td>
</tr>
</tbody>
</table>
<?php
}
?>
</body>
</html>