/**
* @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";
}
}
