<?php
/**
* @package eTraxis
* @ignore
*/
//--------------------------------------------------------------------------------------------------
//
// eTraxis - Records tracking web-based system.
// Copyright (C) 2005-2009 by Artem Rodygin
//
// 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 2 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, write to the Free Software Foundation, Inc.,
// 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
//
//--------------------------------------------------------------------------------------------------
// Author Date Description of modifications
//--------------------------------------------------------------------------------------------------
// Artem Rodygin 2005-03-23 new-001: Records tracking web-based system should be implemented.
// Artem Rodygin 2005-07-23 new-011: Color scheme should be modified.
// Artem Rodygin 2005-08-01 new-013: UI scenarios should be changed.
// Artem Rodygin 2005-08-18 new-037: Any template should be locked to be modified without suspending a project.
// Artem Rodygin 2005-08-23 new-053: All the calls of DAL API functions should be moved to DBO API.
// Artem Rodygin 2005-09-01 bug-079: String database columns are not enough to store UTF-8 values.
// Artem Rodygin 2005-09-07 new-100: 'Date' field type should be implemented.
// Artem Rodygin 2005-09-08 new-101: 'Duration' field type should be implemented.
// Artem Rodygin 2005-09-17 new-128: Lists are malfunctioning in Opera.
// Artem Rodygin 2005-09-27 new-141: Source code review.
// Artem Rodygin 2005-10-05 new-148: Version info should be centralized.
// Artem Rodygin 2005-10-09 new-155: Browser header should contain detailed page info.
// Artem Rodygin 2005-11-08 bug-174: Generated pages should contain <!DOCTYPE> tag.
// Artem Rodygin 2005-11-17 new-176: Change eTraxis design.
// Artem Rodygin 2006-07-27 new-261: UI design should be adopted to slow connection.
// Artem Rodygin 2006-10-08 bug-344: /src/projects/findex.php: Global variables $page and $sort were used before they were defined.
// Artem Rodygin 2007-11-26 new-633: The 'dbx' extension should not be used.
// Artem Rodygin 2008-04-30 bug-699: Views // Names of custom columns are duplicated in the list of available columns, when there are two fields of different types with the same name.
// Artem Rodygin 2008-06-16 bug-719: Global variable $field_type_res was used before it was defined
// Artem Rodygin 2008-11-10 new-749: Guest access for unauthorized users.
// Artem Rodygin 2009-06-12 new-824: PHP 4 is discontinued.
//--------------------------------------------------------------------------------------------------
/**#@+
* Dependency.
*/
require_once('../engine/engine.php');
require_once('../dbo/states.php');
require_once('../dbo/fields.php');
/**#@-*/
global $field_type_res;
init_page();
if (get_user_level() != USER_LEVEL_ADMIN)
{
debug_write_log(DEBUG_NOTICE, 'User must have admin rights to be allowed.');
header('Location: index.php');
exit;
}
$id = ustr2int(try_request('id'));
$state = state_find($id);
if (!$state)
{
debug_write_log(DEBUG_NOTICE, 'State cannot be found.');
header('Location: index.php');
exit;
}
$sort = $page = NULL;
$list = field_list($id, $sort, $page);
$rec_from = $rec_to = 0;
$xml = '<page' . gen_xml_page_header(get_html_resource(RES_FIELDS_ID)) . '>'
. gen_xml_menu()
. '<path>'
. '<pathitem url="index.php">' . get_html_resource(RES_PROJECTS_ID) . '</pathitem>'
. '<pathitem url="view.php?id=' . $state['project_id'] . '">' . ustrprocess(get_html_resource(RES_PROJECT_X_ID), ustr2html($state['project_name'])) . '</pathitem>'
. '<pathitem url="tindex.php?id=' . $state['project_id'] . '">' . get_html_resource(RES_TEMPLATES_ID) . '</pathitem>'
. '<pathitem url="tview.php?id=' . $state['template_id'] . '">' . ustrprocess(get_html_resource(RES_TEMPLATE_X_ID), ustr2html($state['template_name'])) . '</pathitem>'
. '<pathitem url="sindex.php?id=' . $state['template_id'] . '">' . get_html_resource(RES_STATES_ID) . '</pathitem>'
. '<pathitem url="sview.php?id=' . $id . '">' . ustrprocess(get_html_resource(RES_STATE_X_ID), ustr2html($state['state_name'])) . '</pathitem>'
. '<pathitem url="findex.php?id=' . $id . '">' . get_html_resource(RES_FIELDS_ID) . '</pathitem>'
. '</path>'
. '<content>';
if ($list->rows != 0)
{
$columns = array
(
RES_ORDER_ID,
RES_FIELD_NAME_ID,
RES_FIELD_TYPE_ID,
RES_REQUIRED_ID,
);
$widths = array (NULL, NULL, NULL, 100);
$xml .= '<list>'
. gen_xml_bookmarks($page, $list->rows, $rec_from, $rec_to)
. '<hrow>';
for ($i = 1; $i <= count($columns); $i++)
{
$smode = ($sort == $i ? ($i + count($columns)) : $i);
$width = (is_null($widths[$i - 1]) ? NULL : ' width="' . $widths[$i - 1] . '"');
$xml .= '<hcell url="findex.php?id=' . $id . '&sort=' . $smode . '&page=' . $page . '"' . $width . '>'
. get_html_resource($columns[$i - 1])
. '</hcell>';
}
$xml .= '</hrow>';
$list->seek($rec_from - 1);
for ($i = $rec_from; $i <= $rec_to; $i++)
{
$row = $list->fetch();
$url = ' url="fview.php?id=' . $row['field_id'] . '"';
$xml .= '<row' . $url . '>'
. '<cell' . $url . ' align="center">' . ustr2html($row['field_order']) . '</cell>'
. '<cell' . $url . ' align="left">' . ustr2html($row['field_name']) . '</cell>'
. '<cell' . $url . ' align="left">' . get_html_resource($field_type_res[$row['field_type']]) . '</cell>'
. '<cell' . $url . ' align="left" wrap="true">' . get_html_resource($row['field_type'] == FIELD_TYPE_CHECKBOX ? RES_NONE_ID : ($row['is_required'] ? RES_YES_ID : RES_NO_ID)) . '</cell>'
. '</row>';
}
$xml .= '</list>';
}
$xml .= '<button url="sview.php?id=' . $id . '" default="true">' . get_html_resource(RES_BACK_ID) . '</button>';
if ($state['is_locked'])
{
$xml .= '<button url="fcreate.php?id=' . $id . '">' . get_html_resource(RES_CREATE_ID) . '</button>';
}
$xml .= '</content>'
. '</page>';
echo(xml2html($xml));
?>