<?php
include('../admin/inc/conn.php');
include('../admin/inc/mail.php');
if($_POST['type']==1){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $message = str_replace("'", "\'", $_POST['message']);
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `brand_partnership` (`name`, `email`, `phone`, `city`, `message`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$message', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==2){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $message = str_replace("'", "\'", $_POST['message']);
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `client_interest` (`name`, `email`, `phone`, `city`, `message`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$message', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==3){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $message = str_replace("'", "\'", $_POST['message']);
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `retail_partnership` (`name`, `email`, `phone`, `city`, `message`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$message', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==4){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $message = str_replace("'", "\'", $_POST['message']);
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `corporate_tieups` (`name`, `email`, `phone`, `city`, `message`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$message', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==5){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $property = $_POST['property'];
    $invest = $_POST['invest'];
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `franchise_application` (`name`, `email`, `phone`, `city`, `property`, `invest`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$property', '$invest', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
            mailfranchise($con, $con->insert_id);
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==99){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $establishment = $_POST['establishment'];
    $type_of_service = $_POST['type_of_service'];
    $devices = $_POST['devices'];
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `amc` (`name`, `email`, `phone`, `city`, `establishment`, `type_of_service`, `devices`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$establishment', '$type_of_service', '$devices', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
            mailfranchise($con, $con->insert_id);
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==6){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $city = $_POST['city'];
    $business = $_POST['business'];
    $invest = $_POST['invest'];
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `preferred_partner` (`name`, `email`, `phone`, `city`, `business`, `invest`, `date`) VALUES ('$name', '$email', '$phone', '$city', '$business', '$invest', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
             mailPartner($con, $con->insert_id);
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}

if($_POST['type']==21){
    $email = $_POST['email'];
    $pass = $_POST['pass'];
   
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $pass1 = md5($pass);
    $ins_q = "UPDATE `users` SET `password`='".$pass1."' WHERE `email`='".$email."'";
    mysqli_query($con,"DELETE FROM `password_reset_temp` WHERE `email`='".$email."';");
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}
if($_POST['type']==20){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $service = $_POST['service'];
    $message = $_POST['message'];
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date('d-m-Y H:i:s');
    $ins_q = "INSERT INTO `service_form` (`name`, `email`, `phone`, `service`, `message`, `date`) VALUES ('$name', '$email', '$phone', '$service', '$message', '$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));
            //  mailService($con, $con->insert_id);
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    mysqli_close($con);
}

if($_POST['type']==25){
    $email = $_POST['email'];
    date_default_timezone_set('Asia/Kolkata');
    $c_date=  date( 'Y-m-d h:i:s', time ());
    
    $data_insert= "select * from subscribers where email='$email'";
    $query=mysqli_query($con,$data_insert);
    $data=mysqli_fetch_array($query);
    if(($data)!=true){
    $ins_q = "INSERT INTO `subscribers` (`email`,`date`) VALUES ('$email','$c_date')";
    $res =mysqli_query($con, $ins_q);
        if ($res) {
            echo json_encode(array("statusCode"=>200));	
        } 
        else {
            echo json_encode(array("statusCode"=>201));
        }
    }else{
        echo json_encode(array("statusCode"=>202));
    }
    mysqli_close($con);
}
?>