public function orderlist()
{
$xlsCell = array(array('id', '序号'), array('goodsname', '商品名称'), array('count', '数量'), array('price', '金额'));
$xlsModel = new GoodsorderViewModel();
if ($_SESSION['role_id'] > 0) {
$where['uid'] = $_SESSION['id'];
}
$xlsData = $xlsModel->where($where)->field('id,goodsname,count,price')->select();
foreach ($xlsData as $k => $v) {
$count = $count + $xlsData[$k]['count'];
$price = $price + $xlsData[$k]['price'];
}
$xlsData[$k + 1]['goodsname'] = '合计';
$xlsData[$k + 1]['count'] = $count;
$xlsData[$k + 1]['price'] = $price;
$this->xlsData = $xlsData;
$this->display();
}
function expGoodsOrder()
{
//导出Excel
$xlsName = '订单';
$xlsCell = array(array('id', '序号'), array('username', '用户名'), array('shopname', '门店名称'), array('goodsname', '商品名称'), array('count', '数量'), array('price', '金额'), array('time', '销售时间'));
$xlsModel = new GoodsorderViewModel();
$xlsData = $xlsModel->select();
foreach ($xlsData as $k => $v) {
$xlsData[$k]['time'] = date('Y-m-d H:i:s', $xlsData[$k]['time']);
}
$this->exportExcel($xlsName, $xlsCell, $xlsData);
}
