$j++;
if ($row['sis_status'] == 0) {
$lstatus = TRANS('INACTIVE', 'INATIVO');
} else {
$lstatus = TRANS('ACTIVE', 'ATIVO');
}
if ($row['conf_name'] == "") {
$textScreen = TRANS('SCREEN_FULL');
} else {
$textScreen = $row['conf_name'];
}
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['sistema'] . "</td>";
print "<td class='line'>" . transbool($row['sis_atende']) . "</td>";
print "<td class='line'>" . $row['sis_email'] . "</td>";
print "<td class='line'>" . NVL($textScreen) . "</td>";
print "<td class='line'>" . $lstatus . "</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['sis_id'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('COL_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('ENSURE_DEL') . "?','" . $_SERVER['PHP_SELF'] . "','action=excluir&cod=" . $row['sis_id'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('COL_DEL') . "'></a></TD>";
print "</TR>";
}
//print "</TABLE>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
print "<BR><B>" . TRANS('CADASTRE_AREA') . "</B> <font color='red'>" . TRANS('ALERT_AREA_PERMISSION') . "</font><BR>";
print "<TR>";
print "<TD width='20%' align='left' bgcolor=" . TD_COLOR . ">" . TRANS('COL_AREA') . ":</TD>";
print "<TD width='80%' align='left' bgcolor=" . BODY_COLOR . "><INPUT type='text' name='area' class='text' id='idArea'>" . "<input type='checkbox' name='areaatende' value='1' checked>" . TRANS('COL_ATEND') . "</TD>";
print "</TR>";
print "<tr>";
$i = 0;
$j = 2;
while ($rowlist = mysql_fetch_array($exec)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $rowlist['area'] . "</td>";
print "<td class='line'><a onClick=\"javascript: popup_alerta('mostra_consulta.php?numero=" . $rowlist['numero'] . "')\">" . NVL($rowlist['numero']) . "</a></td>";
print "<td class='line'>" . NVL($rowlist['prob_desc']) . "</td>";
print "<td class='line'>" . NVL($rowlist['localizacao']) . "</td>";
print "<td class='line'>" . NVL($rowlist['nome']) . "</td>";
print "<td class='line'>" . NVL(formatDate($rowlist['data_fechamento'])) . "</td>";
print "</TR>";
}
print "</table>";
}
}
}
?>
<script type='text/javascript'>
function popup(pagina) { //Exibe uma janela popUP
x = window.open(pagina,'popup','width=400,height=200,scrollbars=yes,statusbar=no,resizable=yes');
x.moveTo(window.parent.screenX+100, window.parent.screenY+100);
return false
}
print "</tr>";
$j = 2;
while ($rowMail = mysql_fetch_array($execMail)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
$limite = 30;
$shortBody = trim($rowMail['mhist_body']);
if (strlen($shortBody) > $limite) {
$shortBody = substr($shortBody, 0, $limite - 4) . "...";
}
print "<tr class=" . $trClass . " id='imglinhax" . $j . "' onMouseOver=\"destaca('imglinhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('imglinhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('imglinhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\" onClick=\"invertView('linhax" . $j . "');\" STYLE=\"{cursor: pointer;}\">";
print "<td class='line'>" . $rowMail['mhist_subject'] . "</td><td class='line'>" . NVL($rowMail['mhist_listname']) . "</td>" . "<td class='line'>" . $shortBody . "</td>" . "<td class='line'>" . formatDate($rowMail['mhist_date']) . "</td><td class='line'>" . $rowMail['nome'] . "</td>";
print "</tr>";
print "<tr><td colspan='6' ><div id='linhax" . $j . "' style='{display:none}'>";
//style='{display:none}'
print "<TABLE border='0' cellpadding='2' cellspacing='0' width='90%'>";
print "<tr><td class='line'><b>" . TRANS('MAIL_FIELD_TO') . ":</b> " . toHtml($rowMail['mhist_address']) . "</td></tr>";
print "<tr><td class='line'><b>" . TRANS('MAIL_FIELD_CC') . ":</b> " . toHtml($rowMail['mhist_address_cc']) . "</td></tr>";
print "<tr><td class='textarea'>" . nl2br(toHtml($rowMail['mhist_body'])) . "</td></tr>";
//print "<tr><td>".$rowMail['mhist_body']."</td></tr>";
NL();
print "</table></div></td></tr>";
}
print "</table>";
print "</table></div></td></tr>";
}
//FIM DO TRECHO SOBRE OS E-MAIL ENVIADOS
// while ($row = mysql_fetch_array($resultado2)) {
//if ($i==0) {
//$atualmente = "<font ".$alerta.">[".TRANS('TXT_CURRENT_PLACE')."]</font>"; //Perfumaria: Serve para identificar para o usuário o local atual onde o equipamento está!!!
//} else
//$atualmente = '';
// print "<tr class=".$trClass." id='linhax".$j."' onMouseOver=\"destaca('linhax".$j."','".$_SESSION['s_colorDestaca']."');\" onMouseOut=\"libera('linhax".$j."','".$_SESSION['s_colorLinPar']."','".$_SESSION['s_colorLinImpar']."');\" onMouseDown=\"marca('linhax".$j."','".$_SESSION['s_colorMarca']."');\">";
// print "<td class='line'><a ".$alerta." onClick= \"javascript: window.opener.location.href='mostra_consulta_comp.php?comp_local=".$row['local_cod']."&comp_tipo_equip=".$row['tipo']."&ordena=fab_nome,modelo,local,etiqueta'\">".$row['locais']." </a><b><font color='green'>".$atualmente."</font></b></td>";
// print "<td class='line'><font ".$alerta.">".$row['DIA']."/".$row['MES']."/".$row['ANO']."</font></td>";
// print "</TR>";
//}
$j = 2;
while ($row = mysql_fetch_array($resultado2)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['local'] . "</td>";
print "<td class='line'>" . NVL($row['inst_nome'] . " " . $row['hp_comp_inv']) . "</td>";
print "<td class='line'>" . NVL(formatDate($row['hp_date'])) . "</td>";
print "<td class='line'>" . NVL($row['nome']) . "</td>";
print "<td class='line'>" . NVL($row['tecnico']) . "</td>";
print "</TR>";
}
print "<tr><td colspan='4'> </td></tr>";
print "<tr><td colspan='4' align='center'><input type='button' class='minibutton' value='" . $BT_TEXT . "' onClick=\"" . $GETOUT . "\"</td></tr>";
print "</TABLE>";
print "</BODY>";
print "</HTML>";
$linhas = mysql_numrows($resultado);
print "<TABLE border='0' cellpadding='1' cellspacing='0' width='100%'>";
print "<tr class='header'>";
print "<td class='line'>" . TRANS('ML_SIGLA') . "</td><td class='line'>" . TRANS('ML_DESC') . "</td>" . "<td class='line'>" . TRANS('ML_ADDRESS_TO') . "</td>" . "<td class='line'>" . TRANS('ML_ADDRESS_CC') . "</td>" . "</td><td class='line'>" . TRANS('ACT_EDIT') . "</td>";
print "<td class='line'>" . TRANS('COL_DEL', '') . "</TD>";
print "</tr>";
$j = 2;
while ($row = mysql_fetch_array($resultado)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['ml_sigla'] . "</td><td class='line'>" . $row['ml_desc'] . "</td>" . "<td class='line'>" . $row['ml_addr_to'] . "</td>" . "<td class='line'>" . NVL($row['ml_addr_cc']) . "</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['ml_cod'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('ENSURE_DEL') . "?','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['ml_cod'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</tr>";
}
print "</table>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "alter" && empty($_POST['submit'])) {
$row = mysql_fetch_array($resultado);
print "<script type='text/javascript' src='../../includes/fckeditor/fckeditor.js'></script>";
print "<tr><td colspan='2'> </td></tr>";
print "<tr><td>" . TRANS('ML_SIGLA') . "</td><td><input type='text' class='text' name='ml_sigla' id='idSigla' value='" . $row['ml_sigla'] . "'></td></tr>";
print "<tr><td>" . TRANS('ML_DESC') . "</td><td><textarea class='textarea2' name='ml_desc' id='idMlDesc'>" . $row['ml_desc'] . "</textarea></td></tr>";
print "<tr><td>" . TRANS('ML_ADDRESS_TO') . "</td><td><textarea name='ml_address' class='textarea2' id='idMlList'>" . $row['ml_addr_to'] . "</textarea></td></tr>";
print "<tr><td>" . TRANS('ML_ADDRESS_CC') . "</td><td><textarea name='ml_address_cc' class='textarea2' id='idMlListCc'>" . $row['ml_addr_cc'] . "</textarea></td></tr>";
$query_vencimento = "SELECT count(*)AS quantidade, " . "date_add(date_format(comp_data_compra,'%Y-%m-%d'), INTERVAL tempo_meses\tMONTH ) AS vencimento, " . "marc_nome as modelo, fab_nome as fabricante, tipo_nome as tipo " . "FROM equipamentos, tempo_garantia, marcas_comp, fabricantes, tipo_equip " . "WHERE date_add( comp_data_compra, INTERVAL tempo_meses MONTH ) >= curdate( ) " . "AND comp_garant_meses = tempo_cod AND comp_tipo_equip not IN (5) AND comp_marca = marc_cod and " . "comp_fab = fab_cod and comp_tipo_equip = tipo_cod and " . "(date_format( curdate( ) , '%Y' ) = date_format( date_add( comp_data_compra, INTERVAL tempo_meses MONTH ) , '%Y' ) " . "OR date_format( curdate( ) , '%Y' )+" . $PERIODO . " >= date_format( date_add( comp_data_compra, INTERVAL tempo_meses MONTH ) , '%Y')) " . "GROUP BY vencimento,modelo " . "ORDER BY vencimento,modelo";
$exec_vencimento = mysql_query($query_vencimento);
//----------------TABELA 14 -----------------//
print "<p>PRÓXIMOS VENCIMENTOS DE GARANTIA(" . $ANO_ATUAL . " a " . $ANO_PROX . ")</p>";
print "<blockquote>";
print "<table cellspacing='0' border='1'>";
print "<tr><td class='line'><b>DATA</b></td><td class='line'><b>QUANTIDADE</b></td><td class='line'><b>TIPO</b></td><td class='line'><b>MODELO</b></td></tr>";
$tt_garant = 0;
while ($row = mysql_fetch_array($exec_vencimento)) {
$temp = explode(" ", datab($row['vencimento']));
$vencimento = $temp[0];
$tt_garant += $row['quantidade'];
print "<tr><td class='line'>" . NVL($vencimento) . "</td><td align='center'>" . NVL($row['quantidade']) . "</td><td class='line'>" . NVL($row['tipo']) . "</td><td class='line'>" . NVL($row['fabricante']) . " " . NVL($row['modelo']) . "</td></tr>";
}
// while
print "<tr><td class='line'><b>TOTAL</b></td><td colspan='3'><b>" . NVL($tt_garant) . "</b></td></tr>";
print "</table><br><br>";
print "</blockquote>";
//-----------------FINAL DA TABELA 14 -----------------------//
$query_sw_sla = "select o.numero, o.data_abertura, o.data_atendimento, o.data_fechamento, " . "o.sistema as cod_area, s.sistema " . "from ocorrencias as o, sistemas as s " . "where o.status in (4) and s.sis_id=o.sistema and o.sistema in (" . $SW . ") and " . "o.data_fechamento >= '" . $d_ini_completa . "' and o.data_fechamento <= '" . $d_fim_completa . "' and " . "o.data_atendimento is not null order by o.data_abertura";
$exec_sw_sla = mysql_query($query_sw_sla);
$linhas = mysql_num_rows($exec_sw_sla);
$dtS = new dateOpers();
//solução
$dtR = new dateOpers();
//resposta
$sla3 = 6;
//INICIO DO VERMELHO - Tempo de SOLUÇÃO
$sla2 = 4;
//INÍCIO DO AMARELO
$slaR3 = 3600;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=details&cod=" . $row['scpt_id'] . "&cellStyle=true')\">" . NVL($row['scpt_nome']) . "</a></td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=details&cod=" . $row['scpt_id'] . "&cellStyle=true')\">" . NVL($row['scpt_desc']) . "</a></td>";
print "<td class='line'>" . transbool($row['scpt_enduser']) . "</td>";
$texto = trim($row['scpt_script']);
if (strlen($texto) > 50) {
$texto = substr($texto, 0, 45) . " ..... ";
}
$qryProb = "SELECT * FROM prob_x_script " . "LEFT JOIN problemas on prob_id = prscpt_prob_id " . "WHERE prscpt_scpt_id = " . $row['scpt_id'] . " " . "AND prscpt_prob_id = prob_id " . "GROUP BY problema " . "ORDER BY problema ";
$execProb = mysql_query($qryProb);
$allProbs = "";
while ($rowProb = mysql_fetch_array($execProb)) {
!empty($allProbs) ? $allProbs .= ",<br>" : ($allProbs .= "");
$allProbs .= $rowProb['problema'];
}
print "<td class='line'>" . NVL($allProbs) . "</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['scpt_id'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('ENSURE_DEL') . "?','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['scpt_id'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</TR>";
}
print "<tr><td colspan='6'>";
$PAGE->showOutputPages();
print "</td></tr>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "details" && empty($_POST['submit'])) {
$row = mysql_fetch_array($resultado);
print "<BR><B>" . TRANS('TTL_RECORD_INFO') . ":</B><BR>";
print "<TR>";
print "<TD bgcolor='" . TD_COLOR . "'>" . TRANS('COL_SCRIPT_NAME') . ":</TD>";
if ($row['scpt_enduser']) {
print "<TR>";
print "<TD align='left' width='20%' bgcolor='" . BODY_COLOR . "'><input type='submit' class='button' value='" . TRANS('BT_ALTER') . "' name='submit'>";
if (isset($_GET['popup'])) {
print "<input type='hidden' name='popup' value='" . $_GET['popup'] . "'>";
}
print "<input type='hidden' name='cod' value='" . $_GET['cod'] . "'>";
print "</TD>";
print "<TD align='left' bgcolor='" . BODY_COLOR . "'><INPUT type='reset' class='button' value='" . TRANS('BT_CANCEL') . "' name='cancelar' onClick=\"" . $fecha . "\"></TD>";
print "</TR>";
} else {
if (isset($_GET['action']) && $_GET['action'] == "details" && empty($_POST['submit'])) {
$row = mysql_fetch_array($resultado);
//dump($row,'ROW - DETAILS');
print "<BR><B>" . TRANS('SUBTTL_DETAIL_ITEM_SUPPLY') . ":</B><BR>";
NL(2);
print "<tr><td><b><a href='" . $_SERVER['PHP_SELF'] . "'>" . TRANS('SUBTTL_SHOW_ALL') . "</b></a></td>" . "<td>" . "<table><tr>" . "<td><B><a onClick= \"javascript: popup_alerta('piece_hist.php?popup=true&piece_id=" . $row['estoq_cod'] . "')\" title='" . TRANS('HNT_HISTORY_LOCAL_EQUIP') . "'>" . TRANS('MNL_CON_HIST') . "</a></B></TD>" . "<td>" . NVL('') . "</td>" . "<td><B><a onClick= \"javascript: popup_alerta('consulta_garantia_piece.php?popup=true&piece_id=" . $row['estoq_cod'] . "')\" title='" . TRANS('HNT_HISTORY_LOCAL_EQUIP') . "'>" . TRANS('LINK_GUARANT') . "</a></B></TD>" . "<td>" . NVL('') . "</td><td>" . "<b><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['estoq_cod'] . "&cellStyle=true')\">" . "" . TRANS('COL_EDIT') . "</b></a></td>" . "</tr></table>" . "</td></tr>";
NL(2);
print "<TR>";
print "<TD class='default' width='20%' align='left' bgcolor='" . TD_COLOR . "' valign='top'>" . TRANS('COL_TYPE') . ":</TD>";
print "<TD align='left' bgcolor='" . BODY_COLOR . "'>" . $row['item_nome'] . "</td>";
print "</tr>";
print "<TR>";
print "<TD class='default' width='20%' align='left' bgcolor='" . TD_COLOR . "' valign='top'>" . TRANS('COL_DESC') . ":</TD>";
print "<TD align='left' bgcolor='" . BODY_COLOR . "'>" . $row['fabricante'] . " " . $row['modelo'] . " " . $row['capacidade'] . " " . $row['sufixo'] . "</td>";
print "</tr>";
print "<TR>";
print "<TD class='default' width='20%' align='left' bgcolor='" . TD_COLOR . "' valign='top'>" . TRANS('COL_SN') . ":</TD>";
print "<TD align='left' bgcolor='" . BODY_COLOR . "'>" . $row['estoq_sn'] . "</td>";
print "</tr>";
print "<TR>";
print "<TD class='default' width='20%' align='left' bgcolor='" . TD_COLOR . "' valign='top'>" . TRANS('COL_LOCALIZATION') . ":</TD>";
$execStatus = mysql_query($sqlStatus) or die(TRANS('MSG_ERR_RESCUE_INFO_STATUS_CALL_SON') . '<br>' . $sqlStatus);
$regStatus = mysql_num_rows($execStatus);
if ($regStatus > 0) {
$comDeps = true;
}
}
if ($comDeps) {
$imgSub = "<img src='" . ICONS_PATH . "view_tree_red.png' width='16' height='16' title='" . TRANS('FIELD_CALL_BOND_HANG') . "'>";
} else {
$imgSub = "<img src='" . ICONS_PATH . "view_tree_green.png' width='16' height='16' title='" . TRANS('FIELD_CALL_BOND_NOT_HANG') . "'>";
}
} else {
$imgSub = "";
}
print "<TD class='line' " . $valign . "><a href='mostra_consulta.php?numero=" . $rowAT['numero'] . "'>" . $rowAT['numero'] . "</a>" . $imgSub . "</TD>";
print "<TD class='line' " . $valign . ">" . NVL($rowAT['problema']) . "</TD>";
print "<TD class='line' " . $valign . "><b>" . $rowAT['contato'] . "</b><br>" . $rowAT['telefone'] . "</TD>";
print "<TD class='line' " . $valign . "><b>" . $rowAT['setor'] . "</b><br>";
$texto = trim($rowAT['descricao']);
if (strlen($texto) > 200) {
$texto = substr($texto, 0, 195) . " ..... ";
}
print $texto;
print "</TD>";
print "<TD class='line' " . $valign . ">" . $rowAT['area'] . "</TD>";
print "<TD class='line' " . $valign . ">" . $rowAT['chamado_status'] . "</TD>";
// if (array_key_exists($rowAT['cod_area'],$H_horarios)){ //verifica se o código da área possui carga horária definida no arquivo config.inc.php
//$areaChamado = $rowAT['cod_area']; //Recebe o valor da área de atendimento do chamado
// } else $areaChamado = 1; //Carga horária default definida no arquivo config.inc.php
$areaChamado = "";
$areaChamado = testaArea($areaChamado, $rowAT['area_cod'], $H_horarios);
while ($row = mysql_fetch_array($PAGE->RESULT_SQL)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['mat_nome'] . "</td>";
$sqlModelo = "SELECT * FROM marcas_comp WHERE marc_cod = " . $row['mat_modelo_equip'] . "";
$execSql = mysql_query($sqlModelo) or die(TRANS('MSG_NOT_ACCESS_MODEL_DATA'));
$rowModelo = mysql_fetch_array($execSql);
print "<td class='line'>" . NVL($rowModelo['marc_nome']) . "</td>";
print "<td class='line'>" . NVL($row['mat_qtd']) . "</td>";
print "<td class='line'>" . NVL($row['mat_caixa']) . "</td>";
print "<td class='line'>" . NVL($row['mat_obs']) . "</td>";
//print "<td class='line'>".NVL($row['mat_cod'])."</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['mat_cod'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('MSG_DEL_REG') . "','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['mat_cod'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</TR>";
}
print "<tr><td colspan='6'>";
$PAGE->showOutputPages();
print "</td></tr>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
print "<BR><B>" . TRANS('SUBTTL_DOC_CAD') . "</B><BR>";
print "<TR>";
print "<TD width='20%' align='left' bgcolor='" . TD_COLOR . "'>" . TRANS('MNL_VIS_DOC') . ":</TD>";
print "<TD width='80%' align='left' bgcolor='" . BODY_COLOR . "'><INPUT type='text' name='documento' class='text' id='idDocumento'></td>";
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
?>
<script type='text/javascript'>
function popup_alerta(pagina) { //Exibe uma janela popUP
x = window.open(pagina,'_blank','width=700,height=470,scrollbars=yes,statusbar=no,resizable=yes');
x.moveTo(window.parent.screenX+50, window.parent.screenY+50);
return false
}
</script>
<?php
print "<HTML><head><title>SLA Definido</title>";
include 'includes/header.php';
print "</head>";
print "<BODY bgcolor='" . BODY_COLOR . "'>";
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 4);
$sql = "SELECT o.numero AS numero, p.problema AS problema, l.local AS LOCAL , " . "resp.slas_desc AS resposta, sol.slas_desc AS solucao " . " FROM " . "ocorrencias AS o, prioridades AS pr " . "LEFT JOIN localizacao AS l ON l.loc_prior = pr.prior_cod " . "LEFT JOIN sla_solucao AS resp ON resp.slas_cod = pr.prior_sla, sla_solucao AS sol " . "LEFT JOIN problemas AS p ON p.prob_sla = sol.slas_cod " . "WHERE " . "o.problema = p.prob_id and o.local = l.loc_id and o.numero = " . $_GET['numero'] . "";
$exec_sql = mysql_query($sql) or die('ERRO: <br>' . $sql);
$row = mysql_fetch_array($exec_sql);
print "<br><b>" . TRANS('SLA_TO_TICKET') . " <font color='red'>" . $_GET['numero'] . "</font>:</b><br>";
print "<table cellspacing='0' border='1' cellpadding='1' align='left' width='100%'>";
print "<tr><td width='20%'><b>" . TRANS('FIELD_SECTOR') . ":</b></td><td width='30%'>" . NVL($row['LOCAL']) . "</td><td width='20%'><b>" . TRANS('OCO_PROB') . ":</b></td><td width='30%'>" . NVL($row['problema']) . "</td></tr>";
print "<tr><td width='20%'><b>" . TRANS('RESPONSE_SLA') . ":</b></td><td width='30%'>" . NVL($row['resposta']) . "</td><td width='20%'><b>" . TRANS('SOLVE_SLA') . ":</b></td><td width='30%'>" . NVL($row['solucao']) . "</td></tr>";
print "</table>";
print "</body>";
print "</html>";
//print "".TRANS('THERE_IS_ARE')." <b>".$registros."</b> ".TRANS('USER_S_IN_SYSTEM').".<br>";
print "<TR class='header'><td class='line'>" . TRANS('OPT_NAME', 'Nome') . "</TD>" . "<td class='line'>" . TRANS('OPT_LOGIN_NAME', 'Login') . "</TD><td class='line'>" . TRANS('OCO_FIELD_AREA', 'Área') . "</TD>" . "<td class='line'>" . TRANS('OCO_FIELD_AREA_ADMIN', 'Área admin') . "</TD>" . "<td class='line'>" . TRANS('OCO_FIELD_SUBSCRIBE_DATE', 'Data de inclusão') . "</TD><td class='line'>" . TRANS('OCO_FIELD_HIRE_DATE', 'Data de admissão') . "</TD>" . "<td class='line'>" . TRANS('OCO_FIELD_EMAIL', 'E-mail') . "</TD><td class='line'>" . TRANS('OCO_FIELD_PHONE', 'Telefone') . "</TD>" . "<td class='line'>" . TRANS('OCO_FIELD_LEVEL', 'Nível') . "</TD><td class='line'>" . TRANS('OCO_FIELD_ALTER', 'Alterar') . "</TD>" . "<td class='line'>" . TRANS('OCO_FIELD_EXCLUDE', 'Excluir') . "</TD></TR>";
$i = 0;
$j = 2;
while ($row = mysql_fetch_array($PAGE->RESULT_SQL)) {
$j % 2 ? $trClass = "lin_par" : ($trClass = "lin_impar");
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['nome'] . "</TD>";
print "<td class='line'>" . $row['login'] . "</TD>";
print "<td class='line'>" . $row['sistema'] . "</TD>";
print "<td class='line'>" . transbool($row['user_admin']) . "</TD>";
print "<td class='line'>" . datab($row['data_inc']) . "</TD>";
print "<td class='line'>" . datab($row['data_admis']) . "</TD>";
print "<td class='line'>" . $row['email'] . "</TD>";
print "<td class='line'>" . NVL($row['fone']) . "</TD>";
print "<td class='line'><a href='usuarios.php?nivel=" . $row['nivel_cod'] . "&n_desc=" . $row['nivel_nome'] . "'>" . $row['nivel_nome'] . "</a></TD>";
print "<td class='line'><a onClick=\"redirect('usuarios.php?action=alter&cellStyle=true&login="******"')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"javascript:confirmaAcao('" . TRANS('ENSURE_DEL') . " " . $row['nome'] . "?','usuarios.php','action=excluir&login="******"');\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></TD>";
print "</TR>";
}
print "<tr><td colspan='8'>";
$PAGE->showOutputPages();
print "</td></tr>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
$row = mysql_fetch_array($resultado);
print "<BR>";
print "<B>" . TRANS('CADASTRE_USERS') . ":</B>";
print "<BR>";
function generarFacturaProveedor($link, $id_proveedor, $flete, $numero_factura, $cobrarSeguro, $seguro, $envios)
{
$envios1 = $envios;
$envios2 = $envios;
if (!existeFactura($link, $numero_factura, $envios2)) {
$factura->proveedor = "";
$factura->factura = "";
$factura->total_bultos;
$factura->total_mercancia = 0;
$factura->total_peso = 0;
$factura->bskg = 0;
$factura->total_viaje;
$factura->flete = str_replace(",", ".", substr($flete, 0, strpos($flete, ",") + 3));
$factura->seguro = str_replace(",", ".", substr($seguro, 0, strpos($seguro, ",") + 3));
foreach ($envios as $id_envio) {
// Obtengo el envio
$query = "SELECT * FROM ts_envio WHERE id=" . $id_envio;
$result = mysql_query($query, $link);
$row = mysql_fetch_object($result);
if ($factura->cliente == "") {
$factura->cliente = obtenerProveedor($link, $row->id_proveedor);
}
$factura->proveedor .= obtenerProveedorStr($link, $row->id_proveedor) . ", ";
$factura->factura .= $row->factura . ", ";
$factura->total_bultos += $row->bultos;
$factura->total_mercancia += $row->mercancia;
$factura->total_peso += $row->peso;
$factura->total_flete_mercancia += $row->mercancia * ($factura->flete / 100);
$factura->total_flete_peso += $row->peso * $row->bskg;
if ($factura->flete == 0) {
$factura->flete = $row->flete;
}
if ($factura->bskg == 0) {
$factura->bskg = $row->bskg;
}
$factura->total_viaje += $row->viaje;
}
$factura->proveedor = substr($factura->proveedor, 0, -2);
$factura->factura = substr($factura->factura, 0, -2);
$factura->total_flete = $factura->total_flete_mercancia + $factura->total_flete_peso + $factura->total_viaje;
$factura->iva = obtenerIVA($link);
$factura->total_iva = $factura->iva / 100 * $factura->total_flete;
$valor = $factura->total_flete + $factura->total_iva;
if ($factura->seguro != "") {
$valor = $valor + $factura->total_mercancia * ($factura->seguro / 100);
}
$query = "INSERT INTO ts_factura(id_proveedor,\r\n\t\t\t numero_factura,\r\n\t\t\t fecha_factura,\r\n\t\t\t tipo_factura,\r\n\t\t\t factura,\r\n\t\t\t total_bultos,\r\n\t\t\t total_mercancia,\r\n\t\t\t flete,\r\n\t\t\t total_peso,\r\n\t\t\t bskg,\r\n\t\t\t total_viaje,\r\n\t\t\t iva,\r\n\t\t\t seguro,\r\n\t\t\t total_pagar,\r\n\t\t\t relacion,\r\n\t\t\t ind_factura,\r\n\t\t\t ind_activo,\r\n\t\t\t fecha_creacion,\r\n\t\t\t fecha_modificacion,\r\n\t\t\t id_usuario) \r\n\t\t\t VALUES(" . $id_proveedor . ", \r\n\t\t\t '" . $numero_factura . "', \r\n\t\t\t CURDATE(),\r\n\t\t\t 'P', \r\n\t\t\t '" . $factura->factura . "',\r\n\t\t\t " . $factura->total_bultos . ",\r\n\t\t\t " . $factura->total_mercancia . ",\r\n\t\t\t " . NVL($factura->flete) . ",\r\n\t\t\t " . NVL($factura->total_peso) . ",\r\n\t\t\t " . NVL($factura->bskg) . ",\r\n\t\t\t " . NVL($factura->total_viaje) . ",\r\n\t\t\t " . $factura->iva . ",\r\n\t\t\t " . NVL($factura->seguro) . ",\r\n\t\t\t " . $valor . ",\r\n\t\t\t " . codigoRelacion($link) . ",\r\n\t\t\t 1,\r\n\t\t\t 1,\r\n\t\t\t CURDATE(),\r\n\t\t\t CURDATE(),\r\n\t\t\t " . $_SESSION["id_usuario"] . ")";
mysql_query($query, $link);
$id_factura = mysql_insert_id($link);
foreach ($envios1 as $id_envio) {
// Obtengo el envio
$query = "SELECT * FROM ts_envio WHERE id=" . $id_envio;
$result = mysql_query($query, $link);
$row = mysql_fetch_object($result);
$query = "UPDATE ts_envio SET id_factura=" . $id_factura . " WHERE id=" . $row->id;
mysql_query($query, $link);
}
return "exitoGenerarFactura";
}
return "facturaYaExisteError";
}
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhaz" . $j . "' onMouseOver=\"destaca('linhaz" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhaz" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhaz" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
$radio_checado = "";
if (isset($_POST['radio_tpl'])) {
if ($_POST['radio_tpl'] == $rowTpl['tpl_cod']) {
$radio_checado = " checked";
}
}
print "<td class='line' width='10%'><input type='radio' name='radio_tpl' value='" . $rowTpl['tpl_cod'] . "' " . $radio_checado . " id='idRadio' onChange=\"fill_msg('idDivRadio" . $j . "','idDivRadioSub" . $j . "',this);\"> " . $rowTpl['tpl_sigla'] . "</td>";
print "<td class='line'><div id='idDivRadioSub" . $j . "'>" . NVL($rowTpl['tpl_subject']) . "</div></td>";
print "<td class='line'><div id='idDivRadio" . $j . "'>" . NVL($rowTpl['tpl_msg_text']) . "</div></td>";
print "</TR>";
}
}
print "</table></div></td></tr>";
// FIM DA DIV PARA EXIBIÇÃO DOS TEMPLATES
#########################################################
NL(4);
print "<TR>";
print "<TD colspan='2' align='center' width='50%' bgcolor='" . BODY_COLOR . "'>" . "<input type='hidden' value='" . $totalLists . "' name='totalLists'>";
if (isset($_REQUEST['numero'])) {
print "<input type='hidden' value='" . $_REQUEST['numero'] . "' name='numero'>";
}
print "<input type='submit' class='button' value='" . TRANS('BT_SEND') . "' name='submit' onClick=\"LOAD=0;\">";
print "</TD>";
print "<TD colspan='2' align='center' width='50%' bgcolor='" . BODY_COLOR . "'>" . "<INPUT type='button' class='button' value='" . TRANS('BT_CANCEL') . "' name='desloca' onClick=\"window.close();\">" . "</TD>";
print "<td class='line'><input type='radio' id='idRadioProb" . $row['prob_id'] . "' name='radio_prob' value='" . $row['prob_id'] . "'";
//------------------------------------------------------------- FIM ALTERACAO --------------------------------------------------------------
if (isset($_GET['radio_prob']) && $_GET['radio_prob'] == $row['prob_id']) {
print " checked";
} else {
if (isset($_GET['prob']) && $_GET['prob'] == $row['prob_id']) {
print " checked";
}
}
//else
//if (isset($_POST['radio_prob']) && $_POST['radio_prob'] == $row['prob_id']) print " checked"; else
//if (isset($_POST['prob']) && $_POST['prob'] == $row['prob_id']) print " checked";
//------------------------------------------------------------- INICIO ALTERACAO --------------------------------------------------------------
if (isset($_GET['pathAdmin'])) {
//se o script estiver sendo chamado da path do módulo de administração
print " onClick=\"ajaxFunction('divInformacaoProblema', '../../ocomon/geral/showInformacaoProb.php', 'idLoad', 'prob=idProblema', 'area_cod=idArea' , 'radio_prob=idRadioProb" . $row['prob_id'] . "');\"";
} else {
print " onClick=\"ajaxFunction('divInformacaoProblema', 'showInformacaoProb.php', 'idLoad', 'prob=idProblema', 'area_cod=idArea' , 'radio_prob=idRadioProb" . $row['prob_id'] . "');\"";
}
//------------------------------------------------------------- FIM ALTERACAO --------------------------------------------------------------
print ">" . $row['problema'] . "</td>";
print "<td class='line'>" . NVL($row['slas_desc']) . "</td>";
print "<td class='line'>" . NVL($row['probt1_desc']) . "</td>";
print "<td class='line'>" . NVL($row['probt2_desc']) . "</td>";
print "<td class='line'>" . NVL($row['probt3_desc']) . "</td>";
print "</TR>";
}
}
print "</table>";
//print "</div></td></tr>";
//print "</tr>";
$cor1 = TD_COLOR;
print "<tr><td colspan='4'>";
print "" . TRANS('THERE_IS_ARE') . " <b>" . $registros . "</b> " . TRANS('RECORDS_IN_SYSTEM') . ".</td>";
print "</tr>";
print "<TR class='header'><td class='line'>" . TRANS('COL_SITUAC') . "</TD><td class='line'>" . TRANS('COL_DESC') . "</TD><td class='line'>" . TRANS('COL_HILIGHT') . "</TD><td class='line'>" . TRANS('COL_EDIT') . "</TD><td class='line'>" . TRANS('COL_DEL') . "</TD></tr>";
$j = 2;
while ($row = mysql_fetch_array($resultado)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['situac_nome'] . "</td>";
print "<td class='line'>" . NVL($row['situac_desc']) . "</td>";
print "<td class='line'>" . transbool($row['situac_destaque']) . "</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['situac_cod'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('ENSURE_DEL') . "?','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['situac_cod'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</TR>";
}
//print "</TABLE>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
print "<BR><B>" . TRANS('CADASTRE_SITUAC') . "</B><BR>";
print "<TR>";
print "<TD width='20%' align='left' bgcolor='" . TD_COLOR . "'>" . TRANS('COL_SITUAC') . ":</TD>";
print "<TD width='80%' align='left' bgcolor='" . BODY_COLOR . "'><INPUT type='text' name='situacao' class='text' id='idSituacao'>" . "<input type='checkbox' name='destaque'>" . TRANS('COL_HILIGHT') . "</td>";
print "</TR>";
print "<tr>";
print "<TR class='header'><td class='line'>" . TRANS('COL_PROB', 'Problema') . "</TD><td class='line'>" . TRANS('COL_DESC', 'Descrição') . "</TD><td class='line'>" . TRANS('COL_ALIMENTA_BANCO_SOLUCAO') . "</TD><td class='line'>" . TRANS('COL_AREA', '') . "</TD><td class='line'>" . TRANS('COL_SLA', 'SLA') . "</TD>" . "<td class='line'>" . $row_config['conf_prob_tipo_1'] . "</TD><td class='line'>" . $row_config['conf_prob_tipo_2'] . "</TD>" . "<td class='line'>" . $row_config['conf_prob_tipo_3'] . "</TD><td class='line'>" . TRANS('COL_EDIT', '') . "</TD><td class='line'>" . TRANS('COL_DEL', '') . "</TD></tr>";
$j = 2;
while ($row = mysql_fetch_array($PAGE->RESULT_SQL)) {
if ($j % 2) {
$trClass = "lin_par";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
print "<td class='line'>" . $row['problema'] . "</td>";
print "<td class='line'>" . NVL($row['prob_descricao']) . "</td>";
//------------------------------------------------------------- INICIO ALTERACAO --------------------------------------------------------------
print "<td class='line'>" . transbool($row['prob_alimenta_banco_solucao']) . "</td>";
//------------------------------------------------------------- FIM ALTERACAO --------------------------------------------------------------
print "<td class='line'>" . NVL($row['sistema']) . "</td>";
print "<td class='line'>" . ($row['slas_desc'] == '' ? ' ' : $row['slas_desc']) . "</td>";
print "<td class='line'>" . ($row['probt1_desc'] == '' ? ' ' : $row['probt1_desc']) . "</td>";
print "<td class='line'>" . ($row['probt2_desc'] == '' ? ' ' : $row['probt2_desc']) . "</td>";
print "<td class='line'>" . ($row['probt3_desc'] == '' ? ' ' : $row['probt3_desc']) . "</td>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['prob_id'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('ENSURE_DEL') . "?','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['prob_id'] . "')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</TR>";
}
print "<tr><td colspan='8'>";
$PAGE->showOutputPages();
print "</td></tr>";
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
print "<BR><B>" . TRANS('CADASTRE_PROB') . "</B><BR>";
} else {
$trClass = "lin_impar";
}
$j++;
print "<tr class=" . $trClass . " id='linhax" . $j . "' onMouseOver=\"destaca('linhax" . $j . "','" . $_SESSION['s_colorDestaca'] . "');\" onMouseOut=\"libera('linhax" . $j . "','" . $_SESSION['s_colorLinPar'] . "','" . $_SESSION['s_colorLinImpar'] . "');\" onMouseDown=\"marca('linhax" . $j . "','" . $_SESSION['s_colorMarca'] . "');\">";
$sqlAux = "select count(*) total from hw_sw where hws_sw_cod = " . $row['soft_cod'] . " ";
$commitAux = mysql_query($sqlAux);
$rowAux = mysql_fetch_array($commitAux);
$dispo = $row['soft_qtd_lic'] - $rowAux['total'];
print "<td class='line'>" . $row['fab_nome'] . " " . $row['soft_desc'] . " " . $row['soft_versao'] . "</TD>";
print "<td class='line'>" . $row['cat_desc'] . "</TD>";
print "<td class='line'>" . $row['lic_desc'] . "</TD>";
print "<td class='line'>" . NVL($row['soft_qtd_lic']) . "</TD>";
print "<td class='line'>" . $dispo . "</TD>";
print "<td class='line'>" . NVL($row['forn_nome']) . "</TD>";
print "<td class='line'>" . NVL($row['soft_nf']) . "</TD>";
print "<td class='line'><a onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=alter&cod=" . $row['soft_cod'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "edit.png' title='" . TRANS('HNT_EDIT') . "'></a></td>";
print "<td class='line'><a onClick=\"confirmaAcao('" . TRANS('MSG_DEL_REG') . "','" . $_SERVER['PHP_SELF'] . "', 'action=excluir&cod=" . $row['soft_cod'] . "&cellStyle=true')\"><img height='16' width='16' src='" . ICONS_PATH . "drop.png' title='" . TRANS('HNT_DEL') . "'></a></TD>";
print "</TR>";
}
}
} else {
if (isset($_GET['action']) && $_GET['action'] == "incluir" && empty($_POST['submit'])) {
print "<BR><B>" . TRANS('SUBTTL_CAD_SOFT') . "</B><BR>";
print "<tr>";
print "<td width='20%' align='right' bgcolor=" . TD_COLOR . ">" . TRANS('COL_SOFT') . ":</TD>";
print "<td width='80%' align='left' bgcolor=" . BODY_COLOR . "><input type='text' class='text' name='software' id='idSoftware'>";
print "</td>";
print "</tr>";
print "<tr>";
print "<td width='20%' align='right' bgcolor=" . TD_COLOR . ">" . TRANS('COL_VERSION') . ":</TD>";
