if (is_array($wheresqlarr)) {
$wheresql = wheresql($wheresqlarr);
}
if (!empty($_GET['settr'])) {
$settr = strtotime("-" . intval($_GET['settr']) . " day");
$wheresql .= empty($wheresql) ? " WHERE " : " AND ";
$wheresql .= "o.addtime> " . $settr;
}
}
$joinsql = " left JOIN " . table('members') . " as m ON o.uid=m.uid LEFT JOIN " . table('company_profile') . " as c ON o.uid=c.uid ";
$total_sql = "SELECT COUNT(*) AS num FROM " . table('order') . " as o " . $joinsql . $wheresql;
$total_val = $db->get_total($total_sql);
$page = new page(array('total' => $total_val, 'perpage' => $perpage));
$currenpage = $page->nowindex;
$offset = ($currenpage - 1) * $perpage;
$orderlist = get_order_list($offset, $perpage, $joinsql . $wheresql . $oederbysql);
$smarty->assign('pageheader', "订单管理");
$smarty->assign('payment_list', get_payment(2));
$smarty->assign('orderlist', $orderlist);
$smarty->assign('page', $page->show(3));
$smarty->display('company/admin_order_list.htm');
} elseif ($act == 'show_order') {
get_token();
check_permissions($_SESSION['admin_purview'], "ord_show");
$smarty->assign('pageheader', "订单管理");
$smarty->assign('url', $_SERVER["HTTP_REFERER"]);
$smarty->assign('payment', get_order_one($_GET['id']));
$smarty->display('company/admin_order_show.htm');
} elseif ($act == 'order_notes_save') {
check_token();
$link[0]['text'] = "返回列表";
$sys_user = new sys_userBean($db, 'sys_user');
$user_order = new user_orderBean($db, 'user_order');
$user_order_goods = new user_order_goodsBean($db, 'user_order_goods');
$user_comment = new user_commentBean($db, 'user_comment');
switch ($act) {
case 'list':
//商家列表
$result = get_list($db, $user_comment, $user_order, $shop_info);
break;
case 'info':
//商家信息
$result = detail($db, $shop_info, $user_comment, $user_order);
break;
case 'order_list':
//获取商家订单列表
$result = get_order_list($sid, $user_order, $sys_user, $sys_dict, $user_order_goods);
break;
case 'type':
$result = get_type($db, $sys_dict);
break;
case 'trading_mode':
$result = trading_mode($sid, $shop_info);
//获取商家交易模式
break;
case 'search_shop':
$result = search_shop($db, $user_comment, $user_order, $shop_info);
//模糊查询店铺
break;
default:
$result = array('success' => false, 'result' => -1, 'error_msg' => "传入参数有误！");
break;
if ($filter['adate'] != "" || $filter['odate'] != "") {
$sql = "SELECT count(*) FROM `ecs_order_goods` AS a LEFT JOIN ecs_order_info AS b ON a.order_id = b.order_id WHERE b.order_status =1 \r\n\t\t\t\t\tAND a.goods_price >=45 " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql1 = " SELECT b.order_sn,b.kfgh, b.orderman, b.ordertel, b.consignee, b.mobile, b.city, b.address, a.goods_name, a.goods_attr, a.goods_number, b.pay_name, b.pay_note,b.wsts, b.order_amount, from_unixtime( confirm_time ,'%Y-%m-%d') as confirmtime ,from_unixtime( confirm_time ,'%H:%i:%S') as confirmtime1 , left(best_time,10) as best_time2,substring(best_time,11) as best_time1 FROM `ecs_order_goods` AS a LEFT JOIN ecs_order_info AS b ON a.order_id = b.order_id WHERE b.order_status =1 AND a.goods_price >=45" . $where . " ORDER BY " . $order . " LIMIT " . $filter[start] . "," . $filter[page_size];
$row = $GLOBALS['db']->getAll($sql1);
$sql2 = " SELECT b.order_sn,b.kfgh, b.orderman, b.ordertel, b.consignee, b.mobile, b.address, a.goods_name, a.goods_attr, a.goods_number, b.order_amount,b.pay_name, b.pay_note,REPLACE(REPLACE(b.wsts, CHAR(10), ''), CHAR(13), '') as wsts1,from_unixtime( confirm_time ,'%Y-%m-%d') as confirmtime ,from_unixtime( confirm_time ,'%H:%i:%S') as confirmtime1 , left(best_time,10) as best_time2,substring(best_time,11) as best_time1 FROM `ecs_order_goods` AS a LEFT JOIN ecs_order_info AS b ON a.order_id = b.order_id WHERE b.order_status =1 AND a.goods_price >=45" . $where . " ORDER BY " . $order;
$_SESSION['tcontent'] = $GLOBALS['db']->getAll($sql2);
$_SESSION['ttop'] = array("订单号", "客服工号", "订货人", "订货电话", "收货人", "收货电话", "送货地址", "商品名称", "商品磅重", "商品数量", "应收金额", "支付类型", "支付备注", "备注", "订购日期", "时间", "配送日期", "时间");
$arr = array('item' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
}
if ($_REQUEST['act'] == 'query') {
$list = get_order_list();
$smarty->assign('filter', $list['filter']);
$smarty->assign('record_count', $list['record_count']);
$smarty->assign('page_count', $list['page_count']);
$smarty->assign('order_list', $list['item']);
$smarty->assign('date', $_REQUEST['date']);
$smarty->assign('act', 'order_list');
make_json_result($smarty->fetch('eachday_orderinfo.html'), '', array('filter' => $list['filter'], 'page_count' => $list['page_count']));
}
function get_order_list()
{
//查询条件
$filter['date'] = $_REQUEST['date'];
$where = " AND best_time LIKE '" . $filter['date'] . "%'";
$sql = "SELECT count(*) FROM `ecs_order_goods` AS a LEFT JOIN ecs_order_info AS b ON a.order_id = b.order_id WHERE b.order_status =1 \r\n\t\t\t\tAND a.goods_price >=45 " . $where . "ORDER BY surplus desc,bonus desc,pay_note desc";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
