public function run() { DB::table('subjects')->delete(); Subject::create(array('subjectcode' => 'SC6', 'grade' => '6', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA6', 'grade' => '6', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI6', 'grade' => '6', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN6', 'grade' => '6', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'GE6', 'grade' => '6', 'subjectname' => 'Geography')); Subject::create(array('subjectcode' => 'CI6', 'grade' => '6', 'subjectname' => 'Citizenship Education')); Subject::create(array('subjectcode' => 'TA6', 'grade' => '6', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI6', 'grade' => '6', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'HS6', 'grade' => '6', 'subjectname' => 'Health Science')); Subject::create(array('subjectcode' => 'SC7', 'grade' => '7', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA7', 'grade' => '7', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI7', 'grade' => '7', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN7', 'grade' => '7', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'GE7', 'grade' => '7', 'subjectname' => 'Geography')); Subject::create(array('subjectcode' => 'CI7', 'grade' => '7', 'subjectname' => 'Citizenship Education')); Subject::create(array('subjectcode' => 'TA7', 'grade' => '7', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI7', 'grade' => '7', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'HS7', 'grade' => '7', 'subjectname' => 'Health Science')); Subject::create(array('subjectcode' => 'SC8', 'grade' => '8', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA8', 'grade' => '8', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI8', 'grade' => '8', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN8', 'grade' => '8', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'GE8', 'grade' => '8', 'subjectname' => 'Geography')); Subject::create(array('subjectcode' => 'CI8', 'grade' => '8', 'subjectname' => 'Citizenship Education')); Subject::create(array('subjectcode' => 'TA8', 'grade' => '8', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI8', 'grade' => '8', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'HS8', 'grade' => '8', 'subjectname' => 'Health Science')); Subject::create(array('subjectcode' => 'SC9', 'grade' => '9', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA9', 'grade' => '9', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI9', 'grade' => '9', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN9', 'grade' => '9', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'GE9', 'grade' => '9', 'subjectname' => 'Geography')); Subject::create(array('subjectcode' => 'CI9', 'grade' => '9', 'subjectname' => 'Citizenship Education')); Subject::create(array('subjectcode' => 'TA9', 'grade' => '9', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI9', 'grade' => '9', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'HS9', 'grade' => '9', 'subjectname' => 'Health Science')); Subject::create(array('subjectcode' => 'SC10', 'grade' => '10', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA10', 'grade' => '10', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI10', 'grade' => '10', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN10', 'grade' => '10', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'TA10', 'grade' => '10', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI10', 'grade' => '10', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'SC11', 'grade' => '11', 'subjectname' => 'Science')); Subject::create(array('subjectcode' => 'MA11', 'grade' => '11', 'subjectname' => 'Maths')); Subject::create(array('subjectcode' => 'HI11', 'grade' => '11', 'subjectname' => 'History')); Subject::create(array('subjectcode' => 'EN11', 'grade' => '11', 'subjectname' => 'English')); Subject::create(array('subjectcode' => 'TA11', 'grade' => '11', 'subjectname' => 'Tamil')); Subject::create(array('subjectcode' => 'SI11', 'grade' => '11', 'subjectname' => 'Sinhala')); Subject::create(array('subjectcode' => 'CM12', 'grade' => '12', 'subjectname' => 'Combined Maths')); Subject::create(array('subjectcode' => 'C12', 'grade' => '12', 'subjectname' => 'Chemistry')); Subject::create(array('subjectcode' => 'P12', 'grade' => '12', 'subjectname' => 'Physics')); Subject::create(array('subjectcode' => 'B12', 'grade' => '12', 'subjectname' => 'Bio Science')); Subject::create(array('subjectcode' => 'ET12', 'grade' => '12', 'subjectname' => 'Engineering Technology')); Subject::create(array('subjectcode' => 'ST12', 'grade' => '12', 'subjectname' => 'Science For Technology')); Subject::create(array('subjectcode' => 'IT12', 'grade' => '12', 'subjectname' => 'Information Communication Technology')); }
function doInsert() { if (isset($_POST['savecourse'])) { if ($_POST['subjcode'] == "" or $_POST['subjdesc'] == "" or $_POST['unit'] == "") { message("All field is required!", "error"); check_message(); } else { $subj = new Subject(); $subjcode = $_POST['subjcode']; $subjdesc = $_POST['subjdesc']; $unit = $_POST['unit']; $pre = $_POST['pre']; $course = $_POST['course']; $ay = $_POST['ay']; $Semester = $_POST['Semester']; $subj->SUBJ_CODE = $subjcode; $subj->SUBJ_DESCRIPTION = $subjdesc; $subj->UNIT = $unit; $subj->PRE_REQUISITE = $pre; $subj->COURSE_ID = $course; $subj->AY = $ay; $subj->SEMESTER = $Semester; $istrue = $subj->create(); if ($istrue == 1) { message("New Subject created successfully!", "success"); redirect('index.php'); } } } elseif (isset($_POST['saveandnewcourse'])) { if ($_POST['subjcode'] == "" or $_POST['subjdesc'] == "" or $_POST['unit'] == "") { message("All field is required!", "error"); check_message(); } else { $subj = new Subject(); $subjcode = $_POST['subjcode']; $subjdesc = $_POST['subjdesc']; $unit = $_POST['unit']; $pre = $_POST['pre']; $course = $_POST['course']; $ay = $_POST['ay']; $Semester = $_POST['Semester']; $subj->SUBJ_CODE = $subjcode; $subj->SUBJ_DESCRIPTION = $subjdesc; $subj->UNIT = $unit; $subj->PRE_REQUISITE = $pre; $subj->COURSE_ID = $course; $subj->AY = $ay; $subj->SEMESTER = $Semester; $istrue = $subj->create(); if ($istrue == 1) { message("New Subject created successfully!", "success"); redirect('index.php?view=add'); } } } }
public function run() { DB::table('subjects')->delete(); Subject::create(array('name' => 'Algorithm Design and Analysis', 'sem' => 4)); Subject::create(array('name' => 'Computer Organization', 'sem' => 4)); Subject::create(array('name' => 'Graph Theory', 'sem' => 4)); Subject::create(array('name' => 'Mathematics 4', 'sem' => 4)); Subject::create(array('name' => 'Micro-Processors', 'sem' => 4)); Subject::create(array('name' => 'Unix', 'sem' => 4)); }
/** * Guarda un nuevo objetivo en la base de datos * * @return Response */ public function store($admin) { $validator = Validator::make($data = Input::all(), Subject::$rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { Subject::create($data); $this->log_action('Objetivo Creado', 'El objetivo "' . Input::get('name') . '" ha sido creado.'); Session::flash('msj', 'El objetivo ha sido creado exitosamente.'); return Redirect::route('admin.index', compact('admin')); } }
} $course_id = Course::get_by_sql("SELECT * FROM " . T_COURSES . " WHERE " . C_COURSE_CODE . "='" . trim($_POST['course_code']) . "'")[0]->id; $rows = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " WHERE " . C_SUBJECT_CODE . "='" . $_POST['code'] . "' AND " . C_SUBJECT_COURSE_ID . "=" . $course_id); if ($_POST['oper'] == 'add') { if (count($rows) > 0) { die("exists"); } $subject = new Subject(); $subject->code = $_POST['code']; $subject->description = $_POST['description']; $subject->units = $_POST['units']; $subject->prereq_subject_id = $prereq_subject_id; $subject->course_id = $course_id; $subject->year = $_POST['year']; $subject->semester = $_POST['semester']; $subject->curriculum_id = $_POST['curriculum_id']; $subject->create(); } else { if ($_POST['oper'] == 'edit') { $subject = Subject::get_by_id($_POST['id']); $subject->code = $_POST['code']; $subject->description = $_POST['description']; $subject->units = $_POST['units']; $subject->prereq_subject_id = $prereq_subject_id; $subject->course_id = $course_id; $subject->year = $_POST['year']; $subject->semester = $_POST['semester']; $subject->curriculum_id = $_POST['curriculum_id']; $subject->update(); } }