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()); }