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) {
