" ~ _sf ~ ")├", "i");
if (auto m = _txt.matchFirst(rgx_url)) {
_txt = replaceAll!(m =>
_mark_open
~ m.captures[0]
~ _mark_close
)(_txt, rgx_matched_text);
_txt = replaceAll!(m =>
replaceAll!(u =>
u["keep"]
)(m.hit, rgx_marked_pair)
)(_txt, rgx_url);
_txt = replaceAll!(m =>
_span_match
~ m["keep"]
~ _span_close
)(_txt, rgx_marked_pair);
} else {
_txt = replaceAll!(m =>
_span_match
~ m.captures[0]
~ _span_close
)(_txt, rgx_matched_text);
}
}
return _txt;
}
string select_field_like(string db_field, string search_field) {
string where_ = "";
if (!(search_field.empty)) {
string _sf = search_field.strip.split("%20").join(" ");
if (_sf.match(r" OR ")) {
_sf = _sf.split(" OR ").join("%' OR " ~ db_field ~ " LIKE '%");
}
if (_sf.match(r" AND ")) {
_sf = _sf.split(" AND ").join("%' AND " ~ db_field ~ " LIKE '%");
}
_sf = "( " ~ db_field ~ " LIKE\n '%" ~ _sf ~ "%' )";
where_ ~= format(q"┃
%s
┃",
_sf
);
}
return where_;
}
string[] _fields;
_fields ~= select_field_like("doc_objects.clean", tf.text);
_fields ~= select_field_like("metadata_and_text.title", tf.title);
_fields ~= select_field_like("metadata_and_text.creator_author", tf.author);
_fields ~= select_field_like("metadata_and_text.uid", tf.uid);
_fields ~= select_field_like("metadata_and_text.src_filename_base", tf.fn);
_fields ~= select_field_like("metadata_and_text.src_filename_base", tf.src_filename_base);
_fields ~= select_field_like("metadata_and_text.language_document_char", tf.language);
_fields ~= select_field_like("metadata_and_text.date_published", tf.date);
_fields ~= select_field_like("metadata_and_text.classify_keywords", tf.keywords);
_fields ~= select_field_like("metadata_and_text.classify_topic_register", tf.topic_register);
string[] fields;
foreach (f; _fields) {
if (!(f.empty)) { fields ~= f; }
}
string fields_str = "";
fields_str ~= fields.join(" AND ");
sql_select.the_body ~= format(q"┃
SELECT
metadata_and_text.uid,
metadata_and_text.title,
metadata_and_text.creator_author_last_first,
metadata_and_text.creator_author,
metadata_and_text.src_filename_base,
metadata_and_text.language_document_char,
metadata_and_text.date_published,
metadata_and_text.classify_keywords,
metadata_and_text.classify_topic_register,
doc_objects.body,
doc_objects.seg_name,
doc_objects.ocn,
metadata_and_text.uid
FROM
doc_objects,
metadata_and_text
WHERE (
%s
)
AND
doc_objects.uid_metadata_and_text = metadata_and_text.uid
ORDER BY
metadata_and_text.creator_author_last_first,
metadata_and_text.date_published DESC,
metadata_and_text.title,
metadata_and_text.language_document_char,
metadata_and_text.src_filename_base,
doc_objects.ocn
LIMIT %s OFFSET %s
;┃",
fields_str,
cv.sql_match_limit,
cv.sql_match_offset,
);
(cv.checked_sql)
? cgi.write(previous_next
~ "
"
~ sql_select.the_body.strip.split("\n ").join(" ").split("\n").join("
")
~ "\n"
)
: "";
cgi.write(previous_next);
auto select_query_results = db.execute(sql_select.the_body).cached;
string _old_uid = "";
if (!select_query_results.empty) {
string _date_published = "0000";
string _close_para = "";
string _matched_ocn_open = "";
foreach (idx, row; select_query_results) {
if (row["uid"].as!string != _old_uid) {
_close_para = (idx == 1) ? "" : "";
_matched_ocn_open = (idx == 1) ? "" : "";
_old_uid = row["uid"].as!string;
_date_published = (row["date_published"].as!string.match(regex(r"^([0-9]{4})")))
? row["date_published"].as!string : "0000"; // used in regex that breaks if no match
auto m = _date_published.match(regex(r"^([0-9]{4})"));
string _date = (m.hit == "0000") ? "(year?) " : "(" ~ m.hit ~ ") ";
cgi.write(
_close_para
~ "
"
~ "
\""
~ row["title"].as!string ~ "\""
~ " "
~ _date
~ "[" ~ row["language_document_char"].as!string ~ "] "
~ row["creator_author_last_first"].as!string
~ " "
~ show_matched_objects(row["src_filename_base"].as!string)
~ "
"
~ "
"
~ "
"
~ "
"
~ highlight_text_matched(row["body"].as!string, tf.text)
~ "
"
~ "
"
~ "
"
~ "
"
~ highlight_text_matched(row["body"].as!string, tf.text)
~ "
"
~ "
\n");
}
cgi.write("
git
");
}
sql_search_query;
}
{
db.close;
}
{
string tail = format(q"┃
┃");
cgi.write(tail);
}
}
mixin GenericMain!cgi_function_intro;