public function action_edit_page()
{
$id = $this->request->param('options');
$content_page = new Content_Page($id);
if ($content_page->get_page_id()) {
$this->xml_content_page = $this->xml_content->appendChild($this->dom->createElement('page'));
// Get all tags associated with pages and images
$this->xml_content_tags = $this->xml_content->appendChild($this->dom->createElement('tags'));
$tags = array();
foreach (Content_Page::get_tags() as $tag) {
$tags[] = $tag;
}
foreach (Content_Image::get_tags() as $tag) {
foreach ($tags as $tag_to_check) {
if ($tag_to_check['name'] == $tag['name']) {
break 2;
}
}
$tags[] = $tag;
}
foreach ($tags as $tag) {
$tag_node = $this->xml_content_tags->appendChild($this->dom->createElement('tag', $tag['name']));
$tag_node->setAttribute('id', $tag['id']);
}
if (count($_POST) && isset($_POST['URI']) && isset($_POST['name'])) {
if ($_POST['URI'] == '') {
$_POST['URI'] = $_POST['name'];
}
$_POST['URI'] = URL::title($_POST['URI'], '-', TRUE);
$post = new Validation($_POST);
$post->filter('trim');
$post->rule('Valid::not_empty', 'name');
if ($post->validate()) {
$post_values = $post->as_array();
$current_page_data = $content_page->get_page_data();
if ($post_values['name'] != $current_page_data['name'] && !Content_Page::page_name_available($post_values['name'])) {
$post->add_error('name', 'Content_Page::page_name_available');
}
if ($post_values['URI'] != $current_page_data['URI'] && !Content_Page::page_URI_available($post_values['URI'])) {
$post->add_error('URI', 'Content_Page::page_URI_available');
}
}
// Retry
if ($post->validate()) {
$tags = array();
foreach ($post_values['template_position'] as $nr => $template_position) {
if ($post_values['tag_id'][$nr] > 0) {
if (!isset($tags[$template_position])) {
$tags[$template_position] = array();
}
$tags[$template_position][] = $post_values['tag_id'][$nr];
}
}
$content_page->update_page_data($post_values['name'], $post_values['URI'], $tags);
$this->add_message('Page "' . $post_values['name'] . '" updated');
$page_data = $content_page->get_page_data();
unset($page_data['tag_ids']);
$this->set_formdata($page_data);
} else {
$this->add_error('Fix errors and try again');
$this->add_form_errors($post->errors());
// Fix template position data
$tmp_node = $this->xml_content->appendChild($this->dom->createElement('tmp'));
foreach ($post_values['template_position'] as $nr => $template_position) {
$template_field_node = $tmp_node->appendChild($this->dom->createElement('template_field'));
$template_field_node->setAttribute('id', $template_position);
if ($post_values['tag_id'][$nr] > 0) {
$tag_node = $template_field_node->appendChild($this->dom->createElement('tag'));
$tag_node->setAttribute('id', $post_values['tag_id'][$nr]);
}
}
unset($post_values['template_position'], $post_values['tag_id']);
$this->set_formdata($post_values);
}
} else {
$page_data = $content_page->get_page_data();
unset($page_data['tag_ids']);
$this->set_formdata($page_data);
}
/**
* Put the page data to the XML
*
*/
$page_data = $content_page->get_page_data();
$page_data['template_fields'] = array();
foreach ($page_data['tag_ids'] as $template_field_id => $tag_ids) {
$page_data['template_fields'][$template_field_id . 'template_field'] = array('@id' => $template_field_id);
foreach ($tag_ids as $tag_id) {
$page_data['template_fields'][$template_field_id . 'template_field'][$tag_id . 'tag'] = array('@id' => $tag_id);
}
}
// Unset this, or it will cludge our XML
unset($page_data['tag_ids']);
// Set the page data to the page node
xml::to_XML($page_data, $this->xml_content_page, NULL, 'id');
} else {
$this->redirect();
}
}
public function update_page_data($id, $name = FALSE, $URI = FALSE, $tags = FALSE)
{
// Nothing to update
if ($name === FALSE && $URI === FALSE && $tags === FALSE) {
return TRUE;
}
if (!($current_page_data = $this->get_page_data($id))) {
return FALSE;
}
// Check if there is something to update in the content_pages table
if ($name && $current_page_data['name'] != $name || $URI && $current_page_data['URI'] != $URI) {
$sql = 'UPDATE content_pages SET ';
if ($name && $current_page_data['name'] != $name) {
if ($this->page_name_available($name)) {
$sql .= 'name = ' . $this->pdo->quote($name) . ', ';
} else {
return FALSE;
}
}
if ($URI && $current_page_data['URI'] != $URI) {
if (Content_Page::page_URI_available($URI)) {
$sql .= 'URI = ' . $this->pdo->quote($URI) . ', ';
} else {
return FALSE;
}
}
// Finalize and run the query to the content_pages table
$sql = substr($sql, 0, strlen($sql) - 2) . ' WHERE id = ' . $this->pdo->quote($id);
$this->pdo->exec($sql);
}
// Check if there is something to update in the types connection table
if (is_array($tags)) {
// First remove all the old ones
$this->pdo->exec('DELETE FROM content_pages_tags WHERE page_id = ' . $this->pdo->quote($id));
if (count($tags)) {
// Then add the new ones
$sql = 'INSERT INTO content_pages_tags (page_id, tag_id, template_field_id) VALUES';
foreach ($tags as $template_field_id => $tag_ids) {
foreach ($tag_ids as $tag_id) {
$sql .= '(' . $this->pdo->quote($id) . ',' . $this->pdo->quote($tag_id) . ',' . $this->pdo->quote($template_field_id) . '),';
}
}
$this->pdo->exec(substr($sql, 0, strlen($sql) - 1));
}
}
return TRUE;
}