JezK

Edit File: fee_accounts.php

<?php
session_start();
include('session_check.php');
include('adm_operations.php');
include("menuheader.php");
$operations=new adm_operations();
if(!(in_array(6,$access) && in_array(6,$allow)))
echo "<script>location.replace('dashboard.php');</script>";
$class=$operations->getallClassesforOrder($_SESSION['child']['log_school_id'],$_SESSION['child']['choosen_academic_id']);
$sections=0;
$terms=0;
	if(isset($_GET['cln']))
	{
		$sections=$operations->getallsectionsdetailsbyclassId($_GET['cln']);	
	}
// GET TERMS BY CLASS AND SECTION ID'S
	if(isset($_GET['cln']) && isset($_GET['scn']))
	{
		$terms=$operations->getalltermsbyclassnsection($_GET['cln'],$_GET['scn'],$_SESSION['child']['choosen_academic_id']);	
	}

// GET ALL STUDENT TERM FEE DATA USING CLASS AND SECTION ID'S 
$studentfee='0';
$set=0;
$paidstudents_count=0;
$unpaidstudents_count=0;
	if(isset($_GET['trm']) && isset($_GET['cln']) && isset($_GET['scn']))
	{
		$studentfee=$operations->getstudentfeeterms($_SESSION['child']['log_school_id'],$_SESSION['child']['current_academic_id'],$_GET['cln'],$_GET['scn'],$_GET['trm']);
		
		foreach($studentfee as $row)
		{
			if($row['pay_status']=='Paid')
			{
				$paidstudents_count++;
				
			}else
			{
				$unpaidstudents_count++;
			}
			
		}	
	}

if(isset($_POST['termsubmit']))
{
	foreach($_POST['stdid'] as $val)
	{
	if(isset($_POST['paidsts'.$val]))	
		$pdsts[$val]=$_POST['paidsts'.$val];
	else
		$pdsts[$val]=$_POST['paidsts'.$val];
	//echo 'hi'.$_POST['paidsts'.$val];
	}
	$feeids=$_POST['feeid'];
	$stdids=$_POST['stdid'];
	$paidsts=$_POST['paidsts'];
	$formsubmit=$operations->updatestudentFeeAccounts($_SESSION['child']['current_academic_id'],$_POST['stdid'],$_POST['feeid'],$_POST['trmid'],$_POST['clnid'],$_POST['scnid'],$pdsts,$_POST['feeamt'],$_SESSION['fee'],$_POST['tname']);
	
	if($formsubmit=='1')
	{
		$x="fee_accounts.php?cln=".$_POST['clnid']."&scn=".$_POST['scnid']."&trm=".$_POST['trmid']."&act=success";
		echo '<script>location.href="'.$x.'";</script>';		
	}
	unset($_SESSION['fee']);
	
} 
?>
<style>
#nav {
	
	margin: auto;
  	width:300px !important;
	padding-left:0;
	padding-right:0;
	list-style: none;
	background: #18b88d;	
	}
	
	#nav li {
	display:inline-block;
	margin:0 auto;
	text-align:center;
	}
	
	#nav li a {
	display: inline-block;
	padding: 7px 0;
	text-align:center;
	text-decoration: none;
	
	color: #FFFFFF;
	margin:auto;
}

#nav li:hover, li:active {
    background-color: rgb(54, 120, 102);
	width:90px;
}

#nav li.selected 
{
    background: rgb(54, 120, 102);
}

select {
    width: 62px  !important;
    background-color: #FFF;
    border: 1px solid #CCC;
}
.table-condensed > thead > tr > th, .table-condensed > tbody > tr > th, .table-condensed > tfoot > tr > th, .table-condensed > thead > tr > td, .table-condensed > tbody > tr > td, .table-condensed > tfoot > tr > td {
    padding: 0px;
}
</style>
<body style="overflow-x: hidden;">
<div class="row" style="margin-top: 30px;">
	<div class="col-md-9  text-left" style="font:Arial, Helvetica, sans-serif;font-style:normal;font-size:24px; margin-left:20px;">
		<img src="images/rupee-black.png"  title ="Fee Management"   style="font-size: 24px;"/>  Fee Management
	</div>
	<div class="col-md-2 text-center" style="float:right;">
		<button type="button"  onClick="getallunpaid()" class="btn btn-default" style="margin-right:20px;font-family: Arial, Helvetica, sans-serif; font-size:14px;padding:4px 10px;">
		Send Reminder to All
		</button>
	</div>
