o time de desenvolvimento alterou apenas a query do arquivo home:
//Alteração - Gustavo e Andre 07/07/2014 -- inclusão do comando "order by o.numero"
$qryDetail = $QRY["ocorrencias_full_ini"]." WHERE o.sistema = ".$rowAreas['area_cod']." and s.stat_painel in (1,2) and ".
" o.status = ".$rowStatus['stat_id']." order by o.numero";
$execDetail = mysql_query($qryDetail) or die (TRANS('MSG_ERR_RESCUE_DATA_OCCO') .$qryDetail);//Alteração - Gustavo e Andre 07/07/2014 -- inclusão do comando "order by o.numero"
$qryDetail = $QRY["ocorrencias_full_ini"]." WHERE o.sistema = ".$rowAreas['area_cod']." and s.stat_painel in (1,2) and ".
" o.status = ".$rowStatus['stat_id']." order by o.numero";
inserindo o order by o.numero";
$execDetail = mysql_query($qryDetail) or die (TRANS('MSG_ERR_RESCUE_DATA_OCCO') .$qryDetail);
Last edit: SIDNEY 2014-07-07
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
o time de desenvolvimento alterou apenas a query do arquivo home:
//Alteração - Gustavo e Andre 07/07/2014 -- inclusão do comando "order by o.numero"
$qryDetail = $QRY["ocorrencias_full_ini"]." WHERE o.sistema = ".$rowAreas['area_cod']." and s.stat_painel in (1,2) and ".
" o.status = ".$rowStatus['stat_id']." order by o.numero";
$execDetail = mysql_query($qryDetail) or die (TRANS('MSG_ERR_RESCUE_DATA_OCCO') .$qryDetail);//Alteração - Gustavo e Andre 07/07/2014 -- inclusão do comando "order by o.numero"
$qryDetail = $QRY["ocorrencias_full_ini"]." WHERE o.sistema = ".$rowAreas['area_cod']." and s.stat_painel in (1,2) and ".
" o.status = ".$rowStatus['stat_id']." order by o.numero";
inserindo o order by o.numero";
$execDetail = mysql_query($qryDetail) or die (TRANS('MSG_ERR_RESCUE_DATA_OCCO') .$qryDetail);
Last edit: SIDNEY 2014-07-07