得到第一个或最后一个周五在一个月
我试图写这样得到第一个或最后一个周五在一个月
function get_date($month, $year, $week, $day, $direction)
{
....
}
$week
日历功能是一个整数(1,2,3 ...),$日是日(星期日,星期一......)或号码,以较容易的为准。方向有点混乱,因为它做了不同的计算。
举一个例子,我们姑且称之为
get_date(5, 2009, 1, 'Sun', 'forward');
它使用默认值,并获得的第一个星期日2009-05-03五月即。如果我们调用
get_date(5, 2009, 2, 'Sun', 'backward');
,则返回2009-05-24五月即第二最后一个星期日。
也许它可以做得更快...
这是非常有趣的代码。
请注意:$direction
是1向前-1向后缓和的事情了:)
此外,$day
始于周一值为1,并在7日结束。
function get_date($month, $year, $week, $day, $direction) {
if($direction > 0)
$startday = 1;
else
$startday = date('t', mktime(0, 0, 0, $month, 1, $year));
$start = mktime(0, 0, 0, $month, $startday, $year);
$weekday = date('N', $start);
if($direction * $day >= $direction * $weekday)
$offset = -$direction * 7;
else
$offset = 0;
$offset += $direction * ($week * 7) + ($day - $weekday);
return mktime(0, 0, 0, $month, $startday + $offset, $year);
}
我举几个例子进行了测试,似乎总是工作,确保虽然仔细检查它;)
哦,还请注意,星期一= 1,星期日= 7 – MartinodF 2009-05-29 04:30:25
语言无关的版本:
要获得每月的第一天特别,用一个月的第一天开始:YYYY-MM-01。使用任何可用的函数来给出与一周中的某一天相对应的数字。从您要查找的那天起减去该数字;例如,如果一个月的第一天是星期三(2),并且您正在寻找星期五(4),则从4中减去2,并留下2.如果答案是否定的,请添加7.最后,将其添加到第一个这个月;就我的例子而言,第一个星期五将是第三个星期。
要得到本月的最后一个星期五,找到下个月的第一个星期五并减去7天。
只是找出问题的月份的第一天和最后一天是什么(即2009年5月1日是星期五和2009年5月31日是星期日)我相信大多数PHP函数使用星期一= 0,星期日= 6 ,因此星期五= 4,所以你知道星期日(6) - 星期五(4)= 2,然后31-2 = 29,这意味着本月的最后一个星期五是29日。对于第一个星期五,如果数字是负数,则加7,如果数字是0,则该月从星期五开始。
strtotime()可以帮助你。例如
<?php
$tsFirst = strtotime('2009-04-00 next friday');
$tsLast = strtotime('2009-05-01 last friday');
echo date(DATE_RFC850, $tsFirst), " | ", date(DATE_RFC850, $tsLast);
打印
Friday, 03-Apr-09 00:00:00 CEST | Friday, 24-Apr-09 00:00:00 CEST
无需计算或循环 - 这是很容易的strtotime()做:
查找第N或特定的某一天中最后一次出现在一个月:
/////////////////////////////////////////////////////////////////
// Quick Code
/////////////////////////////////////////////////////////////////
// Convenience mapping.
$Names = array(0=>"Sun", 1=>"Mon", 2=>"Tue", 3=>"Wed", 4=>"Thu", 5=>"Fri", 6=>"Sat");
// Specify what we want
// In this example, the Second Monday of Next March
$tsInMonth = strtotime('March');
$Day = 1;
$Ord = 2;
// The actual calculations
$ThisMonthTS = strtotime(date("Y-m-01", $tsInMonth));
$NextMonthTS = strtotime(date("Y-m-01", strtotime("next month", $tsInMonth)));
$DateOfInterest = (-1 == $Ord)
? strtotime("last ".$Names[$Day], $NextMonthTS)
: strtotime($Names[$Day]." + ".($Ord-1)." weeks", $ThisMonthTS);
/////////////////////////////////////////////////////////////////
// Explanation
/////////////////////////////////////////////////////////////////
// Specify the month of which we are interested.
// You can use any timestamp inside that month, I'm using strtotime for convenience.
$tsInMonth = strtotime('March');
// The day of interest, ie: Friday.
// It can be 0=Sunday through 6=Saturday (Like 'w' from date()).
$Day = 5;
// The occurrence of this day in which we are interested.
// It can be 1, 2, 3, 4 for the first, second, third, and fourth occurrence of the day in question in the month in question.
// You can also use -1 to fine the LAST occurrence. That will return the fifth occurrence if there is one, else the 4th.
$Ord = 3;
////////////////////////////////////////////////////////////////
// We now have all the specific values we need.
// The example values above specify the 3rd friday of next march
////////////////////////////////////////////////////////////////
// We need the day name that corresponds with our day number to pass to strtotime().
// This isn't really necessary = we could just specify the string in the first place, but for date calcs, you are more likely to have the day number than the string itself, so this is convenient.
$Names = array(0=>"Sun", 1=>"Mon", 2=>"Tue", 3=>"Wed", 4=>"Thu", 5=>"Fri", 6=>"Sat");
// Calculate the timestamp at midnight of the first of the month in question.
// Remember $tsInMonth is any date in that month.
$ThisMonthTS = strtotime(date("Y-m-01", $tsInMonth));
// Calculate the timestamp at midnight of the first of the FOLLOWING month.
// This will be used if we specify -1 for last occurrence.
$NextMonthTS = strtotime(date("Y-m-01", strtotime("next month", $tsInMonth)));
// Now we just format the values a bit and pass them to strtotime().
// To find the 1,2,3,4th occurrence, we work from the first of the month forward.
// For the last (-1) occurence,work we work back from the first occurrence of the following month.
$DateOfInterest = (-1 == $Ord) ?
strtotime("last ".$Names[$Day], $NextMonthTS) : // The last occurrence of the day in this month. Calculated as "last dayname" from the first of next month, which will be the last one in this month.
strtotime($Names[$Day]." + ".($Ord-1)." weeks", $ThisMonthTS); // From the first of this month, move to "next dayname" which will be the first occurrence, and then move ahead a week for as many additional occurrences as you need.
function get_date($month, $year, $week, $day) {
# $month, $year: current month to search in
# $week: 0=1st, 1=2nd, 2=3rd, 3=4th, -1=last
# $day: 0=mon, 1=tue, ..., 6=sun
$startday=1; $delta=0;
if ($week < 0) {
$startday = date('t', mktime(0, 0, 0, $month, 1, $year)); # 28..31
$delta=1;
}
$start = mktime(0, 0, 0, $month, $startday, $year);
$dstart = date('w', $start)-1; # last of the month falls on 0=mon,6=sun
$offset=$day-$dstart; if ($offset<$delta){$offset+=7;}
$newday=$startday+$offset+($week*7);
return mktime(0, 0, 0, $month, $newday, $year);
}
这对我的作品,并根据语言无关的版本:-) 只是太糟糕了,我需要做的是增量的事情(因为如果最后一天这个月是需要的周日,我们不需要减去7)
PHP的内置时间函数使得这个很简单。
http://php.net/manual/en/function.strtotime.php
// Get first Friday of next month.
$timestamp = strtotime('first fri of next month');
// Get second to last Friday of the current month.
$timestamp = strtotime('last fri of this month -7 days');
// Format a timestamp as a human-meaningful string.
$formattedDate = date('F j, Y', strtotime('first wed of last month'));
请注意,我们总是希望确保我们定义为使用正确的时区与strtotime
使PHP有哪里来计算,以哪个时区的时间戳相对的理解该机认为它在。
date_default_timezone_set('America/New_York');
$formattedDate = date('F j, Y', strtotime('first wed of last month +1 week'));
echo date('Y-m-d',strtotime('last friday'));
同样可以很优雅地使用DateTime
类来完成。
$time_zone = new DateTimeZone('Europe/Ljubljana');
$first_friday_of_this_month = new DateTime('first Friday of this month', $time_zone);
$last_friday_of_this_month = new DateTime('last Friday of this month', $time_zone);
echo $first_friday_of_this_month->format('Y-m-d'); # 2015-11-06
echo $last_friday_of_this_month->format('Y-m-d'); # 2015-11-27
这似乎每次都很完美;它需要提供任何日期,并返回该月的最后一个星期五的日期,即使在该月的5个星期五的情况下。
function get_last_friday_of_month($inDate) {
$inDate = date('Y-m-24', strtotime($inDate));
$last_friday = date('Y-m-d',strtotime($inDate.' next friday'));
$next_friday = date('Y-m-d',strtotime($inDate.' next friday'));
if(date('m', strtotime($last_friday)) === date('m', strtotime($next_friday))){
$last_friday = $next_friday;
}else{
//
}
return $last_friday;
}
下面是最快的解决方案,您可以在所有条件下使用。如果你稍微调整一下,你也可以得到一整天的数组。
function findDate($date, $week, $weekday){
# $date is the date we are using to get the month and year which should be a datetime object
# $week can be: 0 for first, 1 for second, 2 for third, 3 for fourth and -1 for last
# $weekday can be: 1 for Monday, 2 for Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday and 7 for Sunday
$start = clone $date;
$finish = clone $date;
$start->modify('first day of this month');
$finish->modify('last day of this month');
$finish->modify('+1 day');
$interval = DateInterval::createFromDateString('1 day');
$period = new DatePeriod($start, $interval, $finish);
foreach($period AS $date){
$result[$date->format('N')][] = $date;
}
if($week == -1)
return end($result[$weekday]);
else
return $result[$weekday][$week];
}
$date = DateTime::createFromFormat('d/m/Y', '25/12/2016');
# find the third Wednesday in December 2016
$result = findDate($date, 2, 3);
echo $result->format('d/m/Y');
我希望这会有所帮助。
让我知道你是否需要任何进一步的信息。
只是为了好奇心..你在用什么?! 这不是那么简单,但可以做任何事。 – MartinodF 2009-05-29 03:24:09
我在写作业调度程序。一些职位是每月的,我需要能够确定日历中显示他们的日期。 – Zahymaka 2009-05-29 03:32:15
为你写下来,希望它能像你期望的那样工作! – MartinodF 2009-05-29 04:23:23