发表于
输入 fdisk -l查看你U盘的具体分区
1
fdisk -l
先取消树莓派自动挂载取消挂载
1
sudo umount /dev/sdb1
将/dev/sdb1分区格式化成ext4文件系统
1
sudo mkfs.ext4 /dev/sdb1
挂载硬盘
1
sudo mount /dev/sdb1  /data/hardDisk/linkEase/musics
开机自动挂载硬盘
查看硬盘UUID
1
ls -l /dev/disk/by-uuid/
通过UUID挂载硬盘
1
2
3
4
#编辑/etc/fstab
sudo vim /etc/fstab
#添加以下命令到/etc/fstab
UUID=601788b2-96aa-4975-a6c2-7b90b128a7e5 /data/hardDisk/linkEase/musics ext4 defaults 0 0

发表于
RSA数据加密解密
1
2
3
4
5
6
7
8
9
10
11
<?php
//定义常量
        define("INVOICE_PRINT_URL", '');
        define("MERCHANT_ID", '');
        define("MERCHANT_SECRET", '');
        define("PLATFORM_PUBLIC_KEY", '');
        define("MERCHANT_PUBLIC_KEY", '');
        define("MERCHANT_PRIVATE_KEY", $'');
        define("ACCOUNT_VALUE", '');

        const KEYSIZE = 2048;//密钥长度
阅读全文 »

发表于
多维数组拼接成字符串
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  
/**
 * @FuncName:arrayToString
 * @Description 数组拼接成字符串
 * @User ZHaoGuiBin
 * @Date 2020-08-14 9:17
 * @param $data
 * @param string $keys
 * @param string $key_1 //多维数组主key
 * @param string $string
 * @return string
 */
private static function arrayToString($data, $keys = '', $string = '', $key_1 = '')
{
    $temp = 0;
    foreach ($data as $key => $value) {
        if (is_array($value)) {
            if (!is_numeric($key)) {
                $key_1 = $key;
                $string .= $key_1 . '=';
            }
            $string .= self::arrayToString($value, $key, '', $key_1);
        } else {
            if ($keys) {
                if (is_numeric($key)) {
                    if ($temp == 0) {
                        $string .= $keys . '=' . $value;
                        $temp++;
                    } else {
                        $string .= '&' . $value . '&';
                    }
                } else {
                    if ($temp == 0) {
                        if (!is_numeric($keys)) {
                            $string .= $keys . '=' . $key . '=' . $value . '&';
                            $temp++;
                        } else {
                            $string .= $key . '=' . $value . '&';
                            $temp++;
                        }

                    } else {
                        $string .= $key . '=' . $value . '&';
                    }
                }
            } else {
                $string .= $key . '=' . $value . '&';
            }
        }
    }
    return $string;
}

发表于
数组key按照alphabet序排序
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
  
/**
 * @FuncName:arraySoft
 * @Description 数组key按照alphabet序排序
 * @User ZHaoGuiBin
 * @Date 2020-08-13 15:45
 * @param $data
 * @return mixed
 */
private static function arraySoft($data)
{
    ksort($data);
    foreach ($data as $key => $value) {
        if (is_array($value)) {
            $data[$key] = self::arraySoft($value);
        }
    }
    return $data;
}

发表于

PS : mysql 需要开启grant FILE on . to newerp; 权限

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
/**
 * @FILE_NAME:ExcelExport.php
 * @Description 数据导出excel,从数据库导出再下载，数据库配置
 * [mysqld]
 * secure_file_priv= ''
 * @User ZHaoGuiBin
 * @Date 2019-12-04 13:52:58
 */

class ExcelExport
{

