You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
23 lines
661 B
23 lines
661 B
<?php
|
|
include "./header.php";
|
|
//假設供應商代碼為P
|
|
$BizPartnerId = "P";
|
|
$sql_purBillOrder = "
|
|
SELECT * FROM purBillOrderMaster WHERE BizPartnerId = '$BizPartnerId' AND CurrentState = 2";
|
|
$purMaster = $conn->query($sql_purBillOrder);
|
|
//每筆採購單資料
|
|
foreach($purMaster as $master){
|
|
//print_r($master);
|
|
$BillNo = $master['BillNo'];
|
|
|
|
//每筆採購單明細資料
|
|
$sql_purDetail = "
|
|
SELECT * FROM purBillOrderDetail WHERE BillNo = '$BillNo'";
|
|
$purDetail = $conn->query($sql_purDetail);
|
|
foreach($purDetail as $detail){
|
|
print_r($detail);
|
|
}
|
|
echo "<br>----------------------<br>";
|
|
|
|
}
|
|
|
|
|