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); } } }
public function addPost($user_id, $post_content, $location, $url_arr, $album, $cats) { $model = new Posts(); $model->post_content = $post_content; $model->post_comment_count = 0; $model->post_like_count = 0; $model->post_view_count = 0; $model->location = $location; $model->created_at = time(); $model->status = 1; $model->updated_at = time(); $model->user_id = $user_id; $model->album_id = $album; if (!$model->save(FALSE)) { return FALSE; } $this->addNotificationUserWhenAddPost($user_id, $model->post_id); $alb_post = new PostAlbum(); $alb_post->album_id = $model->post_id; $alb_post->album_id = $album; $alb_post->updated_at = time(); $alb_post->created_at = time(); if (!$alb_post->save(FALSE)) { return FALSE; } $cats = json_decode($cats, TRUE); foreach ($cats as $cat) { $cat_model = new CatPost(); $cat_model->cat_id = $cat; $cat_model->post_id = $model->post_id; $cat_model->status = 1; $cat_model->created_at = time(); $cat_model->updated_at = time(); if (!$cat_model->save(FALSE)) { return FALSE; } } if (is_array($url_arr)) { foreach ($url_arr as $url) { $image = new Images(); $image->post_id = $model->post_id; $image->created_at = time(); $image->created_by = $user_id; $image->updated_at = time(); $image->status = 1; // $image->album_id = $album; $image->image_like_count = 0; $image->img_url = $url; if (!$image->save(FALSE)) { return FALSE; } } } else { $image = new Images(); $image->post_id = $model->post_id; $image->created_at = time(); $image->created_by = $user_id; $image->updated_at = time(); $image->status = 1; // $image->album_id = $album; $image->image_like_count = 0; $image->img_url = $url_arr; if (!$image->save(FALSE)) { return FALSE; } } return $model->post_id; }