我想用custom fields在wordpress中创建一个表。看起来像这样:
+---------------------------------------------+
| company | | | |
| | field1 | field2 | Field3 |
| | | | |
+----+-----------+----------+----------+------+
| 56 | 5 | 55 | 58 |
+----+-----------+----------+-- -------+------+
| 888 | 6 | 88 | 55 |
+----+-----------+----------+-- -------+------+
| 558 | 88 | 2 | 150 |
+----+-----------+----------+----------+------+
我需要创建一个过滤器以加载以下职位列表:
"company" == 888
"field1" <= 100 &&
"field2" >= 20 &&
"field3" >= 40
例如,在这种情况下,具有此值的帖子(例如表格)将在此列表中提及。 表格中可以有无限数量或行。
如果tere只是一个具有一个值的字段,我会做类似的事情:
$args = array(
'numberposts' => -1,'post_type' => 'company','meta_query' => array(
array(
'key' => $key_name,'value' => 0,'compare' => '>'
)
)
);
我找不到这样查询表中数据的方法吗? 在那儿?非常感谢您的帮助。
编辑:
是我创建的服装领域。我做了一个中继器。 重要的事情:我需要找到在同一行(所有行)都满足所有条件的公司。
[
{
"key": "group_5dcbf625e861c","title": "Product search params (copy)","fields": [
{
"key": "field_5dcbf62629ce7","label": "product search by param active","name": "product_search_by_param_active","type": "true_false","instructions": "Please choose true to activate this option","required": 1,"conditional_logic": 0,"wrapper": {
"width": "","class": "","id": ""
},"message": "If not checked,search engine won't show this section on website","default_value": 0,"ui": 0,"ui_on_text": "","ui_off_text": ""
},{
"key": "field_5dcbf6262a106","label": "product params values","name": "product_params_values","type": "repeater","instructions": "","required": 0,"conditional_logic": [
[
{
"field": "field_5dcbf62629ce7","operator": "==","value": "1"
}
]
],"collapsed": "","min": 0,"max": 0,"layout": "table","button_label": "","sub_fields": [
{
"key": "field_5dcbf626543aa","label": "param value 1","name": "param_value_1","type": "text","wrapper": {
"width": "","id": ""
},"default_value": "","placeholder": "","prepend": "","append": "","maxlength": ""
},{
"key": "field_5dcbf6265478f","label": "param value 2","name": "param_value_2",{
"key": "field_5dcbf62654c14","label": "param value 3","name": "param_value_3",{
"key": "field_5dcbf62654fc1","label": "param value 4","name": "param_value_4",{
"key": "field_5dcbf62655398","label": "param value 5","name": "param_value_5","maxlength": ""
}
]
}
],"location": [
[
{
"param": "post_type","value": "product"
}
]
],"menu_order": 0,"position": "normal","style": "default","label_placement": "top","instruction_placement": "label","hide_on_screen": "","active": 1,"description": ""
}
]
编辑2:
还有另一种方式。创建表字段。这是字段:
{
"key": "field_5dcdf5a673fa7","label": "product search by param settings","name": "product_search_by_param_settings","type": "table","wrapper": {
"width": "","id": ""
},"use_header": 0,"use_caption": 2
}
这就是保存方式:
a:5:{s:5:"acftf";a:1:{s:1:"v";s:5:"1.3.9";}s:1:"p";a:2:{s:1:"o";a:1:{s:2:"uh";i:0;}s:2:"ca";s:0:"";}s:1:"c";a:5:{i:0;a:1:{s:1:"p";s:0:"";}i:1;a:1:{s:1:"p";s:0:"";}i:2;a:1:{s:1:"p";s:0:"";}i:3;a:1:{s:1:"p";s:0:"";}i:4;a:1:{s:1:"p";s:0:"";}}s:1:"h";a:5:{i:0;a:1:{s:1:"c";s:0:"";}i:1;a:1:{s:1:"c";s:0:"";}i:2;a:1:{s:1:"c";s:0:"";}i:3;a:1:{s:1:"c";s:0:"";}i:4;a:1:{s:1:"c";s:0:"";}}s:1:"b";a:5:{i:0;a:5:{i:0;a:1:{s:1:"c";s:4:"ffsd";}i:1;a:1:{s:1:"c";s:5:"hjkhk";}i:2;a:1:{s:1:"c";s:4:"hkjh";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:4:"fdjk";}}i:1;a:5:{i:0;a:1:{s:1:"c";s:6:"hkjhjk";}i:1;a:1:{s:1:"c";s:5:"hkjhk";}i:2;a:1:{s:1:"c";s:6:"hkjhkj";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:4:"hkhk";}}i:2;a:5:{i:0;a:1:{s:1:"c";s:6:"hkhkjh";}i:1;a:1:{s:1:"c";s:5:"hkjhk";}i:2;a:1:{s:1:"c";s:5:"hkjhk";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:5:"hkjhk";}}i:3;a:5:{i:0;a:1:{s:1:"c";s:5:"hkjhk";}i:1;a:1:{s:1:"c";s:6:"hkjhkj";}i:2;a:1:{s:1:"c";s:6:"hkjhkj";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:5:"hkkhk";}}i:4;a:5:{i:0;a:1:{s:1:"c";s:4:"hkhk";}i:1;a:1:{s:1:"c";s:2:"hk";}i:2;a:1:{s:1:"c";s:4:"hkhk";}i:3;a:1:{s:1:"c";s:4:"hkhk";}i:4;a:1:{s:1:"c";s:4:"hkhk";}}}}