echo "Não há nenhuma empresa com \"{$compania}\" em parte da sua Razão Social.";
} else {
mysql_close($c);
include "conection.php";
$resp = getTableCS($c, $sql_pag, "Empresas", 2, $num_rows, $compania, $pag, $limite);
echo $resp;
}
}
}
}
//$nulo = '(null)';
// if(($c_cnpj == '')||($c_cnpj == $nulo)){
// $c_cnpj = "Não cadastrado";
// }
if ($num_rows == 1 || isset($id)) {
$sql = "select conv.numero as 'Número', conv.data_inicio as 'Data Início', conv.data_fim as 'Data Fim', conv.id as 'id'\n\t\t\t\tfrom empresa emp \n\t\t\t\tinner join convenio conv \n\t\t\t\ton emp.id = conv.id_empresa\n\t\t\t\twhere emp.id='{$id}'\n\t\t\t\torder by conv.numero";
echo "<div class='stdSearchResult'>\n\t\t\t\t\t<br>\n\t\t\t\t\t<div class='descricao'>\n\t\t\t\t\t\t<div>\n\t\t\t\t\t\t\t<div class='what'>Nome:</div>\n\t\t\t\t\t\t\t<input class='info' name='comp' type='text' value='{$c_nome}' readonly>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class='infoline'>\n\t\t\t\t\t\t\t<div class='what'>CNPJ:</div>\n\t\t\t\t\t\t\t<input class='info' name='code' type='text' placeholder='Não Cadastrado' value='{$c_cnpj}' readonly>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class='infoline'>\n\t\t\t\t\t\t\t<div class='what'> Número: </div>\n\t\t\t\t\t\t\t<input class='info' name='comp' type='text' placeholder='Número não cadastrado' value='{$c_numero}' readonly>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t<input class='info' name='id' type='hidden' value='{$id}'>\n\t\t\t\t\t\t\n\t\t\t\t\t</div>\n\t\t\t\t\t\n\t\t\t\t\t<br>\n\t\t\t\t";
$table = getTable3($c, $sql, "Convênios");
echo $table;
echo "\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<hr width=90%>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<table style='background: transparent; border-radius: 20px;'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td><center>\n\t\t\t\t\t\t\t\t\t<div class='classname' onClick='updateData()' style='cursor: pointer;\n\t\t\t\t\t\t\t\t\t\theight: 45px; padding-top: 5px; font-size: 18px; width: 200px;'>\n\t\t\t\t\t\t\t\t\t\t\tAtualizar Dados</div></td>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<td><center>\n\t\t\t\t\t\t\t\t\t<div class='classname' onClick='newAgreement()' style='cursor: pointer;\n\t\t\t\t\t\t\t\t\t\theight: 45px; padding-top: 5px; font-size: 18px; width: 200px;'>\n\t\t\t\t\t\t\t\t\t\t\tNovo Convênio</div></td>\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<form method='post' action='compEdit.php'>\n\t\t\t\t\t\t<div class='updateData' id='newAgreement' style='visibility:hidden; display:none'>\n\t\t\t\t\t\t\t<img onclick='fechar(1)' id='close' alt='Fechar' width='32px' src='close.png'>\n\t\t\t\t\t\t<div id='addNew'><h3><center>Atualizar Dados</center></h3>\n\t\t\t\t\t<input type='hidden' value='{$id}' name='id'>\n\t\t\t\t\tNome <input name='nome' class='inputAtt' value='{$c_nome}' style='margin-right:25px; float: right' type='text' required><br><br>\n\t\t\t\t\tCNPJ <input name='cnpj' class='inputAtt' value='{$c_cnpj}' type='text' style='margin-right:25px; float: right' ><br><br>\n\t\t\t\t\tNúmero <input name='numero' type='text' value='{$c_numero}' style='margin-right:25px; float: right' class='inputAtt' ><br><br>\n\t\t\t\t\t<center><input style='float:none; margin: 10px 0px -10px -30px' class='submit' type='submit' value='OK'></center><br>\n\t\t\t\t\t</div></div></form>\n\t\t\t\t\t\n\t\t\t\t\t<form class='agreement2' method='get' action='convenio_update.php' >\t<input type='hidden' name='id' value='{$id}'>\n\t\t\t\t\t</form>\n\t\t\t\t\t";
echo "<form class='agreement' method='get' action='newAgreement.php'>\n\t\t\t\t\t<input type='hidden' name='id' value='{$id}'></form>";
echo "</div>";
mysql_close($c);
}
?>
<!-- Fim php -->
</div>
</center>
</body>
</html>
}
echo '</table>';
}
echo '<hr/>';
echo '<hr/>';
//必须告诉我创建几行几列的表格
//表格中的内容默认是x
//表格的默认颜色#ABCDEF
//返回表格
echo getTable3(3, 2);
echo '<hr/>';
echo getTable3(4, 2, 'this is a test');
echo '<hr/>';
echo getTable3(3, 3, 'hello world', 'red');
echo '<hr/>';
echo getTable3(4, 5, 'x', 'blue');
/**
* 得到表格
* @param int $rows
* @param int $cols
* @param string $content ='x'
* @param string $bgColor='#ABCDEF'
* @return string
*/
function getTable3($rows, $cols, $content = 'x', $bgColor = '#ABCDEF')
{
$table = "<table border='1' width='60%' bgcolor='{$bgColor}'>";
for ($i = 1; $i <= $rows; ++$i) {
$table .= "<tr>";
for ($j = 1; $j <= $cols; ++$j) {
$table .= "<td>{$content}</td>";
