piratezon_new/backend/app/Controllers/Api/ServiceCenterController.php

<?php

namespace App\Controllers\Api;

use CodeIgniter\HTTP\ResponseInterface;

class ServiceCenterController extends BaseApiController
{
    /**
     * Get service center list
     */
    public function index()
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        $params = $this->getPaginationParams();
        $builder = $this->getDB()->table('service_centers sc');

        // Join with branches table to get branch name
        $builder->select('sc.*, b.name as branch_name');
        $builder->join('branches b', 'sc.branch_id = b.id', 'left');

        // Search
        $searchType = $this->request->getGet('search_type');
        $searchKeyword = $this->request->getGet('search_keyword');
        $isActive = $this->request->getGet('is_active');

        if ($searchType && $searchKeyword) {
            if ($searchType === 'name') {
                $builder->like('sc.name', $searchKeyword);
            } elseif ($searchType === 'address') {
                $builder->like('sc.address', $searchKeyword);
            } elseif ($searchType === 'phone') {
                $builder->like('sc.main_phone', $searchKeyword);
            }
        }

        // is_active 필터링
        if ($isActive !== null && $isActive !== '' && $isActive !== false) {
            $builder->where('sc.is_active', strval($isActive));
        }

        $builder->orderBy('sc.id', 'DESC');
        $result = $this->paginatedResponse($builder, $params);

        // Decode links JSON for each item
        foreach ($result['items'] as &$item) {
            if (!empty($item->links)) {
                $item->links = json_decode($item->links, true);
            } else {
                $item->links = [];
            }
        }

