Proyectos de Subversion LeadersLinked - Backend

<?php
$acl            = $this->viewModel()->getRoot()->getVariable('acl');
$currentUser    = $this->currentUserHelper();

$roleName = $currentUser->getUserTypeId();


$routeAdd       = $this->url('settings/competencies/add');
$routeDatatable = $this->url('settings/competencies');
$routeImport    = $this->url('settings/competencies/import');

$allowAdd       = $acl->isAllowed($roleName, 'settings/competencies/add') ? 1 : 0;
$allowEdit      = $acl->isAllowed($roleName, 'settings/competencies/edit') ? 1 : 0;
$allowDelete    = $acl->isAllowed($roleName, 'settings/competencies/delete') ? 1 : 0;
$allowImport    = $acl->isAllowed($roleName, 'settings/competencies/import') ? 1 : 0;

$allowBehaviorAdd = $acl->isAllowed($roleName, 'settings/behaviors/add') ? 1 : 0;
$routeBehaviorAdd = $this->url('settings/behaviors/add');



$this->headLink()->appendStylesheet($this->basePath('plugins/nprogress/nprogress.css'));
$this->inlineScript()->appendFile($this->basePath('plugins/nprogress/nprogress.js'));

$this->inlineScript()->appendFile($this->basePath('plugins/ckeditor/ckeditor.js'));


$this->inlineScript()->appendFile($this->basePath('plugins/jquery-validation/jquery.validate.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/jquery-validation/additional-methods.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/jquery-validation/localization/messages_es.js'));

$this->headLink()->appendStylesheet($this->basePath('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css'));
$this->headLink()->appendStylesheet($this->basePath('plugins/datatables-responsive/css/responsive.bootstrap4.min.css'));

$this->inlineScript()->appendFile($this->basePath('plugins/datatables/jquery.dataTables.min.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/datatables-responsive/js/dataTables.responsive.min.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/datatables-responsive/js/responsive.bootstrap4.min.js'));


$this->headLink()->appendStylesheet($this->basePath('plugins/bootstrap4-toggle/css/bootstrap4-toggle.min.css'));
$this->inlineScript()->appendFile($this->basePath('plugins/bootstrap4-toggle/js/bootstrap4-toggle.min.js'));

$this->inlineScript()->appendFile($this->basePath('plugins/bootstrap-confirmation/dist/bootstrap-confirmation.js'));
$this->headLink()->appendStylesheet($this->basePath('plugins/bootstrap-checkbox/awesome-bootstrap-checkbox.css'));

$this->inlineScript()->appendFile($this->basePath('plugins/select2/js/select2.js'));
$this->inlineScript()->appendFile($this->basePath('plugins/select2/js/i18n/es.js'));
$this->headLink()->appendStylesheet($this->basePath('plugins/select2/css/select2.css'));

$this->headLink()->appendStylesheet($this->basePath('plugins/select2-bootstrap4-theme/select2-bootstrap4.css'));

// JsRender //
$this->inlineScript()->appendFile($this->basePath('plugins/jsrender/jsrender.min.js'));

// bootbox Alert //
$this->inlineScript()->appendFile($this->basePath('plugins/bootbox/bootbox.min.js'));


$status_active = \LeadersLinked\Model\Competency::STATUS_ACTIVE;

