Update .github/workflows/gemini-pr-review.yaml

Reviewed-on: #178

.github/workflows/gemini-pr-review.yaml

@@ -5,15 +5,20 @@ name: Gemini PR Review
 on:
   pull_request:
     types: [opened, reopened, synchronize]
-  
   workflow_dispatch:
 
+concurrency:
+  group: ${{ github.workflow }}-${{ github.ref }}
+  cancel-in-progress: true
+
 jobs:
-  review:
+  gemini-pr-review:
     runs-on: ubuntu-latest
+    name: Gemini PR Review
+
     steps:
       - name: Checkout code
-        uses: actions/checkout@v5
+        uses: actions/checkout@v6
         with:
           fetch-depth: 0 # This fetches the full history
 
@@ -22,7 +27,6 @@ jobs:
         with:
           node-version: '24'
 
-
       - name: Get npm cache directory
         id: npm-cache-dir
         run: |
@@ -36,8 +40,14 @@ jobs:
           restore-keys: |
             ${{ runner.os }}-npm-global-
 
-#      - name: Install Gemini CLI globally
-#        run: npm install -g --loglevel=http @google/gemini-cli
+      - name: Install Gemini CLI globally (if not already installed)
+        run: |
+          if ! command -v gemini &> /dev/null; then
+            echo "Gemini CLI not found, installing..."
+            npm install -g --loglevel=http @google/gemini-cli
+          else
+            echo "Gemini CLI already installed."
+          fi
 
       - name: Generate git diff and review with Gemini
         id: review
@@ -52,7 +62,6 @@ jobs:
 
           cat /tmp/gemini-client-error*.json || true
 
-
       - name: Post output to PR comment
         id: post_comment
         run: |

app/Console/Commands/Scheduler.php

@@ -183,8 +183,42 @@ class Scheduler extends Command
                     break;
             }
         }
-    }
 
