WebDesign 心得綜整: 7月 2023

2023年7月31日星期一

V40A – [過濾資料]鈕 – 不分頁, 顯示在同一頁 -T1C– 取得 SQL全部資料後, 過濾資料, 再顯示在同一頁 - 重設總筆數

目的: V40A – [過濾資料]鈕 – 顯示在同一頁 – 取得 SQL全部資料後, 過濾資料, 再顯示在同一頁

處理說明: 1> getGridData_M 取全部資料 , 不分頁(par_paging=false)
2> 取得 CaluField - SAP單況(I0001/I0002/..)

3> 過濾 SAP單況 , 符合條件的保留, 不符合的 dr.delete()

4> 傳回符合條件的 ds , 必需修改 ["T1C"] 欄位值(總筆數)

ds.Tables["T1C"].Rows[0]["TOTAL"] = ds.Tables["T1"].Rows.Count;

5> 不分頁, 全部顯示在同一頁,設定每頁筆數=9999(store.pageSize)

Ext.getCmp('grid_Single').store.pageSize = 9999;

6>[過濾SAP單況]鈕, 必需將過濾欄位值記錄為[過濾條件欄位(s_Filter_Str)]-隱藏欄位,

以便顯示時,依該過濾條件過濾

--> [資料顯示]時,再清除該欄位值(s_Filter_Str)

1>*.js

//[過濾 SAP單況]鈕

