<?php

////////////////////////////////////////////////////////////////////////////////
//                                                                            //
//   Copyright (C) 2006  Phorum Development Team                              //
//   http://www.phorum.org                                                    //
//                                                                            //
//   This program is free software. You can redistribute it and/or modify     //
//   it under the terms of either the current Phorum License (viewable at     //
//   phorum.org) or the Phorum License that was distributed with this file    //
//                                                                            //
//   This program is distributed in the hope that it will be useful,          //
//   but WITHOUT ANY WARRANTY, without even the implied warranty of           //
//   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                     //
//                                                                            //
//   You should have received a copy of the Phorum License                    //
//   along with this program.                                                 //
////////////////////////////////////////////////////////////////////////////////

if(!defined("PHORUM_ADMIN")) return;

// ----------------------------------------------------------------------
// Filter description
// ----------------------------------------------------------------------

$filterdef = array
(
    "body" => array(
        "label"         => "Message body",
        "matches"       => array(
            "contains"          => "body LIKE '%QUERY%'",
            "does not contain"  => "body NOT LIKE '%QUERY%'",
        ),
        "queryfield"    => "string"
    ),

    "subject" => array(
        "label"         => "Message subject",
        "matches"       => array(
            "equal to"          => "subject = 'QUERY'",
            "not equal to"      => "subject != 'QUERY'",
            "contains"          => "subject LIKE '%QUERY%'",
            "does not contain"  => "subject NOT LIKE '%QUERY%'",
        ),
        "queryfield"    => "string"
    ),

    "author" => array(
        "label"         => "Message author",
        "matches"       => array(
            "equal to"            => "author = 'QUERY'",
            "not equal to"        => "author != 'QUERY'",
            "contains"            => "author LIKE '%QUERY%'",
            "does not contain"    => "author NOT LIKE '%QUERY%'",
            "starts with"         => "author LIKE 'QUERY%'",
            "does not start with" => "author NOT LIKE 'QUERY%'",
            "ends with"           => "author LIKE '%QUERY'",
            "does not end with"   => "author NOT LIKE 'QUERY%'",
        ),
        "queryfield"    => "string"
    ),

    "date" => array(
        "label"         => "Message date",
        "matches"       => array(
            "posted on"           => "datestamp = 'QUERY'",
            "posted on or before" => "datestamp <= 'QUERY'",
            "posted before"       => "datestamp < 'QUERY'",
            "posted after"        => "datestamp > 'QUERY'",
            "posted on or after"  => "datestamp >= 'QUERY'",
        ),
        "queryfield"    => "date"
    ),

    "ipaddress" => array(
        "label"         => "Author IP-address",
        "matches"       => array(
            "equal to"            => "ip = 'QUERY'",
            "not equal to"        => "ip != 'QUERY'",
            "starts with"         => "ip LIKE 'QUERY%'",
            "does not start with" => "ip NOT LIKE 'QUERY%'",
        ),
        "queryfield"    => "ipaddress"
    ),

    "status" => array(
        "label"         => "Message status",
        "matches"       => array(
            "approved"                         => "status = ".PHORUM_STATUS_APPROVED,
            "on hold (waiting for approval)"   => "status = ".PHORUM_STATUS_HOLD, 
            "disapproved by moderator"         => "status = ".PHORUM_STATUS_HIDDEN,
            "hidden (on hold or disapproved)"  => "status != ".PHORUM_STATUS_APPROVED,
        ),
    ),

    "threadstate" => array(
        "label"         => "Thread status",
        "matches"       => array(
            "open for posting"    => "threadclosed = 0",
            "closed for posting"  => "threadclosed = 1",
        ),
    ),

    "messagetype" => array(
        "label"         => "Message type",
        "matches"       => array(
            "thread starting messages" => "parent_id = 0",
            "followup messages"        => "parent_id != 0",
        )
    ),
);

// ----------------------------------------------------------------------
// Javascript representation of the filter description
// ----------------------------------------------------------------------
?>
<script type="text/javascript">
//<![CDATA[

// The available filters and their configuration.
var filters = {
<?php
$count = count($filterdef);
foreach($filterdef as $filter => $def) { 
    $count--;
    print "  '$filter':{\n" .
          "    'label':'{$def["label"]}',\n" .
          "    'queryfield':" . 
               (isset($def["queryfield"])?"'{$def["queryfield"]}'":"null") .
               ",\n" .
          "    'matches':[\n";
    $mcount = count($def["matches"]); 
    foreach ($def["matches"] as $k => $v) {
        print "      '$k'" . (--$mcount ? ",\n" : "\n");
    }
    print "    ]\n" .
          "  }" .
          ($count ? "," : "") . "\n";
} ?>
};
//]]>
</script>

