public function __construct(SearchQuery $objSearchQuery, $objParentObject, $strControlId = null) { try { parent::__construct($objParentObject, $strControlId); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } $this->objSearchQuery = $objSearchQuery; $this->strTemplate = dirname(__FILE__) . '/SearchQueryPanel.tpl.php'; $this->dtgConditions = new QDataGrid($this); $this->dtgConditions->AddColumn(new QDataGridColumn('Item', '<?= $_CONTROL->ParentControl->RenderItem($_ITEM); ?>', 'HtmlEntities=false', 'Width=160px')); $this->dtgConditions->AddColumn(new QDataGridColumn('Operation', '<?= $_CONTROL->ParentControl->RenderOperation($_ITEM); ?>', 'HtmlEntities=false', 'Width=180px')); $this->dtgConditions->AddColumn(new QDataGridColumn('Value', '<?= $_CONTROL->ParentControl->RenderValue($_ITEM); ?>', 'HtmlEntities=false', 'Width=390px')); $this->dtgConditions->SetDataBinder('dtgConditions_Bind', $this); $this->btnAddCondition = new QButton($this); $this->btnAddCondition->CssClass = 'primary'; $this->btnAddCondition->Text = 'Add a Condition'; $this->btnAddCondition->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'btnAddCondition_Click')); if ($this->objSearchQuery->Id) { $this->objQueryConditionArray = QueryCondition::LoadArrayBySearchQueryId($this->objSearchQuery->Id, QQ::OrderBy(QQN::QueryCondition()->Id)); $this->objQueryConditionArray[] = new QueryCondition(); } else { $this->objQueryConditionArray = array(new QueryCondition()); } // Single Lookup of Node and Operations $this->objNodeArray = array(); foreach (QueryNode::LoadAll(QQ::OrderBy(QQN::QueryNode()->Name)) as $objNode) { $this->objNodeArray[$objNode->Id] = $objNode; } $this->objOperationArray = array(); foreach (QueryOperation::LoadAll(QQ::OrderBy(QQN::QueryOperation()->Name)) as $objOperation) { $this->objOperationArray[$objOperation->Id] = $objOperation; } }
<?php require_once 'logger/error_log.php'; //enables printing log messages to logger/error_log.txt require_once 'Request.php'; //uses client data sent to make query calls to class in charge. require_once 'QueryOperation.php'; //class in charge of query operations $request_method = strtolower($_SERVER['REQUEST_METHOD']); error_log("type " . $request_method); $query = new QueryOperation(); $result = new stdClass(); function get_url_id() { $strip = basename($_SERVER['REQUEST_URI']); $strip = explode("?", $strip); if (count($strip) > 0) { return $strip[0]; } return NULL; } switch ($request_method) { case 'get': $result = $query->getConsumo(new stdClass()); break; case 'put': $put = file_get_contents("php://input", 'r'); $params = json_decode($put); $result = $query->updateConsumo($params); break; case 'post':
<?php require_once 'logger/error_log.php'; //enables printing log messages to logger/error_log.txt require_once 'Request.php'; //uses client data sent to make query calls to class in charge. require_once 'QueryOperation.php'; //class in charge of query operations $request_method = strtolower($_SERVER['REQUEST_METHOD']); error_log("type " . $request_method); $query = new QueryOperation(); $result = new stdClass(); function get_url_id() { $strip = basename($_SERVER['REQUEST_URI']); $strip = explode("?", $strip); if (count($strip) > 0) { return $strip[0]; } return NULL; } switch ($request_method) { case 'get': $result = $query->getRichiesta(new stdClass()); break; case 'put': $put = file_get_contents("php://input", 'r'); $params = json_decode($put); $result = $query->updateRichiesta($params); break; case 'post':
/** * Static Helper Method to Create using PK arguments * You must pass in the PK arguments on an object to load, or leave it blank to create a new one. * If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo * static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to * edit, or if we are also allowed to create a new one, etc. * * @param mixed $objParentObject QForm or QPanel which will be using this QueryOperationMetaControl * @param integer $intId primary key value * @param QMetaControlCreateType $intCreateType rules governing QueryOperation object creation - defaults to CreateOrEdit * @return QueryOperationMetaControl */ public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit) { // Attempt to Load from PK Arguments if (strlen($intId)) { $objQueryOperation = QueryOperation::Load($intId); // QueryOperation was found -- return it! if ($objQueryOperation) { return new QueryOperationMetaControl($objParentObject, $objQueryOperation); } else { if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) { throw new QCallerException('Could not find a QueryOperation object with PK arguments: ' . $intId); } } // If EditOnly is specified, throw an exception } else { if ($intCreateType == QMetaControlCreateType::EditOnly) { throw new QCallerException('No PK arguments specified'); } } // If we are here, then we need to create a new record return new QueryOperationMetaControl($objParentObject, new QueryOperation()); }
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects) { if ($objObject->objSearchQuery) { $objObject->objSearchQuery = SearchQuery::GetSoapObjectFromObject($objObject->objSearchQuery, false); } else { if (!$blnBindRelatedObjects) { $objObject->intSearchQueryId = null; } } if ($objObject->objOrQueryCondition) { $objObject->objOrQueryCondition = QueryCondition::GetSoapObjectFromObject($objObject->objOrQueryCondition, false); } else { if (!$blnBindRelatedObjects) { $objObject->intOrQueryConditionId = null; } } if ($objObject->objQueryOperation) { $objObject->objQueryOperation = QueryOperation::GetSoapObjectFromObject($objObject->objQueryOperation, false); } else { if (!$blnBindRelatedObjects) { $objObject->intQueryOperationId = null; } } if ($objObject->objQueryNode) { $objObject->objQueryNode = QueryNode::GetSoapObjectFromObject($objObject->objQueryNode, false); } else { if (!$blnBindRelatedObjects) { $objObject->intQueryNodeId = null; } } return $objObject; }
<?php session_start(); require_once 'logger/error_log.php'; //enables printing log messages to logger/error_log.txt require_once 'Request.php'; //uses client data sent to make query calls to class in charge. require_once 'QueryOperation.php'; //class in charge of query operations $request_method = strtolower($_SERVER['REQUEST_METHOD']); error_log("type " . $request_method); $query = new QueryOperation(); $result = new stdClass(); function get_url_id() { $strip = basename($_SERVER['REQUEST_URI']); $strip = explode("?", $strip); if (count($strip) > 0) { return $strip[0]; } return NULL; } switch ($request_method) { case 'get': $result = $query->getResults(new stdClass(), $_SESSION['comune']); if (isset($_SESSION['comune'])) { unset($_SESSION['comune']); } break; case 'put': $put = file_get_contents("php://input", 'r');
public static function GetSoapArrayFromArray($objArray) { if (!$objArray) { return null; } $objArrayToReturn = array(); foreach ($objArray as $objObject) { array_push($objArrayToReturn, QueryOperation::GetSoapObjectFromObject($objObject, true)); } return unserialize(serialize($objArrayToReturn)); }
/** * Refresh this MetaControl with Data from the local QueryCondition object. * @param boolean $blnReload reload QueryCondition from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objQueryCondition->Reload(); } if ($this->lblId) { if ($this->blnEditMode) { $this->lblId->Text = $this->objQueryCondition->Id; } } if ($this->lstSearchQuery) { $this->lstSearchQuery->RemoveAllItems(); $this->lstSearchQuery->AddItem(QApplication::Translate('- Select One -'), null); $objSearchQueryArray = SearchQuery::LoadAll(); if ($objSearchQueryArray) { foreach ($objSearchQueryArray as $objSearchQuery) { $objListItem = new QListItem($objSearchQuery->__toString(), $objSearchQuery->Id); if ($this->objQueryCondition->SearchQuery && $this->objQueryCondition->SearchQuery->Id == $objSearchQuery->Id) { $objListItem->Selected = true; } $this->lstSearchQuery->AddItem($objListItem); } } } if ($this->lblSearchQueryId) { $this->lblSearchQueryId->Text = $this->objQueryCondition->SearchQuery ? $this->objQueryCondition->SearchQuery->__toString() : null; } if ($this->lstOrQueryCondition) { $this->lstOrQueryCondition->RemoveAllItems(); $this->lstOrQueryCondition->AddItem(QApplication::Translate('- Select One -'), null); $objOrQueryConditionArray = QueryCondition::LoadAll(); if ($objOrQueryConditionArray) { foreach ($objOrQueryConditionArray as $objOrQueryCondition) { $objListItem = new QListItem($objOrQueryCondition->__toString(), $objOrQueryCondition->Id); if ($this->objQueryCondition->OrQueryCondition && $this->objQueryCondition->OrQueryCondition->Id == $objOrQueryCondition->Id) { $objListItem->Selected = true; } $this->lstOrQueryCondition->AddItem($objListItem); } } } if ($this->lblOrQueryConditionId) { $this->lblOrQueryConditionId->Text = $this->objQueryCondition->OrQueryCondition ? $this->objQueryCondition->OrQueryCondition->__toString() : null; } if ($this->lstQueryOperation) { $this->lstQueryOperation->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstQueryOperation->AddItem(QApplication::Translate('- Select One -'), null); } $objQueryOperationArray = QueryOperation::LoadAll(); if ($objQueryOperationArray) { foreach ($objQueryOperationArray as $objQueryOperation) { $objListItem = new QListItem($objQueryOperation->__toString(), $objQueryOperation->Id); if ($this->objQueryCondition->QueryOperation && $this->objQueryCondition->QueryOperation->Id == $objQueryOperation->Id) { $objListItem->Selected = true; } $this->lstQueryOperation->AddItem($objListItem); } } } if ($this->lblQueryOperationId) { $this->lblQueryOperationId->Text = $this->objQueryCondition->QueryOperation ? $this->objQueryCondition->QueryOperation->__toString() : null; } if ($this->lstQueryNode) { $this->lstQueryNode->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstQueryNode->AddItem(QApplication::Translate('- Select One -'), null); } $objQueryNodeArray = QueryNode::LoadAll(); if ($objQueryNodeArray) { foreach ($objQueryNodeArray as $objQueryNode) { $objListItem = new QListItem($objQueryNode->__toString(), $objQueryNode->Id); if ($this->objQueryCondition->QueryNode && $this->objQueryCondition->QueryNode->Id == $objQueryNode->Id) { $objListItem->Selected = true; } $this->lstQueryNode->AddItem($objListItem); } } } if ($this->lblQueryNodeId) { $this->lblQueryNodeId->Text = $this->objQueryCondition->QueryNode ? $this->objQueryCondition->QueryNode->__toString() : null; } if ($this->txtValue) { $this->txtValue->Text = $this->objQueryCondition->Value; } if ($this->lblValue) { $this->lblValue->Text = $this->objQueryCondition->Value; } if ($this->lstQueryConditionAsOr) { $this->lstQueryConditionAsOr->RemoveAllItems(); $this->lstQueryConditionAsOr->AddItem(QApplication::Translate('- Select One -'), null); $objQueryConditionArray = QueryCondition::LoadAll(); if ($objQueryConditionArray) { foreach ($objQueryConditionArray as $objQueryCondition) { $objListItem = new QListItem($objQueryCondition->__toString(), $objQueryCondition->Id); if ($objQueryCondition->OrQueryConditionId == $this->objQueryCondition->Id) { $objListItem->Selected = true; } $this->lstQueryConditionAsOr->AddItem($objListItem); } } } if ($this->lblQueryConditionAsOr) { $this->lblQueryConditionAsOr->Text = $this->objQueryCondition->QueryConditionAsOr ? $this->objQueryCondition->QueryConditionAsOr->__toString() : null; } }
/** * Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but * could and should be used by any custom databind methods that would be used for instances of this * MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause. * * If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used. * It will also perform any sorting (if applicable). * * @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself * @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query * @return void */ public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null) { // Setup input parameters to default values if none passed in if (!$objCondition) { $objCondition = QQ::All(); } $objClauses = $objOptionalClauses ? $objOptionalClauses : array(); // We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below if ($this->Paginator) { $this->TotalItemCount = QueryOperation::QueryCount($objCondition, $objClauses); } // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add // the OrderByClause to the $objClauses array if ($objClause = $this->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be a Query result from QueryOperation, given the clauses above $this->DataSource = QueryOperation::QueryArray($objCondition, $objClauses); }
<?php require_once 'logger/error_log.php'; //enables printing log messages to logger/error_log.txt require_once 'Request.php'; //uses client data sent to make query calls to class in charge. require_once 'QueryOperation.php'; //class in charge of query operations $request_method = strtolower($_SERVER['REQUEST_METHOD']); error_log("type " . $request_method); $query = new QueryOperation(); $result = new stdClass(); function get_url_id() { $strip = basename($_SERVER['REQUEST_URI']); $strip = explode("?", $strip); if (count($strip) > 0) { return $strip[0]; } return NULL; } switch ($request_method) { case 'get': $result = $query->getResults(new stdClass()); break; case 'put': $put = file_get_contents("php://input", 'r'); $params = json_decode($put); $result = $query->updateRecords($params); break; case 'post':