/**
* @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;
}
}
