86 |
$sql_where="org_jed.id=osobe.org_jed_id |
$sql_where="org_jed.id=osobe.org_jed_id |
87 |
and org_pod_jed.pod_id=osobe.org_pod_jed_id |
and org_pod_jed.pod_id=osobe.org_pod_jed_id |
88 |
and kontakt_osoba_id=kontakt_osobe.id |
and kontakt_osoba_id=kontakt_osobe.id |
89 |
|
and osobe.aktivna=true |
90 |
"; |
"; |
91 |
$sql_order="order by id"; |
$sql_order="order by id"; |
92 |
|
|
123 |
} |
} |
124 |
|
|
125 |
if (isset($imepr) && $imepr != "") { |
if (isset($imepr) && $imepr != "") { |
126 |
$sql_where.=" and ( upper(toczs(osobe.ime)) like upper(toczs('$imepr')) or upper(toczs(osobe.prezime)) like upper(toczs('$imepr')) )"; |
$sql_where.=" and osobe.aktivna=true and ( upper(toczs(osobe.ime)) like upper(toczs('$imepr')) or upper(toczs(osobe.prezime)) like upper(toczs('$imepr')) )"; |
127 |
} |
} |
128 |
|
|
129 |
$sql="select $sql_polja from $sql_tablice where $sql_where $sql_order limit $on_page,$from"; |
$sql="select $sql_polja from $sql_tablice where $sql_where $sql_order limit $on_page,$from"; |