1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : view_invoice.php
back
<?php      
   ob_start();
   session_start();
   include 'config.php'; 
   $login = $_SESSION['login_email'];
   
   if($login == ''){ 
      echo   '<script>location.replace("index.php")</script>';
   }
   $id = $_GET['id'];
   
   if(isset($_SESSION["source_id"])){
      $source_id = $_SESSION['source_id'];
   }
   
   
   
   $companyd = mysqli_query($conn,"SELECT * FROM `company_details`");
   $companyrow = mysqli_fetch_assoc($companyd);
   
   $company_name = $companyrow['company_name'];
   $company_logo = $companyrow['company_logo'];
   $GSTIN = $companyrow['GSTIN'];
   $phone = $companyrow['phone'];
   $email = $companyrow['email'];
   $address = $companyrow['address'];
   $city = $companyrow['city'];
   $state = $companyrow['state'];
   $country = $companyrow['country'];
   $account_name = $companyrow['account_name'];
   $account_no = $companyrow['account_no'];
   $bank_name = $companyrow['bank_name'];
   $ifsc = $companyrow['ifsc'];
   $shift = $companyrow['shift'];
   $branch = $companyrow['branch'];
   $company_color = $companyrow['company_color'];
   $currency = $companyrow['currency'];
   $invoice_prifix = $companyrow['invoice_prifix'];
   $default_invoice = $companyrow['default_invoice'];
   $signature = $companyrow['signature'];
   $invoice_note = $companyrow['invoice_note']; 
   
   
   
   ?>
