2019年7月 – 蔡海斌

自考高等数学学习工具

https://www.shuxuele.com/index.html

涵盖初中数学物理到大学大概大专(相当于高等数学工专前几章的大概内容)

http://www.fhdq.net/sx/14.html

各类数学符号发音

https://www.geogebra.org/classic

空间图像绘制

https://zs.symbolab.com/solver/

超级计算器,部分答案需要付费,不过已经可以大概猜到结果了

需要相关pdf的私下~

目前看一科找一科.

2019-07 半年份的懒人笔记

01米波现场调整为 win 版本
02    不过win下,会牺牲不少性能,如果要求不高,可以考虑
03修复微擎 在php 7.2 环境下登录异常
04    mbstring.fun_overload 导致各种字符串函数异常,导致session解密异常
05php 7.2以上版本安装跳过ssl协议
06pecl install channel://pecl.php.net/mcrypt-1.0.1
07workerman 模拟压力测试脚本
08httponly
09    chrome 特性,只有返回时,标记为httponly,之后会无法在浏览器端读取以及修改.且发送的httponly不会再出出标记
10nmap-vulners和vulscan 
11    https://www.4hou.com/technology/10481.html 
12    需要走代理更新库
13        shell 使用 shadowsockets 局域网代理
14        curl 才能测试 ping 和 telnet 需要单独安装代理或shadowsock
15服务器备份
16    svn 直接复制
17        passwd,authz
18    mysql 复制数据库后,表空间要一起复制.
19对源码做特殊修改,使include 不被open_basedir所限制, 新人测试环境,保护源码安全
20    php 源码 main/fopen_wrappers.c (代码部分是复制别人的...哈哈...省好多时间)
21        源码修改测试, 有 ./configure --disable-all 方便快速编译,只针对测试功能测试
22        PHPAPI int php_check_open_basedir_ex(const char *path, int warn TSRMLS_DC)
23    php 源码编译安装
24        直接复制lnmp phpinfo中的编译参数,避免出错
25        collect2: ld returned 1 exit status make: *** [sapi/cli/php] Error 1
26        解决办法:make ZEND_EXTRA_LIBS='-liconv'
27        ln -s /usr/local/lib/libiconv.so.2 /usr/lib64/
28    独立php版本实现
29        需要另外指定编译目录,配置独立端口,配置独立 /tmp/phpxxx.sock,同时nginx也需要做同样处理,用alias会方便很多.
30            alias 全局修改 /etc/bashrc (注意空格)
31samba
32    无法访问...可能没有权限...这句不关键,第二句才是关键..
33    Samba报错：不允许一个用户使用一个以上用户名与服务器或共享资源的多重连接
34sqlserver php
35    https://www.jianshu.com/p/245b14583c47
36    只有7.0正常,7.2还不行.
37win 分钟级php类计划任务
38    php -q xxx.php
39cups https://www.cups.org/
40"操作无法完成（错误 0X00000709）。再次检查打印机名称、并确保打印机连接网络"
41    识别不到打印机驱动问题. 可下载目标打印机驱动exe ,右键直接解压,再通过查找安装找到目标文件
42    xp识货无法安装的问题.只能随便添加一个打印机(此时无效),再直接修改注册表,改成目标打印机
43    打印机
44        HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Print/Printers
45    打印驱动
46        HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Print/Environments/Windows NT x86/Drivers
47apache vhost单独配置php配置参数
48     php_admin_value open_basedir xxx
49wkhtmltopdf 打印A4
50    隐藏头,隐藏尾(页面宽度750左右为A4常规大小)
51    wkhtmltopdf -T 0 -L 0 -B 0 --page-size A4 --print-media-type --disable-smart-shrinking http://xxx  xxx.pdf
52中文分词
53    mysql 5.7 以上,同时设置ngram_token_size=2,200w内,一次like且文本不是很长的情况下,可以不考虑用like.多次like的情况下,10w起就需要用分词了,速度下降得比较厉害.
54mysql 一次命令复制表以及数据
55    CREATE TABLE igd_sysmsg_backup AS   (   SELECT *   FROM igd_sysmsg   )

Qupload + 多种素材转换成图片实现 (psd,cdr,ai,png,jpg,gif,zip,rar,ppt,pptx,pdf,mp4,avi,mov)

ppt如果直接openoffice解析成pdf再转图片,会有错位问题. 暂时只发现可以通过python调用wps实现兼容的解析.

