FM / models

/var/www/vhosts/nabawater/backend/models/

/var/www/vhosts/nabawater/backend/models

Name	Size	Mode	Actions
.gitkeep	2	0644	edit dl rm
ActivityLog.php	5248	0644	edit dl rm
ActivityLogSearch.php	1523	0644	edit dl rm
AddressType.php	684	0644	edit dl rm
AddressTypeLang.php	561	0644	edit dl rm
AddressTypeSearch.php	1499	0644	edit dl rm
AdminOrderReportSearch.php	2621	0644	edit dl rm
AdminUser.php	5912	0644	edit dl rm
AdminUserChangePasswordForm.php	2250	0644	edit dl rm
AdminUserSearch.php	1417	0644	edit dl rm
AdsSearch.php	2730	0644	edit dl rm
Area.php	3705	0644	edit dl rm
AreaLang.php	514	0644	edit dl rm
AreaSearch.php	1813	0644	edit dl rm
Banner.php	1163	0644	edit dl rm
BannerLang.php	386	0644	edit dl rm
BannerSearch.php	1250	0644	edit dl rm
BannerUploadForm.php	1313	0644	edit dl rm
Branch.php	18932	0644	edit dl rm
BranchDeliveryArea.php	547	0644	edit dl rm
BranchImage.php	1879	0644	edit dl rm
BranchLang.php	754	0644	edit dl rm
BranchReview.php	1770	0644	edit dl rm
BranchReviewSearch.php	3272	0644	edit dl rm
BranchSearch.php	2804	0644	edit dl rm
BranchTimeslot.php	156	0644	edit dl rm
BranchUploadForm.php	1275	0644	edit dl rm
Cart.php	125	0644	edit dl rm
Category.php	3968	0644	edit dl rm
CategoryLang.php	1881	0644	edit dl rm
CategorySearch.php	2304	0644	edit dl rm
CategoryUploadForm.php	1232	0644	edit dl rm
City.php	1362	0644	edit dl rm
CityLang.php	516	0644	edit dl rm
CitySearch.php	1665	0644	edit dl rm
Cms.php	2449	0644	edit dl rm
CmsLang.php	1074	0644	edit dl rm
CmsSearch.php	1433	0644	edit dl rm
Configuration.php	20664	0644	edit dl rm
ConfigurationUploadForm.php	1084	0644	edit dl rm
ContactUs.php	140	0644	edit dl rm
Country.php	1988	0644	edit dl rm
CountryLang.php	538	0644	edit dl rm
CountrySearch.php	1554	0644	edit dl rm
Coupon.php	2694	0644	edit dl rm
CouponLang.php	588	0644	edit dl rm
CouponSearch.php	2685	0644	edit dl rm
CouponUploadForm.php	551	0644	edit dl rm
CouponUser.php	701	0644	edit dl rm
CouponVendor.php	729	0644	edit dl rm
CreditHistory.php	453	0644	edit dl rm
CreditHistorySearch.php	1163	0644	edit dl rm
Cuisine.php	1599	0644	edit dl rm
CuisineLang.php	1648	0644	edit dl rm
CuisineSearch.php	1680	0644	edit dl rm
CuisineUploadForm.php	1217	0644	edit dl rm
DeliveryArea.php	1381	0644	edit dl rm
DeliveryAreaSearch.php	1299	0644	edit dl rm
DeliveryBoy.php	335	0664	edit dl rm
Deliveryboy.php	335	0644	edit dl rm
DeliveryboyLang.php	522	0644	edit dl rm
DeliveryboyRequest.php	168	0644	edit dl rm
DeliveryboyRequestHistory.php	188	0644	edit dl rm
DeliveryboySearch.php	1983	0644	edit dl rm
DeliveryboyUploadForm.php	581	0644	edit dl rm
DeliveryChargeSetting.php	2749	0644	edit dl rm
DeliveryChargeSettingSearch.php	2127	0644	edit dl rm
DriverOrderSearch.php	6823	0644	edit dl rm
EmailQueue.php	143	0644	edit dl rm
Enquiry.php	854	0644	edit dl rm
EnquirySearch.php	1613	0644	edit dl rm
Faq.php	772	0644	edit dl rm
FaqLang.php	1845	0644	edit dl rm
FaqLangSearch.php	1724	0644	edit dl rm
FaqSearch.php	1975	0644	edit dl rm
Ingredient.php	2016	0644	edit dl rm
IngredientLang.php	1956	0644	edit dl rm
IngredientSearch.php	2353	0644	edit dl rm
Item.php	8218	0644	edit dl rm
ItemBottleRefundHistory.php	231	0644	edit dl rm
ItemBottleRefundHistorySearch.php	2219	0644	edit dl rm
ItemFileUploadForm.php	669	0644	edit dl rm
ItemImage.php	484	0644	edit dl rm
ItemImport.php	868	0644	edit dl rm
ItemImportTrack.php	158	0644	edit dl rm
ItemIngredientGroup.php	5851	0644	edit dl rm
ItemIngredientGroupLang.php	1889	0644	edit dl rm
ItemIngredientGroupMapping.php	192	0644	edit dl rm
ItemIngredientGroupSearch.php	2387	0644	edit dl rm
ItemIngredientMapping.php	424	0644	edit dl rm
ItemLang.php	3057	0644	edit dl rm
ItemMapping.php	8785	0644	edit dl rm
ItemMappingGroup.php	732	0644	edit dl rm
ItemMappingSearch.php	2448	0644	edit dl rm
ItemSearch.php	3541	0644	edit dl rm
ItemType.php	1357	0644	edit dl rm
ItemTypeDetails.php	592	0644	edit dl rm
ItemTypeLang.php	1634	0644	edit dl rm
ItemTypeSearch.php	1465	0644	edit dl rm
ItemUploadForm.php	1182	0644	edit dl rm
item_ingredient_group_mapping.php	200	0644	edit dl rm
Item_mapping.php	149	0644	edit dl rm
Item_mapping_group.php	167	0644	edit dl rm
Language.php	354	0644	edit dl rm
LanguageSearch.php	1841	0644	edit dl rm
LoginForm.php	2790	0644	edit dl rm
LoyalityPoint.php	1272	0644	edit dl rm
LoyalityPointReference.php	1367	0644	edit dl rm
LoyalityPointSearch.php	1901	0644	edit dl rm
MallProduct.php	712	0644	edit dl rm
MallProductLang.php	459	0644	edit dl rm
MallProductSearch.php	1549	0644	edit dl rm
MallProductUploadForm.php	1221	0644	edit dl rm
Message.php	134	0644	edit dl rm
MetaTag.php	831	0644	edit dl rm
MetaTagSearch.php	1577	0644	edit dl rm
MobileTranslation.php	164	0644	edit dl rm
MobileTranslationSearch.php	1014	0644	edit dl rm
Newsletter.php	1634	0644	edit dl rm
NewsletterSearch.php	1497	0644	edit dl rm
NewsletterSubscriber.php	402	0644	edit dl rm
NewsletterSubscriberSearch.php	1372	0644	edit dl rm
NewsletterUploadForm.php	1202	0644	edit dl rm
NodeOrder.php	140	0644	edit dl rm
Notification.php	1029	0644	edit dl rm
NotificationSearch.php	1768	0644	edit dl rm
NotificationUploadForm.php	1260	0644	edit dl rm
old_VendorOrderReportSearch.php	2376	0644	edit dl rm
Order.php	53005	0644	edit dl rm
OrderCoupon.php	146	0644	edit dl rm
OrderCouponLang.php	158	0644	edit dl rm
OrderDetails.php	501	0644	edit dl rm
OrderItem.php	140	0644	edit dl rm
OrderItemImage.php	155	0644	edit dl rm
OrderItemIngredientGroup.php	185	0644	edit dl rm
OrderItemIngredientGroupLang.php	197	0644	edit dl rm
OrderItemIngredientMapping.php	191	0644	edit dl rm
OrderItemIngredientMappingLang.php	203	0644	edit dl rm
OrderItemLang.php	152	0644	edit dl rm
OrderMallProduct.php	2247	0644	edit dl rm
OrderMallProductLang.php	173	0644	edit dl rm
OrderMallProductSearch.php	2452	0644	edit dl rm
OrderParcel.php	3315	0644	edit dl rm
OrderParcelItemImage.php	173	0644	edit dl rm
OrderParcelSearch.php	1680	0644	edit dl rm
OrderPromotion.php	155	0644	edit dl rm
OrderPromotionLang.php	167	0644	edit dl rm
OrderSearch.php	51207	0644	edit dl rm
OrderSubscription.php	164	0644	edit dl rm
OrderSubscriptionItem.php	176	0644	edit dl rm
OrderTax.php	137	0644	edit dl rm
OrderTaxLang.php	149	0644	edit dl rm
OtpTemp.php	134	0644	edit dl rm
ParcelItemType.php	1468	0644	edit dl rm
ParcelItemTypeLang.php	423	0644	edit dl rm
ParcelItemTypeSearch.php	1163	0644	edit dl rm
PointHistory.php	149	0644	edit dl rm
Post.php	125	0644	edit dl rm
PostImage.php	140	0644	edit dl rm
ProductUploadForm.php	862	0644	edit dl rm
Promotion.php	1097	0644	edit dl rm
PromotionLang.php	1286	0644	edit dl rm
PromotionSearch.php	2541	0644	edit dl rm
PromotionUploadForm.php	1226	0644	edit dl rm
PushNotification.php	1326	0644	edit dl rm
Role.php	684	0644	edit dl rm
RoleSearch.php	1656	0644	edit dl rm
SourceMessage.php	152	0644	edit dl rm
Tax.php	589	0644	edit dl rm
TaxLang.php	388	0644	edit dl rm
TaxSearch.php	1588	0644	edit dl rm
TimeZone.php	1037	0644	edit dl rm
TodaySpecial.php	1606	0644	edit dl rm
TodaySpecialLang.php	442	0644	edit dl rm
TodaySpecialSearch.php	1842	0644	edit dl rm
TodaySpecialUploadForm.php	1867	0644	edit dl rm
TopOrderItemReportSearch.php	3226	0644	edit dl rm
Topup.php	836	0644	edit dl rm
TopupHistory.php	149	0644	edit dl rm
TopupSearch.php	1538	0644	edit dl rm
Unit.php	2187	0644	edit dl rm
UnitLang.php	1862	0644	edit dl rm
UnitSearch.php	1718	0644	edit dl rm
User.php	9177	0644	edit dl rm
UserAddress.php	1185	0644	edit dl rm
UserAddressLang.php	961	0644	edit dl rm
UserEmptyBottleRefundRequest.php	246	0644	edit dl rm
UserEmptyBottleRefundRequestSearch.php	1688	0644	edit dl rm
UserFavourite.php	152	0644	edit dl rm
UserFriendList.php	155	0644	edit dl rm
UserLevel.php	877	0644	edit dl rm
UserLevelSearch.php	1551	0644	edit dl rm
UserNotification.php	815	0644	edit dl rm
UserPromotion.php	4781	0644	edit dl rm
UserPromotionBranch.php	722	0644	edit dl rm
UserPromotionLang.php	2097	0644	edit dl rm
UserPromotionSearch.php	1853	0644	edit dl rm
UserPromotionUser.php	713	0644	edit dl rm
UserReminder.php	149	0644	edit dl rm
UserSearch.php	2492	0644	edit dl rm
Vendor.php	22248	0644	edit dl rm
VendorBank.php	1396	0644	edit dl rm
VendorBankSearch.php	2237	0644	edit dl rm
VendorCategory.php	590	0644	edit dl rm
VendorCuisine.php	578	0644	edit dl rm
VendorLang.php	532	0644	edit dl rm
VendorOrderReportSearch.php	2943	0644	edit dl rm
VendorPaymentSearch.php	3047	0644	edit dl rm
VendorSearch.php	3421	0644	edit dl rm
VendorType.php	1666	0644	edit dl rm
VendorTypeDetail.php	631	0644	edit dl rm
VendorTypeLang.php	582	0644	edit dl rm
VendorTypeSearch.php	1494	0644	edit dl rm
VendorTypeUploadForm.php	1213	0644	edit dl rm
VendorUploadForm.php	1275	0644	edit dl rm
WalletTransaction.php	164	0644	edit dl rm
WalletTransactionSearch.php	2320	0644	edit dl rm
WebpushNotification.php	4373	0644	edit dl rm

