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); } } } }