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
|
<?php
// 20240711 update by OSL_yee
$formid = "Order";
require_once "inc/configure.php";
function enamel_checkout($orddtl_refid, $opr_param){
//write tx details to $param['subtable']
global $dbh;
$sql = "INSERT into ".$opr_param['subtable']." (
txmain_refid, worker, moldno, qty,
createby, createdate, lastupby, lastupdate
) VALUES (
:txmain_refid, :worker, :moldno, :qty,
:createby, GETDATE(), :lastupby, GETDATE()
)";
$sth = $dbh->prepare($sql);
$q = $sth->execute( array(':txmain_refid' => $opr_param['txmain_refid'],
':worker' => $opr_param['worker'],
':moldno' => $opr_param['moldno'],
':qty' => $opr_param['ttl_qty'],
':createby' => $opr_param['createby'],
':lastupby' => $opr_param['lastupby']) );
/* echo $sth->getSQL( array(':txmain_refid' => $opr_param['txmain_refid'],
':worker' => $opr_param['worker'],
':moldno' => $opr_param['moldno'],
':qty' => $opr_param['qty'],
':createby' => $opr_param['createby'],
':lastupby' => $opr_param['lastupby']) ); */
}
$refid = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_STRING);
$route_refid = (int) filter_var($_REQUEST['route_refid'], FILTER_SANITIZE_STRING);
$txmain_refid = (int) filter_var($_REQUEST['txmain_refid'], FILTER_SANITIZE_STRING);
$qc = filter_var($_REQUEST['qc'], FILTER_SANITIZE_STRING);
if( $_POST['action']=="ord_enamel_checkout" && !empty($refid) && isset($qc) ){
//vdump($_REQUEST); //exit;
$opr_param['opr_code'] = "ENAMEL";
$opr_param['subtable'] = "ord_txenamel";
$opr_param['php_function'] = "enamel_checkout";
$opr_param['ttl_qty'] = filter_var($_REQUEST['ttl_qty'], FILTER_SANITIZE_STRING);
$opr_param['uom_qty'] = filter_var($_REQUEST['uom_qty'], FILTER_SANITIZE_STRING);
$opr_param['worker'] = filter_var($_REQUEST['worker'], FILTER_SANITIZE_STRING);
$opr_param['act_svc_duration'] = filter_var($_REQUEST['act_svc_duration'], FILTER_SANITIZE_STRING);
$opr_param['qc'] = filter_var($_REQUEST['qc'], FILTER_SANITIZE_STRING);
$opr_param['createby'] = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$opr_param['lastupby'] = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
//$opr_param['route_refid'] = (int) filter_var($_REQUEST['route_refid'], FILTER_SANITIZE_STRING);
//$opr_param['txmain_refid'] = (int) filter_var($_REQUEST['txmain_refid'], FILTER_SANITIZE_STRING);
//vdump($opr_param); //exit;
$opr = oprReadyForCheckout($refid, $opr_param);
//vdump($opr);
$opr_param['route_refid'] = (int) filter_var($opr['refid'], FILTER_SANITIZE_STRING);
$opr_param['txmain_refid'] = (int) filter_var($opr['ordtxmain_refid'], FILTER_SANITIZE_STRING);
if($opr){
$dbh->beginTransaction();
ord_updateJCLocation($refid, $opr['refid'], $opr_param);
$checkout_time = ord_checkout($refid, $opr_param);
$dbh->commit();
//vdump($checkout_time); exit;
form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
header("Location: ord_enamel_modifyform.php?refid=$refid&msg=Saved.");
print "Saved.";
}else{
//echo"Unable to checkout"; exit;
form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
header("Location: ord_enamel_modifyform.php?refid=$refid");
}
exit;
}
myerror("Invalid Request");
?>
|