{

xtype: 'button', text: '確定', id: 'OkBtn_V40AB',

listeners: {

click: function (me, e, eOpts) {

//1>更新資料庫資料(AMM_COMPQTY)

var Tmp_Str = "";

if (!(Ext.getCmp("s_SAPSTAT1").getValue()) && !(Ext.getCmp("s_SAPSTAT2").getValue()) && !(Ext.getCmp("s_SAPSTAT3").getValue())) {

Tmp_Str = "SAP單況不可均不勾選 "

+ " 敬請檢核 !!";

mywarnalert(Tmp_Str);

return;

}

var Tmp_Filter_Str = "";

if (Ext.getCmp("s_SAPSTAT1").getValue()) {

Tmp_Filter_Str = Tmp_Filter_Str + "I0001" + ",";

}

if (Ext.getCmp("s_SAPSTAT2").getValue()) {

Tmp_Filter_Str = Tmp_Filter_Str + "E0014" + "," + "E0015" + ",";

}

if (Ext.getCmp("s_SAPSTAT3").getValue()) {

Tmp_Filter_Str = Tmp_Filter_Str + "I0002" + ",";

}

if (checkisnull(Tmp_Filter_Str)) {

Tmp_Filter_Str = Tmp_Filter_Str.substr(0, Tmp_Filter_Str.length - 1);

}

// 重新顯示 - 全部顯示在同一頁

var np = s_JSON('s_form'); //TMFunction.js, 組合form上的查詢條件為json參數傳遞

np["s_isSAPSTAT"] = Ext.getCmp('s_isSAPSTAT').getValue();

np["s_TYPEAF"] = Ext.getCmp('s_TYPEAF').getValue();

np["s_Filter_Str"] = Tmp_Filter_Str;

//console.log('1 gridstore: ', gridstore);

var gridstore = Ext.getCmp('grid_Single').store;

gridstore.getProxy().url = '../api/V40AAPI/getGridData_M?par_paging=false';

gridstore.getProxy().extraParams = np;　//分頁OK,篩選條件OK

Ext.getCmp('grid_Single').store.pageSize = 9999;

Ext.getCmp('grid_Single').reloadGridData();

this.up("window").close();

this.up("window").destroy();

}

//[顯示資料]鈕, 一般正常分頁顯示

{

xtype: 'button',

id: 'btn_Show',

flex: 2,

border: 1,

text: '資料顯示',

iconCls: 'icon-search',

handler: function () {

// 更新 STP欄位值

var np = s_JSON('s_form'); //TMFunction.js, 組合form上的查詢條件為json參數傳遞

np["s_isSAPSTAT"] = Ext.getCmp('s_isSAPSTAT').getValue();

np["s_TYPEAF"] = Ext.getCmp('s_TYPEAF').getValue();

np["s_Filter_Str"] = ""; //[過濾SAP單況]鈕,才會有值過濾SAP單況條件空白

//console.log('1 gridstore: ', gridstore);

//var gridstore = Ext.getCmp('grid_Single').store;

gridstore.getProxy().url = '../api/V40AAPI/getGridData_M';

gridstore.getProxy().extraParams = np;　//分頁OK,篩選條件OK

Ext.getCmp('grid_Single').store.pageSize = 30;

Ext.getCmp('grid_Single').reloadGridData();

}

}, // end of 顯示資料

2>V40A*.cs

[HttpPost]

public dynamic getGridData_M(bool par_paging = true)

{

var c = HttpContext.Current;

NameValueCollection nvc = c.Request.Form;

//panel1

string Tmp_AMMNO = nvc["s_AMMNO"];

string Tmp_SAPNO = nvc["s_SAPNO"];

string Tmp_WBSNO = nvc["s_WBSNO"];

string Tmp_PN = nvc["s_PN"];

//panel2

string Tmp_OGONOAF = nvc["s_OGONOAF"]; //拆檢提領編號

string Tmp_NGONOAF = nvc["s_NGONOAF"]; //維修提領編號

string Tmp_MRPNOAF = nvc["s_MRPNOAF"]; //拆檢交修編號

string Tmp_RPNOAF = nvc["s_RPNOAF"]; //維修交修編號

//panel3

string Tmp_SAPMAN = nvc["s_SAPMAN"];

string Tmp_FIXSN = nvc["s_FIXSN"];

string Tmp_CREMPLYID = nvc["s_CREMPLYID"];

string Tmp_FACWC = nvc["s_FACWC"];

//panel4

string Tmp_isSAPSTAT = nvc["s_isSAPSTAT"]; //料號

string Tmp_TYPEAF = nvc["s_TYPEAF"]; //'3'/'4' : 拆檢約/維條約

string Tmp_Filter_Str = nvc["s_Filter_Str"]; //過濾 SAP單況

string Tmp_SAPDT1 = ""; //發工日期 - 起迄

string Tmp_SAPDT2 = ""; //發工日期 - 起迄

if (!myfunc.checkisnull(nvc["s_SAPDT1"]))

{

Tmp_SAPDT1 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_SAPDT1"]));

};

if (!myfunc.checkisnull(nvc["s_SAPDT2"]))

{

Tmp_SAPDT2 = string.Format("{0:yyyy/MM/dd}", DateTime.Parse(nvc["s_SAPDT2"]));

};

OracleCommand cmd = new OracleCommand();

string Tmp_Sql = " SELECT RNK, "

+ " AMMNO,SAPNO,PN,FIXSN,PNNAME,SAPMAN,SAPDT,WBS,QTY,UNIT, "

+ " FMNO,OGONOAF,NGONOAF,MRPNOAF,RPNOAF,TYPEAF,FACWC,"

+ " CREMPLYID,NEMPID,MEMPID "

+ " FROM ( "

+ " SELECT dense_rank() over(order by A.AMMNO,B.FMNO) as RNK,"

+ " A.AMMNO,A.SAPNO,A.PN,A.FIXSN,A.PNNAME,A.SAPMAN,A.SAPDT,A.WBS, A.QTY,A.UNIT, "

+ " B.FMNO,B.OGONOAF,B.NGONOAF,B.MRPNOAF,B.RPNOAF,B.TYPEAF,B.FACWC, "

+ " B.CREMPLYID,B.NEMPID,B.MEMPID "

+ " FROM AMM_SRO A, AMM_FM B "

+ " WHERE A.AMMNO=B.AMMNO "

+ " AND A.AMMSTS NOT IN ('A','B','F','G','H','I','W','X','Y','Z') "

+ " AND A.SAPNO IS NOT NULL "

+ " AND A.ISSYS='Y' ";

//AMM單號

if (!myfunc.checkisnull(Tmp_AMMNO))

{

Tmp_Sql = Tmp_Sql + " AND A.AMMNO = " + myfunc.AA(Tmp_AMMNO);

};

//工號

if (!myfunc.checkisnull(Tmp_SAPNO))

{

Tmp_Sql = Tmp_Sql + " AND A.SAPNO=" + myfunc.AA(Tmp_SAPNO);

};

//WBS

if (!myfunc.checkisnull(Tmp_WBSNO))

{

Tmp_Sql = Tmp_Sql + " AND A.WBS LIKE " + myfunc.AA("%"+Tmp_WBSNO+"%");

};

//件號

if (!myfunc.checkisnull(Tmp_PN))

{

Tmp_Sql = Tmp_Sql + " AND A.PN LIKE " + myfunc.AA("%" + Tmp_PN+"%");

};

//拆檢提領編號

if (!myfunc.checkisnull(Tmp_OGONOAF))

{

Tmp_Sql = Tmp_Sql + " AND B.OGONOAF LIKE " + myfunc.AA('%' + Tmp_OGONOAF + '%');

};

//維修提領編號

if (!myfunc.checkisnull(Tmp_NGONOAF))

{

Tmp_Sql = Tmp_Sql + " AND B.NGONOAF LIKE " + myfunc.AA('%' + Tmp_NGONOAF + '%');

};

//拆檢交修單號

if (!myfunc.checkisnull(Tmp_RPNOAF))

{

Tmp_Sql = Tmp_Sql + " AND B.RPNOAF LIKE " + myfunc.AA('%' + Tmp_RPNOAF + '%');

};

//維修交修單號

if (!myfunc.checkisnull(Tmp_MRPNOAF))

{

Tmp_Sql = Tmp_Sql + " AND B.MRPNOAF LIKE " + myfunc.AA('%' + Tmp_MRPNOAF + '%');

};

//發工人員

if (!myfunc.checkisnull(Tmp_SAPMAN))

{

Tmp_Sql = Tmp_Sql + " AND A.SAPMAN=" + myfunc.AA(Tmp_SAPMAN);

};

//維修件序號

if (!myfunc.checkisnull(Tmp_FIXSN))

{

Tmp_Sql = Tmp_Sql + " AND A.FIXSN LIKE " + myfunc.AA("%"+Tmp_FIXSN+ "%");

};

//管制人員

if (!myfunc.checkisnull(Tmp_CREMPLYID))

{

Tmp_Sql = Tmp_Sql + " AND B.CREMPLYID=" + myfunc.AA(Tmp_CREMPLYID);

};

//承修工場

if (!myfunc.checkisnull(Tmp_FACWC))

{

Tmp_Sql = Tmp_Sql + " AND B.FACWC= " + myfunc.AA(Tmp_FACWC);

};

//約別

if (!myfunc.checkisnull(Tmp_TYPEAF))

{

Tmp_Sql = Tmp_Sql + " AND B.TYPEAF IN (" + myfunc.AddQuoteStr(Tmp_TYPEAF)+")";

};

string Tmp_Sql1 = "";

//發工日期 - 起 - 迄

if ((!myfunc.checkisnull(Tmp_SAPDT1)) || (!myfunc.checkisnull(Tmp_SAPDT2)))

{

if (!myfunc.checkisnull(Tmp_SAPDT1))

{

Tmp_Sql1 = Tmp_Sql1 + " AND SAPDT>=" + myfunc.AA(Tmp_SAPDT1);

};

if (!myfunc.checkisnull(Tmp_SAPDT2))

{

Tmp_Sql1 = Tmp_Sql1 + " AND SAPDT<=" + myfunc.AA(Tmp_SAPDT2);

}

Tmp_Sql = Tmp_Sql + Tmp_Sql1;

};

Tmp_Sql = Tmp_Sql + " ) ";

cmd.CommandText = Tmp_Sql;

string countSql = " SELECT COUNT(*) as total FROM (" + Tmp_Sql + ")";

//匯出時 ,取全部資料, par_paging =false

DataSet ds = getDataTable(cmd, countSql, par_paging);

//////新增 CaluField 欄位

//- [約別(TYPEAF) ]

Tmp_Sql = " select KEY_CODE as TYPEAF, DESCPT "

+ " from KEYCODE "

+ " where TBL_NAME = 'AMM_FM' "

+ " and KEY_NAME = 'TYPEAF' ";

getKeyCode("TYPEAF", ref ds, Tmp_Sql);

////新增 CaluField [SAP工單單況_(AMM_SRO.SAPSTAT_)]

int Tmp_Cnt = ds.Tables["T1"].Rows.Count;

ds.Tables["T1"].Columns.Add(new DataColumn("SAPMAN_", typeof(string)));

ds.Tables["T1"].Columns.Add(new DataColumn("CREMPLYID_", typeof(string)));

ds.Tables["T1"].Columns.Add(new DataColumn("SAPSTAT_", typeof(string)));

ds.Tables["T1"].Columns.Add(new DataColumn("SAPSTAT__", typeof(string)));

string Tmp_SAPMAN_ = "";

string Tmp_CREMPLYID_ = "";

string Tmp_SAPNO1 = "";

string Tmp_SAPNO_ = "";

string Tmp_SAPSTAT_ = "", Tmp_SAPSTAT__ = "";

string Tmp_TYPEAF_ = "";

string Tmp_Str;

for (int i = 0; i < Tmp_Cnt; i++)

{

DataRow dr = ds.Tables["T1"].Rows[i];

//取得發工人員/管制人員(SAPMAN/CREMPLYID).姓名

Tmp_SAPMAN_ = myfunc.getEmp_NM(dr["SAPMAN"].ToString());

Tmp_CREMPLYID_ = myfunc.getEmp_NM(dr["CREMPLYID"].ToString());

dr["SAPMAN_"] = Tmp_SAPMAN_;

dr["CREMPLYID_"] = Tmp_CREMPLYID_;

//取得 SAP工單狀態(SAPSTAT)

Tmp_SAPNO1 = dr["SAPNO"].ToString();

//轉換成 SAP系統的工號

Tmp_SAPNO_ = myfunc.get_SAPNO(Tmp_SAPNO1, "OR");

//取得 SAP工號的單況

if (Tmp_isSAPSTAT!="true") { //若!="true" , 則不顯示 [SAP工單狀態]

dr["SAPSTAT_"] = "";

continue;

}

Tmp_SAPSTAT_ = ""; Tmp_SAPSTAT__ = "";

if (!myfunc.checkisnull(Tmp_SAPNO_))

{

//Tmp_Sql = " SELECT OBJNR,STAT,INACT,CHGNR,UDATE,UTIME "

Tmp_Sql = " SELECT STAT "

+ " FROM SAPR3.JCDS@SAP "

+ " WHERE 1 = 1 "

+ " AND MANDT = '999' "

+ " AND OBJNR = " + myfunc.AA(Tmp_SAPNO_)

+ " AND INACT = ' ' "

+ " AND STAT IN('I0001','I0002', 'E0015', 'I0076', 'E0022', 'E0012', 'I0045', 'I0013', 'I0012', 'I0046') "

+ " AND (STAT, CHGNR) NOT IN "

+ " ( SELECT STAT, LPAD((to_number(CHGNR)-1),3,0) as CHGNR "

+ " FROM SAPR3.JCDS@SAP "

+ " WHERE 1 = 1 "

+ " AND MANDT = '999' "

+ " AND OBJNR = " + myfunc.AA(Tmp_SAPNO_)

+ " AND INACT = 'X' "

+ " AND STAT IN('I0001','I0002', 'E0015', 'I0076', 'E0022', 'E0012', 'I0045', 'I0013', 'I0012', 'I0046') "

+ " ) "

+ " ORDER BY UDATE DESC, UTIME DESC ";

Tmp_Str = myfunc.SqlValue(Tmp_Sql);

if (Tmp_Str.Length > 0)

{

Tmp_SAPSTAT_ = myfunc.StrExtract(Tmp_Str, 1, ";");

Tmp_SAPSTAT__ = get_SAPSTAT_NM(Tmp_SAPSTAT_);

}

} // if (!myfunc.checkisnull(Tmp_SAPNO_))

dr["SAPSTAT_"] = Tmp_SAPSTAT_; //SAP單況碼 : I0001/I0002/E0014/E0015

dr["SAPSTAT__"] = Tmp_SAPSTAT__; //SAP單況碼說明 : CREATE/RELEASE/ROFF //[過濾 SAP單況]鈕 , 若欲過濾 SAP單況 --> 即符合的單況才保留,其他刪除

} // end of for (int i = 0; i < Tmp_Cnt; i++)

//[過濾SAP單況]鈕, 處理

if (Tmp_Filter_Str.Length > 0)

{

for (int i = 0; i < Tmp_Cnt; i++)

{

DataRow dr = ds.Tables["T1"].Rows[i];

Tmp_SAPSTAT_ = dr["SAPSTAT_"].ToString();

//若i> 目前的資料數量,則離開

if (i >= ds.Tables["T1"].Rows.Count)

{

break;

}

if (myfunc.checkisnull(Tmp_SAPSTAT_))

{

dr.Delete();

continue;

}

if (Tmp_Filter_Str.IndexOf(Tmp_SAPSTAT_) == -1)

{

dr.Delete();

}

} // end of for (int i=0;

//重新設定總筆數

ds.Tables["T1"].AcceptChanges();

ds.Tables["T1C"].Rows[0]["TOTAL"] = ds.Tables["T1"].Rows.Count;

}// end of if (Tmp_Filter_Str.Length > 0)

//var Tmp_Filter = "SAPSTAT__='RELEASE'";

//ds.Tables["T1"].Select(Tmp_Filter);

return ds;

}

2023年7月30日星期日

V120202C -[撿料完成]– 簡單子畫面 – 一般欄位(Form) - readonly

目的: V120202C – 顯示子畫面 – 一般欄位(Text) – 撿料完成

處理說明: 1>顯示子視窗
var win = getMyWindow("撿料完成", J_formFields_V120202C, Btns_V120202C);
win.width = 600;
win.height = 450;
win.show();

2>子畫面欄位

1>*.js
// [Call_V120202C]鈕 - 子畫面欄位
var J_formFields_V120202C = [
{
bodyStyle: "background-color:transparent;", border: false, layout: "vbox", padding: "5", items: [
{
xtype: "fieldcontainer", fieldLabel: "申請單號", labelWidth: 100, layout: "hbox", items: [
{
id: "V120202C_APNO", name: "V120202C_APNO", xtype: "textfield", width: 150, padding: "0 4 0 0", fieldCls: "required",
listeners: {
change: function (me, newValue, oldValue, eOpts) {
if (!(newValue.length == 12))
return;
var np = {};
np["APNO"] = newValue;
var Tmp_url = "../../api/V120202CAPI/get_APNO1";
var rtn_Str = getUrlStr(Tmp_url, np, "取得申請單號.件號/名稱 /數量");
if (checkisnull(rtn_Str)) {
Ext.getCmp("V120202C_MATNR").setValue("");
Ext.getCmp("V120202C_MAKTX").setValue("");
Ext.getCmp("V120202C_QTY").setValue("0");
Tmp_Str = "申請單號(" + newValue + ")無相關資料 "
+ "請檢核!!";
mywarnalert(Tmp_Str);
return;
}
if (checkRtnOK(rtn_Str)) {
var Tmp_recs = Ext.decode(rtn_Str);
var Tmp_rec = Tmp_recs[0];
console.log("Tmp_rec:", Tmp_rec);
Ext.getCmp("V120202C_MATNR").setValue(Tmp_rec.MATNR);
Ext.getCmp("V120202C_MAKTX").setValue(Tmp_rec.MAKTX);
Ext.getCmp("V120202C_QTY").setValue(Tmp_rec.QTY);
Ext.getCmp("V120202C_STAT").setValue(Tmp_rec.STAT);
} // end of if (checkRtnOK(rtn_Str))
} // end of change
} // end of listeners
},
{
xtype: "button", id: "btn_V120202C_APNO", name: "btn_V120202C_APNO", text: "...",
hidden: true,
//員工編號挑選 , TreeView 挑選
handler: function () {
var win = EditPickx('申請單號', '../api/V120202CAPI/get_APNOPick', ['APNO', 'MATNR', 'MAKTX', 'QTY','STAT'], ['V120202C_APNO', 'V120202C_MATNR', 'V120202C_MAKTX', 'V120202C_QTY','V120202C_STAT'], J_pickstore_V120202C_APNO, J_pickcolumns_V120202C_APNO);
win.show();
}
},
]
}, //end of 申請單號
{
xtype: "fieldcontainer", fieldLabel: "撥料件號", labelWidth: 100, layout: "hbox", items: [
{ id: "V120202C_MATNR", name: "V120202C_MATNR", xtype: "textfield", width: 150, padding: "0 4 0 0", readOnly: true, fieldCls: "readonly", },
]
}, // end of 撥料件號
{
xtype: "fieldcontainer", fieldLabel: "名稱", labelWidth: 100, layout: "hbox", items: [
{ id: "V120202C_MAKTX", name: "V120202C_MAKTX", xtype: "textfield", width: 150, padding: "0 4 0 0", readOnly: true, fieldCls: "readonly", },
]
}, // end of 名稱
{
xtype: "fieldcontainer", fieldLabel: "數量", labelWidth: 100, layout: "hbox", items: [
{ id: "V120202C_QTY", name: "V120202C_QTY", xtype: "textfield", width: 150, padding: "0 4 0 0", readOnly: true, fieldCls: "readonly", },
]
}, // end of 數量
{
xtype: "fieldcontainer", fieldLabel: "單況", hidden: true, labelWidth: 100, layout: "hbox", items: [
{ id: "V120202C_STAT", name: "V120202C_STAT", xtype: "textfield", width: 150, padding: "0 4 0 0", hidden: true, readOnly: true, fieldCls: "readonly", },
]
}, // end of 單況
] // end of layout: "vbox", padding: "5", items: [
} //end of J_formFields_Sub1 , items[{
] //end of J_formFields_Sub1 , items[

//2>顯示子畫面 - 按鈕
var Btns_V120202C = [
{
xtype: 'button', text: '確定', id: 'OkBtn_V120202C',
listeners: {
click: function (me, e, eOpts ) {
//1>更新資料庫資料(AMM_COMPQTY)
var Tmp_Str = "";
if (checkisnull(Ext.getCmp("V120202C_APNO").getValue())) {
Tmp_Str = "申請單號不可空白 "
+ " 敬請檢核 !!";
mywarnalert(Tmp_Str);
return;
}

if (checkisnull(Ext.getCmp("V120202C_MATNR").getValue())) {
Tmp_Str = "申請單號(" + Ext.getCmp("V120202C_APNO").getValue() + ") "
+"撥料件號(" + Ext.getCmp("V120202C_MATNR").getValue() + ") "
+"不可空白 "
+"敬請檢核 !!";
mywarnalert(Tmp_Str);
return;
}

var Tmp_STAT = Ext.getCmp("V120202C_STAT").getValue();
if (checkisnull(Tmp_STAT)) {
Tmp_Str = "申請單號(" + Ext.getCmp("V120202C_APNO").getValue() + ") "
+ "單況(" + Ext.getCmp("V120202C_STAT").getValue() + ") "
+ "不可空白 "
+ "敬請檢核 !!";
mywarnalert(Tmp_Str);
return;
}

var Tmp_msg = "";
if (Tmp_STAT != "B") {
switch (Tmp_STAT) {
case "A": {
Tmp_msg = "尚未執行條碼列印!!";
break;
}
case "C": {
Tmp_msg = "撿料已完成勿重覆執行!!";
break;
}
case "D": {
Tmp_msg = "該筆物料已領用, 請確認 !!";
break;
}
case "Z": {
Tmp_msg = "該筆物料已撤銷, 請確認 !!";
break;
}
} //end of switch
mywarnalert(Tmp_msg);
return
} // if <>B

//更新單況
var Tmp_url = '../../api/V120202CAPI/UPDATE_STAT'
var np1 = {};
np1["APNO"] = Ext.getCmp("V120202C_APNO").getValue();
var Rtn_Str = getUrlStr(Tmp_url, np1, "撿料完成(V120202C)");
if (checkRtnOK(Rtn_Str)) {
Tmp_Str = "申請單號(" + Ext.getCmp("V120202C_APNO").getValue() + ") "
+ "單況已變更為 C:撿料完成!!";
mysuccessalert(Tmp_Str);
//清空畫面的欄位值
var f = this.up("form");
console.log("f :", f);
console.log("f.form :", f.form);
f.form.reset();
}
else {
Tmp_Str = "申請單號(" + Ext.getCmp("V120202C_APNO").getValue() + ") "
+ "單況已變更失敗!!";
mywarnalert(Tmp_Str);
}
// end of checkRtnOk

//2> close windows
//this.up("window").close();
//this.up("window").destroy();
//3>重新更新 MDBGrid
//Ext.getCmp("btn_Show").fireHandler();
}
}
},
{
xtype: 'button', text: '取消', id: 'CancelBtn_mySub1',
listeners: {
click: function () {
this.up("window").close();
this.up("window").destroy();
//3>重新更新 MDBGrid
Ext.getCmp("btn_Show").fireHandler();
}
}
},
];

V40A - checkbox 及 checkboxGroup 的用法

目的: V40A - checkbox 及 checkboxGroup 的用法

處理說明: 1> 若單獨 checkbox ,必需設定 id ,

Ext.getCmp(id).getValue() à true/false

2> 若checkboxGroup(grp_id), checkbox必需設定name=grp_id

Ext.getCmp(grp_id).getValue()=checkbox.inputValue

1>V40A.js

1>>[顯示 SAP單況]

{ xtype: 'checkbox', boxLabel: ‘顯示SAP單況’, id: ‘s_isSAPSTAT’, labelWidth : 80,inputValue: ‘Y’, margin: 0 0 0 0 , },

è Ext.getCmp(“s_isSAPSTAT).getValue()=true/false

2>>[約別] : checkboxGroup

{ xtype: 'checkboxgroup', fieldLabel: ‘約別’, labelWidth: 80, layout: 'vbox', id: ‘s_TYPEAF’,

items: [{ xtype: 'checkbox', boxLabel: ‘拆檢約’, name: ‘s_TYPEAF’, labelWidth : 80,

inputValue: ‘3’, margin: 0 0 0 0 , },

{ xtype: 'checkbox', boxLabel: ‘維修約’, name: ‘s_TYPEAF’, labelWidth : 80,

inputValue: ‘4’, margin: 0 0 0 0 , },]

} },}