001<?php
002class QuploadController extends CController {
003    /**
004     * 首页
005     */
006    protected function beforeAction($action) {
007        return true;
008    }
009    function actionDemo() {
010        $this->renderPartial ( 'demo' );
011    }
012    function log($params = []) {
013        write_log ( 'qupload', $params );
014    }
015    function actionToken() {
016        $u = lib ( 'qupload/base.php' );
017         
018        $file_format = preg_replace ( '/^.+\.(\w+)$/ims', '\\1', $_GET ['name'] );
019        $file_format = strtolower ( $file_format );
020        if (! in_array ( $file_format, [ 
021                'psd',
022                'cdr',
023                'ai',
024                'png',
025                'jpg',
026                'gif',
027                'zip',
028                'rar',
029                'ppt',
030                'pptx',
031                'pdf',
032                'mp4',
033                'avi',
034                'mov'
035        ] )) {
036            die ( 'do not allow the file format.' );
037        }
038        $token = $u->genToken ( $_GET ['name'], $_GET ['size'], $_GET ['time'] );
039        if ($token) {
040            if ($_GET ['size'] > 4 * 1000 * 1000 * 1000) {
041                $result = json_encode ( array (
042                        'token' => $token,
043                        'range' => implode ( '-', $u->getRange ( $token ) ),
044                        'status' => $u->getStatus ( $token ),
045                        'tmp_dir' => $u->getInterval (),
046                        'status' => 2,
047                        'error_msg' => '文件大小不能超过1G'
048                ) );
049                $this->log ( $result );
050                echo $result;
051                exit ();
052            }
053            $status = $u->getStatus ( $token );
054            if ($status === 2) {
055                // 上传成功
056                try {
057                    list ( $images_list, $file_info ) = $this->parseImglist ( $u->getInterval () . '/' . $token );
058                    $error_msg = "success";
059                } catch ( Exception $e ) {
060                    $error_msg = $e->getMessage ();
061                }
062            }
063            $result = json_encode ( array (
064                    'token' => $token,
065                    'range' => implode ( '-', $u->getRange ( $token ) ),
066                    'status' => $u->getStatus ( $token ),
067                    'tmp_dir' => $u->getInterval (),
068                    'error_msg' => $error_msg,
069                    'images_list' => $images_list
070            ) );
071             
072            $this->log ( $result );
073            echo $result;
074            exit ();
075        }
076    }
077    public static function uploadDir() {
078        return UPLOAD_DIR . 'file/';
079    }
080    public static function uploadUrl() {
081        return UPLOAD_URL . 'file/';
082    }
083    function actionDownload() {
084        // 弃用,上传成功,根据文件路径,将文件重命名
085        // 上传时,需要检测当前用户是否登录.
086        // exit ();
087        // $_REQUEST ['file'] = '17625/3344abdedd12a65dc7f78d991338d95c4558f66f';
088        // $_REQUEST ['file'] = '17625/050f98d89455c3e6e4c6f96f8d1f7dc8b43b5e70';
089        $file = urldecode ( $_REQUEST ['file'] );
090        if (! preg_match ( '/^\/?\d+\/\w+\.\w+$/ims', $file )) {
091            die ( 'the filename is error' );
092        }
093        $filePath = UPLOAD_DIR . 'file/' . $file;
094        if (! file_exists ( $filePath )) {
095            die ( 'the file do not exists' );
096        }
097        if (! file_exists ( $filePath . '.json' )) {
098            die ( 'the file json do not exists' );
099        }
100        $file_info = file_get_contents ( $filePath . '.json' );
101        $file_info = json_decode ( $file_info, true );
102        if (! $file_info) {
103            die ( 'the file json is error' );
104        }
105        $filename = $file_info ['name'];
106        header ( 'Content-Description: File Transfer' );
107        header ( 'Content-Type: application/octet-stream' );
108        $ua = $_SERVER ["HTTP_USER_AGENT"];
109        if (preg_match ( '/MSIE/', $ua )) {
110            header ( 'Content-Disposition: attachment; filename="' . rawurlencode ( $filename ) . '"' );
111        } elseif (preg_match ( "/Firefox/", $ua )) {
112            header ( 'Content-Disposition: attachment; filename*="utf8\'\'' . $filename . '"' );
113        } else {
114            header ( 'Content-Disposition: attachment; filename="' . $filename . '"' );
115        }
116        header ( 'Content-Transfer-Encoding: binary' );
117        header ( 'Expires: 0' );
118        header ( 'Cache-Control: must-revalidate, post-check=0, pre-check=0' );
119        header ( 'Pragma: public' );
120        header ( 'Content-Length: ' . filesize ( $filePath ) );
121        set_time_limit ( 300 ); // 避免下载超时
122        ob_end_clean (); // 避免大文件导致超过 memory_limit 限制
123        readfile ( $filePath );
124    }
125    public function actionFetch_img_list() {
126        $u = lib ( 'qupload/base.php' );
127        $token = $_REQUEST ['token'];
128        $status = $u->getStatus ( $token );
129        if ($status == 2) {
130            $error_msg = 'success';
131        } else {
132            $error_msg = 'error';
133        }
134        $img_dir = Article::uploadFileDir () . $u->getInterval () . '/' . $token . '_img/';
135        $img_list = FileTools::getCurList ( $img_dir, array (
136                '/\.(png|jpg|gif)$/i' => false 
137        ) );
138        if (empty ( $img_list )) {
139            throw new Exception ( "[{$token}]获取图片异常" );
140        }
141        // ppt 解析出所有图片
142        $images_list = [ ];
143        $dir = str_replace ( '\\', '/', WWW_DIR );
144        foreach ( $img_list as $img ) {
145            $img = str_replace ( '\\', '/', $img );
146            $img = str_replace ( $dir, '', $img );
147            $images_list [] = $img;
148        }
149        echo json_encode ( array (
150                'token' => $token,
151                'range' => implode ( '-', $u->getRange ( $token ) ),
152                'status' => $status,
153                'tmp_dir' => $u->getInterval (),
154                'error_msg' => $error_msg,
155                'images_list' => $images_list
156        ) );
157    }
158    function actionUpload() {
159        set_time_limit ( 0 );
160        ignore_user_abort ( true );
161        $u = lib ( 'qupload/base.php' );
162        $token = isset ( $_GET ['token'] ) ? $_GET ['token'] : null;
163        $start = isset ( $_GET ['start'] ) ? ( int ) $_GET ['start'] : null;
164        if ($start > 4 * 1000 * 1000 * 1000) {
165            $msg = 'do not allow the size more than 1GB';
166            $this->log ( [ 
167                    $msg,
168                    $_GET
169            ] );
170            die ( $msg );
171        }
172        if (! $info = $u->getTokenInfo ( $token )) {
173            $msg = 'can not get the token info';
174            $this->log ( [ 
175                    $msg,
176                    $_GET
177            ] );
178            die ( $msg );
179        }
180        $fp = fopen ( 'php://input', 'r' );
181        $size = $u->size ( $token );
182         
183        // 如果上传起始位置大于文件位置 肯定失败
184        if ($start > $size) {
185            $this->log ( [ 
186                    'position is wrong',
187                    $_GET
188            ] );
189            exit ( 0 );
190        }
191         
192        // 如果文件已经存在 那么肯定是添加
193        if ($size > 0) {
194            $u->append ( $token, $fp, $start );
195        } else {
196            $u->store ( $token, $fp );
197        }
198         
199        $status = $u->getStatus ( $token );
200        $images_list = [ ];
201        if ($status === 3) {
202            $u->delete ( $token );
203            // 上传出错,清理标记,重新上传
204            $status = 0;
205        } elseif ($status === 2) {
206            // 上传成功
207            try {
208                list ( $images_list, $file_info ) = $this->parseImglist ( $u->getInterval () . '/' . $token );
209                $error_msg = "success";
210            } catch ( Exception $e ) {
211                $error_msg = $e->getMessage ();
212            }
213        } else {
214            // status=1
215            // 上传中
216        }
217        $result = json_encode ( array (
218                'range' => implode ( '-', $u->getRange ( $token ) ),
219                'status' => $status,
220                'tmp_dir' => $u->getInterval (),
221                'token' => $token,
222                'error_msg' => $error_msg,
223                'images_list' => $images_list
224        ) );
225         
226        $this->log ( $result );
227        echo $result;
228    }
229    function parseImglist($upload_file) {
230        $file_path = UPLOAD_DIR . '/file/' . $upload_file;
231        if (! file_exists ( $file_path )) {
232            sjson ( false, $title, '文件不存在' );
233        }
234        $file_info = file_get_contents ( $file_path . '.json' );
235        $file_info = json_decode ( $file_info, true );
236        if (! $file_info) {
237            sjson ( false, $title, '文件信息异常' );
238        }
239        $file_format = preg_replace ( '/^.+\.(\w+)$/ims', '\\1', $file_info ['name'] );
240        $file_format = strtolower ( $file_format );
241        $file_flag = preg_replace ( '/^\w+\/(\w+\.\w+)$/ims', '\\1', $upload_file );
242        $file_path_with_format = $file_path . $file_format;
243         
244        // 如果为图片,直接复制图片到指定目录
245        $img_dir = $file_path . '_img';
246        if (file_exists ( $img_dir )) {
247            lib ( 'FileSystem.php' );
248            // 如果目录已经存在,删除,再进行命令调用.
249            // 不然容易出现是否覆盖的提示,导致脚本异常
250            rmdirs ( $img_dir );
251        }
252        mkdir ( $img_dir, 0777 );
253        // 复制文件,并做解析处理,如果防止出现异常时,需要进行二次提交
254        if (in_array ( $file_format, [ 
255                'psd',
256                'cdr',
257                'ai',
258                'png',
259                'jpg',
260                'gif',
261                'zip',
262                'rar'
263        ] )) {
264            // 只有图片允许压缩包
265            // psd,cdr,ai,png,jpg,gif,zip
266            // sjson ( false, $title, '平面设计只允许上传psd,cdr,ai,png,jpg,gif,zip<br>不能' . $file_format );
267            if (in_array ( $file_format, [ 
268                    'zip',
269                    'rar'
270            ] )) {
271                // 先获取压缩包文件内容,检查格式是否包含在指定列表中
272                if ($file_format == 'zip') {
273                    $command = "unzip -l {$file_path}";
274                } else {
275                    $command = "unrar v {$file_path}";
276                }
277                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]压缩包内容获取异常" );
278                // 不管压缩包格式是rar 还是 zip 获取内容列表时,都是
279                // -----
280                // ....
281                // ---------
282                $begin_file_content = 0;
283                foreach ( $output as $line ) {
284                    if (stristr ( $line, '----' )) {
285                        $begin_file_content ++;
286                        continue;
287                    }
288                    if ($begin_file_content == 1) {
289                        $img_format = preg_replace ( '/^.+\.(\w+)$/ims', '\\1', $line );
290                        if (! in_array ( $img_format, [ 
291                                'psd',
292                                'cdr',
293                                'ai',
294                                'png',
295                                'jpg',
296                                'gif'
297                        ] )) {
298                            throw new Exception ( "[{$upload_file}]压缩包文件内容格式异常." );
299                        }
300                    } elseif ($begin_file_content == 2) {
301                        break;
302                    }
303                }
304                if ($file_format == 'zip') {
305                    $command = "unzip {$file_path} -d {$img_dir}";
306                } else {
307                    $command = "unrar x {$file_path} {$img_dir}";
308                }
309                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]压缩包解压异常" );
310                $file_list = FileTools::getCurList ( $img_dir, array (
311                        '/\.(png|jpg|gif|ai|cdr|psd)$/i' => false 
312                ) );
313                if (empty ( $file_list )) {
314                    throw new Exception ( "[{$upload_file}]获取压缩包内容异常" );
315                }
316                // ppt 解析出所有图片
317                $images_list = [ ];
318                foreach ( $file_list as $file ) {
319                    $format = preg_replace ( '/^.+\.(\w+)$/ims', '\\1', $file );
320                    if (in_array ( $format, [ 
321                            'psd',
322                            'ai'
323                    ] )) {
324                        // 通过命令将文件转成图片
325                        $command = "convert {$file}[0] {$file}.png";
326                        list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]图片[{$format}]转化异常" );
327                        $file = $file . '.png';
328                    } elseif (in_array ( $format, [ 
329                            'cdr'
330                    ] )) {
331                        // cdr 格式比较特殊
332                        // 通过命令将文件转成图片
333                        $_pdf_file = "{$file}.pdf";
334                        $command = "uniconvertor {$file} {$_pdf_file}";
335                        list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]cdr图片转化pdf异常" );
336                        $command = "convert {$_pdf_file} {$_pdf_file}.png";
337                        list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]cdr图片转化pdf解析成图片异常" );
338                        $file = $_pdf_file . '.png';
339                    }
340                    $images_list [] = preg_replace ( '/\/data\/www\/sucai\/www/ims', '', $file );
341                }
342            } elseif (in_array ( $file_format, [ 
343                    'png',
344                    'jpg',
345                    'gif'
346            ] )) {
347                // 如果为图片,直接复制图片到指定目录
348                $img_path = $img_dir . '/' . $file_flag;
349                copy ( $file_path, $img_path );
350                $images_list [] = Article::uploadFileUrl () . $upload_file . '_img/' . $file_flag;
351            } elseif (in_array ( $file_format, [ 
352                    'psd',
353                    'ai'
354            ] )) {
355                // 通过命令将文件转成图片
356                $img_path = $upload_file . '_img/' . $file_flag . '.png';
357                $command = "convert {$file_path}[0] " . Article::uploadFileDir () . $img_path;
358                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]图片转化异常" );
359                $images_list [] = Article::uploadFileUrl () . $img_path;
360            } elseif (in_array ( $file_format, [ 
361                    'cdr'
362            ] )) {
363                // cdr 格式比较特殊
364                // 通过命令将文件转成图片
365                $_pdf_file = "{$img_dir}{$file_flag}.pdf";
366                $command = "uniconvertor {$file_path} {$_pdf_file}";
367                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]cdr图片转化pdf异常" );
368                $command = "convert {$_pdf_file} {$_pdf_file}.png";
369                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]cdr图片转化pdf解析成图片异常" );
370                $images_list [] = preg_replace ( '/\/data\/www\/sucai\/www/ims', '', "{$_pdf_file}.png" );
371            }
372        } elseif (in_array ( $file_format, [ 
373                'ppt',
374                'pptx'
375        ] )) {
376            $jod_dir = EXT_DIR . '/convert_tools/';
377            // sjson ( false, $title, 'PPT模板只允许上传ppt,pptx' );
378            $command = "convert {$file_path}[0] " . Article::uploadFileDir () . $img_path;
379            $pdf_file = $img_dir . '/' . $file_flag . '.pdf';
380            // ppt to pdf
381            $command = "java -jar {$jod_dir}jodconverter/lib/jodconverter-cli-2.2.2.jar {$file_path} {$pdf_file}";
382            list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]ppt转pdf异常" );
383            // pdf to png
384            $command = "convert {$pdf_file} {$pdf_file}.png";
385            list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]pdf转图片异常" );
386            $img_list = FileTools::getCurList ( $img_dir, array (
387                    '/\.png$/i' => false 
388            ) );
389            if (empty ( $img_list )) {
390                throw new Exception ( "[{$upload_file}]获取图片异常" );
391            }
392            // ppt 解析出所有图片
393            $images_list = [ ];
394            foreach ( $img_list as $img ) {
395                $images_list [] = preg_replace ( '/\/data\/www\/sucai\/www/ims', '', $img );
396            }
397        } elseif (in_array ( $file_format, [ 
398                'pdf'
399        ] )) {
400            // pdf to png
401            $command = "convert {$file_path} {$img_dir}/{$file_flag}.png";
402            list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]pdf转图片异常" );
403            $img_list = FileTools::getCurList ( $img_dir, array (
404                    '/\.png$/i' => false 
405            ) );
406            if (empty ( $img_list )) {
407                throw new Exception ( "[{$upload_file}]获取图片异常" );
408            }
409            // ppt 解析出所有图片
410            $images_list = [ ];
411            foreach ( $img_list as $img ) {
412                $images_list [] = preg_replace ( '/\/data\/www\/sucai\/www/ims', '', $img );
413            }
414        } else if (in_array ( $file_format, [ 
415                'mp4',
416                'avi',
417                'mov'
418        ] )) {
419            // 视频 mp4,avi,mov
420            // sjson ( false, $title, '视频编辑只允许上传mp4,avi,mov' );
421            // 获取视频总长度
422            $file_length = $this->getVideoLength ( $file_path );
423            if ($file_length < 10) {
424                // 视频长度小于10秒,只获取一张图片,
425                $file_img_spans = [ 
426                        0 
427                ];
428            } else {
429                // 每10分之一长度的地方进行图片采集
430                $file_img_span = intval ( $file_length / 10 );
431                while ( ($left_file_length += $file_img_span) <= $file_length ) {
432                    $file_img_spans [] = $left_file_length;
433                }
434            }
435            foreach ( $file_img_spans as $time_span ) {
436                $img = "{$img_dir}/{$file_flag}-{$time_span}.png";
437                // 小于0.1容易生成空白图片,提示缓存异常啥的
438                $command = "ffmpeg -ss {$time_span} -t 0.1  -i {$file_path} -y -f mjpeg {$img}";
439                list ( $val, $output, $result ) = $this->runCommand ( $command, "[{$upload_file}]视频提取图片[{$time_span}]异常" );
440            }
441            $img_list = FileTools::getCurList ( $img_dir, array (
442                    '/\.png$/i' => false 
443            ) );
444            if (empty ( $img_list )) {
445                throw new Exception ( "[{$upload_file}]获取图片异常" );
446            }
447            // ppt 解析出所有图片
448            $images_list = [ ];
449            foreach ( $img_list as $img ) {
450                chmod ( $img, 0777 );
451                $images_list [] = preg_replace ( '/\/data\/www\/sucai\/www/ims', '', $img );
452            }
453        } else {
454            die ( "[{$upload_file}]上传文件格式异常" );
455        }
456        return [ 
457                $images_list,
458                $file_info
459        ];
460    }
461    /**
462     *
463     * @param unknown $command          
464     * @return string[ $val,//异常状态标记,通常0表示正常
465     *         $output,//命令执行结果
466     *         $result//最后一句命令返回
467     *         ]
468     */
469    function runCommand($command, $msg = '') {
470        $output = "";
471        $val = "";
472        // $val=0 表示正常
473        // 需要标记 ' 2>&1' 将屏幕输出内容(包括异常)全部进行反馈,不加会返回空
474        $result = exec ( $command . ' 2>&1', $output, $val );
475        if ($val) {
476            // gddebug ( $command, $val, $output, $result );
477            write_log ( 'runcommand', [ 
478                    $command,
479                    $val,
480                    $output,
481                    $result
482            ] );
483            throw new Exception ( $msg );
484        }
485        return [ 
486                $val,
487                $output,
488                $result
489        ];
490    }
491    function getVideoLength($file) {
492        if (! file_exists ( $file )) {
493            throw new Exception ( "file do not exists" );
494        }
495        $dir = dirname ( $file );
496        $command = "ffmpeg  -i {$file} 2>&1";
497        $output = "";
498        $val = "";
499        $result = exec ( $command, $output, $val );
500        foreach ( $output as $line ) {
501            if (preg_match ( '/Duration\: (\d+(?:\.\d+)?):(\d+(?:\.\d+)?):(\d+(?:\.\d+)?)\, start/ims', $line, $match )) {
502                $second = intval ( $match [1] ) * 60 * 60 + intval ( $match [2] ) * 60 + intval ( $match [3] );
503                return $second;
504            }
505        }
506        throw new Exception ( "识别不到视频,请检查 result 变量内容" );
507    }
508    function actionIndex() {
509        exit ();
510    }
511}

