Beispiel #1
0
 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();
 }
Beispiel #5
0
 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);
 }
Beispiel #6
0
 public function index()
 {
     $data = Post::select('*')->orderBy('created_at', 'DESC')->get();
     return ['success' => true, 'data' => $data];
 }