<?php
// ----------------------------------------------------------------------
// The filter form
// ----------------------------------------------------------------------
?>

<div class="input-form-td-break">
  Select messages to delete
</div>
<div class="input-form-td-message">
  ATTENTION!<br/>
  This script can delete A LOT of messages at once. So be careful 
  which messages you select for deleting. Use it at your own risk.
  If you do not feel comfortable with this, please make a good
  database backup before deleting any messages.<br/>
  <br/>
  The first step in deleting messages, is setting up a set of filters,
  which select the messages that you want to delete. Please add these
  filters below. After you are done, click the "Show selected messages"
  button to preview what messages you will be deleting.<br/>
  <br/>
  <form id="filterform" method="post" action="<?php $_SERVER["PHP_SELF"] ?>">
  <input type="hidden" name="module" value="message_prune" />
  <input id="filtermode_and" type="radio" checked="checked" name="filtermode" value="and">
    <label for="filtermode_and">Match all of the following</label>
  </input>
  <input id="filtermode_or" type="radio" name="filtermode" value="or">
    <label for="filtermode_or">Match any of the following</label>
  </input>
  <br/>
  <fieldset id="ruleset">
  <!-- filters will be added dynamically in this fieldset -->
  </fieldset>
  </form>

</div>

<?php
// ----------------------------------------------------------------------
// Javascript filter form implementation
// ----------------------------------------------------------------------
?>

<script type="text/javascript">
//<![CDATA[

function PhorumFilterRule(conf)
{
    // Check if we have all required config information.
    if (conf == null) {
        throw("Illegal call of PhorumFilterRule(): no config set");
        return;
    }
    if (conf.parent == null) {
        throw("Illegal call of PhorumFilterRule(): no parent in the config");
        return;
    }
    if (conf.index == null) {
        throw("Illegal call of PhorumFilterRule(): no index in the config");
        return;
    }

    // Object properties -------------------------------------------------

    // Information relating to the PhorumFilter object which created this rule.
    this.parent = conf.parent;
    this.index  = conf.index;

    // The properties that represent the rule state.
    this.field = (conf.field ? conf.field : "body");
    this.match = (conf.match ? conf.match : "contains");
    this.query = (conf.query ? conf.query : "");

    // Object methods ----------------------------------------------------

    // Method for handling actions after selecting a rule field.
    this.select_field_input = function()
    {
        var idx;

        // Store the current rule state.
        idx = this.field_input.selectedIndex;
        this.field = this.field_input.options[idx].value;
        idx = this.match_input.selectedIndex;
        this.match = idx == -1 ? null :  this.match_input.options[idx].value;

        // Populate the match_input selection.
        for (idx=this.match_input.options.length; idx>=0; idx--) {
            this.match_input.options[idx] = null;
        }
        for (var id in filters[this.field].matches) {
            var o = document.createElement('option');
            o.value = filters[this.field].matches[id];
            o.innerHTML = o.value;
            if (o.value == this.match) o.selected = true; 
            this.match_input.appendChild(o);
        }

        // Delegate further handling to select_match_input().
        this.select_match_input();
    }

    // Method for handling actions after selecting a rule match.
    this.select_match_input = function()
    {
        var idx;

        // Store the current rule state.
        idx = this.match_input.selectedIndex;
        this.match = this.match_input.options[idx].value;

        this.query_input.value = this.field +":" + this.match;
    }

    // Method for setting the button state. This will change the
    // state of the [+] button for the rule.
    this.setdelbuttonstate = function(disabled) {
        this.del_button.disabled = disabled;
    }

    // Method for destroying a rule object.
    this.destroy = function()
    {
        this.container.removeChild(this.add_button);
        this.container.removeChild(this.del_button);
        this.fieldcontainer.removeChild(this.field_input);
        this.fieldcontainer.removeChild(this.match_input);
        this.fieldcontainer.removeChild(this.query_input);
        this.container.removeChild(this.fieldcontainer);

        this.add_button = null;
        this.del_button = null;
        this.field_input = null;
        this.match_input = null;
        this.query_input = null;
        this.fieldcontainer = null;
        this.container = null;

        this.type = null;
        this.match = null;
        this.query = null;
    }

    // Build the interface -----------------------------------------------

    this.container = document.createElement('div');
    this.container.ruleobj = this;
    this.container.style.padding = '5px';
    this.container.style.marginBottom = '5px';
    this.container.style.backgroundColor = '#f0f0f0';
    this.container.style.border = '1px solid #ddd';

    this.fieldcontainer = document.createElement('div');
    this.fieldcontainer.ruleobj = this;
    this.fieldcontainer.style.marginRight = '100px';
    this.fieldcontainer.style.whiteSpace = 'nowrap';

    this.field_input = document.createElement('select'); 
    this.field_input.ruleobj = this;
    this.field_input.style.marginRight = '10px';
    this.field_input.style.width = '30%';
    this.field_input.onchange = function() {
        this.ruleobj.select_field_input();
    }

    this.match_input = document.createElement('select');
    this.match_input.ruleobj = this;
    this.match_input.style.marginRight = '10px';
    this.match_input.style.width = '30%';
    this.match_input.onchange = function() {
        this.ruleobj.select_match_input();
    }

    this.query_input = document.createElement('input');
    this.query_input.ruleobj = this;
    this.query_input.type = 'text';
    this.query_input.style.width = '20%';

    this.add_button = document.createElement('input');
    this.add_button.ruleobj = this;
    this.add_button.type = 'button';
    this.add_button.value = '+';
    this.add_button.onclick = function() {
        this.ruleobj.parent.addrule();
    }
    this.add_button.style.styleFloat = 'right';
    this.add_button.style.cssFloat = 'right';
    this.add_button.style.width = '40px';

    this.del_button = document.createElement('input');
    this.del_button.ruleobj = this;
    this.del_button.type = 'button';
    this.del_button.value = '-';
    this.del_button.onclick = function() {
        this.ruleobj.parent.delrule(this.ruleobj);
    }
    this.del_button.style.styleFloat = 'right';
    this.del_button.style.cssFloat = 'right';
    this.del_button.style.width = '40px';

    if (this.add_button) this.container.appendChild(this.add_button);
    if (this.del_button) this.container.appendChild(this.del_button);
    this.fieldcontainer.appendChild(this.field_input);
    this.fieldcontainer.appendChild(this.match_input);
    this.fieldcontainer.appendChild(this.query_input);
    this.container.appendChild(this.fieldcontainer);


    // Populate the field_input selection.
    for (var id in filters) {
        var o = document.createElement('option');
        o.innerHTML = filters[id]["label"];
        o.value     = id;
        if (o.value == this.field) o.selected = true; 
        this.field_input.appendChild(o);
    }

    // Initialize the rule state.
    this.select_field_input();
}

