91 lines
3.6 KiB
PHP
91 lines
3.6 KiB
PHP
<?php
|
|
|
|
namespace App\Integrations\Whmcs\Transformers;
|
|
|
|
use App\Integrations\Whmcs\DTOs\ClientData;
|
|
use App\Integrations\Whmcs\Support\SyncReport;
|
|
use App\Support\PhoneNumber;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class ClientTransformer
|
|
{
|
|
/** @var array<string, int>|null fullname => user id, cached for the process lifetime */
|
|
private static ?array $salerIdsByName = null;
|
|
|
|
public function __construct(private SyncReport $report)
|
|
{
|
|
}
|
|
|
|
/**
|
|
* Map a raw `tblclients` row (array or stdClass) to a ClientData DTO.
|
|
*/
|
|
public function transform(array|object $row): ClientData
|
|
{
|
|
$row = (array) $row;
|
|
|
|
$fullname = trim(($row['firstname'] ?? '') . ' ' . ($row['lastname'] ?? ''));
|
|
if ($fullname === '') {
|
|
$fullname = $row['companyname'] ?: null;
|
|
}
|
|
|
|
$this->auditMissingInfo($row, $fullname);
|
|
|
|
return new ClientData(
|
|
uuid: $row['uuid'],
|
|
fullname: $fullname,
|
|
company: $row['companyname'] ?: null,
|
|
address: trim(($row['address1'] ?? '') . ', ' . ($row['address2'] ?? ''), ', ') ?: null,
|
|
state: $row['state'] ?: null,
|
|
city: $row['city'] ?: null,
|
|
// ponytail: WHMCS repurposes the `postcode` column to store the salesperson's fullname
|
|
saler: $this->resolveSalerId($row['postcode'] ?? null),
|
|
country: $row['country'] ?: null,
|
|
phone: PhoneNumber::normalize($row['phonenumber'] ?? null),
|
|
email: $row['email'] ? strtolower($row['email']) : null,
|
|
// ponytail: WHMCS hashes are not Laravel bcrypt, copied as-is; customer must reset password to log into portal
|
|
password: $row['password'] ?: null,
|
|
note: $row['notes'] ?: null,
|
|
credit: (int) round((float) $row['credit']),
|
|
status: $row['status'] === 'Active' ? 1 : 0,
|
|
emailMarketing: ((int) ($row['emailoptout'] ?? 0)) === 1 ? 0 : 1,
|
|
createdAt: $row['created_at'] ?: $row['datecreated'] ?: null,
|
|
updatedAt: $row['updated_at'] ?: $row['datecreated'] ?: null,
|
|
);
|
|
}
|
|
|
|
private function auditMissingInfo(array $row, ?string $fullname): void
|
|
{
|
|
$ref = (string) ($row['email'] ?: "#{$row['id']}");
|
|
$missing = [];
|
|
if (! $fullname) {
|
|
$missing[] = 'họ tên';
|
|
}
|
|
if (! PhoneNumber::normalize($row['phonenumber'] ?? null)) {
|
|
$missing[] = 'số điện thoại';
|
|
}
|
|
if (trim(($row['address1'] ?? '') . ($row['address2'] ?? '')) === '') {
|
|
$missing[] = 'địa chỉ';
|
|
}
|
|
if ($missing) {
|
|
$this->report->note('client', $ref, $row['id'], 'thieu_thong_tin', 'Thiếu: ' . implode(', ', $missing));
|
|
}
|
|
if (! filter_var($row['email'] ?? '', FILTER_VALIDATE_EMAIL) || preg_match('/@(gmail|yahoo|hotmail|outlook)\.com\.\w+$/i', (string) $row['email'])) {
|
|
$this->report->note('client', $ref, $row['id'], 'email_nghi_sai', "Email WHMCS có vẻ không hợp lệ: {$row['email']}");
|
|
}
|
|
if (! empty($row['postcode']) && $this->resolveSalerId($row['postcode']) === null) {
|
|
$this->report->note('client', $ref, $row['id'], 'khong_map_duoc_sale', "Không tìm thấy nhân viên sale tên \"{$row['postcode']}\" trong bảng user.");
|
|
}
|
|
}
|
|
|
|
private function resolveSalerId(?string $fullname): ?int
|
|
{
|
|
if (! $fullname) {
|
|
return null;
|
|
}
|
|
|
|
self::$salerIdsByName ??= DB::table('user')->get(['id', 'fullname'])->mapWithKeys(fn ($user) => [trim((string) $user->fullname) => $user->id])->all();
|
|
|
|
return self::$salerIdsByName[trim($fullname)] ?? null;
|
|
}
|
|
}
|