Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 16769 Rev 16971
Línea 11... Línea 11...
11 
use Laminas\Log\LoggerInterface;
 11 
use Laminas\Log\LoggerInterface;
12 
use Laminas\Mvc\I18n\Translator;
 12 
use Laminas\Mvc\I18n\Translator;
Línea 13... Línea 13...
13 
 
 13 
 
14 
use Laminas\View\Model\JsonModel;
 14 
use Laminas\View\Model\JsonModel;
- 
 
 15 
use Laminas\View\Model\ViewModel;
15 
use Laminas\View\Model\ViewModel;
 16 
use LeadersLinked\Mapper\DiscoveryContactBlackListMapper;
16 
use LeadersLinked\Mapper\UserMapper;
 17 
use LeadersLinked\Mapper\UserMapper;
17 
use LeadersLinked\Mapper\QueryMapper;
 18 
use LeadersLinked\Mapper\QueryMapper;
18 
use LeadersLinked\Mapper\DiscoveryContactMapper;
 19 
use LeadersLinked\Mapper\DiscoveryContactMapper;
19 
use Laminas\Db\Sql\Expression;
 20 
use Laminas\Db\Sql\Expression;
Línea 105... Línea 106...
105 
            }
 106 
            }
Línea 106... Línea 107...
106
107
107
108
- 
 
 109 
            //$isJson =  true;
Línea 108... Línea 110...
108 
            //$isJson =  true;
 110 
            if ($isJson) {
109 
            if ($isJson) {
 111
110 
 
 112 
 
111 
                $startDate = $this->params()->fromQuery('startDate');
 113 
                $startDate = $this->params()->fromQuery('startDate');
Línea 149... Línea 151...
149
151
Línea -... Línea 152...
- 
 
 152
- 
 
 153 
                } while($endDate > $tempDate);
- 
 
 154
- 
 
 155
- 
 
 156 
                $discoveryContactBlackListMapper = DiscoveryContactBlackListMapper::getInstance($this->adapter);
150
157 
                $contact_ids = $discoveryContactBlackListMapper->fetchAllContactIdsByCompanyId($currentCompany->id);
Línea 151... Línea 158...
151 
                } while($endDate > $tempDate);
 158
152
159
153
160
Línea 163... Línea 170...
163 
                $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
 170 
                $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
164 
                $select->columns([
 171 
                $select->columns([
165 
                    'total' => new Expression('COUNT(*)'),
 172 
                    'total' => new Expression('COUNT(*)'),
166 
                    'date' => new Expression('DATE(added_on)'),
 173 
                    'date' => new Expression('DATE(added_on)'),
167 
                ]);
 174 
                ]);
- 
 
 175
- 
 
 176 
                if($contact_ids) {
- 
 
 177 
                    $select->where->notIn('id', $contact_ids);
- 
 
 178 
                }
- 
 
 179
- 
 
 180
168 
                $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
 181 
                $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
169 
                $select->group(new Expression('DATE(added_on)'));
 182 
                $select->group(new Expression('DATE(added_on)'));
170 
                $select->order('date ASC');
 183 
                $select->order('date ASC');
Línea 171... Línea 184...
171
184
Línea 197... Línea 210...
197 
                    'total' => new Expression('COUNT(*)'),
 210 
                    'total' => new Expression('COUNT(*)'),
198 
                    'date' => new Expression('DATE(added_on)'),
 211 
                    'date' => new Expression('DATE(added_on)'),
199 
                ]);
 212 
                ]);
200 
                $select->where->equalTo('interaction_type_id', $discoveryContactInteractionType->id);
 213 
                $select->where->equalTo('interaction_type_id', $discoveryContactInteractionType->id);
201 
                $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
 214 
                $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
- 
 
 215
- 
 
 216 
                if($contact_ids) {
- 
 
 217 
                    $select->where->notIn('contact_id', $contact_ids);
- 
 
 218 
                }
- 
 
 219
202 
                $select->group([ new Expression('DATE(added_on)'), 'user_id']);
 220 
                $select->group([ new Expression('DATE(added_on)'), 'user_id']);
203 
                $select->order('date ASC');
 221 
                $select->order('date ASC');
Línea 204... Línea 222...
204
222
205 
                $records = $queryMapper->fetchAll($select);
 223 
                $records = $queryMapper->fetchAll($select);
Línea 373... Línea 391...
373 
                $dt->add(new \DateInterval('P1D'));
 391 
                $dt->add(new \DateInterval('P1D'));
Línea 374... Línea 392...
374
392
Línea -... Línea 393...
- 
 
 393
- 
 
 394 
            } while($endDate > $tempDate);
- 
 
 395
- 
 
 396 
            $discoveryContactBlackListMapper = DiscoveryContactBlackListMapper::getInstance($this->adapter);
Línea 375... Línea 397...
375
397 
            $contact_ids = $discoveryContactBlackListMapper->fetchAllContactIdsByCompanyId($currentCompany->id);
Línea 376... Línea 398...
376 
            } while($endDate > $tempDate);
 398
377
399
Línea 388... Línea 410...
388 
            $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
 410 
            $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
389 
            $select->columns([
 411 
            $select->columns([
390 
                'total' => new Expression('COUNT(*)'),
 412 
                'total' => new Expression('COUNT(*)'),
391 
                'date' => new Expression('DATE(added_on)'),
 413 
                'date' => new Expression('DATE(added_on)'),
392 
            ]);
 414 
            ]);
- 
 
 415
- 
 
 416 
            if($contact_ids) {
- 
 
 417 
                $select->where->notIn('id', $contact_ids);
- 
 
 418 
            }
- 
 
 419
393 
            $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
 420 
            $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
394 
            $select->group(new Expression('DATE(added_on)'));
 421 
            $select->group(new Expression('DATE(added_on)'));
395 
            $select->order('date ASC');
 422 
            $select->order('date ASC');
Línea 396... Línea 423...
396
423
Línea 422... Línea 449...
422 
                'total' => new Expression('COUNT(*)'),
 449 
                'total' => new Expression('COUNT(*)'),
423 
                'date' => new Expression('DATE(added_on)'),
 450 
                'date' => new Expression('DATE(added_on)'),
424 
            ]);
 451 
            ]);
425 
            $select->where->equalTo('interaction_type_id', $discoveryContactInteractionType->id);
 452 
            $select->where->equalTo('interaction_type_id', $discoveryContactInteractionType->id);
426 
            $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
 453 
            $select->where->between( new Expression('DATE(added_on)') , $startDate,  $endDate);
- 
 
 454
- 
 
 455 
            if($contact_ids) {
- 
 
 456 
                $select->where->notIn('contact_id', $contact_ids);
- 
 
 457 
            }
- 
 
 458
- 
 
 459
427 
            $select->group([ new Expression('DATE(added_on)'), 'user_id']);
 460 
            $select->group([ new Expression('DATE(added_on)'), 'user_id']);
428 
            $select->order('date ASC');
 461 
            $select->order('date ASC');
Línea 429... Línea 462...
429
462
430 
            $records = $queryMapper->fetchAll($select);
 463 
            $records = $queryMapper->fetchAll($select);