workHour/app/Service/Service.php

<?php

namespace App\Service;


use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Redis;

/**
 * 公用的公共服务
 * @package App\Models
 */
class Service
{

    public $log;
    public $total = 0;

    public function __construct()
    {

    }

    //分页共用
    public function limit($db, $columns, $request)
    {
        $per_page = $request['page_size'] ?? 9999;
        $page = $request['page_index'] ?? 1;
        $return = $db->paginate($per_page, $columns, 'page', $page)->toArray();

        $data['total'] = $return['total'];
        $data['data'] = $return['data'];
        return $data;
    }


    //抽象一个查询条件，省的每天写很多行
    protected function is_exist_db($data, $word, $words, $db, $formula = '=', $type = '')
    {
        if (isset($data[$word]) && ($data[$word] !== null && $data[$word] !== '' && $data[$word] !== [])) {
            switch ($type) {
                case 'time':
                    $data[$word] = ctype_digit($data[$word]) ? $data[$word] : strtotime($data[$word]);
                    if ($formula == '<'||$formula == '<=') $data[$word] += 86400;
                    $db = $db->where($words, $formula, $data[$word]);
                    break;
                case 'like':
                    $db = $db->where($words, $type, '%' . $data[$word] . '%');
                    break;
                case 'in':
                    if (is_array($data[$word])) {
                        $db = $db->wherein($words, $data[$word]);
                    } else {
                        $db = $db->wherein($words, explode(',', $data[$word]));
                    }

                    break;
                default:
                    $db = $db->where($words, $formula, $data[$word]);
                    break;
            }

            return $db;
        }
        return $db;
    }


    //判断是否为空
    protected function isEmpty($data, $word)
    {
        if (isset($data[$word]) && (!empty($data[$word]) || $data[$word] === '0'|| $data[$word] === 0)) return false;
        return true;
    }


    //递归处理数据成子父级关系
    public function makeTree($parentId, &$node)
    {
        $tree = [];
        foreach ($node as $key => $value) {
            if ($value['parent_id'] == $parentId) {
                $tree[$value['id']] = $value;
                unset($node[$key]);
                if (isset($tree[$value['id']]['children'])) {
                    $tree[$value['id']]['children'] = array_merge($tree[$value['id']]['children'], $this->makeTree($value['id'], $node));
                } else {
                    $tree[$value['id']]['children'] = $this->makeTree($value['id'], $node);
                }
            }
        }
        return $tree;
    }

    //进行递归处理数组的排序问题
    public function set_sort_circle($data){
        foreach ($data as $k=>$v){
//            var_dump($v);die;
            if(isset($v['children'])&&!empty($v['children'])){
                $data[$k]['children'] =  $this->set_sort_circle($v['children']);
            }
        }
        $data = array_merge($data);

        return $data;
    }


    //根据编码规则获取每一级的code
    public function get_rule_code($code, $rule)
    {
        $rules = [];
        $num = 0;
        foreach ($rule as $v) {
            $num += $v['num'];
            $code = substr($code, 0, $num);
            if (strlen($code) != $num) continue;
            $rules[] = $code;

        }

        return $rules;
    }



    function curlOpen($url, $config = array())
    {
        $arr = array('post' => false,'referer' => $url,'cookie' => '', 'useragent' => 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; customie8)', 'timeout' => 100, 'return' => true, 'proxy' => '', 'userpwd' => '', 'nobody' => false,'header'=>array(),'gzip'=>true,'ssl'=>true,'isupfile'=>false,'returnheader'=>false,'request'=>'post');
        $arr = array_merge($arr, $config);
        $ch = curl_init();

        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, $arr['return']);
        curl_setopt($ch, CURLOPT_NOBODY, $arr['nobody']);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
        curl_setopt($ch, CURLOPT_USERAGENT, $arr['useragent']);
        curl_setopt($ch, CURLOPT_REFERER, $arr['referer']);
        curl_setopt($ch, CURLOPT_TIMEOUT, $arr['timeout']);


