* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liubo $
* $Id: index.php 17217 2011-01-19 06:29:08Z liubo $
*/
define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
$_REQUEST['act'] = empty($_REQUEST['act']) ? 'signin' : $_REQUEST['act'];
/*------------------------------------------------------ */
//-- 框架
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'list' || $_REQUEST['act'] == 'signin') {
$admin["admin_name"] = $_SESSION["admin_name"];
$admin["school"] = get_school_name($_SESSION["school_code"]);
$admin["class"] = get_class_name($_SESSION["class_code"]);
$smarty->assign('admin', $admin);
$menus = get_menus_by_status($_SESSION["status_id"]);
//区分角色
$smarty->assign('menus', $menus);
$status = get_status($_SESSION["status_id"]);
$smarty->assign('status', $status);
$smarty->display('index.htm');
} elseif ($_REQUEST['act'] == 'top') {
// 获得管理员设置的菜单
$lst = array();
$nav = $db->GetOne('SELECT nav_list FROM ' . $ecs->table('admin_user') . " WHERE user_id = '" . $_SESSION['admin_id'] . "'");
if (!empty($nav)) {
$arr = explode(',', $nav);
foreach ($arr as $val) {
function license_export($license)
{
$content = "注册码,是否付款,学校,班级,学生,注册时间\n";
foreach ($license as $k => $v) {
$content .= $v['license'] . ',';
$content .= $v['pay_id'] > 0 ? "是," : "否,";
$shool_name = '';
$class_name = '';
$student_name = '';
if ($v['school_code']) {
$shool_name = get_school_name(str_replace("_school", "", $v['school_code']));
if ($v['class_code']) {
$class_name = get_class_name_global($v['school_code'], $v['class_code']);
if ($v['student_id']) {
$student_name = get_student_name_global($v['school_code'], $v['class_code'], $v['student_id']);
}
}
}
$content .= $shool_name . ',';
$content .= $class_name . ',';
$content .= $student_name . ',';
$content .= $v['regtime'] . "\n";
}
$charset = empty($_POST['charset']) ? 'GBK' : trim($_POST['charset']);
//UTF8
$file = ecs_iconv(EC_CHARSET, $charset, $content);
header("Content-Disposition: attachment; filename=license_list.csv");
header("Content-Type: application/unknown");
die($file);
}
/**
* 返回学校管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function schoolAdmin_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
//学校管理员名称
$filter['school_code'] = empty($_REQUEST['school_code']) ? '' : trim($_REQUEST['school_code']);
//学校管理员code
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'user_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$ex_where = ' WHERE status_id=1 ';
//学校管理员 status_id=1
if ($filter['keywords']) {
$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
}
if ($filter['school_code']) {
$ex_where .= " AND school_code = '" . mysql_like_quote($filter['school_code']) . "'";
}
$filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('admin_user') . $ex_where);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table('admin_user') . $ex_where . " ORDER by " . $filter['sort_by'] . ' ' . $filter['sort_order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
$filter['keywords'] = stripslashes($filter['keywords']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$schoolAdmin_list = $GLOBALS['db']->getAll($sql);
foreach ($schoolAdmin_list as $key => $val) {
$schoolAdmin_list[$key]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $val['add_time']);
$schoolAdmin_list[$key]['last_login'] = local_date($GLOBALS['_CFG']['time_format'], $val['last_login']);
$schoolAdmin_list[$key]['status'] = get_status($val['status_id']);
//status表示身份
$schoolAdmin_list[$key]['school'] = get_school_name($val['school_code']);
}
$arr = array('schoolAdmin_list' => $schoolAdmin_list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
