/api/app/Http/Controllers/Api/APIBikeCompareListController.php

<?php
namespace App\Http\Controllers\Api;

use App\library\PermissionController;
use DB;
use Illuminate\Http\Request;
use JWTAuth;

class APIBikeCompareListController extends Controller
{

    protected $getPermissionVal;
    public $userDetails;
    public $encryption_enable;
    public function __construct()
    {
        $this->middleware(function ($request, $next) {
            $this->userDetails = JWTAuth::parseToken()->toUser();
            $chkPagePermission = new PermissionController;
            $this->getPermissionVal = $chkPagePermission->chkUserPagePermission('', '', $this->userDetails);
            return $next($request);
        });
        $this->encryption_enable = trans('lang.Is_encryption_enable');
    }

    public function bikecompareList(Request $request)
    {
        try {
            $getPermissionVal = $this->getPermissionVal;
            if ($this->getPermissionVal['view'] == 0) {
                if ($this->encryption_enable == 1) {
                    return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.view_denied'), 'user_id' => 0, 'error_code' => 500]));
                } else {
                    return response()->json(['status' => 0, 'message' => trans('lang.view_denied'), 'user_id' => 0], 500);
                }

                exit;
            }
            $auth_user = JWTAuth::parseToken()->authenticate();

            $status = 0;
            $bikecomID = 0;
            $brandId = 0;
            $modelId = 0;
            $cbrandId = 0;
            $cmodelId = 0;
            $StatusVal = 0;
            $Is_Deleted = 0;
            $Created_on = date("Y-m-d h:i:s");
            $Created_by = $auth_user->id;
            $Updated_on = date("Y-m-d h:i:s");
            $Updated_by = $auth_user->id;
            $bike_list_results = DB::select('CALL compareBike(?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
                array(
                    'View', $brandId, $modelId, $cbrandId, $cmodelId, $StatusVal, $Is_Deleted, $Created_by, $Created_on, $Updated_by, $Updated_on, $bikecomID, 1, @res,
                )
            );
            if ($this->encryption_enable == 1) {
                return CryptoJSAesEncrypt(json_encode(['status' => 1, 'message' => trans('lang.success'), 'result' => $bike_list_results]));
            } else {
                return response()->json(['status' => 1, 'message' => trans('lang.success'), 'result' => $bike_list_results], 200);
            }

        } catch (\Illuminate\Database\QueryException $ex) {
            if ($this->encryption_enable == 1) {
                return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()]));
            } else {
                return response()->json(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()], 500);
            }

        }

    }


    public function bikecompareAdd(){
        try{ 
            $getPermissionVal = $this->getPermissionVal;
            if ($this->getPermissionVal['view'] == 0) {
                if ($this->encryption_enable == 1) {
                    return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.add_denied'), 'user_id' => 0, 'error_code' => 500]));
                } else {
                    return response()->json(['status' => 0, 'message' => trans('lang.add_denied'), 'user_id' => 0], 500);
                }

                exit;
            }
            $inputs = file_get_contents("php://input");
            if ($this->encryption_enable == 1) {
                $decrypted_data = CryptoJSAesDecrypt($inputs);
                $data = json_decode($decrypted_data);
            } else {
                $data = json_decode($inputs);
            }
 
            $status = 0;
            $Is_Deleted = 0;
            $redMsg = "";
            $returnVal = "";
            $auth_user = JWTAuth::parseToken()->authenticate();
            $user_id = $auth_user->id;
            $Created_on = date("Y-m-d h:i:s");
            $Created_by = $auth_user->id;
            $Updated_on = date("Y-m-d h:i:s");
            $Updated_by = $auth_user->id;
            //echo "<pre>";print_r($data);exit;
            if(isset($data->vehicleType) && isset($data->brandId) && isset($data->modelId) && isset($data->cbrandId) && isset($data->cmodelId) && isset($data->cstatus)){
                $bikecomID = 0;
                $vehicleType = $data->vehicleType;
                $brandId = $data->brandId;
                $modelId = $data->modelId;
                $cBrandId = $data->cbrandId;
                $cModelId = $data->cmodelId;
                $StatusVal = $data->cstatus;
                if($brandId > 0 && $modelId > 0 && $cBrandId > 0 && $cModelId > 0){
                    $results = DB::select('CALL compareBike(?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
                        array(
                            'ADD', $brandId, $modelId, $cBrandId, $cModelId, $StatusVal, $Is_Deleted, $Created_by, $Created_on, $Updated_by, $Updated_on, $bikecomID, $vehicleType, @res,
                        )
                    );
                    if(count($results) > 0){
                        $returnVal = isset($results[0]->result) ? $results[0]->result : "";
                        if($returnVal == 0){
                            $redMsg = trans('lang.bike_compare_model_exists');
                        }
                        elseif($returnVal > 0){
                            $status = 1;
                            $redMsg = trans('lang.success');
                        }
                        else{
                            $redMsg = trans('lang.try_again');
                        }
                    }else{
                        $status = 0;
                        $redMsg = trans('lang.try_again');
                    }
                }
                else{
                    $redMsg = trans('lang.Empty_fields');
                }
            }
            else{
                $redMsg = trans('lang.try_again');
            }
        }
        catch (\Illuminate\Database\QueryException $ex) {
            if ($this->encryption_enable == 1) {
                return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()]));
            } else {
                return response()->json(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()], 500);
            }
        }
        if ($this->encryption_enable == 1) {
            return CryptoJSAesEncrypt(json_encode(['status' => $status, 'message' => $redMsg, 'result' => $returnVal]));
        } else {
            return response()->json(['status' => $status, 'message' => $redMsg, 'result' => $returnVal], 200);
        }
    }


    public function bikecompareUpdate(){
        try{
            $getPermissionVal = $this->getPermissionVal;
            if ($this->getPermissionVal['view'] == 0) {
                if ($this->encryption_enable == 1) {
                    return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.edit_denied'), 'user_id' => 0, 'error_code' => 500]));
                } else {
                    return response()->json(['status' => 0, 'message' => trans('lang.edit_denied'), 'user_id' => 0], 500);
                }

                exit;
            }
            $inputs = file_get_contents("php://input");
            if ($this->encryption_enable == 1) {
                $decrypted_data = CryptoJSAesDecrypt($inputs);
                $data = json_decode($decrypted_data);
            } else {
                $data = json_decode($inputs);
            }
            $status = 0;
            $Is_Deleted = 0;
            $redMsg = "";
            $returnVal = "";
            $auth_user = JWTAuth::parseToken()->authenticate();
            $user_id = $auth_user->id;
            $Created_on = date("Y-m-d h:i:s");
            $Created_by = $auth_user->id;
            $Updated_on = date("Y-m-d h:i:s");
            $Updated_by = $auth_user->id;
            //echo "<pre>";print_r($data);exit;
            if(isset($data->vehicleType) && isset($data->bikecomID) && isset($data->brandId) && isset($data->modelId) && isset($data->cbrandId) && isset($data->cmodelId) && isset($data->cstatus)){
                $vehicleType = $data->vehicleType;
                $bikecomID = $data->bikecomID;
                $brandId = $data->brandId;
                $modelId = $data->modelId;
                $cBrandId = $data->cbrandId;
                $cModelId = $data->cmodelId;
                $StatusVal = $data->cstatus;
                if($brandId > 0 && $modelId > 0 && $cBrandId > 0 && $cModelId > 0){
                    $results = DB::select('CALL compareBike(?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
                        array(
                            'UPDATES', $brandId, $modelId, $cBrandId, $cModelId, $StatusVal, $Is_Deleted, $Created_by, $Created_on, $Updated_by, $Updated_on, $bikecomID, $vehicleType, @res,
                        )
                    );
                    if(count($results) > 0){
                        $returnVal = isset($results[0]->result) ? $results[0]->result : "";
                        if($returnVal == 0){
                            $redMsg = trans('lang.bike_compare_model_exists');
                        }
                        elseif($returnVal > 0){
                            $status = 1;
                            $redMsg = trans('lang.success');
                        }
                        else{
                            $redMsg = trans('lang.try_again');
                        }
                    }else{
                        $status = 0;
                        $redMsg = trans('lang.try_again');
                    }
                }
                else{
                    $redMsg = trans('lang.Empty_fields');
                }
            }
            else{
                $redMsg = trans('lang.try_again');
            }
        }
        catch (\Illuminate\Database\QueryException $ex) {
            if ($this->encryption_enable == 1) {
                return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()]));
            } else {
                return response()->json(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()], 500);
            }
        }
        if ($this->encryption_enable == 1) {
            return CryptoJSAesEncrypt(json_encode(['status' => $status, 'message' => $redMsg, 'result' => ""]));
        } else {
            return response()->json(['status' => $status, 'message' => $redMsg, 'result' => ""], 200);
        }
    }


    public function bikecompareDelete(){
        try{
            $getPermissionVal = $this->getPermissionVal;
            if ($this->getPermissionVal['view'] == 0) {
                if ($this->encryption_enable == 1) {
                    return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.edit_denied'), 'user_id' => 0, 'error_code' => 500]));
                } else {
                    return response()->json(['status' => 0, 'message' => trans('lang.edit_denied'), 'user_id' => 0], 500);
                }

                exit;
            }
            $inputs = file_get_contents("php://input");
            if ($this->encryption_enable == 1) {
                $decrypted_data = CryptoJSAesDecrypt($inputs);
                $data = json_decode($decrypted_data);
            } else {
                $data = json_decode($inputs);
            }
            $status = 0;
            $Is_Deleted = 0;
            $redMsg = "";
            $returnVal = "";
            $auth_user = JWTAuth::parseToken()->authenticate();
            $user_id = $auth_user->id;
            $Created_on = date("Y-m-d h:i:s");
            $Created_by = $auth_user->id;
            $Updated_on = date("Y-m-d h:i:s");
            $Updated_by = $auth_user->id;
            $StatusVal = 0;
            $Is_Deleted = 0;
            if(isset($data->bikecomID) && $data->bikecomID > 0){
                $bikecomID = $data->bikecomID;
                $results = DB::select('CALL compareBike(?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
                    array(
                        'Deleted', 0, 0, 0, 0, $StatusVal, $Is_Deleted, $Created_by, $Created_on, $Updated_by, $Updated_on, $bikecomID, 1, @res,
                    )
                );
                $status = 1;
                $redMsg = trans('lang.success');
            }
            else{
                $redMsg = trans('lang.Invalid_input');
            }
        }
        catch (\Illuminate\Database\QueryException $ex) {
            if ($this->encryption_enable == 1) {
                return CryptoJSAesEncrypt(json_encode(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()]));
            } else {
                return response()->json(['status' => 0, 'message' => trans('lang.try_again'), 'result' => "", 'error_code' => $ex->getMessage()], 500);
            }
        }
        if ($this->encryption_enable == 1) {
            return CryptoJSAesEncrypt(json_encode(['status' => $status, 'message' => $redMsg, 'result' => ""]));
        } else {
            return response()->json(['status' => $status, 'message' => $redMsg, 'result' => ""], 200);
        }
    }
}