// path to save text file
$strFolderName = date('Ymd');
$strPath = dirname(__FILE__) . '/homeflow/' . $strFolderName;
// name of textfile (date.blm)
$strTextFile = date('Ymd') . ".txt";
$strBlmFile = date('Ymd') . ".blm";
// name of zip (gzip) file
$backupdate = date("Ymd");
// backup to gzip fuinction
$backupdir = $strPath;
$files = "*";
$backupto = $strPath;
$fileprefix = "";
$tararg = "-cf";
// create folder
createForlder($strPath);
$date_comparison = date('Y-m-d H:i:s', strtotime("today -10 days"));
$sql = "SELECT\n\n\tdeal.*,\n\tarea.are_title,\n\tpro_addr1,pro_addr3,pro_postcode,\n\tpro_east,pro_north,pro_latitude,pro_longitude,\n\tbranch.bra_id,branch.bra_title,branch.bra_tel,branch.bra_fax,\n\tT.pty_title AS ptype,\n\tST.pty_title AS psubtype,\n\tGROUP_CONCAT(DISTINCT CONCAT(feature.fea_title) ORDER BY feature.fea_id ASC SEPARATOR '~') AS features,\n\tGROUP_CONCAT(DISTINCT CONCAT(photos.med_file,'|',photos.med_title) ORDER BY photos.med_order ASC SEPARATOR '~') AS photos,\n\tGROUP_CONCAT(DISTINCT CONCAT(floorplans.med_file,'|',floorplans.med_title) ORDER BY floorplans.med_order ASC SEPARATOR '~') AS floorplans,\n\tGROUP_CONCAT(DISTINCT CONCAT(epc.med_file,'|',epc.med_title) ORDER BY epc.med_order ASC SEPARATOR '~') AS epc\n\nFROM deal\n\nLEFT JOIN property ON deal.dea_prop = property.pro_id\nLEFT JOIN area ON property.pro_area = area.are_id\nLEFT JOIN branch ON deal.dea_branch = branch.bra_id\n\nLEFT JOIN ptype AS T ON deal.dea_ptype = T.pty_id\nLEFT JOIN ptype AS ST ON deal.dea_psubtype = ST.pty_id\n\nLEFT JOIN media AS photos ON deal.dea_id = photos.med_row AND photos.med_table = 'deal' AND photos.med_type = 'Photograph'\nLEFT JOIN media AS floorplans ON deal.dea_id = floorplans.med_row AND floorplans.med_table = 'deal' AND floorplans.med_type = 'Floorplan'\nLEFT JOIN media AS epc ON deal.dea_id = epc.med_row AND epc.med_table = 'deal' AND epc.med_type = 'EPC'\n\nLEFT JOIN link_instruction_to_feature ON dealId = deal.dea_id\nLEFT JOIN feature ON featureId = feature.fea_id\n\nWHERE\n(deal.dea_status = 'Available' OR deal.dea_status = 'Under Offer' OR deal.dea_status = 'Under Offer with Other')\nAND (deal.noPortalFeed <> 1 AND deal.underTheRadar <> 1)\nGROUP BY dea_id\n";
$q = $db->query($sql);
if (DB::isError($q)) {
die("error: " . $q->getMessage());
}
$numRows = $q->numRows();
// write headers
$render = "#HEADER#\nVersion : 3\nEOF : '^'\nEOR : '~'\nProperty Count : " . $numRows . "\nGenerated Date : " . $date_mysql . "\n#DEFINITION#\nAGENT_REF^ADDRESS_1^ADDRESS_2^ADDRESS_3^ADDRESS_4^TOWN^POSTCODE1^POSTCODE2^FEATURE1^FEATURE2^FEATURE3^";
$render .= "FEATURE4^FEATURE5^FEATURE6^FEATURE7^FEATURE8^FEATURE9^FEATURE10^SUMMARY^DESCRIPTION^BRANCH_ID^";
$render .= "STATUS_ID^BEDROOMS^PRICE^PRICE_QUALIFIER^PROP_SUB_ID^CREATE_DATE^UPDATE_DATE^DISPLAY_ADDRESS^";
$render .= "PUBLISHED_FLAG^LET_DATE_AVAILABLE^LET_BOND^LET_TYPE_ID^LET_FURN_ID^LET_RENT_FREQUENCY^TRANS_TYPE_ID^";
$render .= "MEDIA_IMAGE_00^MEDIA_IMAGE_TEXT_00^MEDIA_IMAGE_01^MEDIA_IMAGE_TEXT_01^MEDIA_IMAGE_02^MEDIA_IMAGE_TEXT_02^";
$render .= "MEDIA_IMAGE_03^MEDIA_IMAGE_TEXT_03^MEDIA_IMAGE_04^MEDIA_IMAGE_TEXT_04^MEDIA_IMAGE_05^MEDIA_IMAGE_TEXT_05^";
$render .= "MEDIA_IMAGE_06^MEDIA_IMAGE_TEXT_06^MEDIA_IMAGE_07^MEDIA_IMAGE_TEXT_07^MEDIA_IMAGE_08^MEDIA_IMAGE_TEXT_08^";
private function createForlder($path)
{
$path = rtrim($path, " /") . "/";
if (!file_exists($path) || !file_exists(dirname($path))) {
createForlder(dirname($path));
mkdir($path, 0777);
}
}
