Response to an open source system requirement針對開放源碼系統的要求

On 26 August 2008, Wareprise.com received a comment on one of its post - 8月26日， 2008年， Wareprise.com收到了評論它的一個職位- Open Source PHP Content Management開源的PHP內容管理

I have moved the comment here and it goes like this:我已經搬到這裡的評論，它是這樣的：

Hi All,大家好，

I am looking for an open source system (the preferable combination is Windows, Apache, MySQL, and PHP), to suit (as close as possible) to my requirement below.我期待的一個開源系統（最好的組合是Windows ， Apache ， MySQL和和PHP ） ，以適應（盡可能接近）我的要求如下。

Our company name : MAC 公司名稱：陸委會
Our client name : Alpha 我們的客戶名稱：阿爾法
Project duration : 5 years 項目期限 ： 5年
Project descriptions : The client (ie, Alpha) will be sending inputs to design 80 to 120 advertisements for every day (display ads for yellow pages), and we (ie, MAC) require to deliver the designed/completed ads (as PDF document) back to the customer within 2 days (24 hrs). 項目說明 ：用戶端（即阿爾法）將派遣投入，設計80到120的廣告每天（顯示廣告黃頁） ，我們（即陸委會）要求提供設計/完成的廣告（如PDF文件）回到客戶在2天內（ 24小時） 。 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).如果有任何排斥反應中的廣告然後客戶端將通知我們更正的細節，我們需要重新發送更正廣告在同一天（ 12小時） 。

Internal Teams (MAC) : Team leader (2 members), Login (2 members), Graphic Designer (6 members), Quality Control (6 members), Quality Assurance (2 members) 內部小組（陸委會） ：組長（ 2名） ，登錄（ 2名） ，平面設計師（ 6名） ，質量控制（ 6名） ，質量保證（ 2名）

External Team (Alpha) : Project Coordinators (2 members) 外部團隊（阿爾法） ：項目協調員（ 2名）

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最後，他將重視設計的廣告（如PDF ） ，並完成任務
• 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 /他將過程中，對一些質量管理規範
• S/He will reject the ads and send back to the designer OR的S /他將拒絕廣告和發回的設計師或
• S/He will approve the ads and send to the Quality Assurance的S /他將批准的廣告，並傳送到質量保證

Quality Assurance 質量保證

• A Quality Assurance person will pick any QC approved ads randomly質量保證人將挑選任何的QC核准的廣告隨機
• S/He will process the QA against some specification的S /他將過程中，對一些質量保證規範
• S/He will reject the ads and send back to the designer (again design, QC cycle will be in place) OR的S /他將拒絕廣告和發回的設計師（再次設計，質量控制週期將在位）或
• S/He will approve the ads and send to the Team lead for dispatch的S /他將批准的廣告和發送給領導小組派遣

Dispatch 調度

• The team lead will dispatch the completed ads over FTP領導小組將派出完成了廣告的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基於Web的系統
• 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 Arul庫馬爾

—————————– ----------

Wareprise.com responds to the requirements as follow: Wareprise.com響應的要求如下：

Dear Arul,親愛的Arul ，

Firstly thanks for your enquiry.首先感謝您的詢問。 This is the first time I’m getting enquiries for my opinion and views.這是第一次我要查詢我的意見和看法。 I will try my best to provide you with an answer based on my experiences and thoughts.我會盡力為您提供的答案根據我的經驗和想法。

I believe the biggest challenge to your requirement would the the time tracking for each tasks since you mentioned that there is a need to deliver ads within 2 days or so.我認為， 最大的挑戰你的要求的時間跟踪每個任務既然你提到，有必要提供的廣告在2天左右。

My thinking is there are two options you can consider.我的想法是有兩種選擇，您可以考慮。

1. 1 。 To build a system from scratch using php, mysql, windows. 要建立一個制度從無到有使用PHP ， MySQL和窗口。 The benefit to this is you can get exactly what you need right to the detail.在受益，這是你可以正是您需要正確的細節。 The downside, it can take quite some time and cost to implement depending on how specific there requirement needs to be.缺點，它可以採取相當長的一段時間和成本，執行取決於如何具體有要求需要。

2. 2 。 To find the closes available open source solution which matches your requirements and customize it from there. 要找到關閉現有開放源碼的解決方案符合您的要求，並訂從那裡。 The good thing about most open source solution is that the core functionalities are already there, such as user manager, document management, task management, etc. Downside is that these solutions are usually very focused.好的事最開源解決方案是，核心功能已經存在，如用戶管理器，文件管理，任務管理等缺點是，這些解決方案通常是非常集中。 Meaning, if you need a solution for document management, then it purely does that very well without the other features like project management or customer relationship management.也就是說，如果您需要解決文件管理，那麼它並不純粹是很好的其他功能，如項目管理或客戶關係管理。 So if you are to go with these solutions, chances are you will need to integrate some of these solutions together to make it fit your requirement.所以，如果你是去與這些解決方案，您將需要把其中的一些共同的解決方案，使之適合您的要求。

Think about the possibilities of these 2 options and evaluate the feasibility to implement based on time, cost and resources.想想的可能性，這兩個備選方案和評估的可行性的基礎上實施的時間，成本和資源。

If you plan to go option 2, which is to source for closes match open source solutions , I would recommend the following solutions:如果您計劃去選擇2 ，這就是源比賽結束開源解決方案 ，我想提出以下解決方案：

Epiware

Epiware is mainly document management oriented as it has versioning and check in check out capabilities. Epiware主要是面向文檔管理 ，因為它有版本，並檢查在檢查的能力。 This feature is good when you have more than 1 designer working on ads at the same time.此功能是好的當你有超過1設計師工作的廣告在同一時間。 The check in check out feature will allow a designer to lock the file that he is working on to ensure no two person works on it simultaneously.在檢查中檢查出功能將允許設計師鎖定的文件，他正在努力，以確保沒有兩個人的作品上同時進行。 Epiware oso has simple task management and calendering features. Epiware奧索了簡單的任務管理和壓延功能。

Achievo大展

Achievo is a project management solution which allows your designers to clock in the number of hours they have work on.大展集團是一家項目管理解決方案，讓您的設計師時鐘的小時數他們的工作。 Although not specified in your requirement, I thought it would be great for you to be able to see which particular project / work has taken up the most time and resources to accomplish.雖然沒有指定在您的要求，我認為這將非常適合你就可以看到特定項目/工作採取了最多的時間和資源來完成。 It’s got reports to show the stats of each project which has been worked on.這就是報告的統計資料顯示每個項目一直工作。

A Non Open Source Solution 一個非開源解決方案

Another solution which I can recommend but is not open source would be Microsoft另一種解決辦法，我可以建議，但不是開源將是微軟 Windows Sharepoint Services Windows SharePoint Services的 . 。 With this solution you can create your work areas as well as implement workflows such as allowing a QA person to accept of reject ads before going to the dispatch team.隨著這一解決方案，您可以創建工作領域，以及執行工作流程，如允許質量保證人拒絕接受的廣告，然後再要派遣團隊。 To achieve this, Sharepoint webparts can be developed.為了實現這一目標， webparts的SharePoint可以開發。 For cost wise, it conforms to the Windows Server 2003 licensing model.出於成本明智的，它符合Windows Server 2003的許可模式。

Hopefully some of these suggestions can help.希望這些建議能幫助。 For others who could contribute as well, do comment below.對於其他可能有助於誰也做的評論如下。

Again, thanks for your enquiry.再次，感謝您的詢問。

Save $30 instantly on McAfee Total Protection and Internet Security! 保存30美元即時的McAfee Total Protection和互聯網安全！