* @package projectmanager * @copyright (c) 2005/6 by Ralf Becker * @license http://opensource.org/licenses/gpl-license.php GPL - GNU General Public License * @version $Id: class.uiprojectelements.inc.php 23913 2007-05-22 04:04:13Z lkneschke $ */ include_once(PHPGW_INCLUDE_ROOT.'/projectmanager/inc/class.boprojectelements.inc.php'); /** * ProjectManage UI: list and edit projects-elements */ class uiprojectelements extends boprojectelements { /** * Functions to call via menuaction * * @var array */ var $public_functions = array( 'index' => true, 'edit' => true, 'view' => true, ); /** * Instance of the etemplate class * * @var etemplate */ var $tpl; /** * Labels for status-filter * * @var array */ var $status_labels; /** * Config-settings for projectmanager * * @var array */ var $config; /** * Constructor, calls the constructor of the extended class * * @return uiprojectelements */ function uiprojectelements() { $this->tpl =& CreateObject('etemplate.etemplate'); if ((int) $_REQUEST['pm_id']) { $pm_id = (int) $_REQUEST['pm_id']; // store the current project (only for index, as popups may be called by other parent-projects) } else { $pm_id = $GLOBALS['phpgw']->session->appsession('pm_id','projectmanager'); } if (!$pm_id) { $this->tpl->location(array( 'menuaction' => 'projectmanager.uiprojectmanager.index', 'msg' => lang('You need to select a project first'), )); } $this->boprojectelements($pm_id); // check if we have at least read-access to this project if (!$this->project->check_acl(PHPGW_ACL_READ)) { $this->tpl->location(array( 'menuaction' => 'projectmanager.uiprojectmanager.index', 'msg' => lang('Permission denied !!!'), )); } $this->status_labels = array( 'all' => lang('all'), 'used' => lang('used'), 'new' => lang('new'), 'ignored' => lang('ignored'), ); } /** * View a project-element, just calls edit with view-param set */ function view() { $this->edit(null,true); } /** * Edit or view a project-element * * @var array $content content-array if called by process-exec * @var boolean $view only view project, default false, only used on first call !is_array($content) */ function edit($content=null,$view=false) { if ((int) $this->debug >= 1 || $this->debug == 'edit') $this->debug_message("uiprojectelements::edit(".print_r($content,true).",$view)"); if (is_array($content)) { $this->data = $content['data']; $update_necessary = $save_necessary = 0; $datasource = $this->datasource($this->data['pe_app']); if (($ds_read_from_element = !($ds = $datasource->read($this->data['pe_app_id'],$this->data)))) { $ds = $datasource->element_values($this->data); } if (!$content['view']) { if ($content['pe_completion'] !== '') $content['pe_completion'] .= '%'; foreach($datasource->name2id as $name => $id) { //echo "checking $name=$id (overwrite={$this->data['pe_overwrite']}&$id == ".($this->data['pe_overwrite']&$id?'true':'false')."), content='{$content[$name]}'
\n"; // check if update is necessary, because a field has be set or changed if ($content[$name] && ($content[$name] != $this->data[$name] || !($this->data['pe_overwrite'] & $id))) { //echo "need to update $name as content[$name] changed to '".$content[$name]."' != '".$this->data[$name]."'
\n"; $this->data[$name] = $content[$name]; $this->data['pe_overwrite'] |= $id; $update_necessary |= $id; } // check if a field is no longer set, or it's not set and datasource changed // => set it from the datasource elseif (($this->data['pe_overwrite'] & $id) && !$content[$name] || !($this->data['pe_overwrite'] & $id) && (int)$this->data[$name] != (int)$ds[$name]) { //echo "need to update $name as content[$name] is unset or datasource changed cont='".$content[$name]."', data='".$this->data[$name]."', ds='".$ds[$name]."'
\n"; // if we have a change in the datasource, set pe_synced if ($this->data[$name] != $ds[$name]) { $this->data['pe_synced'] = $this->now_su; } $this->data[$name] = $ds[$name]; $this->data['pe_overwrite'] &= ~$id; $update_necessary |= $id; } } $content['cat_id'] = (int) $content['cat_id']; // as All='' and cat_id column is int // calculate the new summary and if a percentage give the share in hours //echo "