+        $invoiceTransitRules = AlertMailRule::where('module', 'InvoiceTransit')
+            ->where('rule_name', 'InvoiceTransitMail')
+            ->select('plant', 'schedule_type')
+            ->distinct()
+            ->get();
+
+        foreach ($invoiceTransitRules as $rule) {
+
+            switch ($rule->schedule_type) {
+                case 'Live':
+                    // Run every minute
+                    \Artisan::call('send:invoice-transit-report', [
+                        'schedule_type' => $rule->schedule_type,
+                        'plant' => $rule->plant,
+                    ]);
+                    break;
+                case 'Hourly':
+                    if (now()->minute == 0) {
+                        \Artisan::call('send:invoice-transit-report', [
+                            'schedule_type' => $rule->schedule_type,
+                            'plant' => $rule->plant,
+                        ]);
+                    }
+                    break;
+                case 'Daily':
+                    if (now()->format('H:i') == '10:00') {
+                        \Artisan::call('send:invoice-transit-report', [
+                            'schedule_type' => $rule->schedule_type,
+                            'plant' => $rule->plant,
+                        ]);
+                    }
+                    break;
+            }
+        }
+    }
 
     /**
      * Helper to call Artisan commands with parameters.

app/Console/Commands/SendInvoiceTransitReport.php

@@ -0,0 +1,161 @@
+<?php
+
+namespace App\Console\Commands;
+
+use App\Mail\InvoiceTransitMail;
+use App\Models\AlertMailRule;
+use App\Models\InvoiceMaster;
+use App\Models\Plant;
+use Illuminate\Console\Command;
+use Illuminate\Support\Facades\DB;
+
+class SendInvoiceTransitReport extends Command
+{
+    /**
+     * The name and signature of the console command.
+     *
+     * @var string
+     */
+    protected $signature = 'send:invoice-transit-report {schedule_type} {plant}';
+
+    /**
+     * The console command description.
+     *
+     * @var string
+     */
+    protected $description = 'Command description';
+
+    /**
+     * Execute the console command.
+     */
+    public function handle()
+    {
+
+        $scheduleType = $this->argument('schedule_type');
+        $plantId = (int) $this->argument('plant');
+
+        $mailRules = AlertMailRule::where('module', 'InvoiceTransit')
+            ->where('rule_name', 'InvoiceTransitMail')
+            ->where('schedule_type', $scheduleType)
+            ->where('plant', $plantId)
+            ->get();
+
+        $plants = ($plantId == 0)
+            ? Plant::all()
+            : Plant::where('id', $plantId)->get();
+
+        $plantCodes = $plants->pluck('name', 'id');
+
+        if ($plants->isEmpty()) {
+            $this->error('No valid plant(s) found.');
+            return;
+        }
+
+        if (strtolower($scheduleType) == 'daily')
+        {
+           $results = DB::table('invoice_in_transits as it')
+                ->join('invoice_masters as im', function ($join) {
+                    $join->on('im.receiving_plant_name', '=', 'it.receiving_plant_name')->on('im.transport_name', '=', 'it.transport_name');
+                })
+                ->select(
+                    'it.invoice_number',
+                    'it.receiving_plant',
+                    'it.plant_id',
+                    'it.receiving_plant_name',
+                    'it.lr_bl_aw_date',
+                    'it.lr_bl_aw_number',
+                    'im.id as invoice_master_id',
+                    'im.transport_name',
+                    DB::raw('CAST(im.transit_days AS INTEGER) as transit_days'),
+                    // DB::raw('(CURRENT_DATE - CAST(it.lr_bl_aw_date AS DATE)) as delayed_days')
+                     DB::raw('
+                        GREATEST(
+                            0,
+                            (CURRENT_DATE - CAST(it.lr_bl_aw_date AS DATE) - 1)
+                            - CAST(im.transit_days AS INTEGER)
+                        ) AS delayed_days
+                    ')
+                )
+                ->when($plantId != 0, fn($q) => $q->where('it.plant_id', $plantId))
+                ->whereNotNull('it.lr_bl_aw_date')
+                ->whereRaw('
+                    (CURRENT_DATE - CAST(it.lr_bl_aw_date AS DATE))
+                    - CAST(im.transit_days AS INTEGER) > 0
+                ')
+                ->get();
+
+
+            if ($results->isEmpty()) {
+                $this->info('No invoice transit records found for today.');
+                return;
+            }
+
+            $tableData = [];
+
+            foreach ($mailRules as $rule) {
+
+                $ruleInvoices = $results->where('invoice_master_id', $rule->invoice_master_id);
+                //$ruleInvoices = $results->filter(fn($item) => $item->invoice_master_id == (int)$rule->invoice_master_id);
+
+
+                if ($ruleInvoices->isEmpty()) {
+                    $this->info("Skipping rule {$rule->id} — no invoice transit data.");
+                    continue; // ❌ DO NOT SEND MAIL
+                }
+
+                $invoiceMaster = InvoiceMaster::find($rule->invoice_master_id);
+
+                $mailSubject = $invoiceMaster
+                ? "Despatch Invoice In Transit ({$invoiceMaster->receiving_plant_name} - {$invoiceMaster->transport_name})"
+                : "Despatch Invoice In Transit";
+
+                if ($ruleInvoices->isEmpty()) {
+                    $tableData = [];
+                    $this->info("No despatch invoices in transit found for rule {$rule->id}.");
+                } else {
+                    $tableData = $ruleInvoices->values()->map(function ($item, $index) use ($plantCodes) {
+                        return [
+                            'no' => $index + 1,
+                            'plant' => $plantCodes[$item->plant_id],
+                            'receiving_plant' => $item->receiving_plant,
+                            'receiving_plant_name' => $item->receiving_plant_name,
+                            'invoice_number' => $item->invoice_number,
+                            'transport_name' => $item->transport_name,
+                            'lr_bl_aw_date' => $item->lr_bl_aw_date,
+                            'lr_bl_aw_number' => $item->lr_bl_aw_number,
+                            'transit_days' => $item->transit_days,
+                            'status' => $item->delayed_days . ' Days',
+                        ];
+                    })->toArray();
+                }
+
+                $mail = new InvoiceTransitMail($scheduleType, $tableData, $mailSubject);
+
+                $toEmails = collect(explode(',', $rule->email))
+                    ->map(fn ($e) => trim($e))
+                    ->filter()
+                    ->unique()
+                    ->values()
+                    ->toArray();
+
+                $ccEmails = collect(explode(',', $rule->cc_emails))
+                    ->map(fn ($e) => trim($e))
+                    ->filter()
+                    ->unique()
+                    ->values()
+                    ->toArray();
+
+                if (empty($toEmails)) {
+                    $this->warn("Skipping rule {$rule->id} — no To emails.");
+                    continue;
+                }
+
+                \Mail::to($toEmails)->cc($ccEmails)->send($mail);
+
+                $this->info(
+                    "Mail sent → Rule {$rule->id} | Invoice Master ID: {$rule->invoice_master_id} | To: " . implode(', ', $toEmails)
+                );
+            }
+        }
+    }
+}

app/Console/Commands/SendProductionReport.php

@@ -2,15 +2,13 @@
 
 namespace App\Console\Commands;
 
-use App\Models\InvoiceValidation;
-use App\Models\Plant;
-use Illuminate\Console\Command;
-use Illuminate\Support\Facades\Mail;
 use App\Mail\ProductionMail;
 use App\Models\Line;
+use App\Models\Plant;
 use App\Models\ProductionPlan;
 use App\Models\ProductionQuantity;
-use DB;
+use Illuminate\Console\Command;
+use Illuminate\Support\Facades\Mail;
 
 class SendProductionReport extends Command
 {
@@ -19,7 +17,7 @@ class SendProductionReport extends Command
      *
      * @var string
      */
-    //protected $signature = 'send:production-report';
+    // protected $signature = 'send:production-report';
     protected $signature = 'send:production-report {schedule_type} {plant}';
 
     /**
@@ -32,11 +30,10 @@ class SendProductionReport extends Command
     /**
      * Execute the console command.
      */
-
     public function handle()
     {
-        ini_set('max_execution_time', 0); // disable limit
-        set_time_limit(0);
+        // ini_set('max_execution_time', 0); // disable limit
+        // set_time_limit(0);
 
         $scheduleType = $this->argument('schedule_type');
         $plantId = (int) $this->argument('plant'); // cast to int for safety
@@ -55,33 +52,30 @@ class SendProductionReport extends Command
             : Plant::where('id', $plantId)->get();
 
         if ($plants->isEmpty()) {
-            $this->error("No valid plant(s) found.");
+            $this->error('No valid plant(s) found.');
+
             return;
         }
 
         // $startDate = now()->setTime(8, 0, 0);
         // $endDate = now()->copy()->addDay()->setTime(8, 0, 0);
-        if (strtolower($scheduleType) == 'daily')
-        {
+        if (strtolower($scheduleType) == 'daily') {
             $startDate = now()->subDay()->setTime(8, 0, 0);
             $endDate = now()->setTime(8, 0, 0);
-        }
-        else
-        {
+        } else {
             $startDate = now()->setTime(8, 0, 0);
             $endDate = now()->copy()->addDay()->setTime(8, 0, 0);
         }
 
-        $PlanstartDate = now()->setTime(8, 0, 0);
-        $planendDate = now()->copy()->addDay()->setTime(7, 59, 0);
+        $PlanstartDate = now()->subDay()->setTime(8, 0, 0);
+        $planendDate = now()->setTime(7, 59, 0);
 
         $tableData = [];
         $no = 1;
 
-        //.
+        // .
 
-        foreach ($plants as $plant)
-        {
+        foreach ($plants as $plant) {
             $lines = Line::where('plant_id', $plant->id)->get();
 
             foreach ($lines as $line) {
@@ -90,6 +84,7 @@ class SendProductionReport extends Command
                     ->whereBetween('created_at', [$PlanstartDate, $planendDate])
                     ->sum('plan_quantity');
 
+                /** @phpstan-ignore property.notFound */
                 if (strtolower($line->type) == 'fg line') {
                     $productionQuantity = \App\Models\QualityValidation::where('plant_id', $plant->id)
                         ->where('line_id', $line->id)
@@ -113,9 +108,7 @@ class SendProductionReport extends Command
             }
         }
 
-
-
-        //$this->table(['No', 'Plant', 'Line', 'Target Quantity', 'Production Quantity'], $fgTableData);
+        // $this->table(['No', 'Plant', 'Line', 'Target Quantity', 'Production Quantity'], $fgTableData);
 
         // $this->table(['No', 'Plant', 'Line', 'Target Quantity', 'Production Quantity'], $tableData);
 
@@ -128,7 +121,7 @@ class SendProductionReport extends Command
         // }
 
         // $this->info("Production report sent to " . count($emails) . " recipient(s).");
-          // Preview in console
+        // Preview in console
         $mail = new ProductionMail($scheduleType, $tableData);
         $contentVars = $mail->content()->with;
 
@@ -140,13 +133,39 @@ class SendProductionReport extends Command
         $this->info($contentVars['wishes'] ?? '');
 
         // Send mails
-        if (!empty($emails)) {
-            foreach ($emails as $email) {
-                Mail::to($email)->send(new ProductionMail($scheduleType, $tableData));
+        // if (! empty($emails)) {
+        //     foreach ($emails as $email) {
+        //         Mail::to($email)->send(new ProductionMail($scheduleType, $tableData));
+        //     }
+        //     $this->info('Production report sent to '.count($emails).' recipient(s).');
+        // } else {
+        //     $this->warn('No recipients found for ProductionMailAlert.');
+        // }
+        foreach ($mailRules as $rule)
+        {
+            $toEmails = collect(explode(',', $rule->email))
+                ->map(fn ($e) => trim($e))
+                ->filter()
+                ->unique()
+                ->values()
+                ->toArray();
+
+            $ccEmails = collect(explode(',', $rule->cc_emails))
+                ->map(fn ($e) => trim($e))
+                ->filter()
+                ->unique()
+                ->values()
+                ->toArray();
+
+            if (empty($toEmails)) {
+                $this->warn("Skipping rule ID {$rule->id} — no valid To emails found.");
+
+                continue;
             }
-            $this->info("Production report sent to " . count($emails) . " recipient(s).");
-        } else {
-            $this->warn('No recipients found for ProductionMailAlert.');
+
+            \Mail::to($toEmails)->cc($ccEmails)->send($mail);
+
+            $this->info("Mail sent for rule ID {$rule->id} → To: ".implode(', ', $toEmails).($ccEmails ? ' | CC: '.implode(', ', $ccEmails) : ''));
         }
     }
 }

app/Filament/Exports/AlertMailRuleExporter.php

@@ -0,0 +1,73 @@
+<?php
+
+namespace App\Filament\Exports;
+
+use App\Models\AlertMailRule;
+use App\Models\Plant;
+use Filament\Actions\Exports\ExportColumn;
+use Filament\Actions\Exports\Exporter;
+use Filament\Actions\Exports\Models\Export;
+
+class AlertMailRuleExporter extends Exporter
+{
+    protected static ?string $model = AlertMailRule::class;
+
+    public static function getColumns(): array
+    {
+        static $rowNumber = 0;
+        return [
+            ExportColumn::make('no')
+                ->label('NO')
+                ->state(function ($record) use (&$rowNumber) {
+                    // Increment and return the row number
+                    return ++$rowNumber;
+                }),
+            ExportColumn::make('module')
+            ->label('MODULE'),
+            ExportColumn::make('rule_name')
+            ->label('RULE NAME'),
+            ExportColumn::make('email')
+            ->label('EMAIL'),
+            ExportColumn::make('schedule_type')
+            ->label('SCHEDULE TYPE'),
+            ExportColumn::make('plant')
+            ->label('PLANT CODE')
+            ->formatStateUsing(function ($state) {
+                // $state is the plant ID from the database
+                if ($state == 0) {
+                    return 'All Plants';
+                }
+
+                $plant = Plant::find($state);
+                return $plant ? $plant->code : 'Unknown';
+            }),
+            ExportColumn::make('cc_emails')
+            ->label('CC EMAILS'),
+            ExportColumn::make('invoiceMaster.receiving_plant_name')
+            ->label('RECEIVING PLANT NAME'),
+            ExportColumn::make('invoiceMaster.transport_name')
+            ->label('TRANSPORT NAME'),
+            ExportColumn::make('created_at')
+            ->label('CREATED AT'),
+            ExportColumn::make('created_by')
+            ->label('CREATED BY'),
+            ExportColumn::make('updated_at')
+            ->label('UPDATED AT'),
+            ExportColumn::make('deleted_at')
+            ->label('DELETED AT')
+            ->enabledByDefault(false),
+
+        ];
+    }
+
+    public static function getCompletedNotificationBody(Export $export): string
+    {
+        $body = 'Your alert mail rule export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+
+        if ($failedRowsCount = $export->getFailedRowsCount()) {
+            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+        }
+
+        return $body;
+    }
+}

app/Filament/Exports/CharacteristicValueExporter.php

@@ -13,30 +13,49 @@ class CharacteristicValueExporter extends Exporter
 
     public static function getColumns(): array
     {
+        static $rowNumber = 0;
         return [
-            ExportColumn::make('id')
-                ->label('ID'),
-            ExportColumn::make('plant.name'),
-            ExportColumn::make('line.name'),
-            ExportColumn::make('item.id'),
-            ExportColumn::make('machine.name'),
-            ExportColumn::make('process_order'),
-            ExportColumn::make('coil_number'),
-            ExportColumn::make('status'),
-            ExportColumn::make('created_at'),
-            ExportColumn::make('updated_at'),
-            ExportColumn::make('created_by'),
-            ExportColumn::make('updated_by'),
-            ExportColumn::make('deleted_at'),
+            ExportColumn::make('no')
+                ->label('NO')
+                ->state(function ($record) use (&$rowNumber) {
+                    // Increment and return the row number
+                    return ++$rowNumber;
+                }),
+            ExportColumn::make('plant.code')
+            ->label('PLANT CODE'),
+            ExportColumn::make('line.name')
+            ->label('LINE NAME'),
+            ExportColumn::make('item.code')
+            ->label('ITEM CODE'),
+            ExportColumn::make('machine.name')
+            ->label('WORK CENTER'),
+            ExportColumn::make('process_order')
+            ->label('PROCESS ORDER'),
+            ExportColumn::make('coil_number')
+            ->label('COIL NUMBER'),
+            ExportColumn::make('status')
+            ->label('STATUS'),
+            ExportColumn::make('created_at')
+            ->label('CREATED AT'),
+            ExportColumn::make('updated_at')
+            ->label('UPDATED AT'),
+            ExportColumn::make('created_by')
+            ->label('CREATED BY'),
+            ExportColumn::make('updated_by')
+            ->label('UPDATED BY'),
+            ExportColumn::make('deleted_at')
+            ->enabledByDefault(false)
+            ->label('DELETED AT'),
+
         ];
     }
 
     public static function getCompletedNotificationBody(Export $export): string
     {
-        $body = 'Your characteristic value export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+        $body = 'Your characteristic value export has completed and '.number_format($export->successful_rows).' '.str('row')->plural($export->successful_rows).' exported.';
 
         if ($failedRowsCount = $export->getFailedRowsCount()) {
-            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+            $body .= ' '.number_format($failedRowsCount).' '.str('row')->plural($failedRowsCount).' failed to export.';
         }
 
         return $body;

app/Filament/Exports/InvoiceInTransitExporter.php

@@ -0,0 +1,92 @@
+<?php
+
+namespace App\Filament\Exports;
+
+use App\Models\InvoiceInTransit;
+use Filament\Actions\Exports\ExportColumn;
+use Filament\Actions\Exports\Exporter;
+use Filament\Actions\Exports\Models\Export;
+
+class InvoiceInTransitExporter extends Exporter
+{
+    protected static ?string $model = InvoiceInTransit::class;
+
+    public static function getColumns(): array
+    {
+        static $rowNumber = 0;
+        return [
+            ExportColumn::make('no')
+                ->label('NO')
+                ->state(function ($record) use (&$rowNumber) {
+                    // Increment and return the row number
+                    return ++$rowNumber;
+                }),
+            ExportColumn::make('plant.code')
+            ->label('PLANT'),
+            ExportColumn::make('receiving_plant')
+            ->label('RECEIVING PLANT'),
+            ExportColumn::make('receiving_plant_name')
+            ->label('RECEIVING PLANT NAME'),
+            ExportColumn::make('invoice_number')
+            ->label('INVOICE NUMBER'),
+            ExportColumn::make('invoice_date')
+            ->label('INVOICE DATE'),
+            ExportColumn::make('item_code')
+            ->label('ITEM CODE'),
+            ExportColumn::make('description')
+            ->label('DESCRIPTION'),
+            ExportColumn::make('quantity')
+            ->label('QUANTITY'),
+            ExportColumn::make('transport_name')
+            ->label('TRANSPORT NAME'),
+            ExportColumn::make('lr_bl_aw_number')
+            ->label('LR_BL_AW NUMBER'),
+            ExportColumn::make('lr_bl_aw_date')
+            ->label('LR_BL_AW DATE'),
+            ExportColumn::make('pending_days')
+            ->label('PENDING DAYS'),
+            ExportColumn::make('obd_number')
+            ->label('OBD NUMBER'),
+            ExportColumn::make('obd_date')
+            ->label('OBD DATE'),
+            ExportColumn::make('shipment_weight')
+            ->label('SHIPMENT WEIGHT'),
+            ExportColumn::make('unit_price')
+            ->label('UNIT PRICE'),
+            ExportColumn::make('net_value')
+            ->label('NET VALUE'),
+            ExportColumn::make('total_item_amount')
+            ->label('TOTAL ITEM AMOUNT'),
+            ExportColumn::make('tax_amount')
+            ->label('TAX AMOUNT'),
+            ExportColumn::make('transport_mode')
+            ->label('TRANSPORT MODE'),
+            ExportColumn::make('vehicle_number')
+            ->label('VEHICLE NUMBER'),
+            ExportColumn::make('e_waybill_number')
+            ->label('E_WAYBILL NUMBER'),
+            ExportColumn::make('created_at')
+            ->label('CREATED AT'),
+            ExportColumn::make('updated_at')
+            ->label('UPDATED AT'),
+            ExportColumn::make('created_by')
+            ->label('CREATED BY'),
+            ExportColumn::make('updated_by')
+            ->label('UPDATED BY'),
+            ExportColumn::make('deleted_at')
+            ->label('DELETED AT')
+            ->enabledByDefault(false),
+        ];
+    }
+
+    public static function getCompletedNotificationBody(Export $export): string
+    {
+        $body = 'Your invoice in transit export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+
+        if ($failedRowsCount = $export->getFailedRowsCount()) {
+            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+        }
+
+        return $body;
+    }
+}

app/Filament/Exports/InvoiceMasterExporter.php

@@ -0,0 +1,57 @@
+<?php
+
+namespace App\Filament\Exports;
+
+use App\Models\InvoiceMaster;
+use Filament\Actions\Exports\ExportColumn;
+use Filament\Actions\Exports\Exporter;
+use Filament\Actions\Exports\Models\Export;
+
+class InvoiceMasterExporter extends Exporter
+{
+    protected static ?string $model = InvoiceMaster::class;
+
+    public static function getColumns(): array
+    {
+        static $rowNumber = 0;
+        return [
+            ExportColumn::make('no')
+                ->label('NO')
+                ->state(function ($record) use (&$rowNumber) {
+                    // Increment and return the row number
+                    return ++$rowNumber;
+                }),
+            ExportColumn::make('receiving_plant')
+            ->label('Receiving Plant'),
+            ExportColumn::make('receiving_plant_name')
+            ->label('Receiving Plant Name'),
+            ExportColumn::make('transit_days')
+            ->label('Transit Days'),
+            ExportColumn::make('transport_name')
+            ->label('Transport Name'),
+            ExportColumn::make('created_at')
+            ->label('Created At'),
+            ExportColumn::make('updated_at')
+            ->label('Updated At'),
+            ExportColumn::make('created_by')
+            ->label('Created By'),
+            ExportColumn::make('updated_by')
+            ->label('Updated By'),
+            ExportColumn::make('deleted_at')
+            ->label('Deleted At')
+            ->enabledByDefault(false),
+
+        ];
+    }
+
+    public static function getCompletedNotificationBody(Export $export): string
+    {
+        $body = 'Your invoice master export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+
+        if ($failedRowsCount = $export->getFailedRowsCount()) {
+            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+        }
+
+        return $body;
+    }
+}

app/Filament/Exports/InvoiceValidationExporter.php

@@ -24,14 +24,16 @@ class InvoiceValidationExporter extends Exporter
                     // Increment and return the row number
                     return ++$rowNumber;
                 }),
-            ExportColumn::make('plant.name')
-                ->label('PLANT'),
+            ExportColumn::make('plant.code')
+                ->label('PLANT CODE'),
             ExportColumn::make('invoice_number')
                 ->label('INVOICE NUMBER'),
             ExportColumn::make('serial_number')
                 ->label('SERIAL NUMBER'),
             ExportColumn::make('stickerMaster.item.code')
                 ->label('ITEM CODE'),
+            ExportColumn::make('stickerMaster.item.description')
+                ->label('ITEM DESCRIPTION'),
             ExportColumn::make('motor_scanned_status')
                 ->label('MOTOR SCANNED STATUS'),
             ExportColumn::make('pump_scanned_status')
@@ -58,23 +60,23 @@ class InvoiceValidationExporter extends Exporter
                 ->label('OPERATOR ID'),
             ExportColumn::make('created_at')
                 ->label('CREATED AT'),
-                //->dateTimeFormat('d-m-Y H:i:s'),
+            // ->dateTimeFormat('d-m-Y H:i:s'),
             ExportColumn::make('updated_at')
                 ->label('UPDATED AT'),
-                //->dateTimeFormat('d-m-Y H:i:s'),
+            // ->dateTimeFormat('d-m-Y H:i:s'),
             ExportColumn::make('deleted_at')
                 ->enabledByDefault(false)
                 ->label('DELETED AT'),
-                //->dateTimeFormat('d-m-Y H:i:s'),
+            // ->dateTimeFormat('d-m-Y H:i:s'),
         ];
     }
 
     public static function getCompletedNotificationBody(Export $export): string
     {
-        $body = 'Your invoice validation export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+        $body = 'Your invoice validation export has completed and '.number_format($export->successful_rows).' '.str('row')->plural($export->successful_rows).' exported.';
 
         if ($failedRowsCount = $export->getFailedRowsCount()) {
-            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+            $body .= ' '.number_format($failedRowsCount).' '.str('row')->plural($failedRowsCount).' failed to export.';
         }
 
         return $body;

app/Filament/Exports/ProductCharacteristicsMasterExporter.php

@@ -14,6 +14,7 @@ class ProductCharacteristicsMasterExporter extends Exporter
     public static function getColumns(): array
     {
         static $rowNumber = 0;
+
         return [
             ExportColumn::make('no')
                 ->label('NO')
@@ -21,12 +22,12 @@ class ProductCharacteristicsMasterExporter extends Exporter
                     // Increment and return the row number
                     return ++$rowNumber;
                 }),
-            ExportColumn::make('plant.name')
-                ->label('PLANT'),
+            ExportColumn::make('plant.code')
+                ->label('PLANT CODE'),
             ExportColumn::make('item.code')
                 ->label('ITEM CODE'),
             ExportColumn::make('line.name')
-                ->label('LINE NAME'),  //machine.workGroupMaster.name
+                ->label('LINE NAME'),  // machine.workGroupMaster.name
             ExportColumn::make('machine.workGroupMaster.name')
                 ->label('WORK GROUP MASTER'),
             ExportColumn::make('machine.work_center')
@@ -34,15 +35,15 @@ class ProductCharacteristicsMasterExporter extends Exporter
             ExportColumn::make('characteristics_type')
                 ->label('CHARACTERISTICS TYPE'),
             ExportColumn::make('name')
-                ->label('NAME'),
+                ->label('CHARACTERISTICS NAME'),
             ExportColumn::make('inspection_type')
                 ->label('INSPECTION TYPE'),
-            ExportColumn::make('upper')
-                ->label('UPPER'),
             ExportColumn::make('lower')
                 ->label('LOWER'),
             ExportColumn::make('middle')
                 ->label('MIDDLE'),
+            ExportColumn::make('upper')
+                ->label('UPPER'),
             ExportColumn::make('created_at')
                 ->label('CREATED AT'),
             ExportColumn::make('updated_at')
@@ -59,10 +60,10 @@ class ProductCharacteristicsMasterExporter extends Exporter
 
     public static function getCompletedNotificationBody(Export $export): string
     {
-        $body = 'Your product characteristics master export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
+        $body = 'Your product characteristics master export has completed and '.number_format($export->successful_rows).' '.str('row')->plural($export->successful_rows).' exported.';
 
         if ($failedRowsCount = $export->getFailedRowsCount()) {
-            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
+            $body .= ' '.number_format($failedRowsCount).' '.str('row')->plural($failedRowsCount).' failed to export.';
         }
 
         return $body;

app/Filament/Imports/AlertMailRuleImporter.php

@@ -0,0 +1,141 @@
+<?php
+
+namespace App\Filament\Imports;
+
+use App\Models\AlertMailRule;
+use App\Models\Plant;
+use Filament\Actions\Imports\ImportColumn;
+use Filament\Actions\Imports\Importer;
+use Filament\Actions\Imports\Models\Import;
+use Filament\Actions\Imports\Exceptions\RowImportFailedException;
+use Filament\Facades\Filament;
+use Str;
+
+class AlertMailRuleImporter extends Importer
+{
+    protected static ?string $model = AlertMailRule::class;
+
+    public static function getColumns(): array
+    {
+        return [
+            ImportColumn::make('module')
+                ->requiredMapping()
+                ->exampleHeader('Module')
+                ->example('ProductionQuantities/InvoiceValidation/QualityValidation/InvoiceDataReport/InvoiceTransit')
+                ->label('Module')
+                ->rules(['required']),
+            ImportColumn::make('rule_name')
+                ->requiredMapping()
+                ->exampleHeader('Rule Name')
+                ->example('ProductionMail/InvoiceMail/QualityMail/InvoiceDataMail/InvoiceTransitMail')
+                ->label('Rule Name')
+                ->rules(['required']),
+            ImportColumn::make('email')
+                ->requiredMapping()
+                ->exampleHeader('Email')
+                ->example('admin@cripumps.com,ranjith.bala@cripumps.com')
+                ->label('Email')
+                ->rules(['required']),
+            ImportColumn::make('schedule_type')
+                ->exampleHeader('Schedule Type')
+                ->example('Daily/Live/Hourly')
+                ->label('Schedule Type'),
+            ImportColumn::make('plant')
+                ->requiredMapping()
+                ->exampleHeader('Plant Code')
+                ->example('1000 or All Plants')
+                ->label('Plant Code')
+                ->rules(['required']),
+            ImportColumn::make('cc_emails')
+                ->exampleHeader('CC Email')
+                ->example('admin@cripumps.com,ranjith.bala@cripumps.com')
+                ->label('CC Email')
+                ->rules(['nullable', 'string']),
+                //->rules(['cc_emails']),
+            // ImportColumn::make('invoiceMaster')
+            //     ->relationship(),
+            ImportColumn::make('receiving_plant_name')
+                ->exampleHeader('Receiving Plant Name')
+                ->example('BANGALORE')
+                ->label('Receiving Plant Name')
+                ->requiredMapping(),
+            ImportColumn::make('transporter_name')
+                ->exampleHeader('Transporter Name')
+                ->example('SAFEXPRESS PRIVATE LIMITED')
+                ->label('Transporter Name')
+                ->requiredMapping(),
+        ];
+    }
+
+    public function resolveRecord(): ?AlertMailRule
+    {
+        $warnMsg = [];
+
+        $user = Filament::auth()->user();
+
+        $operatorName = $user->name;
+
+        if (strtolower($this->data['plant']) == 'all plants') {
+            $this->data['plant'] = 0;
+        } else {
+            $plant = Plant::where('code', $this->data['plant'])->first();
+            if (!$plant) {
+                $warnMsg[] = "Plant code '{$this->data['plant']}' not found.";
+                $this->data['plant'] = null;
+            } else {
+                $this->data['plant'] = $plant->id;
+            }
+        }
+
+        $receivingPlantName = $this->data['receiving_plant_name'] ?? null;
+        $transporterName = $this->data['transporter_name'] ?? null;
+
+        if (!$receivingPlantName || !$transporterName)
+        {
+            $warnMsg [] = 'Both Receiving Plant Name and Transporter Name are required.';
+        }
+
+        $invoiceMaster = \App\Models\InvoiceMaster::where('receiving_plant_name', $receivingPlantName)
+            ->where('transport_name', $transporterName)
+            ->first();
+
+        if (!$invoiceMaster) {
+            $warnMsg [] = "Invoice Master not found for Receiving Plant '{$receivingPlantName}' and Transporter '{$transporterName}'.";
+        }
+
+        $this->data['invoice_master_id'] = $invoiceMaster->id;
+
+        unset($this->data['receiving_plant_name'], $this->data['transporter_name']);
+
+        if(! empty($warnMsg)){
+            throw new RowImportFailedException(implode(', ', $warnMsg));
+        }
+
+        return AlertMailRule::Create([
+            'module'            => $this->data['module'],
+            'rule_name'         => $this->data['rule_name'],
+            'email'             => $this->data['email'],
+            'schedule_type'     => $this->data['schedule_type'],
+            'plant'             => $this->data['plant'],
+            'cc_emails'         => $this->data['cc_emails'] ?? null,
+            'invoice_master_id' => $invoiceMaster->id,
+            'created_by'        => $operatorName,
+            'updated_by'        => $operatorName,
+        ]);
+
+        //return new AlertMailRule();
+    }
+
+    public static function getCompletedNotificationBody(Import $import): string
+    {
+        $body = 'Your alert mail rule import has completed and ' . number_format($import->successful_rows) . ' ' . str('row')->plural($import->successful_rows) . ' imported.';
+
+        if ($failedRowsCount = $import->getFailedRowsCount()) {
+
+
+            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to import.';
+        }
+
+        return $body;
+    }
+}

app/Filament/Imports/CharacteristicValueImporter.php

@@ -3,9 +3,16 @@
 namespace App\Filament\Imports;
 
 use App\Models\CharacteristicValue;
+use App\Models\Item;
+use App\Models\Line;
+use App\Models\Machine;
+use App\Models\Plant;
+use App\Models\ProcessOrder;
+use Filament\Actions\Imports\Exceptions\RowImportFailedException;
 use Filament\Actions\Imports\ImportColumn;
 use Filament\Actions\Imports\Importer;
 use Filament\Actions\Imports\Models\Import;
+use Str;
 
 class CharacteristicValueImporter extends Importer
 {
@@ -16,25 +23,52 @@ class CharacteristicValueImporter extends Importer
         return [
             ImportColumn::make('plant')
                 ->requiredMapping()
-                ->relationship()
+                ->exampleHeader('Plant Code')
+                ->example('1000')
+                ->label('Plant Code')
+                ->relationship(resolveUsing: 'code')
                 ->rules(['required']),
             ImportColumn::make('line')
                 ->requiredMapping()
-                ->relationship()
+                ->exampleHeader('Line Name')
+                ->example('4 inch pump line')
+                ->label('Line Name')
+                ->relationship(resolveUsing: 'name')
                 ->rules(['required']),
             ImportColumn::make('item')
                 ->requiredMapping()
-                ->relationship()
+                ->exampleHeader('Item Code')
+                ->example('123456')
+                ->label('Item Code')
+                ->relationship(resolveUsing: 'code')
                 ->rules(['required']),
             ImportColumn::make('machine')
                 ->requiredMapping()
-                ->relationship()
+                ->exampleHeader('Work Center')
+                ->example('RMGS09745')
+                ->label('Work Center')
+                ->relationship(resolveUsing: 'work_center')
                 ->rules(['required']),
-            ImportColumn::make('process_order'),
-            ImportColumn::make('coil_number'),
-            ImportColumn::make('status'),
-            ImportColumn::make('created_by'),
-            ImportColumn::make('updated_by'),
+            ImportColumn::make('process_order')
+                ->requiredMapping()
+                ->exampleHeader('Process Order')
+                ->example('23455256352')
+                ->label('Process Order'),
+            ImportColumn::make('coil_number')
+                ->requiredMapping()
+                ->exampleHeader('Coil Number')
+                ->example('0')
+                ->label('Coil Number'),
+            ImportColumn::make('status')
+                ->requiredMapping()
+                ->exampleHeader('Status')
+                ->example('Ok')
+                ->label('Status'),
+            ImportColumn::make('created_by')
+                ->requiredMapping()
+                ->exampleHeader('Created By')
+                ->example('RAW01234')
+                ->label('Created By'),
         ];
     }
 
@@ -45,15 +79,180 @@ class CharacteristicValueImporter extends Importer
         //     'email' => $this->data['email'],
         // ]);
 
-        return new CharacteristicValue();
+        $warnMsg = [];
+        $plantId = null;
+        $itemId = null;
+        $LineId = null;
+        $machineId = null;
+        $itemAgainstPlant = null;
+
+        $plantCode = $this->data['plant'];
+        $processOrder = trim($this->data['process_order'] ?? '');
+        $iCode = trim($this->data['item']);
+        $workCenter = trim($this->data['machine']);
+        $lineName = trim($this->data['line']);
+        $status = trim($this->data['status']);
+        $createdBy = trim($this->data['created_by']);
+        $coilNo = trim($this->data['coil_number']);
+
+        if ($plantCode == null || $plantCode == '') {
+            $warnMsg[] = 'Plant code cannot be empty';
+        } elseif ($iCode == null || $iCode == '') {
+            $warnMsg[] = 'Process Order cannot be empty';
+        } elseif ($workCenter == null || $workCenter == '') {
+            $warnMsg[] = 'Work center cannot be empty';
+        } elseif ($lineName == null || $lineName == '') {
+            $warnMsg[] = 'Line cannot be empty';
+        }
+
+        if (Str::length($plantCode) < 4 || ! is_numeric($plantCode) || ! preg_match('/^[1-9]\d{3,}$/', $plantCode)) {
+            $warnMsg[] = 'Invalid plant code found';
+        } else {
+            $plant = Plant::where('code', $plantCode)->first();
+            if (! $plant) {
+                $warnMsg[] = 'Plant not found';
+            } else {
+                $plantId = $plant->id;
+            }
+        }
+
+        if (Str::length($iCode) < 6 || ! ctype_alnum($iCode)) {
+            $warnMsg[] = 'Invalid item code found';
+        } else {
+            $itemCode = Item::where('code', $iCode)->first();
+            if (! $itemCode) {
+                $warnMsg[] = 'Item code not found';
+            } else {
+                if ($plantId) {
+                    $itemAgainstPlant = Item::where('code', $iCode)->where('plant_id', $plantId)->first();
+                    if (! $itemAgainstPlant) {
+                        $warnMsg[] = 'Item code not found for the given plant';
+                    } else {
+                        $itemId = $itemAgainstPlant->id;
+                    }
+                }
+            }
+        }
+
+        $lineExists = Line::where('name', $lineName)->first();
+        if (! $lineExists) {
+            $warnMsg[] = 'Line name not found';
+        } else {
+            if ($plantId) {
+                $lineAgainstPlant = Line::where('name', $lineName)->where('plant_id', $plantId)->first();
+                if (! $lineAgainstPlant) {
+                    $warnMsg[] = 'Line name not found for the given plant';
+                } else {
+                    $LineId = $lineAgainstPlant->id;
+                }
+            }
+        }
+
+        $workCenterExist = Machine::where('work_center', $workCenter)->first();
+        if (! $workCenterExist) {
+            $warnMsg[] = 'Work Center not found';
+        }
+
+        // $workCenterAgainstPlant = Machine::where('work_center', $workCenter)
+        //     ->where('plant_id', $plantId)
+        //     ->first();
+
+        // if (!$workCenterAgainstPlant) {
+        //     $warnMsg[] = 'Work center not found for the given plant';
+        // } else {
+        //     $MachineId = $workCenterAgainstPlant->id;
+        // }
+
+        if ($plantId != null && $LineId != null) {
+            $machineAgaPlantLine = Machine::where('plant_id', $plantId)
+                ->where('line_id', $LineId)
+                ->where('work_center', $workCenter)
+                ->first();
+
+            if (! $machineAgaPlantLine) {
+                $warnMsg[] = 'Work center not found for the given plant and line';
+            } else {
+                $machineId = $machineAgaPlantLine->id;
+            }
+        }
+
+        if ($processOrder == null || $processOrder == '') {
+            $warnMsg[] = 'Process Order cannot be empty';
+        }
+
+        if ($coilNo == null || $coilNo == '') {
+            $warnMsg[] = 'Coil No cannot be empty';
+        } elseif (! is_numeric($coilNo)) {
+            $warnMsg[] = 'Coil number should contain only numeric values!';
+        }
+
+        if ($status == null || $status == '' || ! $status) {
+            $warnMsg[] = 'Status cannot be empty';
+        } elseif (! in_array($status, ['Ok', 'NotOk'], true)) {
+            $warnMsg[] = "Status must be either 'Ok' or 'NotOk'!";
+        }
+
+        if ($createdBy == null || $createdBy == '' || ! $createdBy) {
+            $warnMsg[] = 'Created By cannot be empty';
+        }
+
+        // $existing = CharacteristicValue::where('plant_id', $plantId)
+        //     ->where('process_order', $processOrder)
+        //     ->where('coil_number', $coilNo)
+        //     ->first();
+
+        // if ($existing) {
+        //     $warnMsg[] = "Process order '{$processOrder}' with coil number '{$coilNo}' already exist for the plant code '{$plantCode}'!";
+        // }
+
+        if ($plantId && $processOrder) {
+            $existing = CharacteristicValue::where('plant_id', $plantId)
+                ->where('process_order', $processOrder)
+                ->where('coil_number', $coilNo)
+                ->first();
+
+            if ($existing) {
+                $warnMsg[] = "Coil number '{$coilNo}' already exists for Plant '{$plantCode}' and Process Order '{$processOrder}'.";
+            }
+        }
+
+        if ($plant && $itemCode && $processOrder != '') {
+
+            $existingOrder = ProcessOrder::where('plant_id', $plant->id)
+                ->where('process_order', $processOrder)
+                ->first();
+
+            if ($existingOrder && $existingOrder->item_id !== ($itemCode->id ?? null)) {
+                $warnMsg[] = 'Same Process Order already exists for this Plant with a different Item Code';
+            }
+        }
+
+        if (! empty($warnMsg)) {
+            throw new RowImportFailedException(implode(', ', $warnMsg));
+        }
+
+        return CharacteristicValue::create([
+            'plant_id' => $plantId,
+            'item_id' => $itemId,
+            'line_id' => $LineId,
+            'machine_id' => $machineId,
+            'process_order' => trim($this->data['process_order']),
+            'coil_number' => trim($this->data['coil_number']),
+            'status' => trim($this->data['status']),
+            'created_by' => trim($this->data['created_by']),
+        ]);
+
+        // return null;
+
+        // return new CharacteristicValue;
     }
 
     public static function getCompletedNotificationBody(Import $import): string
     {
-        $body = 'Your characteristic value import has completed and ' . number_format($import->successful_rows) . ' ' . str('row')->plural($import->successful_rows) . ' imported.';
+        $body = 'Your characteristic value import has completed and '.number_format($import->successful_rows).' '.str('row')->plural($import->successful_rows).' imported.';
 
         if ($failedRowsCount = $import->getFailedRowsCount()) {
-            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to import.';
+            $body .= ' '.number_format($failedRowsCount).' '.str('row')->plural($failedRowsCount).' failed to import.';
         }
 
         return $body;

app/Filament/Imports/ProcessOrderImporter.php

@@ -10,6 +10,7 @@ use Filament\Actions\Imports\Exceptions\RowImportFailedException;
 use Filament\Actions\Imports\ImportColumn;
 use Filament\Actions\Imports\Importer;
 use Filament\Actions\Imports\Models\Import;
+use Filament\Facades\Filament;
 use Str;
 
 class ProcessOrderImporter extends Importer
@@ -38,41 +39,57 @@ class ProcessOrderImporter extends Importer
                 ->example('202500123456')
                 ->label('PROCESS ORDER')
                 ->rules(['required']),
-            ImportColumn::make('created_by')
-                ->exampleHeader('CREATED BY')
-                ->example('RAW01234')
-                ->label('CREATED BY')
+            ImportColumn::make('order_quantity')
+                ->exampleHeader('ORDER QUANTITY')
+                ->example('100')
+                ->label('ORDER QUANTITY')
                 ->rules(['required']),
+            // ImportColumn::make('created_by')
+            //     ->exampleHeader('CREATED BY')
+            //     ->example('RAW01234')
+            //     ->label('CREATED BY')
+            //     ->rules(['required']),
         ];
     }
 
     public function resolveRecord(): ?ProcessOrder
     {
         $warnMsg = [];
-        $plant = Plant::where('code', $this->data['plant'])->first();
-        $itemCode = Item::where('code', $this->data['item'])->first();
+        $plantCod = $this->data['plant'];
+        $plant = null;
         $iCode = trim($this->data['item']);
+        $processOrder = trim($this->data['process_order'] ?? '');
+        $user = Filament::auth()->user();
+        $operatorName = $user->name;
 
-        if (! $plant) {
-            $warnMsg[] = 'Plant not found';
-        } elseif (Str::length($iCode) < 6 || ! ctype_alnum($iCode)) {
-            $warnMsg[] = 'Invalid item code found';
-        } elseif (! $itemCode) {
-            $warnMsg[] = 'Item Code not found';
+        if (Str::length($plantCod) < 4 || ! is_numeric($plantCod) || ! preg_match('/^[1-9]\d{3,}$/', $plantCod)) {
+            $warnMsg[] = 'Invalid plant code found';
+        } else {
+            $plant = Plant::where('code', $plantCod)->first();
+            if (! $plant) {
+                $warnMsg[] = 'Plant not found';
+            }
         }
 
-        $processOrder = trim($this->data['process_order'] ?? '');
+        if (Str::length($iCode) < 6 || ! ctype_alnum($iCode)) {
+            $warnMsg[] = 'Invalid item code found';
+        } else {
+            $itemCode = Item::where('code', $iCode)->first();
+            if (! $itemCode) {
+                $warnMsg[] = 'Item Code not found';
+            }
+        }
 
         if ($processOrder == '') {
             $warnMsg[] = 'Process Order cannot be empty';
         }
 
-        $user = User::where('name', $this->data['created_by'])->first();
-        if (! $user) {
-            $warnMsg[] = 'User not found';
-        }
+        // $user = User::where('name', $this->data['created_by'])->first();
+        // if (! $user) {
+        //     $warnMsg[] = 'User not found';
+        // }
 
-        if ($plant && $processOrder != '') {
+        if ($plant && $itemCode && $processOrder != '') {
 
             $existingOrder = ProcessOrder::where('plant_id', $plant->id)
                 ->where('process_order', $processOrder)
@@ -94,7 +111,7 @@ class ProcessOrderImporter extends Importer
             'coil_number' => '0',
             'order_quantity' => 0,
             'received_quantity' => 0,
-            'created_by' => $user->name,
+            'created_by' => $operatorName,
         ]);
 
         // return new ProcessOrder();

app/Filament/Imports/ProductCharacteristicsMasterImporter.php

@@ -9,12 +9,12 @@ use App\Models\Plant;
 use App\Models\ProductCharacteristicsMaster;
 use App\Models\User;
 use App\Models\WorkGroupMaster;
+use Filament\Actions\Imports\Exceptions\RowImportFailedException;
 use Filament\Actions\Imports\ImportColumn;
 use Filament\Actions\Imports\Importer;
 use Filament\Actions\Imports\Models\Import;
-use Str;
-use Filament\Actions\Imports\Exceptions\RowImportFailedException;
 use Illuminate\Support\Facades\Auth;
+use Str;
 
 class ProductCharacteristicsMasterImporter extends Importer
 {
@@ -25,38 +25,38 @@ class ProductCharacteristicsMasterImporter extends Importer
         return [
             ImportColumn::make('plant')
                 ->requiredMapping()
-                ->exampleHeader('Plant Name')
-                ->example('Ransar Industries-I')
-                ->label('Plant Name')
-                ->relationship(resolveUsing:'name')
+                ->exampleHeader('Plant Code')
+                ->example('1000')
+                ->label('Plant Code')
+                ->relationship(resolveUsing: 'code')
                 ->rules(['required']),
             ImportColumn::make('item')
                 ->requiredMapping()
                 ->exampleHeader('Item Code')
                 ->example('630214')
                 ->label('Item Code')
-                ->relationship(resolveUsing:'code')
+                ->relationship(resolveUsing: 'code')
                 ->rules(['required']),
             ImportColumn::make('line')
                 ->requiredMapping()
-                ->exampleHeader('Line')
+                ->exampleHeader('Line Name')
                 ->example('4 inch pump line')
-                ->label('Line')
-                ->relationship(resolveUsing:'name')
+                ->label('Line Name')
+                ->relationship(resolveUsing: 'name')
                 ->rules(['required']),
             ImportColumn::make('work_group_master_id')
                 ->label('Group Work Center')
                 ->requiredMapping()
                 ->exampleHeader('Group Work Center')
                 ->example('RMGCGABC')
-                ->relationship(resolveUsing:'name')
+                ->relationship(resolveUsing: 'name')
                 ->rules(['required']),
             ImportColumn::make('machine')
                 ->requiredMapping()
                 ->exampleHeader('Work Center')
                 ->example('RMGCE001')
                 ->label('Work Center')
-                ->relationship(resolveUsing:'work_center')
+                ->relationship(resolveUsing: 'work_center')
                 ->rules(['required']),
             ImportColumn::make('characteristics_type')
                 ->exampleHeader('Characteristics Type')
@@ -64,9 +64,9 @@ class ProductCharacteristicsMasterImporter extends Importer
                 ->label('Characteristics Type')
                 ->rules(['required']),
             ImportColumn::make('name')
-                ->exampleHeader('Name')
+                ->exampleHeader('Characteristics Name')
                 ->example('Body')
-                ->label('Name')
+                ->label('Characteristics Name')
                 ->rules(['required']),
             ImportColumn::make('inspection_type')
                 ->exampleHeader('Inspection Type')
@@ -93,7 +93,7 @@ class ProductCharacteristicsMasterImporter extends Importer
                 ->exampleHeader('Created By')
                 ->example('Admin')
                 ->label('Created By'),
-            //ImportColumn::make('updated_by'),
+            // ImportColumn::make('updated_by'),
 
         ];
     }
@@ -102,132 +102,127 @@ class ProductCharacteristicsMasterImporter extends Importer
     {
 
         $warnMsg = [];
-        $plant = Plant::where('name', $this->data['plant'])->first();
-        if (!$plant) {
-            $warnMsg[] = "Plant not found";
-        }
+        $plantCod = $this->data['plant'];
+        $plant = null;
+        if (Str::length($plantCod) < 4 || ! is_numeric($plantCod) || ! preg_match('/^[1-9]\d{3,}$/', $plantCod)) {
+            $warnMsg[] = 'Invalid plant code found';
+        } else {
+            $plant = Plant::where('code', $plantCod)->first();
+            if (! $plant) {
+                $warnMsg[] = 'Plant not found';
+            } else {
+                $itemExists = Item::where('code', $this->data['item'])->first();
+                if (! $itemExists) {
+                    $warnMsg[] = 'Item not found';
+                }
 
-        $itemExists = Item::where('code', $this->data['item'])->first();
-        if (!$itemExists) {
-            $warnMsg[] = "Item not found";
-        }
+                $itemAgainstPlant = Item::where('code', $this->data['item'])
+                    ->where('plant_id', $plant->id)
+                    ->first();
+                if (! $itemAgainstPlant) {
+                    $warnMsg[] = 'Item code not found for the given plant';
+                } else {
+                    $itemId = $itemAgainstPlant->id;
+                }
 
-        $itemAgainstPlant = Item::where('code', $this->data['item'])
-            ->where('plant_id', $plant->id)
-            ->first();
-        if (!$itemAgainstPlant) {
-            $warnMsg[] = "Item code not found for the given plant";
-        }
-        else {
-            $itemId = $itemAgainstPlant->id;
-        }
+                $lineExists = Line::where('name', $this->data['line'])->first();
+                if (! $lineExists) {
+                    $warnMsg[] = 'Line not found';
+                }
 
-        $lineExists = Line::where('name', $this->data['line'])->first();
-        if (!$lineExists) {
-            $warnMsg[] = "Line not found";
-        }
+                $lineAgainstPlant = Line::where('name', $this->data['line'])
+                    ->where('plant_id', $plant->id)
+                    ->first();
 
-        $lineAgainstPlant = Line::where('name', $this->data['line'])
-            ->where('plant_id', $plant->id)
-            ->first();
+                if (! $lineAgainstPlant) {
+                    $warnMsg[] = 'Line not found for the given plant';
+                } else {
+                    $LineId = $lineAgainstPlant->id;
+                }
 
-        if (!$lineAgainstPlant) {
-            $warnMsg[] = "Line not found for the given plant";
-        }
-        else
-        {
-            $LineId = $lineAgainstPlant->id;
-        }
+                $WorkgroupMaster = WorkGroupMaster::where('name', $this->data['work_group_master_id'])->where('plant_id', $plant->id)->first();
+                if (! $WorkgroupMaster) {
+                    $warnMsg[] = 'Work Group Master value not found';
+                } else {
 
-        $WorkgroupMaster = WorkGroupMaster::where('name', $this->data['work_group_master_id'])->where('plant_id', $plant->id)->first();
-        if (!$WorkgroupMaster) {
-            $warnMsg[] = "Work Group Master value not found";
-        }
-        else {
+                    $workGroupMasterId = $WorkgroupMaster->id;
 
-            $workGroupMasterId = $WorkgroupMaster->id;
+                    // 2. Now check if this WorkGroupMaster id exists in ANY of the 10 columns
+                    $existsInLine = Line::where('plant_id', $plant->id)
+                        ->where(function ($q) use ($workGroupMasterId) {
+                            for ($i = 1; $i <= 10; $i++) {
+                                $q->orWhere("work_group{$i}_id", $workGroupMasterId);
+                            }
+                        })
+                        ->exists();
 
-            // 2. Now check if this WorkGroupMaster id exists in ANY of the 10 columns
-            $existsInLine = Line::where('plant_id', $plant->id)
-                ->where(function ($q) use ($workGroupMasterId) {
-                    for ($i = 1; $i <= 10; $i++) {
-                        $q->orWhere("work_group{$i}_id", $workGroupMasterId);
+                    if (! $existsInLine) {
+                        $warnMsg[] = "Work Group Master '{$WorkgroupMaster->name}' is not mapped to any line in this plant";
+                    } else {
+                        $workGroupMasterId = $WorkgroupMaster->id;
                     }
-                })
-                ->exists();
+                }
 
-            if (!$existsInLine) {
-                $warnMsg[] = "Work Group Master '{$WorkgroupMaster->name}' is not mapped to any line in this plant";
-            }
-            else {
-                $workGroupMasterId = $WorkgroupMaster->id;
+                $machine = Machine::where('work_center', $this->data['machine'])->first();
+                if (! $machine) {
+                    $warnMsg[] = 'Work Center not found';
+                } else {
+                    $machineId = $machine->id;
+                }
+
+                $machineAgainstPlant = Machine::where('work_center', $this->data['machine'])
+                    ->where('plant_id', $plant->id)
+                    ->first();
+
+                if (! $machineAgainstPlant) {
+                    $warnMsg[] = 'Work Center not found for the given plant';
+                } else {
+                    $machineId = $machineAgainstPlant->id;
+                }
+
+                $user = User::where('name', $this->data['created_by'])->first();
+                if (! $user) {
+                    $warnMsg[] = 'Operator ID not found';
+                }
+
+                if (($this->data['inspection_type'] ?? null) == 'Value') {
+                    $upper = $this->data['upper'] ?? null;
+                    $lower = $this->data['lower'] ?? null;
+                    $middle = $this->data['middle'] ?? null;
+
+                    if (is_null($upper) || is_null($lower) || is_null($middle)) {
+                        $warnMsg[] = "For 'Value' inspection type, Upper, Lower, and Middle values are required.";
+                    } elseif (! is_numeric($upper) || ! is_numeric($lower) || ! is_numeric($middle)) {
+                        $warnMsg[] = 'Upper, Lower, and Middle values must be numeric.';
+                    } elseif (! ($lower <= $middle && $middle <= $upper)) {
+                        $warnMsg[] = "For 'Value' inspection type, values must satisfy: Lower ≤ Middle ≤ Upper.";
+                    }
+                }
             }
         }
 
-
-        $machine = Machine::where('work_center', $this->data['machine'])->first();
-        if (!$machine) {
-            $warnMsg[] = "Work Center not found";
-        }
-        else {
-            $machineId = $machine->id;
-        }
-
-        $machineAgainstPlant = Machine::where('work_center', $this->data['machine'])
-            ->where('plant_id', $plant->id)
-            ->first();
-
-        if (!$machineAgainstPlant) {
-            $warnMsg[] = "Work Center not found for the given plant";
-        }
-        else
-        {
-            $machineId = $machineAgainstPlant->id;
-        }
-
-        $user = User::where('name', $this->data['created_by'])->first();
-        if (!$user) {
-            $warnMsg[] = "Operator ID not found";
-        }
-
-        if (($this->data['inspection_type'] ?? null) == 'Value') {
-            $upper  = $this->data['upper']  ?? null;
-            $lower  = $this->data['lower']  ?? null;
-            $middle = $this->data['middle'] ?? null;
-
-            if (is_null($upper) || is_null($lower) || is_null($middle)) {
-                $warnMsg[] = "For 'Value' inspection type, Upper, Lower, and Middle values are required.";
-            } elseif (!is_numeric($upper) || !is_numeric($lower) || !is_numeric($middle)) {
-                $warnMsg[] = "Upper, Lower, and Middle values must be numeric.";
-            } elseif (!($lower <= $middle && $middle <= $upper)) {
-                $warnMsg[] = "For 'Value' inspection type, values must satisfy: Lower ≤ Middle ≤ Upper.";
-            }
-        }
-
-        if (!empty($warnMsg)) {
+        if (! empty($warnMsg)) {
             throw new RowImportFailedException(implode(', ', $warnMsg));
-        }
-        else
-        {
+        } else {
             $record = ProductCharacteristicsMaster::firstOrNew([
-                'plant_id'             => $plant->id,
-                'item_id'              => $itemId,
-                'line_id'              => $LineId,
+                'plant_id' => $plant->id,
+                'item_id' => $itemId,
+                'line_id' => $LineId,
                 'work_group_master_id' => $workGroupMasterId,
-                'machine_id'           => $machineId,
+                'machine_id' => $machineId,
             ]);
 
             $currentUser = Auth::check() ? Auth::user()->name : ($this->data['created_by'] ?? 'System');
 
             // If record is new, fill all fields
-            if (!$record->exists) {
-                $record->name                 = $this->data['name'];
+            if (! $record->exists) {
+                $record->name = $this->data['name'];
                 $record->characteristics_type = $this->data['characteristics_type'];
-                $record->inspection_type      = $this->data['inspection_type'];
-                $record->upper                = $this->data['upper'] ?? null;
-                $record->lower                = $this->data['lower'] ?? null;
-                $record->middle               = $this->data['middle'] ?? null;
-                $record->created_by           = $currentUser;
+                $record->inspection_type = $this->data['inspection_type'];
+                $record->upper = $this->data['upper'] ?? null;
+                $record->lower = $this->data['lower'] ?? null;
+                $record->middle = $this->data['middle'] ?? null;
+                $record->created_by = $currentUser;
             } else {
                 // Record exists → update only updated_by and updated_at
                 $record->updated_by = $currentUser;
@@ -264,17 +259,17 @@ class ProductCharacteristicsMasterImporter extends Importer
         //     return null;
         // }
 
-        //return new WorkGroupMaster();
+        // return new WorkGroupMaster();
 
-       // return new ProductCharacteristicsMaster();
+        // return new ProductCharacteristicsMaster();
     }
 
     public static function getCompletedNotificationBody(Import $import): string
     {
-        $body = 'Your product characteristics master import has completed and ' . number_format($import->successful_rows) . ' ' . str('row')->plural($import->successful_rows) . ' imported.';
+        $body = 'Your product characteristics master import has completed and '.number_format($import->successful_rows).' '.str('row')->plural($import->successful_rows).' imported.';
 
         if ($failedRowsCount = $import->getFailedRowsCount()) {
-            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to import.';
+            $body .= ' '.number_format($failedRowsCount).' '.str('row')->plural($failedRowsCount).' failed to import.';
         }
 
         return $body;

app/Filament/Pages/InvoiceDataDashboard.php

@@ -20,7 +20,7 @@ class InvoiceDataDashboard extends Page
 
     protected static string $view = 'filament.pages.invoice-data-dashboard';
 
-    protected static ?string $navigationGroup = 'Invoice Management';
+    protected static ?string $navigationGroup = 'Manufacturing SD';
 
     public function mount(): void
     {

app/Filament/Pages/StickerReprint.php

@@ -641,322 +641,322 @@ class StickerReprint extends Page implements HasForms
 
             // ********************************
 
-            $exists = \App\Models\ProductionPlan::where('plant_id', $this->pId)
-                ->where('shift_id', $this->sId)
-                ->where('line_id', $this->lId)
-                ->whereDate('created_at', today())
-                ->latest()
-                ->exists();
+            // $exists = \App\Models\ProductionPlan::where('plant_id', $this->pId)
+            //     ->where('shift_id', $this->sId)
+            //     ->where('line_id', $this->lId)
+            //     ->whereDate('created_at', today())
+            //     ->latest()
+            //     ->exists();
 
-            if ($exists)
-            {
-                $currentDate = date('Y-m-d');
+            // if ($exists)
+            // {
+            //     $currentDate = date('Y-m-d');
 
-                $shiftId = Shift::where('id', $this->sId)
-                ->first();
+            //     $shiftId = Shift::where('id', $this->sId)
+            //     ->first();
 
-                [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
-                $hRs = (int) $hRs;
-                //$miNs = (int) $miNs;-*/
+            //     [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
+            //     $hRs = (int) $hRs;
+            //     //$miNs = (int) $miNs;-*/
 
-                $totalMinutes = $hRs * 60 + $miNs;
+            //     $totalMinutes = $hRs * 60 + $miNs;
 
-                $from_dt = $currentDate . ' ' . $shiftId->start_time;
+            //     $from_dt = $currentDate . ' ' . $shiftId->start_time;
 
-                $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
+            //     $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
 
-                $currentDateTime = date('Y-m-d H:i:s');
+            //     $currentDateTime = date('Y-m-d H:i:s');
 
-                // Check if current date time is within the range
-                if (!($currentDateTime >= $from_dt && $currentDateTime < $to_dt)) {
-                    //echo "Choosed a valid shift...";
-                    // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //     // Check if current date time is within the range
+            //     if (!($currentDateTime >= $from_dt && $currentDateTime < $to_dt)) {
+            //         //echo "Choosed a valid shift...";
+            //         // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                    $this->form->fill([
-                        'plant_id'=> $this->pId,
-                        'block_name'=> $this->bId,
-                        'shift_id'=> $this->sId,
-                        'line_id'=> $this->lId,
-                        'item_id'=> null,
-                        'serial_number'=> null,
-                        'success_msg'=> null,
-                        'production_order'=> $this->prodOrder,
-                        'sap_msg_status' => null,
-                        'sap_msg_description' => null,
-                        'operator_id'=> $operatorName,
-                        'recent_qr' => $this->recQr,
-                    ]);
-                    Notification::make()
-                        ->title('Invalid Shift')
-                        ->body("Please select a valid shift.")
-                        ->danger()
-                        ->send();
-                    //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                    return;
-                }
-                else
-                {
-                    $this->form->fill([
-                        'plant_id'=> $this->pId,
-                        'block_name'=> $this->bId,
-                        'shift_id'=> $this->sId,
-                        'line_id'=> $this->lId,
-                        'item_id'=> null,
-                        'serial_number'=> null,
-                        'success_msg'=> null,
-                        'production_order'=> $this->prodOrder,
-                        'sap_msg_status' => null,
-                        'sap_msg_description' => null,
-                        'operator_id'=> $operatorName,
-                        'recent_qr' => $this->recQr,
-                    ]);
-                }
-            }
-            else
-            {
-                $existShifts = \App\Models\ProductionPlan::where('plant_id', $this->pId)
-                ->where('shift_id', $this->sId)
-                ->where('line_id', $this->lId)
-                ->whereDate('created_at', Carbon::yesterday())
-                ->latest()
-                ->exists();
+            //         $this->form->fill([
+            //             'plant_id'=> $this->pId,
+            //             'block_name'=> $this->bId,
+            //             'shift_id'=> $this->sId,
+            //             'line_id'=> $this->lId,
+            //             'item_id'=> null,
+            //             'serial_number'=> null,
+            //             'success_msg'=> null,
+            //             'production_order'=> $this->prodOrder,
+            //             'sap_msg_status' => null,
+            //             'sap_msg_description' => null,
+            //             'operator_id'=> $operatorName,
+            //             'recent_qr' => $this->recQr,
+            //         ]);
+            //         Notification::make()
+            //             ->title('Invalid Shift')
+            //             ->body("Please select a valid shift.")
+            //             ->danger()
+            //             ->send();
+            //         //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //         return;
+            //     }
+            //     else
+            //     {
+            //         $this->form->fill([
+            //             'plant_id'=> $this->pId,
+            //             'block_name'=> $this->bId,
+            //             'shift_id'=> $this->sId,
+            //             'line_id'=> $this->lId,
+            //             'item_id'=> null,
+            //             'serial_number'=> null,
+            //             'success_msg'=> null,
+            //             'production_order'=> $this->prodOrder,
+            //             'sap_msg_status' => null,
+            //             'sap_msg_description' => null,
+            //             'operator_id'=> $operatorName,
+            //             'recent_qr' => $this->recQr,
+            //         ]);
+            //     }
+            // }
+            // else
+            // {
+            //     $existShifts = \App\Models\ProductionPlan::where('plant_id', $this->pId)
+            //     ->where('shift_id', $this->sId)
+            //     ->where('line_id', $this->lId)
+            //     ->whereDate('created_at', Carbon::yesterday())
+            //     ->latest()
+            //     ->exists();
 
-                if ($existShifts) //if ($existShifts->count() > 0)
-                { // record exist on yesterday
-                    //$currentDate = date('Y-m-d');
-                    $yesterday = date('Y-m-d', strtotime('-1 days'));
+            //     if ($existShifts) //if ($existShifts->count() > 0)
+            //     { // record exist on yesterday
+            //         //$currentDate = date('Y-m-d');
+            //         $yesterday = date('Y-m-d', strtotime('-1 days'));
 
-                    $shiftId = Shift::where('id', $this->sId)
-                    ->first();
+            //         $shiftId = Shift::where('id', $this->sId)
+            //         ->first();
 
-                    [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
-                    $hRs = (int) $hRs;
-                    //   $miNs = (int) $miNs;-*/
+            //         [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
+            //         $hRs = (int) $hRs;
+            //         //   $miNs = (int) $miNs;-*/
 
-                    $totalMinutes = $hRs * 60 + $miNs;
+            //         $totalMinutes = $hRs * 60 + $miNs;
 
-                    $from_dt = $yesterday . ' ' . $shiftId->start_time;
+            //         $from_dt = $yesterday . ' ' . $shiftId->start_time;
 
-                    $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
+            //         $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
 
-                    $currentDateTime = date('Y-m-d H:i:s');
+            //         $currentDateTime = date('Y-m-d H:i:s');
 
-                    // Check if current date time is within the range
-                    if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
-                        $this->form->fill([
-                            'plant_id'=> $this->pId,
-                            'block_name'=> $this->bId,
-                            'shift_id'=> $this->sId,
-                            'line_id'=> $this->lId,
-                            'item_id'=> null,
-                            'serial_number'=> null,
-                            'success_msg'=> null,
-                            'production_order'=> $this->prodOrder,
-                            'sap_msg_status' => null,
-                            'sap_msg_description' => null,
-                            'operator_id'=> $operatorName,
-                            'recent_qr' => $this->recQr,
-                        ]);
-                    }
-                    else
-                    {
-                        $currentDate = date('Y-m-d');
+            //         // Check if current date time is within the range
+            //         if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
+            //             $this->form->fill([
+            //                 'plant_id'=> $this->pId,
+            //                 'block_name'=> $this->bId,
+            //                 'shift_id'=> $this->sId,
+            //                 'line_id'=> $this->lId,
+            //                 'item_id'=> null,
+            //                 'serial_number'=> null,
+            //                 'success_msg'=> null,
+            //                 'production_order'=> $this->prodOrder,
+            //                 'sap_msg_status' => null,
+            //                 'sap_msg_description' => null,
+            //                 'operator_id'=> $operatorName,
+            //                 'recent_qr' => $this->recQr,
+            //             ]);
+            //         }
+            //         else
+            //         {
+            //             $currentDate = date('Y-m-d');
 
-                        $shiftId = Shift::where('id', $this->sId)
-                        ->first();
+            //             $shiftId = Shift::where('id', $this->sId)
+            //             ->first();
 
-                        [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
-                        $hRs = (int) $hRs;
-                        //   $miNs = (int) $miNs;-*/
+            //             [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
+            //             $hRs = (int) $hRs;
+            //             //   $miNs = (int) $miNs;-*/
 
-                        $totalMinutes = $hRs * 60 + $miNs;
+            //             $totalMinutes = $hRs * 60 + $miNs;
 
-                        $from_dt = $currentDate . ' ' . $shiftId->start_time;
+            //             $from_dt = $currentDate . ' ' . $shiftId->start_time;
 
-                        $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
+            //             $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
 
-                        $currentDateTime = date('Y-m-d H:i:s');
+            //             $currentDateTime = date('Y-m-d H:i:s');
 
-                        // Check if current date time is within the range
-                        if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
-                            //echo "Choosed a valid shift...";
-                            // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //             // Check if current date time is within the range
+            //             if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
+            //                 //echo "Choosed a valid shift...";
+            //                 // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                            $this->form->fill([
-                                'plant_id'=> $this->pId,
-                                'block_name'=> $this->bId,
-                                'shift_id'=> $this->sId,
-                                'line_id'=> $this->lId,
-                                'item_id'=> null,
-                                'serial_number'=> null,
-                                'success_msg'=> null,
-                                'production_order'=> $this->prodOrder,
-                                'sap_msg_status' => null,
-                                'sap_msg_description' => null,
-                                'operator_id'=> $operatorName,
-                                'recent_qr' => $this->recQr,
-                            ]);
-                            Notification::make()
-                                ->title('Plan Not Found')
-                                ->body("Please set production plan first.")
-                                ->danger()
-                                ->send();
-                            //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                            return;
-                        }
-                        else
-                        {
-                            //echo "Choosed a valid shift...";
-                            // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 $this->form->fill([
+            //                     'plant_id'=> $this->pId,
+            //                     'block_name'=> $this->bId,
+            //                     'shift_id'=> $this->sId,
+            //                     'line_id'=> $this->lId,
+            //                     'item_id'=> null,
+            //                     'serial_number'=> null,
+            //                     'success_msg'=> null,
+            //                     'production_order'=> $this->prodOrder,
+            //                     'sap_msg_status' => null,
+            //                     'sap_msg_description' => null,
+            //                     'operator_id'=> $operatorName,
+            //                     'recent_qr' => $this->recQr,
+            //                 ]);
+            //                 Notification::make()
+            //                     ->title('Plan Not Found')
+            //                     ->body("Please set production plan first.")
+            //                     ->danger()
+            //                     ->send();
+            //                 //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 return;
+            //             }
+            //             else
+            //             {
+            //                 //echo "Choosed a valid shift...";
+            //                 // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                            $this->form->fill([
-                                'plant_id'=> $this->pId,
-                                'block_name'=> $this->bId,
-                                'shift_id'=> $this->sId,
-                                'line_id'=> $this->lId,
-                                'item_id'=> null,
-                                'serial_number'=> null,
-                                'success_msg'=> null,
-                                'production_order'=> $this->prodOrder,
-                                'sap_msg_status' => null,
-                                'sap_msg_description' => null,
-                                'operator_id'=> $operatorName,
-                                'recent_qr' => $this->recQr,
-                            ]);
-                            Notification::make()
-                                ->title('Invalid Shift')
-                                ->body("Please select a valid shift.")
-                                ->danger()
-                                ->send();
-                            //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                            return;
-                        }
-                    }
-                }
-                else
-                { // record not exist on yesterday
+            //                 $this->form->fill([
+            //                     'plant_id'=> $this->pId,
+            //                     'block_name'=> $this->bId,
+            //                     'shift_id'=> $this->sId,
+            //                     'line_id'=> $this->lId,
+            //                     'item_id'=> null,
+            //                     'serial_number'=> null,
+            //                     'success_msg'=> null,
+            //                     'production_order'=> $this->prodOrder,
+            //                     'sap_msg_status' => null,
+            //                     'sap_msg_description' => null,
+            //                     'operator_id'=> $operatorName,
+            //                     'recent_qr' => $this->recQr,
+            //                 ]);
+            //                 Notification::make()
+            //                     ->title('Invalid Shift')
+            //                     ->body("Please select a valid shift.")
+            //                     ->danger()
+            //                     ->send();
+            //                 //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 return;
+            //             }
+            //         }
+            //     }
+            //     else
+            //     { // record not exist on yesterday
 
-                    //$currentDate = date('Y-m-d');
-                    $yesterday = date('Y-m-d', strtotime('-1 days'));
+            //         //$currentDate = date('Y-m-d');
+            //         $yesterday = date('Y-m-d', strtotime('-1 days'));
 
-                    $shiftId = Shift::where('id', $this->sId)
-                    ->first();
+            //         $shiftId = Shift::where('id', $this->sId)
+            //         ->first();
 
-                    [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
-                    $hRs = (int) $hRs;
-                    //   $miNs = (int) $miNs;-*/
+            //         [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
+            //         $hRs = (int) $hRs;
+            //         //   $miNs = (int) $miNs;-*/
 
-                    $totalMinutes = $hRs * 60 + $miNs;
+            //         $totalMinutes = $hRs * 60 + $miNs;
 
-                    $from_dt = $yesterday . ' ' . $shiftId->start_time;
+            //         $from_dt = $yesterday . ' ' . $shiftId->start_time;
 
-                    $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
+            //         $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
 
-                    $currentDateTime = date('Y-m-d H:i:s');
+            //         $currentDateTime = date('Y-m-d H:i:s');
 
-                    // Check if current date time is within the range
-                    if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
-                        //echo "Choosed a valid shift...";
-                        // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //         // Check if current date time is within the range
+            //         if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
+            //             //echo "Choosed a valid shift...";
+            //             // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                        $this->form->fill([
-                            'plant_id'=> $this->pId,
-                            'block_name'=> $this->bId,
-                            'shift_id'=> $this->sId,
-                            'line_id'=> $this->lId,
-                            'item_id'=> null,
-                            'serial_number'=> null,
-                            'success_msg'=> null,
-                            'production_order'=> $this->prodOrder,
-                            'sap_msg_status' => null,
-                            'sap_msg_description' => null,
-                            'operator_id'=> $operatorName,
-                            'recent_qr' => $this->recQr,
-                        ]);
-                        Notification::make()
-                            ->title('Plan Not Found')
-                            ->body("Please set production plan first.")
-                            ->danger()
-                            ->send();
-                        //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                        return;
-                    }
-                    else
-                    {
-                        $currentDate = date('Y-m-d');
+            //             $this->form->fill([
+            //                 'plant_id'=> $this->pId,
+            //                 'block_name'=> $this->bId,
+            //                 'shift_id'=> $this->sId,
+            //                 'line_id'=> $this->lId,
+            //                 'item_id'=> null,
+            //                 'serial_number'=> null,
+            //                 'success_msg'=> null,
+            //                 'production_order'=> $this->prodOrder,
+            //                 'sap_msg_status' => null,
+            //                 'sap_msg_description' => null,
+            //                 'operator_id'=> $operatorName,
+            //                 'recent_qr' => $this->recQr,
+            //             ]);
+            //             Notification::make()
+            //                 ->title('Plan Not Found')
+            //                 ->body("Please set production plan first.")
+            //                 ->danger()
+            //                 ->send();
+            //             //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //             return;
+            //         }
+            //         else
+            //         {
+            //             $currentDate = date('Y-m-d');
 
-                        $shiftId = Shift::where('id', $this->sId)
-                        ->first();
+            //             $shiftId = Shift::where('id', $this->sId)
+            //             ->first();
 
-                        [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
-                        $hRs = (int) $hRs;
-                        //   $miNs = (int) $miNs;-*/
+            //             [$hRs, $miNs] = explode('.', $shiftId->duration) + [0, 0];
+            //             $hRs = (int) $hRs;
+            //             //   $miNs = (int) $miNs;-*/
 
-                        $totalMinutes = $hRs * 60 + $miNs;
+            //             $totalMinutes = $hRs * 60 + $miNs;
 
-                        $from_dt = $currentDate . ' ' . $shiftId->start_time;
+            //             $from_dt = $currentDate . ' ' . $shiftId->start_time;
 
-                        $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
+            //             $to_dt = date('Y-m-d H:i:s', strtotime($from_dt . " + $totalMinutes minutes"));
 
-                        $currentDateTime = date('Y-m-d H:i:s');
+            //             $currentDateTime = date('Y-m-d H:i:s');
 
-                        // Check if current date time is within the range
-                        if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
-                            //echo "Choosed a valid shift...";
-                            // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //             // Check if current date time is within the range
+            //             if ($currentDateTime >= $from_dt && $currentDateTime < $to_dt) {
+            //                 //echo "Choosed a valid shift...";
+            //                 // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                            $this->form->fill([
-                                'plant_id'=> $this->pId,
-                                'block_name'=> $this->bId,
-                                'shift_id'=> $this->sId,
-                                'line_id'=> $this->lId,
-                                'item_id'=> null,
-                                'serial_number'=> null,
-                                'success_msg'=> null,
-                                'production_order'=> $this->prodOrder,
-                                'sap_msg_status' => null,
-                                'sap_msg_description' => null,
-                                'operator_id'=> $operatorName,
-                                'recent_qr' => $this->recQr,
-                            ]);
-                            Notification::make()
-                                ->title('Plan Not Found')
-                                ->body("Please set production plan first.")
-                                ->danger()
-                                ->send();
-                            //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                            return;
-                        }
-                        else
-                        {
-                            //echo "Choosed a valid shift...";
-                            // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 $this->form->fill([
+            //                     'plant_id'=> $this->pId,
+            //                     'block_name'=> $this->bId,
+            //                     'shift_id'=> $this->sId,
+            //                     'line_id'=> $this->lId,
+            //                     'item_id'=> null,
+            //                     'serial_number'=> null,
+            //                     'success_msg'=> null,
+            //                     'production_order'=> $this->prodOrder,
+            //                     'sap_msg_status' => null,
+            //                     'sap_msg_description' => null,
+            //                     'operator_id'=> $operatorName,
+            //                     'recent_qr' => $this->recQr,
+            //                 ]);
+            //                 Notification::make()
+            //                     ->title('Plan Not Found')
+            //                     ->body("Please set production plan first.")
+            //                     ->danger()
+            //                     ->send();
+            //                 //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 return;
+            //             }
+            //             else
+            //             {
+            //                 //echo "Choosed a valid shift...";
+            //                 // $set('ppLineError', 'Valid (From: '.$from_dt.', To: '.$to_dt.')');
 
-                            $this->form->fill([
-                                'plant_id'=> $this->pId,
-                                'block_name'=> $this->bId,
-                                'shift_id'=> $this->sId,
-                                'line_id'=> $this->lId,
-                                'item_id'=> null,
-                                'serial_number'=> null,
-                                'success_msg'=> null,
-                                'production_order'=> $this->prodOrder,
-                                'sap_msg_status' => null,
-                                'sap_msg_description' => null,
-                                'operator_id'=> $operatorName,
-                                'recent_qr' => $this->recQr,
-                            ]);
-                            Notification::make()
-                                ->title('Invalid Shift')
-                                ->body("Please select a valid shift.")
-                                ->danger()
-                                ->send();
-                            //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
-                            return;
-                        }
-                    }
-                }
-            }
+            //                 $this->form->fill([
+            //                     'plant_id'=> $this->pId,
+            //                     'block_name'=> $this->bId,
+            //                     'shift_id'=> $this->sId,
+            //                     'line_id'=> $this->lId,
+            //                     'item_id'=> null,
+            //                     'serial_number'=> null,
+            //                     'success_msg'=> null,
+            //                     'production_order'=> $this->prodOrder,
+            //                     'sap_msg_status' => null,
+            //                     'sap_msg_description' => null,
+            //                     'operator_id'=> $operatorName,
+            //                     'recent_qr' => $this->recQr,
+            //                 ]);
+            //                 Notification::make()
+            //                     ->title('Invalid Shift')
+            //                     ->body("Please select a valid shift.")
+            //                     ->danger()
+            //                     ->send();
+            //                 //$set('validationError', 'Curr.'.$currentDateTime.' (From: '.$from_dt.', To: '.$to_dt.')');
+            //                 return;
+            //             }
+            //         }
+            //     }
+            // }
 
             // ********************************
 
@@ -1155,12 +1155,27 @@ class StickerReprint extends Page implements HasForms
         // Only search when all parent IDs are selected
         $parts = explode('|', $formQRData);
         $itemCode = trim($parts[0]);
+
+
         $serialNumberRaw = isset($parts[1]) ? trim($parts[1]) : null;
 
-        // Remove slash and everything after it
+        // // Remove slash and everything after it
+        // if ($serialNumberRaw != null) {
+        //     $serialNumber = preg_replace('/\/.*/', '', $serialNumberRaw);
+        //     $serialNumber = trim($serialNumber);
+        // } else {
+        //     $serialNumber = null;
+        // }
         if ($serialNumberRaw != null) {
-            $serialNumber = preg_replace('/\/.*/', '', $serialNumberRaw);
+            if (strpos($serialNumberRaw, '/') !== false) {
+                $serialNumber = strstr($serialNumberRaw, '/', true); // gets text before slash
+            } else {
+                $serialNumber = $serialNumberRaw; // keep original
+
+            }
+
             $serialNumber = trim($serialNumber);
+
         } else {
             $serialNumber = null;
         }
@@ -1269,86 +1284,86 @@ class StickerReprint extends Page implements HasForms
             return;
         }
 
-        $line = Line::find($this->lId);
-        $lineName = $line ? $line->name : null;
+        //$line = Line::find($this->lId);
+        //$lineName = $line ? $line->name : null;
 
-        $categoryName = (Str::length($item->category) > 0) ? $item->category : "";
+        // $categoryName = (Str::length($item->category) > 0) ? $item->category : "";
 
-        if ($categoryName == 'Submersible Motor')
-        {
-            if ($lineName != '6 inch motor line')
-            {
-                 $this->form->fill([
-                'plant_id'=> $this->pId,
-                'block_name'=> $this->bId,
-                'shift_id'=> $this->sId,
-                'line_id'=> $this->lId,
-                'item_id'=> null,
-                'serial_number'=> null,
-                'success_msg'=> null,
-                'production_order'=> $this->prodOrder,
-                'sap_msg_status' => null,
-                'sap_msg_description' => null,
-                'operator_id'=> $operatorName,
-                'recent_qr' => $this->recQr,
-            ]);
-                Notification::make()
-                    ->title('Invalid Line Found')
-                    ->body("Choose '6 inch motor line' to proceed..!")
-                    ->danger()
-                    ->send();
-                return;
-            }
-        }
-        else if ($categoryName == 'Submersible Pump')
-        {
-            if ($lineName != '6 inch pump line')
-            {
-                 $this->form->fill([
-                'plant_id'=> $this->pId,
-                'block_name'=> $this->bId,
-                'shift_id'=> $this->sId,
-                'line_id'=> $this->lId,
-                'item_id'=> null,
-                'serial_number'=> null,
-                'success_msg'=> null,
-                'production_order'=> $this->prodOrder,
-                'sap_msg_status' => null,
-                'sap_msg_description' => null,
-                'operator_id'=> $operatorName,
-                'recent_qr' => $this->recQr,
-            ]);
-                Notification::make()
-                    ->title('Invalid Line Found')
-                    ->body("Choose '6 inch pump line' to proceed..!")
-                    ->danger()
-                    ->send();
-                return;
-            }
-        }
-        else
-        {
-            $this->form->fill([
-                'plant_id'=> $this->pId,
-                'block_name'=> $this->bId,
-                'shift_id'=> $this->sId,
-                'line_id'=> $this->lId,
-                'item_id'=> null,
-                'serial_number'=> null,
-                'success_msg'=> null,
-                'production_order'=> $this->prodOrder,
-                'sap_msg_status' => null,
-                'sap_msg_description' => null,
-                'operator_id'=> $operatorName,
-                'recent_qr' => $this->recQr,
-            ]);
-                Notification::make()
-                    ->title('Invalid Category Found')
-                    ->body("Set proper category to proceed..!")
-                    ->danger()
-                    ->send();
-                return;
-        }
+        // if ($categoryName == 'Submersible Motor')
+        // {
+        //     if ($lineName != '6 inch motor line')
+        //     {
+        //          $this->form->fill([
+        //         'plant_id'=> $this->pId,
+        //         'block_name'=> $this->bId,
+        //         'shift_id'=> $this->sId,
+        //         'line_id'=> $this->lId,
+        //         'item_id'=> null,
+        //         'serial_number'=> null,
+        //         'success_msg'=> null,
+        //         'production_order'=> $this->prodOrder,
+        //         'sap_msg_status' => null,
+        //         'sap_msg_description' => null,
+        //         'operator_id'=> $operatorName,
+        //         'recent_qr' => $this->recQr,
+        //     ]);
+        //         Notification::make()
+        //             ->title('Invalid Line Found')
+        //             ->body("Choose '6 inch motor line' to proceed..!")
+        //             ->danger()
+        //             ->send();
+        //         return;
+        //     }
+        // }
+        // else if ($categoryName == 'Submersible Pump')
+        // {
+        //     if ($lineName != '6 inch pump line')
+        //     {
+        //          $this->form->fill([
+        //         'plant_id'=> $this->pId,
+        //         'block_name'=> $this->bId,
+        //         'shift_id'=> $this->sId,
+        //         'line_id'=> $this->lId,
+        //         'item_id'=> null,
+        //         'serial_number'=> null,
+        //         'success_msg'=> null,
+        //         'production_order'=> $this->prodOrder,
+        //         'sap_msg_status' => null,
+        //         'sap_msg_description' => null,
+        //         'operator_id'=> $operatorName,
+        //         'recent_qr' => $this->recQr,
+        //     ]);
+        //         Notification::make()
+        //             ->title('Invalid Line Found')
+        //             ->body("Choose '6 inch pump line' to proceed..!")
+        //             ->danger()
+        //             ->send();
+        //         return;
+        //     }
+        // }
+        // else
+        // {
+        //     $this->form->fill([
+        //         'plant_id'=> $this->pId,
+        //         'block_name'=> $this->bId,
+        //         'shift_id'=> $this->sId,
+        //         'line_id'=> $this->lId,
+        //         'item_id'=> null,
+        //         'serial_number'=> null,
+        //         'success_msg'=> null,
+        //         'production_order'=> $this->prodOrder,
+        //         'sap_msg_status' => null,
+        //         'sap_msg_description' => null,
+        //         'operator_id'=> $operatorName,
+        //         'recent_qr' => $this->recQr,
+        //     ]);
+        //         Notification::make()
+        //             ->title('Invalid Category Found')
+        //             ->body("Set proper category to proceed..!")
+        //             ->danger()
+        //             ->send();
+        //         return;
+        // }
 
         if ($this->succId == null) {
             $this->form->fill([
@@ -1383,6 +1398,33 @@ class StickerReprint extends Page implements HasForms
             $itemCode = trim($parts[0]);
             $this->sNoId = isset($parts[1]) ? trim($parts[1]) : null;
 
+            $originalQR = $this->qrData;
+
+            if (strpos($originalQR, '/') != false)
+            {
+                // Allowed endings
+                $allowed = ['/m', '/M', '/p', '/P', '/m|', '/M|', '/p|', '/P|'];
+
+                $foundValidEnding = false;
+
+                foreach ($allowed as $end) {
+                    if (str_ends_with($originalQR, $end)) {
+                        $foundValidEnding = true;
+                        break;
+                    }
+                }
+
+                if (!$foundValidEnding) {
+                    Notification::make()
+                        ->title('Invalid QR Code')
+                        ->body("Invalid QR format: '$originalQR'")
+                        ->danger()
+                        ->send();
+
+                    return;
+                }
+            }
+
             if ($this->sNoId != null) {
                 $this->sNoId = preg_replace('/\/.*/', '', $serialNumberRaw);
                 $this->sNoId = trim($this->sNoId);
@@ -1390,7 +1432,7 @@ class StickerReprint extends Page implements HasForms
                 $this->sNoId = null;
             }
 
-            $this->qrData = preg_replace('/\/.*/', '', $this->qrData);
+            //$this->qrData = preg_replace('/\/.*/', '', $this->qrData);
 
             ProductionQuantity::create([
                 'plant_id'=> $this->pId,
@@ -1406,7 +1448,6 @@ class StickerReprint extends Page implements HasForms
 
             // after success insertion
             $this->form->fill([
-
                 'plant_id'=> $this->pId,
                 'block_name'=> $this->bId,
                 'shift_id'=> $this->sId,
@@ -1429,7 +1470,7 @@ class StickerReprint extends Page implements HasForms
                 ->duration(1000)
                 ->send();
 
-                $url = route('download-qr1-pdf', ['palletNo' => $this->qrData]);
+            $url = route('download-qr1-pdf', ['palletNo' => urlencode($originalQR)]);
               $this->js(<<<JS
                     window.dispatchEvent(new CustomEvent('open-pdf', {
                         detail: {

app/Filament/Resources/AlertMailRuleResource.php

@@ -2,9 +2,12 @@
 
 namespace App\Filament\Resources;
 
+use App\Filament\Exports\AlertMailRuleExporter;
+use App\Filament\Imports\AlertMailRuleImporter;
 use App\Filament\Resources\AlertMailRuleResource\Pages;
 use App\Filament\Resources\AlertMailRuleResource\RelationManagers;
 use App\Models\AlertMailRule;
+use App\Models\InvoiceMaster;
 use App\Models\Plant;
 use Dotenv\Exception\ValidationException;
 use Filament\Facades\Filament;
@@ -17,7 +20,13 @@ use Filament\Tables\Table;
 use Illuminate\Database\Eloquent\Builder;
 use Illuminate\Database\Eloquent\SoftDeletingScope;
 use Filament\Forms\Components\Section;
+use Filament\Forms\Components\Actions\Action;
+use Filament\Notifications\Notification;
+use Illuminate\Support\Facades\Artisan;
+use Illuminate\Support\Facades\DB;
 use Illuminate\Validation\ValidationException as ValidationValidationException;
+use Filament\Tables\Actions\ImportAction;
+use Filament\Tables\Actions\ExportAction;
 
 class AlertMailRuleResource extends Resource
 {
@@ -51,6 +60,7 @@ class AlertMailRuleResource extends Resource
                     'InvoiceDataReport' => 'InvoiceDataReport',
                     'ProductionQuantities' => 'ProductionQuantities',
                     'QualityValidation' => 'QualityValidation',
+                    'InvoiceTransit' => 'InvoiceTransit',
                 ]),
                 Forms\Components\Select::make('rule_name')
                     ->label('Rule Name')
@@ -61,6 +71,7 @@ class AlertMailRuleResource extends Resource
                         'ProductionMail' => 'Production Mail',
                         'InvoiceDataMail' => 'Invoice Data Mail',
                         'QualityMail' => 'Quality Mail',
+                        'InvoiceTransitMail' => 'Invoice Transit Mail',
                     ])
                     ->required(),
                 Forms\Components\TextInput::make('email')
@@ -75,29 +86,76 @@ class AlertMailRuleResource extends Resource
                     'Hourly' => 'Hourly',
                     'Daily' => 'Daily',
                 ]),
+                Forms\Components\Select::make('receiving_plant_name')
+                    ->label('Receiving Plant')
+                    ->options(
+                        InvoiceMaster::query()
+                            ->whereNotNull('receiving_plant_name')
+                            ->select('receiving_plant_name')
+                            ->distinct()
+                            ->pluck('receiving_plant_name', 'receiving_plant_name')
+                    )
+                    ->searchable()
+                    ->reactive()
+                    ->afterStateUpdated(function (callable $set) {
+                        $set('invoice_master_id', null);
+                    }),
+                Forms\Components\Select::make('invoice_master_id')
+                    ->label('Transporter Name')
+                    ->options(function (callable $get) {
+                        $recPlant = $get('receiving_plant_name');
+
+                        if (! $recPlant) {
+                            return [];
+                        }
+
+                        return InvoiceMaster::query()
+                            ->where('receiving_plant_name', $recPlant)
+                            ->whereNotNull('transport_name')
+                            ->where('transport_name', '!=', '')
+                            ->orderBy('transport_name')
+                            ->pluck('transport_name', 'id')
+                            ->toArray();
+                    })
+                    ->searchable(),
                 Checkbox::make('is_active')
                     ->label('All Plants Reports')
                     ->afterStateUpdated(fn ($state, callable $set) => $state ? $set('plant', null) : null)
                     ->reactive(),
+                // Forms\Components\Actions::make([
+                //     Action::make('sendInvoiceData')
+                //         ->label('Invoice Data Report')
+                //         ->action(function ($get) {
+
+                //             $plantIds = AlertMailRule::where('module', 'InvoiceDataReport')
+                //                 ->orderBy('plant')
+                //                 ->pluck('plant')
+                //                 ->toArray();
+
+                //             foreach ($plantIds as $plantId) {
+                //                 Artisan::call('send:invoice-data-report', [
+                //                     'schedule_type' => 'Daily',
+                //                     'plant' => $plantId,
+                //                 ]);
+                //             }
+
+                //             // Notify user in Filament
+                //             Notification::make()
+                //                 ->title('Invoice data report sent successfully!')
+                //                 ->success()
+                //                 ->send();
+                //         }),
+
+                //     ]),
                 Forms\Components\Hidden::make('created_by')
                    ->default(fn () => Filament::auth()->user()?->name),
                 Forms\Components\Hidden::make('updated_by')
                    ->default(fn () => Filament::auth()->user()?->name),
             ])
-            ->columns(6),
+            ->columns(2),
         ]);
     }
 
-    // Optionally, also override for update/editing
-    // public static function mutateFormDataBeforeSave(array $data): array
-    // {
-    //      dd('test');
-    //     if ($data['is_active']) {
-    //         $data['plant'] = 'All Plants';
-    //     }
-    //     return $data;
-    // }
-
     public static function table(Table $table): Table
     {
         return $table
@@ -132,6 +190,14 @@ class AlertMailRuleResource extends Resource
                     ->alignCenter()
                     ->searchable()
                     ->sortable(),
+                Tables\Columns\TextColumn::make('invoiceMaster.receiving_plant_name')
+                    ->label('Receiving Plant')
+                    ->alignCenter()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('invoiceMaster.transport_name')
+                    ->label('Transporter')
+                    ->alignCenter()
+                    ->sortable(),
                 Tables\Columns\TextColumn::make('email')
                     ->label('TO Emails')
                     ->searchable()
@@ -188,6 +254,22 @@ class AlertMailRuleResource extends Resource
                     Tables\Actions\ForceDeleteBulkAction::make(),
                     Tables\Actions\RestoreBulkAction::make(),
                 ]),
+            ])
+            ->headerActions([
+                ImportAction::make()
+                    ->label('Import Alert Mail Rule')
+                    ->color('warning')
+                    ->importer(AlertMailRuleImporter::class)
+                    ->visible(function() {
+                        return Filament::auth()->user()->can('view import alert mail rule');
+                    }),
+                ExportAction::make()
+                    ->label('Export Alert Mail Rule')
+                    ->color('warning')
+                    ->exporter(AlertMailRuleExporter::class)
+                    ->visible(function() {
+                        return Filament::auth()->user()->can('view export alert mail rule');
+                    }),
             ]);
     }
 

app/Filament/Resources/CharacteristicValueResource.php

@@ -184,6 +184,10 @@ class CharacteristicValueResource extends Resource
                     ->hint(fn ($get) => $get('coilNumberError') ? $get('coilNumberError') : null)
                     ->hintColor('danger')
                     ->required(),
+                Forms\Components\TextInput::make('observed_value')
+                    ->label('Observed Value')
+                    ->reactive()
+                    ->required(),
                 Forms\Components\Select::make('status')
                     ->label('Status')
                     ->options([
@@ -244,6 +248,11 @@ class CharacteristicValueResource extends Resource
                     ->searchable()
                     ->alignCenter()
                     ->sortable(),
+                Tables\Columns\TextColumn::make('observed_value')
+                    ->label('Observed value')
+                    ->searchable()
+                    ->alignCenter()
+                    ->sortable(),
                 Tables\Columns\TextColumn::make('status')
                     ->label('Status')
                     ->searchable()

app/Filament/Resources/InvoiceDataValidationResource.php

@@ -28,7 +28,7 @@ class InvoiceDataValidationResource extends Resource
 
     protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';
 
-    protected static ?string $navigationGroup = 'Invoice Management';
+    protected static ?string $navigationGroup = 'Manufacturing SD';
 
     public static function form(Form $form): Form
     {

app/Filament/Resources/InvoiceInTransitResource.php

@@ -0,0 +1,630 @@
+<?php
+
+namespace App\Filament\Resources;
+
+use App\Filament\Exports\InvoiceInTransitExporter;
+use App\Filament\Resources\InvoiceInTransitResource\Pages;
+use App\Filament\Resources\InvoiceInTransitResource\RelationManagers;
+use App\Models\InvoiceInTransit;
+use App\Models\Plant;
+use Filament\Facades\Filament;
+use Filament\Forms;
+use Filament\Forms\Form;
+use Filament\Notifications\Notification;
+use Filament\Resources\Resource;
+use Filament\Tables;
+use Filament\Tables\Table;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Database\Eloquent\SoftDeletingScope;
+use Filament\Forms\Components\FileUpload;
+use Storage;
+use Maatwebsite\Excel\Facades\Excel;
+use Filament\Tables\Actions\ExportAction;
+use Carbon\Carbon;
+use PhpOffice\PhpSpreadsheet\Shared\Date as ExcelDate;
+
+class InvoiceInTransitResource extends Resource
+{
+    protected static ?string $model = InvoiceInTransit::class;
+
+    protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';
+
+    protected static ?string $navigationGroup = 'Manufacturing SD';
+
+    public static function form(Form $form): Form
+    {
+        return $form
+            ->schema([
+                Forms\Components\Select::make('plant_id')
+                    ->relationship('plant', 'name')
+                    ->required(),
+                Forms\Components\TextInput::make('receiving_plant')
+                    ->label('Receiving Plant'),
+                Forms\Components\TextInput::make('receiving_plant_name')
+                    ->label('Receiving Plant Name'),
+                Forms\Components\TextInput::make('invoice_number')
+                    ->label('Invoice Number'),
+                Forms\Components\TextInput::make('invoice_date')
+                    ->label('Invoice Date'),
+                Forms\Components\TextInput::make('item_code')
+                    ->label('Item Code'),
+                Forms\Components\TextInput::make('description')
+                    ->label('Description'),
+                Forms\Components\TextInput::make('quantity')
+                    ->label('Quantity')
+                    ->numeric()
+                    ->default(null),
+                Forms\Components\TextInput::make('transport_name')
+                    ->label('Transport Name'),
+                Forms\Components\TextInput::make('lr_bl_aw_number')
+                    ->label('LR/BL/AW Number'),
+                Forms\Components\TextInput::make('lr_bl_aw_date')
+                    ->label('LR/BL/AW Date'),
+                Forms\Components\TextInput::make('pending_days')
+                    ->label('Pending Days'),
+                Forms\Components\TextInput::make('obd_number')
+                    ->label('OBD Number'),
+                Forms\Components\TextInput::make('obd_date')
+                    ->label('OBD Date'),
+                Forms\Components\TextInput::make('shipment_weight')
+                    ->label('Shipment Weight'),
+                Forms\Components\TextInput::make('unit_price')
+                    ->label('Unit Price'),
+                Forms\Components\TextInput::make('net_value')
+                    ->label('Net value'),
+                Forms\Components\TextInput::make('total_item_amount')
+                    ->label('Total Item Amount'),
+                Forms\Components\TextInput::make('tax_amount')
+                    ->label('Tax Amount'),
+                Forms\Components\TextInput::make('transport_mode')
+                    ->label('Transport Mode'),
+                Forms\Components\TextInput::make('vehicle_number')
+                    ->label('Vehicle Number'),
+                Forms\Components\TextInput::make('e_waybill_number')
+                    ->label('E Way Bill Number'),
+                Forms\Components\Hidden::make('created_by')
+                    ->label('Created By')
+                    ->default(Filament::auth()->user()?->name),
+                Forms\Components\Hidden::make('updated_by')
+                    ->label('Updated By')
+                    ->default(Filament::auth()->user()?->name),
+            ]);
+    }
+
+    public static function table(Table $table): Table
+    {
+        return $table
+            ->columns([
+                Tables\Columns\TextColumn::make('No.')
+                    ->label('No.')
+                    ->alignCenter()
+                    ->getStateUsing(function ($record, $livewire, $column, $rowLoop) {
+                        $paginator = $livewire->getTableRecords();
+                        $perPage = method_exists($paginator, 'perPage') ? $paginator->perPage() : 10;
+                        $currentPage = method_exists($paginator, 'currentPage') ? $paginator->currentPage() : 1;
+
+                        return ($currentPage - 1) * $perPage + $rowLoop->iteration;
+                    }),
+                Tables\Columns\TextColumn::make('plant.name')
+                    ->label('Plant')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('receiving_plant')
+                    ->label('Receiving Plant')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('receiving_plant_name')
+                    ->label('Receiving Plant Name')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('invoice_number')
+                    ->label('Invoice Number')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('invoice_date')
+                    ->label('Invoice Date')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('item_code')
+                    ->label('Item Code')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('description')
+                    ->label('Description')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('quantity')
+                    ->label('Quantity')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('transport_name')
+                    ->label('Transport Name')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('lr_bl_aw_number')
+                    ->label('LR/BL/AW Number')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('lr_bl_aw_date')
+                    ->label('LR/BL/AW Date')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('pending_days')
+                    ->label('Pending Days')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('obd_number')
+                    ->label('OBD Number')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('obd_date')
+                    ->label('OBD Date')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('shipment_weight')
+                    ->label('Shipment Weight')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('unit_price')
+                    ->label('Unit Price')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('net_value')
+                    ->label('Net value')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('total_item_amount')
+                    ->label('Total Item Amount')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('tax_amount')
+                    ->label('Tax Amount')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('transport_mode')
+                    ->label('Transport Mode')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('vehicle_number')
+                    ->label('Vehicle Number')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('e_waybill_number')
+                    ->label('E Way Bill Number')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('created_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('updated_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('deleted_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+            ])
+            ->filters([
+                Tables\Filters\TrashedFilter::make(),
+            ])
+            ->actions([
+                Tables\Actions\ViewAction::make(),
+                Tables\Actions\EditAction::make(),
+            ])
+            ->bulkActions([
+                Tables\Actions\BulkActionGroup::make([
+                    Tables\Actions\DeleteBulkAction::make(),
+                    Tables\Actions\ForceDeleteBulkAction::make(),
+                    Tables\Actions\RestoreBulkAction::make(),
+                ]),
+            ])
+            ->headerActions([
+                Tables\Actions\Action::make('Import Invoice In Transit')
+                    ->label('Import Invoice In Transit')
+                    ->form([
+                        FileUpload::make('invoice_in_transit_file')
+                            ->label('Import Invoice In Transit')
+                            ->preserveFilenames()
+                            ->storeFiles(false)
+                            ->reactive()
+                            ->required()
+                            ->disk('local')
+                            ->directory('uploads/temp'),
+                    ])
+                    ->action(function (array $data) {
+                        InvoiceInTransit::truncate();
+                        $uploadedFile = $data['invoice_in_transit_file'];
+
+                        $disk = Storage::disk('local');
+
+                        $user = Filament::auth()->user();
+
+                        $operatorName = $user->name;
+
+                        // Get original filename
+                        $originalName = $uploadedFile->getClientOriginalName();
+
+                        $path = $uploadedFile->storeAs('uploads/temp', $originalName, 'local'); // returns relative path
+
+                        $fullPath = Storage::disk('local')->path($path);
+
+                        if ($fullPath && file_exists($fullPath))
+                        {
+                            $rows = Excel::toArray(null, $fullPath)[0];
+
+                            if ((count($rows) - 1) <= 0) {
+                                Notification::make()
+                                    ->title('Records Not Found')
+                                    ->body("Import the valid 'Invoice Master Data' file to proceed..!")
+                                    ->danger()
+                                    ->send();
+
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            $invalidPlantCode = [];
+                            $invalidPlantCo = [];
+                            $invalidPlaCoFound = [];
+                            $invalidRecPlant = [];
+                            $invalidRecPlantName = [];
+                            $invalidInvNo = [];
+                            $invalidInvDt = [];
+                            $invalidICode = [];
+                            $invalidDesc = [];
+                            $invalidQty = [];
+                            $invalidTransportName = [];
+                            $invalidLRBLAWNo = [];
+                            $invalidLRBLAWDt = [];
+                            $invalidPenDay = [];
+
+
+                            foreach ($rows as $index => $row) {
+                                if ($index == 0) {
+                                    continue;
+                                }
+
+                                $plantCode = trim($row[0]);
+                                $receivingPlant = trim($row[2]);
+                                $receivingPlantName = trim($row[3]);
+                                $invoiceNo = trim($row[4]);
+                                $invoiceDt = trim($row[5]);
+                                $itemCode = trim($row[6]);
+                                $des = trim($row[7]);
+                                $quantity = trim($row[8]);
+                                $transportName = trim($row[9]);
+                                $LRBAWNo = trim($row[10]);
+                                $LRBAWDt = trim($row[11]);
+                                $pendingDays = trim($row[12]);
+
+                                if (empty($plantCode)) {
+                                    $invalidPlantCode[] = "Row {$index}";
+                                }
+                                if (empty($receivingPlant)) {
+                                    $invalidRecPlant[] = "Row {$index}";
+                                }
+                                if (empty($receivingPlantName)) {
+                                    $invalidRecPlantName[] = "Row {$index}";
+                                }
+                                if (empty($invoiceNo)) {
+                                    $invalidInvNo[] = "Row {$index}";
+                                }
+                                if (empty($invoiceDt)) {
+                                    $invalidInvDt[] = "Row {$index}";
+                                }
+                                if (empty($itemCode)) {
+                                    $invalidICode[] = "Row {$index}";
+                                }
+                                if (empty($des)) {
+                                    $invalidDesc[] = "Row {$index}";
+                                }
+                                if (empty($quantity)) {
+                                    $invalidQty[] = "Row {$index}";
+                                }
+                                if (empty($transportName)) {
+                                    $invalidTransportName[] = "Row {$index}";
+                                }
+                                if (empty($LRBAWNo)) {
+                                    $invalidLRBLAWNo[] = "Row {$index}";
+                                }
+                                if (empty($LRBAWDt)) {
+                                    $invalidLRBLAWDt[] = "Row {$index}";
+                                }
+                                if (empty($pendingDays)) {
+                                    $invalidPenDay[] = "Row {$index}";
+                                }
+
+                                if (strlen($plantCode) < 4) {
+                                    $invalidPlantCo[] = $plantCode;
+                                } elseif (! Plant::where('code', $plantCode)->first()) {
+                                    $invalidPlaCoFound[] = $plantCode;
+                                }
+
+                                $plant = Plant::where('code', $plantCode)->first();
+
+                                //$plantId = $plant->id;
+
+                            }
+
+                            if (! empty($invalidPlantCode) || ! empty($invalidRecPlant) || ! empty($invalidRecPlantName) || ! empty($invalidInvNo) || ! empty($invalidInvDt) || ! empty($invalidICode) || ! empty($invalidDesc) || ! empty($invalidQty) || ($invalidTransportName) || ! empty($invalidLRBLAWNo) || ! empty($invalidLRBLAWDt) || ! empty($invalidPenDay)) {
+                                $errorMsg = '';
+
+                                if (! empty($invalidPlantCode)) {
+                                    $errorMsg .= 'Missing Receiving Plant in rows: '.implode(', ', $invalidPlantCode).'<br>';
+                                }
+                                if (! empty($invalidRecPlant)) {
+                                    $errorMsg .= 'Missing Receiving Plant Name in rows: '.implode(', ', $invalidRecPlant).'<br>';
+                                }
+                                if (! empty($invalidRecPlantName)) {
+                                    $errorMsg .= 'Missing Transit Days in rows: '.implode(', ', $invalidRecPlantName).'<br>';
+                                }
+                                if (! empty($invalidInvNo)) {
+                                    $errorMsg .= 'Missing Transport Name in rows: '.implode(', ', $invalidInvNo).'<br>';
+                                }
+                                if (! empty($invalidInvDt)) {
+                                    $errorMsg .= 'Missing Receiving Plant in rows: '.implode(', ', $invalidInvDt).'<br>';
+                                }
+                                if (! empty($invalidICode)) {
+                                    $errorMsg .= 'Missing Receiving Plant Name in rows: '.implode(', ', $invalidICode).'<br>';
+                                }
+                                if (! empty($invalidDesc)) {
+                                    $errorMsg .= 'Missing Transit Days in rows: '.implode(', ', $invalidDesc).'<br>';
+                                }
+                                if (! empty($invalidQty)) {
+                                    $errorMsg .= 'Missing Transport Name in rows: '.implode(', ', $invalidQty).'<br>';
+                                }
+                                if (! empty($invalidTransportName)) {
+                                    $errorMsg .= 'Missing Receiving Plant in rows: '.implode(', ', $invalidTransportName).'<br>';
+                                }
+                                if (! empty($invalidLRBLAWNo)) {
+                                    $errorMsg .= 'Missing Receiving Plant Name in rows: '.implode(', ', $invalidLRBLAWNo).'<br>';
+                                }
+                                if (! empty($invalidLRBLAWDt)) {
+                                    $errorMsg .= 'Missing Transit Days in rows: '.implode(', ', $invalidLRBLAWDt).'<br>';
+                                }
+                                if (! empty($invalidPenDay)) {
+                                    $errorMsg .= 'Missing Transport Name in rows: '.implode(', ', $invalidPenDay).'<br>';
+                                }
+
+                                Notification::make()
+                                    ->title('Missing Mandatory Fields')
+                                    ->body($errorMsg)
+                                    ->danger()
+                                    ->send();
+
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            if (! empty($invalidPlantCo)) {
+                                $invalidPlantCode = array_unique($invalidPlantCo);
+                                Notification::make()
+                                    ->title('Invalid Plant Codes')
+                                    ->body('The following plant codes should contain minimum 4 digits:<br>'.implode(', ', $invalidPlantCode))
+                                    ->danger()
+                                    ->send();
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            if (! empty($invalidPlaCoFound)) {
+                                $invalidPlaCoFound = array_unique($invalidPlaCoFound);
+                                Notification::make()
+                                    ->title('Invalid Plant Codes')
+                                    ->body('The following plant codes not found in plants:<br>'.implode(', ', $invalidPlaCoFound))
+                                    ->danger()
+                                    ->send();
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            $mandatoryColumns = 23;
+
+                            $firstRow = $rows[0] ?? [];
+
+                            if (count($firstRow) < $mandatoryColumns) {
+
+                                Notification::make()
+                                    ->title('Invalid Excel Format')
+                                    ->body('Few columns not found. Columns A to W are mandatory.')
+                                    ->danger()
+                                    ->persistent()
+                                    ->send();
+
+                                return;
+                            }
+
+                            foreach ($rows as $index => $row)
+                            {
+                                if ($index == 0) {
+                                    continue;
+                                }
+
+                                $plantCode = trim($row[0]);
+                                $receivingPlant = trim($row[2]);
+                                $receivingPlantName = trim($row[3]);
+                                $invoiceNo = trim($row[4]);
+                                $invoiceDt = trim($row[5]);
+                                $itemCode = trim($row[6]);
+                                $des = trim($row[7]);
+                                $quantity = trim($row[8]);
+                                $transportName = trim($row[9]);
+                                $LRBAWNo = trim($row[10]);
+                                $LRBAWDt = trim($row[11]);
+                                $pendingDays = trim($row[12]);
+                                $OBDNumber = trim($row[13]);
+                                $OBDDate = trim($row[14]);
+                                $ShipmentWeight = trim($row[15]);
+                                $UnitPrice = trim($row[16]);
+                                $NetValue = trim($row[17]);
+                                $TotalItemAmount = trim($row[18]);
+                                $TaxAmount = trim($row[19]);
+                                $TransportMode = trim($row[20]);
+                                $VehicleNumber = trim($row[21]);
+                                $EWayBillNumber = trim($row[22]);
+
+                                $plant = Plant::where('code', $plantCode)->first();
+                                if (! $plant) {
+                                    throw new \Exception("Invalid plant code : '{$plantCode}'");
+                                }
+
+                                if (! empty($invoiceDt))
+                                {
+                                    if (preg_match('/^\d{2}[-\/]\d{2}[-\/]\d{4}$/', $invoiceDt)) {
+                                        [$day, $month, $year] = preg_split('/[-\/]/', $invoiceDt);
+                                        $formattedDate = "{$year}-{$month}-{$day}";
+                                    } elseif (is_numeric($invoiceDt)) {
+                                        $formattedDate = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($invoiceDt)->format('Y-m-d');
+                                    } else {
+                                        $formattedDate = date('Y-m-d', strtotime($invoiceDt));
+                                    }
+                                } else {
+                                    $formattedDate = null;
+                                }
+                                if (! empty($LRBAWDt))
+                                {
+                                    if (preg_match('/^\d{2}[-\/]\d{2}[-\/]\d{4}$/', $LRBAWDt)) {
+                                        [$day, $month, $year] = preg_split('/[-\/]/', $LRBAWDt);
+                                        $formattedDt = "{$year}-{$month}-{$day}";
+                                    } elseif (is_numeric($LRBAWDt)) {
+                                        $formattedDt = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($LRBAWDt)->format('Y-m-d');
+                                    } else {
+                                        $formattedDt = date('Y-m-d', strtotime($LRBAWDt));
+                                    }
+                                } else {
+                                    $formattedDt = null;
+                                }
+                                if (! empty($OBDDate))
+                                {
+                                    if (preg_match('/^\d{2}[-\/]\d{2}[-\/]\d{4}$/', $OBDDate)) {
+                                        [$day, $month, $year] = preg_split('/[-\/]/', $OBDDate);
+                                        $formattedDate = "{$year}-{$month}-{$day}";
+                                    } elseif (is_numeric($OBDDate)) {
+                                        $formatted = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($OBDDate)->format('Y-m-d');
+                                    } else {
+                                        $formatted = date('Y-m-d', strtotime($OBDDate));
+                                    }
+                                } else {
+                                    $formatted = null;
+                                }
+
+                                $inserted = InvoiceInTransit::create([
+                                    'plant_id' => $plant->id,
+                                    'receiving_plant' => $receivingPlant,
+                                    'receiving_plant_name' => $receivingPlantName,
+                                    'invoice_number' => $invoiceNo,
+                                    'invoice_date' => $formattedDate,
+                                    'item_code' => $itemCode,
+                                    'description' => $des,
+                                    'quantity' => $quantity,
+                                    'transport_name' => $transportName,
+                                    'lr_bl_aw_number' => $LRBAWNo,
+                                    'lr_bl_aw_date' => $formattedDt,
+                                    'pending_days' => $pendingDays,
+                                    'obd_number' => $OBDNumber,
+                                    'obd_date' => $formatted,
+                                    'shipment_weight' => $ShipmentWeight,
+                                    'unit_price' => $UnitPrice,
+                                    'net_value' => $NetValue,
+                                    'total_item_amount' => $TotalItemAmount,
+                                    'tax_amount' => $TaxAmount,
+                                    'transport_mode' => $TransportMode,
+                                    'vehicle_number' => $VehicleNumber,
+                                    'e_waybill_number' => $EWayBillNumber,
+                                    'created_at' => now(),
+                                    'created_by' => $operatorName,
+                                ]);
+                            }
+                            if ($inserted) {
+                                Notification::make()
+                                    ->title('Upload Success')
+                                    ->body('Invoice in transit uploaded successfully!')
+                                    ->success()
+                                    ->send();
+                                return;
+                            }
+                            else
+                            {
+                                Notification::make()
+                                    ->title('Insertion Failed')
+                                    ->body('Invoice in transit upload failed!')
+                                    ->success()
+                                    ->send();
+                                return;
+                            }
+                        }
+                    })
+                    ->visible(function () {
+                        return Filament::auth()->user()->can('view import invoice in transit');
+                    }),
+                ExportAction::make()
+                    ->label('Export Invoice In Transit')
+                    ->color('warning')
+                    ->exporter(InvoiceInTransitExporter::class)
+                    ->visible(function () {
+                        return Filament::auth()->user()->can('view export invoice in transit');
+                    }),
+            ]);
+    }
+
+    public static function getRelations(): array
+    {
+        return [
+            //
+        ];
+    }
+
+    public static function getPages(): array
+    {
+        return [
+            'index' => Pages\ListInvoiceInTransits::route('/'),
+            'create' => Pages\CreateInvoiceInTransit::route('/create'),
+            'view' => Pages\ViewInvoiceInTransit::route('/{record}'),
+            'edit' => Pages\EditInvoiceInTransit::route('/{record}/edit'),
+        ];
+    }
+
+    public static function getEloquentQuery(): Builder
+    {
+        return parent::getEloquentQuery()
+            ->withoutGlobalScopes([
+                SoftDeletingScope::class,
+            ]);
+    }
+}

app/Filament/Resources/InvoiceInTransitResource/Pages/CreateInvoiceInTransit.php

@@ -0,0 +1,12 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceInTransitResource\Pages;
+
+use App\Filament\Resources\InvoiceInTransitResource;
+use Filament\Actions;
+use Filament\Resources\Pages\CreateRecord;
+
+class CreateInvoiceInTransit extends CreateRecord
+{
+    protected static string $resource = InvoiceInTransitResource::class;
+}

app/Filament/Resources/InvoiceInTransitResource/Pages/EditInvoiceInTransit.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceInTransitResource\Pages;
+
+use App\Filament\Resources\InvoiceInTransitResource;
+use Filament\Actions;
+use Filament\Resources\Pages\EditRecord;
+
+class EditInvoiceInTransit extends EditRecord
+{
+    protected static string $resource = InvoiceInTransitResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\ViewAction::make(),
+            Actions\DeleteAction::make(),
+            Actions\ForceDeleteAction::make(),
+            Actions\RestoreAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceInTransitResource/Pages/ListInvoiceInTransits.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceInTransitResource\Pages;
+
+use App\Filament\Resources\InvoiceInTransitResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ListRecords;
+
+class ListInvoiceInTransits extends ListRecords
+{
+    protected static string $resource = InvoiceInTransitResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\CreateAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceInTransitResource/Pages/ViewInvoiceInTransit.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceInTransitResource\Pages;
+
+use App\Filament\Resources\InvoiceInTransitResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ViewRecord;
+
+class ViewInvoiceInTransit extends ViewRecord
+{
+    protected static string $resource = InvoiceInTransitResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\EditAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceMasterResource.php

@@ -0,0 +1,301 @@
+<?php
+
+namespace App\Filament\Resources;
+
+use App\Filament\Exports\InvoiceMasterExporter;
+use App\Filament\Resources\InvoiceMasterResource\Pages;
+use App\Filament\Resources\InvoiceMasterResource\RelationManagers;
+use App\Models\InvoiceMaster;
+use Filament\Facades\Filament;
+use Filament\Forms;
+use Filament\Forms\Form;
+use Filament\Notifications\Notification;
+use Filament\Resources\Resource;
+use Filament\Tables;
+use Filament\Tables\Table;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Database\Eloquent\SoftDeletingScope;
+use Filament\Tables\Actions\ExportAction;
+use Storage;
+use Maatwebsite\Excel\Facades\Excel;
+use Filament\Forms\Components\FileUpload;
+
+class InvoiceMasterResource extends Resource
+{
+    protected static ?string $model = InvoiceMaster::class;
+
+    protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';
+
+    protected static ?string $navigationGroup = 'Manufacturing SD';
+
+    public static function form(Form $form): Form
+    {
+        return $form
+            ->schema([
+                Forms\Components\TextInput::make('receiving_plant')
+                    ->label('Receiving Plant'),
+                Forms\Components\TextInput::make('receiving_plant_name')
+                    ->label('Receiving Plant Name'),
+                Forms\Components\TextInput::make('transit_days')
+                    ->label('Transit Days'),
+                Forms\Components\TextInput::make('transport_name')
+                    ->label('Transport Name'),
+                Forms\Components\Hidden::make('created_by')
+                    ->label('Created By')
+                    ->default(Filament::auth()->user()?->name),
+                Forms\Components\Hidden::make('updated_by')
+                    ->label('Updated By')
+                    ->default(Filament::auth()->user()?->name),
+            ]);
+    }
+
+    public static function table(Table $table): Table
+    {
+        return $table
+            ->columns([
+                Tables\Columns\TextColumn::make('No.')
+                    ->label('No.')
+                    ->alignCenter()
+                    ->getStateUsing(function ($record, $livewire, $column, $rowLoop) {
+                        $paginator = $livewire->getTableRecords();
+                        $perPage = method_exists($paginator, 'perPage') ? $paginator->perPage() : 10;
+                        $currentPage = method_exists($paginator, 'currentPage') ? $paginator->currentPage() : 1;
+
+                        return ($currentPage - 1) * $perPage + $rowLoop->iteration;
+                    }),
+                Tables\Columns\TextColumn::make('receiving_plant')
+                    ->label('Receiving Plant')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('receiving_plant_name')
+                    ->label('Receiving Plant Name')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('transit_days')
+                    ->label('Transit Days')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('transport_name')
+                    ->label('Transport Name')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('created_at')
+                    ->label('Created At')
+                    ->alignCenter()
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('updated_at')
+                    ->label('Updated At')
+                    ->alignCenter()
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('deleted_at')
+                    ->label('Deleted At')
+                    ->alignCenter()
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+            ])
+            ->filters([
+                Tables\Filters\TrashedFilter::make(),
+            ])
+            ->actions([
+                Tables\Actions\ViewAction::make(),
+                Tables\Actions\EditAction::make(),
+            ])
+            ->bulkActions([
+                Tables\Actions\BulkActionGroup::make([
+                    Tables\Actions\DeleteBulkAction::make(),
+                    Tables\Actions\ForceDeleteBulkAction::make(),
+                    Tables\Actions\RestoreBulkAction::make(),
+                ]),
+            ])
+            ->headerActions([
+                Tables\Actions\Action::make('Import Invoice Master')
+                    ->label('Import Invoice Master')
+                    ->form([
+                        FileUpload::make('invoice_master_file')
+                            ->label('Import Invoice Master')
+                            ->preserveFilenames()
+                            ->storeFiles(false)
+                            ->reactive()
+                            ->required()
+                            ->disk('local')
+                            ->directory('uploads/temp'),
+                    ])
+                    ->action(function (array $data) {
+                        $uploadedFile = $data['invoice_master_file'];
+
+                        $disk = Storage::disk('local');
+
+                        $user = Filament::auth()->user();
+
+                        $operatorName = $user->name;
+
+                        // Get original filename
+                        $originalName = $uploadedFile->getClientOriginalName();
+
+                        $path = $uploadedFile->storeAs('uploads/temp', $originalName, 'local'); // returns relative path
+
+                        $fullPath = Storage::disk('local')->path($path);
+
+                        if ($fullPath && file_exists($fullPath))
+                        {
+                            $rows = Excel::toArray(null, $fullPath)[0];
+
+                            if ((count($rows) - 1) <= 0) {
+                                Notification::make()
+                                    ->title('Records Not Found')
+                                    ->body("Import the valid 'Invoice Master Data' file to proceed..!")
+                                    ->danger()
+                                    ->send();
+
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            $invalidReceivePlant = [];
+                            $invalidReceivePlantName = [];
+                            $invalidTransitDays = [];
+                            $invalidTransportName = [];
+
+                            foreach ($rows as $index => $row) {
+                                if ($index == 0) {
+                                    continue;
+                                }
+
+                                $receivingPlant = trim($row[0]);
+                                $receivingPlantName = trim($row[1]);
+                                $transitDays = trim($row[2]);
+                                $transportName = trim($row[3]);
+
+                                if (empty($receivingPlant)) {
+                                    $invalidReceivePlant[] = "Row {$index}";
+                                }
+                                if (empty($receivingPlantName)) {
+                                    $invalidReceivePlantName[] = "Row {$index}";
+                                }
+                                if (empty($transitDays)) {
+                                    $invalidTransitDays[] = "Row {$index}";
+                                }
+                                if (empty($transportName)) {
+                                    $invalidTransportName[] = "Row {$index}";
+                                }
+
+                            }
+
+                            if (! empty($invalidReceivePlant) || ! empty($invalidReceivePlantName) || ! empty($invalidTransitDays) || ! empty($invalidTransportName)) {
+                                $errorMsg = '';
+
+                                if (! empty($invalidReceivePlant)) {
+                                    $errorMsg .= 'Missing Receiving Plant in rows: '.implode(', ', $invalidReceivePlant).'<br>';
+                                }
+                                if (! empty($invalidReceivePlantName)) {
+                                    $errorMsg .= 'Missing Receiving Plant Name in rows: '.implode(', ', $invalidReceivePlantName).'<br>';
+                                }
+                                if (! empty($invalidTransitDays)) {
+                                    $errorMsg .= 'Missing Transit Days in rows: '.implode(', ', $invalidTransitDays).'<br>';
+                                }
+                                if (! empty($invalidTransportName)) {
+                                    $errorMsg .= 'Missing Transport Name in rows: '.implode(', ', $invalidTransportName).'<br>';
+                                }
+
+                                Notification::make()
+                                    ->title('Missing Mandatory Fields')
+                                    ->body($errorMsg)
+                                    ->danger()
+                                    ->send();
+
+                                if ($disk->exists($path)) {
+                                    $disk->delete($path);
+                                }
+
+                                return;
+                            }
+
+                            foreach ($rows as $index => $row)
+                            {
+                                if ($index == 0) {
+                                    continue;
+                                }
+
+                                $receivingPlant = trim($row[0]);
+                                $receivingPlantName = trim($row[1]);
+                                $transitDays = trim($row[2]);
+                                $transportName = trim($row[3]);
+
+                                $inserted = InvoiceMaster::create([
+                                    'receiving_plant' => $receivingPlant,
+                                    'receiving_plant_name' => $receivingPlantName,
+                                    'transit_days' => $transitDays,
+                                    'transport_name' => $transportName,
+                                    'created_at' => now(),
+                                    'created_by' => $operatorName,
+                                ]);
+                            }
+                            if ($inserted) {
+                                Notification::make()
+                                    ->title('Upload Success')
+                                    ->body('Invoice master uploaded successfully!')
+                                    ->success()
+                                    ->send();
+                                return;
+                            }
+                            else
+                            {
+                                Notification::make()
+                                    ->title('Insertion Failed')
+                                    ->body('Invoice master upload failed!')
+                                    ->success()
+                                    ->send();
+                                return;
+                            }
+                        }
+                    })
+                    ->visible(function () {
+                        return Filament::auth()->user()->can('view import invoice master');
+                    }),
+                ExportAction::make()
+                    ->label('Export Invoice Master')
+                    ->color('warning')
+                    ->exporter(InvoiceMasterExporter::class)
+                    ->visible(function () {
+                        return Filament::auth()->user()->can('view export invoice master');
+                    }),
+            ]);
+    }
+
+    public static function getRelations(): array
+    {
+        return [
+            //
+        ];
+    }
+
+    public static function getPages(): array
+    {
+        return [
+            'index' => Pages\ListInvoiceMasters::route('/'),
+            'create' => Pages\CreateInvoiceMaster::route('/create'),
+            'view' => Pages\ViewInvoiceMaster::route('/{record}'),
+            'edit' => Pages\EditInvoiceMaster::route('/{record}/edit'),
+        ];
+    }
+
+    public static function getEloquentQuery(): Builder
+    {
+        return parent::getEloquentQuery()
+            ->withoutGlobalScopes([
+                SoftDeletingScope::class,
+            ]);
+    }
+}

app/Filament/Resources/InvoiceMasterResource/Pages/CreateInvoiceMaster.php

@@ -0,0 +1,12 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceMasterResource\Pages;
+
+use App\Filament\Resources\InvoiceMasterResource;
+use Filament\Actions;
+use Filament\Resources\Pages\CreateRecord;
+
+class CreateInvoiceMaster extends CreateRecord
+{
+    protected static string $resource = InvoiceMasterResource::class;
+}

app/Filament/Resources/InvoiceMasterResource/Pages/EditInvoiceMaster.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceMasterResource\Pages;
+
+use App\Filament\Resources\InvoiceMasterResource;
+use Filament\Actions;
+use Filament\Resources\Pages\EditRecord;
+
+class EditInvoiceMaster extends EditRecord
+{
+    protected static string $resource = InvoiceMasterResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\ViewAction::make(),
+            Actions\DeleteAction::make(),
+            Actions\ForceDeleteAction::make(),
+            Actions\RestoreAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceMasterResource/Pages/ListInvoiceMasters.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceMasterResource\Pages;
+
+use App\Filament\Resources\InvoiceMasterResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ListRecords;
+
+class ListInvoiceMasters extends ListRecords
+{
+    protected static string $resource = InvoiceMasterResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\CreateAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceMasterResource/Pages/ViewInvoiceMaster.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\InvoiceMasterResource\Pages;
+
+use App\Filament\Resources\InvoiceMasterResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ViewRecord;
+
+class ViewInvoiceMaster extends ViewRecord
+{
+    protected static string $resource = InvoiceMasterResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\EditAction::make(),
+        ];
+    }
+}

app/Filament/Resources/InvoiceOutValidationResource.php

@@ -30,7 +30,7 @@ class InvoiceOutValidationResource extends Resource
 
     protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';
 
-    protected static ?string $navigationGroup = 'Invoice Management';
+    protected static ?string $navigationGroup = 'Manufacturing SD';
 
     public static function form(Form $form): Form
     {

app/Filament/Resources/InvoiceValidationResource/Pages/CreateInvoiceValidation.php

@@ -53,6 +53,7 @@ class CreateInvoiceValidation extends CreateRecord
     public bool $showCapacitorInput = false;
 
     public $excel_file;
+    public $mInvoiceNo;
 
     public function getFormActions(): array
     {
@@ -103,6 +104,8 @@ class CreateInvoiceValidation extends CreateRecord
     {
         $invoiceNumber = trim($invoiceNumber);
 
+        $parts = explode('.', $invoiceNumber);
+
         $this->showCapacitorInput = false;
 
         $user = Filament::auth()->user();
@@ -118,6 +121,62 @@ class CreateInvoiceValidation extends CreateRecord
 
         // ..GET SERIAL INVOICE API
 
+        if(strlen($invoiceNumber) > 15)
+        {
+
+            $payloadJson = base64_decode(strtr($parts[1], '-_', '+/'));
+
+            if (empty($payloadJson)) {
+                Notification::make()
+                    ->title('Invalid payload for scanned qr code.')
+                    ->danger()
+                    ->seconds(1)
+                    ->send();
+                return;
+            }
+
+            $payload = json_decode($payloadJson, true);
+
+
+            if (!isset($payload['data'])) {
+                Notification::make()
+                    ->title('Invalid payload for scanned qr code.')
+                    ->info()
+                    ->seconds(1)
+                    ->send();
+                return;
+            }
+
+            $documentData = $payload['data'];
+
+            if($documentData == '' || $documentData == ''){
+                Notification::make()
+                    ->title('Invalid payload for scanned qr code.')
+                    ->info()
+                    ->seconds(1)
+                    ->send();
+                return;
+            }
+
+                // Extract DocNo
+            preg_match('/"DocNo"\s*:\s*"([^"]+)"/', $documentData, $matches);
+
+            if (!isset($matches[1])) {
+                Notification::make()
+                    ->title('Invoice number not found.')
+                    ->info()
+                    ->seconds(1)
+                    ->send();
+                return;
+            }
+
+            if (isset($matches[1])) {
+                $invoiceNumber = $matches[1];
+            }
+        }
+
+        //dd($invoiceNumber);
+
         // ..
 
         $updateStatus = $this->form->getState()['update_invoice'] ?? null;
@@ -2742,19 +2801,6 @@ class CreateInvoiceValidation extends CreateRecord
                         ->send();
                     $this->dispatch('playWarnSound');
 
-                    // $mailData = $this->getMail();
-                    // $mPlantName = $mailData['plant_name'];
-                    // $emails = $mailData['emails'];
-                    // $mInvoiceType = 'Material';
-
-                    // if (! empty($emails)) {
-                    //     Mail::to($emails)->send(
-                    //         new InvalidSerialMail($mSerNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, 'ItemNotValidMaterialType')
-                    //     );
-                    // } else {
-                    //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                    // }
-
                     $this->form->fill([
                         'plant_id' => $plantId,
                         'invoice_number' => $invoiceNumber,
@@ -2784,19 +2830,6 @@ class CreateInvoiceValidation extends CreateRecord
                         ->send();
                     $this->dispatch('playWarnSound');
 
-                    // $mailData = $this->getMail();
-                    // $mPlantName = $mailData['plant_name'];
-                    // $emails = $mailData['emails'];
-                    // $mInvoiceType = 'Material';
-
-                    // if (! empty($emails)) {
-                    //     Mail::to($emails)->send(
-                    //         new InvalidSerialMail($mSerNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, 'ItemNotInvoice')
-                    //     );
-                    // } else {
-                    //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                    // }
-
                     $this->form->fill([
                         'plant_id' => $plantId,
                         'invoice_number' => $invoiceNumber,
@@ -2825,19 +2858,6 @@ class CreateInvoiceValidation extends CreateRecord
                         ->send();
                     $this->dispatch('playWarnSound');
 
-                    // $mailData = $this->getMail();
-                    // $mPlantName = $mailData['plant_name'];
-                    // $emails = $mailData['emails'];
-                    // $mInvoiceType = 'Material';
-
-                    // if (! empty($emails)) {
-                    //     Mail::to($emails)->send(
-                    //         new InvalidSerialMail($mSerNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, 'Item')
-                    //     );
-                    // } else {
-                    //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                    // }
-
                     $this->form->fill([
                         'plant_id' => $plantId,
                         'invoice_number' => $invoiceNumber,
@@ -3381,19 +3401,6 @@ class CreateInvoiceValidation extends CreateRecord
                                 ->send();
                             $this->dispatch('playNotificationSound');
 
-                            // $mInvoiceType = 'Serial';
-                            // $mailData = $this->getMail();
-                            // $mPlantName = $mailData['plant_name'];
-                            // $emails = $mailData['emails'];
-
-                            // if (! empty($emails)) {
-                            //     Mail::to($emails)->send(
-                            //         new InvalidSerialMail($serNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, 'CompletedSerialInvoice')
-                            //     );
-                            // } else {
-                            //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                            // }
-
                             $filename = $invoiceNumber.'.xlsx';
                             $directory = 'uploads/temp';
                             $disk = Storage::disk('local');
@@ -3511,20 +3518,6 @@ class CreateInvoiceValidation extends CreateRecord
 
                             $this->dispatch('playNotificationSound');
 
-                            // $mInvoiceType = 'Serial';
-                            // $mailData = $this->getMail();
-                            // $mPlantName = $mailData['plant_name'];
-                            // $emails = $mailData['emails'];
-
-                            // if (! empty($emails)) {
-                            //     // Mail::to($emails)->send(new InvalidSerialMail($serNo, $invoiceNumber, $mPlantName, $mInvoiceType));
-                            //     Mail::to($emails)->send(
-                            //         new InvalidSerialMail($serNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, 'CSerialInvoice')
-                            //     );
-                            // } else {
-                            //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                            // }
-
                             $filename = $invoiceNumber.'.xlsx';
                             $directory = 'uploads/temp';
                             $disk = Storage::disk('local');
@@ -3584,22 +3577,6 @@ class CreateInvoiceValidation extends CreateRecord
 
                             $this->dispatch('playWarnSound');
 
-                            // $mInvoiceType = 'Serial';
-                            // $mailData = $this->getMail();
-                            // $mPlantName = $mailData['plant_name'];
-                            // $emails = $mailData['emails'];
-
-                            // $mUserName = Filament::auth()->user()->name;
-
-                            // if (! empty($emails)) {
-                            //     // Mail::to($emails)->send(new InvalidSerialMail($serNo, $invoiceNumber, $mPlantName, $mInvoiceType));
-                            //     Mail::to($emails)->send(
-                            //         new InvalidSerialMail($serNo, $invoiceNumber, $mPlantName, $mInvoiceType, $itemCode, $mUserName, 'DuplicateCapacitorQR')
-                            //     );
-                            // } else {
-                            //     \Log::warning("No recipients found for plant {$plantId}, module Serial, rule invalid_serial.");
-                            // }
-
                             $this->form->fill([
                                 'plant_id' => $plantId,
                                 'invoice_number' => $invoiceNumber,

app/Filament/Resources/ProcessOrderResource.php

@@ -30,6 +30,10 @@ use Filament\Forms\Components\Select;
 use App\Models\Line;
 use Filament\Forms\Components\TextInput;
 use App\Models\Item;
+use App\Models\User;
+
+// use App\Models\PalletValidation;
+// use Dom\Text;
 
 class ProcessOrderResource extends Resource
 {
@@ -81,7 +85,7 @@ class ProcessOrderResource extends Resource
                             return [];
                         }
 
-                        return \App\Models\Item::where('plant_id', $plantId)->pluck('code', 'id');
+                        return Item::where('plant_id', $plantId)->pluck('code', 'id');
                     })
                     ->afterStateUpdated(function (callable $set, callable $get, ?string $state) {
                         $plantId = $get('plant_id');
@@ -90,20 +94,23 @@ class ProcessOrderResource extends Resource
 
                         if ($plantId && $itemId) {
                             // Get the item code using item_id
-                            $itemCode = \App\Models\Item::where('id', $itemId)->value('code');
+                            $itemCode = Item::where('id', $itemId)->value('code');
 
                             if ($itemCode) {
                                 // Now get the item description using plant_id + code
-                                $item = \App\Models\Item::where('plant_id', $plantId)
+                                $item = Item::where('plant_id', $plantId)
                                     ->where('code', $itemCode)
                                     ->first();
 
                                 $set('item_description', $item?->description);
+                                $set('item_uom', $item?->uom);
                             } else {
                                 $set('item_description', null);
+                                $set('item_uom', null);
                             }
                         } else {
                             $set('item_description', null);
+                            $set('item_uom', null);
                         }
                     })
                     ->required(),
@@ -115,7 +122,7 @@ class ProcessOrderResource extends Resource
                     ->afterStateHydrated(function ($component, $state, Get $get, Set $set) {
                         $itemId = $get('item_id');
                         if ($get('id')) {
-                            $item = \App\Models\Item::where('id', $itemId)->first()?->description;
+                            $item = Item::where('id', $itemId)->first()?->description;
                             if ($item) {
                                 $set('item_description', $item);
                             } else {
@@ -124,6 +131,22 @@ class ProcessOrderResource extends Resource
                         }
                     }),
 
+                Forms\Components\TextInput::make('item_uom')
+                    ->label('UOM')
+                    ->required()
+                    ->reactive()
+                    ->afterStateHydrated(function ($component, $state, Get $get, Set $set) {
+                        $itemId = $get('item_id');
+                        if ($get('id')) {
+                            $item = Item::where('id', $itemId)->first()?->uom;
+                            if ($item) {
+                                $set('item_uom', $item);
+                            } else {
+                                $set('item_uom', null);
+                            }
+                        }
+                    }),
+
                 Forms\Components\TextInput::make('id')
                     ->hidden()
                     ->readOnly(),
@@ -265,10 +288,16 @@ class ProcessOrderResource extends Resource
                     ->disk('local')
                     ->directory('uploads/temp')
                     ->preserveFilenames()
+                    ->visible(function() {
+                        return Filament::auth()->user()->can('view process order packing slip');
+                    })
                     ->reactive(),
                 Forms\Components\Actions::make([
                     Action::make('uploadNow')
                         ->label('Upload PDF Now')
+                        ->visible(function() {
+                            return Filament::auth()->user()->can('view process order packing slip');
+                        })
                         ->action(function ($get, callable $set) {
                             $uploadedFiles = $get('attachment');
 
@@ -356,6 +385,9 @@ class ProcessOrderResource extends Resource
 
                     Action::make('downloadAttachment')
                         ->label('Download PDF')
+                        ->visible(function() {
+                            return Filament::auth()->user()->can('view process order packing slip');
+                        })
                         ->action(function ($get) {
                             $equipmentNumber = $get('process_order');
 
@@ -450,7 +482,6 @@ class ProcessOrderResource extends Resource
                         $paginator = $livewire->getTableRecords();
                         $perPage = method_exists($paginator, 'perPage') ? $paginator->perPage() : 10;
                         $currentPage = method_exists($paginator, 'currentPage') ? $paginator->currentPage() : 1;
-
                         return ($currentPage - 1) * $perPage + $rowLoop->iteration;
                     }),
                 Tables\Columns\TextColumn::make('plant.name')
@@ -468,6 +499,11 @@ class ProcessOrderResource extends Resource
                     ->alignCenter()
                     ->searchable()
                     ->sortable(),
+                Tables\Columns\TextColumn::make('item.uom')
+                    ->label('Uom')
+                    ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
                 Tables\Columns\TextColumn::make('process_order')
                     ->label('Process Order')
                     ->alignCenter()
@@ -528,8 +564,7 @@ class ProcessOrderResource extends Resource
             // ->filters([
             //     Tables\Filters\TrashedFilter::make(),
             // ])
-             ->filters([
-
+            ->filters([
             Tables\Filters\TrashedFilter::make(),
             Filter::make('advanced_filters')
                 ->label('Advanced Filters')
@@ -548,10 +583,17 @@ class ProcessOrderResource extends Resource
                     Select::make('Item')
                         ->label('Item Code')
                         ->nullable()
+                        ->searchable()
                         ->options(function (callable $get) {
                                 $plantId = $get('Plant');
 
-                                return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                                if(empty($plantId)) {
+                                    return [];
+                                }
+
+                                return Item::where('plant_id', $plantId)->pluck('code', 'id');
+
+                                //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
                             })
                         ->reactive()
                         ->afterStateUpdated(function ($state, callable $set, callable $get) {
@@ -611,8 +653,6 @@ class ProcessOrderResource extends Resource
                     if (!empty($data['created_to'])) {
                         $query->where('created_at', '<=', $data['created_to']);
                     }
-
-
                     //$query->orderBy('created_at', 'asc');
                 })
                 ->indicateUsing(function (array $data) {
@@ -662,6 +702,130 @@ class ProcessOrderResource extends Resource
                 ]),
             ])
             ->headerActions([
+                Tables\Actions\Action::make('reprint_process')
+                    ->label('Re-Print Process Order')
+                    ->form([
+                        Forms\Components\Section::make()
+                            ->schema([
+                                Forms\Components\Select::make('plant')
+                                    ->label('Select Plant')
+                                    // ->options(Plant::pluck('name', 'id')->toArray())
+                                    ->options(function (callable $get) {
+                                        $userHas = Filament::auth()->user()->plant_id;
+
+                                        return ($userHas && strlen($userHas) > 0) ? Plant::where('id', $userHas)->pluck('name', 'id')->toArray() : Plant::pluck('name', 'id')->toArray();
+                                    })
+                                    ->required()
+                                    ->reactive()
+                                    ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                                        $set('Item', null);
+                                        $set('process_order', null);
+                                        $set('coil_number', null);
+                                        $set('received_quantity', null);
+                                        $set('machine_name', null);
+                                    }),
+                                Select::make('Item')
+                                    ->label('Item Code')
+                                    ->nullable()
+                                    ->required()
+                                    ->searchable()
+                                    ->options(function (callable $get) {
+                                            $plantId = $get('plant');
+
+                                            if(empty($plantId)) {
+                                                return [];
+                                            }
+
+                                            return Item::where('plant_id', $plantId)->pluck('code', 'id');
+
+                                            //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                                        })
+                                    ->reactive()
+                                    ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                                        $set('process_order', null);
+                                        $set('coil_number', null);
+                                        $set('received_quantity', null);
+                                        $set('machine_name', null);
+                                    }),
+                                TextInput::make('process_order')
+                                    ->label('Process Order')
+                                    ->required()
+                                    ->placeholder('Enter Process Order')
+                                    ->reactive()
+                                    ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                                        $set('coil_number', null);
+                                        $set('received_quantity', null);
+                                        $set('machine_name', null);
+                                    }),
+                                Select::make('coil_number')
+                                    ->label('Coil Number')
+                                    ->nullable()
+                                    ->required()
+                                    ->searchable()
+                                    ->options(function (callable $get) {
+                                            $plantId = $get('plant');
+                                            $itemId = $get('Item');
+                                            $processOrder = $get('process_order');
+
+                                            if(empty($plantId) || empty($itemId) || empty($processOrder)) {
+                                                return [];
+                                            }
+
+                                            return ProcessOrder::where('plant_id', $plantId)
+                                                ->where('item_id', $itemId)
+                                                ->where('process_order', $processOrder)
+                                                ->pluck('coil_number', 'coil_number');
+
+                                            //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                                        })
+                                    ->reactive()
+                                    ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                                        $plantId = $get('plant');
+                                        $itemId = $get('Item');
+                                        $processOrder = $get('process_order');
+
+                                        if(!$plantId || !$itemId || !$processOrder || !$state) {
+                                            $set('received_quantity', null);
+                                            $set('machine_name', null);
+                                            return;
+                                        }
+
+                                        $processOrderData = ProcessOrder::where('plant_id', $plantId)
+                                            ->where('item_id', $itemId)
+                                            ->where('process_order', $processOrder)
+                                            ->where('coil_number', $state)
+                                            ->first();
+
+                                        $set('received_quantity', $processOrderData?->received_quantity);
+                                        $set('machine_name', $processOrderData?->machine_name);
+                                    }),
+                                TextInput::make('received_quantity')
+                                    ->label('Received Quantity')
+                                    ->readOnly(),
+
+                                TextInput::make('machine_name')
+                                    ->label('Machine ID')
+                                    ->readOnly(),
+                            ])
+                            ->columns(['default' => 1, 'sm' => 3]),
+                    ])
+                    // ->action(function (array $data) {
+                    //     $selectedPalletNumber = $data['pallet_list'];
+                    //     return redirect()->route('download-reprint-qr-pdf', ['palletNo' => $selectedPalletNumber]);
+                    // })
+                    ->action(function (array $data) {
+                        $username = Filament::auth()->user()->name;
+                        return redirect()->route('download-reprint-process-pdf', [
+                            'plant'         => $data['plant'],
+                            'item'          => $data['Item'],
+                            'process_order' => $data['process_order'],
+                            'coil_number'   => $data['coil_number'],
+                            'name'          => $username,
+                        ]);
+                    })
+                    ->visible(function () {
+                        return Filament::auth()->user()->can('view reprint process order');
+                    }),
                 ImportAction::make()
                     ->label('Import Process Order')
                     ->color('warning')

app/Filament/Resources/ProductCharacteristicsMasterResource.php

@@ -6,6 +6,7 @@ use App\Filament\Exports\ProductCharacteristicsMasterExporter;
 use App\Filament\Imports\ProductCharacteristicsMasterImporter;
 use App\Filament\Resources\ProductCharacteristicsMasterResource\Pages;
 use App\Filament\Resources\ProductCharacteristicsMasterResource\RelationManagers;
+use App\Models\Item;
 use App\Models\Line;
 use App\Models\Machine;
 use App\Models\Plant;
@@ -22,6 +23,10 @@ use Illuminate\Database\Eloquent\Builder;
 use Illuminate\Database\Eloquent\SoftDeletingScope;
 use Filament\Tables\Actions\ImportAction;
 use Filament\Tables\Actions\ExportAction;
+use Filament\Forms\Components\DateTimePicker;
+use Filament\Tables\Filters\Filter;
+use Filament\Forms\Components\Select;
+use Filament\Forms\Components\TextInput;
 
 class ProductCharacteristicsMasterResource extends Resource
 {
@@ -232,47 +237,57 @@ class ProductCharacteristicsMasterResource extends Resource
                     }),
                 Tables\Columns\TextColumn::make('plant.name')
                     ->label('Plant')
+                    ->searchable()
                     ->alignCenter()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('item.code')
                     ->label('Item Code')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('line.name')
                     ->label('Line')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('characteristics_type')
                     ->label('Characteristics Type')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('workGroupMaster.name')
                     ->label('Group Work Center')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('machine.work_center')
                     ->label('Work Center')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
-                Tables\Columns\TextColumn::make('machine.work_center')
-                    ->label('Work Center')
-                    ->alignCenter()
-                    ->sortable(),
+                // Tables\Columns\TextColumn::make('machine.work_center')
+                //     ->label('Work Center')
+                //     ->alignCenter()
+                //     ->sortable(),
                 Tables\Columns\TextColumn::make('inspection_type')
                     ->label('Inspection Type')
                     ->alignCenter()
-                    ->sortable(),
-                Tables\Columns\TextColumn::make('upper')
-                    ->label('Upper')
-                    ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('lower')
                     ->label('Lower')
                     ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('middle')
                     ->label('Middle')
                     ->alignCenter()
+                    ->searchable()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('upper')
+                    ->label('Upper')
+                    ->alignCenter()
+                    ->searchable()
                     ->sortable(),
                 Tables\Columns\TextColumn::make('created_at')
                     ->label('Created At')
@@ -302,9 +317,203 @@ class ProductCharacteristicsMasterResource extends Resource
                     ->sortable()
                     ->toggleable(isToggledHiddenByDefault: true),
             ])
+            // ->filters([
+            //     Tables\Filters\TrashedFilter::make(),
+            // ])
             ->filters([
-                Tables\Filters\TrashedFilter::make(),
+
+            Tables\Filters\TrashedFilter::make(),
+            Filter::make('advanced_filters')
+                ->label('Advanced Filters')
+                ->form([
+                    Select::make('Plant')
+                        ->label('Select Plant')
+                        ->nullable()
+                        ->options(function (callable $get) {
+                            $userHas = Filament::auth()->user()->plant_id;
+                            return ($userHas && strlen($userHas) > 0) ? Plant::where('id', $userHas)->pluck('name', 'id')->toArray() : Plant::pluck('name', 'id')->toArray();
+                        })
+                        ->reactive()
+                        ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                            $set('Item', null);
+                        }),
+                    Select::make('Line')
+                        ->label('Select Line')
+                        ->nullable()
+                        ->options(function (callable $get) {
+                                $plantId = $get('Plant');
+
+                                if(empty($plantId)) {
+                                    return [];
+                                }
+
+                                return Line::where('plant_id', $plantId)->pluck('name', 'id');
+
+                                //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                            })
+                        ->reactive()
+                        ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                            $set('Item', null);
+                        }),
+                    Select::make('Item')
+                        ->label('Item Code')
+                        ->nullable()
+                        ->searchable()
+                        ->options(function (callable $get) {
+                                $plantId = $get('Plant');
+
+                                if(empty($plantId)) {
+                                    return [];
+                                }
+
+                                return Item::where('plant_id', $plantId)->pluck('code', 'id');
+
+                                //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                            })
+                        ->reactive()
+                        ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                            $set('process_order', null);
+                        }),
+                    Select::make('work_group_master')
+                        ->label('Select Work Group Master')
+                        ->nullable()
+                        ->options(function (callable $get) {
+                                $plantId = $get('Plant');
+
+                                if(empty($plantId)) {
+                                    return [];
+                                }
+
+                                return WorkGroupMaster::where('plant_id', $plantId)->pluck('name', 'id');
+
+                                //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                            })
+                        ->reactive()
+                        ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                            $set('Machine', null);
+                        }),
+                    Select::make('Machine')
+                        ->label('Select Machine')
+                        ->nullable()
+                        ->options(function (callable $get) {
+                                $plantId = $get('Plant');
+                                $lineId = $get('Line');
+
+                                if(empty($plantId) || empty($lineId)) {
+                                    return [];
+                                }
+
+                                return Machine::where('plant_id', $plantId)->where('line_id', $lineId)->pluck('work_center', 'id');
+
+                                //return $plantId ? Item::where('plant_id', $plantId)->pluck('code', 'id') : [];
+                            })
+                        ->reactive(),
+                        // ->afterStateUpdated(function ($state, callable $set, callable $get) {
+                        //     $set('process_order', null);
+                        // }),
+                    // TextInput::make('process_order')
+                    //     ->label('Process Order')
+                    //     ->placeholder('Enter Process Order'),
+                    // TextInput::make('coil_number')
+                    //     ->label('Coil Number')
+                    //     ->placeholder(placeholder: 'Enter Coil Number'),
+                    Select::make('characteristics_type')
+                        ->label('Characteristics Type')
+                        ->options([
+                            'Product' => 'Product',
+                            'Process' => 'Process'
+                        ]),
+                    DateTimePicker::make(name: 'created_from')
+                        ->label('Created From')
+                        ->placeholder(placeholder: 'Select From DateTime')
+                        ->reactive()
+                        ->native(false),
+                    DateTimePicker::make('created_to')
+                        ->label('Created To')
+                        ->placeholder(placeholder: 'Select To DateTime')
+                        ->reactive()
+                        ->native(false),
+                ])
+                ->query(function ($query, array $data) {
+                    // Hide all records initially if no filters are applied
+                    if (empty($data['Plant']) && empty($data['Line']) && empty($data['Item']) && empty($data['work_group_master']) && empty($data['Machine']) && empty($data['characteristics_type']) && empty($data['created_from']) && empty($data['created_to'])) {
+                        return $query->whereRaw('1 = 0');
+                    }
+
+                    if (!empty($data['Plant'])) {
+                        $query->where('plant_id', $data['Plant']);
+                    }
+
+                    if (!empty($data['Line'])) {
+                        $query->where('line_id', $data['Line']);
+                    }
+
+                    if (!empty($data['Item'])) {
+                        $query->where('item_id', $data['Item']);
+                    }
+
+                    if (!empty($data['work_group_master'])) {
+                        $query->where('work_group_master_id', $data['work_group_master']);
+                    }
+
+                    if (!empty($data['Machine'])) {
+                        $query->where('machine_id', $data['Machine']);
+                    }
+
+                    if (!empty($data['characteristics_type'])) {
+                        $query->where('characteristics_type', $data['characteristics_type']);
+                    }
+
+                    if (!empty($data['created_from'])) {
+                        $query->where('created_at', '>=', $data['created_from']);
+                    }
+
+                    if (!empty($data['created_to'])) {
+                        $query->where('created_at', '<=', $data['created_to']);
+                    }
+
+
+                    //$query->orderBy('created_at', 'asc');
+                })
+                ->indicateUsing(function (array $data) {
+                    $indicators = [];
+
+                    if (!empty($data['Plant'])) {
+                        $indicators[] = 'Plant: ' . Plant::where('id', $data['Plant'])->value('name');
+                    }
+
+                    if (!empty($data['Line'])) {
+                        $indicators[] = 'Line: ' . Line::where('id', $data['Line'])->value('name');
+                    }
+
+                    if (!empty($data['Item'])) {
+                        $indicators[] = 'Item: ' . Item::where('id', $data['Item'])->value('code');
+                    }
+
+                    if (!empty($data['work_group_master'])) {
+                        $indicators[] = 'Work Group Master: ' . WorkGroupMaster::where('id', $data['work_group_master'])->value('name');
+                    }
+
+                    if (!empty($data['Machine'])) {
+                        $indicators[] = 'Machine: ' . Machine::where('id', $data['Machine'])->value('work_center');
+                    }
+
+                    if (!empty($data['characteristics_type'])) {
+                        $indicators[] = 'Characteristics Type: ' . $data['characteristics_type'];
+                    }
+
+                    if (!empty($data['created_from'])) {
+                        $indicators[] = 'From: ' . $data['created_from'];
+                    }
+
+                    if (!empty($data['created_to'])) {
+                        $indicators[] = 'To: ' . $data['created_to'];
+                    }
+
+                    return $indicators;
+                })
             ])
+            ->filtersFormMaxHeight('280px')
             ->actions([
                 Tables\Actions\ViewAction::make(),
                 Tables\Actions\EditAction::make(),

app/Filament/Resources/TestingTempResource.php

@@ -0,0 +1,252 @@
+<?php
+
+namespace App\Filament\Resources;
+
+use App\Filament\Resources\TestingTempResource\Pages;
+use App\Filament\Resources\TestingTempResource\RelationManagers;
+use App\Models\TestingTemp;
+use Filament\Facades\Filament;
+use Filament\Forms;
+use Filament\Forms\Form;
+use Filament\Resources\Resource;
+use Filament\Tables;
+use Filament\Tables\Table;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Database\Eloquent\SoftDeletingScope;
+use Filament\Forms\Components\Actions\Action;
+use Filament\Notifications\Notification;
+use Storage;
+use Livewire\Features\SupportFileUploads\TemporaryUploadedFile;
+
+class TestingTempResource extends Resource
+{
+    protected static ?string $model = TestingTemp::class;
+
+    protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';
+
+    public static function form(Form $form): Form
+    {
+        return $form
+            ->schema([
+                Forms\Components\TextInput::make('name')
+                    ->label('File Name'),
+                Forms\Components\Select::make('selected_file')
+                    ->label('Select Uploaded File')
+                    ->options(function () {
+                        return collect(Storage::disk('local')->files('uploads'))
+                            ->mapWithKeys(function ($file) {
+                                return [
+                                    $file => basename($file), // value => label
+                                ];
+                            })
+                            ->toArray();
+                    })
+                    ->searchable()
+                    ->reactive(),
+                Forms\Components\FileUpload::make('attachment')
+                    ->label('Upload')
+                    // ->acceptedFileTypes(['application/pdf'])
+                    ->storeFiles(false)
+                    ->disk('local')
+                    ->directory('uploads/temp')
+                    ->preserveFilenames()
+                    ->reactive(),
+                Forms\Components\Actions::make([
+                    Action::make('uploadNow')
+                    ->label('File Upload')
+                    ->color('success')
+                    ->action(function ($get) {
+
+                        $uploadedFiles = $get('attachment');
+
+                        if (is_array($uploadedFiles) && count($uploadedFiles) > 0) {
+
+                            $uploaded = reset($uploadedFiles);
+
+                            if ($uploaded instanceof TemporaryUploadedFile) {
+
+                                $baseName = $get('name');
+                                $extension = $uploaded->getClientOriginalExtension();
+
+                                $finalFileName = $baseName . '.' . $extension;
+
+                                $uploaded->storeAs(
+                                    'uploads',
+                                    $finalFileName,
+                                    'local'
+                                );
+
+                                Notification::make()
+                                    ->title("File uploaded successfully: {$finalFileName}")
+                                    ->success()
+                                    ->send();
+                            }
+
+                        } else {
+                            Notification::make()
+                                ->title('No file selected to upload')
+                                ->warning()
+                                ->send();
+                        }
+                    }),
+
+                    // Action::make('downloadAttachment')
+                    //     ->label('Download File')
+                    //     ->action(function ($get) {
+
+                    //         $fileName = basename($get('selected_file'));
+
+                    //         //dd($fileName);
+
+                    //         // if (!$fileName) {
+                    //         //     Notification::make()
+                    //         //         ->title('Enter file name to download')
+                    //         //         ->danger()
+                    //         //         ->send();
+                    //         //     return;
+                    //         // }
+
+                    //         $files = Storage::disk('local')->files('uploads');
+
+                    //         foreach ($files as $file) {
+
+                    //             if (pathinfo($file, PATHINFO_FILENAME) === $fileName) {
+                    //                     dd($fileName);
+                    //                 Notification::make()
+                    //                     ->title("File downloaded successfully")
+                    //                     ->success()
+                    //                     ->send();
+
+                    //                 return response()->download(
+                    //                     Storage::disk('local')->path($file)
+                    //                 );
+                    //             }
+                    //         }
+
+                    //         // Notification::make()
+                    //         //     ->title('File not found')
+                    //         //     ->danger()
+                    //         //     ->send();
+                    //     }),
+                    Action::make('downloadAttachment')
+                        ->label('Download File')
+                        ->action(function ($get) {
+
+                            $filePath = $get('selected_file'); // uploads/filename.pdf
+
+                            if (!$filePath || !Storage::disk('local')->exists($filePath)) {
+                                Notification::make()
+                                    ->title('File not found')
+                                    ->danger()
+                                    ->send();
+
+                                return;
+                            }
+
+                            Notification::make()
+                                ->title('File downloaded successfully')
+                                ->success()
+                                ->send();
+
+                            return response()->download(
+                                Storage::disk('local')->path($filePath)
+                            );
+                        }),
+
+                        Action::make('deleteAttachment')
+                        ->label('Delete File')
+                        ->color('danger')
+                        ->requiresConfirmation()
+                        ->action(function ($get) {
+
+                            $filePath = $get('selected_file'); // uploads/filename.pdf
+
+                                if (!$filePath || !Storage::disk('local')->exists($filePath)) {
+                                    Notification::make()
+                                        ->title('File not found')
+                                        ->danger()
+                                        ->send();
+
+                                    return;
+                                }
+
+                                Storage::disk('local')->delete($filePath);
+
+                                Notification::make()
+                                    ->title('File deleted successfully')
+                                    ->success()
+                                    ->send();
+                            }),
+
+                    ]),
+                Forms\Components\Hidden::make('created_by')
+                    ->label('Created By')
+                    ->default(Filament::auth()->user()?->name),
+                Forms\Components\Hidden::make('updated_by')
+                    ->label('Updated By')
+                    ->default(Filament::auth()->user()?->name),
+            ]);
+    }
+
+    public static function table(Table $table): Table
+    {
+        return $table
+            ->columns([
+                Tables\Columns\TextColumn::make('id')
+                    ->label('ID')
+                    ->numeric()
+                    ->sortable(),
+                Tables\Columns\TextColumn::make('created_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('updated_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+                Tables\Columns\TextColumn::make('deleted_at')
+                    ->dateTime()
+                    ->sortable()
+                    ->toggleable(isToggledHiddenByDefault: true),
+            ])
+            ->filters([
+                Tables\Filters\TrashedFilter::make(),
+            ])
+            ->actions([
+                Tables\Actions\ViewAction::make(),
+                Tables\Actions\EditAction::make(),
+            ])
+            ->bulkActions([
+                Tables\Actions\BulkActionGroup::make([
+                    Tables\Actions\DeleteBulkAction::make(),
+                    Tables\Actions\ForceDeleteBulkAction::make(),
+                    Tables\Actions\RestoreBulkAction::make(),
+                ]),
+            ]);
+    }
+
+    public static function getRelations(): array
+    {
+        return [
+            //
+        ];
+    }
+
+    public static function getPages(): array
+    {
+        return [
+            'index' => Pages\ListTestingTemps::route('/'),
+            'create' => Pages\CreateTestingTemp::route('/create'),
+            'view' => Pages\ViewTestingTemp::route('/{record}'),
+            'edit' => Pages\EditTestingTemp::route('/{record}/edit'),
+        ];
+    }
+
+    public static function getEloquentQuery(): Builder
+    {
+        return parent::getEloquentQuery()
+            ->withoutGlobalScopes([
+                SoftDeletingScope::class,
+            ]);
+    }
+}

app/Filament/Resources/TestingTempResource/Pages/CreateTestingTemp.php

@@ -0,0 +1,12 @@
+<?php
+
+namespace App\Filament\Resources\TestingTempResource\Pages;
+
+use App\Filament\Resources\TestingTempResource;
+use Filament\Actions;
+use Filament\Resources\Pages\CreateRecord;
+
+class CreateTestingTemp extends CreateRecord
+{
+    protected static string $resource = TestingTempResource::class;
+}

app/Filament/Resources/TestingTempResource/Pages/EditTestingTemp.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Filament\Resources\TestingTempResource\Pages;
+
+use App\Filament\Resources\TestingTempResource;
+use Filament\Actions;
+use Filament\Resources\Pages\EditRecord;
+
+class EditTestingTemp extends EditRecord
+{
+    protected static string $resource = TestingTempResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\ViewAction::make(),
+            Actions\DeleteAction::make(),
+            Actions\ForceDeleteAction::make(),
+            Actions\RestoreAction::make(),
+        ];
+    }
+}

app/Filament/Resources/TestingTempResource/Pages/ListTestingTemps.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\TestingTempResource\Pages;
+
+use App\Filament\Resources\TestingTempResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ListRecords;
+
+class ListTestingTemps extends ListRecords
+{
+    protected static string $resource = TestingTempResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\CreateAction::make(),
+        ];
+    }
+}

app/Filament/Resources/TestingTempResource/Pages/ViewTestingTemp.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Filament\Resources\TestingTempResource\Pages;
+
+use App\Filament\Resources\TestingTempResource;
+use Filament\Actions;
+use Filament\Resources\Pages\ViewRecord;
+
+class ViewTestingTemp extends ViewRecord
+{
+    protected static string $resource = TestingTempResource::class;
+
+    protected function getHeaderActions(): array
+    {
+        return [
+            Actions\EditAction::make(),
+        ];
+    }
+}

app/Http/Controllers/CharacteristicsController.php

@@ -606,7 +606,8 @@ class CharacteristicsController extends Controller
                         'part_validation_2' => $char['part_validation_2'] ?? null,
                         'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                         // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                        'expected_time' => $char['expected_time'] ?? null,
+                        'motor_expected_time' => $char['motor_expected_time'] ?? null,
+                        'pump_expected_time' => $char['pump_expected_time'] ?? null,
                         'updated_by' => $userName ?? null,
                     ];
                 } elseif ($char['motor_pump_pumpset_status'] == '2') {
@@ -623,7 +624,7 @@ class CharacteristicsController extends Controller
                             'part_validation_2' => $char['part_validation_2'] ?? null,
                             'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                             // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                            'expected_time' => $char['expected_time'] ?? null,
+                            'pump_expected_time' => $char['pump_expected_time'] ?? null,
                             'updated_by' => $userName ?? null,
                         ];
                     } else {
@@ -639,7 +640,7 @@ class CharacteristicsController extends Controller
                             'part_validation_2' => $char['part_validation_2'] ?? null,
                             'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                             // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                            'expected_time' => $char['expected_time'] ?? null,
+                            'pump_expected_time' => $char['pump_expected_time'] ?? null,
                             'updated_by' => $userName ?? null,
                         ];
                     }
@@ -657,7 +658,7 @@ class CharacteristicsController extends Controller
                             'part_validation_2' => $char['part_validation_2'] ?? null,
                             'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                             // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                            'expected_time' => $char['expected_time'] ?? null,
+                            'motor_expected_time' => $char['motor_expected_time'] ?? null,
                             'updated_by' => $userName ?? null,
                         ];
                     } else {
@@ -673,7 +674,7 @@ class CharacteristicsController extends Controller
                             'part_validation_2' => $char['part_validation_2'] ?? null,
                             'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                             // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                            'expected_time' => $char['expected_time'] ?? null,
+                            'motor_expected_time' => $char['motor_expected_time'] ?? null,
                             'updated_by' => $userName ?? null,
                         ];
                     }
@@ -694,7 +695,8 @@ class CharacteristicsController extends Controller
                         'part_validation_2' => $char['part_validation_2'] ?? null,
                         'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
                         // 'pending_released_status' => $char['pending_released_status'] ?? null,
-                        'expected_time' => $char['expected_time'] ?? null,
+                        'motor_expected_time' => $char['motor_expected_time'] ?? null,
+                        'pump_expected_time' => $char['pump_expected_time'] ?? null,
                         'updated_by' => $userName ?? null,
                     ];
                 }
@@ -709,8 +711,15 @@ class CharacteristicsController extends Controller
 
                 $updatedRows += $affected;
             } else {
+                $curStat = ClassCharacteristic::where('plant_id', $plantId)
+                    ->where('machine_id', $machineId)
+                    ->where('gernr', $serialNumber)
+                    ->where('item_id', $itemId)
+                    ->first();
+
+                $manStat = ($curStat->man_marked_status == null || $curStat->man_marked_status == '' || $curStat->man_marked_status == '0') ? 0 : (int) $curStat->man_marked_status;
                 $values = [
-                    'man_marked_status' => $char['man_marked_status'] ?? null,
+                    'man_marked_status' => (string) ($manStat + 1),
                     'man_marked_datetime' => $char['man_marked_datetime'] ?? null,
                     'man_marked_by' => ($char['man_marked_by'] == 'jothi') ? 'Admin' : $char['man_marked_by'] ?? null,
                     'samlight_logged_name' => $char['samlight_logged_name'] ?? null,
@@ -849,9 +858,7 @@ class CharacteristicsController extends Controller
 
         $machineId = $machine->id;
 
-        $availFields = [
-            'class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name', 'zmm_beenote', 'zmm_beenumber', 'zmm_beestar', 'zmm_logo_ce', 'zmm_codeclass', 'zmm_colour', 'zmm_logo_cp', 'zmm_grade', 'zmm_grwt_pset', 'zmm_grwt_cable', 'zmm_grwt_motor', 'zmm_grwt_pf', 'zmm_grwt_pump', 'zmm_isivalve', 'zmm_isi_wc', 'zmm_labelperiod', 'zmm_length', 'zmm_license_cml_no', 'zmm_mfgmonyr', 'zmm_modelyear', 'zmm_motoridentification', 'zmm_newt_pset', 'zmm_newt_cable', 'zmm_newt_motor', 'zmm_newt_pf', 'zmm_newt_pump', 'zmm_logo_nsf', 'zmm_packtype', 'zmm_panel', 'zmm_performance_factor', 'zmm_pumpidentification', 'zmm_psettype', 'zmm_size', 'zmm_eff_ttl', 'zmm_type', 'zmm_usp', 'mark_status', 'marked_datetime', 'marked_by', 'man_marked_status', 'man_marked_datetime', 'man_marked_by', 'motor_marked_status', 'pump_marked_status', 'motor_pump_pumpset_status', 'part_validation_1', 'part_validation_2', 'samlight_logged_name', 'pending_released_status', 'expected_time',
-        ];
+        $availFields = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name', 'zmm_logo_cp', 'zmm_logo_ce', 'zmm_logo_nsf', 'zmm_beenote', 'zmm_beenumber', 'zmm_beestar', 'zmm_codeclass', 'zmm_colour', 'zmm_grade', 'zmm_grwt_pset', 'zmm_grwt_cable', 'zmm_grwt_motor', 'zmm_grwt_pf', 'zmm_grwt_pump', 'zmm_isivalve', 'zmm_isi_wc', 'zmm_labelperiod', 'zmm_length', 'zmm_license_cml_no', 'zmm_mfgmonyr', 'zmm_modelyear', 'zmm_motoridentification', 'zmm_newt_pset', 'zmm_newt_cable', 'zmm_newt_motor', 'zmm_newt_pf', 'zmm_newt_pump', 'zmm_packtype', 'zmm_panel', 'zmm_performance_factor', 'zmm_pumpidentification', 'zmm_psettype', 'zmm_size', 'zmm_eff_ttl', 'zmm_type', 'zmm_usp', 'mark_status', 'marked_datetime', 'marked_by', 'man_marked_status', 'man_marked_datetime', 'man_marked_by', 'motor_marked_status', 'motor_marked_by', 'pump_marked_status', 'pump_marked_by', 'motor_pump_pumpset_status', 'motor_machine_name', 'pump_machine_name', 'pumpset_machine_name', 'part_validation_1', 'part_validation_2', 'samlight_logged_name', 'pending_released_status', 'motor_expected_time', 'pump_expected_time'];
 
         if ($itemCode != '' && $itemCode != null && $itemCode && Str::length($itemCode) > 0) {
             $existingJob = ClassCharacteristic::where('plant_id', $plantId)
@@ -937,7 +944,7 @@ class CharacteristicsController extends Controller
                 ], 404);
             }
 
-            $col = ['marked_by', 'man_marked_by'];
+            $col = ['marked_by', 'man_marked_by', 'motor_marked_by', 'pump_marked_by'];
             $missingUsers = [];
             $missingUsersPlant = [];
             $missingUsersRight = [];
@@ -1042,6 +1049,8 @@ class CharacteristicsController extends Controller
 
                         $insertData['marked_by'] = ($char['marked_by'] == 'jothi') ? 'Admin' : $char['marked_by'] ?? null;
                         $insertData['man_marked_by'] = ($char['man_marked_by'] == 'jothi') ? 'Admin' : $char['man_marked_by'] ?? null;
+                        $insertData['motor_marked_by'] = ($char['motor_marked_by'] == 'jothi') ? 'Admin' : $char['motor_marked_by'] ?? null;
+                        $insertData['pump_marked_by'] = ($char['pump_marked_by'] == 'jothi') ? 'Admin' : $char['pump_marked_by'] ?? null;
 
                         $existing = ClassCharacteristic::where('plant_id', $plantId)
                             ->where('item_id', $itemId)
@@ -1121,7 +1130,7 @@ class CharacteristicsController extends Controller
             } else {
                 $hasNewSno = true;
 
-                $col = ['marked_by', 'man_marked_by'];
+                $col = ['marked_by', 'man_marked_by', 'motor_marked_by', 'pump_marked_by'];
                 $missingUsers = [];
                 $missingUsersPlant = [];
                 $missingUsersRight = [];
@@ -1213,9 +1222,7 @@ class CharacteristicsController extends Controller
                 ], 404);
             }
 
-            $masterFields = [
-                'class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name',
-            ];
+            $masterFields = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name', 'zmm_logo_cp', 'zmm_logo_ce', 'zmm_logo_nsf'];
 
             $isInsertOrUpdate = false;
 
@@ -1278,6 +1285,8 @@ class CharacteristicsController extends Controller
 
                             $insertData['marked_by'] = ($char['marked_by'] == 'jothi') ? 'Admin' : $char['marked_by'] ?? null;
                             $insertData['man_marked_by'] = ($char['man_marked_by'] == 'jothi') ? 'Admin' : $char['man_marked_by'] ?? null;
+                            $insertData['motor_marked_by'] = ($char['motor_marked_by'] == 'jothi') ? 'Admin' : $char['motor_marked_by'] ?? null;
+                            $insertData['pump_marked_by'] = ($char['pump_marked_by'] == 'jothi') ? 'Admin' : $char['pump_marked_by'] ?? null;
 
                             $existing = ClassCharacteristic::where('plant_id', $plantId)
                                 ->where('item_id', $itemId)
@@ -1470,9 +1479,9 @@ class CharacteristicsController extends Controller
                 ], 400);
             }
 
-            $columnsToShow = ['mark_status', 'marked_datetime', 'marked_by', 'man_marked_status', 'man_marked_datetime', 'man_marked_by', 'motor_marked_status', 'motor_marked_by', 'pump_marked_status', 'pump_marked_by', 'motor_pump_pumpset_status', 'motor_machine_name', 'pump_machine_name', 'pumpset_machine_name', 'part_validation_1', 'part_validation_2', 'samlight_logged_name', 'pending_released_status', 'expected_time'];
+            $columnsToShow = ['mark_status', 'marked_datetime', 'marked_by', 'man_marked_status', 'man_marked_datetime', 'man_marked_by', 'motor_marked_status', 'motor_marked_by', 'pump_marked_status', 'pump_marked_by', 'motor_pump_pumpset_status', 'motor_machine_name', 'pump_machine_name', 'pumpset_machine_name', 'part_validation_1', 'part_validation_2', 'samlight_logged_name', 'pending_released_status', 'motor_expected_time', 'pump_expected_time'];
 
-            $characteristicsColumns = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name'];
+            $characteristicsColumns = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name', 'zmm_logo_cp', 'zmm_logo_ce', 'zmm_logo_nsf'];
 
             $characteristicsData = ClassCharacteristic::where('aufnr', $jobNumber)
                 ->where('plant_id', $plantId)
@@ -1639,7 +1648,7 @@ class CharacteristicsController extends Controller
                 ], 404);
             }
 
-            if ($serialExists->mark_status != 'Marked' && $serialExists->mark_status != 'marked') {
+            if ($serialExists->mark_status != 'Marked' && $serialExists->motor_marked_status != 'Marked' && $serialExists->pump_marked_status != 'Marked') {
                 // "Serial number '{$serialNumber}' is not marked yet.<br>Please proceed with marking first.";
                 return response()->json([
                     'status_code' => 'ERROR',
@@ -1859,9 +1868,9 @@ class CharacteristicsController extends Controller
                 ], 400);
             }
 
-            // $columnsToShow = ['mark_status','marked_datetime','marked_by','man_marked_status','man_marked_datetime','man_marked_by','motor_marked_status','pump_marked_status','motor_pump_pumpset_status','part_validation_1','part_validation_2','samlight_logged_name','pending_released_status','expected_time'];
+            // $columnsToShow = ['mark_status','marked_datetime','marked_by','man_marked_status','man_marked_datetime','man_marked_by','motor_marked_status','pump_marked_status','motor_pump_pumpset_status','part_validation_1','part_validation_2','samlight_logged_name','pending_released_status','motor_expected_time','pump_expected_time'];
 
-            $characteristicsColumns = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_logo_cp', 'zmm_logo_ce', 'zmm_logo_nsf', 'zmm_laser_name'];
+            $characteristicsColumns = ['class', 'arbid', 'gamng', 'lmnga', 'zz1_cn_bill_ord', 'zmm_amps', 'zmm_brand', 'zmm_degreeofprotection', 'zmm_delivery', 'zmm_dir_rot', 'zmm_discharge', 'zmm_discharge_max', 'zmm_discharge_min', 'zmm_duty', 'zmm_eff_motor', 'zmm_eff_pump', 'zmm_frequency', 'zmm_head', 'zmm_heading', 'zmm_head_max', 'zmm_head_minimum', 'zmm_idx_eff_mtr', 'zmm_idx_eff_pump', 'zmm_kvacode', 'zmm_maxambtemp', 'zmm_mincoolingflow', 'zmm_motorseries', 'zmm_motor_model', 'zmm_outlet', 'zmm_phase', 'zmm_pressure', 'zmm_pumpflowtype', 'zmm_pumpseries', 'zmm_pump_model', 'zmm_ratedpower', 'zmm_region', 'zmm_servicefactor', 'zmm_servicefactormaximumamps', 'zmm_speed', 'zmm_suction', 'zmm_suctionxdelivery', 'zmm_supplysource', 'zmm_temperature', 'zmm_thrustload', 'zmm_volts', 'zmm_wire', 'zmm_package', 'zmm_pvarrayrating', 'zmm_isi', 'zmm_isimotor', 'zmm_isipump', 'zmm_isipumpset', 'zmm_pumpset_model', 'zmm_stages', 'zmm_headrange', 'zmm_overall_efficiency', 'zmm_connection', 'zmm_min_bore_size', 'zmm_isireference', 'zmm_category', 'zmm_submergence', 'zmm_capacitorstart', 'zmm_capacitorrun', 'zmm_inch', 'zmm_motor_type', 'zmm_dismantle_direction', 'zmm_eff_ovrall', 'zmm_bodymoc', 'zmm_rotormoc', 'zmm_dlwl', 'zmm_inputpower', 'zmm_imp_od', 'zmm_ambtemp', 'zmm_de', 'zmm_dischargerange', 'zmm_efficiency_class', 'zmm_framesize', 'zmm_impellerdiameter', 'zmm_insulationclass', 'zmm_maxflow', 'zmm_minhead', 'zmm_mtrlofconst', 'zmm_nde', 'zmm_powerfactor', 'zmm_tagno', 'zmm_year', 'zmm_laser_name', 'zmm_logo_cp', 'zmm_logo_ce', 'zmm_logo_nsf'];
 
             $characteristicsData = ClassCharacteristic::where('aufnr', $jobNumber)
                 ->where('plant_id', $plantId)
@@ -2090,7 +2099,7 @@ class CharacteristicsController extends Controller
             //     ], 404);
             // }
 
-            // $columnsToShow = ['mark_status','marked_datetime','marked_by','man_marked_status','man_marked_datetime','man_marked_by','motor_marked_status','pump_marked_status','motor_pump_pumpset_status','part_validation_1','part_validation_2','samlight_logged_name','pending_released_status','expected_time'];
+            // $columnsToShow = ['mark_status','marked_datetime','marked_by','man_marked_status','man_marked_datetime','man_marked_by','motor_marked_status','pump_marked_status','motor_pump_pumpset_status','part_validation_1','part_validation_2','samlight_logged_name','pending_released_status','motor_expected_time','pump_expected_time'];
 
             // $characteristicsColumns = ['class','arbid','gamng','lmnga','zz1_cn_bill_ord','zmm_amps','zmm_brand','zmm_degreeofprotection','zmm_delivery','zmm_dir_rot','zmm_discharge','zmm_discharge_max','zmm_discharge_min','zmm_duty','zmm_eff_motor','zmm_eff_pump','zmm_frequency','zmm_head','zmm_heading','zmm_head_max','zmm_head_minimum','zmm_idx_eff_mtr','zmm_idx_eff_pump','zmm_kvacode','zmm_maxambtemp','zmm_mincoolingflow','zmm_motorseries','zmm_motor_model','zmm_outlet','zmm_phase','zmm_pressure','zmm_pumpflowtype','zmm_pumpseries','zmm_pump_model','zmm_ratedpower','zmm_region','zmm_servicefactor','zmm_servicefactormaximumamps','zmm_speed','zmm_suction','zmm_suctionxdelivery','zmm_supplysource','zmm_temperature','zmm_thrustload','zmm_volts','zmm_wire','zmm_package','zmm_pvarrayrating','zmm_isi','zmm_isimotor','zmm_isipump','zmm_isipumpset','zmm_pumpset_model','zmm_stages','zmm_headrange','zmm_overall_efficiency','zmm_connection','zmm_min_bore_size','zmm_isireference','zmm_category','zmm_submergence','zmm_capacitorstart','zmm_capacitorrun','zmm_inch','zmm_motor_type','zmm_dismantle_direction','zmm_eff_ovrall','zmm_bodymoc','zmm_rotormoc','zmm_dlwl','zmm_inputpower','zmm_imp_od','zmm_ambtemp','zmm_de','zmm_dischargerange','zmm_efficiency_class','zmm_framesize','zmm_impellerdiameter','zmm_insulationclass','zmm_maxflow','zmm_minhead','zmm_mtrlofconst','zmm_nde','zmm_powerfactor','zmm_tagno','zmm_year','zmm_laser_name'];
 
@@ -2124,6 +2133,8 @@ class CharacteristicsController extends Controller
                 'MOTOR_MACHINE_NAME' => $serialExists->motor_machine_name ?? '',
                 'PUMP_MACHINE_NAME' => $serialExists->pump_machine_name ?? '',
                 'PUMPSET_MACHINE_NAME' => $serialExists->pumpset_machine_name ?? '',
+                'MOTOR_EXPECTED_TIME' => $serialExists->motor_expected_time ?? '',
+                'PUMP_EXPECTED_TIME' => $serialExists->pump_expected_time ?? '',
             ], 200);
         }
     }
@@ -2407,6 +2418,7 @@ class CharacteristicsController extends Controller
         $processOrder = $data['process_order'] ?? '';
         $coilNo = $data['coil_number'] ?? '';
         $status = $data['status'] ?? '';
+        $obsValue = $data['observed_value'] ?? '';
         $createdBy = $data['created_by'] ?? '';
 
         if ($processOrder == null || $processOrder == '' || ! $processOrder) {
@@ -2445,6 +2457,13 @@ class CharacteristicsController extends Controller
             ], 404);
         }
 
+        if ($obsValue == null || $obsValue == '' || ! $obsValue) {
+            return response()->json([
+                'status_code' => 'ERROR',
+                'status_description' => "Observed value can't be empty!",
+            ], 404);
+        }
+
         if ($createdBy == null || $createdBy == '' || ! $createdBy) {
             return response()->json([
                 'status_code' => 'ERROR',
@@ -2484,6 +2503,7 @@ class CharacteristicsController extends Controller
             'process_order' => $processOrder,
             'coil_number' => $coilNo,
             'status' => $status,
+            'observed_value' => $obsValue,
             'created_by' => $createdBy,
         ]);
 

app/Http/Controllers/ProductionStickerReprintController.php

@@ -20,12 +20,23 @@ class ProductionStickerReprintController extends Controller
         //
     }
 
-    public function downloadQrPdf($palletNo)
+    // public function downloadQrPdf($palletNo)
+    // {
+    public function downloadQrPdf(Request $request)
     {
+        // $palletNo = urldecode($palletNo);
+        $palletNo = urldecode($request->query('palletNo'));
+
+        if (!$palletNo) {
+            abort(400, 'palletNo is required');
+        }
+
         $parts = explode('|', $palletNo);
         $itemCode = trim($parts[0]);
         $serialNumberRaw = isset($parts[1]) ? trim($parts[1]) : null;
 
+        // dd($serialNumberRaw);
+
         if ($serialNumberRaw != null) {
             $serial = preg_replace('/\/.*/', '', $serialNumberRaw);
             $serial = trim($serial);
@@ -50,14 +61,42 @@ class ProductionStickerReprintController extends Controller
 
         $productionOrder = $production->production_order ?? '';
 
-        if ($item->category == 'Submersible Motor')
+        if(!preg_match('/\//', $palletNo)){
+            if ($item->category == 'Submersible Motor')
+            {
+                $copies = 1;
+            }
+            elseif ($item->category == 'Submersible Pump')
+            {
+                $copies = 2;
+            }
+        }
+        else
         {
+            // if ($item->category == 'Submersible Motor')
+            // {
+            //     $copies = 1;
+            // }
+            // elseif ($item->category == 'Submersible Pump')
+            // {
+            //     $copies = 1;
+            // }
             $copies = 1;
+
+            if ($serialNumberRaw) {
+                // Check if serial ends with /m or /M, optionally followed by |
+                if (preg_match('/\/[mM](\|)?$/', $serialNumberRaw)) {
+                    $copies = 1;
+                }
+                // Check if serial ends with /p or /P, optionally followed by |
+                elseif (preg_match('/\/[pP](\|)?$/', $serialNumberRaw)) {
+                    $copies = 1;
+                }
+            }
         }
-        elseif ($item->category == 'Submersible Pump')
-        {
-            $copies = 2;
-        }
+
+        // $palletNo = preg_replace('/\/.*/', '', $palletNo);
+
         // 5. Generate QR Code (base64)
         $qrCode = new QrCode($palletNo);
         $output = new Output\Png();
@@ -73,6 +112,8 @@ class ProductionStickerReprintController extends Controller
             'copies'=> $copies,
         ]);
     }
