|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/vtti.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
include_once('include/config.inc.php');
include_once('include/function.php');
include_once('sendmessage.php');
switch($_REQUEST['do']) {
case "commenacademicyear" :
$Degree = mysqli_escape_string($con,$_REQUEST['Degree']);
$duration = mysqli_escape_string($con,$_REQUEST['duration']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$AcademicTitle = mysqli_escape_string($con,$_REQUEST['AcademicTitle']);
$AcademicStartDate = mysqli_escape_string($con,$_REQUEST['AcademicStartDate']);
$AcademicEndDate = mysqli_escape_string($con,$_REQUEST['AcademicEndDate']);
$currentyear = mysqli_escape_string($con,$_REQUEST['currentyear']);
$check=mysqli_query($con,"insert into commenacademicyear(user_id,degree,academictitle,academicstartdate,academicenddate,
currentyear,duration,status)
values('".$UserID."','".$Degree."','".$AcademicTitle."','".$AcademicStartDate."','".$AcademicEndDate."',
'".$currentyear."','".$duration."','1')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
header("Location:commenacademicyear.php");
break;
case "editcommenacademicyear" :
$Degree = mysqli_escape_string($con,$_REQUEST['Degree']);
$duration = mysqli_escape_string($con,$_REQUEST['duration']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$AcademicTitle = mysqli_escape_string($con,$_REQUEST['AcademicTitle']);
$AcademicStartDate = mysqli_escape_string($con,$_REQUEST['AcademicStartDate']);
$AcademicEndDate = mysqli_escape_string($con,$_REQUEST['AcademicEndDate']);
$currentyear = mysqli_escape_string($con,$_REQUEST['currentyear']);
$check=mysqli_query($con,"update commenacademicyear set user_id='".$UserID."',degree='".$Degree."',
academictitle='".$AcademicTitle."',academicstartdate='".$AcademicStartDate."',academicenddate='".$AcademicEndDate."',
currentyear='".$currentyear."',duration='".$duration."',status='1' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
header("Location:commenacademicyear.php");
break;
case "AddApplicationType" :
$applicationtype = mysqli_escape_string($con,$_REQUEST['applicationtype']);
$applicationdes = mysqli_escape_string($con,$_REQUEST['applicationdes']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update applicationtype set user_id='".$UserID."',name='".$applicationtype."',
description='".$applicationdes."',status='1' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$check=mysqli_query($con,"insert into applicationtype(user_id,name,description,status)
values('".$UserID."','".$applicationtype."','".$applicationdes."','1')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
header("Location:applicationtype.php");
break;
case "feeheadmaster" :
$applicationtype = mysqli_escape_string($con,$_REQUEST['feename']);
$course = mysqli_escape_string($con,$_REQUEST['course']);
$applicationdes = mysqli_escape_string($con,$_REQUEST['amount']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$incomeorexpence = mysqli_escape_string($con,$_REQUEST['incomeorexpence']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update feeheadmaster set user_id='".$UserID."',feename='".$applicationtype."',
amount='".$applicationdes."',status='1',course_id='".$course."',incomeorexpence='".$incomeorexpence."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$check=mysqli_query($con,"insert into feeheadmaster(user_id,feename,amount,course_id,status,incomeorexpence)
values('".$UserID."','".$applicationtype."','".$applicationdes."','".$course."','1','".$incomeorexpence."')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
header("Location:feeheadmaster.php");
break;
case "miscfeemaster" :
$applicationtype = mysqli_escape_string($con,$_REQUEST['feename']);
$applicationdes = mysqli_escape_string($con,$_REQUEST['amount']);
$course = mysqli_escape_string($con,$_REQUEST['course']);
$types = mysqli_escape_string($con,$_REQUEST['types']);
$start = mysqli_escape_string($con,$_REQUEST['start']);
$end = mysqli_escape_string($con,$_REQUEST['end']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$incomeorexpence = mysqli_escape_string($con,$_REQUEST['incomeorexpence']);
if($types=='onetime'){
$start='';
$end='';
}
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update miscfeemaster set user_id='".$UserID."',feemaster='".$applicationtype."',
amount='".$applicationdes."',status='1',course_id='".$course."',incomeorexpence='".$incomeorexpence."',types='".$types."',start='".$start."',end='".$end."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$check=mysqli_query($con,"insert into miscfeemaster(user_id,feemaster,amount,course_id,status,incomeorexpence,types,start,end)
values('".$UserID."','".$applicationtype."','".$applicationdes."','".$course."','1','".$incomeorexpence."','".$types."','".$start."','".$end."')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
// akshay
header("Location:miscfeemaster.php");
break;
case "Setinstallment" :
$studentsid = mysqli_escape_string($con,$_REQUEST['studentsid']);
$numberofinstallment = mysqli_escape_string($con,$_REQUEST['numberofinstallment']);
$installmentdate = $_REQUEST['installmentdate'];
$amount = $_REQUEST['amount'];
$latefine = $_REQUEST['latefine'];
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$student_id = mysqli_escape_string($con,$_REQUEST['student_id']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update miscfeemaster set user_id='".$UserID."',feemaster='".$applicationtype."',
amount='".$applicationdes."',status='1',course_id='".$course."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
for($i=1; $i<=$numberofinstallment; $i++){
$check=mysqli_query($con,"insert into setinstallment(studentid,user_id,numberofinstallment,
installmentdate,amount,latefine,admissiontype)
values('".$studentsid."','".$UserID."','".$numberofinstallment."','".$installmentdate[$i]."',
'".$amount[$i]."','".$latefine[$i]."','".$student_id."')");
}
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
header("Location:setinstallmentreports.php");
break;
case "DirectSetinstallment" :
$studentsid = mysqli_escape_string($con,$_REQUEST['studentsid']);
$numberofinstallment = mysqli_escape_string($con,$_REQUEST['numberofinstallment']);
$installmentdate = $_REQUEST['installmentdate'];
$amount = $_REQUEST['amount'];
$latefine = $_REQUEST['latefine'];
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$student_id = mysqli_escape_string($con,$_REQUEST['student_id']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update miscfeemaster set user_id='".$UserID."',feemaster='".$applicationtype."',
amount='".$applicationdes."',status='1',course_id='".$course."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
for($i=1; $i<=$numberofinstallment; $i++){
$check=mysqli_query($con,"insert into directsetinstallment(studentid,user_id,numberofinstallment,
installmentdate,amount,latefine,student_id)
values('".$studentsid."','".$UserID."','".$numberofinstallment."','".$installmentdate[$i]."',
'".$amount[$i]."','".$latefine[$i]."','".$student_id."')");
}
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
header("Location:directadmissionsetinstallmentreports.php");
break;
case "EditSetInstallment" :
$installmentdate = $_REQUEST['installmentdate'];
$amount = $_REQUEST['amount'];
$latefine = $_REQUEST['latefine'];
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update setinstallment set user_id='".$UserID."',installmentdate='".$installmentdate."',
amount='".$amount."',latefine='".$latefine."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}
header("Location:setinstallmentreports.php");
break;
case "EditDirectSetInstallment" :
$installmentdate = $_REQUEST['installmentdate'];
$amount = $_REQUEST['amount'];
$latefine = $_REQUEST['latefine'];
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update directsetinstallment set user_id='".$UserID."',installmentdate='".$installmentdate."',
amount='".$amount."',latefine='".$latefine."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}
header("Location:directadmissionsetinstallmentreports.php");
break;
case "PaySetInstallment" :
$doid1 = mysqli_escape_string($con,$_REQUEST['doid1']);
$enquiry_id = mysqli_escape_string($con,$_REQUEST['enquiry_id']);
$payment_amount = mysqli_escape_string($con,$_REQUEST['payment_amount']);
$lastpaymentdate = mysqli_escape_string($con,$_REQUEST['lastpaymentdate']);
$payment_mode = mysqli_escape_string($con,$_REQUEST['payment_mode']);
$fine = mysqli_escape_string($con,$_REQUEST['fine']);
$payment_date = mysqli_escape_string($con,$_REQUEST['payment_date']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$tableid = mysqli_escape_string($con,$_REQUEST['tableid']);
$POSTransaction = mysqli_escape_string($con,$_REQUEST['POSTransaction']);
$DdNo = mysqli_escape_string($con,$_REQUEST['DdNo']);
$bank = mysqli_escape_string($con,$_REQUEST['bank']);
$checkno = mysqli_escape_string($con,$_REQUEST['checkno']);
$bank_name = mysqli_escape_string($con,$_REQUEST['bank_name']);
$check=mysqli_query($con,"insert into payinstallment(user_id,installment_id,enquiry_id,payment_date
,payment_amount,fine,payment_mode,lastpaymentdate,bank,bank_name,checkno,approve,POSTransaction,DdNo)
values('".$UserID."','".$doid1."','".$enquiry_id."','".$payment_date."','".$payment_amount."'
,'".$fine."','".$payment_mode."','".$lastpaymentdate."','".$bank."','".$bank_name."','".$checkno."',0,'".$POSTransaction."',
'".$DdNo."')");
$last_id=$con->insert_id;
if($check){
if($payment_mode=="Cheque"){
$chequequery=mysqli_query($con,"insert into checktransaction (user_id,sem_no,student_id,approve,cheque_for,amount,
bank_id,bank_name,checkno) values ('".$UserID."',1,'".$last_id."','0','installment','".$payment_amount."','".$bank_name."',
'".$bank."','".$checkno."')");
}
$collage=mysqli_query($con,"select * from admission_enquiry_form where
student_id='".$enquiry_id."'");
$collage=mysqli_fetch_array($collage);
$smss="DEAR ".$collage['name']." CONGRATULATION YOUR INSTALLMENT OF RUPEES ".$payment_amount." HAS BEEN PAID SUCCESSFULLY.";
sendsms($con,$collage['mobileno'],$smss);
$_SESSION['msg']=' Payment Add Successfully .';
}else{
$_SESSION['msg']='Payment Not Add Failed! ';
}
$last_id = $con->insert_id;
$payment=mysqli_query($con,"Select SUM(payment_amount) as payment_amount,SUM(fine) as fine from payinstallment where enquiry_id='".$enquiry_id."'");
$payment=mysqli_fetch_assoc($payment);
$payment_amount=$payment['payment_amount'];
$fine=$payment['fine'];
mysqli_query($con,"update admission_enquiry_form set installmentamount='".$payment_amount."',
latefine='".$fine."' where student_id='".$enquiry_id."'");
$stu_data=mysqli_query($con,"Select * from admission_enquiry_form where student_id='".$enquiry_id."'");
$stu_data=mysqli_fetch_assoc($stu_data);
$totalamoutss=$stu_data['bookingamount']+$stu_data['submitfee']+$stu_data['installmentamount']+$stu_data['lessdiscount'];
$totalamou=$stu_data['totalfee']-$totalamoutss;
/*$totalamou=$totalamoutss-$stu_data['lessdiscount'];
echo "bookingamount".$stu_data['bookingamount']."<br/>";
echo "Total".$stu_data['totalfee']."<br/>";
echo "Submitfee".$stu_data['submitfee']."<br/>";
echo "Installmentamount".$stu_data['installmentamount']."<br/>";
echo "Lessdiscount".$stu_data['lessdiscount']."<br/>";
exit; */
if($totalamou<=0){
mysqli_query($con,"update admission_enquiry_form set dueamount='".$totalamou."',feestatus='0' where student_id='".$enquiry_id."'");
}else{
mysqli_query($con,"update admission_enquiry_form set dueamount='".$totalamou."' where student_id='".$enquiry_id."'");
}
header("Location:setinstallmentspecificreport.php?upid=".$enquiry_id);
break;
case "directPaySetInstallment" :
$doid1 = mysqli_escape_string($con,$_REQUEST['doid1']);
$enquiry_id = mysqli_escape_string($con,$_REQUEST['enquiry_id']);
$payment_amount = mysqli_escape_string($con,$_REQUEST['payment_amount']);
$lastpaymentdate = mysqli_escape_string($con,$_REQUEST['lastpaymentdate']);
$payment_mode = mysqli_escape_string($con,$_REQUEST['payment_mode']);
$fine = mysqli_escape_string($con,$_REQUEST['fine']);
$payment_date = mysqli_escape_string($con,$_REQUEST['payment_date']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$check=mysqli_query($con,"insert into directpayinstallment(user_id,installment_id,enquiry_id,payment_date
,payment_amount,fine,payment_mode,lastpaymentdate)
values('".$UserID."','".$doid1."','".$enquiry_id."','".$payment_date."','".$payment_amount."'
,'".$fine."','".$payment_mode."','".$lastpaymentdate."')");
if($check){
$_SESSION['msg']=' Payment Add Successfully .';
}else{
$_SESSION['msg']='Payment Not Add Failed! ';
}
$last_id = $con->insert_id;
$payment=mysqli_query($con,"Select SUM(payment_amount) as payment_amount,SUM(fine) as fine from directpayinstallment where enquiry_id='".$enquiry_id."'");
$payment=mysqli_fetch_assoc($payment);
$payment_amount=$payment['payment_amount'];
$fine=$payment['fine'];
mysqli_query($con,"update direct_admission set installmentamount='".$payment_amount."',
latefine='".$fine."' where student_id='".$enquiry_id."'");
header("Location:directadmissionsetinstallmentreports.php");
break;
case "Menu" :
$menu = mysqli_escape_string($con,$_REQUEST['menu']);
$UserID = mysqli_escape_string($con,$_REQUEST['EntryUser']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update menu set menuname='".$menu."'
where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$check=mysqli_query($con,"insert into menu(user_id,menuname)
values('".$UserID."','".$menu."')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
header("Location:addmenu.php");
break;
case "usercreate" :
$name = mysqli_escape_string($con,$_REQUEST['name']);
$username = mysqli_escape_string($con,$_REQUEST['username']);
$email = mysqli_escape_string($con,$_REQUEST['email']);
$password = mysqli_escape_string($con,$_REQUEST['password']);
$password=md5($password);
$mobile = mysqli_escape_string($con,$_REQUEST['mobile']);
$role = mysqli_escape_string($con,$_REQUEST['role']);
$per = $_REQUEST['per'];
$menu=implode(',',$per);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
if(!empty($_REQUEST['doid'])){
$check=mysqli_query($con,"update admin set menuper='".$menu."',mobile='".$mobile."'
,mobile='".$mobile."',name='".$name."',user_id='".$UserID."',role='".$role."' where id=".(int)$_REQUEST['doid']);
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$upuserresult=mysqli_query($con,"select * from admin where email='".$email."' or username='".$username."' ");
$row=mysqli_num_rows($upuserresult);
if($row>0){
$_SESSION['msg']='Email Id Allready Exits ! ';
}else{
$check=mysqli_query($con,"insert into admin(password,username,email,role,mobile,menuper,name,user_id)
values('".$password."','".$username."','".$email."','".$role."',
'".$mobile."','".$menu."','".$name."','".$UserID."')");
if($check){
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
}
header("Location:usersreports.php");
break;
case "ConsultantPayForm" :
$consultant_id = mysqli_escape_string($con,$_REQUEST['consultant_id']);
$student_id = mysqli_escape_string($con,$_REQUEST['student_id']);
$pay = mysqli_escape_string($con,$_REQUEST['pay']);
$totalamount = mysqli_escape_string($con,$_REQUEST['totalamount']);
$payment_mode = mysqli_escape_string($con,$_REQUEST['payment_mode']);
$editid = mysqli_escape_string($con,$_REQUEST['editid']);
$doid = mysqli_escape_string($con,$_REQUEST['doid']);
$editdata = mysqli_escape_string($con,$_REQUEST['editdata']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$mobileno=mysqli_query($con,"select * from consultants
where id='".$consultant_id."'");
$mobileno=mysqli_fetch_assoc($mobileno);
$phone=$mobileno['phone'];
$names=$mobileno['name'];
if($editdata==1){
$check=mysqli_query($con,"update installment_consultants_payments
set submitamount='".$pay."',paymentmode='".$payment_mode."'
where id=".(int)$_REQUEST['doid']);
if($check){
$message="DEAR ".$names.'COMMISSION OF RUPEES'.$pay. 'HAS BEEN UPDATE PAYMENT TO YOU.';
sendsms($con,$phone,$message);
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
}else{
$check=mysqli_query($con,"insert into installment_consultants_payments
(user_id,student_id,submitamount,paymentmode,consultants_id,con_payments)
values('".$UserID."','".$student_id."','".$pay."','".$payment_mode."','".$consultant_id."'
,'".$doid."')");
if($check){
$message="DEAR ".$names.'COMMISSION OF RUPEES'.$pay. 'HAS BEEN CREDITED TO YOU.';
sendsms($con,$phone,$message);
$_SESSION['msg']=' Record Add Successfully .';
}else{
$_SESSION['msg']='Record Not Add Failed! ';
}
}
$subamount=mysqli_query($con,"select sum(submitamount) as submitamount from installment_consultants_payments
where student_id='".$_REQUEST['student_id']."'");
$subamount=mysqli_fetch_assoc($subamount);
$totalamounnts=mysqli_query($con,"select totalamount from consultants_payments
where student_id='".$_REQUEST['student_id']."'");
$totalamounnts=mysqli_fetch_assoc($totalamounnts);
$amounts=$totalamounnts['totalamount']-$subamount['submitamount'];
mysqli_query($con,"update consultants_payments
set due='".$amounts."',paid='".$subamount['submitamount']."'
where student_id='".$_REQUEST['student_id']."'");
header("Location:consultantpaymentreports.php");
break;
case "PayMiscFee" :
$studentsid = mysqli_escape_string($con,$_REQUEST['student_id']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
$commonacayear = mysqli_escape_string($con,$_REQUEST['commonacayear']);
$numberofinstallment =$_REQUEST['paymiscf'];
$numberofinstallmentone =$_REQUEST['paymisc'];
$startdate =$_REQUEST['startdate'];
//$startdate =date_format($_REQUEST['startdate'],"Y-m-d"); //your given date
$misc=implode(',',$numberofinstallment);
//var_dump($numberofinstallment);
$amount=0;
$countsone=count($numberofinstallmentone);
$counts=count($numberofinstallment);
//echo $counts;
$commonacayear=mysqli_query($con,"select * from commenacademicyear where id='".$commonacayear."' ");
$commonacayear=mysqli_fetch_assoc($commonacayear);
//print_r($startdate).'<br>';
//$days = ceil(abs( strtotime('2000-01-25') - strtotime('2000-02-20') ) / 86400);
//echo $months = $days/30;
$totalmiscfeemonthlytotalfee=0;
$checkrownum=mysqli_query($con,"select * from addmiscfeeparticular where student_id='".$studentsid."' ");
$checkrownum=mysqli_num_rows($checkrownum);
for($i=0; $i<$counts; $i++){
// echo $numberofinstallment[$i];
$totalamount=0;
$upuserresult=mysqli_query($con,"select amount from miscfeemaster where id='".$numberofinstallment[$i]."' ");
$datas=mysqli_fetch_assoc($upuserresult);
$start = (new DateTime($startdate[$i]))->modify('first day of this month');
$end = (new DateTime($commonacayear['academicenddate']))->modify('first day of next month');
$interval = DateInterval::createFromDateString('1 month');
$period = new DatePeriod($start, $interval, $end);
$motntscount=0;
foreach ($period as $dt) {
$motntscount++;
}
// echo $motntscount;
$oneday=0;
$oneday=$oneday*$sub_struct_days;
$monthlyamount=$datas['amount']*$motntscount;
//echo $monthlyamount;
$totalamount +=$oneday+$monthlyamount;
$totalamount=round($totalamount, 0);
$totalmiscfeemonthlytotalfee +=$totalamount;
if($checkrownum==0){
$check=mysqli_query($con,"insert into addmiscfeeparticular(user_id,student_id,feename,amount,dates,feemasterid,enddate,totalamount,months,days) values(
'".$UserID."','".$studentsid."','".$datas['feemaster']."','".$datas['amount']."','".$startdate[$i]."','".$numberofinstallment[$i]."','".$commonacayear['academicenddate']."','".$totalamount."','".$motntscount."','0')");
}
}
for($i=0; $i<$countsone; $i++){
//echo 1;
$upuserresult=mysqli_query($con,"select amount from miscfeemaster where id='".$numberofinstallment[$i]."' ");
$datas=mysqli_fetch_assoc($upuserresult);
$amount =$amount+$datas['amount'];
}
/*
$upuserresulto=mysqli_query($con,"select totalfee,miscfeetotal from admission_enquiry_form where
student_id='".$studentsid."' ");
$dataso=mysqli_fetch_assoc($upuserresulto);
$newamount=$dataso['totalfee']-$dataso['miscfeetotal'];
$nou=$newamount+$amount;
*/
$check=mysqli_query($con,"update admission_enquiry_form set
miscfeemonthlytotalfee='".$totalmiscfeemonthlytotalfee."', duemiscfeemonthlytotalfee='".$totalmiscfeemonthlytotalfee."' where student_id='".$studentsid."'");
//$check=mysqli_query($con,"update admission_enquiry_form set totalfee='".$nou."'
// where student_id='".$studentsid."'");
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
header("Location:setinstallmentreports.php");
break;
case "PaidMiscFee" :
$studentsid = mysqli_escape_string($con,$_REQUEST['student_id']);
$amount = mysqli_escape_string($con,$_REQUEST['amount']);
$paymentmode = mysqli_escape_string($con,$_REQUEST['paymentmode']);
$bank_name = mysqli_escape_string($con,$_REQUEST['bank_name']);
$checkno = mysqli_escape_string($con,$_REQUEST['checkno']);
$bank = mysqli_escape_string($con,$_REQUEST['bank']);
$monthly = mysqli_escape_string($con,$_REQUEST['monthly']);
$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
if($monthly=='monthly'){
$upuserresulto=mysqli_query($con,"select totalfee,miscfeemonthlytotalfee from admission_enquiry_form where
student_id='".$studentsid."' ");
$dataso=mysqli_fetch_assoc($upuserresulto);
$check=mysqli_query($con,"insert into paymiscfee (user_id,student_id,amount,payment_mode,bank,bank_name,checkno,types) values(
'".$UserID."','".$studentsid."','".$amount."','".$paymentmode."','".$bank."','".$bank_name."','".$checkno."','".$monthly."')");
$inamounts=mysqli_query($con,"select amount from paymiscfee where
student_id='".$studentsid."' and types='".$monthly."' ");
$sumamount=0;
while($inamountso=mysqli_fetch_assoc($inamounts)){
$sumamount=$sumamount+$inamountso['amount'];
}
$newamount=$dataso['miscfeemonthlytotalfee']-$sumamount;
$check=mysqli_query($con,"update admission_enquiry_form set duemiscfeemonthlytotalfee='".$newamount."'
where student_id='".$studentsid."'");
}else{
$upuserresulto=mysqli_query($con,"select totalfee,miscfeetotal from admission_enquiry_form where
student_id='".$studentsid."' ");
$dataso=mysqli_fetch_assoc($upuserresulto);
$check=mysqli_query($con,"insert into paymiscfee (user_id,student_id,amount,payment_mode,bank,bank_name,checkno) values(
'".$UserID."','".$studentsid."','".$amount."','".$paymentmode."','".$bank."','".$bank_name."','".$checkno."')");
$inamounts=mysqli_query($con,"select amount from paymiscfee where
student_id='".$studentsid."' ");
$sumamount=0;
while($inamountso=mysqli_fetch_assoc($inamounts)){
$sumamount=$sumamount+$inamountso['amount'];
}
$newamount=$dataso['miscfeetotal']-$sumamount;
$check=mysqli_query($con,"update admission_enquiry_form set duemiscfee='".$newamount."'
where student_id='".$studentsid."'");
}
if($check){
$_SESSION['msg']=' Record Updated Successfully .';
}else{
$_SESSION['msg']='Record Not Updated Failed! ';
}
header("Location:allmiscfeerecipts.php");
break;
}