function reset_user_password($key = null)
{
if (!empty($this->data)) {
$user = $this->Ticket->findUser($this->data['Ticket']['email']);
$hasTicket = $this->Ticket->find('first', array('conditions' => array('Ticket.email' => $user['User']['email'])));
//pr($hasTicket);
//die;
if (!empty($user) && empty($hasTicket)) {
App::import('Helper', 'Time');
$time = new TimeHelper();
$key = Security::hash(String::uuid(), 'sha1', true);
$this->data['Ticket']['key'] = $key;
$this->data['Ticket']['creation_date'] = $time->format('Y-m-d H:i:s', time());
$url = Router::url(array('controller' => 'tickets', 'action' => 'reset_user_password'), true) . '/' . $key;
//pr($url);
//die;
//ko se ticket shrani v bazo se poslje email (email element: lost_password_notification.ctp) useru, ki je ticket odprl
if ($this->Ticket->save($this->data)) {
$this->set('url', $url);
$this->MyEmail->sendResetPasswordEmail($user['User']['email']);
$this->Session->setFlash('notification email has been sent to you with reset data');
}
} elseif (!empty($hasTicket)) {
if ($this->Ticket->checkTicketDateValidity($hasTicket)) {
$this->Session->setFlash('We had already sent you a link to your email address! Go get it, lazy ass!');
} else {
$this->Session->setFlash('Your ticket regarding lost password has been deleted due to expiration! Try submitting again');
}
}
//se prozi kadar user klikne link, ki vsebuje generiran key, v svojem mailu in ga redirecta sem
} elseif (isset($key) && !empty($key)) {
$result = $this->Ticket->find('first', array('conditions' => array('Ticket.key' => $key)));
$this->Ticket->checkTicketDateValidity($result);
if (!empty($result)) {
$user = $this->Ticket->findUser($result['Ticket']['email']);
$this->set('userId', $user['User']['id']);
$this->set('key', $key);
$this->Ticket->delete($result['Ticket']['id']);
//$this->redirect(array('controller' => 'users', 'action' => 'changeUserPassword/uid:'.$user['User']['id']));
}
} else {
$this->Session->setFlash('Please provide your email!');
}
}
/**
* Store a newly created resource in storage.
*
* @param TicketFormRequest $request
* @return \Illuminate\Http\Response
*/
public function store(TicketFormRequest $request)
{
// return $request->all();
$slug = uniqid();
$ticket = new Ticket(array('title' => $request->get('title'), 'content' => $request->get('content'), 'slug' => $slug));
$ticket->save();
$data = array('ticket' => $slug);
Mail::send('emails.ticket', $data, function ($message) {
$message->from('*****@*****.**', 'Ticket System');
$message->to('*****@*****.**')->subject('There is a new ticket!');
});
return redirect('/contact')->with('status', 'Your ticket has been created! Inserts unique id is: ' . $slug);
}
function set($info = null)
{
$this->garbage();
if ($info) {
$ticketObj = new Ticket();
$data['Ticket']['hash'] = md5(time());
$data['Ticket']['data'] = $info;
if ($ticketObj->save($data)) {
return $data['Ticket']['hash'];
}
}
return false;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Ticket();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Ticket'])) {
$model->attributes = $_POST['Ticket'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->ticket_id));
}
}
$this->redirect(array('view', 'id' => 1));
$this->render('create', array('model' => $model));
}
public function actionCreate()
{
$ticket = new Ticket();
$this->pageName = Yii::t('SupportModule.default', 'MODULE_NAME');
if (Yii::app()->request->isPostRequest) {
$ticket->attributes = $_POST['Ticket'];
$ticket->client_id = Yii::app()->params['client_id'];
if ($ticket->validate()) {
// print_r($ticket);
if ($ticket->save()) {
$this->sendEmail($ticket);
Yii::app()->user->setFlash('success', 'Спасибо за обращение, в ближайшие время оператор вам ответить');
//$this->redirect(array('view','id'=>$ticket->id));
}
}
}
$this->render('create', array('model' => $ticket));
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$rules = ['priority' => 'AlphaNum', 'title' => 'Required', 'text' => 'Required', 'status' => 'Required', 'category' => 'Required|Exists:ticket_categories,id'];
$v = Validator::make(Input::all(), $rules);
if ($v->passes()) {
$ticket = new Ticket();
$ticket->fill(Input::all());
$ticket->issuer()->associate(Auth::getUser());
if (Input::get('category')) {
$cat = TicketCategory::findOrFail(Input::get('category'));
$ticket->category()->associate($cat);
}
$ticket->save();
return Redirect::action('TicketController@index');
} else {
return Redirect::action('TicketController@create')->withErrors($v->getMessageBag());
}
}
public function actionCreate()
{
$model = new OpenTicketForm();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['OpenTicketForm'])) {
$model->attributes = $_POST['OpenTicketForm'];
if ($model->validate()) {
//开票操作一
$ticket = new Ticket();
$ticket->user_email = $model->user_email;
$ticket->user_name = $model->user_name;
$ticket->subject = $model->subject;
$ticket->create_time = date('Y-m-d H:i:s');
$ticket->update_time = date('Y-m-d H:i:s');
$ticket->dept_id = 0;
$ticket->topic_id = $model->help_topic;
$ticket->user_id = Yii::app()->user->getState('user_id');
$ticket->status = 'open';
$ticket->is_answered = 0;
if (!$ticket->save()) {
var_dump($ticket->errors);
die;
}
//print_r($ticket->errors);exit;
//开票操作二
$message = new TicketMessage();
$message->ticket_id = $ticket->ticket_id;
$message->staff_id = 0;
$message->msg_content = $model->msg_content;
$message->create_time = date('Y-m-d H:i:s');
$message->update_time = date('Y-m-d H:i:s');
$message->ip_address = '127.0.0.1';
$message->save();
//页面跳转
Yii::app()->user->setFlash('contact', 'Thank you for contacting us. We will respond to you as soon as possible.');
$this->refresh();
}
}
//$this->redirect(array('view','id'=>1));
$this->render('create', array('model' => $model));
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Ticket();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Ticket'])) {
$model->attributes = $_POST['Ticket'];
$model->total_money = $model->weight * $model->price + $model->insurance + $model->packages + $model->pay_before;
if ($model->size > 0) {
$model->density = round($model->weight / $model->size, 2);
} else {
$model->density = 0;
}
$model->create_time = time();
$model->update_time = time();
$model->valid = 1;
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
/**
* Test whether a second BelongsTO assignment does change the attribute
* (Check if BelongsTo cache is properly updated)
*
* @return null
*/
public function testBelongsDoubleAttribution()
{
$user1 = new User();
$user1->name = "Belongs first attribution from where and other class";
$user1->email = "*****@*****.**";
$user1->code = "01011";
$user1->level = 1;
$this->assertTrue($user1->save());
$user2 = new User();
$user2->name = "Belongs second attribution from where and other class";
$user2->email = "*****@*****.**";
$user2->code = "01012";
$user2->level = 1;
$this->assertTrue($user2->save());
$uid1 = $user1->id;
$uname1 = $user1->name;
$uid2 = $user2->id;
$uname2 = $user2->name;
$users = [$user1->code, $user2->code];
$ticket = new Ticket();
$ticket->description = "Test";
$ticket->user = $user1;
$this->assertEquals($uname1, $ticket->user->name);
$ticket->user = $user2;
$this->assertEquals($uname2, $ticket->user->name);
$this->assertTrue($ticket->save());
$this->assertNotEquals(self::$user->id, $uid1);
$this->assertNotEquals(self::$user->id, $uid2);
$this->assertNotNull($uid1);
$this->assertNotNull($uid2);
$this->assertEquals($ticket->user->id, $uid2);
$this->assertTrue($user1->destroy());
$this->assertTrue($user2->destroy());
$this->assertTrue($ticket->destroy());
}
public function post_newguestticket()
{
$postStr = Input::get('data');
parse_str($postStr, $post);
$post['supportInputHuman'] = strtolower($post['supportInputHuman']);
//Create our validator
$validator = Validator::make(array('name' => $post['supportInputName'], 'email' => $post['supportInputEmail'], 'subject' => $post['supportInputSubject'], 'description' => $post['supportInputDescription'], 'human' => $post['supportInputHuman']), array('name' => 'required|max:50', 'email' => 'required|email|max:100', 'subject' => 'required|max:100', 'description' => 'required|max:4000', 'human' => 'required|in:vatsim'), array('human.required' => 'Please fill in the anti-spam question. (Hint It ends with SIM and starts with VAT.).', 'human.in' => 'The antispam answer is not correct. (Hint: It ends with SIM and starts with VAT.)'));
//Let's make sure that our user is not logged in
if ($validator->fails() || Auth::user()->check()) {
$messages = $validator->messages();
$errorStr = '';
//If we are logged in let's append an error to that message.
if (Auth::user()->check()) {
$errorStr .= '<div class="alert alert-error">Please use the built in ticket help desk in your VA console. You can log in at the top right of this page.</div>';
}
foreach ($messages->all('<li>:message</li>') as $message) {
$errorStr .= '<div class="alert alert-error">' . $message . '</div>';
}
echo $errorStr;
} else {
//All clear.
$ticket = new Ticket();
//We set this value to -1 since it is not associated with a specific VID
$ticket->vid = -1;
$ticket->subject = $post['supportInputSubject'];
$ticket->description = $post['supportInputDescription'];
//The status is open by default
$ticket->status = 1;
$ticket->name = $post['supportInputName'];
$ticket->email = $post['supportInputEmail'];
$ticket->hash = sha1($post['supportInputName'] . time());
//Save our ticket
$ticket->save();
//Create a URL for the user to access their ticket at
$url = URL::to('/') . '/ticket/hash/' . $ticket->hash;
//Now email the user the ticket # and a direct link to access updates (using the hash)
$body = "Hello " . $post['supportInputName'] . ",<br /><br />The VATSIM VASOPs department has received your ticket. Please use the following link to view and update your ticket.<br /><br /> <a href='" . $url . "'>" . $url . "</a><br /><br />You may also view your ticket at <a href='" . Url::to('/') . "/#moduleSupport'>" . Url::to('/') . "/#moduleSupport</a> by entering the following details.<br /><br /><strong>Ticket ID: " . $ticket->id . "</strong><br /><strong>Email: " . $post['supportInputEmail'] . "</strong><br /><br /><br /> <strong>Do not reply to this email. If you wish to reply to this ticket, please do so through your account online.</strong>";
$data = array('subject' => 'VASOPS Ticket #' . $ticket->id . ": " . $post['supportInputSubject'], 'email' => $post['supportInputEmail'], 'name' => $post['supportInputName']);
Mail::send('email.default', array("content" => $body), function ($message) use($data) {
$message->to($data['email'], $data['name'])->subject($data['subject']);
});
//Get a list of auditors who have subscribed to ticket email notifications and send them an email
$auditors = ConsoleUser::where('ticketnotifications', '=', '1')->where('access', '>', -1)->get();
foreach ($auditors as $auditor) {
$email = $auditor->email;
if (empty($email)) {
continue;
}
$body = "Hello " . $auditor->name . ",<br /><br />A new ticket was created by " . $post['supportInputName'] . "<br /><br />" . $post['supportInputDescription'] . "<br /><br /><br /> <strong>Do not reply to this email. If you wish to reply to this ticket, please do so through your account online.</strong>";
$data = array('subject' => 'VASOPS New Ticket: ' . $post['supportInputSubject'], 'name' => $auditor->name, 'email' => $auditor->email);
Mail::send('email.default', array("content" => $body), function ($message) use($data) {
$message->to($data['email'], $data['name'])->subject($data['subject']);
});
}
//That will be all. Let's send 1 to our client to let me know that everything went well.
echo 1;
}
}
$person = new Person($row2['username']);
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
$ticket->updateHistory($history);
}
//
// responses go in issueHistory
//
$sql = "select r.date as date,r.notes as notes,\n u.username as username, c.name as contactMethod\n\t\tfrom responses r\n left join referrals rf on r.referral_id = rf.id\n left join users u on r.user_id = u.id\n left join contactMethods c on r.contactMethod_id = c.id\n\t\twhere rf.request_id=" . $row['id'];
$result2 = $pdo->query($sql);
while ($result2 && ($row2 = $result2->fetch(PDO::FETCH_ASSOC))) {
$history = new History();
$history->setAction('response');
$history->setEnteredDate($row2['date']);
$history->setActionDate($row2['date']);
$history->setNotes($row2['notes']);
$person = new Person($row2['username']);
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
$ticket->updateHistory($history);
}
try {
$ticket->save();
echo $ticket->getId() . " {$cnt}\n";
$cnt++;
} catch (Exception $e) {
echo $e->getMessage() . "\n";
print_r($e);
exit;
}
}
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;
}
}
function editarSeguro()
{
try {
$this->getById($_REQUEST['id']);
$this->voucher = $_REQUEST['voucher'];
$this->save();
$user = new Usuario();
$user->id = $_SESSION['ag_idUsuario'];
//grava os tickets
$oVoo = new Voo();
$rsVoo = $oVoo->getRows(0, 999, array("id" => "asc"), array("grupo" => " = " . $this->grupo->id));
foreach ($rsVoo as $key => $voo) {
$oTicket = new Ticket();
$oTicket->getRow(array("voo" => " = " . $voo->id, "participante" => " = " . $this->id));
$oTicket->voo = $voo;
$oTicket->participante = $this;
$oTicket->ticket = $_REQUEST['ticket' . $voo->id];
$oTicket->reserva = $_REQUEST['reserva' . $voo->id];
$oTicket->save();
}
//grava log de usuario
$oLog = new LogUsuario();
$data = date("Y-m-d H:i:s");
$movimento = "ALTERAR SEGURO DO PARTICIPANTE<BR> CLIENTE: " . $this->cliente->nomeCompleto . "<BR> GRUPO: " . $this->grupo->nomePacote;
$oLog->usuario = $user;
$oLog->data = $data;
$oLog->movimento = $movimento;
$oLog->save();
//fim da log
$_SESSION['tupi.mensagem'] = 48;
} catch (Exception $e) {
$_SESSION['tupi.mensagem'] = 49;
}
}
function convertToTicket(&$logged_user, &$error)
{
db_begin_work();
$ticket = new Ticket();
$ticket->setProjectId($this->getProjectId());
$ticket->setName($this->getName());
$ticket->setBody($this->getBody());
$ticket->setState($this->getState());
$ticket->setVisibility($this->getVisibility());
$ticket->setPriority($this->getPriority());
$ticket->setCommentsCount($this->getCommentsCount());
$ticket->setIsLocked($this->getIsLocked());
$ticket->setCreatedById($logged_user->getId());
$ticket->setCreatedByName($logged_user->getName());
$ticket->setCreatedByEmail($logged_user->getEmail());
if ($this->getType() == 'Page') {
$ticket->setMilestoneId($this->setMilestoneId());
}
$save = $ticket->save();
if ($save && !is_error($save)) {
db_commit();
$ticket->ready();
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS);
mysql_select_db(DB_NAME);
$query = "update healingcrystals_project_objects set parent_id='" . $ticket->getId() . "', parent_type='Ticket' where parent_id='" . $this->getId() . "' and project_id='" . $this->getProjectId() . "' and type in ('Comment', 'Task')";
mysql_query($query);
$query = "update healingcrystals_project_objects set parent_id=null, parent_type=null where parent_id='" . $this->getId() . "' and project_id='" . $this->getProjectId() . "' and type not in ('Comment', 'Task')";
mysql_query($query);
if ($this->getType() == 'Milestone') {
$query = "update healingcrystals_project_objects set milestone_id=null where milestone_id='" . $this->getId() . "' and project_id='" . $this->getProjectId() . "'";
mysql_query($query);
}
$query = "select * from healingcrystals_assignments where object_id='" . $this->getId() . "'";
$result = mysql_query($query);
while ($entry = mysql_fetch_assoc($result)) {
$query = "insert into healingcrystals_assignments (user_id, object_id, is_owner) values ('" . $entry['user_id'] . "', '" . $ticket->getId() . "', '" . $entry['is_owner'] . "')";
mysql_query($query);
}
$query = "select * from healingcrystals_project_object_categories where object_id='" . $this->getId() . "'";
$result = mysql_query($query);
while ($entry = mysql_fetch_assoc($result)) {
$query = "insert ignore into healingcrystals_project_object_categories (object_id, category_id) values ('" . $ticket->getId() . "', '" . $entry['category_id'] . "')";
mysql_query($query);
}
mysql_close($link);
$this->moveToTrash();
return $ticket->getIntegerField1();
} else {
db_rollback();
$error = $save;
return '';
}
}
/**
* Test primary key method
*
* @return null
*/
public function testPKMethod()
{
$user = User::first();
$ticket = new Ticket();
$ticket->user_id = $user->id;
$ticket->description = "pk value test";
$this->assertTrue($ticket->save());
$ticket = Ticket::last();
$this->assertTrue($ticket->id >= time() - 1000);
$this->assertTrue($ticket->destroy());
}
function change_priority()
{
$this->active_ticket->setPriority($this->request->post('priority'));
$save = $this->active_ticket->save();
}
/**
* Add uploaded files to ticket
*
* @return bool|int
*/
public function processFiles()
{
$q = $this->modx->newQuery('TicketFile');
$q->where(array('class' => 'Ticket'));
$q->andCondition(array('parent' => 0, 'createdby' => $this->modx->user->id), null, 1);
$q->sortby('createdon', 'ASC');
$collection = $this->modx->getIterator('TicketFile', $q);
$replace = array();
$count = 0;
/** @var TicketFile $item */
foreach ($collection as $item) {
$hash = $item->get('hash');
if ($item->get('deleted')) {
$replace[$item->get('url')] = '';
$item->remove();
} elseif (!isset($hashes[$hash])) {
$old_url = $item->get('url');
$item->set('parent', $this->object->get('id'));
$item->save();
$new_url = $item->get('url');
if ($old_url != $new_url) {
$replace[preg_replace('/\\.[a-z]+$/i', '', $old_url)] = preg_replace('/\\.[a-z]+$/i', '', $new_url);
}
$count++;
}
}
// Update ticket links
if (!empty($replace)) {
$array = array('introtext' => $this->object->get('introtext'), 'content' => $this->object->get('content'));
$update = false;
foreach ($array as $field => $text) {
$pcre = '#<a.*?>.*?</a>|<img.*?>#s';
preg_match_all($pcre, $text, $matches);
$src = $dst = array();
foreach ($matches[0] as $tag) {
foreach ($replace as $from => $to) {
if (strpos($tag, $from) !== false) {
if ($to == '') {
$src[] = $tag;
$dst[] = '';
} else {
$src[] = $from;
$dst[] = $to;
}
break;
}
}
}
if (!empty($src)) {
$text = str_replace($src, $dst, $text);
if ($text != $this->object->{$field}) {
$this->object->set($field, $text);
$update = true;
}
}
}
if ($update) {
$this->object->save();
}
}
return $count;
}
/**
* Saves/Edits an account
*
*/
public function postEdit($ticket = false)
{
try {
if (empty($ticket)) {
$ticket = new Ticket();
} else {
if ($ticket->user_id !== Auth::id()) {
throw new Exception('general.access_denied');
}
}
$ticket->title = Input::get('title');
$ticket->description = Input::get('description');
$ticket->active = 1;
$ticket->priority = Input::get('priority');
$deploymentId = Input::get('deploymentId');
$ticket->deploymentId = empty($deploymentId) ? 0 : $deploymentId;
$ticket->user_id = Auth::id();
// logged in user id
$success = $ticket->save();
if ($success) {
return Redirect::intended('ticket')->with('success', Lang::get('ticket/ticket.ticket_updated'));
} else {
return Redirect::to('ticket')->with('error', Lang::get('ticket/ticket.ticket_auth_failed'));
}
} catch (Exception $e) {
Log::error($e);
return Redirect::to('ticket')->with('error', $e->getMessage());
}
}
