MAINHACK

Viewing / Editing File: CustomerController.php

<?php

namespace App\Http\Controllers;

use App\Mail\SendCustomerMail;
use App\Models\Customer;
use App\Models\Invoice;
use App\Models\InvoicePay;
use App\Models\Method;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Mail;

class CustomerController extends Controller
{

public function index(Request $request)
    {
        $data['collection'] = Customer::select('id', 'name', 'address', 'phone', 'due')
            ->latest('id')
            ->paginate($request->input('limit', 5));
        return view('customer.index')->with($data);
    }

public function create()
    {
        return view('customer.create');
    }

public function store(Request $request)
    {
        $this->validation($request);
        try {
            $customer = new Customer();
            $customer->name = $request->name;
            $customer->phone = $request->phone;
            $customer->email = $request->email;
            $customer->address = $request->address;
            $customer->due = $request->input('due', 0);
            $customer->save();
            successAlert('Created successfully');
            return redirect()->route('customer.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function edit($id)
    {
        $customer = Customer::find($id);
        return view('customer.edit', compact('customer'));
    }

public function update(Request $request, Customer $customer)
    {
        $this->validation($request, $customer->id);

try {
            $customer->name = $request->name;
            $customer->phone = $request->phone;
            $customer->email = $request->email;
            $customer->address = $request->address;
            $customer->due = $request->input('due', 0);
            $customer->save();
            successAlert('Updated successfully');
            return redirect()->route('customer.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function show($id)
    {
        $customer = Customer::find($id);
        $data['customer'] = $customer;
        $data['invoice'] = Invoice::where('customer_id', $customer->id)->get();
        $data['transaction'] = InvoicePay::where('customer_id', $customer->id)->get();
        $data['methods'] = Method::groupBy('name')->get();
        return view('customer.view')->with($data);
    }

public function delete($id)
    {
        try {
            $customer = Customer::find($id);
            $customer->delete();
            successAlert('Deleted successfully');
            return redirect()->route('customer.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function duePayment(Request $request)
    {
        $request->validate([
            'customer_id' => 'required',
            'method_id' => 'required',
        ]);
        try {
            $amount = $request->input('amount');
            DB::beginTransaction();
            $customer = Customer::findOrFail($request->customer_id);
            if ($amount > $customer->due){
                throw new \Exception('Invalid amount');
            }
            $customer->due -= $amount;
            $customer->save();
            if ($request->filled('invoice_id')){
                $invoice = Invoice::findOrFail($request->invoice_id);
                $invoice->due_price -= $amount;
                $invoice->paid_amount += $amount;
                $invoice->save();

$transaction = new InvoicePay();
                $transaction->amount = $amount;
                $transaction->invoice_id = $request->input('invoice_id');
                $transaction->customer_id = $request->input('customer_id');
                $transaction->method_id = $request->input('method_id');
                $transaction->date = now();
                $transaction->save();
            }

$paymentMethod = Method::findOrFail($request->input('method_id'));
            $paymentMethod->balance += $amount;
            $paymentMethod->save();

DB::commit();
            successAlert('Payment successfully processed');
            return redirect()->back();
        } catch (\Exception $e) {
            DB::rollBack();
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function due(Request $request)
 {
 if ($request->ajax()) {
 $data = Customer::select('id', 'name', 'address', 'phone', 'due')->where('shop_id', Auth::user()->shop_id)->where('due', '>', 0);
 return Datatables::of($data)
 ->addIndexColumn()
 ->addColumn('action', function ($row) {
 return '<a href="' . route('customer.edit', $row->id) . '" class="badge bg-primary"></a> <a href="' . route('customer.view', $row->id) . '" class="badge bg-info"></a> <a onclick="return confirm(\'Are you sure?\')" href="' . route('customer.delete', $row->id) . '" class="badge bg-danger"></a>';
 })
 ->rawColumns(['action'])
 ->make(true);
 }
 $customer = Customer::where('shop_id', Auth::user()->shop_id)->get();

return view('customer.due', compact('customer'));
    }

public function sendEmail(Request $request)
    {
        $customers = Customer::select('id', 'name', 'address', 'phone', 'email')->where('shop_id', Auth::user()->shop_id)->latest()->get();
        return view('customer.email_sender', compact('customers'));
    }

public function sendEmailProcess(Request $request)
    {
        $request->validate([
            'customers' => 'required',
            'email_subject' => 'required',
            'email_body' => 'required',
        ], [
            'customers.required' => 'Customers is required',
            'email_subject.required' => 'Subject field is required',
            'email_body.required' => 'Email body field is required',
        ]);
        try {
            $company = Auth::user()->shop;
            $user = Auth::user();
            $data = [
                'subject' => $request->email_subject . ' | ' . env('MAIL_FROM_NAME'),
                'company_owner' => $user->name,
                'company_name' => $company->name,
                'from_email' => env('MAIL_FROM_ADDRESS'),
                'body' => $request->email_body,
                'logo' => asset('storage/images/admin/site_logo/' . $company->site_logo),
                'site_name' => $company->site_title,
            ];
            foreach ($request->customers as $customer) {
                $cmr = Customer::where('email', $customer)->first();
                $data['customer_name'] = $cmr->name;
                Mail::to($customer)->send(new SendCustomerMail($data));
            }
            Toastr::success('Mail has been sent successfuly!', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return back();
        } catch (\Exception $exception) {
            Toastr::error($exception->getMessage(), '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->back();
        }
    }

private function validation($request, $id = null)
    {
        return $request->validate([
            'name' => 'required',
            'email' => 'required|unique:customers,email,' . $id,
            'phone' => 'required|unique:customers,phone,' . $id,
        ]);
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: CustomerController.php

Server Info

System Features

User Info