/**
* Busca a categoria a partir do id
* @param INT $Category - ID do usuário cadastrado no banco
* @return STRING - retorna o nome da categoria
*/
public function getCategory($Category)
{
$this->CatId = $Category;
$read = new Read();
$read->FullRead("SELECT cat_name FROM " . DB_PRODUTOS_CATEGORIAS . " WHERE cat_id = :id", "id={$this->CatId}");
return $read->getResult()[0]['cat_name'];
}
private function getSyntax()
{
$read = new Read();
$read->ExeRead($this->Tabela, $this->Termos, $this->Places);
$this->Rows = $read->getRowCount();
if ($this->Rows > $this->Limite) {
$Paginas = ceil($this->Rows / $this->Limite);
$MaxLinks = $this->MaxLinks;
$this->Paginator = "<ul class=\"paginator\">";
$this->Paginator .= "<li><a title=\"{$this->First}\" href=\"{$this->Link}1\">{$this->First}</a></li>";
for ($iPag = $this->Page - $MaxLinks; $iPag <= $this->Page - 1; $iPag++) {
if ($iPag >= 1) {
$this->Paginator .= "<li><a title=\"Página {$iPag}\" href=\"{$this->Link}{$iPag}\">{$iPag}</a></li>";
}
}
$this->Paginator .= "<li><span class=\"active\">{$this->Page}</span></li>";
for ($dPag = $this->Page + 1; $dPag <= $this->Page + $MaxLinks; $dPag++) {
if ($dPag <= $Paginas) {
$this->Paginator .= "<li><a title=\"Página {$dPag}\" href=\"{$this->Link}{$dPag}\">{$dPag}</a></li>";
}
}
$this->Paginator .= "<li><a title=\"{$this->Last}\" href=\"{$this->Link}{$Paginas}\">{$this->Last}</a></li>";
$this->Paginator .= "</ul>";
}
}
/**
* Busca o login do usuário a partir do user_id
* @param INT $userid - ID do usuário cadastrado no banco
* @return STRING - retorna o login do usuário
*/
public function getUserName($UserId)
{
$this->UserId = $UserId;
$read = new Read();
$read->FullRead("SELECT user_login FROM " . DB_USERS . " WHERE user_id = :id", "id={$this->UserId}");
return $read->getResult()[0]['user_login'];
}
private function getSyntax()
{
$read = new Read();
$read->ExeRead($this->Table, $this->Terms, $this->Places);
$this->Rows = $read->getRowCount();
// Verifica se tem resultados para que se faça a paginação
if ($this->Rows > $this->Limit) {
// Divide a quantidade de resultados (Rows) pelo limite para obter a quantidade de páginas
$Paginas = ceil($this->Rows / $this->Limit);
$MaxLinks = $this->MaxLinks;
$this->Paginator = "<ul class=\"paginator\">";
$this->Paginator .= "<li><a title=\"{$this->First}\" href=\"{$this->Link}1\">{$this->First}</a></li>";
for ($iPag = $this->Page - $MaxLinks; $iPag <= $this->Page - 1; $iPag++) {
if ($iPag >= 1) {
$this->Paginator .= "<li><a title=\"Página {$iPag}\" href=\"{$this->Link}{$iPag}\">{$iPag}</a></li>";
}
}
$this->Paginator .= "<li><span class=\"active\">{$this->Page}</span></li>";
for ($dPag = $this->Page + 1; $dPag <= $this->Page + $MaxLinks; $dPag++) {
if ($dPag <= $Paginas) {
$this->Paginator .= "<li><a title=\"Página {$dPag}\" href=\"{$this->Link}{$dPag}\">{$dPag}</a></li>";
}
}
$this->Paginator .= "<li><a title=\"{$this->Last}\" href=\"{$this->Link}{$Paginas}\">{$this->Last}</a></li>";
$this->Paginator .= "</ul>";
}
}
private function getSyntax()
{
$read = new Read();
$read->ExeRead($this->tabela, $this->termos, $this->places);
$this->rows = $read->getRowCount();
if ($this->rows > $this->limit) {
$paginas = ceil($this->rows / $this->limit);
$maxLinks = $this->maxLinks;
$this->paginator = "<ul class=\"paginator\">";
$this->paginator .= "<li><a title=\"{$this->first}\" href=\"{$this->link}1\">{$this->first}</a></li>";
for ($iPag = $this->page - $maxLinks; $iPag <= $this->page - 1; $iPag++) {
if ($iPag >= 1) {
$this->paginator .= "<li><a title=\"Página {$iPag}\" href=\"{$this->link}{$iPag}\">{$iPag}</a></li>";
}
}
$this->paginator .= "<li><span=\"active\">{$this->page}</li>";
for ($dPag = $this->page + 1; $dPag <= $this->page + $maxLinks; $dPag++) {
if ($dPag <= $paginas) {
$this->paginator .= "<li><a title=\"Página {$dPag}\" href=\"{$this->link}{$dPag}\">{$dPag}</a></li>";
}
}
$this->paginator .= "<li><a title=\"{$this->last}\" href=\"{$this->link}{$paginas}\">{$this->last}</a></li>";
$this->paginator .= "</ul>";
}
}
public function ExeStatus($PostId, $PostStatus)
{
$this->Post = (int) $PostId;
$this->Data['post_status'] = (string) $PostStatus;
$Read = new Read('ws_posts');
$this->Data['post_id'] = $this->Post;
$Read->update($this->Data);
}
private function setName()
{
$Where = isset($this->Post) ? "post_id != {$this->Post} and" : '';
$readName = new Read();
$readName->ExeRead(self::Entity, "where {$Where} post_title = :t", "t={$this->Data['post_title']}");
if ($readName->getResult()) {
$this->Data['post_name'] = $this->Data['post_name'] . '-' . $readName->getRowCount();
}
}
public function Trabalho($parametro)
{
include_once 'app/View/header.php';
$tipoAtividade = new Read();
$tipoAtividade->ExeRead('tipo_atividades');
include_once 'app/View/form-trabalho.php';
$parametro = $parametro;
include_once 'app/View/footer.php';
}
public static function UserOnline()
{
$now = Date('Y-m-d H:i:s');
$deleteUserOnline = new Delete();
$deleteUserOnline->ExeDelete('ws_siteviews_online', "WHERE online_endview < :now", "now={$now}");
$readUserOnline = new Read();
$readUserOnline->ExeRead('ws_siteviews_online');
return $readUserOnline->getRowCount();
}
private function select()
{
$ReadBanco = new Read();
$ReadBanco->ExeRead(self::entidade, ($this->id != 0 ? 'WHERE id = :id' : null) . ' ORDER BY sigla', $this->id != 0 ? "id={$this->id}" : null);
if ($ReadBanco->getRowCount() > 0) {
$this->result = $ReadBanco->getResult();
} else {
$this->result = null;
}
}
private function select()
{
$read = new Read();
$read->ExeRead(self::entidade, ($this->id != 0 ? 'WHERE id = :id' : '') . ' ORDER BY nome', $this->id != 0 ? "id={$this->id}" : null);
if ($read->getRowCount() > 0) {
$this->result = $read->getResult();
} else {
$this->result = null;
}
}
private function getNames($nutri)
{
$read = new Read();
$read->FullRead("SELECT nutri_name FROM " . DB_NUTRICAO . " WHERE nutri_id = :id", "id={$nutri}");
if ($read->getResult()) {
return $read->getResult()[0]['nutri_name'];
} else {
return null;
}
}
private function setName()
{
$email = $this->Data['email'];
$readName = new Read();
$readName->ExeRead(self::Entity, "WHERE cpf = {$this->Data['cpf']} or email = '{$email}'");
if ($readName->getResult()) {
$this->Msg = "<script>alert('Ja possui Cadastrado em Nosso Sitema!');</script>";
} else {
$this->Create();
}
}
/**
* Obtem o player com o id tal
* @return $Array [] de player
*/
public static function GetAccountId($id)
{
$Read = new Read();
$Read->ExeRead('players', "WHERE id = :id", "id={$id}");
$Result = $Read->getResult();
if ($Result) {
return $Result;
} else {
return false;
}
}
private function getUser()
{
$read = new Read();
$read->ExeRead('pessoas', "WHERE email = :e AND senha = :p", "e={$this->Email}&p={$this->Senha}");
if ($read->getResult()) {
$this->Result = $read->getResult()[0];
return true;
} else {
return false;
}
}
public function getInstituicao($id)
{
$read = new Read();
$read->Reader(self::Entity, 'inner join tb_logradouros on ' . self::Entity . '.tb_logradouros_logradouro_id = tb_logradouros.logradouro_id ' . 'inner join tb_bairros on tb_logradouros.tb_bairros_bairros_id = tb_bairros.bairros_id ' . 'inner join tb_cidade on tb_cidade.cidade_id = tb_bairros.tb_cidade_cidade_id ' . 'where instituicao_id = :id', "id={$id}");
if ($read->getResult()) {
$this->result = $read->getResult();
$this->rowcount = $read->getRowCount();
} else {
$this->result = false;
$this->rowcount = 0;
}
}
private function getUser()
{
$this->senha = md5($this->senha);
$read = new Read();
$read->ExeRead('usuario', "WHERE login = :e AND senha = :p", "e={$this->login}&p={$this->senha}");
if ($read->getResult()) {
$this->result = $read->getResult()[0];
return true;
} else {
return false;
}
}
private function getUser()
{
$this->Senha = md5($this->Senha);
$read = new Read();
$read->ExeRead("ws_users", "WHERE user_email = :e AND user_password = :p", "e={$this->Email}&p={$this->Senha}");
if ($read->getResult()) {
$this->Result = $read->getResult()[0];
return TRUE;
} else {
return FALSE;
}
}
private function setName()
{
$Where = !empty($this->CatId) ? "category_id != {$this->CatId} AND" : '';
$categoria = $this->Data['category_title'];
$readName = new Read();
$readName->ExeRead(self::Entity, "WHERE {$Where} category_title = :t", "t={$this->Data['category_title']}");
if ($readName->getResult()) {
$this->Error = ["<b>Erro ao Cadastrar:</b> Categoria ja está cadastrada", WS_ERROR];
} else {
$this->Create();
}
}
private function checkPessoa()
{
$ReadPessoa = new Read();
$ReadPessoa->ExeRead(self::entidade, "WHERE cadastro = :cadastro", "cadastro={$this->dados['cadastro']}");
if ($ReadPessoa->getRowCount() > 0) {
$this->result = false;
$this->error = ["A identificação {$this->dados['cadastro']} já consta no sistema", WS_ALERT];
return false;
} else {
return true;
}
}
private function GetUser()
{
$this->Pass = md5($this->Pass);
$read = new Read();
$read->ExeRead('user', "WHERE email = :e AND password = :p", "e={$this->Email}&p={$this->Pass}");
if ($read->getResult()) {
$this->Result = $read->getResult()[0];
return true;
} else {
return FALSE;
}
}
public function getMotorista($idmotorista)
{
$read = new Read();
$read->Reader(self::Entity, 'inner join tb_logradouros on ' . self::Entity . '.tb_logradouros_logradouro_id = tb_logradouros.logradouro_id ' . 'inner join tb_bairros on tb_logradouros.tb_bairros_bairros_id = tb_bairros.bairros_id ' . ' where motorista_id = :id', "id={$idmotorista}");
if ($read->getResult()) {
$this->result = $read->getResult();
$this->rowcount = $read->getRowCount();
} else {
$this->result = false;
$this->rowcount = 0;
}
}
function handle_update()
{
$read = new Read(intval($_POST['id']));
if ($read->is_valid) {
$read['status'] = $_POST['status'];
if ($read->update()) {
$title_author = '<b>' . $read['title'] . '</b> by ' . $read['author'];
notice("Status updated sucessfully for {$title_author}.");
} else {
error("An error occured updating {$title_author}");
}
}
}
public function GravarTrabalho()
{
$this->dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
if (isset($_FILES['fileUpload'])) {
$nome = $this->dados['titulo'];
$ext = strtolower(substr($_FILES['fileUpload']['name'], -4));
//Pegando extensão do arquivo
$new_name = $nome . $ext;
//Definindo um novo nome para o arquivo
$this->LinkAnexo = $new_name;
$dir = 'uploads/';
//Diretório para uploads
move_uploaded_file($_FILES['fileUpload']['tmp_name'], $dir . $new_name);
//Fazer upload do arquivo
} else {
echo "<script>alert('nao foi possivel anexar o arquivo!');</script>";
}
if ($this->dados['tipoAtividade'] == "Palestra") {
$tipoA = 1;
} elseif ($this->dados['tipoAtividade'] == "MiniCurso") {
$tipoA = 2;
} else {
$tipoA = 3;
}
//atualiza pessoa
$updateP = new Update();
$dadosUp = ["curriculo" => $this->dados['perfil'], "nivel" => 1, "telefone" => $this->dados['telefone']];
$updateP->ExeUpdate('pessoas', $dadosUp, "where codigo = :id", "id={$this->dados['idPes']}");
//cadastra Trabalho
$cadastrarT = new Create();
$Dados = ["resumo" => $this->dados['resumo'], "data_submetido" => date("Y-m-d"), "tipo_atividade" => $tipoA, "anexo" => $this->LinkAnexo, "status" => "N", "titulo" => $this->dados['titulo']];
$cadastrarT->ExeCreate('trabalhos', $Dados);
$this->idT = $cadastrarT->getResult();
// Vincula o auto trabalho
$cadastraAT = new Create();
$DadosAT = ["codigo_trabalho" => (int) $this->idT, "codigo_autor" => (int) $this->dados['idPes'], "codigo_evento" => 1];
$cadastraAT->ExeCreate('autor_trabalho', $DadosAT);
// pega dados da pessoa
$pessoa = new Read();
$pessoa->ExeRead('pessoas', "where codigo = :id", "id={$this->dados['idPes']}");
foreach ($pessoa->getResult() as $resulPes) {
extract($resulPes);
//Enviar o Email.
$enviarEmail = new Email();
$DadosEmail = ["Assunto" => "Confirmação da Submição de Trabalho DeepDay", "Mensagem" => "Seu Trabalho foi submetido com sucesso.", "RemetenteNome" => "Equipe DeepDay", "RemetenteEmail" => "*****@*****.**", "DestinoNome" => $nome, "DestinoEmail" => $email];
$enviarEmail->Enviar($DadosEmail);
}
echo "<script>alert('Seu trabalho foi submetido com sucesso!');</script>";
echo "<script>window.location.assign('" . BASE . "/painel')</script>";
}
function handle_create()
{
$read = new Read(intval($_POST['read_id']));
if ($read->is_valid) {
$params = array('notes' => $_POST['content']);
if ($read->update($params)) {
notice('Updated!');
} else {
error_log('update failed');
}
} else {
error('No Read by that id.');
}
}
public function Login($user, $pass)
{
$pass = md5($pass);
$read = new Read();
$read->Reader('tb_users', 'where user_login = :user and user_pass = :pass', "user={$user}&pass={$pass}");
if ($read->getResult()) {
$data = $read->getResult();
$_SESSION['schoolbus_login'] = array('username' => $data[0]['user_login'], 'user_url' => $data[0]['user_url'], 'user_nome' => $data[0]['user_nome'], 'nivel' => $data[0]['user_nivel']);
return true;
} else {
if (isset($_SESSION['schoolbus_login'])) {
unset($_SESSION['schoolbus_login']);
}
return false;
}
}
function widget($args, $instance)
{
extract($args);
$title = apply_filters('widget_title', $instance['title']);
$max_columns = $instance['max_columns'];
$sex = $instance['sex'];
$show_sex = isset($instance['show_sex']) ? $instance['show_sex'] : false;
$readings = Read::all(Read::Begun);
if (count($readings) > 0) {
echo $before_widget;
if ($title) {
echo $before_title . $title . $after_title;
}
foreach ($readings as $read) {
echo '<div class="reading">';
if ($read['link'] !== '') {
echo '<a href="' . $read['link'] . '">';
}
if ($read['illustration']) {
echo '<img src="' . $read['illustration'] . '" />';
}
echo '<b>' . $read['title'] . '</b>';
if ($read['link'] !== '') {
echo '</a>';
}
echo '<br />' . $read['author'];
echo '</div>';
}
echo $after_widget;
}
}
public function testSeek()
{
$offset = 5;
$whence = SEEK_SET;
$result = 'content';
$this->driver->expects($this->once())->method('fileSeek')->with($this->resource, $offset, $whence)->will($this->returnValue($result));
$this->assertEquals($result, $this->file->seek($offset, $whence));
}
/**
* Sets office and code if they are present.
*
* @access public
*/
public function __construct($office = null, $code = null)
{
parent::__construct();
$this->add('type', 'article');
if (null !== $office) {
$this->setOffice($office);
}
if (null !== $code) {
$this->setCode($code);
}
}
public function show($id, $slug)
{
$post = Post::where('id', $id)->where('slug', $slug)->with('user.profile')->firstOrFail();
Read::setReadPoints($post);
$title = "Question";
$currentQuestion = Question::getCurrentQuestion();
$points_pct = Question::getTotalPointsPct($currentQuestion);
$remaining_time = Question::getRemainingTime($currentQuestion);
$posts = Post::getRandPosts($currentQuestion);
return View::make('posts.show')->with(['question' => $currentQuestion, 'remaining_time' => $remaining_time, 'points_pct' => $points_pct, 'posts' => $posts, 'selected_post' => $post, 'title' => $title]);
}
