/** * init * * @return self */ public function init() { $table = Table::getInstance(); $adapter = new SelectSource(); $adapter->setSource($table->advancedSelect()); $this->setAdapter($adapter); $this->setDefaultLimit(25); $this->setAllowOrders(['title', 'id', 'cost', 'categoryId']); $this->setAllowFilters(['title', 'description', 'categoryId', 'id']); return $this; }
/** * Init SelectSource * @return self */ public function init() { // Array $adapter = new SelectSource(); $select = new Select(); $select->select('*')->from('test', 't'); $adapter->setSource($select); $this->setAdapter($adapter); $this->setDefaultLimit(10); $this->setAllowOrders(['name', 'id', 'status']); $this->setAllowFilters(['status', 'id', 'email']); return $this; }
/** * init * * @return self */ public function init() { // Create Select $select = new Select(); $select->select('u.*, GROUP_CONCAT( ar.`name` SEPARATOR ", " ) AS rolesList')->from('users', 'u')->leftJoin('u', 'acl_users_roles', 'aur', 'u.`id` = aur.`userId`')->leftJoin('aur', 'acl_roles', 'ar', 'ar.`id` = aur.`roleId`')->groupBy('u.id'); // Setup adapter $adapter = new SelectSource(); $adapter->setSource($select); $this->setAdapter($adapter); $this->setDefaultLimit(25); $this->setAllowOrders(['login', 'email', 'status', 'id']); $this->setAllowFilters(['login', 'email', 'status', 'id', 'roleId']); return $this; }
/** * Select Source Exception * @expectedException \Bluz\Grid\GridException */ public function testSelectSourceThrowsGridException() { $adapter = new SelectSource(); $adapter->setSource('wrong source type'); }