model.itop-request-mgmt.php 9.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. <?php
  2. // Copyright (C) 2010 Combodo SARL
  3. //
  4. // This program is free software; you can redistribute it and/or modify
  5. // it under the terms of the GNU General Public License as published by
  6. // the Free Software Foundation; version 3 of the License.
  7. //
  8. // This program is distributed in the hope that it will be useful,
  9. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  10. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  11. // GNU General Public License for more details.
  12. //
  13. // You should have received a copy of the GNU General Public License
  14. // along with this program; if not, write to the Free Software
  15. // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  16. /**
  17. * Persistent classes for a CMDB
  18. *
  19. * @author Erwan Taloc <erwan.taloc@combodo.com>
  20. * @author Romain Quetiez <romain.quetiez@combodo.com>
  21. * @author Denis Flaven <denis.flaven@combodo.com>
  22. * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL
  23. */
  24. class UserRequest extends ResponseTicket
  25. {
  26. public static function Init()
  27. {
  28. $aParams = array
  29. (
  30. "category" => "bizmodel,searchable,requestmgmt",
  31. "key_type" => "autoincrement",
  32. "name_attcode" => "ref",
  33. "state_attcode" => "status",
  34. "reconc_keys" => array("ref"),
  35. "db_table" => "ticket_request",
  36. "db_key_field" => "id",
  37. "db_finalclass_field" => "",
  38. "display_template" => "",
  39. "icon" => "../modules/itop-request-mgmt-1.0.0/images/user-request.png",
  40. );
  41. MetaModel::Init_Params($aParams);
  42. MetaModel::Init_InheritAttributes();
  43. MetaModel::Init_InheritLifecycle();
  44. MetaModel::Init_AddAttribute(new AttributeEnum("request_type", array("allowed_values"=>new ValueSetEnum('service request,issue,information'), "sql"=>"request_type", "default_value"=>"service request", "is_null_allowed"=>false, "depends_on"=>array())));
  45. MetaModel::Init_AddAttribute(new AttributeString("freeze_reason", array("allowed_values"=>null, "sql"=>"freeze_reason", "default_value"=>null, "is_null_allowed"=>true, "depends_on"=>array())));
  46. MetaModel::Init_SetZListItems('details', array('ref', 'title', 'org_id', 'description', 'request_type','ticket_log', 'start_date', 'tto_escalation_deadline', 'ttr_escalation_deadline', 'document_list', 'ci_list', 'contact_list','incident_list', 'status', 'caller_id', 'service_id', 'servicesubcategory_id', 'product', 'impact', 'urgency', 'priority', 'workgroup_id', 'agent_id', 'agent_email', 'related_problem_id', 'related_change_id', 'close_date', 'last_update', 'assignment_date', 'closure_deadline', 'resolution_code', 'solution', 'user_satisfaction', 'user_commment', 'freeze_reason'));
  47. MetaModel::Init_SetZListItems('advanced_search', array('ref', 'title', 'org_id', 'start_date', 'status', 'caller_id', 'service_id', 'servicesubcategory_id', 'product', 'impact', 'urgency', 'priority', 'workgroup_id', 'agent_id', 'agent_email', 'related_problem_id', 'related_change_id', 'close_date', 'resolution_code', 'solution', 'user_satisfaction', 'user_commment'));
  48. MetaModel::Init_SetZListItems('standard_search', array('ref', 'title', 'org_id', 'request_type','start_date', 'status', 'caller_id', 'service_id', 'servicesubcategory_id', 'product', 'impact', 'urgency', 'priority', 'workgroup_id', 'agent_id', 'agent_email', 'close_date', 'resolution_code', 'solution', 'user_satisfaction', 'user_commment'));
  49. MetaModel::Init_SetZListItems('list', array('title', 'org_id', 'start_date', 'status', 'service_id', 'priority', 'workgroup_id', 'agent_id'));
  50. MetaModel::Init_OverloadStateAttribute('frozen', 'freeze_reason', OPT_ATT_MANDATORY);
  51. // The freeze reason remains hidden in all other states
  52. MetaModel::Init_OverloadStateAttribute('new', 'request_type', OPT_ATT_MANDATORY);
  53. MetaModel::Init_OverloadStateAttribute('new', 'freeze_reason', OPT_ATT_HIDDEN);
  54. MetaModel::Init_OverloadStateAttribute('assigned', 'request_type', OPT_ATT_MANDATORY);
  55. MetaModel::Init_OverloadStateAttribute('assigned', 'freeze_reason', OPT_ATT_HIDDEN);
  56. MetaModel::Init_OverloadStateAttribute('frozen', 'request_type', OPT_ATT_MANDATORY);
  57. MetaModel::Init_OverloadStateAttribute('frozen', 'freeze_reason', OPT_ATT_MANDATORY | OPT_ATT_MUSTPROMPT);
  58. MetaModel::Init_OverloadStateAttribute('escalated_tto', 'request_type', OPT_ATT_MANDATORY);
  59. MetaModel::Init_OverloadStateAttribute('escalated_tto', 'freeze_reason', OPT_ATT_HIDDEN);
  60. MetaModel::Init_OverloadStateAttribute('escalated_ttr', 'request_type', OPT_ATT_MANDATORY);
  61. MetaModel::Init_OverloadStateAttribute('escalated_ttr', 'freeze_reason', OPT_ATT_HIDDEN);
  62. MetaModel::Init_OverloadStateAttribute('resolved', 'request_type', OPT_ATT_MANDATORY);
  63. MetaModel::Init_OverloadStateAttribute('resolved', 'freeze_reason', OPT_ATT_HIDDEN);
  64. MetaModel::Init_OverloadStateAttribute('closed', 'request_type', OPT_ATT_READONLY);
  65. MetaModel::Init_OverloadStateAttribute('closed', 'freeze_reason', OPT_ATT_HIDDEN);
  66. MetaModel::Init_DefineStimulus(new StimulusUserAction("ev_freeze", array()));
  67. MetaModel::Init_DefineTransition("assigned", "ev_freeze", array("target_state"=>"frozen", "actions"=>array(), "user_restriction"=>null));
  68. MetaModel::Init_DefineTransition("frozen", "ev_timeout", array("target_state"=>"escalated_ttr", "actions"=>array(), "user_restriction"=>null));
  69. MetaModel::Init_DefineTransition("frozen", "ev_assign", array("target_state"=>"assigned", "actions"=>array(), "user_restriction"=>null));
  70. MetaModel::Init_DefineTransition("frozen", "ev_resolve", array("target_state"=>"resolved", "actions"=>array(), "user_restriction"=>null));
  71. }
  72. public function ComputeValues()
  73. {
  74. $sCurrRef = $this->Get('ref');
  75. if (strlen($sCurrRef) == 0)
  76. {
  77. $iKey = $this->GetKey();
  78. if ($iKey < 0)
  79. {
  80. // Object not yet in the Database
  81. $iKey = MetaModel::GetNextKey(get_class($this));
  82. }
  83. $sName = sprintf('R-%06d', $iKey);
  84. $this->Set('ref', $sName);
  85. }
  86. return parent::ComputeValues();
  87. }
  88. /**
  89. * Get the icon representing this object
  90. * @param boolean $bImgTag If true the result is a full IMG tag (or an emtpy string if no icon is defined)
  91. * @return string Either the full IMG tag ($bImgTag == true) or just the path to the icon file
  92. */
  93. public function GetIcon($bImgTag = true)
  94. {
  95. $sStatus = $this->Get('status');
  96. switch($this->GetState())
  97. {
  98. case 'escalated_tto':
  99. case 'escalated_ttr':
  100. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  101. break;
  102. case 'resolved':
  103. case 'closed':
  104. $sIcon = self::MakeIconFromName('user-request-closed.png');
  105. break;
  106. case 'new':
  107. $sIcon = self::MakeIconFromName('user-request.png');
  108. $oEscalationDeadline = $this->Get('tto_escalation_deadline');
  109. if ($oEscalationDeadline != null)
  110. {
  111. // A SLA is running
  112. $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date'));
  113. $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline);
  114. $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate);
  115. if ($ratio <= 0)
  116. {
  117. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  118. }
  119. else if ($ratio <= 0.25)
  120. {
  121. $sIcon = self::MakeIconFromName('user-request-deadline.png');
  122. }
  123. }
  124. break;
  125. case 'assigned':
  126. $sIcon = self::MakeIconFromName('user-request.png');
  127. $oEscalationDeadline = $this->Get('ttr_escalation_deadline');
  128. if ($oEscalationDeadline != null)
  129. {
  130. // A SLA is running
  131. $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date'));
  132. $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline);
  133. $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate);
  134. if ($ratio <= 0)
  135. {
  136. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  137. }
  138. else if ($ratio <= 0.25)
  139. {
  140. $sIcon = self::MakeIconFromName('user-request-deadline.png');
  141. }
  142. }
  143. break;
  144. default:
  145. $sIcon = MetaModel::GetClassIcon(get_class($this), $bImgTag);
  146. }
  147. return $sIcon;
  148. }
  149. protected static function MakeIconFromName($sIconName, $bImgTag = true)
  150. {
  151. $sIcon = '';
  152. if ($sIconName != '')
  153. {
  154. $sPath = '../modules/itop-request-mgmt-1.0.0/images/'.$sIconName;
  155. if ($bImgTag)
  156. {
  157. $sIcon = "<img src=\"$sPath\" style=\"vertical-align:middle;\"/>";
  158. }
  159. else
  160. {
  161. $sIcon = $sPath;
  162. }
  163. }
  164. return $sIcon;
  165. }
  166. }
  167. $oMyMenuGroup = new MenuGroup('RequestManagement', 30 /* fRank */);
  168. new TemplateMenuNode('UserRequest:Overview', '../modules/itop-request-mgmt-1.0.0/overview.html', $oMyMenuGroup->GetIndex() /* oParent */, 0 /* fRank */);
  169. new NewObjectMenuNode('NewUserRequest', 'UserRequest', $oMyMenuGroup->GetIndex(), 1 /* fRank */);
  170. new SearchMenuNode('SearchUserRequests', 'UserRequest', $oMyMenuGroup->GetIndex(), 2 /* fRank */);
  171. $oShortcutNode = new TemplateMenuNode('UserRequest:Shortcuts', '', $oMyMenuGroup->GetIndex(), 3 /* fRank */);
  172. $oNode = new OQLMenuNode('UserRequest:MyRequests', 'SELECT UserRequest WHERE agent_id = :current_contact_id AND status NOT IN ("closed","resolved")', $oShortcutNode->GetIndex(), 1 /* fRank */);
  173. $oNode->SetParameters(array('auto_reload' => 'fast'));
  174. $oNode = new OQLMenuNode('UserRequest:EscalatedRequests', 'SELECT UserRequest WHERE status IN ("escalated_tto", "escalated_ttr")', $oShortcutNode->GetIndex(), 2 /* fRank */);
  175. $oNode->SetParameters(array('auto_reload' => 'fast'));
  176. $oNode = new OQLMenuNode('UserRequest:OpenRequests', 'SELECT UserRequest WHERE status IN ("new", "assigned", "escalated_tto", "escalated_ttr", "frozen", "resolved")', $oShortcutNode->GetIndex(), 3 /* fRank */);
  177. $oNode->SetParameters(array('auto_reload' => 'fast'));
  178. ?>