$this->inlineScript()->captureStart();
echo <<<JS
jQuery(document).ready(function($) {
    var allowEdit = $allowEdit;
    var allowDelete = $allowDelete;

    $.validator.setDefaults({
        debug: true,
        highlight: function(element) {
            $(element).addClass('is-invalid');
        },
        unhighlight: function(element) {
            $(element).removeClass('is-invalid');
        },
        errorElement: 'span',
        errorClass: 'error invalid-feedback',
            errorPlacement: function(error, element) {
                if(element.parent('.form-group').length) {
                    error.insertAfter(element);
                } else if(element.parent('.toggle').length) {
                    error.insertAfter(element.parent().parent());
                } else {
                    error.insertAfter(element.parent());
                }
            }
    });

    $.fn.showFormErrorValidator = function(fieldname, errors) {
        var field = $(fieldname);
        if (field) {
            $(field).addClass('is-invalid');
            var error = $('<span id="' + fieldname + '-error" class="error invalid-feedback">' + errors + '</div>');
                if(field.parent('.form-group').length) {
                    error.insertAfter(field);
                } else  if(field.parent('.toggle').length) {
                    error.insertAfter(field.parent().parent());
                } else {
                    error.insertAfter(field.parent());
                }
        }
    };

    var gridTable = $('#gridTable').dataTable({
        'processing': true,
        'serverSide': true,
        'searching': true,
        'order': [
            [0, 'asc']
        ],
        'ordering': true,
        'ordenable': true,
        'responsive': true,
        'select': false,
        'paging': true,
        'pagingType': 'simple_numbers',
        'ajax': {
            'url': '$routeDatatable',
            'type': 'get',
            'beforeSend': function(request) {
                NProgress.start();
            },
            'dataFilter': function(response) {
                var response = jQuery.parseJSON(response);
                var json = {};
                json.recordsTotal = 0;
                json.recordsFiltered = 0;
                json.data = [];
                if (response.success) {
                    json.recordsTotal = response.data.total;
                    json.recordsFiltered = response.data.total;
                    json.data = response.data.items;
                } else {
                    $.fn.showError(response.data)
                }
                return JSON.stringify(json);
            }
        },
        'language': {
            'sProcessing': 'LABEL_DATATABLE_SPROCESSING',
            'sLengthMenu': 'LABEL_DATATABLE_SLENGTHMENU',
            'sZeroRecords': 'LABEL_DATATABLE_SZERORECORDS',
            'sEmptyTable': 'LABEL_DATATABLE_SEMPTYTABLE',
            'sInfo': 'LABEL_DATATABLE_SINFO',
            'sInfoEmpty': 'LABEL_DATATABLE_SINFOEMPTY',
            'sInfoFiltered': 'LABEL_DATATABLE_SINFOFILTERED',
            'sInfoPostFix': '',
            'sSearch': 'LABEL_DATATABLE_SSEARCH',
            'sUrl': '',
            'sInfoThousands': ',',
            'sLoadingRecords': 'LABEL_DATATABLE_SLOADINGRECORDS',
            'oPaginate': {
                'sFirst': 'LABEL_DATATABLE_SFIRST',
                'sLast': 'LABEL_DATATABLE_SLAST',
                'sNext': 'LABEL_DATATABLE_SNEXT',
                'sPrevious': 'LABEL_DATATABLE_SPREVIOUS'
            },
            'oAria': {
                'sSortAscending': ': LABEL_DATATABLE_SSORTASCENDING',
                'sSortDescending': ':LABEL_DATATABLE_SSORTDESCENDING'
            },
        },
        'drawCallback': function(settings) {
            NProgress.done();
            $('button.btn-delete').confirmation({
                rootSelector: 'button.btn-delete',
                title: 'LABEL_ARE_YOU_SURE',
                singleton: true,
                btnOkLabel: 'LABEL_YES',
                btnCancelLabel: 'LABEL_NO',
                onConfirm: function(value) {
                    action = $(this).data('href');
                    NProgress.start();
                    $.ajax({
                        'dataType': 'json',
                        'accept': 'application/json',
                        'method': 'post',
                        'url': action,
                    }).done(function(response) {
                        if (response['success']) {
                            $.fn.showSuccess(response['data']);
                            gridTable.api().ajax.reload(null, false);
                        } else {
                            $.fn.showError(response['data']);
                        }
                    }).fail(function(jqXHR, textStatus, errorThrown) {
                        $.fn.showError(textStatus);
                    }).always(function() {
                        NProgress.done();
                    });
                }
            });
        },
        'aoColumns': [{
                'mDataProp': 'type'
            },
            {
                'mDataProp': 'name'
            },
            {
                'mDataProp': 'status'
            },
            {
                'mDataProp': 'actions'
            },
        ],
        'columnDefs': [{
                'targets': 0,
                'className': 'text-vertical-middle',
            },
            {
                'targets': 1,
                'className': 'text-vertical-middle',
            },
            {
                'targets': -2,
                'orderable': false,
                'className': 'text-center',
                'render': function(data, type, row) {
                    checked = data == 'a' ? ' checked="checked" ' : '';
                    return '<div class="checkbox checkbox-success">' +
                        '<input class="styled" type="checkbox" ' + checked + ' disabled="disabled">' +
                        '<label ></label></div>';
                }
            },
            {
                'targets': -1,
                'orderable': false,
                'render': function(data, type, row) {
                    s = '';
                    if (allowEdit) {
                        s = s + '<button class="btn btn-primary btn-edit" data-href="' + data['link_edit'] + '" data-toggle="tooltip" title="LABEL_EDIT"><i class="fa fa-pencil"></i> LABEL_EDIT </button>&nbsp;';
                    }
                    if (allowDelete) {
                        s = s + '<button class="btn btn-danger btn-delete" data-href="' + data['link_delete'] + '" data-toggle="delete-confirmation" data-popout="true" title="LABEL_DELETE"><i class="fa fa-trash"></i> LABEL_DELETE </button>&nbsp;';
                    }
                    return s;
                }
            }
        ],
    });

    var validator = $('#form').validate({
        debug: true,
        onclick: false,
        onkeyup: false,
        ignore: [],
        rules: {
            'competency_type_id': {
                required: true,
            },
            'name': {
                required: true,
                maxlength: 128,
            },
            'description': {
                updateCkeditor: function() {
                    CKEDITOR.instances.description.updateElement();
                },
                required: true,
            },
            'status': {
                required: false,
            },

        },
        submitHandler: function(form) {
            if ($('input[type="hidden"].behavior_id').length == 0) {
                $.fn.showError('ERROR_NOT_OBSERVABLE_BEHAVIOR');
            } else {
                $.ajax({
                    'dataType': 'json',
                    'accept': 'application/json',
                    'method': 'post',
                    'url': $('#form').attr('action'),
                    'data': $('#form').serialize(),
                }).done(function(response) {
                    NProgress.start();
                    if (response['success']) {
                        $.fn.showSuccess(response['data']);
                        $('#row-form').hide();
                        $('#row-list').show();
                        gridTable.api().ajax.reload(null, false);
                    } else {
                        validator.resetForm();
                        if (jQuery.type(response['data']) == 'string') {
                            $.fn.showError(response['data']);
                        } else {
                            $.each(response['data'], function(fieldname, errors) {
                                $.fn.showFormErrorValidator('#form #' + fieldname, errors);
                            });
                        }
                    }
                }).fail(function(jqXHR, textStatus, errorThrown) {
                    $.fn.showError(textStatus);
                }).always(function() {
                    NProgress.done();
                });
            }
            return false;
        },
        invalidHandler: function(form, validator) {}
    });

    $('body').on('click', 'button.btn-add', function(e) {
        e.preventDefault();
        NProgress.start();


        $.ajax({
            'dataType': 'json',
            'method': 'get',
            'url': '$routeAdd',
        }).done(function(response) {
            if (response['success']) {

                $('#table-behaviors tbody').empty();
                
                $('#select-behavior').children().not(':first').remove();
                $.each(response['data']['behaviors'], function(index, element) {
                    $('#select-behavior').append($('<option>', {
                        value: element.id,
                        text: element.description
                    }));
                });

               
                $('span[id="form-title"]').html('LABEL_ADD');
                $('#form').attr('action', '$routeAdd');
                $('#form #name').val('');
                $('#form #competency_type_id').val('').trigger('change');
                $('#form #competency_type_id').val('').trigger('change');
                $('#form #status').bootstrapToggle('on');
                CKEDITOR.instances.description.setData('');

                validator.resetForm();

                $('#row-form').show();
                $('#row-list').hide();
            } else {
                $.fn.showError(response['data']);
            }
        }).fail(function(jqXHR, textStatus, errorThrown) {
            $.fn.showError(textStatus);
        }).always(function() {
            NProgress.done();
        });




        return false;
    });

    $('body').on('click', 'button.btn-edit', function(e) {
        e.preventDefault();
        $("button.btn-delete").confirmation('hide');
        NProgress.start();
        var action = $(this).data('href');
        $.ajax({
            'dataType': 'json',
            'method': 'get',
            'url': action,
        }).done(function(response) {
            console.log(response)
            if (response['success']) {
                $('span[id="form-title"]').html('LABEL_EDIT');
                $('#form').attr('action', action);
                $('#form #name').val(response['data']['name']);
                $('#form #competency_type_id').val(response['data']['competency_type_id']).trigger('change');
                $('#form #status').bootstrapToggle(response['data']['status'] == '$status_active' ? 'on' : 'off')
                CKEDITOR.instances.description.setData(response['data']['description']);


                $('input[type="hidden"].behavior').remove();
                $('#select-behavior').children().not(':first').remove();
                

                $('#table-behaviors tbody').empty();

                $.each(response['data']['behaviors'], function(index, element) {
                    $('#select-behavior').append($('<option>', {
                        value: element.id,
                        text: element.description
                    }));

                    if(element.checked ) {
                        let data = {
                            id : element.id, 
                            description : element.description,
                        };
                            
                        $('#table-behaviors tbody').append(
                            $('#trBehaviorTemplate').render( data )
                        );


                    }
                 });

               
                

                validator.resetForm();
                $('#row-form').show();
                $('#row-list').hide();
            } else {
                $.fn.showError(response['data']);
            }
        }).fail(function(jqXHR, textStatus, errorThrown) {
            $.fn.showError(textStatus);
        }).always(function() {
            NProgress.done();
        });
        return false;
    });

    $('body').on('click', 'button.btn-refresh', function(e) {
        e.preventDefault();
        gridTable.api().ajax.reload(null, false);
        return false;
    });

    $('body').on('click', 'button.btn-import', function(e) {
        e.preventDefault();
        NProgress.start();
        $.ajax({
            'dataType': 'json',
            'method': 'post',
            'url': '$routeImport',
        }).done(function(response) {
            if (response['success']) {
                $.fn.showSuccess(response['data']);
                gridTable.api().ajax.reload(null, false);
            } else {
                $.fn.showError(response['data']);
            }
        }).fail(function(jqXHR, textStatus, errorThrown) {
            $.fn.showError(textStatus);
        }).always(function() {
            NProgress.done();
        });
        return false;
    });

    $('body').on('click', 'button.btn-cancel', function(e) {
        e.preventDefault();
        $('#row-form').hide();
        $('#row-list').show();
    });

    $('#form #competency_type_id').select2({
        theme: 'bootstrap4',
        width: '100%',
    });

    $('#select-behavior').select2({
        theme: 'bootstrap4',
        width: '100%',
    });

    $('#form #status').bootstrapToggle({
        'on': 'LABEL_ACTIVE',
        'off': 'LABEL_INACTIVE',
        'width': '160px',
        'height': '40px'
    });
    CKEDITOR.replace('description', {
        toolbar: [
            { name: 'editing', items: [ 'Scayt' ] },
            { name: 'links', items: [ 'Link', 'Unlink'] },
            { name: 'paragraph', items: [ 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', 'Blockquote' ] },
            { name: 'basicstyles', items: [ 'Bold', 'Italic', 'Strike', 'RemoveFormat' ] },
            '/',
            { name: 'insert', items: [ 'Image', 'Table', 'HorizontalRule', 'SpecialChar' ] },
            { name: 'styles', items: [ 'Styles', 'Format' ] },
            { name: 'tools', items: [ 'Maximize' ] }
        ],
        removePlugins: 'elementspath,Anchor',
        heigth: 100
    });


    $('body').on('click', 'button.btn-remove-behavior', function(e) {
        e.preventDefault();
        
        var key = '#tr_behavior_id_' + $(this).data('id');
        var element = $(key);
        if(element) {
            $(element).remove();
        }

        return false; 
        


        
       
        /*
        bootbox.confirm({
            title: "LABEL_DELETE LABEL_CONDUCT",
            message: "LABEL_QUESTION_DELETE",
            buttons: {
                cancel: {
                    label: '<i class="fa fa-times"></i> LABEL_CANCEL'
                },
                confirm: {
                    label: '<i class="fa fa-check"></i> LABEL_ACCEPT'
                }
            },
            callback: function(result) {
                if (result) {
                    removeBehavior(id);
                }
            }
        });*/
    });

    $('#btn-select-behavior').click(function(e) {
        e.preventDefault();

        var id  = $('#select-behavior option:selected').val(); 
        
        if(!id) {
            return false;
        }

        var description = $('#select-behavior option:selected').text();
        var key         = '#tr_behavior_id_' + id ;

        console.log("key = "  + key);
        var element     = $(key);


        console.log(element);
        if(element.length > 0) {

            $.fn.showError( 'ERROR_BEHAVIOR_WAS_PREVIOUSLY_ADDED');
            return false;
        }

        let data = {
            id : id, 
            description : description,
        };
            
        $('#table-behaviors tbody').append(
            $('#trBehaviorTemplate').render( data )
        );

        return false;

        

    });

  

    $('button.btn-edit-cancel').click(function(e) {
        e.preventDefault();
        $('#row-form').hide();
        $('#row-list').show();
    });

    


});

JS;
$this->inlineScript()->captureEnd();
?>

<!-- Content Header (Page header) -->
<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-12">
                <h1>LABEL_COMPETENCIES</h1>
            </div>
        </div>
    </div>
    <!-- /.container-fluid -->
</section>
<section class="content" id="row-list">
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <table id="gridTable" class="table   table-hover">
                            <thead>
                                <tr>
                                    <th>LABEL_TYPE</th>
                                    <th>LABEL_NAME</th>
                                    <th>LABEL_ACTIVE</th>
                                    <th>LABEL_ACTIONS</th>
                                </tr>
                            </thead>
                            <tbody>
                            </tbody>
                        </table>
                    </div>
                    <div class="card-footer clearfix">
                        <div style="float:right;">
                            <button type="button" class="btn btn-info btn-refresh"><i class="fa fa-refresh"></i> LABEL_REFRESH </button>
                            <?php if ($allowImport) : ?>
                                <button type="button" class="btn btn-primary btn-import"><i class="fa fa-upload"></i> LABEL_IMPORT </button>
                            <?php endif; ?>
                            <?php if ($allowAdd) : ?>
                                <button type="button" class="btn btn-primary btn-add"><i class="fa fa-plus"></i> LABEL_ADD </button>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<!-- The Form creation -->
<section class="content" id="row-form" style="display: none">
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12 col-sm-12 col-12">
                <div class="panel">
                    <div class="panel-body">
                        <?php
                        $form = $this->form;
                        $form->setAttributes([
                            'method'    => 'post',
                            'name'      => 'form',
                            'id'        => 'form'
                        ]);

                        $form->prepare();
                        echo $this->form()->openTag($form);
                        ?>
                        <div class="row">
                            <div class="col-md-4 col-sm-12 col-12">
                                <div class="from-group">
                                    <?php
                                    $element = $form->get('competency_type_id');
                                    $element->setOptions(['label' => 'LABEL_TYPE']);

                                    echo $this->formLabel($element);
                                    echo $this->formSelect($element);
                                    ?>
                                </div>
                            </div>
                            <div class="col-md-4 col-sm-12 col-12">
                                <div class="from-group">
                                    <?php
                                    $element = $form->get('name');
                                    $element->setOptions(['label' => 'LABEL_NAME']);
                                    $element->setAttributes(['class' => 'form-control']);

                                    echo $this->formLabel($element);
                                    echo $this->formText($element);
                                    ?>
                                </div>
                            </div>
                            <div class="col-md-4 col-sm-12 col-12">
                                <div class="from-group">
                                    <label>LABEL_STATUS</label>
                                    <br />
                                    <?php
                                    $element = $form->get('status');
                                    $element->setOptions(['label' => 'LABEL_STATUS']);
                                    // echo $this->formLabel($element);
                                    echo $this->formCheckbox($element);
                                    ?>
                                </div>
                            </div>
                            <div class="col-md-12 col-sm-12 col-12">
                                <div class="form-group">
                                    <?php
                                    $element = $form->get('description');
                                    $element->setOptions(['label' => 'LABEL_DESCRIPTION']);
                                    $element->setAttributes(['class' => 'form-control']);

                                    echo $this->formLabel($element);
                                    echo $this->formTextArea($element);
                                    ?>
                                </div>
                            </div>
                           
                            <div class="col-md-12 col-sm-12 col-12">
                                <div class="form-group">
                                    <div class="row">
                                        <div class="col-md-8 col-sm-8 col-xs-12">
                                            <select name="select-behavior" id="select-behavior" >
                                                        <option value="">LABEL_SELECT</option>
                                            </select>
                                        </div>
                                        <div class="col-md-4 col-sm-4 col-xs-12">
                                            <button type="button" class="btn btn-primary" id="btn-select-behavior" data-toggle="tooltip" title="LABEL_ADD LABEL_BEHAVIOR">LABEL_ADD LABEL_BEHAVIOR</button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-xs-12 col-md-12">
                            <br />
                            <div class="table-responsive">
                                <table id="table-behaviors" class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="width: 60%;">LABEL_DESCRIPTION</th>
                                            <th style="width: 20%;">LABEL_ACTIONS</th>
                                        </tr>
                                    </thead>
                                    <tbody >
                                    </tbody>
                                </table>
                            </div>
                            <div class="col-xs-12 col-md-12 text-right">
                        
                                    <button type="submit" form="form" class="btn btn-primary">LABEL_SAVE</button>
                                    <button type="button" class="btn btn-secondary btn-edit-cancel">LABEL_CANCEL</button>
                 
                            </div>
                        </div>
                         <?php echo $this->form()->closeTag($form); ?>
                    </div>
                </div>
            </div>
        </div>
</section>

<script id="trBehaviorTemplate" type="text/x-jsrender">
    <tr id="tr_behavior_id_{{:id}}">
        
       <td class="text-left">
         <input type="hidden" class="behavior_id" name="behavior_id[]" value="{{:id}}" />      
         {{:description}}
       </td>   
       <td>
           <button class="btn btn-default btn-remove-behavior" data-id="{{:id}}" data-toggle="tooltip"  data-original-title="LABEL_DELETE"><i class="fa fa-ban" aria-hidden="true"></i> LABEL_DELETE</button>   
       </td>
   </tr>
</script>