set sys#echo = OFF;
set sys#usetag = ON;
<LKHTPL>
string TPL_NAME = "../scripts/v2evaluations.lkhtpl";
string TPL_ACTION = GetStrVar("cgv#TPL_ACTION");
int ParentID = GetIDFromIDString("BEWERTUNGSSERVICE_LISTE");

db_result dbres;

string REDA_REDASITES = GetStrVar("cnf#REDA_REDASITE_VERZ");
addUebergabeVar(REDA_REDASITES);

string SiteOpenTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2open.lkhtpl";
string SiteCloseTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2close.lkhtpl";

//printbr("schreibe Seitenkopf");
string Headline = "Bewertungsservice";
addUebergabeVar(Headline);
ExecLKHTpl(dbres,SiteOpenTPL);

int Fehler = 0;

if(TPL_ACTION == "sendForm"){

	println("				<!-- Beginn Inhalt -->");
	println("				<table width=\"100%\" cellspacing=\"5\" cellpadding=\"3\" border=\"0\">");
	println("				<tr>");
	println("					<td align=\"center\">");
	println("						<div class=\"paraHL\">Schreiben Sie Ihre Meinung und bewerten Sie uns:</div><br>");
	println("						Bitte f&uuml;llen Sie alle Felder unbedingt aus!");
	println("					</td>");
	println("				</tr>");
	println("                <tr>");
	println("					<td align=\"center\">");
	
	println("<script src=\"../scripts/v2formular.js\" type=\"text/javascript\"></script>");
	println("<script>");
	println("function pruefeRadio(feld){");
	println("	for(i = 0; i < feld.length; i ++){");
	println("		if(feld[i].checked){return true;}");
	println("	}");
	println("	alert('Bitte geben Sie eine Wertung ab');");
	println("	return false;");
	println("}");
	println("function checkForm(form){");
	println("	if( pruefeString(form.name, 'name') &&");
	println("		pruefeString(form.vorname, 'vorname') &&");
	println("		pruefeRadio(form.wertung) &&");
	println("		pruefeString(form.text, 'text'))");
	println("	{");
	//println("		alert('submit');");
	println("		form.submit();");
	println("	}");
	println("}");
	println("function resetForm(form){");
	println("	form.reset();");
	println("}");
	println("</script>");
	
	println("	                    <table cellspacing=\"5\" cellpadding=\"3\" border=\"0\">");
	println("						<form name=\"Formular\" id=\"Formular\" action=\"$(TPL_NAME)\" method=\"get\">");	
	println("						<input type=\"hidden\" name=\"TPL_ACTION\" value=\"insertEntry\">");	
	println("	                    <tr>");
	println("							<td align=\"right\">Name:</td>");
	println("							<td><input type=\"text\" name=\"name\" size=\"25\"></td>");
	println("						</tr>");
	println("	                    <tr>");
	println("							<td align=\"right\">Vorname:</td>");
	println("							<td><input type=\"text\" name=\"vorname\"  size=\"25\"></td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td align=\"right\">Sehr gut:</td>");
	println("							<td><input type=\"radio\" name=\"wertung\" value=\"3\"></td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td align=\"right\">Gut:</td>");
	println("							<td><input type=\"radio\" name=\"wertung\" value=\"2\"></td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td align=\"right\">Neutral:</td>");
	println("							<td><input type=\"radio\" name=\"wertung\" value=\"1\"></td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td align=\"right\">Schlecht:</td>");
	println("							<td><input type=\"radio\" name=\"wertung\"  value=\"0\"></td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td colspan=\"2\">Bewertungskommentar:</td>");
	println("						</tr>");
	println("						<tr>");
	println("							<td colspan=\"2\"><textarea name=\"text\" rows=\"3\" cols=\"42\"></textarea></td>");
	println("						</tr>");
	println("						<tr>");
	println("						    <td colspan=\"2\" align=\"center\">");
	println("								<table cellspacing=\"2\" cellpadding=\"2\" border=\"0\" width=\"100%\">");
	println("								<tr>");
	println("								    <td align=\"center\"><input type=\"button\" onclick=\"resetForm(Formular);\" value=\"Formular zurücksetzen\"></td>");
	println("									<td align=\"center\"><input type=\"button\" onclick=\"checkForm(Formular);\" value=\"Formular senden\"></td>");
	println("								</tr>");
	println("								</table>");
	println("							</td>");
	println("						</tr>");
	println("						</form>");
	println("						</table>");	
	
	println("					</td>");
	println("				</tr>");
	println("				</table><br>");
	println("				<!-- Ende Inhalt -->");

}
else {

	if(TPL_ACTION == "insertEntry"){
		
		string name = GetStrVar("cgv#name");
		string vorname = GetStrVar("cgv#vorname");
		string wertung = GetStrVar("cgv#wertung");
		string text = GetStrVar("cgv#text");
		
		//printbr("$(ParentID) - $(vorname) $(name) - $(wertung)");
		//printbr("$(text)");
		
		if(database db = MySQLOpen(rdv#std_server,rdv#std_user,rdv#std_passwd,rdv#std_db,0)){	
			
			int EntryID = 0;		
			// Wert aus id Tabelle auslesen und um eins erhöhen
			string Query =  "select id from id where tabelle = 'evaluation';";
			if(db_result dbres = MySQLGetQueryResult(db,Query)){foreach(dbres;row){EntryID = row["id"];}}		
			int setID = EntryID + 1;
			MySQLExecQuery(db,"update id set id=$(setID) where tabelle = 'evaluation';");	
			
			//printbr("EntryID: $(EntryID)");		
			if(EntryID > 0){
			
				// Speichern der Bewertung
				Query =  "INSERT INTO evaluation (id,parentid,tabelle,vorname,name,wertung,text)";
				Query += " VALUES ($(EntryID),$(ParentID),'main','$(vorname)','$(name)','$(wertung)','$(text)');";
				//printbr("$(Query)");
				if(MySQLExecQuery(db,Query) == 0){					
					Fehler = 3;
				}
			
			}
			else{
				Fehler = 2;
			}
			
		}
		else{
			Fehler = 1;
		}
	
		println("				<!-- Beginn Inhalt -->");
		println("				<table width=\"100%\" cellspacing=\"5\" cellpadding=\"3\" border=\"0\">");
		println("				<tr>");
		println("					<td align=\"center\">");
		if(Fehler == 0){
			println("						<div>Vielen Dank für Ihre Bewertung</div>");
		}		
		else{		
			println("						<div class=\"paraHL\">Es ist ein Fehler aufgetreten</div><br>");
			println("						<div>Fehlercode: $(Fehler) - Bitte wenden Sie sich an <a href=\"mailto:error@trust-halle.de?subject=BewertungsserviceFehlercode$(Fehler)\">error@trust-halle.de</a></div>");
		
		}
		println("					</td>");
		println("				</tr>");
		println("				</table><br>");
		println("				<!-- Ende Inhalt -->");
	
	}
	
	if(Fehler == 0){

		println("				<!-- Beginn Inhalt -->");
		println("				<table width=\"100%\" cellspacing=\"5\" cellpadding=\"3\" border=\"0\">");
		println("				<tr>");
		println("					<td align=\"center\"><div class=\"paraHL\">Liste der Bewertungen</div></td>");
		println("				</tr>");
		
		int i, ContentCnt = 0;		
		string StarStr, Query;
				
		if(database db = MySQLOpen(rdv#std_server,rdv#std_user,rdv#std_passwd,rdv#std_db,0)){
								
			Query = "select evaluation.name, evaluation.vorname, evaluation.text, evaluation.wertung,";
			Query += " date_format(evaluation.datum,'%d.%b %Y') as datum,";
			Query += " date_format(evaluation.datum,'%H:%i') as time";			
			Query += " from evaluation";
			Query += " inner join ordner on ordner.id = evaluation.parentid";
			Query += " inner join main on main.id = ordner.DataID";
			Query += " where (evaluation.parentid = $(ParentID) and evaluation.tabelle = 'main' and evaluation.status = 'Y')";
			Query += " and ordner.aktiv = 'Y'";
			Query += " order by evaluation.datum desc";
			Query += ";";
			//printbr("$(Query)");			
			if(dbres = MySQLGetQueryResult(db,Query)){
				ContentCnt = MySQLGetResZeilen(dbres);				
				foreach(dbres;row){
				
					StarStr = "<img src=\"../images/stern.gif\" width=\"13\" height=\"12\" border=\"0\">";
					for(i = 0; i < row["wertung"]; i++){					
						StarStr += "<img src=\"../images/stern.gif\" width=\"13\" height=\"12\" border=\"0\">";
					}
					println("				<tr><td><hr></td></tr>");
					println("				<tr>");
					println("					<td>");
					printbr("						<span class=\"paraHLsub\"> $(row[\"name\"]), $(row[\"vorname\"])</span> ($(row[\"datum\"])) $(StarStr)<br>");
					println("						$(row[\"text\"])");
					println("					</td>");
					println("				</tr>");	
					
				}
			}

		}
		
		if(ContentCnt == 0){
		
			println("				<tr>");
			println("					<td align=\"center\">Es wurden noch keine Bewertungen abgegeben !</td>");
			println("				</tr>");
		
		}
		
		if(TPL_ACTION != "insertEntry"){
			
			println("				<tr><td><hr></td></tr>");
			println("				<tr>");
			println("					<td align=\"center\">");
			println("						<form action=\"../scripts/v2evaluations.lkhtpl\" method=\"get\">");
			println("							<input type=\"hidden\" name=\"TPL_ACTION\" value=\"sendForm\">");
			println("							<input type=\"submit\" style=\"width:180px\" value=\"eigene Bewertung abgeben\">");		
			println("						</form>");
			println("					</td>");
			println("				</tr>");
		
		}
	
		println("				</table><br>");
		println("				<!-- Ende Inhalt -->");		
	
	}

}
	
//printbr("schreibe Seitenfuß");
ExecLKHTpl(dbres,SiteCloseTPL);
</LKHTPL>