/** client.lua (missionSystem)**/

blipsUpToDate = false

RegisterNetEvent('missionSystem:getJobName')
AddEventHandler('missionSystem:getJobName', function(name)

	if(blipHarvest == false) then
		RemoveBlip(blipHarvest)
	end

	if(blipTreatment == false) then
		RemoveBlip(blipTreatment)
	end

	if(blipSell == false) then
		RemoveBlip(blipSell)
	end

	if(qte == "Mineur") then
		blipHarvest = AddBlipForCoord(<X>, <Y>, <Z>)
		SetBlipSprite(blip, <#Sprite>)
		SetBlipAsShortRange(blip, true)

		blipTreatment = AddBlipForCoord(<X>, <Y>, <Z>)
		SetBlipSprite(blip, <#Sprite>)
		SetBlipAsShortRange(blip, true)

		blipSell = AddBlipForCoord(<X>, <Y>, <Z>)
		SetBlipSprite(blip, <#Sprite>)
		SetBlipAsShortRange(blip, true)
	end
end)

RegisterNetEvent('missionSystem:processGetWeed')
AddEventHandler('missionSystem:processGetWeed', function(qte)
	if(qte == nil) then
		qte = 0
	end

    if qte < 30 then
		TriggerEvent('player:receiveItem',1, 1)
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~g~Vous venez de récolter du cannabis.")
		DrawSubtitleTimed(4500, 1)
	else
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~r~Vous ne pouvez pas récolter plus de cannabis!")
		DrawSubtitleTimed(2000, 1)
	end
end)

RegisterNetEvent('missionSystem:processGetShit')
AddEventHandler('missionSystem:processGetShit', function(qteWeed, qteShit)
	if(qteWeed == nil) then
		qteWeed = 0
	end

	if(qteShit == nil) then
		qteShit = 0
	end

    if qteShit < 30 and qteWeed > 0 then
		TriggerEvent('player:receiveItem',2, 1)
		TriggerEvent('player:looseItem',1, 1)
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~g~Vous venez de faire du shit.")
		DrawSubtitleTimed(4500, 1)
	else
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~r~Vous ne pouvez plus transformer de cannabis !")
		DrawSubtitleTimed(2000, 1)
	end
end)

RegisterNetEvent('missionSystem:processSellShit')
AddEventHandler('missionSystem:processSellShit', function(qte)
	if(qte == nil) then
		qte = 0
	end

    if qte > 0 then
		TriggerEvent('player:looseItem',2, 1)
		TriggerServerEvent('mission:completed', 50)
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~g~Vous venez de vendre du shit pour 50€.")
		DrawSubtitleTimed(2000, 1)
	else
		ClearPrints()
		SetTextEntry_2("STRING")
		AddTextComponentString("~r~Vous n'avez pas de shit à vendre!")
		DrawSubtitleTimed(2000, 1)
	end
end)

Citizen.CreateThread(function()
listOn = false
	while true do
		Wait(0)

		if(blipsUpToDate == false) then

			TriggerServerEvent('jobssystem:getJobName')
			blipsUpToDate = true
		end

		-- RECOLTE DE CANABIS - START
		if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), 2208.777,5578.235,53.735, true) <= 10 then
			TriggerServerEvent('missionSystem:getWeed')
			Citizen.Wait(5000)
		end
		-- RECOLTE DE CANABIS - END


		-- RECOLTE DE SHIT - START
		if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), -1103.57861328125,4889.03271484375,216.067886352539, true) <= 5 then
			TriggerServerEvent('missionSystem:getShit')
			Citizen.Wait(5000)
		end

		if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), -1171.8962402344,-1572.1916503906,4.6636219024658, true) <= 5 then
			TriggerServerEvent('missionSystem:sellShit')
			Citizen.Wait(2500)
		end

		-- RECOLTE DE SHIT - END

	end
end)


/** server.lua (Jobs System) **/

require "resources/essentialmode/lib/MySQL"
MySQL:open("localhost", "gta5_gamemode_essential", "root", "")


function nameJob(id)
  local executed_query = MySQL:executeQuery("SELECT * FROM jobs WHERE job_id = '@namejob'", {['@namejob'] = id})
  local result = MySQL:getResults(executed_query, {'job_name'}, "job_id")
  return result[1].job_name
end

function updatejob(player, id)
  local job = id
  MySQL:executeQuery("UPDATE users SET `job`='@value' WHERE identifier = '@identifier'", {['@value'] = job, ['@identifier'] = player})
end

function getPlayerJob(identifier)
  local executed_query = MySQL:executeQuery("SELECT * FROM jobs WHERE identifier = '@identifier'", {['@identifier'] = identifier})
  local result = MySQL:getResults(executed_query, {'job_name'}, "job_id")
  return result[1].job_name
end

RegisterServerEvent('jobssystem:jobs')
AddEventHandler('jobssystem:jobs', function(id)
  TriggerEvent('es:getPlayerFromId', source, function(user)
        local player = user.identifier
        local nameJob = nameJob(id)
        updatejob(player, id)
        TriggerClientEvent("es_freeroam:notify", source, "CHAR_MP_STRIPCLUB_PR", 1, "Mairie", false, "Votre métier est maintenant : ".. nameJob)
  end)
end)

RegisterServerEvent('jobssystem:getJobName')
AddEventHandler('jobssystem:getJobName', function(id)
  TriggerEvent('es:getPlayerFromId', source, function(user)
        local player = user.identifier
        local name = getPlayerJob(player)
        TriggerClientEvent("missionSystem:getJobName", source, name)
  end)
end)