summaryrefslogtreecommitdiff
path: root/includes/class.project.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/class.project.php')
-rw-r--r--includes/class.project.php474
1 files changed, 474 insertions, 0 deletions
diff --git a/includes/class.project.php b/includes/class.project.php
new file mode 100644
index 0000000..55a4231
--- /dev/null
+++ b/includes/class.project.php
@@ -0,0 +1,474 @@
+<?php
+
+class Project
+{
+ var $id = 0;
+ var $prefs = array();
+
+ function __construct($id)
+ {
+ global $db, $fs;
+
+ if (is_numeric($id)) {
+ $sql = $db->query("SELECT p.*, c.content AS pm_instructions, c.last_updated AS cache_update
+ FROM {projects} p
+ LEFT JOIN {cache} c ON c.topic = p.project_id AND c.type = 'msg'
+ WHERE p.project_id = ?", array($id));
+ if ($db->countRows($sql)) {
+ $this->prefs = $db->fetchRow($sql);
+ $this->id = (int) $this->prefs['project_id'];
+ $sortrules=explode(',', $this->prefs['default_order_by']);
+ foreach($sortrules as $rule){
+ $last_space=strrpos($rule, ' ');
+ if ($last_space === false){
+ # temporarly
+ $sorting[]=array('field'=>$rule, 'dir'=> $this->prefs['default_order_by_dir']);
+ # future - when column default_order_by_dir removed from project table:
+ #$sorting[]=array('field'=>$rule, 'dir'=>'desc');
+ }else{
+ $sorting[]=array(
+ 'field'=>trim(substr($rule, 0, $last_space)),
+ 'dir'=>trim(substr($rule, $last_space))
+ );
+ }
+ }
+ # using an extra name until default_order_by_dir completely removed
+ $this->prefs['sorting']=$sorting; # we can use this also for highlighting in template which columns are sorted by default in task list!
+
+ # For users with only the 'modify_own_tasks' permission within the project
+ # Currently hardcoded here to have it available for Flyspray1.0. May move to dbfield in future.
+ $this->prefs['basic_fields']=array(
+ 'item_summary',
+ 'detailed_desc',
+ 'task_type',
+ 'product_category',
+ 'operating_system',
+ 'task_severity',
+ 'percent_complete',
+ 'product_version',
+ 'estimated_effort'
+ );
+
+ return;
+ }
+ }
+
+ $this->id = 0;
+ $this->prefs['project_title'] = L('allprojects');
+ $this->prefs['feed_description'] = L('feedforall');
+ $this->prefs['theme_style'] = $fs->prefs['global_theme'];
+ $this->prefs['default_entry'] = $fs->prefs['default_entry'];
+ $this->prefs['lang_code'] = $fs->prefs['lang_code'];
+ $this->prefs['project_is_active'] = 1;
+ $this->prefs['others_view'] = 1;
+ $this->prefs['others_viewroadmap'] = 0;
+ $this->prefs['intro_message'] = '';
+ $this->prefs['anon_open'] = 0;
+ $this->prefs['feed_img_url'] = '';
+ $this->prefs['notify_reply'] = '';
+ $this->prefs['default_due_version'] = 'Undecided';
+ $this->prefs['disable_lostpw'] = 0;
+ $this->prefs['disable_changepw'] = 0;
+ $this->prefs['hours_per_manday'] = 0;
+ $this->prefs['estimated_effort_format'] = 0;
+ $this->prefs['current_effort_done_format'] = 0;
+ $this->prefs['custom_style']= $fs->prefs['custom_style'];
+
+ $sortrules=explode(',', $fs->prefs['default_order_by']);
+ foreach($sortrules as $rule){
+ $last_space=strrpos($rule, ' ');
+ if ($last_space === false){
+ # temporarly
+ $sorting[]=array('field'=>$rule, 'dir'=> $fs->prefs['default_order_by_dir']);
+ # future - when column default_order_by_dir removed from project table:
+ #$sorting[]=array('field'=>$rule, 'dir'=>'desc');
+ }else{
+ $sorting[]=array(
+ 'field'=>trim(substr($rule, 0, $last_space)),
+ 'dir'=>trim(substr($rule, $last_space))
+ );
+ }
+ }
+ # using an extra name until default_order_by_dir completely removed
+ $this->prefs['sorting']=$sorting;
+ }
+
+ # 20150219 peterdd: deprecated
+ function setCookie()
+ {
+ # 20150219 peterdd: unnecessary, setting and using a projectid-cookie makes parallel handling of 2 or more projects in different browser tabs impossible.
+ # instead, use form variables or variables from the url!
+ #Flyspray::setCookie('flyspray_project', $this->id);
+ }
+
+ /**
+ * private method
+ */
+ function _pm_list_sql($type, $join)
+ {
+ global $db;
+
+ // deny the possibility of shooting ourselves in the foot.
+ // although there is no risky usage atm, the api should never do unexpected things.
+ if(preg_match('![^A-Za-z0-9_]!', $type)) {
+ return '';
+ }
+ // Get the column names of list tables for the group by statement
+ $groupby = $db->getColumnNames('{list_' . $type . '}', 'l.' . $type . '_id', 'l.');
+
+ $join = 't.'.join(" = l.{$type}_id OR t.", $join)." = l.{$type}_id";
+
+ return "SELECT l.*, COUNT(t.task_id) AS used_in_tasks, COUNT(CASE t.is_closed WHEN 0 THEN 1 ELSE NULL END) AS opentasks, COUNT(CASE t.is_closed WHEN 1 THEN 1 ELSE NULL END) AS closedtasks
+ FROM {list_{$type}} l
+ LEFT JOIN {tasks} t ON ($join) AND (l.project_id=0 OR t.project_id = l.project_id)
+ WHERE l.project_id = ?
+ GROUP BY $groupby
+ ORDER BY list_position";
+ }
+
+ /**
+ * private method
+ *
+ * @param mixed $type
+ * @param mixed $where
+ * @access protected
+ * @return string
+ * @notes The $where parameter is dangerous, think twice what you pass there..
+ */
+ function _list_sql($type, $where = null)
+ {
+ // sanity check.
+ if(preg_match('![^A-Za-z0-9_]!', $type)) {
+ return '';
+ }
+
+ return "SELECT {$type}_id, {$type}_name
+ FROM {list_{$type}}
+ WHERE show_in_list = 1 AND ( project_id = ? OR project_id = 0 )
+ $where
+ ORDER BY list_position";
+ }
+
+ function listTaskTypes($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ return $db->cached_query(
+ 'pm_task_types'.$this->id,
+ $this->_pm_list_sql('tasktype', array('task_type')),
+ array($this->id));
+ } else {
+ return $db->cached_query(
+ 'task_types'.$this->id, $this->_list_sql('tasktype'), array($this->id));
+ }
+ }
+
+ function listOs($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ return $db->cached_query(
+ 'pm_os'.$this->id,
+ $this->_pm_list_sql('os', array('operating_system')),
+ array($this->id));
+ } else {
+ return $db->cached_query('os'.$this->id, $this->_list_sql('os'),
+ array($this->id));
+ }
+ }
+
+ function listVersions($pm = false, $tense = null, $reported_version = null)
+ {
+ global $db;
+
+ $params = array($this->id);
+
+ if (is_null($tense)) {
+ $where = '';
+ } else {
+ $where = 'AND version_tense = ?';
+ $params[] = $tense;
+ }
+
+ if ($pm) {
+ return $db->cached_query(
+ 'pm_version'.$this->id,
+ $this->_pm_list_sql('version', array('product_version', 'closedby_version')),
+ array($params[0]));
+ } elseif (is_null($reported_version)) {
+ return $db->cached_query(
+ 'version_'.$tense,
+ $this->_list_sql('version', $where),
+ $params);
+ } else {
+ $params[] = $reported_version;
+ return $db->cached_query(
+ 'version_'.$tense,
+ $this->_list_sql('version', $where . ' OR version_id = ?'),
+ $params);
+ }
+ }
+
+
+ function listCategories($project_id = null, $hide_hidden = true, $remove_root = true, $depth = true)
+ {
+ global $db, $conf;
+
+ // start with a empty arrays
+ $right = array();
+ $cats = array();
+ $g_cats = array();
+
+ // null = categories of current project + global project, int = categories of specific project
+ if (is_null($project_id)) {
+ $project_id = $this->id;
+ if ($this->id != 0) {
+ $g_cats = $this->listCategories(0);
+ }
+ }
+
+ // retrieve the left and right value of the root node
+ $result = $db->query("SELECT lft, rgt
+ FROM {list_category}
+ WHERE category_name = 'root' AND lft = 1 AND project_id = ?",
+ array($project_id));
+ $row = $db->fetchRow($result);
+
+ $groupby = $db->getColumnNames('{list_category}', 'c.category_id', 'c.');
+
+ // now, retrieve all descendants of the root node
+ $result = $db->query('SELECT c.category_id, c.category_name, c.*, count(t.task_id) AS used_in_tasks
+ FROM {list_category} c
+ LEFT JOIN {tasks} t ON (t.product_category = c.category_id)
+ WHERE c.project_id = ? AND lft BETWEEN ? AND ?
+ GROUP BY ' . $groupby . '
+ ORDER BY lft ASC',
+ array($project_id, intval($row['lft']), intval($row['rgt'])));
+
+ while ($row = $db->fetchRow($result)) {
+ if ($hide_hidden && !$row['show_in_list'] && $row['lft'] != 1) {
+ continue;
+ }
+
+ // check if we should remove a node from the stack
+ while (count($right) > 0 && $right[count($right)-1] < $row['rgt']) {
+ array_pop($right);
+ }
+ $cats[] = $row + array('depth' => count($right)-1);
+
+ // add this node to the stack
+ $right[] = $row['rgt'];
+ }
+
+ // Adjust output for select boxes
+ if ($depth) {
+ foreach ($cats as $key => $cat) {
+ if ($cat['depth'] > 0) {
+ $cats[$key]['category_name'] = str_repeat('...', $cat['depth']) . $cat['category_name'];
+ $cats[$key]['1'] = str_repeat('...', $cat['depth']) . $cat['1'];
+ }
+ }
+ }
+
+ if ($remove_root) {
+ unset($cats[0]);
+ }
+
+ return array_merge($cats, $g_cats);
+ }
+
+ function listResolutions($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ return $db->cached_query(
+ 'pm_resolutions'.$this->id,
+ $this->_pm_list_sql('resolution', array('resolution_reason')),
+ array($this->id));
+ } else {
+ return $db->cached_query('resolution'.$this->id,
+ $this->_list_sql('resolution'), array($this->id));
+ }
+ }
+
+ function listTaskStatuses($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ return $db->cached_query(
+ 'pm_statuses'.$this->id,
+ $this->_pm_list_sql('status', array('item_status')),
+ array($this->id));
+ } else {
+ return $db->cached_query('status'.$this->id,
+ $this->_list_sql('status'), array($this->id));
+ }
+ }
+
+ /* between FS0.9.9.7 to FS1.0alpha2 */
+ /*
+ function listTags($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ $result= $db->query('SELECT tag AS tag_name, 1 AS list_position, 1 AS show_in_list, COUNT(*) AS used_in_tasks
+ FROM {tags} tg
+ JOIN {tasks} t ON t.task_id=tg.task_id
+ WHERE t.project_id=?
+ GROUP BY tag
+ ORDER BY tag', array($this->id));
+ } else {
+ $result= $db->query('SELECT tag AS tag_name, 1 AS list_position, 1 AS show_in_list, COUNT(*) AS used_in_tasks
+ FROM {tags}
+ GROUP BY tag
+ ORDER BY tag');
+ }
+
+ $tags=array();
+ while ($row = $db->fetchRow($result)) {
+ $tags[]=$row;
+ }
+ return $tags;
+ }
+ */
+ /* rewrite of tags feature, FS1.0beta1 */
+ function listTags($pm = false)
+ {
+ global $db;
+ if ($pm) {
+ $result= $db->query('SELECT tg.*, COUNT(tt.task_id) AS used_in_tasks
+ FROM {list_tag} tg
+ LEFT JOIN {task_tag} tt ON tt.tag_id=tg.tag_id
+ LEFT JOIN {tasks} t ON t.task_id=tt.task_id
+ WHERE tg.project_id=?
+ GROUP BY tg.tag_id
+ ORDER BY tg.list_position', array($this->id));
+ $tags=array();
+ while ($row = $db->fetchRow($result)) {
+ $tags[]=$row;
+ }
+ return $tags;
+ } else {
+ return $db->cached_query('tag'.$this->id, $this->_list_sql('tag'), array($this->id));
+ }
+ }
+
+ // This should really be moved to class Flyspray like some other ones too.
+ // Something todo for 1.1.
+ static function listUsersIn($group_id = null)
+ {
+ global $db;
+ return $db->cached_query(
+ 'users_in'.(is_null($group_id) ? $group_id : intval($group_id)),
+ "SELECT u.*
+ FROM {users} u
+ INNER JOIN {users_in_groups} uig ON u.user_id = uig.user_id
+ INNER JOIN {groups} g ON uig.group_id = g.group_id
+ WHERE g.group_id = ?
+ ORDER BY u.user_name ASC",
+ array($group_id));
+ }
+
+ function listAttachments($cid, $tid)
+ {
+ global $db;
+ return $db->cached_query(
+ 'attach_'.intval($cid),
+ "SELECT *
+ FROM {attachments}
+ WHERE comment_id = ? AND task_id = ?
+ ORDER BY attachment_id ASC",
+ array($cid, $tid));
+ }
+
+ function listLinks($cid, $tid)
+ {
+ global $db;
+ return $db->cached_query(
+ 'link_'.intval($cid),
+ "SELECT *
+ FROM {links}
+ WHERE comment_id = ? AND task_id = ?
+ ORDER BY link_id ASC",
+ array($cid, $tid));
+ }
+
+ function listTaskAttachments($tid)
+ {
+ global $db;
+ return $db->cached_query(
+ 'attach_'.intval($tid),
+ "SELECT * FROM {attachments}
+ WHERE task_id = ? AND comment_id = 0
+ ORDER BY attachment_id ASC",
+ array($tid)
+ );
+ }
+
+ function listTaskLinks($tid)
+ {
+ global $db;
+ return $db->cached_query(
+ 'link_'.intval($tid),
+ "SELECT * FROM {links}
+ WHERE task_id = ? AND comment_id = 0
+ ORDER BY link_id ASC",
+ array($tid));
+ }
+
+ /**
+ * Returns the activity by between dates for a project.
+ * @param date $startdate
+ * @param date $enddate
+ * @param integer $project_id
+ * @return array used to get the count
+ * @access public
+ */
+ static function getActivityProjectCount($startdate, $enddate, $project_id) {
+ global $db;
+ $result = $db->query('SELECT count(event_date) as val
+ FROM {history} h left join {tasks} t on t.task_id = h.task_id
+ WHERE t.project_id = ? AND event_date BETWEEN ? and ?',
+ array($project_id, $startdate, $enddate));
+
+ $result = $db->fetchCol($result);
+ return $result[0];
+ }
+
+ /**
+ * Returns the day activity by the date for a project.
+ * @param date $date
+ * @param integer $project_id
+ * @return array used to get the count
+ * @access public
+ */
+ static function getDayActivityByProject($date_start, $date_end, $project_id) {
+ global $db;
+ //NOTE: from_unixtime() on mysql, to_timestamp() on PostreSQL
+ $func = ('mysql' == $db->dblink->dataProvider) ? 'from_unixtime' : 'to_timestamp';
+
+ $result = $db->query("SELECT count(date({$func}(event_date))) as val, MIN(event_date) as event_date
+ FROM {history} h left join {tasks} t on t.task_id = h.task_id
+ WHERE t.project_id = ? AND event_date BETWEEN ? and ?
+ GROUP BY date({$func}(event_date)) ORDER BY event_date DESC",
+ array($project_id, $date_start, $date_end));
+
+ $date1 = new \DateTime("@$date_start");
+ $date2 = new \DateTime("@$date_end");
+ $days = $date1->diff($date2);
+ $days = $days->format('%a');
+ $results = array();
+
+ for ($i = $days; $i >0; $i--) {
+ $event_date = (string) strtotime("-{$i} day", $date_end);
+ $results[date('Y-m-d', $event_date)] = 0;
+ }
+
+ while ($row = $result->fetchRow()) {
+ $event_date = date('Y-m-d', $row['event_date']);
+ $results[$event_date] = (integer) $row['val'];
+ }
+
+ return array_values($results);
+ }
+}
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-19 16:25:33 +0000