Create New Item
×
Item Type
File
Folder
Item Name
File Manager
/
mns
/
pages
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php include("../db/cn.php"); ob_start(); if (isset($_SESSION['user_name']) && isset($_SESSION['user_role']) && isset($_SESSION['outlet_name']) && isset($_SESSION['outlet_address'])) { $userName = $_SESSION['user_name']; $userRole = $_SESSION['user_role']; $outlet_address = $_SESSION['outlet_address']; $outlet_name = $_SESSION['outlet_name']; } if($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['transfer_add'])){ $from_i = $_POST["from_i"]; $to_i = $_POST["to_i"]; $desc_i = $_POST["desc_i"]; $amount_i = $_POST["amount_i"]; $date_time = date("Y-m-d"); mysqli_query($connection,"insert into transfer (from_i,to_i,desc_i,amount_i,date_time,user_name,role,outlet_name,outlet_address) values('".$from_i."','".$to_i."','".$desc_i."','".$amount_i."','".$date_time."','".$userName."','".$userRole."', '".$outlet_name."','".$outlet_address."')"); echo "<script type='text/javascript'>window.location.href = 'transfer.php';</script>"; } if($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['withdraw_add'])){ $userName1 = $_SESSION['user_name']; $userRole1 = $_SESSION['user_role']; @$name_detailnew = $_POST['desc1']; @$amountnew = $_POST["amount1"]; $paid_wd = $_POST["paid_wd"]; $date_timenew = date("Y-m-d"); mysqli_query($connection,"insert into withdraw(name_detail,amount,paid_by,date_time,login_user,user_role,outlet_name,outlet_address) values('".$name_detailnew."','".$amountnew."','".$paid_wd."','".$date_timenew."','".$userName1."','".$userRole1."','".$outlet_name."','".$outlet_address."') "); } ob_end_flush(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta name="description" content=""> <meta name="author" content=""> <title>Whole Sale Retail</title> <!-- Custom fonts for this template--> <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="https://fonts.googleapis.com/css2?family=Quicksand:wght@200;300;400;500;600;700&display=swap" rel="stylesheet"> <!-- Custom styles for this template--> <link href="../css/sb-admin-2.min.css" rel="stylesheet"> <link href="../css/sb-admin-2.css" rel="stylesheet"> <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> </head> <style> body { font-family: 'Quicksand', sans-serif; } #table-container-wrapper { max-height: 660px; /* Adjust the maximum height as needed */ overflow-y: auto; /* Enable vertical scroll when content overflows */ } .chart-container { position: relative; background: rgba(255, 255, 255, 0.9); border-radius: 10px; padding: 15px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.2); } canvas { max-width: 100%; height: auto; } .bg-gradient-primary{ background:#0A4657; color:#fff; } .btn-primary{ background:#0A4657; color:#fff; border:1px #0A4657 solid; } .btn-primary:hover{ background:#fff; border:1px #0A4657 solid; color:#0A4657; } .chart-container { position: relative; background: rgba(255, 255, 255, 0.9); border-radius: 10px; padding: 15px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.2); } canvas { max-width: 100%; height: auto; } .fa-download:hover{ color:#953E39; } .text-primary{ } </style> <body id="page-top"> <!-- Page Wrapper --> <div id="wrapper"> <!-- Sidebar --> <?php include("common/sd.php"); ?> <!-- End of Sidebar --> <!-- Content Wrapper --> <div id="content-wrapper" class="d-flex flex-column"> <!-- Main Content --> <div id="content"> <!-- Topbar --> <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow"> <!-- Sidebar Toggle (Topbar) --> <button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3"> <i class="fa fa-bars"></i> </button> <!-- Topbar Search --> <?php include('common/log.php'); ?> <!-- Topbar Navbar --> </nav> <!-- End of Topbar --> <!-- Begin Page Content --> <div class="container-fluid"> <div class="row"> <div class="col-sm-5"> <h1 class="mb-3" style="color:#060606;font-weight:700;">Transfer IN/OUT</h1> </div> <div class="col-sm-3"></div> <div class="col-sm-3"> <button type="button" class="btn btn-dark " style="float:right;" data-toggle="modal" data-target="#addWithdrawModal"> Add Transfer</button> </div> </div> </div> <br> <?php $transfer_view = mysqli_query($connection,"select * from transfer"); ?> <div class="container-fluid"> <div class="row"> <div class="col-sm-12" id="table-container-wrapper"> <table class="table table-stripped table-hover text-center"> <tr> <th style="background:#5A5C69;color:#fff;">Sr#</th> <th style="background:#5A5C69;color:#fff;">Date</th> <th style="background:#5A5C69;color:#fff;">Transfer-From</th> <th style="background:#5A5C69;color:#fff;">Transfer-To</th> <th style="background:#5A5C69;color:#fff;">Description</th> <th style="background:#5A5C69;color:#fff;">Amount</th> </tr> <?php $sr_no = 1; while($row = mysqli_fetch_array($transfer_view)){ ?> <tr> <td><?php echo $sr_no++; ?></td> <td><?php echo $row["date_time"]; ?></td> <td><?php echo $row["from_i"]; ?></td> <td><?php echo $row["to_i"]; ?></td> <td><?php echo $row["desc_i"]; ?></td> <td><?php echo $row["amount_i"]; ?></td> </tr> <?php } ?> </table> </div> </div> </div> </div> </div> <div class="modal fade" id="addWithdrawModal" tabindex="-1" role="dialog" aria-labelledby="addwithdrawModalLabel" aria-hidden="true" style="margin-top:80px;"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title text-capitalize" id="addwithdrawModalLabel">Transfer</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <!-- Form for adding purchase --> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data"> <div class="form-group"> <lable>From</lable> <select name="from_i" class="form-control"> <option valuse="">Select</option> <option value="cash">Cash</option> <option value="bank1">Bank 1</option> <option value="bank2">Bank 2 </option> <option value="bank3">Bank 3</option> <option value="other">Other</option> </select> </div> <div class="form-group"> <lable>To</lable> <select name="to_i" class="form-control"> <option valuse="">Select</option> <option value="cash">Cash</option> <option value="bank1">Bank 1</option> <option value="bank2">Bank 2 </option> <option value="bank3">Bank 3</option> <option value="other">Other</option> </select> </div> <div class="form-group"> <label>Description</label> <input type="text" name="desc_i" class="form-control" > </div> <div class="form-group"> <label>Amount</label> <input type="text" name="amount_i" class="form-control" > </div> <button type="submit" class="btn btn-dark" name="transfer_add">Enter</button> </form> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- End of Main Content --> <!-- Footer --> <?php include("common/main_ft.php"); ?> <!-- End of Footer --> </div> <!-- End of Content Wrapper --> </div> <!-- End of Page Wrapper --> <!-- Scroll to Top Button--> <a class="scroll-to-top rounded" href="#page-top"> <i class="fas fa-angle-up"></i> </a> <!-- Logout Modal--> <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5> <button class="close" type="button" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div> <div class="modal-footer"> <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button> <a class="btn btn-primary" href="">Logout</a> </div> </div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js"></script> <!-- Bootstrap core JavaScript--> <script src="../vendor/jquery/jquery.min.js"></script> <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- Core plugin JavaScript--> <script src="../vendor/jquery-easing/jquery.easing.min.js"></script> <!-- Custom scripts for all pages--> <script src="../js/sb-admin-2.min.js"></script> </body> </html>