/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = InvoiceModel::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'date' => $this->date, 'due_date' => $this->due_date, 'type' => $this->type, 'vendor_id' => $this->vendor_id, 'value' => $this->value, 'status' => $this->status, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]); $query->andFilterWhere(['like', 'number', $this->number]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getInvoices() { return $this->hasMany(Invoice::className(), ['id' => 'invoice_id'])->viaTable('{{%payment_dtl}}', ['payment_id' => 'id']); }
/** * @return \yii\db\ActiveQuery */ public function getInvoice() { return $this->hasOne(Invoice::className(), ['id' => 'invoice_id']); }