One Hat Cyber Team

View File Name : MedicineBillRepository.php

<?php

namespace App\Repositories;

use App\Models\Medicine;
use App\Models\MedicineBill;
use App\Models\SaleMedicine;
use App\Models\Setting;
use App\Models\SuperAdminSetting;
use App\Models\User;
use Exception;
use Filament\Notifications\Notification;
use GuzzleHttp\Client;
use Illuminate\Support\Facades\DB;
use Razorpay\Api\Api;
use Stripe\Checkout\Session;
use Symfony\Component\HttpKernel\Exception\UnprocessableEntityHttpException;

/**
 * Class DoctorRepository
 *
 * @version February 13, 2020, 8:55 am UTC
 */
class MedicineBillRepository extends BaseRepository
{
    /**
     * @var array
     */
    protected $fieldSearchable = [
        'to',
        'subject',
    ];

    /**
     * Return searchable fields
     */
    public function getFieldsSearchable(): array
    {
        return $this->fieldSearchable;
    }

    /**
     * Configure the Model
     **/
    public function model()
    {
        return MedicineBill::class;
    }

    public function update($medicineBill, $input): bool
    {
        try {
            DB::beginTransaction();
            $input['payment_status'] = isset($input['payment_status']) ? 1 : $medicineBill->payment_status;
            foreach ($input['medicine'] as $key => $inputSale) {
                if (empty($input['medicine'][$key]) && $input['payment_status'] == false) {

                    throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
                }
                $saleMedincine = SaleMedicine::where('medicine_bill_id', $input['medicine_bill'])->where('medicine_id', $input['medicine'][$key])->first();
                if (isset($saleMedincine->sale_quantity) && $input['quantity'][$key]) {
                    if ($saleMedincine->sale_quantity < $input['quantity'][$key] && $input['payment_status'] == 1) {

                        throw new UnprocessableEntityHttpException(__('messages.medicine_bills.update_quantity'));
                    }
                }
            }

            $medicineBill->load('saleMedicine');
            $previousMedicineIds = $medicineBill->saleMedicine->pluck('medicine_id');
            $previousMedicineArray = [];
            foreach ($previousMedicineIds as $previousMedicineId) {
                $previousMedicineArray[] = $previousMedicineId;
            }

            $deleteIds = array_diff($previousMedicineArray, $input['medicine']);
            if ($input['payment_status'] && $medicineBill->payment_status == true) {
                foreach ($deleteIds as $key => $value) {
                    if (array_key_exists($key, $input['medicine'])) {
                        $updatedMedicine = Medicine::find($input['medicine'][$key]);
                        if ($updatedMedicine->available_quantity < $input['quantity'][$key]) {
                            $available = $updatedMedicine->available_quantity == null ? 0 : $updatedMedicine->available_quantity;

                            throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$updatedMedicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                        }
                    }
                }
                foreach ($deleteIds as $deleteId) {
                    $deleteMedicine = Medicine::find($deleteId);
                    $saleMedicine = SaleMedicine::where('medicine_bill_id', $medicineBill->id)->where('medicine_id', $deleteId)->first();
                    $deleteMedicine->update(['available_quantity' => $deleteMedicine->available_quantity + $saleMedicine->sale_quantity]);
                }
                foreach ($deleteIds as $key => $value) {
                    $updatedMedicine = Medicine::find($input['medicine'][$key]);
                    $updatedMedicine->update([
                        'available_quantity' => $updatedMedicine->available_quantity - $input['quantity'][$key],
                    ]);
                }
            }
            $arr = collect($input['medicine']);
            $duplicateIds = $arr->duplicates();
            $prescriptionMedicineArray = [];
            $inputdoseAndMedicine = [];
            foreach ($medicineBill->saleMedicine as $saleMedicine) {
                $prescriptionMedicineArray[$saleMedicine->medicine_id] = $saleMedicine->sale_quantity;
            }

            foreach ($input['medicine'] as $key => $value) {
                $inputdoseAndMedicine[$value] = $input['quantity'][$key];
            }
            foreach ($input['medicine'] as $key => $value) {
                $result = array_intersect($prescriptionMedicineArray, $inputdoseAndMedicine);

                $medicine = Medicine::find($input['medicine'][$key]);
                if (! empty($duplicateIds)) {
                    foreach ($duplicateIds as $key => $value) {
                        $medicine = Medicine::find($duplicateIds[$key]);

                        throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
                    }
                }
                $saleMedicine = SaleMedicine::where('medicine_bill_id', $medicineBill->id)->where('medicine_id', $medicine->id)->first();
                $qty = $input['quantity'][$key];
                if ($input['payment_status'] == true && $medicine->available_quantity < $qty && $medicineBill->payment_status == 0) {
                    $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;

                    throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                }
                if (! is_null($saleMedicine) && $input['payment_status'] == 1 && $medicineBill['payment_status'] == 1) {
                    $PreviousQty = $saleMedicine->sale_quantity == null ? 0 : $saleMedicine->sale_quantity;
                    if ($PreviousQty > $qty) {
                        $medicine->update([
                            'available_quantity' => $medicine->available_quantity + $PreviousQty - $qty,
                        ]);
                    }
                }

                if (! array_key_exists($input['medicine'][$key], $result) && $medicine->available_quantity < $qty && $input['payment_status'] == false) {
                    $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;

                    throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                }
            }
            $medicineBill->saleMedicine()->delete();

            $beforeStatus = $medicineBill['payment_status'];
            $medicineBill->Update([
                'patient_id' => $input['patient_id'],
                'net_amount' => $input['net_amount'],
                'discount' => $input['discount'],
                'payment_status' => $input['payment_status'],
                'payment_type' => $input['payment_type'],
                'total' => $input['total'],
                'tax_amount' => $input['tax'],
                'note' => $input['note'],
                'bill_date' => $input['bill_date'],
            ]);
            if ($input['category_id']) {
                foreach ($input['category_id'] as $key => $value) {
                    $medicine = Medicine::find($input['medicine'][$key]);

                    $saleMedicine = new SaleMedicine;
                    $saleMedicine->medicine_bill_id = $medicineBill->id;
                    $saleMedicine->medicine_id = $medicine->id;
                    $saleMedicine->sale_price = $input['sale_price'][$key];
                    $saleMedicine->expiry_date = $input['expiry_date'][$key];
                    $saleMedicine->sale_quantity = $input['quantity'][$key];
                    $saleMedicine->tax = $input['tax_medicine'][$key] == null ? 0 : $input['tax_medicine'][$key];
                    $saleMedicine->save();

                    if ($input['payment_status'] == 1 && $beforeStatus == 0) {
                        $medicine->update([
                            'available_quantity' => $medicine->available_quantity - $input['quantity'][$key],
                        ]);
                    }
                }
            }
            DB::commit();
        } catch (Exception $e) {
            DB::rollBack();
            throw new UnprocessableEntityHttpException($e->getMessage());
        }

        return true;
    }