</div>
<br>
<div class="menuu">
	<ul id="nav" class="margn_auto text-center">
		<li style="border-right:1px solid #FFFFFF;width:150px; text-align:center;margin-left:-3px;font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
			<a  href="fee_management.php"><img src="images/free-account_white.png"  title ="Fee Schedule" style="margin-right:5px;"/>Fee Schedule</a>
		</li>
		<li class="selected" style="width:152px; text-align:center; margin-left:-3px; font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
			<a href="fee_accounts.php"><img src="images/exam-schedule_white.png" title ="Fee Accounts" style="margin-right:5px;"/>Fee Accounts</a>
		</li>
	</ul>
</div>

<div class="row" style="margin-top: 30px;">
		<div class="col-md-9  text-left" style="font:Arial, Helvetica, sans-serif;font-style:normal;font-size:20px; margin-left:23px; margin-top:-5px;">
			<img src="images/exam-schedule_white.png" style=" font-size:25px;background-color:black;"  title ="Fee Accounts"/>
			 Fee Accounts
		</div>
	</div>

<form method="post">
	<div class="box-body" style="background-color:#fff; padding: 10px; font-family:Arial, Helvetica, sans-serif; font-size:13px; ">
		<div class="clear">
			<div class="form-group col-md-6" style="margin-bottom:1.0%;">
				<div  class="col-md-4  text-right">
					<b style="color:#666666; ">Class</b><span style="color:#FF0000; margin:2px;">*</span>
				</div>
				<div class="col-md-7">  
					<select class="form-control" id="classname" name="classname" style="height:29px; width:295px!important;font-size:12px;" tabindex="2" onchange="classchange()">
							<option selected="selected" value='0'>--Select Class--</option>
						<?php if($class!='0')
								foreach($class as $cls)
								if($_GET['cln']==$cls['class_id'])
								echo "<option  value='".$cls[class_id]."' selected >".$cls[class_name]."</option>";
								else
								echo "<option  value='".$cls[class_id]."' >".$cls[class_name]."</option>";
							?>
					</select>
					
						<div class="col-md-10" id="err_classname" style="color:#990000;margin-left: -13px;margin-top: -11px;"></div>
					 
				</div>
			</div>
		</div>
					
		<div class="clear">
			<div class="form-group col-md-6" style="margin-bottom:1.0%;">
				<div  class="col-md-4  text-right">
					<b style="color:#666666; ">Section</b><span style="color:#FF0000; margin:2px;">*</span>
				</div>
				<div class="col-md-7">  
					<select class="form-control" id="sectionname" name="sectionname" style="height:29px; width:295px!important;font-size:12px;" tabindex="2" onchange="sectionchange()">
							<option value='0'>--Select Section--</option>
							<?php 	if($sections!='0')
								foreach($sections as $sec)
								if($_GET['scn']==$sec['section_id'])
								echo "<option  value='".$sec[section_id]."' selected >".$sec[section_name]."</option>";
								else
								echo "<option  value='".$sec[section_id]."'>".$sec[section_name]."</option>";
							?>
						</select>
						
						<div class="col-md-10" id="err_sectionname" style="color:#990000;margin-left:-13px;margin-top:-11px;"></div>
						 
				</div>
			</div>
		</div>
		
		<div class="clear">
			<div class="form-group col-md-6" style="margin-bottom:1.0%;">
				<div  class="col-md-4  text-right">
					<b style="color:#666666; ">Term</b><span style="color:#FF0000; margin:2px;">*</span>
				</div>
				<div class="col-md-7">  
					<select class="form-control" id="term" name="term" style="height:29px; width:295px!important;font-size:12px;" tabindex="3" onchange="termchange()">
						<option  selected="selected" value='0' >--Select Term--</option>
						<?php if($terms!='0')
							foreach($terms as $term)
							if($term['term_id']==$_GET['trm'])
							{
								echo "<option  value='".$term[term_id]."' selected >".$term[term_name]."</option>";
								$termnam=$term[term_name];
							}
							else
							echo "<option  value='".$term[term_id]."'>".$term[term_name]."</option>";
						?>
					</select>
						
						<div class="col-md-10" id="err_termaname" style="color:#990000;margin-left: -13px;margin-top: -11px;"></div>
						 
						<input type="hidden" value="<?=$termnam?>" name="tname">
				</div>
			</div>
		</div>
		
		
		<div class="clear">
			<div class="form-group col-md-6" style="margin-bottom:1.0%;">
				<div  class="col-md-4  text-right">
					<b style="color:#666666; ">Total No.of Fee Paid:</b>
				</div>
				<div class="col-md-7">
					<?php echo $paidstudents_count;?>
					</div>
			</div>
		</div>		
		
		
		
		<div class="clear">
			<div class="form-group col-md-6" style="margin-bottom:1.0%;">
				<div  class="col-md-4  text-right">
					<b style="color:#666666; ">Total No.of Fee Due:</b>
				</div>
				<div class="col-md-7">
					<?php echo $unpaidstudents_count;?>
					</div>
			</div>
		</div>	
		
		
			
