<?php

include_once('include/head.php');

?>

<body>

<div class="main-page-wrapper">

<?php include_once('include/header.php'); ?>


<?php

/* =========================================================
   INITIAL VARIABLES
========================================================= */

$slug = isset($_GET['slug']) ? trim($_GET['slug']) : '';

$tid = '';
$p_id = '';
$p_name = '';
$p_description23 = '';
$p_short_description23 = '';
$img = '';

$contact_success = '';
$contact_error = '';

$name = '';
$phone = '';
$email = '';
$message = '';


/* =========================================================
   GET PRODUCT USING SLUG
========================================================= */

if ($slug == '') {

    header("Location: " . path() . "/404.php");
    exit;

}

$slug_safe = mysqli_real_escape_string($conn, $slug);

$query = mysqli_query(
    $conn,
    "SELECT *
     FROM tbl_product
     WHERE slug = '$slug_safe'
     LIMIT 1"
);


/* =========================================================
   PRODUCT NOT FOUND
========================================================= */

if (!$query || mysqli_num_rows($query) == 0) {

    header("Location: " . path() . "/404.php");
    exit;

}


/* =========================================================
   GET PRODUCT DATA
========================================================= */

$record = mysqli_fetch_assoc($query);

$tid = $record['p_id'];

$p_id = $record['p_id'];

$p_name = $record['p_name'];

$p_description23 = $record['p_description'];

$p_short_description23 = $record['p_short_description'];


/* =========================================================
   GET PRODUCT IMAGE
========================================================= */

$p_id_safe = mysqli_real_escape_string($conn, $p_id);

$photo = mysqli_query(
    $conn,
    "SELECT *
     FROM tbl_product_photo
     WHERE p_id = '$p_id_safe'
     LIMIT 1"
);

if ($photo && mysqli_num_rows($photo) > 0) {

    $rok = mysqli_fetch_assoc($photo);

    $img = $rok['photo'];

}


/* =========================================================
   ENQUIRY FORM SUBMISSION
========================================================= */

if (isset($_POST['submit_contact'])) {

    $name = trim($_POST['name'] ?? '');

    $phone = trim($_POST['phone'] ?? '');

    $email = trim($_POST['email'] ?? '');

    /*
     * Message is optional
     */
    $message = trim($_POST['message'] ?? '');


    /* =====================================================
       VALIDATION
    ===================================================== */

    if ($name == '') {

        $contact_error = 'Please enter your name.';

    } elseif ($phone == '') {

        $contact_error = 'Please enter your phone number.';

    } elseif ($email == '') {

        $contact_error = 'Please enter your email address.';

    } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {

        $contact_error = 'Please enter a valid email address.';

    } else {


        /* =================================================
           PRODUCT AUTOMATICALLY FROM CURRENT SLUG
        ================================================= */

        $product = $p_name;


        /* =================================================
           ADD INFO
        ================================================= */

        $add_info = "Product: " . $product;

        if ($message != '') {

            $add_info .= "\nMessage: " . $message;

        }


        /* =================================================
           ESCAPE DATA
        ================================================= */

        $name_safe = mysqli_real_escape_string(
            $conn,
            $name
        );

        $phone_safe = mysqli_real_escape_string(
            $conn,
            $phone
        );

        $email_safe = mysqli_real_escape_string(
            $conn,
            $email
        );

        $add_info_safe = mysqli_real_escape_string(
            $conn,
            $add_info
        );


        /* =================================================
           REQUIRED DATABASE FIELD
           
           cust_b_lname is NOT NULL in your table.
           We don't have this field in the form,
           so save an empty value.
        ================================================= */

        $cust_b_lname = '';

        $cust_b_lname_safe = mysqli_real_escape_string(
            $conn,
            $cust_b_lname
        );


        /* =================================================
           DATE + STATUS
        ================================================= */

        $cust_datetime = date('Y-m-d H:i:s');

        $cust_status = 1;


        /* =================================================
           INSERT INTO tbl_customer
        ================================================= */

        $insert_sql = "
            INSERT INTO tbl_customer
            (
                cust_name,
                cust_email,
                cust_phone,
                cust_b_lname,
                add_info,
                cust_datetime,
                cust_status
            )
            VALUES
            (
                '$name_safe',
                '$email_safe',
                '$phone_safe',
                '$cust_b_lname_safe',
                '$add_info_safe',
                '$cust_datetime',
                '$cust_status'
            )
        ";

             include_once('send_mail.php');

    }

}

