/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = TipoDespesa::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(['idtipo_despesa' => $this->idtipo_despesa]); $query->andFilterWhere(['like', 'tipo', $this->tipo]); return $dataProvider; }
public function actionListarRemoto($search = null, $id = null) { $out = ['more' => false]; if (!is_null($search)) { $query = new Query(); $query->select('idtipo_despesa AS id, tipo AS text')->from('tipo_despesa')->where('tipo LIKE "%' . $search . '%"')->limit(200); $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'text' => TipoDespesa::findOne($id)->tipo]; } else { $out['results'] = ['id' => 0, 'text' => 'No matching records found']; } echo Json::encode($out); }
<?php /** * Created by PhpStorm. * User: root * Date: 15/08/15 * Time: 09:26 */ use \yii\bootstrap\ActiveForm; use \yii\helpers\Html; use \kartik\money\MaskMoney; ?> <div class="caixa-despesa"> <?php $form = ActiveForm::begin(); ?> <div class="row"> <div class="col-md-12"> <h2>Nova Despesa</h2> <?= $form->field($model, 'valor')->widget(MaskMoney::classname()) ?> <?= $form->field($model, 'tipo_despesa')->inline()->radioList(\app\models\TipoDespesa::map()) ?> <?= $form->field($model, 'obs')->textInput() ?> <div class="form-group"> <?= Html::submitButton('Cadastrar', ['class' => 'btn btn-success']) ?> </div> </div> </div> <?php ActiveForm::end(); ?> </div>
/** * @return \yii\db\ActiveQuery */ public function getTipoDespesaIdtipoDespesa() { return $this->hasOne(TipoDespesa::className(), ['idtipo_despesa' => 'tipo_despesa_idtipo_despesa']); }
<?php use yii\helpers\Html; use yii\widgets\ActiveForm; /* @var $this yii\web\View */ /* @var $model app\models\Despesa */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="despesa-form"> <?php $form = ActiveForm::begin(); ?> <?= $form->field($model, 'tipo_despesa_idtipo_despesa')->dropDownList(\app\models\TipoDespesa::map()) ?> <div class="form-group"> <?= Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?> </div> <?php ActiveForm::end(); ?> </div>