$output[] = '<tr>';
$output[] = '<td>' . $item->name . '</td>';
$output[] = '<td>' . $item->quantity . '</td>';
$output[] = '</tr>';
//Get item from store inventory ans save it in order summary
$dbitem = db_getItemByName($item->name);
$success = db_addOrderItem($dborder_id, $dbitem['id'], $item->quantity, $item->price);
//Insert order summary for this item
if (!$success) {
array_push($purchaseFailed, $dbitem);
}
}
$output[] = '</tbody>';
$output[] = '</table>';
//Send Email to customer
$buyer = refactored_db_getUserById($dborder_userid);
// Buyer Information: added by JAM - 06/18/2012
//$profile_fields = profile_user_record($dborder_userid); jh 7/13/2015 Note: need to look for a comparable function in efront.
$data = new object();
$data->userfullname = $buyer['name'] . " " . $buyer['surname'];
$data->firstname = $buyer['name'];
$data->lastname = $buyer['surname'];
$data->email = $buyer['email'];
$data->username = $buyer['login'];
$data->password = '';
//$buyer->password;
$data->gender = "n/a";
$data->skypeid = "n/a";
$data->kaseyasalesrep = "n/a";
$data->maintopic = "n/a";
$data->typebundle = "n/a";
//$currentUser -> getRole($this -> getCurrentLesson());
//echo "current user is: ".$currentUser;
//echo "root path is: " . G_ROOTPATH;
$orders = db_getOrders();
//echo "TESTING mysql_result";
//var_dump($orders); //jh this displays the array contents
//echo $orders=>['fields']=>['id'];
//$row = mysqli_fetch_array($orders, MYSQLI_NUM);
//$finfo = $orders->fetch_fields();
//echo $finfo;
//echo "END TESTING mysql_result";
//echo $orders
$formattedOrders = array();
// if (is_array($orders)) {
foreach ($orders as $row) {
$user = refactored_db_getUserById($row['userid']);
$purchaseDate = date(DATE_ATOM, $row['purchasedate'] / 1000);
/*
if($row['ordernumber']=='IA55a4429095d17') {
echo "user array for userid: " . $row['userid']." is ".PHP_EOL;
var_dump($user);
}
*/
$o = array($row['id'], $row['ordernumber'], $user['name'], $purchaseDate, $row['lastmodification'], $row['fulfillmentorderstate'], $row['financialorderstate'], $row['total']);
array_push($formattedOrders, $o);
}
// }
echo json_encode($formattedOrders);
// echo("{'id':'1,'ordernumber':'11','username':'******','purchasedDate':'1','lastmodification':'1','fulfillmentorderstate':'test','financialorderstate':'test','total':'1'}");
//Show details of every order which contain what items were purchased,
//quantities, and price
