Looks whether a media are already in the database, for the COW work
/**
* Updates media associated to a point
*
* @param string $poi
* @param string $mm_type
*
* @return void
*/
public static function UpdateMedia($poi, $mm_type)
{
global $g_ado_db;
global $g_user;
/*
A)
1) given article_number, language_id, map_id, list of map_loc_lan_id / new data
B)
//cycle:
1) read multimedia_id (as old_med_id) of the map_loc_med_id
2) insert new multimedia with new data
3) get the inserted id into new_med_id
4) update maplocationmultimedia into the new_med_id for the map_loc_med_id
6) delete multimedia of old_med_id if none maplocationmultimedia with a link into the old_med_id
*/
// ad B 1)
$queryStr_med_id = "SELECT fk_multimedia_id AS med FROM " . self::TABLE_JOIN . " WHERE id = ?";
// ad B 2)
$queryStr_med_in = "INSERT INTO " . self::TABLE . " (media_type, media_spec, media_src, media_width, media_height, IdUser) VALUES (";
$queryStr_med_in .= "?, ?, ?, ?, ?";
$queryStr_med_in .= ", %%user_id%%)";
// ad B 4)
$queryStr_map_up = "UPDATE " . self::TABLE_JOIN . " SET fk_multimedia_id = ? WHERE id = ?";
$queryStr_map_in = "INSERT INTO " . self::TABLE_JOIN . " (fk_maplocation_id, fk_multimedia_id) VALUES (?, ?)";
$queryStr_map_rm = "DELETE FROM " . self::TABLE_JOIN . " WHERE id = ?";
// ad B 6)
$queryStr_med_rm = "DELETE FROM " . self::TABLE . " WHERE id = ? AND NOT EXISTS (SELECT id FROM " . self::TABLE_JOIN . " WHERE fk_multimedia_id = ?)";
// ad B 1)
$mm_id = null;
$mm_spec = "";
$mm_src = "";
$mm_width = "";
$mm_height = "";
$mm_insert = false;
if ("image" == $mm_type)
{
//print_r($poi);
$mm_id = $poi["image_mm"];
$mm_spec = "";
$mm_src = $poi["image_src"];
$mm_width = $poi["image_width"];
$mm_height = $poi["image_height"];
if ("" != $mm_src) {$mm_insert = true;}
}
if ("video" == $mm_type)
{
$mm_id = $poi["video_mm"];
$mm_spec = $poi["video_type"];
$mm_src = $poi["video_id"];
$mm_width = $poi["video_width"];
$mm_height = $poi["video_height"];
if ("" != $mm_src) {$mm_insert = true;}
}
if (null === $mm_id) {return;}
$med_old_id = null;
if ($mm_id)
{
try
{
$mapmed_sel_params = array();
$mapmed_sel_params[] = $mm_id;
$rows = $g_ado_db->GetAll($queryStr_med_id, $mapmed_sel_params);
if (is_array($rows)) {
foreach ($rows as $row) {
$med_old_id = $row['med'];
}
}
}
catch (Exception $exc)
{
return false;
}
if (null === $med_old_id) {return;}
}
// ad B 2)
$med_new_id = 0;
// insert (and connect) just when there is something to insert
if ($mm_insert)
{
$mm_options = ""; // currently no options used
$reuse_id = Geo_Multimedia::FindMedia($mm_type, $mm_spec, $mm_src, $mm_width, $mm_height, $mm_options);
if ($reuse_id && (0 < $reuse_id))
{
$med_new_id = $reuse_id;
}
else
{
$med_ins_params = array();
$med_ins_params[] = "" . $mm_type;
$med_ins_params[] = "" . $mm_spec;
$med_ins_params[] = "" . $mm_src;
$med_ins_params[] = 0 + $mm_width;
$med_ins_params[] = 0 + $mm_height;
$queryStr_med_in = str_replace("%%user_id%%", $g_user->getUserId(), $queryStr_med_in);
$success = $g_ado_db->Execute($queryStr_med_in, $med_ins_params);
// ad B 3)
$med_new_id = $g_ado_db->Insert_ID();
}
// ad B 4) -- was no media for this connector, thus create a new one
if (null === $med_old_id)
{
$map_in_params = array();
$map_in_params[] = $poi["location_id"];
$map_in_params[] = $med_new_id;
$success = $g_ado_db->Execute($queryStr_map_in, $map_in_params);
return;
}
else // -- already had a media, thus just update the connector
{
$map_up_params = array();
$map_up_params[] = $med_new_id;
$map_up_params[] = $mm_id;
$success = $g_ado_db->Execute($queryStr_map_up, $map_up_params);
}
}
else // here: nothing to left connected, thus deleting the old connector if any
{
if ($mm_id) // if a connector was there
{
// ad B 4) deleting the old connector;
$map_rm_params = array();
$map_rm_params[] = $mm_id;
$success = $g_ado_db->Execute($queryStr_map_rm, $map_rm_params);
}
}
// ad B 6)
try
{
$med_rm_params = array();
$med_rm_params[] = $med_old_id;
$med_rm_params[] = $med_old_id;
$success = $g_ado_db->Execute($queryStr_med_rm, $med_rm_params);
}
catch (Exception $exc)
{
return false;
}
} // fn UpdateMedia
/**
* Updates media associated to a point
*
* @param string $poi
* @param string $mm_type
*
* @return void
*/
public static function UpdateMedia($poi, $mm_type)
{
global $g_ado_db;
global $g_user;
/*
A)
1) given article_number, language_id, map_id, list of map_loc_lan_id / new data
B)
//cycle:
1) read multimedia_id (as old_med_id) of the map_loc_med_id
2) insert new multimedia with new data
3) get the inserted id into new_med_id
4) update maplocationmultimedia into the new_med_id for the map_loc_med_id
6) delete multimedia of old_med_id if none maplocationmultimedia with a link into the old_med_id
*/
// ad B 1)
$queryStr_med_id = 'SELECT fk_multimedia_id AS med FROM ' . self::TABLE_JOIN . ' WHERE id = ?';
// ad B 2)
$queryStr_med_in = 'INSERT INTO ' . self::TABLE . ' (media_type, media_spec, media_src, media_width, media_height, IdUser) VALUES (';
$queryStr_med_in .= '?, ?, ?, ?, ?';
$queryStr_med_in .= ', %%user_id%%)';
// ad B 4)
$queryStr_map_up = 'UPDATE ' . self::TABLE_JOIN . ' SET fk_multimedia_id = ? WHERE id = ?';
$queryStr_map_in = 'INSERT INTO ' . self::TABLE_JOIN . ' (fk_maplocation_id, fk_multimedia_id) VALUES (?, ?)';
$queryStr_map_rm = 'DELETE FROM ' . self::TABLE_JOIN . ' WHERE id = ?';
// ad B 6)
$queryStr_med_rm = 'DELETE FROM ' . self::TABLE . ' WHERE id = ? AND NOT EXISTS (SELECT id FROM ' . self::TABLE_JOIN . ' WHERE fk_multimedia_id = ?)';
// ad B 1)
$mm_id = null;
$mm_spec = '';
$mm_src = '';
$mm_width = '';
$mm_height = '';
$mm_insert = false;
if ('image' == $mm_type) {
$mm_id = $poi['image_mm'];
$mm_spec = '';
$mm_src = $poi['image_src'];
$mm_width = $poi['image_width'];
$mm_height = $poi['image_height'];
if ('' != $mm_src) {
$mm_insert = true;
}
}
if ('video' == $mm_type) {
$mm_id = $poi['video_mm'];
$mm_spec = $poi['video_type'];
$mm_src = $poi['video_id'];
$mm_width = $poi['video_width'];
$mm_height = $poi['video_height'];
if ('' != $mm_src) {
$mm_insert = true;
}
}
if (null === $mm_id) {
return;
}
$med_old_id = null;
if ($mm_id) {
try {
$mapmed_sel_params = array();
$mapmed_sel_params[] = $mm_id;
$rows = $g_ado_db->GetAll($queryStr_med_id, $mapmed_sel_params);
if (is_array($rows)) {
foreach ($rows as $row) {
$med_old_id = $row['med'];
}
}
} catch (Exception $exc) {
return false;
}
if (null === $med_old_id) {
return;
}
}
// ad B 2)
$med_new_id = 0;
// insert (and connect) just when there is something to insert
if ($mm_insert) {
$mm_options = '';
// currently no options used
$reuse_id = Geo_Multimedia::FindMedia($mm_type, $mm_spec, $mm_src, $mm_width, $mm_height, $mm_options);
if ($reuse_id && 0 < $reuse_id) {
$med_new_id = $reuse_id;
} else {
$med_ins_params = array();
$med_ins_params[] = '' . $mm_type;
$med_ins_params[] = '' . $mm_spec;
$med_ins_params[] = '' . $mm_src;
$med_ins_params[] = 0 + $mm_width;
$med_ins_params[] = 0 + $mm_height;
$queryStr_med_in = str_replace('%%user_id%%', $g_user->getUserId(), $queryStr_med_in);
$success = $g_ado_db->Execute($queryStr_med_in, $med_ins_params);
// ad B 3)
$med_new_id = $g_ado_db->Insert_ID();
}
// ad B 4) -- was no media for this connector, thus create a new one
if (null === $med_old_id) {
$map_in_params = array();
$map_in_params[] = $poi['location_id'];
$map_in_params[] = $med_new_id;
$success = $g_ado_db->Execute($queryStr_map_in, $map_in_params);
return;
} else {
$map_up_params = array();
$map_up_params[] = $med_new_id;
$map_up_params[] = $mm_id;
$success = $g_ado_db->Execute($queryStr_map_up, $map_up_params);
}
} else {
if ($mm_id) {
// ad B 4) deleting the old connector;
$map_rm_params = array();
$map_rm_params[] = $mm_id;
$success = $g_ado_db->Execute($queryStr_map_rm, $map_rm_params);
}
}
// ad B 6)
try {
$med_rm_params = array();
$med_rm_params[] = $med_old_id;
$med_rm_params[] = $med_old_id;
$success = $g_ado_db->Execute($queryStr_med_rm, $med_rm_params);
} catch (Exception $exc) {
return false;
}
}
