edittags.php 4.45 KB
Newer Older
Richard Mansfield's avatar
Richard Mansfield committed
1 2 3
<?php
/**
 * Mahara: Electronic portfolio, weblog, resume builder and social networking
4 5
 * Copyright (C) 2006-2009 Catalyst IT Ltd and others; see:
 *                         http://wiki.mahara.org/Contributors
Richard Mansfield's avatar
Richard Mansfield committed
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package    mahara
 * @subpackage core
 * @author     Catalyst IT Ltd
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL
24
 * @copyright  (C) 2006-2009 Catalyst IT Ltd http://catalyst.net.nz
Richard Mansfield's avatar
Richard Mansfield committed
25 26 27 28 29 30 31 32 33 34 35 36 37
 *
 */

define('INTERNAL', 1);
define('MENUITEM', 'myportfolio');
require('init.php');
require_once('pieforms/pieform.php');

define('TITLE', get_string('edittags'));

$tags = get_my_tags();

if ($tag = param_variable('tag', null)) {
38
    $edittagform = pieform(array(
Richard Mansfield's avatar
Richard Mansfield committed
39 40 41 42 43 44 45 46 47 48 49 50 51 52
        'name'     => 'edit_tag',
        'elements' => array(
            'tagname' => array(
                'type'         => 'text',
                'size'         => 30,
                'title'        => get_string('name'),
                'defaultvalue' => $tag,
                'rules'        => array('required' => true),
            ),
            'submit' => array(
                'type'         => 'submit',
                'value'        => get_string('submit'),
            ),
        ),
53 54
    ));
    $deletetagform = pieform(array(
Richard Mansfield's avatar
Richard Mansfield committed
55 56 57 58 59 60 61 62 63
        'name'     => 'delete_tag',
        'renderer' => 'oneline',
        'elements' => array(
            'submit' => array(
                'type'         => 'submit',
                'value'        => get_string('delete'),
                'confirm'      => get_string('confirmdeletetag'),
            ),
        ),
64
    ));
Richard Mansfield's avatar
Richard Mansfield committed
65 66 67
}

$smarty = smarty();
68
$smarty->assign('PAGEHEADING', TITLE);
Richard Mansfield's avatar
Richard Mansfield committed
69 70 71
$smarty->assign('tags', $tags);
if ($tag) {
    $smarty->assign('tag', $tag);
72
    $smarty->assign('tagsearchurl', get_config('wwwroot') . 'tags.php?tag=' . urlencode($tag));
73 74
    $smarty->assign('edittagform', $edittagform);
    $smarty->assign('deletetagform', $deletetagform);
Richard Mansfield's avatar
Richard Mansfield committed
75 76 77 78 79 80 81 82 83 84 85 86 87
}
$smarty->display('edittags.tpl');

function edit_tag_submit(Pieform $form, $values) {
    global $SESSION, $USER, $tag;
    if (!$userid = $USER->get('id')) {
        redirect(get_config('wwwroot') . 'edittags.php?tag=' . urlencode($tag));
    }
    if ($values['tagname'] == $tag) {
        redirect(get_config('wwwroot') . 'edittags.php?tag=' . urlencode($tag));
    }
    db_begin();
    execute_sql(
Francois Marier's avatar
Francois Marier committed
88
        "UPDATE {view_tag} SET tag = ? WHERE tag = ? AND \"view\" IN (SELECT id FROM {view} WHERE \"owner\" = ?)",
Richard Mansfield's avatar
Richard Mansfield committed
89 90
        array($values['tagname'], $tag, $userid)
    );
91 92 93 94
    execute_sql(
        "UPDATE {collection_tag} SET tag = ? WHERE tag = ? AND \"collection\" IN (SELECT id FROM {collection} WHERE \"owner\" = ?)",
        array($values['tagname'], $tag, $userid)
    );
Richard Mansfield's avatar
Richard Mansfield committed
95
    execute_sql(
Francois Marier's avatar
Francois Marier committed
96
        "UPDATE {artefact_tag} SET tag = ? WHERE tag = ? AND artefact IN (SELECT id FROM {artefact} WHERE \"owner\" = ?)",
Richard Mansfield's avatar
Richard Mansfield committed
97 98 99 100 101 102 103 104 105 106 107 108 109 110
        array($values['tagname'], $tag, $userid)
    );
    db_commit();
    $SESSION->add_ok_msg(get_string('tagupdatedsuccessfully'));
    redirect(get_config('wwwroot') . 'tags.php?tag=' . urlencode($values['tagname']));
}

function delete_tag_submit(Pieform $form, $values) {
    global $SESSION, $USER, $tag;
    if (!$userid = $USER->get('id')) {
        redirect(get_config('wwwroot') . 'edittags.php?tag=' . urlencode($tag));
    }
    db_begin();
    execute_sql(
Francois Marier's avatar
Francois Marier committed
111
        "DELETE FROM {view_tag} WHERE tag = ? AND view IN (SELECT id FROM {view} WHERE \"owner\" = ?)",
Richard Mansfield's avatar
Richard Mansfield committed
112 113
        array($tag, $userid)
    );
114 115 116 117
    execute_sql(
        "DELETE FROM {collection_tag} WHERE tag = ? AND collection IN (SELECT id FROM {collection} WHERE \"owner\" = ?)",
        array($tag, $userid)
    );
Richard Mansfield's avatar
Richard Mansfield committed
118
    execute_sql(
Francois Marier's avatar
Francois Marier committed
119
        "DELETE FROM {artefact_tag} WHERE tag = ? AND artefact IN (SELECT id FROM {artefact} WHERE \"owner\" = ?)",
Richard Mansfield's avatar
Richard Mansfield committed
120 121 122 123 124 125
        array($tag, $userid)
    );
    db_commit();
    $SESSION->add_ok_msg(get_string('tagdeletedsuccessfully'));
    redirect(get_config('wwwroot') . 'tags.php');
}