#
#	ITSV-GmbH
#	CCDB - Command and Control Database
#
#	FILE:				dquerymfile_SOIDEDITOR.txt
#	DESCRIPTION:		DQUERY definitions for CCDB-query SOIDEDITOR
#
#	AUTHOR:				Wolfgang Scherer
#	VERSION:			1.0
#	ISSUE:				14.10.2019
#
@querytitle			Bearbeite Regelwerk der Lohnsoftware-SOIDs
@querydescription	Zeigt alle bekannten SOIDs an und erlaubt die Bearbeitung
@group				SVCLMVBRFAUSWDATALOAD
@querytype			dbselect
@sql				SELECT soid.SOID as SOID,soid.LSWID as LSWID,lsw.LSWID as LSW_LSWID, lsw.LSWATTRIBS as LSWATTRIBUTE, lsw.LSWID as LSWINFOLINK
					  FROM SVCLRWSOID soid
						left outer join SVCLRWLSW lsw on lsw.LSWID=soid.LSWID
					  order by soid.SOID asc
@pre_query
	if (that.query.previous_result) {
		let tt = "";
		if (that.query.toptext) {
			tt = that.query.toptext;
		}
		tt += "\r\n<h3>Ergebnis der letzten Aktion</h3>\r\n<pre>\r\n"+aux.objTxt(that.query.previous_result,99,999999)+"\r\n</pre>\r\n";
	}
@post_query
	let crow;
	for (let ri=0; ri<that.result.length; ri++) {
		crow = that.result.getRowObject(ri);
		that.result.setRowAttribute(ri,'__ANCHOR',aux.fixedEncodeURIComponent(crow.SOID));
	}
@toptext
	<h3>Weitere Aktionen</h3>
	<ul>
		<li><a href="/dquery?dataname=SOIDEDITOR">Neu Anzeigen</a></li>
	</ul>
@tableclass			excelFilterTable
#
@decoration.decorate_colcell.SOID.rawhtml	<a name="@@row.__ANCHOR@@">@@row.SOID@@</a>
#
@decoration.decorate_colcell.LSWID		$CONTROL:lswideingabe:lswideoptions
@lswideoptions.control_type				edit
@lswideoptions.value					@@celldata@@
@lswideoptions.url						/dquery?dataname=performObjectAction&objtype=svcllsw&key=@@row.LSWID@@&attribute=LSWID&action=SET&return_to=SOIDEDITOR&return_fragment=@@row.__ANCHOR@@
@lswideoptions.submitlabel				geänderte LSW-ID speichern
@lswideoptions.textinput_fieldname		value
#
@decoration.decorate_colcell.LSWATTRIBUTE	$CONTROL:lswattribseingabe:lswaeoptions
@lswaeoptions.control_type					edit
@lswaeoptions.url							/dquery?dataname=performObjectAction&objtype=svcllsw&key=@@row.LSWID@@&attribute=LSWATTRIBS&action=SET&return_to=SOIDEDITOR&return_fragment=@@row.__ANCHOR@@
@lswaeoptions.submitlabel					geänderte LSW-Attribute speichern
@lswaeoptions.textinput_fieldname			value
@lswaeoptions.input.size					70
#
@decoration.decorate_colcell.LSWINFOLINK.hyperlink.href		/dquery?dataname=LSWinfo&LSWID=@@row.LSWID@@
@decoration.decorate_colcell.LSWINFOLINK.hyperlink.title	Information über Lohnsoftware @@row.LSWID@@ anzeigen
#
@title									Lohnsoftware-Software-IDs (SOIDs) und Zuordnung zu Lohnsoftware-Produkten