1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : view_expense.php
back
<!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>