Convert Custom Report from vers 4 to ver 5 of PHProjekt

VladKuznetsov did a nice job on creating this report for PHProjekt ver 4. We have moved to PHProjekt ver 5 now. I need the report to work in ver 5. Ver 5 comes close to having what I need as is. Adding some new functionality may be sufficient or tweaking the ver 4 report. I am open to either. The original specs are described below along with reuslting dialogue during the coding process. Below is a list of the project requirements. I just broke them out into single points to help me provide you with specific feed back. The points are lettered. A through G my comments are preceded with +++++++ for clarity. ++++++Please format all dates as 30-sep-05 or 30sep05 or similar ^^^^^^^^^^^^^^on RTS date please pull off hours from the date ^^^^^^^^^^^^^^on Assigned column please make about 4 characters wide (heading can be "Asig" so it will fit) to gain space. ^^^^^^^^^^^^^^tighten column size on date fields so that they just fit the date format 30-sep-05 to gain space ^^^^^^^^^^^^^^tighten column size on progress fields so that they just fit the 100% to gain space ^^^^^^^^^^^^^^column orders ^^^^^^^^^^^^^^Projekts ------name--Remark-----------------------------Asig---begin--End-------category---Status%----- ^^^^^^^^^^^^^^TODO -id---Title----Desc--------------------------------Asig--date---deadline--status-------progress%-- P ^^^^^^^^^^^^^^RTS -id---Concatenate(T:Title----D:Text--S:Solution)--Asig--Submit-Due------Customer--status%-----P A) would like a report and button to access it from within phprojekt ([login to view URL]) +++++the tab is the button which Looks good B) This report would be used for to print +++++ this report Print to paper (hopefully without the shading to save on ink) C) a list of all the three groups +++++Looks nice. (Request that in each module the person to whom the item is assigned be listed by there "shortname" making this a tiny field instead of the longer "person field ) C1) a list of PROJECTS (with sub projects and related TODO items cascading below) +++++++ for projects include remakr field, for TODO include Description field. . C2) A list of TODO items that are not associated with projects +++++++ include description field C3) A list of RTS items (help desk items). +++++++ can you include the SHORT name of the person to whom the RTS was assigned (also the solution field) D) The report would be filterable by user +++++++ appears to be exactly what I wanted would like to test with real data. E) and by by "show all open plus all that closed with in the last 15 days" +++++++ appears to be exactly what I wanted would like to test with real data. F) or "show all" +++++++ appears to be exactly what I wanted would like to test with real data. G) or "Show only open" +++++++ appears to be exactly what I wanted would like to test with real data. D,E,F,G are all related to the filter mechanism that I see at the top of the page which I need to test data. (open meaning not 100% complete in the case of projects and todolist, and not "solved" in the case of help desk It looks nice. On the project filter. Seems the filter shows group project but the "TODO's" under projects respects the filter used on the TODO listing section I see where this becomes a complex filter. I am willing to have you price this an add on. If I filter by asig user... say MQQ I'd like to see PROJECTS and subPROJECTS, and TODO for which MQQ is ASIG (here the TODO refer to the ones assigned to projects as the rest show up in the TODO section of report) Also for the subPROJECTS that MQQ has I want to show the parentPROJECT Also for the shown TODO I want to see their PROJEKTS and parentPROJEKTS (even if those projects belong to someone else) I'd like to add a check box called "supervisors view" to the filter block that switches on and of the showing of the following. The Asig selected...eg. MQQ would want to see all subPROJECTS and TODO items for all of his PROJECTS even if those sub projects and TODO belong to someone else, because he is ultimately responsible for getting them to completion. He can check this box to see this view. On the RTS filter. Please include a group filter. (this may be a bit more complex than the other group filter) It would say... if the Asig_user is not a member of the selected group. then do not show RTS item. Some issues. 1) code bug (please confirm that the correction I made is all we need (or send corrected files) In report folder had an issue in both... line 49 of [login to view URL] and line 5 of [login to view URL] you had $path_pre"../"; by looking at files you sent previously I found and changed to: $path_pre"../../"; Seemed to work 2)Admin vs. super user. As admin you're report is not accessible. Only as "root" or SuperAdmin or whatever they call it at [login to view URL] I need it as Admin. I think in the users tables the ACC field = ay means administrator an=root user or "god" as one guy on the forums at phprojekt calls it. 3)Filters (keep in mind all the user filters are to filter off the person who is assigned to the task etc. BUT I will want additional filters to filter by the creator of the task so you may save yourself some work on the future project as you approach refining the current filter. ( There are some issues. I see how this can get complex filtering over the 3 different tables...etc... PROJEKTS Projekte tables has a group field. show only the projekts that are in the filtered group It seems to show projekts from both groups despite group filter selection. If I do not select a group it shows some repeats. I think this is coming from the fact that I am in both groups. Filter project off gruppe field for group filter (I think you are currently filtering off the von field's group membership) Filter project off chef field for asig filter. (I think you are currently filtering off von field) Filter project off status field <100 for show only open. This seems fine. Filter project off status field <100 and status field =100 if status field join history table last modified-now()<15days (I make it sound simple just to try to explain what I need, I know it may be harder than that) right now the 15 days does not seem to work for projects (I changed a project to 100% today and it does not show up when filtered for "show open + closed within 15days) TODO Todo have a group show only the Todo's that are in the filtered group Filter todo off gruppe field for group filter (I think you are currently filtering off the von field's group membership) Filter todo off ext field for asig filter. (I think you are currently filtering off von field) Filter todo off progress field <100 for show only open. Seems to always show all TODO regardless of progress % Filter todo off progress field <100 and status field =100 if status field join history table last modified-now()<15days (I make it sound simple just to try to explain what I need, I know it may be harder than that) RTS RTS does not have a group but RTS_cat does have a gruppe field. So you can get the group by the category field in the RTS table joined to the RTS_cat table. BUT for some reason PHPprojekt does not store the category in the RTS table..... Filter RTS off ASSIGNED is a member of group selected in Group filter (I can not tell how you are currently doing it) Filter RTS off assigned field for asig filter. (I can not tell how you are currently doing it) Filter todo off IsNotNull(solved) for show only open. Seems to always show all TODO regardless of progress % Filter todo off IsNotNull(solved) and (solve_time)-now()<15days (I realized that status field is not progress % in this table please show it as 1=pend, 2=hecho,3=postor,4=trsldo I am not sure if those status codes are in the db or hardcoded somewhere but these are the ones I want) 4) Collapsing etc. It now opens and closes but I seem to get repeating data and it refreshes to the top of the screen. instead of to where you were when you clicked. I think it is working ok but it is hard to tell with Please add an expand all button. 5) In projects area show project number "P:"&[project_id] and TODO number "T"[however_you_are_getting_the_number_1]&":(&"[todo_id]&")" "T"[however_you_are_getting_the_number_2]&":(&"[todo_id]&")" 6)Tabs Seems there are two tabs that say report on them. (one works and one causes an error) Your [login to view URL] in projekt folder refers to a "report" module. That must be the issue. I figure there is reason you made this change.... 7)doubling on project data. Seems there is a lot of double data. Not sure if this a querry issue or what.. See pdf attached.... Internet Explorer 6.0 SP2 I tried from another machine and have the same results (collapsed view only on REPORT) on PROJECT tab I can collapse and expand just fine (do not know if that is relevant or not). my server install is XAMPP ([login to view URL]) on a win2kpro machine. be my server? Lets go with user as the person who is assigned to perform the project, task or RTS. So that I thank you for new screen shot. Layout looks fairly good. I have a few additional "tweaks" shown below marked by ^^^^^^^^^^^^^^^^^ And shown as best I could on attached PDF. That should be all for layout. With the layout tweaks done I would like to see the following how filtering works. how printing works. -----