コード例 #1
0
 /**
  * @param Site $site
  * @param LoanOfficer $loanOfficer
  * @return \Doctrine\ORM\QueryBuilder
  */
 public function findAllByLoanOfficerQuery(Site $site, LoanOfficer $loanOfficer)
 {
     $siteIds = $site->getChildSiteIds();
     array_push($siteIds, $site->getId());
     $q = $this->createQueryBuilder('q')->where('q.site IN (:site_ids)')->andWhere('q.deleted = 0')->andWhere('q.loan_officer = :loan_officer')->orderBy('q.created', 'DESC')->setParameter('loan_officer', $loanOfficer->getId())->setParameter('site_ids', $siteIds);
     return $q;
 }
コード例 #2
0
 /**
  * @param Request $request
  * @return \Symfony\Component\HttpFoundation\RedirectResponse|Response
  * @throws \Symfony\Component\Form\Exception\AlreadyBoundException
  */
 public function addAction(Request $request)
 {
     $siteRequest = $this->get('sudoux.cms.site');
     $site = $siteRequest->getSite();
     $em = $this->getDoctrine()->getEntityManager();
     $officer = new LoanOfficer();
     $officer->setSite($site);
     $siteType = $site->getSiteType();
     if (isset($siteType)) {
         $siteBranch = $site->getSettings()->getBranch();
         if ($siteType->getKeyName() == 'branch' && isset($siteBranch)) {
             $officer->setBranch($siteBranch);
         }
     }
     $form = $this->createForm(new LoanOfficerType($site), $officer);
     if ($request->getMethod() == 'POST') {
         $form->bind($request);
         if ($form->isValid()) {
             $user = $this->get('security.context')->getToken()->getUser();
             $photoData = $form['officer_photo_file']->getData();
             if (isset($photoData)) {
                 $photo = new File();
                 $photo->setName(sprintf('%s %s', $form['first_name']->getData(), $form['last_name']->getData()));
                 $photo->setUser($user);
                 $photo->setSite($site);
                 $photo->setFile($photoData);
                 $officer->setOfficerPhoto($photo);
             }
             $em->persist($officer);
             $em->flush($officer);
             $request->getSession()->getFlashBag()->add('success', 'Your loan officer has been created.');
             return $this->redirect($this->generateUrl('sudoux_mortgage_admin_loan_officer'));
         }
     }
     return $this->render('SudouxMortgageBundle:LoanOfficerAdmin:add.html.twig', array('form' => $form->createView(), 'officer' => $officer));
 }
コード例 #3
0
 /**
  * @param LoanOfficer $loanOfficer
  */
 protected function addLoanOfficerUser(LoanOfficer $loanOfficer)
 {
     $loUser = $loanOfficer->getUser();
     $loSite = $loanOfficer->getOfficerSite();
     $loCreateUser = $loanOfficer->getAutoCreateUser();
     if ($loCreateUser && !isset($loUser) && isset($loSite)) {
         $loRole = $this->em->getRepository('SudouxCmsUserBundle:Role')->findOneBy(array('role' => 'ROLE_LOAN_OFFICER'));
         // check if user already exists by email
         $existingUser = $this->em->getRepository('SudouxCmsUserBundle:User')->findOneBy(array('email' => $loanOfficer->getEmail()));
         if (isset($existingUser)) {
             // assign existing user to lo
             $loanOfficer->setUser($existingUser);
             $this->em->persist($loanOfficer);
         } else {
             $user = new User();
             $username = strtolower(substr($loanOfficer->getFirstName(), 0, 1) . $loanOfficer->getLastName());
             $username = str_replace(' ', '', preg_replace("/[^A-Za-z0-9 ]/", '', $username));
             $user->setUsername($this->getLoanOfficerUsername($username));
             $factory = $this->container->get('security.encoder_factory');
             $encoder = $factory->getEncoder($user);
             $password = $encoder->encodePassword($user->generatePassword(), $user->getSalt());
             $user->setPassword($password);
             $user->setEmail($loanOfficer->getEmail());
             $user->setFirstName($loanOfficer->getFirstName());
             $user->setLastName($loanOfficer->getLastName());
             $user->addSite($loanOfficer->getOfficerSite());
             $user->addRole($loRole);
             $user->addToken();
             $user->setTimezone($loanOfficer->getSite()->getTimezone());
             $loanOfficer->setUser($user);
             $this->em->persist($loanOfficer);
             $emailUtil = $this->container->get('sudoux.cms.message.email_util');
             $email = new Email();
             $email->setRecipient($user->getEmail());
             $email->setRecipientName($user->getFullName());
             $email->setSubject($this->container->get('sudoux.cms.site')->getSiteVar('New Website Account', 'loan_officer_user_add_email_subject'));
             $email->setUser($user);
             $email->setSite($loanOfficer->getSite());
             $resetPasswordUrl = sprintf("https://%s%s", $loanOfficer->getOfficerSite()->getPrimaryDomain()->getDomain(), $this->router->generate('sudoux_cms_user_reset_password', array('token' => $user->getToken())));
             // default message
             $message = sprintf('<p>An account has been created for you on your new website. Your username is %s</p>', $user->getUsername());
             $message .= sprintf('<p><a href="%s">Click here</a> to set your password and confirm your account.</p>', $resetPasswordUrl);
             $tokens = array('username' => $user->getUsername(), 'email' => $user->getEmail(), 'reset_password_url' => $resetPasswordUrl, 'first_name' => $user->getFirstName(), 'last_name' => $user->getLastName(), 'website_url' => 'https://' . $loanOfficer->getOfficerSite()->getPrimaryDomain()->getDomain());
             $message = $this->container->get('sudoux.cms.site')->getSiteVar($message, 'loan_officer_user_add_email_message', $tokens);
             $email->setMessage($message);
             $emailUtil->logAndSend($email);
         }
         $this->em->flush($loanOfficer);
     }
 }
