Example #1
0
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;
}
Example #3
0
 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');
 }
Example #4
0
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;
}
Example #5
0
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;
}
Example #6
0
 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');
 }
Example #7
0
 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');
 }
Example #8
0
 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');
 }
Example #9
0
 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');
 }
Example #10
0
/**
* 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;
}
Example #11
0
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&amp;sid=' . $row['session_id'] . '&amp;limit=0', 'count' => $count));
            $T->parse('sRow', 'sessRow', true);
            $rowclass++;
        }
        $T->parse('sItems', 'sessItems');
    }
    $retval .= $T->finish($T->parse('output', 'sessions'));
    return $retval;
}
Example #12
0
 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');
 }
Example #13
0
 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');
 }
Example #14
0
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);
}
Example #15
0
 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');
 }
Example #16
0
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;
}
Example #17
0
 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');
 }
Example #18
0
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;
}
Example #19
0
 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;
 }
Example #20
0
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 = "&nbsp;[<a href=\"#\" onClick='editListField({$row},{$j});'>Edit</a>&nbsp;]";
            $del_link = "&nbsp;[<a href=\"#\" onClick='ajaxUpdateDefinition(\"deleteField\",{$row},{$j});'\">Delete</a>&nbsp;]";
            $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;
}
Example #21
0
 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 . "&parameter=" . $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');
 }
Example #22
0
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;
}
Example #23
0
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;
}
Example #24
0
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;
}
Example #25
0
 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');
 }
Example #26
0
 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;
 }
Example #27
0
 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');
 }
Example #28
0
 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'));
 }
Example #29
0
 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');
 }
Example #30
0
 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');
 }