@extends('layout.manage')

@section('css_page_level')
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css') }}" />
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/select2/css/select2.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/select2/css/select2-bootstrap.min.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-select/1.12.2/bootstrap-select.min.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-select/bootstrap-select.min.css') }}"/>
@endsection

@section('page-content-wrapper')
	<div class="page-content-wrapper" id="main">
		<div class="page-content">
			<!-- BEGIN PAGE HEADER-->
			<h3 class="page-title">
			@inject('setting','anlutro\LaravelSettings\Facade')
			{{ $setting::get('system_name','全方位建築智慧化管理系統') }} <small>{{ $setting::get('company_name','新保科技') }}</small>
			</h3>
			<div class="page-bar">
				<ul class="page-breadcrumb">
					<li>
						<i class="fa fa-home"></i>
                        <a href="{{route('manage::index')}}">@lang('messages.homepage')</a>
						<i class="fa fa-angle-right"></i>
					</li>
					<li>
                        <a href="{{ route('manage::library::librarys_index') }}">圖書管理系統</a>
						<i class="fa fa-angle-right"></i>
					</li>
					<li>
						<a href="{{ route('manage::library::library_report') }}">報表查詢及列印</a>
                        <i class="fa fa-angle-right"></i>
					</li>
                    <li>
                        <a href="{{ route('manage::library::library_report') }}">書籍借閱明細表</a>
                    </li>
				</ul>
				<div class="page-toolbar">
				</div>
			</div>
			<!-- END PAGE HEADER-->
			<!-- BEGIN DASHBOARD STATS -->
			<div class="row">
				<div class="col-md-12">
					<!-- BEGIN EXAMPLE TABLE PORTLET-->
					<div class="portlet light bordered">
						<div class="portlet-body">
                            <div class="table-toolbar">
                                <div class="btn-group pull-right">
                                    <a class="btn purple dropdown-toggle pull-right" data-toggle="dropdown" href="javascript:;"> 快速篩選
                                        <i class="fa fa-angle-down"></i>
                                    </a>
                                    <ul class="dropdown-menu">
                                        <li>
                                            <a href="javascript:;" id="btn_query"> 條件查詢 / 列印報表 </a>
                                        </li>
                                    </ul>
                                </div>
                                @include('manage.library.ReportList')
                            </div>
							<table class="table table-striped table-bordered table-hover" id="table_library">
                                <thead>
                                    <tr>
                                        <th>
                                            書籍編號
                                        </th>
                                        <th>
                                            書籍名稱
                                        </th>
                                        <th>
                                            借閱人
                                        </th>
                                        <th>
                                            借閱經手人
                                        </th>
                                        <th>
                                            歸還經手人
                                        </th>
                                        <th>
                                            借閱日期
                                        </th>
                                        <th>
                                            應歸還日期
                                        </th>
                                        <th>
                                            借閱狀況
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($library as $one)
                                    <tr class="odd gradeX">
                                        <td>
                                            {{$one->book_id}}
                                        </td>
                                        <td>
                                        	{{$one->book_name}}
                                        </td>
                                        <td>
                                        	{{$one->Uname}}({{$one->Uusername}})
                                        </td>
                                        <td>
                                        	{{$one->U2name}}
                                        </td>
                                        <td>
                                        	{{$one->U3name}}
                                        </td>
                                        <td>
                                            {{$one->created_at}}
                                        </td>
                                        <td>
                                        	{{$one->return_date}}
                                        </td>
                                        <td>
                                            @if($one->status == 0)
                                                <span class="label label-sm label-danger"> 借閱中 </span>
                                            @else
                                                <span class="label label-sm label-success"> 已歸還 </span>
                                            @endif
                                        </td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
						</div>
					</div>
					<!-- END EXAMPLE TABLE PORTLET-->
				</div>
			</div>
		</div>
	<input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">

