PHP Kwf_Model_Select::whereNotEquals方法代码示例

 protected function _getSelect($row)
 {
     $ret = new Kwf_Model_Select();
     foreach ($this->_groupBy as $k => $field) {
         if (is_array($field)) {
             $values = $field;
             $field = $k;
             $valueFound = false;
             foreach ($values as $value) {
                 if ($row->{$field} == $value) {
                     $valueFound = true;
                     $ret->whereEquals($field, $value);
                     break;
                 }
             }
             if (!$valueFound) {
                 $ret->whereNotEquals($field, $values);
             }
         } else {
             if (is_null($row->{$field})) {
                 $ret->whereNull($field);
             } else {
                 $ret->whereEquals($field, $row->{$field});
             }
         }
     }
     return $ret;
 }

 public function testProcessInputFileUploadedNothingExisting()
 {
     $file = tempnam('/tmp', 'uploadtest');
     file_put_contents($file, 'foo');
     $input = array('File' => array('error' => 0, 'tmp_name' => $file, 'type' => 'plain/text', 'name' => 'test.txt'));
     $data = $this->_field->processInput($this->_row, $input);
     $s = new Kwf_Model_Select();
     $s->whereNotEquals('id', array($this->_uploadId1, $this->_uploadId2));
     $r = $this->_uploadsModel->getRow($s);
     $this->assertEquals($data, array('File' => $r->id));
 }

 public function filter($row)
 {
     if (is_null($this->_sourceField)) {
         $value = $row->__toString();
     } else {
         $f = $this->_sourceField;
         $value = $row->{$f};
     }
     $value = Kwf_Filter::filterStatic($value, 'Ascii');
     if ($row instanceof Kwf_Model_Row_Interface) {
         $select = new Kwf_Model_Select();
         foreach ($this->_groupBy as $f) {
             $select->whereEquals($f, $row->{$f});
         }
         $pk = $row->getModel()->getPrimaryKey();
         if ($row->{$pk}) {
             $select->whereNotEquals($pk, $row->{$pk});
         }
         $x = 0;
         $unique = $value;
         while (!$this->_isUnique($unique, $select, $row->getModel())) {
             $unique = $value . '_' . ++$x;
         }
     } else {
         $where = array();
         foreach ($this->_groupBy as $f) {
             if (is_null($row->{$f})) {
                 $where["ISNULL({$f})"] = '';
             } else {
                 $where["{$f} = ?"] = $row->{$f};
             }
         }
         foreach ($row->getPrimaryKey() as $k => $i) {
             if (!is_null($i)) {
                 $where["{$k} != ?"] = $i;
             }
         }
         $x = 0;
         $unique = $value;
         $where["{$this->_field} = ?"] = $unique;
         while ($row->getTable()->fetchAll($where)->count() > 0) {
             $unique = $value . '_' . ++$x;
             $where["{$this->_field} = ?"] = $unique;
         }
     }
     return $unique;
 }

 public function filter($row)
 {
     if (is_null($this->_sourceField)) {
         $value = $row->__toString();
     } else {
         $f = $this->_sourceField;
         $value = $row->{$f};
     }
     $value = Kwf_Filter::filterStatic($value, 'Ascii');
     $select = new Kwf_Model_Select();
     foreach ($this->_groupBy as $f) {
         $select->whereEquals($f, $row->{$f});
     }
     $pk = $row->getModel()->getPrimaryKey();
     if ($row->{$pk}) {
         $select->whereNotEquals($pk, $row->{$pk});
     }
     $x = 0;
     $unique = $value;
     while (!$this->_isUnique($unique, $select, $row->getModel())) {
         $unique = $value . '_' . ++$x;
     }
     return $unique;
 }

 private function _convertSelectForSibling($select, $m)
 {
     $s = new Kwf_Model_Select();
     if ($p = $select->getPart(Kwf_Model_Select::WHERE_EQUALS)) {
         foreach ($p as $f => $v) {
             if (!in_array($f, $this->_getOwnColumns()) && $m->hasColumn($f)) {
                 $s->whereEquals($f, $v);
             }
         }
     }
     if ($p = $select->getPart(Kwf_Model_Select::WHERE_NOT_EQUALS)) {
         foreach ($p as $f => $v) {
             if (!in_array($f, $this->_getOwnColumns()) && $m->hasColumn($f)) {
                 $s->whereNotEquals($f, $v);
             }
         }
     }
     if ($p = $select->getPart(Kwf_Model_Select::WHERE_NULL)) {
         foreach ($p as $f) {
             if (!in_array($f, $this->_getOwnColumns()) && $m->hasColumn($f)) {
                 $s->whereNull($f);
             }
         }
     }
     if ($p = $select->getPart(Kwf_Model_Select::WHERE_EXPRESSION)) {
         foreach ($p as $expr) {
             $e = $this->_convertExprForSibling($expr, $m);
             if ($e) {
                 $s->where($e);
             }
         }
     }
     return $s;
 }

 public function jsonMakeHomeAction()
 {
     $id = $this->_getParam('id');
     $row = Kwf_Model_Abstract::getInstance('Kwc_Root_Category_GeneratorModel')->getRow($id);
     if (!$row) {
         throw new Kwf_Exception("didn't find row to set home");
     }
     if (!$this->_hasPermissions($row, 'makeHome')) {
         throw new Kwf_Exception("Making home this row is not allowed.");
     }
     $root = Kwf_Component_Data_Root::getInstance();
     $component = $root->getComponentById($id, array('ignoreVisible' => true));
     if (!$component->generator->getGeneratorFlag('hasHome')) {
         throw new Kwf_Exception("Generator doesn't have hasHome flag set");
     }
     if (get_class($component) != 'Kwf_Component_Data') {
         //da die data klasse auf Kwf_Component_Data_Home angepasst geändert muss kann das nicht
         //gleichzeitig FirstChildPage oder LinkIntern sein. Daher verbieten.
         $name = Kwf_Trl::getInstance()->trlStaticExecute(Kwc_Abstract::getSetting($component->componentClass, 'componentName'));
         throw new Kwf_Exception_Client(trlKwf("You can't set {0} as Home", $name));
     }
     while ($component) {
         if (Kwc_Abstract::getFlag($component->componentClass, 'hasHome')) {
             $homeComponent = $component;
             $component = null;
         } else {
             $component = $component->parent;
         }
     }
     if ($row) {
         $s = new Kwf_Model_Select();
         $s->whereEquals('is_home', true);
         $s->whereNotEquals('id', $id);
         $oldRows = Kwf_Model_Abstract::getInstance('Kwc_Root_Category_GeneratorModel')->getRows($s);
         $oldId = $id;
         $oldVisible = false;
         foreach ($oldRows as $oldRow) {
             $component = $root->getComponentById($oldRow->id, array('ignoreVisible' => true));
             while ($component) {
                 if (Kwc_Abstract::getFlag($component->componentClass, 'hasHome')) {
                     if ($component === $homeComponent) {
                         $oldId = $oldRow->id;
                         $oldVisible = $oldRow->visible;
                         if (!$this->_hasPermissions($oldRow, 'makeHome')) {
                             throw new Kwf_Exception("Making home this row is not allowed.");
                         }
                         $oldRow->is_home = 0;
                         $oldRow->save();
                     }
                     $component = null;
                 } else {
                     $component = $component->parent;
                 }
             }
         }
         $row->is_home = 1;
         $row->save();
         $this->view->home = $id;
         $this->view->oldhome = $oldId;
         $this->view->oldhomeVisible = $oldVisible;
     } else {
         $this->view->error = 'Page not found';
     }
 }

 public function testCreatesImageComponentx()
 {
     $uploadsModel = Kwf_Model_Abstract::getInstance('Kwc_Basic_Text_Image_UploadsModel');
     $upload1 = $uploadsModel->getRows()->current();
     $c = $this->_root->getComponentById(1008)->getComponent();
     $row = $c->getRow();
     $html = '<p><img src="http://www.vivid-planet.com/assets/web/images/structure/logo.png" /></p>';
     $html = $row->tidy($html);
     $this->assertRegExp("#^<p>\n  <img src=\"/kwf/kwctest/Kwc_Basic_Text_Root/media/Kwc_Basic_Text_Image_TestComponent/1008-i1/dh-100-[0-9a-z]+/[0-9a-z]+/[0-9]+/logo.png\" width=\"100\" height=\"100\" />\n</p>\$#ms", $html);
     $cc = array_values($c->getData()->getChildComponents());
     $this->assertEquals(1, count($cc));
     $this->assertEquals('1008-i1', current($cc)->componentId);
     $m = Kwc_Basic_Text_Component::createChildModel($c->getData()->componentClass);
     $rows = $m->getRows($m->select()->whereEquals('component_id', '1008'));
     $this->assertEquals(1, count($rows));
     $row = $rows->current();
     $this->assertEquals('image', $row->component);
     $this->assertEquals('1', $row->nr);
     $s = new Kwf_Model_Select();
     $s->whereNotEquals('id', $upload1->id);
     $upload2 = $uploadsModel->getRows($s)->current();
     $this->assertEquals('image/png', $upload2->mime_type);
     $this->assertEquals('png', $upload2->extension);
     $this->assertEquals('logo', $upload2->filename);
     $this->assertEquals(file_get_contents($upload2->getFileSource()), file_get_contents('http://www.vivid-planet.com/assets/web/images/structure/logo.png'));
     $m = Kwf_Model_Abstract::getInstance('Kwc_Basic_Text_Image_TestModel');
     $rows = $m->getRows($m->select()->whereEquals('component_id', '1008-i1'));
     $this->assertEquals(1, count($rows));
     $row = $rows->current();
     $this->assertEquals($upload2->id, $row->kwf_upload_id);
 }

 public function testCountSelectWhereNotEquals()
 {
     $s = new Kwf_Model_Select();
     $s->whereNotEquals('foo', 'aa');
     $this->assertEquals(5, $this->_m->countRows($s));
 }