Proyectos de Subversion LeadersLinked - Backend

use LeadersLinked\Form\JobDescription\ContentUploadForm;

use PhpOffice\PhpSpreadsheet\IOFactory;

use LeadersLinked\Model\CompetencyType;

use LeadersLinked\Model\Behavior;

use LeadersLinked\Model\Competency;

use LeadersLinked\Model\CompetencyBehavior;

    }

    public function dictionaryAction()

    {

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

        $currentUser = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $request = $this->getRequest();

        if ($request->isGet()) {

            $form = new ContentUploadForm();

            $this->layout()->setTemplate('layout/layout-backend');

            $viewModel = new ViewModel();

            $viewModel->setTemplate('leaders-linked/jobs-description/dictionary.phtml');

            $viewModel->setVariables([

                'form' => $form

            ]);

            return $viewModel;

        } 

        else if ($request->isPost()) {

            $step = Functions::sanitizeFilterString($this->params()->fromPost('step'));

            if($step == 'validation') {

                $form = new  ContentUploadForm();;

                $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'

                        ]);

                    }

                    $behaviors = [];

                    $competency_types = [];

                    $competencies = [];

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

                    //Tipos de competencias

                    $spreadsheet->setActiveSheetIndex(0);

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

                    $i = 0;

                    foreach($records as $record)

                    {

                        if(!$i) {

                            $i++;

                            continue;

                        }

                        //A = Referencia	B = Nombre	C = Descripción

                        $reference = Functions::sanitizeFilterString($record['A']);

                        $name = Functions::sanitizeFilterString($record['B']);

                        $description = Functions::sanitizeFilterString($record['C']);

                        if(empty($reference) || empty($name) || empty($description) ) {

                            continue;

                        }

                        array_push($competency_types, [

                            'name' => $name, 

                            'description' => $description, 

                            'reference' => $reference

                        ]);

                    }

                    //Comportamientos

                    $spreadsheet->setActiveSheetIndex(1);

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

                    $i = 0;

                    foreach($records as $record)

                    {

                        if(!$i) {

                            $i++;

                            continue;

                        }

                        //A = Referencia	B = Descripción

                        $reference = Functions::sanitizeFilterString($record['A']);

                        $description = Functions::sanitizeFilterString($record['B']);

                        if(empty($reference) || empty($description) ) {

                            continue;

                        }

                        array_push($behaviors, [

                            'description' => $description,

                            'reference' => $reference

                        ]);

                    }

                    //Competencias

                    $spreadsheet->setActiveSheetIndex(2);

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

                    $i  = 0;

                    foreach($records as $record)

                    {

                        //A = Referencia	B = Tipo Competencia	C = Nombre	D = Descripción	 E =Comportamientos

                        if(!$i) {

                            $i++;

                            continue;

                        }

                        $reference = Functions::sanitizeFilterString($record['A']);

                        $competency_type = Functions::sanitizeFilterString($record['B']);

                        $name = Functions::sanitizeFilterString($record['C']);

                        $description = Functions::sanitizeFilterString($record['D']);

                        $behaviors_reference = Functions::sanitizeFilterString($record['E']);

                        if(empty($competency_type) || empty($reference) || empty($description) ) {

                            continue;

                        }

                        array_push($competencies, [

                            'reference' => $reference,

                            'competency_type' => $competency_type,

                            'name' =>  $name,

                            'description' => $description,

                            'behaviors' => $behaviors_reference,

                        ]);

                    }

                    $data = [

                        'competency_types' => $competency_types,

                        'competencies' => $competencies,

                        'behaviors' => $behaviors,

                    ];

                    $key = md5($currentUser->id . '-' . microtime(true));

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

                    return new JsonModel([

                        'success' => true,

                        'data' => [

                            'key' => $key,

                            'items' => $data,

                        ]

                    ]);

                    @unlink($final_filename);

                } 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 = Functions::sanitizeFilterString($this->params()->fromPost('key'));

                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'

                    ]);

                }

                $data = unserialize($value);

                if(!$data) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_CACHE_INVALID'

                    ]);

                }

                $records_added = 0;

                $behaviorMapper = BehaviorMapper::getInstance($this->adapter);

                $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);

                $competencyMapper = CompetencyMapper::getInstance($this->adapter);

                $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);

                if(!empty($data['competency_types'])) {

                    foreach($data['competency_types'] as $record)

                    {

                        $competencyType = $competencyTypeMapper->fetchOneDefaultByExternalCode($record['reference']);

                        if(!$competencyType) {

                            $competencyType = new CompetencyType();

                            $competencyType->external_code = $record['reference'];

                            $competencyType->name = $record['name'];

                            $competencyType->description = $record['description'];

                            $competencyType->status = CompetencyType::STATUS_ACTIVE;

                            if($competencyTypeMapper->insert($competencyType)) {

                                $records_added++;

                            } else {

                                continue;

                            }

                        }

                    }

                }

                if(!empty($data['behaviors'])) {

                    foreach($data['behaviors'] as $record)

                    {

                        $behavior = $behaviorMapper->fetchOneDefaultByExternalCode($record['reference']);

                        if(!$behavior) {

                            $behavior = new Behavior();

                            $behavior->external_code = $record['reference'];

                            $behavior->description = $record['description'];

                            $behavior->status = Behavior::STATUS_ACTIVE;

                            if($behaviorMapper->insert($behavior)) {

                                $records_added++;

                            }else {

                                continue;

                            }

                        }

                    }

                }

                if(!empty($data['competencies'])) {

                    foreach($data['competencies'] as $record)

                    {

                        $competency = $competencyMapper->fetchOneDefaultByExternalCode($record['reference']);

                        if(!$competency) {

                            $competencyType = $competencyTypeMapper->fetchOneDefaultByExternalCode($record['competency_type']);

                            if($competencyType) {

                                $competency = new Competency();

                                $competency->competency_type_id = $competencyType->id;

                                $competency->external_code = $record['reference'];

                                $competency->name = $record['name'];

                                $competency->description = $record['description'];

                                $competency->status = Competency::STATUS_ACTIVE;

                                if($competencyMapper->insert($competency)) {

                                    $records_added++;

                                } else {

                                    continue;

                                }

                            }

                            if(!empty($record['behaviors'])) {

                                $behaviors = explode(',', $record['behaviors']);

                                if(!empty($behaviors)) {

                                    foreach($behaviors as $reference_behavior) {

                                        $behavior = $behaviorMapper->fetchOneDefaultByExternalCode($reference_behavior);

                                        if($behavior) {

                                            $competencyBehavior = $competencyBehaviorMapper->fetchOneByBehaviorIdAndCompetencyId($behavior->id, $competency->id);

                                            if(!$competencyBehavior) {

                                                $competencyBehavior = new CompetencyBehavior();

                                                $competencyBehavior->behavior_id = $behavior->id;

                                                $competencyBehavior->competency_id = $competency->id;

                                                if($competencyBehaviorMapper->insert($competencyBehavior)) {

                                                    $records_added++;

                                                }

                                            }

                                        }

                                    }

                                }

                            }

                        }

                    }

                }

                if($records_added) {

                    $message = $records_added == 1 ?  'LABEL_1_RECORD_IMPORTED' : $records_added . ' LABEL_MULTI_RECORDS_IMPORTED';

                } else {

                    $message = 'LABEL_NO_RECORDS_IMPORTED';

                }

                return new JsonModel([

                    'success' => true,

                    'data' => $message

                ]);

            } else {

                $data = [

                    'success' => false,

                    'data' => 'ERROR_STEP_UNKNOW'

                ];

            }

            return new JsonModel($data);

        } 

        else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }