include_once "handler.php";
if($user) {
$add = $_POST['serch'];
$sql="select * from zakazi where like '"%$add%"'";
echo '<table border="1" style="font: 10px arial;">';
echo '<thead>';
echo '<tr><center>';
echo '<th rowspan="2">УПР</th>';
echo '<th rowspan="2">№</th>';
echo '<th bgcolor="#CCFFFF" colspan="5">Заказчик</th>';
echo '<th bgcolor="#FAEBD7" rowspan="2">Наимен. Файла</th>';
echo '<th bgcolor="#FAEBD7" rowspan="2">Материал</th>';
echo '<th bgcolor="#FAEBD7" rowspan="2">Разрешение Dpi</th>';
echo '<th bgcolor="#CCFFCC" colspan="4">Размеры м.</th>';
echo '<th bgcolor="#FFFFCC" colspan="8">Пособработка</th>';
echo '<th bgcolor="#FFE4E1" rowspan="2">Ответсвенный</th>';
echo '<th colspan="9">Прохождение заказа</th>';
echo '<th colspan="2">Даты</th>';
echo '</tr></center>';
echo '<tr><center>';
echo '<th bgcolor="#CCFFFF">Дата заказа</th>';
echo '<th bgcolor="#CCFFFF">Ф.И.О.</th>';
echo '<th bgcolor="#CCFFFF">Компания</th>';
echo '<th bgcolor="#CCFFFF">Тел.</th>';
echo '<th bgcolor="#CCFFFF">E-mail</th>';
echo '<th bgcolor="#CCFFCC">Длина</th>';
echo '<th bgcolor="#CCFFCC">Высота</th>';
echo '<th bgcolor="#CCFFCC">Кол.</th>';
echo '<th bgcolor="#CCFFCC">Площадь м2</th>';
echo '<th bgcolor="#FFFFCC">Проварка</th>';
echo '<th bgcolor="#FFFFCC">Проклейка</th>';
echo '<th bgcolor="#FFFFCC">Люверсы</th>';
echo '<th bgcolor="#FFFFCC">Карманы</th>';
echo '<th bgcolor="#FFFFCC">Обрезка</th>';
echo '<th bgcolor="#FFFFCC">Ламинация</th>';
echo '<th bgcolor="#FFFFCC">Вид</th>';
echo '<th bgcolor="#FFFFCC">Примечание</th>';
echo '<th>Заказ подтвержден</th>';
echo '<th bgcolor="#FAEBD7">В производстве</th>';
echo '<th>В печати</th>';
echo '<th bgcolor="#FFFFCC">Примечание Печ.</th>';
echo '<th>Отпечатано</th>';
echo '<th>Изготовлено</th>';
echo '<th>Принят</th>';
echo '<th bgcolor="#FFFFCC">Примечание Менеджера</th>';
echo '<th>Сдан</th>';
echo '<th>Дата Сдачи</th>';
echo '<th>Дата доставки</th>';
echo '</tr></center>';
echo '</thead>';
echo '<tbody>';
echo '<tr align="center">';
echo '<td >' . $poisk['nomer'] . '</td>';
echo '<td bgcolor="#CCFFFF">' . $poisk['data_zakaza'] . '</td>';
echo '<td bgcolor="#CCFFFF">' . $poisk['ime'] . '</td>';
echo '<td bgcolor="#CCFFFF">' . $poisk['firma'] . '</td>';
echo '<td bgcolor="#CCFFFF">' . $poisk['tel'] . '</td>';
echo '<td bgcolor="#CCFFFF">' . $poisk['email'] . '</td>';
echo '<td bgcolor="#FAEBD7" >' . $poisk['ime_maketa'] . '</td>';
echo '<td bgcolor="#FAEBD7" >' . $poisk['material'] . '</td>';
echo '<td bgcolor="#FAEBD7" >' . $poisk['razreshenie'] . '</td>';
echo '<td bgcolor="#CCFFCC" >' . $poisk['dlina'] . '</td>';
echo '<td bgcolor="#CCFFCC" >' . $poisk['visota'] . '</td>';
echo '<td bgcolor="#CCFFCC" >' . $poisk['kol'] . '</td>';
echo '<td bgcolor="#CCFFCC" >' . $poisk['S'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['provarka'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['prokleyka'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['lyvers'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['karman'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['obrezka'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['laminaciy'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['vid'] . '</td>';
echo '<td bgcolor="#FFFFCC" >' . $poisk['primechanie'] . '</td>';
echo '<td bgcolor="#FFE4E1">' . $poisk['manager'] . '</td>';
if($poisk["otchet"] == 1) { echo '<td><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { echo '<td><form action="/otch3.php" method="POST"><input name="votch" type="hidden" value="'.$solos.'" /><input name="nomer" type="hidden" value="'.$poisk["nomer"].'" /><input name="otchet" type="hidden" value="1"/><input type="image" name="subon" src="./images/and.gif" width="20" height="20" value="Одобрить" /></form></td>'; }
if($poisk["Dir"] == 1) { echo '<td bgcolor="#FAEBD7" ><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { if(($poisk["otchet"]==1) and ($poisk["Ruk"]== 0)) { echo '<td bgcolor="#FAEBD7"><form action="/dir.php" method="POST"><input name="vdir" type="hidden" value="'.$solos.'" /><input name="nomer" type="hidden" value="'.$poisk["nomer"].'" /><input name="Dir" type="hidden" value="1" /><input type="image" name="subon" src="./images/and.gif" width="20" height="20" value="Одобрить" /></form></td>'; } else { echo '<td bgcolor="#FAEBD7" ><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; } }
if($poisk["Ruk"] == 1) { echo '<td ><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { echo '<td ><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; }
echo '<td bgcolor="#FFFFCC" >' . $poisk['edit'] . '</td>';
if($poisk["Pech"] == 1) { echo '<td ><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { echo '<td ><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; }
if($poisk["Ruk1"] == 1) { echo '<td ><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { echo '<td ><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; }
if($poisk["otcha1"] == 1) { echo '<td><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { if(($poisk["Ruk1"]==1) AND ($poisk["otcha2"]== 0)) { echo '<td><form action="/otch.php" method="POST"><input name="votch1" type="hidden" value="'.$solos.'" /><input name="nomer" type="hidden" value="'.$poisk["nomer"].'" /><input name="otcha1" type="hidden" value="1"/><input type="image" name="subon" src="./images/and.gif" width="20" height="20" value="Одобрить" /></form></td>'; } else { echo '<td><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; } }
echo '<td bgcolor="#FFFFCC" >' . $poisk['edit1'] . '</td>';
if($poisk["otcha2"] == 1) { echo '<td><p><img width="20" height="20" src="./images/on.bmp"></p></td>'; } else { if($poisk["otcha1"]== 1) { echo '<td><form action="/otch2.php" method="POST"><input name="votch2" type="hidden" value="'.$solos.'" /><input name="nomer" type="hidden" value="'.$poisk["nomer"].'" /><input name="otcha2" type="hidden" value="1"/><input type="image" name="subon" src="./images/and.gif" width="20" height="20" value="Одобрить" /></form></td>'; } else { echo '<td><p><img width="20" height="20" src="./images/off.bmp"></p></td>'; } }
echo '<td>' . $poisk['data_sdachi'] . '</td>';
echo '<td>' . $poisk['data_dostavki'] . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
}
}
?>