<h2>File Contents: /home/planet5/www/4xpips.net/secure/library/Am/Query/Renderable.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/4xpips.net/secure/library/Am/Query/Renderable.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

/**
 * A query object that can be displayed as search form,
 * then submitted and queried to database
 * @package Am_Query
 */
abstract class Am_Query_Renderable extends Am_Query
{
    public $possibleConditions = array();
    protected $search = array();
    /** @var Am_Form */
    protected $form;
    /** @var string path to smarty template */
    protected $template = null;
    /** @var string name of saved template or null */
    protected $name;
    protected $saved_search_id;
    
    /** @var string vars prefix */
    protected $prefix = &#039;_u_search&#039;;
    
    /**
     * This function must be overriden and fill-in
     * @see $this-&gt;possibleConditions array
     */
    abstract function initPossibleConditions();
    
    public function setPrefix($prefix)
    {
        $this-&gt;prefix = $prefix;
        return $this;
    }

    /**
     * Set $conditions based on user input. This function must be called
     * only once, because it does not do any cleanup
     * @param Am_Request|array $vars
     * @see $this-&gt;search
     */
    function setFromRequest($vars){
        if ($vars instanceof Am_Request)
            $vars = $vars-&gt;toArray();
        $this-&gt;initPossibleConditions();
        $this-&gt;createForm((array)$vars);
        $vars = $this-&gt;form-&gt;getValue();
        $search = @$vars[$this-&gt;prefix];
        if(!is_array($search)) return; // Nothing to set;
        foreach ($this-&gt;possibleConditions as $cond){
            if ($cond-&gt;setFromRequest($search))
            {
                $this-&gt;conditions[] = $cond;
                $el = $this-&gt;form-&gt;getElementById($cond-&gt;getId());
                if ($el) $el-&gt;setAttribute(&#039;class&#039;, &#039;searchField&#039;); // remote &quot;empty&quot; class
            }
        }
    }
    function createForm(array $vars){
        $form = new Am_Form;
        $form-&gt;setDataSources(array(new Am_Request($vars)));
        $select = $form-&gt;addSelect(&#039;&#039;, array(&#039;size&#039;=&gt;1, &#039;id&#039;=&gt;&#039;search-add-field&#039;));
        $search = $form-&gt;addGroup($this-&gt;prefix);
        
        $search-&gt;options[&#039;&#039;] = &#039;** &#039;.___(&#039;Select a condition to add into search&#039;).&#039; **&#039;;
        foreach ($this-&gt;possibleConditions as $cond) {
            $cond-&gt;renderElement($search);
        }
        $select-&gt;loadOptions($search-&gt;options);
        $this-&gt;form = $form;
    }
    function renderForm($addHidden){
        $this-&gt;initPossibleConditions();
        $t = new Am_View;
        $renderer = HTML_QuickForm2_Renderer::factory(&#039;array&#039;);
        if (!$this-&gt;form)
            $this-&gt;createForm(array());
        $this-&gt;form-&gt;render($renderer);
        $t-&gt;assign(&#039;form&#039;, $renderer-&gt;toArray());
        $t-&gt;assign(&#039;description&#039;, $this-&gt;getDescription(true));
        $t-&gt;assign(&#039;serialized&#039;, $this-&gt;serialize());
        $t-&gt;assign(&#039;hidden&#039;, $addHidden);
        $t-&gt;assign(&#039;loadSearchOptions&#039;, Am_Controller::renderOptions($this-&gt;getLoadOptions(), $this-&gt;saved_search_id));
        return $t-&gt;render($this-&gt;template);
    }
    static function removeEmptyElements(array &amp;$array){
        foreach ($array as $k =&gt; $v)
            if (is_array($v)) {
                self::removeEmptyElements($array[$k]);
                if (!count($array[$k]))
                    unset($array[$k]);
            } elseif ($v == &quot;&quot;)
                unset($array[$k]);
    }
    function serialize(){
        if (!$this-&gt;form)
            $this-&gt;createForm(array());
        $arr = $this-&gt;form-&gt;getValue();
        if(array_key_exists($this-&gt;prefix, $arr))
            $arr = $arr[$this-&gt;prefix];
        else
            $arr = array();
        self::removeEmptyElements($arr);
        unset($arr[&#039;_save_&#039;]);
        return json_encode($arr);
    }
    function unserialize($s){
        $vars = array($this-&gt;prefix =&gt;  (array)json_decode($s, true));
        $this-&gt;setFromRequest($vars);
    }
    function getDescription($short=false){
        $d = array();
        foreach ($this-&gt;conditions as $cond) 
            $d[] = $cond-&gt;getDescription();
        $conds = join(&#039; ,and &#039;, $d);
        if ($short) return $conds;
        return $d ? ___(&#039;Records that match all these conditions&#039;).&#039;: &#039;.$conds : ___(&#039;All records&#039;);
    }
    function setName($name){
        $this-&gt;name = $name;
        return $this;
    }
    function getName(){
        return $this-&gt;name;
    }
    function save(){
        $vars = array(
            &#039;name&#039; =&gt; htmlentities($this-&gt;name),
            &#039;class&#039; =&gt; get_class($this),
            &#039;search&#039; =&gt; $this-&gt;serialize(),
        );
        Am_Di::getInstance()-&gt;db-&gt;query(&quot;INSERT INTO ?_saved_search SET ?a&quot;, $vars);
        return Am_Di::getInstance()-&gt;db-&gt;selectCell(&quot;SELECT LAST_INSERT_ID()&quot;);
    }
    function getLoadOptions(){
        $options = Am_Di::getInstance()-&gt;db-&gt;selectCol(&quot;SELECT saved_search_id as ARRAY_KEY,name
            FROM ?_saved_search WHERE class=?&quot;, get_class($this));
        return array_map(array(&#039;Am_Controller&#039;, &#039;escape&#039;), $options);
    }
    function load($id){
        $id = intval($id);
        $class = get_class($this);
        $r = Am_Di::getInstance()-&gt;db-&gt;selectRow(&quot;SELECT * FROM ?_saved_search
            WHERE saved_search_id=?d and class=?&quot;, $id, $class);
        if ($r) {
            $this-&gt;clearConditions();
            $this-&gt;setName($r[&#039;name&#039;]);
            $this-&gt;saved_search_id = $r[&#039;saved_search_id&#039;];
            $this-&gt;unserialize($r[&#039;search&#039;]);
            if (!$this-&gt;getConditions())
                throw new Am_Exception_InternalError(&quot;Could not load search [$id,$class] - empty conditions&quot;);
        } else
            throw new Am_Exception_InputError(&quot;Could not load query, not found [&quot; . htmlentitites($id) . &quot;,$class]&quot;);
        return $this;
    }
    function deleteSaved($id)
    {
        $id = intval($id);
        $class = get_class($this);
        Am_Di::getInstance()-&gt;db-&gt;query(&quot;DELETE FROM ?_saved_search
            WHERE saved_search_id=?d and class=?&quot;, $id, $class);
        return $this;
    }
}

interface Am_Query_Renderable_Condition {
    /**
     * If this condition is exists in user-submitted
     * request, assign it to current object
     * and return true
     * @param array of parameters in form : fieldname-op, fieldname-val
     *
     */
    function setFromRequest(array $input);
    /**
     * Add corresponding elements to the form
     * @param HTML_QuickForm2 $form
     * @return HTML_QuickForm2_Element|array of elements
     */
    function renderElement(HTML_QuickForm2_Container $form);
    /**
     * @return bool true if field was not enabled during loadFromInput
     */
    function isEmpty();
    /** @return string id of the fieldset */
    function getId();
    /** @return textual description of the filter */
    function getDescription();
}

class Am_Query_Renderable_Condition_Field extends Am_Query_Condition_Field
    implements Am_Query_Renderable_Condition
{
    const NUM = 1;
    const BOOL = 2;
    const STRING = 3;
    const DATE = 4;

    protected $title;
    protected $fieldType;

    protected $fieldGroupTitle = &quot;FIELDS&quot;;

    static $renderOperations = array(
        self::NUM =&gt; array(&#039;=&#039; =&gt; &#039;=&#039;, &#039;&lt;&gt;&#039;=&gt;&#039;&lt;&gt;&#039;, &#039;&gt;&#039;=&gt;&#039;&gt;&#039;, &#039;&lt;&#039;=&gt;&#039;&lt;&#039;, &#039;&gt;=&#039;=&gt;&#039;&gt;=&#039;, &#039;&lt;=&#039;=&gt;&#039;&lt;=&#039;, ),
        self::DATE =&gt; array(&#039;=&#039; =&gt; &#039;=&#039;, &#039;&lt;&gt;&#039;=&gt;&#039;&lt;&gt;&#039;, &#039;&gt;&#039;=&gt;&#039;&gt;&#039;, &#039;&lt;&#039;=&gt;&#039;&lt;&#039;, &#039;&gt;=&#039;=&gt;&#039;&gt;=&#039;, &#039;&lt;=&#039;=&gt;&#039;&lt;=&#039;, ),
        self::STRING =&gt; array(&#039;=&#039;=&gt;&#039;=&#039;, &#039;&lt;&gt;&#039;=&gt;&#039;&lt;&gt;&#039;, &#039;LIKE&#039;=&gt;&#039;LIKE&#039;, &#039;NOT LIKE&#039;=&gt;&#039;NOT LIKE&#039;,),
        self::BOOL =&gt; null,
    );
    /** @var array User fields that must be displayed as select instead of op=&gt;value inputs */
    public function __construct($field, $title, $mysqlFieldType) {
        $this-&gt;field = $field;
        $this-&gt;title = $title;
        @list($type,$len) = explode(&#039;(&#039;, $mysqlFieldType);
        $len = intval($len);
        if (in_array($type, array(&#039;tinyint&#039;))){
            $this-&gt;fieldType = self::BOOL;
        } elseif (in_array($type,array(&#039;date&#039;, &#039;datetime&#039;,&#039;timestamp&#039;))){
            $this-&gt;fieldType = self::DATE;
        } elseif (in_array($type, array(&#039;smallint&#039;, &#039;int&#039;,&#039;float&#039;,&#039;double&#039;,&#039;numeric&#039;))){
            $this-&gt;fieldType = self::NUM;
        } else {
            $this-&gt;fieldType = self::STRING;
        }
    }
    public function setFromRequest(array $input) {
        $id = $this-&gt;getId();
        if (array_key_exists($id, $input) &amp;&amp; array_filter($input[$id], &#039;strlen&#039;))
        {
            if (empty($input[$id][&#039;op&#039;])) $input[$id][&#039;op&#039;] = &#039;=&#039;;
            if (($input[$id][&#039;op&#039;] == &#039;LIKE&#039;) &amp;&amp; (strpos($input[$id][&#039;val&#039;], &#039;%&#039;) === false)) {
                $input[$id][&#039;val&#039;] = &#039;%&#039; . $input[$id][&#039;val&#039;] . &#039;%&#039;;
            }
            if ($this-&gt;fieldType == self::DATE &amp;&amp;
                $input[$id][&#039;op&#039;] == &#039;=&#039;) {
                //we need it so fields datetime and timestamp works correctly for =
                //since we do not allow to chose time in condition
                $input[$id][&#039;op&#039;] = &#039;LIKE&#039;;
                $input[$id][&#039;val&#039;] = @$input[$id][&#039;val&#039;] . &#039;%&#039;;
            }
            $this-&gt;init(@$input[$id][&#039;op&#039;], @$input[$id][&#039;val&#039;]);
            return true;
        } else {
            $this-&gt;empty = true;
            $this-&gt;op = null;
        }
    }
    /**
     * @return HTML_QuickForm2_Container
     */
    public function addGroup(HTML_QuickForm2_Container $form){
       $form-&gt;options[$this-&gt;fieldGroupTitle][$this-&gt;getId()] = $this-&gt;title;
       return $form-&gt;addGroup($this-&gt;getId())
           -&gt;setLabel($this-&gt;title)
           -&gt;setAttribute(&#039;id&#039;, $this-&gt;getId())
           -&gt;setAttribute(&#039;class&#039;, &#039;searchField empty&#039;);
    }
    public function getId(){ return &#039;field-&#039;.$this-&gt;field; }
    public function renderElement(HTML_QuickForm2_Container $form) {
        $group = $this-&gt;addGroup($form);
        if ($operations = self::$renderOperations[$this-&gt;fieldType])
            $group-&gt;addSelect(&#039;op&#039;)-&gt;loadOptions($operations);
        switch ($this-&gt;fieldType) {
            case self::BOOL:
                $group-&gt;addAdvCheckbox(&#039;val&#039;);
                break;
            case self::NUM:
                $group-&gt;addText(&#039;val&#039;, array(&#039;size&#039;=&gt;6));
                break;
            case self::DATE:
                $group-&gt;addDate(&#039;val&#039;, array(&#039;size&#039;=&gt;12));
                break;
            default:
                $group-&gt;addText(&#039;val&#039;, array(&#039;size&#039;=&gt;20));
        }
    }
    public function isEmpty() {
        return $this-&gt;op === null;
    }
    public function getDescription(){
        return $this-&gt;title . &#039; &#039; . $this-&gt;op . &#039; [&#039; . htmlentities($this-&gt;value).&#039;]&#039;;
    }
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2F4xpips.net%2Fsecure%2Flibrary%2FAm%2FQuery'>⬅ Back to Directory</a>