è Ext.getCmp(“s_TYPE”).getValue()=’3,4’ //均勾選

Ext.getCmp(“s_TYPE”).getValue()=’3’ //拆檢約

2023年7月27日星期四

V40A – Query - 產生元件函式 - get_cmp_xxxx - 設定屬性 readOnly

目的: V40A – Query - 產生元件函式 - get_cmp_xxxx

處理步驟: 1>利用 myfunc.js 的 get_cmp 函式產生元件
2>尾碼1: 含欄位名稱尾碼0: 單純元件
– get_cmp_txt1, get_cmp_chkgrp1, get_cmp_dt1
- get_cmp_txt0, get_cmp_chk0 , get_cmp_dt0,

- get_cmp_lbl0, get_cmp_cal0, get_pick_btn0,

3>Runtime 設定元件屬性 - readOnly

cmp_EMPLYID.items[0].readOnly = true;

cmp_EMPLYID.items[0].fieldCls = "readonly";

4>Runtime 設定元件屬性 - 必填(required)

cmp_PITM.items[0].fieldCls = "required";

5>Runtime 設定欄位值

cmp_EMPLYID.items[0].value = loginInfo.id;

cmp_EMPLYID_.value = loginInfo.name;

1>V40A.js

// panel11

var cmp_AMMNO = get_cmp_txt1('AMM單號', 's_AMMNO', 80, 130);

