<?php
session_start();
include 'Includes/db.php';
 // include'../compression.php';
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);
error_reporting(-1);


if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get form fields
    $name = $_POST['name'];
    $cname = $_POST['cname'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $address = $_POST['add'];
    $address = $_POST['add'];
    $pincode = $_POST['pincode'];
    $city = $_POST['city'];
    $whno = $_POST['wh_no'];
    $cat = $_POST['categorie'];
    $sub = isset($_POST['sub_categorie']) ? implode(",", $_POST['sub_categorie']) : '';
    $pak = $_POST['package'];
    $pass = $_POST['password'];
    $working_area = $_POST['working_area'];
    $executive_id = $_POST['executive_id'];

    

    // Dates
    $add_date = date("Y-m-d H:i:s");
    $end_date = date("Y-m-d H:i:s", strtotime("+30 days"));

     // Check for duplicate email or phone
     $check_query = "SELECT * FROM tbl_vendore WHERE email = '$email'";
     $check_result = mysqli_query($con, $check_query);
 
     if (mysqli_num_rows($check_result) > 0) {
         echo "<script>alert('You are already registered with this Email.'); window.location.href='signup.php';</script>";
         exit;
     }

    // Handle file uploads
    $profile_photo = $_FILES['profile_photo']['name'];
    $photo1 = $_FILES['photo1']['name'];
    $photo2 = $_FILES['photo2']['name'];

    // Create uploads folder if not exists
    if (!is_dir("uploads")) {
        mkdir("uploads", 0777, true);
    }

    move_uploaded_file($_FILES['profile_photo']['tmp_name'], "../vendor/" . $profile_photo);
    move_uploaded_file($_FILES['photo1']['tmp_name'], "../vendor/" . $photo1);
    move_uploaded_file($_FILES['photo2']['tmp_name'], "../vendor/" . $photo2);

    // Insert query (adjust table/column names to match your DB)
    $query = "INSERT INTO tbl_vendore 
    (name, cname, email, phone, executive_id, address, pincode, city, wh_no, profile_photo, photo1, photo2, categorie, sub_categorie, package, working_area, password, status)
    VALUES 
    ('$name', '$cname', '$email', '$phone', '$executive_id', '$address', '$pincode', '$city', '$whno', '$profile_photo', '$photo1', '$photo2', '$cat', '$sub', '$pak', '$working_area', '$pass', 0)";

   //  if (mysqli_query($con, $query)) {
   //      echo "<script>alert('Vendor Registered Successfully!'); window.location.href='pay.php';</script>";
   //  } 
   if (mysqli_query($con, $query)) {
      $_SESSION['vendor_id'] = mysqli_insert_id($con); // Save vendor ID for payment step
      echo "<script>window.location.href='view-vendor.php';</script>";
      exit;
  }
    else {
        echo "Error: " . mysqli_error($con);
    }
}
?>