/**
* 返回班级管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function exam_prj_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['name'] = empty($_REQUEST['search_name']) ? '' : trim($_REQUEST['search_name']);
//名称
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['name'] = json_str_iconv($filter['name']);
}
$filter['sort'] = empty($_REQUEST['sort']) ? 'prj_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '25' : trim($_REQUEST['rows']);
$ex_where = " WHERE class_code='" . $_SESSION["class_code"] . "' ";
if ($filter['name']) {
$ex_where .= " AND name like '" . mysql_like_quote($filter['name']) . "%'";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table("exam_prj") . $ex_where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table("exam_prj") . $ex_where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
// echo $sql; echo '<br>';
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getAll($sql);
$arr = array('rows' => $list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
/**
* 返回短信列表数据
*/
function sms_list($class_code, $phone)
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['search_keyword']) ? '' : trim($_REQUEST['search_keyword']);
//关键字
$filter['phones'] = empty($_REQUEST['search_phones']) ? '' : trim($_REQUEST['search_phones']);
//学校code
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort'] = empty($_REQUEST['sort']) ? 'sms_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '20' : trim($_REQUEST['rows']);
$ex_where = " WHERE class_code='" . $class_code . "' and phones like '%{$phone}%'";
if ($filter['keywords']) {
$ex_where .= " AND content LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
}
$filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS["ecs"]->table("sms") . $ex_where);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $GLOBALS["ecs"]->table("sms") . $ex_where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
$filter['keywords'] = stripslashes($filter['keywords']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$sms_list = $GLOBALS['db']->getAll($sql);
$arr = array('rows' => $sms_list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
/**
* 返回班级管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function course_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['semster'] = empty($_REQUEST['search_semster']) ? '' : trim($_REQUEST['search_semster']);
//名称
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['semster'] = json_str_iconv($filter['semster']);
}
$ex_where = " WHERE class_code='" . $_SESSION["class_code"] . "' ";
if ($filter['semster']) {
$ex_where .= " AND semster = '" . mysql_like_quote($filter['semster']) . "'";
}
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table("course") . $ex_where;
// echo $sql; echo '<br>';
$filter['semster'] = stripslashes($filter['semster']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getRow($sql);
return $list;
}
function get_stock_control_log()
{
$result = get_filter();
if ($result === false) {
$filter = array();
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
$filter['admin_agency_id'] = empty($_REQUEST['admin_agency_id']) ? '' : trim($_REQUEST['admin_agency_id']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['start_date'] = empty($_REQUEST['start_date']) ? local_strtotime('-30 days') : $_REQUEST['start_date'];
$filter['end_date'] = empty($_REQUEST['end_date']) ? local_strtotime('today') : $_REQUEST['end_date'];
if (strpos($filter['start_date'], '-') !== false) {
$filter['start_date'] = local_strtotime($filter['start_date']);
$filter['end_date'] = local_strtotime($filter['end_date']);
}
$where = agency_where();
/*add by hg for date 2014-04-21 可选商品*/
if (if_agency()) {
if (!empty($filter['admin_agency_id'])) {
$where .= " AND (a.admin_agency_id = {$filter['admin_agency_id']} ) ";
} else {
$where .= " AND (a.admin_agency_id = 0 ) ";
}
}
if (!empty($filter['keyword'])) {
$where .= " AND (a.goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%' or a.stock_number LIKE '%" . mysql_like_quote($filter['keyword']) . "%' )";
}
if ($filter['start_date']) {
$where = $where . " AND a.log_time >= '{$filter['start_date']}'";
}
if ($filter['end_date']) {
$where = $where . " AND a.log_time <= '" . ($filter['end_date'] + 86400) . "'";
}
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('stock_control_log') . ' AS a ' . 'WHERE 1 ' . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 获取库存日志管理数据 */
$sql = 'SELECT a.* ' . 'FROM ' . $GLOBALS['ecs']->table('stock_control_log') . ' AS a ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($rows = $GLOBALS['db']->fetchRow($res)) {
$rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['log_time']);
$rows['out_type_remarks'] = $GLOBALS['db']->getOne("SELECT remarks FROM " . $GLOBALS['ecs']->table('stock_out_type') . " WHERE id = '" . $rows['out_type_id'] . "' ");
$arr[] = $rows;
}
$GLOBALS['smarty']->assign('start_date', local_date('Y-m-d', $filter['start_date']));
$GLOBALS['smarty']->assign('end_date', local_date('Y-m-d', $filter['end_date']));
$filter['start_date'] = local_date('Y-m-d', $filter['start_date']);
$filter['end_date'] = local_date('Y-m-d', $filter['end_date']);
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
function get_quotation_where($filter)
{
include_once ROOT_PATH . ADMIN_PATH_M . '/includes/lib_main.php';
$_filter = new StdClass();
$_filter->cat_id = $filter['cat_id'];
$_filter->brand_id = $filter['brand_id'];
$where = get_where_sql($_filter);
$_filter->keyword = $filter['keyword'];
$where .= isset($_filter->keyword) && trim($_filter->keyword) != '' ? " AND (g.goods_name LIKE '%" . mysql_like_quote($_filter->keyword) . "%' OR g.goods_sn LIKE '%" . mysql_like_quote($_filter->keyword) . "%' OR g.goods_id LIKE '%" . mysql_like_quote($_filter->keyword) . "%') " : '';
return $where;
}
/**
* 返回班级管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function resource_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['resource_type'] = empty($_REQUEST['search_resource_type']) ? '' : trim($_REQUEST['search_resource_type']);
//编号
$filter['name'] = empty($_REQUEST['search_name']) ? '' : trim($_REQUEST['search_name']);
//名称
$filter['sdate'] = empty($_REQUEST['search_sdate']) ? '' : trim($_REQUEST['search_sdate']);
//起始日期
$filter['edate'] = empty($_REQUEST['search_edate']) ? '' : trim($_REQUEST['search_edate']);
//截止日期
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['name'] = json_str_iconv($filter['name']);
}
$filter['sort'] = empty($_REQUEST['sort']) ? 'resource_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '25' : trim($_REQUEST['rows']);
$ex_where = " WHERE d.class_code='" . $_SESSION["class_code"] . "' ";
if ($filter['resource_type']) {
$ex_where .= " AND d.type = '" . mysql_like_quote($filter['resource_type']) . "'";
}
if ($filter['name']) {
$ex_where .= " AND d.name like '" . mysql_like_quote($filter['name']) . "%'";
}
if ($filter['sdate']) {
$ex_where .= " AND d.created >='" . mysql_like_quote($filter['sdate']) . "'";
}
if ($filter['edate']) {
$ex_where .= " AND d.created <='" . mysql_like_quote($filter['edate']) . "'";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table("resource") . " d " . $ex_where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT d.*, s.name as resource_type " . " FROM " . $GLOBALS['ecs']->table("resource") . " d left join " . $GLOBALS['ecs']->table("resource_type") . " s on d.type=s.rtype_id " . $ex_where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
// echo $sql; echo '<br>';
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getAll($sql);
foreach ($list as $k => $v) {
$list[$k]['creator_name'] = get_user_name($v["creator"], 'admin');
}
$arr = array('rows' => $list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
/**
* 返回班级管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function person_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
//名称
$filter['tel'] = empty($_REQUEST['tel']) ? '' : trim($_REQUEST['tel']);
//电话
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort'] = empty($_REQUEST['sort']) ? 'person_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '25' : trim($_REQUEST['rows']);
$ex_where = " WHERE class_code='" . $_SESSION["class_code"] . "' ";
if ($filter['keywords']) {
$ex_where .= " AND name LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
}
if ($filter['tel']) {
$ex_where .= " AND tel = '" . mysql_like_quote($filter['tel']) . "'";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table("person") . $ex_where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table("person") . $ex_where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
// echo $sql; echo '<br>';
$filter['keywords'] = stripslashes($filter['keywords']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getAll($sql);
// foreach ($list AS $key=>$val)
// {
// $list[$key]['created'] = local_date($GLOBALS['_CFG']['time_format'], $val['created']);
// }
$arr = array('rows' => $list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
public function auction_list($offset = '0, 12')
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['is_going'] = empty($_REQUEST['is_going']) ? 0 : 1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = "";
if (!empty($filter['keyword'])) {
$where .= " AND goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
if ($filter['is_going']) {
$now = gmtime();
$where .= " AND is_finished = 0 AND start_time <= '{$now}' AND end_time >= '{$now}' ";
}
/* 分页大小 */
// $filter = page_and_size($filter);
/* 查询 */
$sql = "SELECT * " . "FROM " . $this->model->pre . "goods_activity WHERE act_type = '" . GAT_AUCTION . "' {$where} " . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT {$offset}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $this->model->query($sql);
$list = array();
foreach ($res as $row) {
$ext_info = unserialize($row['ext_info']);
$arr = array_merge($row, $ext_info);
$arr['start_time'] = local_date('Y-m-d H:i', $arr['start_time']);
$arr['end_time'] = local_date('Y-m-d H:i', $arr['end_time']);
$list[] = $arr;
}
$arr = array('item' => $list, 'filter' => $filter);
return $arr;
}
/**
*
*
* @access public
* @param
*
* @return void
*/
function msg_list($from, $table)
{
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['search_keywords']) ? '' : trim($_REQUEST['search_keywords']);
$filter['msg_type'] = isset($_REQUEST['msg_type']) ? intval($_REQUEST['msg_type']) : -1;
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort'] = empty($_REQUEST['sort']) || trim($_REQUEST['sort']) == 'msg_reply' ? 'msg_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '25' : trim($_REQUEST['rows']);
$where = " WHERE parent_id = '0' AND msg_from='" . $from . "' and user_id='" . $_SESSION["admin_id"] . "' ";
$filter['from'] = $from;
if ($filter['keywords']) {
$where .= " AND (msg_title LIKE '%" . mysql_like_quote($filter['keywords']) . "%' ";
$where .= " OR msg_content LIKE '%" . mysql_like_quote($filter['keywords']) . "%') ";
}
if ($filter['msg_type'] != -1) {
$where .= " AND msg_type = '{$filter['msg_type']}' ";
}
$sql = "SELECT count(*) FROM " . $table . " AS f " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $table . $where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
$msg_list = $GLOBALS['db']->getAll($sql);
foreach ($msg_list as $key => $value) {
$reply = $GLOBALS['db']->getOne("select msg_content from " . $table . " where parent_id=" . $value["msg_id"] . " limit 1");
$msg_list[$key]['msg_status'] = $reply ? 1 : 0;
$msg_list[$key]['msg_reply'] = $reply;
$msg_list[$key]['msg_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['msg_time']);
$msg_list[$key]['msg_type'] = $GLOBALS['_LANG']['type'][$value['msg_type']];
}
$filter['keywords'] = stripslashes($filter['keywords']);
$arr = array('rows' => $msg_list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
/**
* 返回班级管理员列表数据
*
* @access public
* @param
*
* @return void
*/
function forum_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['search_keyword']) ? '' : trim($_REQUEST['search_keyword']);
//主体
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort'] = empty($_REQUEST['sort']) ? 'forum_id' : trim($_REQUEST['sort']);
$filter['order'] = empty($_REQUEST['order']) ? 'DESC' : trim($_REQUEST['order']);
$filter['page'] = empty($_REQUEST['page']) ? '1' : trim($_REQUEST['page']);
$filter['page_size'] = empty($_REQUEST['rows']) ? '25' : trim($_REQUEST['rows']);
$ex_where = " WHERE parent_id=0 and class_code='" . $_SESSION["class_code"] . "' ";
if ($filter['keyword']) {
$ex_where .= " AND (title like '%" . mysql_like_quote($filter['keyword']) . "%'";
$ex_where .= " OR content like '%" . mysql_like_quote($filter['keyword']) . "%')";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table("forum") . $ex_where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table("forum") . $ex_where . " ORDER by " . $filter['sort'] . ' ' . $filter['order'] . " LIMIT " . $filter['start'] . ',' . $filter['page_size'];
// echo $sql; echo '<br>';
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getAll($sql);
foreach ($list as $key => $val) {
$list[$key]['setime'] = $val['stime'] . "-" . $val['etime'];
}
$arr = array('rows' => $list, 'filter' => $filter, 'page' => $filter['page_count'], 'total' => $filter['record_count']);
return $arr;
}
/**
* 获取评论列表
* @access public
* @return array
*/
function get_order_comment_list()
{
$supplier_id = $_SESSION['supplier_id'];
/* 查询条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? 0 : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 's.add_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = !empty($filter['keywords']) ? " AND order_sn LIKE '%" . mysql_like_quote($filter['keywords']) . "%' " : '';
// $sql = "SELECT count(*) FROM " .$GLOBALS['ecs']->table('shop_grade'). " WHERE user_id > 0 $where";
$sql = "SELECT count(*) FROM " . $GLOBALS['ecs']->table('shop_grade') . " s" . " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " o" . " ON o.order_id = s.order_id" . " WHERE s.send > 0 AND o.supplier_id ='{$supplier_id}' {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 获取评论数据 */
$arr = array();
// $sql = "SELECT * FROM " .$GLOBALS['ecs']->table('shop_grade'). " WHERE user_id > 0 AND send >0$where " .
// " ORDER BY $filter[sort_by] $filter[sort_order] ".
// " LIMIT ". $filter['start'] .", $filter[page_size]";
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('shop_grade') . " s " . " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " o " . " ON o.order_id = s.order_id " . " WHERE o.supplier_id ='{$supplier_id}' AND send >0 {$where}" . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res)) {
$u_name = $row['user_name'];
$o_id = $row['order_id'];
$row['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
$sql = "SELECT AVG(comment_rank) FROM " . $GLOBALS['ecs']->table('comment') . " c" . " LEFT JOIN " . $GLOBALS['ecs']->table('order_goods') . " o" . " ON o.goods_id = c.id_value" . " WHERE c.order_id = '{$o_id}' AND c.order_id = o.order_id";
$comment_rank = $GLOBALS['db']->getOne($sql);
$row['comment_rank'] = round($comment_rank, 1);
$row['all_avg'] = round(($row['server'] + $row['send'] + $row['shipping'] + $row['comment_rank']) / 4, 1);
$arr[] = $row;
}
$filter['keywords'] = stripslashes($filter['keywords']);
$arr = array('item' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 生成过滤条件：用于 get_goodslist 和 get_goods_list
* @param object $filter
* @return string
*/
function get_where_sql($filter)
{
$time = date('Y-m-d');
$where = isset($filter->is_delete) && $filter->is_delete == '1' ? ' WHERE is_delete = 1 ' : ' WHERE is_delete = 0 ';
$where .= isset($filter->real_goods) && $filter->real_goods > -1 ? ' AND is_real = ' . intval($filter->real_goods) : '';
$where .= isset($filter->cat_id) && $filter->cat_id > 0 ? ' AND ' . get_children($filter->cat_id) : '';
$where .= isset($filter->brand_id) && $filter->brand_id > 0 ? " AND brand_id = '" . $filter->brand_id . "'" : '';
$where .= isset($filter->intro_type) && $filter->intro_type != '0' ? ' AND ' . $filter->intro_type . " = '1'" : '';
$where .= isset($filter->intro_type) && $filter->intro_type == 'is_promote' ? " AND promote_start_date <= '{$time}' AND promote_end_date >= '{$time}' " : '';
$where .= isset($filter->keyword) && trim($filter->keyword) != '' ? " AND (goods_name LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR goods_sn LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR goods_id LIKE '%" . mysql_like_quote($filter->keyword) . "%') " : '';
$where .= isset($filter->in_ids) ? ' AND goods_id ' . db_create_in($filter->in_ids) : '';
$where .= isset($filter->exclude) ? ' AND goods_id NOT ' . db_create_in($filter->exclude) : '';
$where .= isset($filter->stock_warning) ? ' AND goods_number <= warn_number' : '';
return $where;
}
function get_exchange_goodslist()
{
$result = get_filter();
if ($result === false) {
$filter = array();
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'eg.goods_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if (!empty($filter['keyword'])) {
$where = " AND g.goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
/* 文章总数 */
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('exchange_goods') . ' AS eg ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = eg.goods_id ' . 'WHERE 1 ' . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 获取文章数据 */
$sql = 'SELECT eg.* , g.goods_name ' . 'FROM ' . $GLOBALS['ecs']->table('exchange_goods') . ' AS eg ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = eg.goods_id ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($rows = $GLOBALS['db']->fetchRow($res)) {
$arr[] = $rows;
}
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
* 返回用户列表数据
*
* @access public
* @param
*
* @return void
*/
function user_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['rank'] = empty($_REQUEST['rank']) ? 0 : intval($_REQUEST['rank']);
$filter['pay_points_gt'] = empty($_REQUEST['pay_points_gt']) ? 0 : intval($_REQUEST['pay_points_gt']);
$filter['pay_points_lt'] = empty($_REQUEST['pay_points_lt']) ? 0 : intval($_REQUEST['pay_points_lt']);
$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 1 ';
if (isset($_REQUEST['sign'])) {
if ($_REQUEST['sign'] == 1) {
$ex_where .= " AND parent_id = 0 AND is_fenxiao <> 0 AND is_fenxiao = 1";
}
if ($_REQUEST['sign'] == 2) {
$ex_where .= " AND parent_id > 0 AND is_fenxiao <> 0 AND is_fenxiao = 1";
}
if ($_REQUEST['sign'] == 3) {
$ex_where .= " AND is_fenxiao <> 1 ";
}
}
if ($filter['keywords']) {
$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
}
if ($filter['rank']) {
$sql = "SELECT min_points, max_points, special_rank FROM " . $GLOBALS['ecs']->table('user_rank') . " WHERE rank_id = '{$filter['rank']}'";
$row = $GLOBALS['db']->getRow($sql);
if ($row['special_rank'] > 0) {
/* 特殊等级 */
$ex_where .= " AND user_rank = '{$filter['rank']}' ";
} else {
$ex_where .= " AND rank_points >= " . intval($row['min_points']) . " AND rank_points < " . intval($row['max_points']);
}
}
if ($filter['pay_points_gt']) {
$ex_where .= " AND pay_points >= '{$filter['pay_points_gt']}' ";
}
if ($filter['pay_points_lt']) {
$ex_where .= " AND pay_points < '{$filter['pay_points_lt']}' ";
}
$filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('users') . $ex_where);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT user_id, user_name, email, is_validated, validated,status,user_money, frozen_money, rank_points, pay_points, reg_time,is_fenxiao,parent_id " . " FROM " . $GLOBALS['ecs']->table('users') . $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'];
}
$user_list = $GLOBALS['db']->getAll($sql);
$count = count($user_list);
for ($i = 0; $i < $count; $i++) {
$user_list[$i]['reg_time'] = local_date($GLOBALS['_CFG']['date_format'], $user_list[$i]['reg_time']);
$user_list[$i]['upper_user_name'] = get_upper_level($user_list[$i]['parent_id']);
$one_level_user_count = get_user_count($user_list[$i]['user_id'], 1);
$two_level_user_count = get_user_count($user_list[$i]['user_id'], 2);
$three_level_user_count = get_user_count($user_list[$i]['user_id'], 3);
$user_list[$i]['one_level_user_count'] = $one_level_user_count;
$user_list[$i]['two_level_user_count'] = $two_level_user_count;
$user_list[$i]['three_level_user_count'] = $three_level_user_count;
$user_list[$i]['total_user'] = $one_level_user_count + $two_level_user_count + $three_level_user_count;
}
$arr = array('user_list' => $user_list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 为某商品生成唯一的货号
* @param int $goods_id 商品编号
* @return string 唯一的货号
*/
function generate_goods_sn($goods_id)
{
$goods_sn = $GLOBALS['_CFG']['sn_prefix'] . str_repeat('0', 6 - strlen($goods_id)) . $goods_id;
$sql = "SELECT goods_sn FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_sn LIKE '" . mysql_like_quote($goods_sn) . "%' AND goods_id <> '{$goods_id}' " . " ORDER BY LENGTH(goods_sn) DESC";
$sn_list = $GLOBALS['db']->getCol($sql);
if (in_array($goods_sn, $sn_list)) {
$max = pow(10, strlen($sn_list[0]) - strlen($goods_sn) + 1) - 1;
$new_sn = $goods_sn . mt_rand(0, $max);
while (in_array($new_sn, $sn_list)) {
$new_sn = $goods_sn . mt_rand(0, $max);
}
$goods_sn = $new_sn;
}
return $goods_sn;
}
function get_articleslist()
{
$result = get_filter();
if ($result === false) {
$filter = array();
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']);
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.article_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if (!empty($filter['keyword'])) {
$where = " AND a.title LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
if ($filter['cat_id']) {
$where .= " AND a." . get_article_children($filter['cat_id']);
}
/* 文章总数 */
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 获取文章数据 */
$sql = 'SELECT a.* , ac.cat_name ' . 'FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($rows = $GLOBALS['db']->fetchRow($res)) {
$rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
$arr[] = $rows;
}
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
* 获取退货单列表信息
*
* @access public
* @param
*
* @return void
*/
function back_list()
{
$result = get_filter();
if ($result === false) {
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
/* 过滤信息 */
$filter['delivery_sn'] = empty($_REQUEST['delivery_sn']) ? '' : trim($_REQUEST['delivery_sn']);
$filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']);
$filter['order_id'] = empty($_REQUEST['order_id']) ? 0 : intval($_REQUEST['order_id']);
if ($aiax == 1 && !empty($_REQUEST['consignee'])) {
$_REQUEST['consignee'] = json_str_iconv($_REQUEST['consignee']);
}
$filter['consignee'] = empty($_REQUEST['consignee']) ? '' : trim($_REQUEST['consignee']);
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'update_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
// $where = 'WHERE 1 ';
$where = 'WHERE is_cancled = 0 ';
//修改where条件 chen 0901
if ($filter['order_sn']) {
$where .= " AND order_sn LIKE '%" . mysql_like_quote($filter['order_sn']) . "%'";
}
if ($filter['consignee']) {
$where .= " AND consignee LIKE '%" . mysql_like_quote($filter['consignee']) . "%'";
}
if ($filter['delivery_sn']) {
$where .= " AND delivery_sn LIKE '%" . mysql_like_quote($filter['delivery_sn']) . "%'";
}
/* 获取管理员信息 */
$admin_info = admin_info();
/* 如果管理员属于某个办事处，只列出这个办事处管辖的发货单 */
if ($admin_info['agency_id'] > 0) {
$where .= " AND agency_id = '" . $admin_info['agency_id'] . "' ";
}
/* 如果管理员属于某个供货商，只列出这个供货商的发货单 */
if ($admin_info['suppliers_id'] > 0) {
$where .= " AND suppliers_id = '" . $admin_info['suppliers_id'] . "' ";
}
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 15;
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('back_order') . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 查询 chen 修改sql语句 0901*/
$sql = "SELECT back_id, delivery_sn,back_type,back_reason,pro_descrip,return_money, order_sn, order_id, add_time, action_user, consignee, country,\n province, city, district, tel, status, update_time, email, return_time\n FROM " . $GLOBALS['ecs']->table("back_order") . "\n {$where}\n ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'] . "\n LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$row = $GLOBALS['db']->getAll($sql);
/* 格式化数据 */
foreach ($row as $key => $value) {
$row[$key]['return_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['return_time']);
$row[$key]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
$row[$key]['update_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['update_time']);
if ($value['status'] == 1) {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][1];
} else {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][0];
}
}
$arr = array('back' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 分页获取客服列表
*
* @return array
*/
function customer_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$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']);
$where = !empty($filter['keyword']) ? " AND cus_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'" : '';
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('chat_customer') . " WHERE 1=1 {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 查询 */
$sql = "SELECT a.*, b.user_name " . "FROM " . $GLOBALS['ecs']->table('chat_customer') . " AS a LEFT JOIN " . $GLOBALS['ecs']->table('admin_user') . " AS b ON (a.user_id = b.user_id) WHERE 1=1 {$where} " . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = $GLOBALS['db']->getAll($sql);
foreach ($list as &$item) {
$item['formated_add_time'] = local_date('Y-m-d H:m', $item['add_time']);
}
unset($item);
$arr = array('item' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
function group_buy_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if ($_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = !empty($filter['keyword']) ? " AND goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'" : '';
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods_activity') . " WHERE act_type = '" . GAT_GROUP_BUY . "' {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 查询 */
$sql = "SELECT * " . "FROM " . $GLOBALS['ecs']->table('goods_activity') . " WHERE act_type = '" . GAT_GROUP_BUY . "' {$where} " . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $GLOBALS['db']->query($sql);
$list = array();
while ($row = $GLOBALS['db']->fetchRow($res)) {
$ext_info = unserialize($row['ext_info']);
$stat = group_buy_stat($row['act_id'], $ext_info['deposit']);
$arr = array_merge($row, $stat, $ext_info);
/* 处理价格阶梯 */
$price_ladder = $arr['price_ladder'];
if (!is_array($price_ladder) || empty($price_ladder)) {
$price_ladder = array(array('amount' => 0, 'price' => 0));
} else {
foreach ($price_ladder as $key => $amount_price) {
$price_ladder[$key]['formated_price'] = price_format($amount_price['price']);
}
}
/* 计算当前价 */
$cur_price = $price_ladder[0]['price'];
// 初始化
$cur_amount = $stat['valid_goods'];
// 当前数量
foreach ($price_ladder as $amount_price) {
if ($cur_amount >= $amount_price['amount']) {
$cur_price = $amount_price['price'];
} else {
break;
}
}
$arr['cur_price'] = $cur_price;
$status = group_buy_status($arr);
$arr['start_time'] = local_date($GLOBALS['_CFG']['date_format'], $arr['start_time']);
$arr['end_time'] = local_date($GLOBALS['_CFG']['date_format'], $arr['end_time']);
$arr['cur_status'] = $GLOBALS['_LANG']['gbs'][$status];
$list[] = $arr;
}
$arr = array('item' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
$db->query($sql);
$arr = get_group_goods($goods_id);
$opt = array();
foreach ($arr as $val) {
$opt[] = array('value' => $val['goods_id'], 'text' => '[套餐' . $val['group_id'] . ']' . $val['goods_name'], 'data' => '');
}
clear_cache_files();
make_json_result($opt);
} elseif ($_REQUEST['act'] == 'get_article_list') {
include_once ROOT_PATH . 'includes/cls_json.php';
$json = new JSON();
$filters = (array) $json->decode(json_str_iconv($_GET['JSON']));
$where = " WHERE cat_id > 0 ";
if (!empty($filters['title'])) {
$keyword = trim($filters['title']);
$where .= " AND title LIKE '%" . mysql_like_quote($keyword) . "%' ";
}
$sql = 'SELECT article_id, title FROM ' . $ecs->table('article') . $where . 'ORDER BY article_id DESC LIMIT 50';
$res = $db->query($sql);
$arr = array();
while ($row = $db->fetchRow($res)) {
$arr[] = array('value' => $row['article_id'], 'text' => $row['title'], 'data' => '');
}
make_json_result($arr);
} elseif ($_REQUEST['act'] == 'add_goods_article') {
include_once ROOT_PATH . 'includes/cls_json.php';
$json = new JSON();
check_authz_json('goods_manage');
$articles = $json->decode($_GET['add_ids']);
$arguments = $json->decode($_GET['JSON']);
$goods_id = $arguments[0];
function get_typelist()
{
$result = get_filter();
if ($result === false) {
$filter = array();
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
$filter['admin_agency_id'] = empty($_REQUEST['admin_agency_id']) ? '' : trim($_REQUEST['admin_agency_id']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.add_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if (!empty($filter['keyword'])) {
$where = " AND a.remarks LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
/*加入代理商条件*/
if (!$filter['admin_agency_id']) {
$agency_where = agency_where();
if (!$agency_where) {
$agency_where = "AND a.admin_agency_id = 0";
} else {
$agency_where = "AND a.admin_agency_id = " . admin_agency_id();
}
} else {
$agency_where = " AND a.admin_agency_id = {$filter['admin_agency_id']}";
}
//dump($agency_where);
/* 出库类型总数 */
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('stock_out_type') . ' AS a ' . 'WHERE 1 ' . $where . $agency_where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 获取出库类型数据 */
$sql = 'SELECT a.* , u.user_name ' . 'FROM ' . $GLOBALS['ecs']->table('stock_out_type') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('admin_user') . ' AS u ON u.user_id = a.user_id ' . 'WHERE 1 ' . $where . $agency_where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($rows = $GLOBALS['db']->fetchRow($res)) {
$rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
$arr[] = $rows;
}
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
*
*
* @access public
* @param
*
* @return void
*/
function account_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤列表 */
$filter['user_id'] = !empty($_REQUEST['user_id']) ? intval($_REQUEST['user_id']) : 0;
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['process_type'] = isset($_REQUEST['process_type']) ? intval($_REQUEST['process_type']) : -1;
$filter['payment'] = empty($_REQUEST['payment']) ? '' : trim($_REQUEST['payment']);
$filter['is_paid'] = isset($_REQUEST['is_paid']) ? intval($_REQUEST['is_paid']) : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'add_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['start_date'] = empty($_REQUEST['start_date']) ? '' : local_strtotime($_REQUEST['start_date']);
$filter['end_date'] = empty($_REQUEST['end_date']) ? '' : local_strtotime($_REQUEST['end_date']) + 86400;
$where = " WHERE 1 ";
if ($filter['user_id'] > 0) {
$where .= " AND ua.user_id = '{$filter['user_id']}' ";
}
if ($filter['process_type'] != -1) {
$where .= " AND ua.process_type = '{$filter['process_type']}' ";
} else {
$where .= " AND ua.process_type " . db_create_in(array(SURPLUS_SAVE, SURPLUS_RETURN));
}
if ($filter['payment']) {
$where .= " AND ua.payment = '{$filter['payment']}' ";
}
if ($filter['is_paid'] != -1) {
$where .= " AND ua.is_paid = '{$filter['is_paid']}' ";
}
if ($filter['keywords']) {
$where .= " AND u.user_name LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('user_account') . " AS ua, " . $GLOBALS['ecs']->table('users') . " AS u " . $where;
}
/* 时间过滤 */
if (!empty($filter['start_date']) && !empty($filter['end_date'])) {
$where .= "AND paid_time >= " . $filter['start_date'] . " AND paid_time < '" . $filter['end_date'] . "'";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('user_account') . " AS ua, " . $GLOBALS['ecs']->table('users') . " AS u " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 查询数据 */
$sql = 'SELECT ua.*, u.user_name FROM ' . $GLOBALS['ecs']->table('user_account') . ' AS ua LEFT JOIN ' . $GLOBALS['ecs']->table('users') . ' AS u ON ua.user_id = u.user_id' . $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'];
}
$list = $GLOBALS['db']->getAll($sql);
foreach ($list as $key => $value) {
$list[$key]['surplus_amount'] = price_format(abs($value['amount']), false);
$list[$key]['add_date'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
$list[$key]['process_type_name'] = $GLOBALS['_LANG']['surplus_type_' . $value['process_type']];
}
$arr = array('list' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 返回用户订单列表数据
*
* @access public
* @param
*
* @return void
*/
function order_list()
{
global $start_date, $end_date;
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'order_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['start_date'] = local_date('d-m-Y', $start_date);
$filter['end_date'] = local_date('d-m-Y', $end_date);
$ex_where = ' WHERE 1 ';
if ($filter['keywords']) {
$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) . "%'";
}
$ex_where .= " AND o.user_id = u.user_id AND (o.surplus != 0 OR integral_money != 0) AND `add_time` >= " . $start_date . " AND `add_time` < " . ($end_date + 86400);
$filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_info') . " AS o, " . $GLOBALS['ecs']->table('users') . " AS u " . $ex_where);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT o.order_id, o.order_sn, u.user_name, o.surplus, o.integral_money, o.add_time FROM " . $GLOBALS['ecs']->table('order_info') . " AS o," . $GLOBALS['ecs']->table('users') . " AS u " . $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'];
}
$order_list = $GLOBALS['db']->getAll($sql);
$count = count($order_list);
for ($i = 0; $i < $count; $i++) {
$order_list[$i]['add_time'] = local_date($GLOBALS['_CFG']['date_format'], $order_list[$i]['add_time']);
}
$arr = array('order_list' => $order_list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
function wholesale_list()
{
/* 查询会员等级 */
$rank_list = array();
$sql = "SELECT rank_id, rank_name FROM " . $GLOBALS['ecs']->table('user_rank');
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res)) {
$rank_list[$row['rank_id']] = $row['rank_name'];
}
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = "";
if (!empty($filter['keyword'])) {
$where .= " AND goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('wholesale') . " WHERE 1 {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 查询 */
$sql = "SELECT * " . "FROM " . $GLOBALS['ecs']->table('wholesale') . " WHERE 1 {$where} " . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $GLOBALS['db']->query($sql);
$list = array();
while ($row = $GLOBALS['db']->fetchRow($res)) {
$rank_name_list = array();
if ($row['rank_ids']) {
$rank_id_list = explode(',', $row['rank_ids']);
foreach ($rank_id_list as $id) {
if (isset($rank_list[$id])) {
$rank_name_list[] = $rank_list[$id];
}
}
}
$row['rank_names'] = join(',', $rank_name_list);
$row['price_list'] = unserialize($row['prices']);
$list[] = $row;
}
return array('item' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
*
*
* @access public
* @param
*
* @return void
*/
function msg_list()
{
/* 过滤条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['msg_type'] = isset($_REQUEST['msg_type']) ? intval($_REQUEST['msg_type']) : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'f.msg_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if ($filter['keywords']) {
$where .= " AND f.msg_title LIKE '%" . mysql_like_quote($filter['keywords']) . "%' ";
}
if ($filter['msg_type'] != -1) {
$where .= " AND f.msg_type = '{$filter['msg_type']}' ";
}
$sql = "SELECT count(*) FROM " . $GLOBALS['ecs']->table('feedback') . " AS f" . " WHERE parent_id = '0' " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT f.msg_id, f.user_name, f.msg_title, f.msg_type, f.order_id, f.msg_status, f.msg_time, f.msg_area, COUNT(r.msg_id) AS reply " . "FROM " . $GLOBALS['ecs']->table('feedback') . " AS f " . "LEFT JOIN " . $GLOBALS['ecs']->table('feedback') . " AS r ON r.parent_id=f.msg_id " . "WHERE f.parent_id = 0 {$where} " . "GROUP BY f.msg_id " . "ORDER by {$filter['sort_by']} {$filter['sort_order']} " . "LIMIT " . $filter['start'] . ', ' . $filter['page_size'];
$msg_list = $GLOBALS['db']->getAll($sql);
foreach ($msg_list as $key => $value) {
if ($value['order_id'] > 0) {
$msg_list[$key]['order_sn'] = $GLOBALS['db']->getOne("SELECT order_sn FROM " . $GLOBALS['ecs']->table('order_info') . " WHERE order_id= " . $value['order_id']);
}
$msg_list[$key]['msg_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['msg_time']);
$msg_list[$key]['msg_type'] = $GLOBALS['_LANG']['type'][$value['msg_type']];
}
$filter['keywords'] = stripslashes($filter['keywords']);
$arr = array('msg_list' => $msg_list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 获得商品列表
*
* @access public
* @params integer $isdelete
* @params integer $real_goods
* @params integer $conditions
* @params integer $is_add_goods
* @return array
*/
function goods_list($is_delete, $real_goods = 1, $conditions = '', $is_add_goods)
{
/* 过滤条件 */
$param_str = '-' . $is_delete . '-' . $real_goods;
$result = get_filter($param_str);
if ($result === false) {
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']);
$filter['intro_type'] = empty($_REQUEST['intro_type']) ? '' : trim($_REQUEST['intro_type']);
$filter['is_promote'] = empty($_REQUEST['is_promote']) ? 0 : intval($_REQUEST['is_promote']);
$filter['stock_warning'] = empty($_REQUEST['stock_warning']) ? 0 : intval($_REQUEST['stock_warning']);
$filter['brand_id'] = empty($_REQUEST['brand_id']) ? 0 : intval($_REQUEST['brand_id']);
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
$filter['suppliers_id'] = isset($_REQUEST['suppliers_id']) ? empty($_REQUEST['suppliers_id']) ? '' : trim($_REQUEST['suppliers_id']) : '';
$filter['is_on_sale'] = isset($_REQUEST['is_on_sale']) ? empty($_REQUEST['is_on_sale']) && $_REQUEST['is_on_sale'] === 0 ? '' : trim($_REQUEST['is_on_sale']) : '';
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'goods_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['extension_code'] = empty($_REQUEST['extension_code']) ? '' : trim($_REQUEST['extension_code']);
$filter['is_delete'] = $is_delete;
$filter['real_goods'] = $real_goods;
$filter['is_add_goods'] = $is_add_goods;
$where = $filter['cat_id'] > 0 ? " AND " . get_children($filter['cat_id']) : '';
/* 推荐类型 */
switch ($filter['intro_type']) {
case 'is_best':
$where .= " AND is_best=1";
break;
case 'is_hot':
$where .= ' AND is_hot=1';
break;
case 'is_new':
$where .= ' AND is_new=1';
break;
case 'is_promote':
$where .= " AND is_promote = 1 AND promote_price > 0 AND promote_start_date <= '{$today}' AND promote_end_date >= '{$today}'";
break;
case 'all_type':
$where .= " AND (is_best=1 OR is_hot=1 OR is_new=1 OR (is_promote = 1 AND promote_price > 0 AND promote_start_date <= '" . $today . "' AND promote_end_date >= '" . $today . "'))";
}
/* 库存警告 */
if ($filter['stock_warning']) {
$where .= ' AND goods_number <= warn_number ';
}
/* 品牌 */
if ($filter['brand_id']) {
$where .= " AND brand_id='{$filter['brand_id']}'";
}
/* 扩展 */
if ($filter['extension_code']) {
$where .= " AND extension_code='{$filter['extension_code']}'";
}
/* 关键字 */
if (!empty($filter['keyword'])) {
$where .= " AND (goods_sn LIKE '%" . mysql_like_quote($filter['keyword']) . "%' OR goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%')";
}
if ($real_goods > -1) {
$where .= " AND is_real='{$real_goods}'";
}
/* 上架 */
if ($filter['is_on_sale'] !== '') {
$where .= " AND (is_on_sale = '" . $filter['is_on_sale'] . "')";
}
/* 供货商 */
if (!empty($filter['suppliers_id'])) {
$where .= " AND (suppliers_id = '" . $filter['suppliers_id'] . "')";
}
$where .= $conditions;
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='{$is_delete}' {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " . " (promote_price > 0 AND promote_start_date <= '{$today}' AND promote_end_date >= '{$today}') AS is_promote " . " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='{$is_delete}' {$where}" . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ",{$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql, $param_str);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$row = $GLOBALS['db']->getAll($sql);
return array('goods' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
function auction_list()
{
$result = get_filter();
if ($result === false) {
/* 过滤条件 */
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['is_going'] = empty($_REQUEST['is_going']) ? 0 : 1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = "";
if (!empty($filter['keyword'])) {
$where .= " AND goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
if ($filter['is_going']) {
$now = gmtime();
$where .= " AND is_finished = 0 AND start_time <= '{$now}' AND end_time >= '{$now}' ";
}
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods_activity') . " WHERE act_type = '" . GAT_AUCTION . "' {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 查询 */
$sql = "SELECT * " . "FROM " . $GLOBALS['ecs']->table('goods_activity') . " WHERE act_type = '" . GAT_AUCTION . "' {$where} " . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $GLOBALS['db']->query($sql);
$list = array();
while ($row = $GLOBALS['db']->fetchRow($res)) {
$ext_info = unserialize($row['ext_info']);
$arr = array_merge($row, $ext_info);
$arr['start_time'] = local_date('Y-m-d H:i', $arr['start_time']);
$arr['end_time'] = local_date('Y-m-d H:i', $arr['end_time']);
$list[] = $arr;
}
$arr = array('item' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 获取信息列表
*
* @access public
* @return array
*/
function get_shaidanlist()
{
$result = get_filter();
if ($result === false) {
$filter = array();
$filter['title'] = empty($_REQUEST['title']) ? '' : trim($_REQUEST['title']);
$filter['goods_name'] = empty($_REQUEST['goods_name']) ? '' : trim($_REQUEST['goods_name']);
$filter['user_name'] = empty($_REQUEST['user_name']) ? '' : trim($_REQUEST['user_name']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['title'] = json_str_iconv($filter['title']);
$filter['goods_name'] = json_str_iconv($filter['goods_name']);
$filter['user_name'] = json_str_iconv($filter['user_name']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.shaidan_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if (!empty($filter['title'])) {
$where = " AND a.title LIKE '%" . mysql_like_quote($filter['title']) . "%'";
}
if (!empty($filter['goods_name'])) {
$where = " AND og.goods_name LIKE '%" . mysql_like_quote($filter['goods_name']) . "%'";
}
if (!empty($filter['user_name'])) {
$where = " AND u.user_name LIKE '%" . mysql_like_quote($filter['user_name']) . "%'";
}
/* 总数 */
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('shaidan') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('users') . ' AS u ON u.user_id = a.user_id ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('order_goods') . ' AS og ON og.rec_id = a.rec_id ' . 'WHERE 1 ' . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 数据 */
$sql = 'SELECT a.* , u.user_name, og.goods_name ' . 'FROM ' . $GLOBALS['ecs']->table('shaidan') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('users') . ' AS u ON u.user_id = a.user_id ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('order_goods') . ' AS og ON og.rec_id = a.rec_id ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
$filter['title'] = stripslashes($filter['title']);
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($member = $GLOBALS['db']->fetchRow($res)) {
$member['add_time'] = date("Y-m-d", $member['add_time']);
$arr[] = $member;
}
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
* 获取订购信息
*
* @access public
*
* @return array
*/
function get_bookinglist()
{
/* 查询条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['dispose'] = empty($_REQUEST['dispose']) ? 0 : intval($_REQUEST['dispose']);
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'sort_order' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = !empty($_REQUEST['keywords']) ? " AND g.goods_name LIKE '%" . mysql_like_quote($filter['keywords']) . "%' " : '';
$where .= !empty($_REQUEST['dispose']) ? " AND bg.is_dispose = '{$filter['dispose']}' " : '';
$sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('booking_goods') . ' AS bg, ' . $GLOBALS['ecs']->table('goods') . ' AS g ' . "WHERE bg.goods_id = g.goods_id {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
/* 获取活动数据 */
$sql = 'SELECT bg.rec_id, bg.link_man, g.goods_id, g.goods_name, bg.goods_number, bg.booking_time, bg.is_dispose ' . 'FROM ' . $GLOBALS['ecs']->table('booking_goods') . ' AS bg, ' . $GLOBALS['ecs']->table('goods') . ' AS g ' . "WHERE bg.goods_id = g.goods_id {$where} " . "ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . "LIMIT " . $filter['start'] . ", {$filter['page_size']}";
$row = $GLOBALS['db']->getAll($sql);
foreach ($row as $key => $val) {
$row[$key]['booking_time'] = local_date($GLOBALS['_CFG']['time_format'], $val['booking_time']);
}
$filter['keywords'] = stripslashes($filter['keywords']);
$arr = array('item' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 获取活动列表
*
* @access public
*
* @return void
*/
function get_packagelist()
{
$result = get_filter();
if ($result === false) {
/* 查询条件 */
$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keywords'] = json_str_iconv($filter['keywords']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = !empty($filter['keywords']) ? " AND act_name like '%" . mysql_like_quote($filter['keywords']) . "%'" : '';
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['hhs']->table('goods_activity') . " WHERE act_type =" . GAT_PACKAGE . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter = page_and_size($filter);
/* 获活动数据 */
$sql = "SELECT act_id, act_name AS package_name, start_time, end_time, is_finished, ext_info " . " FROM " . $GLOBALS['hhs']->table('goods_activity') . " WHERE act_type = " . GAT_PACKAGE . $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'];
}
$row = $GLOBALS['db']->getAll($sql);
foreach ($row as $key => $val) {
$row[$key]['start_time'] = local_date($GLOBALS['_CFG']['time_format'], $val['start_time']);
$row[$key]['end_time'] = local_date($GLOBALS['_CFG']['time_format'], $val['end_time']);
$info = unserialize($row[$key]['ext_info']);
unset($row[$key]['ext_info']);
if ($info) {
foreach ($info as $info_key => $info_val) {
$row[$key][$info_key] = $info_val;
}
}
}
$arr = array('packages' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
