$rets->useragent_password = '******';
$current_GMT_time = get_GMT(time());
$current_GMT_time_string = date("Y-m-d H:i:s", $current_GMT_time);
$current_YVR_time = getTimeByCity($current_GMT_time, 'YVR');
$current_YVR_time_string = date("Y-m-d H:i:s", $current_YVR_time);
//The following code is to test if the cron job is executed.
$file = "file.txt";
$current = file_get_contents($file);
$current .= "{$current_YVR_time_string}\n";
file_put_contents($file, $current);
//login and receive server response.
$response = $rets->Login();
var_dump($response);
//$response=$rets->GetCount('Property','11','(363=|A)');
//print $response.'<br/>';
$sysid_array = $rets->GetDataArray('Property', '11', '(363=|A)', 'sysid', null);
//echo count($sysid_array).'<br/>';
foreach ($sysid_array as $index => $array) {
//echo '<br/>['.$index.']'.$array['sysid'].'<br/>';
insert_sysid($array['sysid']);
}
$selectSQL = "SELECT sysid FROM sysid_raw WHERE imported='N' AND problem='N' LIMIT 0, 50";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
while ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
$new_sysid = $row_get_sysid['sysid'];
$listing_array = $rets->GetDataArray('Property', '11', '(sysid=' . $new_sysid . ')', null, null);
if (insert_update_listing($listing_array[0])) {
if (update_sysid_in_raw($new_sysid)) {
echo "<br/><span style=\"color:#336633;\">[info] sysid updated in sysid_raw database. {$new_sysid} imported='Y'.</span><br/>";
}
} else {
require_once 'utilities/utilities.php';
require_once 'RETS.php';
if (mysql_select_db("home365_ios", $useradmin)) {
} else {
echo "Error selecting database, exited.";
exit;
}
$rets = new RETS();
$rets->url = 'http://brc.rebretstest.interealty.com/Login.asmx/Login';
$rets->user = '******';
$rets->password = '******';
$rets->useragent = 'RETSAllisonJiang/1.0';
$rets->useragent_password = '******';
$response = $rets->Login();
var_dump($response);
$listings_array = $rets->GetDataArray('Property', '11', '(363=|A)', null, null);
foreach ($listings_array as $key => $value) {
$selectSQL = "SELECT * FROM listings WHERE sysid=" . $value['sysid'];
$get_listing = mysql_query_or_die($selectSQL, $useradmin);
if ($row_get_listing = mysql_fetch_assoc($get_listing)) {
echo "Record found in database\n";
$updateSQL = sprintf("UPDATE listings SET property_type=%s, address=%s, postal_code=%s, unit_number=%s, city=%s, province=%s, built_year=%s, house_number=%s, list_price=%s, list_date=%s, mls_number=%s, bedrooms=%s, bathrooms=%s, public_remarks=%s, public_remarks_2=%s, lot_size_sqt=%s, lot_size_sqm=%s, floor_area_total=%s, site_influences=%s, type_of_dwelling=%s,publish_on_internet=%s, status=%s WHERE sysid=" . $value['sysid'], GetSQLValueString($value['1'], "text"), GetSQLValueString($value['14'], "text"), GetSQLValueString($value['11'], "text"), GetSQLValueString($value['2971'], "int"), GetSQLValueString($value['3794'], "text"), GetSQLValueString($value['88'], "text"), GetSQLValueString($value['16'], "int"), GetSQLValueString($value['181'], "int"), GetSQLValueString($value['226'], "double"), GetSQLValueString($value['224'], "date"), GetSQLValueString($value['248'], "text"), GetSQLValueString($value['378'], "int"), GetSQLValueString($value['3928'], "int"), GetSQLValueString($value['411'], "text"), GetSQLValueString($value['3985'], "text"), GetSQLValueString($value['2457'], "double"), GetSQLValueString($value['2460'], "double"), GetSQLValueString($value['3922'], "double"), GetSQLValueString($value['3926'], "text"), GetSQLValueString($value['2733'], "text"), GetSQLValueString($value['3'] == 'Yes' ? 'Y' : 'N', "text"), GetSQLValueString($value['363'] == 'Active' ? 'A' : 'D', "text"), GetSQLValueString($value['sysid'], "int"));
$result = mysql_query_or_die($updateSQL, $useradmin);
$album_id = get_album_id($value['sysid']);
if (!$album_id) {
$album_id = create_album($value['sysid']);
}
} else {
$response = $rets->GetPhoto('Property', $value['sysid'] . ':*', 'images');
$photo_array = $response['photo_array'];
$address = $value['14'] . ' ' . $value['3794'] . ' ' . $value['88'];
exit;
}
$rets = new RETS();
$rets->url = 'http://brc.retsca.interealty.com/Login.asmx/Login';
$rets->user = '******';
$rets->password = '******';
$rets->useragent = 'RETSAllisonJiang/1.0';
$rets->useragent_password = '******';
$current_GMT_time = get_GMT(time());
$current_GMT_time_string = date("Y-m-d H:i:s", $current_GMT_time);
$current_YVR_time = getTimeByCity($current_GMT_time, 'YVR');
$current_YVR_time_string = date("Y-m-d H:i:s", $current_YVR_time);
$current_YVR_date = date("Y-m-d", $current_YVR_time);
$mls = $_POST['mls'];
$response = $rets->Login();
$response = $rets->GetDataArray('Property', '11', '(248=' . $mls . ')', 'sysid,248,363,217', 2);
$temp_sysid = $response[0]['sysid'];
$selectSQL = "SELECT * FROM listings WHERE sysid={$temp_sysid}";
$get_listing = mysql_query_or_die($selectSQL, $useradmin);
if ($listing_detail = mysql_fetch_assoc($get_listing)) {
//print_r($listing_detail);
if ($listing_detail['num_of_photos'] <= 1) {
echo "<br/><span style=\"color:red\">该房产在数据库没有图片（或只有一张图片）</span><br/>";
} else {
echo "<br/><span style=\"color:green;\">该房产共有" . $listing_detail['num_of_photos'] . "张照片</span><br/>";
}
$album_id = check_and_insert($listing_detail['sysid']);
$response = $rets->GetPhoto('Property', $listing_detail['sysid'] . ':*', 'images');
$photo_array = $response['photo_array'];
$photo_id_array = get_photo_id($listing_detail['sysid']);
if (count($photo_array) > count($photo_id_array)) {
//print $response;
//print "\n\n";
# get data in an array where: Resource=Property,
# Class=11 (XPROP),
# Query=Status (field 363) is Active,
# Select Fields=sysid,248,363,217 (sysid, MLS#, Status, LastTransDate)
# Num Records=Limit to 2
//$response=$rets->GetDataArray('Property','11','(363=|A)','sysid,248,363,217',2);
//var_dump($response);
//print "\n\n";
#get record where LastTransDate(fild 217) is on May 14, 2014
//$response=$rets->GetDataArray('Property','11','(363=|A),(217=2014-05-14T00:00:00-2014-05-14T23:59:59)',null,null);
//var_dump($response);
//$response=$rets->GetDataArray('Property','11','(363=|A)',null,1);
//var_dump($response);
$response = $rets->GetDataArray('Property', '11', '(248=V1037517)', null, null);
var_dump($response);
foreach ($response as $key => $value) {
foreach ($value as $field => $row_value) {
echo "[{$field}]" . get_column_name($field) . ":{$row_value}\n";
}
}
print "\n\n";
# get data using full key download
# and write to file where: Resource=Property,
# Class=11 (XPROP),
# Query=Status (field 363) is Active,
# Select Fields=All,
# Num Records=Unlimited
//$rets->CreateDataFile('Property','11','(363=|A)',null,null,"data/active_listings.txt");
//print "\n\n";
$rets->password = '******';
$rets->useragent = 'RETSAllisonJiang/1.0';
$rets->useragent_password = '******';
$current_GMT_time = get_GMT(time());
$current_GMT_time_string = date("Y-m-d H:i:s", $current_GMT_time);
$current_YVR_time = getTimeByCity($current_GMT_time, 'YVR');
$current_YVR_time_string = date("Y-m-d H:i:s", $current_YVR_time);
//login and receive server response.
$response = $rets->Login();
var_dump($response);
//The following code is to test if the cron job is executed.
$file = "file.txt";
$current = file_get_contents($file);
$current .= "{$current_YVR_time_string} from sysid_test.php\n";
file_put_contents($file, $current);
$sysid_array = $rets->GetDataArray('Property', '11', '(363=|A)', 'sysid', null);
//var_dump($sysid_array);
$truncateSQL = "TRUNCATE TABLE sysid_raw_current";
$result = mysql_query_or_die($truncateSQL, $useradmin);
foreach ($sysid_array as $index => $array) {
insert_sysid($array['sysid']);
}
function insert_sysid($sysid)
{
global $useradmin;
$selectSQL = "SELECT * FROM sysid_raw_current WHERE sysid={$sysid}";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
if ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
} else {
$insertSQL = sprintf("INSERT INTO sysid_raw_current (sysid) VALUES(%s)", GetSQLValueString($sysid, "int"));
$result = mysql_query_or_die($insertSQL, $useradmin);
