html工具类,一些小工具_automergecells-CSDN博客

本文链接：https://blog.csdn.net/qq_36521848/article/details/79447556

var markerArr;
var windowheight = $(window).height() - 20;
var windowwidth = $(window).width() - 20;
if (windowheight > 600)
windowheight = 600;
if (windowwidth > 1100)
windowwidth = 1100;

datagrid鼠标略过悬浮显示：

rowTooltip: true,

鼠标略过图片替换：
$("#menu_div_lin"+line).append(
'<div class="box" style=""><div class="img_div" style="margin:auto;width:90%;">
<img class="icon" src="${ctx}/static/model/images/menu/new/'+ico+'.png" style="cursor:pointer" οnclick="javascript:parent.showMenu(this);"/>
</div><span style="display:none;height:20px">'+navs[c]+'</span></div>');

$(".icon").hover(function(){
var s = $(this).attr("src");
$(this).attr("src",s.replace(".png","_o.png"));
},function(){
var s = $(this).attr("src");
$(this).attr("src",s.replace("_o.png",".png"));
});

表单提交
$("#excel_mainform").submit();

style="font-size: 12px;font-family: '微软雅黑'"
对象转json
alert(JSON.stringify("${res_cs.m11 }"));

var nowdate = new Date().toISOString().substring(0,10);

合并行：
onLoadSuccess: function (data){

$(this).datagrid("autoMergeCells",['qyname']);//合并指定的列

$(this).datagrid("hideColumn",['yglxnm']);//隐藏指定的列
},

<tr>
<td class="bis_htinfo_form_id_table_td">时间：</td>
<td>
<input id="sts" name="M1" class="easyui-datebox"
value="<fmt:formatDate value="${spht.m1}"/>"
style="width:208px;" data-options="required:'true',editable:false" />-
<input id="ets" name="M1_1" class="easyui-datebox"
value="<fmt:formatDate value="${spht.m1_1}"/>"
style="width:208px;" data-options="required:'true',editable:false" />
</td>
</tr>

获取下拉数据：
$('#combobox).combobox('getValue')
获取当前选中的值$('#combobox).combobox('getText')

提示框：
parent.$.messager.show({ title : "提示",msg: data, position: "bottomRight" });
parent.$.messager.show({ title : "提示",msg: "这里是提示的文字", position: "bottomRight" });

查看：disabled:true,

input是否可输入：

不可输入：
editable:false

可以输入：
editable:true

time

Calendar c = Calendar.getInstance();
c.setTime(new SimpleDateFormat("yyyy-MM-dd").parse(request
.getParameter("endtime")));
c.add(Calendar.DAY_OF_MONTH, 1);
endtime = new SimpleDateFormat("yyyy-MM-dd").format(c.getTime());

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:00");
System.out.println(sdf.format(new java.util.Date()));

disabled:true,

data-options="disabled:true"

搜索传值
if(dep_dg.datagrid('getSelections')==""){
$.messager.show({ title : "提示",msg: '请先选择一个部门！', position: "bottomRight" });
return
}

var obj = $("#searchFrom").serializeObject()
obj.depid = dep_dg.datagrid('getSelections')[0].id;
dg.datagrid('load',obj);

//合并相同列
onLoadSuccess: function(){
$(this).datagrid("autoMergeCells",['要合并的列字段']);
$(this).datagrid("autoMergeCells",['JDNM']);
},

字数限制：

必填项：
class="easyui-validatebox" data-options="editable:true,required:'true',validType:'length[1,200]'"

非必填：
class="easyui-validatebox" data-options="editable:true,validType:'length[0,200]'"

关闭按钮：
<div id="jdxx_dlg" class="easyui-dialog" closed="true" >

<div id="jdxx_dlg-buttons" style="text-align:center;">
<a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-cancel"
οnclick="javascript:$('#jdxx_dlg').dialog('close')" style="width:90px">取消</a>
</div>
</div>

Excel导出提示头文件：
<script charset="utf-8" src="${ctx}/static/plugins/kindeditor/plugins/insertfile/excelin.js?v=2"></script>

导出Excel时间处理：
// 转化数据库日期
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

for (Map<String, Object> map : list) {
String format = sdf.format(map.get("M4"));
map.put("M4", format);
}
时间判断：
头文件：
<script type="text/javascript" src="${ctx}/static/model/js/comm/validator.js?v=2"></script>
//当前的时间和要比较的id时间比较
data-options="validType:'compareDate[\'#要比较的id\',\'到期时间不能早于批准时间!\']'"

//开始时间不能大于结束时间！
var check_starttime = $('#check_starttime').datebox('getValue');
var check_endtime = $('#check_endtime').datebox('getValue');

if(check_starttime > check_endtime){
parent.$.messager.show({ title : "提示",msg: "开始时间不能大于结束时间！", position: "bottomRight" });
return;
}

my97时间格式化：
<input id="aqjd_xzxk_form_mainform_M2" name="M2" class="easyui-my97"

value="<fmt:formatDate value="${aqjd.m2 }" pattern="yyyy-MM-dd"/>"

style="width:240px;" data-options="required:'true'"/></td>

window窗口高度自适应：
var windowheight = $(window).height() - 100;
if (windowheight > 600)
windowheight = 550;
var windowheight= $(window).height()-20;
if(windowheight>400)
windowheight=400;
var tabwidth = window.parent.$("#mainTabs").width()

背景设置
//不可输入
$("*[name='ID1']").attr('disabled', 'true');

// 设置全选
$("input:checkbox").attr('checked','true');

//设置背景色
$("*[name='M" + i +"']").css('background', '#E3E3E3');

//隐藏按钮
$("#comp_xjrw_form_savebt").css('display','none');

//循环设置
for(var i=1;i<=8;i++){
$("*[name='M" + i +"']").attr('readonly', 'readonly');
$("*[name='M" + i +"']").css('background', '#E3E3E3');
}

//批量设置字体
$("input").css('font-size', '13px');

//素质三连：
onDblClickRow: function (rowdata, rowindex, rowDomElement){
showqycg(rowindex.id);
},
onLoadSuccess: function(){
$(this).datagrid("autoMergeCells",['m1']);
},
onLoadError:function(){
parent.$.messager.show({ title : "提示",msg: "数据加载中，请耐心等待。", position: "bottomRight" });
},
rowStyler:function(index,row){
if (row.m10!=null&&row.m10>0&&row.m8>row.m10){
return 'background-color:rgb(232, 190, 101);';
}
},

//保存,数据保存中
function saveBtn(){
if($("#dw_dhzy_form_mainform").form('validate')){
$.ajax({
type:'post',
url:ctx+url,
data:$("#dw_dhzy_form_mainform").serialize(),
dataType: 'text',
beforeSend:function(){
parent.$.messager.show({ title : "提示",msg: "数据载入中,请稍候...", position: "bottomRight" });
},
success:function(data){
$("#dw_dhzy_add_div").window('destroy');
dg.datagrid('reload');
}
});
}
}

判断输入小数位数
var aca_m1=$("#aca_poolfire_form_id_m2").val();
var aca_m2=$("#aca_poolfire_form_id_m2").val();
var aca_m3=$("#aca_poolfire_form_id_m3").val();
var aca_m4=$("#aca_poolfire_form_id_m4").val();
var aca_m5=$("#aca_poolfire_form_id_m5").val();
var aca_m6=$("#aca_poolfire_form_id_m6").val();
var aca_m7=$("#aca_poolfire_form_id_m7").val();
var aca_m8=$("#aca_poolfire_form_id_m8").val();

var id_m1=aca_m1.substring(aca_m1.indexOf(".")+1).length;
var id_m2=aca_m2.substring(aca_m2.indexOf(".")+1).length;
var id_m3=aca_m3.substring(aca_m3.indexOf(".")+1).length;
var id_m4=aca_m4.substring(aca_m4.indexOf(".")+1).length;
var id_m5=aca_m5.substring(aca_m5.indexOf(".")+1).length;
var id_m6=aca_m6.substring(aca_m6.indexOf(".")+1).length;
var id_m7=aca_m7.substring(aca_m7.indexOf(".")+1).length;
var id_m8=aca_m8.substring(aca_m8.indexOf(".")+1).length;

var id__m1=aca_m1.substring(0,1);
var id__m2=aca_m2.substring(0,1);
var id__m3=aca_m3.substring(0,1);
var id__m4=aca_m4.substring(0,1);
var id__m5=aca_m5.substring(0,1);
var id__m6=aca_m6.substring(0,1);
var id__m7=aca_m7.substring(0,1);
var id__m8=aca_m8.substring(0,1);
if(id__m1=="-"||id__m2=="-"||id__m3=="-"||id__m4=="-"||id__m5=="-"||id__m6=="-"||id__m7=="-"||id__m8=="-"){
parent.$.messager.show({ title : "提示",msg: "不可输入负数", position: "bottomRight" });
return;
}

if(id_m1>17||id_m2>17||id_m3>17||id_m4>17||id_m5>17||id_m6>17||id_m7>17||id_m8>17){
parent.$.messager.show({ title : "提示",msg: "小数点后不能超过17位", position: "bottomRight" });
return;
}

去除class
$(".easyui-validatebox").removeClass();

日志：
导包：
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

private static final Logger log = LoggerFactory.getLogger(当前类.class);

查询实体对象：
String sql=" SELECT * FROM ck_kucun WHERE ID1="+wlid+" AND ID2="+qyid+" AND ID3="+ckid;
List<CK_KuCunEntity> list=findBySql(sql, null,CK_KuCunEntity.class);
if(list.size()>0){
return list.get(0);
}
return null;

ddpush测试：

function ddpush() {
var userid = window.prompt("输入绑定的用户ID", "");
var content = window.prompt("输入内容", "");
$.ajax({
type : 'post',
url : ctx + "/App/ddpush?userid=" + userid + "&content=" + content,
async : false,
success : function(data) {

}
});
}

controller
@RequestMapping(value = "ddpush")
@ResponseBody
public void ddpush(HttpServletRequest request) throws ParseException {
new Pushclass().sendMsg(request.getParameter("userid"),
request.getParameter("content"));
}

修改新思路：
$('#yhpc_pcjh_form_mainform').form('load', datas.rows[0])
可以通过load方法将数据实现el表达式的效果，但是需要name 值名称一致
function upd() {
_url = ctx + '/model/yhpc/edit';
var row = dg.datagrid('getSelections');
if (rowIsNull(row) || row == undefined || row[0] == undefined
|| row.length != 1) {
parent.$.messager.show({
title : "提示",
msg : "请选择单行！",
position : "bottomRight"
});
return;
}
var rowIndex = row[0].id;
if (rowIsNull(row))
return;
$("<div id='yhpc_pcjh_dlg_edit_div'></div>").window(
{
title : '隐患排查计划修改页面',
collapsible : false,
minimizable : false,
maximizable : false,
width : 700,
height : 350,
modal : true,
href : ctx + '/model/yhpc/update/' + rowIndex,// 修改请求页面
onLoad : function() {
loadDept(false);
$("#yhpc_pcjh_form_savebt").bind(
'click',
function() {
saveBtn("#yhpc_pcjh_form_mainform",
"#yhpc_pcjh_dlg_edit_div", dg);
});
$("#yhpc_pcjh_form_cancelbt").bind('click', function() {
$('#yhpc_pcjh_dlg_edit_div').window('destroy');// 销毁dialog
})
loaddata(rowIndex);
},
onClose : function() {
$('#yhpc_pcjh_dlg_edit_div').window('destroy');// 销毁dialog
}
});
}

function loaddata(_id) {
$.ajax({
type : 'post',
url : ctx + '/xhtt/Q/zr64zWMnIaOPrsG',
data : {
"id" : _id
},
async : false,
success : function(data) {
var datas = JSON.parse(data);
if (datas.code == 200) {
$('#yhpc_pcjh_form_mainform').form('load', datas.rows[0]);
$("#depid").val(datas.rows[0].depid);
loaduser(datas.rows[0].depid);
// 显示用户名
$("#userid").combobox('setValue',datas.rows[0].userid);
$("#userid").combobox('setText',datas.rows[0].username);
}
}
});
}
sql：

select * from t_hidderdanger_plan where id={id}

下拉框：
获取：
$("#userid").combobox('getValue');
$("#userid").combobox('getText');
赋值：
$("#userid").combobox('setValue',datas.rows[0].userid);
$("#userid").combobox('setText',datas.rows[0].username);
死下拉框：
<td class="yhpc_pcjh_form_id_table_td">排查频率：</td>
<td><input class="easyui-combobox" name="exectime" id="exectime"
data-options="required:true,width:128,editable:false,data: [
{value:'1',text:'每日'},
{value:'2',text:'每周'},
{value:'3',text:'每半月'},
{value:'4',text:'每月'} ] " /></td>

活的下拉框：
<input id="cc" class="easyui-combobox" name="dept" data-options="valueField:'id',textField:'text',url:'get_data.php'">
sql ：select id,name text from tab

删除新方法：
function del_device(){
var rows = dg.datagrid('getChecked');
if(rows.length==0){
$.messager.show({ title : "提示",msg: '请先选择至少一条记录！', position: "bottomRight" });
return;
}
var ids=[];
for(var i=0;i<rows.length;i++){
ids.push(rows[i].id);
}
parent.$.messager.confirm('提示', '删除后无法恢复您确定要删除？', function(data) {
if (data) {
$.ajax({
type:'post',
url:ctx+'/set/device/delDevice',
data:{ids:ids.toString()},
async:false,
success:function(data){
$.messager.show({ title : "提示",msg: data, position: "bottomRight" });
for(var i=0; i<ids.length; i++){
var index = dg.datagrid('getRowIndex',ids[i]);//获取某行的行号
dg.datagrid('deleteRow',index); //通过行号移除该行
}
cx_device();
}
});
}
});

}

function cx_device(depid,postid){
dg.datagrid('load',{name:$('#searchname').val(),depid:depid||$('#s_depid').combotree('getValue'),postid:postid||$('#s_postid').combobox('getValue')});
}

/**
* 删除设备
*/
@RequestMapping(value = "delDevice", method = RequestMethod.POST)
@ResponseBody
public String delDevice(Model model, HttpServletRequest request) {
String datasuccess = "删除成功！";
int ret = setPointService.findpointbydeviceids(request
.getParameter("ids"));
if (ret > 0) {
return "已有设备已经绑定巡检点,无法删除!";
}
service.delDevice(request.getParameter("ids"));
return datasuccess;
}

public void delDevice(String ids) {
dao.delDevice(ids);
dao.delDeviceContent(ids);
dao.delPointDevice(ids);
}

public void delDevice(String ids) {
String sql = "UPDATE t_device SET status=0 WHERE id in (" + ids + ")";
updateBySql(sql);
}

public void delDeviceContent(String ids) {
String sql = "UPDATE t_device_content SET status=0 WHERE deviceid in ("+ ids + ")";
updateBySql(sql);
}

public void delPointDevice(String ids) {
String sql = "delete t_point_device WHERE deviceid in (" + ids + ")";
updateBySql(sql);
}

查询：
public int findpointbydeviceids(String ids) {
return dao.findpointbydeviceids(ids);
}

public int findpointbydeviceids(String ids) {
// TODO Auto-generated method stub
String sql = "select * from t_point_device where deviceid in (" + ids
+ ")";
List<Map<String, Object>> list = findBySql(sql, null, Map.class);
return list != null ? list.size() : 0;
}

时间戳：

Timestamp t=DateUtils.getSysTimestamp();
tm.setS1(t);
tm.setS2(t);
tm.setID1((long)UserUtil.getCurrentUser().getId());

时间加减法：
前两分钟：
select d.*,p.name as deptname FROM t_sos d left join t_department p on d.depid=p.id where dateadd(minute,-2,GETDATE()) < d.sosdatetime

df.format(hti_task.getWorkdate()).equals(df.format(new Date(d.getTime()- (SqlContentDefineConfigue.hti_TimeInfos.get(hidderdanger_plan.getExectime()) * 24 * 60 * 60 * 1000))))

if(mapData.get("dqtime")!=null&&mapData.get("dqtime")!=""){//到期时间范围查询
if(mapData.get("dqtime").equals("0")){//一星期内
content+=" and datediff(d,getdate(),M3)<=7 and M3>GETDATE() ";
}else if(mapData.get("dqtime").equals("1")){//一个月内
content+=" and datediff(m,getdate(),M3)<=1 and M3>GETDATE() and M3<=dateadd(m,1,getdate())";
}else if(mapData.get("dqtime").equals("2")){//三个月内
content+=" and datediff(m,getdate(),M3)<=3 and M3>GETDATE() and M3<=dateadd(m,3,getdate())";
}else if(mapData.get("dqtime").equals("3")){//全部过期
content+=" and M3<GETDATE() ";
}
}

if(mapData.get("dqtime")!=null&&mapData.get("dqtime")!=""){//到期时间范围查询
if(mapData.get("dqtime").equals("0")){//一星期内
content+=" and datediff(d,getdate(),M5)<=7 and M5>GETDATE() ";
}else if(mapData.get("dqtime").equals("1")){//二星期内
content+=" and datediff(d,getdate(),M5)<=14 and M5>GETDATE() ";
}else if(mapData.get("dqtime").equals("2")){//三星期内
content+=" and datediff(d,getdate(),M5)<=21 and M5>GETDATE() ";
}else if(mapData.get("dqtime").equals("3")){//一个月内
content+=" and datediff(m,getdate(),M5)<=1 and M5>GETDATE() and M5<=dateadd(m,1,getdate())";
}else if(mapData.get("dqtime").equals("4")){//两个月内
content+=" and datediff(m,getdate(),M5)<=2 and M5>GETDATE() and M5<=dateadd(m,1,getdate())";
}else if(mapData.get("dqtime").equals("5")){//已过期
content+=" and M5<GETDATE() ";
}
}

选中一条去除一条
查询中间表然后，not in 就可以了
/**
* rfid查找
* */
public List<Map<String, Object>> getRFIDList(String pid) {
String sql = "select id, 'RFID值:'+val+';RFID名称:'+name info"
+ " from t_rfid where status=1 and id not in (select rfid from t_point_rfid ";
if(pid!=null&&!pid.equals("")){//检点id
sql+=" where pointid<>"+pid;
}
sql+=")";
List<Map<String, Object>> list = findBySql(sql, null, Map.class);
return list;
}

Java 时间操作：

String content = content(map);

String m4="";//开始月
String m4_1="";//后一月

String sqlString = "select t.m4,t.m4_1 from contract_information t where t.id="+ map.get("id1");
List<Map<String, Object>> listinfo = findBySql(sqlString, null,Map.class);
if (listinfo != null && listinfo.size() > 0) {
for (int i = 0; i < listinfo.size(); i++) {
m4 = listinfo.get(i).get("m4").toString();
m4_1 = listinfo.get(i).get("m4").toString();
}
}
String sql = " SELECT top "
+ map.get("pageSize")
+ " * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY c.id) AS RowNumber,c.* "
+ "from contract_serviceplan c where c.s3=0 " + content
+ " ) as a " + "WHERE S3=0 AND RowNumber > "
+ map.get("pageSize") + "*(" + map.get("pageNo") + "-1) ";

List<Map<String, Object>> list = findBySql(sql, null, Map.class);
if (list != null && list.size() > 0) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
for (int i = 0; i < list.size(); i++) {

Calendar st=Calendar.getInstance();
Calendar et=Calendar.getInstance();
try {
st.setTime(sdf.parse(m4));
et.setTime(sdf.parse(m4_1));
} catch (ParseException e) {
e.printStackTrace();
}
st.add(Calendar.MONTH,i); //将当前日期加一个月
et.add(Calendar.MONTH,i+1); //将当前日期加两个月
String stime=sdf.format(st.getTime()); //返回String型的时间
String etime=sdf.format(et.getTime()); //返回String型的时间

list.get(i).put("time", stime + " 至 " + etime);
}
}
return list;

图片展示：

获取值类型：

值：/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)
,/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)
,/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)
,/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)
,/ZJCA/upload/image/20171024/20171024113856_168.jpg||timg (1)
,/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)
,/ZJCA/upload/image/20171024/20171024113540_266.jpg||timg (2)

展示代码：

{field:'m6',title:'整改参照示例',align:'left',width:100,formatter: function(value,row,index){
var str="";
alert('值：'+value);
if(value!=null && value!=""){
var arr=value.split(",");
for(var i=0;i<arr.length;i++){
str=str+ "  <a target='_blank' href='"+arr[i].split('||')[0]+"'>"+arr[i].split('||')[1]+"</a>";
}
}
return str;
}
}