public function action_index() { TXEvent::on(onSql); $ids = array_keys($this->projectDAO->rightJoin($this->testDAO, ['type' => 'type'])->filter([['name' => 'test'], ['>=' => ['time' => time()]]])->query([['id' => 'projectId']], 'projectId')); $this->userDAO->filter(['projectId' => [2, 3, 4]])->query(); $this->userDAO->leftJoin($this->projectDAO, ['projectId' => 'id'])->rightJoin($this->testDAO, [[], ['type' => 'type']])->filter([[], ['name' => 'test'], ['>=' => ['time' => time()]]])->query(['*']); $result = $this->userDAO->filter(['>=' => ['id' => 20], 'count' => 2])->limit(2)->query(); TXLogger::info($result); $data = $this->getParam('test'); $params = array('test' => $data); // TXDatabase::start(); // $this->testDAO->add(['name'=>'rollback', 'userId'=>10, 'time'=>time(), 'type'=>2]); // $this->userDAO->add(['name'=>'rollback']); // TXDatabase::commit(); return $this->display('main/test', $params); }
/** * 启动类 */ public static function init() { TXEvent::on(onException, ['TXEvent', 'onException']); TXEvent::on(onRequest, ['TXEvent', 'onRequest']); }