DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS']=$_REQUEST['JAVA_VALUE'];
} else if($_REQUEST['JAVA_FIELD']==$field_name.'__JAVA') {
$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA']=$_REQUEST['JAVA_VALUE'];
}
}
$where=" where ID like '%".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name.'__JAVA'])."%'
and ID_BILLING_USERS like '%".addslashes($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER_OLD__JAVA_FILTR_ID_BILLING_USERS'])."%'
";
$sql = "select `ID` as `key`, concat_ws(' ','ID rekordu Deals:',ID,'; Numer P_DEALNUMBER/PREFIX:',P_DEALNUMBER,P_DEALPREFIX,'; UserID:',`ID_BILLING_USERS`, '; z dnia ',`P_DEALDATE`) as description from `DEALS_TABLE` ".$where." order by `ID` DESC limit 25 ";
ZAP_SQL( $sql );
$i=0;
while ($r = mysql_fetch_object( $result )) {
$rows[$i]->key=$r->key;
$rows[$i]->description=addslashes(iconv("UTF-8", "ISO-8859-1//TRANSLIT", $r->description));
$i++;
}
if(empty($rows)) {
$rows[0]->key='';
$rows[0]->description='';
$rows[0]->description2='';
$rows[0]->description3='';
}
// echo $sql;
if(!empty($_REQUEST['JAVA_GET_SELECT_TABLE_SELECT'])) {
print json_encode($rows);
} else {
echo "Numer Umowy: ";
echo "Numer Platnika:";
// echo "";
echo "";
// echo "";
// echo " asd ID_BILLING_W_DT
";
}
}