public function getLatestActivityDate()
{
$latestTicketEvent = TicketEvents::model()->findBySql("select max(event_recorded_date) as event_recorded_date, description as id from (select event_type_id, event_recorded_date from ticket_events where ticket_id = " . $this->id . " and (event_type_id != 9 and event_type_id !=8) order by event_recorded_date desc)x left join event_type on event_type.id = event_type_id; ");
return "" . $latestTicketEvent->id . " " . date("M d, Y", strtotime($latestTicketEvent->event_recorded_date));
}
public static function recordEvent($event_type_id, $ticket_id, $old_value, $new_value, $comment)
{
$resEvent = NULL;
$newEvent = new TicketEvents();
//Some validation first
if (!isset($event_type_id)) {
throw new CException("Event Type required when loggin ticket events.");
}
if (!isset($ticket_id)) {
throw new CException("Ticket ID required when loggin ticket events.");
}
//Collect and prepare the data
$newEvent->event_type_id = $event_type_id;
$newEvent->ticket_id = $ticket_id;
$newEvent->event_recorded_date = new CDbExpression('NOW()');
$newEvent->old_value = $old_value;
$newEvent->new_value = $new_value;
$newEvent->comment = $comment;
$newEvent->event_performed_by_user_id = User::getCurrentUserId();
//if save susscessfully, just return the new event
if ($newEvent->save()) {
$resEvent = $newEvent;
}
return $resEvent;
}
public function actionEscalate($id)
{
$model = $this->loadModel($id);
$modelNew = new Ticket();
$modelNew->creator_user_id = User::getCurrentUserId();
$modelNew->status = 'Pending';
$modelNew->created_date = new CDbExpression('NOW()');
$modelNew->subject = $model->subject;
$modelNew->description = $model->description;
$modelNew->domain_id = $model->domain_id;
$modelNew->subdomain_id = $model->subdomain_id;
$modelNew->file = $model->file;
$modelNew->priority_id = $model->priority_id;
$modelNew->isEscalated = 1;
$modelNew->assigned_date = new CDbExpression('NOW()');
/* Get the current date and time */
/*Assign the ticket to the most appropiate Domain mentor in tier2*/
$sub = true;
if ($model->subdomain_id == null) {
$sub = false;
}
if (!$sub) {
$modelNew->assign_user_id = User::escalateTicket($model->domain_id, $sub);
} else {
$modelNew->assign_user_id = User::escalateTicket($model->subdomain_id, $sub);
}
$saved = true;
$trans = Yii::app()->db->beginTransaction();
try {
$saved = $modelNew->save();
$sql = 'INSERT INTO comment(description, added_date, ticket_id, user_added) SELECT description, added_date,' . $modelNew->id . ', user_added FROM comment WHERE ticket_id =' . $model->id;
$command = Yii::app()->db->createCommand($sql);
$command->execute();
//generate the escalated events
TicketEvents::recordEvent(EventType::Event_Escalated_To, $model->id, NULL, $modelNew->id, NULL);
//generate the new event
TicketEvents::recordEvent(EventType::Event_New, $modelNew->id, NULL, NULL, NULL);
//generate the escalated events
TicketEvents::recordEvent(EventType::Event_Escalated_From, $modelNew->id, $model->id, NULL, NULL);
$trans->commit();
} catch (Exception $e) {
$trans->rollback();
Yii::log("Error occurred while saving the ticket or its events. Rolling back... . Failure reason as reported in exception: " . $e->getMessage(), CLogger::LEVEL_ERROR, __METHOD__);
$saved = false;
}
//$send = $modelNew->isNewRecord;
if ($saved) {
/*If save if true send Notification the the Domain Mentor who was assigned the ticket */
// if($send)
User::sendTicketAssignedEmailNotification($modelNew->creator_user_id, $modelNew->assign_user_id, $modelNew->domain_id, $modelNew->id);
// $this->redirect(array('view', 'id' => $modelNew->id));
//copy all the comments from the old ticket to the new ticket
//this has been substituted here for a change of status
/* $sql2 = 'INSERT INTO comment(description, added_date, ticket_id, user_added) VALUES ("Ticket ' . $model->id . ' was escalated to ticket '. $modelNew->id . '" , ' . $modelNew->created_date. ',' . $model->id . ', "System")';
$command2 = Yii::app()->db->createCommand($sql2);
$command2->execute();
$sql3 = 'INSERT INTO comment(description, added_date, ticket_id, user_added) VALUES ("Ticket ' . $model->id . ' was escalated to ticket '. $modelNew->id . '" , ' . $modelNew->created_date. ',' . $modelNew->id . ', "System")';
$command3 = Yii::app()->db->createCommand($sql3);
$command3->execute();*/
$response = array();
$response['url'] = "/coplat/index.php/home/userHome";
echo json_encode($response);
exit;
}
}