任意多边形坐标范围判断(重写自百度地图js文件)

001<?php
002/**
003 *
004 * @author Administrator
005 *
006 */
007class MapTools {
008    public static function model() {
009        return new MapTools ();
010    }
011     
012    /**
013     * 判断点是否在矩形内
014     *
015     * @param
016     *          {Point} point 点对象
017     * @param
018     *          {Bounds} bounds 矩形边界对象
019     * @return s {Boolean} 点在矩形内返回true,否则返回false
020     */
021    function isPointInRect($point, $bounds) {
022        // 西南脚点
023        $sw = $bounds ['sw'];
024        // 东北脚点
025        $ne = $bounds ['ne'];
026        return ($point ['lng'] >= $sw ['lng'] && $point ['lat'] >= $sw ['lat'] && $point ['lng'] <= $ne ['lng'] && $point ['lat'] <= $ne ['lat']);
027    }
028     
029    /**
030     * 返回一个多边形的最小外矩形(西南点和东北点的坐标)
031     *
032     * @param array $polygon            
033     */
034    function getBoundsByPolygon($polygon) {
035        $least_lng = $polygon [0] ['lng'];
036        $least_lat = $polygon [0] ['lat'];
037        $largest_lng = $polygon [0] ['lng'];
038        $largest_lat = $polygon [0] ['lat'];
039        foreach ( $polygon as $point ) {
040            if ($point ['lng'] < $least_lng) {
041                $least_lng = $point ['lng'];
042            }
043            if ($point ['lat'] < $least_lat) {
044                $least_lat = $point ['lat'];
045            }
046            if ($point ['lng'] > $largest_lng) {
047                $largest_lng = $point ['lng'];
048            }
049            if ($point ['lat'] > $largest_lat) {
050                $largest_lat = $point ['lat'];
051            }
052        }
053        return array (
054                'sw' => array (
055                        'lng' => $least_lng,
056                        'lat' => $least_lat
057                ),
058                'ne' => array (
059                        'lng' => $largest_lng,
060                        'lat' => $largest_lat
061                ) 
062        );
063    }
064     
065    /**
066     * 判断点是否在多边形内
067     *
068     * @param unknown_type $point           
069     * @param unknown_type $polygon         
070     * @return boolean
071     */
072    function isPointInPolygon($point, $polygon) {
073        if (empty ( $polygon )) {
074            return false;
075        }
076        // 首先判断点是否在多边形的外包矩形内，如果在，则进一步判断，否则返回false
077        // 可以通过绘制矩形时,补充多边形的中心进行计算处理.
078        $polygonBounds = $this->getBoundsByPolygon ( $polygon );
079        if (! $this->isPointInRect ( $point, $polygonBounds )) {
080            return false;
081        }
082        $pts = $polygon;
083        // 获取多边形点
084         
085        // 下述代码来源：http://paulbourke.net/geometry/insidepoly/，进行了部分修改
086        // 基本思想是利用射线法，计算射线与多边形各边的交点，如果是偶数，则点在多边形外，否则
087        // 在多边形内。还会考虑一些特殊情况，如点在多边形顶点上，点在多边形边上等特殊情况。
088         
089        $N = count ( $pts );
090        $boundOrVertex = true;
091        // 如果点位于多边形的顶点或边上，也算做点在多边形内，直接返回true
092        $intersectCount = 0;
093        // cross points count of x
094        $precision = 2e-10;
095        // 浮点类型计算时候与0比较时候的容差
096        $p1 = $p2 = null;
097        // neighbour bound vertices
098        $p = $point;
099        // 测试点
100         
101        $p1 = $pts [0];
102        // left vertex
103        for($i = 1; $i <= $N; ++ $i) {
104            // check all rays
105            if ($p ['lng'] == $p1 ['lng'] && $p ['lat'] == $p1 ['lat']) {
106                return $boundOrVertex;
107                // p is an vertex
108            }
109            $p2 = $pts [$i % $N];
110            // right vertex
111            if ($p ['lat'] < min ( $p1 ['lat'], $p2 ['lat'] ) || $p ['lat'] > max ( $p1 ['lat'], $p2 ['lat'] )) {
112                // ray
113                // is
114                // outside
115                // of
116                // our
117                // interests
118                $p1 = $p2;
119                continue;
120                // next ray left point
121            }
122             
123            if ($p ['lat'] > min ( $p1 ['lat'], $p2 ['lat'] ) && $p ['lat'] < max ( $p1 ['lat'], $p2 ['lat'] )) {
124                // ray
125                // is
126                // crossing
127                // over
128                // by
129                // the
130                // algorithm
131                // (common
132                // part
133                // of)
134                if ($p ['lng'] <= max ( $p1 ['lng'], $p2 ['lng'] )) {
135                    // x is before of
136                    // ray
137                    if ($p1 ['lat'] == $p2 ['lat'] && $p ['lng'] >= min ( $p1 ['lng'], $p2 ['lng'] )) {
138                        // overlies
139                        // on
140                        // a
141                        // horizontal
142                        // ray
143                        return $boundOrVertex;
144                    }
145                     
146                    if ($p1 ['lng'] == $p2 ['lng']) {
147                        // ray is vertical
148                        if ($p1 ['lng'] == $p ['lng']) {
149                            // overlies on a vertical ray
150                            return $boundOrVertex;
151                        } else {
152                            // before ray
153                            ++ $intersectCount;
154                        }
155                    } else {
156                        // cross point on the left side
157                        $xinters = ($p ['lat'] - $p1 ['lat']) * ($p2 ['lng'] - $p1 ['lng']) / ($p2 ['lat'] - $p1 ['lat']) + $p1 ['lng'];
158                        // cross
159                        // point
160                        // of
161                        // lng
162                        if (abs ( $p ['lng'] - $xinters ) < $precision) {
163                            // overlies on
164                            // a ray
165                            return $boundOrVertex;
166                        }
167                         
168                        if ($p ['lng'] < $xinters) {
169                            // before ray
170                            ++ $intersectCount;
171                        }
172                    }
173                }
174            } else { // special case when ray is crossing through the vertex
175                if ($p ['lat'] == $p2 ['lat'] && $p ['lng'] <= $p2 ['lng']) {
176                    // p crossing
177                    // over
178                    // p2
179                    $p3 = $pts [($i + 1) % $N];
180                    // next vertex
181                    if ($p ['lat'] >= min ( $p1 ['lat'], $p3 ['lat'] ) && $p ['lat'] <= max ( $p1 ['lat'], $p3 ['lat'] )) {
182                        // p.lat
183                        // lies
184                        // between
185                        // p1.lat
186                        // &
187                        // p3.lat
188                        ++ $intersectCount;
189                    } else {
190                        $intersectCount += 2;
191                    }
192                }
193            }
194            $p1 = $p2;
195            // next ray left point
196        }
197         
198        if ($intersectCount % 2 == 0) {
199            // 偶数在多边形外
200            return false;
201        } else {
202            // 奇数在多边形内
203            return true;
204        }
205    }
206    /**
207     * 签名校验
208     *
209     * @param unknown $ak           
210     * @param unknown $sk           
211     * @param unknown $url          
212     * @param unknown $querystring_arrays           
213     * @param string $method            
214     * @return string
215     */
216    function caculateAKSN($ak, $sk, $url, $querystring_arrays, $method = 'GET') {
217        if ($method === 'POST') {
218            ksort ( $querystring_arrays );
219        }
220        $querystring = http_build_query ( $querystring_arrays );
221        return md5 ( urlencode ( $url . '?' . $querystring . $sk ) );
222    }
223    /**
224     * 通过地址返回坐标
225     *
226     * @param string $address_name          
227     * @return mixed|boolean
228     */
229    function getLocationByAddress($address_name) {
230        // API控制台申请得到的ak（此处ak值仅供验证参考使用）
231        $ak = 'xxxxxxxxxxxxxx';
232        // 应用类型为for server, 请求校验方式为sn校验方式时，系统会自动生成sk，可以在应用配置-设置中选择Security
233        // Key显示进行查看（此处sk值仅供验证参考使用）
234        $sk = 'xxxxxxxxxxxxxxxxx';
235        // 以Geocoding服务为例，地理编码的请求url，参数待填
236        $url = "http://api.map.baidu.com/geocoder/v2/?address=%s&output=%s&ak=%s&sn=%s";
237        // get请求uri前缀
238        $uri = '/place/v2/search';
239        // 地理编码的请求output参数
240        $output = 'json';
241        $pois = '0';
242        $query = $address_name;
243        $region = '全国';
244        $scope = 1;
245        $querystring_arrays = array (
246                'query' => $query,
247                'output' => $output,
248                'ak' => $ak,
249                'scope' => $scope,
250                'region' => $region
251        );
252        $url = "http://api.map.baidu.com/place/v2/search?query=%s&output=%s&ak=%s&sn=%s&scope=%s&region=%s";
253        // 调用sn计算函数，默认get请求
254        $sn = $this->caculateAKSN ( $ak, $sk, $uri, $querystring_arrays );
255        // 请求参数中有中文、特殊字符等需要进行urlencode，确保请求串与sn对应
256        $target = sprintf ( $url, urlencode ( $query ), $output, $ak, $sn, $scope, urlencode ( $region ) );
257        // 输出计算得到的sn
258        // echo "sn: $sn \n";
259        // 输出完整请求的url（仅供参考验证，故不能正常访问服务）
260        // echo "url: $target \n";
261        $content = file_get_contents ( $target );
262        $content = json_decode ( $content, true );
263        if ($content ['status'] == 0 && isset ( $content ['results'] ) && ! empty ( $content ['results'] ) && isset ( $content ['results'] [0] ['location'] ) && ! empty ( $content ['results'] [0] ['location'] )) {
264            // var_export ( $content );
265            return $content ['results'] [0] ['location'];
266        }
267        return false;
268    }
269    public function getAddressByLocation($longitude, $latitude) {
270        $url = "http://api.map.baidu.com/geocoder/v2/?ak=thT0201pFtgt3VApRT2mhlA6mmpQUnWQ&location={$latitude},{$longitude}&output=json";
271        $ch = curl_init ( $url );
272        curl_setopt ( $ch, CURLOPT_RETURNTRANSFER, true );
273        // 获取数据返回
274        curl_setopt ( $ch, CURLOPT_BINARYTRANSFER, true );
275        // 在启用
276        // CURLOPT_RETURNTRANSFER
277        // 时候将获取数据返回
278        $output = curl_exec ( $ch );
279        $arr = json_decode ( $output, true );
280        if (! $arr || $arr ['status'] || ! isset ( $arr ['result'] ))
281            return false;
282        return $arr ['result'] ['formatted_address'];
283    }
284}

