dateUtil.php 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198
  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 'last30Days':
  56. //近30天(含今天)
  57. $startTime = date("Y-m-d 00:00:00", strtotime("-29 days"));
  58. $endTime = date("Y-m-d 23:59:59");
  59. if ($Stat) {
  60. $startTime = date("Ymd", strtotime("-29 days"));
  61. $endTime = date("Ymd");
  62. }
  63. break;
  64. case 'lastWeek':
  65. //上周
  66. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 - 7, date("Y")));
  67. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 - 7, date("Y")));
  68. break;
  69. case 'thisWeek':
  70. //本周
  71. $startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y")));
  72. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y")));
  73. break;
  74. case 'thisSeason':
  75. //本季度
  76. //本季度未最后一月天数
  77. $getMonthDays = date("t", mktime(0, 0, 0, date('n') + (date('n') - 1) % 3, 1, date("Y")));
  78. $startTime = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - (date('n') - 1) % 3, 1, date('Y')));
  79. $endTime = date('Y-m-d H:i:s', mktime(23, 59, 59, date('n') + (date('n') - 1) % 3, $getMonthDays, date('Y')));
  80. break;
  81. case 'custom':
  82. //自定义
  83. if (empty($startTime)) {
  84. util::fail('请选择开始时间');
  85. }
  86. if (empty($endTime)) {
  87. util::fail('请选择结束时间');
  88. }
  89. if ($Stat) {
  90. $startTime = date("Ymd", strtotime($startTime));
  91. $endTime = date("Ymd", strtotime($endTime));
  92. } else {
  93. $startTime = $startTime . ' 00:00:00';
  94. $endTime = $endTime . ' 23:59:59';
  95. }
  96. break;
  97. case 'byMonth':
  98. $startTime = $startTime . '-01 00:00:00';
  99. $m = date("m", strtotime($startTime));
  100. $y = date("Y", strtotime($startTime));
  101. $endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, $m + 1, 0, $y));
  102. if ($Stat) {
  103. $startTime = date("Ymd", strtotime($startTime));
  104. $endTime = date("Ymd", strtotime($endTime));
  105. }
  106. break;
  107. case 'all':
  108. $startTime = "2015-01-01 00:00:00"; //用项目起始日期做开始时间
  109. $endTime = date("Y-m-d 23:59:59");
  110. if ($Stat) {
  111. $startTime = "20150101";
  112. $endTime = date("Ymd");
  113. }
  114. break;
  115. default:
  116. //今天
  117. $startTime = date("Y-m-d 00:00:00");
  118. $endTime = date("Y-m-d 23:59:59");
  119. if ($Stat) {
  120. $startTime = date("Ymd");
  121. $endTime = date("Ymd");
  122. }
  123. }
  124. //外面使用between包含边界
  125. return ['startTime' => $startTime, 'endTime' => $endTime];
  126. }
  127. //获取日期 ssh 2019.9.16
  128. public static function getDate($type = 0)
  129. {
  130. switch ($type) {
  131. case 1:
  132. //最近7天
  133. $start = date('Ymd', strtotime("-7 days"));
  134. $end = date("Ymd");
  135. break;
  136. case 2:
  137. //最近30天
  138. $start = date('Ymd', strtotime("-30 days"));
  139. $end = date("Ymd");
  140. break;
  141. case 3:
  142. //本月
  143. $start = date("Ym") . "01";
  144. $end = date("Ymd");
  145. break;
  146. case 4:
  147. //上个月
  148. $start = date("Ymd", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
  149. $end = date("Ymd", mktime(23, 59, 59, date("m"), 0, date("Y")));
  150. break;
  151. }
  152. return [$start, $end];
  153. }
  154. //取月份 $type=30以上的表示取月份 ssh 2019.12.31
  155. public static function getMonth($type = 30)
  156. {
  157. $end = date("Ym");
  158. switch ($type) {
  159. case 30:
  160. //最近3个月
  161. $start = self::getStartMonth(3);
  162. break;
  163. case 31:
  164. //最近半年
  165. $start = self::getStartMonth(6);
  166. break;
  167. case 32:
  168. //最近一年
  169. $start = self::getStartMonth(12);
  170. break;
  171. case 33:
  172. //今年
  173. $start = date("Y01");
  174. break;
  175. default:
  176. $start = self::getStartMonth(3);
  177. }
  178. return [$start, $end];
  179. }
  180. //获取开始的月份 ssh 2019.12.31
  181. public static function getStartMonth($num)
  182. {
  183. $base = date('Ym01');
  184. for ($i = 1; $i < $num; $i++) {
  185. $start = date('Ym', strtotime('-1 month', strtotime($base)));
  186. $base = $start . '01';
  187. }
  188. return $start;
  189. }
  190. }