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
|
<?php
$formid = "Order";
require_once "inc/configure.php";
require_once "inc/ord_dtl_func.php";
$refid = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_STRING);
if( $_POST['action']=="ord_disd_modifyform" && !empty($refid) ){
//vdump($_REQUEST); exit;
$custcode = filter_var($_REQUEST['custcode'], FILTER_SANITIZE_STRING);
$order_nbr = filter_var($_REQUEST['order_nbr'], FILTER_SANITIZE_STRING);
$vendor = filter_var($_REQUEST['vendor'], FILTER_SANITIZE_STRING);
$launch_date = filter_var($_REQUEST['launch_date'], FILTER_SANITIZE_STRING);
$custorder_ref = filter_var($_REQUEST['custorder_ref'], FILTER_SANITIZE_STRING);
$status = filter_var($_REQUEST['status'], FILTER_SANITIZE_STRING);
$del_date = filter_var($_REQUEST['del_date'], FILTER_SANITIZE_STRING);
$confirm_date = filter_var($_REQUEST['confirm_date'], FILTER_SANITIZE_STRING);
$remark = filter_var($_REQUEST['remark'], FILTER_SANITIZE_STRING);
$createby = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$lastupby = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$sql_param = array( ':status' => $status,
':del_date' => $del_date,
':confirm_date' => $confirm_date,
':remark' => $remark,
':lastupby' => $lastupby,
':refid' => $refid);
//vdump($sql_param);
//modify product
$sql = "UPDATE ord_main SET
status = :status,
del_date = :del_date,
confirm_date = :confirm_date,
remark = :remark,
pip_date = ISNULL(pip_date, GETDATE()),
lastupby = :lastupby,
lastupdate = GETDATE()
WHERE refid = :refid";
$sth = $dbh->prepare($sql);
$q = $sth->execute( $sql_param );
//echo $sth->getSQL( $sql_param ) . HTML_EOL;
pdo_showerror($sth, $q);
if( $status == "PIP" ){
//pack extra setatus
packOrdExtraItem($refid);
}
//exit;
form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
header("Location: ord_disd_modifyform.php?refid=$refid&msg=Saved.");
print "Saved.";
exit;
}
print "Invalid Request";
?>
|