MAINHACK

Viewing / Editing File: MedicineController.php

<?php

namespace App\Http\Controllers;

use App\Models\Batch;
use App\Models\Category;
use App\Models\Change;
use App\Models\Ecommerce\Product;
use App\Models\EmergencyStock;
use App\Models\Leaf;
use App\Models\Medicine;
use App\Models\ProductCategory;
use App\Models\Shop;
use App\Models\Supplier;
use App\Models\Type;
use App\Models\Unit;
use App\Models\Vendor;
use Brian2694\Toastr\Facades\Toastr;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Response;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Str;
use Intervention\Image\Facades\Image;
use Maatwebsite\Excel\Facades\Excel;
use Yajra\DataTables\DataTables;

class MedicineController extends Controller
{
    protected $model;

public function __construct()
    {
        $this->model = new Medicine();
    }

public function index(Request $request)
    {
        $suppliers = Supplier::select('id', 'name')->get();
        $collection = $this->model
            ->when($request->filled('keyword'), function ($query) use ($request) {
                $query->whereRaw("name regexp '^{$request->keyword}.*'")
                    ->OrWhere('qr_code', $request->keyword)
                    ->OrWhere('generic_name', $request->keyword);
            })
            ->when($request->filled('supplier_id'), function ($query) use ($request) {
                $query->where('supplier_id', $request->supplier_id);
            })
            ->latest()
            ->paginate($request->input('limit', 10));
        return view('medicine.index', compact('collection', 'suppliers'));
    }

public function create()
    {
        $data['suppliers'] = Supplier::select('id', 'name')->get();
        $data['vendors'] = Vendor::select('id', 'name')->get();
        $data['leafs'] = Leaf::select('id', 'name', 'amount')->get();
        $data['categories'] = ProductCategory::select('id', 'title')->get();
        $data['unit'] = Unit::select('id', 'name')->get();
        $data['type'] = Type::select('id', 'name')->get();
        return view('medicine.create')->with($data);
    }

public function store(Request $request)
    {
        $this->inputValidate($request);

try {
            $data = $request->except('_token');
            if ($request->has('image')) {
                $data['image'] = $this->fileUploader($request->image, 'images/medicine', 100, 100);
            }
            $data['slug'] = Str::slug($request->title);
            $data['categories'] = json_encode(@$request->product_categories);
            $data['instock'] = $request->quantity;
            unset($data['product_categories']);
            $this->model->create($data);
            successAlert('Medicine successfully created');
            return redirect()->route('medicines.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function edit($id)
    {
        $data['medicine'] = $this->model->findOrFail($id);
        $data['suppliers'] = Supplier::select('id', 'name')->get();
        $data['vendors'] = Vendor::select('id', 'name')->get();
        $data['leafs'] = Leaf::select('id', 'name', 'amount')->get();
        $data['categories'] = ProductCategory::select('id', 'title')->get();
        $data['unit'] = Unit::select('id', 'name')->get();
        $data['type'] = Type::select('id', 'name')->get();
        return view('medicine.edit')->with($data);
    }

public function update(Request $request, $id)
    {

$this->inputValidate($request, $id);
        try {
            $medicine = $this->model->find($id);
            $data = $request->except('_token');
            if ($request->has('image')) {
                $data['image'] = $this->fileUploader($request->image, 'images/medicine', 100, 100, $medicine->image);
            }
            $data['slug'] = Str::slug($request->title);
            $data['categories'] = json_encode(@$request->product_categories) ?? [];
            $data['instock'] = $request->quantity;
            unset($data['product_categories']);
            $medicine->update($data);
            successAlert('Medicine successfully updated');
            return redirect()->route('medicines.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

public function delete($id)
    {
        try {
            $medicine = $this->model->findOrFail($id);
            $medicine->delete();
            $this->deleteFile('images/medicine', $medicine->image);
            successAlert('Medicine successfully deleted');
            return redirect()->route('medicines.index');
        } catch (\Exception $e) {
            errorAlert($e->getMessage());
            return redirect()->back();
        }
    }

protected function inputValidate($request, $id = null)
    {
        return $request->validate([
            'name' => 'required',
            'generic_name' => 'required',
            'supplier_id' => 'required',
            'status' => 'required',
            'description' => 'required',
        ]);
    }

/**
     * Create a new controller instance.
     *
     * @return void
     */

/**
     * Show the application dashboard.
     *
     * @return \Illuminate\Contracts\Support\Renderable
     */

public function update_price(Request $request, $id)
    {
        $batch = Batch::findOrFail($id);
        if ($request->isMethod('post')) {
            $batch->price = $request->price;
            if ($batch->save()) {
                Toastr::success('Medicine successfully created', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->route('instock');
            } else {
                Toastr::error('Something Went Wrong', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->back();
            }
        }
        return view('medicine.update_price', compact('batch'));
    }

public function add(Request $request)
    {
        if ($request->isMethod('post')) {
            $customer = new Medicine();
            $customer->name = $request->name;
            $customer->qr_code = $request->qr_code;
            $customer->hns_code = $request->hns_code;
            $customer->strength = $request->strength;
            $customer->leaf_id = $request->leaf_id;
            $customer->shelf = $request->shelf;

if (is_numeric($request->category_id)) {
                $customer->category_id = $request->category_id;
            } else {
                $category = new Category();
                $category->name = $request->category_id;
                if ($unit->save()) {
                    $customer->category_id = $category->id;
                }
            }

$customer->supplier_id = $request->supplier_id;
            $customer->vendor_id = $request->vendor_id;
            $customer->vat = $request->vat;
            $customer->status = $request->status;
            $customer->global = 1;
            $customer->generic_name = $request->generic_name;
            $customer->generic_name = $request->generic_name;
            if ($customer->hot) {
                $customer->hot = $request->hot;
            }

$customer->des = $request->des;
            $customer->price = $request->price;
            $customer->buy_price = $request->buy_price;

if ($request->hasFile('image')) {
                $image = $request->file('image');
                $currentDate = Carbon::now()->toDateString();
                $imageName = $currentDate . '-' . uniqid() . '.' . $image->getClientOriginalExtension();
                if (Storage::disk('public')->exists('images/medicine')) {
                    Storage::disk('public')->makeDirectory('images/medicine');
                }
                if (Storage::disk('public')->exists('images/medicine/' . $customer->image)) {
                    Storage::disk('public')->delete('images/medicine/' . $customer->image);
                }
                $bannerImage = Image::make($image)->resize(1500, 1000)->stream();
                Storage::disk('public')->put('images/medicine/' . $imageName, $bannerImage);
                $customer->image = $imageName;
            }
            $customer->shop_id = Auth::user()->shop_id;
            if ($customer->save()) {
                Toastr::success('Medicine successfully created', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->route('medicine.list');
            } else {
                Toastr::error('Something Went Wrong', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->route('medicine.list');
            }
        } else {
            $supplier = Supplier::where('shop_id', Auth::user()->shop_id)->latest()->get();
            $vendors = Vendor::where('shop_id', Auth::user()->shop_id)->latest()->get();
            $leaf = Leaf::where('shop_id', Auth::user()->shop_id)->orWhere('global', 1)->get();
            $category = Category::where('shop_id', Auth::user()->shop_id)->orWhere('global', 1)->get();
            $unit = Unit::where('shop_id', Auth::user()->shop_id)->orWhere('global', 1)->get();
            $type = Type::where('shop_id', Auth::user()->shop_id)->orWhere('global', 1)->get();
            return view('medicine.add', compact('leaf', 'unit', 'category', 'supplier', 'vendors', 'type'));
        }
    }

public function change(Request $request, $id)
    {
        $medicine = Medicine::where('global', 1)->where('id', $id)->firstOrFail();
        if ($request->isMethod('post')) {
            if (Change::where('status', 0)->where('medicine_id', $id)->where('shop_id', Auth::user()->id)->first() != null) {
                Toastr::error('Already One Request Pending', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->back();
            }

$change = new Change();
            $change->medicine_id = $request->id;
            $change->category_id = $request->category_id;
            $change->oldcat_id = $medicine->category_id;
            $change->old_name = $medicine->name;
            $change->shop_id = Auth::user()->shop_id;
            $change->name = $request->name;
            $change->status = 0;
            if ($request->hasFile('image')) {

$image = $request->file('image');
                $currentDate = Carbon::now()->toDateString();
                $imageName = $currentDate . '-' . uniqid() . '.' . $image->getClientOriginalExtension();
                if (Storage::disk('public')->exists('images/medicine')) {
                    Storage::disk('public')->makeDirectory('images/medicine');
                }

$bannerImage = Image::make($image)->resize(1500, 1000)->stream();
                Storage::disk('public')->put('images/asset/' . $imageName, $bannerImage);
                $change->image = $imageName;
            }

if ($change->save()) {
                Toastr::success('Changes Request Succesfully Submitted', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->route('medicine.list');
            } else {
                Toastr::error('Something Went Wrong', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
                return redirect()->back();
            }
        } else {
            $category = Category::where('global', 1)->get();

return view('medicine.change', compact('medicine', 'category'));
        }
    }

public function expired(Request $request)
    {
        if ($request->ajax()) {
            $data = Batch::where('expire', '<=', date('Y-m-d'))->latest('id');
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('name', function ($row) {
                    $medicine = Medicine::where('id', $row->medicine_id)->first();
                    if ($medicine != null) {
                        return '' . $medicine->name . '(' . $medicine->strength . ')';
                    } else {
                        return '';
                    }
                })
                ->addColumn('supplier', function ($row) {
                    $supplier = Medicine::where('id', $row->medicine_id)->first();
                    return $supplier->supplier->name;
                })
                ->addColumn('action', function ($row) {
                    if ($row->global != 1) {
                        return '<a onclick="return confirm(\'Are you sure?\')" href="' . route('expired.delete', $row->id) . '" class="badge bg-danger"><i class="fas fa-trash"></i></a>';
                    }
                })
                ->rawColumns(['action'])
                ->make(true);
        }
        return view('medicine.expired');
    }

public function expired_delete($id)
    {
        $customer = Batch::where('id', $id)->firstOrFail();

if ($customer->delete()) {
            Toastr::success('Medicine successfully Deleted', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->route('report.already_expire');
        } else {
            Toastr::error('Something Went Wrong', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->route('report.already_expire');
        }

}

public function upcoming(Request $request)
    {
        $day = Shop::shopSetting('upcoming_expire_alert');
        if ($request->ajax()) {
            $today = date('Y-m-d', time());
            $upcomingDate = date('Y-m-d', strtotime("+$day days"));
            $data = $data = Batch::where('expire', '>', $today)
                ->where('expire', '<=', $upcomingDate)
                ->latest('id');

return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('name', function ($row) {
                    $medicine = Medicine::where('id', $row->medicine_id)->first();
                    if ($medicine != null) {
                        return '' . $medicine->name . '(' . $medicine->strength . ')';
                    } else {
                        return '';
                    }
                })
                ->addColumn('supplier', function ($row) {
                    $supplier = Medicine::where('id', $row->medicine_id)->first();
                    return $supplier->supplier->name;
                })
                ->make(true);
        }
        return view('medicine.upcoming');
    }

public function instock(Request $request)
    {
        $stock = Batch::select(\DB::raw('sum(buy_price * qty) as total'))->get();
        $sales = Batch::select(\DB::raw('sum(price * qty) as total'))->get();

$stockes = $stock['0']->total;
        $expected = $sales['0']->total;
        $profit = ($expected - $stockes);
        if ($request->ajax()) {
            $data = Medicine::whereHas('batch', function ($query) {
                $query->where('qty', '>', 0);
            })->latest();
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('supplier', function ($row) {
                    return $row->supplier->name;
                })
                ->addColumn('stock', function ($row) {
                    $stock = Batch::where('medicine_id', $row->id)->sum('qty');
                    return $stock;
                })
                ->addColumn('batch', function ($row) {
                    $batch_name = Batch::where('medicine_id', $row->id)->first()->name;
                    return $batch_name;
                })
                ->addColumn('cost', function ($row) {
                    $batch_price = Batch::where('medicine_id', $row->id)->first()->buy_price;
                    return number_format($batch_price, 2);
                })
                ->addColumn('total', function ($row) {
                    $qty = Batch::where('medicine_id', $row->id)->sum('qty');
                    $stock = Batch::where('medicine_id', $row->id)->first()->buy_price;
                    $amt = ($stock * $qty);
                    return number_format($amt, 2, ".", ",");
                })
                ->addColumn('action', function ($row) {
                    $stock = Batch::where('medicine_id', $row->id)->where('qty', '>', 0)->latest()->first();
                    return '<a href="' . route('update.price', $stock->id) . '" class="badge bg-primary">Update Price</a> ';

})
                ->rawColumns(['action'])
                ->make(true);
        }
        return view('medicine.instock', compact('stockes', 'expected', 'profit'));
    }

public function emergencyStock(Request $request)
    {
        $stock = Batch::select(\DB::raw('sum(buy_price * qty) as total'))->where('shop_id', Auth::user()->shop_id)->get();
        $sales = Batch::select(\DB::raw('sum(price * qty) as total'))->where('shop_id', Auth::user()->shop_id)->get();

$stockes = $stock['0']->total;
        $expected = $sales['0']->total;
        $profit = ($expected - $stockes);
        if ($request->ajax()) {
            $data = EmergencyStock::where(function ($q) {
                $q->where('global', 1);
            })->whereHas('batch', function ($query) {
                $query->where('qty', '>', 0);
            })->orderBy('name', 'asc');
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('supplier', function ($row) {
                    return $row->supplier->name;
                })
                ->addColumn('stock', function ($row) {
                    $stock = Batch::where('medicine_id', $row->id)->sum('qty');
                    return $stock;
                })
                ->addColumn('batch', function ($row) {
                    $batch_name = Batch::where('medicine_id', $row->id)->first()->name;
                    return $batch_name;
                })
                ->addColumn('cost', function ($row) {
                    $batch_price = Batch::where('medicine_id', $row->id)->first()->buy_price;
                    return number_format($batch_price, 2);
                })
                ->addColumn('total', function ($row) {
                    $qty = Batch::where('medicine_id', $row->id)->sum('qty');
                    $stock = Batch::where('medicine_id', $row->id)->first()->buy_price;
                    $amt = ($stock * $qty);
                    return number_format($amt, 2, ".", ",");
                })
                ->addColumn('action', function ($row) {
                    $stock = Batch::where('medicine_id', $row->id)->where('qty', '>', 0)->latest()->first();
                    return '<a href="' . route('update.price', $stock->id) . '" class="badge bg-primary">Update Price</a> ';

})
                ->rawColumns(['action'])
                ->make(true);
        }
        return view('medicine.emergency_stock', compact('stockes', 'expected', 'profit'));
    }

public function lowstock(Request $request)
    {
        $low_stock_amount = Shop::shopSetting('low_stock_alert');
        if ($request->ajax()) {
            $data = Medicine::select('*')->whereHas('batch', function ($query) {
                $query->where('qty', '>', 0);
            })->withCount(['batch as total_quantity' => function ($query) {
                $query->select(DB::raw('sum(qty)'));
            }])
                ->having('total_quantity', '<', $low_stock_amount)
                ->latest();
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('supplier', function ($row) {
                    return $row->supplier->name;
                })
                ->addColumn('quantity', function ($row) {
                    return $row->total_quantity;
                })
                ->make(true);
        }
        return view('medicine.lowstock');
    }

public function stockout(Request $request)
    {
        if ($request->ajax()) {
            $data = Medicine::select('*')
                ->whereHas('batch', function ($query) {
                    $query->where('qty', '<', 1);
                })
                ->latest('id');
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('supplier', function ($row) {
                    return $row->supplier->name;
                })
                ->make(true);
        }
        return view('medicine.stockout');
    }

public function importFormView()
    {
        return view('medicine.import_form');
    }

public function importProcess(Request $request)
    {
        $request->validate([
            'medicines' => 'required',
        ], ['medicines.required' => 'Medicine file is required']);
        try {
            if ($request->hasFile('medicines')) {
                $file = $request->file('medicines');
                Excel::import(new MedicineImport(), $file);
            }
            Toastr::success('Medicines has been imported successfully!', '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->back();
        } catch (\Exception $e) {
            Toastr::error($e->getMessage(), '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->back();
        }
    }

public function exporter($slug)
    {
        try {
            $csv_name = $slug;
            $table = $slug;
            if ($slug == 'leaves') {
                $csv_name = 'leaf';
            }
            $filename = "$csv_name.csv";
            $exported_data = DB::table($table)->get()->toArray();
            if (!empty($exported_data)) {
                $headers = $this->makeHeader($table);
                $handle = fopen($filename, 'w+');
                fputcsv($handle, $headers);

foreach ($exported_data as $key => $item) {
                    fputcsv($handle, json_decode(json_encode($item), true));
                }

fclose($handle);
                $headers = array(
                    'Content-Type' => 'text/csv',
                );
                return Response::download($filename, $filename, $headers);
            }
            Toastr::error("No record found in your database, please add $slug", '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->back();
        } catch (\Exception $e) {
            Toastr::error($e->getMessage(), '', ['progressBar' => true, 'closeButton' => true, 'positionClass' => 'toast-top-right']);
            return redirect()->back();
        }
    }

protected function makeHeader($table)
    {
        $fields = DB::table($table)->first();
        $columns = [];
        foreach ($fields as $key => $field) {
            $columns[] = $key;
        }
        return $columns;
    }

public function mergeProduct()
    {
        try {
            $medicinesToInsert = DB::table('medicines')
                ->whereNotIn('name', DB::table('products')->pluck('name'))
                ->get();

foreach ($medicinesToInsert as $medicine) {
                DB::table('products')->insert(
                    [
                        'name' => @$medicine->name,
                        'slug' => Str::slug(@$medicine->name),
                        'generic_name' => @$medicine->generic_name,
                        'price' => @$medicine->price,
                        'buy_price' => @$medicine->buy_price,
                        'quantity' => 0,
                        'instock' => 0,
                        'strength' => @$medicine->strength,
                        'leaf_id' => @$medicine->leaf_id,
                        'type_id' => @$medicine->type_id,
                        'unit_id' => @$medicine->unit_id,
                        'shelf' => @$medicine->shelf,
                        'categories' => json_encode([]),
                        'supplier_id' => @$medicine->supplier_id,
                        'vendor_id' => @$medicine->vendor_id,
                        'type' => 'global',
                        'vat' => @$medicine->vat,
                        'discount' => 0,
                        'description' => @$medicine->des,
                        'status' => @$medicine->status,
                        'image' => @$medicine->image,
                        'igta' => @$medicine->igta,
                        'hns_code' => @$medicine->hns_code,
                        'created_at' => @$medicine->created_at,
                        'updated_at' => @$medicine->updated_at,
                    ]
                );
            }
            successAlert('Medicine successfully merged');
            return redirect()->route('medicines.index');
        } catch (\Exception $e) {
            dd($e);
        }
    }

public function barcodeGenerate()
    {
        $generatedCode = $this->generateCode();
        $uniqueCode = $this->model->where('qr_code', $generatedCode)->first();

if ($uniqueCode) {
            $barcode = $this->generateCode();
        } else {
            $barcode = $generatedCode;
        }
        return response()->json(['message' => 'Barcode', 'barcode' => $barcode], 200);
    }

private function generateCode()
    {
        return uniqid('0110');
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: MedicineController.php

Server Info

System Features

User Info