Ethan/HICCC/Service Request System

From Informatics

Jump to: navigation, search

Contents


Services encompasses several applications used within the Cancer Center. Membership Application, Shared Resource Request System (SRRS) and Shared Resource Feedback are the three currently available applications.


Files

  • /services/request/lib/class.resource.php - handles resources available to the SRRS
  • /services/request/lib/class.service.request.php - handles requests to the SRRS
  • /services/admin/class.admin.service.request.php - handles requests for the administrator of the SRRS
  • /services/request/lib/class.srmailer.php - handles e-mail sent from the SRRS
  • /services/request/lib/config.php - configuration for the SRRS
  • /services/request/lib/lib.php - library for the SRRS


Databases

hicccweb.service_request 

+-------------------+---------------------------+------+-----+------------------+----------------+
| Field             | Type                      | Null | Key | Default          | Extra          |
+-------------------+---------------------------+------+-----+------------------+----------------+
| sr_id             | int(11)                   |      | PRI | NULL             | auto_increment |
| sr_pi_name        | varchar(100)              | YES  |     | NULL             |                |
| sr_pi_id          | varchar(40)               | YES  |     | NULL             |                |
| sr_pi_email       | varchar(100)              | YES  |     | NULL             |                |
| sr_contact_name   | varchar(100)              | YES  |     | NULL             |                |
| sr_contact_email  | varchar(100)              | YES  |     | NULL             |                |
| sr_contact_phone  | varchar(25)               | YES  |     | NULL             |                |
| sr_resource       | varchar(100)              | YES  |     | NULL             |                |
| sr_service        | varchar(100)              | YES  |     | NULL             |                |
| sr_complete_date  | int(16) unsigned zerofill | YES  |     | 0000000000000000 |                |
| sr_comments       | text                      | YES  |     | NULL             |                |
| sr_units          | varchar(30)               | YES  |     | NULL             |                |
| sr_num_units      | int(11)                   | YES  |     | 0                |                |
| sr_email_token    | varchar(32)               | YES  |     | NULL             |                |
| sr_ticket_id      | int(11)                   | YES  |     | NULL             |                |
| sr_admin_comments | text                      | YES  |     | NULL             |                |
+-------------------+---------------------------+------+-----+------------------+----------------+

hicccweb.service_request_event 

+---------------+---------------------------+------+-----+---------+----------------+
| Field         | Type                      | Null | Key | Default | Extra          |
+---------------+---------------------------+------+-----+---------+----------------+
| sre_id        | int(11)                   |      | PRI | NULL    | auto_increment |
| sre_sr_id     | int(11)                   | YES  |     | NULL    |                |
| sre_event     | tinyint(3) unsigned       | YES  |     | NULL    |                |
| sre_timestamp | int(14) unsigned zerofill | YES  |     | NULL    |                |
| sre_user      | int(11)                   | YES  |     | 0       |                |
+---------------+---------------------------+------+-----+---------+----------------+
Retrieved from "http://wiki.c2b2.columbia.edu/informatics/index.php/Ethan/HICCC/Service_Request_System"
Personal tools