控制层
//卖场销售明细,导出Excel
public function store_detail()
{
$data = input("get.");
$list = $this->storeOrderModel->getStoreModel($data);
$firstRowTitle = '卖场销售明细(';
$start_str = empty($data['start']) ? ' - ' : $data['start'];
$end_str = empty($data['end']) ? ' - ' : $data['end'];
$firstRowTitle .= '时间:' . $start_str . '至' . $end_str;
$firstRowTitle .= ')';
down_excel($list, '卖场销售明细表', $firstRowTitle, ['门店编号', '门店名称', '销售总额'], [20, 28, 20]);
}
模型层
/**
* 卖场销售明细
* @param $data
*/
public function getStoreModel($data)
{
//步骤1:从store_order表,查询订单价格,购买日期,导购员id,list
//步骤2:遍历list,根据userid,下单时间data,从表store_countoff查找门店id。
//步骤3:根据门店id,去store表,找到需要的门店名称,和store_gene_id,并赋值给新数组array
// 步骤4: 遍历array数组将金额累加得到门店的总金额;
$where = [];
foreach ($data as $k => $v) {
if ($v === 0) {
continue;
}
if (empty($v)) {
unset($data[$k]);
}
}
if (!empty($data['start'])&&!empty($data['end'])){
$start = strtotime($data['start']);
$end = strtotime($data['end']);
$where['create_time'] = ['between', [$start, $end]];
}
if(!empty($data['start'])&&empty($data['end'])){
$start = strtotime($data['start']);