dateUtil.php 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  1. <?php
  2. namespace common\components;
  3. use Yii;
  4. class dateUtil
  5. {
  6. //日期时间转换 ssh 2021.3.4
  7. public static function formatTime($searchTime, $startTime, $endTime, $Stat = false)
  8. {
  9. switch ($searchTime) {
  10. case 'yesterday':
  11. //昨天
  12. $startTime = date("Y-m-d 00:00:00", strtotime("-1 day"));
  13. $endTime = date("Y-m-d 23:59:59", strtotime("-1 day"));
  14. if ($Stat) {
  15. $startTime = date("Ymd", strtotime("-1 day"));
  16. $endTime = date("Ymd", strtotime("-1 day"));
  17. }
  18. break;
  19. case 'today':
  20. //今天
  21. $startTime = date("Y-m-d 00:00:00");
  22. $endTime = date("Y-m-d 23:59:59");
  23. if ($Stat) {
  24. $startTime = date("Ymd");
  25. $endTime = date("Ymd");
  26. }
  27. break;
  28. case 'thisMonth':
  29. //本月
  30. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), 1, date("Y")));
  31. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("t"), date("Y")));
  32. if ($Stat) {
  33. $startTime = date("Ymd", mktime(0, 0, 0, date("m"), 1, date("Y")));
  34. $endTime = date("Ymd", mktime(23, 59, 59, date("m"), date("t"), date("Y")));
  35. }
  36. break;
  37. case 'lastMonth':
  38. //上个月
  39. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
  40. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), 0, date("Y")));
  41. if ($Stat) {
  42. $startTime = date("Ymd", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
  43. $endTime = date("Ymd", mktime(23, 59, 59, date("m"), 0, date("Y")));
  44. }
  45. break;
  46. case 'thisYear':
  47. //今年
  48. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, 1, 1, date("Y")));
  49. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, 1, 0, date("Y", strtotime('+1 year'))));
  50. if ($Stat) {
  51. $startTime = date("Ymd", mktime(0, 0, 0, 1, 1, date("Y")));
  52. $endTime = date("Ymd", mktime(23, 59, 59, 1, 0, date("Y", strtotime('+1 year'))));
  53. }
  54. break;
  55. case 'lastWeek':
  56. //上周
  57. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 - 7, date("Y")));
  58. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 - 7, date("Y")));
  59. break;
  60. case 'thisWeek':
  61. //本周
  62. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y")));
  63. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y")));
  64. break;
  65. case 'thisSeason':
  66. //本季度
  67. //本季度未最后一月天数
  68. $getMonthDays = date("t", mktime(0, 0, 0, date('n') + (date('n') - 1) % 3, 1, date("Y")));
  69. $startTime = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - (date('n') - 1) % 3, 1, date('Y')));
  70. $endTime = date('Y-m-d H:i:s', mktime(23, 59, 59, date('n') + (date('n') - 1) % 3, $getMonthDays, date('Y')));
  71. break;
  72. case 'custom':
  73. //自定义
  74. if (empty($startTime)) {
  75. util::fail('请选择开始时间');
  76. }
  77. if (empty($endTime)) {
  78. util::fail('请选择结束时间');
  79. }
  80. if ($Stat) {
  81. $startTime = date("Ymd", strtotime($startTime));
  82. $endTime = date("Ymd", strtotime($endTime));
  83. } else {
  84. $startTime = $startTime . ' 00:00:00';
  85. $endTime = $endTime . ' 23:59:59';
  86. }
  87. break;
  88. case 'byMonth':
  89. $startTime = $startTime . '-01 00:00:00';
  90. $m = date("m", strtotime($startTime));
  91. $y = date("Y", strtotime($startTime));
  92. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, $m + 1, 0, $y));
  93. if ($Stat) {
  94. $startTime = date("Ymd", strtotime($startTime));
  95. $endTime = date("Ymd", strtotime($endTime));
  96. }
  97. break;
  98. case 'all':
  99. $startTime = "2015-01-01 00:00:00"; //用项目起始日期做开始时间
  100. $endTime = date("Y-m-d 23:59:59");
  101. if ($Stat) {
  102. $startTime = "20150101";
  103. $endTime = date("Ymd");
  104. }
  105. break;
  106. default:
  107. //今天
  108. $startTime = date("Y-m-d 00:00:00");
  109. $endTime = date("Y-m-d 23:59:59");
  110. if ($Stat) {
  111. $startTime = date("Ymd");
  112. $endTime = date("Ymd");
  113. }
  114. }
  115. //外面使用between包含边界
  116. return ['startTime' => $startTime, 'endTime' => $endTime];
  117. }
  118. //获取日期 ssh 2019.9.16
  119. public static function getDate($type = 0)
  120. {
  121. switch ($type) {
  122. case 1:
  123. //最近7天
  124. $start = date('Ymd', strtotime("-7 days"));
  125. $end = date("Ymd");
  126. break;
  127. case 2:
  128. //最近30天
  129. $start = date('Ymd', strtotime("-30 days"));
  130. $end = date("Ymd");
  131. break;
  132. case 3:
  133. //本月
  134. $start = date("Ym") . "01";
  135. $end = date("Ymd");
  136. break;
  137. case 4:
  138. //上个月
  139. $start = date("Ymd", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
  140. $end = date("Ymd", mktime(23, 59, 59, date("m"), 0, date("Y")));
  141. break;
  142. }
  143. return [$start, $end];
  144. }
  145. //取月份 $type=30以上的表示取月份 ssh 2019.12.31
  146. public static function getMonth($type = 30)
  147. {
  148. $end = date("Ym");
  149. switch ($type) {
  150. case 30:
  151. //最近3个月
  152. $start = self::getStartMonth(3);
  153. break;
  154. case 31:
  155. //最近半年
  156. $start = self::getStartMonth(6);
  157. break;
  158. case 32:
  159. //最近一年
  160. $start = self::getStartMonth(12);
  161. break;
  162. case 33:
  163. //今年
  164. $start = date("Y01");
  165. break;
  166. default:
  167. $start = self::getStartMonth(3);
  168. }
  169. return [$start, $end];
  170. }
  171. //获取开始的月份 ssh 2019.12.31
  172. public static function getStartMonth($num)
  173. {
  174. $base = date('Ym01');
  175. for ($i = 1; $i < $num; $i++) {
  176. $start = date('Ym', strtotime('-1 month', strtotime($base)));
  177. $base = $start . '01';
  178. }
  179. return $start;
  180. }
  181. }