@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::access::index') }}">@lang('messages.access_manage')</a>
						<i class="fa fa-angle-right"></i>
					</li>
					<li>
						<a href="{{ route('manage::access::setting') }}">@lang('messages.access_setting')</a>
					</li>
				</ul>
			</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="row">
									<div class="col-md-6">
			                            <div class="btn-group">
											<a id="btn_query" href="javascript:;" class="btn green">
											資料建立 API<i class="fa fa-plus"></i>
											</a>
			                            </div>
			                            <div class="btn-group">
											<a id="btn_query_sql" href="javascript:;" class="btn green">
											資料建立 SQL<i class="fa fa-plus"></i>
											</a>
			                            </div>
			                            <button id="btn_mass_delete" class="btn red" style="display:none;"> 刪除 <i class="fa fa-trash"></i></button>
									</div>
								</div>
							</div>
							<table class="table table-striped table-bordered table-hover" id="table_access">
								<thead>
									<tr>
										<th>
											<input type="checkbox" id="chk_all" />
										</th>
										<th>
											ID
										</th>
										<th>
											廠商
										</th>
										<th>
											API路徑
										</th>
										<th>
											狀態
										</th>
										<th>
											動作
										</th>
									</tr>
								</thead>
								<tbody>
									@foreach($access as $one)
									<tr class="odd gradeX">
										<td>
											<input name="chk" class='chk_check' type="checkbox" value="{{$one->id}}">
										</td>
										<td>
											{{$one->id}}
										</td>
										<td>
											{{$one->name}}
										</td>
										<td>
											{{$one->url}}
										</td>
										<td>
											@if($one->status == 0)
												<span class="label label-sm label-success"> 啟用中 </span>
											@else
												<span class="label label-sm label-danger"> 停用中 </span>
											@endif
										</td>
										<td>
											<div class="btn-group">
											<button class="btn btn-default btn-xs dropdown-toggle" type="button" data-toggle="dropdown" aria-expand	ed="false">
											@lang('messages.action') <i class="fa fa-angle-down"></i>
											</button>
											<ul class="dropdown-menu pull-right" role="menu">
												@if($one->type == 'API')
                                                <li>
                                                    <a class="btn_edit" uid="{{$one->id}}" href="javascript:;">
                                                    <i class="fa fa-pencil"></i>
                                                    @lang('messages.edit') </a>
                                                </li>
                                                @elseif($one->type == 'MSSQL')
                                                <li>
                                                    <a class="btn_edit_sql" uid="{{$one->id}}" href="javascript:;">
                                                    <i class="fa fa-pencil"></i>
                                                    @lang('messages.edit') </a>
                                                </li>
                                                @endif

                                                <li class="divider">
                                                </li>
                                                <li>
                                                    <a class="btn_del" uid="{{$one->id}}" href="javascript:;">
                                                    <i class="fa fa-trash-o"></i>
                                                    @lang('messages.del') </a>
                                                </li>
                                            </ul>
										</div>
										</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>

<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" method="POST" action="" class="form-horizontal">
            	<div class="modal-body">
                    <div class="form-body">
                    	<div id="form_error_alert" class="alert alert-danger display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.col_invalid')
						</div>
						<div id="form_success_alert" class="alert alert-success display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.valid_and_sent')
						</div>
						<div class="form-group">
                            <label class="col-md-3 control-label">廠商<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" name="name" class="form-control" placeholder="請輸入廠商名稱">
								</select>
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-3 control-label">API路徑<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
								<input type="text" name="url" class="form-control" placeholder="請輸入API路徑"> 
                            </div>
                        </div>
                    </div>
            	</div>
	            <div class="modal-footer">
	            	<input type="hidden" id="_token" name="url_type" value="API">
	            	<input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">
	                <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
	                <button type="submit" class="btn blue" value="print">送出</button>
	            </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade draggable-modal" id="modal_edit" 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_edit" method="POST" action="" class="form-horizontal">
            	<div class="modal-body">
                    <div class="form-body">
                    	<div id="form_error_alert2" class="alert alert-danger display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.col_invalid')
						</div>
						<div id="form_success_alert2" class="alert alert-success display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.valid_and_sent')
						</div>
						<div class="form-group">
                            <label class="col-md-3 control-label">廠商<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" id="name2" name="name2" class="form-control" placeholder="請輸入廠商名稱">
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-3 control-label">API路徑<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" id="url2" name="url2" class="form-control" placeholder="請輸入API路徑">
                            </div>
                        </div>
                    </div>
            	</div>
	            <div class="modal-footer">
	            	<input type="hidden" name="id2" id="id2">
	                <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
	                <button type="submit" class="btn blue" value="print">送出</button>
	            </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade draggable-modal" id="modal_query_sql" 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_sql" method="POST" action="" class="form-horizontal">
            	<div class="modal-body">
                    <div class="form-body">
                    	<div id="form_error_alert" class="alert alert-danger display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.col_invalid')
						</div>
						<div id="form_success_alert" class="alert alert-success display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.valid_and_sent')
						</div>
						<div class="form-group">
                            <label class="col-md-3 control-label">廠商<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" name="name_sql" class="form-control" placeholder="請輸入廠商名稱">
								</select>
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-3 control-label">SQL路徑<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
								<input type="text" name="url_sql" class="form-control" placeholder="請輸入SQL路徑"> 
                            </div>
                        </div>
                    </div>
            	</div>
	            <div class="modal-footer">
	            	<input type="hidden" id="_token" name="url_type" value="MSSQL">
	            	<input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">
	                <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
	                <button type="submit" class="btn blue" value="print">送出</button>
	            </div>
            </form>
        </div>
    </div>
