jQuery Grid Plugin - jqGrid

Hi Tony,

You could try this behavior on this page: http://hpintel-pt.dyndns.org:8.....al-novo11/

var gridimgpath  = 'themes/basic/images';

var modPesquisa  = 'B';

var docEstudo = jQuery(document).ready(function(){

  var mygridE = jQuery("#s5list").jqGrid({

   url: "search_estudo.php?q=1",

    datatype: "json",

   autowidth: true,

height: '100%',

  colNames:['Accoes','Paciente','ID','Aniversario','Sexo','Id Estudo','Data','Descricao','Mod.','Medico Ref.','Report','Instituicao','PK'],

  colModel:[

   {name:'accoes',index:'accoes', width:110, sortable:false},

   {name:'pat_name',index:'pat_name', width:140},

   {name:'pat_id',index:'pat_id', width:60, sorttype:"int"},

//   {name:'aniversario',index:'aniversario', width:70, sorttype:"date" , searchoptions:{dataInit:function(el){$(el).datepicker({dateFormat:'yy-mm-dd'});} }},

   {name:'aniversario',index:'aniversario', width:70, sorttype:"date"},

   {name:'pat_sex',index:'pat_sex', width:30, align:"center", stype:'select', editoptions:{value:":Todos;M:M;F:F;O:O"}},

   {name:'study_iuid',index:'study_iuid', width:100, align:"left", searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},

//   {name:'study_datetime',index:'study_datetime', width:70, sorttype:"date", searchoptions:{dataInit:function(el){$(el).datepicker({dateFormat:'yy-mm-dd'});} }},

   {name:'study_datetime',index:'study_datetime', width:70, sorttype:"date"},

   {name:'study_desc',index:'study_desc', width:140, align:"left", searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},

  {name:'mods_in_study',index:'mods_in_study', width:40, stype:'select', editoptions:{value:":Todas;CR:CR;CT:CT;MR:MR;US:US;XA:XA;AU:AU;BI:BI;CD:CD;DD:DD;DG:DG;DX:DX;ECG:ECG;EPS:EPS;ES:ES;GM:GM;HC:HC;HD:HD;IO:IO;IVUS:IVUS;KO:KO;LS:LS;MG:MG;NM:NM;OCT:OCT;OP:OP;OPM:OPM;OPR:OPR;OPV:OPV;OT:OT;PR:PR;PT:PT;PX:PX;REG:REG;RF:RF;RG:RG;RTDOSE:RTDOSE;RTIMAGE:RTIMAGE;RTPLAN:RTPLAN;RTRECORD:RTRECORD;RTSTRUCT:RTSTRUCT;SEG:SEG;SM:SM;SMR:SMR;SR:SR;ST:ST;TG:TG;XC:XC"}},

   {name:'ref_physician',index:'ref_physician', width:120, searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},

   {name:'report_status',index:'report_status', width:15, hidden:true, sortable:false},

   {name:'instituicao',index:'instituicao', width:120},

   {name:'pk',index:'pk', width:15, hidden:true, sortable:false}

  ],

  autosearch: true,

  rowNum:30,

  mtype: "GET",

  rowList:[15,30,45,60,100],

  imgpath: gridimgpath,

  pager: '#s5pager',

multiselect: false,

  sortname: 'study_datetime',

  viewrecords: true,

  sortorder: "desc",

rownumbers: true,

gridview : false,

onRightClickRow: function(id){ alert("Menu de propriedades para o Estudo: "+id);},

ondblClickRow: function(id){ 

var ret=jQuery("#s5list").getRowData(id);

window.open("detalhe.php?codExame="+ret.study_iuid+"&nome="+ret.pat_name);

},

loadComplete: function(){

var ids = jQuery("#s5list").getDataIDs();

for(var i=0;i<ids.length;i++){

var cl  = ids[i];

var ret = jQuery("#s5list").getRowData(cl);

be = "<input style='height:15px;width:15px;' src='images/viewerw.gif' type='image' title='Chama o Viewer VisionW' onclick=window.open('/visionw/visionw?studyUID="+ret.study_iuid+"'); ></ids>"; 

if(ret.mods_in_study=="XA"){se = "";}

else {se = "<input style='height:15px;width:15px;' src='images/viewerx.gif' type='image' title='Chama o Viewer VisionX' onclick=window.open('/dicom/visionx?codExame="+ret.study_iuid+"'); />";} 

if(ret.mods_in_study=="XA"){ce = "<input style='height:15px;width:15px;' src='images/viewerm.gif' type='image' title='Chama o Viewer MediaPlayer para Hemodinamica' onclick=window.open('/mediaplayer/movie.jsp?codExame="+ret.study_iuid+"'); />";}

else {ce = "";} 

if(ret.report_status=="T"){re = "<input style='height:15px;width:15px;' src='images/rpt_ok.gif' type='image' title='Relatorio terminado' onclick=window.open('/relatorios/index.jsp?codExame="+ret.study_iuid+"'); />";}

else {re = "<input style='height:15px;width:15px;' src='images/rpt_off.gif' type='image' title='Relatorio em execução' onclick=window.open('/relatorios/index.jsp?codExame="+ret.study_iuid+"'); />";} 

dt = "<input style='height:15px;width:15px;' src='images/detalhe.gif' type='image' title='Previsualizacao de imagens do estudo' onclick=window.open('/portal-teste/detalhe.php?codExame="+ret.study_iuid+"');>"; 

bd = "<input style='height:15px;width:15px;' src='images/database.gif' type='image' title='Informação DICOM na Base de Dados' onclick=alert('Visualização de Informação DICOM na BD');>"; 

sd = "<input style='height:15px;width:15px;' src='images/send.gif' type='image' title='Enviar estudo para AET' onclick=copiar_estudo();>"; 

md = "<input style='height:15px;width:15px;' src='images/move.gif' type='image' title='Enviar estudo para AET e apagar na origem' onclick=mover_estudo();>"; 

dd = "<input style='height:15px;width:15px;' src='images/trash.gif' type='image' title='Apagar estudo' onclick=apagar_estudo();>"; 

// dd = "<input style='height:15px;width:15px;' src='images/trash.gif' type='image' title='Apagar estudo' onclick=window.confirm('&confirmSendSelectedEntitiesTo;'+document.myForm.destination.options[document.myForm.destination.selectedIndex ].text + '&confirmSendSelectedEntitiesTo2;');>"; 

//   di = "<input style='height:20px;width:20px;' src='images/dicom.gif' type='image' title='Informação DICOM do estudo' onclick=window.open('detalhe.php?codExame="+ret.study_iuid+"&nome="+ret.pat_name+"');>"; 

  

jQuery("#s5list").setRowData(ids[i],{accoes:be+se+ce+re+" "+dt+bd+" "+sd+md+dd})

}

},

  subGrid: true,

subGridRowExpanded: function(subgrid_id, row_id) {

var subgrid_table_id = subgrid_id+"_t";

var pager_id         = "p_"+subgrid_table_id;

var ret              = jQuery("#s5list").getRowData(row_id);

var row_pk           = ret.pk;

var estudo_id        = ret.study_iuid;

$("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table><div id='"+pager_id+"' class='scroll'></div>");

var mysubgridE = jQuery("#"+subgrid_table_id).jqGrid({

     url: "search_estudo_det.php?q=1&pk="+row_pk,

     datatype: "json",

     colNames:['Accoes','Id Serie','Descricao','AET Origem','Imagens'],

     colModel:[

              {name:'accoes',index:'accoes', width:30, sortable:false},

     {name:'series_iuid',index:'series_iuid', width:170, align:"left", searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}, key:true},

     {name:'series_desc',index:'series_desc', width:170, align:"left", searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},

     {name:'src_aet',index:'src_aet', width:70, align:"left", searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},

     {name:'imagens',index:'imagens', width:30, sortable:false}

     ],

     autowidth: true,

   height: '100%',

   autosearch: true,

     pager: pager_id,

     multiselect: true,

     sortname: 'series_iuid',

     viewrecords: false,

       sortorder: "asc",

     rownumbers: true,

     gridview : false,

        onRightClickRow: function(id){ alert("Menu de propriedades para a serie: "+id);},

       loadComplete: function(){

       var ids = jQuery("#"+subgrid_table_id).getDataIDs();

       for(var i=0;i<ids.length;i++){

       var cl  = ids[i];

         var ret = jQuery("#"+subgrid_table_id).getRowData(cl);

       ddt  = "<input style='height:15px;width:15px;' src='images/detalhe.gif' type='image' title='Imagens da Serie (Em desenvolvimento ...)' onclick=window.open('detalhe_serie.php?codExame="+estudo_id+"&codSerie="+ret.series_iuid+"'); ></ids>"; 

     dse  = "<input style='height:15px;width:15px;' src='images/viewerx.gif' type='image' title='Chama o Viewer VisionJ2' onclick=window.open('/portal-novo11/visionj/visionj2.php?codExame="+estudo_id+"&codSerie="+ret.series_iuid+"'); />"; 

     ds2  = "<input style='height:15px;width:15px;' src='images/viewerx.gif' type='image' title='Chama o Viewer VisionJ' onclick=window.open('/portal-novo11/visionj/visionj.php?codExame="+estudo_id+"&codSerie="+ret.series_iuid+"'); />"; 

       dsd  = "<input style='height:15px;width:15px;' src='images/send.gif' type='image' title='Enviar serie para AET' onclick=copiar_serie();>"; 

       dmd  = "<input style='height:15px;width:15px;' src='images/move.gif' type='image' title='Enviar serie para AET e apagar na origem' onclick=mover_serie();>"; 

       ddd  = "<input style='height:15px;width:15px;' src='images/trash.gif' type='image' title='Apagar serie' onclick=apagar_serie();>"; 

       jQuery("#"+subgrid_table_id).setRowData(ids[i],{accoes:ddt+dse+ds2+" "+dsd+dmd+ddd})

       }

         }

     }).navGrid("#"+pager_id,{edit:false,add:false,del:false,search:false,refresh:false})

          .navButtonAdd("#"+pager_id,{caption:"Fixar",title:"Fixa Barra de Pesquisa", buttonicon :'ui-icon-pin-s',

             onClickButton:function(){

           mysubgrid[0].toggleToolbar()

           } 

        })

          .navButtonAdd("#"+pager_id,{caption:"Limpar",title:"Limpar Pesquisa",buttonicon :'ui-icon-refresh',

             onClickButton:function(){

           mysubgrid[0].clearToolbar()

           } 

        })

          .navButtonAdd("#"+pager_id,{caption:"Teste",title:"Selecção de Series",buttonicon :'ui-icon-search',

           onClickButton:function(){

            var mensagem2 = "";

            var nome2     = "";

            alert("Teste Inicio "+subgrid_table_id);

            var s2 = jQuery("#"+subgrid_table_id).getGridParam('selrow');

       var retv = jQuery("#"+subgrid_table_id).getRowData(s2[0]);

            alert("Teste i2: "+s2.length+" "+s2+" - "+retv.series_iuid);

         for(var i2=0;i2<s2.length;i2++){

         var cl2  = s2[i2];

         var ret2 = jQuery("#"+subgrid_table_id).getRowData(cl2);

         if(mensagem2==""){mensagem2 = ret2.series_iuid;}

         else {mensagem2 = mensagem2 + ", " + ret2.series_iuid}; 

         }

         if(mensagem2=="") {alert('Não seleccionou nenhum exame');}

          else {alert("Series: = "+mensagem2);}

        } 

        });

     },

      subGridRowColapsed: function(subgrid_id, row_id) {

      },  

   caption: "Lista de Estudos / Series"

  })

  .navGrid("#s5pager",{edit:false,add:false,del:false,search:false,refresh:false})

  .navButtonAdd("#s5pager",{caption:"Barra de Pesquisa",title:"Activar / Desactivar Barra de Pesquisa", buttonicon :'ui-icon-pin-s',

   onClickButton:function(){

   mygridE[0].toggleToolbar();

   if(modPesquisa=="B"){modPesquisa="C";}

      else{

        modPesquisa="B";

        jQuery("#s5list").setGridParam({url:"search_estudo.php?q=1"});

      }  

   } 

  })

  .navButtonAdd("#s5pager",{caption:"Pesquisa Composta",title:"Usar Pesquisa Composta", buttonicon :'ui-icon-search',

   onClickButton:function(){

      if(modPesquisa=="B"){mygridE[0].toggleToolbar();}

      modPesquisa="C";

      jQuery("#s5list").setGridParam({url:"search_estudo_f.php?q=1"});

      jQuery("#s5list").searchGrid( {multipleSearch:true} );

   } 

  })

  .navButtonAdd("#s5pager",{caption:"Limpar",title:"Limpar Pesquisa",buttonicon :'ui-icon-refresh',

   onClickButton:function(){

   mygridE[0].clearToolbar()

   } 

  })

  .navButtonAdd("#s5pager",{caption:"Teste",title:"Selecção de Series",buttonicon :'ui-icon-search',

   onClickButton:function(){

     var s1 = jQuery("#s5list").getGridParam('records');

      var mensagem = "";

      var nome     = "";

      alert("Teste Inicio");

     for(var i1=0;i1<s1.length;i1++){

     var nsublista = i1+1;

     var sublista = "#s5list_"+nsublista+"_t";

        alert("Teste i1: "+sublista+" "+s1.length);

        var s2 = jQuery(sublista).getGridParam('selrow');

//     for(var i=0;i<s.length;i++){

          alert("Teste i: "+s2.length);

     var cl2  = s2[0];

     var ret2 = jQuery(sublista).getRowData(cl2);

     if(mensagem==""){mensagem = ret2.series_iuid;}

     else {mensagem = mensagem + ", " + ret2.series_iuid}; 

//     }

     }

     if(mensagem=="") {alert('Não seleccionou nenhum exame');}

      else {alert("Series: = "+mensagem);}

   } 

  });

  mygridE.filterToolbar();

  jQuery("#m1").click( function() {

   var s1 = jQuery("#s5list").getGridParam('records');

    var mensagem = "";

    var nome     = "";

for(var i1=0;i1<s1.length;i1++){

  var s = jQuery("#s5list_"+i+"_t").getGridParam('selrow');

for(var i=0;i<s.length;i++){

var cl  = s[i];

var ret = jQuery("#s5list_"+i+"_t").getRowData(cl);

if(mensagem==""){mensagem = ret.series_iuid;}

else {mensagem = mensagem + "," + ret.series_iuid}; 

  }

}

if(mensagem=="") {alert('Não seleccionou nenhum exame');}

    else {alert("Series: = "+mensagem);}

  });

  $("#div_geral img[title]").tooltip({ 

      tip: '#funnytip', 

      position: "center left", 

      opacity: 0.7 

  });

});

function apaga_serie(){

var df = confirm(" Deseja apagar esta serie???? ");

}

function apaga_estudo(){

var df = confirm(" Deseja apagar este estudo???? ");

}

function move_estudo(){

var df = confirm(" Deseja mover este estudo para outro AET???? ");

}

function move_serie(){

var df = confirm(" Deseja mover esta serie para outro AET???? ");

}

function copia_estudo(){

var df = confirm(" Deseja copiar este estudo para outro AET???? ");

}

function copia_serie(){

var df = confirm(" Deseja copiar esta serie para outro AET???? ");

}

Best regards,

Helder

Hi Tony,

I already tried and tried to manage that error .. but I can't understand what's happening.

I went through the code, and I even changed jquery to an uncompressed version and tried to follow the code, but it's hard 🙂 all the errors that I got was related with jquery.

Could you help me on this???

If you think it's better we could talk over Skype or MSN.

Best regards,

Helder