prefix . "abAdminProfileDetails"; $abHolidayMst = $wpdb->prefix . "abHolidayMst"; $getMinMaxDate = $wpdb->get_results("SELECT priorMonthsToBook, priorDaysToBook FROM ".$abAdminProfileDetails." WHERE isDeleted=0",ARRAY_A); if(!empty($getMinMaxDate[0]['priorDaysToBook']) && !empty($getMinMaxDate[0]['priorMonthsToBook'])) {//if-1 starts $priorDays = $getMinMaxDate[0]['priorDaysToBook'] + 1; $priorMonths = ($getMinMaxDate[0]['priorMonthsToBook'] * 30) - 1; $minDateTimeStamp = strtotime("+".$priorDays." days"); //echo "
"; $minDate = date("d-m-Y", $minDateTimeStamp); //echo $minDate."
"; $maxDateTimeStamp = strtotime("+".$priorMonths." days", $minDateTimeStamp); //echo "
"; $maxDate = date("d-m-Y", $maxDateTimeStamp); //echo $maxDate."
"; } else { $errorMessages = "You cannot book appointment. Please try again"; /* wp_redirect( home_url() ); exit; */ }//if-1 ends if(!empty($minDate) && !empty($maxDate)) {//if-2 starts $holidayResult = $wpdb->get_results("SELECT DATE_FORMAT(holidayDate,'%d-%m-%Y') as holidayDate FROM ".$abHolidayMst." WHERE holidayDate BETWEEN '".changeDateFormatWithoutTime($minDate)."' AND '".changeDateFormatWithoutTime($maxDate)."' AND isDeleted=0",ARRAY_A); $holidayArray=array(); if($holidayResult) {//if-3 starts foreach($holidayResult as $holiday) {//foreach-1 starts if(!empty($holiday['holidayDate'])) {//if-4 starts // implode(',',$holiday['holidayDate']) array_push($holidayArray, "'".$holiday['holidayDate']."'"); }//if-4 ends }//foreach-1 ends }//if-3 ends $holidayString = implode(',',$holidayArray); }//if-2 ends //echo "SELECT DAY(holidayDate) as DayOfHoliday,MONTH(holidayDate) as MonthOfHoliday ,holidayName from ".$abHolidayMst." where isDeleted=0"; $holidayDisplayData = $wpdb->get_results("SELECT DAY(holidayDate) as DayOfHoliday,MONTH(holidayDate) as MonthOfHoliday ,holidayName from ".$abHolidayMst." where isDeleted=0",ARRAY_A); $holidayCount = $wpdb->num_rows; $i=0; if($holidayDisplayData) {//if-5 starts $DayOfHoliday = array(); foreach($holidayDisplayData as $holidayData) {//foreach-2 starts if(!empty($holidayData['holidayName'])) {//if-6 starts $i=++$i; $DayOfHoliday[$i]=trim($holidayData['DayOfHoliday']); $MonthOfHoliday[$i]=trim($holidayData['MonthOfHoliday']-1); $holidayName[$i]="'".trim($holidayData['holidayName'])."'"; }//if-6 ends }//foreach-2 ends }//if-5 ends ?>