public function getBasket()
{
if (strlen($_POST['q']) > 2) {
$data = array();
$sql = '
SELECT {{tree}}.id FROM {{catalog}}
INNER JOIN ({{search}} INNER JOIN {{tree}} ON {{search}}.tree={{tree}}.id)
USING (tree)
WHERE {{search}}.search LIKE \'%' . $_POST['q'] . '%\' AND {{tree}}.visible=1
';
$temp = DB::getAll($sql, 'id');
foreach ($temp as $id) {
$item = Goods::getOne($id);
$item['sizes'] = Goods::getSizes($id);
if ($item['sizes']) {
$data[] = $item;
}
}
return $data;
} else {
return array();
}
}
