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