<?php

namespace App\Http\Controllers;

use App\Influencer;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Hash;
use Validator;

class ProductsController extends Controller
{

	public function getCountries()
	{
		$countries = DB::table('country')
		->get();
		return $countries;
	}


	public function getCarriers()
	{
		$carriers = DB::table('carrier')
		->get();
		return $carriers;
	}



    public function index()
    {		
		$products = DB::table('product')
    	->select(
    		'product.id as id',
    		'product.active as active',
    		'carrier.name as carrier',
    		'country.name as country',
    		'product.sku as sku',
    		'product.amounts as amount',
    		'product.discount_pct as discount_pct',
    		'product.telecom_pct as telecom_pct',
    		'product.is_pinless as is_pinless'
    		)
    	->leftJoin('carrier', 'carrier.id', '=', 'product.carrier_id')
    	->leftJoin('country', 'country.id', '=', 'product.country_id')
    	->paginate(20);
    
    	return view('products.index', [
			'products' => $products,
			'countries' => $this->getCountries(),
			'carriers' => $this->getCarriers()
		]);
    }



	public function filter()
	{
		
		if(Input::has('countries') && Input::has('carriers'))
		{
			$products = DB::table('product')
			->select(
				'product.id as id',
				'product.active as active',
				'carrier.name as carrier',
				'country.name as country',
				'product.sku as sku',
				'product.amounts as amount',
				'product.discount_pct as discount_pct',
				'product.telecom_pct as telecom_pct',
				'product.is_pinless as is_pinless'
    		)
			->leftJoin('carrier', 'carrier.id', '=', 'product.carrier_id')
    		->leftJoin('country', 'country.id', '=', 'product.country_id')
			->where('country.id', '=', Input::get('countries'))
			->where('carrier.id', '=', Input::get('carriers'))
			->paginate(20);

			
			return view('products.index', [
				'products' => $products,
				'countries' => $this->getCountries(),
				'carriers' => $this->getCarriers()
			]);
		}
		else if(Input::has('countries'))
		{
			$products = DB::table('product')
			->select(
				'product.id as id',
				'product.active as active',
				'carrier.name as carrier',
				'country.name as country',
				'product.sku as sku',
				'product.amounts as amount',
				'product.discount_pct as discount_pct',
				'product.telecom_pct as telecom_pct',
				'product.is_pinless as is_pinless'
    		)
			->leftJoin('carrier', 'carrier.id', '=', 'product.carrier_id')
    		->leftJoin('country', 'country.id', '=', 'product.country_id')
			->where('country.id', '=', Input::get('countries'))
			->paginate(20);

			return view('products.index', [
				'products' => $products,
				'countries' => $this->getCountries(),
				'carriers' => $this->getCarriers()
			]);
		}
		else if(Input::has('carriers'))
		{
			$products = DB::table('product')
			->select(
				'product.id as id',
				'product.active as active',
				'carrier.name as carrier',
				'country.name as country',
				'product.sku as sku',
				'product.amounts as amount',
				'product.discount_pct as discount_pct',
				'product.telecom_pct as telecom_pct',
				'product.is_pinless as is_pinless'
    		)
			->leftJoin('carrier', 'carrier.id', '=', 'product.carrier_id')
    		->leftJoin('country', 'country.id', '=', 'product.country_id')
			->where('carrier.id', '=', Input::get('carriers'))
			->paginate(20);

			
			return view('products.index', [
				'products' => $products,
				'countries' => $this->getCountries(),
				'carriers' => $this->getCarriers()
			]);
		}
		else
		{
			$products = DB::table('product')
			->select(
				'product.id as id',
				'product.active as active',
				'carrier.name as carrier',
				'country.name as country',
				'product.sku as sku',
				'product.amounts as amount',
				'product.discount_pct as discount_pct',
				'product.telecom_pct as telecom_pct',
				'product.is_pinless as is_pinless'
				)
			->leftJoin('carrier', 'carrier.id', '=', 'product.carrier_id')
			->leftJoin('country', 'country.id', '=', 'product.country_id')
			->paginate(20);


			return view('products.index', [
				'products' => $products,
				'countries' => $this->getCountries(),
				'carriers' => $this->getCarriers()
			]);
		}
	}



    public function getAll()
    {
    	$products = DB::table('product')->get();
    	
    	return response()->json($products);
    }




    public function update($id)
    {
    	
    	if(Input::has('active'))
    	{
    		DB::table('product')
    		->where('id', '=', $id)
    		->update(['active' => Input::get('active')]);
    	}

    	if(Input::has('discount_pct'))
    	{
    		DB::table('product')
    		->where('id', '=', $id)
    		->update(['discount_pct' => Input::get('discount_pct')]);
    	}
    	

    	if(Input::has('telecom_pct'))
    	{
    		DB::table('product')
    		->where('id', '=', $id)
    		->update(['telecom_pct' => Input::get('telecom_pct')]);
    	}



    	//$product = DB::table('product')->where('id', '=', $id)->get();

    	return redirect()->back();
    }


    public function updateUserpct($id)
    {
    	/*if(Input::has('discount_pct'))
    	{
    		DB::table('product')
    		->where('id', '=', $id)
    		->update(['discount_pct' => Input::get('discount_pct')]);
    	}*/

    	return $id;
    }


}
