340 lines
11 KiB
PHP
340 lines
11 KiB
PHP
<?php
|
||
include_once '../classes/lg-on_Smarty.class_subdir.php';
|
||
$smarty = new lgon_Smarty();
|
||
require_once("../config.inc.php");
|
||
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
|
||
require_once "../language/german.inc.php";
|
||
|
||
require_once("star/Rate.php");
|
||
$rate = new Rate();
|
||
|
||
$db = dbconnect();
|
||
|
||
$teile = explode(" ", $_GET ["load"]);
|
||
$art= trim($teile[0]);
|
||
$nummer = trim($teile[1]);
|
||
$zusatz = trim($teile[2]);
|
||
|
||
setcookie("liedanzeige_art","$art");
|
||
setcookie("liedanzeige_nummer","$nummer");
|
||
setcookie("liedanzeige_zusatz","$zusatz");
|
||
|
||
if(isset($_GET['action'])){
|
||
$action = $_GET['action'];
|
||
}else{
|
||
$action = '';
|
||
}
|
||
|
||
if($action == ''){
|
||
if($zusatz == ''){
|
||
$zusatz="IS NULL";
|
||
}else{
|
||
$zusatz="= '$zusatz'";
|
||
}
|
||
|
||
|
||
|
||
$result_lied = $db->query( "SELECT art, id, nr, zusatz, titel, text, kategorie, unterkategorie
|
||
FROM lieder_synopse
|
||
WHERE art = '$art'
|
||
AND nr = '$nummer'
|
||
AND zusatz $zusatz" );
|
||
$row_lied = $result_lied->fetch_array();
|
||
|
||
$smarty->assign('liedanzeige_art', "$row_lied[art]");
|
||
$smarty->assign('liedanzeige_nr', "$row_lied[nr]");
|
||
$smarty->assign('liedanzeige_zusatz', "$row_lied[zusatz]");
|
||
$smarty->assign('liedanzeige_titel', "$row_lied[titel]");
|
||
$smarty->assign('liedanzeige_kategorie', "$row_lied[kategorie]");
|
||
$smarty->assign('liedanzeige_unterkategorie', "$row_lied[unterkategorie]");
|
||
$smarty->assign('liedanzeige_text', "$row_lied[text]");
|
||
|
||
$datum = date("Y-m-d", time());
|
||
$smarty->assign('liedanzeige_date', "$datum");
|
||
|
||
# Gottesdienst auslesen
|
||
if(!isset($_GET["more_gd"])){
|
||
$more_gd = 5;
|
||
setcookie("more_gd","$more_gd");
|
||
}else{
|
||
$more_gd = $_COOKIE["more_gd"]+5;
|
||
setcookie("more_gd","$more_gd");
|
||
}
|
||
|
||
$result_vorh_gd = $db->query( "SELECT count(*) Anz
|
||
FROM lieder_auffuehrung
|
||
WHERE VAID =$user_vaid
|
||
AND art = '$art'
|
||
AND Nr = '$nummer'
|
||
AND zusatz $zusatz
|
||
AND status = 'G'"
|
||
);
|
||
$row_vorh_gd = $result_vorh_gd->fetch_array();
|
||
$smarty->assign('liedanzeige_anz_gd', "$row_vorh_gd[Anz]");
|
||
$smarty->assign('liedanzeige_more_gd', "$more_gd");
|
||
|
||
$query_gd = "SELECT laid
|
||
, vaid
|
||
, DATE_Format(datum, '%d.%m.%Y')AS datum_form
|
||
, DATE_Format(datum, '%d')AS tag
|
||
, DATE_Format(datum, '%m')AS monat
|
||
, DATE_Format(datum, '%Y')AS jahr
|
||
, DATE_Format(datum, '%Y%m%d')AS datum_sort
|
||
FROM lieder_auffuehrung
|
||
WHERE VAID =$user_vaid
|
||
AND art = '$art'
|
||
AND Nr = '$nummer'
|
||
AND zusatz $zusatz
|
||
AND status = 'G'
|
||
ORDER BY datum_sort DESC
|
||
LIMIT 0,$more_gd
|
||
";
|
||
$result_gd = $db->query($query_gd);
|
||
|
||
while ($row_gd = $result_gd->fetch_array()) {
|
||
$result = $rate->getAllPost("$row_gd[laid]");
|
||
if(!empty($result)) {
|
||
$i=0;
|
||
foreach ($result as $tutorial) {
|
||
$star = "";
|
||
for($i=1;$i<=10;$i++) {
|
||
$selected = "";
|
||
if(!empty($tutorial["rating"]) && $i<=$tutorial["rating"]) {
|
||
$selected = "selected";
|
||
}
|
||
$star .= "<li class='$selected' onmouseover=\"highlightStar(this,$tutorial[id]);\" onmouseout=\"removeHighlight($tutorial[id]);\" onClick=\"addRating(this,$tutorial[id]);\">★</li>";
|
||
}
|
||
}
|
||
}
|
||
if($row_gd['vaid'] == $user_vaid){
|
||
$enable_del = 1;
|
||
}else{
|
||
$enable_del = 0;
|
||
}
|
||
|
||
|
||
$wochentag = date("l", mktime(0,0,0,$row_gd['monat'],$row_gd['tag'],$row_gd['jahr']));
|
||
|
||
switch($wochentag){
|
||
case 'Sunday':
|
||
$wochentag_wt = "So.";
|
||
break;
|
||
case 'Monday':
|
||
$wochentag_wt = "Mo.";
|
||
break;
|
||
case 'Tuesday':
|
||
$wochentag_wt = "Di.";
|
||
break;
|
||
case 'Wednesday':
|
||
$wochentag_wt = "Mi.";
|
||
break;
|
||
case 'Thursday':
|
||
$wochentag_wt = "Do.";
|
||
break;
|
||
case 'Friday':
|
||
$wochentag_wt = "Fr.";
|
||
break;
|
||
case 'Saturday':
|
||
$wochentag_wt = "Sa.";
|
||
break;
|
||
}
|
||
|
||
$row_gd['datum_form'] = "$wochentag_wt, ".$row_gd['datum_form'];
|
||
$row_gd['tutorial_enable_del'] = $enable_del;
|
||
$row_gd['tutorial_id'] = $tutorial["id"];
|
||
$row_gd['tutorial_rating'] = $tutorial["rating"];
|
||
$row_gd['tutorial_star'] = $star;
|
||
$value_gd[] = $row_gd;
|
||
}
|
||
$smarty->assign('table_data2', $value_gd);
|
||
|
||
|
||
|
||
# Chorproben auslesen
|
||
if(!isset($_GET["more_chor"])){
|
||
$more_chor = 5;
|
||
setcookie("more_chor","$more_chor");
|
||
}else{
|
||
$more_chor = $_COOKIE["more_chor"]+5;
|
||
setcookie("more_chor","$more_chor");
|
||
}
|
||
|
||
$result_vorh_chor = $db->query( "SELECT count(*) Anz
|
||
FROM lieder_auffuehrung
|
||
WHERE VAID =$user_vaid
|
||
AND art = '$art'
|
||
AND Nr = '$nummer'
|
||
AND zusatz $zusatz
|
||
AND status = 'C'"
|
||
);
|
||
$row_vorh_chor = $result_vorh_chor->fetch_array();
|
||
$smarty->assign('liedanzeige_anz_chor', "$row_vorh_chor[Anz]");
|
||
$smarty->assign('liedanzeige_more_chor', "$more_chor");
|
||
$query_chor = "SELECT laid
|
||
, vaid
|
||
, DATE_Format(datum, '%d.%m.%Y')AS datum_form
|
||
, DATE_Format(datum, '%d')AS tag
|
||
, DATE_Format(datum, '%m')AS monat
|
||
, DATE_Format(datum, '%Y')AS jahr
|
||
, DATE_Format(datum, '%Y%m%d')AS datum_sort
|
||
FROM lieder_auffuehrung
|
||
WHERE VAID =$user_vaid
|
||
AND art = '$art'
|
||
AND Nr = '$nummer'
|
||
AND zusatz $zusatz
|
||
AND status = 'C'
|
||
ORDER BY datum_sort DESC
|
||
";
|
||
$result_chor = $db->query($query_chor);
|
||
|
||
while ($row_chor = $result_chor->fetch_array()) {
|
||
$result = $rate->getAllPost("$row_chor[laid]");
|
||
if(!empty($result)) {
|
||
$i=0;
|
||
foreach ($result as $tutorial) {
|
||
$star = "";
|
||
for($i=1;$i<=10;$i++) {
|
||
$selected = "";
|
||
if(!empty($tutorial["rating"]) && $i<=$tutorial["rating"]) {
|
||
$selected = "selected";
|
||
}
|
||
$star .= "<li class='$selected' onmouseover=\"highlightStar(this,$tutorial[id]);\" onmouseout=\"removeHighlight($tutorial[id]);\" onClick=\"addRating(this,$tutorial[id]);\">★</li>";
|
||
}
|
||
}
|
||
}
|
||
if($row_chor['vaid'] == $user_vaid){
|
||
$enable_del = 1;
|
||
}else{
|
||
$enable_del = 0;
|
||
}
|
||
|
||
$wochentag = date("l", mktime(0,0,0,$row_chor['monat'],$row_chor['tag'],$row_chor['jahr']));
|
||
|
||
switch($wochentag){
|
||
case 'Sunday':
|
||
$wochentag_wt = "So.";
|
||
break;
|
||
case 'Monday':
|
||
$wochentag_wt = "Mo.";
|
||
break;
|
||
case 'Tuesday':
|
||
$wochentag_wt = "Di.";
|
||
break;
|
||
case 'Wednesday':
|
||
$wochentag_wt = "Mi.";
|
||
break;
|
||
case 'Thursday':
|
||
$wochentag_wt = "Do.";
|
||
break;
|
||
case 'Friday':
|
||
$wochentag_wt = "Fr.";
|
||
break;
|
||
case 'Saturday':
|
||
$wochentag_wt = "Sa.";
|
||
break;
|
||
}
|
||
|
||
$row_chor['datum_form'] = "$wochentag_wt, ".$row_chor['datum_form'];
|
||
|
||
$row_chor['tutorial_enable_del'] = $enable_del;
|
||
$row_chor['tutorial_id'] = $tutorial["id"];
|
||
$row_chor['tutorial_rating'] = $tutorial["rating"];
|
||
$row_chor['tutorial_star'] = $star;
|
||
$value_chor[] = $row_chor;
|
||
}
|
||
$smarty->assign('table_data', $value_chor);
|
||
|
||
}
|
||
|
||
if($action == 'gddatum'){
|
||
$datum = $_POST["datum_gd"];
|
||
$art=$_COOKIE["liedanzeige_art"];
|
||
$nummer=$_COOKIE["liedanzeige_nummer"];
|
||
$zusatz=$_COOKIE["liedanzeige_zusatz"];
|
||
|
||
if($zusatz == ''){
|
||
$zusatz1="IS NULL";
|
||
}else{
|
||
$zusatz1="= '$zusatz'";
|
||
}
|
||
|
||
|
||
$result_vorh = $db->query( "SELECT count(*) Anz
|
||
FROM lieder_auffuehrung
|
||
WHERE datum = '$datum'
|
||
AND VAID = '$user_vaid'
|
||
AND art = '$art'
|
||
AND nr = '$nummer'
|
||
AND zusatz $zusatz1
|
||
AND status = 'G'"
|
||
);
|
||
$row_vorh = $result_vorh->fetch_array();
|
||
if($row_vorh['Anz'] == 0){
|
||
if($zusatz == ''){
|
||
$zusatz2 = "NULL";
|
||
}else{
|
||
$zusatz2 = "'".$zusatz."'";
|
||
}
|
||
|
||
$result_1 = $db->query( "INSERT INTO lieder_auffuehrung (datum, VAID, art, Nr, zusatz, gemeinde, status)
|
||
VALUES ('$datum', '$user_vaid', '$art', '$nummer', $zusatz2, '0', 'G')");
|
||
}
|
||
echo "<meta http-equiv=\"refresh\" content=\"0; URL=".$_SERVER['PHP_SELF'] ."?load=$art $nummer $zusatz\">";
|
||
exit;
|
||
|
||
}
|
||
|
||
if($action == 'chordatum'){
|
||
$datum = $_POST["datum_chor"];
|
||
$art=$_COOKIE["liedanzeige_art"];
|
||
$nummer=$_COOKIE["liedanzeige_nummer"];
|
||
$zusatz=$_COOKIE["liedanzeige_zusatz"];
|
||
|
||
if($zusatz == ''){
|
||
$zusatz1="IS NULL";
|
||
}else{
|
||
$zusatz1="= '$zusatz'";
|
||
}
|
||
|
||
$result_vorh = $db->query( "SELECT count(*) Anz
|
||
FROM lieder_auffuehrung
|
||
WHERE datum = '$datum'
|
||
AND VAID = '$user_vaid'
|
||
AND art = '$art'
|
||
AND nr = '$nummer'
|
||
AND zusatz $zusatz1
|
||
AND status = 'C'"
|
||
);
|
||
$row_vorh = $result_vorh->fetch_array();
|
||
if($row_vorh['Anz'] == 0){
|
||
if($zusatz == ''){
|
||
$zusatz2 = "NULL";
|
||
}else{
|
||
$zusatz2 = "'".$zusatz."'";
|
||
}
|
||
$result_1 = $db->query( "INSERT INTO lieder_auffuehrung (datum, VAID, art, Nr, zusatz, gemeinde, status)
|
||
VALUES ('$datum', '$user_vaid', '$art', '$nummer', $zusatz2, '0', 'C')");
|
||
}
|
||
echo "<meta http-equiv=\"refresh\" content=\"0; URL=".$_SERVER['PHP_SELF'] ."?load=$art $nummer $zusatz\">";
|
||
exit;
|
||
}
|
||
|
||
|
||
if($action == 'del'){
|
||
$art=$_COOKIE["liedanzeige_art"];
|
||
$nummer=$_COOKIE["liedanzeige_nummer"];
|
||
$zusatz=$_COOKIE["liedanzeige_zusatz"];
|
||
$laid = $_GET["laid"];
|
||
|
||
# Nur die eigenen Bewertungen l<>schen
|
||
$result_1 = $db->query( "DELETE FROM lieder_auffuehrung WHERE laid=$laid AND vaid=$user_vaid");
|
||
|
||
echo "<meta http-equiv=\"refresh\" content=\"0; URL=".$_SERVER['PHP_SELF'] ."?load=$art $nummer $zusatz\">";
|
||
exit;
|
||
|
||
}
|
||
|
||
$smarty->assign('action', "$action");
|
||
$smarty->display("../templates/$template/lieder/$templatename");
|
||
?>
|