PHP tservices_tags::getsByTServiceId Exemples

Exemple #1

Fichier : tservices-model-tests.php Projet : kapai69/fl-ru-damp

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

Exemple #2

Fichier : tservices.php Projet : kapai69/fl-ru-damp

 /**
  * Получаем услугу, принадлежащую текущему пользователю, по 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;
 }