예제 #1
0
파일: firebird.php 프로젝트: atk4/atk4
 public function execute()
 {
     if (empty($this->args['fields'])) {
         $this->args['fields'] = array('*');
     }
     return parent::execute();
 }
예제 #2
0
파일: Lister.php 프로젝트: atk4/atk4
 /**
  * Similar to setModel, however you specify array of data here. setSource is
  * actually implemented around :php:class:`Controller_Data_Array`. actually
  * you can pass anything iterateable to setSource() as long as elements of
  * iterating produce either a string or array.
  *
  * @param mixed $source
  * @param array|string|null $fields
  *
  * @return $this
  */
 public function setSource($source, $fields = null)
 {
     // Set DSQL
     if ($source instanceof DB_dsql) {
         $this->dq = $source;
         return $this;
     }
     // SimpleXML and other objects
     if (is_object($source)) {
         if ($source instanceof Model) {
             throw $this->exception('Use setModel() for Models');
         } elseif ($source instanceof Controller) {
             throw $this->exception('Use setController() for Controllers');
         } elseif ($source instanceof Iterator || $source instanceof Closure) {
             $this->iter = $source;
             return $this;
         }
         // Cast non-iterable objects into array
         $source = (array) $source;
     }
     // Set Array as a data source
     if (is_array($source)) {
         $m = $this->setModel('Model', $fields);
         $m->setSource('Array', $source);
         return $this;
     }
     // Set manually
     $this->dq = $this->app->db->dsql();
     $this->dq->table($source)->field($fields ?: '*');
     return $this;
 }
예제 #3
0
 /** Use extended postgresql syntax for fetching ID */
 function SQLTemplate($mode)
 {
     $template = parent::SQLTemplate($mode);
     switch ($mode) {
         case 'insert':
             return $template . " returning id";
     }
     return $template;
 }
예제 #4
0
파일: Model.php 프로젝트: atk4/atk4
 /** Deletes record matching the ID */
 public function delete($id = null)
 {
     if (!is_null($id)) {
         $this->load($id);
     }
     if (!$this->loaded()) {
         throw $this->exception('Unable to determine which record to delete');
     }
     $tmp = $this->dsql;
     $this->initQuery();
     $delete = $this->dsql->where($this->id_field, $this->id);
     $delete->owner->beginTransaction();
     $this->hook('beforeDelete', array($delete));
     $delete->delete();
     $this->hook('afterDelete');
     $delete->owner->commit();
     $this->dsql = $tmp;
     $this->unload();
     return $this;
 }
예제 #5
0
파일: prefixed.php 프로젝트: easyconn/atk4
 function join($table, $on, $type = 'inner')
 {
     return parent::join($this->prefix . $table, $alias);
 }
예제 #6
0
 function init()
 {
     parent::init();
     $this->sql_templates['update'] = "update [table] set [set] [where]";
 }
예제 #7
0
파일: sqlite.php 프로젝트: easyconn/atk4
 function init()
 {
     parent::init();
     $this->sql_templates['describe'] = "pragma table_info([table_noalias])";
 }
