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;
}
