public function testShouldReturnQueryInstanceWithSelect() { $query = new Query('users'); $expected = 'Query'; $result = $query->select(array('username', 'password')); $this->assertInstanceOf($expected, $result); }
/** * Get an array of models from the database. * * @param array $columns * @return array */ private function _get($columns = array('*')) { if (is_null($this->query->selects)) { $this->query->select($columns); } return Hydrator::hydrate($this); }
/** * Возвращает очки по коду * * @param int|null $userId - если передан код пользователя, то стсиема убедится, что очки даны этому пользователю * @return UserPointDO */ public function getPointById($pointId, $userId = null) { $where['id_point'] = $pointId; if (is_inumeric($userId)) { $where['id_user'] = $userId; } return new UserPointDO($this->getRecEnsure(Query::select('*', 'ps_user_points', $where))); }
protected function doSearch(PostArrayAdapter $params) { /* * Параметры */ $process = $params->int('process'); $action = $params->int('action'); $actionParent = $params->int('parent_action'); $dateFrom = $params->int('date_from'); $dateTo = $params->int('date_to'); /* * Запрос */ $what[] = 'id_rec'; $what[] = 'concat(ifnull(id_user, ""), concat("/", id_user_authed)) as user_authed'; $what[] = 'dt_event'; $what[] = 'n_action'; $what[] = 'v_data'; $what[] = 'b_encoded'; $where['id_process'] = $process; if ($actionParent) { $where['id_rec_parent'] = $actionParent; } if ($action) { $where['n_action'] = $action; } if ($dateFrom) { $where[] = Query::assocParam('dt_event', $dateFrom, true, '>='); } if ($dateTo) { $where[] = Query::assocParam('dt_event', $dateTo, true, '<='); } $order = 'dt_event asc, id_rec asc'; $limit = 500; /* * Работа с данными */ $query = Query::select($what, 'ps_audit', $where, null, $order, $limit); $result = PSDB::getArray($query); foreach ($result as &$row) { //Декодируем действие $row['n_action'] = BaseAudit::getByCode($process)->decodeAction($row['n_action'], false); //Декодируем данные $encoded = 1 * $row['b_encoded']; if ($encoded) { $row['v_data'] = print_r(BaseAudit::decodeData($row['v_data']), true); } unset($row['b_encoded']); } $results = new SearchResults($result, $query); $results->addSetting('v_data', SearchResults::COL_PRE); $results->addSetting('n_action', SearchResults::COL_NOWRAP); return $results; }
function getMailCiudadanoRespuestas($id) { include_once "Query.inc"; $query = new Query(); $registros = $query->select("mailCiudadano", "oficio", "idOficio={$id}"); if ($registros) { foreach ($registros as $reg) { return array("mailCiudadano" => "{$reg->mailCiudadano}"); } } }
static function getElectives($program, $elective_type, $elective_group, $exclude = []) { $results = array(); foreach (explode("|", $elective_group) as $group) { $q = new Query("electives"); $q->select("course_code"); $q->where("program_id=?\n\t\t\t\t\t\t\tAND elective_type=?\n\t\t\t\t\t\t\tAND note=?\n\t\t\t\t\t\t\tAND course_code NOT IN " . Query::valuelistsql($exclude), array_merge([$program, $elective_type, $group], $exclude)); $results = array_merge($results, $q->executeFetchAll()); } return $results; }
/** * Метод загражает карту 'код процесса' => 'код действия' => 'кол-во записей' * * @return array */ public function getProcessStatistic($dateTo) { $where = array(); if ($dateTo) { $where[] = Query::assocParam('dt_event', $dateTo, true, '<='); } $result = array(); foreach ($this->getArray(Query::select('id_process, n_action, count(1) as cnt', 'ps_audit', $where, 'id_process, n_action')) as $rec) { $result[$rec['id_process']][$rec['n_action']] = $rec['cnt']; } return $result; }
/** * 根据分类id获取分类名 * @param type $id * @param type $level * @return type */ public static function getCateName($id, $level = null) { $query = new Query(Yii::app()->db); $query->select('name'); $query->from('groupon_cates'); $query->andWhere('id=:id', array(':id' => $id)); if ($level) { $query->andWhere('level=:level', array(':level' => $level)); } $name = $query->queryScalar(); return $name; }
public function getQuery() { $query = new Query(Yii::app()->db); $query->select('id,biz_id,name,city_id,area_id,is_reservation'); $query->from('groupon_biz_shop'); if ($this->biz_id) { $query->andWhere('biz_id=:bid', array(':bid' => $this->biz_id)); } if ($this->name) { $query->andWhere(array('like', 'name', '%' . $this->name . '%')); } return $query; }
/** * Метод возвращает видимые пользователю объекты из базы */ public function getVisibleObjects(FoldedResources $folded, $objName, array $visibleIdents) { $folded->assertWorkWithTable(); $cacheKey = $folded->getUnique("visible-{$objName}"); if (!$this->CACHE->has($cacheKey)) { $view = $folded->getTableView(); $colIdent = $folded->getTableColumnIdent(); $colStype = $folded->getTableColumnStype(); $where = array(); if ($colStype) { $where[$colStype] = $folded->getFoldingSubType(); } $this->CACHE->set($cacheKey, $this->getArray(Query::select('*', $view, $where), null, ObjectQueryFetcher::inst($objName, $colIdent)->setIncludeKeys($visibleIdents))); } return $this->CACHE->get($cacheKey); }
public function process($get, $post) { $this->pageData["Title"] = "Home"; // Select all of the courses that this user is already added or ignored $query = new Query('action'); $result = $query->select('*', array(array('session_id', '=', $_COOKIE['sessionId']))); $idsAlreadyAdded = array(); foreach ($result as $action) { array_push($idsAlreadyAdded, $action->get('course_id')); } // Generate all of the courses (for testing) $allCourses = array(); $query = new Query('courses'); $result = $query->select('*', '', array('number', 'ASC'), 20, false); while ($row = mysqli_fetch_array($result)) { try { $course = new Course(); $course->findById($row['id']); if (!in_array($course->get('id'), $idsAlreadyAdded)) { // Check that this course has not been added by the user yet array_push($allCourses, array('id' => $course->get('id'), 'name' => ucwords(strtolower($course->get('name'))), 'department_id' => $course->get('department_id'), 'number' => $course->get('number'), 'description' => strlen($course->get('description')) == 0 ? 'No description' : $course->get('description'))); } } catch (Exception $e) { } } $this->pageData['allCourses'] = $allCourses; // Select all of the courses that this user is already added $query = new Query('action'); $result = $query->select('*', array(array('session_id', '=', $_COOKIE['sessionId']), array('choice', '=', 0))); $idsAlreadyAdded = array(); foreach ($result as $action) { array_push($idsAlreadyAdded, $action->get('course_id')); } // Get all of the courses in this user's session $usersCourses = array(); foreach ($idsAlreadyAdded as $courseId) { try { $course = new Course(); $course->findById($courseId); array_push($usersCourses, array('id' => $course->get('id'), 'name' => ucwords(strtolower($course->get('name'))), 'department_id' => $course->get('department_id'), 'number' => $course->get('number'))); } catch (Exception $e) { } } $this->pageData['usersCourses'] = $usersCourses; }
/** * js(on)entity returns an json object for the select2 widget * @param string $search Text for the lookup * @param integer of the set value * @return json [description] */ public function actionJsentity($search = NULL, $id = NULL) { header('Content-type: application/json'); $clean['more'] = false; $query = new Query(); if (!is_Null($search)) { $mainQuery = $query->select('id, name AS text')->from('{{%entity}}')->where('UPPER(name) LIKE "%' . strtoupper($search) . '%"'); $command = $mainQuery->createCommand(); $rows = $command->queryAll(); $clean['results'] = array_values($rows); } else { if (!is_null($id)) { $clean['results'] = ['id' => $id, 'text' => Entity::findOne($id)->name]; } else { $clean['results'] = ['id' => 0, 'text' => 'None found']; } } echo Json::encode($clean); exit; }
public function process($get, $post) { if (!isset($post['course_id']) || !is_numeric($post['course_id']) || !isset($_COOKIE['sessionId']) || !is_numeric($_COOKIE['sessionId'])) { $this->failureReason = 'Sorry, there was an error.'; return false; } $query = new Query('action'); // Select all the courses that are in this user's session and have this course id $result = $query->select('*', array(array('course_id', '=', $post['course_id']), array('session_id', '=', $_COOKIE['sessionId'])), '', 1); if (count($result) != 0) { // Abort because this course is already in the user's model $this->failureReason = 'Sorry, there was an error'; return false; } // Now add this course to the user's model $action = new Action(); $action->set('course_id', $post['course_id']); $action->set('session_id', $_COOKIE['sessionId']); $action->save(); return true; }
public function process($get, $post) { // Select all of the courses that this user is already added $query = new Query('action'); $result = $query->select('*', array(array('session_id', '=', $_COOKIE['sessionId']))); $idsAlreadyAdded = array(); foreach ($result as $action) { array_push($idsAlreadyAdded, $action->get('course_id')); } // Select all the courses where the query string is a sub-string of the name or id $query = new Query('courses'); $result = $query->select('*', array(array('name', 'LIKE', '%' . $post['q'] . '%'), 'OR', array('number', 'LIKE', '%' . $post['q'] . '%')), array('number', 'ASC'), 100); $courses = array(); foreach ($result as $course) { if (!in_array($course->get('id'), $idsAlreadyAdded)) { // Check that this course has not been added by the user yet array_push($courses, array('id' => $course->get('id'), 'name' => ucwords(strtolower($course->get('name'))), 'department_id' => $course->get('department_id'), 'number' => $course->get('number'), 'description' => strlen($course->get('description')) == 0 ? 'No description' : $course->get('description'))); } } $this->pageData['courseResults'] = $courses; return true; }
/** * 获取子市区的键值对列表 * @param int/null $pid 父ID * @param int $grade 等级 * @return array */ public static function getAreas($pid = null, $grade = self::GRADE_PROVINCE) { $key = 'arealist_' . $grade . '_' . $pid; $areas = Yii::app()->cache->get($key); // dump($areas); if ($areas === false) { $query = new Query(Yii::app()->db); $query->select('id,name'); $query->from('area'); if ($pid == null) { $query->andWhere('parent_id is null'); } else { $query->andWhere('parent_id=:pid', array(':pid' => $pid)); } $areas = $query->queryAll(); if (!empty($areas)) { $areas = A::map($areas, 'id', 'name'); } Yii::app()->cache->set($key, $areas, 60 * 60 * 24); } // dump($areas); return $areas; }
function _upload_db($old, $to, $path, $size, $type) { $data = file_get_contents($old); $uniqid = md5($data); $query = new Query(); $query->select('id,path')->from('file')->where(array('uniqid' => $uniqid)); $command = $query->createCommand(); $row = $command->queryRow(); if (!$row) { copy($old, $to); $data = array('path' => $path, 'uniqid' => $uniqid, 'size' => $size, 'type' => $type, 'uid' => $this->uid, 'created' => time(), 'admin' => $this->admin); \Yii::$app->db->createCommand()->insert('file', $data)->execute(); } else { if (!file_exists(root_path() . $row['path'])) { copy($old, root_path() . $row['path']); } } $query = new Query(); $query->select('id,path,type')->from('file')->where(array('uniqid' => $uniqid)); $command = $query->createCommand(); $row = $command->queryRow(); @unlink($old); return $row; }
function p_items() { $list = array(); while (1) { if ($this->lat[0] == 'item') { $this->lex(); if ($this->lat[0] != 'WORD') { return $this->unexpectedToken('WORD'); } $value = $this->lat[1]; $this->lex(); $params = $this->p_params(); if (is_a($params, 'Error')) { return $params; } array_push($list, array($value, $params)); } else { if ($this->lat[0] == 'sql') { $this->lex(); if ($this->lat[0] != 'SQLCODE') { return $this->unexpectedToken('SQLCODE'); } $sql = $this->lat[1]; $this->lex(); while ($this->lat[0] == 'SQLCODE') { $sql .= ' ' . $this->lat[1]; $this->lex(); } $result = $this->p_end(); if (is_a($result, 'Error')) { return $result; } $q = new Query(); $r = $q->select($sql); while ($row = $r->next()) { array_push($list, array($row['value'], $row)); } } else { break; } } } return $list; }
<?php require_once 'config.php'; require_once 'functions.php'; require_once '../common/db.php'; try { // Database connection first. $db = new CompactDB($mt_dbhost, $mt_dbname, $mt_dbuser, $mt_dbpass); $q = new Query($db); $chunks = $q->select('id,content')->from('track')->where("processed=0")->run(); // Required objects and set up $c = new Canvas(thisURL()); $c->common->addScriptRef(APP_URL . 'files/jquery.js'); $c->common->addScriptRef(APP_URL . 'files/jquery-effects.js'); switch ($c->getMode()) { /* --------------------------------------------------------------------------------------------------------- */ case 'show': default: // We create the toolbar $t = new Toolbar(); $c->register($t); // If there are chunks to process, we display a button. if (count($chunks) > 0) { $t->addAction('Process ' . count($chunks) . ' tracks', "doConfirm('This action may take a long time and make the browser\\nto timeout. Are you sure you want to do this?','process')", 'go-jump'); } // We retrieve all the tracks we have stored in a pretty table. $mtrx = $db->qSelect("select t.id, t.name, t.pid, from_unixtime(t.offset/1000) as t_start, round(max(e.t)/1000,1) as t_duration " . "from track as t, event as e where t.id=e.track_id and t.processed=1 group by e.track_id;"); $tab = new Table($mtrx); $tab->setProperty('highlight', true); $tab->setProperty('numbering', true); $tab->setProperty('id', 'id');
public function ajax() { $w = new Word(); $w->get(1, 1000); } public function queryById($id) { $s_id = (int) $id; $w = new Word(); echo $w->queryById($s_id); } public function select() { $w = new Word(); $rows = $w->selectLatest(100); // foreach($rows as $key=>$val) { // echo $val["w_desc"]."<hr>"; // } echo json_encode($rows); } } set_time_limit(0); $q = new Query(); if (isset($_GET["id"])) { $q->queryById($_GET['id']); } else { if (isset($_GET['select'])) { //$q->ajax(); $q->select(); } }
/** * checkUserInDB() * Builds select query to check user in DB and returns result as an array * * @return array|false */ private function checkUserInDB() { $query = new Query(); $query->select()->from($this->table)->where($this->identityColumn . " = ?", $this->identity)->andWhere($this->credentialColumn . " = ?", $this->credential)->limit(1); return $this->dbAdapter->fetchRow($query); }
<?php include "sources/funciones.php"; if ($_SESSION["Activa"] and $_SESSION["Tipo_usuario"] == "administrador" and $_REQUEST) { $propietario = __($_REQUEST['propietario']); require "sources/Query.inc"; $query = new Query(); if ($query->select("propietario", "redaccion", "propietario='{$propietario}'")) { echo "<font style=' color: #CC0000'>El Propietario ya existe, intente nuevamente</font>"; } } else { redireccionar(); }
<?php include "sources/funciones.php"; if ($_SESSION["Activa"] and $_SESSION["Tipo_usuario"] == "administrador" and $_REQUEST) { $mail = __($_REQUEST['mail']); require "sources/Query.inc"; $query = new Query(); if ($query->select("correo", "revisor", "correo='{$mail}'")) { echo "<font style=' color: #CC0000'>El correo electrónico ya existe, intente nuevamente</font>"; } } else { redireccionar(); }
function siExiste($campo, $tabla, $email) { include_once "./conf/query.inc"; $queryExiste = new Query(); $valores = $queryExiste->select($campo, $tabla, $email); if ($valores) { foreach ($valores as $valor) { return TRUE; } } return FALSE; }
public function index() { require ROOT . '/Query.php'; echo \Query::select('id', 'titre', 'contenu')->from('articles')->where('id = 1')->where('article.category_id = 1')->where('article.date > NOW()'); }
<?php include "sources/funciones.php"; if ($_SESSION["Activa"] and $_SESSION["Tipo_usuario"] = "normal" and $_REQUEST) { $nOficio = strtolower($_REQUEST['nOficio']); if ($nOficio) { require "sources/Query.inc"; $query = new Query(); $regCupo = $query->select("idOficio idOficio,noOficio nOficio,asunto asunto,fecha fecha, status status", "oficio", "noOficio={$nOficio} and status=2"); $regCupo2 = $query->select("idOficio idOficio,noOficio nOficio,status status", "oficio", "noOficio={$nOficio} and status=3"); if ($regCupo) { echo "<table class='table table-condensed'>"; echo "<thead>"; echo "<tr>"; echo "<th>N° de Oficio</th>"; echo "<th>Asunto</th>"; echo "<th>Fecha</th>"; echo "<th style='text-align:center'>Generar Respuesta</th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; foreach ($regCupo as $regC) { $fechaFormato = $regC->fecha; $meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"); echo "<tr>"; echo "<td>{$regC->nOficio}</td>"; echo "<td>{$regC->asunto}</td>"; echo "<td>" . date('d', strtotime($fechaFormato)) . " de " . $meses[date('n', strtotime($fechaFormato)) - 1] . " de " . date('Y', strtotime($fechaFormato)) . "</td>"; ?> <td style="text-align:center"><a href='generarRespuesta.php?idOficio=<?php echo $regC->idOficio;
public function actionAutocomplete($search = null, $id = null, $object_id = null) { /** * @todo Добавить отображение вложенности */ $out = ['more' => false]; if (!is_null($search)) { $query = new Query(); $query->select(Property::tableName() . '.id, ' . Property::tableName() . '.name AS text')->from(Property::tableName())->andWhere(['like', Property::tableName() . '.name', $search])->limit(100); if (!is_null($object_id)) { $query->leftJoin(PropertyGroup::tableName(), PropertyGroup::tableName() . '.id = ' . Property::tableName() . '.property_group_id'); $query->andWhere([PropertyGroup::tableName() . '.id' => $object_id]); } $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'text' => Property::findOne($id)->name]; } else { $out['results'] = ['id' => 0, 'text' => Yii::t('app', 'No matching records found')]; } echo Json::encode($out); }
/** * Get release with Asociated Artist * Show Action * * @param Query $query * @param string $permalink * @return Query */ public function scopeReleaseDetails($query, $permalink) { $query->where(['permalink' => $permalink, 'active' => true])->with(['artist' => function ($query) { $query->select('id', 'name', 'permalink'); }])->with(['tags' => function ($query) { $query->select('id', 'name', 'permalink'); }]); }
function getRevisorRobertScriptCase() { include_once "Query.inc"; $query = new Query(); $regConsulta = $query->select("idRevisor", "revisor", "1"); if ($regConsulta) { foreach ($regConsulta as $regC) { echo "case '{$regC->idRevisor}':\r\n \$('#Rev" . $regC->idRevisor . "').show();" . "break;"; } } }
* @param {optional} program - The name of the program to return * * @return An XML response containing programs that matched the search * * @example programs.php - This would return all of the programs * @example programs.php?program=Software - This would return all programs with a name like software */ if ($_SERVER['REQUEST_METHOD'] != 'GET') { http_response_code(405); echo '{"e":1, "msg":"Method must be GET."}'; exit; } require_once 'lib/db.php'; $has_param = in_array('program', $_GET); $q = new Query("programs"); $q->select("id"); $q->select("year"); $q->select("name"); if ($has_param) { $q->where('name LIKE ?', [$_GET['program']]); } $rows = $q->executeFetchAll(); $response = '<response e="0">'; foreach ($rows as $program) { $response .= '<program>'; $response .= "<id>{$program['0']}</id>"; $response .= "<year>{$program['1']}</year>"; $response .= "<name>{$program['2']}</name>"; $response .= '</program>'; } $response .= '</response>';
<?php include("sources/funciones.php"); if ($_POST) { $usu = __(strtolower($_POST["usu"])); $pass = __($_POST["pass"]); $passEncriptado = sha1($pass); require("sources/Query.inc"); $query = new Query(); $login = $query->select("idLogin, usuario, password, tipoUsu", "login", "usuario='$usu' and password='******'"); if ($login) { foreach ($login as $l) { switch ($l->tipoUsu) { case 2: $_SESSION["Activa"] = true; $_SESSION["ID"] = $l->idLogin; $_SESSION["Usuario"] = $l->usuario; $_SESSION["Tipo_usuario"] = "normal"; break; case 3: $_SESSION["Activa"] = true; $_SESSION["ID"] = $l->idLogin; $_SESSION["Usuario"] = $l->usuario; $_SESSION["Tipo_usuario"] = "administrador"; break; } } $respuesta = ' <img src="images/ok.png" width="100">