} else { ?>
Mon | Tue | Wed | Thu | Fri | Sat | Sun | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | ||||||||||||||||||||||||||||
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", ($day+1)); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> if($firsttday=="$day_name") { $day=($day+1); ?> } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> |
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; if($mas_1_par>$MALA_CU_DAY_AR_KAR) { } if($mas_1_par<$MALA_CU_DAY_AR_KAR) { /*$mas_1_par=strtotime($mas_1_par);*/ ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows==0) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> $day_name; $no_leave_1_day; $no_leave_1_night; $colour_l=0; if($day_name=="Sunday" ) { $colour_l=1; } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | ||
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); $num_rows = mysql_num_rows($objitem); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows==0) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //echo $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | ||
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> |
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { // echo 'entering 0 loop'; ?> if($mal_ses_id=='') { echo 'entering 0 loop'; ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> $day_name; $no_leave_1_day; $no_leave_1_night; $colour_l=0; if($day_name=="Sunday" ) { $colour_l=1; } ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query( "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { // october 30th ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> |
} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { // october 31st ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Tuesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Wednesday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Thursday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Friday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //$objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Saturday"; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where (date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> | $day_name="Sunday"; ?> $day_name; $no_leave_1_day; $no_leave_1_night; $colour_l=0; if($day_name=="Sunday" ) { $colour_l=1; } //echo $get_tot_app; ?> $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); $num_rows=0; //kirupa // $objitem = mysql_query("SELECT id from tbl_doctor_appointment where date >= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' and status='0'"); // "SELECT id from tbl_doctor_appointment where date >= ' and date='$MALA_CU_DAY_AR_KAR' and status='0'"; // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $mas_1_par=date("Y-m-d", $n_t_d); $MALA_CU_DAY_AR_KAR; /*$mas_1_par=strtotime($mas_1_par);*/ if($mas_1_par<$MALA_CU_DAY_AR_KAR) { ?>} else { ?> if($num_rows == 0) { ?> | }elseif($timing < 7200 ) { ?> | }elseif($get_tot_app == $get_num_stats ) { ?> | } else { ?> | } } ?> if($day>0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> if($num_rows==0) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { ?> if($mal_ses_id=='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> if($mal_ses_id!='') { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } ?> } ?> $day=($day+1); } ?> |
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia iste laborum ad impedit pariatur esse optio tempora sint ullam autem deleniti nam in quos qui nemo ipsum numquam, reiciendis maiores quidem aperiam, rerum vel recusandae