我如何才能找到准确的工作时间在一天和休息时间在一天？

3vpjnl9f  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(535)

我有一天的休息时间和工作时间，我如何才能找到一天的确切工作时间和休息时间？
上班时间是这样的

以前我只有一个场景，比如7月2日，在这种情况下，我把休息时间转换成小时，然后直接从工作时间中扣除。

  1. $secondsPerHour = 3600;
  3. // Getting break entries
  4. $breakTimeEntries = TimeEntries::select('start_date', 'start_time', 'end_time', 'hour_type')
  5.                                ->where('hour_type', 'break') 
  6.                                ->orderBy('start_date')->get();
  8. $breakDurationPerDayArray = array();
  9. // Looping through all the break entries and getting the break entries for each day
  10. foreach($breakTimeEntries as $breakTimeEntry) {
  11.     $startDate = $breakTimeEntry->start_date;
  12.     $breakStartTime = $breakTimeEntry->start_time;
  13.     $breakEndTime = $breakTimeEntry->end_time;
  15.     $breakHours = $breakEndTime - $breakStartTime;
  16.     $breakHoursInSeconds = $breakHours/$secondsPerHour;
  18.     // Adding the break entry for the day to array
  19.     $breakTimePerDayArray[$startDate] = $breakHoursInSeconds;
  20. }
  22. // Getting work entries
  23. $breakTimeEntries = TimeEntries::select('start_date', 'start_time', 'end_time', 'hour_type')
  24.                                ->where('hour_type', 'work') 
  25.                                ->orderBy('start_date')->get();
  27. $workAndBreakHoursArray = array();                             
  28. // Looping through all the work entries and getting the actual work entries for each day
  29. foreach($breakTimeEntries as $breakTimeEntry) {                            
  30.     $workStartTime = $workTimeEntry->start_time;
  31.     $workEndTime = $workTimeEntry->end_time;
  33.     $workHours = $workEndTime - $workStartTime;
  34.     $workHoursInSeconds = $breakHours/$secondsPerHour;
  36.     $startDate = $breakTimeEntry->start_date;
  38.     // Checking wether the start date is in array
  39.     if(in_array($startDate, $breakDurationPerDayArray)) {
  40.         $breakHoursInSeconds = $breakDurationPerDayArray[$startDate];
  41.         $actualWorkedHours = $workHoursInSeconds - $breakHoursInSeconds;
  42.         //To get the worked hours in minutes
  43.         $actualWorkedHoursInMins = $actualWorkedHours/$secondsPerHour;
  44.         //To get the break hours in minutes
  45.         $breakHoursInMin =  $breakHoursInSeconds/$secondsPerHour;
  46.         $workAndBreakHoursArray[$startDate] = ['worked_hours' => $actualWorkedHoursInMins, 'break_hours' => $breakHoursInMin];
  47.     } else {
  48.         //To get the worked hours in minutes
  49.         $workHoursInMins = $workHoursInSeconds/$secondsPerHour;
  50.         $workAndBreakHoursArray[$startDate] = ['worked_hours' => $workHoursInMins, 'break_hours' => 0];
  51.     }
  52. }

此时此刻我已经没有主意了。任何人都建议最好的处理方法。
预期产量是这样的，以小时为单位

  1. [
  2.     [2018-07-02] => [Work => 8, Break =>1],
  3.     [2018-07-03] => [Work => 8, Break =>1],
  4.     [2018-07-04] => [Work => 8, Break =>1],
  5.     [2018-07-05] => [Work => 3.5, Break =>0.5],
  6.     [2018-07-06] => [Work => 4.5, Break =>0.5],
  7.     [2018-07-09] => [Work => 3.5, Break =>0.5],
  8.     [2018-07-10] => [Work => 4.5, Break =>0.5]
  9. ]

数据库链接

mysqlphplaravel-5.2

1条答案

按热度按时间
5n0oy7gb

5n0oy7gb1#

