ÿØÿà JFIF 

  
 
  ÿÛ „ 	 ( %!1!%)+...383-7(-.+




-%%--------------------------------------------------ÿÀ 
 ·
" 

ÿÄ   



           
 ÿÄ 6 



   
 !1AQa"q‘±ð¡ÁÑ2Bá#Rb‚ñr ÿÄ 
 


            
ÿÄ $



 

   
     
!1A2Qaq‘Ñ"ÿÚ 
  ? óª4¦ù‡;ýÔ­aH6’
¯ëxòPº°pp-LæsÊÿ DÖ7:,ûž«ðwZÛ-FȨØðf:‹ß¦šè¸*¹Û”Énó¯¿Âùó†ñ&¶£AiÌ39Ž‡
ÙÛ”Ï.«ÜþÆ6³
§PT$‚5ê‹žæçKw±Ñµ£¡û÷©a5¡9tDB„ÀAB B„€Lsá<¨ª±*p|à¹Þ8 ÜÅÿ 
C!sÜK"=Jæòï¾—Æ9퉌ÄNl׍n¹ü[HÒ;÷W¸…Fîá ¼÷ôÕbbñRH6ëÓªÆZÒ¦*¤´óßÞû,ªµãen«š	ÓQ§—%B¸ßšè̈èÈ(UK«ù‰õ5L™ Æý#ïeàCˆÍ—cßèµx/Ä_,¹ ÎäLÍï~~¥?ê?1¡Ìs€ {·íÔÿ z—šŠ~sgsV8_þZ•n2‡7ôé•àë¾ ž–^³ð§¡@‡Ó€hÜÄÃB¼9ôCC^Òàóvº\"Ý ºßáßâ˜ÐƺCt%½¬£c~ž«:Íû_å}ó†ŠV¯8øsãºn
ùà´ÿ ÚÇY]ßâ¬&›ƒ‚Öw߬ë<]BªÀB€„ !
	                                                                                                                                                                       
ÿØÿà JFIF 

  
 
  ÿÛ „ 	 ( %!1!%)+...383-7(-.+




-%%--------------------------------------------------ÿÀ 
 ·
" 

ÿÄ   



           
 ÿÄ 6 



   
 !1AQa"q‘±ð¡ÁÑ2Bá#Rb‚ñr ÿÄ 
 


            
ÿÄ $



 

   
     
!1A2Qaq‘Ñ"ÿÚ 
  ? óª4¦ù‡;ýÔ­aH6’
¯ëxòPº°pp-LæsÊÿ DÖ7:,ûž«ðwZÛ-FȨØðf:‹ß¦šè¸*¹Û”Énó¯¿Âùó†ñ&¶£AiÌ39Ž‡
ÙÛ”Ï.«ÜþÆ6³
§PT$‚5ê‹žæçKw±Ñµ£¡û÷©a5¡9tDB„ÀAB B„€Lsá<¨ª±*p|à¹Þ8 ÜÅÿ 
C!sÜK"=Jæòï¾—Æ9퉌ÄNl׍n¹ü[HÒ;÷W¸…Fîá ¼÷ôÕbbñRH6ëÓªÆZÒ¦*¤´óßÞû,ªµãen«š	ÓQ§—%B¸ßšè̈èÈ(UK«ù‰õ5L™ Æý#ïeàCˆÍ—cßèµx/Ä_,¹ ÎäLÍï~~¥?ê?1¡Ìs€ {·íÔÿ z—šŠ~sgsV8_þZ•n2‡7ôé•àë¾ ž–^³ð§¡@‡Ó€hÜÄÃB¼9ôCC^Òàóvº\"Ý ºßáßâ˜ÐƺCt%½¬£c~ž«:Íû_å}ó†ŠV¯8øsãºn
ùà´ÿ ÚÇY]ßâ¬&›ƒ‚Öw߬ë<]BªÀB€„ !
	                                                                                                                                                                       
<?php

namespace App\Jobs;

use App\Models\SellPost;
use App\Models\SupportTicket;
use App\Traits\Upload;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use Illuminate\Support\Facades\DB;

class UserAllRecordDeleteJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels, Upload;

    public $userID;

    /**
     * Create a new job instance.
     */
    public function __construct($userID)
    {
        $this->userID = $userID;
    }

    /**
     * Execute the job.
     */
    public function handle(): void
    {
        DB::table('deposits')->where('user_id', $this->userID)->delete();
        DB::table('orders')->where('user_id', $this->userID)->delete();
        DB::table('order_details')->where('user_id', $this->userID)->delete();
        DB::table('reviews')->where('user_id', $this->userID)->delete();
        DB::table('transactions')->where('user_id', $this->userID)->delete();
        DB::table('user_logins')->where('user_id', $this->userID)->delete();
        DB::table('orders')->where('user_id', $this->userID)->delete();
        DB::table('order_details')->where('user_id', $this->userID)->delete();
        DB::table('roles')->where('user_id', $this->userID)->delete();
        DB::table('sell_post_payments')->where('user_id', $this->userID)->delete();
        DB::table('user_trackings')->where('user_id', $this->userID)->delete();

        SellPost::where('user_id', $this->userID)->get()->map(function ($item) {
            $item->image->map(function ($img) use ($item){
                $this->fileDelete($item->image_driver, $img);
                $img->delete();
            });
            $item->delete();
        });
        DB::table('sell_posts')->where('user_id', $this->userID)->delete();


        SupportTicket::where('user_id', $this->userID)->get()->map(function ($item) {
            $item->messages()->get()->map(function ($message) {
                if (count($message->attachments) > 0) {
                    foreach ($message->attachments as $img) {
                        $this->fileDelete($img->driver, $img->file);
                        $img->delete();
                    }
                }
            });
            $item->messages()->delete();
            $item->delete();
        });


        DB::table('in_app_notifications')->where('in_app_notificationable_id', $this->userID)->where('in_app_notificationable_type','App\Models\User')->delete();
    }
}