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

<?php 
$formid = "Order";
require_once "inc/configure.php";

function waxo_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_waxd_checkout" && !empty($refid) && isset($qc) ){
    //vdump($_REQUEST); //exit;    

    $opr_param['opr_code']    = "WAXO";
    $opr_param['subtable']     = "ord_txwaxo";
    $opr_param['php_function']    = "waxo_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_waxd_modifyform.php?refid=$refid&msg=Saved.");
        print "Saved.";
    }else{
        //echo"Unable to checkout"; exit; 
        form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
        header("Location: ord_waxd_modifyform.php?refid=$refid");
    }
    exit;    
}
myerror("Invalid Request");


?>