WP File Manager

Current Path: /home/itutorethiopia/public_html/resources/views/bsetec/tables/

Name	Action
..
config.blade.php	Edit
editor.blade.php	Edit
field.blade.php	Edit
index.blade.php	Edit

Editing: config.blade.php

{!! Form::open(array('url'=>$action, 'class'=>'form-horizontal','id'=>'saveform' , 'parsley-validate'=>'','novalidate'=>' ')) !!}
			<div class="col-md-6 form-horizontal">
				<div class="form-group">
					<label class="col-md-4"> {{ Lang::get('core.table_name') }} </label>
					<div class="col-md-8">
						<input type="text" name="table_name" required="true" value="<?php if(isset($info->Name)) echo $info->Name;?>" class="form-control" >
					</div>
				</div>
				<div class="form-group">
					<label class="col-md-4"> {{ Lang::get('core.storage_engine') }} </label>
					<div class="col-md-8">
						<select class="form-control" name="engine" required="true">
							@foreach($engine as $e)
							 <option value="{{ $e }}" <?php if(isset($info->Engine) && $info->Engine ==$e) echo 'selected';?> >{{ $e }}</option>
							@endforeach
						</select>
					</div>	
				</div>

@if($table !='')	
				<div class="form-group">
					<label class="col-md-4">  </label>
					<div class="col-md-8">
						<button type="submit" class=" btn btn-xs btn-danger"> {{ Lang::get('core.change_table_info') }} </button>
					</div>	
				</div>			
				@endif									
			</div>
			<div style="clear:both;"></div>
			<hr />
			
			
		
		<div class="table-responsive" style="background:#fff;">
			<table class="table table-striped" id="tables">
				<thead>
					<tr>
						
						<th> {{ Lang::get('core.column_name') }} </th>
						<th> {{ Lang::get('core.datatype') }} </th>
						<th> {{ Lang::get('core.lenght_values') }} </th>
						<th> {{ Lang::get('core.default') }} </th>
						
						<th width="75"> {{ Lang::get('core.notnull') }} </th>
						<th> {{ Lang::get('core.key') }} </th>
						<th> {{ Lang::get('core.ai') }} </th>
						<th width="75" > {{ Lang::get('core.btn_action') }} </th>
					</tr>
				</thead>
				<tbody>
				@if(count($columns) >=1)
				@foreach($columns as $column)
					<tr class="" id="field-{{ $column->Field }}">
						
						<td>{{ $column->Field }}</td>
						<td>
						<?php
						$types = explode('(', $column->Type);
						preg_match("/$(.*)$/i", $column->Type,$typeVal);
						$type = $types[0];
						$length = (isset($typeVal[1]))?$typeVal[1]:'';
						?>	
						{{ $type }}					
				
						</td>
						<td>{{ $length }}</td>
						<td>                       
                        {{ $column->Default }}						
						</td>
						
						<td> @if($column->Null =='NO') <i class="text-success fa fa-check-circle"></i> @else <i class="text-danger fa fa-minus-circle"></i>  @endif</td>
						<td>
						@if($column->Key =='PRI') <i class="text-success fa fa-check-circle"></i> @else <i class="text-danger fa fa-minus-circle"></i>  @endif
						</td>
						<td>
						@if($column->Extra =='auto_increment') <i class="text-success fa fa-check-circle"></i> @else <i class="text-danger fa fa-minus-circle"></i>  @endif	
						</td>
						<td>
							<?php $info = 'field='.$column->Field.'&type='.$type.'&lenght='.$length.'&default='.$column->Default.'&notnull='.$column->Null.'&key='.$column->Key.'&ai='.$column->Extra; ?>
							<a href="{{ URL::TO('bsetec/tables/tablefieldedit/'.$table.'?'.$info) }}" class="btn btn-xs btn-primary" onclick="bsetecModal(this.href,'Edit New Column : {{$column->Field}} '); return false;" ><i class="fa fa-edit "></i></a>
							<a href="{{ URL::TO('bsetec/tables/tablefieldremove/'.$table.'/'.$column->Field) }}" rel="#field-{{ $column->Field }}" class="removedField  btn btn-xs btn-danger"><i class="fa fa-minus"></i></a>
						</td>
										
					</tr>
				@endforeach
				@else
					<tr class="clone clonedInput">
						
						<td><input type="text" name="fields[]" value="" class="form-control" required="true" ></td>
						<td>					
                        <select name="types[]" class="form-control" >
							@foreach($tbtypes as $t)
							 <option value="{{ $t }}" >{{ $t }}</option>
							@endforeach
                        </select>					
						</td>
						<td>

@endif
				</tbody>
			
			</table>
		
		</div>
		<hr />
		@if($table == '')
		<a href="javascript:void(0);" class="addC btn btn-xs btn-info" rel=".clone"><i class="fa fa-plus"></i>{{ Lang::get('core.new_field') }}</a>	
			<hr />
			<button type="submit" class="btn btn-xs btn-primary"> {{ Lang::get('core.save_change') }}</button>
		@else
		<a href="{{ URL::TO('bsetec/tables/tablefieldedit/'.$table) }}" class="btn btn-xs btn-info" onclick="bsetecModal(this.href,'Add New Column'); return false;" ><i class="fa fa-plus"></i>{{ Lang::get('core.add_field') }}</a>
		@endif

{!! Form::close() !!}				
<script type="text/javascript">
	$(document).ready(function(){
		$('.addC').relCopy({});	
		$('.removedField').click(function(){
			var url = $(this).attr('href');
			var id =  $(this).attr('rel');
			if(confirm('are u sure remove this field ?'))
			{
				$('.ajaxLoading').show();
				$.get( url , function( data ) {
					
					$('.ajaxLoading').hide();
					$(id).remove();
					
				});

}
			return false;
		});

});
</script>

});
function showRequest()
{
	$('.ajaxLoading').show();
}  
function showResponse(data)  {		
	
	if(data.status == 'success')
	{
		window.location.href = '{{ URL::TO("bsetec/tables") }}';
		
	} else {
		alert(data.message);
	}	
	$('.ajaxLoading').hide();
}

</script>