????????????????????
??????????????????
ÿØÿà
 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
error_reporting(0);
ini_set('display_errors', 0);

// Start output buffering to catch any unwanted output
ob_start();

// Clean any previous output
ob_clean();

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

try {
    include 'connection.php';

if (isset($_POST['admission_no']) && !empty($_POST['admission_no'])) {
    $admission_no = mysqli_real_escape_string($conn, $_POST['admission_no']);
    
    try {
        // Get student basic information from fees table (latest record)
        $student_sql = "SELECT * FROM fees WHERE admission_no = '$admission_no' ORDER BY id DESC LIMIT 1";
        $student_result = $conn->query($student_sql);
        
        if (!$student_result || $student_result->num_rows == 0) {
            echo json_encode([
                'success' => false,
                'message' => 'Student not found'
            ]);
            exit;
        }
        
        $student = $student_result->fetch_assoc();
        
        // Get account summary from accounts table
        $account_sql = "SELECT * FROM accounts WHERE admission_no = '$admission_no'";
        $account_result = $conn->query($account_sql);
        
        $account = array();
        if ($account_result && $account_result->num_rows > 0) {
            $account = $account_result->fetch_assoc();
        } else {
            // If no account record, create default values
            $account = array(
                'admission_no' => $admission_no,
                'total_fees' => $student['total_fee'],
                'due_amount' => $student['total_fee'],
                'paid_amount' => 0,
                'received_amount' => 0
            );
        }
        
        // Get payment history (all payment records for this admission)
        $payments_sql = "SELECT 
                           mr_no, 
                           received_amount, 
                           payment_date, 
                           transaction_id, 
                           bank_upi,
                           due_amount,
                           paid_amount,
                           id
                         FROM fees 
                         WHERE admission_no = '$admission_no' 
                         ORDER BY payment_date DESC, id DESC";
        
        $payments_result = $conn->query($payments_sql);
        $payments = array();
        
        if ($payments_result && $payments_result->num_rows > 0) {
            while ($payment_row = $payments_result->fetch_assoc()) {
                $payments[] = array(
                    'mr_no' => $payment_row['mr_no'],
                    'received_amount' => $payment_row['received_amount'],
                    'payment_date' => date('d-m-Y', strtotime($payment_row['payment_date'])),
                    'transaction_id' => $payment_row['transaction_id'],
                    'bank_upi' => $payment_row['bank_upi'],
                    'due_amount_at_time' => $payment_row['due_amount'],
                    'paid_amount_at_time' => $payment_row['paid_amount']
                );
            }
        }
        
        // Calculate totals for verification
        $total_received_from_payments = 0;
        foreach ($payments as $payment) {
            $total_received_from_payments += floatval($payment['received_amount']);
        }
        
        // Return all data
        $response = array(
            'success' => true,
            'student' => array(
                'admission_no' => $student['admission_no'],
                'student_name' => $student['student_name'],
                'fathers_name' => $student['fathers_name'],
                'mobile_no' => $student['mobile_no'],
                'course_name' => $student['course_name'],
                'total_fee' => $student['total_fee']
            ),
            'account' => $account,
            'payments' => $payments,
            'summary' => array(
                'total_payments_count' => count($payments),
                'total_received_from_payments' => $total_received_from_payments,
                'account_received_amount' => floatval($account['received_amount'])
            )
        );
        
        // Clean output buffer and send JSON
        ob_clean();
        echo json_encode($response);
        exit;
        
    } catch (Exception $e) {
        ob_clean();
        echo json_encode([
            'success' => false,
            'message' => 'Database error: ' . $e->getMessage()
        ]);
        exit;
    }
    
} else {
    ob_clean();
    echo json_encode([
        'success' => false,
        'message' => 'No admission number provided'
    ]);
    exit;
}

} catch (Exception $e) {
    ob_clean();
    echo json_encode([
        'success' => false,
        'message' => 'Connection error: ' . $e->getMessage()
    ]);
    exit;
}

if (isset($conn)) {
    $conn->close();
}
?>