コード例 #1
0
function SiteCreatorAdm(&$smarty, $form = false)
{
    $tabela = $smarty->cfg['prefix'] . 'bilder_site';
    $smarty->assign($smarty->actualpage);
    $page = new PageBilder($smarty, $form);
    $file = new SiteCreator();
    if ($_POST['action'] && !$form['action']) {
        $form['action'] = $_POST['action'];
    }
    if ($_POST['idde'] && !$form['idde']) {
        $form['idde'] = $_POST['idde'];
    }
    switch ($form['action']) {
        case 'save':
            $request = $page->SqlSelect("SELECT * FROM {$tabela} WHERE ID_SITE = {$form['idde']}");
            $itens = mysql_fetch_array($request, MYSQL_ASSOC);
            $file->SaveSiteEditor($smarty, $form);
            if ($file->SaveSiteEditor($smarty, $form)) {
                return $smarty->getFinishError('sitecreator_erro_03');
            }
            ##################
            ### criar LOG ####
            ##################
        ##################
        ### criar LOG ####
        ##################
        case 'edit':
            $smarty->assign($form);
            $request = $page->SqlSelect("SELECT * FROM {$tabela} WHERE ID_SITE = '{$form['idde']}'");
            $itens = mysql_fetch_array($request, MYSQL_ASSOC);
            $file->LoadSiteEditor($smarty, $form);
            return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm_editor.tpl");
            break;
        case 'del':
            if (is_numeric($page->uri['idde'])) {
                $file->RemoveSite($smarty, $form);
                $sql = $page->SqlDelete($tabela, "ID_SITE ='{$page->uri[idde]}'");
                $page->SqlSelect($sql);
                ## remover grupo
            }
            $cfg = array("SetTable" => $tabela, "SetCaption" => array("ID_SITE", "site_name", "site_dominio"));
            if (isset($page->uri['busca']) && $page->uri['busca'] != "") {
                $cfg["SetSearch"] = $page->uri['busca'];
            }
            $cfg["SetOrdenar"] = $page->uri['por'];
            $cfg["SetOrder"] = $page->uri["ord"];
            $page->CreateSelectSQL($cfg, $smarty);
            $form['tabela'] = $cfg['SetTable'];
            $form['coluna'] = $cfg['ID_SITE'];
            $smarty->register_object("listagem", $page);
            return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm.tpl");
            break;
        case 'view':
        case 'redit':
        default:
            $cfg = array("SetTable" => $tabela, "SetCaption" => array("ID_SITE", "site_name", "site_dominio"));
            if (isset($page->uri['busca']) && $page->uri['busca'] != "") {
                $cfg["SetSearch"] = $page->uri['busca'];
            }
            $cfg["SetOrdenar"] = $page->uri['por'];
            $cfg["SetOrder"] = $page->uri["ord"];
            $page->CreateSelectSQL($cfg, $smarty);
            $form['tabela'] = $cfg['SetTable'];
            $form['coluna'] = $cfg['ID_SITE'];
            $smarty->register_object("listagem", $page);
            return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm.tpl");
    }
}
コード例 #2
0
function smarty_function_sqldropdown($params, &$smarty)
{
    if (!$params["id"] || $params["id"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(id)'));
    }
    if (!$params["SetLabel"] || $params["SetLabel"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(SetLabel)'));
    }
    if (!$params["SetValue"] || $params["SetValue"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(SetValue)'));
    }
    $params["SetCaption"] = array_merge($params["SetValue"], $params["SetLabel"]);
    $page = new PageBilder($smarty);
    $sql = $page->CreateSelectSQL($params, $smarty);
    $result = $page->SqlSelect($sql);
    if (mysql_affected_rows() > 0) {
        while ($item = mysql_fetch_array($result, MYSQL_ASSOC)) {
            if (isset($params["SetGroup"])) {
                $vec = $item[$params["SetGroup"]];
                $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'selected' : null);
            } else {
                $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'selected' : $params["SetSelectd"] == $item[$params["SetLabel"]] ? 'selected' : null);
            }
        }
    } else {
        $vec[] = array('value' => '0', 'label' => $smarty->get_config_vars('ERROR_010'));
    }
    ##### Traduzir conteudos #####
    if (isset($params["SetTranslation"])) {
        foreach ($vec as $valor) {
            $val = $params["SetTranslation"] . strtr($valor['value'], "-", "_");
            $valor['label'] = $smarty->get_config_vars($val) ? $smarty->get_config_vars($val) : $valor['label'];
            $novo[] = $valor;
        }
    } else {
        $novo = $vec;
    }
    usort($novo, "cmp");
    reset($novo);
    ########################
    $optionSelect = '<select id="' . $params["id"] . '" name="' . $params["id"] . '"';
    if (isset($params["size"]) && $params["size"] != "") {
        $optionSelect .= 'size="' . $params["size"] . '"';
    }
    if (isset($params["height"]) && $params["height"] != "") {
        $optionSelect .= 'height="' . $params["height"] . '"';
    }
    if (isset($params["onChange"]) && $params["onChange"] != "") {
        $optionSelect .= 'onchange="' . $params["onChange"] . '"';
    }
    if (isset($params["onFocus"]) && $params["onFocus"] != "") {
        $optionSelect .= 'onfocus="' . $params["onFocus"] . '"';
    }
    if (isset($params["onBlur"]) && $params["onBlur"] != "") {
        $optionSelect .= 'onblur="' . $params["onBlur"] . '"';
    }
    $optionSelect .= ' >';
    if (isset($params["SetInicial"])) {
        $optionSelect .= '<option value="0">' . $params["SetInicial"] . '</option>' . "\r\n";
    }
    if (isset($params["SetGroup"])) {
        ##asdasd
    } else {
        foreach ($novo as $itemcat) {
            $check = $itemcat['selected'] == null ? null : " selected=\"{$itemcat['selected']}\"";
            $optionSelect .= '<option value="' . $itemcat['value'] . '"' . $check . '>' . $itemcat['label'] . '</option>';
        }
    }
    $optionSelect .= '</select>';
    return $optionSelect;
}
コード例 #3
0
function UsuarioAdm(&$smarty, $form = false)
{
    $tabela = $smarty->cfg['prefix'] . 'members';
    $smarty->assign($smarty->actualpage);
    $page = new PageBilder($smarty, $form);
    $cfg = array("SetTable" => $tabela, "SetOrdenar" => $page->uri['por'], "SetOrder" => $page->uri["ord"], "SetCaption" => array("ID_MEMBER", "member_name", "member_real"));
    if (isset($page->uri['busca']) && $page->uri['busca'] != "") {
        $cfg["SetSearch"] = $page->uri['busca'];
    }
    $page->CreateSelectSQL($cfg, $smarty);
    $smarty->register_object("listagem", $page);
    $page->uri['tabela'] = $tabela;
    $page->uri['coluna'] = 'ID_MEMBER';
    $user = $smarty->getVars('ID_MEMBER');
    switch ($page->uri['action']) {
        case 'view':
            $page->uri['prefix'] = 'member';
            $page->uri['prefixch'] = 'registro';
            $page->uri['select'] = '*, ID_MEMBER as registro_id';
            $item = $page->exibeRegistro($page->uri, $smarty);
            $smarty->assign($item);
            $p = $smarty->fetch($smarty->modulo_dir . "usuario_adm_view.tpl");
            $smarty->clear_assign($item);
            return $p;
            break;
        case 'edit':
            $page->uri['prefix'] = 'member';
            $page->uri['prefixch'] = 'registro';
            $page->uri['select'] = '*, ID_MEMBER as registro_id';
            $item = $page->exibeRegistro($page->uri, $smarty);
            $smarty->assign($item);
            $p = $smarty->fetch($smarty->modulo_dir . "usuario_adm_edit.tpl");
            $smarty->clear_assign($item);
            $smarty->assign('ID_MEMBER', $user);
            return $p;
            break;
        case 'del':
            if (is_numeric($page->uri['idde'])) {
                $sql = $page->SqlDelete($tabela, "ID_MEMBER ='{$page->uri[idde]}'");
                $page->SqlSelect($sql);
                ## remover grupo
            }
            return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl");
            break;
        case 'redit':
            if ($page->uri['action'] == 'redit') {
                if (!(trim($form['member_password']) == null || trim($form['member_password']) == "")) {
                    $form['member_password'] = Registro::md5_hmac($form['member_password'], strtolower($form['member_name']));
                } else {
                    unset($form['member_password']);
                }
                $form['member_ip'] = $_SERVER['REMOTE_ADDR'];
                if (is_numeric($form[idde])) {
                    $idde = $form[idde];
                    unset($form[idde]);
                    $sql = $page->SqlUpdate($page->uri['tabela'], $form, "ID_MEMBER = '{$idde}'");
                    $request = $page->SqlSelect($sql);
                }
                return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl");
            }
            break;
        default:
            return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl");
    }
}
コード例 #4
0
function smarty_function_sqlradiobox($params, &$smarty)
{
    if (!$params["id"] || $params["id"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(id)'));
    }
    if (!$params["SetLabel"] || $params["SetLabel"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(SetLabel)'));
    }
    if (!$params["SetValue"] || $params["SetValue"] == "") {
        return $smarty->getFinishError("ERROR_008", array("", '(SetValue)'));
    }
    $params["SetCaption"] = array_merge($params["SetValue"], $params["SetLabel"]);
    $page = new PageBilder($smarty);
    $sql = $page->CreateSelectSQL($params, $smarty);
    $result = $page->SqlSelect($sql);
    if (mysql_affected_rows() > 0) {
        while ($item = mysql_fetch_array($result, MYSQL_ASSOC)) {
            $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'checked' : $params["SetSelectd"] == $item[$params["SetLabel"]] ? 'checked' : null);
        }
    } else {
        return $smarty->getFinishError("ERROR_011");
    }
    ##### Traduzir conteudos #####
    if (isset($params["SetTranslation"])) {
        foreach ($vec as $valor) {
            $val = $params["SetTranslation"] . $valor['value'];
            $valor['label'] = $smarty->get_config_vars($val) ? $smarty->get_config_vars($val) : $val;
            $novo[] = $valor;
        }
    } else {
        $novo = $vec;
    }
    usort($novo, "cmp");
    reset($novo);
    ########################
    $optionSelect = '';
    foreach ($novo as $itemcat) {
        $optionSelect .= '<label for="' . $params["id"] . "_" . $itemcat['value'] . '">';
        if ($params["SetDisplay"] == "img") {
            $optionSelect .= "<img src=\"{$itemcat['label']}\" ";
            if (isset($params["SetDisplayheight"])) {
                $optionSelect .= 'height="' . $params["SetDisplayheight"] . '" ';
            }
            if (isset($params["SetDisplaywidth"])) {
                $optionSelect .= 'width="' . $params["SetDisplaywidth"] . '" ';
            }
            $optionSelect .= "/><br />";
        } else {
            $optionSelect .= $itemcat['label'];
        }
        $check = $itemcat['selected'] == null ? null : " checked=\"{$itemcat['selected']}\"";
        $optionSelect .= '<input type="radio" id="' . $params["id"] . "_" . $itemcat['value'] . '" name="' . $params["id"] . '" value="' . $itemcat['value'] . '" ';
        if ($params["onSelect"]) {
            $optionSelect .= 'onselect="' . $params["onSelect"] . '" ';
        }
        if ($params["onFocus"]) {
            $optionSelect .= 'onfocus="' . $params["onFocus"] . '" ';
        }
        if ($params["onBlur"]) {
            $optionSelect .= 'onblur="' . $params["onBlur"] . '" ';
        }
        if ($params["onClick"]) {
            $optionSelect .= 'onclick="' . $params["onClick"] . '" ';
        }
        $optionSelect .= $check . ' />';
        $optionSelect .= '</label>';
    }
    return $optionSelect;
}