/home3/vehiclea/public_html/admin-appleiitfoundationschools-com/fee_payment21092022.php
<?php
include('include/include.php');
if($_POST['type']==1)
{
$select_study_data = executework("SELECT * FROM student_fee where class = '".$_POST['PresentClass']."' and yearOf = '".$_POST['Academic_year']."' and admission_no = '".$_POST['AdmissionNo']."' order by id desc limit 1");
if(mysqli_num_rows($select_study_data)>0){
$row_study = mysqli_fetch_array($select_study_data);
$dueamount = $row_study['due_amount']-$_POST['amount_data'];
$paid_amount = $row_study['paid_amount']+$_POST['amount_data'];
}
else
{
$dueamount = $_POST['study_amount']-$_POST['amount_data'];
$paid_amount = $_POST['amount_data'];
}
$student = executework("SELECT * FROM student_fee order by id desc LIMIT 1");
$addNostudent = mysqli_fetch_array($student);
$year = substr($addNostudent['yearOf'],5);
$code = $addNostudent['branch'];
$invoice1 = $addNostudent['invoice'];
if($invoice1 > 0)
{
$invoicevalue1 = (int) $invoice1 + 1;
$val = sprintf('%03d', $invoicevalue1);
$student_invoice = $year.$code.'-'.$val;
}
else {
$invoicevalue1 = "1";
$val = sprintf('%03d', $invoicevalue1);
$student_invoice = $year.$code.'-'.$val;
}
$insert_study = executeworkins("insert into student_fee (class,rollno,branch,studytotal_amount,syllabus,due_amount,paid_amount,fee_date,paid_studyAmount,create_date,admission_no,yearOf,category,invoice,paid_by) values ('".$_POST['PresentClass']."','".$_POST['RollNo']."','".$_POST['Branch']."','".$_POST['study_amount']."','".$_POST['syllabus']."','".$dueamount."','".$paid_amount."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".$_POST['amount_data']."','".date('Y-m-d H:i:s')."','".$_POST['AdmissionNo']."', '".$_POST['Academic_year']."','".$_POST['category']."','$student_invoice','".$_POST['paid_by']."') ");
if(!empty($insert_study)){
$addNo = executework("SELECT * FROM daybook_credt order by id desc LIMIT 1");
$addNoData = mysqli_fetch_array($addNo);
$year = substr($_POST['Academic_year'],5);
$code = $_POST['Branch'];
$addmissNo = $addNoData['VocherNumber'];
if($addmissNo > 0)
{
$value = (int) $addmissNo + 1;
$val = sprintf('%03d', $value);
}
else {
$value = "1";
$val = sprintf('%03d', $value);
}
$insert_credit = executework("insert into daybook_credt (academicYear,branch_name,category_name,amount,date,create_date,VocherNumber) values ('".$_POST['Academic_year']."','".$_POST['Branch']."','".$_POST['category']."','".$_POST['amount_data']."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".date('Y-m-d H:i:s')."','$val') ");
}
echo $insert_study;
}
if($_POST['type']==2)
{
$select_study_data = executework("SELECT * FROM hostel_payment where class = '".$_POST['PresentClass']."' and yearOf = '".$_POST['Academic_year']."' and admission_no = '".$_POST['AdmissionNo']."' order by id desc limit 1");
if(mysqli_num_rows($select_study_data)>0){
$row_study = mysqli_fetch_array($select_study_data);
$dueamount = $row_study['due_amount']-$_POST['HostelAmt'];
$paid_amount = $row_study['paid_amount']+$_POST['HostelAmt'];
}
else
{
$dueamount = $_POST['HostelTotalAmt']-$_POST['HostelAmt'];
$paid_amount = $_POST['HostelAmt'];
}
$hostel = executework("SELECT * FROM hostel_payment order by id desc LIMIT 1");
$addNohostel = mysqli_fetch_array($hostel);
$year = substr($addNohostel['yearOf'],5);
$code = $addNohostel['branch'];
$invoice1 = $addNohostel['invoice'];
if($invoice1 > 0)
{
$invoicevalue1 = (int) $invoice1 + 1;
$val = sprintf('%03d', $invoicevalue1);
$hostel_invoice = $year.$code.'-'.$val;
}
else {
$invoicevalue1 = "1";
$val = sprintf('%03d', $invoicevalue1);
$hostel_invoice = $year.$code.'-'.$val;
}
$insert_hostel = executeworkins("insert into hostel_payment (class,rollno,branch,hostel_total,syllabus,due_amount,paid_amount,fee_date,paid_hostelAmount,create_date,admission_no,yearOf,category,invoice,paid_by) values ('".$_POST['PresentClass']."','".$_POST['RollNo']."','".$_POST['Branch']."','".$_POST['HostelTotalAmt']."','".$_POST['syllabus']."','".$dueamount."','".$paid_amount."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".$_POST['HostelAmt']."','".date('Y-m-d H:i:s')."','".$_POST['AdmissionNo']."', '".$_POST['Academic_year']."','".$_POST['category4']."','$hostel_invoice','".$_POST['Hostelpaid_by']."') ");
if(!empty($insert_hostel)){
$addNo = executework("SELECT * FROM daybook_credt order by id desc LIMIT 1");
$addNoData = mysqli_fetch_array($addNo);
$year = substr($_POST['Academic_year'],5);
$code = $_POST['Branch'];
$addmissNo = $addNoData['VocherNumber'];
if($addmissNo > 0)
{
$value = (int) $addmissNo + 1;
$val = sprintf('%03d', $value);
}
else {
$value = "1";
$val = sprintf('%03d', $value);
}
$insert_hostel_credit = executework("insert into daybook_credt (academicYear,branch_name,category_name,amount,date,create_date,VocherNumber,category_name) values ('".$_POST['Academic_year']."','".$_POST['Branch']."','".$_POST['category4']."','".$_POST['HostelAmt']."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".date('Y-m-d H:i:s')."','$val') ");
}
echo $insert_hostel;
}
if($_POST['type']==3)
{
$select_study_data = executework("SELECT * FROM additional_fee where class = '".$_POST['PresentClass']."' and yearOf = '".$_POST['Academic_year']."' and admission_no = '".$_POST['AdmissionNo']."' order by id desc limit 1");
if(mysqli_num_rows($select_study_data)>0){
$row_study = mysqli_fetch_array($select_study_data);
$dueamount = $row_study['due_amount']-$_POST['AddAmt'];
$paid_amount = $row_study['paid_amount']+$_POST['AddAmt'];
}
else
{
$dueamount = $_POST['Additional_amount']-$_POST['AddAmt'];
$paid_amount = $_POST['AddAmt'];
}
$student = executework("SELECT * FROM additional_fee order by id desc LIMIT 1");
$addNoadditional = mysqli_fetch_array($student);
$year = substr($addNoadditional['yearOf'],5);
$code = $addNoadditional['branch'];
$invoice1 = $addNoadditional['invoice'];
if($invoice1 > 0)
{
$invoicevalue1 = (int) $invoice1 + 1;
$val = sprintf('%03d', $invoicevalue1);
$additional_invoice = $year.$code.'-'.$val;
}
else {
$invoicevalue1 = "1";
$val = sprintf('%03d', $invoicevalue1);
$additional_invoice = $year.$code.'-'.$val;
}
$insert_add = executeworkins("insert into additional_fee (class,rollno,branch,addtotal_amount,syllabus,due_amount,paid_amount,fee_date,paid_addAmount,create_date,admission_no,yearOf,category,invoice,paid_by) values ('".$_POST['PresentClass']."','".$_POST['RollNo']."','".$_POST['Branch']."','".$_POST['Additional_amount']."','".$_POST['syllabus']."','".$dueamount."','".$paid_amount."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".$_POST['AddAmt']."','".date('Y-m-d H:i:s')."','".$_POST['AdmissionNo']."', '".$_POST['Academic_year']."','".$_POST['category3']."','$additional_invoice','".$_POST['Additionalpaid_by']."') ");
if(!empty($insert_add)){
$addNo = executework("SELECT * FROM daybook_credt order by id desc LIMIT 1");
$addNoData = mysqli_fetch_array($addNo);
$year = substr($_POST['Academic_year'],5);
$code = $_POST['Branch'];
$addmissNo = $addNoData['VocherNumber'];
if($addmissNo > 0)
{
$value = (int) $addmissNo + 1;
$val = sprintf('%03d', $value);
}
else {
$value = "1";
$val = sprintf('%03d', $value);
}
$insert_add_credit = executework("insert into daybook_credt (academicYear,branch_name,category_name,amount,date,create_date,VocherNumber) values ('".$_POST['Academic_year']."','".$_POST['Branch']."','".$_POST['category3']."','".$_POST['AddAmt']."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".date('Y-m-d H:i:s')."','$val') ");
}
echo $insert_add;
}
if($_POST['type']==4)
{
$select_study_data = executework("SELECT * FROM bus_payment where class = '".$_POST['PresentClass']."' and yearOf = '".$_POST['Academic_year']."' and admission_no = '".$_POST['AdmissionNo']."' order by id desc limit 1");
if(mysqli_num_rows($select_study_data)>0){
$row_study = mysqli_fetch_array($select_study_data);
$dueamount = $row_study['due_amount']-$_POST['BusAmt'];
$paid_amount = $row_study['paid_amount']+$_POST['BusAmt'];
}
else
{
$dueamount = $_POST['BusTotalAmt']-$_POST['BusAmt'];
$paid_amount = $_POST['BusAmt'];
}
$student = executework("SELECT * FROM bus_payment order by id desc LIMIT 1");
$addNobus = mysqli_fetch_array($student);
$year = substr($addNobus['yearOf'],5);
$code = $addNobus['branch'];
$invoice1 = $addNobus['invoice'];
if($invoice1 > 0)
{
$invoicevalue1 = (int) $invoice1 + 1;
$val = sprintf('%03d', $invoicevalue1);
$bus_invoice = $year.$code.'-'.$val;
}
else {
$invoicevalue1 = "1";
$val = sprintf('%03d', $invoicevalue1);
$bus_invoice = $year.$code.'-'.$val;
}
$insert_bus = executeworkins("insert into bus_payment (class,rollno,branch,bustotal_amount,syllabus,due_amount,paid_amount,fee_date,paid_busAmount,create_date,admission_no,yearOf,category,invoice,paid_by) values ('".$_POST['PresentClass']."','".$_POST['RollNo']."','".$_POST['Branch']."','".$_POST['BusTotalAmt']."','".$_POST['syllabus']."','".$dueamount."','".$paid_amount."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".$_POST['BusAmt']."','".date('Y-m-d H:i:s')."','".$_POST['AdmissionNo']."', '".$_POST['Academic_year']."','".$_POST['category1']."','$bus_invoice','".$_POST['Buspaid_by']."') ");
if($insert_bus){
$addNo = executework("SELECT * FROM daybook_credt order by id desc LIMIT 1");
$addNoData = mysqli_fetch_array($addNo);
$year = substr($_POST['Academic_year'],5);
$code = $_POST['Branch'];
$addmissNo = $addNoData['VocherNumber'];
if($addmissNo > 0)
{
$value = (int) $addmissNo + 1;
$val = sprintf('%03d', $value);
}
else {
$value = "1";
$val = sprintf('%03d', $value);
}
$bus_day_book = executework("insert into daybook_credt (academicYear,branch_name,category_name,amount,date,create_date,VocherNumber,category_name) values ('".$_POST['Academic_year']."','".$_POST['Branch']."','".$_POST['category1']."','".$_POST['BusAmt']."','".date('Y-m-d',strtotime($_POST['fee_date']))."','".date('Y-m-d H:i:s')."','$val')");
}
}
if($_POST['type']==5)
{
$select_study = executework("SELECT * FROM student_fee where admission_no='".$_POST['AdmissionNo']."' and yearOf = '".$_POST['Academic_year']."'");
$output .= '<div class="table-responsive">
<table class="table table-bordered">
<tr>
<th>S.No</th>
<th>Invoice</th>
<th>Total Amount</th>
<th>Due Amount</th>
<th>Paid Amount</th>
<th>Payment Date</th>
<th>Paid By</th>
<th>Action</th>
</tr>';
$i=1;
while($studyData = mysqli_fetch_array($select_study)){
$branch = $studyData['branch'];
$year = substr($studyData['yearOf'],5);
$category = substr($studyData['category'],0,5);
$invoice = $studyData['invoice'];
$invoice_value = $year.$branch.'-'.$category.'-'.$invoice;
$output .= '<tr>
<td>'.$i.'</td>
<td>'.$invoice_value.'</td>
<td>'.$studyData['studytotal_amount'].'</td>
<td>'.$studyData['due_amount'].'</td>
<td>'.$studyData['paid_studyAmount'].'</td>
<td>'.strtoupper($studyData['paid_by']).'</td>
<td>'.date('M-d-Y',strtotime($studyData['fee_date'])).'</td>
<td><a href="pdf_genartion.php?id='.$studyData['id'].'" class="btn btn-success" target="_blank">Print</a></td>
</tr>';
$i++;
}
echo $output;
}
if($_POST['type']==6)
{
$select_study = executework("SELECT * FROM bus_payment where admission_no='".$_POST['AdmissionNo']."' and yearOf = '".$_POST['Academic_year']."'");
$output .= '<div class="table-responsive">
<table class="table table-bordered">
<tr>
<th>S.No</th>
<th>Invoice</th>
<th>Total Amount</th>
<th>Due Amount</th>
<th>Paid Amount</th>
<th>Payment Date</th>
<th>Paid By</th>
<th>Action</th>
</tr>';
$i=1;
while($studyData = mysqli_fetch_array($select_study)){
$branch = $studyData['branch'];
$year = substr($studyData['yearOf'],5);
$category = substr($studyData['category'],0,5);
$invoice = $studyData['invoice'];
$invoice_value = $year.$branch.'-'.$category.'-'.$invoice;
$output .= '<tr>
<td>'.$i.'</td>
<td>'.$invoice_value.'</td>
<td>'.$studyData['bustotal_amount'].'</td>
<td>'.$studyData['due_amount'].'</td>
<td>'.$studyData['paid_busAmount'].'</td>
<td>'.date('M-d-Y',strtotime($studyData['fee_date'])).'</td>
<td>'.strtoupper($studyData['paid_by']).'</td>
<td><a href="bus_pdf.php?id='.$studyData['id'].'" class="btn btn-success" target="_blank">Print</a></td>
</tr>';
$i++;
}
echo $output;
}
if($_POST['type']==7)
{
$select_study = executework("SELECT * FROM additional_fee where admission_no='".$_POST['AdmissionNo']."' and yearOf = '".$_POST['Academic_year']."'");
$output .= '<div class="table-responsive">
<table class="table table-bordered">
<tr>
<th>S.No</th>
<th>Invoice</th>
<th>Total Amount</th>
<th>Due Amount</th>
<th>Paid Amount</th>
<th>Payment Date</th>
<th>Paid By</th>
<th>Action</th>
</tr>';
$i=1;
while($studyData = mysqli_fetch_array($select_study)){
$branch = $studyData['branch'];
$year = substr($studyData['yearOf'],5);
$category = substr($studyData['category'],0,5);
$invoice = $studyData['invoice'];
$invoice_value = $year.$branch.'-'.$category.'-'.$invoice;
$output .= '<tr>
<td>'.$i.'</td>
<td>'.$invoice_value.'</td>
<td>'.$studyData['addtotal_amount'].'</td>
<td>'.$studyData['due_amount'].'</td>
<td>'.$studyData['paid_addAmount'].'</td>
<td>'.date('M-d-Y',strtotime($studyData['fee_date'])).'</td>
<td>'.strtoupper($studyData['paid_by']).'</td>
<td><a href="additional_pdf.php?id='.$studyData['id'].'" class="btn btn-success" target="_blank">Print</a></td>
</tr>';
$i++;
}
echo $output;
}
if($_POST['type']==8)
{
$select_study = executework("SELECT * FROM hostel_payment where admission_no='".$_POST['AdmissionNo']."' and yearOf = '".$_POST['Academic_year']."'");
$output .= '<div class="table-responsive">
<table class="table table-bordered">
<tr>
<th>S.No</th>
<th>Invoice</th>
<th>Total Amount</th>
<th>Due Amount</th>
<th>Paid Amount</th>
<th>Payment Date</th>
<th>Paid By</th>
<th>Action</th>
</tr>';
$i=1;
while($studyData = mysqli_fetch_array($select_study)){
$branch = $studyData['branch'];
$year = substr($studyData['yearOf'],5);
$category = substr($studyData['category'],0,5);
$invoice = $studyData['invoice'];
$invoice_value = $year.$branch.'-'.$category.'-'.$invoice;
$output .= '<tr>
<td>'.$i.'</td>
<td>'.$invoice_value.'</td>
<td>'.$studyData['hostel_total'].'</td>
<td>'.$studyData['due_amount'].'</td>
<td>'.$studyData['paid_hostelAmount'].'</td>
<td>'.date('M-d-Y',strtotime($studyData['fee_date'])).'</td>
<td>'.$studyData['paid_by'].'</td>
<td><a href="hostel_pdf.php?id='.$studyData['id'].'" class="btn btn-success" target="_blank">Print</a></td>
</tr>';
$i++;
}
echo $output;
}
?>
@LwBee Strong Bypass
Upload File
Create New File