?>


<style>

.product-enquiry-box {
    padding: 25px;
    background: #fff;
    border: 1px solid #eee;
    box-shadow: 0 10px 35px rgba(0, 0, 0, 0.08);
}

.product-enquiry-box h3 {
    font-size: 28px;
    font-weight: 700;
    color: #222;
}

.product-enquiry-form .form-control {
    width: 100%;
    height: 40px;
    border: 1px solid #ddd;
    border-radius: 4px;
    padding: 0 16px;
    font-size: 15px;
    color: #222 !important;
    background: #fff;
}

.w-100 {
    border-radius: 10px;
}

.product-enquiry-form textarea.form-control {
    height: 100px;
    padding: 15px 16px;
    resize: vertical;
}

.product-enquiry-form .form-control:focus {
    border-color: #ff6f01;
    box-shadow: 0 0 0 3px rgba(255, 111, 1, 0.08);
    outline: none;
}

.product-enquiry-form .form-control::placeholder {
    color: #555 !important;
    opacity: 1 !important;
}

.product-enquiry-form button {
    min-width: 170px;
    height: 52px;
    color: #fff;
    font-weight: 600;
    border-radius: 4px;
}

.product-enquiry-success {
    padding: 12px 15px;
    margin-bottom: 20px;
    background: #eaf8ee;
    border: 1px solid #b9e7c6;
    color: #217a35;
    border-radius: 4px;
    font-size: 14px;
}

.product-enquiry-error {
    padding: 12px 15px;
    margin-bottom: 20px;
    background: #fff1f1;
    border: 1px solid #f0bcbc;
    color: #c62828;
    border-radius: 4px;
    font-size: 14px;
}

@media (max-width: 767px) {

    .product-enquiry-box {
        padding: 25px 20px;
        margin-top: 20px;
    }

    .product-enquiry-box h3 {
        font-size: 24px;
    }

}

</style>


<main>


<!-- =====================================================
     PAGE TITLE
====================================================== -->

<div
    class="page-title-area text-center pt-100 pb-100 pt-lg-130 pb-lg-130"
    data-background="assets/img/bg/main-bg.png">

    <div class="container">

        <h2 class="page-title mb-15">

            <?php
            echo htmlspecialchars(
                $p_name,
                ENT_QUOTES,
                'UTF-8'
            );
            ?>

        </h2>

    </div>

</div>


<!-- =====================================================
     SERVICE DETAILS SECTION
====================================================== -->

