| Server IP : 200.152.183.196 / Your IP : 216.73.216.150 Web Server : nginx/1.20.2 System : Linux server.teclabs.com.br 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64 User : re8rc56e54 ( 10140) PHP Version : 7.3.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/cial.ind.br/httpdocs/c2r/includes/ |
Upload File : |
<?
require('../includes/global.php');
$link->exec("SET CHARACTER SET utf8");
function sessionClear(){global $id_site;$_SESSION["adm$id_site"]['id'] = 0;$_SESSION["adm$id_site"]['menu'] = 0;$_SESSION['ID'] = 0;$_SESSION["dir$id_site"] = '';$_SESSION["tit_pg$id_site"] = '';$_SESSION["adm$id_site"]['logado'] = 0;}
function validaAdm($usuario, $senha){global $id_site, $pkey;$_SESSION["adm$id_site"]['logado'] = 0;$query = query("SELECT $pkey, NOME, AREAS_PERMIT FROM usuarios_adm WHERE USUARIO='$usuario' AND SENHA='".cryptMaster($senha)."' AND VISIVEL=1");if($query->rowCount() == 1){foreach($query as $campo){$campo = (object) $campo;$_SESSION["adm$id_site"]['id'] = $campo->COD_ID;$_SESSION["adm$id_site"]['nome'] = $campo->NOME;$_SESSION["adm$id_site"]['menu'] = $campo->AREAS_PERMIT;}$_SESSION["adm$id_site"]['logado'] = 1;}return $_SESSION["adm$id_site"]['logado'];}
function redirectAdm($list='list'){global $id_code, $id_site, $tabela, $acao;$_SESSION["alert$id_site"] = '';if($acao == 'inc'){$_SESSION["alert$id_site"] = 1;}elseif($acao == 'alt'){$_SESSION["alert$id_site"] = 1;}header("Location: painel.php?$id_code=".crypt_encode("dir=$tabela&modo=$list"));}
function totalRows(){global $tabela, $pkey, $dir;if($tabela){$query = query("SHOW TABLES LIKE '$tabela'");if($query->rowCount()){$query = query("SELECT $pkey FROM $tabela");$rows = $query->rowCount();return $rows>0?'(<span id="label_tot_rows">'.$rows.'</span> registro'.($rows>1?'s':'').')':'';}}}
function clickEdit($act, $id){global $tabela, $id_code;if($act == "alt"){return 'onclick="document.location.href=\'painel.php?'.$id_code.'='.crypt_encode('dir='.$tabela.'&modo='.$act.'&ID='.$id).'\';"';}else{return "onclick=\"operaStatus('$tabela', '$id', '$act', this);\"";}}
function tableHeader($lbs, $trs){global $dir;$th = '<th class="check-col"></th>';$v = explode(',', $lbs);$t = count($v);for($x=0; $x<$t; $x++){$w = '';$tit = $v[$x];$th .= '<th><span>'.$tit.'</span></th>';}return '<table class="data-table" cellspacing="0" cellpadding="0"><thead><tr>'.$th.'</tr></thead><tbody>'.$trs.'</tbody></table>';}
function getCatName($table, $id){global $pkey;$r = '';$query = query("SELECT TITULO FROM $table WHERE $pkey='$id'");foreach($query as $campo){$campo = (object) $campo;$r = $campo->TITULO;}return $r;}
function paginacao($where=''){global $tabela, $pkey, $buscar, $dir, $acao, $n_pginacao, $pg;$query = query("SELECT $pkey FROM $tabela $where");$total_records = $query->rowCount();$pages = intval($total_records / $n_pginacao);if($total_records > $n_pginacao){$show = '<form method="post" name="paginacao" action=""><input type="hidden" name="pg" value="'.$pg.'"><input type="hidden" name="dir" value="'.$dir.'"><input type="hidden" name="acao" value="'.$acao.'"><input type="hidden" name="buscar" value="'.$buscar.'"></form><table class="data-table" cellspacing="0" cellpadding="0"><tfoot><tr><td>Páginas: ';for($i=0; $i<($pages + 1); $i++){$x = $i;$x++;if($i == $pg){$show .= $x.' - ';}else if($total_records){$show .= '<a class="text-highlight" onClick="envia_pg('.$i.');" style="cursor:pointer">'.$x.'</a> - ';}$total_records -= $n_pginacao;}$show = substr($show, 0, (strlen($show)-3));return $show.'</td></tr></tfoot></table>';}}
function separador($x){return '<label class="default-label cadastro-separador"><h4>'.$x.'</h4></label>';}
function ifr_upload($posts=''){global $tabela, $ID;return '<div class="ifr_upload"><iframe id="ifr_upload_arquivos_'.$tabela.'" name="ifr_upload_arquivos_'.$tabela.'" src="includes/upload.php?tabela=arquivos_'.$tabela.'&ID='.$ID.$posts.'" width="100%" height="100" frameborder="0"></iframe></div>';}
function frmIndex(){global $pg;return '<form name="frmmanu" action="meio.php" method="post"><fieldset><input type="hidden" name="ID" value=""><input type="hidden" name="dir" value=""><input type="hidden" name="acao" value=""><input type="hidden" name="pg" value="'.$pg.'"></fieldset></form>';}
function frmIndex2(){global $tabela, $pg, $dir, $acao, $cont, $show;return '<form name="frm" action="" method="post" enctype="multipart/form-data"><fieldset><input type="hidden" name="pg" value="'.$pg.'"><input type="hidden" name="dir" value="'.$dir.'"><input type="hidden" name="acao" value="'.$acao.'"><input type="hidden" name="cont" value="'.$cont.'">'.$show.'</fieldset></form>';}
function frmShow(){global $id_code, $tabela, $ID, $dir, $modo, $acao, $show, $USUARIO;$show = explode('<div class="ifr_upload">', $show);$ifrs = '';$t = count($show);if($t > 1){for($x=1; $x<$t; $x++){$ifrs .= '<div class="ifr_upload">'.$show[$x];}}return ($show[0]?'<div class="fit-form"><form class="default-form" name="frm" action="painel.php" method="post" onsubmit="return postForm2(\''.$tabela.'\');"><fieldset><input type="hidden" name="ID" value="'.$ID.'"><input type="hidden" name="dir" value="'.$dir.'"><input type="hidden" name="modo" value="'.$modo.'"><input type="hidden" name="acao" value="'.$acao.'"><input type="hidden" name="tabela" value="'.$tabela.'"><input type="hidden" id="DESCRICAO" name="DESCRICAO">'.$show[0].'</fieldset></form></div><div class="fit-form-submit"><input class="default-submit vibrant-dark-hover" type="button" name="name" value="SALVAR" onclick="document.frm.submit();"><input class="default-cancel vibrant-dark-hover" type="button" name="name" value="CANCELAR" onclick="document.location.href=\'painel.php?'.$id_code.'='.crypt_encode('dir='.$tabela.'&modo='.($modo=='alt'?'list':'list_del')).'\';"></div>':'').''.$ifrs;}
function line_text($l, $n='', $v='', $m=80, $a='', $tp=0, $type='text'){return '<label class="default-label'.($tp==1?'-inline default-label-inline-left':($tp==2?'-inline default-label-inline-right':'')).'"><span class="default-legend'.($tp==1?' default-legend-inline-left':($tp==2?' default-legend-inline-right':'')).'">'.$l.':</span><input class="default-text'.($tp==1?' default-text-inline-left':($tp==2?' default-text-inline-right':'')).'" type="'.$type.'" name="'.$n.'" id="'.$n.'" value="'.$v.'" maxlength="'.$m.'"'.$a.'></label>';}
function line_select($l, $n='', $v='', $a='', $tp=0){return '<label class="default-label'.($tp==1?'-inline default-label-inline-left':($tp==2?'-inline default-label-inline-right':'')).'"><span class="default-legend'.($tp==1?' default-legend-inline-left':($tp==2?' default-legend-inline-right':'')).'">'.$l.':</span><select class="default-select"'.($tp>0?' style="width:183px;"':'').' name="'.$n.'" id="'.$n.'"'.$a.'><option value="" selected="selected">Selecione</option>'.$v.'</select></select></label>';}
function line_select2($l, $n='', $t='', $i=''){$v = '';$query = query("SELECT COD_ID, TITULO FROM $t ORDER BY TITULO");foreach($query as $campo){$campo = (object) $campo;$v .= '<option value="'.$campo->COD_ID.'"'.($campo->COD_ID == $i?' selected="selected"':'').'>'.$campo->TITULO.'</option>';}return '<label class="default-label"><span class="default-legend">'.$l.':</span><select class="default-select" name="'.$n.'" id="'.$n.'"><option value="" selected="selected">Selecione</option>'.$v.'</select></select></label>';}
function line_check($l, $n='', $v='', $w='250px', $s=''){return '<label class="check-label" style="width:'.$w.';margin-right:10px;'.$s.'"><span class="check-btn" style="padding:7px 10px 0 5px !important;"><input type="checkbox" name="'.$n.'" value="1"'.($v==1?' checked="checked"':'').'></span><span class="check-legend">'.$l.'</span></label>';}
function line_radio($l, $n='', $v='', $w='250px', $s=''){return '<label class="check-label" style="width:'.$w.';margin-right:10px;'.$s.'"><span class="check-btn" style="padding:7px 10px 0 5px !important;"><input type="radio" name="'.$n.'" value="1"'.($v==1?' checked="checked"':'').'></span><span class="check-legend">'.$l.'</span></label>';}
function frm_field($name='', $vl='', $mx='', $st="width:450px;", $add='', $tp="text", $cl='', $id=''){return '<input type="'.$tp.'" name="'.$name.'" id="'.($id?$id:$name).'" value="'.$vl.'"'.($cl?' class="'.$cl.'"':'').($st?' style="'.$st.'"':'').($mx?' maxlength="'.$mx.'"':'').$add.'>';}
function frm_bt($tp=1, $vl='', $cl="wymupdate", $oc=''){return '<input type="'.($tp==1?'submit':'button').'" name="frm_bt" id="frm_bt" value="'.$vl.'" class="'.$cl.'" '.($oc?'onclick="'.$oc.'"':'').'>';}
function frm_text($label, $name, $max=100, $add='', $pos=0){global $frm_vlr;return '<label class="default-label'.($pos==1?'-inline default-label-inline-left':($pos==2?'-inline default-label-inline-right':'')).'"><span class="default-legend'.($pos==1?' default-legend-inline-left':($pos==2?' default-legend-inline-right':'')).'">'.$label.':</span><input class="default-text'.($pos==1?' default-text-inline-left':($pos==2?' default-text-inline-right':'')).'" type="text" name="'.$name.'" id="'.$name.'" value="'.($frm_vlr[$name]??'').'" maxlength="'.$max.'"'.$add.'></label>';}
function frm_select($label, $name='', $tabela=''){global $frm_vlr;$v = '';$query = query("SELECT COD_ID, TITULO FROM $tabela ORDER BY TITULO");foreach($query as $campo){$campo = (object) $campo;$v .= '<option value="'.$campo->COD_ID.'"'.($campo->COD_ID == ($frm_vlr[$name]??'')?' selected="selected"':'').'>'.$campo->TITULO.'</option>';}return '<label class="default-label"><span class="default-legend">'.$label.':</span><select class="default-select" name="'.$name.'" id="'.$name.'"><option value="" selected="selected">Selecione</option>'.$v.'</select></select></label>';}
function frm_checkbox($name='', $vl='', $add=''){global $id;return '<input class="check" type="checkbox" name="'.$name.'" id="'.$name.'" value="'.$vl.'" '.$add.($id>0?'onclick="tr_marked(this, '.$id.');"':'').'>';}
function frm_textarea($label, $name, $rows=5){global $frm_vlr;return '<label class="default-label"><span class="default-legend">'.$label.':</span><textarea class="default-text" name="'.$name.'" id="'.$name.'" rows="'.$rows.'" cols="40">'.($frm_vlr[$name]??'').'</textarea></label>';}
function frm_telefone($label, $i='', $tp=''){global $frm_vlr;return '<label class="default-label'.($tp==1?'-inline default-label-inline-left':($tp==2?'-inline default-label-inline-right':'')).'"><span class="default-legend'.($tp==1?' default-legend-inline-left':($tp==2?' default-legend-inline-right':'')).'">'.$label.':</span><input class="default-text" type="text" name="DDD'.$i.'" id="DDD'.$i.'" value="'.($frm_vlr['DDD'.$i]??'').'" maxlength="2" onkeypress="somenteNumeros(this);" style="width:20px;"><input class="default-text" type="text" name="TEL'.$i.'" id="TEL'.$i.'" value="'.($frm_vlr['TEL'.$i]??'').'" maxlength="10" onkeypress="mascaraTel(this,event);somenteNumeros(this);" style="width:140px;margin-left:5px;"></label>';}
function frm_editor($name){global $frm_vlr;return '<br style="clear:both;float:left;"><div id="rte-container" class="rte-container">'.($frm_vlr[$name]??'').'</div><script>RTE.init({container:"rte-container",content:"'.$name.'"});</script><br style="clear:both;float:left;">';}
function table_list_process($labels, $colunas, $funcoes='', $order='TITULO'){
global $link, $tabela, $pkey, $ID, $id_code, $acao, $trs, $buscar;
$w = '';
if($buscar){
$tmp = '';
$v_colunas = explode(',', $colunas);
$t = count($v_colunas);
for($x=0; $x<$t; $x++)
$tmp .= "OR ".$v_colunas[$x]." LIKE '%$buscar%' ";
$w = "WHERE ".substr($tmp, 3, strlen($tmp));
}
$r = '';
$skip = 0;
$query = query("SELECT $pkey, $colunas, VISIVEL, DATA FROM $tabela $w ORDER BY $order");
$rows = $query->rowCount();
if($rows > 0){
foreach($query as $campo){
$id = $campo['COD_ID'];
$click = clickEdit('alt', $id);
$trs .= '<tr id="tr_'.$id.'"'.($campo['VISIVEL']==0?' class="disabled"':'').'><td class="check-col">'.frm_checkbox("checkb_vet[]", $id).'</td>';
$c = 0;
$v_funcoes = explode(',', $funcoes);
$v_colunas = explode(',', $colunas);
$t = count($v_colunas);
for($x=0; $x<$t; $x++){
$valor = $campo[$v_colunas[$x]];
$is_cat = 0;
if(strpos($v_colunas[$x].'X', '_IDX'))
$is_cat = 1;
if(strpos('X'.$v_colunas[$x], 'DDD')){
$valor = '('.$valor.') '.$campo[$v_colunas[$x+1]];
$skip = 1;
}
$trs .= '<td '.$click.' class="cursor-pointer"><span class="text-highlight">'.($is_cat?getCatName($v_funcoes[$c], $valor):$valor).'</span></td>';
if($is_cat == 1)
$c++;
if($skip == 1){
$skip = 0;
break;
}
}
$trs .= '<td '.$click.' class="cursor-pointer"><span class="text-highlight">'.mes_extenso($campo['DATA']).'</span></td></tr>';
}
$r = tableHeader($labels.',Data da atualização', $trs);
}
return $r;
}
function mysql_cols_process(){
global $link, $tabela, $pkey, $ID, $acao;
$sql_str = '';
$frm_vlr = array();
$c = 0;
$vet_fields_tb = array();
$query = query("SHOW COLUMNS FROM $tabela");
foreach($query as $campo){
if($campo['Field'] != $pkey && $campo['Field'] != 'VISIVEL' && $campo['Field'] != 'DATA'){
$sql_str .= $campo['Field']."='".request($campo['Field'])."', ";
$vet_fields_tb[$c]['Field'] = $campo['Field'];
$vet_fields_tb[$c]['Type'] = $campo['Type'];
$c++;
}
}
if($acao == 'alt')
if(query("UPDATE $tabela SET ".$sql_str."DATA=now() WHERE $pkey='$ID'"))
redirectAdm();
$query = query("SELECT * FROM $tabela WHERE $pkey='$ID'");
foreach($query as $campo){
$t = count($vet_fields_tb);
for($x=0; $x<$t; $x++)
$frm_vlr[$vet_fields_tb[$x]['Field']] = $campo[$vet_fields_tb[$x]['Field']];
}
if($ID == 'null' && $_SESSION['ID_create'] == 0){
query("INSERT INTO $tabela(DATA) VALUES(now())");
$ID = $link->lastInsertId();
$_SESSION['ID_create'] = $ID;
$_SESSION['TB_create'] = $tabela;
}
$acao = 'alt';
return $frm_vlr;
}
?>