server.lua

local players = {}
local playernames = {}
ESX = exports['es_extended']:getSharedObject()
local loaded = false
local jobtable = {}
playerinfo = {}
GlobalState.Turfs = json.decode(GetResourceKvpString('Turfs') or '[]') or {}
GlobalState.OngoingTurfwar = {}
lib.callback.register('renzu_jobs:getConfig', function(source)
    return config
end)

CreateThread(function()
    Wait(200)
    local registeredjobs = {}
    playerinfo = SqlFunc(config.Mysql,'fetchAll','SELECT identifier,job,firstname,lastname,job_grade FROM users', {})
    jobsclass = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM job_grades', {})
    existing = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs', {})
    
    for k,v in pairs(jobsclass) do
        if jobtable[v.job_name] == nil then jobtable[v.job_name] = {} end
        if jobtable[v.job_name][tostring(v.grade)] == nil then jobtable[v.job_name][tostring(v.grade)] = v.label end
    end
    for k,v in pairs(existing) do
        registeredjobs[v.name] = v
    end
    for k,v in pairs(config.Jobs) do
        if registeredjobs[k] == nil then
            SqlFunc(config.Mysql,'execute','INSERT INTO renzu_jobs (name, accounts, inventory, garage) VALUES (@name, @accounts, @inventory, @garage)', {
                ['@name']   = k,
                ['@accounts']   = json.encode({money = 0, black_money = 0}),
                ['@inventory']   = '[]',
                ['@garage'] = '[]'
            })
        end
    end
    loaded = true
    print("Renzu Jobs LOADED")
end)

-- Register this stash only when this event is called
lib.callback.register('renzu_jobs:AddStash', function(source, job, type, inventory)
    local xPlayer = GetPlayerFromId(source)
    local name = type
    local id = type
    if inventory ~= 'public_inventory' then
        if type == 'Personal' then
            type = xPlayer.identifier
            name = ''..job..'_'..type..''
        else
            id = ''..job..'_'..type..''
        end
    end
	return exports.ox_inventory:RegisterStash(id, name, 70, 1000000, type == 'Personal' and true or false)
end)

function JobMoney(job,paycheck)
    if paycheck and config.FreePaycheck[job] then return {money=99999999,black_money=99999999} end
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    if result[1] then
        local ret = json.decode(result[1].accounts) or {}
        return ret or {money=0,black_money=0}
    else
        return {money=0,black_money=0}
    end
    return {money=0,black_money=0}
end

function removeMoney(amount,job,source,money_type,export,paycheck)
    if paycheck then return end
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    if result[1] then
        local jobaccount = json.decode(result[1].accounts) or {}
        jobaccount[money_type] = tonumber(jobaccount[money_type]) - tonumber(amount)
        SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET accounts = @accounts WHERE name = @name', {
            ['@name'] = job,
            ['@accounts'] = json.encode(jobaccount)
        })
        if not export then
            TriggerClientEvent('renzu_jobs:updatemoney',source,jobaccount)
        end
    end
end

function addMoney(amount,job,source,money_type,export)
    
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    local jobaccount = json.decode(result[1].accounts) or {}
    jobaccount[money_type] = tonumber(jobaccount[money_type]) + tonumber(amount)
    SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET accounts = @accounts WHERE name = @name', {
        ['@name'] = job,
        ['@accounts'] = json.encode(jobaccount)
    })
    if not export then
        TriggerClientEvent('renzu_jobs:updatemoney',source,jobaccount)
    end
end

exports('JobMoney', function(job,paycheck)
    return JobMoney(job,paycheck)
end)

exports('addMoney', function(amount,job,source,money_type,e)
    return addMoney(amount,job,source,money_type,e)
end)

exports('removeMoney', function(amount,job,source,money_type,e,paycheck)
    return removeMoney(amount,job,source,money_type,e,paycheck)
end)

function addItem(job,item,amount,source,type,xPlayer)
    
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    local inventory = json.decode(result[1].inventory) or {}
    local slots = config.Jobs[job]['inventory'][type].slots
    local foundslot = false
    if inventory[type] == nil then inventory[type] = {} end
    if type == 'Personal' then
        if inventory[type][xPlayer.identifier] == nil then inventory[type][xPlayer.identifier] = {} end
        if not string.find(item:upper(), "WEAPON_") then -- only items that supports multiple amount
            for i=1, slots, 1 do
                local i = tostring(i)
                if inventory[type][xPlayer.identifier][i] ~= nil then  -- checking if slot is not nil
                    if inventory[type][xPlayer.identifier][i][item] ~= nil then -- checking if item is already in slot
                        foundslot = true -- ignore more condition checks below and save to SqlFunc
                        inventory[type][xPlayer.identifier][i][item] = inventory[type][xPlayer.identifier][i][item] + tonumber(amount)
                        break
                    end
                end
            end
        end
        if not foundslot then -- if no slot has been found
            for i=1, slots, 1 do
                local i = tostring(i)
                if inventory[type][xPlayer.identifier][i] == nil then -- create new slot specially dedicated for weapons ( to support multiple the same weapons in inventory )
                    inventory[type][xPlayer.identifier][i] = {} 
                    if string.find(item:upper(), "WEAPON_") then -- weapon condition to save components
                        if inventory[type][xPlayer.identifier][i][item] == nil then 
                            inventory[type][xPlayer.identifier][i][item] = {}
                            inventory[type][xPlayer.identifier][i][item]['data'] = {}
                            inventory[type][xPlayer.identifier][i][item]['data'].ammo = 0
                            local loadoutNum, weapon = xPlayer.getWeapon(item)
                            inventory[type][xPlayer.identifier][i][item]['data'].components = xPlayer.loadout[loadoutNum].components
                        end
                        inventory[type][xPlayer.identifier][i][item]['data'].ammo = tonumber(inventory[type][xPlayer.identifier][i][item]['data'].ammo) + tonumber(amount)
                        break
                    else -- else just add new slot and create new item
                        if inventory[type][xPlayer.identifier][i][item] == nil then 
                            inventory[type][xPlayer.identifier][i][item] = 0 
                        end
                        inventory[type][xPlayer.identifier][i][item] = tonumber(inventory[type][xPlayer.identifier][i][item]) + tonumber(amount)
                        break
                    end
                end
            end
        end
    else
        if not string.find(item:upper(), "WEAPON_") then
            for i=1, slots, 1 do
                local i = tostring(i)
                if inventory[type][i] ~= nil then 
                    if inventory[type][i][item] ~= nil then
                        foundslot = true
                        inventory[type][i][item] = inventory[type][i][item] + tonumber(amount)
                    end
                end
            end
        end
        if not foundslot then
            for i=1, slots, 1 do
                local i = tostring(i)
                if inventory[type][i] == nil then 
                    inventory[type][i] = {} 
                    if string.find(item:upper(), "WEAPON_") then -- weapon condition to save components
                        if inventory[type][i][item] == nil then 
                            inventory[type][i][item] = {}
                            inventory[type][i][item]['data'] = {}
                            inventory[type][i][item]['data'].ammo = 0
                            local loadoutNum, weapon = xPlayer.getWeapon(item)
                            inventory[type][i][item]['data'].components = xPlayer.loadout[loadoutNum].components
                        end
                        inventory[type][i][item]['data'].ammo = tonumber(inventory[type][i][item]['data'].ammo) + tonumber(amount)
                        break
                    else -- else just add new slot and create new item
                        if inventory[type][i][item] == nil then 
                            inventory[type][i][item] = 0 
                        end
                        inventory[type][i][item] = tonumber(inventory[type][i][item]) + tonumber(amount)
                        break
                    end
                end
            end
        end
    end
    SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET inventory = @inventory WHERE name = @name', {
        ['@name'] = job,
        ['@inventory'] = json.encode(inventory)
    })
