/ home / signgwph / signaltechdemo5.com / app / Models / [ HOME SHELL ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
AcceptEstimate.php	1.79 KB	-rw-r--r--
Appreciation.php	2.68 KB	-rw-r--r--
Attendance.php	17.04 KB	-rw-r--r--
AttendanceRegularisation.php	582 B	-rw-r--r--
AttendanceSetting.php	4.75 KB	-rw-r--r--
AutomateShift.php	704 B	-rw-r--r--
Award.php	1.86 KB	-rw-r--r--
AwardIcon.php	1.21 KB	-rw-r--r--
BankAccount.php	3.75 KB	-rw-r--r--
BankTransaction.php	3.28 KB	-rw-r--r--
BaseModel.php	1.7 KB	-rw-r--r--
ClientCategory.php	1.17 KB	-rw-r--r--
ClientContact.php	2.11 KB	-rw-r--r--
ClientDetails.php	5.39 KB	-rw-r--r--
ClientDocument.php	2.57 KB	-rw-r--r--
ClientNote.php	2.54 KB	-rw-r--r--
ClientSubCategory.php	1.57 KB	-rw-r--r--
ClientUserNote.php	1.34 KB	-rw-r--r--
Company.php	23.63 KB	-rw-r--r--
CompanyAddress.php	2.5 KB	-rw-r--r--
Contract.php	8.1 KB	-rw-r--r--
ContractDiscussion.php	2.05 KB	-rw-r--r--
ContractFile.php	3.37 KB	-rw-r--r--
ContractRenew.php	2.45 KB	-rw-r--r--
ContractSign.php	2.24 KB	-rw-r--r--
ContractTemplate.php	2.53 KB	-rw-r--r--
ContractType.php	1.13 KB	-rw-r--r--
Country.php	8.6 KB	-rw-r--r--
CreditNoteItem.php	3.51 KB	-rw-r--r--
CreditNoteItemImage.php	2.33 KB	-rw-r--r--
CreditNotes.php	8.82 KB	-rw-r--r--
Currency.php	2.47 KB	-rw-r--r--
CurrencyFormatSetting.php	1.61 KB	-rw-r--r--
CustomField.php	5.94 KB	-rw-r--r--
CustomFieldGroup.php	3.83 KB	-rw-r--r--
CustomLinkSetting.php	1.59 KB	-rw-r--r--
CustomModulePermission.php	498 B	-rw-r--r--
DashboardWidget.php	10.29 KB	-rw-r--r--
DatabaseBackup.php	933 B	-rw-r--r--
DatabaseBackupSetting.php	1.17 KB	-rw-r--r--
Deal.php	9.51 KB	-rw-r--r--
DealFile.php	2.52 KB	-rw-r--r--
DealFollowUp.php	2.69 KB	-rw-r--r--
DealHistory.php	981 B	-rw-r--r--
DealNote.php	2.62 KB	-rw-r--r--
Designation.php	2.33 KB	-rw-r--r--
Discussion.php	4.83 KB	-rw-r--r--
DiscussionCategory.php	1.42 KB	-rw-r--r--
DiscussionFile.php	3.22 KB	-rw-r--r--
DiscussionReply.php	3.42 KB	-rw-r--r--
EmailNotificationSetting.php	8.16 KB	-rw-r--r--
EmergencyContact.php	2.19 KB	-rw-r--r--
EmployeeActivity.php	927 B	-rw-r--r--
EmployeeDetails.php	5.32 KB	-rw-r--r--
EmployeeDocument.php	2.55 KB	-rw-r--r--
EmployeeDocumentExpiry.php	3.8 KB	-rw-r--r--
EmployeeLeaveQuota.php	1.85 KB	-rw-r--r--
EmployeeLeaveQuotaHistory.php	469 B	-rw-r--r--
EmployeeShift.php	2.63 KB	-rw-r--r--
EmployeeShiftChangeRequest.php	2.18 KB	-rw-r--r--
EmployeeShiftSchedule.php	3.81 KB	-rw-r--r--
EmployeeSkill.php	1.61 KB	-rw-r--r--
EmployeeTeam.php	1.5 KB	-rw-r--r--
Estimate.php	6.5 KB	-rw-r--r--
EstimateItem.php	3.44 KB	-rw-r--r--
EstimateItemImage.php	2.51 KB	-rw-r--r--
EstimateRequest.php	1.14 KB	-rw-r--r--
EstimateTemplate.php	4.06 KB	-rw-r--r--
EstimateTemplateItem.php	3.76 KB	-rw-r--r--
EstimateTemplateItemImage.php	2.58 KB	-rw-r--r--
Event.php	5.13 KB	-rw-r--r--
EventAttendee.php	1.66 KB	-rw-r--r--
EventFile.php	1.98 KB	-rw-r--r--
Expense.php	7.52 KB	-rw-r--r--
ExpenseRecurring.php	6.9 KB	-rw-r--r--
ExpensesCategory.php	2.17 KB	-rw-r--r--
ExpensesCategoryRole.php	1.72 KB	-rw-r--r--
FileStorage.php	2.64 KB	-rw-r--r--
Flag.php	962 B	-rw-r--r--
GanttLink.php	144 B	-rw-r--r--
GdprSetting.php	2.61 KB	-rw-r--r--
GlobalSetting.php	22.56 KB	-rw-r--r--
GoogleCalendarModule.php	2.02 KB	-rw-r--r--
Holiday.php	5.23 KB	-rw-r--r--
Invoice.php	12.7 KB	-rw-r--r--
InvoiceFiles.php	2.25 KB	-rw-r--r--
InvoiceItemImage.php	2.29 KB	-rw-r--r--
InvoiceItems.php	3.6 KB	-rw-r--r--
InvoicePaymentDetail.php	1.05 KB	-rw-r--r--
InvoiceSetting.php	7.82 KB	-rw-r--r--
Issue.php	2.65 KB	-rw-r--r--
KnowledgeBase.php	2.32 KB	-rw-r--r--
KnowledgeBaseCategory.php	1.61 KB	-rw-r--r--
KnowledgeBaseFile.php	2.57 KB	-rw-r--r--
LanguageSetting.php	7.94 KB	-rw-r--r--
Lead.php	8.23 KB	-rw-r--r--
LeadAgent.php	2.05 KB	-rw-r--r--
LeadCategory.php	1.65 KB	-rw-r--r--
LeadCustomForm.php	4.98 KB	-rw-r--r--
LeadNote.php	2.54 KB	-rw-r--r--
LeadPipeline.php	2.6 KB	-rw-r--r--
LeadPipelineStages.php	2.58 KB	-rw-r--r--
LeadProduct.php	1.61 KB	-rw-r--r--
LeadSetting.php	227 B	-rw-r--r--
LeadSource.php	1.72 KB	-rw-r--r--
LeadStatus.php	2 KB	-rw-r--r--
LeadUserNote.php	1.09 KB	-rw-r--r--
Leave.php	8.57 KB	-rw-r--r--
LeaveFile.php	2.28 KB	-rw-r--r--
LeaveSetting.php	1.18 KB	-rw-r--r--
LeaveType.php	9.58 KB	-rw-r--r--
LogTimeFor.php	2.03 KB	-rw-r--r--
MentionUser.php	2.86 KB	-rw-r--r--
Menu.php	1.63 KB	-rw-r--r--
MessageSetting.php	1.59 KB	-rw-r--r--
MobileAppDownloadSetting.php	738 B	-rw-r--r--
Module.php	69.85 KB	-rw-r--r--
ModuleSetting.php	3.87 KB	-rw-r--r--
Notice.php	3.27 KB	-rw-r--r--
NoticeBoardUser.php	498 B	-rw-r--r--
NoticeFile.php	702 B	-rw-r--r--
NoticeView.php	1.69 KB	-rw-r--r--
Notification.php	1.62 KB	-rw-r--r--
OfflinePaymentMethod.php	2.41 KB	-rw-r--r--
Order.php	5.7 KB	-rw-r--r--
OrderCart.php	2.93 KB	-rw-r--r--
OrderItemImage.php	1.55 KB	-rw-r--r--
OrderItems.php	3.8 KB	-rw-r--r--
Passport.php	2.6 KB	-rw-r--r--
Payment.php	8.27 KB	-rw-r--r--
PaymentGatewayCredentials.php	12.54 KB	-rw-r--r--
Permission.php	2.38 KB	-rw-r--r--
PermissionRole.php	10.66 KB	-rw-r--r--
PermissionType.php	1.28 KB	-rw-r--r--
Pinned.php	1.87 KB	-rw-r--r--
PipelineStage.php	2.8 KB	-rw-r--r--
Product.php	8.8 KB	-rw-r--r--
ProductCategory.php	1.54 KB	-rw-r--r--
ProductFiles.php	3.11 KB	-rw-r--r--
ProductSubCategory.php	1.6 KB	-rw-r--r--
Project.php	18.31 KB	-rw-r--r--
ProjectActivity.php	2.12 KB	-rw-r--r--
ProjectCategory.php	2.03 KB	-rw-r--r--
ProjectDepartment.php	492 B	-rw-r--r--
ProjectFile.php	2.97 KB	-rw-r--r--
ProjectLabel.php	1.28 KB	-rw-r--r--
ProjectLabelList.php	1.8 KB	-rw-r--r--
ProjectMember.php	2.77 KB	-rw-r--r--
ProjectMilestone.php	3.74 KB	-rw-r--r--
ProjectNote.php	3.49 KB	-rw-r--r--
ProjectRating.php	1.69 KB	-rw-r--r--
ProjectSetting.php	1.82 KB	-rw-r--r--
ProjectStatusSetting.php	2.49 KB	-rw-r--r--
ProjectSubCategory.php	1.81 KB	-rw-r--r--
ProjectTemplate.php	5.09 KB	-rw-r--r--
ProjectTemplateMember.php	2.42 KB	-rw-r--r--
ProjectTemplateMilestone.php	3.8 KB	-rw-r--r--
ProjectTemplateSubTask.php	1.89 KB	-rw-r--r--
ProjectTemplateTask.php	3.08 KB	-rw-r--r--
ProjectTemplateTaskUser.php	1.61 KB	-rw-r--r--
ProjectTimeLog.php	11.47 KB	-rw-r--r--
ProjectTimeLogBreak.php	5.24 KB	-rw-r--r--
ProjectUserNote.php	1.25 KB	-rw-r--r--
Promotion.php	1.31 KB	-rw-r--r--
Proposal.php	5.13 KB	-rw-r--r--
ProposalItem.php	3.44 KB	-rw-r--r--
ProposalItemImage.php	2.51 KB	-rw-r--r--
ProposalSign.php	1.45 KB	-rw-r--r--
ProposalTemplate.php	3.66 KB	-rw-r--r--
ProposalTemplateItem.php	3.06 KB	-rw-r--r--
ProposalTemplateItemImage.php	2.58 KB	-rw-r--r--
PurposeConsent.php	1.57 KB	-rw-r--r--
PurposeConsentLead.php	1.76 KB	-rw-r--r--
PurposeConsentUser.php	1.66 KB	-rw-r--r--
PushNotificationSetting.php	1.87 KB	-rw-r--r--
PusherSetting.php	1.8 KB	-rw-r--r--
Qrcodes.php	219 B	-rw-r--r--
QuickBooksSetting.php	2.35 KB	-rw-r--r--
RecurringInvoice.php	8.22 KB	-rw-r--r--
RecurringInvoiceItemImage.php	2.57 KB	-rw-r--r--
RecurringInvoiceItems.php	2.94 KB	-rw-r--r--
RecurringInvoiceLog.php	642 B	-rw-r--r--
RemovalRequest.php	1.69 KB	-rw-r--r--
RemovalRequestLead.php	1.79 KB	-rw-r--r--
Role.php	3.54 KB	-rw-r--r--
RoleUser.php	1 KB	-rw-r--r--
RotationAutomateLog.php	176 B	-rw-r--r--
Session.php	1.1 KB	-rw-r--r--
ShiftRotation.php	702 B	-rw-r--r--
ShiftRotationSequence.php	544 B	-rw-r--r--
SignUpSetting.php	453 B	-rw-r--r--
Skill.php	1.12 KB	-rw-r--r--
SlackSetting.php	1.77 KB	-rw-r--r--
SmtpSetting.php	3.87 KB	-rw-r--r--
Social.php	1.13 KB	-rwxr-xr-x
SocialAuthSetting.php	3.49 KB	-rw-r--r--
StickyNote.php	1.84 KB	-rw-r--r--
StorageSetting.php	4.01 KB	-rw-r--r--
SubTask.php	2.67 KB	-rw-r--r--
SubTaskFile.php	3.02 KB	-rw-r--r--
Task.php	22.44 KB	-rw-r--r--
TaskCategory.php	1.69 KB	-rw-r--r--
TaskComment.php	8.87 KB	-rw-r--r--
TaskCommentEmoji.php	1.6 KB	-rw-r--r--
TaskFile.php	2.88 KB	-rw-r--r--
TaskHistory.php	2.24 KB	-rw-r--r--
TaskLabel.php	1.24 KB	-rw-r--r--
TaskLabelList.php	1.76 KB	-rw-r--r--
TaskNote.php	2.67 KB	-rw-r--r--
TaskSetting.php	3.54 KB	-rw-r--r--
TaskTag.php	626 B	-rw-r--r--
TaskTagList.php	472 B	-rw-r--r--
TaskUser.php	1.71 KB	-rw-r--r--
TaskboardColumn.php	2.55 KB	-rw-r--r--
Tax.php	1.65 KB	-rw-r--r--
Team.php	2.5 KB	-rw-r--r--
ThemeSetting.php	1.89 KB	-rw-r--r--
Ticket.php	11.39 KB	-rw-r--r--
TicketActivity.php	4.32 KB	-rw-r--r--
TicketAgentGroups.php	2.04 KB	-rw-r--r--
TicketChannel.php	1.43 KB	-rw-r--r--
TicketCustomForm.php	2.27 KB	-rw-r--r--
TicketEmailSetting.php	2.39 KB	-rw-r--r--
TicketFile.php	2.91 KB	-rw-r--r--
TicketGroup.php	1.83 KB	-rw-r--r--
TicketReply.php	3.18 KB	-rw-r--r--
TicketReplyTemplate.php	1.34 KB	-rw-r--r--
TicketReplyUser.php	492 B	-rw-r--r--
TicketSettingForAgents.php	456 B	-rw-r--r--
TicketTag.php	1.45 KB	-rw-r--r--
TicketTagList.php	1.21 KB	-rw-r--r--
TicketType.php	1.38 KB	-rw-r--r--
TranslateSetting.php	1.03 KB	-rw-r--r--
UnitType.php	9.5 KB	-rw-r--r--
UniversalSearch.php	1.58 KB	-rw-r--r--
User.php	41.94 KB	-rw-r--r--
UserActivity.php	1.5 KB	-rw-r--r--
UserChat.php	6.85 KB	-rw-r--r--
UserInvitation.php	2.33 KB	-rw-r--r--
UserLeadboardSetting.php	1.68 KB	-rw-r--r--
UserPermission.php	2.27 KB	-rw-r--r--
UserTaskboardSetting.php	1.53 KB	-rw-r--r--
UserchatFile.php	3.03 KB	-rw-r--r--
VisaDetail.php	2.64 KB	-rw-r--r--
WeeklyTimesheet.php	845 B	-rw-r--r--
WeeklyTimesheetEntries.php	573 B	-rw-r--r--
goat1.php	143.87 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : UserChat.php

<?php

namespace App\Models;

use App\Scopes\ActiveScope;
use App\Traits\HasCompany;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Query\Builder as QueryBuilder;
use Illuminate\Support\Facades\DB;

/**
 * App\Models\UserChat
 *
 * @property int $id
 * @property int $user_one
 * @property int $user_id
 * @property int $notification_sent
 * @property string $message
 * @property int|null $from
 * @property int|null $to
 * @property string $message_seen
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property-read \App\Models\User|null $fromUser
 * @property-read mixed $icon
 * @property-read \App\Models\User|null $toUser
 * @method static Builder|UserChat lastPerGroup(?array $fields = null)
 * @method static Builder|UserChat newModelQuery()
 * @method static Builder|UserChat newQuery()
 * @method static Builder|UserChat query()
 * @method static Builder|UserChat whereCreatedAt($value)
 * @method static Builder|UserChat whereFrom($value)
 * @method static Builder|UserChat whereId($value)
 * @method static Builder|UserChat whereMessage($value)
 * @method static Builder|UserChat whereMessageSeen($value)
 * @method static Builder|UserChat whereTo($value)
 * @method static Builder|UserChat whereUpdatedAt($value)
 * @method static Builder|UserChat whereUserId($value)
 * @method static Builder|UserChat whereUserOne($value)
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\UserchatFile[] $files
 * @property-read int|null $files_count
 * @method static \Database\Factories\UserChatFactory factory(...$parameters)
 * @property int|null $company_id
 * @property-read \App\Models\Company|null $company
 * @method static Builder|UserChat whereCompanyId($value)
 * @method static Builder|UserChat whereNotificationSent($value)
 * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\MentionUser> $mentionProject
 * @property-read int|null $mention_project_count
 * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\User> $mentionUser
 * @property-read int|null $mention_user_count
 * @mixin \Eloquent
 */
class UserChat extends BaseModel
{

use HasCompany;
    use HasFactory;

protected $table = 'users_chat';

protected $guarded = [
        'id'
    ];

public function fromUser(): BelongsTo
    {
        return $this->belongsTo(User::class, 'from')->withoutGlobalScope(ActiveScope::class);
    }

public function toUser(): BelongsTo
    {
        return $this->belongsTo(User::class, 'to')->withoutGlobalScope(ActiveScope::class);
    }

public static function chatDetail($id, $userID)
    {
        return UserChat::with('fromUser', 'toUser', 'files')->where(function ($q) use ($id, $userID) {
            $q->Where('user_id', $id)->Where('user_one', $userID)
                ->orwhere(function ($q) use ($id, $userID) {
                    $q->Where('user_one', $id)
                        ->Where('user_id', $userID);
                });
        })
            ->orderBy('created_at', 'asc')->get();
    }

public static function messageSeenUpdate($loginUser, $toUser, $updateData)
    {
        return UserChat::where('from', $toUser)->where('to', $loginUser)->update($updateData);
    }

/**
     * Get the latest entry for each group.
     *
     * Each group is composed of one or more columns that make a unique combination to return the
     * last entry for.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param array|null $fields A list of fields that's considered as a unique entry by the query.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeLastPerGroup(Builder $query, ?array $fields = null): Builder
    {
        return $query->whereIn('id', function (QueryBuilder $query) use ($fields) {
            return $query->from(static::getTable())
                ->selectRaw('max(`id`)')
                ->groupBy($fields);
        });
    }

public static function userList()
    {
        return UserChat::with('toUser')->select('users_chat.*')
            ->lastPerGroup(['user_id'])
            ->where('from', user()->id)
            ->orWhere('to', user()->id)
            ->get();
    }

public static function userListLatest($userID, $term)
    {
        // Prepare bindings array
        $bindings = [$userID, $userID];
        
        // Build the WHERE clause securely
        if ($term) {
            $termCnd = 'AND (users.name LIKE ? OR u.name LIKE ?)';
            // Add term parameter bindings with wildcards
            $bindings[] = '%' . $term . '%';
            $bindings[] = '%' . $term . '%';
        }
        else {
            $termCnd = '';
        }

return DB::select('
            SELECT t1.id
            FROM users_chat AS t1
            INNER JOIN users ON users.id = t1.user_one
            INNER JOIN users as u ON u.id = t1.user_id
            INNER JOIN
            (
                SELECT
                    LEAST(user_one, user_id) AS sender,
                    GREATEST(user_one, user_id) AS receiver,
                    MAX(id) AS max_id
                FROM users_chat
                GROUP BY
                    LEAST(user_one, user_id),
                    GREATEST(user_one, user_id)
            ) AS t2
                ON LEAST(t1.user_one, t1.user_id) = t2.sender AND
                GREATEST(t1.user_one, t1.user_id) = t2.receiver AND
                t1.id = t2.max_id
                WHERE (t1.user_one = ? OR t1.user_id = ?) ' . $termCnd . '
                ORDER BY t1.created_at DESC
            ', $bindings);
    }

public function files()
    {
        return $this->hasMany(UserchatFile::class, 'users_chat_id');
    }

public static function chatDetailViaId($chatId)
    {
        $userChat = UserChat::findOrFail($chatId);

if ($userChat) {
            $user1 = $userChat->from;
            $user2 = $userChat->to;

return UserChat::with('fromUser', 'toUser', 'files')->where(function ($q) use ($user1, $user2) {
                $q->Where('user_id', $user1)->Where('user_one', $user2)
                    ->orwhere(function ($q) use ($user1, $user2) {
                        $q->Where('user_one', $user1)
                            ->Where('user_id', $user2);
                    });
            })->orderBy('created_at', 'asc')->get();
        }

return null;

}

public function mentionUser(): BelongsToMany
    {
        return $this->belongsToMany(User::class, 'mention_users')->withoutGlobalScope(ActiveScope::class)->using(MentionUser::class);
    }

public function mentionProject(): HasMany
    {
        return $this->hasMany(MentionUser::class, 'project_id');
    }

}

Performers – Signal Health Group of Naples

Performers

[em_performers]

Code Editor : UserChat.php

Performers

Quick Links

Elite Caregivers USA, LLC

Useful Links

${this.title}

Code Editor : UserChat.php

Quick Links

Elite Caregivers USA, LLC

Useful Links