function action_newtask()
{
global $user;
list($task_id, $token, $ok) = Backend::create_task($_POST);
// Status and redirect
if ($ok) {
$url = CreateURL(array('details', 'task' . $task_id));
if ($user->isAnon()) {
$url = CreateURL(array('details', 'task' . $task_id), array('task_token' => $token));
}
if (Post::val('more_tasks')) {
$url = '';
}
return array(SUBMIT_OK, L('newtaskadded'), $url);
} else {
return array($task_id, $token);
// create_task will out error info there
}
}
$length = count($_POST['detailed_desc']);
for ($i = 0; $i < $length; $i++) {
$ticket = array();
foreach ($_POST as $key => $value) {
if ($key == "assigned_to") {
$sql = $db->Query("SELECT user_id FROM {users} WHERE user_name = ? or real_name = ?", array($value[$i], $value[$i]));
$ticket["rassigned_to"] = array(intval($db->FetchOne($sql)));
continue;
}
if (is_array($value)) {
$ticket[$key] = $value[$i];
} else {
$ticket[$key] = $value;
}
}
list($task_id, $token) = Backend::create_task($ticket);
if (!$task_id) {
$flag = false;
break;
}
}
if (!$flag) {
Flyspray::show_error(L('databasemodfailed'));
break;
}
$_SESSION['SUCCESS'] = L('newtaskadded');
Flyspray::Redirect(CreateURL('index', $proj->id));
break;
// ##################
// Modifying an existing task
// ##################
// 'last_edited_time' => time(),
$args['opened_by'] = $reporter;
$args['product_category'] = $category;
$args['task_severity'] = 1;
$args['task_priority'] = 1;
// 'task_type', , 'product_version',
// 'operating_system', , 'estimated_effort',
// 'supertask_id',
$sql = $db->Query("SELECT project_title FROM {projects} WHERE project_id = ?", array($project));
$projectname = $db->FetchOne($sql);
$subject = $subjects[rand(0, count($subjects) - 1)];
$subject = sprintf($subject, $projectname);
$args['item_summary'] = "Task {$i} ({$subject})";
// 'detailed_desc'
// echo $args['item_summary'] . "\r\n";
$ok = Backend::create_task($args);
if ($ok === 0) {
echo "Failed to create task.\r\n";
} else {
list($id, $token) = $ok;
$db->Query('UPDATE {tasks} SET opened_by = ?, date_opened = ? WHERE task_id = ?', array($reporter, $opened, $id));
}
}
// One task in ten of is unconfirmed, probably just bullshit, not assigned to anyone,
// and we add just a comment "Cannot reproduce".
for ($i = 1; $i <= $maxcomments; $i++) {
$taskid = rand(2, $maxtasks + 1);
$task = Flyspray::GetTaskDetails($taskid, true);
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
if (Req::num('task_id')) {
$task = Flyspray::GetTaskDetails(Req::num('task_id'));
}
if (isset($_SESSION)) {
unset($_SESSION['SUCCESS'], $_SESSION['ERROR']);
}
switch ($action = Req::val('action')) {
// ##################
// Adding a new task
// ##################
case 'newtask.newtask':
if (!Post::val('item_summary') || !Post::val('detailed_desc')) {
Flyspray::show_error(L('summaryanddetails'));
break;
}
list($task_id, $token) = Backend::create_task($_POST);
// Status and redirect
if ($task_id) {
$_SESSION['SUCCESS'] = L('newtaskadded');
if ($user->isAnon()) {
Flyspray::Redirect(CreateURL('details', $task_id, null, array('task_token' => $token)));
} else {
Flyspray::Redirect(CreateURL('details', $task_id));
}
} else {
Flyspray::show_error(L('databasemodfailed'));
break;
}
break;
// ##################
// Modifying an existing task
function createTestData()
{
# quick safety
exit;
if (PHP_SAPI !== 'cli') {
die('Please call it only from commandline');
}
global $db, $fs, $proj, $user, $notify;
// Use this only on a new test installation, code does not work on
// an existing one, and never will.
### Simulation Settings ###
# Set conservative data as default, setup bigger values for further performance tests.
# maybe setting moved out of this function to make performance graphs with multiple runs..
// Borg Inc. is a big multinational company delivering
$maxproducts = 3;
# =projects
$maxversions = 3;
// both to it's
$maxcorporateusers = 5;
// working in
$maxcorporates = 3;
// and
$maxindividualusers = 5;
// who are all happy to report to us about
$maxtasks = 10;
// There are many problems in our products. And then there are also
$maxviewers = 10;
// who just like to watch what's going on here at Borg Inc.
// Our users are also keen to add attachments to their reports and comments, so there are
$maxattachments = 5;
// in our database;
// Our users are also very active with commenting.
$maxcomments = 20;
// To handle all the resulting work, we need
$maxadmins = 2;
$maxmanagers = 2;
$maxdevelopers = 3;
// people working together all over the globe to care for their needs.
### End of Simulation Settings ###
// We also have both a very innovative and standardized naming scheme for our products.
// And we have also made one big invention offered only to our customers in the world:
// Time travel! You can comment on tasks and other comments in them even before the task
// is even opened or the original comment made.
// Add more according to your taste...
$subjects[] = "%s sucks!";
$subjects[] = "%s is utterly crap!";
$subjects[] = "Developers of %s should be hanged!";
$subjects[] = "Developers of %s should be strangled!";
$subjects[] = "Developers of %s should be eaten alive by zombies!";
$subjects[] = "Developers of %s should be thrown in a pit of snakes!";
$subjects[] = "Who is the idiot responsible for %s?";
error_reporting(E_ALL);
// die('Enable me by commenting this out by editing and read the contents first!'.basename(__FILE__).' at line '.__LINE__);
define('IN_FS', 1);
require_once dirname(__FILE__) . '/../includes/fix.inc.php';
require_once dirname(__FILE__) . '/../includes/class.flyspray.php';
require_once dirname(__FILE__) . '/../includes/constants.inc.php';
require_once dirname(__FILE__) . '/../includes/i18n.inc.php';
require_once dirname(__FILE__) . '/../includes/class.tpl.php';
require_once dirname(__FILE__) . '/../vendor/autoload.php';
$conf = parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
$db = new Database();
$db->dbOpenFast($conf['database']);
$RANDOP = 'RAND()';
if ($db->dblink->dataProvider == 'postgres') {
$RANDOP = 'RANDOM()';
}
#die();
$fs = new Flyspray();
$user = new User(1);
$proj = new Project(1);
$notify = new Notifications();
load_translations();
for ($i = 1; $i <= $maxadmins; $i++) {
$user_name = "admin{$i}";
$real_name = "Administrator {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 1, 1);
}
for ($i = 1; $i <= $maxmanagers; $i++) {
$user_name = "pm{$i}";
$real_name = "Project Manager {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 2, 1);
}
$db->Query('UPDATE {projects} SET project_is_active = 0 WHERE project_id = 1');
// Show more columns by default, trying to make database or flyspray crash under stress.
$db->Query("UPDATE {prefs} SET pref_value = 'id project category tasktype severity summary status openedby dateopened progress comments attachments votes' WHERE pref_name = 'visible_columns'");
// Add 3 different Global developer groups with different
// view rights first, then assign developers to them at random.
// Borg Inc. has a strict hierarchy on who can see and do what.
// Somewhat more relaxed with our own developers.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 1', 'Developer Group 1', 0, 1, 1, 0, 1, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 2', 'Developer Group 2', 0, 1, 1, 0, 0, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 3', 'Developer Group 3', 0, 1, 1, 0, 0, 0, 1, 1, 1)");
// Add also general groups for corporate users, individual users and viewers.
// Allow only login. Not so relaxed with them bastards.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Corporate Users', 'Corporate Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Trusted Users', 'Trusted Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Non-trusted Users', 'Non-trusted Users', 0, 1)");
for ($i = 1; $i <= $maxdevelopers; $i++) {
$user_name = "dev{$i}";
$real_name = "Developer {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
$group = rand(7, 9);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// We have been really active in the past years, AND have a lot of projects.
for ($i = 1; $i <= $maxproducts; $i++) {
$projname = strtoupper(substr(md5(uniqid(mt_rand(), true)), 0, mt_rand(8, 12)));
$projname = 'Borg Inc. Product ' . preg_replace('/^(.{3})(.+)$/', '$1-$2', $projname);
$db->Query('INSERT INTO {projects}
( project_title, theme_style, intro_message,
others_view, anon_open, project_is_active,
visible_columns, visible_fields, lang_code,
notify_email, notify_jabber, disp_intro)
VALUES (?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ?)', array($projname, 'CleanFS', "Welcome to {$projname}", 0, 0, 'id category tasktype severity summary status openedby dateopened progress comments attachments votes', 'supertask tasktype category severity priority status private assignedto reportedin dueversion duedate progress os votes', 'en', '', '', 1));
add_project_data();
}
// Assign some of the poor developers to project manager or project developer groups
// rights to some of the projects they must work on.
for ($i = 1; $i <= $maxproducts; $i++) {
$projid = $i + 1;
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 1', array($projid));
$pmgroup = $db->FetchOne($sql);
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 0', array($projid));
$pdgroup = $db->FetchOne($sql);
$pmlimit = intval($maxdevelopers / 100) + rand(-2, 2);
$pdlimit = intval($maxdevelopers / 20) + rand(-10, 10);
$pmlimit = $pmlimit < 1 ? 1 : $pmlimit;
$pdlimit = $pdlimit < 1 ? 1 : $pdlimit;
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (7, 8, 9) ORDER BY {$RANDOP} limit {$pmlimit}");
$pms = $db->fetchCol($sql);
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (8, 9) ORDER BY {$RANDOP} limit {$pdlimit}");
$pds = $db->fetchCol($sql);
foreach ($pms as $pm) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pm, $pmgroup));
}
foreach ($pds as $pd) {
$check = $db->Query('SELECT * FROM {users_in_groups} WHERE user_id = ? AND group_id = ?', array($pd, $pmgroup));
if (!$db->CountRows($check)) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pd, $pdgroup));
}
}
}
// Create corporate users.
for ($i = 1; $i <= $maxcorporateusers; $i++) {
$user_name = "cu{$i}";
$real_name = "Corporate user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = 10;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// Now, create corporate user groups for some of our projects.
// Just %5 change of getting added.
for ($i = 1; $i <= $maxcorporates; $i++) {
for ($j = 1; $j <= $maxproducts; $j++) {
if (rand(1, 20) == 1) {
$projid = $j + 1;
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,add_comments,create_attachments,group_open,view_comments) " . "VALUES('Corporate {$i}', 'Corporate {$i} Users', {$projid}, 0, 0, 1, 1, 1, 1, 1,1,1)");
$sql = $db->Query('SELECT MAX(group_id) FROM {groups}');
$group_id = $db->FetchOne($sql);
// Then, add users
for ($k = $i; $k <= $maxcorporateusers; $k += $maxcorporates) {
$username = "******";
$sql = $db->Query('SELECT user_id FROM {users} WHERE user_name = ?', array($username));
$user_id = $db->FetchOne($sql);
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) VALUES (?, ?)', array($user_id, $group_id));
}
}
}
}
// And also those individual users...
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "iu{$i}";
$real_name = "Individual user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = rand(11, 12);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// That's why we need some more global groups with different viewing rights
// And 100 users just viewing our progress
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "basic{$i}";
$real_name = "Basic {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = 4;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// But that was not enough for all needed permission, so in practice, every
// project also has between 1 AND 20 project groups.
//
// Must recreate, so rights for new projects get loaded. Otherwise,
// even first user in database can't create tasks.
$user = new User(1);
// And that's why we've got $maxtasks opened within the last 10 years
for ($i = 1; $i <= $maxtasks; $i++) {
$project = rand(2, $maxproducts);
// Find someone who is allowed to open a task, do not use global groups
$sql = $db->Query("SELECT uig.user_id\n\t\t\tFROM {users_in_groups} uig\n\t\t\tJOIN {groups} g ON g.group_id = uig.group_id AND g.open_new_tasks = 1 AND (g.project_id = 0 OR g.project_id = ?)\n\t\t\tWHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n\t\t\tORDER BY {$RANDOP} LIMIT 1", array($project));
$reporter = $db->FetchOne($sql);
$sql = $db->Query("SELECT category_id FROM {list_category}\n\t\t\tWHERE project_id = ?\n\t\t\tAND category_name <> 'root'\n\t\t\tORDER BY {$RANDOP} LIMIT 1", array($project));
$category = $db->FetchOne($sql);
$opened = time() - rand(1, 315360000);
$args = array();
$args['project_id'] = $project;
$args['date_opened'] = time() - rand(1, 315360000);
// 'last_edited_time' => time(),
$args['opened_by'] = $reporter;
$args['product_category'] = $category;
$args['task_severity'] = 1;
$args['task_priority'] = 1;
// 'task_type', , 'product_version',
// 'operating_system', , 'estimated_effort',
// 'supertask_id',
$sql = $db->Query("SELECT project_title FROM {projects} WHERE project_id = ?", array($project));
$projectname = $db->FetchOne($sql);
$subject = $subjects[rand(0, count($subjects) - 1)];
$subject = sprintf($subject, $projectname);
$args['item_summary'] = "Task {$i} ({$subject})";
// 'detailed_desc'
// echo $args['item_summary'] . "\r\n";
$ok = Backend::create_task($args);
if ($ok === 0) {
echo "Failed to create task.\r\n";
} else {
list($id, $token) = $ok;
$db->Query('UPDATE {tasks} SET opened_by = ?, date_opened = ? WHERE task_id = ?', array($reporter, $opened, $id));
}
}
# end for maxtasks
// One task in ten of is unconfirmed, probably just bullshit, not assigned to anyone,
// and we add just a comment "Cannot reproduce".
for ($i = 1; $i <= $maxcomments; $i++) {
$taskid = rand(2, $maxtasks + 1);
$task = Flyspray::GetTaskDetails($taskid, true);
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
$sqltext = "SELECT uig.user_id\n\t\t\tFROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.add_comments = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} ";
$sql = $db->Query($sqltext, array($project));
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
// User might still not be able to add a comment, if he can not see the task...
// Just try again until a suitable one comes out from the query. It will finally.
// Try to enhance the query also to return fewer unsuitable ones.
while (!$reporter->can_view_task($task)) {
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
}
$comment = 'Comment.';
Backend::add_comment($task, $comment);
$sql = $db->Query('SELECT MAX(comment_id) FROM {comments}');
$comment_id = $db->FetchOne($sql);
$db->Query('UPDATE {comments} SET user_id = ?, date_added = ? WHERE comment_id = ?', array($reporter->id, $added, $comment_id));
}
# end for maxcomments
// And $maxattachments total, either to task or comment
for ($i = 1; $i <= $maxattachments; $i++) {
$sql = $db->Query("SELECT comment_id, task_id, user_id, date_added FROM {comments} ORDER BY {$RANDOP} LIMIT 1");
list($comment_id, $task_id, $user_id, $date_added) = $db->FetchRow($sql);
$fname = "Attachment {$i}";
if (rand(1, 100) == 1) {
$comment_id = 0;
}
$origname = getAttachmentDescription() . " {$i}";
$db->Query("INSERT INTO {attachments}\n ( task_id, comment_id, file_name,\n file_type, file_size, orig_name,\n added_by, date_added)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)", array($task_id, $comment_id, $fname, 'application/octet-stream', 1024, $origname, $user_id, $date_added));
}
// // But at least we have been able to solve approximately half of the tasks
// Of course, many of the tasks are somehow related to each other, so add
// parents, relationships, dependencies, duplicates etc. last.
// Do this ones last, after creating all the other data.
// Approximately 200 hundred of our projects are already closed or deleted.
// Cannot be sure when using random...
for ($i = 1; $i < 200; $i++) {
}
// Some of our developers AND project managers couldn't take all that AND have already left the premises
// No wonder, because we've got those corporate AND individual users always complaining
// AND whining, not to speak about our management.
$db->dbClose();
}
function createTestData()
{
# quick safety
exit;
if (PHP_SAPI !== 'cli') {
die('');
}
// Use this only on a new test installation, code does not work on
// an existing one, and never will.
// Borg Inc. is a big multinational company delivering
$maxproducts = 50;
// both to it's
$maxcorporateusers = 450;
// working in
$maxcorporates = 50;
// and
$maxindividualusers = 10;
// who are all happy to report to us about
$maxtasks = 150;
// the many problems in our products. And then there are also
$maxviewers = 50;
// who just like to watch what's going on here at Borg Inc.
// Our users are also keen to add attachments to their reports and comments, so there are
$maxattachments = 500;
// in our database;
// Our users are also very active with commenting.
$maxcomments = 750;
// To handle all the resulting work, we need
$maxadmins = 3;
$maxmanagers = 5;
$maxdevelopers = 50;
// people working together all over the globe to care for their needs.
// We also have both a very innovative and standardized naming scheme for our products.
// And we have also made one big invention offered only to our customers in the world:
// Time travel! You can comment on tasks and other comments in them even before the task
// is even opened or the original comment made.
// Add more according to your taste...
$subjects[] = "%s sucks!";
$subjects[] = "%s is utterly crap!";
$subjects[] = "Developers of %s should be hanged!";
$subjects[] = "Developers of %s should be strangled!";
$subjects[] = "Developers of %s should be eaten alive by zombies!";
$subjects[] = "Developers of %s should be thrown in a pit of snakes!";
$subjects[] = "Who is the idiot responsible for %s?";
error_reporting(E_ALL);
// die('Enable me by commenting this out by editing and read the contents first!'.basename(__FILE__).' at line '.__LINE__);
define('IN_FS', 1);
require_once dirname(__FILE__) . '/../includes/fix.inc.php';
require_once dirname(__FILE__) . '/../includes/class.flyspray.php';
require_once dirname(__FILE__) . '/../includes/constants.inc.php';
require_once dirname(__FILE__) . '/../includes/i18n.inc.php';
require_once dirname(__FILE__) . '/../includes/class.tpl.php';
require_once dirname(__FILE__) . '/../vendor/autoload.php';
$conf = @parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
$db = new Database();
$db->dbOpenFast($conf['database']);
$RANDOP = 'RAND()';
if ($db->dblink->dataProvider == 'postgres') {
$RANDOP = 'RANDOM()';
}
$fs = new Flyspray();
$user = new User(1);
$proj = new Project(1);
$notify = new Notifications();
load_translations();
for ($i = 1; $i <= $maxadmins; $i++) {
$user_name = "admin{$i}";
$real_name = "Administrator {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@foo.bar.baz.org';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 1, 1);
}
for ($i = 1; $i <= $maxmanagers; $i++) {
$user_name = "pm{$i}";
$real_name = "Project Manager {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@foo.bar.baz.org';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 2, 1);
}
$db->Query('UPDATE {projects} SET project_is_active = 0 WHERE project_id = 1');
// Show more columns by default, trying to make database or flyspray crash under stress.
$db->Query("UPDATE {prefs} SET pref_value = 'id project category tasktype severity summary status openedby dateopened progress comments attachments votes' WHERE pref_name = 'visible_columns'");
// Add 3 different Global developer groups with different
// view rights first, then assign developers to them at random.
// Borg Inc. has a strict hierarchy on who can see and do what.
// Somewhat more relaxed with our own developers.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 1', 'Developer Group 1', 0, 1, 1, 0, 1, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 2', 'Developer Group 2', 0, 1, 1, 0, 0, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 3', 'Developer Group 3', 0, 1, 1, 0, 0, 0, 1, 1, 1)");
// Add also general groups for corporate users, individual users and viewers.
// Allow only login. Not so relaxed with them bastards.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Corporate Users', 'Corporate Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Trusted Users', 'Trusted Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Non-trusted Users', 'Non-trusted Users', 0, 1)");
for ($i = 1; $i <= $maxdevelopers; $i++) {
$user_name = "dev{$i}";
$real_name = "Developer {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = rand(7, 9);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// We have been really active in the past years, AND have a lot of projects.
for ($i = 1; $i <= $maxproducts; $i++) {
$projname = strtoupper(substr(md5(uniqid(mt_rand(), true)), 0, mt_rand(8, 12)));
$projname = 'Borg Inc. Product ' . preg_replace('/^(.{3})(.+)$/', '$1-$2', $projname);
$db->Query('INSERT INTO {projects}
( project_title, theme_style, intro_message,
others_view, anon_open, project_is_active,
visible_columns, visible_fields, lang_code,
notify_email, notify_jabber, disp_intro)
VALUES (?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ?)', array($projname, 'CleanFS', "Welcome to {$projname}", 0, 0, 'id category tasktype severity summary status openedby dateopened progress comments attachments votes', 'supertask tasktype category severity priority status private assignedto reportedin dueversion duedate progress os votes', 'en', '', '', 1));
add_project_data();
}
// Assign some of the poor developers project manager or project developer
// rights to some of the projects they must work on.
for ($i = 1; $i <= $maxproducts; $i++) {
$projid = $i + 1;
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 1', array($projid));
$pmgroup = $db->FetchOne($sql);
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 0', array($projid));
$pdgroup = $db->FetchOne($sql);
$pmlimit = intval($maxdevelopers / 100) + rand(-2, 2);
$pdlimit = intval($maxdevelopers / 20) + rand(-10, 10);
$pmlimit = $pmlimit < 1 ? 1 : $pmlimit;
$pdlimit = $pdlimit < 1 ? 1 : $pdlimit;
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (7, 8, 9) ORDER BY {$RANDOP} limit {$pmlimit}");
$pms = $db->fetchCol($sql);
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (8, 9) ORDER BY {$RANDOP} limit {$pdlimit}");
$pds = $db->fetchCol($sql);
foreach ($pms as $pm) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pm, $pmgroup));
}
foreach ($pds as $pd) {
$check = $db->Query('SELECT * FROM {users_in_groups} WHERE user_id = ? AND group_id = ?', array($pd, $pmgroup));
if (!$db->CountRows($check)) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pd, $pdgroup));
}
}
}
// Create corporate users.
for ($i = 1; $i <= $maxcorporateusers; $i++) {
$user_name = "cu{$i}";
$real_name = "Corporate user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = 10;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// Now, create corporate user groups for some of our projects.
// Just %5 change of getting added.
for ($i = 1; $i <= $maxcorporates; $i++) {
for ($j = 1; $j <= $maxproducts; $j++) {
if (rand(1, 20) == 1) {
$projid = $j + 1;
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,add_comments,create_attachments,group_open,view_comments) " . "VALUES('Corporate {$i}', 'Corporate {$i} Users', {$projid}, 0, 0, 1, 1, 1, 1, 1,1,1)");
$sql = $db->Query('SELECT MAX(group_id) FROM {groups}');
$group_id = $db->FetchOne($sql);
// Then, add users
for ($k = $i; $k <= $maxcorporateusers; $k += $maxcorporates) {
$username = "******";
$sql = $db->Query('SELECT user_id FROM {users} WHERE user_name = ?', array($username));
$user_id = $db->FetchOne($sql);
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) VALUES (?, ?)', array($user_id, $group_id));
}
}
}
}
// And also those individual users...
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "iu{$i}";
$real_name = "Individual user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = rand(11, 12);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// That's why we need some more global groups with different viewing rights
// And 100000 users just viewing our progress
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "basic{$i}";
$real_name = "Basic {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = 4;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// But that was not enough for all needed permission, so in practice, every
// project also has between 1 AND 20 project groups.
//
// Must recreate, so rights for new projects get loaded. Otherwise,
// even first user in database can't create tasks.
$user = new User(1);
// And that's why we've got 1000000 tasks opened within the last 10 years
for ($i = 1; $i <= $maxtasks; $i++) {
$project = rand(2, $maxproducts);
// Find someone who is allowed to open a task, do not use global groups
$sql = $db->Query("SELECT uig.user_id\n FROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.open_new_tasks = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} LIMIT 1", array($project));
$reporter = $db->FetchOne($sql);
$sql = $db->Query("SELECT category_id FROM {list_category} WHERE project_id = ? AND category_name <> 'root' ORDER BY {$RANDOP} LIMIT 1", array($project));
$category = $db->FetchOne($sql);
$opened = time() - rand(1, 315360000);
$args = array();
$args['project_id'] = $project;
$args['date_opened'] = time() - rand(1, 315360000);
// 'last_edited_time' => time(),
$args['opened_by'] = $reporter;
$args['product_category'] = $category;
$args['task_severity'] = 1;
$args['task_priority'] = 1;
// 'task_type', , 'product_version',
// 'operating_system', , 'estimated_effort',
// 'supertask_id',
$sql = $db->Query("SELECT project_title FROM {projects} WHERE project_id = ?", array($project));
$projectname = $db->FetchOne($sql);
$subject = $subjects[rand(0, count($subjects) - 1)];
$subject = sprintf($subject, $projectname);
$args['item_summary'] = "Task {$i} ({$subject})";
// 'detailed_desc'
// echo $args['item_summary'] . "\r\n";
$ok = Backend::create_task($args);
if ($ok === 0) {
echo "Failed to create task.\r\n";
} else {
list($id, $token) = $ok;
$db->Query('UPDATE {tasks} SET opened_by = ?, date_opened = ? WHERE task_id = ?', array($reporter, $opened, $id));
}
}
// One task in ten of is unconfirmed, probably just bullshit, not assigned to anyone,
// and we add just a comment "Cannot reproduce".
for ($i = 1; $i <= $maxcomments; $i++) {
$taskid = rand(2, $maxtasks + 1);
$task = Flyspray::GetTaskDetails($taskid, true);
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
$sqltext = "SELECT uig.user_id\n FROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.add_comments = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} ";
$sql = $db->Query($sqltext, array($project));
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
// User might still not be able to add a comment, if he can not see the task...
// Just try again until a suitable one comes out from the query. It will finally.
// Try to enhance the query also to return fewer unsuitable ones.
while (!$reporter->can_view_task($task)) {
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
}
$comment = 'Comment.';
Backend::add_comment($task, $comment);
$sql = $db->Query('SELECT MAX(comment_id) FROM {comments}');
$comment_id = $db->FetchOne($sql);
$db->Query('UPDATE {comments} SET user_id = ?, date_added = ? WHERE comment_id = ?', array($reporter->id, $added, $comment_id));
}
// And 5000000 attachments total, either to task or comment
for ($i = 1; $i <= $maxattachments; $i++) {
$sql = $db->Query("SELECT comment_id, task_id, user_id, date_added FROM {comments} ORDER BY {$RANDOP} LIMIT 1");
list($comment_id, $task_id, $user_id, $date_added) = $db->FetchRow($sql);
$fname = "Attachment {$i}";
if (rand(1, 100) == 1) {
$comment_id = 0;
}
$origname = GetAttachmentDescription() . " {$i}";
$db->Query("INSERT INTO {attachments}\n ( task_id, comment_id, file_name,\n file_type, file_size, orig_name,\n added_by, date_added)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)", array($task_id, $comment_id, $fname, 'application/octet-stream', 1024, $origname, $user_id, $date_added));
}
function GetAttachmentDescription()
{
$type = rand(1, 100);
if ($type > 80 && $type <= 100) {
return 'Information that might help solve the problem';
} elseif ($type == 79) {
return 'Pic of my pet alligator';
} elseif ($type == 78) {
return 'Pic of my pet rhinoceros';
} elseif ($type == 77) {
return 'Pic of my pet elephant';
} elseif ($type == 76 || $type == 75) {
return 'Pic of my pet monkey';
} elseif ($type == 74 || $type == 73) {
return 'Pic of my undulate';
} elseif ($type == 72 || $type == 71) {
return 'Pic of my goldfish';
} elseif ($type == 70 || $type == 69) {
return 'Pic of my pet pig';
} elseif ($type == 68 || $type == 67) {
return 'Pic of my pet snake';
} elseif ($type == 66 || $type == 65) {
return 'Pic of my pet rat';
} elseif ($type == 64 || $type == 63) {
return 'Pic of my pet goat';
} elseif ($type == 62 || $type == 61) {
return 'Pic of my pet rabbit';
} elseif ($type == 60 || $type == 59) {
return 'Pic of my pet gerbil';
} elseif ($type == 58 || $type == 57) {
return 'Pic of my pet hamster';
} elseif ($type == 56 || $type == 55) {
return 'Pic of my pet chinchilla';
} elseif ($type == 54 || $type == 53) {
return 'Pic of my pet guinea pig';
} elseif ($type == 52 || $type == 51) {
return 'Pic of my pet turtle';
} elseif ($type == 50 || $type == 49) {
return 'Pic of my pet lizard';
} elseif ($type == 48 || $type == 47) {
return 'Pic of my pet frog';
} elseif ($type == 46 || $type == 45) {
return 'Pic of my pet tarantula';
} elseif ($type == 44 || $type == 43) {
return 'Pic of my pet hermit crab';
} elseif ($type == 42 || $type == 41) {
return 'Pic of my pet parrot';
} elseif ($type >= 40 && $type < 25) {
return 'Pic of my dog';
} else {
return 'Pic of my cat';
}
}
// // But at least we have been able to solve approximately half of the tasks
// Of course, many of the tasks are somehow related to each other, so add
// parents, relationships, dependencies, duplicates etc. last.
// Do this ones last, after creating all the other data.
// Approximately 200 hundred of our projects are already closed or deleted.
// Cannot be sure when using random...
for ($i = 1; $i < 200; $i++) {
}
// Some of our developers AND project managers couldn't take all that AND have already left the premises
// No wonder, because we've got those corporate AND individual users always complaining
// AND whining, not to speak about our management.
$db->dbClose();
function add_project_data()
{
global $db;
$sql = $db->Query('SELECT project_id FROM {projects} ORDER BY project_id DESC', false, 1);
$pid = $db->fetchOne($sql);
$cols = array('manage_project', 'view_tasks', 'open_new_tasks', 'modify_own_tasks', 'modify_all_tasks', 'view_comments', 'add_comments', 'edit_comments', 'delete_comments', 'show_as_assignees', 'create_attachments', 'delete_attachments', 'view_history', 'add_votes', 'close_own_tasks', 'close_other_tasks', 'assign_to_self', 'edit_own_comments', 'assign_others_to_self', 'add_to_assignees', 'view_reports', 'group_open', 'view_estimated_effort', 'view_current_effort_done', 'track_effort', 'add_multiple_tasks', 'view_roadmap', 'view_own_tasks', 'view_groups_tasks', 'edit_assignments');
$args = array_fill(0, count($cols), '1');
array_unshift($args, 'Project Managers', 'Permission to do anything related to this project.', intval($pid));
$db->Query("INSERT INTO {groups}\n ( group_name, group_desc, project_id,\n " . join(',', $cols) . ")\n VALUES ( " . $db->fill_placeholders($cols, 3) . ")", $args);
// Add 1 project specific developer group too.
$args = array_fill(1, count($cols) - 1, '1');
array_unshift($args, 'Project Developers', 'Permission to do almost anything but not manage project.', intval($pid), 0);
$db->Query("INSERT INTO {groups}\n ( group_name, group_desc, project_id,\n " . join(',', $cols) . ")\n VALUES ( " . $db->fill_placeholders($cols, 3) . ")", $args);
$db->Query("INSERT INTO {list_category}\n ( project_id, category_name,\n show_in_list, category_owner, lft, rgt)\n VALUES ( ?, ?, 1, 0, 1, 4)", array($pid, 'root'));
$db->Query("INSERT INTO {list_category}\n ( project_id, category_name,\n show_in_list, category_owner, lft, rgt )\n VALUES ( ?, ?, 1, 0, 2, 3)", array($pid, 'Backend / Core'));
// We develop software for a lot of operating systems.
// Add your favorite ones to the end so we get more data.
$os = 1;
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'All', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.0', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.11', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 95', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows ME', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 2000', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows XP', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Vista', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 7', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 8', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 8.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 10', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.0', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.3', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.4', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.5', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.6', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.7', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2003', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2003 R2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2008', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2008 R2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2012', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2012 R2', $os++));
// We've got also a lot of versions.
// Never go over 42! It's the universal answer to everything. So in that version,
// every possible bug is finally solved AND every feature request implemented.
$totalversions = rand(3, 42);
$present = rand(1, $totalversions);
for ($i = 1; $i <= $totalversions; $i++) {
$tense = $i == $present ? 2 : ($i < $present ? 1 : 3);
$db->Query("INSERT INTO {list_version}\n ( project_id, version_name, list_position,\n show_in_list, version_tense )\n VALUES (?, ?, ?, 1, ?)", array($pid, sprintf('%d.0', $i), $i, $tense));
}
}
}