设计模式 - php中如何解决函数参数列表过长问题

query().from("user")
    .where(
      (user.firstName.like("Bob")).or(user.firstName.like("Ann")))
    .orderBy(user.firstName.asc())
    .list(user);

InsertSQL sql = new InsertSQL();
sql.insertInto("students")
   .value("id", new Integer(id))
   .value("name", name)
   .value("gender", gender);

/**
 * 配置路由规则
 */
RouteBuilder builder = new RouteBuilder() {
    public void configure() {
        from("/user").filter(header("language").isEqualTo("zh")).to("/zh/user");
        from("/user/edit/3").choice()
            .when(header("foo").isEqualTo("bar")).to("queue:d")
            .when(header("foo").isEqualTo("cheese")).to("queue:e")
            .otherwise().to("queue:f");
    }
};

//伪代码
class Sql {
  protected $fields, $table, $where;
  function __construct($table) {
    $this->table = $table; 
  }
  function select($fields){
    $this->fields = $fields;
    return $this;
  }
  function where($where) {
    $this->where = $where;
    return $this;
  }
  function __toString(){
    return "select {$this->fields} from {$this->table} where {$this->where}";
  }
  static function from($table) {
    return new self($table);
  }
}

//用法
echo Sql::from('table')->select('*')->where('1=1');
//输出： select * from table where 1=1;

<code>$rows = (new \yii\db\Query())
    ->select(['id', 'email'])
    ->from('user')
    ->where(['last_name' => 'Smith'])
    ->limit(10)
    ->all();
</code>

<code>function foo($params){
    $params = array_merge(array(
            'select' => 'default selector',
            'where' => 'default where',
            // ...
       ), $params);

    // do something with $params...

}
</code>