public function winnings()
 {
     if (ACL::checkUserPermission('reports.winnings') == false) {
         return Redirect::action('dashboard');
     }
     $game_winnings = Gamewinnings::with('channel.tabledetails.operator')->get();
     $title = Lang::get('Winning Numbers');
     $data = array('acl' => ACL::buildACL(), 'winnings' => $game_winnings, 'title' => $title);
     return View::make('reports/winnings', $data);
 }
 public function winnings()
 {
     //retrieve POST value
     $param = Input::only('gameid', 'winning_number');
     $rules = array('gameid' => 'required|exists:game_channel,id', 'winning_number' => 'required|integer|between:0,36');
     //custom error messaging
     $messages = array('gameid.exists' => 'Game doesn\'t exist');
     $validator = Validator::make($param, $rules, $messages);
     if ($validator->passes()) {
         $gamewinnings = array('game_id' => 1, 'channel_id' => $param['gameid'], 'winning_number' => $param['winning_number']);
         $winnings = Gamewinnings::create($gamewinnings);
         Gamechannel::where('id', $param['gameid'])->update(array('channel_status' => 0));
         $bets = Gamebets::with('channel', 'payout')->where('channel_id', $param['gameid'])->get();
         $bet_win = array();
         foreach ($bets as $row) {
             $win = false;
             switch ($row->payout->name) {
                 case "straight":
                     if ($row->bet_number == $param['winning_number']) {
                         $win = true;
                     }
                     break;
                 case "split":
                     $numbers = explode(",", $row->bet_number);
                     if (in_array($param['winning_number'], $numbers)) {
                         $win = true;
                     }
                     break;
                 case "line":
                     $numbers = explode(",", $row->bet_number);
                     if (in_array($param['winning_number'], $numbers)) {
                         $win = true;
                     }
                     break;
                 case "square":
                     $numbers = explode(",", $row->bet_number);
                     if (in_array($param['winning_number'], $numbers)) {
                         $win = true;
                     }
                     break;
                 case "basket":
                     $numbers = explode(",", $row->bet_number);
                     if (in_array($param['winning_number'], $numbers)) {
                         $win = true;
                     }
                     break;
                 case "1stcolumn":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "2ndcolumn":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "3rdcolumn":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "1dozen":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "2dozen":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "3dozen":
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
                     break;
                 case "even":
                     if ($param['winning_number'] % 2 == 0) {
                         $win = true;
                     }
                     break;
                 case "odd":
                     if ($param['winning_number'] % 2 != 0) {
                         $win = true;
                     }
                     break;
                 default:
                     $numbers_covered = explode(',', $row->payout->numbers_covered);
                     if (in_array($param['winning_number'], $numbers_covered)) {
                         $win = true;
                     }
             }
             if ($win == true) {
                 $update = array('bet_result' => 'win', 'bet_status' => 0);
                 Gamebets::where('id', $row->id)->update($update);
                 $this->player_winnings($row->payout->payout, $row->player_id, $row->bet_amount, $row->channel->channel_id);
                 $bet_win[] = $row->id;
             } elseif ($win == false) {
                 $update = array('bet_result' => 'loss', 'bet_status' => 0);
                 Gamebets::where('id', $row->id)->update($update);
             }
         }
         if (count($bet_win) > 0) {
             $player_winnings = Gamebets::with('payout', 'playerdetails')->whereIn('id', $bet_win)->get();
             if (!empty($player_winnings->first())) {
                 $response = array('betwin' => true, 'message' => 'List of players who won.', 'data' => $player_winnings->toArray());
             }
         } else {
             $response = array('betwin' => false, 'message' => 'No player has won this game.');
         }
     } else {
         //All error message in validation
         $messages = $validator->messages();
         //response if merchant doesnt have list of products.
         $response = array('betwin' => 404, 'error' => 'not_found', 'error_message' => $messages->all());
     }
     echo json_encode($response);
 }