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;
}
