Print multiple orders together at once

In this example we will see how to realize a print that allows to join multiple orders together using the document object.

Script Group	Event
Program	Action

table_rows = database.getsql("SELECT gguid FROM orders WHERE eli=0")

We begin to extrapolate what orders we are going to print. In this case we say that we will take them all. Obviously it is better to insert a filter system as per date or customer.

To make the prints, however, we will only need the gguid of each order

rows = table_rows.getrows()
print = nil
for i = 1,table_rows.countrows() do
        if print == nil then
               print = database.createdocument("gguidprint", "orders",rows[i].getvalue("gguid"))
        else
               print2 = database.createdocument("gguidprint", "orders",rows[i].getvalue("gguid"))
               print.adddocument(print2)
        end
end
if print != nil then
        print.show()
end

Let's start by turning all the rows in the table. We created an empty print object because we need to create a first document that collects all the others.

After setting the print object, all other orders will be appended to this.

At the end if at least one print is present we will proceed to show it.