
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

LOCK TABLES `stock_details` WRITE;
/*!40000 ALTER TABLE `stock_details` DISABLE KEYS */;
INSERT INTO `stock_details` (`id`, `article_id`, `warehouse_id`, `batch_number_FP`, `batch_number_PM`, `title`, `num_container`, `initial_quantity`, `consumed_quantity`, `available_quantity`, `unit_of_stock`, `vendor_batch`, `vendor_name`, `unit_of_purchase`, `expiry_date`, `inspection_date`, `batch_size`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (148,2,1,NULL,'2101N00008',99.00,1,532.80,0.00,532.80,1,NULL,NULL,NULL,'2026-04-30 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(149,2,1,NULL,'2405N0073',98.00,1,266.30,0.00,266.30,1,NULL,NULL,NULL,'2026-06-01 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(150,2,1,NULL,'2408N0194',99.00,1,2985.50,0.00,2985.50,1,NULL,NULL,NULL,'2029-06-08 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(151,3,1,NULL,'2406N0115',100.00,3,0.07,0.00,0.07,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(152,3,1,NULL,'2406N0115',100.00,4,3.24,0.00,3.24,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(153,3,1,NULL,'2406N0115',100.00,5,14.30,0.00,14.30,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:03','2025-10-23 13:15:03',NULL),(154,3,1,NULL,'2406N0115',100.00,6,24.99,0.00,24.99,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(155,3,1,NULL,'2406N0115',100.00,7,24.99,0.00,24.99,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(156,3,1,NULL,'2406N0115',100.00,8,24.99,0.00,24.99,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(157,3,1,NULL,'2406N0115',100.00,9,24.99,0.00,24.99,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(158,3,1,NULL,'2406N0115',100.00,10,24.99,0.00,24.99,3,NULL,NULL,NULL,'2026-10-20 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(159,4,1,NULL,'2003N00028',100.00,1,9880.30,0.00,9880.30,1,NULL,NULL,NULL,'2026-10-31 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(160,4,1,NULL,'2306N0095',100.00,1,10723.00,0.00,10723.00,1,NULL,NULL,NULL,'2026-07-30 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(161,4,1,NULL,'2408N0209',100.00,1,25000.00,0.00,25000.00,1,NULL,NULL,NULL,'2028-02-29 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(162,4,1,NULL,'2408N0209',100.00,2,25000.00,0.00,25000.00,1,NULL,NULL,NULL,'2028-02-29 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(163,5,1,NULL,'2408N0205',100.00,1,27263.30,0.00,27263.30,1,NULL,NULL,NULL,'2027-02-27 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(164,5,1,NULL,'2408N0205',100.00,2,29971.70,0.00,29971.70,1,NULL,NULL,NULL,'2027-02-27 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(165,5,1,NULL,'2408N0205',100.00,3,29971.70,0.00,29971.70,1,NULL,NULL,NULL,'2027-02-27 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(166,5,1,NULL,'2408N0205',100.00,4,29971.70,0.00,29971.70,1,NULL,NULL,NULL,'2027-02-27 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(167,6,1,NULL,'2406N0117',100.00,4,3454.40,0.00,3454.40,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(168,6,1,NULL,'2406N0117',100.00,5,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(169,6,1,NULL,'2406N0117',100.00,6,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(170,6,1,NULL,'2406N0117',100.00,7,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(171,6,1,NULL,'2406N0117',100.00,8,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(172,6,1,NULL,'2406N0117',100.00,9,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(173,6,1,NULL,'2406N0117',100.00,10,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(174,6,1,NULL,'2406N0117',100.00,11,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(175,6,1,NULL,'2406N0117',100.00,12,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(176,6,1,NULL,'2406N0117',100.00,13,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(177,6,1,NULL,'2406N0117',100.00,14,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(178,6,1,NULL,'2406N0117',100.00,15,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(179,6,1,NULL,'2406N0117',100.00,16,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(180,6,1,NULL,'2406N0117',100.00,17,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(181,6,1,NULL,'2406N0117',100.00,18,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(182,6,1,NULL,'2406N0117',100.00,19,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(183,6,1,NULL,'2406N0117',100.00,20,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(184,6,1,NULL,'2406N0117',100.00,21,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(185,6,1,NULL,'2406N0117',100.00,22,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(186,6,1,NULL,'2406N0117',100.00,23,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(187,6,1,NULL,'2406N0117',100.00,24,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(188,6,1,NULL,'2406N0117',100.00,25,20000.00,0.00,20000.00,1,NULL,NULL,NULL,'2029-02-25 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(189,7,1,NULL,'2206N0134',100.00,1,6276.91,0.00,6276.91,1,NULL,NULL,NULL,'2026-10-30 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(190,8,1,NULL,'2212N0267',100.00,1,802.00,0.00,802.00,1,NULL,NULL,NULL,'2026-11-01 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(191,8,1,NULL,'2303N0039',100.00,1,49978.00,0.00,49978.00,1,NULL,NULL,NULL,'2026-08-16 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(192,8,1,NULL,'2303N0039',100.00,2,49978.00,0.00,49978.00,1,NULL,NULL,NULL,'2026-08-16 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(193,9,1,NULL,'2403N0037',100.00,1,5365.50,0.00,5365.50,1,NULL,NULL,NULL,'2026-12-23 22:00:00',NULL,NULL,'A','2025-10-23 13:15:04','2025-10-23 13:15:04',NULL),(194,2,1,NULL,'2101N00005',1.00,1,100.30,0.00,100.30,1,NULL,NULL,NULL,'2026-04-30 22:00:00',NULL,NULL,'A','2025-10-24 08:47:04','2025-10-24 08:47:04',NULL),(195,2,1,NULL,'2405N0072',1.00,1,50.00,0.00,50.00,1,NULL,NULL,NULL,'2026-06-01 22:00:00',NULL,NULL,'A','2025-10-24 08:47:04','2025-10-24 08:47:04',NULL),(196,2,1,NULL,'2408N0193',1.00,1,200.00,0.00,200.00,1,NULL,NULL,NULL,'2029-06-08 22:00:00',NULL,NULL,'A','2025-10-24 08:47:04','2025-10-24 08:47:04',NULL),(197,10,1,NULL,'2303N0041',100.00,1,8000.00,0.00,8000.00,1,NULL,NULL,NULL,'2026-04-30 22:00:00',NULL,NULL,'A','2025-10-24 09:49:01','2025-10-24 09:49:01',NULL);
/*!40000 ALTER TABLE `stock_details` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `unit_of_measure` WRITE;
/*!40000 ALTER TABLE `unit_of_measure` DISABLE KEYS */;
INSERT INTO `unit_of_measure` (`id`, `unit_code`, `unit_name`, `unit_category`, `unit_base`, `conversion_to_base`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'g','Gramme','Masse','g',1.000,'2025-09-30 10:18:06','2025-09-30 10:18:06',NULL),(2,'mg','Milligramme','Masse','g',0.001,'2025-10-03 09:07:14','2025-10-03 09:07:14',NULL),(3,'kg','Kilogramme','Masse','g',1000.000,'2025-10-03 09:07:36','2025-10-03 09:07:36',NULL),(4,'cp','Comprimé','Dosage','cp',1.000,'2025-10-13 13:15:40','2025-10-13 13:15:40',NULL),(5,'l','Litre','Volume','g',1000.000,'2025-10-16 06:45:14','2025-10-23 11:48:54',NULL),(13,'ml','Millilitre','volume','L',0.001,'2025-10-29 08:53:01','2025-10-29 08:53:01',NULL),(14,'Bl','Blister','Conditionnement','Bl',1.000,'2025-11-06 22:04:08','2025-11-06 22:04:08',NULL),(15,'B','Boite','Vente','B',1.000,'2025-11-06 22:06:22','2025-11-06 22:06:22',NULL);
/*!40000 ALTER TABLE `unit_of_measure` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `equipments` WRITE;
/*!40000 ALTER TABLE `equipments` DISABLE KEYS */;
INSERT INTO `equipments` (`id`, `local_id`, `equipment_code`, `equipment_name`, `last_qualification_date`, `next_qualification_date`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,4,'EQHPDSM06','Weighing scale PROD ','2024-10-21 23:00:00','2025-10-20 23:00:00','2025-10-09 09:06:52','2025-10-09 09:06:52',NULL),(2,28,'EQHPDSM02','Weighing scale IPA','2024-10-21 23:00:00','2026-10-20 23:00:00','2025-10-09 09:06:52','2025-11-05 15:51:21',NULL),(3,25,'EQHPDSM01','Balance Excipient','2024-10-21 23:00:00','2026-10-18 23:00:00','2025-10-09 09:06:52','2025-11-05 15:50:17',NULL),(4,25,'EQHPDSM11','Balance Excipient','2024-05-07 23:00:00','2026-10-18 23:00:00','2025-10-09 09:06:52','2025-11-05 15:52:14',NULL),(5,2,'EQHPDSM03','Weighing scale IPQC','2024-10-21 23:00:00','2025-10-20 23:00:00','2025-10-09 09:06:52','2025-10-09 09:06:52',NULL),(6,14,'EQHPDSM12','Weighing scale PROD reconciliation','2025-01-13 23:00:00','2026-01-12 23:00:00','2025-10-09 09:06:52','2025-11-06 22:15:59',NULL),(7,1,'EQHPEFH01','Granulateur Rotocube','2025-02-06 23:00:00','2026-02-05 23:00:00','2025-10-09 09:06:52','2025-11-07 07:03:34',NULL),(8,6,'EQHPEFH03','Blender','2025-01-26 23:00:00','2026-01-25 23:00:00','2025-10-09 09:06:52','2025-11-07 07:04:21',NULL),(9,2,'EQHPEFH0604','Testeur d\'étanchéité des blistèrs','2025-10-08 23:00:00','2026-10-07 23:00:00','2025-10-09 09:06:52','2025-11-07 07:08:01',NULL),(10,3,'EQHPEFH04','Machine de Compression Korch','2025-03-13 23:00:00','2026-03-12 23:00:00','2025-10-09 09:06:52','2025-11-07 07:08:47',NULL),(11,25,'EQHPECE03','Centrale de pesée','2024-11-27 23:00:00','2025-11-26 23:00:00','2025-10-09 09:06:52','2025-10-25 14:06:55',NULL),(12,2,'EQHPECE07','Isolateur IPQC','2025-03-13 23:00:00','2026-03-12 23:00:00','2025-10-09 09:06:52','2025-11-07 07:10:21',NULL),(13,28,'EQHPECE04','Isolateur de pesée  ','2024-11-27 23:00:00','2025-11-26 23:00:00','2025-10-09 09:06:53','2025-10-09 09:06:53',NULL),(14,18,'EQHPENT03','Isolateur de lavage','2025-03-13 23:00:00','2026-03-12 23:00:00','2025-10-09 09:06:53','2025-11-07 07:13:26',NULL),(15,2,'EQHPELQ01','Disintegration tester','2024-09-15 23:00:00','2025-09-14 23:00:00','2025-10-09 09:06:53','2025-10-09 09:06:53',NULL),(16,2,'EQHPELQ02','Testeur de dureté','2024-09-15 23:00:00','2025-09-14 23:00:00','2025-10-09 09:06:53','2025-10-09 09:06:53',NULL),(17,2,'EQHPELQ03','Friability tester','2025-06-15 23:00:00','2026-06-14 23:00:00','2025-10-09 09:06:53','2025-11-07 07:15:07',NULL),(18,11,'EQHPEFH18','capsuleuse comas LI 240','2025-10-14 23:00:00','2026-10-13 23:00:00','2025-10-09 09:06:53','2025-11-07 07:16:20',NULL),(19,5,'EQHPEFH14','Capsule filling machine','2025-10-14 23:00:00','2026-10-13 23:00:00','2025-10-09 09:06:53','2025-11-07 07:17:50',NULL),(20,4,'EQHPEFH05','Coating machine ','2025-02-10 23:00:00','2026-02-09 23:00:00','2025-10-09 09:06:53','2025-10-09 09:06:53',NULL),(21,5,'EQHPEFH06','Blister Machine','2025-02-07 23:00:00','2026-02-06 23:00:00','2025-10-09 09:06:53','2025-11-07 07:20:07',NULL),(22,1,'EQHPEFH36','génerateur testeur des gants','2025-10-14 23:00:00','2026-10-13 23:00:00','2025-10-09 09:06:53','2025-11-07 07:21:03',NULL),(23,1,'EQHPDSM16','Appareil mesure des poincons','2025-09-24 23:00:00','2026-09-23 23:00:00','2025-10-09 09:06:53','2025-11-07 07:22:43',NULL),(24,6,'EQHPELQ04','Dessicator','2024-11-04 23:00:00','2025-11-03 23:00:00','2025-10-09 09:06:53','2025-10-09 09:06:53',NULL),(25,13,'EQHPEFH22','Mixer','2024-11-27 23:00:00','2025-11-26 23:00:00','2025-10-09 09:06:53','2025-10-25 20:49:27',NULL),(26,28,'EQHPECE01','Pass box  (API)','2025-01-19 23:00:00','2026-01-18 23:00:00','2025-10-09 09:06:53','2025-11-06 22:14:59',NULL),(27,25,'EQHPECE02','Pass box (EXP)','2025-01-19 23:00:00','2026-01-18 23:00:00','2025-10-09 09:06:53','2025-11-07 07:26:00',NULL),(28,25,'EQHPECE05','Pass box (pesée)','2025-01-19 23:00:00','2026-01-18 23:00:00','2025-10-09 09:06:53','2025-11-06 22:11:38',NULL),(29,25,'EQHPECE06','Pass box (inlet pass box) OSD','2025-01-19 23:00:00','2026-01-18 23:00:00','2025-10-09 09:06:54','2025-11-06 22:13:18',NULL),(30,13,'EQHPEFH30','Preparation tank (for coating solution)','2024-03-20 23:00:00','2025-11-18 23:00:00','2025-10-09 09:06:54','2025-11-06 22:14:37',NULL),(31,1,'EQHPMTB12','Bin 65 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(32,1,'EQHPMTB13','Bin 30 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(33,1,'EQHPMTB14','Bin 30 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(34,1,'EQHPMTB15','Bin 30 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(35,1,'EQHPMTB16','Bin 10 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(36,1,'EQHPMTB17','Bin 10 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(37,1,'EQHPMTB18','Bin 50 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(38,1,'EQHPMTB19','Bin 50 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(39,1,'EQHPMTB22','Bin 65 L',NULL,NULL,'2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(40,1,'EQHPMTB23','Bin 50 L','2025-01-25 23:00:00','2027-01-25 23:00:00','2025-10-09 09:06:54','2025-10-26 08:36:28',NULL),(41,1,'EQHPECE0409',' Tamis 1mm','2024-08-12 23:00:00','2025-08-11 23:00:00','2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(42,1,'EQHPECE0404',' Tamis 1mm','2024-10-14 23:00:00','2025-10-13 23:00:00','2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(43,1,'EQHPECE0405','Tamis 1,4mm','2024-08-12 23:00:00','2025-08-11 23:00:00','2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(44,1,'EQHPECE0406','Tamis 2,00 mm','2024-08-12 23:00:00','2025-08-11 23:00:00','2025-10-09 09:06:54','2025-10-09 09:06:54',NULL),(45,1,'EQHPECE0407','Tamis 0,8mm','2024-08-12 23:00:00','2025-08-11 23:00:00','2025-10-09 09:06:55','2025-10-09 09:06:55',NULL),(46,1,'EQHPECE0408','Tamis 0,5mm','2024-08-12 23:00:00','2025-08-11 23:00:00','2025-10-09 09:06:55','2025-10-09 09:06:55',NULL),(47,1,'EQHPECE0412','Tamis 250 µm','2024-08-12 23:00:00','2026-08-09 23:00:00','2025-10-09 09:06:55','2025-10-24 08:38:41',NULL),(48,28,'EQHPECE0413','Tamis 180 µm','2025-08-10 23:00:00','2026-08-09 23:00:00','2025-10-09 09:06:55','2025-11-06 14:13:24',NULL);
/*!40000 ALTER TABLE `equipments` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `locals` WRITE;
/*!40000 ALTER TABLE `locals` DISABLE KEYS */;
INSERT INTO `locals` (`id`, `site_id`, `local_code`, `local_name`, `last_qualification_date`, `next_qualification_date`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,2,'LHP1FS01D','Granulateur','2024-08-08','2026-08-07','2025-10-09 08:20:24','2025-10-09 08:20:24',NULL),(2,2,'LHP1FS07D','Contrôle en cours','2024-08-08','2026-08-07','2025-10-09 08:20:24','2025-10-22 12:17:23',NULL),(3,2,'LHP1FS04D','Compression','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(4,2,'LHP1FS05D','Pelliculage','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(5,2,'LHP1FS06D','Mise sous blister','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(6,2,'LHP1FS03D','Mélange','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(7,2,'LHP1AL01D','SAS entrée personnel FS-1','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(8,2,'LHP1VS01D','Vestiaire FS','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(9,2,'LHP1VS02D','Sortie douche de decontamination','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(10,2,'LHP1AL02D','Sas sortie personnel FS','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(11,2,'LHP1FS08D','Mise en gélule','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(12,2,'LHP1CL01D','Couloir','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(13,2,'LHP1FS09D','Préparation solution granulateur','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(14,2,'LHP1FS10D','Instance pelliculage/ blistérage','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(15,2,'LHP1AL03D','SAS entrée personnel FS-2','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(16,2,'LHP1FS02D','Stockage tampon des intrants','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(17,2,'LHP1LV03D','Stockage du matériel propre','2024-08-08','2026-08-07','2025-10-09 08:20:25','2025-10-09 08:20:25',NULL),(18,2,'LHP1LV02D','Laverie FS','2024-08-08','2026-08-07','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(19,2,'LHP1LV01D','Matériel à nettoyer','2024-08-08','2026-08-07','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(20,2,'LHP1MG01D','Stockage des pièces de formats et des poinçons','2024-08-08','2026-08-07','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(21,2,'LHP0VS07D','Vestiaire pesée/échantillonnage des excipients','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(22,2,'LHP0LV04D','Laverie de pesée','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(23,2,'LHP0LV05D','Stockage materiel propre','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(24,2,'LHP0AL09D','Sas personnel pesé/échantillonnage des excipeints','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(25,2,'LHP0CP01D','Pesée/échantillonnage des excipients','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(26,2,'LHP0VS08D','Vestiaire pesée/échantillonnage des matières actives','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(27,2,'LHP0AL10D','Sas personnel pesée/échantillonnage des matières actives','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL),(28,2,'LHP0CP02D','Pesée et échantillonnage des matières actives','2024-07-27','2026-07-26','2025-10-09 08:20:26','2025-10-09 08:20:26',NULL);
/*!40000 ALTER TABLE `locals` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `sites` WRITE;
/*!40000 ALTER TABLE `sites` DISABLE KEYS */;
INSERT INTO `sites` (`id`, `site_code`, `site_name`, `site_address`, `site_region`, `site_city`, `site_phone`, `created_at`, `updated_at`, `deleted_at`) VALUES (2,'Site001','Neapolis Pharma','Route de Tunis Km 7 - BP 206 Nabeul 8000 - Tunisie.','Nabeul','Nabeul','+216 72235006','2025-09-30 09:41:36','2025-09-30 09:41:36',NULL);
/*!40000 ALTER TABLE `sites` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `article_families` WRITE;
/*!40000 ALTER TABLE `article_families` DISABLE KEYS */;
INSERT INTO `article_families` (`id`, `family_code`, `family_name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'PF','Produit Fini','2025-09-30 09:43:14','2025-10-15 15:30:33',NULL),(2,'MP','Matière Première','2025-09-30 09:43:35','2025-09-30 09:43:35',NULL),(3,'AC','Article de Conditionnement','2025-09-30 09:43:50','2025-09-30 09:43:50',NULL);
/*!40000 ALTER TABLE `article_families` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `article_forms` WRITE;
/*!40000 ALTER TABLE `article_forms` DISABLE KEYS */;
INSERT INTO `article_forms` (`id`, `form_code`, `form_name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'Forme_LETROZOLE','Comprimé pelliculé rond biconvexe 6mm Film Coated round diameter 6mm biconvex tablet','2025-10-03 09:13:37','2025-10-03 09:13:37',NULL),(11,'Forme_IMATINIB','Comprimé pelliculé biconvexe, jaune très foncé à orange brunâtre,  ovaloid 18,5 mm x 7,5 mm, portant l\'inscription «N20» sur une face','2025-11-03 14:14:10','2025-11-03 14:14:10',NULL),(12,'Forme_CAPECITABINE','Comprimé pelliculé oblong/Film-coated oblong tablet','2025-11-06 22:03:36','2025-11-06 22:03:36',NULL),(13,'Forme_DASATINIB','Comprimé biconvexe 11 × 6 ovale blanc à blanc cassé portant l\'inscription N22','2025-11-10 12:57:03','2025-11-10 12:57:03',NULL),(14,'Forme_ANASTROZOLE','Comprimé pelliculé blanc à blanc cassérond biconvexe 6mm','2025-11-12 09:18:52','2025-11-12 09:18:52',NULL),(15,'Forme_TOFACITINIB','Comprime pelliculé blanc rond diametre 8mm avec une gravure N44','2025-11-12 12:22:24','2025-11-12 12:22:24',NULL);
/*!40000 ALTER TABLE `article_forms` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `article_models` WRITE;
/*!40000 ALTER TABLE `article_models` DISABLE KEYS */;
INSERT INTO `article_models` (`id`, `model_code`, `model_name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'Moldèle_LETROZOLE','LOCAL/HOSPITALIER /local hospital','2025-10-03 09:14:05','2025-10-03 09:14:05',NULL),(15,'Modèle_IMATINIB','LOCAL/HOSPITALIER /local hospital','2025-11-03 14:14:50','2025-11-03 14:14:50',NULL),(16,'L/H','Local/Hospitalier','2025-11-06 22:05:32','2025-11-06 22:05:32',NULL);
/*!40000 ALTER TABLE `article_models` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `article_sub_families` WRITE;
/*!40000 ALTER TABLE `article_sub_families` DISABLE KEYS */;
INSERT INTO `article_sub_families` (`id`, `article_family_id`, `subfamily_code`, `subfamily_name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,2,'EX','Excipient','2025-09-30 09:44:21','2025-09-30 09:44:21',NULL),(2,2,'PA','Principe Actif','2025-09-30 09:45:05','2025-09-30 09:45:05',NULL);
/*!40000 ALTER TABLE `article_sub_families` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `articles` WRITE;
/*!40000 ALTER TABLE `articles` DISABLE KEYS */;
INSERT INTO `articles` (`id`, `article_family_id`, `article_sub_family_id`, `unit_of_w_v`, `unit_of_sales`, `unit_of_purchase`, `article_form`, `article_model`, `initial_quantity`, `consumed_quantity`, `available_quantity`, `article_code`, `article_name`, `batch_size_w_v`, `batch_size_dosage`, `unit_of_dosage`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,1,NULL,3,NULL,NULL,1,1,0.00,0.00,0.00,'LET2-5T030','LETROZOLE NEAPOLIS 2.5 MG COMPRIME PELLICULE',10.00,100000.00,4,'2025-09-30 08:49:44','2025-10-22 09:46:02',NULL),(2,2,2,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MAN00007','LETROZOLE',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(3,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00001','LACTOSE MONHYDRATE',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(4,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00010','SODIUM STARCH GLYCOLATE',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(5,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00011','CROSPOVIDONE',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(6,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00012','CELLULOSE MICROCRISTALLINE 101',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(7,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00013','MAGNESIUM STEARATE',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(8,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00020','STARCH  1500',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(9,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00021','SILICE COLLOIDALE (OSIL200)',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(10,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00037','OPADRY II YELLOW 85F22147',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(11,2,1,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,'MEN00041','PURIFIED WATER',0.00,0.00,NULL,'2025-09-30 08:49:44','2025-09-30 08:49:44',NULL),(29,1,NULL,3,15,NULL,11,16,0.00,0.00,0.00,'PF152200001','IMATINIB 400',20.00,26666.00,4,'2025-11-04 09:45:46','2025-11-11 11:30:04',NULL),(30,1,NULL,3,15,NULL,12,16,0.00,0.00,0.00,'CAP500T120','CAPECITABINE NEAPOLIS 500 MG  COMPRIME PELLICULE',20.00,31746.00,4,'2025-11-06 22:07:43','2025-11-06 22:07:43',NULL),(31,1,NULL,3,15,NULL,13,16,0.00,0.00,0.00,'DAS050T060','DASATINIB   50 MG  COMPRIME PELLICULE',10.00,50000.00,4,'2025-11-10 13:32:06','2025-11-10 13:32:06',NULL),(32,1,NULL,3,15,NULL,14,16,0.00,0.00,0.00,'ANA001T030','ANASTROZOLE 1 MG  COMPRIME PELLICULE',6.50,650000.00,4,'2025-11-12 09:18:20','2025-11-12 09:20:34',NULL),(33,1,NULL,3,15,NULL,15,16,0.00,0.00,0.00,'PF154000001','TOFACITINIB 5 MG  COMPRIME PELLICULE',5.00,25000.00,4,'2025-11-12 12:21:30','2025-11-12 12:23:02',NULL);
/*!40000 ALTER TABLE `articles` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `warehouses` WRITE;
/*!40000 ALTER TABLE `warehouses` DISABLE KEYS */;
INSERT INTO `warehouses` (`id`, `site_id`, `warehouse_code`, `warehouse_name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,NULL,'NPN','Neapolis','2025-09-30 10:21:31','2025-09-30 10:21:31',NULL);
/*!40000 ALTER TABLE `warehouses` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `correction_reason_templates` WRITE;
/*!40000 ALTER TABLE `correction_reason_templates` DISABLE KEYS */;
INSERT INTO `correction_reason_templates` (`id`, `reason_code`, `reason_label`, `description`, `is_active`, `display_order`, `created_at`, `updated_at`) VALUES (1,'TYPO','Erreur de saisie (typo)','Utilisé lorsqu\'une erreur de frappe a été commise lors de la saisie initiale',1,1,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(2,'WRONG_SCAN','Valeur incorrecte scannée','Utilisé lorsqu\'un mauvais code-barres ou QR code a été scanné',1,2,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(3,'INSTRUMENT_ERROR','Erreur de lecture d\'instrument','Utilisé lorsqu\'une valeur provenant d\'un instrument de mesure a été mal lue ou transcrite',1,3,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(4,'WRONG_SELECTION','Mauvais lot/équipement sélectionné','Utilisé lorsqu\'un mauvais lot de matière première ou équipement a été sélectionné',1,4,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(5,'TRANSPOSED_DATA','Donnée transposée','Utilisé lorsque des données ont été inversées ou saisies dans la mauvaise cellule',1,5,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(6,'UNIT_ERROR','Erreur d\'unité de mesure','Utilisé lorsqu\'une valeur a été saisie avec la mauvaise unité (kg au lieu de g, °C au lieu de °F, etc.)',1,6,'2025-10-09 12:04:23','2025-10-09 12:04:23'),(7,'CUSTOM','Autre (saisir raison personnalisée)','Utilisé pour toute autre raison non couverte par les options prédéfinies',1,7,'2025-10-09 12:04:23','2025-10-09 12:04:23');
/*!40000 ALTER TABLE `correction_reason_templates` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `bill_of_materials` WRITE;
/*!40000 ALTER TABLE `bill_of_materials` DISABLE KEYS */;
INSERT INTO `bill_of_materials` (`id`, `finished_product_article_id`, `primary_material_article_id`, `quantity_per_unit`, `unit_of_measure`, `quantity_per_batch`, `unit_of_batch`, `num_fractions`, `created_at`, `updated_at`, `deleted_at`, `family_code`) VALUES (1,1,2,2.5000,2,250.0000,1,2,'2025-10-02 14:29:54','2025-10-23 11:32:00',NULL,'MP'),(2,1,3,50.0000,2,5000.0000,1,2,'2025-10-02 14:31:31','2025-10-23 11:34:37',NULL,'MP'),(8,1,6,28.0000,2,2800.0000,1,2,'2025-10-15 14:28:04','2025-10-23 11:36:59',NULL,'MP'),(16,1,5,4.0000,2,400.0000,1,2,'2025-10-16 14:04:07','2025-10-23 11:38:33',NULL,'MP'),(18,1,8,11.5000,2,1150.0000,1,0,'2025-10-16 14:38:48','2025-10-23 11:39:07',NULL,'MP'),(19,1,9,0.5000,2,50.0000,1,0,'2025-10-16 14:40:38','2025-10-23 11:43:50',NULL,'MP'),(20,1,7,1.0000,2,100.0000,1,0,'2025-10-16 14:42:26','2025-10-23 11:38:16',NULL,'MP'),(33,1,4,2.5000,2,250.0000,1,3,'2025-10-23 11:42:12','2025-10-23 11:42:12',NULL,'MP'),(37,1,11,26.0000,2,2.6000,5,2,'2025-10-23 11:52:49','2025-10-23 11:52:49',NULL,'MP'),(38,1,10,3.0000,2,300.0000,1,0,'2025-10-23 11:53:19','2025-10-23 11:53:19',NULL,'MP');
/*!40000 ALTER TABLE `bill_of_materials` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `product_compositions` WRITE;
/*!40000 ALTER TABLE `product_compositions` DISABLE KEYS */;
INSERT INTO `product_compositions` (`id`, `bill_of_materials_id`, `parent_fraction_id`, `unit_id`, `quantity`, `created_at`, `updated_at`, `deleted_at`) VALUES (59,1,NULL,1,125.0000,'2025-10-23 11:32:00','2025-10-23 11:32:00',NULL),(60,1,NULL,1,125.0000,'2025-10-23 11:32:00','2025-10-23 11:32:00',NULL),(61,2,NULL,1,2500.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(62,2,61,1,250.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(63,2,61,1,1125.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(64,2,61,1,1125.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(65,2,NULL,1,2500.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(66,2,65,1,250.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(67,2,65,1,1125.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(68,2,65,1,1125.0000,'2025-10-23 11:34:37','2025-10-23 11:34:37',NULL),(69,8,NULL,1,1400.0000,'2025-10-23 11:36:59','2025-10-23 11:36:59',NULL),(70,8,NULL,1,1400.0000,'2025-10-23 11:36:59','2025-10-23 11:36:59',NULL),(71,16,NULL,1,200.0000,'2025-10-23 11:38:33','2025-10-23 11:38:33',NULL),(72,16,NULL,1,200.0000,'2025-10-23 11:38:33','2025-10-23 11:38:33',NULL),(73,33,NULL,1,75.0000,'2025-10-23 11:42:12','2025-10-23 11:42:12',NULL),(74,33,NULL,1,75.0000,'2025-10-23 11:42:12','2025-10-23 11:42:12',NULL),(75,33,NULL,1,100.0000,'2025-10-23 11:42:12','2025-10-23 11:42:12',NULL),(76,37,NULL,5,1.3000,'2025-10-23 11:52:49','2025-10-23 11:52:49',NULL),(77,37,NULL,5,1.3000,'2025-10-23 11:52:49','2025-10-23 11:52:49',NULL);
/*!40000 ALTER TABLE `product_compositions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

