From 7fe8cea615b518c71817bc06b1bc3880ad319e4b Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Wed, 7 Sep 2011 21:19:03 +0000 Subject: Cleaned up javascript and used ajax for select action --- weblog-model.lua | 26 -------------------------- 1 file changed, 26 deletions(-) (limited to 'weblog-model.lua') diff --git a/weblog-model.lua b/weblog-model.lua index 6f440d3..87c070d 100644 --- a/weblog-model.lua +++ b/weblog-model.lua @@ -1193,32 +1193,6 @@ local handleparameters = function(activelog, clientuserid, starttime, endtime, c return result end -function getselected(csvdata) - local result = {} - result.id = cfe({ value=csvdata or "", label="Record ID", descr="Id of Record"}) - result.log = cfe({ type="list", value={}, label="Weblog Access Log" }) - local res, err = pcall(function() - databaseconnect(DatabaseUser) - local entries = {} - -- retrieve a cursor - local sql = "SELECT * FROM pubweblog where selected = true and logdatetime >= '" .. starttime .. "' and logdatetime <= '" .. endtime .. "'" - local idcnt = 0 - sql = sql .. " ORDER BY logdatetime;" - cur = assert (con:execute(sql)) - row = cur:fetch ({}, "a") - while row do - entries[#entries+1] = {sourcename=row.sourcename, clientip=row.clientip, clientuserid=row.clientuserid, logdatetime=row.logdatetime, uri=row.uri, shorturi=shorturi, bytes=row.bytes, reason=row.reason, core=row.score, shortreason=row.shortreason, badyesno=row.badyesno, deniedyesno=row.deniedyesno, bypassyesno=row.bypassyesno, wordloc=row.wordloc, selected=row.selected } - row = cur:fetch (row, "a") - end - -- close everything - cur:close() - result.log.value = entries or {} - --result.log.value = sql - databasedisconnect() - end) - return cfe({ type="group", value=result, errtxt=err, label="Weblog Selected" }) -end - function editselected(chkdata) keycnt = 0 sql = "UPDATE pubweblog SET selected = " -- cgit v1.2.3