DaPortal

Browse Download file Permalink

<?php //$Id$

//This file is part of DeforaOS Web DaPortal

//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, version 3 of the License.

//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/>.

//BugProjectContent

class BugProjectContent extends ContentMulti

{

//public

//methods

//essential

//BugProjectContent::BugProjectContent

public function __construct(Engine $engine, Module $module,

$properties = FALSE)

{

$this->fields['project_id'] = 'project ID';

$this->fields['bug_id'] = 'bug #';

$this->fields['state'] = 'state';

$this->fields['type'] = 'type';

$this->fields['priority'] = 'priority';

$this->fields['assigned'] = 'assigned';

if($properties === FALSE)

$properties = array();

if(!isset($properties['state']))

$properties['state'] = 'New';

parent::__construct($engine, $module, $properties);

if(($project_id = $this->get('project_id')) !== FALSE)

$this->project = ProjectContent::load($engine,

$module, $project_id);

//translations

$this->text_content_by = _('Bug report from');

$this->text_content_list_title = _('Bug reports');

$this->text_more_content = _('More reports...');

$this->text_submit = _('Report bug...');

self::$priorities['Urgent'] = _('Urgent');

self::$priorities['High'] = _('High');

self::$priorities['Medium'] = _('Medium');

self::$priorities['Low'] = _('Low');

self::$states['Assigned'] = _('Assigned');

self::$states['Closed'] = _('Closed');

self::$states['Fixed'] = _('Fixed');

self::$states['Implemented'] = _('Implemented');

self::$states['New'] = _('New');

self::$states['Re-opened'] = _('Re-opened');

self::$types['Major'] = _('Major');

self::$types['Minor'] = _('Minor');

self::$types['Functionality'] = _('Functionality');

self::$types['Feature'] = _('Feature');

}

//accessors

//BugProjectContent::getBugReplies

public function getBugReplies(Engine $engine)

{

return BugReplyProjectContent::listByBugID($engine,

$this->getModule(), $this->get('bug_id'));

}

//BugProjectContent::getColumns

static public function getColumns()

{

return array('title' => _('Title'),

'bug_id' => _('ID'), 'project' => _('Project'),

'date' => _('Date'), 'state' => _('State'),

'type' => _('Type'), 'priority' => _('Priority'));

}

//BugProjectContent::getRequest

public function getRequest($action = FALSE, $parameters = FALSE)

{

return new Request($this->getModule()->getName(), $action,

$this->getID(), parent::getTitle(), $parameters);

}

//BugProjectContent::getTitle

public function getTitle()

{

$title = ($this->project !== FALSE)

? $this->project->getTitle().'/' : '';

return $title.'#'.$this->get('bug_id').': '.parent::getTitle();

}

//BugProjectContent::set

public function set($name, $value)

{

switch($name)

{

case 'priority':

if(!array_key_exists($value, self::$priorities))

return FALSE;

break;

case 'state':

if(!array_key_exists($value, self::$states))

return FALSE;

break;

case 'bug_type':

//XXX workaround for the ContentMulti class

$name = 'type';

case 'type':

if(!array_key_exists($value, self::$types))

return FALSE;

break;

}

return parent::set($name, $value);

}

//useful

//BugProjectContent::display

public function display(Engine $engine, Request $request = NULL)

{

$ret = parent::display($engine, $request);

//FIXME list the replies above the buttons

$ret->append($this->displayReplies($engine, $request));

return $ret;

}

//BugProjectContent::displayContent

public function displayContent(Engine $engine, Request $request)

{

$text = HTML::format($engine, $this->getContent($engine));

return new PageElement('htmlview', array('text' => $text));

}

//BugProjectContent::displayReplies

public function displayReplies(Engine $engine, Request $request)

{

$error = _('Could not list the replies');

if(($replies = $this->getBugReplies($engine)) === FALSE)

return new PageElement('dialog', array(

'type' => 'error', 'text' => $error));

$columns = array('title' => _('Title'),

'username' => _('Username'), 'date' => _('Date'),

'preview' => _('Preview'));

$view = new PageElement('treeview', array('view' => 'preview',

'columns' => $columns));

foreach($replies as $r)

$view->append('row', array(

'username' => $r->getUsername(),

'date' => $r->getDate(),

'preview' => $r->displayContent($engine,

$request)));

return $view;

}

//BugProjectContent::displayRow

public function displayRow(Engine $engine, Request $request = NULL)

{

$project = ProjectContent::load($engine, $this->getModule(),

$this->get('project_id'));

$row = parent::displayRow($engine, $request);

$request = $this->getRequest();

$link = new PageElement('link', array('request' => $request,

'text' => '#'.$this->get('bug_id'),

'title' => $this->getTitle()));

$row->set('bug_id', $link);

$row->set('id', 'bug_id:'.$this->getID());

if($project !== FALSE)

{

$request = $project->getRequest();

$link = new PageElement('link', array(

'stock' => $this->getModule()->getName(),

'request' => $request,

'text' => $project->getTitle(),

'title' => $project->get('synopsis')));

$row->set('project', $link);

}

$row->set('state', $this->get('state'));

$row->set('type', $this->get('type'));

$row->set('priority', $this->get('priority'));

return $row;

}

//BugProjectContent::displayToolbar

public function displayToolbar(Engine $engine, Request $request = NULL)

{

if($this->project !== FALSE)

return $this->project->displayToolbar($engine,

$request);

return FALSE;

}

//BugProjectContent::form

public function form(Engine $engine, Request $request)

{

return parent::form($engine, $request);

}

protected function _formSubmit(Engine $engine, Request $request)

{

$vbox = new PageElement('vbox');

$vbox->append('entry', array('name' => 'title',

'text' => _('Title: '),

'value' => $request->getParameter('title')));

$vbox->append('textview', array('name' => 'content',

'text' => _('Description: '),

'value' => $request->getParameter('content')));

//type

$combobox = $vbox->append('combobox', array(

'name' => 'bug_type',

'text' => _('Type: '),

'value' => $request->get('bug_type')));

foreach(self::$types as $value => $text)

$combobox->append('label', array('value' => $value,

'text' => $text));

//priority

$combobox = $vbox->append('combobox', array(

'name' => 'priority',

'text' => _('Priority: '),

'value' => $request->get('priority')));

foreach(self::$priorities as $value => $text)

$combobox->append('label', array('value' => $value,

'text' => $text));

return $vbox;

}

//BugProjectContent::loadFromBugID

static public function loadFromBugID(Engine $engine, Module $module,

$bug_id)

{

//XXX duplicated from Content::_load()

$database = $engine->getDatabase();

$query = static::$query_load_by_bug_id;

$args = array('module_id' => $module->getID(),

'bug_id' => $bug_id);

$from = array('-', '\\');

$to = array('_', '\\\\');

if($engine instanceof HTTPFriendlyEngine)

{

//XXX friendly links may compress slashes

$from[] = '/';

$to[] = '%';

}

if(is_string($bug_id))

{

$query .= ' AND title '.$database->like(FALSE)

.' :title ESCAPE :escape';

$args['title'] = str_replace($from, $to, $bug_id);

$args['escape'] = '\\';

}

if(($res = $database->query($engine, $query, $args)) === FALSE

|| $res->count() != 1)

return FALSE;

return static::loadFromResult($engine, $module, $res);

}

//protected

//properties

protected $project = FALSE;

//static

static protected $class = 'BugProjectContent';

static protected $list_order = 'bug_id DESC';

static protected $priorities = array('Urgent' => 'Urgent',

'High' => 'High', 'Medium' => 'Medium', 'Low' => 'Low');

static protected $states = array('New' => 'New',

'Assigned' => 'Assigned', 'Closed' => 'Closed',

'Fixed' => 'Fixed', 'Implemented' => 'Implemented',

'Re-opened' => 'Re-opened');

static protected $types = array('Major' => 'Major', 'Minor' => 'Minor',

'Functionality' => 'Functionality', 'Feature' => 'Feature');

//queries

//IN: module_id

static protected $query_list = "SELECT bug.content_id AS id,

bug.timestamp AS timestamp,

bug.module_id AS module_id, bug.module AS module,

bug.user_id AS user_id, bug.username AS username,

bug.group_id AS group_id, bug.groupname AS groupname,

bug.title AS title, bug.content AS content,

bug.enabled AS enabled, bug.public AS public,

bug_id, state, type, priority,

daportal_project.project_id AS project_id,

project.title AS project

FROM daportal_content_public bug, daportal_bug,

daportal_content_public project, daportal_project

WHERE bug.content_id=daportal_bug.content_id

AND daportal_bug.project_id=daportal_project.project_id

AND project.content_id=daportal_project.project_id

AND bug.module_id=:module_id";

//IN: module_id

// user_id

static protected $query_list_user = "SELECT bug.content_id AS id,

bug.timestamp AS timestamp,

bug.module_id AS module_id, bug.module AS module,

bug.user_id AS user_id, bug.username AS username,

bug.group_id AS group_id, bug.groupname AS groupname,

bug.title AS title, bug.content AS content,

bug.enabled AS enabled, bug.public AS public,

bug_id, state, type, priority,

daportal_project.project_id AS project_id,

project.title AS project

FROM daportal_content_public bug, daportal_bug,

daportal_content_public project, daportal_project

WHERE bug.content_id=daportal_bug.content_id

AND daportal_bug.project_id=daportal_project.project_id

AND project.content_id=daportal_project.project_id

AND bug.module_id=:module_id

AND bug.user_id=:user_id";

//IN: module_id

// user_id

static protected $query_list_user_private = "SELECT bug.content_id AS id,

bug.timestamp AS timestamp,

bug.module_id AS module_id, bug.module AS module,

bug.user_id AS user_id, bug.username AS username,

bug.group_id AS group_id, bug.groupname AS groupname,

bug.title AS title, bug.content AS content,

bug.enabled AS enabled, bug.public AS public,

bug_id, state, type, priority,

daportal_project.project_id AS project_id,

project.title AS project

FROM daportal_content_enabled bug, daportal_bug,

daportal_content_public project, daportal_project

WHERE bug.content_id=daportal_bug.content_id

AND daportal_bug.project_id=daportal_project.project_id

AND project.content_id=daportal_project.project_id

AND bug.module_id=:module_id

AND bug.user_id=:user_id";

//IN: module_id

// user_id

// content_id

static protected $query_load = "SELECT

daportal_content_enabled.content_id AS id, timestamp,

module_id, module, user_id, username, group_id, groupname,

title, content, enabled, public, bug_id, project_id, state,

type, priority, assigned

FROM daportal_content_enabled, daportal_bug

WHERE daportal_content_enabled.content_id

=daportal_bug.content_id

AND module_id=:module_id

AND (public='1' OR user_id=:user_id)

AND daportal_content_enabled.content_id=:content_id";

//IN: module_id

// bug_id

static protected $query_load_by_bug_id = 'SELECT

daportal_content_public.content_id AS id, timestamp,

module_id, module, user_id, username, group_id, groupname,

title, content, enabled, public, bug_id, project_id, state,

type, priority, assigned

FROM daportal_content_public, daportal_bug

WHERE daportal_content_public.content_id=daportal_bug.content_id

AND module_id=:module_id

AND bug_id=:bug_id';

}