public function run()
{
AdminNew::create(['name' => 'giới thiệu công ty', 'slug' => 'gioi-thieu-cong-ty', 'type_new_id' => 1]);
AdminNew::create(['name' => 'about-us', 'slug' => 'about-us-company', 'type_new_id' => 1]);
AdminNew::create(['name' => 'Tin tuyển dụng', 'slug' => 'tin-tuyen-dung', 'type_new_id' => 3]);
AdminNew::create(['name' => 'New carrier', 'slug' => 'new-carrier', 'type_new_id' => 3]);
}
public function showChildSlug($slug, $childSlug)
{
$type = TypeNew::findBySlug($slug);
$typeName = $type->name;
$data = AdminNew::findBySlug($childSlug);
$related = AdminNew::where('type_new_id', $data->type_new_id)->whereNotIn('id', [$data->id])->orderBy('id', 'desc')->limit(PAGINATE_RELATED)->get();
return View::make('site.news.showNews')->with(compact('data', 'related', 'typeName', 'slug'));
}
public static function getNameEnglish($modelId)
{
$ob = AdminLanguage::where('model_name', 'AdminNew')->where('model_id', $modelId)->first();
if ($ob) {
return AdminNew::find($ob->relate_id)->name;
}
return null;
}
public static function getLatestNews()
{
if (Cache::has('newsLatest')) {
$news = Cache::get('newsLatest');
} else {
$now = Carbon\Carbon::now();
$news = AdminNew::where('start_date', '<=', $now)->orderBy('start_date', 'desc')->first();
Cache::put('newsLatest', $news, CACHETIME);
}
if ($news) {
return $news;
} else {
return null;
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($slug)
{
$inputNew = AdminNew::findBySlug($slug);
$inputRelated = AdminNew::where('type_new_id', $inputNew->type_new_id)->whereNotIn('id', [$inputNew->id])->where('start_date', '<=', Carbon\Carbon::now())->orderBy('id', 'desc')->limit(PAGINATE_RELATED)->get();
return View::make('site.news.showNews')->with(compact('inputNew', 'inputRelated'));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
if (!Admin::isSeo()) {
$rules = array('name' => 'required');
$input = Input::except('_token');
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
return Redirect::action('NewsController@edit', $id)->withErrors($validator)->withInput(Input::except('name'));
} else {
$inputNews = Input::only('type_new_id', 'name', 'description');
$relateUpdateId = Common::getValueLanguage('AdminNew', $id, 'relate_id');
$inputUpdateRelate['name'] = $input['en_name'];
$inputUpdateRelate['description'] = $input['en_description'];
$inputUpdateRelate['type_new_id'] = Common::getValueLanguage('TypeNew', Input::get('type_new_id'), 'relate_id');
CommonNormal::update($id, $inputNews);
CommonNormal::update($relateUpdateId, $inputUpdateRelate);
$inputLanguage = Input::only('position', 'status');
AdminLanguage::where('model_name', 'AdminNew')->where('model_id', $id)->where('relate_id', $relateUpdateId)->update($inputLanguage);
//update upload image
$imageNews = AdminNew::find($id);
$input['image_url'] = CommonUpload::uploadImage($id, UPLOADIMG, 'image_url', UPLOAD_NEWS, $imageNews->image_url);
CommonNormal::update($id, ['image_url' => $input['image_url']]);
CommonNormal::update($relateUpdateId, ['image_url' => $input['image_url']]);
}
}
return Redirect::action('NewsController@index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$new = AdminNew::where('type_new_id', $id)->first();
if ($new) {
AdminNew::where('type_new_id', $id)->delete();
}
Common::deleteLanguage($id, 'TypeNew');
return Redirect::action('NewsTypeController@index');
}
public static function getNewUrlSiteMap()
{
$now = Carbon\Carbon::now();
$news = AdminNew::where('start_date', '<=', $now)->orderBy('start_date', 'desc')->get();
return $news;
}
public function sendLang()
{
$input = Input::all();
if ($input['lang'] == $input['lang_current']) {
return $input['url'];
} else {
if ($input['lang_current'] == 'vi') {
if ($input['link_url'] == 'gioi-thieu') {
return url('/en/about');
}
if ($input['link_url'] == 'lien-he') {
return url('/en/contact');
}
if (!empty($input['link_url'])) {
$type = TypeNew::findBySlug($input['link_url']);
if (!empty($type)) {
$obj = Common::objectLanguage2('TypeNew', $type->id, LANG_VI);
$slug = $obj->slug;
}
} else {
$slug = '';
}
if (!empty($input['link_url2'])) {
$news = AdminNew::findBySlug($input['link_url2']);
if (!empty($news)) {
$obj = Common::objectLanguage2('AdminNew', $news->id, LANG_VI);
$slugChild = $obj->slug;
}
} else {
$slugChild = '';
}
return url('/en/' . $slug . '/' . $slugChild);
}
if ($input['lang_current'] == 'en') {
if ($input['link_url'] == 'about') {
return url('/vi/gioi-thieu');
}
if ($input['link_url'] == 'contact') {
return url('/vi/lien-he');
}
if (!empty($input['link_url'])) {
$type = TypeNew::findBySlug($input['link_url']);
if (!empty($type)) {
$obj = Common::objectLanguage2('TypeNew', $type->id, LANG_EN);
$slug = $obj->slug;
}
} else {
$slug = '';
}
if (!empty($input['link_url2'])) {
$news = AdminNew::findBySlug($input['link_url2']);
if (!empty($news)) {
$obj = Common::objectLanguage2('AdminNew', $news->id, LANG_EN);
$slugChild = $obj->slug;
}
} else {
$slugChild = '';
}
return url('/vi/' . $slug . '/' . $slugChild);
}
}
}
