WebSVN – lars-tiefland.content-management – Diff – /trunk/Online-Shop/artikel.php

 <?php
     ob_start();
     $error = false;
-    $allowed_mime_types = array( "image/jpg", "image/jpeg", "image/png",
+    $allowed_mime_types = array(
+        "image/jpg",
+        "image/jpeg",
+        "image/png",
-        "image/gif" );
+        "image/gif",
+        );
     session_start();
     $self = basename( $PHP_SELF );
     $DB = "artikel";
     define( "modul_name", "online_shop" );
     define( "tool_name", "artikel" );
     require_once "connect2.php";
+    $GLOBALS["gesperrte_felder"] = array();
+    if ( isset( $web_rechte["online_shop"]["artikel"]["artikel_klonen"] ) )
+    {
+        $GLOBALS["gesperrte_felder"] = explode( ";", $web_rechte["online_shop"]["artikel"]["artikel_klonen"] );
+    }
     require_once "../includes/system/functions.lagerwirtschaft.php";
     function get_vererbte_auspraegungen( $father )
             AND
                 a.vererbung = 1
             AND
                 a.type !=11
         ";
-        $res = mysql_query( $sql );
+        if ( $res = mysql_query( $sql ) )
-        while ( $row = mysql_fetch_assoc( $res ) )
+        {
+            while ( $row = mysql_fetch_assoc( $res ) )
+            {
-            $ret[] = $row;
+                $ret[] = $row;
+            }
+            return $ret;
+        }
-        return $ret;
+        return false;
+    }
     /**
      * ME: Beginn FUNKTIONEN zur Verarbeitung der abh. Auspraegungen
      * #########################################################################################
      */
         $Fathers = substr( $Fathers, 0, $start );
         $str_start = "<tr id=\"auspr_abhaengigkeiten\"style=\"display:" . $view .
             "\">\n";
         $str_start .=
-            "<td><strong>Auspr&auml;gungen (mit Abh&auml;ngigkeiten):</strong>\n";
+            "<td class='links'><strong>Auspr&auml;gungen (mit Abh&auml;ngigkeiten):</strong>\n";
         $str_start .= "</td>\n";
-        $str_start .= "<td>\n";
+        $str_start .= "<td class='rechts'>\n";
         // erstmal alle Ausprägungen holen und dabei die Father-Ebenen abprüfen
         $sql = "
+            {
                 $selVals = array();
                 $selVals = get_selected_auspr( $r['ID'], $artikel_id );
                 $vals = unserialize( $r['wertebereich'] );
-                $str_auspr .= "<table border=\"1\">\n";
+                $str_auspr .= "<table border=\"0\">\n";
                 $str_auspr .= "<tr>\n";
                 $str_auspr .= "<th>" . $r['name'] . "</th>\n";
                 $str_auspr .= "<th>" . $r['abh_auspr'] . "</th>\n";
     if ( $_GET["params"] )
+    {
-    {
+        $params = $_GET["params"];
         $params = $_GET["params"];
-    } elseif ( $_POST["params"] )
+    elseif ( $_POST["params"] )
+    {
         $params = $_POST["params"];
 ?>?action=edit&ID=<? echo $link[ID];
 ?>';
+    }
 </script>
 <?php
-        exit;
+        //exit;
+    }
     if ( $action == "update" )
+            {
                 //Artikel kopieren
                 $_SESSION["artikel_copy"] = $ID;
                 unset( $_POST[$elem] );
                 continue;
+            }
-            } elseif ( $elem == "del_cache" )
+            elseif ( $elem == "klonen" && isset( $user_rechte[modul_name][tool_name]["artikel_klonen"] ) )
+            {
+                //Artikel klonen
+                unset( $_POST[$elem] );
+                clone_item( $ID );
+                continue;
+            }
+            elseif ( $elem == "del_cache" )
+            {
+                // Artikel-Cache löschen
                 $sql = "
                     UPDATE
                         artikel
                     SET
                         parse_date=0
                     AND
                         Language='$language'
                 ";
                 mysql_query( $sql );
                 continue;
+            }
-            } elseif ( $elem == "mode" || $elem == "params" )
+            elseif ( $elem == "mode" || $elem == "params" )
+            {
                 continue;
+            }
-            } elseif ( $elem == "staffel" )
+            elseif ( $elem == "staffel" )
+            {
+                //Preisstaffeln eintragen
                 foreach ( $_POST["staffel"] as $i => $staffel )
+                {
                     foreach ( $staffel["preis"] as $id => $wert )
+                    {
                         if ( stristr( $wert, "%" ) )
                         ";
+                    }
                     $res = mysql_query( $sql );
+                }
                 continue;
+            }
-            } elseif ( ereg( "^preis", $elem, $erg1 ) )
+            elseif ( ereg( "^preis", $elem, $erg1 ) )
+            {
+                //Preise eintragen
                 if ( ereg( "%$", $_POST[$elem], $erg2 ) )
+                {
                     $_POST[$elem] = abs( $_POST[$elem] ) * ( -1 );
+                }
                 array_push( $names, "$elem='" . $_POST[$elem] . "'" );
+            }
-            } elseif ( $elem == "auspraegung_artikel" )
+            elseif ( $elem == "auspraegung_artikel" )
+            {
+                //Ausprägugnen eintragen (short_line_1-Version)
                 if ( isset( $web_rechte[modul_name][tool_name][short_line_1_auspraegung] ) )
+                {
                     $short_line_1 = implode( ";", $_POST[$elem] );
                     unset( $_POST[$elem] );
                     array_push( $names, "short_line_1='" .
                         mysql_real_escape_string( $short_line_1 ) . "'" );
+                }
+            }
-            } elseif ( $elem == "auspraegung" )
+            elseif ( $elem == "auspraegung" )
+            {
+                // Ausprägungen (neue Version)
                 if ( isset( $web_rechte[modul_name][tool_name][$elem] ) )
+                {
                     foreach ( $_POST[$elem] as $a_id => $auspraegung )
+                    {
                         if ( is_array( $auspraegung ) )
                                     '$auspraegung'
+                                )
                             ";
+                        }
                         $res = mysql_query( $sql ) or die( mysql_error() );
-                        //var_dump($auspraegung);
+                    }
                     /*
                     $val = implode( "|", $_POST[$elem] );
                     unset( $_POST["auspraegung"] );
                     array_push( $names, "auspraegung='" . $val . "'" );
                     */