workerman 业务并发测试

01<?php
02use \Workerman\Worker;
03use \Workerman\WebServer;
04use \GatewayWorker\Gateway;
05use \GatewayWorker\BusinessWorker;
06use \Workerman\Autoloader;
07use \Workerman\Connection\AsyncTcpConnection;
08use \Workerman\Lib\Timer;
09 
10require_once './vendor/autoload.php';
11$worker = new Worker ();
12$worker->onWorkerStart = 'connect';
13function connect() {
14    // 2000个链接
15    // if ($count ++ >= 400) {
16    // return;
17    // }
18    for($count = 0; $count < 400; $count ++) {
19        $func = function ($count) {
20            $session_id = 'd34pkfuf88vom9ugptop7e5' . $count;
21            // 建立异步链接
22            // $con = new AsyncTcpConnection ( 'ws://xxxx:8282' );
23            $con = new AsyncTcpConnection ( 'ws://xxxxx:8282' );
24            $con->onMessage = function ($con, $msg) use ($session_id, $count) {
25                // 服务器消息推送
26                echo "recv $session_id $msg\n";
27                $msg = json_decode ( $msg, true );
28                if ($msg && isset ( $msg ['action'] )) {
29                    switch ($msg ['action']) {
30                        case 'broadcast' :
31                            $time = ( int ) date ( 'dHis', time () );
32                            $con->send ( "{\"model\":\"__workerman\",\"action\":\"set_value\",\"value_key\":\"client_time\",\"value_value\":{$time}}" );
33                            break;
34                    }
35                }
36            };
37            $con->onClose = function ($con) use ($session_id, $count) {
38                echo "con $session_id close\n";
39            };
40            $con->onConnect = function ($con) use ($session_id, $count) {
41                // $con->send ( "{\"model\":\"__workerman\",\"action\":\"set_value\",\"value_key\":\"score\",\"value_value\":{$val}}" );
42                // 模拟登录动作
43                $con->send ( "{\"model\":\"remote\",\"action\":\"msg\",\"remote_url\":\"http://xxxxxx/workerman_remote/do/\",\"params\":{\"model\":\"user\",\"action\":\"login\",\"rm_session_id\":\"{$session_id}\"}}" );
44                // 当前链接每10秒发个心跳包
45                $time = ( int ) date ( 'dHis', time () );
46                $con->send ( "{\"model\":\"__workerman\",\"action\":\"set_value\",\"value_key\":\"client_time\",\"value_value\":{$time}}" );
47                Timer::add ( 10, function () use ($con, $session_id, $count, $time) {
48                    // 每10秒推送一个消息
49                    // $con->send ( "{\"model\":\"user\",\"action\":\"sys_time\",\"session_id\":\"{$session_id}\",\"client_time\":\"{$time}\"}" );
50                    // 模拟数钱,一秒推送10个消息
51                    for($i = 0; $i < 10; $i ++) {
52                        $val = ( int ) date ( 'dHis', time () );
53                        $con->send ( "{\"model\":\"__workerman\",\"action\":\"set_value\",\"value_key\":\"score\",\"value_value\":{$val}}" );
54                    }
55                    echo $count . " send complete\n";
56                } );
57            };
58            $con->connect ();
59            echo $count . " connections complete\n";
60        };
61        $func ( $count );
62    }
63}
64Worker::runAll ();

