/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
//$sales = Sale::with ( 'user', 'country' )->orderBy ( 'id', 'desc' )->get ();
$sales = Sale::with('user', 'country', 'values')->orderBy('id', 'desc');
$flag = 0;
$arr_Request = [];
if ($request['user_id'] != null) {
$arr_Request['user_id'] = $request['user_id'];
$flag = 1;
$sales = $sales->where('user_id', $arr_Request['user_id']);
} else {
$arr_Request['user_id'] = null;
}
if ($request['customer_name'] != null) {
$arr_Request['customer_name'] = $request['customer_name'];
$sales = $sales->where('customer_name', $arr_Request['customer_name']);
$flag = 1;
} else {
$arr_Request['customer_name'] = null;
}
if ($request['country_id'] != null) {
$arr_Request['country_id'] = $request['country_id'];
$sales = $sales->where('country_id', $arr_Request['country_id']);
$flag = 1;
} else {
$arr_Request['country_id'] = null;
}
if ($request['region'] != null) {
$arr_Request['region'] = $request['region'];
$sales = $sales->where('region', $arr_Request['region']);
$flag = 1;
} else {
$arr_Request['region'] = null;
}
if ($request['vertical'] != null) {
$arr_Request['vertical'] = $request['vertical'];
$sales = $sales->where('vertical', $arr_Request['vertical']);
$flag = 1;
} else {
$arr_Request['vertical'] = null;
}
if ($request['delivery_location'] != null) {
$arr_Request['delivery_location'] = $request['delivery_location'];
$sales = $sales->where('delivery_location', $arr_Request['delivery_location']);
$flag = 1;
} else {
$arr_Request['delivery_location'] = null;
}
if ($request['engagement'] != null) {
$arr_Request['engagement'] = $request['engagement'];
$sales = $sales->where('engagement', $arr_Request['engagement']);
$flag = 1;
} else {
$arr_Request['engagement'] = null;
}
if ($request['service'] != null) {
$arr_Request['service'] = $request['service'];
$sales = $sales->where('service', $arr_Request['service']);
$flag = 1;
} else {
$arr_Request['service'] = null;
}
$currentYear = date("Y");
if ($request['year'] != null) {
$arr_Request['year'] = $request['year'];
$currentYear = $arr_Request['year'];
$flag = 1;
} else {
$arr_Request['year'] = null;
}
if ($request['q'] != null) {
$arr_Request['q'] = $request['q'];
} else {
$arr_Request['q'] = null;
}
$arr_Request['flag'] = $flag;
$years = Sale::getYear();
$sales = $sales->get();
$totals = [];
$hc1 = $hc2 = $hc3 = $hc4 = $hc5 = $hc6 = $hc7 = $hc8 = $hc9 = $hc10 = $hc11 = $hc12 = 0;
$v1 = $v2 = $v3 = $v4 = $v5 = $v6 = $v7 = $v8 = $v9 = $v10 = $v11 = $v12 = 0;
$total_hc = 0;
$total_value = 0;
foreach ($sales as $key => $sale) {
$total_hc += $sale->head_count;
$total_value += $sale->value;
$value = [];
if ($request['q'] != null && $request['q'] == 'full') {
$value = Sale::makeFullValue($sale, $currentYear);
} elseif ($request['q'] != null && $request['q'] == 'weighted') {
$value = Sale::makeWeightedValue($sale, $currentYear);
} else {
$value = Sale::makeFullValue($sale, $currentYear);
}
$total_val_hc = $total_val_value = 0;
foreach ($value as $val) {
$total_val_hc += $val['hc'];
$total_val_value += $val['value'];
}
if ($total_val_hc == 0 && $total_val_value == 0) {
unset($sales[$key]);
$sale->success = false;
}
$sale->months = $value;
$hc1 += $sale->months[0]['hc'];
$hc2 += $sale->months[1]['hc'];
$hc3 += $sale->months[2]['hc'];
$hc4 += $sale->months[3]['hc'];
$hc5 += $sale->months[4]['hc'];
$hc6 += $sale->months[5]['hc'];
$hc7 += $sale->months[6]['hc'];
$hc8 += $sale->months[7]['hc'];
$hc9 += $sale->months[8]['hc'];
$hc10 += $sale->months[9]['hc'];
$hc11 += $sale->months[10]['hc'];
$hc12 += $sale->months[11]['hc'];
$v1 += $sale->months[0]['value'];
$v2 += $sale->months[1]['value'];
$v3 += $sale->months[2]['value'];
$v4 += $sale->months[3]['value'];
$v5 += $sale->months[4]['value'];
$v6 += $sale->months[5]['value'];
$v7 += $sale->months[6]['value'];
$v8 += $sale->months[7]['value'];
$v9 += $sale->months[8]['value'];
$v10 += $sale->months[9]['value'];
$v11 += $sale->months[10]['value'];
$v12 += $sale->months[11]['value'];
}
array_push($totals, array('hc' => $hc1, 'value' => $v1));
array_push($totals, array('hc' => $hc2, 'value' => $v2));
array_push($totals, array('hc' => $hc3, 'value' => $v3));
array_push($totals, array('hc' => $hc4, 'value' => $v4));
array_push($totals, array('hc' => $hc5, 'value' => $v5));
array_push($totals, array('hc' => $hc6, 'value' => $v6));
array_push($totals, array('hc' => $hc7, 'value' => $v7));
array_push($totals, array('hc' => $hc8, 'value' => $v8));
array_push($totals, array('hc' => $hc9, 'value' => $v9));
array_push($totals, array('hc' => $hc10, 'value' => $v10));
array_push($totals, array('hc' => $hc11, 'value' => $v11));
array_push($totals, array('hc' => $hc12, 'value' => $v12));
$users = User::all();
$countries = Country::all();
$customerNames = Sale::getCustomerName();
return view('fulls.index')->with('sales', $sales)->with('totals', $totals)->with('years', $years)->with('users', $users)->with('countries', $countries)->with('arr_Request', $arr_Request)->with('customerNames', $customerNames)->with('total_hc', $total_hc)->with('total_value', $total_value);
}