var cmp_pick_AMMNO = get_pick_btn0('挑選AMM單號', 's_btn_AMMNO',

'../api/V40AAPI/get_s_AMMNOPick?isComplete=0',

['AMMNO'], ['s_AMMNO'], J_pickstore_s_AMMNO, J_pickcolumns_s_AMMNO);

cmp_AMMNO.items.push(cmp_pick_AMMNO);

// SAPNO

var cmp_SAPNO = get_cmp_txt1('工號', 's_SAPNO', 80, 130);

var cmp_WBSNO = get_cmp_txt1('WBS', 's_WBSNO', 80, 130);

var cmp_pick_WBSNO = get_pick_btn0('挑選WBS', 's_btn_WBSNO',

'../api/V40AAPI/get_s_WBSNOPick',

['WBSNO'], ['s_WBSNO'], J_pickstore_s_WBSNO, J_pickcolumns_s_WBSNO);

cmp_WBSNO.items.push(cmp_pick_WBSNO);

var cmp_PN = get_cmp_txt1('件號', 's_PN', 80, 130);

// panel12

var cmp_OGONOAF = get_cmp_txt1('拆檢提領編號', 's_OGONOAF', 100, 150);

var cmp_pick_OGONOAF = get_pick_btn0('挑選拆檢提領編號', 's_btn_OGONOAF',

'../api/V40AAPI/get_s_OGONOAFPick',

['OGONOAF'], ['s_OGONOAF'], J_pickstore_s_OGONOAF, J_pickcolumns_s_OGONOAF);

