@extends('layouts.app')
@section('title', session('company_code') . ' Elite System')

@section('header')
Dashboard
@endsection

@section('body')
<div class="box box-default">
	<div class="box-body">
        <div class="row">
            <div class="col-xs-12">
                <label class="text-primary" style="font-size:16px; margin-top:6px"><i class="fa fa-fw fa-database"></i> Database Back-ups</label>
            </div>
        </div>
        <hr style="margin-top:6px; margin-bottom:8px">
  		<div class="row">
    		<div class="col-xs-12">
                <table class="table table-condensed table-hover" id="table-data">
                    <thead class="table-header-bg">
                        <tr>
                            <th width="30%">FILE NAME</th>
                            <th width="20%" class="text-left">FILE SIZE</th>
                            <th width="15%" class="text-left">LAST MODIFIED</th>
                            <th width="15%" class="text-left">UPLOADED</th>
                            <th width="20%" class="text-right">&nbsp;</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
    		</div>
	  	</div>
	</div>
</div>
@endsection

@section('scripts')
<script type="text/javascript">
    $(document).on('ready', function() {
        $dt = $('#table-data').DataTable({
            deferred: true,
            processing: true,
            serverSide: true,
            ajax: {
                url: $app_url + '/backups/dumps/dt',
            },
            columns: [
                { data:'file_name',             name:'sb.file_name',            orderable:false,   className:"text-uppercase" },
                { data:'file_size',             name:'sb.file_size',            orderable:false,   className:"text-left" },
                { data:'file_last_modified',    name:'sb.file_last_modified',   orderable:false,   className:"text-left" },
                { data:'upload_status',         name:'sb.upload_status',        orderable:false,   className:"text-left" },
                { data:'action',                name:'action',                  orderable:false,   className:"text-right",         searchable:false }
            ]
        });

        $('#table-data_filter input').unbind();
        $('#table-data_filter input').bind('keyup', function(e) {
            if(e.keyCode == 13) {
                $dt.search($(this).val()).draw();
            }
        });

        $('#table-data_filter input').unbind();
        $('#table-data_filter input').bind('keyup', function(e) {
            if(e.keyCode == 13) {
                $dt.search($(this).val()).draw();
            }
        });

        $('#filter-by-category').change(function() {
            $dt.search($('#table-data_filter input').val()).draw();
        });

        $('#filter-by-status').change(function() {
            $dt.search($('#table-data_filter input').val()).draw();
        });

        $('input[type="search"]').focus();
    }).on('click', '.btn-download-file', function() {
        window.location.href = $app_url + '/backups/dumps/download?fn=' + $(this).data('filename');
    }).on('click', '.btn-upload-file', function() {
        $filename = $(this).data('filename');

        $jc = $.confirm({
            title: false,
            draggable: true,
            columnClass: 'small',
            content:'<p class="text-center"><i class="fa fa-cloud-upload text-bold text-primary" style="font-size:54px"></i></p>' +
                    '<p class="text-center">Continue uploading the backup: <b>'+$filename+'</b>? This process may take a while depending on the size of the backup.</p>',
            buttons: {
                CANCEL: {
                    btnClass:'btn btn-default',
                    text: '<small>[ESC]</small> CANCEL',
                    keys: ['esc']
                },
                UPLOAD: {
                    btnClass: 'btn btn-primary',
                    text: '<small>[ENTER]</small> UPLOAD',
                    keys: ['enter'],
                    action: function() {
                        $.ajax({
                            url: $app_url + '/backups/dumps/upload',
                            type: 'post',
                            data: {
                                'filename': $filename,
                            },
                            beforeSend: function() {
                                $jc.showLoading(true);
                            },
                            success: function(data) {
                                $jc.close();
                                $.confirm({
                                    draggable: true,
                                    title: false,
                                    type: 'blue',
                                    content: '<p class="text-center"><i class="fa fa-fw fa-check text-bold text-primary" style="font-size:54px"></i></p>' +
                                            "<p class='text-center'>Backup was successfully uploaded.</p>",
                                    buttons: {
                                        yes: {
                                            text: '<small>[ENTER]</small> got it!',
                                            btnClass: 'btn-primary',
                                            keys: ['enter'],
                                            action: function() {
                                               $dt.draw();
                                            }
                                        }
                                    }
                                });
                            },
                            error: function(result) {
                                $.confirm({
                                    draggable: true,
                                    title: false,
                                    type: 'orange',
                                    content: '<p class="text-center"><i class="fa fa-fw fa-check text-bold text-warning" style="font-size:54px"></i></p>' +
                                            "<p class='text-center'>Something went wrong while uploading the backup, please try again.</p>",
                                    buttons: {
                                        yes: {
                                            text: '<small>[ENTER]</small> got it!',
                                            btnClass: 'btn-warning',
                                        }
                                    }
                                });
                            },
                            complete: function() {
                                $jc.hideLoading(true);
                            }
                        });

                        return false;
                    }
                }
            }
        });
    });
</script>
@endsection