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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
<?php require_once "inc/configure.php";
$id = isset($_REQUEST['id'])? (int)$_REQUEST['id'] : "";
$sql = "SELECT
master_type_code.*,
master_type.codelen,
master_type.typedesc_en,
master_type.typedesc_sc,
master_type.showext1,
master_type.typeid
FROM
master_type_code
INNER JOIN master_type ON master_type.typeid = master_type_code.typeid
WHERE
master_type_code.id = :id";
//echo $sql;
$sth = $dbh->prepare($sql);
$sth->execute( array(':id'=>$_REQUEST['id']) );
$row = $sth->fetch();
//vdump($row);
unset($sth);?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ENZA</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<?php require_once "inc/jsheader.php"; ?>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" class="top"><?php require"mod_webhead.php"; ?></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" valign="top" class="menu_bg"><?php require"mod_menu.php"; ?></td>
<td valign="top" class="padding1"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr></tr>
<tr>
<td class="c1_bg"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="search">
<tr><form action="master_index.php" method="post">
<td width="80" valign="top" ><span class="stext1">Master:</span></td>
<td width="400" valign="top">
<select name="typeid" >
<?=master_type_option($_REQUEST['typeid'], $_REQUEST['typeid'], true);?>
</select>
</td>
<td align="right" valign="top"><input type="image" src="image/btn_search.jpg" width="64" height="20" /> <a href="master_addform.php?typeid=<?=$_REQUEST['typeid']?>"><img src="image/btn_new.jpg" width="52" height="20" /></a></td>
</form></tr>
</table></td>
</tr>
<tr>
<td valign="top" class="c2_bg">
<!-- content-->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tablelist">
<!-- <tr>
<th align="left">ModifyForm</th>
<th align="left">Table</th>
</tr>-->
<tr>
<td valign="top"><!--master add form-->
<form action="master_modify.php" method="post">
<input type="hidden" name="id" value="<?=$id?>" />
<input type="hidden" name="typeid" value="<?=$row['typeid']?>" />
<table>
<tr>
<th colspan="2"><?=MODIFY?></th>
</tr>
<tr>
<td><?=TYPE?></td>
<td><?=$row['typedesc_'.SYS_LANG]?></td>
</tr>
<tr>
<td><?=CODE?></td>
<td><?=$row['codeid']?></td>
</tr>
<tr>
<td><?=DESC?></td>
<td><input name="codedesc" type="text" value="<?=$row['codedesc_en']?>" /></td>
</tr>
<tr>
<td><?=DESCSC?></td>
<td><input name="ccodedesc" type="text" value="<?=$row['codedesc_sc']?>" /></td>
</tr>
<tr>
<td><?=DELETED?></td>
<td><input type="checkbox" name="deleted" <?=($row['deleted']==1)?'checked="checked"' : '' ?>/></td>
</tr>
<?php if( !empty($row['showext1'] ) ) { ?>
<tr>
<td><?=VALUE?></td>
<td><input name="ext1" type="text" value="<?=$row['ext1']?>" /></td>
</tr>
<?php } ?>
<tr>
<td><?=LAST_MODIFY?></td>
<td><?=lastUpdate($row)?></td>
</tr>
</table>
<input name="submit" type="submit" value="<?=SUBMIT?>" class="pressnhide2" />
<input type="hidden" name="action" value="master_modifyform"/>
<input name="Cancel" value="<?=CANCEL?>" type="button" onclick="location.href='master_index.php?typeid=<?=$row['typeid']?>'"/>
</form>
<!-- end of addform--></td>
<td valign="top" align="right"><?=master_table($row['typeid'], $row['codeid'], true);?></td>
</tr>
</table></td>
</tr>
</table>
<!-- end of content-->
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
|