103 lines
4.8 KiB
Markdown
103 lines
4.8 KiB
Markdown
`name` varchar(200) NOT NULL DEFAULT '',
|
|
`country` varchar(200) NOT NULL DEFAULT '',
|
|
`contact_person` varchar(191) DEFAULT NULL,
|
|
`contact_person_phone` varchar(25) DEFAULT NULL,
|
|
`contact_person_email` varchar(191) DEFAULT NULL,
|
|
|
|
`support_emails` text DEFAULT NULL,
|
|
`finance_emails` text DEFAULT NULL,
|
|
`support_skype` text DEFAULT NULL,
|
|
|
|
`technical_support_person` varchar(191) DEFAULT NULL,
|
|
`services` text DEFAULT NULL,
|
|
`buying_rate` decimal(10,4) DEFAULT 0.0000,
|
|
`rate_type` varchar(20) DEFAULT NULL,
|
|
`payment_terms` varchar(20) DEFAULT NULL,
|
|
`sliding_rate_file` text DEFAULT NULL,
|
|
`connection_status` varchar(70) DEFAULT NULL,
|
|
`connection_type` text DEFAULT NULL,
|
|
`integration_type` text DEFAULT NULL,
|
|
`bind_specifics` text DEFAULT NULL,
|
|
`account_manager_id` int(11) DEFAULT NULL,
|
|
`mno_account_manager` varchar(191) DEFAULT NULL,
|
|
`contract_auto_renew` varchar(15) DEFAULT NULL,
|
|
`contract_validity` varchar(191) DEFAULT NULL,
|
|
`direct_business` varchar(10) DEFAULT 'YES',
|
|
|
|
@php
|
|
function renderBadges($jsonString, $type = 'email') {
|
|
$items = json_decode($jsonString, true) ?? [];
|
|
if(count($items) === 0) return '<span class="text-muted small">N/A</span>';
|
|
$html = '';
|
|
foreach($items as $item) {
|
|
$icon = $type == 'email' ? 'bi-envelope' : 'bi-telephone';
|
|
$html .= '<span class="badge bg-light text-dark border me-1 mb-1"><i class="bi '.$icon.' text-secondary me-1"></i>'.$item.'</span>';
|
|
}
|
|
return $html;
|
|
}
|
|
@endphp
|
|
|
|
@php
|
|
$services = json_decode($showclient->services, true) ?? [];
|
|
@endphp
|
|
|
|
@php
|
|
$msgTypes = json_decode($showclient->message_types, true) ?? [];
|
|
@endphp
|
|
|
|
{!! renderBadges($showclient->finance_email, 'email') !!}
|
|
<div>{!! renderBadges($showclient->finance_email, 'email') !!}</div>
|
|
{!! renderBadges($showclient->support_emails, 'email') !!}</div>
|
|
<div>{!! renderBadges($showclient->rate_emails, 'email') !!}</div>
|
|
<div>{!! renderBadges($showclient->support_phones, 'phone') !!}</div>
|
|
|
|
|
|
|
|
<div class="mb-3">
|
|
<div class="text-muted small mb-1">Finance Emails</div>
|
|
@if($showclient->finance_email !== null || $showclient->finance_email !== "")
|
|
<div><?php dump($showclient->finance_email) ?></div>
|
|
<div>{!! renderBadges($showclient->finance_email, 'email') !!}</div>
|
|
@endif
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<div class="text-muted small mb-1">Support Emails</div>
|
|
@if($showclient->support_emails !== null)
|
|
<div>{!! renderBadges($showclient->support_emails, 'email') !!}</div>
|
|
<div><?php dump($showclient->support_emails) ?></div>
|
|
@endif
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<div class="text-muted small mb-1">Rate Emails</div>
|
|
@if($showclient->rate_emails !== null)
|
|
<div><?php dump($showclient->rate_emails) ?></div>
|
|
<div>{!! renderBadges($showclient->rate_emails, 'email') !!}</div>
|
|
@endif
|
|
</div>
|
|
|
|
<div class="mb-0">
|
|
<div class="text-muted small mb-1">Support Phones</div>
|
|
@if($showclient->support_phones !== null)
|
|
<div><?php dump($showclient->support_phones) ?></div>
|
|
<div>{!! renderBadges($showclient->support_phones, 'phone') !!}</div>
|
|
@endif
|
|
</div>
|
|
|
|
|
|
|
|
|
|
@php
|
|
function renderBadges($items, $type = 'email') {
|
|
if(gettype($items) == 'string') return '<span class="text-muted small">'.$items.'</span>';
|
|
elseif(count($items) === 0) return '<span class="text-muted small">N/A</span>';
|
|
$html = '';
|
|
foreach($items as $item) {
|
|
$icon = $type == 'email' ? 'bi-envelope' : 'bi-telephone';
|
|
$html .= '<span class="badge bg-light text-dark border me-1 mb-1"><i class="bi '.$icon.' text-secondary me-1"></i>'.$item.'</span>';
|
|
}
|
|
return $html;
|
|
}
|
|
@endphp
|
|
|