cmp_OGONOAF.items.push(cmp_pick_OGONOAF);

var cmp_NGONOAF = get_cmp_txt1('維修提領編號', 's_NGONOAF', 100, 150);

var cmp_pick_NGONOAF = get_pick_btn0('挑選維修提領編號', 's_btn_NGONOAF',

'../api/V40AAPI/get_s_NGONOAFPick',

['NGONOAF'], ['s_NGONOAF'], J_pickstore_s_NGONOAF, J_pickcolumns_s_NGONOAF);

cmp_NGONOAF.items.push(cmp_pick_NGONOAF);

var cmp_RPNOAF = get_cmp_txt1('拆檢交修編號', 's_RPNOAF', 100, 150);

var cmp_pick_RPNOAF = get_pick_btn0('挑選拆檢交修編號', 's_btn_RPNOAF',

'../api/V40AAPI/get_s_RPNOAFPick',

['RPNOAF'], ['s_RPNOAF'], J_pickstore_s_RPNOAF, J_pickcolumns_s_RPNOAF);

cmp_RPNOAF.items.push(cmp_pick_RPNOAF);

var cmp_MRPNOAF = get_cmp_txt1('維修交修編號', 's_MRPNOAF', 100, 150);

var cmp_pick_MRPNOAF = get_pick_btn0('挑選拆檢交修編號', 's_btn_MRPNOAF',

'../api/V40AAPI/get_s_MRPNOAFPick',

['MRPNOAF'], ['s_MRPNOAF'], J_pickstore_s_MRPNOAF, J_pickcolumns_s_MRPNOAF);

