File Source for tangra_module

<?php
// $Id$
/**
* Contains class Tangra_Module_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
/**
*
*/
require_once(TANGRA_MAIN_DIR.'interfaces/i_db_storable.class.php');
/**
*
*/
require_once('tangra_module.class.php');
/**
* Tangra_Module_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
class Tangra_Module_DBC extends Tangra_Module implements I_DB_Storable {
/**
* Saves module into DB
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
*/
public function save(DB_Connection $dbc) {
$ret = false;
if ($this->get_id()) {
$ret = $this->update($dbc);
} else {
$ret = $this->insert($dbc);
$this->set_id($ret);
}
return $ret;
}
/**
* Loads by ID
*
* @param DB_Connection $dbc
* @param integer $id
* @return integer On success returns module ID, on failure - false
*/
public function load_by_id(DB_Connection $dbc, $id) {
$ret = false;
$sql = "select hid, ".
"description, ".
"maintainer, ".
"url, ".
"license ".
"from tmods ".
"where id = $id";
$rez = $dbc->execute($sql);
if (!$rez->is_eof()) {
$rez_obj = $rez->fetch_object();
$this->set_id($id);
$this->set_hid($rez_obj->HID);
$this->set_description(stripslashes($rez_obj->DESCRIPTION));
$this->set_maintainer(stripslashes($rez_obj->MAINTAINER));
$this->set_url(stripslashes($rez_obj->URL));
$this->set_license($rez_obj->LICENSE);
$ret = $id;
}
return $ret;
}
/**
* Inserts new module
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
* @internal
*/
protected function insert(DB_Connection $dbc) {
$ret = false;
$id = $dbc->generate_id('tmods_seq');
$hid = $this->get_hid();
$description = addslashes($this->get_description());
$maintainer = addslashes($this->get_maintainer());
$url = addslashes($this->get_url());
$license = $this->get_license();
if ($id) {
$sql = "insert into tmods (id, ".
"hid, ".
"description, ".
"maintainer, ".
"url, ".
"license ".
") ".
"values ".
"($id,".
"'$hid', ".
"'$description', ".
"'$maintainer', ".
"'$url', ".
"$license ".
")";
$dbc->execute($sql);
$ret = $id;
} else {
throw new TE_Exception('ID not generated - tmods_seq');
}
return $ret;
}
/**
* Updates module DB record
*
* @param DB_Connection $dbc
* @return integer On success returns module ID, on failure - false
* @internal
*/
protected function update(DB_Connection $dbc) {
$id = $this->get_id();
$hid = $this->get_hid();
$description = addslashes($this->get_description());
$maintainer = addslashes($this->get_maintainer());
$url = addslashes($this->get_url());
$license = $this->get_license();
$sql = "update tmods set ".
"hid = '$hid', ".
"description = '$description', ".
"maintainer = '$maintainer', ".
"url = '$url', ".
"license = $license ".
"where id = ".$id;
$dbc->execute($sql);
$ret = $id;
return $ret;
}
/**
* Gets SQL for grid
*
* @return string SQL statement
*/
public static function get_sql_for_grid() {
$sql = "select id, hid from tmods order by hid asc";
return $sql;
}
/**
* Gets count SQL for grid
*
* @return string SQL statement
*/
public static function get_sql_count_for_grid() {
$sql = "select count(id) as total_rows from tmods";
return $sql;
}
/**
* Checks if HID is unique
*
* @param DB_Connection $dbc
* @param string $hid HID to check if exists
* @param integer $id ID of current category
* @return boolean
*/
public static function is_unique_hid(DB_Connection $dbc, $hid, $id = 0) {
tangra_if_not_int_throw_e($id);
$hid = addslashes($hid);
$sql = "select id from tmods where hid = '$hid' and id <> $id";
$rez = $dbc->execute($sql);
return $rez->is_eod();
}
/**
* Loads options labels map for Form_field_select
*
* @param DB_Connection $dbc
* @param integer $current_module_id
* @return array
*/
public static function load_modules_ol_map(DB_Connection $dbc, $current_module_id) {
tangra_if_not_int_throw_e($current_module_id);
$sql = "select id, hid from tmods where id <> $current_module_id order by id asc";
$rez = $dbc->execute($sql);
$ret = array();
$ids = array();
while($rez_obj = $rez->fetch_object()) {
array_push($ids, $rez_obj->ID);
$ret['ol_map'][$rez_obj->ID] = $rez_obj->HID;
}
if ($ids) {
$ret['ids'] = $ids;
}
return $ret;
}
/**
* Loads module by HID
*
* @param DB_Connection $dbc
* @param string $hid
* @return integer On success returns module ID, on failure - false
*/
public function load_by_hid(DB_Connection $dbc, $hid) {
$hid = addslashes($hid);
$ret = false;
$sql = "select id from tmods where hid = '$hid'";
$rez = $dbc->execute($sql);
if (!$rez->is_eod()) {
$rez_obj = $rez->fetch_object();
$ret = $this->load_by_id($dbc, $rez_obj->ID);
}
return $ret;
}
/**
* Loads all modules
*
* @param DB_Connection $dbc
* @return array Array of Tangra_Module_DBC objects
*/
public static function load_all(DB_Connection $dbc) {
$sql = "select id from tmods";
$rez = $dbc->execute($sql);
$ret = array();
while ($rez_obj = $rez->fetch_object()) {
$tmp = new Tangra_Module_DBC();
$tmp->load_by_id($dbc, $rez_obj->ID);
$ret[] = clone $tmp;
}
return $ret;
}
/**
* Loads all HIDs as array
*
* @param DB_Connection $dbc
* @return array
*/
public static function load_all_hids_as_array(DB_Connection $dbc) {
$sql = "select hid from tmods";
$rez = $dbc->execute($sql);
$ret = array();
while ($rez_obj = $rez->fetch_object()) {
$ret[$rez_obj->HID] = false;
}
return $ret;
}
/**
* Deletes module
*
* @param DB_Connection $dbc
* @param integer $id
*/
public static function delete(DB_Connection $dbc, $id) {
tangra_if_not_int_throw_e($id);
$sql = "delete from tmods where id = $id";
$dbc->execute($sql);
}
}

Source for file tangra_module_dbc.class.php