Update our egroupware installation

We have an egroupware 1.4 installation that we need patched and brought up to date with EGW 1.6.003. see [login to view URL] We do have a custom link/ project manager between Typo3 and our Egroupware site as well as 3 custom tweaks and one form change that are documented. This scope of work does NOT include the migrating the Typo3 ->egroupware connector. We do need to include the 3 tweaks and need to keep or improve our reformatted Project Manager Edit project form. (I can send this form or a jpg of it. The heart of the changes are that we moved a number of fields to appear on the General tab so that more information is displayed there when the project is opened.) ## Deliverables As background, I have included my notes on the three "tweaks" we made to the egroupware installation. This should provide background on any custom work that needs to be done to migrate our installation. EMAIL LINKING MOD: We changed /srv/www/egroupware/projectmanager/inc/[login to view URL] line 487 oreach((array) $this->search($criteria,false,'pm_number','','%',false,'OR',false,array('pm_status'=>'active')) as $prj ) to foreach((array) $this->search($criteria,false,'pm_number','','%',false,'OR',false,array('pm_status'=>'active','quote','pending')) as $prj ) in the context below In order to allow emails to be attached via the infolog link to projects that have a status other than active. from /** * query projectmanager for entries matching $pattern * * Is called as hook to participate in the linking * * @param string $pattern pattern to search * @return array with pm_id - title pairs of the matching entries */ function link_query( $pattern ) { $criteria = array(); foreach(array('pm_number','pm_title','pm_description') as $col) { $criteria[$col] = $pattern; } $result = array(); foreach((array) $this->search($criteria,false,'pm_number','','%',false,'OR',false,array('pm_status'=>'active','quote','pending')) as $prj ) { if ($prj['pm_id']) $result[$prj['pm_id']] = $this->link_title($prj); } return $result; } STATE FIELD MOD: Under the General Category of the Project Manager there is a standard field called State The underlying filed is pm_status a varchar 9 long The possible values of this are defined in the egroupware application not in the database in the file: /srv/www/egroupware/projectmanager/inc [login to view URL] the relevant part of this is natively :function uiprojectmanager() { $this->boprojectmanager(); $this->status_labels = array( 'active' => lang('Active'), 'nonactive' => lang('Nonactive'), 'archive' => lang('Archive'), 'template' => lang('Template'), On Jan 11 cwho changed to $$this->status_labels = array( '' => lang('All'), 'pending' => lang('Pending-Customer'), 'quote' => lang('Quote-LGM-Pending'), 'active' => lang('Active'), 'hold' => lang('Hold'), 'complete' => lang('Complete'), 'archive' => lang('Archive'), 'nonactive' => lang('Nonactive'), 'template' => lang('Template'), Also changed: $content['nm'] = array( 'get_rows' => 'projectmanager.uiprojectmanager.get_rows', 'filter2' => '',// I initial value for the filter 'options-filter2'=> $this->status_labels, 'filter2_no_lang'=> True,// I set no_lang for filter (=dont translate the options) 'filter' => 'mains', 'filter_label' => lang('Filter'),// I label for filter (optional) 'options-filter' => $this->filter_labels, 'filter_no_lang' => True,// I set no_lang for filter (=dont translate the options) // 'bottom_too' => True,// I show the nextmatch-line (arrows, filters, search, ...) again after the rows 'order' => 'pm_status',// IO name of the column to sort after (optional for the sortheaders) 'sort' => 'DESC',// IO direction of the sort: 'ASC' or 'DESC' ); so that the filter 2 is set to default to all and the sort catergor is set to pm_staus as default HTML DESCRIPTION MOD The Projects Descriptions tab was not editable using the HTML editor under IE in eTemplates opened **[login to view URL]** ****double click on the bar of the html editor to bring up properties editor window**** ******replaced the Options****** ********from:******** ************width: 100%; height:100%;,TableOperations,ContextMenu,ColorChooser,FontChooser,SearchReplace,InsertDateTime************ ****************to**************** ******************** **width: 690px; height :365px;,ContextMenu,ColorChooser,FontChooser,SearchReplace,InsertDateTime********************** ****************************which was copied from the resources description option which was working. ****************************