<?php

include_once 'BBOrm/Connections.php';
include_once 'BBOrm/DBInstance.php';
include_once 'BBOrm/Entity.php';

class Pais extends Entity{
    
    const table_name = 'basico_geografico_paises';
    
}

class Estado extends Entity {

    const table_name = 'basico_geografico_estados';
    
    function municipios() {
        return $this->has_many(Municipio::class, 'estado_id');
    }

}

class Municipio extends Entity {

    const table_name = 'basico_geografico_municipios';
    
    function estado() {
        return $this->belongs_to(Estado::class, 'estado_id');
    }

}

class User extends Entity {

    const timestamps = true;
    const softdelete = true;
    const table_name = 'basico_auth_users';
    
    public function existencia() {
        $this->has_one(Existencia::class, 'user_id');
    }

    public function contatos() {
        $this->has_many('contatos', 'user_id');
    }

    public function permissions() {
        return $this->belongs_to_many_extended(Permission::class, 'basico_auth_permission_user', 'user_id', 'permission_id');
    }

    public function roles() {
        return $this->belongs_to_many( Role::class, 'basico_auth_role_user', 'user_id', 'role_id');
    }

}

class Role extends Entity{
    
    const table_name = "basico_auth_roles";
    
    function permissions(){
        return $this->belongs_to_many(Permission::class, 'basico_auth_role_permission', 'role_id',  'permission_id');
    }
}

class Permission extends Entity{
    
    const table_name = "basico_auth_permissions";
    
}

Connections::add_connection(new PDO("pgsql:dbname=urfat; user=urfat; password=urfat;host=127.0.0.1;port=5432"));

//$a = new Pais();
//$b = $a->count( Array('id' => Array('in', Array(10, 20, 30)) ));
//$b = $a->find_many( Array('id' => Array('in', Array(10, 20, 30)) ) );
//$b = $a->teste();
//var_dump( Pais::find_all() );
//var_dump( Pais::find_one( Array('id'=> Array('=', 60) ), Array('id') ) );
//var_dump( Pais::find_many( Array('id'=> Array('<', 10) ) ) );

//$a = new User();
//$a->load(1);
//$a = User::find_one(Array('id'=>Array('=', 1) ));
$a = User::find_one( 1 );

var_dump( $a->roles() );

//$a = new Estado();
//$a->load(23);

//foreach ($a->municipios() as $municipio) {
//    echo "$municipio->nome \n";
//}

//$a = new Municipio();
//$a->load(1);
//$a->estado();