poc/pds
1
0
Fork 1
Code Issues Pull Requests 12 Actions 10 Packages Projects Releases Wiki Activity

Compare commits

base: poc:actions/gemini-pr-review-patch
Branches Tags
poc:master poc:ranjith-dev poc:renovate/althinect-filament-spatie-roles-permissions-3.x poc:renovate/barryvdh-laravel-debugbar-4.x poc:renovate/livewire-livewire-4.x poc:renovate/filament-filament-5.x poc:jothi-patch-1 poc:renovate/vite-7.x poc:renovate/tpetry-laravel-postgresql-enhanced-3.x poc:renovate/tailwindcss-4.x poc:actions/gemini-pr-review-patch poc:dhana-dev poc:renovate/laravel-framework-12.x poc:renovate/laravel-vite-plugin-2.x poc:renovate/alperenersoy-filament-export-4.x poc:qds poc:gha-test
...
compare: poc:f6125512881396b0dc423ca4e6b1e6d72859b0ce
Branches Tags
poc:master poc:ranjith-dev poc:renovate/althinect-filament-spatie-roles-permissions-3.x poc:renovate/barryvdh-laravel-debugbar-4.x poc:renovate/livewire-livewire-4.x poc:renovate/filament-filament-5.x poc:jothi-patch-1 poc:renovate/vite-7.x poc:renovate/tpetry-laravel-postgresql-enhanced-3.x poc:renovate/tailwindcss-4.x poc:actions/gemini-pr-review-patch poc:dhana-dev poc:renovate/laravel-framework-12.x poc:renovate/laravel-vite-plugin-2.x poc:renovate/alperenersoy-filament-export-4.x poc:qds poc:gha-test

7 Commits
actions/ge ... f612551288

