<?
session_start();
include ("include/db_params.php");
include ("include/dbconnect.php");
include ("include/facmaadmin.php");

/* Gibt Frameset-Definitionen aus; Aufruf: design.php&design=designnr
*/

$design=$_GET["design"];

/* Lesen und Versionenkontrolle design, gefundene id(design_ctrl) in $design_nr */
$SQLString="SELECT * FROM design WHERE id = $design";
if(!$design_rec = mysql_db_query($facma_db, $SQLString))
  echo $SQLString." Not Okay (".$facma_db.")";
$version=0;
/* Admin? */
if($facma_admin == 9)
  if((mysql_result($design_rec, 0, "d1_status") == "n") or (mysql_result($design_rec, 0, "d2_status") == "n"))
    if(mysql_result($design_rec, 0, "d1_status") == "n")
      $version = 1;
    else
      $version = 2;
/* nein oder kein Entwurf vorhanden */
if($version==0)
  if(mysql_result($design_rec, 0, "d1_status") == "a")
    $version = 1;
  else if(mysql_result($design_rec, 0, "d2_status") == "a")
       $version = 2;
if($version == 1)
  $design_nr = mysql_result($design_rec,0,"d1_id");
else if($version == 2)
     $design_nr = mysql_result($design_rec,0,"d2_id");

if($version==0)
  echo "NO DESIGN";
