pupadupa · May 19, 2022 12:55 · Sep 17, 2015 · Sep 17, 2015 · Sep 17, 2015 · Sep 17, 2015
diff --git a/xEditable-and-Lravel-5-example.php → Lravel-5-inpalce-edit-using-xeditable.php b/xEditable-and-Lravel-5-example.php → Lravel-5-inpalce-edit-using-xeditable.php
@@ -1,3 +1,14 @@
+/**
+ * 
+ * In this example we create view with inplace and bulk editing.
+ * Tools and plugins:
+ * jQuery
+ * xEditable jquery plugin
+ * twitter bootstrap
+ *
+ */
+
+/*--------------------------------------------------------------------------------*/
 //1. create routes:
 Route::get('test', ['uses' => 'TestController@index']);
 Route::post('test/update/{id}', ['as' => 'test/update', 'uses' => 'TestController@update']);

diff --git a/xEditable-and-Lravel-5-example.php b/xEditable-and-Lravel-5-example.php
@@ -5,7 +5,7 @@
 
 
 /*--------------------------------------------------------------------------------*/
-//2. Create migration (and run it using php artisan migrate)
+//2. Create migration.
 <?php
 
 use Illuminate\Database\Schema\Blueprint;
@@ -40,6 +40,11 @@ public function down()
     }
 }
 
+/*--------------------------------------------------------------------------------*/
+//2a.
+//Run migration using command:
+//php artisan migrate
+//Add some data to db.
 
 /*--------------------------------------------------------------------------------*/
 //3. Create model Test.php

diff --git a/...avel 5. Inline and bulk editing examples. → xEditable-and-Lravel-5-example.php b/...avel 5. Inline and bulk editing examples. → xEditable-and-Lravel-5-example.php
@@ -3,6 +3,8 @@
 Route::post('test/update/{id}', ['as' => 'test/update', 'uses' => 'TestController@update']);
 Route::post('test/bulk_update', ['as' => 'test/bulk_update', 'uses' => 'TestController@bulk_update']);
 
+
+/*--------------------------------------------------------------------------------*/
 //2. Create migration (and run it using php artisan migrate)
 <?php
 
@@ -38,6 +40,8 @@ public function down()
     }
 }
 
+
+/*--------------------------------------------------------------------------------*/
 //3. Create model Test.php
 <?php
 
@@ -55,7 +59,7 @@ class test extends Model
 }
 
 
-
+/*--------------------------------------------------------------------------------*/
 //4. create controller (TestCpntroller):
 <?php
 
@@ -138,7 +142,9 @@ public function bulk_update(Request $request)
 
 }
 
-//5. create view test/index.blade.php
+
+/*--------------------------------------------------------------------------------*/
+//5. create view in resources/views/test/index.blade.php
 @extends('app')
 
 @section('content')
@@ -226,3 +232,45 @@ public function bulk_update(Request $request)
 
 @endsection
 
