filterTable.class.php

Go to the documentation of this file.

<?php
class helper_filterTable extends object {

        protected $form;

        protected $table;

        protected $session;

        protected $hasValues = false;

        protected function afterInit() {
                $this->table = $this->cfg->table;
                if (!$this->cfg->sessionName)
                        $this->cfg->sessionName = $this->table->getName();

                $this->session = session::getInstance(array(
                        'nameSpace'=>'filterTable_'.$this->cfg->sessionName
                ));

                if (!$this->cfg->check('clearPrm'))
                        $this->cfg->clearPrm = 'clearFilter'.ucfirst($this->table->getName());
                $this->cfg->setinArray('actionPrmClear', $this->cfg->clearPrm, true);

                $this->initForm();
        }

        protected function initForm() {
                $this->form = factory::get('form_db', array_merge($this->cfg->formOpts, array(
                        'filter'=>true,
                        'table'=>$this->table,
                        'sectionName'=>$this->cfg->formName,
                        'action'=>request::uriDef(array('paramA'=>array_merge(array_diff_key(request::get('paramA'), $this->cfg->actionPrmClear), $this->cfg->actionPrmForce)))
                )));

                $this->form->setSubmitText($this->cfg->submitText);
                $this->form->setSubmitplus('<a href="'.$this->clearLink().'">'.$this->cfg->clearText.'</a>');

                if (!empty($this->cfg->fields)) {
                        foreach($this->cfg->fields as $field) {
                                if ($f = $this->table->getField($field)) {
                                        $f['label'] = $this->getLabel($f['name']);
                                        $f['link'] = $this->table->getLinked($f['name']);
                                        $this->form->addFromFieldFilter($f);
                                } else if ($r = $this->table->getRelated($field)) {
                                        $r['label'] = $this->getLabel($r['table']);
                                        $r['name'] = $r['tableLink'];
                                        $this->form->addFromRelatedFilter($r);
                                } else if ($this->table->hasI18n() && db::isI18nName($field) && ($f = $this->table->getI18nTable()->getField(db::unI18nName($field)))) {
                                        $name = db::unI18nName($field);
                                        $f['name'] = $field;
                                        $f['label'] = $this->getLabel($field);
                                        $f['link'] = $this->table->getI18nTable()->getLinked($name);
                                        $this->form->addFromFieldFilter($f);
                                }
                        }
                } else {
                        // All fields
                        foreach($this->table->getField() as $f) {
                                $f['label'] = $this->getLabel($f['name']);
                                $f['link'] = $this->table->getLinked($f['name']);
                                $this->form->addFromFieldFilter($f);
                        }

                        foreach($this->table->getRelated() as $t=>$r) {
                                $r['name'] = $r['tableLink'];
                                $r['label'] = $this->getLabel($r['table']);
                                $this->form->addFromRelated($r);
                        }
                }

        $this->fillValues();
        }
    
    public function fillValues() {
                $defValues = $this->form->getValues();
        
                if (request::isPost() || request::getPrm($this->cfg->clearPrm)) {
                        if (request::isPost())
                                $this->form->refill();
                        $this->session->clear(true);
                } else {
                        foreach($this->form->getNames() as $name) {
                                if ($this->session->check($name))
                                        $this->form->setValue($name, $this->session->get($name));
                        }
                        $this->form->setBound(false);
                }
                foreach($this->form->getValues() as $k=>$v) {
                        if ($v != $defValues[$k])
                                $this->hasValues = true;
                }
    }

        public function getForm() {
                return $this->form;
        }

        public function hasValues() {
                return $this->hasValues;
        }

