// ****************************************************************** // Filename - admin.html // Shortname - // Purpose - This file displays the administration main menu // Copyright - (C) 1996, Ingenia Communications Corporation // Authors - Kjell Wooding // - Chris Grant // Contact - kwooding@ingenia.com // ****************************************************************** CM_Authorize(); 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"); updateURL=addClient("admin.html?update=1"); // Handlers if (request.update) { var ONEWEEK = 1000 * 60 * 60 * 24 * 7; var dtLastWeek = new Date(); dtLastWeek.setHours(0); dtLastWeek.setMinutes(0); dtLastWeek.setSeconds(0); dtLastWeek.setTime(dtLastWeek.getTime() - ONEWEEK); CM_Connect(); var strSQL = "SELECT COUNT(*) AS Deleted "; strSQL += "FROM Meeting "; strSQL += "WHERE Meeting_Date < '" + CM_InformixDateFormat(dtLastWeek) + "'"; var csResult = database.cursor(strSQL); csResult.next(); var intDeleted = csResult.Deleted; csResult.close(); strSQL = "DELETE FROM Meeting "; strSQL += "WHERE Meeting_Date < '" + CM_InformixDateFormat(dtLastWeek) + "'"; database.execute(strSQL); strSQL = "DELETE FROM Meeting_Attendance "; strSQL += "WHERE Meeting_Date < '" + CM_InformixDateFormat(dtLastWeek) + "'"; database.execute(strSQL); strSQL = "DELETE FROM Room_Bookings "; strSQL += "WHERE Booking_Day < '" + CM_InformixDateFormat(dtLastWeek) + "'"; database.execute(strSQL); CM_Disconnect(); var strClientTxt = "\n"; write(strClientTxt); } iMeet 管理作業

iMeet 管理作業

[ Buildings ] 大樓資料維護作業
[ Employees ] 員工資料維護作業
[ Inventory ] 設備財產維護作業
[ Rooms ] 會議室資料維護作業
 [ Delete ] 取消原會議室預訂資料
 [ 結束 iMeet 作業 ] 結束 iMeet 作業

Copyright © 1996, 精業股份有限公司