<?php

namespace App\Http\Controllers\Api;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use DB;
use Validator;

class Version1 extends Controller
{
    function user_registration(Request $request)
    {
		$base_url = getenv('APP_URL');
		$fb_id = $request->get('fb_id');
		$reg_with = $request->get('reg_with');
        $profile = $request->file('profile');
		$email = $request->get('email');
        $img_data = '';
		//echo $email;die;
        $checkData = DB::table('tbl_users')->where('user_email',$email)->first();
		//print_r($checkData);die;
        $CheckUserData = json_decode(json_encode($checkData), True);
        if(empty($CheckUserData))
        {
            if(!empty($profile) || $profile != '')
            {
                $img_data = time(). rand() .'.'.$profile->getClientOriginalExtension();
                $destination_path = public_path() ."/user-profile/";
                $profile->move($destination_path, $img_data);
            }
            $arr_user_registration = array("user_first_name" => $request->get('first_name'),
            								"user_last_name" => $request->get('last_name'),
            								"user_email" => $request->get('email'),
            								"user_password" => md5($request->get('password')),
            								"user_dob" => $request->get('dob'),
                                            "gender" => $request->get('gender'),
            								"user_country" => $request->get('country'),
            								"user_state" => $request->get('state'),
            								"user_city" => $request->get('city'),
                                            "user_profile" => $img_data,
											"user_fb_appid" => $fb_id,
											"reg_with" => $reg_with,
            								"created_date" => time()
        								);
            $user_reg = DB::table('tbl_users')->insert($arr_user_registration);
            $id = DB::getPdo()->lastInsertId();
            $userdata = DB::table('tbl_users')->where('user_id',$id)->first();
            $users = json_decode(json_encode($userdata), True);
            $userDetails = array();
            if(!empty($users))
            {
                $userDetails['user_id'] = $id;
                $userDetails['user_first_name'] = $users['user_first_name'];
                $userDetails['user_last_name'] = $users['user_last_name'];
                $userDetails['user_email'] = $users['user_email'];
                $userDetails['user_password'] = $users['user_password'];
                $userDetails['user_dob'] = $users['user_dob'];
                $userDetails['user_country'] = $users['user_country'];
                $userDetails['user_state'] = $users['user_state'];
                $userDetails['user_city'] = $users['user_city'];
                $userDetails['gender'] = $users['gender'];
                $userDetails['user_profile'] = $base_url."public/user-profile/".$users['user_profile'];
                $userDetails['user_fb_appid'] = $users['user_fb_appid'];
                $userDetails['reg_with'] = $users['reg_with'];
            }
            if(!empty($userDetails)){
            return response()->json(['status' => 1, 'msg' => 'User Created Successfully.', 'data' => $userDetails], 200);
            }else{
                return response()->json(['status' => 0, 'msg' => 'Something Went Wrong.', 'data' => null], 200);
            }
        }
        else
        {
            return response()->json(['status' => 0, 'msg' => 'Email is already Exist.', 'data' => null], 200);
        }

    }
    function apply_list(Request $request)
    {
    	$user_id = $request->get('user_id');
    	$category = $request->get('category');
    	$cat = explode(',',$category);

        if(!empty($category))
        {
    		$img_name = '';
    		if ($request->hasFile('image')) {
    			 $image = $request->file('image');
    			 $img_name = $input['imagename'] = time().'.'.$image->getClientOriginalExtension();
    			 $destinationPath = public_path('/question-images');
    			 $image->move($destinationPath, $input['imagename']);
    		}

            $category = $request->get('category');
            $dj_question1 = $request->get('dj_question1');
    		$dj_question2 = $request->get('dj_question2');
            $fan_question1 = $request->get('fan_question1');
            $pr_question1 = $request->get('pr_question1');
            $pr_question2 = $request->get('pr_question2');
            $pr_question3 = $request->get('pr_question3');
            $artist_question1 = $request->get('artist_question1');
            $artist_question2 = $request->get('artist_question2');
            $ind_question1 = $request->get('ind_question1');
            $ind_question2 = $request->get('ind_question2');
            $ind_question3 = $request->get('ind_question3');
            $arr_question = array("categories" => $category,
                            "dj_question1" => $dj_question1,
    						"dj_image" => $img_name,
    						"dj_question2" => $dj_question2,
    						"user_id" => $user_id,
                            "fan_question1" => $fan_question1,
                            "producer_question1" => $pr_question1,
                            "producer_question2" => $pr_question2,
                            "producer_question3" => $pr_question3,
                            "recording_question1" => $artist_question1,
                            "recording_question2" => $artist_question2,
                            "industry_question1" => $ind_question1,
                            "industry_question2" => $ind_question2,
                            "industry_question3" => $ind_question3,
                            "created_date" => time()
    					);
        DB::table('tbl_questions_list')->insert($arr_question);
        return response()->json(['status' => 1, 'msg' => 'Question List added Successfully..', 'data' => null], 200);
        }else{
            return response()->json(['status' => 0, 'msg' => 'Something Went Wrong.', 'data' => null], 200);
        }
    }