else
  {
/* Aufbau frame_id-Tabelle, Index = Framebezeichnung */
   $top=0; $left=1; $right=2; $bottom=3; $maintop=4; $main=5; $mainbottom=6;
   $SQLString = "SELECT * FROM design_ctrl WHERE id = $design_nr";
   $design_ctrl_tab = mysql_db_query($facma_db, $SQLString);
   $design_ctrl_rec = mysql_fetch_array($design_ctrl_tab);
   if(isset($design_ctrl_rec["param"]))
     if($design_ctrl_rec["param"]>" ")
       $_SESSION["param"]=$design_ctrl_rec["param"];
     else if(isset($_SESSION["param"]))
       {
        unset($_SESSION["param"]);
        if(isset($_SESSION["param"]))
          session_unregister('param');

       }
   if(isset($_SESSION["param"]))
     include($_SESSION["param"]);
   else
     include ("include/params.php");
   include ("include/user_requests.php");
   include ("include/functions.php");

   $center=false;
   if((isset($design_ctrl_rec["zentrieren"])) and ($design_ctrl_rec["zentrieren"]=="Y"))
     $center=true;

   user_request(0,0);
   if($facma_admin!=0)
     update_directories();

   $frame_id[$top] = $design_ctrl_rec["top"];
   $frame_width[$top]=$design_ctrl_rec["topwidth"];
   $frame_id[$left] = $design_ctrl_rec["lleft"];
   $frame_width[$left]=$design_ctrl_rec["leftwidth"];
   $frame_id[$right] = $design_ctrl_rec["rright"];
   $frame_width[$right]=$design_ctrl_rec["rightwidth"];
   $frame_id[$bottom] = $design_ctrl_rec["bottom"];
   $frame_width[$bottom]=$design_ctrl_rec["bottomwidth"];
   $frame_id[$maintop] = $design_ctrl_rec["maintop"];
   $frame_width[$maintop]=$design_ctrl_rec["maintopwidth"];
   $frame_id[$main] = $design_ctrl_rec["main"];
   $frame_width[$main]=$design_ctrl_rec["mainwidth"];
   $frame_id[$mainbottom] = $design_ctrl_rec["mainbottom"];
   $frame_width[$mainbottom]=$design_ctrl_rec["mainbottomwidth"];

/* Ermitteln Framesets: frame_id>0 bedeutet, dass Frame definiert ist */
   $frame0 = false; $frame1 = false;
   if (($frame_id[$top] > 0) or ($frame_id[$bottom] > 0))
     $frame0 = true;
   if (($frame_id[$left] > 0) or ($frame_id[$right] > 0))
     $frame1 = true;
   $frame2 = 0;
   if ($frame_id[$maintop] > 0)
     $frame2++;
   if ($frame_id[$main] > 0)
     $frame2++;
   if ($frame_id[$mainbottom] > 0)
     $frame2++;
   if ($frame2 > 1)
     $frame2 = true;
   else
     $frame2 =false;

   for($x=0;$x<7;$x++)
     {
      if($frame_id[$x] > 0)
        {

         $SQLString= "SELECT * FROM design_det WHERE id = $frame_id[$x]";
         $recordtab = mysql_db_query($facma_db, $SQLString);
         $frame[$x] = mysql_fetch_array($recordtab);
         $SQLString = "SELECT * FROM view WHERE log_id = '".$frame[$x]["defview"]."'";
         if(!$view_rec = mysql_db_query($facma_db, $SQLString))
           echo $SQLString." Not Okay";
         if((mysql_num_rows($view_rec)>0) and ((mysql_result($view_rec,0,"dok1")>" ") or (mysql_result($view_rec,0,"dok2")>" ")))
           {

            $frame[$x]["dok1_status"]=mysql_result($view_rec,0,"v1_status");
            $frame[$x]["dok2_status"]=mysql_result($view_rec,0,"v2_status");
            $frame[$x]["dok1"]=mysql_result($view_rec,0,"dok1");
            $frame[$x]["dok2"]=mysql_result($view_rec,0,"dok2");
           }
         else if(mysql_num_rows($view_rec)>0)
           {
            $frame[$x]["dok1_status"]="";
            $frame[$x]["dok2_status"]="";
           }
        }
     }

/* Ausgabe der notwendigen Frameset-Definitionen */
   $leerframename="leer".$design.".htm";
   if (!file_exists($leerframename))
     $leerframename="leer.htm";
   $logoframename="logo.htm";
   if (!file_exists($logoframename))
     $logoframename="leer.htm";

   $leerframe="<frame src='$leerframename' name='leer' frameborder='0' ' marginwidth='0' ' marginheight='0' scrolling='no' noresize>\n";
   $logoframe="<frame src='$logoframename' name='leer' frameborder='0' ' marginwidth='0' ' marginheight='0' scrolling='no' noresize>\n";
   if($facma_admin == 9)
     {
      echo "<frameset rows='30,*' framespacing='0' frameborder='0' border='0'>\n";
      echo "<frame name='designcontrol' src='designwork.php?design=".$design."' marginwidth='0' marginheight='0' frameborder='0' noresize scrolling='no'>\n";
     }
   if ($frame0 == true)
     {
      if($center==true)
        {
         $centerwidth=0;
         if($frame_id[$left]>0)
           $centerwidth=$centerwidth+$frame_width[$left];
         if($frame_id[$main]>0)
           $centerwidth=$centerwidth+$frame_width[$main];
         if($frame_id[$right]>0)
           $centerwidth=$centerwidth+$frame_width[$right];
         echo "<frameset cols='*,".$centerwidth.",*' framespacing='0' frameborder='0' border='0'>\n";
         echo $leerframe;
        }
      echo "<frameset rows='";
      if($frame_id[$top]>0)
        echo $frame_width[$top].",";
/* Aufgrund der Gegebenheit bei SP Wichtrach bin ich der Meinung, dass mainwidth immer nur die Breite, nie 
   die Höhe des Mainframe bedeuten kann. Das ist mit anderen Sites/Designs nicht ausgetestet. Deshalb immer
   ausgabe von width= "*"
      if(($frame_width[$main]>0) && ($frame1 == false))
        echo $frame_width[$main].",";
      else
*/
        echo "*,";
      if($frame_id[$bottom]>0)
        echo $frame_width[$bottom];
      echo "' framespacing='0' frameborder='0' border='0'>\n";
      if($frame_id[$top]>0)
        {
         out_frame($top, "top"); 
        }
     }
   if ($frame1 == true)
     {
      if(($center==true) and ($frame0 ==false))
        echo "<frameset cols='*,";
      else
        echo "<frameset cols='"; 
      if($frame_id[$left]>0)
        if($frame_width[$left]>0)
          echo $frame_width[$left].",";
        else
          echo "*,";
      if($frame_width[$main]>0)
        echo $frame_width[$main].",";
      else
        echo "*,";
      if($frame_id[$right]>0)
        if($frame_width[$right]>0)
          echo $frame_width[$right];
        else
          echo "*,";
      if(($center==true) and ($frame0 ==false))
        echo "*";      
      echo "' framespacing='0' frameborder='0' border='0'>\n";
      if(($center==true) and ($frame0 ==false))
        echo $leerframe;        
      if($frame_id[$left]>0)
        {
         out_frame($left,"left");
        }
     }
   if ($frame2 == true)
     {
      if(($frame0==false) and ($frame1==false) and ($center==true))
        {
         echo "<frameset cols='*,".$frame_width[$main].",*' framespacing='0' frameborder='0' border='0'>\n";
         echo $leerframe;
        }
      echo "<frameset rows='";
      if($frame_id[$maintop]>0)
        echo $frame_width[$maintop].",";
      echo "*,";
      if($frame_id[$mainbottom]>0)
        echo $frame_width[$mainbottom];
      echo "' framespacing='0' frameborder='0' border='0'>\n";
      if($frame_id[$maintop]>0)
        {
         out_frame($maintop,"maintop");
        } 
      out_frame($main,"main");
      if($frame_id[$mainbottom]>0)
        {
         out_frame($mainbottom,"mainbottom");
        }
      echo "</frameset>\n";
      if(($frame0==false) and ($frame1==false) and ($center==true))
        {
         echo $logoframe;
         echo "</frameset>\n";
        }
     }
   else
     {
      if($frame0 == true or $frame1 == true)
        out_frame($main,"main");
      else
        {
/* main einziges Frame */
         echo "<frameset cols='";
         if(($center==true) or ($frame_width[$main]>0))
           echo "<frameset cols='*,";
         if($frame_width[$main]>0)
           echo $frame_width[$main].",";
         else
           echo "*";
         if(($center==true) or ($frame_width[$main]>0))         
           echo ",* ";
         echo "' framespacing='0' frameborder='0' border='0'>\n";
         if(($center==true) or ($frame_width[$main]>0))
           echo $leerframe;
         out_frame($main,"main");
         if(($center==true) or ($frame_width[$main]>0))
           echo $logoframe;
         echo "</frameset>\n";
        }
     }
   if ($frame1 == true)
     {
      if($frame_id[$right]>0)
        {
         out_frame($right,"right");
        }
      if(($center==true) and ($frame0 ==false))
        echo $logoframe; 
      echo "</frameset>\n";
     }  
   if ($frame0 == true)
     {
      if($frame_id[$bottom]>0)
        {
         out_frame($bottom,"bottom");
        }
      echo "</frameset>\n";
      if($center==true)
        {
         echo $logoframe;
         echo "</frameset>\n";         
        }
     } 

   if($facma_admin == 9)  
     echo "</framset>\n";
  }