コード例 #4
0
 /**
  * @param $csvPath
  * @throws \Exception
  */
 protected function importLoanOfficersFromCsv($csvPath)
 {
     ini_set('auto_detect_line_endings', true);
     $siteId = $this->site->getId();
     $header = array('first_name', 'last_name', 'email', 'los_id', 'nmls_id', 'title', 'phone_office', 'phone_mobile', 'phone_tollfree', 'fax', 'signature', 'bio', 'branch_nmls_id');
     $headerValid = true;
     $batchCount = 10;
     if (file_exists($csvPath)) {
         if (($handle = fopen($csvPath, "r")) !== FALSE) {
             $row = 0;
             while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                 if ($row == 0) {
                     // validate the header
                     for ($i = 0; $i < count($data); $i++) {
                         if ($data[$i] != $header[$i]) {
                             $headerValid = false;
                             break;
                         }
                     }
                     if (!$headerValid) {
                         throw new \Exception('Csv headers are not valid. Correct format is ' . implode(',', $header));
                     }
                 } else {
                     $loanOfficer = new LoanOfficer();
                     $loanOfficer->setFirstName($this->getCsvValue($data[0]));
                     $loanOfficer->setLastName($this->getCsvValue($data[1]));
                     $loanOfficer->setEmail($this->getCsvValue($data[2]));
                     $loanOfficer->setLosId($this->getCsvValue($data[3]));
                     $loanOfficer->setNmlsId($this->getCsvValue($data[4]));
                     $loanOfficer->setTitle($this->getCsvValue($data[5]));
                     $loanOfficer->setPhoneOffice($this->getCsvValue($data[6]));
                     $loanOfficer->setPhoneMobile($this->getCsvValue($data[7]));
                     $loanOfficer->setPhoneTollfree($this->getCsvValue($data[8]));
                     $loanOfficer->setFax($this->getCsvValue($data[9]));
                     $loanOfficer->setSignature($this->getCsvValue($data[10]));
                     $loanOfficer->setBio($this->getCsvValue($data[11]));
                     $loanOfficer->setSite($this->site);
                     $loanOfficer->setAutoCreateUser(false);
                     // this needs to be set after setSite to override default functionality
                     // lookup branch
                     $branchNmlsId = $this->getCsvValue($data[12]);
                     if (!empty($branchNmlsId)) {
                         $branch = $this->em->getRepository('SudouxMortgageBundle:Branch')->findOneBySiteAndNmlsId($this->site, $branchNmlsId);
                         if (isset($branch)) {
                             $loanOfficer->setBranch($branch);
                         }
                     }
                     $this->em->persist($loanOfficer);
                     if ($row % $batchCount == 0) {
                         $this->em->flush();
                         $this->em->clear();
                         $this->site = $this->em->getRepository('SudouxCmsSiteBundle:Site')->find($siteId);
                         $this->output->writeln(sprintf('%s rows processed', $row));
                     }
                 }
                 $row++;
             }
             exit;
             $this->em->flush();
             $this->em->clear();
             $this->output->writeln(sprintf('Processing complete! %s rows processed', $row));
         }
     }
 }