public function dosplit(Request $request)
{
$print_element = Element::where('subject_lesson_id', $request->subject_lesson_id)->where('title', 'نسخة للطباعة')->first();
if (!$print_element) {
$print_element = new Element();
$print_element->title = 'نسخة للطباعة';
$print_element->element_order = 10;
$print_element->state = 'نشط';
$print_element->type = 'pdf';
$print_element->subject_lesson_id = $request->subject_lesson_id;
$print_element->file = $request->file('file');
$print_element->save();
}
foreach ($request->subject_element_title as $key => $value) {
if ($request->element_start_page[$key]) {
$elelment = new Element();
$fonly = uniqid() . time() . '.pdf';
$filename = public_path() . '/temp/' . $fonly;
$elelment->title = $value;
$elelment->element_order = $request->element_order[$key];
$elelment->state = 'نشط';
$elelment->type = 'pdf';
$elelment->subject_lesson_id = $request->subject_lesson_id;
$pdf = new Pdf($print_element->file->path());
$pdf->cat($request->element_start_page[$key], $request->element_end_page[$key]);
$pdf->saveAs($filename);
// sleep(8);
$elelment->file = $filename;
// $elelment->file = 'https://el-css.edu.om/admin/public/temp/'.$fonly;
$elelment->save();
}
}
$message = 'تم اضافة العناصر بنجاح';
return redirect()->route('s.elements.index', array('id' => $request->subject_lesson_id))->with('success', $message);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
$subjects = DB::connection('old')->table('subjects')->get();
$new_lessons = [];
$new_lessons = [];
// $new_subjects = [];
$intro_lesson_id = 689998765;
$lessons = DB::connection('old')->table('lessons')->select('lessons.*')->where('les_sort', '>', 0)->join('subjects', 'les_subjectid', '=', 'sub_id')->get();
$element_new = Element::get();
foreach ($element_new as $lesson) {
$lesson->where('element_order', '=', 10)->delete();
}
foreach ($lessons as $lesson) {
if ($lesson->les_pdf) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'نسخة للطباعة';
$new_element->element_order = 10;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_pdf;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
$new_element->delete();
}
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
// $this->call("OthersTableSeeder");
// if (Subject::count()) {
// return;
// }
// Subject::where('id', 31)->delete();
// $lessons_ids = Lesson::where('subject_subject_id', 31)
// ->pluck('id');
// Lesson::where('subject_subject_id', 31)->delete();
// Element::whereIn('subject_lesson_id', $lessons_ids)
// ->delete();
Element::truncate();
Lesson::truncate();
$subjects = DB::connection('old')->table('subjects')->get();
$new_lessons = [];
// $new_subjects = [];
$intro_lesson_id = 689998765;
$lessons = DB::connection('old')->table('lessons')->select('lessons.*')->where('les_sort', '>', 0)->join('subjects', 'les_subjectid', '=', 'sub_id')->get();
foreach ($subjects as $subject) {
$new_subject['id'] = $subject->sub_id;
$new_subject['name'] = $subject->sub_name;
$new_subject['code'] = $subject->sub_code;
$new_subject['hour'] = $subject->sub_hours;
$new_subject['is_quran'] = str_contains($subject->sub_name, 'الكريم') ? 1 : 0;
$new_subject['description'] = $subject->sub_details;
$new_subject['created_at'] = new DateTime();
$new_subject['updated_at'] = new DateTime();
$new_subject['type'] = 'نظري';
$new_subjects[] = $new_subject;
//for intro
if (!empty($subject->sub_details)) {
$new_lesson['id'] = $intro_lesson_id;
$new_lesson['name'] = 'عن المادة';
$new_lesson['subject_subject_id'] = $subject->sub_id;
$new_lesson['lesson_order'] = 0;
$new_lesson['created_at'] = new DateTime();
$new_lesson['updated_at'] = new DateTime();
$new_lesson['state'] = 'نشط';
$new_lesson['type'] = 'مقدمة';
$new_lessons[] = $new_lesson;
$new_element = new Element();
$new_element->subject_lesson_id = $intro_lesson_id;
$new_element->title = 'الملخص';
$new_element->element_order = 0;
$new_element->state = 'نشط';
$new_element->type = 'نص';
$new_element->value = $subject->sub_details;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
$intro_lesson_id++;
}
}
foreach ($lessons as $lesson) {
$new_lesson['id'] = $lesson->les_id;
$new_lesson['name'] = $lesson->les_name;
$new_lesson['subject_subject_id'] = $lesson->les_subjectid;
$new_lesson['lesson_order'] = $lesson->les_sort;
$new_lesson['created_at'] = new DateTime();
$new_lesson['updated_at'] = new DateTime();
$new_lesson['type'] = 'درس';
$new_lesson['state'] = $lesson->les_active;
$new_lessons[] = $new_lesson;
if ($lesson->les_video) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'المحاضرة المرئية';
$new_element->element_order = 1;
$new_element->state = 'نشط';
$new_element->type = 'فيديو';
$new_element->value = $lesson->les_video;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
// $new_element->delete();
}
}
if ($lesson->les_proceduralgoals) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'الاهداف الاجرائية';
$new_element->element_order = 2;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_proceduralgoals;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
// $new_element->delete();
}
}
if ($lesson->les_mapconcepts) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'خريطة المفاهيم';
$new_element->element_order = 3;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_mapconcepts;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
// $new_element->delete();
}
}
if ($lesson->les_lecturecontent) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'المحتوى';
$new_element->element_order = 4;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_lecturecontent;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
$new_element->delete();
}
}
if ($lesson->les_summary) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'الملخص';
$new_element->element_order = 5;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_summary;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
$new_element->delete();
}
}
if ($lesson->les_pdf) {
$new_element = new Element();
$new_element->subject_lesson_id = $lesson->les_id;
$new_element->title = 'نسخة للطباعة';
$new_element->element_order = 10;
$new_element->state = 'نشط';
$new_element->type = 'PDF';
$new_element->file = "https://el-css.edu.om/" . $lesson->les_summary;
$new_element->created_at = new DateTime();
$new_element->updated_at = new DateTime();
$new_element->save();
if ($new_element->file->size() < 600) {
$new_element->delete();
}
}
}
// foreach(array_chunk($new_subjects, 1000) as $chunk) {
// DB::table('subject_subjects')->insert($chunk);
// }
foreach (array_chunk($new_lessons, 1000) as $chunk) {
DB::table('subject_lessons')->insert($chunk);
}
}
