Fix Download LOG

.env.example

@@ -15,6 +15,13 @@ DB_DATABASE=laravel
 DB_USERNAME=root
 DB_PASSWORD=
 
+OLDLMS_DB_CONNECTION=mysql
+OLDLMS_DB_HOST=127.0.0.1
+OLDLMS_DB_PORT=3306
+OLDLMS_DB_DATABASE=linksehat
+OLDLMS_DB_USERNAME=mysql
+OLDLMS_DB_PASSWORD=password
+
 BROADCAST_DRIVER=log
 CACHE_DRIVER=file
 FILESYSTEM_DISK=local

Modules/Client/Http/Controllers/Api/AuthController.php

@@ -35,13 +35,13 @@ class AuthController extends Controller
         if (filter_var($request->phoneOrEmail, FILTER_VALIDATE_EMAIL)) {
             User::query()->find($user->id)->update([
                 'email' => $request->phoneOrEmail,
-                'otp' => rand(1000, 9999),
+                'otp' => 4444, //rand(1000, 9999),
                 'otp_created_at' => now()
             ]);
         } else {
             User::query()->find($user->id)->update([
                 'phone' => $request->phoneOrEmail,
-                'otp' => rand(1000, 9999),
+                'otp' => 4444,//rand(1000, 9999),
                 'otp_created_at' => now()
             ]);
         }
@@ -81,7 +81,7 @@ class AuthController extends Controller
             );
         }
 
-        return Helper::responseJson(message: 'OTP yang anda masukan salah!');
+        return Helper::responseJson(status: 'error', message: 'OTP yang anda masukan salah!');
     }
 
     public function logout(Request $request)

Modules/Client/Http/Controllers/Api/ClaimReportController.php

