public function Search($word) { $post_obj = new Post(); $word = urldecode($word); $post = $post_obj->GetListPost($word); return view('mei.search')->with('posts', $post); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Post $postModel, Request $request) { //dd($request->all()); //$request=$request->except('_token'); $postModel->create($request->all()); return redirect()->route('posts'); }
/** * Fetches one post based on column value condition and status * @param string $column * @param $value * @param int $status * @return Post */ public function getOneBy($column, $value, $status = Post::POST_PUBLISHED) { if ($status === null) { $status = Post::POST_PUBLISHED; } return $this->postModel->ofStatus($status)->where($column, $value)->take(1); }
/** * new-Action (Formularauswertung) */ public function postNew() { //$validator = Validator::make(Request::all(), Post::$rules); //if (/*$validator->passes()*/) //{ // validation has passed, save user in DB $post = new Post(); $post->title = " "; $post->content = Request::input('content'); $user = Auth::user(); $post->link = ''; $post->user_id = $user->id; $post->event_id = Request::input('event_id'); $post->save(); $response = new \stdClass(); $response->success = true; $response->total = 1; $response->data = $post; return response()->json($response); //} /*else { // validation has failed, display error messages $response = new \stdClass; $response->success = false; $response->total = 1; return response()->json($response); }*/ }
public function addReview(Request $request, Post $post) { $review = new Review(); $review->post_id = $post->id; $review->body = $request->post_body; $post->reviews()->save($review); return back(); }
/** * 返回所有文章 */ function GetAllPost(Request $request) { DB::connection()->enableQueryLog(); $postSrv = new Post(); $res = $postSrv->GetAllPost($request->all()); $res['success'] = $res['data'] ? true : false; $res['sql'] = DB::getQueryLog(); return json_encode($res, JSON_UNESCAPED_UNICODE); }
public function getNew() { $post = new Post(); $post->user_id = 1; $post->title = md5(time() * rand()); $post->content = md5(time() * rand()); $post->link = ''; $post->save(); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $post = new \App\Models\Post(); $json = json_decode(\Request::input('json')); $receiver = \Request::input('receiver'); $post->text = \Request::input('text'); $post->sender_id = Auth::user()->id; $post->receiver_id = User::where('name', '=', $receiver)->first()->id; $post->save(); return \Redirect::to('/post/'); }
/** * Create a new post with a text message * * @param \App\Models\Provider $provider * @param string $message * @return \App\Models\Post */ public function createMessage($provider, $message) { $post = new Post(); $post->service = $provider->service; $post->message = $message; $post->user_id = $provider->user_id; $post->provider_id = $provider->id; $post->scheduled_at = time(); $post->save(); return $post; }
/** * Seeds the table. * * @return void */ public function run() { $post = new Post(); $post->title = 'JSON API paints my bikeshed!'; $post->body = 'If you\'ve ever argued with your team about the way your JSON responses should be ' . 'formatted, JSON API is your anti-bikeshedding weapon.'; /** @var Site $site */ $site = Site::firstOrFail(); /** @var Author $author */ $author = Author::firstOrFail(); $post->site_id = $site->id; $post->author_id = $author->id; $post->save(); }
public function actionCreate() { $data = $_POST['data']; $time = time(); $data['create_at'] = $time; $data['user_id'] = User::getCurrentId(); $comment = new Comment(); $comment->attributes = $data; $post = new Post(); $post->updateAll(['reply_at' => $time, 'last_reply_id' => $data['user_id']], 'id=:id', [':id' => $data['post_id']]); $comment->save(); $this->redirect(array('/post/view', 'id' => $data['post_id'])); }
/** * Create or update a post. * * @param App\Models\Post $post * @param array $inputs * @param bool $user_id * @return App\Models\Post */ private function savePost($post, $inputs, $user_id = null) { $post->title = $inputs['title']; $post->summary = $inputs['summary']; $post->content = $inputs['content']; $post->slug = $inputs['slug']; $post->active = isset($inputs['active']); if ($user_id) { $post->user_id = $user_id; } $post->save(); return $post; }
public function store(Request $request) { $input = $request->all(); $validator = Validator::make($input, Post::getCreateRules()); if ($validator->passes()) { $post = new Post(); $post->user_id = $request->user_id; $post->text = $request->text; $post->save(); return $this->response->array($post); } else { throw new \Dingo\Api\Exception\StoreResourceFailedException('Could not create new user.', $validator->errors()); } }
/** * @inheritdoc */ public function getRelationships($comment, array $includeRelationships = []) { /** @var Comment $comment */ // that's an example how $includeRelationships could be used for reducing requests to database if (isset($includeRelationships['post']) === true) { // as post will be included as full resource we have to give full resource $post = $comment->post; } else { // as post will be included as just id and type so it's not necessary to load it from database $post = new Post(); $post->setAttribute($post->getKeyName(), $comment->post_id); } return ['post' => [self::DATA => $post]]; }
function love(array $params) { $response = new ResponseEntity(); DB::transaction(function () use(&$response, $params) { if ($params['postId']) { $ep = Post::find($params['postId']); if (!$ep) { $response->setMessages(['Post is not available']); } else { $p = new PostLove(); $p->post_id = $params['postId']; $p->user_id = Auth::user()->id; $ok = $p->save(); if ($ok) { $response->setSuccess(true); } else { $response->setMessages(['Something went wrong!']); } } } else { $response->setMessages(['Post is not available']); } }); return $response; }
/** * @param $id * @param $id_acc * @param $title * @param $post * @param int $category */ public static function edit($id, $id_acc, $title, $post, $category = 2) { $cleanPost = \Post::sensor($post, false); $sql = sprintf("UPDATE `iniforum`.`posts`\n SET `post` = :post, `title` = :title, `id_category` = :category, `modified_at`=now()\n WHERE `posts`.`id` = :id AND `posts`.`id_account` = :id_acc"); $bindArray = [':id' => $id, ':id_acc' => $id_acc, ':title' => $title, ':post' => $cleanPost, ':category' => $category]; self::query($sql, $bindArray); }
/** * Store a newly created post in storage. * * @param CreatepostRequest $request * * @return Response */ public function store(CreatePostRequest $request) { $input = Request::all(); if (!empty($input['imagen'])) { $this->carpeta = 'posts/' . $input['id_usuario'] . '/'; if (!File::exists($this->carpeta)) { //Crear carpeta de archivos adjuntos File::makeDirectory($this->carpeta); } $filename = 'posts/' . $input['id_usuario'] . '/' . $input['titulo'] . date("GisdY") . '.jpg'; $input['imagen'] = $filename; Image::make(Input::file('imagen'))->resize(480, 360)->save($filename); } if (!empty($input['archivo'])) { $this->carpeta = 'posts/' . $input['id_usuario'] . '/'; if (!File::exists($this->carpeta)) { //Crear carpeta de archivos adjuntos File::makeDirectory($this->carpeta); } $destinationPath = 'posts/' . $input['id_usuario'] . '/'; // upload path $nombre = Input::file('archivo')->getClientOriginalName(); // getting image extension Input::file('archivo')->move($destinationPath, $nombre); $input['archivo'] = $destinationPath . $nombre; } $post = Post::create($input); return redirect('home'); }
/** * TODO: In future models will have more relations which might not delete automatically. It should be tested properly * TODO: Files should be deleted too * Deletes all boards, threads and posts with 'is_deleted = 1', handles relation between them. * @return array with deleted rows */ public static function clean() { $itemsToDelete = ['boardsIds' => [], 'threadsIds' => [], 'postsIds' => [], 'postDataIds' => [], 'postMessageIds' => []]; Post::getDeletedRows($itemsToDelete); Thread::getDeletedRows($itemsToDelete); Board::getDeletedRows($itemsToDelete); self::getPostDataIds($itemsToDelete); self::getPostMessageIds($itemsToDelete); /** * Deletes post_message's related to threads and posts */ $deleted['post_messages'] = PostMessage::deleteAll(['in', 'id', array_unique($itemsToDelete['postMessageIds'])]); /** * Deletes threads and posts because of FK */ $deleted['threads'] = Thread::deleteAll(['in', 'id', array_unique($itemsToDelete['threadsIds'])]); /** * Deleted posts and threads related to post_data */ $deleted['post_data'] = PostData::deleteAll(['in', 'id', array_unique($itemsToDelete['postDataIds'])]); /** * Deleted boards */ $deleted['boards'] = Board::deleteAll(['in', 'id', array_unique($itemsToDelete['boardsIds'])]); $deleted['posts'] = $deleted['post_data'] - $deleted['threads']; $deleted['total'] = $deleted['boards'] + $deleted['threads'] + $deleted['posts'] + $deleted['post_data'] + $deleted['post_messages']; return $deleted; }
public function run() { DB::table('Posts')->delete(); Post::create(['title' => 'First Post', 'author' => 'Евгений', 'excerpt' => 'First Post body', 'text' => 'Content First Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); Post::create(['title' => 'Second Post', 'author' => 'Евгений', 'excerpt' => 'Second Post body', 'text' => 'Content Second Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); Post::create(['title' => 'Third Post', 'author' => 'Евгений', 'excerpt' => 'Third Post body', 'text' => 'Content Third Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); }
public static function __init(array $options = array()) { parent::__init($options); $self = static::_instance(); $self->_finders['count'] = function ($self, $params, $chain) use(&$query, &$classes) { $db = Connections::get($self::meta('connection')); $records = $db->read('SELECT count(*) as count FROM posts', array('return' => 'array')); return $records[0]['count']; }; Post::applyFilter('save', function ($self, $params, $chain) { $post = $params['record']; if (!$post->id) { $post->created = date('Y-m-d H:i:s'); } else { $post->modified = date('Y-m-d H:i:s'); } $params['record'] = $post; return $chain->next($self, $params, $chain); }); Validator::add('isUniqueTitle', function ($value, $format, $options) { $conditions = array('title' => $value); // If editing the post, skip the current psot if (isset($options['values']['id'])) { $conditions[] = 'id != ' . $options['values']['id']; } // Lookup for posts with same title return !Post::find('first', array('conditions' => $conditions)); }); }
/** * @param ATOM|RSS2 $feed * @return ATOM|RSS2 */ protected function generateFeed($feed) { /* @var Post[] $posts */ $site_name = ArrayHelper::getValue(Yii::$app->params, 'site_name', Yii::$app->name); $posts = Post::find()->where(['status' => Post::STATUS_PUBLISHED])->orderBy(['post_time' => SORT_DESC, 'update_time' => SORT_DESC])->limit(20)->all(); $feed->setTitle($site_name); $feed->setLink(Url::home(true)); $feed->setSelfLink(Url::to(['feed/rss'], true)); $feed->setAtomLink(Url::to(['feed/atom'], true)); $feed->setDescription(ArrayHelper::getValue(Yii::$app->params, 'seo_description', '最新更新的文章')); if ($posts) { $feed->setDate($posts[0]->update_time); } else { $feed->setDate(time()); } foreach ($posts as $post) { $entry = $feed->createNewItem(); $entry->setTitle($post->title); $entry->setLink($post->getUrl(true)); $entry->setDate(intval($post->post_time)); $entry->setDescription($post->excerpt); $entry->setAuthor($post->author_name ? $post->author_name : $post->author->nickname); $entry->setId($post->alias); if ($feed instanceof ATOM) { $entry->setContent($post->content); } $feed->addItem($entry); } return $feed; }
public function run() { DB::table('Posts')->delete(); Post::create(['name' => 'First Name', 'email' => '*****@*****.**', 'city' => 1, 'content' => 'First Feedbuck 24', 'slag' => 'first-feed', 'published' => true, 'created_at' => time(), 'mood' => '1']); Post::create(['name' => 'Second Name', 'email' => '*****@*****.**', 'city' => 2, 'content' => 'Second Feedbuck 24', 'slag' => 'second-feed', 'published' => true, 'created_at' => time(), 'mood' => '2']); Post::create(['name' => 'Third Name', 'email' => '*****@*****.**', 'city' => 3, 'content' => 'Third Feedbuck 24sdsds', 'slag' => 'third-feed', 'published' => true, 'created_at' => time(), 'mood' => '1']); }
public function run() { DB::table('Posts')->delete(); Post::create(['title' => 'First Post', 'slug' => 'first-post', 'excerpt' => 'First Post body', 'content' => 'Content First Post body', 'published' => true, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); Post::create(['title' => 'Second Post', 'slug' => 'second-post', 'excerpt' => 'Second Post body', 'content' => 'Content Second Post body', 'published' => false, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); Post::create(['title' => 'Third Post', 'slug' => 'third-post', 'excerpt' => 'Third Post body', 'content' => 'Content Third Post body', 'published' => false, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]); }
public function actionNew() { $postModel = new Post(); $category = new Category(); $categoryList = ArrayHelper::map($category->find()->asArray()->all(), 'id', 'title'); $postList = $postModel->find()->asArray()->all(); $message = ''; if ($postModel->load(Yii::$app->request->post()) && $postModel->save()) { $selectedCategories = Category::find()->where(['id' => $postModel->categoryIds])->all(); foreach ($selectedCategories as $category) { $postModel->link('categories', $category); } $message = 'Category added success'; } return $this->render('new', ['model' => $postModel, 'message' => $message, 'categoryList' => $categoryList, 'postList' => $postList]); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id = null) { //$posts = Post::all(); $posts = Post::latest('id')->paginate(2); //$posts = DB::table('posts')->paginate(2); return view('post.list', array('posts' => $posts)); }
public function actionIndex() { $query = Post::find(); $pagination = new Pagination(['defaultPageSize' => 6, 'totalCount' => $query->count()]); $posts = $query->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('index', ['posts' => $posts, 'pagination' => $pagination]); }
public function update($id, UpdatePostRequest $request) { $post = Post::find($id); $post->post = $request->get('post'); $post->save(); return redirect()->route('posts.show', $post->id)->with('successes', ['Post updated successfully']); }
public function postsAndGrants() { $id = $this->request->query['id']; // First find all posts for group $posts = Post::find('all', array('conditions' => array('groupId' => new \MongoId($id)), 'limit' => 10))->to('array'); $ids = array(); $total = 0; foreach ($posts as &$p) { $total += $p['y2011']; /* $post = $p['post']; $ids[] = $post; */ } /* $grants = Grant::find('all', array( 'conditions' => array( 'post' => array( '$in' => $ids ) ), 'limit' => 100 ))->to('array'); */ return compact('total', 'posts'); }
public function upload() { $uploader_id = Auth::user()->active_contact->id; if (Input::file('file')->isValid()) { if (Input::get('target') == "posts") { if (Input::get('target_action') == "create") { $target = Post::where('author_id', $uploader_id)->where("status_id", "=", POST_DRAFT_STATUS_ID)->where("ticket_id", Input::get('target_id'))->first(); } elseif (Input::get('target_action') == "edit") { $target = Post::where("id", Input::get('target_id'))->first(); } } elseif (Input::get('target') == "tickets") { if (Input::get('target_action') == "create") { $target = Ticket::where('status_id', TICKET_DRAFT_STATUS_ID)->where('creator_id', $uploader_id)->first(); } elseif (Input::get('target_action') == "edit") { $target = Ticket::where("id", Input::get('target_id'))->first(); } } $id = $target->id; $request['target_id'] = $id; $request['uploader_id'] = $uploader_id; $request['file'] = Input::file('file'); $request['target'] = Input::get('target'); $request['target_action'] = Input::get('target_action'); $response = $this->repo->upload($request); $response = Response::json($response, 200); return $response; } }
/** * @param $sender * @param $receiver * @param $object */ private static function createNewNotification($sender, $event) { $noti = new Notification(); $noti["sender_id"] = $sender; $noti["is_read"] = 0; $noti["objectType"] = POST; if ($event instanceof FollowEvent) { $noti["type"] = FOLLOW; $noti["receiver_id"] = $event["following_id"]; if ($event["follow_type"] == 2) { $noti["objectType"] = BOARD; } else { $noti["objectType"] = USER; } } else { $post = Post::getPostById($event["post_id"]); $noti["receiver_id"] = $post["user_id"]; if ($event instanceof LikeEvent) { $noti["type"] = LIKE; $noti["objectID"] = $event["post_id"]; } else { if ($event instanceof CommentEvent) { $noti["type"] = COMMENT; $noti["objectID"] = $event["post_id"]; } else { if ($event instanceof PinEvent) { $noti["type"] = PIN; $noti["objectID"] = $event["post_id"]; } } } } return $noti; }