01. <table width="100%" border="0" cellspacing="1" class="tablesorter">
02. <thead>
03. <tr>
04. <th>Contract Partner</th>
05. <th>Contract Type</th>
06. <th>Contract Subject</th>
07. <th>Contract Expire</th>
08. <th>Remaining time</th>
09. </tr>
10. </thead>
11.<?php
12.
13.
14.$hostname_contract_manager = "localhost";
15.$database_contract_manager = "xxxxxxx";
16.$username_contract_manager = "xxxxxxxx";
17.$password_contract_manager = "";
18.$contract_manager = mysql_pconnect($hostname_contract_manager, $username_contract_manager, $password_contract_manager) or
19. trigger_error(mysql_error(), E_USER_ERROR);
20.
21.
22.
23.mysql_select_db($database_contract_manager, $contract_manager) or die("Can Not Connect to Database Server");
24.
25.$query_ContractManage =
26."SELECT
27.Contract_Partner,
28.Contract_Type,
29.Contract_Subject,
30.Contract_Expire,
31.(to_days(`contract_details`.`Contract_Expire`) - to_days(curdate())) as countdate
32.
33.FROM
34.contract_details, contract_user
35.where (to_days(`contract_details`.`Contract_Expire`) - to_days(curdate())) <= 30";
36.$ContractManage = mysql_query($query_ContractManage, $contract_manager) or die(mysql_error());
37.
38.
39.$totalRows_ContractManage = mysql_num_rows($ContractManage);
40.if ($totalRows_ContractManage <> 0)
41.{
42.
43. $ContractManage = mysql_query($query_ContractManage);
44.
45.
46. while ($row_ContractManage = mysql_fetch_assoc($ContractManage))
47. {
48. $Contract_ID = $row_ContractManage[Contract_ID];
49. $Contract_Partner = $row_ContractManage[Contract_Partner];
50. $Contract_Type = $row_ContractManage[Contract_Type];
51. $Contract_Subject = $row_ContractManage[Contract_Subject];
52. $Contract_Expire = $row_ContractManage[Contract_Expire];
53. $countExpireDate = $row_ContractManage[countdate];
54. $Admin_Notification = $row_ContractManage[Admin_Notification];
55. ?>
56. <tbody>
57. <tr valign='top'>
58. <td align='left'><?= $Contract_Partner?></td>
59. <td align='center'><?= $Contract_Type?></td>
60. <td align='center'><?= $Contract_Subject?></td>
61. <td align='center'><?= $Contract_Expire?></td>
62. <td align='center'><?= $countExpireDate?></td>
63. </tr>
64. </tbody>
65. <?php
66. $Row_No++;
67. }mysql_close();}
68. ?>
69. </table>
