/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params, $static_params) { $query = TrxTransactionDetails::find()->where($static_params); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'transaction_id' => $this->transaction_id, 'batch' => $this->batch, 'net_weight' => $this->net_weight, 'total_weight' => $this->total_weight, 'pallet_weight' => $this->pallet_weight, 'kitted_unit' => $this->kitted_unit, 'manufacturing_date' => $this->manufacturing_date, 'expiry_date' => $this->expiry_date, 'creator_id' => $this->creator_id, 'updater_id' => $this->updater_id, 'updated_date' => $this->updated_date]); $query->andFilterWhere(['like', 'material_code', $this->material_code])->andFilterWhere(['like', 'pallet_no', $this->pallet_no])->andFilterWhere(['like', 'pallet_type', $this->pallet_type])->andFilterWhere(['like', 'status', $this->status]); // start date range filter if (isset($this->start_date) && $this->start_date != null) { $startDate = explode(' - ', $this->start_date); $startDateFrom = Yii::$app->dateFormatter->convert($startDate[0]); $startDateTo = Yii::$app->dateFormatter->convert($startDate[1]); $query->andFilterWhere(['between', 'start_date', $startDateFrom, $startDateTo]); } // created date range filter if (isset($this->created_date) && $this->created_date != null) { $createdDate = explode(' - ', $this->created_date); $createdDateFrom = Yii::$app->dateFormatter->convert($createdDate[0]); $createdDateTo = Yii::$app->dateFormatter->convert($createdDate[1]); $query->andFilterWhere(['between', 'created_date', $createdDateFrom, $createdDateTo]); } return $dataProvider; }
public function getTransactionDetails($conditions = null) { // to retrieve all *active* material conversions by their index and order them by their ID: $model = TrxTransactionDetails::find()->where($conditions)->one(); return $model; }