public function getResult(Request $request) { $out_sum = $request->get('OutSum'); $inv_id = $request->get('InvId'); $user = Payment::select('user_id')->where('uid', '=', $inv_id)->first(); $checksum = $request->get('SignatureValue'); $password2 = config('roboconfig.password2'); if (strtolower($checksum) == strtolower(md5($out_sum . ":" . $inv_id . ":" . $password2))) { if (Payment::where('uid', '=', $inv_id) && Payment::where('balance', '=', $out_sum)) { try { DB::beginTransaction(); $payment = Payment::where('uid', '=', $inv_id)->first(); if ($payment->status == 0) { $payment->status = 1; $payment->update(); $addBalanceToUser = User::find($user->user_id); $addBalanceToUser->balance += $out_sum; $addBalanceToUser->update(); } DB::commit(); } catch (\PDOException $e) { \Session::flash('message', "{$e->getMessage}()"); DB::connection()->getPdo()->rollBack(); } } } return redirect()->action('ProfileController@index'); }
public function adminGraph() { $result = ['newcomers' => [], 'orga' => ['wei' => 0, 'sandwitch' => 0, 'guarantee' => 0], 'ce' => ['wei' => 0, 'sandwitch' => 0, 'guarantee' => 0], 'vieux' => ['wei' => 0, 'sandwitch' => 0, 'guarantee' => 0]]; $newscomers = Newcomer::with('weiPayment', 'sandwichPayment', 'guaranteePayment')->get(); $students = Student::with('weiPayment', 'sandwichPayment', 'guaranteePayment')->get(); foreach ($newscomers as $newcomer) { if (!isset($result['newcomers'][$newcomer->branch])) { $result['newcomers'][$newcomer->branch] = []; $result['newcomers'][$newcomer->branch]['wei'] = 0; $result['newcomers'][$newcomer->branch]['sandwitch'] = 0; $result['newcomers'][$newcomer->branch]['guarantee'] = 0; } if (isset($newcomer->weiPayment) && $newcomer->weiPayment->state == 'paid') { $result['newcomers'][$newcomer->branch]['wei'] += 1; } if (isset($newcomer->sandwichPayment) && $newcomer->sandwichPayment->state == 'paid') { $result['newcomers'][$newcomer->branch]['sandwitch'] += 1; } if (isset($newcomer->guaranteePayment) && $newcomer->guaranteePayment->state == 'paid') { $result['newcomers'][$newcomer->branch]['guarantee'] += 1; } } foreach ($students as $student) { $ret =& $result['vieux']; if ($student->ce && $student->team_accepted && $student->team_id) { $ret =& $result['ce']; } elseif ($student->orga) { $ret =& $result['orga']; } if (isset($student->weiPayment) && $student->weiPayment->state == 'paid') { $ret['wei'] += 1; } if (isset($student->sandwichPayment) && $student->sandwichPayment->state == 'paid') { $ret['sandwitch'] += 1; } if (isset($student->guaranteePayment) && $student->guaranteePayment->state == 'paid') { $ret['guarantee'] += 1; } } $graphPaid = Payment::select(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\') as day'), DB::raw('COUNT(id) as sum'))->where('type', 'payment')->where('state', 'paid')->where('amount', '>', 325)->orderBy('created_at')->groupBy(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\')'))->get(); $graphCaution = Payment::select(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\') as day'), DB::raw('COUNT(id) as sum'))->where('type', 'guarantee')->where('state', 'paid')->orderBy('created_at')->groupBy(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\')'))->get(); $graphFood = Payment::select(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\') as day'), DB::raw('COUNT(id) as sum'))->where('type', 'payment')->where(DB::raw('`amount`%500'), 325)->where('state', 'paid')->orderBy('created_at')->groupBy(DB::raw('DATE_FORMAT(created_at,\'%d-%m-%Y\')'))->get(); $sum = ['paid' => array_sum(array_column($graphPaid->toArray(), 'sum')), 'caution' => array_sum(array_column($graphCaution->toArray(), 'sum')), 'food' => array_sum(array_column($graphFood->toArray(), 'sum'))]; return View::make('dashboard.wei.graph', ['graphPaid' => $graphPaid, 'graphCaution' => $graphCaution, 'graphFood' => $graphFood, 'sum' => $sum, 'global' => $result]); }
/** * @param Request $request * @return \Illuminate\Http\RedirectResponse|void */ public function getResult(Request $request) { if ($_SERVER['REMOTE_ADDR'] != '37.59.221.230') { return; } //dd(\Request::all()); $m_key = 'halyava'; $m_shop = $request->get('m_shop'); $m_orderid = $request->get('m_orderid'); $m_amount = $request->get('m_amount'); $m_curr = $request->get('m_curr'); $m_desc = $request->get('m_desc'); $checksum = $request->get('m_sign'); $user = Payment::select('user_id')->where('uid', '=', $m_orderid)->first(); if (isset($_POST['m_operation_id']) && isset($checksum)) { $arHash = array($m_shop, $m_orderid, $m_amount, $m_curr, $m_desc, $m_key); $sign_hash = strtoupper(hash('sha256', implode(':', $arHash))); if ($checksum == $sign_hash && $_POST['m_status'] == 'success') { if (Payment::where('uid', '=', $m_orderid) && Payment::where('balance', '=', $m_amount)) { try { DB::beginTransaction(); $payment = Payment::where('uid', '=', $m_orderid)->first(); if ($payment->status == 0) { $payment->status = 1; $payment->update(); $addBalanceToUser = User::find($user->user_id); $addBalanceToUser->balance += $m_amount; $addBalanceToUser->update(); } DB::commit(); } catch (\PDOException $e) { \Session::flash('message', "{$e->getMessage}()"); DB::connection()->getPdo()->rollBack(); } } } } return redirect()->action('ProfileController@index'); }