qbuilder/templates/report_fm_ahr_naga_default.tpl

{* title *}
{include file="reportHeader.tpl"}

{*Edited*}
<div class="report_filter">

{if $columnCount > 0}
	{* parameter *}
	{* FLDAT_von:datefrom:date,
FLDAT_bis:dateuntil:date,
Betrieb:betr:select,
Stufe5:stufe_5:select,
O500_Mahnstufe:mahnst:select,
Stufe2:stufe_2:select,
KNAME:k_name:select,
wochen:woch:select,
Reklamation:rekl:select,
Wiedervorlage:Wiedervorl:date,
Mahnen:Mahnen_ent:select,
Reserve_3:rechgut:select *}
	
		<form method="POST" action="{$smarty.server.PHP_SELF}" onSubmit="return dateFormat('datefrom:dateuntil:Wiedervorl');">
		<table id="report_filter_table" class="report_filter_table">
        <tr id="report_filter_table_submit"><td><input type=submit class="pme-filter" value="{$Query}"></td></tr>
        <tr id="report_filter_table_input">
		<td>{$filter_datefromTxt}</td><td>{$filter_datefromVal}</td><td>{$filter_dateuntilTxt}</td><td>{$filter_dateuntilVal}</td><td>{$filter_betrTxt}</td><td>{$filter_betrVal}</td><td>{$filter_stufe_5Txt}</td><td>{$filter_stufe_5Val}</td><td>{$filter_mahnstTxt}</td><td>{$filter_mahnstVal}</td><td>{$filter_stufe_2Txt}</td><td>{$filter_stufe_2Val}</td><td>{$filter_k_nameTxt}</td><td>{$filter_k_nameVal}</td><td>{$filter_wochTxt}</td><td>{$filter_wochVal}</td><td>{$filter_reklTxt}</td><td>{$filter_reklVal}</td><td>{$filter_WiedervorlTxt}</td><td>{$filter_WiedervorlVal}</td><td>{$filter_Mahnen_entTxt}</td><td>{$filter_Mahnen_entVal}</td><td>{$filter_rechgutTxt}</td><td>{$filter_rechgutVal}</td>
		</tr>
		</table>
		</form>
		
{/if}

{*Edited*}
</div>

{* variable *}
{* {$REPORT_COUNT} *}

{* field *}
{* Betrieb, Stufe2, FAGNR, FTYPE, KNDNR, KNAME, Stufe5, REDAT, O500_HW2BUCHGBETR, FLDAT_von, FLDAT_bis, FLDAT, O500_MAHNSTUFE, Next_MAHNSTUFE, ZA_1, ZA_2, ZA_3, O500_HW2BETR_OFFEN, OPDAT, O500_BELEGNR1, Ktelf, Kstra, Kdplz, Kdort, Bemerkung, Wiedervorlage, Bemerkung_2, Bearbeitet, Mahnen, User, Aenderungsdatum, User_2, Reklamation, Aenderungsdatum_u2, geplAuslief_NA, Auslief_NA, geplAuslief_GA, Auslief_GA, LKNAME, LKTELF, LKSTRA, LKDPLZ, LKDORT, Reserve_1, Reserve_3, shipment_date, customer_number_leasing, customer_name_leasing, text1, text2, Faell_Tage, Wochen, qb_id *}

{* group *}
{* ALL:SUM.O500_HW2BETR_OFFEN; *}

{* pageHeader *}
{* <p>{$Total}: {$REPORT_COUNT}</p> *}
{$form_begin}

{*Edited*}
	<!--<hr>-->

{*Edited*}
	<div id="report_content" class="report_content">

{if $columnCount > 0}

