Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1 Revision 2
Zeile 1... Zeile 1...
1 
<?
 1 
<?php
2 
	// forget about any script timeouts
 2 
    // forget about any script timeouts
3 
	//set_time_limit(0);
 3 
    //set_time_limit(0);
Zeile 4... Zeile 4...
4 
 
 4 
 
5 
	define ("modul_name", "Warenwirtschaft");
 5 
    define( "modul_name", "Warenwirtschaft" );
Zeile 6... Zeile 6...
6 
	define ("tool_name", "in_export");
 6 
    define( "tool_name", "in_export" );
Zeile -... Zeile 7...
- 
 
 7 
 
- 
 
 8 
    require_once "../toolbox/common.php";
7 
 
 9 
 
- 
 
 10 
    $GLOBALS["ui"]->compile_id = "Warenwirtschaft|in_export";
8 
	require_once "../Online-Shop/connect2.php";
 11 
 
9 
 
 12 
    session_start();
- 
 
 13 
    $query = "SELECT
- 
 
 14 
            *
- 
 
 15 
        FROM
10 
	session_start();
 16 
            shops
11 
?>
 17 
        WHERE
12 
<html>
 18 
            importtool != ''
- 
 
 19 
    ";
- 
 
 20 
    $result = mysql_query( $query );
13 
<head>
 21 
    while ( $zeile = mysql_fetch_assoc( $result ) )
- 
 
 22 
    {
- 
 
 23 
        $tools[] = $zeile;
- 
 
 24 
    }
- 
 
 25 
 
14 
	<title>Daten Import</title>
 26 
    $sql = "SELECT
15 
	<link rel=stylesheet type="text/css" href="../styles/styles.php">
 27 
            engine
- 
 
 28 
        FROM
16 
</head>
 29 
            information_schema.TABLES
- 
 
 30 
        WHERE
- 
 
 31 
            table_name='schnittstellen'
- 
 
 32 
    ";
17 
<body leftmargin="20" topmargin="20" marginwidth="20" marginheight="20">
 33 
    $res = mysql_query( $sql );
- 
 
 34 
    echo mysql_error();
- 
 
 35 
    if ( mysql_num_rows( $res ) )
- 
 
 36 
    {
- 
 
 37 
        $sql = "SELECT
- 
 
 38 
                s.*,
- 
 
 39 
                l.name aS l_name
- 
 
 40 
            FROM
- 
 
 41 
                schnittstellen s
- 
 
 42 
            JOIN
- 
 
 43 
                lieferanten l
- 
 
 44 
            ON
- 
 
 45 
                l.id=s.lieferanten_id
18 
Importtools:
46 
            WHERE
- 
 
 47 
                nutzungsart IN ('manuell','dual')
19 
<ul>
 48 
            AND
20 
<?
 49 
                art IN ('bestellimport', 'bestellexport')
21 
	$query="select * from shops where importtool != ''";
 50 
        ";
22 
	$result=mysql_query($query);
 51 
        $res = mysql_query( $sql );
- 
 
 52 
        while ( $row = mysql_fetch_assoc( $res ) )
23 
	while($zeile=mysql_fetch_assoc($result))
 53 
        {
- 
 
 54 
            $tools2[] = $row;
- 
 
 55 
        }
- 
 
 56 
    }
24 
	{
 57 
    $GLOBALS["ui"]->assign( "tools", $tools );
25 
		?><li><a href="<?=$zeile[importtool];?>"><?=$zeile[Name];?></a></li><?
 - 
 
26 
	}
 - 
 
27 
?>
 - 
 
28 
</ul>
 58 
    $GLOBALS["ui"]->assign( "tools2", $tools2 );