<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Doctor Appointment</title>
    <link rel="stylesheet" href="../CSS/hospital.css">
    <link
        href="https://fonts.googleapis.com/css2?family=Abril+Fatface&family=Catamaran:wght@200&family=Courgette&family=Dancing+Script:wght@700&family=Edu+TAS+Beginner:wght@700&family=Lato:wght@300;900&family=Mukta:wght@700&family=Mulish:wght@300&family=Open+Sans&family=PT+Sans:ital,wght@1,700&family=Poppins:wght@300&family=Raleway:wght@100&family=Roboto&family=Roboto+Condensed:wght@700&family=Roboto+Slab&display=swap"
        rel="stylesheet">
    <script src="https://kit.fontawesome.com/f30fac2c61.js" crossorigin="anonymous"></script>
    <link rel="stylesheet" href="../css/animations.css">
    <link rel="stylesheet" href="../css/main.css">
    
    <style>
        .popup {
            animation: transitionIn-Y-bottom 0.5s;
        }

        .main {
            animation: transitionIn-Y-bottom 0.75s;
        }
    </style>


</head>

<body>
<?php

//learn from w3schools.com

session_start();

if(isset($_SESSION["user"])){
    if(($_SESSION["user"])=="" or $_SESSION['usertype']!='p'){
        header("location: ../login.php");
    }else{
        $useremail=$_SESSION["user"];
    }

}else{
    header("location: ../login.php");
}


