* @author Romain Quetiez * @author Denis Flaven * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL */ class UserRequest extends ResponseTicket { public static function Init() { $aParams = array ( "category" => "bizmodel,searchable,requestmgmt", "key_type" => "autoincrement", "name_attcode" => "ref", "state_attcode" => "status", "reconc_keys" => array("ref"), "db_table" => "ticket_request", "db_key_field" => "id", "db_finalclass_field" => "", "display_template" => "", "icon" => "../modules/itop-request-mgmt-1.0.0/images/user-request.png", ); MetaModel::Init_Params($aParams); MetaModel::Init_InheritAttributes(); MetaModel::Init_InheritLifecycle(); 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()))); MetaModel::Init_AddAttribute(new AttributeString("freeze_reason", array("allowed_values"=>null, "sql"=>"freeze_reason", "default_value"=>null, "is_null_allowed"=>true, "depends_on"=>array()))); MetaModel::Init_SetZListItems('details', array('document_list', 'ci_list', 'contact_list','incident_list', 'col:col1' => array( 'fieldset:Ticket:baseinfo' => array('ref','title','org_id','status','priority','request_type','service_id','servicesubcategory_id','product' ), 'fieldset:Ticket:moreinfo' => array('impact','urgency','description','resolution_code', 'solution', 'user_satisfaction', 'user_commment','freeze_reason'), ), 'col:col2' => array( 'fieldset:Ticket:date' => array('start_date','last_update','assignment_date','tto_escalation_deadline', 'ttr_escalation_deadline', 'close_date', 'closure_deadline',), 'fieldset:Ticket:contact' => array('caller_id','workgroup_id','agent_id',), 'fieldset:Ticket:relation' => array('related_problem_id', 'related_change_id'), ) )); // 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')); 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')); 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')); MetaModel::Init_SetZListItems('list', array('title', 'org_id', 'start_date', 'status', 'service_id', 'priority', 'workgroup_id', 'agent_id')); MetaModel::Init_OverloadStateAttribute('frozen', 'freeze_reason', OPT_ATT_MANDATORY); // The freeze reason remains hidden in all other states MetaModel::Init_OverloadStateAttribute('new', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('new', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_OverloadStateAttribute('assigned', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('assigned', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_OverloadStateAttribute('frozen', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('frozen', 'freeze_reason', OPT_ATT_MANDATORY | OPT_ATT_MUSTPROMPT); MetaModel::Init_OverloadStateAttribute('escalated_tto', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('escalated_tto', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_OverloadStateAttribute('escalated_ttr', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('escalated_ttr', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_OverloadStateAttribute('resolved', 'request_type', OPT_ATT_MANDATORY); MetaModel::Init_OverloadStateAttribute('resolved', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_OverloadStateAttribute('closed', 'request_type', OPT_ATT_READONLY); MetaModel::Init_OverloadStateAttribute('closed', 'freeze_reason', OPT_ATT_HIDDEN); MetaModel::Init_DefineStimulus(new StimulusUserAction("ev_freeze", array())); MetaModel::Init_DefineTransition("assigned", "ev_freeze", array("target_state"=>"frozen", "actions"=>array(), "user_restriction"=>null)); MetaModel::Init_DefineTransition("frozen", "ev_timeout", array("target_state"=>"escalated_ttr", "actions"=>array(), "user_restriction"=>null)); MetaModel::Init_DefineTransition("frozen", "ev_assign", array("target_state"=>"assigned", "actions"=>array(), "user_restriction"=>null)); MetaModel::Init_DefineTransition("frozen", "ev_resolve", array("target_state"=>"resolved", "actions"=>array(), "user_restriction"=>null)); } public function ComputeValues() { $sCurrRef = $this->Get('ref'); if (strlen($sCurrRef) == 0) { $iKey = $this->GetKey(); if ($iKey < 0) { // Object not yet in the Database $iKey = MetaModel::GetNextKey(get_class($this)); } $sName = sprintf('R-%06d', $iKey); $this->Set('ref', $sName); } return parent::ComputeValues(); } /** * Get the icon representing this object * @param boolean $bImgTag If true the result is a full IMG tag (or an emtpy string if no icon is defined) * @return string Either the full IMG tag ($bImgTag == true) or just the path to the icon file */ public function GetIcon($bImgTag = true) { $sStatus = $this->Get('status'); switch($this->GetState()) { case 'escalated_tto': case 'escalated_ttr': $sIcon = self::MakeIconFromName('user-request-escalated.png'); break; case 'resolved': case 'closed': $sIcon = self::MakeIconFromName('user-request-closed.png'); break; case 'new': $sIcon = self::MakeIconFromName('user-request.png'); $oEscalationDeadline = $this->Get('tto_escalation_deadline'); if ($oEscalationDeadline != null) { // A SLA is running $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date')); $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline); $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate); if ($ratio <= 0) { $sIcon = self::MakeIconFromName('user-request-escalated.png'); } else if ($ratio <= 0.25) { $sIcon = self::MakeIconFromName('user-request-deadline.png'); } } break; case 'assigned': $sIcon = self::MakeIconFromName('user-request.png'); $oEscalationDeadline = $this->Get('ttr_escalation_deadline'); if ($oEscalationDeadline != null) { // A SLA is running $iStartDate = AttributeDateTime::GetAsUnixSeconds($this->Get('start_date')); $iEscalationDeadline = AttributeDateTime::GetAsUnixSeconds($oEscalationDeadline); $ratio = ($iEscalationDeadline - time())/($iEscalationDeadline - $iStartDate); if ($ratio <= 0) { $sIcon = self::MakeIconFromName('user-request-escalated.png'); } else if ($ratio <= 0.25) { $sIcon = self::MakeIconFromName('user-request-deadline.png'); } } break; default: $sIcon = MetaModel::GetClassIcon(get_class($this), $bImgTag); } return $sIcon; } protected static function MakeIconFromName($sIconName, $bImgTag = true) { $sIcon = ''; if ($sIconName != '') { $sPath = '../modules/itop-request-mgmt-1.0.0/images/'.$sIconName; if ($bImgTag) { $sIcon = ""; } else { $sIcon = $sPath; } } return $sIcon; } } $oMyMenuGroup = new MenuGroup('RequestManagement', 30 /* fRank */); new TemplateMenuNode('UserRequest:Overview', '../modules/itop-request-mgmt-1.0.0/overview.html', $oMyMenuGroup->GetIndex() /* oParent */, 0 /* fRank */); new NewObjectMenuNode('NewUserRequest', 'UserRequest', $oMyMenuGroup->GetIndex(), 1 /* fRank */); new SearchMenuNode('SearchUserRequests', 'UserRequest', $oMyMenuGroup->GetIndex(), 2 /* fRank */); $oShortcutNode = new TemplateMenuNode('UserRequest:Shortcuts', '', $oMyMenuGroup->GetIndex(), 3 /* fRank */); $oNode = new OQLMenuNode('UserRequest:MyRequests', 'SELECT UserRequest WHERE agent_id = :current_contact_id AND status NOT IN ("closed","resolved")', $oShortcutNode->GetIndex(), 1 /* fRank */); $oNode->SetParameters(array('auto_reload' => 'fast')); $oNode = new OQLMenuNode('UserRequest:EscalatedRequests', 'SELECT UserRequest WHERE status IN ("escalated_tto", "escalated_ttr")', $oShortcutNode->GetIndex(), 2 /* fRank */); $oNode->SetParameters(array('auto_reload' => 'fast')); $oNode = new OQLMenuNode('UserRequest:OpenRequests', 'SELECT UserRequest WHERE status IN ("new", "assigned", "escalated_tto", "escalated_ttr", "frozen", "resolved")', $oShortcutNode->GetIndex(), 3 /* fRank */); $oNode->SetParameters(array('auto_reload' => 'fast')); ?>