public function processSection()
{
global $IconPath;
$lobjGuide = new Guide();
if (isset($this->_input['action'])) {
switch ($this->_input['action']) {
case 'create':
// print section and slider div
$new_id = rand(1, 100000);
print "<div id=\"section_{$new_id}\" class=\"sp_section pure-g\" data-layout='4-4-4'>";
print "<div class=\"sp_section_controls\">";
print "<i class=\"fa fa-arrows section_sort\" title=\"Move Section\"></i>\n\t\t\t\t\t<i class=\"fa fa-trash-o section_remove\" title=\"Delete Section\"></i>\n\t\t\t\t\t</div>";
print $lobjGuide->dropBoxes(0, 'left', "");
print $lobjGuide->dropBoxes(1, 'center', "");
print $lobjGuide->dropBoxes(2, 'sidebar', "");
print '<div id="clearblock" style="clear:both;"></div> <!-- this just seems to allow the space to grow to fit dropbox areas -->';
print '</div>';
break;
case 'delete':
if (isset($_POST['section_id'])) {
$db = new Querier();
$q = "DELETE p, s\n\t\t\t\t\t\t\tFROM pluslet p\n\t\t\t\t\t\t\tINNER JOIN pluslet_section ps\n\t\t\t\t\t\t\tON p.pluslet_id = ps.pluslet_id\n\t\t\t\t\t\t\tINNER JOIN section s\n\t\t\t\t\t\t\tON ps.section_id = s.section_id\n\t\t\t\t\t\t\tWHERE p.type != 'Special'\n\t\t\t\t\t\t\tAND s.section_id = " . $_POST['section_id'];
if ($db->exec($q) === FALSE) {
print "Query Error! Did not delete";
} else {
print "Thy will be done!";
}
} else {
print "Error: No section ID";
}
break;
default:
print 'No action.';
break;
}
} else {
print 'No action.';
}
}
$main_width = 0;
}
if (isset($col_widths[2]) && $col_widths[2] > 0) {
$side_width = $col_widths[2] * 8 - 3;
// we make this a squidgen narrower so it doesn't wrap nastily
} else {
$side_width = 0;
}
// Is there a selected tab?
if (isset($_GET["t"]) && $_GET["t"] != "") {
$selected_tab = scrubData($_GET["t"]);
} else {
$selected_tab = 0;
}
//create new guide object and set admin view to false
$lobjGuide = new Guide($this_id);
$lobjGuide->_isAdmin = FALSE;
//processVisibility
if (!$lobjGuide->checkVisibility()) {
exit;
}
$all_tabs = $lobjGuide->getTabs('public');
} else {
header("location:index.php");
}
$page_title = $subject_name;
// Do we have an alternate header?
if (isset($header_type) && $header_type != 'default') {
if (file_exists("includes/header_{$header_type}.php")) {
include "includes/header_{$header_type}.php";
} else {
function writeTable($qualifier, $subject_id = '', $description_search = 0)
{
global $IconPath;
global $proxyURL;
$db = new Querier();
// sanitize submission
$subject_id = scrubData($subject_id);
// Prepare conditions
$condition1 = "";
$condition2 = "";
$condition3 = "";
switch ($qualifier) {
case "Num":
$condition1 = "WHERE left(title, 1) REGEXP '[[:digit:]]+'";
$condition2 = "WHERE left(alternate_title, 1) REGEXP '[[:digit:]]+'";
break;
case "All":
$condition1 = "WHERE title != ''";
$condition2 = "WHERE alternate_title != ''";
break;
case "bysub":
if (isset($subject_id)) {
//get title ids in pluslets' resource token connected to subject
$lobjGuide = new Guide($subject_id);
$lobjTitleIds = $lobjGuide->getRelatedTitles();
$condition1 = "WHERE (subject_id = {$subject_id}";
$condition1 .= count($lobjTitleIds) > 0 ? "\nOR t.title_id IN (" . implode(',', $lobjTitleIds) . ")" : "";
$condition1 .= ")";
$condition2 = "WHERE subject_id = {$subject_id}";
} else {
$condition1 = "WHERE title LIKE " . $db->quote("%" . $qualifier . "%");
$condition2 = "WHERE alternate_title LIKE " . $db->quote("%" . $qualifier . "%");
}
break;
case "bytype":
if (isset($_GET["type"])) {
$condition1 = "WHERE ctags LIKE " . $db->quote(scrubData($_GET["type"]));
$condition2 = "WHERE ctags LIKE " . $db->quote(scrubData($_GET["type"]));
$condition3 = "and alternate_title NOT NULL";
}
break;
case "search":
$condition1 = "WHERE title LIKE " . $db->quote("%" . $qualifier . "%");
// If you uncomment the next line, it will search description field
$condition1 = "WHERE (title LIKE " . $db->quote("%" . $qualifier . "%") . " OR description LIKE " . $db->quote("%" . $qualifier . "%");
$condition2 = "WHERE alternate_title LIKE " . $db->quote("%" + $qualifier + "%");
break;
default:
// This is the simple output by letter and also the search
if (strlen($qualifier) == 1) {
// Is like the first letter
$condition1 = "WHERE title LIKE " . $db->quote($qualifier . "%");
} else {
$condition1 = "WHERE title LIKE " . $db->quote("%" . $qualifier . "%");
}
if ($description_search == 1) {
// If you uncomment the next line, it will search description field
$condition1 = "WHERE (title LIKE " . $db->quote("%" . $qualifier . "%") . " OR description LIKE " . $db->quote("%" . $qualifier . "%") . ")";
}
$condition2 = "WHERE alternate_title LIKE " . $db->quote("%" + $qualifier + "%");
}
$q1 = "SELECT distinct left(t.title,1) as initial, t.title as newtitle, t.description, location, access_restrictions, t.title_id as this_record,eres_display, display_note, pre, citation_guide, ctags, helpguide\n FROM title as t\n INNER JOIN location_title as lt\n ON t.title_id = lt.title_id\n INNER JOIN location as l\n ON lt.location_id = l.location_id\n INNER JOIN restrictions as r\n ON l.access_restrictions = r.restrictions_id\n INNER JOIN rank as rk\n ON rk.title_id = t.title_id\n INNER JOIN source as s\n ON rk.source_id = s.source_id\n {$condition1}\n AND eres_display = 'Y'\n ORDER BY newtitle";
$q2 = "SELECT distinct left(t.alternate_title,1) as initial, t.alternate_title as newtitle, t.description, location, access_restrictions, t.title_id as this_record,eres_display, display_note, pre, citation_guide, ctags, helpguide\n FROM title as t\n INNER JOIN location_title as lt\n ON t.title_id = lt.title_id\n INNER JOIN location as l\n ON lt.location_id = l.location_id\n INNER JOIN restrictions as r\n ON l.access_restrictions = r.restrictions_id\n INNER JOIN rank as rk\n ON rk.title_id = t.title_id\n INNER JOIN source as s\n ON rk.source_id = s.source_id\n {$condition2}\n\t\t AND eres_display = 'Y'\n {$condition3}\n\n\t\t ORDER BY newtitle";
$r = $db->query($q1);
$num_rows = count($r);
if ($num_rows == 0) {
return "<div class=\"no_results\">" . _("Sorry, there are no results at this time.") . "</div>";
}
// prepare header
$items = "<table width=\"98%\" class=\"item_listing\">";
$row_count = 0;
$colour1 = "oddrow";
$colour2 = "evenrow";
foreach ($r as $myrow) {
$row_colour = $row_count % 2 ? $colour1 : $colour2;
$patterns = "/'|\"/";
$replacements = "";
$item_title = $myrow[1];
if ($myrow["pre"] != "") {
$item_title = $myrow["pre"] . " " . $item_title;
}
$safe_title = trim(preg_replace($patterns, $replacements, $item_title));
$blurb = $myrow["description"];
$bib_id = $myrow[5];
/// CHECK RESTRICTIONS ///
if ($myrow['4'] == 2 or $myrow['4'] == 3) {
$url = $proxyURL . $myrow[3];
$rest_icons = "restricted";
} elseif ($myrow['4'] == 4) {
$url = $myrow[3];
$rest_icons = "restricted";
} else {
$url = $myrow[3];
$rest_icons = "";
// if you want the unlocked icon to show, enter "unrestricted" here
}
$current_ctags = explode("|", $myrow["ctags"]);
// add our $rest_icons info to this array at the beginning
array_unshift($current_ctags, $rest_icons);
$icons = showIcons($current_ctags);
/// Check for Help Guide ///
if ($myrow["helpguide"] != "") {
$helpguide = " <a href=\"" . $myrow["helpguide"] . "\"><img src=\"{$IconPath}/help.gif\" border=\"0\" alt=\"" . _("Help Guide") . "\" title=\"" . _("Help Guide") . "\" /></a>";
} else {
$helpguide = "";
}
//Check if there is a display note
if ($myrow["display_note"] == NULL) {
$display_note_text = "";
} else {
$display_note_text = "<br /><strong>" . _("Note:") . " </strong>" . $myrow['display_note'];
}
$bonus = "{$blurb}<br />";
if ($blurb != "") {
$information1 = "<span id=\"bib-{$bib_id}\" class=\"toggleLink curse_me\"><img src=\"{$IconPath}/information.png\" border=\"0\" alt=\"" . _("more information") . "\" title=\"" . _("more information") . "\" /></span>";
// This is new details link; you can use the one above if you prefer
$information = "<span id=\"bib-{$bib_id}\" class=\"toggleLink curse_me\">" . _("about") . "</span>";
} else {
$information = "";
}
$target = targetBlanker();
$items .= self::generateLayout($row_colour, $url, $target, $item_title, $information, $information1, $icons, $helpguide, $display_note_text, $bonus);
$row_count++;
}
$items .= "</table>";
return $items;
}
$main_width = 0;
}
if (isset($col_widths[2]) && $col_widths[2] > 0) {
$side_width = $col_widths[2] * 8 - 3;
// we make this a squidgen narrower so it doesn't wrap nastily
} else {
$side_width = 0;
}
// Is there a selected tab?
if (isset($_GET["t"]) && $_GET["t"] != "") {
$selected_tab = scrubData($_GET["t"]);
} else {
$selected_tab = 0;
}
//create new guide object and set admin view to true
$lobjGuide = new Guide($this_id);
$lobjGuide->_isAdmin = TRUE;
$all_tabs = $lobjGuide->getTabs();
} else {
print "no guide";
}
////////////////////////////
// Now, get our pluslets //
///////////////////////////
global $pluslets_activated;
$all_boxes = "\n<ul id=\"box_options\">\n<li class=\"box_note box-item\">" . _("Drag selection, then drop to right") . "</li>";
foreach ($pluslets_activated as $lstrPluslet) {
if (file_exists(dirname(dirname(__DIR__)) . "/lib/SubjectsPlus/Control/Pluslet/{$lstrPluslet}.php")) {
$lstrObj = "SubjectsPlus\\Control\\Pluslet_" . $lstrPluslet;
if (method_exists($lstrObj, 'getMenuName')) {
$all_boxes .= "<li class=\"box-item draggable\" id=\"pluslet-id-{$lstrPluslet}\" ckclass='" . call_user_func(array($lstrObj, 'getCkPluginName')) . "'>" . call_user_func(array($lstrObj, 'getMenuName')) . "</li>";
/**
* @file section_data.php
* @brief Create new section HTML
* @description
*
* @author agdarby, dgonzalez
* @date updated April 2014
*/
use SubjectsPlus\Control\Guide;
use SubjectsPlus\Control\Querier;
$subsubcat = "";
$subcat = "guides";
$page_title = "Section Functions";
$header = "noshow";
include "../../includes/header.php";
$lobjGuide = new Guide();
if (isset($_POST['action'])) {
switch ($_POST['action']) {
case 'create':
//print section and slider div
$new_id = rand(1, 100000);
print "<div id=\"section_new_{$new_id}\" class=\"sp_section\" data-layout=\"4-4-4\">";
print "<div class=\"sp_section_controls\">\n\t\t\t<img src=\"{$IconPath}/hand_cursor-26.png\" class=\"section_sort\"/>\n\t\t\t<img src=\"{$IconPath}/delete.png\" class=\"section_remove\" />\n\t\t\t<div id=\"slider_section_new_{$new_id}\" class=\"sp_section_slider\"></div>\n\t\t\t\t </div>";
print $lobjGuide->dropBoxes(0, 'left', "");
print $lobjGuide->dropBoxes(1, 'center', "");
print $lobjGuide->dropBoxes(2, 'sidebar', "");
print '<div id="clearblock" style="clear:both;"></div> <!-- this just seems to allow the space to grow to fit dropbox areas -->';
print '</div>';
?>
<script type="text/javascript">
makeSectionSlider('div[id="<?php
// Is this an Insert or an update?
//////////////////////////////////
if ($_POST["subject_id"] == "") {
$record->insertRecord();
$ok_record_id = $record->getRecordId();
} else {
$record->updateRecord();
}
// Show feedback
$feedback = $record->getMessage();
// See all the queries?
//$record->deBug();
print "<div class=\"feedback\" style=\"display:block;\">" . $feedback . "</div>";
}
if (!isset($no_form)) {
$record = new Guide($ok_record_id);
}
// show feedback if it isn't already set
if (!isset($feedback)) {
$feedback = $record->getMessage();
}
/////////////////////////
// SHOW FORM
// If the form isn't suppressed, output it. It will be blank if there's no id
/////////////////////////
if (!isset($_REQUEST["wintype"])) {
$_GET["wintype"] = "";
}
if (!isset($no_form)) {
print "<div id=\"maincontent\">";
$record->outputMetadataForm($_GET["wintype"]);
$db = new Querier();
$r = $db->query($q);
// If this guide doesn't exist, send them away
if (count($r) == 0) {
header("location:index.php");
}
$subject_name = $r[0][0];
$shortform = $r[0][1];
// Is there a selected tab?
if (isset($_GET["t"]) && $_GET["t"] != "") {
$selected_tab = scrubData($_GET["t"]);
} else {
$selected_tab = 0;
}
// create new guide object and set admin view to true
$lobjGuide = new Guide($this_id);
$lobjGuide->_isAdmin = TRUE;
$all_tabs = $lobjGuide->getTabs();
} else {
print "no guide";
}
// //////////////////////////
// Now, get our pluslets //
// /////////////////////////
global $pluslets_activated;
// get related guides
$related_guides = $lobjGuide->getRelatedGuides();
$related_guides = array_filter($related_guides);
// if none exist then do not display related guide pluslet icon
if (empty($related_guides)) {
if (($key = array_search('Related', $pluslets_activated)) !== false) {
