check();
if( $msg ) {
return "CPreference::store-check failed
$msg";
}
if (($msg = $this->delete())) {
return "CPreference::store-delete failed
$msg";
}
if (!($ret = db_insertObject( 'user_preferences', $this, 'pref_user' ))) {
return "CPreference::store failed
" . db_error();
} else {
return NULL;
}
}
function delete() {
$sql = "DELETE FROM user_preferences WHERE pref_user = $this->pref_user AND pref_name = '$this->pref_name'";
if (!db_exec( $sql )) {
return db_error();
} else {
return NULL;
}
}
}
/**
* Module class
*/
class CModule extends CDpObject {
var $mod_id=null;
var $mod_name=null;
var $mod_directory=null;
var $mod_version=null;
var $mod_setup_class=null;
var $mod_type=null;
var $mod_active=null;
var $mod_ui_name=null;
var $mod_ui_icon=null;
var $mod_ui_order=null;
var $mod_ui_active=null;
var $mod_description=null;
var $permissions_item_label=null;
var $permissions_item_field=null;
var $permissions_item_table=null;
function CModule() {
$this->CDpObject( 'modules', 'mod_id' );
}
function install() {
$sql = "SELECT mod_directory FROM modules WHERE mod_directory = '$this->mod_directory'";
if (db_loadHash( $sql, $temp )) {
// the module is already installed
// TODO: check for older version - upgrade
return false;
}
$sql = 'SELECT max(mod_ui_order)
FROM modules';
$this->mod_ui_order = db_loadResult($sql) + 1;
$perms =& $GLOBALS['AppUI']->acl();
$perms->addModule($this->mod_directory, $this->mod_name);
// Determine if it is an admin module or not, then add it to the correct set
if (! isset($this->mod_admin))
$this->mod_admin = 0;
if ($this->mod_admin) {
$perms->addGroupItem($this->mod_directory, "admin");
} else {
$perms->addGroupItem($this->mod_directory, "non_admin");
}
if (isset($this->permissions_item_table) && $this->permissions_item_table)
$perms->addModuleSection($this->permissions_item_table);
$this->store();
return true;
}
function remove() {
$sql = "DELETE FROM modules WHERE mod_id = $this->mod_id";
if (!db_exec( $sql )) {
return db_error();
} else {
$perms =& $GLOBALS['AppUI']->acl();
if (! isset($this->mod_admin))
$this->mod_admin = 0;
if ($this->mod_admin) {
$perms->deleteGroupItem($this->mod_directory, "admin");
} else {
$perms->deleteGroupItem($this->mod_directory, "non_admin");
}
$perms->deleteModule($this->mod_directory);
if (isset($this->permissions_item_table) && $this->permissions_item_table)
$perms->deleteModuleSection($this->permissions_item_table);
return NULL;
}
}
function move( $dirn ) {
$temp = $this->mod_ui_order;
if ($dirn == 'moveup') {
$temp--;
$sql = "UPDATE modules SET mod_ui_order = (mod_ui_order+1) WHERE mod_ui_order = $temp";
db_exec( $sql );
} else if ($dirn == 'movedn') {
$temp++;
$sql = "UPDATE modules SET mod_ui_order = (mod_ui_order-1) WHERE mod_ui_order = $temp";
db_exec( $sql );
}
$sql = "UPDATE modules SET mod_ui_order = $temp WHERE mod_id = $this->mod_id";
db_exec( $sql );
$this->mod_id = $temp;
}
// overridable functions
function moduleInstall() {
return null;
}
function moduleRemove() {
return null;
}
function moduleUpgrade() {
return null;
}
}
/**
* Configuration class
*/
class CConfig extends CDpObject {
function CConfig() {
$this->CDpObject( 'config', 'config_id' );
}
function getChildren($id) {
$this->_query->clear();
$this->_query->addTable('config_list');
$this->_query->addOrder('config_list_id');
$this->_query->addWhere('config_id = ' . $id);
$sql = $this->_query->prepare();
$this->_query->clear();
return db_loadHashList($sql, 'config_list_id');
}
}
class prole {
var $proles_id=NULL;
var $proles_name;
var $proles_description;
var $proles_hour_cost;
var $proles_status;
function bcode() {
}
function bind( $hash ) {
if (!is_array($hash)) {
return "Project roles::bind failed";
} else {
bindHashToObject( $hash, $this );
return NULL;
}
}
function delete() {
$sql = "UPDATE project_roles SET proles_status=1 WHERE proles_id='".$this->proles_id."'";
if (!db_exec( $sql )) {
return db_error();
} else {
return NULL;
}
}
function store() {
if (!($ret = db_insertObject ( 'project_roles', $this, 'proles_id' ))) {
return "Project Roles::store failed. " . db_error();
} else {
return NULL;
}
}
}