common.go 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625
  1. package utils
  2. import (
  3. "bufio"
  4. "crypto/md5"
  5. "crypto/sha1"
  6. "encoding/base64"
  7. "encoding/hex"
  8. "encoding/json"
  9. "fmt"
  10. "image"
  11. "image/png"
  12. "io"
  13. "math"
  14. "math/rand"
  15. "net/http"
  16. "os"
  17. "os/exec"
  18. "path"
  19. "regexp"
  20. "strconv"
  21. "strings"
  22. "time"
  23. )
  24. //随机数种子
  25. var rnd = rand.New(rand.NewSource(time.Now().UnixNano()))
  26. func GetRandString(size int) string {
  27. allLetterDigit := []string{"0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "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", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z", "!", "@", "#", "$", "%", "^", "&", "*"}
  28. randomSb := ""
  29. digitSize := len(allLetterDigit)
  30. for i := 0; i < size; i++ {
  31. randomSb += allLetterDigit[rnd.Intn(digitSize)]
  32. }
  33. return randomSb
  34. }
  35. func GetRandStringNoSpecialChar(size int) string {
  36. allLetterDigit := []string{"0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "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", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z"}
  37. randomSb := ""
  38. digitSize := len(allLetterDigit)
  39. for i := 0; i < size; i++ {
  40. randomSb += allLetterDigit[rnd.Intn(digitSize)]
  41. }
  42. return randomSb
  43. }
  44. func StringsToJSON(str string) string {
  45. rs := []rune(str)
  46. jsons := ""
  47. for _, r := range rs {
  48. rint := int(r)
  49. if rint < 128 {
  50. jsons += string(r)
  51. } else {
  52. jsons += "\\u" + strconv.FormatInt(int64(rint), 16) // json
  53. }
  54. }
  55. return jsons
  56. }
  57. //序列化
  58. func ToString(v interface{}) string {
  59. data, _ := json.Marshal(v)
  60. return string(data)
  61. }
  62. //md5加密
  63. func MD5(data string) string {
  64. m := md5.Sum([]byte(data))
  65. return hex.EncodeToString(m[:])
  66. }
  67. // 获取数字随机字符
  68. func GetRandDigit(n int) string {
  69. return fmt.Sprintf("%0"+strconv.Itoa(n)+"d", rnd.Intn(int(math.Pow10(n))))
  70. }
  71. // 获取随机数
  72. func GetRandNumber(n int) int {
  73. return rnd.Intn(n)
  74. }
  75. func GetRandInt(min, max int) int {
  76. if min >= max || min == 0 || max == 0 {
  77. return max
  78. }
  79. return rand.Intn(max-min) + min
  80. }
  81. func GetToday(format string) string {
  82. today := time.Now().Format(format)
  83. return today
  84. }
  85. //获取今天剩余秒数
  86. func GetTodayLastSecond() time.Duration {
  87. today := GetToday(FormatDate) + " 23:59:59"
  88. end, _ := time.ParseInLocation(FormatDateTime, today, time.Local)
  89. return time.Duration(end.Unix()-time.Now().Local().Unix()) * time.Second
  90. }
  91. // 处理出生日期函数
  92. func GetBrithDate(idcard string) string {
  93. l := len(idcard)
  94. var s string
  95. if l == 15 {
  96. s = "19" + idcard[6:8] + "-" + idcard[8:10] + "-" + idcard[10:12]
  97. return s
  98. }
  99. if l == 18 {
  100. s = idcard[6:10] + "-" + idcard[10:12] + "-" + idcard[12:14]
  101. return s
  102. }
  103. return GetToday(FormatDate)
  104. }
  105. //处理性别
  106. func WhichSexByIdcard(idcard string) string {
  107. var sexs = [2]string{"女", "男"}
  108. length := len(idcard)
  109. if length == 18 {
  110. sex, _ := strconv.Atoi(string(idcard[16]))
  111. return sexs[sex%2]
  112. } else if length == 15 {
  113. sex, _ := strconv.Atoi(string(idcard[14]))
  114. return sexs[sex%2]
  115. }
  116. return "男"
  117. }
  118. //截取小数点后几位
  119. func SubFloatToString(f float64, m int) string {
  120. n := strconv.FormatFloat(f, 'f', -1, 64)
  121. if n == "" {
  122. return ""
  123. }
  124. if m >= len(n) {
  125. return n
  126. }
  127. newn := strings.Split(n, ".")
  128. if m == 0 {
  129. return newn[0]
  130. }
  131. if len(newn) < 2 || m >= len(newn[1]) {
  132. return n
  133. }
  134. return newn[0] + "." + newn[1][:m]
  135. }
  136. //截取小数点后几位
  137. func SubFloatToFloat(f float64, m int) float64 {
  138. newn := SubFloatToString(f, m)
  139. newf, _ := strconv.ParseFloat(newn, 64)
  140. return newf
  141. }
  142. //截取小数点后几位
  143. func SubFloatToFloatStr(f float64, m int) string {
  144. newn := SubFloatToString(f, m)
  145. return newn
  146. }
  147. //获取相差时间-年
  148. func GetYearDiffer(start_time, end_time string) int {
  149. t1, _ := time.ParseInLocation("2006-01-02", start_time, time.Local)
  150. t2, _ := time.ParseInLocation("2006-01-02", end_time, time.Local)
  151. age := t2.Year() - t1.Year()
  152. if t2.Month() < t1.Month() || (t2.Month() == t1.Month() && t2.Day() < t1.Day()) {
  153. age--
  154. }
  155. return age
  156. }
  157. //获取相差时间-秒
  158. func GetSecondDifferByTime(start_time, end_time time.Time) int64 {
  159. diff := end_time.Unix() - start_time.Unix()
  160. return diff
  161. }
  162. func FixFloat(f float64, m int) float64 {
  163. newn := SubFloatToString(f+0.00000001, m)
  164. newf, _ := strconv.ParseFloat(newn, 64)
  165. return newf
  166. }
  167. // 将字符串数组转化为逗号分割的字符串形式 ["str1","str2","str3"] >>> "str1,str2,str3"
  168. func StrListToString(strList []string) (str string) {
  169. if len(strList) > 0 {
  170. for k, v := range strList {
  171. if k == 0 {
  172. str = v
  173. } else {
  174. str = str + "," + v
  175. }
  176. }
  177. return
  178. }
  179. return ""
  180. }
  181. //Token
  182. func GetToken() string {
  183. randStr := GetRandString(64)
  184. token := MD5(randStr + Md5Key)
  185. tokenLen := 64 - len(token)
  186. return strings.ToUpper(token + GetRandString(tokenLen))
  187. }
  188. //数据没有记录
  189. func ErrNoRow() string {
  190. return "<QuerySeter> no row found"
  191. }
  192. //校验邮箱格式
  193. func ValidateEmailFormatat(email string) bool {
  194. reg := regexp.MustCompile(RegularEmail)
  195. return reg.MatchString(email)
  196. }
  197. //验证是否是手机号
  198. func ValidateMobileFormatat(mobileNum string) bool {
  199. reg := regexp.MustCompile(RegularMobile)
  200. return reg.MatchString(mobileNum)
  201. }
  202. //判断文件是否存在
  203. func FileIsExist(filePath string) bool {
  204. _, err := os.Stat(filePath)
  205. return err == nil || os.IsExist(err)
  206. }
  207. //获取图片扩展名
  208. func GetImgExt(file string) (ext string, err error) {
  209. var headerByte []byte
  210. headerByte = make([]byte, 8)
  211. fd, err := os.Open(file)
  212. if err != nil {
  213. return "", err
  214. }
  215. defer fd.Close()
  216. _, err = fd.Read(headerByte)
  217. if err != nil {
  218. return "", err
  219. }
  220. xStr := fmt.Sprintf("%x", headerByte)
  221. switch {
  222. case xStr == "89504e470d0a1a0a":
  223. ext = ".png"
  224. case xStr == "0000010001002020":
  225. ext = ".ico"
  226. case xStr == "0000020001002020":
  227. ext = ".cur"
  228. case xStr[:12] == "474946383961" || xStr[:12] == "474946383761":
  229. ext = ".gif"
  230. case xStr[:10] == "0000020000" || xStr[:10] == "0000100000":
  231. ext = ".tga"
  232. case xStr[:8] == "464f524d":
  233. ext = ".iff"
  234. case xStr[:8] == "52494646":
  235. ext = ".ani"
  236. case xStr[:4] == "4d4d" || xStr[:4] == "4949":
  237. ext = ".tiff"
  238. case xStr[:4] == "424d":
  239. ext = ".bmp"
  240. case xStr[:4] == "ffd8":
  241. ext = ".jpg"
  242. case xStr[:2] == "0a":
  243. ext = ".pcx"
  244. default:
  245. ext = ""
  246. }
  247. return ext, nil
  248. }
  249. //保存图片
  250. func SaveImage(path string, img image.Image) (err error) {
  251. //需要保持的文件
  252. imgfile, err := os.Create(path)
  253. defer imgfile.Close()
  254. // 以PNG格式保存文件
  255. err = png.Encode(imgfile, img)
  256. return err
  257. }
  258. //下载图片
  259. func DownloadImage(imgUrl string) (filePath string, err error) {
  260. imgPath := "./static/imgs/"
  261. fileName := path.Base(imgUrl)
  262. res, err := http.Get(imgUrl)
  263. if err != nil {
  264. fmt.Println("A error occurred!")
  265. return
  266. }
  267. defer res.Body.Close()
  268. // 获得get请求响应的reader对象
  269. reader := bufio.NewReaderSize(res.Body, 32*1024)
  270. filePath = imgPath + fileName
  271. file, err := os.Create(filePath)
  272. if err != nil {
  273. return
  274. }
  275. // 获得文件的writer对象
  276. writer := bufio.NewWriter(file)
  277. written, _ := io.Copy(writer, reader)
  278. fmt.Printf("Total length: %d \n", written)
  279. return
  280. }
  281. //保存base64数据为文件
  282. func SaveBase64ToFile(content, path string) error {
  283. data, err := base64.StdEncoding.DecodeString(content)
  284. if err != nil {
  285. return err
  286. }
  287. f, err := os.Create(path)
  288. defer f.Close()
  289. if err != nil {
  290. return err
  291. }
  292. f.Write(data)
  293. return nil
  294. }
  295. func SaveBase64ToFileBySeek(content, path string) (err error) {
  296. data, err := base64.StdEncoding.DecodeString(content)
  297. exist, err := PathExists(path)
  298. if err != nil {
  299. return
  300. }
  301. if !exist {
  302. f, err := os.Create(path)
  303. if err != nil {
  304. return err
  305. }
  306. n, _ := f.Seek(0, 2)
  307. // 从末尾的偏移量开始写入内容
  308. _, err = f.WriteAt([]byte(data), n)
  309. defer f.Close()
  310. } else {
  311. f, err := os.OpenFile(path, os.O_WRONLY, 0644)
  312. if err != nil {
  313. return err
  314. }
  315. n, _ := f.Seek(0, 2)
  316. // 从末尾的偏移量开始写入内容
  317. _, err = f.WriteAt([]byte(data), n)
  318. defer f.Close()
  319. }
  320. return nil
  321. }
  322. func PathExists(path string) (bool, error) {
  323. _, err := os.Stat(path)
  324. if err == nil {
  325. return true, nil
  326. }
  327. if os.IsNotExist(err) {
  328. return false, nil
  329. }
  330. return false, err
  331. }
  332. func StartIndex(page, pagesize int) int {
  333. if page > 1 {
  334. return (page - 1) * pagesize
  335. }
  336. return 0
  337. }
  338. func PageCount(count, pagesize int) int {
  339. if count%pagesize > 0 {
  340. return count/pagesize + 1
  341. } else {
  342. return count / pagesize
  343. }
  344. }
  345. func TrimHtml(src string) string {
  346. //将HTML标签全转换成小写
  347. re, _ := regexp.Compile("\\<[\\S\\s]+?\\>")
  348. src = re.ReplaceAllStringFunc(src, strings.ToLower)
  349. re, _ = regexp.Compile("\\<img[\\S\\s]+?\\>")
  350. src = re.ReplaceAllString(src, "[图片]")
  351. re, _ = regexp.Compile("class[\\S\\s]+?>")
  352. src = re.ReplaceAllString(src, "")
  353. re, _ = regexp.Compile("\\<[\\S\\s]+?\\>")
  354. src = re.ReplaceAllString(src, "")
  355. return strings.TrimSpace(src)
  356. }
  357. //1556164246 -> 2019-04-25 03:50:46 +0000
  358. //timestamp
  359. func TimeToTimestamp() {
  360. fmt.Println(time.Unix(1556164246, 0).Format("2006-01-02 15:04:05"))
  361. }
  362. func ToUnicode(text string) string {
  363. textQuoted := strconv.QuoteToASCII(text)
  364. textUnquoted := textQuoted[1 : len(textQuoted)-1]
  365. return textUnquoted
  366. }
  367. func VersionToInt(version string) int {
  368. version = strings.Replace(version, ".", "", -1)
  369. n, _ := strconv.Atoi(version)
  370. return n
  371. }
  372. func IsCheckInList(list []int, s int) bool {
  373. for _, v := range list {
  374. if v == s {
  375. return true
  376. }
  377. }
  378. return false
  379. }
  380. func round(num float64) int {
  381. return int(num + math.Copysign(0.5, num))
  382. }
  383. func toFixed(num float64, precision int) float64 {
  384. output := math.Pow(10, float64(precision))
  385. return float64(round(num*output)) / output
  386. }
  387. // GetWilsonScore returns Wilson Score
  388. func GetWilsonScore(p, n float64) float64 {
  389. if p == 0 && n == 0 {
  390. return 0
  391. }
  392. return toFixed(((p+1.9208)/(p+n)-1.96*math.Sqrt(p*n/(p+n)+0.9604)/(p+n))/(1+3.8416/(p+n)), 2)
  393. }
  394. //将中文数字转化成数字,比如 第三百四十五章,返回第345章 不支持一亿及以上
  395. func ChangeWordsToNum(str string) (numStr string) {
  396. words := ([]rune)(str)
  397. num := 0
  398. n := 0
  399. for i := 0; i < len(words); i++ {
  400. word := string(words[i : i+1])
  401. switch word {
  402. case "万":
  403. if n == 0 {
  404. n = 1
  405. }
  406. n = n * 10000
  407. num = num*10000 + n
  408. n = 0
  409. case "千":
  410. if n == 0 {
  411. n = 1
  412. }
  413. n = n * 1000
  414. num += n
  415. n = 0
  416. case "百":
  417. if n == 0 {
  418. n = 1
  419. }
  420. n = n * 100
  421. num += n
  422. n = 0
  423. case "十":
  424. if n == 0 {
  425. n = 1
  426. }
  427. n = n * 10
  428. num += n
  429. n = 0
  430. case "一":
  431. n += 1
  432. case "二":
  433. n += 2
  434. case "三":
  435. n += 3
  436. case "四":
  437. n += 4
  438. case "五":
  439. n += 5
  440. case "六":
  441. n += 6
  442. case "七":
  443. n += 7
  444. case "八":
  445. n += 8
  446. case "九":
  447. n += 9
  448. case "零":
  449. default:
  450. if n > 0 {
  451. num += n
  452. n = 0
  453. }
  454. if num == 0 {
  455. numStr += word
  456. } else {
  457. numStr += strconv.Itoa(num) + word
  458. num = 0
  459. }
  460. }
  461. }
  462. if n > 0 {
  463. num += n
  464. n = 0
  465. }
  466. if num != 0 {
  467. numStr += strconv.Itoa(num)
  468. }
  469. return
  470. }
  471. func Sha1(data string) string {
  472. sha1 := sha1.New()
  473. sha1.Write([]byte(data))
  474. return hex.EncodeToString(sha1.Sum([]byte("")))
  475. }
  476. func GetVideoPlaySeconds(videoPath string) (playSeconds float64, err error) {
  477. cmd := `ffmpeg -i ` + videoPath + ` 2>&1 | grep 'Duration' | cut -d ' ' -f 4 | sed s/,//`
  478. out, err := exec.Command("bash", "-c", cmd).Output()
  479. if err != nil {
  480. return
  481. }
  482. outTimes := string(out)
  483. fmt.Println("outTimes:", outTimes)
  484. if outTimes != "" {
  485. timeArr := strings.Split(outTimes, ":")
  486. h := timeArr[0]
  487. m := timeArr[1]
  488. s := timeArr[2]
  489. hInt, err := strconv.Atoi(h)
  490. if err != nil {
  491. return playSeconds, err
  492. }
  493. mInt, err := strconv.Atoi(m)
  494. if err != nil {
  495. return playSeconds, err
  496. }
  497. s = strings.Trim(s, " ")
  498. s = strings.Trim(s, "\n")
  499. sInt, err := strconv.ParseFloat(s, 64)
  500. if err != nil {
  501. return playSeconds, err
  502. }
  503. playSeconds = float64(hInt)*3600 + float64(mInt)*60 + float64(sInt)
  504. }
  505. return
  506. }
  507. func GetMaxTradeCode(tradeCode string) (maxTradeCode string, err error) {
  508. tradeCode = strings.Replace(tradeCode, "W", "", -1)
  509. tradeCode = strings.Trim(tradeCode, " ")
  510. tradeCodeInt, err := strconv.Atoi(tradeCode)
  511. if err != nil {
  512. return
  513. }
  514. tradeCodeInt = tradeCodeInt + 1
  515. maxTradeCode = fmt.Sprintf("W%06d", tradeCodeInt)
  516. return
  517. }
  518. // excel日期字段格式化 yyyy-mm-dd
  519. func ConvertToFormatDay(excelDaysString string) string {
  520. // 2006-01-02 距离 1900-01-01的天数
  521. baseDiffDay := 38719 //在网上工具计算的天数需要加2天,什么原因没弄清楚
  522. curDiffDay := excelDaysString
  523. b, _ := strconv.Atoi(curDiffDay)
  524. // 获取excel的日期距离2006-01-02的天数
  525. realDiffDay := b - baseDiffDay
  526. //fmt.Println("realDiffDay:",realDiffDay)
  527. // 距离2006-01-02 秒数
  528. realDiffSecond := realDiffDay * 24 * 3600
  529. //fmt.Println("realDiffSecond:",realDiffSecond)
  530. // 2006-01-02 15:04:05距离1970-01-01 08:00:00的秒数 网上工具可查出
  531. baseOriginSecond := 1136185445
  532. resultTime := time.Unix(int64(baseOriginSecond+realDiffSecond), 0).Format("2006-01-02")
  533. return resultTime
  534. }
  535. func CheckPwd(pwd string) bool {
  536. compile := `([0-9a-z]+){6,12}|(a-z0-9]+){6,12}`
  537. reg := regexp.MustCompile(compile)
  538. flag := reg.MatchString(pwd)
  539. return flag
  540. }
  541. func GetMonthStartAndEnd(myYear string, myMonth string) (startDate, endDate string) {
  542. // 数字月份必须前置补零
  543. if len(myMonth) == 1 {
  544. myMonth = "0" + myMonth
  545. }
  546. yInt, _ := strconv.Atoi(myYear)
  547. timeLayout := "2006-01-02 15:04:05"
  548. loc, _ := time.LoadLocation("Local")
  549. theTime, _ := time.ParseInLocation(timeLayout, myYear+"-"+myMonth+"-01 00:00:00", loc)
  550. newMonth := theTime.Month()
  551. t1 := time.Date(yInt, newMonth, 1, 0, 0, 0, 0, time.Local).Format("2006-01-02")
  552. t2 := time.Date(yInt, newMonth+1, 0, 0, 0, 0, 0, time.Local).Format("2006-01-02")
  553. return t1, t2
  554. }
  555. //移除字符串中的空格
  556. func TrimStr(str string) (str2 string) {
  557. return strings.Replace(str, " ", "", -1)
  558. }
  559. //字符串转换为time
  560. func StrTimeToTime(strTime string) time.Time {
  561. timeLayout := "2006-01-02 15:04:05" //转化所需模板
  562. loc, _ := time.LoadLocation("Local") //重要:获取时区
  563. resultTime, _ := time.ParseInLocation(timeLayout, strTime, loc)
  564. return resultTime
  565. }