+
+/*--------------------------------------------------------------------------------*/
+//6. create view in resources/views/app.blade.php
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="utf-8">
+    <meta http-equiv="X-UA-Compatible" content="IE=edge">
+    <meta name="viewport" content="width=device-width, initial-scale=1">
+    <title>xEditable and laravel 5. Inline and bulk editing examples.</title>
+
+    <!-- Latest compiled and minified CSS -->
+    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css">
+
+    <!-- Fonts -->
+    <link href='//fonts.googleapis.com/css?family=Roboto:400,300' rel='stylesheet' type='text/css'>
+
+    <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
+
+    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
+    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
+    <!--[if lt IE 9]>
+        <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
+        <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
+        <![endif]-->
+
+
+</head>
+<body>
+
+@yield('content')
+
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.2/js/bootstrap.min.js"></script>
+
+<link href="//cdnjs.cloudflare.com/ajax/libs/x-editable/1.5.0/bootstrap3-editable/css/bootstrap-editable.css" rel="stylesheet"/>
+<script src="//cdnjs.cloudflare.com/ajax/libs/x-editable/1.5.0/bootstrap3-editable/js/bootstrap-editable.min.js"></script>
+
+@yield('scripts')
+
+</body>
+</html>
diff --git a/xEditable and Laravel 5. Inline and bulk editing examples. b/xEditable and Laravel 5. Inline and bulk editing examples.
@@ -0,0 +1,228 @@
+//1. create routes:
+Route::get('test', ['uses' => 'TestController@index']);
+Route::post('test/update/{id}', ['as' => 'test/update', 'uses' => 'TestController@update']);
+Route::post('test/bulk_update', ['as' => 'test/bulk_update', 'uses' => 'TestController@bulk_update']);
+
+//2. Create migration (and run it using php artisan migrate)
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateTestsTable extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        Schema::create('tests', function (Blueprint $table) {
+            $table->increments('id');
+            $table->timestamps();
+            $table->string('name')->nullable();
+            $table->float('value')->nullable();
+            $table->date('date')->nullable();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+        Schema::drop('tests');
+    }
+}
+
+//3. Create model Test.php
+<?php
+
+namespace App;
+
+use Illuminate\Database\Eloquent\Model;
+
+class test extends Model
+{
+    protected $fillable = [
+    	'name',
+    	'value',
+    	'date'
+    ];
+}
+
+
+
+//4. create controller (TestCpntroller):
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+
+use App\Http\Requests;
+use App\Http\Controllers\Controller;
+
+use App\Test;
+use Input;
+
+use Schema;
+use Redirect;
+
+class TestController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     *
+     * @return Response
+     */
+    public function index()
+    {
+        $test = Test::select()
+            ->orderBy('id')
+            ->get()
+            ;
+
+        // $test_columns = Schema::getColumnListing('tests');
+        $test_model = new Test();
+        $fillable_columns = $test_model->getFillable();
+        foreach ($fillable_columns as $key => $value) {
+            $test_columns[$value] = $value;
+        }
+
+        return view('test.index')
+            ->with('test', $test)
+            ->with('test_columns', $test_columns)
+        ;
+    }
+
+
+    public function update(Request $request, $id)
+    {
+        $test = Test::find($id);
+        $column_name = Input::get('name');
+        $column_value = Input::get('value');
+
+        if( Input::has('name') && Input::has('value')) {
+            $test = Test::select()
+                ->where('id', '=', $id)
+                ->update([$column_name => $column_value]);
+            return response()->json([ 'code'=>200], 200);
+        }
+
+        return response()->json([ 'error'=> 400, 'message'=> 'Not enought params' ], 400);
+    }
+
+    public function bulk_update(Request $request)
+    {
+        if (Input::has('ids_to_edit') && Input::has('bulk_name') && Input::has('bulk_value')) {
+            $ids = Input::get('ids_to_edit');
+            $bulk_name = Input::get('bulk_name');
+            $bulk_value = Input::get('bulk_value');
+            foreach ($ids as $id) {
+                $test = Test::select()
+                    ->where('id', '=', $id)
+                    ->update([$bulk_name => $bulk_value]);
+            }
+            // return Redirect::route('client/leads')->with('message', $message);
+            $message = "Done";
+        } else {
+            $message = "Error. Empty or Wrong data provided.";
+            return Redirect::back()->withErrors(array('message' => $message))->withInput();
+        }
+        return Redirect::back()->with('message', $message);
+    }
+
+}
+
+//5. create view test/index.blade.php
+@extends('app')
+
+@section('content')
+
+<div class="container">
+
+    <div class="row">
+        <div class="col-md-12">
+            @if (count($errors) > 0)
+                <div class="alert alert-danger">
+                    Oops! We have some erros
+                    <ul>
+                        @foreach ($errors->all() as $error)
+                            <li>{{ $error }}</li>
+                        @endforeach
+                    </ul>
+                </div>
+            @endif
+
+            @if(Session::has('message'))
+                <div class="alert alert-success">
+                  {!!Session::get('message')!!}
+                </div>
+            @endif
+        </div>
+    </div>
+
+    <div class="row">
+        <div class="col-md-12">
+
+            <h2>Bulk edit</h2>
+            {!! Form::open(['action' => 'TestController@bulk_update', 'method' => "POST", "class"=>"form-inline"]) !!}
+            <div class="form-group">
+                <label for="lead_status">For selected rows change filed </label>
+                {!! Form::select('bulk_name', $test_columns, [], ['class' => 'form-control']) !!}
+            </div>
+            <div class="form-group">
+                <label for="lead_status">equal to</label>
+                {!! Form::text('bulk_value', null, ['class' => 'form-control'])!!}
+            </div>
+            <button class="btn btn-default">Save</button>
+            <hr>
+            <table class="table table-striped">
+            @foreach($test as $t)
+                <tr>
+                    <td><td width="10px"><input type="checkbox" name="ids_to_edit[]" value="{{$t->id}}" /></td></td>
+                    <td>{{$t->id}}</td>
+                    <td><a href="#" class="testEdit" data-type="text" data-column="name" data-url="{{route('test/update', ['id'=>$t->id])}}" data-pk="{{$t->id}}" data-title="change" data-name="name">{{$t->name}}</a></td>
+                    <td><a href="#" class="testEdit" data-type="text" data-column="value"  data-url="{{route('test/update', ['id'=>$t->id])}}" data-pk="{{$t->id}}" data-title="change" data-name="value">{{$t->value}}</a></td>
+                    <td><a href="#" class="testEdit" data-type="text" data-column="date"  data-url="{{route('test/update', ['id'=>$t->id])}}" data-pk="{{$t->id}}" data-title="change" data-name="date">{{$t->date}}</a></td>
+                </tr>
+            @endforeach
+            </table>
+            {!! Form::close() !!}
+
+
+        </div>
+    </div>
+</div>
+
+@endsection
+
+@section('scripts')
+
+<script>
+$.fn.editable.defaults.mode = 'inline';
+$(document).ready(function() {
+    $('.testEdit').editable({
+        params: function(params) {
+            // add additional params from data-attributes of trigger element
+            params.name = $(this).editable().data('name');
+            return params;
+        },
+        error: function(response, newValue) {
+            if(response.status === 500) {
+                return 'Server error. Check entered data.';
+            } else {
+                return response.responseText;
+                // return "Error.";
+            }
+        }
+    });
+});
+</script>
+
+@endsection
+
No results found