1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : all-transactions.php
back
<?php      
    ob_start();
    session_start();
    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'];
    }		  
?>
<!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" />
    <!-- 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" />
      <link href="https://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet">
</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">Payment History</h4>
                                <ol class="breadcrumb float-right">
                                    <li class="breadcrumb-item"><a href="#">Sales</a></li>
                                    <li class="breadcrumb-item active">Payment History</li>
                                </ol>
                                <div class="clearfix"></div>
                            </div>
                        </div>
                    </div>
                    <!-- end row -->
                    
                    
                    <div class="row "> 
                     <div class="col-md-12 card-box" style=" margin: 0 auto;padding: 20px;">
                        <form action="invoice-report-download.php" method="post" role="form">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="exampleInputPassword1">From Date <span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="fromdate" name="fromdate" required> 
                                    </div>
                                </div>

                                <div class="col-md-6">
                                    <div class="form-group">
                                        <label for="exampleInputPassword1">To Date  <span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="todate" name="todate" required>
                                    </div>
                                </div>
                                <input type="hidden" class="form-control" id="report" name="report" value="all_transaction">
                             
                                <div class="col-md-12">
                                        <button type="submit" class="btn btn-purple waves-effect waves-light w-100">Download</button>  
                                </div>
                            </div>
                           
                        </form>
                     </div>
                      <!--end colum -->
                  </div>


                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                            <table id="view_allTransactions_status" class="table table-bordered">
                                    <thead>
                                        <tr class="theme-bg">
                                            <th>Date</th>
                                            <th>Customer Name</th>
                                            <th class="text-center">Amount</th>
                                            <th>Tax Deduction</th>
                                            <th>Invoice No</th>
                                            <th>Transaction Mode</th>
                                         
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php 
										    $sql = "SELECT a.*, b.bill_display_name FROM payment a left join contact b on a.company_id = b.id where a.is_deleted != 'YES' AND transaction_type = 'Credit' AND a.source_id = '$source_id'  ORDER By a.payment_date DESC";
											$result = mysqli_query($conn,$sql);
											while( $row = mysqli_fetch_array($result)){
                                                
										?>
                                        <tr class="gradeX" style='font-size:13px'>
                                            <td><?php echo date("d/m/Y", strtotime($row['payment_date'])); ?></td>
                                            <td><?php echo $row['bill_display_name'] ?></td>
                                            <td><?php echo $row['amount']; ?></td>
                                            <td class="text-center"><?php echo $row['tax_deduction']; ?></td>
                                            <td><?php echo $row['reference']; ?></td>
                                            <td><?php echo $row['mode'] ?></td>
                                            
                                            
                                          
                                        </tr>
                                        <?php } ?>

                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <!-- end: page -->

                    </div>








                </div>
                <!-- container -->
            </div>
            <!-- content -->
            <?php include 'copyrignt.php' ?>
        </div>
        <!-- ============================================================== -->
        <!-- End Right content here -->
        <!-- ============================================================== -->
    </div>
    
   
    <!-- END wrapper -->
   <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() {

      

        $('#view_allTransactions_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: 'allTransactionsData',
                    className: 'btn-sm'
                },
                {
                    extend: 'csv',
                    title: 'allTransactionsData',
                    className: 'btn-sm'
                },
                {
                    extend: 'excel',
                    title: 'allTransactionsData',
                    className: 'btn-sm'
                },
                {
                    extend: 'pdf',
                    title: 'allTransactionsData',
                    className: 'btn-sm'
                },
                {
                    extend: 'print',
                    title: 'allTransactionsData',
                    className: 'btn-sm'
                }
            ]
        });
       
    });

$('#view_allTransactions_status').DataTable({
    order: [[3, 'asc']],
   
});

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