/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(TicketFormRequest $request)
{
// return $request->all();
$ticket = new Ticket(array('title' => $request->get('title'), 'content' => $request->get('content'), 'phone_number' => $request->get('phone_number'), 'email' => $request->get('email'), 'country' => $request->get('country'), 'gender' => $request->get('gender'), 'job' => $request->get('job')));
$ticket->save();
return redirect('/contact')->with('status', 'Your contact has been created! Its unique id is: ');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(TicketFormRequest $request)
{
$slug = uniqid();
$ticket = new Ticket(array('title' => $request->get('title'), 'content' => $request->get('content'), 'slug' => $slug, 'user_id' => 0));
$ticket->save();
return redirect('/contact')->with('status', 'Your ticket has been created! Its unique id is: ' . $slug);
}
/**
* upload New Tickets
*
* @return Response
*/
public function postUploadTickets(Request $request)
{
$file = $request->file;
// your file upload input field in the form should be named 'file'
//validate the upload
$validator = $this->validator($request->all());
if ($validator->fails()) {
return redirect('/tickets/upload?error')->with('message', 'The following errors occurred')->withErrors($validator)->withInput();
}
if (($handle = fopen($file, 'r')) !== FALSE) {
while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
$ticket = new Ticket();
$ticket->requester = $row[0];
$ticket->ref_number = $row[1];
$ticket->open_date = $row[2];
$ticket->service = $row[3];
$ticket->priority = $row[4];
$ticket->sla_breached = $row[5];
$ticket->customer = $row[6];
$ticket->location = $row[7];
$ticket->reporting_method = $row[8];
$ticket->resolver_group = $row[9];
$ticket->resolution_code = $row[10];
$ticket->cause_code = $row[11];
$ticket->responsible_party = $row[12];
$ticket->reported_by = $row[13];
//$ticket->closed_by = $row[14] ;
$ticket->save();
}
}
return redirect('/tickets/upload?done=1');
}
/**
* Store a new ticket
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function newTicket(Request $request)
{
$messages = ['required' => 'The :attribute is mandatory', 'phone_number.regex' => 'The phone number must be in E.164 format'];
$this->validate($request, ['name' => 'required', 'phone_number' => 'required|regex:/^\\+[1-9]\\d{1,14}$/', 'description' => 'required'], $messages);
$newTicket = new Ticket($request->all());
$newTicket->save();
$request->session()->flash('status', "We've received your support ticket. We'll be in touch soon!");
return redirect()->route('home');
}
public static function registrarHIjo($nroTicket, $ticketPadre, $usucrea)
{
$ticket = new Ticket();
$ticket->nroticket = $nroTicket;
$ticket->usucrea = $usucrea;
$ticket->ticket_padre = $ticketPadre;
$ticket->save();
return $ticket->id;
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(TicketFormRequest $request)
{
$slug = uniqid();
$ticket = new Ticket(['title' => $request->get('title'), 'content' => $request->get('content'), 'slug' => $slug]);
$ticket->save();
Mail::send('emails.ticket', ['ticket' => $slug], function ($message) {
$message->from('*****@*****.**', 'Learning Laravel');
$message->to('*****@*****.**')->subject('There is a new ticket!');
});
return redirect('/contact')->with('status', 'Your ticket has been created! Its unique id is: ' . $slug);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(TicketFormRequest $request)
{
$ticket = new Ticket();
$ticket->title = request('title');
$ticket->content = request('content');
$ticket->slug = uniqid();
$ticket->user_id = Auth::user()->id;
$ticket->status = 5;
$ticket->save();
return redirect('tickets')->withStatus('Your ticket has been created! Its unique id is ' . $ticket->slug);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(TicketFormRequest $request)
{
$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('*****@*****.**', 'Learning Laravel');
$message->to('*****@*****.**')->subject('There is a new ticket!');
});
return redirect('/contact')->with('status', 'Your ticket has been created! Its unique id is: ' . $slug);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(TicketFormRequest $request)
{
//Para validar los datos enviados
//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('*****@*****.**', 'Learning Laravel');
$message->to('*****@*****.**')->subject('Hay un nuevo ticket');
});
return redirect('/contact')->with('status', 'Your ticket has been created! Its unique id is: ' . $slug);
}
/**
* Store a newly created resource in storage.
*
* @param TicketRequest $request
* @return Response
*/
public function store(TicketRequest $request)
{
$request['slug'] = strtolower(str_random(10));
// create new ticket
$ticket = new Ticket($request->all());
$ticket->save();
// update users in pivot table
$this->syncUsers($ticket, $request['user_list']);
session()->flash('flash_message', "The ticket \"{$ticket->name}\" has been created.");
// redirect to notification form
if ($request['notify']) {
return redirect("tickets/{$ticket->id}/notify");
}
return redirect('tickets');
}
public function create(Request $request)
{
$ticket = new Ticket();
$ticket->customer_name = $request->get('customer_name');
$ticket->customer_address = $request->get('customer_address');
$ticket->customer_tel = $request->get('customer_tel');
$ticket->customer_email = $request->get('customer_email');
$ticket->type = $request->get('type');
$ticket->category_id = $request->get('category_id');
$ticket->post_serial = $request->get('post_serial');
$ticket->description = $request->get('description');
$ticket->user_created = Auth::user()->id;
if (!$ticket->save()) {
return 'There was an error';
}
return 'Ticket created';
}
public function store(TicketFormRequest $request)
{
$slug = uniqid();
$ticket = new Ticket(['title' => $request->get('title'), 'content' => $request->get('content'), 'slug' => $slug]);
$ticket->save();
/*-----------------------------------------------------------------------
Uncomment and add your email address to use mail function.
Note: Use '.env.email' as your '.env'
-------------------------------------------------------------------------
$data = array(
'ticket' => $slug
);
Mail::send('emails.ticket', $data, function ($message) {
$message->from('*****@*****.**', 'Learning Laravel');
$message->to('*****@*****.**')->subject('There is a new ticket');
});
------------------------------------------------------------------------*/
return redirect('/contact')->with('status', 'Your ticket has been created! Its unique id is ' . $slug);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Requests\CreateTicket $request)
{
$ticket = new Ticket($request->all());
$ticket->save();
return redirect('tickets');
}
public function update(Ticket $ticket, TicketFormRequest $request)
{
$ticket->title = $request->get('title');
$ticket->content = $request->get('content');
if ($request->get('status') != null) {
$ticket->status = 0;
//0=answered
} else {
$ticket->status = 1;
//1=pending
}
$ticket->save();
return redirect(action('TicketsController@edit', $ticket->slug))->with('status', 'The ticket ' . $ticket->slug . ' has been updated!');
}
public function appGetMaintianWorkFormAct()
{
$nhservers = Nhserver::all();
$curl = new Curl();
foreach ($nhservers as $nhserver) {
$p = 0;
$retCount = 1;
while ($retCount != 0) {
$curl->get('http://' . $nhserver->host . ':' . $nhserver->port . '/WebSite/appGetMaintianWorkFormAct.ebf', array('MaintianComTel' => '400335', 'PageIndex' => $p++));
$result = $curl->response;
$result = mb_convert_encoding($result, "UTF-8", "gb2312");
$json_result = json_decode($result);
$retCount = count($json_result->Ret);
foreach ($json_result->Ret as $ret) {
$historyTicket = Ticket::current()->wformid($ret->WFormId)->find();
if (empty($historyTicket)) {
//step 1 save record
$millisecond = microtime(true) * 1000;
$time = explode(".", $millisecond);
$millisecond = $time[0];
$api_id = 'ABC' . $millisecond;
$ticket = new Ticket();
$ticket->current = 1;
$ticket->location_id = $nhserver->id;
$ticket->time_log = date('Y-m-d H:i:s');
$ticket->data_content = $result;
$ticket->WFormId = $ret->WFormId;
$ticket->Identifier = $ret->Identifier;
$ticket->WFormSetTime = $ret->WFormSetTime;
$ticket->ReplyDue = $ret->ReplyDue;
$ticket->IsChecked = $ret->IsChecked;
$ticket->ArriveDue = $ret->ArriveDue;
$ticket->WFormContent = $ret->WFormContent;
$ticket->OrgName = $ret->OrgName;
$ticket->InstallAddress = $ret->InstallAddress;
$ticket->ModelId = $ret->ModelId;
$ticket->BrandId = $ret->BrandId;
$ticket->RepairInfo = json_encode($ret->RepairInfo);
$ticket->Engineer = $ret->RepairInfo->Engineer;
$ticket->RepairCreateTime = $ret->RepairInfo->RepairCreateTime;
$ticket->RespTime = $ret->RepairInfo->RespTime;
$ticket->ArrivalTime = $ret->RepairInfo->ArrivalTime;
$ticket->RepairformSts = $ret->RepairInfo->RepairformSts;
$ticket->MaintianComTel = $ret->RepairInfo->MaintianComTel;
$ticket->GivenArrivalTime = $ret->RepairInfo->GivenArrivalTime;
$ticket->Mobile = $ret->RepairInfo->Mobile;
$ticket->api_id = $api_id;
$ticket->save();
//step 2 send email
//step 3 call ebs api
} else {
//check update
if ($historyTicket->Identifier != $ret->Identifier || $historyTicket->WFormSetTime != $ret->WFormSetTime || $historyTicket->ReplyDue != $ret->ReplyDue || $historyTicket->IsChecked != $ret->IsChecked || $historyTicket->ArriveDue != $ret->ArriveDue || $historyTicket->WFormContent != $ret->WFormContent || $historyTicket->OrgName != $ret->OrgName || $historyTicket->InstallAddress != $ret->InstallAddress || $historyTicket->ModelId != $ret->ModelId || $historyTicket->BrandId != $ret->BrandId || $historyTicket->Engineer != $ret->RepairInfo->Engineer || $historyTicket->RepairCreateTime != $ret->RepairInfo->RepairCreateTime || $historyTicket->RespTime != $ret->RepairInfo->RespTime || $historyTicket->ArrivalTime != $ret->RepairInfo->ArrivalTime || $historyTicket->RepairformSts != $ret->RepairInfo->RepairformSts || $historyTicket->MaintianComTel != $ret->RepairInfo->MaintianComTel || $historyTicket->GivenArrivalTime != $ret->RepairInfo->GivenArrivalTime || $historyTicket->Mobile != $ret->RepairInfo->Mobile) {
$ticket = new Ticket();
$ticket->current = 1;
$ticket->location_id = $historyTicket->location_id;
$ticket->time_log = date('Y-m-d H:i:s');
$ticket->data_content = $result;
$ticket->WFormId = $ret->WFormId;
$ticket->Identifier = $ret->Identifier;
$ticket->WFormSetTime = $ret->WFormSetTime;
$ticket->ReplyDue = $ret->ReplyDue;
$ticket->IsChecked = $ret->IsChecked;
$ticket->ArriveDue = $ret->ArriveDue;
$ticket->WFormContent = $ret->WFormContent;
$ticket->OrgName = $ret->OrgName;
$ticket->InstallAddress = $ret->InstallAddress;
$ticket->ModelId = $ret->ModelId;
$ticket->BrandId = $ret->BrandId;
$ticket->RepairInfo = json_encode($ret->RepairInfo);
$ticket->Engineer = $ret->RepairInfo->Engineer;
$ticket->RepairCreateTime = $ret->RepairInfo->RepairCreateTime;
$ticket->RespTime = $ret->RepairInfo->RespTime;
$ticket->ArrivalTime = $ret->RepairInfo->ArrivalTime;
$ticket->RepairformSts = $ret->RepairInfo->RepairformSts;
$ticket->MaintianComTel = $ret->RepairInfo->MaintianComTel;
$ticket->GivenArrivalTime = $ret->RepairInfo->GivenArrivalTime;
$ticket->Mobile = $ret->RepairInfo->Mobile;
$ticket->api_id = $historyTicket->api_id;
$ticket->ebs_id = $historyTicket->ebs_id;
$ticket->ebs_content = $historyTicket->ebs_content;
$ticket->flag1 = $historyTicket->flag1;
$ticket->flag2 = $historyTicket->flag2;
$ticket->flag3 = $historyTicket->flag3;
$ticket->flag4 = $historyTicket->flag4;
$ticket->flag5 = $historyTicket->flag5;
$ticket->save();
$historyTicket->current = 0;
$historyTicket->save();
}
}
}
}
//Timeout not responding (Select * from tb_ticket where current=1 and repairformset=1 and flag1=0 and repaircreatetime is not null and datediff(mi,repaircreatetime,now)>20)
$timeout_tickets = DB::select('select * from tickets where current=1 and RepairformSts=1 and flag1=0 and RepairCreateTime is not null and datediff(mi,RepairCreateTime,now)>20');
foreach ($timeout_tickets as $t) {
//send email to user
}
//update flag1 = 1;
DB::update('update tickets set flag1 = 1 where current=1 and RepairformSts=1 and flag1=0 and RepairCreateTime is not null and datediff(mi,RepairCreateTime,now)>20');
//Timeout is not present (Select * from tb_ticket where current=1 and repairformset=2 and flag2=0 and resptime is not null and datediff(mi,resptime,now)>20)
$timeout_tickets = DB::select('select * from tickets where current=1 and RepairformSts=2 and flag2=0 and RespTime is not null and datediff(mi,RespTime,now)>20');
foreach ($timeout_tickets as $t) {
//send email to user
}
//update flag2 = 1;
DB::update('update tickets set flag2 = 1 where current=1 and RepairformSts=2 and flag2=0 and RespTime is not null and datediff(mi,RespTime,now)>20');
//Timeout not repaired (Select * from tb_ticket where current=1 and repairformset=3 and flag3=0 and arrivaltime is not null and datediff(mi,arrivaltime,now)>20)
$timeout_tickets = DB::select('select * from tickets where current=1 and RepairformSts=3 and flag3=0 and ArrivalTime is not null and datediff(mi,ArrivalTime,now)>20');
foreach ($timeout_tickets as $t) {
//send email to user
}
//update flag3 = 1;
DB::update('update tickets set flag3 = 1 where current=1 and RepairformSts=3 and flag3=0 and ArrivalTime is not null and datediff(mi,ArrivalTime,now)>20');
}
$curl->close();
}
public function saveNewTicket(Request $request)
{
try {
DB::beginTransaction();
$ticket = new Ticket();
$ticket->title = $request->input('title');
$ticket->description = $request->input('description');
$ticket->complete_date = $request->input('complete_date');
$ticket->project_id = $request->input('project_id');
$ticket->assigned_to = $request->input('assigned_to');
$ticket->type = $request->input('type');
$ticket->estimate_id = $request->input('estimate_id');
$ticket->created_by = Auth::user()->id;
$ticket->status = 'Assigned';
$ticket->save();
$followers = $request->input('followers');
foreach ($followers as $value) {
DB::table('ticket_followers')->insert(['ticket_id' => $ticket->id, 'user_id' => $value]);
}
$this->dispatch(new TicketCreatedNotification($ticket));
DB::commit();
} catch (\PDOException $e) {
DB::rollBack();
return response('Some error in saving the ticket', 500);
}
return response('Ticket saved', 201);
}
public function postTicket()
{
//require login
if (!Auth::check()) {
return Redirect::to("auth/login");
}
//auth check passed
$ticket = new Ticket();
//this ticket should be associated with nobody when it is first created.
$ticket->assigned_to = null;
$ticket->setStatus($ticket->getStatusFromFriendly('new'));
$ticket->priority = 2;
$ticket->date_created = Carbon::now();
$ticket->placedBy()->associate(Auth::user());
$ticket->subject = Input::get("ticketTitle");
$ticket->save();
//add a message containing the ticket text
$message = new Message();
$message->user()->associate(Auth::user());
$message->ticket()->associate($ticket);
$message->text = Input::get("ticketText");
$message->ticket_status = $ticket->status;
$message->created = Carbon::now();
$message->save();
//now show the ticket
return view('helpdesk/ticket', compact("ticket"));
}
public function update(TicketRequest $request, Ticket $ticket)
{
if (!Entrust::can('edit_ticket')) {
return redirect('/dashboard')->withErrors(config('constants.NA'));
}
if (!Helper::getMode()) {
return redirect()->back()->withErrors(config('constants.DISABLE_MESSAGE'));
}
$data = $request->except('user_id');
$ticket->fill($data)->save();
$service_time = Helper::getServiceTime($ticket->ticket_priority);
if ($service_time['resolution_time_type'] == 'business_hour') {
$ticket->resolution_due_time = Helper::calculateDueTime($service_time['resolution_time'], $ticket->created_at);
} else {
$ticket->resolution_due_time = date('Y-m-d H:i', $service_time['resolution_time'] * 60 + strtotime($ticket->created_at));
}
if ($service_time['response_time_type'] == 'business_hour') {
$ticket->response_due_time = Helper::calculateDueTime($service_time['response_time'], $ticket->created_at);
} else {
$ticket->response_due_time = date('Y-m-d H:i', $service_time['response_time'] * 60 + strtotime($ticket->created_at));
}
$ticket->save();
Helper::updateCustomField($this->form, $ticket->id, $data);
$ticket->assignedUser()->sync($request->input('user_id') ?: []);
return redirect()->back()->withSuccess(config('constants.ADDED'));
}
