@@ -4,7 +4,6 @@ |
||
| 4 | 4 | use MysqlUuid\Formats\Binary; |
| 5 | 5 | use MysqlUuid\Uuid; |
| 6 | 6 | use Core\Entity\ArticleType; |
| 7 | -use MysqlUuid\Formats\PlainString; |
|
| 8 | 7 | |
| 9 | 8 | class ArticleDiscussions extends AbstractMigration |
| 10 | 9 | { |
@@ -10,11 +10,11 @@ discard block |
||
| 10 | 10 | { |
| 11 | 11 | public function up() |
| 12 | 12 | { |
| 13 | - $this->table('article_discussions', ['id' => false]) |
|
| 14 | - ->addColumn('article_uuid', 'binary', ['limit' => 16]) |
|
| 13 | + $this->table('article_discussions', [ 'id' => false ]) |
|
| 14 | + ->addColumn('article_uuid', 'binary', [ 'limit' => 16 ]) |
|
| 15 | 15 | ->addColumn('title', 'text') |
| 16 | 16 | ->addColumn('body', 'text') |
| 17 | - ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION']) |
|
| 17 | + ->addForeignKey('article_uuid', 'articles', 'article_uuid', [ 'delete' => 'NO_ACTION', 'update' => 'NO_ACTION' ]) |
|
| 18 | 18 | ->create(); |
| 19 | 19 | |
| 20 | 20 | // $this->insertDummyData(); |
@@ -27,15 +27,15 @@ discard block |
||
| 27 | 27 | |
| 28 | 28 | private function insertDummyData() |
| 29 | 29 | { |
| 30 | - $ids = []; |
|
| 30 | + $ids = [ ]; |
|
| 31 | 31 | $rows = $this->fetchAll('select admin_user_uuid from admin_users;'); |
| 32 | - foreach($rows as $r){ |
|
| 33 | - $ids[] = $r['admin_user_uuid']; |
|
| 32 | + foreach ($rows as $r) { |
|
| 33 | + $ids[ ] = $r[ 'admin_user_uuid' ]; |
|
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | $faker = Faker\Factory::create(); |
| 37 | 37 | $count = rand(250, 300); |
| 38 | - for($i = 0; $i < $count; $i++){ |
|
| 38 | + for ($i = 0; $i < $count; $i++) { |
|
| 39 | 39 | $id = $faker->uuid; |
| 40 | 40 | $mysqluuid = (new Uuid($id))->toFormat(new Binary()); |
| 41 | 41 | $title = $faker->sentence(5, 15); |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | 'article_id' => $id, |
| 46 | 46 | 'slug' => strtolower(trim(preg_replace('~[^\pL\d]+~u', '-', $title), '-')), |
| 47 | 47 | 'status' => 1, |
| 48 | - 'admin_user_uuid' => $ids[array_rand($ids)], |
|
| 48 | + 'admin_user_uuid' => $ids[ array_rand($ids) ], |
|
| 49 | 49 | 'type' => ArticleType::DISCUSSION |
| 50 | 50 | ]; |
| 51 | 51 | |
@@ -31,6 +31,9 @@ discard block |
||
| 31 | 31 | $this->adapter = $adapter; |
| 32 | 32 | } |
| 33 | 33 | |
| 34 | + /** |
|
| 35 | + * @param string $id |
|
| 36 | + */ |
|
| 34 | 37 | public function get($id) |
| 35 | 38 | { |
| 36 | 39 | return $this->select(['admin_user_id' => $id])->current(); |
@@ -40,7 +43,7 @@ discard block |
||
| 40 | 43 | * Get admin user by email. |
| 41 | 44 | * |
| 42 | 45 | * @param string $email email |
| 43 | - * @return array|\ArrayObject|null |
|
| 46 | + * @return string |
|
| 44 | 47 | */ |
| 45 | 48 | public function getByEmail(string $email) |
| 46 | 49 | { |
@@ -50,7 +53,6 @@ discard block |
||
| 50 | 53 | /** |
| 51 | 54 | * Updates login data. |
| 52 | 55 | * |
| 53 | - * @param string $uuid admin user id |
|
| 54 | 56 | * @return int number of affected rows |
| 55 | 57 | */ |
| 56 | 58 | public function updateLogin(string $userId): int |
@@ -58,6 +60,11 @@ discard block |
||
| 58 | 60 | return $this->update(['last_login' => date('Y-m-d H:i:s')], ['admin_user_id' => $userId]); |
| 59 | 61 | } |
| 60 | 62 | |
| 63 | + /** |
|
| 64 | + * @param string $userId |
|
| 65 | + * |
|
| 66 | + * @return \Zend\Db\Sql\Select |
|
| 67 | + */ |
|
| 61 | 68 | public function getPaginationSelect($userId) |
| 62 | 69 | { |
| 63 | 70 | $select = $this->getSql()->select()->order(['created_at' => 'desc']); |
@@ -67,6 +74,9 @@ discard block |
||
| 67 | 74 | return $select; |
| 68 | 75 | } |
| 69 | 76 | |
| 77 | + /** |
|
| 78 | + * @param integer $limit |
|
| 79 | + */ |
|
| 70 | 80 | public function getRandom($limit) |
| 71 | 81 | { |
| 72 | 82 | $select = $this->getSql()->select() |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | |
| 33 | 33 | public function get($id) |
| 34 | 34 | { |
| 35 | - return $this->select(['admin_user_id' => $id])->current(); |
|
| 35 | + return $this->select([ 'admin_user_id' => $id ])->current(); |
|
| 36 | 36 | } |
| 37 | 37 | |
| 38 | 38 | /** |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | */ |
| 44 | 44 | public function getByEmail(string $email) |
| 45 | 45 | { |
| 46 | - return $this->select(['email' => $email])->current(); |
|
| 46 | + return $this->select([ 'email' => $email ])->current(); |
|
| 47 | 47 | } |
| 48 | 48 | |
| 49 | 49 | /** |
@@ -54,12 +54,12 @@ discard block |
||
| 54 | 54 | */ |
| 55 | 55 | public function updateLogin(string $userId): int |
| 56 | 56 | { |
| 57 | - return $this->update(['last_login' => date('Y-m-d H:i:s')], ['admin_user_id' => $userId]); |
|
| 57 | + return $this->update([ 'last_login' => date('Y-m-d H:i:s') ], [ 'admin_user_id' => $userId ]); |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | public function getPaginationSelect($userId) |
| 61 | 61 | { |
| 62 | - $select = $this->getSql()->select()->order(['created_at' => 'desc']); |
|
| 62 | + $select = $this->getSql()->select()->order([ 'created_at' => 'desc' ]); |
|
| 63 | 63 | |
| 64 | 64 | $select->where->notEqualTo('admin_user_id', $userId); |
| 65 | 65 | |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | public function getRandom($limit) |
| 70 | 70 | { |
| 71 | 71 | $select = $this->getSql()->select() |
| 72 | - ->where(['status' => 1]) |
|
| 72 | + ->where([ 'status' => 1 ]) |
|
| 73 | 73 | ->order(new Expression('rand()')) |
| 74 | 74 | ->limit($limit); |
| 75 | 75 | |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | |
| 79 | 79 | public function getUuid($adminUserId) |
| 80 | 80 | { |
| 81 | - $user = $this->select(['admin_user_id' => $adminUserId])->current(); |
|
| 81 | + $user = $this->select([ 'admin_user_id' => $adminUserId ])->current(); |
|
| 82 | 82 | |
| 83 | 83 | if (!$user) { |
| 84 | 84 | throw new \Exception('Admin user does not exist!', 400); |
@@ -22,6 +22,9 @@ |
||
| 22 | 22 | return $this; |
| 23 | 23 | } |
| 24 | 24 | |
| 25 | + /** |
|
| 26 | + * @return boolean |
|
| 27 | + */ |
|
| 25 | 28 | public function current() |
| 26 | 29 | { |
| 27 | 30 | return $this->session->getStorage()->user; |
@@ -7,7 +7,6 @@ |
||
| 7 | 7 | use Zend\Db\Adapter\AdapterAwareInterface; |
| 8 | 8 | use Zend\Db\TableGateway\AbstractTableGateway; |
| 9 | 9 | use Zend\Db\Sql\Delete; |
| 10 | -use Zend\Db\Sql\Insert; |
|
| 11 | 10 | |
| 12 | 11 | /** |
| 13 | 12 | * Class ArticleMapper. |
@@ -44,9 +44,9 @@ |
||
| 44 | 44 | public function getCategories($articleId) |
| 45 | 45 | { |
| 46 | 46 | $select = $this->getSql()->select() |
| 47 | - ->columns([]) |
|
| 48 | - ->join('category', 'category.category_uuid = articles.category_uuid', ['name', 'slug', 'category_id']) |
|
| 49 | - ->where(['articles.article_id' => $articleId]); |
|
| 47 | + ->columns([ ]) |
|
| 48 | + ->join('category', 'category.category_uuid = articles.category_uuid', [ 'name', 'slug', 'category_id' ]) |
|
| 49 | + ->where([ 'articles.article_id' => $articleId ]); |
|
| 50 | 50 | |
| 51 | 51 | return $this->selectWith($select); |
| 52 | 52 | } |
@@ -12,7 +12,6 @@ |
||
| 12 | 12 | /** |
| 13 | 13 | * Fetches a list of ArticleEntity models. |
| 14 | 14 | * |
| 15 | - * @param array $params |
|
| 16 | 15 | * @return \ArrayObject |
| 17 | 16 | */ |
| 18 | 17 | public function fetchAllArticles($page, $limit); |
@@ -63,6 +63,9 @@ |
||
| 63 | 63 | return $this->getPagination($select, $page, $limit); |
| 64 | 64 | } |
| 65 | 65 | |
| 66 | + /** |
|
| 67 | + * @param integer $limit |
|
| 68 | + */ |
|
| 66 | 69 | public function fetchLatest($limit) |
| 67 | 70 | { |
| 68 | 71 | return $this->articleEventsMapper->getLatest($limit); |
@@ -101,15 +101,15 @@ discard block |
||
| 101 | 101 | |
| 102 | 102 | $article = $articleFilter->getValues(); |
| 103 | 103 | $article += [ |
| 104 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
| 104 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
| 105 | 105 | 'type' => ArticleType::EVENT, |
| 106 | 106 | 'article_id' => $id, |
| 107 | 107 | 'article_uuid' => $uuId |
| 108 | 108 | ]; |
| 109 | - unset($article['admin_user_id']); |
|
| 109 | + unset($article[ 'admin_user_id' ]); |
|
| 110 | 110 | |
| 111 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 112 | - unset($article['category_id']); |
|
| 111 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 112 | + unset($article[ 'category_id' ]); |
|
| 113 | 113 | |
| 114 | 114 | $event = $eventFilter->getValues() + [ |
| 115 | 115 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -131,31 +131,31 @@ discard block |
||
| 131 | 131 | throw new FilterException($articleFilter->getMessages() + $eventFilter->getMessages()); |
| 132 | 132 | } |
| 133 | 133 | |
| 134 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
| 134 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
| 135 | 135 | $event = $eventFilter->getValues() + [ |
| 136 | 136 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
| 137 | 137 | 'main_img' => $this->upload->uploadImage($data, 'main_img') |
| 138 | 138 | ]; |
| 139 | 139 | |
| 140 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
| 141 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 142 | - unset($article['category_id'], $article['admin_user_id']); |
|
| 140 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
| 141 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 142 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
| 143 | 143 | |
| 144 | 144 | // We don't want to force user to re-upload image on edit |
| 145 | - if (!$event['featured_img']) { |
|
| 146 | - unset($event['featured_img']); |
|
| 145 | + if (!$event[ 'featured_img' ]) { |
|
| 146 | + unset($event[ 'featured_img' ]); |
|
| 147 | 147 | } else { |
| 148 | 148 | $this->upload->deleteFile($oldArticle->featured_img); |
| 149 | 149 | } |
| 150 | 150 | |
| 151 | - if (!$event['main_img']) { |
|
| 152 | - unset($event['main_img']); |
|
| 151 | + if (!$event[ 'main_img' ]) { |
|
| 152 | + unset($event[ 'main_img' ]); |
|
| 153 | 153 | } else { |
| 154 | 154 | $this->upload->deleteFile($oldArticle->main_img); |
| 155 | 155 | } |
| 156 | 156 | |
| 157 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
| 158 | - $this->articleEventsMapper->update($event, ['article_uuid' => $article['article_uuid']]); |
|
| 157 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 158 | + $this->articleEventsMapper->update($event, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 159 | 159 | } |
| 160 | 160 | |
| 161 | 161 | public function deleteArticle($id) |
@@ -168,7 +168,7 @@ discard block |
||
| 168 | 168 | |
| 169 | 169 | $this->upload->deleteFile($event->main_img); |
| 170 | 170 | $this->upload->deleteFile($event->featured_img); |
| 171 | - $this->articleEventsMapper->delete(['article_uuid' => $event->article_uuid]); |
|
| 171 | + $this->articleEventsMapper->delete([ 'article_uuid' => $event->article_uuid ]); |
|
| 172 | 172 | $this->delete($event->article_uuid); |
| 173 | 173 | } |
| 174 | 174 | } |
@@ -203,6 +203,9 @@ |
||
| 203 | 203 | return $this->articleMapper->getCategories($articleId); |
| 204 | 204 | } |
| 205 | 205 | |
| 206 | + /** |
|
| 207 | + * @param integer $limit |
|
| 208 | + */ |
|
| 206 | 209 | public function getLatestWeb($limit) |
| 207 | 210 | { |
| 208 | 211 | return $this->articlePostsMapper->getLatest($limit); |
@@ -137,19 +137,19 @@ discard block |
||
| 137 | 137 | |
| 138 | 138 | $article = $articleFilter->getValues(); |
| 139 | 139 | $article += [ |
| 140 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
| 140 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
| 141 | 141 | 'type' => ArticleType::POST, |
| 142 | 142 | 'article_id' => $id, |
| 143 | 143 | 'article_uuid' => $uuId |
| 144 | 144 | ]; |
| 145 | 145 | |
| 146 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 147 | - unset($article['category_id'], $article['admin_user_id']); |
|
| 146 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 147 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
| 148 | 148 | |
| 149 | 149 | $post = $postFilter->getValues() + [ |
| 150 | 150 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
| 151 | 151 | 'main_img' => $this->upload->uploadImage($data, 'main_img'), |
| 152 | - 'article_uuid' => $article['article_uuid'] |
|
| 152 | + 'article_uuid' => $article[ 'article_uuid' ] |
|
| 153 | 153 | ]; |
| 154 | 154 | |
| 155 | 155 | $this->articleMapper->insert($article); |
@@ -166,31 +166,31 @@ discard block |
||
| 166 | 166 | throw new FilterException($articleFilter->getMessages() + $postFilter->getMessages()); |
| 167 | 167 | } |
| 168 | 168 | |
| 169 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
| 169 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
| 170 | 170 | $post = $postFilter->getValues() + [ |
| 171 | 171 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
| 172 | 172 | 'main_img' => $this->upload->uploadImage($data, 'main_img') |
| 173 | 173 | ]; |
| 174 | 174 | |
| 175 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
| 176 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 177 | - unset($article['category_id'], $article['admin_user_id']); |
|
| 175 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
| 176 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 177 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
| 178 | 178 | |
| 179 | 179 | // We don't want to force user to re-upload image on edit |
| 180 | - if (!$post['featured_img']) { |
|
| 181 | - unset($post['featured_img']); |
|
| 180 | + if (!$post[ 'featured_img' ]) { |
|
| 181 | + unset($post[ 'featured_img' ]); |
|
| 182 | 182 | } else { |
| 183 | 183 | $this->upload->deleteFile($oldArticle->featured_img); |
| 184 | 184 | } |
| 185 | 185 | |
| 186 | - if (!$post['main_img']) { |
|
| 187 | - unset($post['main_img']); |
|
| 186 | + if (!$post[ 'main_img' ]) { |
|
| 187 | + unset($post[ 'main_img' ]); |
|
| 188 | 188 | } else { |
| 189 | 189 | $this->upload->deleteFile($oldArticle->main_img); |
| 190 | 190 | } |
| 191 | 191 | |
| 192 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
| 193 | - $this->articlePostsMapper->update($post, ['article_uuid' => $article['article_uuid']]); |
|
| 192 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 193 | + $this->articlePostsMapper->update($post, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 194 | 194 | } |
| 195 | 195 | |
| 196 | 196 | public function deleteArticle($id) |
@@ -203,7 +203,7 @@ discard block |
||
| 203 | 203 | |
| 204 | 204 | $this->upload->deleteFile($post->main_img); |
| 205 | 205 | $this->upload->deleteFile($post->featured_img); |
| 206 | - $this->articlePostsMapper->delete(['article_uuid' => $post->article_uuid]); |
|
| 206 | + $this->articlePostsMapper->delete([ 'article_uuid' => $post->article_uuid ]); |
|
| 207 | 207 | $this->delete($post->article_uuid); |
| 208 | 208 | } |
| 209 | 209 | |
@@ -91,6 +91,9 @@ |
||
| 91 | 91 | return $this->getPagination($select, $page, $limit); |
| 92 | 92 | } |
| 93 | 93 | |
| 94 | + /** |
|
| 95 | + * @param integer $limit |
|
| 96 | + */ |
|
| 94 | 97 | public function fetchLatest($limit) |
| 95 | 98 | { |
| 96 | 99 | return $this->articleVideosMapper->getLatest($limit); |
@@ -127,14 +127,14 @@ discard block |
||
| 127 | 127 | |
| 128 | 128 | $article = $articleFilter->getValues(); |
| 129 | 129 | $article += [ |
| 130 | - 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article['admin_user_id']), |
|
| 130 | + 'admin_user_uuid' => $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]), |
|
| 131 | 131 | 'type' => ArticleType::VIDEO, |
| 132 | 132 | 'article_id' => $id, |
| 133 | 133 | 'article_uuid' => $uuId |
| 134 | 134 | ]; |
| 135 | 135 | |
| 136 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 137 | - unset($article['category_id'], $article['admin_user_id']); |
|
| 136 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 137 | + unset($article[ 'category_id' ], $article[ 'admin_user_id' ]); |
|
| 138 | 138 | |
| 139 | 139 | $videos = $videosFilter->getValues() + [ |
| 140 | 140 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -156,11 +156,11 @@ discard block |
||
| 156 | 156 | throw new FilterException($articleFilter->getMessages() + $videosFilter->getMessages()); |
| 157 | 157 | } |
| 158 | 158 | |
| 159 | - $article = $articleFilter->getValues() + ['article_uuid' => $oldArticle->article_uuid]; |
|
| 160 | - $article['category_uuid'] = $this->categoryMapper->get($article['category_id'])->category_uuid; |
|
| 161 | - $article['admin_user_uuid'] = $this->adminUsersMapper->getUuid($article['admin_user_id']); |
|
| 162 | - unset($article['category_id']); |
|
| 163 | - unset($article['admin_user_id']); |
|
| 159 | + $article = $articleFilter->getValues() + [ 'article_uuid' => $oldArticle->article_uuid ]; |
|
| 160 | + $article[ 'category_uuid' ] = $this->categoryMapper->get($article[ 'category_id' ])->category_uuid; |
|
| 161 | + $article[ 'admin_user_uuid' ] = $this->adminUsersMapper->getUuid($article[ 'admin_user_id' ]); |
|
| 162 | + unset($article[ 'category_id' ]); |
|
| 163 | + unset($article[ 'admin_user_id' ]); |
|
| 164 | 164 | |
| 165 | 165 | $videos = $videosFilter->getValues() + [ |
| 166 | 166 | 'featured_img' => $this->upload->uploadImage($data, 'featured_img'), |
@@ -168,20 +168,20 @@ discard block |
||
| 168 | 168 | ]; |
| 169 | 169 | |
| 170 | 170 | // We don't want to force user to re-upload image on edit |
| 171 | - if (!$videos['featured_img']) { |
|
| 172 | - unset($videos['featured_img']); |
|
| 171 | + if (!$videos[ 'featured_img' ]) { |
|
| 172 | + unset($videos[ 'featured_img' ]); |
|
| 173 | 173 | } else { |
| 174 | 174 | $this->upload->deleteFile($oldArticle->featured_img); |
| 175 | 175 | } |
| 176 | 176 | |
| 177 | - if (!$videos['main_img']) { |
|
| 178 | - unset($videos['main_img']); |
|
| 177 | + if (!$videos[ 'main_img' ]) { |
|
| 178 | + unset($videos[ 'main_img' ]); |
|
| 179 | 179 | } else { |
| 180 | 180 | $this->upload->deleteFile($oldArticle->main_img); |
| 181 | 181 | } |
| 182 | 182 | |
| 183 | - $this->articleMapper->update($article, ['article_uuid' => $article['article_uuid']]); |
|
| 184 | - $this->articleVideosMapper->update($videos, ['article_uuid' => $article['article_uuid']]); |
|
| 183 | + $this->articleMapper->update($article, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 184 | + $this->articleVideosMapper->update($videos, [ 'article_uuid' => $article[ 'article_uuid' ] ]); |
|
| 185 | 185 | } |
| 186 | 186 | |
| 187 | 187 | public function deleteArticle($id) |
@@ -194,7 +194,7 @@ discard block |
||
| 194 | 194 | |
| 195 | 195 | $this->upload->deleteFile($video->main_img); |
| 196 | 196 | $this->upload->deleteFile($video->featured_img); |
| 197 | - $this->articleVideosMapper->delete(['article_uuid' => $video->article_uuid]); |
|
| 197 | + $this->articleVideosMapper->delete([ 'article_uuid' => $video->article_uuid ]); |
|
| 198 | 198 | $this->delete($video->article_uuid); |
| 199 | 199 | } |
| 200 | 200 | } |
@@ -44,6 +44,9 @@ |
||
| 44 | 44 | return $select; |
| 45 | 45 | } |
| 46 | 46 | |
| 47 | + /** |
|
| 48 | + * @param integer $limit |
|
| 49 | + */ |
|
| 47 | 50 | public function getCategoryPostsSelect($categoryId = null, $limit = null) |
| 48 | 51 | { |
| 49 | 52 | $select = $this->getSql()->select() |
@@ -33,12 +33,12 @@ discard block |
||
| 33 | 33 | |
| 34 | 34 | public function get($id) |
| 35 | 35 | { |
| 36 | - return $this->select(['category_id' => $id])->current(); |
|
| 36 | + return $this->select([ 'category_id' => $id ])->current(); |
|
| 37 | 37 | } |
| 38 | 38 | |
| 39 | 39 | public function getPaginationSelect() |
| 40 | 40 | { |
| 41 | - $select = $this->getSql()->select()->order(['name' => 'asc']); |
|
| 41 | + $select = $this->getSql()->select()->order([ 'name' => 'asc' ]); |
|
| 42 | 42 | |
| 43 | 43 | return $select; |
| 44 | 44 | } |
@@ -46,17 +46,17 @@ discard block |
||
| 46 | 46 | public function getCategoryPostsSelect($categoryId = null, $limit = null) |
| 47 | 47 | { |
| 48 | 48 | $select = $this->getSql()->select() |
| 49 | - ->columns(['category_name' => 'name', 'category_slug' => 'slug']) |
|
| 49 | + ->columns([ 'category_name' => 'name', 'category_slug' => 'slug' ]) |
|
| 50 | 50 | ->join('articles', 'articles.category_uuid = category.category_uuid', |
| 51 | - ['article_id', 'slug', 'admin_user_uuid', 'published_at'] |
|
| 52 | - )->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', ['*'], 'right') |
|
| 51 | + [ 'article_id', 'slug', 'admin_user_uuid', 'published_at' ] |
|
| 52 | + )->join('article_posts', 'article_posts.article_uuid = articles.article_uuid', [ '*' ], 'right') |
|
| 53 | 53 | ->join('admin_users', 'admin_users.admin_user_uuid = articles.admin_user_uuid', |
| 54 | - ['admin_user_id', 'first_name', 'last_name', 'face_img'] |
|
| 55 | - )->where(['articles.status' => 1]) |
|
| 56 | - ->order(['published_at' => 'desc']); |
|
| 54 | + [ 'admin_user_id', 'first_name', 'last_name', 'face_img' ] |
|
| 55 | + )->where([ 'articles.status' => 1 ]) |
|
| 56 | + ->order([ 'published_at' => 'desc' ]); |
|
| 57 | 57 | |
| 58 | 58 | if ($categoryId) { |
| 59 | - $select->where(['category_id' => $categoryId]); |
|
| 59 | + $select->where([ 'category_id' => $categoryId ]); |
|
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | if ($limit) { |
@@ -83,14 +83,14 @@ discard block |
||
| 83 | 83 | $inHomepage = null, |
| 84 | 84 | $inCategoryList = null |
| 85 | 85 | ) { |
| 86 | - $select = $this->getSql()->select()->where(['type' => ArticleType::POST]); |
|
| 86 | + $select = $this->getSql()->select()->where([ 'type' => ArticleType::POST ]); |
|
| 87 | 87 | |
| 88 | 88 | if ($inHomepage !== null) { |
| 89 | - $select->where(['is_in_homepage' => $inHomepage]); |
|
| 89 | + $select->where([ 'is_in_homepage' => $inHomepage ]); |
|
| 90 | 90 | } |
| 91 | 91 | |
| 92 | 92 | if ($inCategoryList !== null) { |
| 93 | - $select->where(['is_in_category_list' => $inCategoryList]); |
|
| 93 | + $select->where([ 'is_in_category_list' => $inCategoryList ]); |
|
| 94 | 94 | } |
| 95 | 95 | |
| 96 | 96 | if ($limit) { |