The problem of repeating the sports date?

:
public function getMemberPhysicalTestDate()
{
    $arr = MemberPhysicalTest::find()
        ->alias("mpt")
        ->joinWith(["member m"],FALSE)
        ->where([
            "m.member_account_id" => $this->accountId,
            "mpt.type" => $this->type,
            "mpt.is_delete" => 0
        ])
        ->select("mpt.create_at")
        ->groupBy(["DATE_FORMAT(from_unixtime(mpt.create_at),"%Y-%m-%d")"])
        ->orderBy("mpt.create_at desc")
        ->asArray()
        ->all();
    return $arr;
}

this method doesn"t work very well: only the first item is found, and the second one is not found on June 26th.

Php yii

Mar.22,2021

public function getMemberPhysicalTestDate()
{
    $arr = MemberPhysicalTest::find()
        ->alias('mpt')
        ->joinWith(['member m'],FALSE)
        ->where([
            'm.member_account_id' => $this->accountId,
            'mpt.type' => $this->type,
            'mpt.is_delete' => 0
        ])
        ->select(["DATE_FORMAT(mpt.create_at,'%Y-%m-%d') as testDate"])
        ->groupBy(["DATE_FORMAT(mpt.create_at,'%Y-%m-%d')"])
        ->orderBy('mpt.create_at desc')
        ->asArray()
        ->all();
    return $arr;
}
groupByfrom_unixtimeok

Previous: Mini Program reported an error when introducing Mini Program's plug-in into the wepy framework.

Next: What's the difference between the way js creates classes function and class?

When Yii2 ActiveRecord save (), the non-date type field is set to Expression verification failure, is there a solution within the framework?
$model = new Test(); $model->uuid = new Expression( UUID() ); $model->create = new Expression( NOW() ); if($model->save() === false) { echo(json_encode($model->getErrors()));exit; } else echo( saved ); the output is shown as:...

Php yii

Feb.27,2021
How to realize the Web Page Preview function by PHP
premise: to generate a landing page according to a template, DB stores only the pictures or text information to be replaced. < hr > to make an online landing page creation tool, how to realize the preview function after the H5 page is finished, simil...

Php yii2

Mar.10,2021
Yii restful request 405
the default RESTful, in the advanced application template prompts 405 Method Not Allowed [version 2.0] except GET I follow the similar method of creating a new application body in the advanced application template in this article, copy the Backend app...

Yii2 php yii

Mar.18,2021
Calculation of the longest continuous exercise days
app public function getSustainedDays($accountId) { $list = $this->getMotionDates($accountId); $times = 0; if ($list) { $i = 0; $j = 0; $dates = strtotime(date("Y-m-d",$list[0][ entry_time ])); fo...

Php yii

Mar.22,2021
How to understand self in PHP?
class A { const STR = "A"; public function x() { echo self::STR; } } class B extends A{ const STR = "B"; } (new B)->x(); the final output is A. how do you underst...

Php laravel thinkphp yii

Mar.28,2021
Error reported using YII exit function, logout? not found
sign out as written in the document: Yii::app()->user->logout(); the result reported a 500 error. ERROR: 2018-06-28 14:18:20 ip[127.0.0.1] requestId[951106107] [exception.CException] callId[0] [] CException: Session and its behaviors do not ...

Php yii

Mar.29,2021
How to set yii2, url does not add the module name, directly routed to the default module? Thank you
there are multiple modules under my frontend. How to set yii2. Url will be routed directly to the default module without adding the module name? Thank you ...

Php yii

Mar.31,2021
When Yii2 is enabled, debug does not display the debugging toolbar (online environment)
yii2 framework, debug toolbar is not displayed after opening debug, online environment does not display, but offline can be displayed as shown below, none online. After the code is uploaded online, only the database configuration is modified, but the r...

Php yii2 debug

Apr.03,2021
Nginx cannot cross domains
No one answered once before, probably because the description of the question is not very detailed configure the nginx server as follows: add_header Access-Control-Allow-Origin $http_origin; add_header Access-Control-Allow-Headers Cookie,Set-Cooki...

Nginx php yii thinkphp5

Oct.27,2021
Is there a problem with apache configuring https?
the server uses Aliyun ECS, to build a lampp environment, and the ssl certificate is downloaded from Tencent Cloud, . From the Internet to find some configuration tutorials, has not been successful. Visit your own website http is normal, https is not no...

Php yii linux apache centos

Jan.10,2022