<?php
include '../connection.php';




?>

<!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;
        }
        td {
  text-align: center;
}
    </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"];

?>
    <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">Appointments</a></li>
                <li><a href="../patient/doctor.php"><b><u>Doctors</u></b></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="main" style="display:block; margin-top: 25px;">
        
        
        <div class="dash-body">
            <br><br><br><br>
            <table border="0" width="100%" style="border-spacing: 0; margin: 0; padding: 0; margin-top: 25px;">
    <tr>
        <td width="10%" style="padding-left: 50px;">
            <a href="doctor.php">
                <button class="login-btn btn-primary-soft btn" style="padding: 11px 25px;">
                    <font class="tn-in-text">Back</font>
                </button>
            </a>
        </td>
        <td>
            <form action="" method="post" class="header-search" style="display: flex; align-items: center;">
                <input type="search" name="search" class="input-text header-searchbar" placeholder="Search Doctor name or Email" list="doctors" style="margin-right: 10px; width: 1150px;">
                <?php
                    echo '<datalist id="doctors">';
                    $list11 = $database->query("select docname, docemail from doctor;");
                    for ($y=0; $y<$list11->num_rows; $y++){
                        $row00 = $list11->fetch_assoc();
                        $d = $row00["docname"];
                        $c = $row00["docemail"];
                        echo "<option value='$d'><br/>";
                        echo "<option value='$c'><br/>";
                    };
                    echo ' </datalist>';
                ?>
                <input type="Submit" value="Search" class="login-btn btn-primary btn" style="padding: 10px 25px;">
            </form>
        </td>
    </tr>
</table>
 <br><br>

               
                
                <tr>
                    <td colspan="4" style="padding-top:10px;">
                        <p class="heading-main12" style="margin-left: 65px;font-size:18px;color:rgb(49, 49, 49)">&nbsp;&nbsp;All Doctors (<?php echo $list11->num_rows; ?>)</p>
                    </td>
                    <br>
                </tr>
                <?php
                    if($_POST){
                        $keyword=$_POST["search"];
                        
                        $sqlmain= "select * from doctor where docemail='$keyword' or docname='$keyword' or docname like '$keyword%' or docname like '%$keyword' or docname like '%$keyword%'";
                    }else{
                        $sqlmain= "select * from doctor order by docid desc";

                    }



                ?>
                  
                <tr>
                   <td colspan="4">
                       <center>
                        <div class="abc scroll">
                        <table width="93%" class="sub-table scrolldown" border="0">
                        <thead>
                        <tr>
                                <th class="table-headin">
                                    
                                
                                Doctor Name
                                
                                </th>
                               <!--  <th class="table-headin">
                                    Email
                                </th> -->
                                <th class="table-headin">
                                    
                                    Specialties
                                    
                                </th>
                                <th class="table-headin">
                                    
                                    Events
                                    
                                </tr>
                        </thead>
                        <tbody>
                        
                            <?php

                                
                                $result= $database->query($sqlmain);

                                if($result->num_rows==0){
                                    echo '<tr>
                                    <td colspan="4">
                                    <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="doctor.php"><button  class="login-btn btn-primary-soft btn"  style="display: flex;justify-content: center;align-items: center;margin-left:20px;">&nbsp; Show all Doctors &nbsp;</font></button>
                                    </a>
                                    </center>
                                    <br><br><br><br>
                                    </td>
                                    </tr>';
                                    
                                }
                                else{
                                for ( $x=0; $x<$result->num_rows;$x++){
                                    $row=$result->fetch_assoc();
                                    $docid=$row["docid"];
                                    $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"];
                                    echo '<tr>
                                        <td> &nbsp;'.
                                        substr($name,0,30)
                                        .'</td>
                                      
                                        <td>
                                            '.substr($spcil_name,0,30).'
                                        </td>

                                        <td>
                                        <div style="display:flex;justify-content: center;">
                                        
                                        <a href="?action=view&id='.$docid.'" 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=session&id='.$docid.'&name='.$name.'"  class="non-style-link"><button  class="btn-primary-soft btn button-icon menu-icon-session-active"  style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Sessions</font></button></a>
                                        </div>
                                        </td>
                                    </tr>';
                                    
                                }
                            }
                                 
                            ?>
 
                            </tbody>

                        </table>
                        </div>
                        </center>
                   </td> 
                </tr>
                       
                        
                        
            </table>
        </div>
    </div>
    <?php 
    if($_GET){
        
        $id=$_GET["id"];
        $action=$_GET["action"];
        if($action=='drop'){
            $nameget=$_GET["name"];
            echo '
            <div id="popup1" class="overlay">
                    <div class="popup">
                    <center>
                        <h2>Are you sure?</h2>
                        <a class="close" href="doctor.php">&times;</a>
                        <div class="content">
                            You want to delete this record<br>('.substr($nameget,0,40).').
                            
                        </div>
                        <div style="display: flex;justify-content: center;">
                        <a href="delete-doctor.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="doctors.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="doctor.php">&times;</a>
                        <div class="content">
                            Doc Appoontment<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: center;font-size: 25px;font-weight: 250;">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="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="doctor.php"><input type="button" value="OK" class="login-btn btn-primary-soft btn" ></a>
                                
                                    
                                </td>
                
                            </tr>
                           

                        </table>
                        </div>
                    </center>
                    <br><br>
            </div>
            </div>
            ';
        }elseif($action=='session'){
            $name=$_GET["name"];
            echo '
            <div id="popup1" class="overlay">
                    <div class="popup">
                    <center>
                        <h2 style="text-align:center;">Redirect to Doctors sessions?</h2>
                        <a class="close" href="doctor.php">&times;</a>
                        <div class="content" style="display:block;">
                          <p style="text-align:center;">  You want to view All sessions by <br>('.substr($name,0,40).').</p>
                            
                        </div>
                        <form action="session.php" method="post" style="display: flex">

                                <input type="hidden" name="search" value="'.$name.'">

                                
                        <div style="display: flex;justify-content:center;margin-left:45%;margin-top:6%;;margin-bottom:6%;">
                        
                        <input type="submit"  value="Yes" class="btn-primary btn"   >
                        
                        
                        
                        </div>
                    </center>
            </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 class="detail">
                 <button id="closeBtn">
                    <i class="fa-solid fa-xmark"></i>
                 </button>
                <div class="content">

                </div>
            </div>
        </div>
        <script src="../script/index.js"></script>
</body>

</html>