Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
CRAP | |
0.00% |
0 / 14 |
| BirthdayUsersController | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 14 |
| index | |
0.00% |
0 / 1 |
12 | |
0.00% |
0 / 14 |
|||
| <?php | |
| namespace App\Http\Controllers\Api; | |
| use App\Http\Controllers\Controller; | |
| use Illuminate\Http\Request; | |
| use Illuminate\Support\Facades\Auth; | |
| use Carbon\Carbon; | |
| use App\Models\Auth\User; | |
| class BirthdayUsersController extends Controller { | |
| public function index() { | |
| $users = User::all(); | |
| $currentDate = Carbon::now()->format('m-d'); | |
| $birthday_users = User::join('user_details', 'users.id', '=', 'user_details.user_id') | |
| ->whereRaw('DATE_FORMAT(dob, "%m-%d") = ?', [$currentDate]) | |
| ->get(); | |
| if(!empty($birthday_users)) { | |
| foreach($birthday_users as $birthday_user) { | |
| $message = $birthday_user->name . ' ' . $birthday_user->lastName . "'s birthday today! "; | |
| $arr[]= $message; | |
| } | |
| return response()->json([ | |
| 'status' => '200', | |
| 'message' => $arr | |
| ]); | |
| } else { | |
| return response()->json([ | |
| 'status' => '200', | |
| 'message' => [] | |
| ]); | |
| } | |
| } | |
| } |