<div class="modal fade draggable-modal" id="modal_query" tabindex="-1" role="basic" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header bg-blue-madison">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
                <h4 class="modal-title font-white">條件查詢</h4>
            </div>
            <form id="form_query" action="" class="form-horizontal">
                <div class="modal-body">
                    <div class="form-body">
                        <div class="form-group">
                            <label class="col-md-2 control-label">書籍編號</label>
                            <div class="col-md-4">
                                <select name="book_id_s" id="book_id_s" class="form-control selectpicker" data-live-search="true"> 
                                    <option value="">未選擇</option>
                                    @foreach($book_ids as $one)
                                        <option value="{{$one->book_id}}">{{$one->book_id}}</option>
                                    @endforeach
                                </select>
                            </div>
                            <label class="col-md-1 control-label">到</label>
                            <div class="col-md-4">
                                <select name="book_id_e" id="book_id_e" class="form-control selectpicker" data-live-search="true"> 
                                    <option value="">未選擇</option>
                                    @foreach($book_ids as $one)
                                        <option value="{{$one->book_id}}">{{$one->book_id}}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-2 control-label">借閱日期</label>
                            <div class="col-md-4">
                                <div class="date form_datetime date-picker" data-date-format="yyyy-mm-dd">
                                    <input type="text" name="date_s" id="date_s" readonly class="form-control"> 
                                    <span class="input-group-btn">
                                        <button class="btn default date-set" type="button" style="display: none;"></button>
                                    </span>
                                </div>
                            </div>
                            <label class="col-md-1 control-label">到</label>
                            <div class="col-md-4">
                                <div class="date form_datetime date-picker" data-date-format="yyyy-mm-dd">
                                    <input type="text" name="date_e" id="date_e" readonly class="form-control"> 
                                    <span class="input-group-btn">
                                        <button class="btn default date-set" type="button" style="display: none;"></button>
                                    </span>
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-2 control-label">借閱人</label>
                            <div class="col-md-9">
                                <select name="user" id="user" class="form-control selectpicker" data-live-search="true">
                                    <option value="">未選擇</option>
                                    @foreach($users as $one)
                                        <option value="{{$one->id}}">{{$one->name}} ( {{$one->username}} )</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>                        
                        <div class="form-group">
                            <label class="col-md-2 control-label">借閱狀況</label>
                            <div class="col-md-9">
                                <label class="radio-inline">
                                    <input type="radio" name="status_type" value="" checked>全部
                                </label>
                                <label class="radio-inline">
                                    <input type="radio" name="status_type" value="0">借閱中
                                </label>
                                <label class="radio-inline">
                                    <input type="radio" name="status_type" value="1">已歸還
                                </label>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
                    <button type="button" class="btn btn-danger" id="btn_query_print">列印</button>
                    <button type="button" class="btn btn-info" id="btn_query_submit">查詢</button>
                </div>
            </form>
        </div>
        <!-- /.modal-content -->
    </div>
    <!-- /.modal-dialog -->
</div>
@endsection

@section('plugins_page_level')
<script type="text/javascript" src="{{ asset('assets/global/plugins/jquery-validation/js/jquery.validate.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/jquery-validation/js/additional-methods.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/datatables/media/js/jquery.dataTables.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootbox/bootbox.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-datepicker/locales/bootstrap-datepicker.zh-TW.min.js') }}"></script>

<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-fileinput/additional-methods.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/select2/js/select2.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-select/1.12.2/bootstrap-select.min.js') }}"></script>
@endsection

@section('js_page_level')
    <script>
        $(document).ready(function(){

            $('.date-picker').datepicker({
                orientation: "left",
                autoclose: true,
                dateFormat: 'yyyy-mm-dd',
                language: 'zh-TW',
            });

            $('.selectpicker').selectpicker({
                size: 8
            });

            $(document).on('click','#btn_query',function(){
                $('#modal_query').modal('show');
            });

            var table = $('#table_library');
            var oTable = table.dataTable({
                // Internationalisation. For more info refer to http://datatables.net/manual/i18n
                "language": {
                    "aria": {
                        "sortAscending": ": activate to sort column ascending",
                        "sortDescending": ": activate to sort column descending"
                    },
                    "emptyTable": "@lang('messages.datatable_no_data')",
                    "info": "@lang('messages.display_from') _START_ @lang('messages.display_to') _END_ @lang('messages.then_total') _TOTAL_ @lang('messages.records')",
                    "infoEmpty": "@lang('messages.no_match')",
                    "infoFiltered": "(@lang('messages.from') _MAX_ @lang('messages.records_filter'))",
                    "lengthMenu": "@lang('messages.show') _MENU_ @lang('messages.records')",
                    "search": "@lang('messages.quick_filter'):",
                    "zeroRecords": "@lang('messages.no_data')",
                    "paginate": {
                        "previous":"@lang('messages.last_page')",
                        "next": "@lang('messages.next_page')",
                        "last": "@lang('messages.lastest')",
                        "first": "@lang('messages.most_previous')"
                    }
                },
                "aaSorting": [[5,'asc']],
                "lengthMenu": [
                    [10, 20, 50, -1],
                    [10, 20, 50, "All"] // change per page values here
                ],
                // set the initial value
                "pageLength": 10,            
                "pagingType": "bootstrap_full_number",
            });
        });

        $(document).on('click','#btn_query_submit',function(){
            var form = $('#form_query');
            form.attr("action", '{{ route("manage::library::library_report2")}}');
            form.submit();
        });

        $(document).on('click','#btn_query_print',function(){
            var form = $('#form_query');
            form.attr("action", '{{ route("manage::library::library_report2_print")}}');
            form.submit(); 
        });
    </script>
@endsection