fix bug sync google sheet and handle to long data address on pbg task

app/Jobs/ScrapingDataJob.php

@@ -79,7 +79,7 @@ class ScrapingDataJob implements ShouldQueue
             if (isset($import_datasource)) {
                 $import_datasource->update([
                     'status' => 'failed',
-                    'response_body' => 'Error: ' . $e->getMessage(),
+                    'response_body' => 'Terjadi kesalahan, Syncronize tidak selesai',
                     'finish_time' => now(),
                     'failed_uuid' => $failed_uuid,
                 ]);

app/Services/ServiceGoogleSheet.php

@@ -107,7 +107,7 @@ class ServiceGoogleSheet
                     'tanggal_skrd' => $this->convertToDate($cleanValue($row[33] ?? null)),
                     'ptsp' => $cleanValue($row[34] ?? null),
                     'selesai_terbit' => $cleanValue($row[35] ?? null),
-                    'tanggal_pembayaran' => $cleanValue($row[36] ?? null),
+                    'tanggal_pembayaran' => $this->convertToDate($cleanValue($row[36] ?? null)),
                     'format_sts' => $cleanValue($row[37] ?? null),
                     'tahun_terbit' => (int) $cleanValue($row[38] ?? null),
                     'tahun_berjalan' => (int) $cleanValue($row[39] ?? null),

database/migrations/2025_05_20_105942_alter_address_column_on_pbg_task_table.php

@@ -0,0 +1,26 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('pbg_task', function(Blueprint $table){
+            $table->text('address')->nullable()->change();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        //
+    }
+};