Proyectos de Subversion LeadersLinked - Services

Rev

Rev 283 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 283 Rev 345
Línea 1... Línea 1...
1 
<?php
 1 
<?php
2 
 
 - 
 
3 
declare(strict_types=1);
 2 
declare(strict_types = 1);
4 
 
 - 
 
5 
namespace LeadersLinked\Command;
 3 
namespace LeadersLinked\Command;
Línea 6... Línea 4...
6 
 
 4 
 
7 
use Symfony\Component\Console\Command\Command;
 5 
use Symfony\Component\Console\Command\Command;
8 
use Symfony\Component\Console\Input\InputInterface;
 6 
use Symfony\Component\Console\Input\InputInterface;
9 
//use Symfony\Component\Console\Input\InputOption;
 7 
// use Symfony\Component\Console\Input\InputOption;
10 
use Symfony\Component\Console\Output\OutputInterface;
 8 
use Symfony\Component\Console\Output\OutputInterface;
11 
use Laminas\Db\Adapter\AdapterInterface;
 - 
 
12 
 
 9 
use Laminas\Db\Adapter\AdapterInterface;
13 
use Laminas\Log\LoggerInterface;
 10 
use Laminas\Log\LoggerInterface;
14 
use LeadersLinked\Mapper\MicrolearningUserProgressMapper;
 11 
use LeadersLinked\Mapper\MicrolearningUserProgressMapper;
15 
use LeadersLinked\Mapper\MicrolearningSlideMapper;
 12 
use LeadersLinked\Mapper\MicrolearningSlideMapper;
16 
use LeadersLinked\Mapper\QueryMapper;
 13 
use LeadersLinked\Mapper\QueryMapper;
17 
use LeadersLinked\Model\MicrolearningUserProgress;
 14 
use LeadersLinked\Model\MicrolearningUserProgress;
18 
use Laminas\Mvc\I18n\Translator;
 15 
use Laminas\Mvc\I18n\Translator;
Línea 19... Línea -...
19 
use LeadersLinked\Cache\CacheInterface;
 - 
 
20 
 
 16 
use LeadersLinked\Cache\CacheInterface;
21 
 
 17 
 
- 
 
 18 
