if ($predchozi_stav == "" || $predchozi_stav != $skupina["stav"]) { $predchozi_stav = $skupina["stav"]; $T_data["nazevStav"] = $skupiny_popis[$skupina["stav"]]; $TM->assignBlockVars('uzivatel.edit.skupinySetup.stav', $T_data, 3); } $T_data["id"] = $skupina["id"]; $T_data["nazev"] = $skupina["nazev"] . " -> " . $skupina["kanalNazev"]; $T_data["imgURL"] = "css/" . $_REQUEST["s"] . "/images/delete.png"; $T_data["delURL"] = getUrl("adminUzivatele", array('u' => $_REQUEST["u"], 'a' => "delete", 'skupID' => $skupina["id"])); $TM->assignBlockVars('uzivatel.edit.skupinySetup.stav.skup', $T_data, 4); } } //pridat skupiny $sql = "SELECT * FROM skupiny\n WHERE stav != 'none' AND id NOT IN (" . implode($uzivatelovy_skupiny, ",") . ")\n ORDER BY nazev"; $rs = $sqlEngine->query($sql); if (SQLEngine::getRowCount($rs) > 0) { $TM->assignBlockVars('uzivatel.edit.pridat', $actionHere, 2); foreach (SQLEngine::getRows($rs) as $skupina) { unset($T_data); $T_data["id"] = $skupina["id"]; $T_data["nazev"] = $skupina["nazev"]; $TM->assignBlockVars('uzivatel.edit.pridat.kategorie', $T_data, 3); } $sql = "SELECT * FROM kanaly"; $rs = $sqlEngine->query($sql); $nastavenyKanal = false; foreach (SQLEngine::getRows($rs) as $kanal) { unset($T_data); $T_data["id"] = $kanal["id"]; $T_data["nazev"] = $kanal["nazev"]; if ($kanal["nazev"] == "email" && $u["email"] != "" || $kanal["nazev"] == "sms" && $u["sms"] != "") {
function vypis($limit = 30, $offset = 0, $filtr = array(), $order_by = "login", $order_type = "ASC") { /* login telefon jmeno prijmeni icq skype email aktivni = "A"=ano/"N"=ne/""=nevybrano celkem_inzeratu_cond = null = nevybrano, lt = mene nez, gt = vice nez, eq = rovno celkem_inzeratu priceCond = null = nevybrano, lt = mene nez, gt = vice nez, eq = rovno celkem_trzba_cond = cena inzeratu datumPrihlaseni][od] = datumPrihlaseni][do] = */ if ($order_by == "") { $order_by = "login"; } if ($filtr["login"] != "") { $where .= " AND login LIKE '%" . mysql_escape_string($filtr["login"]) . "%'"; } if ($filtr["email"] != "") { $where .= " AND email LIKE '%" . mysql_escape_string($filtr["email"]) . "%'"; } if ($filtr["jmeno"] != "") { $where .= " AND jmeno LIKE '%" . mysql_escape_string($filtr["jmeno"]) . "%'"; } if ($filtr["prijmeni"] != "") { $where .= " AND prijmeni LIKE '%" . mysql_escape_string($filtr["prijmeni"]) . "%'"; } if ($filtr["telefon"] != "") { $where .= " AND telefon LIKE '%" . mysql_escape_string($filtr["telefon"]) . "%'"; } if ($filtr["icq"] != "") { $where .= " AND icq LIKE '%" . mysql_escape_string($filtr["icq"]) . "%'"; } if ($filtr["skype"] != "") { $where .= " AND skype LIKE '%" . mysql_escape_string($filtr["skype"]) . "%'"; } if ($filtr["aktivni"] != "") { $where .= " AND aktivni='" . mysql_escape_string($filtr["aktivni"]) . "'"; } if ($filtr["celkem_inzeratu"] != "") { $podm = "="; if ($filtr["celkem_inzeratu_cond"] == "lt") { $podm = "<="; } if ($filtr["celkem_inzeratu_cond"] == "gt") { $podm = ">="; } $where .= " AND celkem_inzeratu" . $podm . mysql_escape_string($filtr["celkem_inzeratu"]); } if ($filtr["celkem_trzba"] != "") { $podm = "="; if ($filtr["celkem_trzba_cond"] == "lt") { $podm = "<="; } if ($filtr["celkem_trzba_cond"] == "gt") { $podm = ">="; } $where .= " AND celkem_trzba" . $podm . mysql_escape_string($filtr["celkem_trzba"]); } if ($filtr["datumPrihlaseni"]["od"] != "") { $where .= " AND posledni_prihlaseni>='" . mysql_escape_string($filtr["datumPrihlaseni"]["od"]) . " 00:00:00'"; } if ($filtr["datumPrihlaseni"]["do"] != "") { $where .= " AND posledni_prihlaseni<='" . mysql_escape_string($filtr["datumPrihlaseni"]["do"]) . " 23:59:59'"; } $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM uzivatel WHERE bazar='" . $this->bazar . "' " . $where . " order by " . $order_by . " " . $order_type . " LIMIT " . $limit; #echo $sql; #exit; #return; if ($offset > 0) { $sql .= "," . $offset; } $rs = $this->db2->query($sql); $out["result"] = SQLEngine::getErrorCode($rs); $out["result_text"] = SQLEngine::getErrorText($rs); $out['uzivatele'] = SQLEngine::getRows($rs); $out['pocet'] = SQLEngine::getRowCount($rs); #print_r($sql); #exit; return $out; }
$T_data["urlLocation"] = getUrl("publicMessages", array("skupina" => $sk["id"], "stav" => $_REQUEST["stav"], "pocet" => $_REQUEST["pocet"])); $T_data["choose"] = $_REQUEST["skupina"] == $sk["id"] ? "selected=\"selected\"" : ""; $TM->assignBlockVars('filtr.option', $T_data, 1); } //vypis zprav do tabulky $filter_stav = isset($_REQUEST["stav"]) ? "= '" . $_REQUEST["stav"] . "'" : "= 'DONE'"; $filter_pocet = isset($_REQUEST["pocet"]) ? $_REQUEST["pocet"] + 0 : 30; $query = "SELECT zpravy.id,\n zpravy.text,\n UNIX_TIMESTAMP(zpravy.odeslatPo)+3600 as odeslatPo,\n UNIX_TIMESTAMP(zpravy.vlozeno)+3600 as vlozeno,\n zpravy.stav\n FROM zpravy\n INNER JOIN spravce_admini ON spravce_admini.id = zpravy.vytvoril\n WHERE (zpravy.stav = 'NEW' OR zpravy.stav " . $filter_stav . ")\n AND zpravy.odeslatPo <= NOW()\n AND zpravy.odeslatPo > SUBDATE(NOW(),INTERVAL 2 MONTH)\n ORDER BY stav, odeslatPo DESC"; $qZpravy = $sqlEngine->query($query); $vypsanychZprav = 0; //vypis zprav $vypsatZprav = 10; foreach (SQLEngine::getRows($qZpravy) as $zprava) { $query = "SELECT idSkupiny FROM zpravy_skupiny\n INNER JOIN skupiny ON skupiny.id = zpravy_skupiny.idSkupiny\n WHERE zpravy_skupiny.idZpravy = " . $zprava["id"] . " &&\n " . (isset($_REQUEST["skupina"]) ? "zpravy_skupiny.idSkupiny = '" . $_REQUEST["skupina"] . "'" : "true") . " &&\n skupiny.stav = 'public'"; $qFilter = $sqlEngine->query($query); if (SQLEngine::getRowCount($qFilter) == 0) { continue; } unset($T_data); $T_data["text"] = nl2br(stripcslashes($zprava["text"])); $T_data["styl"] = strtolower($zprava["stav"]); $T_data["vlozeno"] = date("d.m.Y H:i", $zprava["odeslatPo"]); //menu zpravy $menu = ""; switch ($zprava["stav"]) { case "STOP": $T_data["stav"] = "Rozesílání pozastavena"; break; case "NEW": $T_data["stav"] = "Bude rozeslano: " . date("d.m.Y H:i", $zprava["odeslatPo"]); break;
$T_data['disable_sms'] = "disabled"; $T_data['option_sms'] = get_option($vybranyKanal[1], $cenaKanal[$row["id"]][1]); $TM->assignBlockVars('table_A.row_A', $T_data, 1); foreach ($vybranyKanal as $i => $v) { $vybranyKanal[$i] = -1; } } // nacteme skupiny dostupne jen po schvaleni spravce $sql = "SELECT * FROM skupiny \n WHERE stav = 'private'"; $rs = $sqlEngine->query($sql); foreach (SQLEngine::getRows($rs) as $row) { unset($T_data); //seznam vybranych kanalu $rs_viceKanalu = $sqlEngine->query("SELECT * FROM uzivatele_skupiny WHERE idUzivatel = ? && idSkupina = ?", array($_SESSION["user"]["id"], $row["id"])); // muzeme zobrazit jen ty co jsou prideleny spravcem, uzivatel si VIP sam vybrat nemuze if (SQLEngine::getRowCount($rs_viceKanalu) == 0) { continue; } foreach (SQLEngine::getRows($rs_viceKanalu) as $kanal) { $vybranyKanal[$kanal["kanal"]] = 0; } $T_data['skupina_nazev'] = $row["nazev"]; $T_data['idSkupiny'] = $row["id"]; $is_email_ok ? $T_data['disable_email'] = "" : ($T_data['disable_email'] = "disabled"); $T_data['option_email'] = get_option($vybranyKanal[0], $cenaKanal[$row["id"]][0]); // zatim je defaultne uzivateli zakazano nastavovat SMS, pouze admin // ($is_sms_ok ? $T_data['disable_sms'] = "" : $T_data['disable_sms'] = "disabled"); $T_data['disable_sms'] = "disabled"; $T_data['option_sms'] = get_option($vybranyKanal[1], $cenaKanal[$row["id"]][1]); $TM->assignBlockVars('table_B.row_B', $T_data, 1); foreach ($vybranyKanal as $i => $v) {