File size: 8.56Kb
<?
include_once ('../../system/function.php');
$title = 'Магазин';
include_once ('../../system/header.php');
if(!isset($user['id'])) {
header('Location: / ');
exit;
}
$id = abs(intval($_GET['id']));
$dir = mysql_fetch_assoc(mysql_query("SELECT * FROM `shop_dir` WHERE `id` = '".$id."'"));
$act = isset($_GET['act']) ? $_GET['act'] : null;
switch($act) {
default:
echo '<div class="title">Магазин</div>
<div class="podmenu"><a href="/Shop/Search">Поиск</a></div>
<div class="podmenu"><a href="/Shop/New">Новые</a></div>
<div class="podmenu"><a href="/Shop/Discount">Новая цена</a></div>';
echo '<div class="title">Разделы</div>';
$dirs = mysql_query("SELECT * FROM `shop_dir`");
while ($a = mysql_fetch_assoc($dirs)){
$kats = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_kat` WHERE `dir` = '".$a['id']."' "),0);
$countg = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `dir` = '".$a['id']."'"),0);
$newf = mysql_result(mysql_query("SELECT count(`id`) FROM `shop_good` WHERE `dir` = '".$a['id']."' and `time` > '".(time()-((60*60)*24))."'"),0);
echo '<div class="podmenu"><img src="/images/icons/grid.png" height="20" alt="*">
<a href="/Shop/Dir'.$a['id'].'">'.$a['name'].' | Категории ['.$kats.'] / Товары ['.$countg.' + <font color="red">'.$newf.'</font>]</br>
<small>'.$a['text'].'</small></a>';
if($user['level'] == 4){
echo'</br></br><a href="/Shop/Adm/R/D'.$a['id'].'">[Удалить]</a> | <a href="/Shop/Adm/R/E'.$a['id'].'">[Изменить]</a>';
}
echo'</div>';
}
if($user['level'] == 4){
echo '<div class="podmenu"><a href="Shop/Adm/Add_r">Добавить раздел</a></div>';
}
echo '<div class="title">Моя панель</div>
<div class="podmenu"><a href="/Shop/My"> Мои товары</a></div>
<div class="podmenu"><a href="/modules/shop/good.php?act=byeds"> Купленные</a></div>
<div class="podmenu"><a href="/Shop/Cart"> Корзина</a></div>
<div class="podmenu"><a href="/Shop/Vants"> Мои желания</a></div>';
break;
case 'search':
echo '<div class="title"><a href="/Shop">Магазин</a> | Поиск </div>';
if(isset($_SESSION['err'])){
echo '<div class="podmenu"><font color="red"><b><i>'.$_SESSION['err'].'</i></b></font></div>';
}
unset($_SESSION['err']);
echo '<form action="" method="POST"><div class="podmenu">Вводите
<select name="kret">
<option value="name">Название</option>
<option value="text">Описание</option>
</select>
</div>
<div class="podmenu">
*Название файлы:<br /><input type="text" name="met" maxlength="100" /><br />
<input type="submit" name="ok" value="Искать" />
</form></div>';
if(isset($_REQUEST['ok'])) {
$met = strong($_POST['met']);
$kret = strong($_POST['kret']);
if(empty($met)) {
$_SESSION['err'] = 'Заполните поле';
header('Location: ?');
exit;
}
if(strlen($met) < 2 or mb_strlen($met) > 100) {
$_SESSION['err'] = 'Длина запроса от до 100 символов';
header('Location: ?');
exit;
}
echo '<div class="menu">Результаты поиска:</div>';
var_dump($kret);
$search = mysql_query("SELECT * FROM `shop_good` where ".$kret." LIKE '%".$met."%' ORDER BY `time` DESC ");
$sql = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` where ".$kret." LIKE '%".$met."%' "),0);
while($s = mysql_fetch_assoc($search)){
$array = explode(" ", $s['text']);
$text_num = array_slice($array, 0, 20);
$text_v = implode(" ", $text_num);
$text_v .= '...';
echo '
<div class="podmenu"><img src="/images/icons/template.png" height="20" alt="*">
<a href="/Shop/Good'.$s['id'].'">'.$s['name'].'|
Цена: [<font color="green">'.$s['cost'].'</font>] R</a></br>
Продавец: '.nick($s['saller']).'</br>
<div class="news">'.bb(smile($text_v)).'</div></div>';
}}
if($sql == 0)
echo '<div class="podmenu"><center><b>Тут ничего нет!</b></center></div>';
break;
case 'new':
echo '<div class="title"><a href="/Shop">Магазин</a> | Новые товары </div>';
if (empty($user['max'])) $user['max'] = 10;
$max = $user['max'];
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `time` > '".(time()-((60*60)*24))."'"),0);
$k_page = k_page($k_post, $max);
$page = page($k_page);
$start = $max * $page - $max;
$good = mysql_query("SELECT * FROM `shop_good` Where `time` > '".(time()-((60*60)*24))."' ORDER BY `time` DESC LIMIT $start, $max");
while($a = mysql_fetch_assoc($good)){
echo '<div class="podmenu"><img src="/images/icons/template.png" height="20" alt="*">
<a href="/Shop/Good'.$a['id'].'">'.$a['name'].' |
Цена: [<font color="green">'.$a['cost'].'</font>] рублей </br>
Продавец: '.nick($a['saller']).'</br>
Описание: '.bb(smile($a['text'])).'
</div>';
}
if ($k_post < 1) echo '<div class="podmenu"><b><center>Пусто!</center></b></div>';
if ($k_page > 1) echo str('' . $HOME . '/Shop/New?', $k_page, $page); // Вывод страниц
break;
case 'disc':
echo '<div class="title"><a href="/Shop">Магазин</a> | Товары со скидкой </div>';
if (empty($user['max'])) $user['max'] = 10;
$max = $user['max'];
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `discont` != '0' and `cost` != `discont`"),0);
$k_page = k_page($k_post, $max);
$page = page($k_page);
$start = $max * $page - $max;
$good = mysql_query("SELECT * FROM `shop_good` Where `discont` != '0' and `cost` != `discont` ORDER BY `time` DESC LIMIT $start, $max");
while($a = mysql_fetch_assoc($good)){
echo '<div class="podmenu"><img src="/images/icons/template.png" height="20" alt="*">
<a href="/Shop/Good'.$a['id'].'">'.$a['name'].' |
Цена: Старая [<font color="green"><s>'.$a['cost'].'</s></font>] |
Новая [<font color="green">'.$a['discont'].'</font>] рублей </br>
Продавец: '.nick($a['saller']).'</br>
Описание: '.bb(smile($a['text'])).'</div>';
}
if ($k_post < 1) echo '<div class="podmenu"><b><center>Пусто!</center></b></div>';
if ($k_page > 1) echo str('' . $HOME . '/Shop/Discount?', $k_page, $page); // Вывод страниц
break;
case 'dir':
if(!$dir){
header("Location: / ");
exit;
}
echo '<div class="title"><a href="/Shop">Магазин</a> | '.$dir['name'].' </div>';
if($user['level'] == 4){
echo '<div class="podmenu"><a href="/Shop/Add_Kat'.$id.'">Создать категорию</a></div>';
}
$kats = mysql_query("SELECT * FROM `shop_kat` WHERE `dir` = '".$id."'");
while($a = mysql_fetch_assoc($kats)){
$countg = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `kat` = '".$a['id']."'"),0);
$newf = mysql_result(mysql_query("SELECT count(`id`) FROM `shop_good` WHERE `kat` = '".$a['id']."' and `time` > '".(time()-((60*60)*24))."'"),0);
echo '
<div class="podmenu"><img src="/images/icons/grid.png" height="20" alt="*">
<a href="/Shop/Kat'.$a['id'].'">'.$a['name'].' ['.$countg.' + <font color="red">'.$newf.'</font>]';
if($user['level'] == 4){
echo' | <a href="/Shop/Del_Kat'.$a['id'].'">[Удалить]</a> | <a href="/Shop/Edit_Kat'.$a['id'].'">[Изменить]</a>';
}
echo'</div>';
}
break;
case 'kat':
$kat = mysql_fetch_assoc(mysql_query("SELECT * FROM `shop_kat` WHERE `id` = '".$id."'"));
if(!$kat){
header("Location: / ");
exit;
}
$di = mysql_fetch_assoc(mysql_query("SELECT * FROM `shop_dir` WHERE `id` = '".$kat['dir']."'"));
echo '<div class="title"><a href="/Shop">Магазин</a> | <a href="/Shop/Dir'.$kat['dir'].'">'.$di['name'].' </a> | '.$kat['name'].' </div>';
echo '<div class="podmenu"><a href="/Shop/Add_Good'.$id.'">Добавить товар</a></div>';
$countg = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `kat` = '".$id."'"),0);
if (empty($user['max'])) $user['max'] = 10;
$max = $user['max'];
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `shop_good` WHERE `kat` = '".$id."'"),0);
$k_page = k_page($k_post, $max);
$page = page($k_page);
$start = $max * $page - $max;
$good = mysql_query("SELECT * FROM `shop_good` Where `kat` = '".$id."' ORDER BY `time` DESC LIMIT $start, $max");
while($a = mysql_fetch_assoc($good)){
echo '<div class="podmenu"><img src="/images/icons/template.png" height="20" alt="*">
<a href="/Shop/Good'.$a['id'].'">'.$a['name'].' | Цена: [<font color="green">'.$a['cost'].'</font>] рублей </div>';
}
if ($k_post < 1) echo '<div class="podmenu"><b><center>Пусто!</center></b></div>';
if ($k_page > 1) echo str('' . $HOME . '/Shop/Kat'.$id.'?', $k_page, $page); // Вывод страниц
break;
}
include_once ('../../system/footer.php');