/**
* Return an array of available items, suitable for dropDownList()
* @param number $root ID of root nodes to retrieve
* @param string $level The level of tree to retrieve
* @return array $res An associate array with key - value
*/
public static function options($root = 0, $level = NULL)
{
$res = [];
if ($root instanceof self) {
$res[$root->id] = str_repeat('-', $root->level) . ' ' . $root->title;
if ($level) {
foreach ($root->children()->all() as $childRoot) {
$res += self::options($childRoot, $level - 1);
}
} elseif (is_null($level)) {
foreach ($root->children()->all() as $childRoot) {
$res += self::options($childRoot, NULL);
}
}
} elseif (is_scalar($root)) {
if ($root == 0) {
foreach (self::find()->roots()->all() as $rootItem) {
if ($level) {
$res += self::options($rootItem, $level - 1);
} elseif (is_null($level)) {
$res += self::options($rootItem, NULL);
}
}
} else {
$root = self::find($root);
if ($root) {
$res += self::options($root, $level);
}
}
}
return $res;
}
/**
* Sorting method used for sorting numbers
*
* @param number $a
* @param number $b
* @return int
*/
public function numberSort($a, $b)
{
$valA = $a->getColumn($this->columnToSort);
$valB = $b->getColumn($this->columnToSort);
if ($valA === false) {
$valA = null;
}
if ($valB === false) {
$valB = null;
}
return !isset($valA) && !isset($valB) ? 0 : (!isset($valA) ? 1 : (!isset($valB) ? -1 : ($valA != $valB || !isset($a->c[Row::COLUMNS]['label']) ? $this->sign * ($valA < $valB ? -1 : 1) : -1 * $this->sign * strnatcasecmp($a->c[Row::COLUMNS]['label'], $b->c[Row::COLUMNS]['label']))));
}
/**
* Identifier string
*
* @param number|string|array|ExpressionInterface|RequestInterface $identifier
* @param QueryInterface $query
* @return string
*/
protected function identifierToString($identifier, QueryInterface $query) : string
{
// Expression
if ($identifier instanceof ExpressionInterface) {
$query->addParameters($identifier->getParameters());
$identifier = $identifier->getExpression();
} elseif ($identifier instanceof RequestInterface) {
return sprintf(static::MASK_NESTED, $this->requestToString($identifier, $query));
} elseif (is_array($identifier)) {
return $this->quoteArrayIdentifier($identifier);
}
return $this->quoteIdentifier($identifier);
}
/**
* Sets a variable and its value.
*
* The variable will be extracted to the local scope of the template with
* the same name given as parameter to the method. So setting a variable
* named "title" will result in a $title variable available to the template.
*
* The value can be a string, a number or a PhpTemplate instance. In the
* latter case, the variable content will be the result of the whole parsed
* template of the PhpTemplate instance.
*
* The proper method for setting arrays is setArray().
*
* @since 1.1
* @param string $name Name of the variable.
* @param string|number|PhpTemplate $value variable content.
* @see setArray()
*/
public function set($name, $value)
{
if ($value instanceof \Innomatic\Tpl\Template) {
// This is a subtemplate, process it.
//
$this->vars[$name] = $value->parse();
} elseif (is_array($value)) {
// This is an array, it must be passed encoded.
//
$this->vars[$name] = $value;
$this->tplEngine->set($name, \Shared\Wui\WuiXml::encode($value));
} elseif (is_numeric($value)) {
// This is a number, it must be passed as it is.
//
$this->vars[$name] = $value;
$this->tplEngine->set($name, $value);
} else {
// This is a string, it must be passed as a CDATA.
//
$this->vars[$name] = $value;
$this->tplEngine->set($name, \Shared\Wui\WuiXml::cdata($value));
}
}
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "date.php";
$date = new date();
require $dir_libraries . "number.php";
$number = new number();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
$id = $number->id('absensi', '10', '');
$jam = date('H:i:s');
$jam_dtg1 = substr($jam, 0, 2);
$jam_dtg2 = substr($jam, 3, 2);
$jam_dtg3 = substr($jam, 6, 2);
$jam_plg1 = substr($jam, 0, 2);
$jam_plg2 = substr($jam, 3, 2);
$jam_plg3 = substr($jam, 6, 2);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
<?php
require_once dirname(__FILE__) . '/../../app/setup.php';
require_once $BASE_DIR . 'core/number.php';
$conn = new connection_factory($param_conn);
$sql = "SELECT\n n.nspname AS esquema, c.relname AS tabela, t.typname AS tipo\n FROM\n pg_class c\n LEFT JOIN\n pg_namespace n ON n.oid = c.relnamespace\n LEFT JOIN\n pg_type t ON t.oid = c.reltype\n WHERE\n c.relkind = 'r' AND\n n.nspname IN ('financeiro','prato','public', 'saed', 'sicad');";
$tables = $conn->get_all($sql);
$num_registros = array();
foreach ($tables as $tb) {
$sql = 'SELECT COUNT(*) FROM "' . $tb['esquema'] . '"."' . $tb['tabela'] . '";';
$num_registros[$tb['esquema']] += $conn->get_one($sql);
}
arsort($num_registros, SORT_NUMERIC);
echo "<h3>Número de Registros no banco do Sistema Acadêmico <br /><br /> Esquemas</h3>";
foreach ($num_registros as $key => $value) {
echo '<h4>' . $key . ': <font color="red">' . number::numeric2decimal_br($value, 0) . '</font></h4>';
}
if ($flag_diff == 1 && $flag_media == 0 && $flag_maior == 0 && $nota != -1) {
$flag_grava = 1;
} else {
$flag_grava = 0;
}
// GRAVA AS NOTAS NO BANCO DE DADOS
// SO ATUALIZA A NOTA SE NAO EXISTIR A NOTA EXTRA E A SOMA FOR MENOR OU IGUAL A 100
if ($flag_grava == 1 || $nota == -1) {
$sql_update .= "UPDATE matricula\n SET \n\t\t\t\t\t\t\tnota_final = {$NotaFinal} \n WHERE \n ref_pessoa = {$aluno_id} AND\n ref_disciplina_ofer = {$diario_id} AND \n ref_periodo = '{$periodo}' AND\n ref_motivo_matricula = 0; ";
// AND ref_disciplina = '$getdisciplina'
$sql_update .= "UPDATE \n diario_notas \n SET \n nota = {$nota} \n WHERE \n ref_diario_avaliacao = '{$prova}' AND \n\t\t\t\t\t d_ref_disciplina_ofer = {$diario_id} AND\n\t\t\t\t\t ra_cnec = '{$aluno_id}';";
if ($nota > -1 || $flag_grava == 1) {
$msg_registros .= "<font color=\"#000000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Nota <font color=\"#FF0000\"><strong>{$NotaReal}</strong></font> registrada para o aluno(a) <strong>{$nome_aluno}</strong>({$aluno_id})<br></font>";
}
if ($nota == -1 && $nota_extra != -1) {
$msg_registros .= "<font color=\"#000000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><font color=\"blue\" ><strong>Nota extra " . number::numeric2decimal_br($nota_extra, 1) . " eliminada!</strong></font>: aluno(a) <strong>{$nome_aluno}</strong>({$aluno_id}) <br></font>";
}
} else {
if ($flag_diff == 0) {
$msg_registros .= "<font color=\"#000000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><font color=\"blue\" ><strong>Nenhuma alteração: </strong></font> aluno(a) <strong>{$nome_aluno}</strong>({$aluno_id}) <br></font>";
} else {
// A NOTA DO ALUNO ULTRAPASSOU 100 OU JA FOI LANCADA A NOTA EXTRA
if ($nota != -1) {
if ($flag_maior == 1) {
$msg_registros .= "<font color=\"#000000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><font color=\"blue\" ><strong>Nota {$NotaReal} não registrada, possíveis causas: </strong></font><font color=\"#FF0000\"><strong>NOTA EXTRA OU MÉDIA > 100 pontos</strong></font>: aluno(a) <strong>{$nome_aluno}</strong>({$aluno_id}) <br></font>";
} else {
if ($flag_media == 1) {
$msg_registros .= "<font color=\"#000000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><font color=\"blue\" ><strong>Nota {$NotaReal} não registrada, possíveis causas: </strong></font><font color=\"#FF0000\"><strong>MÉDIA >= 60 pontos</strong></font>: aluno(a) <strong>{$nome_aluno}</strong>({$aluno_id}) <br></font>";
}
}
}
<?php
require "../../../libraries/start.php";
require $dir_libraries . "custom.php";
$custom = new custom();
require $dir_libraries . "image.php";
$image = new image();
require $dir_libraries . "date.php";
$date = new date();
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
if (isset($_POST['save'])) {
$nama = $form->input('nama');
$id_tipe = $form->input('id_tipe');
$id_no = $form->input('id_no');
$jabatan = $form->input('jabatan');
$aktif = $form->input('aktif');
$tempat = $form->input('tempat');
$tgl_lahir = $date->dateEnglishMinus($form->input('tgl_lahir'));
$jns_kelamin = $form->input('jns_kelamin');
$agama = $form->input('agama');
$pernikahan = $form->input('pernikahan');
$pekerjaan_id = $form->input('pekerjaan_id');
$pendidikan = $form->input('pendidikan');
$alamat = $form->input('alamat');
$rt = $form->input('rt');
$rw = $form->input('rw');
$propinsi_id = $form->input('propinsi_id');
$kota_id = $form->input('kota_id');
case 1:
echo ", равно 1";
break;
case 2:
echo ", равно 2";
break;
case 3:
echo ", равно 3";
break;
case 4:
echo ", равно 4";
break;
case 5:
echo ", равно 5";
break;
case 6:
echo ", равно 6";
break;
case 7:
echo ", равно 7";
break;
case 8:
echo ", равно 8";
break;
}
}
}
$number = new number();
$number->create_number();
$number->finding();
$number->finding_number();
continue;
}
$situacao = '';
if (verificaAprovacao($aluno, $curso, $disciplina_ofer)) {
$situacao = 'A';
} else {
$situacao = '<span style="color: red; font-weight: bold;">R</span>';
}
if (!verificaPeriodo($periodo) && $disciplina_aluno['fl_finalizada'] == 'f') {
$situacao = 'M';
}
echo '<td align="center">' . number::numeric2decimal_br($disciplina_aluno['nota_final'], 1) . '</td>';
echo '<td align="center">' . $disciplina_aluno['total_distribuido'] . '</td>';
echo '<td align="center">' . number::numeric2decimal_br($media_disciplina, 1) . '</td>';
echo '<td align="center">' . $disciplina_aluno['num_faltas'] . '</td>';
echo '<td align="center">' . number::numeric2decimal_br(@($disciplina_aluno['num_faltas'] * 100 / $ch_realizada), 1) . '</td>';
echo '<td align="center">' . $ch_realizada . '</td>';
echo '<td align="center">' . $situacao . '</td>';
}
echo '</tr>';
}
?>
</table>
<br />
(<strong>*</strong>) Disciplina com lançamentos não finalizados, passível de alterações.
<br /><br />
<div align="left" style="font-size: 0.85em;">
<h4>Legenda</h4>
<strong>A</strong> - Aprovado<br />
<strong>R</strong> - Reprovado <br />
<strong>M</strong> - Matriculado <br /><br />
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
require $dir_libraries . "number.php";
$number = new number();
$id = $number->id('pegawai', '3', '');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
</head>
<body>
<?php
include $dir_subviews . "menu.php";
?>
<?php
//include $dir_subviews."header.php";
?>
<?php
require "../../../libraries/start.php";
require $dir_libraries . "custom.php";
$custom = new custom();
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
if (isset($_GET['step'])) {
$step = $_GET['step'];
} else {
$step = 0;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
</head>
<body>
<?php
include $dir_subviews . "menu.php";
?>
<tr bgcolor="#cccccc">
<td align="center"><b>Matrícula</b></td>
<td><b>Nome</b></td>
<td align="center"><b>Nota</b></td>
<td align="center"><b>Motivo</b></td>
</tr>
<?php
foreach ($qry_dispensas as $row3) {
$nome_f = $row3['nome'];
$racnec = $row3['ra_cnec'];
$racnec = str_pad($racnec, 5, "0", STR_PAD_LEFT);
$num = $row3['ordem_chamada'];
$motivo_matricula = $row3['ref_motivo_matricula'];
if ($row3['nota_final'] != 0) {
$nota = number::numeric2decimal_br($row3['nota_final'], 1);
} else {
$nota = $row3['nota_final'];
}
if ($nota < 60) {
$nota = "<font color=\"red\"><b>{$nota}</b></font>";
}
// APROVEITAMENTO DE ESTUDOS 2
// CERTIFICACAO DE EXPERIENCIAS 3
// EDUCACAO FISICA 4
switch ($motivo_matricula) {
case 2:
$motivo_matricula = 'Aproveitamento de estudos';
break;
case 3:
$motivo_matricula = 'Certificação de experiência';
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
$id = $number->id('user_login', '3', '');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
</head>
<body>
<?php
include $dir_subviews . "menu.php";
?>
<?php
//include $dir_subviews."header.php";
?>
if ($nota != $nota_atual) {
$flag_diff = 1;
} else {
$flag_diff = 0;
}
if ($flag_diff == 1) {
$NotaFinal = $nota_parcial + $nota;
} else {
$NotaFinal = $nota_parcial + $nota_atual;
}
if ($NotaFinal > 100) {
$flag_maior = 1;
} else {
$flag_maior = 0;
}
$NotaReal = number::numeric2decimal_br($nota, 1);
// SE NOTA EXTRA NÃO FOI LANCADA,
// E A NOTA FOR DIFERENTE DA ANTERIOR E NÃO FOR MAIOR QUE 100 GRAVA
// E O SOMATÓRIO DAS NOTAS DISTRIBUIDA É MENOR/IGUAL A 100
// E A NOTA É MENOR/IGUAL O VALOR DA NOTA DISTRIBUIDA
if ($flag_extra == 0 && $flag_diff == 1 && $flag_maior == 0 && $flag_nota_distribuida_maior == 0) {
$flag_grava = 1;
} else {
$flag_grava = 0;
}
// GRAVA AS NOTAS NO BANCO DE DADOS
// SO ATUALIZA A NOTA SE NAO EXISTIR A NOTA EXTRA E A SOMA FOR MENOR OU IGUAL A 100
if ($flag_grava == 1) {
$sql_update .= "UPDATE matricula\r\n SET \r\n\t\t\t\t\t\t\tnota_final = {$NotaFinal} \r\n WHERE \r\n ref_pessoa = {$aluno_id} AND\r\n ref_disciplina_ofer = {$diario_id} AND \r\n ref_periodo = '{$periodo}' AND\r\n ref_motivo_matricula = 0; ";
// AND ref_disciplina = '$getdisciplina'
$sql_update .= "UPDATE \r\n diario_notas \r\n SET \r\n nota = {$nota} \r\n WHERE \r\n\t\t\t\t d_ref_disciplina_ofer = {$diario_id} AND\r\n ref_diario_avaliacao = '{$prova}' AND \r\n ra_cnec = '{$aluno_id}';";
function _desempenho_docente_importa($memory_limit, $csv_file)
{
global $conn;
$levantamento = '1001';
$qry = '';
$nao_sera_importado = '';
if (!file_exists($csv_file)) {
echo 'arquivo não encontrado: ' . $csv_file;
return;
}
$csv_file = realpath($csv_file);
// Automatically detect line endings.
ini_set('auto_detect_line_endings', '1');
$handle = @fopen($csv_file, 'r');
$count_lines = count(file($csv_file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES));
$count = 0;
echo '<strong>Arquivo:</strong> ' . basename($csv_file) . '<br /><br />';
while (($line = fgetcsv($handle, 1000, '|')) !== FALSE) {
//$verifica_associacao = 0;
set_time_limit(60);
$professor = (int) trim($line[1]);
$disciplina_ofer = (int) trim($line[0]);
echo $professor . ' - ' . $disciplina_ofer . '<br />';
if ((!is_numeric($professor) || $professor == 0) && (!is_numeric($disciplina_ofer) || $disciplina_ofer == 0)) {
continue;
}
//if (!is_numeric($disciplina_ofer) || $disciplina_ofer = 0) continue;
//echo $disciplina_ofer . ' - ';
// verifica associação professor <-> disciplina_ofer
$sql_verifica = "SELECT ref_professor FROM disciplinas_ofer_prof ";
$sql_verifica .= " WHERE ref_disciplina_ofer = {$disciplina_ofer} AND ";
$sql_verifica .= " ref_professor = {$professor};";
//echo $sql_verifica;
$verifica_associacao = count($conn->adodb->GetAll($sql_verifica));
echo 'associa: ' . $verifica_associacao . '<br />';
if ($verifica_associacao == 1) {
$qry_avaliacao = "BEGIN;";
$nota_criterio_1 = number::decimal_br2numeric(trim($line[2]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 1, {$levantamento}, {$nota_criterio_1});";
$nota_criterio_2 = number::decimal_br2numeric(trim($line[3]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 2, {$levantamento}, {$nota_criterio_2});";
$nota_criterio_3 = number::decimal_br2numeric(trim($line[4]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 3, {$levantamento}, {$nota_criterio_3});";
$nota_criterio_4 = number::decimal_br2numeric(trim($line[5]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 4, {$levantamento}, {$nota_criterio_4});";
$nota_criterio_5 = number::decimal_br2numeric(trim($line[6]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 5, {$levantamento}, {$nota_criterio_5});";
$nota_criterio_6 = number::decimal_br2numeric(trim($line[7]), 2);
$qry_avaliacao .= "INSERT INTO desempenho_docente_nota VALUES ({$disciplina_ofer}, {$professor}, 6, {$levantamento}, {$nota_criterio_6});";
$qry_avaliacao .= "COMMIT;";
$ret = $conn->adodb->Execute($qry_avaliacao);
if ($ret === FALSE) {
$qry .= $professor . ' - ' . $disciplina_ofer . ' <font color="red">ERRO</font><br />';
} else {
$qry .= $professor . ' - ' . $disciplina_ofer . ' <font color="green">OK</font><br />';
}
} else {
// não existe associação professor <-> disciplina_ofer
$sql_info = "SELECT descricao_disciplina(get_disciplina_de_disciplina_of({$disciplina_ofer})) || ' (' || {$disciplina_ofer} || ') - '";
$sql_info .= " || pessoa_nome({$professor}) || ' (' || {$professor} || ')';";
$nao_sera_importado .= $conn->adodb->GetOne($sql_info) . ' ' . $sql_verifica . '<br />';
}
$count++;
}
// endwhile;
@fclose($handle);
if (strlen($nao_sera_importado) > 0) {
echo '<h3>Não será importado os registros abaixo, pois não existe associação entre o professor(a) e a disciplina informadas</h3>';
echo $nao_sera_importado;
}
if (strlen($qry) > 0) {
echo '<h3>Resultado da importação</h3>';
echo "<br />{$qry}<br />";
} else {
echo '<h3>Nenhum registro para importação</h3>';
}
}
<?php
class number
{
public function count($i, $from)
{
while ($i < $from) {
echo $i . PHP_EOL;
$i++;
}
}
}
$obj = new number();
echo $obj->count(0, 15) . PHP_EOL;
if (count($diarios_info) > 0) {
foreach ($diarios_info as $disciplina_aluno) {
$nao_finalizada = $disciplina_aluno['fl_finalizada'] == 'f' ? '<strong>*</strong>' : ' ';
$color = $color != '#ffffff' ? '#ffffff' : '#cce5ff';
$situacao = '';
if (verificaAprovacao($aluno, $curso, $disciplina_aluno['ref_disciplina_ofer'])) {
$situacao = 'A';
} else {
$situacao = '<span style="color: red; font-weight: bold;">R</span>';
}
if (!verificaPeriodo($periodo) && $disciplina_aluno['fl_finalizada'] == 'f') {
$situacao = 'M';
}
echo '<tr bgcolor="' . $color . '">';
echo '<td><a href="lista_notas_detalhe.php?c=' . $curso . '&p=' . $periodo . '&d=' . $disciplina_aluno['ref_disciplina_ofer'] . '" alt="Clique para detalhar a disciplina" title="Clique para detalhar a disciplina">' . $disciplina_aluno['descricao_disciplina'] . '</a>' . $nao_finalizada . '</td>';
echo '<td align="center">' . number::numeric2decimal_br($disciplina_aluno['nota_final'], 1) . '</td>';
echo '<td align="center">' . $disciplina_aluno['total_distribuido'] . '</td>';
echo '<td align="center">' . $disciplina_aluno['num_faltas'] . '</td>';
echo '<td align="center">' . $situacao . '</td>';
echo '</tr>';
$count++;
}
}
?>
</table>
<br />
(<strong>*</strong>) Disciplina com lançamentos não finalizados, passível de alterações.
<br /><br />
<div align="left" style="font-size: 0.85em;">
<h4>Legenda</h4>
<strong>A</strong> - Aprovado<br />
<?php
require "../../../libraries/start.php";
require $dir_libraries . "custom.php";
$custom = new custom();
require $dir_libraries . "image.php";
$image = new image();
require $dir_libraries . "date.php";
$date = new date();
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
if (isset($_POST['save'])) {
$id = $form->input('$id');
$nama = $form->input('nama');
$no_ktp = $form->input('no_ktp');
$no_kta = $form->input('no_kta');
$jabatan = $form->input('jabatan');
$jenis = $form->input('jenis');
$tempat = $form->input('tempat');
$tgl_lahir = $date->dateEnglishMinus($form->input('tgl_lahir'));
$alamat = $form->input('alamat');
$rt = $form->input('rt');
$rw = $form->input('rw');
$kota = $form->input('kota');
$kecamatan = $form->input('kecamatan');
$desa = $form->input('desa');
$hp = $form->input('hp');
$telp_rumah = $form->input('telp_rumah');
$email = $form->input('email');
">
<td align="center">
<?php
echo $diario['ref_disciplina_ofer'];
?>
</td>
<td align="center">
<?php
echo $diario['descricao_disciplina'];
?>
</td>
<td align="center">
<?php
echo number::numeric2decimal_br($diario['nota_media'], 1);
?>
</td>
<?php
}
$diario_tmp = $diario['ref_disciplina_ofer'];
$count_criterios++;
if ($count_criterios == $num_criterios) {
$count_criterios = 1;
?>
</tr>
<?php
}
}
?>
<?php
require "libraries/database.php";
$database = new database();
require "libraries/number.php";
$number = new number();
require "libraries/form.php";
$form = new form();
$addr_root = "http://" . $_SERVER['SERVER_NAME'];
if (isset($_POST['action']) && $_POST['action'] == "absen") {
$pegawai_id = $form->input('pegawai_id');
$keterangan = $form->input('keterangan');
$jam = date('H:i:s');
$datetime = date('Y-m-d H:i:s');
$today = date('Y-m-d');
if (isset($_POST['absen_datang'])) {
$id = $number->id('absensi', 10, '');
$sql = "INSERT INTO absensi VALUES('{$id}','{$pegawai_id}','{$today}','{$jam}','','1','0','{$keterangan}',''," . "'{$pegawai_id}','{$datetime}','','')";
if (!$database->query($sql)) {
//die($sql);
$_SESSION['info'] = "Error: SQL Command";
header("Location: " . $addr_root . "/index.php");
exit;
} else {
$_SESSION['info'] = "Absensi Sudah Ditambahkan";
header("Location: " . $addr_root . "/index.php");
exit;
}
}
if (isset($_POST['absen_pulang'])) {
$sql = "UPDATE absensi SET jam_pulang='{$jam}', status_pulang='1', keterangan_pulang='{$keterangan}', upd='{$pegawai_id}', upd_date='{$datetime}' WHERE pegawai_id='{$pegawai_id}'";
<?php
require "../../../libraries/start.php";
require $dir_libraries . "custom.php";
$custom = new custom();
require $dir_libraries . "date.php";
$date = new date();
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
if (isset($_POST['save'])) {
$nama = $form->input('nama');
$user_level_id = $form->input('user_level_id');
$aktif = $form->input('aktif');
$username = $form->input('username');
$tgl1 = $date->dateEnglishMinus($form->input('tgl1'));
$tgl2 = $date->dateEnglishMinus($form->input('tgl2'));
$action = $form->input('action');
$user = $_SESSION['nama'];
$datetime = date('Y-m-d H:i:s');
// START INSERT DATA ==============================>
if ($action == "insert") {
$id = $number->id('user_login', 5);
$sql = "INSERT INTO user_login\n (id, nama, user_level_id, aktif, username, password, tgl1, tgl2, crt, crt_date) \n VALUES \n ('{$id}','{$nama}','{$user_level_id}','{$aktif}','{$username}',PASSWORD('{$username}'),'{$tgl1}','{$tgl2}','{$user}','{$datetime}')";
if (!$database->query($sql)) {
die($sql);
} else {
$_SESSION['success'] = "<b>Berhasil!</b> Anda telah menambah data baru";
header("Location: create.php");
exit;
/**
* Sets a variable and its value.
*
* The variable will be extracted to the local scope of the template with
* the same name given as parameter to the method. So setting a variable
* named "title" will result in a $title variable available to the template.
*
* The value can be a string, a number or a PhpTemplate instance. In the
* latter case, the variable content will be the result of the whole parsed
* template of the PhpTemplate instance.
*
* The proper method for setting arrays is setArray().
*
* @since 1.1
* @param string $name Name of the variable.
* @param string|number|PhpTemplate $value variable content.
* @see setArray()
*/
public function set($name, $value)
{
$this->vars[$name] = $value instanceof \Innomatic\Tpl\Template ? $value->parse() : $value;
}
<td><font color="#FFFFFF"><b> Matrícula</b></font></td>
<td><font color="#FFFFFF"><b> Nome</b></font></td>
</tr>
<?php
$st = '';
$ordem = 1;
foreach ($alunos as $aluno) {
$notaprova = $aluno['notabanco'];
$nota_parcial = $aluno['notaparcial'];
if ($prova == 7 && $nota_parcial > 59.999) {
continue;
}
if ($notaprova < 0) {
$notaprova = '';
} else {
$notaprova = number::numeric2decimal_br($notaprova, 1);
}
if ($st == '#F3F3F3') {
$st = '#E3E3E3';
} else {
$st = '#F3F3F3';
}
?>
<tr bgcolor="<?php
echo $st;
?>
"> <td align="center"><?php
echo $ordem;
?>
</td>
<td align="center">
