/**
* @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));
}
