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