public static function get_outprop_ids($broker_id, $city_id) { if (empty($broker_id) || empty($city_id)) { return array(); } $table = Dao_Broker_HzProp::b_broker_search_tb($city_id); $sql = "select proid,status from {$table} where userid=? and cityid=? and status in (2,6) and ispkg=10;"; $stmt = APF_DB_Factory::get_instance()->get_pdo('rent_slave')->prepare($sql); $stmt->execute(array($broker_id, $city_id)); $re = $stmt->fetchAll(); return $re; }