//header("Content-Type: text/html; charset=UTF-8");
/*
Iroda hozzáférései
IrodaID: 6107
Iroda neve: Central Home - Honvéd utca
MYSQL host: i2.ingatlan.com
MYSQL adatbázis: interface
MYSQL tábla: interface
MYSQL user: interface6107
MYSQL pwd: wHtTjFkH5824
PID: z6107agcrUiMoFyfjNb9077
*/
include 'inc/init.php';
$in_iroda="centralhome_haris";
//$in_iroda="Central Home - Honvéd utca";
$in_irodaid="6107";
$in_pid="z6107agcrUiMoFyfjNb9077";
function ingatlanQuery( $query, $debug = false )
{
$insql_host="i2.ingatlan.com";
$insql_db="interface";
//$insql_uid="centralhome6107";
$insql_uid="interface6107";
$insql_pwd="wHtTjFkH5824";
mysql_pconnect ($insql_host, $insql_uid, $insql_pwd);
$res = mysql_db_query ($insql_db, $query);
if ($debug)
echo "
$query
" . mysql_error () . "
\n";
return $res;
}
$ujszeru=my_ff ("SELECT hu FROM dict WHERE id='102723'");
$allapot = array();
$allapot[1]='felújítandó';
$allapot[2]='felújítandó';
$allapot[3]='közepes állapotú';
$allapot[4]='jó állapotú';
$allapot[5]='felújított';
$allapot[6]= $ujszeru;
$allapot[7]= $ujszeru;
$tavfutes=my_ff ("SELECT hu FROM dict WHERE id='102724'");
$hazkozpontifutes=my_ff ("SELECT hu FROM dict WHERE id='102725'");
$futes = array();
$futes[2]='gáz (konvektor)';
$futes[3]='gáz (héra)';
$futes[4]='gáz (cirko)';
$futes[5]= $hazkozpontifutes;
$futes[6]= $tavfutes;
$futes[7]='elektromos';
$futes[8]='egyéb';
$futes[9]='fan-coll';
$lift = array();
$lift[23]='van';
$lift[24]='van';
$lift[368]='nincs';
$kilatas = array();
$kilatas[3]='utcai';
$kilatas[4]='udvari';
$kilatas[5]='kertre néző';
$kilatas[6]='panorámás';
$kilatas[7]='panorámás';
$emelet = array();
$emelet[2]='földszint';
$emelet[3]='földszint';
$emelet[4]='félemelet';
$emelet[5]='1';
$emelet[6]='2';
$emelet[7]='3';
$emelet[8]='4';
$emelet[9]='5';
$emelet[10]='6';
$emelet[11]='7';
$emelet[12]='8';
$emelet[13]='9';
$emelet[14]='10';
$emelet[15]='10 felett';
$kerulet = array();
$kerulet['3']='1';
$kerulet['4']='2';
$kerulet['5']='3';
$kerulet['6']='4';
$kerulet['7']='5';
$kerulet['8']='6';
$kerulet['9']='7';
$kerulet['10']='8';
$kerulet['11']='9';
$kerulet['12']='10';
$kerulet['13']='11';
$kerulet['14']='12';
$kerulet['15']='13';
$kerulet['16']='14';
$kerulet['17']='15';
$kerulet['18']='16';
$kerulet['19']='17';
$kerulet['20']='18';
$kerulet['21']='19';
$kerulet['22']='20';
$kerulet['23']='21';
$kerulet['24']='22';
$kerulet['25']='23';
$where = '';
if ($_POST['action'] == 'export')
{
if (! empty ($_GET['agent']) && $_GET['agent']!='0' )
$where .= (! empty ($where) ? ' and ' : '') . "user.id = '".$_POST['agent']."'";
if (! empty ($_GET['agency_id']) && $_GET['agency_id']!='0' )
$where .= (! empty ($where) ? ' and ' : '') . "agency.id = '".$_POST['agency_id']."'";
for ( $i=1; $i<=$maxdarab; $i++ ){
if (!empty ($_POST['property_id_'.$i]) )
$where .= (! empty ($where) ? ' or ' : '') . "property.id = '".$_POST['property_id_'.$i]."'";
}
if (! empty ($where))
$where = "and $where";
// else $where=' and 1 ';
}
$dateformat="Y-m-d";
$dt_1dago=mktime(
date('G'),
date('i'),
date('s'),
date('m'),
date('d')-1,
date('y'));
$dt_1dago=date($dateformat,$dt_1dago);
$sql="
SELECT property.id as id,
process_property_selling.guide_price as price,
property.flat as flat,
property.building_outside as outside,
property.building_inside as inside,
property.offical_size as size,
property_address.property_district_id as district,
concat_ws(' ', property_address.name, suffix.hu ) as address,
property.livingroom as livingroom,
property.usklivingroom as usklivingroom,
property.bedroom1 as bedroom1,
property.bedroom2 as bedroom2,
property.bedroom3 as bedroom3,
property.bedroom4 as bedroom4,
property.bedroom5 as bedroom5,
property.property_heater_id as heating,
property.property_sight_id as sight,
dict_text.hu as note_hu,
dict_text.en as note_en,
property.property_floor_id as floor,
lift.id as lift,
user.id as agent_id,
user.name as agent_name,
user.email as agent_email,
user.mobil as agent_mobil
FROM property
INNER JOIN process_property_selling
ON process_property_selling.property_id = property.id
AND process_property_selling.act = 'enabled'
INNER JOIN property_address
ON property_address.id = property.property_address_id
INNER JOIN dict suffix
ON suffix.id=( SELECT name FROM property_address_suffix WHERE property_address_suffix.id=property_address.property_address_suffix_id )
INNER JOIN dict lift
ON lift.id=( SELECT name FROM property_lift WHERE property_lift.id=property.property_lift_id )
INNER JOIN user
ON process_property_selling.agent_user_id=user.id
LEFT JOIN dict_text
ON dict_text.id=property.note
WHERE property.act = 'enabled'
$where
GROUP BY property.id
ORDER BY district
";
//echo $sql;
$res=my_query($sql, false);
// -----------------------------------------------------------------------------------------------------
while ( $data = my_fetch_array($res) )
{
$szobak=0;
$felszobak=0;
$tipus='livingroom';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='usklivingroom';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom1';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom2';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom3';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom4';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom5';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom6';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom7';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom8';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom9';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$tipus='bedroom10';if ( $data[$tipus] > 0 && $data[$tipus] < 12 ) $felszobak++; elseif ( $data[$tipus] >= 12 ) $szobak++; // <
$iof_allapot=round (( $data[flat] + $data[outside] + $data[inside] ) / 3, 0 );
//$iof_allapot = $data[flat];
// -----------------------------------------------------------------------------------------------------
$sql_pic = "
SELECT property_picture.id as id,
dict.hu as desciption,
plan
FROM property_picture
INNER JOIN dict
ON property_picture.name=dict.id
WHERE property_picture.property_id='$data[id]' AND
property_picture.crypt='no' AND
property_picture.pos < '6'
ORDER BY property_picture.plan desc, property_picture.pos asc
LIMIT 0,5
";
$res_pic=my_query($sql_pic, false);
$cx=0;
$kep=array();
while ( $row = my_fetch_array($res_pic))
{
$kep[$cx]='http://admin.centralhome.hu/i/property/' . $row[id] . '.jpg';
//ha a sorra kerulo kep alaprajz, akkor legyartjuk hozza a vizjeles kepet
if($row[plan]=="yes"){
//itt kerul ra a vizjel
$src="/data/www/friendlyway/centralhome.hu/httpdocs/admin/i/property/". $row[id] . '.jpg';
$watermark = imagecreatefromgif('watermark.gif');
$watermark_width = imagesx($watermark);
$watermark_height = imagesy($watermark);
imagealphablending( $watermark, true );
$image = imagecreatetruecolor($watermark_width, $watermark_height);
$image = imagecreatefromjpeg($src);
$image_width = imagesx($image);
$image_height = imagesy($image);
$dest_x = ( $image_width - $watermark_width ) / 2;
$dest_y = ( $image_height - $watermark_height ) / 2;
imagecopymerge($image, $watermark, $dest_x, $dest_y, 0, 0, $watermark_width, $watermark_height, 20);
imagejpeg($image, "temp/temp.jpg", 100);
imagedestroy($image);
imagedestroy($watermark);
$kep[$cx]='http://admin.centralhome.hu/temp/temp.jpg';
//a feltoltendo kepet most kivetelesen a temp konyvtarbol huzza be
}
$cx++;
}
mysql_free_result($res_pic);
// -----------------------------------------------------------------------------------------------------
$kerulet_val=$kerulet[$data[district]];
$emelet_val=$emelet[$data[floor]];
$futes_val=$futes[$data[heating]];
$kilatas_val=$kilatas[$data[sight]];
$allapot_val=$allapot[$iof_allapot];
$lift_val=$lift[$data[lift]];
$data[note_hu]=htmlspecialchars($data[note_hu], ENT_QUOTES );
$data[note_en]=htmlspecialchars($data[note_en], ENT_QUOTES );
$altipus=my_ff ("SELECT hu FROM dict WHERE id='102690'");
$user = "
SELECT id,
email,
mobil
FROM user
WHERE id = '$_SESSION[user_id]'
";
$res_user=my_query($user, false);
$row_user = my_fetch_array($res_user);
$sql=" INSERT INTO interface
( `sajatid`,
`ugynok_id`,
`pid`,
`status`,
`mod`,
`tipus`,
`altipus`,
`ar`,
`armertekegyseg`,
`lakter`,
`orszag`,
`megye`,
`telepules`,
`utca`,
`kerulet`,
`szobak`,
`szobakfel`,
`emelet`,
`futes`,
`megjegyzes`,
`megjegyzes_angol`,
`lift`,
`kilatas`,
`kep`,
`kep2`,
`kep3`,
`kep4`,
`kep5`,
`allapot`,
`email`,
`telefon`
)
VALUES
(
'$data[id]',
'$_SESSION[user_id]',
'$in_pid',
'0',
'1',
'lakás',
'$altipus',
'$data[price]',
'HUF',
'$data[size]',
'Magyarország',
'Budapest',
'Budapest',
'$data[address]',
'$kerulet_val',
'$szobak',
'$felszobak',
'$emelet_val',
'$futes_val',
'$data[note_hu]',
'$data[note_en]',
'$lift_val',
'$kilatas_val',
'$kep[0]',
'$kep[1]',
'$kep[2]',
'$kep[3]',
'$kep[4]',
'$allapot_val',
'$row_user[email]',
'$row_user[mobil]'
)";
ingatlanQuery($sql, false);
// print $sql . '
';
// ennek mennie kell
$sajatid = $data[id];
$url='http://ingatlan.com/interface/interface_b105.php?sajatid='.$sajatid.'&pid='.$in_pid;
$lines = file($url);
foreach( $lines as $num => $line )
{
print $line . '
';
}
/*
foreach ( $data as $num => $line )
{
print $num . '# ' . $line . '
';
}
*/
print '
' . $sql . '
';
//header ('Location:http://ingatlan.com/interface/interface_b105.php?sajatid='.$sajatid.'&pid='.$in_pid.'');
//print '
' . $sql . '
';
//print $iof_allapot . '
';
//print $url . '
';
//die();
//print $url . '
';
}
mysql_free_result($res);
//header('Location:index.php?page=asd');
?>