    /**
     * @FuncName:exportExcel
     * @Description
     * @User ZHaoGuiBin
     * @Date 2019-12-24 13:42:11
     * @param string $title
     * @param $sql
     * @param $data
     * @return bool
     */
    public static function exportExcel($title = '报表导出', $sql, $data)
    {

        $data_dir = getcwd() . "/data_export/";
        $sys = new SysModel();
        $db = $sys->getAdapter();

        //删除历史表格
        self::deleteExcel();

        if (!file_exists($data_dir) || !is_writable($data_dir)) {
            if (!@mkdir($data_dir, 0755, TRUE)) {
                Tools::dieJs("alert('导出失败，请联系管理员处理');history.go(-1);");
            }
        }

        $file_name = $title . time() . ".csv";
        $file_path = $data_dir . $file_name;

        //拼接sql
        $convert_fields = "";
        $title_fields = "";
        $fields = '';
        $temp_key = 0;
        $fields_count = count($data);
        foreach ($data as $key => $field) {
            $temp_key += 1;
            $convert_fields .= "ifnull(CONVERT (( `{$key}` ) USING gb2312 ),'')" . ($temp_key < $fields_count ? ',' : '');
            $title_fields .= "'{$key}'" . ($temp_key < $fields_count ? ',' : '');
            $fields .= "`{$field}`" . ($temp_key < $fields_count ? ',' : '');
        }

        $sql_str = "SELECT {$convert_fields} INTO OUTFILE '{$file_path}' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'
        FROM ( SELECT {$title_fields} UNION SELECT {$fields} FROM ({$sql}) as t ) temp";

        $db->query($sql_str);

        self::downloadExcel($file_path, $file_name);

        return true;
    }

    /**
     * @FuncName:downloadExcel
     * @Description
     * @User ZHaoGuiBin
     * @Date 2019-12-24 14:25:10
     * @param $file_path 文件地址
     * @param $file_name 文件名称
     * @return void
     */
    public static function downloadExcel($file_path, $file_name)
    {
        ob_end_clean();

        if (!file_exists($file_path)) {
            Tools::dieJs("alert('文件不存在，请联系管理员处理');history.go(-1);");
        }

        $fp = fopen($file_path, "r");
        $file_size = filesize($file_path);

        //下载文件需要用到的头
        header("Content-type:text/html;charset=utf-8");
        Header("Content-type: application/octet-stream");
        Header("Accept-Ranges: bytes");
        Header("Accept-Length:" . $file_size);
        Header("Content-Disposition: attachment; filename=" . $file_name);
        $buffer = 1024;
        $file_count = 0;

        while (!feof($fp) && $file_count < $file_size) {
            $file_con = fread($fp, $buffer);
            $file_count += $buffer;
            echo $file_con;
        }
        fclose($fp);
    }

    /**
     * @FuncName:deleteExcel
     * @Description 删除没用的表格
     * @User ZHaoGuiBin
     * @Date 2019-12-24 15:05:01
     * @return bool
     */
    public static function deleteExcel()
    {

        //几分钟前的时间戳
        $delete_time = strtotime("-5 minute");

        $data_dir = getcwd() . "/data_export/*.csv";
        $data_dir = glob($data_dir);

        if (empty($data_dir)) {
            return true;
        }

        foreach ($data_dir as $key => $file_path) {
            $temp_time = self::findNum($file_path);
            if ($temp_time < $delete_time) {
                unlink($file_path);
            }
        }

        return true;
    }

    /**
     * @FuncName:findNum
     * @Description
     * @User ZHaoGuiBin
     * @Date 2019-12-24 14:54:11
     * @param string $str
     * @return string
     */
    public static function findNum($str = '')
    {
        $str = trim($str);
        if (empty($str)) {
            return '';
        }
        $temp = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
        $result = '';
        for ($i = 0; $i < strlen($str); $i++) {
            if (in_array($str[$i], $temp)) {
                $result .= $str[$i];
            }
        }
        return $result;
    }


}

发表于 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
/**
 * @FILE_NAME:ExcelExport.php
 * @Description csv导出数据
 * @User ZHaoGuiBin
 * @Date 2019-12-04 13:52:58
 */

class ExcelExport
{
    /**
     * @FuncName:sqlQuery
     * @Description 生成器模式返回数据
     * @User ZHaoGuiBin
     * @Date 2020-01-08 16:43
     * @param $sql
     * @return Generator
     */
    public static function sqlQuery($sql)
    {
        $sys = new SysModel();
        $db = $sys->getAdapter();

        foreach ($db->fetchAll($sql) as $key => $val) {
            yield $val; //生成器返回数据，避免内存溢出
        }
    }


