1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : payment-status.php
back
<!DOCTYPE html>
<?php 
   session_start();
   $id = $_GET['id'];
   include 'config.php';
   $login = $_SESSION['login_email'];
   if($login == ''){
       echo '<script>location.replace("index.php")</script>';
   }
   
   if(isset($_SESSION["source_id"])){
       $source_id = $_SESSION['source_id'];
   }
   $contactId = ""; 
   $companyName = "";
   $contactPerson = "";
   $designation = "";
   $sql = "SELECT * FROM contact where id = '$id'";
   $result = mysqli_query($conn,$sql);
   if(mysqli_num_rows($result) > 0){
       while($row = mysqli_fetch_array($result)){ 
           $contactId = $row["id"];
           $customer_type = $row["customer_type"];
           $bill_display_name = $row["bill_display_name"];
           $contactPerson = $row["contact_person_name"];
           $designation = $row["contact_person_designation"];
       }
   }
   
   
   $totalDebit = 0.00;
   $sqlGetDebit = "SELECT amount_paid FROM generate_invoice where bill_pay_name = '$id' AND data_delete != 'yes'";
   $resultGetDebit = mysqli_query($conn,$sqlGetDebit);
   if(mysqli_num_rows($resultGetDebit) > 0){
       while($row = mysqli_fetch_array($resultGetDebit)){ 
           $totalDebit += $row["amount_paid"];
       }
   }
   
   $totalDebit = sprintf('%0.2f', $totalDebit);
   
   $totalCredit = 0.00;
   $sqlGetCredit = "SELECT amount FROM payment where company_id = '$id' AND transaction_type = 'Credit' AND is_deleted = 'NO'";
   $resultGetCredit = mysqli_query($conn,$sqlGetCredit);
   if(mysqli_num_rows($resultGetCredit) > 0){
       while($row = mysqli_fetch_array($resultGetCredit)){ 
           $totalCredit += $row["amount"];
       }
   }
   $totalCredit = sprintf('%0.2f', $totalCredit);
   
                  
   ?>
