/** * 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')); }