news.php

<?php
/** @var i18n $I18N */

$id = rex_request('id', 'int', 0);
$clang = rex_request('clang', 'int', 0);

$now = new DateTime();

$urlParam = '&amp;subpage=' . $subpage;
if($func) {
    $urlParam .= '&amp;func=' . $func;
}
if($id) {
    $urlParam .= '&amp;id=' . $id;
}
rex_asd_news_language($clang, $urlParam);

if ($func == 'status') {

    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    $sql->select('`status`');

    $status = ($sql->getValue('status')) ? 0 : 1;

    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    $sql->setValue('status', $status);

    if ($sql->update()) {
        echo rex_info($I18N->msg('asd_news_status_saved'));
    } else {
        echo rex_warning($sql->getError());
    }

    $func = '';

}

if ($func == 'delete') {

    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);

    if ($sql->delete()) {
        echo rex_info($I18N->msg('asd_news_deleted'));
    } else {
        echo rex_warning($sql->getError());
    }

    $func = '';

}

if ($func == 'unpublish') {

    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    $sql->setValue('publishedAt', '0000-00-00 00:00:00');
    $sql->setValue('publishedBy', 0);

    $successMessage = $I18N->msg('asd_news_unpublished_s');

    if (rex_asd_news_config::getConfig('published-lang') == 'all') {
        $sql->setWhere('`id` = ' . $id);
        $successMessage = $I18N->msg('asd_news_unpublished_m');
    }

    if ($sql->update()) {
        echo rex_info($successMessage);
    } else {
        echo rex_warning($sql->getError());
    }

    $func = '';

}

