Skip to content

Instantly share code, notes, and snippets.

@OYeahllz
OYeahllz / 上传文件.html
Created December 9, 2019 13:43
[上传文件]
<div class="row">
<label class="col-sm-2 control-label"></label>
<div class="col-sm-5">
<div class="fileinput fileinput-new input-group" data-provides="fileinput">
<div class="form-control" data-trigger="fileinput">
<i class="glyphicon glyphicon-file fileinput-exists"></i>
<span class="fileinput-filename">请选择文件</span>
</div>
<span class="input-group-addon btn btn-default btn-file">
<span class="fileinput-new">Select file</span>
@OYeahllz
OYeahllz / 检查输入的日期.js
Created December 8, 2019 14:40
检查输入的日期 #日期 #date
function checkInputDate(elements, type = null) {
for (let i = 0; i < elements.length; i++) {
if (elements[i].val().trim() == '') {
return false;
}
if(type == 'date'){
if(!(/^(\d{4})-(\d{2})-(\d{2})$/).test(elements[i].val().trim())){
return false;
}
}
@OYeahllz
OYeahllz / 调用接口.php
Created December 6, 2019 10:36
[调用接口] #cms #接口
global $siteConf;
require_once ROOT_PATH . 'protected/services/RequestCmsServiceBaseLib.php';
$request = new \RequestCmsServiceBaseLib();
$request_url = $siteConf['server']['zzcms'] . '?q=/api/adsCostByCat';
$max = 3;
LogHelper::info('Request adsCostByCat start...', [
'data' => $ymd,
]);
$response = [];
while (true) {
@OYeahllz
OYeahllz / htmlToPdf.php
Created December 3, 2019 10:23
[html转pdf] #pdf
$dir_name = ROOT_PATH . 'templates/shipment_print/';
$index = '_' . microtime(true);
$filename_html = $dir_name . 'html.html';
$filename_pdf = $dir_name . 'html.pdf';
$filename_log = $dir_name . 'html_to_pdf_log.txt';
file_put_contents($filename_html, $html);
$shell = "sudo xvfb-run wkhtmltopdf -g --encoding utf-8 $filename_html $filename_pdf >>$filename_log 2>&1";
shell_exec($shell);
$pdfContentB64List = [];
$pdfContentB64List[] = base64_encode(file_get_contents($filename_pdf));
@OYeahllz
OYeahllz / 清框.sql
Created November 8, 2019 07:03
[清框操作] #sql
1
@OYeahllz
OYeahllz / get_name_array.js
Created November 6, 2019 02:19
[获取html中的数组] #html #js #tpl
let goods_ids = $("input[name='goodsId[]']").map(function () {
return $(this).val();
}).get();
@OYeahllz
OYeahllz / upload_export.html
Created October 30, 2019 11:15
[模板导入] #excel #导入 #导出
<div class="col-lg-12 query-form">
<div class="panel panel-default">
<div class="panel-heading">
<i class="fa fa-barcode" aria-hidden="true"></i>
<label style="font-size: 14px">导入</label>
</div>
<div class="panel-body">
<form id="edit_form" method="POST" class="form-horizontal" action="change_goods_name.php" enctype="multipart/form-data">
<input type="text" hidden id="act" name="act" value="" title="act"/>
<div class="box-content col-sm-12">
@OYeahllz
OYeahllz / add_random.js
Created October 29, 2019 12:22
[引入js时加入随机数] #js
<script type="text/javascript">
document.write("<s"+"cript type='text/javascript' src='../../js/erp/american_whs_management/refund_apply_usa_apply.js?"+Math.random()+"'></scr"+"ipt>");
</script>
@OYeahllz
OYeahllz / create_table.sql
Created October 27, 2019 15:40
[mysql建表规范] #mysql
CREATE TABLE IF NOT EXISTS `demo_table` (
`demo_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`int_value` int(11) NOT NULL DEFAULT '0' COMMENT '整数类型',
`float_value` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '浮点数类型',
`varchar_value` varchar(255) NOT NULL DEFAULT '' COMMENT 'varchar 类型',
`text_value` text NOT NULL COMMENT '大文本类型',
`user_name/user_id/username/action_user/create_by` varchar(100) NOT NULL DEFAULT '', -- 通常可能不同人创建的也需要添加
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`demo_id`),
@OYeahllz
OYeahllz / excel_read_bug.php
Created October 21, 2019 05:53
[excel读取数字精度不正确] 使用number_format #excel
// 这里使用number_format可以,使用round不行,即使将数据转为float
$data[$row - 1][$colMap[$col]] = number_format($data[$row - 1][$colMap[$col]],2,'.','');