public function searchPrevContainer()
{
$criteria = new CDbCriteria();
//$criteria->compare('t.ecnt_container_nr', $this->ecnt_container_nr);
$criteria->condition = "ecnt_datetime < '" . $this->ecnt_datetime . "' and t.ecnt_container_nr ='" . $this->ecnt_container_nr . "'";
$criteria->order = "ecnt_datetime DESC";
$criteria->limit = 1;
return EcntContainer::model()->find($criteria);
}
<div class="table-header">
<i class="icon-road"></i>
<?php
echo Yii::t('EdifactDataModule.model', 'On The Way');
?>
</div>
<?php
if (!empty($grid_error)) {
?>
<div class="alert alert-error"><?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 = EcntContainer::model();
$this->widget('TbGridView', array('id' => 'ecnt-way-grid', 'dataProvider' => $model->searchOnTheWay(), 'template' => '{summary}{items}', 'summaryText' => ' ', 'htmlOptions' => array('class' => 'rel-grid-view'), 'columns' => array(array('name' => 'ecnt_terminal', 'type' => 'raw', 'value' => 'Chtml::tag("span" , array("class" => $data->getTerminalClass() ), $data->ecnt_terminal)'), array('name' => 'ecnt_transport_id'), array('name' => 'ecnt_container_nr'), array('name' => 'ecnt_datetime'), array('name' => 'ecnt_move_code', 'value' => '$data->getEnumColumnLabel("ecnt_move_code")'), array('name' => 'ecnt_iso_type'), array('class' => 'editable.EditableColumn', 'name' => 'ecnt_notes', 'editable' => array('type' => 'textarea', 'url' => $this->createUrl('/edifactdata/ecntContainer/editableSaver'))), array('class' => 'TbButtonColumn', 'buttons' => array('view' => array('visible' => 'TRUE'), 'update' => array('visible' => 'FALSE'), 'delete' => array('visible' => 'FALSE')), 'viewButtonUrl' => 'Yii::app()->controller->createUrl("ecntContainer/view", array("ecnt_id" => $data->ecnt_id))', 'viewButtonOptions' => array('data-toggle' => 'tooltip')))));
//}
Yii::endProfile('ecnt_on_the_way.view.grid');
public function attributeLabels()
{
return array_merge(parent::attributeLabels(), EcntContainer::model()->attributeLabels());
}
public function loadModel($id)
{
$m = EcntContainer::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;
}