public function getContent()
{
$action = Core_Tools::getInput('_GET', 'action', 'varchar', false);
$shop = Profile_Shop::getShop(Core_Tools::getInput('_GET', 'id', 'int'));
$myself = Profile_Member::getMyself();
if ($action == 'add') {
return $this->getAddShop();
} elseif ($action == 'manage' && $shop->isFound() && $myself && $shop->canModerate($myself)) {
return $this->getShopManagement($shop);
} elseif ($action == 'moderator' && $shop->isFound() && $myself && $shop->canModerate($myself)) {
return $this->getModeratorManagement($shop);
} elseif ($action == 'categories' && $shop->isFound() && $myself && $shop->canModerate($myself)) {
return $this->getManageCategories($shop);
} elseif ($shop->isFound()) {
return $this->getOverview($shop);
} else {
return '<p>Invalid input.</p>';
}
}
public function getPendingOrders()
{
$db = Core_Database::__getInstance();
$l = $db->getDataFromQuery($db->customQuery("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\torders o\n\t\t\tLEFT JOIN\n\t\t\t\torder_prods op ON o.o_id = op.o_id\n\t\t\tWHERE\n\t\t\t\top.plid = '" . (int) $this->getId() . "'\n\t\t\t\tAND o.o_isDone = '0'\n\t\t"));
$o = array();
foreach ($l as $v) {
$shop = Profile_Shop::getShop($v['s_id']);
$company = Profile_Company::getCompany($v['c_id']);
$o[] = array($shop->getProduct($v['p_id']), $v, $company, $shop);
}
return $o;
}
public function getShops()
{
$db = Core_Database::__getInstance();
$l = $db->select('companies_shop', array('*'), "c_id = '" . $db->escape($this->getId()) . "'");
$o = array();
foreach ($l as $v) {
$o[] = Profile_Shop::getShop($v['s_id']);
}
return $o;
}
public function getGoogleContent()
{
$db = Core_Database::__getInstance();
$shop = Core_Tools::getInput('_GET', 'sid', 'int', false);
if ($shop > 0) {
// Show all products of this shop
$shop = Profile_Shop::getShop($shop);
if ($shop) {
$shop_page = new Pages_Shop();
return $shop_page->getOverview($shop);
}
}
// Show a list of all shops.
$page = new Core_Template();
$data = $db->select('shops', array('*'), null, 's_name ASC');
foreach ($data as $v) {
$page->addListValue('shops', array('name' => Core_Tools::output_varchar($v['s_name']), 'url' => self::getUrl('page=order&sid=' . $v['s_id']), 'location' => Core_Tools::output_varchar($v['s_gemeente'])));
}
return $page->parse('google_shops.phpt');
}
