byp4a55 professor6T9

Linux world-400.fr.planethoster.net 4.18.0-425.13.1.lve.el7h.x86_64 #1 SMP Mon Feb 27 14:44:55 UTC 2023 x86_64
Apache
10.195.0.10

File Name : PaymentPurchaseReturnsController.php

<?php
namespace App\Http\Controllers;

use App\Mail\PaymentReturn;
use App\Models\PaymentPurchaseReturns;
use App\Models\Provider;
use App\Models\PurchaseReturn;
use App\Models\Role;
use App\Models\Setting;
use \Nwidart\Modules\Facades\Module;
use App\Models\sms_gateway;
use App\utils\helpers;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Mail;
use Twilio\Rest\Client as Client_Twilio;
use DB;
use PDF;

class PaymentPurchaseReturnsController extends BaseController
{

//------------- Get All Payment Purchase Returns --------------\\

public function index(request $request)
    {
        $this->authorizeForUser($request->user('api'), 'Reports_payments_purchase_Return', PaymentPurchaseReturns::class);

// How many items do you want to display.
        $perPage = $request->limit;
        $pageStart = \Request::get('page', 1);
        // Start displaying items from this number;
        $offSet = ($pageStart * $perPage) - $perPage;
        $order = $request->SortField;
        $dir = $request->SortType;
        $helpers = new helpers();
        $role = Auth::user()->roles()->first();
        $view_records = Role::findOrFail($role->id)->inRole('record_view');
        // Filter fields With Params to retriever
        $param = array(0 => 'like', 1 => '=', 2 => 'like');
        $columns = array(0 => 'Ref', 1 => 'purchase_return_id', 2 => 'Reglement');
        $data = array();

// Check If User Has Permission View  All Records
        $Payments = PaymentPurchaseReturns::with('PurchaseReturn', 'PurchaseReturn.provider')
            ->where('deleted_at', '=', null)
            ->whereBetween('date', array($request->from, $request->to))
            ->where(function ($query) use ($view_records) {
                if (!$view_records) {
                    return $query->where('user_id', '=', Auth::user()->id);
                }
            })

// Multiple Filter
            ->where(function ($query) use ($request) {
                return $query->when($request->filled('provider_id'), function ($query) use ($request) {
                    return $query->whereHas('PurchaseReturn.provider', function ($q) use ($request) {
                        $q->where('id', '=', $request->provider_id);
                    });
                });
            });
        $Filtred = $helpers->filter($Payments, $columns, $param, $request)

// Search With Multiple Param
            ->where(function ($query) use ($request) {
                return $query->when($request->filled('search'), function ($query) use ($request) {
                    return $query->where('Ref', 'LIKE', "%{$request->search}%")
                        ->orWhere('date', 'LIKE', "%{$request->search}%")
                        ->orWhere('Reglement', 'LIKE', "%{$request->search}%")
                        ->orWhere(function ($query) use ($request) {
                            return $query->whereHas('PurchaseReturn', function ($q) use ($request) {
                                $q->where('Ref', 'LIKE', "%{$request->search}%");
                            });
                        })
                        ->orWhere(function ($query) use ($request) {
                            return $query->whereHas('PurchaseReturn.provider', function ($q) use ($request) {
                                $q->where('name', 'LIKE', "%{$request->search}%");
                            });
                        });
                });
            });

$totalRows = $Filtred->count();
        if($perPage == "-1"){
            $perPage = $totalRows;
        }
        $Payments = $Filtred->offset($offSet)
            ->limit($perPage)
            ->orderBy($order, $dir)
            ->get();

foreach ($Payments as $Payment) {

$item['date'] = $Payment->date;
            $item['Ref'] = $Payment->Ref;
            $item['Ref_return'] = $Payment['PurchaseReturn']->Ref;
            $item['provider_name'] = $Payment['PurchaseReturn']['provider']->name;
            $item['Reglement'] = $Payment->Reglement;
            $item['montant'] = $Payment->montant;
            // $item['montant'] = number_format($Payment->montant, 2, '.', '');
            $data[] = $item;
        }

$suppliers = Provider::where('deleted_at', '=', null)->get(['id', 'name']);
        $purchase_returns = PurchaseReturn::get(['Ref', 'id']);

return response()->json([
            'totalRows' => $totalRows,
            'payments' => $data,
            'purchase_returns' => $purchase_returns,
            'suppliers' => $suppliers,
        ]);
    }

//----------- Store New Payment Purchase Return --------------\\

public function store(Request $request)
    {
        $this->authorizeForUser($request->user('api'), 'create', PaymentPurchaseReturns::class);

if($request['montant'] > 0){
            \DB::transaction(function () use ($request) {
                $role = Auth::user()->roles()->first();
                $view_records = Role::findOrFail($role->id)->inRole('record_view');
                $PurchaseReturn = PurchaseReturn::findOrFail($request['purchase_return_id']);
        
                // Check If User Has Permission view All Records
                if (!$view_records) {
                    // Check If User->id === purchase return->id
                    $this->authorizeForUser($request->user('api'), 'check_record', $PurchaseReturn);
                }

$total_paid = $PurchaseReturn->paid_amount + $request['montant'];
                $due = $PurchaseReturn->GrandTotal - $total_paid;

PaymentPurchaseReturns::create([
                    'purchase_return_id' => $request['purchase_return_id'],
                    'Ref' => $this->getNumberOrder(),
                    'date' => $request['date'],
                    'Reglement' => $request['Reglement'],
                    'montant' => $request['montant'],
                    'change' => $request['change'],
                    'notes' => $request['notes'],
                    'user_id' => Auth::user()->id,
                ]);

$PurchaseReturn->update([
                    'paid_amount' => $total_paid,
                    'payment_statut' => $payment_statut,
                ]);

}, 10);
        }

return response()->json(['success' => true, 'message' => 'Payment Create successfully'], 200);
    }

//------------ function show -----------\\

public function show($id){
        //
        
    }

//----------- Update Payment Purchase Return --------------\\

public function update(Request $request, $id)
    {
        $this->authorizeForUser($request->user('api'), 'update', PaymentPurchaseReturns::class);

\DB::transaction(function () use ($id, $request) {
            $role = Auth::user()->roles()->first();
            $view_records = Role::findOrFail($role->id)->inRole('record_view');
            $payment = PaymentPurchaseReturns::findOrFail($id);
    
            // Check If User Has Permission view All Records
            if (!$view_records) {
                // Check If User->id === payment->id
                $this->authorizeForUser($request->user('api'), 'check_record', $payment);
            }

$PurchaseReturn = PurchaseReturn::find($payment->purchase_return_id);
            $old_total_paid = $PurchaseReturn->paid_amount - $payment->montant;
            $new_total_paid = $old_total_paid + $request['montant'];
            $due = $PurchaseReturn->GrandTotal - $new_total_paid;

if ($due === 0.0 || $due < 0.0) {
                $payment_statut = 'paid';
            } else if ($due !== $PurchaseReturn->GrandTotal) {
                $payment_statut = 'partial';
            } else if ($due === $PurchaseReturn->GrandTotal) {
                $payment_statut = 'unpaid';
            }
            
            $payment->update([
                'date' => $request['date'],
                'Reglement' => $request['Reglement'],
                'montant' => $request['montant'],
                'change' => $request['change'],
                'notes' => $request['notes'],
            ]);

$PurchaseReturn->update([
                'paid_amount' => $new_total_paid,
                'payment_statut' => $payment_statut,
            ]);

}, 10);

return response()->json(['success' => true, 'message' => 'Payment Update successfully'], 200);
    }

//----------- Remove Payment Purchase Return --------------\\

public function destroy(Request $request, $id)
    {
        $this->authorizeForUser($request->user('api'), 'delete', PaymentPurchaseReturns::class);

$PurchaseReturn = PurchaseReturn::find($payment->purchase_return_id);
            $total_paid = $PurchaseReturn->paid_amount - $payment->montant;
            $due = $PurchaseReturn->GrandTotal - $total_paid;

PaymentPurchaseReturns::whereId($id)->update([
                'deleted_at' => Carbon::now(),
            ]);

$PurchaseReturn->update([
                'paid_amount' => $total_paid,
                'payment_statut' => $payment_statut,
            ]);

}, 10);