+                }
+            }
-            } elseif ( $elem == 'auspr' )
+            elseif ( $elem == 'auspr' )
+            {
                 // update abh ausprägungen
                 update_abh_auspr( $_POST[$elem], $ID );
+            }
-            } elseif ( $elem == "lieferant" || $elem == "lieferant_artnr" )
+            elseif ( $elem == "lieferant" || $elem == "lieferant_artnr" )
+            {
+                //Lieferanten-Nummern
                 if ( is_array( $_POST["lieferant"] ) )
+                {
                     foreach ( $_POST["lieferant"] as $l_id => $aktiv )
+                    {
                         if ( $aktiv )
+                }
                 continue;
+            }
             else
+            {
+                // Alles andere
                 array_push( $names, "$elem='" . mysql_real_escape_string( $_POST[$elem] ) .
                     "'" );
+            }
+        }
         $query = "update $DB set " . join( $names, ', ' );
 ?>
 <link rel="stylesheet" href="<?= $file;
 ?>"/>
 <script language="javscript" type="text/javascript">
     $(function(){
+        $('.icecat_btn').button({
+            icons:{
+                primary: 'ui-icon-link'
+            }
+        }).click(get_icecat_info);
         $('.show_preise').button({
             icons:
+            {
                 primary:"ui-icon-zoomin"
+            }
             autoOpen:false,
             modal:true,
             height:600,
             width:700,
             resizable:false
-        })
+        });
+        function get_icecat_info()
+        {
+            id=this.id;
+            id=id.split("_");
+            ean=id[2];
+            $('#icecat_data').html('<div class="box_2"><div class="box_top"></div><div class="box_middle"><br><br><br><br><center>Loading ... <img src="/images/navigation/loading.gif"></center></div><div class="box_bottom"></div></div>');
+            $('#icecat_data').load("getIceCatInfo.php?EAN="+ean);
+        }
         function show_preise()
