public function actionAuditLog() { $query = \sammaye\audittrail\AuditTrail::find(); $rules = \yii\helpers\Json::decode(Yii::$app->request->get('rules')); if ($rules) { $translator = new Translator($rules); $query->andWhere($translator->where())->addParams($translator->params()); } $dataProvider = new \yii\data\ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); return $this->render('audit-log', ['dataProvider' => $dataProvider, 'rules' => $rules]); }
/** * Lists all SysUser models. * @return mixed */ public function actionIndex() { $query = SysUser::find(); $rules = \yii\helpers\Json::decode(Yii::$app->request->get('rules')); if ($rules) { $translator = new Translator($rules); $query->andWhere($translator->where())->addParams($translator->params()); } $dataProvider = new \yii\data\ActiveDataProvider(['query' => $query]); return $this->render('index', ['dataProvider' => $dataProvider, 'rules' => $rules]); }
public function testRules() { foreach ($this->rulesProvider() as $rule) { $translator = new Translator($rule[0]); $expected = $rule[1]; $this->assertEquals($expected[0], $translator->where()); $params = $translator->params(); foreach ($expected[1] as $key => $value) { $this->assertArrayHasKey($key, $params); $this->assertEquals($value, $params[$key]); } } }