/** * @Route("/register/newresourcetype", name="new_esource_type_registration") */ public function newresourcetypeAction(Request $request) { $resource = new NewResourceType(); $formtitle = "New Resource Type"; $form = $this->createFormBuilder($resource)->add('name', \Symfony\Component\Form\Extension\Core\Type\TextType::class, ['label' => 'Resource Name'])->add('o_id', ChoiceType::class, array('mapped' => true, 'choices' => $this->getOfficername(), 'label' => 'Officer Name'))->add('save', SubmitType::class, ['label' => 'Submit'])->getForm(); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $db = new DBAccess($resource); $db->insert(); return new RedirectResponse($this->generateUrl('new_esource_type_registration'), array('error_description' => 'you are successfully completed your action')); } return $this->render('default/index.html.twig', array('form' => $form->createView(), 'title' => $formtitle, 'table' => false, 'profile' => false)); }
/** * @Route("/register/event1", name="event_register1S") */ public function eventAction(Request $request) { $event = new Event(); $title = "New Event Registration"; $form = $this->createForm(EventType::class, $event); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $date = explode('-', $event->getDaterange()); $event->setStartdate(date('Y-m-d', strtotime($date[0]))); $event->setEnddate(date('Y-m-d', strtotime($date[0]))); $event->setStarttime($event->getStarttime()->getTimestamp()); $event->setEndtime($event->getEndtime()->getTimestamp()); var_dump($event); $db = new DBAccess($event); $db->insert(); return new RedirectResponse($this->generateUrl('event_register1S'), array('error_description' => 'you are successfully completed your action')); } return $this->render('default/index.html.twig', array('form' => $form->createView(), 'title' => $title, 'table' => false, 'profile' => false)); }
/** * @Route("/register/member/{email}", name="student_nregistration") */ public function newmemberAction(Request $request, $email) { $member = new Member(); $member->setEmail($email); $title = "Student Registration"; $date = date("Y-m-d"); $member->setRegisterDate($date); $form = $this->createForm(MemberType::class, $member); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $db = new DBAccess($member); $id = $db->insert(); if (!$id) { return $this->redirect($this->generateUrl('student_check', array('error_description' => 'Email is not available'))); } else { return $this->redirect($this->generateUrl('student_check', array('error_description' => 'New member added with DI ' . $id))); } } return $this->render('default/index.html.twig', array('form' => $form->createView(), 'title' => $title, 'table' => false, 'profile' => false)); }
/** * @Route("/reserve/{slug}") * @Route("/reserve/sport", name="reserve_sport") * @Route("/reserve/other", name="reserve_other") * * */ public function reserveSportAction(Request $request, $slug) { $task = new DynamicAllocation(); $formtitle = " Resource Reservation"; if ($slug == 'sport') { $row = ResourceAccess::getResourceAvalability('SEQP'); } else { $row = ResourceAccess::getResourceAvalability('OTHER'); } $col = array_keys($row[0]); $form = $this->createFormBuilder($task)->add('type_id', ChoiceType::class, array('mapped' => true, 'choices' => $this->optionBuild("SEQP"), 'label' => 'Type'))->add('quntity', IntegerType::class, ['label' => 'Quntity'])->add('daterange', TextType::class, array('label' => 'Reservation period', 'attr' => array('class' => 'form-control pull-right', 'data-inputmask' => "'alias': 'yyyy-mm-dd'", 'data-mask')))->add('comments', TextType::class, ['label' => 'Comments'])->add('save', SubmitType::class, ['label' => 'Submit'])->getForm(); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $result = $form->getData(); $date = explode('-', $result->getDaterange()); $task->setIssuedDate(date('Y-m-d', strtotime($date[0]))); $task->setDueDate(date('Y-m-d', strtotime($date[0]))); $task->setMemberId($this->getUser()->getMember()->getStudentId()); $db = new DBAccess($task); $db->insert(); return new RedirectResponse($this->generateUrl('reserve'), array('error_description' => 'you are successfully completed your action')); } return $this->render('default/index.html.twig', array('form' => $form->createView(), 'title' => $formtitle, 'table' => true, 'row' => $row, 'col' => $col, 'profile' => false)); }
/** * Created by PhpStorm. // * User: bmCSoft * Date: 2015-12-16 * Time: 4:57 PM */ namespace AppBundle\Modal; use AppBundle\Entity\Member; use AppBundle\Entity\Resource; use AppBundle\Entity\User; use AppBundle\Entity\ResourceAllocation; use Symfony\Component\Config\Definition\Exception\Exception; $r = new DBAccess(null); $r->insert(); class DBAccess { private $entity_type; private $entity; private $error = false; function myErrorHandler($errno, $errstr, $errfile, $errline) { if (!$this->error) { $error = true; } exit; } function __construct($entity) { if ($entity != null) {