//import database
include("../connection.php");
$userrow = $database->query("select * from patient where pemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["pid"];
$username=$userfetch["pname"];


//echo $userid;
//echo $username;


$sqlmain= "select appointment.appoid,schedule.scheduleid,schedule.title,doctor.docname,patient.pname,schedule.scheduledate,schedule.scheduletime,appointment.apponum,appointment.appodate from schedule inner join appointment on schedule.scheduleid=appointment.scheduleid inner join patient on patient.pid=appointment.pid inner join doctor on schedule.docid=doctor.docid  where  patient.pid=$userid ";

if($_POST){
    //print_r($_POST);
    


    
    if(!empty($_POST["sheduledate"])){
        $sheduledate=$_POST["sheduledate"];
        $sqlmain.=" and schedule.scheduledate='$sheduledate' ";
    };



    //echo $sqlmain;

}

$sqlmain.="order by appointment.appodate  asc";
$result= $database->query($sqlmain);
?>

    <div class="container">
        <nav>
            <div class="logo">
                <h1>Doc Appointment</h1>
            </div>
            <i id="bar" class="fa-solid fa-bars"></i>
            <ul>
                <li><a href="../patient/index.php">Home</a></li>
                <li><a href="../patient/appointment.php"><b><u>Appointments</u></b></a></li>
                <li><a href="../patient/doctor.php">Doctors</a></li>
                <li><a href="../patient/session.php">Sessions</a></li>
                <li><a href="..\patient\profile.php">Profile</a></li>
                <li>
                    <p class="profile-title" style="text-align:center;text-transform:uppercase;"><b>
                            <?php echo substr($username, 0, 13) ?>
                    </p></b>
                    <!-- <p class="profile-subtitle"><b><?php echo substr($useremail, 0, 22) ?></p></b> -->
                </li>



                <li>


                    <a href="../logout.php">
                        <button class="btn">Log out</button>
                    </a>
                </li>
                <li>
                    <p style="font-size: 14px;color:black;padding: 0;margin: 0;text-align: right;">
                        Today's Date
                    </p>
                    <p class="heading-sub12" style="padding: 0;margin: 0; font-weight:bold">
                        <?php
                        date_default_timezone_set('Asia/Kolkata');

                        $date = date('Y-m-d');
                        echo $date;
                        ?>
                    </p>
                </li>



            </ul>
        </nav>
        <div class="container">
            <div class="main" style="display:block; margin-top: 25px;">
                <Br><br>


                <div class="dash-body">
                    <table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;margin-top:25px; ">
                        <tr>
                            <td width="13%">
                                <a href="appointment.php"><button class="login-btn btn-primary-soft btn btn-icon-back"
                                        style="padding-top:11px;padding-bottom:11px;margin-left:20px;width:125px">
                                        <font class="tn-in-text">Back</font>
                                    </button></a>
                            </td>
                            <td>
                                <p style="font-size: 23px;padding-left:12px;font-weight: 600;">My Bookings history :</p>

                            </td>
                            <?php

                            date_default_timezone_set('Asia/Kolkata');

                            $today = date('Y-m-d');



                            ?>



                        </tr>

                        <!-- <tr>
                    <td colspan="4" >
                        <div style="display: flex;margin-top: 40px;">
                        <div class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49);margin-top: 5px;">Schedule a Session</div>
                        <a href="?action=add-session&id=none&error=0" class="non-style-link"><button  class="login-btn btn-primary btn button-icon"  style="margin-left:25px;background-image: url('../img/icons/add.svg');">Add a Session</font></button>
                        </a>
                        </div>
                    </td>
                </tr> -->
                        <tr><br>
                            <td colspan="4" style="padding-top:10px;width: 100%;">

                                <p class="heading-main12"
                                    style="margin-left: 110px;font-size:18px;color:rgb(249, 249, 249);font-weight:bold;">My Bookings (<?php echo $result->num_rows; ?>)
                                </p>
                                <br>
                            </td>

                        </tr><br>
                        <tr>
                            <td colspan="4" style="padding-top:0px;width: 100%;">
                                <center>
                                    <table class="filter-container" border="0" style="border:0px;">
                                        <tr>
                                           
                                            <td width="5%" style="text-align: center;">
                                                Date:
                                            </td>
                                            <td width="30%">
                                                <form action="" method="post">

                                                    <input type="date" name="sheduledate" id="date"
                                                        class="input-text filter-container-items"
                                                        style="margin: 0;width: 95%;">

                                            </td>

                                            <td width="12%">
                                                <input type="submit" name="filter" value=" Filter"
                                                    class=" btn-primary-soft btn button-icon btn-filter"
                                                    style="padding: 15px; margin :0;width:80%">
                                                </form>
                                            </td>

                                        </tr>
                                    </table>

                                </center>
                            </td>

                        </tr>



                        <tr>
                            <td colspan="4">
                                <center>
                                    <div class="abc scroll">
                                        <table width="93%" class="sub-table scrolldown" border="0" style="border:none">

                                            <tbody>

                                                <?php




                                                if ($result->num_rows == 0) {
                                                    echo '<tr>
                                    <td colspan="7">
                                    <br><br><br><br>
                                    <center>
                                    <img src="../img/notfound.svg" width="25%">
                                    
                                    <br>
                                    <p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We  couldnt find anything related to your keywords !</p>
                                    <a class="non-style-link" href="appointment.php"><button  class="login-btn btn-primary-soft btn"  style="display: flex;justify-content: center;align-items: center;margin-left:20px;">&nbsp; Show all Appointments &nbsp;</font></button>
                                    </a>
                                    </center>
                                    <br><br><br><br>
                                    </td>
                                    </tr>';

                                                } else {

                                                    for ($x = 0; $x < ($result->num_rows); $x++) {
                                                        echo "<tr>";
                                                        for ($q = 0; $q < 3; $q++) {
                                                            $row = $result->fetch_assoc();
                                                            if (!isset ($row)) {
                                                                break;
                                                            }
                                                            ;
                                                            $scheduleid = $row["scheduleid"];
                                                            $title = $row["title"];
                                                            $docname = $row["docname"];
                                                            $scheduledate = $row["scheduledate"];
                                                            $scheduletime = $row["scheduletime"];
                                                            $apponum = $row["apponum"];
                                                            $appodate = $row["appodate"];
                                                            $appoid = $row["appoid"];

                                                            if ($scheduleid == "") {
                                                                break;
                                                            }

                                                            echo '
                                            <td style="width: 25%;">
                                                    <div  class="dashboard-items search-items"  >
                                                    
                                                        <div style="width:100%;">
                                                        <div class="h3-search">
                                                                    Booking Date: ' . substr($appodate, 0, 30) . '<br>
                                                                    Reference Number: OC-000-' . $appoid . '
                                                                </div>
                                                                <div class="h1-search">
                                                                    ' . substr($title, 0, 21) . '<br>
                                                                </div>
                                                                <div class="h3-search">
                                                                    Appointment Number:<div class="h1-search">0' . $apponum . '</div>
                                                                </div>
                                                                <div class="h3-search">
                                                                    ' . substr($docname, 0, 30) . '
                                                                </div>
                                                                
                                                                
                                                                <div class="h4-search">
                                                                    Scheduled Date: ' . $scheduledate . '<br>Starts: <b>@' . substr($scheduletime, 0, 5) . '</b> (24h)
                                                                </div>
                                                                <br>
                                                                <a href="?action=drop&id=' . $appoid . '&title=' . $title . '&doc=' . $docname . '" ><button  class="login-btn btn-primary-soft btn "  style="padding-top:11px;padding-bottom:11px;width:100%"><font class="tn-in-text">Cancel Booking</font></button></a>
                                                        </div>
                                                                
                                                    </div>
                                                </td>';

                                                        }
                                                        echo "</tr>";

                                                        // for ( $x=0; $x<$result->num_rows;$x++){
                                                        //     $row=$result->fetch_assoc();
                                                        //     $appoid=$row["appoid"];
                                                        //     $scheduleid=$row["scheduleid"];
                                                        //     $title=$row["title"];
                                                        //     $docname=$row["docname"];
                                                        //     $scheduledate=$row["scheduledate"];
                                                        //     $scheduletime=$row["scheduletime"];
                                                        //     $pname=$row["pname"];
                                                        //     
                                                        //     
                                                        //     echo '<tr >
                                                        //         <td style="font-weight:600;"> &nbsp;'.
                                                
                                                        //         substr($pname,0,25)
                                                        //         .'</td >
                                                        //         <td style="text-align:center;font-size:23px;font-weight:500; color: var(--btnnicetext);">
                                                        //         '.$apponum.'
                                                
                                                        //         </td>
                                                        //         <td>
                                                        //         '.substr($title,0,15).'
                                                        //         </td>
                                                        //         <td style="text-align:center;;">
                                                        //             '.substr($scheduledate,0,10).' @'.substr($scheduletime,0,5).'
                                                        //         </td>
                                                
                                                        //         <td style="text-align:center;">
                                                        //             '.$appodate.'
                                                        //         </td>
                                                
                                                        //         <td>
                                                        //         <div style="display:flex;justify-content: center;">
                                                
                                                        //         <!--<a href="?action=view&id='.$appoid.'" class="non-style-link"><button  class="btn-primary-soft btn button-icon btn-view"  style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">View</font></button></a>
                                                        //        &nbsp;&nbsp;&nbsp;-->
                                                        //        <a href="?action=drop&id='.$appoid.'&name='.$pname.'&session='.$title.'&apponum='.$apponum.'" class="non-style-link"><button  class="btn-primary-soft btn button-icon btn-delete"  style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Cancel</font></button></a>
                                                        //        &nbsp;&nbsp;&nbsp;</div>
                                                        //         </td>
                                                        //     </tr>';
                                                
                                                    }
                                                }

                                                ?>

                                            </tbody>

                                        </table>
                                    </div>
                                </center>
                            </td>
                        </tr>



                    </table>
                </div>
            </div>
            <?php

            if ($_GET) {
                $id = $_GET["id"];
                $action = $_GET["action"];
                if ($action == 'booking-added') {

                    echo '
            <div id="popup1" class="overlay">
                    <div class="popup">
                    <center>
                    <br><br>
                        <h2>Booking Successfully.</h2>
                        <a class="close" href="appointment.php">&times;</a><br>
                        <div class="content" style="display:block;">
                        Your Appointment number is ' . $id . '.<br><br>
                            
                        </div>
                        <div style="display: flex;justify-content: center;">
                        
                        <a href="appointment.php" class="non-style-link"><button  class="btn-primary btn"  style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text">&nbsp;&nbsp;OK&nbsp;&nbsp;</font></button></a>
                        <br><br><br><br>
                        </div>
                    </center>
            </div>
            </div>
            ';
                } elseif ($action == 'drop') {
                    $title = $_GET["title"];
                    $docname = $_GET["doc"];

                    echo '
            <div id="popup1" class="overlay">
                    <div class="popup">
                    <center><br>
                        <h2>Are you sure?</h2><br>
                        <a class="close" href="appointment.php">&times;</a>
                        <div class="content" style="display:block;">
                            You want to Cancel this Appointment?<br><br>
                            Session Name: &nbsp;<b>' . substr($title, 0, 40) . '</b><br>
                            Doctor name&nbsp; : <b>' . substr($docname, 0, 40) . '</b><br><br>
                            
                        </div>
                        <div style="display: flex;justify-content: center;">
                        <a href="delete-appointment.php?id=' . $id . '" class="non-style-link"><button  class="btn-primary btn"  style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"<font class="tn-in-text">&nbsp;Yes&nbsp;</font></button></a>&nbsp;&nbsp;&nbsp;
                        <a href="appointment.php" class="non-style-link"><button  class="btn-primary btn"  style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text">&nbsp;&nbsp;No&nbsp;&nbsp;</font></button></a>

                        </div>
                    </center>
            </div>
            </div>
            ';
                } elseif ($action == 'view') {
                    $sqlmain = "select * from doctor where docid='$id'";
                    $result = $database->query($sqlmain);
                    $row = $result->fetch_assoc();
                    $name = $row["docname"];
                    $email = $row["docemail"];
                    $spe = $row["specialties"];

                    $spcil_res = $database->query("select sname from specialties where id='$spe'");
                    $spcil_array = $spcil_res->fetch_assoc();
                    $spcil_name = $spcil_array["sname"];
                    $nic = $row['docnic'];
                    $tele = $row['doctel'];
                    echo '
            <div id="popup1" class="overlay">
                    <div class="popup">
                    <center>
                        <h2></h2>
                        <a class="close" href="doctors.php">&times;</a>
                        <div class="content">
                            Doc Appointment<br>
                            
                        </div>
                        <div style="display: flex;justify-content: center;">
                        <table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
                        
                            <tr>
                                <td>
                                    <p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">View Details.</p><br><br>
                                </td>
                            </tr>
                            
                            <tr>
                                
                                <td class="label-td" colspan="2">
                                    <label for="name" class="form-label">Name: </label>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                    ' . $name . '<br><br>
                                </td>
                                
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                    <label for="Email" class="form-label">Email: </label>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                ' . $email . '<br><br>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                    <label for="nic" class="form-label">NIC: </label>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                ' . $nic . '<br><br>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                    <label for="Tele" class="form-label">Telephone: </label>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                ' . $tele . '<br><br>
                                </td>
                            </tr>
                            <tr>
                                <td class="label-td" colspan="2">
                                    <label for="spec" class="form-label">Specialties: </label>
                                    
                                </td>
                            </tr>
                            <tr>
                            <td class="label-td" colspan="2">
                            ' . $spcil_name . '<br><br>
                            </td>
                            </tr>
                            <tr>
                                <td colspan="2">
                                    <a href="doctors.php"><input type="button" value="OK" class="login-btn btn-primary-soft btn" ></a>
                                
                                    
                                </td>
                
                            </tr>
                           

                        </table>
                        </div>
                    </center>
                    <br><br>
            </div>
            </div>
            ';
                }
            }

            ?>
        </div>

    </div>





    </div>
    <div class="footer">
        <div class="text">
            <h3>About Us</h3>
            <p>24 Hours</p>
            <p>Top Doctor</p>
            <p>Best Care</p>
            <p>Patient</p>
            <p></p>

        </div>
        <div class="text">
            <h3>Speciality</h3>
            <p>Knee surgery</p>
            <p>Spin surgery</p>
            <p>Leg surgery</p>
            <p>Tendon surgery</p>
            <p></p>

        </div>
        <div class="text">
            <h3>Best Teams</h3>
            <p>Doctors</p>
            <p>Nursing</p>
            <p>Staff</p>
            <p>Hospital</p>
            <p></p>

        </div>
        <div class="text">
            <h3>Address</h3>
            <p>Near MG Road</p>
            <p>Galaxy Care</p>
            <p>333-09093</p>
            <p>09-883-090</p>


        </div>
    </div>

 
    </div>
    </div>
    <script src="../script/index.js"></script>
</body>

</html>