JezK

Edit File: viewasn.php

<?php 
include("app/checkSession.php");
// include("app/adminObj.php"); 
if(!isset($_SESSION['customer_user_id'])){
   $customerObj->redirect('login.php');
}

include("header.php");

$query="SELECT asn.*,urq.currency_type,uc.currency FROM uflexit_asn_request as asn join uflexit_request_quote as urq on urq.quotation_id=asn.quotation_id join uflexit_countries as uc on uc.country_id=urq.currency_type WHERE asn.asn_id=".(int)$_REQUEST['asn_id'];

$alist=$customerObj->db->get_row($query);
// print_r($alist);
$currencyType=$alist['currency'];

$wrow = $customerObj->db->get_row("SELECT * FROM uflexit_master_warehouse WHERE warehouse_id=".(int)$alist['warehouse_id']);
  $urow = $customerObj->db->get_row("SELECT * FROM uflexit_users WHERE user_id=".(int)$alist['user_id']);
  $crow = $customerObj->db->get_row("SELECT * FROM uflexit_users WHERE user_id=".(int)$alist['created_by']);
 ?>

</div>

<div class="row">
                            <div class="col-md-5 col-sm-5"><label for="whname"><b><?php echo $lang['CREATED_BY'];?></b></label></div>
                            <div class="col-md-1 col-sm-1 colon">:</div>
                            <div class="col-md-6 col-sm-6"><?php echo isset($crow['first_name'])?$crow['first_name']:"";?>
                            <?php echo isset($crow['last_name'])?$crow['last_name']:"";?></div>
                            </div>
                            
                        </div>
                     </div>

<!-- <div class="col-sm-6 mb-5 pb-4">
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="invoices"><b><?php echo $lang['CUSTOMER_TYPE'];?></b></label>
                        </div>
                        <div class="col-md-6 text-capitalize">
                            :&nbsp;&nbsp; <?php echo $urow['role_id']==3?'Individual':'Business';?>
                        </div>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="customer"><b><?php echo $lang['PRICE'];?></b></label>
                        </div>
                        <div class="col-md-6 text-capitalize">
                            :&nbsp;&nbsp;<?php echo $alist['price'];?>
                       <span class="currencyType"><?php echo $currencyType  ?></span>
                        </div>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="whname"><b><?php echo $lang['DATE'];?></b></label>
                        </div>
                        <div class="col-md-6 text-capitalize">
                        :&nbsp;&nbsp; <?php echo  $alist['date'];?>
                     </div>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="whname"><b><?php echo $lang['CREATED_BY'];?></b></label>
                        </div>
                        <div class="col-md-6 text-capitalize">
                            :&nbsp;&nbsp;<?php echo isset($crow['first_name'])?$crow['first_name']:"";?>
                        <?php echo isset($crow['last_name'])?$crow['last_name']:"";?>
                        </div>
                        
                    </div>

</div> -->

</tr>
                    </thead>
                    <tbody>
                        <?php 
                         $query1="SELECT * FROM uflexit_mini_goods_track WHERE asn_no='".$_REQUEST['asn_id']."'";
                       $alist_goods=$customerObj->db->get_results($query1); 
                    //   print_r($alist_goods);
                        if($alist_goods){
                            foreach ($alist_goods as $glist) {
                                ?>
                             <tr>
                            <td><?php echo $glist['item_code'];?></td>
                            <td><?php echo $glist['item_description'];?></td>
                            <td><?php echo $glist['item_quantity'];?></td>
                            <td><?php echo $glist['ref_number'];?></td>
                            <td><?php echo $glist['price'];?></td>
                            <td><?php echo $glist['pallet_space_num'];?></td>
                            </tr>
                        <?php 
                               }
                        }
                       
                      ?>

</tbody>
                </table>
                </div>
            </div>
        </div>

<?php include("footer.php"); ?>