+        {
             id=this.id;
             id=id.split("_");
             id=id[2];
+    {
 ?>
     <script type="text/javascript" language="javascript" src="/js/bildverwaltung.js"></script>
 <?php
+    }
-    if ( isset( $user_rechte[modul_name][tool_name]["beschreibung"] ) )
-    {
-?>
-<!-- Einbindung TinyMCE -->
-<script type="text/javascript" src="../tiny_mce/tiny_mce.js"></script>
-<script type="text/javascript">
-tinyMCE.init({
-    // General options
-    mode : "exact",
-    elements: "beschreibung",
-    theme : "advanced",
-    language: "de",
-    plugins : "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",
-    // Theme options
-    theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull",
-    theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,preview,|,forecolor,backcolor",
-    theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,ltr,rtl,|,fullscreen",
-    theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",
-    theme_advanced_toolbar_location : "top",
-    theme_advanced_toolbar_align : "left",
-    theme_advanced_statusbar_location : "bottom",
-    theme_advanced_resizing : true,
-    // Example content CSS (should be your site CSS)
-    content_css : "css/example.css",
-    // Drop lists for link/image/media/template dialogs
-    template_external_list_url : "js/template_list.js",
-    external_link_list_url : "js/link_list.js",
-    external_image_list_url : "js/image_list.js",
-    media_external_list_url : "js/media_list.js",
-    // Replace values for the template plugin
-    template_replace_values : {
-        username : "Some User",
-        staffid : "991234"
-    }
-});
-</script>
-    <?php
-    }
 ?>
 <link rel="stylesheet" href="includes/artikel_zusatzinfo/eu-label.css">
 <link rel="stylesheet" type="text/css" href="redaktion.css">
 <style type="text/css">
 body
 <body bgcolor="#<? echo $webs[bgcolor_seite];
 ?>" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" text="#000000">
 <script type="text/javascript" language="javascript">
+    $(function(){
-    $(function(){
+        $('#artikel_form').submit(checkHersteller);
         $('.lieferant_artnr').hide();
         $('.lieferant').click(toggle_artnr);
         $('.lieferant').each(function(index, value){
             feld=value.id;
                 $('#'+feld).attr("checked",true);
+            }
         })
     });
+    function checkHersteller()
+    {
+        hersteller=$('#hersteller_select').val();
+        if(hersteller==0)
+        {
+            alert("Bitte wählen Sie einen Hersteller aus!");
+            return false;
+        }
+    }
     function toggle_artnr()
+    {
         art_nr_name=this.id;
         art_nr=art_nr_name.split("_");
 </script>
 <?php
     require_once "load_from_db.php";
     if ( $_SERVER["REMOTE_ADDR"] == "89.245.130.99" )
+    {
-        //        var_dump( $view_data );
+        //var_dump( $view_data );
+    }
 ?>
 <form method="post" action="<? echo $self;
-?>" name="formname" enctype="multipart/form-data">
+?>" name="formname" enctype="multipart/form-data" id="artikel_form">
     <div style="color: red;">
 <?php
     if ( $error )
+    {
         echo "Sie haben mindestens ein Bild in einem für das Internet unüblichen Format hochgladen.<br>";
 ?>">
 <?php
+    }
 ?>
     <div id="antwort"></div>
-  <table width="558" border="0" cellspacing="0" cellpadding="0">
+  <table style width="100%;" border="0" cellspacing="0" cellpadding="0">
     <tr valign="top">
       <td width="508">
         <?php
     require_once "language_pack.php";
     if ( $action == "edit" )
+    {
         if ( $ID )
+        {
+            $sql = "SELECT
+                    *
+                FROM
+                    $DB
+                WHERE
+                    ID = '$ID'
+                AND
-            $sql = "SELECT * FROM $DB where ID = '$ID' and Language = '$language'";
+                    Language = '$language'
+            ";
             $result = mysql_query( $sql ) or die( mysql_errno() . ": " .
                 mysql_error() );
             if ( mysql_num_rows( $result ) == 0 )
+            {
+                $sql = "SELECT
+                        *
+                    FROM
+                        $DB
+                    WHERE
+                        ID = '$ID'
+                    AND
-                $result = mysql_query( "SELECT * FROM $DB where ID = '$ID' and Language = '" .
+                        Language = '" . DEFAULT_LANG . "'
+                ";
-                    DEFAULT_LANG . "'" ) or die( mysql_errno() . ": " .
+                $result = mysql_query( $sql ) or die( mysql_errno() . ": " .
                     mysql_error() );
                 $Language_neueintrag = true;
+            }
             else
+            {
                 $Language_neueintrag = false;
+            }
-            $zeile = mysql_fetch_array( $result );
+            $zeile = mysql_fetch_assoc( $result );
             $_SESSION['artikel_zusatzinfo'][] = $zeile;
+            if ( isset( $web_rechte[modul_name][tool_name]["artikel_klonen"] ) )
+            {
+                $sql_m = "SELECT
+                        father
+                    FROM
+                        shop_link_table
+                    WHERE
+                        id=" . $zeile["ID"] . "
+                    AND
+                        verwendung='a2ma'
+                ";
+                $res_m = mysql_query( $sql_m );
+                $anz = mysql_num_rows( $res_m );
+                if ( $anz == 1 )
+                {
+                    $row_m = mysql_fetch_assoc( $res_m );
+                    $zeile["mutter"] = $row_m["father"];
+                    $sql_m = "SELECT
+                            *
+                        FROM
+                            artikel
+                        WHERE
+                            id=" . $zeile["mutter"] . "
+                        AND
+                            language='" . DEFAULT_LANG . "'
+                    ";
+                    $res_m = mysql_query( $sql_m );
+                    $zeile_mutter = mysql_fetch_assoc( $res_m );
+                }
+            }
+        }
 ?>
         <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
           <tr bgcolor="#<? echo $webs[bgcolor_links]
 ?>">
         else
+        {
 ?>Neueintrag<? }
 ?>
               </b> <? echo $zeile['ID']
 ?></font>
+    <?php
+        if ( $zeile["EAN"] && isset( $user_rechte[modul_name][tool_name]["icecat"] ) )
+        {
+?>
+            <span style="float: right;">
+                <a class="icecat_btn" id="icecat_btn_<?= $zeile["EAN"];
+?>">IceCat-Infos laden</a>
+            </span>
+            <?php
+        }
+?>
               <input type="hidden" name="Father" value="<? $out = "-1";
         if ( $zeile[Father] )
+        {
             $out = $zeile[Father];
+        }
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
+            <?php
-            <?php
+            if ( $f_name[0] == "!" || ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) &&
-            if ( $f_name[0] == "!" )
+                $zeile["mutter"] ) )
             {
-                echo ( $zeile[$Feld] ) ? htmlentities( $zeile[$Feld] ) :
+                echo ( $zeile_mutter[$Feld] ) ? htmlentities( $zeile_mutter[$Feld] ) :
                     "&nbsp;";
+            }
             else
+            {
 ?>
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
             <?php
+            if ( $f_name[0] == "!" || ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) &&
-            if ( $f_name[0] == "!" )
+                $zeile["mutter"] ) )
+            {
-                echo ( $zeile[$Feld] ) ? htmlentities( $zeile[$Feld] ) :
+                echo ( $zeile_mutter[$Feld] ) ? htmlentities( $zeile_mutter[$Feld] ) :
                     "&nbsp;";
+            }
             else
+            {
 ?>
 ?>
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
             <?php
+            if ( $f_name[0] == "!" || ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) &&
-            if ( $f_name[0] == "!" )
+                $zeile["mutter"] ) )
+            {
-                echo ( $zeile[$Feld] ) ? htmlentities( $zeile[$Feld] ) :
+                echo ( $zeile_mutter[$Feld] ) ? htmlentities( $zeile_mutter[$Feld] ) :
                     "&nbsp;";
+            }
             else
+            {
 ?>
 ?>
               </td>
           </tr>
           <?php
+        }
-        if ( isset( $user_rechte["online_shop"]["artikel"]["lieferanten"] ) )
+        if ( isset( $user_rechte["online_shop"]["artikel"]["lieferanten"] ) && $ID )
+        {
 ?>
             <tr>
                 <td class="links">
                     <strong>Lieferanten</strong>
 ?>
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
             <?php
+            if ( $f_name[0] == "!" || ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) &&
-            if ( $f_name[0] == "!" )
+                $zeile["mutter"] ) )
+            {
-                echo $zeile[$Feld];
+                echo $zeile_mutter[$Feld];
+            }
             else