end

function removeItem(job,item,amount,source,type,xPlayer,slot)
    
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    local inventory = json.decode(result[1].inventory) or {}
    if type == 'Personal' then
        if string.find(item:upper(), "WEAPON_") then
            inventory[type][xPlayer.identifier][slot] = nil
        else
            inventory[type][xPlayer.identifier][slot][item] = tonumber(inventory[type][xPlayer.identifier][slot][item]) - tonumber(amount)
            if inventory[type][xPlayer.identifier][slot][item] <= 0 then
                inventory[type][xPlayer.identifier][slot] = nil
            end
        end
    else
        if string.find(item:upper(), "WEAPON_") then
            inventory[type][slot] = nil
        else
            inventory[type][slot][item] = tonumber(inventory[type][slot][item]) - tonumber(amount)
            if inventory[type][slot][item] <= 0 then
                inventory[type][slot] = nil
            end
        end
    end
    SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET inventory = @inventory WHERE name = @name', {
        ['@name'] = job,
        ['@inventory'] = json.encode(inventory)
    })
end

function GetItems(job,type,xPlayer)
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {['@name'] = job})
    local inventory = json.decode(result[1].inventory) or {}
    if inventory[type] == nil then inventory[type] = {} end
    if type == 'Personal' then
        if inventory[type][xPlayer.identifier] == nil then inventory[type][xPlayer.identifier] = {} end
        inventory = inventory[type][xPlayer.identifier]
    else
        inventory = inventory[type]
    end
    return inventory
end

function SaveClothes(clothename,clothe,xPlayer)
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM saveclothes WHERE identifier = @identifier', {['@identifier'] = xPlayer.identifier})
    if result[1] == nil then -- save new wardrobe to db
        local wardrobe = {}
        wardrobe[clothename] = clothe
        SqlFunc(config.Mysql,'execute','INSERT INTO saveclothes (identifier, wardrobe) VALUES (@identifier, @wardrobe)', {
            ['@identifier']   = xPlayer.identifier,
            ['@wardrobe']   = json.encode(wardrobe)
        })
    elseif result[1] then -- replace existing or save new
        
        local wardrobe = json.decode(result[1].wardrobe) or {}
        
        wardrobe[clothename] = clothe
        SqlFunc(config.Mysql,'execute','UPDATE saveclothes SET wardrobe = @wardrobe WHERE identifier = @identifier', {
            ['@identifier'] = xPlayer.identifier,
            ['@wardrobe'] = json.encode(wardrobe)
        })
    end
    -- save skin
    SqlFunc(config.Mysql,'execute','UPDATE users SET skin = @skin WHERE identifier = @identifier', {
		['@skin'] = json.encode(clothe),
		['@identifier'] = xPlayer.identifier
	})
end

lib.callback.register('renzu_jobs:selectclothe',function(source, skin)
    local source = tonumber(source)
    local xPlayer = GetPlayerFromId(source)
    SqlFunc(config.Mysql,'execute','UPDATE users SET skin = @skin WHERE identifier = @identifier', {
        ['@skin'] = json.encode(skin),
        ['@identifier'] = xPlayer.identifier
    })
end)

function UpdateJob(identifier, job, grade)
    SqlFunc(config.Mysql,'execute','UPDATE users SET job = @job, job_grade = @job_grade WHERE identifier = @identifier',
        {
            ['@job'] = job,
            ['@job_grade'] = grade,
            ['@identifier'] = identifier
    })
end

function addMoneyOffline(identifier,amount)
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM users WHERE identifier = @identifier', {['@identifier'] = identifier})
    if result[1] then
        if config.esx == '1.1' then
            local bank = tonumber(result[1].bank) + tonumber(amount)
            SqlFunc(config.Mysql,'execute','UPDATE users SET bank = @bank WHERE identifier = @identifier',
            {
                ['@bank'] = bank,
                ['@identifier'] = identifier
            })
        else
            local res = json.decode(result[1].accounts)
            res['bank'] = res['bank'] + tonumber(amount)
            SqlFunc(config.Mysql,'execute','UPDATE users SET accounts = @accounts WHERE identifier = @identifier',
            {
                ['@accounts'] = json.encode(res),
                ['@identifier'] = identifier
            })
        end
    end
end

