function log_status_changes() { global $ist, $ict, $ics, $ios, $iap, $ipr, $isv, $ist, $isa, $field_event_map, $AppUI; if (dPgetParam($_POST, "item_id")) { $hditem = new CHelpDeskItem(); $hditem->load(dPgetParam($_POST, "item_id")); foreach ($field_event_map as $key => $value) { if (!eval("return \$hditem->{$value} == \$this->{$value};")) { $old = $new = ""; switch ($value) { // Create the comments here case 'item_assigned_to': $sql = "\n SELECT \n user_id, concat(contact_first_name,' ',contact_last_name) as user_name\n FROM \n users\n LEFT JOIN contacts ON user_contact = contact_id\n WHERE \n user_id in (" . ($hditem->{$value} ? $hditem->{$value} : "") . ($this->{$value} && $hditem->{$value} ? ", " : "") . ($this->{$value} ? $this->{$value} : "") . ")\n "; $ids = db_loadList($sql); foreach ($ids as $row) { if ($row["user_id"] == $this->{$value}) { $new = $row["user_name"]; } else { if ($row["user_id"] == $hditem->{$value}) { $old = $row["user_name"]; } } } break; case 'item_company_id': $sql = "\n SELECT \n company_id, company_name\n FROM \n companies\n WHERE \n company_id in (" . ($hditem->{$value} ? $hditem->{$value} : "") . ($this->{$value} && $hditem->{$value} ? ", " : "") . ($this->{$value} ? $this->{$value} : "") . ")\n "; $ids = db_loadList($sql); foreach ($ids as $row) { if ($row["company_id"] == $this->{$value}) { $new = $row["company_name"]; } else { if ($row["company_id"] == $hditem->{$value}) { $old = $row["company_name"]; } } } break; case 'item_project_id': $sql = "\n SELECT \n project_id, project_name\n FROM \n projects\n WHERE \n project_id in (" . ($hditem->{$value} ? $hditem->{$value} : "") . ($this->{$value} && $hditem->{$value} ? ", " : "") . ($this->{$value} ? $this->{$value} : "") . ")\n "; $ids = db_loadList($sql); foreach ($ids as $row) { if ($row["project_id"] == $this->{$value}) { $new = $row["project_name"]; } else { if ($row["project_id"] == $hditem->{$value}) { $old = $row["project_name"]; } } } break; case 'item_calltype': $old = $AppUI->_($ict[$hditem->{$value}]); $new = $AppUI->_($ict[$this->{$value}]); break; case 'item_source': $old = $AppUI->_($ics[$hditem->{$value}]); $new = $AppUI->_($ics[$this->{$value}]); break; case 'item_status': $old = $AppUI->_($ist[$hditem->{$value}]); $new = $AppUI->_($ist[$this->{$value}]); break; case 'item_priority': $old = $AppUI->_($ipr[$hditem->{$value}]); $new = $AppUI->_($ipr[$this->{$value}]); break; case 'item_severity': $old = $AppUI->_($isv[$hditem->{$value}]); $new = $AppUI->_($isv[$this->{$value}]); break; case 'item_os': $old = $AppUI->_($ios[$hditem->{$value}]); $new = $AppUI->_($ios[$this->{$value}]); break; case 'item_application': $old = $AppUI->_($iap[$hditem->{$value}]); $new = $AppUI->_($iap[$this->{$value}]); break; case 'item_notify': $old = $hditem->{$value} ? $AppUI->_('On') : $AppUI->_('Off'); $new = $this->{$value} ? $AppUI->_('On') : $AppUI->_('Off'); break; default: $old = $hditem->{$value}; $new = $this->{$value}; break; } $last_status_log_id = $this->log_status($key, $AppUI->_('changed from') . " \"" . addslashes($old) . "\" " . $AppUI->_('to') . " \"" . addslashes($new) . "\""); } } return $last_status_log_id; } }
function file_show_attr() { global $AppUI, $obj, $ci, $canAdmin, $projects, $file_project, $file_task, $task_name, $preserve, $file_helpdesk_item; if ($ci) { $str_out = '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Minor Revision') . '</td><td><input type="Radio" name="revision_type" value="minor" checked />' . '</td><tr><td align="right" nowrap="nowrap">' . $AppUI->_('Major Revision') . '</td><td><input type="Radio" name="revision_type" value="major" /></td>'; } else { $str_out = '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Version') . ':</td>'; } $str_out .= '<td align="left">'; if ($ci || $canAdmin && $obj->file_checkout == 'final') { $str_out .= '<input type="hidden" name="file_checkout" value="" /><input type="hidden" name="file_co_reason" value="" />'; } if ($ci) { $the_value = strlen($obj->file_version) > 0 ? $obj->file_version + 0.01 : '1'; $str_out .= '<input type="hidden" name="file_version" value="' . $the_value . '" />'; } else { $the_value = strlen($obj->file_version) > 0 ? $obj->file_version : '1'; $str_out .= '<input type="text" name="file_version" maxlength="10" size="5" value="' . $the_value . '" />'; } $str_out .= '</td>'; $select_disabled = ' '; $onclick_task = ' onclick="popTask()" '; if ($ci && $preserve) { $select_disabled = ' disabled="disabled" '; $onclick_task = ' '; // need because when a html is disabled, it's value it's not sent in submit $str_out .= '<input type="hidden" name="file_project" value="' . $file_project . '" />'; $str_out .= '<input type="hidden" name="file_category" value="' . $obj->file_category . '" />'; } // Category $str_out .= '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Category') . ':</td>'; $str_out .= '<td align="left">' . arraySelect(w2PgetSysVal('FileType'), 'file_category', '' . $select_disabled, $obj->file_category, true) . '<td>'; // --------------------------------------------------------------------------------- if ($file_helpdesk_item) { $hd_item = new CHelpDeskItem(); $hd_item->load($file_helpdesk_item); //Helpdesk Item $str_out .= '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Helpdesk Item') . ':</td>'; $str_out .= '<td align="left"><strong>' . $hd_item->item_id . ' - ' . $hd_item->item_title . '</strong></td></tr>'; // Project $str_out .= '<input type="hidden" name="file_project" value="' . $file_project . '" />'; // Task $str_out .= '<input type="hidden" name="file_task" value="0" />'; } else { // Project $str_out .= '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Project') . ':</td>'; $str_out .= '<td align="left">' . projectSelectWithOptGroup($AppUI->user_id, 'file_project', 'size="1" class="text" style="width:270px"' . $select_disabled, $file_project) . '</td></tr>'; // --------------------------------------------------------------------------------- // Task $str_out .= '<tr><td align="right" nowrap="nowrap">' . $AppUI->_('Task') . ':</td><td align="left" colspan="2" valign="top"><input type="hidden" name="file_task" value="' . $file_task . '" /><input type="text" class="text" name="task_name" value="' . $task_name . '" size="40" disabled /><input type="button" class="button" value="' . $AppUI->_('select task') . '..."' . $onclick_task . '/></td></tr>'; } return $str_out; }
if ($obj->task_log_date) { $date = new CDate($obj->task_log_date); $obj->task_log_date = $date->format(FMT_DATETIME_MYSQL); } $AppUI->setMsg('Task Log'); $obj->task_log_costcode = $obj->task_log_costcode; if ($msg = $obj->store()) { $AppUI->setMsg($msg, UI_MSG_ERROR); $AppUI->redirect(); } else { $hditem->notify(TASK_LOG, $obj->task_log_id); $AppUI->setMsg(@$_POST['task_log_id'] ? 'updated' : 'added', UI_MSG_OK, true); } $AppUI->redirect("m=helpdesk&a=view&item_id={$item_id}&tab=0"); } else { $hditem = new CHelpDeskItem(); if (!$hditem->bind($_POST)) { $AppUI->setMsg($hditem->error, UI_MSG_ERROR); $AppUI->redirect(); } $AppUI->setMsg('Help Desk Item', UI_MSG_OK); if ($del) { // if (($msg = $hditem->delete())) { // $AppUI->setMsg( $msg, UI_MSG_ERROR ); // } else { // $AppUI->setMsg( 'deleted', UI_MSG_OK, true ); // $hditem->log_status(17); // $AppUI->redirect('m=helpdesk&a=list'); // } //if ($del) { // if (($msg = $hditem->delete())) {