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