lib.callback.register('renzu_jobs:playerlist', function (source)
    playerinfo = SqlFunc(config.Mysql,'fetchAll','SELECT identifier,job,firstname,lastname,job_grade FROM users', {})
    local source = tonumber(source)
    local xPlayer = GetPlayerFromId(source)
    local jobs = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM job_grades', {})
    local salary = {}
    local job =  xPlayer.job.name
    local done = false
    local count = 0
    CreateThread(function()
        for i=1, #jobs, 1 do
            if jobs[i].job_name == job then
                salary[tostring(jobs[i].grade)] = jobs[i]
            end
        end

        for k,v in pairs(config.Jobs[xPlayer.job.name].grade) do
            if salary[tostring(k)] then
                v.salary = salary[tostring(k)].salary
                v.label = salary[tostring(k)].label
            end
        end
        done = true
    end)
    while not done and count < 2000 do count = count + 100 Wait(1) end
    local list = {}
    local online = {}
    local xPlayers = ESX.GetPlayers()
    local mycoord = GetEntityCoords(GetPlayerPed(source))
    for i=1, #xPlayers, 1 do
        local toPlayer = GetPlayerFromId(xPlayers[i])
        if #(mycoord - GetEntityCoords(GetPlayerPed(toPlayer.source))) < 50 and xPlayer.job.name ~= toPlayer.job.name then
            table.insert(online,{name = toPlayer.name, id = toPlayer.identifier})
        end
    end
    for k,v in pairs(playerinfo) do
        local initials = math.random(1,#config.RandomAvatars)
        local letters = config.RandomAvatars[initials]
        if v.identifier ~= nil and v.job ~= nil and v.job == xPlayer.job.name and v.firstname ~= '' and v.firstname ~= nil then
            v.name = v.firstname..' '..v.lastname
            if jobtable[v.job] == nil then jobtable[xPlayer.job.name] = {} end
            list[v.identifier] = {online = ESX.GetPlayerFromIdentifier(v.identifier) or false, id = v.identifier, job = jobtable[v.job][tostring(v.job_grade)], name = v.firstname, firstname = v.firstname, lastname = v.lastname, image = 'https://ui-avatars.com/api/?name='..v.firstname..'+'..v.lastname..'&background='..letters.background..'&color='..letters.color..''}
        end
    end
    local count = 0
    for k,v in pairs(playerinfo) do count = count + 1 end
    return cb(list, count, true,'',xPlayer.job.name,JobMoney(xPlayer.job.name), config.Jobs[xPlayer.job.name],online)
end)

function SendtoDiscord(webhook,color,title,desc)
    if not config.discordwebhook then return end
    local K = {
        {
            ["color"] = color, 
            ["title"] = "**" .. title .. "**", 
            ["description"] = desc, 
            ["footer"] = {["text"] = "^7[^2Renzu_Jobs^7]"}}
    }
    PerformHttpRequest(webhook,function(p, q, r) end, "POST",
        json.encode({username = l, embeds = K, avatar_url = k}), {
            ["Content-Type"] = "application/json"}
    )
end

function DiscordMessage(xPlayer,action,val,receiver)
    return "**\nname: **" ..
    GetPlayerName(xPlayer.source) ..
        "**\n Identifier: **" ..
        xPlayer.identifier ..
                "**\n Action: **" ..
                    action.." " .. val ..
                    "**\n Receiver: **" ..
                    receiver
end

lib.callback.register('renzu_jobs:getJobmoney',function(source, job, type)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    local money = JobMoney(job)[type]
    return money or 0
end)

lib.callback.register('renzu_jobs:sendbonus',function(source, identifier, amount)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    local toPlayer = GetPlayerFromIdentifier(identifier)
    if config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].givebonus then
        
        if toPlayer then
            if tonumber(amount) > 0 and JobMoney(xPlayer.job.name).money >= tonumber(amount) then
                removeMoney(tonumber(amount),xPlayer.job.name,source,'money')
                toPlayer.addMoney(tonumber(amount))
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You give $'..tonumber(amount)..' to '..toPlayer.name)
                TriggerClientEvent('renzu_jobs:notify',toPlayer.source,'success','Job', 'You Receive $'..tonumber(amount)..' Bonus from '..xPlayer.job.grade_label..' '..xPlayer.name..'')
                if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                    SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Send',amount,toPlayer.name))
                end
                return cb(true)
            else
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough money in stock')
            end
        else
            
            if tonumber(amount) > 0 and JobMoney(xPlayer.job.name).money >= tonumber(amount) then
                removeMoney(tonumber(amount),xPlayer.job.name,source,'money')
                local name =  xPlayer.job.name..' Member'
                for k,v in pairs(playerinfo) do
                    if v.identifier == identifier and v.firstname ~= '' and v.firstname ~= nil then
                        name = v.firstname
                    end
                end
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You give $'..tonumber(amount)..' to '..name)
                addMoneyOffline(identifier,tonumber(amount))
                if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                    SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Send',amount,name))
                end
                return cb(true)
            else
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough money in stock')
            end
        end
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have access')
        return cb(false)
    end
end)

GetExtendedPlayers = function(key, val) -- compatibility with non esx_legacy
	local xPlayers = {}
	for k, v in pairs(ESX.Players) do
		if key then
			if (key == 'job' and v.job.name == val) or v[key] == val then
				table.insert(xPlayers, v)
			end
		else
			table.insert(xPlayers, v)
		end
	end
	return xPlayers
end

lib.callback.register('renzu_jobs:changesalary', function (source, grade, amount) -- basecode esx_society - Credits
    local source = source
    local xPlayer = GetPlayerFromId(source)
    local grade = tonumber(grade)
    local amount = tonumber(amount)
    if config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].salarychange then
        if amount <= config.Jobs[xPlayer.job.name]['max_salary'] then
            SqlFunc(config.Mysql,'execute','UPDATE job_grades SET salary = @salary WHERE job_name = @job_name AND grade = @grade', {
                ['@salary']   = amount,
                ['@job_name'] = xPlayer.job.name,
                ['@grade']    = grade
            }, function(rowsChanged)
                local xPlayers = GetExtendedPlayers('job', xPlayer.job.name)
                for _, xTarget in pairs(xPlayers) do
                    if xTarget.job.grade == grade then
                        xTarget.setJob(xPlayer.job.name, grade)
                    end
                end
                if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                    SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Salary Change',amount,config.Jobs[xPlayer.job.name]['grade'][tonumber(grade)].label))
                end
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You successfully change the salary')
                return cb(true)
            end)
        else
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Over Budget for Salary Amount')
            return cb(false)
        end
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have access')
        return cb(false)
    end
end)

function Cancarry(xPlayer,item,amount)
    if string.find(item:upper(), "WEAPON_") and not xPlayer.hasWeapon(item) then
        return true
    elseif config.esx == '1.1' and item ~= nil and xPlayer.getInventoryItem(item) and xPlayer.getInventoryItem(item).limit >= (xPlayer.getInventoryItem(item).count + tonumber(amount)) then
        return true
    elseif config.esx == '1.2' and xPlayer.canCarryItem(item,tonumber(amount)) then
        return true
    end
    return false
end

lib.callback.register('renzu_jobs:buyitem',function(source, item, amount, job, shopindex)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    if config.Jobs[xPlayer.job.name] ~= nil and xPlayer.job.grade >= config.Jobs[xPlayer.job.name]['shop'][shopindex].grade or config.Jobs[job] ~= nil and config.Jobs[job]['shop'][shopindex].public then
        local found = false
        local value = 0
        for k,v in pairs(config.Jobs[job]['shop'][shopindex]['items']) do
            if v.name == item then
                found = true
                if tonumber(v.value) then
                    value = v.value
                end
                break
            end
        end
        value = value * tonumber(amount)
        if found and tonumber(amount) > 0 and xPlayer.getMoney() >= tonumber(value) and Cancarry(xPlayer,item,tonumber(amount)) and config.Jobs[job]['shop'][shopindex].public
        or not config.Jobs[job]['shop'][shopindex].public and found and tonumber(amount) > 0 and JobMoney(xPlayer.job.name).money >= tonumber(value) and Cancarry(xPlayer,item,tonumber(amount)) then
            if not config.Jobs[job]['shop'][shopindex].public then
                removeMoney(tonumber(value),xPlayer.job.name,source,'money')
            else
                addMoney(tonumber(value),job,source,'money')
                xPlayer.removeMoney(tonumber(value))
            end
            local label = nil
            if not string.find(item:upper(), "WEAPON_") then
                label = ESX.GetItemLabel(item)
                xPlayer.addInventoryItem(item,tonumber(amount))
            else
                label = ESX.GetWeaponLabel(item)
                xPlayer.addWeapon(item, 100)
                SetPedAmmo(GetPlayerPed(source),GetHashKey(item),100)
            end
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You Bought '..label)
            if config.Jobs[xPlayer.job.name]['shop'][shopindex].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['shop'][shopindex].webhook,16711680,config.Jobs[xPlayer.job.name]['shop'][shopindex].label,DiscordMessage(xPlayer,'Buy item',label..' '..amount,' '))
            end
            return cb(true)
        elseif not Cancarry(xPlayer,item,tonumber(amount)) and found then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have inventory space')
            return cb(false)
        elseif found then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have enough money')
            return cb(false)
        else
            -- item is not register to config (EXPLOITING?)
            -- ban trigger here
            return cb(false)
        end
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have access')
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:withdraw_deposit',function(source, type, amount, money_type)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    if xPlayer.job.name then
        local wperm = config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].withdraw
        local dperm = config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].deposit
        if wperm and type == 0 and tonumber(amount) > 0 and JobMoney(xPlayer.job.name)[money_type] >= tonumber(amount) then
            removeMoney(tonumber(amount),xPlayer.job.name,source,money_type)
            if xPlayer.getAccount(money_type) == nil then -- money accounts does not exist in ancient frameworks, only bank and black_money
                xPlayer.addMoney(tonumber(amount))
            else
                xPlayer.addAccountMoney(money_type, tonumber(amount))
            end
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You Withdraw '..amount..' from '..xPlayer.job.name..' money')
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Withdraw',amount,money_type))
            end
        elseif type == 0 and wperm then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'not enough money in stock')
        elseif type == 0 then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'No permission')
        end
        
        local esxold = false
        local account = xPlayer.getAccount(money_type)
        if money_type ~= 'black_money' and account == nil then -- assume a old esx if this account is nil, ancient framework only have bank and black_money
            account = {}
            account.money = xPlayer.getMoney()
            esxold = true
        end
        if dperm and type == 1 and tonumber(amount) > 0 and tonumber(account.money) >= tonumber(amount) then
            addMoney(tonumber(amount),xPlayer.job.name,source,money_type)
            if esxold then
                xPlayer.removeMoney(tonumber(amount))
            else
                xPlayer.removeAccountMoney(money_type, tonumber(amount))
            end
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You Deposit '..amount..' from '..xPlayer.job.name..' money')
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Deposit',amount,money_type))
            end
        elseif type == 1 and dperm then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have enough money')
        elseif type == 1 then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'No permission')
        end
    end
