/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$platforms = Platform::all();
$platform_levels = PlatformLevel::all();
return view("platform/index")->with('PlatformArray', $platforms)->with('PlatformLevelArray', $platform_levels);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
// $productList = Product::all();
$start_investment_amount = $request->input('start_investment_amount');
$start_investment_amount_value = 0;
switch ($start_investment_amount) {
case '不限':
# code...
break;
case '100以上':
$start_investment_amount_value = 100;
break;
case '500以上':
$start_investment_amount_value = 500;
break;
case '1000以上':
$start_investment_amount_value = 1000;
break;
case '5000以上':
$start_investment_amount_value = 5000;
break;
default:
# code...
break;
}
$rate = $request->input('rate');
$rate_start_value = 0;
$rate_end_value = 100;
switch ($rate) {
case '不限':
# code...
break;
case '5%以下':
$rate_start_value = 0.0;
$rate_end_value = 0.05;
break;
case '5%-10%':
$rate_start_value = 0.05;
$rate_end_value = 0.1;
break;
case '10%以上':
$rate_start_value = 0.1;
$rate_end_value = 100;
break;
default:
# code...
break;
}
$investment_period = $request->input('investment_period');
$investment_period_start_value = 0;
$investment_period_end_value = 1000000000;
switch ($investment_period) {
case '不限':
# code...
break;
case '1周以内':
$investment_period_start_value = 0;
$investment_period_end_value = 7;
break;
case '1个月以内':
$investment_period_start_value = 0;
$investment_period_end_value = 31;
break;
case '1-3个月':
$investment_period_start_value = 30;
$investment_period_end_value = 91;
break;
case '3-6个月':
$investment_period_start_value = 90;
$investment_period_end_value = 181;
break;
case '6-12个月':
$investment_period_start_value = 180;
$investment_period_end_value = 365;
break;
case '1年以上':
$investment_period_start_value = 360;
$investment_period_end_value = 1000000000;
break;
default:
# code...
break;
}
$platform_grade = $request->input('platform_grade');
$productList = \DB::table('platforms')->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
// $productList = \DB::table('platforms')->leftJoin('products', 'platforms.id', '=', 'products.platform_id')
// ->where('start_investment_amount','>=',$start_investment_amount_value)
// ->where('rate','>=',$rate_start_value)->where('rate','<',$rate_end_value)
// ->where('investment_period','>=',$investment_period_start_value)->where('investment_period','<=',$investment_period_end_value)->get();
switch ($platform_grade) {
case '不限':
# code...
break;
case 'A++':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'A++');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
case 'A+':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'A+');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
case 'A':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'A');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
case 'B++':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'B++');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
case 'B+':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'B+');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
case 'B':
$productList = Platform::whereHas('platform_levels', function ($q) {
$q->where('grade_value', 'like', 'B');
})->leftJoin('products', 'platforms.id', '=', 'products.platform_id')->where('start_investment_amount', '>=', $start_investment_amount_value)->where('rate', '>=', $rate_start_value)->where('rate', '<', $rate_end_value)->where('investment_period', '>=', $investment_period_start_value)->where('investment_period', '<=', $investment_period_end_value)->get();
break;
default:
# code...
break;
}
return view('productions/index')->with('productList', $productList);
}