-- MySQL dump 10.13  Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: db_access_02709
-- ------------------------------------------------------
-- Server version	8.0.40

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

--
-- Table structure for table `cpt_tbl_transaction`
--

DROP TABLE IF EXISTS `cpt_tbl_transaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cpt_tbl_transaction` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type_transaction` enum('av','tr','od','od_av') NOT NULL COMMENT 'av= Achat-Vente, tr= tresorerie, od= OD',
  `fk_facture_id` int DEFAULT NULL COMMENT ' NULL pour les OD',
  `fk_tiers_id` int DEFAULT NULL COMMENT 'Is not Null for tresorerie ',
  `montant` decimal(13,2) NOT NULL,
  `devise` varchar(3) NOT NULL,
  `fk_idworkday` int NOT NULL,
  `intitule` varchar(100) NOT NULL,
  `date_valeur` date NOT NULL,
  `justification` varchar(50) DEFAULT NULL,
  `observation` varchar(20) DEFAULT NULL,
  `file_justif` varchar(255) DEFAULT NULL,
  `user_crea` varchar(30) NOT NULL,
  `date_crea` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `id_app` int DEFAULT '0' COMMENT 'cfr id Société',
  PRIMARY KEY (`id`),
  KEY `trans_fk_fac_id` (`fk_facture_id`),
  KEY `trans_fk_idworkday` (`fk_idworkday`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cpt_tbl_transaction`
--

