mirror of
https://github.com/uroni/urbackup_backend.git
synced 2025-10-26 11:36:50 +00:00
260 lines
7.2 KiB
C++
260 lines
7.2 KiB
C++
/*************************************************************************
|
|
* UrBackup - Client/Server backup system
|
|
* Copyright (C) 2011-2016 Martin Raiber
|
|
*
|
|
* This program is free software: you can redistribute it and/or modify
|
|
* it under the terms of the GNU Affero General Public License as published by
|
|
* the Free Software Foundation, either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU Affero General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License
|
|
* along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
**************************************************************************/
|
|
|
|
#ifndef CLIENT_ONLY
|
|
|
|
#include "action_header.h"
|
|
#include "../../urbackupcommon/os_functions.h"
|
|
#include "../../urlplugin/IUrlFactory.h"
|
|
#include "backups.h"
|
|
|
|
extern IUrlFactory *url_fak;
|
|
|
|
ACTION_IMPL(logs)
|
|
{
|
|
Helper helper(tid, &POST, &PARAMS);
|
|
JSON::Object ret;
|
|
SUser *session=helper.getSession();
|
|
if(session!=NULL && session->id==SESSION_ID_INVALID) return;
|
|
std::string filter=POST["filter"];
|
|
std::string s_logid=POST["logid"];
|
|
int logid=watoi(s_logid);
|
|
std::string rights=helper.getRights("logs");
|
|
std::vector<int> clientid;
|
|
if(rights!="all" && rights!="none" )
|
|
{
|
|
std::vector<std::string> s_clientid;
|
|
Tokenize(rights, s_clientid, ",");
|
|
for(size_t i=0;i<s_clientid.size();++i)
|
|
{
|
|
clientid.push_back(atoi(s_clientid[i].c_str()));
|
|
}
|
|
}
|
|
if(clientid.size()>0 && filter.empty() )
|
|
{
|
|
for(size_t i=0;i<clientid.size();++i)
|
|
{
|
|
filter+=convert(clientid[i]);
|
|
if(i+1<clientid.size())
|
|
filter+=",";
|
|
}
|
|
}
|
|
std::vector<int> v_filter;
|
|
if(!filter.empty())
|
|
{
|
|
std::vector<std::string> s_filter;
|
|
Tokenize(filter, s_filter, ",");
|
|
for(size_t i=0;i<s_filter.size();++i)
|
|
{
|
|
v_filter.push_back(watoi(s_filter[i]));
|
|
}
|
|
}
|
|
if(session!=NULL && rights!="none")
|
|
{
|
|
IDatabase *db=helper.getDatabase();
|
|
std::string qstr="SELECT c.id AS id, c.name AS name FROM clients c WHERE ";
|
|
if(!clientid.empty()) qstr+=backupaccess::constructFilter(clientid, "c.id")+" AND ";
|
|
qstr+=" EXISTS (SELECT id FROM logs l WHERE l.clientid=c.id LIMIT 1) ORDER BY name";
|
|
|
|
IQuery *q_clients=db->Prepare(qstr);
|
|
db_results res=q_clients->Read();
|
|
q_clients->Reset();
|
|
JSON::Array clients;
|
|
for(size_t i=0;i<res.size();++i)
|
|
{
|
|
JSON::Object obj;
|
|
obj.set("id", watoi(res[i]["id"]));
|
|
obj.set("name", res[i]["name"]);
|
|
clients.add(obj);
|
|
}
|
|
if(clientid.empty())
|
|
{
|
|
ret.set("all_clients", JSON::Value(true));
|
|
}
|
|
ret.set("clients", clients);
|
|
ret.set("has_user", session->id!=SESSION_ID_TOKEN_AUTH && session->id!=SESSION_ID_ADMIN);
|
|
|
|
IQuery *q_log_right_clients=db->Prepare("SELECT id, name FROM clients"+(clientid.empty()?""
|
|
:" WHERE "+backupaccess::constructFilter(clientid, "id"))+" ORDER BY name");
|
|
|
|
res=q_log_right_clients->Read();
|
|
q_log_right_clients->Reset();
|
|
JSON::Array log_right_clients;
|
|
for(size_t i=0;i<res.size();++i)
|
|
{
|
|
JSON::Object obj;
|
|
obj.set("id", watoi(res[i]["id"]));
|
|
obj.set("name", res[i]["name"]);
|
|
log_right_clients.add(obj);
|
|
}
|
|
ret.set("log_right_clients", log_right_clients);
|
|
|
|
ret.set("filter", filter);
|
|
if(s_logid.empty())
|
|
{
|
|
std::string s_ll=POST["ll"];
|
|
int ll=2;
|
|
if(!s_ll.empty())
|
|
{
|
|
ll=watoi(s_ll);
|
|
}
|
|
std::string bed;
|
|
if(ll==2)
|
|
{
|
|
bed="l.errors>0";
|
|
}
|
|
else if(ll==1)
|
|
{
|
|
bed="(l.warnings>0 OR l.errors>0)";
|
|
}
|
|
qstr="SELECT l.id AS id, c.name AS name, strftime('"+helper.getTimeFormatString()+"', l.created) AS time, l.errors AS errors, l.warnings AS warnings, "
|
|
"l.image AS image, l.incremental AS incremental, l.resumed AS resumed, l.restore AS restore FROM logs l INNER JOIN clients c ON l.clientid=c.id";
|
|
|
|
if(!v_filter.empty())
|
|
{
|
|
qstr+=" WHERE "+backupaccess::constructFilter(v_filter, "l.clientid");
|
|
if(!bed.empty())
|
|
{
|
|
qstr+=" AND "+bed;
|
|
}
|
|
}
|
|
else if(!bed.empty()) qstr+=" WHERE "+bed;
|
|
|
|
qstr+=" ORDER BY l.created DESC LIMIT 50";
|
|
IQuery *q=db->Prepare(qstr);
|
|
res=q->Read();
|
|
q->Reset();
|
|
JSON::Array logs;
|
|
for(size_t i=0;i<res.size();++i)
|
|
{
|
|
JSON::Object obj;
|
|
obj.set("name", res[i]["name"]);
|
|
obj.set("id", watoi(res[i]["id"]));
|
|
obj.set("time", watoi64(res[i]["time"]));
|
|
obj.set("errors", watoi(res[i]["errors"]));
|
|
obj.set("warnings", watoi(res[i]["warnings"]));
|
|
obj.set("image", watoi(res[i]["image"]));
|
|
obj.set("incremental", watoi(res[i]["incremental"]));
|
|
obj.set("resumed", watoi(res[i]["resumed"]));
|
|
obj.set("restore", watoi(res[i]["restore"]));
|
|
logs.add(obj);
|
|
}
|
|
ret.set("logs", logs);
|
|
ret.set("ll", ll);
|
|
|
|
if(POST.find("report_mail")!=POST.end())
|
|
{
|
|
IQuery *q=db->Prepare("UPDATE settings_db.si_users SET report_mail=?, report_loglevel=? WHERE id=?");
|
|
q->Bind(POST["report_mail"]);
|
|
q->Bind(watoi(POST["report_loglevel"]));
|
|
q->Bind(session->id);
|
|
q->Write();
|
|
q->Reset();
|
|
}
|
|
|
|
if(POST.find("report_mail")!=POST.end())
|
|
{
|
|
IQuery *q=db->Prepare("UPDATE settings_db.si_users SET report_mail=?, report_loglevel=?, report_sendonly=? WHERE id=?");
|
|
q->Bind(POST["report_mail"]);
|
|
q->Bind(watoi(POST["report_loglevel"]));
|
|
q->Bind(watoi(POST["report_sendonly"]));
|
|
q->Bind(session->id);
|
|
q->Write();
|
|
ret.set("saved_ok", true);
|
|
}
|
|
|
|
IQuery *mq=db->Prepare("SELECT report_mail, report_loglevel, report_sendonly FROM settings_db.si_users WHERE id=? AND report_mail IS NOT NULL");
|
|
mq->Bind(session->id);
|
|
res=mq->Read();
|
|
mq->Reset();
|
|
|
|
if(!res.empty())
|
|
{
|
|
ret.set("report_mail", res[0]["report_mail"]);
|
|
ret.set("report_loglevel", watoi(res[0]["report_loglevel"]));
|
|
ret.set("report_sendonly", watoi(res[0]["report_sendonly"]));
|
|
}
|
|
else
|
|
{
|
|
ret.set("report_mail", "");
|
|
ret.set("report_sendonly", "");
|
|
ret.set("report_loglevel", "");
|
|
}
|
|
|
|
if(url_fak!=NULL)
|
|
{
|
|
ret.set("HAS_MAIL_START", "");
|
|
ret.set("HAS_MAIL_STOP", "");
|
|
}
|
|
else
|
|
{
|
|
ret.set("HAS_MAIL_START", "<!--");
|
|
ret.set("HAS_MAIL_STOP", "-->");
|
|
}
|
|
|
|
if (helper.getRights(RIGHT_REPORT_SCRIPT) == RIGHT_ALL)
|
|
{
|
|
ret.set("can_report_script_edit", true);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
IQuery *q=db->Prepare("SELECT l.clientid AS clientid, ld.data AS logdata, strftime('"+helper.getTimeFormatString()+"', l.created) AS time, c.name AS name "
|
|
"FROM ((logs l INNER JOIN log_data ld ON l.id=ld.logid) INNER JOIN clients c ON l.clientid=c.id) WHERE l.id=?");
|
|
q->Bind(logid);
|
|
db_results res=q->Read();
|
|
q->Reset();
|
|
|
|
if(!res.empty())
|
|
{
|
|
bool ok=true;
|
|
if(!clientid.empty())
|
|
{
|
|
ok=false;
|
|
int t_clientid=watoi(res[0]["clientid"]);
|
|
for(size_t i=0;i<clientid.size();++i)
|
|
{
|
|
if(clientid[i]==t_clientid)
|
|
{
|
|
ok=true;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
if(ok)
|
|
{
|
|
JSON::Object log;
|
|
log.set("data", res[0]["logdata"]);
|
|
log.set("time", watoi64(res[0]["time"]));
|
|
log.set("clientname", res[0]["name"]);
|
|
ret.set("log", log);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
ret.set("error", 1);
|
|
}
|
|
|
|
helper.Write(ret.stringify(false));
|
|
}
|
|
|
|
#endif //CLIENT_ONLY
|