在400条的情况下,内存用不了多少,稳定性也有保证,不过实际情况,还是得具体场景才能判断.

小程序web-view开发框架(写给公司的特殊形式,只做说明,不含代码~.~)

需要先了解手机软件开发有三种形式,原生,混合开发,React-Native开发:

原生开发就是使用手机所支持的原生语言进行开发,像android是用java,iphone是 Objective-C

混合开发就是内置web-view形式,通过在web-view中注入一个js对象,并提供原生语言接口,js通过调用这些接口,实现网页应用和手机间的交互,像phonegap,dcloud等,

React-Native 开发则是直接创建第三种语言,类似html和js,然后生成对应的手机软件

三者主要对比性能和开发便捷程度

原生速度最快,但是跨平台性限制,导致各平台,都需要开发对应版本, 所以开发速度肯定是最慢的.

混合开发,各平台提供统一的接口给注入的js对象调用,所以只需要掌握基本的html和js基础,熟悉注入对象的文档即可开发能在多平台上跑的应用.速度最快,但是性能是最差的.因为是通过web-view进行渲染,性能是个硬伤,但是mui等前端框架,可极大程度的缩小差距. 但是混合应用, 说到底,只能开发展示类的应用.

React-Native 则是编写完成后,编辑器会编译成对应平台的软件,性能相对来说比混合好,开发也相对中等.

