所以我们有各种各样的搜索页面,每个页面都有不同的搜索条件,所以我决定编写一个组件,它将从控制器获取传递给它的参数,收集必要的数据并返回一个数组,然后我可以将其设置为在我的视图文件中使用,以填充下拉框以过滤条件。
我已经设法将所有内容都写到我必须使用 cakePHP 助手来构建动态选择框的地方。我确信我做错了什么,如果有更简单的方法可以做到这一点并且仍然保持一定的动态性,请在可能的情况下提供帮助:
// COMPONENT METHOD:
public function filterQueries($parameters) {
// Get defaults from the user:
$criteria = $parameters["custom"];
$defaults = $parameters["defaults"];
// Validate the defaults the user may want and assign them to the return array:
if($defaults != "false") {
foreach($defaults as $key => $value) {
if(array_key_exists($value, $this->defaults)) {
$this->returnArray["defaults"][$value] = $this->defaults[$value];
}
}
}
// Get all data for the custom requested form fields:
if($criteria != false) {
foreach($criteria as $model => $arguments) {
$fields = $arguments["fields"];
$conditions = $arguments["conditions"];
$recursive = $arguments["recursive"];
if(!in_array($model,$this->uses)) {
$useModel = ClassRegistry::init($model);
} else {
$useModel = $this->$$model;
}
$array = $useModel->find("all",array("conditions" => $conditions, "fields" => $fields, "recursive" => $recursive));
$this->returnArray["custom"][$model] = $array;
}
}
return $this->returnArray;
}
上面的函数将获得一个分解自定义搜索或默认值的数组(上面未包含,但它都可以正常工作,它完全按照我的预期返回数组。
// The code within my action to get the content from above:
// Load the Filters component to search data:
$search = $this->Components->load("Filter");
// Tell search what you want:
$searchBoxes = array(
"defaults" => array("statuses", "survey_type"),
"custom" => array(
"User" => array(
"fields" => array("User.id","User.first_name", "User.last_name"),
"conditions" => array("User.user_group_id" => "4f847c63-1840-446e-88be-3e4d29566cf0"),
"recursive" => -1
)
)
);
$filterResults = $search->filterQueries($searchBoxes);
$this->set("filters",$filterResults);
所以现在我在我的视图文件中得到了这个多关联数组(一切仍然很好),但我现在想根据上面创建的数组构建一个用户下拉列表的示例,但结果与我预期的完全不同:
echo $this->Form->input('user_id',
array(
"type" => "select",
"options" => $filters["custom"]["User"]
)
);
HTML 输出已损坏,并按如下所示显示:
<option value="last_name">Doe</option>
<option value="first_name">Jihn</option>
<optgroup label="User"> </optgroup>
<optgroup label="1"> </optgroup>
<option value="last_name">Marilyn</option>
<option value="first_name">Monroe</option>
我承认我没有很多蛋糕经验,但不明白如何获得结果:
<option value='USERID'>NAME</option> // Yes I know the names and surnames must be concatinated still
任何关于如何做到这一点的建议帮助或指导,并以正确的方式做,将不胜感激:)
VARDUMP on $filters['custom']['users']
array
0 =>
array
'User' =>
array
'id' => string '4f84840e-cda8-4704-8fdf-210729566cf0' (length=36)
'first_name' => string 'Name' (length=4)
'last_name' => string 'Surname' (length=11)
1 =>
array
'User' =>
array
'id' => string '4f8488cb-53e0-4f72-af73-3de229566cf0' (length=36)
'first_name' => string 'Name' (length=6)
'last_name' => string 'Surname' (length=6)
您可以通过执行以下操作来增强输出:
1)为了组合表的两个字段,可以在模型中使用"virtualfields"
,如下所示: 例如,如果您有用户模型,则可以定义如下:
public $virtualFields = array(
'full_name' => 'CONCAT(first_name, " ",last_name)'
);
因此,现在,每当调用用户模型的find
方法时,都会获得"full_name"字段。
2)要从表中获取选择框的数据,可以使用find('list')
方法。例如,对于用户模型,如果您需要表的id,full_name (last and first name combined using the virtual fields)
,可以按如下方式完成:
$this->User->find('list',array('fields'=>array('id','full_name'),'conditions'=>$conditions))
我希望这有帮助..
我想您实际上要做的是使用格式化选项创建另一个数组。
foreach ($filters["custom"]["User"] as $arr)
{
$options[$arr['id']] = $arr['first_name'] . ' ' . $arr['last_name'];
}
然后
echo $this->Form->select('user_id', $options);
我认为你需要这样的东西:
$result = Set::combine($filters["custom"]["User"],
'{n}.User.id', // this is the value of select box
array(
'{0} {1}',
'{n}.User.first_name',
'{n}.User.last_name'
) // this is the text of select box
);
pr($result);
$this->form->input('inputname', array
在 cakePHP 3 上,我还不能使用"virtualFields",但我可以使用如下方式:
//In PostsController
$users = $this->Posts->Users->find('list',
['keyField' => 'id',
'valueField' => 'full_name', //Don't forget to call concatened field here
'conditions' => $conditions,
'order' => $orderBy
]);
//here the magic happens
$concat = $users->func()->concat(
['Users.first_name' => 'identifier',
' ',
'Users.last_name' => 'identifier'
]);
//selecting fields
$users->select(['id', 'full_name' => $concat]);
//sending to view
$this->set('users', $users->toArray());
我希望这对 CakePHP 3 开发人员有所帮助