	function login(Request $request)
	{
		$base_url = getenv('APP_URL');
		$email = $request->get('email');
		$password = md5($request->get('password'));

		$userCheck = DB::table('tbl_users')->where('user_email',$email)->where('user_password',$password)->first();
		$users = json_decode(json_encode($userCheck), True);
		if(!empty($users))
		{
            $public_path = public_path();
			$userdata = DB::table('tbl_users')->where('user_id',$users['user_id'])->first();
			$list_userDetails = json_decode(json_encode($userdata), True);
			$userDetails['user_id'] = $list_userDetails['user_id'];
			$userDetails['user_first_name'] = $list_userDetails['user_first_name'];
			$userDetails['user_last_name'] = $list_userDetails['user_last_name'];
			$userDetails['user_email'] = $list_userDetails['user_email'];
			$userDetails['user_password'] = $list_userDetails['user_password'];
			$userDetails['user_dob'] = $list_userDetails['user_dob'];
			$userDetails['user_country'] = $list_userDetails['user_country'];
			$userDetails['user_state'] = $list_userDetails['user_state'];
			$userDetails['user_city'] = $list_userDetails['user_city'];
			$userDetails['gender'] = $list_userDetails['gender'];
			$userDetails['user_profile'] = $base_url."public/user-profile/".$list_userDetails['user_profile'];
			$userDetails['user_fb_appid'] = $list_userDetails['user_fb_appid'];
			$userDetails['reg_with'] = $list_userDetails['reg_with'];
			return response()->json(['status' => 1, 'msg' => 'Login Successfull..', 'data' => $userDetails], 200);
		}
		else{
			return response()->json(['status' => 0, 'msg' => "Email and Password doesn't match.", 'data' => null], 200);
		}
	}

    function check_user(Request $request)
    {
		$base_url = getenv('APP_URL');
        $email = $request->get('email');
        $fb_id = $request->get('fb_id');

        $userCheck__ = DB::select("SELECT * FROM tbl_users WHERE user_email = '$email' OR user_fb_appid = '$fb_id'");
		$getuser = json_decode(json_encode($userCheck__), True);
        if(!empty($getuser))
        {
			$userCheck = DB::table('tbl_users')->where('user_id',$getuser[0]['user_id'])->first();
			$users = json_decode(json_encode($userCheck), True);
			if(!empty($users))
			{
				$public_path = public_path();
				$userdata = DB::table('tbl_users')->where('user_id',$users['user_id'])->first();
				$list_userDetails = json_decode(json_encode($userdata), True);
				$userDetails['user_id'] = $list_userDetails['user_id'];
				$userDetails['user_first_name'] = $list_userDetails['user_first_name'];
				$userDetails['user_last_name'] = $list_userDetails['user_last_name'];
				$userDetails['user_email'] = $list_userDetails['user_email'];
				$userDetails['user_password'] = $list_userDetails['user_password'];
				$userDetails['user_dob'] = $list_userDetails['user_dob'];
				$userDetails['user_country'] = $list_userDetails['user_country'];
				$userDetails['user_state'] = $list_userDetails['user_state'];
				$userDetails['user_city'] = $list_userDetails['user_city'];
				$userDetails['gender'] = $list_userDetails['gender'];
				$userDetails['user_profile'] = $base_url."public/user-profile/".$list_userDetails['user_profile'];
				$userDetails['user_fb_appid'] = $list_userDetails['user_fb_appid'];
				$userDetails['reg_with'] = $list_userDetails['reg_with'];
				return response()->json(['status' => 1, 'msg' => 'User Exist..', 'data' => $userDetails], 200);
			}
        }
        else
        {
            return response()->json(['status' => 0, 'msg' => 'User not Exist. Please fill Userdata First.'], 200);
        }
    }
}