$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'];
get_geocode($address, $value['sysid']);
echo "Creating new record\n";
$insertSQL = sprintf("INSERT INTO listings (sysid, property_type, address, postal_code, unit_number, city, province, built_year, house_number, list_price, list_date, mls_number, bedrooms, bathrooms, public_remarks, public_remarks_2, lot_size_sqt, lot_size_sqm, floor_area_total, site_influences, type_of_dwelling,publish_on_internet,status) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", GetSQLValueString($value['sysid'], "int"), 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"));
$result = mysql_query_or_die($insertSQL, $useradmin);
$album_id = create_album($value['sysid']);
for ($i = 0; $i < count($photo_array); $i++) {
$insertPhotoSQL = sprintf("INSERT INTO photo_profile(photo_path)VALUES(%s)", GetSQLValueString($photo_array[$i], "text"));
$result = mysql_query_or_die($insertPhotoSQL, $useradmin);
$photo_id = mysql_insert_id($useradmin);
$insertAlbumSQL = sprintf("INSERT INTO album_profile(album_id, photo_id, cover)VALUES(%s,%s,%s)", GetSQLValueString($album_id, "int"), GetSQLValueString($photo_id, "int"), GetSQLValueString($i == 0 ? 'Y' : 'N', "text"));
$result = mysql_query_or_die($insertAlbumSQL, $useradmin);
}
//insert record to listing_realtors
$current_YVR_time_string = date("Y-m-d H:i:s", $current_YVR_time);
$before1hr_time_string = date("Y-m-d H:i:s", $current_YVR_time - 3600);
$selectSQL = "SELECT SQL_CALC_FOUND_ROWS DISTINCT sysid FROM listings WHERE (ISNULL(listings.album_id) OR num_of_photos<=1) AND status='A' AND property_type!='Land Only' ORDER BY RAND() LIMIT 0, 10";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
$row = mysql_fetch_row(mysql_query("SELECT FOUND_ROWS()", $useradmin));
//login and receive server response.
if (is_array($row) && $row[0] > 0) {
echo '<br/>' . $row[0] . 'records needs to be album_patched.<br/>';
$response = $rets->Login();
while ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
echo '<br/><br/>checking:<span style="color:#00ff00;">' . $row_get_sysid['sysid'] . '</span><br/>';
$album_id = check_and_insert($row_get_sysid['sysid']);
if (!empty($album_id)) {
$photo_id_array = get_photo_id($row_get_sysid['sysid']);
var_dump($photo_id_array);
$response = $rets->GetPhoto('Property', $row_get_sysid['sysid'] . ':*', 'images');
$photo_array = $response['photo_array'];
if (count($photo_array) > count($photo_id_array)) {
for ($i = 0; $i < count($photo_array); $i++) {
$selectSQL = "SELECT * FROM photo_profile WHERE photo_path='" . $photo_array[$i] . "'";
if ($photo_item = mysql_fetch_assoc(mysql_query_or_die($selectSQL, $useradmin))) {
echo "<br/>photo_path found in database, nothing to be inserted.<br/>";
} else {
echo "<br/>photo_path not found in database, inserting new record<br/>";
$insertPhotoSQL = sprintf("INSERT INTO photo_profile(photo_path)VALUES(%s)", GetSQLValueString($photo_array[$i], "text"));
$result = mysql_query_or_die($insertPhotoSQL, $useradmin);
$photo_id = mysql_insert_id($useradmin);
$insertAlbumSQL = sprintf("INSERT INTO album_profile(album_id, photo_id, cover)VALUES(%s,%s,%s)", GetSQLValueString($album_id, "int"), GetSQLValueString($photo_id, "int"), GetSQLValueString($i == 0 ? 'Y' : 'N', "text"));
$result = mysql_query_or_die($insertAlbumSQL, $useradmin);
}
unset($selectSQL);
if (empty($num_of_photos)) {
$empty++;
$deleteSQL = sprintf("DELETE FROM sysid_raw_recent_image_update WHERE sysid=%s", GetSQLValueString($temp_sysid, "int"));
$result = mysql_query_or_die($deleteSQL, $useradmin);
echo '<br/><span style="color:#ff0000;">' . $temp_sysid . ' is removed from the database because remote data does\'t have num of photos data.</span><br/>';
} else {
$photo_id_array = get_photo_id($temp_sysid);
if (count($photo_id_array) > 0) {
if (count($photo_id_array) < $num_of_photos) {
//var_dump($photo_id_array);
//echo "<br/>";
$i++;
echo $temp_sysid . ":" . $num_of_photos . "<br/>";
$album_id = check_and_insert($temp_sysid);
if (!empty($album_id)) {
$response = $rets->GetPhoto('Property', $temp_sysid . ':*', 'images');
$photo_array = $response['photo_array'];
//var_dump($photo_array);
if (is_array($photo_array) && count($photo_array) >= $num_of_photos) {
echo "<br/>Number of photos retrieved matches the database record.<br/>";
for ($i = 0; $i < count($photo_array); $i++) {
$selectSQL = "SELECT * FROM photo_profile WHERE photo_path='" . $photo_array[$i] . "'";
//echo $selectSQL."<br/>";
if ($photo_item = mysql_fetch_assoc(mysql_query_or_die($selectSQL, $useradmin))) {
echo "<br/>photo_path found in database, nothing to be inserted.<br/>";
} else {
$selectSQL = "SELECT photo_profile.photo_id FROM listings LEFT JOIN album_profile ON listings.album_id = album_profile.album_id" . " LEFT JOIN photo_profile ON album_profile.photo_id = photo_profile.photo_id" . " WHERE photo_path='http://80a5e3a6041af90156b0-bf53eb49f254872ee431fd1273bc084d.r45.cf2.rackcdn.com/_.jpg'" . " AND listings.album_id={$album_id}";
$get_photo = mysql_query_or_die($selectSQL, $useradmin);
if ($row_get_photo = mysql_fetch_assoc($get_photo)) {
echo "<br/>Broken image found. Updating record.<br/>";
$photo_id = $row_get_photo['photo_id'];
$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)) {
echo "<br/>We got more photos from the remote server<br/>";
for ($i = 0; $i < count($photo_array); $i++) {
$selectSQL = "SELECT * FROM photo_profile WHERE photo_path='" . $photo_array[$i] . "'";
if ($photo_item = mysql_fetch_assoc(mysql_query_or_die($selectSQL, $useradmin))) {
echo "<br/>photo_path found in database, nothing to be inserted.<br/>";
} else {
$selectSQL = "SELECT photo_profile.photo_id FROM listings LEFT JOIN album_profile ON listings.album_id = album_profile.album_id" . " LEFT JOIN photo_profile ON album_profile.photo_id = photo_profile.photo_id" . " WHERE photo_path='http://80a5e3a6041af90156b0-bf53eb49f254872ee431fd1273bc084d.r45.cf2.rackcdn.com/_.jpg'" . " AND listings.album_id={$album_id}";
$get_photo = mysql_query_or_die($selectSQL, $useradmin);
if ($row_get_photo = mysql_fetch_assoc($get_photo)) {
echo "<br/>Broken image found. Updating record.<br/>";
$photo_id = $row_get_photo['photo_id'];
$photo_path = $photo_array[$i];