end)

lib.callback.register('renzu_jobs:setjob',function(source, grade, identifier)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    if config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].gradechange then
        local toPlayer = GetPlayerFromIdentifier(identifier)
        if toPlayer then
            text = 'Promoted'
            notify = 'success'
            if toPlayer.job.grade < tonumber(grade) then
                text = 'Demoted'
                notify = 'warning'
            end
            toPlayer.setJob(xPlayer.job.name, tonumber(grade))
            playerinfo = SqlFunc(config.Mysql,'fetchAll','SELECT identifier,job,firstname,lastname FROM users', {})
            Wait(100)
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You '..text..' '..toPlayer.name..' as a '..xPlayer.job.grade_label)
            TriggerClientEvent('renzu_jobs:notify',toPlayer.source,notify,'Job', 'You have been '..text..' by '..xPlayer.name..' to '..config.Jobs[xPlayer.job.name].grade[tonumber(grade)].label)
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,text,'',xPlayer.name..' to '..config.Jobs[xPlayer.job.name].grade[tonumber(grade)].label))
            end
            return cb(true)
        else
            text = 'Promoted'
            notify = 'success'
            local name =  xPlayer.job.name..' Member'
            local jobgrade = 0
            for k,v in pairs(playerinfo) do
                if v.identifier == identifier and v.firstname ~= '' and v.firstname ~= nil then
                    name = v.firstname
                    if v.job_grade then
                        jobgrade = v.job_grade
                    end
                end
            end
            UpdateJob(identifier, xPlayer.job.name, tonumber(grade))
            playerinfo = SqlFunc(config.Mysql,'fetchAll','SELECT identifier,job,firstname,lastname FROM users', {})
            Wait(100)
            
            if tonumber(jobgrade) > tonumber(grade) then
                text = 'Demoted'
                notify = 'warning'
            end
            
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You '..text..' '..name..' as a '..config.Jobs[xPlayer.job.name].grade[tonumber(grade)].label)
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,text,'',name..' to '..config.Jobs[xPlayer.job.name].grade[tonumber(grade)].label))
            end
            return cb(true)
        end
        
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have access')
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:kick',function(source, identifier)
    local source = source
    local xPlayer = GetPlayerFromId(source)
    if config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name].grade[xPlayer.job.grade]['access'].fire then
        local toPlayer = GetPlayerFromIdentifier(identifier)
        if toPlayer then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You Kicked '..toPlayer.name..' from '..xPlayer.job.label)
            TriggerClientEvent('renzu_jobs:notify',toPlayer.source,'info','Job', 'You have been fired by '..xPlayer.name..' from '..xPlayer.job.label)
            toPlayer.setJob(config.defaultjob, 0)
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Fired','',toPlayer.name))
            end
            return cb(true)
        else
            local name =  xPlayer.job.name..' Member'
            local jobgrade = 0
            for k,v in pairs(playerinfo) do
                if v.identifier == identifier and v.firstname ~= '' and v.firstname ~= nil then
                    name = v.firstname
                    jobgrade = v.job_grade
                end
            end
            UpdateJob(identifier, config.defaultjob, 0)
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You Kicked '..name..' from '..config.Jobs[xPlayer.job.name].grade[tonumber(jobgrade)].label)
            if config.Jobs[xPlayer.job.name]['bossmenu'].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['bossmenu'].webhook,16711680,'boss menu',DiscordMessage(xPlayer,'Fired','',name))
            end
            return cb(true)
        end
        
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have access')
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:itemfunc', function(source, type, amount, item, inv_type, slot)
	local xPlayer    = GetPlayerFromId(source)
	local i = xPlayer.getInventoryItem(item)
    if item == 'black_money' and not config.black_money_item then
        i = {count = xPlayer.getAccount('black_money').money}
    end
    local amount = tonumber(amount)
    local callback = false
    --
    local isweapon = string.find(item:upper(), "WEAPON_")
    if config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name]['inventory'][inv_type].grade <= xPlayer.job.grade then
        if not isweapon and type == 1 and amount ~= nil and amount > 0 and i.count >= amount or type == 1 and isweapon and xPlayer.hasWeapon(item) then -- deposit item
            addItem(xPlayer.job.name,item,amount,source,inv_type,xPlayer)
            local label = nil
            if isweapon then
                label = ESX.GetWeaponLabel(item)
                xPlayer.removeWeapon(item)
            elseif item ~= 'black_money' or config.black_money_item and item == 'black_money' then
                label = ESX.GetItemLabel(item)
                xPlayer.removeInventoryItem(item, amount)
            elseif item == 'black_money' and not config.black_money_item then
                label = 'Black Money'
                xPlayer.removeAccountMoney('black_money',tonumber(amount))
            end
            callback = true
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You deposit '..label..' x'..amount)
            if config.Jobs[xPlayer.job.name]['inventory'][inv_type].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['inventory'][inv_type].webhook,16711680,'Inventory',DiscordMessage(xPlayer,'Deposit Item',label..' x'..amount,inv_type..' Inventory'))
            end
            return cb(callback)
        elseif type == 1 then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have enough')
            return cb(callback)
        end
        if not isweapon and type == 0 and tonumber(amount) > 0 and GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item] >= amount 
        or type == 0 and isweapon and GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item]['data'] ~= nil and not xPlayer.hasWeapon(item) then
            local label = nil
            if isweapon and not xPlayer.hasWeapon(item) then
                label = ESX.GetWeaponLabel(item)
                xPlayer.addWeapon(item, tonumber(GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item]['data'].ammo))
                SetPedAmmo(GetPlayerPed(source),GetHashKey(item),tonumber(GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item]['data'].ammo))
                SetCurrentPedWeapon(GetPlayerPed(source),GetHashKey(item),true)
                Wait(200)
                
                
                if GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item]['data'].components then
                    for k,v in pairs(GetItems(xPlayer.job.name,inv_type,xPlayer)[slot][item]['data'].components) do
                        
                        xPlayer.removeWeaponComponent(tostring(item), tostring(v))
                        Wait(100)
                        xPlayer.addWeaponComponent(tostring(item), tostring(v))
                    end
                end
                callback = true
            elseif item ~= 'black_money' or config.black_money_item then
                if Cancarry(xPlayer,item,amount) then
                    label = ESX.GetItemLabel(item)
                    xPlayer.addInventoryItem(item, tonumber(amount))
                    callback = true
                else
                    TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough inventory space')
                    callback = false
                    return
                end
            elseif item == 'black_money' and not config.black_money_item then
                label = 'Black Money'
                callback = true
                xPlayer.addAccountMoney('black_money',tonumber(amount))
            end
            if callback then
                removeItem(xPlayer.job.name,item,amount,source,inv_type,xPlayer,slot)
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'You withdraw '..label..' x'..amount)
            end
            if config.Jobs[xPlayer.job.name]['inventory'][inv_type].webhook then
                SendtoDiscord(config.Jobs[xPlayer.job.name]['inventory'][inv_type].webhook,16711680,'Inventory',DiscordMessage(xPlayer,'Withdraw Item',label..' x'..amount,inv_type..' Inventory'))
            end
            return cb(callback)
        elseif type == 0 then
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough stock')
            return cb(callback)
        end
        
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have a permission to access')
        return cb(callback)
    end
