במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

]]jkjjgdjffksdkdxmnnnnnnnnnnnmnmmnmnmnmnmbnwqeqwewqskfgj במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

<?php
require_once 'include/config.php';
include "jdate/jdatetime.class.php";
include "jdate/jdf.php";
$tatil=0;

if(!isset($_SESSION['sender_id']))
{
    // header("location: ../../index.php");
    echo "<script> document.location='../index.php';</script>";

die;
}
if(isset($_GET['delnobat']))
{
    $del=$_GET['delnobat'];
    $iduser=$_SESSION['sender_id'];
    $del="delete from vizit_tell where id='{$del}' and id_online_user='{$iduser}' and active=0";
    $res=$conn->query($del);

$msg=3;
}
if(isset($_POST['taeed_user']))
{
    $datevizit2=$_POST['datevizit2'];
    $id_doctor=$_POST['id_doctor'];
    $ch_day=$_POST['ch_day'];
    $sqlday="SELECT * FROM `work_matab` where id='{$ch_day}' ";
    $res2=$conn->query($sqlday);
    $rowday=mysqli_fetch_assoc($res2);
    $id_day=$_SESSION['id_day']=$rowday['id_day'];
    $timevizit=$rowday['time'];
    $namefamily=$_SESSION['name_family'];
    $id_user=$_SESSION['sender_id'];
    $mobile=$_SESSION['user_login'];
    $_SESSION['id_doctor_vizit']=$id_doctor;
    $_SESSION['datevizit']=$datevizit2;
    $_SESSION['timevizit']=$timevizit;

$sql="select * from vizit_tell where  id_online_user='{$id_user}' and datevizit='{$datevizit2}' and timevizit='{$timevizit}'";
    $re1=$conn->query($sql);
    if(mysqli_num_rows($re1)==0) {
//        $ins = "insert into vizit_tell (id_doctor,datevizit,timevizit,namefamily,tell,id_online_user)
//            values ('{$id_doctor}','{$datevizit2}','{$timevizit}','{$namefamily}','{$mobile}','{$id_user}')";
//        $conn->query($ins);
//        $msg=1;
      header("location: menu_nobat.php");
      die;
    }else{
        $msg=2;
    }

}
if(isset($_POST['exitweek']))
{
    header("location: show_doctors.php");
    die;
}

if(!isset($_SESSION["doctor_list"]))
{
    $_SESSION["doctor_list"]=0;
}
//require_once 'headernobat.php';

<head>
    <link rel="stylesheet" href="<?php echo $_SESSION["localhost_path"];?>lib/lib/css/bootstrap.min.css'; ?>">
    <link rel="stylesheet" href="<?php echo $_SESSION["localhost_path"];?>lib/lib/assets/css/bootstrap.min.css">
     <script src="<?php echo $_SESSION["localhost_path"];?>lib/lib/js/bootstrap.min.js"></script>
    <style>
        table.sortable th:not(.sorttable_sorted)
        :not(.sorttable_sorted_reverse):not(.sorttable_nosort):after {
            content: " \25B4\25BE"
        }
        th{
            text-align: center;
        }

td, th {
            border: 1px solid #dddddd;
            text-align: center;
            padding: 8px;
        }

tr:nth-child(even) {
            background-color: #dddddd;
        }

</style>
    <style type="text/css">
        @page{
            margin: 0 20px;
            size: a4;
        }
        form{
            text-align: center;
            margin-top: 20px;
        }
        form input[type=submit]{
            background: lightblue;
            color: white;
            font-size: 20px;
            border-radius: 5px;
            margin-top: 20px;
            cursor: pointer;
        }
    </style>
     <link rel="stylesheet" type="text/css" href="../tools/calendar/calendar-blue2.css" >
     <link rel="stylesheet" type="text/css" href="lib/lib/css/style-dark.min.css">
    <script src="../tools/calendar/jalali.js"></script>
    <script src="../tools/calendar/calendar.js"></script>
    <script src="../tools/calendar/calendar-setup.js"></script>
    <script src="../tools/calendar/calendar-fa.js"></script>

