<?php
session_start();
require_once "config.php";
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
// Function to sanitize input
function sanitizeInput($input) {
    return htmlspecialchars(strip_tags(trim($input)));
}


if ($_SERVER["REQUEST_METHOD"] == "POST") {
    
    
    $vname = sanitizeInput($_POST['vname']);
    $cname = sanitizeInput($_POST['cname']);
    $email = sanitizeInput($_POST['email']);
    $mobile = sanitizeInput($_POST['mobile']);
    $address = sanitizeInput($_POST['address']);
    $pan = sanitizeInput($_POST['pan']);
    $status = sanitizeInput($_POST['status']);
    
   
    if (isset($_GET['action'])) {
        $action = $_GET['action'];

        if ($action == 'add') {
            
            $sql = "INSERT INTO  vendors (name, company_name, email, phone, pan, address, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
            
            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "sssssssss", $vname, $cname, $email, $mobile, $address, $pan, $status, $date, $date);
                
                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Vendor added successfully.";
                    header("location: vendor.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        } 
        
        if ($action == 'edit') {

           $vendor_id = sanitizeInput($_POST['vendor_id']); 

            $sql = "UPDATE vendors SET name=?, company_name=?, email=?, phone=?, pan=?, address=?, status=?, updated_at=? WHERE id=?";
            
            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "ssssssssi", $vname, $cname, $email, $mobile, $pan, $address, $status, $date, $vendor_id);
                
                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Vendor updated successfully.";
                    header("location: vendor.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        }
        
        if ($action == 'delete') {
            $vendor_id = sanitizeInput($_POST['delete_id']); 
            $sql = "DELETE FROM vendors WHERE vendor_id=?";
            
            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "i", $vendor_id);
                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    header("Location: branch.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            }
        }
    }
    else{
        
    }
}
?>