如何使用动态记录过滤时区列的时间戳

Question

SQLSTATE[42883]：未定义的函数： 7错误：运算符不存在：没有时区的时间戳~~未知LINE 1：...ERE（"transaction_date"=1美元）AND（"transaction_date"喜欢2美元）^提示：没有运算符匹配给定的名称和参数类型。可能需要添加显式类型转换。

public function search($params)
    {
        $query = EpayslipAudit::find()->orderBy(['id'=>SORT_DESC]);

        // add conditions that should always apply here

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        $this->load($params);

        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }

        $query->andFilterWhere([
            'transaction_date' => $this->transaction_date,
        ]);
        $query->andFilterWhere(['like', 'party_id', $this->party_id]);
        $query->andFilterWhere(['like', 'name', $this->name]);
        $query->andFilterWhere(['like', 'email', $this->email]);
        $query->andFilterWhere(['like', 'period', $this->period]);
        $query->andFilterWhere(['like', 'status', $this->status]);
        $query->andFilterWhere(['like', 'action_by', $this->action_by]);
        $query->andFilterWhere(['like', 'transaction_date', $this->transaction_date]);

        return $dataProvider;
    }

Answer 1

那么你应该使用“或”语句。

$query->andFilterWhere(['or', [
   ['transaction_date' => $this->transaction_date],
   ['LIKE', 'transaction_date', $this->transaction_date]
]]);

或者享受“中间”语句，它可以以相同的方式声明。