end)

lib.callback.register('renzu_jobs:getPlayerWeapons', function(source, job, type)
    local source = source
    local xPlayer    = GetPlayerFromId(source)
    Wait(1000)
    return cb(xPlayer.getLoadout())
end)

lib.callback.register('renzu_jobs:getweapon', function(source, weapon)
    local source = source
    local xPlayer    = GetPlayerFromId(source)
    if xPlayer.hasWeapon(weapon) then
        xPlayer.removeWeapon(weapon)
        return cb(true)
    else
        xPlayer.addWeapon(weapon, 100)
        SetCurrentPedWeapon(GetPlayerPed(source),GetHashKey(weapon),true)
        SetPedAmmo(GetPlayerPed(source),GetHashKey(weapon),100)
        if config.Jobs[xPlayer.job.name]['weapon_armory'].webhook then
            SendtoDiscord(config.Jobs[xPlayer.job.name]['weapon_armory'].webhook,16711680,'Weapon Armory',DiscordMessage(xPlayer,'Get Weapon',weapon,' '))
        end
        Wait(100)
        return cb(true)
    end
end)

local ongoingcrafting = {}
lib.callback.register('renzu_jobs:craftitem', function(source, item, amount, type)
    local source = source
	local xPlayer    = GetPlayerFromId(source)
    local conf = config.Jobs[xPlayer.job.name]['crafting']['craftable'][item]
    local isweapon = string.find(item:upper(), "WEAPON_")
    local callback = false
    if isweapon and tonumber(amount) > 1 then
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You can only craft weapons one at a time')
    elseif ongoingcrafting[source] == nil then
        if conf ~= nil then
            local notenoughcabron = false
            for k,v in pairs(conf.requirements) do
                
                local hasitem = xPlayer.getInventoryItem(v.name)
                local require = v.amount * tonumber(amount)
                if hasitem.count ~= nil and hasitem.count < require then
                    notenoughcabron = true
                end
            end
            if notenoughcabron then
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough requirement')
            elseif Cancarry(xPlayer,item,tonumber(amount)) then
                callback = true
                ongoingcrafting[source] = true
                Citizen.CreateThread(function() -- incase lower fxserver
                    FreezeEntityPosition(GetPlayerPed(source),true)
                    return
                end)
                for k,v in pairs(conf.requirements) do
                    
                    local hasitem = xPlayer.getInventoryItem(v.name)
                    local require = v.amount * tonumber(amount)
                    if hasitem.count ~= nil and hasitem.count >= require then
                        xPlayer.removeInventoryItem(v.name, require)
                    end
                end
                option = {
                    icons = true, -- show or hide icons default true
                    pool = 0, -- Default: 0 Limits the number of concurrent notification elements that can be rendered within the notifications container at any given time. A value of 0 means that there is no limit.
                    sticky = false, -- Default: false A boolean designating whether the notification elements should be removed automatically when they expire or whether they should stay in the DOM until they are removed manually.
                    pauseOnHover = false, -- Default: true A boolean designating whether the notifications expiration control should pause when hovering over the wrapper element. Can only be set on class instantiation.
                    life = conf.seconds * tonumber(amount) * 1000, -- Default: 3000 Expiration time for non-sticky notification elements in milliseconds.
                    progressbar = true, -- A boolean designating whether the life time progress bar will be displayed for each notification element
                    effect = 'slide', -- The animation effect when adding or removing notification elements. Accepted values: fade or slide.
                    easing = 'ease-in-out', -- linear, ease, ease-in, ease-out, ease-in-out or a custom cubic-bezier value.
                }
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'default','Crafting Table', 'in Progress Please Wait ', option)
                Wait(conf.seconds * tonumber(amount) * 1000)
                if isweapon then
                    xPlayer.addWeapon(item, 0)
                else
                    xPlayer.addInventoryItem(item, tonumber(amount))
                end
                option = {
                    icons = true, -- show or hide icons default true
                    pool = 0, -- Default: 0 Limits the number of concurrent notification elements that can be rendered within the notifications container at any given time. A value of 0 means that there is no limit.
                    sticky = false, -- Default: false A boolean designating whether the notification elements should be removed automatically when they expire or whether they should stay in the DOM until they are removed manually.
                    pauseOnHover = false, -- Default: true A boolean designating whether the notifications expiration control should pause when hovering over the wrapper element. Can only be set on class instantiation.
                    life = 3000, -- Default: 3000 Expiration time for non-sticky notification elements in milliseconds.
                    progressbar = true, -- A boolean designating whether the life time progress bar will be displayed for each notification element
                    effect = 'slide', -- The animation effect when adding or removing notification elements. Accepted values: fade or slide.
                    easing = 'ease-in-out', -- linear, ease, ease-in, ease-out, ease-in-out or a custom cubic-bezier value.
                }
                ongoingcrafting[source] = nil
                Citizen.CreateThread(function() -- incase lower fxserver
                    FreezeEntityPosition(GetPlayerPed(source),false)
                    return
                end)
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Crafting Table', 'Successfully Crafted a '..item, option)
                if config.Jobs[xPlayer.job.name]['crafting'].webhook then
                    SendtoDiscord(config.Jobs[xPlayer.job.name]['crafting'].webhook,16711680,config.Jobs[xPlayer.job.name]['crafting'].label,DiscordMessage(xPlayer,'Craft a item ',item..' x'..amount,' '))
                end
            elseif not Cancarry(xPlayer,item,tonumber(amount)) then
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Not enough inventory space')
                callback = false
                return
            end
        else
            TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Crafting Table', 'item not exist in this crafting table')
        end
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'warning','Crafting Table', 'Ongoing crafting..')
    end
