function MG_editRSS() { global $_CONF, $_MG_CONF, $_TABLES, $_USER, $LANG_MG00, $LANG_MG01; $retval = ''; $T = new Template($_MG_CONF['template_path'] . '/admin'); $T->set_file('admin', 'rssedit.thtml'); $T->set_var('site_url', $_CONF['site_url']); $T->set_var('site_admin_url', $_CONF['site_admin_url']); $rss_full_select = '<input type="checkbox" name="rss_full_enabled" value="1" ' . ($_MG_CONF['rss_full_enabled'] ? ' checked="checked"' : '') . '/>'; $rss_type_select = "<select name='rss_feed_type'>"; $rss_type_select .= "<option value='RSS-2.0'" . ($_MG_CONF['rss_feed_type'] == "RSS-2.0" ? ' selected="selected"' : "") . ">RSS2.0</option>"; $rss_type_select .= "<option value='RSS-1.0'" . ($_MG_CONF['rss_feed_type'] == "RSS-1.0" ? ' selected="selected"' : "") . ">RSS1.0</option>"; $rss_type_select .= "<option value='RSS-0.91'" . ($_MG_CONF['rss_feed_type'] == "RSS-0.91" ? ' selected="selected"' : "") . ">RSS0.91</option>"; $rss_type_select .= "<option value='PIE-0.1'" . ($_MG_CONF['rss_feed_type'] == "PIE-0.1" ? ' selected="selected"' : "") . ">PIE0.1</option>"; $rss_type_select .= "<option value='ATOM-1.0'" . ($_MG_CONF['rss_feed_type'] == "ATOM-1.0" ? ' selected="selected"' : "") . ">ATOM</option>"; $rss_type_select .= "<option value='ATOM-0.3'" . ($_MG_CONF['rss_feed_type'] == "ATOM-0.3" ? ' selected="selected"' : "") . ">ATOM0.3</option>"; $rss_type_select .= "</select>"; $hide_email_select = '<input type="checkbox" name="hide_email" value="1" ' . ($_MG_CONF['hide_author_email'] ? ' checked="checked"' : '') . '/>'; $rss_ignore_empty_select = '<input type="checkbox" name="rss_ignore_empty" value="1" ' . ($_MG_CONF['rss_ignore_empty'] ? ' checked="checked"' : '') . '/>'; $rss_anonymous_only_select = '<input type="checkbox" name="rss_anonymous_only" value="1" ' . ($_MG_CONF['rss_anonymous_only'] ? ' checked="checked"' : '') . '/>'; $T->set_var(array('lang_rss_options' => $LANG_MG01['rss_options'], 'lang_rss_full' => $LANG_MG01['rss_full'], 'lang_rss_type' => $LANG_MG01['rss_type'], 'lang_rss_ignore_empty' => $LANG_MG01['rss_ignore_empty'], 'lang_rss_anonymous_only' => $LANG_MG01['rss_anonymous_only'], 'lang_rss_feed_name' => $LANG_MG01['rss_feed_name'], 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_reset' => $LANG_MG01['reset'], 'rss_full_select' => $rss_full_select, 'rss_type_select' => $rss_type_select, 'hide_email_select' => $hide_email_select, 'lang_hide_email' => $LANG_MG01['hide_email'], 'rss_ignore_empty_select' => $rss_ignore_empty_select, 'rss_anonymous_only_select' => $rss_anonymous_only_select, 'rss_feed_name' => $_MG_CONF['rss_feed_name'], 's_form_action' => $_MG_CONF['admin_url'] . 'rss.php')); $T->parse('output', 'admin'); $retval .= $T->finish($T->get_var('output')); return $retval; }
function MG_selectUsers($page) { global $glversion, $_CONF, $_MG_CONF, $_TABLES, $_USER, $LANG_MG00, $LANG_MG01; $retval = ''; $T = new Template($_MG_CONF['template_path']); $T->set_file('admin', 'createmembers.thtml'); $T->set_var(array('site_admin_url' => $_CONF['site_admin_url'], 'site_url' => $_CONF['site_url'], 'xhtml' => XHTML)); $T->set_block('admin', 'UserRow', 'uRow'); $start = $page * 50; $end = 50; $sql = "SELECT COUNT(gl.uid) AS count " . "FROM {$_TABLES['users']} AS gl " . "LEFT JOIN {$_TABLES['mg_userprefs']} AS mg ON gl.uid=mg.uid " . "WHERE gl.status = 3 AND gl.uid > 2 AND (mg.member_gallery IS NULL OR mg.member_gallery < 1)"; $result = DB_query($sql); list($total_records) = DB_fetchArray($result); $sql = "SELECT gl.uid, gl.status, gl.username, gl.fullname, mg.member_gallery " . "FROM {$_TABLES['users']} AS gl " . "LEFT JOIN {$_TABLES['mg_userprefs']} AS mg ON gl.uid=mg.uid " . "WHERE gl.status = 3 AND gl.uid > 2 AND (mg.member_gallery IS NULL OR mg.member_gallery < 1) " . "ORDER BY gl.username ASC LIMIT {$start},{$end}"; $result = DB_query($sql); while ($row = DB_fetchArray($result)) { if ($glversion[1] < 4) { $row['status'] = 3; } $uid = $row['uid']; $remote = SEC_inGroup("Remote Users", $uid) ? '(r)' : ''; $username = $row['username']; $member_gallery = $row['member_gallery']; $T->set_var(array('uid' => $uid, 'username' => $username . ' ' . $remote . ' - ' . $row['fullname'], 'select' => '<input type="checkbox" name="user[]" value="' . $uid . '"' . XHTML . '>')); $T->parse('uRow', 'UserRow', true); } $T->set_var(array('lang_userid' => $LANG_MG01['userid'], 'lang_username' => $LANG_MG01['username'], 'lang_select' => $LANG_MG01['select'], 'lang_checkall' => $LANG_MG01['check_all'], 'lang_uncheckall' => $LANG_MG01['uncheck_all'], 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_reset' => $LANG_MG01['reset'], 's_form_action' => $_MG_CONF['admin_url'] . 'createmembers.php', 'pagenav' => COM_printPageNavigation($_MG_CONF['admin_url'] . 'createmembers.php', $page + 1, ceil($total_records / 50)))); $retval .= $T->finish($T->parse('output', 'admin')); return $retval; }
function disp() { $t = new Template('../template/system'); $t->set_file('f', 'loginfo.html'); $t->set_block('f', 'row', 'r'); $rs = $this->dbObj->GetArray('select lt.logtypename,l.* from ' . WEB_ADMIN_TABPOX . 'log l,' . WEB_ADMIN_TABPOX . 'logtype lt where l.logtypeid=lt.logtypeid and l.srcuserid=' . $this->getUid()); foreach ($rs as $v) { $t->set_var($v); $ok = $this->loginObj->_superid ? false : true; $t->set_var('del', $this->getDelStr($this->getUid(), $v['logid'], 'a', 'loginfo.php?deltype=log', $ok)); $t->parse('r', 'row', true); } $t->set_block('f', 'row2', 'r2'); $rs = $this->dbObj->GetArray("select u.username,m.* from " . WEB_ADMIN_TABPOX . "message m," . WEB_ADMIN_TABPOX . "user u where m.userid = u.userid and msgtitle='组长登录' and sendtoids like '" . $this->getUid() . "'"); foreach ($rs as $v) { if (!$v['hadratify']) { if (!$this->loginObj->_superid) { $v['accept'] = '<a href="loginfo.php?action=accept&id=' . $v['msgid'] . '">认可</a>'; } else { $v['accept'] = '认可'; } } else { $v['accept'] = '已认可'; } $t->set_var($v); $ok = $this->loginObj->_superid ? false : true; $t->set_var('del', $this->getDelStr($this->getUid(), $v['msgid'], 'a', 'loginfo.php?deltype=msg', $ok)); $t->parse('r2', 'row2', true); } $t->parse('out', 'f'); $t->p('out'); }
function MG_editUser($uid) { global $_CONF, $_MG_CONF, $_TABLES, $_USER, $LANG_MG00, $LANG_MG01; $retval = ''; $active = 0; $quota = 0; $username = DB_getItem($_TABLES['users'], 'username', "uid=" . $uid); $result = DB_query("SELECT active,quota FROM {$_TABLES['mg_userprefs']} WHERE uid=" . $uid); $nRows = DB_numRows($result); if ($nRows > 0) { $row = DB_fetchArray($result); $active = $row['active']; $quota = $row['quota'] / 1048576; } else { $active = 1; $quota = $_MG_CONF['member_quota'] / 1048576; } $T = new Template($_MG_CONF['template_path'] . '/admin'); $T->set_file('admin', 'useredit.thtml'); $T->set_var('site_url', $_CONF['site_url']); $T->set_var('site_admin_url', $_CONF['site_admin_url']); $active_select = '<input type="checkbox" name="active" value="1" ' . ($active ? ' CHECKED' : '') . '/>'; $T->set_var(array('s_form_action' => $_MG_CONF['admin_url'] . 'edituser.php', 'lang_user_edit' => $LANG_MG01['edit_user'], 'lang_username' => $LANG_MG01['username'], 'lang_active' => $LANG_MG01['active'], 'lang_quota' => $LANG_MG01['quota'], 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_reset' => $LANG_MG01['reset'], 'lang_unlimited' => $LANG_MG01['zero_unlimited'], 'uid' => $uid, 'active' => $active_select, 'quota' => $quota, 'username' => $username)); $T->parse('output', 'admin'); $retval .= $T->finish($T->get_var('output')); return $retval; }
function MG_adminEXIF() { global $_TABLES, $_MG_CONF, $_CONF, $LANG_MG01, $LANG_MG04; $retval = ''; $T = new Template($_MG_CONF['template_path'] . '/admin/'); $T->set_file('admin', 'exif_tags.thtml'); $T->set_var('site_url', $_CONF['site_url']); $T->set_var('site_admin_url', $_CONF['site_admin_url']); $T->set_block('admin', 'exifRow', 'eRow'); $sql = "SELECT * FROM {$_TABLES['mg_exif_tags']}"; $result = DB_query($sql); $nRows = DB_numRows($result); for ($i = 0; $i < $nRows; $i++) { $row = DB_fetchArray($result); $properties[] = $row['name']; $tag[$row['name']][] = $row['selected']; } $exifKeys = getExifKeys(); $x = 0; foreach ($properties as $property) { $title = $exifKeys[$property][0]; $T->set_var(array('exif_tag' => $title, 'selected' => $tag[$property][0] ? ' checked="checked"' : '', 'tag' => $property, 'rowcounter' => $x % 2)); $T->parse('eRow', 'exifRow', true); $x++; } $T->set_var(array('lang_select' => $LANG_MG01['select'], 'lang_exiftag' => $LANG_MG01['exiftag'], 'lang_exif_admin_help' => $LANG_MG01['exif_admin_help'], 'lang_check_all' => $LANG_MG01['check_all'], 'lang_uncheck_all' => $LANG_MG01['uncheck_all'], 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 's_form_action' => $_MG_CONF['admin_url'] . 'exif_admin.php')); $T->parse('output', 'admin'); $retval .= $T->finish($T->get_var('output')); return $retval; }
function disp() { //定义模板 $t = new Template('../template/basic'); $t->set_file('f', 'upmorefile.html'); $t->unknowns = "remove"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $t->set_block('f', 'mainlist', 'ml'); //设置分类 $t->set_var('ml'); $inrs =& $this->dbObj->Execute('select * from ' . WEB_ADMIN_TABPOX . 'apparatus where agencyid =' . $_SESSION["currentorgan"]); //echo 'select * from '.WEB_ADMIN_TABPOX.'roomgroup where agencyid ='.$_SESSION["currentorgan"]; while ($inrrs =& $inrs->FetchRow()) { $t->set_var($inrrs); $t->parse('ml', 'mainlist', true); } $inrs->Close(); $t->set_var('add', $this->getAddStr('img')); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function disp() { //定义模板 $t = new Template('../template/finace'); $t->set_file('f', 'nianjie.html'); $t->unknowns = "remove"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $annualbatch_name = date('Y', time()) . "年"; $t->set_var('annualbatch_name', $annualbatch_name); //上次年结 $bgdate = $this->dbObj->getone('select enddate from ' . WEB_ADMIN_TABPOX . 'annualbatch where agencyid =' . $_SESSION["currentorgan"] . ' order by annualbatch_id desc'); if (!$bgdate) { //如果没有月结过 查找最早的单时间。 $bgdate = $this->dbObj->getone('select creattime from ' . WEB_ADMIN_TABPOX . 'sell where agencyid =' . $_SESSION["currentorgan"] . ' order by sell_id asc'); $bgdate = date('Y-m-d', strtotime($bgdate)); } else { $bgdate = date("Y-m-d", strtotime("{$m}+1 days", strtotime($bgdate))); //设置开始时间为上次月结的下一天 } $t->set_var('bgdate', $bgdate); $t->set_var('enddate', date('Y-m-d')); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function goDispAppend() { $t = new Template('../template/system'); $t->set_file('f', 'contactdetail.html'); $t->set_block('f', 'gender', 'g'); if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); } else { $updid = $_GET[MODIFY . 'id'] + 0; $t->set_var($this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'contact WHERE contactid = ' . $updid)); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); $inrs2 =& $this->dbObj->Execute("select * from " . WEB_ADMIN_TABPOX . "contact where contactid =" . $updid); while ($inrrs2 =& $inrs2->FetchRow()) { $sex = $inrrs2['gender']; } $inrs2->Close(); } $t->set_var('agentid', $_GET['agentid']); $t->set_var('shopid', $_GET['shopid']); $t->set_var('gender', $this->gender($sex)); $t->parse('g', 'gender', true); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function disp() { $t = new Template(WEB_ADMIN_TMPPATH); $dispObj = new DispAttachRule(&$this->dbObj, $this->getUid()); $t->set_file('f', 'pageconfig.html'); $t->set_block('f', 'row', 'r'); $p = $_GET['pageid'] + 0; $sql = "\r\n\t\t\tSELECT c.configvalue AS userdefalut,o.* FROM " . WEB_ADMIN_TABPOX . "otherrule o \r\n\t\t\t\tLEFT OUTER JOIN " . WEB_ADMIN_TABPOX . "config c ON ( (o.otherruleid = c.otherruleid) AND (c.userid = " . $this->getUid() . ") ) \r\n\t\t\tWHERE (o.isrule = 0) AND (o.issystemvar = 0) AND (o.ruleid = {$p})\r\n\t\t"; $rs = $this->dbObj->GetArray($sql); foreach ($rs as $v) { $t->set_var($dispObj->disp($v, $v['userdefalut'])); $t->parse('r', 'row', true); } $r = ''; $m = new Menu(&$this->dbObj); $s = $m->getRelating($p); for ($i = 0; $i < count($s); $i++) { if ($i == 0) { $r = $s[$i]['rulename']; } else { $r .= ' > ' . $s[$i]['rulename']; } } $t->set_var('updid', $p); $t->set_var('address', $r); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
/** * Shows all polls in system * * List all the polls on the system if no $pid is provided * * @return string HTML for poll listing * */ function polllist() { global $_CONF, $_TABLES, $_USER, $_PO_CONF, $LANG25, $LANG_LOGIN, $LANG_POLLS; $retval = ''; if (empty($_USER['username']) && ($_CONF['loginrequired'] == 1 || $_PO_CONF['pollsloginrequired'] == 1)) { $retval = COM_startBlock($LANG_LOGIN[1], '', COM_getBlockTemplate('_msg_block', 'header')); $login = new Template($_CONF['path_layout'] . 'submit'); $login->set_file(array('login' => 'submitloginrequired.thtml')); $login->set_var('xhtml', XHTML); $login->set_var('login_message', $LANG_LOGIN[2]); $login->set_var('site_url', $_CONF['site_url']); $login->set_var('lang_login', $LANG_LOGIN[3]); $login->set_var('lang_newuser', $LANG_LOGIN[4]); $login->parse('output', 'login'); $retval .= $login->finish($login->get_var('output')); $retval .= COM_endBlock(COM_getBlockTemplate('_msg_block', 'footer')); } else { require_once $_CONF['path_system'] . 'lib-admin.php'; $header_arr = array(array('text' => $LANG25[9], 'field' => 'topic', 'sort' => true), array('text' => $LANG25[20], 'field' => 'voters', 'sort' => true), array('text' => $LANG25[3], 'field' => 'unixdate', 'sort' => true), array('text' => $LANG_POLLS['open_poll'], 'field' => 'is_open', 'sort' => true)); $defsort_arr = array('field' => 'unixdate', 'direction' => 'desc'); $text_arr = array('has_menu' => false, 'title' => $LANG_POLLS['pollstitle'], 'instructions' => "", 'icon' => '', 'form_url' => ''); $query_arr = array('table' => 'polltopics', 'sql' => $sql = "SELECT *,UNIX_TIMESTAMP(date) AS unixdate, display " . "FROM {$_TABLES['polltopics']} WHERE 1=1", 'query_fields' => array('topic'), 'default_filter' => COM_getPermSQL(), 'query' => '', 'query_limit' => 0); $retval .= ADMIN_list('polls', 'plugin_getListField_polls', $header_arr, $text_arr, $query_arr, $defsort_arr); } return $retval; }
function MG_displaySessions() { global $_CONF, $_MG_CONF, $_TABLES, $LANG_MG01; $retval = ''; $T = new Template($_MG_CONF['template_path']); $T->set_file('sessions', 'sessions.thtml'); $T->set_var(array('site_url' => $_CONF['site_url'], 'xhtml' => XHTML, 's_form_action' => $_MG_CONF['admin_url'] . 'sessions.php', 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_delete' => $LANG_MG01['delete'], 'lang_select' => $LANG_MG01['select'], 'lang_checkall' => $LANG_MG01['check_all'], 'lang_uncheckall' => $LANG_MG01['uncheck_all'], 'lang_session_description' => $LANG_MG01['description'], 'lang_session_owner' => $LANG_MG01['owner'], 'lang_session_count' => $LANG_MG01['count'], 'lang_action' => $LANG_MG01['action'])); $T->set_block('sessions', 'sessItems', 'sItems'); $sql = "SELECT * FROM {$_TABLES['mg_sessions']} WHERE session_status=1"; $result = DB_query($sql); $numRows = DB_numRows($result); $rowclass = 0; if ($numRows == 0) { // we have no active sessions $T->set_var('lang_no_sessions', $LANG_MG01['no_sessions']); $T->set_var('noitems', true); $T->set_var('sItems', ''); } else { $totalSess = $numRows; $T->set_block('sessions', 'sessRow', 'sRow'); for ($x = 0; $x < $numRows; $x++) { $row = DB_fetchArray($result); $res2 = DB_query("SELECT COUNT(id) FROM {$_TABLES['mg_session_items']} " . "WHERE session_id='" . $row['session_id'] . "' AND status=0"); list($count) = DB_fetchArray($res2); $T->set_var(array('row_class' => $rowclass % 2 ? '2' : '1', 'session_id' => $row['session_id'], 'session_owner' => DB_getItem($_TABLES['users'], 'username', "uid={$row['session_uid']}"), 'session_description' => $row['session_description'], 'session_continue' => $_MG_CONF['site_url'] . '/batch.php?mode=continue&sid=' . $row['session_id'] . '&limit=0', 'count' => $count)); $T->parse('sRow', 'sessRow', true); $rowclass++; } $T->parse('sItems', 'sessItems'); } $retval .= $T->finish($T->parse('output', 'sessions')); return $retval; }
function goDispAppend() { $t = new Template('../template/basic'); $t->set_file('f', 'tb_produre_b_detail.html'); $t->set_block('f', 'gender', 'g'); if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); $t->set_var('createtime', date("Y-m-d H:i:s")); $t->set_var('userid', $this->getUid()); } else { $updid = $_GET[MODIFY . 'id'] + 0; $t->set_var($this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'produre WHERE produre_id = ' . $updid)); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); echo 'SELECT * FROM ' . WEB_ADMIN_TABPOX . 'produre WHERE produre_id = ' . $updid; $inrs =& $this->dbObj->Execute('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'produre WHERE produre_id = ' . $updid); while ($inrrs =& $inrs->FetchRow()) { $t->set_var($inrrs); } $inrs->Close(); } $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function goDispAppend() { $t = new Template('../template/basic'); $t->set_file('f', 'servicecategory_detail.html'); $t->unknowns = "move"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); $t->set_var('category_name', ""); $t->set_var('error', ""); $t->set_var('showeditdiv', ""); $t->set_var('memo', ""); $t->set_var('userid', $this->getUid()); } else { $updid = $_GET[MODIFY . 'id'] + 0; $t->set_var($this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'servicecategory WHERE category_id = ' . $updid)); $t->set_var('error', ""); $t->set_var('showeditdiv', ""); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); $inrs =& $this->dbObj->Execute('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'servicecategory WHERE category_id = ' . $updid); while ($inrrs =& $inrs->FetchRow()) { $t->set_var($inrrs); } $inrs->Close(); } $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function fncview($uid, $template) { $pi_name = "userbox"; global $_CONF; global $LANG_USERBOX_ADMIN; //template フォルダ $tmplfld = DATABOX_templatePath('admin', 'default', $pi_name); $tmpl = new Template($tmplfld); $tmpl->set_file(array('view' => 'view.thtml')); //-- $tmpl->set_var('site_admin_url', $_CONF['site_admin_url']); if ($template === "") { $tmpl->set_var('about_thispage', $LANG_USERBOX_ADMIN['about_admin_view']); } else { $tmpl->set_var('about_thispage', ""); } $tmpl->parse('output', 'view'); $view = $tmpl->finish($tmpl->get_var('output')); $information = array(); $retval = userbox_profile($uid, $template, "", "view"); $layout = $retval['layout']; $information['headercode'] = $retval['headercode']; $information['pagetitle'] = $retval['title']; $display = $view; $display .= $retval['display']; $display = DATABOX_displaypage($pi_name, $layout, $display, $information); COM_output($display); }
function disp() { //定义模板 $t = new Template('../template/getdata'); $t->set_file('f', 'getcard.html'); $t->unknowns = "keep"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $t->set_block('f', 'mainlist', 'ml'); $category = $_GET["category"]; $keywords = $_GET["keywords"]; $ftable = $_GET["ftable"]; $condition = ''; if ($category != '' && $keywords != '') { if ($ftable == '') { $condition = $category . ' like "%' . $keywords . '%"'; } else { $condition = $category . ' like " %' . $keywords . '%"'; } } $pageid = $_GET[pageid]; $pageid = $pageid ? $pageid : 1; $pageid = intval($pageid); $psize = $this->getValue('pagesize'); $psize = $psize ? $psize : 20; $offset = $pageid > 0 ? ($pageid - 1) * $psize : 0; //设置分类 $t->set_var('ml'); if ($condition != '' && $ftable == '') { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard where marketingcardtype_id in(1,2,3,4,5,6,7) and agencyid =' . $_SESSION["currentorgan"] . ' and ' . $condition; } else { if ($ftable != '') { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard p INNER JOIN ' . WEB_ADMIN_TABPOX . "{$ftable} f on p.categoryid =f.category_id where f.category_name like '%" . $keywords . "%' and p.agencyid =" . $_SESSION["currentorgan"]; } else { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard where marketingcardtype_id in(1,2,3,4,5,6,7) and agencyid =' . $_SESSION["currentorgan"]; } } $inrs =& $this->dbObj->Execute($sql . " ORDER BY marketingcard_id DESC LIMIT " . $offset . " , " . $psize); $result =& $this->dbObj->Execute($sql); $count = $result->RecordCount(); $t->set_var('pagelist', $this->page("?category=" . $category . "&keywords=" . urlencode($keywords) . "&ftable=" . $ftable, $count, $psize, $pageid)); $t->set_var('recordcount', $count); $t->set_var('cardtypelist', $this->selectlist('marketingcardtype', 'marketingcardtype_id', 'marketingcardtype_name', $_GET['marketingcardtype_id'])); while ($inrrs =& $inrs->FetchRow()) { $t->set_var($inrrs); $t->set_var('gender', $inrrs["genderid"] == 1 ? '男' : '女'); $t->set_var('brand_name', $this->dbObj->getone('select brand_name from ' . WEB_ADMIN_TABPOX . 'brand where brand_id =' . $inrrs["brandid"])); $t->set_var('standardunit', $this->dbObj->getone('select unit_name from ' . WEB_ADMIN_TABPOX . 'unit where unit_id =' . $inrrs["standardunit"])); //$t -> set_var('category_name',$this -> dbObj -> getone('select category_name from '.WEB_ADMIN_TABPOX.'procatalog where category_id ='.$inrrs["categoryid"])); $t->set_var('marketingcardtype_name', $this->dbObj->getone('select marketingcardtype_name from ' . WEB_ADMIN_TABPOX . 'marketingcardtype where marketingcardtype_id =' . $inrrs["marketingcardtype_id"])); $t->parse('ml', 'mainlist', true); } $inrs->Close(); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function forum_admin_list() { global $_TABLES, $LANG_ADMIN, $LANG_GF00, $LANG_GF91, $LANG_GF06, $_CONF, $_FF_CONF; USES_lib_admin(); $retval = ''; $selected = ''; $menu_arr = array(); $admin_list = new Template($_CONF['path'] . 'plugins/forum/templates/admin/'); $admin_list->set_file('admin-list', 'index.thtml'); $admin_list->set_var('block_start', COM_startBlock($LANG_GF91['gfstats'])); $menu_arr = FF_adminNav($LANG_GF06['1']); $admin_list->set_var('admin_menu', ADMIN_createMenu($menu_arr, $LANG_GF00['instructions'], $_CONF['site_url'] . '/forum/images/forum.png')); // CATEGORIES $numcats = DB_query("SELECT id FROM {$_TABLES['ff_categories']}"); $totalcats = DB_numRows($numcats); // FORUMS $numforums = DB_query("SELECT forum_id FROM {$_TABLES['ff_forums']}"); $totalforums = DB_numRows($numforums); // TOPICS $numtopics = DB_query("SELECT id FROM {$_TABLES['ff_topic']} WHERE pid = 0"); $totaltopics = DB_numRows($numtopics); // POSTS $numposts = DB_query("SELECT id FROM {$_TABLES['ff_topic']}"); $totalposts = DB_numRows($numposts); // VIEWS $numviews = DB_query("SELECT SUM(views) AS TOTAL FROM {$_TABLES['ff_topic']}"); $totalviews = DB_fetchArray($numviews); // AVERAGE POSTS if ($totalposts != 0) { $avgcposts = $totalposts / $totalcats; $avgcposts = round($avgcposts); $avgfposts = $totalposts / $totalforums; $avgfposts = round($avgfposts); $avgtposts = $totalposts / $totaltopics; $avgtposts = round($avgtposts); } else { $avgcposts = 0; $avgfposts = 0; $avgtposts = 0; } // AVERAGE VIEWS if ($totalviews['TOTAL'] != 0) { $avgcviews = $totalviews['TOTAL'] / $totalcats; $avgcviews = round($avgcviews); $avgfviews = $totalviews['TOTAL'] / $totalforums; $avgfviews = round($avgfviews); $avgtviews = $totalviews['TOTAL'] / $totaltopics; $avgtviews = round($avgtviews); } else { $avgcviews = 0; $avgfviews = 0; $avgtviews = 0; } $admin_list->set_var(array('statsmsg' => $LANG_GF91['statsmsg'], 'totalcatsmsg' => $LANG_GF91['totalcats'], 'totalcats' => $totalcats, 'totalforumsmsg' => $LANG_GF91['totalforums'], 'totalforums' => $totalforums, 'totaltopicsmsg' => $LANG_GF91['totaltopics'], 'totaltopics' => $totaltopics, 'totalpostsmsg' => $LANG_GF91['totalposts'], 'totalposts' => $totalposts, 'totalviewsmsg' => $LANG_GF91['totalviews'], 'totalviews' => $totalviews['TOTAL'], 'category' => $LANG_GF91['category'], 'forum' => $LANG_GF91['forum'], 'topic' => $LANG_GF91['topic'], 'avgpmsg' => $LANG_GF91['avgpmsg'], 'avgcposts' => $avgcposts, 'avgfposts' => $avgfposts, 'avgtposts' => $avgtposts, 'avgvmsg' => $LANG_GF91['avgvmsg'], 'avgcviews' => $avgcviews, 'avgfviews' => $avgfviews, 'avgtviews' => $avgtviews)); $admin_list->set_var('block_end', COM_endBlock()); $admin_list->parse('output', 'admin-list'); $retval .= $admin_list->finish($admin_list->get_var('output')); return $retval; }
function goDispAppend() { $t = new Template('../template/customer'); $t->set_file('f', 'fixedassets_detail.html'); $t->unknowns = "move"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); $t->set_var('customer_id', ""); $t->set_var('customer_name', ''); $t->set_var('man', ""); $t->set_var('content', ""); $t->set_var('handphone', ""); $t->set_var('visitedate', date("Y-m-d")); $t->set_var('title', ""); $t->set_var('error', ""); $t->set_var('showeditdiv', ""); $t->set_var('memo', ""); $t->set_var('userid', $this->getUid()); $t->set_var('picurl', "暂时没有照片"); $t->set_var('birthday', date("Y-m-d")); $t->set_var('updid', ""); //$t -> set_var('vistietypelist',$this->selectlist('visitetype','visitetype_id','visitetype_name',"")); } else { $updid = $_GET[MODIFY . 'id'] + 0; $data = $this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'fixedassets WHERE fixedassets_id = ' . $updid); $t->set_var($data); if ($data['picpath'] == '') { $t->set_var('picurl', "暂时没有照片"); } else { $t->set_var('picurl', "<img src=" . $data['picpath'] . " width=120 height=150 />"); } $t->set_var('ismarrycheck1', $data['ismarry'] == 1 ? 'checked' : ''); $t->set_var('ismarrycheck2', $data['ismarry'] == 2 ? 'checked' : ''); $t->set_var('error', ""); $t->set_var('showeditdiv', ""); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); } //$t -> set_var('brandlist',$this ->selectlist('brand','brand_id','brand_name',$data['brandid'])); //$t -> set_var('genderlist',"111"); //echo $data['genderid']; $t->set_var('genderlist', $this->gender($data['genderid'])); //$t -> set_var('procataloglist',$this ->selectlist('procatalog','category_id','category_name',$data['categoryid'])); //$t -> set_var('unitlist',$this ->selectlist('unit','unit_id','unit_name',$data['standardunit'])); //$t -> set_var('viceunitlist',$this ->selectlist('unit','unit_id','unit_name',$data['viceunit'])); $t->set_var('vistietypelist', $this->selectlist('visitetype', 'visitetype_id', 'visitetype_name', $data['visitetypeid'])); $t->set_var('satisfactionlist', $this->selectlist('satisfaction', 'satisfaction_id', 'satisfaction_name', $data['satisfactionid'])); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function MG_editAVDefaults() { global $_CONF, $_MG_CONF, $_TABLES, $_USER, $LANG_MG07, $LANG_MG01, $LANG_MG03, $LANG_ACCESS, $LANG_DIRECTION; global $glversion, $LANG04; $retval = ''; $T = new Template($_MG_CONF['template_path'] . '/admin'); $T->set_file(array('admin' => 'editavdefaults.thtml')); $T->set_var('site_url', $_MG_CONF['site_url']); require_once $_CONF['path_system'] . 'classes/navbar.class.php'; $navbar = new navbar(); $navbar->add_menuitem($LANG_MG07['wmp_options'], 'showhideMGAdminEditorDiv("wmp",0);return false;', true); $navbar->add_menuitem($LANG_MG07['qt_options'], 'showhideMGAdminEditorDiv("qt",1);return false;', true); $navbar->add_menuitem($LANG_MG07['mp3_options'], 'showhideMGAdminEditorDiv("mp3",2);return false;', true); $navbar->add_menuitem($LANG_MG07['swf_options'], 'showhideMGAdminEditorDiv("flash",3);return false;', true); $navbar->set_selected($LANG_MG07['wmp_options']); $T->set_var('navbar', $navbar->generate()); $T->set_var('no_javascript_warning', $LANG04[150]); // ui mode select $asf_uimode_select = '<select name="asf_uimode">'; $asf_uimode_select .= '<option value="none" ' . ($_MG_CONF['asf_uimode'] == 'none' ? ' selected="selected"' : '') . '>' . $LANG_MG07['none'] . '</option>'; $asf_uimode_select .= '<option value="mini" ' . ($_MG_CONF['asf_uimode'] == 'mini' ? ' selected="selected"' : '') . '>' . $LANG_MG07['mini'] . '</option>'; $asf_uimode_select .= '<option value="full" ' . ($_MG_CONF['asf_uimode'] == 'full' ? ' selected="selected"' : '') . '>' . $LANG_MG07['full'] . '</option>'; $asf_uimode_select .= '</select>'; $mov_scale_select = '<select name="mov_scale">'; $mov_scale_select .= '<option value="tofit" ' . ($_MG_CONF['mov_scale'] == 'tofit' ? ' selected="selected"' : '') . '>' . $LANG_MG07['to_fit'] . '</option>'; $mov_scale_select .= '<option value="aspect" ' . ($_MG_CONF['mov_scale'] == 'aspect' ? ' selected="selected"' : '') . '>' . $LANG_MG07['aspect'] . '</option>'; $mov_scale_select .= '<option value="1" ' . ($_MG_CONF['mov_scale'] == '1' ? ' selected="selected"' : '') . '>' . $LANG_MG07['normal_size'] . '</option>'; $mov_scale_select .= '</select>'; $mp3_uimode_select = '<select name="mp3_uimode">'; $mp3_uimode_select .= '<option value="none" ' . ($_MG_CONF['mp3_uimode'] == 'none' ? ' selected="selected"' : '') . '>' . $LANG_MG07['none'] . '</option>'; $mp3_uimode_select .= '<option value="mini" ' . ($_MG_CONF['mp3_uimode'] == 'mini' ? ' selected="selected"' : '') . '>' . $LANG_MG07['mini'] . '</option>'; $mp3_uimode_select .= '<option value="full" ' . ($_MG_CONF['mp3_uimode'] == 'full' ? ' selected="selected"' : '') . '>' . $LANG_MG07['full'] . '</option>'; $mp3_uimode_select .= '</select>'; $swf_quality_select = '<select name="swf_quality">'; $swf_quality_select .= '<option value="low" ' . ($_MG_CONF['swf_quality'] == 'low' ? ' selected="selected"' : '') . '>' . $LANG_MG07['low'] . '</option>'; $swf_quality_select .= '<option value="high" ' . ($_MG_CONF['swf_quality'] == 'high' ? ' selected="selected"' : '') . '>' . $LANG_MG07['high'] . '</option>'; $swf_quality_select .= '</select>'; $swf_scale_select = '<select name="swf_scale">'; $swf_scale_select .= '<option value="showall" ' . ($_MG_CONF['swf_scale'] == 'showall' ? ' selected="selected"' : '') . '>' . $LANG_MG07['showall'] . '</option>'; $swf_scale_select .= '<option value="noborder" ' . ($_MG_CONF['swf_scale'] == 'noborder' ? ' selected="selected"' : '') . '>' . $LANG_MG07['noborder'] . '</option>'; $swf_scale_select .= '<option value="exactfit" ' . ($_MG_CONF['swf_scale'] == 'exactfit' ? ' selected="selected"' : '') . '>' . $LANG_MG07['exactfit'] . '</option>'; $swf_scale_select .= '</select>'; $swf_wmode_select = '<select name="swf_wmode">'; $swf_wmode_select .= '<option value="window" ' . ($_MG_CONF['swf_wmode'] == 'window' ? ' selected="selected"' : '') . '>' . $LANG_MG07['window'] . '</option>'; $swf_wmode_select .= '<option value="opaque" ' . ($_MG_CONF['swf_wmode'] == 'opaque' ? ' selected="selected"' : '') . '>' . $LANG_MG07['opaque'] . '</option>'; $swf_wmode_select .= '<option value="transparent" ' . ($_MG_CONF['swf_wmode'] == 'transparent' ? ' selected="selected"' : '') . '>' . $LANG_MG07['transparent'] . '</option>'; $swf_wmode_select .= '</select>'; $swf_asa_select = '<select name="swf_allowscriptaccess">'; $swf_asa_select .= '<option value="always" ' . ($_MG_CONF['swf_allowscriptaccess'] == 'always' ? ' selected="selected"' : '') . '>' . $LANG_MG07['always'] . '</option>'; $swf_asa_select .= '<option value="sameDomain" ' . ($_MG_CONF['swf_allowscriptaccess'] == 'sameDomain' ? ' selected="selected"' : '') . '>' . $LANG_MG07['sameDomain'] . '</option>'; $swf_asa_select .= '<option value="never" ' . ($_MG_CONF['swf_allowscriptaccess'] == 'never' ? ' selected="selected"' : '') . '>' . $LANG_MG07['never'] . '</option>'; $swf_asa_select .= '</select>'; $T->set_var(array('lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 's_form_action' => $_MG_CONF['admin_url'] . 'avdefaults.php', 'lang_asf_options' => $LANG_MG07['wmp_options'], 'lang_mov_options' => $LANG_MG07['qt_options'], 'lang_mp3_options' => $LANG_MG07['mp3_options'], 'lang_swf_options' => $LANG_MG07['swf_options'], 'lang_playcount' => $LANG_MG07['playcount'], 'lang_playcount_help' => $LANG_MG07['playcount_help'], 'lang_option' => $LANG_MG07['option'], 'lang_description' => $LANG_MG07['description'], 'lang_on' => $LANG_MG07['on'], 'lang_off' => $LANG_MG07['off'], 'lang_auto_start' => $LANG_MG07['auto_start'], 'lang_auto_start_help' => $LANG_MG07['auto_start_help'], 'lang_enable_context_menu' => $LANG_MG07['enable_context_menu'], 'lang_enable_context_menu_help' => $LANG_MG07['enable_context_menu_help'], 'lang_stretch_to_fit' => $LANG_MG07['stretch_to_fit'], 'lang_stretch_to_fit_help' => $LANG_MG07['stretch_to_fit_help'], 'lang_status_bar' => $LANG_MG07['status_bar'], 'lang_status_bar_help' => $LANG_MG07['status_bar_help'], 'lang_ui_mode' => $LANG_MG07['ui_mode'], 'lang_ui_mode_help' => $LANG_MG07['ui_mode_help'], 'lang_height' => $LANG_MG07['height'], 'lang_width' => $LANG_MG07['width'], 'lang_height_help' => $LANG_MG07['height_help'], 'lang_width_help' => $LANG_MG07['width_help'], 'lang_bgcolor' => $LANG_MG07['bgcolor'], 'lang_bgcolor_help' => $LANG_MG07['bgcolor_help'], 'lang_auto_ref' => $LANG_MG07['auto_ref'], 'lang_auto_ref_help' => $LANG_MG07['auto_ref_help'], 'lang_controller' => $LANG_MG07['controller'], 'lang_controller_help' => $LANG_MG07['controller_help'], 'lang_kiosk_mode' => $LANG_MG07['kiosk_mode'], 'lang_kiosk_mode_help' => $LANG_MG07['kiosk_mode_help'], 'lang_scale' => $LANG_MG07['scale'], 'lang_scale_help' => $LANG_MG07['scale_help'], 'lang_loop' => $LANG_MG07['loop'], 'lang_loop_help' => $LANG_MG07['loop_help'], 'lang_menu' => $LANG_MG07['menu'], 'lang_menu_help' => $LANG_MG07['menu_help'], 'lang_scale' => $LANG_MG07['scale'], 'lang_swf_scale_help' => $LANG_MG07['swf_scale_help'], 'lang_wmode' => $LANG_MG07['wmode'], 'lang_wmode_help' => $LANG_MG07['wmode_help'], 'lang_quality' => $LANG_MG07['quality'], 'lang_quality_help' => $LANG_MG07['quality_help'], 'lang_flash_vars' => $LANG_MG07['flash_vars'], 'lang_asa' => $LANG_MG07['asa'], 'lang_asa_help' => $LANG_MG07['asa_help'], 'lang_bgcolor' => $LANG_MG07['bgcolor'], 'lang_bgcolor_help' => $LANG_MG07['bgcolor_help'], 'lang_clsid' => $LANG_MG07['clsid'], 'lang_codebase' => $LANG_MG07['codebase'], 'lang_swf_version_help' => $LANG_MG07['swf_version_help'], 'asf_autostart_enabled' => $_MG_CONF['asf_autostart'] ? ' checked="checked"' : '', 'asf_autostart_disabled' => $_MG_CONF['asf_autostart'] ? '' : ' checked="checked"', 'asf_enablecontextmenu_enabled' => $_MG_CONF['asf_enablecontextmenu'] ? ' checked="checked"' : '', 'asf_enablecontextmenu_disabled' => $_MG_CONF['asf_enablecontextmenu'] ? '' : ' checked="checked"', 'asf_stretchtofit_enabled' => $_MG_CONF['asf_stretchtofit'] ? ' checked="checked"' : '', 'asf_stretchtofit_disabled' => $_MG_CONF['asf_stretchtofit'] ? '' : ' checked="checked"', 'asf_showstatusbar_enabled' => $_MG_CONF['asf_showstatusbar'] ? ' checked="checked"' : '', 'asf_showstatusbar_disabled' => $_MG_CONF['asf_showstatusbar'] ? '' : ' checked="checked"', 'asf_uimode_select' => $asf_uimode_select, 'asf_uimode' => $_MG_CONF['asf_uimode'], 'asf_playcount' => $_MG_CONF['asf_playcount'], 'asf_height' => $_MG_CONF['asf_height'], 'asf_width' => $_MG_CONF['asf_width'], 'asf_bgcolor' => $_MG_CONF['asf_bgcolor'], 'mov_autoref_enabled' => $_MG_CONF['mov_autoref'] ? ' checked="checked"' : '', 'mov_autoref_disabled' => $_MG_CONF['mov_autoref'] ? '' : ' checked="checked"', 'mov_autoplay_enabled' => $_MG_CONF['mov_autoplay'] ? ' checked="checked"' : '', 'mov_autoplay_disabled' => $_MG_CONF['mov_autoplay'] ? '' : ' checked="checked"', 'mov_controller_enabled' => $_MG_CONF['mov_controller'] ? ' checked="checked"' : '', 'mov_controller_disabled' => $_MG_CONF['mov_controller'] ? '' : ' checked="checked"', 'mov_kioskmode_enabled' => $_MG_CONF['mov_kioskmode'] ? ' checked="checked"' : '', 'mov_kioskmode_disabled' => $_MG_CONF['mov_kioskmode'] ? '' : ' checked="checked"', 'mov_scale_select' => $mov_scale_select, 'mov_loop_enabled' => $_MG_CONF['mov_loop'] ? ' checked="checked"' : '', 'mov_loop_disabled' => $_MG_CONF['mov_loop'] ? '' : ' checked="checked"', 'mov_height' => $_MG_CONF['mov_height'], 'mov_width' => $_MG_CONF['mov_width'], 'mov_bgcolor' => $_MG_CONF['mov_bgcolor'], 'mp3_autostart_enabled' => $_MG_CONF['mp3_autostart'] ? ' checked="checked"' : '', 'mp3_autostart_disabled' => $_MG_CONF['mp3_autostart'] ? '' : ' checked="checked"', 'mp3_enablecontextmenu_enabled' => $_MG_CONF['mp3_enablecontextmenu'] ? ' checked="checked"' : '', 'mp3_enablecontextmenu_disabled' => $_MG_CONF['mp3_enablecontextmenu'] ? '' : ' checked="checked"', 'mp3_showstatusbar_enabled' => $_MG_CONF['mp3_showstatusbar'] ? ' checked="checked"' : '', 'mp3_showstatusbar_disabled' => $_MG_CONF['mp3_showstatusbar'] ? '' : ' checked="checked"', 'mp3_loop_enabled' => $_MG_CONF['mp3_loop'] ? ' checked="checked"' : '', 'mp3_loop_disabled' => $_MG_CONF['mp3_loop'] ? '' : ' checked="checked"', 'mp3_uimode_select' => $mp3_uimode_select, 'mp3_uimode' => $_MG_CONF['mp3_uimode'], 'swf_play_enabled' => $_MG_CONF['swf_play'] ? ' checked="checked"' : '', 'swf_play_disabled' => $_MG_CONF['swf_play'] ? '' : ' checked="checked"', 'swf_menu_enabled' => $_MG_CONF['swf_menu'] ? ' checked="checked"' : '', 'swf_menu_disabled' => $_MG_CONF['swf_menu'] ? '' : ' checked="checked"', 'swf_loop_enabled' => $_MG_CONF['swf_loop'] ? ' checked="checked"' : '', 'swf_loop_disabled' => $_MG_CONF['swf_loop'] ? '' : ' checked="checked"', 'swf_quality_select' => $swf_quality_select, 'swf_scale_select' => $swf_scale_select, 'swf_wmode_select' => $swf_wmode_select, 'swf_asa_select' => $swf_asa_select, 'swf_flashvars' => $_MG_CONF['swf_flashvars'], 'swf_height' => $_MG_CONF['swf_height'], 'swf_width' => $_MG_CONF['swf_width'], 'swf_bgcolor' => $_MG_CONF['swf_bgcolor'], 'swf_codebase' => $_MG_CONF['swf_version'], 'swf_version' => $_MG_CONF['swf_version'], 'rtl' => $LANG_DIRECTION == "rtl" ? "rtl" : "", 'gltoken_name' => CSRF_TOKEN, 'gltoken' => SEC_createToken())); $T->parse('output', 'admin'); $retval .= $T->finish($T->get_var('output')); return $retval; }
function view() { global $_CONF, $_TABLES; $retval = ''; $sql = "SELECT L.tag_id, L.tag, COUNT(m.tag_id) AS cnt, L.hits " . "FROM {$_TABLES['tag_list']} AS L " . "LEFT JOIN {$_TABLES['tag_map']} AS m " . "ON L.tag_id = m.tag_id " . "GROUP BY m.tag_id " . "ORDER BY cnt DESC, tag"; $result = DB_query($sql); if (DB_error()) { return $retval . '<p>' . TAG_str('db_error') . '</p>'; } else { if (DB_numRows($result) == 0) { return $retval . '<p>' . TAG_str('no_tag') . '</p>'; } } $T = new Template($_CONF['path'] . 'plugins/tag/templates'); $T->set_file('stats', 'admin_stats.thtml'); $T->set_var('xhtml', XHTML); $T->set_var('this_script', COM_buildURL($_CONF['site_admin_url'] . '/plugins/tag/index.php')); $T->set_var('lang_desc_admin_stats', TAG_str('desc_admin_stats')); $T->set_var('lang_lbl_tag', TAG_str('lbl_tag')); $T->set_var('lang_lbl_count', TAG_str('lbl_count')); $T->set_var('lang_lbl_hit_count', TAG_str('lbl_hit_count')); $T->set_var('lang_delete_checked', TAG_str('delete_checked')); $T->set_var('lang_ban_checked', TAG_str('ban_checked')); $sw = 1; $body = ''; while (($A = DB_fetchArray($result)) !== false) { $tag_id = $A['tag_id']; $body .= '<tr class="pluginRow' . $sw . '">' . '<td><input id="tag' . TAG_escape($tag_id) . '" name="tag_ids[]" ' . 'type="checkbox" value="' . TAG_escape($A['tag_id']) . '"' . XHTML . '><label for="tag' . TAG_escape($tag_id) . '">' . TAG_escape($A['tag']) . '</label></td>' . '<td style="text-align: right;">' . TAG_escape($A['cnt']) . '</td><td style="text-align: right;">' . TAG_escape($A['hits']) . '</td></tr>' . LB; $sw = $sw == 1 ? 2 : 1; } $T->set_var('body', $body); $T->parse('output', 'stats'); $retval = $T->finish($T->get_var('output')); return $retval; }
function generatenexlistFieldHTML($did, $row) { global $_CONF, $_TABLES; $p = new Template($_CONF['path_layout'] . 'nexlist'); $p->set_file(array('fields' => 'definition_fields.thtml', 'field_rec' => 'definition_field_record.thtml')); $p->set_var('definition_id', $did); $p->set_var('rowid', $row); $sql = "SELECT * FROM {$_TABLES['nexlistfields']} WHERE lid='{$did}' ORDER BY id"; $FLD_query = DB_Query($sql); $numfields = DB_numrows($FLD_query); if ($numfields > 0) { $j = 1; $p->set_var('show_fields', ''); while ($FLD = DB_fetchArray($FLD_query, false)) { $edit_link = " [<a href=\"#\" onClick='editListField({$row},{$j});'>Edit</a> ]"; $del_link = " [<a href=\"#\" onClick='ajaxUpdateDefinition(\"deleteField\",{$row},{$j});'\">Delete</a> ]"; $p->set_var('field_recid', $FLD['id']); $p->set_var('field_name', $FLD['fieldname']); $p->set_var('field_value', $FLD['value_by_function']); $p->set_var('field_width', $FLD['width']); $p->set_var('field_id', $j); $p->set_var('edit_link', $edit_link); $p->set_var('delete_link', $del_link); if ($FLD['predefined_function'] == 1) { $checked = 'CHECKED'; $display_ftext = 'none'; $display_fddown = ''; $p->set_var('function_dropdown_options', nexlist_getCustomListFunctionOptions($FLD['value_by_function'])); } else { $checked = ''; $display_ftext = ''; $display_fddown = 'none'; $p->set_var('function_dropdown_options', nexlist_getCustomListFunctionOptions()); } $p->set_var('checked', $checked); $p->set_var('display_ftext', $display_ftext); $p->set_var('display_fddown', $display_fddown); if ($j == 1) { $p->parse('definition_field_records', 'field_rec'); } else { $p->parse('definition_field_records', 'field_rec', true); } $j++; } $p->parse('definition_fields', 'fields'); } else { $p->set_var('show_fields', 'none'); $p->set_var('definition_field_records', ''); } $p->parse('output', 'fields'); $html = $p->finish($p->get_var('output')); $html = htmlentities($html); return $html; }
function disp() { //定义模板 $template = $_GET["template"] == '' ? "getstaff" : $_GET["template"]; $t = new Template('../template/getdata'); $t->set_file('f', $template . '.html'); $t->unknowns = "keep"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $t->set_block('f', 'mainlist', 'ml'); $keywords = $_GET["keywords"]; $parameter = $_GET["parameter"]; $parameter = explode("@@@", $parameter); $keywords = explode("@@@", $keywords); $condition = ''; for ($i = 0; $i < count($parameter); $i++) { if ($parameter[$i] != '') { $condition = $condition == '' ? 'A.' . $parameter[$i] . ' in (' . $keywords[$i] . ')' : $condition . " and A." . $parameter[$i] . ' in (' . $keywords[$i] . ')'; $condition1 = $condition == '' ? $parameter[$i] . ' in (' . $keywords[$i] . ')' : $condition . " and " . $parameter[$i] . 'in (' . $keywords[$i] . ')'; } } $pageid = $_GET[pageid]; $pageid = $pageid ? $pageid : 1; $pageid = intval($pageid); $psize = $this->getValue('pagesize'); $psize = $psize ? $psize : 20; $offset = $pageid > 0 ? ($pageid - 1) * $psize : 0; //设置分类 $t->set_var('ml'); if ($condition != '' && $ftable == '') { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard A INNER JOIN ' . WEB_ADMIN_TABPOX . 'marketingcardtype B ON A.marketingcardtype_id=B.marketingcardtype_id where A.agencyid =' . $_SESSION["currentorgan"] . ' and ' . $condition; } else { if ($ftable != '') { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard p INNER JOIN ' . WEB_ADMIN_TABPOX . "{$ftable} f on p.categoryid =f.category_id where f.category_name like '%" . $keywords . "%' and p.agencyid =" . $_SESSION["currentorgan"]; } else { $sql = 'select * from ' . WEB_ADMIN_TABPOX . 'marketingcard A INNER JOIN ' . WEB_ADMIN_TABPOX . 'marketingcardtype B ON A.marketingcardtype_id=B.marketingcardtype_id where A.agencyid =' . $_SESSION["currentorgan"]; } } $inrs =& $this->dbObj->Execute($sql . " ORDER BY price DESC LIMIT " . $offset . " , " . $psize); $result =& $this->dbObj->Execute($sql); $count = $result->RecordCount(); $t->set_var('pagelist', $this->page("?template=" . $template . "¶meter=" . $parameter . "&keywords=" . urlencode($keywords), $count, $psize, $pageid)); $t->set_var('recordcount', $count); while ($inrrs =& $inrs->FetchRow()) { $t->set_var($inrrs); $t->set_var('employee_id', $inrrs['employee_id']); $t->set_var('employee_name', $inrrs['employee_name']); $t->set_var('gender', $inrrs["genderid"] == 1 ? '男' : '女'); $t->set_var('category_name', $this->dbObj->getone('select category_name from ' . WEB_ADMIN_TABPOX . 'procatalog where category_id =' . $inrrs["categoryid"])); $t->parse('ml', 'mainlist', true); } $inrs->Close(); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function MG_quotaReport($page, $quotaquery, $usedquery) { global $_TABLES, $_MG_CONF, $_CONF, $LANG_MG01, $LANG_MG03; $counter = 0; $rowcounter = 1; $retval = ''; $start = $page * 50; $end = 50; $T = new Template($_MG_CONF['template_path'] . '/admin'); $T->set_file(array('report' => 'quotareport.thtml')); $retval .= COM_startBlock('', '', COM_getBlockTemplate('_admin_block', 'header')); $T->set_var(array('lang_username' => $LANG_MG01['username'], 'lang_active' => $LANG_MG01['active'], 'lang_quota' => $LANG_MG01['quota'], 'lang_used' => $LANG_MG01['used'])); $T->set_block('report', 'UserRow', 'uRow'); if ($quotaquery > 0) { $quotaselect = $quotaquery * 1048676; } else { $quotaselect = 0; } $tres = DB_query("SELECT COUNT(gl.uid) AS count FROM {$_TABLES['users']} AS gl LEFT JOIN {$_TABLES['mg_userprefs']} AS mg ON gl.uid=mg.uid WHERE gl.status = 3 AND gl.uid > 2 AND mg.member_gallery=1 AND mg.quota >= " . $quotaselect); $trow = DB_fetchArray($tres); $total_records = $trow['count']; $sql = "SELECT gl.uid, gl.status, gl.username, gl.fullname, mg.member_gallery, mg.quota FROM {$_TABLES['users']} AS gl LEFT JOIN {$_TABLES['mg_userprefs']} AS mg ON gl.uid=mg.uid WHERE gl.status = 3 AND gl.uid > 2 AND mg.member_gallery=1 AND mg.quota >= " . $quotaselect . " ORDER BY gl.username ASC LIMIT {$start},{$end}"; $result = DB_query($sql); while ($userRow = DB_fetchArray($result)) { $uid = $userRow['uid']; $quota_mb = MG_getUserQuota($uid) / 1048676; $quota = number_format($quota_mb, 2); $used_mb = (double) MG_quotaUsage($uid) / 1048576; $used = number_format($used_mb, 2); if ($quotaquery > 0) { // limit based on quota if ($quota_mb >= $quotaquery) { $show = 1; } else { $show = 0; } } else { $show = 1; } if ($show) { $T->set_var(array('result_row' => $rowcounter, 'rowclass' => $rowcounter % 2 ? '2' : '1', 'username' => '<a href="' . $_MG_CONF['admin_url'] . 'edituser.php?uid=' . $uid . '">' . $userRow['username'] . " (" . $userRow['fullname'] . ")</a>", 'uid' => $uid, 'quota' => $quota == 0 ? 'Unlimited' : $quota, 'used' => $used, 'active' => MG_getUserActive($uid))); $T->parse('uRow', 'UserRow', true); $rowcounter++; $counter++; } } $T->set_var(array('site_admin_url' => $_MG_CONF['admin_url'], 'used' => $usedquery, 'quota' => $quotaquery, 'lang_go' => $LANG_MG03['go'], 'lang_quota' => $LANG_MG01['quota'], 'lang_used' => $LANG_MG01['used'], 'lang_batch_update' => $LANG_MG01['batch_quota_update'], 'lang_update' => $LANG_MG01['update'], 'pagenav' => COM_printPageNavigation($_MG_CONF['admin_url'] . 'quotareport.php', $page + 1, ceil($total_records / 50)))); $T->parse('output', 'report'); $retval .= $T->finish($T->get_var('output')); $retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer')); return $retval; }
function MG_quotaConfirm() { global $_MG_CONF, $_CONF, $LANG_MG01; $retval = ''; $B = new Template($_MG_CONF['template_path']); $B->set_file('admin', 'quotaconfirm.thtml'); $B->set_var('site_url', $_CONF['site_url']); $B->set_var('site_admin_url', $_CONF['site_admin_url']); $B->set_var(array('lang_title' => $LANG_MG01['rebuild_quota'], 's_form_action' => $_MG_CONF['admin_url'] . 'quota.php?mode=rebuild', 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_details' => $LANG_MG01['rebuild_quota_help'])); $B->parse('output', 'admin'); $retval .= $B->finish($B->get_var('output')); return $retval; }
function MG_massDelete() { global $MG_albums, $_USER, $_CONF, $_TABLES, $_MG_CONF, $LANG_MG00, $LANG_MG01; $retval = ''; $T = new Template($_MG_CONF['template_path'] . '/admin'); $T->set_file('admin', 'massdelete.thtml'); $T->set_var('site_url', $_CONF['site_url']); $T->set_var('site_admin_url', $_CONF['site_admin_url']); $T->set_var(array('album_list' => $MG_albums[0]->showSelectTree(0), 's_form_action' => $_MG_CONF['admin_url'] . 'massdelete.php', 'lang_save' => $LANG_MG01['save'], 'lang_cancel' => $LANG_MG01['cancel'], 'lang_reset' => $LANG_MG01['reset'], 'lang_delete_confirm' => $LANG_MG01['delete_item_confirm'], 'lang_delete' => $LANG_MG01['delete'])); $T->parse('output', 'admin'); $retval .= $T->finish($T->get_var('output')); return $retval; }
function goDispAppend() { $t = new Template('../template/customer'); $t->set_file('f', 'messagerecord_detail.html'); $t->unknowns = "move"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); $t->set_var('customer_id', ""); $t->set_var('customer_name', ""); $t->set_var('employee_id', ""); $t->set_var('man', ""); $t->set_var('title', ""); $t->set_var('content', ""); $t->set_var('senddate', date("Y-m-d")); $t->set_var('address', ""); $t->set_var('showeditdiv', ""); $t->set_var('handphone', ""); $t->set_var('userid', $this->getUid()); } else { $updid = $_GET[MODIFY . 'id'] + 0; $data = $this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'messagerecord WHERE messagerecord_id = ' . $updid); $t->set_var($data); $t->set_var('ismarrycheck1', $data['ismarry'] == 1 ? 'checked' : ''); $t->set_var('ismarrycheck2', $data['ismarry'] == 2 ? 'checked' : ''); $t->set_var('error', ""); $t->set_var('showeditdiv', ""); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); } if ($date['state'] == 1) { $t->set_var('state', '<input id="state" type="radio" checked="checked" value="1" name="state" /><label for="state">可用</label><input id="state" type="radio" value="0" name="state" /><label for="state">停用</label>'); } else { $t->set_var('state', '<input id="state" type="radio" value="1" name="state" /><label for="state_0">可用</label><input id="state" type="radio" value="0" checked="checked" name="state" /><label for="state">停用</label>'); } //$t -> set_var('brandlist',$this ->selectlist('brand','brand_id','brand_name',$data['brandid'])); //$t -> set_var('genderlist',"111"); //echo $data['genderid']; $t->set_var('genderlist', $this->gender($data['genderid'])); //$t -> set_var('procataloglist',$this ->selectlist('procatalog','category_id','category_name',$data['categoryid'])); //$t -> set_var('unitlist',$this ->selectlist('unit','unit_id','unit_name',$data['standardunit'])); //$t -> set_var('viceunitlist',$this ->selectlist('unit','unit_id','unit_name',$data['viceunit'])); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function view() { global $_CONF, $_TABLES; $body = ''; $T = new Template($_CONF['path'] . 'plugins/tag/templates'); $T->set_file('badword', 'admin_badword.thtml'); $T->set_var('xhtml', XHTML); $T->set_var('this_script', COM_buildURL($_CONF['site_admin_url'] . '/plugins/tag/index.php')); $T->set_var('lang_desc_admin_badword', TAG_str('desc_admin_badword')); $T->set_var('lang_add', TAG_str('add')); $T->set_var('lang_lbl_tag', TAG_str('lbl_tag')); $T->set_var('lang_delete_checked', TAG_str('delete_checked')); $sql = "SELECT * FROM {$_TABLES['tag_badwords']}"; $result = DB_query($sql); if (DB_error()) { return $retval . '<p>' . TAG_str('db_error') . '</p>'; } else { if (DB_numRows($result) == 0) { $T->set_var('msg', '<p>' . TAG_str('no_badword') . '</p>'); } else { $sw = 1; while (($A = DB_fetchArray($result)) !== false) { $word = TAG_escape($A['badword']); $body .= '<tr><td>' . '<input id="' . $word . '" name="words[]" type="checkbox" ' . 'value="' . $word . '"><label for="' . $word . '">' . $word . '</label></td></tr>' . LB; $sw = $sw == 1 ? 2 : 1; } } } $T->set_var('body', $body); $T->parse('output', 'badword'); $retval = $T->finish($T->get_var('output')); return $retval; }
function goDispAppend() { $t = new Template('../template/system'); $t->set_file('f', 'userdetail.html'); $t->set_block('f', 'group', 'g'); $groupArr = array(); if ($this->isAppend) { $t->set_var('action', 'add'); $t->set_var('actionName', '增加'); } else { $updid = $_GET[MODIFY . 'id'] + 0; $t->set_var($this->dbObj->GetRow('SELECT * FROM ' . WEB_ADMIN_TABPOX . 'user WHERE userid = ' . $updid)); $t->set_var('updid', $updid); $t->set_var('action', 'upd'); $t->set_var('actionName', '修改'); $gs = $this->dbObj->GetArray('SELECT groupid FROM ' . WEB_ADMIN_TABPOX . 'usergroup WHERE userid = ' . $updid); foreach ($gs as $v) { $groupArr[] = $v['groupid']; } } //当前用户所管理的组 $umgs = '0'; //echo 'select agency_type id from '.WEB_ADMIN_TABPOX.'agency a inner join '.WEB_ADMIN_TABPOX.'user u on a.agency_id=u.agencyid where u.userid='.$this->getUid(); $agency_type_id =& $this->dbObj->GetOne('select agencytype id from ' . WEB_ADMIN_TABPOX . 'agency a inner join ' . WEB_ADMIN_TABPOX . 'user u on a.agency_id=u.agencyid where u.userid=' . $this->getUid()); //echo $agency_type_id; //'select g.groupid from '.WEB_ADMIN_TABPOX.'groupmanager g inner join '.WEB_ADMIN_TABPOX.'user u on g.userid=u.userid where u.agencyid='.$_SESSION["currentorgan"] if ($agency_type_id == 1) { $mgs =& $this->dbObj->Execute('select groupid from ' . WEB_ADMIN_TABPOX . 'group where agencyid=' . $_SESSION["currentorgan"]); } else { $mgs =& $this->dbObj->Execute('select groupid from ' . WEB_ADMIN_TABPOX . 'groupmanager where userid=' . $this->getUid()); } while (!$mgs->EOF) { $umgs .= ',' . $mgs->fields['groupid']; $mgs->MoveNext(); } //设置组列表 $rs =& $this->dbObj->Execute("select * from " . WEB_ADMIN_TABPOX . 'group where groupid in(' . $umgs . ')'); while ($rrs =& $rs->FetchRow()) { $t->set_var($rrs); if (in_array($rrs['groupid'], $groupArr)) { $t->set_var('gchecked', ' checked'); } else { $t->set_var('gchecked', ''); } $t->parse('g', 'group', true); } $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
public static function Selection($order_id, $showlog = 0, $selected = '') { global $LANG_PP, $_PP_CONF; self::Init(); $T = new Template(PAYPAL_PI_PATH . '/templates'); $T->set_file('ordstat', 'orderstatus.thtml'); $T->set_var(array('order_id' => $order_id, 'oldvalue' => $selected, 'showlog' => $showlog == 1 ? 1 : 0)); $T->set_block('ordstat', 'StatusSelect', 'Sel'); foreach ($_PP_CONF['orderstatus'] as $key => $data) { $T->set_var(array('selected' => $key == $selected ? 'selected="selected"' : '', 'stat_key' => $key, 'stat_descr' => isset($LANG_PP['orderstatus'][$key]) ? $LANG_PP['orderstatus'][$key] : $key)); $T->parse('Sel', 'StatusSelect', true); } $T->parse('output', 'ordstat'); return $T->finish($T->get_var('output')); }
function disp() { $t = new Template('../template/stock'); $t->set_file('f', 'initstock.html'); $t->unknowns = "move"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $t->set_var('producecategorylist', $this->selectlist('procatalog', 'category_id', 'category_name', 0)); $t->set_var('warehouselist', $this->selectlist('warehouse', 'warehouse_id', 'warehouse_name', 0)); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }
function disp() { //定义模板 $t = new Template('../template/basic'); $t->set_file('f', 'import.html'); $t->unknowns = "move"; $t->left_delimiter = "[#"; //修改左边界符为[# $t->right_delimiter = "#]"; //修改右边界符#] $fname = $_FILES['MyFile']['name']; $do = copy($_FILES['MyFile']['tmp_name'], $fname); if ($_FILES['MyFile']['name']) { if ($do) { $error = '导入成功,请返回查看'; } else { $error = "导入失败"; } } error_reporting(0); $fname = $_FILES['MyFile']['name']; $handle = fopen($fname, "r"); while ($data = fgetcsv($handle, 10000, ",")) { $this->dbObj->Execute("SET NAMES 'utf8'"); $data[2] = $this->dbObj->getone("SELECT category_id FROM `" . WEB_ADMIN_TABPOX . "procatalog` WHERE category_name='" . $data[2] . "' and agencyid=" . $_SESSION["currentorgan"]); $data[3] = $this->dbObj->getone("SELECT brand_id FROM `" . WEB_ADMIN_TABPOX . "brand` WHERE brand_name='" . $data[3] . "' and agencyid=" . $_SESSION["currentorgan"]); $data[4] = $this->dbObj->getone("SELECT unit_id FROM `" . WEB_ADMIN_TABPOX . "unit` WHERE unit_name='" . $data[4] . "' and agencyid=" . $_SESSION["currentorgan"]); $data[5] = $this->dbObj->getone("SELECT unit_id FROM `" . WEB_ADMIN_TABPOX . "unit` WHERE unit_name='" . $data[5] . "' and agencyid=" . $_SESSION["currentorgan"]); $data[3] = $data[3] == '' ? 0 : $data[3]; $data[4] = $data[4] == '' ? 0 : $data[4]; $data[5] = $data[5] == '' ? 0 : $data[5]; $data[6] = $data[6] == '' ? 0 : $data[6]; $q = "insert into s_produce (`produce_no`,produce_name,`categoryid`, `brandid`, `standardunit`,`viceunit`,`viceunitnumber`, `price`, `upperlimit`, `lowerlimit`, `code`, `shortcode`, `address`, `efficacy`, `useway`, `basis`, memo,agencyid) values ('{$data['0']}','{$data['1']}','{$data['2']}','{$data['3']}','{$data['4']}','{$data['5']}','{$data['6']}','{$data['7']}','{$data['8']}','{$data['9']}','{$data['10']}','{$data['11']}','{$data['12']}','{$data['13']}','{$data['14']}','{$data['15']}','{$data['16']}'," . $_SESSION["currentorgan"] . ")"; $this->dbObj->Execute($q); if (mysql_error()) { $error = '导入失败' . mysql_error(); break; } } fclose($handle); $t->set_var('error', $error); $t->set_var('backpath', 'produce.php'); $t->set_var('format', '编码,名称,类别,品牌,主单位,副单位,容量,牌价,库存上限,下限,代码,简码,产地,功效,用法,成分,备注'); $t->set_var('PHP_SELF', $_SERVER["PHP_SELF"]); $t->set_var('path', WEB_ADMIN_HTTPPATH . '/common/'); $t->parse('out', 'f'); $t->p('out'); }