

INSERT INTO acl_roles (id, name, description) VALUES
    (1, 'ROLE_EMPLOYEE_READ', null),
    (2, 'ROLE_EMPLOYEE_WRITE', null),
    (3, 'ROLE_WAREHOUSE_READ', null),
    (4, 'ROLE_WAREHOUSE_WRITE', null),
    (5, 'ROLE_ITEM_READ', null),
    (6, 'ROLE_ITEM_WRITE', null),
    (7, 'ROLE_CUSTOMER_READ', null),
    (8, 'ROLE_CUSTOMER_WRITE', null),
    (9, 'ROLE_ORDER_READ', null),
    (10, 'ROLE_ORDER_WRITE', null),
    (11, 'ROLE_RETURN_READ', null),
    (12, 'ROLE_RETURN_WRITE', null),
    (13, 'ROLE_TRANSFER_READ', null),
    (14, 'ROLE_TRANSFER_WRITE', null),
    (1001, 'ROLE_SALES', null),
    (1002, 'ROLE_ADMIN', null),
    (1003, 'ROLE_CARRIER', null),
    (1004, 'ROLE_CHECKER', null),
    (2001, 'ROLE_BOSS', null);

INSERT INTO acl_groups (id, name, description) VALUES
    (1, 'Admin', null),
    (2, 'Boss', null),
    (3, 'Carrier', null),
    (4, 'Checker', null),
    (5, 'Sales', null);

INSERT INTO acl_group_roles (acl_group_id, acl_role_id) VALUES
    (1, 1002),
    (1, 14),
    (1, 13),
    (1, 12),
    (1, 11),
    (1, 10),
    (1, 9),
    (1, 8),
    (1, 7),
    (1, 6),
    (1, 5),
    (1, 4),
    (1, 3),
    (1, 1),
    (2, 2001),
    (2, 14),
    (2, 13),
    (2, 12),
    (2, 11),
    (2, 10),
    (2, 9),
    (2, 8),
    (2, 7),
    (2, 6),
    (2, 5),
    (2, 4),
    (2, 3),
    (2, 2),
    (2, 1),
    (3, 1003),
    (3, 14),
    (3, 13),
    (3, 12),
    (3, 11),
    (3, 10),
    (3, 9),
    (3, 5),
    (3, 3),
    (4, 1004),
    (4, 14),
    (4, 13),
    (4, 12),
    (4, 11),
    (4, 10),
    (4, 9),
    (4, 5),
    (4, 3),
    (5, 1001),
    (5, 12),
    (5, 11),
    (5, 10),
    (5, 9),
    (5, 8),
    (5, 7),
    (5, 5),
    (5, 3);

INSERT INTO mappings (id, object)
VALUES (1, 'employee'),
       (2, 'items'),
       (3, 'warehouse_items'),
       (4, 'customers'),
       (5, 'report_empty_orders');

