Fixed Po Verification
Note:Required to verify each and every item
PO NO
SC NO
Seq No
Category
Item Code
Description
Last Unit Price
Unit Price
Remarks
Sub Item1-Sub Value1
Sub Item2-Sub Value2
Sub Item3-Sub Value3
Sub Item4-Sub Value4
Sub Item5-Sub Value5
Sub Item6-Sub Value6
Verify
$sqlstr1=mysqli_query($conn,"Select * From PO_Imp_F_Item where Internal='$Internal'"); while($record1=mysqli_fetch_array($sqlstr1)) { $pcno=$record1['PCNo']; $seqno=$record1['SeqNo']; $categoryid=$record1['Cat_ID']; $sqlstr15=mysqli_query($conn,"Select * From Parts where Internal='$categoryid' "); $record15=mysqli_fetch_array($sqlstr15); $Cat=$record15['Item']; $itemcode=$record1['Item_Code']; $description=$record1['Description']; $qty=$record1['QTY']; $unitprice=$record1['Unit_Price']; $lastprice=$record1['Last_Price']; $subitem1=$record1['SubItem1']; $subvalue1=$record1['Subval1']; $SubItem2=$record1['SubItem2']; $Subvalue2=$record1['Subval2']; $SubItem3=$record1['SubItem3']; $Subvalue3=$record1['Subval3']; $SubItem4=$record1['SubItem4']; $Subvalue4=$record1['Subval4']; $SubItem5=$record1['Subitem5']; $Subvalue5=$record1['Subval5']; $SubItem6=$record1['SubItem6']; $Subvalue6=$record1['Subval6']; $remarks=$record1['Remarks']; $Last_Price=$record1['Last_Price']; $sqlstr5=mysqli_query($conn,"Select * From SC_Item where Sc_No='$pcno' AND Seq_No='$seqno' "); $record5=mysqli_fetch_array($sqlstr5); $article=$record5['Article']; $modelgroup=$record5['Model_Group']; if($modelgroup == '1') { $specno=$record5['Spec_No']; } if($modelgroup <> '1') { $sqlstr6=mysqli_query($conn,"Select * From SC_Item where LineNo='$article' "); $record6=mysqli_fetch_array($sqlstr6); $specno=$record6['Spec_No']; } $sqlstr6=mysqli_query($conn,"Select * From Sp_Kitem where Internal='$specno' AND Group_Item='$Cat' "); $record6=mysqli_fetch_array($sqlstr6); $Group_Item=$record6['Group_Item']; $Model=$record6['Model']; $Description=$record6['Description']; $SI11=$record6['SubItem1']; $Sv1=$record6['Subval1']; $SI22=$record6['SubItem2']; $Sv22=$record6['Subval2']; $SubItem33=$record6['SubItem3']; $Subvalue33=$record6['Subval3']; $SubItem44=$record6['SubItem4']; $Subvalue44=$record6['Subval4']; $SubItem55=$record6['Subitem5']; $Subvalue55=$record6['Subval5']; $SubItem66=$record6['SubItem6']; $Subvalue66=$record6['Subval6']; ?>
-
-
-
-
-
-
Spec Details
-
-
-
-
-
-
} ?>