PHP Category::find方法代码示例

 public function run()
 {
     $query = Category::find();
     $query->andWhere([Category::tableName() . '.active' => 1]);
     if ($this->root_category_id !== null) {
         $query->andWhere([Category::tableName() . '.parent_id' => $this->root_category_id]);
     }
     if ($this->category_group_id !== null) {
         $query->andWhere([Category::tableName() . '.category_group_id' => $this->category_group_id]);
     }
     $query->groupBy(Category::tableName() . ".id");
     $query->orderBy($this->sort);
     if ($this->limit !== null) {
         $query->limit($this->limit);
     }
     $object = Object::getForClass(Category::className());
     \app\properties\PropertiesHelper::appendPropertiesFilters($object, $query, $this->values_by_property_id, []);
     $sql = $query->createCommand()->getRawSql();
     $cacheKey = "FilteredCategoriesWidget:" . md5($sql);
     $result = Yii::$app->cache->get($cacheKey);
     if ($result === false) {
         $categories = Category::findBySql($sql)->all();
         $result = $this->render($this->viewFile, ['categories' => $categories]);
         Yii::$app->cache->set($cacheKey, $result, 86400, new \yii\caching\TagDependency(['tags' => ActiveRecordHelper::getCommonTag(Category::tableName())]));
     }
     return $result;
 }

 protected function categoriesSitemap($parentId = 0, $prefix = '')
 {
     $categories = Category::find()->select(['id', 'category_group_id', 'slug'])->where(['parent_id' => $parentId, 'active' => 1])->asArray(true)->all();
     array_reduce($categories, function ($carry, $item) use($prefix) {
         $this->sitemap->addUrl($prefix . '/' . $item['slug']);
         $this->categoriesSitemap($item['id'], $prefix . '/' . $item['slug']);
         $this->productsSitemap($item['id'], $prefix . '/' . $item['slug']);
     });
 }

 protected static function getProductType(Product $model)
 {
     if (!isset(self::$breadcrumbsData[$model->main_category_id])) {
         $parentIds = $model->getMainCategory()->getParentIds();
         $breadcrumbs = [];
         foreach ($parentIds as $id) {
             $breadcrumbs[] = Category::find()->select(['name'])->where(['id' => $id])->asArray()->scalar();
         }
         $breadcrumbs[] = $model->getMainCategory()->name;
         self::$breadcrumbsData[$model->main_category_id] = $breadcrumbs;
     }
     return htmlspecialchars(implode(' > ', self::$breadcrumbsData[$model->main_category_id]));
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Category::find();
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false, 'sort' => new \yii\data\Sort(['attributes' => ['name']])]);
     $this->load($params);
     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;
     }
     $query->andFilterWhere(['id' => $this->id, 'parent_id' => $this->parent_id]);
     $query->andFilterWhere(['like', 'name', $this->name]);
     $query->andFilterWhere(['like', 'text', $this->text]);
     return $dataProvider;
 }

 public static function buildTextTree($id = null, $level = 1, $ban = [])
 {
     $return = [];
     $prefix = str_repeat('--', $level);
     $level++;
     if (empty($id)) {
         $categories = Category::find()->where('parent_id = 0 OR parent_id is null')->orderBy('sort DESC')->asArray()->all();
     } else {
         $categories = Category::find()->where(['parent_id' => $id])->orderBy('sort DESC')->asArray()->all();
     }
     foreach ($categories as $category) {
         if (!in_array($category['id'], $ban)) {
             $return[$category['id']] = "{$prefix} {$category['name']}";
             $return = $return + self::buildTextTree($category['id'], $level, $ban);
         }
     }
     return $return;
 }

 /**
  * @inheritdoc
  */
 public function init()
 {
     if (!isset($this->url, $this->gridSelector)) {
         throw new InvalidParamException('Attribute \'url\' or \'gridSelector\' is not set');
     }
     if (true === empty($this->moveText)) {
         $this->moveText = Yii::t('app', 'Are you sure you want to move all selected products into');
     }
     if (true === empty($this->addText)) {
         $this->addText = Yii::t('app', 'Are you sure you want to add all selected products into');
     }
     if (!isset($this->htmlOptions['id'])) {
         $this->htmlOptions['id'] = '';
     }
     if (true === empty(static::$categories)) {
         $cc = Category::find()->select('id, name')->where(['active' => 1])->asArray(true)->all();
         foreach ($cc as $k => $cat) {
             static::$categories[$cat['id']] = $cat['name'];
         }
     }
 }

 /**
  * @deprecated
  * @param $category_group_id
  * @param int $level
  * @param int $is_active
  * @return Category[]
  */
 public static function getByLevel($category_group_id, $level = 0, $is_active = 1)
 {
     $cacheKey = "CategoriesByLevel:{$category_group_id}:{$level}";
     if (false === ($models = Yii::$app->cache->get($cacheKey))) {
         $models = Category::find()->where(['category_group_id' => $category_group_id, 'parent_id' => $level, 'active' => $is_active])->orderBy('sort_order')->with('images')->all();
         if (null !== $models) {
             $cache_tags = [];
             foreach ($models as $model) {
                 $cache_tags[] = ActiveRecordHelper::getObjectTag($model, $model->id);
             }
             $cache_tags[] = ActiveRecordHelper::getObjectTag(static::className(), $level);
             Yii::$app->cache->set($cacheKey, $models, 86400, new TagDependency(['tags' => $cache_tags]));
         }
     }
     foreach ($models as $model) {
         static::$identity_map[$model->id] = $model;
     }
     return $models;
 }

            <?php 
