{% extends 'MainBundle:Master:template.html.twig' %}
{% block scripts %}

<link rel="stylesheet" href="{{ asset('bundles/grid/css/ui.jqgrid.css') }}" />
<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">

    var url_data='{{ path('sessionDataGrid') }}';
    var url_removeS='{{ path('sessionRemoveData') }}';
    var session_data='';
    var filters='';

    //data room
    var RoomD='';
    {% if(app.session.get('scheduleAppGrid_room') is defined) %}
    RoomD='{{ app.session.get('scheduleAppGrid_room') }}';
    session_data+='scheduleAppGrid_room*';
    {% endif %}
    if(RoomD!=''){
        filters +='{"field":"roc.roomName","op":"eq","data":"'+RoomD+'"},';
    }
    var Room=': {{ 'labels.all'|trans([], 'LocalizationBundle') }};';
    {% for rooms in roomlist %}
    Room+='{{ rooms.roomName  }}'+":"+'{{ rooms.roomName }}';
    {% if loop.index != roomlist|length %}
    Room+=';';
    {% endif %}
    {% endfor %}

    //data modalities
    var modalityD='';
    {% if(app.session.get('scheduleAppGrid_modality') is defined) %}
    modalityD= '{{ app.session.get('scheduleAppGrid_modality') }}';
    session_data+='scheduleAppGrid_modality*';
    {% endif %}
    if(modalityD!=''){
        filters += '{"field":"mod.idModality","op":"eq","data":"'+modalityD+'"},';
    }
    var modalities=': {{ 'labels.all'|trans([], 'LocalizationBundle') }};';
    {% for modality in entities %}
    modalities+='{{ modality.varMod }}'+":"+'{{ modality.varMod }}';
    {% if loop.index != entities|length %}
    modalities+=';';
    {% endif %}
    {% endfor %}

    // data agreement
    var epsD='';
    {% if(app.session.get('scheduleAppGrid__eps') is defined) %}
    epsD='{{ app.session.get('scheduleAppGrid__eps') }}';
    session_data+='scheduleAppGrid__eps*';
    {% endif %}
    if(epsD!=''){
        filters +='{"field":"eps.name","op":"eq","data":"'+epsD+'"},';
    }
    var eps = ': {{ 'labels.all'|trans([], 'LocalizationBundle') }};';
    {% for VarEpsList in epsList %}
    eps+='{{ VarEpsList.name }}'+":"+'{{ VarEpsList.name }}';
    {% if loop.index != epsList|length %}
    eps+=';';
    {% endif %}
    {% endfor %}

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

    $(function() {

        $("#grid").jqGrid({
            url: "{{ path('_grid_schedule_appointment_data') }}",datatype: 'json',
            postData: {
                filters:'{"groupOp":"AND","rules":['+filters.slice(0, -1)+']}'
            },
            colModel: [{name:'dateStart', index:'sche.dateStart', width:25, stype:"text",
                formatoptions: {
                    srcformat: 'yy-mm-dd',
                    newformat: 'yy-mm-dd'

                },
                sorttype:"date",
                searchoptions: { sopt: ['eq','le','ge'],
                    clearSearch: false,
                    dataInit: function (elem) {
                        $(elem).datepicker({
                            dateFormat: 'dd-mm-yy',
                            changeYear: true,
                            changeMonth: true
                        });
                    },defaultValue:appointmentD
                }},
                {name:'hoursStart',index:'sche.hoursStart', sorttype:'date', datefmt:'H:i', align:'center', width:20, search:false},
                {name:'duration',index:'scheRul.duration', sorttype:'string', width:20, align:'center', search:false},
                {name:'idDocumentType',index:'docType', sorttype:'string', width:20, align:'center', search:false},
                {name:'document', index:'pe.document', width:20,searchoptions:{clearSearch: false,sopt:['cn']}, sortable: true, sorttype:'number'},
                {name:'telephone', index:'pe.telephone', sorttype:'text', width:20,searchoptions:false},
                {name:'firstLastName', index:'pe.firstLastName', width:45,searchoptions:{clearSearch: false,sopt:['cn']},sorttype:'text'},
                {name:'roomName', index:'roc.roomName', sorttype:'text', width:15, stype:"select", searchoptions:{ clearSearch: false, sopt:['eq'], value:Room,defaultValue:RoomD}},
                {name:'varMod', index:'mod.idModality', sorttype:'text', width:15, stype:"select", searchoptions:{ clearSearch: false, sopt:['eq'], value:modalities,defaultValue:modalityD}},
                {name:'studyName', index:'stc.studyName', sorttype:'text', width:40,searchoptions:{clearSearch: false,sopt:['cn']}},
                {name:'eps', index:'eps.name', sorttype:'text', width:15, stype:"select", searchoptions:{clearSearch: false,value:eps,defaultValue:epsD}},
                {name:'varHead', index:'he.headquarterName', stype:"select", width:25, searchoptions:{clearSearch: false,value:Headquart,defaultValue:HeadquartD}},
                {name:'appointmentStatus', index:'A.appointmentStatus',  sorttype:'string', width:30, align:'center', search:false},
                {name:'appointmentCode', index:'appCodeSchedule',  sorttype:'string', width:20, align:'center', search:false}

            ]
            , colNames: ["{{ 'Query.appointment.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'schedule.hour_init'|trans([], 'LocalizationBundle') }}:",
                "{{ 'schedule.duration'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.typeDocument.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.ID.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.telephone.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.patient.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'receive.room'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.mod.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'WorkslitResult.study.plural'|trans([], 'LocalizationBundle') }}:",
                "{{ 'utilities.agreement'|trans([], 'LocalizationBundle') }}:",
                "{{ 'assistive.headquarters.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.state.label'|trans([], 'LocalizationBundle') }}:",
                "{{ 'Query.appointmentCode.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",
            toppager:true,
            caption: '{{ 'Menu.appointmentSchedule'|trans([], 'LocalizationBundle') }}'

        });
        jQuery("#grid").jqGrid('setFrozenColumns');
        $('#gs_dateStart').datepicker();
        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!=''){
                    RemoveSessions(url_removeS,session_data.slice(0, -1));

                }

            },
            position: 'last'
        });
        jQuery("#grid").jqGrid('filterToolbar',{stringResult: true, searchfield:true, searchOnEnter: false, defaultSearch: 'cn', autosearch:true});
        $("#grid").jqGrid ('setLabel', 'Name', '', {'text-align':'right'});
        $("#grid").jqGrid('getGridParam', 'rowNum') == 'ALL';
        $('#grid').setGridParam({datatype: 'json', url:'{{ path('_grid_schedule_appointment_data') }}'});
        $('#grid')[0].triggerToolbar();
        setInterval('refresh()', parseInt({{ refresh_timer }})*1000);
        $('#gs_roomName').change(function(){
            setSession(url_data,'scheduleAppGrid','room', $(this).val());
        });
        $('#gs_varMod').change(function(){
            setSession(url_data,'scheduleAppGrid','modality', $(this).val());
        });
        $('#gs_varHead').change(function(){
            setSession(url_data,'scheduleAppGrid','headquarter', $(this).val());
        });
        $('#gs_eps').change(function(){
            setSession(url_data,'scheduleAppGrid','eps', $(this).val());
        });
        $('#gs_dateStart').change(function (dateText, inst) {
            setSession(url_data,'scheduleAppGrid','date', $('#gs_dateStart').val());
            setTimeout(function () {
                $('#grid')[0].triggerToolbar();
            }, 100);
        });
        
        setInterval('refresh()', parseInt({{ refresh_timer }})*1000);
    });

    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:20px; ">
            <table id="grid" ></table>
            <div id="pager" ></div>
        </div>

    </section>
{% endblock %}