<?php
/**
 * @package     JLex Review
 * @version     5
 * @copyright   Copyright JLexArt. All rights reserved
 * @license     GNU General Public License version 2 or later;
 * @author      www.jlexart.com
 */

defined ( "_JEXEC" ) or die;

class JLexReviewControllerField extends JControllerLegacy
{
    protected $tables=[
            "reviews" => [
                    "key"  => "id",
                    "name" => "#__jlexreview",
                    "fields" => ["published", "featured"]
                ]
        ];

	public function getValue(){}

    public function saveValue()
    {
    	$app = JFactory::getApplication();
        $tb  = $app->input->getCmd("table", "");
        $field = $app->input->getCmd("field", "");
        $value = $app->input->getString("value", "");
        $id    = $app->input->getInt("id", 0);

        if(!array_key_exists($tb, $this->tables))
        {
            JLexReviewHelperAdmin::toJson(["status"=>400, "error"=>jtext::_("JGB_BAD_REQUEST")]);
            return;
        }

        $table = $this->tables[$tb];
        if(!in_array($field, $table["fields"]))
        {
            JLexReviewHelperAdmin::toJson(["status"=>400, "error"=>jtext::_("JGB_BAD_REQUEST")]);
            return;
        }

        if($id<1)
        {
            JLexReviewHelperAdmin::toJson(["status"=>400, "error"=>jtext::_("JGB_BAD_REQUEST")]);
            return;
        }

        $db = JFactory::getDbo();
        $query = $db->getQuery(true);

        if($tb=="reviews" && $field=="published")
        {
            JTable::addIncludePath(dirname(__FILE__).'/../tables');
            $row = JTable::getInstance("review", "TableJR");
            $row->load($id);
            $row->do_publish($value);

            JLexReviewHelperAdmin::toJson(["status"=>200]);
        }

        // update value
        $query->clear()
              ->update($db->quoteName($table["name"]))
              ->set($db->quoteName($field)."=".$db->quote($value))
              ->where($db->quoteName($table["key"])."=".$db->quote($id));

        $db->setQuery($query)->execute();

        JLexReviewHelperAdmin::toJson(["status"=>200]);
    }
}