View source
<?php
namespace Drupal\faq\Form;
use Drupal\Component\Utility\Html;
use Drupal\Core\Database\Connection;
use Drupal\Core\Database\Database;
use Drupal\Core\Entity\EntityTypeManagerInterface;
use Drupal\Core\Form\ConfigFormBase;
use Drupal\Core\Language\LanguageManagerInterface;
use Drupal\taxonomy\Entity\Vocabulary;
use Drupal\faq\FaqHelper;
use Drupal\Core\Form\FormStateInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
class OrderForm extends ConfigFormBase {
protected $entityTypeManager;
protected $languageManager;
protected $database;
public function __construct(EntityTypeManagerInterface $entityTypeManager, LanguageManagerInterface $languageManager, Connection $database) {
$this->entityTypeManager = $entityTypeManager;
$this->languageManager = $languageManager;
$this->database = $database;
}
public static function create(ContainerInterface $container) {
return new static($container
->get('entity_type.manager'), $container
->get('language_manager'), $container
->get('database'));
}
public function getFormId() {
return 'faq_order_form';
}
protected function getEditableConfigNames() {
return [];
}
public function buildForm(array $form, FormStateInterface $form_state, $category = NULL) {
if ($id = FaqHelper::searchInArgs('faq-page')) {
$next_id = $id + 1;
if (is_numeric(FaqHelper::arg($next_id))) {
$category = FaqHelper::arg($next_id);
}
}
$order = $date_order = '';
$faq_settings = $this
->config('faq.settings');
$use_categories = $faq_settings
->get('use_categories');
if (!$use_categories) {
$step = "order";
}
elseif ($form_state
->getValues() != NULL && empty($category)) {
$step = "categories";
}
else {
$step = "order";
}
$form['step'] = array(
'#type' => 'value',
'#value' => $step,
);
if ($step == "categories") {
$vocabularies = Vocabulary::loadMultiple();
$options = array();
foreach ($vocabularies as $vid => $vobj) {
$tree = $this->entityTypeManager
->getStorage('taxonomy_term')
->loadTree($vid);
foreach ($tree as $term) {
if (!FaqHelper::taxonomyTermCountNodes($term->tid)) {
continue;
}
$options[$term->tid] = $this
->t($term->name);
$form['choose_cat']['faq_category'] = array(
'#type' => 'select',
'#title' => t('Choose a category'),
'#description' => t('Choose a category that you wish to order the questions for.'),
'#options' => $options,
'#multiple' => FALSE,
);
$form['choose_cat']['search'] = array(
'#type' => 'submit',
'#value' => t('Search'),
'#submit' => array(
'faq_order_settings_choose_cat_form_submit',
),
);
}
}
}
else {
$default_sorting = $faq_settings
->get('default_sorting');
$default_weight = 0;
if ($default_sorting != 'DESC') {
$default_weight = 1000000;
}
$options = array();
if (!empty($form_state
->getValue('faq_category'))) {
$category = $form_state
->getValue('faq_category');
}
$langcode = $this->languageManager
->getCurrentLanguage()
->getId();
$query = $this->database
->select('node', 'n');
$query
->join('node_field_data', 'd', 'n.nid = d.nid');
$query
->fields('n', [
'nid',
])
->fields('d', [
'title',
])
->condition('n.type', 'faq')
->condition('d.langcode', $langcode)
->condition('d.status', 1)
->addTag('node_access');
$query
->addExpression("COALESCE(w.weight, {$default_weight})", 'effective_weight');
if (empty($category)) {
$category = 0;
$query
->leftJoin('faq_weights', 'w', 'n.nid = %alias.nid AND %alias.tid = :category', array(
':category' => $category,
));
$query
->orderBy('effective_weight', 'ASC')
->orderBy('d.sticky', 'DESC')
->orderBy('d.created', $default_sorting == 'DESC' ? 'DESC' : 'ASC');
}
else {
$query
->innerJoin('taxonomy_index', 'ti', '(n.nid = %alias.nid)');
$query
->leftJoin('faq_weights', 'w', 'n.nid = %alias.nid AND %alias.tid = :category', array(
':category' => $category,
));
$query
->condition('ti.tid', $category);
$query
->orderBy('effective_weight', 'ASC')
->orderBy('d.sticky', 'DESC')
->orderBy('d.created', $default_sorting == 'DESC' ? 'DESC' : 'ASC');
}
$options = $query
->execute()
->fetchAll();
$form['weight']['faq_category'] = array(
'#type' => 'value',
'#value' => $category,
);
$form['order_no_cats']['#tree'] = TRUE;
$form['order_no_cats']['#theme'] = 'faq_draggable_question_order_table';
foreach ($options as $i => $record) {
$form['order_no_cats'][$i]['nid'] = array(
'#type' => 'hidden',
'#value' => $record->nid,
);
$form['order_no_cats'][$i]['title'] = array(
'#markup' => Html::escape($record->title),
);
$form['order_no_cats'][$i]['sort'] = array(
'#type' => 'weight',
'#delta' => count($options),
'#default_value' => $i,
);
}
$form['actions']['#type'] = 'actions';
$form['actions']['submit'] = array(
'#type' => 'submit',
'#value' => $this
->t('Save order'),
'#button_type' => 'primary',
);
}
return $form;
}
public function submitForm(array &$form, FormStateInterface $form_state) {
$order_no_cats = $form_state
->getValue('order_no_cats');
if ($form_state
->getValue('op')
->__toString() == t('Save order') && !empty($order_no_cats)) {
foreach ($order_no_cats as $i => $faq) {
$nid = $faq['nid'];
$index = $faq['sort'];
Database::getConnection()
->merge('faq_weights')
->fields(array(
'weight' => $index,
))
->keys(array(
'tid' => $form_state
->getValue('faq_category'),
'nid' => $nid,
))
->execute();
}
parent::submitForm($form, $form_state);
}
}
}