<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
    <h2>&nbsp;GTE FAQ</h2>
  </div>
  <div class="container-fluid" style="margin-left:220px;">
      <Br>
          
        
     
     <Cfif parameterexists(url.delete)>
         <cfquery name="is" dataSource="#ds#" result="result">

         delete from gtefaq 
         where id = #url.delete#
        </cfquery> 
     </cfif>
<Cfif parameterexists(url.add)>
<cfquery name="is" dataSource="#ds#" result="result">
INSERT INTO gtefaq(typer,question,answer	)
VALUES
('#form.typer#','#form.question#','#form.answer#')
</cfquery>

<cflocation url="gtefaq.cfm" addtoken="no">
</cfif>

    <cfif parameterexists(url.editsave)>
    
    <cfquery name="upds" dataSource="#ds#">
        update gtefaq 
        set typer = '#form.typer#',
        question  = '#form.question#',
        answer = '#form.answer#',
        questionorder = #form.questionorder#
        where id = #url.editsave#
    </cfquery>

<Cflocation url="gtefaq.cfm?saved" addtoken="no">    
    <cfelseif parameterexists(url.edit)>
    
    <cfquery name="geter" dataSource="#ds#">
        select * from gtefaq where id = #Url.edit#
    </cfquery>
<cfoutput>
    
    <a href="gtefaq.cfm?delete=#url.edit#">Delete Entry</a>
    <p></p>
<FORM action="gtefaq.cfm?editsave=#url.edit#" method="post"  enctype="multipart/form-data">


<table >
 


<tr><Td><b style="font-weight:900">Type</b></td><td>

<input name="typer" type="text" class="form-control"  required value="#geter.typer#">
</td></tr>

 <tr><Td><b style="font-weight:900">Order</b></td><td>

<input name="questionorder" type="text" class="form-control"  required value="#geter.questionorder#">
</td></tr>

<tr><Td><b style="font-weight:900">Question</b></td><td>

<input name="question" type="text" class="form-control"  required value="#geter.question#">
</td></tr>

  <cfcookie name = "folderme"
    value = "#Now()#"
    expires = "NOW">

<cfcookie name = "folderme" value = "/uploads2/1/">
<Cfparam name="url.beta" default="on">


   <cfcookie name = "folderme"
    value = "#Now()#"
    expires = "NOW">

<cfcookie name = "folderme" value = "/uploads2/1/">
<Cfparam name="url.beta" default="on">


	<script src="ckeditor46z27e/ckeditor.js?asd2" charset="utf-8"></script>

<script type="text/javascript" src="ckfinder3511a/ckfinder.js?as441" charset="utf-8"></script>
<tr><Td><b style="font-weight:900">Answer</b></td><td>
<textarea name="answer" class="form-control" style="width:100%;height:300px;">#geter.answer#</textarea>
</td></tr>

<script type="text/javascript">

CKEDITOR.on( 'dialogDefinition', function( ev ) {
                                // Take the dialog name and its definition from the event data.
                                var dialogName = ev.data.name;
                                var dialogDefinition = ev.data.definition;
                                // Check if the definition is from the dialog we're interested on (the "Link" dialog).
                                if ( dialogName == 'link' ){
                                        var targetTab = dialogDefinition.getContents( 'target' );
                                        var targetDropdown = targetTab.get( 'linkTargetType' );
                                        targetDropdown.default = '_blank';
                                }
                        }       );



CKFinder.setupCKEditor( editor, 'ckfinder34/' ) ;


var editor = CKEDITOR.replace( 'answer',{
   height: '500px',
   extraAllowedContent : 'object(*);param(*);embed(*);p(*);script(*);form(*);input(*);div(*);blockquote(*)'
});


editor.on( 'instanceReady', function() {
console.log( editor.filter.allowedContent );
} );
</script>

 
</Cfoutput>
</table>



<br>
<input type="submit" Value="Save" name="buttadminman" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">
</div>

</form>

<cfelse>     

<Cfif parameterexists(url.updated)>
    Saved!<p></p></cfif>
    
    
    <FORM action="gtefaq.cfm?add=on" method="post"  enctype="multipart/form-data">


<table >
 


<tr><Td><b style="font-weight:900">Type</b></td><td>

<input name="typer" type="text" class="form-control"  required>
</td></tr>

 
<tr><Td><b style="font-weight:900">Question</b></td><td>

<input name="question" type="text" class="form-control"  required>
</td></tr>


<tr><Td><b style="font-weight:900">Answer</b></td><td>

<textarea name="answer" class="form-control" style="width:100%;height:300px;"></textarea></td></tr>

 
</table>



<br>
<input type="submit" Value="Add" name="buttadminman" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">
</div>

</form>


<cfquery name="getdel" dataSource="#ds#">
	select * from gtefaq
order by id</cfquery>	 

<table id="example23" class="display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="p0-100%"  style="margin-left:220px;">
<thead>
<th>Edit</th>
<th>Type</th>
<th>Question</th>
<th>Answer</th>
<th>Order</th>

</th>
</thead>

<cfoutput query="getdel">
	<tr>

<td><a href="gtefaq.cfm?edit=#id#" >edit</a></td>	
<td style="max-width: 100px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; ">#typer#</td>
<td style="max-width: 100px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; "><small>#question#</small></td>	

<td style="max-width: 50px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; "><small>#answer#</small></td>
    <td style="max-width: 50px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; "><small>#questionorder#</small></td>
    
	</tr>	
		
</cfoutput>

	</TAble>
</cfif>

   </div>
<!--Footer-part-->
<br><br><br><br>

    <script src="/theme/assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <!-- start - This is for export functionality only -->
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
    <script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
    <!-- end - This is for export functionality only -->
    <script>
  $(document).ready(function() {
    $('#example').DataTable( {
        "paging":   false,
        "ordering": false,
        "info":     false
    } );
} );

      $('#example23').DataTable({
        dom: 'Bfrtip',
             order: [[3, 'desc']],
        buttons: [
           
        ]
             ,   "paging":   false,

    });

    </script>



   </div>
<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">