@@ -0,0 +1,63 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use Illuminate\Http\Request;
+use App\Http\Controllers\Controller;
+
+class ClaimReportController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     *
+     * @return \Illuminate\Http\Response
+     */
+    public function index()
+    {
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return \Illuminate\Http\Response
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     *
+     * @param  int  $id
+     * @return \Illuminate\Http\Response
+     */
+    public function show($id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @param  int  $id
+     * @return \Illuminate\Http\Response
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     *
+     * @param  int  $id
+     * @return \Illuminate\Http\Response
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Client/Http/Controllers/Api/CorporateDivisionController.php

@@ -0,0 +1,116 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use App\Models\CorporateDivision;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Validation\Rule;
+
+class CorporateDivisionController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request, $corporate_id)
+    {
+        $division = CorporateDivision::query()
+            ->where('corporate_id', $corporate_id)
+            ->get(['id', 'name']);
+
+        return response()->json($division);
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request, $corporate_id)
+    {
+        $request->validate([
+            'code' => [
+                'required',
+            ],
+            'name' => 'required'
+        ]);
+
+        $newCorporatePlan = CorporateDivision::create([
+            'corporate_id' => $corporate_id,
+            'code' => $request->code,
+            'name' => $request->name,
+        ]);
+
+        return $newCorporatePlan;
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($corporate_id, $id)
+    {
+        $corporatePlan = CorporateDivision::findOrFail($id);
+
+        return $corporatePlan;
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $corporate_id, $id)
+    {
+        $corporatePlan = CorporateDivision::findOrFail($id);
+        $request->validate([
+            'code' => [
+                'required',
+                Rule::unique('corporate_plans')->where('corporate_id', $corporate_id)->ignore($corporatePlan->id)
+            ],
+            'name' => 'required'
+        ]);
+
+        $corporatePlan->fill([
+            'code' => $request->code,
+            'name' => $request->name,
+            'active' => $request->active,
+        ])->save();
+
+        return $corporatePlan;
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Client/Http/Controllers/Api/CorporateManageController.php

@@ -0,0 +1,73 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\Auth;
+
+class CorporateManageController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        $userLogin = Auth::user();
+        $corporate = $userLogin->managedCorporates()->select(['corporates.id', 'corporates.name'])->get();
+
+        return response()->json($corporate);
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($corporate_id)
+    {
+        //
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('client::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Client/Http/Controllers/Api/CorporateMemberController.php

@@ -0,0 +1,112 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\Member;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Modules\Client\Transformers\MemberResources;
+
+class CorporateMemberController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request, $corporate_id)
+    {
+        $limit = $request->has('per_page') ? $request->per_page : 10;
+
+        $members = Member::query()
+            ->whereHas('employeds', function ($corporateEmployee) use ($corporate_id) {
+                $corporateEmployee->where('corporate_id', $corporate_id);
+            })->when($request->input('search'), function ($query, $search) {
+                $query->where('member_id', 'like', "%" . $search . "%")
+                    ->orWhere('name', 'like', "%" . $search . "%");
+            });
+
+        if ($request->input('claimMember') === 'false') {
+            $members = $members->when($request->input('division'), function ($division, $division_id) {
+                $division->whereHas('division', function ($corporateEmployee) use ($division_id) {
+                    $corporateEmployee->where('division_id', $division_id);
+                });
+            })->when($request->has('orderBy'), function ($query) use ($request) {
+                $query->orderBy($request->orderBy, $request->order);
+            });
+        }
+        //  else {
+        //     $members = $members->get();
+
+        //     return response()->json(MemberResources::collection($members));
+        // }
+        $members->with('currentPlan');
+        $members->withSum('claims', 'total_claim');
+
+        $members = $members->paginate($limit);
+        // return $members;
+        
+        return response()->json(Helper::paginateResources(MemberResources::collection($members)));
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('client::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('client::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('client::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Client/Http/Controllers/Api/CorporatePolicyController.php

@@ -5,25 +5,25 @@ namespace Modules\Client\Http\Controllers\Api;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\Auth;
+use Modules\Client\Transformers\DashboardResources;
 
-class DashboardController extends Controller
+class CorporatePolicyController extends Controller
 {
     /**
      * Display a listing of the resource.
      * @return Renderable
      */
-    public function index()
+    public function index(Request $request, $corporate_id)
     {
-        $user = auth()->user();
+        $user = Auth::user();
+        $currentCorporate = $user->managedCorporates()
+            ->with(['currentPolicy', 'employees'])
+            ->find($corporate_id);
 
-        $corporate = $user->managedCorporates()
-                        ->withCount('employees')
-                        ->with(['policies' => function ($policy) {
-                            $policy->limit(1)->latest();
-                        }])
-                        ->first();
+        $data = DashboardResources::make($currentCorporate);
 
-        return response()->json(compact('corporate'));
+        return response()->json($data);
     }
 
     /**

Modules/Client/Http/Controllers/Api/UserController.php

@@ -5,6 +5,7 @@ namespace Modules\Client\Http\Controllers\Api;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\Auth;
 
 class UserController extends Controller
 {
@@ -14,7 +15,10 @@ class UserController extends Controller
      */
     public function index()
     {
-        return response()->json(auth()->user());
+        $userLogin = Auth::user();
+        $corporateSelected = $userLogin->managedCorporates()->select('corporates.id')->where('active', 1)->first();
+
+        return response()->json(['user' => $userLogin, 'corporate' => $corporateSelected]);
     }
 
     /**

Modules/Client/Routes/api.php

@@ -1,8 +1,10 @@
 <?php
 
 use Modules\Client\Http\Controllers\Api\AuthController;
-use Modules\Client\Http\Controllers\Api\DashboardController;
-use Modules\Client\Http\Controllers\Api\MemberController;
+use Modules\Client\Http\Controllers\Api\CorporateDivisionController;
+use Modules\Client\Http\Controllers\Api\CorporateManageController;
+use Modules\Client\Http\Controllers\Api\CorporateMemberController;
+use Modules\Client\Http\Controllers\Api\CorporatePolicyController;
 use Modules\Client\Http\Controllers\Api\UserController;
 
 /*
@@ -24,11 +26,14 @@ Route::prefix('client')->group(function () {
     });
 
     Route::middleware('auth:sanctum')->group(function () {
-
         Route::post('logout', [AuthController::class, 'logout'])->name('logout');
-        Route::get('/user', [UserController::class, 'index']);
+        Route::get('user', [UserController::class, 'index']);
 
-        Route::get('dashboard', [DashboardController::class, 'index']);
-        Route::get('members', [MemberController::class, 'index']);
+        Route::get('corporate-manage', [CorporateManageController::class, 'index']);
+        Route::prefix('{corporate_id}')->group(function () {
+            Route::get('policy', [CorporatePolicyController::class, 'index']);
+            Route::get('division', [CorporateDivisionController::class, 'index']);
+            Route::get('members', [CorporateMemberController::class, 'index']);
+        });
     });
 });

Modules/Client/Transformers/DashboardResources.php

@@ -0,0 +1,38 @@
+<?php
+
+namespace Modules\Client\Transformers;
+
+use App\Helpers\Helper;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class DashboardResources extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array|\Illuminate\Contracts\Support\Arrayable|\JsonSerializable
+     */
+    public function toArray($request)
+    {
+        $myLimitBalance = (int)$this->currentPolicy->limit_balance;
+        $myLimitTotal = (int)$this->currentPolicy->total_premi;
+
+        $lockBalance = (int)$this->currentPolicy->minimal_stop_service_net;
+        $lockPercentage = (int)$this->currentPolicy->minimal_stop_service_percentage;
+
+        return [
+            'policy' => [
+                'myLimit' => [
+                    'balance' => $myLimitBalance,
+                    'total' => $myLimitTotal,
+                    'percentage' => $myLimitTotal ? (($myLimitBalance / $myLimitTotal) * 100) : 0,
+                ],
+                'lockLimit' => [
+                    'balance' => $lockBalance,
+                    'percentage' => $lockPercentage
+                ]
+            ],
+        ];
+    }
+}

Modules/Client/Transformers/MemberResources.php

@@ -0,0 +1,32 @@
+<?php
+
+namespace Modules\Client\Transformers;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MemberResources extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array|\Illuminate\Contracts\Support\Arrayable|\JsonSerializable
+     */
+    public function toArray($request)
+    {
+        return [
+            'id' => $this->id,
+            'memberId' => $this->member_id,
+            'fullName' => $this->full_name,
+            $this->mergeWhen($request->input('claimMember') === 'false', [
+                'division' => $this->division->name ?? '',
+                'status' => $this->active
+            ]),
+            'limit' => [
+                'current' => $this->claims_sum_total_claim,
+                'total' => $this->currentPlan->limit_rules ?? 0,
+                'percentage' => (!empty($this->currentPlan->limit_rules ?? 0)) ? (($this->claims_sum_total_claim / $this->currentPlan->limit_rules) * 100) : 0
+            ],
+        ];
+    }
+}

Modules/HospitalPortal/Config/config.php

@@ -0,0 +1,5 @@
+<?php
+
+return [
+    'name' => 'HospitalPortal'
+];

Modules/HospitalPortal/Database/Seeders/HospitalPortalDatabaseSeeder.php

@@ -0,0 +1,21 @@
+<?php
+
+namespace Modules\HospitalPortal\Database\Seeders;
+
+use Illuminate\Database\Seeder;
+use Illuminate\Database\Eloquent\Model;
+
+class HospitalPortalDatabaseSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        Model::unguard();
+
+        // $this->call("OthersTableSeeder");
+    }
+}

Modules/HospitalPortal/Http/Controllers/Api/AuthController.php

@@ -0,0 +1,128 @@
+<?php
+
+namespace Modules\HospitalPortal\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Models\User;
+use Crypt;
+use Error;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Facades\Hash;
+use Illuminate\Support\Facades\Mail;
+use Modules\Internal\Emails\SendVerifyEmail;
+use Modules\Internal\Events\ForgetPassword;
+
+class AuthController extends Controller
+{
+    public function login(Request $request)
+    {
+        $request->validate([
+            'email' => 'required|email',
+            'password' => 'required'
+        ]);
+
+        $user = User::query()
+            ->where('email', $request->email)
+            ->first();
+
+        if (!$user) {
+            return response(['message' => 'User Tidak Ditemukan'], 404);
+        }
+
+        if (!Hash::check($request->password, $user->password)) {
+            return response(['message' => 'Password Salah'], 403);
+        }
+
+        return response([
+            'message' => 'Selamat Datang',
+            'user' => $user,
+            'token' => $user->createToken('app')->plainTextToken
+        ]);
+    }
+
+    public function logout(Request $request)
+    {
+        $token = $request->bearerToken();
+        Auth::user()->tokens()->where('id', $token)->delete();
+
+        return response(['message' => 'Berhasil Logout.']);
+    }
+
+    public function resetPassword(Request $request)
+    {
+        $user = Auth::user();
+
+        $request->validate([
+            'old_password' => 'required',
+            'new_password' => 'required',
+            'confirm_new_password' => 'required'
+        ]);
+
+        if (!Hash::check($request['old_password'], $user->password)) {
+            return response(['message' => 'Password Salah'], 403);
+        }
+
+        if ($request["new_password"] != $request["confirm_new_password"]) {
+            return response([
+                'message' => "Password Tidak Sama"
+            ]);
+        }
+
+        $user->update([
+            'password' => Hash::make($request->confirm_new_password),
+        ]);
+        return response()->json($user);
+    }
+
+    public function verifyEmail(Request $request)
+    {
+        $request->validate([
+            'email' => 'required|email',
+        ]);
+
+        $user = User::query()
+            ->where('email', $request->email)
+            ->first();
+
+        if (!$user) {
+            return response(['message' => 'User Tidak Ditemukan'], 404);
+        }
+
+        Event(new ForgetPassword($user));
+
+        // Mail::to($user->email)->send(new SendVerifyEmail($user));
+
+        return response()->json($user);
+    }
+
+    public function forgetPassword(Request $request)
+    {
+        $request->validate([
+            'new_password' => 'required',
+            'confirm_new_password' => 'required'
+        ]);
+
+        $token = Crypt::decryptString($request->token);
+        $email = explode('|', $token)[0];
+
+        $user = User::query()
+            ->where('email', $email)
+            ->first();
+
+        if (!$user) {
+            return response(['message' => 'User Tidak Ditemukan'], 404);
+        }
+
+        if ($request["new_password"] != $request["confirm_new_password"]) {
+            return response([
+                'message' => "Password Tidak Sama"
+            ], 404);
+        }
+
+        $user->update([
+            'password' => Hash::make($request->confirm_new_password),
+        ]);
+        return response()->json($user);
+    }
+}

Modules/HospitalPortal/Http/Controllers/Api/ClaimRequestController.php

@@ -0,0 +1,145 @@
+<?php
+
+namespace Modules\HospitalPortal\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\ClaimRequest;
+use App\Models\File;
+use App\Models\Member;
+use Exception;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use PDF;
+
+class ClaimRequestController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(request $request)
+    {
+        $claimRequests = ClaimRequest::query()
+                                ->when($request->search, function ($q, $search) {
+                                    $q->where('code', 'LIKE', "%".$search."%");
+                                })
+                                ->when($request->orderBy, function ($q, $orderBy) use ($request) {
+                                    if (in_array($orderBy, ['submission_date', 'code'])) {
+                                        $q->orderBy($orderBy, $request->order);
+                                    }
+                                })
+                                ->when($request->status, function($q, $status) {
+                                    $q->where('status', $status);
+                                })
+                                ->with(['member'])
+                                ->paginate();
+
+        return Helper::responseJson($claimRequests);
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('hospitalportal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        $request->validate([
+            // 'submission_date' => 'required',
+            'member_id' => 'required',
+            // 'files' => ''
+        ]);
+
+        $newClaimRequest = ClaimRequest::create([
+            'member_id' => $request->member_id,
+            'submission_date' => now(),
+            'status' => 'requested'
+        ]);
+
+        if ($request->hasFile('result_files')) {
+            foreach ($request->result_files as $file) {
+                $pathFile = File::storeFile('claim', $newClaimRequest->id, $file);
+                $newClaimRequest->files()->updateOrCreate([
+                    'type' => 'result',
+                    'name' => File::getFileName('claim', $newClaimRequest->id, $file),
+                    'original_name' => $file->getClientOriginalName(),
+                    'extension' => $file->getClientOriginalExtension(),
+                    'path' => $pathFile,
+                    'created_by' => auth()->user()->id,
+                    'updated_by' => auth()->user()->id,
+                ]);
+            }
+        }
+        return ($request->result_files[0]->getClientOriginalName());
+
+        return Helper::responseJson(data: $request->toArray(), message: 'Claim Request berhasil ajukan!');
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('hospitalportal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('hospitalportal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+
+    public function generateLog($claim_request_id)
+    {
+        $claimRequest = ClaimRequest::findOrFail($claim_request_id);
+
+        if ($claimRequest->status != 'approved') {
+            throw new Exception("Belum Teverifikasi", 1);
+        }
+
+        $member = Member::findOrFail($claimRequest->member_id)
+                ->load(['currentPlan', 'currentPolicy', 'currentPlan.corporateBenefits', 'currentPlan.corporateBenefits.benefit']);
+
+        $pdf = PDF::loadView('pdf.guaranted_leter', compact('member', 'claimRequest'));
+        return $pdf->download('Guaranted Letter - '.$member->full_name.'.pdf');
+        
+        return $claimRequest;
+    }
+}

Modules/HospitalPortal/Http/Controllers/Api/MemberController.php

@@ -0,0 +1,41 @@
+<?php
+
+namespace Modules\HospitalPortal\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\Member;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+
+class MemberController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function search(Request $request)
+    {
+        $request->validate([
+            'no_polis' => 'required',
+            'birth_date' => 'required'
+        ]);
+
+        $member = Member::query()
+                        ->where('member_id', $request->no_polis)
+                        ->where('birth_date', $request->birth_date)
+                        ->with(['person', 'currentCorporate', 
+                            // 'currentCorporate.corporateServices' => function ($corporateService) {
+                            //     $corporateService->where('status', 'active');
+                            // }, 
+                            // 'currentCorporate.corporateServices.service'
+                            // 'currentPlan.benefits',
+                            // 'currentPlan.corporateBenefit.plan',
+                            'currentPlan.corporateBenefits.benefit'
+                        ])
+                        ->firstOrFail();
+
+            
+        return Helper::responseJson($member);
+    }
+}

Modules/HospitalPortal/Http/Controllers/ClaimController.php

@@ -0,0 +1,83 @@
+<?php
+
+namespace Modules\HospitalPortal\Http\Controllers;
+
+use App\Helpers\Helper;
+use App\Models\Claim;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+
+class ClaimController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index()
+    {
+        $claims = Claim::where('deleted_at', 'ASD')->paginate(5);
+
+        return Helper::responseJson($claims);
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('hospitalportal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('hospitalportal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('hospitalportal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/HospitalPortal/Http/Controllers/HospitalPortalController.php

@@ -0,0 +1,79 @@
+<?php
+
+namespace Modules\HospitalPortal\Http\Controllers;
+
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+
+class HospitalPortalController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index()
+    {
+        return view('hospitalportal::index');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('hospitalportal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('hospitalportal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('hospitalportal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/HospitalPortal/Providers/HospitalPortalServiceProvider.php

@@ -0,0 +1,112 @@
+<?php
+
+namespace Modules\HospitalPortal\Providers;
+
+use Illuminate\Support\ServiceProvider;
+use Illuminate\Database\Eloquent\Factory;
+
+class HospitalPortalServiceProvider extends ServiceProvider
+{
+    /**
+     * @var string $moduleName
+     */
+    protected $moduleName = 'HospitalPortal';
+
+    /**
+     * @var string $moduleNameLower
+     */
+    protected $moduleNameLower = 'hospitalportal';
+
+    /**
+     * Boot the application events.
+     *
+     * @return void
+     */
+    public function boot()
+    {
+        $this->registerTranslations();
+        $this->registerConfig();
+        $this->registerViews();
+        $this->loadMigrationsFrom(module_path($this->moduleName, 'Database/Migrations'));
+    }
+
+    /**
+     * Register the service provider.
+     *
+     * @return void
+     */
+    public function register()
+    {
+        $this->app->register(RouteServiceProvider::class);
+    }
+
+    /**
+     * Register config.
+     *
+     * @return void
+     */
+    protected function registerConfig()
+    {
+        $this->publishes([
+            module_path($this->moduleName, 'Config/config.php') => config_path($this->moduleNameLower . '.php'),
+        ], 'config');
+        $this->mergeConfigFrom(
+            module_path($this->moduleName, 'Config/config.php'), $this->moduleNameLower
+        );
+    }
+
+    /**
+     * Register views.
+     *
+     * @return void
+     */
+    public function registerViews()
+    {
+        $viewPath = resource_path('views/modules/' . $this->moduleNameLower);
+
+        $sourcePath = module_path($this->moduleName, 'Resources/views');
+
+        $this->publishes([
+            $sourcePath => $viewPath
+        ], ['views', $this->moduleNameLower . '-module-views']);
+
+        $this->loadViewsFrom(array_merge($this->getPublishableViewPaths(), [$sourcePath]), $this->moduleNameLower);
+    }
+
+    /**
+     * Register translations.
+     *
+     * @return void
+     */
+    public function registerTranslations()
+    {
+        $langPath = resource_path('lang/modules/' . $this->moduleNameLower);
+
+        if (is_dir($langPath)) {
+            $this->loadTranslationsFrom($langPath, $this->moduleNameLower);
+        } else {
+            $this->loadTranslationsFrom(module_path($this->moduleName, 'Resources/lang'), $this->moduleNameLower);
+        }
+    }
+
+    /**
+     * Get the services provided by the provider.
+     *
+     * @return array
+     */
+    public function provides()
+    {
+        return [];
+    }
+
+    private function getPublishableViewPaths(): array
+    {
+        $paths = [];
+        foreach (\Config::get('view.paths') as $path) {
+            if (is_dir($path . '/modules/' . $this->moduleNameLower)) {
+                $paths[] = $path . '/modules/' . $this->moduleNameLower;
+            }
+        }
+        return $paths;
+    }
+}

Modules/HospitalPortal/Providers/RouteServiceProvider.php

@@ -0,0 +1,69 @@
+<?php
+
+namespace Modules\HospitalPortal\Providers;
+
+use Illuminate\Support\Facades\Route;
+use Illuminate\Foundation\Support\Providers\RouteServiceProvider as ServiceProvider;
+
+class RouteServiceProvider extends ServiceProvider
+{
+    /**
+     * The module namespace to assume when generating URLs to actions.
+     *
+     * @var string
+     */
+    protected $moduleNamespace = 'Modules\HospitalPortal\Http\Controllers';
+
+    /**
+     * Called before routes are registered.
+     *
+     * Register any model bindings or pattern based filters.
+     *
+     * @return void
+     */
+    public function boot()
+    {
+        parent::boot();
+    }
+
+    /**
+     * Define the routes for the application.
+     *
+     * @return void
+     */
+    public function map()
+    {
+        $this->mapApiRoutes();
+
+        $this->mapWebRoutes();
+    }
+
+    /**
+     * Define the "web" routes for the application.
+     *
+     * These routes all receive session state, CSRF protection, etc.
+     *
+     * @return void
+     */
+    protected function mapWebRoutes()
+    {
+        Route::middleware('web')
+            ->namespace($this->moduleNamespace)
+            ->group(module_path('HospitalPortal', '/Routes/web.php'));
+    }
+
+    /**
+     * Define the "api" routes for the application.
+     *
+     * These routes are typically stateless.
+     *
+     * @return void
+     */
+    protected function mapApiRoutes()
+    {
+        Route::prefix('api')
+            ->middleware('api')
+            ->namespace($this->moduleNamespace)
+            ->group(module_path('HospitalPortal', '/Routes/api.php'));
+    }
+}

Modules/HospitalPortal/Resources/views/index.blade.php

@@ -0,0 +1,9 @@
+@extends('hospitalportal::layouts.master')
+
+@section('content')
+    <h1>Hello World</h1>
+
+    <p>
+        This view is loaded from module: {!! config('hospitalportal.name') !!}
+    </p>
+@endsection

Modules/HospitalPortal/Resources/views/layouts/master.blade.php

@@ -0,0 +1,19 @@
+<!DOCTYPE html>
+<html lang="en">
+    <head>
+        <meta charset="utf-8">
+        <meta http-equiv="X-UA-Compatible" content="IE=edge">
+        <meta name="viewport" content="width=device-width, initial-scale=1">
+        <title>Module HospitalPortal</title>
+
+       {{-- Laravel Mix - CSS File --}}
+       {{-- <link rel="stylesheet" href="{{ mix('css/hospitalportal.css') }}"> --}}
+
+    </head>
+    <body>
+        @yield('content')
+
+        {{-- Laravel Mix - JS File --}}
+        {{-- <script src="{{ mix('js/hospitalportal.js') }}"></script> --}}
+    </body>
+</html>

Modules/HospitalPortal/Routes/api.php

@@ -0,0 +1,43 @@
+<?php
+
+use Illuminate\Http\Request;
+use Modules\HospitalPortal\Http\Controllers\Api\AuthController;
+use Modules\HospitalPortal\Http\Controllers\Api\ClaimRequestController;
+use Modules\HospitalPortal\Http\Controllers\Api\MemberController;
+use Modules\HospitalPortal\Http\Controllers\ClaimController;
+
+/*
+|--------------------------------------------------------------------------
+| API Routes
+|--------------------------------------------------------------------------
+|
+| Here is where you can register API routes for your application. These
+| routes are loaded by the RouteServiceProvider within a group which
+| is assigned the "api" middleware group. Enjoy building your API!
+|
+*/
+
+Route::prefix('hospitalportal')->group(function () {
+
+    Route::post('login', [AuthController::class, 'login'])->name('login');
+    Route::post('forget-password', [AuthController::class, 'forgetPassword'])->name('forget-password');
+    Route::post('verify-email', [AuthController::class, 'verifyEmail'])->name('verify-email');
+
+
+    Route::middleware('auth:sanctum')->group(function () {
+
+        Route::post('logout', [AuthController::class, 'logout'])->name('logout');
+        Route::get('/user', function (Request $request) {
+            return $request->user();
+        });
+        Route::put('reset-password', [AuthController::class, 'resetPassword'])->name('resetPassword');
+
+        Route::get('claims', [ClaimController::class, 'index']);
+
+        Route::post('search-member', [MemberController::class, 'search']);
+
+        Route::get('claim-requests', [ClaimRequestController::class, 'index'])->name('claim-requests.index');
+        Route::post('claim-requests', [ClaimRequestController::class, 'store'])->name('claim-requests.store');
+        Route::get('claim-requests/{claim_request_id}/log', [ClaimRequestController::class, 'generateLog'])->name('claim-requests.generate-log');
+    });
+});

Modules/HospitalPortal/Routes/web.php

@@ -0,0 +1,16 @@
+<?php
+
+/*
+|--------------------------------------------------------------------------
+| Web Routes
+|--------------------------------------------------------------------------
+|
+| Here is where you can register web routes for your application. These
+| routes are loaded by the RouteServiceProvider within a group which
+| contains the "web" middleware group. Now create something great!
+|
+*/
+
+Route::prefix('hospitalportal')->group(function() {
+    Route::get('/', 'HospitalPortalController@index');
+});

Modules/HospitalPortal/composer.json

@@ -0,0 +1,23 @@
+{
+    "name": "nwidart/hospitalportal",
+    "description": "",
+    "authors": [
+        {
+            "name": "Nicolas Widart",
+            "email": "n.widart@gmail.com"
+        }
+    ],
+    "extra": {
+        "laravel": {
+            "providers": [],
+            "aliases": {
+
+            }
+        }
+    },
+    "autoload": {
+        "psr-4": {
+            "Modules\\HospitalPortal\\": ""
+        }
+    }
+}

Modules/HospitalPortal/module.json

@@ -0,0 +1,13 @@
+{
+    "name": "HospitalPortal",
+    "alias": "hospitalportal",
+    "description": "",
+    "keywords": [],
+    "priority": 0,
+    "providers": [
+        "Modules\\HospitalPortal\\Providers\\HospitalPortalServiceProvider"
+    ],
+    "aliases": {},
+    "files": [],
+    "requires": []
+}

Modules/HospitalPortal/package.json

@@ -0,0 +1,21 @@
+{
+  "private": true,
+  "scripts": {
+    "dev": "npm run development",
+    "development": "mix",
+    "watch": "mix watch",
+    "watch-poll": "mix watch -- --watch-options-poll=1000",
+    "hot": "mix watch --hot",
+    "prod": "npm run production",
+    "production": "mix --production"
+  },
+  "devDependencies": {
+    "axios": "^0.21.4",
+    "dotenv": "^10.0.0",
+    "dotenv-expand": "^5.1.0",
+    "laravel-mix": "^6.0.31",
+    "laravel-mix-merge-manifest": "^2.0.0",
+    "lodash": "^4.17.21",
+    "postcss": "^8.3.7"
+  }
+}

Modules/HospitalPortal/webpack.mix.js

@@ -0,0 +1,14 @@
+const dotenvExpand = require('dotenv-expand');
+dotenvExpand(require('dotenv').config({ path: '../../.env'/*, debug: true*/}));
+
+const mix = require('laravel-mix');
+require('laravel-mix-merge-manifest');
+
+mix.setPublicPath('../../public').mergeManifest();
+
+mix.js(__dirname + '/Resources/assets/js/app.js', 'js/hospitalportal.js')
+    .sass( __dirname + '/Resources/assets/sass/app.scss', 'css/hospitalportal.css');
+
+if (mix.inProduction()) {
+    mix.version();
+}

Modules/Internal/Emails/SendVerifyEmail.php

@@ -0,0 +1,37 @@
+<?php
+
+namespace Modules\Internal\Emails;
+
+use Illuminate\Bus\Queueable;
+use Illuminate\Mail\Mailable;
+use Illuminate\Queue\SerializesModels;
+use Illuminate\Contracts\Queue\ShouldQueue;
+
+class SendVerifyEmail extends Mailable
+{
+    use Queueable, SerializesModels;
+    public $data;
+
+    /**
+     * Create a new message instance.
+     *
+     * @return void
+     */
+    public function __construct($data)
+    {
+        $this->data = $data;
+    }
+
+    /**
+     * Build the message.
+     *
+     * @return $this
+     */
+    public function build()
+    {
+        $this->subject('Verify Email')
+            ->markdown('verify_email');
+
+        return $this;
+    }
+}

Modules/Internal/Events/ForgetPassword.php

@@ -0,0 +1,33 @@
+<?php
+
+namespace Modules\Internal\Events;
+
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ForgetPassword
+{
+    use Dispatchable, SerializesModels;
+    
+    public $data;
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct($data)
+    {
+        $this->data = $data;
+    }
+
+    /**
+     * Get the channels the event should be broadcast on.
+     *
+     * @return array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

Modules/Internal/Http/Controllers/Api/AuthController.php

@@ -4,9 +4,14 @@ namespace Modules\Internal\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
 use App\Models\User;
+use Crypt;
+use Error;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\Auth;
 use Illuminate\Support\Facades\Hash;
+use Illuminate\Support\Facades\Mail;
+use Modules\Internal\Emails\SendVerifyEmail;
+use Modules\Internal\Events\ForgetPassword;
 
 class AuthController extends Controller
 {
@@ -18,8 +23,8 @@ class AuthController extends Controller
         ]);
 
         $user = User::query()
-                ->where('email', $request->email)
-                ->first();
+            ->where('email', $request->email)
+            ->first();
 
         if (!$user) {
             return response(['message' => 'User Tidak Ditemukan'], 404);
@@ -43,4 +48,81 @@ class AuthController extends Controller
 
         return response(['message' => 'Berhasil Logout.']);
     }
+
+    public function resetPassword(Request $request)
+    {
+        $user = Auth::user();
+
+        $request->validate([
+            'old_password' => 'required',
+            'new_password' => 'required',
+            'confirm_new_password' => 'required'
+        ]);
+
+        if (!Hash::check($request['old_password'], $user->password)) {
+            return response(['message' => 'Password Salah'], 403);
+        }
+
+        if ($request["new_password"] != $request["confirm_new_password"]) {
+            return response([
+                'message' => "Password Tidak Sama"
+            ]);
+        }
+
+        $user->update([
+            'password' => Hash::make($request->confirm_new_password),
+        ]);
+        return response()->json($user);
+    }
+
+    public function verifyEmail(Request $request)
+    {
+        $request->validate([
+            'email' => 'required|email',
+        ]);
+
+        $user = User::query()
+            ->where('email', $request->email)
+            ->first();
+
+        if (!$user) {
+            return response(['message' => 'User Tidak Ditemukan'], 404);
+        }
+
+        Event(new ForgetPassword($user));
+
+        // Mail::to($user->email)->send(new SendVerifyEmail($user));
+
+        return response()->json($user);
+    }
+
+    public function forgetPassword(Request $request)
+    {
+        $request->validate([
+            'new_password' => 'required',
+            'confirm_new_password' => 'required'
+        ]);
+
+        $token = Crypt::decryptString($request->token);
+        $email = explode('|', $token)[0];
+
+        $user = User::query()
+            ->where('email', $email)
+            ->first();
+
+        if (!$user) {
+            return response(['message' => 'User Tidak Ditemukan'], 404);
+        }
+
+        if ($request["new_password"] != $request["confirm_new_password"]) {
+            return response([
+                'message' => "Password Tidak Sama"
+            ], 404);
+        }
+
+        $user->update([
+            'password' => Hash::make($request->confirm_new_password),
+        ]);
+        return response()->json($user);
+    }
 }

Modules/Internal/Http/Controllers/Api/BenefitController.php

@@ -3,6 +3,7 @@
 namespace Modules\Internal\Http\Controllers\Api;
 
 use App\Models\Benefit;
+use App\Models\CorporateBenefit;
 use App\Models\MemberBenefit;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
@@ -18,12 +19,13 @@ class BenefitController extends Controller
      */
     public function index(Request $request, $corporate_id)
     {
-        $benefits = Benefit::query()
-                    ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
-                    ->paginate()
-                    ->appends($request->all());
-        
+        $benefits = CorporateBenefit::query()
+            ->filter($request->all())
+            ->where('corporate_id', $corporate_id)
+            ->with('benefit', 'plan')
+            ->paginate()
+            ->appends($request->all());
+
         return $benefits;
     }
 
@@ -89,59 +91,59 @@ class BenefitController extends Controller
 
     public function memberBenefitImport(Request $request, $corporate_id)
     {
-        $request->validate([
-            'file' => 'required|file|mimes:xls,xlsx,csv,txt',
-        ]); 
-        $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
-        $file = $request->file('file')->storeAs('temp', $file_name);
+        // $request->validate([
+        //     'file' => 'required|file|mimes:xls,xlsx,csv,txt',
+        // ]); 
+        // $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
+        // $file = $request->file('file')->storeAs('temp', $file_name);
 
-        $reader = ReaderEntityFactory::createReaderFromFile(Storage::path('temp/'.$file_name));
-        $reader->open(Storage::path('temp/'.$file_name));
+        // $reader = ReaderEntityFactory::createReaderFromFile(Storage::path('temp/'.$file_name));
+        // $reader->open(Storage::path('temp/'.$file_name));
 
-        $headers_map_to_table_fields = Benefit::$doc_headers_to_field_map;
+        // $headers_map_to_table_fields = Benefit::$doc_headers_to_field_map;
 
-        $imported_benefit_data = 0;
-        $failed_benefit_data = [];
-        foreach ($reader->getSheetIterator() as $sheet) {
-            $doc_headers_indexes = [];
-            foreach ($sheet->getRowIterator() as $index => $row) {
-                if ($index == 1) { // First Row Must be Header
-                    foreach ($row->getCells() as $index => $cell) {
-                        $doc_headers_indexes[$index] = rtrim($cell->getValue());
-                    }
-                } else { // Next Row Should be Data
-                    $new_benefit_data = [];
-                    foreach ($row->getCells() as $index => $cell) {
-                        $new_benefit_data[$headers_map_to_table_fields[$doc_headers_indexes[$index]]] = $cell->getValue();
-                    }
+        // $imported_benefit_data = 0;
+        // $failed_benefit_data = [];
+        // foreach ($reader->getSheetIterator() as $sheet) {
+        //     $doc_headers_indexes = [];
+        //     foreach ($sheet->getRowIterator() as $index => $row) {
+        //         if ($index == 1) { // First Row Must be Header
+        //             foreach ($row->getCells() as $index => $cell) {
+        //                 $doc_headers_indexes[$index] = rtrim($cell->getValue());
+        //             }
+        //         } else { // Next Row Should be Data
+        //             $new_benefit_data = [];
+        //             foreach ($row->getCells() as $index => $cell) {
+        //                 $new_benefit_data[$headers_map_to_table_fields[$doc_headers_indexes[$index]]] = $cell->getValue();
+        //             }
 
-                    // $imported_plan_data[] = $new_row; // Insert to Array
-                    // Create Directly
-                    $new_benefit_data['corporate_id'] = $corporate_id;
-                    try {
-                        Benefit::updateOrCreate([
-                            'corporate_id' => $corporate_id,
-                            'code' => $new_benefit_data['code']
-                        ], $new_benefit_data);
+        //             // $imported_plan_data[] = $new_row; // Insert to Array
+        //             // Create Directly
+        //             $new_benefit_data['corporate_id'] = $corporate_id;
+        //             try {
+        //                 Benefit::updateOrCreate([
+        //                     'corporate_id' => $corporate_id,
+        //                     'code' => $new_benefit_data['code']
+        //                 ], $new_benefit_data);
 
-                        $imported_benefit_data++;
-                    } catch(\Exception $e) {
-                        $new_benefit_data['error'] = $e->getMessage();
-                        $failed_benefit_data[] = $new_benefit_data;
-                    }
-                }
-            }
-            
-            break; //only read first sheet
-        }
-        $reader->close();
-        Storage::delete('temp/'.$file_name);
-        // throw(404);
+        //                 $imported_benefit_data++;
+        //             } catch(\Exception $e) {
+        //                 $new_benefit_data['error'] = $e->getMessage();
+        //                 $failed_benefit_data[] = $new_benefit_data;
+        //             }
+        //         }
+        //     }
 
-        return [
-            'total_successed_row' => $imported_benefit_data,
-            'total_failed_row' => count($failed_benefit_data),
-            'failed_row' => $failed_benefit_data
-        ];
+        //     break; //only read first sheet
+        // }
+        // $reader->close();
+        // Storage::delete('temp/'.$file_name);
+        // // throw(404);
+
+        // return [
+        //     'total_successed_row' => $imported_benefit_data,
+        //     'total_failed_row' => count($failed_benefit_data),
+        //     'failed_row' => $failed_benefit_data
+        // ];
     }
 }

Modules/Internal/Http/Controllers/Api/ClaimRequestController.php

@@ -0,0 +1,113 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\ClaimRequest;
+use App\Models\Member;
+use Exception;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Knp\Snappy\Pdf;
+use Modules\Internal\Transformers\ClaimRequestResource;
+
+class ClaimRequestController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        $claimRequests = ClaimRequest::query()
+                                ->when($request->search, function ($q, $search) {
+                                    $q->where('code', 'LIKE', "%".$search."%");
+                                })
+                                ->when($request->orderBy, function ($q, $orderBy) use ($request) {
+                                    if (in_array($orderBy, ['submission_date', 'code'])) {
+                                        $q->orderBy($orderBy, $request->order);
+                                    }
+                                })
+                                ->when(empty($request->orderBy), function ($q) {
+                                    $q->orderBy('created_at', 'desc');
+                                })
+                                ->when($request->status, function($q, $status) {
+                                    $q->where('status', $status);
+                                })
+                                ->with(['member', 'files'])
+                                ->paginate();
+
+        return Helper::paginateResources(ClaimRequestResource::collection($claimRequests));
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+
+    public function approve($id)
+    {
+        $claimRequest = ClaimRequest::findOrFail($id);
+
+        $claimRequest->status = 'approved';
+        $claimRequest->save();
+
+        return $claimRequest;
+    }
+}

Modules/Internal/Http/Controllers/Api/CorporateBenefitController.php

@@ -18,14 +18,30 @@ class CorporateBenefitController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $benefits = CorporateBenefit::query()
-                    ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
-                    ->paginate(0)
-                    ->appends($request->all());
-        
+            ->filter($request->all())
+            ->where('corporate_id', $corporate_id)
+            ->paginate(0)
+            ->appends($request->all());
         return $benefits;
     }
+    public function activation(Request $request, $benefit_id)
+    {
+        $request->validate([
+            'active' => 'required'
+        ]);
 
+        // abort(404);
+
+        $benefit = CorporateBenefit::findOrFail($benefit_id);
+        $benefit->active = $request->active == '1';
+
+        if ($benefit->save()) {
+            return response()->json([
+                'benefit' => $benefit,
+                'message' => 'Status Updated Successfully'
+            ]);
+        }
+    }
     /**
      * Show the form for creating a new resource.
      * @return Renderable

Modules/Internal/Http/Controllers/Api/CorporateController.php

@@ -3,10 +3,15 @@
 namespace Modules\Internal\Http\Controllers\Api;
 
 use App\Exceptions\ImportRowException;
+use App\Helpers\Helper;
 use App\Imports\PlansImport;
 use App\Models\Benefit;
+use App\Models\Claim;
 use App\Models\Corporate;
+use App\Models\CorporateBenefit;
 use App\Models\Plan;
+use App\Models\Service;
+use App\Models\User;
 use App\Services\ImportService;
 use DB;
 use Illuminate\Contracts\Support\Renderable;
@@ -14,6 +19,9 @@ use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
 use Maatwebsite\Excel\Facades\Excel;
 use Box\Spout\Reader\Common\Creator\ReaderEntityFactory;
+use App\Models\File;
+use Illuminate\Support\Facades\File as FacadesFile;
+use Illuminate\Support\Facades\Response;
 use Illuminate\Support\Facades\Storage;
 use Modules\Internal\Services\CorporateService;
 
@@ -26,18 +34,20 @@ class CorporateController extends Controller
     public function index(Request $request)
     {
         $corporates = Corporate::query()
-                                ->when($request->search, function ($query, $search) {
-                                    return $query->where('name', 'LIKE', '%'.$search.'%')
-                                                ->orWhere('code', 'LIKE', '%'.$search.'%');
-                                })
-                                ->with('currentPolicy', 'subCorporates')
-                                ->withCount([
-                                    'employees',
-                                    'corporatePlans',
-                                    'corporateBenefits',
-                                ])
-                                ->where('type', 'corporate')
-                                ->paginate(10);
+            ->when($request->search, function ($query, $search) {
+                return $query->where('name', 'LIKE', '%' . $search . '%')
+                    ->orWhere('code', 'LIKE', '%' . $search . '%');
+            })
+            ->with('currentPolicy', 'subCorporates')
+            ->withCount([
+                'employees',
+                'corporateBenefits',
+                'corporatePlans',
+
+                // 'claims'
+            ])
+            ->where('type', 'corporate')
+            ->paginate(10);
 
         return $corporates;
     }
@@ -48,10 +58,10 @@ class CorporateController extends Controller
      */
     public function create()
     {
-        $corporateGroups = Corporate::whereNull('parent_id')->get()->map(function($corporate) {
+        $corporateGroups = Corporate::whereNull('parent_id')->get()->map(function ($corporate) {
             return [
                 'value' => $corporate->id,
-                'label' => $corporate->name.' ('.$corporate->code.')',
+                'label' => $corporate->name . ' (' . $corporate->code . ')',
             ];
         });
 
@@ -68,7 +78,7 @@ class CorporateController extends Controller
     public function store(Request $request)
     {
         $request->validate([
-            'code' => 'required',
+            'code' => 'required|regex:/^[a-zA-Z0-9]+$/',
             'name' => 'required',
             // 'logo' => 'required',
             'policy_code' => 'required_with:policy_id',
@@ -80,7 +90,7 @@ class CorporateController extends Controller
             'policy_stop_service_percentage' => 'required_with:policy_code',
             'policy_stop_service_net' => 'required_with:policy_code',
         ]);
-        
+
         try {
             DB::beginTransaction();
             $corporate_data = $request->all();
@@ -104,6 +114,135 @@ class CorporateController extends Controller
                 ]);
             }
 
+            // Service
+            $services = [
+                [
+                    'id' => 1,
+                    'name' => 'Out Patient',
+                    'code' => 'OP',
+                    'description' => 'Out Patient',
+                ],
+                [
+                    'id' => 2,
+                    'name' => 'Inpatient',
+                    'code' => 'IP',
+                    'description' => 'Inpatient',
+                ],
+                [
+                    'id' => 3,
+                    'name' => 'Dental',
+                    'code' => 'DE',
+                    'description' => 'Dental',
+                ],
+                [
+                    'id' => 4,
+                    'name' => 'Maternal',
+                    'code' => 'MA',
+                    'description' => 'Maternal',
+                ],
+                [
+                    'id' => 5,
+                    'name' => 'Optical',
+                    'code' => 'OPT',
+                    'description' => 'Optical',
+                ],
+                [
+                    'id' => 6,
+                    'name' => 'Medical Check Up',
+                    'code' => 'MCU',
+                    'description' => 'Medical Check Up',
+                ],
+            ];
+
+            foreach ($services as $service) {
+
+                $corporateService = $newCorporate->corporateServices()->create([
+                    'service_code' => $service['code'],
+                    'status' => 'inactive'
+                ]);
+
+                $corporateService->configs()->insert([
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'gp_external_doctor_online',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'gp_external_doctor_offline',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'gp_internal_doctor_online',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'gp_internal_doctor_offline',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'sp_external_doctor_online',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'sp_external_doctor_offline',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'sp_internal_doctor_online',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'sp_internal_doctor_offline',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'vitamins',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'delivery_fee',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'general_practitioner_fee',
+                        'value' => false,
+                    ],
+                    [
+                        'corporate_service_id' => $corporateService->id,
+                        'name' => 'specialist_practitioner_fee',
+                        'value' => false,
+                    ],
+                ]);
+            }
+
+            // TODO Remove This
+            // Assign Managed to Manager one
+            $managerOne = User::where('email', 'manager+one@gmail.com')->first();
+            $managerOne->managedCorporates()->attach($newCorporate);
+
+            if ($request->hasFile('logo')) {
+                $pathFileAvatar = File::storeFile('avatar', $newCorporate->id, $request->file('logo'));
+                $newCorporate->files()->updateOrCreate([
+                    'type' => 'avatar',
+                    'name' => File::getFileName('avatar', $newCorporate->id, $request->file('logo')),
+                    'extension' => $request->file('logo')->getClientOriginalExtension(),
+                    'path' => $pathFileAvatar,
+                    'created_by' => auth()->user()->id,
+                    'updated_by' => auth()->user()->id,
+                ]);
+            }
+
+
             DB::commit();
         } catch (\Exception $e) {
             DB::rollBack();
@@ -121,11 +260,22 @@ class CorporateController extends Controller
     public function show($id)
     {
         $corporate = Corporate::query()
-                            ->with(['currentPolicy'])
-                            ->withCount('corporatePlans')
-                            ->withCount('employees')
-                            // ->withCount('employees.claims')
-                            ->findOrFail($id);
+            ->with(['currentPolicy', 'plans'])
+            ->withCount('corporatePlans')
+            ->withCount('employees')
+            // ->withCount('employees.claims')
+            ->findOrFail($id);
+        $plans = $corporate['plans']->map(function ($plan) {
+            return [
+                'id' => $plan['id'],
+                'code' => $plan['code'],
+                'corporate_id' => $plan['corporate_id'],
+                'corporate_plan_id' => $plan['corporate_plan_id'],
+            ];
+        });
+
+        unset($corporate['plans']);
+        $corporate['plans'] = $plans;
 
         return response()->json($corporate);
     }
@@ -151,7 +301,7 @@ class CorporateController extends Controller
     public function update(Request $request, $id)
     {
         $request->validate([
-            'code' => 'required',
+            'code' => 'required|regex:/^[a-zA-Z0-9]+$/',
             'name' => 'required',
             'policy_code' => 'required_with:policy_id',
             'policy_total_premi' => 'required_with:policy_code',
@@ -162,12 +312,16 @@ class CorporateController extends Controller
             'policy_stop_service_percentage' => 'required_with:policy_code',
             'policy_stop_service_net' => 'required_with:policy_code',
         ]);
-        
+
         try {
             DB::beginTransaction();
+            //karena pake formdata
+            $linkingRules = $request->linking_rules;
+            $linkingRules = explode(',', $linkingRules);
 
             $corporate = Corporate::findOrFail($id);
-            $corporate->fill($request->toArray());
+            $corporate->fill($request->all());
+            $corporate->linking_rules = $linkingRules;
             $corporate->save();
 
             $corporate->policies()->updateOrCreate(
@@ -187,6 +341,19 @@ class CorporateController extends Controller
                 ]
             );
 
+            if ($request->hasFile('logo')) {
+                $pathFileAvatar = File::storeFile('avatar', $corporate->id, $request->file('logo'));
+
+                $corporate->files()->updateOrCreate([
+                    'type' => 'avatar',
+                    'name' => File::getFileName('avatar', $corporate->id, $request->file('logo')),
+                    'extension' => $request->file('logo')->getClientOriginalExtension(),
+                    'path' => $pathFileAvatar,
+                    'created_by' => auth()->user()->id,
+                    'updated_by' => auth()->user()->id,
+                ]);
+            }
+
             DB::commit();
         } catch (\Exception $e) {
             DB::rollBack();
@@ -206,7 +373,8 @@ class CorporateController extends Controller
         //
     }
 
-    public function activation(Request $request, $corporate_id) {
+    public function activation(Request $request, $corporate_id)
+    {
         $request->validate([
             'active' => 'required'
         ]);
@@ -230,16 +398,16 @@ class CorporateController extends Controller
             'file' => 'required|file|mimes:xls,xlsx,csv,txt',
         ]);
         // dd($request->toArray());
-        $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
+        $file_name = now()->getPreciseTimestamp(3) . '-' . $request->file('file')->getClientOriginalName();
         $file = $request->file('file')->storeAs('temp', $file_name);
-        $corporate = Corporate::findOrFail($corporate_id);
-        
+        $corporate = Corporate::with(['plans'])->findOrFail($corporate_id);
+
         $import = new ImportService();
-        $import->read(Storage::path('temp/'.$file_name));
-        $import->write(Storage::disk('public')->path('temp/result-'.$file_name), 'xsls');
+        $import->read(Storage::path('temp/' . $file_name));
+        $import->write(Storage::disk('public')->path('temp/result-' . $file_name), 'xsls');
 
         foreach ($import->sheetsIterator() as $sheetIndex => $sheet) {
-            if ( !in_array($sheet->getName(), ['Plan', 'Benefit']) ) {
+            if (!in_array($sheet->getName(), ['Plan', 'Benefit'])) {
                 continue;
             } else {
                 if ($sheetIndex == 1) { // Rename First Sheet to Writer
@@ -250,17 +418,16 @@ class CorporateController extends Controller
                     $nextWriterSheet->setName($sheet->getName());
                 }
 
-                if ( $sheet->getName() == 'Plan' ) {
+                if ($sheet->getName() == 'Plan') {
                     $headers_map_to_table_fields = Plan::$doc_headers_to_field_map;
-                } else if ( $sheet->getName() == 'Benefit' ) {
-                    $headers_map_to_table_fields = Benefit::$doc_headers_to_field_map;
+                } else if ($sheet->getName() == 'Benefit') {
+                    $headers_map_to_table_fields = CorporateBenefit::$doc_headers_to_field_map;
                 }
 
                 // Write Header to File
                 $result_headers = array_keys($headers_map_to_table_fields);
                 $result_headers = array_merge($result_headers, ['Ingest Code', 'Ingest Note']);
                 $import->addArrayToRow($result_headers);
-                
             }
 
             $doc_headers_indexes = [];
@@ -268,8 +435,8 @@ class CorporateController extends Controller
                 if ($index == 1) { // First Row Must be Header
                     foreach ($row->getCells() as $index => $cell) {
                         $title = $cell->getValue();
-                        $title = preg_replace( "/\r|\n/", " ", $title );
-                        $title = preg_replace('/\xc2\xa0/', " ", $title );
+                        $title = preg_replace("/\r|\n/", " ", $title);
+                        $title = preg_replace('/\xc2\xa0/', " ", $title);
                         $title = rtrim($title);
                         $title = ltrim($title);
                         $doc_headers_indexes[$index] = $title;
@@ -285,9 +452,9 @@ class CorporateController extends Controller
 
                     try { // Process the Row Data
                         $corporateService = new CorporateService();
-                        if ( $sheet->getName() == 'Plan' ) {
+                        if ($sheet->getName() == 'Plan') {
                             $corporateService->handlePlanRow($corporate, $row_data);
-                        } else if ( $sheet->getName() == 'Benefit' ) {
+                        } else if ($sheet->getName() == 'Benefit') {
                             $corporateService->handleBenefitRow($corporate, $row_data);
                         }
 
@@ -296,7 +463,6 @@ class CorporateController extends Controller
                             'Ingest Code' => 200,
                             'Ingest Note' => 'Success',
                         ]), $sheet->getName());
-
                     } catch (ImportRowException $e) {
                         // Write Data Validation Error to File
                         $import->addArrayToRow(array_merge($row_data, [
@@ -315,7 +481,7 @@ class CorporateController extends Controller
             }
         }
         $import->reader->close();
-        Storage::delete('temp/'.$file_name);
+        Storage::delete('temp/' . $file_name);
         $import->writer->close();
 
         return [
@@ -323,9 +489,36 @@ class CorporateController extends Controller
             // 'total_failed_row' => count($failed_plan_data),
             // 'failed_row' => $failed_plan_data,
             'result_file' => [
-                'url' => Storage::disk('public')->url('temp/result-'.$file_name),
-                'name' => 'result-'.$file_name,
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
+                'name' => 'result-' . $file_name,
             ]
         ];
     }
+
+    public function importDocumentExample($document_type) 
+    {
+        switch ($document_type) {
+            case 'plan-benefit':
+                return Helper::responseJson([
+                    'file_name' => "Corporate Plan & Benefit Import.xlsx",
+                    "file_url" => url('files/Corporate Plan & Benefit Import.xlsx')
+                ]);
+                break;
+            case 'member':
+                return Helper::responseJson([
+                    'file_name' => "Corporate Membership Import.xlsx",
+                    "file_url" => url('files/Corporate Membership Import.xlsx')
+                ]);
+                break;            
+            case 'diagnosis-exclusion':
+                return Helper::responseJson([
+                    'file_name' => "Corporate Exclusion Import.xlsx",
+                    "file_url" => url('files/Corporate Exclusion Import.xlsx')
+                ]);
+                break;            
+            default:
+                return Helper::responseJson([], 'error', 404);
+                break;
+        }
+    }
 }

Modules/Internal/Http/Controllers/Api/CorporateMemberController.php

@@ -15,6 +15,7 @@ use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
 use Illuminate\Support\Facades\Storage;
 use Modules\Internal\Services\MemberEnrollmentService;
+use PDF;
 
 class CorporateMemberController extends Controller
 {
@@ -29,28 +30,47 @@ class CorporateMemberController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $members = Member::query()
-                    ->filter($request->all())
-                // ->where('corporate_id', $corporate_id)
-                    ->whereHas('employeds', function ($employeds) use ($corporate_id) {
-                        $employeds->where('corporate_id', $corporate_id);
-                    })
-                    ->with([
-                        'employeds', 
-                        'currentPolicy',
-                        // 'claims',
-                        'claims' => function ($claim) {
-                            return $claim->whereBetween('requested_at', [now()->startOfYear(), now()->endOfYear()]);
-                            // return $claim->used(now()->startOfYear(), now()->endOfYear());
-                        }
-                    ])
-                    ->with('currentPlan')
-                    // ->with
-                    ->paginate()
-                    ->appends($request->all());
-        
+            ->filter($request->all())
+            // ->where('corporate_id', $corporate_id)
+            ->whereHas('employeds', function ($employeds) use ($corporate_id) {
+                $employeds->where('corporate_id', $corporate_id);
+            })
+            ->with([
+                'employeds',
+                'currentPolicy',
+                // 'claims',
+                'claims' => function ($claim) {
+                    // return $claim->whereBetween('requested_at', [now()->startOfYear(), now()->endOfYear()]);
+                    // return $claim->used(now()->startOfYear(), now()->endOfYear());
+                }
+            ])
+            ->with('currentPlan')
+            // ->with
+            ->paginate()
+            ->appends($request->all());
+
         return Helper::paginateResources(MemberDataTableResource::collection($members));
     }
 
+    public function activation(Request $request, $member_id)
+    {
+        $request->validate([
+            'active' => 'required'
+        ]);
+
+        // abort(404);
+
+        $member = Member::findOrFail($member_id);
+        $member->active = $request->active == '1';
+
+        if ($member->save()) {
+            return response()->json([
+                'member' => $member,
+                'message' => 'Status Updated Successfully'
+            ]);
+        }
+    }
+
     /**
      * Show the form for creating a new resource.
      * @return Renderable
@@ -116,17 +136,17 @@ class CorporateMemberController extends Controller
     {
         $request->validate([
             'file' => 'required|file|mimes:xls,xlsx,csv,txt',
-        ]); 
+        ]);
         $corporate = Corporate::findOrFail($corporate_id)->load('currentPolicy');
-        
-        $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
+
+        $file_name = now()->getPreciseTimestamp(3) . '-' . $request->file('file')->getClientOriginalName();
         $file = $request->file('file')->storeAs('temp', $file_name);
 
-        $reader = ReaderEntityFactory::createReaderFromFile(Storage::path('temp/'.$file_name));
-        $reader->open(Storage::path('temp/'.$file_name));
-        
+        $reader = ReaderEntityFactory::createReaderFromFile(Storage::path('temp/' . $file_name));
+        $reader->open(Storage::path('temp/' . $file_name));
+
         $writer = WriterEntityFactory::createXLSXWriter();
-        $writer->openToFile(Storage::disk('public')->path('temp/result-'.$file_name));
+        $writer->openToFile(Storage::disk('public')->path('temp/result-' . $file_name));
 
         $headers_map_to_table_fields = $this->memberEnrollmentService->doc_headers_to_field_map;
 
@@ -144,8 +164,8 @@ class CorporateMemberController extends Controller
                     foreach ($row->getCells() as $index => $cell) {
                         // Clear up the string and remove all spaces
                         $title = $cell->getValue();
-                        $title = preg_replace( "/\r|\n/", " ", $title );
-                        $title = preg_replace('/\xc2\xa0/', " ", $title );
+                        $title = preg_replace("/\r|\n/", " ", $title);
+                        $title = preg_replace('/\xc2\xa0/', " ", $title);
                         $title = rtrim($title);
                         $title = ltrim($title);
                         $doc_headers_indexes[$index] = $title;
@@ -162,7 +182,7 @@ class CorporateMemberController extends Controller
                     try {
                         // dd($new_member_data);
                         $rowResponse = $this->memberEnrollmentService->handleImportRow($corporate, $new_member_data);
-                        
+
                         // Write Success Result to File
                         $singleRow = WriterEntityFactory::createRow($this->memberEnrollmentService->makeResultRowWithResultFormat($rowResponse));
                         $writer->addRow($singleRow);
@@ -173,9 +193,12 @@ class CorporateMemberController extends Controller
                             'ingestion_code' => $e->getCode(),
                             'ingestion_status' => $e->getMessage(),
                         ]);
-                        $singleRow = WriterEntityFactory::createRow($this->memberEnrollmentService->makeResultRowWithResultFormat($new_member_data));
-                        $writer->addRow($singleRow);
-                        $failed_member_data[] = ['row_number' => $index, 'error' => $e->getMessage()];
+                        // try {
+                            $singleRow = WriterEntityFactory::createRow($this->memberEnrollmentService->makeResultRowWithResultFormat($new_member_data));
+                            $writer->addRow($singleRow);
+                        // } catch (\Exception $e) {
+                            $failed_member_data[] = ['row_number' => $index, 'error' => $e->getMessage(), 'data' => $new_member_data];
+                        // }
                     } catch (\Exception $e) {
                         // Write Server Error to File
                         $new_member_data = array_merge($new_member_data, [
@@ -187,14 +210,13 @@ class CorporateMemberController extends Controller
                         $failed_member_data[] = ['row_number' => $index, 'error' => $e->getMessage()];
                     }
                 }
-
             }
-            
+
             break; //only read first sheet
         }
         $reader->close();
         $writer->close();
-        Storage::delete('temp/'.$file_name);
+        Storage::delete('temp/' . $file_name);
         // throw(404);
 
         return [
@@ -202,9 +224,22 @@ class CorporateMemberController extends Controller
             'total_failed_row' => count($failed_member_data),
             'failed_row' => $failed_member_data,
             'result_file' => [
-                'url' => Storage::disk('public')->url('temp/result-'.$file_name),
-                'name' => 'result-'.$file_name,
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
+                'name' => 'result-' . $file_name,
             ]
         ];
     }
+
+
+    public function generateLog($member_id)
+    {
+        $member = Member::findOrFail($member_id)
+                ->load(['currentPlan', 'currentPolicy', 'currentPlan.corporateBenefits', 'currentPlan.corporateBenefits.benefit']);
+
+        // dd($member->currentPlan->corporateBenefits->toArray());
+
+        // return view('pdf.guaranted_leter', compact('member'));
+        $pdf = PDF::loadView('pdf.guaranted_leter', compact('member'));
+        return $pdf->download('Guaranted Letter - '.$member->full_name.'.pdf');
+    }
 }

Modules/Internal/Http/Controllers/Api/CorporatePlanController.php

@@ -17,14 +17,33 @@ class CorporatePlanController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $benefits = CorporatePlan::query()
-                    ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
-                    ->paginate(0)
-                    ->appends($request->all());
-        
+            ->filter($request->all())
+            ->where('corporate_id', $corporate_id)
+            ->paginate(0)
+            ->appends($request->all());
+
         return $benefits;
     }
 
+    public function activation(Request $request, $plan_id)
+    {
+        $request->validate([
+            'active' => 'required'
+        ]);
+
+        // abort(404);
+
+        $plan = CorporatePlan::findOrFail($plan_id);
+        $plan->active = $request->active == '1';
+
+        if ($plan->save()) {
+            return response()->json([
+                'plan' => $plan,
+                'message' => 'Status Updated Successfully'
+            ]);
+        }
+    }
+
     /**
      * Show the form for creating a new resource.
      * @return Renderable

Modules/Internal/Http/Controllers/Api/CorporateServiceController.php

@@ -12,6 +12,7 @@ use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
 use Modules\Internal\Transformers\CorporateServiceConfigResource;
+use Termwind\Components\Dd;
 
 class CorporateServiceController extends Controller
 {
@@ -74,6 +75,7 @@ class CorporateServiceController extends Controller
     public function update(Request $request, $corporate_id)
     {
         $corporateService = CorporateService::where('corporate_id', $corporate_id)->where('service_code', $request->service_code)->first();
+
         $corporateServiceConfig = $corporateService->configs()->updateOrCreate([
             'corporate_service_id' => $corporateService->id,
             'name' => $request->config_name
@@ -97,19 +99,32 @@ class CorporateServiceController extends Controller
 
     public function corporateServiceIndex($corporate_id, $service_code)
     {
-        $corporate = Corporate::findOrFail($corporate_id);
+        $corporate = Corporate::findOrFail($corporate_id)->with(['plans'])->first();
+        $plans = $corporate['plans']->map(function ($plan) {
+            return [
+                'id' => $plan['id'],
+                'code' => $plan['code'],
+                'corporate_id' => $plan['corporate_id'],
+                'corporate_plan_id' => $plan['corporate_plan_id'],
+            ];
+        });
+
+        unset($corporate['plans']);
+        $corporate['plans'] = $plans;
+
         $corporateService = CorporateService::query()
-                                            ->where('corporate_id', $corporate_id)
-                                            ->where('service_code', $service_code)
-                                            ->with(['configs', 'service', 
-                                                'specialities' => function($speciality) {
-                                                    $speciality->where('status', 'active');
-                                                }, 
-                                                'specialities.speciality'])
-                                            ->first();
+            ->where('corporate_id', $corporate_id)
+            ->where('service_code', $service_code)
+            ->with([
+                'configs', 'service',
+                'corporateServiceSpecialities',
+                'corporateServiceSpecialities.speciality',
+                'corporateServiceSpecialities.exclusions.rules'
+            ])
+            ->first();
         // $service = CorporateServiceConfigResource::make($corporateService);
         $specialities = Speciality::get();
-        
+
         return response()->json(
             [
                 'corporate' => $corporate,
@@ -123,10 +138,10 @@ class CorporateServiceController extends Controller
     {
         // $corporate = Corporate::findOrFail($corporate_id);
         $corporateService = CorporateService::query()
-                                            ->where('corporate_id', $corporate_id)
-                                            ->where('service_code', $service_code)
-                                            // ->with('configs', 'service')
-                                            ->first();
+            ->where('corporate_id', $corporate_id)
+            ->where('service_code', $service_code)
+            // ->with('configs', 'service')
+            ->first();
         $corporateService->fill([
             'status' => $request->status == 'active' ? 'active' : 'inactive'
         ]);
@@ -137,26 +152,288 @@ class CorporateServiceController extends Controller
 
     public function corporateServiceSpecialityUpdate(Request $request, $corporate_id, $service_code)
     {
+
+
+        // return response()->json([$request->checked, $request->value, $request->speciality_id]);
+
         $corporateService = CorporateService::query()
-                                            ->where('corporate_id', $corporate_id)
-                                            ->where('service_code', $service_code)
-                                            ->first();
-        CorporateServiceSpeciality::updateOrCreate([
+            ->where('corporate_id', $corporate_id)
+            ->where('service_code', $service_code)
+            ->first();
+
+
+        $corporateServiceSpeciality = CorporateServiceSpeciality::updateOrCreate([
             'corporate_service_id' => $corporateService->id,
             'speciality_id' => $request->speciality_id,
         ], [
             'corporate_service_id' => $corporateService->id,
             'speciality_id' => $request->speciality_id,
-            'status' => $request->status
+            'active' => $request->active
         ]);
 
+        $exclusion =  $corporateServiceSpeciality->exclusions()->updateOrCreate([
+            'corporate_id' => $corporate_id,
+            'service_code' => $service_code,
+        ], [
+            'corporate_id' => $corporate_id,
+            'service_code' => $service_code,
+            'type' => 'speciality',
+        ]);
+
+
         $selected_specialities = CorporateServiceSpeciality::query()
-                                                        ->where('corporate_service_id', $corporateService->id)
-                                                        ->where('status', 'active')
-                                                        ->with('speciality')
-                                                        ->get()
-                                                        ->pluck('speciality.name', 'speciality.id');
+            ->where('corporate_service_id', $corporateService->id)
+            ->where('active', true)
+            ->with('speciality')
+            ->get()
+            ->pluck('speciality.name', 'speciality.id');
 
         return response()->json($selected_specialities);
     }
+
+    public function storeExclusion(Request $request, $corporate_id, $service_code)
+    {
+
+        $corporateService = CorporateService::query()
+            ->where('corporate_id', $corporate_id)
+            ->where('service_code', $service_code)
+            ->first();
+
+        $corporateServiceSpeciality = CorporateServiceSpeciality::where('corporate_service_id', $corporateService->id)
+            ->where('speciality_id', $request->speciality_id)
+            ->with('exclusions.rules')
+            ->first();
+
+        if (empty($corporateServiceSpeciality)) {
+            $corporateServiceSpeciality = CorporateServiceSpeciality::create([
+                'corporate_service_id' => $corporateService->id,
+                'speciality_id' => $request->speciality_id,
+                'active' => false,
+            ]);
+
+            $corporateServiceSpeciality->exclusions()->updateOrCreate([
+                'corporate_id' => $corporate_id,
+                'service_code' => $service_code,
+            ], [
+                'corporate_id' => $corporate_id,
+                'service_code' => $service_code,
+                'type' => 'speciality',
+            ]);
+        }
+
+        $exclusion = $corporateServiceSpeciality->exclusions()->where('corporate_id', $corporate_id)->where('service_code', $service_code)->first();
+
+
+        if ($request->type == 'msc') {
+
+            $value_input = $request->value;
+            $current_msc = $exclusion->rules()->where('name', 'msc')->first()->values ?? null;
+
+            if (!empty($current_msc)) {
+
+                $values = "";
+                if ($request->value == 'm' && $request->checked == "1") {
+                    $values = $current_msc . "," . $value_input;
+                }
+
+                if ($request->value == 's' && $request->checked == "1") {
+                    $values = $current_msc . "," . $value_input;
+                }
+
+                if ($request->value == 'c' && $request->checked == "1") {
+                    $values = $current_msc . "," . $value_input;
+                }
+
+                if ($request->value == 'm' && $request->checked == "0") {
+                    $values = str_replace($value_input, "", $current_msc);
+                    $values = str_replace(",,", ",", $values);
+                    $values = trim($values, ",");
+                }
+
+                if ($request->value == 's' && $request->checked == "0") {
+                    $values = str_replace($value_input, "", $current_msc);
+                    $values = str_replace(",,", ",", $values);
+                    $values = trim($values, ",");
+                }
+
+                if ($request->value == 'c' && $request->checked == "0") {
+                    $values = str_replace($value_input, "", $current_msc);
+                    $values = str_replace(",,", ",", $values);
+                    $values = trim($values, ",");
+                }
+
+                $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                    'exclusion_id' => $exclusion->id,
+                    'name' => 'msc',
+                ], [
+                    'name' => 'msc',
+                    'values' => $values,
+                ]);
+            } else {
+                if ($request->value == 'm' && $request->checked == "1") {
+                    $values = $value_input;
+                }
+
+                if ($request->value == 's' && $request->checked == "1") {
+                    $values = $value_input;
+                }
+
+                if ($request->value == 'c' && $request->checked == "1") {
+                    $values = $value_input;
+                }
+
+                $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                    'exclusion_id' => $exclusion->id,
+                    'name' => 'msc',
+                ], [
+                    'name' => 'msc',
+                    'values' => $values,
+                ]);
+            }
+        }
+
+        if ($request->type == 'gender') {
+            $value_input = $request->value;
+            $current_gender = $exclusion->rules()->where('name', 'gender')->first()->values ?? null;
+
+            if (!empty($current_gender)) {
+                $values = "";
+                if ($request->value == 'male' && $request->checked == "1") {
+                    $values = $current_gender . "," . $value_input;
+                }
+
+                if ($request->value == 'female' && $request->checked == "1") {
+                    $values = $current_gender . "," . $value_input;
+                }
+
+                if ($request->value == 'male' && $request->checked == "0") {
+                    if (substr($current_gender, 0, 4) == "male") {
+                        $values = str_replace($value_input, "", $value_input) . substr($current_gender, 5, 10);
+                    } else {
+                        $values = str_replace($value_input, "", $value_input) . substr($current_gender, 0, 6);
+                    }
+                }
+
+                if ($request->value == 'female' && $request->checked == "0") {
+                    $values = str_replace($value_input, "", $current_gender);
+                    $values = str_replace(",,", ",", $values);
+                    $values = trim($values, ",");
+                }
+
+                $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                    'exclusion_id' => $exclusion->id,
+                    'name' => 'gender',
+                ], [
+                    'name' => 'gender',
+                    'values' => $values,
+                ]);
+            } else {
+                if ($request->value == 'male' && $request->checked == "1") {
+                    $values = $value_input;
+                }
+
+                if ($request->value == 'female' && $request->checked == "1") {
+                    $values = $value_input;
+                }
+
+                $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                    'exclusion_id' => $exclusion->id,
+                    'name' => 'gender',
+                ], [
+                    'name' => 'gender',
+                    'values' => $values,
+                ]);
+            }
+        }
+
+        if ($request->type == "min_age") {
+            $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'min_age',
+            ], [
+                'name' => 'min_age',
+                'values' => $request->value,
+            ]);
+        }
+
+        if ($request->type == "max_age") {
+            $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'max_age',
+            ], [
+                'name' => 'max_age',
+                'values' => $request->value,
+            ]);
+        }
+
+        if ($request->type == "plan") {
+            $value = $request->value;
+            foreach ($value as $key => $val) {
+                $item[] = $val['value'];
+            }
+
+            $plan = implode(",", $item);
+
+            $exclusion_rule = $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'plan',
+            ], [
+                'name' => 'plan',
+                'values' => $plan ?? '',
+            ]);
+        }
+
+        if ($request->type == "one_row") {
+            $data = $request->one_row;
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'min_age',
+            ], [
+                'name' => 'min_age',
+                'values' => $data['min_age'] ?? '',
+            ]);
+
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'max_age',
+            ], [
+                'name' => 'max_age',
+                'values' => $data['max_age'] ?? '',
+            ]);
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'plan',
+            ], [
+                'name' => 'plan',
+                'values' => $data['plan'] ?? '',
+            ]);
+        }
+
+
+        $selected_specialities = CorporateServiceSpeciality::query()
+            ->where('corporate_service_id', $corporateService->id)
+            ->where('active', true)
+            ->with('speciality')
+            ->get()
+            ->pluck('speciality.name', 'speciality.id');
+
+        $corporateService = CorporateService::query()
+            ->where('corporate_id', $corporate_id)
+            ->where('service_code', $service_code)
+            ->with([
+                'configs', 'service',
+                'corporateServiceSpecialities',
+                'corporateServiceSpecialities.speciality',
+                'corporateServiceSpecialities.exclusions.rules'
+            ])
+            ->first();
+
+        return response()->json([
+            'selected_specialities' => $selected_specialities,
+            'service' => CorporateServiceConfigResource::make($corporateService),
+        ]);
+    }
 }

Modules/Internal/Http/Controllers/Api/DiagnosisExclusionController.php

@@ -5,6 +5,7 @@ namespace Modules\Internal\Http\Controllers\Api;
 use App\Exceptions\ImportRowException;
 use App\Helpers\Helper;
 use App\Models\Corporate;
+use App\Models\CorporateService;
 use App\Models\Exclusion;
 use App\Models\Icd;
 use App\Models\ImportLog;
@@ -26,10 +27,12 @@ class DiagnosisExclusionController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $exclusions = Exclusion::query()
-                            ->where('corporate_id', $corporate_id)
-                            ->with(['exclusionable', 'rules'])
-                            ->filter($request->toArray())
-                            ->paginate();
+            ->where('corporate_id', $corporate_id)
+            ->where('type', 'diagnosis')
+            ->where('deleted_at', null)
+            ->with(['exclusionable', 'rules'])
+            ->filter($request->toArray())
+            ->paginate();
         // return $exclusions;
         return Helper::paginateResources(DiagnosisExclusionResource::collection($exclusions));
     }
@@ -91,7 +94,13 @@ class DiagnosisExclusionController extends Controller
      */
     public function destroy($id)
     {
-        //
+        $exclusion = Exclusion::findOrFail($id);
+
+        $exclusion->rules()->delete();
+        $exclusion->delete();
+        return response()->json([
+            'message' => 'Exclusion deleted successfully'
+        ]);
     }
 
     public function import(Request $request, $corporate_id)
@@ -100,10 +109,10 @@ class DiagnosisExclusionController extends Controller
             'file' => 'required|file|mimes:xls,xlsx,csv,txt',
         ]);
         // dd($request->toArray());
-        $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
+        $file_name = now()->getPreciseTimestamp(3) . '-' . $request->file('file')->getClientOriginalName();
         $file = $request->file('file')->storeAs('temp', $file_name);
         $corporate = Corporate::findOrFail($corporate_id);
-        
+
         // $importLog = $corporate->importLogs()->create([
         //     'type' => 'diagnosis-exclusions',
         //     'file_path' => $file,
@@ -112,8 +121,8 @@ class DiagnosisExclusionController extends Controller
         // ]);
 
         $import = new ImportService();
-        $import->read(Storage::path('temp/'.$file_name));
-        $import->write(Storage::disk('public')->path('temp/result-'.$file_name), 'xsls');
+        $import->read(Storage::path('temp/' . $file_name));
+        $import->write(Storage::disk('public')->path('temp/result-' . $file_name), 'xsls');
 
         foreach ($import->sheetsIterator() as $sheetIndex => $sheet) {
             $doc_headers_indexes = [];
@@ -121,8 +130,8 @@ class DiagnosisExclusionController extends Controller
                 if ($index == 1) { // First Row Must be Header
                     foreach ($row->getCells() as $index => $cell) {
                         $title = $cell->getValue();
-                        $title = preg_replace( "/\r|\n/", " ", $title );
-                        $title = preg_replace('/\xc2\xa0/', " ", $title );
+                        $title = preg_replace("/\r|\n/", " ", $title);
+                        $title = preg_replace('/\xc2\xa0/', " ", $title);
                         $title = rtrim($title);
                         $title = ltrim($title);
                         $doc_headers_indexes[$index] = $title;
@@ -148,12 +157,12 @@ class DiagnosisExclusionController extends Controller
                         9 => 'keterangan',
                         10 => 'maternity_waiting'
                     ];
-                    
+
                     foreach ($row->getCells() as $header_index => $cell) {
                         if (isset($row_map[$header_index])) {
                             $value = $cell->getValue();
-                            $value = preg_replace( "/\r|\n/", " ", $value );
-                            $value = preg_replace('/\xc2\xa0/', " ", $value );
+                            $value = preg_replace("/\r|\n/", " ", $value);
+                            $value = preg_replace('/\xc2\xa0/', " ", $value);
                             $value = rtrim($value);
                             $value = ltrim($value);
                             $row_data[$row_map[$header_index]] = $cell->getValue();
@@ -171,7 +180,8 @@ class DiagnosisExclusionController extends Controller
                             empty($row_data['sp_exclusion']) &&
                             empty($row_data['pre_exis_exclusion']) &&
                             empty($row_data['op_de_exclusion']) &&
-                            empty($row_data['maternity_waiting'])) {
+                            empty($row_data['maternity_waiting'])
+                        ) {
                             continue;
                         }
 
@@ -184,7 +194,6 @@ class DiagnosisExclusionController extends Controller
                             'Ingest Code' => 200,
                             'Ingest Note' => 'Success',
                         ]), $sheet->getName());
-
                     } catch (ImportRowException $e) {
                         // Write Data Validation Error to File
                         $import->addArrayToRow(array_merge($row_data, [
@@ -205,7 +214,7 @@ class DiagnosisExclusionController extends Controller
             break; // Only Read First Row
         }
         $import->reader->close();
-        Storage::delete('temp/'.$file_name);
+        Storage::delete('temp/' . $file_name);
         $import->writer->close();
 
         return [
@@ -213,9 +222,102 @@ class DiagnosisExclusionController extends Controller
             // 'total_failed_row' => count($failed_plan_data),
             // 'failed_row' => $failed_plan_data,
             'result_file' => [
-                'url' => Storage::disk('public')->url('temp/result-'.$file_name),
-                'name' => 'result-'.$file_name,
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
+                'name' => 'result-' . $file_name,
             ]
         ];
     }
+
+    public function storeExclusion(Request $request, $corporate_id)
+    {
+        $exclusion = Exclusion::where('corporate_id', $corporate_id)
+            ->where('id', $request->icd_id)
+            ->where('type', 'diagnosis')
+            ->first();
+
+
+        if ($request->type == "one_row") {
+            $data = $request->one_row;
+
+            foreach ($data['msc'] as $key => $value) {
+                if ($key == 'm' && $value == "1") {
+                    $msc[] = $key;
+                } elseif ($key == 's' && $value == "1") {
+                    $msc[] = $key;
+                } elseif ($key == 'c' && $value == "1") {
+                    $msc[] = $key;
+                } else {
+                    $msc[] = "";
+                }
+            }
+
+            $msc = implode(",", $msc);
+            $msc = trim($msc, ",");
+            $msc = str_replace(",,", ",", $msc);
+
+            foreach ($data['gender'] as $key => $value) {
+                if ($key == 'male' && $value == "1") {
+                    $gender[] = $key;
+                } elseif ($key == 'female' && $value == "1") {
+                    $gender[] = $key;
+                } else {
+                    $gender[] = "";
+                }
+            }
+
+            $gender = implode(",", $gender);
+            $gender = trim($gender, ",");
+
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'msc',
+            ], [
+                'name' => 'msc',
+                'values' => $msc ?? '',
+            ]);
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'gender',
+            ], [
+                'name' => 'gender',
+                'values' => $gender ?? '',
+            ]);
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'min_age',
+            ], [
+                'name' => 'min_age',
+                'values' => $data['min_age'] ?? '',
+            ]);
+
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'max_age',
+            ], [
+                'name' => 'max_age',
+                'values' => $data['max_age'] ?? '',
+            ]);
+
+            $exclusion->rules()->updateOrCreate([
+                'exclusion_id' => $exclusion->id,
+                'name' => 'plan',
+            ], [
+                'name' => 'plan',
+                'values' => $data['plan'] ?? '',
+            ]);
+        }
+
+        $exclusions = Exclusion::query()
+            ->where('corporate_id', $corporate_id)
+            ->where('type', 'diagnosis')
+            ->with(['exclusionable', 'rules'])
+            ->filter($request->toArray())
+            ->paginate();
+        // return $exclusions;
+        return Helper::paginateResources(DiagnosisExclusionResource::collection($exclusions));
+    }
 }

Modules/Internal/Http/Controllers/Api/DivisionController.php

@@ -17,11 +17,11 @@ class DivisionController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $benefits = CorporateDivision::query()
-                    ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
-                    ->paginate(0)
-                    ->appends($request->all());
-        
+            ->filter($request->all())
+            ->where('corporate_id', $corporate_id)
+            ->paginate(0)
+            ->appends($request->all());
+
         return $benefits;
     }
 
