Esempio n. 1
0
 /**
  * Get list of link siblings
  * @return array
  */
 public function getSiblings()
 {
     $siblings = MenuLink::find()->joinWith('translations')->andFilterWhere(['like', 'menu_id', $this->menu_id])->andFilterWhere(['!=', 'menu_link.id', $this->id])->all();
     $list = ArrayHelper::map($siblings, 'id', function ($array, $default) {
         return $array->label . ' [' . $array->id . ']';
     });
     return ArrayHelper::merge([NULL => Yii::t('yee', 'No Parent')], $list);
 }
 public function actionSaveOrders()
 {
     if (Yii::$app->getRequest()->isAjax) {
         $n = 1;
         $params = [];
         $select = [];
         $db = Yii::$app->db;
         $settings = Yii::$app->getRequest()->post('settings');
         foreach ($settings as $setting) {
             $select[] = "SELECT :id_{$n} as 'id', :order_{$n} as 'order', :parent_{$n} as 'parent_id'";
             $params[":id_{$n}"] = $setting[0];
             $params[":order_{$n}"] = (int) $setting[1];
             $params[":parent_{$n}"] = isset($setting[2]) ? $setting[2] : '';
             $n++;
         }
         $select = implode(' UNION ', $select);
         $menuLinkTable = MenuLink::tableName();
         $db->createCommand("UPDATE {$menuLinkTable} m INNER JOIN ({$select})t ON m.id=t.id " . " SET m.order=t.order, m.parent_id=t.parent_id", $params)->execute();
     }
     return false;
 }
Esempio n. 3
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params = [])
 {
     $queryParams = Yii::$app->request->getQueryParams();
     $query = MenuLink::find()->joinWith('translations');
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => -1], 'sort' => ['defaultOrder' => ['order' => SORT_ASC]]]);
     $this->load($queryParams);
     foreach ($params as $key => $value) {
         $this->{$key} = $value;
     }
     $restrictLinkAccess = YeeHelper::isImplemented(MenuLink::className(), OwnerAccess::CLASSNAME) && !User::hasPermission(MenuLink::getFullAccessPermission());
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     if ($restrictLinkAccess) {
         $query->andFilterWhere([MenuLink::getOwnerField() => Yii::$app->user->identity->id]);
     }
     $query->andWhere(['menu_id' => $this->menu_id])->andFilterWhere(['alwaysVisible' => $this->alwaysVisible])->andFilterWhere(['like', 'id', $this->id])->andWhere(['parent_id' => $this->parent_id]);
     return $dataProvider;
 }
Esempio n. 4
0
 /**
  * @return \omgdef\multilingual\MultilingualQuery
  */
 public function getLinks()
 {
     return $this->hasMany(MenuLink::className(), ['menu_id' => 'id'])->joinWith('translations');
 }