function sermon_alphabetical_get_one_node($letterstartnumber)
{
global $CFG, $COURSE, $alphabet;
if (empty($letterstartnumber)) {
return '';
}
$extrawhere = array();
for ($x = 0; $x < NUMBER_OF_PARTION_LETTERS; $x++) {
$extrawhere[] = "name LIKE '{$alphabet[$letterstartnumber + $x]}%' ";
}
//get the relavant sermons for this sermon series
$sql = "SELECT r.*, rs.datedelivered, rs.seriesname, rs.book, rs.beginchapter, cm.id as `cmid`,\n rs.guestspeaker, rs.guestspeakername, rs.hitcounter, rs.lastaccess \n FROM {$CFG->prefix}resource r \n JOIN {$CFG->prefix}resource_sermon rs ON rs.resourceid = r.id\n JOIN {$CFG->prefix}course_modules cm ON cm.instance = r.id \n WHERE r.type = 'sermon' AND r.course = {$COURSE->id} AND name != '' ";
$sql .= !empty($extrawhere) ? ' AND (' . implode(' OR ', $extrawhere) . ')' : '';
$sql .= " ORDER BY r.name ASC";
$sermons = get_recordset_sql($sql);
//loop through and make them into an array of objecst compatible for a json_encode
$letters = array();
while (($sermon = rs_fetch_next_record($sermons)) !== false) {
if (empty($sermon->seriesname)) {
$sermon->seriesname = 'no name';
}
$sermon->datedelivered = date('m-d-Y', $sermon->datedelivered);
$sermonnode = new stdClass();
$sermonnode->attributes = new stdClass();
$sermonnode->attributes->id = $sermon->cmid . '~' . sermon_block_make_name_safe_for_id($sermon->seriesname);
$sermonnode->attributes->class = 'leaf sermon';
if (!empty($sermon->reference)) {
$sermonnode->attributes->class .= ' mp3 ';
} else {
if (!empty($sermon->referencesermontext)) {
$sermonnode->attributes->class .= ' text ';
} else {
if (!empty($sermon->referencelesson)) {
$sermonnode->attributes->class .= ' lesson ';
}
}
}
$sermonnode->attributes->class .= rs_fetch_record($sermons) === false ? ' last ' : '';
$sermonnode->data = get_string('sermonleaf', 'resource', $sermon);
$letters[] = $sermonnode;
}
$letters = array_values($letters);
if (empty($letters)) {
return '';
}
return $letters;
}
function sermon_series_get_one_node($seriesname)
{
global $CFG, $COURSE;
if (empty($seriesname)) {
return '';
}
//get the relavant sermons for this sermon series
$sql = "SELECT r.*, rs.datedelivered, rs.seriesname, rs.book, rs.beginchapter, cm.id as `cmid`,\n rs.guestspeaker, rs.guestspeakername, rs.hitcounter, rs.lastaccess \n FROM {$CFG->prefix}resource r \n JOIN {$CFG->prefix}resource_sermon rs ON rs.resourceid = r.id\n JOIN {$CFG->prefix}course_modules cm ON cm.instance = r.id \n WHERE r.type = 'sermon' AND r.course = {$COURSE->id} AND name != '' AND rs.seriesname = '{$seriesname}'\n ORDER BY rs.seriesname ASC, rs.datedelivered DESC";
$sermons = get_recordset_sql($sql);
//loop through and make them into an array of objecst compatible for a json_encode
$series = array();
while (($sermon = rs_fetch_next_record($sermons)) !== false) {
if (empty($sermon->seriesname)) {
$sermon->seriesname = 'no name';
}
//clean up some variable
// $sermon->seriesname = stripslashes($sermon->seriesname);
// $sermon->name = stripslashes($sermon->name);
$sermon->datedelivered = date('m-d-Y', $sermon->datedelivered);
$sermonnode = new stdClass();
$sermonnode->attributes = new stdClass();
$sermonnode->attributes->id = $sermon->cmid . '~' . sermon_block_make_name_safe_for_id($sermon->seriesname);
$sermonnode->attributes->class = 'leaf sermon';
if (!empty($sermon->reference)) {
$sermonnode->attributes->class .= ' mp3 ';
} else {
if (!empty($sermon->referencesermontext)) {
$sermonnode->attributes->class .= ' text ';
} else {
if (!empty($sermon->referencelesson)) {
$sermonnode->attributes->class .= ' lesson ';
}
}
}
$sermonnode->attributes->class .= rs_fetch_record($sermons) === false ? ' last ' : '';
$sermonnode->data = get_string('sermonleaf', 'resource', $sermon);
$series[] = $sermonnode;
}
$series = array_values($series);
if (empty($series)) {
return '';
}
return $series;
}
function sermon_date_get_one_node($datecategory)
{
global $CFG, $COURSE, $alphabet;
if (empty($datecategory)) {
return '';
}
//get the relevant sermons for these dates
$sql = "SELECT r.*, rs.datedelivered, rs.seriesname, rs.book, rs.beginchapter, cm.id as `cmid`,\n rs.guestspeaker, rs.guestspeakername, rs.hitcounter, rs.lastaccess \n FROM {$CFG->prefix}resource r \n JOIN {$CFG->prefix}resource_sermon rs ON rs.resourceid = r.id\n JOIN {$CFG->prefix}course_modules cm ON cm.instance = r.id \n WHERE r.type = 'sermon' AND r.course = {$COURSE->id} AND name != '' ";
$startdate = 0;
$enddate = 0;
switch ($datecategory) {
case CURRENT_YEAR:
$startdate = mktime(0, 0, 0, 1, 1, date('Y'));
$enddate = time();
break;
case PREVIOUS_YEAR:
$startdate = mktime(0, 0, 0, 1, 1, date('Y') - 1);
$enddate = mktime(0, 0, 0, 1, 1, date('Y'));
break;
case PREVIOUS_FIVE_YEARS:
$startdate = mktime(0, 0, 0, 1, 1, date('Y') - 6);
$enddate = mktime(0, 0, 0, 1, 1, date('Y') - 1);
break;
case OLDER:
$startdate = 0;
$enddate = mktime(0, 0, 0, 1, 1, date('Y') - 6);
break;
}
$sql .= " AND rs.datedelivered >= '{$startdate}' AND rs.datedelivered < '{$enddate}' ";
$sql .= " ORDER BY rs.datedelivered DESC";
$sermons = get_recordset_sql($sql);
//loop through and make them into an array of objects compatible for a json_encode
$datesermons = array();
while (($sermon = rs_fetch_next_record($sermons)) !== false) {
if (empty($sermon->seriesname)) {
$sermon->seriesname = 'no name';
}
// $sermon->seriesname = stripslashes($sermon->seriesname);
// $sermon->name = stripslashes($sermon->name);
$sermon->datedelivered = date('m-d-Y', $sermon->datedelivered);
$sermonnode = new stdClass();
$sermonnode->attributes = new stdClass();
$sermonnode->attributes->id = $sermon->cmid . '~' . sermon_block_make_name_safe_for_id($sermon->seriesname);
$sermonnode->attributes->class = 'leaf sermon';
if (!empty($sermon->reference)) {
$sermonnode->attributes->class .= ' mp3 ';
} else {
if (!empty($sermon->referencesermontext)) {
$sermonnode->attributes->class .= ' text ';
} else {
if (!empty($sermon->referencelesson)) {
$sermonnode->attributes->class .= ' lesson ';
}
}
}
$sermonnode->attributes->class .= rs_fetch_record($sermons) === false ? ' last ' : '';
$sermonnode->data = get_string('sermonleaf', 'resource', $sermon);
$datesermons[] = $sermonnode;
}
$datesermons = array_values($datesermons);
if (empty($datesermons)) {
return '';
}
return $datesermons;
}
