public function beforeSave()
{
//validate rigts to record
if (!$this->isNewRecord && !FpeoPeriodOdo::model()->findByPk($this->primaryKey)) {
return false;
}
//get fixr for truck
$fixr = FixrFiitXRef::model()->findByPk($this->fpeo_fixr_id);
if (!$fixr) {
$this->addError('fpeo_id', 'Can not find fixr record');
return false;
}
//found fret record - definitiom
if (empty($fixr->fixrPositionFret)) {
$this->addError('fpeo_id', 'No defined position');
return false;
}
$position_model = $fixr->fixrPositionFret->fret_model;
$position_model_fixr_field = $fixr->fixrPositionFret->fret_model_fixr_id_field;
//process position model
$position = new $position_model();
$position_data = $position->findByAttributes(array($position_model_fixr_field => $this->fpeo_fixr_id));
if (empty($fixr->fixrPositionFret)) {
$this->addError('fpeo_id', 'No found position data');
return false;
}
//find in position model vtrc_id - truck field
$vtrc_id = false;
foreach ($position_data->attributes as $col_name => $col_value) {
if (substr($col_name, -7) == 'vtrc_id') {
$vtrc_id = $col_value;
break;
}
}
if (!$vtrc_id) {
$this->addError('fpeo_id', 'In position data no exist vtrc_id columns');
return false;
}
//get nearest odometer reading by date
$vodo = VodoOdometer::getOdoByDate($vtrc_id, $this->fpeo_start_date);
if (!$vodo) {
$this->addError('fpeo_id', 'No found odometer readings for car');
return false;
}
//get data from odometer reading
$this->fpeo_vodo_id = $vodo->vodo_id;
$this->fpeo_start_abs_odo = $vodo->vodo_abs_odo;
$this->fpeo_end_abs_odo = $vodo->vodo_abs_odo + $this->fpeo_distance;
//end date
$vtrc = VtrcTruck::model()->findByPk($vtrc_id);
if (empty($vtrc->vtrc_year_mileage)) {
$this->addError('fpeo_id', 'Pleas set for truc Yearly Run');
return false;
}
$sql_expr = new CDbExpression("ADDDATE(:date,:days)");
$sql_expr->params = array(':date' => $this->fpeo_start_date, ':days' => round($this->fpeo_distance / $vtrc->vtrc_year_mileage * 365));
$this->fpeo_end_date = $sql_expr;
return parent::beforeSave();
}
public function loadModel($id)
{
$m = VodoOdometer::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('TrucksModule.crud', 'The requested page does not exist.'));
}
return $model;
}
/**
* get last reading before requestd date
* @param int $vtrc_id
* @param date $date
* @return VodoOdometer record
*/
public static function getOdoByDate($vtrc_id, $date)
{
$criteria = new CDbCriteria();
$criteria->compare('vodo_vtrc_id', $vtrc_id);
$criteria->condition = "vodo_end_datetime < :date";
$criteria->params = array(':date' => $date);
return VodoOdometer::model()->find($criteria);
}
