/** * @param Module $module */ public function upload(Module $module) { $randPrefix = mt_rand(1, 9999); $module->getModuleImage()->move($this->getUploadRootDir(), $randPrefix . '-' . $module->getModuleImage()->getClientOriginalName()); $module->setPathImage($this->getUploadDir() . '/' . $randPrefix . '-' . $module->getModuleImage()->getClientOriginalName()); $module->setNameImage($randPrefix . '-' . $module->getModuleImage()->getClientOriginalName()); $module->setModuleImage(null); return; }
/** * @Route("/result/create", name="result_create") */ public function createAction(Request $request) { $result = new student_module_grade(); // generating data for the form $students = Student::getAll(); $studentIds = array(); foreach ($students as $student) { $studentIds[$student->getIndexNo()] = $student->getIndexNo(); //array_push($studentIds, $student->getIndexNo()); } $modules = Module::getAll(); $moduleIds = array(); foreach ($modules as $module) { $moduleIds[$module->getCode()] = $module->getCode(); //array_push($moduleIds, $module->getCode()); } $grades = Grade::getAll(); $gradeIds = array(); foreach ($grades as $grade) { $gradeIds[$grade->getGrade()] = $grade->getGrade(); //array_push($gradeIds, $grade->getGrade()); } $form = $this->createFormBuilder($result)->add('s_id', ChoiceType::class, array('choices' => $studentIds, 'choices_as_values' => true, 'label' => 'Index No'))->add('m_code', ChoiceType::class, array('choices' => $moduleIds, 'choices_as_values' => true, 'label' => 'Module'))->add('grade', ChoiceType::class, array('choices' => $gradeIds, 'choices_as_values' => true, 'label' => 'Grade'))->add('save', SubmitType::class, array('label' => 'Add Marks'))->getForm(); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { // ... perform some action, such as saving the task to the database $result->save(); return $this->redirectToRoute('result_create'); } ////////////////////////form 2 for add multiple////////////////////////////////// $form2Data = array('message' => 'Type your message here'); $form2 = $this->createFormBuilder($form2Data)->add('m_code', ChoiceType::class, array('choices' => $moduleIds, 'choices_as_values' => true, 'label' => 'Module'))->add('marks', TextType::class)->add('save', SubmitType::class, array('label' => 'Add Marks'))->getForm(); $form2->handleRequest($request); if ($form2->isSubmitted() && $form2->isValid()) { // ... perform some action, such as saving the task to the database $data = $form2->getData(); //die($data['marks']); $module = $data['m_code']; $marks = $data['marks']; //$em = $this->getDoctrine()->getManager(); $doc = $this->getDoctrine(); student_module_grade::saveAll($module, $marks, $doc); return $this->redirectToRoute('result_create'); } ////////////////////////////////////////////////////////// // ADDED THE FORM2 array return $this->render('result/create.html.twig', array('form' => $form->createView(), 'form2' => $form2->createView())); }
public static function getAll() { $con = Connection::getConnectionObject()->getConnection(); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $modules = array(); //Make an empty array $stmt = $con->prepare('SELECT id,code,title,sem_id,credits,gpa FROM module'); $stmt->execute(); $stmt->bind_result($id, $code, $title, $semId, $credits, $gpa); while ($stmt->fetch()) { $module = new Module(); $module->id = $id; $module->setTitle($title); $module->setCode($code); $module->setSemId($semId); $module->setCredits($credits); $module->setGpa($gpa); array_push($modules, $module); //Push one by one } $stmt->close(); return $modules; }
private function route(Module $module) { return $this->get('router')->generate('api_1_get_module', ['module' => $module->getId()]); }
/** * @Route("/module/view", name="module_viewAll") */ public function viewallAction(Request $request) { $modules = Module::getAll(); return $this->render('module/viewall.html.twig', array('modules' => $modules)); }