@@ -44,7 +44,6 @@ class DivisionController extends Controller
         $request->validate([
             'code' => [
                 'required',
-                Rule::unique('corporate_plans')->where('corporate_id', $corporate_id)
             ],
             'name' => 'required'
         ]);

Modules/Internal/Http/Controllers/Api/DoctorController.php

@@ -0,0 +1,111 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\Practitioner;
+use App\Models\PractitionerRole;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Modules\Internal\Transformers\DoctorResource;
+
+class DoctorController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        // $doctors = PractitionerRole::active()->with('practitioner.person', 'organization')
+        //     ->when($request->search ?? null, function ($query, $search) {
+        //         $query->whereHas('practitioner.person', function ($person) use ($search) {
+        //             $person->where('name', 'LIKE', '%' . $search . '%');
+        //         });
+        //     })->paginate();
+
+        $doctors = Practitioner::with('person', 'practitionerRoles.organization', 'practitionerRoles.speciality')
+            ->when($request->search ?? null, function ($query, $search) {
+                $query->whereHas('person', function ($person) use ($search) {
+                    $person->where('name', 'LIKE', '%' . $search . '%');
+                });
+            })
+            ->when($request->organization_id ?? null, function ($query, $organization_id) {
+                $query->whereHas('practitionerRoles', function ($practitionerRole) use ($organization_id) {
+                    $practitionerRole->where('organization_id', $organization_id);
+                });
+            })
+            ->when($request->speciality_id ?? null, function ($query, $speciality_id) {
+                $query->whereHas('practitionerRoles', function ($practitionerRole) use ($speciality_id) {
+                    $practitionerRole->where('speciality_id', $speciality_id);
+                });
+            })
+            ->paginate();
+
+        // return $doctors;
+
+
+        return response()->json(Helper::paginateResources(DoctorResource::collection($doctors)));
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Internal/Http/Controllers/Api/OrganizationController.php

