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); } }