        curl_setopt($ch, CURLOPT_HEADER, $arr['returnheader']);//��ȡheader
        if($arr['gzip']) curl_setopt($ch, CURLOPT_ENCODING, 'gzip,deflate');
        if($arr['ssl'])
        {
            curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
            curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
        }
        if(!empty($arr['cookie']))
        {
            curl_setopt($ch, CURLOPT_COOKIEJAR, $arr['cookie']);
            curl_setopt($ch, CURLOPT_COOKIEFILE, $arr['cookie']);
        }

        if(!empty($arr['proxy']))
        {
            //curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);
            curl_setopt ($ch, CURLOPT_PROXY, $arr['proxy']);
            if(!empty($arr['userpwd']))
            {
                curl_setopt($ch,CURLOPT_PROXYUSERPWD,$arr['userpwd']);
            }
        }

        //ip�Ƚ����⣬�ü�ֵ��ʾ
        if(!empty($arr['header']['ip']))
        {
            array_push($arr['header'],'X-FORWARDED-FOR:'.$arr['header']['ip'],'CLIENT-IP:'.$arr['header']['ip']);
            unset($arr['header']['ip']);
        }
        $arr['header'] = array_filter($arr['header']);

        if(!empty($arr['header']))
        {
            curl_setopt($ch, CURLOPT_HTTPHEADER, $arr['header']);
        }

        if($arr['request'] === 'put'){
            curl_setopt ($ch, CURLOPT_CUSTOMREQUEST, "PUT");
            curl_setopt($ch, CURLOPT_POSTFIELDS,$arr['post']);
        }elseif($arr['post'] != false)
        {
            curl_setopt($ch, CURLOPT_POST, true);
            if(is_array($arr['post']) && $arr['isupfile'] === false)
            {
                $post = http_build_query($arr['post']);
            }
            else
            {
                $post = $arr['post'];
            }
            curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
        }

        $result = curl_exec($ch);
        curl_close($ch);

