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 //product selection
$formid=$_REQUEST['formid'];
require_once "inc/configure.php";
//show all shipped prodcut (with serial number) of the input PN and Custcode
//plus item with no serial number
function rpr_order_option($product_refid, $custcode, $default="", $showdesc=true){
global $dbh;
$sql = "SELECT
dbo.ord_txpako.refid,
dbo.ord_txpako.serialno,
dbo.ord_txpako.status,
dbo.ord_dtl.product_refid,
dbo.ord_main.custcode,
dbo.ord_dtl.itemno,
dbo.ivc_fty.refid AS fty_refid,
dbo.ivc_fty.ivc_nbr AS fty_ivc_nbr,
dbo.ivc_fty.ivc_customer AS fty_ivc_customer,
dbo.ord_main.order_nbr,
dbo.ivc_cus.refid AS cus_refid,
dbo.ivc_cus.ivc_nbr AS cus_ivc_nbr,
dbo.ivc_cus.ivc_customer AS cus_ivc_customer,
dbo.ord_txpako.product_wt
FROM
dbo.ord_txpako
INNER JOIN dbo.ord_dtl ON dbo.ord_txpako.orddtl_refid = dbo.ord_dtl.refid
INNER JOIN dbo.ord_main ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
INNER JOIN dbo.ivc_fty ON dbo.ivc_fty.refid = dbo.ord_txpako.ivcfty_refid
LEFT JOIN dbo.ivc_cus ON dbo.ord_txpako.ivccus_refid = dbo.ivc_cus.refid
WHERE
dbo.ord_txpako.received_time IS NOT NULL AND
dbo.ivc_cus.ivc_customer = :custcode AND
dbo.ord_dtl.product_refid = :product_refid
ORDER BY
cus_ivc_nbr ASC,
dbo.ord_main.order_nbr ASC,
dbo.ord_txpako.serialno ASC";
$sth = $dbh->prepare($sql);
$sth->execute( array(':custcode'=>$custcode,
':product_refid'=>$product_refid ) );
/*echo $sth->getSQL( array(':custcode'=>$custcode,
':product_refid'=>$product_refid ) ); */
$s = '';
while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$selected = ($row['serialno']==$default)? 'selected' : '';
$ivcno = empty($row['fty_ivc_nbr']) ? $row['order_nbr'] : $row['fty_ivc_nbr'];
$s .= '<option value="'.$row['refid'].'" '.$selected.'>'.$ivcno.' - '.$row['serialno'];
if($showdesc){
$s .= ' ('.numf($row['product_wt']).'gr)';
}
$s .= '</option>';
}
return $s;
}
$custcode=$_REQUEST['custcode'];
$product_refid=$_REQUEST['product_refid'];
if(empty($custcode)){
print'<option value="">'.MISSING.WS.CUSTOMER.WS.CODE.'</option>';
exit;
}elseif(empty($product_refid)){
print'<option value="">'.MISSING.WS.PRODUCT.WS.CODE.'</option>';
exit;
}
?>
<option value=""></option><?=rpr_order_option($product_refid, $custcode)?>
|