class RecalculateMicrolearningProgressCommand extends Command
22 
class RecalculateMicrolearningProgressCommand extends Command
 19 
{
23 
{
 20 
 
24 
    /**
 21 
    /**
25 
     *
 22 
     *
26 
     * @var \Laminas\Db\Adapter\AdapterInterface
 23 
     * @var \Laminas\Db\Adapter\AdapterInterface
27 
     */
 24 
     */
28 
    private $adapter;
 25 
    private $adapter;
29
26 
 
30 
    /**
 27 
    /**
31 
     *
 28 
     *
32 
     * @var \LeadersLinked\Cache\CacheInterface
 29 
     * @var \LeadersLinked\Cache\CacheInterface
33 
     */
 - 
 
34 
    private $cache;
 30 
     */
35
31 
    private $cache;
36
32 
 
37 
    /**
 33 
    /**
38 
     *
 34 
     *
39 
     * @var \Laminas\Log\LoggerInterface
 35 
     * @var \Laminas\Log\LoggerInterface
40 
     */
 36 
     */
41 
    private $logger;
 37 
    private $logger;
42
38 
 
43 
    /**
 39 
    /**
44 
     *
 40 
     *
45 
     * @var array
 41 
     * @var array
46 
     */
 - 
 
47 
    private $config;
 42 
     */
48
43 
    private $config;
49
44 
 
50 
    /**
 45 
    /**
51 
     *
 46 
     *
52 
     * @var \Laminas\Mvc\I18n\Translator
 47 
     * @var \Laminas\Mvc\I18n\Translator
53 
     */
 - 
 
54 
    private $translator;
 48 
     */
55
49 
    private $translator;
56
50 
 
57 
    /**
 51 
    /**
58 
     *
 52 
     *
- 
 
 53 
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
59 
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
 54 
     * @param \LeadersLinked\Cache\CacheInterface $cache
60 
     * @param \LeadersLinked\Cache\CacheInterface $cache
 55 
     * @param
61 
     * @param \Laminas\Log\LoggerInterface
 56 
     *            \Laminas\Log\LoggerInterface
62 
     * @param array $config
 57 
     * @param array $config
63 
     * @param \Laminas\Mvc\I18n\Translator $translator
 58 
     * @param \Laminas\Mvc\I18n\Translator $translator
64 
     */
 59 
     */
65 
    public function __construct($adapter, $cache, $logger, $config, $translator)
 60 
    public function __construct($adapter, $cache, $logger, $config, $translator)
66 
    {
 61 
    {
67 
        $this->adapter      = $adapter;
 62 
        $this->adapter = $adapter;
68 
        $this->cache        = $cache;
 63 
        $this->cache = $cache;
69 
        $this->logger       = $logger;
 64 
        $this->logger = $logger;
70 
        $this->config       = $config;
 65 
        $this->config = $config;
71 
        $this->translator   = $translator;
 66 
        $this->translator = $translator;
72
67 
 
Línea 73... Línea -...
73 
        parent::__construct();
 - 
 
74 
    }
 68 
        parent::__construct();
75 
 
 69 
    }
Línea -... Línea 70...
- 
 
 70 
 
76
71 
    protected function execute(InputInterface $input, OutputInterface $output): int
77 
    protected function execute(InputInterface $input, OutputInterface $output) : int
 72 
    {
78 
    {
 73 
 
79 
 
 74 
        /**
Línea 80... Línea -...
80 
        /***** INICIO TOPICOS DUPLICADOS *****/
 - 
 
81 
 
 75 
         * *** INICIO TOPICOS DUPLICADOS ****
82 
        $output->writeln('Comenzamos a buscar los registros duplicados de los Tópicos');
 76 
         */
83 
        $queryMapper = QueryMapper::getInstance($this->adapter);
 77 
        $output->writeln('Comenzamos a buscar los registros duplicados de los Tópicos');
84 
 
 78 
        $queryMapper = QueryMapper::getInstance($this->adapter);
85
79 
 
86 
        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 80 
        $sql = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
87 
        echo $sql . PHP_EOL;
 - 
 
88
81 
        echo $sql . PHP_EOL;
89 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
 - 
 
90
82 
 
91 
        foreach($record_users as $record_user)
 83 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
92 
        {
 84 
 
93 
            $user_id = $record_user['user_id'];
 85 
        foreach ($record_users as $record_user) {
94
86 
            $user_id = $record_user['user_id'];
95
87 
 
96 
            $sql  = " SELECT DISTINCT(topic_id) AS topic_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 88 
            $sql = " SELECT DISTINCT(topic_id) AS topic_id FROM " . MicrolearningUserProgressMapper::_TABLE;
97 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";
 - 
 
Línea 98... Línea 89...
98 
            $sql .= " AND user_id = $user_id";
 89 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";
99
- 
 
100 
            echo $sql . PHP_EOL;
 90 
            $sql .= " AND user_id = $user_id";
101 
            $records_topic = $queryMapper->fetchAllUsingParameters($sql);
 91 
 
102
92 
            echo $sql . PHP_EOL;
103 
 
 93 
            $records_topic = $queryMapper->fetchAllUsingParameters($sql);
104 
            foreach($records_topic as $record_topic)
 94 
 
105 
            {
 95 
            foreach ($records_topic as $record_topic) {
106 
                $topic_id = $record_topic['topic_id'];
 96 
                $topic_id = $record_topic['topic_id'];
107
97 
 
108 
                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
 98 
                $sql = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
109 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";
 99 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";
110 
                $sql .= " AND user_id = $user_id";
 100 
                $sql .= " AND user_id = $user_id";
111 
                $sql .= " AND topic_id = $topic_id";
 101 
                $sql .= " AND topic_id = $topic_id";
112 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
 102 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
113 
                echo $sql . PHP_EOL;
 103 
                echo $sql . PHP_EOL;
114
104 
 
115 
                $record = $queryMapper->fetchOneUsingParameters($sql);
 105 
                $record = $queryMapper->fetchOneUsingParameters($sql);
116 
                $id = $record['id'];
 106 
                $id = $record['id'];
117
107 
 
118 
                $sql  = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
 - 
 
119 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_TOPIC ."' ";
 - 
 
Línea -... Línea 108...
- 
 
 108 
                $sql = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
120 
                $sql .= " AND user_id = $user_id ";
 109 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";
121 
                $sql .= " AND topic_id = $topic_id ";
 110 
                $sql .= " AND user_id = $user_id ";
122 
                $sql .= " AND id <> $id ";
 111 
                $sql .= " AND topic_id = $topic_id ";
123 
                echo $sql . PHP_EOL;
 112 
                $sql .= " AND id <> $id ";
- 
 
 113 
                echo $sql . PHP_EOL;
124
114 
 
125 
                $queryMapper->delete($sql);
 115 
                $queryMapper->delete($sql);
126 
 
 116 
            }
127 
            }
 117 
        }
128 
        }
 118 
        $output->writeln('Terminamos de procesar los registros duplicados de los Tópicos');
- 
 
 119 
 
129 
        $output->writeln('Terminamos de procesar los registros duplicados de los Tópicos');
 120 
        /**
130
121 
         * *** FIN TOPICOS DUPLICADOS ****
131 
        /***** FIN TOPICOS DUPLICADOS *****/
 122 
         */
132
- 
 
133
123 
 
134
124 
        /**
135 
        /***** INICIO CAPSULAS DUPLICADOS *****/
 125 
         * *** INICIO CAPSULAS DUPLICADOS ****
136
126 
         */
137 
        $output->writeln('Comenzamos a buscar los registros duplicados de las Capsulas');
 127 
 
138 
        $queryMapper = QueryMapper::getInstance($this->adapter);
 128 
        $output->writeln('Comenzamos a buscar los registros duplicados de las Capsulas');
139
129 
        $queryMapper = QueryMapper::getInstance($this->adapter);
140
- 
 
141 
        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 130 
 
142 
        echo $sql . PHP_EOL;
 - 
 
143
131 
        $sql = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
144 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
 132 
        echo $sql . PHP_EOL;
145
133 
 
146 
        foreach($record_users as $record_user)
 134 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
147 
        {
 135 
 
148 
            $user_id = $record_user['user_id'];
 136 
        foreach ($record_users as $record_user) {
149
137 
            $user_id = $record_user['user_id'];
150
- 
 
151 
            $sql  = " SELECT DISTINCT(capsule_id) AS capsule_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 138 
 
152 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";
 139 
            $sql = " SELECT DISTINCT(capsule_id) AS capsule_id FROM " . MicrolearningUserProgressMapper::_TABLE;
153 
            $sql .= " AND user_id = $user_id";
 - 
 
154
140 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";
155 
            echo $sql . PHP_EOL;
 141 
            $sql .= " AND user_id = $user_id";
156 
            $records_capsule = $queryMapper->fetchAllUsingParameters($sql);
 142 
 
157
143 
            echo $sql . PHP_EOL;
158
144 
            $records_capsule = $queryMapper->fetchAllUsingParameters($sql);
159 
            foreach($records_capsule as $record_capsule)
 145 
 
160 
            {
 146 
            foreach ($records_capsule as $record_capsule) {
161 
                $capsule_id = $record_capsule['capsule_id'];
 147 
                $capsule_id = $record_capsule['capsule_id'];
162
148 
 
163 
                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
 149 
                $sql = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
164 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";
 150 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";
165 
                $sql .= " AND user_id = $user_id";
 151 
                $sql .= " AND user_id = $user_id";
166 
                $sql .= " AND capsule_id = $capsule_id";
 152 
                $sql .= " AND capsule_id = $capsule_id";
167 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
 153 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
168 
                echo $sql . PHP_EOL;
 154 
                echo $sql . PHP_EOL;
169
155 
 
170 
                $record = $queryMapper->fetchOneUsingParameters($sql);
 156 
                $record = $queryMapper->fetchOneUsingParameters($sql);
171 
                $id = $record['id'];
 157 
                $id = $record['id'];
172
158 
 
173 
                $sql  = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
 159 
                $sql = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
174 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_CAPSULE ."' ";
 - 
 
175 
                $sql .= " AND user_id = $user_id ";
 160 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";
176 
                $sql .= " AND capsule_id = $capsule_id ";
 161 
                $sql .= " AND user_id = $user_id ";
177 
                $sql .= " AND id <> $id ";
 162 
                $sql .= " AND capsule_id = $capsule_id ";
178 
                echo $sql . PHP_EOL;
 163 
                $sql .= " AND id <> $id ";
- 
 
 164 
                echo $sql . PHP_EOL;
179
165 
 
180 
                $queryMapper->delete($sql);
 166 
                $queryMapper->delete($sql);
181
167 
            }
182 
            }
 168 
        }
183 
        }
 169 
        $output->writeln('Terminamos de procesar los registros duplicados de las Capsulas');
- 
 
 170 
 
184 
        $output->writeln('Terminamos de procesar los registros duplicados de las Capsulas');
 171 
        /**
185
172 
         * *** FIN CAPSULAS DUPLICADOS ****
186 
        /***** FIN CAPSULAS DUPLICADOS *****/
 173 
         */
187
- 
 
188
174 
 
189
175 
        /**
190 
        /***** INICIO DIAPOSITIVAS DUPLICADOS *****/
 176 
         * *** INICIO DIAPOSITIVAS DUPLICADOS ****
191
177 
         */
192 
        $output->writeln('Comenzamos a buscar los registros duplicados de las Diapositivas');
 178 
 
193 
        $queryMapper = QueryMapper::getInstance($this->adapter);
 179 
        $output->writeln('Comenzamos a buscar los registros duplicados de las Diapositivas');
194
180 
        $queryMapper = QueryMapper::getInstance($this->adapter);
195
- 
 
196 
        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 181 
 
197 
        echo $sql . PHP_EOL;
 - 
 
198
182 
        $sql = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;
199 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
 183 
        echo $sql . PHP_EOL;
200
184 
 
201 
        foreach($record_users as $record_user)
 185 
        $record_users = $queryMapper->fetchAllUsingParameters($sql);
202 
        {
 186 
 
203 
            $user_id = $record_user['user_id'];
 187 
        foreach ($record_users as $record_user) {
204
188 
            $user_id = $record_user['user_id'];
205
- 
 
206 
            $sql  = " SELECT DISTINCT(slide_id) AS slide_id FROM " . MicrolearningUserProgressMapper::_TABLE;
 189 
 
207 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";
 190 
            $sql = " SELECT DISTINCT(slide_id) AS slide_id FROM " . MicrolearningUserProgressMapper::_TABLE;
208 
            $sql .= " AND user_id = $user_id";
 - 
 
209
191 
            $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";
210 
            echo $sql . PHP_EOL;
 192 
            $sql .= " AND user_id = $user_id";
211 
            $records_slides = $queryMapper->fetchAllUsingParameters($sql);
 193 
 
212
194 
            echo $sql . PHP_EOL;
213
195 
            $records_slides = $queryMapper->fetchAllUsingParameters($sql);
214 
            foreach($records_slides as $record_slide)
 196 
 
215 
            {
 197 
            foreach ($records_slides as $record_slide) {
216 
                $slide_id = $record_slide['slide_id'];
 198 
                $slide_id = $record_slide['slide_id'];
217
199 
 
218 
                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
 200 
                $sql = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;
219 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";
 201 
                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";
220 
                $sql .= " AND user_id = $user_id";
 202 
                $sql .= " AND user_id = $user_id";
221 
                $sql .= " AND slide_id = $slide_id";
 203 
                $sql .= " AND slide_id = $slide_id";
222 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
 204 
                $sql .= " ORDER BY completed DESC LIMIT 0, 1";
223 
                echo $sql . PHP_EOL;
 205 
                echo $sql . PHP_EOL;
224
206 
 
225 
                $record = $queryMapper->fetchOneUsingParameters($sql);
 207 
                $record = $queryMapper->fetchOneUsingParameters($sql);
226 
                $id = $record['id'];
 208 
                $id = $record['id'];
227
209 
 
228 
                $sql  = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
 210 
                $sql = " DELETE FROM " . MicrolearningUserProgressMapper::_TABLE;
229 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_SLIDE ."' ";
 - 
 
230 
                $sql .= " AND user_id = $user_id ";
 211 
                $sql .= " WHERE type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";
231 
                $sql .= " AND slide_id = $slide_id ";
 212 
                $sql .= " AND user_id = $user_id ";
232 
                $sql .= " AND id <> $id ";
 213 
                $sql .= " AND slide_id = $slide_id ";
233 
                echo $sql . PHP_EOL;
 214 
                $sql .= " AND id <> $id ";
- 
 
 215 
                echo $sql . PHP_EOL;
234
216 
 
- 
 
 217 
                $queryMapper->delete($sql);
235 
                $queryMapper->delete($sql);
 218 
            }
236
219 
        }
237 
            }
 220 
        $output->writeln('Terminamos de procesar los registros duplicados de las Diapositivas');
238 
        }
 - 
 
239 
        $output->writeln('Terminamos de procesar los registros duplicados de las Diapositivas');
 221 
 
240
222 
        /**
241 
        /***** FIN DIAPOSITIVAS DUPLICADOS *****/
 223 
         * *** FIN DIAPOSITIVAS DUPLICADOS ****
242
224 
         */
Línea 243... Línea 225...
243 
        $progressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
 225 
 
244 
        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
 226 
        $progressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
245
227 
        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
246
228 
 
247 
        $output->writeln('Recalculo del progreso de los Tópicos');
 229 
        $output->writeln('Recalculo del progreso de los Tópicos');
248
230 
 
249 
        $records = $progressMapper->fetchAllTopics();
 231 
        $records = $progressMapper->fetchAllTopics();
Línea 250... Línea 232...
250 
 
 232 
 
251 
        foreach($records as $record)
 233 
        foreach ($records as $record) {
252 
        {   $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicId($record->company_id,$record->topic_id);
 234 
            $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicId($record->company_id, $record->topic_id);
253 
            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicId($record->user_id, $record->topic_id);
 235 
            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicId($record->user_id, $record->topic_id);
254
236 
 
255 
            $record->total_slides = $total_slides;
 237 
            $record->total_slides = $total_slides;
256 
            $record->view_slides = $view_slides;
 238 
            $record->view_slides = $view_slides;
257 
            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;
 239 
            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;
258 
 
 240 
 
Línea 259... Línea -...
259 
            $sql  = " UPDATE  " . MicrolearningUserProgressMapper::_TABLE;
 - 
 
260 
            $sql .= " SET progress =  " . $record->progress;
 241 
            $sql = " UPDATE  " . MicrolearningUserProgressMapper::_TABLE;
261 
            $sql .= " , total_slides =  " . $total_slides;
 242 
            $sql .= " SET progress =  " . $record->progress;
262 
            $sql .= " , view_slides  =  " . $view_slides;
 243 
            $sql .= " , total_slides =  " . $total_slides;
263 
            $sql .= " WHERE id =  " . $record->id;
 - 
 
264 
            echo $sql . PHP_EOL;
 244 
            $sql .= " , view_slides  =  " . $view_slides;
265
245 
            $sql .= " WHERE id =  " . $record->id;
266 
            $queryMapper->update($sql);
 246 
            echo $sql . PHP_EOL;
267 
        }
 247 
 
268 
 
 248 
            $queryMapper->update($sql);
269
249 
        }
270 
        $output->writeln('Inicio del proceso de Recalculo de las Capsulas');
 - 
 
271 
        $records = $progressMapper->fetchAllCapsules();
 250 
 
272 
        foreach($records as $record)
 251 
        $output->writeln('Inicio del proceso de Recalculo de las Capsulas');
273 
        {
 252 
        $records = $progressMapper->fetchAllCapsules();
274 
            $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicIdAndCapsuleId($record->company_id, $record->topic_id, $record->capsule_id);
 253 
        foreach ($records as $record) {
275 
            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicIdAndCapsuleId($record->user_id, $record->topic_id, $record->capsule_id);
 254 
            $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicIdAndCapsuleId($record->company_id, $record->topic_id, $record->capsule_id);
276
255 
            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicIdAndCapsuleId($record->user_id, $record->topic_id, $record->capsule_id);
277 
            $record->total_slides = $total_slides;
 256 
 
278 
            $record->view_slides = $view_slides;
 257 
            $record->total_slides = $total_slides;
279 
            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;
 258 
            $record->view_slides = $view_slides;
280
259 
            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;
281
260 
 
282 
            $sql  = " UPDATE  " . MicrolearningUserProgressMapper::_TABLE;
 261 
            $sql = " UPDATE  " . MicrolearningUserProgressMapper::_TABLE;
283 
            $sql .= " SET progress =  " . $record->progress;
- 
 
Línea 284... Línea 262...
284 
            $sql .= " , total_slides =  " . $total_slides;
262 
            $sql .= " SET progress =  " . $record->progress;
285 
            $sql .= " , view_slides  =  " . $view_slides;
263 
            $sql .= " , total_slides =  " . $total_slides;
286 
            $sql .= " WHERE id =  " . $record->id;
264 
            $sql .= " , view_slides  =  " . $view_slides;
287 
            echo $sql . PHP_EOL;
 265 
            $sql .= " WHERE id =  " . $record->id;
288
- 
 
289 
            $queryMapper->update($sql);
 - 
 
290
- 
 
291 
            //$progressMapper->update($record);
 266 
            echo $sql . PHP_EOL;
292 
        }
 267