+
+
     public function store(Request $request)
     {
         //

app/Mail/InvoiceTransitMail.php

@@ -0,0 +1,119 @@
+<?php
+
+namespace App\Mail;
+
+use Carbon\Carbon;
+use Illuminate\Bus\Queueable;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Mail\Mailable;
+use Illuminate\Mail\Mailables\Content;
+use Illuminate\Mail\Mailables\Envelope;
+use Illuminate\Queue\SerializesModels;
+
+class InvoiceTransitMail extends Mailable
+{
+    use Queueable, SerializesModels;
+
+    public $scheduleType;
+
+    public $tableData;
+
+    public $mailSubject;
+
+    /**
+     * Create a new message instance.
+     */
+    public function __construct($scheduleType, $tableData, $mailSubject)
+    {
+        $this->scheduleType = $scheduleType;
+        $this->tableData = $tableData ?? [];
+        $this->mailSubject = $mailSubject ?? 'Invoice In Transit';
+    }
+
+    /**
+     * Get the message envelope.
+     */
+    public function envelope(): Envelope
+    {
+        return new Envelope(
+            subject: $this->mailSubject,
+        );
+    }
+
+    /**
+     * Get the message content definition.
+     */
+    // public function content(): Content
+    // {
+    //     return new Content(
+    //         view: 'view.name',
+    //     );
+    // }
+
+    public function content(): Content
+    {
+        $greeting = '<b>Dear Service Provider</b>,<br><br>The following consignments to our branch warehouse are overdue beyond the agreed timeline.Immediate delivery is required today; Failure to complain will result to not able to fulfill customer requirements and leads to potential sales loss.Please treat this as the critical and confirm despatch without delay. <br><br><b> Dear C.R.I Branch Team,</b> <br><br> Please follow and ensure the same.';
+
+        //$greeting1 = 'Dear C.R.I Branch Team, <br><br> Please follow and ensure the same';
+
+          if (strtolower($this->scheduleType) == 'daily') {
+
+            $dates = collect($this->tableData)
+                ->pluck('lr_bl_aw_date')
+                ->filter()
+                ->map(fn ($d) => Carbon::parse($d));
+
+            if ($dates->isNotEmpty()) {
+                $startDate = $dates->min()->startOfDay();
+            }
+            else
+            {
+                $startDate = now()->subDay()->startOfDay();
+            }
+
+            $endDate = now();
+
+            // $reportPeriod = "<br><br>"
+            //     . "Report Period: <b>{$startDate->format('d-m-Y')}</b> "
+            //     . "to <b>{$endDate->format('d-m-Y')}.</b>";
+                // . "<br>Please arrange to receipt the same immediately.";
+
+            //$greeting .= $reportPeriod;
+        }
+
+        if ($this->scheduleType == 'Hourly') {
+            $now = now();
+            $fromHour = $now->copy()->subHour()->format('H:i:s');
+            $toHour = $now->format('H:i:s');
+            $reportDate = $now->format('d/m/Y');
+            $greeting .= "from: $reportDate, $fromHour to $toHour. <br><br>Please arrange to receipt the same immediately.";
+        }
+
+        if ($this->scheduleType == 'Live') {
+            $now = now();
+            $fromMinute = $now->copy()->subMinute()->format('d/m/Y H:i:s');
+            $toMinute = $now->format('d/m/Y H:i:s');
+            $greeting .= "from: $fromMinute to $toMinute. <br><br>Please arrange to receipt the same immediately.";
+        }
+
+        return new Content(
+            view: 'mail.invoice-in-transit-report',
+            with: [
+                'company' => 'CRI Digital Manufacturing Solutions',
+                'greeting' => $greeting,
+                'tableData' => $this->tableData,
+                'wishes' => 'Thanks & Regards,<br>CRI Digital Manufacturing Solutions',
+            ],
+        );
+    }
+
+    /**
+     * Get the attachments for the message.
+     *
+     * @return array<int, \Illuminate\Mail\Mailables\Attachment>
+     */
+    public function attachments(): array
+    {
+        return [];
+    }
+}

app/Models/AlertMailRule.php

@@ -13,6 +13,7 @@ class AlertMailRule extends Model
     protected $fillable = [
         'module',
         'plant',
+        'invoice_master_id',
         'rule_name',
         'email',
         'cc_emails',
@@ -23,8 +24,9 @@ class AlertMailRule extends Model
         'updated_by',
     ];
 
-    // public function plant(): BelongsTo
-    // {
-    //     return $this->belongsTo(Plant::class);
-    // }
+    public function invoiceMaster(): BelongsTo
+    {
+        return $this->belongsTo(InvoiceMaster::class);
+        //return $this->belongsTo(InvoiceMaster::class, 'invoice_master_id');
+    }
 }

