Proyectos de Subversion LeadersLinked - Backend

Rev

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