public static function loadFixtures(\thebuggenie\core\entities\Scope $scope)
{
$scheme = new IssuetypeScheme();
$scheme->setScope($scope->getID());
$scheme->setName("Default issuetype scheme");
$scheme->setDescription("This is the default issuetype scheme. It is used by all projects with no specific issuetype scheme selected. This scheme cannot be edited or removed.");
$scheme->save();
framework\Settings::saveSetting(framework\Settings::SETTING_DEFAULT_ISSUETYPESCHEME, $scheme->getID(), 'core', $scope->getID());
foreach (Issuetype::getAll() as $issuetype) {
$scheme->setIssuetypeEnabled($issuetype);
if ($issuetype->getIcon() == 'developer_report') {
$scheme->setIssuetypeRedirectedAfterReporting($issuetype, false);
}
if (in_array($issuetype->getIcon(), array('task', 'developer_report', 'idea'))) {
$scheme->setIssuetypeReportable($issuetype, false);
}
}
return $scheme;
}
<table class="cleantable">
<thead>
<tr>
<th><?php
echo __('Name');
?>
</th>
<th><?php
echo __('ID');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach (\thebuggenie\core\entities\IssuetypeScheme::getAll() as $item) {
?>
<tr><td><?php
echo $item->getName();
?>
</td><td><?php
echo $item->getID();
?>
</td></tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="csv_data_box">
/**
* Configure project settings
*
* @param framework\Request $request The request object
*/
public function runConfigureProjectSettings(framework\Request $request)
{
if ($request->isPost()) {
$this->forward403unless($this->getUser()->canEditProjectDetails($this->selected_project), framework\Context::getI18n()->__('You do not have access to update these settings'));
$release_date = null;
if ($request['has_release_date']) {
$release_date = mktime(0, 0, 1, $request['release_month'], $request['release_day'], $request['release_year']);
}
$this->selected_project->setReleaseDate($release_date);
$old_key = $this->selected_project->getKey();
if ($request->hasParameter('project_name')) {
if (trim($request['project_name']) == '') {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please specify a valid project name')));
} else {
$this->selected_project->setName($request['project_name']);
}
}
$message = $old_key != $this->selected_project->getKey() ? framework\Context::getI18n()->__('%IMPORTANT: The project key has changed. Remember to replace the current url with the new project key', array('%IMPORTANT' => '<b>' . framework\Context::getI18n()->__('IMPORTANT') . '</b>')) : '';
if ($request->hasParameter('project_key')) {
$this->selected_project->setKey($request['project_key']);
}
if ($request->hasParameter('use_prefix')) {
$this->selected_project->setUsePrefix((bool) $request['use_prefix']);
}
if ($request->hasParameter('use_prefix') && $this->selected_project->doesUsePrefix()) {
if (!$this->selected_project->setPrefix($request['prefix'])) {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__("Project prefixes may only contain letters and numbers")));
}
}
if ($request->hasParameter('client')) {
if ($request['client'] == 0) {
$this->selected_project->setClient(null);
} else {
$this->selected_project->setClient(entities\Client::getB2DBTable()->selectById($request['client']));
}
}
if ($request->hasParameter('subproject_id')) {
if ($request['subproject_id'] == 0) {
$this->selected_project->clearParent();
} else {
$this->selected_project->setParent(entities\Project::getB2DBTable()->selectById($request['subproject_id']));
}
}
if ($request->hasParameter('workflow_scheme')) {
try {
$workflow_scheme = entities\WorkflowScheme::getB2DBTable()->selectById($request['workflow_scheme']);
$this->selected_project->setWorkflowScheme($workflow_scheme);
} catch (\Exception $e) {
}
}
if ($request->hasParameter('issuetype_scheme')) {
try {
$issuetype_scheme = entities\IssuetypeScheme::getB2DBTable()->selectById($request['issuetype_scheme']);
$this->selected_project->setIssuetypeScheme($issuetype_scheme);
} catch (\Exception $e) {
}
}
if ($request->hasParameter('use_scrum')) {
$this->selected_project->setUsesScrum((bool) $request['use_scrum']);
}
if ($request->hasParameter('description')) {
$this->selected_project->setDescription($request->getParameter('description', null, false));
}
if ($request->hasParameter('homepage')) {
$this->selected_project->setHomepage($request['homepage']);
}
if ($request->hasParameter('doc_url')) {
$this->selected_project->setDocumentationURL($request['doc_url']);
}
if ($request->hasParameter('wiki_url')) {
$this->selected_project->setWikiURL($request['wiki_url']);
}
if ($request->hasParameter('released')) {
$this->selected_project->setReleased((int) $request['released']);
}
if ($request->hasParameter('locked')) {
$this->selected_project->setLocked((bool) $request['locked']);
}
if ($request->hasParameter('enable_builds')) {
$this->selected_project->setBuildsEnabled((bool) $request['enable_builds']);
}
if ($request->hasParameter('enable_editions')) {
$this->selected_project->setEditionsEnabled((bool) $request['enable_editions']);
}
if ($request->hasParameter('enable_components')) {
$this->selected_project->setComponentsEnabled((bool) $request['enable_components']);
}
if ($request->hasParameter('allow_changing_without_working')) {
$this->selected_project->setChangeIssuesWithoutWorkingOnThem((bool) $request['allow_changing_without_working']);
}
if ($request->hasParameter('allow_autoassignment')) {
$this->selected_project->setAutoassign((bool) $request['allow_autoassignment']);
}
$this->selected_project->save();
return $this->renderJSON(array('message' => $this->getI18n()->__('Settings saved')));
}
}
/**
* Perform an action on an issue type
*
* @param framework\Request $request
*/
public function runConfigureIssuetypesAction(framework\Request $request)
{
if ($request->hasParameter('scheme_id')) {
$this->scheme = entities\IssuetypeScheme::getB2DBTable()->selectById((int) $request['scheme_id']);
}
$this->forward403unless($this->access_level == framework\Settings::ACCESS_FULL);
switch ($request['mode']) {
case 'add':
if ($request['name']) {
$issuetype = new entities\Issuetype();
$issuetype->setName($request['name']);
$issuetype->setIcon($request['icon']);
$issuetype->save();
return $this->renderJSON(array('title' => framework\Context::getI18n()->__('Issue type created'), 'content' => $this->getComponentHTML('issuetype', array('type' => $issuetype))));
}
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid name for the issue type')));
case 'update':
if (($issuetype = entities\Issuetype::getB2DBTable()->selectById($request['id'])) instanceof entities\Issuetype) {
if ($this->scheme instanceof entities\IssuetypeScheme) {
$this->scheme->setIssuetypeRedirectedAfterReporting($issuetype, $request['redirect_after_reporting']);
$this->scheme->setIssuetypeReportable($issuetype, $request['reportable']);
return $this->renderJSON(array('title' => framework\Context::getI18n()->__('The issue type details were updated'), 'description' => $issuetype->getDescription(), 'name' => $issuetype->getName()));
} elseif ($request['name']) {
$issuetype->setDescription($request['description']);
$issuetype->setName($request['name']);
$issuetype->setIcon($request['icon']);
$issuetype->save();
return $this->renderJSON(array('title' => framework\Context::getI18n()->__('The issue type was updated'), 'description' => $issuetype->getDescription(), 'name' => $issuetype->getName()));
} else {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid name for the issue type')));
}
}
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid issue type')));
case 'updatechoices':
if (($issuetype = entities\Issuetype::getB2DBTable()->selectById($request['id'])) instanceof entities\Issuetype) {
$this->scheme->clearAvailableFieldsForIssuetype($issuetype);
foreach ($request->getParameter('field', array()) as $key => $details) {
$this->scheme->setFieldAvailableForIssuetype($issuetype, $key, $details);
}
return $this->renderJSON(array('title' => framework\Context::getI18n()->__('Available choices updated')));
} else {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid issue type')));
}
case 'delete':
if (($issuetype = entities\Issuetype::getB2DBTable()->selectById($request['id'])) instanceof entities\Issuetype) {
$issuetype->delete();
return $this->renderJSON(array('message' => framework\Context::getI18n()->__('Issue type deleted')));
} else {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid issue type')));
}
case 'toggletype':
if (($issuetype = entities\Issuetype::getB2DBTable()->selectById($request['id'])) instanceof entities\Issuetype) {
if ($this->scheme instanceof entities\IssuetypeScheme) {
$this->scheme->setIssuetypeEnabled($issuetype, $request['state'] == 'enable');
return $this->renderJSON(array('issuetype_id' => $issuetype->getID()));
}
}
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid action for this issue type / scheme')));
default:
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => framework\Context::getI18n()->__('Please provide a valid action for this issue type')));
}
}
public function updateByIssuetypeSchemeID($scheme_id)
{
$schemes = \thebuggenie\core\entities\IssuetypeScheme::getAll();
foreach ($schemes as $default_scheme_id => $scheme) {
break;
}
$crit = $this->getCriteria();
$crit->addWhere(self::ISSUETYPE_SCHEME_ID, $scheme_id);
$crit->addWhere(self::SCOPE, framework\Context::getScope()->getID());
$crit->addUpdate(self::ISSUETYPE_SCHEME_ID, $default_scheme_id);
$res = $this->doUpdate($crit);
}
public function loadFixtures()
{
// Load initial settings
tables\Settings::getTable()->loadFixtures($this);
\thebuggenie\core\framework\Settings::loadSettings();
// Load group, users and permissions fixtures
Group::loadFixtures($this);
// Load initial teams
Team::loadFixtures($this);
// Set up user states, like "available", "away", etc
Userstate::loadFixtures($this);
// Set up data types
list($b_id, $f_id, $e_id, $t_id, $u_id, $i_id, $ep_id) = Issuetype::loadFixtures($this);
$scheme = IssuetypeScheme::loadFixtures($this);
tables\IssueFields::getTable()->loadFixtures($this, $scheme, $b_id, $f_id, $e_id, $t_id, $u_id, $i_id, $ep_id);
Datatype::loadFixtures($this);
// Set up workflows
Workflow::loadFixtures($this);
WorkflowScheme::loadFixtures($this);
tables\WorkflowIssuetype::getTable()->loadFixtures($this);
// Set up left menu links
tables\Links::getTable()->loadFixtures($this);
}
public function runDoImportCSV(framework\Request $request)
{
try {
if ($request['csv_data'] == '') {
throw new \Exception($this->getI18n()->__('No data supplied to import'));
}
$csv = str_replace("\r\n", "\n", $request['csv_data']);
$csv = html_entity_decode($csv);
$headerrow = null;
$data = array();
$errors = array();
// Parse CSV
$handle = fopen("php://memory", 'r+');
fputs($handle, $csv);
rewind($handle);
$i = 0;
while (($row = fgetcsv($handle, 1000)) !== false) {
if (!$headerrow) {
$headerrow = $row;
} else {
if (count($headerrow) == count($row)) {
$data[] = array_combine($headerrow, $row);
} else {
$errors[] = $this->getI18n()->__('Row %row does not have the same number of elements as the header row', array('%row' => $i));
}
}
$i++;
}
fclose($handle);
if (empty($data)) {
throw new \Exception($this->getI18n()->__('Insufficient data to import'));
}
// Verify required columns are present based on type
$requiredcols = array(self::CSV_TYPE_CLIENTS => array(self::CSV_CLIENT_NAME), self::CSV_TYPE_PROJECTS => array(self::CSV_PROJECT_NAME), self::CSV_TYPE_ISSUES => array(self::CSV_ISSUE_TITLE, self::CSV_ISSUE_PROJECT, self::CSV_ISSUE_ISSUE_TYPE));
if (!isset($requiredcols[$request['type']])) {
throw new \Exception('Sorry, this type is unimplemented');
}
foreach ($requiredcols[$request['type']] as $col) {
if (!in_array($col, $headerrow)) {
$errors[] = $this->getI18n()->__('Required column \'%col\' not found in header row', array('%col' => $col));
}
}
// Check if rows are long enough and fields are not empty
for ($i = 0; $i != count($data); $i++) {
$activerow = $data[$i];
// Check if fields are empty
foreach ($activerow as $col => $val) {
if (strlen($val) == 0) {
$errors[] = $this->getI18n()->__('Row %row column %col has no value', array('%col' => $col, '%row' => $i + 1));
}
}
}
if (count($errors) == 0) {
// Check if fields are valid
switch ($request['type']) {
case self::CSV_TYPE_PROJECTS:
for ($i = 0; $i != count($data); $i++) {
$activerow = $data[$i];
// Check if project exists
$key = str_replace(' ', '', $activerow[self::CSV_PROJECT_NAME]);
$key = mb_strtolower($key);
$tmp = entities\Project::getByKey($key);
if ($tmp !== null) {
$errors[] = $this->getI18n()->__('Row %row: A project with this name already exists', array('%row' => $i + 1));
}
// First off are booleans
$boolitems = array(self::CSV_PROJECT_SCRUM, self::CSV_PROJECT_ALLOW_REPORTING, self::CSV_PROJECT_AUTOASSIGN, self::CSV_PROJECT_FREELANCE, self::CSV_PROJECT_EN_BUILDS, self::CSV_PROJECT_EN_COMPS, self::CSV_PROJECT_EN_EDITIONS, self::CSV_PROJECT_SHOW_SUMMARY);
foreach ($boolitems as $boolitem) {
if (array_key_exists($boolitem, $activerow) && isset($activerow[$boolitem]) && $activerow[$boolitem] != 1 && $activerow[$boolitem] != 0) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be 1/0)', array('%col' => $boolitem, '%row' => $i + 1));
}
}
// Now identifiables
$identifiableitems = array(array(self::CSV_PROJECT_QA, self::CSV_PROJECT_QA_TYPE), array(self::CSV_PROJECT_LEAD, self::CSV_PROJECT_LEAD_TYPE), array(self::CSV_PROJECT_OWNER, self::CSV_PROJECT_OWNER_TYPE));
foreach ($identifiableitems as $identifiableitem) {
if (!array_key_exists($identifiableitem[1], $activerow) && array_key_exists($identifiableitem[0], $activerow) || array_key_exists($identifiableitem[1], $activerow) && !array_key_exists($identifiableitem[0], $activerow)) {
$errors[] = $this->getI18n()->__('Row %row: Both the type and item ID must be supplied for owner/lead/qa fields', array('%row' => $i + 1));
continue;
}
if (array_key_exists($identifiableitem[1], $activerow) && isset($activerow[$identifiableitem[1]]) !== null && $activerow[$identifiableitem[1]] != self::CSV_IDENTIFIER_TYPE_USER && $activerow[$identifiableitem[1]] != self::CSV_IDENTIFIER_TYPE_TEAM) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be 1 for a user or 2 for a team)', array('%col' => $identifiableitem[1], '%row' => $i + 1));
}
if (array_key_exists($identifiableitem[0], $activerow) && isset($activerow[$identifiableitem[0]]) && !is_numeric($activerow[$identifiableitem[0]])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => $identifiableitem[0], '%row' => $i + 1));
} elseif (array_key_exists($identifiableitem[0], $activerow) && isset($activerow[$identifiableitem[0]]) && is_numeric($activerow[$identifiableitem[0]])) {
// check if they exist
switch ($activerow[$identifiableitem[1]]) {
case self::CSV_IDENTIFIER_TYPE_USER:
try {
entities\User::getB2DBTable()->selectByID($activerow[$identifiableitem[0]]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: user does not exist', array('%col' => $identifiableitem[0], '%row' => $i + 1));
}
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
try {
entities\Team::getB2DBTable()->selectById($activerow[$identifiableitem[0]]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: team does not exist', array('%col' => $identifiableitem[0], '%row' => $i + 1));
}
break;
}
}
}
// Now check client exists
if (array_key_exists(self::CSV_PROJECT_CLIENT, $activerow) && isset($activerow[self::CSV_PROJECT_CLIENT])) {
if (!is_numeric($activerow[self::CSV_PROJECT_CLIENT])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_PROJECT_CLIENT, '%row' => $i + 1));
} else {
try {
entities\Client::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_CLIENT]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: client does not exist', array('%col' => self::CSV_PROJECT_CLIENT, '%row' => $i + 1));
}
}
}
// Now check if workflow exists
if (array_key_exists(self::CSV_PROJECT_WORKFLOW_ID, $activerow) && isset($activerow[self::CSV_PROJECT_WORKFLOW_ID])) {
if (!is_numeric($activerow[self::CSV_PROJECT_WORKFLOW_ID])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_PROJECT_WORKFLOW_ID, '%row' => $i + 1));
} else {
try {
entities\WorkflowScheme::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_WORKFLOW_ID]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: workflow scheme does not exist', array('%col' => self::CSV_PROJECT_WORKFLOW_ID, '%row' => $i + 1));
}
}
}
// Now check if issuetype scheme
if (array_key_exists(self::CSV_PROJECT_ISSUETYPE_SCHEME, $activerow) && isset($activerow[self::CSV_PROJECT_ISSUETYPE_SCHEME])) {
if (!is_numeric($activerow[self::CSV_PROJECT_ISSUETYPE_SCHEME])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_PROJECT_ISSUETYPE_SCHEME, '%row' => $i + 1));
} else {
try {
entities\IssuetypeScheme::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_ISSUETYPE_SCHEME]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: issuetype scheme does not exist', array('%col' => self::CSV_PROJECT_ISSUETYPE_SCHEME, '%row' => $i + 1));
}
}
}
// Finally check if the summary type is valid. At this point, your error list has probably become so big it has eaten up all your available RAM...
if (array_key_exists(self::CSV_PROJECT_SUMMARY_TYPE, $activerow) && isset($activerow[self::CSV_PROJECT_SUMMARY_TYPE])) {
if ($activerow[self::CSV_PROJECT_SUMMARY_TYPE] != 'issuetypes' && $activerow[self::CSV_PROJECT_SHOW_SUMMARY] != 'milestones') {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be \'issuetypes\' or \'milestones\')', array('%col' => self::CSV_PROJECT_SUMMARY_TYPE, '%row' => $i + 1));
}
}
}
break;
case self::CSV_TYPE_ISSUES:
for ($i = 0; $i != count($data); $i++) {
$activerow = $data[$i];
// Check if project exists
try {
$prjtmp = entities\Project::getB2DBTable()->selectByID($activerow[self::CSV_ISSUE_PROJECT]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: Project does not exist', array('%col' => self::CSV_ISSUE_PROJECT, '%row' => $i + 1));
break;
}
// First off are booleans
$boolitems = array(self::CSV_ISSUE_STATE, self::CSV_ISSUE_BLOCKING);
foreach ($boolitems as $boolitem) {
if (array_key_exists($boolitem, $activerow) && isset($activerow[$boolitem]) && $activerow[$boolitem] != 1 && $activerow[$boolitem] != 0) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be 1/0)', array('%col' => $boolitem, '%row' => $i + 1));
}
}
// Now numerics
$numericitems = array(self::CSV_ISSUE_VOTES, self::CSV_ISSUE_PERCENTAGE, self::CSV_ISSUE_ISSUENO);
foreach ($numericitems as $numericitem) {
if (array_key_exists($numericitem, $activerow) && isset($activerow[$numericitem]) && !is_numeric($activerow[$numericitem])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => $numericitem, '%row' => $i + 1));
}
}
// Percentage must be 0-100
if (array_key_exists(self::CSV_ISSUE_PERCENTAGE, $activerow) && isset($activerow[self::CSV_ISSUE_PERCENTAGE]) && ($activerow[self::CSV_ISSUE_PERCENTAGE] < 0 || $activerow[self::CSV_ISSUE_PERCENTAGE] > 100)) {
$errors[] = $this->getI18n()->__('Row %row column %col: Percentage must be from 0 to 100 inclusive', array('%col' => self::CSV_ISSUE_PERCENTAGE, '%row' => $i + 1));
}
// Now identifiables
$identifiableitems = array(array(self::CSV_ISSUE_OWNER, self::CSV_ISSUE_OWNER_TYPE), array(self::CSV_ISSUE_ASSIGNED, self::CSV_ISSUE_ASSIGNED_TYPE));
foreach ($identifiableitems as $identifiableitem) {
if (!array_key_exists($identifiableitem[1], $activerow) && array_key_exists($identifiableitem[0], $activerow) || array_key_exists($identifiableitem[1], $activerow) && !array_key_exists($identifiableitem[0], $activerow)) {
$errors[] = $this->getI18n()->__('Row %row: Both the type and item ID must be supplied for owner/lead/qa fields', array('%row' => $i + 1));
continue;
}
if (array_key_exists($identifiableitem[1], $activerow) && isset($activerow[$identifiableitem[1]]) && $activerow[$identifiableitem[1]] != self::CSV_IDENTIFIER_TYPE_USER && $activerow[$identifiableitem[1]] != self::CSV_IDENTIFIER_TYPE_TEAM) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be 1 for a user or 2 for a team)', array('%col' => $identifiableitem[1], '%row' => $i + 1));
}
if (array_key_exists($identifiableitem[0], $activerow) && isset($activerow[$identifiableitem[0]]) && !is_numeric($activerow[$identifiableitem[0]])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => $identifiableitem[0], '%row' => $i + 1));
} elseif (array_key_exists($identifiableitem[0], $activerow) && isset($activerow[$identifiableitem[0]]) && is_numeric($activerow[$identifiableitem[0]])) {
// check if they exist
switch ($activerow[$identifiableitem[1]]) {
case self::CSV_IDENTIFIER_TYPE_USER:
try {
entities\User::getB2DBTable()->selectByID($activerow[$identifiableitem[0]]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: user does not exist', array('%col' => $identifiableitem[0], '%row' => $i + 1));
}
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
try {
entities\Team::getB2DBTable()->selectById($activerow[$identifiableitem[0]]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: team does not exist', array('%col' => $identifiableitem[0], '%row' => $i + 1));
}
break;
}
}
}
// Now timestamps
if (array_key_exists(self::CSV_ISSUE_POSTED, $activerow) && isset($activerow[self::CSV_ISSUE_POSTED]) && (string) (int) $activerow[self::CSV_ISSUE_POSTED] !== $activerow[self::CSV_ISSUE_POSTED] && $activerow[self::CSV_ISSUE_POSTED] >= PHP_INT_MAX && $activerow[self::CSV_ISSUE_POSTED] <= ~PHP_INT_MAX) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a Unix timestamp)', array('%col' => self::CSV_ISSUE_POSTED, '%row' => $i + 1));
}
// Now check user exists for postedby
if (array_key_exists(self::CSV_ISSUE_POSTED_BY, $activerow) && isset($activerow[self::CSV_ISSUE_POSTED_BY])) {
if (!is_numeric($activerow[self::CSV_ISSUE_POSTED_BY])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_POSTED_BY, '%row' => $i + 1));
} else {
try {
entities\User::getB2DBTable()->selectByID($activerow[self::CSV_ISSUE_POSTED_BY]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: user does not exist', array('%col' => self::CSV_ISSUE_POSTED_BY, '%row' => $i + 1));
}
}
}
// Now check milestone exists and is valid
if (array_key_exists(self::CSV_ISSUE_MILESTONE, $activerow) && isset($activerow[self::CSV_ISSUE_MILESTONE])) {
if (!is_numeric($activerow[self::CSV_ISSUE_MILESTONE])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_MILESTONE, '%row' => $i + 1));
} else {
try {
$milestonetmp = entities\Milestone::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_MILESTONE]);
if ($milestonetmp->getProject()->getID() != $activerow[self::CSV_ISSUE_PROJECT]) {
$errors[] = $this->getI18n()->__('Row %row column %col: milestone does not apply to the specified project', array('%col' => self::CSV_ISSUE_MILESTONE, '%row' => $i + 1));
}
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: milestone does not exist', array('%col' => self::CSV_ISSUE_MILESTONE, '%row' => $i + 1));
}
}
}
// status
if (array_key_exists(self::CSV_ISSUE_STATUS, $activerow) && isset($activerow[self::CSV_ISSUE_STATUS])) {
if (!is_numeric($activerow[self::CSV_ISSUE_STATUS])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_STATUS, '%row' => $i + 1));
} else {
try {
entities\Status::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_STATUS]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: status does not exist', array('%col' => self::CSV_ISSUE_STATUS, '%row' => $i + 1));
}
}
}
// resolution
if (array_key_exists(self::CSV_ISSUE_RESOLUTION, $activerow) && isset($activerow[self::CSV_ISSUE_RESOLUTION])) {
if (!is_numeric($activerow[self::CSV_ISSUE_RESOLUTION])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_RESOLUTION, '%row' => $i + 1));
} else {
try {
entities\Resolution::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_RESOLUTION]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: resolution does not exist', array('%col' => self::CSV_ISSUE_RESOLUTION, '%row' => $i + 1));
}
}
}
// priority
if (array_key_exists(self::CSV_ISSUE_PRIORITY, $activerow) && isset($activerow[self::CSV_ISSUE_PRIORITY])) {
if (!is_numeric($activerow[self::CSV_ISSUE_PRIORITY])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_PRIORITY, '%row' => $i + 1));
} else {
try {
entities\Priority::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_PRIORITY]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: priority does not exist', array('%col' => self::CSV_ISSUE_PRIORITY, '%row' => $i + 1));
}
}
}
// category
if (array_key_exists(self::CSV_ISSUE_CATEGORY, $activerow) && isset($activerow[self::CSV_ISSUE_CATEGORY])) {
if (!is_numeric($activerow[self::CSV_ISSUE_CATEGORY])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_CATEGORY, '%row' => $i + 1));
} else {
try {
entities\Category::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_CATEGORY]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: category does not exist', array('%col' => self::CSV_ISSUE_CATEGORY, '%row' => $i + 1));
}
}
}
// severity
if (array_key_exists(self::CSV_ISSUE_SEVERITY, $activerow) && isset($activerow[self::CSV_ISSUE_SEVERITY])) {
if (!is_numeric($activerow[self::CSV_ISSUE_SEVERITY])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_SEVERITY, '%row' => $i + 1));
} else {
try {
entities\Severity::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_SEVERITY]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: severity does not exist', array('%col' => self::CSV_ISSUE_SEVERITY, '%row' => $i + 1));
}
}
}
// reproducability
if (array_key_exists(self::CSV_ISSUE_REPRODUCIBILITY, $activerow) && isset($activerow[self::CSV_ISSUE_REPRODUCIBILITY])) {
if (!is_numeric($activerow[self::CSV_ISSUE_REPRODUCIBILITY])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_REPRODUCIBILITY, '%row' => $i + 1));
} else {
try {
entities\Reproducability::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_REPRODUCIBILITY]);
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: reproducability does not exist', array('%col' => self::CSV_ISSUE_REPRODUCIBILITY, '%row' => $i + 1));
}
}
}
// type
if (array_key_exists(self::CSV_ISSUE_ISSUE_TYPE, $activerow) && isset($activerow[self::CSV_ISSUE_ISSUE_TYPE])) {
if (!is_numeric($activerow[self::CSV_ISSUE_ISSUE_TYPE])) {
$errors[] = $this->getI18n()->__('Row %row column %col: invalid value (must be a number)', array('%col' => self::CSV_ISSUE_ISSUE_TYPE, '%row' => $i + 1));
} else {
try {
$typetmp = entities\Issuetype::getB2DBTable()->selectById($activerow[self::CSV_ISSUE_ISSUE_TYPE]);
if (!$prjtmp->getIssuetypeScheme()->isSchemeAssociatedWithIssuetype($typetmp)) {
$errors[] = $this->getI18n()->__('Row %row column %col: this project does not support issues of this type (%type)', array('%type' => $typetmp->getName(), '%col' => self::CSV_ISSUE_ISSUE_TYPE, '%row' => $i + 1));
}
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row column %col: issue type does not exist', array('%col' => self::CSV_ISSUE_ISSUE_TYPE, '%row' => $i + 1));
}
}
}
}
break;
}
}
// Handle errors
if (count($errors) != 0) {
$errordiv = '<ul>';
foreach ($errors as $error) {
$errordiv .= '<li>' . $error . '</li>';
}
$errordiv .= '</ul>';
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('errordetail' => $errordiv, 'error' => $this->getI18n()->__('Errors occured while importing, see the error list in the import screen for further details')));
}
} catch (\Exception $e) {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('errordetail' => $e->getMessage(), 'error' => $e->getMessage()));
}
if ($request['csv_dry_run']) {
return $this->renderJSON(array('message' => $this->getI18n()->__('Dry-run successful, you can now uncheck the dry-run box and import your data.')));
} else {
switch ($request['type']) {
case self::CSV_TYPE_CLIENTS:
for ($i = 0; $i != count($data); $i++) {
try {
$activerow = $data[$i];
$client = new entities\Client();
$client->setName($activerow[self::CSV_CLIENT_NAME]);
if (isset($activerow[self::CSV_CLIENT_EMAIL])) {
$client->setEmail($activerow[self::CSV_CLIENT_EMAIL]);
}
if (isset($activerow[self::CSV_CLIENT_WEBSITE])) {
$client->setWebsite($activerow[self::CSV_CLIENT_WEBSITE]);
}
if (isset($activerow[self::CSV_CLIENT_FAX])) {
$client->setFax($activerow[self::CSV_CLIENT_FAX]);
}
if (isset($activerow[self::CSV_CLIENT_TELEPHONE])) {
$client->setTelephone($activerow[self::CSV_CLIENT_TELEPHONE]);
}
$client->save();
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row failed: %err', array('%row' => $i + 1, '%err' => $e->getMessage()));
}
}
break;
case self::CSV_TYPE_PROJECTS:
for ($i = 0; $i != count($data); $i++) {
try {
$activerow = $data[$i];
$project = new entities\Project();
$project->setName($activerow[self::CSV_PROJECT_NAME]);
$project->save();
if (isset($activerow[self::CSV_PROJECT_PREFIX])) {
$project->setPrefix($activerow[self::CSV_PROJECT_PREFIX]);
$project->setUsePrefix(true);
}
if (isset($activerow[self::CSV_PROJECT_SCRUM])) {
if ($activerow[self::CSV_PROJECT_SCRUM] == '1') {
$project->setUsesScrum(true);
}
}
if (isset($activerow[self::CSV_PROJECT_OWNER]) && isset($activerow[self::CSV_PROJECT_OWNER_TYPE])) {
switch ($activerow[self::CSV_PROJECT_OWNER_TYPE]) {
case self::CSV_IDENTIFIER_TYPE_USER:
$user = new entities\User($activerow[self::CSV_PROJECT_OWNER]);
$project->setOwner($user);
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
$team = new entities\Team($activerow[self::CSV_PROJECT_OWNER]);
$project->setOwner($team);
break;
}
}
if (isset($activerow[self::CSV_PROJECT_LEAD]) && isset($activerow[self::CSV_PROJECT_LEAD_TYPE])) {
switch ($activerow[self::CSV_PROJECT_LEAD_TYPE]) {
case self::CSV_IDENTIFIER_TYPE_USER:
$user = new entities\User($activerow[self::CSV_PROJECT_LEAD]);
$project->setLeader($user);
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
$team = new entities\Team($activerow[self::CSV_PROJECT_LEAD]);
$project->setLeader($team);
break;
}
}
if (isset($activerow[self::CSV_PROJECT_QA]) && isset($activerow[self::CSV_PROJECT_QA_TYPE])) {
switch ($activerow[self::CSV_PROJECT_QA_TYPE]) {
case self::CSV_IDENTIFIER_TYPE_USER:
$user = new entities\User($activerow[self::CSV_PROJECT_QA]);
$project->setQaResponsible($user);
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
$team = new entities\Team($activerow[self::CSV_PROJECT_QA]);
$project->setQaResponsible($team);
break;
}
}
if (isset($activerow[self::CSV_PROJECT_DESCR])) {
$project->setDescription($activerow[self::CSV_PROJECT_DESCR]);
}
if (isset($activerow[self::CSV_PROJECT_DOC_URL])) {
$project->setDocumentationUrl($activerow[self::CSV_PROJECT_DOC_URL]);
}
if (isset($activerow[self::CSV_PROJECT_WIKI_URL])) {
$project->setWikiUrl($activerow[self::CSV_PROJECT_WIKI_URL]);
}
if (isset($activerow[self::CSV_PROJECT_FREELANCE])) {
if ($activerow[self::CSV_PROJECT_FREELANCE] == '1') {
$project->setChangeIssuesWithoutWorkingOnThem(true);
}
}
if (isset($activerow[self::CSV_PROJECT_EN_BUILDS])) {
if ($activerow[self::CSV_PROJECT_EN_BUILDS] == '1') {
$project->setBuildsEnabled(true);
}
}
if (isset($activerow[self::CSV_PROJECT_EN_COMPS])) {
if ($activerow[self::CSV_PROJECT_EN_COMPS] == '1') {
$project->setComponentsEnabled(true);
}
}
if (isset($activerow[self::CSV_PROJECT_EN_EDITIONS])) {
if ($activerow[self::CSV_PROJECT_EN_EDITIONS] == '1') {
$project->setEditionsEnabled(true);
}
}
if (isset($activerow[self::CSV_PROJECT_CLIENT])) {
$project->setClient(entities\Client::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_CLIENT]));
}
if (isset($activerow[self::CSV_PROJECT_SHOW_SUMMARY])) {
if ($activerow[self::CSV_PROJECT_SHOW_SUMMARY] == '1') {
$project->setFrontpageSummaryVisibility(true);
}
}
if (isset($activerow[self::CSV_PROJECT_SUMMARY_TYPE])) {
$project->setFrontpageSummaryType($activerow[self::CSV_PROJECT_SUMMARY_TYPE]);
}
if (isset($activerow[self::CSV_PROJECT_ALLOW_REPORTING])) {
$project->setLocked($activerow[self::CSV_PROJECT_ALLOW_REPORTING]);
}
if (isset($activerow[self::CSV_PROJECT_AUTOASSIGN])) {
$project->setAutoassign($activerow[self::CSV_PROJECT_AUTOASSIGN]);
}
if (isset($activerow[self::CSV_PROJECT_ISSUETYPE_SCHEME])) {
$project->setIssuetypeScheme(entities\IssuetypeScheme::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_ISSUETYPE_SCHEME]));
}
if (isset($activerow[self::CSV_PROJECT_WORKFLOW_ID])) {
}
$project->setWorkflowScheme(entities\WorkflowScheme::getB2DBTable()->selectById($activerow[self::CSV_PROJECT_WORKFLOW_ID]));
$project->save();
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row failed: %err', array('%row' => $i + 1, '%err' => $e->getMessage()));
}
}
break;
case self::CSV_TYPE_ISSUES:
for ($i = 0; $i != count($data); $i++) {
try {
$activerow = $data[$i];
$issue = new entities\Issue();
$issue->setTitle($activerow[self::CSV_ISSUE_TITLE]);
$issue->setProject($activerow[self::CSV_ISSUE_PROJECT]);
$issue->setIssuetype($activerow[self::CSV_ISSUE_ISSUE_TYPE]);
$issue->save();
if (isset($activerow[self::CSV_ISSUE_DESCR])) {
$issue->setDescription($activerow[self::CSV_ISSUE_DESCR]);
}
if (isset($activerow[self::CSV_ISSUE_REPRO])) {
$issue->setReproductionSteps($activerow[self::CSV_ISSUE_REPRO]);
}
if (isset($activerow[self::CSV_ISSUE_STATE])) {
$issue->setState($activerow[self::CSV_ISSUE_STATE]);
}
if (isset($activerow[self::CSV_ISSUE_STATUS])) {
$issue->setStatus($activerow[self::CSV_ISSUE_STATUS]);
}
if (isset($activerow[self::CSV_ISSUE_POSTED_BY])) {
$issue->setPostedBy(entities\User::getB2DBTable()->selectByID($activerow[self::CSV_ISSUE_POSTED_BY]));
}
if (isset($activerow[self::CSV_ISSUE_OWNER]) && isset($activerow[self::CSV_ISSUE_OWNER_TYPE])) {
switch ($activerow[self::CSV_ISSUE_OWNER_TYPE]) {
case self::CSV_IDENTIFIER_TYPE_USER:
$user = new entities\User($activerow[self::CSV_ISSUE_OWNER]);
$issue->setOwner($user);
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
$team = new entities\Team($activerow[self::CSV_ISSUE_OWNER]);
$issue->setOwner($team);
break;
}
}
if (isset($activerow[self::CSV_ISSUE_ASSIGNED]) && isset($activerow[self::CSV_ISSUE_ASSIGNED_TYPE])) {
switch ($activerow[self::CSV_ISSUE_ASSIGNED_TYPE]) {
case self::CSV_IDENTIFIER_TYPE_USER:
$user = new entities\User($activerow[self::CSV_ISSUE_ASSIGNED]);
$issue->setAssignee($user);
break;
case self::CSV_IDENTIFIER_TYPE_TEAM:
$team = new entities\Team($activerow[self::CSV_ISSUE_ASSIGNED]);
$issue->setAssignee($team);
break;
}
}
if (isset($activerow[self::CSV_ISSUE_RESOLUTION])) {
$issue->setResolution($activerow[self::CSV_ISSUE_RESOLUTION]);
}
if (isset($activerow[self::CSV_ISSUE_PRIORITY])) {
$issue->setPriority($activerow[self::CSV_ISSUE_PRIORITY]);
}
if (isset($activerow[self::CSV_ISSUE_CATEGORY])) {
$issue->setCategory($activerow[self::CSV_ISSUE_CATEGORY]);
}
if (isset($activerow[self::CSV_ISSUE_BLOCKING])) {
$issue->setBlocking($activerow[self::CSV_ISSUE_BLOCKING]);
}
if (isset($activerow[self::CSV_ISSUE_SEVERITY])) {
$issue->setSeverity($activerow[self::CSV_ISSUE_SEVERITY]);
}
if (isset($activerow[self::CSV_ISSUE_REPRODUCIBILITY])) {
$issue->setReproducability($activerow[self::CSV_ISSUE_REPRODUCIBILITY]);
}
if (isset($activerow[self::CSV_ISSUE_VOTES])) {
$issue->setVotes($activerow[self::CSV_ISSUE_VOTES]);
}
if (isset($activerow[self::CSV_ISSUE_PERCENTAGE])) {
$issue->setPercentCompleted($activerow[self::CSV_ISSUE_PERCENTAGE]);
}
if (isset($activerow[self::CSV_ISSUE_ISSUENO])) {
$issue->setIssueNo((int) $activerow[self::CSV_ISSUE_ISSUENO]);
}
if (isset($activerow[self::CSV_ISSUE_MILESTONE])) {
$issue->setMilestone($activerow[self::CSV_ISSUE_MILESTONE]);
}
if (isset($activerow[self::CSV_ISSUE_POSTED])) {
$issue->setPosted((int) $activerow[self::CSV_ISSUE_POSTED]);
}
$issue->save();
} catch (\Exception $e) {
$errors[] = $this->getI18n()->__('Row %row failed: %err', array('%row' => $i + 1, '%err' => $e->getMessage()));
}
}
break;
}
// Handle errors
if (count($errors) != 0) {
$errordiv = '<ul>';
foreach ($errors as $error) {
$errordiv .= '<li>' . $error . '</li>';
}
$errordiv .= '</ul>';
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('errordetail' => $errordiv, 'error' => $this->getI18n()->__('Errors occured while importing, see the error list in the import screen for further details')));
} else {
return $this->renderJSON(array('message' => $this->getI18n()->__('Successfully imported %num rows!', array('%num' => count($data)))));
}
}
}
public function componentIssueTypeSchemeOptions()
{
$this->issuetype = entities\Issuetype::getB2DBTable()->selectById($this->id);
$this->scheme = entities\IssuetypeScheme::getB2DBTable()->selectById($this->scheme_id);
$this->builtinfields = entities\Datatype::getAvailableFields(true);
$this->customtypes = entities\CustomDatatype::getAll();
$this->visiblefields = $this->scheme->getVisibleFieldsForIssuetype($this->issuetype);
}
