<?php
    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);
    session_start();
    include_once('config.php');
    #include_once('validate-special.php');
    use PHPMailer\PHPMailer\PHPMailer;
    use PHPMailer\PHPMailer\Exception;
    require 'vendor/autoload.php';
    function generate($length = 7) {
        $chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
        $token = '';
        while(strlen($token) < $length) {
            $token .= $chars[mt_rand(0, strlen($chars) - 1)];
        }
        return 'ORDER_' . $token;
    }

    date_default_timezone_set('Asia/Kolkata');
    $date = date('d-m-Y H:i:s');

    if (defined('PAYMENT_GATEWAY') && $currentPaymentGateway == 'CASHFREE') {
        $orderId = generate(13);
    } else if (defined('PAYMENT_GATEWAY') && $currentPaymentGateway == 'PAYU') {
        $orderId = generate(13);
    } else {
        $orderId ='';
    }
    $applicant_name = urlencode($_POST['applicant_name']);
    $mobile_number  = urlencode($_POST['mobile_number']);
    $email_id  = urlencode($_POST['email_id']);

    //state//
    if (isset($_POST['state'])) {
        $state = urlencode($_POST['state']);
    } else if (isset($_POST['office_state'])) {
        $state = urlencode($_POST['office_state']);
    } else {
        $state = '-';
    }

    $crm_website = 'GEMREGISTRATIONONLINE.ORG';
    $url1 = 'gemregistrationonline.org';
    $webpath = pathinfo($url1, PATHINFO_FILENAME);
    $website = 'gemregistrationonline.org';
    $table='gem_registration';
    $TodayDate = date('d-m-Y');

    //g.e.m Registrations
    if (isset($_POST['form_id']) && ($_POST['form_id'] == "gem_registration")) {
        //Retrive Product Price According To Product Name(form_id)
       $_SESSION['table_id'] = 'gem_registration';
        $payment_status = 'Unpaid';
        $sql ="SELECT product_price FROM product_lists WHERE product_name = '".$_POST["form_id"]."'";
        $result = $conn->query($sql);
        $row = $result->fetch_assoc();
        $product_price = $row["product_price"];
        $form_page_url = $_POST["form_id"].'.php';
        $form_page_url = str_replace('_','-',$form_page_url);

        $_POST["sol_number"] ='';
        $cur_url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://" . $_SERVER['HTTP_HOST'] ;
        if(!empty($_FILES['upload_pan_card']['name'])) {
            $url = "https://uploadmsme.in/index.php";
            $tmp_file_name = $_FILES['upload_pan_card']['tmp_name'];
            $file_type = $_FILES['upload_pan_card']['type'];
            $file_name = basename($_FILES['upload_pan_card']['name']);
            $post_data = array(
                'file' => curl_file_create($tmp_file_name, $file_type, $file_name)
            );
            if(empty($tmp_file_name)) {
                echo'';
            }else {
                $ch = curl_init();
                curl_setopt($ch, CURLOPT_URL, $url);
                curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data);
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                $upload_pancard = curl_exec($ch);
                curl_close($ch);
            }
        }else{
            $upload_pancard = '';
        }

        $sql =
        "INSERT INTO $table (
        form_name,
        form_page_url,
        c_gateway,
        c_gateway_merchant,
        payment_stage,
        applicant_name,
        mobile_number,
        email_id,
        date_of_birth,
        office_address,
        office_state,
        office_district,
        office_pincode,
        aadhaar_number,
        pan_card_number,
        bank_name,
        bank_address,
        bank_account_number,
        ifsc_code,
        business_name,
        incorporation_date,
        type_of_organisation,
        upload_pan_card,
        total_amount,
        payment_status,
        order_id,
        terms_of_service,
        form_created_on,
        form_created_date
        )
        VALUES (
            '".$_POST["form_name"]."',
            '".$form_page_url."',
            '".$currentPaymentGateway."',
            '".$merchantEmail."',
            '".$stage."',
            '".$_POST["applicant_name"]."',
            '".$_POST["mobile_number"]."',
            '".$_POST["email_id"]."',
            '".$_POST["dob"]."',
            '".$_POST["office_address"]."',
            '".$_POST["office_state"]."',
            '".$_POST["office_district"]."',
            '".$_POST["office_pincode"]."',
            'NA',
            '".$_POST["pan_card_number"]."',
            '".$_POST["bank_name"]."',
            '".$_POST["bank_address"]."',
            '".$_POST["bank_account_number"]."',
            '".$_POST["ifsc_code"]."',
            '".$_POST["business_name"]."',
            '".$_POST["incorporation_date"]."',
            '".$_POST["type_of_organisation"]."',
            '".$upload_pancard."',
            '".$product_price."',
            '".$payment_status."',
            '".$orderId."',
            'Checked',
            '".$date."',
            '".$TodayDate."'
        )
        ";
        if (!$result = $conn->query($sql)) {
            die('There was an error running the query [' . $conn->error . ']');
        } else {
            $_SESSION["form_id"] = $conn->insert_id;
            $form_name = urlencode($_POST["form_name"]);
            $ch = curl_init('https://crm2.techlounge.co.in/api/registration-form-submission.php?formId='.$_SESSION["form_id"].'&vendor=TTG&business=GEM&website='.$crm_website.'&amount='.$product_price.'&status=Unpaid&name='.$applicant_name.'&mobile='.$mobile_number.'&email='.$email_id.'&state='.$state.'&formName='.$form_name.'&solNumber='.urlencode($_POST["sol_number"]).'');
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
            $response = curl_exec($ch);
            curl_close($ch);
            $_SESSION["panel_form_id_2"] = $response;
    }
    include_once('client-email.php');
        include_once('payu/payu-submit.php');
    }

?>