public function run() { $user = $this->order[$this->is_emp ? 'freelancer' : 'employer']; //получаем общее кол-во отзывов $oplinks = NULL; $opcount = opinions::GetCounts($user['uid'], array('total')); if (array_sum($opcount['total']) > 0) { $oplinks = array('p' => getSortOpinionLinkEx('frl', "total", 1, $user['login'], zin($opcount['total']['p']), null, 0), 'n' => getSortOpinionLinkEx('frl', "total", 2, $user['login'], zin($opcount['total']['n']), null, 0), 'm' => getSortOpinionLinkEx('frl', "total", 3, $user['login'], zin($opcount['total']['m']), null, 0)); } //город юзера $city_id = $this->order['is_meet'] == 't' && $this->order['city'] > 0 ? $this->order['city'] : $user['city']; $user['place_title'] = ''; if ($city_id > 0) { $user['place_title'] = city::getCountryName($city_id) . ', ' . city::getCityName($city_id); } //собираем шаблон $this->render('t-service-order-user-profile', array('user' => $user, 'oplinks' => $oplinks)); }
<?php } $oid = $theme['sbr_id']; //$_next = $is_next; } //endfor ?> <?php if (is_array($msgs2) && count($msgs2)) { $aUser = get_object_vars($user); ?> <?php foreach ($msgs2 as $opinion) { $opcomm = opinions::getCommentOpinionById(array($opinion['id'])); $cls_rating = $opinion['rating'] == 1 ? "b-button_poll_plus" : ($opinion['rating'] == 0 ? " b-button_poll_multi" : "b-button_poll_minus"); ?> <div class="b-post" id="opinion_<?php echo $opinion['id']; ?> "> <a name="o_<?php echo $opinion['id']; ?> "></a> <div class="b-post__body b-post__body_pad_10_15_20" > <div class="b-post__avatar"> <a class="b-post__link" href="/users/<?php echo $opinion['login']; ?>
/** * Обрабатываем данные для ввывода информации по шагу */ public function actionProjects() { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/projects.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/professions.php"; $prj_id = __paramInit('int', 'project', null, 0); if ($prj_id > 0) { $obj_project = new projects(); $project = $obj_project->GetPrjCust($prj_id); } if ($project['id'] > 0) { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/users.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/opinions.php"; // Загружаем данные по отзывам автора проекта $op_data = opinions::getCounts($project['user_id'], array('frl', 'norisk', 'all', 'total')); //$op_data['norisk']['a'] = ( (int)$op_data['norisk']['p'] + (int)$op_data['norisk']['n'] + (int)$op_data['norisk']['m'] ); //$op_data['all']['a'] = ( (int)$op_data['all']['p'] + (int)$op_data['all']['n'] + (int)$op_data['all']['m'] ); $op_data['total']['a'] = (int) $op_data['total']['p'] + (int) $op_data['total']['n'] + (int) $op_data['total']['m']; $user = new users(); $user->GetUserByUID($project['user_id']); $registered = strtolower(ElapsedMnths(strtotime($project['reg_date']))); $is_offer = $this->isOfferProject($project['id']); $count_offer = $this->countOffers(); $count_pay_offer = $this->countPayOffers(); // Максимальное количество ответов для пользователя $max_offers = 3 + $count_pay_offer; // Обработка запросов на странице $action = __paramInit('string', null, 'action'); if ($action && ($count_offer < $max_offers || $project['kind'] == 7 || $action == 'paid_offer')) { $error = $this->actionProcessingProjects($action, $project); } include $_SERVER['DOCUMENT_ROOT'] . "/wizard/registration/steps/tpl.step.answer.php"; } else { $filter = array(); $category = $_COOKIE[$this->parent->getCookieName('categories')]; $subcategory = $_COOKIE[$this->parent->getCookieName('subcategories')]; if ($category > 0) { $cat[] = professions::GetGroupName($category); $filter['active'] = 't'; $filter['my_specs'] = 'f'; $filter['categories'][0] = array($category => '0'); if ($subcategory > 0) { $cat[] = professions::GetProfName($subcategory); unset($filter['categories'][0]); $filter['categories'][1] = array($subcategory => '1'); } $category_name = implode(": ", $cat); } $obj_project = new new_projects(); $obj_project->page_size = step_freelancer::DEF_PROJECTS_PER_PAGE; $projects = $obj_project->getProjects($count, -1, 1, false, $filter, true, false, NULL, true); include $_SERVER['DOCUMENT_ROOT'] . "/wizard/registration/steps/tpl.step.search.php"; } }
<?php define('IS_SITE_ADMIN', 1); $no_banner = 1; $rpath = '../../'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; session_start(); get_uid(); if (!hasPermissions('adm') || !hasPermissions('users')) { header('Location: /404.php'); exit; } $op = new opinions(); if ($_GET['ds']) { $ds = strtotime($_GET['ds']); } if ($_GET['de']) { $de = strtotime($_GET['de']); } if (!$ds) { $ds = mktime(0, 0, 1, date('m'), date('d'), date('Y')); } if (!$de) { $de = mktime(23, 59, 59, date('m'), date('d'), date('Y')); } switch ($_GET['filter']) { case 'pos': $rating = 1; break; case 'neg': $rating = -1;
/** * Дополнительные действия при бане пользователя на всем сайте. * * @param int $uid UID пользователя. */ public function _afterUserBan($uid) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/projects.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/messages.php'; $opinions = new opinions(); $opinions->HideOpin($uid); projects::CloseAllUserPrj($uid); self::banSuspiciousUser($uid); $mess = new messages(); $mess->clearMessageSender($uid); }
<?php if ($activ_tab == 5) { ?> <div id="op_header"> <a name="op_head"></a> <div class="ops-bar"> <ul> <?php echo opinions::view_op_nav_bar($user, __paramInit('string', 'sort', null), $period); ?> </ul> </div> </div> <h2 class="b-layout__title b-layout__title_padtop_10 b-layout__title_padleft_15"><?php echo $opCount . ending($opCount, ' отзыв', ' отзыва', ' отзывов') . ' ' . mb_strtolower($author_filter_string) . ' ' . mb_strtolower($filter_string); ?> </h2> <?php }
/** * Возвращает часть ответа с отзывами о пользователе * * @param array $aData информация о отзывами о пользователе * @return array */ private function _getUserOpinionsData($aData) { require_once ABS_PATH . '/classes/paid_advices.php'; require_once ABS_PATH . '/classes/opinions.php'; require_once ABS_PATH . '/classes/sbr_meta.php'; require_once ABS_PATH . '/classes/sbr.php'; $aReturn = array(); $msgs = sbr::getUserFeedbacks($aData['uid'], is_emp($aData['role']), false, 0, false, false); // рекомендации $msgs2 = opinions::GetMsgs($aData['uid'], null, null, null, $error, 'users', false, 0, 0); // мнения if (is_array($msgs) && $msgs) { foreach ($msgs as $theme) { $oUser = new users(); $oUser->GetUserByUID($theme['fromuser_id']); $taData = array(); $taClassVars = array_keys(get_class_vars('users')); foreach ($taClassVars as $sVar) { $taData[$sVar] = $oUser->{$sVar}; } if (!is_emp($taData['role'])) { require_once ABS_PATH . '/classes/freelancer.php'; $aTmp = freelancer::getFreelancerByLogin(array($taData['login'])); $taData['spec'] = $aTmp[0]['spec']; } $aReturn[] = array("id" => $theme['id'], 'type' => $theme['is_payed'] ? 2 : 1, "from_user_id" => $theme['fromuser_id'], "to_user_id" => $theme['touser_id'], "rate" => $theme['sbr_rating'], "text" => $theme['descr'] ? iconv('cp1251', 'utf-8', $theme['descr']) : '', "status" => 1, "create_time" => strtotime($theme['posted_time']), "update_time" => $theme[''], "user" => $this->_getUserData($taData)); } } if (is_array($msgs2) && $msgs2) { foreach ($msgs2 as $opinion) { $oUser = new users(); $oUser->GetUserByUID($opinion['fromuser_id']); $taData = array(); $taClassVars = array_keys(get_class_vars('users')); foreach ($taClassVars as $sVar) { $taData[$sVar] = $oUser->{$sVar}; } if (!is_emp($taData['role'])) { require_once ABS_PATH . '/classes/freelancer.php'; $aTmp = freelancer::getFreelancerByLogin(array($taData['login'])); $taData['spec'] = $aTmp[0]['spec']; } $aReturn[] = array("id" => $opinion['id'], 'type' => 2, "from_user_id" => $opinion['fromuser_id'], "to_user_id" => $opinion['touser_id'], "rate" => $opinion['rating'], "text" => $opinion['msgtext'] ? iconv('cp1251', 'utf-8', $opinion['msgtext']) : '', "status" => 1, "create_time" => strtotime($opinion['post_time']), "update_time" => $opinion['modified'] ? strtotime($opinion['modified']) : 0, "user" => $this->_getUserData($taData)); } } return $aReturn; }
function EditSBROpForm($op_id, $login) { $op_id = intval($op_id); session_start(); include_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; $objResponse = new xajaxResponse(); $ele_id = 'form_container_' . $op_id; $objResponse->script("\$\$('.editFormSbr').set('html', ' ').setStyle('display', 'none');"); $objResponse->script("\$\$('.sbrmsgblock').setStyle('display', 'block');"); $objResponse->script("\$('form_container_to_{$op_id}').setStyle('display', 'none');"); $objResponse->script("\$('{$ele_id}').setStyle('display', 'block');"); $objResponse->assign($ele_id, 'innerHTML', opinions::getEditSBREditForm($op_id, $login)); return $objResponse; }
/** * Отправляет уведомление о редактировании отзыва. * * @param string|array $ids идентификаторы отзывов * @param resource $connect соединение к БД (необходимо в PgQ) или NULL -- создать новое. * @return integer количество отправленных уведомлений. */ function EditOpinion($ids, $connect = NULL) { require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; $opin = new opinions(0, 0); if (!($opinions = $opin->getNewOpinion($ids, $connect))) { return NULL; } foreach ($opinions as $opinion) { if (!$opinion['t_email'] || substr($opinion['t_subscr'], 3, 1) != '1' || $opinion['t_banned'] == '1') { continue; } // если не нужны уведомления пропускаем отсылку $path = "/users/{$opinion['t_login']}/opinions/?from=" . (substr($opinion['f_role'], 0, 1) == '1' ? 'emp' : 'frl'); if (!$opinion['modified_id'] || $opinion['modified_id'] == $opinion['f_uid']) { // отзыв редактирует автор switch ($opinion['rating']) { case 0: $type_text = "нейтральный"; break; case 1: $type_text = "положительный"; break; case -1: $type_text = "отрицательный"; break; } $body = "Пользователь <a href='{$GLOBALS['host']}/users/{$opinion['f_login']}{$this->_addUrlParams('b')}'>" . $opinion["f_uname"] . " " . $opinion["f_usurname"] . "</a> [<a href='{$GLOBALS['host']}/users/{$opinion['f_login']}{$this->_addUrlParams('b')}'>" . $opinion["f_login"] . "</a>]\nоставил(а) {$type_text} отзыв о вас.<br />\nВы можете прочитать его на странице вашего аккаунта - <a href='{$GLOBALS['host']}{$path}{$this->_addUrlParams('b', '&')}'>" . $GLOBALS["host"] . $path . "</a>"; } else { // отзыв редактирует админ $body = "Модератор отредактировал отзыв по Безопасной Сделке.\n<br />\n<br />\nВы можете прочитать его на странице вашего аккаунта - <a href='{$GLOBALS['host']}{$path}{$this->_addUrlParams('b', '&')}'>" . $GLOBALS["host"] . $path . "</a>"; } $this->message = $this->GetHtml($opinion["t_uname"], $body, array('header' => 'default', 'footer' => 'default'), array('login' => $opinion['t_login'])); $this->from = "FL.ru <*****@*****.**>"; $this->subject = "Редактирование отзыва на FL.ru"; $this->recipient = "{$opinion['t_uname']} {$opinion['t_usurname']} [{$opinion['t_login']}] <" . $opinion['t_email'] . ">"; $this->send('text/html'); } return $this->sended; }
<?php ini_set('display_errors', 0); //error_reporting(E_ALL ^ E_NOTICE); ini_set('max_execution_time', 0); ini_set('memory_limit', '512M'); if (!isset($_SERVER['DOCUMENT_ROOT']) || !strlen($_SERVER['DOCUMENT_ROOT'])) { $_SERVER['DOCUMENT_ROOT'] = rtrim(realpath(pathinfo(__FILE__, PATHINFO_DIRNAME) . '/../../'), '/'); } require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/stdf.php"; //require_once($_SERVER['DOCUMENT_ROOT'] . "/classes/config.php"); //require_once($_SERVER['DOCUMENT_ROOT'] . "/classes/profiler.php"); require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; //------------------------------------------------------------------------------ if (count($argv) > 1) { parse_str(implode('&', array_slice($argv, 1)), $_GET); } //------------------------------------------------------------------------------ $login = @$_GET['login']; $user = new users(); $user->GetUser($login); if ($user->uid > 0) { $result = opinions::GetCounts2($user->uid, array('total')); var_dump($result); } //------------------------------------------------------------------------------ exit;
include "../fbd.php"; exit; } $action = trim($_POST['action']); $tr_id = intval($_REQUEST['transaction_id']); if ($action == 'buy') { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/paid_advices.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/exrates.php"; $exrates = new exrates(); $EXR = $exrates->GetAll(); $paid_advice = new paid_advices(); $id_advice = intval($_POST['id_advice']); $advice = $paid_advice->getAdvice($id_advice); if ((int) $advice['id'] <= 0) { header("Location: /bill/fail/"); exit; } $sum = round($advice['comm_sum'] / $EXR[13], 2); $order_id = $paid_advice->payedAdvice($advice['id'], $advice['user_to'], $tr_id, $sum, $advice['comm_sum']); if ($advice['converted_id'] > 0 && $order_id) { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/opinions.php"; opinions::DeleteMsg($advice['user_from'], $advice['converted_id']); } } if (!$order_id) { header("Location: /bill/fail/"); exit; } else { header("Location: /bill/success/"); exit; }
/** * печатает навигационную панель страницы отзывов * @param users $user объект класса users с данными о пользователе */ static function view_op_nav_bar($user, $sort) { global $filter_string, $author_filter_string, $period, $author, $filterCounts; $opinions = opinions::GetCounts($user->uid, array('total')); $opinionsTotal = $opinions['total']; $opinionsAll = $opinionsTotal['p'] + $opinionsTotal['n'] + $opinionsTotal['m']; $opinionsLink = '/users/' . $user->login . '/opinions/'; $authorFilterLinkParams = "?sort={$sort}&period={$period}"; $periodFilterLinkParams = "?sort={$sort}&author={$author}"; $ratingFilterLinkParams = "?period={$period}&author={$author}"; include $_SERVER['DOCUMENT_ROOT'] . '/user/tpl.op_nav_bar.php'; }
/** * удаляет комментарий к мнению, отзыву. * * @param type $op_id * @param type $comm_id * @param type $from * @param type $isFeedback если true - это отзыв * * @return \xajaxResponse */ function DeleteOpinionComm($op_id, $comm_id, $from = 'frl', $isFeedback = false) { @session_start(); $objResponse = new xajaxResponse(); if ($isFeedback) { $msg = sbr_meta::getFeedback($op_id, true); } else { $msg = opinions::GetMessageById($op_id); } if (get_uid(0) == $msg['touser_id'] || hasPermissions('users')) { $error = opinions::deleteComment($comm_id, get_uid(false), hasPermissions('users'), $isFeedback); } else { $error = 'Вы не можете удалить комментарий.'; } $prefix = $isFeedback ? 'feedback_' : ''; if (!$error) { $objResponse->script("\$('{$prefix}opinion_btn_add_comment_{$op_id}').setStyle('display', ''); \n \$('{$prefix}opinion_btn_add_comment_{$op_id}').setProperty('disabled', '');\n \$('{$prefix}opinion_btn_edit_comment_{$op_id}').setProperty('disabled', '');\n \$('{$prefix}comment_content_{$op_id}').dispose();"); } else { $objResponse->script("alert('{$error}')"); } return $objResponse; }
header("HTTP/1.0 404 Not Found"); exit; } require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/rating.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/professions.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/country.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/city.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/teams.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/sbr.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/opinions.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/payed.php"; global $session; $sbr_info = sbr_meta::getUserInfo($user->uid); //@todo: упростил но это вообще здесь не нужно впринципе см getHeaderData $from = is_emp($user->role) ? 'emp' : 'frl'; $op_data = opinions::getHeaderData($from, $user, $user->uid); if (!$rating || !$rating instanceof rating || $rating->data['user_id'] != $user->uid) { $rating = new rating($user->uid, $user->is_pro, $user->is_verify, $user->is_profi, 1); } $r_data = $rating->data; //$samerank = rating::CountByRank($r_data['rank']); $banblog = $user->GetBan($user->uid, 1); if ($user->birthday && $user->birthday > "1910-01-01") { $user_ago = ElapsedYears(strtotime($user->birthday)); } $info_for_reg = @unserialize($user->info_for_reg); $team = new teams(); // срок окончания ПРО - только для админов if (hasPermissions('users') && $user->is_pro === 't') { $proLast = payed::ProLast($user->login); $proDate = date('d-m-Y в h:i', strtotime($proLast['cnt']));
/** * Шаблон блока фрилансера, находящегося на странице создания/редактирования СБР. * @param object $frl информация о фрилансере. * * @return string html-блок. */ static function view_frl($frl) { global $session; if (!$frl->uid) { return ''; } require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; $frl_link = "/users/{$frl->login}"; $frl_name = $frl->uname . ' ' . $frl->usurname . ' [' . $frl->login . ']'; $sbr_info = self::getUserInfo($frl->uid); $ocnt = opinions::GetCounts($frl->uid, array('norisk', 'emp', 'all')); ob_start(); ?> <a href="<?php echo $frl_link; ?> " target="_blank"><?php echo view_avatar($frl->login, $frl->photo); ?> </a> <div class="user-info"> <div class="user-stat"><?php echo $frl->is_pro == 't' ? view_pro2($frl->is_pro_test == 't') : ''; ?> <?php echo $session->view_online_status($frl->login); ?> <a href="<?php echo $frl_link; ?> " class="freelancer-name" target="_blank"><?php echo $frl_name; ?> </a></div> «Безопасных Сделок»: <?php echo (int) $sbr_info['success_cnt']; ?> <br /> <a href="/users/<?php echo $frl->login; ?> /opinions/?from=norisk#op_head" class="lnk-nr-reviews" target="_blank">Рекомендации работодателей</a>: <a href="<?php echo $frl_link; ?> /opinions/?from=norisk&sort=1#op_head" class="ops-plus" target="_blank">+<?php echo (int) $ocnt['norisk']['p']; ?> </a> / <a href="<?php echo $frl_link; ?> /opinions/?from=norisk&sort=2#op_head" class="ops-neitral" target="_blank"><?php echo (int) $ocnt['norisk']['n']; ?> </a> / <a href="<?php echo $frl_link; ?> /opinions/?from=norisk&sort=3#op_head" class="ops-minus" target="_blank">-<?php echo (int) $ocnt['norisk']['m']; ?> </a> <br/> <a href="<?php echo $frl_link; ?> /opinions/?from=users#op_head" class="lnk-nr-reviews" target="_blank">Мнения пользователей</a>: <a href="<?php echo $frl_link; ?> /opinions/?from=users&sort=1#op_head" class="ops-plus" target="_blank">+<?php echo (int) $ocnt['all']['p']; ?> </a> / <a href="<?php echo $frl_link; ?> /opinions/?from=users&sort=2#op_head" class="ops-neitral" target="_blank"><?php echo (int) $ocnt['all']['n']; ?> </a> / <a href="<?php echo $frl_link; ?> /opinions/?from=users&sort=3#op_head" class="ops-minus" target="_blank">-<?php echo (int) $ocnt['all']['m']; ?> </a> <input type="hidden" name="frl_login_added" value="<?php echo $frl->login; ?> "/> </div> <?php return ob_get_clean(); }
<?php require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/rating.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/xajax/projects_ci.common.php"; $xajax->printJavascript('/xajax/'); require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/project_exrates.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/HTML/projects_lenta.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/opinions.php"; // Подгружаем данные по мнения создалю проекта $op_data = opinions::getCounts($project['user_id'], array('frl', 'norisk', 'all', 'total')); $project_exRates = project_exrates::GetAll(); $exch = array(1 => 'FM', 'USD', 'Euro', 'Руб'); $translate_exRates = array(0 => 2, 1 => 3, 2 => 4, 3 => 1); $foto_alt = $project['name']; $answer_button_href = get_uid(FALSE) ? is_emp($_SESSION['role']) ? "/frl_only.php" : ($project['pro_only'] == 't' && !$is_pro && $project['user_id'] != $_SESSION['uid'] && !hasPermissions('projects') ? "/payed/" : "#new_offer") : "/registration/?from_prj=" . $project['id']; $category = professions::GetGroup($project['category'], $eeee); if ($category['name'] && $project['subcategory']) { $category['name'] .= ' / ' . professions::GetProfName($project['subcategory']); } $can_edit = !!is_numeric(InGet('edit')) && $user_offer['refused'] != 't'; $is_user_offer_exist = (!$user_offer_exist || $can_edit) && $project['closed'] != 't' && $uid > 0; if ($project['pro_only'] == 't' && !$is_pro && $project['user_id'] != $_SESSION['uid'] && !hasPermissions('projects')) { $offers = array(); $is_user_offer_exist = false; } if ($project['verify_only'] == 't') { $verify_check = $is_verify; if (!$is_verify) { //$answer_button_href = '/promo/verification/'; if (!get_uid(false)) { $_SESSION['ref_uri2'] = $project['id'];
function RestoreAdvice($id_advice, $status) { $objResponse = new xajaxResponse(); $id_advice = intval($id_advice); if (!$id_advice) { $objResponse->call('alert', 'Ошибка'); return $objResponse; } $advice = new paid_advices(); $advice->restore($id_advice, $status); $info = $advice->getAdvice($id_advice); if ($info['converted_id'] > 0) { require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/opinions.php"; opinions::setConvertOpinion($info['converted_id'], true); } $objResponse->call("restoreAdvice", $id_advice); return $objResponse; }
if ($is_upload_error) { $error['files'] = 1; $error['files_text'] = 'Размер файла не должен превышать 30 Мб'; } $is_transfer = false; if ($opinion > 0 && get_uid(false) && !$paid_advice->isConvertExist($opinion)) { $_opinion = opinions::GetMsgInfo($opinion, $error); $advice = opinions::converOpinion2Advice($_opinion); if ($advice) { $is_transfer = true; } else { //header("Location: /404.php"); //exit; } if (isset($_POST['save']) && $is_transfer) { $is_convert = opinions::setConvertOpinion($opinion); if ($is_convert) { $edit = $paid_advice->add($advice['user_to'], $advice['msgtext'], $advice['user_from'], $advice['create_date'], $opinion); $_POST['paid_advice_id'] = $edit; } else { $error['save'] = 'Не удалось записать рекомендацию'; } } } if ($edit > 0 && get_uid(false)) { $advice = $paid_advice->getAdvice((int) $edit, $user->uid); $filesSize = 0; $bitDisabled = '00000'; $bitEnabled = '11111'; if ($advice['docs_link'] != "") { $link = $advice['docs_link'];
ini_set('display_errors', 0); //error_reporting(E_ALL ^ E_NOTICE); ini_set('max_execution_time', 0); ini_set('memory_limit', '512M'); if (!isset($_SERVER['DOCUMENT_ROOT']) || !strlen($_SERVER['DOCUMENT_ROOT'])) { $_SERVER['DOCUMENT_ROOT'] = rtrim(realpath(pathinfo(__FILE__, PATHINFO_DIRNAME) . '/../../'), '/'); } require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/stdf.php'; //require_once($_SERVER['DOCUMENT_ROOT'] . "/classes/config.php"); //require_once($_SERVER['DOCUMENT_ROOT'] . "/classes/profiler.php"); require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/opinions.php'; //------------------------------------------------------------------------------ $results = array(); if (count($argv) > 1) { parse_str(implode('&', array_slice($argv, 1)), $_GET); } //------------------------------------------------------------------------------ $login = @$_GET['login']; isAllowProfi(); $user = new users(); $user->GetUser($login); if ($user->uid > 0) { $results['GetCounts'] = print_r(opinions::GetCounts($user->uid, array('total')), true); } //------------------------------------------------------------------------------ array_walk($results, function (&$value, $key) { $value = sprintf('%s = %s' . PHP_EOL, $key, $value); }); print_r(implode('', $results)); exit;
<?php // Задача https://beta.free-lance.ru/mantis/view.php?id=28240 ini_set('display_errors', 'on'); require_once "../classes/config.php"; require_once "../classes/opinions.php"; // Месяц для подсчета статистики $date_start = '2014-09-01 00:00:00'; $date_end = '2014-10-01 00:00:00'; $sql = "\n select \n uid, \n login,\n (select count(*) from projects as p2 where p2.user_id = users.uid and p2.kind=4 and p2.post_date >= '{$date_start}' and p2.post_date < '{$date_end}') as vacancies_count,\n (select count(*) from projects as p3 where p3.user_id = users.uid and p3.payed = 0 and p3.kind=4 and p3.post_date >= '{$date_start}' and p3.post_date < '{$date_end}') as vacancies_not_payed,\n reg_date,\n (select 0-sum(ammount) from account_operations where billing_id=(select id from account where uid = users.uid) and ammount < 0) as amount\n from users where uid in (\n select user_id from projects where payed = 0 and kind=4 and post_date >= '{$date_start}' and post_date < '{$date_end}'\n ) \n order by vacancies_not_payed desc\n"; $count = 0; $rows = $DB->rows($sql); foreach ($rows as $row) { ++$count; $o = opinions::GetCounts($row['uid'], array('total')); $o_sum = intval($o['total']['p']) + intval($o['total']['m']); echo '"' . join('";"', $row) . '"'; echo ";\"{$o['total']['p']}\";\"{$o['total']['m']}\";"; echo "\n"; }