<?php
session_start();
include 'database.php';
//print_r($_POST);
//print_r($_FILES["prescription"]["name"]);

if (isset($_POST["submit"])) {

    if ($_POST['centre'] == 0) {
        $_POST['address'] = $_POST['address'];
        $_POST['centre'] = "Home Collection";
    } else {
        $_POST['address'] = "";
        $_POST['centre'] = "Lab";
    }


    if ($_FILES['prescription']['name'][0] == "") {
        if ($_POST['payment'] == '1') {
            $insert = "INSERT INTO `inquerydetails`(`name`, `emailid`, `phone`, `testname`, `payment`, `centre`, `address`,`amount`, `date`, `time`,`userid`,`prescription`) VALUES ('" . $_POST["name"] . "','" . $_POST["email"] . "','" . $_POST["phone"] . "','" . $_POST["testname"] . "','Online','" . $_POST["centre"] . "','" . $_POST["address"] . "','','" . $_POST["date"] . "','" . $_POST["time"] . "','" . $_POST["userid"] . "','')";
            $result12 = mysqli_query($conn, $insert);
            $last_id = $conn->insert_id;
            $query = "SELECT * FROM inquerydetails where inqueryid=$last_id";
            $result = mysqli_query($conn, $query);
            $row = mysqli_fetch_assoc($result);
            $emailList = "leads@clientsnow.co.in";
            $headers .= "Bcc: " . $emailList . "\r\n";

            $body = "
                    		Hi Patho World ,
                    		You have one sample collection request
                    		Below are the details,
                    		Name =  " . $_POST["name"] . " 
                    		Email =  " . $_POST["email"] . "
                    		Phone =  " . $_POST["phone"] . " 
                    		Test =  " . $_POST["testname"] . "
                    		Centre = " . $_POST["centre"] . "
                    		Payment = " . $_POST["payment"] . "
                    		Address = " . $_POST["address"] . "
                    		Date = " . $_POST["date"] . "
                    		Time = " . $_POST["time"] . "
                    		Amount = " . $_POST["amount"] . "
                    		 ";
            //report@pathoworld.in
            mail("report@pathoworld.in", "Inquiry", $body, $headers);
            $_SESSION['MobileNo'] = $_SESSION['MobileNo'];
            $_SESSION['name'] = $_POST["name"];
            $_SESSION['email'] = $_POST["email"];
            $_SESSION['phone'] = $_POST["phone"];
            $_SESSION['testname'] = $_POST["testname"];
            $_SESSION['amount'] = $_POST["amount"];
            $_SESSION['inqueryid'] = $row["inqueryid"];
            header("Location:pay.php");
        }
        if ($_POST['payment'] == '0') {
            $insert = "INSERT INTO `inquerydetails`(`name`, `emailid`, `phone`, `testname`, `payment`, `centre`, `address`,`amount`, `date`, `time`,`userid`,`prescription`) VALUES ('" . $_POST["name"] . "','" . $_POST["email"] . "','" . $_POST["phone"] . "','" . $_POST["testname"] . "','offline','" . $_POST["centre"] . "','" . $_POST["address"] . "','','" . $_POST["date"] . "','" . $_POST["time"] . "','" . $_POST["userid"] . "','')";
            $result12 = mysqli_query($conn, $insert);
            $last_id = $conn->insert_id;
            $query = "SELECT * FROM inquerydetails where inqueryid=$last_id";
            $result = mysqli_query($conn, $query);
            $row = mysqli_fetch_assoc($result);
            $emailList = "leads@clientsnow.co.in";
            $headers .= "Bcc: " . $emailList . "\r\n";

            $body = "
                    		Hi Patho World ,
                    		You have one sample collection request
                    		Below are the details,
                    		Name =  " . $_POST["name"] . " 
                    		Email =  " . $_POST["email"] . "
                    		Phone =  " . $_POST["phone"] . " 
                    		Test =  " . $_POST["testname"] . "
                    		Centre = " . $_POST["centre"] . "
                    		Payment = " . $_POST["payment"] . "
                    		Address = " . $_POST["address"] . "
                    		Date = " . $_POST["date"] . "
                    		Time = " . $_POST["time"] . "
                    		Amount = " . $_POST["amount"] . "
                    		 ";
            //report@pathoworld.in
            mail("report@pathoworld.in", "Inquiry", $body, $headers);
            $_SESSION['MobileNo'] = $_SESSION['MobileNo'];
            $_SESSION['name'] = $_POST["name"];
            $_SESSION['email'] = $_POST["email"];
            $_SESSION['phone'] = $_POST["phone"];
            $_SESSION['testname'] = $_POST["testname"];
            $_SESSION['amount'] = $_POST["amount"];
            $_SESSION['inqueryid'] = $row["inqueryid"];
            header("Location:offlinepay.php");
        }
    } else {
        //file exist
        // echo 'exist';
        //payment 1
        if ($_POST['payment'] == '1') {
            $targetDir = "file/";
            $allowTypes = array('jpg', 'png', 'jpeg', 'docx');
            // Looping over all files
            for ($i = 0; $i < count($_FILES['prescription']['name']); $i++) {
                $filename = $_FILES['prescription']['name'][$i];
                $targetFilePath = $targetDir . $filename;

                // Check whether file type is valid 
                $fileType = pathinfo($targetFilePath, PATHINFO_EXTENSION);
                if (in_array($fileType, $allowTypes)) {
                    // Upload files and store in database
                    if (move_uploaded_file($_FILES["prescription"]["tmp_name"][$i], 'file/' . $filename)) {
                        // Image db insert sql
                        // $insert = "INSERT into files(file_name,uploaded_on,status) values('$filename',now(),1)";
                        $insert = "INSERT INTO `inquerydetails`(`name`, `emailid`, `phone`, `testname`, `payment`, `centre`, `address`,`amount`, `date`, `time`,`userid`,`prescription`) VALUES ('" . $_POST["name"] . "','" . $_POST["email"] . "','" . $_POST["phone"] . "','" . $_POST["testname"] . "','Online','" . $_POST["centre"] . "','" . $_POST["address"] . "','','" . $_POST["date"] . "','" . $_POST["time"] . "','" . $_POST["userid"] . "','" . $filename . "')";
                        $result12 = mysqli_query($conn, $insert);
                        $last_id = $conn->insert_id;
                        $query = "SELECT * FROM inquerydetails where inqueryid=$last_id";
                        $result = mysqli_query($conn, $query);
                        $row = mysqli_fetch_assoc($result);
                    }
                }
            }
            $emailList = "leads@clientsnow.co.in";
            $headers .= "Bcc: " . $emailList . "\r\n";

            $body = "
                    		Hi Patho World ,
                    		You have one sample collection request
                    		Below are the details,
                    		Name =  " . $_POST["name"] . " 
                    		Email =  " . $_POST["email"] . "
                    		Phone =  " . $_POST["phone"] . " 
                    		Test =  " . $_POST["testname"] . "
                    		Centre = " . $_POST["centre"] . "
                    		Payment = " . $_POST["payment"] . "
                    		Address = " . $_POST["address"] . "
                    		Date = " . $_POST["date"] . "
                    		Time = " . $_POST["time"] . "
                    		Amount = " . $_POST["amount"] . "
                    		 ";
            //report@pathoworld.in
            mail("report@pathoworld.in", "Inquiry", $body, $headers);
            $_SESSION['MobileNo'] = $_SESSION['MobileNo'];
            $_SESSION['name'] = $_POST["name"];
            $_SESSION['email'] = $_POST["email"];
            $_SESSION['phone'] = $_POST["phone"];
            $_SESSION['testname'] = $_POST["testname"];
            $_SESSION['amount'] = $_POST["amount"];
            $_SESSION['inqueryid'] = $row["inqueryid"];
            header("Location:pay.php");
        }

        //payment 0

        if ($_POST['payment'] == '0') {

            // Image db insert sql
            // $insert = "INSERT into files(file_name,uploaded_on,status) values('$filename',now(),1)";
            $insert = "INSERT INTO `inquerydetails`(`name`, `emailid`, `phone`, `testname`, `payment`, `centre`, `address`,`amount`, `date`, `time`,`userid`,`prescription`) VALUES ('" . $_POST["name"] . "','" . $_POST["email"] . "','" . $_POST["phone"] . "','" . $_POST["testname"] . "','Offline','" . $_POST["centre"] . "','" . $_POST["address"] . "','','" . $_POST["date"] . "','" . $_POST["time"] . "','" . $_POST["userid"] . "','" . $filename . "')";
            $result12 = mysqli_query($conn, $insert);
            $last_id = $conn->insert_id;
            $query = "SELECT * FROM inquerydetails where inqueryid=$last_id";
            $result = mysqli_query($conn, $query);
            $row = mysqli_fetch_assoc($result);

            $emailList = "leads@clientsnow.co.in";
            $headers .= "Bcc: " . $emailList . "\r\n";

            $body = "
        		Hi Patho World ,
        		You have one sample collection request
        		Below are the details,
        		Name =  " . $_POST["name"] . " 
        		Email =  " . $_POST["email"] . "
        		Phone =  " . $_POST["phone"] . " 
        		Test =  " . $_POST["testname"] . "
        		Centre = " . $_POST["centre"] . "
        		Payment = " . $_POST["payment"] . "
        		Address = " . $_POST["address"] . "
        		Date = " . $_POST["date"] . "
        		Time = " . $_POST["time"] . "
        		Amount = " . $_POST["amount"] . "
        		 ";
            //report@pathoworld.in
            mail("report@pathoworld.in", "Inquiry", $body, $headers);
            $_SESSION['MobileNo'] = $_SESSION['MobileNo'];
            $_SESSION['name'] = $_POST["name"];
            $_SESSION['email'] = $_POST["email"];
            $_SESSION['phone'] = $_POST["phone"];
            $_SESSION['testname'] = $_POST["testname"];
            $_SESSION['amount'] = $_POST["amount"];
            $_SESSION['inqueryid'] = $row["inqueryid"];
            header("Location:offlinepay.php");
        }
    }
}
?>
<!doctype html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="Robots" content="all">
    <meta name="Googlebot" content="index, follow">
    <meta name="Yahoobot" content="Index, Follow">
    <meta name="MSNbot" content="index, follow">
    <meta name="allow-search" content="yes">
    <meta name="robots" content="Index, Follow">
    <meta name="rating" content="General">
    <meta name="author" content="patho World">
    <meta name="language" content="EN">
    <meta name="document-type" content="Public">
    <meta name="publisher" content="clientsnow.in">
    <meta name="document-rating" content="Safe for Kids">
    <meta name="document-distribution" content="Global">
    <!-- Bootstrap Min CSS -->
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <!-- Animate Min CSS -->
    <link rel="stylesheet" href="assets/css/animate.min.css">
    <!-- FontAwesome Min CSS -->
    <link rel="stylesheet" href="assets/css/fontawesome.min.css">
    <!-- Flaticon CSS -->
    <link rel="stylesheet" href="assets/css/flaticon.css">
    <!-- Magnific Popup Min CSS -->
    <link rel="stylesheet" href="assets/css/magnific-popup.min.css">
    <!-- niceSelect CSS -->
    <!--<link rel="stylesheet" href="assets/css/nice-select.css">-->
    <!-- Odometer Min CSS -->
    <link rel="stylesheet" href="assets/css/odometer.min.css">
    <!-- MeanMenu CSS -->
    <link rel="stylesheet" href="assets/css/meanmenu.css">
    <!-- Owl Carousel Min CSS -->
    <link rel="stylesheet" href="assets/css/owl.carousel.min.css">
    <!-- Progressbar Min CSS -->
    <link rel="stylesheet" href="assets/css/progressbar.min.css">
    <!-- Style CSS -->
    <link rel="stylesheet" href="assets/css/style.css">
    <!-- Responsive CSS -->
    <link rel="stylesheet" href="assets/css/responsive.css">
    <title>Appointment</title>
    <link rel="icon" type="image/png" href="assets/img/favicon.png">
    <!-- plugin css for this page -->
    <link rel="stylesheet" href="assets/vendors/select2/select2.min.css">
    <link rel="stylesheet" href="assets/vendors/select2-bootstrap-theme/select2-bootstrap.min.css">
    <!-- End plugin css for this page -->
    <!-- Global site tag (gtag.js) - Google Analytics -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-138278072-51"></script>
    <script>
        window.dataLayer = window.dataLayer || [];

        function gtag() {
            dataLayer.push(arguments);
        }
        gtag('js', new Date());

        gtag('config', 'UA-138278072-51');
    </script>

    <!-- Global site tag (gtag.js) - Google Ads: 10884371105 -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=AW-10884371105"></script>
    <script>
        window.dataLayer = window.dataLayer || [];

        function gtag() {
            dataLayer.push(arguments);
        }
        gtag('js', new Date());
        gtag('config', 'AW-10884371105');
    </script>
    <script type="text/javascript">
        (function(c, l, a, r, i, t, y) {
            c[a] = c[a] || function() {
                (c[a].q = c[a].q || []).push(arguments)
            };
            t = l.createElement(r);
            t.async = 1;
            t.src = "https://www.clarity.ms/tag/" + i;
            y = l.getElementsByTagName(r)[0];
            y.parentNode.insertBefore(t, y);
        })(window, document, "clarity", "script", "l8rz3aztvj");
    </script>
    <link rel="canonical" id="canonicalTag" href=" ">
    <script>
        var currentURL = window.location.href;
        document.getElementById('canonicalTag').setAttribute('href', currentURL);
    </script>
