/home3/vehiclea/public_html/admin-appleiitfoundationschools-com/student_data.php
<?php
include('include/include.php');
if($_POST['type'] == 1){
$admissionNo = $_POST['admission'];
$syllabus = $_POST['syllabus'];
$addCustData = executework("SELECT * FROM student_registration where StudentName like '%".$admissionNo."%' and syllabus = '".$syllabus."' limit 0,5");
$addCust_arr = array();
while($data = mysqli_fetch_assoc($addCustData)){
$id = $data['id'];
$AdmissionNo = $data['StudentName'];
$addCust_arr[] = array("id" => $id, "AdmissionNo" => $AdmissionNo);
}
echo json_encode($addCust_arr);
}
if($_POST['type'] == 2){
$keyid = $_POST['keyid'];
$admission = executework ("select * from student_registration where id = '". $keyid."'");
$row = mysqli_fetch_array($admission);
$select_study = executework("select invoice from student_fee order by id desc limit 1 ");
if(mysqli_num_rows($select_study)>0)
{
$srow = mysqli_fetch_array($select_study);
$invoice = $srow['invoice'];
$value = (int) $invoice + 1;
$val = sprintf('%06d', $value);
$invoice_value = $row['Branch'].'-'.$val;
}
else
{
$value = "1";
$val = sprintf('%06d', $value);
$invoice_value = $row['Branch'].'-'.$val;
}
if(!empty($row['photo'])){
$image = $row['photo'];
}
else
{
$image = 'assets/img/user.png';
}
$select_studyData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='STUDY FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_studyData)>0)
{
$dataRow = mysqli_fetch_array($select_studyData);
$studydue_amount = $dataRow['study_due_amount'];
$study_paid_amount = $dataRow['study_paid_amount'];
}
else
{
$studydue_amount = $row['study_amount'];
$study_paid_amount = 0;
}
$select_busData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='BUS FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_busData)>0)
{
$dataRow = mysqli_fetch_array($select_busData);
$busdue_amount = $dataRow['study_due_amount'];
$bus_paid_amount = $dataRow['study_paid_amount'];
}
else
{
$busdue_amount = $row['BusAmount'];
$bus_paid_amount = 0;
}
$select_AddData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='ADDITIONAL FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_AddData)>0)
{
$dataRow = mysqli_fetch_array($select_AddData);
$Adddue_amount = $dataRow['study_due_amount'];
$Add_paid_amount = $dataRow['study_paid_amount'];
}
else
{
$Adddue_amount = $row['add_amount'];
$Add_paid_amount = 0;
}
$select_hosteData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='HOSTEL FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_hosteData)>0)
{
$dataRow = mysqli_fetch_array($select_hosteData);
$hostedue_amount = $dataRow['study_due_amount'];
$hoste_paid_amount = $dataRow['study_paid_amount'];
}
else
{
$hostedue_amount = $row['hostel_amount'];
$hoste_paid_amount = 0;
}
$select_booksData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='BOOKS FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_booksData)>0)
{
$dataRow = mysqli_fetch_array($select_booksData);
$booksdue_amount = $dataRow['study_due_amount'];
$books_paid_amount =$dataRow['study_paid_amount'];
}
else
{
$booksdue_amount = $row['books_fee'];
$books_paid_amount = 0;
}
$select_AdmissionData = executework("select * from student_fee where admission_no ='".$row['AdmissionNo']."' and category ='ADMISSION FEE' and yearOf = '".$row['Academic_year']."' order by id desc limit 1");
if(mysqli_num_rows($select_AdmissionData)>0)
{
$dataRow = mysqli_fetch_array($select_AdmissionData);
$Admissionsdue_amount = $dataRow['study_due_amount'];
$Admission_paid_amount =$dataRow['study_paid_amount'];
}
else
{
$Admissionsdue_amount = $row['Amount'];
$Admission_paid_amount = 0;
}
$dataRow = mysqli_fetch_array($select_studyData);
echo json_encode(array(
"studentname" => ucfirst($row['StudentName']),
"surname" => ucfirst($row['Surname']),
"Dob" => date('d-m-Y',strtotime($row['Dob'])),
"Academic_year" => $row['Academic_year'],
"FatherName" => strtoupper($row['FatherName']),
"AdmissionNo" => $row['AdmissionNo'],
"MotherName" => strtoupper($row['MotherName']),
"AdmissionDate" => date('d-m-Y',strtotime($row['AdmissionDate'])),
"FatherMobile" => $row['FatherMobile'],
"Gender" => strtoupper($row['Gender']),
"Mandal" => strtoupper($row['Mandal']),
"PresentClass" => strtoupper($row['PresentClass']),
"Blood" => strtoupper($row['Blood']),
"syllabus" => strtoupper($row['syllabus']),
"SecreName" => strtoupper($row['SecreName']),
"Hostel" => strtoupper($row['Hostel']),
"admission_atcual_amt" => $row['admission_atcual_amt'],
"admission_Amount" => $row['Amount'],
"PinCode" => $row['PinCode'],
"Branch" => $row['Branch'],
"syllabus" => $row['syllabus'],
"file_image" => $image,
"study_amount" => $studydue_amount,
"study_paid_amount" => $study_paid_amount,
"busdue_amount" => $busdue_amount,
"bus_paid_amount" => $bus_paid_amount,
"Adddue_amount" => $Adddue_amount,
"Add_paid_amount" => $Add_paid_amount,
"hostedue_amount" => $hostedue_amount,
"hoste_paid_amount" => $hoste_paid_amount,
"booksdue_amount" => $booksdue_amount,
"books_paid_amount" => $books_paid_amount,
"Admissionsdue_amount" => $Admissionsdue_amount,
"Admission_paid_amount" => $Admission_paid_amount,
"Branch" => $row['Branch'],
"invoice_value" => $invoice_value,
"Businvoice_value" => $invoice_value,
"Addinvoice_value" => $invoice_value,
"hostelinvoice_value" => $invoice_value,
"booksinvoice_value" => $invoice_value,
"adminvoice_value" => $invoice_value,
"study_total_amount" => $row['study_amount'],
"bus_total_amount" => $row['BusAmount'],
"Additional_total_amount" => $row['add_amount'],
"Hostel_total_amount" => $row['hostel_amount'],
"Books_total_amount" => $row['books_fee'],
"study_actual_fee" => $row['study_actual_fee'],
"hostel_atcual_fee" => $row['hostel_atcual_fee'],
"bus_actual_fee" => $row['bus_actual_fee'],
"books_actual_fee" => $row['books_actual_fee'],
"add_actual_amount" => $row['add_actual_amount'],
"admissionAmount" => $row['Amount'],
"admission_atcual_amt" => $row['admission_atcual_amt'],
));
}
if($_POST['type'] == 5)
{
$year = substr($_POST['Academic_year'],5);
$code = $_POST['Branch'];
$class = substr($_POST['PresentClass'],0,3);
$admData = executework("SELECT * FROM student_registration where PresentClass = '".$_POST['PresentClass']."' and Academic_year = '".$_POST['Academic_year']."' and Branch = '".$_POST['Branch']."' order by id desc LIMIT 1");
if(mysqli_num_rows($admData)>0){
$rollNoData = mysqli_fetch_array($admData);
$rollNoo = $rollNoData['RollNo'];
$value = (int) $rollNoo + 1;
$val = sprintf('%03d', $value);
$Roll_value = $year.$code.'-'.$class.'-'.$val;
echo $Roll_value;
}
else {
$value = "1";
$val = sprintf('%03d', $value);
$Roll_value = $year.$code.'-'.$class.'-'.$val;
echo $Roll_value;
}
}
if($_POST['type'] == 6)
{
$year = substr($_POST['promoteYear'],5);
$code = $_POST['Branch'];
$class = substr($_POST['promote_class'],0,3);
$admData = executework("SELECT RollNo FROM promote_class where class = '".$_POST['promote_class']."' and academic_year = '".$_POST['promoteYear']."' and Branch = '".$_POST['Branch']."' order by id desc LIMIT 1");
if(mysqli_num_rows($admData)>0){
$rollNoData = mysqli_fetch_array($admData);
$rollNoo = $rollNoData['RollNo'];
$value = (int) $rollNoo + 1;
$val = sprintf('%06d', $value);
$Roll_value = $year.$code.'-'.$class.'-'.$val;
echo $Roll_value;
}
else {
$value = "1";
$val = sprintf('%06d', $value);
$Roll_value = $year.$code.'-'.$class.'-'.$val;
echo $Roll_value;
}
}
if($_POST['type'] == 15)
{
$fee_structure = executework("SELECT * FROM fee_structure where year = '".$_POST['Academic_year']."' and class = '".$_POST['PresentClass']."' and syllabus = '".$_POST['Syllabus']."'");
$feeRow = mysqli_fetch_array($fee_structure);
echo json_encode(array(
"admission_fee" => $feeRow['admission_fee'],
"studying_amount" => $feeRow['studying_amount'],
"addition_fee" => $feeRow['addition_fee'],
"hostel_fee" => $feeRow['tution_fee'],
"bus_fee" => $feeRow['bus_fee'],
"books_fee" => $feeRow['books_fee']
));
}
if($_POST['type'] == 8)
{
$promote = executework("INSERT INTO promote_class (addmission_no,class,RollNo,study_fee,study_actval_fee,hostel_fee,hostel_actval_fee,bus_fee,bus_actval_fee,additional_fee,actual_add_fee,academic_year,books_fee,books_actual_fee,create_date,Branch) values ('".$_POST['AdmissionNo']."','".$_POST['PresentClass']."','".$_POST['promoteRollNo']."','".$_POST['promoteSTotal']."','".$_POST['promoteSTotal123']."','".$_POST['promoteHTotal']."','".$_POST['promoteHTotal123']."','".$_POST['promoteBTotal']."','".$_POST['promoteBTotal123']."','".$_POST['promoteATotal']."','".$_POST['promoteATotal123']."','".$_POST['Academic_year']."','".$_POST['promoteBkTotal']."','".$_POST['promoteBkTotal123']."','".date('Y-m-d H:i:s')."','".$_POST['Branch']."') ");
echo $promote;
}
if($_POST['type'] == 17)
{
$PresentClass = executework("SELECT * FROM sections where class = '".$_POST['PresentClass']."'");
$row = mysqli_fetch_array($PresentClass);
echo $row['section'];
}
?>
@LwBee Strong Bypass
Upload File
Create New File