<?php require_once('../topo.php');?>
<?php require_once('../lateral.php');?>
<br><br><br>
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="50" colspan="4" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="40"><span class="TituloPagina" style="padding-left: 5px;">SERVIÇOS</span></td>
        <td align="right"><table width="100" border="0" align="right" cellpadding="2" cellspacing="0">
          <tr>
            <td width="83" align="left"><table width="160" border="0" cellspacing="0" cellpadding="2" class="BoxMenuCinzaEscuro" onclick="location.href='listar_categorias.php';">
              <tr>
                <td height="25" align="center" class="TextoMenuCinza"><img src="img/icone_novo.gif" width="29" height="21" /></td>
                <td align="left"><span class="TextoMenuBranco" style="font-weight:normal; color:#FFF;">Categorias</span></td>
              </tr>
            </table></td>
            <td width="84" align="left"><table width="160" border="0" cellspacing="0" cellpadding="2" class="BoxMenuCinzaEscuro" onclick="location.href='listar_subcategorias.php';">
              <tr>
                <td height="25" align="center" class="TextoMenuCinza"><img src="img/icone_novo.gif" width="29" height="21" /></td>
                <td align="left"><span class="TextoMenuBranco" style="font-weight:normal; color:#FFF;">SubCategorias</span></td>
              </tr>
            </table></td>
            <td width="150" align="left"><table width="150" border="0" cellspacing="0" cellpadding="2" class="BoxMenuCinzaEscuro" onclick="location.href='manutencao_servicos.php';">
              <tr>
                <td height="25" align="center" class="TextoMenuCinza"><img src="img/icone_novo.gif" width="29" height="21" /></td>
                <td align="left"><span class="TextoMenuBranco" style="font-weight:normal; color:#FFF;">Novo Serviço</span></td>
              </tr>
            </table></td>
            <td width="125" align="left">&nbsp;</td>
            <td width="370" align="right"><table width="180" border="0" align="right" cellpadding="0" cellspacing="0" class="BoxMenuBranco">
              <form method="post" action="listar_servicos.php" enctype="multipart/form-data">
                <tr>
                  <td width="148" align="left" bgcolor="#FFFFFF"><input type="text" name="busca" id="busca" style="width: 100%; height: 20px;" class="InputBranco" /></td>
                  <td width="28" align="center" bgcolor="#FFFFFF"><input type="image" src="img/icone_buscar.gif" /></td>
                </tr>
              </form>
            </table></td>
          </tr>
        </table></td>
        <td width="80" align="right" style="padding-right: 8px;"><table width="70" border="0" cellspacing="0" cellpadding="2" class="BoxMenuCinza" onclick="history.go(-1);">
          <tr>
            <td height="25" align="center" class="TextoMenuBranco">Voltar</td>
            </tr>
          </table></td>
        </tr>
    </table></td>
    <td width="250" rowspan="2" align="left" valign="top"><?php require_once('lateral_geral.php');?></td>
  </tr>
  <tr>
    <td colspan="4" align="center" valign="top">    
    <table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" id="tabela_padrao" class="display">
     <thead>
      <tr class="TextoCinzaEscuro">
        <td width="10%" align="left" bgcolor="#A6A6A6"><strong>CÓD</strong></td>
        <td width="20%" height="30" bgcolor="#A6A6A6" class="TextoCinzaEscuro"><strong>TITÚLO</strong></td>
        <td width="10%" align="left" bgcolor="#A6A6A6"><strong>CATEGORIA</strong></td>
        <td width="10%" align="left" bgcolor="#A6A6A6"><strong>SUBCATEGORIA</strong></td>
        <td width="10%" align="left" bgcolor="#A6A6A6"><strong>DESCRIÇÃO</strong></td>
        <td width="20%" align="left" bgcolor="#A6A6A6"><strong>VALOR CUSTO</strong></td>
        <td width="20%" align="left" bgcolor="#A6A6A6"><strong>UNIDADE</strong></td>
        <td width="20%" align="center" bgcolor="#A6A6A6">&nbsp;</td>
        </tr>
        </thead>
        <tbody>
      <?php
		$busca = $_POST['busca'];
			$cor_fundo = "#FFFFFF";			  
		  if(empty($busca)){
			 	$seleciona = Seleciona("servicos", "", "ORDER BY titulo ASC");
		  }else{
			  	$seleciona = Seleciona("servicos", "WHERE titulo LIKE '%".$busca."%'", "ORDER BY titulo ASC");
		  }
			while($linha=mysql_fetch_array($seleciona)){
				$id_servico = $linha['idservico'];
				$id_categoria = $linha['idcategoria'];
				$id_subcategoria = $linha['idsubcategoria'];
				
				//SELECIONA NOME CATEGORIA
				
			 	$SelecionaCategoria = Seleciona("servicos_categorias", "WHERE idservicocategoria='$id_categoria'", "");	
				while($categorias=mysql_fetch_array($SelecionaCategoria)){
					$NomeCategoria = $categorias['titulo'];
				}
				
				
				//SELECIONA NOME SUBCATEGORIA
				
			 	$SelecionaSubCategoria = Seleciona("servicos_subcategorias", "WHERE idservicosubcategoria='$id_subcategoria'", "");	
				while($subcategorias=mysql_fetch_array($SelecionaSubCategoria)){
					$NomeSubCategoria = $subcategorias['titulo'];
				}				
			
			if($cor_fundo == "#FFFFFF"){
				$cor_fundo = "#E4E4E4";
			}else{
				$cor_fundo = "#FFFFFF";
			}
		?>
      <tr class="TextoCinzaPequeno" bgcolor="<?php echo $cor_fundo;?>" onmouseover="javascript:this.style.backgroundColor='#CCCCCC'" onmouseout="javascript:this.style.backgroundColor='<?php echo $cor_fundo;?>'" style="cursor:pointer;" onclick="location.href='manutencao_servicos.php?idservico=<?php echo $linha['idservico'];?>';">
        <td width="5%" align="left"><?php echo $linha['idservico'];?></td>
        <td width="50%" height="30"><?php echo $linha['titulo'];?></td>
        <td width="10%" align="left"><?php echo $NomeCategoria;?></td>
        <td width="10%" align="left"><?php echo $NomeSubCategoria;?></td>
        <td width="10%" align="left"><?php echo $linha['descricao'];?></td>
        <td width="5%" align="left"><?php echo $linha['valorcusto'];?></td>
        <td width="5%" align="left"><?php echo $linha['unidade'];?></td>
        <td width="5%" align="right"><img src="img/icone_detalhe.gif" width="22" height="24" border="0" /></td>
        </tr>
      <?php }?>
        </tbody>
    </table>    
    </td>
  </tr>
  <tr>
    <td colspan="5" align="center" valign="middle">
</td>
  </tr>
</table>
<?php require_once('../rodape.php');?>