public function __construct($result) { if (is_bool($result)) { $data = $result; } else { $data = array(); $this->result = $result; while ($row = $result->fetchArray(SQLITE3_ASSOC)) { $data[] = $row; } reset($data); } parent::__construct($data); }
public function ShowRequest() { Factory::getUser()->authorise("request", ResponseRegistery::getInstance()->site_id); $this->tmpl->loadPage('showRequest'); $site_id = ResponseRegistery::getInstance()->site_id; $query = "SELECT items.title AS item_name, \n items.price AS item_price,\n reqs.name AS name,\n reqs.tel AS tel,\n reqs.register_date AS date,\n reqs.code AS code,\n reqs.city AS city,\n reqs.address AS address,\n reqs.status AS status,\n reqs.id AS id\n FROM sh_requests AS reqs\n JOIN sh_items_requests AS it_reqs ON (it_reqs.request_id = reqs.id)\n JOIN sh_items AS items ON (items.id = it_reqs.item_id)\n JOIN sh_subgroups_items AS sgItem ON ( sgItem.item_id = items.id )\n JOIN sh_subgroups AS sg ON ( sg.id = sgItem.subgroup_id )\n JOIN sh_groups AS g ON ( sg.group_id = g.id )\n WHERE (g.site_id ={$site_id})"; $res = $this->db->query($query); $retC = QueryResult::$returnClass; QueryResult::$returnClass = 'stdClass'; $requests = $res->fetchAll(); QueryResult::$returnClass = $retC; fb($requests); $ret = array(); foreach ($requests as $req) { fb($req, 'b'); $req->date = Factory::getDate($req->date)->format("d-m-Y"); if (!isset($ret[$req->id])) { $ret[$req->id] = clone $req; //$ret[$req->id]->requests=array(); } $x = $ret[$req->id]; $x->requests[] = clone $req; fb($req, 'a'); } foreach ($ret as &$req) { foreach ($req->requests as &$item) { $item = new istdClass($item); } $req = new istdClass($req); } fb($ret, 'ffffff'); $status_options = array('pending' => 'در دست بررسی', 'sent' => 'ارسال شده', 'cancel' => 'لغو شده', 'return' => 'برگشت خورده'); $this->tmpl->assign('status_options', $status_options); $this->tmpl->assign('requests', $ret); $this->reponse->setTitle('سفارشات'); $this->reponse->setTemplate($this->tmpl); }
public function save($con = null) { parent::save($con); $c = new Criteria(); $c->add(QueryResultPeer::RESULT_DATE, $this->getCreatedAt('Y-m-d')); $c->add(QueryResultPeer::QUERY_ID, $this->getQueryId()); $daily = QueryResultPeer::doSelectOne($c); if ($daily) { $daily->setResultSize(($daily->getResultSize() * $daily->getResultCount() + $this->getResultSize()) / ($daily->getResultCount() + 1)); $daily->setResultCount($daily->getResultCount() + 1); } else { $daily = new QueryResult(); $daily->setQueryId($this->getQueryId()); $daily->setResultCount(1); $daily->setResultSize($this->getResultSize()); $daily->setResultDate($this->getCreatedAt('Y-m-d')); } $daily->save(); }
public function getQueryResult(SelectQuery $query, $expires = Cache::DO_NOT_CACHE) { if ($expires !== Cache::DO_NOT_CACHE && ($list = $this->getCachedByQuery($query))) { return $list; } else { $list = $this->fetchList($query); $count = clone $query; $count = DBPool::getByDao($this->dao)->queryRow($count->dropFields()->dropOrder()->limit(null, null)->get(SQLFunction::create('COUNT', '*')->setAlias('count'))); return $this->cacheByQuery($query, $list ? QueryResult::create()->setList($list)->setCount($count['count'])->setQuery($query) : QueryResult::create(), $expires); } }
public function __get($name) { $name = strtolower($name); if (!isset($this->data[$name])) { $old = QueryResult::$returnClass; QueryResult::$returnClass = 'istdClass'; switch ($name) { case 'blogtimezone': $this->data[$name] = 12600; break; case 'blogprofile': $this->data[$name] = false; break; case 'baseurl': $this->data[$name] = ResponseRegistery::getInstance()->baseURL; break; case 'blogid': case 'blogurl': case 'shopurl': case 'blogxmllink': case 'blogauthor': case 'blogemail': case 'blogdescription': case 'blogtitle': case 'blogarchivelink': case 'blogcustomhtml': case 'blogandposttitle': case 'blogphoto': case 'blogphotolink': case 'blogabout': $this->loadBlogInfo(); break; case 'blog': $this->loadPost(); break; case 'blogarchive': $this->loadArchive(); break; case 'bloglinks': case 'bloglinksblock': $this->loadLink(); break; case 'bloglinkdumpblock': case 'bloglinkdump': $this->loadLinkDump(); break; case 'blogcategoriesblock': case 'blogcategories': $this->loadCategory(); break; case 'blogauthorsblock': case 'blogauthors': $this->loadAuthor(); break; case 'blogpreviousitemsblock': case 'blogpreviousitems': $this->loadPreviousItem(); break; case 'blognextandpreviousblock': case 'blogpreviouspageblock': case 'blognextpageblock': $this->loadNextAndPrevious(); break; case 'blogprofilelinkblock': $this->data[$name] = false; break; case 'item': $this->loadItem(); break; case 'frotelitem': $this->loadFrotelItem(); break; case 'item_full': $this->showItem(); break; case 'shopcard': $this->shopCard(); break; default: throw new Exception("code not found {$name}"); } QueryResult::$returnClass = $old; } return $this->data[$name]; }
/** * Retrieves data from specified objects, whether or not they have been deleted. * * @param String $query Query String * @param QueryOptions $queryOptions Batch size limit. OPTIONAL * @return QueryResult */ public function queryAll($query, $queryOptions = NULL) { $this->setHeaders("queryAll"); $raw = $this->sforce->queryAll(array('queryString' => $query))->result; $QueryResult = new QueryResult($raw); $QueryResult->setSf($this); // Dependency Injection return $QueryResult; }
<?php // SOAP_CLIENT_BASEDIR - folder that contains the PHP Toolkit and your WSDL // $USERNAME - variable that contains your Salesforce.com username (must be in the form of an email) // $PASSWORD - variable that contains your Salesforce.com password define("SOAP_CLIENT_BASEDIR", "soapclient"); require_once SOAP_CLIENT_BASEDIR . '/SforcePartnerClient.php'; require_once SOAP_CLIENT_BASEDIR . '/SforceHeaderOptions.php'; require_once 'samples/userAuth.php'; try { $mySforceConnection = new SforcePartnerClient(); $mySoapClient = $mySforceConnection->createConnection(SOAP_CLIENT_BASEDIR . '/partner.wsdl.xml'); $mylogin = $mySforceConnection->login($USERNAME, $PASSWORD); $query = 'Select Name, BillingStreet, BillingCity, BillingState From Account limit 20'; $response = $mySforceConnection->query($query); $queryResult = new QueryResult($response); for ($queryResult->rewind(); $queryResult->pointer < $queryResult->size; $queryResult->next()) { print_r($queryResult->current()); } } catch (Exception $e) { print_r($mySforceConnection->getLastRequest()); echo $e->faultstring; }
<?php include_once '../includes/functions.php'; $get = filter_input_array(INPUT_GET); $records = array(); $date = date('Y-m-d'); $query = "SELECT Id,Name,Event_Series__c,Event_Start_Day__c,Start_Time__c,Venue_Name__c,Event_Ticket_Types_ALL__c FROM Event__c WHERE Event_Start_Day__c >= {$date}"; $response = $mySforceConnection->query($query); $queryResult = new QueryResult($response); for ($queryResult->rewind(); $queryResult->pointer < $queryResult->size; $queryResult->next()) { $record = $queryResult->current(); if ($record->fields->Event_Series__c) { $records[$record->fields->Event_Series__c][] = $record; } else { $records[$record->Id][] = $record; } } ?> <form action="" method="post"> <div class="form-group"> <label>Select Event</label> <select name="event_id" id="eventSelect" class="form-control"> <option>-- Select Event --</option> <?php foreach ($records as $key => $record) { echo '<option value="' . $key . '" ' . ($get['event_id'] == $key ? 'selected' : '') . '>' . $record[key($record)]->fields->Name . '</option>'; } ?> </select> </div> <?php
/** * Create a query result * @param int $id The id of the entity * @param int $lastModified The date of the last modification of the entity. * @param int The id of the entity to which this result is related */ public function __construct($id, $lastModified = null, $relatedTo = null) { parent::__construct($id, $lastModified); $this->relatedTo = $relatedTo; }