project_summary[pe_total_shares]={$this->project_summary['pe_total_shares']}, old_pe_share={$content['old_pe_share']}, old_default_share=$content[old_default_share], content[pe_share]={$content['pe_share']}

\n"; $planned_time = $content['pe_planned_time'] ? $content['pe_planned_time'] : $ds['pe_planned_time']; $default_share = $planned_time && $this->project->data['pm_accounting_type'] != 'status' ? $planned_time : $this->default_share; $this->project_summary['pe_total_shares'] -= round((string) $content['old_pe_share'] !== '' ? $content['old_pe_share'] : $content['old_default_share']); if (substr($content['pe_share'],-1) == '%' || $this->project->data['pm_accounting_type'] == 'status') { //echo "

project_summary[pe_total_shares]={$this->project_summary['pe_total_shares']}

\n"; if ((float) $content['pe_share'] == 100 || !$this->project_summary['pe_total_shares']) { $content['pe_share'] = $this->default_share; } else { $content['pe_share'] = round($this->project_summary['pe_total_shares'] * (float) $content['pe_share'] / (100 - (float) $content['pe_share']),1); } //echo "

pe_share={$content['pe_share']}

\n"; } $this->project_summary['pe_total_shares'] += round((string) $content['pe_share'] !== '' ? $content['pe_share'] : $default_share); //echo "

project_summary[pe_total_shares]={$this->project_summary['pe_total_shares']}, default_share=$default_share, content[pe_share]={$content['pe_share']}

