/** * Execute the console command. * * @return mixed */ public function fire() { $topics = Topic::all(); $markdown = new Markdown(); $transfer_count = 0; $convert_count = 0; foreach ($topics as $topic) { if (empty($topic->body_original)) { // store the original data $topic->body_original = $topic->body; // convert to markdown $topic->body = $markdown->convertMarkdownToHtml($topic->body); $topic->save(); $transfer_count++; } else { // convert to markdown $topic->body = $markdown->convertMarkdownToHtml($topic->body_original); $topic->save(); $convert_count++; } } $this->info("Transfer old data count: " . $transfer_count); $this->info("Convert original to body count: " . $convert_count); $this->info("It's Done, have a good day."); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // get all the nerds $topics = Topic::all(); // load the view and pass the nerds return View::make('topics.index')->with('topics', $topics); }
/** * Список тем */ public function forum($id) { if (!($forum = Forum::find_by_id($id))) { App::abort('default', 'Данного раздела не существует!'); } $total = Topic::count(['conditions' => ['forum_id = ?', $id]]); $page = App::paginate(Setting::get('topics_per_page'), $total); $topics = Topic::all(['conditions' => ['forum_id = ?', $id], 'offset' => $page['offset'], 'limit' => $page['limit'], 'order' => 'updated_at desc', 'include' => ['forum', 'post_count', 'post_last' => ['user']]]); /* $topics = Topic::all([ 'select' => 't.*, p.user_id post_user, p.created_at post_created', 'from' => 'topics as t', 'conditions' => ['t.forum_id = ?', $id], 'joins' => ['LEFT JOIN ( SELECT topic_id, MAX(created_at) AS max FROM posts GROUP BY topic_id ) AS latest ON t.id = latest.topic_id LEFT JOIN posts p ON p.created_at = latest.max AND p.topic_id = latest.topic_id'], 'offset' => $page['offset'], 'limit' => $page['limit'], 'order' => 't.updated_at desc', 'include' => [ 'forum', 'post_count', ],*/ $crumbs = ['/forum' => 'Форум', $forum->title]; if ($forum->parent_id) { $crumbs = ['/forum' => 'Форум', '/forum/' . $forum->parent_id => $forum->parent()->title, $forum->title]; } App::view('forums.forum', compact('forum', 'topics', 'page', 'crumbs')); }
public function forumget($page) { if (Topic::all()->count() > ($page - 1) * 20) { $topics = Topic::take(20)->skip(($page - 1) * 20)->orderBy("sn", "desc")->get(); for ($i = 0; $i < count($topics); $i++) { $writer = Student::find($topics[$i]->stu_id); $export[] = array("id" => urlencode($topics[$i]->id), "title" => urlencode(str_replace("\\'", "'", addslashes($topics[$i]->title))), "writer" => urlencode(str_replace("\\'", "'", addslashes($writer->nick))), "body" => urlencode(str_replace("\\'", "'", base64_encode($topics[$i]->body))), "file" => urlencode(str_replace("\\'", "'", addslashes($topics[$i]->file))), "date" => $topics[$i]->day, "view" => $topics[$i]->view); } } else { $export[] = array("id" => " ", "title" => " ", "writer" => " ", "body" => " ", "file" => " ", "date" => " ", "view" => " "); } return urldecode(json_encode($export)); }
/** * Execute the console command. * * @return mixed */ public function fire() { $topics = Topic::all(); $transfer_count = 0; foreach ($topics as $topic) { if (empty($topic->excerpt)) { $topic->excerpt = Topic::makeExcerpt($topic->body); $topic->save(); $transfer_count++; } } $this->info("Transfer old data count: " . $transfer_count); $this->info("It's Done, have a good day."); }
public function extractData() { $gifts = Gift::all(); //礼品 $topics = Topic::all(); // 话题 $gift_posters = GiftPoster::all(); //礼品海报 $gift_photo_intros = GiftPhotoIntro::all(); //图文介绍 // fwrite(fopen(app_path().'\storage\mysq.txt', 'w'), 'man'); file_put_contents(app_path() . '/storage/gifts.txt', json_encode($gifts)); file_put_contents(app_path() . '/storage/topics.txt', json_encode($topics)); file_put_contents(app_path() . '/storage/gift_posters.txt', json_encode($gift_posters)); file_put_contents(app_path() . '/storage/gift_photo_intros.txt', json_encode($gift_photo_intros)); return 0; }
public function show($tid = 'all') { if ($tid == 'all') { if (Input::has('answers')) { $topics = Topic::with('answers')->get()->toArray(); } else { $topics = Topic::all(); } return Response::make(['success' => true, 'data' => $topics]); } else { try { $topic = Topic::findOrFail($tid); $topic->answers = $topic->answers->toArray(); return Response::make(['success' => true, 'data' => $topic]); } catch (Exception $e) { return Response::make(['error' => true, 'message' => 'Sorry but that topic cannot be found!', 'data' => null], 404); } } }
public function Welcome() { $lastHolText = Setting::where('item', '=', 'lastHolText')->first()->value; $lastHolDate = Setting::where('item', '=', 'lastHolDate')->first()->value; $export[] = array("id" => " ", "title" => $lastHolText, "day" => $lastHolDate, "writer" => " ", "body" => " ", "file" => " ", "image" => " ", "link" => " ", "view" => " "); if (Newsstu::all()->count() > 0) { $newsstu = Newsstu::take(2)->orderBy("id", "desc")->get(); for ($i = 0; $i < count($newsstu); $i++) { $export[] = array("id" => " ", "title" => urlencode(trim($newsstu[$i]->web_main_top_title)), "day" => urlencode(trim($newsstu[$i]->web_main_top_day)), "writer" => urlencode(trim($newsstu[$i]->web_main_where)), "body" => urlencode(base64_encode($newsstu[$i]->web_main_data)), "file" => urlencode(trim($newsstu[$i]->web_main_link)), "image" => urlencode(trim($newsstu[$i]->web_main_file)), "link" => urlencode(trim($newsstu[$i]->web_main_outside_link)), "view" => " "); } } if (Topic::all()->count() > 0) { $topics = Topic::take(2)->orderBy("sn", "desc")->get(); for ($i = 0; $i < count($topics); $i++) { $writer = Student::find($topics[$i]->stu_id); $export[] = array("id" => urlencode($topics[$i]->id), "title" => urlencode(addslashes($topics[$i]->title)), "day" => " ", "writer" => urlencode(addslashes($writer->nick)), "body" => urlencode(base64_encode($topics[$i]->body)), "file" => urlencode(addslashes($topics[$i]->file)), "image" => " ", "link" => " ", "view" => urlencode($topics[$i]->view)); } } return urldecode(json_encode($export)); }
public static function count() { return Topic::all()->count(); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $topics = Topic::all(); $categories = Category::all(); return View::make('forum')->with(array('topics' => $topics, 'categories' => $categories)); }
<?php /* |-------------------------------------------------------------------------- | Application Routes |-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the Closure to execute when that URI is requested. | */ Route::get('/', function () { return View::make('index')->with("topics", Topic::all()); }); Route::get('topics/{id}', function ($id) { $oTopic = Topic::find($id); return View::make('topic')->with('topic', $oTopic); }); Route::get('posts/{id}', function ($id) { $oPost = Post::find($id); return View::make('post')->with('post', $oPost); }); Route::get('users/new', function () { return View::make('newUserForm'); }); Route::get('users/{id}/edit', function ($id) { $oUser = User::find($id); return View::make('editUserForm')->with('user', $oUser); }); Route::put('users/{id}', function ($id) {
public function home() { $scriptures = Scripture::all(); $topics = Topic::all(); require_once 'views/scripture/home.php'; }