Laravel 7：在每个月的第一天自动将值添加到列

发布于 2025-02-04 15:40:52 字数 1265 浏览 4 评论 0原文

我想每个月在表中的所有行中为特定列增加值。

用户表：

ID	离开_Alloc	feluf_earn
1	20	0
2	20	1.5
3	20	-3
4	20	4

控制器：

public function earned_leave(){
  $user = User::where('leave_alloc', '!=', null)->get();
  foreach($user as $row){
    $leave_alloc = $row->leave_alloc;
    $earned_leave = $leave_alloc / 12;
    $row->leave_earn += $earned_leave;
    $row->save();
  }
}

$ enned_leave将是$ wept_alloc由除以的结果12。因此，在每个月的第一天，我想将赢得的休假金额添加到所有用户的well_earn列。此列可以具有负值和小数值。

我该如何进行自动化？

原文

I want to add value to specific column for all rows in a table every month.

Users Table:

id	leave_alloc	leave_earn
1	20	0
2	20	1.5
3	20	-3
4	20	4

Controller:

public function earned_leave(){
  $user = User::where('leave_alloc', '!=', null)->get();
  foreach($user as $row){
    $leave_alloc = $row->leave_alloc;
    $earned_leave = $leave_alloc / 12;
    $row->leave_earn += $earned_leave;
    $row->save();
  }
}

Here $earned_leave will be the result of $leave_alloc divided by 12. So, on the first day of every month, I want to add the earned leave amount to the leave_earn column of all users. This column can hold a negative value and decimal value.

How can I make this automation?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

累赘 2025-02-11 15:40:53

laravel支持任务计划。对于您的任务，您可以使用- ＆gt; monthlyon（4，'15：00'）;

在最简单的实现中，看起来

$schedule->call(function () {
  $user = User::where('leave_alloc', '!=', null)->get();
  foreach($user as $row){
    $earned_leave = $row->leave_alloc / 12;
    $row->leave_earn += $earned_leave;
    $row->save();
  }
})->monthlyOn(1, '12:00');

别忘了添加

Laravel support task scheduling. For your task you may use ->monthlyOn(4, '15:00');

In most simple realization it looks like

$schedule->call(function () {
  $user = User::where('leave_alloc', '!=', null)->get();
  foreach($user as $row){
    $earned_leave = $row->leave_alloc / 12;
    $row->leave_earn += $earned_leave;
    $row->save();
  }
})->monthlyOn(1, '12:00');

Don't forget to add Cron entry

回复收藏 0 原文

~没有更多了~