SHIFT = 1
TABLES[] = users
TABLES[] = stock

SQL[] = " ,users.id FROM users"
SQL[] = "LEFT JOIN stock ON users.id=stock.users_id"
SQL[] = "LEFT JOIN (SELECT rp1.* FROM reward_points rp1 INNER JOIN (SELECT users_id, MAX(id) AS max_id FROM reward_points GROUP BY users_id) rp2 ON rp1.users_id = rp2.users_id AND rp1.id = rp2.max_id) reward_points ON reward_points.users_id=users.id"
GROUP_BY = "GROUP BY users.id"

[users.color]
title = COLOR
controller = modules\extendedDatatable\code\TextColumnController
visible = false

[users.id] 
title = ID
controller = modules\extendedDatatable\code\NumberIntColumnController
visible = false

[users.state]
title = Stav
controller = modules\users\code\UserStateColumnController
visible = true
filter = app\constants\State

[users.tags]
title = Tagy
controller = modules\ttjs\code\TagsColumnController
visible = true

[users.personalno]
title = Osobné číslo
controller = modules\extendedDatatable\code\NumberIntColumnController
visible = true

[users.first_name]
title = Meno
controller = modules\extendedDatatable\code\TextColumnController
visible = true

[users.last_name]
title = Priezvisko
controller = modules\extendedDatatable\code\TextColumnController
visible = true

[stock.items_count] 
title = "Sklad (ks)"
controller = modules\extendedDatatable\code\NumberIntColumnController
visible = true

[stock.unpaid_commission]
title = Nevyplatená provízia
controller = modules\extendedDatatable\code\PriceColumnController
visible = true

[users.iban]
title = "Číslo účtu / IBAN"
controller = modules\extendedDatatable\code\TextColumnController
visible = true

[users.email]
title = E-mail
controller = modules\extendedDatatable\code\TextColumnController
visible = true

[points_balance_calc] 
title = "users_datatable.points_balance"
controller = modules\extendedDatatable\code\NumberIntColumnController
alias = "FLOOR(IFNULL(reward_points.points_balance, 0)) AS points_balance_calc"
visible = true

[lifetime_points_calc] 
title = "users_datatable.lifetime_points"
controller = modules\extendedDatatable\code\NumberIntColumnController
alias = "FLOOR(IFNULL(reward_points.lifetime_points, 0)) AS lifetime_points_calc"
visible = true

[users.note]
title = Poznámka
controller = modules\extendedDatatable\code\TextColumnController
visible = true

[users.last_name_birth]
title = Rodné priezvisko
controller = modules\extendedDatatable\code\TextColumnController
visible = true