@@ -1,14 +1,15 @@
 <?php
 
-namespace Modules\Client\Http\Controllers\Api;
+namespace Modules\Internal\Http\Controllers\Api;
 
 use App\Helpers\Helper;
-use App\Models\Member;
+use App\Models\Organization;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
+use Modules\Internal\Transformers\OrganizationResource;
 
-class MemberController extends Controller
+class OrganizationController extends Controller
 {
     /**
      * Display a listing of the resource.
@@ -16,27 +17,18 @@ class MemberController extends Controller
      */
     public function index(Request $request)
     {
-        $user = auth()->user();
+        $organizations = Organization::hospital()->with('currentAddress')
+            ->when($request->search ?? null, function ($query, $search) {
+                $query->where('name', 'LIKE', '%' . $search . '%');
+            })
+            ->paginate();
+        return response()->json(Helper::paginateResources(OrganizationResource::collection($organizations)));
+    }
 
-        $corporate = $user->managedCorporates()->first();
-        // $plans = 
-
-        $members = Member::query()
-                        ->whereHas('employeds', function($corporateEmployee) use ($corporate) {
-                            $corporateEmployee->where('corporate_id', $corporate->id);
-                        });
-        if ($request->has('search')) {
-            $members
-                ->where('member_id', 'like', "%" . $request->search . "%")
-                ->orWhere('payor_id', 'like', "%" . $request->search . "%")
-                ->orWhere('name', 'like', "%" . $request->search . "%");
-        }
-
-        $members = $members->paginate();
-
-        return response()->json([
-            'members' => Helper::paginateResources($members)
-        ]);
+    public function searchOrganization(Request $request)
+    {
+        $organizations = Organization::hospital()->get();
+        return response()->json(OrganizationResource::collection($organizations));
     }
 
     /**
@@ -45,7 +37,7 @@ class MemberController extends Controller
      */
     public function create()
     {
-        return view('client::create');
+        return view('internal::create');
     }
 
     /**
@@ -65,7 +57,7 @@ class MemberController extends Controller
      */
     public function show($id)
     {
-        return view('client::show');
+        return view('internal::show');
     }
 
     /**
@@ -75,7 +67,7 @@ class MemberController extends Controller
      */
     public function edit($id)
     {
-        return view('client::edit');
+        return view('internal::edit');
     }
 
     /**

Modules/Internal/Http/Controllers/Api/PlanController.php

@@ -28,16 +28,16 @@ class PlanController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $plans = Plan::query()
-                    ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
-                    // ->whereHas('corporatePlan', function ($corporatePlan) use ($corporate_id) {
-                    //     $corporatePlan->where('corporate_id', $corporate_id);
-                    // })
-                    // ->with('corporatePlan')
-                    ->orderBy('corporate_plan_id', 'ASC')
-                    ->paginate()
-                    ->appends($request->all());
-        
+            ->filter($request->all())
+            ->where('corporate_id', $corporate_id)
+            // ->whereHas('corporatePlan', function ($corporatePlan) use ($corporate_id) {
+            //     $corporatePlan->where('corporate_id', $corporate_id);
+            // })
+            // ->with('corporatePlan')
+            ->orderBy('corporate_plan_id', 'ASC')
+            ->paginate()
+            ->appends($request->all());
+
         return $plans;
     }
 
@@ -105,14 +105,14 @@ class PlanController extends Controller
     {
         $request->validate([
             'file' => 'required|file|mimes:xls,xlsx,csv,txt',
-        ]); 
-        $file_name = now()->getPreciseTimestamp(3).'-'.$request->file('file')->getClientOriginalName();
+        ]);
+        $file_name = now()->getPreciseTimestamp(3) . '-' . $request->file('file')->getClientOriginalName();
         $file = $request->file('file')->storeAs('temp', $file_name);
         $corporate = Corporate::findOrFail($corporate_id);
-        
+
         $import = $this->importService;
-        $import->read(Storage::path('temp/'.$file_name));
-        $import->write(Storage::disk('public')->path('temp/result-'.$file_name), 'xsls');
+        $import->read(Storage::path('temp/' . $file_name));
+        $import->write(Storage::disk('public')->path('temp/result-' . $file_name), 'xsls');
 
         $headers_map_to_table_fields = Plan::$doc_headers_to_field_map;
 
@@ -142,7 +142,7 @@ class PlanController extends Controller
                     // Create Directly
                     try {
                         $rowResponse = $this->corporateService->handlePlanRow($corporate, $plan_row);
-                        
+
                         // Write Success Result to File
                         array_push($plan_row, 'SUCCESS');
                         $import->addArrayToRow($plan_row);
@@ -160,11 +160,11 @@ class PlanController extends Controller
                     }
                 }
             }
-            
+
             break; //only read first sheet
         }
         $import->reader->close();
-        Storage::delete('temp/'.$file_name);
+        Storage::delete('temp/' . $file_name);
         $import->writer->close();
         // throw(404);
 
@@ -173,8 +173,8 @@ class PlanController extends Controller
             'total_failed_row' => count($failed_plan_data),
             'failed_row' => $failed_plan_data,
             'result_file' => [
-                'url' => Storage::disk('public')->url('temp/result-'.$file_name),
-                'name' => 'result-'.$file_name,
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
+                'name' => 'result-' . $file_name,
             ]
         ];
     }

Modules/Internal/Http/Controllers/Api/SpecialityController.php

@@ -0,0 +1,87 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers\Api;
+
+use App\Models\Speciality;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+
+class SpecialityController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index()
+    {
+        $specialiy = Speciality::get();
+        return response()->json($specialiy);
+    }
+
+    public function searchSpeciality(Request $request)
+    {
+        $specialiy = Speciality::get();
+        return response()->json($specialiy);
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Internal/Listeners/SendVerifyEmail.php

@@ -0,0 +1,37 @@
+<?php
+
+namespace Modules\Internal\Listeners;
+
+use App\Models\User;
+use Modules\Internal\Events\ForgetPassword;
+use Illuminate\Queue\InteractsWithQueue;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Support\Facades\Mail;
+use Modules\Internal\Notifications\NotifyVerifyEmail;
+
+class SendVerifyEmail
+{
+    /**
+     * Create the event listener.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Handle the event.
+     *
+     * @param ForgetPassword $event
+     * @return void
+     */
+    public function handle(ForgetPassword $event)
+    {
+        User::where('email', $event->data['email'])
+            ->each(function ($user) use ($event) {
+                $user->notify(new NotifyVerifyEmail($event->data));
+            });
+    }
+}

