seController

<?php

namespace App\Http\Controllers\Distribution;
//  start-  code 15-jan-2020
use App\Models\Distribution\HubManager;
use App\Models\Distribution\Order;
use App\Models\Distribution\PO;
use App\Models\Distribution\Payment;
use App\Models\Distribution\PaymentData;

//  end-  code 15-jan-2020

use App\Http\Controllers\Controller;
use App\Models\Distribution\DistrubutionFmcg;
use App\Models\Distribution\HubWmm;
use App\Models\Distribution\Package;
use App\Models\Distribution\Requsition;
use App\Models\Distribution\RequsitionData;
use App\Models\Distribution\TerritoryHub;
use App\Models\Distribution\TerritoryManager;
use App\Repository\RetailNetworkProductCategoryRepository;
use App\Repository\RetailNetworkProductRepository;
use App\Repository\RetailNetworkProductUnitRepository;
use App\Repository\RetailNetworkRoleRepository;
use Auth;
use DB;
use Illuminate\Http\Request;
use Illuminate\Support\Arr;
use Session;

class SeController extends Controller
{

    private $product;
    private $unit;
    private $category;
    private $role;

    public function __construct(RetailNetworkProductUnitRepository $unit,RetailNetworkProductCategoryRepository $category,RetailNetworkRoleRepository $role){
        //$this->product = $product;
        $this->unit = $unit;
        $this->category = $category;
        $this->role = $role;
        $this->product = new RetailNetworkProductRepository();
    }

   public function products($prefix){

         return view('distribution.se.product_list',[
            'prefix'=>$prefix,
            'units'=>$this->unit->all($prefix),
            'formUnits'=>$this->unit->allByActive($prefix),
            'categories'=>$this->category->all($prefix),
            'formCategories'=>$this->category->allByActive($prefix),
            'roles'=>$this->role->allByActive($prefix),
            'products'=>$this->product->all($prefix),
            'companies'=>DistrubutionFmcg::with('company')->get(),
            'brands'=>$this->product->getBrandForUser($prefix),
            'productsforSelect'=>$this->product->allForSelect($prefix),
            'packages'=>Package::get(),

       ]);
   }


   public function dashboard($prefix){
      return view('distribution.se.dashboard');
   }



    public function requisitionHistory($prefix){

        $territory = TerritoryManager::where(['user_id'=>Auth::guard('web')->user()->id])->pluck('territory_id');
        //dd($territory);

        if(count($territory) > 0){
            $hubs = TerritoryHub::whereIn('territory_id',$territory)->pluck('hub_id');
            if(count($hubs) > 0){
                $users = HubWmm::whereIn('hub_id',$hubs)->pluck('user_id');

                $allRequsitions = Requsition::with('user')->whereIn('user_id',$users)->orderBy('id','desc')->paginate(100);

            }else{
                $allRequsitions = array();
            }

        }else{
            $allRequsitions = array();
        }

      return view('distribution.se.requisition_history',[
        'prefix'=>$prefix,
        'requsitions'=>$allRequsitions,
      ]);
    }


  public function productListByRequsition($prefix,$requsition_id){
       $data =  RequsitionData::where(['requsition_id'=>$requsition_id])->get();
      $requsition =  Requsition::where(['id'=>$requsition_id])->get()->first();

        return view('distribution.se.requisition_history_details',[
            'prefix'=>$prefix,
            'requsition'=>$requsition,
            'requsitionData'=>$data,
        ]);
  }


  public function productListByRequsitionChangeStatus(Request $request,$prefix,$id){
      if($request->confirm != ""){
          Requsition::where(['id'=>$id])->update([
              'status'=>$request->confirm
          ]);
          Session::flash('success','Change Order Status Successfully');
          return redirect()->back();
      }
  }



//  start-  code 15-jan-2020
public function transctionList($prefix){
    // return "ok";
    $territory = TerritoryManager::where(['user_id'=>Auth::guard('web')->user()->id])->pluck('territory_id');

    if(count($territory) > 0){
        $hubs = TerritoryHub::whereIn('territory_id',$territory)->pluck('hub_id');
        if(count($hubs) > 0){
            $users = HubWmm::whereIn('hub_id',$hubs)->pluck('user_id');

            $allRequsitions = Requsition::with('user')->whereIn('user_id',$users)->orderBy('id','desc')->paginate(100);
            $paymentInfo    = Payment::with('user')->whereIn('requisition_id',$allRequsitions)->orderBy('id','desc')->paginate(100);

        }else{
            $allRequsitions = array();
            $paymentInfo = array();
        }

    }else{
        $allRequsitions = array();
        $paymentInfo = array();
    }
    // return $users;
    // return $allRequsitions;
    // $paymentInfo = Payment::all();
    // $allRequsitions = Requsition::all();



    return view('distribution.se.se_cash_collection_history',[
        'prefix'=>$prefix,
        'transctionList'=>$paymentInfo,
        'allRequsitions'=>$allRequsitions,
    ]);

}


public function transctionDetailsById($prefix,$id){

    // return "se";
    $payment = Payment::where(['id'=>$id])->get()->first();
    $paymentData = PaymentData::where(['payment_id'=>$id])->get();

     return view('distribution.se.se_requisitionPyamentDetails',[
        'prefix'=>$prefix,
        'payment'=>$payment,
        'paymentData'=>$paymentData,
    ]);

}

public function sales($prefix)
{
    $territory = TerritoryManager::where(['user_id'=>Auth::guard('web')->user()->id])->pluck('territory_id');
    //dd($territory);

    if(count($territory) > 0){
        $hubs = TerritoryHub::whereIn('territory_id',$territory)->pluck('hub_id');
        if(count($hubs) > 0){
            $users = HubWmm::whereIn('hub_id',$hubs)->pluck('user_id');

            $allOrders = Order::with('user')
                                ->whereIn('user_id',$users)

                                ->orderBy('id','desc')->paginate(100);

        }else{
            $allOrders = array();
        }

    }else{
        $allOrders = array();
    }

    // return $allOrders;

    return view('distribution.se.se_sales',[
        'prefix'=>$prefix,
        'requsitions'=>$allOrders,
      ]);
}

public function individualsales($prefix,$id)
{
    $allOrders_ById = Order::with('user')
                        ->where('user_id',$id)
                        ->orderBy('id','desc')->paginate(100);
    // return $allOrders_ById;

    return view('distribution.se.se_sales_by_individual',[
        'prefix'=>$prefix,
        'requsitions'=>$allOrders_ById,
      ]);
}
//  end-    code 15-jan-2020



}