Example #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Persons::find();
     $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;
     }
     $query->andFilterWhere(['person_id' => $this->person_id, 'organization_id' => $this->organization_id, 'created' => $this->created]);
     $query->andFilterWhere(['like', 'firstname', $this->firstname])->andFilterWhere(['like', 'lastname', $this->lastname])->andFilterWhere(['like', 'photo_filepath', $this->photo_filepath])->andFilterWhere(['like', 'state', $this->state]);
     return $dataProvider;
 }
Example #2
0
File: view.php Project: KCala/BDcrm
<?php

use yii\grid\GridView;
use yii\helpers\Html;
use yii\widgets\DetailView;
/* @var $this yii\web\View */
/* @var $model app\models\Organizations */
/* @var $searchModel app\models\PersonsSearch */
$this->title = $model->name;
$this->params['breadcrumbs'][] = ['label' => 'Organizations', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
$personsDataProvider = new \yii\data\ActiveDataProvider(['query' => \app\models\Persons::find()->where(['organization_id' => Yii::$app->getRequest()->getQueryParam('id')]), 'pagination' => ['pageSize' => 20]]);
?>
<div class="organizations-view">

    <h1><?php 
echo Html::encode($this->title);
?>
</h1>

    <p>
        <?php 
echo Html::a('Update', ['update', 'id' => $model->organization_id], ['class' => 'btn btn-primary']);
?>
        <?php 
echo Html::a('Delete', ['delete', 'id' => $model->organization_id], ['class' => 'btn btn-danger', 'data' => ['confirm' => 'Are you sure you want to delete this item?', 'method' => 'post']]);
?>
    </p>

    <?php 
echo DetailView::widget(['model' => $model, 'attributes' => ['organization_id', 'name', 'address', 'city', 'postal_code', 'website', 'description:ntext', 'logo_filepath', 'state']]);
Example #3
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getPersons()
 {
     return $this->hasMany(Persons::className(), ['organization_id' => 'organization_id']);
 }
Example #4
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getPerson()
 {
     return $this->hasOne(Persons::className(), ['person_id' => 'person_id']);
 }
Example #5
0
 /**
  * Finds the Persons model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Persons the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Persons::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }