FM / models

/var/www/vhosts/nabawater/common/models/

/var/www/vhosts/nabawater/common/models

Name	Size	Mode	Actions
base/	-	0755	rm
ActivityLog.php	175	0644	edit dl rm
AddressType.php	1715	0644	edit dl rm
AddressTypeLang.php	322	0644	edit dl rm
AdminUser.php	8600	0644	edit dl rm
Ads.php	2430	0644	edit dl rm
AdsLang.php	158	0644	edit dl rm
Area.php	1168	0644	edit dl rm
AreaLang.php	286	0644	edit dl rm
Banner.php	1440	0644	edit dl rm
BannerLang.php	170	0644	edit dl rm
Branch.php	15646	0644	edit dl rm
BranchDeliveryArea.php	202	0644	edit dl rm
BranchImage.php	328	0644	edit dl rm
BranchLang.php	353	0644	edit dl rm
BranchReview.php	695	0644	edit dl rm
BranchTimeslot.php	22186	0644	edit dl rm
Cart.php	146	0644	edit dl rm
Category.php	1597	0644	edit dl rm
CategoryLang.php	348	0644	edit dl rm
City.php	1167	0644	edit dl rm
CityLang.php	286	0644	edit dl rm
Cms.php	1396	0644	edit dl rm
CmsLang.php	410	0644	edit dl rm
Configuration.php	2688	0644	edit dl rm
ContactUs.php	508	0644	edit dl rm
Country.php	1188	0644	edit dl rm
CountryLang.php	301	0644	edit dl rm
Coupon.php	851	0644	edit dl rm
CouponLang.php	381	0644	edit dl rm
CouponUser.php	170	0644	edit dl rm
CouponVendor.php	178	0644	edit dl rm
CreditHistory.php	204	0644	edit dl rm
Cuisine.php	1248	0644	edit dl rm
CuisineLang.php	341	0644	edit dl rm
DeliveryArea.php	646	0644	edit dl rm
Deliveryboy.php	1361	0644	edit dl rm
DeliveryboyLang.php	321	0644	edit dl rm
DeliveryboyRequest.php	269	0644	edit dl rm
DeliveryboyRequestHistory.php	230	0644	edit dl rm
DeliveryChargeSetting.php	1040	0644	edit dl rm
EmailQueue.php	675	0644	edit dl rm
Enquiry.php	158	0644	edit dl rm
Faq.php	1306	0644	edit dl rm
FaqLang.php	291	0644	edit dl rm
Ingredient.php	1226	0644	edit dl rm
IngredientLang.php	337	0644	edit dl rm
Item.php	1977	0644	edit dl rm
ItemBottleRefundHistory.php	2305	0644	edit dl rm
ItemImage.php	296	0644	edit dl rm
ItemImportTrack.php	190	0644	edit dl rm
ItemIngredientGroup.php	1379	0644	edit dl rm
ItemIngredientGroupLang.php	379	0644	edit dl rm
ItemIngredientGroupMapping.php	238	0644	edit dl rm
ItemIngredientMapping.php	215	0644	edit dl rm
ItemLang.php	444	0644	edit dl rm
ItemMapping.php	575	0644	edit dl rm
ItemMappingGroup.php	272	0644	edit dl rm
ItemType.php	1269	0644	edit dl rm
ItemTypeDetails.php	190	0644	edit dl rm
ItemTypeLang.php	329	0644	edit dl rm
item_ingredient_group_mapping.php	246	0644	edit dl rm
Item_mapping.php	178	0644	edit dl rm
Language.php	1440	0644	edit dl rm
LoaylityPoint.php	598	0644	edit dl rm
LoginForm.php	1857	0644	edit dl rm
LoyalityPoint.php	599	0644	edit dl rm
LoyalityPointReference.php	218	0644	edit dl rm
MallProduct.php	1341	0644	edit dl rm
MallProductLang.php	190	0644	edit dl rm
Message.php	158	0644	edit dl rm
MetaTag.php	526	0644	edit dl rm
MobileTranslation.php	198	0644	edit dl rm
Newsletter.php	570	0644	edit dl rm
NewsletterSubscriber.php	597	0644	edit dl rm
NodeOrder.php	166	0644	edit dl rm
Notification.php	1505	0644	edit dl rm
Order.php	28635	0644	edit dl rm
OrderCoupon.php	898	0644	edit dl rm
OrderCouponLang.php	190	0644	edit dl rm
OrderItem.php	915	0644	edit dl rm
OrderItemImage.php	186	0644	edit dl rm
OrderItemIngredientGroup.php	901	0644	edit dl rm
OrderItemIngredientGroupLang.php	242	0644	edit dl rm
OrderItemIngredientMapping.php	234	0644	edit dl rm
OrderItemIngredientMappingLang.php	250	0644	edit dl rm
OrderItemLang.php	182	0644	edit dl rm
OrderMallProduct.php	1436	0644	edit dl rm
OrderMallProductLang.php	210	0644	edit dl rm
OrderParcel.php	3805	0644	edit dl rm
OrderParcelItemImage.php	210	0644	edit dl rm
OrderPromotion.php	1608	0644	edit dl rm
OrderPromotionLang.php	202	0644	edit dl rm
OrderSubscription.php	665	0644	edit dl rm
OrderSubscriptionItem.php	214	0644	edit dl rm
OrderTax.php	162	0644	edit dl rm
OrderTaxLang.php	178	0644	edit dl rm
OtpTemp.php	268	0644	edit dl rm
ParcelItemType.php	973	0644	edit dl rm
ParcelItemTypeLang.php	202	0644	edit dl rm
PointHistory.php	178	0644	edit dl rm
Post.php	496	0644	edit dl rm
PostImage.php	166	0644	edit dl rm
Promotion.php	1570	0644	edit dl rm
PromotionLang.php	182	0644	edit dl rm
Role.php	546	0644	edit dl rm
SourceMessage.php	182	0644	edit dl rm
SubscriptionLog.php	1380	0644	edit dl rm
Tax.php	1142	0644	edit dl rm
TaxLang.php	158	0644	edit dl rm
TimeZone.php	162	0644	edit dl rm
TodaySpecial.php	1508	0644	edit dl rm
TodaySpecialLang.php	194	0644	edit dl rm
Topup.php	533	0644	edit dl rm
TopupHistory.php	682	0644	edit dl rm
Unit.php	1934	0644	edit dl rm
UnitLang.php	298	0644	edit dl rm
User.php	9570	0644	edit dl rm
UserAddress.php	2167	0644	edit dl rm
UserAddressLang.php	190	0644	edit dl rm
UserEmptyBottleRefundRequest.php	242	0644	edit dl rm
UserFavourite.php	306	0644	edit dl rm
UserFriendList.php	186	0644	edit dl rm
UserLevel.php	565	0644	edit dl rm
UserNotification.php	194	0644	edit dl rm
UserPromotion.php	3075	0644	edit dl rm
UserPromotionBranch.php	206	0644	edit dl rm
UserPromotionLang.php	388	0644	edit dl rm
UserPromotionUser.php	198	0644	edit dl rm
UserReminder.php	620	0644	edit dl rm
Vendor.php	9928	0644	edit dl rm
VendorBank.php	549	0644	edit dl rm
VendorCategory.php	186	0644	edit dl rm
VendorCuisine.php	182	0644	edit dl rm
VendorLang.php	386	0644	edit dl rm
VendorType.php	1327	0644	edit dl rm
VendorTypeDetail.php	194	0644	edit dl rm
VendorTypeLang.php	343	0644	edit dl rm
WalletTransaction.php	3564	0644	edit dl rm

