[php] posts

Viewer

  1. <?php
  2. $tdataposts=array();$tdataposts[".searchableFields"]=array();$tdataposts[".ShortName"]="posts";$tdataposts[".OwnerID"]="Controller";$tdataposts[".OriginalTable"]="posts";$tdataposts[".pagesByType"]=my_json_decode("{\"add\":[\"add\"],\"edit\":[\"edit\"],\"export\":[\"export\"],\"import\":[\"import\"],\"list\":[\"list\"],\"masterlist\":[\"masterlist\"],\"masterprint\":[\"masterprint\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}");$tdataposts[".originalPagesByType"]=$tdataposts[".pagesByType"];$tdataposts[".pages"]=types2pages(my_json_decode("{\"add\":[\"add\"],\"edit\":[\"edit\"],\"export\":[\"export\"],\"import\":[\"import\"],\"list\":[\"list\"],\"masterlist\":[\"masterlist\"],\"masterprint\":[\"masterprint\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}"));$tdataposts[".originalPages"]=$tdataposts[".pages"];$tdataposts[".defaultPages"]=my_json_decode("{\"add\":\"add\",\"edit\":\"edit\",\"export\":\"export\",\"import\":\"import\",\"list\":\"list\",\"masterlist\":\"masterlist\",\"masterprint\":\"masterprint\",\"print\":\"print\",\"search\":\"search\",\"view\":\"view\"}");$tdataposts[".originalDefaultPages"]=$tdataposts[".defaultPages"];$fieldLabelsposts=array();$fieldToolTipsposts=array();$pageTitlesposts=array();$placeHoldersposts=array();if(mlang_getcurrentlang()=="English"){$fieldLabelsposts["English"]=array();$fieldToolTipsposts["English"]=array();$placeHoldersposts["English"]=array();$pageTitlesposts["English"]=array();$fieldLabelsposts["English"]["PostID"]="Post ID";$fieldToolTipsposts["English"]["PostID"]="";$placeHoldersposts["English"]["PostID"]="";$fieldLabelsposts["English"]["Facility_Name"]="Facility Name";$fieldToolTipsposts["English"]["Facility_Name"]="";$placeHoldersposts["English"]["Facility_Name"]="";$fieldLabelsposts["English"]["Owner"]="Owner";$fieldToolTipsposts["English"]["Owner"]="";$placeHoldersposts["English"]["Owner"]="";$fieldLabelsposts["English"]["Address"]="Address";$fieldToolTipsposts["English"]["Address"]="";$placeHoldersposts["English"]["Address"]="";$fieldLabelsposts["English"]["Lat"]="Lat";$fieldToolTipsposts["English"]["Lat"]="";$placeHoldersposts["English"]["Lat"]="";$fieldLabelsposts["English"]["FacilityType"]="Facility Type";$fieldToolTipsposts["English"]["FacilityType"]="";$placeHoldersposts["English"]["FacilityType"]="";$fieldLabelsposts["English"]["Fence"]="Fence";$fieldToolTipsposts["English"]["Fence"]="";$placeHoldersposts["English"]["Fence"]="";$fieldLabelsposts["English"]["Lights"]="Lights";$fieldToolTipsposts["English"]["Lights"]="";$placeHoldersposts["English"]["Lights"]="";$fieldLabelsposts["English"]["FireExtinguisher"]="Fire Extinguisher";$fieldToolTipsposts["English"]["FireExtinguisher"]="";$placeHoldersposts["English"]["FireExtinguisher"]="";$fieldLabelsposts["English"]["SecurityPost"]="Security Post";$fieldToolTipsposts["English"]["SecurityPost"]="";$placeHoldersposts["English"]["SecurityPost"]="";$fieldLabelsposts["English"]["CCTV"]="CCTV";$fieldToolTipsposts["English"]["CCTV"]="";$placeHoldersposts["English"]["CCTV"]="";$fieldLabelsposts["English"]["CrimeRate"]="Crime Rate";$fieldToolTipsposts["English"]["CrimeRate"]="";$placeHoldersposts["English"]["CrimeRate"]="";$fieldLabelsposts["English"]["BackupProximity"]="Backup Proximity";$fieldToolTipsposts["English"]["BackupProximity"]="";$placeHoldersposts["English"]["BackupProximity"]="";$fieldLabelsposts["English"]["LabourProximity"]="Labour Proximity";$fieldToolTipsposts["English"]["LabourProximity"]="";$placeHoldersposts["English"]["LabourProximity"]="";$fieldLabelsposts["English"]["LivingStandard"]="Living Standard";$fieldToolTipsposts["English"]["LivingStandard"]="";$placeHoldersposts["English"]["LivingStandard"]="";$fieldLabelsposts["English"]["ContentValue"]="Content Value";$fieldToolTipsposts["English"]["ContentValue"]="";$placeHoldersposts["English"]["ContentValue"]="";$fieldLabelsposts["English"]["OptionalCoverage"]="Optional Coverage";$fieldToolTipsposts["English"]["OptionalCoverage"]="";$placeHoldersposts["English"]["OptionalCoverage"]="";$fieldLabelsposts["English"]["VulnerabilityScore"]="Vulnerability Score";$fieldToolTipsposts["English"]["VulnerabilityScore"]="";$placeHoldersposts["English"]["VulnerabilityScore"]="";$fieldLabelsposts["English"]["OtherObservations"]="Other Observations";$fieldToolTipsposts["English"]["OtherObservations"]="";$placeHoldersposts["English"]["OtherObservations"]="";$fieldLabelsposts["English"]["Status"]="Status";$fieldToolTipsposts["English"]["Status"]="";$placeHoldersposts["English"]["Status"]="";$fieldLabelsposts["English"]["AccessmentDate"]="Accessment Date";$fieldToolTipsposts["English"]["AccessmentDate"]="";$placeHoldersposts["English"]["AccessmentDate"]="";$fieldLabelsposts["English"]["ContractDate"]="Contract Date";$fieldToolTipsposts["English"]["ContractDate"]="";$placeHoldersposts["English"]["ContractDate"]="";$fieldLabelsposts["English"]["Entrance_Exits"]="Entrance Exits";$fieldToolTipsposts["English"]["Entrance_Exits"]="";$placeHoldersposts["English"]["Entrance_Exits"]="";$fieldLabelsposts["English"]["MotionAlarm"]="Motion Alarm";$fieldToolTipsposts["English"]["MotionAlarm"]="";$placeHoldersposts["English"]["MotionAlarm"]="";$fieldLabelsposts["English"]["SmokeAlarm"]="Smoke Alarm";$fieldToolTipsposts["English"]["SmokeAlarm"]="";$placeHoldersposts["English"]["SmokeAlarm"]="";$fieldLabelsposts["English"]["Photos"]="Photos";$fieldToolTipsposts["English"]["Photos"]="";$placeHoldersposts["English"]["Photos"]="";$fieldLabelsposts["English"]["Contact"]="Contact";$fieldToolTipsposts["English"]["Contact"]="";$placeHoldersposts["English"]["Contact"]="";$fieldLabelsposts["English"]["OtherRecommendations"]="Other Recommendations";$fieldToolTipsposts["English"]["OtherRecommendations"]="";$placeHoldersposts["English"]["OtherRecommendations"]="";$fieldLabelsposts["English"]["FenceRemark"]="Fence Remark";$fieldToolTipsposts["English"]["FenceRemark"]="";$placeHoldersposts["English"]["FenceRemark"]="";$fieldLabelsposts["English"]["LightsRemark"]="Lights Remark";$fieldToolTipsposts["English"]["LightsRemark"]="";$placeHoldersposts["English"]["LightsRemark"]="";$fieldLabelsposts["English"]["FireExtinguisherRemark"]="Fire Extinguisher Remark";$fieldToolTipsposts["English"]["FireExtinguisherRemark"]="";$placeHoldersposts["English"]["FireExtinguisherRemark"]="";$fieldLabelsposts["English"]["SecurityPostRemark"]="Security Post Remark";$fieldToolTipsposts["English"]["SecurityPostRemark"]="";$placeHoldersposts["English"]["SecurityPostRemark"]="";$fieldLabelsposts["English"]["CCTV_Remark"]="CCTV Remark";$fieldToolTipsposts["English"]["CCTV_Remark"]="";$placeHoldersposts["English"]["CCTV_Remark"]="";$fieldLabelsposts["English"]["CrimeRateRemark"]="Crime Rate Remark";$fieldToolTipsposts["English"]["CrimeRateRemark"]="";$placeHoldersposts["English"]["CrimeRateRemark"]="";$fieldLabelsposts["English"]["BackupProximityRemark"]="Backup Proximity Remark";$fieldToolTipsposts["English"]["BackupProximityRemark"]="";$placeHoldersposts["English"]["BackupProximityRemark"]="";$fieldLabelsposts["English"]["LabourProximityRemark"]="Labour Proximity Remark";$fieldToolTipsposts["English"]["LabourProximityRemark"]="";$placeHoldersposts["English"]["LabourProximityRemark"]="";$fieldLabelsposts["English"]["LivingStandardRemark"]="Living Standard Remark";$fieldToolTipsposts["English"]["LivingStandardRemark"]="";$placeHoldersposts["English"]["LivingStandardRemark"]="";$fieldLabelsposts["English"]["ContentValueRemark"]="Content Value Remark";$fieldToolTipsposts["English"]["ContentValueRemark"]="";$placeHoldersposts["English"]["ContentValueRemark"]="";$fieldLabelsposts["English"]["Entrance_ExitsRemark"]="Entrance ExitsRemark";$fieldToolTipsposts["English"]["Entrance_ExitsRemark"]="";$placeHoldersposts["English"]["Entrance_ExitsRemark"]="";$fieldLabelsposts["English"]["Accessibility"]="Accessibility";$fieldToolTipsposts["English"]["Accessibility"]="";$placeHoldersposts["English"]["Accessibility"]="";$fieldLabelsposts["English"]["AccessibilityRemark"]="Accessibility Remark";$fieldToolTipsposts["English"]["AccessibilityRemark"]="";$placeHoldersposts["English"]["AccessibilityRemark"]="";$fieldLabelsposts["English"]["MotionAlarmRemark"]="Motion Alarm Remark";$fieldToolTipsposts["English"]["MotionAlarmRemark"]="";$placeHoldersposts["English"]["MotionAlarmRemark"]="";$fieldLabelsposts["English"]["SmokeAlarmRemark"]="Smoke Alarm Remark";$fieldToolTipsposts["English"]["SmokeAlarmRemark"]="";$placeHoldersposts["English"]["SmokeAlarmRemark"]="";$fieldLabelsposts["English"]["OptionalCoverageRemark"]="Optional Coverage Remark";$fieldToolTipsposts["English"]["OptionalCoverageRemark"]="";$placeHoldersposts["English"]["OptionalCoverageRemark"]="";$fieldLabelsposts["English"]["Lon"]="Lon";$fieldToolTipsposts["English"]["Lon"]="";$placeHoldersposts["English"]["Lon"]="";$fieldLabelsposts["English"]["Controller"]="Controller";$fieldToolTipsposts["English"]["Controller"]="";$placeHoldersposts["English"]["Controller"]="";if(count($fieldToolTipsposts["English"]))
  3. $tdataposts[".isUseToolTips"]=true;}
  4. $tdataposts[".NCSearch"]=true;$tdataposts[".shortTableName"]="posts";$tdataposts[".nSecOptions"]=1;$tdataposts[".mainTableOwnerID"]="Controller";$tdataposts[".entityType"]=0;$tdataposts[".connId"]="ssci_office_at_localhost";$tdataposts[".strOriginalTableName"]="posts";$tdataposts[".showAddInPopup"]=false;$tdataposts[".showEditInPopup"]=false;$tdataposts[".showViewInPopup"]=false;$popupPagesLayoutNames=array();$tdataposts[".popupPagesLayoutNames"]=$popupPagesLayoutNames;$tdataposts[".listAjax"]=false;$tdataposts[".listAjax"]=false;$tdataposts[".audit"]=false;$tdataposts[".locking"]=false;$pages=$tdataposts[".defaultPages"];if($pages[PAGE_EDIT]){$tdataposts[".edit"]=true;$tdataposts[".afterEditAction"]=1;$tdataposts[".closePopupAfterEdit"]=1;$tdataposts[".afterEditActionDetTable"]="";}
  5. if($pages[PAGE_ADD]){$tdataposts[".add"]=true;$tdataposts[".afterAddAction"]=4;$tdataposts[".closePopupAfterAdd"]=1;$tdataposts[".afterAddActionDetTable"]="service";}
  6. if($pages[PAGE_LIST]){$tdataposts[".list"]=true;}
  7. $tdataposts[".strSortControlSettingsJSON"]="";if($pages[PAGE_VIEW]){$tdataposts[".view"]=true;}
  8. if($pages[PAGE_IMPORT]){$tdataposts[".import"]=true;}
  9. if($pages[PAGE_EXPORT]){$tdataposts[".exportTo"]=true;}
  10. if($pages[PAGE_PRINT]){$tdataposts[".printFriendly"]=true;}
  11. $tdataposts[".showSimpleSearchOptions"]=true;$tdataposts[".allowShowHideFields"]=true;$tdataposts[".allowFieldsReordering"]=true;$tdataposts[".isUseAjaxSuggest"]=true;$tdataposts[".rowHighlite"]=true;$tdataposts[".ajaxCodeSnippetAdded"]=false;$tdataposts[".buttonsAdded"]=false;$tdataposts[".addPageEvents"]=true;$tdataposts[".isUseTimeForSearch"]=false;$tdataposts[".badgeColor"]="CFAE83";$tdataposts[".allSearchFields"]=array();$tdataposts[".filterFields"]=array();$tdataposts[".requiredSearchFields"]=array();$tdataposts[".googleLikeFields"]=array();$tdataposts[".googleLikeFields"][]="PostID";$tdataposts[".googleLikeFields"][]="Facility_Name";$tdataposts[".googleLikeFields"][]="Owner";$tdataposts[".googleLikeFields"][]="Address";$tdataposts[".googleLikeFields"][]="Lon";$tdataposts[".googleLikeFields"][]="Lat";$tdataposts[".googleLikeFields"][]="FacilityType";$tdataposts[".googleLikeFields"][]="Fence";$tdataposts[".googleLikeFields"][]="FenceRemark";$tdataposts[".googleLikeFields"][]="Lights";$tdataposts[".googleLikeFields"][]="LightsRemark";$tdataposts[".googleLikeFields"][]="FireExtinguisher";$tdataposts[".googleLikeFields"][]="FireExtinguisherRemark";$tdataposts[".googleLikeFields"][]="SecurityPost";$tdataposts[".googleLikeFields"][]="SecurityPostRemark";$tdataposts[".googleLikeFields"][]="CCTV";$tdataposts[".googleLikeFields"][]="CCTV_Remark";$tdataposts[".googleLikeFields"][]="CrimeRate";$tdataposts[".googleLikeFields"][]="CrimeRateRemark";$tdataposts[".googleLikeFields"][]="BackupProximity";$tdataposts[".googleLikeFields"][]="BackupProximityRemark";$tdataposts[".googleLikeFields"][]="LabourProximity";$tdataposts[".googleLikeFields"][]="LabourProximityRemark";$tdataposts[".googleLikeFields"][]="LivingStandard";$tdataposts[".googleLikeFields"][]="LivingStandardRemark";$tdataposts[".googleLikeFields"][]="ContentValue";$tdataposts[".googleLikeFields"][]="ContentValueRemark";$tdataposts[".googleLikeFields"][]="OptionalCoverage";$tdataposts[".googleLikeFields"][]="OptionalCoverageRemark";$tdataposts[".googleLikeFields"][]="VulnerabilityScore";$tdataposts[".googleLikeFields"][]="OtherObservations";$tdataposts[".googleLikeFields"][]="Status";$tdataposts[".googleLikeFields"][]="AccessmentDate";$tdataposts[".googleLikeFields"][]="ContractDate";$tdataposts[".googleLikeFields"][]="Entrance_Exits";$tdataposts[".googleLikeFields"][]="Entrance_ExitsRemark";$tdataposts[".googleLikeFields"][]="Accessibility";$tdataposts[".googleLikeFields"][]="AccessibilityRemark";$tdataposts[".googleLikeFields"][]="MotionAlarm";$tdataposts[".googleLikeFields"][]="MotionAlarmRemark";$tdataposts[".googleLikeFields"][]="SmokeAlarm";$tdataposts[".googleLikeFields"][]="SmokeAlarmRemark";$tdataposts[".googleLikeFields"][]="Photos";$tdataposts[".googleLikeFields"][]="Contact";$tdataposts[".googleLikeFields"][]="OtherRecommendations";$tdataposts[".googleLikeFields"][]="Controller";$tdataposts[".tableType"]="list";$tdataposts[".printerPageOrientation"]=0;$tdataposts[".nPrinterPageScale"]=100;$tdataposts[".nPrinterSplitRecords"]=40;$tdataposts[".geocodingEnabled"]=true;$tdataposts[".geocodingData"]=array();$tdataposts[".geocodingData"]["latField"]="Lat";$tdataposts[".geocodingData"]["lngField"]="Lon";$tdataposts[".geocodingData"]["addressFields"]=array();$tdataposts[".geocodingData"]["addressFields"][]="Facility_Name";$tdataposts[".geocodingData"]["addressFields"][]="Address";$tdataposts[".pageSize"]=20;$tdataposts[".warnLeavingPages"]=true;$tstrOrderBy="";if(strlen($tstrOrderBy)&&strtolower(substr($tstrOrderBy,0,8))!="order by")
  12. $tstrOrderBy="order by ".$tstrOrderBy;$tdataposts[".strOrderBy"]=$tstrOrderBy;$tdataposts[".orderindexes"]=array();$tdataposts[".sqlHead"]="SELECT PostID,   Facility_Name,   Owner,   Address,   Lon,   Lat,   FacilityType,   Fence,   FenceRemark,   Lights,   LightsRemark,   FireExtinguisher,   FireExtinguisherRemark,   SecurityPost,   SecurityPostRemark,   CCTV,   CCTV_Remark,   CrimeRate,   CrimeRateRemark,   BackupProximity,   BackupProximityRemark,   LabourProximity,   LabourProximityRemark,   LivingStandard,   LivingStandardRemark,   ContentValue,   ContentValueRemark,   OptionalCoverage,   OptionalCoverageRemark,   VulnerabilityScore,   OtherObservations,   Status,   AccessmentDate,   ContractDate,   Entrance_Exits,   Entrance_ExitsRemark,   Accessibility,   AccessibilityRemark,   MotionAlarm,   MotionAlarmRemark,   SmokeAlarm,   SmokeAlarmRemark,   Photos,   Contact,   OtherRecommendations,Controller";$tdataposts[".sqlFrom"]="FROM posts inner join control_zones on Facility_Name=Post";$tdataposts[".sqlWhereExpr"]="";$tdataposts[".sqlTail"]="";$arrRPP=array();$arrRPP[]=10;$arrRPP[]=20;$arrRPP[]=30;$arrRPP[]=50;$arrRPP[]=100;$arrRPP[]=500;$arrRPP[]=-1;$tdataposts[".arrRecsPerPage"]=$arrRPP;$arrGPP=array();$arrGPP[]=1;$arrGPP[]=3;$arrGPP[]=5;$arrGPP[]=10;$arrGPP[]=50;$arrGPP[]=100;$arrGPP[]=-1;$tdataposts[".arrGroupsPerPage"]=$arrGPP;$tdataposts[".highlightSearchResults"]=true;$tableKeysposts=array();$tableKeysposts[]="PostID";$tdataposts[".Keys"]=$tableKeysposts;$tdataposts[".hideMobileList"]=array();$tdataposts[".hideMobileList"][5]=array();$tdataposts[".hideMobileList"][5]["PostID"]=true;$tdataposts[".hideMobileList"][5]["Lat"]=true;$tdataposts[".hideMobileList"][5]["FacilityType"]=true;$tdataposts[".hideMobileList"][5]["Fence"]=true;$tdataposts[".hideMobileList"][5]["Lights"]=true;$tdataposts[".hideMobileList"][5]["FireExtinguisher"]=true;$tdataposts[".hideMobileList"][5]["SecurityPost"]=true;$tdataposts[".hideMobileList"][5]["CCTV"]=true;$tdataposts[".hideMobileList"][5]["CrimeRate"]=true;$tdataposts[".hideMobileList"][5]["BackupProximity"]=true;$tdataposts[".hideMobileList"][5]["LabourProximity"]=true;$tdataposts[".hideMobileList"][5]["LivingStandard"]=true;$tdataposts[".hideMobileList"][5]["ContentValue"]=true;$tdataposts[".hideMobileList"][5]["OptionalCoverage"]=true;$tdataposts[".hideMobileList"][5]["OtherObservations"]=true;$tdataposts[".hideMobileList"][5]["AccessmentDate"]=true;$tdataposts[".hideMobileList"][5]["ContractDate"]=true;$tdataposts[".hideMobileList"][5]["Entrance_Exits"]=true;$tdataposts[".hideMobileList"][5]["MotionAlarm"]=true;$tdataposts[".hideMobileList"][5]["SmokeAlarm"]=true;$tdataposts[".hideMobileList"][5]["Photos"]=true;$fdata=array();$fdata["Index"]=1;$fdata["strName"]="PostID";$fdata["GoodName"]="PostID";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","PostID");$fdata["FieldType"]=3;$fdata["AutoInc"]=true;$fdata["strField"]="PostID";$fdata["isSQLExpression"]=true;$fdata["FullName"]="PostID";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]=getJsValidatorName("Number");$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["PostID"]=$fdata;$tdataposts[".searchableFields"][]="PostID";$fdata=array();$fdata["Index"]=2;$fdata["strName"]="Facility_Name";$fdata["GoodName"]="Facility_Name";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Facility_Name");$fdata["FieldType"]=200;$fdata["strField"]="Facility_Name";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Facility_Name";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["EditParams"].=" maxlength=50";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$edata["validateAs"]["basicValidate"][]="DenyDuplicated";$edata["validateAs"]["customMessages"]["DenyDuplicated"]=array("message"=>"Value %value% already exists","messageType"=>"Text");$edata["denyDuplicates"]=true;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Facility_Name"]=$fdata;$tdataposts[".searchableFields"][]="Facility_Name";$fdata=array();$fdata["Index"]=3;$fdata["strName"]="Owner";$fdata["GoodName"]="Owner";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Owner");$fdata["FieldType"]=200;$fdata["strField"]="Owner";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Owner";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=2;$edata["LookupTable"]="clients";$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["autoCompleteFields"][]=array('masterF'=>"Address",'lookupF'=>"Address");$edata["autoCompleteFields"][]=array('masterF'=>"Contact",'lookupF'=>"Phone");$edata["LCType"]=0;$edata["LookupUnique"]=true;$edata["LinkField"]="FullName";$edata["LinkFieldType"]=0;$edata["DisplayField"]="FullName";$edata["LookupOrderBy"]="";$edata["AllowToAdd"]=true;$edata["addPageId"]="add";$edata["SelectSize"]=1;$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Owner"]=$fdata;$tdataposts[".searchableFields"][]="Owner";$fdata=array();$fdata["Index"]=4;$fdata["strName"]="Address";$fdata["GoodName"]="Address";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Address");$fdata["FieldType"]=200;$fdata["strField"]="Address";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Address";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["EditParams"].=" maxlength=50";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Address"]=$fdata;$tdataposts[".searchableFields"][]="Address";$fdata=array();$fdata["Index"]=5;$fdata["strName"]="Lon";$fdata["GoodName"]="Lon";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Lon");$fdata["FieldType"]=14;$fdata["strField"]="Lon";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Lon";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=7;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=7;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["list"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=0;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["print"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=0;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["export"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=6;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["masterlist"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=6;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["masterprint"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]=getJsValidatorName("Number");$fdata["EditFormats"]["edit"]=$edata;$edata=array("EditFormat"=>"Readonly");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["add"]=$edata;$edata=array("EditFormat"=>"Readonly");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["search"]=$edata;$fdata["isSeparate"]=true;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Lon"]=$fdata;$tdataposts[".searchableFields"][]="Lon";$fdata=array();$fdata["Index"]=6;$fdata["strName"]="Lat";$fdata["GoodName"]="Lat";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Lat");$fdata["FieldType"]=14;$fdata["strField"]="Lat";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Lat";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=7;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=7;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["list"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=0;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["print"]=$vdata;$vdata=array("ViewFormat"=>"Number");$vdata["DecimalDigits"]=0;$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["export"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]=getJsValidatorName("Number");$fdata["EditFormats"]["edit"]=$edata;$edata=array("EditFormat"=>"Readonly");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["add"]=$edata;$edata=array("EditFormat"=>"Readonly");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["search"]=$edata;$fdata["isSeparate"]=true;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Lat"]=$fdata;$tdataposts[".searchableFields"][]="Lat";$fdata=array();$fdata["Index"]=7;$fdata["strName"]="FacilityType";$fdata["GoodName"]="FacilityType";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","FacilityType");$fdata["FieldType"]=200;$fdata["strField"]="FacilityType";$fdata["isSQLExpression"]=true;$fdata["FullName"]="FacilityType";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=0;$edata["LookupValues"]=array();$edata["LookupValues"][]="Residence";$edata["LookupValues"][]="Office";$edata["LookupValues"][]="Industry";$edata["LookupValues"][]="Construction Site";$edata["LookupValues"][]="Event";$edata["LookupValues"][]="Hospital";$edata["LookupValues"][]="School";$edata["LookupValues"][]="Bank";$edata["LookupValues"][]="Hotel/Bar/Restaurant";$edata["LookupValues"][]="Shop";$edata["LookupValues"][]="Other";$edata["SelectSize"]=1;$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["FacilityType"]=$fdata;$tdataposts[".searchableFields"][]="FacilityType";$fdata=array();$fdata["Index"]=8;$fdata["strName"]="Fence";$fdata["GoodName"]="Fence";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Fence");$fdata["FieldType"]=3;$fdata["strField"]="Fence";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Fence";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Fence"]=$fdata;$tdataposts[".searchableFields"][]="Fence";$fdata=array();$fdata["Index"]=9;$fdata["strName"]="FenceRemark";$fdata["GoodName"]="FenceRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","FenceRemark");$fdata["FieldType"]=201;$fdata["strField"]="FenceRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="FenceRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["FenceRemark"]=$fdata;$tdataposts[".searchableFields"][]="FenceRemark";$fdata=array();$fdata["Index"]=10;$fdata["strName"]="Lights";$fdata["GoodName"]="Lights";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Lights");$fdata["FieldType"]=3;$fdata["strField"]="Lights";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Lights";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Lights"]=$fdata;$tdataposts[".searchableFields"][]="Lights";$fdata=array();$fdata["Index"]=11;$fdata["strName"]="LightsRemark";$fdata["GoodName"]="LightsRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","LightsRemark");$fdata["FieldType"]=201;$fdata["strField"]="LightsRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="LightsRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["LightsRemark"]=$fdata;$tdataposts[".searchableFields"][]="LightsRemark";$fdata=array();$fdata["Index"]=12;$fdata["strName"]="FireExtinguisher";$fdata["GoodName"]="FireExtinguisher";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","FireExtinguisher");$fdata["FieldType"]=3;$fdata["strField"]="FireExtinguisher";$fdata["isSQLExpression"]=true;$fdata["FullName"]="FireExtinguisher";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["FireExtinguisher"]=$fdata;$tdataposts[".searchableFields"][]="FireExtinguisher";$fdata=array();$fdata["Index"]=13;$fdata["strName"]="FireExtinguisherRemark";$fdata["GoodName"]="FireExtinguisherRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","FireExtinguisherRemark");$fdata["FieldType"]=201;$fdata["strField"]="FireExtinguisherRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="FireExtinguisherRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["FireExtinguisherRemark"]=$fdata;$tdataposts[".searchableFields"][]="FireExtinguisherRemark";$fdata=array();$fdata["Index"]=14;$fdata["strName"]="SecurityPost";$fdata["GoodName"]="SecurityPost";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","SecurityPost");$fdata["FieldType"]=3;$fdata["strField"]="SecurityPost";$fdata["isSQLExpression"]=true;$fdata["FullName"]="SecurityPost";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["SecurityPost"]=$fdata;$tdataposts[".searchableFields"][]="SecurityPost";$fdata=array();$fdata["Index"]=15;$fdata["strName"]="SecurityPostRemark";$fdata["GoodName"]="SecurityPostRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","SecurityPostRemark");$fdata["FieldType"]=201;$fdata["strField"]="SecurityPostRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="SecurityPostRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["SecurityPostRemark"]=$fdata;$tdataposts[".searchableFields"][]="SecurityPostRemark";$fdata=array();$fdata["Index"]=16;$fdata["strName"]="CCTV";$fdata["GoodName"]="CCTV";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","CCTV");$fdata["FieldType"]=3;$fdata["strField"]="CCTV";$fdata["isSQLExpression"]=true;$fdata["FullName"]="CCTV";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["CCTV"]=$fdata;$tdataposts[".searchableFields"][]="CCTV";$fdata=array();$fdata["Index"]=17;$fdata["strName"]="CCTV_Remark";$fdata["GoodName"]="CCTV_Remark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","CCTV_Remark");$fdata["FieldType"]=201;$fdata["strField"]="CCTV_Remark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="CCTV_Remark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["CCTV_Remark"]=$fdata;$tdataposts[".searchableFields"][]="CCTV_Remark";$fdata=array();$fdata["Index"]=18;$fdata["strName"]="CrimeRate";$fdata["GoodName"]="CrimeRate";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","CrimeRate");$fdata["FieldType"]=3;$fdata["strField"]="CrimeRate";$fdata["isSQLExpression"]=true;$fdata["FullName"]="CrimeRate";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["CrimeRate"]=$fdata;$tdataposts[".searchableFields"][]="CrimeRate";$fdata=array();$fdata["Index"]=19;$fdata["strName"]="CrimeRateRemark";$fdata["GoodName"]="CrimeRateRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","CrimeRateRemark");$fdata["FieldType"]=201;$fdata["strField"]="CrimeRateRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="CrimeRateRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["CrimeRateRemark"]=$fdata;$tdataposts[".searchableFields"][]="CrimeRateRemark";$fdata=array();$fdata["Index"]=20;$fdata["strName"]="BackupProximity";$fdata["GoodName"]="BackupProximity";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","BackupProximity");$fdata["FieldType"]=3;$fdata["strField"]="BackupProximity";$fdata["isSQLExpression"]=true;$fdata["FullName"]="BackupProximity";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["BackupProximity"]=$fdata;$tdataposts[".searchableFields"][]="BackupProximity";$fdata=array();$fdata["Index"]=21;$fdata["strName"]="BackupProximityRemark";$fdata["GoodName"]="BackupProximityRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","BackupProximityRemark");$fdata["FieldType"]=201;$fdata["strField"]="BackupProximityRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="BackupProximityRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["BackupProximityRemark"]=$fdata;$tdataposts[".searchableFields"][]="BackupProximityRemark";$fdata=array();$fdata["Index"]=22;$fdata["strName"]="LabourProximity";$fdata["GoodName"]="LabourProximity";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","LabourProximity");$fdata["FieldType"]=3;$fdata["strField"]="LabourProximity";$fdata["isSQLExpression"]=true;$fdata["FullName"]="LabourProximity";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["LabourProximity"]=$fdata;$tdataposts[".searchableFields"][]="LabourProximity";$fdata=array();$fdata["Index"]=23;$fdata["strName"]="LabourProximityRemark";$fdata["GoodName"]="LabourProximityRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","LabourProximityRemark");$fdata["FieldType"]=201;$fdata["strField"]="LabourProximityRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="LabourProximityRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["LabourProximityRemark"]=$fdata;$tdataposts[".searchableFields"][]="LabourProximityRemark";$fdata=array();$fdata["Index"]=24;$fdata["strName"]="LivingStandard";$fdata["GoodName"]="LivingStandard";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","LivingStandard");$fdata["FieldType"]=3;$fdata["strField"]="LivingStandard";$fdata["isSQLExpression"]=true;$fdata["FullName"]="LivingStandard";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["LivingStandard"]=$fdata;$tdataposts[".searchableFields"][]="LivingStandard";$fdata=array();$fdata["Index"]=25;$fdata["strName"]="LivingStandardRemark";$fdata["GoodName"]="LivingStandardRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","LivingStandardRemark");$fdata["FieldType"]=201;$fdata["strField"]="LivingStandardRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="LivingStandardRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["LivingStandardRemark"]=$fdata;$tdataposts[".searchableFields"][]="LivingStandardRemark";$fdata=array();$fdata["Index"]=26;$fdata["strName"]="ContentValue";$fdata["GoodName"]="ContentValue";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","ContentValue");$fdata["FieldType"]=3;$fdata["strField"]="ContentValue";$fdata["isSQLExpression"]=true;$fdata["FullName"]="ContentValue";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["ContentValue"]=$fdata;$tdataposts[".searchableFields"][]="ContentValue";$fdata=array();$fdata["Index"]=27;$fdata["strName"]="ContentValueRemark";$fdata["GoodName"]="ContentValueRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","ContentValueRemark");$fdata["FieldType"]=201;$fdata["strField"]="ContentValueRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="ContentValueRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["ContentValueRemark"]=$fdata;$tdataposts[".searchableFields"][]="ContentValueRemark";$fdata=array();$fdata["Index"]=28;$fdata["strName"]="OptionalCoverage";$fdata["GoodName"]="OptionalCoverage";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","OptionalCoverage");$fdata["FieldType"]=3;$fdata["strField"]="OptionalCoverage";$fdata["isSQLExpression"]=true;$fdata["FullName"]="OptionalCoverage";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["OptionalCoverage"]=$fdata;$tdataposts[".searchableFields"][]="OptionalCoverage";$fdata=array();$fdata["Index"]=29;$fdata["strName"]="OptionalCoverageRemark";$fdata["GoodName"]="OptionalCoverageRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","OptionalCoverageRemark");$fdata["FieldType"]=201;$fdata["strField"]="OptionalCoverageRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="OptionalCoverageRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["OptionalCoverageRemark"]=$fdata;$tdataposts[".searchableFields"][]="OptionalCoverageRemark";$fdata=array();$fdata["Index"]=30;$fdata["strName"]="VulnerabilityScore";$fdata["GoodName"]="VulnerabilityScore";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","VulnerabilityScore");$fdata["FieldType"]=200;$fdata["strField"]="VulnerabilityScore";$fdata["isSQLExpression"]=true;$fdata["FullName"]="VulnerabilityScore";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["VulnerabilityScore"]=$fdata;$tdataposts[".searchableFields"][]="VulnerabilityScore";$fdata=array();$fdata["Index"]=31;$fdata["strName"]="OtherObservations";$fdata["GoodName"]="OtherObservations";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","OtherObservations");$fdata["FieldType"]=201;$fdata["strField"]="OtherObservations";$fdata["isSQLExpression"]=true;$fdata["FullName"]="OtherObservations";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["OtherObservations"]=$fdata;$tdataposts[".searchableFields"][]="OtherObservations";$fdata=array();$fdata["Index"]=32;$fdata["strName"]="Status";$fdata["GoodName"]="Status";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Status");$fdata["FieldType"]=200;$fdata["strField"]="Status";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Status";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=0;$edata["LookupValues"]=array();$edata["LookupValues"][]="Pending";$edata["LookupValues"][]="Operational";$edata["LookupValues"][]="Terminated";$edata["SelectSize"]=1;$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Status"]=$fdata;$tdataposts[".searchableFields"][]="Status";$fdata=array();$fdata["Index"]=33;$fdata["strName"]="AccessmentDate";$fdata["GoodName"]="AccessmentDate";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","AccessmentDate");$fdata["FieldType"]=7;$fdata["strField"]="AccessmentDate";$fdata["isSQLExpression"]=true;$fdata["FullName"]="AccessmentDate";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"Short Date");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Date");$edata["weekdayMessage"]=array("message"=>"Invalid week day","messageType"=>"Text");$edata["weekdays"]="[]";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["DateEditType"]=5;$edata["InitialYearFactor"]=100;$edata["LastYearFactor"]=10;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Equals","More than","Less than","Between",EMPTY_SEARCH,NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["AccessmentDate"]=$fdata;$tdataposts[".searchableFields"][]="AccessmentDate";$fdata=array();$fdata["Index"]=34;$fdata["strName"]="ContractDate";$fdata["GoodName"]="ContractDate";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","ContractDate");$fdata["FieldType"]=7;$fdata["strField"]="ContractDate";$fdata["isSQLExpression"]=true;$fdata["FullName"]="ContractDate";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"Short Date");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Date");$edata["weekdayMessage"]=array("message"=>"Invalid week day","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["DateEditType"]=5;$edata["InitialYearFactor"]=100;$edata["LastYearFactor"]=10;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Equals","More than","Less than","Between",EMPTY_SEARCH,NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["ContractDate"]=$fdata;$tdataposts[".searchableFields"][]="ContractDate";$fdata=array();$fdata["Index"]=35;$fdata["strName"]="Entrance_Exits";$fdata["GoodName"]="Entrance_Exits";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Entrance_Exits");$fdata["FieldType"]=3;$fdata["strField"]="Entrance_Exits";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Entrance_Exits";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Entrance_Exits"]=$fdata;$tdataposts[".searchableFields"][]="Entrance_Exits";$fdata=array();$fdata["Index"]=36;$fdata["strName"]="Entrance_ExitsRemark";$fdata["GoodName"]="Entrance_ExitsRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Entrance_ExitsRemark");$fdata["FieldType"]=201;$fdata["strField"]="Entrance_ExitsRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Entrance_ExitsRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Entrance_ExitsRemark"]=$fdata;$tdataposts[".searchableFields"][]="Entrance_ExitsRemark";$fdata=array();$fdata["Index"]=37;$fdata["strName"]="Accessibility";$fdata["GoodName"]="Accessibility";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Accessibility");$fdata["FieldType"]=201;$fdata["strField"]="Accessibility";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Accessibility";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Accessibility"]=$fdata;$tdataposts[".searchableFields"][]="Accessibility";$fdata=array();$fdata["Index"]=38;$fdata["strName"]="AccessibilityRemark";$fdata["GoodName"]="AccessibilityRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","AccessibilityRemark");$fdata["FieldType"]=201;$fdata["strField"]="AccessibilityRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="AccessibilityRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["AccessibilityRemark"]=$fdata;$tdataposts[".searchableFields"][]="AccessibilityRemark";$fdata=array();$fdata["Index"]=39;$fdata["strName"]="MotionAlarm";$fdata["GoodName"]="MotionAlarm";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","MotionAlarm");$fdata["FieldType"]=3;$fdata["strField"]="MotionAlarm";$fdata["isSQLExpression"]=true;$fdata["FullName"]="MotionAlarm";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["MotionAlarm"]=$fdata;$tdataposts[".searchableFields"][]="MotionAlarm";$fdata=array();$fdata["Index"]=40;$fdata["strName"]="MotionAlarmRemark";$fdata["GoodName"]="MotionAlarmRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","MotionAlarmRemark");$fdata["FieldType"]=201;$fdata["strField"]="MotionAlarmRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="MotionAlarmRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["MotionAlarmRemark"]=$fdata;$tdataposts[".searchableFields"][]="MotionAlarmRemark";$fdata=array();$fdata["Index"]=41;$fdata["strName"]="SmokeAlarm";$fdata["GoodName"]="SmokeAlarm";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","SmokeAlarm");$fdata["FieldType"]=3;$fdata["strField"]="SmokeAlarm";$fdata["isSQLExpression"]=true;$fdata["FullName"]="SmokeAlarm";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Lookup wizard");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["LookupType"]=0;$edata["autoCompleteFieldsOnEdit"]=0;$edata["autoCompleteFields"]=array();$edata["LCType"]=4;$edata["HorizontalLookup"]=true;$edata["LookupValues"]=array();$edata["LookupValues"][]="0";$edata["LookupValues"][]="1";$edata["LookupValues"][]="2";$edata["LookupValues"][]="3";$edata["LookupValues"][]="4";$edata["LookupValues"][]="5";$edata["IsRequired"]=true;$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["validateAs"]["basicValidate"][]="IsRequired";$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Equals";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["SmokeAlarm"]=$fdata;$tdataposts[".searchableFields"][]="SmokeAlarm";$fdata=array();$fdata["Index"]=42;$fdata["strName"]="SmokeAlarmRemark";$fdata["GoodName"]="SmokeAlarmRemark";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","SmokeAlarmRemark");$fdata["FieldType"]=201;$fdata["strField"]="SmokeAlarmRemark";$fdata["isSQLExpression"]=true;$fdata["FullName"]="SmokeAlarmRemark";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["SmokeAlarmRemark"]=$fdata;$tdataposts[".searchableFields"][]="SmokeAlarmRemark";$fdata=array();$fdata["Index"]=43;$fdata["strName"]="Photos";$fdata["GoodName"]="Photos";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Photos");$fdata["FieldType"]=200;$fdata["strField"]="Photos";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Photos";$fdata["DeleteAssociatedFile"]=true;$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"File-based Image");$vdata["ImageWidth"]=300;$vdata["ImageHeight"]=300;$vdata["multipleImgMode"]=1;$vdata["maxImages"]=0;$vdata["showGallery"]=true;$vdata["galleryMode"]=1;$vdata["captionMode"]=1;$vdata["captionField"]="";$vdata["imageBorder"]=1;$vdata["imageFullWidth"]=1;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Document upload");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]="bmp";$edata["acceptFileTypesHtml"]=".bmp";$edata["acceptFileTypes"].="|gif";$edata["acceptFileTypesHtml"].=",.gif";$edata["acceptFileTypes"].="|jpg";$edata["acceptFileTypesHtml"].=",.jpg";$edata["acceptFileTypes"].="|png";$edata["acceptFileTypesHtml"].=",.png";$edata["acceptFileTypes"]="(".$edata["acceptFileTypes"].")$";$edata["maxNumberOfFiles"]=6;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["ResizeImage"]=true;$edata["NewSize"]=2000;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Photos"]=$fdata;$tdataposts[".searchableFields"][]="Photos";$fdata=array();$fdata["Index"]=44;$fdata["strName"]="Contact";$fdata["GoodName"]="Contact";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","Contact");$fdata["FieldType"]=200;$fdata["strField"]="Contact";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Contact";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="tel";$edata["EditParams"]="";$edata["EditParams"].=" maxlength=50";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Contact"]=$fdata;$tdataposts[".searchableFields"][]="Contact";$fdata=array();$fdata["Index"]=45;$fdata["strName"]="OtherRecommendations";$fdata["GoodName"]="OtherRecommendations";$fdata["ownerTable"]="posts";$fdata["Label"]=GetFieldLabel("posts","OtherRecommendations");$fdata["FieldType"]=201;$fdata["strField"]="OtherRecommendations";$fdata["isSQLExpression"]=true;$fdata["FullName"]="OtherRecommendations";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text area");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=0;$edata["nRows"]=100;$edata["nCols"]=200;$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$edata["CreateThumbnail"]=true;$edata["StrThumbnail"]="th";$edata["ThumbnailSize"]=600;$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["OtherRecommendations"]=$fdata;$tdataposts[".searchableFields"][]="OtherRecommendations";$fdata=array();$fdata["Index"]=46;$fdata["strName"]="Controller";$fdata["GoodName"]="Controller";$fdata["ownerTable"]="";$fdata["Label"]=GetFieldLabel("posts","Controller");$fdata["FieldType"]=200;$fdata["strField"]="Controller";$fdata["isSQLExpression"]=true;$fdata["FullName"]="Controller";$fdata["UploadFolder"]="files";$fdata["ViewFormats"]=array();$vdata=array("ViewFormat"=>"");$vdata["NeedEncode"]=true;$vdata["truncateText"]=true;$vdata["NumberOfChars"]=80;$fdata["ViewFormats"]["view"]=$vdata;$fdata["EditFormats"]=array();$edata=array("EditFormat"=>"Text field");$edata["weekdayMessage"]=array("message"=>"","messageType"=>"Text");$edata["weekdays"]="[]";$edata["acceptFileTypes"]=".+$";$edata["acceptFileTypesHtml"]="";$edata["maxNumberOfFiles"]=1;$edata["HTML5InuptType"]="text";$edata["EditParams"]="";$edata["controlWidth"]=200;$edata["validateAs"]=array();$edata["validateAs"]["basicValidate"]=array();$edata["validateAs"]["customMessages"]=array();$fdata["EditFormats"]["edit"]=$edata;$fdata["isSeparate"]=false;$fdata["defaultSearchOption"]="Contains";$fdata["searchOptionsList"]=array("Contains","Equals","Starts with","More than","Less than","Between","Empty",NOT_EMPTY);$fdata["filterTotals"]=0;$fdata["filterMultiSelect"]=0;$fdata["filterFormat"]="Values list";$fdata["showCollapsed"]=false;$fdata["sortValueType"]=0;$fdata["numberOfVisibleItems"]=10;$fdata["filterBy"]=0;$tdataposts["Controller"]=$fdata;$tdataposts[".searchableFields"][]="Controller";$tables_data["posts"]=&$tdataposts;$field_labels["posts"]=&$fieldLabelsposts;$fieldToolTips["posts"]=&$fieldToolTipsposts;$placeHolders["posts"]=&$placeHoldersposts;$page_titles["posts"]=&$pageTitlesposts;$detailsTablesData["posts"]=array();$dIndex=0;$detailsParam=array();$detailsParam["dDataSourceTable"]="service";$detailsParam["dOriginalTable"]="service";$detailsParam["dType"]=PAGE_LIST;$detailsParam["dShortTable"]="service";$detailsParam["dCaptionTable"]=GetTableCaption("service");$detailsParam["masterKeys"]=array();$detailsParam["detailKeys"]=array();$detailsTablesData["posts"][$dIndex]=$detailsParam;$detailsTablesData["posts"][$dIndex]["masterKeys"]=array();$detailsTablesData["posts"][$dIndex]["masterKeys"][]="PostID";$detailsTablesData["posts"][$dIndex]["detailKeys"]=array();$detailsTablesData["posts"][$dIndex]["detailKeys"][]="Post";$masterTablesData["posts"]=array();require_once(getabspath("classes/sql.php"));function createSqlQuery_posts(){$proto0=array();$proto0["m_strHead"]="SELECT";$proto0["m_strFieldList"]="PostID,   Facility_Name,   Owner,   Address,   Lon,   Lat,   FacilityType,   Fence,   FenceRemark,   Lights,   LightsRemark,   FireExtinguisher,   FireExtinguisherRemark,   SecurityPost,   SecurityPostRemark,   CCTV,   CCTV_Remark,   CrimeRate,   CrimeRateRemark,   BackupProximity,   BackupProximityRemark,   LabourProximity,   LabourProximityRemark,   LivingStandard,   LivingStandardRemark,   ContentValue,   ContentValueRemark,   OptionalCoverage,   OptionalCoverageRemark,   VulnerabilityScore,   OtherObservations,   Status,   AccessmentDate,   ContractDate,   Entrance_Exits,   Entrance_ExitsRemark,   Accessibility,   AccessibilityRemark,   MotionAlarm,   MotionAlarmRemark,   SmokeAlarm,   SmokeAlarmRemark,   Photos,   Contact,   OtherRecommendations,Controller";$proto0["m_strFrom"]="FROM posts inner join control_zones on Facility_Name=Post";$proto0["m_strWhere"]="";$proto0["m_strOrderBy"]="";;$proto0["cipherer"]=null;$proto2=array();$proto2["m_sql"]="";$proto2["m_uniontype"]="SQLL_UNKNOWN";$obj=new SQLNonParsed(array("m_sql"=>""));$proto2["m_column"]=$obj;$proto2["m_contained"]=array();$proto2["m_strCase"]="";$proto2["m_havingmode"]=false;$proto2["m_inBrackets"]=false;$proto2["m_useAlias"]=false;$obj=new SQLLogicalExpr($proto2);$proto0["m_where"]=$obj;$proto4=array();$proto4["m_sql"]="";$proto4["m_uniontype"]="SQLL_UNKNOWN";$obj=new SQLNonParsed(array("m_sql"=>""));$proto4["m_column"]=$obj;$proto4["m_contained"]=array();$proto4["m_strCase"]="";$proto4["m_havingmode"]=false;$proto4["m_inBrackets"]=false;$proto4["m_useAlias"]=false;$obj=new SQLLogicalExpr($proto4);$proto0["m_having"]=$obj;$proto0["m_fieldlist"]=array();$proto6=array();$obj=new SQLField(array("m_strName"=>"PostID","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto6["m_sql"]="PostID";$proto6["m_srcTableName"]="posts";$proto6["m_expr"]=$obj;$proto6["m_alias"]="";$obj=new SQLFieldListItem($proto6);$proto0["m_fieldlist"][]=$obj;$proto8=array();$obj=new SQLField(array("m_strName"=>"Facility_Name","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto8["m_sql"]="Facility_Name";$proto8["m_srcTableName"]="posts";$proto8["m_expr"]=$obj;$proto8["m_alias"]="";$obj=new SQLFieldListItem($proto8);$proto0["m_fieldlist"][]=$obj;$proto10=array();$obj=new SQLField(array("m_strName"=>"Owner","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto10["m_sql"]="Owner";$proto10["m_srcTableName"]="posts";$proto10["m_expr"]=$obj;$proto10["m_alias"]="";$obj=new SQLFieldListItem($proto10);$proto0["m_fieldlist"][]=$obj;$proto12=array();$obj=new SQLField(array("m_strName"=>"Address","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto12["m_sql"]="Address";$proto12["m_srcTableName"]="posts";$proto12["m_expr"]=$obj;$proto12["m_alias"]="";$obj=new SQLFieldListItem($proto12);$proto0["m_fieldlist"][]=$obj;$proto14=array();$obj=new SQLField(array("m_strName"=>"Lon","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto14["m_sql"]="Lon";$proto14["m_srcTableName"]="posts";$proto14["m_expr"]=$obj;$proto14["m_alias"]="";$obj=new SQLFieldListItem($proto14);$proto0["m_fieldlist"][]=$obj;$proto16=array();$obj=new SQLField(array("m_strName"=>"Lat","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto16["m_sql"]="Lat";$proto16["m_srcTableName"]="posts";$proto16["m_expr"]=$obj;$proto16["m_alias"]="";$obj=new SQLFieldListItem($proto16);$proto0["m_fieldlist"][]=$obj;$proto18=array();$obj=new SQLField(array("m_strName"=>"FacilityType","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto18["m_sql"]="FacilityType";$proto18["m_srcTableName"]="posts";$proto18["m_expr"]=$obj;$proto18["m_alias"]="";$obj=new SQLFieldListItem($proto18);$proto0["m_fieldlist"][]=$obj;$proto20=array();$obj=new SQLField(array("m_strName"=>"Fence","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto20["m_sql"]="Fence";$proto20["m_srcTableName"]="posts";$proto20["m_expr"]=$obj;$proto20["m_alias"]="";$obj=new SQLFieldListItem($proto20);$proto0["m_fieldlist"][]=$obj;$proto22=array();$obj=new SQLField(array("m_strName"=>"FenceRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto22["m_sql"]="FenceRemark";$proto22["m_srcTableName"]="posts";$proto22["m_expr"]=$obj;$proto22["m_alias"]="";$obj=new SQLFieldListItem($proto22);$proto0["m_fieldlist"][]=$obj;$proto24=array();$obj=new SQLField(array("m_strName"=>"Lights","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto24["m_sql"]="Lights";$proto24["m_srcTableName"]="posts";$proto24["m_expr"]=$obj;$proto24["m_alias"]="";$obj=new SQLFieldListItem($proto24);$proto0["m_fieldlist"][]=$obj;$proto26=array();$obj=new SQLField(array("m_strName"=>"LightsRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto26["m_sql"]="LightsRemark";$proto26["m_srcTableName"]="posts";$proto26["m_expr"]=$obj;$proto26["m_alias"]="";$obj=new SQLFieldListItem($proto26);$proto0["m_fieldlist"][]=$obj;$proto28=array();$obj=new SQLField(array("m_strName"=>"FireExtinguisher","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto28["m_sql"]="FireExtinguisher";$proto28["m_srcTableName"]="posts";$proto28["m_expr"]=$obj;$proto28["m_alias"]="";$obj=new SQLFieldListItem($proto28);$proto0["m_fieldlist"][]=$obj;$proto30=array();$obj=new SQLField(array("m_strName"=>"FireExtinguisherRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto30["m_sql"]="FireExtinguisherRemark";$proto30["m_srcTableName"]="posts";$proto30["m_expr"]=$obj;$proto30["m_alias"]="";$obj=new SQLFieldListItem($proto30);$proto0["m_fieldlist"][]=$obj;$proto32=array();$obj=new SQLField(array("m_strName"=>"SecurityPost","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto32["m_sql"]="SecurityPost";$proto32["m_srcTableName"]="posts";$proto32["m_expr"]=$obj;$proto32["m_alias"]="";$obj=new SQLFieldListItem($proto32);$proto0["m_fieldlist"][]=$obj;$proto34=array();$obj=new SQLField(array("m_strName"=>"SecurityPostRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto34["m_sql"]="SecurityPostRemark";$proto34["m_srcTableName"]="posts";$proto34["m_expr"]=$obj;$proto34["m_alias"]="";$obj=new SQLFieldListItem($proto34);$proto0["m_fieldlist"][]=$obj;$proto36=array();$obj=new SQLField(array("m_strName"=>"CCTV","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto36["m_sql"]="CCTV";$proto36["m_srcTableName"]="posts";$proto36["m_expr"]=$obj;$proto36["m_alias"]="";$obj=new SQLFieldListItem($proto36);$proto0["m_fieldlist"][]=$obj;$proto38=array();$obj=new SQLField(array("m_strName"=>"CCTV_Remark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto38["m_sql"]="CCTV_Remark";$proto38["m_srcTableName"]="posts";$proto38["m_expr"]=$obj;$proto38["m_alias"]="";$obj=new SQLFieldListItem($proto38);$proto0["m_fieldlist"][]=$obj;$proto40=array();$obj=new SQLField(array("m_strName"=>"CrimeRate","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto40["m_sql"]="CrimeRate";$proto40["m_srcTableName"]="posts";$proto40["m_expr"]=$obj;$proto40["m_alias"]="";$obj=new SQLFieldListItem($proto40);$proto0["m_fieldlist"][]=$obj;$proto42=array();$obj=new SQLField(array("m_strName"=>"CrimeRateRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto42["m_sql"]="CrimeRateRemark";$proto42["m_srcTableName"]="posts";$proto42["m_expr"]=$obj;$proto42["m_alias"]="";$obj=new SQLFieldListItem($proto42);$proto0["m_fieldlist"][]=$obj;$proto44=array();$obj=new SQLField(array("m_strName"=>"BackupProximity","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto44["m_sql"]="BackupProximity";$proto44["m_srcTableName"]="posts";$proto44["m_expr"]=$obj;$proto44["m_alias"]="";$obj=new SQLFieldListItem($proto44);$proto0["m_fieldlist"][]=$obj;$proto46=array();$obj=new SQLField(array("m_strName"=>"BackupProximityRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto46["m_sql"]="BackupProximityRemark";$proto46["m_srcTableName"]="posts";$proto46["m_expr"]=$obj;$proto46["m_alias"]="";$obj=new SQLFieldListItem($proto46);$proto0["m_fieldlist"][]=$obj;$proto48=array();$obj=new SQLField(array("m_strName"=>"LabourProximity","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto48["m_sql"]="LabourProximity";$proto48["m_srcTableName"]="posts";$proto48["m_expr"]=$obj;$proto48["m_alias"]="";$obj=new SQLFieldListItem($proto48);$proto0["m_fieldlist"][]=$obj;$proto50=array();$obj=new SQLField(array("m_strName"=>"LabourProximityRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto50["m_sql"]="LabourProximityRemark";$proto50["m_srcTableName"]="posts";$proto50["m_expr"]=$obj;$proto50["m_alias"]="";$obj=new SQLFieldListItem($proto50);$proto0["m_fieldlist"][]=$obj;$proto52=array();$obj=new SQLField(array("m_strName"=>"LivingStandard","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto52["m_sql"]="LivingStandard";$proto52["m_srcTableName"]="posts";$proto52["m_expr"]=$obj;$proto52["m_alias"]="";$obj=new SQLFieldListItem($proto52);$proto0["m_fieldlist"][]=$obj;$proto54=array();$obj=new SQLField(array("m_strName"=>"LivingStandardRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto54["m_sql"]="LivingStandardRemark";$proto54["m_srcTableName"]="posts";$proto54["m_expr"]=$obj;$proto54["m_alias"]="";$obj=new SQLFieldListItem($proto54);$proto0["m_fieldlist"][]=$obj;$proto56=array();$obj=new SQLField(array("m_strName"=>"ContentValue","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto56["m_sql"]="ContentValue";$proto56["m_srcTableName"]="posts";$proto56["m_expr"]=$obj;$proto56["m_alias"]="";$obj=new SQLFieldListItem($proto56);$proto0["m_fieldlist"][]=$obj;$proto58=array();$obj=new SQLField(array("m_strName"=>"ContentValueRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto58["m_sql"]="ContentValueRemark";$proto58["m_srcTableName"]="posts";$proto58["m_expr"]=$obj;$proto58["m_alias"]="";$obj=new SQLFieldListItem($proto58);$proto0["m_fieldlist"][]=$obj;$proto60=array();$obj=new SQLField(array("m_strName"=>"OptionalCoverage","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto60["m_sql"]="OptionalCoverage";$proto60["m_srcTableName"]="posts";$proto60["m_expr"]=$obj;$proto60["m_alias"]="";$obj=new SQLFieldListItem($proto60);$proto0["m_fieldlist"][]=$obj;$proto62=array();$obj=new SQLField(array("m_strName"=>"OptionalCoverageRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto62["m_sql"]="OptionalCoverageRemark";$proto62["m_srcTableName"]="posts";$proto62["m_expr"]=$obj;$proto62["m_alias"]="";$obj=new SQLFieldListItem($proto62);$proto0["m_fieldlist"][]=$obj;$proto64=array();$obj=new SQLField(array("m_strName"=>"VulnerabilityScore","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto64["m_sql"]="VulnerabilityScore";$proto64["m_srcTableName"]="posts";$proto64["m_expr"]=$obj;$proto64["m_alias"]="";$obj=new SQLFieldListItem($proto64);$proto0["m_fieldlist"][]=$obj;$proto66=array();$obj=new SQLField(array("m_strName"=>"OtherObservations","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto66["m_sql"]="OtherObservations";$proto66["m_srcTableName"]="posts";$proto66["m_expr"]=$obj;$proto66["m_alias"]="";$obj=new SQLFieldListItem($proto66);$proto0["m_fieldlist"][]=$obj;$proto68=array();$obj=new SQLField(array("m_strName"=>"Status","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto68["m_sql"]="Status";$proto68["m_srcTableName"]="posts";$proto68["m_expr"]=$obj;$proto68["m_alias"]="";$obj=new SQLFieldListItem($proto68);$proto0["m_fieldlist"][]=$obj;$proto70=array();$obj=new SQLField(array("m_strName"=>"AccessmentDate","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto70["m_sql"]="AccessmentDate";$proto70["m_srcTableName"]="posts";$proto70["m_expr"]=$obj;$proto70["m_alias"]="";$obj=new SQLFieldListItem($proto70);$proto0["m_fieldlist"][]=$obj;$proto72=array();$obj=new SQLField(array("m_strName"=>"ContractDate","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto72["m_sql"]="ContractDate";$proto72["m_srcTableName"]="posts";$proto72["m_expr"]=$obj;$proto72["m_alias"]="";$obj=new SQLFieldListItem($proto72);$proto0["m_fieldlist"][]=$obj;$proto74=array();$obj=new SQLField(array("m_strName"=>"Entrance_Exits","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto74["m_sql"]="Entrance_Exits";$proto74["m_srcTableName"]="posts";$proto74["m_expr"]=$obj;$proto74["m_alias"]="";$obj=new SQLFieldListItem($proto74);$proto0["m_fieldlist"][]=$obj;$proto76=array();$obj=new SQLField(array("m_strName"=>"Entrance_ExitsRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto76["m_sql"]="Entrance_ExitsRemark";$proto76["m_srcTableName"]="posts";$proto76["m_expr"]=$obj;$proto76["m_alias"]="";$obj=new SQLFieldListItem($proto76);$proto0["m_fieldlist"][]=$obj;$proto78=array();$obj=new SQLField(array("m_strName"=>"Accessibility","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto78["m_sql"]="Accessibility";$proto78["m_srcTableName"]="posts";$proto78["m_expr"]=$obj;$proto78["m_alias"]="";$obj=new SQLFieldListItem($proto78);$proto0["m_fieldlist"][]=$obj;$proto80=array();$obj=new SQLField(array("m_strName"=>"AccessibilityRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto80["m_sql"]="AccessibilityRemark";$proto80["m_srcTableName"]="posts";$proto80["m_expr"]=$obj;$proto80["m_alias"]="";$obj=new SQLFieldListItem($proto80);$proto0["m_fieldlist"][]=$obj;$proto82=array();$obj=new SQLField(array("m_strName"=>"MotionAlarm","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto82["m_sql"]="MotionAlarm";$proto82["m_srcTableName"]="posts";$proto82["m_expr"]=$obj;$proto82["m_alias"]="";$obj=new SQLFieldListItem($proto82);$proto0["m_fieldlist"][]=$obj;$proto84=array();$obj=new SQLField(array("m_strName"=>"MotionAlarmRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto84["m_sql"]="MotionAlarmRemark";$proto84["m_srcTableName"]="posts";$proto84["m_expr"]=$obj;$proto84["m_alias"]="";$obj=new SQLFieldListItem($proto84);$proto0["m_fieldlist"][]=$obj;$proto86=array();$obj=new SQLField(array("m_strName"=>"SmokeAlarm","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto86["m_sql"]="SmokeAlarm";$proto86["m_srcTableName"]="posts";$proto86["m_expr"]=$obj;$proto86["m_alias"]="";$obj=new SQLFieldListItem($proto86);$proto0["m_fieldlist"][]=$obj;$proto88=array();$obj=new SQLField(array("m_strName"=>"SmokeAlarmRemark","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto88["m_sql"]="SmokeAlarmRemark";$proto88["m_srcTableName"]="posts";$proto88["m_expr"]=$obj;$proto88["m_alias"]="";$obj=new SQLFieldListItem($proto88);$proto0["m_fieldlist"][]=$obj;$proto90=array();$obj=new SQLField(array("m_strName"=>"Photos","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto90["m_sql"]="Photos";$proto90["m_srcTableName"]="posts";$proto90["m_expr"]=$obj;$proto90["m_alias"]="";$obj=new SQLFieldListItem($proto90);$proto0["m_fieldlist"][]=$obj;$proto92=array();$obj=new SQLField(array("m_strName"=>"Contact","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto92["m_sql"]="Contact";$proto92["m_srcTableName"]="posts";$proto92["m_expr"]=$obj;$proto92["m_alias"]="";$obj=new SQLFieldListItem($proto92);$proto0["m_fieldlist"][]=$obj;$proto94=array();$obj=new SQLField(array("m_strName"=>"OtherRecommendations","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto94["m_sql"]="OtherRecommendations";$proto94["m_srcTableName"]="posts";$proto94["m_expr"]=$obj;$proto94["m_alias"]="";$obj=new SQLFieldListItem($proto94);$proto0["m_fieldlist"][]=$obj;$proto96=array();$obj=new SQLNonParsed(array("m_sql"=>"Controller"));$proto96["m_sql"]="Controller";$proto96["m_srcTableName"]="posts";$proto96["m_expr"]=$obj;$proto96["m_alias"]="";$obj=new SQLFieldListItem($proto96);$proto0["m_fieldlist"][]=$obj;$proto0["m_fromlist"]=array();$proto98=array();$proto98["m_link"]="SQLL_MAIN";$proto99=array();$proto99["m_strName"]="posts";$proto99["m_srcTableName"]="posts";$proto99["m_columns"]=array();$proto99["m_columns"][]="PostID";$proto99["m_columns"][]="Facility_Name";$proto99["m_columns"][]="Owner";$proto99["m_columns"][]="Address";$proto99["m_columns"][]="Lon";$proto99["m_columns"][]="Lat";$proto99["m_columns"][]="FacilityType";$proto99["m_columns"][]="Fence";$proto99["m_columns"][]="FenceRemark";$proto99["m_columns"][]="Lights";$proto99["m_columns"][]="LightsRemark";$proto99["m_columns"][]="FireExtinguisher";$proto99["m_columns"][]="FireExtinguisherRemark";$proto99["m_columns"][]="SecurityPost";$proto99["m_columns"][]="SecurityPostRemark";$proto99["m_columns"][]="CCTV";$proto99["m_columns"][]="CCTV_Remark";$proto99["m_columns"][]="CrimeRate";$proto99["m_columns"][]="CrimeRateRemark";$proto99["m_columns"][]="BackupProximity";$proto99["m_columns"][]="BackupProximityRemark";$proto99["m_columns"][]="LabourProximity";$proto99["m_columns"][]="LabourProximityRemark";$proto99["m_columns"][]="LivingStandard";$proto99["m_columns"][]="LivingStandardRemark";$proto99["m_columns"][]="ContentValue";$proto99["m_columns"][]="ContentValueRemark";$proto99["m_columns"][]="OptionalCoverage";$proto99["m_columns"][]="OptionalCoverageRemark";$proto99["m_columns"][]="VulnerabilityScore";$proto99["m_columns"][]="OtherObservations";$proto99["m_columns"][]="Status";$proto99["m_columns"][]="AccessmentDate";$proto99["m_columns"][]="ContractDate";$proto99["m_columns"][]="Entrance_Exits";$proto99["m_columns"][]="Entrance_ExitsRemark";$proto99["m_columns"][]="Accessibility";$proto99["m_columns"][]="AccessibilityRemark";$proto99["m_columns"][]="MotionAlarm";$proto99["m_columns"][]="MotionAlarmRemark";$proto99["m_columns"][]="SmokeAlarm";$proto99["m_columns"][]="SmokeAlarmRemark";$proto99["m_columns"][]="Photos";$proto99["m_columns"][]="Contact";$proto99["m_columns"][]="OtherRecommendations";$obj=new SQLTable($proto99);$proto98["m_table"]=$obj;$proto98["m_sql"]="posts";$proto98["m_alias"]="";$proto98["m_srcTableName"]="posts";$proto100=array();$proto100["m_sql"]="";$proto100["m_uniontype"]="SQLL_UNKNOWN";$obj=new SQLNonParsed(array("m_sql"=>""));$proto100["m_column"]=$obj;$proto100["m_contained"]=array();$proto100["m_strCase"]="";$proto100["m_havingmode"]=false;$proto100["m_inBrackets"]=false;$proto100["m_useAlias"]=false;$obj=new SQLLogicalExpr($proto100);$proto98["m_joinon"]=$obj;$obj=new SQLFromListItem($proto98);$proto0["m_fromlist"][]=$obj;$proto102=array();$proto102["m_link"]="SQLL_INNERJOIN";$proto103=array();$proto103["m_strName"]="control_zones";$proto103["m_srcTableName"]="posts";$proto103["m_columns"]=array();$proto103["m_columns"][]="ID";$proto103["m_columns"][]="Zone";$proto103["m_columns"][]="Post";$proto103["m_columns"][]="Controller";$obj=new SQLTable($proto103);$proto102["m_table"]=$obj;$proto102["m_sql"]="inner join control_zones on Facility_Name=Post";$proto102["m_alias"]="";$proto102["m_srcTableName"]="posts";$proto104=array();$proto104["m_sql"]="Facility_Name=Post";$proto104["m_uniontype"]="SQLL_UNKNOWN";$obj=new SQLField(array("m_strName"=>"Facility_Name","m_strTable"=>"posts","m_srcTableName"=>"posts"));$proto104["m_column"]=$obj;$proto104["m_contained"]=array();$proto104["m_strCase"]="=Post";$proto104["m_havingmode"]=false;$proto104["m_inBrackets"]=false;$proto104["m_useAlias"]=false;$obj=new SQLLogicalExpr($proto104);$proto102["m_joinon"]=$obj;$obj=new SQLFromListItem($proto102);$proto0["m_fromlist"][]=$obj;$proto0["m_groupby"]=array();$proto0["m_orderby"]=array();$proto0["m_srcTableName"]="posts";$obj=new SQLQuery($proto0);return $obj;}
  13. $queryData_posts=createSqlQuery_posts();;$tdataposts[".sqlquery"]=$queryData_posts;include_once(getabspath("include/posts_events.php"));$tableEvents["posts"]=new eventclass_posts;$tdataposts[".hasEvents"]=true;?>

Editor

You can edit this paste and save as new:


File Description
  • posts
  • Paste Code
  • 29 Jun-2024
  • 116.15 Kb
You can Share it: