public function tallySheet($type)
{
$bets = Auth::user()->bets()->where('type', '=', $type)->whereHas('transaction', function ($transactionQuery) {
$startTime = Carbon::now()->hour(0)->minute(0)->second(0);
$endTime = Carbon::now()->hour(23)->minute(59)->second(59);
$transactionQuery->where('draw', '=', getDrawTime())->whereBetween('created_at', [$startTime, $endTime]);
})->groupBy('bet_number')->get([DB::raw('sum(bet_amount) as bet_amount'), 'bet_number', 'id', 'type', 'user_id']);
return $bets;
}
public function create($input)
{
$draw = getDrawTime();
$user = Auth::user();
foreach ($input as $type => $amount) {
$this->todayPrize($type, $draw)->delete();
$prize = new Prize(['amount' => $amount, 'type' => $type, 'draw' => $draw]);
$user->prizes()->save($prize);
}
}
/**
* Display a listing of the resource.
* GET /winningnumber
*
* @return Response
*/
public function index()
{
if (Request::get('draw') != '') {
$draw = Request::get('draw');
} else {
$draw = getDrawTime();
}
$date = Request::get('date');
$result = $this->winningNumberRepository->getWinners('last2', $draw, $date);
$result = $result->merge($this->winningNumberRepository->getWinners('last3', $draw, $date));
$result = $result->merge($this->winningNumberRepository->getWinners('fourdigit', $draw, $date));
$result = $result->merge($this->winningNumberRepository->getWinners('swertwo', $draw, $date));
$result = $result->merge($this->winningNumberRepository->getWinners('swertres', $draw, $date));
return $result;
}
public function create($input)
{
if (isset($input['draw'])) {
$draw = $input['draw'];
} else {
$draw = getDrawTime();
}
$date = $input['date'];
unset($input['draw']);
unset($input['date']);
foreach ($input as $type => $winning_number) {
$this->todayWinningNumber($type, $draw, $date)->delete();
$winningNumber = WinningNumber::create(['bet_number' => $winning_number, 'type' => $type, 'draw' => $draw]);
$winningNumber->created_at = $startTime = Carbon::parse($date)->hour(0)->minute(0)->second(1);
$winningNumber->save();
}
}
public function getBetByCurrentDraw($type)
{
$startTime = Carbon::now()->hour(0)->minute(0)->second(0);
$endTime = Carbon::now()->hour(23)->minute(59)->second(59);
return Bet::where('type', '=', $type)->where('draw', '=', getDrawTime())->whereBetween('created_at', [$startTime, $endTime])->get();
}
/**
* Get todays prize by admin
*/
public function todayPrize()
{
$draw = getDrawTime();
$last2 = $this->prizeRepository->todayPrize('last2', $draw)->first();
$last3 = $this->prizeRepository->todayPrize('last3', $draw)->first();
$fourdigit = $this->prizeRepository->todayPrize('fourdigit', $draw)->first();
$swertwo = $this->prizeRepository->todayPrize('swertwo', $draw)->first();
$swertres = $this->prizeRepository->todayPrize('swertres', $draw)->first();
return compact('last2', 'last3', 'fourdigit', 'swertwo', 'swertres');
}
/**
* Tally sheet for printing
*/
public function tallySheetPrinting($type)
{
$tallySheet = $this->transactionRepository->tallySheet($type);
$user = Auth::user();
$draw = getDrawTime();
$date = date('F d Y');
return View::make('transactions.tally-sheet', compact('tallySheet', 'user', 'draw', 'date'));
}
/**
* Update the specified resource in storage.
* PUT /bet/{id}
*
* @param int $id
* @return Response
*/
public function update($id)
{
$input = Input::all();
$input['draw'] = getDrawTime();
try {
if ($input['type'] == 'last2') {
$this->last2Form->validate($input);
} elseif ($input['type'] == 'last3') {
$this->last3Form->validate($input);
} elseif ($input['type'] == 'fourdigit') {
$this->fourDigitForm->validate($input);
} elseif ($input['type'] == 'swertwo') {
$this->swerTwoForm->validate($input);
} elseif ($input['type'] == 'swertres') {
$this->swerTresForm->validate($input);
}
} catch (Laracasts\Validation\FormValidationException $error) {
$result = 'error';
if ($input['type'] == 'last2') {
$errors = $this->last2Form->getValidationErrors();
} elseif ($input['type'] == 'last3') {
$errors = $this->last3Form->getValidationErrors();
} elseif ($input['type'] == 'fourdigit') {
$errors = $this->fourDigitForm->getValidationErrors();
} elseif ($input['type'] == 'swertwo') {
$errors = $this->swerTwoForm->getValidationErrors();
} elseif ($input['type'] == 'swertres') {
$errors = $this->swerTresForm->getValidationErrors();
}
return compact('result', 'errors');
}
if ($input['type'] == 'fourdigit') {
if (strlen($input['bet_number']) == 2) {
$input['type'] = 'last2';
} elseif (strlen($input['bet_number']) == 3) {
$input['type'] = 'last3';
} else {
$input['type'] = 'fourdigit';
}
}
if ($input['type'] == 'swertres') {
if (strlen($input['bet_number']) == 2) {
$input['type'] = 'swertwo';
} else {
$input['type'] = 'swertres';
}
}
$limit = $this->betLimitRepository->byBetNumber($input['bet_number']);
if (isset($limit)) {
$startTime = Carbon::now()->hour(0)->minute(0)->second(0);
$endTime = Carbon::now()->hour(23)->minute(59)->second(59);
$total = DB::table('bets')->where('bet_number', '=', $input['bet_number'])->whereBetween('created_at', [$startTime, $endTime])->where('id', '!=', $id)->where('draw', '=', $input['draw'])->sum('bet_amount');
$total += $input['bet_amount'];
if ($total > $limit->bet_amount) {
$result = 'error';
$errors = ['bet_amount' => ['\'' . $input['bet_number'] . '\' is sold out.']];
return compact('result', 'errors');
}
}
$result = 'success';
$bet = $this->betRepository->update($id, $input);
return compact('result', 'bet');
}
return '';
} elseif ($currentDate >= strtotime(date('Y-m-d 15:45:00')) && $currentDate <= strtotime(date('Y-m-d 16:30:00'))) {
return '';
} elseif ($currentDate >= strtotime(date('Y-m-d 20:55:00')) && $currentDate <= strtotime(date('Y-m-d 23:59:59'))) {
return '';
} elseif ($currentDate >= strtotime(date('Y-m-d 00:00:01')) && $currentDate <= strtotime(date('Y-m-d 06:00:00'))) {
return '';
}
});
/*
|--------------------------------------------------------------------------
| Route for 9pm
|--------------------------------------------------------------------------
*/
Route::filter('9pm', function () {
if (getDrawTime() != '9PM') {
return '';
}
});
/*
|--------------------------------------------------------------------------
| Draw Filter full day draw
|--------------------------------------------------------------------------
*/
Route::filter('drawday', function () {
$currentDate = strtotime(date('Y-m-d H:i:s'));
if ($currentDate >= strtotime(date('Y-m-d 20:55:00')) && $currentDate <= strtotime(date('Y-m-d 23:59:59'))) {
return '';
} elseif ($currentDate >= strtotime(date('Y-m-d 00:00:01')) && $currentDate <= strtotime(date('Y-m-d 06:00:00'))) {
return '';
}
