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; }