Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory :  /home/fdshops/public_html/app/Console/Commands/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace App\Console\Commands;

use App\Business;
use App\Notifications\CustomerNotification;
use App\NotificationTemplate;
use App\Transaction;
use App\Utils\NotificationUtil;
use Illuminate\Console\Command;
use Notification;

class AutoSendPaymentReminder extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'pos:autoSendPaymentReminder';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Sends payment reminder to customers with overdue sells if auto send is enabled in notification template for payment reminder';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct(NotificationUtil $notificationUtil)
    {
        parent::__construct();

        $this->notificationUtil = $notificationUtil;
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        try {
            ini_set('max_execution_time', 0);
            ini_set('memory_limit', '512M');

            $templates = NotificationTemplate::where('template_for', 'payment_reminder')
                                        ->where(function ($q) {
                                            $q->where('auto_send', 1)
                                            ->orWhere('auto_send_sms', 1)
                                            ->orWhere('auto_send_wa_notif', 1);
                                        })
                                        ->get();

            foreach ($templates as $template) {
                $business = Business::with(['currency'])->where('id', $template->business_id)->first();

                $data = [
                    'subject' => $template->subject ?? '',
                    'sms_body' => $template->sms_body ?? '',
                    'whatsapp_text' => $template->whatsapp_text ?? '',
                    'email_body' => $template->email_body ?? '',
                    'template_for' => 'payment_reminder',
                    'cc' => $template->cc ?? '',
                    'bcc' => $template->bcc ?? '',
                    'auto_send' => ! empty($template->auto_send) ? 1 : 0,
                    'auto_send_sms' => ! empty($template->auto_send_sms) ? 1 : 0,
                    'auto_send_wa_notif' => ! empty($template->auto_send_wa_notif)
                     ? 1 : 0,
                ];

                $orig_data = [
                    'email_body' => $data['email_body'],
                    'sms_body' => $data['sms_body'],
                    'subject' => $data['subject'],
                    'whatsapp_text' => $data['whatsapp_text'],
                ];

                if (! empty($data['auto_send']) || ! empty($data['auto_send_sms'])) {
                    $overdue_sells = Transaction::where('transactions.business_id', $business->id)
                                    ->where('transactions.type', 'sell')
                                    ->where('transactions.status', 'final')
                                    ->leftjoin('activity_log as a', function ($join) {
                                        $join->on('a.subject_id', '=', 'transactions.id')
                                            ->where('subject_type', \App\Transaction::class)
                                            ->where('description', 'payment_reminder');
                                    })
                                    ->whereNull('a.id')
                                    ->with(['contact', 'payment_lines'])
                                    ->select('transactions.*')
                                    ->groupBy('transactions.id')
                                    ->OverDue()
                                    ->get();

                    foreach ($overdue_sells as $sell) {
                        $tag_replaced_data = $this->notificationUtil->replaceTags($business, $orig_data, $sell);

                        $data['email_body'] = $tag_replaced_data['email_body'];
                        $data['sms_body'] = $tag_replaced_data['sms_body'];
                        $data['subject'] = $tag_replaced_data['subject'];
                        $data['whatsapp_text'] = $tag_replaced_data['whatsapp_text'];

                        $data['email_settings'] = $business->email_settings ?? [];
                        $data['sms_settings'] = $business->sms_settings ?? [];

                        //send email notification
                        if (! empty($data['auto_send']) && ! empty($sell->contact->email)) {
                            try {
                                Notification::route('mail', [$sell->contact->email])
                                    ->notify(new CustomerNotification($data));

                                $this->notificationUtil->activityLog($sell, 'payment_reminder', null, ['email' => $sell->contact->email, 'is_automatic' => true], false);
                            } catch (\Exception $e) {
                                \Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
                            }
                        }

                        //send sms notification
                        if (! empty($data['auto_send_sms']) && ! empty($sell->contact->mobile)) {
                            try {
                                $this->notificationUtil->sendSms($data);

                                $this->notificationUtil->activityLog($sell, 'payment_reminder', null, ['mobile' => $sell->contact->mobile, 'is_automatic' => true], false);
                            } catch (\Exception $e) {
                                \Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
                            }
                        }

                        //TODO:: whatsapp notification to be implemented
                    }
                }
            }
        } catch (\Exception $e) {
            \Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());

            exit($e->getMessage());
        }
    }
}