Edit: /var/www/vhosts/nabawater/backend/models/AreaSearch.php (1813B)

<?php

namespace backend\models;

use Yii;
use yii\data\ActiveDataProvider;
use common\helpers\Com;

/**
 * Class  AreaSearch
 * @package backend/models
 */
class AreaSearch extends Area
{
    /**
     * 
     * @return array
     */
    public function rules()
    {    
        return [
            [['area_status', 'area_name','city_name','country_name'], 'safe']
        ];
    }
    
    /**
     * 
     * @param type $params
     * @return ActiveDataProvider
     */
    public function search($params)
    {
        $query = Area::find()
            ->alias('C')
            ->select(['C.*','CLang.country_name','CityLang.city_name'])
            ->leftJoin(['CLang' => CountryLang::tableName()], 'CLang.country_id = C.country_id')
            ->leftJoin(['CityLang' => CityLang::tableName()], 'CityLang.city_id = C.city_id')
            ->where(['<>', 'C.area_status', Area::DELETE]);

Area::selectTranslation($query);
        
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'PageSize' => Com::postPerPage(),
            ],
            'sort' => [
                'attributes' => [
                    'area_name'
                ],
                'defaultOrder' => SORT_ASC
            ]
        ]);
      
        $this->load($params);
        if(!$this->validate()) {
            return $dataProvider;
        }  
        
        $query->andFilterWhere(['like', 'CL.area_name', strtolower($this->area_name)])
              ->andFilterWhere(['like', 'CLang.country_name', $this->country_name])
              ->andFilterWhere(['like', 'CityLang.city_name', $this->city_name])
              ->andFilterWhere(['like', 'C.area_status', $this->area_status]);
            
        return $dataProvider;   
    }  
}

alias('C') ->select(['C.*','CLang.country_name','CityLang.city_name']) ->leftJoin(['CLang' => CountryLang::tableName()], 'CLang.country_id = C.country_id') ->leftJoin(['CityLang' => CityLang::tableName()], 'CityLang.city_id = C.city_id') ->where(['<>', 'C.area_status', Area::DELETE]); Area::selectTranslation($query); $dataProvider = new ActiveDataProvider([ 'query' => $query, 'pagination' => [ 'PageSize' => Com::postPerPage(), ], 'sort' => [ 'attributes' => [ 'area_name' ], 'defaultOrder' => SORT_ASC ] ]); $this->load($params); if(!$this->validate()) { return $dataProvider; } $query->andFilterWhere(['like', 'CL.area_name', strtolower($this->area_name)]) ->andFilterWhere(['like', 'CLang.country_name', $this->country_name]) ->andFilterWhere(['like', 'CityLang.city_name', $this->city_name]) ->andFilterWhere(['like', 'C.area_status', $this->area_status]); return $dataProvider; } }