Расшифровка титульных страниц и справок

[yelizariev]

3) сейчас заметил, что титульные листы и следующие за ними листы справок приводятся только в графической версии; в диске они даются и текстом тоже, и это нужно доделать. Со справкой дело поправимое - можно давать аналогично листам списков, текст и картинку рядом; сложнее с титульными листами, т.к. в придуманную Вами конструкцию это не ложится, а рушить ее не хочется. Как вариант - давать текстовую версию ниже на всю ширину, перед следующей страницей обычной структуры (справкой или списком)

[yelizariev]

http://xn----ctbhbcabhmli2ake3ct5aa3l5a.xn--p1ai/lists/list184/#image-211

"За разстрел всех 138 человек" указано в таблице pomety.csv  https://github.com/itpp-labs/stalin/blob/master/data/db/tables/pomety.csv#L38

Далее айди пометы используется в pages.csv

Там же есть поле pagekind

+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+
| "pageid" | "tom" | "pageintom" | "alistid" | "pagekind" | "arowcount" |    "picturefile"     | "textfile" | "sublisttitle" | "categorytitle" | "grouptitle" | "podpnkvd" | "pometa" |
+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+
| "2807"   | "9"   | "211"       | "184"     | "2"        | "0"         | "17-171-417-211.jpg" | ""         | "0"            | "0"             | "0"          | "0"        | "37"     |
+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+

"подлежащих суду военной коллегии" встречается в listtitl.csv https://github.com/itpp-labs/stalin/blob/master/data/db/tables/listtitl.csv#L9

listtile это centertext,toptext в lists.csv Там же расшифровки подписей в полях politsigns https://github.com/itpp-labs/stalin/blob/master/data/db/tables/lists.csv#L185

+----------+--------+--------+---------+-----------+-----------------------------------------------+-------+------------------------+--------------+-----------+---------------------------------------------------------+---------+---------+-------------+------------+------------+-----------+--------------+------------------+--------------+---------------+--------------+-----------------+------------------+---------------+------------+--------------+--------+
| "listid" | "fond" | "opis" | "ed_hr" | "delonum" |                  "deloname"                   | "tom" |       "datetext"       |   "adate"    | "listnum" |                       "listtitle"                       | "page1" | "page2" | "listmaker" | "listkind" | "reallist" | "toptext" | "centertext" |   "politsigns"   | "signstalin" | "signmolotov" | "signjdanov" | "signkaganovic" | "signvoroshilov" | "signmikoyan" | "signejov" | "signkosior" | "prim" |
+----------+--------+--------+---------+-----------+-----------------------------------------------+-------+------------------------+--------------+-----------+---------------------------------------------------------+---------+---------+-------------+------------+------------+-----------+--------------+------------------+--------------+---------------+--------------+-----------------+------------------+---------------+------------+--------------+--------+
| "184"    | "17"   | "171"  | "417"   | "9-Л/8-9" | "Право-троцкистский блок (списки осужденных)" | "9"   | "от 26 июля 1938 года" | "1938-07-26" | "31"      | "Записка Ежова с приложением списка лиц - Москва-центр" | "210"   | "217"   | "15"        | "0"        | "1"        | "15"      | "8"          | "Сталин,Молотов" | "1"          | "1"           | "0"          | "0"             | "0"              | "0"           | "0"        | "0"          | ""     |
+----------+--------+--------+---------+-----------+-----------------------------------------------+-------+------------------------+--------------+-----------+---------------------------------------------------------+---------+---------+-------------+------------+------------+-----------+--------------+------------------+--------------+---------------+--------------+-----------------+------------------+---------------+------------+--------------+--------+

[yelizariev]

http://ec2-34-204-45-90.compute-1.amazonaws.com:1313/lists/list184/#image-212 pages.csv:

+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+
| "pageid" | "tom" | "pageintom" | "alistid" | "pagekind" | "arowcount" |    "picturefile"     | "textfile" | "sublisttitle" | "categorytitle" | "grouptitle" | "podpnkvd" | "pometa" |
+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+
| "2808"   | "9"   | "212"       | "184"     | "3"        | "0"         | "17-171-417-212.jpg" | ""         | "0"            | "0"             | "0"          | "0"        | "0"      |
+----------+-------+-------------+-----------+------------+-------------+----------------------+------------+----------------+-----------------+--------------+------------+----------+

sublists.csv:

+-------------+-------+-----------+--------------+---------------+-----------+--------------+----------------+-------------+--------+--------+--------+-------------+-------------+-------------+--------+--------+----------------------------------------------------+-------------------------------------------------+---------------+----------------+------------------+-------------------+----------------+---------------+-------------+----------+
| "sublistid" | "tom" | "listnum" |   "adate"    |  "datetext"   | "alistid" | "sublistnum" | "sublisttitle" | "geography" | "kat1" | "kat2" | "kat3" | "kat1count" | "kat2count" | "kat3count" | "grif" | "kind" |                     "podp_fin"                     |                    "podp_pb"                    | "podp_stalin" | "podp_molotov" | "podp_kaganovic" | "podp_voroshilov" | "podp_mikoyan" | "podp_jdanov" | "podp_ejov" | "simple" |
+-------------+-------+-----------+--------------+---------------+-----------+--------------+----------------+-------------+--------+--------+--------+-------------+-------------+-------------+--------+--------+----------------------------------------------------+-------------------------------------------------+---------------+----------------+------------------+-------------------+----------------+---------------+-------------+----------+
| "124"       | "9"   | "30"      | "0000-00-00" | "26.VII.38г." | "184"     | "1"          | "Москва-центр" | ""          | "1"    | "0"    | "0"    | "139"       | "0"         | "0"         | ""     | "0"    | "Шапиро (нач.1-го спецотд. НКВД СССР ст.майор ГБ)" | "Сталин Молотов (За расстрел всех 138 человек)" | "1"           | "1"            | "1"              | "1"               | "1"            | "1"           | "1"         | "1"      |
+-------------+-------+-----------+--------------+---------------+-----------+--------------+----------------+-------------+--------+--------+--------+-------------+-------------+-------------+--------+--------+----------------------------------------------------+-------------------------------------------------+---------------+----------------+------------------+-------------------+----------------+---------------+-------------+----------+

[yelizariev]

done in #77