<html>
   <head>
      <meta 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" />
      <!-- DataTables -->
      <link href="plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <link href="plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <!-- Responsive datatable examples -->
      <link href="plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <script src="assets/js/modernizr.min.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" />
   </head>
   <body>
      <style>
      #view_allpayment_status .openModel{
          
      }
         .tabcontent {
         display: none;
         padding: 6px 12px;
         border: 1px solid #ccc;
         border-top: none;
         }
         @media (min-width: 1200px){
.modal-xl {
    max-width: 1140px;
}}
      </style>
      <!-- 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">Payments</h4>
                        <ol class="breadcrumb float-right">
                           <li class="breadcrumb-item ">Payments</li>
                           <li class="breadcrumb-item active">Payment Status</li>
                        </ol>
                        <div class="clearfix"></div>
                     </div>
                  </div>
               </div>
               <!-- end row -->
              <div class="row">
                     <div class="col-sm-12">
                        <div class="card-box table-responsive">
                           <table id="view_allpayment_status" class="table table-bordered table-striped">
                              <thead>
                                 <tr class="theme-bg">
                                     <th>#</th>
                                    <th>Bill Display Name</th>
                                    <th>Customer Type</th>
                                    <th class="text-center">Bill Amount</th>
                                    <th class="text-center">Payment received</th> 
                                    <th class="text-center">Balance</th>
                                    <th class="text-center">View Summary</th>
                                 </tr>
                              </thead>
                              <tbody>
                                 <?php
                                 $serNo=0;
                                 $sql = "SELECT * FROM `contact` where `data_delete` = 'NO' ORDER BY `contact`.`id` DESC";
   $result = mysqli_query($conn,$sql);
   if(mysqli_num_rows($result) > 0){
       while($row = mysqli_fetch_array($result)){ 
           $contactId = $row["id"];
           $customer_type = $row["customer_type"];
           $bill_display_name = $row["bill_display_name"];
           $contactPerson = $row["contact_person_name"];
           $designation = $row["contact_person_designation"];
           
           
           $totalDebit = 0.00;
   $sqlGetDebit = "SELECT amount_paid FROM generate_invoice where bill_pay_name = '$contactId' AND data_delete != 'yes'";
   $resultGetDebit = mysqli_query($conn,$sqlGetDebit);
   if(mysqli_num_rows($resultGetDebit) > 0){
       while($row = mysqli_fetch_array($resultGetDebit)){ 
           $totalDebit += $row["amount_paid"];
       }
   }
   
   $totalDebit = sprintf('%0.2f', $totalDebit);
   
   $totalCredit = 0.00;
   $sqlGetCredit = "SELECT amount FROM payment where company_id = '$contactId' AND transaction_type = 'Credit' AND is_deleted = 'NO'";
   $resultGetCredit = mysqli_query($conn,$sqlGetCredit);
   if(mysqli_num_rows($resultGetCredit) > 0){
       while($row = mysqli_fetch_array($resultGetCredit)){ 
           $totalCredit += $row["amount"];
       }
   }
   $totalCredit = sprintf('%0.2f', $totalCredit);
   
   $remain_balance=sprintf('%0.2f',($totalDebit-$totalCredit));
                                   ?>
                                 <tr class="gradeX">
                                     <td><?php echo $serNo+=1;?></td>
                                    <td class="company-name"><?php echo ucwords(strtolower($bill_display_name));?></td>
                                    <td><?php echo $customer_type;?></td>
                                     <td class="text-center"><?php echo $totalDebit;?></td> 
                                    <td class="text-center"><?php echo $totalCredit;?></td>
                                    <td class="text-center"><?php echo $remain_balance;?></td>
                                    <td class="text-center"><a data-contact-id="<?php echo $contactId;?>" href="view-company-invoice-details.php?id=<?php echo $contactId?>" target="_blank" class="btn btn-sm btn-info openInvoiceModel"><i class="fa fa-eye"></i></a> </td>
                                 </tr>
                                 <?php }}?>
                                 
                              </tbody>
                           </table>
                        </div>
                     </div>
                     <!-- end: page -->
                  </div>
               
            </div>
            <!-- container -->
         </div>
        
      </div>