{php}
	global $phpme;
	while ($phpme->assign_rows()) {
{/php}

		{* columnHeader *}
		{if $rows_count == 1}
			<div id="report_content_header" class="report_content_header">
			<table id="report_content_header_table" class="report_content_header_table">
			<tr><td>&nbsp;</td>
			<td>{$BetriebTxt2}</td>
		<td>{$Stufe2Txt2}</td>
		<td>{$FAGNRTxt2}</td>
		<td>{$KNAMETxt2}</td>
		<td>{$Stufe5Txt2}</td>
		<td>{$REDATTxt2}</td>
		<td>{$O500_HW2BUCHGBETRTxt2}</td>
		<td>{$FLDAT_vonTxt2}</td>
		<td>{$FLDAT_bisTxt2}</td>
		<td>{$FLDATTxt2}</td>
		<td>{$O500_MAHNSTUFETxt2}</td>
		<td>{$O500_HW2BETR_OFFENTxt2}</td>
		<td>{$OPDATTxt2}</td>
		<td>{$O500_BELEGNR1Txt2}</td>
		<td>{$BemerkungTxt2}</td>
		<td>{$WiedervorlageTxt2}</td>
		<td>{$Bemerkung_2Txt2}</td>
		<td>{$BearbeitetTxt2}</td>
		<td>{$MahnenTxt2}</td>
		<td>{$AenderungsdatumTxt2}</td>
		<td>{$ReklamationTxt2}</td>
		<td>{$Aenderungsdatum_u2Txt2}</td>
		<td>{$Reserve_3Txt2}</td>
		<td>{$shipment_dateTxt2}</td>
		<td>{$customer_number_leasingTxt2}</td>
		<td>{$customer_name_leasingTxt2}</td>
		<td>{$text1Txt2}</td>
		<td>{$text2Txt2}</td>
		<td>{$WochenTxt2}</td>

			</tr>
			</table>
			{if strlen($sortInfo) > 0}
				{$sortInfo}
			{/if}
			</div>
			<div id="report_content_table" class="report_content_table">
			<table id="report_content_table_table" class="report_content_table_table">

		{/if}

		{* detail *}
		{if $rows_count % 2 == 0}
			<tr bgcolor=#E8EEFF>
		{else}
			<tr>
		{/if}

			<td nowrap>
			{$rows.link_change}
			{$rows.link_copy}
			{$rows.link_delete}
			</td>
			<td>&nbsp;{$rows.Betrieb}</td>
		<td>&nbsp;{$rows.Stufe2}</td>
		<td>&nbsp;{$rows.FAGNR}</td>
		<td>&nbsp;{$rows.KNAME}</td>
		<td>&nbsp;{$rows.Stufe5}</td>
		<td>&nbsp;{$rows.REDAT}</td>
		<td>&nbsp;{$rows.O500_HW2BUCHGBETR}</td>
		<td>&nbsp;{$rows.FLDAT_von}</td>
		<td>&nbsp;{$rows.FLDAT_bis}</td>
		<td>&nbsp;{$rows.FLDAT}</td>
		<td>&nbsp;{$rows.O500_MAHNSTUFE}</td>
		<td>&nbsp;{$rows.O500_HW2BETR_OFFEN}</td>
		<td>&nbsp;{$rows.OPDAT}</td>
		<td>&nbsp;{$rows.O500_BELEGNR1}</td>
		<td>&nbsp;{$rows.Bemerkung}</td>
		<td>&nbsp;{$rows.Wiedervorlage}</td>
		<td>&nbsp;{$rows.Bemerkung_2}</td>
		<td>&nbsp;{$rows.Bearbeitet}</td>
		<td>&nbsp;{$rows.Mahnen}</td>
		<td>&nbsp;{$rows.Aenderungsdatum}</td>
		<td>&nbsp;{$rows.Reklamation}</td>
		<td>&nbsp;{$rows.Aenderungsdatum_u2}</td>
		<td>&nbsp;{$rows.Reserve_3}</td>
		<td>&nbsp;{$rows.shipment_date}</td>
		<td>&nbsp;{$rows.customer_number_leasing}</td>
		<td>&nbsp;{$rows.customer_name_leasing}</td>
		<td>&nbsp;{$rows.text1}</td>
		<td>&nbsp;{$rows.text2}</td>
		<td>&nbsp;{$rows.Wochen}</td>

			</tr>

		{* groupFooter *}
	

		{* columnFooter *}
		{if ! $rows_next}

			</table>
            </div>
			</div>
			<div id="report_gesamt_berechnung" class="report_gesamt_berechung">
	
		
		<tr><td colspan={$columnCount}>
		{$grandTotal} 
		{$O500_HW2BETR_OFFENTxt}={$ALLGroup_SUM}
					
		</td></tr>
				
			</div>
		{/if}

{php}
	}
{/php}

	{if $rows_count == 0}
		<h5 align='center'>{'NoData'|__}</h5>
        </div>
	{/if}
	</div>
{else}
	{section name=html loop=$form_hidden}
		{$form_hidden[html]}
	{/section}
	<table class='report_content_formular_table' cellspacing='0px'>
	
		<tr>
			<td>{$BetriebTxt}</td>
			<td>{$BetriebVal}</td>
		</tr>
		<tr>
			<td>{$Stufe2Txt}</td>
			<td>{$Stufe2Val}</td>
		</tr>
		<tr>
			<td>{$FAGNRTxt}</td>
			<td>{$FAGNRVal}</td>
		</tr>
		<tr>
			<td>{$FTYPETxt}</td>
			<td>{$FTYPEVal}</td>
		</tr>
		<tr>
			<td>{$KNDNRTxt}</td>
			<td>{$KNDNRVal}</td>
		</tr>
		<tr>
			<td>{$KNAMETxt}</td>
			<td>{$KNAMEVal}</td>
		</tr>
		<tr>
			<td>{$Stufe5Txt}</td>
			<td>{$Stufe5Val}</td>
		</tr>
		<tr>
			<td>{$REDATTxt}</td>
			<td>{$REDATVal}</td>
		</tr>
		<tr>
			<td>{$O500_HW2BUCHGBETRTxt}</td>
			<td>{$O500_HW2BUCHGBETRVal}</td>
		</tr>
		<tr>
			<td>{$FLDAT_vonTxt}</td>
			<td>{$FLDAT_vonVal}</td>
		</tr>
		<tr>
			<td>{$FLDAT_bisTxt}</td>
			<td>{$FLDAT_bisVal}</td>
		</tr>
		<tr>
			<td>{$FLDATTxt}</td>
			<td>{$FLDATVal}</td>
		</tr>
		<tr>
			<td>{$O500_MAHNSTUFETxt}</td>
			<td>{$O500_MAHNSTUFEVal}</td>
		</tr>
		<tr>
			<td>{$Next_MAHNSTUFETxt}</td>
			<td>{$Next_MAHNSTUFEVal}</td>
		</tr>
		<tr>
			<td>{$ZA_1Txt}</td>
			<td>{$ZA_1Val}</td>
		</tr>
		<tr>
			<td>{$ZA_2Txt}</td>
			<td>{$ZA_2Val}</td>
		</tr>
		<tr>
			<td>{$ZA_3Txt}</td>
			<td>{$ZA_3Val}</td>
		</tr>
		<tr>
			<td>{$O500_HW2BETR_OFFENTxt}</td>
			<td>{$O500_HW2BETR_OFFENVal}</td>
		</tr>
		<tr>
			<td>{$OPDATTxt}</td>
			<td>{$OPDATVal}</td>
		</tr>
		<tr>
			<td>{$O500_BELEGNR1Txt}</td>
			<td>{$O500_BELEGNR1Val}</td>
		</tr>
		<tr>
			<td>{$KtelfTxt}</td>
			<td>{$KtelfVal}</td>
		</tr>
		<tr>
			<td>{$KstraTxt}</td>
			<td>{$KstraVal}</td>
		</tr>
		<tr>
			<td>{$KdplzTxt}</td>
			<td>{$KdplzVal}</td>
		</tr>
		<tr>
			<td>{$KdortTxt}</td>
			<td>{$KdortVal}</td>
		</tr>
		<tr>
			<td>{$BemerkungTxt}</td>
			<td>{$BemerkungVal}</td>
		</tr>
		<tr>
			<td>{$WiedervorlageTxt}</td>
			<td>{$WiedervorlageVal}</td>
		</tr>
		<tr>
			<td>{$Bemerkung_2Txt}</td>
			<td>{$Bemerkung_2Val}</td>
		</tr>
		<tr>
			<td>{$BearbeitetTxt}</td>
			<td>{$BearbeitetVal}</td>
		</tr>
		<tr>
			<td>{$MahnenTxt}</td>
			<td>{$MahnenVal}</td>
		</tr>
		<tr>
			<td>{$UserTxt}</td>
			<td>{$UserVal}</td>
		</tr>
		<tr>
			<td>{$AenderungsdatumTxt}</td>
			<td>{$AenderungsdatumVal}</td>
		</tr>
		<tr>
			<td>{$User_2Txt}</td>
			<td>{$User_2Val}</td>
		</tr>
		<tr>
			<td>{$ReklamationTxt}</td>
			<td>{$ReklamationVal}</td>
		</tr>
		<tr>
			<td>{$Aenderungsdatum_u2Txt}</td>
			<td>{$Aenderungsdatum_u2Val}</td>
		</tr>
		<tr>
			<td>{$geplAuslief_NATxt}</td>
			<td>{$geplAuslief_NAVal}</td>
		</tr>
		<tr>
			<td>{$Auslief_NATxt}</td>
			<td>{$Auslief_NAVal}</td>
		</tr>
		<tr>
			<td>{$geplAuslief_GATxt}</td>
			<td>{$geplAuslief_GAVal}</td>
		</tr>
		<tr>
			<td>{$Auslief_GATxt}</td>
			<td>{$Auslief_GAVal}</td>
		</tr>
		<tr>
			<td>{$LKNAMETxt}</td>
			<td>{$LKNAMEVal}</td>
		</tr>
		<tr>
			<td>{$LKTELFTxt}</td>
			<td>{$LKTELFVal}</td>
		</tr>
		<tr>
			<td>{$LKSTRATxt}</td>
			<td>{$LKSTRAVal}</td>
		</tr>
		<tr>
			<td>{$LKDPLZTxt}</td>
			<td>{$LKDPLZVal}</td>
		</tr>
		<tr>
			<td>{$LKDORTTxt}</td>
			<td>{$LKDORTVal}</td>
		</tr>
		<tr>
			<td>{$Reserve_1Txt}</td>
			<td>{$Reserve_1Val}</td>
		</tr>
		<tr>
			<td>{$Reserve_3Txt}</td>
			<td>{$Reserve_3Val}</td>
		</tr>
		<tr>
			<td>{$shipment_dateTxt}</td>
			<td>{$shipment_dateVal}</td>
		</tr>
		<tr>
			<td>{$customer_number_leasingTxt}</td>
			<td>{$customer_number_leasingVal}</td>
		</tr>
		<tr>
			<td>{$customer_name_leasingTxt}</td>
			<td>{$customer_name_leasingVal}</td>
		</tr>
		<tr>
			<td>{$text1Txt}</td>
			<td>{$text1Val}</td>
		</tr>
		<tr>
			<td>{$text2Txt}</td>
			<td>{$text2Val}</td>
		</tr>
		<tr>
			<td>{$Faell_TageTxt}</td>
			<td>{$Faell_TageVal}</td>
		</tr>
		<tr>
			<td>{$WochenTxt}</td>
			<td>{$WochenVal}</td>
		</tr>
	</table>
	</div>

	{* using translate : {'add'|__} *}
	{* for value : $rows.keyname *}
{/if}

{if $columnCount > 0}
	{include file="listButtons.tpl"}
{else}
	{include file="recordButtons.tpl"}
{/if}

{* summary *}

{* pageFooter *}
{$form_end}
{include file="reportFooter.tpl"}