Proyectos de Subversion LeadersLinked - Backend

<?php

$acl            = $this->viewModel()->getRoot()->getVariable('acl');

$currentUser    = $this->currentUserHelper();

$roleName = $currentUser->getUserTypeId();

$routeDatatable = $this->url('habits/progress');

$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/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'));

$columns = "var columns = new Array(); \r\n";

$columns .= "columns[0] = 'date'; \r\n";

$i = 1;

foreach($categories as $category_id => $category_name)

{

    $columns .= "columns[$i] = 'cat_{$category_id}'; \r\n";

    $i++;

}

$columns .= "columns[$i] = 'content'; \r\n";

$this->inlineScript()->captureStart();

echo <<<JS

    jQuery( document ).ready(function( $ ) {

        $columns

        var page = 1;

        var maxPage = 1;

        $.fn.loadRecords = function() {

            NProgress.start();

                $.ajax({

                    'dataType'  : 'json',

                    'accept'    : 'application/json',

                    'method'    : 'get',

                    'url'       : '$routeDatatable',

                    'data'      :  {

                        'id' :  $('#form-filter #user_id').val(),

                        'page' : page

                    }

                }).done(function(response) {

                    if(response['success']) {

                        total = parseInt(response['data']['total'])

                        maxPage = total / 10;

                        if(maxPage * 10 < total) {

                            maxPage++;

                        }

                        if(page >= maxPage) {

                            $('button.btn-load-more').hide();

                        } else {

                            $('button.btn-load-more').show();

                        }

                        response['data']['items'].forEach(function(item)  {

                            var s = '<tr>';

                            columns.forEach(function(column)  {

                                s += '<td>' + item[column] + '</td>';

                            });

                            console.log(s)

                            $('#gridTable tbody').append(s)

                        });

                    } else {

                        $.fn.showError(response['data']);

                    }

                }).fail(function( jqXHR, textStatus, errorThrown) {

                   $.fn.showError(textStatus);

                }).always(function() {

                    NProgress.done();

                });

            return false;

        }

        $('body').on('click', 'button.btn-load-more', function(e) {

            e.preventDefault();

            page = page + 1;

            $.fn.loadRecords();

        });

        $('#form-filter #user_id').change(function(e) {

            e.preventDefault();

            $('#gridTable tbody').empty();

            page = 1;

            maxPage = 1;

            $.fn.loadRecords();

        });

        $('#form-filter #user_id').select2({

            theme: 'bootstrap-5',

            width: '100%',

           //dropdownParent: $('#modal'),

        });

        $.fn.loadRecords();

    });

JS;

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

?>

<div class="container">

	<div class="card">

		<div class="card-header">

   			<h6 class="card-title">LABEL_PROGRESS</h6>

   		</div>

		<div class="card-body">

			<form name="form-filter" id="form-filter">

			<div class="row">

  				<div class="col mt-3">

  					<label for="user_id" class="form-label">LABEL_USER</label>

  					<select name="user_id" id="user_id" class="form-control">

  					<?php foreach($users as $key => $value ) : ?>

  					<option value="<?php echo $key ?>"><?php echo $value ?></option>

  					<?php endforeach; ?>

  					</select>

  				</div>

  			</div>

  			</form>

			<div class="row">

  				<div class="col mt-3">

                  	<table id="gridTable" class="table  table-bordered">

                 		<thead>

                   			<tr>

                           		<th>LABEL_DATE</th>

                           		<?php foreach($categories as $category_id => $category_name) : ?>

                          		<th><?php echo $category_name ?></th>

                          		<?php endforeach; ?>

                            	<th>LABEL_CONTENT</th>

                            </tr>

                  		</thead>

                      	<tbody>

                      	</tbody>

                 	</table>

                 </div>

             </div>

         </div>

    	 <div class="card-footer text-right">

			<button type="button" style="display: none" class="btn btn-info btn-load-more"><i class="fa fa-sync"></i> LABEL_LOAD_MORE </button>

		</div>

 	</div>

</div>