function linkTempEmails($key)
{
global $application;
$tables = Subscriptions::getTables();
$table = 'subscription_temp';
$columns =& $tables[$table]['columns'];
$atable = 'email_address';
$acolumns =& $tables[$atable]['columns'];
$query = new DB_Update($table);
$query->addUpdateTable($atable);
$query->addUpdateExpression($columns['email_id'], $acolumns['email_id']);
$query->addUpdateValue($columns['state'], SUBSCRIPTION_TEMP_EXISTS);
$query->WhereValue($columns['action_key'], DB_EQ, $key);
$query->WhereAND();
$query->WhereField($columns['email'], DB_EQ, $acolumns['email']);
$application->db->getDB_Result($query);
$query = new DB_Update($table);
$query->addUpdateValue($columns['state'], SUBSCRIPTION_TEMP_DONT_EXISTS);
$query->WhereValue($columns['action_key'], DB_EQ, $key);
$query->WhereAND();
$query->WhereValue($columns['state'], DB_EQ, SUBSCRIPTION_TEMP_UNKNOWN);
$application->db->getDB_Result($query);
}
function updateImagesSortOrder($product_id, $sort_order)
{
global $application;
$tables = $this->getTables();
$images_table = $tables['pi_images']['columns'];
for ($i = 0; $i < count($sort_order); $i++) {
$query = new DB_Update('pi_images');
$query->addUpdateValue($images_table['sort_order'], $i);
$query->WhereValue($images_table['product_id'], DB_EQ, $product_id);
$query->WhereAND();
$query->WhereValue($images_table['image_id'], DB_EQ, $sort_order[$i]);
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
return;
}
/**
* Copies the part of the updateOrder($data) functionality. It is created
* only, because updateOrder is too hungus for the small update.
*/
function updateOrderPersonDataAttribute($order_id, $person_info_variant_id, $person_attribute_id, $b_encrypted, $encrypted_symmetric_secret_key, $rsa_public_key_asc_format, $new_value)
{
global $application;
$tables = $this->getTables();
$opd = $tables['order_person_data']['columns'];
$db_update = new DB_Update('order_person_data');
$db_update->addUpdateValue($opd['value'], $new_value);
$db_update->addUpdateValue($opd['encrypted_secret_key'], $encrypted_symmetric_secret_key);
$db_update->addUpdateValue($opd['rsa_public_key_asc_format'], $rsa_public_key_asc_format);
$db_update->WhereValue($opd['order_id'], DB_EQ, $order_id);
$db_update->WhereAND();
$db_update->WhereValue($opd['attribute_id'], DB_EQ, $person_attribute_id);
$db_update->WhereAND();
$db_update->WhereValue($opd['variant_id'], DB_EQ, $person_info_variant_id);
$db_update->WhereAND();
$db_update->WhereValue($opd['b_encrypted'], DB_EQ, $b_encrypted ? "1" : "0");
$application->db->PrepareSQL($db_update);
$application->db->DB_Exec();
}
function updateGroupAttrsSortOrder($group_name, $attrs_sort_order)
{
global $application;
$tables = $this->getTables();
$atg_table = $tables['ca_attrs_to_groups']['columns'];
$group_info = $this->getPersonInfoGroupInfoByName($group_name);
for ($i = 0; $i < count($attrs_sort_order); $i++) {
$query = new DB_Update('ca_attrs_to_groups');
$query->addUpdateValue($atg_table['sort_order'], $i);
$query->WhereValue($atg_table['group_id'], DB_EQ, $group_info['group_id']);
$query->WhereAND();
$query->WhereValue($atg_table['attr_id'], DB_EQ, $attrs_sort_order[$i]);
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
return;
}
/**
* Updates Inventory data.
*
* @param string $parent_entity - entity name
* @param int $entity_id - ID of the entity
* @param $inv_data = array(
* '$it_id_01' => array(
* 'sku' => string
* 'quantity' => int
* )
* .......
* );
* @return bool; true if it is updated, false otherwise
*/
function updateInventory($parent_entity, $entity_id, $inv_data)
{
if (!is_array($inv_data) or empty($inv_data)) {
return true;
}
global $application;
$tables = $this->getTables();
$it_table = $tables['po_inventory']['columns'];
foreach ($inv_data as $it_id => $it_data) {
$query = new DB_Update('po_inventory');
$query->addUpdateValue($it_table['sku'], $it_data['sku']);
$query->addUpdateValue($it_table['quantity'], intval($it_data['quantity']));
$query->WhereValue($it_table['parent_entity'], DB_EQ, $parent_entity);
$query->WhereAND();
$query->WhereValue($it_table['entity_id'], DB_EQ, $entity_id);
$query->WhereAND();
$query->WhereValue($it_table['it_id'], DB_EQ, $it_id);
$application->db->PrepareSQL($query);
if (!$application->db->DB_Exec()) {
return false;
}
}
return true;
}
function updateHotlinkExpireDate($opid, $hl_id, $ts)
{
global $application;
$tables = $this->getTables();
$hl_table = $tables['pf_hotlinks']['columns'];
$query = new DB_Update('pf_hotlinks');
$query->addUpdateValue($hl_table['expire_date'], $ts);
$query->WhereValue($hl_table['order_product_id'], DB_EQ, $opid);
$query->WhereAND();
$query->WhereValue($hl_table['hotlink_id'], DB_EQ, $hl_id);
$application->db->PrepareSQL($query);
return $application->db->DB_Exec();
}
