"; print_r($getData);die;

$leadIdData = '';
if(!empty($getData) && !empty($getData['results']) && $getData['code'] === 200)
{
    $leadIdData = $getData['results'][0];
}


/* ===============================
   CURL CALL FROM MOBILE DATA
================================ */

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://procorporateleague.com/pcl_rest/api/v9/profile/mobile/'.$leadIdData['phone'],
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response = curl_exec($curl);
curl_close($curl);

$profileData = '';
$getData = json_decode($response, true);

if (!empty($getData) && !empty($getData['results']) && $getData['code'] === 200)
{
    $profileData = $getData['results'][0];
}


/* ===============================
   BUILD POST DATA
================================ */

$postData = [
    "subject"           => "{$leadIdData['full_name']}, Your AI-Powered PCL Profile is Live - Upload Video Now",
    "email"             => $profileData['email']                            ?? $leadIdData['email'] ?? '',
    "name"              => $leadIdData['full_name']                         ?? 'PCL',
    "city"              => $leadIdData['city']                              ?? '',
    "reference_id"      => $leadIdData['lead_id']                           ?? '',
    "registration_type" => $leadIdData['user_profile']                      ?? '',
    "mobile"            => $leadIdData['phone']                             ?? '',
    "user_id"           => $leadIdData['master_id']                         ?? '',
    "company_name"      => $profileData['company_name_individual']          ?? '',
    "person_name"       => $leadIdData['full_name']                         ?? '',
    "person_age"        => $profileData['age']                              ?? '',
];

//echo "
"; print_r($postData);die;

$filePath   = "https://www.procorporateleague.com/2026/pcl/assets/mail_image/";
$imgVersion = time();

if (empty($postData['email'])) {
    echo json_encode([
        "status_code" => 400,
        "status"      => "failed",
        "message"     => "Email is required"
    ]);
    exit;
}

/* ===============================
   BUILD TEMPLATE VARIABLES
================================ */
$user_name         = htmlspecialchars($postData['name']);
$user_email        = htmlspecialchars($postData['email']);
$city              = htmlspecialchars($postData['city']);
$reference_id      = htmlspecialchars($postData['reference_id']);
$registration_type = htmlspecialchars($postData['registration_type']);
$user_mobile       = htmlspecialchars($postData['mobile']);
$corporate         = htmlspecialchars($postData['company_name']);
$age               = htmlspecialchars($postData['person_age']);
$cta_link          = "https://www.procorporateleague.com/2026/pcl/eleven11.php?lead_id=" . urlencode($postData['reference_id']) . "&id=" . urlencode($postData['user_id']);

if (!empty($registration_type) && $registration_type == 'teams') {
    $team         = 'team';
    $company_name = $postData['company_name'];
    $person_name  = $postData['person_name'];
} else {
    $team         = 'individual';
    $company_name = '';
    $person_name  = $user_name;
}

/* ===============================
   FETCH STATS
================================ */
$statscurl = curl_init();
curl_setopt_array($statscurl, [
    CURLOPT_URL            => 'https://procorporateleague.com/pcl_rest/api/v1/pcl/stats',
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_ENCODING       => '',
    CURLOPT_MAXREDIRS      => 10,
    CURLOPT_TIMEOUT        => 0,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_HTTP_VERSION   => CURL_HTTP_VERSION_1_1,
    CURLOPT_CUSTOMREQUEST  => 'GET',
]);
$statsresponse = curl_exec($statscurl);
curl_close($statscurl);

$getstatsresponse = json_decode($statsresponse, true);
$statsArrayData = [
    'total_matches_played'  => $getstatsresponse['results'][0]['Total_Matches_Played']  ?? '',
    'total_runs_Scored'     => $getstatsresponse['results'][0]['Total_Runs_Scored']     ?? '',
    'total_wickets_Claimed' => $getstatsresponse['results'][0]['Total_Wickets_Claimed'] ?? '',
    'total_hundreds'        => $getstatsresponse['results'][0]['Total_Hundreds']        ?? '',
    'total_fifties'         => $getstatsresponse['results'][0]['Total_Fifties']         ?? '',
];

/* ===============================
   DB CALLS
================================ */

// SMTP Data
$smtpSql = "SELECT * FROM `smtp_auth_data` WHERE id = 1";
$smtpExe = mysqli_query($conn, $smtpSql);
$smtpRow = mysqli_fetch_assoc($smtpExe);
if (empty($smtpRow)) {
    echo json_encode([
        "status_code" => 400,
        "status"      => "ERROR",
        "message"     => "SMTP AUTH MISSING"
    ]);
    die;
}

// Email Template
$emailSql = "SELECT * FROM `email_template` WHERE id = 1";
$emailExe = mysqli_query($conn, $emailSql);
$emailRow = mysqli_fetch_assoc($emailExe);
if (empty($emailRow)) {
    echo json_encode([
        "status_code" => 400,
        "status"      => "ERROR",
        "message"     => "EMAIL TEMPLATE MISSING"
    ]);
    die;
}

