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 saveCountry(SJB_Country $country)
{
$countrySID = $country->getSID();
SJB_ObjectDBManager::saveObject('countries', $country);
if (!$countrySID) {
self::setLastOrder($country);
}
}
/**
* @param $networkID
* @param $sid
* @return array|null
*/
public static function getFeedInfoByNetworkIdAndSID($networkID, $sid)
{
$feedInfo = SJB_ObjectDBManager::getObjectInfo($networkID . "_feeds", $sid);
if (!empty($feedInfo)) {
$feedInfo['id'] = $feedInfo['sid'];
return $feedInfo;
}
return null;
}
/**
* @param SJB_State $state
*/
public static function saveState(SJB_State $state)
{
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_FIELDS));
$stateSID = $state->getSID();
SJB_ObjectDBManager::saveObject('states', $state);
if (!$stateSID) {
self::setLastOrder($state);
}
}
public static function getCommentsInfoBySIDCollection($sid_collection)
{
$comments = array();
foreach ($sid_collection as $comment_sid) {
$comment = parent::getObjectInfo("comments", $comment_sid);
$comment['id'] = $comment['sid'];
$comments[] = $comment;
}
return $comments;
}
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 getSubAdminInfoBySID($user_sid)
{
return parent::getObjectInfo("subadmins", $user_sid);
}
public static function saveAdminDetails($admin)
{
parent::saveObject('administrator', $admin);
}
public static function deleteAlphabetBySID($ABSsid)
{
return SJB_ObjectDBManager::deleteObjectInfoFromDB("alphabet", $ABSsid);
}
public function update()
{
return SJB_ObjectDBManager::saveObject($this->db_table_name, $this);
}
public static function deleteCurrencyBySID($currency_sid)
{
return parent::deleteObjectInfoFromDB('currency', $currency_sid);
}
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 deleteArticleBySID($articleSid)
{
parent::deleteObjectInfoFromDB('news', $articleSid);
}
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 recordPaymentLog($status, $gateway_caption, $gateway_response)
{
$obj = new SJB_PaymentLog(array('date' => SJB_I18N::getInstance()->getDate(date('Y-m-d H:i:s')), 'gateway' => $gateway_caption, 'message' => print_r($gateway_response, true), 'status' => $status));
SJB_ObjectDBManager::saveObject("payment_log", $obj);
}
public static function deleteProductBySID($productSID)
{
SJB_ShoppingCart::deleteItemsFromCartByProductSID($productSID);
return SJB_ObjectDBManager::deleteObjectInfoFromDB('products', $productSID);
}
public static function deleteObject($db_table_name, $object_sid)
{
return SJB_ObjectDBManager::deleteObject($db_table_name, $object_sid);
}
public static function getEmailInfoBySID($email_sid)
{
return SJB_ObjectDBManager::getObjectInfo("email_log", $email_sid);
}
public static function deleteListingTypeBySID($listing_type_sid)
{
return parent::deleteObjectInfoFromDB("listing_types", $listing_type_sid);
}
public static function getUserInfoBySID($user_sid)
{
return parent::getObjectInfo("users", $user_sid);
}
public static function getFieldInfoBySID($sid)
{
return SJB_ObjectDBManager::getObjectInfo('polls', $sid);
}
public static function getUserGroupNameBySID($user_group_sid)
{
$user_group_info = parent::getObjectInfo("user_groups", $user_group_sid);
return $user_group_info['name'];
}
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());
}
}
public static function getUserProfileFieldInfoByID($user_field_id)
{
$cache = SJB_Cache::getInstance();
$cacheId = md5('SJB_UserProfileFieldManager::getUserProfileFieldInfoByID' . $user_field_id);
if ($cache->test($cacheId)) {
return $cache->load($cacheId);
}
$result = null;
$sid = self::getUserProfileFieldsValue($user_field_id, 'id');
if (!empty($sid)) {
$user_field_sid = $sid[0]['sid'];
$result = SJB_ObjectDBManager::getObjectInfo('user_profile_fields', $user_field_sid);
}
$cache->save($result, $cacheId, array(SJB_Cache::TAG_FIELDS));
return $result;
}
public static function getTaxInfoBySID($sid)
{
return SJB_ObjectDBManager::getObjectInfo('taxes', $sid);
}
public static function getCodeInfoBySID($sid)
{
$code_info = SJB_ObjectDBManager::getObjectInfo('promotions', $sid);
return $code_info;
}
public static function savePage($info)
{
parent::saveObject('posting_pages', $info);
if ($info->getOrder()) {
return true;
}
$max_order = SJB_DB::queryValue('SELECT MAX(`order`) FROM posting_pages WHERE listing_type_sid = ?n', $info->getListingTypeSID());
$max_order = empty($max_order) ? 0 : $max_order;
return SJB_DB::query('UPDATE posting_pages SET listing_type_sid = ?n, `order` = ?n WHERE sid = ?n', $info->getListingTypeSID(), ++$max_order, $info->getSID());
}
