common.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. <?php
  2. // 应用公共文件
  3. /**
  4. * 数据库查询结果集无限级分类
  5. * @param mixed $list 结果集
  6. * @param string $pk 主键
  7. * @param string $pid 父级字段名
  8. * @param string $child 子结果集
  9. * @param int $root 起始id
  10. * @return @return array
  11. */
  12. function list_tree($list, $pk = 'id', $pid = 'pid', $child = 'child', $root = 0)
  13. {
  14. $tree = [];
  15. foreach ($list as $key => $val) {
  16. if ($val[$pid] == $root) {
  17. unset($list[$key]);
  18. if (!empty($list)) {
  19. $children = list_tree($list, $pk, $pid, $child, $val[$pk]);
  20. $val[$child] = $children;
  21. }
  22. array_push($tree, $val);
  23. }
  24. }
  25. return $tree;
  26. }
  27. function make_tree($list, $pk = 'id', $pid = 'pid', $child = 'child', $root = 0)
  28. {
  29. $tree=array();
  30. foreach ($list as $key => $val) {
  31. if ($val[$pid]==$root) {
  32. unset($list[$key]);
  33. if (!empty($list)) {
  34. $child = make_tree($list, $pk, $pid, $child, $val[$pk]);
  35. if (!empty($child)) {
  36. $val['child']=$child;
  37. } else {
  38. $val['child']= array();
  39. }
  40. }
  41. $tree[]=$val;
  42. }
  43. }
  44. return $tree;
  45. }
  46. /**
  47. * 获取指定月份的第一天开始和最后一天结束的时间戳
  48. *
  49. * @param int $y 年份 $m 月份
  50. * @return array(本月开始时间,本月结束时间)
  51. */
  52. function month_frist_and_last_day($y = "", $m = ""){
  53. if ($y == "") $y = date("Y");
  54. if ($m == "") $m = date("m");
  55. $m = sprintf("%02d", intval($m));
  56. $y = str_pad(intval($y), 4, "0", STR_PAD_RIGHT);
  57. $m>12 || $m<1 ? $m=1 : $m=$m;
  58. $firstday = strtotime($y . $m . "01000000");
  59. $firstdaystr = date("Y-m-01", $firstday);
  60. $lastday = strtotime(date('Y-m-d 23:59:59', strtotime("$firstdaystr +1 month -1 day")));
  61. return [ "firstday" => $firstday, "lastday" => $lastday];
  62. }
  63. /**
  64. * 生成随机字符串
  65. */
  66. function generate_stochastic_string($length = 16)
  67. {
  68. $permitted_chars = '0123456789abcdefghijklmnopqrstuvwxyz';
  69. return substr(str_shuffle($permitted_chars), 0, $length);
  70. }