        public function getWhere() {
                $where = $this->table->getWhere();
                foreach($this->form->getValues() as $name=>$val) {
                        $field = strpos($name, '.') === false ? $this->table->getName().'.'.$name : $name;
                        if (!is_null($val) && ($val || $val === '0')) {
                                if (is_array($val)) {
                                        if (array_key_exists('min', $val) || array_key_exists('max', $val)) {
                                                $min = array_key_exists('min', $val) && !empty($val['min'])?$val['min'] : null;
                                                $max = array_key_exists('max', $val) && !empty($val['max'])?$val['max'] : null;
                                                if ($min)
                                                        $where->add(array(
                                                                'field'=>$field,
                                                                'val'=>$min,
                                                                'op'=>'>='
                                                        ));
                                                if ($max)
                                                        $where->add(array(
                                                                'field'=>$field,
                                                                'val'=>$max,
                                                                'op'=>'<='
                                                        ));
                                        } else {
                                                $fieldRel = $this->table->getRelated($name);
                                                $where->add(array(
                                                        'field'=>$fieldRel ? $fieldRel['tableLink'].'.'.$fieldRel['fk2']['name'] : $field,
                                                        'val'=>array_map(array($this->table->getDb(), 'quoteValue'), $val),
                                                        'op'=>'IN'
                                                ));
                                        }
                                } else if(strpos($name, '_file')) {
                                        $where->add(array(
                                                'field'=>$field,
                                                'val'=>'',
                                                'op'=>'<>'
                                        ));
                                } else {
                                        $f = $this->table->getField($name);
                                        if (is_array($f) && (!array_key_exists('text', $f) || $f['text'])) {
                                                $tmp = explode(' ', $val);
                                                array_walk($tmp, create_function('&$v', '$v = trim($v);'));
                                                $tmp = array_filter($tmp);
                                                foreach($tmp as $t) {
                                                        $where->add(array(
                                                                'field'=>$field,
                                                                'val'=>'%'.$t.'%',
                                                                'op'=>'LIKE'
                                                        ));
                                                }
                                        } else if ($this->table->hasI18n() && db::isI18nName($name) && ($f = $this->table->getI18nTable()->getField(db::unI18nName($name)))) {
                                                $tblName = $this->table->getI18nTable()->getName();
                                                $prim = $this->table->getI18nTable()->getPrimary();
                                                $field = $tblName.'.'.db::unI18nName($name);
                                                $clause = '('.$this->table->getName().'.'.$this->table->getIdent().' IN (SELECT '.$tblName.'.'.$prim[0].' FROM '.$tblName.' WHERE ';

                                                $tmpWhere = $this->table->getI18nTable()->getWhere(array('op'=>'OR'));

                                                if (!array_key_exists('text', $f) || $f['text']) {
                                                        $tmp = explode(' ', $val);
                                                        array_walk($tmp, create_function('&$v', '$v = trim($v);'));
                                                        $tmp = array_filter($tmp);
                                                        foreach($tmp as $t) {
                                                                $tmpWhere->add(array(
                                                                        'field'=>$field,
                                                                        'val'=>'%'.$t.'%',
                                                                        'op'=>'LIKE'
                                                                ));
                                                        }
                                                } else {
                                                        $tmpWhere->add(array(
                                                                'field'=>$field,
                                                                'val'=>$val
                                                        ));
                                                }
                                                $clause.= $tmpWhere.'))';
                                                $where->add($clause);
                                        } else {
                                                $where->add(array(
                                                        'field'=>$field,
                                                        'val'=>$val
                                                ));
                                        }
                                }
                                $this->session->set(array(
                                        'name'=>$name,
                                        'val'=>$val
                                ));
                        }
                }

                if (count($where))
                        return $where;
                return null;
        }

        public function getLabel($name) {
                return array_key_exists($name, $this->cfg->label) ?
                                $this->cfg->getInArray('label', $name) :
                                $this->table->getLabel($name);
        }

        public function clearLink() {
                $prmA = array_merge(array_diff_key(request::get('paramA'), $this->cfg->actionPrmClear), $this->cfg->actionPrmForce);
                $prmA[$this->cfg->clearPrm] = 1;
                return request::uriDef(array('paramA'=>$prmA));
        }

        public function to($type) {
                return $this->form->to($type);
        }

        public function toHtml() {
                return $this->to('html');
        }

        public function __toString() {
                return $this->to(request::get('out'));
        }

}