GetOuListAdvance

<?php
/**
 * Created by PhpStorm.
 * User: sts-Ephraim Jehudah
 * Date: 19/06/19
 * Time: 9:29
 */

namespace Sts\CmsCommon\BO;


use Sts\PleafCommon\Model\OU;
use Sts\PleafCore\BusinessFunction;
use Sts\PleafCore\CreateNativeQuery;
use Sts\PleafCore\QueryBuilder;

class GetOuListAdvance implements BusinessFunction
{

    public function getDescription(){
        return "Get Ou List Advance";
    }

    public function execute($dto){

        $tenantId   =   $dto['tenantId'];
        $ouId       =   $dto["ouId"];
        $ouCode     =   $dto['ouCode'];
        $ouName     =   $dto['ouName'];
        $datetime   =   $dto['datetime'];

        $queryBuilder = new QueryBuilder();
        $queryBuilder
            ->add("SELECT")
            ->add(" A.ou_id, A.tenant_id, A.ou_code, A.ou_parent_id, A.ou_name, B.ou_type_name, A.ou_parent_id")
            ->add(", C.ou_code parent_ou_code, C.ou_name parent_ou_name")
            ->add(", A.ou_type_id, A.create_datetime, A.create_user_id, A.update_user_id, A.version")
            ->add(", A.active, A.active_datetime, A.non_active_datetime ")
            ->add("FROM ")->add(OU::getTableName())->add(" A ")
            ->add("INNER JOIN t_ou_type B ON A.ou_type_id = B.ou_type_id")
            ->add("LEFT JOIN ")->add(OU::getTableName())->add(" C ON A.ou_parent_id = C.ou_id")
            ->add("ORDER BY A.ou_code, A.ou_name, A.ou_parent_id ASC");

        $query = new CreateNativeQuery($queryBuilder->toString());
        $result =  $query->getResultList();

        return [ "ou_list" => $result ];

    }
}