<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; }