Cancelled

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

([url removed, login to view])

+++++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 [url removed, login to view] and line 5 of [url removed, login to view]

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 [url removed, login to view]

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

[url removed, login to view] 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 ([url removed, login to view]) 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.

-----

Skills: PHP

See more: you ver, working from, get screen printing done, ver 5, top member, top group, top codes, to p, three p, select group, table customer, screen mind, reason job change, project administrator job description, points line, points guy, php codes pdf, php codes list, perform line, one tabs, always right, looking chef job, line coding, administrator job description, need chef

About the Employer:
( 16 reviews ) houston, United States

Project ID: #47356

5 freelancers are bidding on average $88 for this job

cstl

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development More

$89 USD in 6 days
(18 Reviews)
6.9
instance

GOOD QUALITY WORK WITH INTIME DELIVERY OF THE PRODUCT . 100% GUARANTEED OF HIGH QUALITY PROFESSIONAL WORK, AS WE ARE THE EXPERTISE IN JAVA/J2EE , JSP , EJB, ASP,PHP, STRUTS FRAME WORK RELATED PROJECTS. OUR COMPANY HA More

$50 USD in 5 days
(1 Review)
3.0
softfire

Active and talented programmers working for our company will complete your job quickly and with great quality. You will have detailed info about our perfomance and progress and you will be able to make your correctives More

$100 USD in 5 days
(0 Reviews)
0.0
eway123

Please contact us for more details.

$100 USD in 10 days
(0 Reviews)
0.0
outsourcevn

Our Company is a Global Provider of security solutions, software, data backup, and various IT services including Web development and search engine optimization. Our 20 employees bring years of experience in software de More

$100 USD in 10 days
(0 Reviews)
0.0