app/Models/CharacteristicValue.php

@@ -19,6 +19,7 @@ class CharacteristicValue extends Model
         'process_order',
         'coil_number',
         'status',
+        'observed_value',
         'created_at',
         'updated_at',
         'created_by',

app/Models/InvoiceInTransit.php

@@ -0,0 +1,46 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\Relations\BelongsTo;
+use Illuminate\Database\Eloquent\SoftDeletes;
+
+class InvoiceInTransit extends Model
+{
+    use SoftDeletes;
+
+    protected $fillable = [
+        "plant_id",
+        "receiving_plant",
+        "receiving_plant_name",
+        "invoice_number",
+        "invoice_date",
+        "item_code",
+        "description",
+        "quantity",
+        "transport_name",
+        "lr_bl_aw_number",
+        "lr_bl_aw_date",
+        "pending_days",
+        "obd_number",
+        "obd_date",
+        "shipment_weight",
+        "unit_price",
+        "net_value",
+        "total_item_amount",
+        "tax_amount",
+        "transport_mode",
+        "vehicle_number",
+        "e_waybill_number",
+        "created_at",
+        "created_by",
+        "updated_by",
+        "updated_at"
+    ];
+
+    public function plant(): BelongsTo
+    {
+        return $this->belongsTo(Plant::class);
+    }
+}