<!DOCTYPE html> 
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <title>Invoice Management | Invoice</title>
      <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
      <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
      <meta content="Coderthemes" name="author" />
      <meta http-equiv="X-UA-Compatible" content="IE=edge" />
      <!-- Font Awsome -->
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
      <!-- App favicon -->
      <link rel="shortcut icon" href="assets/images/favicon.png">
      <!-- Pie Chart Css -->   
      <!--<link href="assets/pie charts/style.css" rel="stylesheet" type="text/css" />-->
      <!-- App css -->
      <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/style.css" rel="stylesheet" type="text/css" />
      <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/css/select2.min.css'>
      <script src="assets/js/modernizr.min.js"></script> 
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> 
      <script type="text/javascript" src="script.js"></script>
      <link href="plugins/sweet-alert2/sweetalert2.min.css" rel="stylesheet" type="text/css">
      <link href="plugins/jquery-toastr/jquery.toast.min.css" rel="stylesheet" />
      <style>
         .table td, .table th {
               padding: .75rem;
               vertical-align: top;
               border-top: 0px solid #dee2e6;
               border-bottom: 1px solid #dee2e6; 
         }
      </style>
   </head>
   <body>
      <!-- Begin page -->
      <div id="wrapper">
         <!-- Top Bar Start -->
         <?php include 'top-header.php'; ?>
         <!-- Top Bar End -->
         <!-- ========== Left Sidebar Start ========== -->
         <?php include 'left-sidebar.php'; ?>
         <!-- Left Sidebar End -->
         <!-- ============================================================== -->
         <!-- Start right Content here -->
         <!-- ============================================================== -->
         <div class="content-page">
            <!-- Start content -->
            <div class="content">
               <div class="container-fluid">
                  <div class="row">
                     <div class="col-12">
                        <div class="page-title-box">
                           <h4 class="page-title float-left">View Invoice</h4>
                           <ol class="breadcrumb float-right">
                              <li class="breadcrumb-item"><a href="#">Sales</a></li>
                              <li class="breadcrumb-item ">All Invoice</li>
                              <li class="breadcrumb-item active">View Invoice</li>
                           </ol>
                           <div class="clearfix"></div>
                        </div>
                     </div>
                  </div>
                  <!-- end row -->
                  
                  <?php 
                      $companyId ="";
                      $sql = " SELECT * FROM generate_invoice where id = '$id' and data_delete = 'NO'"; 
                      $result = mysqli_query($conn,$sql);
                      while( $row = mysqli_fetch_array($result)){ 
                          
                          $bill_pay_name = $row['bill_pay_name'];
                          $invoice_id = $row['invoice_Id'];
                          $proforma_id = $row['proforma_id'];
                          $date = $row['date'];
                          $terms = $row['terms'];
                          $due_date = $row['due_date'];
                          $deliver_address = $row['deliver_address'];
                          $billingAddress = $row['billingAddress'];
                          $client_name = $row['client_name'];
                          $pincode = $row['pincode'];
                          $mobile_no = $row['mobile_no'];
                          $email = $row['email'];
                          $gstin = $row['gstin'];
                          $type = $row['type'];
                          $buyer_reference = $row['buyer_reference'];
                          $delivery_type = $row['delivery_type'];
                          $delivery_terms = $row['delivery_terms'];
                          $mode_of_shipment = $row['mode_of_shipment'];
                          $shipping_date = $row['shipping_date'];
                          $port_of_loading = $row['port_of_loading'];
                          $port_of_delivery = $row['port_of_delivery'];
                          $payment_method = $row['payment_method'];
                          $hs_code = $row['hs_code'];
                          $terms_of_payment = $row['terms_of_payment'];
                          $bank_details = $row['bank_details'];
                          $foreign_charges = $row['foreign_charges'];
                          $foreign_rate = $row['foreign_rate'];
                          $discount_percent = $row['discount_percent'];
                          $discount = $row['discount'];
                          $other_charges = $row['other_charges'];
                          $memo = $row['memo'];
                          $other_price = $row['other_price'];
                          $subtotal_price = $row['subtotal_price'];
                          $foreign_price = $row['foreign_price'];
                          $bank_charge = $row['bank_charge'];
                          $amount_paid = $row['amount_paid']; 
                          $comment = $row['comment']; 
                          $invoice_reference = $row['invoice_reference']; 
                          
                  ?>
                  
                  <div class="card-box">
                     <div class="col-md-12">
                        <div class="row" >
                           <div class="col-md-12 mt-3 mb-3">
                              <h3 class="text-center" style="color:<?php echo $row['company_color'] ?>;"><b>Commercial Invoice</b></h3>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-8">
                                  <p><b>SHIPPER :</b></p>
                                  <h3 class="mb-0"><?php echo $company_name ?></h3>
                                  <p  class="mb-0"><?php echo $address.','.$city.','.$state.','.$country; ?></p>
                                  <p  class="mb-0">Contact Person :Betty Qin</p>
                                  <p  class="mb-0">Contact Number : <?php echo $phone ?></p>
                                  <p  class="mb-0">Email : <?php echo $email ?></p>
                           </div>
                           <div class="col-md-4 text-right">
                                  <h3 class="mb-0">Invoice No.  : <?php echo $invoice_id ?></h3>
                                  <p class="mb-0">Invoice Reference  : <?php echo $invoice_reference ?></p>
                                  <p class="mb-0">Proforma No.  : <?php echo $proforma_id ?></p>
                                  <p class="mb-0">Proforma Date : <?php echo $date ?></p>
                                  <p class="mb-0">Buyer's Order : <?php echo $buyer_reference ?></p>
                                  <p class="mb-0">HS Code :  </p>
                                  <p class="mb-0">Comments:  Haryana</p>
                           </div>
                        </div>
                        <hr>
                        
                        <?php 
                        
                        
                              $contactsql = mysqli_query($conn,"SELECT * FROM `contact` where id='$bill_pay_name' and data_delete !='yes'");
                              $contactrow = mysqli_fetch_assoc($contactsql);
                              
                              $customer_type = $contactrow['customer_type'];
                              $bill_display_name = $contactrow['bill_display_name'];
                              $contact_person_name = $contactrow['contact_person_name'];
                              $contact_person_designation = $contactrow['contact_person_designation'];  
                             
                           
                           
                           //   billing address 
                           
                           $getad_b = mysqli_query($conn,"SELECT * FROM `contact_address` where id='$billingAddress'");
                           $getadrow_b = mysqli_fetch_assoc($getad_b);
                           
                           $address_get_b = $getadrow_b['address'] .', '. $getadrow_b['city'] .', '. $getadrow_b['state'] .', '. $getadrow_b['country'];
                          
                           $currency_contact = $getadrow_b['currency'];
                           
                           
                           

                              
                              
                            //   getting address
                            
                            
                            $getad = mysqli_query($conn,"SELECT * FROM `contact_address` where id='$deliver_address'");
                            $getadrow = mysqli_fetch_assoc($getad);
                             
                            $address_get = $getadrow['address'] .', '. $getadrow['city'] .', '. $getadrow['state'] .', '. $getadrow['country'];
                              $iecno = $getadrow['iecno'];  
                        ?>
                        
                        <div class="row">
                           <div class="col-md-8">
                               <p><b>CONSIGNEE :</b></p>
                              <h4 class="mb-0"> <?php echo $bill_display_name ?> </h4>
                              <p  class="mb-0"> <?php echo $address_get_b ?></p> 
                              <p  class="mb-0">Zip Code : <?php echo $pincode ?></p>
                              <p  class="mb-0">GSTIN : <?php echo $gstin ?></p>
                              <p  class="mb-0">IEC No.: <?php echo $iecno ?></p>
                              <p  class="mb-0">Contact Person: <?php echo $client_name ?></p>
                              <p  class="mb-0">Contact No.: <?php echo $mobile_no ?></p>
                           </div>
                           <div class="col-md-4 text-right">
                                  <h4 class="mb-0">Delivery Terms  : <?php echo $delivery_terms ?></h4>
                                  <p  class="mb-0">Delivery Type : <?php echo $delivery_type ?></p>
                                  <p  class="mb-0">Payment Terms : <?php echo $terms_of_payment ?></p>
                                  <p  class="mb-0">Port Of loading :  <?php echo $port_of_loading ?></p>
                                  <p  class="mb-0">Port Of Delivery :  <?php echo $port_of_delivery ?></p>
                                  <p  class="mb-0">Country Of Origin Of goods :  China</p>
                                  <p  class="mb-0">Country Of Final Destination :  India</p>
                           </div>
                        </div>
                        <hr>
                        
                        <div class="row">
                           <div class="col-md-8">
                              <p><b>SHIP TO :</b></p> 
                              <p><?php echo $address_get  ?></p>
                           </div> 
                           <div class="col-md-4 text-right">
                                  <h4 class="mb-0">Beneficary Name : <?php echo $account_name ?></h4>
                                  <p  class="mb-0">Bank A/C  No. : <?php echo $account_no ?></p>
                                  <p  class="mb-0">Bank Name : <?php echo $bank_name ?></p>
                                  <p  class="mb-0">Swift Name :  <?php echo $shift ?></p>
                                  <p  class="mb-0">Address :  <?php echo $address ?></p> 
                           </div>
                        </div>
                         
                     </div> 
                     <div class="row mb-4">
                         <div class="col-md-12">
                             <p><b>Comment:</b> <?php echo $comment ?></p>
                         </div>
                     </div>
                     <div class="row" >
                       <table class="table table-responsive">
                                    <thead>
                                        <tr style="width:100%"> 
                                            <th>Image</th>
                                            <th>Item Name</th>
                                            <th>Item Code</th>
                                            <th>Color</th>
                                            <th>Unit</th>
                                            <th>Size</th> 
                                            <th>Qty.</th>
                                            <th>Rate (<?php echo $currency_contact ?>)</th>
                                            <th>Total (<?php echo $currency_contact ?>)</th> 
                                        </tr>
                                    </thead>
                                    <tbody id="itemsadd">
                                        <?php 
                                               $getitemsql = mysqli_query($conn,"SELECT * FROM invoice_item a left join inventory b on a.item_id = b.id where a.invoice_reference = '$invoice_reference'");
                                               while($item_row = mysqli_fetch_assoc($getitemsql)){  
                                                   
                                                   $item_image = $item_row['item_image'];
                                                                                                                                
                                            if(!empty($item_image)){
                                              $if_image = '<img  src="inventory/'.$item_image.'" width="50">';
                                            }else{
                                                $if_image = '';
                                            }
                                         
                                                   
                                        ?>
                                        <tr style="width:100%"> 
                                            <td  style="width:5%"><?php echo $if_image ?></td> 
                                            <td  style="width:5%"><?php echo $item_row['name'] ?></td> 
                                            <td  style="width:10%"><?php echo $item_row['item_code'] ?></td> 
                                            <td  style="width:5%"><?php echo $item_row['color'] ?></td>
                                            <td  style="width:5%"><?php echo $item_row['unit_of_measure'] ?></td>
                                            <td  style="width:10%"><?php echo $item_row['size'] ?></td>
                                            <td  style="width:5%"><?php echo $item_row['qty'] ?></td>
                                            <td  style="width:10%"><?php echo $item_row['price'] ?></td>
                                            <td  style="width:10%"><?php echo $item_row['row_total'] ?></td>  
                                        </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                     </div>
                     <div class="row">
                        <div class="col-md-8"></div> 
                        <div class="col-md-4">
                            <div class="form-group row">
                              <p class="col-9 mb-0 ">Other   </label>
                              <div class="col-3">
                                 <p class="mb-0 "><?php echo $other_price?> (<?php echo $currency_contact ?>) </p>
                              </div>
                           </div>
                            <div class="form-group row">
                              <p class="col-9 mb-0 ">Sub Total   </label>
                              <div class="col-3">
                                 <p class="mb-0 "><?php echo $subtotal_price?> (<?php echo $currency_contact ?>) </p>
                              </div>
                           </div>
                            <div class="form-group row">
                              <p class="col-9 mb-0 ">Bank Charges   </label>
                              <div class="col-3">
                                 <p class="mb-0 "><?php echo $bank_charge?> (<?php echo $currency_contact ?>) </p>
                              </div>
                           </div> 
                           <div class="form-group row">
                              <p class="col-9  mb-0 "> Amount Paid   </label>
                              <div class="col-3">
                                 <p class="mb-0 "><?php echo $amount_paid?> (<?php echo $currency_contact ?>) </p>
                              </div>
                           </div>
                                                   
                        </div>
                        <div class="col-md-8">

                        </div>
                        <div class="col-md-12">
        
                            <a href="edit-invoice.php?id=<?php echo $id ?>" class="btn w-md waves-effect waves-light btn-info" data-toggle="tooltip" data-placement="top" title="" data-original-title="Edit"><i class="fa fa-pencil"></i> Edit</a> 
                       
                           <button type="button" class="btn w-md waves-effect waves-light btn-danger" value="<?php echo $id ?>" data-toggle="tooltip" data-placement="top" title="" data-original-title="Delete" id="btnDelete" onclick="deleteInvoice(this)"><i class="fa fa-trash-o"></i> Delete</button>
               
                           <a href="create-packing.php?id=<?php echo $id ?>" class="btn w-md waves-effect waves-light btn-warning" value="<?php echo $id ?>" data-toggle="tooltip" data-placement="top" title="" data-original-title="Convert To Packing List" id="btnConvert"> Convert To Packing List</a>
                       
                           <a href="print-invoice.php?id=<?php echo $id ?>" target="blank" class="btn w-md waves-effect waves-light btn-success"  data-toggle="tooltip" data-placement="top" title="" data-original-title="Print"><i class="fa fa-print"></i> Print</a>
                        </div>
                     </div>
                  </div>
                  
                  <?php } ?>
                  
               </div>
            </div>
            <!-- container -->
         </div>
         <!-- content -->
         <?php include 'copyrignt.php' ?>
      </div>
      <!-- ============================================================== -->
      <!-- End Right content here -->
      <!-- ============================================================== -->
      </div>
      <!-- END wrapper --> 
      <!-- /.modal -->
      <script src="assets/js/jquery.min.js"></script>
      <script src="assets/js/popper.min.js"></script><!-- Popper for Bootstrap -->
      <script src="assets/js/bootstrap.min.js"></script>
      <script src="assets/js/metisMenu.min.js"></script>
      <!--<script src="assets/js/waves.js"></script>-->
      <script src="assets/js/jquery.slimscroll.js"></script> 
      <!-- Dashboard init -->
      <!-- <script src="assets/pages/jquery.dashboard.js"></script> -->
      <!-- App js -->
      <script src="assets/js/jquery.core.js"></script>
      <script src="assets/js/jquery.app.js"></script>
      <!-- Chart Js -->
      <!-- <script src="assets/pie charts/script.js"></script>-->
      <!-- <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js'></script> -->
      <!-- <script src='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.min.js'></script> -->
      <script src="plugins/sweet-alert2/sweetalert2.min.js"></script>
      <script src="plugins/jquery-toastr/jquery.toast.min.js" type="text/javascript"></script>
      <script type="text/javascript">
 
             $(document).ready(function(){
                
                 if (localStorage.getItem("InvoiceDeleted") == "true") {
                     successMessage("Invoice Successfully Deleted.");
                     localStorage.setItem("InvoiceDeleted", "false");
                 }
 
         });
         
             function deleteInvoice(button){
                 var itemId = $(button).val(); 
                 swal({
                         title: 'Are you sure?',
                         text: "Do you really want to restore this Item??",
                         type: 'warning',
                         showCancelButton: true,
                         confirmButtonColor: '#4fa7f3',
                         cancelButtonColor: '#d57171',
                         confirmButtonText: "Yes, I'm Sure!"
                     }).then(function () {
                     $.ajax({
                         url : "PHP/response.php",
                         data : "action=DeleteInvoice&id="+itemId,
                         method : "POST",
                         async : false,
                         success : function(response){
                             if(response == "DELETED"){
                                 localStorage.setItem("InvoiceDeleted", "true");
                                 location.replace('invoice.php');
                                 }
                             else{
                                 errorMessage("Item could not be deleted.");
                             }
                         },
                         error : function(error){
                             errorMessage("Item could not be deleted.");
                         }
                     });
                 });
             }
         
             function errorToast(msg){
                 $.toast({
                         heading: 'Error!',
                         text: msg,
                         position: 'top-right',
                         loaderBg: '#bf441d',
                         icon: 'error',
                         hideAfter: 3000,
                         stack: 1
                 });
                 }
         
             function successMessage(msg){
                 swal({
                     title: 'Success!',
                     text: msg,
                     type: 'success',
                     confirmButtonColor: '#4fa7f3'
                 });
             }
         
             function errorMessage(msg){
                 swal({
                     title: 'Error!',
                     text: msg,
                     type: 'error',
                     confirmButtonColor: '#4fa7f3'
                 });
             }
      </script>
   </body>
</html>