TP6 查找指定工作日 · 杂记

需求：开发中有时会遇到工作日的问题，比如一个审批需要三个工作日，我们在录入的时候就需要知道三个工作日之后的日期。原理：**利用mysql存储未来指定天数的工作日时间戳，然后利用limit查找** ##### 1.调用方法： ~~~php $getTimeClass = new app\common\common\GetTime(); return $getTimeClass->get_after_date(5); //获取5个工作日之后的日期 ~~~ ##### 2.类demo： ~~~php <?php namespace app\common\common; use think\facade\{Db,Config}; class GetTime { /** * [天行数据] * [接口文档url：https://www.tianapi.com/apiview/139] * @var [type] */ private $readme; /** * [天行数据接口地址] * @var string */ private $base_url = "http://api.tianapi.com/txapi/jiejiari/index"; /** * [天行数据接口秘钥] * @var string */ private $key = "d5ebdaf781005a07a5ca77d62531bb0e"; /** * [数据表前缀] * @var [type] */ protected $tablePrefix; /** * [数据表名字] * @var [type] */ protected $tableName; /** * [拉取天数] * @var integer */ private $time = 120; /** * [构造函数初始化表前缀和表名称] * @Author juming * @DateTime 2021-01-26T16:18:07+0800 */ public function __construct(){ $this->tablePrefix = Config::get('database.connections.mysql.prefix'); $this->tableName = "{$this->tablePrefix}workdays"; return $this; } /** * [获取指定个工作日的日期] * @Author juming * @DateTime 2021-01-26T16:19:05+0800 * @param int $after [description] * @return [type] [description] */ public function get_after_date(int $after){ if($after > 30){ throw new \Exception("Only query data within 30 days is supported"); } self::check_table_exists(); $timestamp = self::get_before_dawn_time(); $data = Db::table($this->tableName)->where('timestamp','>',$timestamp)->limit($after)->column('timestamp'); if(count($data) != $after){ return self::request_and_get_data($after); } $end = end($data); return date('Y-m-d',$end); } /** * [请求天行接口拉取数据] * @Author juming * @DateTime 2021-01-26T16:20:39+0800 * @param int $after [description] * @return [type] [description] */ protected function request_and_get_data(int $after){ set_time_limit(0); $timestamp = self::get_last_date(); for($i=1;$i<=$this->time;$i++){ $date = date('Y-m-d',$timestamp + $i*86400); $get_url = self::get_url($date); $res = json_decode(file_get_contents($get_url),true); if($res['code'] != 200){ throw new \Exception("接口调用失败(错误码：".$res['code'].")"); } if($res['newslist'][0]['isnotwork'] == 0){ $insert['timestamp'] = strtotime($date); Db::table($this->tableName)->insert($insert); } } return self::get_after_date($after); } /** * [获取接口的url] * @Author juming * @DateTime 2021-01-26T16:21:41+0800 * @param String $date [description] * @return [type] [description] */ private function get_url(String $date){ return $this->base_url.'?key='.$this->key.'&date='.$date; } /** * [获取数据表中最后的数据日期] * @Author juming * @DateTime 2021-01-26T16:22:47+0800 * @return [type] [description] */ private function get_last_date(){ $timestamp = Db::table($this->tableName)->order('id','desc')->limit(1)->value('timestamp'); $timestamp = $timestamp ? $timestamp :$this->get_before_dawn_time();; return $timestamp; } /** * [获取当日凌晨时间戳] * @Author juming * @DateTime 2021-01-26T16:23:12+0800 * @return [type] [description] */ protected function get_before_dawn_time(){ return strtotime(date('Y-m-d')); } /** * [检查表是否存在] * @Author juming * @DateTime 2021-01-26T16:23:34+0800 * @return [type] [description] */ protected function check_table_exists(){ $check = Db::query("show tables like '{$this->tableName}'"); if (empty($check)) { $sql = self::getCreateSql(); Db::execute($sql); } } /** * [创建数据表sql语句] * @Author juming * @DateTime 2021-01-26T16:23:58+0800 * @return [type] [description] */ protected function getCreateSql(){ return <<<EOT CREATE TABLE `{$this->tableName}` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `timestamp` int(11) DEFAULT '0' COMMENT '当日时间戳', PRIMARY KEY (`id`), KEY `timestamp` (`timestamp`) USING BTREE COMMENT '当日凌晨时间戳索引' ) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT='工作日记录表'; EOT; } } ~~~ ##### 3.说明：调用类方法时，会首先检查数据库中workdays表是否存在，如果不存在会自动创建workdays表，无需手动创建，使用前请确保数据库配置正确。作者：JuMinggniMuJ 来源：简书著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。