D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
shubmkcj
/
urbane.createerp.com
/
Filename :
new-invoice.php
back
Copy
<?php ob_start(); session_start(); include 'config.php'; $login = $_SESSION['login_email']; if($login == ''){ echo '<script>location.replace("index.php")</script>'; } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Endive Media | 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> </head> <body> <div class="modal fade" id="thankyouModal" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content" style="padding:20px 10px"> <!-- Modal body --> <div class="modal-body text-center"> <h3 class="modal-title"> Invoice Deleted</h3> </div> <div class="col-md-12 text-center"> <button type="button" class="btn btn-danger " data-dismiss="modal" style="padding:10px 20px">Ok</button> </div> </div> </div> </div> <div class="modal fade" id="thankyouedit" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content" style="padding:20px 10px"> <!-- Modal body --> <div class="modal-body text-center"> <h3 class="modal-title"> Invoice Edit Successfully</h3> </div> <div class="col-md-12 text-center"> <button type="button" class="btn btn-danger " data-dismiss="modal" style="padding:10px 20px">Ok</button> </div> </div> </div> </div> <div class="modal fade" id="thankyouinsert" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content" style="padding:20px 10px"> <!-- Modal body --> <div class="modal-body text-center"> <h3 class="modal-title">Invoice Created Successfully</h3> </div> <div class="col-md-12 text-center"> <button type="button" class="btn btn-danger " data-dismiss="modal" style="padding:10px 20px">Ok</button> </div> </div> </div> </div> <div class="modal fade" id="thankyourestore" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content" style="padding:20px 10px"> <!-- Modal body --> <div class="modal-body text-center"> <h3 class="modal-title">Invoice Restored</h3> </div> <div class="col-md-12 text-center"> <button type="button" class="btn btn-danger " data-dismiss="modal" style="padding:10px 20px">Ok</button> </div> </div> </div> </div> <!-- 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">Manage Invoice</h4> <ol class="breadcrumb float-right"> <li class="breadcrumb-item"><a href="#">Dashboard</a></li> <li class="breadcrumb-item active">Invoice</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="datatable" class="table table-bordered"> <thead> <tr class="bg-grey"> <th>Invoice Id</th> <th>Company Name</th> <th>Item</th> <th>Paid Amount</th> <th class="text-center">Actions</th> </tr> </thead> <tbody> <?php $sql = "SELECT a.*, b.default_invoice FROM invoice a left join company_details b on a.company_id = b.id where a.data_delete != 'yes'"; $result = mysqli_query($conn,$sql); while( $row = mysqli_fetch_array($result)){ $default_invoice = "print_invoice.php"; if($row["default_invoice"] != ""){ $default_invoice = $row["default_invoice"]; } ?> <tr class="gradeX"> <td><?php echo $row['invoice'] ?></td> <td><?php echo $row['company_name'] ?></td> <td> <?php $itemId = explode(",", $row['item_name']); $itemName = ""; for($i = 0; $i < count($itemId); $i++){ $id = $itemId[$i]; $sqlGetItemName = "SELECT item_name FROM inventory_manager WHERE id = '$id'"; $resultGetItemName = mysqli_query($conn, $sqlGetItemName); if($resultGetItemName){ while($rowGetItemName = mysqli_fetch_array($resultGetItemName)){ $itemName .= $rowGetItemName["item_name"]. ", "; } } } echo substr(trim($itemName), 0, -1); ?> </td> <td><?php echo $row['amount_paid'] ?></td> <td class="actions text-center"> <a href="edit-invoice.php?id=<?php echo $row['id'] ?>" class="btn btn-icon waves-effect waves-light btn-info" data-toggle="tooltip" data-placement="top" title="" data-original-title="Edit"><i class="fa fa-pencil"></i></a> <a href="delete_invoice.php?id=<?php echo $row['id'] ?>" class="btn btn-icon waves-effect waves-light btn-danger" data-toggle="tooltip" data-placement="top" title="" data-original-title="Delete"><i class="fa fa-trash-o"></i></a> <a href="view_invoice.php?id=<?php echo $row['id'] ?>" class="btn btn-icon waves-effect waves-light btn-warning" data-toggle="tooltip" data-placement="top" title="" data-original-title="View"><i class="fa fa-eye"></i></a> <a href="<?php echo $default_invoice; ?>?id=<?php echo $row['id'] ?>" class="btn btn-icon waves-effect waves-light btn-purple" data-toggle="tooltip" data-placement="top" title="" data-original-title="Print" target="_blank"><i class="fa fa-print"></i></a> </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 --> <!-- Chart Js --> <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="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> --> <!-- 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 type="text/javascript"> $(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)'); }); </script> </body> <?php if(isset($_SESSION['success'])){ $success = $_SESSION['success'] ; if($success === "success" ){ echo "<script> $(window).load(function(){ $('#thankyouModal').modal('show'); });</script>"; $_SESSION['success'] = ''; } } if(isset($_SESSION['edit'])){ $edit = $_SESSION['edit'] ; if($edit === "edit" ){ echo "<script> $(window).load(function(){ $('#thankyouedit').modal('show'); });</script>"; $_SESSION['edit'] = ''; } } if(isset($_SESSION['insert'])){ $insert = $_SESSION['insert'] ; if($insert === "insert" ){ echo "<script> $(window).load(function(){ $('#thankyouinsert').modal('show'); });</script>"; $_SESSION['insert'] = ''; } } if(isset($_SESSION['restore'])){ $restore = $_SESSION['restore'] ; if($restore === "restore" ){ echo "<script> $(window).load(function(){ $('#thankyourestore').modal('show'); });</script>"; $_SESSION['restore'] = ''; } } ?> </html>