Hi All,
I am looking for an open source system (this system or preferable combinations is Windows, Apache, MySQL, and PHP), to suit (as close as possible) my requirement below.
Our company name: MAC
Our Client name: Alpha
Project duration: 5 years
Project Descriptions: The client (i.e., Alpha) will be sending inputs to design 80 advertisements for every day (display ads for yellow pages), and we (i.e., MAC) require to deliver the designed/completed ads (as PDF document) back to the customer within 2 days (24 hrs). If any rejection in the ads then client will notify us the correction details and we need to re-send the corrected ads in the same day (12 hrs).
Internal Teams (MAC): Team leader (2 members), Login (2 members), Graphic Designer (6 members), Quality Control (6 members), Quality Assurance (2 members)
External Team (Alpha): Project Coordinators (2 members)
Workflow:
Login
• The login person will enter the each ad details on the system, and attach some graphic files for design
• If any query on the ads he will raise the clarification to Team Lead
• When the Team Lead able to resolve the query then the team lead will respond back to the Login person, IF NOT
• Team lead will send/forward the query to the project co-coordinator at the client end for resolution, then the resolution notification will reach login and team lead teams
Designing
• A Designer will pick any ads randomly
• He will start construct the ads using some adobe application
• Finally he will attach the designed ads (as PDF) and complete the task
• If any query on the ads he will raise the clarification to Team Lead
• When the Team Lead able to resolve the query then the team lead will respond back to the designer, IF NOT
• Team lead will send/forward the query to the project co-coordinator at the client end for resolution, then the resolution notification will reach design and team lead teams
Quality Control
• A Quality controller will pick any completed ads randomly
• S/He will process the QC against some specification
• S/He will reject the ads and send back to the designer OR
• S/He will approve the ads and send to the Quality Assurance
Quality Assurance
• A Quality Assurance person will pick any QC approved ads randomly
• S/He will process the QA against some specification
• S/He will reject the ads and send back to the designer (again design, QC cycle will be in place) OR
• S/He will approve the ads and send to the Team lead for dispatch
Dispatch
• The team lead will dispatch the completed ads over FTP
• If any error in the ads the Project Coordinator can reject the ads
• Again login, design, QC, QA, dispatch cycle will repeat
Features required
• Web based system
• Time Tracking for each tasks
• Version control for each ads
• Email, Attachment modules
• Custom fields
• Reports
• Project Management, Collaboration, workflow, administration, security, versioning, scheduling, tem plating, syndication, personalization/localization, and session management,
I look forward to receive your views
Best regards,
Arul Kumar