Merge branch 'mhmfajar' of http://itcorp.primaya.id:3000/rajif/aso into mhmfajar

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

@@ -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/CorporateController.php

@@ -0,0 +1,75 @@
+<?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 CorporateController 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();
+
+        // corporate policy, all member list, notification
+
+        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/DashboardController.php

@@ -5,6 +5,8 @@ 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
 {
@@ -12,18 +14,16 @@ class DashboardController 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);
+            
+        $data = DashboardResources::make($currentCorporate);
 
-        $corporate = $user->managedCorporates()
+        return response()->json($data);
-                        ->withCount('employees')
-                        ->with(['policies' => function ($policy) {
-                            $policy->limit(1)->latest();
-                        }])
-                        ->first();
-
-        return response()->json(compact('corporate'));
     }
 
     /**

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

@@ -0,0 +1,120 @@
+<?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 DivisionController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        $user = Auth::user();
+
+        $corporate = $user->managedCorporates()->where('active', 1)->first();
+
+        $benefits = CorporateDivision::query()
+            ->where('corporate_id', $corporate->id)
+            ->get(['id', 'name']);
+
+        return $benefits;
+    }
+
+    /**
+     * 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/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,7 +1,9 @@
 <?php
 
 use Modules\Client\Http\Controllers\Api\AuthController;
+use Modules\Client\Http\Controllers\Api\CorporateController;
 use Modules\Client\Http\Controllers\Api\DashboardController;
+use Modules\Client\Http\Controllers\Api\DivisionController;
 use Modules\Client\Http\Controllers\Api\MemberController;
 use Modules\Client\Http\Controllers\Api\UserController;
 
@@ -26,9 +28,19 @@ 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::prefix('{corporate_id}')->group(function() {
+        Route::get('asd', function ($corporate_id) {
+            return $corporate_id;
+        });
+
+        
         Route::get('dashboard', [DashboardController::class, 'index']);
+        Route::get('corporate', [CorporateController::class, 'index']);
+        Route::get('corporate/{corporate_id}', [CorporateController::class, 'show']);
+        Route::get('division', [DivisionController::class, 'index']);
         Route::get('members', [MemberController::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' => ($myLimitBalance / $myLimitTotal) * 100,
+                ],
+                'lockLimit' => [
+                    'balance' => $lockBalance,
+                    'percentage' => $lockPercentage
+                ]
+            ],
+        ];
+    }
+}

Modules/Client/Transformers/MemberResources.php

@@ -0,0 +1,25 @@
+<?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 [
+            'memberId' => $this->member_id,
+            'full_name' => $this->full_name,
+            'division' => $this->division->name,
+            'employeeLimit' => '',
+            'status' => $this->active
+        ];
+    }
+}

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

@@ -26,18 +26,17 @@ class CorporateController extends Controller
     public function index(Request $request)
     {
         $corporates = Corporate::query()
-                                ->when($request->search, function ($query, $search) {
+            ->when($request->search, function ($query, $search) {
-                                    return $query->where('name', 'LIKE', '%'.$search.'%')
+                return $query->where('name', 'LIKE', '%' . $search . '%')
-                                                ->orWhere('code', 'LIKE', '%'.$search.'%');
+                    ->orWhere('code', 'LIKE', '%' . $search . '%');
-                                })
+            })
-                                ->with('currentPolicy', 'subCorporates')
+            ->with('currentPolicy', 'subCorporates')
-                                ->withCount([
+            ->withCount([
-                                    'employees',
+                'employees',
-                                    'corporatePlans',
+                'corporateBenefits',
-                                    'corporateBenefits',
+            ])
-                                ])
+            ->where('type', 'corporate')
-                                ->where('type', 'corporate')
+            ->paginate(10);
-                                ->paginate(10);
 
         return $corporates;
     }
@@ -48,10 +47,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 . ')',
             ];
         });
 
@@ -80,7 +79,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();
@@ -155,7 +154,7 @@ class CorporateController extends Controller
             'policy_stop_service_percentage' => 'required_with:policy_code',
             'policy_stop_service_net' => 'required_with:policy_code',
         ]);
-        
+
         try {
             DB::beginTransaction();
 
@@ -199,7 +198,8 @@ class CorporateController extends Controller
         //
     }
 
-    public function activation(Request $request, $corporate_id) {
+    public function activation(Request $request, $corporate_id)
+    {
         $request->validate([
             'active' => 'required'
         ]);
@@ -223,16 +223,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);
-        
+
         $import = new ImportService();
-        $import->read(Storage::path('temp/'.$file_name));
+        $import->read(Storage::path('temp/' . $file_name));
-        $import->write(Storage::disk('public')->path('temp/result-'.$file_name), 'xsls');
+        $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
@@ -243,9 +243,9 @@ 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' ) {
+                } else if ($sheet->getName() == 'Benefit') {
                     $headers_map_to_table_fields = Benefit::$doc_headers_to_field_map;
                 }
 
@@ -253,7 +253,6 @@ class CorporateController extends Controller
                 $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 = [];
@@ -261,8 +260,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("/\r|\n/", " ", $title);
-                        $title = preg_replace('/\xc2\xa0/', " ", $title );
+                        $title = preg_replace('/\xc2\xa0/', " ", $title);
                         $title = rtrim($title);
                         $title = ltrim($title);
                         $doc_headers_indexes[$index] = $title;
@@ -278,9 +277,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);
                         }
 
@@ -289,7 +288,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, [
@@ -308,7 +306,7 @@ class CorporateController extends Controller
             }
         }
         $import->reader->close();
-        Storage::delete('temp/'.$file_name);
+        Storage::delete('temp/' . $file_name);
         $import->writer->close();
 
         return [
@@ -316,8 +314,8 @@ 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),
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
-                'name' => 'result-'.$file_name,
+                'name' => 'result-' . $file_name,
             ]
         ];
     }

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

@@ -27,22 +27,22 @@ class CorporateMemberController extends Controller
     public function index(Request $request, $corporate_id)
     {
         $members = Member::query()
-                    ->filter($request->all())
+            ->filter($request->all())
-                // ->where('corporate_id', $corporate_id)
+            // ->where('corporate_id', $corporate_id)
-                    ->whereHas('employeds', function ($employeds) use ($corporate_id) {
+            ->whereHas('employeds', function ($employeds) use ($corporate_id) {
-                        $employeds->where('corporate_id', $corporate_id);
+                $employeds->where('corporate_id', $corporate_id);
-                    })
+            })
-                    ->with([
+            ->with([
-                        'employeds', 
+                'employeds',
-                        'currentPolicy',
+                'currentPolicy',
-                        'claims' => function ($claim) {
+                // 'claims' => function ($claim) {
-                            return $claim->used();
+                //     return $claim->used();
-                        }
+                // }
-                    ])
+            ])
-                    ->with('currentPlan')
+            ->with('currentPlan')
-                    ->paginate()
+            ->paginate()
-                    ->appends($request->all());
+            ->appends($request->all());
-        
+
         return $members;
     }
 
@@ -111,17 +111,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 = ReaderEntityFactory::createReaderFromFile(Storage::path('temp/' . $file_name));
-        $reader->open(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;
 
@@ -139,8 +139,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("/\r|\n/", " ", $title);
-                        $title = preg_replace('/\xc2\xa0/', " ", $title );
+                        $title = preg_replace('/\xc2\xa0/', " ", $title);
                         $title = rtrim($title);
                         $title = ltrim($title);
                         $doc_headers_indexes[$index] = $title;
@@ -157,7 +157,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);
@@ -182,14 +182,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 [
@@ -197,8 +196,8 @@ 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),
+                'url' => Storage::disk('public')->url('temp/result-' . $file_name),
-                'name' => 'result-'.$file_name,
+                'name' => 'result-' . $file_name,
             ]
         ];
     }

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())
+            ->filter($request->all())
-                    ->where('corporate_id', $corporate_id)
+            ->where('corporate_id', $corporate_id)
-                    ->paginate(0)
+            ->paginate(0)
-                    ->appends($request->all());
+            ->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/Services/MemberEnrollmentService.php

@@ -27,7 +27,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",
@@ -89,7 +89,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 +106,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",
@@ -264,7 +264,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 +306,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'])
+        if (
-        && !(substr($row['telephone_mobile'], 0, 4) == '+628' || substr($row['telephone_mobile'], 0, 3) == '628')) {
+            !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'])
+        if (
-        && !filter_var($row['email'], FILTER_VALIDATE_EMAIL)) {
+            !empty($row['email'])
+            && !filter_var($row['email'], FILTER_VALIDATE_EMAIL)
+        ) {
             throw new ImportRowException(__('enrollment.EMAIL_INVALID'), 0, null, $row);
         }
 
@@ -396,16 +400,16 @@ class MemberEnrollmentService
             switch ($row['record_mode']) {
                 case "1": // New Member
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
+                        ->where('member_id', $row['member_id'])
-                                    // ->whereHas('employeds', function ($query) use ($corporate) {
+                        // ->whereHas('employeds', function ($query) use ($corporate) {
-                                    //     $query->where('corporate_id', $corporate->id);
+                        //     $query->where('corporate_id', $corporate->id);
-                                    // })
+                        // })
-                                    ->first();
+                        ->first();
-                
+
                     // Validate If Exist Member
                     if ($member) {
                         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 +422,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);
                     }
@@ -449,8 +453,28 @@ class MemberEnrollmentService
                             ]);
                             $memberPolicy->save();
 
-                            if (!empty($row['division'])) {
+                            if (!empty($row['division_name'])) {
-                                $division_id = CorporateDivision::where('code', $row['division_code'])->where('')->pluck('id');
+                                $division_id = CorporateDivision::query()->where('code', $row['division_name'])->pluck('id')->first();
+
+                                if (empty($division_id)) {
+                                    $corporateCodeArray = explode(' ', $row['division_name']);
+
+                                    if (!empty($corporateCodeArray[1])) {
+                                        $corporateCode = substr($corporateCodeArray[0], 0, 1) . substr($corporateCodeArray[1], 0, 1);
+                                    } elseif (!empty($corporateCodeArray[2])) {
+                                        $corporateCode = substr($corporateCodeArray[0], 0, 1) . substr($corporateCodeArray[1], 0, 1);
+                                    } else {
+                                        $corporateCode = substr($row['division_name'], 0, 1);
+                                    }
+
+                                    $division = CorporateDivision::query()->create([
+                                        'corporate_id' => $corporate->id,
+                                        'name' => $row['division_name'],
+                                        'code' => $corporateCode,
+                                    ]);
+
+                                    $division_id = $division->id;
+                                }
                             }
 
                             $member->employeds()->create([
@@ -476,13 +500,13 @@ class MemberEnrollmentService
                     break;
                 case "2": // Member Information Update (Without Replacement Card)
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
+                        ->where('member_id', $row['member_id'])
-                                    ->first();
+                        ->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 +520,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 +547,13 @@ class MemberEnrollmentService
                     break;
                 case "3": // Member Deletion
                     $member = Member::query()
-                                    ->where('member_id', $row['member_id'])
+                        ->where('member_id', $row['member_id'])
-                                    ->first();
+                        ->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 +565,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,14 +590,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);
                     }
@@ -583,9 +607,10 @@ class MemberEnrollmentService
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
-                    if (Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
+                    if (
-                                    || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
+                        Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
-                        ) {
+                        || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
+                    ) {
                         throw new ImportRowException(__('enrollment.MEMBER_RENEWAL_STILL_ACTIVE'), 0, null, $row);
                     }
 
@@ -609,14 +634,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);
                     }
@@ -625,9 +650,10 @@ class MemberEnrollmentService
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
 
-                    if (Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
+                    if (
-                                    || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
+                        Carbon::parse($memberPolicy->end) > Carbon::parse(strtotime($row['member_expiry_date']))
-                        ) {
+                        || $memberPolicy->end > Carbon::parse(strtotime($row['member_expiry_date']))
+                    ) {
                         throw new ImportRowException(__('enrollment.MEMBER_RENEWAL_STILL_ACTIVE'), 0, null, $row);
                     }
 
@@ -651,7 +677,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 +703,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 +712,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 +728,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 +765,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 +785,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)
+                                ->where('member_id', $memberPolicy->member->id)
-                                                                ->first();
+                                ->first();
-                            $newCorporateEmployee = CorporateEmployee::updateOrCreate([
+                            $newCorporateEmployee = CorporateEmployee::updateOrCreate(
-                                'corporate_id' => $oldCorporate->id,
+                                [
-                                'member_id' => $memberPolicy->member->id
+                                    'corporate_id' => $oldCorporate->id,
-                            ],
+                                    'member_id' => $memberPolicy->member->id
-                            [
+                                ],
-                                'corporate_id' => $newCorporate->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,7 +828,7 @@ 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);
                     }
@@ -808,7 +836,7 @@ class MemberEnrollmentService
                     if (Carbon::parse(strtotime($row['member_effective_date'])) < now() || Carbon::parse(strtotime($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']))) {
                         throw new ImportRowException(__('enrollment.MEMBER_EXPIRY_DATE_INVALID'), 0, null, $row);
                     }
@@ -828,14 +856,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);
                     }
@@ -851,10 +879,10 @@ class MemberEnrollmentService
                     $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 +893,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);
                     }
@@ -896,9 +924,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 +935,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 +946,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('corporate_id', $corporate->id)
-                                ->where('code', $row['plan_id'])
+                        ->where('code', $row['plan_id'])
-                                ->where('active', true)
+                        ->where('active', true)
-                                ->first();
+                        ->first();
                     if (!$plan) {
                         throw new ImportRowException(__('enrollment.PLAN_NOT_FOUND'), 0, null, $row);
                     }
@@ -933,14 +961,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);
                     }
@@ -978,7 +1006,7 @@ class MemberEnrollmentService
     }
 
     // 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) {

app/Helpers/Helper.php

@@ -158,10 +158,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/Models/Corporate.php

@@ -44,10 +44,10 @@ class Corporate extends Model
     public function currentPolicy()
     {
         return $this->hasOne(CorporatePolicy::class)
-                    // ->where('start', '<=', now())
+            // ->where('start', '<=', now())
-                    // ->where('end', '>=', now())
+            // ->where('end', '>=', now())
-                    ->where('active', true)
+            ->where('active', true)
-                    ->latestOfMany();
+            ->latestOfMany();
     }
 
     public function corporatePlans()

app/Models/CorporateEmployee.php

@@ -19,4 +19,9 @@ class CorporateEmployee extends Model
         'nik',
         'status'
     ];
+
+    public function division()
+    {
+        return $this->belongsTo(CorporateDivision::class, 'division_id');
+    }
 }

app/Models/Member.php

@@ -63,7 +63,7 @@ class Member extends Model
         'gender_code',
         ''
     ];
-    
+
     protected $hidden = [
         'created_at',
         'updated_at',
@@ -86,30 +86,30 @@ class Member extends Model
     public function corporates()
     {
         return $this
-                ->belongsToMany(Corporate::class, 'corporate_employees', 'corporate_id', 'member_id')
+            ->belongsToMany(Corporate::class, 'corporate_employees', 'corporate_id', 'member_id')
-                ->withPivot([
+            ->withPivot([
-                    'branch_code', 
+                'branch_code',
-                    'divison_id',
+                'division_id',
-                    'nik',
+                'nik',
-                    'status',
+                'status',
-                    'start',
+                'start',
-                    'end'
+                'end'
-                ]);
+            ]);
     }
 
     public function currentCorporate()
     {
         return $this->belongsToMany(Corporate::class, 'corporate_employees', 'corporate_id', 'member_id')
-                // ->withPivot([
+            // ->withPivot([
-                //     'branch_code', 
+            //     'branch_code', 
-                //     'divison_id',
+            //     'divison_id',
-                //     'nik',
+            //     'nik',
-                //     'status',
+            //     'status',
-                //     'start',
+            //     'start',
-                //     'end'
+            //     'end'
-                // ])
+            // ])
-                ->where('start', '<', now())
+            ->where('start', '<', now())
-                ->where('end', '>', now());
+            ->where('end', '>', now());
     }
 
     public function memberPlans()
@@ -126,7 +126,7 @@ class Member extends Model
     {
         return $this->hasOneThrough(Plan::class, MemberPlan::class, 'member_id', 'id', 'id', 'plan_id')->latest();
     }
-    
+
     public function policies()
     {
         return $this->hasMany(MemberPolicy::class, 'member_id', 'member_id');
@@ -135,10 +135,10 @@ class Member extends Model
     public function currentPolicy()
     {
         return $this->hasOneThrough(CorporatePolicy::class, MemberPolicy::class, 'member_id', 'code', 'member_id', 'policy_id')
-                    ->where('corporate_policies.start', '<', now())
+            ->where('corporate_policies.start', '<', now())
-                    ->where('corporate_policies.end', '>', now())
+            ->where('corporate_policies.end', '>', now())
-                    ->where('member_policies.start', '<', now())
+            ->where('member_policies.start', '<', now())
-                    ->where('member_policies.end', '>', now());
+            ->where('member_policies.end', '>', now());
         // return $this->hasOne(MemberPolicy::class, 'member_id', 'member_id')->where('status', 'active')->latestOfMany();
     }
 
@@ -174,13 +174,22 @@ class Member extends Model
     {
         $query->when($filters['search'] ?? false, function ($query, $search) {
             return $query
-                    ->where('member_id', 'like', "%" . $search . "%")
+                ->where('member_id', 'like', "%" . $search . "%")
-                    ->orWhere('payor_id', 'like', "%" . $search . "%")
+                ->orWhere('payor_id', 'like', "%" . $search . "%")
-                    ->orWhere('name', 'like', "%" . $search . "%")
+                ->orWhere('name', 'like', "%" . $search . "%");
-                    ;
+            // ->orWhereHas('corporatePlan', function ($query) use ($search) {
-                    // ->orWhereHas('corporatePlan', function ($query) use ($search) {
+            //     $query->where('code', 'like', "%" . $search . "%");
-                    //     $query->where('code', 'like', "%" . $search . "%");
+            // });
-                    // });
         });
     }
+
+    // public function corporateEmployee()
+    // {
+    //     return $this->hasOne(CorporateEmployee::class, 'member_id');
+    // }
+
+    public function division()
+    {
+        return $this->hasOneThrough(CorporateDivision::class, CorporateEmployee::class, 'member_id', 'id', 'id', 'division_id');
+    }
 }

database/migrations/2022_11_22_135948_create_claims_table.php

@@ -22,15 +22,12 @@ return new class extends Migration
             $table->string('currency');
             $table->foreignId('plan_id')->index();
             $table->foreignId('benefit_id')->index();
-            
+
             $table->dateTime('requested_at')->nullable();
             $table->unsignedBigInteger('requested_by')->nullable()->index();
-            
+
             $table->dateTime('received_at')->nullable();
             $table->unsignedBigInteger('received_by')->nullable()->index();
-            
-            $table->dateTime('approved_at')->nullable();
-            $table->unsignedBigInteger('approved_by')->nullable()->index();
 
             $table->dateTime('declined')->nullable();
             $table->unsignedBigInteger('declined_by')->nullable()->index();

frontend/client-portal/src/@types/auth.ts

@@ -28,7 +28,7 @@ export type JWTContextType = {
   method: 'jwt';
   login: (phoneOrEmail: string) => Promise<void>;
   validateOtp: (phoneOrEmail: string, otp: string) => Promise<void>
-  logout: () => Promise<void>;
+  logout: () => void;
 };
 
 // export type FirebaseContextType = {

frontend/client-portal/src/contexts/LaravelAuthContext.tsx

@@ -132,16 +132,9 @@ function AuthProvider({ children }: AuthProviderProps) {
     axios
       .post('/verify-code', { phoneOrEmail: phoneOrEmail, otp })
       .then((response) => {
-        const { user, token } = response.data.data;
+        const { token } = response.data.data;
         setSession(token);
 
-        dispatch({
-          type: Types.ValidateOtp,
-          payload: {
-            user,
-          },
-        });
-
         return response.data;
       })
       .catch((error) => {
@@ -149,8 +142,7 @@ function AuthProvider({ children }: AuthProviderProps) {
         if (error.response.status !== 422) throw error.response;
       });
 
-  const logout = async () => {
+  const logout = () => {
-    await axios.post('/logout');
     setSession(null);
     dispatch({ type: Types.Logout });
   };

frontend/client-portal/src/layouts/dashboard/header/AccountPopover.tsx

@@ -8,6 +8,7 @@ import { IconButtonAnimate } from '../../../components/animate';
 import { useNavigate } from 'react-router-dom';
 import useAuth from '../../../hooks/useAuth';
 import useLocalStorage from '../../../hooks/useLocalStorage';
+import { enqueueSnackbar } from 'notistack';
 
 // ----------------------------------------------------------------------
 
@@ -33,10 +34,6 @@ export default function AccountPopover() {
   const navigate = useNavigate();
   const { logout } = useAuth();
 
-  const [emailOrPhone, setEmailOrPhone] = useLocalStorage('emailOrPhone', '');
-  const [emailOrPhoneForm, setEmailOrPhoneForm] = useLocalStorage('emailOrPhoneForm', false);
-  const [loginOrVerifyCode, setLoginOrVerifyCode] = useLocalStorage('loginOrVerifyCode', false);
-
   const handleOpen = (event: React.MouseEvent<HTMLElement>) => {
     setOpen(event.currentTarget);
   };
@@ -46,11 +43,9 @@ export default function AccountPopover() {
   };
 
   const handleLogout = () => {
-    setEmailOrPhone('');
-    setEmailOrPhoneForm(false);
-    setLoginOrVerifyCode(false);
     logout();
     navigate('/auth/login');
+    enqueueSnackbar('Logout Berhasil!', { variant: 'success' });
   };
 
   return (

frontend/client-portal/src/pages/Dashboard/Dashboard.tsx

@@ -1,5 +1,13 @@
 // @mui
-import { Typography, Container, Grid } from '@mui/material';
+import {
+  Typography,
+  Container,
+  Grid,
+  FormControl,
+  InputLabel,
+  MenuItem,
+  Select,
+} from '@mui/material';
 // hooks
 import useSettings from '../../hooks/useSettings';
 // components
@@ -8,7 +16,11 @@ import Page from '../../components/Page';
 import CardNotification from '../../sections/dashboard/CardNotification';
 import CardBalance from '../../sections/dashboard/CardBalance';
 import TableList from '../../sections/dashboard/TableList';
-import List from './List';
+import { useEffect, useState } from 'react';
+import axios from '../../utils/axios';
+import { Stack } from '@mui/system';
+import { SelectChangeEvent } from '@mui/material/Select';
+import useAuth from '../../hooks/useAuth';
 
 // ----------------------------------------------------------------------
 
@@ -21,43 +33,100 @@ const itemList = [
 
 // ----------------------------------------------------------------------
 
+/* ---------------------------------- types --------------------------------- */
+
+type CorporateDataProps = {
+  id: number;
+  name: string;
+};
+
+type CardBalanceProps = {
+  myLimit: {
+    balance: number;
+    total: number;
+    percentage: number;
+  };
+  lockLimit: {
+    balance: number;
+    percentage: number;
+  };
+};
+
+/* -------------------------------------------------------------------------- */
+
 export default function Dashboard() {
   const { themeStretch } = useSettings();
+  const { user } = useAuth();
+  const [currentCorporate, setCurrentCorporate] = useState({id: 1});
 
-  // const [corporate, setCorporate] = useState({});
+  // @ts-ignore
+  const [corporateValue, setCorporateValue] = useState(`${user.corporate.id}`);
+  const [corporateData, setCorporateData] = useState([]);
+  const [tableData, setTableData] = useState([]);
+  const [policyData, setPolicyData] = useState<CardBalanceProps>({
+    myLimit: {
+      balance: 0,
+      total: 0,
+      percentage: 0,
+    },
+    lockLimit: {
+      balance: 0,
+      percentage: 0,
+    },
+  });
 
-  // const loadSomething = () => {
+  const handleCorporateChange = (event: SelectChangeEvent) => {
-  //   axios
+    setCorporateValue(event.target.value as string);
-  //     .get('dashboard')
+  };
-  //     .then((res) => {
-  //       setCorporate(res.data.corporate);
-  //     })
-  //     .catch((err) => {
-  //       alert('Opps, Something Went Wrong when collecting dashboard data');
-  //     });
-  // };
 
-  // useEffect(() => {
+  useEffect(() => {
-  //   loadSomething();
+    (async () => {
-  // }, []);
+      const corporates = await axios.get(`${currentCorporate.id}/dashboard`);
+      const dashboard = await axios.get(`${currentCorporate.id}/dashboard`);
+
+      console.log(dashboard);
+
+      setCorporateData(corporates.data);
+      setPolicyData(dashboard.data.policy);
+    })();
+  }, [user, corporateValue]);
 
   return (
     <Page title="Dashboard">
       <Container maxWidth={themeStretch ? false : 'xl'}>
-        <Typography variant="h3" component="h1" paragraph>
+        <Stack direction="row" justifyContent="space-between">
-          Dashboard
+          <Typography variant="h3" component="h1" paragraph>
-        </Typography>
+            Dashboard
+          </Typography>
+
+          <FormControl>
+            <InputLabel id="simple-corporate-select-lable">Corporate</InputLabel>
+            <Select
+              labelId="simple-corporate-select-lable"
+              id="corporate-select-lable"
+              value={corporateValue}
+              label="Corporate"
+              defaultValue={corporateValue}
+              onChange={handleCorporateChange}
+            >
+              {corporateData.map((row: CorporateDataProps, index) => (
+                <MenuItem key={index} value={row.id}>
+                  {row.name}
+                </MenuItem>
+              ))}
+            </Select>
+          </FormControl>
+        </Stack>
 
         <Grid container spacing={2}>
-          <Grid item xs={6} lg={6} md={12}>
+          <Grid item xs={12} lg={6} md={12}>
             <CardNotification data={itemList} />
           </Grid>
-          <Grid item xs={6} lg={6} md={12}>
+          <Grid item xs={12} lg={6} md={12}>
-            <CardBalance />
+            <CardBalance data={policyData} />
           </Grid>
           <Grid item xs={12} lg={12} md={12}>
             <TableList />
-            {/* <List /> */}
           </Grid>
         </Grid>
       </Container>

frontend/client-portal/src/pages/Dashboard/List.tsx

@@ -1,373 +0,0 @@
-// @mui
-import {
-  Box,
-  Button,
-  Card,
-  Collapse,
-  IconButton,
-  InputLabel,
-  MenuItem,
-  OutlinedInput,
-  Paper,
-  Select,
-  SelectChangeEvent,
-  Table,
-  TableBody,
-  TableCell,
-  TableContainer,
-  TableHead,
-  TableRow,
-  TextField,
-  Typography,
-  Badge,
-  Tab,
-  Tabs,
-  CardHeader,
-  Stack,
-  Menu,
-  ButtonGroup,
-  Pagination,
-  Grid,
-  Autocomplete,
-} from '@mui/material';
-import KeyboardArrowDownIcon from '@mui/icons-material/KeyboardArrowDown';
-import KeyboardArrowRightIcon from '@mui/icons-material/KeyboardArrowRight';
-import AddIcon from '@mui/icons-material/Add';
-import UploadIcon from '@mui/icons-material/Upload';
-import CancelIcon from '@mui/icons-material/Cancel';
-// hooks
-import React, { ChangeEvent, Component, useEffect, useRef, useState } from 'react';
-import useSettings from '../../hooks/useSettings';
-import { useNavigate, useParams, useSearchParams } from 'react-router-dom';
-// components
-import axios from '../../utils/axios';
-import { LaravelPaginatedData } from '../../@types/paginated-data';
-import { Icd } from '../../@types/diagnosis';
-import BasePagination from '../../components/BasePagination';
-import { Member } from '../../@types/member';
-import Iconify from '../../components/Iconify';
-
-const options = [
-  { label: 'The Shawshank Redemption', value: 1994 },
-  { label: 'The Godfather', year: 1972 },
-  { label: 'The Godfather: Part II', year: 1974 },
-  { label: 'The Dark Knight', year: 2008 },
-  { label: '12 Angry Men', year: 1957 },
-  { label: "Schindler's List", year: 1993 },
-  { label: 'Pulp Fiction', year: 1994 },
-];
-
-export default function List() {
-  const navigate = useNavigate();
-  const { themeStretch } = useSettings();
-  const { corporate_id } = useParams();
-  const [searchParams, setSearchParams] = useSearchParams();
-  const [importResult, setImportResult] = useState(null);
-
-  function SearchInput(props: any) {
-    // SEARCH
-    const searchInput = useRef<HTMLInputElement>(null);
-    const [searchText, setSearchText] = useState('');
-
-    const [value, setValue] = useState<string | null>(options[0]);
-    const [inputValue, setInputValue] = useState('');
-
-    const handleSearchChange = (event: any) => {
-      const newSearchText = event.target.value ?? '';
-      setSearchText(newSearchText);
-    };
-
-    const handleSearchSubmit = (event: any) => {
-      event.preventDefault();
-      props.onSearch(searchText); // Trigger to Parent
-    };
-
-    useEffect(() => {
-      // Trigger First Search
-      setSearchText(searchParams.get('search') ?? '');
-      console.log(value, inputValue);
-    }, [searchParams, value, inputValue]);
-
-    return (
-      <form onSubmit={handleSearchSubmit} style={{ width: '100%' }}>
-        <Stack direction="row" spacing={2}>
-          <Autocomplete
-            value={value}
-            onChange={(event: any, newValue: string | null) => {
-              setValue(newValue);
-            }}
-            inputValue={inputValue}
-            onInputChange={(event, newInputValue) => {
-              setInputValue(newInputValue);
-            }}
-            id="controllable-states-demo"
-            options={options}
-            sx={{ width: 300 }}
-            renderInput={(params) => <TextField {...params} label="Division" />}
-          />
-          <TextField
-            id="search-input"
-            ref={searchInput}
-            label="Search"
-            variant="outlined"
-            fullWidth
-            onChange={handleSearchChange}
-            value={searchText}
-          />
-        </Stack>
-      </form>
-    );
-  }
-
-  function ImportForm(props: any) {
-    // IMPORT
-    // Create Button Menu
-    const [anchorEl, setAnchorEl] = React.useState<null | HTMLElement>(null);
-    const createMenu = Boolean(anchorEl);
-    const importForm = useRef<HTMLInputElement>(null);
-    const [currentImportFileName, setCurrentImportFileName] = useState(null);
-
-    const handleClick = (event: React.MouseEvent<HTMLButtonElement>) => {
-      setAnchorEl(event.currentTarget);
-    };
-
-    const handleClose = () => {
-      setAnchorEl(null);
-    };
-
-    const handleImportButton = () => {
-      if (importForm?.current) {
-        handleClose();
-        importForm.current ? importForm.current.click() : console.log('No File selected');
-      } else {
-        alert('No file selected');
-      }
-    };
-
-    const handleCancelImportButton = () => {
-      importForm.current.value = '';
-      importForm.current.dispatchEvent(new Event('change', { bubbles: true }));
-    };
-
-    const handleImportChange = (event: any) => {
-      if (event.target.files[0]) {
-        setCurrentImportFileName(event.target.files[0].name);
-      } else {
-        setCurrentImportFileName(null);
-      }
-    };
-
-    const handleUpload = () => {
-      if (importForm.current?.files.length) {
-        const formData = new FormData();
-        formData.append('file', importForm.current?.files[0]);
-        axios
-          .post(`master/formularium/import`, formData)
-          .then((response) => {
-            handleCancelImportButton();
-            loadDataTableData();
-            setImportResult(response.data);
-            // alert('Succesfully read '+ response.data.total_successed_row + ' with ' + response.data.total_failed_row + ' failed rows');
-          })
-          .catch((response) => {
-            alert(
-              'Looks like something went wrong. Please check your data and try again. ' +
-                response.message
-            );
-          });
-      } else {
-        alert('No File Selected');
-      }
-    };
-
-    return (
-      <Stack direction="row" spacing={2} padding={2}>
-        <SearchInput onSearch={applyFilter} />
-        <Button
-          id="import-button"
-          variant="outlined"
-          startIcon={<Iconify icon="material-symbols:download-rounded" />}
-          sx={{ paddingY: '15px', paddingX: '22px', flex: '10%' }}
-          component="label"
-        >
-          Import
-          <input
-            type="file"
-            id="file"
-            ref={importForm}
-            style={{ display: 'none' }}
-            onChange={handleImportChange}
-            accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel, text/plain"
-          />
-        </Button>
-        <Button
-          id="import-button"
-          variant="contained"
-          startIcon={<AddIcon />}
-          sx={{ paddingY: '15px', paddingX: '22px', flex: '15%' }}
-          onClick={handleClick}
-        >
-          Add Data
-        </Button>
-      </Stack>
-    );
-  }
-
-  // Called on every row to map the data to the columns
-  function createData(member: Member): Member {
-    return {
-      ...member,
-    };
-  }
-
-  // Generate the every row of the table
-  function Row(props: { row: ReturnType<typeof createData> }) {
-    const { row } = props;
-    const [open, setOpen] = React.useState(true);
-
-    return (
-      <React.Fragment>
-        <TableRow sx={{ '& > *': { borderBottom: 'unset' } }}>
-          <TableCell>
-            <IconButton aria-label="expand row" size="small" onClick={() => setOpen(!open)}>
-              {open ? <KeyboardArrowDownIcon /> : <KeyboardArrowRightIcon />}
-            </IconButton>
-          </TableCell>
-          <TableCell align="left">{row.member_id}</TableCell>
-          <TableCell align="left">{row.payor_id}</TableCell>
-          <TableCell align="left">{row.name}</TableCell>
-          <TableCell align="left">{row.nik}</TableCell>
-          <TableCell align="left">{row.nric}</TableCell>
-
-          <TableCell align="right">
-            <Button variant="outlined" color="success" size="small">
-              Active
-            </Button>
-          </TableCell>
-          {/* <TableCell align="right"><Button variant="outlined" color="error" size="small">Disable</Button></TableCell> */}
-        </TableRow>
-        {/* COLLAPSIBLE ROW */}
-        <TableRow>
-          <TableCell style={{ paddingBottom: 0, paddingTop: 0 }} colSpan={99}>
-            <Collapse in={open} timeout="auto" unmountOnExit>
-              <Box sx={{ borderBottom: 1 }}>
-                <Typography variant="body2" gutterBottom component="div">
-                  <Grid></Grid>
-                </Typography>
-              </Box>
-            </Collapse>
-          </TableCell>
-        </TableRow>
-      </React.Fragment>
-    );
-  }
-
-  // Dummy Default Data
-  const [dataTableIsLoading, setDataTableLoading] = useState(true);
-  const [dataTableLastRequest, setDataTableLastRequest] = useState(0);
-  const [dataTableResponseState, setDataTableResponseState] = useState('idle');
-  const [dataTableData, setDataTableData] = useState<LaravelPaginatedData>({
-    current_page: 1,
-    data: [],
-    path: '',
-    first_page_url: '',
-    last_page: 1,
-    last_page_url: '',
-    next_page_url: '',
-    prev_page_url: '',
-    per_page: 10,
-    from: 0,
-    to: 0,
-    total: 0,
-  });
-  const [dataTablePage, setDataTablePage] = useState(5);
-
-  const loadDataTableData = async (appliedFilter: any | null = null) => {
-    setDataTableLoading(true);
-    const filter = appliedFilter ? appliedFilter : Object.fromEntries([...searchParams.entries()]);
-    const response = await axios.get('/members', { params: filter });
-
-    setDataTableData(response.data.members);
-    setDataTableLoading(false);
-  };
-
-  const headStyle = {
-    fontWeight: 'bold',
-  };
-
-  const applyFilter = async (searchFilter: string) => {
-    await loadDataTableData({ search: searchFilter });
-    setSearchParams({ search: searchFilter });
-  };
-
-  const handlePageChange = (event: ChangeEvent, value: number) => {
-    const filter = Object.fromEntries([...searchParams.entries(), ['page', value]]);
-    loadDataTableData(filter);
-    setSearchParams(filter);
-  };
-
-  useEffect(() => {
-    loadDataTableData();
-  }, []);
-
-  return (
-    <Stack>
-      <Card>
-        <ImportForm />
-
-        {/* The Main Table */}
-        <TableContainer component={Paper} sx={{ paddingX: 1, borderRadius: 2 }}>
-          <Table aria-label="collapsible table">
-            <TableBody>
-              <TableRow sx={{ backgroundColor: '#F4F6F8' }}>
-                <TableCell style={headStyle} align="left">
-                  Member ID
-                </TableCell>
-                <TableCell style={headStyle} align="center">
-                  Name
-                </TableCell>
-                <TableCell style={headStyle} align="center">
-                  Divisi
-                </TableCell>
-                <TableCell style={headStyle} align="center">
-                  Limit
-                </TableCell>
-                <TableCell style={headStyle} align="center">
-                  Status
-                </TableCell>
-                <TableCell style={headStyle} align="right">
-                  {' '}
-                </TableCell>
-              </TableRow>
-            </TableBody>
-            {dataTableIsLoading ? (
-              <TableBody>
-                <TableRow>
-                  <TableCell colSpan={6} align="center">
-                    Loading
-                  </TableCell>
-                </TableRow>
-              </TableBody>
-            ) : dataTableData.data.length === 0 ? (
-              <TableBody>
-                <TableRow>
-                  <TableCell colSpan={6} align="center">
-                    No Data
-                  </TableCell>
-                </TableRow>
-              </TableBody>
-            ) : (
-              <TableBody>
-                {dataTableData.data.map((row) => (
-                  <Row key={row.id} row={row} />
-                ))}
-              </TableBody>
-            )}
-          </Table>
-        </TableContainer>
-
-        <BasePagination paginationData={dataTableData} onPageChange={handlePageChange} />
-      </Card>
-    </Stack>
-  );
-}

frontend/client-portal/src/sections/auth/login/LoginEmailForm.tsx

@@ -11,6 +11,7 @@ import useAuth from '../../../hooks/useAuth';
 import useIsMountedRef from '../../../hooks/useIsMountedRef';
 /* ------------------------------- components ------------------------------- */
 import { FormProvider, RHFTextField } from '../../../components/hook-form';
+import { enqueueSnackbar } from 'notistack';
 
 /* ---------------------------------- types --------------------------------- */
 
@@ -56,6 +57,10 @@ export default function LoginForm({ setEmailOrPhone, setLoginOrVerifyCode }: Log
       setEmailOrPhone(data.email);
       setLoginOrVerifyCode(true);
       reset();
+      enqueueSnackbar('Kode OTP telah dikirim, silahkan cek email yang login', {
+        variant: 'success',
+        autoHideDuration: 2000,
+      });
     } catch (error: any) {
       reset();
 

frontend/client-portal/src/sections/auth/login/LoginPhoneForm.tsx

@@ -11,6 +11,7 @@ import { FormProvider, RHFTextField } from '../../../components/hook-form';
 /* ---------------------------------- hooks --------------------------------- */
 import useAuth from '../../../hooks/useAuth';
 import useIsMountedRef from '../../../hooks/useIsMountedRef';
+import { enqueueSnackbar } from 'notistack';
 
 /* ---------------------------------- types --------------------------------- */
 
@@ -56,6 +57,10 @@ export default function LoginPhoneForm({ setEmailOrPhone, setLoginOrVerifyCode }
       setEmailOrPhone(0 + data.phone);
       setLoginOrVerifyCode(true);
       reset();
+      enqueueSnackbar('Kode OTP telah dikirim, silahkan cek pada nomor yang telah login', {
+        variant: 'success',
+        autoHideDuration: 2000,
+      });
     } catch (error: any) {
       reset();
 

frontend/client-portal/src/sections/auth/login/VerifyCodeForm.tsx

@@ -87,24 +87,25 @@ export default function VerifyCodeForm({
   }, [setValue]);
 
   const onSubmit = async (data: FormValuesProps) => {
-    try {
+    // @ts-ignore
-      await new Promise((resolve) => setTimeout(resolve, 1000));
+    const response: responseProps = await validateOtp(emailOrPhone, Object.values(data).join(''));
-      // @ts-ignore
-      const response: responseProps = await validateOtp(emailOrPhone, Object.values(data).join(''));
 
-      if (response.data.length === 0) {
+    if (response.data.length === 0) {
-        return enqueueSnackbar(response.message, {
+      return enqueueSnackbar(response.message, {
-          variant: 'error',
+        variant: 'error',
-          autoHideDuration: 4000,
+        autoHideDuration: 4000,
-          preventDuplicate: true,
+        preventDuplicate: true,
-        });
+      });
-      }
+    } else {
-
+      enqueueSnackbar('Verify success!', { variant: 'success', autoHideDuration: 1000 });
-      navigate('/dashboard');
+      await new Promise((resolve) => setTimeout(resolve, 2000));
-      enqueueSnackbar('Verify success!', { variant: 'success' });
-    } catch (error) {
-      console.error(error);
     }
+
+    navigate('/dashboard');
+    enqueueSnackbar('Login Berhasil!', { variant: 'success' });
+    localStorage.removeItem('loginOrVerifyCode');
+    localStorage.removeItem('emailOrPhone');
+    localStorage.removeItem('emailOrPhoneForm');
   };
 
   const handleChangeWithNextField = (

frontend/client-portal/src/sections/dashboard/CardBalance.tsx

@@ -14,23 +14,29 @@ import Iconify from '../../components/Iconify';
 import { useState } from 'react';
 // utils
 import { fCurrency } from '../../utils/formatNumber';
-// <sections></sections>
+/* -------------------------------- sections -------------------------------- */
 import DialogTopUpLimit from './DialogTopUpLimit';
 import DialogClaimSubmitMember from './DialogClaimSubmitMember';
 
-// ----------------------------------------------------------------------
+/* ---------------------------------- types --------------------------------- */
 
-type DataMembers = {
+type CardBalanceProps = {
-  name: string;
+  data: {
-  memberId: string;
+    myLimit: {
-  saldo: string;
+      balance: number;
+      total: number;
+      percentage: number;
+    };
+    lockLimit: {
+      balance: number;
+      percentage: number;
+    };
+  };
 };
 
-type NotificationProps = {
+/* -------------------------------------------------------------------------- */
-  data?: { members: DataMembers[] };
-};
 
-// ----------------------------------------------------------------------
+/* --------------------------------- styled --------------------------------- */
 
 const RootBalanceStyle = styled(Card)(({ theme }) => ({
   boxShadow: 'none',
@@ -52,19 +58,15 @@ const BorderLinearProgress = styled(LinearProgress)(({ theme }) => ({
   },
 }));
 
-// ----------------------------------------------------------------------
+/* -------------------------------------------------------------------------- */
 
-const INITIAL = '500.000.000';
+export default function CardBalance(props: CardBalanceProps) {
-const TOTAL = 375000000;
-const PERCENT = 75;
-
-// ----------------------------------------------------------------------
-
-export default function CardBalance({ data }: NotificationProps) {
   const [openDialog, setOpenDialog] = useState(false);
   const [dialogTitle, setDialogTitle] = useState('');
   const [isDialog, setIsDialog] = useState('');
 
+  const { myLimit, lockLimit } = props.data;
+
   const clickHandler = (isDialog: string) => {
     switch (isDialog) {
       case 'submitClaim':
@@ -91,18 +93,26 @@ export default function CardBalance({ data }: NotificationProps) {
             <Typography variant="body2" component="span" sx={{ opacity: 0.72 }}>
               Total Limit
             </Typography>
-            <Typography sx={{ typography: 'body2' }}>{fCurrency(TOTAL)}</Typography>
+            <Typography sx={{ typography: 'body2' }}>
-            <Typography sx={{ typography: 'caption', color: '#919EAB' }}>/ {INITIAL}</Typography>
+              {fCurrency(myLimit ? myLimit.balance : 0)}
+            </Typography>
+            <Typography sx={{ typography: 'caption', color: '#919EAB' }}>
+              / {myLimit ? myLimit.total : 0}
+            </Typography>
           </div>
 
           <Stack direction="row" alignItems="center" justifyContent="center">
             <Typography variant="h5" sx={{ ml: 0.5 }}>
-              {PERCENT}%
+              {myLimit ? myLimit.percentage : 0}%
             </Typography>
           </Stack>
         </Stack>
 
-        <BorderLinearProgress variant="determinate" value={PERCENT} sx={{ mb: 1 }} />
+        <BorderLinearProgress
+          variant="determinate"
+          value={myLimit ? myLimit.percentage : 0}
+          sx={{ mb: 1 }}
+        />
 
         <Stack sx={{ backgroundColor: '#B2E8E8', paddingY: 1, paddingX: 1.5, mb: 2 }}>
           <Typography sx={{ typography: 'caption', display: 'flex', alignItems: 'center' }}>
@@ -113,11 +123,11 @@ export default function CardBalance({ data }: NotificationProps) {
               sx={{ color: '#424242', marginRight: '6px' }}
             />
             <Typography variant="caption" component="span">
-              Lock Fund ( 25% )
+              Lock Fund ( {lockLimit ? lockLimit.percentage : 0}% )
             </Typography>
           </Typography>
           <Typography sx={{ typography: 'caption', color: '#637381' }}>
-            125.000.000 / 125.000.000
+            {lockLimit ? lockLimit.balance : 0} / {myLimit ? myLimit.total : 0}
           </Typography>
         </Stack>
 
@@ -146,7 +156,7 @@ export default function CardBalance({ data }: NotificationProps) {
           openDialog={openDialog}
           setOpenDialog={setOpenDialog}
           title={{ name: dialogTitle }}
-          data={data?.members}
+          // data={data?.members}
         />
       )}
 

frontend/client-portal/src/sections/dashboard/TableList.tsx

@@ -14,12 +14,18 @@ import {
   IconButton,
   Card,
   Grid,
+  FormControl,
+  InputLabel,
+  Select,
+  MenuItem,
+  SelectChangeEvent,
 } from '@mui/material';
 import { visuallyHidden } from '@mui/utils';
+import { Add as AddIcon } from '@mui/icons-material';
 /* ---------------------------------- axios --------------------------------- */
-import axios from 'axios';
+import axios from '../../utils/axios';
 /* ---------------------------------- react --------------------------------- */
-import { useEffect, useState } from 'react';
+import { useEffect, useRef, useState } from 'react';
 /* -------------------------------- component ------------------------------- */
 import Iconify from '../../components/Iconify';
 import BaseTablePagination from '../../components/BaseTablePagination';
@@ -28,7 +34,6 @@ import palette from '../../theme/palette';
 import { useSearchParams } from 'react-router-dom';
 
 /* ---------------------------------- types --------------------------------- */
-
 type PaginationTableProps = {
   current_page: number;
   from: number;
@@ -63,10 +68,13 @@ interface EnhancedTableProps {
   orderBy: string;
 }
 
+type DivisionDataProps = {
+  id: number;
+  name: string;
+};
 /* -------------------------------------------------------------------------- */
 
 /* -------------------------- enchanced table head -------------------------- */
-
 const headCells: readonly HeadCell[] = [
   {
     id: 'member_id',
@@ -139,16 +147,14 @@ function EnhancedTableHead({ order, orderBy, onRequestSort }: EnhancedTableProps
     </TableHead>
   );
 }
-
 /* -------------------------------------------------------------------------- */
 
-export default function TableList() {
+export default function TableList(props: any) {
   const [order, setOrder] = useState<Order>('asc');
   const [orderBy, setOrderBy] = useState('name');
-  const [customSearchParams, setCustomSearchParams] = useSearchParams();
+  const [searchParams, setSearchParams] = useSearchParams();
   const [isLoading, setIsLoading] = useState(true);
   const [dataTable, setDataTable] = useState([]);
-  const [dataDivision, setDataDivision] = useState([]);
   const [page, setPage] = useState(0);
   const [rowsPerPage, setRowsPerPage] = useState(10);
   const [appliedParams, setAppliedParams] = useState({});
@@ -169,7 +175,7 @@ export default function TableList() {
     setOrder(isAsc ? 'desc' : 'asc');
     setOrderBy(property);
     const params = Object.fromEntries([
-      ...customSearchParams.entries(),
+      ...searchParams.entries(),
       ['order', isAsc ? 'desc' : 'asc'],
       ['orderBy', property],
     ]);
@@ -177,37 +183,75 @@ export default function TableList() {
   };
   /* -------------------------------------------------------------------------- */
 
+  /* ----------------------------- Field Container ---------------------------- */
+  /* ----------------------------- division field ----------------------------- */
+  const [divisionValue, setDivisionValue] = useState('all');
+  const [divisionData, setDivisionData] = useState([]);
+
+  const handleDivisionChange = (event: SelectChangeEvent) => {
+    setDivisionValue(event.target.value as string);
+
+    if (event.target.value === 'all') {
+      searchParams.delete('division');
+      const params = Object.fromEntries([...searchParams.entries()]);
+      setAppliedParams(params);
+    } else {
+      const params = Object.fromEntries([
+        ...searchParams.entries(),
+        ['division', event.target.value as string],
+      ]);
+      setAppliedParams(params);
+    }
+  };
+  /* -------------------------------------------------------------------------- */
+
   /* ------------------------------ Search field ------------------------------ */
   const [searchText, setSearchText] = useState('');
 
-  const handleSearch = (event: React.ChangeEvent<HTMLInputElement>) => {
-    setSearchText(event.target.value);
-  };
-
   const handleSearchSubmit = async (event: React.FormEvent<HTMLFormElement>) => {
     event.preventDefault();
     setIsLoading(true);
-    const params = Object.fromEntries([...customSearchParams.entries(), ['search', searchText]]);
+    const params = Object.fromEntries([...searchParams.entries(), ['search', searchText]]);
     await new Promise((resolve) => setTimeout(resolve, 500));
     setAppliedParams(params);
     setIsLoading(false);
   };
   /* -------------------------------------------------------------------------- */
 
-  /* ---------------------------- table pagination ---------------------------- */
+  /* ------------------------------ import button ----------------------------- */
+  const [currentImportFileName, setCurrentImportFileName] = useState(null);
+  const importForm = useRef<HTMLInputElement>(null);
 
+  const handleImportChange = (event: any) => {
+    if (event.target.files[0]) {
+      setCurrentImportFileName(event.target.files[0].name);
+    } else {
+      setCurrentImportFileName(null);
+    }
+  };
+  /* -------------------------------------------------------------------------- */
+
+  /* ------------------------------ create button ----------------------------- */
+  const [anchorEl, setAnchorEl] = useState<null | HTMLElement>(null);
+  const handleClick = (event: React.MouseEvent<HTMLButtonElement>) => {
+    setAnchorEl(event.currentTarget);
+  };
+  /* -------------------------------------------------------------------------- */
+  /* -------------------------------------------------------------------------- */
+
+  /* ---------------------------- table pagination ---------------------------- */
   /* ------------------------ button change pagination ------------------------ */
   const onPageChangeHandle = async (
     event: React.MouseEvent<HTMLButtonElement> | null,
     newPage: number
   ) => {
     setIsLoading(true);
-    const params = Object.fromEntries([...customSearchParams.entries(), ['page', newPage + 1]]);
+    const params = Object.fromEntries([...searchParams.entries(), ['page', newPage + 1]]);
     setPage(newPage);
     await new Promise((resolve) => setTimeout(resolve, 500));
     setAppliedParams(params);
     setIsLoading(false);
-    // setCustomSearchParams.set('page', newPage + 1);
+    // setSearchParams.set('page', newPage + 1);
   };
   /* -------------------------------------------------------------------------- */
 
@@ -216,7 +260,7 @@ export default function TableList() {
     setIsLoading(true);
     setPage(0);
     const params = Object.fromEntries([
-      ...customSearchParams.entries(),
+      ...searchParams.entries(),
       ['per_page', parseInt(event.target.value, 10)],
     ]);
     setRowsPerPage(parseInt(event.target.value, 10));
@@ -225,52 +269,104 @@ export default function TableList() {
     setIsLoading(false);
   };
   /* -------------------------------------------------------------------------- */
-
   /* -------------------------------------------------------------------------- */
 
   useEffect(() => {
     (async () => {
       setIsLoading(true);
 
+      const division = await axios.get('/division');
+      setDivisionData(division.data);
+
       const params =
         Object.keys(appliedParams).length !== 0
           ? appliedParams
-          : Object.fromEntries([
+          : Object.fromEntries([...searchParams.entries(), ['order', order], ['orderBy', orderBy]]);
-              ...customSearchParams.entries(),
-              ['order', order],
-              ['orderBy', orderBy],
-            ]);
 
-      const response = await axios.get('http://localhost:8001/api/dashboard', {
+      const response = await axios.get('/dashboard', {
         params: params,
       });
 
-      const division = await axios.get('http://localhost:8001/api/division');
+      console.log(response);
-      setDataDivision(division.data);
 
-      setCustomSearchParams(params);
+      setSearchParams(params);
-      setDataTable(response.data.data);
+      // setDataTable(response.data.data);
-      setPaginationTable(response.data.meta);
+      // setPaginationTable(response.data.meta);
-      setRowsPerPage(response.data.meta.per_page);
+      // setRowsPerPage(response.data.meta.per_page);
       setIsLoading(false);
     })();
-  }, [appliedParams, customSearchParams, order, orderBy, setCustomSearchParams]);
+  }, [appliedParams, searchParams, order, orderBy, setSearchParams]);
 
   return (
     <Card>
       <Grid container>
         {/* Field 1 */}
         <Grid item xs={12} paddingX="24px" paddingY="20px">
-          <form onSubmit={handleSearchSubmit} style={{ width: '100%' }}>
+          <Grid container spacing={2}>
-            <TextField
+            <Grid item xs={12} lg={3} xl={2}>
-              id="search-input"
+              <FormControl fullWidth>
-              label="Search"
+                <InputLabel id="simple-division-select-lable">Division</InputLabel>
-              variant="outlined"
+                <Select
-              fullWidth
+                  labelId="simple-division-select-lable"
-              onChange={handleSearch}
+                  id="division-select-lable"
-              value={searchText}
+                  value={divisionValue}
-            />
+                  label="Division"
-          </form>
+                  onChange={handleDivisionChange}
+                >
+                  <MenuItem value="all">All</MenuItem>
+                  {divisionData.map((row: DivisionDataProps, index) => (
+                    <MenuItem key={index} value={row.id}>
+                      {row.name}
+                    </MenuItem>
+                  ))}
+                </Select>
+              </FormControl>
+            </Grid>
+            <Grid item xs={12} lg={5} xl={6}>
+              <form onSubmit={handleSearchSubmit}>
+                <TextField
+                  id="search-input"
+                  label="Search"
+                  variant="outlined"
+                  onChange={(event) => setSearchText(event.target.value)}
+                  value={searchText}
+                  fullWidth
+                />
+              </form>
+            </Grid>
+            <Grid item xs={12} lg={2} xl={2}>
+              <Button
+                id="import-button"
+                variant="outlined"
+                startIcon={<Iconify icon="material-symbols:download-rounded" />}
+                component="label"
+                fullWidth
+                sx={{ height: '100%' }}
+              >
+                Import
+                <input
+                  type="file"
+                  id="file"
+                  ref={importForm}
+                  style={{ display: 'none' }}
+                  onChange={handleImportChange}
+                  accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel, text/plain"
+                />
+              </Button>
+            </Grid>
+            <Grid item xs={12} lg={2} xl={2}>
+              <Button
+                id="import-button"
+                variant="contained"
+                startIcon={<AddIcon />}
+                onClick={handleClick}
+                fullWidth
+                sx={{ height: '100%' }}
+              >
+                Add Data
+              </Button>
+            </Grid>
+          </Grid>
         </Grid>
         {/* End Field 1 */}
         {/* Field 2 */}