Extjs
ext导入 工单导入
cookie 创建
Ext.state.Manager.
public static void main(String[] args) {
Calendar calendar = new GregorianCalendar();
String N = calendar.get(Calendar.YEAR)+"";
String Y = calendar.get(Calendar.MONTH)+1+"";
System.out.println(N +""+ Y);
String D= calendar.get(Calendar.DAY_OF_WEEK)+"";
}
@RemoteMethod managemeer
@Results( { @Result(name = CRUDActionSupport.RELOAD, location = "complaints!input.action?id=${id}&updateFlag=${updateFlag}", type = "redirect") })
public class ComplaintsAction extends CRUDActionSupport<Complaints> {
触发器
create or replace trigger tr_complaints
before
update or delete of 列名 on 表名 for each
declare
begin
if updating then
if 条件 then
执行语句
end if
elsif deleting then
update company c set c.erpmessage = '删除' where c.CM_ID = :new.CM_ID;
end if;
EXCEPTION
WHEN NO_DATA_FOUND THEN
update company c
set c.erpzt = 1, c.erpmessage = '未找到'
where c.CM_ID = :new.CM_ID;
WHEN OTHERS THEN
update company c
set c.erpzt = 1, c.erpmessage = '异常'
where c.CM_ID = :new.CM_ID;
end;
end TR_COMPANY;
点击保存的时候销毁session
session.removeValue("contact");
//当不确认是新增和更改时
complaintsmanager.saveOrUpdate(complaints);
//部门信息 工单处理后修改时执行的sql
burdenAssociateManager.deleteByGdid(complaints.getGdid());
struts 标签
初始加载工单类型赋静值
第二次是
值不变不清空
<s:select cssClass="required" cssStyle="width:80"
list="#{'':'','投诉':'投诉','差错':'差错','建议':'建议','表扬':'表扬'}"
listValue="key" id="type" onchange="contentChange(this)"
listKey="value" name="gdType" theme="simple" />
多项选择取值 并赋值
//获取工单类型元素
var flag = document.getElementById("type");
//改选项在那一项 从0起
var index = flag.selectedIndex;
//改项的值 eg 0是全部
var val = flag.options[index].value;
document.getElementById("cnt").innerHTML = val + "内容摘要";
//隐藏
$("#ssss").hide();
显示
$("#ssss").show();
多项选择option去掉
$("#tsLevel").empty();
js 给静态的多项选择赋值
$("#tsLevel").append("<option value='轻微差错'>轻微差错</option>");
针对 属性 和样式的
//当再次输入存在的电话号码的时候使其后面的联系人姓名置灰
$("#contact").attr("readolny","readolny").css({color:"red",background: "gray"});
$("#hyid").removeAttr("disabled").css({color:"red",background: "white"});
js
截取字符
var khtypes = $.trim($("#khlx").val());
var khtyp = khtypes.substr(0,3);
$("#khlx").focus();//定位
$("#hyid").val("");//清空
$("#hyid,#telphoneNum,#contact").val("");
异步提交
//散客户
ComplaintsManager.findByHyId(hyNum.value, showDataResult);
function showDataResult(datainfo) {
var khtypes = $.trim($("#khlx").val());
var khtyp = khtypes.substr(0,3);
if (null == datainfo) {
if("b2b"==khtyp||"B2B"==khtyp){
alert("该分销商编号不存在，请重新输入");
$("#hyid,#telphoneNum,#contact").val("");
}else if("OTA"==khtypes){
alert("该会员用户名不存在，请重新输入");
$("#hyid,#telphoneNum,#contact").val("");
}else if("TMC"==khtypes){
alert("该会员号不存在，请重新输入");
$("#hyid,#telphoneNum,#contact").val("");
}
多项选择
默认加载 dwr赋值
<s:select listKey="tsFrom" id="t_tsfrom" cssClass="required"
listValue="tsFrom" cssStyle="width:90" list="tsfrom1"
name="tsFrom" theme="simple" headerKey=""
onchange="getTsFromDescribe(this);" headerValue="--请选择--" />
<select id="ts_tsFrom" style="width: 90" name="tsdescribe">
<option style="color: gray">
--请选择--
</option>
</select>
//投诉信息来源信息级联
function getTsFromDescribe(ts_describe){
var tsfrom = $("#t_tsfrom").val();
var tstsFrom = $("#ts_tsFrom").val();
Ext.Ajax.request( {
url : '${ctx}/complaints/complaints!getTsFrom.action',
params : {
tsfrom : tsfrom
},
success : function(response) {
var json = Ext.util.JSON.decode(response.responseText);
if (json.success) {
var data = json.cmList;
if ("" == data) {
alert("请选择投诉类型");
inputForm.t_tsfrom.focus();
$("#ts_tsFrom").empty();
} else {
$("#ts_tsFrom").empty();
//对获取到的数据进行迭代
for ( var i = 0; i < data.length; i++) {
var id = data[i];
var name = data[i];
$("#ts_tsFrom").append(
"<option value='" + id + "'>" + name + "</option>");
}
dwr.util.removeAllOptions('tstsFrom');
dwr.util.addOptions('tstsFrom', data);
}
}
}
订单唯一性
//判断此订单号号是否存在
function checkDingdanId(userNameCnl) {
ComplaintsManager.findByOrderId(userNameCnl.value, function(di) {
//("该订单号已经存在，请重新输入或查询已存在订单详情！")
if (di != null) {
var r=confirm("该订单号已经存在，请重新输入或查询已存在订单详情！");
if(r==true){
userNameCnl.value = "";
userNameCnl.focus();
}else{
$(".img").show();
userNameCnl.focus();
}
}
//加载页面的时候就将工单编号自动生成
$(function(){
function checkDingdanIds() {
//DWR
ComplaintsManager.getMaxData(function(di) {
if (di != null) {
$("#zdgdid").val(di);
}
});
}
checkbox
<div style="display: none" id="paymodel">
<input id="yuejie" name="paymodel" type="checkbox" value="1" />
<span>月结</span>
<input id="xianjie" name="paymodel" type="checkbox" value="2" />
<span>现结</span>
<input id="zhoujie" name="paymodel" type="checkbox"
value="3" />
<span>周结</span>
<input id="banyuejie" name="paymodel" type="checkbox"
value="4" />
<span>半月结</span> </div>
时间插件
<input type="text" name="replyTime" style="display: none"
value="<fmt:formatDate value='${replyTime}' pattern='yyyy-MM-dd HH:mm:ss'/>"
id="replyTime" class="Wdate"
onfocus="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss',minDate:'%y-%M-#{%d}'})"
readonly="readonly" />
<td colspan="3" style="display: none">
<input style="display: none" title="此编号为系统自动生成，不可以更改"
autocomplete="off" name="gdid" readonly="true"
value="${gdid}" type="text" id="gdid" size="12"
maxlength="11" class="required" />
</td>