public function add()
{
$campus = new Campus();
$campus->setCidade($_POST['cidade_campus']);
$campus->setNome($_POST['nome_campus']);
$campus->setFkInstituicao($_POST['id_instituicao']);
$campusMySqlDAO = new CampusMySqlDAO();
$campusMySqlDAO->insert($campus);
}
/**
* atualiza um registro da tabela
*
* @parametro CampusMySql campu
*/
public function update(Campus $Campus)
{
$sql = "UPDATE {$this->table} SET nome = :nome, cidade = :cidade, fk_instituicao = :fk_instituicao WHERE id_campus = :id";
$id = $Campus->getIdCampus();
$nome = $Campus->getNome();
$cidade = $Campus->getCidade();
$fkInstituicao = $Campus->getFkInstituicao();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id);
$stmt->bindParam(':nome', $nome);
$stmt->bindParam(':cidade', $cidade);
$stmt->bindParam(':fkInstituicao', $fkInstituicao);
return $stmt->execute();
}
public function actionIndex()
{
$campuses = Campus::model()->findAll(array('condition' => 'inactive != :inactive', 'params' => array(':inactive' => '1'), 'order' => 'order_by'));
$campusList = CHtml::listData($campuses, 'id', 'name');
$model = new LoginForm();
$this->render('login', array('model' => $model, 'campusList' => $campusList));
}
public function index_onDelete()
{
if (($checkedIds = post('checked')) && is_array($checkedIds) && count($checkedIds)) {
foreach ($checkedIds as $postId) {
if (!($post = Campus::find($postId))) {
continue;
}
$post->delete();
}
Flash::success('Successfully deleted those campus.');
}
return $this->listRefresh();
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('units', function (Blueprint $table) {
$table->decimal('years_before_drop')->nullable();
});
//campus
$campus = Campus::where('unitid', 2)->first();
$campus->years_before_drop = $campus->getAveYearsBeforeDropout();
$campus->ave_batch_attrition = $campus->getAveAttrition();
$campus->save(['timestamps' => false]);
//program
$programlist = Program::where('programs.degreelevel', 'U')->whereNotIn('programs.programid', array(62, 66, 38, 22))->get();
foreach ($programlist as $program) {
$program->years_stay = $program->getAveYearsOfStay();
$program->years_before_shift = $program->getAveYearsBeforeShifting();
$program->years_before_drop = $program->getAveYearsBeforeDropout();
$program->ave_batch_attrition = $program->getAveAttrition();
$program->ave_batch_shift = $program->getAveShiftRate();
$program->ave_students = $program->getAveStudents();
$program->save(['timestamps' => false]);
}
//department
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
foreach ($departmentlist as $department) {
$department->ave_batch_attrition = $department->getAveAttrition();
$department->ave_batch_shift = $department->getAveShiftRate();
$department->ave_students = $department->getAveStudents();
$department->save(['timestamps' => false]);
}
//college
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
$collegelist = [];
foreach ($departmentlist as $department) {
array_push($collegelist, $department->college);
}
$collegelist = array_unique($collegelist);
foreach ($collegelist as $college) {
$college->ave_batch_attrition = $college->getAveAttrition();
$college->ave_batch_shift = $college->getAveShiftRate();
$college->ave_students = $college->getAveStudents();
$college->save(['timestamps' => false]);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//up manila
$campus = Campus::where('unitid', 2)->first();
$yearlyStudentAverage = $campus->getStudentAverage();
$aveAttrition = $campus->getAveAttrition();
$batchAttrition = $campus->getBatchAttrition();
$aveDropouts = $campus->getAveDropouts();
$batchDropouts = $campus->getBatchDropouts();
$aveYearsBeforeDropout = $campus->getAveYearsBeforeDropout();
$aveDelayed = $campus->getAveDelayed();
$batchDelayed = $campus->getBatchDelayed();
//return page
return View::make('campus.campus', ['yearlyStudentAverage' => $yearlyStudentAverage, 'aveAttrition' => $aveAttrition, 'batchAttrition' => $batchAttrition, 'aveDropouts' => $aveDropouts, 'batchDropouts' => $batchDropouts, 'aveYearsBeforeDropout' => $aveYearsBeforeDropout, 'aveDelayed' => $aveDelayed, 'batchDelayed' => $batchDelayed]);
}
/**
* @param Campus $campus The campus object to add.
*/
protected function doAddCampus($campus)
{
$this->collCampuss[] = $campus;
$campus->setSchool($this);
}
<div id="topo2" align="left">
<img src="../../imgs/topo2/topo2.png" alt="Instituto Federal Baiano" />
<div id="topo2Texto">
<?php
echo $_SESSION["Gnomeprocessoseletivo"];
?>
</div>
</div>
<div align="right" class="admin_logout"><p><a href="../login/logout.php" target="_self">Logout</a></p></div>
<div align="center"><h2>Área Administrativa - Cursos</h2></div>
<?php
/* Acesso ao banco de dados */
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$campus = new Campus();
$vetorcampus = $campus->SelectByAll($conexao);
echo "<form id='excluircampus' name='excluircampus' action='' method='post'>";
echo ' <table width="76%" border="1">';
echo ' <tr>';
echo ' <td width="80%"><strong>Campus</strong></td>';
echo ' <td width="20%"><strong>Excluir</strong></td>';
echo ' </tr>';
foreach ($vetorcampus as $campus) {
echo ' <tr>';
echo ' <td>' . $campus->getNome() . '</td>';
echo " <td><a href='#' onclick='excluir(" . $campus->getIdCampus() . ")'>Excluir</a></td>";
echo ' </tr>';
}
echo ' </table>';
}
private static function convert($row)
{
$participante = new Participante();
$participante->id = $row['id'];
$participante->nome = $row['nome'];
$participante->matricula = $row['matricula'];
$participante->email = $row['email'];
$participante->cpf = $row['cpf'];
$participante->nome_mae = $row['nome_mae'];
$participante->identidade = $row['identidade'];
$participante->tipo = TipoParticipante::find($row['tipo_id']);
if ($participante->tipo->id == 3) {
$participante->quantidade_alunos = $row['quantidade_alunos'];
}
if ($row['data_nascimento'] != "") {
$participante->data_nascimento = date("d/m/Y", strtotime($row['data_nascimento']));
}
if (isset($row['campus_id'])) {
$participante->campus = Campus::find($row['campus_id']);
}
$participante->escola = $row['escola'];
return $participante;
}
</td>
</tr>
<tr>
<td align='right' width="200px">
<label for=campus>Polo:</label>
</td>
<td colspan='2'>
<select id="campus" name="campus" tabindex="25">
<option value="0" selected="selected">Escolha um Polo</option>
<?php
include_once "../classes/DB.php";
include_once "../classes/Campus.php";
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$campus = new Campus(null, null);
$vetorcampus = $campus->SelectByAll($conexao);
/* Varaveis auxiliares */
$i = 0;
$sel = "selected";
$total = count($vetorcampus);
while ($total > $i) {
$nome = $vetorcampus[$i]->getNome();
$codigo = $vetorcampus[$i]->getIdCampus();
echo "<option value=" . $codigo . ">" . strtoupper($nome) . "</option>\n";
$i = $i + 1;
}
?>
</select>
<span class="textoSobrescrito">*</span>
</td>
<img src="../../imgs/topo2/topo2.png" alt="Instituto Federal Baiano" />
<div id="topo2Texto">
<?php
echo $_SESSION["Gnomeprocessoseletivo"];
?>
</div>
</div>
<div align="right" class="admin_logout"><p><a href="../login/logout.php" target="_self">Logout</a></p></div>
<div align="center"><h2>Área Administrativa - Local de Prova</h2></div>
<?php
/* Acesso ao banco de dados */
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$localprova = new Localprova();
$campus = new Campus();
$vetorlocalprova = $localprova->SelectByAll($conexao);
/* Varaveis auxiliares */
$i = 0;
$total = count($vetorlocalprova);
echo "<form id='excluirlocal' name='excluirlocal' action='' method='post'>";
echo ' <table width="76%" border="1">';
echo ' <tr>';
echo ' <td width="50%"><strong>Local de Prova</strong></td>';
echo ' <td width="50%"><strong>Campus</strong></td>';
echo ' <td width="35%"><strong>Excluir</strong></td>';
echo ' </tr>';
foreach ($vetorlocalprova as $local) {
echo ' <tr>';
echo ' <td>' . $local->getnome() . '</td>';
echo ' <td>' . $campus->SelectNomeCampus($conexao, $local->getcampus())->getNome() . '</td>';
/**
* Filter the query by a related Campus object
*
* @param Campus|PropelCollection $campus The related object(s) to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return TermQuery The current query, for fluid interface
*/
public function filterByCampus($campus, $comparison = null)
{
if ($campus instanceof Campus) {
return $this->addUsingAlias(TermPeer::CAMPUS_ID, $campus->getId(), $comparison);
} elseif ($campus instanceof PropelCollection) {
if (null === $comparison) {
$comparison = Criteria::IN;
}
return $this->addUsingAlias(TermPeer::CAMPUS_ID, $campus->toKeyValue('PrimaryKey', 'Id'), $comparison);
} else {
throw new PropelException('filterByCampus() only accepts arguments of type Campus or PropelCollection');
}
}
/**
* Declares an association between this object and a Campus object.
*
* @param Campus $v
* @return Term The current object (for fluent API support)
* @throws PropelException
*/
public function setCampus(Campus $v = null)
{
if ($v === null) {
$this->setCampusId(NULL);
} else {
$this->setCampusId($v->getId());
}
$this->aCampus = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Campus object, it will not be re-added.
if ($v !== null) {
$v->addTerm($this);
}
return $this;
}
<?php
session_start("SELECAO");
session_start();
include "../classes/DB.php";
include "../classes/Campus.php";
$id = addslashes($_GET['id']);
/*Acesso ao banco de dados */
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$campus = new Campus();
$existeCandidatoAssociado = $campus->existeCandidatoAssociado($conexao, $id);
$campus_eliminado = false;
$campus_inativado = false;
if ($existeCandidatoAssociado) {
$campus_inativado = $campus->inativar($conexao, $id);
} else {
$campus_eliminado = $campus->apagar($conexao, $id);
}
if ($campus_eliminado) {
$_SESSION['flashMensagem'] = 'Curso excluido com sucesso.';
} elseif ($campus_inativado) {
$_SESSION['flashMensagem'] = 'O Curso selecionado possui candidatos associados e foi inativado.';
} else {
$_SESSION['flashMensagem'] = 'Problemas ao efetuar o transação.';
}
header('Location: ../login/menu.php');
exit;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="pt-br" xmlns="http://www.w3.org/1999/xhtml">
/**
* Exclude object from result
*
* @param Campus $campus Object to remove from the list of results
*
* @return CampusQuery The current query, for fluid interface
*/
public function prune($campus = null)
{
if ($campus) {
$this->addUsingAlias(CampusPeer::ID, $campus->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('unitfactors', function (Blueprint $table) {
//
$table->increments('id');
$table->integer('unitid');
$table->integer('factorid');
$table->string('type');
$table->decimal('value');
$table->timestamps();
});
//seed table
$campus = Campus::where('unitid', 2)->first();
//employment
$employmentArray = $campus->getEmploymentCount();
//employed
$employmentFactor = new Unitfactor();
$employmentFactor->unitid = 2;
$employmentFactor->factorid = 1;
$employmentFactor->type = "Employed";
$employmentFactor->value = $employmentArray['Employed'];
$employmentFactor->save();
//unemployed
$employmentFactor = new Unitfactor();
$employmentFactor->unitid = 2;
$employmentFactor->factorid = 1;
$employmentFactor->type = "Unemployed";
$employmentFactor->value = $employmentArray['Unemployed'];
$employmentFactor->save();
//grades
$gradeArray = $campus->getGradeCount();
//passed
$gradeFactor = new Unitfactor();
$gradeFactor->unitid = 2;
$gradeFactor->factorid = 2;
$gradeFactor->type = "Passed";
$gradeFactor->value = $gradeArray['Passed'];
$gradeFactor->save();
//failed
$gradeFactor = new Unitfactor();
$gradeFactor->unitid = 2;
$gradeFactor->factorid = 2;
$gradeFactor->type = "Failed";
$gradeFactor->value = $gradeArray['Failed'];
$gradeFactor->save();
//region
$regionArray = $campus->getRegionCount();
//Luzon
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Luzon";
$regionFactor->value = $regionArray['Luzon'];
$regionFactor->save();
//Visayas
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Visayas";
$regionFactor->value = $regionArray['Visayas'];
$regionFactor->save();
//Mindanao
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Mindanao";
$regionFactor->value = $regionArray['Mindanao'];
$regionFactor->save();
//stbracketKey
$stbracketArray = $campus->getSTBracketCount();
//A
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "A";
$stbracketFactor->value = $stbracketArray['A'];
$stbracketFactor->save();
//B
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "B";
$stbracketFactor->value = $stbracketArray['B'];
$stbracketFactor->save();
//C
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "C";
$stbracketFactor->value = $stbracketArray['C'];
$stbracketFactor->save();
//D
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "D";
$stbracketFactor->value = $stbracketArray['D'];
$stbracketFactor->save();
//E1
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "E1";
$stbracketFactor->value = $stbracketArray['E1'];
$stbracketFactor->save();
//E2
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "E2";
$stbracketFactor->value = $stbracketArray['E2'];
$stbracketFactor->save();
}
public function campus()
{
//return 'We Are Working';
//Changed
$data['date'] = $this->getBaseDateTime();
$campus = UserCampus::whereUserId(Auth::user()->id)->first();
if ($campus) {
Session::put('campus', $campus->campus_id);
} else {
Session::put('campus', 1);
}
/*19-May-2015 Ehsan*/
$user = User::find(Auth::user()->id);
$url = Picture::find($user->picture);
$data['self'] = $url;
/*!!!!19-May-2015 Ehsan*/
// Everyday Question Generation
$data['question'] = null;
$data['prev_question'] = null;
$question = Question::orderBy('id', 'desc')->first();
$prev_question = Question::orderBy('id', 'desc')->skip(1)->first();
if ($question) {
$data['question'] = $question;
$data['options_of_question'] = QuestionOption::whereQuestionId($question->id)->get();
//$get_count_of_the_answers = DB::table('users_answers')->select(DB::raw('option_number,count(*) as count'))->join('question_options','users_answers.option_id', '=', 'question_options.id')->whereQuestionId($question->id)->groupBy('option_id')->groupBy('option_number')->orderBy('option_number')->get();
$data['answered'] = UsersAnswer::whereUserId(Auth::user()->id)->whereQuestionId($question->id)->first();
}
if ($prev_question) {
$data['prev_question'] = $prev_question;
$options_of_question = QuestionOption::whereQuestionId($prev_question->id)->get();
$total_answer = 0;
foreach ($options_of_question as $key) {
$current_answer = DB::table('users_answers')->select(DB::raw('count(*) as count'))->whereOptionId($key->id)->first()->count;
$total_answer += $current_answer;
$answers_count[$key->option_number] = array('option_details' => $key->option_details, 'total_answer' => $current_answer);
}
try {
foreach ($options_of_question as $key) {
$cur = $answers_count[$key->option_number]['total_answer'] * 1.0;
$percentage = $cur / $total_answer * 100.0;
$answers_count[$key->option_number]['total_answer'] = number_format((double) $percentage, 2, '.', '');
}
} catch (Exception $e) {
$answers_count[1]['total_answer'] = 33;
$answers_count[2]['total_answer'] = 33;
$answers_count[3]['total_answer'] = 33;
}
$data['total_votes'] = $total_answer;
$data['answers'] = $answers_count;
}
// ENd of Question Related Code
// Top And Flop Post Generation
//return json_encode($data);
$posts = Post::select('posts.*')->join('users', 'users.id', '=', 'posts.user_id')->where('users.disable', '0')->whereType('2')->whereCampusId(Session::get('campus'))->orderBy('posts.id', 'desc')->take(30)->lists('id');
$top_post = DB::table('likes')->select(DB::raw('count(*) as like_count, post_id'))->whereIn('post_id', $posts)->orderBy('like_count', 'desc')->groupBy('post_id')->first();
// return json_encode($top_post);
$flop_post = DB::table('dislikes')->select(DB::raw('count(*) as dislike_count, post_id'))->whereIn('post_id', $posts)->orderBy('dislike_count', 'desc')->groupBy('post_id')->first();
$data['flop_post'] = null;
$data['top_post'] = null;
if ($top_post) {
$post = Post::whereId($top_post->post_id)->first();
/*19-May-2015 Ehsan*/
$user = User::find($post->user_id);
$url = Picture::find($user->picture);
$url = $url->url;
/*!!!!19-May-2015 Ehsan*/
$text = htmlentities($post->post);
/*Eve-26-May-Ehsan*/
/*!!!!Eve-26-May-Ehsan*/
$text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text);
$text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text);
$text = nl2br($text);
$text = Emojione::shortnameToImage($text);
$now = Carbon::parse($post->created_at);
$data['top_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans());
} else {
$data['top_post'] = null;
}
if ($flop_post) {
$post = Post::whereId($flop_post->post_id)->first();
/*19-May-2015 Ehsan*/
$user = User::find($post->user_id);
$url = Picture::find($user->picture);
$url = $url->url;
/*!!!!19-May-2015 Ehsan*/
$text = htmlentities($post->post);
/*Eve-26-May-Ehsan*/
/*!!!!Eve-26-May-Ehsan*/
$text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text);
$text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text);
$text = nl2br($text);
$text = Emojione::shortnameToImage($text);
$now = Carbon::parse($post->created_at);
$data['flop_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans());
} else {
$data['flop_post'] = null;
}
// Top And Flop Post Generation end
// Get All Available Reports and Feelings
$data['feelings'] = Feeling::get();
$data['reports'] = Report::get();
//
$data['notifications'] = $this->getNotification();
//Get Current Trends
$now = Carbon::now();
$before_12hours = Carbon::now()->subHours(12);
$data['tags'] = DB::table('hash_tagged_posts')->select('tag_id', 'tag', DB::raw('count(*) as count'))->join('hashtags', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) {
$query->select('id')->from('posts')->whereType('2')->where('campus_id', Session::get('campus'));
})->whereBetween('hash_tagged_posts.created_at', array($before_12hours, $now))->groupBy(['tag_id', 'tag'])->orderBy('count', 'desc')->take(3)->get();
//Get Current Trends End
$data['page'] = "campus";
$campus = UserCampus::whereUserId(Auth::user()->id)->first();
if ($campus == null || $campus->campus_id == '1') {
$data['page'] = "campus";
$data['top_post'] = null;
$data['flop_post'] = null;
$data['posts'] = null;
$data['isValid'] = "0";
$data['campuses'] = Campus::all();
return View::make('campus')->with('data', $data);
}
$data['isValid'] = "1";
$data['campus'] = Campus::find(Session::get('campus'))->name;
return View::make('campus')->with('data', $data);
}
<?php
include_once dirname(__FILE__) . '/../inc/config.inc.php';
include_once dirname(__FILE__) . '/../model/TipoParticipante.class.php';
include_once dirname(__FILE__) . '/../inc/helper.inc.php';
include_once dirname(__FILE__) . '/../model/Campus.class.php';
if (!recebendo_submissao_trabalhos()) {
header("location: /" . $config['PATH'] . "/index.php?syserror=SUBMISSAO_TRABALHOS_ENCERRADA");
exit;
}
$tipos = TipoParticipante::all();
$campi = Campus::all();
?>
<!DOCTYPE HTML>
<html lang="pt-br">
<head>
<?php
include_once dirname(__FILE__) . '/../inc/head.inc.php';
?>
<script type="text/javascript">
jQuery(function($){
$("#cpf").mask("999.999.999-99");
$("#login_cpf").mask("999.999.999-99");
$("#data_nascimento").mask("99/99/9999");
$(".help-inline").hide();
$("#quantidade_alunos_field").hide();
$("#campus_field").hide();
$("#escola_field").hide();
});
include_once dirname(__FILE__) . '/../inc/helper.inc.php';
include_once dirname(__FILE__) . '/../model/Participante.class.php';
include_once dirname(__FILE__) . '/../model/Atividade.class.php';
include_once dirname(__FILE__) . '/../model/Inscricao.class.php';
include_once dirname(__FILE__) . '/../model/TipoParticipante.class.php';
include_once dirname(__FILE__) . '/../model/Campus.class.php';
$nome = $_POST['nome'];
$nome_mae = $_POST['nome_mae'];
$identidade = $_POST['identidade'];
$cpf = $_POST['cpf'];
$data_nascimento = $_POST['data_nascimento'];
$email = $_POST['email'];
$tipo = TipoParticipante::find($_POST['tipo_id']);
$quantidade_alunos = $_POST['quantidade_alunos'];
if ($_POST['tipo_id'] == 1 || $_POST['tipo_id'] == 2) {
$campus = Campus::find($_POST['campus_id']);
}
$escola = $_POST['escola'];
$participante = Participante::find_by_cpf($cpf);
if (isset($participante)) {
header("location: /" . $config['PATH'] . "/inscricoes/form_login.php?syserror=CPF_JA_INSCRITO");
exit;
}
$participante = new Participante();
$participante->nome = $nome;
$participante->nome_mae = $nome_mae;
$participante->identidade = $identidade;
$participante->cpf = $cpf;
$participante->data_nascimento = $data_nascimento;
$participante->email = $email;
$participante->tipo = $tipo;
<?php
require_once 'autoload.php';
if (isset($_REQUEST['opcao'])) {
//------------ inserir_campus ----------------------
if ($_REQUEST['opcao'] == 'inserir_campus') {
$nome_campus = $_REQUEST['nome_campus'];
$cidade_campus = $_REQUEST['cidade_campus'];
$id_instituicao = $_REQUEST['id_instituicao'];
$campus = new Campus();
$campus->setFkInstituicao($id_instituicao);
$campus->setNome($nome_campus);
$campus->setCidade($cidade_campus);
$dao_campus = new CampusMySqlDAO();
$id_campus = $dao_campus->insert($campus);
echo $id_campus;
exit;
} else {
if ($_REQUEST['opcao'] == 'getCampi') {
ViewUsuario::viewCampusAjax();
}
}
}
/* Acesso ao banco de dados */
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$inscrito = new Inscrito();
if ($id) {
$objinscrito = $inscrito->SelectById($conexao, $id);
} elseif ($cpf) {
$objinscrito = $inscrito->SelectByCpf($conexao, $cpf);
}
if (empty($objinscrito[0])) {
$_SESSION['flashMensagem'] = 'CPF não encontrado na nossa base de dados.';
header("Location:" . $_SERVER['HTTP_REFERER']);
exit;
}
// Obter Campus
$campus = new Campus(null, null);
$campusInscrito = $objinscrito[0]->getcampus();
$vetorCampusIncrito = $campus->SelectNomeCampus($conexao, $campusInscrito);
$nomeCampus = $vetorCampusIncrito->getNome();
// Obter Curso
$nomeCurso = new Curso();
$nomeCurso = $nomeCurso->SelectByPrimaryKey($conexao, $objinscrito[0]->getcurso());
$nomeCurso = $nomeCurso[0]->getnome();
// Obter Local Prova
$local_prova = new Localprova(null, null, null);
// Obter UF
$estado = new UnidadeFederativa(null, null);
$estadoId = $objinscrito[0]->getestado();
$vetorEstadoNome = $estado->SelectNomeUnidadeFederativa($conexao, $estadoId);
$estadoNome = $vetorEstadoNome[0]->getNome();
// Obter Município
/**
* Filter the query by a related Campus object
*
* @param Campus $campus the related object to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return SchoolQuery The current query, for fluid interface
*/
public function filterByCampus($campus, $comparison = null)
{
if ($campus instanceof Campus) {
return $this->addUsingAlias(SchoolPeer::ID, $campus->getSchoolId(), $comparison);
} elseif ($campus instanceof PropelCollection) {
return $this->useCampusQuery()->filterByPrimaryKeys($campus->getPrimaryKeys())->endUse();
} else {
throw new PropelException('filterByCampus() only accepts arguments of type Campus or PropelCollection');
}
}
/**
* method Delete()
* Delete a record
*/
function Delete($param)
{
try {
$key = $param['key'];
// get the parameter $key
TTransaction::open('saciq');
// open a transaction with database
$object = new Campus($key, FALSE);
// instantiates the Active Record
$object->delete();
// deletes the object from the database
TTransaction::close();
// close the transaction
$this->onReload($param);
// reload the listing
new TMessage('info', 'Registro excluído');
// success message
} catch (Exception $e) {
if ($e->getCode() == 23000) {
new TMessage('error', '<b>Registro duplicado</b><br>Verifique os campos inseridos e tente novamente');
} else {
if ($e->getCode() == 0) {
new TMessage('error', '<b>Error</b> <br>' . $e->getMessage());
} else {
new TMessage('error', '<b>Error Desconhecido</b> <br>Código: ' . $e->getCode());
}
}
// desfazer todas as operacoes pendentes
TTransaction::rollback();
}
}
<?php
session_start("SELECAO");
session_start();
include "../classes/DB.php";
include "../classes/Campus.php";
$nome = addslashes($_POST['nome']);
/* Acesso ao banco de dados */
$banco = DB::getInstance();
$conexao = $banco->ConectarDB();
$campus = new Campus(null, $nome);
$resultado = $campus->Inserir($conexao);
if ($resultado == true) {
$_SESSION['flashMensagem'] = 'Campus cadastrado com sucesso.';
} else {
$_SESSION['flashMensagem'] = 'Problemas ao efetuar o transação.';
}
header('Location: ../login/menu.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="pt-br" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title> <?php
echo $_SESSION["Gnomeprocessoseletivo"];
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<link href="../../estilo_selecao.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function delayer(){
window.location = '../login/login.php';
