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"]));
        foreach ($list as $k => $v){
            if (strtotime(date("Y-m-d",$v["entry_time"])) == ($dates - 24*60*60*$j)) {
                $iPP;
                $jPP;
            } else {
                if ($i > $times) $times = $i;
                $i = 1;
                $j = 0;
                if ($k+1 < count($list)) $dates = strtotime(date("Y-m-d",$list[$k+1]["entry_time"]));
            }
        }
        if ($i > $times) $times = $i;
    }
    return $times;
}
public function getMotionDates($accountId)
{
    $entryRecord = EntryRecord::find()
        ->alias("er")
        ->joinWith(["members m"], FALSE)
        ->where(["m.member_account_id" => $accountId])
        ->select("er.entry_time")
        ->groupBy(["DATE_FORMAT(from_unixtime(er.entry_time),"%Y-%m-%d")"])
        ->orderBy("er.entry_time desc")
        ->asArray()
        ->all();
    return $entryRecord;
}


2

Php yii

Mar.22,2021

solve it in a different way without extra query overhead. Add two fields to the user table: the number of days in a row and the date of the last sign-in. When signing in, judge whether the last day is today, if nothing is done; if it is yesterday, PP, update the last date; if it is the day before yesterday or longer, change the number of days to 1, update the last date

function getSustainedDays()
{
    $list = [
        ['entry_time'=>'2018-01-01'],    
        ['entry_time'=>'2018-01-02'],    
        ['entry_time'=>'2018-01-04'],    
        ['entry_time'=>'2018-01-05'],    
        ['entry_time'=>'2018-01-06'],    
        ['entry_time'=>'2018-01-07'],    
        ['entry_time'=>'2018-01-09']
    ];
    $times = 0;
    $max = count($list)-1;
    if ($list) {
        $arr = [];
        $i = 0;
        $j = 0;
        $dates = strtotime($list[0]['entry_time']);
        foreach ($list as $k => $v){
            
            $now =  strtotime( $v['entry_time']);
            if ($now == ($dates +  24*60*60*$j)) {
                $iPP;
                $jPP;
                echo $k;
            } else {
                array_push($arr,$i);
                $i = 1;
                $j=1;
                if ($k+1 < count($list)) $dates = $now;
        
            }
            if($k==$max){
                array_push($arr,$i);
            }
                             
        }
        print_r($arr);
            $times = max($arr);
        
    }
    return $times;
}
echo getSustainedDays();

:
public function getSustainedDays($accountId)
{
    $list = $this->getMotionDates($accountId);
    $len = 1;
    $max = 1;
    if ($list) {
        foreach ($list as $k => $v){
            if ($k+1 == count($list)) break;
            if ((strtotime(date("Y-m-d",$list[$k]['entry_time'])) - 60*60*24) == strtotime(date("Y-m-d",$list[$k+1]['entry_time']))) {
                $lenPP;
            } else {
                if ($len > $max) $max = $len;
                $len = 1;
            }
            if ($len > $max) $max = $len;
        }
    }
    return $max;
}

Previous: RabbitMQ is deployed on an intranet server. Is there any way for APP to receive a push?

Next: VUE date and time format is removed. 0

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
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, ...

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