小程序则是比较接近react-native的形式,但是又可通过web-view的处理形式实现混合开发,公司这边使用的是web-view形式,上手相对容易很多.

小程序的限制:

小程序的限制是底层权限没有开放,限制比较高,导致写出来的应用,实际上是各公众号的功能差不多.在网速正常情况下,二者功能基本没有太大差别.唯一的优势基本就是入口可以在顶部下来访问.但是最大的缺点则是无法自由的进行模板消息推送. 小程序只有提交表单的情况下,会得到一个表单id,通过该表单才可以进行小程序消息下发,所以小程序一但离线,基本无法通知用户, 只能做为一款极其轻量的应用. 不过在绑定的前提下,公众号可以代替小程序推送消息,并通过消息访问小程序,前提是关注. 做到这步非常麻烦.小程序返回公众号流程繁琐,无法直接进入公众号.

公众号的类型:订阅号,服务号,小程序,企业号…

各公众号openid相互独立,所以,小程序用户的openid不同于其它公众号,且无法共享

公司web-view形式的小程序开发:

微信开发者工具

https://developers.weixin.qq.com/miniprogram/dev/devtools/download.html

框架目录结构,每种必需小程序的功能,单独写成一个独立页面,然后通过wx进行访问

小程序开发者工具截图

小程序获取用户信息不同于公众号授权跳转,进入的时候就强制授权获取,且只能获取一次.且返回的是用户的详细信息和一个code,通过该code,才能获取小程序的用户openid. 所以入口处将用户信息传递到服务器端,必须由服务器进行保存,如果丢失,二次访问时,像头像,昵称这些信息将无法获取.除非将对应服务号接入,通过服务号进行授权跳转(小程序web-view本质是个浏览器,只是限制了长按扫描二维码,但是授权跳转有效)

小程序由于分享,支付,客服,关注,登录等特殊动作,必须由纯小程序代码进行编写,所以当需要触发上述功能时,web-view通过内置对象,携带参数并跳转到对应的页面,操作完成后,进行返回.以上为公司小程序的基本实现形式.

特殊模板小程序开发

通过开发一套完整的小程序,并提交到开放平台,绑定做为通用小程序模板, 这样只需要用户给对应的平台授权,平台可以直接给对应用户生成一套专属的小程序. 通过配置扩展变量,标记当前是哪个用户使用该模板.

web-view的最大优势为修改在web端,无需像小程序一般提交修改审核,极其便利.同时,在确保公众号开发一套任意的功能,通过关联openid,即可无缝整合成小程序访问.

最近小程序的优化,一个是通过头部跳转 Location: xxx 跳转”实现”不跳转太多次进入页面