Merge branch 'staging'

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

@@ -0,0 +1,136 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use App\Models\Claim;
+use App\Services\ClaimService;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Modules\Client\Transformers\ClaimShowResource;
+
+class ClaimController extends Controller
+{
+    public function __construct(public ClaimService $claimService)
+    {
+    }
+
+    public function status($corporate_id)
+    {
+        $claims = $this->claimService->getCountClaimRequestPerStatus($corporate_id);
+
+        dd($claims);
+
+        return Helper::responseJson([
+            'count_requested' => 0,
+            'count_approval' => 0,
+            'count_disbrushment' => 0,
+            'count_rejected' => 0,
+        ]);
+    }
+
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request, $corporate_id)
+    {
+        $claims = Claim::query()
+            ->when($request->search ?? null, function ($query, $search) {
+                $query->where('code', 'LIKE', '%' . $search . '%');
+            })
+            ->with([
+                'member',
+                'diagnoses' => function ($diagnosis) {
+                    return $diagnosis->where('type', 'primary');
+                },
+                'diagnoses.icd',
+                'plan',
+                'benefit',
+                'claimRequest',
+                'claimRequest.service'
+            ])
+            ->paginate(10);
+
+        return Helper::responseJson($claims);
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('client::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        $claim = Claim::query()
+            ->with([
+                'member',
+                'member.currentPlan',
+                'member.currentPlan.benefits',
+                'member.currentCorporate',
+                'member.currentPolicy',
+                'diagnosis',
+                'diagnoses',
+                'benefit',
+                'files',
+                'claimRequest',
+                'claimRequest.files',
+                'items',
+                'items.claim_itemable',
+            ])
+            ->findOrFail($id);
+
+        return Helper::responseJson(ClaimShowResource::make($claim));
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('client::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

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

@@ -3,110 +3,39 @@
 namespace Modules\Client\Http\Controllers\Api;
 
 use App\Helpers\Helper;
-use App\Models\Member;
+use App\Services\CorporateMemberService;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
-use Modules\Client\Transformers\MemberResources;
+use Modules\Client\Transformers\ClaimReport\MemberResources as ClaimReportMemberResources;
+use Modules\Client\Transformers\Dashboard\MemberResources as DashboardMemberResources;
+use Modules\Client\Transformers\Dashboard\MemberAlarmCenterResources as DashboardMemberAlarmResources;
 
 class CorporateMemberController extends Controller
 {
+    public function __construct(public CorporateMemberService $corporateMemberService)
+    {
+    }
+
     /**
      * Display a listing of the resource.
      * @return Renderable
      */
     public function index(Request $request, $corporate_id)
     {
-        $limit = $request->has('per_page') ? $request->per_page : 10;
-
-        $members = Member::query()
-            ->whereHas('employeds', function ($corporateEmployee) use ($corporate_id) {
-                $corporateEmployee->where('corporate_id', $corporate_id);
-            })->when($request->input('search'), function ($query, $search) {
-                $query->where('member_id', 'like', "%" . $search . "%")
-                    ->orWhere('name', 'like', "%" . $search . "%");
-            });
-
-        if ($request->input('claimMember') === 'false') {
-            $members = $members->when($request->input('division'), function ($division, $division_id) {
-                $division->whereHas('division', function ($corporateEmployee) use ($division_id) {
-                    $corporateEmployee->where('division_id', $division_id);
-                });
-            })->when($request->has('orderBy'), function ($query) use ($request) {
-                $query->orderBy($request->orderBy, $request->order);
-            });
+        switch ($request->input('type')) {
+            case 'claim-report':
+                $members = $this->corporateMemberService->getAllMemberClaimReports($corporate_id, $request);
+                return response()->json(Helper::paginateResources(ClaimReportMemberResources::collection($members)));
+            case 'claim-submit':
+                $members = $this->corporateMemberService->getAllMemberClaimReports($corporate_id, $request);
+                return response()->json(Helper::paginateResources(ClaimReportMemberResources::collection($members)));
+            case 'alarm-center':
+                $members = $this->corporateMemberService->getAllMemberAlarmCenter($corporate_id, $request);
+                return response()->json(Helper::paginateResources(DashboardMemberAlarmResources::collection($members)));
+            default:
+                $members = $this->corporateMemberService->getAllMemberDashboards($corporate_id, $request);
+                return response()->json(Helper::paginateResources(DashboardMemberResources::collection($members)));
         }
-        //  else {
-        //     $members = $members->get();
-
-        //     return response()->json(MemberResources::collection($members));
-        // }
-        $members->with('currentPlan');
-        $members->withSum('claims', 'total_claim');
-
-        $members = $members->paginate($limit);
-        // return $members;
-        
-        return response()->json(Helper::paginateResources(MemberResources::collection($members)));
-    }
-
-    /**
-     * Show the form for creating a new resource.
-     * @return Renderable
-     */
-    public function create()
-    {
-        return view('client::create');
-    }
-
-    /**
-     * Store a newly created resource in storage.
-     * @param Request $request
-     * @return Renderable
-     */
-    public function store(Request $request)
-    {
-        //
-    }
-
-    /**
-     * Show the specified resource.
-     * @param int $id
-     * @return Renderable
-     */
-    public function show($id)
-    {
-        return view('client::show');
-    }
-
-    /**
-     * Show the form for editing the specified resource.
-     * @param int $id
-     * @return Renderable
-     */
-    public function edit($id)
-    {
-        return view('client::edit');
-    }
-
-    /**
-     * Update the specified resource in storage.
-     * @param Request $request
-     * @param int $id
-     * @return Renderable
-     */
-    public function update(Request $request, $id)
-    {
-        //
-    }
-
-    /**
-     * Remove the specified resource from storage.
-     * @param int $id
-     * @return Renderable
-     */
-    public function destroy($id)
-    {
-        //
     }
 }

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

@@ -2,11 +2,12 @@
 
 namespace Modules\Client\Http\Controllers\Api;
 
+use App\Helpers\Helper;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
 use Illuminate\Support\Facades\Auth;
-use Modules\Client\Transformers\DashboardResources;
+use Modules\Client\Transformers\Dashboard\LimitResources;
 
 class CorporatePolicyController extends Controller
 {
@@ -14,25 +15,15 @@ class CorporatePolicyController extends Controller
      * Display a listing of the resource.
      * @return Renderable
      */
-    public function index(Request $request, $corporate_id)
+    public function index($corporate_id)
     {
-        $user = Auth::user();
-        $currentCorporate = $user->managedCorporates()
+        $currentCorporate = Auth::user()->managedCorporates()
             ->with(['currentPolicy', 'employees'])
             ->find($corporate_id);
 
-        $data = DashboardResources::make($currentCorporate);
+        $data = LimitResources::make($currentCorporate);
 
-        return response()->json($data);
-    }
-
-    /**
-     * Show the form for creating a new resource.
-     * @return Renderable
-     */
-    public function create()
-    {
-        return view('client::create');
+        return Helper::responseJson($data);
     }
 
     /**

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

@@ -0,0 +1,71 @@
+<?php
+
+namespace Modules\Client\Http\Controllers\Api;
+
+use App\Helpers\Helper;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\Auth;
+use Modules\Client\Transformers\Dashboard\TopUpLimitResources;
+
+class TopUpController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index($corporate_id)
+    {
+        $data = Auth::user()
+            ->managedCorporates()
+            ->with(['currentPolicy', 'employees'])
+            ->withCount(['employees', 'claims' => function ($query) {
+                $query->where('claims.status', 'paid');
+            }])
+            ->find($corporate_id);
+
+        return Helper::responseJson(TopUpLimitResources::make($data));
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('client::show');
+    }
+
+    /**
+     * 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/Routes/api.php

@@ -6,6 +6,8 @@ use Modules\Client\Http\Controllers\Api\CorporateManageController;
 use Modules\Client\Http\Controllers\Api\CorporateMemberController;
 use Modules\Client\Http\Controllers\Api\CorporatePolicyController;
 use Modules\Client\Http\Controllers\Api\UserController;
+use Modules\Client\Http\Controllers\Api\ClaimController;
+use Modules\Client\Http\Controllers\Api\TopUpController;
 
 /*
 |--------------------------------------------------------------------------
@@ -34,6 +36,13 @@ Route::prefix('client')->group(function () {
             Route::get('policy', [CorporatePolicyController::class, 'index']);
             Route::get('division', [CorporateDivisionController::class, 'index']);
             Route::get('members', [CorporateMemberController::class, 'index']);
+            Route::get('claims/status', [ClaimController::class, 'status']);
+            Route::get('claims', [ClaimController::class, 'index']);
+
+            Route::get('topup', [TopUpController::class, 'index']);
+            Route::post('topup', [TopUpController::class, 'store']);
         });
+
+        Route::get('claims/{id}', [ClaimController::class, 'show']);
     });
 });

Modules/Client/Transformers/ClaimReport/MemberResources.php

@@ -0,0 +1,26 @@
+<?php
+
+namespace Modules\Client\Transformers\ClaimReport;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MemberResources extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        return [
+            'id' => $this->id,
+            'memberId' => $this->member_id,
+            'fullName' => $this->full_name,
+            'division' => $this->division_name ?? '',
+            'submission_date' => '',
+            'status' => $this->active,
+        ];
+    }
+}

Modules/Client/Transformers/ClaimShowResource.php

@@ -0,0 +1,41 @@
+c<?php
+
+namespace Modules\Client\Transformers;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class ClaimShowResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        $data = parent::toArray($request);
+        // $data['']
+        $data['benefit_items'] = $this->items
+            ->filter(function ($item) {
+                return $item->claim_itemable_type == Benefit::class;
+            })
+            ->map(function ($item) {
+                $itemData = $item->claim_itemable->toArray();
+                $itemData['nominal_dicover'] = $item['nominal_dicover'] ?? 0;
+                $itemData['nominal_ditagihkan'] = $item['nominal_ditagihkan'] ?? 0;
+                $itemData['nominal_total'] = $item['nominal_total'] ?? 0;
+                
+                // For React Frotnend
+                $itemData['biaya_diajukan'] = $itemData['nominal_ditagihkan'];
+                $itemData['biaya_disetujui'] = $itemData['nominal_dicover'];
+
+                return $itemData;
+            });
+
+            $data['primary_diagnosis'] = $this->diagnoses->filter(function($diagnosis){ return $diagnosis->type == 'primary';})->values();
+            $data['secondary_diagnosis'] = $this->diagnoses->filter(function($diagnosis){ return $diagnosis->type == 'secondary';})->values();
+
+        return $data;
+    }
+}

Modules/Client/Transformers/Dashboard/LimitResources.php

@@ -1,11 +1,10 @@
 <?php
 
-namespace Modules\Client\Transformers;
+namespace Modules\Client\Transformers\Dashboard;
 
-use App\Helpers\Helper;
 use Illuminate\Http\Resources\Json\JsonResource;
 
-class DashboardResources extends JsonResource
+class LimitResources extends JsonResource
 {
     /**
      * Transform the resource into an array.
@@ -22,17 +21,15 @@ class DashboardResources extends JsonResource
         $lockPercentage = (int)$this->currentPolicy->minimal_stop_service_percentage;
 
         return [
-            'policy' => [
-                'myLimit' => [
-                    'balance' => $myLimitBalance,
-                    'total' => $myLimitTotal,
-                    'percentage' => $myLimitTotal ? (($myLimitBalance / $myLimitTotal) * 100) : 0,
-                ],
-                'lockLimit' => [
-                    'balance' => $lockBalance,
-                    'percentage' => $lockPercentage
-                ]
+            'myLimit' => [
+                'balance' => $myLimitBalance,
+                'total' => $myLimitTotal,
+                'percentage' => $myLimitTotal ? round(($myLimitBalance / $myLimitTotal) * 100, 2) : 0,
             ],
+            'lockLimit' => [
+                'balance' => $lockBalance,
+                'percentage' => $lockPercentage
+            ]
         ];
     }
 }

Modules/Client/Transformers/Dashboard/MemberAlarmCenterResources.php

@@ -0,0 +1,26 @@
+<?php
+namespace Modules\Client\Transformers\Dashboard;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MemberAlarmCenterResources extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request  $request
+     * @return array|\Illuminate\Contracts\Support\Arrayable|\JsonSerializable
+     */
+    public function toArray($request)
+    {
+        return [
+            'id' => $this->id,
+            'memberId' => $this->member_id,
+            'fullName' => $this->full_name,
+            'service' => $this->service_code,
+            'start_date' => $this->start_date,
+            'end_date' => $this->end_date,
+            'status' => $this->active,
+        ];
+    }
+}

Modules/Client/Transformers/Dashboard/MemberResources.php

@@ -1,6 +1,6 @@
 <?php
 
-namespace Modules\Client\Transformers;
+namespace Modules\Client\Transformers\Dashboard;
 
 use Illuminate\Http\Resources\Json\JsonResource;
 
@@ -18,15 +18,13 @@ class MemberResources extends JsonResource
             'id' => $this->id,
             'memberId' => $this->member_id,
             'fullName' => $this->full_name,
-            $this->mergeWhen($request->input('claimMember') === 'false', [
-                'division' => $this->division->name ?? '',
-                'status' => $this->active
-            ]),
+            'division' => $this->division_name ?? '',
             'limit' => [
-                'current' => $this->claims_sum_total_claim,
+                'current' => $this->claims_sum_total_claim ?? 0,
                 'total' => $this->currentPlan->limit_rules ?? 0,
                 'percentage' => (!empty($this->currentPlan->limit_rules ?? 0)) ? (($this->claims_sum_total_claim / $this->currentPlan->limit_rules) * 100) : 0
             ],
+            'status' => $this->active,
         ];
     }
 }

Modules/Client/Transformers/Dashboard/TopUpLimitResources.php

@@ -0,0 +1,33 @@
+<?php
+
+namespace Modules\Client\Transformers\Dashboard;
+
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class TopUpLimitResources extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @param  \Illuminate\Http\Request
+     * @return array
+     */
+    public function toArray($request)
+    {
+        $myLimitBalance = (int)$this->currentPolicy->limit_balance;
+        $myLimitTotal = (int)$this->currentPolicy->total_premi;
+
+        return [
+            'companyName' => $this->name,
+            'policyNumber' => $this->currentPolicy->code,
+            'totalMembers' => $this->employees_count,
+            'totalCases' => $this->claims_count,
+            'myLimit' => [
+                'balance' => $myLimitBalance,
+                'total' => $myLimitTotal,
+                'percentage' => $myLimitTotal ? round(($myLimitBalance / $myLimitTotal) * 100, 2) : 0,
+            ],
+            'maxTopUp' => ($myLimitTotal - $myLimitBalance)
+        ];
+    }
+}

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

