/**
* Renders the index view for the module
* @return string
*/
public function actionChangeGroup()
{
$count = 0;
foreach (Object::find()->all() as $object) {
/** @var $object Object */
$group = Group::find()->where(['name' => mb_substr($object->name, 0, 1)])->one();
if ($group) {
\Yii::$app->db->createCommand()->update('object', ['group_id' => $group->id], ['id' => $object->id])->execute();
$count++;
}
}
echo "done - {$count}\n";
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Object::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'group_id' => $this->group_id, 'region_id' => $this->region_id]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Object::find()->joinWith(['sale']);
//->orderBy(['id' => SORT_DESC]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['object.id' => $this->id, 'sale.region_id' => $this->region_id, 'sale.status' => $this->status, 'sale.district_id' => $this->district_id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'address', $this->address]);
return $dataProvider;
}
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
/* @var $this yii\web\View */
/* @var $model common\models\ObjectInfo */
/* @var $form yii\widgets\ActiveForm */
$object_list = \common\models\Object::find()->all();
?>
<div class="object-info-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'address_ksk')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'amount_house')->textInput();
?>
<?php
echo $form->field($model, 'address_house')->textInput();
?>
<?php
echo $form->field($model, 'fullname_chairman')->textInput();
?>
public static function gpsMarkers($district_id)
{
$temp = Object::find()->joinWith(['sale']);
if ($district_id > 0) {
$temp = $temp->where(['district_id' => $district_id]);
}
$temp = $temp->asArray()->all();
$items = [];
foreach ($temp as $t) {
$t = $t['sale'];
$items[] = ['link' => Url::toRoute(['sale/update', 'id' => $t['id']]), 'status' => $t['status'], 'pos' => $t['gps'], 'title' => 'ID ' . $t['object_id'] . ' (' . $t['address'] . ') ' . $t['name'] . ' - ' . date('d.m.Y', $t['created_at'])];
}
return $items;
}
