/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = AppPartner::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, 'INN' => $this->INN, 'KPP' => $this->KPP, 'ID_BankAccount' => $this->ID_BankAccount, 'ID_TypePatrner' => $this->ID_TypePatrner]);
$query->andFilterWhere(['like', 'Name', $this->Name])->andFilterWhere(['like', 'FullName', $this->FullName])->andFilterWhere(['like', 'LegalAddress', $this->LegalAddress])->andFilterWhere(['like', 'ActualAddress', $this->ActualAddress])->andFilterWhere(['like', 'MailAddress', $this->MailAddress])->andFilterWhere(['like', 'Phone', $this->Phone])->andFilterWhere(['like', 'Fax', $this->Fax])->andFilterWhere(['like', 'Email', $this->Email]);
return $dataProvider;
}
<?php
use yii\helpers\Html;
use yii\helpers\ArrayHelper;
// use yii\grid\GridView;
use kartik\grid\GridView;
use yii\widgets\Pjax;
use app\models\AppPartner;
use app\models\AppSystemIssuer;
/* @var $this yii\web\View */
/* @var $searchModel app\models\ContractSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */
$this->title = 'Договоры';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="contract-index">
<?php
// echo $this->render('_search', ['model' => $searchModel]);
$gridColumns = [['class' => 'kartik\\grid\\SerialColumn', 'contentOptions' => ['class' => 'kartik-sheet-style'], 'header' => '', 'headerOptions' => ['class' => 'kartik-sheet-style']], ['attribute' => 'Name', 'vAlign' => 'middle', 'hAlign' => 'left', 'value' => function ($model, $key, $index, $widget) {
return Html::a($model->Name, $model->AlfrescoLink, ['title' => 'Ссылка на электронную версию документа']);
}, 'format' => 'raw'], ['value' => 'partner.FullName', 'attribute' => 'ID_partner', 'filterType' => GridView::FILTER_SELECT2, 'filter' => ArrayHelper::map(AppPartner::find()->all(), 'ID', 'FullName'), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Все контрагенты']], ['attribute' => 'DateOfSigning', 'format' => 'date'], ['attribute' => 'ID_issuer', 'value' => 'issuer.Description', 'filterType' => GridView::FILTER_SELECT2, 'filter' => ArrayHelper::map(AppSystemIssuer::find()->all(), 'ID', 'Description'), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Все системы']], ['attribute' => 'ID_in_ExtSystem'], ['attribute' => 'status', 'class' => 'kartik\\grid\\BooleanColumn'], ['class' => 'kartik\\grid\\ActionColumn', 'template' => '{view}{info}']];
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => $gridColumns, 'responsive' => true, 'hover' => true, 'pjax' => true, 'panel' => ['heading' => '<h3 class="panel-title"><i class="glyphicon glyphicon-folder-open"></i>' . '  ' . Html::encode($this->title) . '</h3>', 'type' => 'primary', 'before' => Html::a('<i class="glyphicon glyphicon-plus"></i> Создать договор', ['create'], ['class' => 'btn btn-success'])], 'toolbar' => ['{export}', '{toggleData}']]);
?>
</div>
use app\models\AppContractPayPeriod;
use app\models\AppContractCurrency;
use app\models\AppPartner;
use app\models\AppSystemIssuer;
use app\models\AppCard;
use app\models\AppCardsSearch;
use app\models\PetrolVecfil012Search;
/* @var $this yii\web\View */
/* @var $model app\models\Contract */
$this->title = $model->Name;
$this->params['breadcrumbs'][] = ['label' => 'Договоры', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
/*************************************************************************
* Подготовка данных для представления в
************************************************************************/
$attributes = [['group' => true, 'label' => 'Номер и дата подписания', 'rowOptions' => ['class' => 'info']], ['columns' => [['attribute' => 'ContractNumber'], ['attribute' => 'Period', 'format' => 'date', 'type' => DetailView::INPUT_DATE, 'widgetOptions' => ['pluginOptions' => ['format' => 'yyyy-mm-dd']]], ['attribute' => 'DateOfSigning', 'format' => 'date', 'type' => DetailView::INPUT_DATE, 'widgetOptions' => ['pluginOptions' => ['format' => 'yyyy-mm-dd']]]]], ['columns' => [['attribute' => 'Name'], ['attribute' => 'status', 'label' => 'В работе?', 'format' => 'raw', 'value' => $model->status ? '<span class="label label-success">Yes</span>' : '<span class="label label-danger">No</span>', 'type' => DetailView::INPUT_SWITCH, 'widgetOptions' => ['pluginOptions' => ['onText' => 'Yes', 'offText' => 'No']]]]], ['group' => true, 'label' => 'Электронная копия', 'rowOptions' => ['class' => 'info']], ['attribute' => 'AlfrescoLink', 'format' => 'raw'], ['group' => true, 'label' => 'Связанные поля', 'rowOptions' => ['class' => 'info']], ['attribute' => 'ID_partner', 'value' => $model->ID_partner != null ? $model->partner->FullName : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppPartner::find()->all(), 'ID', 'FullName')]], ['group' => true, 'label' => 'Параметры договора', 'rowOptions' => ['class' => 'info']], ['columns' => [['attribute' => 'ID_TypeOfContract', 'value' => $model->ID_TypeOfContract != null ? $model->typeOfContract->Description : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppContractType::find()->all(), 'ID', 'Description')]], ['attribute' => 'ID_TypeOfCalculation', 'value' => $model->ID_TypeOfCalculation != null ? $model->typeOfCalculation->Description : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppContractCalcType::find()->all(), 'ID', 'Description')]]]], ['columns' => [['attribute' => 'ID_PaymentPeriod', 'value' => $model->ID_PaymentPeriod != null ? $model->paymentperiod->Description : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppContractPayPeriod::find()->all(), 'ID', 'Description')]], ['attribute' => 'ID_CurrencyOfThePayments', 'value' => $model->ID_CurrencyOfThePayments != null ? $model->currencyOfThePayments->Name : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppContractCurrency::find()->all(), 'ID', 'Name')]]]], ['group' => true, 'label' => 'Привязка к внешней системе', 'rowOptions' => ['class' => 'info']], ['columns' => [['attribute' => 'ID_issuer', 'value' => $model->ID_issuer != null ? $model->issuer->Description : '', 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(AppSystemIssuer::find()->all(), 'ID', 'Description')]], ['attribute' => 'ID_in_ExtSystem']]]];
?>
<div class="contract-view">
<?php
echo DetailView::widget(['model' => $model, 'condensed' => true, 'hover' => true, 'mode' => DetailView::MODE_VIEW, 'fadeDelay' => 0, 'panel' => ['heading' => 'Договор : ' . $model->Name, 'type' => DetailView::TYPE_PRIMARY], 'attributes' => $attributes, 'deleteOptions' => ['url' => ['delete', 'id' => $model->ID], 'data' => ['confirm' => Yii::t('app', 'Вы действительно хотите удалить запись'), 'method' => 'post']]]);
?>
<div class="card-view">
<?php
/***************** Вывод грида по картам *********************/
echo Yii::$app->controller->renderPartial('@app/views/app-cards/indexforcontract', ['model' => $model, 'dataProvider' => new \yii\data\ActiveDataProvider(['query' => $model->getcards()]), 'searchModel' => new AppCardsSearch()]);
/***************** Вывод грида по картам петрола *********************/
/*
echo Yii::$app->controller->renderPartial(
'@app/views/petrol-vecfil012/index',
/**
* @return \yii\db\ActiveQuery
*/
public function getpartners()
{
return $this->hasMany(AppPartner::className(), ['ID_Contract' => 'ID']);
}
?>
<?php
echo $form->field($model, 'ID_CurrencyOfThePayments')->dropDownList(ArrayHelper::map(AppContractCurrency::find()->all(), 'ID', 'Name'), ['prompt' => 'Выберете валюту...']);
?>
<?php
echo $form->field($model, 'ID_issuer')->dropDownList(ArrayHelper::map(AppSystemIssuer::find()->all(), 'ID', 'Description'), ['prompt' => 'В какой системе закреплен...']);
?>
<?php
echo $form->field($model, 'ID_in_ExtSystem')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'ID_partner')->dropDownList(ArrayHelper::map(AppPartner::find()->all(), 'ID', 'FullName'), ['prompt' => 'Выберете контрагента...']);
?>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<hr>
<?php
echo Html::submitButton('Создать', ['class' => 'btn btn-primary']);
?>
<?php
echo Html::resetButton('Очистить', ['class' => 'btn btn-default']);
?>
</div>
/**
* Finds the Partner model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Partner the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = AppPartner::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