+            {
 ?>
               <input type="text" name="<? echo $Feld
                         Name
                 ";
                 $res = mysql_query( $sql );
                 echo mysql_error();
 ?>
-                <select name="hersteller">
+                <select name="hersteller" id="hersteller_select">
                     <option value="0"></option>
            <?php
                 while ( $row = mysql_fetch_assoc( $res ) )
+                {
                     if ( $zeile["hersteller"] == $row["ID"] )
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
             <table>
                 <tr>
                     <td class="rechts">
+                    <?php
+            if ( ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) && $zeile["mutter"] ) )
+            {
+                echo $zeile_mutter[$Feld];
+            }
+            else
+            {
+?>
-              <input type="text" name="kurzbezeichnung" size="90" value="<? echo
+                        <input type="text" name="kurzbezeichnung" size="90" value="<? echo
-            htmlentities( $zeile[$Feld] )
+                htmlentities( $zeile[$Feld] )
 ?>">
+<?php
+            }
+?>
                         </td>
             <?php
             if ( isset( $user_rechte[modul_name][tool_name]["namenserweiterung"] ) )
+            {
 ?>
                     <td class="links"> <b>Artikelrubrik:</b></td>
                     <td class="rechts">
+                    <?php
+                if ( ( in_array( "namenserweiterung", $GLOBALS["gesperrte_felder"] ) &&
+                    $zeile["mutter"] ) )
+                {
+                    echo $zeile_mutter["namenserweiterung"];
+                }
+                else
+                {
+?>
                         <input type="text" name="namenserweiterung" value="<?= $zeile["namenserweiterung"];
 ?>">
+<?php
+                }
+?>
                     </td>
             <?php
+            }
 ?>
                 </tr>
           <?php
