public function site_field_sets($orderby = "position ASC") {
global $wf;
$args = array($orderby);
if (is_null($ret = $this->property_cache_args("site_field_sets", $args ))) {
$this->field_types = array();
global $wpdb;
$field_sets_table = MPM::table("field-sets");
$fields_table = MPM::table("fields");
$select_list = $this->assigned_select_list();
$sql = "
SELECT
$select_list
FROM $field_sets_table s
INNER JOIN $fields_table f ON s.id = f.`field_set_id`
WHERE (s.type = 'w')
AND f.disabled = 0 AND s.disabled = 0
ORDER BY set_type, set_position, field_position;
";
$field_sets = array();
$fields_by_set = array();
$results = $wpdb->get_results($sql);
foreach ($results as $result) {
$set_name = $result->set_name;
$set_type = $result->set_type;
$use_set = true;
$use_field = true;
if ($use_set) {
$field_sets[$set_name] = $this->set_data_from_result($result);
}
// now record the field too
if ($use_field) {
if (!in_array($result->field_type, $this->field_types)) {
$this->field_types[] = $result->field_type;
}
$fields_by_set[$set_name][$result->field_name] = $this->field_data_from_result($result);
}
} // endforeach
$field_set_models = array();
foreach ($field_sets as $field_set) {
$field_set_model = new MPM_SiteFieldSet();
$field_set_model->set_from_row($field_set);
$field_models = array();
$fields = $fields_by_set[$field_set["name"]];
if (is_array($fields) && count($fields)) {
foreach ($fields as $field) {
$field_model = new MPM_Field();
$field_model->set_from_row($field);
if ($field_model->in_current_site()) {
$field_models[$field["name"]] = $field_model;
}
}
$field_set_model->set_fields($field_models);
}
if ($field_set_model->in_current_site()) {
$field_set_models[$field_set_model->name] = $field_set_model;
}
}
$ret = $this->property_cache_args("site_field_sets", $args, $field_set_models );
}
return $ret;
}
