/**
* load content of wiki page
*
* @param string $doc_id
* @param int $wikicategory_id
* @param int $version_no
* @return db result
*/
function churchwiki_load($doc_id, $wikicategory_id, $version_no = null)
{
if (!$version_no) {
$version_no = churchwiki_getCurrentNo($doc_id, $wikicategory_id);
}
ct_log("Aufruf Hilfeseite {$wikicategory_id}:{$doc_id} ({$version_no})", 2, "-1", "help");
$data = db_query("SELECT p.vorname, p.name, doc_id, version_no, wikicategory_id, text, modified_date, modified_pid, auf_startseite_yn\n FROM {cc_wiki} w LEFT JOIN {cdb_person} p ON (w.modified_pid=p.id)\n WHERE version_no=:version_no AND doc_id=:doc_id AND wikicategory_id=:wikicategory_id", array(':doc_id' => $doc_id, ':wikicategory_id' => $wikicategory_id, ':version_no' => $version_no))->fetch();
if (isset($data->text)) {
$data->text = preg_replace('/\\\\/', "", $data->text);
$data->text = preg_replace('/===([^===]*)===/', "<h3>\$1</h3>", $data->text);
$data->text = preg_replace('/==([^==]*)==/', "<h2>\$1</h2>", $data->text);
$data->files = churchcore_getFilesAsDomainIdArr("wiki_" . $wikicategory_id, $doc_id);
}
return $data;
}
/**
* get next services for current user
* @param string $short
* @return string
*/
function churchservice_getUserNextServices($short = true)
{
global $user;
include_once './' . CHURCHDB . '/churchdb_db.php';
$pid = $user->id;
$res = db_query("\n SELECT e.id event_id, cal.bezeichnung AS event, DATE_FORMAT(e.startdate, '%d.%m.%Y %H:%i') AS datum,\n s.bezeichnung AS service, sg.bezeichnung AS servicegroup, cdb_person_id,\n DATE_FORMAT(es.modified_date, '%d.%m.%Y %H:%i') AS modified_date\n FROM {cs_eventservice} es, {cs_event} e, {cc_cal} cal, {cs_servicegroup} sg, {cs_service} s\n WHERE cal.id=e.cc_Cal_id AND e.valid_yn=1 AND cdb_person_id=:pid AND e.startdate>=current_date AND zugesagt_yn=1\n AND es.valid_yn=1 AND es.event_id=e.id AND es.service_id=s.id AND sg.id=s.servicegroup_id order by e.startdate", array(':pid' => $pid));
$nr = 0;
$txt = "";
foreach ($res as $arr) {
$nr++;
if ($nr <= 5 || !$short) {
$txt .= "<p><a href='?q=churchservice&id={$arr->event_id}'>{$arr->datum} - {$arr->event}</a>:\n <a href='?q=churchservice&id={$arr->event_id}'><b>{$arr->service}</b></a> ({$arr->servicegroup})";
$files = churchcore_getFilesAsDomainIdArr("service", $arr->event_id);
$txt .= '<span class="pull-right">';
if (isset($files) && isset($files[$arr->event_id])) {
$i = 0;
foreach ($files[$arr->event_id] as $file) {
$i++;
if ($i < 4) {
$txt .= churchcore_renderFile($file) . " ";
} else {
$txt .= "...";
}
// TODO: ... for each additional file?
}
}
$txt .= "</span><small><br> " . t("confirmed.on", $arr->modified_date) . "</small>";
}
}
return $txt;
}
/**
* delete arrangement
* @param unknown $params
*/
function churchservice_delArrangement($params)
{
$i = new CTInterface();
$i->setParam("id");
$files = churchcore_getFilesAsDomainIdArr("song_arrangement", $params["id"]);
if (isset($files) && isset($files[$params["id"]])) {
foreach ($files[$params["id"]] as $file) {
churchcore_delFile($file->id);
}
}
db_delete("cs_song_arrangement")->fields($i->getDBInsertArrayFromParams($params))->condition("id", $params["id"], "=")->execute(false);
}
function churchservice_getUserNextServices($shorty = true)
{
global $user;
include_once './' . CHURCHDB . '/churchdb_db.php';
$pid = $user->id;
$res = db_query("SELECT e.id event_id, cal.bezeichnung event, DATE_FORMAT(e.startdate, '%d.%m.%Y %H:%i') datum, s.bezeichnung service, sg.bezeichnung servicegroup, cdb_person_id, DATE_FORMAT(es.modified_date, '%d.%m.%Y %H:%i') modified_date\n FROM {cs_eventservice} es, {cs_event} e, {cc_cal} cal, {cs_servicegroup} sg, {cs_service} s where\n cal.id=e.cc_Cal_id and e.valid_yn=1 and \n cdb_person_id={$pid} and e.startdate>=current_date and zugesagt_yn=1 and es.valid_yn=1 and es.event_id=e.id and es.service_id=s.id and sg.id=s.servicegroup_id order by e.startdate");
$nr = 0;
$txt = "";
foreach ($res as $arr) {
$nr = $nr + 1;
if ($nr <= 5 || !$shorty) {
$txt .= '<p><a href="?q=churchservice&id=' . $arr->event_id . '">' . $arr->datum . " - " . $arr->event . "</a>: ";
$txt .= '<a href="?q=churchservice&id=' . $arr->event_id . '"><b>' . $arr->service . "</b></a> (" . $arr->servicegroup . ")";
$files = churchcore_getFilesAsDomainIdArr("service", $arr->event_id);
$txt .= '<span class="pull-right">';
if (isset($files) && isset($files[$arr->event_id])) {
$i = 0;
foreach ($files[$arr->event_id] as $file) {
$i++;
if ($i < 4) {
$txt .= churchcore_renderFile($file) . " ";
} else {
$txt .= "...";
}
}
}
$txt .= "</span><small><br> ";
$txt .= t("confirmed.on", $arr->modified_date) . "</small>";
}
}
return $txt;
}