User

<?php

namespace Sts\CmsCommon\BO;
use Sts\PleafCore\DefaultBusinessFunction;
use Sts\PleafCore\BusinessFunction;
use Sts\PleafCore\QueryBuilder;
use Sts\PleafCore\CreateNativeQuery;
use Sts\CmsCommon\Helpers\ConditionExpression;
use Sts\CmsCommon\Model\user;



/**
 * @author Sulfano Agus Fikri, 30/08/2018
 * @in
 * - userId
 * - orderId
 * @out
 * orderDetail
 */

class GetUserListAdvance implements BusinessFunction {

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

    public function execute($dto){
        \log::debug('GetUserListAdvance');

        $dateTime = $dto["dateTime"];
        $userId   = $dto["userid"];
        $username = $dto["username"];
        $email    = $dto["email"];
        $fullname = $dto["fullname"];
        $cabang   = $dto["cabang"];
        $role     = $dto["role"];
        $active   = $dto["active"];


        $queryBuilder = new QueryBuilder();


        $queryBuilder
        ->add("SELECT")
        ->add("A.username, A.email, A.fullname, B.ou_name, C.role_name,")
        ->add("A.active, A.user_id, A.tenant_id, A.password, A.phone,")
        ->add("A.role_default_id, A.private_key, A.create_datetime, A.create_user_id, A.update_datetime,")
        ->add("A.update_user_id, A.version, A.active_datetime, A.non_active_datetime, A.ou_default_id,
            A.policy_default_id")
        ->add("FROM")->add(User::getTableName())->add(" A ")
        ->add("INNER JOIN")->add(User::getTableName())->add(" B ON A.ou_default_id = B.ou_id ")
        ->add("INNER JOIN")->add(User::getTableName())->add(" C ON A.role_default_id = C.role_id ")
        ->add("ORDER BY fullname, username ASC");


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

        return [
            "get_user_list_advance" => $result
        ];
    }
}