[RESOLVED] Building a Dynamic Array

[jsjohnstone]

Hi all,

I'm currently using a class that integrates with our accounting system and trying to build invoices from our online payment gateway.

As part of the invoice, I'd obviously like to be able to have a list of all the 'products' being sold which need to be added line-by-line to the invoice - however, I'm having some difficulty building the array that is submitted to our accounting API to achieve this.

The code to build an invoice with two line items would be:

$new_invoice = array(
array(
	"Type"=>"ACCREC",
	"Contact" => array(
		"ContactID" => $customer['id']
	),
	"Date" => date("Y-m-d"),
	"DueDate" => date("Y-m-d"),
	"Status" => "SUBMITTED",
	"LineAmountTypes" => "Inclusive",
	"LineItems"=> array(
		"LineItem" => array(
			array(
				"Description" => "Item 1",
				"Quantity" => "1.0000",
				"UnitAmount" => "Amount 1",
				"AccountCode" => "210",
				"Tracking" => array(
					"TrackingCategory" => array (
						"Name" => "Show",
						"Option" => "Tracking ID 1"
					 )
				) 
			)
			array(
				"Description" => "Item 2",
				"Quantity" => "1.0000",
				"UnitAmount" => "Amount 2",
				"AccountCode" => "210",
				"Tracking" => array(
					"TrackingCategory" => array (
						"Name" => "Show",
						"Option" => "Tracking ID 2"
					 )
				) 
			)
		)
	)
)
);

Now the key part here is obviously the LineItems array - which has an array in it called "LineItem" which then has a various number of 'sub-arrays' for each line item.

What I'm basically trying to achieve would be something similar to:

	"LineItems"=> array(
		"LineItem" => array(
			do {
				array(
					"Description" => "Item 1",
					"Quantity" => "1.0000",
					"UnitAmount" => "Amount 1",
					"AccountCode" => "210",
					"Tracking" => array(
						"TrackingCategory" => array (
							"Name" => "Show",
							"Option" => "Tracking ID 1"
						 )
					) 
				)
			} while($row_lineitem = mysql_fetch_row($lineitem));
		))

But this produces a PHP error when it encounters the WHILE statement. Any ideas how to produce something similar while avoiding this error?

Would appreciate the help! Thanks guys!

Cheers,

Jamie

[dagon]

create your line items array after(or before) the main array and add them together.

[jsjohnstone]

Hi Dagon,

Thanks for your quick response - makes perfect sense!

The only question I'd have regarding it is how to add the arrays in a loop because the "Sub-Array" within the "LineItems > LineItem" arrays doesn't have a key of any kind.

Can you build arrays by "adding on" the array with .= like so?

 
do { 
             $array .=   array( 
                    "Description" => "Item 1", 
                    "Quantity" => "1.0000", 
                    "UnitAmount" => "Amount 1", 
                    "AccountCode" => "210", 
                    "Tracking" => array( 
                        "TrackingCategory" => array ( 
                            "Name" => "Show", 
                            "Option" => "Tracking ID 1" 
                         ) 
                    ) 
                ) 
            } while($row_lineitem = mysql_fetch_row($lineitem)); 
 

Cheers,

Jamie.

[dagon]

are products in the same table as invoices or are they a septate table, what's the data that is coming from the db look like

at a guess

inside row loop
you want to build part one of array.
then for each product add LineItem's then move on to next invoice.

so you need to store (temporarily in the loop) what every field you are using to match the line items, so you know when it changes.

[jsjohnstone]

Hey Dagon!

Thanks again for your help - it came together perfectly! For anyone who is interested, here is how I put the code together:

do {
		/// First off, we loop through all the "Line Items" using a MySQL query and do{}while() loop.
		/// During this, we build the variables for each entry in our invoice.
		$linedescription = "[".$adjustments['type']."] ".$adjustments['comment'];
		$lineamount = $adjustments['amount'];
		/// Finally, we use our array, $lineitems, and add to this using empty square brackets ("[]") - 
		$lineitems[] = array(
							 "Description" => $linedescription,
							 "Quantity" => "1.000",
							 "UnitAmount" => $lineamount,
							 "AccountCode" => "260",
							 "Tracking" => array(
								"TrackingCategory" => array (
									"Name" => "Show",
									"Option" => $event['xeroid']
								)
							) 
						);

} while ($adjustments = mysql_fetch_assoc($adj));

/// OK - onto building the invoice array!
$new_invoice = array(
array(
	"Type"=>"ACCREC",
	"Contact" => array(
		"ContactID" => $customer['id']
	),
	"Date" => date("Y-m-d"),
	"DueDate" => date("Y-m-d"),
	"Status" => "SUBMITTED",
	"LineAmountTypes" => "Inclusive",
	"LineItems"=> array(
	/// We refer to the array we built earlier, $lineitems, and just stick it in here where the arrays are normally built!
		"LineItem" => $lineitems
	)
));

$invoice_result = $xero->Invoices( $new_invoice );

Again - cheers for your help!

Jamie.