/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Restaurant::find(); if ($params['id']) { $query = Restaurant::find()->where('status!=0 and state !=4'); } $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['defaultOrder' => ['updatedOn' => SORT_DESC]]); //$query->andWhere("not ((`state`=".AppActiveRecord::STATUS_DRAFT.") AND (`createdBy`!=".\yii::$app->user->id."))"); if (!($this->load($params) && $this->validate())) { $query->andFilterWhere(['NOT', ['state' => AppActiveRecord::STATUS_DELETE]]); return $dataProvider; } if ($this->state !== null) { if ($this->state == AppActiveRecord::STATUS_DRAFT) { $query->andFilterWhere(['state' => $this->state, 'createdBy' => \yii::$app->user->id]); } else { $query->andFilterWhere(['state' => $this->state]); } } else { $query->andFilterWhere(['NOT', ['state' => AppActiveRecord::STATUS_DELETE]]); } $query->andFilterWhere(['Id' => $this->Id, 'sourceId' => $this->sourceId, 'chainId' => $this->chainId, 'cityId' => $this->cityId, 'localityId' => $this->localityId, 'zoneId' => $this->zoneId, 'pin' => $this->pin, 'entityType' => $this->entityType, 'gpsLat' => $this->gpsLat, 'gpsLong' => $this->gpsLong, 'priceForTwo' => $this->priceForTwo, 'capacity' => $this->capacity, 'coverFee' => $this->coverFee, 'entryFee' => $this->entryFee, 'ladiesFee' => $this->ladiesFee, 'hotelId' => $this->hotelId, 'status' => $this->status, 'healthStatus' => $this->healthStatus, 'popularityScore' => $this->popularityScore, 'popularityScroreParams' => $this->popularityScroreParams, 'createdBy' => $this->createdBy, 'updatedBy' => $this->updatedBy, 'createdOn' => $this->createdOn, 'updatedOn' => $this->updatedOn, 'popularpubs' => $this->popularpubs, 'launchdate' => $this->launchdate]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'landmark', $this->landmark])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'alias', $this->alias])->andFilterWhere(['like', 'tollfree', $this->tollfree])->andFilterWhere(['like', 'phoneAlias', $this->phoneAlias])->andFilterWhere(['like', 'website', $this->website])->andFilterWhere(['like', 'facebook', $this->facebook])->andFilterWhere(['like', 'owner', $this->owner])->andFilterWhere(['like', 'manager', $this->manager])->andFilterWhere(['like', 'tips', $this->tips])->andFilterWhere(['like', 'famousFor', $this->famousFor])->andFilterWhere(['like', 'guid', $this->guid])->andFilterWhere(['like', 'old_guid', $this->old_guid])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'ip', $this->ip])->andFilterWhere(['like', 'specialities', $this->specialities]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Restaurant::find()->where('status=0'); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['Id' => $this->Id, 'sourceId' => $this->sourceId, 'chainId' => $this->chainId, 'cityId' => $this->cityId, 'localityId' => $this->localityId, 'zoneId' => $this->zoneId, 'pin' => $this->pin, 'entityType' => $this->entityType, 'gpsLat' => $this->gpsLat, 'gpsLong' => $this->gpsLong, 'priceForTwo' => $this->priceForTwo, 'capacity' => $this->capacity, 'coverFee' => $this->coverFee, 'entryFee' => $this->entryFee, 'ladiesFee' => $this->ladiesFee, 'hotelId' => $this->hotelId, 'status' => $this->status, 'healthStatus' => $this->healthStatus, 'popularityScore' => $this->popularityScore, 'popularityScroreParams' => $this->popularityScroreParams, 'createdBy' => $this->createdBy, 'updatedBy' => $this->updatedBy, 'createdOn' => $this->createdOn, 'updatedOn' => $this->updatedOn, 'popularpubs' => $this->popularpubs, 'launchdate' => $this->launchdate]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'landmark', $this->landmark])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'alias', $this->alias])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'mobile', $this->mobile])->andFilterWhere(['like', 'tollfree', $this->tollfree])->andFilterWhere(['like', 'phoneAlias', $this->phoneAlias])->andFilterWhere(['like', 'website', $this->website])->andFilterWhere(['like', 'facebook', $this->facebook])->andFilterWhere(['like', 'owner', $this->owner])->andFilterWhere(['like', 'manager', $this->manager])->andFilterWhere(['like', 'tips', $this->tips])->andFilterWhere(['like', 'famousFor', $this->famousFor])->andFilterWhere(['like', 'guid', $this->guid])->andFilterWhere(['like', 'old_guid', $this->old_guid])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'ip', $this->ip])->andFilterWhere(['like', 'specialities', $this->specialities]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getRestaurants() { return $this->hasMany(Restaurant::className(), ['sourceId' => 'id']); }
<?php echo $form->field($modelBrandsCityField, 'name')->checkbox(['label' => 'Lock']); ?> <?php echo $form->field($model, 'website')->textInput(['maxlength' => 225]); ?> <?php echo $form->field($modelBrandsCityField, 'website')->checkbox(['label' => 'Lock']); ?> <?php echo $form->field($model, 'pricefortwo')->dropDownList(ArrayHelper::merge(['' => 'Select'], \common\models\Restaurant::priceForTwo())); ?> <?php echo $form->field($modelBrandsCityField, 'pricefortwo')->checkbox(['label' => 'Lock']); ?> <?php /*/?><?= $form->field($model, 'cuisine')->dropDownList(ArrayHelper::merge([],ArrayHelper::map(\common\models\Cuisine::find()->andWhere(['status' => 1])->All(), 'Id', 'name')),['multiple'=>'multiple','size'=>7,'title'=>'Select Cuisines']) ?> <?php //*/ ?> <?php echo $form->field($model, 'cuisine')->widget(Multiselect::className(), ['data' => ArrayHelper::merge([], ArrayHelper::map(\common\models\Cuisine::find()->andWhere(['status' => 1])->All(), 'Id', 'name')), 'options' => ['multiple' => 'multiple', 'size' => 7, 'title' => 'Select Cuisines']]); ?>
public function actionChainrestaurant() { \yii::$app->user->setIdentity(\common\models\User::findByUsername('admin')); $usersData = \yii::$app->oldcmsdb->createCommand("SELECT est_id, est_est_grp_id\n FROM \n tc_establishments order by est_id")->query(); while ($row = $usersData->read()) { $attributes = array('Id' => $row['est_id'], 'chainId' => $row['est_est_grp_id'], 'createdBy' => 40, 'updatedBy' => 40, 'status' => 1); //print_r($attributes); //echo "\n"; if (($restaurant = Restaurant::findOne($attributes['Id'])) !== null) { $restaurant->detachBehavior('timestamp'); $restaurant->detachBehavior('user'); $restaurant->setAttributes($attributes); //$restaurant->Id = $attributes['Id']; if ($restaurant->update(false) !== false) { echo "restaurant Id:" . $attributes['Id'] . ": imported\n"; } else { echo "restaurant Id:" . $attributes['Id'] . ": not imported\n"; } } else { //echo "restaurant Id:".$attributes['Id'].": not available\n"; } } }
/** * @return \yii\db\ActiveQuery */ public function getRestaurants() { return $this->hasMany(Restaurant::className(), ['hotelId' => 'Id']); }
protected function findRestaurantModel($id) { if (($model = Restaurant::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getRestaurant() { return $this->hasOne(Restaurant::className(), ['Id' => 'restaurantID']); }
public function actionLoadchain() { Yii::$app->response->format = Response::FORMAT_JSON; $model = new Restaurant(); $map = new \common\models\ResMap(); if ($model->load(Yii::$app->request->post())) { $chaindata = $model->chainCity; $chainmapstatus = $chaindata->chainFieldStatusMaps; \yii::trace(print_r($chainmapstatus, true)); $finalmap = []; foreach ($model->chainFieldMap() as $map) { $map['id'] = \yii\helpers\BaseHtml::getInputId($model, $map['id']); $map['lock'] = $chainmapstatus->{$map['value']}; $map['value'] = $chaindata->{$map['value']}; $finalmap[] = $map; } return ['responce' => ['map' => $finalmap]]; } else { return ['responce' => 'false']; } }
/** * * @param string $q * @return JSON encoded associative array of suggested venue * @author Atul */ public function actionFetchVenue($q = null, $cityId = 0, $type = 0) { Yii::$app->response->format = Response::FORMAT_JSON; if ($type == 0) { $query = Restaurant::find()->with('city', 'locality', 'zone'); } else { $query = \common\models\Venue::find()->with('city', 'locality', 'zone'); } if (!empty($cityId)) { if ($cityId) { $query->andFilterWhere(['cityId' => $cityId]); } if ($q) { $query->andFilterWhere(['like', 'name', $q . '%', false]); } //*/ $query->andFilterWhere(['status' => \common\component\AppActiveRecord::STATUS_PUBLISH]); //*/ $dataProvider = new \yii\data\ActiveDataProvider(['query' => $query]); $data = []; foreach ($dataProvider->getModels() as $model) { $NameString = $model->name . ' in ' . $model->localityname . ' ' . $model->cityname . '(' . $model->zonename . ')'; $data[] = ['id' => $model->Id, 'value' => $NameString]; } return $data; } }
public function getEst() { return $this->hasOne(Restaurant::className(), ['Id' => 'estId']); }
public function AddRestaurants($restaurantIds) { $db = static::getDb(); $transaction = $db->beginTransaction(); $restaurantAr = []; try { foreach ($restaurantIds as $values) { $restaurantAr[] = $model = Restaurant::findOne($values); $model->alocateChain($this, false); } $transaction->commit(); try { foreach ($restaurantAr as $resmodel) { $resmodel->published(); } } catch (\Exception $e) { \yii::trace($e->getMessage()); return false; } } catch (\Exception $e) { \yii::trace($e->getMessage()); $transaction->rollBack(); return false; } }
/** * @return \yii\db\ActiveQuery */ public function getRestaurants() { return $this->hasMany(Restaurant::className(), ['chainId' => 'chainId'])->via('chainCityMaps'); }