<b><?php
echo Yii::t('ReisModule.default', 'Опасный груз');
?>
:</b>
</section>
<section class="col-sm-6">
<?php
echo $Reis->dangerous ? Yii::t('ReisModule.default', 'да') : Yii::t('ReisModule.default', 'нет');
?>
</section>
<?php
if ($Reis->dangerous) {
?>
<section class="col-sm-6">
<b><?php
echo Reis::getSomeOptsByTransportType($Reis->transport_type_id, "ADR_name", "Need translate for=[ADR_name],id=[{$Reis->transport_type_id}]");
?>
:</b>
</section>
<section class="col-sm-6">
<?php
echo $Reis->ADR ? $Reis->ADR : '---';
?>
</section>
<?php
}
?>
</div>
</section>
<section class="col-sm-6">
<div class="row">
<?php
echo $form->checkboxListGroup($Reis, 'body', ['widgetOptions' => ['data' => Reis::getTransportTypeAir(), 'htmlOptions' => ['name' => 'Reis[body_air]']], 'label' => Reis::getSomeOptsByTransportType(22, "body_name", "Need translate for=[body_name],id=[22]")]);
?>
</section>
</div>
<div id="transport_type_block_river" style="display:none">
<section class="col-md-4 checkbox-list-bg show-green">
<?php
echo $form->checkboxListGroup($Reis, 'body', ['widgetOptions' => ['data' => Reis::getTransportTypeRiver(), 'htmlOptions' => ['name' => 'Reis[body_river]']], 'label' => Reis::getSomeOptsByTransportType(72, "body_name", "Need translate for=[body_name],id=[72]")]);
?>
</section>
</div>
<div id="transport_type_block_multi" style="display:none">
<section class="col-md-4 checkbox-list-bg show-green">
<?php
echo $form->checkboxListGroup($Reis, 'body', ['widgetOptions' => ['data' => Reis::getTransportTypeMulti(), 'htmlOptions' => ['name' => 'Reis[body_multi]']], 'label' => Reis::getSomeOptsByTransportType(73, "body_name", "Need translate for=[body_name],id=[73]")]);
?>
</section>
</div>
</div>
<section class="col-md-12 show-green">
<h3 class="pull-left"><?php
echo Yii::t('ReisModule.default', 'Оплата');
?>
:</h3>
<div class="pull-left" style="margin-top: 10px; margin-left: 20px;">
<?php
echo $form->checkboxGroup($Reis, 'price_asc');
?>
</div>
public function getCriteria()
{
$criteria = new CDbCriteria();
$params = $with = $condition = $arr = [];
if (!empty($this->from_shapes)) {
$from_shapes = json_decode($this->from_shapes);
foreach ($from_shapes as $shape) {
switch ($shape->type) {
case 'circle':
$radius = $shape->radius / 111144;
$lat = (double) $shape->center->lat;
$lng = (double) $shape->center->lng;
$condition[] = "(address_from.lat BETWEEN '" . ($lat - $radius) . "' AND '" . ($lat + $radius) . "') \r\n AND (address_from.long BETWEEN '" . ($lng - $radius) . "' AND '" . ($lng + $radius) . "')\r\n AND SQRT(POW(" . $lat . "-address_from.lat,2)+POW(" . $lng . "-address_from.long,2)) <" . $radius;
break;
case 'rectangle':
$condition[] = "(address_from.lat BETWEEN '" . (double) $shape->SW->lat . "' AND '" . (double) $shape->NE->lat . "') \r\n AND (address_from.long BETWEEN '" . (double) $shape->SW->lng . "' AND '" . (double) $shape->NE->lng . "')";
break;
case 'polygon':
$triangle = $this->_getTriangle($shape);
foreach ($triangle as $tr) {
$condition[] = "IN_TRIANGLE(" . $tr[0]->lat . "," . $tr[0]->lng . "," . $tr[1]->lat . "," . $tr[1]->lng . "," . $tr[2]->lat . "," . $tr[2]->lng . ",address_from.lat,address_from.long)";
}
break;
}
}
}
// CVarDumper::dump($this,10,10);exit;
if (!empty($this->from_name)) {
$arr[] = "address_from.name = " . Yii::app()->db->quoteValue($this->from_name) . "";
if (!empty($this->from_radius)) {
$arr[] = "address_from.radius = '" . $this->from_radius . "'";
}
if (!empty($this->from_address_lat) && !empty($this->from_address_long)) {
$from_radius = (int) $this->from_radius;
$radius = ($from_radius < 25 ? 25 : $from_radius) / 111.144;
$lat = (double) $this->from_address_lat;
$lng = (double) $this->from_address_long;
$condition[] = "(address_from.lat BETWEEN '" . ($lat - $radius) . "' AND '" . ($lat + $radius) . "') \r\n\t\t\t\t AND (address_from.long BETWEEN '" . ($lng - $radius) . "' AND '" . ($lng + $radius) . "')\r\n\t\t\t\t AND SQRT(POW(" . $lat . "-address_from.lat,2)+POW(" . $lng . "-address_from.long,2)) <" . $radius;
}
if (!empty($arr)) {
$condition[] = implode(' AND ', $arr);
}
}
if (!empty($condition)) {
$with['address_from'] = ['joinType' => 'INNER JOIN', 'condition' => implode(' OR ', $condition)];
}
$condition = $arr = [];
if (!empty($this->to_shapes)) {
$to_shapes = json_decode($this->to_shapes);
foreach ($to_shapes as $shape) {
switch ($shape->type) {
case 'circle':
$radius = $shape->radius / 111144;
$lat = (double) $shape->center->lat;
$lng = (double) $shape->center->lng;
$condition[] = "(address_to.lat BETWEEN '" . ($lat - $radius) . "' AND '" . ($lat + $radius) . "') \r\n AND (address_to.long BETWEEN '" . ($lng - $radius) . "' AND '" . ($lng + $radius) . "')\r\n AND SQRT(POW(" . $lat . "-address_to.lat,2)+POW(" . $lng . "-address_to.long,2)) <" . $radius;
break;
case 'rectangle':
$condition[] = "(address_to.lat BETWEEN '" . (double) $shape->SW->lat . "' AND '" . (double) $shape->NE->lat . "') \r\n AND (address_to.long BETWEEN '" . (double) $shape->SW->lng . "' AND '" . (double) $shape->NE->lng . "')";
break;
case 'polygon':
$triangle = $this->_getTriangle($shape);
foreach ($triangle as $tr) {
$condition[] = "IN_TRIANGLE(" . $tr[0]->lat . "," . $tr[0]->lng . "," . $tr[1]->lat . "," . $tr[1]->lng . "," . $tr[2]->lat . "," . $tr[2]->lng . ",address_from.lat,address_from.long)";
}
break;
}
}
}
if (!empty($this->to_name)) {
$arr[] = "address_to.name = " . Yii::app()->db->quoteValue($this->to_name) . "";
if (!empty($this->to_radius)) {
$arr[] = "address_to.radius = '" . $this->to_radius . "'";
}
if (!empty($this->to_address_lat) && !empty($this->to_address_long)) {
$to_radius = (int) $this->to_radius;
$radius = ($to_radius < 25 ? 25 : $to_radius) / 111.144;
$lat = (double) $this->to_address_lat;
$lng = (double) $this->to_address_long;
$condition[] = "(address_to.lat BETWEEN '" . ($lat - $radius) . "' AND '" . ($lat + $radius) . "') \r\n\t\t\t\t AND (address_to.long BETWEEN '" . ($lng - $radius) . "' AND '" . ($lng + $radius) . "')\r\n\t\t\t\t AND SQRT(POW(" . $lat . "-address_to.lat,2)+POW(" . $lng . "-address_to.long,2)) <" . $radius;
}
if (!empty($arr)) {
$condition[] = implode(' AND ', $arr);
}
}
if (!empty($condition)) {
$with['address_to'] = ['joinType' => 'INNER JOIN', 'condition' => implode(' OR ', $condition)];
}
$condition = [];
if (!empty($this->when_from) || !empty($this->when_to)) {
$when_from = date('Y-m-d', strtotime($this->when_from));
$when_to = date('Y-m-d', strtotime($this->when_to));
if (!empty($this->when_from) && !empty($this->when_to)) {
$condition = ':when_from <= t.when_from AND :when_to >= t.when_from ';
$criteria->addCondition($condition);
$params[':when_from'] = $when_from;
$params[':when_to'] = $when_to;
} elseif (!empty($this->when_from)) {
$criteria->addCondition(':when_from <= t.when_from');
$params[':when_from'] = $when_from;
} elseif (!empty($this->when_to)) {
$criteria->addCondition(':when_to >= t.when_from');
$params[':when_to'] = $when_to;
}
}
if (!empty($this->volume_from)) {
$criteria->addCondition(':volume_from <= t.volume_from');
$params[':volume_from'] = $this->volume_from;
}
if (!empty($this->volume_to)) {
$criteria->addCondition(':volume_to >= t.volume_to');
$params[':volume_to'] = $this->volume_to;
}
if (!empty($this->weight_from)) {
$criteria->addCondition(':weight_from <= t.weight_from');
$params[':weight_from'] = $this->weight_from;
}
if (!empty($this->weight_from_unit)) {
$criteria->addCondition(':weight_from_unit = t.weight_from_unit');
$params[':weight_from_unit'] = $this->weight_from_unit;
}
if (!empty($this->weight_to)) {
$criteria->addCondition(':weight_to >= t.weight_to');
$params[':weight_to'] = $this->weight_to;
}
if (!empty($this->weight_to_unit)) {
$criteria->addCondition(':weight_to_unit = t.weight_to_unit');
$params[':weight_to_unit'] = $this->weight_to_unit;
}
if (!empty($this->length_from)) {
$criteria->addCondition(':length_from <= t.length_from');
$params[':length_from'] = $this->length_from;
}
if (!empty($this->length_to)) {
$criteria->addCondition(':length_to >= t.length_to');
$params[':length_to'] = $this->length_to;
}
if (!empty($this->height_from)) {
$criteria->addCondition(':height_from <= t.height_from');
$params[':height_from'] = $this->height_from;
}
if (!empty($this->height_to)) {
$criteria->addCondition(':height_to >= t.height_to');
$params[':height_to'] = $this->height_to;
}
if (!empty($this->width_from)) {
$criteria->addCondition(':width_from <= t.width_from');
$params[':width_from'] = $this->width_from;
}
if (!empty($this->width_to)) {
$criteria->addCondition(':width_to >= t.width_to');
$params[':width_to'] = $this->width_to;
}
//Yii::log("getCriteria this=[".print_r( $this , true )."]","info");
if (false !== $this->transport_type_id) {
if (0 == $this->transport_type_id) {
if (!empty($this->dangerous_ALL)) {
$criteria->addCondition(':dangerous = t.dangerous');
$params[':dangerous'] = $this->dangerous_ALL;
}
} elseif ($this->transport_type_id > 0) {
$dangerousTmp = Reis::getSomeOptsByTransportType($this->transport_type_id, 'dangerous', null);
if (!is_null($dangerousTmp) && !empty($this->{$dangerousTmp})) {
$criteria->addCondition(':dangerous = t.dangerous');
$params[':dangerous'] = $this->{$dangerousTmp};
$adrTmp = Reis::getSomeOptsByTransportType($this->transport_type_id, 'ADR', null);
if (!is_null($this->{$adrTmp}) && !empty($this->{$adrTmp})) {
$criteria->addCondition(':ADR = t.ADR');
$params[':ADR'] = $this->{$adrTmp};
}
}
$criteria->addCondition(':transport_type_id = t.transport_type_id');
$params[':transport_type_id'] = $this->transport_type_id;
$arrRel = Reis::getSomeOptsByTransportType($this->transport_type_id, 'relations', []);
// Yii::log("getCriteria arrRel=[".print_r( $arrRel , true )."],this=[".print_r( $this , true )."]","info");
foreach ($arrRel as $k => $v) {
// k - body , v - body_auto
if (!empty($this->{$v})) {
// body_list
$dataNameRel = Reis::getSomeOptsByTransportType($this->transport_type_id, "{$k}_list", null);
if (!is_null($dataNameRel) && method_exists('Reis', $dataNameRel)) {
$arrNameRelItems = call_user_func(array('Reis', $dataNameRel));
//Yii::log("getCriteria arrNameRelItems=[".print_r( $arrNameRelItems , true )."]","info");
$arrIn = [];
foreach ($this->{$v} as $v2) {
if (isset($arrNameRelItems[$v2])) {
// проверка что в словаре есть такой индекс, защита
$arrIn[] = (int) $v2;
}
}
if (count($arrIn)) {
$with[$k] = ['joinType' => 'INNER JOIN', 'condition' => "{$k}.id IN (" . implode(',', $arrIn) . ")"];
}
}
}
}
}
} else {
Yii::log("getCriteria transport_type_id is false", "info");
}
if (false !== $this->price_requested && is_array($this->price_requested)) {
foreach ($this->price_requested as $v) {
if (1 == $v) {
$criteria->addCondition('t.price_asc = 1');
} elseif (2 == $v) {
$criteria->addCondition('t.price_asc = 0');
}
}
}
$condition = [];
if (!empty($this->price_present)) {
$condition[] = "(cost.value > 0)";
}
if (false !== $this->price_methods_of_payment && is_array($this->price_methods_of_payment)) {
foreach ($this->price_methods_of_payment as $v) {
if (0 == $v) {
$condition[] = "(cost.cash = 0)";
} elseif (1 == $v) {
$condition[] = "(cost.cash = 1)";
}
}
}
if (false !== $this->price_currency && is_array($this->price_currency)) {
foreach ($this->price_currency as $v) {
$condition[] = "(cost.currency_id = {$v})";
}
}
if (!empty($condition)) {
$with['cost'] = ['joinType' => 'INNER JOIN', 'condition' => implode(' AND ', $condition)];
}
$with['user'] = ['with' => ['company']];
$criteria->addCondition('t.deleted_status=:deleted_status AND company.active = "1"');
$params[':deleted_status'] = Cargo::DEL_SATUS_ACTIVE;
$criteria->with = $with;
$criteria->params = $params;
$criteria->order = 't.reis_id DESC';
return $criteria;
}
