<?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)));
}

// print_r($_POST);die;

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    

    $client_id = sanitizeInput($_POST['client_id']);
    $description = sanitizeInput($_POST['description']);
    $follow_up_date = sanitizeInput($_POST['follow_up_date']);
    $status = sanitizeInput($_POST['status']);
    $created_by = $_SESSION['id'];

    if (isset($_GET['action'])) {
        $action = $_GET['action'];

        if ($action == 'add') {
            $sql = "INSERT INTO calls (client_id, description, follow_up_date, status, created_by, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "sssssss", $client_id, $description, $follow_up_date, $status, $created_by, $date, $date);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Calls added successfully.";
                    header("location: calls.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        }

        if ($action == 'edit') {
            $client_id = sanitizeInput($_POST['client_id']);
            $sql = "UPDATE calls SET name=?, phone=?, email=?, website=?, designation=?, documents=?, type=?, address=?, remarks=?, status=?, assigned_to=?, updated_at=? WHERE id=?";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "ssssssssssssi", $client_name, $phone, $email, $website,  $designation, $documents, $client_type, $address, $remarks, $status, $assigned_to, $date, $client_id);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Client updated successfully.";
                    header("location: calls.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            } else {
                echo "Error: " . mysqli_error($conn);
            }
        }

        if ($action == 'delete') {
            $client_id = sanitizeInput($_POST['client_id']);
            $sql = "DELETE FROM calls WHERE id=?";

            if ($stmt = mysqli_prepare($conn, $sql)) {
                mysqli_stmt_bind_param($stmt, "i", $client_id);

                if (mysqli_stmt_execute($stmt)) {
                    mysqli_stmt_close($stmt);
                    mysqli_close($conn);
                    $_SESSION['success_message'] = "Client deleted successfully.";
                    header("location: calls.php");
                    exit();
                } else {
                    echo "Error: " . mysqli_error($conn);
                }
            }
        }
    }
}
?>