DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA']=$_REQUEST['JAVA_VALUE'];
}
}
if(!isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA'])) $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA']='';
$where=" where t1.S_ADDRESS_STREET like '%".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA'])."%'
";
// if(!empty($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])) $where.=" and ( sua.ID_BILLING_USERS like '%".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])."%'
// or sut.ID_BILLING_USERS like '%".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])."%' )
// ";
$sql = "select t1.`S_ADDRESS_STREET` as `key`, concat_ws(' ','ID rekordu :',t1.ID,'; REWIR:',t1.M_REWIR,'; Status Budynku:',t2.A_STATUS,'; ULICA:',t2.`P_ADDRESS_STREET`
) as description from `USERS2_MARKETING` as t1
left join BUILDINGS as t2 on t1.`T_TELBOX_BUILDING_IN`=t2.`S_ADDRESS_STREET`";
//if(!empty($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS']))
// $sql.="
// left join SES_USERS2_A as sua on ( sua.`S_ADDRESS_STREET`=t1.`S_ADDRESS_STREET` and sua.ID_BILLING_USERS='".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])."' )
// left join SES_TV_A as sut on ( sut.`S_ADDRESS_STREET`=t1.`S_ADDRESS_STREET` and sut.ID_BILLING_USERS='".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])."' )";
$sql.=" ".$where." limit 25 ";
ZAP_SQL( $sql );
$i=0;
SEF('REMOVE_LOCALES_OGONKI');
while ($r = mysql_fetch_object( $result )) {
$rows[$i]->key=$r->key;
$rows[$i]->description=addslashes(iconv("UTF-8", "ISO-8859-1//TRANSLIT", REMOVE_LOCALES_OGONKI($r->description)));
$i++;
}
if(empty($rows)) {
$rows[0]->key='';
$rows[0]->description='';
$rows[0]->description2='';
$rows[0]->description3='';
}
if(!empty($_REQUEST['JAVA_GET_SELECT_TABLE_SELECT'])) {
print json_encode($rows);
} else {
echo "Wyszukaj Adres:";
echo "
Niżej wybierz wyszukany adres:
";
// echo "";
// echo " asd ID_BILLING_W_DT
";
}
}