</div>

<div class="col-md-12 text-center" id="err_feeaccounts" style="color:#0F9B0C;"><? if($_GET['act']=='success') echo "Fee Accounts updated successfully";?></div>

<div class="row" style="margin-left:10px;margin-right:10px;">
	<div class="col-md-12 centered" style="font-family: Arial, Helvetica, sans-serif;margin-top:10px;">
		<table id="myTable" class="table table-condensed table-hover" style="margin-top:-10px;">
			<thead>
				<tr class="info">
					<th class="col-md-1 text-center">Student <br/>Roll No</th>
					<th>Student Name</th>
					<th>Amount</th>
					<th>Due Date</th>
					<th>Paid on</th>				
					<th>Status</th>
					<th>Actions</th>
					<th>Reminder</th>
				</tr>
			</thead>
		<tbody>
	<?php if($studentfee!='notfound' && $studentfee!='0')
		foreach($studentfee as $row)
		{
			$s=$row[student_id];						
			if($row[pay_status]=='Paid')
			{
			$t='<label class="radio-inline"><input type="radio" class="dummy" name="paidsts'.$row[student_id].'" value="1" checked>Paid</label>			
				<label class="radio-inline"><input type="radio" class="dummy" name="paidsts'.$row[student_id].'" value="0">Unpaid</label>';
			$_SESSION['fee'][$s]=1;
			$bt='<button type="button" class="btn btn-default"style="font-family:Arial, Helvetica, sans-serif;font-style:normal;font-size:13px;margin: 10px 10px 10px 0px;" disabled>Send Reminder</button>';
			}
			else
			{
			$t='<label class="radio-inline"><input type="radio" class="dummy" name="paidsts'.$row[student_id].'" value="1">Paid</label>			
				<label class="radio-inline"><input type="radio" class="dummy" name="paidsts'.$row[student_id].'" value="0" checked>Unpaid</label>';		
			$_SESSION['fee'][$s]=0;
			$bt='<button type="button" class="btn btn-default"style="font-family:Arial, Helvetica, sans-serif;font-style:normal;font-size:13px;margin: 10px 10px 10px 0px;" onclick="sendfeenote('.$s.')">Send Reminder</button>';
			}
		echo '<tr>
				<td  class="col-sm-1 text-center" style=" font-size:14px;padding-top:16px;">'.$row[student_rollno].'</td>
				<td  style=" font-size:14px;padding-top:16px;">'.$row[student_firstname].' '.$row[student_lastname].'</td>		
				<td  style="font-size:14px;padding-top:16px;"> &#8377; '.number_format($row[term_amount]).'</td>
				<td  style=" font-size:14px;padding-top:16px;">'.$row[due_date].'</td>
				<td  style=" font-size:14px;padding-top:16px;">'.$row[paid_on].'</td>
				<td  style="font-size:14px;padding-top:16px;">'.$row[pay_status].'</td>
				<td  style=" font-size:14px;padding-top:16px;">
				'.$t.'
				<input type="hidden" name="stdid[]" value="'.$row[student_id].'">
				<input type="hidden" name="feeamt" value="'.$row[amount_paid].'">				
				<input type="hidden" name="feeid[]" value="'.$row[student_fee_id].'">					
				</td>
				<td>
				'.$bt.'
				</td>
			</tr>';
			$set=1;
		}?>  
		</tbody>
	</table>
			<input type="hidden" name="trmid" value="<?=$_GET[trm]?>">
			<input type="hidden" name="clnid" value="<?=$_GET[cln]?>">
			<input type="hidden" name="scnid" value="<?=$_GET[scn]?>">	
			<input type="hidden" id="norec" value="<?=$set?>">			
	</div>