예제 #8
0
파일: Basic.php 프로젝트: atk4/atk4
 /**
  * Recursively render this view.
  */
 public function recursiveRender()
 {
     // get data source
     if (!$this->source) {
         // force grid sorting implemented in Grid_Advanced
         if ($this->owner instanceof Grid_Advanced) {
             $this->owner->getIterator();
         }
         // set data source for Paginator
         if ($this->owner->model) {
             $this->setSource($this->owner->model);
         } elseif ($this->owner->dq) {
             $this->setSource($this->owner->dq);
         } else {
             throw $this->exception('Unable to find source for Paginator');
         }
     }
     // calculate found rows
     if ($this->source instanceof DB_dsql) {
         $this->source->preexec();
         $this->found_rows = $this->source->foundRows();
     } elseif ($this->source instanceof Model) {
         $this->found_rows = (int) $this->source->count();
     } else {
         $this->found_rows = count($this->source);
     }
     // calculate current page and total pages
     $this->cur_page = (int) floor($this->skip / $this->ipp) + 1;
     $this->total_pages = (int) ceil($this->found_rows / $this->ipp);
     if ($this->cur_page > $this->total_pages || $this->cur_page == 1 && $this->skip != 0) {
         $this->cur_page = 1;
         if ($this->memorize) {
             $this->memorize('skip', $this->skip = 0);
         }
         if ($this->source instanceof DB_dsql) {
             $this->source->limit($this->ipp, $this->skip);
             $this->source->rewind();
             // re-execute the query
         } elseif ($this->source instanceof Model) {
             $this->source->setLimit($this->ipp, $this->skip);
         } else {
             // Imants: not sure if this is correct, but it was like this before
             $this->source->setLimit($this->ipp, $this->skip);
         }
     }
     // no need for paginator if there is only one page
     if ($this->total_pages <= 1) {
         return $this->destroy();
     }
     if ($this->cur_page > 1) {
         /** @type View $v */
         $v = $this->add('View', null, 'prev');
         $v->setElement('a')->setAttr('href', $this->app->url($this->base_page, $u = array($this->skip_var => $pn = max(0, $this->skip - $this->ipp))))->setAttr('data-skip', $pn)->set('« Prev');
     } else {
         $this->template->tryDel('prev');
     }
     if ($this->cur_page < $this->total_pages) {
         /** @type View $v */
         $v = $this->add('View', null, 'next');
         $v->setElement('a')->setAttr('href', $this->app->url($this->base_page, $u = array($this->skip_var => $pn = $this->skip + $this->ipp)))->setAttr('data-skip', $pn)->set('Next »');
     } else {
         $this->template->tryDel('next');
     }
     // First page
     if ($this->cur_page > $this->range + 1) {
         /** @type View $v */
         $v = $this->add('View', null, 'first');
         $v->setElement('a')->setAttr('href', $this->app->url($this->base_page, $u = array($this->skip_var => $pn = max(0, 0))))->setAttr('data-skip', $pn)->set('1');
         if ($this->cur_page > $this->range + 2) {
             /** @type View $v */
             $v = $this->add('View', null, 'points_left');
             $v->setElement('span')->set('...');
         }
     }
     // Last page
     if ($this->cur_page < $this->total_pages - $this->range) {
         /** @type View $v */
         $v = $this->add('View', null, 'last');
         $v->setElement('a')->setAttr('href', $this->app->url($this->base_page, $u = array($this->skip_var => $pn = max(0, ($this->total_pages - 1) * $this->ipp))))->setAttr('data-skip', $pn)->set($this->total_pages);
         if ($this->cur_page < $this->total_pages - $this->range - 1) {
             /** @type View $v */
             $v = $this->add('View', null, 'points_right');
             $v->setElement('span')->set('...');
         }
     }
     // generate source for Paginator Lister (pages, links, labels etc.)
     $data = array();
     //setting cur as array seems not working in atk4.3. String is working
     $tplcur = $this->template->get('cur');
     $tplcur = isset($tplcur[0]) ? $tplcur[0] : '';
     $range = range(max(1, $this->cur_page - $this->range), min($this->total_pages, $this->cur_page + $this->range));
     foreach ($range as $p) {
         $data[] = array('href' => $this->app->url($this->base_page, array($this->skip_var => $pn = ($p - 1) * $this->ipp)), 'pn' => $pn, 'cur' => $p == $this->cur_page ? $tplcur : '', 'label' => $p);
     }
     if ($this->ajax_reload) {
         $this->js('click', $this->owner->js()->reload(array($this->skip_var => $this->js()->_selectorThis()->attr('data-skip'))))->_selector('#' . $this->name . ' a');
     }
     parent::setSource($data);
     return parent::recursiveRender();
 }
예제 #9
0
파일: Field.php 프로젝트: atk4/atk4
 /**
  * Modifies specified query to include this particular field.
  *
  * @param DB_dsql $select
  *
  * @return $this
  */
 public function updateSelectQuery($select)
 {
     $p = null;
     if (!empty($this->owner->relations)) {
         $p = $this->owner->table_alias ?: $this->owner->table;
     }
     if ($this->relation) {
         $select->field($this->actual_field ?: $this->short_name, $this->relation->short_name, $this->short_name);
     } elseif (!is_null($this->actual_field) && $this->actual_field != $this->short_name) {
         $select->field($this->actual_field, $p, $this->short_name);
         return $this;
     } else {
         $select->field($this->short_name, $p);
     }
     return $this;
 }
예제 #10
0
파일: prefixed.php 프로젝트: atk4/atk4
 public function join($table, $on, $type = 'inner', $alias = UNDEFINED)
 {
     return parent::join($this->prefix . $table, $alias);
 }