/** * Изменение позиции пользователя. * * @param integer $user uid пользователя * @param integer $transaction_id id транзакции * @param array $bids массив, в котором индекс элементов - id места размещения, значения - сумма для поднятия позиции * * @return integer id операции транзакции */ public function BidPlaces($user, $transaction_id, $bids, &$error) { $bill_id = 0; if ($bids) { foreach ($bids as $prof => $sum) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/account.php'; $account = new account(); $error = $account->Buy($bill_id, $transaction_id, 21, $user, $prof, '', $sum, 0); if ($error !== 0) { return 0; } global $DB; $sql = 'UPDATE users_first_page SET psum=psum+? WHERE id IN (SELECT id FROM users_first_page WHERE user_id = ? AND from_date+to_date >= now() AND payed=true AND ordered = true AND profession=? )'; $DB->query($sql, $sum, $user, $prof); $id = 1; } } if ($bill_id) { //$account->commit_transaction($transaction_id, $user, $bill_id); $memBuff = new memBuff(); $memBuff->flushGroup('firstpg'); } return $id; }
/** * Создание нового предложения * * @param array $create Переменная типа array(name=>value) где name - поле таблицы, value - значение для записи (@see Таблица freelance_offers) * @return boolean|string */ public function Create($create) { global $DB; $uid = $create['user_id']; if ($_SESSION['uid'] == $uid && !is_emp()) { $account = new account(); $transaction_id = $account->start_transaction($uid, $tr_id); $error = $account->Buy($billing_id, $transaction_id, self::FM_OP_CODE, $uid, "Покупка публикации предложения фрилансера", "Покупка публикации предложения", 1, 0); if ($error) { return $error; } $account->commit_transaction($transaction_id, $uid, $billing_id); $create['bill_id'] = $billing_id; $create['moderator_status'] = is_pro() ? NULL : 0; $id_offer = $DB->insert('freelance_offers', $create, 'id'); if ($id_offer > 0) { if (!is_pro()) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/stop_words.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/user_content.php'; $stop_words = new stop_words(); $nStopWordsCnt = $stop_words->calculate($fields['descr'], $fields['title']); $DB->insert('moderation', array('rec_id' => $id_offer, 'rec_type' => user_content::MODER_SDELAU, 'stop_words_cnt' => $nStopWordsCnt)); } return $id_offer; } return false; } else { return false; } }
/** * Изменение логина юзера. Перед вызовом необходимо проинициализировать члены класса * old_login, new_login, save_old. * * @param string $error возвращает сообщение об ошибке * * @return 0 * * @see classes/db_access#Add($error, $return_id) */ public function Add(&$error) { global $DB; require_once ABS_PATH . '/classes/users.php'; $user = new users(); $this->user_id = $user->GetUid($error, $this->old_login); if (!$this->user_id) { $error = 'Пользователь не найден!'; return 0; } $new_user = $user->GetUid($error, $this->new_login); if ($new_user) { $error = 'Логин занят!'; return 0; } if ($this->save_old) { require_once ABS_PATH . '/classes/users_old.php'; require_once ABS_PATH . '/classes/account.php'; $account = new account(); $tr_id = $account->start_transaction($this->user_id); $id = 0; $error = $account->Buy($id, $tr_id, self::OP_CODE, $this->user_id, 'Изменеие логина', 'Изменение логина'); if ($error) { return 0; } $this->operation_id = $id; $users_old = new users_old(); $users_old->Add($this->old_login); } if (!$error) { $aData = array('user_id' => '', 'old_login' => '', 'new_login' => '', 'save_old' => '', 'operation_id' => ''); foreach ($aData as $key => $val) { $aData[$key] = $this->{$key}; } $CFile = new CFile(); if (!$CFile->MoveDir($this->new_login, $this->old_login)) { $error = "Директория не создана! {$this->new_login}, {$this->old_login}"; if ($this->operation_id) { $account->Del($this->user_id, $this->operation_id); } } else { $DB->insert('login_change', $aData); $user->login = $this->new_login; $user->Update($this->user_id, $res); } } return 0; }
/** * Функция оплаты акции. * * @global object $DB база данных * * @param int $transaction_id ИД транзакции сделки * @param int $user_id ИД пользователя * * @return int */ public function setPayed($transaction_id, $user_id) { global $DB; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/account.php'; $account = new account(); if (is_emp($_SESSION['role'])) { return 0; } $bill_id = 0; $error = $account->Buy($bill_id, $transaction_id, $this->getConst_OP_CODE(), $user_id, $this->title, $this->descr, $this->getConst_PAYED_SUM(), 0); if ($error !== 0) { return 0; } if ($bill_id) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/pay_place.php'; $pay_place = new pay_place(1); $account->commit_transaction($transaction_id, $user_id, $bill_id); $this->setUserPro($user_id, $bill_id); $pay_place->addUserTop($user_id); return $bill_id; } return 0; }
/** * Сохранение предложения по проектам * * @param object $objResponse xajaxResponse * @param string $rec_id идентификатор записи * @param string $rec_type тип записи * @param array $aForm массив данных * @param string $sDrawFunc имя функции для выполнения после сохранения */ function _admEditPrjOfferSaveForm(&$objResponse, $rec_id = '', $rec_type = '', $aForm = array(), $sDrawFunc = '') { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/messages.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/user_content.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/projects_offers.php'; $obj_offer = new projects_offers(); $payed_items = $aForm['ps_payed_items']; $payed_color = $aForm['ps_payed_items'][0] == '1'; if ($aForm['is_color'] && !$payed_color) { $account = new account(); $transaction_id = $account->start_transaction(get_uid()); $error_buy = $account->Buy($billing_id, $transaction_id, $answers->color_op_code, get_uid(), "Выделение ответа на проект цветом", "Выделение <a href='" . getFriendlyURL("project", $project['id']) . "#freelancer_{$_SESSION['uid']}' target='_blank'>предложения</a> цветом", 1, 1); $payed_items = '1'; if ($error_buy) { $aForm['is_color'] = false; $payed_items = '0'; } } $sReason = _parseReason($aForm['user_id'], $aForm['adm_edit_text']); $error = $obj_offer->AddOffer($aForm['user_id'], $aForm['pid'], $aForm['ps_cost_from'], $aForm['ps_cost_to'], $aForm['ps_cost_type'], $aForm['ps_time_from'], $aForm['ps_time_to'], $aForm['ps_time_type'], antispam(stripslashes($aForm['ps_text'])), $aForm['ps_work_1_id'], $aForm['ps_work_2_id'], $aForm['ps_work_3_id'], $aForm['ps_work_1_link'], $aForm['ps_work_2_link'], $aForm['ps_work_3_link'], $aForm['ps_work_1_name'], $aForm['ps_work_2_name'], $aForm['ps_work_3_name'], $aForm['ps_work_1_pict'], $aForm['ps_work_2_pict'], $aForm['ps_work_3_pict'], $aForm['ps_work_1_prev_pict'], $aForm['ps_work_2_prev_pict'], $aForm['ps_work_3_prev_pict'], isset($aForm['ps_for_customer_only']), $aForm['edit'], 0, isset($aForm['prefer_sbr']), $aForm['is_color'], null, $payed_items, 0, $_SESSION['uid'], $sReason); if (!$error && !$error_buy && !$payed_color && $account) { $account->commit_transaction($transaction_id, get_uid(), $billing_id); $is_payed_color = true; } if ($error) { $objResponse->alert('Ошибка сохранения предложения' . $error); $sParent = $sDrawFunc == 'stream0' || $sDrawFunc == 'stream1' || $sDrawFunc == 'stream2' ? 'parent.' : ''; $objResponse->script("{$sParent}adm_edit_content.disabled = false; {$sParent}adm_edit_content.button();"); } else { messages::prjOfferModifiedNotification($aForm['user_id'], $aForm['pid'], $sReason); $content_id = user_content::MODER_PRJ_OFFERS; _admEditAfterAll($objResponse, $content_id, $rec_id, $rec_type, $sDrawFunc, $aForm); } }
/** * Обработка и оплата операций * * @global type $DB * @param type $option * @return boolean */ function billingOperation($option, $transaction_id) { global $DB; $ok = false; $account = new account(); switch ($option['op_code']) { // Аккаунт ПРО у фрилансера case 48: case 49: case 50: case 51: case 76: // Удаляем операции по покупке ответов - публикуем ответы $prof = new payed(); $ok = $prof->SetOrderedTarif($this->uid, $transaction_id, 1, "Аккаунт PRO", $option['op_code'], $error); if ($ok) { $_SESSION['pro_last'] = payed::ProLast($_SESSION['login']); $_SESSION['pro_last'] = $_SESSION['pro_last']['freeze_to'] ? false : $_SESSION['pro_last']['cnt']; $userdata = new users(); $_SESSION['pro_test'] = $userdata->GetField($this->uid, $error2, 'is_pro_test', false); $this->clearBlockedOperations(step_freelancer::OFFERS_OP_CODE); $step_frl = new step_freelancer(); $offers = $step_frl->getWizardOffers($this->uid, 'all', false); if ($offers) { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/users.php"; $step_frl->log = $this->log; $step_frl->user = new users(); $step_frl->user->GetUserByUID($this->uid); $step_frl->transferOffers($offers); } $this->showProjectsFeedbacks(); } break; // Аккаунт ПРО у работодателя // Аккаунт ПРО у работодателя case 15: $prof = new payed(); $ok = $prof->SetOrderedTarif($this->uid, $transaction_id, 1, "Аккаунт PRO", $option['op_code'], $error); if ($ok) { $_SESSION['pro_last'] = payed::ProLast($_SESSION['login']); $_SESSION['pro_last'] = $_SESSION['pro_last']['freeze_to'] ? false : $_SESSION['pro_last']['cnt']; $userdata = new users(); $_SESSION['pro_test'] = $userdata->GetField($this->uid, $error2, 'is_pro_test', false); } // Обновляем выбор цвета для проектов тк он для ПРО бесплатный $colorProjects = $this->updateColorProject(); $prj = new new_projects(); foreach ($colorProjects as $k => $project) { $delete_color[] = $project['op_id']; if ($project['country'] == null) { $project['country'] = 'null'; } if ($project['city'] == null) { $project['city'] = 'null'; } $project['name'] = addslashes($project['name']); $project['descr'] = addslashes($project['descr']); if ($project['logo_id'] <= 0) { $project['logo_id'] = 'null'; } $project['payed_items'] = $project['payed_items'] | '010'; $project['is_color'] = 't'; $prj->editPrj($project, false); } // Удаляем данные операции if ($delete_color) { $this->deleteDraftAccountOperation($delete_color); } break; // Публикация конкурса // Публикация конкурса case new_projects::OPCODE_KON: case new_projects::OPCODE_KON_NOPRO: require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/wizard/step_wizard_registration.php'; $drafts = new drafts(); $draft = $drafts->getDraft($option['parent_id'], $this->uid, 1); // Если еще не опубликован if (!$draft['prj_id']) { $project_id = $draft['id']; $error = $account->Buy($bill_id, $transaction_id, $option['op_code'], $this->uid, $option['descr'], $option['comment'], 1, 0); $ok = $bill_id > 0; if ($bill_id) { $color = $DB->val("SELECT id FROM draft_account_operations WHERE parent_id = ? AND op_type = 'contest' AND option = 'color' AND uid = ?", $project_id, wizard::getUserIDReg()); $draft['billing_id'] = $bill_id; $draft['folder_id'] = 'null'; $draft['payed'] = '0'; $draft['payed_items'] = '000'; if (is_pro() && $color > 0) { $draft['is_color'] = 't'; } else { $draft['is_color'] = 'f'; } $draft['win_date'] = date('d-m-Y', strtotime($draft['win_date'])); $draft['end_date'] = date('d-m-Y', strtotime($draft['end_date'])); $draft['is_bold'] = 'f'; $draft['user_id'] = $this->uid; if ($draft['country'] == null) { $draft['country'] = 'null'; } if ($draft['city'] == null) { $draft['city'] = 'null'; } $draft['name'] = addslashes($draft['name']); $draft['descr'] = addslashes($draft['descr']); if ($draft['logo_id'] <= 0) { $draft['logo_id'] = 'null'; } $prj = new new_projects(); $attachedfiles_tmpdraft_files = drafts::getAttachedFiles($option['parent_id'], 4); if ($attachedfiles_tmpdraft_files) { $attachedfiles_tmpdraft_files = array_map(create_function('$a', 'return array("id" => $a);'), $attachedfiles_tmpdraft_files); } if ($attachedfiles_tmpdraft_files) { $month = date('Ym'); $dir = 'projects/upload/' . $month . '/'; $files = step_wizard_registration::transferFiles($attachedfiles_tmpdraft_files, 'file_projects', $dir); } $spec = $draft["categories"]; $spec = explode("|", $spec); $spec = array(array('category_id' => $spec[0], 'subcategory_id' => $spec[1])); $prj->addPrj($draft, $files); $prj->saveSpecs($draft["id"], $spec); // смотрим были ли выбраны платные опции для опубликованного конкурса if ($draft['id'] != $project_id && $draft['id'] > 0) { if ($this->sleep[$project_id]) { foreach ($this->sleep[$project_id] as $k => $opt) { $opt['parent_id'] = $draft['id']; $this->billingOperation($opt); } } else { //Обновляем родителя на всякий случай $update = array("parent_id" => $draft['id']); $DB->update("draft_account_operations", $update, "parent_id = ? AND op_type = 'contest' AND uid = ?", $project_id, wizard::getUserIDReg()); $this->sleep_parent[$project_id] = $draft['id']; } $DB->update("draft_projects", array('prj_id' => $draft['id']), "id = ? AND uid = ?", $project_id, wizard::getUserIDReg()); } } } break; // Платный проект/конкурс // Платный проект/конкурс case 53: $prj = new new_projects(); if ($this->sleep_parent[$option['parent_id']]) { $option['parent_id'] = $this->sleep_parent[$option['parent_id']]; } $project = $prj->getProject($option['parent_id']); if (!$project['id']) { $this->sleep[$option['parent_id']][$option['id']] = $option; return true; } else { unset($this->sleep[$option['parent_id']]); } if ($project['country'] == null) { $project['country'] = 'null'; } if ($project['city'] == null) { $project['city'] = 'null'; } $project['name'] = addslashes($project['name']); $project['descr'] = addslashes($project['descr']); if ($project['logo_id'] <= 0) { $project['logo_id'] = 'null'; } $project['folder_id'] = 'null'; $items = array(); switch ($option['option']) { case 'top': $project['top_days'] = $option['op_count']; break; case 'color': $is_pay = $project['payed_items'] & '010'; if ($is_pay != '010') { $project['payed_items'] = $project['payed_items'] | '010'; $project['is_color'] = 't'; $items['color'] = true; if (is_pro()) { $is_payed = true; $prj->SavePayedInfo($items, $project['id'], null, $project['top_days']); $prj->editPrj($project, false); } } else { $is_payed = true; } break; case 'bold': $is_pay = $project['payed_items'] & '001'; if ($is_pay != '001') { $project['payed_items'] = $project['payed_items'] | '001'; $project['is_bold'] = 't'; $items['bold'] = true; } else { $is_payed = true; } break; case 'logo': $is_pay = $project['payed_items'] & '100'; if ($is_pay != '100') { $key = md5(microtime()); $prj = new tmp_project($key); $prj->init(1); $fu = new CFile($option['src_id']); $ext = $fu->getext(); $tmp_dir = $prj->getDstAbsDir(); $tmp_name = $fu->secure_tmpname($tmp_dir, '.' . $ext); $tmp_name = substr_replace($tmp_name, "", 0, strlen($tmp_dir)); $fu->table = 'file_projects'; $r = $fu->_remoteCopy($tmp_dir . $tmp_name); $project['payed_items'] = $project['payed_items'] | '100'; $project['logo_id'] = $fu->id; $items['logo'] = true; if ($option['extra']) { $project['link'] = $option['extra']; } } else { $is_payed = true; } break; } if (!$is_payed) { $error = $account->Buy($bill_id, $transaction_id, $option['op_code'], $this->uid, $option['descr'], $option['comment'], $option['ammount'], 0); $ok = $bill_id > 0; $project['billing_id'] = $bill_id; $prj->SavePayedInfo($items, $project['id'], $bill_id, $project['top_days']); $prj->editPrj($project, false); } else { $ok = true; } break; // Платные ответы на проекты // Платные ответы на проекты case 61: $answers = new projects_offers_answers(); $error = $answers->BuyByFM($this->uid, $option['op_count'], $transaction_id, 0); if (!$error) { $ok = true; $_SESSION['answers_ammount'] = $option['op_count']; // Публикуем ответы $step_frl = new step_freelancer(); $offers = $step_frl->getWizardOffers($this->uid, $option['op_count']); if ($offers) { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/users.php"; $step_frl->log = $this->log; $step_frl->user = new users(); $step_frl->user->GetUserByUID($this->uid); $step_frl->transferOffers($offers); } } break; } return $ok; }
/** * Сохраняет временный проект в базу. * * @param integer $buyer_id ид. юзера-покупателя проекта. Если указан, то проект будет куплен за его счет (например, для админов). * @param mixed &$proj сюда сохранится информация о проекте после его сохранения * @return integer|string 0 в случае успешной покупки или текст ошибки. */ function saveProject($buyer_id = NULL, &$proj, $promo_codes = array()) { $price = 0; // Если проект новый добаляется, то надо отослать уведомление if (!$this->isEdit()) { $need_send_email = true; } else { $need_send_email = false; } $operations = array(); if ($ammount = $this->getAmmount()) { $buyer_id = $buyer_id ? $buyer_id : $this->_uid; $account = new account(); if (!$account->GetInfo($buyer_id, true)) { return 'Ошибка в получении информации по счету.'; } $is_pro = is_pro(true, $this->_project["user_id"]); $price = $this->getPrice($items); if ($this->isKonkurs()) { if ($items['contest']) { $operations['contest'] = array('op_code' => $is_pro ? self::OPCODE_KON : self::OPCODE_KON_NOPRO, 'op_code_bns' => $is_pro ? self::OPCODE_KON_BNS : self::OPCODE_KON_BNS_NOPRO, 'ammount' => 1, 'comment' => $this->getOperationComment('contest')); } } if ($this->isVacancy()) { if ($items['office']) { $operations['office'] = array('op_code' => $this->getVacancyOpCode(), 'op_code_bns' => self::OPCODE_PAYED_BNS, 'ammount' => 1, 'comment' => $this->getOperationComment('office')); } } $services = array('top', 'logo', 'urgent', 'hide'); foreach ($services as $service) { if ($items[$service]) { $operations[$service] = array('op_code' => self::getOpCodeByService($service), 'ammount' => $items[$service], 'comment' => $this->getOperationComment($service)); } } foreach ($operations as $service => $operation) { $bill_id = 0; $this->_transactionId = $account->start_transaction($buyer_id, $this->_transactionId); if (!isset($operation['op_code_bns'])) { $operation['op_code_bns'] = $operation['op_code']; } $descr = trim($operation['comment'], '&'); if ($this->_project['billing_id']) { $descr .= ' - дополнение к операции #' . $this->_project['billing_id']; } if ($account->bonus_sum >= $price) { $error = $account->BuyFromBonus($bill_id, $this->_transactionId, $operation['op_code_bns'], $buyer_id, "{$descr} за счет подарка", "{$operation['comment']} за счет подарка", $operation['ammount'], true); if ($error) { return $error; } } else { $error = $account->Buy($bill_id, $this->_transactionId, $operation['op_code'], $buyer_id, $descr, $operation['comment'], $operation['ammount'], 0, isset($promo_codes[$service]) ? $promo_codes[$service] : 0); if ($error) { return $error; } } if (!$bill_id) { return 'Не хватает денег. ' . $account->sum . ' из ' . $price; } $this->account_operation_id = $bill_id; $operations[$service]['bill_id'] = $bill_id; } } $prePrj = $this->_preDb($price, $bill_id); $success = $this->isEdit() ? $this->editPrj($this->_project, $this->_attach, array_reverse($this->getCategories())) : $this->addPrj($this->_project, $this->_attach, array_reverse($this->_categories)); if (!$this->isEdit()) { foreach ($operations as $service => $operation) { $account->updateComment($this->getOperationComment($service), $operation['bill_id'], array($operation['op_code'], $operation['op_code_bns'])); } } $proj = $this->_project; if (!$success) { $this->_postDbFailed($prePrj, $bill_id, $buyer_id); return $error ? $error : 'Error'; } $this->SavePayedInfo($items, $this->_project['id'], $bill_id, $topDays ? $topDays : 1); $this->_postDbSuccess(); if (!$_SESSION['quickprjbuy_ok_id']) { $_SESSION['quickprjbuy_ok_id'] = $this->_project['id']; } return 0; }
/** * Поднимаем рейтиинг * * @param integer $fid ИД Кому поднимаем * @param integer $transaction_id ИД Транзакции * @param integer $time Время * @param string $comments Дополнительный комментарий * @param integer $tarif Тариф * @param integer $ammount Kоличество товара * @param integer $commit Завершать ли транзакцию после этой операции. * @return unknown */ function getUpRating($fid, $sum, $transaction_id, $time, $comments = "Поднятие рейтинга за FM", $tarif = 75, $ammount = 1, $commit = 1) { require_once ABS_PATH . "/classes/account.php"; $account = new account(); $error = $account->Buy($bill_id, $transaction_id, $tarif, $fid, $comments, $comments, $ammount, $commit); if ($error !== 0) { return 1; } return 0; }
/** * Обновляет дату объявления, поднимая на первое место * @param type $uid * @param type $prof_id * @param type $from_buffer */ public static function moveTop($uid, $prof_id, $is_group, $transaction_id, $from_buffer = false, $psum = 0, $op_code, $promo = 0) { $success = false; $prof_name = self::getOperationDescr($is_group ? 0 : $prof_id, $is_group ? $prof_id : 0); require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/account.php"; $account = new account(); $ok = $account->Buy($id, $transaction_id, $op_code, $uid, "Перемещение наверх размещения в {$prof_name} каталога фрилансеров и услуг", $from_buffer ? 'оплата из буфера' : '', 1, 1, $promo); if ($ok === 0) { global $DB; $data = array('first_post' => 'NOW()', 'skip_psum' => true, 'sent_up' => false); if ($from_buffer) { $data['psum'] = $psum; } $tarif_case = $is_group ? 'AND tarif = 19' : ''; $success = $DB->update('users_first_page', $data, "user_id = ?i AND profession = ?i {$tarif_case}", $uid, $prof_id); } $memBuff = new memBuff(); $memBuff->flushGroup("firstpg"); unset($_SESSION['payed_frl']); return $success; }
/** * Продляет специализации по ID пользователя * * @param integer $uid ID пользователя * @param boolean $is_autopaid Учитывать только отмеченные для автопродления * @param string $period Период продления * @param boolean $prolong_only * @return string Сообщение об ошибке если есть */ function prolongSpecs($uid, $is_autopaid = false, $period = '1 mon', $prolong_only = false) { global $DB; return; // #0022795 require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/account.php"; $account = new account(); $specs = self::getPaidSpecs($uid, true, $is_autopaid, $prolong_only); if (!$specs) { return 'Нет специализаций'; } $transaction_id = $account->start_transaction($uid); $billing_id = NULL; $sum = 0; foreach ($specs as $i => $spec) { $DB->start(); $sql = "UPDATE spec_paid_choise SET paid_to = paid_to + '{$period}'::interval\n WHERE id = {$spec['id']} AND user_id = {$uid} RETURNING paid_to, (paid_to - '{$period}'::interval) as paid_from"; if ($res = $DB->query($sql)) { $paid_to = pg_fetch_result($res, 0, 0); $paid_from = pg_fetch_result($res, 0, 1); $descr = 'Продление "' . $spec['name'] . '" до ' . date('d.m.Y', strtotime($paid_to)); if ($error = $account->Buy($bill_id, $transaction_id, self::OP_PAID_SPEC, $uid, $descr, $descr, 1, 0)) { $DB->rollback(); break; } if ($DB->commit()) { $billing_id = $bill_id; $sum++; $sql = "INSERT INTO spec_paid_acc_operations (billing_id, paid_from, paid_to)\n VALUES ({$bill_id}, '{$paid_from}'::timestamp, '{$paid_to}'::timestamp)"; $rs = $DB->query($sql); } } } if ($billing_id) { $account->commit_transaction($transaction_id, $uid, $billing_id); require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/smail.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/op_codes.php"; $mail = new smail(); $ops = new op_codes(); $price = $ops->getCodes(self::OP_PAID_SPEC); if ($price) { $price = $price[self::OP_PAID_SPEC]; $mail->PaidSpecsAutopayed($uid, $sum * $price['sum']); } } return $error; }
public function paidOperation($id) { global $DB; if (!$id) { return false; } require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/projects.php'; $operation = $DB->row('SELECT * FROM draft_account_operations WHERE id = ? AND status IS NULL', $id); $account = new account(); $this->_transactionId = $account->start_transaction($_SESSION['uid'], $this->_transactionId); switch ($operation['op_type']) { case 'project': $project = $DB->row('SELECT id, payed_info FROM projects WHERE id = ?i', $operation['parent']); if (!$project['id']) { return 'Ошибка обработки операции.'; } if ($account->sum >= $operation['ammount']) { if ($error = $account->Buy($bill_id, $this->_transactionId, $operation['op_code'], $_SESSION['uid'], trim($operations['descr'], '/'), trim($operations['comments'], '/'), 1, true)) { return $error; } } if (!$bill_id) { return 'Не хватает денег.'; } $update = array(); switch ($operation['option']) { case 'color': $update['is_color'] = true; $update['payed_items'] = $project['payed_info'] | '010'; break; case 'bold': $update['is_bold'] = true; $update['payed_items'] = $project['payed_info'] | '001'; break; case 'top': $update['top_from'] = date('d.m.Y H:i', strtotime('now')); $update['top_to'] = date('d.m.Y H:i', strtotime("now +{$operation['op_count']} day")); break; case 'logo': $update['logo_id'] = $operation['src_id']; $update['payed_items'] = $project['payed_info'] | '100'; break; } $update['billing_id'] = $bill_id; $DB->update('projects', $update, 'id = ?', $operation['parent']); header('Location: /bill/success/'); exit; break; case 'contest': // Публикация конкурса if ($account->sum >= $operation['ammount']) { if ($error = $account->Buy($bill_id, $this->_transactionId, $operation['op_code'], $_SESSION['uid'], trim($operations['descr'], '/'), trim($operations['comments'], '/'), 1, true)) { return $error; } } if (!$bill_id) { return 'Не хватает денег.'; } $key = md5(microtime()); $prj = new tmp_project($key); if (get_uid()) { $prj->init(1); } $draft = new drafts(); $project = $drafts->getDraft($operation['parent'], $_SESSION['uid'], 1); require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/attachedfiles.php'; $attachedfiles = new attachedfiles(); $attachedfiles_tmpdraft_files = drafts::getAttachedFiles($operation['parent'], 4); if ($attachedfiles_tmpdraft_files) { $attachedfiles_prj_files = array(); foreach ($attachedfiles_tmpdraft_files as $attachedfiles_draft_file) { $attachedfiles_draft_files[] = $attachedfiles_draft_file; } $attachedfiles->setFiles($attachedfiles_draft_files, 1); } $insert = array('user_id' => $_SESSION['uid'], 'name' => $project['name'], 'descr' => $project['descr'], 'kind' => $project['kind'], 'cost' => $project['cost'], 'currency' => $project['currency'], 'country' => $project['country'] > 0 ? $project['country'] : 'NULL', 'city' => $project['city'] > 0 ? $project['city'] : 'NULL', 'payed' => '0', 'pro_only' => $project['pro_only'], 'logo_id' => 'NULL', 'link' => $project['logo_link'], 'is_color' => 'f', 'is_bold' => 'f', 'billing_id' => 0, 'payed_items' => '000', 'folder_id' => 0, 'budget_type' => $project['budget_type'], 'priceby' => $project['priceby'], 'prefer_sbr' => $project['prefer_sbr'], 'end_date' => $project['p_end_date'], 'win_date' => $project['p_win_date']); if (!empty($project['categories'])) { $cat = explode('|', $project['categories']); $categories[0] = array('category_id' => intval($cat[0]), 'subcategory_id' => intval($cat[1])); } $create = $prj->addPrj($insert, $attachedfiles_draft_files, $categories); // Добавляем проект if ($create) { $drafts->DeleteDraft($draft_id, $uid, 1); header('Location: /bill/success/'); exit; } break; case 'account': // Покупка ПРО break; } }
/** * Возврат ответов в случае блокировки проекта. * * @param int $project_id - ID проекта * * @return mixed - сообщение об ошибке или 0 в случае успеха */ public function ReturnAnswers($project_id) { global $DB; $descr = 'Возврат ответа на проект в связи с блокировкой проекта'; $op_code = $this->return_op_code; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/projects_offers.php'; $of = new projects_offers(); $offers = $of->GetPrjOffers($count, $project_id, 'ALL', 0, 0, true); if (!$count) { return; } require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/account.php'; $account = new account(); foreach ($offers as $offer) { $uid = $offer['user_id']; if ($offer['type'] == 0) { continue; } $transaction_id = $account->start_transaction($uid); $error = $account->Buy($billing_id, $transaction_id, $op_code, $uid, $descr, $descr, 0, 0); if ($error) { return $error; } if ($offer['type'] == 2) { $DB->query('UPDATE projects_offers_answers SET pay_offers = pay_offers + 1 WHERE uid = ?', $uid); } else { $free_cnt = self::FREE_ANSWERS_CNT; $DB->query("UPDATE projects_offers_answers \n SET free_offers = free_offers + (CASE WHEN free_offers < {$free_cnt} THEN 1 ELSE 0 END) WHERE uid = ?", $uid); } $account->commit_transaction($transaction_id, $uid, $billing_id); } }
header('Location: ' . getFriendlyURL('project', $project['id']) . '?' . intval($project['id']) . $from_prm_s); } } break; case 'buy': if (!($error = $answers->BuyByFM($_SESSION['uid'], $_POST['ammount']))) { header('Location: ' . getFriendlyURL('project', $project['id'])); exit; } break; case 'payed_is_color': $offer_id = __paramInit('int', null, 'id_offers'); $account = new account(); $transaction_id = $account->start_transaction(get_uid()); $project_id = $obj_offer->getProjectIDByOfferID($offer_id); $error_buy = $account->Buy($billing_id, $transaction_id, $answers->color_op_code, get_uid(), 'Выделение ответа на проект цветом', "Выделение <a href='" . getFriendlyURL('project', $project_id) . "#freelancer_{$_SESSION['uid']}' target='_blank'>ответа на проект</a> цветом", 1, 1); $is_color = 't'; $payed_items = '1'; if ($error_buy) { $is_color = 'f'; $payed_items = '0'; } $fields = array('is_color' => "'{$is_color}'", 'payed_items' => "B'{$payed_items}'"); $error = $obj_offer->setFieldsOffers($offer_id, $fields); if (!$error) { header('Location: /bill/success/'); exit; } else { $error_is_color = 'Ошибка обработки запроса'; } break;
public function payedAdvice($id_advice, $uid, $transaction_id, $tarif, $trs_sum) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/account.php'; $tarif = floatval($tarif); $account = new account(); $link = "<a href='{$GLOBALS['host']}/users/{$_SESSION['login']}/opinions/#p_" . $id_advice * 2 . "' target='_blank'>Рекомендация</a>"; $error = $account->Buy($bill_id, $transaction_id, self::OP_CODE, $uid, 'Оплата рекомендации', $link, $tarif, 0, 0, $trs_sum); if ($error !== 0) { return 0; } if ($bill_id) { $account->commit_transaction($transaction_id, $uid, $bill_id); $this->setPayed($id_advice, $bill_id); return $bill_id; } return 0; }
/** * Покупка места в карусели на главной и странице каталога. * */ private function setCatalogOrMainPageRoundabout() { global $DB; $uid = (int) $_POST['uid']; $row = $DB->row("SELECT role, uname, usurname, login, sum FROM users LEFT JOIN account ON account.uid = users.uid \n WHERE users.uid = {$uid}"); $role = $row['role'][0]; $user = $row['uname'] . ' ' . $row['usurname'] . ' [' . $row['login'] . ']'; $sum = $row['sum']; if ($role !== '0') { $this->jsonError('Пользователь не найден или является работодателем'); } $date = $_POST['date']; $f = preg_match("#[0-9]{4}\\-[0-9]{2}\\-[0-9]{2}#", $date, $m); if (!$f) { $date = false; } if ($uid) { $catalog = $_POST['type'] == 'catalog'; if ($_POST['type'] == 'catalog') { $tarif = 73; } elseif ($_POST['type'] == 'main') { $tarif = 65; } $payPlace = new pay_place($catalog ? 1 : 0); $account = new account(); $transaction_id = $account->start_transaction($uid, $tr_id); if (($buy = $account->Buy($id, $transaction_id, $tarif, $uid, 'Оплата новых платных мест за FM', 'Оплачено', 1)) === 0) { $payPlace->addUser($uid); $t = intval($payPlace->getTimeShow()); $msg = "{$user} будет размещен " . ($catalog ? 'в <a href="/freelancers/">каталоге</a> ' : 'на <a href="/">главной странице</a> ') . ($t == 0 ? 'сейчас' : "через {$t} минут" . ($t == 1 ? 'у' : ($t > 1 && $t < 5 ? 'ы' : ''))) . '.'; $this->jsonOk('msg', $msg); } else { $msg = "В данный момент на счету у {$user} {$sum} FM. <a href=\"/bill\" target=\"_blank\">Пополнить счет</a><br/><br/>"; $this->jsonError($msg); } } }