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

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

if(!havePermission("SXu")){ 
    myerror(INVALID.WS.PERMISSION);
}

$refid                 = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_STRING);

if( $_POST['action']=="inv_xfer_modifyform" && $refid && $main=getDB("inv_xfer", $refid) ){
//vdump($_REQUEST);//exit;

    $remarks            = filter_var($_REQUEST['remarks'], FILTER_SANITIZE_STRING);    
    $createby            = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
    $lastupby            = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
    
    $sql_param = array(    ':refid' => $refid,
                        ':remarks' => $remarks,    
                            ':lastupby' => $lastupby);
    
    $dbh->beginTransaction();

    //update main
    $sql = "UPDATE inv_xfer SET
                remarks = :remarks,
                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);

    //mark all dtl ($refid, $k)
    xfer_markAllUnused($refid);

    foreach($_REQUEST['material'] as $key=>$mat_item){
        if($key>0){ //valid row
            //insert new record            
            xfer_Dtl($refid, $mat_item, 'OUT', $main['companyid']);
        }
    }
    foreach($_REQUEST['dest_material'] as $key=>$mat_item){
        if($key>0){ //valid row
            //insert new record            
            xfer_Dtl($refid, $mat_item, 'IN', $main['companyid']);
        }
    }
        
    //delete all dtl with the flag ($refid, $k)
    xfer_deleteUnused($refid);
    
//exit;
$dbh->commit();

    form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
    header("Location: inv_xfer_modifyform.php?refid=$refid&msg=Saved.");
    print "Saved.";
    exit;
    
    
}
print "Invalid Request";


?>