/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Vendorproducts::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(['Pid' => $this->Pid]); $query->andFilterWhere(['like', 'ProductName', $this->ProductName])->andFilterWhere(['like', 'Quatity', $this->Quatity])->andFilterWhere(['like', 'Weight', $this->Weight])->andFilterWhere(['like', 'Price', $this->Price])->andFilterWhere(['like', 'Discount', $this->Discount]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { if (isset($params['vendorId'])) { $vendorId = $params['vendorId']; $query = Vendorproducts::find()->where("vendorId = {$vendorId} and \tEndDate >= CURDATE()"); } else { $query = Vendorproducts::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(['Saleid' => $this->Saleid]); $query->andFilterWhere(['like', 'productId', $this->productId])->andFilterWhere(['like', 'Brand', $this->Brand])->andFilterWhere(['like', 'Quantity', $this->Quantity])->andFilterWhere(['like', 'uom', $this->uom])->andFilterWhere(['like', 'AltQty', $this->AltQty])->andFilterWhere(['like', 'AltUom', $this->AltUom])->andFilterWhere(['like', 'UnitPrice', $this->UnitPrice])->andFilterWhere(['like', 'SalePrice', $this->SalePrice])->andFilterWhere(['like', 'PriceUnit', $this->PriceUnit])->andFilterWhere(['like', 'StartDate', $this->StartDate])->andFilterWhere(['like', 'EndDate', $this->EndDate])->andFilterWhere(['like', 'ReserveCount', $this->ReserveCount])->andFilterWhere(['like', 'SaleInd', $this->SaleInd])->andFilterWhere(['like', 'categoryName', $this->categoryName]); //print_r($dataProvider->getModels());exit(); return $dataProvider; }
public static function getTotalsalleitems($vendorId) { $totalsaleItems = Vendorproducts::find()->where("(StartDate > '2015-11-07' OR StartDate = '2015-11-07') AND vendorId={$vendorId} ")->count(); return $totalsaleItems; }