end)

lib.callback.register('renzu_jobs:saveclothes', function(source, name, data)
    local xPlayer    = GetPlayerFromId(source)
    SaveClothes(name,data,xPlayer)
    return cb(true)
end)

lib.callback.register('renzu_jobs:setweaponcomponents', function(source, weapon, component, slot)
    local xPlayer    = GetPlayerFromId(source)
    local component = component
    local weapon = tostring(weapon)
    if xPlayer.hasWeaponComponent(weapon, component, slot) then
        xPlayer.removeWeaponComponent(weapon, component, slot)
        return cb(true)
    else
        xPlayer.addWeaponComponent(weapon, component, slot)
        return cb(true)
    end
end)

lib.callback.register('renzu_jobs:getPlayerWardrobe', function(source)
    local xPlayer    = GetPlayerFromId(source)
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM saveclothes WHERE identifier = @identifier', {['@identifier'] = xPlayer.identifier})
    local wardrobe = {}
    if result[1] then
        wardrobe = json.decode(result[1].wardrobe)
    end
    return cb(wardrobe)
end)

lib.callback.register('renzu_jobs:getvehicles', function(source)
    local xPlayer    = GetPlayerFromId(source)
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM owned_vehicles WHERE owner = @owner', {['@owner'] = xPlayer.identifier})
    local garage = {}
    if result[1] then
        if config.Jobs[xPlayer.job.name]['garage'].unique then
            local jobgarage = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {
                ['@name'] = xPlayer.job.name
            })
            
            if jobgarage[1] then
                
                local jobvehicles = json.decode(jobgarage[1].garage)
                for k,v in pairs(result) do
                    local prop = json.decode(v.vehicle)
                    
                    if jobvehicles[prop.plate] ~= nil then
                        
                        garage[prop.plate] = v
                    end
                end
            end
        else
            garage = result
        end
    end
    vehicles = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM vehicles', {})
    
    return cb(garage,vehicles)
end)

lib.callback.register('renzu_jobs:takeoutvehicle', function(source, plate)
    local xPlayer    = GetPlayerFromId(source)
    
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM owned_vehicles WHERE owner = @owner AND plate = @plate', {
        ['@owner'] = xPlayer.identifier,
        ['@plate'] = plate
    })
    local garage = {}
    
    if result[1] then
        SqlFunc(config.Mysql,'execute','UPDATE owned_vehicles SET stored = @stored WHERE plate = @plate', {
            ['@plate'] = plate,
            ['@stored'] = 0,
        })
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'Successfully take out a vehicle')
        return cb(true)
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont owned the vehicle')
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:storevehicle', function(source, plate, prop)
    local xPlayer    = GetPlayerFromId(source)
    
    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM owned_vehicles WHERE owner = @owner AND plate = @plate', {
        ['@owner'] = xPlayer.identifier,
        ['@plate'] = plate
    })
    local garage = {}
    
    if result[1] then
        SqlFunc(config.Mysql,'execute','UPDATE owned_vehicles SET stored = @stored, vehicle = @vehicle WHERE plate = @plate', {
            ['@plate'] = plate,
            ['@vehicle'] = json.encode(prop),
            ['@stored'] = 1,
        })
        if config.Jobs[xPlayer.job.name]['garage'].unique then
            local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {
                ['@name'] = xPlayer.job.name
            })
            local vehicles = {}
            if result[1] then
                vehicles = json.decode(result[1].garage)
                vehicles[plate] = 1
            end
            SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET garage = @garage WHERE name = @name', {
                ['@name'] = xPlayer.job.name,
                ['@garage'] = json.encode(vehicles),
            })
        end
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'Successfully Store a vehicle')
        return cb(true)
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont owned the vehicle')
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:returnvehicle', function(source, plate)
    local xPlayer    = GetPlayerFromId(source)
    
    if xPlayer.getMoney() >= 500 then
        xPlayer.removeMoney(500)
        return cb(true)
    else
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have enough money to pay valet')
        return cb(false)
    end
end)

RegisterNetEvent('esx:setJob', function(src,job,old)
	local xPlayer = GetPlayerFromId(src)
	local new = false
    UpdateJob(xPlayer.identifier, job.name, tonumber(job.grade))
end)

RegisterNetEvent('renzu_jobs:duty', function(job,state)
    local source = source
    local xPlayer    = GetPlayerFromId(source)
    local grade = xPlayer.job.grade
    local job = job
    local text = 'Onduty'
    if not state then
        job = config.Jobs[job]['duty'].offdutyname
        text = 'Offduty'
    end
    xPlayer.setJob(job, grade)
    Wait(500)
    TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'Successfully '..text)
    UpdateJob(xPlayer.identifier, job, grade)
end)

