How to Insert data automatically in Yii2?

Question

Here i need to insert data record automatically in Database using Yii2 when the condition met

i have two table claim and pending

In claim table i have 10 fields including i have another field called turnaroundtime here i will set a date

if the claim table doesn't update on or before the turnaroundtime, then some data from the claim table have to move to another table called pending.

How can i achieve this using Yii 2 Framework

Note: In claim table i also have created_at and updated_at fields also

RKJ · Accepted Answer · 2015-05-04 06:27:12Z

2

you should set a cronjob to run on certain interval of time to invoke some php code that would check the difference between current time, turnaroundtime and updated_at time and move the data to pending table if the condition is met

if((current-time >= turnaroundtime) && (updated_at > turnaroundtime)){
    //move data to pending table
}

edited May 4, 2015 at 6:27

answered May 4, 2015 at 6:11

RKJ

516 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kalaiselvan Mahendiran Over a year ago

thank you very much its working , how can i everytime run cmd prompt

chaintng Over a year ago

You need to set cron job working an interval time. If it's unix server, run crontab -e to set the cron job.

RKJ Over a year ago

docs.phplist.com/CronJobExamples.html. thesitewizard.com/general/set-cron-job.shtml. cronjobs are provided by webservers. If cronjobs are enabled in cpanel you can see it under Advanced tab. If you like this answer please don't forget to upvote my answer !!

Touqeer Shafi · Accepted Answer · 2015-05-04 06:51:18Z

1

in Yii2 yii\db\BaseActiveRecord you can use this beforeSave event.

This method is called at the beginning of inserting or updating a record.

public function beforeSave($insert)
{
    if($insert) { 
        // If data is new
        $this->created_at = date("Y-m-d H:i:s");
    } else { 
        //It's updating
        $this->updated_at = date("Y-m-d H:i:s"); 
    }

    //Make sure you return true because it's an event
    return true;
}

answered May 4, 2015 at 6:51

Touqeer Shafi

5,3043 gold badges31 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to Insert data automatically in Yii2?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related