-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_impo
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

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

DROP TABLE IF EXISTS `ds_tarifario_win_ratio_sem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ds_tarifario_win_ratio_sem` (
  `id` int(11) NOT NULL,
  `fecha` date DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `semana` int(11) DEFAULT NULL,
  `concluido_wr_total` int(11) DEFAULT NULL,
  `concluido_no_total` int(11) DEFAULT NULL,
  `concluido_yes_total` int(11) DEFAULT NULL,
  `win_ration_objectiv_total` float DEFAULT NULL,
  `win_ratio_total` float DEFAULT NULL,
  `win_ratio_average_ytd_total` float DEFAULT NULL,
  `participacion_wr_total` float DEFAULT NULL,
  `participacion_no_total` float DEFAULT NULL,
  `concluido_wr_pa` int(11) DEFAULT NULL,
  `concluido_no_pa` int(11) DEFAULT NULL,
  `concluido_yes_pa` int(11) DEFAULT NULL,
  `win_ratio_pa` float DEFAULT NULL,
  `concluido_wr_pe` int(11) DEFAULT NULL,
  `concluido_no_pe` int(11) DEFAULT NULL,
  `concluido_yes_pe` int(11) DEFAULT NULL,
  `win_ratio_pe` float DEFAULT NULL,
  `concluido_wr_pp` int(11) DEFAULT NULL,
  `concluido_no_pp` int(11) DEFAULT NULL,
  `concluido_yes_pp` int(11) DEFAULT NULL,
  `win_ratio_pp` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ds_tarifario_win_ratio_sem`
--

LOCK TABLES `ds_tarifario_win_ratio_sem` WRITE;
/*!40000 ALTER TABLE `ds_tarifario_win_ratio_sem` DISABLE KEYS */;
INSERT INTO `ds_tarifario_win_ratio_sem` VALUES (1,'2020-01-01',2020,1,0,33,7,16,18,18,3,0,0,33,4,11,0,0,3,100,0,0,0,0),(2,'2020-01-06',2020,2,6,1,3,16,30,26,3,96,0,0,0,0,69,1,30,30,0,0,0,0),(3,'2020-01-13',2020,3,0,61,5,16,46,38,5,0,0,33,7,18,0,28,45,62,0,0,0,0),(4,'2020-01-20',2020,4,0,206,5,16,22,29,2,0,0,98,22,18,0,108,36,25,0,0,0,0),(5,'2020-01-27',2020,5,0,210,8,16,29,26,2,0,0,122,34,22,0,88,51,37,0,0,2,100),(6,'2020-02-03',2020,6,1,226,6,16,17,22,2,31,0,82,24,23,104,144,43,15,0,0,0,0),(7,'2020-02-10',2020,7,0,300,7,16,20,19,2,0,0,98,25,20,0,202,52,20,0,0,0,0),(8,'2020-02-17',2020,8,0,251,6,16,20,20,3,0,0,106,23,18,0,145,41,22,0,0,0,0),(9,'2020-02-24',2020,9,0,363,6,16,16,18,2,0,0,148,26,15,0,215,41,16,0,0,0,0),(10,'2020-03-02',2020,10,1,345,6,16,14,15,3,5,0,147,18,11,18,198,43,17,0,0,0,0),(11,'2020-03-09',2020,11,3,373,7,16,15,15,3,9,0,135,28,17,38,238,47,15,0,0,0,0),(12,'2020-03-16',2020,12,3,281,6,16,16,16,4,11,0,161,25,13,35,120,37,19,0,0,0,0),(13,'2020-03-23',2020,13,3,257,9,16,24,20,4,12,0,165,23,12,37,90,69,35,0,2,0,0),(14,'2020-03-30',2020,14,2,199,7,16,26,25,6,9,0,121,34,22,21,78,44,31,0,0,0,0),(15,'2020-04-06',2020,15,0,180,7,24,30,28,8,0,0,110,42,28,0,70,35,33,0,0,0,0),(16,'2020-04-13',2020,16,0,122,6,24,36,33,12,0,0,61,35,36,0,57,34,37,0,4,0,0),(17,'2020-04-20',2020,17,0,63,8,24,57,45,21,0,0,17,22,56,0,40,55,58,0,6,6,50),(18,'2020-04-27',2020,18,5,168,6,24,21,33,7,24,0,45,15,25,59,118,41,19,0,5,5,50),(19,'2020-05-04',2020,19,5,193,6,24,19,20,7,22,0,80,10,11,59,90,35,19,0,23,16,41),(20,'2020-05-11',2020,20,5,233,6,24,19,19,6,19,0,70,6,8,58,131,51,21,0,32,11,26),(21,'2020-05-18',2020,21,6,100,8,24,33,25,12,33,1,59,7,10,59,30,50,36,0,11,23,68),(22,'2020-05-25',2020,22,5,105,8,24,35,34,12,32,8,19,14,34,51,82,60,31,0,4,13,76),(23,'2020-06-01',2020,23,7,96,8,24,33,34,12,38,52,0,15,22,21,93,62,35,0,3,7,70),(24,'2020-06-08',2020,24,8,179,6,24,20,26,8,29,32,1,14,30,40,173,41,16,9,5,10,42),(25,'2020-06-15',2020,25,1,91,9,24,31,25,11,49,15,6,28,57,65,79,54,27,31,6,8,18),(26,'2020-06-22',2020,26,1,140,1,24,29,30,9,42,20,2,24,52,54,101,51,25,44,37,30,27),(27,'2020-06-29',2020,27,9,164,7,24,21,25,9,34,14,3,16,48,54,156,48,19,30,5,7,17),(28,'2020-07-06',2020,28,1,249,1,24,21,21,7,33,20,9,18,38,47,227,57,17,71,13,25,23),(29,'2020-07-13',2020,29,1,136,1,24,29,24,9,49,42,12,29,35,79,117,52,21,40,7,39,45),(30,'2020-07-20',2020,30,1,126,1,24,29,29,10,49,19,1,24,55,66,117,73,29,64,8,16,18),(31,'2020-07-27',2020,31,2,112,9,24,21,25,8,62,37,2,28,42,91,105,54,22,101,5,9,8),(32,'2020-08-03',2020,32,2,50,1,24,31,26,10,74,34,0,33,49,64,47,81,42,133,3,11,7),(33,'2020-08-10',2020,33,2,56,9,24,22,26,9,77,47,0,37,44,82,53,58,30,162,3,1,1),(34,'2020-08-17',2020,34,2,27,1,24,27,24,11,81,38,0,22,37,114,23,54,28,102,4,28,21),(35,'2020-08-24',2020,35,2,137,8,24,19,22,9,58,46,0,15,25,99,136,55,19,88,1,14,14),(36,'2020-08-31',2020,36,1,112,1,24,26,22,11,54,16,0,18,53,76,103,59,25,80,9,23,21),(37,'2020-09-07',2020,37,1,149,9,24,21,23,10,51,32,1,20,38,85,145,56,20,79,3,15,15),(38,'2020-09-14',2020,38,2,57,7,24,20,20,11,72,37,3,13,25,118,54,55,24,88,0,5,5),(39,'2020-09-21',2020,39,2,50,1,24,30,25,12,73,24,0,26,52,118,40,75,32,100,10,23,17),(40,'2020-09-28',2020,40,1,96,8,24,24,27,12,59,35,2,21,36,91,71,60,27,66,23,8,8),(41,'2020-10-05',2020,41,2,100,1,24,26,25,12,59,40,0,34,46,97,86,51,22,64,14,19,20),(42,'2020-10-12',2020,42,1,96,1,24,28,27,13,58,31,0,20,39,108,93,72,26,55,3,19,25),(43,'2020-10-19',2020,43,1,77,1,24,29,28,14,61,45,0,31,41,93,74,69,29,47,3,7,12),(44,'2020-10-26',2020,44,2,51,8,24,25,27,14,69,30,2,22,41,118,48,51,24,68,1,15,18),(45,'2020-11-02',2020,45,2,93,9,24,22,23,12,65,35,0,21,38,140,60,59,23,76,33,18,14),(46,'2020-11-09',2020,46,1,112,9,24,25,24,14,53,33,0,8,20,91,109,76,28,55,3,15,21),(47,'2020-11-16',2020,47,3,42,9,24,21,23,12,78,49,2,17,25,149,39,54,22,110,1,22,17),(48,'2020-11-23',2020,48,2,69,9,24,21,21,12,70,31,0,14,31,136,68,67,25,112,1,13,10),(49,'2020-11-30',2020,49,7,128,1,24,38,28,20,29,0,0,30,100,71,113,67,27,0,15,24,62),(50,'2020-12-07',2020,50,9,76,9,24,34,36,22,43,1,0,17,94,96,62,51,24,0,14,22,61),(51,'2020-12-14',2020,51,1,24,6,24,34,34,28,59,0,0,18,100,107,24,42,24,0,0,6,100),(52,'2020-12-21',2020,52,1,46,4,24,21,27,22,58,0,1,14,93,135,43,21,11,0,2,13,87),(53,'2021-01-04',2021,1,4,0,0,34,0,18,2,98,0,0,0,0,0,0,0,0,0,0,0,0),(54,'2021-01-11',2021,2,0,10,4,34,81,44,0,19,29,0,18,38,77,73,49,25,38,13,18,26),(55,'2021-01-18',2021,3,0,33,8,34,72,75,0,28,57,1,22,28,132,60,63,25,26,11,14,27),(56,'2021-01-25',2021,4,0,53,8,34,63,67,0,37,95,0,25,21,144,81,55,20,18,6,9,27),(57,'2021-02-01',2021,5,0,57,9,34,62,62,0,38,104,0,0,0,151,66,73,25,47,0,0,0),(58,'2021-02-08',2021,6,0,100,6,34,39,50,0,61,74,4,18,19,84,41,36,22,22,4,10,28),(59,'2021-02-15',2021,7,1,56,8,34,55,46,8,37,72,6,17,18,129,71,47,19,22,6,11,28),(60,'2021-02-22',2021,8,0,85,1,34,57,56,0,43,0,7,28,80,2,66,79,54,0,3,15,83),(61,'2021-03-01',2021,9,0,95,8,34,48,53,0,52,0,9,19,68,2,78,55,41,0,5,13,72),(62,'2021-03-08',2021,10,4,179,1,34,38,42,1,61,0,28,22,44,0,104,72,41,0,3,16,84),(63,'2021-03-15',2021,11,3,128,1,34,45,41,1,54,0,39,25,39,0,73,85,54,0,5,14,74),(64,'2021-03-22',2021,12,2,114,1,34,23,31,51,26,0,47,17,27,3,38,66,62,0,6,8,57),(65,'2021-03-29',2021,13,2,95,9,34,49,31,1,49,0,41,25,38,3,33,42,54,0,3,17,85),(66,'2021-04-05',2021,14,2,42,3,34,46,49,2,51,0,19,21,53,0,0,1,100,0,3,6,67),(67,'2021-04-12',2021,15,0,5,1,34,71,51,0,29,0,0,0,0,0,0,0,0,0,0,0,0),(68,'2021-04-19',2021,16,1,0,3,34,0,1,100,0,0,0,0,0,0,0,0,0,0,0,0,0),(69,'2021-04-26',2021,17,0,0,1,34,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(70,'2021-05-03',2021,18,0,0,1,34,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(71,NULL,2021,19,0,0,0,34,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(72,NULL,2021,20,0,0,1,34,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(73,NULL,2021,21,0,0,0,34,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(74,NULL,2021,22,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(75,NULL,2021,23,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(76,NULL,2021,24,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(77,NULL,2021,25,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(78,NULL,2021,26,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(79,NULL,2021,27,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(80,NULL,2021,28,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(81,NULL,2021,29,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(82,NULL,2021,30,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(83,NULL,2021,31,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(84,NULL,2021,32,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(85,NULL,2021,33,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(86,NULL,2021,34,0,0,1,34,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(87,NULL,2021,35,0,0,0,34,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(88,NULL,2021,36,0,0,1,34,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(89,NULL,2021,37,0,0,0,34,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(90,NULL,2021,38,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(91,NULL,2021,39,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(92,NULL,2021,40,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(93,NULL,2021,41,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(94,NULL,2021,42,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(95,NULL,2021,43,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(96,NULL,2021,44,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(97,NULL,2021,45,0,1,0,34,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0),(98,NULL,2021,46,0,0,1,34,100,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(99,NULL,2021,47,0,0,2,34,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(100,NULL,2021,48,0,0,0,34,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(101,NULL,2021,49,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(102,NULL,2021,50,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(103,NULL,2021,51,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(104,NULL,2021,52,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `ds_tarifario_win_ratio_sem` 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-07-25 20:18:08
