interface/super/rules/library/RuleCriteriaDatabaseCustom.php

   1 <?php
   2  // Copyright (C) 2010-2011 Aron Racho <aron@mi-squred.com>
   3  //
   4  // This program is free software; you can redistribute it and/or
   5  // modify it under the terms of the GNU General Public License
   6  // as published by the Free Software Foundation; either version 2
   7  // of the License, or (at your option) any later version.
   8
   9 /**
  10  * Description of RuleCriteriaDatabaseCustom
  11  *
  12  * @author aron
  13  */
  14 class RuleCriteriaDatabaseCustom extends RuleCriteria
  15 {
  16
  17     var $table;
  18     var $column;
  19     var $valueComparator;
  20     var $value;
  21     var $frequencyComparator;
  22     var $frequency;
  23
  24     function __construct(
  25         $table,
  26         $column,
  27         $valueComparator,
  28         $value,
  29         $frequencyComparator,
  30         $frequency
  31     ) {
  32         $this->table = $table;
  33         $this->column = $column;
  34         $this->valueComparator = $valueComparator;
  35         $this->value = $value;
  36         $this->frequencyComparator = $frequencyComparator;
  37         $this->frequency = $frequency;
  38     }
  39
  40     function getRequirements()
  41     {
  42         $requirements = "";
  43         if ($this->value) {
  44             $requirements .= xl("Value") . ": ";
  45             $requirements .= $this->decodeComparator($this->valueComparator) . " " . $this->value;
  46             $requirements .= " | ";
  47         }
  48
  49         $requirements .= xl("Frequency") . ": ";
  50         $requirements .= $this->decodeComparator($this->frequencyComparator) . " " . $this->frequency;
  51
  52         return $requirements;
  53     }
  54
  55     function getTitle()
  56     {
  57         return xl($this->table) . "." . xl($this->column);
  58     }
  59
  60     function getView()
  61     {
  62         return "custom.php";
  63     }
  64
  65     function getTableNameOptions()
  66     {
  67         $options = array();
  68         $stmts = sqlStatement("SHOW TABLES");
  69         for ($iter=0; $row=sqlFetchArray($stmts); $iter++) {
  70             foreach ($row as $key => $value) {
  71                 array_push($options, array( "id" => out($value), "label" => out(xl($value)) ));
  72             }
  73         }
  74
  75         return $options;
  76     }
  77
  78     function getDbView()
  79     {
  80         $dbView = parent::getDbView();
  81
  82         $dbView->method = "database";
  83         $dbView->methodDetail = "";
  84         $dbView->value =
  85                 "::"
  86                 . $this->table . "::" . $this->column. "::"
  87                 . $this->valueComparator . "::" . $this->value . "::"
  88                 . $this->frequencyComparator . "::" . $this->frequency;
  89         return $dbView;
  90     }
  91
  92     function updateFromRequest()
  93     {
  94         parent::updateFromRequest();
  95
  96         $this->table = _post("fld_table");
  97         $this->column = _post("fld_column");
  98         $this->value = _post("fld_value");
  99         $this->valueComparator = _post("fld_value_comparator");
 100         $this->frequency = _post("fld_frequency");
 101         $this->frequencyComparator = _post("fld_frequency_comparator");
 102     }
 103 }