/** * Loads the user for the given username. * * This method must return null if the user is not found. * * @param string $username The username * * @return UserInterface|null */ public function loadUserByUsername($username) { $query = "select l.User_Id,l.Password,u.role from login l,user_role u where l.user_role=u.Id and l.User_Id=:username"; $Db = new Database(); $Con = $Db->getDbConnection(); $stmt = $Con->prepare($query); $stmt->execute(array(':username' => $username)); $table = $stmt->fetch(); if ($table['User_Id'] === null) { $message = sprintf('Username or Password Incorrect'); throw new UsernameNotFoundException($message); } $user = new Login(); $user->setUserId($table['User_Id']); $user->setPassword($table['Password']); $user->setRole($table['role']); return $user; }
public function addVehicleAction(Request $request) { // 1) build the form $user = new Vehicle(); $vehicle = new Vehical(); $resource = new Resource(); $form = $this->createForm(VehicleType::class, $user); // 2) handle the submit (will only happen on POST) $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $Db = new Database(); $Con = $Db->getDbConnection(); $sql = "INSERT INTO vehical (Vehical_Id,Vehical_Type,Capacity) VALUES (?,?,?)"; $sql2 = "INSERT INTO resource (Resource_Id,Type) VALUES (?,?)"; $stmt = $Con->prepare($sql2); $stmt->bindValue(1, $user->getVehical()); $stmt->bindValue(2, "vehicle"); $stmt->execute(); $stmt2 = $Con->prepare($sql); $stmt2->bindValue(1, $user->getVehical()); $stmt2->bindValue(2, $user->getVehicalType()); $stmt2->bindValue(3, $user->getCapacity()); $stmt2->execute(); // // $resource->setType("vehicle"); // $resource->setResourceId($user->getVehical()); // // $vehicle ->setVehical($resource); // $vehicle ->setVehicalType($user ->getVehicalType()); // $vehicle ->setCapacity($user ->getCapacity()); // // $em = $this->getDoctrine()->getManager(); // $em->persist($resource); // $em->persist($vehicle); // $em->flush(); // ... do any other work - like send them an email, etc // maybe set a "flash" success message for the user return $this->redirectToRoute('admin_addVehicle'); } return $this->render('URMSAppBundle:Admin:addVehicle.html.twig', array('form' => $form->createView())); }
public function getVehicleListAction(Request $request) { $Vrequest = new RequestVehicle(); $form = $this->createForm(VehicleRequestType::class, $Vrequest); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $vehicleType = $Vrequest->getVehicleType(); $query = "select * from vehical WHERE Vehical_Type = :vehicleType"; $Db = new Database(); $Con = $Db->getDbConnection(); $stmt = $Con->prepare($query); $stmt->execute(array(':vehicleType' => $Vrequest->getVehicleType())); $new_Vehical = $stmt->fetchAll(); return $this->render('URMSAppBundle:User:View_Vehical_List.html.twig', array('vehicles' => $new_Vehical)); } return $this->render('URMSAppBundle:User:RequestVehicle.html.twig', array('form' => $form->createView())); }