JezK

Edit File: issuetranscationindividualview.php

<?php 
  include("header.php"); 
  $sql= "select umw.*,urq.currency_type,uc.currency from uflexit_material_transactions as umw join uflexit_request_quote as urq on urq.quotation_id=umw.quotation_id join uflexit_countries as uc on  uc.country_id=urq.currency_type where umw.randval='".$_GET['rnd']."' and type=1";
  $row = $wareHouseAdminObj->db->get_row($sql);
//   print_r($row);
$currencyType=$row['currency'];
?>

<div class="container">
    <div class="mt-3 px-md-4 px-0">
        <div class="row px-md-3 px-2">
            <div class="container pl-0 pr-2 text-dark">
            <a href="javascript:history.go(-1)"><img src="images/back_main.png" class="mb-3"></a>
                <h5><?php echo $lang['ISSUING_TRANSACTION_DETAILS'];?></h5>
            </div>
        </div>
    </div>
    <div class="warehouse_boxshadow mt-3 mb-5 mx-1 mx-md-4">
        <div class="container pt-4 pl-4 pb-2 ">
            <div class="row">

<div class="col-lg-6 col-md-12 col-sm-12">
                     <div class="row">
                        <div class="col-md-5"><p><strong><?php echo $lang['QUOTATION_ID'];?></strong></p></div>
                        <div class="col-md-1 colon">:</div>
                        <div class="col-md-6"><p><?php echo $row['quotation_id'] ?></p></div>
                        </div>

<div class="row">
                        <div class="col-md-5"> <p><strong><?php echo $lang['ADVANCE_SHIPMENT_ID'];?></strong></p></div>
                        <div class="col-md-1 colon">:</div>
                        <div class="col-md-6"><p><?php echo $row['asn_id']  ?></p></div>
                        </div>

<div class="row">
                        <div class="col-md-5"> <p><strong><?php echo $lang['CUSTOMER_NAME'];?></strong></p></div>
                        <div class="col-md-1 colon">:</div>
                        <div class="col-md-6"><p><?php echo $row['customer_name'] ?></p></div>
                        </div>

<div class="row">
                        <div class="col-md-5"> <p><strong><?php echo $lang['EMAIL'];?></strong></p></div>
                        <div class="col-md-1 colon">:</div>
                        <div class="col-md-6"><p><?php echo $row['email'] ?></p></div>
                        </div>

</div>
                  <div class="col-lg-6 col-md-12 col-sm-12">
                  <div class="row">
                        <div class="col-md-5"> <p><strong><?php echo $lang['COUNTRY'];?></strong></p></div>
                        <div class="col-md-1 colon">:</div>
                        <div class="col-md-6"><p><?php echo $row['country'] ?></p></div>
                        </div>

<div class="row">
                        <div class="col-md-5 col-sm-5"> <p><strong><?php echo $lang['CITY'];?></strong></p></div>
                        <div class="col-md-1 col-sm-1 colon">:</div>
                        <div class="col-md-6 col-sm-6"><p><?php echo $row['city'] ?></p></div>
                        </div>
                  </div>
                
            </div>
        </div>
    </div>
    <div class="mt-3 px-md-4 px-2">
        <div class="row px-md-3 px-0 pb-3">
            <div class="container pl-0 pr-2 text-dark">
                <h5 class="mb-3"><?php echo $lang['ITEM_DETAILS'];?></h5>
                <div class="warehouse_boxshadow p-4 table-responsive">
                    <table id='example' class=" table table-bordered table_body  px-0 issuedTransaction">
                        <thead class="theadcolor">
                            <tr>
                                <th><?php echo $lang['ITEM_CODE'];?></th>
                                <th class="customWitdh"><?php echo $lang['ITEM_DESCRIPTION'];?></th>
                                <th><?php echo $lang['QUANTITY'];?></th>

<th><?php echo $lang['REFERENCE_NUMBER'];?></th>
                                <th><?php echo $lang['COST'];?> &nbsp;(<?php echo $currencyType ?>)</th>
                                
                                <th><?php echo $lang['PALLET_NO'];?>.</th>
                                <th><?php echo $lang['ROW'];?></th>
                                <th><?php echo $lang['RACK'];?></th>
                                <th><?php echo $lang['PIN'];?></th>
                            </tr>
                        </thead>
                        <tbody>

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

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

<style>
#example_length {
    display: none !important;
}
div#example_filter{
    display:none;
}
table.dataTable tbody th, table.dataTable tbody td {
    padding: 8px 10px;
    white-space: break-spaces;
    background: #eaeffa !important;
}

.table-bordered td, .table-bordered th {
    border: 1px solid #dee2e6 !important;
}
div#example_paginate {
    display: none !important;
}
.dataTables_length {
    display: none !important;
}
</style>

<script>
jQuery(document).ready(function() {
    jQuery('#example').DataTable({
        "processing": true,
        "dataSrc": "",
        "dom": 'Bfrtip',
        "dom": 'Rlfrtlip',
        language: {
            search: '',
            searchPlaceholder: "Search",
            
        },
        "pagingType": "full_numbers",
        "bProcessing": true,
        "bServerSide": true,
        "sAjaxSource": "app/view-individualIssueTransaction-ajax.php?rnd=<?php echo $_GET['rnd'] ?>",
        "ordering": false,
        "aoColumns": [{
                mData: 'itemcode'
            },
            {
                mData: 'item_desc'
            },
            {
                mData: 'qty'
            },
            {
                mData: 'ref_number'
            },

{
                mData: 'cost'
            },
            {
                mData: 'pallet_no'
            },
            {
                mData: 'row_val'
            },
            {
                mData: 'rack'
            },
            {
                mData: 'pin'
            }

]

});
});
</script>

<script src="https://code.jquery.com/jquery-3.5.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.5/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.5/js/buttons.flash.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.5/js/buttons.html5.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.5/js/buttons.print.min.js" type="text/javascript"></script>

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.22/css/jquery.dataTables.min.css">

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.5/css/buttons.dataTables.min.css">