By ilechcod on

Hello Folks!
This is my first post on Drupal Forum, so please spare any mistakes, or foolish questions.
I am trying to create a requirements management system on Drupal 7, with the following constraints:

First of all, is there already a contributed Drupal requirements management module, if yes - please give details, if no please see specs below:

(1) A from for adding new requirements
Notes: I've already created a new content type called "Requirements", and I can list all forms using "Views". However, still have a number of questions:
Is it possible to create forms that look like a standard Web Form (such as the Yahoo! New User Form, with multiple columns), rather than the standard Drupal-style (1-column, title, body, etc)?
I tried using WebForm to do this, but it looks like it can only submit to email addresses. I need a way to create requirement elicitation forms that are submitted directly to the system (database tables), and can then be listed (with a link to edit each form)
(2) A workflow for approving/rejecting new requirements
(a) I already have a drop-down (Approval Status) on my "Requirements" content type, however - I don't want that CCK list Field showing up to all users (including viewers). I need it to only be visible to Approvers Role. I heard about the cck_field_permissions module, but when I searched - was told it was obsolete, and no further development. Is there a better way for me to do this?
(b) I need to kick-off a workflow process once a requirements form is submitted - prompting approved roles to approve/reject the requirements. What is the best way for me to do this? Heard about the Workflow Module - but doesnt seem to integrate with WebForms (is the WebForm module the best way for me to create these forms)?
(3) A way of notifying authorized users by email once a requirements is approved/rejected.
(4) A way of restricting signed-in users to:
(a) only requirements created by them
(b) list requirements by projects
(4)A settings module for specifying levels of approval for the workflow, and other settings required for this requirements management module to easily be customized by cutomers.

Do I need to develop a new module for this, or is there already something existing I can use?
I've got till Wednesday to show my client the first draft of this new system.
Please advice & assist,

Regards People!
Chibuzo

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

1) Display suite includes an optional module that allows several layouts for the edit form per content type

2) Search for workflow under module douwnloads

3) Rules modules if not the solution you pick for (2)

4a) Content access module

4b) not sure what you are asking, first thought is views

ilechcod’s picture

ilechcod commented

Dear Nevets,
Thank you very much for quick reply.
Could you please, maybe throw some more light?
(1) Which "display suite" are you referring to? You mean under the Webform module, or is this another module?
(2 & 3) Whats difference b/w Workflow & Rules Modules? Or I need both?

So from what you have said so far, looks like I don't need to develop a new module to handle this.
But what of constraint (5)? - a settings page where I can specify various settings for operations?

Thanks for urgent reply - I'm already downloading Workflow & Rules modules as I write.
Need to get this done before Wed. morning.

Please any more advice would be much appreciated.
Regards All

nevets’s picture

nevets commented

Display suite is a module, it provides form layout for the edit forms of content (content types)

There are several "workflow" modules, which one you pick will depend on (5). Rules basically adds the ability to have things happen based on events/triggers.

That is an ambitious deadline, good luck.

ilechcod’s picture

ilechcod commented

Quick Questions...
I've downloaded the Display Suite...
Please whats the best way of creating the add requirement form?
Using New COntent Type or Webforms?

Thanks

nevets’s picture

nevets commented

I would use a content type.

ilechcod’s picture

ilechcod commented

How do I programatically write content to a (disabled) field, say something like "Requirements Approved on date mm/dd/yyyy), without the viewer being able to modify it?

spovlot’s picture

spovlot commented

You may be able to use the Workbench module (http://drupal.org/project/workbench) to handle most of your requirements. It provides a customizable workflow approval system along with customizable access permissions. This is a suite of modules. So, be sure to review the project details. There are also some screencasts included on that page.

ilechcod’s picture

ilechcod commented

Spovlot, I installed the workbench suites and configured all my states, transitions and all.
Suddenly, I get this error on my page

PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. in _drupal_session_write() (line 206 of /opt/lampp/htdocs/transform/includes/session.inc).

The error persists even after restarting my system, apache, and mysql.
When I go to http://localhost/transform, it shows same error.

I've just spent 2 days configuring a lot on this site - pls is there a way to clear this error w/o starting afresh/reinstalling Drupal?

Thanks

spovlot’s picture

spovlot commented

I am unfamiliar with this error. Sorry that it is causing you problems. I saw that you opened up another issue on this specific problem. I hope that someone will be able to resolve it.

patmccay’s picture

patmccay commented

Hi ilechcod, I know this is an incredibly old thread but I'm looking to do something very similar in Drupal and I wanted to see if you were able to accomplish what you were looking to do, or if you needed to build your requirements management system in something else. Any update would be helpful! Thanks!