Modules/Internal/Notifications/NotifyVerifyEmail.php

@@ -0,0 +1,70 @@
+<?php
+
+namespace Modules\Internal\Notifications;
+
+use Crypt;
+use Illuminate\Bus\Queueable;
+use Illuminate\Notifications\Notification;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Notifications\Messages\MailMessage;
+
+class NotifyVerifyEmail extends Notification
+{
+    use Queueable;
+    protected $data;
+    /**
+     * Create a new notification instance.
+     *
+     * @return void
+     */
+    public function __construct($data)
+    {
+        $this->data = $data;
+    }
+
+    /**
+     * Get the notification's delivery channels.
+     *
+     * @param mixed $notifiable
+     * @return array
+     */
+    public function via($notifiable)
+    {
+        return ['mail'];
+    }
+
+    /**
+     * Get the mail representation of the notification.
+     *
+     * @param mixed $notifiable
+     * @return \Illuminate\Notifications\Messages\MailMessage
+     */
+    public function toMail($notifiable)
+    {
+
+        $token = Crypt::encryptString($this->data['email'] . '|' . now());
+
+        $url = env('INTERNAL_URL', 'https://aso.linksehat.com') . '/auth/forget-password?token=' . $token;
+
+        return (new MailMessage)
+            ->subject('Verify Email')
+            ->markdown('verify_email', ['url' => $url]);
+        // return (new MailMessage)
+        //             ->line('The introduction to the notification.')
+        //             ->action('Notification Action', 'https://laravel.com')
+        //             ->line('Thank you for using our application!');
+    }
+
+    /**
+     * Get the array representation of the notification.
+     *
+     * @param mixed $notifiable
+     * @return array
+     */
+    public function toArray($notifiable)
+    {
+        return [
+            //
+        ];
+    }
+}

Modules/Internal/Providers/EventServiceProvider.php

@@ -0,0 +1,50 @@
+<?php
+
+namespace Modules\Internal\Providers;
+
+use Illuminate\Support\Facades\Event;
+use Illuminate\Support\ServiceProvider;
+use Modules\Internal\Events\ForgetPassword;
+use Modules\Internal\Listeners\SendVerifyEmail;
+
+class EventServiceProvider extends ServiceProvider
+{
+    // protected $listen = [
+    //     ForgetPassword::class => [
+    //         SendVerifyEmail::class,
+    //     ],
+    // ];
+
+    /**
+     * Bootstrap any application services.
+     *
+     * @return void
+     */
+    public function boot()
+    {
+        Event::listen(
+            ForgetPassword::class,
+            [SendVerifyEmail::class, 'handle']
+        );
+    }
+
+    /**
+     * Register the service provider.
+     *
+     * @return void
+     */
+    public function register()
+    {
+        //
+    }
+
+    /**
+     * Get the services provided by the provider.
+     *
+     * @return array
+     */
+    public function provides()
+    {
+        return [];
+    }
+}

Modules/Internal/Providers/InternalServiceProvider.php

@@ -7,6 +7,11 @@ use Illuminate\Database\Eloquent\Factory;
 
 class InternalServiceProvider extends ServiceProvider
 {
+    protected $listen = [
+        ForgetPassword::class => [
+            SendVerifyEmail::class,
+        ],
+    ];
     /**
      * @var string $moduleName
      */
@@ -51,7 +56,8 @@ class InternalServiceProvider extends ServiceProvider
             module_path($this->moduleName, 'Config/config.php') => config_path($this->moduleNameLower . '.php'),
         ], 'config');
         $this->mergeConfigFrom(
-            module_path($this->moduleName, 'Config/config.php'), $this->moduleNameLower
+            module_path($this->moduleName, 'Config/config.php'),
+            $this->moduleNameLower
         );
     }
 

Modules/Internal/Routes/api.php

@@ -5,6 +5,7 @@ use Modules\Internal\Http\Controllers\Api\AuthController;
 use Illuminate\Http\Request;
 use Modules\Internal\Http\Controllers\Api\BenefitController;
 use Modules\Internal\Http\Controllers\Api\ClaimController;
+use Modules\Internal\Http\Controllers\Api\ClaimRequestController;
 use Modules\Internal\Http\Controllers\Api\CorporateBenefitController;
 use Modules\Internal\Http\Controllers\Api\CorporateController;
 use Modules\Internal\Http\Controllers\Api\CorporateFormulariumController;
@@ -14,10 +15,13 @@ use Modules\Internal\Http\Controllers\Api\CorporateServiceController;
 use Modules\Internal\Http\Controllers\Api\DiagnosisController;
 use Modules\Internal\Http\Controllers\Api\DiagnosisExclusionController;
 use Modules\Internal\Http\Controllers\Api\DivisionController;
+use Modules\Internal\Http\Controllers\Api\DoctorController;
 use Modules\Internal\Http\Controllers\Api\DrugController;
 use Modules\Internal\Http\Controllers\Api\FormulariumController;
 use Modules\Internal\Http\Controllers\Api\MemberController;
+use Modules\Internal\Http\Controllers\Api\OrganizationController;
 use Modules\Internal\Http\Controllers\Api\PlanController;
+use Modules\Internal\Http\Controllers\Api\SpecialityController;
 
 /*
 |--------------------------------------------------------------------------
@@ -36,16 +40,19 @@ Route::prefix('internal')->group(function () {
     Route::post('login', [AuthController::class, 'login'])->name('login');
     Route::post('forget-password', [AuthController::class, 'forgetPassword'])->name('forget-password');
     Route::post('verify-email', [AuthController::class, 'verifyEmail'])->name('verify-email');
-    
+
 
     Route::middleware('auth:sanctum')->group(function () {
-        
+
         Route::post('logout', [AuthController::class, 'logout'])->name('logout');
         Route::get('/user', function (Request $request) {
             return $request->user();
         });
+        Route::put('reset-password', [AuthController::class, 'resetPassword'])->name('resetPassword');
+
 
         Route::resource('corporates', CorporateController::class);
+        Route::get('corporates/import-document-example/{document_type}', [CorporateController::class, 'importDocumentExample']);
         Route::put('corporates/{corporate_id}/activation', [CorporateController::class, 'activation']);
         Route::post('corporates/{corporate_id}/import-plan-benefit', [CorporateController::class, 'importPlanBenefit']);
 
@@ -53,14 +60,16 @@ Route::prefix('internal')->group(function () {
         Route::post('corporates/{corporate_id}/corporate-plans', [CorporatePlanController::class, 'store']);
         Route::get('corporates/{corporate_id}/corporate-plans/{id}/edit', [CorporatePlanController::class, 'edit']);
         Route::put('corporates/{corporate_id}/corporate-plans/{id}', [CorporatePlanController::class, 'update']);
-        
+        Route::put('plans/{plan_id}/activation', [CorporatePlanController::class, 'activation']);
+
         Route::get('corporates/{corporate_id}/plans', [PlanController::class, 'index']);
         Route::post('corporates/{corporate_id}/plans/import', [PlanController::class, 'planImport']);
-        
+
         Route::get('corporates/{corporate_id}/corporate-benefits', [CorporateBenefitController::class, 'index']);
         Route::post('corporates/{corporate_id}/corporate-benefits', [CorporateBenefitController::class, 'store']);
         Route::get('corporates/{corporate_id}/corporate-benefits/{id}/edit', [CorporateBenefitController::class, 'edit']);
         Route::put('corporates/{corporate_id}/corporate-benefits/{id}', [CorporateBenefitController::class, 'update']);
+        Route::put('benefits/{benefit_id}/activation', [CorporateBenefitController::class, 'activation']);
 
         Route::get('corporates/{corporate_id}/benefits', [BenefitController::class, 'index']);
         Route::post('corporates/{corporate_id}/benefits/import', [BenefitController::class, 'memberBenefitImport']);
@@ -72,8 +81,12 @@ Route::prefix('internal')->group(function () {
 
         Route::get('corporates/{corporate_id}/members', [CorporateMemberController::class, 'index']);
         Route::post('corporates/{corporate_id}/members/import', [CorporateMemberController::class, 'import']);
+        Route::put('members/{member_id}/activation', [CorporateMemberController::class, 'activation']);
+
 
         Route::get('corporates/{corporate_id}/diagnosis-exclusions', [DiagnosisExclusionController::class, 'index']);
+        Route::post('corporates/{corporate_id}/diagnosis-exclusions/store', [DiagnosisExclusionController::class, 'storeExclusion']);
+        Route::delete('diagnosis-exclusions/{id}', [DiagnosisExclusionController::class, 'destroy']);
         Route::post('corporates/{corporate_id}/diagnosis-exclusions/import', [DiagnosisExclusionController::class, 'import']);
 
         Route::get('corporates/{corporate_id}/services', [CorporateServiceController::class, 'index']);
@@ -81,6 +94,7 @@ Route::prefix('internal')->group(function () {
         Route::get('corporates/{corporate_id}/services/{service_code}', [CorporateServiceController::class, 'corporateServiceIndex']);
         Route::put('corporates/{corporate_id}/services/{service_code}', [CorporateServiceController::class, 'corporateServiceUpdate']);
         Route::post('corporates/{corporate_id}/services/{service_code}/specialities', [CorporateServiceController::class, 'corporateServiceSpecialityUpdate']);
+        Route::post('corporates/{corporate_id}/services/{service_code}/specialities/exclusion', [CorporateServiceController::class, 'storeExclusion']);
 
         Route::get('corporates/{corporate_id}/formulariums', [CorporateFormulariumController::class, 'index']);
         Route::put('corporates/{corporate_id}/formulariums/{formularium_id}/{action}', [CorporateFormulariumController::class, 'updateStatus']);
@@ -97,13 +111,25 @@ Route::prefix('internal')->group(function () {
 
         Route::get('members', [MemberController::class, 'index']);
         Route::get('members/{member_id}/benefits', [MemberController::class, 'benefits']);
-        
+
         Route::get('claims', [ClaimController::class, 'index']);
         Route::post('claims', [ClaimController::class, 'store']);
         Route::get('claims/{id}', [ClaimController::class, 'show']);
         Route::post('check-limit', [ClaimController::class, 'checkLimit']);
+
+        Route::get('search-organizations', [OrganizationController::class, 'searchOrganization']);
+        Route::get('search-specialities', [SpecialityController::class, 'searchSpeciality']);
+        Route::resource('organizations', OrganizationController::class);
+        Route::resource('doctors', DoctorController::class);
+
+        Route::get('generate-log/{member_id}', [CorporateMemberController::class, 'generateLog']);
         
+        Route::get('claim-requests', [ClaimRequestController::class, 'index'])->name('claim-requests.index');
+        Route::post('claim-requests/{id}/approve', [ClaimRequestController::class, 'approve'])->name('claim-requests.approve');
     });
 
+    // Route::resource('organizations', OrganizationController::class);
+    // Route::resource('doctors', DoctorController::class);
+
     // Route::get('something', [DiagnosisExclusionController::class, 'index']);
 });

Modules/Internal/Routes/web.php

@@ -11,6 +11,8 @@
 |
 */
 
+use Modules\Internal\Http\Controllers\Api\CorporateMemberController;
+
 Route::prefix('internal')->group(function() {
     Route::get('/', 'InternalController@index');
-});
+});

Modules/Internal/Services/CorporateService.php

@@ -5,11 +5,12 @@ namespace Modules\Internal\Services;
 use App\Exceptions\ImportRowException;
 use App\Models\Benefit;
 use App\Models\Corporate;
+use App\Models\CorporateBenefit;
 use App\Models\Plan;
 use Box\Spout\Writer\Common\Creator\WriterEntityFactory;
 
 class CorporateService