+        }
 ?>
           <?php
         $Feld = "beschreibung";
+        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) && !$zeile["mutter"] )
+        {
+?>
+<!-- Einbindung TinyMCE -->
+<script type="text/javascript" src="../tiny_mce/tiny_mce.js"></script>
+<script type="text/javascript">
+tinyMCE.init({
+    // General options
+    mode : "exact",
+    elements: "beschreibung,icecat_beschreibung",
+    theme : "advanced",
+    language: "de",
+    plugins : "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",
+    // Theme options
+    theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull",
+    theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,preview,|,forecolor,backcolor",
+    theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,ltr,rtl,|,fullscreen",
+    theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",
+    theme_advanced_toolbar_location : "top",
+    theme_advanced_toolbar_align : "left",
+    theme_advanced_statusbar_location : "bottom",
+    theme_advanced_resizing : true,
+    // Example content CSS (should be your site CSS)
+    content_css : "css/example.css",
+    // Drop lists for link/image/media/template dialogs
+    template_external_list_url : "js/template_list.js",
+    external_link_list_url : "js/link_list.js",
+    external_image_list_url : "js/image_list.js",
+    media_external_list_url : "js/media_list.js",
+    // Replace values for the template plugin
+    template_replace_values : {
+        username : "Some User",
+        staffid : "991234"
+    }
+});
+</script>
+    <?php
+        }
         $hide = "document.getElementById('img_d001').style.display='';document.getElementById('img_u001').style.display='none';";
         $display = "document.getElementById('img_u001').style.display='';document.getElementById('img_d001').style.display='none';";
         if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
+        {
             $display .= "document.getElementById('$Feld').style.display='';";
             "" : "none"
 ?>;" id="img_d001" align="right"></div>
             </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
+<?php
+            if ( ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) && $zeile["mutter"] ) )
+            {
+?>
+                <div id="beschreibung" style="display:<?= ( $view_data[$Feld] ) ?
+                "" : "none;"
+?>"><?= $zeile_mutter[$Feld];
+?></div>
+            <?php
+            }
+            else
+            {
+?>
               <textarea id="beschreibung" name="beschreibung" cols="45" rows="6" id="<?= $Feld
-?>" style="display:<?= ( $view_data[$Feld] ) ? "" : "none"
+?>" style="display:<?= ( $view_data[$Feld] ) ? "" : "none;"
 ?>"><? echo $zeile[beschreibung];
 ?></textarea>
+<?php
+            }
+?>
 </td>
           </tr>
           <?php
+        }
 ?>
 ?>" valign="top" width="30%">
                     <font color="#<? echo $webs[font_color_links]
 ?>"><b>Ausprägung:</b></font>
                 </td>
                 <td class="rechts" width="70%" colspan="2">&nbsp;&nbsp;
-                        <table width="100%" border="1">
+                        <table width="100%" border="0">
                             <tr>
                                 <th>Eigenschaft</th>
                                 <th>Wert</th>
                             </tr>
         <?php
                     WHERE
                         ID=" . $row["auspraegung"] . "
                 ";
                 $res_a = mysql_query( $sql_a );
                 $row_a = mysql_fetch_assoc( $res_a );
-                if ( !in_array( $row_a["type"], array( 3, 4, 5, 6, 7, 9, 10 ) ) )
+                if ( !in_array( $row_a["type"], array(
+,
+,
+,
+,
+,
+,
+) ) )
+                {
                     $sql_art = "SELECT
+                            *
                         FROM
                             artikel_to_auspraegung
                         <?php
                             break;
                         case 2:
 ?>
                                     <input type="radio" name="auspraegung[<?= $row_a["ID"]
-?>]" value="1" <?= ( $row_art["wert"] == "1" ) ? "checked='checked'":
+?>]" value="1" <?= ( $row_art["wert"] == "1" ) ? "checked='checked'" : ""
-                            ""
 ?>>ja&nbsp;
                                     <input type="radio" name="auspraegung[<?= $row_a["ID"]