<div id="myModalViewSummary" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalViewSummary" data-backdrop="static" data-keyboard="false" aria-hidden="true">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                <h4 class="modal-title" id="addressTitle"><?php echo ucwords(strtolower($bill_display_name));?> <span style="font-weight:300; ">Invoice Details</span></h4>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card-box table-responsive">
                           <table id="invoiceTablesdks" class="table table-bordered table-striped ">
                                <thead>
                                    <tr class="theme-bg">
                                        <th>#</th>
                                        <th>Date</th>
                                        <th>Proforma Id</th>
                                        <th>Invoice Id</th>
                                        <th>Invoice Reference Id</th>
                                        <th>Total Amount</th>
                                    </tr>
                                </thead>
                                <tbody class="dataInvoiceDisplay">
                                   
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary waves-effect" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

      <script src='https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.1.3/Chart.js'></script>
      <!-- jQuery  -->
      <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>-->
      <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 -->
      <!-- Required datatable js -->
      <script src="plugins/datatables/jquery.dataTables.min.js"></script>
      <script src="plugins/datatables/dataTables.bootstrap4.min.js"></script>
      <!-- Buttons examples -->
      <script src="plugins/datatables/dataTables.buttons.min.js"></script>
      <script src="plugins/datatables/buttons.bootstrap4.min.js"></script>
      <script src="plugins/datatables/jszip.min.js"></script>
      <script src="plugins/datatables/pdfmake.min.js"></script>
      <script src="plugins/datatables/vfs_fonts.js"></script>
      <script src="plugins/datatables/buttons.html5.min.js"></script>
      <script src="plugins/datatables/buttons.print.min.js"></script>
      <script src="plugins/datatables/buttons.colVis.min.js"></script>
      <!-- Responsive examples -->
      <script src="plugins/datatables/dataTables.responsive.min.js"></script>
      <script src="plugins/datatables/responsive.bootstrap4.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">
    var $ = jQuery;
    //  $(document).ready(function() {
    //      $('#datatable').DataTable();

    //      //Buttons examples
    //      var table = $('#datatable-buttons').DataTable({
    //          lengthChange: false,
    //          buttons: ['copy', 'excel', 'pdf', 'colvis']
    //      });

    //      table.buttons().container()
    //          .appendTo('#datatable-buttons_wrapper .col-md-6:eq(0)');
    //  });


    $(document).ready(function() {

        // $(document).on('click', '.openInvoiceModel', function() {
        //     var data_contact_id = $(this).attr("data-contact-id");
        //     alert(data_contact_id);
        // });

        // $('#view_allpayment_status').on('click', '.openInvoiceModel', function(event) {
        //     var data_contact_id = $(this).attr("data-contact-id");
        //     // alert(data_contact_id);

        //     if(data_contact_id!=""){
        //     $.ajax({
        //       url:"ajax-show-invoice-details.php",
        //       type:"post",
        //       data:{id:data_contact_id},
        //       success:function(response){
        //           console.log(response);
        //             var data = JSON.parse(response);
        //             if (data.status == "true") {
        //                 $('#addressTitle').html(data.dataRowCompanyName);
        //                 $('.dataInvoiceDisplay').html(data.datarows);
        //                 $('#myModalViewSummary').modal('show');
        //             }
                  
                   
        //       }
        //     });
        // }

        // });


        // $('#view_allemployer').DataTable( {
        //     dom: 'Bfrtip',
        //     buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ]
        // } );

        $('#view_allpayment_status').DataTable({

            // dom: 'Bfrtip',
            dom: "<'row'<'col-sm-4'l><'col-sm-4 text-center'B><'col-sm-4'f>>tp",
            "lengthMenu": [
                [10, 25, 50, -1],
                [10, 25, 50, "All"]
            ],
            buttons: [{
                    extend: 'copy',
                    title: 'allPaymentData',
                    className: 'btn-sm'
                },
                {
                    extend: 'csv',
                    title: 'allPaymentData',
                    className: 'btn-sm'
                },
                {
                    extend: 'excel',
                    title: 'allPaymentData',
                    className: 'btn-sm'
                },
                {
                    extend: 'pdf',
                    title: 'allPaymentData',
                    className: 'btn-sm'
                },
                {
                    extend: 'print',
                    title: 'allPaymentData',
                    className: 'btn-sm'
                }
            ]
        });
        $('#invoiceTablesdks').DataTable({

            // dom: 'Bfrtip',
            dom: "<'row'<'col-sm-4'l><'col-sm-4 text-center'B><'col-sm-4'f>>tp",
            "lengthMenu": [
                [10, 25, 50, -1],
                [10, 25, 50, "All"]
            ],
            buttons: [{
                    extend: 'copy',
                    title: 'allInvoiceData',
                    className: 'btn-sm'
                },
                {
                    extend: 'csv',
                    title: 'allInvoiceData',
                    className: 'btn-sm'
                },
                {
                    extend: 'excel',
                    title: 'allInvoiceData',
                    className: 'btn-sm'
                },
                {
                    extend: 'pdf',
                    title: 'allInvoiceData',
                    className: 'btn-sm'
                },
                {
                    extend: 'print',
                    title: 'allInvoiceData',
                    className: 'btn-sm'
                }
            ]
        });

    });


    //  function getPaidAmount(referenceNo){
    //      var result = 0.00;
    //      $.ajax({
    //          url : "PHP/response.php",
    //          data : "action=getPaidAmount&referenceNo="+referenceNo,
    //          method : "POST",
    //          async : false,
    //          success : function(response){
    //              result = response*1;
    //          },
    //          error : function(err){}
    //      });
    //      return result;
    //  }

</script>
   </body>
</html>