$total_count_S = $this->Community->list_count("DB2",$table_name,array('state' => '처리완료'), "","");

 function list_count($dbname, $table_name, $sql_where, $searchkey, $searchvalue) {
 
  $this->$dbname->select(' COUNT('.$this->$dbname->protect_identifiers('*').') as '.$this->$dbname->protect_identifiers('cnt'));

  if ($sql_where!="") 
   $this->$dbname->where($sql_where);  <-- 이부분
 
  if ($searchvalue != "" && $searchvalue != "NULL")
   $this->$dbname->like( $searchkey, $searchvalue);

  $qry = $this->$dbname->get($table_name);
  $row = $qry->row();

  $this->$dbname->flush_cache();
  //$this->$dbname->close(); 

  return $row->cnt;
 }

array('state' => '처리완료')