session_start(); include "includes/required.php"; include "controllers/search_controller.php"; include "controllers/listing_controller.php"; include "controllers/user_controller.php"; include "controllers/review_controller.php"; date_default_timezone_set("Europe/London"); $businessType = 1; $defaultBannerImage = "genericbackgroundimage.jpg"; if($businessType == 1){ $businessProfile = "generic"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else if($businessType == 2){ $businessProfile = "attractions"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else if($businessType == 3){ $businessProfile = "food"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else if($businessType == 4){ $businessProfile = "accomodation"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else if($businessType == 5){ $businessProfile = "clubs"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else if($businessType == 6){ $businessProfile = "event"; $defaultBannerImage = "genericbackgroundimage.jpg"; } else { $businessProfile = "generic"; $defaultBannerImage = "genericbackgroundimage.jpg"; } $displayMessage = ""; $newReviewAdded = false; if(isset($_GET['id'])){ $listingId = $_GET['id']; $alreadyBookedmarkedFlag = isListingBookmarked($mysqli, $listingId, $usersUuid); if(isset($_GET['action'])){ $actionToDo = $_GET['action']; if($actionToDo == "bookmark"){ saveListing($mysqli, $listingId, $usersUuid); $displayMessage = "Listing has been added to your bookmarks."; $alreadyBookedmarkedFlag = 1; } if($actionToDo == "unbookmark"){ unsaveListing($mysqli, $listingId, $usersUuid); $displayMessage = "Listing has been removed from your bookmarks."; $alreadyBookedmarkedFlag = 0; } } if(isset($_POST['buttonAddReview']) && $usersUuid != ""){ $newReviewStat1 = $_POST['rgcl'][0]; $newReviewStat2 = $_POST['rgcl'][1]; $newReviewStat3 = $_POST['rgcl'][2]; $newReviewStat4 = $_POST['rgcl'][3]; $newReviewStat5 = $_POST['rgcl'][4]; $newReviewStat6 = $_POST['newReviewStat6']; $newReviewStat7 = $_POST['newReviewStat7']; $newReviewStat8 = $_POST['newReviewStat8']; $newReviewId = $_POST['newReviewerId']; $newReviewComment = $_POST['newReviewComment']; $averageTotalScore = $newReviewStat1 + $newReviewStat2 + $newReviewStat3 + $newReviewStat4 + $newReviewStat5; $totalStats = 5; if ($newReviewStat6 == 10){ // Not used $newReviewStat6 = 0; } else { $averageTotalScore = $averageTotalScore + $newReviewStat6; $totalStats = $totalStats + 1; } if ($newReviewStat7 == 10){ // Not used $newReviewStat7 = 0; } else { $averageTotalScore = $averageTotalScore + $newReviewStat7; $totalStats = $totalStats + 1; } if ($newReviewStat8 == 10){ // Not used $newReviewStat8 = 0; } else { $averageTotalScore = $averageTotalScore + $newReviewStat8; $totalStats = $totalStats + 1; } $averageScore = $averageTotalScore / $totalStats; addNewReview($mysqli, $listingId, $averageScore, $newReviewStat1, $newReviewStat2, $newReviewStat3, $newReviewStat4, $newReviewStat5, $newReviewStat6, $newReviewStat7, $newReviewStat8, $newReviewId, $newReviewComment); $displayMessage = "Your review has been added."; $newReviewAdded = true; } $listingDetails = getListing($mysqli, $listingId); $listingName = $listingDetails['name']; $listingAddress1 = $listingDetails['address_1']; $listingAddress2 = $listingDetails['address_2']; $listingTown = $listingDetails['town']; $listingCounty = $listingDetails['county']; $listingPostcode = $listingDetails['postcode']; $listingCountry = $listingDetails['country']; $fullBusinessAddress = $listingAddress1; if($listingAddress2 != ""){ $fullBusinessAddress = $fullBusinessAddress . ", " . $listingAddress2; } $fullBusinessAddress = $fullBusinessAddress . ", " . $listingTown; if($listingPostcode != ""){ $fullBusinessAddress = $fullBusinessAddress . ", " . $listingPostcode; } if($listingCountry != ""){ $fullBusinessAddress = $fullBusinessAddress . ", " . $listingCountry; } $listingDateFounded = $listingDetails['date_founded']; $listingPhone = $listingDetails['phone']; $listingContactEmail = $listingDetails['contact_email']; $listingContactPhone = $listingDetails['contact_phone']; $listingBusinessType = $listingDetails['category_main']; $listingDescription = $listingDetails['description']; $profileViews = $listingDetails['views'] + 1; $profileSaves = getNumberBookmarks($mysqli, $listingId); $listingBusinessTypeValue = getBusinessType($listingBusinessType); $allListingTags = getListingTags($mysqli, $listingId); $listingMondayOpen = $listingDetails['monday_open']; $listingMondayClose = $listingDetails['monday_close']; $listingTuesdayOpen = $listingDetails['tuesday_open']; $listingTuesdayClose = $listingDetails['tuesday_close']; $listingWednesdayOpen = $listingDetails['wednesday_open']; $listingWednesdayClose = $listingDetails['wednesday_close']; $listingThursdayOpen = $listingDetails['thursday_open']; $listingThursdayClose = $listingDetails['thursday_close']; $listingFridayOpen = $listingDetails['friday_open']; $listingFridayClose = $listingDetails['friday_close']; $listingSaturdayOpen = $listingDetails['saturday_open']; $listingSaturdayClose = $listingDetails['saturday_close']; $listingSundayOpen = $listingDetails['sunday_open']; $listingSundayClose = $listingDetails['sunday_close']; $listingMondayClosedFlag = $listingDetails['monday_closed_flag']; $listingTuesdayClosedFlag = $listingDetails['tuesday_closed_flag']; $listingWednesdayClosedFlag = $listingDetails['wednesday_closed_flag']; $listingThursdayClosedFlag = $listingDetails['thursday_closed_flag']; $listingFridayClosedFlag = $listingDetails['friday_closed_flag']; $listingSaturdayClosedFlag = $listingDetails['saturday_closed_flag']; $listingSundayClosedFlag = $listingDetails['sunday_closed_flag']; $listingMondayOpenFlag = $listingDetails['monday_open_flag']; $listingTuesdayOpenFlag = $listingDetails['tuesday_open_flag']; $listingWednesdayOpenFlag = $listingDetails['wednesday_open_flag']; $listingThursdayOpenFlag = $listingDetails['thursday_open_flag']; $listingFridayOpenFlag = $listingDetails['friday_open_flag']; $listingSaturdayOpenFlag = $listingDetails['saturday_open_flag']; $listingSundayOpenFlag = $listingDetails['sunday_open_flag']; $currentDayOfWeek = date("l"); $currentTimeHour = date("H"); $currentTimeMin = date("i"); if($currentDayOfWeek == "Monday"){ $closedAllDayFlag = $listingMondayClosedFlag; $openAllDayFlag = $listingMondayOpenFlag; $openTimeHour = (explode(":", $listingMondayOpen))[0]; $openTimeMin = (explode(":", $listingMondayOpen))[1]; $closeTimeHour = (explode(":", $listingMondayClose))[0]; $closeTimeMin = (explode(":", $listingMondayClose))[1]; } else if($currentDayOfWeek == "Tuesday"){ $closedAllDayFlag = $listingTuesdayClosedFlag; $openAllDayFlag = $listingTuesdayOpenFlag; $openTimeHour = (explode(":", $listingTuesdayOpen))[0]; $openTimeMin = (explode(":", $listingTuesdayOpen))[1]; $closeTimeHour = (explode(":", $listingTuesdayClose))[0]; $closeTimeMin = (explode(":", $listingTuesdayClose))[1]; } else if($currentDayOfWeek == "Wednesday"){ $closedAllDayFlag = $listingWednesdayClosedFlag; $openAllDayFlag = $listingWednesdayOpenFlag; $openTimeHour = (explode(":", $listingWednesdayOpen))[0]; $openTimeMin = (explode(":", $listingWednesdayOpen))[1]; $closeTimeHour = (explode(":", $listingWednesdayClose))[0]; $closeTimeMin = (explode(":", $listingWednesdayClose))[1]; } else if($currentDayOfWeek == "Thursday"){ $closedAllDayFlag = $listingThursdayClosedFlag; $openAllDayFlag = $listingThursdayOpenFlag; $openTimeHour = (explode(":", $listingThursdayOpen))[0]; $openTimeMin = (explode(":", $listingThursdayOpen))[1]; $closeTimeHour = (explode(":", $listingThursdayClose))[0]; $closeTimeMin = (explode(":", $listingThursdayClose))[1]; } else if($currentDayOfWeek == "Friday"){ $closedAllDayFlag = $listingFridayClosedFlag; $openAllDayFlag = $listingFridayOpenFlag; $openTimeHour = (explode(":", $listingFridayOpen))[0]; $openTimeMin = (explode(":", $listingFridayOpen))[1]; $closeTimeHour = (explode(":", $listingFridayClose))[0]; $closeTimeMin = (explode(":", $listingFridayClose))[1]; } else if($currentDayOfWeek == "Saturday"){ $closedAllDayFlag = $listingSaturdayClosedFlag; $openAllDayFlag = $listingSaturdayOpenFlag; $openTimeHour = (explode(":", $listingSaturdayOpen))[0]; $openTimeMin = (explode(":", $listingSaturdayOpen))[1]; $closeTimeHour = (explode(":", $listingSaturdayClose))[0]; $closeTimeMin = (explode(":", $listingSaturdayClose))[1]; } else if($currentDayOfWeek == "Sunday"){ $closedAllDayFlag = $listingSundayClosedFlag; $openAllDayFlag = $listingSundayOpenFlag; $openTimeHour = (explode(":", $listingSundayOpen))[0]; $openTimeMin = (explode(":", $listingSundayOpen))[1]; $closeTimeHour = (explode(":", $listingSundayClose))[0]; $closeTimeMin = (explode(":", $listingSundayClose))[1]; } $listingWebsite = $listingDetails['website']; $listingFacebook = $listingDetails['facebook']; $listingTwitter = $listingDetails['twitter']; $listingInstagram = $listingDetails['instagram']; /* Work out review Stuff */ $listingReviewNumber = $listingDetails['review_number']; $listingReviewTotal = $listingDetails['review_total']; $listingReviewTotalStat1 = $listingDetails['total_review_stat_1']; $listingReviewTotalStat2 = $listingDetails['total_review_stat_2']; $listingReviewTotalStat3 = $listingDetails['total_review_stat_3']; $listingReviewTotalStat4 = $listingDetails['total_review_stat_4']; $listingReviewTotalStat5 = $listingDetails['total_review_stat_5']; $listingReviewTotalStat6 = $listingDetails['total_review_stat_6']; $listingReviewTotalStat7 = $listingDetails['total_review_stat_7']; $listingReviewTotalStat8 = $listingDetails['total_review_stat_8']; if($listingReviewNumber > 0){ $listingReviewAverage = intval(($listingReviewTotal / 5) / $listingReviewNumber); $listingReviewAverageStat1 = $listingReviewTotalStat1 / $listingReviewNumber; $listingReviewAverageStat2 = $listingReviewTotalStat2 / $listingReviewNumber; $listingReviewAverageStat3 = $listingReviewTotalStat3 / $listingReviewNumber; $listingReviewAverageStat4 = $listingReviewTotalStat4 / $listingReviewNumber; $listingReviewAverageStat5 = $listingReviewTotalStat5 / $listingReviewNumber; $listingReviewAverageStat6 = $listingReviewTotalStat6 / $listingReviewNumber; $listingReviewAverageStat7 = $listingReviewTotalStat7 / $listingReviewNumber; $listingReviewAverageStat8 = $listingReviewTotalStat8 / $listingReviewNumber; } else { $listingReviewAverage = 0; $listingReviewAverageStat1 = 0; $listingReviewAverageStat2 = 0; $listingReviewAverageStat3 = 0; $listingReviewAverageStat4 = 0; $listingReviewAverageStat5 = 0; $listingReviewAverageStat6 = 0; $listingReviewAverageStat7 = 0; $listingReviewAverageStat8 = 0; } $allListingReviews = getListingReviews($mysqli, $listingId); $totalReviewsCount = count($allListingReviews); if($newReviewAdded){ $newReviewAverage = $listingReviewTotal + $averageTotalScore; $newReviewStatTotal1 = $listingReviewTotalStat1 + $newReviewStat1; $newReviewStatTotal2 = $listingReviewTotalStat2 + $newReviewStat2; $newReviewStatTotal3 = $listingReviewTotalStat3 + $newReviewStat3; $newReviewStatTotal4 = $listingReviewTotalStat4 + $newReviewStat4; $newReviewStatTotal5 = $listingReviewTotalStat5 + $newReviewStat5; $newReviewStatTotal6 = $listingReviewTotalStat6 + $newReviewStat6; $newReviewStatTotal7 = $listingReviewTotalStat7 + $newReviewStat7; $newReviewStatTotal8 = $listingReviewTotalStat8 + $newReviewStat8; $listingReviewNumber = $listingReviewNumber + 1; $listingReviewAverage = intval(($listingReviewTotal / 5) / $listingReviewNumber); $listingReviewAverageStat1 = $newReviewStatTotal1 / $listingReviewNumber; $listingReviewAverageStat2 = $newReviewStatTotal2 / $listingReviewNumber; $listingReviewAverageStat3 = $newReviewStatTotal3 / $listingReviewNumber; $listingReviewAverageStat4 = $newReviewStatTotal4 / $listingReviewNumber; $listingReviewAverageStat5 = $newReviewStatTotal5 / $listingReviewNumber; $listingReviewAverageStat6 = $newReviewStatTotal6 / $listingReviewNumber; $listingReviewAverageStat7 = $newReviewStatTotal7 / $listingReviewNumber; $listingReviewAverageStat8 = $newReviewStatTotal8 / $listingReviewNumber; updateBusinessReviews($mysqli, $listingId, $listingReviewNumber, $newReviewAverage, $newReviewStatTotal1, $newReviewStatTotal2, $newReviewStatTotal3, $newReviewStatTotal4, $newReviewStatTotal5, $newReviewStatTotal6, $newReviewStatTotal7, $newReviewStatTotal8); } updateProfileViewStat($mysqli, $listingId); $listingDateAdded = $listingDetails['date_added']; $listingBusinessRegId = $listingDetails['business_reg_id']; } $chosenPage = $_GET['page']; if ($chosenPage == ""){ $chosenPage = "feed"; } else if ($chosenPage != "details" && $chosenPage != "gallery" && $chosenPage != "videos" && $chosenPage != "reviews" && $chosenPage != "contact" && $chosenPage != "faqs" && $chosenPage != "menu" && $chosenPage != "products" && $chosenPage != "services" && $chosenPage != "facilities" && $chosenPage != "offers" && $chosenPage != "jobs" && $chosenPage != "events" && $chosenPage != "calendar" && $chosenPage != "news" && $chosenPage != "classifieds" && $chosenPage != "meettheteam" && $chosenPage != "store" && $chosenPage != "exhibitions" && $chosenPage != "files" && $chosenPage != "loyalty" && $chosenPage != "rooms"){ $chosenPage = "feed"; } $profilePages = getProfilePages($mysqli, $listingId); $faqsTabEnabledFlag = $profilePages['faq_page_flag']; $menuTabEnabledFlag = $profilePages['menu_page_flag']; $productsTabEnabledFlag = $profilePages['products_page_flag']; $servicesTabEnabledFlag = $profilePages['services_page_flag']; $facilitiesTabEnabledFlag = $profilePages['facilities_page_flag']; $offersTabEnabledFlag = $profilePages['offers_page_flag']; $jobsTabEnabledFlag = $profilePages['jobs_page_flag']; $eventsTabEnabledFlag = $profilePages['events_page_flag']; $calendarTabEnabledFlag = $profilePages['calendar_page_flag']; $classifiedsTabEnabledFlag = $profilePages['classifieds_page_flag']; $meettheteamTabEnabledFlag = $profilePages['meettheteam_page_flag']; $storeTabEnabledFlag = $profilePages['store_page_flag']; $exhibitionsTabEnabledFlag = $profilePages['exhibition_page_flag']; $galleryTabEnabledFlag = $profilePages['gallery_page_flag']; $videosTabEnabledFlag = $profilePages['video_page_flag']; $filesTabEnabledFlag = $profilePages['files_page_flag']; $newsTabEnabledFlag = $profilePages['news_page_flag']; $reviewsTabEnabledFlag = $profilePages['reviews_page_flag']; $loyaltyTabEnabledFlag = $profilePages['loyalty_page_flag']; $roomsTabEnabledFlag = $profilePages['rooms_page_flag']; ?>
include "includes/header.php"; ?>