} 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 2 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 3 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 4 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 5 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 6 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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; //day 7 // $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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> | } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); echo $get_num_stats.' '. $get_tot_app; $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } else { ?> echo $monthName;?> } ?> echo $day;?> } else { ?> echo $st;?> } ?> } else { // echo 'entering 0 loop'; ?> if($mal_ses_id=='') { // echo 'entering this 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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 and t2.cancel_us = 0"); $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 || $mas_1_par<$MALA_CU_DAY_AR_KAR) { ?> } 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