public static function getCatgoryFullContentByPageID($cat_id, $page_id)
{
$itemsPerPage = 5;
$contentPerSubject = 3;
$resultArr = [];
$subjectObj = Subjects::where('cat_id', $cat_id)->orderBy('last_reply_time', 'desc')->get();
foreach ($subjectObj as $subject) {
$contentObj = Contents::where('content_id', $subject->subject_id)->first();
$userObj = User::find($subject->po_id);
$cookieObj = ChCookie::where('id', $userObj->cookie_id)->first();
$shortCookie = $cookieObj->short_cookie;
$tmpArr = ['subject_id' => $contentObj->content_id, 'subject_text' => $contentObj->content, 'subject_cookie' => $shortCookie, 'subject_create_time' => $subject->created_at, 'subject_img' => $contentObj->image, 'contents' => []];
$contentObj = Contents::where('subject_id', $subject->subject_id)->where('content_id', '!=', $subject->subject_id)->orderBy('content_id', 'desc')->get();
foreach ($contentObj as $content) {
$userObj = User::find($content->po_id);
$cookieObj = ChCookie::where('id', $userObj->id)->first();
$shortCookie = $cookieObj->short_cookie;
$tmpContent = ['content_id' => $content->content_id, 'content_text' => $content->content, 'content_cookie' => $shortCookie, 'content_create_time' => $content->created_at, 'content_img' => $content->image];
array_push($tmpArr['contents'], $tmpContent);
}
array_push($resultArr, $tmpArr);
}
//var_dump($resultArr);
return $resultArr;
}
public function news($id)
{
if ($id == null) {
return redirect()->intended('/');
}
$news = Contents::where('id', $id)->get()->first();
$view = \View::make('home.news');
$news->body = str_replace(Config::get('image.name'), Config::get('image.host'), $news->body);
$view->with('news', $news);
return $view;
}
