<?php
/**
 * @property \modelBackendContent $model_backend_content
 */
class actionAdminCtypesFieldStringAjax extends cmsAction {

    public function run($ctype_id = 0, $field_id = 0) {

        if (!$this->request->isAjax() ||
                !is_numeric($ctype_id) ||
                !is_numeric($field_id)
        ) {
            return cmsCore::error404();
        }

        if (!($ctype = $this->model_backend_content->getContentType($ctype_id)) ||
                !($field = $this->model_backend_content->getContentField($ctype['name'], $field_id))
        ) {
            return cmsCore::error404();
        }

        $this->model_backend_content->selectOnly('COUNT(i.id)', 'stroki')->
                        select('i.' . $field['name'], 'field')->
                        groupBy('i.' . $field['name'])->
                order_by = 'stroki DESC';

        $items = $this->model_backend_content->get($this->model_backend_content->table_prefix . $ctype['name'], function ($item) {
            return $item['field'];
        });

        return $this->cms_template->renderJSON([
            'error'  => false,
            'result' => implode("\n", array_diff($items, ['']))
        ]);
    }

}