function PhorumFilter(conf)
{
    // Check if we have all required config information.
    if (conf == null) {
        throw("Illegal call of PhorumFilter(): no config set");
        return;
    }
    if (conf.parent == null) {
        throw("Illegal call of PhorumFilter(): no parent in the config");
        return;
    }

    // Object properties -------------------------------------------------

    this.rules = new Array();
    this.rulecount = 0;
    this.index = 0;
    this.parent = conf.parent;

    // Object methods ----------------------------------------------------

    this.addrule = function(conf)
    {
        // Create a PhorumFilterRule object.
        if (conf == null) conf = {};
        conf.parent = this;
        conf.index  = this.index++;
        var ruleobj = new PhorumFilterRule(conf);

        // Add the rule to the filter.
        this.parent.appendChild(ruleobj.container);
        this.rules[ruleobj.index] = ruleobj;

        this.rulecount ++;

        this.setbuttonstate();
    }

    this.delrule = function(ruleobj)
    {
        // Do not delete the last rule.
        if (this.rulecount == 1) return;

        // Delete the rule from the filter.
        this.parent.removeChild(ruleobj.container);
        ruleobj.destroy();
        this.rules[ruleobj.index] = null;

        this.rulecount --;

        this.setbuttonstate();
    }

    this.setbuttonstate = function()
    {
        var disabled = this.rulecount == 1 ? true : false;
        for (var i = 0 ; i < this.index; i++) {
            if (this.rules[i] != null) {
                this.rules[i].setdelbuttonstate(disabled); 
            }
        }
    }

    // Build the interface -----------------------------------------------

    // Initialize the filter state.
    this.addrule();
}

var filter = new PhorumFilter({"parent": document.getElementById("ruleset")});

//]]>
</script>