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 recharge() { $data = static::returnDataArray(); // $channel = Input::get('channel'); // if( $channel != 'WX_NATIVE' || $channel != 'ALI_QRCODE' ); // return Response::json(array( 'errCode'=>21, 'message'=>'支付方式只能选去微信或支付宝') ); // $data["channel"] = $channel; $data["channel"] = "WX_NATIVE"; // $money = 1; $money = Input::get('money'); if (preg_match('/^\\d*$/', $money)) { if ((int) $money >= 50 && (int) $money < 10000) { $data["total_fee"] = $money * 100; //单位换算成分 $money*100 } else { return Response::json(array('errCode' => 21, 'message' => '单次充值金额只能为50至10000元,且为整数')); } } else { return Response::json(array('errCode' => 22, 'message' => '订单金额应为正整数')); } $data["bill_no"] = CostDetail::get_unique_id(); $data['title'] = '充值'; $data["optional"] = json_decode(json_encode(array("user_id" => Sentry::getUser()->user_id), true), true); $order_auth_info = new OrderAuthInfo(); $order_auth_info->transactionId = $data["bill_no"]; //交易单号 $order_auth_info->transactionFee = $data["total_fee"]; //费用 if (!$order_auth_info->save()) { return Response::json(array('errCode' => 23, 'message' => '数据库保存错误')); } Cache::put($data["bill_no"], $data, 120); try { $result = BCRESTApi::bill($data); if ($result->result_code != 0) { return Response::json(array('errCode' => 24, 'message' => $result)); } $code_url = $result->code_url; //生成支付链接 } catch (Exception $e) { return Response::json(array('errCode' => 25, 'message' => $e->getMessage())); } $qrcode = array(); $qrcode['bill_no'] = $data['bill_no']; $qrcode['code_url'] = $code_url; Session::put('qrcode', $qrcode); return Response::json(array('errCode' => 0, 'message' => 'ok', 'url' => '/beecloud/qrcode')); }
/** * 插入随机数据 */ protected function create_cost_details($total = 300) { echo 'Creating cost_details...'; $fee_type = FeeType::where('category', '10')->first(); $users = User::all(); foreach ($users as $user) { for ($i = 0; $i < $total; ++$i) { $cost_detail = new CostDetail(); $cost_detail->user_id = $user->user_id; $cost_detail->fee_type_id = $fee_type->id; $cost_detail->number = rand(50, 100); $cost_detail->created_at = $this->get_random_datetime(); $cost_detail->save(); } } echo 'Done' . PHP_EOL; }