</div>
<div class="modal fade draggable-modal" id="modal_edit_sql" 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_edit_sql" method="POST" action="" class="form-horizontal">
            	<div class="modal-body">
                    <div class="form-body">
                    	<div id="form_error_alert2" class="alert alert-danger display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.col_invalid')
						</div>
						<div id="form_success_alert2" class="alert alert-success display-hide">
							<button class="close" data-close="alert"></button>
							@lang('messages.valid_and_sent')
						</div>
						<div class="form-group">
                            <label class="col-md-3 control-label">廠商<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" id="name2_sql" name="name2_sql" class="form-control" placeholder="請輸入廠商名稱">
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-md-3 control-label">SQL路徑<span class="required" aria-required="true"> * </span></label>
                            <div class="col-md-9">
                                <input type="text" id="url2_sql" name="url2_sql" class="form-control" placeholder="請輸入SQL路徑">
                            </div>
                        </div>
                    </div>
            	</div>
	            <div class="modal-footer">
	            	<input type="hidden" name="id2_sql" id="id2_sql">
	                <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
	                <button type="submit" class="btn blue" value="print">送出</button>
	            </div>
            </form>
        </div>
    </div>
</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(){
	$.ajax({//取得門牌資料
				type: 'GET',
				dataType: 'json',
				url: "{{ action('Manage\UserController@get_doorplates') }}",
				success: function(sendback){
					for(x in sendback.get_doorplates){
						var door=sendback.get_doorplates[x];
			            $('#doorplates').append($('<option>', {
							    value: door.doorplate+'-'+door.floor+'-'+door.household,
							    text: door.doorplate+'-'+door.floor+'-'+door.household
							}));
					}
					$('#doorplates').selectpicker('refresh');
				},
				error   : function ( data ){
		        }
			});
	var admin_data;
	$.ajax({//取得用戶資料
				type: 'GET',
				dataType: 'json',
				url: "{{ action('Manage\UserController@get_adminUser') }}",
				success: function(sendback){
					admin_data=sendback;
					for(one in admin_data.get_adminUser){
						
						if(admin_data.get_adminUser[one].privilege =="door"){
							
							$('#admin_user').append($('<option>', {
							    value: admin_data.get_adminUser[one].username,
							    text: admin_data.get_adminUser[one].username
							}));
							
						}
					}
					if(admin_data.get_adminUser[3]!=null){
						var door=admin_data.get_adminUser[0].doorplates.split(",");
						var arr = [];
						for(var i=0;i<door.length;i++){
							arr.push(door[i]);	
						}
						$('#doorplates').val(arr);
					}
					$('#admin_user').selectpicker('refresh');
					$('#doorplates').selectpicker('refresh');
				},
				error   : function ( data ){
		        }
			});
	$('#admin_user').on('change', function(e){
	  // console.log(this.value,
	  //             this.options[this.selectedIndex].value,
	  //             $(this).find("option:selected").val(),);
	  	var door=admin_data.get_adminUser[this.selectedIndex].doorplates.split(",");
		var arr = [];
		console.log(door);

		for(var i=0;i<door.length;i++){
			arr.push(door[i]);	
		}
		$('#doorplates').val(arr);					
	 	$('#doorplates').selectpicker('refresh');
	});

	var table = $('#table_access');
    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": [[1,'desc']],
        "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('change','#class_id',function(){
	var uname = $(this).find(':selected').attr('uname');
	$('#class_name').val(uname);
});

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

