<?php
        include 'var.php';
        include 'login.php';
        $pas = $_POST["pas"];
        $log = $_POST["user"];
        if ($pas == "" | $log == "") {
            echo print_login_page("index.php");
        } else if ($pas != "NULL" & $log != "NULL") {
            mssql_connect($serv, $user, $pass);
            mssql_select_db($db);
            $qlog = "SELECT * FROM [dbo].[firma] WHERE [log]='$log' AND [pas]='$pas' ;";
            $answer_log = mssql_query($qlog);
            $inn = -1;
                while ($data = mssql_fetch_row($answer_log)) {
                $inn = array();
           $inn[] = $data[0];
            }
            if ($inn > 0) {
                $do = $_POST['do'];
                include "functions.php";                
                    echo "<center>";
                    $type = $_POST['type'];
                    $upas = $_POST['pas'];
                        $strInn = $inn[0];
                for($i=1;$i<count($inn);$i++){
                   $strInn .= ",".$inn[$i];
            }
            $q = "SELECT * FROM [dbo].[main] WHERE [inn] IN (".$strInn.");";
 
                        $answer = mssql_query($q);
                        $b = false;
                        echo "<a href='index.php' style='color:#ffffff;'>Назад</a>
";
                        echo "<table cellspacing='0'  border='1' border-color='#3333ff'>
                <tr style='background-color:#ffaaaa'>
    <td>Фирма</td><td>№ машины</td><td>№ прицепа</td><td>Дата въезда</td><td>Дата выезда</td>            
</tr>";
                        while ($data = mssql_fetch_row($answer)) {
                            if ($b) {
                                echo"<tr style='background-color:#aaaaff'>";
                                $b = false;
                            } else {
                                echo"<tr style='background-color:#aaffaa;'>";
                                $b = true;
                            }
                            echo "<td>" . $data[3] . "</td><td>" . $data[1] . "</td><td>" . $data[2] . "</td><td>" . $data[7] . "</td><td>" . $data[14] . "</td>";
                            echo "</tr>";
                        }
                        echo "</table>";
                    
                 //   echo more_filter($inn, $upas);
                    echo "</center>";

                } else {
                    echo print_login_page("index.php");
                }
            } else {
                echo print_login_page("index.php");
            }

            
            ?>