public function testRightColumnsHeadersNamesAfterItemConverter()
{
$data = array(array('first' => 'John', 'lastname' => 'Doe'), array('first' => 'Ivan', 'lastname' => 'Sidorov'));
$reader = new ArrayReader($data);
$converter = new MappingItemConverter();
$converter->addMapping('first', 'firstname');
$output = new BufferedOutput();
$table = new Table($output);
$table->setStyle('compact');
$workflow = new Workflow($reader);
$workflow->addItemConverter($converter)->addWriter(new ConsoleTableWriter($output, $table))->process();
$this->assertRegExp('/\\s+lastname\\s+firstname\\s+Doe\\s+John\\s+Sidorov\\s+Ivan\\s+/', $output->fetch());
}
public function testMultipleMappingsForAnItemAfterAnotherItemConverterwasAdded()
{
$originalData = array(array('foo' => 'bar', 'baz' => 'value'));
$ouputTestData = array();
$writer = new ArrayWriter($ouputTestData);
$reader = new ArrayReader($originalData);
$workflow = new Workflow($reader);
// add a dummy item converter
$workflow->addItemConverter(new CallbackItemConverter(function ($item) {
return $item;
}));
// add multiple mappings
$workflow->addMapping('foo', 'bar')->addMapping('baz', 'bazzoo')->addWriter($writer)->process();
$this->assertArrayHasKey('bar', $ouputTestData[0]);
$this->assertArrayHasKey('bazzoo', $ouputTestData[0]);
}
public function createAction(Request $request = null)
{
// the key used to lookup the template
$templateKey = 'edit';
if (false === $this->admin->isGranted('CREATE')) {
throw new AccessDeniedException();
}
$object = $this->admin->getNewInstance();
$this->admin->setSubject($object);
/** @var $form \Symfony\Component\Form\Form */
$form = $this->admin->getForm();
$form->setData($object);
if ($this->getRestMethod() == 'POST') {
$form->submit($this->get('request'));
$isFormValid = $form->isValid();
// persist if the form was valid and if in preview mode the preview was approved
if ($isFormValid && (!$this->isInPreviewMode() || $this->isPreviewApproved())) {
if (false === $this->admin->isGranted('CREATE', $object)) {
throw new AccessDeniedException();
}
try {
$dummyImport = getcwd() . "/dummyImport";
$fname = "directly.csv";
$filename = $dummyImport . "/" . $fname;
@mkdir($dummyImport);
@unlink($filename);
// move file to dummy filename
$form['file']->getData()->move($dummyImport, $fname);
// Create and configure the reader
$file = new \SplFileObject('dummyImport/directly.csv', "r");
// $file->setFlags(SplFileObject::READ_CSV);
$csvReader = new CsvReader($file, ";");
$csvReader->setHeaderRowNumber(0);
// Create the workflow from the reader
$workflow = new Workflow($csvReader);
// Create a writer: you need Doctrine’s EntityManager.
$em = $this->getDoctrine()->getManager();
$doctrineWriter = new DoctrineWriter($em, 'SuppliercheckAdminBundle:Import');
$workflow->addWriter($doctrineWriter);
$converter = new MappingItemConverter();
$converter->addMapping('id_catalog_simple', 'idCatalogSimple')->addMapping('created_at_external', 'createdAtExternal')->addMapping('updated_at_external', 'updatedAtExternal')->addMapping('created_at', 'createdAt')->addMapping('updated_at', 'updatedAt')->addMapping('special_price', 'specialPrice')->addMapping('special_from_date', 'specialFromDate')->addMapping('special_to_date', 'specialToDate')->addMapping('tax_class', 'taxClass')->addMapping('tax_class_2', 'taxClass2')->addMapping('original_price', 'originalPrice')->addMapping('base_price', 'basePrice')->addMapping('barcode_ean', 'barcodeEan')->addMapping('sku_supplier_simple', 'skuSupplierSimple')->addMapping('supplier_simple_name', 'supplierSimpleName')->addMapping('shipment_type', 'shipmentType')->addMapping('transport_type', 'transportType')->addMapping('is_global', 'isGlobal')->addMapping('shipment_cost', 'shipmentCost')->addMapping('shipment_cost_comment', 'shipmentCostComment')->addMapping('dreamroom_show_in_image_map', 'dreamroomShowInImageMap')->addMapping('dreamroom_image_map_x', 'dreamroomImageMapX')->addMapping('dreamroom_image_map_y', 'dreamroomImageMapY')->addMapping('xcart_sku', 'xcartSku')->addMapping('delivery_date_start', 'deliveryDateStart')->addMapping('delivery_date_end', 'deliveryDateEnd')->addMapping('docdata_ean', 'docdataEan')->addMapping('docdata_description', 'docdataDescription')->addMapping('docdata_weight', 'docdataWeight')->addMapping('custom_identifier', 'customIdentifier')->addMapping('expected_delivery_date_start', 'expectedDeliveryDateStart')->addMapping('expected_delivery_date_end', 'expectedDeliveryDateEnd')->addMapping('navision_flag', 'navisionFlag')->addMapping('delivery_day_min', 'deliveryDayMin')->addMapping('delivery_day_max', 'deliveryDayMax')->addMapping('additional_inbound_info', 'additionalInboundInfo')->addMapping('expected_gm1', 'expectedGm1')->addMapping('expected_gm2', 'expectedGm2')->addMapping('expected_gm3', 'expectedGm3')->addMapping('sum_gross_weight', 'sumGrossWeight')->addMapping('number_separate_packages', 'numberSeparatePackages')->addMapping('delay_reasons', 'delayReasons')->addMapping('hide_original_price', 'hideOriginalPrice')->addMapping('producer_name', 'producerName')->addMapping('producer_address', 'producerAddress')->addMapping('additional_2mh_service', 'additional2mhService')->addMapping('additional_2mh_service_price', 'additional2mhServicePrice')->addMapping('is_bundle', 'isBundle')->addMapping('id_catalog_config_westwing', 'idCatalogConfigWestwing')->addMapping('design_scout', 'designScout')->addMapping('logistic_lead', 'logisticLead')->addMapping('id_catalog_simple_westwing', 'idCatalogSimpleWestwing')->addMapping('supplier_identifier', 'supplierIdentifier')->addMapping('config_group', 'configGroup')->addMapping('attribute_set', 'attributeSet')->addMapping('id_catalog_config', 'idCatalogConfig')->addMapping('sku_config', 'skuConfig')->addMapping('status_config', 'statusConfig')->addMapping('name_other', 'nameOther')->addMapping('editor_opinion', 'editorOpinion')->addMapping('choice_of_description', 'choiceOfDescription')->addMapping('display_as_out_of_stock', 'displayAsOutOfStock')->addMapping('pet_status', 'petStatus')->addMapping('pet_approved', 'petApproved')->addMapping('activated_at', 'activatedAt')->addMapping('sku_supplier_config', 'skuSupplierConfig')->addMapping('name_supplier', 'nameSupplier')->addMapping('delivery_period', 'deliveryPeriod')->addMapping('main_material', 'mainMaterial')->addMapping('package_height', 'packageHeight')->addMapping('package_length', 'packageLength')->addMapping('package_width', 'packageWidth')->addMapping('package_weight', 'packageWeight')->addMapping('short_description', 'shortDescription')->addMapping('care_label', 'careLabel')->addMapping('next_simple_nr', 'nextSimpleNr')->addMapping('brand_name_for_theme_campaigns', 'brandNameForThemeCampaigns')->addMapping('advent_day', 'adventDay')->addMapping('advent_url', 'adventUrl')->addMapping('advent_path', 'adventPath')->addMapping('overwrite_delivery_period', 'overwriteDeliveryPeriod')->addMapping('is_seo_relevant', 'isSeoRelevant')->addMapping('export_static', 'exportStatic')->addMapping('is_hybris_product', 'isHybrisProduct')->addMapping('has_delivery_guarantee', 'hasDeliveryGuarantee')->addMapping('net_purchase_price', 'netPurchasePrice')->addMapping('net_purchase_price_discounted', 'netPurchasePriceDiscounted')->addMapping('supplier_product_number', 'supplierProductNumber')->addMapping('supplier_product_name', 'supplierProductName')->addMapping('local_stock', 'localStock')->addMapping('global_stock', 'globalStock')->addMapping('package1_length', 'package1Length')->addMapping('package1_height', 'package1Height')->addMapping('package1_width', 'package1Width')->addMapping('package1_weight', 'package1Weight')->addMapping('package2_length', 'package2Length')->addMapping('package2_height', 'package2Height')->addMapping('package2_width', 'package2Width')->addMapping('package2_weight', 'package2Weight')->addMapping('package3_length', 'package3Length')->addMapping('package3_height', 'package3Height')->addMapping('package3_width', 'package3Width')->addMapping('package3_weight', 'package3Weight')->addMapping('color_1', 'color1')->addMapping('color_2', 'color2')->addMapping('color_3', 'color3')->addMapping('color_characteristic', 'colorCharacteristic')->addMapping('additional_campaigns', 'additionalCampaigns')->addMapping('status_simple', 'statusSimple')->addMapping('expected_logistics_cost', 'expectedLogisticsCost')->addMapping('discount_level', 'discountLevel')->addMapping('blowout_round', 'blowoutRound')->addMapping('allow_multiple_po', 'allowMultiplePo');
$workflow->addItemConverter($converter)->process();
//fin de l'import dans la table virtuelle IMPORT
//copie des données avec mise en place des relations One TO Many
$em1 = $this->getDoctrine()->getManager();
$getData = new ArrayCollection();
$getData = $em1->getRepository('SuppliercheckAdminBundle:Import');
$listData = $getData->findAll();
foreach ($listData as $value) {
$newProduct = new Product();
$newProduct->setCampaign($object);
$newProduct->createFromImport($value);
$sku = $newProduct->getSku();
$newProduct->setLink($sku);
$newProduct->setValidated(false);
$newProduct->setComments(null);
$object->getProducts()->add($newProduct);
$newProduct = $value;
}
// $object1 = $this->admin->create($object);
// $id = $this->admin->getNormalizedIdentifier($object);
// $o = $object1->getId();
// $idencode = md5($o);
// $object1->setUrlencode($idencode);
// $this->admin->create($object);
$object = $this->admin->create($object);
$id = $object->getId();
$idencode = md5($id);
$object->setUrlencode($idencode);
$this->admin->create($object);
if ($this->isXmlHttpRequest()) {
return $this->renderJson(array('result' => 'ok', 'objectId' => $this->admin->getNormalizedIdentifier($object)));
}
$this->addFlash('sonata_flash_success', $this->admin->trans('flash_create_success', array('%name%' => $this->escapeHtml($this->admin->toString($object))), 'SonataAdminBundle'));
// redirect to edit mode
return $this->redirectTo($object);
} catch (ModelManagerException $e) {
$this->logModelManagerException($e);
$isFormValid = false;
}
}
// show an error message if the form failed validation
if (!$isFormValid) {
if (!$this->isXmlHttpRequest()) {
$this->addFlash('sonata_flash_error', $this->admin->trans('flash_create_error', array('%name%' => $this->escapeHtml($this->admin->toString($object))), 'SonataAdminBundle'));
}
} elseif ($this->isPreviewRequested()) {
// pick the preview template if the form was valid and preview was requested
$templateKey = 'preview';
$this->admin->getShow();
}
}
$view = $form->createView();
// set the theme for the current Admin Form
$this->get('twig')->getExtension('form')->renderer->setTheme($view, $this->admin->getFormTheme());
return $this->render($this->admin->getTemplate($templateKey), array('action' => 'create', 'form' => $view, 'object' => $object));
}
/**
* Generate a CSV file
*
* @Route("/detalhado/csv", name="printer_csv_detalhado")
*
*/
public function csvDetalhadoAction(Request $request)
{
ini_set('memory_limit', '1024M');
gc_enable();
$em = $this->getDoctrine()->getManager();
$form = $request->query->get('form');
if ($form) {
$start = new \DateTime($form['startDate']);
$start = $start->format('U');
$end = new \DateTime($form['endDate']);
$end->setTime('23', '59', '59');
$end = $end->format('U');
$this->get('logger')->debug("Relatório CSV Detalhado. Início = " . $form['startDate'] . " Fim = " . $form['endDate']);
}
$start = isset($start) ? $start : time() - 60 * 60 * 24 * 30;
$end = isset($end) ? $end : time();
$printers = $em->getRepository('CocarBundle:PrinterCounter')->relatorioCsvGeralDetalhado($start, $end);
// Gera cabeçalho
$cabecalho = array();
foreach ($printers as $elm) {
array_push($cabecalho, array_keys($elm));
break;
}
// Adiciona contagem no cabeçalho
array_push($cabecalho[0], 'totalPrints');
// Gera CSV
$reader = new ArrayReader(array_merge($cabecalho, $printers));
// Gera CSV
//$reader = new ArrayReader($printers);
// Create the workflow from the reader
$workflow = new Workflow($reader);
// Contador geral das impressorasa
$converter = new CallbackItemConverter(function ($item) {
if (array_key_exists('printsEnd', $item) && array_key_exists('printsStart', $item)) {
$item['totalPrints'] = $item['printsEnd'] - $item['printsStart'];
} else {
$item['totalPrints'] = null;
}
return $item;
});
$workflow->addItemConverter($converter);
// As you can see, the first names are not capitalized correctly. Let's fix
// that with a value converter:
$converter = new CallbackValueConverter(function ($input) {
return date('d/m/Y', $input);
});
$workflow->addValueConverter('endDate', $converter);
$workflow->addValueConverter('startDate', $converter);
// Add the writer to the workflow
$tmpfile = tempnam(sys_get_temp_dir(), 'impressoras');
$file = new \SplFileObject($tmpfile, 'w');
$writer = new CsvWriter($file);
$workflow->addWriter($writer);
// Process the workflow
$workflow->process();
// Retorna o arquivo
$response = new BinaryFileResponse($tmpfile);
$response->headers->set('Content-Type', 'text/csv');
$response->headers->set('Content-Disposition', 'attachment; filename="impressoras.csv"');
$response->headers->set('Content-Transfer-Encoding', 'binary');
return $response;
}
/**
* @return \Ddeboer\DataImport\Result
* @throws \Ddeboer\DataImport\Exception\ExceptionInterface
* @throws \Exception
*/
public function processData()
{
$workflow = new Workflow($this->reader);
$output = new ConsoleOutput();
// Don’t import the non-metadata
$filter = new Filter\CallbackFilter(function ($row) {
if (is_numeric($row['reg_id'])) {
return true;
}
if ( ! trim($row['reg_id'])) {
foreach ($row as $item) {
if ( ! is_array($item)) {
if (trim($item)) {
return true;
}
} else {
foreach ($item as $foo) {
if (trim($foo)) {
return true;
}
}
}
}
}
return false;
});
$trimConverter = new CallbackItemConverter(function ($row) {
foreach ($row as $key => $value) {
$row[$key] = trim($row[$key]);
}
return $row;
});
$lexicalConverter = new CallbackItemConverter(function ($row) {
foreach ($row as $key => $value) {
if (isset( $this->prolog['columns'][$key]['id'] ) and $this->prolog['columns'][$key]['id'] == 27) {
$lang = $this->prolog['columns'][$key]['lang'];
//check for existing language suffix
if ($value and ! preg_match("/\\." . $lang . "$/u", $value)) {
$row[$key] = $value . "." . $lang;
}
}
}
return $row;
});
$typeConverter = new MappingValueConverter([
'rdfs:class' => 'class',
'rdfs:property' => 'property',
'class' => 'class',
'property' => 'property',
'Class' => 'class',
'Property' => 'property',
'subclass' => 'class',
'subproperty' => 'property',
'' => '',
]);
$vocabWriter = new Writer\CallbackWriter(function ($row) {
$this->setPrologColumns();
//todo: $row[59] (status) and $row[62] (uri) sre hardcoded but the array key should be set somewhere globally
if ( ! isset( $row[59] )) {
$row[59] = $this->prolog['defaults']['statusId'];
}
$rowStatus = $row[59];
$language = $this->prolog['defaults']['lang'];
foreach ($row as $key => &$element) {
$this->updateRowUris($key, $element);
}
$uri = $this->getFqn($row[62]);
$property = null;
if ( ! empty( $row['reg_id'] )) {
$property = \ConceptPeer::retrieveByPK($row['reg_id']);
} else {
//check for an existing property by uri
/** @var \Concept $property */
$property = \ConceptPeer::getConceptByUri($uri);
}
//even if we found a property, we kill it if it's in a different schema than we're populating
if ($property and $property->getVocabularyId() !== $this->vocabId) {
//todo: we should log this event
unset( $property );
}
if (empty( $property )) { //it's a new property
$property = new \Concept();
$property->setVocabularyId($this->vocabId);
$property->setCreatedUserId($this->userId);
$property->setUpdatedUserId($this->userId);
$property->setStatusId($rowStatus);
$property->setLanguage($language);
$property->setUri($uri);
$property->save();
}
unset( $row['reg_id'] );
if ($property) {
// if (8 == $rowStatus) {
// //it's been deprecated and we don't do anything else
// $property->setStatusId($rowStatus);
// $this->updateElement($element, $dbElement, $property);
// } else {
$dbElements = $property->getElementsForImport($this->profileProperties);
foreach ($dbElements as $key => $dbElement) {
/** @var string | array $rowElement */
$rowElement = isset( $row[$key] ) ? $row[$key] : null;
if (is_array($rowElement)) {
foreach ($rowElement as $elementKey => &$element) {
if ($this->updateConceptProperty($element, $dbElement, $property)) {
unset( $rowElement[$elementKey] );
}
}
} else {
if ($this->updateConceptProperty($rowElement, $dbElement, $property)) {
unset( $row[$key] );
}
}
}
foreach ($row as $key => $value) {
$dbElement = isset( $dbElements[$key] ) ? $dbElements[$key] : null;
if ( ! empty( $this->prolog['columns'][$key]['property'] )) {
$profileProperty = $this->prolog['columns'][$key]['property'];
if (is_array($value)) {
foreach ($value as &$oneValue) {
$language = $this->prolog['columns'][$key]['lang'][0];
$this->upsertConceptFromRow($dbElement,
$oneValue,
$rowStatus,
$property,
$profileProperty,
$language,
$key);
}
} else {
$language = $this->prolog['columns'][$key]['lang'];
$this->upsertConceptFromRow($dbElement,
$value,
$rowStatus,
$property,
$profileProperty,
$language,
$key);
}
}
}
}
$property->setUri($uri);
$property->setStatusId($rowStatus);
$affectedRows = $property->save();
if (empty( $property->getPrefLabel() )) {
$prefLabel = \ConceptPropertyPeer::lookupProperty($property->getId(),
19,
$this->prolog['defaults']['lang']);
if ( ! empty( $prefLabel )) {
$property->setPrefLabel($prefLabel->getObject());
$property->setPrefLabelId($prefLabel->getId());
$property->setLanguage($this->prolog['defaults']['lang']);
$property->save();
}
}
return;
//**************
// CRUFT ALERT
// The rest of this is never run!!
//**************
//build an array of references
$newElements = [ ];
$newElements2 = [ ];
if ( ! isset( $row['status'] )) {
$row[14] = $this->prolog['defaults']['statusId'];
}
foreach ($row as $key => $element) {
//skip it there's no property id
$columnKey = $this->prolog['columns'][$key];
if ( ! $columnKey['id']) {
continue;
}
if ( ! empty( $columnKey['type'] ) and $this->useCuries) {
$element = $this->getFqn($element);
}
$key2 = md5(strval($columnKey['id']) . strval($columnKey['lang']) . $element);
$newElements[$key2] = [ ];
$newElements[$key2] += $columnKey;
$newElements[$key2]['val'] = $element;
/** @var \ProfileProperty $profileProperty */
if (isset( $columnKey['property'] )) {
$profileProperty = $columnKey['property'];
$var = [
'matchkey' => $key2,
'val' => $newElements[$key2],
];
if (isset( $profileProperty ) and $profileProperty->getHasLanguage()) {
$newElements2[$columnKey['id']][$columnKey['lang']][] = $var;
} else {
$newElements2[$columnKey['id']][] = $var;
}
}
}
if ( ! empty( $row['reg_id'] )) {
$property = \SchemaPropertyPeer::retrieveByPK($row['reg_id']);
if ($property) {
$dbElements = $property->getSchemaPropertyElementsRelatedBySchemaPropertyIdJoinProfileProperty();
$dbElements2 = [ ];
/** @var \SchemaPropertyElement $dbElement */
foreach ($dbElements as $dbElement) {
if ($dbElement->getProfileProperty()->getHasLanguage()) {
$dbElements2[$dbElement->getProfilePropertyId()][$dbElement->getLanguage()][] = &$dbElement;
} else {
$dbElements2[$dbElement->getProfilePropertyId()][] = &$dbElement;
}
}
/** @var \SchemaPropertyElement $element */
foreach ($dbElements as $element) {
$language = $element->getLanguage();
$profilePropertyId = $element->getProfilePropertyId();
$key = md5(strval($profilePropertyId) . strval($language) . $element->getObject());
//if the newelement key matches then
if (isset( $newElements[$key] )) {
if ($element->getProfileProperty()->getHasLanguage()) {
$newElements2Array = $newElements2[$profilePropertyId][$language];
} else {
$newElements2Array = $newElements2[$profilePropertyId];
}
$count = count($newElements2Array);
for ($I = 0; $I < $count; $I++) {
if ($newElements2Array[$I]['matchkey'] == $key) {
unset( $newElements2Array[$I] );
}
}
unset( $newElements[$key] );
$element->importStatus = 'match';
continue;
} else {
if ($element->getProfileProperty()->getHasLanguage()) {
if (isset( $newElements2[$profilePropertyId][$language] )) {
$count = count($newElements2[$profilePropertyId][$language]);
for ($I = 0; $I < $count; $I++) {
if ($newElements2[$profilePropertyId][$language][$I]['val']['val'] == $element->getObject()) {
unset( $newElements2[$profilePropertyId][$language][$I] );
$element->importStatus = 'match';
if ( ! count($newElements2[$profilePropertyId][$language])) {
unset( $newElements2[$profilePropertyId][$language] );
}
continue;
}
}
}
} else {
//compare the old values with the new with the same key
$count = count($newElements2[$profilePropertyId]);
for ($I = 0; $I < $count; $I++) {
if (isset( $newElements2[$profilePropertyId][$I] )) {
if ($newElements2[$profilePropertyId][$I]['val']['val'] == $element->getObject()) {
unset( $newElements2[$profilePropertyId][$I] );
$element->importStatus = 'match';
continue;
}
}
}
}
//if the key matches then
//if the value matches
//delete the newElement
//else the value doesn't match
//if the newElement value is empty
//delete the dbElement
}
$element->matchKey = $key;
}
//update the property values
$property->save();
} else {
//there's no existing property an we have to create a new one
$property = new \SchemaProperty();
}
foreach ($newElements as $key => $newElement) {
if ( ! empty( $newElement['id'] ) and ! isset( $oldElements[$key] )) {
$profileProperty = $newElement['property'];
//walk the old elements looking for a match on predicate + language
/** @var \SchemaPropertyElement[] $oldElement */
foreach ($dbElements as $oldElement) {
/** @var \SchemaPropertyElement $oldOne */
$oldOne = &$oldElement['element'];
if ($newElement['id'] == $oldOne->getProfilePropertyId()) {
/** @var \ProfileProperty $profileProperty */
if (( $profileProperty->getHasLanguage() and $newElement['lang'] == $oldOne->getLanguage() ) or ! $profileProperty->getHasLanguage()) {
if ( ! empty( $newElement['val'] )) {
$oldOne->setObject($newElement['val']);
$oldOne->setUpdatedUserId($this->userId);
$oldOne->setStatusId($row['status']);
//$oldOne->save();
$oldElement['status'] = "updated";
} else {
$oldOne->delete();
$oldElement['status'] = "deleted";
}
//update the property value
if ($profileProperty->getIsInForm()) {
$this->setPropertyValue($newElement['val'],
$property,
$profileProperty->getName(),
! $profileProperty->getIsObjectProp());
}
break;
}
}
}
//we looked through them all, add a new one
if ( ! empty( $newElement['val'] )) {
$addMe = new \SchemaPropertyElement();
$addMe->setObject($newElement['val']);
//$addMe->setSchemaPropertyRelatedBySchemaPropertyId($property);
$addMe->setCreatedUserId($this->userId);
$addMe->setUpdatedUserId($this->userId);
$addMe->setLanguage($newElement['lang']);
$addMe->setProfilePropertyId($newElement['id']);
$addMe->setStatusId($row['status']);
$addMe->importId = $this->importId;
//$addMe->save();
$property->addSchemaPropertyElementRelatedBySchemaPropertyId($addMe);
//update the property value
if ($profileProperty->getIsInForm()) {
$this->setPropertyValue($newElement['val'],
$property,
$profileProperty->getName(),
! $profileProperty->getIsObjectProp());
}
}
}
}
//update the property
if ($property) {
$property->setStatusId($row['status']);
$property->save();
}
}
//var_dump($row);
});
$schemaWriter = new Writer\CallbackWriter(function ($row) {
$this->setPrologColumns();
if ( ! isset( $row[14] )) {
$row[14] = $this->prolog['defaults']['statusId'];
}
$rowStatus = $row[14];
$language = $this->prolog['defaults']['lang'];
foreach ($row as $key => &$element) {
$this->updateRowUris($key, $element);
}
$uri = $row[13];
$property = null;
$schemaId = $this->vocabId;
if ( ! empty( $row['reg_id'] )) {
$property = \SchemaPropertyPeer::retrieveByPK($row['reg_id']);
} else {
//check for an existing property by uri
/** @var \SchemaProperty $property */
$property = \SchemaPropertyPeer::retrieveByUri($uri);
if ($property) {
$schemaId = $property->getSchemaId();
}
}
//even if we found a property, we kill it if it's in a different schema than we're populating
if ($property and $schemaId !== $this->vocabId) {
//todo: we should log this event
unset( $property );
}
if (empty( $property )) { //it's a new property
$property = new \SchemaProperty();
$property->setSchemaId($this->vocabId);
$property->setCreatedUserId($this->userId);
$property->setUpdatedUserId($this->userId);
$property->setStatusId($rowStatus);
$property->setLanguage($language);
$property->save();
}
unset( $row['reg_id'] );
if ($property) {
// if (8 == $rowStatus) {
// //it's been deprecated and we don't do anything else
// $property->setStatusId($rowStatus);
// $this->updateElement($element, $dbElement, $property);
// } else {
$dbElements = $property->getElementsForImport($this->profileProperties);
foreach ($dbElements as $key => $dbElement) {
/** @var string | array $rowElement */
$rowElement = isset( $row[$key] ) ? $row[$key] : null;
if (is_array($rowElement)) {
foreach ($rowElement as $elementKey => &$element) {
if ($this->updateElement($element, $dbElement, $property)) {
unset( $rowElement[$elementKey] );
}
}
} else {
if ($this->updateElement($rowElement, $dbElement, $property)) {
unset( $row[$key] );
}
}
}
foreach ($row as $key => $value) {
$dbElement = isset( $dbElements[$key] ) ? $dbElements[$key] : null;
if ( ! empty( $this->prolog['columns'][$key]['property'] )) {
$profileProperty = $this->prolog['columns'][$key]['property'];
if (is_array($value)) {
foreach ($value as &$oneValue) {
$language = $this->prolog['columns'][$key]['lang'][0];
$this->upsertElementFromRow($dbElement,
$oneValue,
$rowStatus,
$property,
$profileProperty,
$language,
$key);
}
} else {
$language = $this->prolog['columns'][$key]['lang'];
$this->upsertElementFromRow($dbElement,
$value,
$rowStatus,
$property,
$profileProperty,
$language,
$key);
}
if ($key == 'parent_class' and strtolower($property->getType()) == 'class' and $row[$key] != $property->getParentUri()) {
$property->setParentUri($row[$key]);
//we'll set this later
$property->setIsSubpropertyOf(null);
}
if ($key == 'parent_property' and strtolower($property->getType()) == 'property' and $row[$key] != $property->getParentUri()) {
$property->setParentUri($row[$key]);
//we'll set this later
$property->setIsSubpropertyOf(null);
}
}
}
}
$affectedRows = $property->save();
// }
return;
//build an array of references
$newElements = [ ];
$newElements2 = [ ];
if ( ! isset( $row['status'] )) {
$row[14] = $this->prolog['defaults']['statusId'];
}
foreach ($row as $key => $element) {
//skip it there's no property id
$columnKey = $this->prolog['columns'][$key];
if ( ! $columnKey['id']) {
continue;
}
if ( ! empty( $columnKey['type'] ) and $this->useCuries) {
$element = $this->getFqn($element);
}
$key2 = md5(strval($columnKey['id']) . strval($columnKey['lang']) . $element);
$newElements[$key2] = [ ];
$newElements[$key2] += $columnKey;
$newElements[$key2]['val'] = $element;
/** @var \ProfileProperty $profileProperty */
if (isset( $columnKey['property'] )) {
$profileProperty = $columnKey['property'];
$var = [
'matchkey' => $key2,
'val' => $newElements[$key2],
];
if (isset( $profileProperty ) and $profileProperty->getHasLanguage()) {
$newElements2[$columnKey['id']][$columnKey['lang']][] = $var;
} else {
$newElements2[$columnKey['id']][] = $var;
}
}
}
if ( ! empty( $row['reg_id'] )) {
$property = \SchemaPropertyPeer::retrieveByPK($row['reg_id']);
if ($property) {
$dbElements = $property->getSchemaPropertyElementsRelatedBySchemaPropertyIdJoinProfileProperty();
$dbElements2 = [ ];
/** @var \SchemaPropertyElement $dbElement */
foreach ($dbElements as $dbElement) {
if ($dbElement->getProfileProperty()->getHasLanguage()) {
$dbElements2[$dbElement->getProfilePropertyId()][$dbElement->getLanguage()][] = &$dbElement;
} else {
$dbElements2[$dbElement->getProfilePropertyId()][] = &$dbElement;
}
}
/** @var \SchemaPropertyElement $element */
foreach ($dbElements as $element) {
$language = $element->getLanguage();
$profilePropertyId = $element->getProfilePropertyId();
$key = md5(strval($profilePropertyId) . strval($language) . $element->getObject());
//if the newelement key matches then
if (isset( $newElements[$key] )) {
if ($element->getProfileProperty()->getHasLanguage()) {
$newElements2Array = $newElements2[$profilePropertyId][$language];
} else {
$newElements2Array = $newElements2[$profilePropertyId];
}
$count = count($newElements2Array);
for ($I = 0; $I < $count; $I++) {
if ($newElements2Array[$I]['matchkey'] == $key) {
unset( $newElements2Array[$I] );
}
}
unset( $newElements[$key] );
$element->importStatus = 'match';
continue;
} else {
if ($element->getProfileProperty()->getHasLanguage()) {
if (isset( $newElements2[$profilePropertyId][$language] )) {
$count = count($newElements2[$profilePropertyId][$language]);
for ($I = 0; $I < $count; $I++) {
if ($newElements2[$profilePropertyId][$language][$I]['val']['val'] == $element->getObject()) {
unset( $newElements2[$profilePropertyId][$language][$I] );
$element->importStatus = 'match';
if ( ! count($newElements2[$profilePropertyId][$language])) {
unset( $newElements2[$profilePropertyId][$language] );
}
continue;
}
}
}
} else {
//compare the old values with the new with the same key
$count = count($newElements2[$profilePropertyId]);
for ($I = 0; $I < $count; $I++) {
if (isset( $newElements2[$profilePropertyId][$I] )) {
if ($newElements2[$profilePropertyId][$I]['val']['val'] == $element->getObject()) {
unset( $newElements2[$profilePropertyId][$I] );
$element->importStatus = 'match';
continue;
}
}
}
}
//if the key matches then
//if the value matches
//delete the newElement
//else the value doesn't match
//if the newElement value is empty
//delete the dbElement
}
$element->matchKey = $key;
}
//update the property values
$property->save();
} else {
//there's no existing property an we have to create a new one
$property = new \SchemaProperty();
}
foreach ($newElements as $key => $newElement) {
if ( ! empty( $newElement['id'] ) and ! isset( $oldElements[$key] )) {
$profileProperty = $newElement['property'];
//walk the old elements looking for a match on predicate + language
/** @var \SchemaPropertyElement[] $oldElement */
foreach ($dbElements as $oldElement) {
/** @var \SchemaPropertyElement $oldOne */
$oldOne = &$oldElement['element'];
if ($newElement['id'] == $oldOne->getProfilePropertyId()) {
/** @var \ProfileProperty $profileProperty */
if (( $profileProperty->getHasLanguage() and $newElement['lang'] == $oldOne->getLanguage() ) or ! $profileProperty->getHasLanguage()) {
if ( ! empty( $newElement['val'] )) {
$oldOne->setObject($newElement['val']);
$oldOne->setUpdatedUserId($this->userId);
$oldOne->setStatusId($row['status']);
//$oldOne->save();
$oldElement['status'] = "updated";
} else {
$oldOne->delete();
$oldElement['status'] = "deleted";
}
//update the property value
if ($profileProperty->getIsInForm()) {
$this->setPropertyValue($newElement['val'],
$property,
$profileProperty->getName(),
! $profileProperty->getIsObjectProp());
}
break;
}
}
}
//we looked through them all, add a new one
if ( ! empty( $newElement['val'] )) {
$addMe = new \SchemaPropertyElement();
$addMe->setObject($newElement['val']);
//$addMe->setSchemaPropertyRelatedBySchemaPropertyId($property);
$addMe->setCreatedUserId($this->userId);
$addMe->setUpdatedUserId($this->userId);
$addMe->setLanguage($newElement['lang']);
$addMe->setProfilePropertyId($newElement['id']);
$addMe->setStatusId($row['status']);
$addMe->importId = $this->importId;
//$addMe->save();
$property->addSchemaPropertyElementRelatedBySchemaPropertyId($addMe);
//update the property value
if ($profileProperty->getIsInForm()) {
$this->setPropertyValue($newElement['val'],
$property,
$profileProperty->getName(),
! $profileProperty->getIsObjectProp());
}
}
}
}
//update the property
if ($property) {
$property->setStatusId($row['status']);
$property->save();
}
}
//var_dump($row);
});
$workflow->addItemConverter($this->mapping);
$workflow->addFilter($filter);
$workflow->addItemConverter($trimConverter);
$workflow->addItemConverter($lexicalConverter);
$workflow->addWriter(new Writer\ConsoleProgressWriter($output, $this->reader));
$workflow->addValueConverter("4", $typeConverter);
//add a database writer
if ('schema' == $this->type) {
$workflow->addWriter($schemaWriter);
} else {
$workflow->addWriter($vocabWriter);
}
/** @todo we need to make a second pass through to delete missing rows
* for each schemaproperty in the database
* match to a row in the csv
* if the row value is empty and $this->deleteMissing
* delete the entire schemaproperty
*/
$workResults = $workflow->process();
$this->DataWorkflowResults = $workResults;
/** @TODO need to make a second pass through to lookup and set $element->related_schema_property_id */
$this->processParents($this->vocabId);
//use the prolog to configure namespaces, look up correct resources in the database
//store the row number of the first non-meta line
return $workResults;
}
public function importFileAction(Request $request)
{
/*
* $import = new Import();
*
*
* $em2 = $this->getDoctrine()->getManager();
* $em2->persist($import);
* $em2->flush();
* $i = $import->getId();
* var_dump($i);
*/
// Get FileId to "import"
$param = $request->request;
$fileId = (int) trim($param->get("fileId"));
$curType = trim($param->get("fileType"));
$uploadedFile = $request->files->get("csvFile");
// if upload was not ok, just redirect to "AdminStatWrongPArameters"
if (!CSVTypes::existsType($curType) || $uploadedFile == null) {
return 0;
}
// generate dummy dir
$dummyImport = getcwd() . "/dummyImport";
$fname = "directly.csv";
$filename = $dummyImport . "/" . $fname;
@mkdir($dummyImport);
@unlink($filename);
// move file to dummy filename
$uploadedFile->move($dummyImport, $fname);
// Create and configure the reader
$file = new \SplFileObject('dummyImport/directly.csv', "r");
// $file->setFlags(SplFileObject::READ_CSV);
$csvReader = new CsvReader($file, ";");
// var_dump($csvReader);
// Tell the reader that the first row in the CSV file contains column headers
$csvReader->setHeaderRowNumber(0);
// foreach ($csvReader as $row => $value) {
// $value['sku'] = '1' ;
// }
// Create the workflow from the reader
$workflow = new Workflow($csvReader);
// Create a writer: you need Doctrine’s EntityManager.
$em = $this->getDoctrine()->getManager();
$doctrineWriter = new DoctrineWriter($em, 'SuppliercheckAdminBundle:Data');
// $doctrineWriter->writeItem(array ('import', 'test'));
/*
* $em = $this->getDoctrine()->getManager();
* $query = $em->createQuery(
* 'SELECT p
* FROM AcmeStoreBundle:Product p
* WHERE p.price > :price
* ORDER BY p.price ASC'
* )->setParameter('price', '19.99');
*
* $products = $query->getResult();
*/
// $doctrineWriter->setTruncate(false);
/*
* $doctrineWriter
* ->prepare()
* ->writeItem(
* array(
* 'voila' => $i,
*
* )
* );
*/
// $doctrineWriter->setTruncate(false);
$workflow->addWriter($doctrineWriter);
// $em3=$this->getDoctrine()->getManager();
// $doctrineR = new DoctrineReader($em3, 'AdminAdminBundle:Data');
// $fields =$doctrineR->getFields();
// $workflow2 = new Workflow($doctrineR);
// $entityMetadata=$em->getClassMetadata('AdminAdminBundle:Product');
// $entityMetadata->setIdGeneratorType(\Doctrine\ORM\Mapping\ClassMetadata::GENERATOR_TYPE_AUTO);
// $converter = new StringToDateTimeValueConverter();
$converter = new MappingItemConverter();
$converter->addMapping('id_catalog_simple', 'idCatalogSimple')->addMapping('created_at_external', 'createdAtExternal')->addMapping('updated_at_external', 'updatedAtExternal')->addMapping('created_at', 'createdAt')->addMapping('updated_at', 'updatedAt')->addMapping('special_price', 'specialPrice')->addMapping('special_from_date', 'specialFromDate')->addMapping('special_to_date', 'specialToDate')->addMapping('tax_class', 'taxClass')->addMapping('tax_class_2', 'taxClass2')->addMapping('original_price', 'originalPrice')->addMapping('base_price', 'basePrice')->addMapping('barcode_ean', 'barcodeEan')->addMapping('sku_supplier_simple', 'skuSupplierSimple')->addMapping('supplier_simple_name', 'supplierSimpleName')->addMapping('shipment_type', 'shipmentType')->addMapping('transport_type', 'transportType')->addMapping('is_global', 'isGlobal')->addMapping('shipment_cost', 'shipmentCost')->addMapping('shipment_cost_comment', 'shipmentCostComment')->addMapping('dreamroom_show_in_image_map', 'dreamroomShowInImageMap')->addMapping('dreamroom_image_map_x', 'dreamroomImageMapX')->addMapping('dreamroom_image_map_y', 'dreamroomImageMapY')->addMapping('xcart_sku', 'xcartSku')->addMapping('delivery_date_start', 'deliveryDateStart')->addMapping('delivery_date_end', 'deliveryDateEnd')->addMapping('docdata_ean', 'docdataEan')->addMapping('docdata_description', 'docdataDescription')->addMapping('docdata_weight', 'docdataWeight')->addMapping('custom_identifier', 'customIdentifier')->addMapping('expected_delivery_date_start', 'expectedDeliveryDateStart')->addMapping('expected_delivery_date_end', 'expectedDeliveryDateEnd')->addMapping('navision_flag', 'navisionFlag')->addMapping('delivery_day_min', 'deliveryDayMin')->addMapping('delivery_day_max', 'deliveryDayMax')->addMapping('additional_inbound_info', 'additionalInboundInfo')->addMapping('expected_gm1', 'expectedGm1')->addMapping('expected_gm2', 'expectedGm2')->addMapping('expected_gm3', 'expectedGm3')->addMapping('sum_gross_weight', 'sumGrossWeight')->addMapping('number_separate_packages', 'numberSeparatePackages')->addMapping('delay_reasons', 'delayReasons')->addMapping('hide_original_price', 'hideOriginalPrice')->addMapping('producer_name', 'producerName')->addMapping('producer_address', 'producerAddress')->addMapping('additional_2mh_service', 'additional2mhService')->addMapping('additional_2mh_service_price', 'additional2mhServicePrice')->addMapping('is_bundle', 'isBundle')->addMapping('id_catalog_config_westwing', 'idCatalogConfigWestwing')->addMapping('design_scout', 'designScout')->addMapping('logistic_lead', 'logisticLead')->addMapping('id_catalog_simple_westwing', 'idCatalogSimpleWestwing')->addMapping('supplier_identifier', 'supplierIdentifier')->addMapping('config_group', 'configGroup')->addMapping('attribute_set', 'attributeSet')->addMapping('id_catalog_config', 'idCatalogConfig')->addMapping('sku_config', 'skuConfig')->addMapping('status_config', 'statusConfig')->addMapping('name_other', 'nameOther')->addMapping('editor_opinion', 'editorOpinion')->addMapping('choice_of_description', 'choiceOfDescription')->addMapping('display_as_out_of_stock', 'displayAsOutOfStock')->addMapping('pet_status', 'petStatus')->addMapping('pet_approved', 'petApproved')->addMapping('activated_at', 'activatedAt')->addMapping('sku_supplier_config', 'skuSupplierConfig')->addMapping('name_supplier', 'nameSupplier')->addMapping('delivery_period', 'deliveryPeriod')->addMapping('main_material', 'mainMaterial')->addMapping('package_height', 'packageHeight')->addMapping('package_length', 'packageLength')->addMapping('package_width', 'packageWidth')->addMapping('package_weight', 'packageWeight')->addMapping('short_description', 'shortDescription')->addMapping('care_label', 'careLabel')->addMapping('next_simple_nr', 'nextSimpleNr')->addMapping('brand_name_for_theme_campaigns', 'brandNameForThemeCampaigns')->addMapping('advent_day', 'adventDay')->addMapping('advent_url', 'adventUrl')->addMapping('advent_path', 'adventPath')->addMapping('overwrite_delivery_period', 'overwriteDeliveryPeriod')->addMapping('is_seo_relevant', 'isSeoRelevant')->addMapping('export_static', 'exportStatic')->addMapping('is_hybris_product', 'isHybrisProduct')->addMapping('has_delivery_guarantee', 'hasDeliveryGuarantee')->addMapping('net_purchase_price', 'netPurchasePrice')->addMapping('net_purchase_price_discounted', 'netPurchasePriceDiscounted')->addMapping('supplier_product_number', 'supplierProductNumber')->addMapping('supplier_product_name', 'supplierProductName')->addMapping('local_stock', 'localStock')->addMapping('global_stock', 'globalStock')->addMapping('package1_length', 'package1Length')->addMapping('package1_height', 'package1Height')->addMapping('package1_width', 'package1Width')->addMapping('package1_weight', 'package1Weight')->addMapping('package2_length', 'package2Length')->addMapping('package2_height', 'package2Height')->addMapping('package2_width', 'package2Width')->addMapping('package2_weight', 'package2Weight')->addMapping('package3_length', 'package3Length')->addMapping('package3_height', 'package3Height')->addMapping('package3_width', 'package3Width')->addMapping('package3_weight', 'package3Weight')->addMapping('color_1', 'color1')->addMapping('color_2', 'color2')->addMapping('color_3', 'color3')->addMapping('color_characteristic', 'colorCharacteristic')->addMapping('additional_campaigns', 'additionalCampaigns')->addMapping('status_simple', 'statusSimple')->addMapping('expected_logistics_cost', 'expectedLogisticsCost')->addMapping('discount_level', 'discountLevel')->addMapping('blowout_round', 'blowoutRound')->addMapping('allow_multiple_po', 'allowMultiplePo');
// Process the workflow
// $workflow->addValueConverter('import', $i);
$workflow->addItemConverter($converter)->process();
//$workflow2->process();
/*
$doctrineWriterId = new DoctrineWriter($em3, 'AdminAdminBundle:Data');
$doctrineWriterId
->prepare()
->writeItem(
array(
'importId' => '$i',
)
)
->finish();*/
//$reader =$doctrineWriterId = new DoctrineWriter($em3, 'AdminAdminBundle:Data');
/* $em3=$this->getDoctrine()->getManager();
$doctrineWriterId = new DoctrineWriter($em3, 'AdminAdminBundle:Data');
$doctrineWriterId
->prepare()
->writeItem(
array(
'importId' => '$i',
)
)
->finish();
$workflow2 = new Workflow($doctrineWriterId);
$workflow2->process();
//var_dump($workflow);
//$b = new csv() ;
$em2 = $this->getDoctrine()->getManager();
$em3 = $this->getDoctrine()->getManager();
//$em2->persist($import);
//$em2->flush();
//$i = $import->getId();
$A = $em2->getRepository('AdminAdminBundle:Data');
//$B = new csv() ;
$B = clone $A;
//$B->setId(null);
//$B = new csv() ;
//$B->setIdCatalogConfig('11');
//$em3->persist($B);
$em3->flush();
$em2->flush();
var_dump($B);
*/
return $this->render('SuppliercheckAdminBundle:Default:csv_import.html.twig');
}
public function apply(Workflow $workflow, ConverterProviderInterface $converterProvider)
{
$fieldMapping = array();
foreach ($this as $mapping) {
$to = null;
$from = null;
$converter = null;
if ($mapping instanceof Mapping) {
$to = $mapping->to;
$from = $mapping->from;
$converter = $mapping->converter;
} else {
$converter = $mapping;
}
if (!empty($to) && !empty($from)) {
$fieldMapping[$from] = $to;
}
if ($converter) {
if (is_string($converter)) {
if (!$converterProvider->has($converter)) {
throw new InvalidConfigurationException("Converter with id '{$converter}' not found in configured converters.");
}
$converter = $converterProvider->get($converter);
}
if ($converter instanceof ValueConverterInterface) {
$targetField = empty($to) ? $from : $to;
if (empty($targetField)) {
throw new InvalidConfigurationException('Cannot use ValueConverter ' . get_class($converter) . ' without target-field.');
}
$workflow->addValueConverter($targetField, $converter);
} elseif ($converter instanceof ItemConverterInterface) {
$workflow->addItemConverter($converter);
} else {
throw new \LogicException('Invalid converter supplied: ' . get_class($converter));
}
}
}
if (!empty($fieldMapping)) {
$workflow->addItemConverter(new MappingItemConverter($fieldMapping));
}
}
/**
* Creates a new Campaign entity.
*
*/
public function createAction(Request $request)
{
$entity = new Campaign();
// $product = new \Suppliercheck\SupplierBundle\Entity\Product();
// $product->setName('tag1');
// $product->setCampaignId(1);
// $entity->getProducts()->add($product);
// $em1 = $this->getDoctrine()->getManager();
// $em1->persist($product);
// $em1->flush();
// Original create form
// $form = $this->createCreateForm($entity);
$request = $this->getRequest();
$form = $this->createCreateForm($entity);
// $form->handleRequest($request);
if ($request->isMethod('POST')) {
$form->handleRequest($request);
if ($form->isValid()) {
// $form['file']->getData()->move($dir, $someNewFilename);
$dummyImport = getcwd() . "/dummyImport";
$fname = "directly.csv";
$filename = $dummyImport . "/" . $fname;
@mkdir($dummyImport);
@unlink($filename);
// move file to dummy filename
$form['file']->getData()->move($dummyImport, $fname);
// Create and configure the reader
$file = new \SplFileObject('dummyImport/directly.csv', "r");
// $file->setFlags(SplFileObject::READ_CSV);
$csvReader = new CsvReader($file, ";");
$csvReader->setHeaderRowNumber(0);
// Create the workflow from the reader
$workflow = new Workflow($csvReader);
// Create a writer: you need Doctrine’s EntityManager.
$em = $this->getDoctrine()->getManager();
$doctrineWriter = new DoctrineWriter($em, 'SuppliercheckSupplierBundle:Import');
$workflow->addWriter($doctrineWriter);
$converter = new MappingItemConverter();
$converter->addMapping('id_catalog_simple', 'idCatalogSimple')->addMapping('created_at_external', 'createdAtExternal')->addMapping('updated_at_external', 'updatedAtExternal')->addMapping('created_at', 'createdAt')->addMapping('updated_at', 'updatedAt')->addMapping('special_price', 'specialPrice')->addMapping('special_from_date', 'specialFromDate')->addMapping('special_to_date', 'specialToDate')->addMapping('tax_class', 'taxClass')->addMapping('tax_class_2', 'taxClass2')->addMapping('original_price', 'originalPrice')->addMapping('base_price', 'basePrice')->addMapping('barcode_ean', 'barcodeEan')->addMapping('sku_supplier_simple', 'skuSupplierSimple')->addMapping('supplier_simple_name', 'supplierSimpleName')->addMapping('shipment_type', 'shipmentType')->addMapping('transport_type', 'transportType')->addMapping('is_global', 'isGlobal')->addMapping('shipment_cost', 'shipmentCost')->addMapping('shipment_cost_comment', 'shipmentCostComment')->addMapping('dreamroom_show_in_image_map', 'dreamroomShowInImageMap')->addMapping('dreamroom_image_map_x', 'dreamroomImageMapX')->addMapping('dreamroom_image_map_y', 'dreamroomImageMapY')->addMapping('xcart_sku', 'xcartSku')->addMapping('delivery_date_start', 'deliveryDateStart')->addMapping('delivery_date_end', 'deliveryDateEnd')->addMapping('docdata_ean', 'docdataEan')->addMapping('docdata_description', 'docdataDescription')->addMapping('docdata_weight', 'docdataWeight')->addMapping('custom_identifier', 'customIdentifier')->addMapping('expected_delivery_date_start', 'expectedDeliveryDateStart')->addMapping('expected_delivery_date_end', 'expectedDeliveryDateEnd')->addMapping('navision_flag', 'navisionFlag')->addMapping('delivery_day_min', 'deliveryDayMin')->addMapping('delivery_day_max', 'deliveryDayMax')->addMapping('additional_inbound_info', 'additionalInboundInfo')->addMapping('expected_gm1', 'expectedGm1')->addMapping('expected_gm2', 'expectedGm2')->addMapping('expected_gm3', 'expectedGm3')->addMapping('sum_gross_weight', 'sumGrossWeight')->addMapping('number_separate_packages', 'numberSeparatePackages')->addMapping('delay_reasons', 'delayReasons')->addMapping('hide_original_price', 'hideOriginalPrice')->addMapping('producer_name', 'producerName')->addMapping('producer_address', 'producerAddress')->addMapping('additional_2mh_service', 'additional2mhService')->addMapping('additional_2mh_service_price', 'additional2mhServicePrice')->addMapping('is_bundle', 'isBundle')->addMapping('id_catalog_config_westwing', 'idCatalogConfigWestwing')->addMapping('design_scout', 'designScout')->addMapping('logistic_lead', 'logisticLead')->addMapping('id_catalog_simple_westwing', 'idCatalogSimpleWestwing')->addMapping('supplier_identifier', 'supplierIdentifier')->addMapping('config_group', 'configGroup')->addMapping('attribute_set', 'attributeSet')->addMapping('id_catalog_config', 'idCatalogConfig')->addMapping('sku_config', 'skuConfig')->addMapping('status_config', 'statusConfig')->addMapping('name_other', 'nameOther')->addMapping('editor_opinion', 'editorOpinion')->addMapping('choice_of_description', 'choiceOfDescription')->addMapping('display_as_out_of_stock', 'displayAsOutOfStock')->addMapping('pet_status', 'petStatus')->addMapping('pet_approved', 'petApproved')->addMapping('activated_at', 'activatedAt')->addMapping('sku_supplier_config', 'skuSupplierConfig')->addMapping('name_supplier', 'nameSupplier')->addMapping('delivery_period', 'deliveryPeriod')->addMapping('main_material', 'mainMaterial')->addMapping('package_height', 'packageHeight')->addMapping('package_length', 'packageLength')->addMapping('package_width', 'packageWidth')->addMapping('package_weight', 'packageWeight')->addMapping('short_description', 'shortDescription')->addMapping('care_label', 'careLabel')->addMapping('next_simple_nr', 'nextSimpleNr')->addMapping('brand_name_for_theme_campaigns', 'brandNameForThemeCampaigns')->addMapping('advent_day', 'adventDay')->addMapping('advent_url', 'adventUrl')->addMapping('advent_path', 'adventPath')->addMapping('overwrite_delivery_period', 'overwriteDeliveryPeriod')->addMapping('is_seo_relevant', 'isSeoRelevant')->addMapping('export_static', 'exportStatic')->addMapping('is_hybris_product', 'isHybrisProduct')->addMapping('has_delivery_guarantee', 'hasDeliveryGuarantee')->addMapping('net_purchase_price', 'netPurchasePrice')->addMapping('net_purchase_price_discounted', 'netPurchasePriceDiscounted')->addMapping('supplier_product_number', 'supplierProductNumber')->addMapping('supplier_product_name', 'supplierProductName')->addMapping('local_stock', 'localStock')->addMapping('global_stock', 'globalStock')->addMapping('package1_length', 'package1Length')->addMapping('package1_height', 'package1Height')->addMapping('package1_width', 'package1Width')->addMapping('package1_weight', 'package1Weight')->addMapping('package2_length', 'package2Length')->addMapping('package2_height', 'package2Height')->addMapping('package2_width', 'package2Width')->addMapping('package2_weight', 'package2Weight')->addMapping('package3_length', 'package3Length')->addMapping('package3_height', 'package3Height')->addMapping('package3_width', 'package3Width')->addMapping('package3_weight', 'package3Weight')->addMapping('color_1', 'color1')->addMapping('color_2', 'color2')->addMapping('color_3', 'color3')->addMapping('color_characteristic', 'colorCharacteristic')->addMapping('additional_campaigns', 'additionalCampaigns')->addMapping('status_simple', 'statusSimple')->addMapping('expected_logistics_cost', 'expectedLogisticsCost')->addMapping('discount_level', 'discountLevel')->addMapping('blowout_round', 'blowoutRound')->addMapping('allow_multiple_po', 'allowMultiplePo');
$workflow->addItemConverter($converter)->process();
//fin de l'import dans la table virtuelle IMPORT
//copie des données avec mise en place des relations One TO Many
$em1 = $this->getDoctrine()->getManager();
$getData = new ArrayCollection();
$getData = $em1->getRepository('SuppliercheckSupplierBundle:Import');
$listData = $getData->findAll();
foreach ($listData as $value) {
$newProduct = new Product();
$newProduct->setCampaign($entity);
$newProduct->createFromImport($value);
$sku = $newProduct->getSku();
$newProduct->setLink($sku);
$entity->getProducts()->add($newProduct);
$newProduct = $value;
}
// $entity->addProducts($value);
//var_dump($entity);
// $user->getAuthoredComments()->add($newComment);
// $newComment->setAuthor($user);
$em = $this->getDoctrine()->getManager();
$em->persist($entity);
$em->flush();
return $this->redirect($this->generateUrl('supplier_campaign_show', array('id' => $entity->getId())));
}
}
// if ($form->isValid()) {
// $em = $this->getDoctrine()->getManager();
// $em->persist($entity);
// $em->flush();
// return $this->redirect($this->generateUrl('supplier_campaign_show', array('id' => $entity->getId())));
// }
return $this->render('SuppliercheckSupplierBundle:Campaign:new.html.twig', array('entity' => $entity, 'form' => $form->createView()));
}