cmp_MRPNOAF.items.push(cmp_pick_MRPNOAF);

// panel13

var cmp_SAPMAN = get_cmp_txt1('發工人員', 's_SAPMAN', 100, 80);

var cmp_SAPMAN_ = get_cmp_cal0('s_SAPMAN_', 80);

var cmp_pick_SAPMAN = get_pick_btn0('挑選發工人員', 's_btn_SAPMAN',

'../api/V40AAPI/get_s_SAPMANPick',

['SAPMAN', 'EMPLYNM'], ['s_SAPMAN', 's_SAPMAN_'], J_pickstore_s_SAPMAN, J_pickcolumns_s_SAPMAN);

cmp_SAPMAN.items.push(cmp_SAPMAN_, cmp_pick_SAPMAN);

var cmp_FIXSN = get_cmp_txt1('維修件序號', 's_FIXSN', 100, 100);

var cmp_CREMPLYID = get_cmp_txt1('管制人員', 's_CREMPLYID', 100, 80);

var cmp_CREMPLYID_ =get_cmp_cal0('s_CREMPLYID_', 80);

var cmp_pick_CREMPLYID = get_pick_btn0('挑選管制人員', 's_btn_CREMPLYID',

'../api/V40AAPI/get_s_CREMPLYIDPick',

['CREMPLYID', 'EMPLYNM'], ['s_CREMPLYID', 's_CREMPLYID_'], J_pickstore_s_CREMPLYID, J_pickcolumns_s_CREMPLYID);

