@extends('layouts.internal')

@section('content')
@section('breadcrumb')
<div class="c-subheader justify-content-between px-3">
<ol class="breadcrumb border-0 m-0 px-0 px-md-3">
<li class="breadcrumb-item"><a href="/"><i class="fa fa-home"></i></a></li>
@if(url()->previous() != url()->current())
<li class="breadcrumb-item"><a href="{{url()->previous()}}">&leftarrow; Previous Page</a></li>
@endif						
<li class="breadcrumb-item"><a href="{{route('email_templates')}}">Email Queries</a></li>
<li class="breadcrumb-item active" aria-current="page">New Email Queries</li>

</ol>
</div>
@endsection
<style>#sql_query{height:300px;resize:none}</style>



    <!-- bread -->
    <div class="card" >
    <div class="card-body">

            <table width="100%">
                <tr>
                    <td colspan="3">
                        <label for="inputFirstname">Name</label>
                        {!! Form::text('name', $record->name, array('placeholder' => 'Name','class' => 'form-control', 'id' => 'name')) !!}
                    
                    </td>
                </tr>
                <tr>
                    <td colspan="3">
                        <label for="inputFirstname">Type</label>
                        {!! Form::text('name', $record->type, array('placeholder' => 'Name','class' => 'form-control', 'id' => 'type')) !!}
                    </td>
                </tr>
                <tr>
                    <td colspan="3">
                        <label for="inputFirstname">Source</label>
                        {!! Form::text('name', $record->source, array('placeholder' => 'Name','class' => 'form-control', 'id' => 'source')) !!}
                    </td>
                </tr>
                <tr>
                    <td colspan="3">
                        <label for="inputFirstname">SQL Query</label>
                        {!! Form::textarea('name', $record->sql_query, array('placeholder' => 'Name','class' => 'form-control', 'id' => 'sql_query')) !!}
                    </td>
                </tr>
                <tr>
                    <td>
                    <div class="align-right pt-4 pb-4">
                        <input type="hidden" value="{{ $record->id }}" id="idx">
                        <input onclick="store()" type="button" class="btn btn-primary px-4" value="Update">
                        <a href="{{ route('email_queries') }}" class="btn btn-secondary px-4">Back</a>
 
                    </div>
                    </td>
                </tr>
            </table>
        </div>
    </div>

<script>

function store(){
    var id = $('#idx').val();
    var name = $('#name').val();
    var type = $('#type').val();
    var source = $('#source').val();
    var sql_query = $('#sql_query').val();

    $.ajax({

        type:'post',
         headers: {
          'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
         },
         url:'{{ url("update_email_query") }}',

         data:{id:id, name:name, type:type, source:source, sql_query:sql_query},

         success:function(data){
            toastr.success(data);
         }

    });  
}
      

</script>
@endsection