��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/lib/core/lhquestionary/lhquestionary.php

��ѧ٧ѧ�
<?php /** * Status - * 0 - Pending * 1 - Active * 2 - Closed * 3 - Blocked * */ class erLhcoreClassQuestionary { public static function getSession() { if ( !isset( self::$persistentSession ) ) { self::$persistentSession = new ezcPersistentSession( ezcDbInstance::get(), new ezcPersistentCodeManager( './pos/lhquestionary' ) ); } return self::$persistentSession; } private static $persistentSession; // Returns relative voting item, if matched items are with the same priority // item with longer location should be returned first/ public static function getReletiveVoting($url) { $matchString = ''; if ($url != '') { $parts = parse_url($url); if (isset($parts['path'])) { $matchString = $parts['path']; } if (isset($parts['query'])) { $matchString .= '?'.$parts['query']; } } $mostRelative = false; $items = self::getList(array('sort' => 'priority DESC', 'filter' => array('active' => 1))); foreach ($items as $item) { if ( (empty($item->location) \|\| $item->location == '/') && $mostRelative == false) { // Select standard one if we do not have yet one $mostRelative = $item; } else if ( !empty($item->location) && $item->location != '/' && strpos($matchString, $item->location) !== false) { if ($mostRelative == false) { $mostRelative = $item; } elseif (strlen($item->location) > strlen($mostRelative->location)) { $mostRelative = $item; } } } return $mostRelative; } public static function getList($paramsSearch = array(), $class = 'erLhcoreClassModelQuestion', $tableName = 'lh_question') { $paramsDefault = array('limit' => 32, 'offset' => 0); $params = array_merge($paramsDefault,$paramsSearch); $session = self::getSession(); $q = $session->createFindQuery( $class ); $conditions = array(); if (!isset($paramsSearch['smart_select'])) { if (isset($params['filter']) && count($params['filter']) > 0) { foreach ($params['filter'] as $field => $fieldValue) { $conditions[] = $q->expr->eq( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filterin']) && count($params['filterin']) > 0) { foreach ($params['filterin'] as $field => $fieldValue) { $conditions[] = $q->expr->in( $field, $fieldValue ); } } if (isset($params['filterlt']) && count($params['filterlt']) > 0) { foreach ($params['filterlt'] as $field => $fieldValue) { $conditions[] = $q->expr->lt( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filtergt']) && count($params['filtergt']) > 0) { foreach ($params['filtergt'] as $field => $fieldValue) { $conditions[] = $q->expr->gt( $field,$q->bindValue( $fieldValue )); } } if (isset($params['customfilter']) && count($params['customfilter']) > 0) { foreach ($params['customfilter'] as $fieldValue) { $conditions[] = $fieldValue; } } if (count($conditions) > 0) { $q->where( $conditions ); } if (isset($params['use_index'])) { $q->useIndex( $params['use_index'] ); } $q->limit($params['limit'],$params['offset']); $q->orderBy(isset($params['sort']) ? $params['sort'] : 'id DESC' ); } else { $q2 = $q->subSelect(); $q2->select( 'id' )->from( $tableName ); if (isset($params['filter']) && count($params['filter']) > 0) { foreach ($params['filter'] as $field => $fieldValue) { $conditions[] = $q2->expr->eq( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filterin']) && count($params['filterin']) > 0) { foreach ($params['filterin'] as $field => $fieldValue) { $conditions[] = $q2->expr->in( $field, $fieldValue ); } } if (isset($params['filterlt']) && count($params['filterlt']) > 0) { foreach ($params['filterlt'] as $field => $fieldValue) { $conditions[] = $q2->expr->lt( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filterlte']) && count($params['filterlte']) > 0) { foreach ($params['filterlte'] as $field => $fieldValue) { $conditions[] = $q2->expr->lte( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filtergt']) && count($params['filtergt']) > 0) { foreach ($params['filtergt'] as $field => $fieldValue) { $conditions[] = $q2->expr->gt( $field,$q->bindValue( $fieldValue) ); } } if (isset($params['filtergte']) && count($params['filtergte']) > 0) { foreach ($params['filtergte'] as $field => $fieldValue) { $conditions[] = $q2->expr->gte( $field,$q->bindValue( $fieldValue) ); } } if (isset($params['customfilter']) && count($params['customfilter']) > 0) { foreach ($params['customfilter'] as $fieldValue) { $conditions[] = $fieldValue; } } if (count($conditions) > 0) { $q2->where( $conditions ); } if (isset($params['use_index'])) { $q2->useIndex( $params['use_index'] ); } $q2->limit($params['limit'],$params['offset']); $q2->orderBy(isset($params['sort']) ? $params['sort'] : 'id DESC'); $q->innerJoin( $q->alias( $q2, 'items' ), $tableName . '.id', 'items.id' ); $q->orderBy(isset($params['sort']) ? $params['sort'] : 'id DESC' ); } $objects = $session->find( $q ); return $objects; } public static function getCount($params = array(), $table = 'lh_question', $operation = 'COUNT(id)') { $session = self::getSession(); $q = $session->database->createSelectQuery(); $q->select( $operation )->from( $table ); $conditions = array(); if (isset($params['filter']) && count($params['filter']) > 0) { foreach ($params['filter'] as $field => $fieldValue) { $conditions[] = $q->expr->eq( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filterin']) && count($params['filterin']) > 0) { foreach ($params['filterin'] as $field => $fieldValue) { $conditions[] = $q->expr->in( $field, $fieldValue ); } } if (isset($params['filterlt']) && count($params['filterlt']) > 0) { foreach ($params['filterlt'] as $field => $fieldValue) { $conditions[] = $q->expr->lt( $field, $q->bindValue($fieldValue) ); } } if (isset($params['filtergt']) && count($params['filtergt']) > 0) { foreach ($params['filtergt'] as $field => $fieldValue) { $conditions[] = $q->expr->gt( $field,$q->bindValue( $fieldValue )); } } if (isset($params['customfilter']) && count($params['customfilter']) > 0) { foreach ($params['customfilter'] as $fieldValue) { $conditions[] = $fieldValue; } } if ( count($conditions) > 0 ) { $q->where( $conditions ); } if (isset($params['use_index'])) { $q->useIndex( $params['use_index'] ); } $stmt = $q->prepare(); $stmt->execute(); $result = $stmt->fetchColumn(); return $result; } } ?>

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