</head>

<body>

<?php
if(isset($msg))
{
    if($msg==1)
    {
        echo '
                                                    <script src="lib/lib/js/sweetalert.min.js"></script>
                                                  <script>
                                                    swal({
                                                            title: "پیام",
                                                            text: "  ثبت رزرو شما انجام شد  ",
                                                            type: "success",
                                                            icon: "success",
                                                            button: "خروج",
                                                        }).then(function () {
                                                        window.location = "";
                                                    });   
                                                  </script>
                                                ';

}
    if($msg==2)
    {
        echo '
                                                    <script src="lib/lib/js/sweetalert.min.js"></script>
                                                  <script>
                                                    swal({
                                                            title: "خطا",
                                                            text: "    امکان ثبت وجود ندارد قبلا در این تاریخ و ساعت ثبت انجام شده است  ",
                                                            type: "error",
                                                            icon: "error",
                                                            button: "خروج",
                                                        }).then(function () {
                                                        window.location = "";
                                                    });   
                                                  </script>
                                                ';

}
    if($msg==3)
    {
        echo '
                                                    <script src="lib/lib/js/sweetalert.min.js"></script>
                                                  <script>
                                                    swal({
                                                            title: "پیام",
                                                            text: "  حذف نوبت درخواستی شما انجام شد  ",
                                                            type: "success",
                                                            icon: "success",
                                                            button: "خروج",
                                                        }).then(function () {
                                                        window.location = "?delok";
                                                    });   
                                                  </script>
                                                ';

}
}
if(isset($_GET['datev'])){?>
    
    <div class="offcanvas bg-white offcanvas-top" tabindex="-1" id="offcanvasTop">
        <div class="offcanvas-body d-flex align-items-center align-items-center">
            <div class="container">
                <div class="row">
                    <div class="col">
                        <div class="text-center">
                            <h4>جستجو کنيد...</h4>
                            <div class="subcribe-form mt-4">
                                <form method="post">
                                    <div class="mb-0">
                                        <input type="text" autocomplete="off" id="help" name="namesearch" class="border bg-white rounded-pill" required="" placeholder="جستجو با نام بیمار">
                                        <button type="submit" name="mysearch" class="btn btn-pills btn-primary">جستجو</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
<?php } ?>