if ($func == '') {

    $list = new rex_list('
    SELECT
      `id`, `title`, `publishedAt`, `status`
    FROM `' . rex_asd_news_config::getTable() . '`
    WHERE `clang` = ' . $clang . '
    ORDER BY CASE
        WHEN `publishedAt` = "0000-00-00 00:00:00" THEN 1
         ELSE 0
        END DESC,
    `publishedAt` DESC, `updatedAt` DESC');

    $list->addParam('clang', $clang);
    $list->addParam('subpage', $subpage);

    $imgHeader = '
    <a class="rex-i-element rex-i-generic-add" href="' . $list->getUrl(array('func' => 'add')) . '">
        <span class="rex-i-element-text">add</span>
    </a>';

    $list->setColumnLabel('id', $imgHeader);
    $list->setColumnLabel('title', $I18N->msg('asd_news_title'));
    $list->setColumnLabel('publishedAt', $I18N->msg('asd_news_publishedAt'));
    $list->removeColumn('status');
    $list->addTableColumnGroup(array(40, '*', 120, 50, 50, 50, 50));

    $list->setColumnParams('title', array('func' => 'edit', 'id' => '###id###'));

    $list->setColumnFormat('publishedAt', 'custom', function ($params) use ($list, $now, $clang, $I18N, $REX) {
        $publishedAt = new DateTime($list->getValue('publishedAt'));

        $value = $publishedAt->format('d.m.Y H:i');

        if ($list->getValue('publishedAt') == '0000-00-00 00:00:00') {
            return '';
        }

        return '<span>' . $value . '</span>';
    });

    $list->addColumn('publishCol', $I18N->msg('asd_news_publish'), -1, array('<th colspan="4">' . $I18N->msg('actions') . '</th>', '<td>###VALUE###</td>'));
    $list->setColumnFormat('publishCol', 'custom', function ($params) use ($list, $clang, $now, $I18N) {
        $publishedAt = new DateTime($list->getValue('publishedAt'));

        if ($list->getValue('publishedAt') == '0000-00-00 00:00:00') {
            return '
            <span class="rex-offline datepicker" data-id="###id###">' . $I18N->msg('asd_news_unpublished') . '</span>
            <span style="height:1px; width:1px; display:block" id="news_###id###" data-clang="' . $clang . '" value="' . $now->format('d/m/Y H:i') . '"></span>';
        }

        $url = $list->getParsedUrl(array('func' => 'unpublish', 'id' => '###id###'));

        return '<a href="' . $url . '" class="rex-online" onclick="return confirm(\'' . $I18N->msg('asd_news_really_unpublish') . '\');">' . $I18N->msg('asd_news_published') . '</a>';

    });

    $list->addColumn('editCol', $I18N->msg('edit'), -1, array('', '<td>###VALUE###</td>'));
    $list->setColumnParams('editCol', array('func' => 'edit', 'id' => '###id###'));

    $list->addColumn('delCol', $I18N->msg('delete'), -1, array('', '<td>###VALUE###</td>'));
    $list->setColumnParams('delCol', array('func' => 'delete', 'id' => '###id###'));
    $list->addLinkAttribute('delCol', 'onclick', 'return confirm(\'' . $I18N->msg('asd_news_really_delete') . '\');');

    $list->addColumn('statusCol', 'offline', -1, array('', '<td>###VALUE###</td>'));
    $list->setColumnFormat('statusCol', 'custom', function ($params) use ($list, $I18N) {

        $url = $list->getParsedUrl(array('func' => 'status', 'id' => '###id###'));

        if ($list->getValue('status') == 1) {
            return '<a href="' . $url . '" class="rex-online">' . $I18N->msg('status_online') . '</a>';
        } else {
            return '<a href="' . $url . '" class="rex-offline">' . $I18N->msg('status_offline') . '</a>';
        }

    });

    $list->show();
    echo '
    <script>
    jQuery(document).ready(function($) {

        $(".datepicker").css("cursor", "pointer").click(function() {
            id = $(this).data("id");
            obj = $("#news_" + id);
            clang = obj.data("clang");
            date = obj.data("date");


            obj.datetimepicker({
                minDate: 0,
                formatDate: "d.m.Y",
                dayOfWeekStart: 1,
                lang: "de",
                step: 30,
                onSelectTime: function() {
                  $.post("index.php", {
                    page: "asd_news",
                    func: "publish",
                    id: id,
                    clang: clang,
                    time: obj.val()
                  }, function(data) {
                     obj.closest("tr").html(data);
                  });
                }
            }).datetimepicker("show");




        });

    });

    </script>';

}

if ($func == 'add' || $func == 'edit') {

    if (rex_asd_news_config::isControlPlugin()) {
        foreach (array('REX_FORM_SAVED', 'REX_FORM_DELETED') as $extension) {
            rex_register_extension($extension, 'url_generate::generatePathFile');
        }
    }

    $title = ($func == 'add') ? $I18N->msg('add') : $I18N->msg('edit');

    $form = new rex_news_form(rex_asd_news_config::getTable(), ucfirst($title), 'id=' . $id . ' AND clang = ' . $clang);
    $form->divId = 'asd_news-addon-editmode';

    $field = $form->addTextField('title');
    $field->setLabel($I18N->msg('asd_news_title'));

    if(OOAddon::isAvailable('metainfo')) {
        $form->addRawField($form->getMetainfoExtension());
    }

    $form->addHiddenField('clang', (int)$clang);
    $form->addHiddenField('updatedAt', $now->format('Y-m-d H:i:s'));
    $form->addHiddenField('updatedBy', $REX['USER']->getValue('user_id'));

    $form->addParam('clang', (int)$clang);
    $form->addParam('id', (int)$id);

    if ($func == 'add') {
        $id = rex_asd_news::getLastNewsId() + 1;
    }

    $form->addHiddenField('id', $id);

    if ($func == 'add') {

        $form->addHiddenField('createdAt', $now->format('Y-m-d H:i:s'));
        $form->addHiddenField('createdBy', $REX['USER']->getValue('user_id'));

        rex_register_extension('REX_FORM_SAVED', function ($subject) use ($clang, $REX, $id) {
            rex_news_form::saveOverLangValues($subject['form'], $id, $clang);
        });

    }

    $form->show();

}


?>