@@ -62,10 +62,11 @@ class ClaimRequestController extends Controller
     {
         $request->validate([
             'member_id' => 'required',
+            'service_code' => 'required|in:OP,IP'
         ]);
 
         $member = Member::find($request->member_id);
-        $newClaimRequest = ClaimRequestService::storeClaimRequest(member: $member);
+        $newClaimRequest = ClaimRequestService::storeClaimRequest(member: $member, paymentType: 'reimbursement', serviceCode: $request->service_code);
 
         ClaimRequested::dispatch($newClaimRequest);
 

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

@@ -2,14 +2,18 @@
 
 namespace Modules\Internal\Http\Controllers\Api;
 
+use App\Helpers\Helper;
 use App\Models\Benefit;
 use App\Models\Claim;
 use App\Models\Icd;
 use App\Models\Member;
+use App\Models\Organization;
 use App\Services\ClaimService;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
+use Modules\Internal\Transformers\ClaimShowResource;
+use PDF;
 
 class ClaimController extends Controller
 {
@@ -21,9 +25,14 @@ class ClaimController extends Controller
     {
         $claims = Claim::with([
                             'member',
-                            'diagnosis',
+                            'diagnoses' => function ($diagnosis) {
+                                return $diagnosis->where('type', 'primary');
+                            },
+                            'diagnoses.icd',
                             'plan', 
-                            'benefit'
+                            'benefit',
+                            'claimRequest',
+                            'claimRequest.service'
                         ])
                         ->latest()
                         ->paginate(10);
@@ -87,13 +96,27 @@ class ClaimController extends Controller
                 ->with([
                     'member', 
                     'member.currentPlan', 
-                    'diagnosis',
+                    'member.currentPlan.benefits',
+                    'member.currentCorporate',
+                    'member.currentPolicy',
+                    // 'diagnosis',
+                    'diagnoses',
+                    'diagnoses.icd',
                     'benefit',
-                    'files'
+                    'files',
+                    'claimRequest',
+                    'claimRequest.files',
+                    'items',
+                    'items.claim_itemable',
+                    'encounters',
+                    'encounters.doctors',
+                    'encounters.primaryDiagnoses',
+                    'encounters.primaryDiagnoses.diagnosis',
+                    'encounters.healthcare'
                     ])
                 ->findOrFail($id);
 
-        return response()->json($claim);
+        return Helper::responseJson(ClaimShowResource::make($claim));
     }
 
     /**
@@ -131,4 +154,135 @@ class ClaimController extends Controller
     {
         return true;
     }
+
+    public function updateDetails(Request $request, $id)
+    {
+        $request->validate([
+            'healthcare_id' => 'required',
+            'doctor_id' => 'required',
+            'start' => 'required',
+            'end' => 'required'
+        ]);
+
+        $claim = Claim::findOrFail($id);
+
+        return $claim;
+    }
+    
+    public function updateItems(Request $request, $id)
+    {
+        $request->validate([]);
+        $claim = Claim::findOrFail($id);
+        
+        $order = 1;
+        $data = [];
+        $claim->items()->forceDelete();
+        foreach ($request->benefit_items as $benefitItem) {
+            $benefit = Benefit::find($benefitItem['id']);
+            if ($benefit) {
+                $benefit->claimItem()->create([
+                    'claim_id' => $claim->id,
+                    'order' => $order,
+                    'name' => $benefit->code,
+                    'currency' => 'IDR',
+                    'nominal_ditagihkan' => $benefitItem['biaya_diajukan'] ?? 0,
+                    'nominal_dicover' => $benefitItem['biaya_disetujui'] ?? 0,
+                    'nominal_total' => $benefitItem['biaya_disetujui'] ?? 0,
+                ]);
+            }
+
+            $order++;
+        }
+        return Helper::responseJson([], message: "Item Claim berhasil di update");
+    }
+
+    public function updateDiagnosis(Request $request, $id)
+    {
+        $request->validate([]);
+        $claim = Claim::findOrFail($id);
+
+        $claim->diagnoses()->forceDelete();
+        if ($request->primary) {
+            foreach ($request->primary as $diagnosisId) {
+                    $claim->diagnoses()->create([
+                        'claim_id' => $claim->id,
+                        'type' => 'primary', 
+                        'diagnosis_id' => $diagnosisId,
+                        'note' => '',
+                        'description' => '',
+                    ]);
+            }
+        }
+
+        if ($request->secondary) {
+            foreach ($request->secondary as $diagnosisId) {
+                $claim->diagnoses()->create([
+                    'claim_id' => $claim->id,
+                    'type' => 'secondary', 
+                    'diagnosis_id' => $diagnosisId,
+                    'note' => '',
+                    'description' => '',
+                ]);
+            }
+        }
+
+        return Helper::responseJson([], message: "Diagnosis berhasil di update");
+    }
+
+    public function decline($id)
+    {
+        $claim = Claim::findOrFail($id);
+        $claim->status = 'declined';
+        $claim->save();
+
+        return Helper::responseJson($claim, message: "Claim berhasil di decline");
+    }
+
+    public function approve($id)
+    {
+        $claim = Claim::findOrFail($id);
+        $claim->status = 'approved';
+        $claim->save();
+
+        return Helper::responseJson($claim, message: "Claim berhasil di approve");
+    }
+
+    public function reOpen($id)
+    {
+        $claim = Claim::findOrFail($id);
+        $claim->status = 'received';
+        $claim->save();
+
+        return Helper::responseJson($claim, message: "Claim berhasil di approve");
+    }
+
+    public function downloadFinalLog($id)
+    {
+        $claim = Claim::findOrFail($id);
+
+        $hospital = $claim->finalEncounter->healthcare ?? null;
+
+        // TODO Fix this tipu tipu
+        $inpationBenefit = $claim->member->currentPlan->benefits()->first();
+        
+        $pdf = PDF::loadView('pdf.final_log', [
+            'claim' => $claim,
+            'member' => $claim->member,
+            'dateOfAdmission' => $claim->start,
+            'hospital' => $hospital,
+            'inpationBenefit' => $inpationBenefit
+        ]);
+        
+        return $pdf->download('Final LOG '.$claim->code.'.pdf');
+
+        $view = view('pdf.final_log', [
+            'claim' => $claim,
+            'member' => $claim->member,
+            'dateOfAdmission' => $claim->start,
+            'hospital' => $hospital,
+            'inpationBenefit' => $inpationBenefit
+        ]);
+
+        return $view;
+    }
 }

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

@@ -4,12 +4,10 @@ namespace Modules\Internal\Http\Controllers\Api;
 
 use App\Helpers\Helper;
 use App\Models\ClaimRequest;
-use App\Models\Member;
-use Exception;
+use App\Services\ClaimService;
 use Illuminate\Contracts\Support\Renderable;
 use Illuminate\Http\Request;
 use Illuminate\Routing\Controller;
-use Knp\Snappy\Pdf;
 use Modules\Internal\Transformers\ClaimRequestResource;
 use Modules\Internal\Transformers\ClaimRequestShowResource;
 
@@ -36,7 +34,7 @@ class ClaimRequestController extends Controller
                                 ->when($request->status, function($q, $status) {
                                     $q->where('status', $status);
                                 })
-                                ->with(['member', 'files'])
+                                ->with(['member', 'files', 'service'])
                                 ->paginate();
 
         return Helper::paginateResources(ClaimRequestResource::collection($claimRequests));
@@ -115,19 +113,31 @@ class ClaimRequestController extends Controller
         $claimRequest = ClaimRequest::findOrFail($id);
         $member = $claimRequest->member;
         
-        $claimRequest->status = 'approved';
-        $claimRequest->save();
-        
-        // Store Generated Documents
-        $logContent = view('pdf.guaranted_leter', compact('member', 'claimRequest'));
-        $claimRequest->generatedDocuments()->create([
-            'type' => 'guarantee_letter',
-            'title' => 'Guarantee Letter for '. $member->full_name,
-            'document_type' => 'type',
-            'html_content' => $logContent,
-            'system_origin' => 'primecenter'
-        ]);
+        try {
+
+            // Create New Claim
+            $newClaim = ClaimService::storeClaim(member: $member, status: 'received', claimRequest: $claimRequest);
+            
+            // Update Claim Request Status & Link with Claim
+            $claimRequest->status = 'approved';
+            $claimRequest->claim_id = $newClaim->id;
+            $claimRequest->save();
+            
+            // Store Generated Documents LOG
+            $logContent = view('pdf.guaranted_leter', compact('member', 'claimRequest'));
+            $claimRequest->generatedDocuments()->create([
+                'type' => 'guarantee_letter',
+                'title' => 'Guarantee Letter for '. $member->full_name,
+                'document_type' => 'type',
+                'html_content' => $logContent,
+                'system_origin' => 'primecenter'
+            ]);
+
+        } catch (\Exception $e) {
+
+        }
 
         return $claimRequest;
     }
+
 }

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

@@ -77,6 +77,7 @@ class CorporateController extends Controller
      */
     public function store(Request $request)
     {
+       
         $request->validate([
             'code' => 'required|regex:/^[a-zA-Z0-9]+$/',
             'name' => 'required',
@@ -90,7 +91,6 @@ 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();
@@ -98,7 +98,6 @@ class CorporateController extends Controller
 
             $newCorporate = Corporate::create($request->all());
             if ($request->has('policy_code') && !empty($request->policy_code)) {
-                // dd($request->policy_code, 'fuck you');
                 $newCorporate->policies()->create([
                     'code' => $request->policy_code ?? NULL,
                     'total_premi' => $request->policy_total_premi ?? NULL,
@@ -397,7 +396,6 @@ class CorporateController extends Controller
         $request->validate([
             'file' => 'required|file|mimes:xls,xlsx,csv,txt',
         ]);
-        // dd($request->toArray());
         $file_name = now()->getPreciseTimestamp(3) . '-' . $request->file('file')->getClientOriginalName();
         $file = $request->file('file')->storeAs('temp', $file_name);
         $corporate = Corporate::with(['plans'])->findOrFail($corporate_id);
@@ -521,4 +519,5 @@ class CorporateController extends Controller
                 break;
         }
     }
+    
 }

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

@@ -155,7 +155,7 @@ class CorporateMemberController extends Controller
         $result_headers = $this->memberEnrollmentService->result_doc_headers;
         $singleRow = WriterEntityFactory::createRow($this->memberEnrollmentService->makeResultRow($result_headers));
         $writer->addRow($singleRow);
-
+      
         $imported_member_data = 0;
         $failed_member_data = [];
         foreach ($reader->getSheetIterator() as $sheet) {
@@ -181,7 +181,7 @@ class CorporateMemberController extends Controller
                     }
 
                     try {
-                        // dd($new_member_data);
+                      
                         $rowResponse = $this->memberEnrollmentService->handleImportRow($corporate, $new_member_data);
 
                         // Write Success Result to File

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

@@ -91,7 +91,8 @@ class DivisionController extends Controller
         $request->validate([
             'code' => [
                 'required',
-                Rule::unique('corporate_plans')->where('corporate_id', $corporate_id)->ignore($corporatePlan->id)
+                // Rule::unique('corporate_plans')->where('corporate_id', $corporate_id)->ignore($corporatePlan->id)
+                Rule::unique('corporate_divisions')->where('corporate_id', $corporate_id)
             ],
             'name' => 'required'
         ]);

Modules/Internal/Http/Controllers/Api/Linksehat/PaymentController.php

@@ -0,0 +1,136 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers\Api\Linksehat;
+
+use App\Helpers\Helper;
+use App\Models\OLDLMS\Appointment;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Modules\Internal\Transformers\LinksehatPaymentResource;
+
+class PaymentController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        // return $request->toArray();
+        $appointments = Appointment::query()
+            ->where('sPaymentStatus', 'settlement')
+            ->with(['healthCare', 'healthCare.commission', 'detail', 'user', 'doctor', 'doctor.user']);
+
+        if ($request->has('search')) {
+            $appointments->where(function ($query) use ($request) {
+                $query->where('nID', $request->search)
+                    ->orWhere('sBookingCode', $request->search)
+                    ->orWhereHas('detail', function (Builder $detail) use ($request) {
+                        $detail->where('sPaymentDetails', 'LIKE', '%' . $request->search . "%");
+                    });
+            });
+        }
+
+        if (($request->has('appointment_start') || $request->has('appointment_end'))
+            && !empty($request->appointment_start)
+            && !empty($request->appointment_end)
+        ) {
+            // $appointments = $appointments->whereHas('detail', function (Builder $detail) use ($request) {
+
+            //     // Appointment Start
+            //     // if ($request->has('appointment_start')) {
+            //     $detail->where('dTanggalAppointment', '>=', $request->appointment_start);
+            //     // } else {
+            //     //     $detail->where('dTanggalAppointment', '>', now()->format('Y-m-d'));
+            //     // }
+
+            //     // if ($request->has('appointment_end')) {
+            //     $detail->where('dTanggalAppointment', '<=', $request->appointment_end);
+            //     // } else {
+            //     //     $detail->where('dTanggalAppointment', '<', now()->addDay(1)->format('Y-m-d'));
+            //     // }
+
+            // });
+
+            $appointments = $appointments->where(function($q) use ($request) {
+                $q->where('dAgreeOn', '>=', $request->appointment_start)
+                    ->where('dAgreeOn', '<=', $request->appointment_end);
+            });
+        }
+
+        if ($request->has('payment_status') && $request->payment_status != 'semua') {
+            $appointments->where('sPaymentStatus', $request->payment_status);
+        }
+
+        if ($request->has('healthcare_id') && !empty($request->healthcare_id)) {
+            $appointments->where('nIDHealthCare', $request->healthcare_id);
+        }
+
+        $appointments = $appointments->orderBy('dUpdateOn', 'DESC')
+            ->paginate();
+
+        return Helper::responseJson(Helper::paginateResources(LinksehatPaymentResource::collection($appointments)));
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

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

@@ -0,0 +1,141 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers\Api;
+
+use App\Models\Icd;
+use App\Models\OLDLMS\Healthcare;
+use App\Models\Organization;
+use App\Models\Practitioner;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+
+class OptionController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index(Request $request)
+    {
+        $request->validate([
+            'type' => 'required',
+            'search' => 'required'
+        ]);
+
+        switch ($request->type) {
+            case 'diagnosis':
+                $icds = Icd::query()
+                    ->where('code', 'LIKE', '%'.$request->search.'%')
+                    ->orWhere('name', 'LIKE', '%'.$request->search.'%')
+                    ->limit('10')
+                    ->get();
+
+                return $icds;
+                break;
+            case 'doctors':
+                $doctors = Practitioner::query()
+                    ->whereHas('person', function ($person) use ($request) {
+                        $person->where('name', 'LIKE', '%'.$request->search.'%');
+                    })
+                    ->limit('10')
+                    ->get();
+                
+                $doctors = $doctors->map(function($doctor) {
+                    $doctorDetail = $doctor->person->toArray();
+                    unset($doctorDetail['id']);
+
+                    return array_merge([
+                        'id' => $doctor->id,
+                        'code' => $doctor->code
+                    ], $doctorDetail);
+                });
+
+                return $doctors;
+                break;
+            case 'healthcares':
+                $healthcares = Organization::query()
+                    ->hospital()
+                    ->where('name', 'LIKE', '%'.$request->search.'%')
+                    ->limit('10')
+                    ->get();
+                    
+                return $healthcares;
+                break;
+            case 'linksehat-healthcares':
+                $healthcares = Healthcare::query()
+                    ->where('sHealthCare', 'LIKE', '%'.$request->search.'%')
+                    ->limit('10')
+                    ->get();
+                    
+                return $healthcares;
+                break;
+            
+            default:
+                # code...
+                break;
+        }
+
+        return view('internal::index');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     * @return Renderable
+     */
+    public function create()
+    {
+        return view('internal::create');
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     * @param Request $request
+     * @return Renderable
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+}

Modules/Internal/Http/Controllers/ClaimEncounterController.php

@@ -0,0 +1,281 @@
+<?php
+
+namespace Modules\Internal\Http\Controllers;
+
+use App\Helpers\Helper;
+use App\Models\Claim;
+use App\Models\Encounter;
+use App\Models\Practitioner;
+use Illuminate\Contracts\Support\Renderable;
+use Illuminate\Http\Request;
+use Illuminate\Routing\Controller;
+use Illuminate\Support\Facades\DB;
+use Modules\Internal\Transformers\EncounterResource;
+
+class ClaimEncounterController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     * @return Renderable
+     */
+    public function index()
+    {
+        return view('internal::index');
+    }
+
+    /**
+     * 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, $claim_id)
+    {
+        $request->validate([
+            'service_code' => 'required',
+            'tanggal_masuk' => 'required',
+            'tanggal_keluar' => 'required'
+        ]);
+        $claim = Claim::findOrFail($claim_id);
+
+        // return ($request->primary_diagnosis['id']);
+        // die;
+        // return $request->toArray();
+        try {
+            DB::beginTransaction();
+
+            $newEncounterData = [
+                'status' => 'completed',
+                'class' => $request->service_code,
+                'type' => 'Consultation',
+                'patient_id' => $claim->member->person_id,
+                'start' => $request->tanggal_masuk,
+                'end' => $request->tanggal_keluar,
+                'number_of_bed' => $request->number_of_bed,
+                'duration_day' => $request->duration_day
+            ];
+
+            if ($request->has('healthcare')) {
+                $newEncounterData['healthcare_id'] = $request->healthcare['id'];
+            }
+
+            // Create New Encounter
+            $newEncounter = $claim->encounters()->create($newEncounterData);
+
+            
+            // --------------------------------------------
+            // Meta
+            // TODO Handle if healthcare not primaya
+            $newEncounter->metas()->updateOrCreate([
+                'type' => 'MEDRECID',
+                'system' => 'primaya-his' 
+            ], [
+                'type' => 'MEDRECID',
+                'system' => 'primaya-his',
+                'value' => $request->medical_record_number
+            ]);
+            
+            // ---------------------------------------------
+            // Handle Diagnosis
+            if ($request->has('primary_diagnosis') && $request->primary_diagnosis) {
+                $newEncounter->diagnoses()->create([
+                    'diagnosis_id' => $request->primary_diagnosis['id'],
+                    'type' => 'primary',
+                    'use' => 'discharge',
+                    'source' => 'primecenter',
+                    'description' => 'Batching',
+                ]);
+            }
+
+            if ($request->has('secondary_diagnoses')) {
+                foreach ($request->secondary_diagnoses as $diagnosis) {
+                    if (!isset($diagnosis['id'])) { // Handle Null Values
+                        continue;
+                    }
+                    $newEncounter->diagnoses()->create([
+                        'diagnosis_id' => $diagnosis['id'],
+                        'type' => 'secondary',
+                        'use' => 'discharge',
+                        'source' => 'primecenter',
+                        'description' => 'Batching',
+                    ]);
+                }
+            }
+
+            // ------------------------------------
+            // Handle Doctors as primary Doctor
+            if ($request->has('doctor')) {
+                $newEncounter->participants()->create([
+                    'type' => 'Doctor',
+                    'participantable_type' => Practitioner::class,
+                    'participantable_id' => $request->doctor['id'],
+                ]);
+            }
+            DB::commit();
+            
+            $newEncounter->load(['diagnoses', 'doctors', 'healthcare']);
+            
+            return Helper::responseJson(data: EncounterResource::make($newEncounter), message: 'Encounter berhasil ditambahkan');
+
+        } catch (\Exception $e) {
+            DB::rollback();
+            throw $e;
+        }
+    }
+
+    /**
+     * Show the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function show($id)
+    {
+        return view('internal::show');
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     * @param int $id
+     * @return Renderable
+     */
+    public function edit($id)
+    {
+        return view('internal::edit');
+    }
+
+    /**
+     * Update the specified resource in storage.
+     * @param Request $request
+     * @param int $id
+     * @return Renderable
+     */
+    public function update(Request $request, $claim_id, $encounter_id)
+    {
+        $request->validate([
+            'service_code' => 'required',
+            'tanggal_masuk' => 'required',
+            'tanggal_keluar' => 'required'
+        ]);
+        // $claim = Claim::findOrFail($claim_id);
+
+        // return ($request->primary_diagnosis['id']);
+        // die;
+        // return $request->toArray();
+        try {
+            DB::beginTransaction();
+
+            $encounter = Encounter::findOrFail($encounter_id);
+
+            $encounterData = [
+                'status' => 'completed',
+                'class' => $request->service_code,
+                'type' => 'Consultation',
+                'start' => $request->tanggal_masuk,
+                'end' => $request->tanggal_keluar,
+                'number_of_bed' => $request->number_of_bed,
+                'duration_day' => $request->duration_day
+            ];
+
+            if ($request->has('healthcare')) {
+                $encounterData['healthcare_id'] = $request->healthcare['id'];
+            }
+
+            // Update The Encounter
+            $encounter->fill($encounterData);
+            $encounter->save();
+
+            
+            // --------------------------------------------
+            // Meta
+            // TODO Handle if healthcare not primaya
+            $encounter->metas()->updateOrCreate([
+                'type' => 'MEDRECID',
+                'system' => 'primaya-his' 
+            ], [
+                'type' => 'MEDRECID',
+                'system' => 'primaya-his',
+                'value' => $request->medical_record_number
+            ]);
+            
+            // ---------------------------------------------
+            // Handle Diagnosis
+            if ($request->has('primary_diagnosis')) {
+                $encounter->diagnoses()->where('type', 'primary')->delete();
+                $encounter->diagnoses()->create([
+                    'diagnosis_id' => $request->primary_diagnosis['id'],
+                    'type' => 'primary',
+                    'use' => 'discharge',
+                    'source' => 'primecenter',
+                    'description' => 'Batching',
+                ]);
+            }
+
+            if ($request->has('secondary_diagnoses')) {
+                $encounter->diagnoses()->where('type', 'secondary')->delete();
+                foreach ($request->secondary_diagnoses as $diagnosis) {
+                    if (!isset($diagnosis['id'])) { // Handle Null Values
+                        continue;
+                    }
+                    $encounter->diagnoses()->create([
+                        'diagnosis_id' => $diagnosis['id'],
+                        'type' => 'secondary',
+                        'use' => 'discharge',
+                        'source' => 'primecenter',
+                        'description' => 'Batching',
+                    ]);
+                }
+            }
+
+            // ------------------------------------
+            // Handle Doctors as primary Doctor
+            // if ($request->has('doctor')) {
+            //     $encounter->participants()->create([
+            //         'type' => 'Doctor',
+            //         'participantable_type' => Practitioner::class,
+            //         'participantable_id' => $request->doctor['id'],
+            //     ]);
+            // }
+            DB::commit();
+            
+            $encounter->load(['diagnoses', 'doctors', 'healthcare']);
+            
+            return Helper::responseJson(data: EncounterResource::make($encounter), message: 'Encounter berhasil ditambahkan');
+
+        } catch (\Exception $e) {
+            DB::rollback();
+            throw $e;
+        }
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     * @param int $id
+     * @return Renderable
+     */
+    public function destroy($id)
+    {
+        //
+    }
+
+    public function setFinalEncounter(Request $request, $claim_id)
+    {
+        $request->validate([
+            'encounter_id' => 'required'
+        ]);
+
+        $claim = Claim::findOrFail($claim_id);
+
+        $claim->final_encounter_id = $request->encounter_id;
+        $claim->save();
+
+        return Helper::responseJson(data: $claim, message: "Success Update Final Encounter");
+    }
+}

Modules/Internal/Routes/api.php

@@ -21,13 +21,16 @@ use Modules\Internal\Http\Controllers\Api\DivisionController;
 use Modules\Internal\Http\Controllers\Api\DoctorController;
 use Modules\Internal\Http\Controllers\Api\DrugController;
 use Modules\Internal\Http\Controllers\Api\FormulariumController;
+use Modules\Internal\Http\Controllers\Api\Linksehat\PaymentController;
 use Modules\Internal\Http\Controllers\Api\LivechatController;
 use Modules\Internal\Http\Controllers\Api\MemberController;
+use Modules\Internal\Http\Controllers\Api\OptionController;
 use Modules\Internal\Http\Controllers\Api\OrganizationController;
 use Modules\Internal\Http\Controllers\Api\PlanController;
 use Modules\Internal\Http\Controllers\Api\ProvinceController;
 use Modules\Internal\Http\Controllers\Api\SpecialityController;
 use Modules\Internal\Http\Controllers\Api\VillageController;
+use Modules\Internal\Http\Controllers\ClaimEncounterController;
 
 /*
 |--------------------------------------------------------------------------
@@ -47,6 +50,8 @@ Route::prefix('internal')->group(function () {
     Route::post('forget-password', [AuthController::class, 'forgetPassword'])->name('forget-password');
     Route::post('verify-email', [AuthController::class, 'verifyEmail'])->name('verify-email');
 
+    Route::get('linksehat/payments', [PaymentController::class, 'index']);
+
 
     Route::middleware('auth:sanctum')->group(function () {
 
@@ -118,7 +123,16 @@ Route::prefix('internal')->group(function () {
         Route::get('members', [MemberController::class, 'index']);
         Route::get('members/{member_id}/benefits', [MemberController::class, 'benefits']);
 
+        Route::post('claims/{claim_id}/encounters', [ClaimEncounterController::class, 'store']);
+        Route::post('claims/{claim_id}/encounters/{encounter_id}/update', [ClaimEncounterController::class, 'update']);
+        Route::post('claims/{claim_id}/set-final-encounter', [ClaimEncounterController::class, 'setFinalEncounter']);
+
         Route::get('claims', [ClaimController::class, 'index']);
+        Route::post('claims/{id}/update-items', [ClaimController::class, 'updateItems'])->name('claim.update-items');
+        Route::post('claims/{id}/update-diagnosis', [ClaimController::class, 'updateDiagnosis'])->name('claim.update-diagnosis');
+        Route::post('claims/{id}/decline', [ClaimController::class, 'decline'])->name('claim.decline');
+        Route::post('claims/{id}/approve', [ClaimController::class, 'approve'])->name('claim.approve');
+        Route::post('claims/{id}/re-open', [ClaimController::class, 'reOpen'])->name('claim.re-open');
         Route::post('claims', [ClaimController::class, 'store']);
         Route::get('claims/{id}', [ClaimController::class, 'show']);
         Route::post('check-limit', [ClaimController::class, 'checkLimit']);
@@ -142,4 +156,7 @@ Route::prefix('internal')->group(function () {
     Route::get('city', [CityController::class, 'index']);
     Route::get('district', [DistrictController::class, 'index']);
     Route::get('village', [VillageController::class, 'index']);
+    Route::get('options', [OptionController::class, 'index']);
+
+    Route::get('final-log/{id}', [ClaimController::class, 'downloadFinalLog'])->name('claim.download-final-log');
 });

Modules/Internal/Services/ClaimService.php

@@ -1,11 +0,0 @@
-<?php
-
-namespace Modules\Internal\Services;
-
-use App\Models\Claim;
-use Illuminate\Support\Facades\DB;
-
-class ClaimService
-{
-    
-}

Modules/Internal/Services/CorporateService.php

@@ -39,11 +39,10 @@ class CorporateService
         try {
             $plan_data = $row;
             $plan_data["corporate_id"] = $corporate->id;
-
             $this->validatePlanRow($plan_data);
-
             $plan = $corporate->plans()->updateOrCreate([
-                'service_code' => $plan_data['service_code'],
+                'corporate_plan_id' => $plan_data['corporate_plan_id'],
+                // 'active' => 0,
             ], $plan_data);
 
             return $plan;
@@ -102,7 +101,8 @@ class CorporateService
             ], [
                 'code' => $benefit_data['code'],
                 'service_code' => $plan->service_code,
-                'active' => true
+                'active' => 1,
+                'description' => $benefit_data['description'],
             ]);
 
             $corporateBenefit = $corporate->corporateBenefits()->updateOrCreate([