本文示範如何以 os3grid 元件,搭配 Ajax,實作一個網頁版的薪資錄入界面。
先加入以下程式碼,用來計算字串長度(把中文字元當成兩個字寬),以修正中文顯示:
function strlen(str)
{
var len;
var i;
len = 0;
for (i=0;i<str.length;i++)
{
if (str.charCodeAt(i)>255) len+=2; else len++;
}
return len;
}
接著在 function grid_cell_txt_edit ( cell ) 裡修改以下一行,主要用來應付中文寬度:
s += ' size="'+ strlen(val) + '" ';
另外可微調顏色設定,例如:this.cols = { "hover" : "#d5f1ff", ...
考量到每個單位都有不同的帳套,因此以一對多建立帳套與薪資項目表:
CREATE TABLE pq_unitgzxm (
unit_id char(8) NOT NULL DEFAULT '',
xmbh int NOT NULL DEFAULT 0,
xmbm varchar(3) NOT NULL PRIMARY KEY,
xmmc varchar(200) NOT NULL DEFAULT '',
lx varchar(200) NOT NULL DEFAULT '',
JSgs varchar(200) NOT NULL DEFAULT ''
);
實際薪資錄入採用空間冗餘的辦法,用 gzdata1~gzdata20 等欄位儲存各薪資項目的值:
CREATE TABLE pq_gzxm (
gzb_id char(8) NOT NULL DEFAULT '',
employee_id char(8) NOT NULL DEFAULT '',
xm varchar(400) NOT NULL DEFAULT '',
employeecontract_id char(8) NOT NULL DEFAULT '',
gzdata1 decimal NOT NULL DEFAULT '0',
...
gzdata20 decimal NOT NULL DEFAULT '0'
);
後端以 PHP 函式 show_form() 依帳號與年月取出薪資項目與員工資料,組裝成 gz_array 傳給模板:
function show_form($unit_id = '', $gzyear ='', $gzmonth='',$error = '') {
global $db, $me, $t,$_POST;
extract($_POST);
if ($unit_id && !$error) {
$rs = $db->Execute("select * from ".TBL_UNITGZXM." where unit_id = '$unit_id'");
$items = $rs->GetArray();
$t->assign('items', $items);
$gzb = $db->GetRow("select gzb_id,dwmc from ".TBL_GZB." where unit_id = '$unit_id' and gzyear='2006' and gzmonth='04'");
$gzb_id = $gzb['gzb_id'];
$dwmc = $gzb['dwmc'];
$gz_array = array();
$rs = $db->Execute("select * from ".TBL_GZXM." where gzb_id = '$gzb_id'");
while (!$rs->EOF) {
$gzdata_array = array();
for ($i = 1, $count = count($items)-3; $i <= $count; $i++) {
array_push($gzdata_array, $rs->fields['gzdata'.$i]);
}
$gzline = array($rs->fields['employee_id'],$rs->fields['xm'],$dwmc,$gzdata_array);
array_push($gz_array, $gzline);
$rs->MoveNext();
}
} else { $t->assign($_POST); }
$t->assign('error', $error);
$t->assign('gz_array', $gz_array);
$t->render('salary.html', PAGE_TITLE,'wrap.Html',False);
}
表單模板中,get_data() 函式把錄入的資料組裝成 XML,再透過 Ajax 回傳伺服器;row_modifIEd() 則在使用者修改儲存格時標記該列為已變更:
function get_data ( g )
{
var objDom = new ActiveXObject("MSXML.DOMDocument"); //定義 DOM 物件
objDom.async=false;
var objRoot = objDom.createElement("SALARY"); //建立根節點
objDom.appendChild(objRoot);
var l = g.length ();
var t, data, s = "", i, v;
for ( t = 0; t < l; t ++ )
{
var objFIEld = objDom.createElement("Item");
objDom.documentElement.appendChild(objFIEld);
curnode=objDom.documentElement.lastChild;
data = g.get_row ( t );
for ( i = 3; i < data.length; i ++ ) {
var gzdata = objDom.createElement("gzdata"+(i-2));
gzdata.text=data [ i ];
curnode.appendChild(gzdata);
}
}
post_data = "op=savesalary&salarydata=" + escape(objDom.XML);
var returnstuff = http_fetch_sync('salary.PHP',post_data);
if(returnstuff['responseText'].indexOf("ok")!=-1)
{
alert("保存成功!");
}
}
function row_modifIEd ( grid, cell_pos, row_num, new_val )
{
var attrs = grid.get_row_attrs ( row_num );
attrs [ 'changed' ] = 'YES';
}
接著建立 OS3Grid 實例,設定標題(由 PHP 動態產生欄位名稱)、邊框、可編輯欄位、滑鼠高亮等屬性,再把 gz_array 的每一列透過 g.add_row() 加入表格,最後呼叫 g.render('grid') 完成渲染。
這個函式負責同步送出請求並回傳 responseText 與 responseXML:
var global_xmlhttp = getXMLHTTPinstance();
function http_fetch_sync(url,post_data)
{
global_xmlhttp = getXMLHTTPinstance();
var method = 'GET';
if ( typeof(post_data) != 'undefined' )
{ method = 'POST'; }
try
{ global_XMLhttp.open(method, url,false); }
catch(e)
{ alert('message:'+e.message+":url:"+url); }
if ( method == 'POST')
{ global_XMLhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded'); }
global_XMLhttp.send(post_data);
var args = {"responseText":global_xmlhttp.responseText,"responseXML":global_xmlhttp.responseXML,"request_id":request_id};
return args;
}