<?php

namespace Telemedicina\Http\Controllers;

use Illuminate\Http\Request;
use Telemedicina\Structure;
use DB;
use SoapBox\Formatter\Formatter;
use SimpleXMLElement;

class StructureController extends Controller
{
    public function getStructureBySpecialty(Request $request){
        $id = $request->id;
        
        // Buscar equivalencia tabla.
        $obj = Structure::where('specialty', $id)->first();
        
        if($obj){
            // Enviar estructura
            $obj = DB::select("SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = ?", [$obj->table]);
            $formatter = Formatter::make(json_encode($obj), Formatter::JSON);
            
            return response($formatter->toXML())
            ->header('Content-Type', 'text/xml');
        }
    }
    
    public function getStructureByName(Request $request){
        // Enviar estructura
        $obj = DB::select("SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = ?", [$request->name]);
        $formatter = Formatter::make(json_encode($obj), Formatter::JSON);
        
        return response($formatter->toXML())
        ->header('Content-Type', 'text/xml');
        
    }
}