Edit: /var/www/vhosts/nabawater/common/models/Item.php (1977B)

<?php

namespace common\models;

use common\models\base\BaseItem;
use yii\db\ActiveQuery;
use common\components\AttributeKeyGeneratorBehaviour;
use Yii;

/**
 * Class Item
 * @package common\models
 */
class Item extends BaseItem
{
    const IS_RECOMMENDED = 1;
    const NOT_RECOMMENDED = 0;
    const IS_APPROVED = 1;
    CONST NOT_APPROVED = 0;

const PURCHASE_TYPE_DIRECT = 1;
    const PURCHASE_TYPE_BULK = 2;

const LARGE_IMAGE_WIDTH = 1000;

/**
    *
    * @var string 
    */
    public $item_name, $item_description, $item_short_desc;  
    
    /**
    * 
    * @param ActiveQuery $query
    * @param string $alias
    * @param string $language
    */
    public static function selectTranslation(ActiveQuery $query, $alias = 'I', $language = null)
    {
        if ($language === null) {
            $language = Yii::$app->language;
        }
        $langAlias = "{$alias}L";
        $query->leftJoin(
            [$langAlias => ItemLang::tableName()] ,
            "$langAlias.item_id = $alias.item_id AND $langAlias.language_code = :lang", 
            [':lang' => $language]
        )->addSelect([
            "$langAlias.item_name",
            "$langAlias.item_description",
            "$langAlias.item_short_desc",
        ]);
    }
    
    /**
    * @return array
    */
    public function behaviors()
    {
        $behaviors = parent::behaviors();
        $behaviors[] = [
            'class' => AttributeKeyGeneratorBehaviour::class,
            'attributes' => [
                'item_key'
            ]
        ];
        return $behaviors;
    }
    
    
    public static function getItemName($itemKey)
    {
        $query = Item::find()
                ->select(['I.*'])
                ->alias('I')
                ->where(['I.item_key' => $itemKey]);
        
        self::selectTranslation($query);
        
        $result = $query->one();
        
        return ($result != null) ? $result->item_name : '';
    }
    
}

language; } $langAlias = "{$alias}L"; $query->leftJoin( [$langAlias => ItemLang::tableName()] , "$langAlias.item_id = $alias.item_id AND $langAlias.language_code = :lang", [':lang' => $language] )->addSelect([ "$langAlias.item_name", "$langAlias.item_description", "$langAlias.item_short_desc", ]); } /** * @return array */ public function behaviors() { $behaviors = parent::behaviors(); $behaviors[] = [ 'class' => AttributeKeyGeneratorBehaviour::class, 'attributes' => [ 'item_key' ] ]; return $behaviors; } public static function getItemName($itemKey) { $query = Item::find() ->select(['I.*']) ->alias('I') ->where(['I.item_key' => $itemKey]); self::selectTranslation($query); $result = $query->one(); return ($result != null) ? $result->item_name : ''; } }