        return $this->respondSuccess($result);
    }

    /**
     * Get single service center
     */
    public function show($id = null)
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        $builder = $this->getDB()->table('service_centers sc');
        $builder->select('sc.*, b.name as branch_name');
        $builder->join('branches b', 'sc.branch_id = b.id', 'left');
        $builder->where('sc.id', $id);
        $serviceCenter = $builder->get()->getRow();

        if (!$serviceCenter) {
            return $this->respondError('서비스센터를 찾을 수 없습니다.', ResponseInterface::HTTP_NOT_FOUND);
        }

        // Decode links JSON
        if (!empty($serviceCenter->links)) {
            $serviceCenter->links = json_decode($serviceCenter->links, true);
        } else {
            $serviceCenter->links = [];
        }

        return $this->respondSuccess($serviceCenter);
    }

    /**
     * Create service center
     */
    public function create()
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        try {
            $json = $this->request->getJSON();

            // Validation
            if (empty($json->name)) {
                return $this->respondError('서비스센터명을 입력하세요.', ResponseInterface::HTTP_BAD_REQUEST);
            }

            if (empty($json->branch_id)) {
                return $this->respondError('소속 지점을 선택하세요.', ResponseInterface::HTTP_BAD_REQUEST);
            }

            if (empty($json->phone)) {
                return $this->respondError('대표번호를 입력하세요.', ResponseInterface::HTTP_BAD_REQUEST);
            }

            if (empty($json->address)) {
                return $this->respondError('주소를 입력하세요.', ResponseInterface::HTTP_BAD_REQUEST);
            }

            // Encode links to JSON
            $links = null;
            if (!empty($json->links) && is_array($json->links)) {
                $links = json_encode($json->links);
            }

            // 데이터 준비
            $data = [
                'name' => $json->name ?? '',
                'branch_id' => $json->branch_id ?? null,
                'main_phone' => $json->phone ?? '',
                'address' => $json->address ?? '',
                'detail_address' => $json->detail_address ?? '',
                'latitude' => $json->latitude ?? null,
                'longitude' => $json->longitude ?? null,
                'business_hours' => $json->business_hours ?? '',
                'service_reservation_link' => $json->service_reservation_link ?? '',
                'links' => $links,
                'created_at' => date('Y-m-d H:i:s')
            ];

            $builder = $this->getDB()->table('service_centers');
            $result = $builder->insert($data);

            if (!$result) {
                return $this->respondError('서비스센터 등록에 실패했습니다.', ResponseInterface::HTTP_INTERNAL_SERVER_ERROR);
            }

            return $this->respondSuccess(['id' => $this->getDB()->insertID()], '서비스센터가 등록되었습니다.');
        } catch (\Exception $e) {
            log_message('error', 'ServiceCenter create error: ' . $e->getMessage());
            return $this->respondError('서버 오류가 발생했습니다: ' . $e->getMessage(), ResponseInterface::HTTP_INTERNAL_SERVER_ERROR);
        }
    }

    /**
     * Update service center
     */
    public function update($id = null)
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        $json = $this->request->getJSON();

        // Encode links to JSON
        $links = null;
        if (!empty($json->links) && is_array($json->links)) {
            $links = json_encode($json->links);
        }

        // 데이터 준비
        $data = [
            'name' => $json->name ?? '',
            'branch_id' => $json->branch_id ?? null,
            'main_phone' => $json->phone ?? '',
            'address' => $json->address ?? '',
            'detail_address' => $json->detail_address ?? '',
            'latitude' => $json->latitude ?? null,
            'longitude' => $json->longitude ?? null,
            'business_hours' => $json->business_hours ?? '',
            'service_reservation_link' => $json->service_reservation_link ?? '',
            'links' => $links,
            'updated_at' => date('Y-m-d H:i:s')
        ];

        $builder = $this->getDB()->table('service_centers');
        $builder->where('id', $id)->update($data);

        return $this->respondSuccess(null, '서비스센터가 수정되었습니다.');
    }

    /**
     * Delete service center
     */
    public function delete($id = null)
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        $builder = $this->getDB()->table('service_centers');
        $builder->where('id', $id)->delete();

        return $this->respondSuccess(null, '서비스센터가 삭제되었습니다.');
    }

    /**
     * Toggle service center active status
     */
    public function toggleActive($id = null)
    {
        $auth = $this->requireAuth();
        if ($auth instanceof ResponseInterface) {
            return $auth;
        }

        $builder = $this->getDB()->table('service_centers');
        $serviceCenter = $builder->where('id', $id)->get()->getRow();

        if (!$serviceCenter) {
            return $this->respondError('서비스센터를 찾을 수 없습니다.', ResponseInterface::HTTP_NOT_FOUND);
        }

        // 현재 상태의 반대로 변경
        $newStatus = $serviceCenter->is_active == 1 ? 0 : 1;

        $builder->where('id', $id)->update([
            'is_active' => $newStatus,
            'updated_at' => date('Y-m-d H:i:s')
        ]);

        $statusText = $newStatus == 1 ? '사용' : '비사용';
        return $this->respondSuccess(['is_active' => $newStatus], "서비스센터가 {$statusText} 상태로 변경되었습니다.");
    }

    /**
     * Get public service center list (No authentication required)
     * 공개 API - 인증 없이 활성 서비스센터 목록 조회
     */
    public function publicList()
    {
        try {
            $builder = $this->getDB()->table('service_centers sc');
            $builder->select('sc.*, b.name as branch_name');
            $builder->join('branches b', 'sc.branch_id = b.id', 'left');

            // 활성화된 서비스센터만 조회
            $builder->where('sc.is_active', 1);
            $builder->orderBy('sc.id', 'DESC');

            $serviceCenters = $builder->get()->getResult();

            // Decode links JSON for each item
            foreach ($serviceCenters as &$serviceCenter) {
                if (!empty($serviceCenter->links)) {
                    $serviceCenter->links = json_decode($serviceCenter->links, true);
                } else {
                    $serviceCenter->links = [];
                }
            }

            return $this->respondSuccess($serviceCenters);
        } catch (\Exception $e) {
            log_message('error', 'ServiceCenter public list error: ' . $e->getMessage());
            return $this->respondError('서버 오류가 발생했습니다.', ResponseInterface::HTTP_INTERNAL_SERVER_ERROR);
        }
    }

    /**
     * Get public single service center (No authentication required)
     * 공개 API - 인증 없이 단일 서비스센터 정보 조회
     */
    public function publicShow($id = null)
    {
        try {
            $builder = $this->getDB()->table('service_centers sc');
            $builder->select('sc.*, b.name as branch_name');
            $builder->join('branches b', 'sc.branch_id = b.id', 'left');
            $builder->where('sc.id', $id);
            $builder->where('sc.is_active', 1);
            $serviceCenter = $builder->get()->getRow();

            if (!$serviceCenter) {
                return $this->respondError('서비스센터를 찾을 수 없습니다.', ResponseInterface::HTTP_NOT_FOUND);
            }

            // Decode links JSON
            if (!empty($serviceCenter->links)) {
                $serviceCenter->links = json_decode($serviceCenter->links, true);
            } else {
                $serviceCenter->links = [];
            }

            return $this->respondSuccess($serviceCenter);
        } catch (\Exception $e) {
            log_message('error', 'ServiceCenter public show error: ' . $e->getMessage());
            return $this->respondError('서버 오류가 발생했습니다.', ResponseInterface::HTTP_INTERNAL_SERVER_ERROR);
        }
    }
}