1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
<?php
require_once('check_login.php');
$date = new DateTime();
$date->modify("+1 month");
$sql = "select * from `order` where status = ? and enddate <= ? and enddate >= ? order by enddate ASC";
$parameters = array("NEW", $date->format("Y-m-d"), date("Y-m-d"));
$rows = bind_pdo($sql, $parameters, "selectall");
if(!empty($_GET["send_alert"]) && !empty($_GET["id"])){
if($_GET["send_alert"] == 1){
//$order_info = get_order((int)$_GET["id"]);
contract_alert_email((int)$_GET["id"]);
}
}
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once("html_head.php"); ?>
</head>
<body>
<table width="1200" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("menu.php"); ?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td width="1000" align="left" valign="top">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> 快將完結合約
</b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (isset($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="130" class="listtitletxt">合約編號</td>
<td width="130" class="listtitletxt">客戶編號</td>
<td width="150" class="listtitletxt">客戶姓名</td>
<td width="80" class="listtitletxt">合約完結到期</td>
<td width="80" class="listtitletxt">發出電郵通知</td>
</tr>
<?php
foreach ($rows as $row) {
$customer_info = get_customer($row["customer_id"]);
$customer_name = get_customer_name(rsa_crypt($customer_info["firstname"], 2), rsa_crypt($customer_info["lastname"], 2));
print '<tr> <form action="invoice_add.php" method="post" name="modifyform" enctype="multipart/form-data" class="form_field">';
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' style='padding-left:5'><a href='order_modifyform.php?order_id=" . $row["id"] . "' target='_blank'> " . $row{'code'} . "</a></td>";
print "<td class='listtxt' style='padding-left:5'><a href='customer_modifyform.php?id=" . $row["customer_id"] . "' target='_blank'> " . $customer_info{'code'} . "</a></td>";
print "<td class='listtxt' style='padding-left:5'><a href='customer_modifyform.php?id=" . $row["customer_id"] . "' target='_blank'>" . $customer_name . "</a></td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'enddate'} . "</td>";
print "<td class='listtxt' style='padding-left:5'><button type='button' onclick='if(confirm(\"確定發出電郵通知?\")){location.href=\"contract_alert.php?id=".$row["id"]."&send_alert=1\";}'>發出電郵通知</button></td>";
print "</form></tr>";
}
?>
</table>
<br> <br> <br> <br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
|