public function showTodayOrder() { $connection = \Yii::$app->db; //搜索今天所有的订单号 $datetime = date('ymd'); $datesearch = $datetime . '%'; $ordertables = Ordertables::getinstance(); $sql = 'SELECT * FROM ordertables WHERE order_id LIKE \'' . $datesearch . '\''; $command = $connection->createCommand($sql)->queryAll(); return $command; }
/** * Finds the Ordertables model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $order_id * @param string $item_id * @return Ordertables the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($order_id, $item_id) { if (($model = Ordertables::findOne(['order_id' => $order_id, 'item_id' => $item_id])) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }