<?php
/**
*
* @ This file is created by http://DeZender.Net
* @ deZender (PHP7 Decoder for ionCube Encoder)
*
* @ Version			:	4.0.6.0
* @ Author			:	DeZender
* @ Release on		:	20.09.2018
* @ Official site	:	http://DeZender.Net
*
*/

namespace App\Http\Controllers\Admin;

class PackageController extends Controller
{
	public function index()
	{
		return view('admin.packages.index');
	}

	public function indexData()
	{
		if (request()->server('SERVER_NAME') == 'smmworldpanel.com') {
			$packages = DB::select('SELECT' . "\n" . '                                         id,' . "\n" . '                                         name,' . "\n" . '                                         description,' . "\n" . '                                         price_per_item,' . "\n" . '                                         minimum_quantity,' . "\n" . '                                         maximum_quantity,' . "\n" . '                                         features,' . "\n" . '                                         position,' . "\n" . '                                         status' . "\n" . '                                       FROM' . "\n" . '                                         packages' . "\n" . '                                       UNION' . "\n" . '                                       SELECT' . "\n" . '                                         id,' . "\n" . '                                         name,' . "\n" . '                                         "3kWKcZLJ" AS description,' . "\n" . '                                         -1 AS price_per_item,' . "\n" . '                                         -1 AS minimum_quantity,' . "\n" . '                                         -1 AS maximum_quantity,' . "\n" . '                                         "" AS features,' . "\n" . '                                         position,' . "\n" . '                                         status' . "\n" . '                                       FROM' . "\n" . '                                         services');
		}
		return datatables()->of($packages)->editColumn('id', function($package) {
			if ($package->description == '3kWKcZLJ') {
				return $package->id . '<br><a href="/admin/package/service/' . $package->id . '/up" class="btn btn-xs btn-success"><i class="fas fa-caret-square-up"></i></a>&nbsp;<a href="/admin/package/service/' . $package->id . '/down" class="btn btn-xs btn-success"><i class="fas fa-caret-square-down"></i></a>';
			}
			else {
				return $package->id . '<br><a href="/admin/package/' . $package->id . '/up" class="btn btn-xs btn-success"><i class="fas fa-caret-square-up"></i></a>&nbsp;<a href="/admin/package/' . $package->id . '/down" class="btn btn-xs btn-success"><i class="fas fa-caret-square-down"></i></a>';
			}
		})->addColumn('action', function($package) {
			$id = $package->id;

			if ($package->description == '3kWKcZLJ') {
				return view('admin.services.index-buttons', compact('id'));
			}
			else {
				return view('admin.packages.index-buttons', compact('id'));
			}
		})->addColumn('sposition', function($package) {
			if ($package->description == '3kWKcZLJ') {
				return $package->position;
			}
			else {
				return \App\Package::find($package->id)->service->position;
			}
		})->addColumn('jposition', function($package) {
			if ($package->description == '3kWKcZLJ') {
				return 0;
			}
			else {
				return $package->position;
			}
		})->editColumn('price_per_item', '{{ getOption(\'currency_symbol\') . number_format(($price_per_item * getOption(\'display_price_per\')),2, getOption(\'currency_separator\'), \'\') }}')->editColumn('description', '{{ str_limit($description,50) }}')->setRowClass(function($package) {
			return $package->description == '3kWKcZLJ' ? 'serviceClass' : '';
		})->rawColumns(['id', 'action'])->toJson();
	}

	public function create()
	{
		$apis = \App\API::all();
		$services = \App\Service::where(['status' => 'ACTIVE'])->get();
		return view('admin.packages.create', compact('services', 'apis'));
	}

	public function store(\Illuminate\Http\Request $request)
	{
		$this->validate($request, ['service_id' => 'required', 'name' => 'required', 'price_per_item' => 'required|numeric', 'minimum_quantity' => 'required|numeric', 'maximum_quantity' => 'required|numeric', 'description' => 'required', 'features' => 'required']);
		$price_per_item = $request->input('price_per_item') / 1000;
		$minimum_quantity = $request->input('minimum_quantity');
		$preferred_api_id = (!!$request->input('preferred_api_id') ? $request->input('preferred_api_id') : NULL);
		$package = \App\Package::create(['service_id' => $request->input('service_id'), 'name' => $request->input('name'), 'slug' => str_slug($request->input('name')), 'price_per_item' => $price_per_item, 'minimum_quantity' => $request->input('minimum_quantity'), 'maximum_quantity' => $request->input('maximum_quantity'), 'refillbtn' => $request->input('refillbtn'), 'features' => $request->input('features'), 'status' => $request->input('status'), 'preferred_api_id' => $preferred_api_id, 'custom_comments' => $request->input('custom_comments'), 'description' => $request->input('description')]);
		$seller_package_id = (!!$request->input('seller_package_id') ? $request->input('seller_package_id') : NULL);
		if (isset($seller_package_id) && isset($preferred_api_id)) {
			\App\ApiMapping::create(['api_id' => $preferred_api_id, 'api_package_id' => $seller_package_id, 'package_id' => $package->id]);
		}

		\Illuminate\Support\Facades\Session::flash('alert', __('messages.created'));
		\Illuminate\Support\Facades\Session::flash('alertClass', 'success');
		return redirect('/admin/packages/create');
	}

	public function show($id)
	{
		return redirect('/admin/packages');
	}

	public function edit($id)
	{
		$package = \App\Package::findOrFail($id);
		$apis = \App\API::all();
		$services = \App\Service::where(['status' => 'ACTIVE'])->get();
		$am = \App\ApiMapping::where(['api_id' => $package->preferred_api_id, 'package_id' => $package->id])->get();

		if (0 < $am->count()) {
			$api_package_id = $am->first()->api_package_id;
		}
		else {
			$api_package_id = '';
		}

		return view('admin.packages.edit', compact('services', 'package', 'apis', 'api_package_id'));
	}

	public function update(\Illuminate\Http\Request $request, $id)
	{
		$this->validate($request, ['service_id' => 'required', 'name' => 'required', 'price_per_item' => 'required|numeric', 'minimum_quantity' => 'required|numeric', 'maximum_quantity' => 'required|numeric', 'description' => 'required', 'features' => 'required']);
		$price_per_item = $request->input('price_per_item') / 1000;
		$minimum_quantity = $request->input('minimum_quantity');
		$package = \App\Package::findOrFail($id);
		$preferred_api_id = (!!$request->input('preferred_api_id') ? $request->input('preferred_api_id') : NULL);
		$package->service_id = $request->input('service_id');
		$package->name = $request->input('name');
		$package->slug = str_slug($request->input('name'));
		$package->price_per_item = $price_per_item;
		$package->minimum_quantity = $request->input('minimum_quantity');
		$package->maximum_quantity = $request->input('maximum_quantity');
		$package->refillbtn = $request->input('refillbtn');
		$package->features = $request->input('features');
		$package->position = $request->input('position');
		$package->status = $request->input('status');
		$package->description = $request->input('description');
		$package->preferred_api_id = $preferred_api_id;
		$package->custom_comments = $request->input('custom_comments');
		$package->save();
		$seller_package_id = (!!$request->input('seller_package_id') ? $request->input('seller_package_id') : NULL);
........................................................................................................................
...................................................
............................