public static function replace(array $args = array()) { $v = new PuzzleGuessSquare(); if ($v->validate($args)) { $puzzle_guess = PuzzleGuess::whereRaw('puzzle_id in (select id from puzzles where slug = ?)', array($args['puzzle_slug']))->where('user_id', $args['user_id'])->first(); $p = Puzzle::where('slug', $args['puzzle_slug'])->first(); if (!$puzzle_guess) { $puzzle_guess = new PuzzleGuess(); $puzzle_guess->user_id = $args['user_id']; $puzzle_guess->puzzle_id = $p->id; $puzzle_guess->created_timestamp_utc = time(); } if ($puzzle_guess->solved()) { return array('errors' => array('This puzzle is already solved')); } $puzzle_guess->updated_timestamp_utc = time(); $puzzle_guess->save(); $pgs = PuzzleGuessSquare::where('puzzle_guess_id', $puzzle_guess->id)->where('row', $args['row'])->where('col', $args['col'])->first(); if (!$pgs) { $pgs = new PuzzleGuessSquare(); $pgs->puzzle_guess_id = $puzzle_guess->id; $pgs->row = $args['row']; $pgs->col = $args['col']; } $pgs->timestamp_utc = time(); if (isset($args['letter'])) { $pgs->letter = $args['letter']; } $pgs->save(); $pgs['solved'] = $puzzle_guess->solved(); return $pgs; } else { return array('errors' => $v->errors); } }
public function guess_squares($user_id = 0) { $ps = PuzzleGuess::where('puzzle_id', $this->id)->where('user_id', $user_id)->first(); if (!$ps) { return array(); } else { $pgs = PuzzleGuessSquare::where('puzzle_guess_id', $ps->id)->orderBy('col')->orderBy('row')->get(); $ret = array(); foreach ($pgs as $pg) { $ret[$pg->row . '-' . $pg->col] = array('letter' => $pg->letter); } return $ret; } }
public function getPuzzle($slug) { $p = Puzzle::with('clues')->whereNull('puzzles.deleted_timestamp_utc')->with('puzzle_template')->where('slug', $slug)->first(); if (!$p) { $returnData = array('errors' => array('Puzzle not available')); return response()->json($returnData, 401); //return array('errors' => array('Puzzle not available')); } $p->clue_squares = $p->puzzle_template->clueSquares(); $p->puzzle_squares = $p->puzzle_squares(false); $template_owner = User::find($p->puzzle_template->user_id); $p->puzzle_template->owner = $template_owner->name; $p->puzzle_template->owner_username = $template_owner->username; $puzzle_owner = User::find($p->user_id); $p->owner = $puzzle_owner->name; $p->owner_username = $puzzle_owner->username; $user = Auth::user(); if ($user) { $guess = PuzzleGuess::where('puzzle_id', $p->id)->where('user_id', $user->id)->first(); if ($guess) { $p->solved = $guess->solved(); } else { $p->solved = 0; } $p->guess_squares = $p->guess_squares($user->id); } else { $p->solved = 0; $p->guess_squares = array(); } return $p; }