/** Crosswords management.
*/
function crossword($crossword = null, $operation = null)
{
if ('save' === $operation) {
OutputModes('ajax');
}
if (!CheckPermissions('office')) {
return;
}
if (null !== $crossword && is_numeric($crossword)) {
$crossword = (int) $crossword;
$crosswords = $this->crosswords_model->GetCrosswords($crossword);
if (count($crosswords) === 0) {
show_404();
}
$crossword_info = $crosswords[0];
$this->load->model('permissions_model');
$data = array('Permissions' => array('modify' => $this->permissions_model->hasUserPermission('CROSSWORD_MODIFY'), 'stats_basic' => $this->permissions_model->hasUserPermission('CROSSWORD_STATS_BASIC')), 'Crossword' => &$crossword_info);
if (null === $operation) {
if (!CheckRolePermissions('CROSSWORD_VIEW')) {
return;
}
$puzzle = 0;
$worked = $this->crosswords_model->LoadCrossword($crossword_info['id'], $puzzle);
if (!$worked) {
show_404();
}
$crosswordView = new CrosswordView($puzzle);
$crosswordView->setClueTypes($crossword_info['has_quick_clues'], $crossword_info['has_cryptic_clues']);
$crosswordView->setReadOnly(true, true);
$data['Grid'] =& $crosswordView;
$data['Tips'] = new CrosswordTipsList(null, $crossword_info['id'], true, false);
$this->pages_model->SetPageCode('crosswords_office_xword_view');
$this->main_frame->SetContentSimple('crosswords/office/crossword_view', $data);
} else {
if ('save' === $operation) {
if (!CheckRolePermissions('CROSSWORD_VIEW', 'CROSSWORD_MODIFY')) {
return;
}
if (isset($_POST['xw']['save'])) {
$puzzle = new CrosswordPuzzle();
$worked = $puzzle->importData($_POST['xw']);
if ($worked) {
$this->crosswords_model->SaveCrossword($crossword, $puzzle);
$status = 'success';
} else {
$this->main_frame->Error(array('class' => 'error', 'text' => 'Invalid crossword data.'));
$status = 'fail';
}
} else {
$this->main_frame->Error(array('class' => 'error', 'text' => 'Unable to edit crossword.'));
$status = 'fail';
}
$root = array('_tag' => 'crossword', 'status' => $status);
$this->main_frame->SetXml($root);
$this->main_frame->Load();
return;
} else {
if ('edit' === $operation) {
if (!CheckRolePermissions('CROSSWORD_VIEW', 'CROSSWORD_MODIFY')) {
return;
}
$this->pages_model->SetPageCode('crosswords_office_xword_edit');
$this->load->helper('input_date');
$this->load->helper('input_progress');
$puzzle = 0;
$worked = $this->crosswords_model->LoadCrossword($crossword, $puzzle);
if (!$worked) {
$puzzle = new CrosswordPuzzle(13, 13);
}
$crosswordView = new CrosswordView($puzzle, true);
$data = array();
// MAIN CONFIGURATION
$config = new InputInterfaces();
$quick_clues_interface = new InputCheckboxInterface('has_quick_clues', $crossword_info['has_quick_clues']);
$config->Add('Quick clues', $quick_clues_interface);
$cryptic_clues_interface = new InputCheckboxInterface('has_cryptic_clues', $crossword_info['has_cryptic_clues']);
$config->Add('Cryptic Clues', $cryptic_clues_interface);
$categories = $this->crosswords_model->GetAllCategories();
$category_names = array();
foreach ($categories as $id => $category) {
$category_names[$id] = $category['name'];
}
$category_interface = new InputSelectInterface('category_id', $crossword_info['category_id']);
$category_interface->SetOptions($category_names);
$config->Add('Category', $category_interface);
$layouts = $this->crosswords_model->GetAllLayouts();
$layout_names = array();
foreach ($layouts as $id => $layout) {
$layout_names[$id] = $layout['name'];
}
$layout_interface = new InputSelectInterface('layout_id', $crossword_info['layout_id']);
$layout_interface->SetOptions($layout_names);
$config->Add('Layout', $layout_interface);
$deadline_interface = new InputDateInterface('deadline', $crossword_info['deadline'], true);
$config->Add('Deadline', $deadline_interface);
$publication_interface = new InputDateInterface('publication', $crossword_info['publication'], true);
$config->Add('Publication', $publication_interface);
$expiry_interface = new InputDateInterface('expiry', $crossword_info['expiry'], true);
$config->Add('Expiry', $expiry_interface);
$winners_value = $crossword_info['winners'];
$winners_interface = new InputIntInterface('winners', $winners_value, $winners_value > 0);
$winners_interface->SetRange(1, 100);
$config->Add('Winners', $winners_interface);
$completeness_interface = new InputProgressInterface('completeness', $crossword_info['completeness']);
$config->Add('Progress', $completeness_interface);
$authors_interface = new InputSelectInterface('authors', $crossword_info['author_ids']);
$authors = $this->crosswords_model->GetAllAuthors();
$author_options = array();
foreach ($authors as $author) {
$author_options[(int) $author['id']] = $author['fullname'];
}
foreach ($crossword_info['authors'] as $author) {
if (!isset($author_options[$author['id']])) {
$author_options[$author['id']] = $author['fullname'];
}
}
$authors_interface->SetOptions($author_options);
$config->Add('Authors', $authors_interface);
// VALIDATION
$num_errors = $config->Validate();
if (0 == $num_errors && $config->Updated()) {
$values = $config->ChangedValues();
$error = false;
if (count($values) == 0) {
$this->messages->AddMessage('information', "You did not make any changes");
$error = true;
}
// Apply rules to changes here
$integrated_values = $crossword_info;
foreach ($values as $id => $value) {
$integrated_values[$id] = $value;
}
// can't have deadline after publishing
if ($integrated_values['deadline'] !== null && $integrated_values['publication'] !== null && $integrated_values['deadline'] > $integrated_values['publication']) {
$this->messages->AddMessage('error', 'Deadline should not be set after publication');
$error = true;
}
// can't have expiry before publishing
if ($integrated_values['publication'] !== null && $integrated_values['expiry'] !== null && $integrated_values['publication'] > $integrated_values['expiry']) {
$this->messages->AddMessage('error', 'Expiry should not be set before publication');
$error = true;
}
if (!$error) {
if (isset($values['authors'])) {
$authors = $values['authors'];
$values['authors'] = array();
foreach ($authors as $author_id) {
$values['authors'][(int) $author_id] = array('id' => (int) $author_id, 'fullname' => $author_options[(int) $author_id]);
}
}
$values['id'] = $crossword_info['id'];
if (!$this->crosswords_model->UpdateCrossword($values)) {
$this->messages->AddMessage('error', 'Changes could not be saved');
} else {
$this->messages->AddMessage('success', 'Changes have been saved successfully');
foreach ($values as $id => $value) {
$crossword_info[$id] = $value;
}
}
}
}
// Which clues are enabled may have just changed
$crosswordView->setClueTypes($crossword_info['has_quick_clues'], $crossword_info['has_cryptic_clues']);
$data['Configuration'] =& $config;
$data['Tips'] = new CrosswordTipsList(null, $crossword_info['id'], true);
$data['Grid'] =& $crosswordView;
$data['Paths'] = array('view' => site_url("office/crosswords/crossword/{$crossword}"), 'save' => site_url("office/crosswords/crossword/{$crossword}/save"));
$this->main_frame->SetContentSimple('crosswords/office/crossword_edit', $data);
} else {
if ('stats' === $operation) {
if (!CheckRolePermissions('CROSSWORD_STATS_BASIC')) {
return;
}
// find information about this crossword
$data['Stats'] = $this->crosswords_model->CalculateStats($crossword_info['id'], array('saves', 'save_users'));
$data['Stats']['winners'] = $crossword_info['winners_so_far'];
$data['StatLabels'] = array('save_users' => 'Number of users who have attempted crossword (based on saves)', 'save_mean_per_user' => 'Mean number of saves per user (approx 30 secs between saves)', 'winners' => 'Number of winners');
$this->main_frame->SetContentSimple('crosswords/office/crossword_stats', $data);
} elseif ($operation == 'preview') {
if (!CheckRolePermissions('CROSSWORD_VIEW')) {
return;
}
$this->crosswords_model->GetCrosswordThumbnail($crossword);
return;
} else {
show_404();
}
}
}
}
} else {
show_404();
}
$this->main_frame->Load();
}
/** Load a crossword.
* @param $crossword_id int Id of crossword.
* @param $puzzle CrosswordPuzzle Puzzle to load into.
* @return bool true if successful.
*/
function LoadCrossword($crossword_id, &$puzzle)
{
// First get dimentions
$sql = 'SELECT `crossword_width` AS width, ' . ' `crossword_height` AS height ' . 'FROM `crosswords` ' . 'WHERE `crossword_id` = ?';
$bind = array($crossword_id);
$results = $this->db->query($sql, $bind)->result_array();
if (count($results) === 0) {
return false;
}
// Set up the result
$width = (int) $results[0]['width'];
$height = (int) $results[0]['height'];
$puzzle = new CrosswordPuzzle($width, $height);
// Get the lights
$sql = 'SELECT `crossword_light_posx` AS posx, ' . ' `crossword_light_posy` AS posy, ' . ' `crossword_light_orientation` AS orientation, ' . ' `crossword_light_solution` AS solution, ' . ' `crossword_light_normal_clue` AS quickClue, ' . ' `crossword_light_cryptic_clue` AS crypticClue ' . 'FROM `crossword_lights` ' . 'WHERE `crossword_light_crossword_id` = ?';
// Use bind from above
$results = $this->db->query($sql, $bind)->result_array();
foreach ($results as &$result) {
$puzzle->addLight((int) $result['posx'], (int) $result['posy'], $result['orientation'] == 'horizontal' ? CrosswordGrid::$HORIZONTAL : CrosswordGrid::$VERTICAL, new CrosswordClue($result['solution'], $result['quickClue'], $result['crypticClue']));
}
return true;
}