<?php ini_set('display_errors', 1); error_reporting(E_ALL ^ E_NOTICE); require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/stdf.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/tservices/tservices_categories.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/tservices/tservices_tags.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/tservices/tservices.php'; $tservices_categories = new tservices_categories(); $result = $tservices_categories->getTitleAndSubtitle(10); assert('$result == array("spec_title" => "Веб-программирование", "group_title" => "Разработка сайтов")'); $result = $tservices_categories->getCategoryParentId(10); assert('$result == 7'); $tservices_tags = new tservices_tags(); $result = $tservices_tags->getsByTServiceId(39); assert('$result == array( 0 => "альбом", 1 => "бронировать", 2 => "забронировать", 3 => "заказать", 4 => "заказывать", 5 => "зарезервировать" )'); $tservices = new tservices(2); $result = $tservices->isExistFeedbacks(27); assert('$result == 2'); $result = $tservices->getTotalCount(); assert('$result == array("plus" => 2, "minus" => 2)'); $result = $tservices->getNearBy('next', 38); $result = $tservices->getNearBy('prev', 38); $result = $tservices->getCountCompleteSbrServices(); assert('$result == 5'); $result = $tservices->deleteById(750); assert('$result == TRUE'); $result = $tservices->isExists(749); $result = $tservices->getFeedbacks(36); $result = $tservices->getCard(36); $result = $tservices->setPage(5)->getShortList();
/** * Получаем услугу, принадлежащую текущему пользователю, по ID и * заполняем свойства обьекта. * * @param type $id * * @return bool */ public function getByID($id) { $row = $this->db()->row("\n SELECT \n s.*,\n COALESCE((sc.sbr_minus + sc.order_minus),0) AS minus_feedbacks\n FROM {$this->TABLE} AS s \n LEFT JOIN {$this->TABLE_COUNTERS} AS sc ON sc.service_id = s.id\n WHERE \n s.deleted = FALSE \n AND s.user_id = ?i \n AND s.id = ?i", $this->uid, $id); if ($this->arrayToFieldsProps($row)) { $tservices_tags = new tservices_tags(); $this->tags = $tservices_tags->getsByTServiceId($id); $this->images = CFile::selectFilesBySrc($this->TABLE_FILES, $id, 'id', 'small = 1 AND preview=\'f\''); $this->preview = CFile::selectFilesBySrc($this->TABLE_FILES, $id, 'id', 'small = 1 AND preview=\'t\''); $this->is_angry = $row['minus_feedbacks'] > 0; return true; } return false; }