local b='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/' -- You will need this for encoding/decoding
-- encoding
function veh(data)
	data = tostring(data)
    return ((data:gsub('.', function(x) 
        local r,b='',x:byte()
        for i=8,1,-1 do r=r..(b%2^i-b%2^(i-1)>0 and '1' or '0') end
        return r;
    end)..'0000'):gsub('%d%d%d?%d?%d?%d?', function(x)
        if (#x < 6) then return '' end
        local c=0
        for i=1,6 do c=c+(x:sub(i,i)=='1' and 2^(6-i) or 0) end
        return b:sub(c+1,c+1)
    end)..({ '', '==', '=' })[#data%3+1])
end

local NumberCharset = {}
for i = 48,  57 do table.insert(NumberCharset, string.char(i)) end
function GetRandomNumber(length)
	Citizen.Wait(1)
	math.randomseed(GetGameTimer())
	if length > 0 then
		return GetRandomNumber(length - 1) .. NumberCharset[math.random(1, #NumberCharset)]
	else
		return ''
	end
end

function GenPlate()
    local plate = nil
    if config.Mysql == 'mysql-async' then
        MySQL.Async.fetchAll('SELECT * FROM owned_vehicles', {}, function(result)
            local p = veh(tonumber(#result))
            p = p:gsub("=", "")
            total = 7 - p:len()
            if total ~= 0 then
                p = string.upper(""..veh(tonumber(#result)).." "..GetRandomNumber(total).."")
                p = p:gsub("=", "")
            end
            
            plate = p:upper()
        end)
    else
        exports['ghmattimysql']:execute('SELECT * FROM owned_vehicles', {}, function(result)
            local p = veh(tonumber(#result))
            p = p:gsub("=", "")
            local total = 8 - p:len()
            if total ~= 0 then
                p = veh(tonumber(#result))..GetRandomNumber(total)
                p = p:gsub("=", "")
            end
            plate = p:upper()
        end)
    end
    while plate == nil do Wait(0) end
    return plate
end

lib.callback.register('renzu_jobs:buyvehicle', function(source, model)
    local xPlayer    = GetPlayerFromId(source)
    local conf = config.Jobs[xPlayer.job.name]['vehicleshop'].vehicles
    for k,v in pairs(conf) do
        
        if v.model == model then
            if xPlayer.job.grade >= v.grade then
                if xPlayer.getMoney() >= tonumber(v.value) then
                    xPlayer.removeMoney(tonumber(v.value))
                    local plate = GenPlate()
                    SqlFunc(config.Mysql,'execute','INSERT INTO owned_vehicles (plate, vehicle, owner, stored) VALUES (@plate, @vehicle, @owner, @stored)', {
                        ['@plate']   = plate,
                        ['@vehicle']   = json.encode({model = GetHashKey(model), plate = plate}),
                        ['@owner']   = xPlayer.identifier,
                        ['@stored'] = 1
                    })
                    local result = SqlFunc(config.Mysql,'fetchAll','SELECT * FROM renzu_jobs WHERE name = @name', {
                        ['@name'] = xPlayer.job.name
                    })
                    local vehicles = {}
                    if result[1] then
                        vehicles = json.decode(result[1].garage)
                        vehicles[plate] = 1
                    end
                    SqlFunc(config.Mysql,'execute','UPDATE renzu_jobs SET garage = @garage WHERE name = @name', {
                        ['@name'] = xPlayer.job.name,
                        ['@garage'] = json.encode(vehicles),
                    })
                    TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'Successfully Bought a Vehicle - Check your Garage')
                    if config.Jobs[xPlayer.job.name]['vehicleshop'].webhook then
                        SendtoDiscord(config.Jobs[xPlayer.job.name]['vehicleshop'].webhook,16711680,config.Jobs[xPlayer.job.name]['vehicleshop'].label,DiscordMessage(xPlayer,'Buy Vehicle',model,' '))
                    end
                    return cb(true)
                else
                    TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have enough money')
                    return cb(false)
                end
            else
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'You dont have a permmision to buy this vehicle')
                return cb(false)
            end
            break
        end
    end
    
end)

function Round(num)
	return math.floor(num+0.5)
end

lib.callback.register('renzu_jobs:washmoney', function(source, amount, id)
    local source = source
	local xPlayer    = GetPlayerFromId(source)
    local id = id
    local coord = GetEntityCoords(GetPlayerPed(source))
    if tonumber(amount) < 0 then
        DropPlayer(source,'is this bug?')
        return
    end
    if xPlayer.getAccount('black_money').money < tonumber(amount) then
        TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'warning','Job', 'Black money onhand is insufficient')
        return cb('notenough')
    end
    if not config.MoneyWash[id].inuse then
        Citizen.CreateThread(function()
            local src = source
            coord = coord
            config.MoneyWash[id].inuse = true
            TriggerClientEvent('renzu_jobs:washuse',-1, id,config.MoneyWash[id].inuse)
            xPlayer.removeAccountMoney('black_money',tonumber(amount))
            Wait(60000)
            config.MoneyWash[id].inuse = false
            if #(GetEntityCoords(GetPlayerPed(src)) - coord) < 50 then
                TriggerClientEvent('renzu_jobs:washuse',-1, id,config.MoneyWash[id].inuse)
                local money = Round(tonumber(amount) * (1-config.MoneyWashTax))
                local tax = Round(tonumber(amount) * config.MoneyWashTax)
                xPlayer.addMoney(money)
                addMoney(tonumber(tax),config.MoneyWashOwner,src,'money')
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'success','Job', 'Money is Successfuly Washed')
            else
                local money = Round(tonumber(amount) * (1-config.MoneyWashTax))
                addMoney(tonumber(money),config.MoneyWashOwner,src,'money')
                TriggerClientEvent('renzu_jobs:washuse',-1, id,config.MoneyWash[id].inuse)
                TriggerClientEvent('renzu_jobs:notify',xPlayer.source,'error','Job', 'Money is Successfuly Washed and someone took it')
            end
        end)
        Wait(1000)
        return cb(true)
    else
        return cb(false)
    end
end)

lib.callback.register('renzu_jobs:getBlackMoney', function(source)
	local xPlayer    = GetPlayerFromId(source)
	local blackMoney = xPlayer.getAccount('black_money').money
    return cb(blackMoney)
end)

lib.callback.register('renzu_jobs:getPlayerInventory', function(source, job, type)
	local xPlayer    = GetPlayerFromId(source)
	local blackMoney = xPlayer.getAccount('black_money').money
	local items      = xPlayer.inventory
    local jobinventory = {}
    
    if config.Jobs[xPlayer.job.name] ~= nil and config.Jobs[xPlayer.job.name]['inventory'][type] then
        -- job inventory
        for slot,v in pairs(GetItems(xPlayer.job.name,type,xPlayer)) do
            
            for k,v in pairs(v) do
                
                local item_type = 'item'
                local label = nil
                local amount = v
                if string.find(k:upper(), "WEAPON_") then
                    item_type = 'weapon'
                    label = ESX.GetWeaponLabel(k)
                    amount = v['data'].ammo
                elseif k == 'black_money' and not config.black_money_item then
                    label = 'Black Money'
                else
                    label = ESX.GetItemLabel(k)
                end
                table.insert(jobinventory, {
                    label = label .. ' x' .. amount,
                    type  = item_type,
                    slot = slot,
                    name = k
                })
                
            end
        end
        -- player inventory
        local playerinventory = {}
        for i=1, #items, 1 do
			local item = items[i]
			if item.count > 0 then
                
				table.insert(playerinventory, {
					label = item.label .. ' x' .. item.count,
					type  = 'item',
					name = item.name
				})
			end
		end
        for k,v in pairs(xPlayer.getLoadout()) do
            if v.label then
                table.insert(playerinventory, {
                    label = v.label .. ' x' .. v.ammo,
                    ammo = v.ammo,
                    type  = 'weapon',
                    name = v.name
                })
            end
        end
        table.insert(playerinventory, {
            label = 'Black Money' .. ' x' .. blackMoney,
            type  = 'account',
            name = 'black_money'
        })
        
        return cb({
            playerinventory      = playerinventory,
            weapons    = xPlayer.getLoadout(),
            inventory = jobinventory
        })
    else
        return cb(false)
    end
end)

function SqlFunc(plugin,type,query,var)
	local wait = promise.new()
    if type == 'fetchAll' and plugin == 'mysql-async' then
		MySQL.Async.fetchAll(query, var, function(result)
            wait:resolve(result)
        end)
    end
    if type == 'execute' and plugin == 'mysql-async' then
        MySQL.Async.execute(query, var, function(result)
            wait:resolve(result)
        end)
    end
    if type == 'execute' and plugin == 'ghmattisql' then
        exports['ghmattimysql']:execute(query, var, function(result)
            wait:resolve(result)
        end)
    end
    if type == 'fetchAll' and plugin == 'ghmattisql' then
        exports.ghmattimysql:execute(query, var, function(result)
            wait:resolve(result)
        end)
    end
    if type == 'execute' and plugin == 'oxmysql' then
        exports.oxmysql:execute(query, var, function(result)
            wait:resolve(result)
        end)
    end
    if type == 'fetchAll' and plugin == 'oxmysql' then
		exports['oxmysql']:fetch(query, var, function(result)
			wait:resolve(result)
		end)
    end
	return Citizen.Await(wait)
end

lib.callback.register('renzu_jobs:getJob', function(source, job, type)
    local xPlayer = GetPlayerFromId(source)
    if xPlayer.getGroup() == 'admin' or xPlayer.getGroup() == 'superadmin' then
        return ESX.Jobs
    end
    return false
end)

lib.callback.register('renzu_jobs:Addgrade', function(source, data)
    local xPlayer = GetPlayerFromId(source)
    local jobs = ESX.Jobs
    if not ESX.Jobs[data.name] then
        SqlFunc(config.Mysql,'execute','INSERT INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES (@job_name, @grade, @name, @label, @salary, @skin_male, @skin_female)', {
            ['@job_name']   = data.job,
            ['@grade']   = data.grade,
            ['@name'] = string.gsub(data.label, "%s+", ""):lower(),
            ['@label'] = data.label,
            ['@salary'] = data.salary or 1,
            ['@skin_male'] = '[]',
            ['@skin_female'] = '[]',
        })
        jobs[data.job].grades[data.grade] = {job_name = data.job, grade = data.grade, salary = data.salary or 1, label = data.label, name = string.gsub(data.label, "%s+", ""):lower(), skin_male = "", skin_female = ""}
        ESX.RefreshJobs()
        TriggerClientEvent('renzu_jobs:notify',jobs,'success','Job', 'ESX Jobs Has been Refreshed')
        return true
    else
        return false
    end
    return ESX.Jobs
end)

lib.callback.register('renzu_jobs:Createjob', function(source, data)
    local xPlayer = GetPlayerFromId(source)
    local jobs = ESX.Jobs
    if not ESX.Jobs[data.name] then
        SqlFunc(config.Mysql,'execute','INSERT INTO jobs (name, label, whitelisted) VALUES (@name, @label, @whitelisted)', {
            ['@name']   = data.name,
            ['@label']   = data.label,
            ['@whitelisted'] = data.whitelisted or 0
        })
        SqlFunc(config.Mysql,'execute','INSERT INTO job_grades (job_name, grade, name, label) VALUES (@job_name, @grade, @name, @label)', {
            ['@job_name']   = data.name,
            ['@grade']   = 1,
            ['@name'] = 'recruit',
            ['@label'] = 'Recruit',
        })
        jobs[data.name] = {name = data.name, label = data.label, grades = {[1] = {job_name = data.name, grade = 1, salary = 0, label = 'Recruit', name = 'recruit', skin_male = "", skin_female = ""}, whitelisted = data.whitelisted or false}}
        ESX.RefreshJobs()
        TriggerClientEvent('renzu_jobs:notify',jobs,'success','Job', 'ESX Jobs Has been Refreshed')
        return true
    else
        return false
    end
    return true
end)

cb2 = function(data)
    return table.unpack(data)
end
cb = function(...)
    return cb2({...})
end

-- TURF WARS
GlobalState.TurfActive = false
lib.callback.register('renzu_jobs:OccupyTeritorry',function(source,id)
    local turfs = GlobalState.Turfs
    local xPlayer = GetPlayerFromId(source)
    turfs[id] = {owner = xPlayer.job.name, ownerlabel = xPlayer.job.label, triggerby = xPlayer.identifier}
    GlobalState.Turfs = turfs
    local turfname = id:upper()
    local jobname = xPlayer.job.label
    TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR',  id..' has been Occupied by '..xPlayer.name..' ('..xPlayer.job.label..')')
end)

lib.callback.register('renzu_jobs:openVault',function(source,id)
    local turfs = GlobalState.Turfs
    local xPlayer = GetPlayerFromId(source)
    if turfs[id].owner == xPlayer.job.name and not turfs[id].vault then
        for k,v in pairs(config.Turfs[id].reward()) do
            xPlayer.addInventoryItem(v.item,v.amount)
            turfs[id].vault = true
        end
        GlobalState.Turfs = turfs
        SetResourceKvp('Turfs', json.encode(GlobalState.Turfs))
        TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR',  id..' Reward Vault has been Claimed by '..xPlayer.name..' ('..xPlayer.job.label..')')
    elseif turfs[id].owner == xPlayer.job.name and turfs[id].vault then
        TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR',  id..' Reward is Already Claimed')
    end
end)

lib.callback.register('renzu_jobs:removeturf',function(source,id)
    local turfs = GlobalState.Turfs
    local xPlayer = GetPlayerFromId(source)
    turfs[id] = nil
    GlobalState.Turfs = turfs
    local turfname = id:upper()
    local jobname = xPlayer.job.label
    TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', id..' can be occupied again, Reason: Owner Died ('..xPlayer.name..') recently owned by '..jobname)
end)

RegisterNetEvent('esx_multicharacter:relog', function()
	local source = source
	local xPlayer = GetPlayerFromId(source)
    local active = GlobalState.TurfActive
    if active then
        local turfs = GlobalState.Turfs
        if turfs[active] and turfs[active].triggerby == xPlayer.identifier then
            turfs[active] = nil
            GlobalState.Turfs = turfs
            TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', active:upper()..' can be occupied again, Reason: Owner Disconnected ('..xPlayer.name..') recently owned by '..xPlayer.job.name)
        end
    end
end)

RegisterNetEvent("playerDropped",function()
	local source = source
	local xPlayer = GetPlayerFromId(source)
    local active = GlobalState.TurfActive
    if active then
        local turfs = GlobalState.Turfs
        if turfs[active] and turfs[active].triggerby == xPlayer.identifier then
            turfs[active] = nil
            GlobalState.Turfs = turfs
            TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', active:upper()..' can be occupied again, Reason: Owner Disconnected ('..xPlayer.name..') recently owned by '..xPlayer.job.name)
        end
    end
end)

CreateThread(function()
    while true do
        local time = os.date("*t")
        for k,v in pairs(config.Turfs) do
            if v.schedule == time.hour and time.min == 0 and time.sec == 1 then
                StartTurfWar(k)
            end
        end
        Wait(1000)
    end
end)

StartTurfWar = function(id)
    local turf = id
    local ongoing = GlobalState.OngoingTurfwar
    ongoing[turf] = true
    GlobalState.OngoingTurfwar = ongoing
    GlobalState.TurfActive = turf
    local id = turf:upper()
    local turfs = GlobalState.Turfs
    turfs[turf] = nil
    GlobalState.Turfs = turfs
    GlobalState.TurfTime = config.turfwarduration
    TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', id..' Turf War has begin')
    Citizen.CreateThread(function()
        while true do
            GlobalState.TurfTime -= 1
            if GlobalState.TurfTime <= 0 then
                local owner = 'None'
                local turfs = GlobalState.Turfs
                if turfs[turf] then
                    turfs[turf].vault = false
                end
                GlobalState.Turfs = turfs
                if GlobalState.Turfs[turf] and GlobalState.Turfs[turf].ownerlabel then
                    owner = GlobalState.Turfs[turf].ownerlabel
                else
                    GlobalState.Turfs[turf] = nil
                end
                SetResourceKvp('Turfs', json.encode(GlobalState.Turfs))
                GlobalState.TurfActive = nil
                if owner ~= 'None' then
                    TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', id..' Turf Has Been Successfully Occupied by '..owner)
                else
                    TriggerClientEvent('renzu_jobs:notify',-1,'inform','TURF WAR', id..' Turf Has Ended. Owner: None')
                end
                break
            end
            Wait(1000)
        end
    end)
end