</head>

<body>
    <!-- Start Navbar Area -->
    <?php include 'header.php'; ?>
    <!-- End Navbar Area -->
    <!-- Start Product Details Area -->
    <section class="product-details-area ptb-120">
        <div class="container">
            <h3>Book Your Appointment</h3>
            <?php
            include 'database.php';
            $querys = "SELECT * from userregistration where MobileNo=" . $_SESSION['MobileNo'];
            //  print_r($query);
            $results = mysqli_query($conn, $querys);
            $row = mysqli_fetch_assoc($results);

            //      $query112 = "SELECT * FROM healthpackagesprofile where healthpackagesprofileid=".$_POST['hid'];  
            //   print_r($query112);
            //     $result1s = mysqli_query($conn,$query112);
            //     $row1=mysqli_fetch_assoc($result1s);

            ?>
            <div class="appointment-form">
                <form method="POST" action="" enctype="multipart/form-data">
                    <div class="row">
                        <?php echo $msg ?>
                        <div class="col-md-6">
                            <input type="hidden" class="form-control" name="userid" value="<?php echo $row['userid'] ?>">
                            <input type="hidden" class="form-control" name="amount" value="<?php echo $_POST['amount'] ?>">
                            <div class="form-group">
                                <label>Name</label>
                                <input type="text" class="form-control" name="name" value="<?php echo $row['Name'] ?>" readonly>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Email-id</label>
                                <input type="email" class="form-control" name="email">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Contact No</label>
                                <input type="text" class="form-control" name="phone" value="<?php echo $_SESSION['MobileNo'] ?>" readonly>
                            </div>
                        </div>

                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Test</label>
                                <input type="text" class="form-control" name="testname" value="<?php echo $_POST['testname'] ?>">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Appointment Date</label>
                                <input type="date" class="form-control" name="date" id="txtdate" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Appointment Time</label>
                                <select name="time" list="time2" class="form-control">
                                    <option value="09:00:00">09:00 am</option>
                                    <option value="11:00:00">11:00 am</option>
                                    <option value="13:00:00">01:00 pm</option>
                                    <option value="15:00:00">03:00 pm</option>
                                    <option value="17:00:00">05:00 pm</option>
                                    <option value="19:00:00">07:00 pm</option>
                                    <option value="21:00:00">09:00 pm</option>
                                </select>
                            </div>
                        </div>

                        <div class="col-6">
                            <div class="form-group">
                                <label>Payment Via</label>
                                <input type="radio" name="payment" id="onn" value="1">
                                <label>Online</label>

                                <input type="radio" name="payment" id="off" value="0">
                                <label>Cash</label>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="form-group">
                                <label>Test Location</label>
                                <input type="radio" name="centre" id="centre" value="1">
                                <label>Lab</label>

                                <input type="radio" name="centre" id="centre1" value="0">
                                <label>Home Collection</label>
                            </div>
                            <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
                            <div class="div_entrega_outro">
                                <textarea name="address" class="form-control"></textarea>
                            </div>
                            <script>
                                $('.div_entrega_outro').hide();
                                $("input[id$='centre1']").click(function() {
                                    $('.div_entrega_outro').show();
                                });

                                $("input[id$='centre']").click(function() {
                                    $('.div_entrega_outro').hide();
                                });
                            </script>

                        </div>
                        <div class="col-md-6 uploadprep">
                            <div class="form-group">
                                <label>Upload Prescription <spam style="color:red">(Optional)</spam></label>
                                <input type="file" class="form-control" name="prescription[]" id="prescription" multiple>
                            </div>
                        </div>
                        <script>
                            ///radio prepupload
                            $('.uploadprep').hide();

                            $("input[id$='off']").click(function() {
                                $('.uploadprep').hide();
                            });

                            $("input[id$='onn']").click(function() {
                                $('.uploadprep').show();
                            });
                        </script>
                    </div>
                    <div class="col-2">
                        <input type="submit" name="submit" class="btn btn-primary" value="Book Appointment">
                    </div>
                </form>
            </div>
        </div>
    </section>
    <script>
        $(function() {
            var dtToday = new Date();

            var month = dtToday.getMonth() + 1;
            var day = dtToday.getDate();
            var year = dtToday.getFullYear();
            if (month < 10)
                month = '0' + month.toString();
            if (day < 10)
                day = '0' + day.toString();

            var minDate = year + '-' + month + '-' + day;

            $('#txtdate').attr('min', minDate);
        });
    </script>
    <!-- End Product Details Area -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="assets/vendors/select2/select2.min.js"></script>
    <script src="assets/vendors/typeahead.js/typeahead.bundle.min.js"></script>
    <script src="assets/vendors/js/typeahead.js"></script>
    <script src="assets/vendors/select2.js"></script>
    <!-- Start Footer Area -->
    <?php include 'footer.php'; ?>
    <!-- End Footer Area -->
</body>

</html>