EVOLUTION-NINJA
Edit File: importDetails.php
<span><a target="_blank" href="<?php echo base_url(); ?>import/pdf_download/<?php echo $impfilenor; ?>"> <img src="<?php echo base_url(); ?>assets/admin/img/pdfimg.jpg" style="width:30px;"></a></span> <?php $count=1; foreach($dispDATA as $fdata) { ?> <table align="center" border="1" style="width:85%;height:100%;" cellpadding="10"> <tr style="background-color:#578ebe"> <th colspan="4"><span style="margin-right:13%;">Import file No : <?php echo $impfilenor; ?> </span><span>SUPPLIER : <?php echo $fdata->name; ?></span></th><th style="width:10%;"></th> </tr> <tr> <th colspan="2">CONSITMENT <?php echo $count; ?></th><th style="width:30%;" rowspan="4"></th><th>DATE OF BOOKING</th><th><?php echo $fdata->booking_date; ?></th> </tr> <tr> <th>BLNO</th><th><?php echo $fdata->billLoadingNo; ?></th><th>DATE OF PAYMENT</th><th><?php echo $fdata->PaymentDate; ?></th> </tr> <tr> <th>BL/DATE</th><th><?php echo $fdata->billLoadingDate; ?></th><th>GOODS RECIEVED DATE</th><th><?php echo $fdata->RecievedDate; ?></th> </tr> <tr> <th>PORT</th><th><?php echo $fdata->port; ?></th><th></th><th></th> </tr> <tr> <th colspan="4"></th><th></th> </tr> <tr> <th>SALES CONTRACT NO.</th><th></th><th colspan="2"></th><th></th> </tr> <?php $dddds=mysql_query("SELECT * FROM mi_goods_license_recieved WHERE goods_details_id='".$fdata->goodsdetid."'"); ?> <tr> <th colspan="5">LICENCES : <tr style="background-color:#f7f7f7"><td></td><th>Category</th><th>License Number</th><th>Recieved Quantity</th><th>Custom Duty</th></tr> <?php while($ddde=mysql_fetch_array($dddds)) { ?> <tr><td></td><td><?php if($ddde['category']=="advance_auth") { echo "Advanced Authorisation"; } else { echo "Incentive Schemes"; } ?></td><td><?php echo $ddde['license_no']; ?></td><td><?php echo $ddde['recieved_quantity']; ?></td><td><?php echo $ddde['customduty']; ?></td></tr> <?php }?> </th><th></th> </tr> <tr> <th colspan="5"></th> </tr> <tr> <th>GOODS DISCRIPTION</th><th>NO OF BALES</th><th>QUANTITY BOOKED</th><th>MILL NUMBER</th><th>UNIT PRICE</th> </tr> <tr> <td><?php echo $fdata->quality.'('.$fdata->dinear.')'.'<b> Grade : </b> '.$fdata->grade; ?></td><th><?php echo $fdata->box_no_of_bale; ?></th><th><?php echo $fdata->quantity_booked; ?></th><th><?php echo $fdata->mill_no; ?></th><th><?php echo $fdata->unit_price; ?></th> </tr> <tr> <th colspan="5"></th> </tr> <tr> <th colspan="5"></th> </tr> <tr> <th colspan="4">FCN VALUE</th><th></th> </tr> <tr> <th colspan="4">TOTAL VALUE</th><th><?php echo $fdata->TotalValue; ?></th> </tr> <tr> <th colspan="4">AVG RATE (KGS) INR</th><th><?php echo $fdata->AverageRate; ?></th> </tr> </table><br> <?php $count++; }?>