Viewing file:  PaymentSalesController.php (21.29 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers;
use App\Exports\Payment_Sale_Export;
use App\Mail\Payment_Sale;
use App\Models\Client;
use App\Models\PaymentSale;
use App\Models\Role;
use App\Models\Sale;
use App\Models\Setting;
use App\utils\helpers;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Mail;
use Maatwebsite\Excel\Facades\Excel;
use App\Models\PaymentWithCreditCard;
use Twilio\Rest\Client as Client_Twilio;
use Stripe;
use DB;
use PDF;
class PaymentSalesController extends BaseController
{
//------------- Get All Payments Sales --------------\\
public function index(request $request)
{
$this->authorizeForUser($request->user('api'), 'Reports_payments_Sales', PaymentSale::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 => 'sale_id', 2 => 'Reglement');
$data = array();
// Check If User Has Permission View All Records
$Payments = PaymentSale::with('sale.client')
->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('client_id'), function ($query) use ($request) {
return $query->whereHas('sale.client', function ($q) use ($request) {
$q->where('id', '=', $request->client_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('sale', function ($q) use ($request) {
$q->where('Ref', 'LIKE', "%{$request->search}%");
});
})
->orWhere(function ($query) use ($request) {
return $query->whereHas('sale.client', 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_Sale'] = $Payment['sale']->Ref;
$item['client_name'] = $Payment['sale']['client']->name;
$item['Reglement'] = $Payment->Reglement;
$item['montant'] = number_format($Payment->montant, 2, '.', '');
$data[] = $item;
}
$clients = Client::where('deleted_at', '=', null)->get(['id', 'name']);
$sales = Sale::get(['Ref', 'id']);
return response()->json([
'totalRows' => $totalRows,
'payments' => $data,
'sales' => $sales,
'clients' => $clients,
]);
}
//----------- Store new Payment Sale --------------\\
public function store(Request $request)
{
$this->authorizeForUser($request->user('api'), 'create', PaymentSale::class);
\DB::transaction(function () use ($request) {
$helpers = new helpers();
$role = Auth::user()->roles()->first();
$view_records = Role::findOrFail($role->id)->inRole('record_view');
$sale = Sale::findOrFail($request['sale_id']);
// Check If User Has Permission view All Records
if (!$view_records) {
// Check If User->id === sale->id
$this->authorizeForUser($request->user('api'), 'check_record', $sale);
}
try {
$total_paid = $sale->paid_amount + $request['montant'];
$due = $sale->GrandTotal - $total_paid;
if ($due === 0.0 || $due < 0.0) {
$payment_statut = 'paid';
} else if ($due !== $sale->GrandTotal) {
$payment_statut = 'partial';
} else if ($due === $sale->GrandTotal) {
$payment_statut = 'unpaid';
}
if($request['montant'] > 0){
// Paying Method credit card
if ($request['Reglement'] == 'credit card') {
Stripe\Stripe::setApiKey(config('app.STRIPE_SECRET'));
$PaymentWithCreditCard = PaymentWithCreditCard::where('customer_id', $request->client_id)->first();
if (!$PaymentWithCreditCard) {
// Create a Customer
$customer = \Stripe\Customer::create([
'source' => $request->token,
'email' => $request->client_email,
]);
// Charge the Customer instead of the card:
$charge = \Stripe\Charge::create([
'amount' => $request['montant'] * 100,
'currency' => 'usd',
'customer' => $customer->id,
]);
$PaymentCard['customer_stripe_id'] = $customer->id;
} else {
$customer_id = $PaymentWithCreditCard->customer_stripe_id;
$charge = \Stripe\Charge::create([
'amount' => $request['montant'] * 100,
'currency' => 'usd',
'customer' => $customer_id,
]);
$PaymentCard['customer_stripe_id'] = $customer_id;
}
$PaymentSale = new PaymentSale();
$PaymentSale->sale_id = $request['sale_id'];
$PaymentSale->Ref = $this->getNumberOrder();
$PaymentSale->date = $request['date'];
$PaymentSale->Reglement = $request['Reglement'];
$PaymentSale->montant = $request['montant'];
$PaymentSale->change = $request['change'];
$PaymentSale->notes = $request['notes'];
$PaymentSale->user_id = Auth::user()->id;
$PaymentSale->save();
$sale->update([
'paid_amount' => $total_paid,
'payment_statut' => $payment_statut,
]);
$PaymentCard['customer_id'] = $request->client_id;
$PaymentCard['payment_id'] = $PaymentSale->id;
$PaymentCard['charge_id'] = $charge->id;
PaymentWithCreditCard::create($PaymentCard);
// Paying Method Cach
} else {
PaymentSale::create([
'sale_id' => $request['sale_id'],
'Ref' => $this->getNumberOrder(),
'date' => $request['date'],
'Reglement' => $request['Reglement'],
'montant' => $request['montant'],
'change' => $request['change'],
'notes' => $request['notes'],
'user_id' => Auth::user()->id,
]);
$sale->update([
'paid_amount' => $total_paid,
'payment_statut' => $payment_statut,
]);
}
}
} catch (Exception $e) {
return response()->json(['message' => $e->getMessage()], 500);
}
}, 10);
return response()->json(['success' => true, 'message' => 'Payment Create successfully'], 200);
}
//------------ function show -----------\\
public function show($id){
//
}
//----------- Update Payments Sale --------------\\
public function update(Request $request, $id)
{
$this->authorizeForUser($request->user('api'), 'update', PaymentSale::class);
\DB::transaction(function () use ($id, $request) {
$helpers = new helpers();
$role = Auth::user()->roles()->first();
$view_records = Role::findOrFail($role->id)->inRole('record_view');
$payment = PaymentSale::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);
}
$sale = Sale::find($payment->sale_id);
$old_total_paid = $sale->paid_amount - $payment->montant;
$new_total_paid = $old_total_paid + $request['montant'];
$due = $sale->GrandTotal - $new_total_paid;
if ($due === 0.0 || $due < 0.0) {
$payment_statut = 'paid';
} else if ($due !== $sale->GrandTotal) {
$payment_statut = 'partial';
} else if ($due === $sale->GrandTotal) {
$payment_statut = 'unpaid';
}
try {
if ($request['Reglement'] == 'credit card') {
Stripe\Stripe::setApiKey(config('app.STRIPE_SECRET'));
if ($payment->Reglement == 'credit card') {
$PaymentWithCreditCard = PaymentWithCreditCard::where('payment_id', $payment->id)->first();
// Create Refund
\Stripe\Refund::create([
'charge' => $PaymentWithCreditCard->charge_id,
]);
$customer_id = $PaymentWithCreditCard->customer_stripe_id;
// Charge the Customer instead of the card:
$charge = \Stripe\Charge::create([
'amount' => $request['montant'] * 100,
'currency' => 'usd',
'customer' => $customer_id,
]);
$payment->update([
'date' => $request['date'],
'Reglement' => $request['Reglement'],
'montant' => $request['montant'],
'change' => $request['change'],
'notes' => $request['notes'],
]);
$sale->update([
'paid_amount' => $new_total_paid,
'payment_statut' => $payment_statut,
]);
$PaymentWithCreditCard->charge_id = $charge->id;
$PaymentWithCreditCard->save();
} else {
$PaymentWithCreditCard = PaymentWithCreditCard::where('customer_id', $request->client_id)->first();
if (!$PaymentWithCreditCard) {
// Create a Customer
$customer = \Stripe\Customer::create([
'source' => $request->token,
'email' => $request->client_email,
]);
// Charge the Customer instead of the card:
$charge = \Stripe\Charge::create([
'amount' => $request['montant'] * 100,
'currency' => 'usd',
'customer' => $customer->id,
]);
$PaymentCard['customer_stripe_id'] = $customer->id;
} else {
$customer_id = $PaymentWithCreditCard->customer_stripe_id;
$charge = \Stripe\Charge::create([
'amount' => $request['montant'] * 100,
'currency' => 'usd',
'customer' => $customer_id,
]);
$PaymentCard['customer_stripe_id'] = $customer_id;
}
$payment->update([
'date' => $request['date'],
'Reglement' => $request['Reglement'],
'montant' => $request['montant'],
'change' => $request['change'],
'notes' => $request['notes'],
]);
$sale->update([
'paid_amount' => $new_total_paid,
'payment_statut' => $payment_statut,
]);
$PaymentCard['customer_id'] = $request->client_id;
$PaymentCard['payment_id'] = $payment->id;
$PaymentCard['charge_id'] = $charge->id;
PaymentWithCreditCard::create($PaymentCard);
}
// Paying Method Cach
} else {
$payment->update([
'date' => $request['date'],
'Reglement' => $request['Reglement'],
'montant' => $request['montant'],
'change' => $request['change'],
'notes' => $request['notes'],
]);
$sale->update([
'paid_amount' => $new_total_paid,
'payment_statut' => $payment_statut,
]);
}
} catch (Exception $e) {
return response()->json(['message' => $e->getMessage()], 500);
}
}, 10);
return response()->json(['success' => true, 'message' => 'Payment Update successfully'], 200);
}
//----------- Delete Payment Sales --------------\\
public function destroy(Request $request, $id)
{
$this->authorizeForUser($request->user('api'), 'delete', PaymentSale::class);
\DB::transaction(function () use ($id, $request) {
$role = Auth::user()->roles()->first();
$view_records = Role::findOrFail($role->id)->inRole('record_view');
$payment = PaymentSale::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);
}
$sale = Sale::find($payment->sale_id);
$total_paid = $sale->paid_amount - $payment->montant;
$due = $sale->GrandTotal - $total_paid;
if ($due === 0.0 || $due < 0.0) {
$payment_statut = 'paid';
} else if ($due !== $sale->GrandTotal) {
$payment_statut = 'partial';
} else if ($due === $sale->GrandTotal) {
$payment_statut = 'unpaid';
}
if ($payment->Reglement == 'credit card') {
$PaymentWithCreditCard = PaymentWithCreditCard::where('payment_id', $id)->first();
if($PaymentWithCreditCard){
Stripe\Stripe::setApiKey(config('app.STRIPE_SECRET'));
// Create Refund
\Stripe\Refund::create([
'charge' => $PaymentWithCreditCard->charge_id,
]);
$PaymentWithCreditCard->delete();
}
}
PaymentSale::whereId($id)->update([
'deleted_at' => Carbon::now(),
]);
$sale->update([
'paid_amount' => $total_paid,
'payment_statut' => $payment_statut,
]);
}, 10);
return response()->json(['success' => true, 'message' => 'Payment Delete successfully'], 200);
}
//----------- Reference order Payment Sales --------------\\
public function getNumberOrder()
{
$last = DB::table('payment_sales')->latest('id')->first();
if ($last) {
$item = $last->Ref;
$nwMsg = explode("_", $item);
$inMsg = $nwMsg[1] + 1;
$code = $nwMsg[0] . '_' . $inMsg;
} else {
$code = 'INV/SL_1111';
}
return $code;
}
//----------- Payment Sale PDF --------------\\
public function payment_sale(Request $request, $id)
{
$payment = PaymentSale::with('sale', 'sale.client')->findOrFail($id);
$payment_data['sale_Ref'] = $payment['sale']->Ref;
$payment_data['client_name'] = $payment['sale']['client']->name;
$payment_data['client_phone'] = $payment['sale']['client']->phone;
$payment_data['client_adr'] = $payment['sale']['client']->adresse;
$payment_data['client_email'] = $payment['sale']['client']->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_sale', [
'symbol' => $symbol,
'setting' => $settings,
'payment' => $payment_data,
]);
return $pdf->download('Payment_Sale.pdf');
}
//------------- Send Payment Sale on Email -----------\\
public function SendEmail(Request $request)
{
$this->authorizeForUser($request->user('api'), 'view', PaymentSale::class);
$payment = $request->all();
$pdf = $this->payment_sale($request, $payment['id']);
$this->Set_config_mail(); // Set_config_mail => BaseController
$mail = Mail::to($request->to)->send(new Payment_Sale($payment, $pdf));
return $mail;
}
//----------- Export To Excel Payment Sales --------------\\
public function exportExcel(Request $request)
{
$this->authorizeForUser($request->user('api'), 'view', PaymentSale::class);
return Excel::download(new Payment_Sale_Export, 'Payment_Sale.xlsx');
}
//-------------------Sms Notifications -----------------\\
public function Send_SMS(Request $request)
{
$payment = PaymentSale::with('sale', 'sale.client')->findOrFail($request->id);
$url = url('/api/payment_Sale_PDF/' . $request->id);
$receiverNumber = $payment['sale']['client']->phone;
$message = "Dear" .' '.$payment['sale']['client']->name." \n We are contacting you in regard to a Payment #".$payment['sale']->Ref.' '.$url.' '. "that has been created on your account. \n We look forward to conducting future business with you.";
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);
}
}
}
|