require ('dbcon.php');
$Internal=$_GET['Internal'];
$sql1="Select * From Request_Imp_Permit_Head where Internal='$Internal'";
//echo $sql1;
$result1=mysqli_query($conn,$sql1);
$record1=mysqli_fetch_array($result1);
$Importpermitno=$record1['Undertaken_No'];
$blno=$record1['BL_No'];
$beno=$record1['BE_No'];
?>
Custom Input
| Import Permit No : |
| BE NO : |
| BL No : |
Serial No |
Item Code |
Item Name |
//$sql33="Select * From BE_Serial_RPT WHERE Internal='".$Internal."'";
$sqlstr="SELECT * FROM BE_Serial_RPT1 WHERE Req_Internal='".$Internal."' order by Item_Code_Serial ";
// echo $sqlstr;
$result33=mysqli_query($conn,$sqlstr);
while($record33=mysqli_fetch_array($result33))
{
//while($record = mysqli_fetch_array( $result ))
// {
$serialno=$record33['Item_Code_Serial'];
$partid=$record33['Item_Code'];
$partname=$record33['Item'];
?>
|
|
|
}
?>
//$sql33="Select * From BE_Serial_RPT WHERE Internal='".$Internal."'";
$sqlstr="SELECT * FROM BE_Serial_Head WHERE Req_Internal='".$Internal."' AND Cat_ID='0' order by Item_Code_Serial ";
//echo $sql2;
$result33=mysqli_query($conn,$sqlstr);
while($record33=mysqli_fetch_array($result33))
{
//while($record = mysqli_fetch_array( $result ))
// {
$serialno=$record33['Item_Code_Serial'];
$partid=$record33['Item_Code'];
$partname=$record33['Item'];
?>
|
|
|
}
?>
//$sql33="Select * From BE_Serial_RPT WHERE Internal='".$Internal."'";
$sqlstr="SELECT * FROM BE_Serial_Head WHERE Req_Internal='".$Internal."' AND Cat_ID='5' order by Item_Code_Serial ";
//echo $sql2;
$result33=mysqli_query($conn,$sqlstr);
while($record33=mysqli_fetch_array($result33))
{
//while($record = mysqli_fetch_array( $result ))
// {
$serialno=$record33['Item_Code_Serial'];
$partid=$record33['Item_Code'];
$partname=$record33['Item'];
$sqlstr5="SELECT * FROM Fixed_Inv_Packing WHERE Item_Combine='".$partid."' ";
//echo $sql2;
$result335=mysqli_query($conn,$sqlstr5);
$record335=mysqli_fetch_array($result335);
$itemname=$record335['Item_Combine_Int'];
?>
|
|
|
}
?>