
/*!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 `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 `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 `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;
/*!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 */;

