File: /home/barbeatleanalyti/public_html/manage.beatleanalytics.com/site/include/restohotelinfo.php
<?php
/* <summary>
Class contains methods related to state module
<author>
Beatle Buddy 2017.
</author>
Version 1.0
</summary>
*/
class include_restohotelinfo
{
/*
<summary>
Default constructor
</summary>
*/
function __CONSTRUCT(){
}
public function FetchReviewData($Val=""){
global $objDB;
$SQL = "SELECT * FROM beatle_review WHERE ";
if(!empty($this->ReviewId) && !empty($this->ReviewType)){
$SQL .= " `reviewId` = ".$this->ReviewId." and type = '".$this->ReviewType."'";
}/*else{
$SQL .= " 1 ";
}*/
$rsReviewInfo = $objDB->sql_query($SQL);
return $rsReviewInfo;
}
public function FetchReviewImages(){
global $objDB;
$SQL = "SELECT * FROM beatle_review_photo WHERE ";
if(!empty($this->ReviewId)){
$SQL .= " `reviewId` = ".$this->ReviewId;
}
$rsReviewImages = $objDB->sql_query($SQL);
return $rsReviewImages;
}
public function FetchReviewFeedback($reviewId){
global $objDB;
$SQL = "SELECT * FROM beatle_review_feedback WHERE ";
if(!empty($this->ReviewId)){
$SQL .= " `reviewId` = ".$this->ReviewId;
}else{
$SQL .= " `reviewId` = ".$reviewId;
}
$rsReviewFeedback = $objDB->sql_query($SQL);
return $rsReviewFeedback;
}
public function fetchOrganization(){
global $objDB;
$SQL = "SELECT OrgId,db_Orgname FROM beatle_organization WHERE OrgId = ".$_SESSION['OtherInfo']['OrgID'];
$rsOrgInfo = $objDB->sql_query($SQL);
return $rsOrgInfo;
}
public function fetchBranches(){
global $objDB;
$SQL = "SELECT db_branchName,branchId FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'];
$rsBranches = $objDB->sql_query($SQL);
return $rsBranches;
}
public function fetchIndustrys($OrgID,$BranchID,$IndustryID){
global $objDB;
if(!empty($OrgID)) {
$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$OrgID.")";
$rsBranches = $objDB->sql_query($SQL);
}else {
$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'].")";
$rsBranches = $objDB->sql_query($SQL);
}
return $rsBranches;
}
public function FetchOrganizationName($id){
global $objDB;
$SQL = "SELECT db_Orgname FROM beatle_organization WHERE OrgId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_Orgname'];
}
public function FetchBranchName($id){
global $objDB;
$SQL = "SELECT db_branchName FROM beatle_branch WHERE branchId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_branchName'];
}
public function FetchIndustryName($id){
global $objDB;
$SQL = "SELECT db_industry FROM beatle_industry WHERE IndId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_industry'];
}
public function SelectPageContentName($id){
global $objDB;
$SQL = "SELECT db_pageConTitle FROM beatle_pagecontent WHERE pageConId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_pageConTitle'];
}
public function SelectPageName($id){
global $objDB;
$SQL = "SELECT db_pagename FROM beatle_page WHERE pageId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_pagename'];
}
public function fetchrestohotelinfoQA($CustomerID,$sort,$PageIDS){
global $objDB;
//print_r($_SESSION);
//$SQL = "SELECT pageConId FROM beatle_pagecontent WHERE LOWER(db_pageConTitle) = '".strtolower(QUESTION_DEFAULT_SENTENCE)."'";
$SQL = "SELECT GROUP_CONCAT(pageConId) AS pageConIds FROM beatle_pagecontent WHERE LOWER(db_pageselection) = 'multiline'";
$AboutUSayIArr = $objDB->sql_query($SQL);
$AboutUSayI_ID = $AboutUSayIArr[0]['pageConIds'];
//print_r($PageIDS);
$SQL = "SELECT beatle_organization.OrgId FROM beatle_organization RIGHT JOIN beatle_userlogin ON beatle_organization.OrgId = beatle_userlogin.OrgID WHERE beatle_userlogin.userId = ".$_SESSION['UserInfo']['UserID']." ";
$rsOrgID = $objDB->sql_query($SQL);
$SQL = "SELECT * FROM beatle_survey WHERE is_submit = 'Y' AND db_surveyPageid IN (".$PageIDS.") ";
if(!empty($this->TokenID))
$SQL .= " AND beatle_survey.tokenid = '".$this->TokenID."' " ;
if(!empty($this->FromDate) && !empty($this->ToDate)){
$SQL .= " AND created_date BETWEEN '".date("Y-m-d",strtotime($this->FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($this->ToDate))." 23:59:59' ";
}
if(!empty($AboutUSayI_ID))
$SQL .= " AND db_surveyContentId NOT IN (".$AboutUSayIArr[0]['pageConIds'].") ";
//echo "<br /><br />";
//echo $SQL;
$rsData = $objDB->sql_query($SQL);
return $rsData;
}
public function fetchIndustryPagesData(){
global $objDB;
$SQL_B = "";
if(strtolower($_SESSION['UserInfo']['UType']) == 'owner') {
$SQL = "SELECT * FROM beatle_branch WHERE db_branchOrg = (SELECT OrgId FROM beatle_organization WHERE db_ownerId = ".$_SESSION['UserInfo']['UserID']." )";
}else if(strtolower($_SESSION['UserInfo']['UType']) == 'manager'){
$SQL = "SELECT * FROM beatle_branch WHERE db_branchManager = ".$_SESSION['UserInfo']['UserID']." ";
}else if(strtolower($_SESSION['UserInfo']['UType']) == 'line_manager'){
$SQL = "SELECT * FROM beatle_branch WHERE branchId = (SELECT BranchID FROM beatle_userlogin WHERE userId = ".$_SESSION['UserInfo']['UserID'].") ";
}
$rsBranches = $objDB->sql_query($SQL);
return $rsBranches;
}
public function fetchContentAboutISay($CustomerID){
global $objDB;
//$SQL = "SELECT pageConId FROM beatle_pagecontent WHERE LOWER(db_pageConTitle) = '".strtolower(QUESTION_DEFAULT_SENTENCE)."'";
$SQL = "SELECT pageConId,db_pageConTitle FROM beatle_pagecontent WHERE LOWER(db_pageselection) = 'multiline'";
$AboutUSayIArr = $objDB->sql_query($SQL);
$returnArr = array();
for($i=0;$i < count($AboutUSayIArr); $i++){
$AboutUSayIArr = $objDB->sql_query($SQL);
$AboutUSayI_ID = $AboutUSayIArr[$i]['pageConId'];
$returnArr = array();
$returnArr[0] = $AboutUSayIArr[$i]['db_pageConTitle'];
$SQL1 = "SELECT db_surveyValue FROM beatle_survey WHERE is_submit = 'Y' AND tokenid = '".$this->TokenID."'";
if(!empty($AboutUSayI_ID))
$SQL1 .= " AND db_surveyContentId = ".$AboutUSayI_ID;
$rsData = $objDB->sql_query($SQL1);
if(count($rsData) > 0){
$returnArr[1] = $rsData[0]['db_surveyValue'];
break;
}else{
$returnArr[1] = "No any data found";
}
// $checkvalue = $rsData[0]['db_surveyValue'];
// if(empty($checkvalue)){
// break;
// }
}
// $AboutUSayIArr = $objDB->sql_query($SQL);
// $AboutUSayI_ID = $AboutUSayIArr[0]['pageConId'];
// $returnArr = array();
// $returnArr[0] = $AboutUSayIArr[0]['db_pageConTitle'];
// $SQL = "SELECT db_surveyValue FROM beatle_survey WHERE is_submit = 'Y' AND tokenid = '".$this->TokenID."'";
// if(!empty($AboutUSayI_ID))
// $SQL .= " AND db_surveyContentId = ".$AboutUSayI_ID;
// $rsData = $objDB->sql_query($SQL);
// if(count($rsData) > 0){
// $returnArr[1] = $rsData[0]['db_surveyValue'];
// }else{
// $returnArr[1] = "No any data found";
// }
return $returnArr;
}
public function fetchContentDetails($CustomerID,$type){
global $objDB;
//$rsData = $this->FetchCustomerData();
$SQL = "SELECT
beatle_survey.surveyId,
beatle_survey.db_surveyBranchid,
beatle_survey.db_surveyUserid,
beatle_survey.db_surveyIndId,
beatle_survey.db_surveyPageid,
beatle_survey.db_surveyContentId,
beatle_survey.db_surveyValue,
beatle_survey.created_date,
beatle_survey.updated_date,
beatle_survey.tokenid,
beatle_survey.orgid,
beatle_survey.is_submit,
beatle_userlogin.db_phone,
beatle_userlogin.db_userLoginName,
beatle_userlogin.db_username,
beatle_userlogin.userId
FROM
beatle_survey
INNER JOIN beatle_userlogin ON beatle_survey.db_surveyUserid = beatle_userlogin.userId
WHERE beatle_survey.is_submit = 'Y' AND beatle_survey.db_surveyUserid = ".$this->CustomerID." ";
if(!empty($this->FromDate) && !empty($this->ToDate)){
$SQL .= " AND beatle_survey.created_date BETWEEN '".date("Y-m-d",strtotime($this->FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($this->ToDate))." 23:59:59' ";
}
if(!empty($this->OrgID))
$SQL .= " AND beatle_survey.orgid = ".$this->OrgID." " ;
else
$SQL .= " AND beatle_survey.orgid = ".$_SESSION['OtherInfo']['OrgID']." " ;
if(!empty($this->BranchID))
$SQL .= " AND beatle_survey.db_surveyBranchid = ".$this->BranchID." " ;
if(!empty($this->IndustryID))
$SQL .= " AND beatle_survey.db_surveyIndId = ".$this->IndustryID." " ;
if(!empty($this->TokenID))
$SQL .= " AND beatle_survey.tokenid = '".$this->TokenID."' " ;
//if(empty($IN))
//$SQL .= " GROUP BY beatle_survey.tokenid";
$SQL .= " ORDER BY beatle_survey.created_date DESC";
//echo $SQL;
$rsData = $objDB->sql_query($SQL);
if(count($rsData) <= 0)
return array();
if($type == 'question') {
//$rsBranches = $this->fetchIndustryPagesData($CustomerID,$type);
//$BranchIDArr = array();
//foreach($rsBranches as $key => $val){
// $BranchIDArr[] = $val['branchId'];
//}
}
$SQL = "SELECT db_pagesId AS PageIDs FROM beatle_industry WHERE IndId = ".$this->IndustryID;
$rsPageID = $objDB->sql_query($SQL);
//echo $rsPageID[0]['PageIDs'];
$SQL = "SELECT GROUP_CONCAT(pageId) AS PageIDS FROM beatle_page WHERE pageId IN (".$rsPageID[0]['PageIDs'].") AND LOWER(db_pagetype) = '".$type."'";
$rsPages = $objDB->sql_query($SQL);
//print_r($rsPages);
//die;
if($type == 'content') {
return $rsPages;
}
if(!empty($rsPages[0]['PageIDS']))
$rsQuestionData = $this->fetchrestohotelinfoQA($CustomerID,$type,$rsPages[0]['PageIDS']);
else
$rsQuestionData = array();
return $rsQuestionData;
}
public function fetchStateName($sid){
global $objDB;
$SQL = "SELECT name from states WHERE id = ".$sid;
$rsData = $objDB->sql_query($SQL);;
return $rsData[0]['name'];
}
public function fetchCityName($sid){
global $objDB;
$SQL = "SELECT name from cities WHERE id = ".$sid;
$rsData = $objDB->sql_query($SQL);;
return $rsData[0]['name'];
}
public function FetchReviewBranchInd($reviewId){
global $objDB;
$SQL = "SELECT branchId,indId from beatle_review WHERE reviewId = ".$reviewId." and type = 'ind' ";
$rsData = $objDB->sql_query($SQL);
return $rsData;
}
public function updateRestohotelData(){
global $objDB;
/*echo($_POST['BranchID']);
die();*/
include(INCLUDE_PATH."/selectfeedback.php");
$objReports = new include_selectfeedback();
$rsCustomerInfo = $objReports->FetchCustomerData();
//echo count($rsCustomerInfo);
//die();
$_REQUEST['acn'] = 'FetchReviewData';
$feedbackCount = $this->FetchReviewFeedback($_POST['reviewId']);
if(count($feedbackCount) <= 0){
for ($i=0;$i< count($rsCustomerInfo);$i++)
{
$rsPagesIDS_ = IndustryPageIDS('Content',$_POST['BranchID'],$_POST['IndustryID']);
$totalAvg = 0;
/*echo "<pre>";
print_r($rsPagesIDS_);*/
foreach($rsPagesIDS_ as $val) {
$rsPagesContent = $objReports->fetchPageListAll($val);
$avgSum = 0;
for($pgc=0;$pgc<count($rsPagesContent); $pgc++){
$avgVal = $objReports->FetchOverAllAvg($rsCustomerInfo[$i]['db_surveyUserid'],"",$_POST['BranchID'],$_POST['IndustryID'],'Content',$rsPagesContent[$pgc]['pageConId'],$rsCustomerInfo[$i]['tokenid']);
$avgSum = $avgSum + $avgVal;
}
$totalAvg += round($avgSum/count($rsPagesContent),2);
}
if(empty($_POST['IndustryID'])){
if(count($rsPagesIDS_) >3){
$totalAvg = round($totalAvg/(count($rsPagesIDS_)/2),2);
}else{
$totalAvg = round($totalAvg/count($rsPagesIDS_),2);
}
}else{
$totalAvg = round($totalAvg/count($rsPagesIDS_),2);
}
$rsPagesIDS = IndustryPageIDS('question',$_POST['BranchID'],$_POST['IndustryID']);
foreach($rsPagesIDS as $val) {
$rsPagesContent = $objReports->fetchPageList($val);
for($pgc=0;$pgc<count($rsPagesContent); $pgc++){
$avgVal = $objReports->FetchQuestionValue($rsCustomerInfo[$i]['db_surveyUserid'],"",$_POST['BranchID'],$_POST['IndustryID'],'question',$rsPagesContent[$pgc]['pageConId'],$rsCustomerInfo[$i]['tokenid']);
if(!empty($avgVal)){
//echo $totalAvg." / ".$avgVal."<br>";
if($totalAvg >= 3){
$username = $rsCustomerInfo[$i]['db_username'];
if(empty($rsCustomerInfo[$i]['db_username'])){
$username = "Guest";
}
$SQL = "INSERT INTO beatle_review_feedback (reviewId,userId,username,avgRating,feedbackDetail,tokenid,feedbackDate,created_date) VALUES(".$_POST['reviewId'].",".$rsCustomerInfo[$i]['db_surveyUserid'].",'".$username."',".$totalAvg.",'".addslashes(trim(preg_replace('/\s+/', ' ', $avgVal)))."','".$rsCustomerInfo[$i]['tokenid']."','".$rsCustomerInfo[$i]['created_date']."','".date('Y-m-d H:i:s')."')" ;
$objDB->sql_query($SQL);
}
}
}
}//echo "<br>";
}
}//die();
$SQL = "SELECT * FROM beatle_review_photo WHERE ";
if(!empty($_POST['reviewId'])){
$SQL .= " `reviewId` = ".$_POST['reviewId'];
}
$result = $objDB->sql_query($SQL);
if(count($result) <= 0){
ReturnPostFormData($_REQUEST,"restohotelinfo.html?rid=".$_POST['reviewId']."&type=".$_SESSION['ReviewInfo']['reviewType'],"You have not select any image, please try again and select images ! ",1);
exit;
}
$SQL = "SELECT * FROM beatle_review_feedback WHERE ";
if(!empty($_POST['reviewId'])){
$SQL .= " `reviewId` = ".$_POST['reviewId'];
}
$result = $objDB->sql_query($SQL);
if(count($result) <= 0){
ReturnPostFormData($_REQUEST,"restohotelinfo.html?rid=".$_POST['reviewId']."&type=".$_SESSION['ReviewInfo']['reviewType'],"You have not select any feedback, please try again and select feedback ! ",1);
exit;
}
$date = date('Y-m-d H:i:s');
$restDesc = addslashes($_POST['restDesc']);
$SQL = "UPDATE beatle_review
set restName = '".$_POST['restName']."',
restDesc = '".$restDesc."',
phoneNo = '".$_POST['phoneNo']."',
email = '".$_POST['email']."',
webprofileimage = '".$_POST['webprofileimage']."',
updated_date = '".$date."',
status = 'Y' WHERE reviewId = ".$_POST['reviewId'];
/*echo($SQL);
die();*/
$rvData = $objDB->sql_query($SQL);
if(count($rvData) > 0){
unset($_REQUEST['acn']);
unset($_REQUEST['v']);
unset($_SESSION['ReviewInfo']);
header("Location: profilenew.html");
ReturnPostFormData($_REQUEST,"profilenew.html","ReviewInfo data updated successfuly.",0);
exit;
}else{
ReturnPostFormData($_REQUEST,"restohotelinfo.html","Here is something wrong to update data.",1);
exit;
}
}
}
?>