INSERT INTO mapping_fields (id, mapping_id, `database`, excel)
VALUES (1, 1, 'id', 'id'),
       (2, 1, 'code', 'nik'),
       (3, 1, 'name', 'nama'),
       (4, 1, 'title', 'jabatan'),
       (5, 1, 'email', 'email'),
       (6, 1, 'description', 'keterangan'),
       (7, 2, 'id', 'id'),
       (8, 2, 'code', 'item_no'),
       (9, 2, 'name', 'name'),
       (10, 2, 'part', 'merk'),
       (11, 2, 'unit', 'satuan'),
       (12, 2, 'package', 'package'),
       (13, 2, 'price', 'price'),
       (14, 2, 'weight', 'berat'),
       (15, 2, 'barcode', 'barcode'),
       (17, 3, 'id', 'id'),
       (18, 3, 'code', 'item_no'),
       (19, 3, 'name', 'name'),
       (20, 3, 'part', 'merk'),
       (21, 3, 'unit', 'satuan'),
       (22, 3, 'package', 'package'),
       (23, 3, 'price', 'price'),
       (24, 3, 'weight', 'berat'),
       (25, 3, 'barcode', 'barcode'),
       (26, 3, 'location', 'location'),
       (27, 3, 'stock', 'qty'),
       (28, 4, 'id', 'id'),
       (29, 4, 'code', 'customers_no'),
       (30, 4, 'name', 'name'),
       (31, 4, 'address1', 'address1'),
       (32, 4, 'address2', 'address2'),
       (33, 4, 'city', 'city'),
       (34, 4, 'state', 'state'),
       (35, 4, 'country', 'country'),
       (36, 4, 'phone1', 'phone_no1'),
       (37, 4, 'phone2', 'phone_no2'),
       (38, 4, 'discount', 'disc'),
       (39, 4, 'payment', 'term'),
       (40, 4, 'employee_name', 'sales'),
       (41, 5, 'code', 'code'),
       (42, 5, 'new_customer', 'new_customer'),
       (43, 5, 'taxable', 'taxable'),
       (44, 5, 'status', 'status'),
       (45, 5, 'date', 'date'),
       (46, 5, 'total', 'total'),
       (47, 5, 'order_discount', 'order_discount'),
       (48, 5, 'final_total', 'final_total'),
       (49, 5, 'sales_update_date', 'sales_update_date'),
       (50, 5, 'admin_update_date', 'admin_update_date'),
       (51, 5, 'carrier_update_date', 'carrier_update_date'),
       (52, 5, 'checker_update_date', 'checker_update_date'),
       (53, 5, 'sales_memo', 'sales_memo'),
       (54, 5, 'admin_memo', 'admin_memo'),
       (55, 5, 'carrier_memo', 'carrier_memo'),
       (56, 5, 'checker_memo', 'checker_memo'),
       (57, 5, 'warehouse_code', 'warehouse_code'),
       (58, 5, 'warehouse_name', 'warehouse_name'),
       (59, 5, 'customer_code', 'customer_code'),
       (60, 5, 'customer_name', 'customer_name'),
       (61, 5, 'customer_address1', 'customer_address1'),
       (62, 5, 'customer_address2', 'customer_address2'),
       (63, 5, 'customer_city', 'customer_city'),
       (64, 5, 'customer_state', 'customer_state'),
       (65, 5, 'customer_country', 'customer_country'),
       (66, 5, 'customer_phone1', 'customer_phone1'),
       (67, 5, 'customer_phone2', 'customer_phone2'),
       (68, 5, 'customer_discount', 'customer_discount'),
       (69, 5, 'customer_payment', 'customer_payment'),
       (70, 5, 'customer_description', 'customer_description'),
       (81, 5, 'sales_code', 'sales_code'),
       (82, 5, 'sales_name', 'sales_name'),
       (83, 5, 'admin_code', 'admin_code'),
       (84, 5, 'admin_name', 'admin_name'),
       (85, 5, 'carrier_code', 'carrier_code'),
       (86, 5, 'carrier_name', 'carrier_name'),
       (87, 5, 'checker_code', 'checker_code'),
       (88, 5, 'checker_name', 'checker_name'),
       (89, 5, 'quantity', 'quantity'),
       (80, 5, 'shipping_quantity', 'shipping_quantity'),
       (91, 5, 'order_detail_discount', 'order_detail_discount'),
       (92, 5, 'final_price', 'final_price'),
       (93, 5, 'subtotal', 'subtotal'),
       (94, 5, 'item_location', 'item_location'),
       (95, 5, 'item_stock', 'item_stock'),
       (96, 5, 'item_code', 'item_code'),
       (97, 5, 'item_name', 'item_name'),
       (98, 5, 'item_part', 'item_part'),
       (99, 5, 'item_unit', 'item_unit'),
       (100, 5, 'item_package', 'item_package'),
       (101, 5, 'item_price', 'item_price'),
       (102, 5, 'item_weight', 'item_weight'),
       (103, 2, 'category', 'kategori');

INSERT INTO announcements (id, content)
VALUES (1, 'Hello, world!');