return response()->json(['success' => true, 'message' => 'Payment Delete successfully'], 200);
    }

//------------- Send Payment Purchase Return To Email -----------\\

public function SendEmail(Request $request)
    {

$this->authorizeForUser($request->user('api'), 'view', PaymentPurchaseReturns::class);

$payment['id'] = $request->id;
        $payment['Ref'] = $request->Ref;
        $settings = Setting::where('deleted_at', '=', null)->first();
        $payment['company_name'] = $settings->CompanyName;
        
        $pdf = $this->payment_return($request, $payment['id']);
        $this->Set_config_mail(); // Set_config_mail => BaseController
        $mail = Mail::to($request->to)->send(new PaymentReturn($payment, $pdf));
        return $mail;
    }

//----------- Number Order Payment Purchase Return --------------\\

public function getNumberOrder()
    {
        $last = DB::table('payment_purchase_returns')->latest('id')->first();

if ($last) {
            $item = $last->Ref;
            $nwMsg = explode("_", $item);
            $inMsg = $nwMsg[1] + 1;
            $code = $nwMsg[0] . '_' . $inMsg;

} else {
            $code = 'INV/RT_1111';
        }
        return $code;
    }

//----------- Payment Purchase Return PDF --------------\\

public function payment_return(Request $request, $id)
    {
        $payment = PaymentPurchaseReturns::with('PurchaseReturn', 'PurchaseReturn.provider')->findOrFail($id);

$payment_data['return_Ref'] = $payment['PurchaseReturn']->Ref;
        $payment_data['supplier_name'] = $payment['PurchaseReturn']['provider']->name;
        $payment_data['supplier_phone'] = $payment['PurchaseReturn']['provider']->phone;
        $payment_data['supplier_adr'] = $payment['PurchaseReturn']['provider']->adresse;
        $payment_data['supplier_email'] = $payment['PurchaseReturn']['provider']->email;
        $payment_data['montant'] = $payment->montant;
        $payment_data['Ref'] = $payment->Ref;
        $payment_data['date'] = $payment->date;
        $payment_data['Reglement'] = $payment->Reglement;

$helpers = new helpers();
        $settings = Setting::where('deleted_at', '=', null)->first();
        $symbol = $helpers->Get_Currency_Code();

$pdf = \PDF::loadView('pdf.Payment_Purchase_Return', [
            'symbol' => $symbol,
            'setting' => $settings,
            'payment' => $payment_data,
        ]);

return $pdf->download('Payment_Purchase_Return.pdf');
    }

