D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
thread-self
/
root
/
proc
/
thread-self
/
root
/
home
/
shubmkcj
/
urbane.createerp.com
/
Filename :
view_expense.php
back
Copy
<!DOCTYPE html> <?php $id = $_GET['id']; session_start(); include 'config.php'; $login = $_SESSION['login_email']; if($login == ''){ echo '<script>location.replace("index.php")</script>'; } $isTaxable = ""; $dateofExpense = ""; $vendorName = ""; $vendorGST = ""; $invoiceNo = ""; $itemName = ""; $amount = ""; $cgst = ""; $sgst = ""; $igst =""; $paymentMode = ""; $paymentRemarks = ""; $itemRemarks = ""; $sql = "SELECT * FROM expenses where id = '$id'"; $result = mysqli_query($conn,$sql); if($result){ if(mysqli_num_rows($result) > 0){ while( $row = mysqli_fetch_array($result)){ $isTaxable = $row["is_taxable"]; $dateofExpense = $row["date_of_expense"]; $vendorName = $row["vendor_name"]; $vendorGST = $row["vendor_gst"]; $invoiceNo = $row["invoice_no"]; $itemName = $row["item_name"]; $amount = $row["amount"]; $cgst = $row["cgst"]; $sgst = $row["sgst"]; $igst =$row["igst"];; $paymentMode = $row["payment_mode"]; $paymentRemarks = $row["payment_remarks"]; $itemRemarks = $row["item_remarks"]; } } } ?> <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> <link href="plugins/sweet-alert2/sweetalert2.min.css" rel="stylesheet" type="text/css"> </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 Expense</h4> <ol class="breadcrumb float-right"> <li class="breadcrumb-item ">Expenses</li> <li class="breadcrumb-item active">View Expense</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 class="table table-bordered" id="datatable-editable"> <tbody> <?php if($isTaxable == "YES"){ ?> <tr class="gradeX"> <td class="bg-grey">Date of Expense</td> <td><?php echo $dateofExpense; ?></td> <td class="bg-grey">Vendor Name</td> <td><?php echo $vendorName; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">Vendor GSTIN</td> <td><?php echo $vendorGST; ?></td> <td class="bg-grey">Invoice No</td> <td><?php echo $invoiceNo; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">Item Name</td> <td><?php echo $itemName; ?></td> <td class="bg-grey">Amount</td> <td><?php echo $amount; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">CGST</td> <td><?php echo $cgst; ?></td> <td class="bg-grey">SGST</td> <td><?php echo $sgst; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">IGST</td> <td><?php echo $igst; ?></td> <td class="bg-grey">Payment Mode</td> <td><?php echo $paymentMode; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">Payment Remarks</td> <td><?php echo $paymentRemarks; ?></td> <td class="bg-grey">Item Remarks</td> <td><?php echo $itemRemarks; ?></td> </tr> <?php } else { ?> <tr class="gradeX"> <td class="bg-grey">Date of Expense</td> <td><?php echo $dateofExpense; ?></td> <td class="bg-grey">Item Name</td> <td><?php echo $itemName; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">Amount</td> <td><?php echo $amount; ?></td> <td class="bg-grey">Payment Mode</td> <td><?php echo $paymentMode; ?></td> </tr> <tr class="gradeX"> <td class="bg-grey">Item Remarks</td> <td><?php echo $itemRemarks; ?></td> <td class="bg-grey"></td> <td></td> </tr> <?php } ?> </tbody> </table> <?php if (strpos($_SERVER["HTTP_REFERER"], 'deleted_expenses') === false) { ?> <div class="row"> <div class="col-sm-4"> <form action="add_expense.php" method="post"> <input type="hidden" value="<?php echo $id; ?>" name="expenseId"> <?php if($access->getFinanceEdit($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?> <button type="submit" class="btn btn-md btn-info" id="btnEdit">Edit</button> <?php } ?> <?php if($access->getFinanceDelete($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?> <button type="button" class="btn btn-md btn-danger" id="btnDelete">Delete</button> <?php } ?> </form> </div> </div> <?php } ?> </div> </div> <!-- end Panel --> </div> <!-- end container --> </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 src="plugins/sweet-alert2/sweetalert2.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)'); }); $(document).ready(function(){ if (localStorage.getItem("expenseAdded") == "true") { successMessage("Expense Successfully Updated."); localStorage.setItem("expenseAdded", "false"); } }) $("#btnDelete").click(function(){ var id = "<?php echo $id; ?>"; swal({ title: 'Are you sure?', text: "Do you really want to delete this?", type: 'warning', showCancelButton: true, confirmButtonColor: '#4fa7f3', cancelButtonColor: '#d57171', confirmButtonText: "Yes, I'm Sure!" }).then(function () { $.ajax({ url : "PHP/response.php", data : "action=DeleteExpense&id="+id, async : false, method : "POST", success : function(response){ if(response.trim() == "DELETED"){ localStorage.setItem("expenseDeleted", "true"); location.replace("all_expenses.php"); } else{ errorMessage("Could not delete this expense."); } }, error : function(err){ errorMessage("Could not delete this expense."); } }); }) }) 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>