/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$em = $this->container->get('doctrine')->getManager();
$dataSet = ['MAGELLAN MARITIME SERVICES GMBH', 'UES INTERNATIONAL (HK) HOLDINGS LIMITED', 'SEACO SRL', 'FLORENS CONTAINER SERVICES CO LTD', 'SEACUBE CONTAINER LEASING', 'TOUAX', 'GRAND VIEW CONTAINER TRADING (HK) CO LTD'];
foreach ($dataSet as $k => $v) {
$organization = new Organization();
$organization->setName($v);
$em->persist($organization);
}
$em->flush();
$em->clear();
}
/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$em = $this->container->get('doctrine')->getManager();
$dataSet = ['Sogeco', 'CAI (Container Applications International)', 'Textainer', 'TAL International Container Corporation', 'Beacon Intermodal', 'Triton Container International Limited '];
foreach ($dataSet as $k => $v) {
$organization = new Organization();
$organization->setName($v);
$em->persist($organization);
}
$em->flush();
$em->clear();
}
/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$em = $this->container->get('doctrine')->getManager();
$dataSet = ['A.P. Moller–Maersk Group', 'CMA CGM S.A.'];
foreach ($dataSet as $k => $v) {
$organization = new Organization();
$organization->setName($v);
$em->persist($organization);
}
$em->flush();
$em->clear();
}
/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
$em = $this->container->get('doctrine')->getManager();
$dataSet = ['APL' => ['APL' => 'American President Lines']];
foreach ($dataSet as $k => $v) {
$organization = new Organization();
$organization->setName($k);
$em->persist($organization);
foreach ($v as $i => $j) {
$subcontractor = new Subcontractor();
$subcontractor->setOrganization($organization);
$subcontractor->setCode($i);
$subcontractor->setName($j);
$em->persist($subcontractor);
}
}
$em->flush();
$em->clear();
}
/**
* Parse sheet
* @param \PHPExcel_Worksheet $sheet
* @param bool $isEem
*/
private function parseSheet(\PHPExcel_Worksheet $sheet, $isEem = false)
{
$this->setActiveWorksheet($sheet);
$map = $this->getSheetMap($this->_objExcel->getIndex($sheet));
$this->getMessageService()->addMessage("Start import sheet <i>{$sheet->getTitle()}</i>:", Message::TEXT);
for ($startRow = 2; ($orgId = $this->getValueByColAndRow($map['OrganizationID'], $startRow)) == true; $startRow++) {
$data = array_map(function ($col) use($startRow, $map) {
return $this->getValueByColAndRow($col, $startRow);
}, $map);
if (isset($data['Action']) && strtoupper($data['Action']) == 'DELETED') {
continue;
}
if (!is_numeric($data['LocationID'])) {
$this->getMessageService()->addMessage('Location is not a number at line ' . $startRow, Message::WARNING);
continue;
}
if (!$data['Organization']) {
$this->getMessageService()->addMessage('Empty organization name at line ' . $startRow, Message::WARNING);
continue;
}
if (!$data['LocationID']) {
$this->getMessageService()->addMessage('Empty location id at line ' . $startRow, Message::WARNING);
continue;
}
if (!isset($this->processedOrganizations[$orgId])) {
$this->_em->getFilters()->disable('softdeleteable');
$organization = $this->_em->getRepository('CoreBundle:Organization')->findOneBy(['customerCode' => $orgId, 'customer' => $this->customer->getId()]);
$this->_em->getFilters()->enable('softdeleteable');
if (!$organization) {
$organization = new Entity\Organization();
$this->counters['createdOrg']++;
}
$organization->setName($data['Organization'])->setCustomer($this->customer)->setCustomerCode($data['OrganizationID'])->setCustomNumber1(intval($isEem))->setDeletedAt(null);
$this->processedOrganizations[$orgId] = $organization;
} else {
$organization = $this->processedOrganizations[$orgId];
if ($organization->getName() && $this->stripValue($organization->getName()) != $this->stripValue($data['Organization'])) {
$this->getMessageService()->addMessage("Different organization name for orgId = {$orgId} at line " . $startRow, Message::ERROR);
continue;
}
}
if (isset($data['Sign'])) {
$organization->setSign($data['Sign']);
}
$this->_em->persist($organization);
$this->_em->getFilters()->disable('softdeleteable');
$location = $this->_em->getRepository('CoreBundle:OrganizationLocation')->findOneBy(['organization' => $organization->getId(), 'customerCode' => $data['LocationID']]);
$this->_em->getFilters()->enable('softdeleteable');
if (!$location) {
$location = new Entity\OrganizationLocation();
$this->counters['createdLoc']++;
} else {
$this->counters['updatedLoc']++;
}
if (!isset($this->locationsNames[$data['LocationID']])) {
$this->locationsNames[$data['LocationID']] = $this->stripValue($data['LocationName']);
} else {
if ($this->locationsNames[$data['LocationID']] != $this->stripValue($data['LocationName'])) {
$this->getMessageService()->addMessage("Different location name for LocationId = {$data['LocationID']} at line " . $startRow, Message::ERROR);
continue;
}
}
$location->setAlias($data['LocationName'])->setOrganization($organization)->setCustomer($this->customer)->setCustomerCode((int) $data['LocationID'])->setDeletedAt(null);
if (isset($data['LocationDesc'])) {
$location->setCustomText1($data['LocationDesc']);
}
if (isset($data['AgentID'])) {
$location->setCustomNumber1((int) $data['AgentID'])->setCustomText2($data['AgentName']);
}
if (isset($data['TimeBuffer'])) {
$location->setCustomNumber2((int) $data['TimeBuffer'])->setCustomNumber3((int) $data['ADP']);
}
$this->_em->persist($location);
//remaining locations will be soft deleted
if (isset($this->vendors[$orgId]['locs'][$data['LocationID']])) {
unset($this->vendors[$orgId]['locs'][$data['LocationID']]);
}
}
}
private function addOrganization($name)
{
$org = new Entity\Organization();
$org->setName($name);
$org->setCustomer($this->_customer);
$org->setCustomerCode(self::CUSTOMER_CODE);
$this->_em->persist($org);
return $org;
}