function save_post($cp, $tabela) { global $dd, $acao, $path; if (isset($dd[0]) and strlen($dd[0]) > 0 and strlen($cp[0][1]) > 0) { $sql = "update " . $tabela . " set "; $cz = 0; for ($k = 1; $k < 100; $k++) { if (strlen($cp[$k][1]) > 0 and $cp[$k][4] == True) { if ($cz++ > 0) { $sql = $sql . ', '; } if (substr($cp[$k][0], 0, 2) == '$D') { $dd[$k] = brtos($dd[$k]); } $sql = $sql . $cp[$k][1] . '=' . chr(39) . $dd[$k] . chr(39) . ' '; } } $sql = $sql . ' where ' . $cp[0][1] . "='" . $dd[0] . "'"; if (strlen($tabela) > 0) { $result = db_query($sql) or die("<P><FONT COLOR=RED>ERR 002:Query failed<HR>" . $sql); } $acao = null; $saved = 1; } else { $sql = "insert into " . $tabela . " ("; $sql2 = ""; $tt = 0; for ($k = 1; $k < 100; $k++) { if (strlen(trim($cp[$k][1]))) { if ($tt++ > 0) { $sql = $sql . ', '; $sql1 = $sql1 . ', '; } $sql = $sql . $cp[$k][1]; if (substr($cp[$k][0], 0, 2) == '$D') { $dd[$k] = brtos($dd[$k]); } $sql1 = $sql1 . chr(39) . $dd[$k] . chr(39); } } $sql = $sql . ') values (' . $sql1 . ')'; // echo $sql; $sqlc = $sql; if (strlen($tabela) > 0) { $result = db_query($sql); } // $dd[1] = null; $acao = null; $saved = 2; } return $saved; }
} $cp = array(); array_push($cp, array('$H8', '', '', false, true)); array_push($cp, array('$D8', '', '<nobr>' . msg('scheduled_meeting'), True, true)); array_push($cp, array('$[6-20]', '', '<nobr>' . msg('works_for_page'), True, true)); array_push($cp, array('$B8', '', msg('show'), False, true)); if (strlen($acao) == 0 or strlen($dd[1]) < 10) { echo '<h2>' . msg('agenda_for_meeting') . '</h2>'; echo '<TABLE width="400" border=0 class="tabela01" > <TR><TH colspan=2 align="center" class="tabela00"> ' . msg('inform_the_data') . ' <TR><TD>'; $tela = $form->editar($cp, $tabela); echo '</table>'; } else { $form->saved = 1; } if ($form->saved > 0) { echo $tela; $data = brtos($dd[1]); echo $mt->mostra($data, $dd[2]); } else { echo $tela; } echo $mt->mostra_proximas(); echo '</div>'; echo $hd->foot(); ?> <script> </script>
$msg_ok = '<font color="green">' . msg('validated') . '</font>'; $msg_nok = '<font color="red">' . msg('no_validated') . '</font>'; if ($clinic == 0 and $ref == 'CLINIC') { $cont = 'ok'; } if ($obrig == 1 and ($ativo == 1 or strlen($ativo) == 0)) { $link = '<A HREF="submit.php?dd91=' . $line['sub_pag'] . '#' . $line['sub_codigo'] . '">'; switch ($ref) { /* * Enrollment */ case 'ENROLL': if ($LANG == 'en_US') { $date = ustos($cont); } else { $date = brtos($cont); } echo '<TR>'; echo '<TD>'; echo msg($line['sub_descricao']) . ' - ' . $cont; /* CHECK DATE THE EROLLMENT */ if ($date < date("Ymd")) { $cont = ''; } if (strlen($cont) > 0) { echo '<TD align="center">' . $msg_ok; } else { /* ISSUE #89# */ echo ' <font color="red">'; echo msg('date_less_than_current'); echo '</font>';