64 lines
3.9 KiB
SQL
64 lines
3.9 KiB
SQL
-- Refinery (المصفاة) modules ported from AqabaTCS: trips, wage claims, commission claims, wallets, variables, cards.
|
|
-- Authority: SU (always allowed by the code, needs no row) and REFINERY_MGR (rows below: 6 screens + every action key).
|
|
-- Run on a database where GRAINS_SCREEN_PERMISSIONS exists (db/grains-screen-permissions.sql). Safe to re-run. Not executed by the application.
|
|
-- Delete a row to take a key away (the API applies it within about a minute, the browser on the next reload or sign-in).
|
|
-- Give another role access: copy the block and change the role code.
|
|
|
|
INSERT INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY)
|
|
SELECT 'REFINERY_MGR', v.resource_key
|
|
FROM (SELECT 'refinery.trips' AS resource_key FROM dual UNION ALL
|
|
SELECT 'refinery.trips.firstAdvance' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.secondAdvance' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.firstAdvanceReverse' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.secondAdvanceReverse' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.exchange' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.exchangeAudit' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.receipt' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.payment' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.activateWalletExchange' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.orangePayment' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.cashPayment' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.confirmExchange' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.print' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.report' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.operatorReport' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.exchangeReport' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.dieselReport' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.cardsReport' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.bankReport' FROM dual UNION ALL
|
|
SELECT 'refinery.trips.recalculateBalance' FROM dual UNION ALL
|
|
SELECT 'refinery.wageClaims' FROM dual UNION ALL
|
|
SELECT 'refinery.wageClaims.create' FROM dual UNION ALL
|
|
SELECT 'refinery.wageClaims.close' FROM dual UNION ALL
|
|
SELECT 'refinery.wageClaims.transfer' FROM dual UNION ALL
|
|
SELECT 'refinery.wageClaims.report' FROM dual UNION ALL
|
|
SELECT 'refinery.commissionClaims' FROM dual UNION ALL
|
|
SELECT 'refinery.commissionClaims.create' FROM dual UNION ALL
|
|
SELECT 'refinery.commissionClaims.complete' FROM dual UNION ALL
|
|
SELECT 'refinery.commissionClaims.report' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets.create' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets.update' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets.activate' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets.deactivate' FROM dual UNION ALL
|
|
SELECT 'refinery.wallets.report' FROM dual UNION ALL
|
|
SELECT 'refinery.variables' FROM dual UNION ALL
|
|
SELECT 'refinery.variables.create' FROM dual UNION ALL
|
|
SELECT 'refinery.variables.update' FROM dual UNION ALL
|
|
SELECT 'refinery.variables.tonPriceCorrection' FROM dual UNION ALL
|
|
SELECT 'refinery.variables.report' FROM dual UNION ALL
|
|
SELECT 'refinery.variables.remainingBalanceReport' FROM dual UNION ALL
|
|
SELECT 'refinery.cards' FROM dual UNION ALL
|
|
SELECT 'refinery.cards.create' FROM dual UNION ALL
|
|
SELECT 'refinery.cards.activate' FROM dual UNION ALL
|
|
SELECT 'refinery.cards.deactivate' FROM dual UNION ALL
|
|
SELECT 'refinery.cards.report' FROM dual) v
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM GRAINS_SCREEN_PERMISSIONS p
|
|
WHERE p.rolecode = 'REFINERY_MGR' AND p.resource_key = v.resource_key);
|
|
|
|
COMMIT;
|
|
|
|
-- Check (expect 47 rows):
|
|
-- SELECT resource_key FROM GRAINS_SCREEN_PERMISSIONS WHERE rolecode = 'REFINERY_MGR' AND resource_key LIKE 'refinery.%' ORDER BY resource_key;
|