CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: payment_accounts
CREATE TABLE `payment_accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` enum('bank','ewallet') NOT NULL,
  `provider` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `account_holder` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `payment_accounts` (`id`, `name`, `type`, `provider`, `account_number`, `account_holder`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'BCA', 'bank', 'BCA', '2920858026', 'Raden Cik Awang', '1', '2026-02-12 18:17:51', '2026-02-27 13:35:53');
INSERT INTO `payment_accounts` (`id`, `name`, `type`, `provider`, `account_number`, `account_holder`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'Mandiri', 'bank', 'Mandiri', '1120005038182', 'Raden Cik Awang', '1', '2026-02-27 13:36:18', '2026-02-27 13:36:18');
INSERT INTO `payment_accounts` (`id`, `name`, `type`, `provider`, `account_number`, `account_holder`, `is_active`, `created_at`, `updated_at`) VALUES ('11', 'BRI', 'bank', 'BRI', '185901012107503', 'Raden Cik Awang', '1', '2026-03-02 13:17:08', '2026-03-02 13:17:08');

-- Table: payments
CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL DEFAULT 'cash',
  `payment_account_id` bigint(20) unsigned DEFAULT NULL,
  `proof_path` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `cashier_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_cashier_id_foreign` (`cashier_id`),
  KEY `payments_order_id_index` (`order_id`),
  KEY `payments_created_at_index` (`created_at`),
  KEY `payments_payment_account_id_foreign` (`payment_account_id`),
  CONSTRAINT `payments_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payments_payment_account_id_foreign` FOREIGN KEY (`payment_account_id`) REFERENCES `payment_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('8', '20', '50000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 11:14:54', '2026-03-02 11:14:54');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('9', '23', '19800.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 11:16:50', '2026-03-02 11:16:50');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('10', '36', '5400.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 11:28:18', '2026-03-02 11:28:18');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('11', '33', '41700.00', 'transfer', '10', NULL, NULL, '16', '2026-03-02 11:45:34', '2026-03-02 11:45:34');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('12', '34', '1800.00', 'transfer', '10', NULL, NULL, '16', '2026-03-02 11:45:34', '2026-03-02 11:45:34');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('13', '65', '140000.00', 'cash', NULL, NULL, NULL, '5', '2026-03-02 13:09:49', '2026-03-02 13:09:49');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('14', '67', '5000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 13:31:01', '2026-03-02 13:31:01');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('15', '56', '50000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 13:35:23', '2026-03-02 13:35:23');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('16', '19', '48000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 13:37:10', '2026-03-02 13:37:10');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('17', '85', '20000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:00:16', '2026-03-02 14:00:16');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('18', '27', '24300.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 14:01:48', '2026-03-02 14:01:48');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('19', '29', '3200.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 14:01:48', '2026-03-02 14:01:48');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('20', '30', '100000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:15:33', '2026-03-02 14:15:33');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('21', '50', '100000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:16:44', '2026-03-02 14:16:44');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('22', '42', '49500.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:33:00', '2026-03-02 14:33:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('23', '45', '15400.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:33:00', '2026-03-02 14:33:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('24', '92', '3997.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 14:35:00', '2026-03-02 14:35:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('25', '41', '10000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 14:36:35', '2026-03-02 14:36:35');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('26', '63', '32800.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 14:43:16', '2026-03-02 14:43:16');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('27', '95', '1040000.00', 'transfer', '10', NULL, NULL, '16', '2026-03-02 15:04:24', '2026-03-02 15:04:24');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('28', '68', '52000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 15:05:00', '2026-03-02 15:05:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('29', '55', '25000.00', 'transfer', '11', NULL, NULL, '16', '2026-03-02 15:05:31', '2026-03-02 15:05:31');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('30', '22', '26400.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 15:10:22', '2026-03-02 15:10:22');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('31', '25', '97500.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 15:10:22', '2026-03-02 15:10:22');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('32', '74', '20000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 15:23:51', '2026-03-02 15:23:51');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('33', '108', '109200.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:02:14', '2026-03-02 16:02:14');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('34', '91', '17500.00', 'transfer', '8', NULL, NULL, '5', '2026-03-02 16:04:34', '2026-03-02 16:04:34');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('35', '59', '100000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 16:14:42', '2026-03-02 16:14:42');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('36', '69', '50000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 16:15:49', '2026-03-02 16:15:49');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('37', '86', '10000.00', 'cash', NULL, NULL, NULL, '16', '2026-03-02 16:18:21', '2026-03-02 16:18:21');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('38', '88', '21900.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:23:02', '2026-03-02 16:23:02');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('39', '46', '90000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:24:32', '2026-03-02 16:24:32');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('40', '32', '42000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:29:00', '2026-03-02 16:29:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('41', '44', '101400.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:29:00', '2026-03-02 16:29:00');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('42', '21', '630000.00', 'transfer', '10', NULL, NULL, '16', '2026-03-02 16:35:22', '2026-03-02 16:35:22');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('43', '60', '50000.00', 'transfer', '10', NULL, NULL, '16', '2026-03-02 16:37:50', '2026-03-02 16:37:50');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('44', '103', '23400.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 16:46:46', '2026-03-02 16:46:46');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('45', '84', '147000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 17:04:30', '2026-03-02 17:04:30');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('46', '57', '217000.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 17:05:28', '2026-03-02 17:05:28');
INSERT INTO `payments` (`id`, `order_id`, `amount`, `payment_method`, `payment_account_id`, `proof_path`, `notes`, `cashier_id`, `created_at`, `updated_at`) VALUES ('47', '78', '36300.00', 'transfer', '8', NULL, NULL, '16', '2026-03-02 17:05:56', '2026-03-02 17:05:56');

-- Table: permissions
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('1', 'manage users', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('2', 'create orders', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('3', 'process payments', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('4', 'update production', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('5', 'view reports', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('6', 'view click reports', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('7', 'print spk', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('8', 'management access', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('9', 'view customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('10', 'create customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('11', 'edit customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('12', 'delete customers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('13', 'view products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('14', 'create products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('15', 'edit products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('16', 'delete products', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('17', 'view units', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('18', 'manage units', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('19', 'view suppliers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('20', 'manage suppliers', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('21', 'view finance', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('22', 'manage deposits', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('23', 'view stock', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('24', 'manage stock', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('25', 'view materials', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('26', 'manage materials', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('27', 'view expenses', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('28', 'manage expenses', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('29', 'view employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('30', 'create employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('31', 'edit employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('32', 'delete employees', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('33', 'view salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('34', 'create salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('35', 'edit salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('36', 'delete salaries', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('37', 'manage backups', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('38', 'manage payment accounts', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('39', 'request cancellations', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('40', 'approve cancellations', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('41', 'view orders', 'web', '2026-02-10 08:23:29', '2026-02-10 08:23:29');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('42', 'view machines', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('43', 'manage machines', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('44', 'view ai', 'web', '2026-03-02 12:56:49', '2026-03-02 12:56:49');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('45', 'manage settings', 'web', '2026-03-02 12:56:49', '2026-03-02 12:56:49');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('46', 'manage customers', 'web', '2026-03-02 12:56:49', '2026-03-02 12:56:49');

-- Table: product_material
CREATE TABLE `product_material` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `material_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_material_product_id_material_id_unique` (`product_id`,`material_id`),
  KEY `product_material_material_id_foreign` (`material_id`),
  CONSTRAINT `product_material_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_material_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('87', '21', '44', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('88', '21', '45', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('89', '21', '47', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('90', '21', '48', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('91', '21', '49', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('92', '21', '50', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('93', '21', '46', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('94', '21', '55', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('95', '21', '54', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('96', '21', '51', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('97', '21', '52', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('98', '21', '53', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('99', '21', '56', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('100', '21', '58', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('101', '21', '59', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('102', '21', '60', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('103', '21', '57', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('104', '23', '89', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('106', '23', '85', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('107', '23', '86', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('108', '23', '87', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('109', '23', '88', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('110', '22', '64', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('111', '22', '66', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('112', '22', '80', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('113', '22', '61', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('114', '22', '65', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('115', '22', '63', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('116', '22', '77', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('117', '23', '97', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('118', '22', '76', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('119', '22', '78', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('120', '22', '79', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('121', '22', '75', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('122', '22', '83', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('123', '22', '84', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('124', '22', '82', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('125', '22', '81', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('126', '22', '72', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('127', '22', '74', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('128', '22', '73', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('129', '22', '70', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('130', '22', '71', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('131', '21', '90', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('132', '21', '69', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('133', '21', '96', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('134', '21', '95', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('135', '21', '93', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('136', '21', '67', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('137', '21', '68', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('138', '21', '94', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('139', '22', '62', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('140', '24', '92', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('141', '24', '91', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('142', '24', '99', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('143', '24', '98', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('144', '22', '101', NULL, NULL);
INSERT INTO `product_material` (`id`, `product_id`, `material_id`, `created_at`, `updated_at`) VALUES ('145', '25', '103', NULL, NULL);

-- Table: products
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `track_clicks` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_code_unique` (`code`),
  KEY `products_is_active_index` (`is_active`),
  KEY `products_unit_id_foreign` (`unit_id`),
  CONSTRAINT `products_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('21', 'Versant', 'VR0001', NULL, NULL, '1', '1', '2026-02-17 11:16:10', '2026-02-17 11:16:10');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('22', 'Indoor', 'ID0001', NULL, NULL, '1', '0', '2026-02-17 11:16:29', '2026-02-17 11:16:29');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('23', 'Outdoor', 'OD0001', NULL, NULL, '1', '0', '2026-02-17 11:16:49', '2026-02-17 11:16:49');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('24', 'Jasa', 'CUTA3', NULL, NULL, '1', '0', '2026-02-27 13:44:32', '2026-02-27 13:44:32');
INSERT INTO `products` (`id`, `name`, `code`, `description`, `unit_id`, `is_active`, `track_clicks`, `created_at`, `updated_at`) VALUES ('25', 'PROMO KROMO RAMADHAN', 'PKR', NULL, NULL, '1', '0', '2026-03-02 15:48:26', '2026-03-02 15:48:26');

-- Table: purchase_payments
CREATE TABLE `purchase_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_date` date NOT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_payments_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_payments_created_by_foreign` (`created_by`),
  CONSTRAINT `purchase_payments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchase_payments_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: purchases
CREATE TABLE `purchases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) unsigned NOT NULL,
  `purchase_date` date NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `paid_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('unpaid','partial','paid') NOT NULL DEFAULT 'paid',
  `type` enum('satuan','meteran') NOT NULL DEFAULT 'satuan',
  `supplier` varchar(255) DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchases_material_id_foreign` (`material_id`),
  KEY `purchases_created_by_foreign` (`created_by`),
  KEY `purchases_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `purchases_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchases_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: role_has_permissions
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('1', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('1', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('1', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('2', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('3', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('4', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('5', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('6', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('7', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('8', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('9', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('10', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('11', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('12', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('13', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('14', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('15', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('16', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('17', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('18', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('19', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('20', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('21', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('22', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('23', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('24', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('25', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('26', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('27', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('28', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('29', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('30', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('31', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('32', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('33', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('34', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('35', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('36', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('37', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('38', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('39', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('40', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '4');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('41', '7');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('42', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('42', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('42', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('42', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('43', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('43', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('44', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('44', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('44', '6');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('45', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('45', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('46', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('46', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('46', '3');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('46', '5');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('46', '6');

-- Table: roles
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('1', 'developer', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('2', 'owner', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('3', 'designer', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('4', 'kasir', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('5', 'operator', 'web', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('6', 'spv', 'web', '2026-02-10 01:47:14', '2026-02-10 01:47:14');
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ('7', 'Administrasi', 'web', '2026-02-27 01:29:49', '2026-02-27 01:29:49');

-- Table: salaries
CREATE TABLE `salaries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `period` varchar(255) NOT NULL,
  `base_salary` decimal(12,2) NOT NULL DEFAULT 0.00,
  `allowance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `overtime` decimal(12,2) NOT NULL DEFAULT 0.00,
  `bonus` decimal(12,2) NOT NULL DEFAULT 0.00,
  `deduction` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `notes` text DEFAULT NULL,
  `status` enum('draft','paid') NOT NULL DEFAULT 'draft',
  `paid_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `salaries_employee_id_period_unique` (`employee_id`,`period`),
  CONSTRAINT `salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: sessions
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('1tQokD0rVx5xfmrVbwuzpSB0lxoCCT3BZPtL55lz', '24', '36.68.127.235', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNU9wT3ZQMjNoZlVRSmtERnE3UW5KbG5YSExIUVVUWmxPYVN2cE96TyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM1OiJodHRwOi8vcG9zLmVya2FncmFwaGlhLmNvbS9wcm9kdWtzaSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI0O30=', '1772457199');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('58geTTJaXyGTIa8mIpwccVgofheAowTnmtB6Hqq4', '8', '114.10.103.128', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicXZ6Q0psd0xockg2TWRBaFRoOW82bEVmRDQwbWxnREY1Wk5UdEtFeiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6ODtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNToiaHR0cHM6Ly9wb3MuZXJrYWdyYXBoaWEuY29tL2JhY2t1cHMiO319', '1772458468');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('CiCewP8jLon3n0aNBMfYvBEPLNp53y3QZg0Yj9vi', '1', '103.87.228.98', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTEsyNWdoY2FhTzBEd21lR2cxdW9jZzd5MmZ0ZnBoOEVxV1pEOTFsZCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMzOiJodHRwczovL3Bvcy5lcmthZ3JhcGhpYS5jb20vcm9sZXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', '1772457993');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('EEQasSSZgUH3Q5VmXzcmKusYu6viIHCdFfgIcnwp', NULL, '36.50.157.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Mobile Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiemdLajBYbGZpcUtiTWJ2cTVjSUw5NXRxdWRYaVhnckozazJQUGxuZyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNzoiaHR0cHM6Ly9wb3MuZXJrYWdyYXBoaWEuY29tL3B1cmNoYXNlcyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMzOiJodHRwczovL3Bvcy5lcmthZ3JhcGhpYS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1772453054');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('MaVFC57hvpBk5UHJkkNUl4PWRm5QEW5Grt7TUUlP', '1', '103.87.228.98', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQ0RrbmxQRktFazBndGhRa1BhVFBENGNWa2FONjNzVG9PYmlKQkhnZiI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ2OiJodHRwczovL3Bvcy5lcmthZ3JhcGhpYS5jb20vcmVwb3J0cy9uZXQtaW5jb21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', '1772454797');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('VQxh9gBRWAuHh7d8jrAaSuQWLivcKroZqUpRfd42', '21', '103.3.220.155', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTEZySnpmN1VOZmhwNWlRNXlzMVMwVjV3UFd1bTN3VXQwVWpLcVdDSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHBzOi8vcG9zLmVya2FncmFwaGlhLmNvbS9vcGVyYXRvci9kYXNoYm9hcmQvbGl2ZT9zaW5jZV9pZD0xMjIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjM6InVybCI7YTowOnt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjE7fQ==', '1772450038');

-- Table: settings
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('1', 'shop_name', 'Erkagraphia', 'shop', '2026-02-09 13:27:05', '2026-02-28 08:09:51');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('2', 'shop_address', 'Jl. Rambutan No.1 B, Pasir Gintung, Kec. Tj. Karang Pusat, Kota Bandar Lampung, Lampung 35127', 'shop', '2026-02-09 13:27:05', '2026-02-28 08:09:51');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('3', 'shop_phone', '0823-3733-1391', 'shop', '2026-02-09 13:27:05', '2026-02-28 08:09:52');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('4', 'shop_whatsapp', '0812-3456-7890', 'shop', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('5', 'shop_email', 'order@posgraf.com', 'shop', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('6', 'shop_footer', 'Terima kasih atas kepercayaan Anda! Barang yang sudah dipesan tidak dapat dikembalikan dan jika anda ingin mengecek status pesanan anda silakan scan barcode nota ini.', 'shop', '2026-02-09 13:27:05', '2026-02-17 21:18:30');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('7', 'shop_instagram', '@posgraf_printing', 'social', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('8', 'shop_logo', 'logos/logo-full.png', 'shop', '2026-02-12 18:16:25', '2026-02-12 18:16:25');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('9', 'shop_logo_icon', 'logos/logo-icon.PNG', 'shop', '2026-02-12 18:16:25', '2026-02-27 00:41:48');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('10', 'wa_template', 'Halo Kak *{nama}*,

Kami ingin menginformasikan bahwa orderan Kakak sudah *selesai* dan *siap diambil* ya.

*Detail Order:*
- No. Invoice: *{invoice}*
- Tanggal Order: {tanggal}

Ditunggu kedatangannya, terima kasih!', 'wa', '2026-02-12 18:16:25', '2026-02-12 18:16:25');
INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('11', 'wa_template_piutang', '- Sisa Pembayaran: Rp {sisa}

Mohon untuk dapat melunasi sisa pembayaran saat pengambilan ya Kak.', 'wa', '2026-02-12 18:16:25', '2026-02-12 18:16:25');

-- Table: stock_movements
CREATE TABLE `stock_movements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` bigint(20) unsigned NOT NULL,
  `type` enum('in','out','damaged','adjustment') NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `reference_type` varchar(255) DEFAULT NULL,
  `reference_id` bigint(20) unsigned DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stock_movements_user_id_foreign` (`user_id`),
  KEY `stock_movements_material_id_type_index` (`material_id`,`type`),
  KEY `stock_movements_reference_type_reference_id_index` (`reference_type`,`reference_id`),
  CONSTRAINT `stock_movements_material_id_foreign` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `stock_movements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('14', '62', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '9', 'Order #INV-20260227-0001 - kunyuk', '1', '2026-02-27 13:56:04', '2026-02-27 13:56:04');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('15', '62', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '10', 'Order #INV-20260227-0002 - Fajar rk', '1', '2026-02-27 14:17:50', '2026-02-27 14:17:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('16', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '11', 'Order #INV-20260228-0001 - xxx', '3', '2026-02-28 08:22:00', '2026-02-28 08:22:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('17', '47', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '12', 'Order #INV-20260228-0002 - aaa', '3', '2026-02-28 08:24:00', '2026-02-28 08:24:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('18', '62', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '13', 'Order #INV-20260228-0003 - asda', '3', '2026-02-28 08:28:34', '2026-02-28 08:28:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('19', '47', 'out', '111.00', '0.00', '0.00', 'App\\Models\\Order', '14', 'Order #INV-20260228-0004 - xx', '1', '2026-02-28 08:30:48', '2026-02-28 08:30:48');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('20', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '15', 'Order #INV-20260228-0005 - aaaa', '1', '2026-02-28 09:19:32', '2026-02-28 09:19:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('21', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '16', 'Order #INV-20260228-0006 - jhjh', '1', '2026-02-28 09:21:13', '2026-02-28 09:21:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('22', '61', 'in', '680.00', '18000.00', '12240000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:36:25', '2026-02-28 16:36:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('23', '101', 'in', '60.00', '20000.00', '1200000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:43:07', '2026-02-28 16:43:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('24', '64', 'in', '55.00', '45000.00', '2475000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:43:37', '2026-02-28 16:43:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('25', '62', 'in', '150.00', '15000.00', '2250000.00', NULL, NULL, 'visi media', '8', '2026-02-28 16:44:25', '2026-02-28 16:44:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('26', '63', 'in', '180.00', '18000.00', '3240000.00', NULL, NULL, NULL, '8', '2026-02-28 16:45:11', '2026-02-28 16:45:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('27', '66', 'in', '40.00', '2600.00', '104000.00', NULL, NULL, 'visi media', '8', '2026-02-28 16:45:57', '2026-02-28 16:45:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('28', '82', 'in', '820.00', '8500.00', '6970000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:47:11', '2026-02-28 16:47:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('29', '81', 'in', '490.00', '8500.00', '4165000.00', NULL, NULL, 'prinmate', '8', '2026-02-28 16:52:41', '2026-02-28 16:52:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('31', '65', 'in', '35.00', '45000.00', '1575000.00', NULL, NULL, 'visi media', '8', '2026-03-01 07:05:22', '2026-03-01 07:05:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('32', '70', 'in', '27.00', '21000.00', '567000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:10:32', '2026-03-01 07:10:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('33', '71', 'in', '21.00', '35000.00', '735000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:11:11', '2026-03-01 07:11:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('34', '74', 'in', '3.00', '75000.00', '225000.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 07:11:52', '2026-03-01 07:11:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('35', '76', 'in', '95.00', '12000.00', '1140000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:14:24', '2026-03-01 07:14:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('36', '77', 'in', '50.00', '35000.00', '1750000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:15:21', '2026-03-01 07:15:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('37', '79', 'in', '1.00', '130000.00', '130000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:16:12', '2026-03-01 07:16:12');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('38', '80', 'in', '120.00', '11000.00', '1320000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:27:57', '2026-03-01 07:27:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('39', '85', 'in', '722.00', '5700.00', '4115400.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:28:59', '2026-03-01 07:28:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('40', '86', 'in', '120.00', '7700.00', '924000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:29:33', '2026-03-01 07:29:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('41', '87', 'in', '265.00', '19000.00', '5035000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 07:30:51', '2026-03-01 07:30:51');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('42', '88', 'in', '95.00', '18000.00', '1710000.00', NULL, NULL, NULL, '8', '2026-03-01 07:31:35', '2026-03-01 07:31:35');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('43', '89', 'in', '160.00', '21500.00', '3440000.00', NULL, NULL, NULL, '8', '2026-03-01 07:32:15', '2026-03-01 07:32:15');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('44', '44', 'in', '700.00', '365.00', '255500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:33:32', '2026-03-01 07:33:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('45', '45', 'in', '1395.00', '455.00', '634725.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:34:22', '2026-03-01 07:34:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('46', '46', 'in', '375.00', '575.00', '215625.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:34:57', '2026-03-01 07:34:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('47', '48', 'in', '750.00', '775.00', '581250.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:35:44', '2026-03-01 07:35:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('49', '49', 'in', '230.00', '889.00', '204470.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:42:54', '2026-03-01 07:42:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('50', '50', 'in', '300.00', '965.00', '289500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:49:34', '2026-03-01 07:49:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('51', '51', 'in', '1000.00', '242.00', '242000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:50:36', '2026-03-01 07:50:36');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('52', '53', 'in', '220.00', '1625.00', '357500.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:51:08', '2026-03-01 07:51:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('53', '55', 'in', '345.00', '1088.00', '375360.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:51:58', '2026-03-01 07:51:58');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('54', '56', 'in', '31.00', '3900.00', '120900.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:52:23', '2026-03-01 07:52:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('55', '57', 'in', '35535.00', '1018.00', '36174630.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:53:22', '2026-03-01 07:53:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('56', '58', 'in', '2914.00', '1018.00', '2966452.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:54:00', '2026-03-01 07:54:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('57', '59', 'in', '3250.00', '2477.00', '8050250.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:55:22', '2026-03-01 07:55:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('58', '60', 'in', '1085.00', '2477.00', '2687545.00', NULL, NULL, 'DSI', '8', '2026-03-01 07:56:05', '2026-03-01 07:56:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('59', '69', 'in', '1.00', '10000.00', '10000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 07:57:25', '2026-03-01 07:57:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('60', '68', 'in', '1250.00', '145.00', '181250.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:02:23', '2026-03-01 08:02:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('61', '67', 'in', '7500.00', '145.00', '1087500.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:02:59', '2026-03-01 08:02:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('62', '52', 'in', '225.00', '525.00', '118125.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 08:03:31', '2026-03-01 08:03:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('63', '93', 'in', '750.00', '250.00', '187500.00', NULL, NULL, 'BINTANG TERANG', '8', '2026-03-01 08:04:05', '2026-03-01 08:04:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('64', '54', 'in', '480.00', '1425.00', '684000.00', NULL, NULL, 'INDAH SARI ABADI', '8', '2026-03-01 08:06:55', '2026-03-01 08:06:55');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('65', '102', 'in', '1.00', '460000.00', '460000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:07:50', '2026-03-01 08:07:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('66', '72', 'in', '1.00', '105000.00', '105000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:20:45', '2026-03-01 08:20:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('67', '73', 'in', '7.00', '130000.00', '910000.00', NULL, NULL, 'VISI MEDIA', '8', '2026-03-01 08:22:44', '2026-03-01 08:22:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('68', '94', 'in', '50.00', '1000.00', '50000.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 08:23:39', '2026-03-01 08:23:39');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('69', '91', 'in', '100000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:24:21', '2026-03-01 10:24:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('70', '92', 'in', '100000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:25:30', '2026-03-01 10:25:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('71', '98', 'in', '10000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:26:05', '2026-03-01 10:26:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('72', '99', 'in', '10000000000.00', '0.00', '0.00', NULL, NULL, 'ONLINE', '8', '2026-03-01 10:26:45', '2026-03-01 10:26:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('73', '59', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '17', 'Order #INV-20260302-0001 - relya kemiri', '20', '2026-03-02 10:08:57', '2026-03-02 10:08:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('74', '68', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '17', 'Order #INV-20260302-0001 - relya kemiri', '20', '2026-03-02 10:08:57', '2026-03-02 10:08:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('75', '60', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - glow beauty', '3', '2026-03-02 10:10:46', '2026-03-02 10:10:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('76', '57', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - pipito', '3', '2026-03-02 10:10:46', '2026-03-02 10:10:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('77', '57', 'out', '11.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - pipito sedang', '3', '2026-03-02 10:10:46', '2026-03-02 10:10:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('78', '57', 'out', '7.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - azzae', '3', '2026-03-02 10:10:46', '2026-03-02 10:10:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('79', '57', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - cahaya rs', '3', '2026-03-02 10:10:46', '2026-03-02 10:10:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('80', '59', 'in', '20.00', '0.00', '0.00', 'App\\Models\\Order', '17', 'Stok dikembalikan - Edit Order #INV-20260302-0001', '20', '2026-03-02 10:12:13', '2026-03-02 10:12:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('81', '68', 'in', '20.00', '0.00', '0.00', 'App\\Models\\Order', '17', 'Stok dikembalikan - Edit Order #INV-20260302-0001', '20', '2026-03-02 10:12:13', '2026-03-02 10:12:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('82', '91', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '17', 'Order #INV-20260302-0001 - relya kemiri', '20', '2026-03-02 10:12:13', '2026-03-02 10:12:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('83', '60', 'in', '4.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('84', '57', 'in', '6.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('85', '57', 'in', '11.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('86', '57', 'in', '7.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('87', '57', 'in', '10.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('88', '48', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Order #INV-20260302-0002 - ria zulian', '3', '2026-03-02 10:12:52', '2026-03-02 10:12:52');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('89', '48', 'in', '1.00', '0.00', '0.00', 'App\\Models\\Order', '18', 'Stok dikembalikan - Edit Order #INV-20260302-0002', '3', '2026-03-02 10:13:24', '2026-03-02 10:13:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('90', '51', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '19', 'Order #INV-20260302-0003 - dinamika 0302', '19', '2026-03-02 10:18:14', '2026-03-02 10:18:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('91', '51', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '19', 'Order #INV-20260302-0003 - sekabar', '19', '2026-03-02 10:18:14', '2026-03-02 10:18:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('92', '57', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '20', 'Order #INV-20260302-0004 - maps sc', '20', '2026-03-02 10:20:34', '2026-03-02 10:20:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('93', '91', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '20', 'Order #INV-20260302-0004 - maps sc', '20', '2026-03-02 10:20:34', '2026-03-02 10:20:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('94', '85', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '21', 'Order #INV-20260302-0005 - PATRA NIAGA', '3', '2026-03-02 10:32:24', '2026-03-02 10:32:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('95', '85', 'out', '2.40', '0.00', '0.00', 'App\\Models\\Order', '21', 'Order #INV-20260302-0005 - PATRA NIAGA 2', '3', '2026-03-02 10:32:24', '2026-03-02 10:32:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('96', '85', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '21', 'Order #INV-20260302-0005 - PANGKALAN', '3', '2026-03-02 10:32:24', '2026-03-02 10:32:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('97', '85', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '21', 'Order #INV-20260302-0005 - AGEN LPG', '3', '2026-03-02 10:32:24', '2026-03-02 10:32:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('98', '44', 'out', '12.00', '0.00', '0.00', 'App\\Models\\Order', '22', 'Order #INV-20260302-0006 - lalabelt', '20', '2026-03-02 10:34:05', '2026-03-02 10:34:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('99', '44', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '23', 'Order #INV-20260302-0007 - argarian', '19', '2026-03-02 10:35:30', '2026-03-02 10:35:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('100', '57', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '24', 'Order #INV-20260302-0008 - vans', '3', '2026-03-02 10:37:42', '2026-03-02 10:37:42');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('101', '57', 'out', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Order #INV-20260302-0009 - lk you', '20', '2026-03-02 10:45:54', '2026-03-02 10:45:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('102', '68', 'out', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Order #INV-20260302-0009 - lk you', '20', '2026-03-02 10:45:54', '2026-03-02 10:45:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('103', '91', 'out', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Order #INV-20260302-0009 - lk you', '20', '2026-03-02 10:45:54', '2026-03-02 10:45:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('104', '57', 'in', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Stok dikembalikan - Edit Order #INV-20260302-0009', '20', '2026-03-02 10:46:31', '2026-03-02 10:46:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('105', '68', 'in', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Stok dikembalikan - Edit Order #INV-20260302-0009', '20', '2026-03-02 10:46:31', '2026-03-02 10:46:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('106', '91', 'in', '15.00', '0.00', '0.00', 'App\\Models\\Order', '25', 'Stok dikembalikan - Edit Order #INV-20260302-0009', '20', '2026-03-02 10:46:31', '2026-03-02 10:46:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('107', '58', 'out', '100.00', '0.00', '0.00', 'App\\Models\\Order', '26', 'Order #INV-20260302-0010 - krenyess', '3', '2026-03-02 10:51:22', '2026-03-02 10:51:22');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('108', '58', 'in', '100.00', '0.00', '0.00', 'App\\Models\\Order', '26', 'Stok dikembalikan - Edit Order #INV-20260302-0010', '3', '2026-03-02 10:52:10', '2026-03-02 10:52:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('109', '57', 'out', '100.00', '0.00', '0.00', 'App\\Models\\Order', '26', 'Order #INV-20260302-0010 - krenyess', '3', '2026-03-02 10:52:10', '2026-03-02 10:52:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('110', '48', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '27', 'Order #INV-20260302-0011 - beny daryono', '20', '2026-03-02 10:56:30', '2026-03-02 10:56:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('111', '57', 'out', '30.00', '0.00', '0.00', 'App\\Models\\Order', '28', 'Order #INV-20260302-0012 - si biru new x7 MUDIN', '23', '2026-03-02 11:07:09', '2026-03-02 11:07:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('112', '48', 'out', '40.00', '0.00', '0.00', 'App\\Models\\Order', '28', 'Order #INV-20260302-0012 - enyong lure MUDIN', '23', '2026-03-02 11:07:09', '2026-03-02 11:07:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('113', '53', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '29', 'Order #INV-20260302-0013 - yanvaldi', '20', '2026-03-02 11:07:41', '2026-03-02 11:07:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('114', '48', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '30', 'Order #INV-20260302-0014 - balai busana', '19', '2026-03-02 11:09:09', '2026-03-02 11:09:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('115', '57', 'in', '30.00', '0.00', '0.00', 'App\\Models\\Order', '28', 'Stok dikembalikan - Edit Order #INV-20260302-0012', '19', '2026-03-02 11:11:28', '2026-03-02 11:11:28');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('116', '48', 'in', '40.00', '0.00', '0.00', 'App\\Models\\Order', '28', 'Stok dikembalikan - Edit Order #INV-20260302-0012', '19', '2026-03-02 11:11:28', '2026-03-02 11:11:28');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('117', '44', 'in', '8.00', '0.00', '0.00', 'App\\Models\\Order', '23', 'Stok dikembalikan - Edit Order #INV-20260302-0007', '19', '2026-03-02 11:11:58', '2026-03-02 11:11:58');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('118', '47', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '31', 'Order #INV-20260302-0015 - nonome', '20', '2026-03-02 11:14:44', '2026-03-02 11:14:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('119', '61', 'out', '0.60', '0.00', '0.00', 'App\\Models\\Order', '32', 'Order #INV-20260302-0016 - foto anak kecil', '3', '2026-03-02 11:15:31', '2026-03-02 11:15:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('120', '90', 'out', '14.00', '0.00', '0.00', 'App\\Models\\Order', '33', 'Order #INV-20260302-0017 - fashionbie & ukong', '3', '2026-03-02 11:19:01', '2026-03-02 11:19:01');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('121', '57', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '33', 'Order #INV-20260302-0017 - fashionbie & ukong', '3', '2026-03-02 11:19:01', '2026-03-02 11:19:01');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('122', '51', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '34', 'Order #INV-20260302-0018 - rs medika 1', '3', '2026-03-02 11:22:59', '2026-03-02 11:22:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('123', '87', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '35', 'Order #INV-20260302-0019 - MA FASION', '20', '2026-03-02 11:23:12', '2026-03-02 11:23:12');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('124', '51', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '36', 'Order #INV-20260302-0020 - ny ririn', '19', '2026-03-02 11:24:31', '2026-03-02 11:24:31');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('125', '45', 'out', '7.00', '0.00', '0.00', 'App\\Models\\Order', '37', 'Order #INV-20260302-0021 - eid mubarak', '3', '2026-03-02 11:26:02', '2026-03-02 11:26:02');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('126', '85', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '38', 'Order #INV-20260302-0022 - PT HAIDA', '20', '2026-03-02 11:27:14', '2026-03-02 11:27:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('127', '57', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '39', 'Order #INV-20260302-0023 - bunda delicious', '19', '2026-03-02 11:32:07', '2026-03-02 11:32:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('128', '91', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '39', 'Order #INV-20260302-0023 - bunda delicious', '19', '2026-03-02 11:32:07', '2026-03-02 11:32:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('129', '86', 'out', '25.00', '0.00', '0.00', 'App\\Models\\Order', '40', 'Order #INV-20260302-0024 - PT ANUGERAH 1', '3', '2026-03-02 11:32:25', '2026-03-02 11:32:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('130', '57', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '41', 'Order #INV-20260302-0025 - zuhri farm', '19', '2026-03-02 11:37:51', '2026-03-02 11:37:51');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('131', '91', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '41', 'Order #INV-20260302-0025 - zuhri farm', '19', '2026-03-02 11:37:51', '2026-03-02 11:37:51');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('132', '57', 'out', '15.00', '0.00', '0.00', 'App\\Models\\Order', '42', 'Order #INV-20260302-0026 - tisa cookies', '20', '2026-03-02 11:39:37', '2026-03-02 11:39:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('133', '61', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Order #INV-20260302-0027 - kopdeskel', '3', '2026-03-02 11:39:54', '2026-03-02 11:39:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('134', '82', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Order #INV-20260302-0027 - kopdeskel', '3', '2026-03-02 11:39:54', '2026-03-02 11:39:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('135', '98', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Order #INV-20260302-0027 - kopdeskel', '3', '2026-03-02 11:39:54', '2026-03-02 11:39:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('136', '85', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '44', 'Order #INV-20260302-0028 - kejora 01', '19', '2026-03-02 11:41:34', '2026-03-02 11:41:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('137', '85', 'out', '3.70', '0.00', '0.00', 'App\\Models\\Order', '44', 'Order #INV-20260302-0028 - kejora 02-03', '19', '2026-03-02 11:41:34', '2026-03-02 11:41:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('138', '85', 'out', '1.46', '0.00', '0.00', 'App\\Models\\Order', '44', 'Order #INV-20260302-0028 - kejora 04', '19', '2026-03-02 11:41:34', '2026-03-02 11:41:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('139', '61', 'in', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Stok dikembalikan - Batal Order #INV-20260302-0027', '8', '2026-03-02 11:42:43', '2026-03-02 11:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('140', '82', 'in', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Stok dikembalikan - Batal Order #INV-20260302-0027', '8', '2026-03-02 11:42:43', '2026-03-02 11:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('141', '98', 'in', '0.85', '0.00', '0.00', 'App\\Models\\Order', '43', 'Stok dikembalikan - Batal Order #INV-20260302-0027', '8', '2026-03-02 11:42:43', '2026-03-02 11:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('142', '44', 'out', '7.00', '0.00', '0.00', 'App\\Models\\Order', '45', 'Order #INV-20260302-0029 - BI INUK FOTO', '20', '2026-03-02 11:45:32', '2026-03-02 11:45:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('143', '61', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '46', 'Order #INV-20260302-0030 - kopdeskel', '3', '2026-03-02 11:46:14', '2026-03-02 11:46:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('144', '82', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '46', 'Order #INV-20260302-0030 - kopdeskel', '3', '2026-03-02 11:46:14', '2026-03-02 11:46:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('145', '98', 'out', '0.85', '0.00', '0.00', 'App\\Models\\Order', '46', 'Order #INV-20260302-0030 - kopdeskel', '3', '2026-03-02 11:46:14', '2026-03-02 11:46:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('146', '85', 'out', '6.96', '0.00', '0.00', 'App\\Models\\Order', '47', 'Order #INV-20260302-0031 - cover gate sensor 84x138cm (1)', '23', '2026-03-02 11:47:26', '2026-03-02 11:47:26');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('147', '61', 'out', '0.30', '0.00', '0.00', 'App\\Models\\Order', '47', 'Order #INV-20260302-0031 - pintu darurat exit', '23', '2026-03-02 11:47:26', '2026-03-02 11:47:26');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('148', '85', 'in', '6.96', '0.00', '0.00', 'App\\Models\\Order', '47', 'Stok dikembalikan - Edit Order #INV-20260302-0031', '23', '2026-03-02 11:47:49', '2026-03-02 11:47:49');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('149', '61', 'in', '0.30', '0.00', '0.00', 'App\\Models\\Order', '47', 'Stok dikembalikan - Edit Order #INV-20260302-0031', '23', '2026-03-02 11:47:49', '2026-03-02 11:47:49');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('150', '61', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '48', 'Order #INV-20260302-0032 - hmg', '3', '2026-03-02 11:50:11', '2026-03-02 11:50:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('151', '81', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '48', 'Order #INV-20260302-0032 - hmg', '3', '2026-03-02 11:50:11', '2026-03-02 11:50:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('152', '99', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '48', 'Order #INV-20260302-0032 - hmg', '3', '2026-03-02 11:50:11', '2026-03-02 11:50:11');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('153', '57', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '49', 'Order #INV-20260302-0033 - prz vanila', '19', '2026-03-02 11:51:08', '2026-03-02 11:51:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('154', '91', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '49', 'Order #INV-20260302-0033 - prz vanila', '19', '2026-03-02 11:51:08', '2026-03-02 11:51:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('155', '47', 'out', '13.00', '0.00', '0.00', 'App\\Models\\Order', '50', 'Order #INV-20260302-0034 - RADIF', '3', '2026-03-02 11:52:25', '2026-03-02 11:52:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('156', '85', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '51', 'Order #INV-20260302-0035 - TEMBESU', '3', '2026-03-02 11:55:56', '2026-03-02 11:55:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('157', '57', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '52', 'Order #INV-20260302-0036 - es bubur sumsum', '19', '2026-03-02 11:57:03', '2026-03-02 11:57:03');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('158', '91', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '52', 'Order #INV-20260302-0036 - es bubur sumsum', '19', '2026-03-02 11:57:03', '2026-03-02 11:57:03');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('159', '85', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '53', 'Order #INV-20260302-0037 - SPBU SIAGA 0302', '3', '2026-03-02 11:57:47', '2026-03-02 11:57:47');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('160', '61', 'out', '6.97', '0.00', '0.00', 'App\\Models\\Order', '54', 'Order #INV-20260302-0038 - STIKER JEFRAN 1', '3', '2026-03-02 12:00:54', '2026-03-02 12:00:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('161', '82', 'out', '6.97', '0.00', '0.00', 'App\\Models\\Order', '54', 'Order #INV-20260302-0038 - STIKER JEFRAN 1', '3', '2026-03-02 12:00:54', '2026-03-02 12:00:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('162', '57', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '55', 'Order #INV-20260302-0039 - kripik n3', '19', '2026-03-02 12:01:36', '2026-03-02 12:01:36');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('163', '91', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '55', 'Order #INV-20260302-0039 - kripik n3', '19', '2026-03-02 12:01:36', '2026-03-02 12:01:36');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('164', '47', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '56', 'Order #INV-20260302-0040 - jourell', '3', '2026-03-02 12:03:01', '2026-03-02 12:03:01');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('165', '57', 'out', '70.00', '0.00', '0.00', 'App\\Models\\Order', '57', 'Order #INV-20260302-0041 - BAGUS RAMADI ASPAL', '23', '2026-03-02 12:04:00', '2026-03-02 12:04:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('166', '57', 'in', '70.00', '0.00', '0.00', 'App\\Models\\Order', '57', 'Stok dikembalikan - Edit Order #INV-20260302-0041', '23', '2026-03-02 12:04:29', '2026-03-02 12:04:29');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('167', '85', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '58', 'Order #INV-20260302-0042 - kunjungan', '19', '2026-03-02 12:04:35', '2026-03-02 12:04:35');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('168', '47', 'out', '22.00', '0.00', '0.00', 'App\\Models\\Order', '59', 'Order #INV-20260302-0043 - kotrek 1', '3', '2026-03-02 12:06:25', '2026-03-02 12:06:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('169', '57', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '59', 'Order #INV-20260302-0043 - dua putri 0203', '3', '2026-03-02 12:06:25', '2026-03-02 12:06:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('170', '91', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '59', 'Order #INV-20260302-0043 - dua putri 0203', '3', '2026-03-02 12:06:25', '2026-03-02 12:06:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('171', '57', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '60', 'Order #INV-20260302-0044 - tungku ikol kue', '19', '2026-03-02 12:08:33', '2026-03-02 12:08:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('172', '91', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '60', 'Order #INV-20260302-0044 - tungku ikol kue', '19', '2026-03-02 12:08:33', '2026-03-02 12:08:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('173', '59', 'out', '19.00', '0.00', '0.00', 'App\\Models\\Order', '61', 'Order #INV-20260302-0045 - from 0203', '3', '2026-03-02 12:08:53', '2026-03-02 12:08:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('174', '68', 'out', '19.00', '0.00', '0.00', 'App\\Models\\Order', '61', 'Order #INV-20260302-0045 - from 0203', '3', '2026-03-02 12:08:53', '2026-03-02 12:08:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('175', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '62', 'Order #INV-20260302-0046 - agz 0203', '3', '2026-03-02 12:10:33', '2026-03-02 12:10:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('176', '57', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '63', 'Order #INV-20260302-0047 - wannagive campur', '23', '2026-03-02 12:16:44', '2026-03-02 12:16:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('177', '47', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '63', 'Order #INV-20260302-0047 - wannagive campur', '23', '2026-03-02 12:16:44', '2026-03-02 12:16:44');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('178', '87', 'out', '10.50', '0.00', '0.00', 'App\\Models\\Order', '64', 'Order #INV-20260302-0048 - KRAKOTA', '20', '2026-03-02 12:50:33', '2026-03-02 12:50:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('179', '87', 'in', '10.50', '0.00', '0.00', 'App\\Models\\Order', '64', 'Stok dikembalikan - Edit Order #INV-20260302-0048', '20', '2026-03-02 12:50:47', '2026-03-02 12:50:47');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('180', '54', 'out', '50.00', '0.00', '0.00', 'App\\Models\\Order', '65', 'Order #INV-20260302-0049 - xu ping ok', '20', '2026-03-02 13:00:18', '2026-03-02 13:00:18');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('181', '54', 'in', '50.00', '0.00', '0.00', 'App\\Models\\Order', '65', 'Stok dikembalikan - Edit Order #INV-20260302-0049', '20', '2026-03-02 13:01:21', '2026-03-02 13:01:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('182', '57', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '66', 'Order #INV-20260302-0050 - warung snack', '19', '2026-03-02 13:02:17', '2026-03-02 13:02:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('183', '91', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '66', 'Order #INV-20260302-0050 - warung snack', '19', '2026-03-02 13:02:17', '2026-03-02 13:02:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('184', '44', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '67', 'Order #INV-20260302-0051 - ABAH AING', '20', '2026-03-02 13:04:06', '2026-03-02 13:04:06');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('185', '47', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '68', 'Order #INV-20260302-0052 - rizki steven', '19', '2026-03-02 13:04:47', '2026-03-02 13:04:47');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('186', '47', 'out', '4.00', '0.00', '0.00', 'App\\Models\\Order', '69', 'Order #INV-20260302-0053 - idul fitri 0203', '19', '2026-03-02 13:06:21', '2026-03-02 13:06:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('187', '85', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '70', 'Order #INV-20260302-0054 - AL MUKMIN', '20', '2026-03-02 13:07:38', '2026-03-02 13:07:38');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('188', '59', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '71', 'Order #INV-20260302-0055 - Glowing sunscreen', '3', '2026-03-02 13:07:53', '2026-03-02 13:07:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('189', '59', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '71', 'Order #INV-20260302-0055 - new boosting white', '3', '2026-03-02 13:07:53', '2026-03-02 13:07:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('190', '85', 'out', '3.75', '0.00', '0.00', 'App\\Models\\Order', '72', 'Order #INV-20260302-0056 - HUT PWKI', '20', '2026-03-02 13:10:09', '2026-03-02 13:10:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('191', '85', 'in', '3.75', '0.00', '0.00', 'App\\Models\\Order', '72', 'Stok dikembalikan - Edit Order #INV-20260302-0056', '20', '2026-03-02 13:10:20', '2026-03-02 13:10:20');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('192', '57', 'out', '50.00', '0.00', '0.00', 'App\\Models\\Order', '73', 'Order #INV-20260302-0057 - mayang sari 0203', '19', '2026-03-02 13:12:35', '2026-03-02 13:12:35');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('193', '91', 'out', '50.00', '0.00', '0.00', 'App\\Models\\Order', '73', 'Order #INV-20260302-0057 - mayang sari 0203', '19', '2026-03-02 13:12:35', '2026-03-02 13:12:35');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('194', '59', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '74', 'Order #INV-20260302-0058 - kementerian', '3', '2026-03-02 13:13:07', '2026-03-02 13:13:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('195', '68', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '74', 'Order #INV-20260302-0058 - kementerian', '3', '2026-03-02 13:13:07', '2026-03-02 13:13:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('196', '91', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '74', 'Order #INV-20260302-0058 - kementerian', '3', '2026-03-02 13:13:07', '2026-03-02 13:13:07');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('197', '47', 'out', '80.00', '0.00', '0.00', 'App\\Models\\Order', '75', 'Order #INV-20260302-0059 - restu siska 210', '23', '2026-03-02 13:17:30', '2026-03-02 13:17:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('198', '47', 'in', '80.00', '0.00', '0.00', 'App\\Models\\Order', '75', 'Stok dikembalikan - Edit Order #INV-20260302-0059', '23', '2026-03-02 13:18:02', '2026-03-02 13:18:02');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('199', '59', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '76', 'Order #INV-20260302-0060 - symphony stiker', '19', '2026-03-02 13:20:42', '2026-03-02 13:20:42');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('200', '68', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '76', 'Order #INV-20260302-0060 - symphony stiker', '19', '2026-03-02 13:20:42', '2026-03-02 13:20:42');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('201', '91', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '76', 'Order #INV-20260302-0060 - symphony stiker', '19', '2026-03-02 13:20:42', '2026-03-02 13:20:42');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('202', '85', 'out', '0.80', '0.00', '0.00', 'App\\Models\\Order', '77', 'Order #INV-20260302-0061 - STOP A- STOP B', '20', '2026-03-02 13:24:06', '2026-03-02 13:24:06');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('203', '85', 'in', '0.80', '0.00', '0.00', 'App\\Models\\Order', '77', 'Stok dikembalikan - Edit Order #INV-20260302-0061', '20', '2026-03-02 13:24:23', '2026-03-02 13:24:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('204', '50', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '78', 'Order #INV-20260302-0062 - SI MANIS 310', '23', '2026-03-02 13:25:56', '2026-03-02 13:25:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('205', '57', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '78', 'Order #INV-20260302-0062 - si manis hijau new', '23', '2026-03-02 13:25:56', '2026-03-02 13:25:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('206', '57', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '79', 'Order #INV-20260302-0063 - ngabubu thrift (@3 lembar)', '19', '2026-03-02 13:30:08', '2026-03-02 13:30:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('207', '91', 'out', '6.00', '0.00', '0.00', 'App\\Models\\Order', '79', 'Order #INV-20260302-0063 - ngabubu thrift', '19', '2026-03-02 13:30:08', '2026-03-02 13:30:08');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('208', '61', 'out', '1.48', '0.00', '0.00', 'App\\Models\\Order', '80', 'Order #INV-20260302-0064 - dilarang 1', '3', '2026-03-02 13:31:21', '2026-03-02 13:31:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('209', '81', 'out', '1.48', '0.00', '0.00', 'App\\Models\\Order', '80', 'Order #INV-20260302-0064 - dilarang 1', '3', '2026-03-02 13:31:21', '2026-03-02 13:31:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('210', '61', 'out', '1.01', '0.00', '0.00', 'App\\Models\\Order', '80', 'Order #INV-20260302-0064 - spbu 0203', '3', '2026-03-02 13:31:21', '2026-03-02 13:31:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('211', '81', 'out', '1.01', '0.00', '0.00', 'App\\Models\\Order', '80', 'Order #INV-20260302-0064 - spbu 0203', '3', '2026-03-02 13:31:21', '2026-03-02 13:31:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('212', '59', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '81', 'Order #INV-20260302-0065 - bybels', '20', '2026-03-02 13:39:18', '2026-03-02 13:39:18');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('213', '91', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '81', 'Order #INV-20260302-0065 - bybels', '20', '2026-03-02 13:39:18', '2026-03-02 13:39:18');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('214', '57', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '82', 'Order #INV-20260302-0066 - wanga 0203', '19', '2026-03-02 13:41:20', '2026-03-02 13:41:20');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('215', '57', 'in', '8.00', '0.00', '0.00', 'App\\Models\\Order', '82', 'Stok dikembalikan - Edit Order #INV-20260302-0066', '19', '2026-03-02 13:42:43', '2026-03-02 13:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('216', '57', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '82', 'Order #INV-20260302-0066 - wanga 0203', '19', '2026-03-02 13:42:43', '2026-03-02 13:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('217', '91', 'out', '8.00', '0.00', '0.00', 'App\\Models\\Order', '82', 'Order #INV-20260302-0066 - wanga 0203', '19', '2026-03-02 13:42:43', '2026-03-02 13:42:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('218', '47', 'out', '50.00', '0.00', '0.00', 'App\\Models\\Order', '83', 'Order #INV-20260302-0067 - bead sol', '20', '2026-03-02 13:43:58', '2026-03-02 13:43:58');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('219', '85', 'in', '2.00', '0.00', '0.00', 'App\\Models\\Order', '44', 'Stok dikembalikan - Edit Order #INV-20260302-0028', '19', '2026-03-02 13:48:30', '2026-03-02 13:48:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('220', '85', 'in', '3.70', '0.00', '0.00', 'App\\Models\\Order', '44', 'Stok dikembalikan - Edit Order #INV-20260302-0028', '19', '2026-03-02 13:48:30', '2026-03-02 13:48:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('221', '85', 'in', '1.46', '0.00', '0.00', 'App\\Models\\Order', '44', 'Stok dikembalikan - Edit Order #INV-20260302-0028', '19', '2026-03-02 13:48:30', '2026-03-02 13:48:30');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('222', '46', 'out', '42.00', '0.00', '0.00', 'App\\Models\\Order', '84', 'Order #INV-20260302-0068 - launa cendikia', '19', '2026-03-02 13:49:10', '2026-03-02 13:49:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('223', '90', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '85', 'Order #INV-20260302-0069 - tn chandra', '3', '2026-03-02 13:51:59', '2026-03-02 13:51:59');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('224', '61', 'in', '0.60', '0.00', '0.00', 'App\\Models\\Order', '32', 'Stok dikembalikan - Edit Order #INV-20260302-0016', '3', '2026-03-02 13:52:58', '2026-03-02 13:52:58');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('225', '57', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '86', 'Order #INV-20260302-0070 - kychii', '19', '2026-03-02 13:55:15', '2026-03-02 13:55:15');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('226', '91', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '86', 'Order #INV-20260302-0070 - kychii', '19', '2026-03-02 13:55:15', '2026-03-02 13:55:15');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('227', '50', 'out', '11.00', '0.00', '0.00', 'App\\Models\\Order', '87', 'Order #INV-20260302-0071 - tag sale 1', '3', '2026-03-02 13:58:19', '2026-03-02 13:58:19');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('228', '57', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '88', 'Order #INV-20260302-0072 - parfum abu', '19', '2026-03-02 14:03:17', '2026-03-02 14:03:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('229', '91', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '88', 'Order #INV-20260302-0072 - parfum abu', '19', '2026-03-02 14:03:17', '2026-03-02 14:03:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('230', '68', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '88', 'Order #INV-20260302-0072 - parfum abu', '19', '2026-03-02 14:03:17', '2026-03-02 14:03:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('231', '48', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '89', 'Order #INV-20260302-0073 - Undangan Hoki 6', '23', '2026-03-02 14:04:47', '2026-03-02 14:04:47');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('232', '86', 'in', '25.00', '0.00', '0.00', 'App\\Models\\Order', '40', 'Stok dikembalikan - Batal Order #INV-20260302-0024', '16', '2026-03-02 14:08:24', '2026-03-02 14:08:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('233', '85', 'out', '16.00', '0.00', '0.00', 'App\\Models\\Order', '90', 'Order #INV-20260302-0074 - ngabubu 01-02', '19', '2026-03-02 14:10:00', '2026-03-02 14:10:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('234', '85', 'out', '4.50', '0.00', '0.00', 'App\\Models\\Order', '90', 'Order #INV-20260302-0074 - ngabubu 03', '19', '2026-03-02 14:10:00', '2026-03-02 14:10:00');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('235', '45', 'out', '5.00', '0.00', '0.00', 'App\\Models\\Order', '91', 'Order #INV-20260302-0075 - lamondo', '20', '2026-03-02 14:10:26', '2026-03-02 14:10:26');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('236', '47', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '92', 'Order #INV-20260302-0076 - kotak build', '19', '2026-03-02 14:12:02', '2026-03-02 14:12:02');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('237', '85', 'out', '1.00', '0.00', '0.00', 'App\\Models\\Order', '93', 'Order #INV-20260302-0077 - bazar jilbab', '19', '2026-03-02 14:15:48', '2026-03-02 14:15:48');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('238', '57', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '94', 'Order #INV-20260302-0078 - faris barokah', '20', '2026-03-02 14:16:09', '2026-03-02 14:16:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('239', '59', 'out', '100.00', '0.00', '0.00', 'App\\Models\\Order', '95', 'Order #INV-20260302-0079 - royal queen 2026', '19', '2026-03-02 14:20:43', '2026-03-02 14:20:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('240', '91', 'out', '100.00', '0.00', '0.00', 'App\\Models\\Order', '95', 'Order #INV-20260302-0079 - royal queen 2026', '19', '2026-03-02 14:20:43', '2026-03-02 14:20:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('241', '48', 'in', '1.00', '0.00', '0.00', 'App\\Models\\Order', '89', 'Stok dikembalikan - Edit Order #INV-20260302-0073', '23', '2026-03-02 14:23:23', '2026-03-02 14:23:23');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('242', '57', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '96', 'Order #INV-20260302-0080 - kitchen rrr', '3', '2026-03-02 14:23:45', '2026-03-02 14:23:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('243', '91', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '96', 'Order #INV-20260302-0080 - kitchen rrr', '3', '2026-03-02 14:23:45', '2026-03-02 14:23:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('244', '57', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '97', 'Order #INV-20260302-0081 - akifa cakee', '20', '2026-03-02 14:32:49', '2026-03-02 14:32:49');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('245', '91', 'out', '10.00', '0.00', '0.00', 'App\\Models\\Order', '97', 'Order #INV-20260302-0081 - akifa cakee', '20', '2026-03-02 14:32:49', '2026-03-02 14:32:49');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('246', '48', 'out', '19.00', '0.00', '0.00', 'App\\Models\\Order', '98', 'Order #INV-20260302-0082 - briggs', '3', '2026-03-02 14:34:17', '2026-03-02 14:34:17');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('247', '47', 'out', '73.00', '0.00', '0.00', 'App\\Models\\Order', '99', 'Order #INV-20260302-0083 - weton 1= 7, won 2 =13, weton 3=53', '20', '2026-03-02 14:35:56', '2026-03-02 14:35:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('248', '47', 'in', '73.00', '0.00', '0.00', 'App\\Models\\Order', '99', 'Stok dikembalikan - Edit Order #INV-20260302-0083', '20', '2026-03-02 14:36:15', '2026-03-02 14:36:15');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('249', '44', 'out', '86.00', '0.00', '0.00', 'App\\Models\\Order', '100', 'Order #INV-20260302-0084 - negeri cinta', '3', '2026-03-02 14:43:02', '2026-03-02 14:43:02');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('250', '44', 'in', '86.00', '0.00', '0.00', 'App\\Models\\Order', '100', 'Stok dikembalikan - Edit Order #INV-20260302-0084', '3', '2026-03-02 14:43:34', '2026-03-02 14:43:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('251', '44', 'out', '86.00', '0.00', '0.00', 'App\\Models\\Order', '100', 'Order #INV-20260302-0084 - negeri cinta', '3', '2026-03-02 14:43:34', '2026-03-02 14:43:34');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('252', '59', 'in', '100.00', '0.00', '0.00', 'App\\Models\\Order', '95', 'Stok dikembalikan - Edit Order #INV-20260302-0079', '19', '2026-03-02 14:43:43', '2026-03-02 14:43:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('253', '91', 'in', '100.00', '0.00', '0.00', 'App\\Models\\Order', '95', 'Stok dikembalikan - Edit Order #INV-20260302-0079', '19', '2026-03-02 14:43:43', '2026-03-02 14:43:43');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('254', '44', 'in', '86.00', '0.00', '0.00', 'App\\Models\\Order', '100', 'Stok dikembalikan - Edit Order #INV-20260302-0084', '3', '2026-03-02 14:44:41', '2026-03-02 14:44:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('255', '44', 'out', '86.00', '0.00', '0.00', 'App\\Models\\Order', '100', 'Order #INV-20260302-0084 - negeri cinta', '3', '2026-03-02 14:44:41', '2026-03-02 14:44:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('256', '61', 'out', '0.80', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - TDH FOOT', '20', '2026-03-02 14:53:13', '2026-03-02 14:53:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('257', '61', 'out', '0.48', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - HOUSE FOOT', '20', '2026-03-02 14:53:13', '2026-03-02 14:53:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('258', '82', 'out', '0.80', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - TDH FOOT', '20', '2026-03-02 14:53:13', '2026-03-02 14:53:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('259', '82', 'out', '0.48', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - HOUSEFOOT', '20', '2026-03-02 14:53:13', '2026-03-02 14:53:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('260', '99', 'out', '1.28', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - POTONGIN SEMUA', '20', '2026-03-02 14:53:13', '2026-03-02 14:53:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('261', '57', 'out', '30.00', '0.00', '0.00', 'App\\Models\\Order', '102', 'Order #INV-20260302-0086 - boy fried 0203', '19', '2026-03-02 14:53:57', '2026-03-02 14:53:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('262', '91', 'out', '30.00', '0.00', '0.00', 'App\\Models\\Order', '102', 'Order #INV-20260302-0086 - boy fried 0203', '19', '2026-03-02 14:53:57', '2026-03-02 14:53:57');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('263', '61', 'in', '0.80', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('264', '61', 'in', '0.48', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('265', '82', 'in', '0.80', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('266', '82', 'in', '0.48', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('267', '99', 'in', '1.28', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('268', '82', 'out', '1.28', '0.00', '0.00', 'App\\Models\\Order', '101', 'Order #INV-20260302-0085 - TDH FOOT', '20', '2026-03-02 14:55:37', '2026-03-02 14:55:37');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('269', '82', 'in', '1.28', '0.00', '0.00', 'App\\Models\\Order', '101', 'Stok dikembalikan - Edit Order #INV-20260302-0085', '20', '2026-03-02 14:56:32', '2026-03-02 14:56:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('270', '49', 'out', '135.00', '0.00', '0.00', 'App\\Models\\Order', '89', 'Order #INV-20260302-0073 - Undangan Hoki 6', '23', '2026-03-02 14:58:13', '2026-03-02 14:58:13');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('271', '47', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '103', 'Order #INV-20260302-0087 - KUPON ZAKAT', '20', '2026-03-02 15:02:24', '2026-03-02 15:02:24');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('272', '49', 'in', '720.00', '888.00', '639360.00', NULL, NULL, NULL, '8', '2026-03-02 15:12:40', '2026-03-02 15:12:40');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('273', '57', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '104', 'Order #INV-20260302-0088 - cik ly', '19', '2026-03-02 15:49:40', '2026-03-02 15:49:40');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('274', '68', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '104', 'Order #INV-20260302-0088 - cik ly', '19', '2026-03-02 15:49:40', '2026-03-02 15:49:40');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('275', '103', 'in', '10000000.00', '1.00', '10000000.00', NULL, NULL, 'ONLINE', '8', '2026-03-02 15:52:47', '2026-03-02 15:52:47');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('276', '59', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '105', 'Order #INV-20260302-0089 - DF PARFUME', '20', '2026-03-02 15:54:09', '2026-03-02 15:54:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('277', '68', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '105', 'Order #INV-20260302-0089 - DF PARFUME', '20', '2026-03-02 15:54:09', '2026-03-02 15:54:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('278', '91', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '105', 'Order #INV-20260302-0089 - DF PARFUME', '20', '2026-03-02 15:54:09', '2026-03-02 15:54:09');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('279', '59', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '106', 'Order #INV-20260302-0090 - zainal stiker', '19', '2026-03-02 15:58:46', '2026-03-02 15:58:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('280', '91', 'out', '9.00', '0.00', '0.00', 'App\\Models\\Order', '106', 'Order #INV-20260302-0090 - zainal stiker', '19', '2026-03-02 15:58:46', '2026-03-02 15:58:46');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('281', '61', 'out', '0.24', '0.00', '0.00', 'App\\Models\\Order', '107', 'Order #INV-20260302-0091 - stop bullying', '3', '2026-03-02 15:59:33', '2026-03-02 15:59:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('282', '50', 'out', '28.00', '0.00', '0.00', 'App\\Models\\Order', '108', 'Order #INV-20260302-0092 - shalinan', '19', '2026-03-02 16:01:50', '2026-03-02 16:01:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('283', '44', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '109', 'Order #INV-20260302-0093 - voucher 1', '3', '2026-03-02 16:28:50', '2026-03-02 16:28:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('284', '44', 'out', '20.00', '0.00', '0.00', 'App\\Models\\Order', '109', 'Order #INV-20260302-0093 - special 0203', '3', '2026-03-02 16:28:50', '2026-03-02 16:28:50');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('285', '68', 'in', '9000.00', '150.00', '1350000.00', NULL, NULL, 'ONLINE', '8', '2026-03-02 16:29:25', '2026-03-02 16:29:25');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('286', '47', 'out', '81.00', '0.00', '0.00', 'App\\Models\\Order', '110', 'Order #INV-20260302-0094 - yasin musni', '3', '2026-03-02 16:32:54', '2026-03-02 16:32:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('287', '67', 'out', '81.00', '0.00', '0.00', 'App\\Models\\Order', '110', 'Order #INV-20260302-0094 - yasin musni', '3', '2026-03-02 16:32:54', '2026-03-02 16:32:54');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('288', '103', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '111', 'Order #INV-20260302-0095 - wanga prz item', '19', '2026-03-02 16:35:03', '2026-03-02 16:35:03');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('289', '61', 'out', '1.80', '0.00', '0.00', 'App\\Models\\Order', '112', 'Order #INV-20260302-0096 - stiker', '23', '2026-03-02 16:35:21', '2026-03-02 16:35:21');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('290', '61', 'in', '1.80', '0.00', '0.00', 'App\\Models\\Order', '112', 'Stok dikembalikan - Edit Order #INV-20260302-0096', '23', '2026-03-02 16:35:41', '2026-03-02 16:35:41');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('291', '49', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '113', 'Order #INV-20260302-0097 - hamperscake', '20', '2026-03-02 16:37:56', '2026-03-02 16:37:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('292', '68', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '113', 'Order #INV-20260302-0097 - hamperscake', '20', '2026-03-02 16:37:56', '2026-03-02 16:37:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('293', '85', 'out', '5.90', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('294', '85', 'out', '2.36', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('295', '85', 'out', '2.08', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('296', '85', 'out', '4.16', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('297', '85', 'out', '5.76', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('298', '85', 'out', '2.75', '0.00', '0.00', 'App\\Models\\Order', '114', 'Order #INV-20260302-0098 - folder visual motif', '23', '2026-03-02 16:40:32', '2026-03-02 16:40:32');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('299', '59', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '115', 'Order #INV-20260302-0099 - MINI ONE 1', '3', '2026-03-02 16:43:56', '2026-03-02 16:43:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('300', '91', 'out', '3.00', '0.00', '0.00', 'App\\Models\\Order', '115', 'Order #INV-20260302-0099 - MINI ONE 1', '3', '2026-03-02 16:43:56', '2026-03-02 16:43:56');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('301', '61', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '116', 'Order #INV-20260302-0100 - M2REPAIR', '20', '2026-03-02 16:51:14', '2026-03-02 16:51:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('302', '82', 'out', '2.00', '0.00', '0.00', 'App\\Models\\Order', '116', 'Order #INV-20260302-0100 - M2REPAIR', '20', '2026-03-02 16:51:14', '2026-03-02 16:51:14');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('303', '61', 'in', '2.00', '0.00', '0.00', 'App\\Models\\Order', '116', 'Stok dikembalikan - Edit Order #INV-20260302-0100', '20', '2026-03-02 16:51:45', '2026-03-02 16:51:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('304', '82', 'in', '2.00', '0.00', '0.00', 'App\\Models\\Order', '116', 'Stok dikembalikan - Edit Order #INV-20260302-0100', '20', '2026-03-02 16:51:45', '2026-03-02 16:51:45');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('305', '61', 'out', '5.04', '0.00', '0.00', 'App\\Models\\Order', '117', 'Order #INV-20260302-0101 - HASIL BUMI', '20', '2026-03-02 16:56:05', '2026-03-02 16:56:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('306', '82', 'out', '5.04', '0.00', '0.00', 'App\\Models\\Order', '117', 'Order #INV-20260302-0101 - HASIL BUMI', '20', '2026-03-02 16:56:05', '2026-03-02 16:56:05');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('307', '61', 'in', '5.04', '0.00', '0.00', 'App\\Models\\Order', '117', 'Stok dikembalikan - Edit Order #INV-20260302-0101', '20', '2026-03-02 16:56:53', '2026-03-02 16:56:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('308', '82', 'in', '5.04', '0.00', '0.00', 'App\\Models\\Order', '117', 'Stok dikembalikan - Edit Order #INV-20260302-0101', '20', '2026-03-02 16:56:53', '2026-03-02 16:56:53');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('309', '61', 'out', '0.88', '0.00', '0.00', 'App\\Models\\Order', '118', 'Order #INV-20260302-0102 - LPG  SALIM', '20', '2026-03-02 16:59:33', '2026-03-02 16:59:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('310', '82', 'out', '0.88', '0.00', '0.00', 'App\\Models\\Order', '118', 'Order #INV-20260302-0102 - LPG  SALIM', '20', '2026-03-02 16:59:33', '2026-03-02 16:59:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('311', '85', 'out', '0.55', '0.00', '0.00', 'App\\Models\\Order', '119', 'Order #INV-20260302-0103 - 7 KEBIASAAN', '3', '2026-03-02 17:02:10', '2026-03-02 17:02:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('312', '61', 'out', '1.70', '0.00', '0.00', 'App\\Models\\Order', '120', 'Order #INV-20260302-0104 - SUMBER NIAGA', '20', '2026-03-02 17:02:10', '2026-03-02 17:02:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('313', '82', 'out', '1.70', '0.00', '0.00', 'App\\Models\\Order', '120', 'Order #INV-20260302-0104 - SUMBER NIAGA', '20', '2026-03-02 17:02:10', '2026-03-02 17:02:10');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('314', '61', 'out', '1.72', '0.00', '0.00', 'App\\Models\\Order', '121', 'Order #INV-20260302-0105 - ELPIGI SALIM', '20', '2026-03-02 17:04:27', '2026-03-02 17:04:27');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('315', '82', 'out', '1.72', '0.00', '0.00', 'App\\Models\\Order', '121', 'Order #INV-20260302-0105 - ELPIGI SALIM', '20', '2026-03-02 17:04:27', '2026-03-02 17:04:27');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('316', '85', 'in', '0.55', '0.00', '0.00', 'App\\Models\\Order', '119', 'Stok dikembalikan - Edit Order #INV-20260302-0103', '3', '2026-03-02 17:04:33', '2026-03-02 17:04:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('317', '85', 'out', '0.55', '0.00', '0.00', 'App\\Models\\Order', '119', 'Order #INV-20260302-0103 - 7 KEBIASAAN', '3', '2026-03-02 17:04:33', '2026-03-02 17:04:33');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('318', '57', 'out', '21.00', '0.00', '0.00', 'App\\Models\\Order', '122', 'Order #INV-20260302-0106 - sogon', '20', '2026-03-02 17:11:01', '2026-03-02 17:11:01');
INSERT INTO `stock_movements` (`id`, `material_id`, `type`, `quantity`, `unit_price`, `total_price`, `reference_type`, `reference_id`, `notes`, `user_id`, `created_at`, `updated_at`) VALUES ('319', '57', 'in', '21.00', '0.00', '0.00', 'App\\Models\\Order', '122', 'Stok dikembalikan - Edit Order #INV-20260302-0106', '20', '2026-03-02 17:11:39', '2026-03-02 17:11:39');

-- Table: suppliers
CREATE TABLE `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'INDAH SARI ABADI', '123654789', 'JL. TENGKU UMAR, KEDATON. BANDAR LAMPUNG', NULL, '1', '2026-02-13 06:25:31', '2026-02-13 06:25:31');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'VISI MEDIA', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-02-28 16:34:15', '2026-02-28 16:34:15');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'PRINTMATE', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:06:32', '2026-03-01 07:06:32');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('9', 'IQBAL SUPLAYER', NULL, 'BAANDAR LAMPUNG', NULL, '1', '2026-03-01 07:07:50', '2026-03-01 07:07:50');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'RWC SUPLAYER TINTA', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:08:25', '2026-03-01 07:08:25');
INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `notes`, `is_active`, `created_at`, `updated_at`) VALUES ('11', 'TOKO KERTAS SEJATI', NULL, 'BANDAR LAMPUNG', NULL, '1', '2026-03-01 07:09:09', '2026-03-01 07:09:09');

-- Table: units
CREATE TABLE `units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `symbol` varchar(20) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'm²', 'm2', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'pcs', 'pcs', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'lembar', 'lbr', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'meter', 'm', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'roll', 'roll', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'pak', 'pak', '1', '2026-02-09 13:27:05', '2026-02-09 13:27:05');
INSERT INTO `units` (`id`, `name`, `symbol`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'kg', 'kg', '1', '2026-02-27 13:51:38', '2026-02-27 13:51:38');

-- Table: users
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('developer','owner','spv','designer','kasir','operator','administrasi') NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('1', 'Rio Ardiansyah', 'rio@erkagraphia.com', NULL, '$2y$12$ricMiD.e2iledSsMa6ffw.DVwwb2swDM1qlCRZvPEEZfoYXiYBk1m', 'developer', '1', '9ps2dnHZxC05sa35aBN1jbjONldHmbYfUwJdryXnlpVunMGu79f4dxWgddna', '2026-02-09 13:27:04', '2026-02-27 12:50:19');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('2', 'Raden Cik Awang', 'radenawang@erkagraphia.com', NULL, '$2y$12$j5gzh6O4MgCTB9KM9vpEpuQbO9nO2IVg.Gr7UiCtIeH53tEAMC.gi', 'owner', '1', 'wGEKk3mM21DyA9xZf8d5r0qokRSRLy0yA8PoUTi3SRe8HLFK8xxEBPBIUiKP', '2026-02-09 13:27:04', '2026-03-02 12:37:56');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('3', 'Fadli Juansyah', 'fadil@erkagraphia.com', NULL, '$2y$12$NrVjm9xRX5L3laPyGLVdjeE5z9xWyuQuyEK9cEZhVuP0BkiJXDcRu', 'designer', '1', NULL, '2026-02-09 13:27:04', '2026-02-28 08:57:03');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('5', 'Renti Melania', 'renti@erkagraphia.com', NULL, '$2y$12$w/gMJzmQsY9cPRV1e.n1Nez7LDc/iyTFmSmtU5y8C0iZyvq88gQH6', 'kasir', '1', NULL, '2026-02-09 13:27:05', '2026-03-02 11:34:51');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('6', 'Ari Kurnaiwan', 'ari@erkagraphia.com', NULL, '$2y$12$MabipxAKZ/rrj7p2WnJgo.ieMbSSHUFQmopf.iddeowgEpSop9eQ2', 'operator', '1', 'eScD21VtnmncBwJTlE3PfFLVcsLn8ZZJBdJzlgxmSk0DPQcrRcNkvEv33F4x', '2026-02-09 13:27:05', '2026-02-28 08:58:14');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('8', 'Bambang Suroso', 'bambang@erkagraphia.com', NULL, '$2y$12$zO7t6iO5zftqJcyJv1aF2OrnZTAHrc7DeFN58EfCZAWZpwPCK1efi', 'spv', '1', 'e7QPsObgpfR6twr2n9dxih1W9a31bjsDuBf3wMvy2hhDCquHXWb2tuy8nSBe', '2026-02-10 01:50:47', '2026-02-28 08:56:29');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('16', 'Sherli Andini', 'sherli@erkagraphia.com', NULL, '$2y$12$8OhzT0s4nUucoaw3t9RBiOU.W1aUfW98c05JTYvaEAQPzJ6Z1asBG', 'administrasi', '1', '5fChW9XYk50qqQhALjtnKBmDmoWWoyLQ98Mj16GT1hNlQwxUUwHmwPtvurCJ', '2026-02-27 01:40:45', '2026-02-28 08:01:24');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('17', 'M. Angkasa Muluk', 'muluk@erkagraphia.com', NULL, '$2y$12$xqU1kMu8bWIICbuuMtcDmeD2Y5p4GS/K2eWFvucUo2yS3oRokmkyO', 'operator', '1', NULL, '2026-02-27 14:25:35', '2026-02-28 08:59:04');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('18', 'Fajar Hermawan', 'fajar@erkagraphia.com', NULL, '$2y$12$yK4iygwGFwYbHJA9D.MNvefaE2VWhVenUc9ApXDcbEeIKUr.OJhXu', 'operator', '1', NULL, '2026-02-28 08:58:08', '2026-03-02 13:15:46');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('19', 'Agung Nugroho', 'agung@erkagraphia.com', NULL, '$2y$12$LEKoIMG/jzO/mR90gO/kmOuy1C0qFVmLmaBDh6GwgGf00zXKCddIe', 'designer', '1', 'FRiPn74V5jgpPWjHHV4bhdSyiCcUO2WmaOQYIMwrfGVXmIKCmAUsxhrkEkzZ', '2026-02-28 08:58:37', '2026-03-02 13:14:02');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('20', 'Hendra Irawan', 'hendra@erkagraphia.com', NULL, '$2y$12$7d6cSS14fPU/2kvQ.68eLeIdt89zvhIprrXmDy33E5qT2nnA.OP1C', 'designer', '1', '5xJAuJxpvCVib47Q8rFJmGHriecCtz0TdjVnwb9nfi3xev3S8JxDY3YeicpD', '2026-02-28 08:59:35', '2026-03-02 13:14:14');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('21', 'Aji Dwi Prasetio', 'aji@erkagraphia.com', NULL, '$2y$12$.m0i5hEQyp.taO/Ha8bA.e6WEvXBRuUeR5N9/K6.xxXDQRSxVw.3W', 'operator', '1', NULL, '2026-02-28 09:00:02', '2026-03-02 10:14:17');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('22', 'Arsi Maulana Ibrahum', 'arsi@erkagraphia.com', NULL, '$2y$12$.VfBFMepz1eTfBQo46A.3O3qWPUHH5/kYVeTz1zGWDY86QIDO1K..', 'operator', '1', NULL, '2026-02-28 09:00:53', '2026-03-02 13:13:46');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('23', 'Muhammad Nur Adli', 'adli@erkagraphia.com', NULL, '$2y$12$Vvdr2yspBCZW438dQ/4NJOVbTXZj0l6fzRSmlczhoX.aNhpymDI76', 'designer', '1', NULL, '2026-02-28 09:02:00', '2026-02-28 09:42:46');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('24', 'Azrul', 'azrul@erkagraphia.com', NULL, '$2y$12$DoAPLxd0ASN8qF.mn45x6ezoNkSTp2BUDF2PU7Di3RQu7pqvuGjOC', 'operator', '1', NULL, '2026-02-28 09:02:41', '2026-03-02 11:55:16');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('25', 'Radius Prawiro', 'radius@erkagraphia.com', NULL, '$2y$12$gT/zUyBIjUtDpdtWMlW3SOC8fKef3cYpNuv1LvlycKQMBiPdBTO2K', 'designer', '1', NULL, '2026-02-28 10:20:27', '2026-03-02 13:14:46');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES ('26', 'Monitor', 'monitor@erkagraphia.com', NULL, '$2y$12$3mpgpA9wfpkxQ3o4fi1fBuSQpRWsiwSUHVRIFIESVdWqsUtvYn04q', 'operator', '1', 'zKi8JGwARYSkkpnjxUHk5icZ8z7tJibfyqwV3S6Uq3pb22X1bs2bB6wdnPDe', '2026-02-28 14:47:10', '2026-03-02 11:24:03');

