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
|
<?php
$formid = "Order";
require_once "inc/configure.php";
require_once "inc/ord_cn_func.php";
$refid = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_STRING);
if( $_POST['action']=="cn_cus_modifyform" && $refid && $row=getDB("cn_cus_main",$refid) ){
//vdump($_REQUEST); //exit;
$cn_customer = filter_var($_REQUEST['cn_customer'], FILTER_SANITIZE_STRING);
$cn_nbr = filter_var($_REQUEST['cn_nbr'], FILTER_SANITIZE_STRING);
$companyid = filter_var($_REQUEST['companyid'], FILTER_SANITIZE_STRING);
$launch_date = filter_var($_REQUEST['launch_date'], FILTER_SANITIZE_STRING);
$due_date = filter_var($_REQUEST['due_date'], FILTER_SANITIZE_STRING);
$status = filter_var($_REQUEST['status'], FILTER_SANITIZE_STRING);
$remarks = filter_var($_REQUEST['remarks'], FILTER_SANITIZE_STRING);
$createby = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$lastupby = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$uom_cy = filter_var('USD', FILTER_SANITIZE_STRING);
$issue_ivcnbr = filter_var($_REQUEST['issue_ivcnbr'], FILTER_SANITIZE_STRING);
if($issue_ivcnbr){
list($cn_nbr, $seq) = cusivc_getNewIvcNbrSeq("ivc_cus", $row['companyid'], "CN");
//generateIvccusNbr($ivc_customer);
}
$sql_param = array( ':refid' => $refid,
':due_date' => $due_date,
':status' => $status,
':uom_cy' => $uom_cy,
':cn_nbr' => $cn_nbr,
':seq' => $seq,
':remarks' => $remarks,
':finished' => $finished,
':lastupby' => $lastupby);
$dbh->beginTransaction();
//update main
$sql = "UPDATE cn_cus_main SET
due_date = :due_date,
status = :status,
uom_cy = :uom_cy,
cn_nbr = :cn_nbr,
seq = :seq,
remarks = :remarks,
finished = :finished,
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, $sql_param);
cn_cus_markallDtl($refid);
foreach($_REQUEST['product'] as $key=>$prod_item){
if($key>0){ //valid row
//insert new record
//vdump($prod_item);
if($prod_item['refid']>0){
cn_cusmain_updateDtl($refid, $prod_item);
}else{
cn_cusmain_insertDtl($refid, $prod_item);
}
}
}
//delete all record in ord_podtl where pomain_refid = refid
cn_cusmain_deleteUnusedDtlbyMainRefid($refid);
//update invoice summary
cn_cusmain_updateSummary($refid);
//exit;
$dbh->commit();
//$dbh->rollBack();
//exit;
form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
header("Location: cn_cus_modifyform.php?refid=$refid&msg=Saved.");
print "Saved.";
exit;
}
print "Invalid Request";
?>
|