public static function deletePollBySID($sid)
{
if (SJB_ObjectDBManager::deleteObjectInfoFromDB('polls', $sid)) {
SJB_DB::query('DELETE FROM `polls_field_list` WHERE `field_sid` = ?n', $sid);
SJB_DB::query('DELETE FROM `polls_results` WHERE `poll_sid` = ?n', $sid);
}
}
public static function deleteQuestionBySID($sid)
{
$info = self::getFieldInfoBySID($sid);
if (!strcasecmp("list", $info['type']) || !strcasecmp("boolean", $info['type']) || !strcasecmp("multilist", $info['type'])) {
SJB_DB::query("DELETE FROM questions_field_list WHERE field_sid = ?n" . $sid);
}
return parent::deleteObjectInfoFromDB("questions", $sid);
}
public static function deleteUserById($id)
{
SJB_DB::query('UPDATE `users` SET `parent_sid` = 0 WHERE `parent_sid` = ?n', $id);
SJB_DB::query('UPDATE `listings` SET `subuser_sid` = 0 WHERE `subuser_sid` = ?n', $id);
$user = SJB_UserManager::getObjectBySID($id);
SJB_Statistics::addStatistics('deleteUser', $user->getUserGroupSID(), $user->getSID());
return parent::deleteObjectInfoFromDB('users', $id);
}
public static function deleteAlphabetBySID($ABSsid)
{
return SJB_ObjectDBManager::deleteObjectInfoFromDB("alphabet", $ABSsid);
}
public static function deleteCurrencyBySID($currency_sid)
{
return parent::deleteObjectInfoFromDB('currency', $currency_sid);
}
public static function deleteUserProfileFieldInfo($user_profile_field_sid)
{
$field_info = SJB_UserProfileFieldDBManager::getUserProfileFieldInfoBySID($user_profile_field_sid);
if (!strcasecmp("list", $field_info['type'])) {
SJB_DB::query("DELETE FROM user_profile_field_list WHERE field_sid = ?n" . $user_profile_field_sid);
} elseif (!strcasecmp('location', $field_info['type'])) {
SJB_DB::query('DELETE FROM user_profile_fields WHERE parent_sid = ?n', $user_profile_field_sid);
}
if (parent::deleteObjectInfoFromDB('user_profile_fields', $user_profile_field_sid)) {
$result = SJB_DB::query("SELECT * FROM `user_profile_fields` WHERE `id` = ?s", $field_info['id']);
if (count($result) == 0) {
if (!strcasecmp('location', $field_info['type'])) {
parent::deleteField('users', $field_info['id'] . "_Country");
parent::deleteField('users', $field_info['id'] . "_State");
parent::deleteField('users', $field_info['id'] . "_City");
parent::deleteField('users', $field_info['id'] . "_ZipCode");
}
return parent::deleteField('users', $field_info['id']);
} else {
SJB_DB::query("UPDATE users SET `{$field_info['id']}` = null WHERE `user_group_sid` = ?n", $field_info['user_group_sid']);
}
}
return false;
}
/**
* @static
* @param int $templateSID
* @return array|bool|int
*/
public static function deleteEmailTemplateBySID($templateSID)
{
$emailTemplate = SJB_EmailTemplateEditor::getEmailTemplateBySID($templateSID);
if (!empty($emailTemplate)) {
$userDefined = $emailTemplate->getPropertyValue('user_defined');
if ($userDefined) {
// delete atachment
$fileProp = $emailTemplate->getProperty('file');
if ($fileProp) {
SJB_UploadFileManager::deleteUploadedFileByID($fileProp->value);
}
return SJB_ObjectDBManager::deleteObjectInfoFromDB('email_templates', $templateSID);
}
}
return false;
}
public static function deleteObject($db_table_name, $object_sid)
{
return SJB_ObjectDBManager::deleteObjectInfoFromDB($db_table_name, $object_sid);
}
public static function deleteListingTypeBySID($listing_type_sid)
{
return parent::deleteObjectInfoFromDB("listing_types", $listing_type_sid);
}
public static function deleteArticleBySID($articleSid)
{
parent::deleteObjectInfoFromDB('news', $articleSid);
}
public static function deleteQuestionnaireBySID($sid)
{
SJB_ObjectDBManager::deleteObjectInfoFromDB('screening_questionnaires', $sid);
SJB_ScreeningQuestionnairesFieldManager::deleteQuestionsByParentSID($sid);
SJB_DB::query("UPDATE `listings` SET `screening_questionnaire`='' WHERE `screening_questionnaire`=?n", $sid);
}
public static function deleteComplexListingFieldBySID($listing_field_info)
{
if (!strcasecmp('list', $listing_field_info->field_type)) {
SJB_DB::query('DELETE FROM listing_field_list WHERE field_sid = ?n' . $listing_field_info->sid);
} elseif (!strcasecmp('tree', $listing_field_info->field_type)) {
SJB_DB::query('DELETE FROM listing_field_tree WHERE field_sid = ?n', $listing_field_info->sid);
}
return parent::deleteObjectInfoFromDB('listing_complex_fields', $listing_field_info->sid);
}
public static function deleteProductBySID($productSID)
{
SJB_ShoppingCart::deleteItemsFromCartByProductSID($productSID);
return SJB_ObjectDBManager::deleteObjectInfoFromDB('products', $productSID);
}
public static function deleteSubAdminById($id)
{
return parent::deleteObjectInfoFromDB('subadmins', $id);
}
public static function deleteUserGroupInfo($user_group_sid)
{
return parent::deleteObjectInfoFromDB('user_groups', $user_group_sid);
}
public static function deleteListingBySID($listing_sid)
{
$listing = SJB_ListingManager::getObjectBySID($listing_sid);
if (parent::deleteObjectInfoFromDB('listings', $listing_sid)) {
SJB_Statistics::addStatistics('deleteListing', $listing->getListingTypeSID(), $listing->getSID());
}
}
