private function setData() { $this->Data = array_map('strip_tags', $this->Data); $this->Data = array_map('trim', $this->Data); $this->Data['category_name'] = Check::Name($this->Data['category_title']); $this->Data['category_date'] = Check::Data($this->Data['category_date']); $this->Data['category_parent'] = $this->Data['category_parent'] == 'null' ? null : $this->Data['category_parent']; }
public static function Data($Data) { self::$Format = explode(' ', $Data); self::$Data = explode('/', self::$Format[0]); if (empty(self::$Format[1])) { self::$Format[1] = date('H:i:s'); } self::$Data = self::$Data[2] . '-' . self::$Data[1] . '-' . self::$Data[0] . ' ' . self::$Format[1]; return self::$Data; }
public static function Image($ImageUrl, $ImageDesc, $ImageW = NULL, $ImageH = NULL) { self::$Data = 'uploads/' . $ImageUrl; if (file_exists(self::$Data) && !is_dir(self::$Data)) { $patch = HOME; $imagem = self::$Data; return "<img src=\"{$patch}/tim.php?src={$patch}/{$imagem}&w={$ImageW}&h={$ImageH}\" alt=\"{$ImageDesc}\" title=\"{$ImageDesc}\"/>"; } else { return FALSE; } }
/** * **************************************** * *********** PRIVATES ******************* * **************************************** */ private function setDados($Data) { if (in_array('', $Data)) { $this->Result = false; $this->Error = ["<b>Erro de insersão:</b> Para efetuar esta ação, preencha todos os campos!", WS_ALERT]; } else { $this->Data = $Data; $this->Data = array_map("trim", $this->Data); $this->Data = array_map("strip_tags", $this->Data); $this->Data['setor_date'] = Check::Data($this->Data['setor_date']); return true; } }
private function setData() { $Cover = $this->Data['post_cover']; $Content = $this->Data['post_content']; unset($this->Data['post_cover'], $this->Data['post_content']); $this->Data = array_map('strip_tags', $this->Data); $this->Data = array_map('trim', $this->Data); $this->Data['post_name'] = Check::Name($this->Data['post_title']); $this->Data['post_date'] = Check::Data($this->Data['post_date']); $this->Data['post_type'] = 'post'; $this->Data['post_cover'] = $Cover; $this->Data['post_content'] = $Content; $this->Data['post_cat_parent'] = $this->getCatParent(); }
private function getStringLog() { $orderBy = ' ORDER BY '; $fields = []; $order = []; $i = 0; $this->Sentence = "SELECT created_date, action, user_id, answer, ip FROM " . DB_LOGS . " WHERE "; if ($this->UserId != null) { $fields[$i] = "user_id IN (" . implode(", ", $this->UserId) . ")"; $order[$i++] = "user_id ASC"; } if ($this->StartDate != '') { $fields[$i] = "created_date BETWEEN '" . substr(Check::Data($this->StartDate), 0, 10) . "'"; if ($this->EndDate != '') { $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; } else { $fields[$i] .= " AND CURRENT_DATE()"; } $order[$i] = "created_date DESC"; $i++; } elseif ($this->StartDate == '' && $this->EndDate != '') { $fields[$i] = "created_date BETWEEN '2014-01-01'"; $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; $order[$i] = "created_date DESC"; $i++; } if ($this->Action == 'l') { $fields[$i++] = "action LIKE '%' :action1 '%' OR action LIKE '%' :action2 '%'"; } elseif ($this->Action != 't') { $fields[$i++] = "action LIKE '%' :action '%'"; } if ($this->Answer == 'Sucesso') { $fields[$i] = "answer LIKE '%' 'Sucesso' '%'"; } elseif ($this->Answer == 'Erro') { $fields[$i] = "answer LIKE '%' 'Erro' '%'"; } if (count($order) > 0) { $this->Sentence .= implode(' AND ', $fields) . $orderBy . implode(', ', $order); } else { $this->Sentence .= implode(' AND ', $fields); } if ($i == 0) { $this->Sentence = str_replace(" WHERE ", "", $this->Sentence); } }
/** * <b>Cria Cardápio:</b> Cria o esqueleto do cardápio com a data desejada para edição das informaçoes posteriores * @param array $Data - Atribuitivo * @param INT $userId = id do usuário que está criando o registro */ public function ExeCreateCardapio(array $Data, $userId) { $this->Data = $Data; $this->UserId = $userId; if (!empty($this->Data['cardapio_dia'])) { $readCardapio = new Read(); $readCardapio->FullRead("SELECT id FROM " . DB_NUTRICAO_CARDAPIO_DIA . " WHERE cardapio_dia = :dia", "dia=" . substr(Check::Data($this->Data['cardapio_dia']), 0, 10)); if (!$readCardapio->getResult()) { $this->Data['cardapio_dia'] = substr(Check::Data($this->Data['cardapio_dia']), 0, 10); $this->setCreateDate(); $this->setCreatedBy(); $this->Create(DB_NUTRICAO_CARDAPIO_DIA); } else { $this->Result = false; $this->Error = ["Erro ao criar cardápio. Cardápio já existe.", TW_ERROR]; } } else { $this->Result = false; $this->Error = ["Erro ao criar cardápio. Verifique se preencheu corretamente.", TW_ERROR]; } }
private function getStringFull() { $orderBy = ' ORDER BY '; $fields = []; $order = []; $i = 0; $this->Sentence = "SELECT t1.*, t2.visitante_nome FROM " . DB_VISITAS . " t1 INNER JOIN " . DB_VISITANTES . " t2 ON (t1.visitante_id = t2.visitante_id) WHERE "; if ($this->UserId != null) { $fields[$i] = "t1.visitante_id IN (" . implode(", ", $this->UserId) . ")"; $order[$i++] = "t2.visitante_nome ASC"; } if ($this->StartDate != '') { $fields[$i] = "t1.visita_data_entrada BETWEEN '" . substr(Check::Data($this->StartDate), 0, 10) . "'"; if ($this->EndDate != '') { $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; } else { $fields[$i] .= " AND CURRENT_DATE()"; } $order[$i] = "t1.visita_data_entrada DESC"; $i++; } elseif ($this->StartDate == '' && $this->EndDate != '') { $fields[$i] = "t1.visita_data_entrada BETWEEN '2014-01-01'"; $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; $order[$i] = "t1.visita_data_entrada DESC"; $i++; } if (count($order) > 0) { $this->Sentence .= implode(' AND ', $fields) . $orderBy . implode(', ', $order); } else { $this->Sentence .= implode(' AND ', $fields); } }
/** * <b>Imagem Upload:</b> Ao executar este HELPER, ele automaticamente verifica a existencia da imagem na pasta * uploads. Se existir retorna a imagem redimensionada! * @return HTML = imagem redimencionada! */ public static function Image($ImageUrl, $ImageDesc, $ImageW = null, $ImageH = null) { self::$Data = $ImageUrl; if (file_exists(self::$Data) && !is_dir(self::$Data)) { $patch = HOME; $imagem = self::$Data; return "<img src=\"{$patch}/tim.php?src={$patch}/{$imagem}&w={$ImageW}&h={$ImageH}\" alt=\"{$ImageDesc}\" title=\"{$ImageDesc}\" class='img-thumbnail'/>"; } else { return false; } }
<!DOCTYPE html> <html lang="pt-br"> <head> <meta charset="UTF-8"> <title>WS PHP - Helpers :: Manipulação e Validação</title> </head> <body> <?php require './_app/Config.inc.php'; //$check = new Check(); //var_dump($check); $Email = 'bruno.gmail.com'; if (Check::Email($Email)) { echo 'Válido!<hr>'; } else { echo 'Inválido!<hr>'; } $Name = 'Estamos aprendendo PHP. Veja você como é!'; echo Check::Name($Name) . '<hr>'; $Data = '21/12/2015 20:36:10'; echo Check::Data($Data) . '<hr>'; ?> </body> </html>
private function setData() { if ($this->Data['visita_data_entrada'] !== '') { $updateData['visita_data_entrada'] = Check::Data($this->Data['visita_data_entrada'] . ' ' . $this->Data['visita_hora_entrada']); } if ($this->Data['visita_data_saida'] !== '') { $updateData['visita_data_saida'] = Check::Data($this->Data['visita_data_saida'] . ' ' . $this->Data['visita_hora_saida']); } unset($this->Data['visita_data_entrada']); unset($this->Data['visita_hora_entrada']); unset($this->Data['visita_data_saida']); unset($this->Data['visita_hora_saida']); $read = new Read(); $read->ExeRead(DB_VISITAS, "WHERE visitante_id = :id ORDER BY id DESC LIMIT 1", "id={$this->VisitanteId}"); if (isset($updateData)) { $update = new Update(); $update->ExeUpdate(DB_VISITAS, $updateData, "WHERE id = :id", "id={$read->getResult()[0]['id']}"); } }
private function setData() { $cover = !empty($this->Data['user_cover']) ? $this->Data['user_cover'] : NULL; unset($this->Data['user_cover']); $this->Data = array_map('strip_tags', $this->Data); $this->Data = array_map('trim', $this->Data); $this->Data['user_birthday'] = Check::Data($this->Data['user_birthday']); $this->Data['user_cover'] = !empty($cover) ? $cover : NULL; if (!Check::Email($this->Data['user_email'])) { $this->Error = ['<b>Oppss, email Inválido</b>, por favor preencha corretamente o campo.', WS_ALERT]; $this->Data['user_email'] = null; $this->Result = null; } // $this->Data['user_level'] = 5; $this->Data['user_status'] = 1; $this->Data['user_registration'] = date('Y-m-d H:i:s', time()); $this->Data['user_lastupdate'] = date('Y-m-d H:i:s', time()); if (!empty($this->Data['user_password'])) { $this->Data['user_password'] = md5($this->Data['user_password']); } else { unset($this->Data['user_password']); } }
private function getStringFull() { $orderBy = ' ORDER BY '; $groupBy = " GROUP BY t1.prod_name, t3.reg_action "; $fields = []; $order = []; $i = 0; $this->Sentence = "SELECT t1.prod_name, t1.prod_unidade, t3.reg_quantidade, t2.cat_name, t3.reg_action, t3.reg_data, t3.reg_motivo, t3.reg_descricao FROM " . DB_PRODUTOS . " t1 INNER JOIN " . DB_PRODUTOS_CATEGORIAS . " t2 ON (t1.prod_categoria = t2.cat_id) INNER JOIN " . DB_PRODUTOS_REGISTRO . " t3 ON (t1.prod_id = t3.prod_id) WHERE "; $this->SumSentence = "SELECT t1.prod_name, t1.prod_quantidade, t1.prod_unidade, t2.cat_name, SUM(t3.reg_quantidade) AS soma, t3.reg_action FROM " . DB_PRODUTOS . " t1 INNER JOIN " . DB_PRODUTOS_CATEGORIAS . " t2 ON (t1.prod_categoria = t2.cat_id) INNER JOIN " . DB_PRODUTOS_REGISTRO . " t3 ON (t1.prod_id = t3.prod_id) WHERE "; if ($this->Action === 'u') { $fields[$i++] = "t3.reg_action = 'remove'"; } elseif ($this->Action === 'r') { $fields[$i++] = "t3.reg_action = 'add'"; } if ($this->ProdId != null) { $fields[$i++] = "t1.prod_id IN (" . implode(", ", $this->ProdId) . ")"; } if ($this->CatId != null) { $fields[$i++] = "t2.cat_id IN (" . implode(", ", $this->CatId) . ")"; } if ($this->StartDate != '') { $fields[$i] = "t3.reg_data BETWEEN '" . substr(Check::Data($this->StartDate), 0, 10) . "'"; if ($this->EndDate != '') { $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; } else { $fields[$i] .= " AND CURRENT_DATE()"; } $order[$i] = "t3.reg_data DESC"; $i++; } elseif ($this->StartDate == '' && $this->EndDate != '') { $fields[$i] = "t3.reg_data BETWEEN '2014-01-01'"; $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; $order[$i] = "t3.reg_data DESC"; $i++; } if (count($order) > 0) { $this->Sentence .= implode(' AND ', $fields) . $orderBy . implode(', ', $order); $this->SumSentence .= implode(' AND ', $fields) . $groupBy . $orderBy . implode(', ', $order); } else { $this->Sentence .= implode(' AND ', $fields); $this->SumSentence .= implode(' AND ', $fields) . $groupBy; } if ($this->StartDate == '' and $this->EndDate == '' and $this->ProdId === null and $this->Action !== 'u' and $this->Action !== 'r' and $this->CatId === null) { $this->Sentence = str_replace(" WHERE ", "", $this->Sentence); $this->SumSentence = str_replace(" WHERE ", "", $this->SumSentence); } }
$Upload = new Upload(); $Upload->File($file); $filename = DOCUMENT_ROOT . NAME . "/uploads/" . $Upload->getResult(); if (file_exists($filename)) { $FileRead = fopen($filename, "r"); $Read = new Controle('sft_particular'); $Read->truncate(); $Erros = []; while (!feof($FileRead)) { $file = fgets($FileRead); $Linha = !empty($file) ? explode(";", utf8_encode($file)) : null; if (is_array($Linha) && count($Linha) == 12) { $Erro = null; $Objeto = array(); $Objeto['part_os'] = $Linha[0]; $Objeto['part_date'] = Check::Data($Linha[1]); $Objeto['part_nm_paciente'] = $Linha[4]; $Objeto['part_vl_liquido'] = Check::toFloat($Linha[9]); $Objeto['part_vl_pago'] = Check::toFloat($Linha[10]); $Objeto['part_vl_debito'] = Check::toFloat($Linha[11]); $Linha[2] = $Linha[2] == '0' ? "418 - Sistema" : $Linha[2]; $findUser = explode(" - ", $Linha[2])[1]; $atendente = FindUser($findUser); $findCode = explode('-', $Linha[0])[0]; $unidade = FindCod($findCode); if (!$atendente) { $Erro = true; $Objeto['error'] = 'Não encontrado atendente: ' . $findUser; $Erros[] = $Objeto; } else { $Objeto['aten_id'] = $atendente;
public static function CheckImage($ImageUrl, $ImageDesc, $ImageW = null, $ImageH = null) { // Caminho da Imagem self::$Data = $ImageUrl; // Verifica se a imagem existe e retorna ela redimensionada if (file_exists(self::$Data) && !is_dir(self::$Data)) { $patch = BASE; $image = self::$Data; return "<img src=\"{$patch}/tim.php?src={$patch}/{$image}&w={$ImageW}&h={$ImageH}\" alt=\"{$ImageDesc}\" title=\"{$ImageDesc}\"/>"; } else { return false; } }
/** * Calcula a idade a partir da data de nascimento * @param STRING $data - data de nascimento * @return INT - a idade */ public function getIdade($data) { $data = substr(Check::Data($data), 0, 10); $nascimento = new DateTime($data); $idade = $nascimento->diff(new DateTime(date('Y-m-d'))); return $idade->format('%Y'); }
/** * Calcula a idade a partir da data de nascimento * @param STRING $time - data de nascimento * @return INT - a idade */ public static function getIdade($time) { if ($time == '') { return null; } $data = substr(Check::Data($time), 0, 10); $nascimento = new DateTime($data); $idade = $nascimento->diff(new DateTime(date('Y-m-d'))); return $idade->format('%Y'); }
/** * **************************************** * *************** PRIVATES *************** * **************************************** */ private function setData() { $Content = $this->Data['perfil_content']; unset($this->Data['perfil_content']); $this->Data = array_map('strip_tags', $this->Data); $this->Data = array_map('trim', $this->Data); $this->Data['perfil_name'] = Check::Name($this->Data['perfil_title']); $this->Data['perfil_date'] = Check::Data($this->Data['perfil_date']); $this->Data['perfil_content'] = $Content; }
private function setData() { $this->Data['reg_data'] = substr(Check::Data($this->Data['reg_data']), 0, 10); }
private function getStringFull() { $orderBy = ' ORDER BY t1.cardapio_dia ASC'; $fields = []; $i = 0; $this->Sentence = "SELECT t1.cardapio_dia, t2.cardapio_porcao, t3.nutri_name, t3.nutri_quantidade, t3.nutri_medida, t3.nutri_tabela, t4.cat_name FROM " . DB_NUTRICAO_CARDAPIO_DIA . " t1 INNER JOIN " . DB_NUTRICAO_CARDAPIO . " t2 ON (t1.id = t2.cardapio_id) INNER JOIN " . DB_NUTRICAO . " t3 ON (t2.nutri_id = t3.nutri_id) INNER JOIN " . DB_NUTRICAO_CATEGORIAS . " t4 ON (t3.nutri_cat = t4.cat_id) WHERE "; if ($this->NutriId != null) { $fields[$i++] = "t2.nutri_id IN (" . implode(", ", $this->NutriId) . ")"; } if ($this->StartDate != '') { $fields[$i] = "t1.cardapio_dia BETWEEN '" . substr(Check::Data($this->StartDate), 0, 10) . "'"; if ($this->EndDate != '') { $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; } else { $fields[$i] .= " AND CURRENT_DATE()"; } $i++; } elseif ($this->StartDate == '' && $this->EndDate != '') { $fields[$i] = "t1.cardapio_dia BETWEEN '2014-01-01'"; $fields[$i] .= " AND '" . substr(Check::Data($this->EndDate), 0, 10) . "'"; $i++; } $this->Sentence .= implode(' AND ', $fields) . $orderBy; if ($this->StartDate == '' and $this->EndDate == '' and $this->NutriId === null) { $this->Sentence = str_replace(" WHERE ", "", $this->Sentence); } }
private function setData() { $i = 0; foreach ($this->Data as $key => $value) { if (strpos($key, 'semana_') !== false) { $buffer[$i++] = $value; unset($this->Data[$key]); } } $this->Data['turma_semana'] = implode(", ", $buffer); $this->Data['curso_id'] = $this->CursoId; $this->Data['turma_data_inicio'] = Check::Data($this->Data['turma_data_inicio']); $this->Data['turma_data_termino'] = Check::Data($this->Data['turma_data_termino']); }
/** * **************************************** * *************** PRIVATES *************** * **************************************** */ private function setData() { $this->Data = array_map('strip_tags', $this->Data); $this->Data = array_map('trim', $this->Data); $this->Data['youtube_date'] = Check::Data($this->Data['youtube_date']); }