    /**
     * @FuncName:exportExcel
     * @Description
     * @User ZHaoGuiBin
     * @Date 2020-01-09 09:23
     * @param string $title
     * @param string $sql
     * @param array $data example : ["单号" => 'order_key'],['报表title名称'=>'mysql语句字段名']
     * @return bool
     */
    public static function exportExcel($title = '报表导出', $sql = '', $data = [])
    {

        $data_dir = getcwd() . "/data_export/";

        //删除历史表格
        self::deleteExcel();

        if (!file_exists($data_dir) || !is_writable($data_dir)) {
            if (!@mkdir($data_dir, 0755, TRUE)) {
                Tools::dieJs("alert('导出失败，请联系管理员处理');history.go(-1);");
            }
        }

        $file_name = $title . time() . ".csv";
        $file_path = $data_dir . $file_name;

        //拼接sql
        $fields = '';
        $title_fields = [];
        $temp_key = 0;
        $fields_count = count($data);
        foreach ($data as $key => $field) {
            $temp_key += 1;
            $fields .= "ifnull({$field},'') as {$field}" . ($temp_key < $fields_count ? ',' : '');
            array_push($title_fields, $key);
        }

        $fp = fopen($file_path, 'w'); //生成临时文件
        fwrite($fp, chr(0xEF) . chr(0xBB) . chr(0xBF));//转码,防止乱码
        fputcsv($fp, $title_fields);//插入标题
        foreach (self::sqlQuery("SELECT {$fields} FROM ({$sql}) as t") as $key => $value) {
            fputcsv($fp, $value);
        }

        fclose($fp);

        self::downloadExcel($file_path, $file_name);

        return true;
    }

    /**
     * @FuncName:downloadExcel
     * @Description
     * @User ZHaoGuiBin
     * @Date 2020-01-08 16:46
     * @param string $file_path
     * @param string $file_name
     * @return void
     */
    public static function downloadExcel($file_path = '', $file_name = '')
    {
        ob_end_clean();

        if (!file_exists($file_path)) {
            Tools::dieJs("alert('文件不存在，请联系管理员处理');history.go(-1);");
        }

        $fp = fopen($file_path, "r");
        $file_size = filesize($file_path);

        //下载文件需要用到的头
        header("Content-type:text/html;charset=utf-8");
        Header("Content-type: application/octet-stream");
        Header("Accept-Ranges: bytes");
        Header("Accept-Length:" . $file_size);
        Header("Content-Disposition: attachment; filename=" . $file_name);
        $buffer = 1024;
        $file_count = 0;

        while (!feof($fp) && $file_count < $file_size) {
            $file_con = fread($fp, $buffer);
            $file_count += $buffer;
            echo $file_con;
        }
        fclose($fp);
    }

    /**
     * @FuncName:deleteExcel
     * @Description 删除没用的表格
     * @User ZHaoGuiBin
     * @Date 2019-12-24 15:05:01
     * @return bool
     */
    public static function deleteExcel()
    {

        //几分钟前的时间戳
        $delete_time = strtotime("-5 minute");

        $data_dir = getcwd() . "/data_export/*.csv";
        $data_dir = glob($data_dir);

        if (empty($data_dir)) {
            return true;
        }

        foreach ($data_dir as $key => $file_path) {
            $temp_time = self::findNum($file_path);
            if ($temp_time < $delete_time) {
                unlink($file_path);
            }
        }

        return true;
    }

    /**
     * @FuncName:findNum
     * @Description
     * @User ZHaoGuiBin
     * @Date 2019-12-24 14:54:11
     * @param string $str
     * @return string
     */
    public static function findNum($str = '')
    {
        $str = trim($str);
        if (empty($str)) {
            return '';
        }
        $temp = array('1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
        $result = '';
        for ($i = 0; $i < strlen($str); $i++) {
            if (in_array($str[$i], $temp)) {
                $result .= $str[$i];
            }
        }
        return $result;
    }


}

发表于

启动两个线程, 一个输出 1,3,5,7…99, 另一个输出 2,4,6,8…100 最后 STDOUT 中按序输出 1,2,3,4,5…100

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
package main

import (
	"fmt"
	"time"
)

var pool = 100

//奇数
func oddNum(c chan int) {
	for i := 1; i <= pool; i++ {
		c <- i
		if i%2 == 1 {
			fmt.Println(i)
		}
	}
}

//偶数
func even(c chan int) {
	for i := 1; i <= pool; i++ {
		<-c
		if i%2 == 0 {
			fmt.Println(i)
		}
	}
}

func main() {

	c := make(chan int)

	go oddNum(c)
	go even(c)

	time.Sleep(time.Second * 1)

}