\n"; foreach(array('pe_status','cat_id','pe_remark','pe_constraints','pe_share') as $name) { if ($name == 'pe_constraints') { foreach($content['pe_constraints'] as $type => $data) { if (!$data) { unset($content['pe_constraints'][$type]); // ignore not set constraints } elseif (!is_array($data)) { $content['pe_constraints'][$type] = explode(',',$data); // otherwise it's detected as change } } } if ($content[$name] != $this->data[$name] || $name == 'pe_share' && $content[$name] !== $this->data[$name]) // for pe_share we differ between 0 and empty! { //echo "need to update $name as content[$name] changed to '".print_r($content[$name],true)."' != '".print_r($this->data[$name],true)."'
\n"; $this->data[$name] = $content[$name]; $save_necessary = true; if ($name == 'pe_remark') $this->data['update_remark'] = true; } } } //echo "uiprojectelements::edit(): save_necessary=".(int)$save_necessary.", update_necessary=$update_necessary, data="; _debug_array($this->data); $view = $content['view'] && !($content['edit'] && $this->check_acl(PHPGW_ACL_EDIT)); if (($content['save'] || $content['apply']) && $this->check_acl(PHPGW_ACL_EDIT)) { if ($update_necessary || $save_necessary) { if ($this->save(null,true,$update_necessary) != 0) { $msg = lang('Error: saving the project-element (%1) !!!',$this->db->Error); unset($content['save']); // dont exit } else { $msg = lang('Project-Element saved'); $js = "opener.location.href='".$GLOBALS['phpgw']->link('/index.php',array( 'menuaction' => $content['caller'] ? $content['caller'] : 'projectmanager.uiprojectelements.index', 'msg' => $msg, ))."';"; } } else { $msg = lang('no save necessary'); } } if ($content['delete'] && $this->check_acl(PHPGW_ACL_DELETE)) { // all delete are done by index $js = "opener.location.href='".$GLOBALS['phpgw']->link('/index.php',array( 'menuaction' => $content['caller'] ? $content['caller'] : 'projectmanager.uiprojectelements.index', 'delete' => $this->data['pe_id'], ))."';"; /* return $this->index(array('nm'=>array('rows'=>array( 'delete' => array($this->data['pe_id']=>true) )))); */ } if ($content['save'] || $content['cancel'] || $content['delete']) { $js .= 'window.close();'; echo ''; $GLOBALS['phpgw']->common->phpgw_exit(); /* $this->tpl->location(array( 'menuaction' => 'projectmanager.uiprojectelements.index', 'msg' => $msg, )); */ } } else { if ((int) $_GET['pe_id']) { $this->read((int) $_GET['pe_id']); } if ($this->data['pe_id']) { if (!$this->check_acl(PHPGW_ACL_READ)) { $this->tpl->location(array( 'menuaction' => 'projectmanager.uiprojectelements.index', 'msg' => lang('Permission denied !!!'), )); } if (!$this->check_acl(PHPGW_ACL_EDIT)) $view = true; } $js = 'window.focus();'; $datasource = $this->datasource($this->data['pe_app']); if (($ds_read_from_element = !($ds = $datasource->read($this->data['pe_app_id'],$this->data)))) { $ds = $datasource->element_values($this->data); } else { $this->data['pe_title'] = $ds['pe_title']; // updating the title, not all datasources do it automatic } } $planned_time = $this->data['pe_planned_time'] ? $this->data['pe_planned_time'] : $ds['pe_planned_time']; $default_share = $planned_time && $this->project->data['pm_accounting_type'] != 'status' ? $planned_time : $this->default_share; if ($ds_read_from_element && !$view) { $msg .= lang('No READ access to the datasource: removing overwritten values will just empty them !!!'); } $preserv = $this->data + array( 'view' => $view, 'data' => $this->data, 'caller' => !$content['caller'] && preg_match('/menuaction=([^&]+)/',$_SERVER['HTTP_REFERER'],$matches) ? $matches[1] : $content['caller'], 'old_pe_share' => $this->data['pe_share'], 'old_default_share' => $default_share, ); unset($preserv['pe_resources']); // otherwise we cant detect no more resources set foreach($datasource->name2id as $name => $id) { if ($id != PM_TITLE && !($this->data['pe_overwrite'] & $id)) // empty not explicitly set values { $this->data[$name] = ''; } } $js .= "\nfunction calc_budget(form) { form['exec[pe_used_budget]'].value = form['exec[pe_used_quantity]'].value.replace(/,/,'.') * form['exec[pe_unitprice]'].value.replace(/,/,'.'); if (form['exec[pe_used_budget]'].value == '0') form['exec[pe_used_budget]'].value = ''; form['exec[pe_planned_budget]'].value = form['exec[pe_planned_quantity]'].value.replace(/,/,'.') * form['exec[pe_unitprice]'].value.replace(/,/,'.'); if (form['exec[pe_planned_budget]'].value == '0') form['exec[pe_planned_budget]'].value = ''; }"; $tabs = 'dates|times|budget|constraints|resources|details'; $content = $this->data + array( 'ds' => $ds, 'msg' => $msg, 'js' => '', 'default_share' => $default_share, 'duration_format' => $this->config['duration_format'], 'no_times' => $this->project->data['pm_accounting_type'] == 'status', $tabs => $content[$tabs], 'no_pricelist' => $this->project->data['pm_accounting_type'] != 'pricelist', 'planned_quantity_blur' => $this->data['pe_planned_time'] ? $this->data['pe_planned_time'] / 60 : $ds['pe_planned_quantity'], 'used_quantity_blur' => $this->data['pe_used_time'] ? $this->data['pe_used_time'] / 60 : $ds['pe_used_quantity'], ); // calculate percentual shares $content['default_total'] = $content['share_total'] = $this->project_summary['pe_total_shares']; if ((string) $this->data['pe_share'] !== '') { if ($this->project_summary['pe_total_shares']) { $content['share_percentage'] = round(100.0 * $this->data['pe_share'] / $this->project_summary['pe_total_shares'],1) . '%'; } $content['default_total'] += $default_share - $this->data['pe_share']; } if ($content['default_total']) { $content['default_percentage'] = round(100.0 * $default_share / $content['default_total'],1) . '%'; } if ($this->project->data['pm_accounting_type'] == 'status') { $content['pe_share'] = $content['share_percentage']; } //_debug_array($content); $sel_options = array( 'pe_constraints' => $this->titles(array( // only titles of elements displayed in a gantchart "pe_status != 'ignore'", // '(pe_planned_start IS NOT NULL OR pe_real_start IS NOT NULL)', // '(pe_planned_end IS NOT NULL OR pe_real_end IS NOT NULL)', 'pe_id != '.(int)$this->data['pe_id'], // dont show own title )), 'milestone' => $this->milestones->titles(array('pm_id' => $this->data['pm_id'])), ); $readonlys = array( 'delete' => !$this->data['pe_id'] || !$this->check_acl(PHPGW_ACL_DELETE), 'edit' => !$view || !$this->check_acl(PHPGW_ACL_EDIT), ); // disable the times tab, if accounting-type status $readonlys[$tabs]['times'] = $this->project->data['pm_accounting_type'] == 'status'; // check if user has the necessary rights to view or edit the budget $readonlys[$tabs]['budget'] = !$this->check_acl(PHPGW_ACL_BUDGET); if (!$this->check_acl(PHPGW_ACL_EDIT_BUDGET)) { foreach(array('pe_planned_budget','pe_used_budget','pl_id','pe_unitprice','pe_planned_quantity','pe_used_quantity') as $key) { $readonlys[$key] = true; } } if ($view) { foreach($this->db_cols as $name) { $readonlys[$name] = true; } $readonlys['pe_remark'] = true; $readonlys['save'] = $readonlys['apply'] = true; $readonlys['pe_constraints[start]'] = $readonlys['pe_constraints[end]'] = $readonlys['pe_constraints[milestone]'] = true; } $GLOBALS['phpgw_info']['flags']['app_header'] = lang('projectmanager') . ' - ' . ($this->data['pm_id'] ? ($view ? lang('View project-elements') : lang('Edit project-elements')) : lang('Add project-elements')); $this->tpl->read('projectmanager.elements.edit'); $this->tpl->exec('projectmanager.uiprojectelements.edit',$content,$sel_options,$readonlys,$preserv,2); } /** * query projects for nextmatch in the projects-list * * reimplemented from so_sql to disable action-buttons based on the acl and make some modification on the data * * @param array &$query_in * @param array &$rows returned rows/cups * @param array &$readonlys eg. to disable buttons based on acl */ function get_rows(&$query_in,&$rows,&$readonlys) { $GLOBALS['phpgw']->session->appsession('projectelements_list','projectmanager',$query=$query_in); if ($this->status_filter[$query['filter']]) { $query['col_filter']['pe_status'] = $this->status_filter[$query['filter']]; } else { unset($query['col_filter']['pe_status']); } if ($query['cat_id']) { $query['col_filter']['cat_id'] = $query['cat_id']; $query_in['link_add']['extra'] = array('cat_id' => $query['cat_id']); } else { unset($query['col_filter']['cat_id']); unset($query_in['link_add']['extra']); } if (!$query['col_filter']['pe_resources']) { unset($query['col_filter']['pe_resources']); } if ($query['filter2'] & 2) // show sub-elements (elements of sub-projects) { $query['col_filter']['pm_id'] = $this->project->children($this->pm_id,array($this->pm_id)); if (count($query['col_filter']['pm_id']) <= 1) $query['col_filter']['pm_id'] = $this->pm_id; // dont show the sub-projects $query['col_filter'][] = "link_app1!='projectmanager'"; } // cumulate eg. timesheets in also included infologs $query['col_filter']['cumulate'] = !($query['filter2'] & 4); $total = parent::get_rows($query,$rows,$readonlys,true); unset($query['col_filter']['cumulate']); // adding the project itself always as first line $self = $this->update('projectmanager',$this->pm_id); $self['pe_app'] = 'projectmanager'; $self['pe_app_id'] = $this->pm_id; $self['pe_icon'] = 'projectmanager/navbar'; $self['pe_modified'] = $this->project->data['pm_modified']; $self['pe_modifier'] = $this->project->data['pm_modifier']; $rows = array_merge(array($self),$rows); $readonlys = array(); foreach($rows as $n => $val) { $row =& $rows[$n]; if ($n && !$this->check_acl(PHPGW_ACL_EDIT,$row)) { $readonlys["edit[$row[pe_id]]"] = true; } if ($n && !$this->check_acl(PHPGW_ACL_DELETE,$row)) { $readonlys["delete[$row[pe_id]]"] = true; } if (!$n) { // no link for own project if (!$this->project->check_acl(PHPGW_ACL_EDIT,$this->project->data)) { $readonlys['edit'] = true; } } else { $row['link'] = array( 'app' => $row['pe_app'], 'id' => $row['pe_app_id'], 'title'=> $row['pe_title'], 'help' => $row['pe_app'] == 'projectmanager' ? lang("Select this project and show it's elements") : lang('View this element in %1',lang($row['pe_app'])), ); } if (!($query['filter2']&1)) unset($row['pe_details']); // add project-title for elements from sub-projects if (($query['filter2']&2) && $row['pm_id'] != $this->pm_id) { $row['pm_title'] = $this->project->link_title($row['pm_id']); $row['pm_link'] = array( 'app' => 'projectmanager', 'id' => $row['pm_id'], 'title'=> $this->project->link_title($row['pm_id']), 'help' => lang("Select this project and show it's elements"), ); } $row['pe_completion_icon'] = $row['pe_completion'] == 100 ? 'done' : $row['pe_completion']; $custom_app_icons[$row['pe_app']][] = $row['pe_app_id']; } if ($GLOBALS['phpgw_info']['user']['preferences']['projectmanager']['show_custom_app_icons']) { $custom_app_icons['location'] = 'pm_custom_app_icons'; $custom_app_icons = $GLOBALS['phpgw']->hooks->process($custom_app_icons); unset($row); // it's used as reference before !!! foreach($rows as $n => $row) { if (isset($custom_app_icons[$row['pe_app']][$row['pe_app_id']])) { $rows[$n]['pe_completion_icon'] = $custom_app_icons[$row['pe_app']][$row['pe_app_id']]; } } } if (!$this->project->check_acl(PHPGW_ACL_BUDGET)) { $rows['no_pe_used_budget_pe_planned_budget'] = true; } if ($this->project->data['pm_accounting_type'] == 'status') { $rows['no_pe_used_time_pe_planned_time'] = true; } // disable time & budget columns if pm is configures for status or status and time only if ($this->config['accounting_types'] == 'status') { $rows['no_pm_used_time_pm_planned_time'] = true; $rows['no_pm_used_budget_pm_planned_budget'] = true; $query_in['options-selectcols']['pm_used_time'] = $query_in['options-selectcols']['pm_planned_time'] = false; $query_in['options-selectcols']['pm_used_budget'] = $query_in['options-selectcols']['pm_planned_budget'] = false; } if ($this->config['accounting_types'] == 'status,times') { $rows['no_pm_used_budget_pm_planned_budget'] = true; $query_in['options-selectcols']['pm_used_budget'] = $query_in['options-selectcols']['pm_planned_budget'] = false; } $rows['duration_format'] = ','.$this->config['duration_format'].',,1'; if ($query['cat_id']) $rows['no_cat_id'] = true; // calculate the filter-specific summary if we have a filter, beside the default pe_status=used=array(new,regular) if (array_diff(array_keys($query['col_filter']),array(0,'pe_status','pm_id')) || !is_array($query['col_filter']['pe_status'])) { $rows += $this->summary(null,$query['col_filter']); } if ((int)$this->debug >= 2 || $this->debug == 'get_rows') { $this->debug_message("uiprojectelements::get_rows(".print_r($query,true).") total=$total, rows =".print_r($rows,true)."readonlys=".print_r($readonlys,true)); } return $total; } /** * List existing projects-elements * * @param array $content=null * @param string $msg='' */ function index($content=null,$msg='') { if ((int) $this->debug >= 1 || $this->debug == 'index') $this->debug_message("uiprojectelements::index(".print_r($content,true).",$msg)"); // store the current project (only for index, as popups may be called by other parent-projects) $GLOBALS['phpgw']->session->appsession('pm_id','projectmanager',$this->project->data['pm_id']); if ($_GET['msg']) $msg = $_GET['msg']; if ($content['nm']['rows']['edit']) { $this->tpl->location(array( 'menuaction' => 'projectmanager.uiprojectmanager.edit', 'pm_id' => $this->pm_id, )); } elseif ($content['sync_all'] && $this->project->check_acl(PHPGW_ACL_ADD)) { $msg = lang('%1 element(s) updated',$this->sync_all()); } elseif((int) $_GET['delete'] || $content['nm']['rows']['delete']) { if ($content['nm']['rows']['delete']) { list($pe_id) = each($content['nm']['rows']['delete']); } else { $pe_id = (int) $_GET['delete']; } if ($this->read($pe_id) && !$this->check_acl(PHPGW_ACL_DELETE)) { $msg = lang('Permission denied !!!'); } else { $msg = $this->delete($pe_id) ? lang('Project-Element deleted') : lang('Error: deleting project-element !!!'); } } $content = array( 'nm' => $GLOBALS['phpgw']->session->appsession('projectelements_list','projectmanager'), 'msg' => $msg, ); if (!is_array($content['nm'])) { $content['nm'] = array( 'get_rows' => 'projectmanager.uiprojectelements.get_rows', 'filter' => 'used',// I initial value for the filter 'filter_label' => lang('Filter'),// I label for filter (optional) 'options-filter' => $this->status_labels, 'filter_no_lang' => True,// I set no_lang for filter (=dont translate the options) 'options-filter2' => array( 0 => 'No details', 1 => 'Details', 2 => 'Subelements', 3 => 'Details of subelements', 4 => 'Cumulated elements too', 5 => 'Details of cumulated', ), 'col_filter' => array('pe_resources' => 0), // default value, to suppress loop 'order' => 'pe_modified',// IO name of the column to sort after (optional for the sortheaders) 'sort' => 'DESC',// IO direction of the sort: 'ASC' or 'DESC' 'default_cols' => '!cat_id', ); } // add "buttons" only with add-rights if ($this->project->check_acl(PHPGW_ACL_ADD)) { $content['nm']['header_right'] = 'projectmanager.elements.list.add'; $content['nm']['header_left'] = 'projectmanager.elements.list.add-new'; } else { unset($content['nm']['header_right']); unset($content['nm']['header_left']); $readonlys['sync_all'] = true; } $content['nm']['link_to'] = array( 'to_id' => $this->pm_id, 'to_app' => 'projectmanager', 'no_files' => true, 'search_label' => 'Add existing', 'link_label' => 'Add', ); $content['nm']['link_add'] = array( 'to_id' => $this->pm_id, 'to_app' => 'projectmanager', 'add_app' => 'infolog', ); // set id for automatic linking via quick add $GLOBALS['phpgw_info']['flags']['currentid'] = $this->pm_id; $GLOBALS['phpgw_info']['flags']['app_header'] = lang('projectmanager').' - '.lang('Elementlist') . ': ' . $this->project->data['pm_number'] . ': ' .$this->project->data['pm_title'] ; $this->tpl->read('projectmanager.elements.list'); $this->tpl->exec('projectmanager.uiprojectelements.index',$content,'',$readonlys); } }