{% extends 'MainBundle:Master:template.html.twig' %}
{% block scripts %}
    <link rel="stylesheet" href="{{ asset('bundles/grid/css/ui.jqgrid.css') }}" />
    <style>
        .firstname:hover, .firstname:focus, .firstname:active {
            background-color: #001f3f;
            padding: 10px;
            -webkit-transform: scale(0.9);
            transform: scale(0.9);
        }
    </style>
    <script src="{{ asset('bundles/grid/js/jquery.jqGrid.js') }}">
    </script>
    <script src="{{ asset('bundles/grid/js/i18n/grid.locale-'~ locale ~'.js') }}">
    </script>
    <script language="javascript">
        // data modalities
        var url_data='{{ path('sessionDataGrid') }}';
        var url_removeS='{{ path('sessionRemoveData') }}';
        var session_data='';
        var filters='';
        var modalityD='';
        {% if(app.session.get('mainGrid_modality') is defined) %}
            modalityD= '{{ app.session.get('mainGrid_modality') }}';
            session_data+='mainGrid_modality*';
        {% endif %}
        if(modalityD!=''){
            filters += '{"field":"M.idModality","op":"eq","data":"'+modalityD+'"},';
        }

        var modalities=': {{ 'labels.all'|trans([], 'LocalizationBundle') }};';
        {% for modality in entities %}
        modalities+='{{ modality.varMod }}'+":"+'{{ modality.varMod }};';
        {% endfor %}
        // data provenances
        var provenancesD='';
        {% if(app.session.get('mainGrid_provenance') is defined) %}
            provenancesD='{{ app.session.get('mainGrid_provenance') }}';
            session_data+='mainGrid_provenance*';
        {% endif %}
        if(provenancesD!=''){
            filters += '{"field":"PRO.name","op":"eq","data":"'+provenancesD+'"},';
        }
        var provenances=': {{ 'labels.all'|trans([], 'LocalizationBundle') }};';
        {% for provenance in proList %}
            provenances+='{{ provenance.name }}'+":"+'{{ provenance.name }};';
        {% endfor %}
        // data priority
        var prioritiesD='';
        {% if(app.session.get('mainGrid_priority') is defined) %}
            prioritiesD='{{ app.session.get('mainGrid_priority') }}';
            session_data+='mainGrid_priority*';
        {% endif %}
        if(prioritiesD!=''){
            filters +='{"field":"PRI.id","op":"eq","data":"'+prioritiesD+'"},';
        }
        var priorities=':{{ 'labels.all'|trans([], 'LocalizationBundle') }};';

        {% for priority in priList %}
        priorities+='{{ priority.priId }}'+":"+'{{ priority.priName }};';
        {% endfor %}
        //data studyname
        var studyNameD='';
        {% if(app.session.get('mainGrid_status') is defined) %}
            studyNameD='{{ app.session.get('mainGrid_status') }}';
            session_data+='mainGrid_status*';
        {% endif %}
        if(studyNameD!=''){
            filters +='{"field":"A.appointmentStatus","op":"eq","data":"'+studyNameD+'"},';
        }
        var studyName=': {{ 'labels.all'|trans([], 'LocalizationBundle') }};'+
                "5:"+'{{ 'patient.plect.label'|trans([], 'LocalizationBundle') }};'+
                "7:"+'{{ 'patient.ptrans.label'|trans([], 'LocalizationBundle') }};'+
                "9:"+'{{ 'patient.pvali.label'|trans([], 'LocalizationBundle') }};'+
                "11:"+'{{ 'patient.vali.label'|trans([], 'LocalizationBundle') }};'+
                "13:"+'{{ 'patient.entre.label'|trans([], 'LocalizationBundle') }};'+
                "15:"+'{{ 'patient.reg.label'|trans([], 'LocalizationBundle') }}';

        //data headquater
        var HeadquartD='';
        {% if(app.session.get('mainGrid_headquarter') is defined) %}
            HeadquartD='{{ app.session.get('mainGrid_headquarter') }}';
            session_data+='mainGrid_headquarter*';
        {% endif %}
        if(HeadquartD!=''){
            filters +='{"field":"H.headquarterName","op":"eq","data":"'+HeadquartD+'"},';
        }
        var Headquart=':{{ 'labels.all'|trans([], 'LocalizationBundle') }};';
        {% for sedes in Headquarter %}
        Headquart+='{{ sedes.varHead  }}'+":"+'{{ sedes.varHead }};';
        {% endfor %}
        //data appointmentDate
        var appointmentD='';
        {% if(app.session.get('mainGrid_date') is defined) %}
            appointmentD='{{ app.session.get('mainGrid_date') }}';
            session_data+='mainGrid_date*';
        {% endif %}
        if(appointmentD!=''){
            filters +='{"field":"A.appointmentDate","op":"eq","data":"'+appointmentD+'"},';
        }

        $(function() {
            var xw = parseInt($(document).width());
            $("#grid").jqGrid({
                url: "{{ path('_grid_main') }}",datatype: 'json',
                        postData: {
                            filters:'{"groupOp":"AND","rules":['+filters.slice(0, -1)+']}'
                        }
                , colModel: [
                    {name:'appointmentDate1', index:'A.appointmentDate', width:17, search:true, stype:'text',
                        formatoptions: {
                            srcformat: 'dd-mm-yy',
                            newformat: 'dd-mm-yy'

                        },
                        sorttype:"date",
                        searchoptions: { clearSearch: false, sopt: ['eq','le','ge'],

                            dataInit: function (elem) {
                                $(elem).datepicker({
                                    dateFormat: 'dd-mm-yy',
                                    changeYear: true,
                                    changeMonth: true,
                                    
                                });
                            },defaultValue:appointmentD
                        } }, 
                    {name:'idRoomAppointmentStudyReceipt', index:'R.idRoomAppointmentStudyReceipt', sortable:false, align: 'center', width:3, search:false }, 
                    {name:'idRoomAppointmentStudyReceipt', index:'R.idRoomAppointmentStudyReceipt', sortable:false, align: 'center', width:3, search:false },
                    {name:'idRoomAppointmentStudyReceipt', index:'R.idRoomAppointmentStudyReceipt', sortable:false, align: 'center', width:3, search:false },
                    {name:'idRoomAppointmentStudyReceipt', index:'R.idRoomAppointmentStudyReceipt', sortable:false, align: 'center', width:3, search:false },
                    {name:'appointmentDate2',index:'A.appointmentDate', datefmt:'H:i', align:'center', width:20, search:false},
                    {name:'idDocumentType',index:'docType', sorttype:'string', width:20, align:'center', search:false},

                    {name:'document', index:'P.document', width:25,searchoptions:{clearSearch: false,sopt:['cn']},  sortable: true, sorttype:'number'},
                 
                    {name:'ageYear', index:'P.ageYear', width:10,searchoptions:{clearSearch: false,sopt:['eq']},  sortable: true, sorttype:'number'},    
                    
                    {name:'firstLastName', index:'P.firstLastName', editoptions: { style: "text-transform: uppercase" },width:65,searchoptions:{clearSearch: false, sopt:['cn']},sorttype:'text'},
                    {name:'studyName', index:'S.studyName', sorttype:'text', width:35,searchoptions:{clearSearch: false,sopt:['cn']}},
                    {name:'varMod', index:'M.idModality', sorttype:'text', width:15, stype:"select", searchoptions:{clearSearch: false,value:modalities.slice(0, -1),defaultValue:modalityD}},
                    {name:'Procedencia', index:'PRO.name', sorttype:'text',  stype:"select", width:25,searchoptions:{sopt:['eq'], clearSearch: false,value:provenances.slice(0, -1),defaultValue:provenancesD}},
                    {name:'priority', index:'PRI.id', sorttype:'text',stype:"select", width:25,searchoptions:{sopt:['eq'],clearSearch: false,value:priorities.slice(0, -1),defaultValue:prioritiesD}},
                    {name:'varHead', index:'H.headquarterName', stype:"select", width:25, searchoptions:{clearSearch: false,value:Headquart.slice(0, -1),defaultValue:HeadquartD}},
                    {name:'appointmentStatus', index:'A.appointmentStatus', stype:"select", width:25, searchoptions:{clearSearch: false,value: studyName,defaultValue:studyNameD}},
                    {name:'bottom', index:'A.bottom', stype:"select", sortable:false, align: 'center', width:5, search:false }  

                ]
                , colNames: ["{{ 'Query.date_arrival.label'|trans([], 'LocalizationBundle') }}:",
                    "",
                    "",
                    "",
                    "",
                    
                 
                                     
                    "{{ 'Query.time_arrival.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Query.typeDocument.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Query.ID.label'|trans([], 'LocalizationBundle') }}:",
                    
                    "{{ 'Query.age.label'|trans([], 'LocalizationBundle') }}:",
                    
                    "{{ 'Query.patient.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'WorkslitResult.study.plural'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Query.mod.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Modify.pre.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Modify.pri.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'assistive.headquarters.label'|trans([], 'LocalizationBundle') }}:",
                    "{{ 'Query.state.label'|trans([], 'LocalizationBundle') }}:",
                    ""

                ]
                ,
                rowList:[30, 60, 90],
                rowNum:30,
                sortname: 'A.appointmentDate',
                pager: '#pager',
                viewrecords: true,
                shrinkToFit:true,
                height: '100%',
                forceFit:true,
                autowidth:true,
                position: "last",
                caption: '{{ 'Query.label.label'|trans([], 'LocalizationBundle') }}',
                toppager:true,
                ondblClickRow: function(id){
                    var url_detail='{{ path('DetailInformationPatientRec', {'per':'per'}) }}';
                    url_detail = url_detail.replace("per", id);
                    window.open(url_detail);
                }
            });
            var table_selector="#grid";
            var pager_selector="#pager";
            $(table_selector).jqGrid('navGrid', pager_selector, {
                cloneToTop: true,
                edit: false,
                add: false,
                del: false,
                search: true,
                refresh: true,
                view: false
            },{},{},{},{multipleSearch:true});

            $(table_selector).jqGrid('navSeparatorAdd', table_selector + '_toppager', {
                sepclass: 'ui-separator',
                sepcontent: '',
                position: 'last'
            });

            $(table_selector).jqGrid('navButtonAdd', table_selector + '_toppager', {
                caption: '  X  ',
                buttonicon: 'ui-icon ',
                onClickButton: function() {
                    if(session_data!=''){
                        $('#gs_varMod option[value=""]').attr('selected','selected');
                        $('#gs_Procedencia option[value=""]').attr('selected','selected');
                        $('#gs_priority option[value=""]').attr('selected','selected');
                        $('#gs_varHead option[value=""]').attr('selected','selected');
                        $('#gs_appointmentStatus option[value=""]').attr('selected','selected');
                        $('#gs_appointmentDate1').val('');
                        RemoveSessions(url_removeS,session_data.slice(0, -1));
                    }

                },
                position: 'last'
            });
            jQuery("#grid").jqGrid('setFrozenColumns');
            $('#gs_appointmentDate1').datepicker();

            jQuery("#grid").jqGrid('filterToolbar',{searchOperators : false, stringResult: true, searchOnEnter: false, searchfield:true, autosearch:true, disabledClear:true});
            $("#grid").jqGrid ('setLabel', 'Name', '', {'text-align':'right'});
            $('#grid').setGridParam({datatype: 'json', url:'{{ path('_grid_main') }}'});
            $('#grid')[0].triggerToolbar();
            //$('#grid').trigger("toolbar",[{current:true}]);
            setInterval('refresh()', parseInt({{ refresh_timer }})*1000);
            //filters change
            $('#gs_varMod').change(function(){
                setSession(url_data,'mainGrid','modality', $(this).val());
            });
            $('#gs_Procedencia').change(function(){
                setSession(url_data,'mainGrid','provenance', $(this).val());
            });
            $('#gs_priority').change(function(){
                setSession(url_data,'mainGrid','priority', $(this).val());
            });
            $('#gs_varHead').change(function(){
                setSession(url_data,'mainGrid','headquarter', $(this).val());
            });
            $('#gs_appointmentStatus').change(function(){
                setSession(url_data,'mainGrid','status', $(this).val());
            });
           
            $('#gs_appointmentDate1').change(function (dateText, inst) {
                                        setSession(url_data,'mainGrid','date', $('#gs_appointmentDate1').val());
                                        setTimeout(function () {
                                            $('#grid')[0].triggerToolbar();
                                        }, 100);
                                    });

        });
        function refresh(){
            $('#grid').trigger("reloadGrid",[{current:true}]);
        }
        function RemoveSessions(url,fields){
            $.ajax({
                url: url,
                type: "POST",
                data: {
                    'fields': fields
                },
                success: function(resp) { //Limpia el cuerpo de la tabla para incluir la nueva información
                    var jsonResp = JSON.parse(resp);
                    console.log(jsonResp);
                    location.reload();
                },
                onFailure: function() {
                    //alert('Se ha producido un error');
                }
            });
        }
        function setSession(url,grid,field,value){
            $.ajax({
                url: url,
                type: "POST",
                data: {
                    'grid': grid,
                    'field': field,
                    'value': value
                },
                success: function(resp) { //Limpia el cuerpo de la tabla para incluir la nueva información
                    var jsonResp = JSON.parse(resp);
                    console.info(jsonResp);
                },
                onFailure: function() {
                    //alert('Se ha producido un error');
                }
            });
        }
    </script>

{% endblock %}
{% block content %}

    <section >
        <div style="padding:0 20px 20px 20px; ">
            <table id="grid" ></table>
            <div id="pager" ></div>
        </div>

    </section>

{% endblock %}