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
|
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
header("Location: login.php");
exit;
}
$series_id = (int)$_GET["series_id"];
$sth1 = $dbh->prepare("SELECT * FROM series WHERE series_id=? ");
$parameter = array($series_id);
if (!$sth1->execute($parameter))
throw new Exception('[' . $sth1->errorCode() . ']: ' . print_r($sth1->errorInfo()));
$row = $sth1->fetch(PDO::FETCH_ASSOC);
$sql99 = "SELECT * FROM sys_cms_login WHERE cmsloginid=?";
$sth99 = $dbh->prepare($sql99);
$sth99->execute(array((int)$row{'lastupby'}));
$row99 = $sth99->fetch(PDO::FETCH_ASSOC);
//check if this model has been record for a warranty
$sql = "select * from customer_warranty warranty, series series, model model where series.series_id = model.series_id and warranty.model_code = model.model_code and warranty.series_code = series.series_code and model.series_id = ? and warranty.deleted = ?";
if (!($sth = $dbh->prepare($sql))) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
if (!$sth->execute(array($series_id, "0"))) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
if($sth->rowCount() > 0){
echo "<script>alert('This series already linked with some customer warranty.');</script>";
}
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title>Content Management System (CMS) - Powered by One Solution Limited</title>
</head>
<body>
<form action="series_modify.php" method="post" name="modifyform" enctype="multipart/form-data">
<input type="hidden" name="series_id" value="<?= $row{'series_id'}; ?>">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="right" valign="middle" class="icontxt">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" align="center">
<input type="image" alt="submit" src="images/iconSave.png" width="32" height="32" border="0"><br> Save
</td>
<td width="50" align="center">
<a href="series_index.php?msg=Cancel"><img src="images/iconCancel.png" alt="Cancel" width="32" height="32" border="0"><br> Cancel
</a></td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<span style="float:left;" class="pagetitletxt"> <b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> Modify: Product Model
</b></span><span style="float:right;" class="msg">Last Update: <?= $row99{'cmsloginname'} . ' ' . $row{'lastupdate'}; ?></span>
</td>
</tr>
<tr>
<td align="left" valign="middle"><!-- Content -->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" align="right" valign="top" class='content'>Region</td>
<td class='content' valign="top">: </td>
<td class='content'>
<input type="radio" class="content" name="region" value="CN" <?php if($row{"region"} == "CN") echo "checked"; ?> /><label>CN</label>
<input type="radio" class="content" name="region" value="HK" <?php if($row{"region"} == "HK") echo "checked"; ?>/><label>HK</label>
<br><br>
</td>
</tr>
<tr>
<td width="120" align="right" valign="top" class='content'>Series Code</td>
<td class='content' valign="top">: </td>
<td class='content'>
<input type="text" class="content" name="series_code" size="80" maxlength="100" value="<?=$row{"series_code"}?>" /><br><span class="msg">Maxlength:100</span>
<br><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
|