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);