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
<p 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> </p>
時間插件
<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>