<?php
if(isset($_GET['idradif']))
{
    $idradif=$_GET['idradif'];
    $datev=$_GET['datev'];

$get_total = "update  vizit_tell set active='1' where id='{$idradif}' ";

$res = $conn->query($get_total);

//header("nobatTell.php?datev=".$datev);

echo "<script>document.location=nobatTell.php?datev=".$datev."</script>";

}
if(isset($_GET['timev']))
{
    $id=$_GET['timev'];
    $get_total = "SELECT * FROM office_hour where id='{$id}' ";
 
    $res = $conn->query($get_total);
    $row = $res->fetch_assoc() ;
    $tedad_nobat_time=$row['tedad_nobat_time'];
    $timevizit=$_SESSION["timevizit"]=$row['hour'];
    $idd=$_SESSION["doctor_list"];
    $doctor10 ="SELECT * FROM `persons` where id='{$idd}'";
    $res_doc=$conn->query($doctor10);
    $_SESSION["name_doctor"]="";
    $rowdoctor=mysqli_fetch_assoc($res_doc);
    $namedoctor = $rowdoctor["first_name"].'   '.$rowdoctor["last_name"];

?>
    <form method="post">
        <center>
            <div style="background-color: #00A5E3;width: 600px;text-align: center" >
                نام پزشک: <?php echo $namedoctor; ?><br>
                تاریخ ویزیت: <?php echo $_SESSION["date_from"]; ?> &nbsp;&nbsp;
                ساعت ویزیت: <?php echo $timevizit; ?><br>
                نام بیمار: &nbsp;&nbsp;<input type="text" name="namebimar"  dir="rtl"
                                              placeholder="نام و نام خانوادگی بیمار را وارد نمایید" size="70"
                                              required="required"  oninvalid="setCustomValidity('لطفاً نام و نام خانوادگی را وارد کنید')"
                                              oninput="setCustomValidity('')" id="name"   class="form-control"  >
                <br>
                تلفن بیمار: <input type="text" name="tellbimar" size="70" dir="ltr"
                                   placeholder="تلفن تماس بیمار را وارد نمایید"
                                   required oninvalid="setCustomValidity('لطفاً تلفن را وارد کنید')"
                                   oninput="setCustomValidity('')"
                                   onkeypress="return /[0-9-.]/i.test(event.key)"
                                   id="phoneNo"   class="form-control" placeholder="شماره تماس :">
                <span id="spanmsg"></span>
                <br>
                <select name="tabligh"  style="font: 20px Vazir;">
                    <option style="font: 20px Vazir;" value="0">بدون تبلیغات</option>
                    <?php
                    $doctorttab ="SELECT * FROM `tablighat` ";
                    $res_tab=$conn->query($doctorttab);
                    while($rowtab=mysqli_fetch_assoc($res_tab))
                    {?>

<option style="font: 20px Vazir;" value="<?php echo $rowtab['id'];?>"><?php echo $rowtab['title'];  ?></option>
                    <?php }

?>
                </select>
                <br>
                <input type="submit" name="sabtnobat" value="ثبت نوبت">
            </div></center>
    </form>
<?php }
if(isset($_SESSION["save"]))
{
    unset($_SESSION["save"]);
    ?>   <center> <div style="background-color: #a3ff96;width: 600px;text-align: center" >
        ثبت نوبت دهی انجام شد
    </div></center>
<?php } ?>

<th  style="text-align:center">  پزشک و تاریخ نوبت دهی</th>

<tr>
            <td>
                <center>
                     <?php
                    if(isset($_GET['doctor'])){
                        $id_doctor=$_GET['doctor'];
                    }else{
                        header("location:show_ticket.php");
                        die;
                    }
                    $doctor10 ="SELECT * FROM `persons` where id='{$id_doctor}'";
                    $res_doc=$conn->query($doctor10);
                    if(mysqli_num_rows($res_doc)==0)
                    {
                        header("location:show_ticket.php");
                        die;
                    }
                    $_SESSION["name_doctor"]="";
                    $rowdoctor=mysqli_fetch_assoc($res_doc);
                     if(!empty($rowdoctor['image'])){
                         $image='../View/dr_page/image_doctor/'.$rowdoctor['image'];
                     }else{
                         $image="uploads/noimage.png";
                     }

?>
                    <div class="imgBoxWpyarPanelSlider"  style="overflow-x: auto;text-align: center">
                        <center> <img src="<?php echo $image; ?>" style="border-radius: 20px;border-style: double" width="200px" height="200px"/> </center>
                    </div>
                    <br>

<?php
                    $today_date = jDateTime::date('Y/m/d', false, false);
                    $sql_doctor="SELECT * FROM `work_doctor` where dateend>='{$today_date}' and id_doctor='{$id_doctor}' ";
                    $res_doc=$conn->query($sql_doctor);
                    $tatil=0;

if(mysqli_num_rows($res_doc)>0)
                    {
                        $rowt=mysqli_fetch_assoc($res_doc);
                        $tatil=1;
                    }
                    if($tatil==1){
                        ?>
                        <span style="font-family: Vazir;font-weight: bold;font-size: 18px"   >
                <p style="font-family: Vazir;font-size: 18px;font-weight: bold;background: #ff2605; color: black" class="form-label"> در این تاریخ امکان پذیرش بیمار میسر نیست  </p>
                <p style="font-family: Vazir;font-size: 18px;font-weight: bold;background: #ff2605; color: black" class="form-label">تاریخ شروع تعطیلی: <?php  echo $rowt['datestart'] ?>  </p>
                <p style="font-family: Vazir;font-size: 18px;font-weight: bold;background: #ff2605; color: black" class="form-label">تاریخ پایان تعطیلی: <?php echo $rowt['dateend'] ?> </p>
                <hr>
                   </span>
                    <?php } ?>

