/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Category\ModelName::truncate();
\Model\Category\ModelName::create(['id' => 1, 'title' => 'Саясат жана коом', 'titleRu' => 'Политика и общество', 'order' => 1, 'published' => true]);
\Model\Category\ModelName::create(['id' => 2, 'title' => 'Экономика жана бизнес', 'titleRu' => 'Экономика и бизнес', 'order' => 2, 'published' => true]);
\Model\Category\ModelName::create(['id' => 3, 'title' => 'Музыка жана чыгармачылык', 'titleRu' => 'Музыка и выступления', 'order' => 3, 'published' => true]);
\Model\Category\ModelName::create(['id' => 4, 'title' => 'Илим жана билим', 'titleRu' => 'Наука и образование', 'order' => 4, 'published' => true]);
\Model\Category\ModelName::create(['id' => 5, 'title' => 'Айыл чарба', 'titleRu' => 'Сельское хозяйство', 'order' => 5, 'published' => true]);
\Model\Category\ModelName::create(['id' => 6, 'title' => 'Маданият', 'titleRu' => 'Культура', 'order' => 6, 'published' => true]);
\Model\Category\ModelName::create(['id' => 7, 'title' => 'Спорт', 'titleRu' => 'Спорт', 'order' => 7, 'published' => true]);
\Model\Category\ModelName::create(['id' => 8, 'title' => 'Ден соолук', 'titleRu' => 'Здоровье', 'order' => 8, 'published' => true]);
\Model\Category\ModelName::create(['id' => 9, 'title' => 'Балдар', 'titleRu' => 'Дети', 'order' => 9, 'published' => true]);
\Model\Category\ModelName::create(['id' => 10, 'title' => 'Интернет жана технологиялар', 'titleRu' => 'Интернет и технологии', 'order' => 10, 'published' => true]);
\Model\Category\ModelName::create(['id' => 11, 'title' => 'Коргонуу жана коопсуздук', 'titleRu' => 'Оборона и безопасность', 'order' => 11, 'published' => true]);
\Model\Category\ModelName::create(['id' => 12, 'title' => 'Коррупция', 'titleRu' => 'Коррупция', 'order' => 12, 'published' => true]);
\Model\Category\ModelName::create(['id' => 13, 'title' => 'Кылмыш', 'titleRu' => 'Происшествия', 'order' => 13, 'published' => true]);
\Model\Category\ModelName::create(['id' => 14, 'title' => 'Дин', 'titleRu' => 'Религия', 'order' => 14, 'published' => true]);
\Model\Category\ModelName::create(['id' => 15, 'title' => 'Аналитика', 'titleRu' => 'Аналитика', 'order' => 15, 'published' => true]);
\Model\Category\ModelName::create(['id' => 16, 'title' => 'Аймактык жаңылыктар', 'titleRu' => 'Граница', 'order' => 16, 'published' => true]);
\Model\Category\ModelName::create(['id' => 17, 'title' => 'Чек ара', 'titleRu' => 'Региональные новости', 'order' => 17, 'published' => true]);
\Model\Category\ModelName::create(['id' => 18, 'title' => 'Экология', 'titleRu' => 'Экология', 'order' => 18, 'published' => true]);
\Model\Category\ModelName::create(['id' => 19, 'title' => 'Туризм', 'titleRu' => 'Туризм', 'order' => 19, 'published' => true]);
\Model\Category\ModelName::create(['id' => 20, 'title' => 'Укук коргоо', 'titleRu' => 'Право', 'order' => 20, 'published' => true]);
// factory(\Model\Category\ModelName::class, 10)->create();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Category\ModelName::truncate();
\Model\Category\ModelName::create(['id' => 1, 'name' => 'sayasatjanakoom', 'title' => 'Саясат жана коом', 'order' => 1, 'published' => true]);
\Model\Category\ModelName::create(['id' => 2, 'name' => 'economyandbisnes', 'title' => 'Экономика жана бизнес', 'order' => 2, 'published' => true]);
\Model\Category\ModelName::create(['id' => 3, 'name' => 'musicandproduction', 'title' => 'Музыка жана чыгармачылык', 'order' => 3, 'published' => true]);
\Model\Category\ModelName::create(['id' => 4, 'name' => 'science', 'title' => 'Илим жана билим', 'order' => 4, 'published' => true]);
\Model\Category\ModelName::create(['id' => 5, 'name' => 'village', 'title' => 'Айыл чарба', 'order' => 5, 'published' => true]);
\Model\Category\ModelName::create(['id' => 6, 'name' => 'madaniyat', 'title' => 'Маданият', 'order' => 6, 'published' => true]);
\Model\Category\ModelName::create(['id' => 7, 'name' => 'sport', 'title' => 'Спорт', 'order' => 7, 'published' => true]);
\Model\Category\ModelName::create(['id' => 8, 'name' => 'health', 'title' => 'Ден соолук', 'order' => 8, 'published' => true]);
\Model\Category\ModelName::create(['id' => 9, 'name' => 'baldar', 'title' => 'Балдар', 'order' => 9, 'published' => true]);
\Model\Category\ModelName::create(['id' => 10, 'name' => 'internet', 'title' => 'Интернет жана технологиялар', 'order' => 10, 'published' => true]);
\Model\Category\ModelName::create(['id' => 11, 'name' => 'security', 'title' => 'Коргонуу жана коопсуздук', 'order' => 11, 'published' => true]);
\Model\Category\ModelName::create(['id' => 12, 'name' => 'corruption', 'title' => 'Коррупция', 'order' => 12, 'published' => true]);
\Model\Category\ModelName::create(['id' => 13, 'name' => 'kylmysh', 'title' => 'Кылмыш', 'order' => 13, 'published' => true]);
\Model\Category\ModelName::create(['id' => 14, 'name' => 'din', 'title' => 'Дин', 'order' => 14, 'published' => true]);
\Model\Category\ModelName::create(['id' => 15, 'name' => 'analytics', 'title' => 'Аналитика', 'order' => 15, 'published' => true]);
\Model\Category\ModelName::create(['id' => 16, 'name' => 'aymaktagynews', 'title' => 'Аймактык жаңылыктар', 'order' => 16, 'published' => true]);
\Model\Category\ModelName::create(['id' => 17, 'name' => 'broard', 'title' => 'Чек ара', 'order' => 17, 'published' => true]);
\Model\Category\ModelName::create(['id' => 18, 'name' => 'ecology', 'title' => 'Экология', 'order' => 18, 'published' => true]);
\Model\Category\ModelName::create(['id' => 19, 'name' => 'turizm', 'title' => 'Туризм', 'order' => 19, 'published' => true]);
\Model\Category\ModelName::create(['id' => 20, 'name' => 'ukukkorgoo', 'title' => 'Укук коргоо', 'order' => 20, 'published' => true]);
// factory(\Model\Category\ModelName::class, 10)->create();
}
public function project(\Model\Project\ModelName $project)
{
$projectList = \Model\Project\ModelName::get();
$MediaCategories = \Model\MediaCategory\ModelName::get();
$mediaAll = \Model\Media\ModelName::get();
$mainBanner = \Model\Background\ModelName::where('name', '=', 'main')->first();
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
return view('Front::media.project', ['project' => $project, 'MediaCategories' => $MediaCategories, 'mainBanner' => $mainBanner, 'categories' => $categories, 'projectList' => $projectList, 'backgroundMain' => $backgroundMain]);
}
public function project(\Model\Project\ModelName $project)
{
$projectList = \Model\Project\ModelName::get();
// $MediaCategory = \Model\MediaCategory\ModelName::get();
$mediaAll = \Model\Media\ModelName::get();
$mainBanner = \Model\Background\ModelName::where('name', '=', 'main')->first();
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$relatedNews = \Model\Project\ModelName::where('published', '=', true)->where('dostuk', '=', $project->id)->get();
$dostukProjects = \Model\Project\ModelName::where('published', '=', true)->where('dostuk', '=', 1)->get();
return view('Front::channel.dostuk.project', ['project' => $project, 'mainBanner' => $mainBanner, 'categories' => $categories, 'projectList' => $projectList, 'backgroundMain' => $backgroundMain, 'relatedNews' => $relatedNews, 'dostukProjects' => $dostukProjects]);
}
public function filterResultCategory(Request $request)
{
$category_id = $request->category;
$category = \Model\Category\ModelName::where('id', '=', $category_id)->first();
$lc = app()->getlocale();
$df = $request->dateFrom;
$dt = $request->dateTo;
$dateFrom = date('Y-m-d', strtotime($df));
$dateTo = date('Y-m-d', strtotime($dt));
$perPage = 10;
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
if ($lc == 'kg' and $df != '' and $dt != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromkg($df)->datetokg($dt)->orderBy('id', 'desc')->paginate($perPage);
} elseif ($lc == 'kg' and $df != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromkg($df)->orderBy('id', 'desc')->paginate($perPage);
} elseif ($lc == 'kg' and $dt != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datetokg($dt)->orderBy('id', 'desc')->paginate($perPage);
} elseif ($lc == 'ru' and $df != '' and $dt != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromru($df)->datetoru($dt)->orderBy('id', 'desc')->paginate($perPage);
} elseif ($lc == 'ru' and $df != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromru($df)->orderBy('id', 'desc')->paginate($perPage);
} elseif ($lc == 'ru' and $dt != '') {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datetoru($dt)->orderBy('id', 'desc')->paginate($perPage);
} else {
$postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->orderBy('id', 'desc')->paginate($perPage);
}
return view('Front::category.index', ['perPage' => $perPage, 'category' => $category, 'posts' => $postAllFromTo, 'categories' => $categories, 'backgroundMain' => $backgroundMain]);
}
public function directorPost(\Model\Post\ModelName $post)
{
$lc = app()->getlocale();
$post->incrementViewed();
$categories = \Model\Category\ModelName::all();
$positionTop = \Model\Banner\ModelName::top()->first();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
if ($post->parentId != '0' && $post->parentId != null) {
$parentId = $post->parentId;
$parentId = \Model\PhotoParent\ModelName::where('id', '=', $parentId)->first();
$photoChilds = \Model\PhotoChild\ModelName::where('parentId', '=', $parentId->id)->get();
} else {
$parentId = '0';
$photoChilds = '0';
}
if ($post->related1 != null) {
$related1Post = \Model\Post\ModelName::where('id', '=', $post->related1)->first();
} else {
$related1Post = null;
}
if ($post->related2 != null) {
$related2Post = \Model\Post\ModelName::where('id', '=', $post->related2)->first();
} else {
$related2Post = null;
}
if ($post->related3 != null) {
$related3Post = \Model\Post\ModelName::where('id', '=', $post->related3)->first();
} else {
$related3Post = null;
}
if ($lc == 'kg') {
$relatedPosts = \Model\Post\ModelName::where('category_id', '=', $post->category_id)->languagekg()->take(6)->skip(0)->orderBy('id', 'desc')->get();
} elseif ($lc == 'ru') {
$relatedPosts = \Model\Post\ModelName::where('category_id', '=', $post->category_id)->languageru()->take(6)->skip(0)->orderBy('id', 'desc')->get();
}
return view('Front::pages.directorPost', ['post' => $post, 'related1Post' => $related1Post, 'related2Post' => $related2Post, 'related3Post' => $related3Post, 'relatedPosts' => $relatedPosts, 'parentId' => $parentId, 'photoChilds' => $photoChilds, 'categories' => $categories, 'positionTop' => $positionTop, 'backgroundMain' => $backgroundMain, 'positionTop' => $this->positionTop, 'positionRight' => $this->positionRight, 'positionCenter' => $this->positionCenter, 'positionBottom' => $this->positionBottom, 'positionLeft' => $this->positionLeft]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(Category $category)
{
$category->delete();
return redirect()->route('admin.category.index');
}
public function editionkeneshPage()
{
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
return view('Front::pages.editionkenesh', ['backgroundMain' => $backgroundMain, 'categories' => $categories]);
}
|--------------------------------------------------------------------------
| Model Factories
|--------------------------------------------------------------------------
|
| Here you may define all of your model factories. Model factories give
| you a convenient way to create models for testing and seeding your
| database. Just tell the factory how a default model should look.
|
*/
$factory->define(\Model\User\ModelName::class, function (Faker\Generator $faker) {
$channels = \Model\Channel\ModelName::all();
$channel = $channels[rand(0, count($channels) - 1)];
return ['name' => $faker->name, 'email' => $faker->unique()->email, 'password' => bcrypt("123123"), 'role' => 'manager', 'channel_id' => $channel->id()];
});
$factory->define(\Model\Post\ModelName::class, function (Faker\Generator $faker) {
$categories = \Model\Category\ModelName::all();
$category = $categories[rand(0, count($categories) - 1)];
$channels = \Model\Channel\ModelName::all();
$channel = $channels[rand(0, count($channels) - 1)];
return ['category_id' => $category->id(), 'channel_id' => $channel->id(), 'name' => $faker->unique()->sentence(), 'title' => $faker->unique()->sentence(), 'content' => $faker->unique()->paragraph(), 'description' => $faker->unique()->sentence(), 'published' => true, 'general' => rand(0, 1)];
});
// // Category
// $factory->define(\Model\Category\ModelName::class, function (Faker\Generator $faker) {
// return [
// 'name' => $faker->word(),
// 'title' => $faker->word(),
// 'published' => true,
// ];
// });
$factory->define(\Model\Tag\Tag::class, function (Faker\Generator $faker) {
return ['name' => $faker->word];
public function allVideos()
{
$projectList = \Model\Project\ModelName::where('extracolumn', '=', '1')->orderBy('id', 'desc')->get();
$mainBanner = \Model\Background\ModelName::where('name', '=', 'main')->first();
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$perPage = 15;
$allVideos = \Model\Media\ModelName::where('published', '=', true)->orderBy('id', 'desc')->paginate($perPage);
return view('Front::media.all', ['perPage' => $perPage, 'mainBanner' => $mainBanner, 'categories' => $categories, 'projectList' => $projectList, 'backgroundMain' => $backgroundMain, 'allVideos' => $allVideos, 'positionTop' => $this->positionTop, 'positionRight' => $this->positionRight, 'positionCenter' => $this->positionCenter, 'positionBottom' => $this->positionBottom, 'positionLeft' => $this->positionLeft]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit(Post $post)
{
$channelList = \Model\Channel\ModelName::lists('display', 'id')->toArray();
$categoryList = \Model\Category\ModelName::lists('titleRu', 'id')->toArray();
$PhotoParentList = \Model\PhotoParent\ModelName::lists('name', 'id')->toArray();
$relatedPosts = \Model\Post\ModelName::where('title', '<>', '')->where('id', '<>', $post->id)->lists('title', 'id')->toArray();
$relatedPosts2 = \Model\Post\ModelName::where('titleRu', '<>', '')->where('id', '<>', $post->id)->lists('titleRu', 'id')->toArray();
$dostukProgramList = \Model\Project\ModelName::where('dostuk', '=', '1')->lists('name', 'id')->toArray();
$birinchiProgramList = \Model\Project\ModelName::where('birinchi', '=', '1')->lists('name', 'id')->toArray();
$kyrgyzradioProgramList = \Model\Project\ModelName::where('kyrgyzradio', '=', '1')->lists('name', 'id')->toArray();
$tags = \Model\Tag\Tag::lists('name', 'id');
$tags2 = \Model\Tag\Tag::lists('name', 'id');
return view('Admin::post.edit', ['post' => $post, 'tags' => $tags, 'tags2' => $tags2, 'relatedPosts' => $relatedPosts, 'relatedPosts2' => $relatedPosts2, 'channelList' => $channelList, 'categoryList' => $categoryList, 'PhotoParentList' => $PhotoParentList, 'dostukProgramList' => $dostukProgramList, 'birinchiProgramList' => $birinchiProgramList, 'kyrgyzradioProgramList' => $kyrgyzradioProgramList]);
}
public function project(\Model\Project\ModelName $project)
{
$projectList = \Model\Project\ModelName::get();
// $MediaCategory = \Model\MediaCategory\ModelName::get();
$mediaAll = \Model\Media\ModelName::get();
$mainBanner = \Model\Background\ModelName::where('name', '=', 'main')->first();
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$relatedNews = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', $project->id)->get();
$lc = app()->getlocale();
if ($lc == 'kg') {
$birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('name', '<>', '')->get();
} else {
$birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('nameRu', '<>', '')->get();
}
return view('Front::channel.birinchi.project', ['project' => $project, 'mainBanner' => $mainBanner, 'categories' => $categories, 'projectList' => $projectList, 'backgroundMain' => $backgroundMain, 'relatedNews' => $relatedNews, 'birinchiProjects' => $birinchiProjects]);
}
public function mediaPage(\Model\Media\ModelName $media)
{
/*$mediaPost = \Model\Media\ModelName::where('id','=',$media);
dd($mediaPost);*/
$mainBanner = \Model\Background\ModelName::where('name', '=', 'main')->first();
$categories = \Model\Category\ModelName::all();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
return view('Front::media.index', ['mediaPost' => $media, 'mainBanner' => $mainBanner, 'categories' => $categories, 'backgroundMain' => $backgroundMain]);
}
public function Posts()
{
$channel = \Model\Channel\ModelName::general();
$categories = \Model\Category\ModelName::all();
return view('Front::post.posts', ['channel' => $channel, 'categories' => $categories]);
}
