public static function FetchProducts() { $sql = 'SELECT * FROM easyii_catalog_items where category_id=2'; $allProducts = Item::findBySql($sql)->all(); $listData = ArrayHelper::map($allProducts, 'item_code', 'title'); return $listData; }
public static function applyFilters($filters, $query) { if (is_array($filters)) { if (!empty($filters['country'])) { $query->andFilterWhere(['=', 'country', $filters['country']]); unset($filters['country']); } if (!empty($filters['government'])) { $query->andFilterWhere(['=', 'government', $filters['government']]); unset($filters['government']); } if (!empty($filters['city'])) { $query->andFilterWhere(['=', 'city', $filters['city']]); unset($filters['city']); } if (!empty($filters['district'])) { $query->andFilterWhere(['=', 'district', $filters['district']]); unset($filters['district']); } if (!empty($filters['product_id'])) { //get all pharmacies for this product $sql = 'SELECT customer_id FROM customer_items where item_id=' . $filters['product_id']; $allpharmacies = \yii\easyii\modules\catalog\models\Item::findBySql($sql)->asArray()->all(); $data[] = null; foreach ($allpharmacies as $key => $value) { $data[] = $value[customer_id] . ','; } $query->andFilterWhere(['in', 'item_id', $data]); unset($filters['product_id']); } } return $query; }