$start_year = $date[0];
$end_year = $start_year + $fim;
if ($start_year < 1905) {
echo "<script>alert('Data de início inválida!');</script>";
} else {
if ($end_year - $start_year > 99) {
echo "<script>alert('Duração de convênio inválida!');</script>";
} else {
$end_date = '';
$end_date .= $end_year;
$end_date .= '-';
$end_date .= $date[1];
$end_date .= '-';
$end_date .= $date[2];
$sql = "SELECT numero FROM convenio WHERE id_empresa = {$id};";
$line = querySql($c, $sql, "getline");
$numero_convenio = $line["numero"];
$numero_convenio = explode('/', $numero_convenio);
$numero_empresa = $numero_convenio[0];
$novo_convenio = '';
$novo_convenio .= $numero_conv;
$novo_convenio .= '/';
$novo_convenio .= $year % 100;
mysql_close($c);
include "conection.php";
$sql = "insert into convenio(numero, id_empresa, data_inicio,data_fim) values('{$novo_convenio}','{$id}','{$inicio}','{$end_date}')";
$res = mysql_query($sql);
mysql_close($c);
}
}
}
die;
}
if ($cnpj[12] != $d1 || $cnpj[13] != $d2 || !preg_match('/(^[\\d]{14}$)/', $cnpj)) {
echo "<script>alert('CNPJ Inválido!')</script>";
die;
}
// VALIDAÇÃO CNPJ FIM
// Expressão regular do CNPJ ou CPF: ([0-9]{2}[\.]?[0-9]{3}[\.]?[0-9]{3}[\/]?[0-9]{4}[-]?[0-9]{2})|([0-9]{3}[\.]?[0-9]{3}[\.]?[0-9]{3}[-]?[0-9]{2})
include 'dbfunctions.php';
$c = beginConection($acesso);
$sql = "select *\n\t\t\t from empresa\n\t\t\t where(nome='{$name}' or cnpj='{$code}')";
if (querySql($c, $sql, "find") == false) {
$sql = "insert into empresa(nome, cnpj) values('{$name}','{$code}')";
if (querySql($c, $sql, "create") == true) {
$numeroConvenio = $comp . "/" . $end;
$sql = "select id from empresa where(nome='{$name}' and cnpj='{$code}')";
$line = querySql($c, $sql, "getline");
$idEmpresa = $line["id"];
$sql = "insert into convenio(numero, id_empresa) values('{$numeroConvenio}','{$idEmpresa}')";
if (querySql($c, $sql, "create") == true) {
$result = "\n\t\t\t\t\t<div class='alert'>\n\t\t\t\t\t\t<a style='color: white' href='company_search.php?company={$cnpj}'>\n\t\t\t\t\t\t\t<div class='stdSearchResult' style='background-color: #333333'>\n\t\t\t\t\t\t\t\t<font color='white'><br>\n\t\t\t\t\t\t\t\t\tEmpresa cadastrada e conveniada com sucesso.<br>Clique aqui para visualizar seus dados.\n\t\t\t\t\t\t\t\t</font>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</div>";
}
}
} else {
$result = "\n\t\t\t<div class='alert'>\n\t\t\t\t<a style='color: white' href='company_search.php?company={$cnpj}'>\n\t\t\t\t\t<div class='stdSearchResult' style='background-color: #333333'>\n\t\t\t\t\t\t<font color='white'><br>\n\t\t\t\t\t\t\tEmpresa já cadastrada.<br>Clique aqui para editar seus dados ou renovar convênio.\n\t\t\t\t\t\t</font>\n\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t</div>";
}
}
mysql_close($c);
echo $result;
?>
</html>
function queryAllExercisePlan($userid)
{
$uid = intval($userid);
$sql = "select * from `exercise_plan` where userid=" . $uid;
$ary = array();
$res = querySql($sql);
if ($res) {
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
array_push($ary, $row);
}
}
return $ary;
}
$id = isset($_GET['id']) ? $_GET['id'] : 1;
$id = (int) $id;
function querySql($sel, $from, $where, $alt)
{
$SQL = "SELECT {$sel} FROM {$from} WHERE `id` = " . $where;
$date = mysqli_query($SQL);
$count = mysqli_affected_rows();
if ($count === 1) {
$inf = mysqli_fetch_array($data);
$ansDate = $inf[0];
} else {
$ansDate = $alt;
}
return $ansDate;
}
$str = querySql('title', 'page', $id, 'title');
function title()
{
$str = 'title';
return $str;
}
function menu()
{
$shablon = file_get_contents('menu.tpl');
return $shablon;
}
function info()
{
$textData = 'info';
return $textData;
}