/* Funktion gibt <frame mit Paramtern aus 

$frame_x = Index zu ass. Array ab Db-tab design
*/
function out_frame($frame_x, $frame_name)
  {

   global $frame;
   global $facma_admin;
   $framestring="<frame src='";
/* Paramter zu aufgerufener View: View-nr, width (errechnet oder ab DB) und bgcolor  */
   /* Admin? */
   if($facma_admin == 9)
     if(($frame[$frame_x]["dok1_status"] == "n") or ($frame[$frame_x]["dok2_status"] == "n"))
       if ($frame[$frame_x]["dok1_status"] == "n")
           $framestring.=$frame[$frame_x]["dok1"];
       else
           $framestring.=$frame[$frame_x]["dok2"];
/* nein oder kein Entwurf vorhanden */
   if($framestring=="<frame src='")
     if($frame[$frame_x]["dok1_status"]=="a")
        $framestring.=$frame[$frame_x]["dok1"];
     else if($frame[$frame_x]["dok2_status"]=="a")
        $framestring.=$frame[$frame_x]["dok2"];
     else
       if($frame[$frame_x]["defview"]>"")
         if(isset($_GET["view"]))
           $framestring.="view.php?view=".$_GET["view"];
         else
           $framestring.="view.php?view=".$frame[$frame_x]["defview"];
       else  
         $framestring.="default.htm";

   $framestring.="' name='$frame_name' frameborder='";
   $framestring.=$frame[$frame_x]["border"]."' ";
   $framestring.="' marginwidth='";
   $framestring.=$frame[$frame_x]["fspacing"]."' ";
   $framestring.="' marginheight='";
   $framestring.=$frame[$frame_x]["fspacing"]."' ";
   $framestring.="scrolling='";
   if($frame[$frame_x]["scrolling"]=="n")
     $framestring.="no' ";
   else
     $framestring.="auto' ";
   if($frame[$frame_x]["resize"]=="n")
     $framestring.="noresize";
   $framestring.=">";
   echo $framestring."\n";
   return true;
  }