-{    
+{
     protected function validatePlanRow($row)
     {
         if (empty($row['service_code'])) {
@@ -41,10 +42,8 @@ class CorporateService
 
             $this->validatePlanRow($plan_data);
 
-            $plan = Plan::updateOrCreate([
+            $plan = $corporate->plans()->updateOrCreate([
                 'service_code' => $plan_data['service_code'],
-                'corporate_id' => $corporate->id,
-                'code' => $plan_data['code'],
             ], $plan_data);
 
             return $plan;
@@ -61,10 +60,10 @@ class CorporateService
         if (empty($row['plan_code'])) {
             throw new ImportRowException(__('benefit.PLAN_CODE_REQUIRED'), 0, null, $row);
         }
-        if (empty($row['benefit_code'])) {
+        if (empty($row['code'])) {
             throw new ImportRowException(__('benefit.BENEFIT_CODE_REQUIRED'), 0, null, $row);
         }
-        if (empty($row['code'])) {
+        if (empty($row['corporate_benefit_code'])) {
             throw new ImportRowException(__('benefit.CUSTOMER_BENEFIT_CODE_REQUIRED'), 0, null, $row);
         }
         if (empty($row['description'])) {
@@ -83,21 +82,37 @@ class CorporateService
 
     public function handleBenefitRow(Corporate $corporate, $row)
     {
+
         try {
             $benefit_data = $row;
             $benefit_data["corporate_id"] = $corporate->id;
-
             $this->validateBenefitRow($benefit_data);
 
-            $plan = Benefit::updateOrCreate([
-                'service_code' => $benefit_data['service_code'],
-                'plan_code' => $benefit_data['plan_code'],
-                'corporate_id' => $corporate->id,
+
+            $plan = $corporate->plans()
+                            ->where('corporate_plan_id', $benefit_data['plan_code'])
+                            ->first();
+
+            // $corporate->plans->where('corporate_plan_id', $benefit_data['plan_code'])->first();
+            $benefit_data['plan_code'] = $plan->id;
+
+            $benefit = Benefit::updateOrCreate([
                 'code' => $benefit_data['code'],
+                'service_code' => $plan->service_code,
+            ], [
+                'code' => $benefit_data['code'],
+                'service_code' => $plan->service_code,
+                'active' => true
+            ]);
+
+            $corporateBenefit = $corporate->corporateBenefits()->updateOrCreate([
+                'benefit_id' => $benefit->id,
+                'plan_id' => $plan->id
             ], $benefit_data);
 
-            return $plan;
+            return $corporateBenefit;
         } catch (\Exception $e) {
+            // dd($e->getMessage());
             throw $e;
         }
     }

Modules/Internal/Services/ExclusionService.php

@@ -32,10 +32,10 @@ class ExclusionService
                         'service_code' => 'OP',
                         'type' => 'diagnosis'
                     ]);
-                    
+
                     if (!empty($excl_array[1])) { //msc
                         $msc = explode(',', $excl_array[1]);
-                        collect($msc)->each(function($m) use ($exclusion) {
+                        collect($msc)->each(function ($m) use ($exclusion) {
                             $exclusion->rules()->create([
                                 'name' => 'msc',
                                 'values' => $m
@@ -44,11 +44,18 @@ class ExclusionService
                     }
                     if (!empty($excl_array[2])) { //genders
                         $genders = explode(',', $excl_array[2]);
-                        collect($genders)->each(function($gender) use ($exclusion) {
-                            $exclusion->rules()->create([
-                                'name' => 'gender',
-                                'values' => $gender
-                            ]);
+                        collect($genders)->each(function ($gender) use ($exclusion) {
+                            if ($gender == 'M') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'male'
+                                ]);
+                            } else if ($gender == 'F') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'female'
+                                ]);
+                            }
                         });
                     }
                     if (!empty($excl_array[3])) { //min_age
@@ -84,10 +91,10 @@ class ExclusionService
                         'service_code' => 'OP',
                         'type' => 'diagnosis'
                     ]);
-                    
+
                     if (!empty($excl_array[1])) { //msc
                         $msc = explode(',', $excl_array[1]);
-                        collect($msc)->each(function($m) use ($exclusion) {
+                        collect($msc)->each(function ($m) use ($exclusion) {
                             $exclusion->rules()->create([
                                 'name' => 'msc',
                                 'values' => $m
@@ -96,11 +103,18 @@ class ExclusionService
                     }
                     if (!empty($excl_array[2])) { //genders
                         $genders = explode(',', $excl_array[2]);
-                        collect($genders)->each(function($gender) use ($exclusion) {
-                            $exclusion->rules()->create([
-                                'name' => 'gender',
-                                'values' => $gender
-                            ]);
+                        collect($genders)->each(function ($gender) use ($exclusion) {
+                            if ($gender == 'M') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'male'
+                                ]);
+                            } else if ($gender == 'F') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'female'
+                                ]);
+                            }
                         });
                     }
                     if (!empty($excl_array[3])) { //min_age
@@ -133,10 +147,10 @@ class ExclusionService
                         'service_code' => 'OP',
                         'type' => 'diagnosis'
                     ]);
-                    
+
                     if (!empty($excl_array[1])) { //msc
                         $msc = explode(',', $excl_array[1]);
-                        collect($msc)->each(function($m) use ($exclusion) {
+                        collect($msc)->each(function ($m) use ($exclusion) {
                             $exclusion->rules()->create([
                                 'name' => 'msc',
                                 'values' => $m
@@ -145,11 +159,18 @@ class ExclusionService
                     }
                     if (!empty($excl_array[2])) { //genders
                         $genders = explode(',', $excl_array[2]);
-                        collect($genders)->each(function($gender) use ($exclusion) {
-                            $exclusion->rules()->create([
-                                'name' => 'gender',
-                                'values' => $gender
-                            ]);
+                        collect($genders)->each(function ($gender) use ($exclusion) {
+                            if ($gender == 'M') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'male'
+                                ]);
+                            } else if ($gender == 'F') {
+                                $exclusion->rules()->create([
+                                    'name' => 'gender',
+                                    'values' => 'female'
+                                ]);
+                            }
                         });
                     }
                     if (!empty($excl_array[3])) { //min_age
@@ -177,7 +198,6 @@ class ExclusionService
                 $excl_array = explode('|', $row['ma_exclusion']);
                 dd($excl_array);
                 if ($excl_array[0]) {
-
                 }
             }
 
@@ -185,7 +205,6 @@ class ExclusionService
                 $excl_array = explode('|', $row['sp_exclusion']);
                 dd($excl_array);
                 if ($excl_array[0]) {
-
                 }
             }
 
@@ -193,7 +212,6 @@ class ExclusionService
                 $excl_array = explode('|', $row['pre_exist_exclusion']);
                 dd($excl_array);
                 if ($excl_array[0]) {
-
                 }
             }
 
@@ -201,7 +219,6 @@ class ExclusionService
                 $excl_array = explode('|', $row['op_de_exclusion']);
                 dd($excl_array);
                 if ($excl_array[0]) {
-
                 }
             }
 
@@ -209,7 +226,6 @@ class ExclusionService
                 $excl_array = explode('|', $row['maternity_waiting']);
                 dd($excl_array);
                 if ($excl_array[0]) {
-
                 }
             }
             return true;

Modules/Internal/Services/MemberEnrollmentService.php

@@ -10,10 +10,12 @@ use App\Models\CorporateDivision;
 use App\Models\CorporatePlan;
 use App\Models\Member;
 use App\Models\MemberPolicy;
+use App\Models\Person;
 use App\Models\Plan;
 use Box\Spout\Writer\Common\Creator\WriterEntityFactory;
 use Box\Spout\Common\Entity\Row;
 use Carbon\Carbon;
+use DateTime;
 use DB;
 
 class MemberEnrollmentService
@@ -27,7 +29,7 @@ class MemberEnrollmentService
         "Halodoc Member ID"                                                         => "halodoc_member_id",
         "Corporate ID"                                                              => "corporate_id",
         "NIK"                                                                       => "nik",
-        "Division"                                                                  => "division_code",
+        "Division"                                                                  => "division_name",
         "Branch Code"                                                               => "branch_code",
         "Bank Info"                                                                 => "banks_info",
         "Language"                                                                  => "language",
@@ -44,6 +46,7 @@ class MemberEnrollmentService
         "The Right Classes Room of  BPJS Participants"                              => "bpjs_class",
         "Name of Faskes"                                                            => "faskes_name",
         "Rule_BPJSK ('Y' or 'N')"                                                   => "bpjsk",
+        "Rule BPJSK"                                                                => "bpjsk",
         "Agent Code / intermediary code"                                            => "agent_code",
         "Member Name"                                                               => "name",
         "Address1"                                                                  => "address1",
@@ -89,7 +92,7 @@ class MemberEnrollmentService
         "Internal Use"                                                              => "internal_use_6",
         "StartNoClaim"                                                              => "start_no_claim",
         "EndNoClaim"                                                                => "end_no_claim",
-        "Option Mode"                                                               => "option_mode",        
+        "Option Mode"                                                               => "option_mode",
         "Policy Inforce"                                                            => "policy_in_force",
         "Renewal activation date"                                                   => "renewal_activation_date",
         "Renewal Activation Date"                                                   => "renewal_activation_date",
@@ -106,7 +109,7 @@ class MemberEnrollmentService
         "halodoc_member_id"                 => "Halodoc Member ID",
         "corporate_id"                      => "Corporate ID",
         "nik"                               => "NIK",
-        "division_code"                     => "Division",
+        "division_name"                     => "Division",
         "branch_code"                       => "Branch Code",
         "banks_info"                        => "Bank Info",
         "language"                          => "Language",
@@ -122,7 +125,7 @@ class MemberEnrollmentService
         "faskes_fkrtl"                      => "Faskes FKRTL (Next Level Provider) or Individual group preferred provider",
         "bpjs_class"                        => "The Right Classes Room of  BPJS Participants",
         "faskes_name"                       => "Name of Faskes",
-        "bpjsk"                             => "Rule_BPJSK ('Y' or 'N')",
+        "bpjsk"                             => "Rule BPJSK",
         "agent_code"                        => "Agent Code / intermediary code",
         "name"                              => "Member Name",
         "address1"                          => "Address1",
@@ -194,8 +197,8 @@ class MemberEnrollmentService
         "Faskes FKRTL (Next Level Provider) or Individual group preferred provider",
         "The Right Classes Room of  BPJS Participants",
         "Name of Faskes",
-        "Rule_BPJSK ('Y' or 'N')",
-        "Agent Code / intermediary code",
+        "Rule BPJSK",
+        "Internal Use",
         "Member Name",
         "Address1",
         "Address 1",
@@ -246,6 +249,10 @@ class MemberEnrollmentService
         $this->member = $member;
     }
 
+    public function dateParser($date_from_row) {
+        return is_string($date_from_row) ? Carbon::parse(strtotime($date_from_row)) : Carbon::parse($date_from_row);
+    }
+
     protected function validateRow($row)
     {
         if (empty($row['record_type'])) {
@@ -264,7 +271,7 @@ class MemberEnrollmentService
             if (!empty($row['principal_id'])) {
                 throw new ImportRowException(__('enrollment.PRINCIPAL_ID_NOT_REQUIRED'), 0, null, $row);
             }
-            
+
             if (empty($row['corporate_id'])) {
                 throw new ImportRowException(__('enrollment.CORPORATE_ID_REQUIRED'), 0, null, $row);
             }
@@ -306,34 +313,38 @@ class MemberEnrollmentService
             throw new ImportRowException(__('enrollment.INVALID_MARITAL_STATUS'), 0, null, $row);
         }
 
-        if (empty($row['member_effective_date']) ) {
+        if (empty($row['member_effective_date'])) {
             throw new ImportRowException(__('enrollment.MEMBER_EFFECTIVE_REQUIRED'), 0, null, $row);
         }
         // TODO EFFECTIVE DATE VALIDATION
 
-        if (empty($row['member_expiry_date']) ) {
+        if (empty($row['member_expiry_date'])) {
             throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_REQUIRED'), 0, null, $row);
         }
         // TODO EFFECTIVE DATE VALIDATION
 
         // TODO FKTP VALIDATION
         // TODO FKRTL VALIDATION
-        
+
         if (!empty($row['marital_status']) && !in_array($row['marital_status'], ['S', 'M', 'D'])) {
             throw new ImportRowException(__('enrollment.INVALID_MARITAL_STATUS'), 0, null, $row);
         }
-        
+
         if (empty($row['name'])) {
             throw new ImportRowException(__('enrollment.NAME_REQUIRED'), 0, null, $row);
         }
 
-        if (!empty($row['telephone_mobile'])
-        && !(substr($row['telephone_mobile'], 0, 4) == '+628' || substr($row['telephone_mobile'], 0, 3) == '628')) {
+        if (
+            !empty($row['telephone_mobile'])
+            && !(substr($row['telephone_mobile'], 0, 4) == '+628' || substr($row['telephone_mobile'], 0, 3) == '628')
+        ) {
             throw new ImportRowException(__('enrollment.PHONE_INVALID'), 0, null, $row);
         }
-        
-        if (!empty($row['email'])
-        && !filter_var($row['email'], FILTER_VALIDATE_EMAIL)) {
+
+        if (
+            !empty($row['email'])
+            && !filter_var($row['email'], FILTER_VALIDATE_EMAIL)
+        ) {
             throw new ImportRowException(__('enrollment.EMAIL_INVALID'), 0, null, $row);
         }
 
@@ -355,10 +366,10 @@ class MemberEnrollmentService
                 "member_id" => $row['member_id'] ?? null,
                 "payor_id" => $row['payor_id'] ?? null,
                 "nik" => $row['nik'] ?? null,
-                "birth_date" => Carbon::parse(strtotime($row['date_of_birth'])),
+                "birth_date" => $this->dateParser($row['date_of_birth']),
                 "gender" => Helper::genderNormalization($row['sex']),
-                "language" => $row['language'] ?? null,
-                "race" => $row['race'] ?? null,
+                // "language" => $row['language'] ?? null,
+                // "race" => $row['race'] ?? null,
                 "marital_status" => $row['marital_status'] ?? null,
                 "record_type" => $row['record_type'] ?? null,
                 "principal_id" => $row['principal_id'] ?? null,
@@ -396,16 +407,30 @@ class MemberEnrollmentService
             switch ($row['record_mode']) {
                 case "1": // New Member
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
-                                    // ->whereHas('employeds', function ($query) use ($corporate) {
-                                    //     $query->where('corporate_id', $corporate->id);
-                                    // })
-                                    ->first();
-                
+                        ->where('member_id', $row['member_id'])
+                        // ->whereHas('employeds', function ($query) use ($corporate) {
+                        //     $query->where('corporate_id', $corporate->id);
+                        // })
+                        ->first();
+
                     // Validate If Exist Member
                     if ($member) {
+                        $person = Person::updateOrCreate(
+                            [
+                                'id' => $member->person_id
+                            ],
+                            [
+                                'name' => $row['name'] ?? null,
+                                'birth_date' => $this->dateParser($row['date_of_birth']),
+                                'gender' => Helper::genderPerson($row['sex']),
+                                'language' => $row['language'] ?? null,
+                                'race' => $row['race'] ?? null,
+                            ]
+                        );
+                        $member->person_id = $person->id;
+                        $member->save();
                         throw new ImportRowException(__('enrollment.MEMBER_UNIQUE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     } else {
@@ -418,7 +443,7 @@ class MemberEnrollmentService
 
                     if ($memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -435,22 +460,44 @@ class MemberEnrollmentService
 
                     $this->validateRow($row);
 
+
                     try {
                         DB::beginTransaction();
                         $member->fill($member_data);
                         if ($member->save()) {
+
+                            $person = Person::create([
+                                'name' => $row['name'],
+                                'birth_date' => $this->dateParser($row['date_of_birth']),
+                                'gender' => Helper::genderPerson($row['sex']),
+                                'language' => $row['language'] ?? null,
+                                'race' => $row['race'] ?? null,
+                            ]);
+                            $member->person_id = $person->id;
+                            $member->save();
+
                             $memberPolicy = new MemberPolicy();
                             $memberPolicy->fill([
                                 'member_id' => $member->member_id,
                                 'policy_id' => $row['policy_number'],
-                                'start' => Carbon::parse(strtotime($row['member_effective_date'])),
-                                'end' => Carbon::parse(strtotime($row['member_expiry_date'])),
+                                'start' => $this->dateParser($row['member_effective_date']),
+                                'end' => $this->dateParser($row['member_expiry_date']),
                                 'status' => 'active'
                             ]);
                             $memberPolicy->save();
 
-                            if (!empty($row['division'])) {
-                                $division_id = CorporateDivision::where('code', $row['division_code'])->where('')->pluck('id');
+                            if (!empty($row['division_name'])) {
+                                $division_id = CorporateDivision::query()->where('code', $row['division_name'])->pluck('id')->first();
+
+                                if (empty($division_id)) {
+                                    $division = CorporateDivision::query()->updateOrCreate(['name' => $row['division_name'], 'code' => $row['division_name']], [
+                                        'corporate_id' => $corporate->id,
+                                        'name' => $row['division_name'],
+                                        'code' => $row['division_name'],
+                                    ]);
+
+                                    $division_id = $division->id;
+                                }
                             }
 
                             $member->employeds()->create([
@@ -464,8 +511,8 @@ class MemberEnrollmentService
                             $member->memberPlans()->create([
                                 'plan_id' => $plan->id,
                                 'status' => 'active',
-                                'start' => Carbon::parse(strtotime($row['member_effective_date'])),
-                                'end' => Carbon::parse(strtotime($row['member_expiry_date'])),
+                                'start' => $this->dateParser($row['member_effective_date']),
+                                'end' => $this->dateParser($row['member_expiry_date']),
                             ]);
                         }
                         DB::commit();
@@ -476,13 +523,13 @@ class MemberEnrollmentService
                     break;
                 case "2": // Member Information Update (Without Replacement Card)
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
-                                    ->first();
-                
+                        ->where('member_id', $row['member_id'])
+                        ->first();
+
                     // Validate If Exist Member
                     if (!$member) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_FOUND', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -496,23 +543,23 @@ class MemberEnrollmentService
 
                         if (!$memberPolicy) {
                             throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                                'member_id' => $row['member_id'], 
+                                'member_id' => $row['member_id'],
                                 'policy_id' => $row['policy_number']
                             ]), 0, null, $row);
                         }
-                        
+
                         if ($memberPolicy->status != 'active') {
                             throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                                'member_id' => $row['member_id'], 
+                                'member_id' => $row['member_id'],
                                 'policy_id' => $row['policy_number']
                             ]), 0, null, $row);
                         }
-                        
+
                         $memberPolicy->member->fill($member_data);
                         if (!$memberPolicy->member->isDirty()) {
                             throw new ImportRowException(__('enrollment.MEMBER_NO_CHANGE'), 0, null, $row);
                         }
-                        
+
                         $memberPolicy->member->save();
                         DB::commit();
                     } catch (\Exception $e) {
@@ -523,13 +570,13 @@ class MemberEnrollmentService
                     break;
                 case "3": // Member Deletion
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
-                                    ->first();
-                
+                        ->where('member_id', $row['member_id'])
+                        ->first();
+
                     // Validate If Exist Member
                     if (!$member) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_FOUND', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -541,21 +588,21 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
                     $member = $memberPolicy->member;
                     $member->active = false;
-                    
+
                     $member->save();
                     break;
                 case "5": // Member Renewal Policy (without card)
@@ -566,26 +613,27 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
-                    
+
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
 
-                    if (Carbon::parse(strtotime($row['member_effective_date'])) > Carbon::parse(strtotime($row['member_expiry_date']))) {
+                    if ($this->dateParser($row['member_effective_date']) > $this->dateParser($row['member_expiry_date'])) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
-                    if (Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
-                                    || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
-                        ) {
+                    if (
+                        Carbon::parse($memberPolicy->end) > $this->dateParser($row['member_expiry_date'])
+                        || $memberPolicy->end > $this->dateParser($row['member_expiry_date'])
+                    ) {
                         throw new ImportRowException(__('enrollment.MEMBER_RENEWAL_STILL_ACTIVE'), 0, null, $row);
                     }
 
@@ -609,25 +657,26 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
-                            'policy_id' => $row['policy_number']
-                        ]), 0, null, $row);
-                    }
-                    
-                    if ($memberPolicy->status != 'active') {
-                        throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
-                    if (Carbon::parse(strtotime($row['member_effective_date'])) > Carbon::parse(strtotime($row['member_expiry_date']))) {
+                    if ($memberPolicy->status != 'active') {
+                        throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
+                            'member_id' => $row['member_id'],
+                            'policy_id' => $row['policy_number']
+                        ]), 0, null, $row);
+                    }
+
+                    if ($this->dateParser($row['member_effective_date']) > $this->dateParser($row['member_expiry_date'])) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
-                    if (Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
-                                    || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
-                        ) {
+                    if (
+                        Carbon::parse($memberPolicy->end) > $this->dateParser($row['member_expiry_date'])
+                        || $memberPolicy->end > $this->dateParser($row['member_expiry_date'])
+                    ) {
                         throw new ImportRowException(__('enrollment.MEMBER_RENEWAL_STILL_ACTIVE'), 0, null, $row);
                     }
 
@@ -651,7 +700,7 @@ class MemberEnrollmentService
                     //         'policy_id' => $row['policy_number']
                     //     ]), 0, null, $row);
                     // }
-                    
+
                     // // Read Option Mode
                     // $option_mode = explode('!', $row['option_mode']);
                     // $corp_code = $option_mode[1] ?? null;
@@ -677,7 +726,7 @@ class MemberEnrollmentService
                     $member_id_old = $member_id[0] ?? null;
                     $member_id_new = $member_id[1] ?? null;
 
-                    
+
                     $memberPolicy = MemberPolicy::query()
                         ->where('policy_id', $policy_number_old)
                         ->where('member_id', $member_id_old)
@@ -686,14 +735,14 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $member_id_old, 
+                            'member_id' => $member_id_old,
                             'policy_id' => $policy_number_old
                         ]), 0, null, $row);
                     }
-                    
+
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $member_id_old, 
+                            'member_id' => $member_id_old,
                             'policy_id' => $policy_number_old
                         ]), 0, null, $row);
                     }
@@ -702,12 +751,12 @@ class MemberEnrollmentService
                         if (!empty($row['principal_id'])) {
                             throw new ImportRowException(__('enrollment.PRINCIPAL_ID_NOT_REQUIRED'), 0, null, $row);
                         }
-                        
+
                         if (empty($row['corporate_id'])) {
                             throw new ImportRowException(__('enrollment.CORPORATE_ID_REQUIRED'), 0, null, $row);
                         }
                     }
-            
+
                     if ($record_type_new == 'D') {
                         if (empty($row['principal_id'])) {
                             throw new ImportRowException(__('enrollment.PRINCIPAL_ID_REQUIRED'), 0, null, $row);
@@ -739,19 +788,19 @@ class MemberEnrollmentService
                     //         'policy_id' => $row['policy_number']
                     //     ]), 0, null, $row);
                     // }
-                    
+
                     try {
                         DB::beginTransaction();
-                        
-                        if ( !empty($record_type_new) ) {
+
+                        if (!empty($record_type_new)) {
                             $member = $memberPolicy->member;
                             $member->record_type = $record_type_new;
                             $member->principal_id = $row['principal_id'];
 
                             $member->save();
                         }
-    
-                        if ( !empty($corp_code_new) ) {
+
+                        if (!empty($corp_code_new)) {
                             $oldCorporate = Corporate::where('code', $corp_code_old)->first();
                             $newCorporate = Corporate::where('code', $corp_code_new)->first();
 
@@ -759,24 +808,26 @@ class MemberEnrollmentService
                                 throw new ImportRowException(__('enrollment.CORPORATE_NOT_FOUND'), 0, null, $row);
                             }
                             $corporateEmployee = CorporateEmployee::where('corporate_id', $oldCorporate->id)
-                                                                ->where('member_id', $memberPolicy->member->id)
-                                                                ->first();
-                            $newCorporateEmployee = CorporateEmployee::updateOrCreate([
-                                'corporate_id' => $oldCorporate->id,
-                                'member_id' => $memberPolicy->member->id
-                            ],
-                            [
-                                'corporate_id' => $newCorporate->id,
-                                'member_id' => $memberPolicy->member->id
-                            ]);
+                                ->where('member_id', $memberPolicy->member->id)
+                                ->first();
+                            $newCorporateEmployee = CorporateEmployee::updateOrCreate(
+                                [
+                                    'corporate_id' => $oldCorporate->id,
+                                    'member_id' => $memberPolicy->member->id
+                                ],
+                                [
+                                    'corporate_id' => $newCorporate->id,
+                                    'member_id' => $memberPolicy->member->id
+                                ]
+                            );
                         }
 
-                        if ( !empty($policy_number_new) ) {
+                        if (!empty($policy_number_new)) {
                             $memberPolicy->policy_id = $policy_number_new;
                             $memberPolicy->save();
                         }
 
-                        if ( !empty($member_id_new) ) {
+                        if (!empty($member_id_new)) {
                             $memberPolicy->member_id = $member_id_new;
                             $memberPolicy->save();
 
@@ -800,16 +851,16 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
-                    if (Carbon::parse(strtotime($row['member_effective_date'])) < now() || Carbon::parse(strtotime($row['member_expiry_date'])) < now()) {
+                    if ($this->dateParser($row['member_effective_date']) < now() || $this->dateParser($row['member_expiry_date']) < now()) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_MUST_BE_AFTER_TODAY'), 0, null, $row);
                     }
-                    
-                    if (Carbon::parse(strtotime($row['member_effective_date'])) > Carbon::parse(strtotime($row['member_expiry_date']))) {
+
+                    if ($this->dateParser($row['member_effective_date']) > $this->dateParser($row['member_expiry_date'])) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
@@ -828,14 +879,14 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
 
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -844,17 +895,17 @@ class MemberEnrollmentService
                     $newMemberPolicy->fill([
                         'member_id' => $row['member_id'],
                         'policy_id' => $row['policy_number'],
-                        'start' => Carbon::parse(strtotime($row['member_effective_date'])),
-                        'end' => Carbon::parse(strtotime($row['member_expiry_date'])),
+                        'start' => $this->dateParser($row['member_effective_date']),
+                        'end' => $this->dateParser($row['member_expiry_date']),
                         'status' => 'active'
                     ]);
                     $newMemberPolicy->save();
                     break;
 
-                    
-                    
 
-                // THESE MODES BELOW ARE DISABLED
+
+
+                    // THESE MODES BELOW ARE DISABLED
                 case "4": // Member Update Start and End Date
                     throw new ImportRowException(__('MODE 4 NOT HANDLED PROPERLY, TRY TO USE MODE 2'), 0, null, $row);
                     break;
@@ -865,14 +916,14 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
-                    
+
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -886,7 +937,7 @@ class MemberEnrollmentService
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_NO_CHANGE'), 0, null, $row);
                     }
 
-                    if (Carbon::parse(strtotime($row['member_effective_date'])) > Carbon::parse(strtotime($row['member_expiry_date']))) {
+                    if ($this->dateParser($row['member_effective_date']) > $this->dateParser($row['member_expiry_date'])) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
@@ -896,9 +947,9 @@ class MemberEnrollmentService
                 case "8": // Member Information Update (With Replacement Card)
                     throw new ImportRowException(__('MODE 8 NOT HANDLED PROPERLY, TRY TO USE MODE 2'), 0, null, $row);
                     break;
-                // case "10": // No Information Available
+                    // case "10": // No Information Available
 
-                //     break;
+                    //     break;
                 case "11": // Advance Renewal with OLD Card No. (PRINT)
 
                     throw new ImportRowException(__('MODE 11 NOT HANDLED PROPERLY, TRY TO USE MODE 13'), 0, null, $row);
@@ -907,9 +958,9 @@ class MemberEnrollmentService
 
                     throw new ImportRowException(__('MODE 12 NOT HANDLED PROPERLY, TRY TO USE MODE 13'), 0, null, $row);
                     break;
-                // case "14": // No Information Available
+                    // case "14": // No Information Available
 
-                //     break;
+                    //     break;
                 case "15": // Lost Card / Change Card with new card number (Print) (Rarely Used)
 
                     throw new ImportRowException(__('MODE 15 NOT HANDLED PROPERLY, TRY TO USE MODE 2'), 0, null, $row);
@@ -918,10 +969,10 @@ class MemberEnrollmentService
                     throw new ImportRowException(__('MODE 16 NOT HANDLED PROPERLY, TRY TO USE MODE 2'), 0, null, $row);
                     break;
                     $plan = CorporatePlan::query()
-                                ->where('corporate_id', $corporate->id)
-                                ->where('code', $row['plan_id'])
-                                ->where('active', true)
-                                ->first();
+                        ->where('corporate_id', $corporate->id)
+                        ->where('code', $row['plan_id'])
+                        ->where('active', true)
+                        ->first();
                     if (!$plan) {
                         throw new ImportRowException(__('enrollment.PLAN_NOT_FOUND'), 0, null, $row);
                     }
@@ -933,14 +984,14 @@ class MemberEnrollmentService
 
                     if (!$memberPolicy) {
                         throw new ImportRowException(__('enrollment.MEMBER_NOT_EXISTS', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
-                    
+
                     if ($memberPolicy->status != 'active') {
                         throw new ImportRowException(__('enrollment.MEMBER_INACTIVE', [
-                            'member_id' => $row['member_id'], 
+                            'member_id' => $row['member_id'],
                             'policy_id' => $row['policy_number']
                         ]), 0, null, $row);
                     }
@@ -971,14 +1022,22 @@ class MemberEnrollmentService
         $cells = [];
         foreach ($this->result_doc_headers as $header) {
             $value = $row_data[$this->doc_headers_to_field_map[$header]] ?? null;
-            $cells[] = WriterEntityFactory::createCell($value);
+            if (is_string($value)) {
+                $cells[] = WriterEntityFactory::createCell($value);
+            } 
+            else if ($value instanceof DateTime) {
+                $cells[] = WriterEntityFactory::createCell(Carbon::parse($value)->format('Ymd'));
+            } 
+            else {
+                $cells[] = WriterEntityFactory::createCell(null);
+            }
         }
 
         return $cells;
     }
 
     // This returning row with format or order as it is
-    public function makeResultRow($row_data) 
+    public function makeResultRow($row_data)
     {
         $cells = [];
         foreach ($row_data as $cellValue) {

Modules/Internal/Transformers/ClaimRequestResource.php

@@ -0,0 +1,33 @@
+<?php
+
+namespace Modules\Internal\Transformers;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class ClaimRequestResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        $filesGroupByType = $this->files->mapToGroups(function($file) {
+            return [$file->type => $file];
+        });
+
+        $data = [
+            'id' => $this->id,
+            'code' => $this->code,
+            'submission_date' => $this->submission_date,
+            'member' => $this->member,
+            'status' => $this->status ?? 'unknown',
+            'service_type' => $this->service_type,
+            'files_by_type' => $filesGroupByType
+        ];
+
+        return $data;
+    }
+}

Modules/Internal/Transformers/CorporateServiceConfigResource.php

@@ -15,15 +15,83 @@ class CorporateServiceConfigResource extends JsonResource
     public function toArray($request)
     {
 
-        return [
+        $data =  [
             'id' => $this->id,
             'corporate_id' => $this->corporate_id,
             'service_code' => $this->service_code,
             'status' => $this->status,
-            'name' => $this->service->name,
-            'description' => $this->service->description,
+            'name' => $this->service->name ?? '-',
+            'description' => $this->service->description ?? '-',
             'configurations' => $this->configs->pluck('value', 'name'),
-            'selected_specialities' => $this->specialities->pluck('speciality.name', 'speciality_id')
+            'selected_specialities' => $this->corporateServiceSpecialities->where('active', true)->pluck('speciality.name', 'speciality_id'),
+            'exclusions' => $this->corporateServiceSpecialities->map(function ($speciality) {
+                return [
+                    'speciality_id' => $speciality->speciality_id,
+                    // 'rules' => $speciality->exclusions->first()->rules->map(
+                    //     function ($rule) {
+                    //         return [
+                    //             'name' => $rule->name,
+                    //             'value' => explode(',', $rule->values)
+                    //         ];
+                    //     }
+                    // ),
+
+                ];
+            }),
         ];
+
+        $list_msc = $this->corporateServiceSpecialities->map(function ($speciality) {
+            return  explode(',', $speciality->exclusions->first()->rules->where('name', 'msc')->first()->values ?? '');
+        })->map(function ($item) {
+            return [
+                'm' => in_array('m', $item),
+                's' => in_array('s', $item),
+                'c' => in_array('c', $item),
+            ];
+        });
+
+        $list_gender = $this->corporateServiceSpecialities->map(function ($speciality) {
+            // dd($speciality->exclusions->first()->rules);
+            return  explode(',', $speciality->exclusions->first()->rules->where('name', 'gender')->first()->values ?? '');
+        })->map(function ($item) {
+
+            return [
+                'male' => in_array('male', $item),
+                'female' => in_array('female', $item),
+            ];
+        });
+
+        $min_age = $this->corporateServiceSpecialities->map(function ($speciality) {
+            return  $speciality->exclusions->first()->rules->where('name', 'min_age')->first()->values ?? '';
+        });
+
+        $max_age = $this->corporateServiceSpecialities->map(function ($speciality) {
+            return  $speciality->exclusions->first()->rules->where('name', 'max_age')->first()->values ?? '';
+        });
+
+        $plan = $this->corporateServiceSpecialities->map(function ($speciality) {
+            return $speciality->exclusions->first()->rules->where('name', 'plan')->first()->values ?? null;
+        });
+
+        $data['exclusions'] = $data['exclusions']->map(function ($item, $key) use (
+            $list_msc,
+            $list_gender,
+            $min_age,
+            $max_age,
+            $plan,
+        ) {
+            $item['msc'] = $list_msc[$key];
+            $item['gender'] = $list_gender[$key];
+            $item['min_age'] = $min_age[$key];
+            $item['max_age'] = $max_age[$key];
+            $item['plan'] = $plan[$key];
+            return $item;
+        });
+
+
+
+
+
+        return $data;
     }
 }

Modules/Internal/Transformers/DiagnosisExclusionResource.php

@@ -14,7 +14,7 @@ class DiagnosisExclusionResource extends JsonResource
      */
     public function toArray($request)
     {
-        return [
+        $data = [
             'id' => $this->id,
             'code' => $this->exclusionable->code,
             'name' => $this->exclusionable->name,
@@ -25,5 +25,36 @@ class DiagnosisExclusionResource extends JsonResource
                 return [$item['name'] => $item['values']];
             })
         ];
+
+        $msc = explode(',', $this->rules->where('name', 'msc')->first()->values ?? '');
+        $list_msc = [
+            'm' => in_array('m', $msc),
+            's' => in_array('s', $msc),
+            'c' => in_array('c', $msc),
+        ];
+
+        $gender = explode(',', $this->rules->where('name', 'gender')->first()->values ?? '');
+        $list_gender = [
+            'male' => in_array('male', $gender),
+            'female' => in_array('female', $gender),
+        ];
+
+        $min_age = $this->rules->where('name', 'min_age')->first()->values ?? '';
+        $max_age = $this->rules->where('name', 'max_age')->first()->values ?? '';
+        $plan = $this->rules->where('name', 'plan')->first()->values ?? '';
+
+        $value_plan = [
+            'plan' => $plan,
+            'gender' => $list_gender,
+            'msc' => $list_msc,
+            'min_age' => $min_age,
+            'max_age' => $max_age,
+        ];
+
+        $data['value_rules'] = $value_plan;
+
+
+
+        return $data;
     }
 }

Modules/Internal/Transformers/DoctorResource.php

@@ -0,0 +1,53 @@
+<?php
+
+namespace Modules\Internal\Transformers;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class DoctorResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        $doctor = [
+            'id' => $this->id,
+            // 'his_dokter_id' => $this->practitionerRoles->meta,
+            'name' => $this->person->name,
+            'person_id' => $this->person->id,
+            'phone' => $this->person->phone,
+            'email' => $this->person->email,
+            'gender' => $this->person->gender == "L" ? 'Laki-laki' : 'Perempuan',
+            'address' => $this->person->currentAddress->text,
+            'organizations' => $this->practitionerRoles->unique('organization_id')->map(function ($practitionerRole) {
+                return [
+                    'organization_id' => $practitionerRole->organization->id,
+                    'organization_name' => $practitionerRole->organization->name,
+                ];
+            }),
+            "specialties" => $this->practitionerRoles->unique('speciality_id')->map(function ($practitionerRole) {
+                return [
+                    'specialty_id' => $practitionerRole->speciality->id,
+                    'specialty_name' => $practitionerRole->speciality->name,
+                ];
+            }),
+            "departemen" => $this->practitionerRoles->map(function ($practitionerRole) {
+                return [
+                    'departemen_id' => $practitionerRole->meta->DepartemenID,
+                ];
+            }),
+            'education' => $this->meta->education,
+            'experience' => $this->meta->work_experience,
+            'award' => $this->meta->award,
+            'keilmuan' => $this->meta->Keilmuan,
+            'tipe_dokter' => $this->meta->tipeDokter,
+
+        ];
+
+        return $doctor;
+    }
+}

Modules/Internal/Transformers/OrganizationResource.php

@@ -0,0 +1,32 @@
+<?php
+
+namespace Modules\Internal\Transformers;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class OrganizationResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        $organization = [
+            'id' => $this->id,
+            'name' => $this->name,
+            'type' => $this->type,
+            'code' => $this->code,
+            'description' => $this->description,
+            'kodeRs' => $this->meta->kodeRs ?? null,
+            'phone' => $this->meta->phone ?? null,
+            'lat' => $this->currentAddress->lat ?? null,
+            'lng' => $this->currentAddress->lng ?? null,
+            'address' => $this->currentAddress ?? null,
+        ];
+
+        return $organization;
+    }
+}

Modules/Internal/module.json

@@ -5,7 +5,8 @@
     "keywords": [],
     "priority": 0,
     "providers": [
-        "Modules\\Internal\\Providers\\InternalServiceProvider"
+        "Modules\\Internal\\Providers\\InternalServiceProvider",
+        "Modules\\Internal\\Providers\\EventServiceProvider"
     ],
     "aliases": {},
     "files": [],

app/Events/ClaimApproved.php

@@ -0,0 +1,39 @@
+<?php
+
+namespace App\Events;
+
+use App\Models\Claim;
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimApproved
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    public $claim;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct(Claim $claim)
+    {
+        $this->claim = $claim;
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Events/ClaimDeclined.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Events;
+
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimDeclined
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Events/ClaimPaid.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Events;
+
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimPaid
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Events/ClaimPostpone.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Events;
+
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimPostpone
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Events/ClaimReceived.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Events;
+
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimReceived
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Events/ClaimRequested.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Events;
+
+use Illuminate\Broadcasting\Channel;
+use Illuminate\Broadcasting\InteractsWithSockets;
+use Illuminate\Broadcasting\PresenceChannel;
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
+use Illuminate\Foundation\Events\Dispatchable;
+use Illuminate\Queue\SerializesModels;
+
+class ClaimRequested
+{
+    use Dispatchable, InteractsWithSockets, SerializesModels;
+
+    /**
+     * Create a new event instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the channels the event should broadcast on.
+     *
+     * @return \Illuminate\Broadcasting\Channel|array
+     */
+    public function broadcastOn()
+    {
+        return new PrivateChannel('channel-name');
+    }
+}

app/Exceptions/ImportRowException.php

@@ -8,10 +8,10 @@ use Throwable;
 class ImportRowException extends Exception
 {
     protected $data = null;
-    
+
     public function __construct($message, $code = 0, Throwable $previous = null, $data)
     {
-        parent::__construct($message, $code, $previous);
+        parent::__construct($message, (int)$code, $previous);
         $this->data = $data;
     }
 

app/Helpers/Helper.php

@@ -24,6 +24,21 @@ class Helper
         }
     }
 
+    public static function genderPerson($anyGenderCode)
+    {
+        if ($anyGenderCode == 'M') {
+            return 'L';
+        } else if ($anyGenderCode == 'F') {
+            return 'P';
+        } else if ($anyGenderCode == 'O') {
+            return 'others';
+        } else if ($anyGenderCode == 'U') {
+            return 'unknown';
+        } else {
+            return null;
+        }
+    }
+
     public static function paginateResources($resource)
     {
         return [
@@ -35,6 +50,8 @@ class Helper
             'last_page_url' => '',
             'links' => $resource->links(null, $resource->items()),
             'next_page_url' => $resource->nextPageUrl(),
+            'per_page' => $resource->perPage(),
+            'total' => $resource->total()
         ];
     }
 
@@ -158,10 +175,10 @@ class Helper
      * @param  string  $message
      * @return JsonResponse
      */
-    public static function responseJson(array|object $data = [], int $statusCode = Response::HTTP_OK, string $message = 'Data berhasil di ambil'): JsonResponse
+    public static function responseJson(array|object $data = [], string $status = 'success', int $statusCode = Response::HTTP_OK, string $message = 'Data berhasil di ambil'): JsonResponse
     {
         return response()->json([
-            'status' => in_array($statusCode, [200, 201, 204]) ? 'success' : 'error',
+            'status' => $status,
             'statusCode' => $statusCode,
             'message' => $message,
             'data' => $data,

app/Http/Controllers/Api/MemberController.php

@@ -1,104 +0,0 @@
-<?php
-
-namespace App\Http\Controllers\Api;
-
-use App\Http\Controllers\Controller;
-use App\Models\Member;
-use Illuminate\Http\Request;
-
-class MemberController extends Controller
-{
-    /**
-     * Display a listing of the resource.
-     *
-     * @return \Illuminate\Http\Response
-     */
-    public function index()
-    {
-        $members = [];
-        
-        $faker = \Faker\Factory::create();
-
-        for ($i = 0; $i < 10; $i++) {
-            $members[] = [
-                'id' => (10-$i),
-                'code' => 'UT0000'.sprintf("%02d", 10-$i),
-                'nik' => 'UNTR0000'.sprintf("%02d", $i),
-                'name' => $faker->name,
-                'plan_code' => collect(['PLAN001', 'PLAN002', 'PLAN003', 'PLAN004', 'PLAN005'])->random(),
-                'number_of_families' => random_int(2,4),
-                'number_of_claim' => random_int(0,2),
-                'active' => true,
-                'history' => []
-            ];
-        }
-
-        return $members;
-    }
-
-    /**
-     * Show the form for creating a new resource.
-     *
-     * @return \Illuminate\Http\Response
-     */
-    public function create()
-    {
-        //
-    }
-
-    /**
-     * Store a newly created resource in storage.
-     *
-     * @param  \Illuminate\Http\Request  $request
-     * @return \Illuminate\Http\Response
-     */
-    public function store(Request $request)
-    {
-        //
-    }
-
-    /**
-     * Display the specified resource.
-     *
-     * @param  int  $id
-     * @return \Illuminate\Http\Response
-     */
-    public function show($id)
-    {
-        //
-    }
-
-    /**
-     * Show the form for editing the specified resource.
-     *
-     * @param  int  $id
-     * @return \Illuminate\Http\Response
-     */
-    public function edit($id)
-    {
-        //
-    }
-
-    /**
-     * Update the specified resource in storage.
-     *
-     * @param  \Illuminate\Http\Request  $request
-     * @param  int  $id
-     * @return \Illuminate\Http\Response
-     */
-    public function update(Request $request, $id)
-    {
-        //
-    }
-
-    /**
-     * Remove the specified resource from storage.
-     *
-     * @param  int  $id
-     * @return \Illuminate\Http\Response
-     */
-    public function destroy($id)
-    {
-        //
-    }
-}

app/Http/Controllers/Api/MembershipController.php

@@ -1,58 +0,0 @@
-<?php
-
-namespace App\Http\Controllers\Api;
-
-use App\Helpers\Helper;
-use App\Http\Controllers\Controller;
-use App\Models\Member;
-use App\Services\ClaimService;
-use Illuminate\Http\Request;
-
-class MembershipController extends Controller
-{
-    //
-    public function check(Request $request) 
-    {
-        $request->validate([
-            'member_id' => 'required',
-            'birth_date' => 'required',
-        ]);
-
-        $member = Member::where('member_id', $request->member_id)->first();
-
-        if (!$member) {
-            return Helper::responseJson(statusCode: 404, message: 'Member not found.');
-        }
-
-        if (!$member->active) {
-            return Helper::responseJson(statusCode: 406, message: 'The Member '.$request->member_id.' is Inactive.');
-        }
-
-        
-        return Helper::responseJson(data: $member, message: 'Member Found');
-    }
-
-    public function checkLimit(Request $request)
-    {
-        $request->validate([
-            'member_id' => 'required',
-            'type' => 'required|in:consultation-gp,consultation-specialist,medicine'
-        ]);
-
-        if ($request->type == 'consultation-gp') {
-            $benefitCode = 'OPCONS1';
-        }
-        if ($request->type == 'consultation-specialist') {
-            $benefitCode = 'OPCONS2';
-        }
-        if ($request->type == 'medicine') {
-            $benefitCode = 'OPMEDI1';
-        }
-
-        $member = Member::where('member_id', $request->member_id)->with(['currentCorporate', 'currentPolicy', 'currentPlan'])->first();
-
-        $limits = ClaimService::showMemberBenefitLimit($member, $benefitCode);
-
-        return Helper::responseJson(data: $limits);
-    }
-}

app/Http/Controllers/Api/OLDLMS/ClaimController.php

@@ -0,0 +1,88 @@
+<?php
+
+namespace App\Http\Controllers\Api\OLDLMS;
+
+use App\Helpers\Helper;
+use App\Http\Controllers\Controller;
+use App\Models\Icd;
+use App\Models\Member;
+use App\Models\Claim;
+use App\Models\Speciality;
+use App\Services\ClaimService;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class ClaimController extends Controller
+{
+    public function store(Request $request)
+    {
+        $request->validate([
+            'member_id' => 'required',
+            'user_id' => 'required',
+            'type' => 'required|in:consultation,teleconsultation,medicine',
+            // 'speciality_code' => 'required',
+            'total_claim' => 'required',
+            'detail' => 'required',
+        ]);
+
+        $currentSpeciality = Speciality::where('code', $request->speciality_code)->first();
+        
+        $gpSpecialityName = config('aso.general_practitioner_speciality_name', 'Umum');
+        $isGp = $gpSpecialityName == ($currentSpeciality ? $currentSpeciality->name : false);
+
+        if ($request->type == 'medicine') {
+            $benefitCode = 'OPMEDI1';
+        } else if ($isGp) {
+            $benefitCode = 'OPCONS1';
+        } else {
+            $benefitCode = 'OPCONS2';
+        }
+
+        $member = Member::query()
+                        ->where('member_id', $request->member_id)
+                        ->with([
+                            'currentPlan',
+                        ])
+                        ->firstOrFail();
+        $benefit = $member->currentPlan->benefits()->where('code', $benefitCode)->first();
+        
+        $claim = ClaimService::storeClaim($member, null, $request->total_claim, $benefit, 'requested');
+        $claim->status = 'approved';
+        $claim->save();
+        
+        return Helper::responseJson($claim);
+    }
+
+    public function updateClaimDiagnosis(Request $request)
+    {
+        $request->validate([
+            'claim_code' => 'required',
+            'icd_codes' => 'required'
+        ]);
+
+        $claim = Claim::where('code', $request->claim_code)->firstOrFail();
+
+        try {
+            DB::beginTransaction();
+            $claim->fill(['status' => 'postpone'])->update();
+
+            $icds = Icd::whereIn('code', $request['icd_codes'])->get();
+            $icds = $icds->map(function($icd) use ($claim) {
+                return [
+                    'claim_id' => $claim->id,
+                    'type' => 'primary',
+                    'diagnosis_id' => $icd->id,
+                    'note' => 'HIS Summary',
+                    'description'=> ''
+                ];
+            })->toArray();
+
+            return $claim->diagnoses()->insert($icds);
+            DB::commit();
+        } catch (\Exception $e) {
+            DB::rollback();
+
+            return Helper::responseJson($e, 500);
+        };
+    }
+}

app/Http/Controllers/Api/OLDLMS/MembershipController.php

@@ -0,0 +1,172 @@
+<?php
+
+namespace App\Http\Controllers\Api\OLDLMS;
+
+use App\Helpers\Helper;
+use App\Http\Controllers\Controller;
+use App\Models\Member;
+use App\Services\ClaimService;
+use Illuminate\Http\Request;
+
+class MembershipController extends Controller
+{
+    //
+    public function check(Request $request)
+    {
+        $request->validate([
+            'member_id' => 'required',
+            // 'birth_date' => 'required',
+        ]);
+
+        $member = Member::where('member_id', $request->member_id)->first();
+
+        if (!$member) {
+            return Helper::responseJson(statusCode: 404, message: 'Member not found.', status: 'error');
+        }
+
+        if (!$member->active) {
+            return Helper::responseJson(statusCode: 406, message: 'The Member ' . $request->member_id . ' is Inactive.', status: 'error');
+        }
+
+        return Helper::responseJson(data: $member, message: 'Member Found');
+    }
+
+    public function checkLimit(Request $request)
+    {
+        $request->validate([
+            'member_id' => 'required',
+            'type' => 'required|in:consultation,teleconsultation,medicine',
+            // 'speciality_code' => 'sometimes'
+        ]);
+
+        $member = Member::query()
+            ->where('member_id', $request->member_id)
+            ->with(['currentCorporate', 'currentPolicy', 'currentPlan', 'postponedClaims'])
+            ->first();
+
+        $corporateService = $member->currentCorporate->corporateServices()
+            ->active()
+            ->where('service_code', 'OP')
+            ->with([
+                'configs',
+                'specialities' => function ($speciality) use ($request) {
+                    $speciality->where('code', $request->speciality_code ?? null)
+                        ->wherePivot('active', 1);
+                }
+            ])
+            ->first();
+
+        $currentSpeciality = $corporateService->specialities->first();
+
+        if ($currentSpeciality) {
+            $corporateService->load([
+                'corporateServiceSpecialities' => function ($corporateServiceSpeciality) use ($currentSpeciality) {
+                    $corporateServiceSpeciality->where('speciality_id', $currentSpeciality->id);
+                },
+                'corporateServiceSpecialities.exclusions' => function ($exclusion) {
+                    $exclusion->where('service_code', 'OP');
+                },
+                'corporateServiceSpecialities.exclusions.rules'
+            ]);
+        }
+
+        $corporateServiceSpeciality = $corporateService->corporateServiceSpecialities->first() ?? null;
+
+        $serviceSpecialityRules = $corporateServiceSpeciality->exclusions->first()->rules ?? collect([]);
+        $serviceSpecialityRules = $serviceSpecialityRules->mapWithKeys(function ($rule) {
+            return [$rule->name => $rule];
+        });
+
+        $configs = $corporateService->configs->mapWithKeys(function ($config) {
+            return [$config->name => $config];
+        });
+
+        $gpSpecialityName = config('aso.general_practitioner_speciality_name', 'Umum');
+        $isGp = $gpSpecialityName == ($currentSpeciality ? $currentSpeciality->name : false);
+
+        if ($request->type == 'medicine') {
+            $benefitCode = 'OPMEDI1';
+        } else if ($isGp) {
+            $benefitCode = 'OPCONS1';
+        } else {
+            $benefitCode = 'OPCONS2';
+        }
+
+        $limits = ClaimService::showMemberBenefitLimit($member, $benefitCode);
+        $limits['postponed_claims'] = $member->postponedClaims;
+        $limits['postponed_claims_payment_url'] = route('postpone-pay', $member->member_id);
+        $limits['postponed_claims_unpaid_total'] = $member->postponedClaims->sum('total_claim');
+
+        $coverage['medicine_benefit'] = false;
+        if ($benefitCode = 'OPMEDI1') {
+            $medicineBenefit = $member->currentPlan->benefits()->where('code', $benefitCode)->wherePivot('active', 1)->first();
+            $coverage['medicine_benefit'] = !empty($medicineBenefit);
+        }
+        $coverage['medicine_delivery_fee'] = (($configs['delivery_fee']['value'] ?? 1) == 1);
+
+        if ($currentSpeciality) {
+            $xCoverage['sp_consultation_benefit'] = (($configs['sp_internal_doctor_offline']['value'] ?? 1) == 1);
+            $xCoverage['sp_teleconsultation_benefit'] = (($configs['sp_internal_doctor_online']['value'] ?? 1) == 1);
+            $xCoverage['gp_consultation_benefit'] = (($configs['gp_internal_doctor_offline']['value'] ?? 1) == 1);
+            $xCoverage['gp_teleconsultation_benefit'] = (($configs['gp_internal_doctor_online']['value'] ?? 1) == 1);
+            $coverage['consultation_benefit'] = ($isGp)
+                ? $xCoverage['gp_consultation_benefit']
+                : $xCoverage['sp_consultation_benefit'];
+            $coverage['teleconsultation_benefit'] = ($isGp)
+                ? $xCoverage['gp_teleconsultation_benefit']
+                : $xCoverage['sp_teleconsultation_benefit'];
+
+            $xCoverage['sp_admin_fee'] = (($configs['specialist_practitioner_fee']['value'] ?? 1) == 1);
+            $xCoverage['gp_admin_fee'] = (($configs['general_practitioner_fee']['value'] ?? 1) == 1);
+            $coverage['admin_fee'] = ($isGp)
+                ? $xCoverage['gp_admin_fee']
+                : $xCoverage['sp_admin_fee'];
+        } else {
+            // Not Supported
+            $coverage['consultation_benefit'] = false;
+            $coverage['teleconsultation_benefit'] = false;
+            $coverage['admin_fee'] = false;
+        }
+
+        $limits['coverage'] = $coverage;
+
+        // TODO THIS EXCLUSION IS USED AS INCLUSION NOW, MUST BE CHANGE TO USED AS EXCLUSION AND MAYBE MOVE THE TABLE
+        $excluded = [];
+        foreach ($serviceSpecialityRules as $ruleName => $rule) {
+            if ($ruleName == 'msc') {
+                $values = explode(',', $rule->values);
+                if (!in_array(strtolower($member->marital_status), $values)) {
+                    $excluded[] = $rule;
+                }
+            }
+
+            if ($ruleName == 'gender') {
+                $values = explode(',', $rule->values);
+                if (!in_array(strtolower($member->gender), $values)) {
+                    $excluded[] = $rule;
+                }
+            }
+
+            if ($ruleName == 'min_age') {
+                if (!empty($rule->values) && $member->age < $rule->values) {
+                    $excluded[] = $rule;
+                }
+            }
+
+            if ($ruleName == 'max_age') {
+                if (!empty($rule->values) && $member->age > $rule->values) {
+                    $excluded[] = $rule;
+                }
+            }
+
+            if ($ruleName == 'plan') {
+                $values = explode(',', $rule->values);
+                if (!in_array($member->currentPlan->code, $values)) {
+                    $excluded[] = $rule;
+                }
+            }
+        }
+
+        return Helper::responseJson(data: $limits);
+    }
+}

app/Http/Controllers/Api/OLDLMS/PaymentController.php

@@ -0,0 +1,55 @@
+<?php
+
+namespace App\Http\Controllers\Api\OLDLMS;
+
+use App\Http\Controllers\Controller;
+use App\Models\Member;
+use App\Services\Duitku;
+use Illuminate\Http\Request;
+use Str;
+
+class PaymentController extends Controller
+{
+    public function postponePay($memberId) 
+    {
+        $member = Member::where('member_id', $memberId)->with('postponedClaims')->firstOrFail();
+
+        $totalBill = $member->postponedClaims->sum('total_claim');
+
+        $config_duitku = [
+            'merchant_code' =>  env('DUITKU_MERCHANT_CODE'),
+            'merchant_key' =>  env('DUITKU_MERCHANT_KEY'),
+        ];
+        $paymentService = new Duitku($config_duitku);
+        
+        $invoice = (object) [
+            'invoice_number' => 'INV'.Str::random(5, 5),
+        ];
+        
+        $user = (object) [
+            'email' => $member->email,
+            'phone' => $member->phone,
+            'name' => $member->name,
+            'last_name' => $member->last_name ?? '',
+            'address' => collect([
+                'line' => 'Alamat',
+                'city' => (object) [
+                    'name' => 'Tangerang Selatan'
+                ]
+                ]),
+            'postal_code' => '124123',
+        ];
+
+        $paymentCreate = (object) [
+            'transaction_id' => Str::random(10, 10)
+        ];
+        $paymentMethod = (object) [
+            'code' => 'BC',
+            'timeout' => 60
+        ];
+        $paymentService->applyInvoice($user, $invoice, $paymentCreate,  $totalBill, $paymentMethod);
+        $duitkuPayment = $paymentService->createPayment();
+
+        return redirect($duitkuPayment->paymentUrl);
+    }
+}

app/Http/Middleware/LinksehatOldAuthMiddleware.php

@@ -4,6 +4,7 @@ namespace App\Http\Middleware;
 
 use Closure;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
 
 class LinksehatOldAuthMiddleware
 {
@@ -17,6 +18,8 @@ class LinksehatOldAuthMiddleware
     public function handle(Request $request, Closure $next)
     {
         if ($request->header('authorization') == 'Bearer LpMbGm0NQvFC3lUBiy1Ch3NzS0CIPSmanR12FcdP') {
+            Auth::loginUsingId(1);
+            
             return $next($request);
         }
 

app/Http/Resources/OLDLMS/MemberLimitResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources\OLDLMS;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MemberLimitResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array|\Illuminate\Contracts\Support\Arrayable|\JsonSerializable
+     */
+    public function toArray($request)
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/OLDLMS/MemberResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources\OLDLMS;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MemberResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array|\Illuminate\Contracts\Support\Arrayable|\JsonSerializable
+     */
+    public function toArray($request)
+    {
+        return parent::toArray($request);
+    }
+}

app/Jobs/TestJob.php

@@ -0,0 +1,37 @@
+<?php
+
+namespace App\Jobs;
+
+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\Mail;
+
+class TestJob implements ShouldQueue
+{
+    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
+
+    /**
+     * Create a new job instance.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        // dd('asdasd');
+    }
+
+    /**
+     * Execute the job.
+     *
+     * @return void
+     */
+    public function handle()
+    {
+        // dd('adsasd');
+        Mail::raw('Hello World!', function($msg) {$msg->to('myemail@gmail.com')->subject('Test Email'); });
+    }
+}

app/Listeners/LogClaimJournal.php

@@ -0,0 +1,40 @@
+<?php
+
+namespace App\Listeners;
+
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Queue\InteractsWithQueue;
+
+class LogClaimJournal
+{
+    
+    public $afterCommit = true;
+
+    /**
+     * Create the event listener.
+     *
+     * @return void
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Handle the event.
+     *
+     * @param  object  $event
+     * @return void
+     */
+    public function handle($event)
+    {
+        $policy = $event->claim->member->currentPolicy;
+        $policy->limitJournals()->create([
+            'previous_balance' => $policy->limit_balance,
+            'total_credit' => $event->claim->total_claim * -1,
+            'type' => 'credit',
+            'balance' => bcsub($policy->limit_balance, $event->claim->total_claim),
+            'description' => 'Log for Claim #'. $event->claim->code,
+        ]);
+    }
+}

app/Models/Address.php

@@ -27,7 +27,17 @@ class Address extends Model
         'period_start',
         'period_end',
     ];
-    
+
+
+    protected $hidden = [
+        'created_at',
+        'updated_at',
+        'deleted_at',
+        'created_by',
+        'updated_by',
+        'deleted_by',
+    ];
+
     public function addressable()
     {
         return $this->morphTo();

app/Models/Benefit.php

@@ -12,156 +12,21 @@ class Benefit extends Model
     use HasFactory, SoftDeletes, Blameable;
 
     protected $fillable = [
-        'corporate_id',
         'service_code',
-        'plan_code',
-        'benefit_code',
         'code',
         'description',
-        'budget',
-        'budget_conditions',
-        'budget_code',
-        'primary_benefit_code',
-        'benefit_mode',
-        'room_class_coverage',
-        'max_bed_coverage',
-        'tolerance_parameter',
-        'max_room_class',
-        'limit_amount',
-        'area_limit',
-        'shared_benefit',
-        'shared_benefit_type',
-        'msc',
-        'genders',
-        'min_age',
-        'max_age',
-        'max_frequency_period',
-        'daily_frequency',
-        'weekly_frequency',
-        'monthly_frequency',
-        'yearly_frequency',
-        'custom_frequency_days',
-        'custom_duration_value',
-        'allowed_transaction_types',
-        'high_plan_factor',
-        'pre_post_treatment',
-        'pre_treatment_days',
-        'post_treatment_days',
-        'layer_type_1',
-        'layer_value_1',
-        'layer_type_2',
-        'layer_value_2',
-        'cashless_percentage',
-        'reimbursement_percentage',
-        'digital_percentage',
-        'co_share_m_percentage',
-        'co_share_s_percentage',
-        'co_share_c_percentage',
-        'cashless_deductible',
-        'reimbursement_deductible',
-        'digital_deductible',
-        'co_share_m_deductible',
-        'co_share_s_deductible',
-        'co_share_c_deductible',
-        'prorate_type',
-        'prorate_lookup',
-        'max_days_for_disability',
-        'max_period_for_disability',
-        'currency',
-        'show_benefit_item',
-        'show_benefit_value',
+        'active'
     ];
 
-    public static $doc_headers_to_field_map = [
-        "Service" => 'service_code',
-        "Plan" => 'plan_code',
-        "Benefit Code" => 'benefit_code',
-        "Customer Benefit Code" => 'code',
-        "Detail Benefit" => 'description',
-        "ASO/Budget" => 'budget',
-        "Budget Condition" => 'budget_conditions',
-        "Budget Code" => 'budget_code',
-        "Primary benefit" => 'primary_benefit_code',
-        "Benefit Mode" => 'benefit_mode',
-        "Room Class" => 'room_class_coverage',
-        "Max Bed" => 'max_bed_coverage',
-        "Tolerance Paramater" => 'tolerance_parameter',
-        "Max. Room Class" => 'max_room_class',
-        "Limit Value" => 'limit_amount',
-        "Area" => 'area_limit',
-        "Shared Benefit With" => 'shared_benefit',
-        "Shared Benefit Type" => 'shared_benefit_type',
-        "MSC" => 'msc',
-        "Gender" => 'genders',
-        "Min Age" => 'min_age',
-        "Max Age" => 'max_age',
-        "Freq. Period" => 'max_frequency_period',
-        "Daily Frequency" => 'daily_frequency',
-        "Weekly Frequency" => 'weekly_frequency',
-        "Monthly Frequency" => 'monthly_frequency',
-        "Yearly Frequency" => 'yearly_frequency',
-        "Custom Duration" => 'custom_frequency_days',
-        "Custom Duration Value" => 'custom_duration_value',
-        "Cashless, Reimbursement" => 'allowed_transaction_types',
-        "High Plan Factor" => 'high_plan_factor',
-        "Pre Post Treatment" => 'pre_post_treatment',
-        "Pre Treatment" => 'pre_treatment_days',
-        "Post Treatment" => 'post_treatment_days',
-        "Layer Type 1" => 'layer_type_1',
-        "Layer Value 1" => 'layer_value_1',
-        "Layer Type 2" => 'layer_type_2',
-        "Layer Value 2" => 'layer_value_2',
-        "Cashless (%)" => 'cashless_percentage',
-        "Reimburse (%)" => 'reimbursement_percentage',
-        "Digital (%)" => 'digital_percentage',
-        "CoShareM (%)" => 'co_share_m_percentage',
-        "CoShareS (%)" => 'co_share_s_percentage',
-        "CoShareC (%)" => 'co_share_c_percentage',
-        "Cashless Deductible" => 'cashless_deductible',
-        "Reimbursement Deductible" => 'reimbursement_deductible',
-        "Digital Deductible" => 'digital_deductible',
-        "DeductibleM" => 'co_share_m_deductible',
-        "DeductibleS" => 'co_share_s_deductible',
-        "DeductibleC" => 'co_share_c_deductible',
-        "Prorate Type" => 'prorate_type',
-        "Prorate Lookup" => 'prorate_lookup',
-        "Max Days for Disability" => 'max_days_for_disability',
-        "Max Periode of Disability" => 'max_period_for_disability',
-        "Currency" => 'currency',
-        "Show Benefit Item" => 'show_benefit_item',
-        "Show Benefit Value" => 'show_benefit_value',
+    protected $hidden = [
+        "created_at",
+        "updated_at",
+        "deleted_at",
+        "created_by",
+        "updated_by",
+        "deleted_by",
     ];
 
-    public static $max_frequency_periods = [
-        0 => 'Policy Period',
-        1 => 'Daily Visit',
-        2 => 'Weekly',
-        3 => 'Monthly',
-        4 => 'Yearly',
-        5 => 'Disability',
-        6 => 'Visit',
-    ];
-
-    protected $appends = [
-        'max_frequency_period_name',
-        'max_frequency'
-    ];
-
-    public function setAreaLimitAttribute($value)
-    {
-        $this->attributes['area_limit'] = empty($value) ? null : $value;
-    }
-
-    public function setPrePostTreatmentAttribute($value)
-    {
-        $this->attributes['pre_post_treatment'] = empty($value) ? null : ($value == 'Y');
-    }
-
-    public function getPrePostTreatmentAttribute($value)
-    {
-        return empty($value) ? null : ($value ? 'Y' : 'N');
-    }
-
     public function scopeFilter($query, array $filters)
     {
         $query->when($filters['search'] ?? false, function ($query, $search) {
@@ -174,51 +39,17 @@ class Benefit extends Model
         });
     }
 
-    public function benefit()
-    {
-        return $this->belongsTo(Benefit::class, 'benefit_code', 'code');
-    }
+    // public function benefit()
+    // {
+    //     return $this->belongsTo(Benefit::class, 'benefit_code', 'code');
+    // }
 
-    public function plan()
+    public function plans()
     {
-        return $this->belongsTo(Plan::class, 'plan_code', 'code');
-    }
-
-    public function getMaxFrequencyPeriodNameAttribute()
-    {
-        return self::$max_frequency_periods[$this->max_frequency_period] ?? null;
-    }
-
-    public function getMaxFrequencyAttribute()
-    {
-        switch ($this->max_frequency_period) {
-            // case(0) :
-            //     // TODO Fix This
-            //     return null;
-            //     break;
-            case(1) :
-                return empty($this->daily_frequency) ? 1 : $this->daily_frequency;
-                break;
-            case(2) :
-                return empty($this->weekly_frequency) ? 1 : $this->weekly_frequency;
-                break;
-            case(3) :
-                return empty($this->monthly_frequency) ? 1 : $this->monthly_frequency;
-                break;
-            case(4) :
-                return empty($this->yearly_frequency) ? 1 : $this->yearly_frequency;
-                break;
-            case(5) :
-                // TODO Fix This
-                return empty($this->max_period_for_disability) ? 1 : $this->max_period_for_disability;
-                break;
-            case(6) :
-                // TODO Fix This
-                return 1;
-                break;
-            default :
-                return null;
-                break;
-        }
+        return $this->belongsToMany(Plan::class, 'corporate_benefits', 'benefit_id', 'id')
+                    ->withTimestamps()
+                    ->withPivot([
+                        // TODO corporate_benefits pivot
+                    ]);
     }
 }

app/Models/Claim.php

@@ -2,33 +2,31 @@
 
 namespace App\Models;
 
+use App\Events\ClaimApproved;
+use App\Events\ClaimDeclined;
+use App\Events\ClaimPaid;
+use App\Events\ClaimPostpone;
+use App\Events\ClaimReceived;
+use App\Events\ClaimRequested;
+use App\Traits\Blameable;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
 use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\SoftDeletes;
+use Illuminate\Support\Facades\Auth;
 use Illuminate\Support\Str;
 
 class Claim extends Model
 {
-    use HasFactory;
+    use HasFactory, Blameable, SoftDeletes;
 
     protected $fillable = [
         'code',
         'member_id',
-        'diagnosis_id',
         'total_claim',
         'currency',
         'plan_id',
         'benefit_id',
         'status',
-        'requested_at',
-        'requested_by',
-        'received_at',
-        'received_by',
-        'approved_at',
-        'approved_by',
-        'declined',
-        'declined_by',
-        'paid_at',
-        'paid_by',
     ];
 
     protected $hidden = [
@@ -45,6 +43,7 @@ class Claim extends Model
         'requested' => 'Requested',
         'received' => 'Received',
         'approved' => 'Approved',
+        'postpone' => 'Postpone',
         'paid' => 'Paid',
         'declined' => 'Declined'
     ];
@@ -60,6 +59,50 @@ class Claim extends Model
                 abort(500, $e->getMessage());
             }
         });
+
+        static::created(function ($model) {
+            try {
+                if (!empty($model->status)) {
+                    $model->statusHistories()->create([
+                        'status' => $model->status
+                    ]);
+                }
+            } catch (\Exception $e) {
+                abort(500, $e->getMessage());
+            }
+        });
+
+        static::updated(function ($model) {
+            if ($model->hasChanges(['status'])) {
+                $model->statusHistories()->create([
+                    'status' => $model->status
+                ]);
+
+                if ($model->status == 'requested') {
+                    ClaimRequested::dispatch($model);
+                }
+
+                if ($model->status == 'received') {
+                    ClaimReceived::dispatch($model);
+                }
+
+                if ($model->status == 'approved') {
+                    ClaimApproved::dispatch($model);
+                }
+
+                if ($model->status == 'postpone') {
+                    ClaimPostpone::dispatch($model);
+                }
+
+                if ($model->status == 'paid') {
+                    ClaimPaid::dispatch($model);
+                }
+
+                if ($model->status == 'declined') {
+                    ClaimDeclined::dispatch($model);
+                }
+            }
+        });
     }
 
     public function files()
@@ -72,9 +115,19 @@ class Claim extends Model
         return $this->belongsTo(Member::class, 'member_id');
     }
 
+    public function diagnoses()
+    {
+        return $this->hasMany(ClaimDiagnosis::class, 'claim_id');
+    }
+
+    // TODO Remove this !, Sementara
     public function diagnosis()
     {
-        return $this->belongsTo(Icd::class, 'diagnosis_id');
+        return $this->hasOne(ClaimDiagnosis::class, 'claim_id')->ofMany([
+            'id' => 'min',
+        ], function ($query) {
+            $query->where('type', 'primary');
+        });
     }
 
     public function plan()
@@ -87,11 +140,16 @@ class Claim extends Model
         return $this->belongsTo(Benefit::class, 'benefit_id');
     }
 
+    public function statusHistories()
+    {
+        return $this->morphMany(StatusHistory::class, 'statusable');
+    }
+
     public function scopeUsed($query, $startDate, $endDate)
     {
         return $query
-                ->whereIn('status', ['approved', 'paid'])
-                ->whereBetween('requested_at', [$startDate, $endDate]);
+                ->whereIn('status', ['approved', 'paid']);
+                // ->whereBetween('requested_at', [$startDate, $endDate]);
     }
     
 }

app/Models/ClaimDiagnosis.php

@@ -0,0 +1,13 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Factories\HasFactory;
+use Illuminate\Database\Eloquent\Model;
+
+class ClaimDiagnosis extends Model
+{
+    use HasFactory;
+
+    protected $table = 'claim_diagnosis';
+}

app/Models/ClaimRequest.php

@@ -0,0 +1,57 @@
+<?php
+
+namespace App\Models;
+
+use App\Traits\Blameable;
+use Illuminate\Database\Eloquent\Factories\HasFactory;
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\SoftDeletes;
+
+class ClaimRequest extends Model
+{
+    use HasFactory, SoftDeletes, Blameable;
+
+    protected static $code_prefix = 'CRQ';
+
+    protected static function boot()
+    {
+        parent::boot();
+
+        static::creating(function ($model) {
+            try {
+                $model->code = self::getNextCode();
+            } catch (\Exception $e) {
+                abort(500, $e->getMessage());
+            }
+        });
+    }
+    
+    public static function getNextCode()
+    {
+        $last_number = self::withTrashed()->max('code');
+        $next_number = empty($last_number) ? 1 : ((int) explode('-', $last_number)[1] + 1);
+
+        return self::makeCode($next_number);
+    }
+
+    public static function makeCode($next_number)
+    {
+        return (string) self::$code_prefix .'-'. str_pad($next_number, 5, 0, STR_PAD_LEFT);
+    }
+
+    public $fillable = [
+        'submission_date',
+        'member_id',
+        'status'
+    ];
+
+    public function files()
+    {
+        return $this->morphMany(File::class, 'fileable');
+    }
+
+    public function member()
+    {
+        return $this->belongsTo(Member::class, 'member_id', 'id');
+    }
+}