function newroom()
{
require_once _base_ . '/lib/lib.form.php';
require_once $GLOBALS['where_scs'] . '/lib/lib.room.php';
$lang =& DoceboLanguage::createInstance('admin_config', 'scs');
$out =& $GLOBALS['page'];
$rules = getAdminRules();
$out->setWorkingZone('content');
$out->add(getTitleArea($lang->def('_ROOM_MAN'), 'admin_conf') . '<div class="std_block">');
$room_types = array("course" => $lang->def('_COURSE'), "private" => $lang->def('_PRIVATE'), "public" => $lang->def('_PUBLIC'));
$out->add(Form::openForm('rules_admin', 'index.php?modname=room&op=insroom') . Form::openElementSpace() . Form::getTextfield($lang->def('_ROOM_NAME'), 'rules_room_name', 'rules[room_name]', 255) . Form::getDropdown($lang->def('_ROOM_TYPE'), 'rules_room_type', 'rules[room_type]', $room_types));
while (list($var_name, $var_value) = each($rules)) {
$out->add(maskMultiple($var_name, $var_value));
}
$out->add(Form::closeElementSpace() . Form::openButtonSpace() . Form::getButton('save', 'save', $lang->def('_SAVE')) . Form::getButton('undo', 'undo', $lang->def('_UNDO')) . Form::closeButtonSpace() . Form::closeForm());
$out->add('</div>');
}
function add_row($row, $pk)
{
$id_course = false;
if ($row['code'] == '') {
$row['code'] = $this->default_cols['code'];
}
if ($row['name'] == '') {
$row['name'] = $this->default_cols['name'];
}
if ($row['description'] == '') {
$row['description'] = $this->default_cols['description'];
}
if ($row['lang_code'] == '') {
$row['lang_code'] = $this->default_cols['lang_code'];
}
if ($row['status'] == '') {
$row['status'] = $this->default_cols['status'];
}
if ($row['subscribe_method'] == '') {
$row['subscribe_method'] = $this->default_cols['subscribe_method'];
}
if ($row['permCloseLO'] == '') {
$row['permCloseLO'] = $this->default_cols['permCloseLO'];
}
if ($row['difficult'] == '') {
$row['difficult'] = $this->default_cols['difficult'];
}
if ($row['show_progress'] == '') {
$row['show_progress'] = $this->default_cols['show_progress'];
}
if ($row['show_time'] == '') {
$row['show_time'] = $this->default_cols['show_time'];
}
if ($row['show_extra_info'] == '') {
$row['show_extra_info'] = $this->default_cols['show_extra_info'];
}
if ($row['show_rules'] == '') {
$row['show_rules'] = $this->default_cols['show_rules'];
}
if ($row['date_begin'] == '') {
$row['date_begin'] = $this->default_cols['date_begin'];
}
if ($row['date_end'] == '') {
$row['date_end'] = $this->default_cols['date_end'];
}
if ($row['valid_time'] == '') {
$row['valid_time'] = $this->default_cols['valid_time'];
}
if ($row['max_num_subscribe'] == '') {
$row['max_num_subscribe'] = $this->default_cols['max_num_subscribe'];
}
if ($row['prize'] == '') {
$row['prize'] = $this->default_cols['prize'];
}
if ($row['selling'] == '') {
$row['selling'] = $this->default_cols['selling'];
}
// check if the course identified by the pk alredy exits
$id_course = $this->get_row_by_pk($pk);
if ($id_course === false) {
$this->last_error = 'Error in search query : ( ' . mysql_error() . ' )';
return false;
}
if ($id_course === 'jump') {
return true;
}
$is_add = false;
if ($id_course === 0) {
$is_add = true;
// course is to add
$query_course = "\r\n\t\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_course \r\n\t\t\tSET idCategory = '0', \r\n\t\t\t\tcode = '" . addslashes($row['code']) . "', \r\n\t\t\t\tname = '" . addslashes($row['name']) . "', \r\n\t\t\t\tdescription = '" . $row['description'] . "', \r\n\t\t\t\tlang_code = '" . $row['lang_code'] . "', \r\n\t\t\t\tstatus = '" . $row['status'] . "', \r\n\t\t\t\tsubscribe_method = '" . $row['subscribe_method'] . "',\r\n\t\t\t\tpermCloseLO = '" . $row['permCloseLO'] . "', \r\n\t\t\t\tdifficult = '" . $row['difficult'] . "', \r\n\t\t\t\tshow_progress = '" . $row['show_progress'] . "', \r\n\t\t\t\tshow_time = '" . $row['show_time'] . "', \r\n\t\t\t\tshow_extra_info = '" . $row['show_extra_info'] . "', \r\n\t\t\t\tshow_rules = '" . $row['show_rules'] . "', \r\n\t\t\t\tdate_begin = '" . $row['date_begin'] . "', \r\n\t\t\t\tdate_end = '" . $row['date_end'] . "', \r\n\t\t\t\tvalid_time = '" . $row['valid_time'] . "',\r\n\t\t\t\tmax_num_subscribe = '" . $row['max_num_subscribe'] . "', \r\n\t\t\t\tprize = '" . $row['prize'] . "',\r\n\t\t\t\tselling = '" . $row['selling'] . "',\r\n\t\t\t\timported_from_connection = '" . $this->get_name() . "'";
if (!sql_query($query_course)) {
$this->last_error = 'Error in insert query : ( ' . mysql_error() . ' )' . '<!-- ' . $query_course . ' -->';
return false;
}
$id_course = mysql_insert_id();
// import the menu
if (Docebo::user()->getUserLevelId() != ADMIN_GROUP_GODADMIN) {
$re &= sql_query("\r\n\t\t\t\tINSERT INTO " . $GLOBALS['prefix_fw'] . "_admin_course \r\n\t\t\t\t( id_entry, type_of_entry, idst_user ) VALUES \r\n\t\t\t\t( '" . $id_course . "', 'course', '" . getLogUserId() . "') ");
}
//if the scs exist create a room
if ($GLOBALS['where_scs'] !== false) {
require_once $GLOBALS['where_scs'] . '/lib/lib.room.php';
$rules = array('room_name' => $row['name'], 'room_type' => 'course', 'id_source' => $id_course);
$admin_rules = getAdminRules();
$rules = array_merge($rules, $admin_rules);
$re = insertRoom($rules);
}
$course_idst = DoceboCourse::createCourseLevel($id_course);
require_once $GLOBALS['where_lms'] . '/lib/lib.manmenu.php';
if (!cerateCourseMenuFromCustom($this->std_menu_to_assign, $id_course, $course_idst)) {
$this->last_error = 'Error in menu assignament';
return false;
}
} else {
// course is to update
$query_course = "\r\n\t\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_course \r\n\t\t\tSET code = '" . addslashes($row['code']) . "', \r\n\t\t\t\tname = '" . addslashes($row['name']) . "', \r\n\t\t\t\tdescription = '" . $row['description'] . "', \r\n\t\t\t\tlang_code = '" . $row['lang_code'] . "', \r\n\t\t\t\tstatus = '" . $row['status'] . "', \r\n\t\t\t\tsubscribe_method = '" . $row['subscribe_method'] . "',\r\n\t\t\t\tpermCloseLO = '" . $row['permCloseLO'] . "', \r\n\t\t\t\tdifficult = '" . $row['difficult'] . "', \r\n\t\t\t\tshow_progress = '" . $row['show_progress'] . "', \r\n\t\t\t\tshow_time = '" . $row['show_time'] . "', \r\n\t\t\t\tshow_extra_info = '" . $row['show_extra_info'] . "', \r\n\t\t\t\tshow_rules = '" . $row['show_rules'] . "', \r\n\t\t\t\tdate_begin = '" . $row['date_begin'] . "', \r\n\t\t\t\tdate_end = '" . $row['date_end'] . "', \r\n\t\t\t\tvalid_time = '" . $row['valid_time'] . "',\r\n\t\t\t\tmax_num_subscribe = '" . $row['max_num_subscribe'] . "', \r\n\t\t\t\tprize = '" . $row['prize'] . "',\r\n\t\t\t\tselling = '" . $row['selling'] . "'\r\n\t\t\tWHERE idCourse = '" . $id_course . "'";
if (!sql_query($query_course)) {
$this->last_error = 'Error in update query : ( ' . mysql_error() . ' )' . '<!-- ' . $query_course . ' -->';
return false;
}
}
if ($id_course != false) {
if ($this->cache_inserted) {
$this->arr_id_inserted[] = $id_course;
}
if ($this->sendnotify == 1) {
// send notify
if ($is_add) {
require_once $GLOBALS['where_framework'] . '/lib/lib.eventmanager.php';
$msg_composer = new EventMessageComposer();
$msg_composer->setSubjectLangText('email', '_ALERT_SUBJECT', false);
$msg_composer->setBodyLangText('email', '_ALERT_TEXT', array('[url]' => Get::sett('url'), '[course_code]' => $row['code'], '[course]' => $row['name']));
$msg_composer->setBodyLangText('sms', '_ALERT_TEXT_SMS', array('[url]' => Get::sett('url'), '[course_code]' => $row['code'], '[course]' => $row['name']));
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
$course_man = new Man_Course();
$recipients = $course_man->getIdUserOfLevel($id_course);
createNewAlert('CoursePropModified', 'course', 'add', '1', 'Inserted course ' . $_POST['course_name'], $recipients, $msg_composer);
}
}
return true;
}
$this->last_error = 'Unknow error';
return false;
}
