File manager - Edit - /var/www/payraty/helpdesk/app/Services/Ticketing/DeleteTickets.php
Back
<?php namespace App\Services\Ticketing; use App\Models\Activity; use App\Models\Reply; use App\Models\Ticket; use Illuminate\Support\Facades\DB; class DeleteTickets { public function execute(array $ticketIds): void { $replyIds = Reply::whereIn('ticket_id', $ticketIds) ->get(['id', 'ticket_id']) ->pluck('id'); //detach attachments from replies DB::table('file_entry_models') ->whereIn('model_id', $replyIds) ->where('model_type', Reply::MODEL_TYPE) ->delete(); //detach tags from tickets DB::table('taggables') ->whereIn('taggable_id', $ticketIds) ->where('taggable_type', Ticket::MODEL_TYPE) ->delete(); //delete ticket replies Reply::whereIn('id', $replyIds)->delete(); //delete tickets Ticket::whereIn('id', $ticketIds)->delete(); // delete activity items Activity::where('subject_type', Ticket::MODEL_TYPE) ->whereIn('subject_id', $ticketIds) ->delete(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 0.3 |
proxy
|
phpinfo
|
Settings