/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'language_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\language\\LanguageI18n', ['language_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'person.full_name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\person\\Person', ['id', 'CONCAT(first_name, \' \', last_name) as full_name'], [['LIKE', 'first_name', $search]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'attribute_type.value': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\attributeType\\AttributeTypeI18n', ['concat(attribute_type_id, "|", value)', 'value'], [['LIKE', 'value', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'tree_type_i18n.label': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\treeType\\TreeTypeI18n', ['tree_type_id', 'label'], [['LIKE', 'label', $search], ['i18n_id' => Yii::$app->language]], 10); break; case 'media_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\media\\MediaI18n', ['media_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'cms_simple_menu_group_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\cmsSimpleMenuGroup\\CmsSimpleMenuGroupI18n', ['cms_simple_menu_group_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'product_i18n.name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\product\\ProductI18n', ['product_id', 'name'], [['LIKE', 'name', $search], ['i18n_id' => Yii::$app->language]], 10); break; case 'brand.name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\brand\\Brand', ['id', 'name'], [['LIKE', 'name', $search]], 10); break; case 'supplier.name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\supplier\\Supplier', ['id', 'name'], [['LIKE', 'name', $search]], 10); break; case 'variantList': $data = (new ActiveQuery(Variant::className()))->joinWith('productI18ns')->where(['LIKE', 'name', $search])->andWhere(['i18n_id' => Yii::$app->language])->limit(25)->all(); $id = ''; $value = ''; $models = []; foreach ($data as $variant) { $value = $variant->productI18n->name . ' • '; foreach ($variant->variantAttributes as $varAtt) { $attribute = $varAtt->attributeI18n ? $varAtt->attributeI18n->value : $varAtt->attributeI18ns[0]->value; $value .= '<span class=badge>' . $attribute . '</span> '; } $models[] = ['id' => $variant->id, 'value' => $value]; } return Html::activeAdvancedDropDownListData($models, 'id', 'value'); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'sheet_type_i18n.label': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\sheetType\\SheetTypeI18n', ['sheet_type_id', 'label'], [['LIKE', 'label', $search], ['i18n_id' => Yii::$app->language]], 10); break; case 'branch_i18n.label': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\branch\\BranchI18n', ['branch_id', 'label'], [['LIKE', 'label', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'cms_layout_i18n.name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\cmsLayout\\CmsLayoutI18n', ['cms_layout_id', 'name'], [['LIKE', 'name', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'third.id': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\third\\Third', ['id', 'id'], [['LIKE', 'id', $search]], 10); break; case 'address_type_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\address\\AddressTypeI18n', ['address_type_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'third.id': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\third\\Third', ['id', 'id'], [['LIKE', 'id', $search]], 10); break; case 'language_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\language\\LanguageI18n', ['language_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; case 'user.username': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\user\\User', ['id', 'username'], [['LIKE', 'username', $search]], 10); break; case 'person_gender_i18n.title': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\person\\PersonGenderI18n', ['gender_id', 'title'], [['LIKE', 'title', $search], ['i18n_id' => Yii::$app->language]], 10); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { $explode = explode('|', $id); $id = $explode[0]; $attr_type = isset($explode[1]) ? $explode[1] : null; switch ($id) { case 'attribute_type_i18n.value': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\attributeType\\AttributeTypeI18n', ['attribute_type_id', 'value'], [['LIKE', 'value', $search], ['i18n_id' => Yii::$app->language]], 10); break; case 'attribute.value': $models = (new \yii\db\Query())->select(['concat(attribute_id, "|", value)', 'value'])->from('attribute')->leftJoin('attribute_i18n', '`attribute`.`id` = `attribute_i18n`.`attribute_id`')->where(['attribute_type_id' => $attr_type])->andWhere(['LIKE', 'value', $search])->andWhere(['i18n_id' => Yii::$app->language])->limit(10)->all(); $attributeId = ''; $attributeValue = ''; if (!empty($models)) { $keys = array_keys($models[0]); $attributeId = $keys[0]; $attributeValue = isset($keys[1]) ? $keys[1] : $keys[0]; } return Html::activeAdvancedDropDownListData($models, $attributeId, $attributeValue); break; default: return []; break; } }
/** * @inheritdoc */ protected function getAdvancedDropDownList($id, $search) { switch ($id) { case 'company.name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\company\\Company', ['third_id', 'name'], [['LIKE', 'name', $search]], 10); break; case 'person.last_name': return Html::findAdvancedDropDownListData('kalibao\\common\\models\\person\\Person', ['third_id', 'last_name'], [['LIKE', 'last_name', $search]], 10); break; default: return []; break; } }