File Source for tangra_module_category

<?php
// $Id$
/**
* Contains class Tangra_Module_Category_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
/**
*
*/
require_once(TANGRA_MAIN_DIR.'interfaces/i_db_storable.class.php');
/**
*
*/
require_once('tangra_module_category.class.php');
/**
* Tangra_Module_Category_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
class Tangra_Module_Category_DBC extends Tangra_Module_Category implements I_DB_Storable {
/**
* Saves category into DB
*
* @param DB_Connection $dbc
* @return integer On success returns category 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 category by ID
*
* @param DB_Connection $dbc
* @param integer $id
* @return integer On success returns category ID, on failure - false
*/
public function load_by_id(DB_Connection $dbc, $id) {
$ret = false;
$sql = "select hid, "
." name,"
." description"
." from tmod_categories "
."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_name(stripslashes($rez_obj->NAME));
$this->set_description($rez_obj->DESCRIPTION);
$ret = $id;
}
return $ret;
}
/**
* Inserts new category
*
* @param DB_Connection $dbc
* @return integer On success returns category ID, on failure - false
* @internal
*/
protected function insert(DB_Connection $dbc) {
$ret = false;
$id = $dbc->generate_id('tmod_categories_seq');
$hid = $this->get_hid();
$name = addslashes($this->get_name());
$description = addslashes($this->get_description());
if ($id) {
$sql = "insert into tmod_categories (id, "
."hid, "
."name, "
."description "
.") ".
"values ".
"($id,".
"'$hid', ".
"'$name', ".
"'$description' ".
")";
$dbc->execute($sql);
$ret = $id;
} else {
throw new TE_Exception('ID not generated - tmod_categories_seq');
}
return $ret;
}
/**
* Updates existing category DB record
*
* @param DB_Connection $dbc
* @return integer On success returns category ID, on failure - false
* @internal
*/
protected function update(DB_Connection $dbc) {
$id = $this->get_id();
$hid = $this->get_hid();
$name = addslashes($this->get_name());
$description = addslashes($this->get_description());
$sql = "update tmod_categories set ".
"hid = '$hid', ".
"name = '$name', ".
"description = '$description' ".
"where id = ".$id;
$dbc->execute($sql);
$ret = $id;
return $ret;
}
/**
* Gets SQL for grid
*
* @return string
*/
public static function get_sql_for_grid() {
$sql = "select id, hid, name, description from tmod_categories order by name asc";
return $sql;
}
/**
* Gets count SQL for grid
*
* @return string
*/
public static function get_sql_count_for_grid() {
$sql = "select count(id) as total_rows from tmod_categories";
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 tmod_categories where hid = '$hid' and id <> $id";
$rez = $dbc->execute($sql);
return $rez->is_eod();
}
/**
* Loads category by HID
*
* @param DB_Connection $dbc
* @param string $hid
* @return integer On success returns category ID, on failure - false
*/
public function load_by_hid(DB_Connection $dbc, $hid) {
$hid = addslashes($hid);
$ret = false;
$sql = "select id from tmod_categories 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;
}
}

Source for file tangra_module_category_dbc.class.php