Beispiel #1
0
<?php

/*!
 * Traq Lite
 * Copyright (c) 2009-2016 Jack P.
 * https://github.com/nirix/traq-lite
 *
 * Licensed under the BSD 3-Clause license.
 */
use Traq\Models\Component;
$component = new Component();
if (Request::$method == 'POST') {
    $component->set(['name' => Request::$post['name'], 'project_id' => Request::$post['project_id']]);
    if ($component->validate()) {
        db()->beginTransaction();
        $query = db()->prepare('INSERT INTO ' . PREFIX . 'components (name, project_id) VALUES(:name, :project_id)');
        $query->bindValue(':name', $component['name']);
        $query->bindValue(':project_id', $component['project_id'], PDO::PARAM_INT);
        $query->execute();
        db()->commit();
        return redirect('/admin/components');
    }
}
return view('admin/components/new.phtml', ['component' => $component]);
Beispiel #2
0
<?php

/*!
 * Traq Lite
 * Copyright (c) 2009-2016 Jack P.
 * https://github.com/nirix/traq-lite
 *
 * Licensed under the BSD 3-Clause license.
 */
use Traq\Models\Component;
$query = db()->prepare('SELECT * FROM ' . PREFIX . 'components WHERE id = ? LIMIT 1');
$query->bindValue(1, Request::$properties['id']);
$query->execute();
$component = $query->fetch();
if (!$component) {
    return show404();
}
$component = new Component($component);
if (Request::$method == 'POST') {
    $component->set(['name' => Request::$post['name'], 'slug' => Request::$post['slug'], 'description' => Request::$post['description'], 'display_order' => Request::$post['display_order']]);
    if ($component->validate()) {
        db()->beginTransaction();
        $query = db()->prepare('UPDATE ' . PREFIX . 'components SET name = :name WHERE id = :id LIMIT 1');
        $query->bindValue(':id', $component['id'], PDO::PARAM_INT);
        $query->bindValue(':name', $component['name']);
        $query->execute();
        db()->commit();
        return redirect('/admin/components');
    }
}
return view('admin/components/edit.phtml', ['component' => $component]);