        return $result;
    }

    function getAllIdsArr($data, $pid = 0, $prefix = '', &$result = []) {
        foreach ($data as $node) {
            if ($node['parent_id'] == $pid) {
                $id = $prefix . $node['id'];
                $result[] = $id;
                $this->getAllIdsArr($data, $node['id'], $id . ',', $result);
            }
        }
        return $result;
    }

    function getLongestStr($arr = [], $searchStr){
        if(empty($arr) || ! $searchStr) return '';
        if(! is_string($searchStr)) $searchStr = (string)$searchStr;

        $longest = '';
        foreach ($arr as $str) {
            if (strpos($str, $searchStr) !== false && strlen($str) > strlen($longest)) {
                $longest = $str;
            }
        }
        return $longest;
    }

    function getAllDescendants($data, $id) {
        $result = array(); // 存储结果的数组

        foreach ($data as $node) {
            if ($node['parent_id'] == $id) { // 如果当前节点的父 ID 等于指定 ID，则将该节点添加到结果中
                $result[] = $node['id'];
                // 递归查询该节点的所有子孙节点，并将结果合并到结果数组中
                $result = array_merge($result, $this->getAllDescendants($data, $node['id']));
            }
        }

        return $result;
    }

    function changeDateToDateMin($time){
        if(empty($time)) return '';

        // 创建一个 DateTime 对象并设置时区为 UTC
        $dateTime = new \DateTime($time, new \DateTimeZone('UTC'));

        // 将时区设置为 PRC
        $dateTime->setTimezone(new \DateTimeZone('Asia/Shanghai'));

        // 将日期时间格式化为特定格式
        $formattedDate = $dateTime->format('Y-m-d H:i:s');

        return $formattedDate;
    }

    //后台端 某些需要限制请求频率的接口
    //需要主动删除  Redis::del($key)
    public function limitingSendRequestBackgNeed($key,$value=0){
        $prefix = config('app.name') . ':';
        $key = $prefix . $key;
        if(! empty($value)) $value = 1;
        // 使用Redis Facade设置，当键名不存在时才设置成功
        if (Redis::setnx($key, $value)) return [true, ''];

        return [false,'操作频繁！'];
    }

    public function dellimitingSendRequestBackgNeed($key){
        $prefix = config('app.name') . ':';
        $key = $prefix . $key;
        Redis::del($key);
    }

    // 校验域名是否通畅可达
    // $domain baidu.com 不要带http这些协议头
    // gethostbyname() 函数可能会受到 PHP 配置中的 allow_url_fopen 和 disable_functions 选项的限制
    function isDomainAvailable($domain) {
        $ip = gethostbyname($domain);

        // 如果解析失败或者返回的 IP 地址与输入的域名相同，则说明域名无效
        if ($ip === $domain || filter_var($ip, FILTER_VALIDATE_IP) === false)  return false;

        return true;
    }

    function changeDateToDate($time, $is_end = false){
        if(empty($time)) return '';

        // 创建一个 DateTime 对象并设置时区为 UTC
        $dateTime = new \DateTime($time, new \DateTimeZone('UTC'));

        // 将时区设置为 PRC
        $dateTime->setTimezone(new \DateTimeZone('Asia/Shanghai'));

        $str = "00:00:00";
        if($is_end) $str = "23:59:59";

        // 将日期时间格式化为特定格式
        $formattedDate = $dateTime->format('Y-m-d ' . $str);

        return strtotime($formattedDate);
    }

    //前端传来的时间段 转换为时间戳
    //精确到秒
    function changeDateToTimeStampAboutRange($time_range, $is_end = true){
        if(empty($time_range[0]) || empty($time_range[1])) return [];

        // 创建一个 DateTime 对象并设置时区为 UTC
        $dateTime = new \DateTime($time_range[0], new \DateTimeZone('UTC'));
        $dateTime1 = new \DateTime($time_range[1], new \DateTimeZone('UTC'));

        // 将时区设置为 PRC
        $dateTime->setTimezone(new \DateTimeZone('Asia/Shanghai'));
        $dateTime1->setTimezone(new \DateTimeZone('Asia/Shanghai'));

        // 将日期时间格式化为特定格式
        $formattedDate = $dateTime->format('Y-m-d');
        $formattedDate1 = $dateTime1->format('Y-m-d');

        $str = " 23:59:59";
        if(! $is_end) $str = " 00:00:00";
        $return = [];
        $return[] = strtotime($formattedDate . " 00:00:00");
        $return[] = strtotime($formattedDate1 . $str);

        return $return;
    }

    /**
     * 检查数字是否合法，并可验证其正负性和小数位数
     *
     * @param mixed $number 要检查的值
     * @param int $decimals 允许的最大小数位数（默认 2）
     * @param string|null $sign 要求的符号：'positive' 大于 0 , 'negative' 小于0, 'zero' 等于0, 'non-negative' 大于或等于 0, 'non-positive' 小于或等于 0 null 表示不限制
     * @param bool $strict 是否严格模式（不允许整数传字符串等）
     * @return array ['valid' => bool, 'error' => string|null, 'info' => array]
     */
    public function checkNumber($number, $decimals = 2, $sign = null, $strict = false)
    {
        $result = [
            'valid' => false,
            'error' => null,
            'info' => []
        ];

        // 1. 类型检查
        if ($strict) {
            if (!is_numeric($number) || is_bool($number)) {
                $result['error'] = '必须是数字类型';
                return $result;
            }
        } else {
            // 宽松模式：允许字符串数字
            if (!is_numeric($number)) {
                $result['error'] = '不是有效数字';
                return $result;
            }
        }

        $num = (float)$number; // 统一转为浮点数处理

        // 2. 正负号检查
        if ($sign !== null) {
            switch ($sign) {
                case 'positive':
                    if ($num <= 0) {
                        $result['error'] = '数字必须大于 0';
                        return $result;
                    }
                    break;
                case 'negative':
                    if ($num >= 0) {
                        $result['error'] = '数字必须小于 0';
                        return $result;
                    }
                    break;
                case 'zero':
                    if ($num != 0) {
                        $result['error'] = '数字必须等于 0';
                        return $result;
                    }
                    break;
                case 'non-negative': // 大于等于 0
                    if ($num < 0) {
                        $result['error'] = '数字必须大于或等于 0';
                        return $result;
                    }
                    break;
                case 'non-positive': // 小于等于 0
                    if ($num > 0) {
                        $result['error'] = '数字必须小于或等于 0';
                        return $result;
                    }
                    break;
                default:
                    $result['error'] = "不支持的符号类型: '{$sign}'";
                    return $result;
            }
        }

        // 3. 小数位数检查
        // 将数字转为标准格式，避免科学计数法
        $numStr = rtrim(rtrim(sprintf('%.10F', $num), '0'), '.'); // 去除末尾无意义的0
        if ($numStr === '' || $numStr === '-') {
            $numStr = '0';
        }

        // 检查是否有小数点
        if (strpos($numStr, '.') === false) {
            $decimalPlaces = 0;
        } else {
            $parts = explode('.', $numStr);
            $decimalPlaces = strlen($parts[1]);
        }

        if ($decimalPlaces > $decimals) {
            $result['error'] = "小数位数超过 {$decimals} 位（实际 {$decimalPlaces} 位）";
            return $result;
        }

        // 4. 附加信息
        $result['valid'] = true;
        $result['info'] = [
            'original' => $number,
            'value' => $num,
            'decimal_places' => $decimalPlaces,
            'sign' => $num > 0 ? 'positive' : ($num < 0 ? 'negative' : 'zero'),
        ];

        return $result;
    }

    function isValidPhone($phone) {
        return preg_match('/^1(3\d|4[5-9]|5[0-35-9]|6[5-7]|7[0-8]|8\d|9[0-35-9])\d{8}$/', $phone);
    }

    public function checkArrayRepeat($data, $column, $title = ""){
        $ids = array_column($data, $column);

        // 检查空值
        if (in_array('', $ids, true) || in_array(null, $ids, true)) {
            return [false, $title . '不能为空'];
        }
        // 检查重复
        if (count($ids) !== count(array_unique($ids))) {
            return [false, $title . '不能重复'];
        }

        return [true, ''];
    }

    /**
     * 生成单据编号
     * @param int $top_depart_id 公司ID
     * @param string $type 单据类型标识 (如 'FEE')
     * @param string $prefix 编号前缀 (如 'FE')
     * @param int $length 流水号长度
     * @return string
     */
    public function generateBillNo($need = [], $length = 5)
    {
        $top_depart_id = $need['top_depart_id'];
        $type = $need['type'];
        $prefix = $need['prefix'] ?? '';
        $period = $need['period']; // 202603

        // 1. 原子更新：存在则自增，不存在则初始化
        // 这样处理不需要 select for update，性能最高且并发安全
        DB::statement("
        INSERT INTO sys_bill_sequences (top_depart_id, bill_type, period, current_value) 
        VALUES (?, ?, ?, 1) 
        ON DUPLICATE KEY UPDATE current_value = current_value + 1
    ", [$top_depart_id, $type, $period]);

        // 2. 获取本次生成的流水号
        $sequence = DB::table('sys_bill_sequences')
            ->where('top_depart_id', $top_depart_id)
            ->where('bill_type', $type)
            ->where('period', $period)
            ->value('current_value');

        // 3. 拼接输出：前缀 + 年月 + 补齐位数的流水号
        // 结果示例：FE26030001
        return $prefix . $period . str_pad($sequence, $length, '0', STR_PAD_LEFT);
    }
}