cmp_CREMPLYID.items.push(cmp_CREMPLYID_, cmp_pick_CREMPLYID);

var cmp_FACWC = get_cmp_txt1('承修工場', 's_FACWC', 100, 100);

var cmp_pick_FACWC = get_pick_btn0('挑選管制人員', 's_btn_FACWC',

'../api/V40AAPI/get_s_FACWCPick',

['FACWC'], ['s_FACWC'], J_pickstore_s_FACWC, J_pickcolumns_s_FACWC);

cmp_FACWC.items.push(cmp_pick_FACWC);

//panel14 checkboxgroup

var cmp_TYPEAF = get_cmp_chkgrp1('約別', 's_TYPEAF', 80);

var cmp_TYPEAF1 = get_cmp_chk0('拆檢約', 's_TYPEAF', 1);

var cmp_TYPEAF2 = get_cmp_chk0('維修約', 's_TYPEAF', 2);

cmp_TYPEAF.items.push(cmp_TYPEAF1, cmp_TYPEAF2);

//checkbox 設定 margin , 若無margin,則 '0 0 0 0'

var cmp_isSAPSTAT = get_cmp_chk0('顯示SAP單況', 's_isSAPSTAT',80, 'Y','0 0 0 50');

var cmp_SAPDT = get_cmp_dt1('發工日期', 's_SAPDT1', 80, 100);

var cmp_SAPDT_lbl = get_cmp_lbl0(" ~ ", 20);

var cmp_SAPDT2 = get_cmp_dt0('s_SAPDT2', 100);

cmp_SAPDT.items.push(cmp_SAPDT_lbl, cmp_SAPDT2);

//篩選條件畫面

var Query = new Ext.FormPanel({

id: 's_form',

layout: { type: 'hbox', align: 'stretch' },

fieldDefaults: { labelAlign: 'right' },

defaults: { margin: { top: 3 } },

items: [

{

xtype: 'panel', id: 'panel1', layout: { type: 'hbox', align: 'stretch' }, flex: 14, border: 0,

items: [

{

xtype: 'panel', id: 'panel11', layout: { type: 'vbox', align: 'stretch' }, flex: 25, border: 0,

items: [cmp_AMMNO, cmp_SAPNO, cmp_WBSNO, cmp_PN, ],

}, // end of panel11

{

xtype: 'panel', id: 'panel12', layout: { type: 'vbox', align: 'stretch' }, flex: 30, border: 0,

items: [cmp_OGONOAF, cmp_NGONOAF, cmp_RPNOAF, cmp_MRPNOAF,],

}, // end of panel12 , flex:16

{

xtype: 'panel', id: 'panel13', layout: { type: 'vbox', align: 'stretch' }, flex: 30, border: 0,

items: [cmp_SAPMAN, cmp_FIXSN, cmp_CREMPLYID, cmp_FACWC,],

}, // end of panel13 , flex:16

{

xtype: 'panel', id: 'panel14', layout: { type: 'vbox', align: 'stretch' }, flex: 30, border: 0,

items: [cmp_isSAPSTAT, cmp_TYPEAF, cmp_SAPDT],

}, // end of panel13 , flex:16

]

}, // end of panel1

{

//xtype: 'toolbar',

xtype: 'panel',

id: 'panel2',

layout: { type: 'vbox', align: 'right' },

flex: 1,

border: 0,

items: [

{

xtype: 'button',

id: 'btn_Show',

flex: 2,

border: 1,

text: '資料顯示',

iconCls: 'icon-search',

handler: function () {

// 更新 STP欄位值

var np = s_JSON('s_form'); //TMFunction.js, 組合form上的查詢條件為json參數傳遞

np["s_isSTATFM"] = Ext.getCmp('s_isSTATFM').getValue();

np["s_isMB1A"] = Ext.getCmp('s_isMB1A').getValue();

//console.log('1 gridstore: ', gridstore);

var gridstore = Ext.getCmp('grid_Single').store;

//console.log('2 gridstore: ', gridstore);

//gridstore.getProxy().url = '../api/V40AAPI/getGridData_M?par_paging=false';

gridstore.getProxy().url = '../api/V40AAPI/getGridData_M';

gridstore.getProxy().extraParams = np;　//分頁OK,篩選條件OK

//var Tmp_cnt = 0;

////資料 - 全部顯示

//gridstore.on('load', function () {

// console.log("onload gridstore.data.length:", gridstore.data.length);

// Ext.getCmp('grid_Single').store.pageSize = gridstore.data.length;

// console.log("Ext.getCmp(grid_ptb): ", Ext.getCmp('grid_ptb'));

// console.log(" 0 Ext.getCmp(grid_ptb).afterPageText: ", Ext.getCmp('grid_ptb').afterPageText);

// Ext.getCmp('grid_ptb').updateInfo();

// Tmp_cnt = Tmp_cnt + 1;

// if (Tmp_cnt<=1)

// Ext.getCmp('grid_ptb').moveLast();

//})

Ext.getCmp('grid_Single').reloadGridData();

//將目前挑選 arr 清空;

resetCbxArr();

resetCbxArr1();

//console.log("gridstore.getCount():", gridstore.getCount());

//if (gridstore.getCount() == 0) {

// mywarnalert("無符合條件的資料");

//}

}

}, // end of 顯示資料

{

xtype: 'button',

id: 'btn_clear',

flex: 2,

border: 1,

text: '清除條件',

iconCls: 'icon-clear',

handler: function () {

var f = Query.getForm();

f.reset();

}

}, // end of 清除條件

{ xtype: 'label', id: 'label151', flex: 2, border: 0, text: '', }, // end of label

] // end of items of [顯示資料][清除條件]

} // end of panel2 //顯示按鈕

] // end of items of Query

});

