$qry_config = "SELECT * FROM config ";
$exec_config = mysql_query($qry_config) or die (TRANS('ERR_QUERY'));
$row_config = mysql_fetch_array($exec_config);
$qry = $QRY["useropencall_custom"];
$qry.= " AND c.conf_cod = '".$_SESSION['s_screen']."'";
$execqry = mysql_query($qry);
$rowconf = mysql_fetch_array($execqry);
$query = "select o.*, u.* from ocorrencias o, usuarios u where o.operador=u.user_id and numero=".$cod."";
$resultado = mysql_query($query);
$row = mysql_fetch_array($resultado);
$linhas = mysql_numrows($resultado);
$qryTela = "select * from imagens where img_oco = ".$row['numero']."";
$execTela = mysql_query($qryTela) or die (TRANS('MSG_ERR_NOT_INFO_IMAGE'));
$isTela = mysql_num_rows($execTela);
$cont = 0;
while ($rowTela = mysql_fetch_array($execTela)) {
$cont++;
print "<tr>";
$size = round($rowTela['img_size']/1024,1);
print "<TD bgcolor='".TD_COLOR."' >Anexo ".$cont." [".$rowTela['img_tipo']."]<br>(".$size."k):</td>";
if(eregi("^image\/(pjpeg|jpeg|png|gif|bmp)$", $rowTela["img_tipo"])) {
$viewImage = " <a onClick=\"javascript:popupWH('../../includes/functions/showImg.php?".
"file=".$row['numero']."&cod=".$rowTela['img_cod']."',".$rowTela['img_largura'].",".$rowTela['img_altura'].")\" ".
"title='View the file'><img src='../../includes/icons/kghostview.png' width='16px' height='16px' border='0'></a>";
} else {
$viewImage = "";
}
print "<td colspan='5' ><a onClick=\"redirect('../../includes/functions/download.php?".
"file=".$row['numero']."&cod=".$rowTela['img_cod']."')\" title='Download the file'>".
"<img src='../../includes/icons/attach2.png' width='16px' height='16px' border='0'>".
"".$rowTela['img_nome']."</a>".$viewImage."".
height='16' width='16' src='".ICONS_PATH."drop.png' title='".TRANS('HNT_DEL')."'>".
"</TD>";
print "</tr>";
}
/* ----------------- INICIO ALTERACAO ----------------- */
print "<tr>";
print "<td colspan='4'>";
if ((!empty($rowconf) && $rowconf['conf_scr_upload']) || empty($rowconf)) {
for($i=1;$i<=$row_config['conf_qtd_max_anexos']; $i++){
$estilo = 'width: 100%; margin: 0; height: 20px; margin-bottom: 2px;';
if($i > 1)
$estilo .= " display: none;";
print "<div id='tr_anexo_$i' style='{ $estilo }'>";
//print "<tr id='tr_anexo_$i' $estilo>";
print "<div style='{width: 20%; height: 100%; background-color: ".TD_COLOR."; float: left; margin: 0;}'>".TRANS('OCO_FIELD_ATTACH_FILE','Anexar arquivo').":</div>";
print "<div style='{width: 70%; background-color: ".BODY_COLOR."; float: left; margin-left: 2px;}'>";
print " <INPUT type='file' class='text' name='anexo_$i' id='id_anexo_$i' />";
if($i != $row_config['conf_qtd_max_anexos']){
print " ";
print "<a id='link_adic_$i'
onclick=\"
javascript:document.getElementById('tr_anexo_".($i+1)."').style.display='block';
document.getElementById('link_adic_".($i)."').style.display='none';
\"> ".TRANS('ATTACH_ANOTHER')."</a>";
}
print "</div>";
print "</div>";
}
}
print "</td>";
print "</tr>";
/* ----------------- FIM ALTERACAO ----------------- */
/* ----------------- INICIO ALTERACAO ----------------- */
$gravaImg = false;
$qryConf = "SELECT * FROM config";
$execConf = mysql_query($qryConf) or die (TRANS('ERR_QUERY').", A TABELA CONF FOI CRIADA?");
$rowConf = mysql_fetch_array($execConf);
$arrayConf = array();
$arrayConf = montaArray($execConf,$rowConf);
for($i=1;$i<=$row_config['conf_qtd_max_anexos']; $i++){
$nomeAnexo = 'anexo_'.$i;
if (isset($_FILES[$nomeAnexo]) and $_FILES[$nomeAnexo]['name']!="") {
$upld = upload($nomeAnexo,$arrayConf,$rowConf['conf_upld_file_types']);
if ($upld =="OK") {
$gravaImg[$i] = true;
} else {
$gravaImg[$i] = false;
$upld.="<br><a align='center' onClick=\"exibeEscondeImg('idAlerta');\"><img src='".ICONS_PATH."/stop.png' width='16px' height='16px'> ".TRANS('LINK_CLOSE','Fechar')."</a>";
print "</table>";
print "<div class='alerta' id='idAlerta'><table bgcolor='#999999'><tr><td colspan='2' bgcolor='yellow'>".$upld."</td></tr></table></div>";
exit;
}
}
}
/* ----------------- FIM ALTERACAO ----------------- */
/* ----------------- INICIO ALTERACAO ----------------- */
for($i=1;$i<=$row_config['conf_qtd_max_anexos']; $i++){
if ($gravaImg[$i]) {
$nomeAnexo = 'anexo_'.$i;
//INSERSAO DO ARQUIVO NO BANCO
$fileinput=$_FILES[$nomeAnexo]['tmp_name'];
$tamanho = getimagesize($fileinput);
$tamanho2 = filesize($fileinput);
if(chop($fileinput)!=""){
// $fileinput should point to a temp file on the server
// which contains the uploaded image. so we will prepare
// the file for upload with addslashes and form an sql
// statement to do the load into the database.
$image = addslashes(fread(fopen($fileinput,"r"), 1000000));
$SQL = "Insert Into imagens (img_nome, img_oco, img_tipo, img_bin, img_largura, img_altura, img_size) values ".
"('".noSpace($_FILES[$nomeAnexo]['name'])."',".$numero.", '".$_FILES[$nomeAnexo]['type']."', ".
"'".$image."', '".$tamanho[0]."', '".$tamanho[1]."', '".$tamanho2."')";
// now we can delete the temp file
unlink($fileinput);
} /*else {
echo "".TRANS('MSG_NOT_IMAGE_SELECT')."";
exit;
}*/
$exec = mysql_query($SQL); //or die ("N?O FOI POSS?VEL GRAVAR O ARQUIVO NO BANCO DE DADOS! ");
if ($exec == 0)
$aviso.= TRANS('MSG_ATTACH_IMAGE')."<br>";
}
}
/* ----------------- FIM ALTERACAO ----------------- */
Início