X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fpeertrustpage.cpp;h=667595d126c42572369f84445588ad9ff73e2554;hp=4a451ed2dd37bf469fafe7ac05bfab8b1c88615c;hb=52c0819bfc1d083c6e0738f75f0d7eeba521295a;hpb=37a8d59548287dcad78ef00e7b18058721eb9935 diff --git a/src/http/pages/peertrustpage.cpp b/src/http/pages/peertrustpage.cpp index 4a451ed..667595d 100644 --- a/src/http/pages/peertrustpage.cpp +++ b/src/http/pages/peertrustpage.cpp @@ -5,6 +5,48 @@ #include #endif +const std::string PeerTrustPage::BuildQueryString(const long startrow, const std::string &namesearch, const std::string &sortby, const std::string &sortorder) +{ + std::string returnval=""; + std::string tempval=""; + + if(startrow>=0) + { + StringFunctions::Convert(startrow,tempval); + returnval+="startrow="+tempval; + } + + if(namesearch!="") + { + if(returnval!="") + { + returnval+="&"; + } + returnval+="namesearch="+namesearch; + } + + if(sortby!="") + { + if(returnval!="") + { + returnval+="&"; + } + returnval+="sortby="+sortby; + } + + if(sortorder!="") + { + if(returnval!="") + { + returnval+="&"; + } + returnval+="sortorder="+sortorder; + } + + return returnval; + +} + const std::string PeerTrustPage::GeneratePage(const std::string &method, const std::map &queryvars) { int count=0; @@ -15,6 +57,10 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s std::string rowsperpagestr; int startrow=0; std::string startrowstr="0"; + std::string namesearch=""; + std::string sql; + std::string sortby=""; + std::string sortorder=""; StringFunctions::Convert(rowsperpage,rowsperpagestr); @@ -68,20 +114,90 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s StringFunctions::Convert(startrow,startrowstr); } + // sort by + if(queryvars.find("sortby")!=queryvars.end()) + { + sortby=(*queryvars.find("sortby")).second; + } + else + { + sortby="Name"; + } + + // sort order + if(queryvars.find("sortorder")!=queryvars.end()) + { + sortorder=(*queryvars.find("sortorder")).second; + } + else + { + sortorder="ASC"; + } + + // if we are searching by name + if(queryvars.find("namesearch")!=queryvars.end()) + { + namesearch=(*queryvars.find("namesearch")).second; + } + content+="

Peer Trust

"; - content+="Message Trust is how much you trust the identity to post good messages. Trust List Trust is how much weight you want the trust list of that identity to have when calculating the total. The local trust levels are set by you, and the peer trust levels are calculated by a weighted average using other identities trust lists."; + content+="Message Trust is how much you trust the identity to post good messages. Trust List Trust is how much weight you want the trust list of that identity to have when calculating the total. The local trust levels are set by you, and the peer trust levels are calculated by a weighted average using other identities' trust lists."; + content+="
"; + content+="
"; + content+=""; + content+=""; + content+="
"; + content+="
"; content+="
"; content+=""; content+=""; content+=""; - content+=""; + content+=""; + content+=""; + content+=""; + content+=""; + content+=""; - SQLite3DB::Statement st=m_db->Prepare("SELECT COUNT(*) FROM tblIdentity;"); + // get count of identities we are showing + sql="SELECT COUNT(*) FROM tblIdentity"; + if(namesearch!="") + { + sql+=" WHERE Name LIKE '%' || ? || '%'"; + } + sql+=";"; + SQLite3DB::Statement st=m_db->Prepare(sql); + if(namesearch!="") + { + st.Bind(0,namesearch); + } st.Step(); st.ResultInt(0,identitycount); st.Finalize(); - st=m_db->Prepare("SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";"); + sql="SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity"; + if(namesearch!="") + { + sql+=" WHERE Name LIKE '%' || ? || '%'"; + } + sql+=" ORDER BY"; + if(sortby=="Name") + { + sql+=" Name COLLATE NOCASE"; + } + else + { + sql+=" "+sortby; + } + if(sortorder!="") + { + sql+=" "+sortorder; + } + sql+=" LIMIT "+startrowstr+","+rowsperpagestr+";"; + st=m_db->Prepare(sql); + if(namesearch!="") + { + st.Bind(0,namesearch); + } st.Step(); while(st.RowReturned()) @@ -93,6 +209,7 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s std::string localtrustlisttrust; std::string peertrustlisttrust; std::string publickey; + std::string keypart=""; StringFunctions::Convert(count,countstr); @@ -104,17 +221,24 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s st.ResultText(5,peertrustlisttrust); st.ResultText(6,publickey); + if(publickey.size()>8) + { + keypart=publickey.substr(3,5); + } + content+=""; content+=""; content+=""; + content+=""; cols+=2; } if(startrow+rowsperpageNext Page -->"; + content+=""; } content+=""; } @@ -183,6 +305,25 @@ const std::string PeerTrustPage::GetClassString(const std::string &trustlevel) } } +const std::string PeerTrustPage::ReverseSort(const std::string &sortname, const std::string ¤tsortby, const std::string ¤tsortorder) +{ + if(sortname==currentsortby) + { + if(currentsortorder=="ASC") + { + return "DESC"; + } + else + { + return "ASC"; + } + } + else + { + return currentsortorder; + } +} + const bool PeerTrustPage::WillHandleURI(const std::string &uri) { if(uri.find("peertrust.")!=std::string::npos)
NameLocal Message TrustPeer Message TrustLocal Trust List TrustPeer Trust List Trust
NameLocal Message TrustPeer Message TrustLocal Trust List TrustPeer Trust List Trust
"; content+=""; + content+=""; if(name!="") { - content+=name; + content+=SanitizeOutput(name+keypart)+"..."; } else { content+="[Unknown Name]"; } + content+=""; content+=""; content+=""; @@ -133,7 +257,6 @@ const std::string PeerTrustPage::GeneratePage(const std::string &method, const s if(startrow>0 || startrow+rowsperpage0) { StringFunctions::Convert(startrow-rowsperpage,tempstr); - content+="<-- Previous Page<-- Previous PageNext Page -->