public function index($request) { $this->renderType = 'smarty'; $name = $request->post('name'); $list = Post::findAll(); $list = Post::select()->where()->all(); $row = Post::select()->where(['id' => 1])->one(); return $list; }
/** * دریافت پستها بر اساس مقادیر * * @param int $n * @param $tag * @param $active * @param string $orderby * @param string $direction * @return Illuminate\Support\Collection */ public function lists($n, $tag = NULL, $orderby = 'updated_at', $direction = 'desc', $active = true) { $query = $this->model->select('pst_id', 'tag', 'title', 'read_more', 'content', 'seen', 'active', 'created_at', 'updated_at')->orderBy($orderby, $direction); if ($tag) { $query->where('tag', $tag); } $query->where('active', $active); $Res = $query->paginate($n); $this->AddJalaliDate($Res); return $Res; }
public function find($params) { $post = Post::select("posts.*"); $posts->leftJoin('tickets', 'posts.ticket_id', '=', 'tickets.id'); $post->where("posts.id", $params['id']); if (!Auth::user()->active_contact->isE80()) { $post->where("tickets.company_id", Auth::user()->active_contact->company_id); } $post = count($post->get()) ? $post->get()[0] : []; return $post; }
public function sitemap() { $sitemap = App::make('sitemap'); if (!$sitemap->isCached()) { $posts = Post::select('slug', 'view_count', 'updated_at')->orderBy('created_at', 'desc')->get(); $pages = Page::select('slug', 'updated_at')->get(); foreach ($posts as $post) { $sitemap->add(url('/posts') . '/' . $post->slug, $post->updated_at); } foreach ($pages as $page) { $sitemap->add(url('/') . '/' . $page->slug, $page->updated_at); } } return $sitemap->render(); }
public function nav() { $website_to_project = array(); $websites = Website::get(); if ($websites) { foreach ($websites as $key => $val) { $websites_array[$val['websites_id']] = $val['websites_name']; } } $projects = Project::get(); if ($projects) { foreach ($projects as $key => $val) { $projects_array[$val['projects_id']] = $val['projects_name']; } } $posts = Post::select('website', 'project')->orderby("website", "asc")->orderby("project", "asc")->get(); if ($posts) { foreach ($posts as $key => $val) { $website_to_project[$val['website']]['websites_name'] = $websites_array[$val['website']]; $website_to_project[$val['website']]['projects_name'][$val['project']] = $projects_array[$val['project']]; } } return response()->json($website_to_project); }
public function index() { $data = Post::select('*')->orderBy('created_at', 'DESC')->get(); return ['success' => true, 'data' => $data]; }