//-------------------Sms Notifications -----------------\\
     public function Send_SMS(Request $request)
     {
         $payment = PaymentPurchaseReturns::with('PurchaseReturn', 'PurchaseReturn.provider')->findOrFail($request->id);
         $settings = Setting::where('deleted_at', '=', null)->first();
         $gateway = sms_gateway::where('id' , $settings->sms_gateway)
         ->where('deleted_at', '=', null)->first();

$url = url('/api/payment_return_purchase_pdf/' . $request->id);
         $receiverNumber = $payment['PurchaseReturn']['provider']->phone;
         $message = "Dear" .' '.$payment['PurchaseReturn']['provider']->name." \n We are contacting you in regard to a Payment #".$payment['PurchaseReturn']->Ref.' '.$url.' '. "that has been created on your account. \n We look forward to conducting future business with you.";
         
         //twilio
        if($gateway->title == "twilio"){
            try {
    
                $account_sid = env("TWILIO_SID");
                $auth_token = env("TWILIO_TOKEN");
                $twilio_number = env("TWILIO_FROM");
    
                $client = new Client_Twilio($account_sid, $auth_token);
                $client->messages->create($receiverNumber, [
                    'from' => $twilio_number, 
                    'body' => $message]);
        
            } catch (Exception $e) {
                return response()->json(['message' => $e->getMessage()], 500);
            }

//nexmo
        }elseif($gateway->title == "nexmo"){
            try {

$basic  = new \Nexmo\Client\Credentials\Basic(env("NEXMO_KEY"), env("NEXMO_SECRET"));
                $client = new \Nexmo\Client($basic);
                $nexmo_from = env("NEXMO_FROM");
        
                $message = $client->message()->send([
                    'to' => $receiverNumber,
                    'from' => $nexmo_from,
                    'text' => $message
                ]);
                        
            } catch (Exception $e) {
                return response()->json(['message' => $e->getMessage()], 500);
            }
        }
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	pluszzsu/pluszzsu	0755	2023-01-11 05:52:22
..	dir	-	pluszzsu/pluszzsu	0755	2022-03-27 01:46:46
Auth	dir	-	pluszzsu/pluszzsu	0755	2022-01-08 03:50:14
hrm	dir	-	pluszzsu/pluszzsu	0755	2022-04-04 07:05:30
AdjustmentController.php	text/x-php	30.81 KB	pluszzsu/pluszzsu	0644	2022-06-02 05:41:04
AuthController.php	text/x-php	1.7 KB	pluszzsu/pluszzsu	0644	2022-06-14 05:13:06
BackupController.php	text/x-php	2.36 KB	pluszzsu/pluszzsu	0644	2022-06-16 04:46:02
BaseController.php	text/x-php	4 KB	pluszzsu/pluszzsu	0644	2022-06-24 05:50:40
BrandsController.php	text/x-php	5.67 KB	pluszzsu/pluszzsu	0644	2022-01-08 03:43:10
CategorieController.php	text/x-php	3.54 KB	pluszzsu/pluszzsu	0644	2022-01-08 03:43:20
CategoryExpenseController.php	text/x-php	5.32 KB	pluszzsu/pluszzsu	0644	2022-01-08 03:43:28
ClientController.php	text/x-php	13.26 KB	pluszzsu/pluszzsu	0644	2023-01-11 05:49:04
Controller.php	text/x-php	374 B	pluszzsu/pluszzsu	0644	2020-10-12 12:23:42
CurrencyController.php	text/x-php	3.94 KB	pluszzsu/pluszzsu	0644	2022-01-08 03:43:46
DashboardController.php	text/x-php	25.13 KB	pluszzsu/pluszzsu	0644	2023-01-10 09:13:30
ExpensesController.php	text/x-php	12.02 KB	pluszzsu/pluszzsu	0644	2022-06-02 05:41:34
HomeController.php	text/x-php	495 B	pluszzsu/pluszzsu	0644	2021-04-21 04:54:46
MailSettingsController.php	text/x-php	1.42 KB	pluszzsu/pluszzsu	0644	2022-06-24 05:50:16
PasswordResetController.php	text/x-php	3.8 KB	pluszzsu/pluszzsu	0644	2021-04-21 04:54:46
PaymentPurchaseReturnsController.php	text/x-php	15.14 KB	pluszzsu/pluszzsu	0644	2022-07-31 03:29:00
PaymentPurchasesController.php	text/x-php	14.67 KB	pluszzsu/pluszzsu	0644	2022-07-31 03:27:00
PaymentSaleReturnsController.php	text/x-php	14.82 KB	pluszzsu/pluszzsu	0644	2022-07-31 03:28:26
PaymentSalesController.php	text/x-php	22.18 KB	pluszzsu/pluszzsu	0644	2022-07-31 03:28:40
Payment_gateway_SettingsController.php	text/x-php	2.81 KB	pluszzsu/pluszzsu	0644	2022-06-16 04:36:08
PermissionsController.php	text/x-php	6.34 KB	pluszzsu/pluszzsu	0644	2022-06-17 02:37:02
PosController.php	text/x-php	16.55 KB	pluszzsu/pluszzsu	0644	2022-06-30 06:56:02
ProductsController.php	text/x-php	47.77 KB	pluszzsu/pluszzsu	0644	2022-06-18 05:56:26
ProvidersController.php	text/x-php	13.19 KB	pluszzsu/pluszzsu	0644	2023-01-11 05:49:12
PurchasesController.php	text/x-php	56.96 KB	pluszzsu/pluszzsu	0644	2023-01-05 12:43:00
PurchasesReturnController.php	text/x-php	54.19 KB	pluszzsu/pluszzsu	0644	2023-01-05 12:45:06
QuotationsController.php	text/x-php	32.08 KB	pluszzsu/pluszzsu	0644	2023-01-05 12:44:36
ReportController.php	text/x-php	171.08 KB	pluszzsu/pluszzsu	0644	2023-01-25 10:23:36
SalesController.php	text/x-php	73.06 KB	pluszzsu/pluszzsu	0644	2023-01-21 12:07:48
SalesReturnController.php	text/x-php	50.86 KB	pluszzsu/pluszzsu	0644	2023-01-05 12:45:38
SettingsController.php	text/x-php	10.37 KB	pluszzsu/pluszzsu	0644	2023-01-21 12:35:00
SetupController.php	text/x-php	8.56 KB	pluszzsu/pluszzsu	0644	2021-07-16 03:42:26
ShipmentController.php	text/x-php	7.11 KB	pluszzsu/pluszzsu	0644	2022-06-02 05:45:04
Sms_SettingsController.php	text/x-php	3.8 KB	pluszzsu/pluszzsu	0644	2022-06-27 08:16:36
TestDbController.php	text/x-php	3.08 KB	pluszzsu/pluszzsu	0644	2022-02-21 01:30:34
TransferController.php	text/x-php	52.94 KB	pluszzsu/pluszzsu	0644	2022-08-04 06:51:32
UnitsController.php	text/x-php	6.02 KB	pluszzsu/pluszzsu	0644	2022-01-08 03:47:46
UpdateController.php	text/x-php	4.09 KB	pluszzsu/pluszzsu	0644	2023-01-10 09:34:26
UserController.php	text/x-php	12.57 KB	pluszzsu/pluszzsu	0644	2022-06-27 07:51:52
WarehouseController.php	text/x-php	6.28 KB	pluszzsu/pluszzsu	0644	2022-06-02 05:45:32

Team Anon Force

https://t.me/Professor6T9x