JezK

Edit File: viewasn.php

<?php 
include("app/checkSession.php");
//include("app/adminObj.php"); 
if(empty($_SESSION['user_id'])&& $_SESSION['user_id']=='')
{
   header("Location: ../owner_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_id=".(int)$_REQUEST['asn_id'];

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

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

?>

<div class="col-md-12 mb-4 px-5">
    <a href="javascript:history.back(1)" class="pr-3 pr-md-0 position-relative" style="z-index:9"><img
            src="images/back_main.png"></a>
    
</div>
<div class="container px-3 px-md-5">
    <h4 class="col-sm-12 px-0 mt-4"><?php echo $lang['View ASN'];?></h4>

<div class="containercontent">
        <div class="card-1 shadow-sm p-3 mb-5 bg-white rounded">
            <div class="card-body">

<div class="row">
                    <div class="col-lg-6 col-md-12 col-sm-12">
                            <div class="row">
                            <div class="col-md-5"><label for="invoices"><b><?php echo $lang['WAREHOUSE_NAME'];?></b></label></div>
                            <div class="col-md-1 colon">:</div>
                            <div class="col-md-6 text-capitalize"><?php echo $wrow['warehouse_name'];?></div>
                            </div>
                            
                            <div class="row">
                            <div class="col-md-5"><label for="whnumber"><b><?php echo $lang['WAREHOUSE_ID'];?></b></label></div>
                            <div class="col-md-1 colon">:</div>
                            <div class="col-md-6"><?php echo $alist['warehouse_id'];?></p></div>
                            </div>

<div class="row">
                            <div class="col-md-5"><label for="whnumber"><b><?php echo $lang['QUOTATION_ID'];?></b></label></div>
                            <div class="col-md-1 colon">:</div>
                            <div class="col-md-6"><?php echo $alist['quotation_id'];?></div>
                            </div>

<div class="row">
                            <div class="col-md-5"><label for="whname"><b><?php echo $lang['REQUEST_TYPE'];?></b></label></div>
                            <div class="col-md-1 colon">:</div>
                            <div class="col-md-6"><?php  if ($alist['request_type']=='Request Quote'){
                                echo $lang['REQUEST_QUOTE'];
                            }
                            else{
                                echo $lang['ONLINE_BOOKING'];
                            }?></div>
                            </div>

</div>

<div class="col-lg-6 col-md-12 col-sm-12">
                        <div class="row">
                            <div class="col-md-5"><label for="invoices"><b><?php echo $lang['CUSTOMER_NAME'];?></b></label></div>
                            <div class="col-md-1 colon">:</div>
                            <div class="col-md-6"><?php echo $urow['first_name'];?> <?php echo $urow['last_name'];?></div>
                            </div>

<div class="row">
                            <div class="col-md-5 col-sm-5"><label for="invoices"><b><?php echo $lang['CUSTOMER_TYPE'];?></b></label></div>
                            <div class="col-md-1 col-sm-1 colon">:</div>
                            <div class="col-md-6 col-sm-6"><?php echo $urow['role_id']==3?$lang['INDIVIDUAL']:$lang['BUSINESS'];?></div>
                            </div>
                            <div class="row">
                            <div class="col-md-5 col-sm-5"><label for="customer"><b><?php echo $lang['PRICE'];?></b></label></div>
                            <div class="col-md-1 col-sm-1 colon">:</div>
                            <div class="col-md-6 col-sm-6"><?php echo $alist['price'];?>
                            <span class="currencyType"><?php echo $alist['currency']; ?></span></div>
                            </div>
                            <div class="row">
                            <div class="col-md-5 col-sm-5"><label for="whname"><b><?php echo $lang['DATE'];?></b></label></div>
                            <div class="col-md-1 col-sm-1 colon">:</div>
                            <div class="col-md-6 col-sm-6"><input type="text" style="border:none" class="datePicker w-50 dateAlignment" id="datePicker" value="<?php echo date('d-m-Y', strtotime($alist['date'])); ?>"><label for="datePicker"> <span><img src="./images/calendar.png" alt="date"></span></label></div>
                            </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="mt-5 table-responsive">
                    <table class="table table-bordered table_body text-center mt-4">
                        <thead class="theadcolor">
                            <tr>
                            <th><?php echo $lang['ITEM_CODE'];?></th>
                            <th><?php echo $lang['ITEM_DESCRIPTION'];?></th>
                                <th><?php echo $lang['Qty'];?></th>
                                <th><?php echo $lang['REFERENCE_NUMBER'];?></th>
                                <th><?php echo $lang['COST'];?> &nbsp; (<?php echo $currency ?>)</th>
                                <th><?php echo $lang['PALLET_NO'];?></th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php 
                         $query1="SELECT * FROM uflexit_mini_goods_track WHERE asn_no='".$_REQUEST['asn_id']."'";

$alist_goods=$wareHouseAdminObj->db->get_results($query1);

// print_r($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"); ?>

<script>
        $=jQuery;
        var date;
        $(document).ready(function(){
            $('#datePicker').datetimepicker({
	            format: 'DD-MM-YYYY'
	            
        }).on('dp.change',function(e){
          var quotationId=<?php echo $alist['quotation_id'] ?>;
           date=  jQuery('#datePicker').val()
        //    alert(date)
            $.ajax(({
                url:'ajax.php',
                type:'post',
                data:({action:"updateShipmentStatus",
                    dateVal:date,
                    quotationid:quotationId
                }),
                success:function(response){
                    var data=JSON.parse(response)
                   var msg='<?php echo $lang['SHIPMENT_STATUS_UPDATED_SUCCUESSFULLY_FOR_QUOTATION_ID']; ?>';
                    alert( msg+data.result.quotation_id)
                }
            }))
    }); 
})

// jQuery('#datePicker').click(function(){
        //     // alert("hello")
            
        // })
        </script>