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
|
<?php
$formid = "Order";
require_once "inc/configure.php";
function get_Orddtlrefid_byPako($pako_refid){
global $dbh;
$sql = "SELECT
dbo.ord_txpako.orddtl_refid
FROM
dbo.ord_txpako
WHERE
dbo.ord_txpako.refid = :pako_refid
";
$sth = $dbh->prepare($sql);
$q = $sth->execute( array(':pako_refid' => $pako_refid) );
//echo $sth->getSQL( array(':pako_refid' => $pako_refid) );
pdo_showerror($sth, $q);
$row = $sth->fetch();
return $row['orddtl_refid'];
}
function markRECEIVEDitem($ivcfty_refid, $refid){
global $dbh;
$sql = "UPDATE dbo.ord_txpako
SET
status = 'RECEIVED',
received_time = GETDATE(),
lastupby = :lastupby,
lastupdate = GETDATE()
WHERE
refid = :refid AND
ivcfty_refid = :ivcfty_refid AND
(status = 'OCCUPIED' OR status = 'SENT')";
$sth = $dbh->prepare($sql);
$q = $sth->execute( array(':refid' => $refid,
':ivcfty_refid' => $ivcfty_refid,
':lastupby' => filter_var($_SESSION['user'], FILTER_SANITIZE_STRING)) );
/* echo $sth->getSQL( array(':refid' => $refid,
':ivcfty_refid' => $ivcfty_refid,
':lastupby' => filter_var($_SESSION['user'], FILTER_SANITIZE_STRING)) );*/
pdo_showerror($sth, $q);
$orddtl_refid=get_Orddtlrefid_byPako($refid);
//checkout txpako if the job card's items are all received
if( getJCremainQTY($orddtl_refid) <= 0 ){
//checkout pako
//echo "checkout $orddtl_refid";
$opr_param['opr_code'] = "PAKO";
$opr_param['subtable'] = "ord_txpako";
//$opr_param['php_function'] = "pako_checkout";
$opr_param['lastupby'] = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$opr = oprReadyForCheckout($orddtl_refid, $opr_param, $status);
//vdump($opr);
$opr_param['orddtl_refid'] = (int) filter_var($opr['orddtl_refid'], FILTER_SANITIZE_STRING);
$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($status=='OK'){
$checkout_time = ord_checkout($orddtl_refid, $opr_param);
}
$ordmain_refid = ord_getOrdmain_refid($orddtl_refid);
//vdump($ordmain_refid, ord_getOrdRemainQTY($ordmain_refid));
if( ord_getOrdRemainQTY($ordmain_refid) == 0){
ord_setStatus($ordmain_refid, 'PRF');
}
}
}
if( !havePermission("RCu")){
myerror(INVALID.WS.PERMISSION);
exit;
}
$refid = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_NUMBER_INT);
//vdump($_REQUEST); exit;
if( $_POST['action']=="ivc_ftyrcpt_modifyform" && !empty($refid) ){
$dbh->beginTransaction();
if(is_array($_REQUEST['invoice_check'])){
foreach($_REQUEST['invoice_check'] as $pako_refid => $invoice_check){
//vdump($key);
markRECEIVEDitem($refid, $pako_refid);
}
}
//check all items in the invoice are received
checknmarkFinishedIvcfty($refid);
//exit;
$dbh->commit();
//echo "msg=$msg";
//exit;
header("Location: ivc_ftyrcpt_modifyform.php?refid=$refid&msg=Saved.");
print "Saved.";
exit;
}
print "Invalid Request";
?>
|