echo $form->field($model, 'content')->widget(Yii::$app->getModule('core')->wysiwyg_class_name(), Yii::$app->getModule('core')->wysiwyg_params());
?>

            <?php 
echo $form->field($model, 'sort_order');
?>

            <?php 
echo $form->field($model, 'date_added')->widget(DateTimePicker::classname(), ['pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-mm-dd hh:ii', 'todayHighlight' => true, 'todayBtn' => true]]);
?>

            <?php 
if ($model->isNewRecord === false) {
    echo $form->field($model, 'parent_id')->dropDownList(ArrayHelper::merge([0 => Yii::t('app', 'Root')], ArrayHelper::map(\app\modules\shop\models\Category::find()->where('id != :id', ['id' => $model->id])->all(), 'id', 'name')));
}
?>
            <?php 
BackendWidget::end();
?>

            <?php 
BackendWidget::begin(['title' => Yii::t('app', 'Images'), 'icon' => 'image', 'footer' => $this->blocks['submit']]);
?>

            <div id="actions">
                <?php 
echo \yii\helpers\Html::tag('span', Icon::show('plus') . Yii::t('app', 'Add files..'), ['class' => 'btn btn-success fileinput-button']);
?>
                <?php 

 /**
  * @param null $id
  * @return string|\yii\web\Response
  * @throws NotFoundHttpException
  * @throws ServerErrorHttpException
  * @throws \Exception
  * @throws \yii\base\InvalidRouteException
  */
 public function actionEdit($id = null)
 {
     /*
      * @todo Продумать механизм сохранения изображений для нового продукта.
      * Сейчас для нового продукта скрывается форма добавления изображений.
      */
     if (null === ($object = Object::getForClass(Product::className()))) {
         throw new ServerErrorHttpException();
     }
     /** @var null|Product|HasProperties|\devgroup\TagDependencyHelper\ActiveRecordHelper $model */
     $model = null;
     $parent = null;
     if (null === $id) {
         $model = new Product();
         $model->loadDefaultValues();
         $parent_id = Yii::$app->request->get('owner_id', 0);
         if (0 !== intval($parent_id) && null !== Product::findById($parent_id)) {
             $model->parent_id = $parent_id;
         }
         $model->measure_id = $this->module->defaultMeasureId;
     } else {
         $model = Product::findById($id, null);
         if (null !== $model && $model->parent_id > 0) {
             $parent = Product::findById($model->parent_id, null);
         }
     }
     if (null === $model) {
         throw new NotFoundHttpException();
     }
     $model->loadRelatedProductsArray();
     $event = new BackendEntityEditEvent($model);
     $this->trigger(self::EVENT_BACKEND_PRODUCT_EDIT, $event);
     $post = \Yii::$app->request->post();
     if ($event->isValid && $model->load($post)) {
         $saveStateEvent = new BackendEntityEditEvent($model);
         $this->trigger(self::EVENT_BACKEND_PRODUCT_EDIT_SAVE, $saveStateEvent);
         if ($model->validate()) {
             if (isset($post['GeneratePropertyValue'])) {
                 $generateValues = $post['GeneratePropertyValue'];
             } else {
                 $generateValues = [];
             }
             if (isset($post['PropertyGroup'])) {
                 $model->option_generate = Json::encode(['group' => $post['PropertyGroup']['id'], 'values' => $generateValues]);
             } else {
                 $model->option_generate = '';
             }
             $save_result = $model->save();
             $model->saveProperties($post);
             $model->saveRelatedProducts();
             if (null !== ($view_object = ViewObject::getByModel($model, true))) {
                 if ($view_object->load($post, 'ViewObject')) {
                     if ($view_object->view_id <= 0) {
                         $view_object->delete();
                     } else {
                         $view_object->save();
                     }
                 }
             }
             if ($save_result) {
                 $modelAfterSaveEvent = new BackendEntityEditEvent($model);
                 $this->trigger(self::EVENT_BACKEND_PRODUCT_AFTER_SAVE, $modelAfterSaveEvent);
                 $categories = isset($post['Product']['categories']) ? $post['Product']['categories'] : [];
                 $model->saveCategoriesBindings($categories);
                 $this->runAction('save-info', ['model_id' => $model->id]);
                 $model->invalidateTags();
                 $action = Yii::$app->request->post('action', 'save');
                 if (Yii::$app->request->post(HasProperties::FIELD_ADD_PROPERTY_GROUP) || Yii::$app->request->post(HasProperties::FIELD_REMOVE_PROPERTY_GROUP)) {
                     $action = 'save';
                 }
                 $returnUrl = Yii::$app->request->get('returnUrl', ['index']);
                 switch ($action) {
                     case 'next':
                         return $this->redirect(['edit', 'returnUrl' => $returnUrl, 'parent_id' => Yii::$app->request->get('parent_id', null)]);
                     case 'back':
                         return $this->redirect($returnUrl);
                     default:
                         return $this->redirect(Url::toRoute(['edit', 'id' => $model->id, 'returnUrl' => $returnUrl, 'parent_id' => $model->main_category_id]));
                 }
             } else {
                 Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot save data'));
             }
         } else {
             Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot save data'));
         }
     }
     $items = ArrayHelper::map(Category::find()->all(), 'id', 'name');
     return $this->render('product-form', ['object' => $object, 'model' => $model, 'items' => $items, 'selected' => $model->getCategoryIds(), 'parent' => $parent]);
 }

    public function actionGenerate()
    {
        $ymlConfig = new Yml();
        if (!$ymlConfig->loadConfig()) {
            return false;
        }
        static::$noimg = Yii::$app->getModule('image')->noImageSrc;
        if (1 == $ymlConfig->offer_param) {
            $this->prepareProperties();
        }
        \Yii::$app->urlManager->setHostInfo($ymlConfig->shop_url);
        $filePath = \Yii::getAlias('@webroot') . '/' . $ymlConfig->general_yml_filename;
        $tpl = <<<'TPL'
        <name>%s</name>
        <company>%s</company>
        <url>%s</url>
        <currencies>
            <currency id="%s" rate="1" plus="0"/>
        </currencies>
        <categories>
            %s
        </categories>
        <store>%s</store>
        <pickup>%s</pickup>
        <delivery>%s</delivery>
        <local_delivery_cost>%s</local_delivery_cost>
        <adult>%s</adult>
TPL;
        $section_categories = '';
        $categories = Category::find()->where(['active' => 1])->asArray();
        /** @var Category $row */
        foreach ($categories->each(500) as $row) {
            $section_categories .= '<category id="' . $row['id'] . '" ' . (0 != $row['parent_id'] ? 'parentId="' . $row['parent_id'] . '"' : '') . '>' . htmlspecialchars(trim(strip_tags($row['name']))) . '</category>' . PHP_EOL;
        }
        unset($row, $categories);
        $section_shop = sprintf($tpl, $ymlConfig->shop_name, $ymlConfig->shop_company, $ymlConfig->shop_url, $ymlConfig->currency_id, $section_categories, 1 == $ymlConfig->shop_store ? 'true' : 'false', 1 == $ymlConfig->shop_pickup ? 'true' : 'false', 1 == $ymlConfig->shop_delivery ? 'true' : 'false', $ymlConfig->shop_local_delivery_cost, 1 == $ymlConfig->shop_adult ? 'true' : 'false');
        $section_offers = '';
        //        $offer_type = ('simplified' === $ymlConfig->general_yml_type) ? '' : 'type="'.$ymlConfig->general_yml_type.'"';
        $offer_type = '';
        // временно, пока не будет окончательно дописан механизм для разных типов
        $products = Product::find()->where(['active' => 1]);
        /** @var Product $row */
        foreach ($products->each(100) as $row) {
            $price = $this->getByYmlParam($ymlConfig, 'offer_price', $row, 0);
            $price = intval($price);
            if ($price <= 0 || $price >= 1000000000) {
                continue;
            }
            $offer = '<offer id="' . $row->id . '" ' . $offer_type . ' available="true">' . PHP_EOL;
            /** @var Category $category */
            $category = $row->category;
            $category = empty($category) ? 1 : $category->category_group_id;
            $offer .= '<url>' . Url::to(['/shop/product/show', 'model' => $row, 'category_group_id' => $category], true) . '</url>' . PHP_EOL;
            $offer .= $this->wrapByYmlParam($ymlConfig, 'offer_price', $row, '<price>%s</price>' . PHP_EOL);
            $offer .= '<currencyId>' . $ymlConfig->currency_id . '</currencyId>' . PHP_EOL;
            $offer .= $this->wrapByYmlParam($ymlConfig, 'offer_category', $row, '<categoryId>%s</categoryId>' . PHP_EOL);
            $offer .= $this->wrapByYmlParam($ymlConfig, 'offer_picture', $row, function ($value) use($ymlConfig) {
                if (empty($value)) {
                    return $value;
                }
                $value = '<picture>' . rtrim($ymlConfig->shop_url, '/') . $value . '</picture>' . PHP_EOL;
                return $value;
            });
            $offer .= $this->wrapByYmlParam($ymlConfig, 'offer_name', $row, function ($value) use($ymlConfig) {
                if (mb_strlen($value) > 120) {
                    $value = mb_substr($value, 0, 120);
                    $value = mb_substr($value, 0, mb_strrpos($value, ' '));
                }
                $value = '<name>' . htmlspecialchars(trim(strip_tags($value))) . '</name>' . PHP_EOL;
                return $value;
            });
            $offer .= $this->wrapByYmlParam($ymlConfig, 'offer_description', $row, function ($value) use($ymlConfig) {
                if (mb_strlen($value) > 175) {
                    $value = mb_substr($value, 0, 175);
                    $value = mb_substr($value, 0, mb_strrpos($value, ' '));
                }
                $value = '<description>' . htmlspecialchars(trim(strip_tags($value))) . '</description>' . PHP_EOL;
                return $value;
            });
            if (1 == $ymlConfig->offer_param) {
                $offer .= $this->getValues($row);
            }
            $offer .= '</offer>';
            $section_offers .= $offer . PHP_EOL;
        }
        unset($row, $products);
        $ymlFileTpl = <<<'TPL'
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE yml_catalog SYSTEM "shops.dtd">
<yml_catalog date="%s">
    <shop>
        %s
        <offers>
            %s
        </offers>
    </shop>
</yml_catalog>
TPL;
        $fileString = sprintf($ymlFileTpl, date('Y-m-d H:i'), $section_shop, $section_offers);
        if (1 == $ymlConfig->use_gzip) {
//.........这里部分代码省略.........

 /**
  * @param YmlModel $config
  * @return array
  */
 private function generateSectionShop(YmlModel $config)
 {
     return ['name' => $config->shop_name, 'company' => $config->shop_company, 'url' => $config->shop_url, 'currency' => $this->currency->iso_code, 'categories' => Category::find()->where(['active' => 1])->asArray(), 'store' => static::USE_STORE == $config->shop_store ? 'true' : 'false', 'pickup' => static::USE_PICKUP == $config->shop_pickup ? 'true' : 'false', 'delivery' => static::USE_DELIVERY == $config->shop_delivery ? 'true' : 'false', 'local_delivery_cost' => $config->shop_local_delivery_cost, 'adult' => static::USE_ADULT == $config->shop_adult ? 'true' : 'false'];
 }

 public function getData()
 {
     $this->data = ArrayHelper::map(Category::find()->asArray()->all(), 'id', 'name');
     return parent::getData();
 }