Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 16768 | Rev 16802 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
16758 efrain 1 
<?php
2 
declare(strict_types=1);
3 
 
4 
namespace LeadersLinked\Controller;
5 
 
6 
use Laminas\Db\Adapter\AdapterInterface;
16768 efrain 7 
 
16758 efrain 8 
use Laminas\Mvc\Controller\AbstractActionController;
9 
use Laminas\Log\LoggerInterface;
10 
use Laminas\View\Model\ViewModel;
11 
use Laminas\View\Model\JsonModel;
12 
use LeadersLinked\Mapper\QueryMapper;
13 
use PhpOffice\PhpSpreadsheet\IOFactory;
14 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
15 
use LeadersLinked\Form\DiscoveryContact\ContactDownloadForm;
16 
use LeadersLinked\Mapper\DiscoveryContactMapper;
17 
use Laminas\Mvc\I18n\Translator;
16766 efrain 18 
use LeadersLinked\Library\Functions;
16758 efrain 19 
 
20 
class DiscoveryContactReportController extends AbstractActionController
21 
{
22 
    /**
23 
     *
16769 efrain 24 
     * @var \Laminas\Db\Adapter\AdapterInterface
16758 efrain 25 
     */
26 
    private $adapter;
27 
 
28 
    /**
29 
     *
16769 efrain 30 
     * @var \LeadersLinked\Cache\CacheInterface
16758 efrain 31 
     */
16769 efrain 32 
    private $cache;
33 
 
34 
 
35 
    /**
36 
     *
37 
     * @var \Laminas\Log\LoggerInterface
38 
     */
16758 efrain 39 
    private $logger;
40 
 
41 
    /**
42 
     *
43 
     * @var array
44 
     */
45 
    private $config;
46 
 
16769 efrain 47 
 
16758 efrain 48 
    /**
49 
     *
16769 efrain 50 
     * @var \Laminas\Mvc\I18n\Translator
16758 efrain 51 
     */
52 
    private $translator;
53 
 
16769 efrain 54 
 
16758 efrain 55 
    /**
56 
     *
16769 efrain 57 
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
58 
     * @param \LeadersLinked\Cache\CacheInterface $cache
59 
     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger
16758 efrain 60 
     * @param array $config
16769 efrain 61 
     * @param \Laminas\Mvc\I18n\Translator $translator
16758 efrain 62 
     */
16769 efrain 63 
    public function __construct($adapter, $cache, $logger, $config, $translator)
16758 efrain 64 
    {
65 
        $this->adapter      = $adapter;
16769 efrain 66 
        $this->cache        = $cache;
16758 efrain 67 
        $this->logger       = $logger;
68 
        $this->config       = $config;
69 
        $this->translator   = $translator;
70 
    }
71 
 
72 
 
73 
    public function indexAction()
74 
    {
75 
 
76 
        $request = $this->getRequest();
77 
        if($request->isGet()) {
78 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
79 
            $currentUser = $currentUserPlugin->getUser();
80 
            $currentCompany = $currentUserPlugin->getCompany();
81 
 
82 
            $headers  = $request->getHeaders();
83 
 
84 
            $isJson = false;
85 
            if($headers->has('Accept')) {
86 
                $accept = $headers->get('Accept');
87 
 
88 
                $prioritized = $accept->getPrioritized();
89 
 
90 
                foreach($prioritized as $key => $value) {
91 
                    $raw = trim($value->getRaw());
92 
 
93 
                    if(!$isJson) {
94 
                        $isJson = strpos($raw, 'json');
95 
                    }
96 
 
97 
                }
98 
            }
99 
 
100 
            if($isJson) {
101 
 
16766 efrain 102 
                $first_name      = Functions::sanitizeFilterString($this->params()->fromQuery('first_name', ''));
103 
                $last_name	     = Functions::sanitizeFilterString($this->params()->fromQuery('last_name', ''));
104 
                $corporate_email = Functions::sanitizeFilterString($this->params()->fromQuery('corporate_email', ''));
105 
                $company         = Functions::sanitizeFilterString($this->params()->fromQuery('company', ''));
106 
                $position        = Functions::sanitizeFilterString($this->params()->fromQuery('position', ''));
107 
                $country	     = Functions::sanitizeFilterString($this->params()->fromQuery('country', ''));
108 
                $state	         = Functions::sanitizeFilterString($this->params()->fromQuery('state', ''));
109 
                $city	         = Functions::sanitizeFilterString($this->params()->fromQuery('city', ''));
110 
                $personal_email  = Functions::sanitizeFilterString($this->params()->fromQuery('personal_email', ''));
111 
                $phone	         = Functions::sanitizeFilterString($this->params()->fromQuery('phone', ''));
112 
                $phone_extension = Functions::sanitizeFilterString($this->params()->fromQuery('phone_extension', ''));
113 
                $celular	     = Functions::sanitizeFilterString($this->params()->fromQuery('celular', ''));
114 
                $whatsapp        = Functions::sanitizeFilterString($this->params()->fromQuery('whatsapp', ''));
115 
                $linkedin	     = Functions::sanitizeFilterString($this->params()->fromQuery('linkedin', ''));
16758 efrain 116 
 
117 
                $queryMapper = QueryMapper::getInstance($this->adapter);
118 
                $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
119 
 
120 
                if($first_name) {
121 
                    $select->where->like('first_name', '%'.$first_name.'%');
122 
                }
123 
                if($last_name) {
124 
                    $select->where->like('last_name', '%'.$last_name.'%');
125 
                }
126 
                if($corporate_email) {
127 
                    $select->where->like('corporate_email', '%'.$corporate_email.'%');
128 
                }
129 
                if($company) {
130 
                    $select->where->like('company', '%'.$company.'%');
131 
                }
132 
                if($position) {
133 
                    $select->where->like('position', '%'.$position.'%');
134 
                }
135 
                if($country) {
136 
                    $select->where->like('country', '%'.$country.'%');
137 
                }
138 
                if($state) {
139 
                    $select->where->like('state', '%'.$state.'%');
140 
                }
141 
                if($city) {
142 
                    $select->where->like('city', '%'.$city.'%');
143 
                }
144 
                if($personal_email) {
145 
                    $select->where->like('personal_email', '%'.$personal_email.'%');
146 
                }
147 
                if($phone) {
148 
                    $select->where->like('phone', '%'.$phone.'%');
149 
                }
150 
                if($phone_extension) {
151 
                    $select->where->like('phone_extension', '%'.$phone_extension.'%');
152 
                }
153 
                if($celular) {
154 
                    $select->where->like('celular', '%'.$celular.'%');
155 
                }
156 
                if($whatsapp) {
157 
                    $select->where->like('whatsapp', '%'.$whatsapp.'%');
158 
                }
159 
                if($linkedin) {
160 
                    $select->where->like('linkedin', '%'.$linkedin.'%');
161 
                }
162 
                $select->limit(100);
163 
                $select->order('added_on ASC');
164 
 
165 
                $items = $queryMapper->fetchAll($select);
166 
 
167 
                return new JsonModel([
168 
                    'success' => true,
169 
                    'data' => [
170 
                        'items' => $items,
171 
                    ]
172 
                ]);
173 
 
174 
 
175 
            } else {
176 
                $form = new ContactDownloadForm();
177 
 
178 
                $this->layout()->setTemplate('layout/layout-backend.phtml');
179 
                $viewModel = new ViewModel();
180 
                $viewModel->setTemplate('leaders-linked/discovery-contact-report/index');
181 
                $viewModel->setVariables([
182 
                   'form' => $form
183 
                ]);
184 
                return $viewModel ;
185 
            }
186 
        }
187 
 
188 
        return new JsonModel([
189 
            'success' => false,
190 
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
191 
        ]);;
192 
    }
193 
 
194 
    public function downloadAction()
195 
    {
196 
        $request = $this->getRequest();
197 
        if($request->isGet()) {
198 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
199 
            $currentUser = $currentUserPlugin->getUser();
200 
            $currentCompany = $currentUserPlugin->getCompany();
201 
 
16766 efrain 202 
            $first_name      = Functions::sanitizeFilterString($this->params()->fromQuery('first_name', ''));
203 
            $last_name	     = Functions::sanitizeFilterString($this->params()->fromQuery('last_name', ''));
204 
            $corporate_email = Functions::sanitizeFilterString($this->params()->fromQuery('corporate_email', ''));
205 
            $company         = Functions::sanitizeFilterString($this->params()->fromQuery('company', ''));
206 
            $position        = Functions::sanitizeFilterString($this->params()->fromQuery('position', ''));
207 
            $country	     = Functions::sanitizeFilterString($this->params()->fromQuery('country', ''));
208 
            $state	         = Functions::sanitizeFilterString($this->params()->fromQuery('state', ''));
209 
            $city	         = Functions::sanitizeFilterString($this->params()->fromQuery('city', ''));
210 
            $personal_email  = Functions::sanitizeFilterString($this->params()->fromQuery('personal_email', ''));
211 
            $phone	         = Functions::sanitizeFilterString($this->params()->fromQuery('phone', ''));
212 
            $phone_extension = Functions::sanitizeFilterString($this->params()->fromQuery('phone_extension', ''));
213 
            $celular	     = Functions::sanitizeFilterString($this->params()->fromQuery('celular', ''));
214 
            $whatsapp        = Functions::sanitizeFilterString($this->params()->fromQuery('whatsapp', ''));
215 
            $linkedin	     = Functions::sanitizeFilterString($this->params()->fromQuery('linkedin', ''));
216 
            $scholarship	 = Functions::sanitizeFilterString($this->params()->fromQuery('scholarship', ''));
16758 efrain 217 
 
218 
            $queryMapper = QueryMapper::getInstance($this->adapter);
219 
            $select = $queryMapper->getSql()->select(DiscoveryContactMapper::_TABLE);
220 
            $select->columns([
221 
                'first_name',
222 
                'last_name',
223 
                'personal_email',
224 
                'corporate_email',
225 
                'company',
226 
                'position',
227 
                'country',
228 
                'state',
229 
                'city',
230 
                'phone',
231 
                'phone_extension',
232 
                'celular',
233 
                'whatsapp',
234 
                'linkedin',
235 
                'sector',
16766 efrain 236 
                'scholarship',
16759 efrain 237 
                'added_on'
16758 efrain 238 
            ]);
239 
 
240 
            if($first_name) {
241 
                $select->where->like('first_name', '%'.$first_name.'%');
242 
            }
243 
            if($last_name) {
244 
                $select->where->like('last_name', '%'.$last_name.'%');
245 
            }
246 
            if($corporate_email) {
247 
                $select->where->like('corporate_email', '%'.$corporate_email.'%');
248 
            }
249 
            if($company) {
250 
                $select->where->like('company', '%'.$company.'%');
251 
            }
252 
            if($position) {
253 
                $select->where->like('position', '%'.$position.'%');
254 
            }
255 
            if($country) {
256 
                $select->where->like('country', '%'.$country.'%');
257 
            }
258 
            if($state) {
259 
                $select->where->like('state', '%'.$state.'%');
260 
            }
261 
            if($city) {
262 
                $select->where->like('city', '%'.$city.'%');
263 
            }
264 
            if($personal_email) {
265 
                $select->where->like('personal_email', '%'.$personal_email.'%');
266 
            }
267 
            if($phone) {
268 
                $select->where->like('phone', '%'.$phone.'%');
269 
            }
270 
            if($phone_extension) {
271 
                $select->where->like('phone_extension', '%'.$phone_extension.'%');
272 
            }
273 
            if($celular) {
274 
                $select->where->like('celular', '%'.$celular.'%');
275 
            }
276 
            if($whatsapp) {
277 
                $select->where->like('whatsapp', '%'.$whatsapp.'%');
278 
            }
279 
            if($linkedin) {
280 
                $select->where->like('linkedin', '%'.$linkedin.'%');
281 
            }
16766 efrain 282 
            if($scholarship) {
283 
               // scholarship
284 
            }
16758 efrain 285 
 
286 
            $spreadsheet = new Spreadsheet();
287 
            $spreadsheet->getProperties()->setTitle('Relevamiento de Contactos');
288 
 
289 
            $sheetIndex = 0;
290 
            $workSheet  =  $spreadsheet->setActiveSheetIndex($sheetIndex);
291 
 
292 
            $max_row = 100000;
293 
            $col = 1;
294 
            $row = 1;
295 
            $items = $queryMapper->fetchAll($select);
16760 efrain 296 
 
297 
 
298 
            $j = 0;
16758 efrain 299 
            foreach ( $items as $item )
300 
            {
16760 efrain 301 
                $j++;
16758 efrain 302 
 
303 
                if($row == 1) {
304 
                    $col = 1;
305 
                    $labels = [
306 
                        $this->translator->translate('LABEL_FIRST_NAME'),
307 
                        $this->translator->translate('LABEL_LAST_NAME'),
308 
                        $this->translator->translate('LABEL_PERSONAL_EMAIL'),
309 
                        $this->translator->translate('LABEL_CORPORATE_EMAIL'),
310 
                        $this->translator->translate('LABEL_COMPANY'),
311 
                        $this->translator->translate('LABEL_POSITION'),
312 
                        $this->translator->translate('LABEL_COUNTRY'),
313 
                        $this->translator->translate('LABEL_STATE'),
314 
                        $this->translator->translate('LABEL_CITY'),
315 
                        $this->translator->translate('LABEL_PHONE'),
316 
                        $this->translator->translate('LABEL_PHONE_EXTENSION'),
317 
                        $this->translator->translate('LABEL_CELULAR'),
318 
                        $this->translator->translate('LABEL_WHATSAPP'),
319 
                        $this->translator->translate('LABEL_LINKEDIN'),
16759 efrain 320 
                        $this->translator->translate('LABEL_SECTOR'),
16766 efrain 321 
                        $this->translator->translate('LABEL_SCHOLARSHIP'),
16759 efrain 322 
                        $this->translator->translate('LABEL_ADDED_DATE')
16758 efrain 323 
                    ];
324 
 
325 
 
326 
                    foreach ($labels as $label)
327 
                    {
328 
                        $workSheet->setCellValue([$col, $row],$label );
329 
                        $col++;
330 
                    }
331 
                    $row++;
332 
                }
333 
 
334 
 
335 
 
336 
                $col = 1;
337 
                foreach($item as $value)
338 
                {
339 
                    $workSheet->setCellValue([$col, $row], $value);
340 
                    $col++;
341 
                }
342 
 
16759 efrain 343 
 
16760 efrain 344 
                $row++;
16758 efrain 345 
                if($row > $max_row) {
346 
                    $row = 1;
347 
                    $workSheet = $spreadsheet->createSheet();
348 
 
349 
                }
350 
 
351 
            }
352 
 
16760 efrain 353 
 
354 
 
16758 efrain 355 
            $fileName = 'reporte_relevamiento_de_contactos_'  . date('d-m-Y-h-i-a', time()) . '.xls';
356 
            $tempFilename = tempnam(sys_get_temp_dir(), 'reporte_relevamiento_de_contactos_' . time());
357 
 
358 
            $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
359 
            $writer->save($tempFilename);
360 
 
361 
            $content = file_get_contents($tempFilename);
362 
            @unlink($tempFilename);
363 
 
364 
            return new JsonModel([
365 
                'success' => true,
366 
                'data' => [
367 
                    'content' => base64_encode($content),
368 
                    'basename' => $fileName
369 
 
370 
                ]
371 
            ]);
372 
 
373 
        }
374 
 
375 
        return new JsonModel([
376 
            'success' => false,
377 
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
378 
        ]);;
379 
    }
380 
 
381 
 
382 
 
383 
 
384 
}