File Source for tangra_module_release_relation

<?php
/**
* Contains class Tangra_Module_Installer
*
* @package tangra_lib
* @subpackage modules_manager
*/
/**
*
*/
require_once(TANGRA_MAIN_DIR.'interfaces/i_db_storable.class.php');
/**
*
*/
require_once('tangra_module_release_relation.class.php');
/**
* Tangra_Module_Release_Relation_DBC
*
* @package tangra_lib
* @subpackage modules_manager
*/
class Tangra_Module_Release_Relation_DBC extends Tangra_Module_Release_Relation implements I_DB_Storable {
/**
* Saves the record
*
* @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 record 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) {
tangra_if_not_int_throw_e($id);
$ret = false;
$sql = "select id, type, module_release, relation_to, version_requirement from tmod_release_relations where id = $id";
$rez = $dbc->execute($sql);
if (!$rez->is_eof()) {
$rez_obj = $rez->fetch_object();
$this->set_id($id);
$this->set_type($rez_obj->TYPE);
$this->set_module_release($rez_obj->MODULE_RELEASE);
$this->set_relation_to(stripslashes($rez_obj->RELATION_TO));
$this->set_version_requirement(stripslashes($rez_obj->VERSION_REQUIREMENT));
$ret = $id;
}
return $ret;
}
/**
* Inserts new DB record
*
* @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('tmod_release_relations_seq');
$type = $this->get_type();
$module_release = $this->get_module_release();
$relation_to = addslashes($this->get_relation_to());
$version_requirement = addslashes($this->get_version_requirement());
if ($id) {
$sql = "insert into tmod_release_relations (id, ".
"type, ".
"module_release, ".
"relation_to, ".
"version_requirement ".
") ".
"values ".
"($id,".
"$type, ".
"$module_release, ".
"'$relation_to', ".
"'$version_requirement' ".
")";
$dbc->execute($sql);
$ret = $id;
} else {
throw new TE_Exception('ID not generated - settings_seq');
}
return $ret;
}
/**
* Updates existing 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();
$type = $this->get_type();
$module_release = $this->get_module_release();
$relation_to = addslashes($this->get_relation_to());
$version_requirement = addslashes($this->get_version_requirement());
$sql = "update tmod_release_relations set ".
"type = $type, ".
"module_release = $module_release, ".
"relation_to = '$relation_to', ".
"version_requirement = '$version_requirement' ".
"where id = ".$id;
$dbc->execute($sql);
$ret = $id;
return $ret;
}
/**
* Deletes record
*
* @param DB_Connection $dbc
* @param integer $param_id Parameter ID
*/
public static function delete(DB_Connection $dbc, $id) {
tangra_if_not_int_throw_e($id);
$sql = "delete from tmod_release_relations where id = $id";
$dbc->execute($sql);
}
public static function delete_relations_for_module(DB_Connection $dbc, $module_id) {
tangra_if_not_int_throw_e($module_id);
$sql = "select id from tmod_release_relations where module = $module_id";
$rez = $dbc->execute($sql);
while($rez_obj = $rez->fetch_object()) {
Tangra_Module_Relation_DBC::delete($dbc, $rez_obj->ID);
}
}
/**
* Gets SQL for grid
*
* @param integer $mod_rel_id Release ID
* @return string SQL statement
*/
public static function get_sql_for_grid($mod_rel_id) {
tangra_if_not_int_throw_e($mod_rel_id);
$sql = "select rr.id, ".
"rt.name, ".
"rr.relation_to, ".
"rr.version_requirement ".
"from tmod_release_relations rr, ".
"tmod_relation_types rt ".
"where rr.module_release = $mod_rel_id and ".
"rr.type = rt.id ".
"order by rr.relation_to asc";
return $sql;
}
/**
* Gets count SQL for grid
*
* @param integer $mod_rel_id Release ID
* @return string SQL statement
*/
public static function get_sql_count_for_grid($mod_rel_id) {
tangra_if_not_int_throw_e($mod_rel_id);
$sql = "select count(rc.id) as total_rows ".
"from tmod_release_relations rc ".
"where rc.module_release = $mod_rel_id";
return $sql;
}
/**
* Loads options-labels map for form_field_select
*
* @param DB_Connection $dbc
* @return array
*/
public static function load_types_ol_map(DB_Connection $dbc) {
$sql = "select id, name from tmod_relation_types 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->NAME;
}
if ($ids) {
$ret['ids'] = $ids;
}
return $ret;
}
/**
* Loads all relations for type for release
*
* @param DB_Connection $dbc
* @param integer $module_release_id Release ID
* @param integer $type_id Type ID
* @return array
*/
public static function select_for_release_by_type(DB_Connection $dbc, $module_release_id, $type_id) {
tangra_if_not_int_throw_e($module_release_id);
tangra_if_not_int_throw_e($type_id);
$sql = "select relation_to, ".
"version_requirement ".
"from tmod_release_relations ".
"where module_release = $module_release_id and ".
"type = $type_id ".
"order by relation_to asc";
$rez = $dbc->execute($sql);
$ret = array();
while ($rez_obj = $rez->fetch_object()) {
$ret[] = array('hid' => $rez_obj->RELATION_TO, 'version_requirement' => $rez_obj->VERSION_REQUIREMENT);
}
return $ret;
}
/**
* Deletes all relation for release
*
* @param DB_Connection $dbc
* @param integer $module_release_id Release ID
*/
public static function delete_for_release(DB_Connection $dbc, $module_release_id) {
tangra_if_not_int_throw_e($module_release_id);
$sql = "delete from tmod_release_relations where module_release = $module_release_id";
$dbc->execute($sql);
}
/**
* Copyes relation from one release to other
*
* @param DB_Connection $dbc
* @param integer $from_id Source release ID
* @param integer $to_id Target release ID
*/
public static function copy_relations(DB_Connection $dbc, $from_id, $to_id) {
tangra_if_not_int_throw_e($from_id);
tangra_if_not_int_throw_e($to_id);
$sql = "select id from tmod_release_relations where module_release = $from_id";
$rez = $dbc->execute($sql);
while ($rez_obj = $rez->fetch_object()) {
$tmp_from = new Tangra_Module_Release_Relation_DBC();
$tmp_from->load_by_id($dbc, $rez_obj->ID);
$tmp_from->set_id(0);
$tmp_from->set_module_release($to_id);
$tmp_from->save($dbc);
}
}
}

Source for file tangra_module_release_relation_dbc.class.php