// ******************************************************************
// Filename - admn_inv.html
// Shortname - IV
// Purpose - This code edits Inventory information
// Copyright - (C) 1996, Ingenia Communications Corporation
// Authors - Kjell Wooding
// - Chris Grant
// Contact - kwooding@ingenia.com
// ******************************************************************
CM_Authorize();
IF_VerifyRoutines();
empURL=addClient("admn_emp.html");
roomURL=addClient("admn_rm.html");
buildURL=addClient("admn_bdg.html");
invURL=addClient("admn_inv.html");
mapURL=addClient("admn_map.html");
quitURL=addClient("login.html?logout=1");
mainURL=addClient("admin.html");
iMeet 會議室預訂系統 - 設備財產管理作業
function IV_InvSelectOpts(invid, select) {
CM_Connect();
if (invid) { // Show currently selected inventory first
stmt="SELECT * from Inventory, Equipment"+
" WHERE Inventory_ID="+invid+
" AND Inventory.Equipment_Lookup = Equipment.Equipment_Lookup";
csSelInv=database.cursor(stmt);
if (!csSelInv.next()) {
debug("ERROR: IV_Inventory passed invalid invid:"+invid);
} else {
write("
所屬設備類別
產品描述
放置位置
");
write("
");
write(aeCancel);
write("
");
write ("");
}
function IV_DBInvEdit(invid) {
insert=0;
if (!invid) {
invid=CM_GetNextPriKey("Inventory","Inventory_ID");
insert=1;
}
CM_Connect();
csEdit=database.cursor("select * from Inventory WHERE Inventory_ID="+invid,
true);
csEdit.next();
csEdit.Inventory_ID=invid;
csEdit.Item_Description=request.InvDesc;
csEdit.Equipment_Lookup=request.EquipType;
csEdit.Room_ID=request.RoomID;
if (insert) {
csEdit.insertRow("Inventory");
} else {
csEdit.updateRow("Inventory");
}
csEdit.close();
CM_Disconnect();
IV_Inventory(invid);
}
// Handlers
if (request.doInventory) {
if (request.invid) {
IV_Inventory(request.invid,true);
} else {
IV_Inventory(null,true);
}
} else if (request.doInvNew) {
IV_InvEdit(null);
} else if (request.doDBInvNew) {
IV_DBInvEdit(null);
} else if (request.doInvEdit) {
IV_InvEdit(request.invid);
} else if (request.doDBInvEdit) {
IV_DBInvEdit(request.invid);
} else if (request.doInvDel) {
IV_DBInvDel(request.invid);
} else if (request.doEquip) {
strEquipRef = "admn_eq.html?intOldInvID=" + request.intOldInvID +
"&strEditButton=" + request.strEditButton +
"&strNewButton=" + request.strNewButton;
redirect(addClient(strEquipRef));
}
else if (request.doDone) {
redirect(addClient("admin.html"));
}
else { // default
IV_Inventory(null,true);
}