/* hun : ingatlanok listázása */
session_start;
include ('inc/init.php');
include ('milla.php');
var_postget ('cue');
$res = my_query("SELECT eur FROM rates") or die(mysql_error());
$row = my_fetch_array($res);
$valuta = $row[eur];
$querystring_side='';
foreach ($_GET as $key => $value)
{
if ($key != 'cue' && $key!='limitfrom' && $key!='property_id')
{
$querystring_side .= "&" . "$key=$value";
}
}
## navigalas kezdoertekei
if (! $limitfrom)
$limitfrom = 0;
if ($cue == 'forward')
$limitfrom += 50;
if ($cue == 'back')
if ($limitfrom - 50 >= 0)
$limitfrom -= 50;
if ( $_GET[cue]=='qselection' )
{
if ( my_ff("SELECT quality_selection FROM property_kiado WHERE id='$_GET[property_id]'")=='1' ) my_query("UPDATE property_kiado SET quality_selection='0' WHERE id='$_GET[property_id]'");
else my_query("UPDATE property_kiado SET quality_selection='1' WHERE id='$_GET[property_id]'");
}
if ( $_GET[cue]=='special' )
{
if ( my_ff("SELECT specialoffer FROM property_kiado WHERE id='$_GET[property_id]'")=='1' ) my_query("UPDATE property_kiado SET specialoffer='0' WHERE id='$_GET[property_id]'");
else my_query("UPDATE property_kiado SET specialoffer='1' WHERE id='$_GET[property_id]'");
}
$u_id=$_SESSION['user_id'];
$_user_post_id = my_ff ("select user_post_id from user where id = '$_SESSION[user_id]'");
if( $_user_post_id==11 or $_user_post_id==22 )
{ $u_exec=true; }
/* primelocation signing - begin */
if($u_exec)
{
// peti primelocationja
/*
foreach ($_POST as $key => $value)
{
if($key=='primeloc' && $_POST['primelocsign'])
{
foreach ($value as $subkey => $subvalue)
{
if($subvalue=='on')
{
$sql="update property set primeloc=1 where id=$subkey";
my_query($sql);
//echo mysql_error();
//echo "--Kulcs: $subkey, Érték: $subvalue
\n";
}
}
}
if($key=='primelocdel' && $_POST['primelocsign'])
{
foreach ($value as $subkey => $subvalue)
{
if($subvalue=='on')
{
$sql="update property set primeloc=0 where id=$subkey";
my_query($sql);
//echo mysql_error();
//echo "--Kulcs: $subkey, Érték: $subvalue
\n";
}
}
}
}
*/
if ($_POST['primelocsign'] == 'yes')
{
$del_prime = $set_prime = $unset_prime = array (); // a del torli koypontilag, a masik 2 csak a helzi adatbayis miatt kell
$res = my_query ("select id, primeloc from property_kiado");
while ($row = mysql_fetch_array ($res))
{
if ($_POST['primeloc_' . $row['id']] != '1' && $row['primeloc'] == '1')
array_push ($del_prime, $row['id']);
if ($_POST['primeloc_' . $row['id']] == '1')
array_push ($set_prime, $row['id']);
else
array_push ($unset_prime, $row['id']);
}
mysql_free_result ($res);
$temp = '';
for ($i = 0; $i < count ($set_prime); $i++)
{
if ($i > 0)
$temp .= ' or ';
$temp .= " id = '{$set_prime[$i]}' ";
}
my_query ("update property_kiado set primeloc = '1' where $temp");
$temp = '';
for ($i = 0; $i < count ($unset_prime); $i++)
{
if ($i > 0)
$temp .= ' or ';
$temp .= " id = '{$unset_prime[$i]}' ";
}
my_query ("update property_kiado set primeloc = '0' where $temp");
$temp = '';
for ($i = 0; $i < count ($del_prime); $i++)
$temp .= $del_prime[$i] . '+';
$temp = substr ($temp, 0, strlen ($temp) - 1);
echo '';
}
}
/* primelocation signing - end */
if ($_GET['cue'] == 'where' )
{
$_SESSION['ing_query'] = $_SERVER['QUERY_STRING'];
}
if ($_GET['cue'] == 'del' && is_user_boss ())
{
my_query ("update property_kiado set act = 'disabled' where id = '$_GET[id]'");
}
if($_user_post_id==22 )
{ $f_mark=true; }
/********** folyamat *************
orderfield olvasása sessionből
ha az uj rendezesi mezo = legutobb valasztott rendezesi mezo,
akkor forduljon a sorrend (orderdesc)
egyebkent
orderfield[0]=orderfield[1];
orderfield[1]=neworderfield;
orderfield mentése sessionbe
************************************/
// ps is a namespace for this part of code
if($_GET['property_sight_id'])
{
$ps_res=my_query (" select id, name from property_sight order by pos");
$i=0;
$ps_pos=0;
while($ps_row = mysql_fetch_array ($ps_res))
{
$ps_rows[$i]=$ps_row;
//echo "{$ps_row['id']}
";
if($ps_row['id']==$_GET['property_sight_id'])
{
$ps_pos=$i;
}
$i=$i+1;
}
switch ($ps_pos)
{
case 0:
$ps_where = " property_sight_id=" . $ps_rows[$ps_pos]['id'];
break;
case 1:
$ps_where = " property_sight_id=" . $ps_rows[$ps_pos]['id'];
break;
case 2:
$ps_where = " property_sight_id=" . $ps_rows[$ps_pos]['id'];
break;
case 3:
$ps_where = " property_sight_id=" . $ps_rows[$ps_pos]['id'];
break;
case 4:
$ps_where = " property_sight_id=" . $ps_rows[$ps_pos]['id'];
break;
}
}
if($ps_where){ $ps_where = " and (" .$ps_where . ")";}
// echo "propery_sight test: {$_GET['property_sight_id']} $ps_pos xxx $ps_where";
/* *** sight absolute positions/orders:
udvar 0
z.udvar 1
utcai 2
panorama 3
duna panorama 4
*/
if($_GET['property_heater_id'])
{
$ph_res=my_query (" select id, name from property_heater order by pos");
$i=0;
$ph_pos=0;
while($ph_row = mysql_fetch_array ($ph_res))
{
$ph_rows[$i]=$ph_row;
//echo "{$ph_row['id']}
";
if($ph_row['id']==$_GET['property_heater_id'])
{
$ph_pos=$i;
}
$i=$i+1;
}
switch ($ph_pos)
{
case 0:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 1:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'] ;
break;
case 2:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 3:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 4:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 5:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 6:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
case 7:
$ph_where = " property_heater_id=" . $ph_rows[$ph_pos]['id'];
break;
}
}
if($ph_where){ $ph_where = " and (" .$ph_where . ")";}
if($_GET['property_flattype'])
{
$pf_res=my_query (" select id, name from property_flattype order by pos");
$i=0;
$pf_pos=0;
while($pf_row = mysql_fetch_array ($pf_res))
{
$pf_rows[$i]=$pf_row;
//echo "{$ps_row['id']}
";
if($pf_row['id']==$_GET['property_flattype'])
{
$pf_pos=$i;
}
$i=$i+1;
}
switch ($pf_pos)
{
case 0:
$pf_where = " property_flattype=" . $pf_rows[$pf_pos]['id'];
break;
case 1:
$pf_where = " property_flattype=" . $pf_rows[$pf_pos]['id'];
break;
case 2:
$pf_where = " property_flattype=" . $pf_rows[$pf_pos]['id'];
break;
case 3:
$pf_where = " property_flattype=" . $pf_rows[$pf_pos]['id'];
break;
}
}
if($pf_where){ $pf_where = " and (" .$pf_where . ")";}
// read array from session
// if there is session defined
if (isset($_SESSION['prop_orderfield']))
{$orderfield=$_SESSION['prop_orderfield'];}
//printf( "%s", $_GET['orderfield']);
if (isset ($_GET['orderfield'])) {
if(empty($orderfield[1]))
{
$orderfield[1]=$_GET['orderfield'];
}
if($orderfield[1]!=$_GET['orderfield'])
{
$orderfield[0]=$orderfield[1];
$orderfield[1] = $_GET['orderfield'];
$orderdesc = $_GET['orderdesc'] ? true : false;
}
} else {
$orderfield[1] = 'district_id';
$orderfield[0] = 'address';
$orderdesc = false;
}
/** create $orders string **/
$orders='';
if (isset($orderfield[0]))
{
$orders=$orderfield[0];
}
if (isset($orderfield[1]))
{
if($orderfield[1]!=$orderfield[0] && !empty($orderfield[1]) )
{
$orders= $orderfield[1] . ", " . $orders ;
}
}
if ($orderdesc)
{
$orders=$orders . " desc " ;
}
$_SESSION['prop_orderfield']=$orderfield;
//echo "$orders ....
";
//echo "$orderdesc ....
";
//printf(" %s és %s", $orderfield[0],$orderfield[1]);
$get_orders = '';
if (! empty ($_GET['ID']))
$get_orders .= "&ID=$_GET[ID]";
if (! empty ($_GET['phone']))
$get_orders .= "&phone=$_GET[phone]";
if (! empty ($_GET['mobil']))
$get_orders .= "&mobil=$_GET[mobil]";
if (! empty ($_GET['uzlethelyiseg']))
$get_orders .= "&uzlethelyiseg=$_GET[uzlethelyiseg]";
if (! empty ($_GET['price1_kiado']))
$get_orders .= "&price1=$_GET[price1_kiado]";
if (! empty ($_GET['price2_kiado']))
$get_orders .= "&price2=$_GET[price2_kiado]";
if (! empty ($_GET['m2price']))
$get_orders .= "&m2price=$_GET[m2price]";
if (! empty ($_GET['m1']))
$get_orders .= "&m1=$_GET[m1]";
if (! empty ($_GET['m2']))
$get_orders .= "&m2=$_GET[m2]";
if (! empty ($_GET['roomfull_min']))
$get_orders .= "&roomfull_min=$_GET[roomfull_min]";
if (! empty ($_GET['roomfull_max']))
$get_orders .= "&roomfull_max=$_GET[roomfull_max]";
$dist_str = var_chkbox ('district', 'property_district');
$dist_arr = ! empty ($dist_str) ? explode (',', $dist_str) : array ();
if (! empty ($dist_arr))
{
for ($i = 0; $i < count ($dist_arr); $i++)
{
$get_orders .= "&district_{$dist_arr[$i]}=on";
}
}
$masstrans_str = var_chkbox ('masstrans', 'property_transport');
$masstrans_arr = ! empty ($masstrans_str) ? explode (',', $masstrans_str) : array ();
if (! empty ($masstrans_arr))
{
for ($i = 0; $i < count ($masstrans_arr); $i++)
{
$get_orders .= "&masstrans_{$masstrans_arr[$i]}=on";
}
}
if ($_GET['address_name'] > -1)
$get_orders .= "&address_name=$_GET[address_name]";
if ($_GET['flat1'] > -1)
$get_orders .= "&flat1=$_GET[flat1]";
if ($_GET['flat2'] > -1)
$get_orders .= "&flat2=$_GET[flat2]";
if ($_GET['outside1'] > -1)
$get_orders .= "&outside1=$_GET[outside1]";
if ($_GET['outside2'] > -1)
$get_orders .= "&outside2=$_GET[outside2]";
if ($_GET['inside1'] > -1)
$get_orders .= "&inside1=$_GET[inside1]";
if ($_GET['inside2'] > -1)
$get_orders .= "&inside2=$_GET[inside2]";
if ($_GET['floor_id'])
$get_orders .= "&floor_id=$_GET[floor_id]";
if ($_GET['max_floor_lift'])
$get_orders .= "&max_floor_lift=$_GET[max_floor_lift]";
if ($_GET['panorama'])
$get_orders .= "&panorama=$_GET[panorama]";
if ($_GET['balcony'])
$get_orders .= "&balcony=$_GET[balcony]";
if ($_GET['terrace'])
$get_orders .= "&terrace=$_GET[terrace]";
if ($_GET['property_sight_id'])
$get_orders .= "&property_sight_id=$_GET[property_sight_id]";
if ($_GET['property_heater_id'])
$get_orders .= "&property_heater_id=$_GET[property_heater_id]";
if ($_GET['property_flattype'])
$get_orders .= "&property_flattype=$_GET[property_flattype]";
if ($_GET['primelock'])
$get_orders .= "&primelock=$_GET[primelock]";
if ($_GET['joelosztas'])
$get_orders .= "&joelosztas=$_GET[joelosztas]";
if ($_GET['sdate1'])
$get_orders .= "&sdate1=$_GET[sdate1]";
if ($_GET['sdate2'])
$get_orders .= "&sdate2=$_GET[sdate2]";
if ($_GET['edate1'])
$get_orders .= "&edate1=$_GET[edate1]";
if ($_GET['edate2'])
$get_orders .= "&edate2=$_GET[edate2]";
if ($_GET['agent'])
$get_orders .= "&agent=$_GET[agent]";
if ($_GET['agency_id'])
$get_orders .= "&agency_id=$_GET[agency_id]";
//echo 'property_sight_id: '.$_GET[property_sight_id];
#
?>