index.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881
  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. * iTop User Portal main page
  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. require_once('../approot.inc.php');
  25. require_once(APPROOT.'/application/application.inc.php');
  26. require_once(APPROOT.'/application/nicewebpage.class.inc.php');
  27. require_once(APPROOT.'/application/wizardhelper.class.inc.php');
  28. define('SERVICECATEGORY_QUERY', 'SELECT Service AS s JOIN SLA AS sla ON sla.service_id=s.id JOIN lnkContractToSLA AS ln ON ln.sla_id=sla.id JOIN CustomerContract AS cc ON ln.contract_id=cc.id WHERE cc.org_id = :org_id');
  29. define('SERVICE_SUBCATEGORY_QUERY', 'SELECT ServiceSubcategory WHERE service_id = :svc_id');
  30. define('VALIDATE_SERVICECATEGORY_QUERY', 'SELECT Service AS s JOIN SLA AS sla ON sla.service_id=s.id JOIN lnkContractToSLA AS ln ON ln.sla_id=sla.id JOIN CustomerContract AS cc ON ln.contract_id=cc.id WHERE cc.org_id = :org_id AND s.id = :id');
  31. define('VALIDATE_SERVICESUBCATEGORY_QUERY', 'SELECT ServiceSubcategory AS Sub JOIN Service AS Svc ON Sub.service_id = Svc.id WHERE Sub.id=:id');
  32. define('ALL_PARAMS', 'from_service_id,org_id,caller_id,service_id,servicesubcategory_id,title,description,impact,urgency,workgroup_id,moreinfo,caller_id,start_date,end_date,duration,impact_duration');
  33. /**
  34. * Displays the portal main menu
  35. * @param WebPage $oP The current web page
  36. * @return void
  37. */
  38. function DisplayMainMenu(WebPage $oP)
  39. {
  40. $oP->AddMenuButton('showongoing', 'Portal:ShowOngoing', '../portal/index.php?operation=show_ongoing');
  41. $oP->AddMenuButton('newrequest', 'Portal:CreateNewRequest', '../portal/index.php?operation=create_request');
  42. $oP->AddMenuButton('showclosed', 'Portal:ShowClosed', '../portal/index.php?operation=show_closed');
  43. if (UserRights::CanChangePassword())
  44. {
  45. $oP->AddMenuButton('change_pwd', 'Portal:ChangeMyPassword', '../portal/index.php?loginop=change_pwd');
  46. }
  47. }
  48. /**
  49. * Displays the current tickets
  50. * @param WebPage $oP The current web page
  51. * @return void
  52. */
  53. function ShowOngoingTickets(WebPage $oP)
  54. {
  55. $oP->add("<div id=\"open_requests\">\n");
  56. $oP->add("<h1 id=\"title_open_requests\">".Dict::S('Portal:OpenRequests')."</h1>\n");
  57. ListOpenRequests($oP);
  58. $oP->add("</div>\n");
  59. $oP->add("<div id=\"#div_resolved_requests\">\n");
  60. $oP->add("<h1 id=\"#resolved_requests\">".Dict::S('Portal:ResolvedRequests')."</h1>\n");
  61. ListResolvedRequests($oP);
  62. $oP->add("</div>\n");
  63. }
  64. /**
  65. * Displays the closed tickets
  66. * @param WebPage $oP The current web page
  67. * @return void
  68. */
  69. function ShowClosedTickets(WebPage $oP)
  70. {
  71. $oP->add("<div id=\"#closed_tickets\">\n");
  72. //$oP->add("<h1 id=\"#closed_tickets\">".Dict::S('Portal:ListClosedTickets')."</h1>\n");
  73. ListClosedTickets($oP);
  74. $oP->add("</div>\n");
  75. }
  76. /**
  77. * Displays the form to select a Service Category Id (among the valid ones for the specified user Organization)
  78. * @param WebPage $oP Web page for the form output
  79. * @param Organization $oUserOrg The organization of the current user
  80. * @return void
  81. */
  82. function SelectServiceCategory($oP, $oUserOrg)
  83. {
  84. $aParameters = $oP->ReadAllParams(ALL_PARAMS);
  85. $oP->add("<div class=\"wizContainer\" id=\"form_select_service\">\n");
  86. $oP->WizardFormStart('request_wizard', 1);
  87. $oP->add("<h1 id=\"select_category\">".Dict::S('Portal:SelectService')."</h1>\n");
  88. $oP->add("<table>\n");
  89. $oSearch = DBObjectSearch::FromOQL(SERVICECATEGORY_QUERY);
  90. $oSet = new CMDBObjectSet($oSearch, array(), array('org_id' => $oUserOrg->GetKey()));
  91. while($oService = $oSet->Fetch())
  92. {
  93. $id = $oService->GetKey();
  94. $sChecked = "";
  95. if (isset($aParameters['service_id']) && ($id == $aParameters['service_id']))
  96. {
  97. $sChecked = "checked";
  98. }
  99. $oP->p("<tr><td style=\"vertical-align:top\"><p><input name=\"attr_service_id\" $sChecked type=\"radio\" id=\"service_$id\" value=\"$id\"></p></td><td style=\"vertical-align:top\"><p><b><label for=\"service_$id\">".$oService->GetName()."</label></b></p>");
  100. $oP->p("<p>".$oService->GetAsHTML('description')."</p></td></tr>");
  101. }
  102. $oP->add("</table>\n");
  103. $oP->DumpHiddenParams($aParameters, array('service_id'));
  104. $oP->add("<input type=\"hidden\" name=\"operation\" value=\"create_request\">");
  105. $oP->WizardFormButtons(BUTTON_BACK | BUTTON_NEXT | BUTTON_CANCEL);
  106. $oP->WizardFormEnd();
  107. $oP->WizardCheckSelectionOnSubmit(Dict::S('Portal:PleaseSelectOneService'));
  108. $oP->add("</div>\n");
  109. }
  110. /**
  111. * Displays the form to select a Service Subcategory Id (among the valid ones for the specified user Organization)
  112. * and based on the page's parameter 'service_id'
  113. * @param WebPage $oP Web page for the form output
  114. * @param Organization $oUserOrg The organization of the current user
  115. * @return void
  116. */
  117. function SelectServiceSubCategory($oP, $oUserOrg)
  118. {
  119. $aParameters = $oP->ReadAllParams(ALL_PARAMS);
  120. $iSvcId = $aParameters['service_id'];
  121. $iDefaultSubSvcId = isset($aParameters['servicesubcategory_id']) ? $aParameters['servicesubcategory_id'] : 0;
  122. $iDefaultWizNext = 2;
  123. $oSearch = DBObjectSearch::FromOQL(SERVICE_SUBCATEGORY_QUERY);
  124. $oSet = new CMDBObjectSet($oSearch, array(), array('svc_id' => $iSvcId, 'org_id' => $oUserOrg->GetKey()));
  125. $oServiceCategory = MetaModel::GetObject('Service', $iSvcId, false);
  126. if (is_object($oServiceCategory))
  127. {
  128. $oP->add("<div class=\"wizContainer\" id=\"form_select_servicesubcategory\">\n");
  129. $oP->add("<h1 id=\"select_subcategory\">".Dict::Format('Portal:SelectSubcategoryFrom_Service', $oServiceCategory->GetName())."</h1>\n");
  130. $oP->WizardFormStart('request_wizard', $iDefaultWizNext);
  131. $oP->add("<table>\n");
  132. while($oSubService = $oSet->Fetch())
  133. {
  134. $id = $oSubService->GetKey();
  135. $sChecked = "";
  136. if ($id == $iDefaultSubSvcId)
  137. {
  138. $sChecked = "checked";
  139. }
  140. $oP->add("<tr>");
  141. $oP->add("<td style=\"vertical-align:top\">");
  142. $oP->add("<p><input name=\"attr_servicesubcategory_id\" $sChecked type=\"radio\" id=\"servicesubcategory_$id\" value=\"$id\"></p>");
  143. $oP->add("</td>");
  144. $oP->add("<td style=\"vertical-align:top\">");
  145. $oP->add("<p><b><label for=\"servicesubcategory_$id\">".$oSubService->GetName()."</label></b></p>");
  146. $oP->add("<p>".$oSubService->GetAsHTML('description')."</p>");
  147. $oP->add("</td>");
  148. $oP->add("</tr>");
  149. }
  150. $oP->add("</table>\n");
  151. $oP->DumpHiddenParams($aParameters, array('servicesubcategory_id'));
  152. $oP->add("<input type=\"hidden\" name=\"operation\" value=\"create_request\">");
  153. $oP->WizardFormButtons(BUTTON_BACK | BUTTON_NEXT | BUTTON_CANCEL);
  154. $oP->WizardFormEnd();
  155. $oP->WizardCheckSelectionOnSubmit(Dict::S('Portal:PleaseSelectAServiceSubCategory'));
  156. $oP->add("</div>\n");
  157. }
  158. else
  159. {
  160. $oP->p("Error: Invalid Service: id = $iSvcId");
  161. }
  162. }
  163. /**
  164. * Displays the form for the final step of the UserRequest creation
  165. * @param WebPage $oP The current web page for the form output
  166. * @param Organization $oUserOrg The organization of the current user
  167. * @return void
  168. */
  169. function RequestCreationForm($oP, $oUserOrg)
  170. {
  171. $oP->add_script(
  172. <<<EOF
  173. // Create the object once at the beginning of the page...
  174. var oWizardHelper = new WizardHelper('UserRequest', '');
  175. EOF
  176. );
  177. $aParameters = $oP->ReadAllParams(ALL_PARAMS);
  178. $aList = array('title', 'description', 'impact', 'urgency', 'workgroup_id');
  179. $sDescription = '';
  180. if (isset($aParameters['template_id']))
  181. {
  182. $oTemplate = MetaModel::GetObject('Template', $aParameters['template_id'], false);
  183. if (is_object($oTemplate))
  184. {
  185. $sDescription = htmlentities($oTemplate->Get('template'), ENT_QUOTES, 'UTF-8');
  186. }
  187. }
  188. $oServiceCategory = MetaModel::GetObject('Service', $aParameters['service_id'], false);
  189. $oServiceSubCategory = MetaModel::GetObject('ServiceSubcategory', $aParameters['servicesubcategory_id'], false);
  190. if (is_object($oServiceCategory) && is_object($oServiceSubCategory))
  191. {
  192. $oRequest = new UserRequest();
  193. $oRequest->Set('org_id', $oUserOrg->GetKey());
  194. $oRequest->Set('caller_id', UserRights::GetContactId());
  195. $oRequest->Set('service_id', $aParameters['service_id']);
  196. $oRequest->Set('servicesubcategory_id', $aParameters['servicesubcategory_id']);
  197. $oAttDef = MetaModel::GetAttributeDef('UserRequest', 'service_id');
  198. $aDetails[] = array('label' => $oAttDef->GetLabel(), 'value' => $oServiceCategory->GetName());
  199. $oAttDef = MetaModel::GetAttributeDef('UserRequest', 'servicesubcategory_id');
  200. $aDetails[] = array('label' => $oAttDef->GetLabel(), 'value' => $oServiceSubCategory->GetName());
  201. $iFlags = 0;
  202. foreach($aList as $sAttCode)
  203. {
  204. $value = '';
  205. if (isset($aParameters[$sAttCode]))
  206. {
  207. $value = $aParameters[$sAttCode];
  208. $oRequest->Set($sAttCode, $value);
  209. }
  210. }
  211. $aFieldsMap = array();
  212. foreach($aList as $sAttCode)
  213. {
  214. $value = '';
  215. $oAttDef = MetaModel::GetAttributeDef(get_class($oRequest), $sAttCode);
  216. $iFlags = $oRequest->GetAttributeFlags($sAttCode);
  217. if (isset($aParameters[$sAttCode]))
  218. {
  219. $value = $aParameters[$sAttCode];
  220. }
  221. $aArgs = array('this' => $oRequest);
  222. $sInputId = 'attr_'.$sAttCode;
  223. $aFieldsMap[$sAttCode] = $sInputId;
  224. $sValue = "<span id=\"field_{$sInputId}\">".$oRequest->GetFormElementForField($oP, get_class($oRequest), $sAttCode, $oAttDef, $value, '', 'attr_'.$sAttCode, '', $iFlags, $aArgs).'</span>';
  225. $aDetails[] = array('label' => $oAttDef->GetLabel(), 'value' => $sValue);
  226. }
  227. $aDetails[] = array('label' => Dict::S('Class:Ticket/Attribute:ticket_log'), 'value' => '<textarea id="attr_moreinfo" class="resizable ui-resizable" cols="40" rows="8" name="attr_moreinfo" title="" style="margin: 0px; resize: none; position: static; display: block; height: 145px; width: 339px;">'.$sDescription.'</textarea>');
  228. $oP->add_linked_script("../js/json.js");
  229. $oP->add_linked_script("../js/forms-json-utils.js");
  230. $oP->add_linked_script("../js/wizardhelper.js");
  231. $oP->add_linked_script("../js/wizard.utils.js");
  232. $oP->add_linked_script("../js/linkswidget.js");
  233. $oP->add_linked_script("../js/extkeywidget.js");
  234. $oP->add_linked_script("../js/jquery.blockUI.js");
  235. $oP->add("<div class=\"wizContainer\" id=\"form_request_description\">\n");
  236. $oP->add("<h1 id=\"title_request_form\">".Dict::S('Portal:DescriptionOfTheRequest')."</h1>\n");
  237. $oP->WizardFormStart('request_form', 3);
  238. //$oP->add("<table>\n");
  239. $oP->details($aDetails);
  240. $oAttPlugin = new AttachmentPlugIn();
  241. $oAttPlugin->OnDisplayRelations($oRequest, $oP, true /* edit */);
  242. $oP->DumpHiddenParams($aParameters, $aList);
  243. $oP->add("<input type=\"hidden\" name=\"operation\" value=\"create_request\">");
  244. $oP->WizardFormButtons(BUTTON_BACK | BUTTON_FINISH | BUTTON_CANCEL);
  245. $oP->WizardFormEnd();
  246. $oP->add("</div>\n");
  247. $iFieldsCount = count($aFieldsMap);
  248. $sJsonFieldsMap = json_encode($aFieldsMap);
  249. $oP->add_ready_script(
  250. <<<EOF
  251. oWizardHelper.SetFieldsMap($sJsonFieldsMap);
  252. oWizardHelper.SetFieldsCount($iFieldsCount);
  253. // Starts the validation when the page is ready
  254. CheckFields('request_form', false);
  255. $('#request_form').submit( function() {
  256. return OnSubmit('request_form');
  257. });
  258. EOF
  259. );
  260. }
  261. else
  262. {
  263. // User not authorized to use this service ?
  264. //ShowOngoingTickets($oP);
  265. }
  266. }
  267. /**
  268. * Validate the parameters and create the UserRequest object (based on the page's POSTed parameters)
  269. * @param WebPage $oP The current web page for the output
  270. * @param Organization $oUserOrg The organization of the current user
  271. * @return void
  272. */
  273. function DoCreateRequest($oP, $oUserOrg)
  274. {
  275. $aParameters = $oP->ReadAllParams(ALL_PARAMS);
  276. $sTransactionId = utils::ReadPostedParam('transaction_id', '');
  277. if (!utils::IsTransactionValid($sTransactionId))
  278. {
  279. $oP->add("<h1>".Dict::S('UI:Error:ObjectAlreadyCreated')."</h1>\n");
  280. //ShowOngoingTickets($oP);
  281. return;
  282. }
  283. // Validate the parameters
  284. // 1) ServiceCategory
  285. $oSearch = DBObjectSearch::FromOQL(VALIDATE_SERVICECATEGORY_QUERY);
  286. $oSet = new CMDBObjectSet($oSearch, array(), array('id' => $aParameters['service_id'], 'org_id' => $oUserOrg->GetKey()));
  287. if ($oSet->Count() != 1)
  288. {
  289. // Invalid service for the current user !
  290. throw new Exception("Invalid Service Category: id={$aParameters['service_id']} - count: ".$oSet->Count());
  291. }
  292. $oServiceCategory = $oSet->Fetch();
  293. // 2) Service Subcategory
  294. $oSearch = DBObjectSearch::FromOQL(VALIDATE_SERVICESUBCATEGORY_QUERY);
  295. $oSet = new CMDBObjectSet($oSearch, array(), array('service_id' => $aParameters['service_id'], 'id' =>$aParameters['servicesubcategory_id'],'org_id' => $oUserOrg->GetKey() ));
  296. if ($oSet->Count() != 1)
  297. {
  298. // Invalid subcategory
  299. throw new Exception("Invalid ServiceSubcategory: id={$aParameters['servicesubcategory_id']} for service category ".$oServiceCategory->GetName()."({$aParameters['service_id']}) - count: ".$oSet->Count());
  300. }
  301. $oServiceSubCategory = $oSet->Fetch();
  302. $oRequest = new UserRequest();
  303. $oRequest->Set('org_id', $oUserOrg->GetKey());
  304. $oRequest->Set('caller_id', UserRights::GetContactId());
  305. $aList = array('service_id', 'servicesubcategory_id', 'title', 'description', 'impact');
  306. $oRequest->UpdateObjectFromPostedForm();
  307. if (isset($aParameters['moreinfo']))
  308. {
  309. // There is a template, insert it into the description
  310. $oRequest->Set('ticket_log', $aParameters['moreinfo']);
  311. }
  312. /////$oP->DoUpdateObjectFromPostedForm($oObj);
  313. $oAttPlugin = new AttachmentPlugIn();
  314. $oAttPlugin->OnFormSubmit($oRequest);
  315. list($bRes, $aIssues) = $oRequest->CheckToWrite();
  316. if ($bRes)
  317. {
  318. $oRequest->DBInsert();
  319. $oP->add("<h1>".Dict::Format('UI:Title:Object_Of_Class_Created', $oRequest->GetName(), MetaModel::GetName(get_class($oRequest)))."</h1>\n");
  320. //DisplayObject($oP, $oRequest, $oUserOrg);
  321. ShowOngoingTickets($oP);
  322. }
  323. else
  324. {
  325. RequestCreationForm($oP, $oUserOrg);
  326. $sIssueDesc = Dict::Format('UI:ObjectCouldNotBeWritten', implode(', ', $aIssues));
  327. $oP->add_ready_script("alert('".addslashes($sIssueDesc)."');");
  328. }
  329. }
  330. /**
  331. * Prompts the user for creating a new request
  332. * @param WebPage $oP The current web page
  333. * @return void
  334. */
  335. function CreateRequest(WebPage $oP, Organization $oUserOrg)
  336. {
  337. switch($oP->GetWizardStep())
  338. {
  339. case 0:
  340. default:
  341. SelectServiceCategory($oP, $oUserOrg);
  342. break;
  343. case 1:
  344. SelectServiceSubCategory($oP, $oUserOrg);
  345. break;
  346. case 2:
  347. RequestCreationForm($oP, $oUserOrg);
  348. break;
  349. case 3:
  350. DoCreateRequest($oP, $oUserOrg);
  351. break;
  352. }
  353. }
  354. /**
  355. * Lists all the currently opened User Requests for the current user
  356. * @param WebPage $oP The current web page
  357. * @return void
  358. */
  359. function ListOpenRequests(WebPage $oP)
  360. {
  361. $oUserOrg = GetUserOrg();
  362. $sOQL = 'SELECT UserRequest WHERE org_id = :org_id AND status NOT IN ("closed")';
  363. $oSearch = DBObjectSearch::FromOQL($sOQL);
  364. $iUser = UserRights::GetContactId();
  365. if ($iUser > 0)
  366. {
  367. $oSearch->AddCondition('caller_id', $iUser);
  368. }
  369. $oSet = new CMDBObjectSet($oSearch, array(), array('org_id' => $oUserOrg->GetKey()));
  370. $aZList = array('finalclass', 'title', 'start_date', 'status', 'servicesubcategory_id', 'priority', 'caller_id');
  371. $oP->DisplaySet($oSet, $aZList, Dict::S('Portal:NoOpenRequest'));
  372. }
  373. /**
  374. * Lists all the currently resolved (not yet closed) User Requests for the current user
  375. * @param WebPage $oP The current web page
  376. * @return void
  377. */
  378. function ListResolvedRequests(WebPage $oP)
  379. {
  380. $oUserOrg = GetUserOrg();
  381. $sOQL = 'SELECT UserRequest WHERE org_id = :org_id AND status = "resolved"';
  382. $oSearch = DBObjectSearch::FromOQL($sOQL);
  383. $iUser = UserRights::GetContactId();
  384. if ($iUser > 0)
  385. {
  386. $oSearch->AddCondition('caller_id', $iUser);
  387. }
  388. $oSet = new CMDBObjectSet($oSearch, array(), array('org_id' => $oUserOrg->GetKey()));
  389. $aZList = array('finalclass', 'title', 'start_date', 'status', 'servicesubcategory_id', 'priority', 'caller_id');
  390. $oP->DisplaySet($oSet, $aZList, Dict::S('Portal:NoOpenRequest'));
  391. }
  392. /**
  393. * Lists all the currently closed tickets
  394. * @param WebPage $oP The current web page
  395. * @return void
  396. */
  397. function ListClosedTickets(WebPage $oP)
  398. {
  399. $aAttSpecs = array('ref', 'start_date', 'close_date', 'service_id', 'caller_id');
  400. $aZList = array('title', 'start_date', 'close_date', 'servicesubcategory_id');
  401. $oP->DisplaySearchForm('UserRequest', $aAttSpecs, array('operation' => 'show_closed'), 'search_', false /* => not closed */);
  402. $oUserOrg = GetUserOrg();
  403. // UserRequest
  404. $oSearch = $oP->PostedParamsToFilter('UserRequest', $aAttSpecs, 'search_');
  405. if(is_null($oSearch))
  406. {
  407. $oSearch = new DBObjectSearch('UserRequest');
  408. }
  409. $oSearch->AddCondition('org_id', $oUserOrg->GetKey());
  410. $oSearch->AddCondition('status', 'closed');
  411. $iUser = UserRights::GetContactId();
  412. if ($iUser > 0)
  413. {
  414. $oSearch->AddCondition('caller_id', $iUser);
  415. }
  416. $oSet1 = new CMDBObjectSet($oSearch);
  417. $oP->add("<p>\n");
  418. $oP->add("<h1>".Dict::S('Portal:ClosedRequests')."</h1>\n");
  419. $oP->DisplaySet($oSet1, $aZList, Dict::S('Portal:NoClosedRequest'));
  420. $oP->add("</p>\n");
  421. }
  422. /**
  423. * Display an object - to be customized
  424. * @param WebPage $oP The current web page
  425. * @param Object $oObj Any kind of object
  426. * @param Object $oUserOrg The organization of the logged in user
  427. * @return void
  428. */
  429. function DisplayObject($oP, $oObj, $oUserOrg)
  430. {
  431. switch(get_class($oObj))
  432. {
  433. case 'UserRequest':
  434. ShowDetailsRequest($oP, $oObj);
  435. break;
  436. default:
  437. throw new Exception("The class ".get_class($oObj)." is not handled through the portal");
  438. }
  439. }
  440. /**
  441. * Displays the details of a request
  442. * @param WebPage $oP The current web page
  443. * @param Object $oObj The target object
  444. * @return void
  445. */
  446. function ShowDetailsRequest(WebPage $oP, $oObj)
  447. {
  448. $sClass = get_class($oObj);
  449. $bIsEscalateButton = false;
  450. $bIsCloseButton = false;
  451. $bEditAttachments = false;
  452. switch($oObj->GetState())
  453. {
  454. case 'new':
  455. case 'assigned':
  456. case 'frozen':
  457. $aEditAtt = array(
  458. 'ticket_log' => '????'
  459. );
  460. $bEditAttachments = true;
  461. // disabled - $bIsEscalateButton = true;
  462. break;
  463. case 'escalated_tto':
  464. case 'escalated_ttr':
  465. $aEditAtt = array(
  466. 'ticket_log' => '????'
  467. );
  468. $bEditAttachments = true;
  469. break;
  470. case 'resolved':
  471. $aEditAtt = array(
  472. // non, read-only dans cet etat - 'ticket_log' => '????',
  473. 'user_satisfaction' => '????',
  474. 'user_commment' => '????',
  475. );
  476. $bIsCloseButton = true;
  477. break;
  478. case 'closed':
  479. case 'closure_requested':
  480. default:
  481. $aEditAtt = array();
  482. break;
  483. }
  484. // REFACTORISER LA MISE EN FORME
  485. $oP->add("<h1 id=\"title_request_details\">".$oObj->GetIcon()."&nbsp;".Dict::Format('Portal:TitleRequestDetailsFor_Request', $oObj->GetName())."</h1>\n");
  486. switch($sClass)
  487. {
  488. case 'UserIssue':
  489. //$aAttList = array('ref', 'status', 'title', 'description', 'start_date', 'caller_id', 'servicesubcategory_id', 'impact', 'priority', 'agent_id', 'close_date', 'last_update', 'assignment_date', 'resolution_code', 'solution', 'origin', 'time_spent', 'respected_gtr', 'gtr_overdue', 'user_satisfaction', 'user_commment', 'freeze_reason', 'ticket_log');
  490. $aAttList = array('col:0'=> array('ref','caller_id','impact','perimeter','servicesubcategory_id','title'),'col:1'=> array('status','priority','start_date','resolution_date','last_update','agent_id'));
  491. break;
  492. case 'UserRequest':
  493. //$aAttList = array('ref', 'status', 'title', 'description', 'requesttype', 'start_date', 'caller_id', 'servicesubcategory_id', 'priority', 'agent_id', 'close_date', 'last_update', 'assignment_date', 'user_satisfaction', 'user_commment', 'freeze_reason', 'ticket_log');
  494. $aAttList = array('col:0'=> array('ref','caller_id','servicesubcategory_id','title'),'col:1'=> array('status','priority','start_date','resolution_date','last_update','agent_id'));
  495. break;
  496. default:
  497. //$aAttList = array('ref');
  498. array('col:0'=> array('ref','service_id','servicesubcategory_id','title'),'col:1'=> array('status','start_date'));
  499. break;
  500. }
  501. // Remove the edited attribute from the shown attributes
  502. //
  503. foreach($aEditAtt as $sAttCode => $foo)
  504. {
  505. foreach($aAttList as $col => $aColumn)
  506. {
  507. if (in_array($sAttCode, $aColumn))
  508. {
  509. if(($index = array_search($sAttCode, $aColumn)) !== false)
  510. {
  511. unset($aAttList[$col][$index]);
  512. }
  513. }
  514. }
  515. }
  516. $oP->add("<div class=\"wizContainer\" id=\"form_commment_request\">\n");
  517. $oP->WizardFormStart('request_form', null);
  518. $oP->add('<div id="request_details">');
  519. $oP->add('<table id="request_details_table">');
  520. $oP->add('<tr>');
  521. $oP->add('<td style="vertical-align:top;">');
  522. $oP->DisplayObjectDetails($oObj, $aAttList['col:0']);
  523. $oP->add('</td>');
  524. $oP->add('<td style="vertical-align:top;">');
  525. $oP->DisplayObjectDetails($oObj, $aAttList['col:1']);
  526. $oP->add('</td>');
  527. $oP->add('</tr>');
  528. // REFACTORISER
  529. $oP->add('<tr>');
  530. $oP->add('<td colspan="2" style="vertical-align:top;">');
  531. $oAttPlugin = new AttachmentPlugIn();
  532. if ($bEditAttachments)
  533. {
  534. $oAttPlugin->EnableDelete(false);
  535. $oAttPlugin->OnDisplayRelations($oObj, $oP, true /* edit */);
  536. }
  537. else
  538. {
  539. $oAttPlugin->OnDisplayRelations($oObj, $oP, false /* read */);
  540. }
  541. $oP->add('</td>');
  542. $oP->add('</tr>');
  543. if (count($aEditAtt) > 0)
  544. {
  545. $oP->add('<tr>');
  546. $oP->add('<td colspan="2" style="vertical-align:top;">');
  547. //$oP->add("<form action=\"../portal/index.php\" id=\"request_form\" method=\"post\">\n");
  548. //$oP->add('<table id=""><tr><td style="vertical-align:top;">');
  549. //$oP->add("<h1 id=\"title_request_details\">".Dict::Format('Portal:CommentsFor_Request', $oObj->GetName())."</h1>\n");
  550. $oP->add("<input type=\"hidden\" name=\"class\" value=\"$sClass\">");
  551. $oP->add("<input type=\"hidden\" name=\"id\" value=\"".$oObj->GetKey()."\">");
  552. $oP->add("<input type=\"hidden\" name=\"operation\" value=\"update_request\">");
  553. $oP->add("<input type=\"hidden\" id=\"stimulus_to_apply\" name=\"apply_stimulus\" value=\"\">\n");
  554. $oP->add_script(
  555. <<<EOF
  556. function SetStimulusToApply(sStimulusCode)
  557. {
  558. $('#stimulus_to_apply').val(sStimulusCode);
  559. }
  560. EOF
  561. );
  562. $aEditFields = array(); // Intermediate array to avoid code duplication while splitting btw ticket_log and the rest
  563. foreach($aEditAtt as $sAttCode => $foo)
  564. {
  565. $sValue = $oObj->Get($sAttCode);
  566. $sDisplayValue = $oObj->GetEditValue($sAttCode);
  567. $aArgs = array('this' => $oObj, 'formPrefix' => '');
  568. $oAttDef = MetaModel::GetAttributeDef($sClass, $sAttCode);
  569. $sInputId = 'input_'.$sAttCode;
  570. $sHTMLValue = "<span id=\"field_{$sInputId}\">".cmdbAbstractObject::GetFormElementForField($oP, $sClass, $sAttCode, $oAttDef, $sValue, $sDisplayValue, $sInputId, '', 0 /*$iFlags*/, $aArgs).'</span>';
  571. $aEditFields[$sAttCode] = array(
  572. 'label' => MetaModel::GetLabel($sClass, $sAttCode),
  573. 'value' => $sHTMLValue
  574. );
  575. }
  576. foreach($aEditFields as $sAttCode => $aFieldSpec)
  577. {
  578. if ($sAttCode == 'ticket_log')
  579. {
  580. // Skip, the public log will be displayed below the buttons
  581. continue;
  582. }
  583. $oP->add("<div class=\"edit_item\">");
  584. $oP->add('<h1>'.$aFieldSpec['label'].'</h1>');
  585. $oP->add($aFieldSpec['value']);
  586. $oP->add('</div>');
  587. }
  588. // $oP->p('<textarea id="user_request_commment" name="commment"></textarea>');
  589. if($bIsCloseButton)
  590. {
  591. $sStimulusCode = 'ev_close';
  592. $oP->p('<input type="submit" onClick="SetStimulusToApply(\''.$sStimulusCode.'\');" value="'.Dict::S('Portal:Button:CloseTicket').'">');
  593. }
  594. else
  595. {
  596. $oP->p('<input type="submit" value="'.Dict::S('Portal:Button:UpdateRequest').'">');
  597. }
  598. if ($bIsEscalateButton)
  599. {
  600. $sStimulusCode = 'ev_timeout';
  601. $oP->p('<input type="submit" onClick="SetStimulusToApply(\''.$sStimulusCode.'\');" value="'.Dict::S('Portal:ButtonEscalate').'">');
  602. }
  603. $oP->add('</td>');
  604. $oP->add('</tr>');
  605. }
  606. $oP->add('<tr>');
  607. $oP->add('<td colspan="2" style="vertical-align:top;">');
  608. if (isset($aEditFields['ticket_log']))
  609. {
  610. $oP->add("<div class=\"edit_item\">");
  611. $oP->add('<h1>'.$aEditFields['ticket_log']['label'].'</h1>');
  612. $oP->add($aEditFields['ticket_log']['value']);
  613. $oP->add('</div>');
  614. }
  615. else
  616. {
  617. $oP->add('<h1>'.MetaModel::GetLabel($sClass, 'ticket_log').'</h1>');
  618. $oP->add($oObj->GetAsHTML('ticket_log'));
  619. }
  620. $oP->add('</td>');
  621. $oP->add('</tr>');
  622. $oP->add('</table>');
  623. $oP->add('</div>');
  624. $oP->WizardFormEnd();
  625. $oP->add('</div>');
  626. }
  627. /**
  628. * Get The organization of the current user (i.e. the organization of its contact)
  629. * @param WebPage $oP The current page, for errors output
  630. * @return Organization The user's org or null in case of problem...
  631. */
  632. function GetUserOrg()
  633. {
  634. $oOrg = null;
  635. $iContactId = UserRights::GetContactId();
  636. $oContact = MetaModel::GetObject('Contact', $iContactId, false); // false => Can fail
  637. if (is_object($oContact))
  638. {
  639. $oOrg = MetaModel::GetObject('Organization', $oContact->Get('org_id'), false); // false => can fail
  640. }
  641. else
  642. {
  643. throw new Exception(Dict::S('Portal:ErrorNoContactForThisUser'));
  644. }
  645. return $oOrg;
  646. }
  647. ///////////////////////////////////////////////////////////////////////////////
  648. //
  649. // Main program
  650. //
  651. ///////////////////////////////////////////////////////////////////////////////
  652. try
  653. {
  654. require_once(APPROOT.'/application/startup.inc.php');
  655. require_once(APPROOT.'/application/portalwebpage.class.inc.php');
  656. $oAppContext = new ApplicationContext();
  657. $sOperation = utils::ReadParam('operation', '');
  658. require_once(APPROOT.'/application/loginwebpage.class.inc.php');
  659. LoginWebPage::DoLogin(false /* bMustBeAdmin */, true /* IsAllowedToPortalUsers */); // Check user rights and prompt if needed
  660. ApplicationContext::SetUrlMakerClass('MyPortalURLMaker');
  661. $oUserOrg = GetUserOrg();
  662. $sCode = $oUserOrg->Get('code');
  663. $sAlternateStylesheet = '';
  664. if (@file_exists("./$sCode/portal.css"))
  665. {
  666. $sAlternateStylesheet = "$sCode";
  667. }
  668. $oP = new PortalWebPage(Dict::S('Portal:Title'), $sAlternateStylesheet);
  669. $oP->EnableDisconnectButton(utils::CanLogOff());
  670. $oP->SetWelcomeMessage(Dict::Format('Portal:WelcomeUserOrg', UserRights::GetUserFriendlyName(), $oUserOrg->GetName()));
  671. if (is_object($oUserOrg))
  672. {
  673. switch($sOperation)
  674. {
  675. case 'show_closed':
  676. DisplayMainMenu($oP);
  677. ShowClosedTickets($oP);
  678. break;
  679. case 'create_request':
  680. DisplayMainMenu($oP);
  681. CreateRequest($oP, $oUserOrg);
  682. break;
  683. case 'details':
  684. DisplayMainMenu($oP);
  685. $oObj = $oP->FindObjectFromArgs(array('UserRequest'));
  686. DisplayObject($oP, $oObj, $oUserOrg);
  687. break;
  688. case 'update_request':
  689. DisplayMainMenu($oP);
  690. $oObj = $oP->FindObjectFromArgs(array('UserRequest'));
  691. switch(get_class($oObj))
  692. {
  693. case 'UserRequest':
  694. $aAttList = array('ticket_log', 'user_satisfaction', 'user_commment');
  695. break;
  696. default:
  697. throw new Exception("Implementation issue: unexpected class '".get_class($oObj)."'");
  698. }
  699. try
  700. {
  701. $oP->DoUpdateObjectFromPostedForm($oObj, $aAttList);
  702. }
  703. catch(TransactionException $e)
  704. {
  705. $oP->add("<h1>".Dict::S('UI:Error:ObjectAlreadyUpdated')."</h1>\n");
  706. }
  707. DisplayObject($oP, $oObj, $oUserOrg);
  708. break;
  709. case 'show_ongoing':
  710. default:
  711. DisplayMainMenu($oP);
  712. ShowOngoingTickets($oP);
  713. }
  714. }
  715. $oP->output();
  716. }
  717. catch(CoreException $e)
  718. {
  719. require_once(APPROOT.'/setup/setuppage.class.inc.php');
  720. $oP = new SetupPage(Dict::S('UI:PageTitle:FatalError'));
  721. $oP->add("<h1>".Dict::S('UI:FatalErrorMessage')."</h1>\n");
  722. $oP->error(Dict::Format('UI:Error_Details', $e->getHtmlDesc()));
  723. $oP->output();
  724. if (MetaModel::IsLogEnabledIssue())
  725. {
  726. if (MetaModel::IsValidClass('EventIssue'))
  727. {
  728. try
  729. {
  730. $oLog = new EventIssue();
  731. $oLog->Set('message', $e->getMessage());
  732. $oLog->Set('userinfo', '');
  733. $oLog->Set('issue', $e->GetIssue());
  734. $oLog->Set('impact', 'Page could not be displayed');
  735. $oLog->Set('callstack', $e->getTrace());
  736. $oLog->Set('data', $e->getContextData());
  737. $oLog->DBInsertNoReload();
  738. }
  739. catch(Exception $e)
  740. {
  741. IssueLog::Error("Failed to log issue into the DB");
  742. }
  743. }
  744. IssueLog::Error($e->getMessage());
  745. }
  746. // For debugging only
  747. //throw $e;
  748. }
  749. catch(Exception $e)
  750. {
  751. require_once(APPROOT.'/setup/setuppage.class.inc.php');
  752. $oP = new SetupPage(Dict::S('UI:PageTitle:FatalError'));
  753. $oP->add("<h1>".Dict::S('UI:FatalErrorMessage')."</h1>\n");
  754. $oP->error(Dict::Format('UI:Error_Details', $e->getMessage()));
  755. $oP->output();
  756. if (MetaModel::IsLogEnabledIssue())
  757. {
  758. if (MetaModel::IsValidClass('EventIssue'))
  759. {
  760. try
  761. {
  762. $oLog = new EventIssue();
  763. $oLog->Set('message', $e->getMessage());
  764. $oLog->Set('userinfo', '');
  765. $oLog->Set('issue', 'PHP Exception');
  766. $oLog->Set('impact', 'Page could not be displayed');
  767. $oLog->Set('callstack', $e->getTrace());
  768. $oLog->Set('data', array());
  769. $oLog->DBInsertNoReload();
  770. }
  771. catch(Exception $e)
  772. {
  773. IssueLog::Error("Failed to log issue into the DB");
  774. }
  775. }
  776. IssueLog::Error($e->getMessage());
  777. }
  778. }
  779. ?>