Rev 13309 | Autoría | Ultima modificación | Ver Log |
<?phpdeclare(strict_types=1);namespace LeadersLinked\Controller;use Laminas\Db\Adapter\AdapterInterface;use Laminas\Cache\Storage\Adapter\AbstractAdapter;use Laminas\Mvc\Controller\AbstractActionController;use Laminas\Log\LoggerInterface;use Laminas\View\Model\ViewModel;use Laminas\View\Model\JsonModel;use LeadersLinked\Library\Functions;use LeadersLinked\Mapper\FeedMapper;use LeadersLinked\Mapper\TopicMapper;use LeadersLinked\Mapper\QueryMapper;use Laminas\Paginator\Adapter\DbSelect;use Laminas\Paginator\Paginator;use LeadersLinked\Form\CreateFeedForm;use LeadersLinked\Form\TopicForm;use Laminas\Hydrator\ArraySerializableHydrator;use Laminas\Db\ResultSet\HydratingResultSet;use LeadersLinked\Model\Feed;use LeadersLinked\Model\Topic;use LeadersLinked\Mapper\CompanyMapper;use LeadersLinked\Model\Company;use LeadersLinked\Hydrator\ObjectPropertyHydrator;class DevelopmentContentController extends AbstractActionController {/**** @var AdapterInterface*/private $adapter;/**** @var AbstractAdapter*/private $cache;/**** @var LoggerInterface*/private $logger;/**** @var array*/private $config;/**** @param AdapterInterface $adapter* @param AbstractAdapter $cache* @param LoggerInterface $logger* @param array $config*/public function __construct($adapter, $cache, $logger, $config) {$this->adapter = $adapter;$this->cache = $cache;$this->logger = $logger;$this->config = $config;}public function indexAction() {$request = $this->getRequest();$currentUserPlugin = $this->plugin('currentUserPlugin');$currentCompany = $currentUserPlugin->getCompany();$currentUser = $currentUserPlugin->getUser();try{$request = $this->getRequest();if ($request->isGet()) {$headers = $request->getHeaders();$isJson = false;if ($headers->has('Accept')) {$accept = $headers->get('Accept');$prioritized = $accept->getPrioritized();foreach ($prioritized as $key => $value) {$raw = trim($value->getRaw());if (!$isJson) {$isJson = strpos($raw, 'json');}}}if ($isJson) {$search = $this->params()->fromQuery('search', []);$search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);$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));$fields = ['title'];$order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'title';if (!in_array($order_direction, ['ASC', 'DESC'])) {$order_direction = 'ASC';}$acl = $this->getEvent()->getViewModel()->getVariable('acl');$items = [];$feedMapper = FeedMapper::getInstance($this->adapter);$paginator = $feedMapper->fetchAllByDevelop();foreach ($paginator as $record) {$item = ['id' => $record->id,'title' => $record->title,'description' => $record->description,'status' => $record->status,];array_push($items, $item);}return new JsonModel(['success' => true,'data' => ['items' => $items,]]);} else {$form = new CreateFeedForm($this->adapter, $currentCompany->id);$this->layout()->setTemplate('layout/layout-backend');$viewModel = new ViewModel();$viewModel->setTemplate('leaders-linked/development-content/index.phtml');$viewModel->setVariable('form', $form);return $viewModel;}} else {return new JsonModel(['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED']);}} catch (\Throwable $e) {$e->getMessage();return new JsonModel(['success' => false,'data' => $e]);}}public function addAction() {$currentUserPlugin = $this->plugin('currentUserPlugin');$currentCompany = $currentUserPlugin->getCompany();$currentUser = $currentUserPlugin->getUser();$id = $this->params()->fromRoute('id');$uncuratedMapper = FeedMapper::getInstance($this->adapter);$uncurated = $uncuratedMapper->fetchOneByUuid($id);$request = $this->getRequest();try{if($request->isPost()) {$form = new CreateFeedForm($this->adapter);$dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());$categoriesId = $dataPost['category_id'] ?? [];$dataPost['category_id'] = null;$form->setData($dataPost);if($form->isValid()) {$dataPost = (array) $form->getData();$hydrator = new ObjectPropertyHydrator();$feed = new Feed();$hydrator->hydrate($dataPost, $feed);$feed->user_id = $currentUser->id;$feed->company_id = $currentCompany->id;$feed->user_id = $currentUser->id;$feed->status = Feed::STATUS_SAVED;$feed->type = Feed::TYPE_DC;$feed->posted_or_shared = Feed::POSTED;$feed->shared_with = Feed::SHARE_WITH_PUBLIC;$feed->related_feed = $uncurated->id;$feed->total_comments = 0;$feed->total_shared = 0;$files = $this->getRequest()->getFiles()->toArray();$file_type = '';if(isset($files['file']) && empty($files['file']['error'])) {$feed_tmp_filename = $files['file']['tmp_name'];$feed_filename = $this->normalizeString($files['file']['name']);$mime_type = mime_content_type($feed_tmp_filename);if($mime_type == 'image/jpg' || $mime_type == 'image/jpeg' || $mime_type == 'image/png') {$file_type = Feed::FILE_TYPE_IMAGE;} else if($mime_type == 'video/webm' || $mime_type == 'video/mpeg' || $mime_type == 'video/mpg' || $mime_type == 'video/mp4') {$file_type = Feed::FILE_TYPE_VIDEO;} else if($mime_type == 'application/pdf') {$file_type = Feed::FILE_TYPE_DOCUMENT;}}$feedMapper = FeedMapper::getInstance($this->adapter);if($feedMapper->insert($feed)) {$feed = $feedMapper->fetchOne($feed->id);$category = new FeedTopic();$feedMapper->update($feed);$feed = $feedMapper->fetchOne($feed->id);if(!empty($categoriesId)){// print_r($dataPost['job_description_id']);$categoriesMapper = TopicMapper::getInstance($this->adapter);$feedTopicMapper = FeedTopicMapper::getInstance($this->adapter);$ok = true;foreach($categoriesId as $category_id) {// echo '$jobDescriptionUuid = ' . $jobDescriptionUuid ;$category = $categoriesMapper->fetchOneByUuidOrTitle($category_id);if(!$category){$category = new Topic;$category->title = $category_id;$category->type='dc';$categoriesMapper->insert($category);}$record = new FeedTopic();$record->topic_id = $category->id;$record->feed_id = $feed->id;$result = $feedTopicMapper->insert($record);$ok = $ok && $result;}}if( $file_type == Feed::FILE_TYPE_DOCUMENT) {try {$target_path = $this->config['leaderslinked.fullpath.feed'] . $feed->uuid;if(!file_exists($target_path)) {mkdir($target_path, 0755);}$full_filename = $target_path . DIRECTORY_SEPARATOR .$feed_filename;$result = move_uploaded_file($feed_tmp_filename , $full_filename);if($result) {$feed->file_type = $file_type;$feed->file_name = basename($feed_filename);$feedMapper->update($feed);} else {error_log('no se pudo mover o renombrar el documento : ' . $feed_tmp_filename . ' al directorio : ' . $full_filename );}} catch(\Throwable $e) {error_log($e->getTraceAsString());}}if( $file_type == Feed::FILE_TYPE_IMAGE) {try {$target_path = $this->config['leaderslinked.fullpath.feed'] . $feed->uuid;if(!file_exists($target_path)) {mkdir($target_path, 0755);}list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.feed_image_size']);$feed_filename = substr($feed_filename, 0, strrpos($feed_filename, '.')) . '.png';$crop_to_dimensions = false;if(Image::uploadImage($feed_tmp_filename, $target_path, $feed_filename, $target_width, $target_height, $crop_to_dimensions )) {$feed->file_type = $file_type;$feed->file_name = basename($feed_filename);$feedMapper->update($feed);}} catch(\Throwable $e) {error_log($e->getTraceAsString());}}if( $file_type == Feed::FILE_TYPE_VIDEO) {try {$target_path = $this->config['leaderslinked.fullpath.feed'] . $feed->uuid;if(!file_exists($target_path)) {mkdir($target_path, 0755);}$full_filename = $target_path . DIRECTORY_SEPARATOR . $feed_filename;$result = move_uploaded_file($feed_tmp_filename , $full_filename);if($result) {$size = $this->config['leaderslinked.image_sizes.feed_image_size'];$getFromSecound = 2;//extracción del cover$generateFileName = substr($feed_filename, 0, strrpos($feed_filename, '.'));$generateFile = $target_path . DIRECTORY_SEPARATOR . $generateFileName . '.png';$cmd = "/usr/bin/ffmpeg -i $full_filename -an -ss $getFromSecound -s $size $generateFile";exec($cmd);$feed->file_type = $file_type;$feed->file_name = basename($feed_filename);$feed->file_image_preview = basename($generateFile);$feedMapper->update($feed);$videoConvert = new VideoConvert();$videoConvert->filename = $full_filename;$videoConvert->type = VideoConvert::TYPE_FEED;$videoConvertMapper = VideoConvertMapper::getInstance($this->adapter);$videoConvertMapper->insert($videoConvert);} else {error_log('no se pudo mover o renombrar el documento : ' . $feed_tmp_filename . ' al directorio : ' . $full_filename );}} catch(\Throwable $e) {error_log($e->getTraceAsString());}}$response = ['success' => true,'data' => 'success'];} else {$messages = [];$form_messages = (array) $form->getMessages();foreach($form_messages as $fieldname => $field_messages){$messages[$fieldname] = array_values($field_messages);}}} else {$response = ['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED'];}return new JsonModel($response);}} catch (\Throwable $e) {$e->getMessage();return new JsonModel(['success' => false,'data' => $e]);}}public function deleteAction() {$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();$request = $this->getRequest();if($request->isPost()) {$id = $this->params()->fromRoute('id');$feedMapper = FeedMapper::getInstance($this->adapter);$feed = $feedMapper->fetchOneByUuid($id);if(!$feed) {$response = ['success' => false,'data' => 'ERROR_POST_NOT_FOUND'];return new JsonModel($response);}if($feed->company_id != $currentCompany->id) {$response = ['success' => false,'data' => 'ERROR_UNAUTHORIZED'];return new JsonModel($response);}$feedMapper = FeedMapper::getInstance($this->adapter);$feed->status = Feed::STATUS_DELETED;if($feedMapper->update($feed)) {$response = ['success' => true,'data' => 'LABEL_FEED_WAS_DELETED'];} else {$response = ['success' => false,'data' => $feedMapper->getError()];}return new JsonModel($response);} else {$response = ['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED'];}return new JsonModel($response);}}