set sys#echo = OFF;
set sys#usetag = ON;
<script>
if(parent.frames.length == 0){
   document.location.href = '/scripts/loadFrameSet.lkhtpl?PageURL=' + this.location.href;
}
</script>
<LKHTPL>
string PageName = GetStrVar("cgv#PageName");
// printbr("PageName: $(PageName)");

if(database db = MySQLOpen(rdv#std_server,rdv#std_user,rdv#std_passwd,rdv#std_db,0)){

   string TPL_NAME = "/scripts/v2artikelliste.lkhtpl";
   int LimitStart = GetIntVar("cgv#LimitStart");
   int Limit = 10;

   db_result dbres, datares;
   db_row row;
   string Query;

   int PageID = 0;
   //printbr("PageID: $(PageID)");
   //printbr("PageName: $(PageName)");
   Query = "select ordner.* from ordner where ordner.name = '$(PageName)' and ordner.OrdnerStrang = 19;";
   //printbr("$(Query)");
   if(datares = MySQLGetQueryResult(db,Query)){
      foreach(datares;row){
         PageID = row["id"];
      }
   }
   //printbr("PageID: $(PageID)");

   int ContentCnt = 0, ForeachCnt = 0, DataID, ID = PageID;

   // aktueller Mehrwertsteuersatz
   double SteuerSatz = 19.00;

   string REDA_REDASITES = GetStrVar("cnf#REDA_REDASITE_VERZ");
   string REDA_STYLE_TABLE = "shop";

   string SiteOpenTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2open.lkhtpl";
   string SiteParaTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2artikel_para.lkhtpl";
   string SiteFooterTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2artikel_footer.lkhtpl";
   string SiteNoParaTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2nopara.lkhtpl";
   string SiteCloseTPL = "/var/www/vhosts/geosysteme.de/lkh_prg/newreda/v2close.lkhtpl";

   addUebergabeVar(ID);
   addUebergabeVar(SteuerSatz);
   addUebergabeVar(REDA_STYLE_TABLE);
   addUebergabeVar(REDA_REDASITES);

   //printbr("schreibe Seitenkopf");
   ExecLKHTpl(dbres,SiteOpenTPL);

   if(PageID > 0){

      println("            <style>");
      println("            .bluetxt {color : #08739F;}");
      println("            .graytxt {color : #808080;}");
      println("            </style>");
      println("            <script>");

      println("            /* INCLUDE Function */");
      println("            /* dynform.js */");
      println("            var form = parent.form;");
      println("            DelKnoten = parent.DelKnoten;");
      println("            AddForm = parent.AddForm;");
      println("            AddKnoten = parent.AddKnoten;");
      println("            showFormular = parent.showFormular;");
      println("            submitFormular = parent.submitFormular;");
      println("            DelKnoten = parent.DelKnoten;");

      println("            function sendForm(LimitStart){");

      println("               var input_form = document.getElementById('InputFormular');");

      println("               var form = this.form;");
      println("               DelKnoten(form);");
      println("               AddForm(form,'main','$(TPL_NAME)');");
      println("               AddKnoten(form,'PageName','$(PageName)');");
      //println("               AddKnoten(form,'preis',(LimitStart) ? '$(preis)' : input_form.preis.value);");
      println("               AddKnoten(form,'LimitStart',(LimitStart) ? LimitStart : '0');");
      //println("               showFormular(form);");
      println("               submitFormular(form);");
      println("               DelKnoten(form);");

      println("            }");
      println("            </script>");

      int SearchHit = 0;
      string SearchHitStr = "";

      Query = "select if((datenblatt.nettopreis_home_geosys > 0),datenblatt.nettopreis_home_geosys,shop.npreis_geosys) as nettopreis";
      Query += " from ordner";
      Query += " inner join shop on shop.id = ordner.DataID";
      Query += " left join datenblatt on datenblatt.blattArtNr = shop.artnr";
      Query += " where (ordner.parent = $(PageID) and ordner.aktiv = 'Y' and ordner.DataID != '')";
      //Preis mit 0 entspricht preis auf Anfrage
      //Query += " and shop.npreis_geosys > 0";
      Query += " and shop.aktiv_geosys = 'Y'";
      Query += " order by nettopreis";
      Query += ";";
      //printbr("$(Query)");
      if(datares = MySQLGetQueryResult(db,Query)){SearchHit = MySQLGetResZeilen(datares);}

      if(SearchHit > 0){

         SearchHitStr += "            <!-- Beginn Anzeige der Trefferquote -->";
         SearchHitStr += "            <table width=\"100%\" cellspacing=\"3\" cellpadding=\"2\" border=\"0\">\n";
         SearchHitStr += "            <tr>\n";
         SearchHitStr += "               <td align=\"left\" class=\"bluetxt\"><strong>Ergebnisse</strong> $(LimitStart + 1)-$(((LimitStart + Limit) < SearchHit) ? LimitStart + Limit : SearchHit) von $(SearchHit)</td>\n";
         int Pages = (SearchHit%Limit > 0) ? (SearchHit/Limit) + 1 : SearchHit/Limit;
         if(Pages > 1){
            SearchHitStr += "               <td align=\"right\">\n";
            for(int i = 0; i < Pages; i ++){
               if((LimitStart/Limit) == i){
                  SearchHitStr += "             $(i+1)&nbsp;</strong>\n";
               }
               else{
                  SearchHitStr += "             <a href=\"javascript:sendForm('$(Limit*i)')\">$(i+1)</a>&nbsp;\n";
               }
            }
            SearchHitStr += "            </td>\n";
         }
         SearchHitStr += "            </tr>\n";
         SearchHitStr += "            <tr><td colspan=\"3\"><hr></td></tr>\n";
         SearchHitStr += "            </table>\n";
         SearchHitStr += "            <!-- Ende Anzeige der Trefferquote -->";

      }

      Query = "select ordner.id as OrdnerID, shop.*,";
      Query += " if((datenblatt.nettopreis_home_geosys > 0),datenblatt.nettopreis_home_geosys,shop.npreis_geosys) as nettopreis,";
      Query += " if((datenblatt.show_home_geosys = 'Y'),'Y','N') as show_home,";
      Query += " if((datenblatt.angebots_text != ''),datenblatt.angebots_text,'') as angebots_text";
      Query += " from ordner";
      Query += " inner join shop on shop.id = ordner.DataID";
      Query += " left join datenblatt on datenblatt.blattArtNr = shop.artnr";
      Query += " where (ordner.parent = $(PageID) and ordner.aktiv = 'Y' and ordner.DataID != '')";
      //Preis mit 0 entspricht preis auf Anfrage
      //Query += " and shop.npreis_geosys > 0";
      Query += " and shop.aktiv_geosys = 'Y'";
      Query += " order by nettopreis";
      Query += " limit $(LimitStart),$(Limit)";
      Query += ";";
      //printbr("$(Query)");
      if(datares = MySQLGetQueryResult(db,Query)){
         ContentCnt = MySQLGetResZeilen(datares);
         if(ContentCnt > 0){
            println("$(SearchHitStr)");
            foreach(datares;row){

               ForeachCnt = foreachcount#;
               DataID = row["id"];

               addUebergabeVar(ContentCnt);
               addUebergabeVar(ForeachCnt);
               addUebergabeVar(DataID);

               //printbr("schreibe Absatz $(row[\"id\"])");
               ExecLKHTpl(datares,SiteParaTPL);

            }
            println("$(SearchHitStr)");
         }
         else {

            //printbr("schreibe keinen Absatz vorhanden");
            ExecLKHTpl(dbres,SiteNoParaTPL);

         }

      }

      //printbr("schreibe Shopfuß");
      ExecLKHTpl(dbres,SiteFooterTPL);

   }
   else{

      //printbr("schreibe keinen Absatz vorhanden");
      ExecLKHTpl(datares,SiteNoParaTPL);


   }

   //printbr("schreibe Seitenfuß");
   ExecLKHTpl(dbres,SiteCloseTPL);

}
else{
   println("$(MySQLStatus())");
}
</LKHTPL>