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