[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
You aren't clear as to what you want. All you have is a bunch of queries there, without specifying the output. And I don't see what issue you are having with method chaining (you use it just fine on the second line).

Also, those are all relationships? You only call get() on relationships, not on fields. Are any of those get()s $has_many relationships? Or are they all $has_one? What is other()?

You cannot use $error as a field name (or relationship). That is a reserved word. $field might give you trouble as well.

For all of your $has_one, if you are only trying to get the information for output, and you are using DMZ (which I assume you are), trying merging the columns you want into one query:

Code:

// change the values in the array to be the fields you want.
$v->join_related('member', array('name', 'field2', ...));
// repeat for each $has_one you want to join in.
// access the above using:
$v->member_name;
$v->member_field2;

As far as outputting a json object, you do something like this:

Code:

$output = array();
foreach($v->all as $value) {
    $item = array();
    $item['field'] = $value->field;
    ....
    $output[] = $item;
}

echo json_encode($output);

Although there may be more to it.

As far as putting it in the controller or view: that's personal preference. I decided to put my code in the controller, since 99% of it is gathering fields. I consider the json_encode() to be my "view". You should also set your Content-Type header to application/json.

Code:

header('Content-Type: application/json');

For debugging purposes (via Firebug), there's a good bit of code on the PHP json_encode page that handles pretty-printing the output. I then usually set the type to text/plain on my development server, so I can easily read the output.