function getAdrID($group_id = 0, $search = array())
{
//liefert NUR die IDs zurueck als Array!!! Beoetigt fuer die Formulare
//keine suche ueber f0_9 !!!!! da wir speicher sparen wollen... nur ids!
//bzw neue query testen!
$ADRID = array();
$DB = new tm_DB();
$Query = "\n\t\t\t\t\t\tSELECT " . TM_TABLE_ADR . ".id\n\t\t\t\t\t\tFROM " . TM_TABLE_ADR . "\n\t\t\t\t\t";
if (isset($search['group']) && !empty($search['group'])) {
$group_id = checkset_int($search['group']);
}
if (check_dbid($group_id)) {
$Query .= "LEFT JOIN " . TM_TABLE_ADR_GRP_REF . " ON " . TM_TABLE_ADR . ".id = " . TM_TABLE_ADR_GRP_REF . ".adr_id";
}
$Query .= " WHERE " . TM_TABLE_ADR . ".siteid='" . TM_SITEID . "'";
if (check_dbid($group_id)) {
$Query .= " AND " . TM_TABLE_ADR_GRP_REF . ".siteid='" . TM_SITEID . "'\n\t\t\t\t\t\t AND " . TM_TABLE_ADR_GRP_REF . ".grp_id=" . checkset_int($group_id);
}
if (isset($search['email']) && !empty($search['email'])) {
$Query .= " AND lcase(" . TM_TABLE_ADR . ".email) like lcase('" . dbesc($search['email']) . "')";
}
if (isset($search['recheck']) && !empty($search['recheck'])) {
$Query .= " AND " . TM_TABLE_ADR . ".recheck = " . checkset_int($search['recheck']) . "";
}
if (isset($search['aktiv']) && ($search['aktiv'] === "1" || $search['aktiv'] === "0")) {
//!!! we have to compare strings, weird php! argh.
$Query .= " AND " . TM_TABLE_ADR . ".aktiv = " . checkset_int($search['aktiv']) . "";
}
//check for status, OR
if (isset($search['status']) && $search['status'] > 0) {
//if is no array, let first array entry be the string, so we always have an array
if (!is_array($search['status'])) {
$search_status = $search['status'];
$search['status'] = array();
$search['status'][0] = $search_status;
}
//create query
$ssc = count($search['status']);
if ($search['status'][0] > 0) {
$Query .= " AND (";
for ($sscc = 0; $sscc < $ssc; $sscc++) {
$Query .= TM_TABLE_ADR . ".status=" . checkset_int($search['status'][$sscc]);
if ($sscc + 1 < $ssc) {
$Query .= " OR";
}
}
$Query .= " )";
}
}
$DB->Query($Query);
$ac = 0;
while ($DB->next_record()) {
$ADRID[$ac] = $DB->Record['id'];
$ac++;
}
$this->DB->free();
return $ADRID;
}
function getID($group_id = 0, $search = array())
{
//liefert NUR die IDs in einer Gruppe zurueck als Array!!! Beoetigt fuer die Formulare
$ID = array();
$DB = new tm_DB();
$Query = "\n\t\t\t\t\t\tSELECT " . $this->TM_TABLE_ITEM . ".id\n\t\t\t\t\t\tFROM " . $this->TM_TABLE_ITEM . "\n\t\t\t\t\t";
if (isset($search['group']) && !empty($search['group'])) {
$group_id = checkset_int($search['group']);
}
if (check_dbid($group_id)) {
$Query .= "LEFT JOIN " . $this->TM_TABLE_ITEM_GRP_REF . " ON " . $this->TM_TABLE_ITEM . ".id = " . $this->TM_TABLE_ITEM_GRP_REF . ".item_id";
}
$Query .= " WHERE " . $this->TM_TABLE_ITEM . ".siteid='" . TM_SITEID . "'";
if (check_dbid($group_id)) {
$Query .= " AND " . $this->TM_TABLE_ITEM_GRP_REF . ".siteid='" . TM_SITEID . "'\n\t\t\t\t\t\t AND " . $this->TM_TABLE_ITEM_GRP_REF . ".grp_id=" . checkset_int($group_id);
}
if (isset($search['url']) && !empty($search['url'])) {
$Query .= " AND lcase(" . $this->TM_TABLE_ITEM . ".url) like lcase('" . dbesc($search['url']) . "')";
}
if (isset($search['aktiv']) && ($search['aktiv'] === "1" || $search['aktiv'] === "0")) {
//!!! we have to compare strings, weird php! argh.
$Query .= " AND " . $this->TM_TABLE_ITEM . ".aktiv = " . checkset_int($search['aktiv']) . "";
}
$DB->Query($Query);
$c = 0;
while ($DB->next_record()) {
$ITEMID[$c] = $DB->Record['id'];
$c++;
}
$this->DB->free();
return $ITEMID;
}