app/Models/InvoiceMaster.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\SoftDeletes;
+
+class InvoiceMaster extends Model
+{
+    use SoftDeletes;
+
+    protected $fillable = [
+        "receiving_plant",
+        "receiving_plant_name",
+        "transit_days",
+        "transport_name",
+        "created_at",
+        "created_by",
+        "updated_by",
+        "updated_at"
+    ];
+}

app/Models/TestingTemp.php

@@ -0,0 +1,20 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\SoftDeletes;
+
+class TestingTemp extends Model
+{
+    use SoftDeletes;
+
+    protected $fillable = [
+        'name',
+        'created_at',
+        'updated_at',
+        'created_by',
+        'updated_by',
+    ];
+
+}

app/Policies/InvoiceInTransitPolicy.php

@@ -0,0 +1,106 @@
+<?php
+
+namespace App\Policies;
+
+use Illuminate\Auth\Access\Response;
+use App\Models\InvoiceInTransit;
+use App\Models\User;
+
+class InvoiceInTransitPolicy
+{
+    /**
+     * Determine whether the user can view any models.
+     */
+    public function viewAny(User $user): bool
+    {
+        return $user->checkPermissionTo('view-any InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can view the model.
+     */
+    public function view(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('view InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can create models.
+     */
+    public function create(User $user): bool
+    {
+        return $user->checkPermissionTo('create InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can update the model.
+     */
+    public function update(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('update InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can delete the model.
+     */
+    public function delete(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('delete InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can delete any models.
+     */
+    public function deleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('delete-any InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can restore the model.
+     */
+    public function restore(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('restore InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can restore any models.
+     */
+    public function restoreAny(User $user): bool
+    {
+        return $user->checkPermissionTo('restore-any InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can replicate the model.
+     */
+    public function replicate(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('replicate InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can reorder the models.
+     */
+    public function reorder(User $user): bool
+    {
+        return $user->checkPermissionTo('reorder InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can permanently delete the model.
+     */
+    public function forceDelete(User $user, InvoiceInTransit $invoiceintransit): bool
+    {
+        return $user->checkPermissionTo('force-delete InvoiceInTransit');
+    }
+
+    /**
+     * Determine whether the user can permanently delete any models.
+     */
+    public function forceDeleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('force-delete-any InvoiceInTransit');
+    }
+}

app/Policies/InvoiceMasterPolicy.php

@@ -0,0 +1,106 @@
+<?php
+
+namespace App\Policies;
+
+use Illuminate\Auth\Access\Response;
+use App\Models\InvoiceMaster;
+use App\Models\User;
+
+class InvoiceMasterPolicy
+{
+    /**
+     * Determine whether the user can view any models.
+     */
+    public function viewAny(User $user): bool
+    {
+        return $user->checkPermissionTo('view-any InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can view the model.
+     */
+    public function view(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('view InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can create models.
+     */
+    public function create(User $user): bool
+    {
+        return $user->checkPermissionTo('create InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can update the model.
+     */
+    public function update(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('update InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can delete the model.
+     */
+    public function delete(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('delete InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can delete any models.
+     */
+    public function deleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('delete-any InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can restore the model.
+     */
+    public function restore(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('restore InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can restore any models.
+     */
+    public function restoreAny(User $user): bool
+    {
+        return $user->checkPermissionTo('restore-any InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can replicate the model.
+     */
+    public function replicate(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('replicate InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can reorder the models.
+     */
+    public function reorder(User $user): bool
+    {
+        return $user->checkPermissionTo('reorder InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can permanently delete the model.
+     */
+    public function forceDelete(User $user, InvoiceMaster $invoicemaster): bool
+    {
+        return $user->checkPermissionTo('force-delete InvoiceMaster');
+    }
+
+    /**
+     * Determine whether the user can permanently delete any models.
+     */
+    public function forceDeleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('force-delete-any InvoiceMaster');
+    }
+}

app/Policies/TestingTempPolicy.php

@@ -0,0 +1,106 @@
+<?php
+
+namespace App\Policies;
+
+use Illuminate\Auth\Access\Response;
+use App\Models\TestingTemp;
+use App\Models\User;
+
+class TestingTempPolicy
+{
+    /**
+     * Determine whether the user can view any models.
+     */
+    public function viewAny(User $user): bool
+    {
+        return $user->checkPermissionTo('view-any TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can view the model.
+     */
+    public function view(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('view TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can create models.
+     */
+    public function create(User $user): bool
+    {
+        return $user->checkPermissionTo('create TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can update the model.
+     */
+    public function update(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('update TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can delete the model.
+     */
+    public function delete(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('delete TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can delete any models.
+     */
+    public function deleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('delete-any TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can restore the model.
+     */
+    public function restore(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('restore TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can restore any models.
+     */
+    public function restoreAny(User $user): bool
+    {
+        return $user->checkPermissionTo('restore-any TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can replicate the model.
+     */
+    public function replicate(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('replicate TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can reorder the models.
+     */
+    public function reorder(User $user): bool
+    {
+        return $user->checkPermissionTo('reorder TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can permanently delete the model.
+     */
+    public function forceDelete(User $user, TestingTemp $testingtemp): bool
+    {
+        return $user->checkPermissionTo('force-delete TestingTemp');
+    }
+
+    /**
+     * Determine whether the user can permanently delete any models.
+     */
+    public function forceDeleteAny(User $user): bool
+    {
+        return $user->checkPermissionTo('force-delete-any TestingTemp');
+    }
+}

database/migrations/2025_12_27_124510_add_observed_value_column_to_characteristic_values.php

@@ -0,0 +1,29 @@
+<?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
+    {
+        DB::statement(<<<SQL
+            ALTER TABLE characteristic_values
+            ADD COLUMN observed_value NUMERIC(10,3);
+        SQL);
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        // Schema::table('characteristic_values', function (Blueprint $table) {
+        //     //
+        // });
+    }
+};

database/migrations/2026_01_02_143627_create_invoice_in_transits_table.php

@@ -0,0 +1,60 @@
+<?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
+    {
+        $sql = <<<'SQL'
+            CREATE TABLE invoice_in_transits (
+                id					               	BIGINT GENERATED always AS IDENTITY PRIMARY KEY,
+                plant_id							BIGINT NOT NULL,
+
+                receiving_plant                     TEXT DEFAULT NULL,
+                receiving_plant_name                TEXT DEFAULT NULL,
+                invoice_number                      TEXT DEFAULT NULL,
+                invoice_date                        TEXT DEFAULT NULL,
+                item_code                           TEXT DEFAULT NULL,
+                description                         TEXT DEFAULT NULL,
+                quantity                            NUMERIC(10,3) DEFAULT NULL,
+                transport_name                      TEXT DEFAULT NULL,
+                lr_bl_aw_number                     TEXT DEFAULT NULL,
+                lr_bl_aw_date                       TEXT DEFAULT NULL,
+                pending_days                        TEXT DEFAULT NULL,
+                obd_number                          TEXT DEFAULT NULL,
+                obd_date                            TEXT DEFAULT NULL,
+                shipment_weight                     TEXT DEFAULT NULL,
+                unit_price                          TEXT DEFAULT NULL,
+                net_value                           TEXT DEFAULT NULL,
+                total_item_amount                   TEXT DEFAULT NULL,
+                tax_amount                          TEXT DEFAULT NULL,
+                transport_mode                      TEXT DEFAULT NULL,
+                vehicle_number                      TEXT DEFAULT NULL,
+                e_waybill_number                    TEXT DEFAULT NULL,
+
+                created_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                updated_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                created_by							TEXT DEFAULT NULL,
+                updated_by							TEXT DEFAULT NULL,
+                deleted_at			                TIMESTAMP,
+
+                FOREIGN KEY (plant_id)              REFERENCES  plants (id)
+            );
+        SQL;
+        DB::statement($sql);
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('invoice_in_transits');
+    }
+};

database/migrations/2026_01_02_151916_create_invoice_masters_table.php

@@ -0,0 +1,40 @@
+<?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
+    {
+        $sql = <<<'SQL'
+            CREATE TABLE invoice_masters (
+                id					               	BIGINT GENERATED always AS IDENTITY PRIMARY KEY,
+
+                receiving_plant					    TEXT DEFAULT NULL,
+                receiving_plant_name			    TEXT DEFAULT NULL,
+                transit_days                        TEXT DEFAULT NULL,
+                transport_name                      TEXT DEFAULT NULL,
+
+                created_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                updated_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                created_by							TEXT DEFAULT NULL,
+                updated_by							TEXT DEFAULT NULL,
+                deleted_at			                TIMESTAMP
+            );
+        SQL;
+        DB::statement($sql);
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('invoice_masters');
+    }
+};

database/migrations/2026_01_03_090439_add_foreign_key_invoice_master_id_column_to_alert_mail_rules.php

@@ -0,0 +1,33 @@
+<?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
+    {
+        $sql = <<<'SQL'
+            ALTER TABLE alert_mail_rules
+            ADD COLUMN invoice_master_id BIGINT DEFAULT NULL,
+            ADD CONSTRAINT invoice_masters_invoice_master_id_fkey
+            FOREIGN KEY (invoice_master_id) REFERENCES invoice_masters(id);
+        SQL;
+
+        DB::statement($sql);
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        // Schema::table('alert_mail_rules', function (Blueprint $table) {
+        //     //
+        // });
+    }
+};

database/migrations/2026_01_06_183146_create_testing_temps_table.php

@@ -0,0 +1,35 @@
+<?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
+    {
+       $sql = <<<'SQL'
+            CREATE TABLE testing_temps (
+                id					               	BIGINT GENERATED always AS IDENTITY PRIMARY KEY,
+                name                                TEXT DEFAULT NULL,
+                created_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                updated_at							TIMESTAMP NOT NULL DEFAULT NOW(),
+                created_by							TEXT DEFAULT NULL,
+                updated_by							TEXT DEFAULT NULL,
+                deleted_at			                TIMESTAMP
+            );
+        SQL;
+        DB::statement($sql);
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('testing_temps');
+    }
+};

database/seeders/PermissionSeeder.php

@@ -171,5 +171,12 @@ class PermissionSeeder extends Seeder
 
         Permission::updateOrCreate(['name' => 'view import sticker printing']);
         Permission::updateOrCreate(['name' => 'view export sticker printing']);
+
+        Permission::updateOrCreate(['name' => 'view import invoice master']);
+        Permission::updateOrCreate(['name' => 'view export invoice master']);
+
+        Permission::updateOrCreate(['name' => 'view import invoice in transit']);
+        Permission::updateOrCreate(['name' => 'view export invoice in transit']);
+
     }
 }

database/seeders/UserSeeder.php

@@ -3,7 +3,6 @@
 namespace Database\Seeders;
 
 use App\Models\User;
-use Hash;
 use Illuminate\Database\Seeder;
 
 class UserSeeder extends Seeder
@@ -17,20 +16,20 @@ class UserSeeder extends Seeder
             ['email' => 'dhanabalan.saravanan@cripumps.com'],
             [
                 'name' => 'Dhanabalan S',
-                'password' => bcrypt('SdHaNa@123'),
+                'password' => bcrypt('SdHaNa$1997'),
                 'updated_at' => now(),
-                'created_at' => now()
+                'created_at' => now(),
             ]
         );
         $user1->assignRole('Super Admin');
 
         $user2 = User::updateOrCreate(
-            ['email' => 'ranjith@cripumps.com'],
+            ['email' => 'ranjith.bala@cripumps.com'],
             [
                 'name' => 'Ranjith B',
-                'password' => bcrypt('Ranjii@5503'),
+                'password' => bcrypt('Ranjii$5503'),
                 'updated_at' => now(),
-                'created_at' => now()
+                'created_at' => now(),
             ]
         );
         $user2->assignRole('Super Admin');

resources/views/mail/invoice-in-transit-report.blade.php

@@ -0,0 +1,125 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <title>Invoice Data Report</title>
+    <style>
+        body {
+            font-family: 'Segoe UI', Arial, sans-serif;
+            background-color: #f9fafb;
+            color: #333;
+            margin: 0;
+            padding: 0;
+        }
+        h2 {
+            color: #215c98;
+            text-align: center;
+            margin-bottom: 20px;
+        }
+        table {
+            border-collapse: collapse;
+            width: 100%;
+            font-size: 14px;
+            white-space: nowrap !important;
+        }
+        th, td {
+            border: 1px solid #020813da;
+            padding: 8px 10px;
+            text-align: center;
+            white-space: nowrap !important;
+            text-overflow: ellipsis;
+        }
+        .td-left {
+            text-align: left !important;
+        }
+        th {
+            background-color: #215c98;
+            color: #fff;
+            white-space: nowrap !important;
+        }
+        tr:nth-child(even) {
+            background-color: #f3f4f6;
+        }
+        .status-wentout {
+            color: #10b981;
+            font-weight: bold;
+        }
+        /* .status-pending {
+            color: #ef4444;
+            font-weight: bold;
+        } */
+        .status-pending-yellow {
+        color: #eab308;
+        font-weight: bold;
+        }
+        .status-pending-red {
+            color: #ef4444;
+            font-weight: bold;
+        }
+        .footer {
+            text-align: center;
+            font-size: 13px;
+            color: #6b7280;
+            margin-top: 30px;
+        }
+    </style>
+</head>
+<body>
+    <div style="text-align: center; font-weight: bold;">
+        {{ $company }}
+    </div>
+    <br>
+    <p>{!! $greeting !!}</p>
+    <div class="container">
+        @if(empty($tableData))
+            <p style="text-align:center;">No invoice in transit data available.</p>
+        @else
+            <table>
+                <thead>
+                    <tr>
+                        <th>No</th>
+                        <th>Receiving Plant Code</th>
+                        <th>Plant Name</th>
+                        <th>Receiving Plant Name</th>
+                        <th>Invoice Number</th>
+                        <th>Transport Name</th>
+                        <th>LR Number</th>
+                        <th>LR Date</th>
+                        <th>Transit Days</th>
+                        <th>Pending Days</th>
+                    </tr>
+                </thead>
+                <tbody>
+                    @foreach ($tableData as $row)
+                    <tr>
+                        <td>{{ $row['no'] }}</td>
+                        <td>{{ $row['receiving_plant'] }}</td>
+                        <td>{{ $row['plant'] }}</td>
+                        <td>{{ $row['receiving_plant_name'] }}</td>
+                        <td>{{ $row['invoice_number'] }}</td>
+                        <td class="td-left">{{ $row['transport_name'] }}</td>
+                        <td>{{ $row['lr_bl_aw_number'] }}</td>
+                        <td>
+                            @if(!empty($row['lr_bl_aw_date']) && $row['lr_bl_aw_date'] != '-')
+                                {{ \Carbon\Carbon::parse($row['lr_bl_aw_date'])->format('d-M-Y') }}
+                            @else
+                                -
+                            @endif
+                        </td>
+
+                        {{-- <td>{{ $row['lr_bl_aw_date'] }}</td> --}}
+                        <td>{{ $row['transit_days'] }}</td>
+                        <td>{{ $row['status'] }}</td>
+
+                        {{-- <td class="{{ $row['status_class'] ?? '' }}">
+                            {{ $row['status'] }}
+                        </td> --}}
+                    </tr>
+                @endforeach
+                </tbody>
+            </table>
+        @endif
+        <p>{!! $wishes !!}</p>
+    </div>
+</body>
+</html>

routes/api.php

@@ -77,7 +77,9 @@ Route::get('/download-reprint-qr-pdf/{palletNo}', [PalletController::class, 'dow
 
 // Route::get('/download-reprint-process-pdf/{plant}/{item}/{process_order}/{coil_number}/{name}', [PalletController::class, 'downloadReprintProcess'])->name('download-reprint-process-pdf');
 
-Route::get('/download-qr1-pdf/{palletNo}', [ProductionStickerReprintController::class, 'downloadQrPdf'])->name('download-qr1-pdf');
+//Route::get('/download-qr1-pdf/{palletNo}', [ProductionStickerReprintController::class, 'downloadQrPdf'])->where('palletNo', '.*')->name('download-qr1-pdf');
+Route::get('/download-qr1-pdf', [ProductionStickerReprintController::class, 'downloadQrPdf'])
+    ->name('download-qr1-pdf');
 
 // Production Dashboard Controller
 
@@ -159,23 +161,23 @@ Route::get('laser/item/get-master-data', [StickerMasterController::class, 'get_m
 
 Route::post('laser/route/data', [CharacteristicsController::class, 'test']); // ->withoutMiddleware(VerifyCsrfToken::class)
 
-// //..Part Validation - Characteristics
+// ..Part Validation - Characteristics
 
-// // Route::get('get-characteristics/master-data', [CharacteristicsController::class, 'getCharacteristicsMaster']);
+// Route::get('get-characteristics/master-data', [CharacteristicsController::class, 'getCharacteristicsMaster']);
 
-// // //..Serial or job
+// ..Serial or job
 
-// // Route::get('laser/characteristics/get', [CharacteristicsController::class, 'getClassChar']);
+// Route::get('laser/characteristics/get', [CharacteristicsController::class, 'getClassChar']);
 
-// // Route::get('laser/characteristics/check', [CharacteristicsController::class, 'checkClassChar']);
+// Route::get('laser/characteristics/check', [CharacteristicsController::class, 'checkClassChar']);
 
-// // //..Job or Master - Characteristics
+// ..Job or Master - Characteristics
 
-// // Route::post('laser/characteristics/data', [CharacteristicsController::class, 'storeClassChar']);
+// Route::post('laser/characteristics/data', [CharacteristicsController::class, 'storeClassChar']);
 
-// // //..serial auto or manual
+// ..serial auto or manual
 
-// // Route::post('laser/characteristics/status', [CharacteristicsController::class, 'storeLaserStatus']);
+// Route::post('laser/characteristics/status', [CharacteristicsController::class, 'storeLaserStatus']);
 
 // ..Product Characteristics
 

routes/console.php

@@ -9,14 +9,9 @@ Artisan::command('inspire', function () {
     $this->comment(Inspiring::quote());
 })->purpose('Display an inspiring quote');
 
-
 Artisan::command('auto:scheduler', function () {
     $this->call('custom:scheduler');
-})->everyMinute();
-
-
-//     Schedule::command('send:invoice-report');
-//   Schedule::command('send:production-report');
+})->everyMinute()->withoutOverlapping();
 
 // app()->booted(function () {
 //     $schedule = app(Schedule::class);