date('Y-m-d H:i:s', strtotime('+6 hours', strtotime(date('Y-m-d H:i:s')))) , date('d-m-Y h:i:s a', strtotime( $val['created_at'] )) ; throw new \Exception('Access Denied') ; $bsns_id = $user_details->bussiness_id ; throw new \Exception("ER0011 :: Download path not provided"); Issue for fetching the size of the disk used we are not excuded the deleted folder as : $result = FileDocumentModel::selectRaw('SUM(size_1)')->whereNull('deleted_at')->first(); // if folder delt // if section delt few queries select * from documents order by id desc limit 100 ; select * from folder_directory order by id desc limit 100 ; update folder_directory set deleted_at = null where id >147 ; -- troubled data start select * from documents where size_1 = 0 or path=0 or path = null order by id desc; select * from documents where size_1 = 0 or path = null order by id desc; select id, size_1, path, name from documents where size_1 = 0 or path = 0 order by id desc; select id, size_1, path, name from documents where size_1 = 0 order by id desc; -- troubled data end SELECT users.id as uid, users.bussiness_id, bussiness.id as bid, users.is_email_verify, bussiness.created_at as u_created_at, users.name, users.email, users.phone, users.email_verified_at, users.role_id, users.created_at as u_created_at, bussiness.company_name, bussiness.current_plan, bussiness.plan_expired_on FROM `bussiness` left join users on users.bussiness_id = bussiness.id order by bussiness.created_at desc ;