Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rotary2982.org/public_html/conf2026

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: smsapi.php

<?php include('config.php');
	
if($_GET['type'] == 'categories'){
    if(isset($_GET['zone']))
	   $sql_filter = "SELECT `zone_no`,`name`,`mobile_no` FROM `district_posting` WHERE position = 'AG' ORDER BY zone_no";
    else
        $sql_filter = "SELECT category FROM district_posting GROUP BY category";
    
    $result_filter = mysqli_query($con, $sql_filter);
    $result = mysqli_fetch_all($result_filter, MYSQLI_ASSOC);

if(!empty($result))
    {
    	$response['response'] = $result;
    }else{
    	$response['response'] = 0;
    }
}elseif($_GET['type'] == 'approval_status'){
   
    $result = [array('id' => '0', 'status' => 'Pending'), array('id' => '1', 'status' => 'Accepted'), array('id' => '2', 'status' => 'Declined')];
    if(!empty($result))
    {
        $response['response'] = $result;
    }else{
        $response['response'] = 0;
    }
}elseif($_GET['type'] == 'getData'){
	$categories = str_replace(array('[', ']'), array('', ''), $_GET['categories']);
	if($_GET['resend'] == 1)
        $sql = "SELECT * FROM district_posting WHERE category IN($categories) AND approved = 0";
    else
        $sql = "SELECT * FROM district_posting WHERE category IN($categories) AND sms_status = 0";

$res = mysqli_query($con, $sql);
     
    while ($row = mysqli_fetch_assoc($res)) {
    	$id = $row['posting_id'];
    	$phone_number = $row['mobile_no'];
    	if($phone_number != 0 && $phone_number != '' && strlen($phone_number) == 10){
	    	$message = "Dear Rtn\nJoin the Live Training on Rotary.org & Rotary Zone App\nOn 02-08-2025 at Kongunadu Engg. College, Namakkal\nRtn Elanchelian\nDist Chair - Rotary Zone App";

$data[] = array('posting_id' => $id, 'phone_number' => $phone_number, 'message' => $message);
		}
		
    }

if(!empty($data))
    {
    	$response['response'] = $data;
    }else{
    	$response['response'] = 0;
    }

}elseif($_GET['type'] == 'getIndividualData'){
    $mobile_no = $_GET['phone_number'];
    
    $sql = "SELECT * FROM district_posting WHERE mobile_no = '$mobile_no'";
    $res = mysqli_query($con, $sql);
    while ($row = mysqli_fetch_assoc($res)) {
        $id = $row['posting_id'];
        $sms_status = $row['sms_status'];
        $sent_date = ($row['sms_sent_date'] != '0000-00-00 00:00:00') ? date('d-m-Y', strtotime($row['sms_sent_date'])) : '';
	    $message = "Dear Rtn\nJoin the Live Training on Rotary.org & Rotary Zone App \n On 02-08-2025 at Kongunadu Engg. College, Namakkal \n Rtn Elanchelian \n Dist Chair - Rotary Zone App";
        $data[] = array('posting_id' => $id, 'message' => $message, 'sms_status' => $sms_status, 'sms_sent_date' => $sent_date);
    }

if(!empty($data))
    {
        $response['response'] = $data;
    }else{
        $response['response'] = 0;
    }

}elseif($_GET['type'] == 'update')
{
	header('Content-type: application/json');

$jsonData = file_get_contents('php://input');
    $data = json_decode($jsonData, true);

if (json_last_error() !== JSON_ERROR_NONE) {
        echo 'JSON Decode Error: ' . json_last_error_msg();
        die();
    }

foreach($data as $d)
    {
    	$sql = "UPDATE district_posting SET sms_status = ". $d['status'] .", sms_sent_date = '". $d['sentDate'] ."' WHERE posting_id = ". $d['postingId'];
    	$res = mysqli_query($con, $sql);

$query = "INSERT INTO sms_history (ref_posting_id, sms_status, sms_sent_date) VALUES (". $d['postingId'] .", ". $d['status'] .", '". $d['sentDate'] ."')";
        $res1 = mysqli_query($con, $query); 
    }

if($res && $res1){
    	$response['response'] = 'success';
    }else{
    	$response['response'] = 0;
    }
}elseif($_GET['type'] == 'getZoneData')
{
    $zone_no = $_GET['zone_no'];
    $approve_status = $_GET['approve_status'];
    
    $title = $approve_status == 0 ? 'Pending' : ($approve_status == 1 ? 'Accepted' : 'Declined');
    $sql = "SELECT `club_name`,`name`,`mobile_no` FROM district_posting WHERE zone_no = '$zone_no' AND approved = '$approve_status' ORDER BY club_name, name";
    $res = mysqli_query($con, $sql);
    $cname = '';
    $message = "District Posting Approval $title List";
    while ($row = mysqli_fetch_assoc($res)) {
        if($row['club_name'] != $cname){
            $message .= "\n\n*". $row['club_name']."*";
            $cname = $row['club_name'];
        }

$message .= "\n". $row['mobile_no']." - ".$row['name'];
    }

if(!empty($message))
    {
        $response['response'] = $message;
    }else{
        $response['response'] = 0;
    }
    
}elseif ($_GET['type'] == 'Login') {

$username = $_POST['username'];
    $password = $_POST['password'];

$q = mysqli_query($con, "
        SELECT user_group, rotarian_name, AID 
        FROM admin 
        WHERE ANAME = '$username' 
        AND APASS = '$password'
    ");

if (mysqli_num_rows($q) > 0) {

$admin = mysqli_fetch_assoc($q);

echo json_encode([
            "status" => true,
            "message" => "Login successful",
            "data" => [
                "user_group"    => $admin['user_group'],
                "rotarian_name" => $admin['rotarian_name'],
                "user_id"       => $admin['AID']
            ]
        ]);

} else {
        echo json_encode([
            "status" => false,
            "message" => "Invalid username or password"
        ]);
    }
    exit;
}elseif ($_GET['type'] == 'VerifyMobileNo') {

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

$phone = $_POST['phone_number'] ?? '';

if ($phone == '') {
        echo json_encode([
            "status" => false,
            "message" => "Phone number is required"
        ]);
        exit;
    }

/* ================= REGISTRATION CHECK ================= */
    $reg_sql = "
SELECT 
    r.registration_id,
    r.reg_no,
    r.approve_status,
    r.registration_type_id,
    r.category_id,
    rt.registration_type_details AS registration_type_name,
    r.registration_amount,
    r.registration_date,

m.member_id,
    m.rotarian_name,
    m.club_id,
    c.club_name,

rd.name AS guest_name,
    rd.club_name AS guest_club

FROM registration r
LEFT JOIN registration_type rt 
    ON rt.registration_type_id = r.registration_type_id
LEFT JOIN member m 
    ON m.phone_number = r.phone_number
LEFT JOIN club c 
    ON c.club_id = m.club_id
LEFT JOIN registration_details rd
    ON rd.ref_registration_id = r.registration_id

WHERE r.phone_number = '$phone'
";

$reg_q = mysqli_query($con, $reg_sql);

if (!$reg_q) {
        echo json_encode([
            "status" => false,
            "message" => "Registration query error",
            "error" => mysqli_error($con)
        ]);
        exit;
    }

if (mysqli_num_rows($reg_q) > 0) {
        $regDls = [];
        $i = 0;
        while ($reg = mysqli_fetch_assoc($reg_q)) {

$is_guest = ($reg['category_id'] == 3);

$name = $is_guest
        ? ($reg['guest_name'] ?? '')
        : ($reg['rotarian_name'] ?? '');

$club_name = $is_guest
        ? ($reg['guest_club'] ?? '')
        : ($reg['club_name'] ?? '');

$member_id = $is_guest ? "" : $reg['member_id'];
    $club_id   = $is_guest ? "" : $reg['club_id'];

$regDls[$i] = [
        "registration_type_id"   => $reg['registration_type_id'],
        "registration_type_name" => $reg['registration_type_name'],
        "category_id"            => $reg['category_id'],
        "is_guest"               => $is_guest ? 1 : 0,
        "member_id"              => $member_id,
        "rotarian_name"          => $name,
        "club_id"                => $club_id,
        "club_name"              => $club_name,
        "registrtaion_date"      => $reg['registration_date'],
        "amount"                 => $reg['registration_amount']
    ];

if ($reg['approve_status'] == 1) {
        $regDls[$i]["approve_status"] = 1;
        $regDls[$i]["status_text"] = "Success";
        $regDls[$i]["reg_no"] = $reg['reg_no'];
    } else {
        $regDls[$i]["approve_status"] = 0;
        $regDls[$i]["status_text"] = "Pending";
        $regDls[$i]["reg_no"] = "";
    }

$i++;
}

echo json_encode([
            "status"  => true,
            "message" => "Already registered",
            "isRegistered" => "1",
            "data" => $regDls
        ]);
        exit;
}

/* ================= MEMBER CHECK ================= */
    $member_sql = "
    SELECT member_id, rotarian_name, club_id, phone_number, rotarian_email
    FROM member 
    WHERE phone_number = '$phone'
    LIMIT 1
";

$member_q = mysqli_query($con, $member_sql);

if (!$member_q) {
        echo json_encode([
            "status" => false,
            "message" => "Member query error",
            "error" => mysqli_error($con)
        ]);
        exit;
    }

if (mysqli_num_rows($member_q) == 0) {
        echo json_encode([
            "status" => false,
            "message" => "Member number not found"
        ]);
        exit;
    }

$member = mysqli_fetch_assoc($member_q);

$club_q = mysqli_query($con, "
        SELECT club_name 
        FROM club 
        WHERE club_id = '{$member['club_id']}'
        LIMIT 1
    ");
    $club = mysqli_fetch_assoc($club_q);

$category = [
        ["id" => "1", "name" => "Combo (Conf. + 5 Seminars)", "amount" => Combo],
        ["id" => "2", "name" => "Conference", "amount" => Rotarian],
        ["id" => "7", "name" => "Patron 1", "amount" => Patron_1],
        ["id" => "8", "name" => "Patron 2", "amount" => Patron_2],
        ["id" => "9", "name" => "Patron 3", "amount" => Patron_3],
    ];

echo json_encode([
        "status" => true,
        "message" => "Mobile number verified",
        "isRegistered" => "0",
        "data" => [
            "member_id" => $member['member_id'],
            "rotarian_name" => $member['rotarian_name'],
            "phone_number" => $member['phone_number'],
            "rotarian_email" => $member['rotarian_email'],
            "club_id" => $member['club_id'],
            "club_name" => $club['club_name'] ?? '',
            "category" => $category,
            "registration_date" => $registration_date
        ]
    ]);

exit;
}elseif($_GET['type'] == 'submitRegistration') {

$registration_date = $_POST['registration_date'] ?? date('Y-m-d');
    $category_id = $_POST['category_id'] ?? '';
    $registration_type_id = $_POST['registration_type_id'] ?? 0;
    $club_id = $_POST['club_id'] ?? 0;
    $club_name = $_POST['club_name'] ?? '';
    $member_id = $_POST['member_id'] ?? 0;
    $group_number = $_POST['group_number'] ?? '';
    $phone_number = $_POST['phone_number'] ?? '';
    $registration_amount = $_POST['registration_amount'] ?? 0;
    $UPI_type = $_POST['UPI_type'] ?? 0;
    $payment_mode = $_POST['payment_mode'] ?? 0;
    $payment_date = $_POST['payment_date'] ?? date('Y-m-d H:i:s');
    $ref_cash_recpt_no = $_POST['ref_cash_recpt_no'] ?? 0;
    $ref_user_id = $_POST['ref_user_id'] ?? 0;
    if($payment_mode == 1){
    $paid_to_member_id = $_POST['ref_user_id'] ?? 0;
    }else{
    $paid_to_member_id = 0;
    }
    $added_date = date('Y-m-d H:i:s');

// $UPI_transaction_screenshot = '';
    // if(isset($_FILES['UPI_transaction_screenshot']) && $_FILES['UPI_transaction_screenshot']['error'] == 0){
    //     $ext = pathinfo($_FILES['UPI_transaction_screenshot']['name'], PATHINFO_EXTENSION);
    //     $fileName = time().'_'.rand(10,9999).'.'.$ext;
	//     $UPI_transaction_screenshot = "uploads/upi_screenshots/".$fileName;
    //     move_uploaded_file($_FILES['UPI_transaction_screenshot']['tmp_name'], $UPI_transaction_screenshot);
    // }

$UPI_transaction_screenshot = '';

if (isset($_FILES['UPI_transaction_screenshot']) && $_FILES['UPI_transaction_screenshot']['error'] == 0) {
    $ext = pathinfo($_FILES['UPI_transaction_screenshot']['name'], PATHINFO_EXTENSION);
    $fileName = time() . '_' . rand(10, 9999) . '.' . $ext;
    move_uploaded_file($_FILES['UPI_transaction_screenshot']['tmp_name'], "uploads/upi_screenshots/" . $fileName);
    $UPI_transaction_screenshot = $fileName;
}

$UPI_transaction_id = $_POST['UPI_transaction_id'] ?? '';

$reg_query = "INSERT INTO registration (
        registration_date, category_id, registration_type_id, club_id, club_name, member_id, group_number,
        phone_number, registration_amount, UPI_type, UPI_transaction_id, UPI_transaction_screenshot,
        payment_mode, payment_date, ref_cash_recpt_no, ref_user_id, paid_to_member_id, added_date
    ) VALUES (
        '$registration_date', '$category_id', '$registration_type_id', '$club_id', '$club_name', '$member_id', '$group_number',
        '$phone_number', '$registration_amount', '$UPI_type', '$UPI_transaction_id', '$UPI_transaction_screenshot',
        '$payment_mode', '$payment_date', '$ref_cash_recpt_no', '$ref_user_id', '$paid_to_member_id', '$added_date'
    )";

if(mysqli_query($con, $reg_query)){
        $registration_id = mysqli_insert_id($con);
    } else {
        die(json_encode(['status'=>false,'message'=>'Failed Registration','error'=>mysqli_error($con)]));
    }

// $photo_upload = '';
    // if(isset($_FILES['photo_upload']) && $_FILES['photo_upload']['error'] == 0){
    //     $ext = pathinfo($_FILES['photo_upload']['name'], PATHINFO_EXTENSION);
    //     $fileName = time().'_'.rand(10,9999).'.'.$ext;
	//     $filePath = "uploads/".$fileName;
    //     move_uploaded_file($_FILES['photo_upload']['tmp_name'], $filePath);
    // }

$photo_upload = '';

if (isset($_FILES['photo_upload']) && $_FILES['photo_upload']['error'] == 0) {
    $ext = pathinfo($_FILES['photo_upload']['name'], PATHINFO_EXTENSION);
    $fileName = time() . '_' . rand(10, 9999) . '.' . $ext;
    move_uploaded_file($_FILES['photo_upload']['tmp_name'], "uploads/" . $fileName);
    $photo_upload = $fileName;
}

$name = $_POST['name'] ?? '';
    $email = $_POST['email_id'] ?? '';
    $food = $_POST['food'] ?? 1;
    $gender = $_POST['gender'] ?? 1;
    $t_shirt_size = $_POST['t_shirt_and_shirt_size'] ?? '';
    $fellowship = $_POST['fellow_ship'] ?? 2;
    $member_type = $_POST['member_type'] ?? 0;

$detail_query = "INSERT INTO registration_details (
        ref_registration_id, group_number, group_count, registration_date, club_id, club_name,
        member_id, ref_member_id, member_type, category_id, name, phone_number, email_id, food,
        gender, t_shirt_and_shirt_size, fellow_ship, photo_upload, registration_amount, added_date
    ) VALUES (
        '$registration_id', '$group_number', '1', '$registration_date', '$club_id', '$club_name',
        '$member_id', '$member_id', '$member_type', '$category_id', '$name', '$phone_number', '$email', '$food',
        '$gender', '$t_shirt_size', '$fellowship', '$photo_upload', '$registration_amount', '$added_date'
    )";
    // echo $detail_query; die();

if(!mysqli_query($con, $detail_query)){
        die(json_encode([
            'status'=>false,
            'message'=>'Failed to insert registration details',
            'error'=>mysqli_error($con)
        ]));
    }

echo json_encode([
        'status' => true,
        'message' => 'Registration submitted successfully',
        'registration_id' => $registration_id
    ]);

exit;
}elseif ($_GET['type'] == 'DashboardCount') {

header('Content-Type: application/json');
    $user_id = $_POST['user_id'] ?? '';
    if (empty($user_id)) {
        echo json_encode([
            "status"  => false,
            "message" => "User ID is required"
        ]);
        exit;
    }

$today = date('Y-m-d');
    $total_count = "0";
    $total_q = mysqli_query($con, "SELECT COUNT(*) AS total_count FROM registration WHERE ref_user_id = '$user_id'");
    if ($total_q && $row = mysqli_fetch_assoc($total_q)) {
        $total_count = (string) $row['total_count'];
    }

$today_count = "0";
    $today_q = mysqli_query($con, "SELECT COUNT(*) AS today_count FROM registration WHERE ref_user_id = '$user_id' AND DATE(registration_date) = '$today'");
    if ($today_q && $row = mysqli_fetch_assoc($today_q)) {
        $today_count = (string) $row['today_count'];
    }
    $payment_map = [
       
        4 => 'online_pos',
        2 => 'online_direct',
        1 => 'cash'

];

$payment_modes = [];
    foreach ($payment_map as $type) {
        $payment_modes[$type] = [
            "type"   => $type,
            "count"  => "0",
            "amount" => "0"
        ];
    }

$today_amount = "0";

$payment_q = mysqli_query($con, "SELECT payment_mode, COUNT(*) AS mode_count, SUM(COALESCE(registration_amount, 0)) AS total_amount FROM registration WHERE ref_user_id = '$user_id' AND DATE(registration_date) = '$today' GROUP BY payment_mode");
    if ($payment_q) {
        while ($row = mysqli_fetch_assoc($payment_q)) {

$mode_num = (int) $row['payment_mode'];

if (isset($payment_map[$mode_num])) {

$type = $payment_map[$mode_num];

$payment_modes[$type]['count']  = (string) $row['mode_count'];
                $payment_modes[$type]['amount'] = (string) $row['total_amount'];

$today_amount = (string) (
                    (float) $today_amount + (float) $row['total_amount']
                );
            }
        }
    }

$payment_modes = array_values($payment_modes);

echo json_encode([
        "status" => true,
        "message" => "Dashboard data fetched successfully",
        "total_count" => $total_count,
        "today_count" => $today_count,
        "today_amount" => $today_amount,
        "payment_modes" => $payment_modes
    ]);

exit;
}elseif ($_GET['type'] == 'clublist') {

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

// Fetch all clubs
    $club_q = mysqli_query($con, "SELECT club_id, club_name FROM club ORDER BY club_name ASC");

if (!$club_q) {
        echo json_encode([
            "status" => false,
            "message" => "Database query failed: " . mysqli_error($con)
        ]);
        exit;
    }

$clubs = [];

while ($row = mysqli_fetch_assoc($club_q)) {
        $clubs[] = [
            "club_id" => (string) $row['club_id'],   // convert to string
            "club_name" => $row['club_name']
        ];
    }

echo json_encode([
        "status" => true,
        "message" => "Club list fetched successfully",
        "clubs" => $clubs
    ]);

exit;
}elseif ($_GET['type'] == 'categorylist') {

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

// Category list using constants
    $categories = [
        [
            "id"     => "1",
            "name"   => "Combo (Conf. + 5 Seminars)",
            "amount" => (string) Combo
        ],
        [
            "id"     => "2",
            "name"   => "Conference",
            "amount" => (string) Rotarian
        ],
        [
            "id"     => "7",
            "name"   => "Patron 1",
            "amount" => (string) Patron_1
        ],
        [
            "id"     => "8",
            "name"   => "Patron 2",
            
            "amount" => (string) Patron_2
        ],
        [
            "id"     => "9",
            "name"   => "Patron 3",
            "amount" => (string) Patron_3
        ],
        [
            "id"     => "16",
            "name"   => "Guest",
            "amount" => (string) Guest
        ]
    ];

echo json_encode([
        "status" => true,
        "message" => "Category list fetched successfully",
        "categories" => $categories
    ]);

exit;
}elseif ($_GET['type'] == 'upgradeverifymobileno') {

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

$phone_number = $_POST['phone_number'] ?? '';

if (empty($phone_number)) {
        echo json_encode([
            "status"  => false,
            "message" => "Phone number is required"
        ]);
        exit;
    }

$reg_q = mysqli_query($con, "
        SELECT 
            registration_id,
            phone_number,
            registration_type_id,
            registration_amount,
            approve_status,
            category_id
        FROM registration
        WHERE phone_number = '$phone_number' && upgrade_id = 0 && delete_status = 0
        LIMIT 1
    ");

if (!$reg_q || mysqli_num_rows($reg_q) == 0) {
        echo json_encode([
            "status"  => false,
            "message" => "Mobile number not registered"
        ]);
        exit;
    }

$reg = mysqli_fetch_assoc($reg_q);

$registration_id       = $reg['registration_id'];
    $category_id           = $reg['category_id'];
    $registration_type_id  = (string) $reg['registration_type_id'];
    $registration_amount   = (string) $reg['registration_amount'];
    $approve_status        = (string) $reg['approve_status'];

// Combo amount (constant already defined in project)
    $combo_amount  = (string) Combo;

// Amount to pay calculation
    $amount_to_pay = (string) max(0, ((int) Combo - (int) $registration_amount));

if ($registration_type_id === "1") {
        echo json_encode([
            "status"  => false,
            "message" => "Already in combo",
            "allow"   => "0"
        ]);
        exit;
    }

if ($registration_type_id == "2" && $approve_status == "0") {
    // print_r($approve_status);die();

echo json_encode([
            "status"  => false,
            "message" => "Waiting for approval. Please get approval to upgrade."
        ]);
        exit;
    }

if ($registration_type_id === "2") {

$detail_q = mysqli_query($con, "
            SELECT 
                rd.name,
                rd.phone_number,
                rd.club_id,
                rd.club_name
            FROM registration_details rd
            WHERE rd.ref_registration_id = '$registration_id'
            LIMIT 1
        ");

$details = [
            "name"         => "",
            "phone_number" => $phone_number,
            "club_id"      => "",
            "club_name"    => ""
        ];

if ($detail_q && mysqli_num_rows($detail_q) > 0) {
            $row = mysqli_fetch_assoc($detail_q);

$details = [
                "name"         => $row['name'] ?? "",
                "phone_number" => $row['phone_number'] ?? $phone_number,
                "club_id"      => (string) ($row['club_id'] ?? ""),
                "club_name"    => $row['club_name'] ?? ""
            ];
        }
        if ($category_id == "3") {
    // print_r($approve_status);die();

echo json_encode([
            "status"  => false,
            "message" => "Guests do not have permission to upgrade."
        ]);
        exit;
    }

echo json_encode([
            "status"  => true,
            "message" => "Available to upgrade combo",
            "allow"   => "1",

"combo" => [
                "id"     => "1",
                "name"   => "Combo (Conf. + 5 Seminars)",
                "amount" => (string) Combo
            ],

"data" => [
                "name"                   => $details['name'],
                "phone_number"           => $details['phone_number'],
                "club_id"                => $details['club_id'],
                "club_name"              => $details['club_name'],
                "registration_id"        => $registration_id,
                "registration_amount"    => $registration_amount,
                "registration_type_id"   => $registration_type_id,
                "amount_to_pay"          => $amount_to_pay
            ]
        ]);
        exit;
    }
$type_names = [
    "1"  => "Combo (Conf. + 5 Seminars)",
    "2"  => "Conference",
    "7"  => "Patron 1",
    "8"  => "Patron 2",
    "9"  => "Patron 3",
    "16" => "Guest"
];

$reg_type_name = $type_names[$registration_type_id] ?? "Unknown Type";

echo json_encode([
    "status"  => false,
    "message" => "Already registered under the " . $reg_type_name." category are not eligible for the Combo upgrade"
]);
exit;

// echo json_encode([
    //     "status"  => false,
    //     "message" => "Already registered under the Family Patron category are not eligible for the Combo upgrade"
    // ]);
    // exit;
}elseif ($_GET['type'] == 'upgradeRegistration') {

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

$old_registration_id        = $_POST['registration_id'] ?? 0;
    $new_registration_type_id   = $_POST['registration_type_id'] ?? 0;
    $amount_to_pay              = $_POST['amount_to_pay'] ?? 0;

// Payment fields (FROM POST)
    $payment_mode               = $_POST['payment_mode'] ?? 0;
    $UPI_type                   = $_POST['UPI_type'] ?? 0;
    $UPI_transaction_id         = $_POST['UPI_transaction_id'] ?? '';
    $payment_date               = $_POST['payment_date'] ?? date('Y-m-d H:i:s');
    $ref_cash_recpt_no          = $_POST['ref_cash_recpt_no'] ?? 0;
    $ref_user_id                = $_POST['ref_user_id'] ?? 0;
    if($payment_mode == 1){
    $paid_to_member_id = $_POST['ref_user_id'] ?? 0;
    }else{
    $paid_to_member_id = 0;
    }
    $added_date                 = date('Y-m-d H:i:s');

// UPI Screenshot upload
    $UPI_transaction_screenshot = '';

if (isset($_FILES['UPI_transaction_screenshot']) && $_FILES['UPI_transaction_screenshot']['error'] == 0) {

$ext = pathinfo($_FILES['UPI_transaction_screenshot']['name'], PATHINFO_EXTENSION);

$fileName = time() . '_' . rand(10, 9999) . '.' . $ext;

$uploadPath = "uploads/upi_screenshots/";

move_uploaded_file(
        $_FILES['UPI_transaction_screenshot']['tmp_name'],
        $uploadPath . $fileName
    );

$UPI_transaction_screenshot = $fileName;
}

if (!$old_registration_id || !$new_registration_type_id || !$amount_to_pay) {
        echo json_encode([
            'status' => false,
            'message' => 'Required fields missing'
        ]);
        exit;
    }

$old_reg_q = mysqli_query($con, "
        SELECT * FROM registration 
        WHERE registration_id = '$old_registration_id'
        LIMIT 1
    ");

if (!$old_reg_q || mysqli_num_rows($old_reg_q) == 0) {
        echo json_encode([
            'status' => false,
            'message' => 'Original registration not found'
        ]);
        exit;
    }

$old_reg = mysqli_fetch_assoc($old_reg_q);

$insert_reg = "
        INSERT INTO registration (
            registration_date, category_id, registration_type_id,upgrade,
            club_id, club_name, member_id, group_number,
            phone_number, registration_amount,
            UPI_type, UPI_transaction_id, UPI_transaction_screenshot,
            payment_mode, payment_date, ref_cash_recpt_no,
            ref_user_id, paid_to_member_id, added_date
        ) VALUES (
            '{$old_reg['registration_date']}',
            '{$old_reg['category_id']}',
            '$new_registration_type_id',
            '1',
            '{$old_reg['club_id']}',
            '{$old_reg['club_name']}',
            '{$old_reg['member_id']}',
            '{$old_reg['group_number']}',
            '{$old_reg['phone_number']}',
            '$amount_to_pay',
            '$UPI_type',
            '$UPI_transaction_id',
            '$UPI_transaction_screenshot',
            '$payment_mode',
            '$payment_date',
            '$ref_cash_recpt_no',
            '$ref_user_id',
            '$paid_to_member_id',
            '$added_date'
        )
    ";

if (!mysqli_query($con, $insert_reg)) {
        echo json_encode([
            'status' => false,
            'message' => 'Upgrade registration failed',
            'error' => mysqli_error($con)
        ]);
        exit;
    }

$new_registration_id = mysqli_insert_id($con);

$old_detail_q = mysqli_query($con, "
        SELECT * FROM registration_details 
        WHERE ref_registration_id = '$old_registration_id'
        LIMIT 1
    ");

if (!$old_detail_q || mysqli_num_rows($old_detail_q) == 0) {
        echo json_encode([
            'status' => false,
            'message' => 'Original registration details not found'
        ]);
        exit;
    }

$old_detail = mysqli_fetch_assoc($old_detail_q);

$insert_detail = "
        INSERT INTO registration_details (
            ref_registration_id, group_number, group_count,
            registration_date, club_id, club_name,
            member_id, ref_member_id, member_type,
            category_id, name, phone_number, email_id,
            food, gender, t_shirt_and_shirt_size,
            fellow_ship, photo_upload,
            registration_amount, added_date
        ) VALUES (
            '$new_registration_id',
            '{$old_detail['group_number']}',
            '{$old_detail['group_count']}',
            '{$old_detail['registration_date']}',
            '{$old_detail['club_id']}',
            '{$old_detail['club_name']}',
            '{$old_detail['member_id']}',
            '{$old_detail['ref_member_id']}',
            '{$old_detail['member_type']}',
            '{$old_detail['category_id']}',
            '{$old_detail['name']}',
            '{$old_detail['phone_number']}',
            '{$old_detail['email_id']}',
            '{$old_detail['food']}',
            '{$old_detail['gender']}',
            '{$old_detail['t_shirt_and_shirt_size']}',
            '{$old_detail['fellow_ship']}',
            '{$old_detail['photo_upload']}',
            '$amount_to_pay',
            '$added_date'
        )
    ";

if (!mysqli_query($con, $insert_detail)) {
        echo json_encode([
            'status' => false,
            'message' => 'Upgrade registration details failed',
            'error' => mysqli_error($con)
        ]);
        exit;
    }

$new_registration_detail_id = mysqli_insert_id($con);

mysqli_query($con, "
        UPDATE registration SET
            upgrade = 0,
            upgrade_id = '$new_registration_id',
            upgrade_combo = 1
        WHERE registration_id = '$old_registration_id'
    ");

mysqli_query($con, "
        UPDATE registration_details SET
            upgrade_id = '$new_registration_detail_id'
        WHERE ref_registration_id = '$old_registration_id'
    ");

echo json_encode([
        'status' => true,
        'message' => 'Registration upgraded successfully',
        'new_registration_id' => $new_registration_id
    ]);
    exit;
}elseif ($_GET['type'] == 'VerifyGuestMobileNo') {

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

$phone = $_POST['phone_number'] ?? '';

if ($phone == '') {
        echo json_encode([
            "status" => false,
            "message" => "Phone number is required",
            "isregistered" => 0
        ]);
        exit;
    }

$sql = "
        SELECT registration_id 
        FROM registration
        WHERE phone_number = '$phone'
        LIMIT 1
    ";

$query = mysqli_query($con, $sql);

if (!$query) {
        echo json_encode([
            "status" => false,
            "message" => "Database error", 
            "error" => mysqli_error($con)
        ]);
        exit;
    }

if (mysqli_num_rows($query) > 0) {

echo json_encode([
            "status" => false,
            "message" => "Already Registered",
            "isregistered" => 1
        ]);
        exit;

} else {

echo json_encode([
            "status" => true,
            "message" => "Phone number available to register",
            "isregistered" => 0
        ]);
        exit;
    }
}

if (isset($response) && isset($response['response'])) {

if ($response['response'] != '0') {
        $response["success"] = 1;
        $response["message"] = "sent";
        echo json_encode($response);
    } else {
        $response["success"] = 0;
        $response["message"] = "failure";
        echo json_encode($response);
    }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: smsapi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation