1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
#include "FbBookMenu.h"
#include "FbMenu.h"
#include "FbConst.h"
#include "FbString.h"
#include "FbDatabase.h"
#include "FbBookEvent.h"
#include "FbMasterInfo.h"
#include "FbMasterTypes.h"
#include "models/FbBookList.h"
#include "models/FbBookTree.h"
FbBookMenu::FbBookMenu(FbModelItem item, int book)
: m_auth(0), m_seqn(0), m_book(book)
{
if (book) return;
FbAuthParentData * auth = wxDynamicCast(&item, FbAuthParentData);
if (auth) {
m_auth = auth->GetCode();
FbSeqnParentData * seqn = wxDynamicCast(&item.GetParent(), FbSeqnParentData);
if (seqn) m_seqn = seqn->GetCode();
return;
}
FbSeqnParentData * seqn = wxDynamicCast(&item, FbSeqnParentData);
if (seqn) {
m_seqn = seqn->GetCode();
FbAuthParentData * auth = wxDynamicCast(&item.GetParent(), FbAuthParentData);
if (auth) m_auth = auth->GetCode();
return;
}
}
void FbBookMenu::Init(const FbMasterInfo &master, bool bShowOrder)
{
Append(ID_OPEN_BOOK, _("Open book") + (wxString)wxT("\tEnter"));
FbMasterDownInfo * down = wxDynamicCast(&master, FbMasterDownInfo);
if (down) {
Append(ID_DELETE_DOWNLOAD, _("Delete download query"));
if (down->GetId()) Append(ID_DOWNLOAD_BOOK, _("Retry download"));
} else {
Append(ID_DOWNLOAD_BOOK, _("Download a file"));
}
if ( m_book > 0 ) Append(ID_SYSTEM_DOWNLOAD, _("Download via browser"));
if ( m_book > 0 ) Append(ID_BOOK_PAGE, _("Online books page"));
AppendSeparator();
AppendImg(wxID_COPY, _("Copy") + (wxString)wxT("\tCtrl+C"), wxART_COPY);
Append(ID_COPY_URL, _("Copy URL"));
Append(wxID_SELECTALL, _("Select all") + (wxString)wxT("\tCtrl+A"));
Append(ID_UNSELECTALL, _("Undo selection"));
Append(ID_SHOW_COLUMNS, _("Table columns"));
AppendSeparator();
AppendImg(wxID_DELETE, _("Delete book"), wxART_DELETE);
AppendSeparator();
if (bShowOrder) Append(wxID_ANY, _("Sort by"), new FbMenuSort);
Append(ID_FILTER_SET, _("Filter setup..."));
AppendCheckItem(ID_FILTER_USE, _("Use filter"));
AppendCheckItem(ID_FILTER_DEL, _("Show deleted"));
AppendSeparator();
AppendAuth();
AppendSeqn();
AppendSeparator();
FbMasterFldrInfo * info = wxDynamicCast(&master, FbMasterFldrInfo);
int folder = info ? info->GetId() : 0;
if (!info || folder) Append(ID_FAVORITES_ADD, _("Add to favourites"));
AppendFldr(folder);
Append(wxID_ANY, _("Rate this book"), new FbMenuRating);
if (info) Append(ID_FAVORITES_DEL, _("Delete bookmark"));
AppendSeparator();
Append(ID_EDIT_COMMENTS, _("Add comments"));
Append(wxID_PROPERTIES, _("Properties"));
}
void FbBookMenu::AppendAuth()
{
wxString text = _("Jump to author");
FbMenu * submenu = NULL;
wxString sql = fbT("SELECT id, full_name FROM authors WHERE %s ORDER BY 2") << fbCOLLATE_CYR;
if (m_book) {
sql = wxString::Format(sql, wxT("id IN (SELECT id_author FROM books WHERE id=%d)"));
sql = wxString::Format(sql, m_book);
} else if (m_auth) {
sql = wxString::Format(sql, wxT("id=%d"));
sql = wxString::Format(sql, m_auth);
} else {
Append(wxID_ANY, text)->Enable(false);
return;
}
FbCommonDatabase database;
FbSQLite3ResultSet result = database.ExecuteQuery(sql);
while (result.NextRow()) {
wxString name = result.GetString(1);
if (name.IsEmpty()) continue;
if (submenu == NULL) submenu = new FbMenu;
submenu->AppendSub(FbMenu::AUTH, result.GetInt(0), name);
}
Append(wxID_ANY, text, submenu)->Enable(submenu);
}
void FbBookMenu::AppendSeqn()
{
wxString text = _("Jump to series");
FbMenu * submenu = NULL;
wxString sql = wxT("SELECT id, value FROM sequences WHERE %s ORDER BY value");
if (m_book) {
sql = wxString::Format(sql, wxT("id IN (SELECT id_seq FROM bookseq WHERE id_book=%d)"));
sql = wxString::Format(sql, m_book);
} else if (m_seqn) {
sql = wxString::Format(sql, wxT("id=%d"));
sql = wxString::Format(sql, m_seqn);
} else {
Append(wxID_ANY, text)->Enable(false);
return;
}
FbCommonDatabase database;
FbSQLite3ResultSet result = database.ExecuteQuery(sql);
while (result.NextRow()) {
wxString name = result.GetString(1);
if (name.IsEmpty()) continue;
if (submenu == NULL) submenu = new FbMenu;
submenu->AppendSub(FbMenu::SEQN, result.GetInt(0), name);
}
Append(wxID_ANY, text, submenu)->Enable(submenu);
}
void FbBookMenu::AppendFldr(int folder)
{
wxString text = _("Add to folders");
FbMenu * submenu = NULL;
wxString sql = wxT("SELECT id, value FROM folders ORDER BY value");
FbLocalDatabase database;
FbSQLite3ResultSet result = database.ExecuteQuery(sql);
while (result.NextRow()) {
int key = result.GetInt(0);
if (folder == key) continue;
if (submenu == NULL) submenu = new FbMenu;
submenu->AppendSub(FbMenu::FLDR, key, result.GetString(1));
}
Append(wxID_ANY, text, submenu)->Enable(submenu);
}
|
