One-page Project updating

A lot of functions can be done from the projects page, including changing project status, priority, "Team" (something we added, using sys_vals), and creating a new task on a given project. Eventually I'd like to make all project editing happen from this page.

You may want to import our sysvals data into your database to see how we use teams, statuses, colors, etc.

-- phpMyAdmin SQL Dump

  -- version 2.11.9.4

  -- http://www.phpmyadmin.net

  --

  -- Host: localhost

  -- Generation Time: Feb 16, 2009 at 09:52 AM

  -- Server version: 5.1.30

  -- PHP Version: 5.2.4

  

  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

  

  --

  -- Database: `complian_dprj4`

  --

  

  -- --------------------------------------------------------

  

  --

  -- Table structure for table `sysvals`

  --

  

  CREATE TABLE IF NOT EXISTS `sysvals` (

  `sysval_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `sysval_key_id` int(10) unsigned NOT NULL DEFAULT '0',

  `sysval_title` varchar(48) NOT NULL DEFAULT '',

  `sysval_value` text NOT NULL,

  PRIMARY KEY (`sysval_id`)

  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

  

  --

  -- Dumping data for table `sysvals`

  --

  

  INSERT INTO `sysvals` (`sysval_id`, `sysval_key_id`, `sysval_title`, `sysval_value`) VALUES

  (1, 1, 'ProjectStatus', '0|Ready\r\n1|Nd. Resources\r\n2|Nd. Content\r\n3|In Progress\r\n4|In Review\r\n5|Complete\r\n6|Cancelled\r\n7|Templates\r\n8|Ongoing\r\n9|Hold'),

  (2, 1, 'CompanyType', '1|Client'),

  (3, 1, 'TaskDurationType', '1|hours\n24|days'),

  (4, 1, 'EventType', '0|General\n1|Appointment\n2|Meeting\n3|All Day Event\n4|Anniversary\n5|Reminder'),

  (5, 1, 'TaskStatus', '0|Active\n-1|Inactive'),

  (6, 1, 'TaskType', '0|Unknown\n1|Administrative\n2|Operative'),

  (7, 2, 'ProjectType', '0| All\r\n1| App Mgt - Blue\r\n2| ROI - Green\r\n3| Learn Net - White\r\n4| Edu Tech - Lilac\r\n5| Online Edu - Orange\r\n6| Office Mgmnt - Pink\r\n7| Apps Training - Purple\r\n8| Edu Programs - Yellow\r\n9| Strategic Plan - Turq'),

  (8, 3, 'ProjectColors', 'Web|FFE0AE\r\nEngineering|AEFFB2\r\nHelpDesk|FFFCAE\r\nSystem Administration|FFAEAE'),

  (9, 1, 'FileType', '0|Unknown\n1|Document\n2|Application'),

  (10, 1, 'TaskPriority', '-1|low\n0|normal\n1|high'),

  (11, 1, 'ProjectPriority', '-1|3-LOW\r\n0|2-MEDIUM\r\n1|1-HIGH\r\n2|2-UNKNOWN'),

  (12, 1, 'ProjectPriorityColor', '-1|#D4E2F7\r\n0|#009999\r\n1|#EFA9A9'),

  (13, 1, 'TaskLogReference', '0|Not Defined\n1|Email\n2|Helpdesk\n3|Phone Call\n4|Fax'),

  (14, 1, 'TaskLogReferenceImage', '0| 1|./images/obj/email.gif 2|./modules/helpdesk/images/helpdesk.png 3|./images/obj/phone.gif 4|./images/icons/stock_print-16.png'),

  (15, 1, 'BudgetCode', '0|UH 1|MedSchool 2|HMO'),

  (16, 3, 'ProjectStatusColor', '0|#D4E3F7\r\n1|#D8BFD8\r\n2|#F7F7D4\r\n3|#FFFFFF\r\n4|#F7E9D4\r\n5|#E9E9E9\r\n6|#E9E9E9\r\n7|#FFFFFF\r\n8|#D5F7D4'),

  (17, 1, 'ProjectRequiredFields', 'f.project_name.value.length|<3\r\nf.project_color_identifier.value.length|<3\r\nf.project_company.options[f.project_company.selectedIndex].value|<1'),

  (18, 1, 'UserType', '0|Default User\r\n1|Administrator\r\n2|CEO\r\n3|Director\r\n4|Branch Manager\r\n5|Manager\r\n6|Supervisor\r\n7|Employee'),

  (19, 1, 'TicketNotify', '0|admin@localhost\n1|admin@localhost\n2|admin@localhost\r\n3|admin@localhost\r\n4|admin@localhost'),

  (20, 1, 'TicketPriority', '0|Low\n1|Normal\n2|High\n3|Highest\n4|911'),

  (21, 1, 'TicketStatus', '0|Open\n1|Closed\n2|Deleted'),

  (24, 4, 'HelpDeskPriority', '0|Not Specified\n1|Low\n2|Medium\n3|High'),

  (25, 4, 'HelpDeskSeverity', '0|Not Specified\n1|No Impact\n2|Low\n3|Medium\n4|High\n5|Critical'),

  (26, 4, 'HelpDeskCallType', '0|Not Specified\r\n1|Activity still in progress\r\n2|Wrong activity on plan\r\n3|Quiz didn''t score\r\n4|How to unenroll\r\n5|Unable to log in\r\n6|Delete activity from transcript\r\n7|Manager - Staff list\r\n8|Learning module or SCORM\r\n9|Other'),

  (27, 4, 'HelpDeskSource', '0|Not Specified\r\n1|E-Mail\r\n2|Phone\r\n3|In Person\r\n4|Fax'),

  (28, 4, 'HelpDeskOS', '0|End-User\r\n1|Manager\r\n2|Facilitator\r\n3|Other'),

  (29, 4, 'HelpDeskApplic', '0|Not Applicable\r\n1|LMS\r\n2|Learning Module/Quiz'),

  (30, 4, 'HelpDeskStatus', '0|Unassigned\n1|Open\n2|Closed\n3|On Hold\n4|Testing'),

  (31, 4, 'HelpDeskAuditTrail', '0|Created\n1|Title\n2|Requestor Name\n3|Requestor E-mail\n4|Requestor Phone\n5|Assigned To\n6|Notify by e-mail\n7|Company\n8|Project\n9|Call Type\n10|Call Source\n11|Status\n12|Priority\n13|Severity\n14|Operating System\n15|Application\n16|Summary\n17|Deleted'),

  (35, 3, 'ProjectTypeColor', '0|#CCCCCC;\r\n1|#6699cc\r\n2|#66cc99\r\n3|#FFFFFF\r\n4|#ccccff\r\n5|#ff9966\r\n6|#ff99cc\r\n7|#660099\r\n8|#ffffcc\r\n9|#009999'),

  (32, 2, 'Complete?', '0|Yes\r\n1|No'),

  (36, 1, 'TicketSubject', '0| Other\r\n1|activity still in progress\r\n2|wrong activity on plan\r\n3|quiz didn''t score\r\n4|how to unenroll\r\n5|unable to log in\r\n6|delete activity from transcript\r\n7|Unable to open modules or quizzes\r\n8|Facilitator access\r\n9|How to Use\r\n10|Fix Learning Activity or Portal'); 

Enhanced To-do list for each user

Reorder the tasks on your list: we very rarely share tasks, so each task basically has one assigned user. As a result, I was able to use a field in the main tasks table to keep track of a task-order value, so each person could order their tasks on a big list.

This should really be done with a separate table and some jquery-style drag-n-drop so you can move your tasks around in the list, but that's all for a future upgrade. This quick-and dirty-version works for small teams with minimal task sharing.

Help-call log based on ticket module

I modified the ticket system to create a sort of call log. We don't really need a real ticket system per se, but we do need a way to keep statistics on what kinds of requests for help come in. So I've started to work on making this a one-page module. Everything is entered and filtered on one page. A work in progress.

3 Comments

• << Previous
• Next >>

tony | November 23, 2009 2:16 PM

thanks for this!!!!!

have you looked at web2project??

Lee | January 25, 2010 11:20 AM

Your 'Projects' layout is so much more along the lines of what I need to produce. Can you provide more information on how you got it to look like that? I am some what a newbie at DPJ and editing the files, but with a little much appreciated guidance I can do it.

Thank you in advance!

-Lee

Ellen replied to comment from Lee | January 25, 2010 11:43 AM

Take a look at this post - you may have missed it because I forgot to categorize it as dotproject:

http://thedesignspace.net/MT2archives/000277.html

Let me know if that helps.

• << Previous
• Next >>