/** * @Route("/testdb",name="database") */ public function test() { $member = new Entity\Member(); $member->setMobile("07129832"); $member->setRegisterDate("12/12/2012"); $member->setEmail("*****@*****.**"); $member->setFirstName("Nuwan"); $member->setLastName("Rathnayaka"); $member->setStudentId("123456F"); $member->setDeptName("noone"); $r = new Entity\Resource(); $r->setResourceId("1"); $r->setDescription("this description"); $r->setOfficerId("1234"); $r->setValue("sdsds"); $ra = new Entity\ResourceAllocation(); $ra->setResourceId("1"); $ra->setMemberId("123456F"); $ra->setComments("Use enjoy it"); $ra->setDueDate("2016-01-07"); $ra->setIssuedDate("2015-12-34"); $nStudent = new Entity\Member(); $nStudent->setStudentId("123456"); $db = new Modal\DBAccess($nStudent); $n = $db->getDetail(); echo $n->getFirstName(); return new Response(); }
/** * Comparaison function for members * Ascending order for name and then firstName * * @param \AppBundle\Entity\Member $m1 * @param \AppBundle\Entity\Member $m2 * @return number (-1, 0 or 1 if $m1 is inferior, equals or superior to $m2) */ private function compareMembers(Member $m1, Member $m2) { $result = strcmp($m1->getName(), $m2->getName()); if ($result == 0) { $result = strcmp($m1->getFirstName(), $m2->getFirstName()); } return $result; }
/** * @param Member $member * @return null|string */ public function getPhoto(Member $member) { $filename = $this->photoDirectory . '/' . $member->getId() . '.' . $member->getPhotoExtension(); if (file_exists($filename) && is_readable($filename)) { return $filename; } return null; }
function createRandomMember() { $username = $this->generateRandomString(6); $member = new Member(); $member->setUsername($username); $this->em->persist($member); $this->em->flush(); return $member; }
/** * @param ObjectManager $manager */ public function load(ObjectManager $manager) { $member = new Member(); $member->setFirstname('John')->setLastname('Doe')->setGender('m')->setBirthday(new \DateTime('1980-01-01'))->setBirthplace('New York City')->setAddress('1 main street')->setZip('F-123')->setCity('Washington D.C.'); $manager->persist($member); $manager->flush(); $member = new Member(); $member->setFirstname('Jane')->setLastname('Smith')->setGender('f')->setBirthday(new \DateTime('1981-02-03'))->setBirthplace('Passadena')->setAddress('86th street')->setZip('ABCDEF')->setCity('Miami'); $manager->persist($member); $manager->flush(); }
private function checkMember(Member $member, array $formattedArray) { $this->assertArrayHasKey('id', $formattedArray, 'Check "id" key'); $this->assertArrayHasKey('name', $formattedArray, 'Check "name" key'); $this->assertArrayHasKey('firstName', $formattedArray, 'Check "firstName" key'); $this->assertArrayHasKey('phone', $formattedArray, 'Check "phone" key'); $this->assertEquals($formattedArray['id'], $member->getId(), 'Check "id" value'); $this->assertEquals($formattedArray['name'], $member->getName(), 'Check "name" value'); $this->assertEquals($formattedArray['firstName'], $member->getFirstName(), 'Check "firstName" value'); $this->assertEquals($formattedArray['phone'], $member->getPhone(), 'Check "phone" value'); }
public function prePersist(Member $member, LifecycleEventArgs $event) { /** @var UserManager $userManager */ $userManager = $this->container->get('fos_user.user_manager'); /** @var \AppBundle\Entity\User $user */ $user = $userManager->findUserByUsername($member->getUserName()); if ($user === null) { $user = $userManager->createUser(); $user->setUsername($member->getUserName()); $user->setEmail($member->getEmail()); $user->setRoles(['ROLE_USER']); $user->setPlainPassword('welcome'); $user->setEnabled(true); $userManager->updateUser($user, true); } $member->setFosUser($user); }
private function getUser($username) { $db = new DBConnection(); $link = $db->connect(); $query = "SELECT * FROM app_user WHERE email ='{$username}'"; $result = $link->query($query); $user = null; $member_id = 0; while ($row = mysqli_fetch_assoc($result)) { $user = new User($row['email'], $row['password'], "", unserialize($row['role'])); $member_id = $row['id']; } $db->closeConnection(); $member = new Member(); $member->setStudentId($member_id); $da = new DBAccess($member); $user->setMember($da->getDetail()); return $user; }
/** * @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)); }
public function buildForm(FormBuilderInterface $builder, array $options) { $builder->add('name', 'text', ['label' => 'Nombre']); $builder->add('surname1', 'text', ['label' => 'Primer apellido']); $builder->add('surname2', 'text', ['label' => 'Segundo apellido']); $builder->add('birth', 'date', ['years' => $this->getyears(), 'label' => 'Fecha de nacimiento']); $builder->add('dni', 'text', ['label' => 'DNI']); $builder->add('address', 'text', ['label' => 'Dirección']); $builder->add('phone', 'text', ['label' => 'Teléfono']); $builder->add('username', 'text', ['label' => 'Email']); $builder->add('change_password', 'password', ['mapped' => false, 'label' => 'Contraseña', 'required' => false]); $builder->add('status', 'choice', ['choices' => [0 => 'Inactivo', 1 => 'Activo'], 'label' => 'Estado']); $builder->add('rol', 'choice', ['choices' => Member::getRolOptions()]); $builder->add('send', 'submit', ['label' => 'Guardar']); }
/** * Format a Member to build a JSON-compatible array * * @param \AppBundle\Entity\Member $member * @return array */ private function formatMember(Member $member) { return array('id' => $member->getId(), 'name' => $member->getName(), 'firstName' => $member->getFirstName(), 'phone' => $member->getPhone()); }
public function getDetail() { $db = new DBConnection(); if ($db->connect()) { if ($this->entity_type == 'Member') { $member = new Member(); $query = "SELECT * FROM member WHERE s_ID = '" . $this->entity->getStudentId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $member->setStudentId($row['s_ID']); $member->setFirstName($row['first_name']); $member->setLastName($row['last_name']); $member->setDeptName($row['dept_name']); $member->setRegisterDate($row['register_date']); $member->setEmail($row['email']); $member->setMobile($row['mobile']); } $db->closeConnection(); return $member; } elseif ($this->entity_type == 'Resource') { $resource = new Resource(); $resource->setResourceId($this->entity->getResourceId()); $query = "SELECT * FROM resource WHERE r_ID='" . $this->entity->getResourceId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resource->setResourceId($row['r_ID']); $resource->setValue($row['value']); $resource->setDescription($row['description']); $resource->setOfficerId($row['o_ID']); } $db->closeConnection(); return $resource; } elseif ($this->entity_type == 'ResourceAllocation') { $resourceAlloc = new ResourceAllocation(); $query = "SELECT * FROM resource_alloc WHERE r_ID ='" . $this->entity->getResourceId() . "' AND s_ID = '" . $this->entity->getMemberId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resourceAlloc->setMemberId($row['s_ID']); $resourceAlloc->setResourceId($row['r_ID']); $resourceAlloc->setComments($row['comments']); $resourceAlloc->setIssuedDate($row['issued_date']); $resourceAlloc->setDueDate($row['due_date']); } $db->closeConnection(); return $resourceAlloc; } } else { echo "Cannot connect to database"; } }
public function getDetail() { $db = new DBConnection(); $link = $db->connect(); if ($link) { if ($this->entity_type == 'Member') { $member = new Member(); $query = "SELECT * FROM member WHERE id = " . $this->entity->getStudentId(); $result = $link->query($query); while ($row = mysqli_fetch_assoc($result)) { $member->setStudentId($row['id']); $member->setFirstName($row['first_name']); $member->setLastName($row['last_name']); $member->setDeptName($row['dept_name']); $member->setRegisterDate($row['register_date']); $member->setEmail($row['email']); $member->setMobile($row['mobile']); $member->setIndexNu($row['index_no']); $member->setBirthday($row['birthday']); $member->setGender($row['gender']); $member->setFacultyname($row['faculty_name']); $member->setNic($row['NIC']); } $db->closeConnection(); return $member; } elseif ($this->entity_type == 'Resource') { $resource = new Resource(); foreach ($this->entity as $property => $value) { $resource->{$property}($value); } $query = "SELECT * FROM resource WHERE r_ID='" . $resource->getResourceId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resource->setResourceId($row[1]); $resource->setCategory($row[2]); $resource->setDescription($row[3]); $resource->setOfficerId($row[4]); } $db->closeConnection(); return $resource; } elseif ($this->entity_type == 'DynamicAllocation') { $resourceAlloc = new ResourceAllocation(); foreach ($this->entity as $property => $value) { $resourceAlloc->{$property}($value); } $query = "SELECT * FROM dynamic_alloc WHERE r_ID ='" . $resourceAlloc->getResourceId() . "' AND s_ID = '" . $resourceAlloc->getMemberId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resourceAlloc->setComments($row[2]); $resourceAlloc->setIssuedDate($row[3]); $resourceAlloc->setDueDate($row[4]); } $db->closeConnection(); return $resourceAlloc; } } else { echo "Cannot connect to database"; } }
public function getDetail() { $db = new DBConnection(); if ($db->connect()) { if ($this->entity_type == 'Member') { $member = new Member(); foreach ($this->entity as $property => $value) { $member->{$property}($value); } $query = "SELECT * FROM member WHERE s_ID = '" . $member->getStudentId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $member->setFirstName($row[1]); $member->setLastName($row[2]); $member->setDeptName($row[3]); $member->setRegisterDate($row[4]); $member->setEmail($row[5]); $member->setMobile($row[6]); } $db->closeConnection(); return $member; } elseif ($this->entity_type == 'Resource') { $resource = new Resource(); foreach ($this->entity as $property => $value) { $resource->{$property}($value); } $query = "SELECT * FROM resource WHERE r_ID='" . $resource->getResourceId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resource->setResourceId($row[1]); $resource->setValue($row[2]); $resource->setDescription($row[3]); $resource->setOfficerId($row[4]); } $db->closeConnection(); return $resource; } elseif ($this->entity_type == 'ResourceAllocation') { $resourceAlloc = new ResourceAllocation(); foreach ($this->entity as $property => $value) { $resourceAlloc->{$property}($value); } $query = "SELECT * FROM resource_alloc WHERE r_ID ='" . $resourceAlloc->getResourceId() . "' AND s_ID = '" . $resourceAlloc->getMemberId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resourceAlloc->setComments($row[2]); $resourceAlloc->setIssuedDate($row[3]); $resourceAlloc->setDueDate($row[4]); } $db->closeConnection(); return $resourceAlloc; } } else { echo "Cannot connect to database"; } }