<?php
header('Content-Type: text/plain');
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

try {
    $db = DB();
    
    // Correctly format courses_applied as a valid JSON array of course names to satisfy constraint
    $coursesApplied = json_encode([
        "Advance Diploma in Architecture Design",
        "Advance Diploma in Automotive Management"
    ], JSON_UNESCAPED_UNICODE);
    
    echo "Restoring application AFF1779143034 into production database...\n";
    
    $res = $db->insert('affiliation_applications', [
        'application_number'         => 'AFF1779143034',
        'institution_name'           => 'HHH',
        'institution_type'           => 'Society',
        'established_year'           => 2020,
        'registration_number'        => '123456',
        'total_staff'                => 4,
        'director_name'              => 'Shalini',
        'director_mobile'            => '3439164515',
        'director_email'             => 'ravikumar231991@gmail.com',
        'director_photo'             => 'uploads/affiliation/photo_1779142982_4470.jpeg',
        'landline'                   => '',
        'address'                    => 'Sector 63',
        'city'                       => '',
        'district'                   => '',
        'state'                      => '',
        'pincode'                    => '110092',
        'building_type'              => 'owned',
        'total_area'                 => '',
        'number_of_classrooms'       => 1,
        'library_facility'           => 1,
        'computer_lab'               => 0,
        'internet_facility'          => 0,
        'courses_applied'            => $coursesApplied,
        'affiliation_fee_transaction_id' => '',
        'application_status'         => 'submitted',
        'submitted_at'               => '2026-05-19 03:53:53',
        'ip_address'                 => '45.251.49.23',
        
        'father_guardian_name'       => 'AAA',
        'registered_address'         => 'Arya nagar Karkardooma',
        'communication_address'      => 'Sector 63',
        'whatsapp_no'                => '1111111111',
        'registration_date'          => '2026-05-07',
        'pan_gst_no'                 => 'qwewqeqw',
        'identity_proof_no'          => 'wqeqweqwe',
        'bank_name'                  => '231231',
        'bank_account_no'            => '21312312321',
        'bank_ifsc'                  => '1234',
        'applied_for'                => 'Skill Development',
        'proposed_center_name'       => 'qeqeqe',
        'practical_lab_facility'     => 0,
        'computer_systems_available' => 0,
        'total_computers'            => 0,
        'power_backup_facility'      => 0,
        'clean_drinking_water'       => 0,
        'furniture_available'        => 0,
        'washroom_facility'          => 0,
        'safety_fire_extinguisher'   => 0,
        'faculty_details'            => '[{"sno":1,"name":"sfdsf","qualification":"sdfds","designation":"sdfdsf","experience":"2"}]',
        'courses_applied_details'    => '[{"sno":1,"name":"2","duration":"1","eligibility":"2","code":"2"},{"sno":2,"name":"Advance Diploma in Architecture Design","duration":"1 Year","eligibility":"12th Pass","code":"IBVTE-ADAD-15"},{"sno":3,"name":"Advance Diploma in Automotive Management","duration":"1 Year","eligibility":"12th Pass","code":"IBVTE-ADAM-18"}]',
        'documents_attached'         => 'Staff & Faculty Qualification Documents',
        'uploaded_documents'         => '{"4":"uploads/affiliation/doc_4_1779143029_5432.jpeg"}'
    ]);
    
    if ($res) {
        echo "SUCCESS! Recovered application ID: " . $res . "\n";
    } else {
        echo "FAILED to recover application.\n";
    }
} catch (Exception $e) {
    echo "ERROR: " . $e->getMessage() . "\n";
    echo $e->getTraceAsString() . "\n";
}