public function load(ObjectManager $manager) { // UserSkill : 1 $repository = $manager->getRepository('AppBundle:UserSkill'); $userSkillEntity = $repository->find(1); // User : 2 $repository = $manager->getRepository('AppBundle:User'); $userEntity = $repository->find(2); $voteEntity = new Vote(); $voteEntity->setUserSkill($userSkillEntity); $voteEntity->setUser($userEntity); $manager->persist($voteEntity); $manager->flush(); }
/** * @Route("/rating", name="rating", options={"expose"=true}) */ public function rateSkillAction(Request $request) { $result = 'false'; $id = $request->get('term'); $em = $this->getDoctrine()->getManager(); $userSkill = $em->getRepository('AppBundle:UserSkill')->find($id); $userSkillId = $userSkill->getUserSkillId(); $user = $this->get('security.token_storage')->getToken()->getUser(); $userId = $user->getUserId(); $userVoting = $em->getRepository('AppBundle:User')->find($userId); $userInVoteExistObject = $em->getRepository('AppBundle:Vote')->findOneBy(array('user' => $userId, 'userkill' => $userSkillId)); if ($userInVoteExistObject) { $em->remove($userInVoteExistObject); $em->flush(); } else { $voteEntity = new Vote(); $voteEntity->setUserSkill($userSkill); $voteEntity->setUser($userVoting); $em->persist($voteEntity); $em->flush(); $result = 'true'; } $counts = $em->getRepository('AppBundle:Vote')->counting($id); foreach ($counts as $count) { $total = $count['rate']; } $response = new Response(); $response->setContent(json_encode(array('total' => $total, 'status' => $result))); return $response; }