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;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// $this->call(UserTableSeeder::class);
Model::reguard();
User::create(['email' => '*****@*****.**', 'password' => bcrypt('kantavee'), 'name' => '*****@*****.**']);
Contents::create(['title' => 'content migrate', 'description' => 'descript migrate', 'status' => 1, 'body' => '<h2>Hello world!</h2>']);
}
public function update(Request $request)
{
$body = $this->bodyReplace($request->input('body'));
$content = Contents::find($request->input('id'));
if ($content == null) {
return Response::json(array('result' => false, 'message' => 'can not defind this content'));
}
$content->title = $request->input('title');
$content->description = $request->input('description');
$content->body = $body;
$content->thumbnail = $request->input('thumbnail');
$content->start = $request->input('start');
$content->updated_at = Carbon::now('Asia/Bangkok');
$content->end = $request->input('end');
$content->status = $request->input('status');
$result = $content->save();
if ($result) {
return Response::json(array('result' => true, 'message' => 'Update success.', 'obj' => $result));
} else {
return Response::json(array('result' => false, 'message' => 'Update fail.', 'obj' => $result));
}
}
public function getContentByCatID(Request $request, $cat_id)
{
$page_id = $request->get('p');
$catObj = Categories::find($cat_id);
$data['cat_name'] = $catObj->cat_name;
$data['fullContent'] = Contents::getCatgoryFullContentByPageID($cat_id, 1);
return View::make('catview', $data);
}
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;
}
