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