    public function medicineBillStore($input)
    {
        // dd($input);
        try {
            DB::beginTransaction();

            // if (empty($input['medicine'])) {
            //     throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
            // }

            // $arr = collect($input['medicine']);
            // $duplicateIds = $arr->duplicates();

            // $input['payment_status'] = isset($input['payment_status']) ? 1 : 0;

            // foreach ($input['medicine'] as $key => $value) {
            //     $medicine = Medicine::find($input['medicine'][$key]);
            //     if (! empty($duplicateIds)) {
            //         foreach ($duplicateIds as $key => $value) {
            //             $medicine = Medicine::find($duplicateIds[$key]);
            //             throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
            //         }
            //     }
            //     $qty = $input['quantity'][$key];

            //     if ($medicine->available_quantity < $qty) {
            //         $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
            //         throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
            //     }
            // }

            $medicineBill = MedicineBill::create([
                'bill_number' => 'BIL'.generateUniqueBillNumber(),
                'patient_id' => $input['patient_id'],
                'net_amount' => $input['net_amount'],
                'discount' => $input['discount'],
                'payment_status' => $input['payment_status'],
                'payment_type' => $input['payment_type'],
                'note' => $input['note'],
                'total' => $input['total'],
                'tax_amount' => $input['tax_amount'],
                'payment_note' => $input['payment_note'],
                'model_type' => \App\Models\MedicineBill::class,
                'bill_date' => $input['bill_date'],
                'model_id' => 1,
            ]);

            $medicineBill->update([
                'model_id' => $medicineBill->id,
            ]);
            if ($input['saleMedicine']) {
                foreach ($input['saleMedicine'] as $medicineVal) {
                    $medicine = Medicine::find($medicineVal['medicine_id']);

                    $tax = $medicineVal['tax'] == null ? $medicineVal['tax'] : 0;

                    $saleMedicine = new SaleMedicine;
                    $saleMedicine->medicine_bill_id = $medicineBill->id;
                    $saleMedicine->medicine_id = $medicine->id;
                    $saleMedicine->sale_price = $medicineVal['sale_price'];
                    $saleMedicine->expiry_date = $medicineVal['expiry_date'];
                    $saleMedicine->sale_quantity = $medicineVal['sale_quantity'] ?? 0;
                    $saleMedicine->tax = $tax;
                    $saleMedicine->amount = $medicineVal['amount'];
                    $saleMedicine->save();

                    if ($input['payment_status'] == 1) {
                        $medicine->update([
                            'available_quantity' => $medicine->available_quantity - $medicineVal['sale_quantity'],
                        ]);
                    }
                }
                DB::commit();

                return $medicineBill;
            }
        } catch (\Exception $e) {
            DB::rollBack();
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    // public function medicineBillStore($input)
    // {
    //     $structuredMedicines = [
    //         'category_id' => [],
    //         'medicine' => [],
    //         'expiry_date' => [],
    //         'sale_price' => [],
    //         'sale_quantity' => [],
    //         'tax' => [],
    //         'amount' => [],
    //     ];

    //     foreach ($input['saleMedicine'] as $medicineData) {
    //         $structuredMedicines['category_id'][] = $medicineData['category_id'];
    //         $structuredMedicines['medicine'][] = $medicineData['medicine'];
    //         $structuredMedicines['expiry_date'][] = $medicineData['expiry_date'];
    //         $structuredMedicines['sale_price'][] = $medicineData['sale_price'];
    //         $structuredMedicines['sale_quantity'][] = $medicineData['sale_quantity'];
    //         $structuredMedicines['tax'][] = $medicineData['tax'];
    //         $structuredMedicines['amount'][] = $medicineData['amount'];
    //     }
    //     try {
    //         DB::beginTransaction();

    //         if (empty($structuredMedicines['medicine'])) {
    //             throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
    //         }

    //         $arr = collect($structuredMedicines['medicine']);
    //         $duplicateIds = $arr->duplicates();

    //         $input['payment_status'] = isset($input['payment_status']) ? 1 : 0;

    //         foreach ($structuredMedicines['medicine'] as $key => $value) {
    //             $medicine = Medicine::find($structuredMedicines['medicine'][$key]);
    //             if (! empty($duplicateIds)) {
    //                 foreach ($duplicateIds as $key => $value) {
    //                     $medicine = Medicine::find($duplicateIds[$key]);
    //                     throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
    //                 }
    //             }
    //             $qty = $structuredMedicines['sale_quantity'][$key];

    //             if ($medicine->available_quantity < $qty) {
    //                 $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
    //                 throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity') . ' ' . $medicine->name . ' ' . __('messages.medicine_bills.is') . ' ' . $available . '.');
    //             }
    //         }

    //         $medicineBill = MedicineBill::create([
    //             'bill_number' => 'BIL' . generateUniqueBillNumber(),
    //             'patient_id' => $input['patient_id'],
    //             'net_amount' => $input['net_amount'],
    //             'discount' => $input['discount'],
    //             'payment_status' => $input['payment_status'],
    //             'payment_type' => $input['payment_type'],
    //             'note' => $input['note'],
    //             'total' => $input['total'],
    //             'tax_amount' => $input['tax'],
    //             'payment_note' => $input['payment_note'],
    //             'model_type' => \App\Models\MedicineBill::class,
    //             'bill_date' => $input['bill_date'],
    //             'model_id' => 1,
    //         ]);
    //         if ($medicineBill) {
    //             $medicineBill->update([
    //                 'model_id' => $medicineBill->id,
    //             ]);
    //         }

    //         if ($structuredMedicines['category_id']) {
    //             foreach ($structuredMedicines['category_id'] as $key => $value) {
    //                 $medicine = Medicine::find($structuredMedicines['medicine'][$key]);
    //                 $tax = $structuredMedicines['tax'][$key] == null ? $structuredMedicines['tax'][$key] : 0;

    //                 $saleMedicine = new SaleMedicine();
    //                 $saleMedicine->medicine_bill_id = $medicineBill->id;
    //                 $saleMedicine->medicine_id = $medicine->id;
    //                 $saleMedicine->sale_price = $structuredMedicines['sale_price'][$key];
    //                 $saleMedicine->expiry_date = $structuredMedicines['expiry_date'][$key];
    //                 $saleMedicine->sale_quantity = $structuredMedicines['sale_quantity'][$key];
    //                 $saleMedicine->amount = $structuredMedicines['amount'][$key];
    //                 $saleMedicine->tax = $tax;
    //                 $saleMedicine->save();

    //                 if ($input['payment_status'] == 1) {
    //                     $medicine->update([
    //                         'available_quantity' => $medicine->available_quantity - $structuredMedicines['quantity'][$key],
    //                     ]);
    //                 }
    //             }
    //             DB::commit();

    //             return $medicineBill;
    //         }
    //     } catch (\Exception $e) {
    //         DB::rollBack();
    //         throw new UnprocessableEntityHttpException($e->getMessage());
    //     }
    // }

    public function stripeApiKey()
    {
        $tenantId = User::findOrFail(getLoggedInUserId())->tenant_id;
        $stripeKey = Setting::whereTenantId($tenantId)->where('key', '=', 'stripe_secret')->first();

        if (! empty($stripeKey->value)) {
            setStripeApiKey($tenantId);
        } else {
            throw new UnprocessableEntityHttpException(__('messages.new_change.provide_stripe_key'));
        }
    }

    public function stripeSession($input, $medicineBill)
    {
        $input['bill_number'] = $medicineBill->bill_number;

        $this->stripeApiKey();
        try {
            $session = Session::create([
                'payment_method_types' => ['card'],
                'line_items' => [
                    [
                        'price_data' => [
                            'product_data' => [
                                'name' => 'Payment for Medicine bill',
                            ],
                            'unit_amount' => in_array(strtoupper(getCurrentCurrency()), zeroDecimalCurrencies()) ? $input['net_amount'] : ($input['net_amount'] * 100),
                            'currency' => strtoupper(getCurrentCurrency()),
                        ],
                        'quantity' => 1,
                    ],
                ],
                'client_reference_id' => $input['patient_id'],
                'mode' => 'payment',
                'success_url' => route('medicine.bill.stripe.success').'?session_id={CHECKOUT_SESSION_ID}',
                'cancel_url' => route('medicine.bill.stripe.failed').'?'.http_build_query(['input' => $input]),
            ]);

            $result = [
                'sessionId' => $session['id'],
            ];
            session(['sessionUrl' => $session['url']]);

            return $result;
        } catch (\Exception $e) {
            MedicineBill::findOrFail($medicineBill->id)->delete();
            session(['paymentError' => $e->getMessage()]);

            return Notification::make()
                ->danger()
                ->title($e->getMessage())
                ->send();
        }
    }

    public function medicineBillstripeSuccess($input)
    {
        $sessionId = $input['session_id'];

        if (empty($sessionId)) {
            throw new UnprocessableEntityHttpException('session id required');
        }

        $this->stripeApiKey();

        $sessionData = Session::retrieve($sessionId);

        if ($sessionData) {
            return true;
        }

        return false;
    }

    public function medicineBillstripeFailed($input)
    {
        $input = $input['input'];

        try {
            $input['payment_status'] = isset($input['payment_status']) ? 1 : 0;

            $medicineBill = MedicineBill::where('bill_number', $input['bill_number'])->first();

            if (array_key_exists('category_id', $input)) {
                foreach ($input['category_id'] as $key => $value) {
                    $medicine = Medicine::find($input['medicine'][$key]);
                    $tax = $input['tax_medicine'][$key] == null ? $input['tax_medicine'][$key] : 0;

                    $saleMedicine = SaleMedicine::where('medicine_bill_id', $medicineBill->id)->first();
                    $saleMedicine->delete();

                    if ($input['payment_status'] == 1) {
                        $medicine->update([
                            'available_quantity' => $input['quantity'][$key] + $medicine->available_quantity,
                        ]);
                    }
                }
            }

            $medicineBill->delete();

            return true;
        } catch (\Exception $e) {
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    public function razorPayPayment($input)
    {
        $amount = intval($input['net_amount']);

        try {
            $api = new Api(getPaymentCredentials('razorpay_key'), getPaymentCredentials('razorpay_secret'));

            $orderData = [
                'receipt' => '1',
                'amount' => $amount * 100,
                'currency' => strtoupper(getCurrentCurrency()),
                'notes' => [
                    'amount' => $amount,
                ],
            ];

            $razorpayOrder = $api->order->create($orderData);

            $data['id'] = $razorpayOrder->id;
            $data['net_amount'] = $amount;

            return $data;
        } catch (\Exception $e) {
            $data['error'] = $e->getMessage();

            return $data;
        }
    }

    public function razorPayPaymentSuccess($input)
    {
        $api = new Api(getPaymentCredentials('razorpay_key'), getPaymentCredentials('razorpay_secret'));

        if (count($input) && ! empty($input['razorpay_payment_id'])) {

            $payment = $api->payment->fetch($input['razorpay_payment_id']);

            if (count($input) && ! empty($input['razorpay_payment_id'])) {

                $payment = $api->payment->fetch($input['razorpay_payment_id']);

                if ($payment->status == 'authorized') {
                    return true;
                }

                return false;
            }

            return true;
        }
    }

    public function paystackPaymentSuccess($input)
    {

        try {
            DB::beginTransaction();
            if (empty($input['saleMedicine'])) {
                throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
            }

            $arr = collect($input['saleMedicine']);
            $duplicateIds = $arr->duplicates();

            $input['payment_status'] = isset($input['payment_status']) ? 1 : 0;

            foreach ($input['saleMedicine'] as $key => $value) {
                $medicine = Medicine::find($input['saleMedicine'][$key]['medicine_id']);
                if (! empty($duplicateIds)) {
                    foreach ($duplicateIds as $key => $value) {
                        $medicine = Medicine::find($duplicateIds[$key]);
                        throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
                    }
                }
                $qty = $input['saleMedicine'][$key]['sale_quantity'];

                if ($medicine->available_quantity < $qty) {
                    $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
                    throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                }
            }

            $medicineBill = MedicineBill::create([
                'bill_number' => 'BIL'.generateUniqueBillNumber(),
                'patient_id' => $input['patient_id'],
                'net_amount' => $input['net_amount'],
                'discount' => $input['discount'],
                'payment_status' => $input['payment_status'],
                'payment_type' => $input['payment_type'],
                'note' => $input['note'] ?? null,
                'total' => $input['total'],
                'tax_amount' => $input['tax_amount'],
                'payment_note' => $input['payment_note'] ?? null,
                'model_type' => \App\Models\MedicineBill::class,
                'bill_date' => $input['bill_date'],
                'model_id' => 0,
            ]);

            $medicineBill->update([
                'model_id' => $medicineBill->id,
            ]);

            if (array_key_exists('saleMedicine', $input)) {
                foreach ($input['saleMedicine'] as $key => $value) {
                    $medicine = Medicine::find($input['saleMedicine'][$key]['medicine_id']);
                    $tax = $input['saleMedicine'][$key]['tax'] == null ? $input['saleMedicine'][$key]['tax'] : 0;
                    SaleMedicine::create([
                        'medicine_bill_id' => $medicineBill->id,
                        'medicine_id' => $medicine->id,
                        'sale_price' => $input['saleMedicine'][$key]['sale_price'],
                        'expiry_date' => $input['saleMedicine'][$key]['expiry_date'] ?? null,
                        'sale_quantity' => $input['saleMedicine'][$key]['sale_quantity'],
                        'tax' => $tax,
                        'amount' => $input['saleMedicine'][$key]['amount'],
                    ]);
                    if ($input['payment_status'] == 1) {
                        $medicine->update([
                            'available_quantity' => $medicine->available_quantity - $input['saleMedicine'][$key]['sale_quantity'],
                        ]);
                    }
                }
                DB::commit();

                return true;
            }

            return;
        } catch (Exception $e) {
            DB::rollBack();
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    public function phonePePayment($input)
    {

        foreach ($input['saleMedicine'] as $key => $value) {
            $medicine = Medicine::find($input['saleMedicine'][$key]['medicine_id']);
            if (! empty($duplicateIds)) {
                foreach ($duplicateIds as $key => $value) {
                    $medicine = Medicine::find($duplicateIds[$key]);
                    $data['error'] = __('messages.medicine_bills.duplicate_medicine');

                    return $data;
                }
            }
            $qty = $input['saleMedicine'][$key]['sale_quantity'];

            if ($medicine->available_quantity < $qty) {
                $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
                $data['error'] = __('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.';

                return $data;
            }
        }

        $amount = $input['net_amount'];

        $redirectbackurl = route('medicine.bill.phonepe.callback').'?'.http_build_query(['input' => $input]);

        $merchantId = getPaymentCredentials('phonepe_merchant_id');
        $merchantUserId = getPaymentCredentials('phonepe_merchant_id');
        $merchantTransactionId = getPaymentCredentials('phonepe_merchant_transaction_id');
        $baseUrl = getPaymentCredentials('phonepe_env') == 'production' ? 'https://api.phonepe.com/apis/hermes' : 'https://api-preprod.phonepe.com/apis/pg-sandbox';
        $saltKey = getPaymentCredentials('phonepe_salt_key');
        $saltIndex = getPaymentCredentials('phonepe_salt_index');
        $callbackurl = route('medicine.bill.phonepe.callback').'?'.http_build_query(['input' => $input]);

        config([
            'phonepe.merchantId' => $merchantId,
            'phonepe.merchantUserId' => $merchantUserId,
            'phonepe.env' => $baseUrl,
            'phonepe.saltKey' => $saltKey,
            'phonepe.saltIndex' => $saltIndex,
            'phonepe.redirectUrl' => $redirectbackurl,
            'phonepe.callBackUrl' => $callbackurl,
        ]);

        $data = [
            'merchantId' => $merchantId,
            'merchantTransactionId' => $merchantTransactionId,
            'merchantUserId' => $merchantUserId,
            'amount' => $amount * 100,
            'redirectUrl' => $redirectbackurl,
            'redirectMode' => 'POST',
            'callbackUrl' => $callbackurl,
            'paymentInstrument' => [
                'type' => 'PAY_PAGE',
            ],
        ];

        $encode = base64_encode(json_encode($data));

        $string = $encode.'/pg/v1/pay'.$saltKey;
        $sha256 = hash('sha256', $string);
        $finalXHeader = $sha256.'###'.$saltIndex;

        $curl = curl_init();

        curl_setopt_array($curl, [
            CURLOPT_URL => $baseUrl.'/pg/v1/pay',
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_ENCODING => '',
            CURLOPT_MAXREDIRS => 10,
            CURLOPT_TIMEOUT => 0,
            CURLOPT_FOLLOWLOCATION => false,
            CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
            CURLOPT_CUSTOMREQUEST => 'POST',
            CURLOPT_POSTFIELDS => json_encode(['request' => $encode]),
            CURLOPT_HTTPHEADER => [
                'Content-Type: application/json',
                'X-VERIFY: '.$finalXHeader,
            ],
        ]);

        $response = curl_exec($curl);
        $rData = json_decode($response);

        if ($rData->success == false) {
            $eData['error'] = $rData->message;

            return $eData;
        }
        curl_close($curl);

        $url = $rData->data->instrumentResponse->redirectInfo->url;
        session(['sessionUrl' => $url]);

    }

    public function phonePePaymentSuccess($input)
    {

        $input = $input['input'];

        try {
            DB::beginTransaction();

            if (empty($input['saleMedicine'])) {
                throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
            }
            foreach ($input['saleMedicine'] as $key => $value) {
                $medicine = Medicine::find($input['saleMedicine'][$key]['medicine_id']);
                if (! empty($duplicateIds)) {
                    foreach ($duplicateIds as $key => $value) {
                        $medicine = Medicine::find($duplicateIds[$key]);
                        throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
                    }
                }
                $qty = $input['saleMedicine'][$key]['sale_quantity'];

                if ($medicine->available_quantity < $qty) {
                    $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
                    throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                }
            }

            $arr = collect($input['saleMedicine']);
            $duplicateIds = $arr->duplicates();

            $input['payment_status'] = isset($input['payment_status']) ? 1 : 0;

            $medicineBill = MedicineBill::create([
                'bill_number' => 'BIL'.generateUniqueBillNumber(),
                'patient_id' => $input['patient_id'],
                'net_amount' => $input['net_amount'],
                'discount' => $input['discount'],
                'payment_status' => $input['payment_status'],
                'payment_type' => $input['payment_type'],
                'note' => $input['note'] ?? null,
                'total' => $input['total'],
                'tax_amount' => $input['tax_amount'],
                'payment_note' => $input['payment_note'] ?? null,
                'model_type' => \App\Models\MedicineBill::class,
                'bill_date' => $input['bill_date'],
                'model_id' => 0,
            ]);
            $medicineBill->update([
                'model_id' => $medicineBill->id,
            ]);

            if ($input['saleMedicine']) {
                foreach ($input['saleMedicine'] as $key => $value) {
                    $medicine = Medicine::find($input['saleMedicine'][$key]['medicine_id']);
                    $tax = $input['saleMedicine'][$key]['tax'] == null ? $input['saleMedicine'][$key]['tax'] : 0;
                    SaleMedicine::create([
                        'medicine_bill_id' => $medicineBill->id,
                        'medicine_id' => $medicine->id,
                        'sale_price' => $input['saleMedicine'][$key]['sale_price'],
                        'expiry_date' => $input['saleMedicine'][$key]['expiry_date'] ?? null,
                        'sale_quantity' => $input['saleMedicine'][$key]['sale_quantity'],
                        'amount' => $input['saleMedicine'][$key]['amount'],
                        'tax' => $tax,

                    ]);
                    if ($input['payment_status'] == 1) {
                        $medicine->update([
                            'available_quantity' => $medicine->available_quantity - $input['saleMedicine'][$key]['sale_quantity'],
                        ]);
                    }
                }
                DB::commit();

                return true;
            }

            return;
        } catch (Exception $e) {
            DB::rollBack();
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    public function flutterWavePayment($input)
    {

        $reference = time();

        $data = [
            'payment_options' => 'card,banktransfer',
            'amount' => $input['net_amount'],
            'email' => getLoggedInUser()->email,
            'tx_ref' => $reference,
            'currency' => getCurrentCurrency(),
            'redirect_url' => route('medicine.bill.flutterwave.success'),
            'customer' => [
                'email' => getLoggedInUser()->email,
            ],
            'customizations' => [
                'title' => 'Medicine Bill Payment',
                'description' => isset($input['payment_note']) ?? '',
            ],
        ];

        $client = new Client;
        $url = 'https://api.flutterwave.com/v3/payments';
        $clientId = SuperAdminSetting::where('key', 'flutterwave_secret')->first()->value;

        $response = $client->post($url, [
            'headers' => [
                'Authorization' => 'Bearer '.$clientId,
                'Content-Type' => 'application/json',
            ],
            'json' => $data,
        ]);

        $body = json_decode($response->getBody(), true);
        if ($body['status'] == 'success') {
            session()->put('medicineBillDataFlutterWave', $input);
            session()->put('sessionUrl', $body['data']['link']);
        }

    }

    public function flutterWaveSuccess($input)
    {
        try {
            DB::beginTransaction();

            if ($input['status'] == 'successful') {

                $transactionID = $input['transaction_id'];
                $flutterWaveData = $this->verifyPayment($transactionID);

                $sessionData = session()->get('medicineBillDataFlutterWave');
                if (isset($sessionData) && ! empty($sessionData)) {

                    if (empty($sessionData['saleMedicine'])) {
                        throw new UnprocessableEntityHttpException(__('messages.medicine_bills.medicine_not_selected'));
                    }
                    foreach ($sessionData['saleMedicine'] as $key => $value) {
                        $medicine = Medicine::find($sessionData['saleMedicine'][$key]['medicine_id']);
                        if (! empty($duplicateIds)) {
                            foreach ($duplicateIds as $key => $value) {
                                $medicine = Medicine::find($duplicateIds[$key]);
                                throw new UnprocessableEntityHttpException(__('messages.medicine_bills.duplicate_medicine'));
                            }
                        }
                        $qty = $sessionData['saleMedicine'][$key]['sale_quantity'];

                        if ($medicine->available_quantity < $qty) {
                            $available = $medicine->available_quantity == null ? 0 : $medicine->available_quantity;
                            throw new UnprocessableEntityHttpException(__('messages.medicine_bills.available_quantity').' '.$medicine->name.' '.__('messages.medicine_bills.is').' '.$available.'.');
                        }
                    }
                    $arr = collect($sessionData['saleMedicine']);
                    $duplicateIds = $arr->duplicates();

                    $sessionData['payment_status'] = isset($sessionData['payment_status']) ? 1 : 0;

                    $medicineBill = MedicineBill::create([
                        'bill_number' => 'BIL'.generateUniqueBillNumber(),
                        'patient_id' => $sessionData['patient_id'],
                        'net_amount' => $sessionData['net_amount'],
                        'discount' => $sessionData['discount'],
                        'payment_status' => $sessionData['payment_status'],
                        'payment_type' => $sessionData['payment_type'],
                        'note' => $sessionData['note'] ?? null,
                        'total' => $sessionData['total'],
                        'tax_amount' => $sessionData['tax_amount'],
                        'payment_note' => $sessionData['payment_note'] ?? null,
                        'model_type' => \App\Models\MedicineBill::class,
                        'bill_date' => $sessionData['bill_date'],
                        'model_id' => 0,
                    ]);
                    $medicineBill->update([
                        'model_id' => $medicineBill->id,
                    ]);

                    if (array_key_exists('saleMedicine', $sessionData)) {
                        foreach ($sessionData['saleMedicine'] as $key => $value) {
                            $medicine = Medicine::find($sessionData['saleMedicine'][$key]['medicine_id']);
                            $tax = $sessionData['saleMedicine'][$key]['tax'] == null ? $sessionData['saleMedicine'][$key]['tax'] : 0;
                            SaleMedicine::create([
                                'medicine_bill_id' => $medicineBill->id,
                                'medicine_id' => $medicine->id,
                                'sale_price' => $sessionData['saleMedicine'][$key]['sale_price'],
                                'expiry_date' => $sessionData['saleMedicine'][$key]['expiry_date'] ?? null,
                                'sale_quantity' => $sessionData['saleMedicine'][$key]['sale_quantity'],
                                'tax' => $tax,
                                'amount' => $sessionData['saleMedicine'][$key]['amount'],
                            ]);
                            if ($sessionData['payment_status'] == 1) {
                                $medicine->update([
                                    'available_quantity' => $medicine->available_quantity - $sessionData['saleMedicine'][$key]['sale_quantity'],
                                ]);
                            }
                        }
                        DB::commit();
                        session()->forget('medicineBillDataFlutterWave');

                        return true;
                    }
                }

                return false;
            }
        } catch (Exception $e) {
            DB::rollBack();
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    private function verifyPayment($transactionID)
    {
        $client = new Client;
        $url = "https://api.flutterwave.com/v3/transactions/{$transactionID}/verify";
        $clientId = SuperAdminSetting::where('key', 'flutterwave_secret')->first()->value;

        $response = $client->get($url, [
            'headers' => [
                'Authorization' => 'Bearer '.$clientId,
                'Content-Type' => 'application/json',
            ],
        ]);

        return json_decode($response->getBody(), true);
    }
}