Proyectos de Subversion LeadersLinked - Backend

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

$roleName = $currentUser->getUserTypeId();


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

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


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

$this->inlineScript()->appendFile($this->basePath('assets/vendors/bootstrap-maxlength/bootstrap-maxlength.min.js'));






$this->headLink()->appendStylesheet($this->basePath('assets/vendors/datatables.net-bs5/dataTables.bootstrap5.css'));
$this->headLink()->appendStylesheet($this->basePath('assets/vendors/datatables.net-bs5-responsive/responsive.bootstrap5.css'));

$this->inlineScript()->appendFile($this->basePath('assets/vendors/datatables.net/jquery.dataTables.js'));
$this->inlineScript()->appendFile($this->basePath('assets/vendors/datatables.net-bs5/dataTables.bootstrap5.js'));
$this->inlineScript()->appendFile($this->basePath('assets/vendors/datatables.net-bs5-responsive/dataTables.responsive.min.js'));
$this->inlineScript()->appendFile($this->basePath('assets/vendors/datatables.net-bs5-responsive/responsive.bootstrap5.min.js'));


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




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

$this->headLink()->appendStylesheet($this->basePath('assets/vendors/select2-bootstrap5-theme/select2-bootstrap-5-theme.css'));

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

// bootbox Alert //



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

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


   

    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();
            
        },
        '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' : '';
                    return '<div class="form-check">' +
                        '<input type="checkbox" class="form-check-input" disabled="" ' + checked + '>' +
                        '<label class="form-check-label" for="checkCheckedDisabled"></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-pen"></i> LABEL_EDIT </button>&nbsp;';
                    }
                    if (allowDelete) {
                        s = s + '<button class="btn btn-danger btn-delete" data-href="' + data['link_delete'] + '" data-toggle="tooltip" 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': {
                maxlength: 512,
                required: true,
            },
            'status': {
                required: false,
            },

        },
        submitHandler: function(form) {
            if ($('input[type="hidden"].behavior_id').length == 0) {
                $.fn.showError('ERROR_NOT_OBSERVABLE_BEHAVIOR');
                return false;
            } 
                $.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();
                });
      

        },
        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
                    }));
                });

               
                
                $('#form').attr('action', '$routeAdd');
                $('#form #name').val('');
                $('#form #competency_type_id').val('').trigger('change');
                $('#form #status').bootstrapToggle('on');
                 $('#form #description').val('');

                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();

        NProgress.start();
        var action = $(this).data('href');
        $.ajax({
            'dataType': 'json',
            'method': 'get',
            'url': action,
        }).done(function(response) {
            if (response['success']) {
                
                $('#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')
                $('#form #description').val(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-delete', function(e) { 
        e.preventDefault();
        var action = $(this).data('href');


          swal.fire({
            title: 'LABEL_ARE_YOU_SURE',
            icon: 'question',
            cancelButtonText: 'LABEL_NO',
            showCancelButton: true,
            confirmButtonText: 'LABEL_YES'
          }).then((result) => {
            if (result.isConfirmed) {

                    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();
                    });
            }
       });
    });
    

    $('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: 'bootstrap-5',
        width: '100%',
    });

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

    $('#form #status').bootstrapToggle({
        'on': 'LABEL_ACTIVE',
        'off': 'LABEL_INACTIVE',
        'width': '160px',
        'height': '40px'
    });

    $('#form #description').maxlength({
        alwaysShow: true,
        validate: true
    });



    $('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; 

    });

    $('#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 ;
        var element     = $(key)

        if(element.length > 0) {
            $.fn.showError( 'ERROR_BEHAVIOR_WAS_PREVIOUSLY_ADDED');
            return false;
        }


        if(description.length > 50) {
           description = description.substr(0, 50) + '...';
        }

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

        return false;

        

    });

  

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

    


});

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

<div class="container">
        <div class="card" id="row-list">
                
                <div class="card-body">
                        <h6 class="card-title">LABEL_COMPETENCIES</h6>
                        <div class="row">
                         <div class="col-12 mt-3">
                         <table id="gridTable" class="table   table-bordered">
                            <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>
                </div>
                <div class="card-footer text-right">
                            <button type="button" class="btn btn-info btn-refresh"><i class="fa fa-sync"></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 class="card" id="row-form" style="display: none">
                                        <?php
                        $form = $this->form;
                        $form->setAttributes([
                            'method'    => 'post',
                            'name'      => 'form',
                            'id'        => 'form'
                        ]);

                        $form->prepare();
                        echo $this->form()->openTag($form);
                        ?>
                <div class="card-body">
                        <h6 class="card-title">LABEL_COMPETENCIES</h6>
                        <div class="row">
                         <div class="col-12 mt-3">
                                        <?php
                                    $element = $form->get('competency_type_id');
                                    $element->setOptions(['label' => 'LABEL_TYPE']);

                                    echo $this->formLabel($element);
                                    echo $this->formSelect($element);
                                    ?>
                        </div>
                </div>
                        <div class="row">
                         <div class="col-12 mt-3">
                                    <?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="row">
                         <div class="col-12 mt-3">
                                    <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="row">
                         <div class="col-12 mt-3">
                                    <?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="row">
                         <div class="col-8 mt-3">
                                        <select name="select-behavior" id="select-behavior" >
                                <option value="">LABEL_SELECT</option>
                        </select>
                        </div>
                        <div class="col-4 mt-3">
                        <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 class="row">
                         <div class="col-12 mt-3">
                            <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>
                </div>
         </div> 
                <div class="card-footer text-right">
                      <button type="submit" form="form" class="btn btn-primary">LABEL_SAVE</button>
                <button type="button" class="btn btn-light btn-cancel">LABEL_CANCEL</button>
                </div>
                <?php echo $this->form()->closeTag($form); ?>
        </div>
</div>





<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>