public function eventPostModelCopyProduct()

in 3.0.x-and-above/upload/admin/controller/extension/module/facebook_business.php [365:397]
29 lines of code
3 McCabe index (conditional complexity)

    public function eventPostModelCopyProduct($route, &$args, $test) {
        $product_id = $args[0];

        $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "product_to_facebook` WHERE product_id = '" . (int)$product_id . "'");

        if ($query->num_rows) {
            $facebook_params = array(
                'facebook_google_product_category'   => $query->row['google_product_category'],
                'facebook_condition'                 => $query->row['condition'],
                'facebook_age_group'                 => $query->row['age_group'],
                'facebook_color'                     => $query->row['color'],
                'facebook_gender'                    => $query->row['gender'],
                'facebook_material'                  => $query->row['material'],
                'facebook_pattern'                   => $query->row['pattern']
            );
        } else {
            $facebook_params = array(
                'facebook_google_product_category'   => '',
                'facebook_condition'                 => '',
                'facebook_age_group'                 => '',
                'facebook_color'                     => '',
                'facebook_gender'                    => '',
                'facebook_material'                  => '',
                'facebook_pattern'                   => ''
            );
        }

        $last_id_query = $this->db->query("SELECT MAX(product_id) AS `product_id` FROM " . DB_PREFIX . "product");

        if ($last_id_query->row['product_id']) {
            $this->db->query("INSERT INTO " . DB_PREFIX . "product_to_facebook SET product_id = '" . (int)$last_id_query->row['product_id'] . "', google_product_category = '" . (int)$facebook_params['facebook_google_product_category'] . "', `condition` = '" . $this->db->escape($facebook_params['facebook_condition']) . "', age_group = '" . $this->db->escape($facebook_params['facebook_age_group']) . "', color = '" . $this->db->escape($facebook_params['facebook_color']) . "', gender = '" . $this->db->escape($facebook_params['facebook_gender']) . "', material = '" . $this->db->escape($facebook_params['facebook_material']) . "', pattern = '" . $this->db->escape($facebook_params['facebook_pattern']) . "'");
        }
    }