-?>]" value="0" <?= ( $row_art["wert"] == "0" ) ? "checked='checked'":
+?>]" value="0" <?= ( $row_art["wert"] == "0" ) ? "checked='checked'" : ""
-                            ""
 ?>>nein
                         <?php
                             break;
+                    }
 ?>
                                 </td>
                             </tr>
 <?php
+                }
-                } elseif ( $row_a["type"] == 4 || $row_a["type"] == 7 )
+                elseif ( $row_a["type"] == 4 || $row_a["type"] == 7 )
+                {
 ?>
                     <tr>
                         <td colspan="2" class="links"><?= $row_a["name"];
 ?></td>
                     </tr>
 <?php
+                }
-                } elseif ( $row_a["type"] == 5 || $row_a["type"] == 6 )
+                elseif ( $row_a["type"] == 5 || $row_a["type"] == 6 )
+                {
                     $sql_art = "SELECT
+                            *
                         FROM
                             artikel_to_auspraegung
                             if ( $wert )
+                            {
                                 $sel = '';
                                 if ( $row_a["type"] == 6 )
+                                {
-                                    if ( in_array( $wert, unserialize( $row_art["wert"] ) ) )
+                                    $art_wert_arr = unserialize( $row_art["wert"] );
+                                    if ( is_array( $art_wert_arr ) && in_array( $wert,
+                                        $art_wert_arr ) )
+                                    {
                                         $sel = 'checked="checked"';
+                                    }
+                                }
                                 else
     <?php
+                                }
 ?>
                             <?php
+                            }
-                            //var_dump($wert);
+                        }
+                    }
                     else
+                    {
                         echo "<br>keine Werte eingetragen!";
+                    }
 ?>
                     </td>
                     </tr>
                 <?php
+                }
-                } elseif ( $row_a["type"] == 10 )
+                elseif ( $row_a["type"] == 10 )
+                {
                     $sql_art = "SELECT
+                            *
                         FROM
                             artikel_to_auspraegung
                             da.auspraegung=" . $row_a["ID"] . "
                     ";
                     $res_dir = mysql_query( $sql_dir );
                     $row_dir = mysql_fetch_assoc( $res_dir );
                     $werte = unserialize( $row_dir["wertebereich"] );
-                    //var_dump($werte);
 ?><tr>
                 <td class="links"><?= $row_a["name"];
 ?></td>
                 <td class="recths">
                     <table>
                         </tr>
                         <tr class="euLabel">
                     <?php
                     foreach ( $werte as $wert )
+                    {
+                        if ( !$wert )
+                        {
+                            continue;
+                        }
 ?>
                             <td class="<?= trim( $wert, "+" );
 ?>"><input type="radio" name="auspraegung[<?= $row_a["ID"];
 ?>]" value="<?= $wert;
 ?>"<?= ( $row_art["wert"] == $wert ) ? "checked='checked'" : "";
                         echo "1";
+                    }
 ?>].checked=true;"/>
                     </font> </td>
                   <td width="45%" nowrap="nowrap"align="center"><font color="#<? echo
-$webs[font_color_rechts]
+                    $webs[font_color_rechts]
 ?>">&nbsp;
                     </font>
                     <? if ( substr( $Felddaten[0], 0, 4 ) <> "Doku" )
