/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Course\Course::truncate();
// factory(\Model\Course\Course::class, 10)->create();
\Model\Course\Course::create(['id' => 1, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=9', 'image' => 'img/course/cover/tarih-600x400.jpg', 'code' => 'TAR-251', 'name' => 'Ата Мекен Тарыхы I', 'description' => 'Атамекен (Кыргыз Республикасынын) тарыхын окутууга киришүү Кыргызстандагы этникалык процесстер, кыргыз элинин жаралышы жана калыптанышы жөнүндө', 'approved' => true, 'published' => true, 'order' => 10]);
\Model\Course\Course::create(['id' => 2, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/ekoloji-600x400.jpg', 'code' => 'CEV-150', 'name' => 'Экология', 'description' => 'Киришүү. Экологиянын маселелери, изилдөө объектиси жана структурасы. Экологиянын дисциплиналар арасындагы мүнөзү', 'approved' => true, 'published' => true, 'order' => 20]);
\Model\Course\Course::create(['id' => 3, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=8', 'image' => 'img/course/cover/turk-uygralik-600x400.jpg', 'code' => 'TAR-202', 'name' => 'Dünya ve Türk Uygarlıkları', 'description' => 'Көчмөн цивлизациялардын өзгөчөлүктөрү', 'approved' => true, 'published' => true, 'order' => 30]);
\Model\Course\Course::create(['id' => 4, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=3', 'image' => 'img/course/cover/manas-600x400.jpg', 'code' => 'TUR-226', 'name' => 'Manasşinaslık', 'description' => '“Манас” эпосу – кыргыз рухунун туу чокусу', 'approved' => true, 'published' => true, 'order' => 40]);
\Model\Course\Course::create(['id' => 5, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=7', 'image' => 'img/course/cover/felsefe-600x400.jpg', 'code' => 'FIL-291', 'name' => 'Felsefe', 'description' => 'Felsefe Tarihi II (İslam ve Ortaçağ Felsefesi)', 'approved' => true, 'published' => true, 'order' => 50]);
\Model\Course\Course::create(['id' => 6, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=12', 'image' => 'img/course/cover/positif-bilimler-600x400.jpg', 'code' => 'FEN-102', 'name' => 'Pozitiv Bilim Kavramları', 'description' => 'Заманбап табият таануу илимдеринин концепциялары курсунун предмети. Коом, маданият жана илим.', 'approved' => true, 'published' => true, 'order' => 60]);
\Model\Course\Course::create(['id' => 7, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=2', 'image' => 'img/course/cover/tarih-2-600x400.jpg', 'code' => 'FEN-102', 'name' => 'Ata Meken Tarihi II (TR)', 'description' => 'Türkiye Cumhuriyeti Tarihi', 'approved' => true, 'published' => true, 'order' => 70]);
\Model\Course\Course::create(['id' => 8, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/ume-333-600x400.jpg', 'code' => 'UME3', 'name' => 'Programming Languages I', 'description' => 'Programming Languages I', 'approved' => true, 'published' => true, 'order' => 80]);
\Model\Course\Course::create(['id' => 9, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/java-600x400.jpg', 'code' => 'UME4', 'name' => 'Programming Languages II', 'description' => 'Introduction to Programming using Java', 'approved' => true, 'published' => true, 'order' => 90]);
// $courses = \Model\Course\Course::lists('id');
// $users = \Model\User\User::whereIn('role', ['student', 'teacher'])->lists('id')->toArray();
\DB::table('user_course')->insert(['user_id' => 3, 'course_id' => 2]);
\DB::table('user_course')->insert(['user_id' => 4, 'course_id' => 2]);
$students = \Model\User\User::where('role', '=', 'student')->get();
// registering students to course
$arr = [];
foreach ($students as $student) {
$arr[] = ['user_id' => $student->id(), 'course_id' => 2];
}
\DB::table('user_course')->insert($arr);
}
/**
* Execute the command.
*
* @return void
*/
public function handle()
{
$token = str_random(40);
$email = $this->request->input('email');
$user = User\User::where('email', '=', $email)->first();
$counter = \DB::table('password_resets')->where('id', '=', $user->id())->get();
if (count($counter) > 0) {
\DB::table('password_resets')->where('id', '=', $user->id())->update(['token' => $token]);
} else {
\DB::table('password_resets')->insert(['id' => $user->id(), 'token' => $token]);
}
session()->flash('success-message', trans('site.Check your email to reset your password'));
event(new User\Events\PasswordResetEvent($user));
}
/**
* Get a paginated list of all users.
*
* @return mixed
*/
public function getTotal(Request $request)
{
$total = User::where(function ($query) use($request) {
if ($request->has('filter')) {
$filters = $request->input('filter');
foreach ($filters['filters'] as $key => $filter) {
if ($filter['operator'] == 'startswith') {
$query->where($filter['field'], 'LIKE', $filter['value'] . '%');
} elseif ($filter['operator'] == 'contains') {
$query->where($filter['field'], 'LIKE', '%' . $filter['value'] . '%');
} elseif ($filter['operator'] == 'gte') {
$query->where($filter['field'], '>=', $filter['value']);
} elseif ($filter['operator'] == 'lte') {
$query->where($filter['field'], '<=', $filter['value']);
} elseif ($filter['operator'] == 'eq') {
if ($filter['value'] == "true") {
$filter['value'] = 1;
} elseif ($filter['value'] == "false") {
$filter['value'] = 0;
}
$query->where($filter['field'], '=', $filter['value']);
}
}
}
})->count();
return $total;
}
