dateUtil.php 7.9 KB

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