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];
}
