public function addWishList($post_id, $user_id, $album_id) { // $check = Wishlist::model()->findByAttributes(array('post_id' => $post_id, 'user_id' => $user_id)); // if ($check) { // return FALSE; // } else { $check_album = PostAlbum::model()->findByAttributes(array('post_id' => $post_id, 'album_id' => $album_id)); $check = Wishlist::model()->findByAttributes(array('post_id' => $post_id, 'user_id' => $user_id)); if (!$check_album && !$check) { $alb_post = new PostAlbum(); $alb_post->post_id = $post_id; $alb_post->album_id = $album_id; $alb_post->created_at = time(); $alb_post->updated_at = time(); $model = new Wishlist(); $model->post_id = $post_id; $model->user_id = $user_id; $model->album_id = $album_id; $model->status = 1; $model->created_at = time(); $model->updated_at = time(); if ($model->save(FALSE) && $alb_post->save(FALSE)) { return TRUE; } } return FALSE; }
public function getRandomPostOfAlbum($album_id) { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->order = 'RAND()'; $criteria->condition = "album_id = {$album_id}"; $criteria->limit = 4; $posts = PostAlbum::model()->findAll($criteria); $images = array(); if ($posts) { foreach ($posts as $post) { $images[] = Images::model()->getImagePreviewByPostId($post->post_id); } } $cnt = count($images); if ($cnt < 4) { for ($i = 0; $i < 4 - $cnt; $i++) { $images[] = ''; } } return $images; }
public function actionPostToAlbum() { $posts = Posts::model()->findAll(); foreach ($posts as $item) { $check = PostAlbum::model()->findByAttributes(array('album_id' => $item->album_id, 'post_id' => $item->post_id)); if (!$check) { $model = new PostAlbum(); $model->post_id = $item->post_id; $model->album_id = $item->album_id; $model->created_at = time(); $model->updated_at = time(); $model->save(FALSE); } } $wishilist = Wishlist::model()->findAll(); foreach ($wishilist as $item) { $check = PostAlbum::model()->findByAttributes(array('album_id' => $item->album_id, 'post_id' => $item->post_id)); if (!$check) { $model = new PostAlbum(); $model->post_id = $item->post_id; $model->album_id = $item->album_id; $model->created_at = time(); $model->updated_at = time(); $model->save(FALSE); } } }