WebSVN – LeadersLinked - Backend – Diff – /module/LeadersLinked/src/Controller/DiscoveryContactController.php

 declare(strict_types=1);
 namespace LeadersLinked\Controller;
 use Laminas\Db\Adapter\AdapterInterface;
-use Laminas\Cache\Storage\Adapter\AbstractAdapter;
+use LeadersLinked\Cache\CacheInterface;
     private $adapter;
     /**
+     *
-     * @var AbstractAdapter
+     * @var CacheInterface
      */
     private $cache;
     private $config;
     /**
+     *
      * @param AdapterInterface $adapter
-     * @param AbstractAdapter $cache
+     * @param CacheInterface $cache
      * @param LoggerInterface $logger
      * @param array $config
      */
     public function __construct($adapter, $cache, $logger, $config)
+                }
+            }
             if ($isJson) {
                 $search = $this->params()->fromQuery('search');
-                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
+                $search = empty($search['value']) ? '' :  Functions::sanitizeFilterString($search['value']);
                 $page               = intval($this->params()->fromQuery('start', 1), 10);
                 $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
                 $order =  $this->params()->fromQuery('order', []);
                 $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
-                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
+                $order_direction    = empty($order[0]['dir']) ? 'ASC' : Functions::sanitizeFilterString(filter_var($order[0]['dir']));
                 $items = [];
                 $records = $paginator->getCurrentItems();
+                foreach ($records as $record) {
+                    switch($record->scholarship)
+                    {
+                        case DiscoveryContact::SCHOLARSHIP_YES :
+                            $scholarship = 'LABEL_YES';
+                            break;
+                        case DiscoveryContact::SCHOLARSHIP_NO :
+                            $scholarship = 'LABEL_NO';
+                            break;
+                        default :
+                            $scholarship = 'LABEL_UNKNOW';
+                            break;
                 foreach ($records as $record) {
                     $item = [
                         'first_name' => $record->first_name,
                         'last_name' => $record->last_name,
                         'corporate_email' => $record->corporate_email,
+                        'company' => $record->company,
-                        'company' => $record->company,
+                        'country' => $record->country,
-                        'country' => $record->country,
+                        'sector' => $record->sector,
-                        'sector' => $record->sector,
+                        'scholarship' => $scholarship,
                         'actions' => [
                             'link_edit' => $this->url()->fromRoute('discovery-contacts/edit', ['id' => $record->uuid]),
                         $discoveryContactLog->details .= 'LABEL_WHATSAPP : ' . $discoveryContact->whatsapp  . PHP_EOL;
+                    }
                     if ($discoveryContact->linkedin) {
                         $discoveryContactLog->details .= 'LABEL_LINKEDIN : ' . $discoveryContact->linkedin  . PHP_EOL;
+                    }
+                    if ($discoveryContact->scholarship) {
+                        $discoveryContactLog->details .= 'LABEL_SCHOLARSHIP : ' . $discoveryContact->scholarship  . PHP_EOL;
+                    }
                     $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
                     $discoveryContactLogMapper->insert($discoveryContactLog);
                         $discoveryContactLog->details .= 'LABEL_WHATSAPP : ' . $discoveryContactOld->whatsapp . ' / ' . $discoveryContact->whatsapp  . PHP_EOL;
+                    }
                     if ($discoveryContactOld->linkedin != $discoveryContact->linkedin) {
                         $discoveryContactLog->details .= 'LABEL_LINKEDIN : ' . $discoveryContactOld->linkedin . ' / ' . $discoveryContact->linkedin  . PHP_EOL;
+                    }
+                    if ($discoveryContactOld->scholarship != $discoveryContact->scholarship) {
+                        $discoveryContactLog->details .= 'LABEL_SCHOLARSHIP: ' . $discoveryContactOld->scholarship . ' / ' . $discoveryContact->scholarship  . PHP_EOL;
+                    }
                     $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
                     $discoveryContactLogMapper->insert($discoveryContactLog);
             $data['phone_extension'] = $data['phone_extension'] ? trim($data['phone_extension']) : '';
             $data['personal_email'] = $data['personal_email'] ? trim($data['personal_email']) : '';
             $data['celular'] = $data['celular'] ? trim($data['celular']) : '';
             $data['whatsapp'] = $data['whatsapp'] ? trim($data['whatsapp']) : '';
             $data['linkedin'] = $data['linkedin'] ? trim($data['linkedin']) : '';
+            $data['scholarship'] = $data['scholarship'] ? trim($data['scholarship']) : '';
             $data['phone_extension'] = $data['phone_extension'] ? trim($data['phone_extension']) : '';
             $data['personal_email'] = $data['personal_email'] ? trim($data['personal_email']) : '';
             $data['celular'] = $data['celular'] ? trim($data['celular']) : '';
             $data['whatsapp'] = $data['whatsapp'] ? trim($data['whatsapp']) : '';
             $data['linkedin'] = $data['linkedin'] ? trim($data['linkedin']) : '';
+            $data['scholarship'] = $data['scholarship'] ? trim($data['scholarship']) : '';
             $data['link_interactions'] = $this->url()->fromRoute('discovery-contacts/interactions', ['id' => $discoveryContact->uuid]);
         if ($request->isPost()) {
                         O = Sector
                          */
-                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));
+                        $first_name = Functions::sanitizeFilterString($record['A']);
-                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));
+                        $last_name = Functions::sanitizeFilterString($record['B']);
-                        $email_personal = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));
+                        $email_personal = strtolower(Functions::sanitizeFilterString($record['C']));
-                        $email_company = trim(filter_var($record['D'], FILTER_SANITIZE_EMAIL));
+                        $email_company = strtolower(Functions::sanitizeFilterString($record['D']));
-                        $company =  isset($record['E']) ? trim(filter_var($record['E'], FILTER_SANITIZE_STRING)) : '';
+                        $company =  isset($record['E']) ? Functions::sanitizeFilterString($record['E']) : '';
-                        $position = isset($record['F']) ? trim(filter_var($record['F'], FILTER_SANITIZE_STRING)) : '';
+                        $position = isset($record['F']) ? Functions::sanitizeFilterString($record['F']) : '';
-                        $country = isset($record['G']) ? trim(filter_var($record['G'], FILTER_SANITIZE_STRING)) : '';
+                        $country = isset($record['G']) ? Functions::sanitizeFilterString($record['G']) : '';
-                        $state = isset($record['H']) ? trim(filter_var($record['H'], FILTER_SANITIZE_STRING)) : '';
+                        $state = isset($record['H']) ? Functions::sanitizeFilterString($record['H']) : '';
-                        $city = isset($record['I']) ? trim(filter_var($record['I'], FILTER_SANITIZE_STRING)) : '';
+                        $city = isset($record['I']) ? Functions::sanitizeFilterString($record['I']) : '';
-                        $phone = isset($record['J']) ? trim(filter_var($record['J'], FILTER_SANITIZE_STRING)) : '';
+                        $phone = isset($record['J']) ? Functions::sanitizeFilterString(filter_var($record['J'])) : '';
                         $phone = preg_replace('/[^0-9]/', '', $phone);