你给拉威尔贴了标签，所以我猜你在用它。它包含了碳，它是一个伟大的工具，一切与时间有关。https://carbon.nesbot.com/docs/#difference
edit1:下面是一个示例，假设您规范化了条目：

  1. $entries = [
  2.     [
  3.         'type'  => 'work',
  4.         'start' => 1310198400,
  5.         'end'   => 1310230800,
  6.     ],
  7.     [
  8.         'type'  => 'break',
  9.         'start' => 1310212800,
  10.         'end'   => 1310216400,
  11.     ],
  12.     [
  13.         'type'  => 'work',
  14.         'start' => 1310284800,
  15.         'end' => 1310299200,
  16.     ],
  17.     [
  18.         'type'  => 'break',
  19.         'start' => 1310299200,
  20.         'end' => 1310302800,
  21.     ],
  22.     [
  23.         'type'  => 'work',
  24.         'start' => 1310302800,
  25.         'end' => 1310317200,
  26.     ],
  27.     [
  28.         'type'  => 'work',
  29.         'start' => 1310371200,
  30.         'end' => 1310385600,
  31.     ],
  32.     [
  33.         'type'  => 'break',
  34.         'start' => 1310384700,
  35.         'end' => 1310387400,
  36.     ],
  37.     [
  38.         'type'  => 'work',
  39.         'start' => 1310387400,
  40.         'end' => 1310403600,
  41.     ]
  42. ];
  44. $workEntries = collect();
  45. $breakEntries = collect();
  47. foreach ($entries as $entry)
  48. {
  49.     if ($entry['type'] == 'work')
  50.         $workEntries->push($entry);
  52.     else if ($entry['type'] == 'break')
  53.         $breakEntries->push($entry);
  54. }
  56. /*
  57.     For each work entry, check if any break entry overlaps.
  59. * /
  61. foreach ($workEntries as $workEntry)
  62. {
  63.     $workStart  = $workEntry['start'];
  64.     $workEnd    = $workEntry['end'];
  66.     foreach ($breakEntries as $breakEntry)
  67.     {
  68.         $breakStart         = $breakEntry['start'];
  69.         $breakEnd           = $breakEntry['end'];
  70.         $overlapDuration    = 0;
  72.         if (!Carbon::createFromTimestamp($workStart)->isSameDay(Carbon::createFromTimestamp($breakStart)))
  73.             continue;
  75.         /*
  76.             Check if work and break overlap
  78.             Scenario 1:
  79.                 Break started mid-work
  81.             Scenario 2:
  82.                 Break started before work
  83.         */
  84.         if (($breakStart >= $workStart) || ($breakStart < $workStart))
  85.         {
  86.             if ($breakStart >= $workStart)
  87.                 $overlapStart = $breakStart;
  89.             else if ($breakStart < $workStart)
  90.                 $overlapStart = $workStart;
  92.             /*
  93.                 Break ends before work ends (or simultaneously)
  94.             */
  95.             if ($breakEnd <= $workEnd)
  96.                 $overlapEnd = $breakEnd;
  98.             /*
  99.                 Break ends after work ends
  100.             */
  101.             else
  102.                 $overlapEnd = $workEnd;
  104.             /*
  105.                 Calculate overlap length
  106.             */
  107.             $overlapDuration = $overlapEnd - $overlapStart;
  108.         }
  110.         /*
  111.             Actual time worked that day is time worked - breaks that overlap work periods.
  112.             Get human-friendly date (day, month, year), display.
  113.         */
  114.         $workDuration = ($workEnd - $workStart - $overlapDuration)/3600;
  115.         $date = Carbon::createFromTimestamp($workStart)->toFormattedDateString();
  117.         dump("Time worked on $date is $workDuration h.");
  118.     }
  119. }

将打印：

  1. "Time worked on Jul 9, 2011 is 8 h."
  2. "Time worked on Jul 10, 2011 is 4 h."
  3. "Time worked on Jul 10, 2011 is 4 h."
  4. "Time worked on Jul 11, 2011 is 3.75 h."
  5. "Time worked on Jul 11, 2011 is 4.5 h."

我假设对每天的数据进行分组不会带来太多麻烦：）
edit2:在我做一个工作示例之前，我没有注意到你更改了你的问题，所以请原谅数据没有按你想要的格式显示。再说一次，让它符合你的需要应该是一项简单的任务。

展开查看全部
赞(0）分享  回复(0）举报  2021-06-21
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com