LOCK TABLES `cpt_tbl_transaction` WRITE;
/*!40000 ALTER TABLE `cpt_tbl_transaction` DISABLE KEYS */;
INSERT INTO `cpt_tbl_transaction` VALUES (1,'av',1,NULL,610.00,'USD',1,'prise en charge medicale pour ndjate , art en action et morel','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:17:00',2),(2,'av',2,NULL,90.00,'USD',1,'prise en charge médicale pour matondo et ndjike','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:19:02',2),(3,'av',3,NULL,265.00,'USD',1,'prise en charge medicale pour BRP','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:20:26',2),(4,'av',4,NULL,210.00,'USD',1,'prise en charge medicale pour TAnk','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:21:09',2),(5,'av',5,NULL,425.00,'USD',1,'prise en charge medicale pour servtec','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:21:47',2),(6,'av',6,NULL,685.00,'USD',1,'prise en charge medicale mois de janvier','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:22:51',2),(7,'av',7,NULL,965.00,'USD',1,'prise en charge medicale pour BUO, im Congo et SQL','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:23:59',2),(8,'av',12,NULL,550.00,'USD',1,'prise en charge medicale pour si jeunesse savait, servtec veritas','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:27:13',2),(9,'av',13,NULL,750.00,'USD',1,'prise en charge medicale pour mongu, polytra, art en action','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:29:06',2),(10,'av',14,NULL,550.00,'USD',1,'prise en charge medicale Congo American','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 12:29:46',2),(12,'tr',1,1,600.00,'USD',1,'paiement prise en charge medicale','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 17:16:14',2),(13,'tr',1,1,10.00,'USD',1,'paiement prise en charge medicale','2024-05-17',NULL,NULL,NULL,'admin','2024-05-17 17:28:20',2),(14,'od',NULL,NULL,150.00,'USD',1,'achat Oui','2024-05-01',NULL,NULL,NULL,'admin','2024-05-22 19:04:36',2),(15,'od',NULL,NULL,10.00,'USD',1,'paiement transport ','2024-05-22','eza té',NULL,NULL,'admin','2024-05-22 19:07:18',2),(16,'av',15,NULL,85678.18,'USD',17,'vente Eau','2023-06-01',NULL,NULL,NULL,'pathy','2024-06-04 20:02:23',5),(17,'tr',15,7,85678.18,'USD',20,'perception facture n 01 Client Divers','2023-07-01',NULL,NULL,NULL,'pathy','2024-06-04 20:08:03',5),(19,'od',NULL,NULL,25770.24,'USD',14,'affectation résultat en instance perte','2023-01-05',NULL,NULL,NULL,'pathy','2024-06-04 20:32:20',5),(20,'av',16,NULL,51148.84,'USD',17,'Achat fournitures','2023-06-02',NULL,NULL,NULL,'pathy','2024-06-04 20:51:40',5),(21,'av',17,NULL,1306.97,'USD',17,'Achat fournitures','2023-06-03',NULL,NULL,NULL,'pathy','2024-06-04 21:00:48',5),(22,'tr',NULL,8,52362.14,'USD',20,'paiement facture 02 et 03','2023-07-01',NULL,NULL,NULL,'pathy','2024-06-04 21:10:39',5),(23,'od',NULL,NULL,11817.63,'USD',18,'Annulation TVA Collectée','2023-08-01',NULL,NULL,NULL,'pathy','2024-06-04 21:21:34',5),(24,'od_av',NULL,9,150.00,'USD',21,'achat phone bureau','2023-02-01','nothing',NULL,NULL,'mbo','2024-06-12 10:01:08',6),(25,'od',NULL,NULL,13.64,'USD',18,'prise en charge Impot minimal','2023-08-01',NULL,NULL,NULL,'pathy','2024-06-14 20:02:26',5),(26,'tr',NULL,NULL,13.64,'USD',20,'paiement IBP 2022','2023-08-01',NULL,NULL,NULL,'pathy','2024-06-14 20:05:47',5),(27,'od',NULL,NULL,26294.10,'USD',18,'Appointement Salaire','2023-09-01',NULL,NULL,NULL,'pathy','2024-06-14 20:11:39',5),(28,'tr',NULL,NULL,26294.10,'USD',20,'paiement salaire','2023-09-05',NULL,NULL,NULL,'pathy','2024-06-14 20:12:55',5),(29,'od',NULL,NULL,475.55,'USD',18,'Taxe environnementale','2023-09-01',NULL,NULL,NULL,'pathy','2024-06-14 20:20:10',5),(30,'tr',NULL,NULL,475.55,'USD',20,'paiement taxe environnementale ','2023-10-25',NULL,NULL,NULL,'pathy','2024-06-14 20:21:26',5),(31,'od',NULL,NULL,320.43,'USD',18,'Achat Vignette , EMPEA ','2023-09-01',NULL,NULL,NULL,'pathy','2024-06-14 20:28:00',5),(32,'tr',NULL,NULL,320.43,'USD',20,'paiement vignette et IPMEA','2023-11-05',NULL,NULL,NULL,'pathy','2024-06-14 20:28:58',5),(33,'od',NULL,NULL,93.37,'USD',17,'Prise en charge pénalité et Amande  fiscale','2023-06-06',NULL,NULL,NULL,'pathy','2024-06-14 20:33:52',5),(34,'tr',NULL,NULL,93.37,'USD',20,'paiement penalité et Amande fiscale','2023-01-01',NULL,NULL,NULL,'pathy','2024-06-14 20:35:56',5),(35,'od',NULL,NULL,308.33,'USD',19,'Penalité et Amande penale','2023-11-05',NULL,NULL,NULL,'pathy','2024-06-14 20:37:43',5),(36,'tr',NULL,NULL,308.33,'USD',20,'paiement penalité et amande fiscale','2023-12-10',NULL,NULL,NULL,'pathy','2024-06-14 20:38:51',5),(37,'tr',NULL,NULL,38.50,'USD',20,'paiement avance','2023-09-10',NULL,NULL,NULL,'pathy','2024-06-14 20:40:42',5),(38,'od',NULL,NULL,887.82,'USD',18,'preparation IPR','2023-09-25',NULL,NULL,NULL,'pathy','2024-06-14 21:21:25',5),(39,'tr',NULL,NULL,710.11,'USD',20,'paiement IPR','2023-09-30',NULL,NULL,NULL,'pathy','2024-06-14 21:23:48',5),(40,'od_av',NULL,9,1200.00,'USD',23,'achat test od av','2024-02-01','is a true transaction',NULL,NULL,'mbo','2024-06-17 21:52:23',6),(41,'od_av',NULL,9,150.00,'USD',23,'test 2 od av','2024-02-01','test justification',NULL,'p_justif/6/vVHzPLZRS2vVLJWzRo6OsjS0R0s0rSTDBlgiz4lb.pdf','mbo','2024-06-17 21:59:52',6);
/*!40000 ALTER TABLE `cpt_tbl_transaction` 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 */;

-- Dump completed on 2025-05-06 22:45:24
