public function readEdiData($edi_id)
{
echo '$edi_id=' . $edi_id . PHP_EOL;
$error = array();
$edifact = Edifact::model()->FindByPk($edi_id);
$parser = new EDI\Parser();
$f = explode(PHP_EOL, $edifact->message);
$parser->parse($f);
$EdiReader = new ContainerReader($f);
$dateTimePreparation = $EdiReader->readDateTimePreparation();
$terminal = $EdiReader->readEdiDataValue('UNB', 2);
$MessageType = $EdiReader->readUNHmessageType();
$MessageCode = $EdiReader->readEdiDataValue('BGM', 1);
if ($terminal == 'RIXBCT' || $terminal == 'LVRIXKRA') {
if ($MessageType == 'COARRI') {
//TDT 8067 Mode of transport, coded: codes
// '1' maritime transport
// '8' inland water transport
$ModeOfTransport = $EdiReader->readEdiDataValue(['TDT', [1 => 20]], 3, 1);
$container_count = $EdiReader->readEdiDataValue('CNT', 1, 1);
if ($container_count == 1) {
$containers = [$EdiReader->getParsedFile()];
} else {
$containers = $EdiReader->readGroups('NAD', 'EQD', 'NAD', 'CNT');
}
if ($container_count != count($containers)) {
$error[] = 'Mismatch contaier count. CNT=' . $container_count . ' groups=' . count($containers);
EcntContainer::saveEdiData(array(), $EdiReader, $error, $edifact);
return false;
}
foreach ($containers as $container) {
$error = [];
$ecnt_data = [];
$EdiReader->resetErrors();
//PARTY QUALIFIER
//CA Carrier
//(3126) Party undertaking or arranging transport of goods between named points.
$ecnt_data['ecnt_fwd'] = $EdiReader->readEdiDataValue(['NAD', ['1' => 'CA']], 2, 0);
//8051 TRANSPORT STAGE QUALIFIER:
// '20' (main carriage)
// Read: 8028 CONVEYANCE REFERENCE NUMBER: the vessel operator's loading voyage number
$ecnt_data['ecnt_transport_id'] = $EdiReader->readEdiDataValue(['TDT', ['1' => 20]], 2);
//var_dump($container);
$ConEdiReader = new ContainerReader();
$ConEdiReader->setParsedFile($container);
$container_number = $ConEdiReader->readEdiDataValue('EQD', 2);
$ecnt_data['ecnt_edifact_id'] = $edifact->id;
$ecnt_data['ecnt_container_nr'] = $container_number;
$ecnt_data['ecnt_terminal'] = $terminal;
$ecnt_data['ecnt_message_type'] = $MessageType;
$ecnt_data['ecnt_iso_type'] = $ConEdiReader->readEdiDataValue('EQD', 3, 0);
//2005 Date/time/period qualifier: code
//‘203' Execution date
$ecnt_data['ecnt_datetime'] = $ConEdiReader->readEdiSegmentDTM(203);
//$LoadingLocationIdentification = $EdiReader->readEdiDataValue(['LOC',[1=>9]],2,0);
//$DischargingLocationIdentification = $ConEdiReader->readEdiDataValue(['LOC',[1=>11]],2,0);
if ($MessageCode == 270) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_VESSEL_LOAD;
$ecnt_data['ecnt_ib_carrier'] = 'TRUCK';
} elseif ($MessageCode == 98) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_VESSEL_DISCHARGE;
$ecnt_data['ecnt_ob_carrier'] = 'TRUCK';
} else {
$error[] = 'Neatrada operation - vessel load/unload!' . '/Loading:' . $LoadingLocationIdentification . '/Discharging:' . $DischargingLocationIdentification . '/MessageCode:' . $MessageCode;
}
$ecnt_data['ecnt_weight'] = $ConEdiReader->readEdiDataValue(['MEA', ['2' => 'G']], 3, 1);
$ecnt_data['ecnt_booking'] = $ConEdiReader->readEdiDataValue(['RFF', ['1.0' => 'BN']], 1, 1);
$ecnt_data['ecnt_statuss'] = $ConEdiReader->readFullEmpty();
EcntContainer::saveEdiData($ecnt_data, $EdiReader, $error, $edifact);
}
return;
} elseif ($MessageType == 'CODECO') {
//get count of containers
$container_count = $EdiReader->readEdiDataValue('CNT', 1, 1);
//get container group detais
if ($container_count == 1) {
$containers = [$EdiReader->getParsedFile()];
} else {
$containers = $EdiReader->readGroups('NAD', 'EQD', 'TDT', 'CNT');
}
if ($container_count != count($containers)) {
$error[] = 'Mismatch contaier count. CNT=' . $container_count . ' groups=' . count($containers);
EcntContainer::saveEdiData(array(), $EdiReader, $error, $edifact);
return false;
}
//LOC Place of loading
// 9 - [3334] Seaport, airport, freight terminal,
// rail station or other place at which the goods (cargo)
// are loaded on to the means of transport being used for their carriage.
// TRUCK IN
//11 - Place of discharge
// [3392] Seaport, airport, freight terminal, rail station or other
// place at which goods are unloaded from the means of transport
// having been used for their carriage.
// TRUCK OUT
$LocationFunctionPlaceLoading = $EdiReader->readEdiDataValue(['LOC', [1 => 9]], 2);
$LocationFunctionPlaceDischarge = $EdiReader->readEdiDataValue(['LOC', [1 => 11]], 2);
$LocationFunctionKS = $EdiReader->readEdiDataValue(['LOC', [1 => 165]], 2);
if (!empty($LocationFunctionPlaceLoading)) {
$ecnt_operation = EcntContainer::ECNT_OPERATION_TRUCK_IN;
} elseif (!empty($LocationFunctionPlaceDischarge)) {
$ecnt_operation = EcntContainer::ECNT_OPERATION_TRUCK_OUT;
} elseif (!empty($LocationFunctionKS)) {
$ecnt_operation = EcntContainer::ECNT_OPERATION_TRUCK_OUT;
} else {
$error[] = 'Neatrada operation - truck in/out';
}
//PARTY QUALIFIER
//CF Container operator/lessee
// Party to whom the possession of specified property (e.g. container) has been conveyed for a period of time in return for rental payments.
$ecnt_fwd = $EdiReader->readEdiDataValue(['NAD', ['1' => 'CF']], 2);
//process all containers
foreach ($containers as $container) {
$error = [];
$EdiReader->resetErrors();
$ConEdiReader = new ContainerReader();
$ConEdiReader->setParsedFile($container);
$ecnt_data = [];
$ecnt_data['ecnt_terminal'] = $terminal;
$ecnt_data['ecnt_container_nr'] = $ConEdiReader->readEdiDataValue('EQD', 2);
$ecnt_data['ecnt_iso_type'] = $ConEdiReader->readEdiDataValue('EQD', 3, 0);
$ecnt_data['ecnt_message_type'] = $MessageType;
$ecnt_data['ecnt_operation'] = $ecnt_operation;
$ecnt_data['ecnt_fwd'] = $ecnt_fwd;
//2005 Date/time/period qualifier: code
// 7 - efective datetime
$ecnt_data['ecnt_datetime'] = $ConEdiReader->readEdiSegmentDTM(7);
$ecnt_data['ecnt_transport_id'] = $ConEdiReader->readTDTtransportIdentification(1);
if (!empty($ecnt_data['ecnt_transport_id'])) {
$ecnt_data['ecnt_ib_carrier'] = 'TRUCK';
}
$ecnt_data['ecnt_statuss'] = $ConEdiReader->readFullEmpty();
EcntContainer::saveEdiData($ecnt_data, $EdiReader, $error, $edifact);
}
return;
} else {
$error[] = 'Unknown message type:' . $MessageType;
EcntContainer::saveEdiData(array(), $EdiReader, $error, $edifact);
return;
}
} elseif ($terminal == 'RIXCT') {
if ($MessageType == 'COARRI') {
$ecnt_data = [];
$ecnt_data['ecnt_terminal'] = $terminal;
$ecnt_data['ecnt_message_type'] = $MessageType;
$ecnt_data['ecnt_fwd'] = $EdiReader->readEdiDataValue(['NAD', ['1' => 'CA']], 2, 0);
$ecnt_data['ecnt_transport_id'] = $EdiReader->readEdiDataValue(['TDT', ['1' => 20]], 2);
$ecnt_data['ecnt_edifact_id'] = $edifact->id;
$ecnt_data['ecnt_container_nr'] = $EdiReader->readEdiDataValue('EQD', 2);
$ecnt_data['ecnt_iso_type'] = $EdiReader->readEdiDataValue('EQD', 3, 0);
$ecnt_data['ecnt_datetime'] = $EdiReader->readEdiSegmentDTM(203);
//2005 Date/time/period qualifier: code
//‘203' Execution date
$ecnt_data['ecnt_datetime'] = $EdiReader->readEdiSegmentDTM(203);
if ($MessageCode == 270) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_VESSEL_LOAD;
$ecnt_data['ecnt_ib_carrier'] = 'TRUCK';
} elseif ($MessageCode == 98) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_VESSEL_DISCHARGE;
$ecnt_data['ecnt_ob_carrier'] = 'TRUCK';
} else {
$error[] = 'Neatrada operation - vessel load/unload!' . '/Loading:' . $LoadingLocationIdentification . '/Discharging:' . $DischargingLocationIdentification . '/MessageCode:' . $MessageCode;
}
$ecnt_data['ecnt_weight'] = $EdiReader->readEdiDataValue(['MEA', ['2' => 'G']], 3, 1);
$ecnt_data['ecnt_statuss'] = $EdiReader->readFullEmpty();
EcntContainer::saveEdiData($ecnt_data, $EdiReader, $error, $edifact);
return true;
} elseif ($MessageType == 'CODECO') {
$ecnt_data = [];
$ecnt_data['ecnt_terminal'] = $terminal;
$ecnt_data['ecnt_message_type'] = $MessageType;
$ecnt_data['ecnt_container_nr'] = $EdiReader->readEdiDataValue('EQD', 2);
$ecnt_data['ecnt_iso_type'] = $EdiReader->readEdiDataValue('EQD', 3, 0);
$ecnt_data['ecnt_fwd'] = $EdiReader->readEdiDataValue(['NAD', ['1' => 'CF']], 2);
// 1001 Document name code
$DocumentNameCode = $EdiReader->readEdiDataValue('BGM', 1);
if ($DocumentNameCode == 34) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_TRUCK_IN;
} elseif ($DocumentNameCode == 36) {
$ecnt_data['ecnt_operation'] = EcntContainer::ECNT_OPERATION_TRUCK_OUT;
} else {
$error[] = 'Neatrada operation - truck in/out';
}
$ecnt_data['ecnt_statuss'] = $EdiReader->readFullEmpty();
//Effective from date/time
$ecnt_data['ecnt_datetime'] = $EdiReader->readEdiSegmentDTM('181');
$ecnt_data['ecnt_transport_id'] = $EdiReader->readEdiDataValue(['TDT', ['1' => '1']], 8, 0);
if (!empty($ecnt_data['ecnt_transport_id'])) {
$ecnt_data['ecnt_ib_carrier'] = 'TRUCK';
}
$ecnt_data['ecnt_weight'] = $EdiReader->readEdiDataValue(['MEA', ['2' => 'AAE']], 3, 1);
$ecnt_data['ecnt_booking'] = $EdiReader->readEdiDataValue(['RFF', ['1.0' => 'BN']], 1, 1);
EcntContainer::saveEdiData($ecnt_data, $EdiReader, $error, $edifact);
return true;
} else {
$error[] = 'Unknown message type:' . $MessageType;
EcntContainer::saveEdiData(array(), $EdiReader, $error, $edifact);
return true;
}
}
$error[] = 'Unrecognised message';
EcntContainer::saveEdiData(array(), $EdiReader, $error, $edifact);
return false;
}
</div>
</div>
<?php
if (!empty($model->ecnt_edifact_id)) {
?>
<div class="space-12"></div>
<div class="row">
<h3 class="header blue lighter smaller">
EDI File Readable
</h3>
<div class="span12">
<pre>
<?php
$edifact = Edifact::model()->FindByPk($model->ecntEdifact->id);
$EdiParser = new EDI\Parser();
$f = explode(PHP_EOL, $edifact->message);
$parsed = $EdiParser->parse($f);
$analyser = new EDI\Analyser();
$analyser->edi_message = $edifact->message;
$mapping_segments = realpath(Yii::getPathOfAlias('edifact-data')) . '/D95B/segments.xml';
$analyser->loadSegmentsXml($mapping_segments);
echo $analyser->process($parsed);
?>
</pre>
</div>
</div>
<?php
}
echo $grid_error;
?>
</div>
<?php
}
if (!empty($grid_warning)) {
?>
<div class="alert alert-warning"><?php
echo $grid_warning;
?>
</div>
<?php
}
//if (!empty($modelMain->ecerErrors)) {
// render grid view
$model = Edifact::model();
$model->status = Edifact::STATUS_ERROR;
$this->widget('TbGridView', array('id' => 'ecer-errors-grid', 'dataProvider' => $model->search(), 'template' => '{summary}{items}{pager}', 'summaryText' => ' ', 'htmlOptions' => array('class' => 'rel-grid-view'), 'columns' => array(array('name' => 'terminal'), array('name' => 'bgm_1_id'), array('name' => 'prep_datetime'), array('name' => 'message_ref_number'), array('name' => 'filename'), array('name' => 'create_datetime'), array('class' => 'TbButtonColumn', 'buttons' => array('view' => array('visible' => 'TRUE'), 'update' => array('visible' => 'FALSE'), 'delete' => array('visible' => 'FALSE')), 'viewButtonUrl' => 'Yii::app()->controller->createUrl("edifact/view", array("id" => $data->id))', 'viewButtonOptions' => array('data-toggle' => 'tooltip')))));
Yii::endProfile('edifact.view.grid');
Yii::beginProfile('ecer_ecnt_id.view.grid');
$grid_error = '';
$grid_warning = '';
?>
<div class="table-header">
<i class="icon-warning-sign"></i>
<?php
echo Yii::t('EdifactDataModule.model', 'Non-standard moving of containers');
?>
</div>
public function loadModel($id)
{
$m = Edifact::model();
// apply scope, if available
$scopes = $m->scopes();
if (isset($scopes[$this->scope])) {
$m->{$this->scope}();
}
$model = $m->findByPk($id);
if ($model === null) {
throw new CHttpException(404, Yii::t('EdifactDataModule.crud', 'The requested page does not exist.'));
}
return $model;
}