MAINHACK

Viewing / Editing File: PurchaseController.php

<?php

namespace Modules\Crm\Http\Controllers;

use App\Contact;
use App\Http\Controllers\Controller;
use App\Transaction;
use App\Utils\ModuleUtil;
use App\Utils\ProductUtil;
use App\Utils\TransactionUtil;
use Illuminate\Http\Request;
use Yajra\DataTables\Facades\DataTables;

class PurchaseController extends Controller
{
    /**
     * All Utils instance.
     */
    protected $productUtil;

protected $transactionUtil;

protected $moduleUtil;

/**
     * Constructor
     *
     * @param  ProductUtils  $product
     * @return void
     */
    public function __construct(ProductUtil $productUtil, TransactionUtil $transactionUtil, ModuleUtil $moduleUtil)
    {
        $this->productUtil = $productUtil;
        $this->transactionUtil = $transactionUtil;
        $this->moduleUtil = $moduleUtil;
    }

/**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function getPurchaseList(Request $request)
    {
        $business_id = request()->session()->get('user.business_id');

$contact_type = Contact::where('business_id', $business_id)
                            ->find(auth()->user()->crm_contact_id)
                            ->type;

if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'crm_module') && in_array($contact_type, ['supplier', 'both']))) {
            abort(403, 'Unauthorized action.');
        }

if ($request->ajax()) {
            $purchases = $this->transactionUtil->getListPurchases($business_id);

//filter by payment status
 if (! empty($request->input('payment_status')) && $request->input('payment_status') != 'overdue') {
 $purchases->where('transactions.payment_status', $request->input('payment_status'));
 } elseif ($request->input('payment_status') == 'overdue') {
 $purchases->whereIn('transactions.payment_status', ['due', 'partial'])
 ->whereNotNull('transactions.pay_term_number')
 ->whereNotNull('transactions.pay_term_type')
 ->whereRaw("IF(transactions.pay_term_type='days', DATE_ADD(transactions.transaction_date, INTERVAL transactions.pay_term_number DAY) < CURDATE(), DATE_ADD(transactions.transaction_date, INTERVAL transactions.pay_term_number MONTH) < CURDATE())");
 }

//filter by purchase status
            if (! empty($request->status)) {
                $purchases->where('transactions.status', $request->status);
            }

//filter by date
 if (! empty($request->start_date) && ! empty($request->end_date)) {
 $start = $request->start_date;
 $end = $request->end_date;
 $purchases->whereDate('transactions.transaction_date', '>=', $start)
 ->whereDate('transactions.transaction_date', '<=', $end);
 }

//get purchase of logged in supplier/customer
            $purchases->where('contacts.id', auth()->user()->crm_contact_id);

return Datatables::of($purchases)
 ->addColumn('action', function ($row) {
 $html = '<div class="btn-group">
 <button type="button" class="tw-dw-btn tw-dw-btn-xs tw-dw-btn-outline tw-dw-btn-info tw-w-max dropdown-toggle" 
 data-toggle="dropdown" aria-expanded="false">'.
 __('messages.actions').
 'Toggle Dropdown
 
 </button>
 <ul class="dropdown-menu dropdown-menu-left" role="menu">
 <li>
 <a href="#" data-href="'.action([\App\Http\Controllers\PurchaseController::class, 'show'], [$row->id]).'" class="btn-modal" data-container=".view_modal">'.__('messages.view').'</a>
 </li>

<li>
 <a href="#" class="print-invoice" data-href="'.action([\App\Http\Controllers\PurchaseController::class, 'printInvoice'], [$row->id]).'">'.__('messages.print').'</a>
 </li>';

$html .= '</ul>
 </div>';

return $html;
 })
 ->removeColumn('id')
 ->editColumn('ref_no', function ($row) {
 return ! empty($row->return_exists) ? $row->ref_no.' ' : $row->ref_no;
 })
 ->editColumn(
 'final_total',
 '{{$final_total}}'
 )
 ->editColumn('transaction_date', '{{@format_datetime($transaction_date)}}')
 ->editColumn(
 'status',
 '<a href="#">
 
 {{__(\'lang_v1.\' . $status)}}
 
 </a>'
 )
 ->editColumn(
 'payment_status',
 function ($row) {
 $payment_status = Transaction::getPaymentStatus($row);

if ($payment_status == 'partial') {
                            $bg = 'bg-aqua';
                        } elseif ($payment_status == 'due') {
                            $bg = 'bg-yellow';
                        } elseif ($payment_status == 'paid') {
                            $bg = 'bg-light-green';
                        } elseif ($payment_status == 'overdue' || $payment_status == 'partial-overdue') {
                            $bg = 'bg-red';
                        }

$html = '<a href="#" class="view_payment_modal payment-status-label" data-orig-value="'.$payment_status.'" data-status-name="'.__('lang_v1.'.$payment_status).'">'.__('lang_v1.'.$payment_status).'
 </a>';

return $html;
 }
 )
 ->addColumn('payment_due', function ($row) {
 $due = $row->final_total - $row->amount_paid;
 $due_html = ''.__('lang_v1.purchase').': '.$due.'';

if (! empty($row->return_exists)) {
 $return_due = $row->amount_return - $row->return_paid;
 $due_html .= ' '.__('lang_v1.purchase_return').': <a href="#" class="no-print">'.$return_due.'</a>'.$return_due.'';
 }

return $due_html;
                })
                ->setRowAttr([
                    'data-href' => function ($row) {
                        return  action([\App\Http\Controllers\PurchaseController::class, 'show'], [$row->id]);
                    }, ])
                ->rawColumns(['action', 'ref_no', 'status', 'payment_status', 'final_total', 'payment_due'])
                ->make(true);
        }

$orderStatuses = $this->productUtil->orderStatuses();

return view('crm::purchase.index')
            ->with(compact('orderStatuses'));
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: PurchaseController.php

Server Info

System Features

User Info