|
Server IP : 2a02:4780:3:1378:0:3736:a38e:10 / Your IP : 3.149.233.90 Web Server : LiteSpeed System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/src/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// First we execute our common code to connection to the database and start the session
require("common.php");
// At the top of the page we check to see whether the user is logged in or not
if(!isset($_SESSION['user']) && !isset($_SESSION['Mng_User']))
{
// If they are not, we redirect them to the login page.
header("Location: login.php");
// Remember that this die statement is absolutely critical. Without it,
// people can view your members-only content without logging in.
die("Redirecting to login.php");
}
// Everything below this point in the file is secured by the login system
// We can display the user's username to them by reading it from the session array. Remember that because
// a username is user submitted content we must use htmlentities on it before displaying it to the user.
?>
<?php
include "config/config.php";
if (isset($_POST['btnAddBankDetails']))
{
//echo"<pre>"; print_r($_POST); exit;
/*$sql="INSERT INTO `bankaccounts` (`Bank_Name`, `IFSC`, `Account_Number`, `AccountHolderName`, `PayuKey`, `SaltKey`, `MerchantKey`, `AccountType`,`Link`) VALUES ('$_POST[BankName]', '$_POST[IFSC]', '$_POST[AccountNumber]', '$_POST[AccountHolderName]', '$_POST[PayuKey]', '$_POST[SaltKey]', '$_POST[MerchantKey]', '$_POST[AccountType]','$_POST[Link]')";*/
$sql="INSERT INTO `bankaccounts` (`Bank_Name`, `Account_Number`, `AccountHolderName`) VALUES ('$_POST[BankName]', '$_POST[AccountNumber]', '$_POST[AccountHolderName]')";
$AccountNumber_RightFour=substr($_POST['AccountNumber'], -4);
$ledger_Name="$_POST[BankName]"."-"."$AccountNumber_RightFour";
mysqli_query($con,"INSERT INTO `ledger` (`Name`, `Type`) VALUES ('$ledger_Name', 'Current Assets')");
if(!mysqli_query($con,$sql))
{
echo "Error";
}else
{
?>
<script>
alert("Bank Details are Saved");
<?php
if(isset($_GET['req']))
{
?>
window.location="Head.php";
<?php
}
else
{
?>
window.location="bank.php";
<?php
}
?>
</script>
<?php
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- start: Meta -->
<meta charset="utf-8">
<title>Fees Management</title> <meta name="description" content="Bootstrap Metro Dashboard">
<meta name="author" content="Dennis Ji">
<meta name="keyword" content="Metro, Metro UI, Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">
<!-- end: Meta -->
<!-- start: Mobile Specific -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- end: Mobile Specific -->
<!-- start: CSS -->
<link id="bootstrap-style" href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-responsive.min.css" rel="stylesheet">
<link id="base-style" href="css/style.css" rel="stylesheet">
<link id="base-style-responsive" href="css/style-responsive.css" rel="stylesheet">
<link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800&subset=latin,cyrillic-ext,latin-ext' rel='stylesheet' type='text/css'>
<!-- end: CSS -->
<!-- The HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<link id="ie-style" href="css/ie.css" rel="stylesheet">
<![endif]-->
<!--[if IE 9]>
<link id="ie9style" href="css/ie9.css" rel="stylesheet">
<![endif]-->
<!-- start: Favicon -->
<link rel="shortcut icon" href="img/favicon.ico">
<!-- end: Favicon -->
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
}
-->
</style>
</head>
<body>
<!-- start: Header -->
<?php include "menu_f.php"; ?>
<!-- start: Header -->
<div class="container-fluid-full">
<div class="row-fluid">
<!-- start: Main Menu -->
<div id="sidebar-left" class="span2">
<div class="nav-collapse sidebar-nav">
<ul class="nav nav-tabs nav-stacked main-menu">
<li><a href="dashboard.php"><i class="icon-bar-chart"></i><span class="hidden-tablet"> Dashboard</span></a></li>
<?php include "menu.php"; ?>
</ul>
</div>
</div>
<!-- end: Main Menu -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
</div>
</noscript>
<!-- start: Content -->
<div id="content" class="span10">
<ul class="breadcrumb">
<li>
<i class="icon-home"></i>
<a href="dashboard.php">Home</a>
<i class="icon-angle-right"></i>
</li>
<li>
<i class="icon-edit"></i>
<a href="#">Bank Details</a>
</li>
</ul>
<div class="box-content">
<div class="row-fluid sortable">
<div class="box span12">
<div class="box-header" data-original-title>
<h2><i class="halflings-icon white edit"></i><span class="break"></span>Manage Bank Accounts</h2>
</div>
<div class="box-content">
<form class="form-horizontal" action="" method="post" id="customer_form" enctype="multipart/form-data">
<fieldset>
<div class="control-group">
<label class="control-label" for="focusedInput">Bank Name</label>
<div class="controls">
<input class="input-xlarge focused" Name="BankName" id="focusedInput" type="text" placeholder="Bank Name" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Account Holder Name</label>
<div class="controls">
<input class="input-xlarge focused" Name="AccountHolderName" id="focusedInput" type="text" placeholder="Account Holder Name" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Account Number</label>
<div class="controls">
<input class="input-xlarge focused" Name="AccountNumber" id="focusedInput" type="text" placeholder="Account Number" required>
</div>
</div>
<?php /*
<div class="control-group">
<label class="control-label" for="focusedInput">IFSC</label>
<div class="controls">
<input class="input-xlarge focused" Name="IFSC" id="focusedInput" type="text" placeholder="IFSC" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">PayuKey</label>
<div class="controls">
<input class="input-xlarge focused" Name="PayuKey" id="focusedInput" type="text" placeholder="PayuKey" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">SaltKey</label>
<div class="controls">
<input class="input-xlarge focused" Name="SaltKey" id="focusedInput" type="text" placeholder="SaltKey" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">MerchantKey</label>
<div class="controls">
<input class="input-xlarge focused" Name="MerchantKey" id="focusedInput" type="text" placeholder="MerchantKey" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Account Type</label>
<div class="controls">
<input class="input-xlarge focused" Name="AccountType" id="focusedInput" type="text" placeholder="AccountType" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Link</label>
<div class="controls">
<input class="input-xlarge focused" Name="Link" id="focusedInput" type="text" placeholder="Link" required>
</div>
</div> */ ?>
<div class="form-actions">
<button type="submit" name="btnAddBankDetails" class="btn btn-primary">Save changes</button>
<button class="btn">Cancel</button>
</div>
</fieldset>
</form>
</div>
</div><!--/span-->
</div><!--/row-->
<div class="box-content">
<div class="row-fluid sortable">
<div class="box span12">
<div class="box-header" data-original-title>
<h2><i class="halflings-icon white user"></i><span class="break"></span>Banks</h2>
</div>
<table id="example" class="table table-striped table-bordered">
<thead>
<tr>
<th>Bank ID</th>
<th>Bank Name</th>
<th>Account Holder Name</th>
<th>Account Number</th>
<!--th>IFSC</th>
<th>Account Type</th-->
<th>Action</th>
</tr></thead>
<?php
include "config/config.php";
$r5=mysqli_query($con,"SELECT * FROM `bankaccounts`");
while($row5=mysqli_fetch_array($r5))
{
?> <tbody>
<tr>
<td class="bank_id"><?php echo $row5['Id']; ?></td>
<td class="bank_name"><?php echo $row5['Bank_Name']; ?></td>
<td class="bank_account_name"><?php echo $row5['AccountHolderName']; ?> </td>
<td class="bank_account_number"><?php echo $row5['Account_Number']; ?></td>
<!--td><?php echo $row5['IFSC']; ?></td>
<td><?php echo $row5['AccountType']; ?></td-->
<td>
<a href="javascript:void(0)" class="btnEdit">Edit</a>
</td>
</tr></tbody>
<?php
}
?>
</table></div>
<p> </p>
</div></div>
</div><!--/.fluid-container-->
<!-- end: Content -->
</div><!--/#content.span10-->
</div><!--/fluid-row-->
<div id="myModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<form class="form-horizontal" action="" method="post" id="" enctype="multipart/form-data">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Edit Bank Details</h4>
</div>
<div class="modal-body">
<div class="box-content">
<fieldset>
<div class="control-group">
<label class="control-label" for="focusedInput">Bank Name</label>
<div class="controls">
<input class="input-xlarge focused BankName_edit" Name="BankName_edit" id="focusedInput" type="text" placeholder="Bank Name" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Account Holder Name</label>
<div class="controls">
<input class="input-xlarge focused AccountHolderName_edit" Name="AccountHolderName_edit" id="focusedInput" type="text" placeholder="Account Holder Name" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput">Account Number</label>
<div class="controls">
<input class="input-xlarge focused AccountNumber_edit" Name="AccountNumber_edit" id="focusedInput" type="text" placeholder="Account Number" required>
</div>
<input type="hidden" class="hdbank_id" name="bank_id" />
</div>
</fieldset>
</div>
</div>
<div class="modal-footer">
<button type="submit" name="btnSaveBankDetails" class="btn btn-primary">Save changes</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<div class="clearfix"></div>
<footer>
<p>
<span style="text-align:left;float:left">© 2018 <a href="http://evisioninfotech.in" alt="Bootstrap_Metro_Dashboard">e vision infotech</a></span>
</p>
</footer>
<!-- start: JavaScript-->
<script src="js/jquery-1.9.1.min.js"></script>
<script src="js/jquery-migrate-1.0.0.min.js"></script>
<script src="js/jquery-ui-1.10.0.custom.min.js"></script>
<script src="js/jquery.ui.touch-punch.js"></script>
<script src="js/modernizr.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.cookie.js"></script>
<script src='js/fullcalendar.min.js'></script>
<script src='js/jquery.dataTables.min.js'></script>
<script src="js/excanvas.js"></script>
<script src="js/jquery.flot.js"></script>
<script src="js/jquery.flot.pie.js"></script>
<script src="js/jquery.flot.stack.js"></script>
<script src="js/jquery.flot.resize.min.js"></script>
<script src="js/jquery.chosen.min.js"></script>
<script src="js/jquery.uniform.min.js"></script>
<script src="js/jquery.cleditor.min.js"></script>
<script src="js/jquery.noty.js"></script>
<script src="js/jquery.elfinder.min.js"></script>
<script src="js/jquery.raty.min.js"></script>
<script src="js/jquery.iphone.toggle.js"></script>
<script src="js/jquery.uploadify-3.1.min.js"></script>
<script src="js/jquery.gritter.min.js"></script>
<script src="js/jquery.imagesloaded.js"></script>
<script src="js/jquery.masonry.min.js"></script>
<script src="js/jquery.knob.modified.js"></script>
<script src="js/jquery.sparkline.min.js"></script>
<script src="js/counter.js"></script>
<script src="js/retina.js"></script>
<script src="js/custom.js"></script>
<!-- end: JavaScript-->
<script>
$(".btnEdit").click(function(){
$(".BankName_edit").val($(this).parents("tr").find(".bank_name").text());
$(".AccountHolderName_edit").val($(this).parents("tr").find(".bank_account_name").text());
$(".AccountNumber_edit").val($(this).parents("tr").find(".bank_account_number").text());
$(".hdbank_id").val($(this).parents("tr").find(".bank_id").text());
$("#myModal").modal("show");
});
</script>
</body>
</html>
<?php
if (isset($_POST['btnSaveBankDetails']))
{
$sql="UPDATE `bankaccounts` SET `Bank_Name`='$_POST[BankName_edit]', `Account_Number`='$_POST[AccountNumber_edit]', `AccountHolderName`='$_POST[AccountHolderName_edit]' where Id=$_POST[bank_id]";
//echo $sql; exit;
$AccountNumber_RightFour=substr($_POST['AccountNumber_edit'], -4);
$ledger_Name="$_POST[BankName_edit]"."-"."$AccountNumber_RightFour";
mysqli_query($con,"INSERT INTO `ledger` (`Name`, `Type`) VALUES ('$ledger_Name', 'Current Assets')");
if(!mysqli_query($con,$sql))
{
echo "Error";
}else
{
?>
<script>
alert("Bank Details are Saved");
window.location="bank.php";
</script>
<?php
}
}
?>