<div class="service-details-section pt-150 pt-lg-100 pb-95 pb-lg-60">

    <div class="container">

        <div class="row">

            <div class="col-lg-12 ps-xxl-5">

                <div class="service-details-content mb-60">


                    <!-- =================================================
                         PRODUCT IMAGE + ENQUIRY FORM
                    ================================================== -->

                    <div class="row align-items-center">


                        <!-- =================================================
                             LEFT - PRODUCT IMAGE
                        ================================================== -->

                        <div class="col-md-6">

                            <div class="img-box mb-30">

                                <?php if ($img != '') { ?>

                                    <img
                                        class="w-100"
                                        src="<?php path(); ?>/admin/assets/images/product-image/<?php echo htmlspecialchars($img, ENT_QUOTES, 'UTF-8'); ?>"
                                        alt="<?php echo htmlspecialchars($p_name, ENT_QUOTES, 'UTF-8'); ?>">

                                <?php } ?>

                            </div>

                        </div>


                        <!-- =================================================
                             RIGHT - ENQUIRY FORM
                        ================================================== -->

                        <div class="col-md-6">

                            <div class="product-enquiry-box">


                                <h3 class="mb-20">
                                    Enquire Now
                                </h3>


                                <!-- =================================================
                                     SUCCESS MESSAGE
                                ================================================== -->

                                <?php if ($contact_success != '') { ?>

                                    <div class="product-enquiry-success">

                                        <?php
                                        echo htmlspecialchars(
                                            $contact_success,
                                            ENT_QUOTES,
                                            'UTF-8'
                                        );
                                        ?>

                                    </div>

                                <?php } ?>


                                <!-- =================================================
                                     ERROR MESSAGE
                                ================================================== -->

                                <?php if ($contact_error != '') { ?>

                                    <div class="product-enquiry-error">

                                        <?php
                                        echo htmlspecialchars(
                                            $contact_error,
                                            ENT_QUOTES,
                                            'UTF-8'
                                        );
                                        ?>

                                    </div>

                                <?php } ?>


                                <!-- =================================================
                                     ENQUIRY FORM
                                ================================================== -->

                                <form
                                    method="POST"
                                    action=""
                                    class="product-enquiry-form">


                                    <div class="row">


                                        <!-- NAME -->

                                        <div class="col-md-6 mb-3">

                                            <input
                                                type="text"
                                                name="name"
                                                class="form-control"
                                                placeholder="Name"
                                                value="<?php echo htmlspecialchars($name, ENT_QUOTES, 'UTF-8'); ?>"
                                                required>

                                        </div>


                                        <!-- PHONE -->

                                        <div class="col-md-6 mb-3">

                                            <input
                                                type="text"
                                                name="phone"
                                                class="form-control phone"
                                                placeholder="Phone"
                                                value="<?php echo htmlspecialchars($phone, ENT_QUOTES, 'UTF-8'); ?>"
                                                required>

                                        </div>


                                        <!-- EMAIL -->

                                        <div class="col-md-6 mb-3">

                                            <input
                                                type="email"
                                                name="email"
                                                class="form-control"
                                                placeholder="Email"
                                                value="<?php echo htmlspecialchars($email, ENT_QUOTES, 'UTF-8'); ?>"
                                                required>

                                        </div>


                                        <!-- =================================================
                                             PRODUCT
                                             AUTOMATIC FROM CURRENT SLUG
                                        ================================================== -->

                                        <div class="col-md-6 mb-3">

                                            <input
                                                type="text"
                                                class="form-control"
                                                value="<?php echo htmlspecialchars($p_name, ENT_QUOTES, 'UTF-8'); ?>"
                                                readonly>

                                        </div>


                                        <!-- =================================================
                                             MESSAGE - OPTIONAL
                                        ================================================== -->

                                        <div class="col-md-12 mb-3">

                                            <textarea
                                                name="message"
                                                class="form-control"
                                                rows="5"
                                                placeholder="Message"><?php echo htmlspecialchars($message, ENT_QUOTES, 'UTF-8'); ?></textarea>

                                        </div>
                                        
                                        <div class="g-recaptcha form-group col-md-12 mb-3" data-sitekey="6LdWhb8qAAAAABZO-gA6yiy-qRXSflpUAnbAQtgt"></div>



                                        <!-- SUBMIT -->

                                        <div class="col-md-12">

                                            <button
                                                type="submit"
                                                name="submit_contact"
                                                class="btn btn-brand"
                                                style="background:#ff6f01; border-color:#ff6f01;">

                                                Send

                                                <i class="bi bi-arrow-right"></i>

                                            </button>

                                        </div>


                                    </div>

                                </form>


                            </div>

                        </div>

                    </div>


                    <!-- =================================================
                         PRODUCT DESCRIPTION
                    ================================================== -->

                    <p>

                        <?php echo $p_description23; ?>

                    </p>


                </div>

            </div>

        </div>

    </div>

</div>


</main>


<?php include_once('include/footer.php'); ?>


</div>

</body>

</html>