123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650 |
- <?php
- /**
- * 求两个已知经纬度之间的距离,单位为米
- * @param lng1 $ ,lng2 经度
- * @param lat1 $ ,lat2 纬度
- * @return float 距离,单位米
- * @author www.Alixixi.com
- */
- if (!function_exists('getdistance')) {
- function getdistance($lng1, $lat1, $lng2, $lat2)
- {
- // 将角度转为狐度
- $radLat1 = deg2rad($lat1); //deg2rad()函数将角度转换为弧度
- $radLat2 = deg2rad($lat2);
- $radLng1 = deg2rad($lng1);
- $radLng2 = deg2rad($lng2);
- $a = $radLat1 - $radLat2;
- $b = $radLng1 - $radLng2;
- $s = 2 * asin(sqrt(pow(sin($a / 2), 2) + cos($radLat1) * cos($radLat2) * pow(sin($b / 2), 2))) * 6378.137 * 1000;
- return $s;
- }
- }
- if (!function_exists('float_number')) {
- function float_number($number)
- {
- $number = intval($number);
- $length = strlen(intval($number)); //数字长度
- if ($length > 3) { //万单位
- //截取前俩为
- $str = substr_replace(strstr($number, substr($number, -2), ' '), '.', -1, 0) . "公里";
- } else {
- return $number . '米';
- }
- return $str . '米';
- }
- }
- if (!function_exists('build_field_option')) {
- function build_field_option($name = null, $selected = null, $type = null)
- {
- //获取选项列表
- $fields = \addons\qingdongams\model\Field::getField($name, $type);
- $html = '<option value="">请选择' . $name . '</option>';
- foreach ($fields as $v) {
- if ($selected == $v) {
- $html .= "<option value='{$v}' selected='selected'>{$v}</option>";
- } else {
- $html .= "<option value='{$v}'>{$v}</option>";
- }
- }
- return $html;
- }
- }
- //修改多维数组为一位数组
- if (!function_exists('modify_array')) {
- function modify_array($arr, $field1, $field2)
- {
- $data = [];
- foreach ($arr as $v) {
- $data[$v[$field1] ?? ''] = $v[$field2] ?? '';
- }
- return $data;
- }
- }
- //显示文件夹
- if (!function_exists('showdir')) {
- function showdir($path)
- {
- $dh = opendir($path);//打开目录
- $arr = [];
- while (($d = readdir($dh)) != false) {
- //逐个文件读取,添加!=false条件,是为避免有文件或目录的名称为0
- if ($d == '.' || $d == '..') {//判断是否为.或..,默认都会有
- continue;
- }
- if (is_dir($path . '/' . $d)) {//如果为目录
- $lowers = showdir($path . '/' . $d);//继续读取该目录下的目录或文件
- if ($lowers) {
- $arr = array_merge($arr, $lowers);
- }
- } else {
- $arr[] = $path . '/' . $d;
- }
- }
- return $arr;
- }
- }
- //获取年度列表
- if (!function_exists('getYears')) {
- function getYears()
- {
- $start = 2020;
- $years = [];
- $toYear = date('Y');
- $end = date('Y') + 1;
- for ($start; $start <= $end; $start++) {
- if ($start == $toYear) {
- $years[] = [
- 'id' => $start,
- 'name' => $start . '年',
- 'selected' => 'selected'
- ];
- } else {
- $years[] = [
- 'id' => $start,
- 'name' => $start . '年',
- ];
- }
- }
- return $years;
- }
- }
- ///随机字符串,字母+数字
- if (!function_exists('genRandomString')) {
- function genRandomString($len, $t = 0)
- {
- $chars = array(
- "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k",
- "l", "m", "n", "p", "q", "r", "s", "t", "u", "v",
- "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G",
- "H", "I", "J", "K", "L", "M", "N", "P", "Q", "R",
- "S", "T", "U", "V", "W", "X", "Y", "Z"
- );
- $chars1 = array(
- "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k",
- "l", "m", "n", "p", "q", "r", "s", "t", "u", "v",
- "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G",
- "H", "I", "J", "K", "L", "M", "N", "P", "Q", "R",
- "S", "T", "U", "V", "W", "X", "Y", "Z"
- );
- $chars2 = array(
- "1", "2",
- "3", "4", "5", "6", "7", "8", "9"
- );
- $chars3 = array(
- "A", "B", "C", "D", "E", "F", "G", "O",
- "H", "I", "J", "K", "L", "M", "N", "P", "Q", "R",
- "S", "T", "U", "V", "W", "X", "Y", "Z"
- );
- $chars4 = array(
- "A", "B", "C", "D", "E", "F", "G",
- "H", "I", "J", "K", "L", "M", "N", "P", "Q", "R",
- "S", "T", "U", "V", "W", "X", "Y", "Z", "1", "2",
- "3", "4", "5", "6", "7", "8", "9"
- );
- if ($t == 1) {
- $charsLen = count($chars1) - 1;
- shuffle($chars1); // 将数组打乱
- $output = "";
- for ($i = 0; $i < $len; $i++) {
- $output .= $chars1[mt_rand(0, $charsLen)];
- }
- } elseif ($t == 2) {
- $charsLen = count($chars2) - 1;
- shuffle($chars2); // 将数组打乱
- $output = "";
- for ($i = 0; $i < $len; $i++) {
- $output .= $chars2[mt_rand(0, $charsLen)];
- }
- } elseif ($t == 3) {
- $charsLen = count($chars3) - 1;
- shuffle($chars3); // 将数组打乱
- $output = "";
- for ($i = 0; $i < $len; $i++) {
- $output .= $chars3[mt_rand(0, $charsLen)];
- }
- } elseif ($t == 4) {
- $charsLen = count($chars4) - 1;
- shuffle($chars4); // 将数组打乱
- $output = "";
- for ($i = 0; $i < $len; $i++) {
- $output .= $chars4[mt_rand(0, $charsLen)];
- }
- } else {
- $charsLen = count($chars) - 1;
- shuffle($chars); // 将数组打乱
- $output = "";
- for ($i = 0; $i < $len; $i++) {
- $output .= $chars[mt_rand(0, $charsLen)];
- }
- }
- return $output;
- }
- }
- //将表情进行转义 用于存储的时候
- if (!function_exists('emoji_encode')) {
- function emoji_encode($str)
- {
- if (!is_string($str)) return $str;
- if (!$str || $str == 'undefined') return '';
- $text = json_encode($str); //暴露出unicode
- $text = preg_replace_callback("/(\\\u[2def][0-9a-f]{3})/i", function ($str) {
- return addslashes($str[0]);
- }, $text); //将emoji的unicode留下,其他不动,这里的正则比原答案增加了d,因为我发现我很多emoji实际上是\ud开头的,反而暂时没发现有\ue开头。
- return json_decode($text);
- }
- }
- //将表情进行反转义 用于读取的时候
- if (!function_exists('emoji_decode')) {
- function emoji_decode($str)
- {
- $text = json_encode($str); //暴露出unicode
- $text = preg_replace_callback('/\\\\\\\\/i', function ($str) {
- return '\\';
- }, $text); //将两条斜杠变成一条,其他不动
- return json_decode($text);
- }
- }
- //过滤emoji
- if (!function_exists('filter_Emoji')) {
- function filter_Emoji($str)
- {
- $str = preg_replace_callback( //执行一个正则表达式搜索并且使用一个回调进行替换
- '/./u',
- function (array $match) {
- return strlen($match[0]) >= 4 ? '' : $match[0];
- },
- $str);
- return $str;
- }
- }
- //获取编号
- if (!function_exists('get_num')) {
- function get_num($type)
- {
- return 'R' . date('Ymd') . rand(10000, 99999);
- }
- }
- if (!function_exists('setTimes')) {
- /**
- * @param $times
- * @param string $type date|datetime|time
- * @return array|string
- */
- function setTimes($times, $type = 'date')
- {
- switch ($times) {
- case 'today':
- $today = date('Y-m-d');
- $todayend = date('Y-m-d');
- $result = [$today, $todayend];
- break;
- case 'yesterday':
- $yesterday = date('Y-m-d', strtotime('-1 day'));
- $result = [$yesterday, $yesterday];
- break;
- case 'tomorrow':
- $tomorrow = date('Y-m-d', strtotime('+1 day'));
- $result = [$tomorrow, $tomorrow];
- break;
- case 'thisweek':
- $thisweek_start = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y")));
- $thisweek_end = date("Y-m-d", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y")));
- $result = [$thisweek_start, $thisweek_end];
- break;
- case 'lastweek':
- $lastweek_start = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 - 7, date("Y")));
- $lastweek_end = date("Y-m-d", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 - 7, date("Y")));
- $result = [$lastweek_start, $lastweek_end];
- break;
- case 'nextweek':
- $lastweek_start = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 + 7, date("Y")));
- $lastweek_end = date("Y-m-d", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 + 7, date("Y")));
- $result = [$lastweek_start, $lastweek_end];
- break;
- case 'thismonth':
- $thismonth_start = date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y")));
- $thismonth_end = date("Y-m-d", mktime(23, 59, 59, date("m"), date("t"), date("Y")));
- $result = [$thismonth_start, $thismonth_end];
- break;
- case 'lastmonth':
- $lastmonth_start = date("Y-m-d", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
- $lastmonth_end = date("Y-m-d", mktime(23, 59, 59, date("m"), 0, date("Y")));
- $result = [$lastmonth_start, $lastmonth_end];
- break;
- case 'nextmonth':
- $nextmonth_start = date("Y-m-d", mktime(0, 0, 0, date("m") + 1, 1, date("Y")));
- $nextmonth_end = date("Y-m-d", mktime(23, 59, 59, date("m") + 1, date("t"), date("Y")));
- $result = [$nextmonth_start, $nextmonth_end];
- break;
- case 'thisquarter':
- //本季度未最后一月天数
- $getMonthDays = date("t", mktime(0, 0, 0, date('n') + (date('n') - 1) % 3, 1, date("Y")));
- //本季度/
- $thisquarter_start = date('Y-m-d', mktime(0, 0, 0, date('n') - (date('n') - 1) % 3, 1, date('Y')));
- $thisquarter_end = date('Y-m-d', mktime(23, 59, 59, date('n') + (date('n') - 1) % 3, $getMonthDays, date('Y')));
- $result = [$thisquarter_start, $thisquarter_end];
- break;
- case 'lastquarter':
- //上季度未最后一月天数
- $getMonthDays = date("t", mktime(0, 0, 0, date('n') + (date('n') - 1) % 3 - 3, 1, date("Y")));
- $thisquarter_start = date('Y-m-d', mktime(0, 0, 0, date('n') - (date('n') - 1) % 3 - 3, 1, date('Y')));
- $thisquarter_end = date('Y-m-d', mktime(23, 59, 59, date('n') + (date('n') - 1) % 3 - 3, $getMonthDays, date('Y')));
- $result = [$thisquarter_start, $thisquarter_end];
- break;
- case 'nextquarter':
- //下季度未最后一月天数
- $getMonthDays = date("t", mktime(0, 0, 0, date('n') + (date('n') - 1) % 3 + 3, 1, date("Y")));
- $thisquarter_start = date('Y-m-d', mktime(0, 0, 0, date('n') - (date('n') - 1) % 3 + 3, 1, date('Y')));
- $thisquarter_end = date('Y-m-d', mktime(23, 59, 59, date('n') + (date('n') - 1) % 3 + 3, $getMonthDays, date('Y')));
- $result = [$thisquarter_start, $thisquarter_end];
- break;
- case 'thisyear':
- //今年
- $thisyear_start = date('Y') . '-1-1';
- $thisquarter_end = date('Y') . '-12-31';
- $result = [$thisyear_start, $thisquarter_end];
- break;
- case 'lastyear':
- //去年
- $lastyear_start = date('Y')-1 . '-1-1';
- $lastyear_end = date('Y')-1 . '-12-31';
- $result = [$lastyear_start, $lastyear_end];
- break;
- case 'nextyear':
- //下一年
- $nextyear_start = date('Y')+1 . '-1-1';
- $nextyear_end = date('Y')+1 . '-12-31';
- $result = [$nextyear_start, $nextyear_end];
- break;
- case 'else'://其他
- $dates=input('dates','','trim');
- $times = explode(' - ', $dates);
- $result = [$times[0] ?? date('Y-m-d'), $times[1] ?? date('Y-m-d')];
- break;
- default:
- $times = explode(',', $times);
- $result = [$times[0] ?? date('Y-m-d'), $times[1] ?? date('Y-m-d')];
- break;
- }
- if ($type == 'date') {
- return $result;
- } elseif ($type == 'datetime') {
- $result[0] = date('Y-m-d H:i:s', strtotime($result[0]));
- $result[1] = date('Y-m-d H:i:s', strtotime($result[1]) + 86400 - 1);
- return $result;
- } elseif ($type == 'time') {
- $result[0] =strtotime($result[0]);
- $result[1] =strtotime($result[1]) + 86400 - 1;
- return $result;
- } else {
- return $result;
- }
- }
- }
- if (!function_exists('export_excel')){
- //导出excel
- function export_excel($title, $expTableData, $excel = 'export')
- {
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment;filename=' . $excel . '.xlsx');
- header('Cache-Control: max-age=0');
- $obj = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
- // 以下内容是excel文件的信息描述信息
- $obj->getProperties()->setTitle('导出文件'); //设置标题
- $obj->setActiveSheetIndex(0);
- $obj->getActiveSheet()->setTitle('导出文件');
- /* 循环读取每个单元格的数据 */
- $a = 'A';
- $currentSheet = $obj->getActiveSheet();
- foreach ($title as $key => $value) {
- //读取工作表1
- // 设置第一行加粗
- $obj->getActiveSheet()->getStyle($a . '1')->getFont()->setBold(true);
- //这里是设置单元格的内容
- $currentSheet->getCell($a . '1')->setValue($value);
- $a++;
- }
- //行数循环
- $b = 2;
- foreach ($expTableData as $k => $row) {
- $a = 'A';
- foreach ($row as $key => $value) {
- //这里是设置单元格的内容
- $currentSheet->getCell($a . $b)->setValue($value);
- $a++;
- }
- $b++;
- }
- $PHPWriter = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($obj);
- $fileName = $excel . date('YmdHis') . '.xlsx';
- $file_path = ROOT_PATH . 'public' . '/export/' . date('Y-m-d') . '/' . $fileName;
- // 创建文件夹
- $path_info = pathinfo($file_path);
- if ($path_info['dirname'] && !is_dir($path_info['dirname'])) {
- $result = create_dir($path_info['dirname']);
- if (false === $result) {
- return false;
- }
- }
- $PHPWriter->save($file_path);
- $datas['filePath'] = '/' . 'export/' . date('Y-m-d') . '/' . $fileName;
- $datas['fileName'] = $fileName;
- $datas['size'] = filesize('./' . 'export/' . date('Y-m-d') . '/' . $fileName);
- return $datas;
- }
- }
- if (!function_exists('create_dir')){
- /**
- * 创建文件夹,可以多级创建
- * @param string $filename 需要创建的文件夹路径
- * @return boolean
- */
- function create_dir($filename) {
- if (!is_dir($filename)) {
- create_dir(dirname($filename));
- return mkdir($filename, 0777);
- }
- return true;
- }
- }
- if (!function_exists('convertAmountToCn')){
- /**
- * 将数值金额转换为中文大写金额
- * @param $amount float 金额(支持到分)
- * @param $type int 补整类型,0:到角补整;1:到元补整
- * @return mixed 中文大写金额
- */
- function convertAmountToCn($amount, $type = 1)
- {
- // 判断输出的金额是否为数字或数字字符串
- if (!is_numeric($amount)) {
- return "要转换的金额只能为数字!";
- }
- // 金额为0,则直接输出"零元整"
- if ($amount == 0) {
- return "人民币零元整";
- }
- // 金额不能为负数
- if ($amount < 0) {
- return "要转换的金额不能为负数!";
- }
- // 金额不能超过万亿,即12位
- if (strlen($amount) > 12) {
- return "要转换的金额不能为万亿及更高金额!";
- }
- // 预定义中文转换的数组
- $digital = array('零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖');
- // 预定义单位转换的数组
- $position = array('仟', '佰', '拾', '亿', '仟', '佰', '拾', '万', '仟', '佰', '拾', '元');
- // 将金额的数值字符串拆分成数组
- $amountArr = explode('.', $amount);
- // 将整数位的数值字符串拆分成数组
- $integerArr = str_split($amountArr[0], 1);
- // 将整数部分替换成大写汉字
- $result = '';
- $integerArrLength = count($integerArr); // 整数位数组的长度
- $positionLength = count($position); // 单位数组的长度
- for ($i = 0; $i < $integerArrLength; $i++) {
- // 如果数值不为0,则正常转换
- if ($integerArr[$i] != 0) {
- $result = $result . $digital[$integerArr[$i]] . $position[$positionLength - $integerArrLength + $i];
- } else {
- // 如果数值为0, 且单位是亿,万,元这三个的时候,则直接显示单位
- if (($positionLength - $integerArrLength + $i + 1) % 4 == 0) {
- $result = $result . $position[$positionLength - $integerArrLength + $i];
- }
- }
- }
- // 如果小数位也要转换
- if ($type == 0) {
- // 将小数位的数值字符串拆分成数组
- $decimalArr = str_split($amountArr[1], 1);
- // 将角替换成大写汉字. 如果为0,则不替换
- if ($decimalArr[0] != 0) {
- $result = $result . $digital[$decimalArr[0]] . '角';
- }
- // 将分替换成大写汉字. 如果为0,则不替换
- if ($decimalArr[1] != 0) {
- $result = $result . $digital[$decimalArr[1]] . '分';
- }
- } else {
- $result = $result . '整';
- }
- return $result;
- }
- }
- if (!function_exists('getItemNumber')) {
- function getItemNumber($type)
- {
- if ($type == 'quote') {
- return 'Q' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'consume') {
- return 'F' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'contract') {
- return 'K' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'workorder') {
- return 'W' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'export') {
- return 'Ck' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'import') {
- return 'Rk' . date('ymd') . rand(1, 9999);
- }
- if ($type == 'receivables') {
- return 'R' . date('ymd') . rand(1, 9999);
- }
- return date('ymd') . rand(1, 9999);
- }
- }
- //获取date时间列表
- if (!function_exists('getDateList')) {
- function getDateList($start_time, $end_time)
- {
- $data = [];
- for ($i = $start_time; $i < $end_time; $i = $i + 86400) {
- $data[] = date('Y-m-d', $i);
- }
- return $data;
- }
- }
- if (!function_exists('getRatio')) {
- //获取比例
- function getRatio($number, $achievement)
- {
- if (empty($number)) {
- return 0;
- }
- if ($achievement == 0) {
- return 0;
- }
- return $achievement ? intval(sprintf("%.2f", $number / $achievement) * 100) : 0;
- }
- }
- //根据时间段获取所包含的年份
- function getYearByTime($start_time, $end_time)
- {
- $yearArr = [];
- $monthArr = monthList($start_time, $end_time);
- foreach ($monthArr as $v) {
- $yearArr[date('Y',$v)] = date('Y',$v);
- }
- return array_values($yearArr);
- }
- /**
- * 生成从开始月份到结束月份的月份数组
- * @param int $start 开始时间戳
- * @param int $end 结束时间戳
- */
- function monthList($start,$end){
- if (!is_numeric($start) || !is_numeric($end) || ($end <= $start)) return '';
- $start = date('Y-m',$start);
- $end = date('Y-m',$end);
- //转为时间戳
- $start = strtotime($start.'-01');
- $end = strtotime($end.'-01');
- $i = 0;
- $d = array();
- while ($start <= $end) {
- //这里累加每个月的的总秒数 计算公式:上一月1号的时间戳秒数减去当前月的时间戳秒数
- $d[$i] = $start;
- $start += strtotime('+1 month',$start)-$start;
- $i++;
- }
- return $d;
- }
- //根据时间段获取所包含的月份
- function getmonthByTime($start_time, $end_time)
- {
- $monthList = [];
- $monthArr = monthList($start_time, $end_time);
- foreach ($monthArr as $v) {
- $monthList[date('Y',$v)][] = date('m',$v);
- }
- return $monthList;
- }
|