etraxis / etraxis-obsolete

                break;

            case COLUMN_TYPE_FLOAT:

                array_push($clause_select, "v{$column['column_id']}.value{$column['column_id']}");

                array_push($clause_join,

                           "left outer join " .

                           "(select r.record_id, flv.float_value as value{$column['column_id']} " .

                           "from tbl_records r, tbl_states s, tbl_fields f, tbl_events e, tbl_field_values fv " .

                           "left outer join tbl_float_values flv on fv.value_id = flv.value_id " .

                           "where r.record_id = e.record_id and s.state_id = f.state_id and s.state_name = '{$column['state_name']}' and f.field_id = fv.field_id and f.field_name = '{$column['field_name']}' and f.field_type = " . FIELD_TYPE_FLOAT . " and e.event_id = fv.event_id and fv.is_latest = 1 and ({$sql_field_perms})) v{$column['column_id']} " .

                           "on r.record_id = v{$column['column_id']}.record_id");

                if ($i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} asc");

                }

                elseif (-$i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} desc");

                }

                break;

            case COLUMN_TYPE_STRING:

                break;

            case COLUMN_TYPE_STRING:

                array_push($clause_select, "v{$column['column_id']}.value{$column['column_id']}");

                array_push($clause_join,

                           "left outer join " .

                           "(select r.record_id, sv.string_value as value{$column['column_id']} " .

                           "from tbl_records r, tbl_states s, tbl_fields f, tbl_events e, tbl_field_values fv " .

                           "left outer join tbl_string_values sv on fv.value_id = sv.value_id " .

                           "where r.record_id = e.record_id and s.state_id = f.state_id and s.state_name = '{$column['state_name']}' and f.field_id = fv.field_id and f.field_name = '{$column['field_name']}' and f.field_type = " . FIELD_TYPE_STRING . " and e.event_id = fv.event_id and fv.is_latest = 1 and ({$sql_field_perms})) v{$column['column_id']} " .

                           "on r.record_id = v{$column['column_id']}.record_id");

                if ($i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} asc");

                }

                elseif (-$i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} desc");

                }

                break;

            case COLUMN_TYPE_MULTILINED:

                break;

            case COLUMN_TYPE_LIST_STRING:

                array_push($clause_select, "v{$column['column_id']}.value{$column['column_id']}");

                array_push($clause_join,

                           "left outer join " .

                           "(select r.record_id, lv.str_value as value{$column['column_id']} " .

                           "from tbl_records r, tbl_states s, tbl_fields f, tbl_events e, tbl_field_values fv " .

                           "left outer join tbl_list_values lv on fv.field_id = lv.field_id and fv.value_id = lv.int_value " .

                           "where r.record_id = e.record_id and s.state_id = f.state_id and s.state_name = '{$column['state_name']}' and f.field_id = fv.field_id and f.field_name = '{$column['field_name']}' and f.field_type = " . FIELD_TYPE_LIST . " and e.event_id = fv.event_id and fv.is_latest = 1 and ({$sql_field_perms})) v{$column['column_id']} " .

                           "on r.record_id = v{$column['column_id']}.record_id");

                if ($i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} asc");

                }

                elseif (-$i == $sort)

                {

                    array_push($clause_order, "value{$column['column_id']} desc");

                }

                break;

            case COLUMN_TYPE_NUMBER:

            case COLUMN_TYPE_CHECKBOX: