ghostscript pdf 转为 图片
名称windows中程序叫做gswin64linux中叫做gs windows gswin64 为窗口程序 gswin64c 为console控制台程序 命令 封面图 1gs -dSAFER -dBATCH -dNOPAUSE -r250 -dTextAlphaBits=4 -dGraphicsAlphaBits=4 -dNumRenderingThreads=4 -sDEVICE=jpeg -dJPEGQ=80 -sPageList=1 -sOutputFile=filename.jpg ./test.pdf 指定截图大小 1-g400x800 -dFitPage 转图片 1gswin64 -dSAFER -dBATCH -dNOPAUSE -r250 -dTextAlphaBits=4 -dGraphicsAlphaBits=4 -dNumRenderingThreads=4 -sDEVICE=jpeg -dJPEGQ=80 -sOutputFile=2/filename%d.jpg ./test.pdf 获取pdf页面数一定要有dNOSAFER 1gs...
LibreOffice 转换文档格式
自动安装1234567891011apt-get install libreoffice -yapt-get install libreoffice-l10n-zh-cn libreoffice-help-zh-cn -ycd /usr/share/fonts && \ wget https://mirrors.tuna.tsinghua.edu.cn/adobe-fonts/source-han-sans/SubsetOTF/SourceHanSansCN.zip && \ wget https://mirrors.tuna.tsinghua.edu.cn/adobe-fonts/source-han-serif/SubsetOTF/SourceHanSerifCN.zip && \ unzip SourceHanSansCN.zip && \ unzip SourceHanSerifCN.zip && \ rm -rf SourceHanSerifCN.zip &a...
thinkphp5 自动写入数据库 datetime
123protected $autoWriteTimestamp = 'datetime';protected $dateFormat = 'Y-m-d H:i:s';
php excel PhpSpreadsheet 处理大量数据 读取
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566use PhpOffice\PhpSpreadsheet\IOFactory;use PhpOffice\PhpSpreadsheet\Spreadsheet;class Xlsx{ public static function load($filePath) { $inputFileType = IOFactory::identify($filePath); $excelReader = IOFactory::createReader($inputFileType); $PHPExcel = $excelReader->load($filePath); return $PHPExcel; } /** * 迭代每一行...
nginx 去掉了TLSv1.0 但是还是一直支持
nginx存在多个虚拟机时候必须所有虚拟机都去掉才会生效
liboffice soffice 转码 pdf ppt
文档转为pdf1.\soffice --convert-to pdf:writer_pdf_Export --outdir C:\var\test.pdf C:\var\b.pptx
docker php 安装 pqsql
12345678910FROM php:7.2.2-fpm# 国内源RUN apt-get cleanRUN apt-get update RUN apt-get install -y libpq-devRUN docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsqlRUN docker-php-ext-install pdoRUN docker-php-ext-install pdo_pgsql
git 忽略当前目录所有文件
建立文件1.gitignore 内容12*!.gitignore 忽略文件1git rm --cached readme1.txt
pgsql
json展开值1SELECT "value" FROM "inner_id_mapping", json_each_text(inner_id_mapping.ids::json) limit 100 窗口函数增加idx的序号字段,使用over进行分窗,后续可通过idx获取组内的行数 123456SELECT *, row_number() over(partition by province order by product_num desc) idx FROM ( SELECT sum(product_num) as product_num, "province", "channel" FROM "inner_analyse" GROUP BY "channel", "province") "b" 12345678mysql:show databasespgsql:\l 或者\l+(显示的信息要...
apache nginx header 删除 配置
apache 删除响应header 1Header unset Access-Control-Allow-Origin apache 增加header 1Header set Access-Control-Allow-Methods * nginx 增加header 1add_header Access-Control-Allow-Origin $http_origin always;