/* ===============================
   BUILD CONDITIONAL BLOCKS
================================ */

// Age block
$age_block = !empty($age)
    ? "
Age : " . ucwords($age) . "
"
    : '';

// CTA button (individual only)
$cta_button_block = ($registration_type === 'individual')
    ? "
        

            

                

                    
                        Upload your Video
                    
                
            
        
"
    : '';

// Next steps block
$next_steps_block = ($registration_type === 'individual')
    ? "
        
✅ Our team will review your details
        
🎥 If applicable, your uploaded video will undergo AI-based evaluation
        
📩 You will receive further updates on your registered email / WhatsApp
        
🏏 Get ready for matches, trials & national broadcast opportunities
"
    : "
        
✅ Our team will review your details
        
📩 You will receive further updates on your registered email / WhatsApp
        
🏏 Get ready for matches, trials & national broadcast opportunities
";

/* ===============================
   REPLACE PLACEHOLDERS IN TEMPLATE
================================ */

$emailBody = $emailRow['template_file'] ?? '';

$replacements = [
    '{{user_name}}'             => ucwords($user_name),
    '{{person_name}}'           => ucwords($person_name),
    '{{user_email}}'            => $user_email,
    '{{city}}'                  => ucwords($city),
    '{{reference_id}}'          => $reference_id,
    '{{registration_type}}'     => $registration_type,
    '{{user_mobile}}'           => $user_mobile,
    '{{corporate}}'             => ucwords($corporate),
    '{{team}}'                  => ucwords($team),
    '{{company_name}}'          => ucwords($company_name),
    '{{cta_link}}'              => $cta_link,
    '{{filePath}}'              => $filePath,
    '{{imgVersion}}'            => $imgVersion,
    '{{age_block}}'             => $age_block,
    '{{cta_button_block}}'      => $cta_button_block,
    '{{next_steps_block}}'      => $next_steps_block,
    '{{total_matches_played}}'  => number_format($statsArrayData['total_matches_played']  ?: 0),
    '{{total_runs_Scored}}'     => number_format($statsArrayData['total_runs_Scored']      ?: 0),
    '{{total_wickets_Claimed}}' => number_format($statsArrayData['total_wickets_Claimed']  ?: 0),
    '{{total_hundreds}}'        => number_format($statsArrayData['total_hundreds']         ?: 0),
    '{{total_fifties}}'         => number_format($statsArrayData['total_fifties']          ?: 0),
];

$emailBody = strtr($emailBody, $replacements);

/* ===============================
   SEND EMAIL
================================ */
$mail = new PHPMailer(true);
try {
    $mail->isSMTP();
    $mail->Host       = $smtpRow['smtp_host']     ?? '';
    $mail->SMTPAuth   = true;
    $mail->Username   = $smtpRow['smtp_username'] ?? '';
    $mail->Password   = $smtpRow['smtp_password'] ?? '';
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;
    $mail->Port       = 587;

    $mail->setFrom('sachin.gupta@procorporateleague.com', 'Pro Corporate League');
    $mail->addAddress($postData['email'], $postData['name']);
    //$mail->addAddress('zehraruhi82@gmail.com', 'Ruhi');
    //$mail->addCC('mohammad.mozammil@procorporateleague.com', 'Mozammil');
    //$mail->addCC('zehraruhi82@gmail.com', 'Ruhi');
    //$mail->addCC('sachin.gupta@procorporateleague.com', 'Sachin Gupta');
    $mail->addCC('sachin.gupta@corporateworldcup.com', 'Sachin Gupta');
    $mail->addCC('rifat.saleem@procorporateleague.com', 'Refat Saleem');

    $mail->CharSet  = 'UTF-8';
    $mail->Encoding = 'base64';
    $mail->isHTML(true);
    $mail->Subject = !empty($postData['subject']) ? $postData['subject'] : 'Registration Confirmed – Pro Corporate League';
    $mail->Body    = $emailBody;

    $mail->send();

    // Enterprise logging after successful send.
    // Controller resolves module/submodule/source dynamically using active_file_name/server path/URLs.
    $trackingResult = pcl_email_log_dynamic($mail, $emailBody ?? '', $postData ?? [], [
        'status' => 'sent',
        'delivery_status' => 'sent',
        'message' => 'Email sent successfully'
    ]);

    echo json_encode([
        "status_code" => 200,
        "status"      => "success",
        "message"     => "Registration email sent successfully",
        "tracking"    => $trackingResult
    ]);
} catch (Exception $e) {
    
    $trackingResult = pcl_email_log_dynamic($mail, $emailBody ?? '', $postData ?? [], [
        'status' => 'failed',
        'delivery_status' => 'failed',
        'message' => $mail->ErrorInfo ?? $e->getMessage(),
        'error_message' => $mail->ErrorInfo ?? $e->getMessage()
    ]);
echo json_encode([
        "status_code" => 500,
        "status"      => "error",
        "message"     => $mail->ErrorInfo
    ]);
}