public function getItemWebsites($item, $default = false) { // support for websites column if set if (!empty($item["websites"])) { if (!isset($this->_wsids[$item["websites"]])) { $this->_wsids[$item["websites"]] = array(); $cws = $this->tablename("core_website"); $wscodes = csl2arr($item["websites"]); $qcolstr = $this->arr2values($wscodes); $rows = $this->selectAll("SELECT website_id FROM {$cws} WHERE code IN ({$qcolstr})", $wscodes); foreach ($rows as $row) { $this->_wsids[$item["websites"]][] = $row['website_id']; } } return $this->_wsids[$item["websites"]]; } if (!isset($item['store'])) { $item['store'] = "admin"; } $k = $item["store"]; if (!isset($this->_wsids[$k])) { $this->_wsids[$k] = array(); $cs = $this->tablename("core_store"); if (trim($k) != "admin") { $scodes = csl2arr($k); $qcolstr = $this->arr2values($scodes); $rows = $this->selectAll("SELECT website_id FROM {$cs} WHERE code IN ({$qcolstr}) AND store_id!=0 GROUP BY website_id", $scodes); } else { $rows = $this->selectAll("SELECT website_id FROM {$cs} WHERE store_id!=0 GROUP BY website_id "); } foreach ($rows as $row) { $this->_wsids[$k][] = $row['website_id']; } } return $this->_wsids[$k]; }
public function getItemWebsites($item) { //use default website if (!isset($item["websites"]) || empty($item["websites"])) { return array($this->_defaultwsid); } else { if (!isset($this->_wsids[$item["websites"]])) { $this->_wsids[$item["websites"]] = array(); $cws = $this->tablename("core_website"); $wscodes = csl2arr($item["websites"]); $qcolstr = $this->arr2values($wscodes); $rows = $this->selectAll("SELECT website_id FROM {$cws} WHERE code IN ({$qcolstr})", $wscodes); foreach ($rows as $row) { $this->_wsids[$item["websites"]][] = $row['website_id']; } } return $this->_wsids[$item["websites"]]; } }