function db_getCourseById($courseId)
{
try {
$course = db_getrecord("SELECT c.id, c.shortname FROM mdl_course c WHERE id = " . $courseId);
return $course;
} catch (Exception $e) {
echo $e->getMessage();
return null;
}
}
$neworder->financialorderstate = $financialstate;
$neworder->fulfillmentorderstate = $fulfillmentstate;
db_addGoogleCheckoutOrder($neworder->email, $neworder->ordernumber, $neworder->purchasedate, $neworder->fulfillmentorderstate, $neworder->financialorderstate);
$dborder = db_getOrderByOrderNumber($neworder->ordernumber);
$total = 0;
//Get shopping cart information
$items = get_arr_result($data[$root]['shopping-cart']['items']['item']);
foreach ($items as $item) {
$itemname = $item['item-name']['VALUE'];
$itemdescription = $item['item-description']['VALUE'];
$currency = $item['unit-price']['currency'];
$unitprice = $item['unit-price']['VALUE'];
$quantity = $item['quantity']['VALUE'];
//Get item from store inventory
$sql_getitem = 'SELECT * from mdl_shoppingcart_store_inventory WHERE name = "' . $itemname . '" and description = "' . $itemdescription . '"';
$dbitem = db_getrecord($sql_getitem);
//Insert order summary for this item
db_addOrderItem($dborder->id, $dbitem->id, $quantity, $unitprice);
$total += $quantity * $unitprice;
}
db_modifyOrderTotal($dborder->id, $total);
$user = db_getUserByEmail($email);
$Gresponse->SendAck();
//$data[$root]['serial-number']
break;
case "authorization-amount-notification":
break;
case "order-state-change-notification":
$new_financial_state = $data[$root]['new-financial-order-state']['VALUE'];
$new_fulfillment_order = $data[$root]['new-fulfillment-order-state']['VALUE'];
$ordernumber = $data[$root]['google-order-number']['VALUE'];
} else {
$result = array('success' => false, 'message' => "Error executing database operation");
}
} else {
$result = array('success' => false, 'message' => 'Package item cannot be deleted since package is being reference in existing orders');
}
echo json_encode($result);
} else {
if ($action == "isPkgBillable") {
if (isset($_POST['packageid'])) {
$packageid = $_POST['packageid'];
} else {
$packageid = 0;
}
$sql = "SELECT billable FROM mdl_shoppingcart_store_inventory WHERE id = " . $packageid;
$result = db_getrecord($sql);
echo json_encode($result->billable == "1");
} else {
if ($action == "changeStatus") {
if (isset($_POST['packageid'])) {
$packageid = $_POST['packageid'];
} else {
$packageid = 0;
}
$success = db_changePackageStatus($packageid);
$response = array('success' => $success);
echo json_encode($response);
}
}
}
}