-                        $extension = isset($record['K']) ? trim(filter_var($record['K'], FILTER_SANITIZE_STRING)) : '';
+                        $extension = isset($record['K']) ? Functions::sanitizeFilterString($record['K']) : '';
                         $extension = preg_replace('/[^0-9]/', '', $extension);
+                        $movil = isset($record['L']) ? Functions::sanitizeFilterString($record['L']) : '';
+                        $movil = preg_replace('/[^0-9]/', '', $movil);
+                        $whatsapp = isset($record['M']) ? Functions::sanitizeFilterString($record['M']) : '';
+                        $whatsapp = preg_replace('/[^0-9]/', '', $whatsapp);
+                        $linkedin = isset($record['N']) ? trim(filter_var($record['N'], FILTER_SANITIZE_URL)) : '';
+                        $sector = isset($record['O']) ? Functions::sanitizeFilterString($record['O']) : '';
+                        $scholarship = isset($record['P']) ? strtolower(Functions::sanitizeFilterString($record['P'])) : '';
                         $movil = isset($record['L']) ? trim(filter_var($record['L'], FILTER_SANITIZE_STRING)) : '';
-                        $movil = preg_replace('/[^0-9]/', '', $movil);
+                        if($scholarship == 'yes' || $scholarship == 'si') {
                             $scholarship = DiscoveryContact::SCHOLARSHIP_YES;
-                        $whatsapp = isset($record['M']) ? trim(filter_var($record['M'], FILTER_SANITIZE_STRING)) : '';
+                        } else {
                                 'extension' => $extension,
                                 'movil' => $movil,
                                 'whatsapp' =>  $whatsapp,
                                 'linkedin' => $linkedin,
                                 'sector' => $sector,
+                                'scholarship' => $scholarship,
                             ]);
+                        }
+                    }
                         'data'   => $messages
                     ]);
+                }
             } else if ($step == 'process') {
-                $key = filter_var($this->params()->fromPost('key'), FILTER_SANITIZE_STRING);
+                $key = Functions::sanitizeFilterString($this->params()->fromPost('key'));
                 if (!$key) {
                     return new JsonModel([
                         'success' => false,
                         'data' => 'ERROR_CACHE_KEY_EMPTY'
                     $extension = $record['extension'];
                     $movil = $record['movil'];
                     $whatsapp =  $record['whatsapp'];
                     $linkedin = $record['linkedin'];
                     $sector = $record['sector'];
+                    $scholarship = $record['scholarship'];
                     $discoveryContact = $discoveryContactMapper->fetchOneByCorporateEmail($email_company);
                         $discoveryContact->phone = empty($phone) ? '' : '+' . $phone;
                         $discoveryContact->phone_extension = $extension;
                         $discoveryContact->celular = empty($movil) ? '' : '+' . $movil;
                         $discoveryContact->whatsapp = empty($whatsapp) ? '' : '+' . $whatsapp;
                         $discoveryContact->linkedin = $linkedin;
+                        $discoveryContact->scholarship = $scholarship;
                                 $discoveryContactLog->details .= 'LABEL_WHATSAPP : ' . $discoveryContact->whatsapp  . PHP_EOL;
+                            }
                             if ($discoveryContact->linkedin) {
                                 $discoveryContactLog->details .= 'LABEL_LINKEDIN : ' . $discoveryContact->linkedin  . PHP_EOL;
+                            }
+                            if ($discoveryContact->scholarship) {
+                                $discoveryContactLog->details .= 'LABEL_SCHOLARSHIP : ' . $discoveryContact->scholarship  . PHP_EOL;
+                            }

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/DiscoveryContactController.php – Rev 16643 → 16766