Home  >  Article  >  Backend Development  >  According to the given date format 'YYYY-mm-dd', get the starting date of the week where the date is located

According to the given date format 'YYYY-mm-dd', get the starting date of the week where the date is located

WBOY
WBOYOriginal
2016-07-25 08:50:201035browse
Common date operations
  1. /**
  2. * Get the start date of all weeks in the year
  3. * @param $year format 'YYYY'
  4. * Return the two-dimensional array subscript key1 value corresponding to the actual year of the week in which a certain day of the year is located, and the key2 value corresponding to the certain day of the year The day of the week [week of the year]
  5. * Returns false The date format is wrong
  6. */
  7. function get_all_weeks($year){
  8. $week_arr = array();
  9. $year = intval(trim($year));
  10. $preg = "/^d{ 4,}$/";
  11. if(!preg_match($preg, $year)){
  12. return false;
  13. }
  14. $begin_day = $year . '-01-01';
  15. $end_day = $year . '- 12-31';
  16. //The first Monday of the year
  17. if(date('w',strtotime($begin_day))!=1){
  18. $begin_day = date('Y-m-d',strtotime(" next monday", strtotime($begin_day)));
  19. }
  20. //The number of weeks where the first Monday is located
  21. $begin_week_num = intval(date('W',strtotime($begin_day)));
  22. //One year Last Sunday
  23. if(date('w',strtotime($end_day))!=0){
  24. $end_day = date('Y-m-d',strtotime("last sunday",strtotime($end_day)));
  25. //There is a New Year's Eve week, and the New Year's Eve week is Monday
  26. $end_day_next = date('Y-m-d',strtotime($end_day)+24*60*60);
  27. //The year and location of the New Year's Eve week Week number
  28. $stride_year = date('o',strtotime($end_day_next));
  29. $stride_weeknum = intval(date('W',strtotime($end_day_next)));
  30. }
  31. //The number of weeks in which the last Sunday is located
  32. $end_week_num = intval(date('W',strtotime($end_day)));
  33. //The first Monday of the year is the first or second week of the year
  34. if($begin_week_num!=1){
  35. $i=2;
  36. }else{
  37. $i=1;
  38. }
  39. $j = 0;
  40. for($i;$i<=$end_week_num;$i++){
  41. $start_date = date("Y-m-d" , strtotime("$begin_day $j week"));
  42. $end_day = date("Y-m-d", strtotime($start_date . '+6 day'));
  43. $week_arr[$year][$i] = array(
  44. $start_date,
  45. $end_day
  46. );
  47. $j++;
  48. }
  49. if($end_day_next){
  50. $week_arr[$stride_year][$stride_weeknum] = array(
  51. $end_day_next,
  52. date("Y-m-d", strtotime( $end_day_next . '+6 day'))
  53. );
  54. }
  55. return $week_arr;
  56. }
  57. //demo_call
  58. /*
  59. $year = '2013';
  60. if(get_all_weeks($year)){
  61. var_dump(get_all_weeks($year));
  62. }else{
  63. echo 'Date format error';
  64. }
  65. */
  66. /**
  67. * Get the start date of the week where a certain day is located
  68. * Depends on the function get_all_weeks
  69. * @param $day format: 'YYYY-mm-dd'
  70. * Returns false because the date format is wrong
  71. * Correct, returns json "{"begin_day": "YYYY-mm-dd","end_day":"YYYY-mm-dd"}"
  72. */
  73. function get_day_week($day){
  74. $date_arr = explode(' -', trim($day));
  75. if(!checkdate(intval($date_arr[1]), intval($date_arr[2]), intval($date_arr[0]))){
  76. return false;
  77. }
  78. $year = date('Y',strtotime($day));
  79. $weeks = get_all_weeks($year);
  80. //The year and week number of a certain day
  81. $real_year = date('o',strtotime ($day));
  82. $week_num = intval(date('W',strtotime($day)));
  83. if(!empty($weeks[$real_year][$week_num][0]))
  84. $begin_day = $weeks[$real_year][$week_num][0];
  85. if(!empty($weeks[$real_year][$week_num][1]))
  86. $end_day = $weeks[$real_year][$week_num] [1];
  87. //New year week value is stored in the previous year
  88. if(empty($begin_day)||empty($end_day)){
  89. $year = date('Y',strtotime($day)) -1;
  90. $weeks = get_all_weeks($year);
  91. $real_year = date('o',strtotime($day));
  92. $week_num = intval(date('W',strtotime($day)));
  93. if(!empty($weeks[$real_year][$week_num][0]))
  94. $begin_day = $weeks[$real_year][$week_num][0];
  95. if(!empty($weeks[$real_year ][$week_num][1]))
  96. $end_day = $weeks[$real_year][$week_num][1];
  97. }
  98. $the_day = array(
  99. 'begin_day' => $begin_day,
  100. 'end_day' => $end_day
  101. );
  102. $the_day = json_encode($the_day);
  103. return $the_day;
  104. }
  105. //demo_call
  106. /*
  107. $day = '2014-01-01';
  108. if(get_day_week ($day)){
  109. var_dump(get_day_week($day));
  110. }else{
  111. echo 'Date format error';
  112. }
  113. */
Copy code


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn