static function add_order_enrols_vm2($order_id, $user_id)
{
$db = JFactory::getDBO();
$user = JFactory::getUser($user_id);
$username = $user->username;
$email = $user->email;
/* Update user profile in Moodle with VM data, if necessary */
JoomdleHelperContent::call_method('create_joomdle_user', $username);
$order_id = $db->Quote($order_id);
$query = 'SELECT *' . ' FROM #__virtuemart_order_items' . ' WHERE virtuemart_order_id =';
$query .= "{$order_id}";
$db->setQuery($query);
$items = $db->loadObjectList();
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->stderr());
}
/* No items in this order */
if (count($items) == 0) {
return;
}
$params = JComponentHelper::getParams('com_joomdle');
$buy_for_children = $params->get('buy_for_children');
$courses_category = $params->get('courses_category');
foreach ($items as $item) {
/* Only process product in Courses category */
$product_id = $item->virtuemart_product_id;
$order_item_id = $item->virtuemart_order_item_id;
$query = "SELECT virtuemart_category_id" . " FROM #__virtuemart_product_categories" . " WHERE virtuemart_product_id=" . $db->Quote($product_id);
$db->setQuery($query);
$cats = $db->loadAssocList();
$cats_array = array();
foreach ($cats as $cat) {
$cats_array[] = $cat['virtuemart_category_id'];
}
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->stderr());
}
/* If it is a course */
if (in_array($courses_category, $cats_array)) {
$sku = $item->order_item_sku;
if ($buy_for_children) {
if (strncmp($item->order_item_sku, 'bundle_', 7) == 0) {
//bundle
JoomdleHelperParents::purchase_bundle($username, $sku, $item->product_quantity);
} else {
JoomdleHelperParents::purchase_course($username, $sku, $item->product_quantity);
}
} else {
if (strncmp($item->order_item_sku, 'bundle_', 7) == 0) {
//bundle
JoomdleHelperShop::enrol_bundle($username, $sku);
} else {
//course
JoomdleHelperContent::enrolUser($username, $sku);
/* Send confirmation email */
JoomdleHelperShop::send_confirmation_email($email, $sku);
}
}
}
}
}
