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
|
<?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_addform" ){
//vdump($_REQUEST);//exit;
$companyid = filter_var($_REQUEST['companyid'], FILTER_SANITIZE_STRING);
$stockcategy = filter_var($_REQUEST['stockcategy'], 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);
$sql_param = array(':companyid' => $companyid,
':stockcategy' => $stockcategy,
':remarks' => $remarks,
':createby' => $createby,
':lastupby' => $lastupby);
$dbh->beginTransaction();
//update main
$sql = "INSERT INTO inv_xfer (
companyid, xferdate, remarks, stockcategy,
createby, createdate, lastupby, lastupdate
) VALUES (
:companyid, GETDATE(), :remarks, :stockcategy,
:createby, GETDATE(), :lastupby, GETDATE()
) ";
$sth = $dbh->prepare($sql);
$q = $sth->execute( $sql_param );
//echo $sth->getSQL( $sql_param ) . HTML_EOL;
pdo_showerror($sth, $q, $sql_param);
$refid = $dbh->lastInsertId();
foreach($_REQUEST['material'] as $key=>$mat_item){
if($key>0){ //valid row
//insert new record
xfer_Dtl($refid, $mat_item, 'OUT', $companyid);
}
}
foreach($_REQUEST['dest_material'] as $key=>$mat_item){
if($key>0){ //valid row
//insert new record
xfer_Dtl($refid, $mat_item, 'IN', $companyid);
}
}
$dbh->commit();
//exit;
form_dest($_REQUEST['godest'], $_REQUEST['formdest']);
header("Location: inv_xfer_modifyform.php?refid=$refid&msg=Saved.");
print "Saved.";
exit;
}
print "Invalid Request";
?>
|