Author SHA1 Message Date
jothi
f612551288 Merge pull request 'removed required option in alert mail for schedule type' (#61) from ranjith-dev into master
All checks were successful
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 14s
Details 
Reviewed-on: #61
 2025-12-03 03:17:05 +00:00
dhanabalan
8d1e616777 removed required option in alert mail for schedule type
Some checks failed
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 11s
Details
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (pull_request) Successful in 11s
Details
Gemini PR Review / review (pull_request) Failing after 31s
Details
Laravel Pint / pint (pull_request) Successful in 2m22s
Details
Laravel Larastan / larastan (pull_request) Failing after 3m1s
Details
2025-12-03 08:46:49 +05:30
jothi
4f84735eaf Merge pull request 'correction of alert mail rule logic for invoice data report' (#60) from ranjith-dev into master
All checks were successful
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 10s
Details 
Reviewed-on: #60
 2025-12-03 03:05:35 +00:00
dhanabalan
534ac222fa correction of alert mail rule logic for invoice data report
Some checks failed
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 12s
Details
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (pull_request) Successful in 11s
Details
Gemini PR Review / review (pull_request) Failing after 51s
Details
Laravel Larastan / larastan (pull_request) Failing after 3m1s
Details
Laravel Pint / pint (pull_request) Successful in 2m47s
Details
2025-12-03 08:35:03 +05:30
jothi
45b8c1fbb4 Merge pull request 'corrected logic for mail triggering' (#59) from ranjith-dev into master
All checks were successful
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 10s
Details 
Reviewed-on: #59
 2025-12-02 11:13:56 +00:00
dhanabalan
005ea2cf87 corrected logic for mail triggering
Some checks failed
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 10s
Details
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (pull_request) Successful in 11s
Details
Laravel Pint / pint (pull_request) Failing after 13m36s
Details
Laravel Larastan / larastan (pull_request) Failing after 3m16s
Details
Gemini PR Review / review (pull_request) Failing after 23s
Details
2025-12-02 16:42:37 +05:30
jothi
6015968043 Merge pull request 'Update .github/workflows/gemini-pr-review.yaml' (#58) from actions/gemini-pr-review-patch into master
All checks were successful
Scan for leaked secrets using Kingfisher / kingfisher-secrets-scan (push) Successful in 11s
Details 
Reviewed-on: #58
 2025-12-02 10:57:48 +00:00
4 changed files with 290 additions and 95 deletions
Expand all files Collapse all files

202
app/Console/Commands/Scheduler.php Normal file
View File

@@ -0,0 +1,202 @@
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use Illuminate\Console\Scheduling\Schedule;
use App\Models\AlertMailRule;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Support\Facades\Log;
class Scheduler extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
// protected $signature = 'app:scheduler';
protected $signature = 'custom:scheduler';
/**
* The console command description.
*
* @var string
*/
// protected $description = 'Command description';
protected $description = 'Manually trigger scheduler logic';
/**
* Execute the console command.
*/
// public function handle()
// {
// //
// }
public function handle()
{
// --- Production Rules ---
$productionRules = AlertMailRule::where('module', 'ProductionQuantities')
->where('rule_name', 'ProductionMail')
->select('plant', 'schedule_type')
->distinct()
->get();
foreach ($productionRules as $rule) {
switch ($rule->schedule_type) {
case 'Live':
// Run every minute
\Artisan::call('send:production-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
break;
case 'Hourly':
if (now()->minute == 0) {
\Artisan::call('send:production-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
case 'Daily':
if (now()->format('H:i') == '07:59') {
\Artisan::call('send:production-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
}
}
// --- Invoice Validation Rules ---
$invoiceRules = AlertMailRule::where('module', 'InvoiceValidation')
->where('rule_name', 'InvoiceMail')
->select('plant', 'schedule_type')
->distinct()
->get();
foreach ($invoiceRules as $rule) {
switch ($rule->schedule_type) {
case 'Live':
// Run every minute
\Artisan::call('send:invoice-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
break;
case 'Hourly':
if (now()->minute == 0) {
\Artisan::call('send:invoice-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
case 'Daily':
if (now()->format('H:i') == '07:59') {
\Artisan::call('send:invoice-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
}
}
// foreach ($invoiceRules as $rule) {
// switch ($rule->schedule_type) {
// case 'Live':
// try {
// Artisan::call('send:invoice-report', [
// 'schedule_type' => $rule->schedule_type,
// 'plant' => $rule->plant,
// ]);
// Log::info('Invoice report sent | Plant: '.$rule->plant);
// } catch (\Throwable $e) {
// Log::error("Invoice Live Failed ({$rule->plant}): ".$e->getMessage());
// }
// break;
// case 'Hourly':
// if (now()->minute == 0) {
// Artisan::call('send:invoice-report', [
// 'schedule_type' => $rule->schedule_type,
// 'plant' => $rule->plant,
// ]);
// }
// break;
// case 'Daily':
// if (now()->format('H:i') == '07:59') {
// Artisan::call('send:invoice-report', [
// 'schedule_type' => $rule->schedule_type,
// 'plant' => $rule->plant,
// ]);
// }
// break;
// }
// }
// --- Invoice Data Report Rules ---
$invoiceDataRules = AlertMailRule::where('module', 'InvoiceDataReport')
->where('rule_name', 'InvoiceDataMail')
->select('plant', 'schedule_type')
->distinct()
->get();
foreach ($invoiceDataRules as $rule) {
switch ($rule->schedule_type) {
case 'Live':
// Run every minute
\Artisan::call('send:invoice-data-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
break;
case 'Hourly':
if (now()->minute == 0) {
\Artisan::call('send:invoice-data-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
case 'Daily':
if (now()->format('H:i') == '10:00') {
\Artisan::call('send:invoice-data-report', [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
}
break;
}
}
}
/**
* Helper to call Artisan commands with parameters.
*/
protected function callArtisanCommand($commandName, $rule)
{
\Artisan::call($commandName, [
'schedule_type' => $rule->schedule_type,
'plant' => $rule->plant,
]);
$this->info("Executed {$commandName} for plant: {$rule->plant}");
\Log::info("Executed {$commandName} for plant: {$rule->plant}");
}
}

18
app/Console/Commands/SendInvoiceReport.php
View File

@@ -2,11 +2,11 @@
namespace App\Console\Commands; namespace App\Console\Commands;
use App\Mail\test;
use App\Models\InvoiceValidation; use App\Models\InvoiceValidation;
use App\Models\Plant; use App\Models\Plant;
use Illuminate\Console\Command; use Illuminate\Console\Command;
use Illuminate\Support\Facades\Mail; use Illuminate\Support\Facades\Mail;
use App\Mail\test;
class SendInvoiceReport extends Command class SendInvoiceReport extends Command
{ {
@@ -18,7 +18,6 @@ class SendInvoiceReport extends Command
// protected $signature = 'app:send-invoice-report'; // protected $signature = 'app:send-invoice-report';
protected $signature = 'send:invoice-report {schedule_type} {plant}'; protected $signature = 'send:invoice-report {schedule_type} {plant}';
/** /**
* The console command description. * The console command description.
* *
@@ -29,8 +28,6 @@ class SendInvoiceReport extends Command
/** /**
* Execute the console command. * Execute the console command.
*/ */
public function handle() public function handle()
{ {
$schedule = $this->argument('schedule_type'); $schedule = $this->argument('schedule_type');
@@ -52,18 +49,14 @@ class SendInvoiceReport extends Command
: [$plantIdArg]; : [$plantIdArg];
$no = 1; $no = 1;
if (strtolower($schedule) == 'daily') if (strtolower($schedule) == 'daily') {
{
$startDate = now()->subDay()->setTime(8, 0, 0); $startDate = now()->subDay()->setTime(8, 0, 0);
$endDate = now()->setTime(8, 0, 0); $endDate = now()->setTime(8, 0, 0);
} } else {
else
{
$startDate = now()->setTime(8, 0, 0); $startDate = now()->setTime(8, 0, 0);
$endDate = now()->copy()->addDay()->setTime(8, 0, 0); $endDate = now()->copy()->addDay()->setTime(8, 0, 0);
} }
foreach ($plantIds as $plantId) foreach ($plantIds as $plantId) {
{
$plant = Plant::find($plantId); $plant = Plant::find($plantId);
$plantName = $plant ? $plant->name : $plantId; $plantName = $plant ? $plant->name : $plantId;
@@ -193,7 +186,6 @@ class SendInvoiceReport extends Command
} }
} }
// Send to MaterialInvoiceMail recipients (material + bundle table) // Send to MaterialInvoiceMail recipients (material + bundle table)
if ($mailRules->has('MaterialInvoiceMail')) { if ($mailRules->has('MaterialInvoiceMail')) {
$emails = $mailRules['MaterialInvoiceMail']->pluck('email')->unique()->toArray(); $emails = $mailRules['MaterialInvoiceMail']->pluck('email')->unique()->toArray();
@@ -222,6 +214,4 @@ class SendInvoiceReport extends Command
$this->info($contentVars['wishes'] ?? ''); $this->info($contentVars['wishes'] ?? '');
} }
} }

1
app/Filament/Resources/AlertMailRuleResource.php
View File

@@ -70,7 +70,6 @@ class AlertMailRuleResource extends Resource
->label('CC Emails'), ->label('CC Emails'),
Forms\Components\Select::make('schedule_type') Forms\Components\Select::make('schedule_type')
->label('Schedule Type') ->label('Schedule Type')
->required()
->options([ ->options([
'Live' => 'Live', 'Live' => 'Live',
'Hourly' => 'Hourly', 'Hourly' => 'Hourly',

146
routes/console.php
View File

@@ -2,8 +2,6 @@
use Illuminate\Foundation\Inspiring; use Illuminate\Foundation\Inspiring;
use Illuminate\Support\Facades\Artisan; use Illuminate\Support\Facades\Artisan;
use App\Models\AlertMailRule;
use Illuminate\Console\Scheduling\Schedule;
@@ -11,87 +9,93 @@ Artisan::command('inspire', function () {
$this->comment(Inspiring::quote()); $this->comment(Inspiring::quote());
})->purpose('Display an 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:invoice-report');
// Schedule::command('send:production-report'); // Schedule::command('send:production-report');
app()->booted(function () { // app()->booted(function () {
$schedule = app(Schedule::class); // $schedule = app(Schedule::class);
// $schedule->command('report:send-daily-production')->dailyAt('07:59'); // // $schedule->command('report:send-daily-production')->dailyAt('07:59');
// Production report scheduling // // Production report scheduling
$productionRules = AlertMailRule::where('module', 'ProductionQuantities') // $productionRules = AlertMailRule::where('module', 'ProductionQuantities')
->where('rule_name', 'ProductionMail') // ->where('rule_name', 'ProductionMail')
->select('plant', 'schedule_type') // ->select('plant', 'schedule_type')
->distinct() // ->distinct()
->get(); // ->get();
foreach ($productionRules as $rule) { // foreach ($productionRules as $rule) {
$type = $rule->schedule_type; // $type = $rule->schedule_type;
$plantId = $rule->plant; // $plantId = $rule->plant;
$command = $schedule->command('send:production-report', [$type, $plantId]); // $command = $schedule->command('send:production-report', [$type, $plantId]);
// ->appendOutputTo(storage_path('logs/scheduler.log')); // // ->appendOutputTo(storage_path('logs/scheduler.log'));
switch ($type) { // switch ($type) {
case 'Live': // case 'Live':
$command->everyMinute(); // $command->everyMinute();
break; // break;
case 'Hourly': // case 'Hourly':
$command->hourly(); // $command->hourly();
break; // break;
case 'Daily': // case 'Daily':
$command->dailyAt('07:59'); // $command->dailyAt('07:59');
break; // break;
} // }
} // }
// Invoice report scheduling // // Invoice report scheduling
$invoiceRules = AlertMailRule::where('module', 'InvoiceValidation') // $invoiceRules = AlertMailRule::where('module', 'InvoiceValidation')
->select('plant', 'schedule_type') // ->select('plant', 'schedule_type')
->distinct() // ->distinct()
->get(); // ->get();
foreach ($invoiceRules as $rule) { // foreach ($invoiceRules as $rule) {
$type = $rule->schedule_type; // $type = $rule->schedule_type;
$plantId = $rule->plant; // $plantId = $rule->plant;
$command = $schedule->command('send:invoice-report', [$type, $plantId]); // $command = $schedule->command('send:invoice-report', [$type, $plantId]);
switch ($type) { // switch ($type) {
case 'Live': // case 'Live':
$command->everyMinute(); // $command->everyMinute();
break; // break;
case 'Hourly': // case 'Hourly':
$command->hourly(); // $command->hourly();
break; // break;
case 'Daily': // case 'Daily':
$command->dailyAt('07:59'); // $command->dailyAt('07:59');
break; // break;
} // }
} // }
// Invoice Data Report Scheduling // // Invoice Data Report Scheduling
$invoiceDataRules = AlertMailRule::where('module', 'InvoiceDataReport') // $invoiceDataRules = AlertMailRule::where('module', 'InvoiceDataReport')
->select('plant', 'schedule_type') // ->select('plant', 'schedule_type')
->distinct() // ->distinct()
->get(); // ->get();
foreach ($invoiceDataRules as $rule) { // foreach ($invoiceDataRules as $rule) {
$type = $rule->schedule_type; // $type = $rule->schedule_type;
$plantId = $rule->plant; // $plantId = $rule->plant;
$command = $schedule->command('send:invoice-data-report', [$type, $plantId]); // $command = $schedule->command('send:invoice-data-report', [$type, $plantId]);
switch ($type) { // switch ($type) {
case 'Live': // case 'Live':
$command->everyMinute(); // $command->everyMinute();
break; // break;
case 'Hourly': // case 'Hourly':
$command->hourly(); // $command->hourly();
break; // break;
case 'Daily': // case 'Daily':
$command->dailyAt('10:00'); // $command->dailyAt('10:00');
break; // break;
} // }
} // }
}); // });