000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class RebateController extends Controller
{

public function monthlyRebateReport(Request $request){
		$data = array();

if ($request->isMethod('post')){
			$validator = \Validator::make($request->all(),
				array(
					'month' =>'required',
					'year' =>'required',
				)
			);

if($validator->fails()){
				return redirect('user/monthly-rebate-report')
				->withErrors($validator)
				->withInput();
			}else{
				$month = $request->month;
				$year = $request->year;
				$start = $year.'-'.$month.'-01';
				$end = $year.'-'.$month.'-31';

$company_dis_rabate = \DB::table('company_dis')->select('product_company_id','payment_date', \DB::raw('SUM(claim_amount) as total_claim'))->whereBetween('payment_date',[$start,$end])->groupBy('product_company_id')->get();

$warehouse_dis_rabate = \DB::table('warehouse_dis')->select('product_company_id','payment_date', \DB::raw('SUM(claim_amount) as total_claim'))->whereBetween('payment_date',[$start,$end])->groupBy('product_company_id')->get();
				$rebate = array();
				$n=0;
				foreach ($company_dis_rabate as  $crebate) {
					$rebate[$n] = $crebate;
					$n++;
				}
				foreach ($warehouse_dis_rabate as  $wrebate) {
					$rebate[$n] = $wrebate;
					$n++;
				}
				$data['rebates'] = $rebate;
			}
		}else{
			$data['rebates'] = [];
		}
		return view('dashboard.report.monthly-rebate-report',$data);
	}
}