Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/ts.corals.io/corals-api/Corals/modules/Utility/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

use Corals\User\Communication\Models\NotificationTemplate;
use Illuminate\Database\Schema\Blueprint;

if ( !\Schema::hasColumn('utility_comments', 'status')) {

    \Illuminate\Support\Facades\Schema::table('utility_comments', function (Blueprint $table) {
        $table->string('status')->nullable()->after('body');
    });
}

\Illuminate\Support\Facades\DB::table('permissions')->insert([
    'name' => 'Utility::comment.set_status',
    'guard_name' => config('auth.defaults.guard'),
    'created_at' => now(),
    'updated_at' => now(),
]);

NotificationTemplate::updateOrCreate(['name' => 'notifications.comment.comment_created'], [
    'friendly_name' => 'New Comment Created',
    'title' => 'New Comment has been created',
    'extras' => [
        "bcc_users" => ["1"]
    ],
    'body' => [
        'mail' => '<table align="center" border="0" cellpadding="0" cellspacing="0" style="max-width:600px;" width="100%"><tbody><tr><td align="left" style="font-family: Open Sans, Helvetica, Arial, sans-serif; font-size: 16px; font-weight: 400; line-height: 24px; padding-bottom: 15px;">
<p style="font-size: 18px; font-weight: 800; line-height: 24px; color: #333333;">Hello there,</p>
<p style="font-size: 16px; font-weight: 400; line-height: 24px; color: #777777;">
<br/>
New Comment for "<b>{commentable_identifier}</b>" ({commentable_class}) has been created by {author_name} ({author_email}).
<br/>
Check the following details:
<br/>
Comment Body: {comment_body},<br/>
Comment Status: {comment_status},
<br/>
<br/>
Thanks.
</p></td></tr></tbody></table>',
        'database' => 'New Comment for "<b>{commentable_identifier}</b>" ({commentable_class}) has been created by {author_name} ({author_email}).<br/>
Check the following details:
<br/>
Comment Body: {comment_body},<br/>
Comment Status: {comment_status},'
    ],
    'via' => ["mail", "database"]
]);

NotificationTemplate::updateOrCreate(['name' => 'notifications.comment.comment_toggle_status'], [
    'friendly_name' => 'Comment Status',
    'title' => 'Comment status has been changed',
    'extras' => [
        "bcc_users" => ["1"]
    ],
    'body' => [
        'mail' => '<table align="center" border="0" cellpadding="0" cellspacing="0" style="max-width:600px;" width="100%"><tbody><tr><td align="left" style="font-family: Open Sans, Helvetica, Arial, sans-serif; font-size: 16px; font-weight: 400; line-height: 24px; padding-bottom: 15px;">
<p style="font-size: 18px; font-weight: 800; line-height: 24px; color: #333333;">Hello there,</p>
<p style="font-size: 16px; font-weight: 400; line-height: 24px; color: #777777;">
<br/>
Comment status for "<b>{commentable_identifier}</b>" ({commentable_class}) has been changed for {author_name} ({author_email}).
<br/>
Check the following details:
<br/>
Comment Body: {comment_body},<br/>
Comment Status: {comment_status},
<br/>
<br/>
Thanks.
</p></td></tr></tbody></table>',
        'database' => 'Comment status for "<b>{commentable_identifier}</b>" ({commentable_class}) has been changed for {author_name} ({author_email}).<br/>
Check the following details:
<br/>
Comment Body: {comment_body},<br/>
Comment Status: {comment_status},'
    ],
    'via' => ["mail", "database"]
]);