????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................<?php
include 'connection.php';  // Includes $conn if defined

// Use $mysqli for consistency with other files
$user = 'xceljsr_db';
$password = 'xcel@123#$';
$database = 'xceljsr_db';
$servername = 'localhost';
$mysqli = new mysqli($servername, $user, $password, $database);

// Checking for connections
if ($mysqli->connect_error) {
    header('Content-Type: application/json');
    echo json_encode(['error' => 'Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error]);
    exit;
}

// Set charset for consistent UTF-8 handling
$mysqli->set_charset("utf8mb4");

header('Content-Type: application/json');  // Ensure JSON response

if (isset($_POST['admission_no']) && !empty($_POST['admission_no'])) {
    $admission_no = mysqli_real_escape_string($mysqli, $_POST['admission_no']);
    
    // 1. Fetch Student Details from admission table
    $student_sql = "SELECT admission_no, student_name, fathers_name, contact_personal AS mobile_no, course, 
                           dob, blood_group, nationality, marital_status, qualification, aadhar_no, 
                           present_address, permanent_address, trade, contact_home, email_id, 
                           duration, course_fee_amount, discount, payable_amount
                    FROM admission 
                    WHERE admission_no = '$admission_no'";
    
    $student_result = $mysqli->query($student_sql);
    
    if (!$student_result) {
        echo json_encode(['error' => 'Student query failed: ' . $mysqli->error]);
        exit;
    }
    
    if ($student_result->num_rows == 0) {
        echo json_encode(['success' => false, 'message' => "No student found for admission_no: $admission_no"]);
        exit;
    }
    
    $student = $student_result->fetch_assoc();
    
    // 2. Fetch Account Summary from accounts table
    $account_sql = "SELECT total_fees, due_amount, paid_amount, received_amount, extra_fee
                    FROM accounts 
                    WHERE admission_no = '$admission_no'";
    
    $account_result = $mysqli->query($account_sql);
    
    if (!$account_result) {
        echo json_encode(['error' => 'Account query failed: ' . $mysqli->error]);
        exit;
    }
    
    $account = ['total_fees' => 0, 'due_amount' => 0, 'paid_amount' => 0, 'received_amount' => 0, 'extra_fee' => 0];
    if ($account_result->num_rows > 0) {
        $account_row = $account_result->fetch_assoc();
        $account['total_fees'] = floatval($account_row['total_fees'] ?? 0);
        $account['due_amount'] = floatval($account_row['due_amount'] ?? 0);
        $account['paid_amount'] = floatval($account_row['paid_amount'] ?? 0);
        $account['received_amount'] = floatval($account_row['received_amount'] ?? 0);
        $account['extra_fee'] = floatval($account_row['extra_fee'] ?? 0);
    }
    
    // 3. Fetch Extra Fee Payment History from extra_fee table
    $payments_sql = "SELECT extra_fee_no, received_amount, payment_date, payment_for, reason, 
                            payment_mode, transaction_id, bank_upi, addedby
                     FROM extra_fee 
                     WHERE admission_no = '$admission_no' 
                     ORDER BY payment_date DESC, id DESC";
    
    $payments_result = $mysqli->query($payments_sql);
    
    if (!$payments_result) {
        echo json_encode(['error' => 'Payments query failed: ' . $mysqli->error]);
        exit;
    }
    
    $payments = [];
    while ($payment_row = $payments_result->fetch_assoc()) {
        $payments[] = [
            'extra_fee_no' => $payment_row['extra_fee_no'] ?? '',
            'received_amount' => floatval($payment_row['received_amount'] ?? 0),
            'payment_date' => $payment_row['payment_date'] ?? '',
            'payment_for' => $payment_row['payment_for'] ?? '',
            'reason' => $payment_row['reason'] ?? '',
            'payment_mode' => $payment_row['payment_mode'] ?? '',
            'transaction_id' => $payment_row['transaction_id'] ?? '',
            'bank_upi' => $payment_row['bank_upi'] ?? '',
            'addedby' => $payment_row['addedby'] ?? ''
        ];
    }
    
    // Success response
    echo json_encode([
        'success' => true,
        'student' => $student,
        'account' => $account,
        'payments' => $payments
    ]);
    
} else {
    echo json_encode(['error' => 'Admission No is required']);
}

$mysqli->close();
exit;
?>