public function cost_detail() { // 默认渲染数据 $render_data = ['previous_input' => ['date' => '', 'cost_type' => '10'], 'results' => []]; $params = Input::all(); // 参数非空,且指定查询的消费类型,且指定的消费类型有效 if (!empty($params)) { // 默认第一页 if (!Input::has('page')) { $params['page'] = 1; } if (!Input::has('date')) { $params['date'] = date('Y-m'); } Input::merge($params); $render_data['previous_input'] = array_merge($render_data['previous_input'], $params); // 查询充值记录 if ($params['cost_type'] == '10') { // 先查询费用类型 $fee_type = FeeType::select('id', 'category', 'item')->where('category', '10')->first(); // 查询费用明细所必须条件 $render_data['results'] = CostDetail::select('cost_id', 'created_at', 'fee_type_id', 'number')->where('user_id', Sentry::getUser()->user_id)->where('fee_type_id', $fee_type->id)->where('created_at', 'like', $params['date'] . '%')->orderBy('created_at', 'desc')->get(); } else { if ($params['cost_type'] == '20') { $date = Carbon::parse(Input::get('date')); $date_start = $date->timestamp * 1000; $date->addMonth(); $date_end = $date->timestamp * 1000; $render_data['results'] = BusinessController::count(Sentry::getUser()->user_id, $date_start, $date_end); } } } return View::make('pages.finance-center.cost-manage.cost-detail', $render_data); }
public function getCount() { $startDate = Input::get("startDate"); $endDate = Input::get("endDate"); $name = Input::get("name"); $user = BusinessUser::where("business_name", "=", $name)->first(); if (!isset($user)) { return Response::json(array("errCode" => 1, "errMsg" => "[数据库错误]找不到该用户")); } try { $data = BusinessController::count($user->user_id, $startDate, $endDate); } catch (Exception $e) { return Response::json(array("errCode" => 1, "errMsg" => "[服务器错误]获取访问接口统计数据失败")); } return Response::json(array("errCode" => 0, "data" => $data)); }