->select("b.username, a.table, a.board_table, a.comment_table, ".$u_field, false)

$sql = $builder->getCompiledSelect(false);

$query = $builder->get();

위에 처럼 하면 sql에 값이  b.username 에 넘어오지 않고

아래 처럼 하면 되는 것 같은데 ...

$sql = $builder->getCompiledSelect();

$query = $builder->get(null,0,false);

getCompiledSelect(bool $reset = true): string 에서 호출하는 

resetSelect() 에서 뭔가를 하는 것 닽은데 ...

고수님들 설명을 부탁 드립니다.

fromSubquery 두개 사용은 안되는 거 같습니다;;

정상적인 결과가 안 나오네요.

하나만 사용시에는 모든게 정상입니다.

fromSubquery 을 join 으로 바꾸니 제대로 됩니다

sql 에 기본적인 지식이 없다보니..

$sql = $builder->getCompiledSelect(); // 이줄을 첨가하지 않으면 에러 납니다.

$query = $builder->get(null,0,false);

if ($query->getNumRows() > 0) { $cnt = $query->getNumRows(); }


$builder->limit($per_page, ($page_index - 1) * $per_page);

$query = $builder->get();

return $query->getResult();

    public function all_search_paginated_active($search_table, $search_field, $field_or, $text_or, $search_text, $page_index=1, $per_page=10, &$cnt=0) 
    {                   
        $union = $this->all_search_paginated_union($search_table, $search_field, $field_or, $text_or, $search_text); 

        $user_subquery = 
		        $this->db
                     ->table("users");
					
        $u_field = " `a`.`id`, `a`.`user_id`, `a`.`user_name`, `a`.`category_name`, `a`.`subject`, `a`.`reply_count`, `a`.`reg_date`, `a`.`modify_date`, `a`.`contents`, `a`.`tag`";

        $builder = $this->db
		                ->newQuery()
                        ->select("users.username, a.table, a.board_table, a.comment_table, ".$u_field, false)
                        ->fromSubquery($union, "a");
                        //->fromSubquery($user_subquery, "b")
                        ->join("users", "users.id = a.user_id");
                        //->orderBy("reg_date", "desc");
        
		//$sql = $builder->getCompiledSelect(false);
		//$sql = $builder->getCompiledSelect();

        //$query = $builder->get();
        $query = $builder->get(null,0,false);

        if ($query->getNumRows() > 0) {
            $cnt = $query->getNumRows();
        }

		//echo $sql;
        echo $this->db->GetLastQuery();
		echo '<br>';
		echo $cnt;
		echo '<br>';
		echo '<br>';

        //$builder = $this->db
		//                ->newQuery()
        //                ->select("b.username, a.table, a.board_table, a.comment_table, ".$u_field, false)
        //                ->fromSubquery($union, "a")
        //                ->fromSubquery($user_subquery, "b")
        //                ->where("a.user_id", "b.id")
        //                ->orderBy("reg_date", "desc")
		//    			//->limit($per_page, ($page_index - 1) * $per_page)
		//				;
		//$sql = $builder->getCompiledSelect();

        $builder->orderBy("modify_date", "desc");
        $builder->limit($per_page, ($page_index - 1) * $per_page);
		$query = $builder->get();
        //$query = $builder->get($per_page, ($page_index - 1) * $per_page);

		//echo $sql;
        echo $this->db->GetLastQuery();
		echo '<br>';
		echo '<br>';
        
        return $query->getResult();
    }

    public function all_search_paginated_union($search_table, $search_field, $field_or, $text_or, $search_text) 
    {
        $s_field = " `id`, `user_id`, `user_name`, `category_name`, `subject`, `reply_count`, `reg_date`, `modify_date`, `contents`, `tag` ";

        $union = 0;
        if (is_array($search_table)) {
            foreach($search_table as $table) {
                $builder = 
				    $this->db
                         ->table($table)
                         ->select("'".$table."' as `table`, '".$table."' as `board_table`, '".$table."_comment' as `comment_table`, ".$s_field, false);
                    
				$builder = $this->search_orlike($builder, $search_table, $search_field, $field_or, $text_or, $search_text); 
                    
				$builder->orderBy('id', 'DESC');

                if ($union) {
                    $union = $union->union($builder);
    			}	
				else {
                    $union = $builder;
                }
            }
		}		
        else {
            $builder = 
		        $this->db
                     ->table($table)
                     ->select("'".$search_table."' as `table`, '".$search_table."' as `board_table`, '".$search_table."_comment' as `comment_table`, ".$s_field, false);
                   
			$builder = $this->search_orlike($builder, $search_table, $search_field, $field_or, $text_or, $search_text); 
                    
			$builder->orderBy('id', 'DESC');

            $union = $builder;
        }           
		
		return $union;
	}					

    public function search_orlike($builder, $search_table, $search_field, $field_or, $text_or, $search_text) 
    {
        $f = "";
        $t = "";

        if (is_array($search_field)) {
            if (is_array($search_text)) {
                foreach($search_field as $field) {
                    if ($field_or == "or") {
                        $builder->orGroupStart();
                    }
                    else {
                        $builder->GroupStart();
                    }
                    foreach($search_text as $text) {
                        if ($text_or =='or') {
                          $builder->orLike($field, $text);
                        }
                        else {
                          $builder->Like($field, $text);
                        }   
                    }   
                    $builder->GroupEnd();
                }
            } else {
                foreach($search_field as $field) {
                    if ($field_or == "or") {
                        $builder->orGroupStart();
                    }
                    else {
                        $builder->GroupStart();
                    }
                    if ($field_or =='or') {
                      $builder->orLike($field, $search_text);
                    }
                    else {
                      $builder->Like($field, $search_text);
                    }   
                    $builder->GroupEnd();
                }
            }
        } else {
            if (is_array($search_text)) {
                $builder->GroupStart();
                foreach($search_text as $text) {
                    if ($text_or =='or') {
                      $builder->orLike($search_field, $text);
                    }
                    else {
                      $builder->Like($search_field, $text);
                    }   
                }
                $builder->GroupEnd();
            } else {
                if ($text_or =='or') {
                  $builder->orLike($search_field, $search_text);
                }
                else {
                  $builder->Like($search_field, $search_text);
                }   
            }
        }   
        
        return $builder;        
    }   

    public function getCompiledSelect(bool $reset = true): string
    {
        $select = $this->compileSelect();

        if ($reset === true) {
            $this->resetSelect();
        }

        return $this->compileFinalQuery($select);
    }

    protected function resetSelect()
    {
        $this->resetRun([
            'QBSelect'   => [],
            'QBJoin'     => [],
            'QBWhere'    => [],
            'QBGroupBy'  => [],
            'QBHaving'   => [],
            'QBOrderBy'  => [],
            'QBNoEscape' => [],
            'QBDistinct' => false,
            'QBLimit'    => false,
            'QBOffset'   => false,
            'QBUnion'    => [],
        ]);

        if (! empty($this->db)) {
            $this->db->setAliasedTables([]);
        }

        // Reset QBFrom part
        if (! empty($this->QBFrom)) {
            $this->from(array_shift($this->QBFrom), true);
        }
    }
    public function from($from, bool $overwrite = false): self
    {
        if ($overwrite === true) {
            $this->QBFrom = [];
            $this->db->setAliasedTables([]);
        }

        foreach ((array) $from as $table) {
            if (strpos($table, ',') !== false) {
                $this->from(explode(',', $table));
            } else {
                $table = trim($table);

                if ($table === '') {
                    continue;
                }

                $this->trackAliases($table);
                $this->QBFrom[] = $this->db->protectIdentifiers($table, true, null, false);
            }
        }

        return $this;
    }