//conn->rx->parsedUri->host
static void getDevinfo(HttpConn *conn) {
if(session("isAuthed") != NULL){
if (strcmp(session("isAuthed"),"true") != 0) {
render("login.esp");
return;
}
}else{
render("login.esp");
return;
}
char pProg[256] = {0};
int r = 0;
EdiField *src;
getbaseJson(tmpip, pProg);
render(pProg);
//delete optlog 7days ago
Edi *db = ediOpen("db/muxnms.mdb", "mdb", EDI_AUTO_SAVE);
time_t curTime;
time(&curTime);
EdiGrid *opts = ediReadTable(db, "optlog");
if(opts != NULL){
for (r = 0; r < opts->nrecords; r++) {
src = opts->records[r]->fields;
src += 4;
if(atoi(src->value) < (curTime - 7*24*3600)){
ediRemoveRec(db, "optlog", opts->records[r]->id);
}
}
}
}
static void getoptlogs() {
char str[16] = {0};
int len = 0;
cchar *role = getSessionVar("role");
if(role == NULL){
rendersts(str, 9);
render(str);
return;
}
if((strcmp(role, "root") !=0) && (strcmp(role, "admin") !=0)){
rendersts(str, 5);//无权限
render(str);
return;
}
//find optlog
Edi *db = ediOpen("db/muxnms.mdb", "mdb", EDI_AUTO_SAVE);
// //删除7天前的日志
time_t curTime;
time(&curTime);
//EdiGrid *oldlogs = ediReadWhere(db, "optlog", "logtime", "<", curTime - 7*24*3600);
EdiGrid *oldlogs = ediReadTable(db, "optlog");
//printf("========logs========>>>%s\n", ediGridAsJson(oldlogs, MPR_JSON_PRETTY));
for(len=0; len < oldlogs->nrecords; len++){
EdiRec *log = oldlogs->records[len];
if(atoi(mprGetJson(mprParseJson(ediRecAsJson(log, MPR_JSON_PRETTY)), "logtime")) < (curTime - 7*24*3600)){
ediRemoveRec(db, "optlog", log->id);
}
}
EdiGrid *logs = ediReadTable(db, "optlog");
render(ediGridAsJson(logs, MPR_JSON_PRETTY));
}
PUBLIC bool removeRec(cchar *tableName, cchar *key)
{
if (ediRemoveRec(getDatabase(), tableName, key) < 0) {
feedback("error", "Cannot delete %s", stitle(tableName));
return 0;
}
feedback("info", "Deleted %s", stitle(tableName));
return 1;
}
