public function uploadProcessAction(Request $request)
{
/* @var $uploadedFile \Symfony\Component\HttpFoundation\File\UploadedFile */
$uploadedFile = $request->files->get('upfile');
$inputFileName = $uploadedFile->getPathname();
$inputFileType = \PHPExcel_IOFactory::identify($inputFileName);
$objReader = \PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($inputFileName);
$objWorksheet = $objPHPExcel->getActiveSheet();
$enableCardCreation = $request->request->has('create');
// analysis of first row
$colNames = [];
$cards = [];
$firstRow = true;
foreach ($objWorksheet->getRowIterator() as $row) {
// dismiss first row (titles)
if ($firstRow) {
$firstRow = false;
// analysis of first row
foreach ($row->getCellIterator() as $cell) {
$colNames[$cell->getColumn()] = $cell->getValue();
}
continue;
}
$card = [];
$cellIterator = $row->getCellIterator();
foreach ($cellIterator as $cell) {
$col = $cell->getColumn();
$colName = $colNames[$col];
//$setter = str_replace(' ', '', ucwords(str_replace('_', ' ', "set_$fieldName")));
$card[$colName] = $cell->getValue();
}
if (count($card) && !empty($card['code'])) {
$cards[] = $card;
}
}
/* @var $em \Doctrine\ORM\EntityManager */
$em = $this->get('doctrine')->getManager();
$repo = $em->getRepository('AppBundle:Card');
$metaData = $em->getClassMetadata('AppBundle:Card');
$fieldNames = $metaData->getFieldNames();
$associationMappings = $metaData->getAssociationMappings();
$counter = 0;
foreach ($cards as $card) {
/* @var $entity \AppBundle\Entity\Card */
$entity = $repo->findOneBy(array('code' => $card['code']));
if (!$entity) {
if ($enableCardCreation) {
$entity = new Card();
$now = new \DateTime();
$entity->setDateCreation($now);
$entity->setDateUpdate($now);
} else {
continue;
}
}
$changed = FALSE;
$output = ["<h4>" . $card['name'] . "</h4>"];
foreach ($card as $colName => $value) {
$getter = str_replace(' ', '', ucwords(str_replace('_', ' ', "get_{$colName}")));
$setter = str_replace(' ', '', ucwords(str_replace('_', ' ', "set_{$colName}")));
if (key_exists($colName, $associationMappings)) {
$associationMapping = $associationMappings[$colName];
$associationRepository = $em->getRepository($associationMapping['targetEntity']);
$associationEntity = $associationRepository->findOneBy(['name' => $value]);
if (!$associationEntity) {
throw new \Exception("cannot find entity [{$colName}] of name [{$value}]");
}
if (!$entity->{$getter}() || $entity->{$getter}()->getId() !== $associationEntity->getId()) {
$changed = TRUE;
$output[] = "<p>association [{$colName}] changed</p>";
$entity->{$setter}($associationEntity);
}
} else {
if (in_array($colName, $fieldNames)) {
$type = $metaData->getTypeOfField($colName);
if ($type === 'boolean') {
$value = (bool) $value;
}
if ($entity->{$getter}() != $value || $entity->{$getter}() === NULL && $entity->{$getter}() !== $value) {
$changed = TRUE;
$output[] = "<p>field [{$colName}] changed</p>";
$entity->{$setter}($value);
}
}
}
}
if ($changed) {
$em->persist($entity);
$counter++;
echo join("", $output);
}
}
$em->flush();
return new Response($counter . " cards changed or added");
}