alert('Invalid Verification Code'); history.back();"); // } // } function generate($length = 7) { $chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890'; $token = ''; while (strlen($token) < $length) { $token .= $chars[mt_rand(0, strlen($chars) - 1)]; } return 'ORDER_' . $token; } $orderId = generate(13); require 'vendor/autoload.php'; $applicant_name = urlencode($_POST['applicant_name']); $mobile_number = urlencode($_POST['mobile_number']); $email_id = urlencode($_POST['email_id']); $form_name = urlencode($_POST['form_name']); $product_price = '1'; // Tech Lounge if (isset($_POST['form_id']) && $_POST['form_id'] == 'annual_return_enquiry') { $sql = " INSERT INTO fssai ( form_name, applicant_name, mobile_number, email_id, existing_licence_number, state, total_amount, order_id, form_created_on ) VALUES ( '" . $_POST["form_name"] . "', '" . $_POST["applicant_name"] . "', '" . $_POST["mobile_number"] . "', '" . $_POST["email_id"] . "', '" . $_POST['existing_licence_number'] . "', '" . $_POST["office_state"] . "', '" . $product_price . "', '" . $orderId . "', '" . $date . "' )"; if (!$result = $conn->query($sql)) { die('There was an error running the query [' . $conn->error . ']'); } else { $_SESSION["form_id"] = $conn->insert_id; $uid = $_SESSION["form_id"]; $ch = curl_init('https://crm2.techlounge.co.in/api/registration-form-submission.php?formId=' . $_SESSION["form_id"] . '&vendor=TTG&business=FSSAI&website=' . $crm_website . '&amount=ANNUAL_RETURN_ENQUIRY&status=Unpaid&name=' . $applicant_name . '&mobile=' . $mobile_number . '&email=' . $email_id . '&formName=' . $form_name . ''); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); require($_SERVER['DOCUMENT_ROOT'] . "/editable/data-form.php"); // $form_data // Function to generate a random token function generateToken($length = 7) { $chars = 'abcdefghijklmnopqrstuvwxyz1234567890'; $token = ''; for ($i = 0; $i < $length; $i++) { $token .= $chars[mt_rand(0, strlen($chars) - 1)]; } return $token; } // Generate CID $cid = generateToken(16); // Ensure all required values are present if (!isset($_POST['form_name'], $form_data[$_POST['form_name']])) { die("Invalid form data."); } $form_name = $_POST['form_name']; $form_link = $form_data[$form_name]['form_link']; $table_name = $form_data[$form_name]['table_name']; // Build full links $full_link = $current_link . $form_link . '?cid=' . $cid; $full_link_telesales = $current_link . '/telesales/' . $form_link . '?teleid=' . $cid; // echo $full_link_telesales; die(); // Escape input values to prevent SQL injection $cid = mysqli_real_escape_string($conn, $cid); $uid = (int) $uid; // Ensure integer $table_name = mysqli_real_escape_string($conn, $table_name); $form_name = mysqli_real_escape_string($conn, $form_name); // Construct SQL query $sql_insert_cid = "INSERT INTO cid (cid, uid, table_name, form_name) VALUES ('$cid', $uid, '$table_name', '$form_name')"; // Execute query $result_insert_id = mysqli_query($conn, $sql_insert_cid); if ($result_insert_id) { // Fetch user details $sql_select_user = "SELECT * FROM `$table_name` WHERE id = $uid"; $result_select_user = mysqli_query($conn, $sql_select_user); if ($row_select_user = mysqli_fetch_assoc($result_select_user)) { $user_name_array = $form_data[$form_name]['user_name']; $user_email_array = $form_data[$form_name]['user_email']; $user_name = $row_select_user[$user_name_array] ?? 'Unknown'; $user_email = $row_select_user[$user_email_array] ?? 'Unknown'; // API call to update form link $crm_api_url = "https://crm2.techlounge.co.in/api/edit-form-link-telesales.php?pannel_form_id=" . $_SESSION["panel_form_id_2"] . "&formId=" . $uid . "&fulllink=" . urlencode($full_link) . "&tele_sales_link=" . urlencode($full_link_telesales); // echo $crm_api_url; $ch = curl_init($crm_api_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); } } // Include PayU payment processing include_once('./payu/annual-return-payu-submit.php'); // Mailer $mail = new PHPMailer(true); $PayLink = 'https://efoodlicence.com/Payment.php?cmpnMail=' . base64_encode($orderId); try { $mail->isSMTP(); $mail->Host = 'efoodlicence.com'; $mail->SMTPAuth = true; $mail->Username = 'no-reply@efoodlicence.com'; $mail->Password = 'freeDOM@611#'; $mail->SMTPSecure = 'tls'; $mail->Port = 587; $mail->setFrom("no-reply@efoodlicence.com", "EFOODLICENCE"); $mail->addAddress("" . $_POST["email_id"] . ""); $mail->isHTML(true); $mail->Subject = "Your " . $_POST["form_name"] . " Submitted Successfully"; $mail->Body = " Dear " . $_POST["applicant_name"] . ",

Thank you for submitting your request for " . $_POST["form_name"] . " on our website.

This mail is an acknowledgement of successful submission of your application, on our website. This mail does not confirm the payment status against the submitted application.

Click on the link below to make payment.

Pay Here

Regards,
Team Processing,
For Queries: care@efoodlicence.com "; $mail->send(); $mail->ClearAllRecipients(); $mail->addAddress("no-reply@efoodlicence.com"); $mail->isHTML(true); $mail->Subject = "New " . $_POST["form_name"] . " Submitted"; $mail->Body = " APPLICANT NAME: " . $_POST["applicant_name"] . "
MOBILE NUMBER: " . $_POST['mobile_number'] . "
EMAIL ID: " . $_POST['email_id'] . "
"; $mail->send(); } catch (Exception $e) { echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}"; } } echo ""; echo ""; }