

<?php $__env->startSection('content'); ?>
  <div class="page-content row">
    <!-- Page header -->
    <div class="page-header">
      <div class="page-title">
        <h3> MySQL Editor <small> Edit SQL Statement </small></h3>
      </div>
	  
        <ul class="breadcrumb">
          <li><a href="<?php echo e(URL::to('dashboard')); ?>"> Dashboard </a></li>
          <li><a href="<?php echo e(URL::to('abserve/module')); ?>"> Module </a></li>
          <li class="active">  MySQL Editor  </li>
        </ul>     
	  	  
    </div>

	 <div class="page-content-wrapper m-t"> 
	<?php echo $__env->make('abserve.module.tab',array('active'=>'sql'), array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>

	<?php if(Session::has('message')): ?>
		   <?php echo e(Session::get('message')); ?>

	<?php endif; ?>
<div class="sbox">
 <div class="sbox-title"><h5> MySQL Statment Editor  </h5></div>
 <div class="sbox-content">
 <?php echo Form::open(array('url'=>'abserve/module/savesql/'.$module_name, 'class'=>'form-vertical ')); ?>

 <div class="infobox infobox-info fade in">
  <button type="button" class="close" data-dismiss="alert"> x </button>  
  <p> <strong>Tips !</strong> U can use query builder tool such <a href="http://code.google.com/p/sqlyog/downloads/list" target="_blank">SQL YOG </a> , PHP MyAdmin , Maestro etc to build your query statment and preview the result , <br /> then copy the syntac here </p>	
</div>	


<div class="form-group">
<label for="ipt" class=" control-label">SQL SELECT & JOIN</label>
  <textarea name="sql_select" rows="5" id="sql_select" class="tab_behave form-control"  placeholder="SQL Select & Join Statement" ><?php echo e($sql_select); ?></textarea>
</div> 	

<div class="form-group">
<label for="ipt" class=" control-label">SQL WHERE CONDITIONAL</label>
  <textarea name="sql_where" rows="2" id="sql_where" class="form-control" placeholder="SQL Where Statement" ><?php echo e($sql_where); ?></textarea>
</div> 

<div class="infobox infobox-danger fade in">
  <button type="button" class="close" data-dismiss="alert"> x </button>  
  <p> <strong>Warning !</strong> Please make sure SQL where not empty , for prevent error when user attempt submit  <strong>SEARCH</strong>   </p>	
</div>	
		
	

<div class="form-group">
<label for="ipt" class=" control-label">SQL GROUP</label>
 <textarea name="sql_group" rows="2" id="sql_group" class="form-control"   placeholder="SQL Grouping Statement" ><?php echo e($sql_group); ?></textarea>

</div> 
<div class="form-group">
<label for="ipt" class=" control-label"></label>
<button type="submit" class="btn btn-primary"> Save SQL </button>
</div> 	

 <input type="hidden" name="module_id" value="<?php echo e($row->module_id); ?>" />
 <input type="hidden" name="module_name" value="<?php echo e($row->module_name); ?>" />
 
 <?php echo Form::close(); ?>

 </div>
</div>	
	
</div>	</div>
<div class="clr"></div>

<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.app', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>