Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2 lars 1 
<?php
2 
    // forget about any script timeouts
3 
    //set_time_limit(0);
1 lars 4 
 
2 lars 5 
    define( "modul_name", "Warenwirtschaft" );
6 
    define( "tool_name", "in_export" );
1 lars 7 
 
2 lars 8 
    require_once "../toolbox/common.php";
1 lars 9 
 
2 lars 10 
    $GLOBALS["ui"]->compile_id = "Warenwirtschaft|in_export";
11 
 
12 
    session_start();
13 
    $query = "SELECT
14 
            *
15 
        FROM
16 
            shops
17 
        WHERE
18 
            importtool != ''
19 
    ";
20 
    $result = mysql_query( $query );
21 
    while ( $zeile = mysql_fetch_assoc( $result ) )
22 
    {
23 
        $tools[] = $zeile;
24 
    }
25 
 
26 
    $sql = "SELECT
27 
            engine
28 
        FROM
29 
            information_schema.TABLES
30 
        WHERE
31 
            table_name='schnittstellen'
32 
    ";
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
46 
            WHERE
47 
                nutzungsart IN ('manuell','dual')
48 
            AND
49 
                art IN ('bestellimport', 'bestellexport')
50 
        ";
51 
        $res = mysql_query( $sql );
52 
        while ( $row = mysql_fetch_assoc( $res ) )
53 
        {
54 
            $tools2[] = $row;
55 
        }
56 
    }
57 
    $GLOBALS["ui"]->assign( "tools", $tools );
58 
    $GLOBALS["ui"]->assign( "tools2", $tools2 );
59 
    $GLOBALS["ui"]->display( "in_exporttool.tpl" )
1 lars 60 
?>