$(document).on('click','.btn_edit',function(){
	var uid = $(this).attr('uid');
	$.ajax({
		type : 'POST',
		url  : "{{ route('manage::access::get_setting') }}",
		dataType : 'json',
		data : {
			id     : uid,
			_token : $('#_token').val(),
		},
		success: function(sendback){
			$.each(sendback, function (key, data) {
				$("#form_edit input[name='"+key+"2']").val(data);
			});
			$('#modal_edit').modal('show');
		},
		error: function(){
			toastr['error']("@lang('messages.error_need_refresh')");
		}
	});
});
$(document).on('click','.btn_edit_sql',function(){
	var uid = $(this).attr('uid');
	$.ajax({
		type : 'POST',
		url  : "{{ route('manage::access::get_setting') }}",
		dataType : 'json',
		data : {
			id     : uid,
			_token : $('#_token').val(),
		},
		success: function(sendback){
			$.each(sendback, function (key, data) {
				$("#form_edit_sql input[name='"+key+"2_sql']").val(data);
			});
			$('#modal_edit_sql').modal('show');
		},
		error: function(){
			toastr['error']("@lang('messages.error_need_refresh')");
		}
	});
});

$(document).on('click','.btn_del',function(){
	var uid = $(this).attr('uid');
	$.ajax({
		type : 'POST',
		url: "{{ route('manage::access::del_setting') }}",
		dataType : 'json',
		data : {
			id     : uid,
			_token : $('#_token').val(),
		},
		success: function(sendback){
			toastr['success']('刪除成功');
			window.location.reload();
		},
		error: function(){
			toastr['error']("@lang('messages.error_need_refresh')");
		}
	});
});

$(document).on('change','#table_access .chk_check',function(){
	var checkedNum = $('.chk_check:checked').length;
	if(checkedNum > 0){
		$('#btn_mass_delete').show();
	}else{
		$('#btn_mass_delete').hide();
		$('#chk_all').attr("checked",false);
		$.uniform.update();
	}
});

$(document).on('click','#chk_all',function(){
	if($(this).is(':checked')){
        $('.chk_check').attr("checked",true);
    }else{
        $('.chk_check').attr("checked",false);
    }
    $.uniform.update();
	var checkedNum = $('.chk_check:checked').length;
	if(checkedNum > 0){
		$('#btn_mass_delete').show();
	}else{
		$('#btn_mass_delete').hide();
	}
});

$(document).on('click','#btn_mass_delete',function(){
	var ids = $.map($('input:checkbox:checked[name="chk"]'), function(n, i){
	      return n.value;
	}).join(',');
	bootbox.confirm("@lang('messages.sure_del')", function(result) {
		if(result == true){
			$.ajax({
				type : 'POST',
				dataType : 'json',
				url  : "{{ route('manage::access::del_all_setting') }}",
				data : {
					_token   : $('#_token').val(),
					ids : ids
				},
				success : function(sendback){
					toastr['success']("@lang('messages.del_success')");
					window.location.reload();
				},
				error : function(sendback){
					toastr['error']("@lang('messages.del_fail')");
				}
			});
		}
	});
});

$('#form_query').validate({
	errorElement: 'span', //default input error message container
    errorClass: 'help-block help-block-error', // default input error message class
    focusInvalid: false, // do not focus the last invalid input
    ignore: "",  // validate all fields including form hidden input
	rules:{
		name:{
			required: true
		},
	},
	messages:{
		name:{
			required: '請輸入類別名稱'
		},
	},

    invalidHandler: function (event, validator) { //display error alert on form submit
        $('#form_success_alert').hide();
        $('#form_error_alert').show();
        $('.modal').scrollTop($('#form_error_alert'));
    },

    highlight: function (element) { // hightlight error inputs
       $(element)
            .closest('.form-group').addClass('has-error'); // set error class to the control group
    },

    unhighlight: function (element) { // revert the change done by hightlight
        $(element)
            .closest('.form-group').removeClass('has-error'); // set error class to the control group
    },

    success: function (label) {
        label
            .closest('.form-group').removeClass('has-error'); // set success class to the control group
    },

    submitHandler: function (form) {
        $('#form_success_alert').show();
        $('#form_error_alert').hide();
        var form = $('#form_query');
        form.attr("action", '{{action('Manage\Access\AccessController@addsetting')}}');
        $('#form_query')[0].submit();
    }
});

