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
|
<?php
$formid = "Order";
require_once "inc/configure.php";
$refid = (int) filter_var($_REQUEST['refid'], FILTER_SANITIZE_STRING);
if( !empty($refid) ){
vdump($_REQUEST);
$computer = gethostname();
$userid = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
$barcode = generateJCBarcode($refid);
$sql="SELECT
dbo.ord_dtl.refid,
dbo.ord_dtl.main_refid,
dbo.ord_main.order_nbr,
dbo.ord_main.launch_date,
dbo.ord_main.del_date,
dbo.ord_dtl.qty,
dbo.ord_dtl.[size],
dbo.ord_dtl.itemno,
dbo.inv_product.name_en,
dbo.inv_product.name_sc
FROM
dbo.ord_dtl
INNER JOIN dbo.ord_main ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
INNER JOIN dbo.inv_product ON dbo.ord_dtl.product_refid = dbo.inv_product.refid
WHERE
dbo.ord_dtl.refid = $refid
";
var_dump($barcode, $sql, $computer, $userid);
exit;
header("Location: sys_labelqueue.php");
}
myerror("Invalid Request");
?>
|