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 solved()
{
$p = $this->puzzle;
$guess_squares_db = PuzzleGuessSquare::where('puzzle_guess_id', $this->id)->orderBy('row')->orderBy('col')->get();
$guess_squares = array();
foreach ($guess_squares_db as $gs) {
$guess_squares[$gs->row . '-' . $gs->col] = array('letter' => $gs->letter);
}
$pss = $p->puzzle_squares(true);
foreach ($pss as $k => $ps) {
if ($ps['square_type'] != "black" && (!isset($guess_squares[$k]) || $guess_squares[$k]['letter'] != $ps['letter'])) {
return 0;
}
}
return 1;
}
