Proyectos de Subversion LeadersLinked - Backend

use PhpOffice\PhpSpreadsheet\IOFactory;

use LeadersLinked\Form\DiscoveryContact\ContactUploadForm;

use LeadersLinked\Mapper\DiscoveryContactInteractionMapper;

use LeadersLinked\Mapper\DiscoveryContactInteractionTypeMapper;

use LeadersLinked\Model\DiscoveryContactInteraction;

                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING); 

                $formInteraction = new InteractionForm($this->adapter, $currentCompany->id);

                $contactUploadForm = new ContactUploadForm();

                    'form' => $form,

    }

    public function uploadAction()

    {

        $request = $this->getRequest();

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser    = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $request    = $this->getRequest();

        if($request->isPost()) {

            $step = filter_var( $this->params()->fromPost('step'), FILTER_SANITIZE_STRING);

            if($step == 'validation') {

                $form = new  ContactUploadForm();

                $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

                $form->setData($dataPost);

                if($form->isValid()) {

                    $file = $_FILES['file'];

                    $tmp_filename = $file['tmp_name'];

                    $final_filename =  'data/' . $file['name'];

                    if(!move_uploaded_file($tmp_filename, $final_filename)) {

                        return new JsonModel([

                            'success' => false,

                            'data' => 'ERROR_UPLOAD_FILE'

                        ]);

                    }

                    $emails = [];

                    $contacts = [];

                    $spreadsheet = IOFactory::load($final_filename);

                    $records = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

                    foreach($records as $record)

                    {

                        /*

                        A = Nombre	

                        B = Apellido	

                        C = Correo Personal	

                        D = Correo Trabajo	

                        E = Empresa	

                        F = Puesto	

                        G = Pais	

                        H = Estado	

                        I = Ciudad	

                        J = Telefono	

                        K = Extensión	

                        L = Celular	

                        M = Whatsapp	

                        N = Linkedin

                         */

                        $first_name = trim(filter_var($record['A'], FILTER_SANITIZE_STRING));

                        $last_name = trim(filter_var($record['B'], FILTER_SANITIZE_STRING));

                        $email_personal = trim(filter_var($record['C'], FILTER_SANITIZE_EMAIL));

                        $email_company = trim(filter_var($record['D'], FILTER_SANITIZE_EMAIL));

                        $company =  isset($record['E']) ? trim(filter_var($record['E'], FILTER_SANITIZE_STRING)) : '';

                        $position = isset($record['F']) ? trim(filter_var($record['F'], FILTER_SANITIZE_STRING)) : '';

                        $country = isset($record['G']) ? trim(filter_var($record['G'], FILTER_SANITIZE_STRING)) : '';

                        $state = isset($record['H']) ? trim(filter_var($record['H'], FILTER_SANITIZE_STRING)) : '';

                        $city = isset($record['I']) ? trim(filter_var($record['I'], FILTER_SANITIZE_STRING)) : '';

                        $phone = isset($record['J']) ? trim(filter_var($record['J'], FILTER_SANITIZE_STRING)) : '';

                        $phone = preg_replace( '/[^0-9]/', '', $phone);

                        $extension = isset($record['K']) ? trim(filter_var($record['K'], FILTER_SANITIZE_STRING)) : '';

                        $extension = preg_replace( '/[^0-9]/', '', $extension);

                        $movil = isset($record['L']) ? trim(filter_var($record['L'], FILTER_SANITIZE_STRING)) : '';

                        $movil = preg_replace( '/[^0-9]/', '', $movil);

                        $whatsapp = isset($record['M']) ? trim(filter_var($record['M'], FILTER_SANITIZE_STRING)) : '';

                        $whatsapp = preg_replace( '/[^0-9]/', '', $whatsapp);

                        $linkedin = isset($record['N']) ? trim(filter_var($record['N'], FILTER_SANITIZE_URL)) : '';

                        //||  empty($password)

                        if(empty($first_name) || empty($last_name) || !filter_var($email_company, FILTER_VALIDATE_EMAIL) ) {

                            continue;

                        }

                        if(!in_array($email_company, $emails)) {

                            array_push($emails, $email_company);

                            array_push($contacts, [

                                'first_name' =>   $first_name, 

                                'last_name' => $last_name,

                                'email_personal' => $email_personal,

                                'email_company' => $email_company,

                                'company' => $company , 

                                'position' => $position,

                                'country' => $country,

                                'state' => $state,

                                'city' => $city,

                                'phone' => $phone,

                                'extension' => $extension,

                                'movil' => $movil,

                                'whatsapp' =>  $whatsapp,

                                'linkedin' => $linkedin,

                            ]);

                        }

                    }

                    $key = md5($currentUser->id . '-discovery-contacts-' . uniqid() );

                    $this->cache->setItem($key, serialize($contacts));

                    return new JsonModel([

                        'success' => true,

                        'data' => [

                            'key' => $key,

                            'items' => $contacts,

                        ]

                    ]);

                } else {

                    $messages = [];

                    $form_messages = (array) $form->getMessages();

                    foreach($form_messages  as $fieldname => $field_messages)

                    {

                        $messages[$fieldname] = array_values($field_messages);

                    }

                    return new JsonModel([

                        'success'   => false,

                        'data'   => $messages

                    ]);

                }

            } else if($step == 'process') {

                $key = filter_var( $this->params()->fromPost('key'), FILTER_SANITIZE_STRING);

                if(!$key) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_CACHE_KEY_EMPTY'

                    ]);

                }

                $value = $this->cache->getItem($key);

                if(!$value) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_CACHE_NOT_FOUND'

                    ]);

                }

                $records = unserialize($value);

                if(!$records) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_CACHE_INVALID'

                    ]);

                }

                $discoveryContactMapper = DiscoveryContactMapper::getInstance($this->adapter) ;          

                $discoveryContactInteractionTypeMapper = DiscoveryContactInteractionTypeMapper::getInstance($this->adapter); 

                $discoveryContactInteractionType = $discoveryContactInteractionTypeMapper->fetchOneFirstActiveByCompanyId($currentCompany->id);

                $discoveryContactInteractionMapper = DiscoveryContactInteractionMapper::getInstance($this->adapter);      

                $new_contacts  = 0;

                $duplicate_contacts = 0;

                $error_contacts = 0;

                foreach($records as $record)

                {

                    $first_name =   $record['first_name'];

                    $last_name = $record['last_name'];

                    $email_personal = $record['email_personal'];

                    $email_company = $record['email_company'];

                    $company = $record['company'];

                    $position = $record['position'];

                    $country = $record['country'];

                    $state = $record['state'];

                    $city = $record['city'];

                    $phone = $record['phone'];

                    $extension = $record['extension'];

                    $movil = $record['movil'];

                    $whatsapp =  $record['whatsapp'];

                    $linkedin = $record['linkedin'];

                    $discoveryContact = $discoveryContactMapper->fetchOneByCorporateEmail($email_company);

                    if($discoveryContact) {

                        $duplicate_contacts++;

                    } else {

                        $discoveryContact = new DiscoveryContact();

                        $discoveryContact->company_id = $currentCompany->id;

                        $discoveryContact->first_name = $first_name;

                        $discoveryContact->last_name = $last_name;

                        $discoveryContact->corporate_email = $email_company;

                        $discoveryContact->personal_email = $email_personal;

                        $discoveryContact->company = $company;

                        $discoveryContact->position = $position;

                        $discoveryContact->country = $country;

                        $discoveryContact->state = $state;

                        $discoveryContact->city = $city;

                        $discoveryContact->phone = empty($phone) ? '' : '+' . $phone;

                        $discoveryContact->phone_extension = $extension;

                        $discoveryContact->celular = empty($movil) ? '' : '+' . $movil;

                        $discoveryContact->whatsapp = empty($whatsapp) ? '' : '+' . $whatsapp;

                        $discoveryContact->linkedin = $linkedin;

                        if($discoveryContactMapper->insert($discoveryContact)) {

                            $new_contacts++; 

                            if($discoveryContactInteractionType) {

                                $discoveryContactInteraction = new DiscoveryContactInteraction();

                                $discoveryContactInteraction->company_id = $currentCompany->id;

                                $discoveryContactInteraction->contact_id = $discoveryContact->id;

                                $discoveryContactInteraction->interaction_type_id = $discoveryContactInteractionType->id;

                                $discoveryContactInteraction->user_id = $currentUser->id;

                                $discoveryContactInteractionMapper->insert($discoveryContactInteraction);

                            }

                        } else {

                            $error_contacts++;

                        }

                    }

                }

                return new JsonModel([

                    'success' => true,

                    'data' => [

                        'new_contacts' => $new_contacts,

                        'error_contacts' => $error_contacts,

                        'duplicate_contacts' => $duplicate_contacts,

                    ]

                ]);

            } else {

                return new JsonModel([

                    'success' => false,

                    'data' => 'ERROR_PARAMETERS_ARE_INVALID'

                ]);

            }

        }

        return new JsonModel([

            'success' => false,

            'data' => 'ERROR_METHOD_NOT_ALLOWED'

        ]);