$('#form_edit').validate({
	errorElement: 'span', //default input error message container
    errorClass: 'help-block help-block-error', // default input error message class
    focusInvalid: false, // do not focus the last invalid input
    ignore: "",  // validate all fields including form hidden input
	rules:{
		name:{
			required: true
		},
	},
	messages:{
		name:{
			required: '請輸入類別名稱'
		},
	},

    invalidHandler: function (event, validator) { //display error alert on form submit
        $('#form_success_alert2').hide();
        $('#form_error_alert2').show();
        $('.modal').scrollTop($('#form_error_alert2'));
    },

    highlight: function (element) { // hightlight error inputs
       $(element)
            .closest('.form-group').addClass('has-error'); // set error class to the control group
    },

    unhighlight: function (element) { // revert the change done by hightlight
        $(element)
            .closest('.form-group').removeClass('has-error'); // set error class to the control group
    },

    success: function (label) {
        label
            .closest('.form-group').removeClass('has-error'); // set success class to the control group
    },

    submitHandler: function (form) {
		$.ajax({
			type: 'POST',
			dataType: 'json',
			url: "{{ route('manage::access::edit_setting') }}",
			data: {
				_token			: $('#_token').val(),
				id  		 	: $('#id2').val(),
				name			: $('#name2').val(),
				url 			: $('#url2').val()
			},
			success: function(sendback){
		        $('#form_success_alert2').show();
		        $('#form_error_alert2').hide();
				toastr['success']('資料成功送出')
				$('#modal_edit').modal('hide');
				window.location.reload();
			},
			error   : function ( data ){
	        	toastr['error']('發生錯誤，請重新整理後再次操作');
	        	window.location.reload();
				$('#form_success_alert2').hide();
        		$('#form_error_alert2').show();
				$('.modal').scrollTop($('#form_error_alert2'));
	        }
		});
    }
});

$('#form_query_sql').validate({
	errorElement: 'span', //default input error message container
    errorClass: 'help-block help-block-error', // default input error message class
    focusInvalid: false, // do not focus the last invalid input
    ignore: "",  // validate all fields including form hidden input
	rules:{
		name_sql:{
			required: true
		},
	},
	messages:{
		name_sql:{
			required: '請輸入類別名稱'
		},
	},

    invalidHandler: function (event, validator) { //display error alert on form submit
        $('#form_success_alert').hide();
        $('#form_error_alert').show();
        $('.modal').scrollTop($('#form_error_alert'));
    },

    highlight: function (element) { // hightlight error inputs
       $(element)
            .closest('.form-group').addClass('has-error'); // set error class to the control group
    },

    unhighlight: function (element) { // revert the change done by hightlight
        $(element)
            .closest('.form-group').removeClass('has-error'); // set error class to the control group
    },

    success: function (label) {
        label
            .closest('.form-group').removeClass('has-error'); // set success class to the control group
    },

    submitHandler: function (form) {
        $('#form_success_alert').show();
        $('#form_error_alert').hide();
        var form = $('#form_query_sql');
        form.attr("action", '{{action('Manage\Access\AccessController@addsetting')}}');
        $('#form_query_sql')[0].submit();
    }
});

$('#form_edit_sql').validate({
	errorElement: 'span', //default input error message container
    errorClass: 'help-block help-block-error', // default input error message class
    focusInvalid: false, // do not focus the last invalid input
    ignore: "",  // validate all fields including form hidden input
	rules:{
		name_sql:{
			required: true
		},
	},
	messages:{
		name_sql:{
			required: '請輸入類別名稱'
		},
	},

    invalidHandler: function (event, validator) { //display error alert on form submit
        $('#form_success_alert2').hide();
        $('#form_error_alert2').show();
        $('.modal').scrollTop($('#form_error_alert2'));
    },

    highlight: function (element) { // hightlight error inputs
       $(element)
            .closest('.form-group').addClass('has-error'); // set error class to the control group
    },

    unhighlight: function (element) { // revert the change done by hightlight
        $(element)
            .closest('.form-group').removeClass('has-error'); // set error class to the control group
    },

    success: function (label) {
        label
            .closest('.form-group').removeClass('has-error'); // set success class to the control group
    },

    submitHandler: function (form) {
		$.ajax({
			type: 'POST',
			dataType: 'json',
			url: "{{ route('manage::access::edit_setting') }}",
			data: {
				_token			: $('#_token').val(),
				id  		 	: $('#id2_sql').val(),
				name			: $('#name2_sql').val(),
				url 			: $('#url2_sql').val()
			},
			success: function(sendback){
		        $('#form_success_alert2').show();
		        $('#form_error_alert2').hide();
				toastr['success']('資料成功送出')
				$('#modal_edit').modal('hide');
				window.location.reload();
			},
			error   : function ( data ){
	        	toastr['error']('發生錯誤，請重新整理後再次操作');
	        	window.location.reload();
				$('#form_success_alert2').hide();
        		$('#form_error_alert2').show();
				$('.modal').scrollTop($('#form_error_alert2'));
	        }
		});
    }
});



</script>
@endsection