Pref_Filters::saveRulesAndActions()

Complexity

Conditions	15
Paths	868

Size

Total Lines	77
Code Lines	40

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    private function saveRulesAndActions($filter_id)
    {

        $sth = $this->pdo->prepare("DELETE FROM ttrss_filters2_rules WHERE filter_id = ?");
        $sth->execute([$filter_id]);

        $sth = $this->pdo->prepare("DELETE FROM ttrss_filters2_actions WHERE filter_id = ?");
        $sth->execute([$filter_id]);

        if (!is_array(clean($_REQUEST["rule"]))) {
            $_REQUEST["rule"] = [];
        }
        if (!is_array(clean($_REQUEST["action"]))) {
            $_REQUEST["action"] = [];
        }

        if ($filter_id) {
            /* create rules */

            $rules = array();
            $actions = array();

            foreach (clean($_REQUEST["rule"]) as $rule) {
                $rule = json_decode($rule, true);
                unset($rule["id"]);

                if (array_search($rule, $rules) === false) {
                    array_push($rules, $rule);
                }
            }

            foreach (clean($_REQUEST["action"]) as $action) {
                $action = json_decode($action, true);
                unset($action["id"]);

                if (array_search($action, $actions) === false) {
                    array_push($actions, $action);
                }
            }

            $rsth = $this->pdo->prepare("INSERT INTO ttrss_filters2_rules
						(filter_id, reg_exp,filter_type,feed_id,cat_id,match_on,inverse) VALUES
						(?, ?, ?, NULL, NULL, ?, ?)");

            foreach ($rules as $rule) {
                if ($rule) {

                    $reg_exp = trim($rule["reg_exp"]);
                    $inverse = isset($rule["inverse"]) ? 1 : 0;

                    $filter_type = (int) trim($rule["filter_type"]);
                    $match_on = json_encode($rule["feed_id"]);

                    $rsth->execute([$filter_id, $reg_exp, $filter_type, $match_on, $inverse]);
                }
            }

            $asth = $this->pdo->prepare("INSERT INTO ttrss_filters2_actions
						(filter_id, action_id, action_param) VALUES
						(?, ?, ?)");

            foreach ($actions as $action) {
                if ($action) {

                    $action_id = (int) $action["action_id"];
                    $action_param = $action["action_param"];
                    $action_param_label = $action["action_param_label"];

                    if ($action_id == 7) {
                        $action_param = $action_param_label;
                    }

                    if ($action_id == 6) {
                        $action_param = (int) str_replace("+", "", $action_param);
                    }

                    $asth->execute([$filter_id, $action_id, $action_param]);
                }