thinkphp获取星期_ThinkPHP中如何获取指定日期后工作日的具体日期

1 <?php2

3 classwork_days4 {5 /**6 * 获取星期7 * @param $date8 * @return mixed9 */

10 function get_week($date)11 {12 //强制转换日期格式

13 $date_str = date('Y-m-d', strtotime($date));14 //封装成数组

15 $arr = explode("-", $date_str);16 //参数赋值17 //年

18 $year = $arr[0];19 //月，输出2位整型，不够2位右对齐

20 $month = sprintf('%02d', $arr[1]);21 //日，输出2位整型，不够2位右对齐

22 $day = sprintf('%02d', $arr[2]);23 //时分秒默认赋值为0；

24 $hour = $minute = $second = 0;25 //转换成时间戳

26 $strap = mktime($hour, $minute, $second, $month, $day, $year);27 //获取数字型星期几

28 $number_wk = date("w", $strap);29 //获取数字对应的星期

30 return $number_wk;31 //自定义星期数组32 //$weekArr = array("星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六");33 //获取数字对应的星期34 //return $weekArr[$number_wk];

35 }36

37 /**38 * 获取指定日期段内每一天的日期39 * @param string $startdate 开始日期40 * @param string $enddate 结束日期41 * @return array42 */

43 function getDateFromRange($startdate, $enddate)44 {45 $stimestamp = strtotime($startdate);46 $etimestamp = strtotime($enddate);47 //计算日期段内有多少天

48 $days = ($etimestamp - $stimestamp) / 86400 + 1;49 //保存每天日期

50 $_list_date = array();51 for ($i = 0; $i < $days; $i++) {52 $_list_date[] = date('Y-m-d', $stimestamp + (86400 * $i));53 }54 return $_list_date;55 }56

57 function curl_post($url, $data = null)58 {59 $curl =curl_init();60 curl_setopt($curl, CURLOPT_URL, $url);61 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE);62 curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, FALSE);63 if (!empty($data)) {64 curl_setopt($curl, CURLOPT_POST, 1);65 curl_setopt($curl, CURLOPT_POSTFIELDS, $data);66 }67 curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);68 $output = curl_exec($curl);69 curl_close($curl);70 return $output;71 }72

73

74 /**75 * 更新数据库指定年份日期数据76 * @param $year77 * @return int78 */

79 function updateDate($year)80 {81 $startDate = date('Y-m-d', strtotime($year . '-01-01'));82 $endDate = date('Y-m-d', strtotime('+1 year', strtotime($startDate)) - 86400);83 $_list_date = self::getDateFromRange($startDate, $endDate);84 $url = '/Tools/holiday';//自行查找的免费API

85 $m = M('tb_workday');86 $count = 0;87 foreach ($_list_date as $k => $_date) {88 $_ret = 0;89 $_date = date('Ymd', strtotime($_date));90 $_post_data = array('date' => $_date);91 $_ret_curl = curl_post($url, $_post_data);92 $_ret_curl = json_decode($_ret_curl, true);93

94 //工作日

95 if ($_ret_curl['data'] == 0) {96 $dateData['exact_date'] = $_date;97 $dateData['date_year'] = $year;98 $dateData['date_type'] = 0;99 $_ret = $m->add($dateData) ? 1 : 0;100 unset($dateData);101

102

103 //工作日 判断是否为周末

104 if (in_array(self::get_week($_date), array(0, 1))) {105 //特殊工作日

106 $dateData['exact_date'] = $_date;107 $dateData['date_year'] = $year;108 $dateData['date_type'] = 1;109 $_ret = $m->add($dateData) ? 1 : 0;110 unset($dateData);111 }112 }113

114 //法定节假日

115 if ($_ret_curl['data'] == 2) {116 $dateData['exact_date'] = $_date;117 $dateData['date_year'] = $year;118 $dateData['date_type'] = 2;119 $_ret = $m->add($dateData) ? 1 : 0;120 unset($dateData);121 }122

123 //休息日(周末) 暂不处理

124 /*if ($_ret_curl['data'] == 1) {125

126 }*/

127

128 $_ret && $count++;129 unset($_date, $_post_data, $_ret_curl, $_ret);130 }131 return $count;132 }133

134

135 /**136 * 获取当年所有工作日 (从数据库获取，数据库无数据则先更新数据)137 * @param string $year 当年年份138 * @return array139 */

140 private function getWorkDays($year)141 {142 $m = M('tb_workday');143 $map['date_year'] = $year;144 $map['date_type'] = 0;145 $DateArray = $m->field('exact_date')->where($map)->select();146 if (!empty($DateArray)) {147 $DateArray = array_column($DateArray, 'exact_date');148 return $DateArray;149 } else{150 //更新数据库工作日数据

151 $ret = self::updateDate($year);152 if ($ret > 0) {153 return self::getWorkDays($year);154 } else{155 return false;156 }157 }158 }159

160 /**161 * 获取开始日期后第N个工作日具体日期162 * @param $startdate string 计算开始日期 需包含年月日信息163 * @param $days int 间隔天数164 * @return mixed 成功返回 对应日期，失败返回false165 */

166 public function getNextWorkDate($startdate, $days)167 {168 $year = date('Y', strtotime($startdate));169 $startdate = date('Y-m-d', strtotime($startdate));170 $workDays = $this->getWorkDays($year);171 $search_key = array_search(date('Ymd', strtotime($startdate)), $workDays);172 if ($search_key === false) {//查询日期为非工作173 //获取查询日期前最近工作日

174 $m = M('tb_workday');175 $map['date_year'] = $year;176 $map['date_type'] = 0;177 $map['DATE_FORMAT(`exact_date`,\'%Y-%m-%d\')'] = array('LT', $startdate);178 $_search_date = $m->where($map)->order('`exact_date` DESC')->getField('exact_date');179 $search_key = array_search($_search_date, $workDays);180 unset($m, $map, $_search_date);181 }182 $t_key = $search_key + $days;183 if ($t_key <= count($workDays) - 1) {184 return date('Y-m-d', strtotime($workDays[$t_key]));185 } else{186 //查询日期已跨年

187 $n_days = $days - (count($workDays) - 1 - $search_key);188 $next_year = $year + 1;189 return $this->getNextWorkDate($next_year . '-01-01', $n_days - 1);190 }191 }192 }193

194 $startdate = '-09-28';195 $days = 5;196

197 $class = newwork_days();198 $_date_workday = $class->getNextWorkDate($startdate, $days);199 echo $_date_workday;//-10-10