local Tunnel = module("vrp", "lib/Tunnel")
local Proxy = module("vrp", "lib/Proxy")
MySQL = module("vrp_mysql", "MySQL")

vRPclient = Tunnel.getInterface("vRP","vrp_asigurare")
vRPPclient = Tunnel.getInterface("vRP_parking","vrp_asigurare")
vRP = Proxy.getInterface("vRP")

MySQL.createCommand("vRP/iamasinilejucatorului","SELECT * FROM vrp_user_vehicles WHERE user_id = @user_id")
MySQL.createCommand("vRP/asiguraremasinasets","UPDATE vrp_user_vehicles SET asigurare = 'are' WHERE vehicle_plate=@vehicle_plate")


function build_asigurare_menu(source)
	local user_id = vRP.getUserId({source})
	local player = vRP.getUserSource({user_id})
	if user_id ~= nil then
		asiguraremenu = {name="ASIGURARI AUTO",css={top="75px",header_color="rgba(0,200,0,0.75)"}}
		MySQL.query("vRP/iamasinilejucatorului", {user_id = user_id}, function(rows, affected)
			if #rows > 0 then
				for i, v in pairs(rows) do
					local masina = v.numemasina
					local placuta = v.vehicle_plate
					local pret = v.price
					local statusulasigurarii = v.asigurare
					local asigurarepret = pret/10
					local baniplayer = vRP.getMoney({user_id})
					asiguraremenu[masina] = {function(player, choice)
						if (baniplayer >= asigurarepret) then
							if statusulasigurarii == "nu" then
								vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Felicitari , ai cumparat asigurare cu : "..asigurarepret.."$ pentru masina : "..masina.."!"})
								vRP.tryPayment({user_id,asigurarepret})
								MySQL.query("vRP/asiguraremasinasets", {vehicle_plate = placuta})
							else
								vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Masina <font color = 'green'>"..masina.."</font> are deja asigurare!"})
							end
						else
							vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Nu ai suficienti bani pentru a plati asigurarea !"})
						end
						vRP.closeMenu({source,asiguraremenu})
					end, "Placuta : <font color='green'>"..placuta.."</font><br>Pret masina : <font color='green'>"..pret.."$</font><br>Pret : <font color = 'green'>"..asigurarepret.."$"}
				end
				vRP.openMenu({source,asiguraremenu})
			end
		end)
	end
end

RegisterServerEvent('asiguraremeniu')
AddEventHandler('asiguraremeniu', function(plate)
    local user_id = vRP.getUserId({source})
    local player = vRP.getUserSource({user_id})
    build_asigurare_menu(player,choice)
end)

function verificamasinile(source)
	local id = vRP.getUserId({source})
	local player = vRP.getUserSource({id})
	vRP.prompt({player, "USER ID : ", "", function(player, user_id)
		if user_id ~= nil then
			asiguraremenu = {name="ASIGURARI AUTO",css={top="75px",header_color="rgba(0,200,0,0.75)"}}
			MySQL.query("vRP/iamasinilejucatorului", {user_id = user_id}, function(rows, affected)
				if #rows > 0 then
					for i, v in pairs(rows) do
						local masina = v.numemasina
						local placuta = v.vehicle_plate
						local statusasigasd = v.asigurare
						asiguraremenu[masina] = {function(player, choice)
						end, "Placuta : <font color='green'>"..placuta.."</font><br> Are asigurare : <font color = 'green'>"..statusasigasd}
					end
					vRP.openMenu({source,asiguraremenu})
				end
			end)
		end
	end})
end

RegisterCommand("testcomanda", function(source)
	local user_id = vRP.getUserId({source})
	local player = vRP.getUserSource({user_id})
	verificamasinile(source)
end)

local function politieextend(player,choice)
	vRP.buildMenu({"Politie extended", {player = player}, function(menu)
			menu.name = "Politie extended"
			menu.css={top="75px",header_color="rgba(0,200,0,0.75)"}
			menu.onclose = function(player) vRP.closeMenu({player}) end
			menu["Verifica asigurari"] = {function(player, choice)
				verificamasinile(player)
			end, "Verifica asigurarile unui jucator"}
		vRP.openMenu({player,menu})
	end})
end

vRP.registerMenuBuilder({"main", function(add, data)
	local user_id = vRP.getUserId({data.player})
	if user_id ~= nil then
		local choices = {}

		if(vRP.hasPermission({user_id, "police.service"}))then
			choices["Politie extended"] = {politieextend, "Meniu pentru politie <font color='green'>extended</font>"}
		end

	    add(choices)
    end
end})

local function build_menu(source)
	local x, y, z = -35.033771514893,-1113.3518066406,26.422353744507
	local function menu_enter(source,area)
		local user_id = vRP.getUserId({source})
    	if user_id ~= nil then
			asiguraremenu = {name="ASIGURARI AUTO",css={top="75px",header_color="rgba(0,200,0,0.75)"}}
			MySQL.query("vRP/iamasinilejucatorului", {user_id = user_id}, function(rows, affected)
				if #rows > 0 then
					for i, v in pairs(rows) do
						local masina = v.numemasina
						local placuta = v.vehicle_plate
						local pret = v.price
						local statusulasigurarii = v.asigurare
						local asigurarepret = pret/10
						local baniplayer = vRP.getMoney({user_id})
						asiguraremenu[masina] = {function(player, choice)
							if (baniplayer >= asigurarepret) then
								if statusulasigurarii == "nu" then
									vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Felicitari , ai cumparat asigurare cu : "..asigurarepret.."$ pentru masina : "..masina.."!"})
									vRP.tryPayment({user_id,asigurarepret})
									MySQL.query("vRP/asiguraremasinasets", {vehicle_plate = placuta})
								else
									vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Masina <font color = 'green'>"..masina.."</font> are deja asigurare!"})
								end
							else
								vRPclient.notify(player,{"~w~[~g~ASIGURARE~w~] Nu ai suficienti bani pentru a plati asigurarea !"})
							end
							vRP.closeMenu({source,asiguraremenu})
						end, "Placuta : <font color='green'>"..placuta.."</font><br>Pret masina : <font color='green'>"..pret.."$</font><br>Pret : <font color = 'green'>"..asigurarepret.."$"}
					end
					vRP.openMenu({source,asiguraremenu})
				end
			end)
		end
	end
	local function menu_leave(source,area)
		local user_id = vRP.getUserId({source})
		vRP.closeMenu({source})
	end

	vRP.setArea({source,"vRP:Asigurari",x,y,z,2,1.5,menu_enter,menu_leave})
end

AddEventHandler("vRP:playerSpawn",function(user_id, source, first_spawn)
	if first_spawn then
		build_menu(source)
	end
end)

RegisterCommand("alexmihai04esefsdasd", function(source, args)
	build_menu(source)
	vRPclient.notify(source,{"Bravo, Alex :)"})
  end)