isAjax()) { $model = new SettlementModel(); $page = input('page', 1); $page_size = input('page_size', PAGE_LIST_ROWS); $store_id = input('store_id', ''); if (!empty($store_id)) { $condition[] = [ 'store_id', '=', $store_id ]; } $condition[] = [ 'site_id', '=', $this->site_id ]; $start_time = input('start_time', ''); $end_time = input('end_time', ''); if (!empty($start_time) && empty($end_time)) { $condition[] = [ 'start_time', '>=', $start_time ]; } elseif (empty($start_time) && !empty($end_time)) { $condition[] = [ 'end_time', '<=', $end_time ]; } elseif (!empty($start_time) && !empty($end_time)) { $condition[] = [ 'start_time', '>=', $start_time ]; $condition[] = [ 'end_time', '<=', $end_time ]; } $order = 'id desc'; $field = 'id,settlement_no,site_id,site_name,store_name,order_money,shop_money,refund_platform_money,platform_money,refund_shop_money, refund_money,create_time,commission,is_settlement,offline_refund_money,offline_order_money,start_time,end_time, store_commission, withdraw_id'; $list = $model->getStoreSettlementPageList($condition, $page, $page_size, $order, $field); return $list; } //门店列表 $store_model = new Store(); $store_list = $store_model->getStoreList([ [ 'site_id', '=', $this->site_id ] ]); $this->assign('store_list', $store_list[ 'data' ]); return $this->fetch('settlement/index'); } /** * 已结算 * @return array */ public function settlement() { if (request()->isAjax()) { $remark = input('remark', ''); $settlement_id = input('settlement_id', 0); if (empty($remark)) { return error(-1, '请填写备注!'); } $settlement_model = new SettlementModel(); $res = $settlement_model->editSettlement([ 'is_settlement' => 1, 'remark' => $remark ], [ [ 'id', '=', $settlement_id ] ]); return $res; } } /** * detail 结算详情 */ public function detail() { $settlement_id = input('settlement_id', 0); $order_model = new OrderCommonModel(); if (request()->isAjax()) { $condition[] = [ 'store_settlement_id', '=', $settlement_id ]; $page = input('page', 1); $page_size = input('page_size', PAGE_LIST_ROWS); $field = 'order_id,order_no,pay_type,order_money,pay_type_name,order_status,refund_money,commission,finish_time,store_commission'; $list = $order_model->getOrderPageList($condition, $page, $page_size, 'finish_time desc', $field); return $list; } $settlement_model = new SettlementModel(); $settlement_info = $settlement_model->getSettlementInfo([ [ 'id', '=', $settlement_id ] ]); $store_model = new Store(); $store_info = $store_model->getStoreInfo([ [ 'store_id', '=', $settlement_info[ 'data' ][ 'store_id' ] ] ], 'create_time'); $this->assign('store_info', $store_info[ 'data' ]); $this->assign('info', $settlement_info[ 'data' ]); return $this->fetch('settlement/detail'); } }