- $query = "SELECT l.*, p.partnumber, p.description, c.name, c.street, " .
- "c.zipcode, c.city, c.country, c.contact, c.phone, c.fax, c.homepage, " .
- "c.email, c.notes, c.customernumber, c.language, a.invnumber " .
- "FROM license l " .
- "LEFT JOIN parts p ON (p.id = l.parts_id) " .
- "LEFT JOIN customer c ON (c.id = l.customer_id) " .
- "LEFT JOIN ar a ON " .
- "(a.id = (SELECT i.trans_id FROM invoice i WHERE i.id = " .
- "(SELECT li.trans_id FROM licenseinvoice li WHERE li.license_id = l.id))) " .
- "LEFT JOIN invoice i ON " .
- "(i.id = " .
- "(SELECT li.trans_id FROM licenseinvoice li WHERE li.license_id = l.id)) " .
- "WHERE l.id = " . $form->{"id"};
+ $query =
+ "SELECT l.*, p.partnumber, p.description, c.name, c.street, "
+ . "c.zipcode, c.city, c.country, c.contact, c.phone, c.fax, c.homepage, "
+ . "c.email, c.notes, c.customernumber, c.language, a.invnumber "
+ . "FROM license l "
+ . "LEFT JOIN parts p ON (p.id = l.parts_id) "
+ . "LEFT JOIN customer c ON (c.id = l.customer_id) "
+ . "LEFT JOIN ar a ON "
+ . "(a.id = (SELECT i.trans_id FROM invoice i WHERE i.id = "
+ . "(SELECT li.trans_id FROM licenseinvoice li WHERE li.license_id = l.id))) "
+ . "LEFT JOIN invoice i ON "
+ . "(i.id = "
+ . "(SELECT li.trans_id FROM licenseinvoice li WHERE li.license_id = l.id)) "
+ . "WHERE l.id = "
+ . $form->{"id"};