local data = {cost = 250000}

function refreshgui(element)
    local uid = element:getData("player:sid")
    if not uid then return false end
    
    local result = exports["DB2"]:dbGet("SELECT pystories_vehicles.model,pystories_vehicles.id,pystoriesvehicles.ownedGroup,ogrpg_organization_list.name FROM pystoriesvehicles left join ogrpg_organization_list on ogrpg_organization_list.id=pystories_vehicles.ownedGroup WHERE ownedPlayer=?", uid)
    triggerClientEvent(element, "org:refresh", resourceRoot, result)
end
addEvent("org:download", true)
addEventHandler("org:download", resourceRoot, refreshgui)

addEvent("org:check", true)
addEventHandler("org:check", resourceRoot, function(id, name)
    local uid = client:getData("player:sid")
    if not uid then return false end
    
    local result = exports["DB2"]:dbGet("SELECT * FROM pystories_vehicles WHERE id=? AND ownedPlayer=?", id, uid)
    if #result < 0 then 
        return triggerClientEvent(client, "onClientAddNotification", client, "Nie jeste? w?a?cicielem tego pojazdu!", "error")
    end
    
    local result = exports["DB2"]:dbGet("SELECT * FROM pystories_vehicles WHERE id=? AND parking=0", id)
    if #result > 0 then 
        return triggerClientEvent(client, "onClientAddNotification", client, "Pojazd nie znajduje si? w przechowalni!", "error")
    end
    
    local result = exports["DB2"]:dbGet("SELECT * FROM pystories_vehicles WHERE id=? AND ownedPlayer=?", id, uid)
    if #result > 0 then 
        if result[1].ownedGroup ~= "0" then 
                local query = exports["DB2"]:dbSet("UPDATE pystories_vehicles SET ownedGroup=0 WHERE id=? AND ownedPlayer=?", id, uid)
                triggerClientEvent(client, "onClientAddNotification", client, "Zmieni?e?(a?) pojazdowi "..name.." [ID: "..id.."] przypis na siebie.", "success")
                refreshgui(client)
            return
        end
    
        local org = getElementData(client, "player:organization:id")
        if not org then return triggerClientEvent(client, "onClientAddNotification", client, "Nie nale?ysz do ?adnej organizacji!", "error") end
        local query = exports["DB2"]:dbSet("UPDATE pystories_vehicles SET ownedGroup=? WHERE id=? AND ownedPlayer=?", org, id, uid)
        if query then
            triggerClientEvent(client, "onClientAddNotification", client, "Zmieni?e?(a?) pojazdowi "..name.." [ID: "..id.."] przypis na organizacj?.", "success")
            refreshgui(client)
        end
    end
end)

addEvent("org:create", true)
addEventHandler("org:create", root, function(name)
    local uid = source:getData("player:sid")
    if not uid then return false end
    
    local result = exports["DB2"]:dbGet("SELECT * FROM ogrpg_organization_list WHERE name=?", name)
    if #result == 0 and source.money >= data.cost then
        exports["DB2"]:dbSet("INSERT INTO ogrpg_organization_list (name) VALUES (?)", name)
        
        local result = exports["DB2"]:dbGet("SELECT * FROM ogrpg_organization_list where name=?",name)
        exports["DB2"]:dbSet("INSERT INTO ogrpg_organizations (code, uid, rank) VALUES (?,?,?)", result[1].id, uid, 4)
        
        setElementData(source, "player:organization", name)
        setElementData(source, "player:organization:id", result[1].id)
        triggerClientEvent(source, "onClientAddNotification", source, "Pomy?lnie stworzy?e?(a?) organizacj? o nazwie "..name.."!", "success")
        source:takeMoney(data.cost)
    else
        triggerClientEvent(source, "onClientAddNotification", source, "Istnieje ju? taka organizacja b?d? nie posiadasz 200.000PLN!", "error")
    end
end)