Beispiel #1
0
 /**
  * Execute the query and set up the results iterator
  * @param string|array $formName (if array, must be array of string)
  * @param null|string $submitTimeKeyName
  * @return void
  */
 protected function setDataIterator($formName, $submitTimeKeyName = null)
 {
     $submitTimes = $this->queryRandomSubmitTimes($formName);
     $sql = $this->getPivotQuery($formName, false, $submitTimes);
     $queryOptions = array();
     if ($submitTimeKeyName) {
         $queryOptions['submitTimeKeyName'] = $submitTimeKeyName;
     }
     if (isset($this->options['limit']) && $this->hasFilterOrTransform()) {
         // have data iterator apply the limit if it is not already
         // being applied in SQL directly, which we do when there are
         // no filter constraints.
         $queryOptions['limit'] = $this->options['limit'];
     }
     $unbuffered = false;
     if (isset($this->options['unbuffered'])) {
         $queryOptions['unbuffered'] = $this->options['unbuffered'];
         $unbuffered = $queryOptions['unbuffered'] == 'true';
     }
     if ($this->debug) {
         $queryOptions['debug'] = 'true';
     }
     $this->dataIterator = CFDBQueryResultIteratorFactory::getInstance()->newQueryIterator($unbuffered);
     if ($this->transform && !empty($this->transform->transformIterators)) {
         $postProcessOptions = $queryOptions;
         // make a copy
         // If we have a transform, then alternatively-named options like 'tlimit' are used
         // in the actual query (CFDBQueryResultIterator) whereas the normally named
         // ones are handled by the CFDBTransformEndpoint post-processor
         unset($queryOptions['limit']);
         if (isset($this->options['tlimit'])) {
             $queryOptions['limit'] = $this->options['tlimit'];
         }
         unset($queryOptions['orderby']);
         if (isset($this->options['torderby'])) {
             $queryOptions['orderby'] = $this->options['torderby'];
         }
         // These aren't really needed b/c we have already setup $this->rowTransformFilter
         unset($queryOptions['filter']);
         if (isset($this->options['tfilter'])) {
             $queryOptions['filter'] = $this->options['tfilter'];
         }
         unset($queryOptions['search']);
         if (isset($this->options['tsearch'])) {
             $queryOptions['search'] = $this->options['tsearch'];
         }
         $this->dataIterator->query($sql, $this->rowTransformFilter, $queryOptions);
         $queryDisplayColumns = $this->getColumnsToDisplay($this->dataIterator->columns);
         $this->transform->setTimezone();
         // Hookup query iterator as first transform, hookup last iterator as $this->dataIterator
         $this->transform->setDataSource($this->dataIterator);
         $this->dataIterator = $this->transform->getIterator();
         // $this->dataIterator is a CFDBTransformEndpoint
         $this->dataIterator->getPostProcessor()->query($sql, $this->rowFilter, $postProcessOptions);
         $displayColumns = $this->getColumnsToDisplay($this->dataIterator->getDisplayColumns());
         // Not sure why I need to do this to make show/hide work in some cases
         $this->dataIterator->displayColumns = empty($displayColumns) ? $queryDisplayColumns : $displayColumns;
     } else {
         // No transform, just query
         $this->dataIterator->query($sql, $this->rowFilter, $queryOptions);
         $this->dataIterator->displayColumns = $this->getColumnsToDisplay($this->dataIterator->columns);
     }
 }
 public function test_eval_class_chain_mixed_2()
 {
     $t = new CFDBTransformParser();
     $t->parse('SortByField(fname)&&upperall');
     $t->setupTransforms();
     $data = array(array('fname' => 'zzzz', 'lname' => 'AAAAA'), array('fname' => 'yyyy', 'lname' => 'CCCCC'), array('fname' => 'xxxx', 'lname' => 'BBBBB'));
     $source = new ArrayDataIterator($data);
     $t->setDataSource($source);
     $iter = $t->getIterator();
     $iter->nextRow();
     $this->assertEquals('XXXX', $iter->row['fname']);
     $this->assertEquals('BBBBB', $iter->row['lname']);
     $iter->nextRow();
     $this->assertEquals('YYYY', $iter->row['fname']);
     $this->assertEquals('CCCCC', $iter->row['lname']);
     $iter->nextRow();
     $this->assertEquals('ZZZZ', $iter->row['fname']);
     $this->assertEquals('AAAAA', $iter->row['lname']);
 }