<p  style="font-family: Vazir;font-size: 18px;font-weight: bold;background: white; color: black">
                       تاریخ ویزیت را انتخاب نمایید</p>
                    <input type="text" name="datevizit2" id="date_from" autocomplete="off"
                           style="font-family: Vazir;font-size: 18px;font-weight: bold;background: white; color: black"
                        <?php if(isset($_POST['chdayweek'])) { echo 'style="display: none"';}else{  echo 'style="display: black"';}?>
                       value="<?php if(isset($_POST['datevizit2'])){echo $_POST['datevizit2'];} ?>"
                       placeholder="انتخاب تاریخ" >
                </center>
            </td>
        </tr>
        <tr>

<?php  } ?>
                <input type="submit"  style="width: 150px;height: 50px;background:#f50c14;border-radius: 10px"
                       name="exitweek" value="بازگشت">

</td>
        </tr>
    </table>
        </center>
        </div>
    </div>
</form>
<div class="row_status">
    <div class="wpyarpanel-mb-10" style="overflow-x: auto;">
        <?php
        if(isset($_POST['chdayweek']) and !empty($_POST['datevizit2'])) {
            $today_date22 = $_POST['datevizit2'];
            $id_doctor=$_POST['list_doctor'];
            $sql_doctor22 = "SELECT * FROM `work_doctor` where dateend>='{$today_date22}' and id_doctor='{$id_doctor}' ";
            $res_doc22 = $conn->query($sql_doctor22);
            $tatil = 0;
            if (mysqli_num_rows($res_doc22) > 0) {
                $rowt22 = mysqli_fetch_assoc($res_doc22);
                $tatil = 1;
            }
            if ($tatil == 1) {

echo '
                                                    <script src="lib/lib/js/sweetalert.min.js"></script>
                                                  <script>
                                                    swal({
                                                            title: "خطا",
                                                            text: "    در این روز مطب فعالیتی ندارد  ",
                                                            type: "error",
                                                            icon: "error",
                                                            button: "خروج",
                                                        }).then(function () {
                                                        window.location = "";
                                                    });   
                                                  </script>
                                                ';

}

}
        if(isset($_POST['chdayweek']) and !empty($_POST['datevizit2'])){

$date_user=$_POST['datevizit2'];
            $year1=substr($_POST['datevizit2'],0,4);
            $mon1=substr($_POST['datevizit2'],5,2);
            $day1=substr($_POST['datevizit2'],8,2);
            $date_miladi = jalali_to_gregorian($year1,$mon1, $day1 , '/');
            $date_miladi2 =  str_replace('/','',$date_miladi);
            $date = strtotime($date_miladi);
            $day_date2 = date('l', $date);
            $days_latin=array('Saturday','Sunday','Monday','Tuesday','Wednesday','Thursday','Friday');
            $choice_day_user=array_search($day_date2,$days_latin)+1;
            if($choice_day_user==1){
                $name_day='شنبه';
            }else if($choice_day_user==2){
                $name_day='یکشنبه';
            }else if($choice_day_user==3){
                $name_day='دوشنبه';
            }else if($choice_day_user==4){
                $name_day='سه شنبه';
            }else if($choice_day_user==5){
                $name_day='چهارشنبه';
            }else if($choice_day_user==6){
                $name_day='پنج شنبه';
            }else if($choice_day_user==7){
                $name_day='سه شنبه';
            }

$sql_n="SELECT * FROM `work_matab` where id_day='{$choice_day_user}' and paziresh>0";
            $resu=$conn->query($sql_n);

if(mysqli_num_rows($resu)==0)
            {
                  echo '
                                                    <script src="lib/lib/js/sweetalert.min.js"></script>
                                                  <script>
                                                    swal({
                                                            title: "خطا",
                                                            text: "    در این روز مطب فعالیتی ندارد  ",
                                                            type: "error",
                                                            icon: "error",
                                                            button: "خروج",
                                                        }).then(function () {
                                                        window.location = "";
                                                    });   
                                                  </script>
                                                ';

}else{
                echo '<center><span style="background:darkgrey;font-family: Vazir;font-weight: bold;font-size: 18px"><label class="form-label">   پذیرش شما: </label>';
                echo ' <label class="form-label"> : '.$date_user.' </label>';
                echo ' <label class="form-label">  روز: '.$name_day.' </label></span> </center>';

echo '<style>
                                                        table {
                                                          border-collapse: collapse;
                                                          width: 100%;
                                                        }
                                                        
                                                        th, td {
                                                          text-align: left;
                                                          padding: 8px;
                                                        }
                                                        
                                                        tr:nth-child(even) {background-color: #f2f2f2;}
                                                        </style>';
                $sqlday="SELECT * FROM `work_matab` where id_day='{$choice_day_user}' and paziresh=1   ORDER BY `work_matab`.`time` ASC";
               
                $res2=$conn->query($sqlday);
                echo '<table >';
                echo '<thead  ><tr style="background: yellow;color:black" >
                 <th style="text-align:center">لغو نوبت</th>                            
                 <th style="text-align:center">ظرفیت پذیرش</th>                            
                 <th style="text-align:center">ساعت پذیرش</th>                            
                 <th style="text-align:center">انتخاب</th>                            
                 </tr></thead>';
                ?>
                <form method="post">
                <input type="hidden" name="datevizit2" value="<?php echo $_POST['datevizit2'];?>">
                <input type="hidden" name="id_doctor" value="<?php echo $id_doctor;?>">

<?php
                while($rown=mysqli_fetch_assoc($res2))
                {
                    $choicedate=$_POST['datevizit2'];
                    $timevizit=$rown['time'];
                    $tedad=$rown['tedad'];
                    $sqltel="SELECT * FROM `vizit_tell` where id_doctor='{$id_doctor}' and datevizit='{$choicedate}' and timevizit='{$timevizit}'";
                    $restel=$conn->query($sqltel);
                    $numtel=mysqli_num_rows($restel);
                    if($numtel<$tedad)
                    {
                        $numtel=$tedad-$numtel;
                        ?>
                    <tr style="color:#d8d9d0;background:grey">
                        <td   style="text-align:center">
                          <?php
                          $user=$_SESSION['sender_id'];
                          $sqltelu="SELECT * FROM `vizit_tell` where id_online_user='{$user}' and  id_doctor='{$id_doctor}' and datevizit='{$choicedate}' and timevizit='{$timevizit}'";
                          $restelu=$conn->query($sqltelu);
                          $numtelu=mysqli_num_rows($restelu);
                            if($numtelu>0){
                                $xid=mysqli_fetch_assoc($restelu);
                                $idres=$xid['id'];
                          ?>
                            <a class="btn-danger" style="border-style: double;border-radius: 5px" href="?delnobat=<?php echo $idres; ?>">لغو شود</a> </td>
                          <?php } ?>
                        <td   style="text-align:center"><span for="<?php echo 'id'.$rown['id']; ?>"><?php echo $numtel ?></span> </td>
                        <td    style="text-align:center"><span for="<?php echo 'id'.$rown['id']; ?>"><?php echo  $rown['time'] ?></span></td>
                        <td    style="text-align:center"><input type="radio" name="ch_day" value="<?php echo $rown['id']; ?>" ></td>
                     </tr>
                    <?php   } ?>

<?php
                } ?>
                  <tr>
                        <td colspan="4" style="text-align:center">
                            <input type="submit"  style="width: 150px;height: 50px;background:goldenrod;border-radius: 10px;font-family:Vazir;font-weight: bold;font-size:16px"
                                   value="ثبت رزرو نوبت" name="taeed_user">
                        </td>
                  </tr>

<?php echo '</table>';
            }

</form>

<?php }
        ?>

</div>
</div>

</script>

</body>
</html>