甘特图控件DHTMLX Gantt教程：dhtmlxGantt 与PHP: Laravel（下）-控件新闻-慧都网

甘特图控件DHTMLX Gantt教程：dhtmlxGantt 与PHP: Laravel（下）

翻译|使用教程|编辑：颜馨|2023-05-23 10:10:09.683|阅读 183 次

概述：本章讲述dhtmlxGantt 与PHP: Laravel（下），欢迎查阅~

#慧都22周年庆大促·界面/图表报表/文档/IDE/IOT/测试等千款热门软控件火热促销中>>

存储任务的顺序

客户端甘特图允许使用拖放对任务进行重新排序。因此，如果您使用此功能，则必须将此订单存储在数据库中。您可以在此处查看常见说明。

现在让我们将此功能添加到我们的应用程序中。

在客户端上启用任务重新排序

首先，我们需要允许用户在 UI 中更改任务顺序。打开索引视图并更新甘特图的配置：

gantt.config.order_branch = true;
gantt.config.order_branch_free = true;

gantt.init("gantt_here");

在服务器上启用任务重新排序

现在，让我们在后端反映这些更改。我们将订单存储在名为“sortorder”的列中。完整的任务架构可能如下所示：

Schema::create('tasks', function (Blueprint $table){
$table->increments('id');
$table->string('text');
$table->integer('duration');
$table->float('progress');
$table->dateTime('start_date');
$table->integer('parent');
$table->integer('sortorder')->default(0);
$table->timestamps();
});

或者，可以将迁移添加到我们之前生成的架构：

php artisan make:migration add_sortorder_to_tasks_table --table=tasks

迁移文件的代码为：

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddSortorderToTasksTable extends Migration
{
public function up()
{
Schema::table('tasks', function (Blueprint $table) {
$table->integer('sortorder')->default(0);
});
}

public function down()
{
Schema::table('tasks', function (Blueprint $table) {
$table->dropColumn('sortorder');
});
}
}

并应用迁移：

php artisan migrate

之后，我们需要更新控制器中定义的 CRUD。

1 .GET /data 必须返回按列排序的任务：sortorder

<?php
namespace App\Http\Controllers;
use App\Task;
use App\Link;

class GanttController extends Controller
{
public function get(){
$tasks = new Task();
$links = new Link();

return response()->json([
"data" => $tasks->orderBy('sortorder')->get(),
"links" => $links->all()
]);
}
}

2 .新添加的任务必须接收初始值：sortorder

public function store(Request $request){
$task = new Task();

$task->text = $request->text;
$task->start_date = $request->start_date;
$task->duration = $request->duration;
$task->progress = $request->has("progress") ? $request->progress : 0;
$task->parent = $request->parent;
$task->sortorder = Task::max("sortorder") + 1;

$task->save();

return response()->json([
"action"=> "inserted",
"tid" => $task->id
]);
}

3 升最后，当用户对任务重新排序时，必须更新任务订单：

public function update($id, Request $request){
$task = Task::find($id);

$task->text = $request->text;
$task->start_date = $request->start_date;
$task->duration = $request->duration;
$task->progress = $request->has("progress") ? $request->progress : 0;
$task->parent = $request->parent;

$task->save();

if($request->has("target")){
$this->updateOrder($id, $request->target);
}

return response()->json([
"action"=> "updated"
]);
}

private function updateOrder($taskId, $target){
$nextTask = false;
$targetId = $target;

if(strpos($target, "next:") === 0){
$targetId = substr($target, strlen("next:"));
$nextTask = true;
}

if($targetId == "null")
return;

$targetOrder = Task::find($targetId)->sortorder;
if($nextTask)
$targetOrder++;

Task::where("sortorder", ">=", $targetOrder)->increment("sortorder");

$updatedTask = Task::find($taskId);
$updatedTask->sortorder = $targetOrder;
$updatedTask->save();
}