+                    {
                         if ( $zeile[$image_name] != "" )
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%" nowrap><font color="#<? echo $webs[font_color_rechts]
 ?>">
             <?php
+                    if ( $f_name[0] == "!" || ( in_array( $Feld, $GLOBALS["gesperrte_felder"] ) &&
-                    if ( $f_name[0] == "!" )
+                        $zeile["mutter"] ) )
+                    {
-                        echo $zeile[$Feld];
+                        echo $zeile_mutter[$Feld];
+                    }
                     else
+                    {
 ?>
               <input type="text" name="<? echo $Feld
             </tr>
           <?php
+        }
+        $stati = false;
+        $Felder = array(
+            "status",
-        $stati = false;
+            "Lieferstatus",
+            "Lieferstatus2",
-        $Felder = array( "status", "Lieferstatus", "Lieferstatus2", "Bestand" );
+            "Bestand" );
         $hide = "document.getElementById('img_d010').style.display='';document.getElementById('img_u010').style.display='none';";
         $display = "document.getElementById('img_u010').style.display='';document.getElementById('img_d010').style.display='none';";
         foreach ( $Felder as $Feld )
+        {
             $kats = explode( ";", $katsRaw[0] );
             if ( !$ID )
+            {
                 $zeile[$Feld] = $katsRaw[1];
+            }
+            if ( ( in_array( strtolower( $Feld ), $GLOBALS["gesperrte_felder"] ) &&
+                $zeile["mutter"] ) )
+            {
+                echo $kats[$zeile_mutter[$Feld]];
+            }
+            else
+            {
 ?>
 <select name="<? echo $Feld
 ?>" id="<?= $Feld;
 ?>_sel"><?php
-            $kat_runner = 0;
+                $kat_runner = 0;
-            foreach ( $kats as $elem )
+                foreach ( $kats as $elem )
-            {
+                {
 ?><option value="<?= $kat_runner;
 ?>"<? if ( $zeile[$Feld] == $kat_runner )
-                {
+                    {
 ?>selected<? }
 ?>><?= $elem;
 ?></option><?php
-                $kat_runner++;
+                    $kat_runner++;
-            }
+                }
 ?></select>
 <?php
+            }
             $Feld2 = $Feld . "Maintainer";
             if ( isset( $user_rechte[modul_name][tool_name][$Feld2] ) )
+            {
+                $kats = explode( ";", $web_rechte[modul_name][tool_name][$Feld2] );
+                if ( in_array( strtolower( $Feld2 ), $GLOBALS["gesperrte_felder"] ) &&
+                    $zeile["mutter"] )
+                {
+                    echo "<br>" . $zeile_mutter[$Feld2];
+                }
+                else
                 $kats = explode( ";", $web_rechte[modul_name][tool_name][$Feld2] );
 ?><select name="<?= $Feld2;
 ?>" id="<?= $Feld2;
 ?>"><?php
-                foreach ( $kats as $elem )
+                    foreach ( $kats as $elem )
+                    {
 ?><option value="<?= $elem;
 ?>"<? if ( $zeile[$Feld2] == $elem )
+                        {
 ?>selected<? }
 ?>><?= $elem;
 ?></option><?php
-                    $kat_runner++;
+                        $kat_runner++;
+                    }
-?></select><?php
+?></select><?php
+                }
+            }
             if ( isset( $user_rechte["Warenwirtschaft"]["bestellung"]["lieferantenbestellung"] ) )
+            {
 ?>&nbsp;<a class="lager" id="lager_<?= $zeile["ID"];
 ?>
               </b></font> </td>
             <td bgcolor="#<? echo $webs[bgcolor_rechts]
 ?>" colspan="2" width="70%">
 <?php
+            $a_id = $ID;
+            if ( $zeile["mutter"] )
+            {
+                $a_id = $zeile["mutter"];
+            }
-            $bestand = getArtikelbestandsInfo( $ID );
+            $bestand = getArtikelbestandsInfo( $a_id );
             echo $bestand['bestandsmenge'] . ' (' . $bestand['verfuegbareMenge'] .
                 ')';
+            if ( $zeile["mutter"] )
+            {
+                echo "<br>Dies ist der Bestand des Mutterartikels " . $zeile_mutter["ID"] .
+                    " (" . $zeile_mutter["kurzbezeichnung"] . ")";
+            }
 ?>
             </td>
           </tr>
 <?php
+        }
+        {
             if ( $link )
+            {
                 $Feld = "delete_link";
                 //if (isset($user_rechte[modul_name][tool_name][$Feld]))
+                {
 ?>
                 <input name="<? echo $Feld
 ?>" type="button" value="Verknüpfung L&ouml;schen" onclick="if (confirm('Wollen Sie die Verknüpfung dieses Artikels zum diesem Ordner wirklich löschen ?')) {document.location.href='<? echo
                     $self
                 <?php
+                }
                 // Termintaste
                 $Feld = "termin";
                 //if (isset($user_rechte[modul_name][tool_name][$Feld]))
+                {
 ?><input type="button" value="Termin" onclick="systemtermin('Artikel <? if ( $zeile[hersteller] )
+                    {
                         echo htmlentities( $zeile[hersteller] )
 ?> <? }
 ?>')"><?php
+                }
                 $Feld = 'buchung_aufgeben';
                 if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) &&
+                    isset( $user_rechte['Warenwirtschaft']['lagerwirtschaft']['lagerwirtschaft'] ) &&
-                    isset( $user_rechte['Warenwirtschaft']['lagerwirtschaft']['lagerwirtschaft'] ) )
+                    !$zeile["mutter"] )
+                {
 ?>
                     <input type="button" value="Buchung aufgeben" onclick="location.href='<?= 'http://' .
                     $_SERVER['SERVER_NAME'] .
                         '/Warenwirtschaft/lagerwirtschaft.php?action=buchung&artikelId=' .
                         $ID
 ?>';" />
                     <?php
+                }
+                $Feld = "artikel_klonen";
+                if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) && !$zeile["mutter"] )
+                {
+?>
+                    <input type="submit" name="klonen" value="Klonen" />
+                    <?php
+                }
+            }
+        }
         if ( isset( $web_rechte["Lexikon"]["acronyms"]["beschreibung"] ) )
