|
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";
$bank_res=mysqli_query($con,"SELECT * FROM `bankaccounts`");
/*$r=mysqli_query($con,"select * from sub_head where `Status` != 'S' ");*/
$r=mysqli_query($con,"select * from sub_head ");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- start: Meta -->
<meta name="robots" content="noindex, nofollow">
<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'>
<link id="bootstrap-style" href="css/new_chosen.min.css" rel="stylesheet">
<!-- 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;
}
#Sub_HeadsRole_chosen
{
width:100%!important;
}
#selectError1_chosen {
width: 50%!important;
}
-->
.controls input,.controls select
{
width:50%;
}
</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="#">Head</a>
</li>
</ul>
<div class="box-content">
<?php if(isset($_SESSION['user'])) { ?>
<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>Add Fees Code (Head)</h2>
</div>
<div class="box-content">
<form class="form-horizontal" action="Head_php.php" method="post" id="customer_form" enctype="multipart/form-data">
<fieldset>
<div class="control-group">
<label class="control-label" for="focusedInput">Head Name</label>
<div class="controls">
<input class="focused" Name="Head_Name" id="focusedInput" type="text" placeholder="This is Main Head Name" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="selectError1">Sub Head </label>
<div class="controls">
<select id="selectError1" multiple data-rel="chosen" Name="Sub_Heads[]" required class="select2 ddlSubHeads" style="width:100%;">
<?php
while($row=mysqli_fetch_array($r))
{
?>
<option value="<?php echo $row['Sub_Id']; ?>" ><?php echo $row['Name']."- (Rs.".$row['Amount'].")"; ?></option>
<?php
}
?>
</select>
<b style="margin-left:5px;">Total : INR <span class="SubHeadsTotal">0</span></b>
</div>
</div>
<div class="control-group">
<label class="control-label" for="selectError">Bank Code</label>
<div class="controls">
<select id="selectError" Name="Bank_Code" data-rel="chosen" required>
<?php
while($bank=mysqli_fetch_array($bank_res))
{
?>
<option value="<?php echo "$bank[Id]"; ?>"><?php echo "$bank[Bank_Name]"."-"."$bank[Account_Number]"; ?></option>
<?php
}
?>
</select>
<a href="bank.php?req=0" class="btn btn-primary btn-sm" style="padding: 0px 5px;margin-top: -17px;margin-left: 7px;"><i class="icon-plus" style=""></i></a>
</div>
</div>
<div class="control-group" style="display:none;">
<label class="control-label" for="date01">Last Date</label>
<div class="controls">
<input type="text" class="datepicker" data-format="yyyy-mm-dd" Name="Last_Date" id="date01" value="01-06-2026" required>
</div>
</div>
<div class="control-group warning" style="display:none;">
<label class="control-label" for="inputWarning">Fine Amount</label>
<div class="controls">
<input type="text" Name="Fine_Amount" id="inputWarning" value="0" required>
<span class="help-inline">Per day after last date </span>
</div>
</div>
<!-- <div class="control-group">-->
<!--<label class="control-label" Name="OTP" for="optionsCheckbox2">One Time Payment</label>-->
<!--<div class="controls">-->
<!-- <label class="checkbox">-->
<!-- <input type="checkbox" Name="OTP" id="optionsCheckbox2" value="Yes" >-->
<!-- </label>-->
<!--</div>-->
<!-- </div>-->
<div class="control-group warning">
<label class="control-label" Name="rname" for="inputWarning">Receipt Name </label>
<div class="controls">
<input type="text" class="ReceiptName" style="text-transform:uppercase;" Name="rname" id="inputWarning" placeholder="Use only four Characters not numbers " maxlength="4" pattern="[A-Za-z]{4}" required>
<!--<span class="help-inline"></span>-->
<span class="help-inline">Use only four Characters not numbers and special Charcters </span>
</div>
</div>
<div class="controls">
<button type="submit" class="btn btn-primary">Save changes</button>
<button class="btn">Cancel</button>
</div>
</fieldset>
</form>
</div>
</div><!--/span-->
</div><!--/row--></form>
<?php } ?>
<div class="box-content1">
<div class="row-fluid sortable">
<div class="box">
<div class="box-header" data-original-title>
<h2><i class="halflings-icon white user"></i><span class="break"></span>Fees Codes</h2>
<div class="box-icon">
</div>
</div>
<table id="example" class="table table-striped table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Sub Head</th>
<?php /*<th>Last Date</th>
<th>One Time Payment</th>*/?>
<th>Total Amount</th>
<?php /* <th>Fine amount</th> */ ?>
<th>Bank Name</th>
<th>Receipt Name</th>
<th style="width:100px;"></th>
</tr></thead>
<?php
include "config/config.php";
$r5=mysqli_query($con,"SELECT * FROM `head` order by Head_Id asc");
while($row5=mysqli_fetch_array($r5))
{
?> <tbody>
<tr>
<td><?php echo $row5['Head_Id']; ?></td>
<td><?php echo $row5['Name']; ?></td>
<td><?php $subhead=explode("/",$row5['SubHeads']);
foreach($subhead as $r1)
{
$r2=mysqli_query($con,"SELECT * FROM `sub_head` WHERE `Sub_Id` = '$r1' ");
$r3=mysqli_fetch_array($r2);
echo $r3['Sub_Id']."-".$r3['Name'] ."- (Rs.".$r3['Amount'].")"; ?> <br>
<?php
}
?></td>
<?php /*
<td><?php echo $row5['Last_Date']; ?></td>
<td><div align="center"><?php echo $row5['One_Time_Payment']; ?></div></td>*/?>
<td>
<div align="center"><?php $subhead=explode("/",$row5['SubHeads']);
$sum=0;
foreach($subhead as $r1)
{
$r2=mysqli_query($con,"SELECT * FROM `sub_head` WHERE `Sub_Id` = '$r1' ");
$r3=mysqli_fetch_array($r2);
$k=$r3['Amount']; ?> <?php
$sum=$sum+$k;
}
echo $sum; ?></div></td>
<?php /* <td><div align="center"><?php echo $row5['Fine_Amount']; ?></div></td> */ ?>
<td><?php $sql6=mysqli_query($con,"SELECT * FROM `bankaccounts` WHERE `Id` = '$row5[Bank_Code]'");
$row9=mysqli_fetch_array($sql6);
echo $row9['Bank_Name'];
?></td>
<td><?php echo $row5['ReciptName']; ?></td>
<?php $head_res_check=mysqli_query($con,"select * from `paid_fees` where `Head_Id` = '$row5[Head_Id]'");
$ckk=mysqli_num_rows($head_res_check);
if($ckk == 0)
{
$_SESSIOn['id']=$row5['Head_Id'];
//echo $row5['Head_Id'];
?>
<td>
<a href="hdelete.php?id=<?php echo $row5['Head_Id']; ?>"><img src="delete.png" width="25px" height="25px"></a>
<button type="button" class="btnEditHead" data-hid="<?php echo $row5['Head_Id']; ?>" data-ids="<?php echo $row5['SubHeads']; ?>" data-hname="<?php echo $row5['Name']; ?>" data-rname="<?php echo $row5['ReciptName']; ?>" data-bank="<?php echo $row5['Bank_Code']; ?>"><i class="icon-edit"></i></button>
<a class="btn btn-danger btn-sm" onclick="return confirm('Are you sure want to duplicate this head ?');" href="head_copy.php?id=<?php echo $row5['Head_Id']; ?>" style="padding: 2px 8px;"><i class="icon-copy"></i></a>
</td>
<?php } else {
?> <td>
<button type="button" class="btnEditHead" data-hid="<?php echo $row5['Head_Id']; ?>" data-ids="<?php echo $row5['SubHeads']; ?>" data-hname="<?php echo $row5['Name']; ?>" data-rname="<?php echo $row5['ReciptName']; ?>" data-bank="<?php echo $row5['Bank_Code']; ?>"><i class="icon-edit"></i></button>
<a class="btn btn-danger btn-sm" onclick="return confirm('Are you sure want to duplicate this head ?');" href="head_copy.php?id=<?php echo $row5['Head_Id']; ?>" style="padding: 2px 8px;"><i class="icon-copy"></i></a>
</td>
<?php } ?>
</tr></tbody>
<?php
}
?>
</table></div>
<p> </p>
</div></div>
</div><!--/.fluid-container-->
<!-- end: Content -->
</div><!--/#content.span10-->
</div><!--/fluid-row-->
<div id="EditHeadDetails" class="modal fade" role="dialog" style="display:none;">
<div class="modal-dialog">
<form action="Head.php" method="post" >
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Edit Sub Head</h4>
</div>
<div class="modal-body">
<div class="control-group">
<label class="control-label" for="Sub_HeadsRole">Sub Head </label>
<div class="controls">
<input class="focused Head_Name1" name="Head_Name1" id="focusedInput" type="text" placeholder="This is Main Head Name" required="">
</div>
</div>
<div class="control-group">
<label class="control-label" for="Sub_HeadsRole">Receipt Name </label>
<div class="controls">
<input class="focused Receipt_Name1" name="Receipt_Name1" id="focusedInput" type="text" placeholder="This is Main Receipt Name" required="">
</div>
</div>
<div class="control-group">
<label class="control-label" for="selectError">Bank Code</label>
<div class="controls">
<select id="selectError1" class="Bank_Code1 select2" Name="Bank_Code1" data-rel="chosen" required>
<?php
$bank_res=mysqli_query($con,"SELECT * FROM `bankaccounts`");
while($bank=mysqli_fetch_array($bank_res))
{
?>
<option value="<?php echo "$bank[Id]"; ?>"><?php echo "$bank[Bank_Name]"."-"."$bank[Account_Number]"; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="Sub_HeadsRole">Sub Head </label>
<div class="controls">
<input type="hidden" name="hdHead_Id" class="hdHead_Id" value="0" />
<select id="Sub_HeadsRole" multiple data-rel="chosen" Name="Sub_Heads1[]" required class="select2 Sub_Heads1">
<?php
$r35=mysqli_query($con,"select * from sub_head ");
while($row=mysqli_fetch_array($r35))
{
?>
<option value="<?php echo $row['Sub_Id']; ?>" ><?php echo $row['Sub_Id']."-". $row['Name']."- (Rs.".$row['Amount'].")"; ?></option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-primary" name="editdata">Save changes</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<script>
function check(id)
{
alert(id);
}
</script>
<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>
<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/new_chosen.jquery.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>
<script>
$(".ReceiptName").keyup(function (e) {
$(this).val($(this).val().toUpperCase());
});
$(".ReceiptName").keypress(function (e) {
var keyCode = e.keyCode || e.which;
var regex = /^[A-Za-z]+$/;
var isValid = regex.test(String.fromCharCode(keyCode));
if (!isValid) {
return false;
}
return isValid;
});
$(".btnEditHead").click(function(){
let ids=$(this).data("ids");
let hid=$(this).data("hid");
let hname=$(this).data("hname");
let rname=$(this).data("rname");
let bank=$(this).data("bank");
//$("#EditHeadDetails").find(".Sub_Heads1").val(1).trigger("chosen:updated");
if (ids.length>2)
{
var str_array = ids.split('/');
for (var i = 0; i < str_array.length; i++) {
str_array[i] = str_array[i].replace(/^\s*/, "").replace(/\s*$/, "");
}
}
else
{
var str_array = ids;
}
$("#Sub_HeadsRole").val(str_array).trigger("chosen:updated");
$("#EditHeadDetails").find(".hdHead_Id").val(hid);
$("#EditHeadDetails").find(".Head_Name1").val(hname);
$("#EditHeadDetails").find(".Receipt_Name1").val(rname);
$("#EditHeadDetails").find(".Bank_Code1").val(bank).trigger("chosen:updated");
$("#EditHeadDetails").modal("show");
});
$(".ddlSubHeads").change(function(){
let ids=$(this).val();
let sub_ids=ids.join(",");
$.ajax({
url: 'GetSubHeadsTotal.php',
type: 'GET',
data: "sub_ids="+sub_ids,
success: function(response) {
$(".SubHeadsTotal").text(response);
}
});
});
</script>
</body>
</html>
<?php
if(isset($_POST['editdata']))
{
$Head_Id=$_POST['hdHead_Id'];
$Head_Name1=$_POST['Head_Name1'];
$Sub_Heads1=$_POST['Sub_Heads1'];
$Receipt_Name1=$_POST['Receipt_Name1'];
$Bank_Code1=$_POST['Bank_Code1'];
$Sub_Head = implode("/", $Sub_Heads1);
$ins=mysqli_query($con,"Update head set SubHeads='$Sub_Head',Name='$Head_Name1',Bank_Code='$Bank_Code1',ReciptName='$Receipt_Name1' WHERE Head_Id=$Head_Id");
if($ins)
{
?>
<script>
alert("Head has been updated...");
document.location="Head.php";
</script>
<?php
}
else
{
?>
<script>
alert("Unable to update Head...");
document.location="Head.php";
</script>
<?php
}
}
?>