/**
  * save
  * Saves a collection of attendance records
  * @Route("/admin/schedule/attendance/save", options={"expose"=true})
  * @Template("TSKScheduleBundle:Default:attendance_save.html.twig")
  * @Method("POST")
  */
 public function saveAction(Request $request)
 {
     $form = $this->createForm(new AttendanceFormType(), new Attendance(), array('csrf_protection' => false));
     $form->bind($request);
     $attendance = $form->getData();
     $roster = $attendance->getRosters()->first();
     if ($request->isMethod('POST')) {
         if ($form->isValid()) {
             // save the attendance
             $em = $this->getDoctrine()->getManager();
             $statuses = $attendance->getStatuses();
             foreach ($attendance->getRosters() as $r) {
                 $sa = new ScheduleAttendance();
                 $sa->setSchool($r->getSchedule()->getSchool());
                 $sa->setClass($r->getClass());
                 $sa->setSchedule($r->getSchedule());
                 $sa->setStudent($r->getStudent());
                 $sa->setAttDate($attendance->getAttDate());
                 $sa->setStatus('present');
                 $em->persist($sa);
                 try {
                     $em->flush();
                 } catch (\Exception $e) {
                     print $e->getMessage();
                     if ($e->getCode() == '23000') {
                         // ignore ...
                     } else {
                         // print $e->getCode();
                         // throw $e;
                     }
                 }
             }
             if ($this->getRequest()->isXmlHttpRequest()) {
                 return new Response(1);
             } else {
                 $this->get('session')->getFlashBag()->add('success', 'Attendance saved!');
             }
         } else {
             $errors = $this->get('validator')->validate($roster);
             $errmsg = '';
             foreach ($errors as $error) {
                 $errmsg = $error->getMessage();
             }
             if ($this->getRequest()->isXmlHttpRequest()) {
                 return new Response('some error');
             } else {
                 $this->get('session')->getFlashBag()->add('error', 'Error saving attendance ' . $errmsg);
             }
         }
         if ($this->getRequest()->isXmlHttpRequest()) {
             return new Response(1);
         } else {
             return $this->redirect($this->getRequest()->headers->get('referer'));
         }
         return $this->redirect($this->generateUrl('tsk_schedule_roster_index', array('id' => $roster->getSchedule()->getId(), 'class' => $roster->getClass()->getId())));
     }
 }
示例#2
0
 protected function processAttendance($row)
 {
     if ($row) {
         $attendanceRepo = $this->manager->getRepository('TSK\\ScheduleBundle\\Entity\\ScheduleAttendance');
         $attDate = new \DateTime($row[3]);
         $classRepo = $this->manager->getRepository('TSK\\ClassBundle\\Entity\\Classes');
         $studentRepo = $this->manager->getRepository('TSK\\StudentBundle\\Entity\\Student');
         $class = $classRepo->find($row[1]);
         if (!$class) {
             print "Can't find class " . $row[1] . "\n";
             exit;
         }
         $student = $studentRepo->findOneBy(array('legacyStudentId' => $row[2]));
         if (!$student) {
             print "Can't find student " . $row[2] . "\n";
             exit;
         }
         $oldAttendance = $attendanceRepo->findOneBy(array('attDate' => $attDate, 'class' => $class, 'student' => $student));
         if (!$oldAttendance) {
             $attendance = new ScheduleAttendance();
             $attendance->setSchool($this->school);
             $attendance->setSchedule($this->dummyScheduleEntity);
             $attendance->setClass($class);
             $attendance->setStudent($student);
             $attendance->setAttDate($attDate);
             $attendance->setStatus('present');
             $attendance->setNotes($row[4]);
             try {
                 $this->manager->persist($attendance);
                 $this->manager->flush();
             } catch (DBALException $e) {
             } catch (\Exception $e) {
                 ld($e);
                 print $e->getMessage();
                 exit;
             }
         }
     }
 }