</div>

<div class="form-group" style="margin-left:-50px;">
	<div class="col-md-12" align="center">
		<button type="submit" name="termsubmit" class="btn btn-default custom-button-width .navbar-right btnclr"  tabindex="16" style="font-family:Arial, Helvetica, sans-serif;font-style:normal;font-size:13px; margin:10px;" onclick="return fullvalidation();">Submit</button>
	</div>
</div>	  
</form>  
 
 
   <script src="//code.jquery.com/jquery-1.12.0.min.js"></script>
   <script src="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
   <script src="https://cdn.datatables.net/buttons/1.1.2/js/dataTables.buttons.min.js"></script>
   <script src="//cdn.datatables.net/buttons/1.1.2/js/buttons.print.min.js"></script>
   <script src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
   <script src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
   <script src="//cdn.datatables.net/buttons/1.1.2/js/buttons.html5.min.js"></script>
   <script src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
	
	<script type="text/javascript">

$(document).ready(function(){

/*$('#myTable').DataTable({

"pageLength":100,
				
		stateSave: true,
		
		dom: 'T<"clear">lfrtip',	
		
		"oLanguage": { "sSearch": "" },

tableTools: {
					"aButtons": [
					{
					"sExtends": "xls",
					"mColumns": [0, 1, 2, 3, 4, 5]
					},
					{
					"sExtends": "pdf",
					"sPdfOrientation": "landscape",
					 "mColumns": [0, 1, 2, 3, 4, 5]					
					},
					{
					  "sExtends": "print",             
					  "mColumns": [0, 1, 2, 3, 4, 5]
					}
					]
					}
	});
	
	$('div.dataTables_filter input').attr('placeholder', 'Search');
	*/
	var classname=$('#classname').find('option:selected').text();
	var secname=$('#sectionname').find('option:selected').text();
	var tm=$('#term').find('option:selected').text();
	$('#myTable').DataTable( {
        dom: 'B<"clear">lfrtip',
       "iDisplayLength": 100,
       stateSave: true,
       buttons: [
            {
                extend: 'print',
                title: '<center><h3><?php echo $_SESSION['child']['school_name']?></h3></center>',
                message: 'Fee Management<br>Academic Year:<?php echo $_SESSION[child][choosen_year_name]?>&nbsp&nbsp Class:'+classname+'&nbsp&nbsp Section:'+secname+'&nbsp&nbsp Term:'+tm+'<br>',
                exportOptions: {
                    columns: [ 0, 1, 2, 3, 4, 5 ]
                }
            },
            {
                extend: 'pdfHtml5',
                title:'<?php echo $_SESSION['child']['school_name']?>',
                message: 'Fee Management\nAcademic Year:<?php echo $_SESSION[child][choosen_year_name]?>\t Class:'+classname+'\t Section:'+secname+'\t Term:'+tm+'\n',
                exportOptions: {
                    columns: [ 0, 1, 2, 3, 4, 5 ]
                }
            },
            {
				extend: 'excelHtml5',
				title:'<?php echo $_SESSION['child']['school_name']?>',
				 exportOptions: {
                    columns: [ 0, 1, 2, 3, 4, 5 ]
                }
				
			}           
           
        ]
    } );
	});

</script>