model.itop-request-mgmt.php 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194
  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', 'freeze_reason', OPT_ATT_HIDDEN);
  55. MetaModel::Init_OverloadStateAttribute('frozen', 'freeze_reason', OPT_ATT_MANDATORY | OPT_ATT_MUSTPROMPT);
  56. MetaModel::Init_OverloadStateAttribute('escalated_tto', 'freeze_reason', OPT_ATT_HIDDEN);
  57. MetaModel::Init_OverloadStateAttribute('escalated_ttr', 'freeze_reason', OPT_ATT_HIDDEN);
  58. MetaModel::Init_OverloadStateAttribute('resolved', 'freeze_reason', OPT_ATT_HIDDEN);
  59. MetaModel::Init_OverloadStateAttribute('closed', 'request_type', OPT_ATT_READONLY);
  60. MetaModel::Init_OverloadStateAttribute('closed', 'freeze_reason', OPT_ATT_HIDDEN);
  61. MetaModel::Init_DefineStimulus(new StimulusUserAction("ev_freeze", array()));
  62. MetaModel::Init_DefineTransition("assigned", "ev_freeze", array("target_state"=>"frozen", "actions"=>array(), "user_restriction"=>null));
  63. MetaModel::Init_DefineTransition("frozen", "ev_timeout", array("target_state"=>"escalated_ttr", "actions"=>array(), "user_restriction"=>null));
  64. MetaModel::Init_DefineTransition("frozen", "ev_assign", array("target_state"=>"assigned", "actions"=>array(), "user_restriction"=>null));
  65. MetaModel::Init_DefineTransition("frozen", "ev_resolve", array("target_state"=>"resolved", "actions"=>array(), "user_restriction"=>null));
  66. }
  67. public function ComputeValues()
  68. {
  69. $sCurrRef = $this->Get('ref');
  70. if (strlen($sCurrRef) == 0)
  71. {
  72. $iKey = $this->GetKey();
  73. if ($iKey < 0)
  74. {
  75. // Object not yet in the Database
  76. $iKey = MetaModel::GetNextKey(get_class($this));
  77. }
  78. $sName = sprintf('R-%06d', $iKey);
  79. $this->Set('ref', $sName);
  80. }
  81. return parent::ComputeValues();
  82. }
  83. /**
  84. * Get the icon representing this object
  85. * @param boolean $bImgTag If true the result is a full IMG tag (or an emtpy string if no icon is defined)
  86. * @return string Either the full IMG tag ($bImgTag == true) or just the path to the icon file
  87. */
  88. public function GetIcon($bImgTag = true)
  89. {
  90. $sStatus = $this->Get('status');
  91. switch($this->GetState())
  92. {
  93. case 'escalated_tto':
  94. case 'escalated_ttr':
  95. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  96. break;
  97. case 'resolved':
  98. case 'closed':
  99. $sIcon = self::MakeIconFromName('user-request-closed.png');
  100. break;
  101. case 'new':
  102. $sIcon = self::MakeIconFromName('user-request.png');
  103. $oEscalationDeadline = $this->Get('tto_escalation_deadline');
  104. if ($oEscalationDeadline != null)
  105. {
  106. // A SLA is running
  107. $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date'));
  108. $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline);
  109. $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate);
  110. if ($ratio <= 0)
  111. {
  112. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  113. }
  114. else if ($ratio <= 0.25)
  115. {
  116. $sIcon = self::MakeIconFromName('user-request-deadline.png');
  117. }
  118. }
  119. break;
  120. case 'assigned':
  121. $sIcon = self::MakeIconFromName('user-request.png');
  122. $oEscalationDeadline = $this->Get('ttr_escalation_deadline');
  123. if ($oEscalationDeadline != null)
  124. {
  125. // A SLA is running
  126. $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date'));
  127. $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline);
  128. $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate);
  129. if ($ratio <= 0)
  130. {
  131. $sIcon = self::MakeIconFromName('user-request-escalated.png');
  132. }
  133. else if ($ratio <= 0.25)
  134. {
  135. $sIcon = self::MakeIconFromName('user-request-deadline.png');
  136. }
  137. }
  138. break;
  139. default:
  140. $sIcon = MetaModel::GetClassIcon(get_class($this), $bImgTag);
  141. }
  142. return $sIcon;
  143. }
  144. protected static function MakeIconFromName($sIconName, $bImgTag = true)
  145. {
  146. $sIcon = '';
  147. if ($sIconName != '')
  148. {
  149. $sPath = '../modules/itop-request-mgmt-1.0.0/images/'.$sIconName;
  150. if ($bImgTag)
  151. {
  152. $sIcon = "<img src=\"$sPath\" style=\"vertical-align:middle;\"/>";
  153. }
  154. else
  155. {
  156. $sIcon = $sPath;
  157. }
  158. }
  159. return $sIcon;
  160. }
  161. }
  162. $oMyMenuGroup = new MenuGroup('RequestManagement', 30 /* fRank */);
  163. new TemplateMenuNode('UserRequest:Overview', '../modules/itop-request-mgmt-1.0.0/overview.html', $oMyMenuGroup->GetIndex() /* oParent */, 0 /* fRank */);
  164. new NewObjectMenuNode('NewUserRequest', 'UserRequest', $oMyMenuGroup->GetIndex(), 1 /* fRank */);
  165. new SearchMenuNode('SearchUserRequests', 'UserRequest', $oMyMenuGroup->GetIndex(), 2 /* fRank */);
  166. $oShortcutNode = new TemplateMenuNode('UserRequest:Shortcuts', '', $oMyMenuGroup->GetIndex(), 3 /* fRank */);
  167. $oNode = new OQLMenuNode('UserRequest:MyRequests', 'SELECT UserRequest WHERE agent_id = :current_contact_id AND status NOT IN ("closed","resolved")', $oShortcutNode->GetIndex(), 1 /* fRank */);
  168. $oNode->SetParameters(array('auto_reload' => 'fast'));
  169. $oNode = new OQLMenuNode('UserRequest:EscalatedRequests', 'SELECT UserRequest WHERE status IN ("escalated_tto", "escalated_ttr")', $oShortcutNode->GetIndex(), 2 /* fRank */);
  170. $oNode->SetParameters(array('auto_reload' => 'fast'));
  171. $oNode = new OQLMenuNode('UserRequest:OpenRequests', 'SELECT UserRequest WHERE status IN ("new", "assigned", "escalated_tto", "escalated_ttr", "frozen", "resolved")', $oShortcutNode->GetIndex(), 3 /* fRank */);
  172. $oNode->SetParameters(array('auto_reload' => 'fast'));
  173. ?>