Ext.getCmp('grid_Single').addDocked({

dockedItems: [{

items: [Query]

}]

});

3>設定 readOnly 屬性

var cmp_EMPLYID = get_cmp_txt1('異動人員', 'sub_EMPLYID', 80, 100);
var cmp_EMPLYID_ = get_cmp_txt0( 'sub_EMPLYID_', 100);
cmp_EMPLYID.items.push(cmp_EMPLYID_);
//readOnly: true, fieldCls: "readonly"
cmp_EMPLYID.items[0].readOnly = true;
cmp_EMPLYID.items[0].fieldCls = "readonly";
cmp_EMPLYID.items[0].value = loginInfo.id;
cmp_EMPLYID_.value = loginInfo.name;

V40A - 元件id重覆, 畫面無法顯示 or 畫面顯示不正常 ,且無錯誤訊息 - id - 畫面

目的: V40A - 元件ID重覆, 畫面無法顯示 or 畫面顯示不正常 ,且無錯誤訊息

處理步驟: 1>檢核元件 id 是否重覆

1>*.js
var cmp_CREMPLYID = get_cmp_txt1('管制人員', 's_CREMPLYID', 100, 80);
var cmp_CREMPLYID_ =get_cmp_cal0('s_CREMPLYID_', 80);
var cmp_pick_CREMPLYID = get_pick_btn1('挑選管制人員', 's_btn_CREMPLYID',
'../api/V40AAPI/get_s_CREMPLYIDPick',
['CREMPLYID', 'EMPLYNM'], ['s_CREMPLYID', 's_CREMPLYID_'], J_pickstore_s_CREMPLYID, J_pickcolumns_s_CREMPLYID);
cmp_CREMPLYID.items.push(cmp_CREMPLYID_, cmp_pick_CREMPLYID);

var cmp_FACWC = get_cmp_txt1('承修工場', 's_FACWC', 100, 100);
var cmp_pick_FACWC = get_pick_btn1('挑選管制人員', 's_btn_FACWC',
'../api/V40AAPI/get_s_FACWCPick',
['FACWC'], ['s_FACWC'], J_pickstore_s_FACWC, J_pickcolumns_s_FACWC);
cmp_FACWC.items.push(cmp_CREMPLYID_,cmp_pick_FACWC);
//cmp_FACWC.items.push(cmp_pick_FACWC); // 正確 statement

--> 元件id(cmp_CREMPLYID_ ) 重覆

2023年7月25日星期二

V40A : 過濾目前畫面的 store 的資料 - SAP單況='ROFF' - filter - filterby

目的: V40A : 過濾目前畫面的 store 的資料 - SAP單況='ROFF'

處理說明： 1>利用 store.filter("FieldName", FieldValue);
過濾前先清空 filter Store.clearFilter(true);

2>filterby(fn());

               store.filterBy(function (rec){
                             if (rec.get('host') && rec.get('policyDetails')) {
                                  // do something
                                  return true;
                             }
                             return false;
                        });

訂閱：文章 (Atom)

2023年7月31日星期一

V40A – [過濾資料]鈕 – 不分頁, 顯示在同一頁 -T1C– 取得 SQL全部資料後, 過濾資料, 再顯示在同一頁 - 重設總筆數

2023年7月30日星期日

V120202C -[撿料完成]– 簡單子畫面 – 一般欄位(Form) - readonly

V40A - checkbox 及 checkboxGroup 的用法

2023年7月27日星期四

V40A – Query - 產生元件函式 - get_cmp_xxxx - 設定屬性 readOnly

V40A - 元件id重覆, 畫面無法顯示 or 畫面顯示不正常 ,且無錯誤訊息 - id - 畫面

2023年7月25日星期二

V40A : 過濾目前畫面的 store 的資料 - SAP單況='ROFF' - filter - filterby

WebDesign 心得綜整

追蹤者

網誌存檔

關於我自己

2023年7月31日 星期一

V40A – [過濾資料]鈕 – 不分頁, 顯示在同一頁 -T1C– 取得 SQL全部資料後, 過濾資料, 再顯示在同一頁 - 重設總筆數

2023年7月30日 星期日

V120202C -[撿料完成]– 簡單子畫面 – 一般欄位(Form) - readonly

V40A - checkbox 及 checkboxGroup 的用法

2023年7月27日 星期四

V40A – Query - 產生元件函式 - get_cmp_xxxx - 設定屬性 readOnly

V40A - 元件id重覆, 畫面無法顯示 or 畫面顯示不正常 ,且無錯誤訊息 - id - 畫面

2023年7月25日 星期二

V40A : 過濾目前畫面的 store 的資料 - SAP單況='ROFF' - filter - filterby

WebDesign 心得綜整

追蹤者

網誌存檔

關於我自己

2023年7月31日星期一

2023年7月30日星期日

2023年7月27日星期四

2023年7月25日星期二