";
die(1);
Util::dieWithError('Error getting client info.');
}
try {
//get kiosk page records
$sql = "SELECT KioskPage.*
,Site.SiteGUID
,siteURLrec.URL AS siteplanURL
,AreaMap.AreaMapGUID
,mapURLrec.URL AS areamapURL
FROM KioskPage
LEFT JOIN Site ON KioskPageType='Site Plan' AND KioskPage.SiteID>0 AND Site.SiteID=KioskPage.SiteID
LEFT JOIN URL siteURLrec ON KioskPageType='Site Plan' AND siteURLrec.SiteID IS NOT NULL AND siteURLrec.SiteID=Site.SiteID
LEFT JOIN AreaMap ON KioskPageType='POI Map' AND KioskPage.AreaMapID>0 AND AreaMap.AreaMapID=KioskPage.AreaMapID
LEFT JOIN URL mapURLrec ON KioskPageType='POI Map' AND mapURLrec.AreaMapID IS NOT NULL AND mapURLrec.AreaMapID=AreaMap.AreaMapID
WHERE KioskPage.KioskID=:KioskID AND KioskPageEnabled=1
ORDER BY KioskPageDisplayOrder";
$stmt = $db->prepare($sql);
$stmt->bindValue(':KioskID', (int)$kiosk_id, PDO::PARAM_INT);
$stmt->execute();
$KioskPages = $stmt->fetchAll(PDO::FETCH_ASSOC);
//echo "pages=
";
die(1);
Util::dieWithError('Error getting kiosk page info.');
}
try {
//get floorplan records
$sql = "SELECT Plan.*, URL.URL, GROUP_CONCAT(PlanTagData.PlanTagID) AS PlanTagIDs
FROM KioskProject
INNER JOIN Plan ON Plan.ProjectID=KioskProject.ProjectID AND Plan.IsActive=1 AND Plan.Status='Approved'
INNER JOIN URL ON URL.PlanID=Plan.PlanID
LEFT JOIN PlanTagData ON PlanTagData.PlanID=Plan.PlanID
WHERE KioskProject.KioskID=:KioskID
GROUP BY PlanID
ORDER BY PlanDisplayName, PlanTagDataDisplayOrder";
$stmt = $db->prepare($sql);
$stmt->bindValue(':KioskID', (int)$kiosk_id, PDO::PARAM_INT);
$stmt->execute();
$Plans = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $ex) {
echo "kiosk_id=" . $kiosk_id . "";
echo "sql=" . $sql . " ";
// echo "recs=
" . print_r($KioskPages, TRUE) . "
";
die(1);
Util::dieWithError('Error getting kiosk floorplans info.');
}
try {
//get floorplan exteriors
$sql = "SELECT
Plan.PlanID
, PlanOption.OptionID AS ExteriorOptionID
, PlanOption.OptionDisplayName AS ExteriorDisplayName
, PlanOption.OptionData1 AS ExteriorThumbnailImage
, COALESCE(Plan.PlanAlternateKioskPreviewFile,PlanOption.OptionData2) AS ExteriorFullSizeImage
FROM KioskProject
INNER JOIN Plan ON Plan.ProjectID=KioskProject.ProjectID AND Plan.IsActive=1 AND Plan.Status='Approved'
LEFT JOIN PlanOptionGroup ON PlanOptionGroup.PlanID= Plan.PlanID AND PlanOptionGroup.OptionGroupTypeID=2
LEFT JOIN PlanOption ON PlanOption.OptionGroupID = PlanOptionGroup.OptionGroupID AND PlanOption.OptionEnabled=1 AND PlanOption.OptionSelected=1
WHERE KioskProject.KioskID=:KioskID
GROUP BY Plan.PlanID
ORDER BY Plan.PlanID";
$stmt = $db->prepare($sql);
$stmt->bindValue(':KioskID', (int)$kiosk_id, PDO::PARAM_INT);
$stmt->execute();
$PlanExteriors = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $ex) {
echo "kiosk_id=" . $kiosk_id . "";
echo "sql=" . $sql . " ";
// echo "recs=
" . print_r($PlanExteriors, TRUE) . "
";
die(1);
Util::dieWithError('Error getting kiosk floorplan exteriors info.');
}
try {
//get floorplan tag data records
$sql = "SELECT PlanTag.*,PlanTagData.*
FROM KioskProject
INNER JOIN Plan ON Plan.ProjectID=KioskProject.ProjectID AND Plan.IsActive=1 AND Plan.Status='Approved'
INNER JOIN PlanTagData ON PlanTagData.PlanID=Plan.PlanID
INNER JOIN PlanTag ON PlanTag.PlanTagID=PlanTagData.PlanTagID
WHERE KioskProject.KioskID=:KioskID
ORDER BY PlanID, PlanTagData.PlanTagDataDisplayOrder";
$stmt = $db->prepare($sql);
$stmt->bindValue(':KioskID', (int)$kiosk_id, PDO::PARAM_INT);
$stmt->execute();
$PlanTagData = $stmt->fetchAll(PDO::FETCH_ASSOC);
//echo "PlanTagData=