+        {
             <td width="40%">&nbsp; </td>
-                  </tr>
-                </table>
-        <?php
                   </tr>
-?>
+                </table>
+<div id="add_image_dialog" title="Bild hinzufügen"></div>
+</td>
+            <?php
+        if ( $zeile["EAN"] && isset( $user_rechte[modul_name][tool_name]["icecat"] ) )
+        {
+?>
+<td width="1000">
+    <table width="1000" border="0" cellspacing="0" cellpadding="0">
+    <tr>
+        <td>
+            <div id="icecat_data"></div>
+        </td>
+    </tr>
+    </table>
+</td>
+            <?php
+        }
 <div id="add_image_dialog" title="Bild hinzufügen"></div>
-</td>
+?>
       <td valign="top" align="right" width="50">
 <?php
     if ( isset( $user_rechte["online_shop"]["language"] ) and ( $ID ) )
         return true;
+    }
+</script>
+<?php
+    if ( isset( $user_rechte["admin"]["toolbox"]["bildverwaltung"] ) )
 </script>
 ?>
 <div id="preise_dialog" title="Artikelpreise"></div>
 <div id="del_image_dialog" title="Bildzuordnung löschen">
     <form id="del_image_form">
         <input type="hidden" id="b_id" name="b_id" />
         <input type="hidden" id="a_id" name="a_id" value="<?= $zeile["ID"];
 ?>" />
         Wollen Sie Die Zuordnung des Bildes <span id="bild_name"></span> wirklch aufheben?
+    </form>
+</div>
+<?php
     </form>
+?>
+</body>
+<?php
+    function clone_item( $artikel )
+    {
+        $sql = "SELECT
+                *
+            FROM
+                artikel
+            WHERE
+                ID = $artikel
+        ";
+        $res = mysql_query( $sql );
+        while ( $row = mysql_fetch_assoc( $res ) )
+        {
+            $data = array();
+            if ( $new_id )
+            {
+                $row["ID"] = $new_id;
+            }
+            else
+            {
+                unset( $row["ID"] );
+            }
+            foreach ( $row as $feld => $wert )
+            {
+                if ( in_array( strtolower( $feld ), $GLOBALS["gesperrte_felder"] ) )
+                {
+                    unset( $row[$feld] );
+                    if ( $feld == "beschreibung" )
+                    {
+                        unset( $row["beschreibung_html"] );
+                    }
+                }
+            }
+            foreach ( $row as $feld => $wert )
+            {
+                if ( !is_null( $wert ) )
+                {
+                    $wert = mysql_real_escape_string( $wert );
+                    $data[] = $feld . "='" . $wert . "'";
+                }
+                else
+                {
+                    $data[] = $feld . "=NULL";
+                }
+            }
+            $sql_k = "
+                INSERT INTO
+                    artikel
+                SET
+            ";
+            $sql_k .= "\t" . implode( ",\n\t\t", $data );
+            $res_k = mysql_query( $sql_k );
+            if ( !$new_id )
+            {
+                $new_id = mysql_insert_id();
+            }
+            echo mysql_error();
+        }
+        $sql_sl = "
+            INSERT INTO
+                shop_link_table
+            SET
+                Father=$artikel,
+                ID=$new_id,
+                verwendung='a2ma'
+        ";
+        $res = mysql_query( $sql_sl );
+        $sql_aa = "
+            INSERT INTO
+                artikel_to_auspraegung
+            (
+                SELECT
+                    $new_id AS artikel,
+                    auspraegung,
+                    wert
+                FROM
+                    artikel_to_auspraegung
+                WHERE
+                    artikel=$artikel
+            )
+        ";
+        $res = mysql_query( $sql_aa );
+        exit;

Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Online-Shop/artikel.php – Revision 1 → 2