116 lines
5.4 KiB
PHP
Executable File
116 lines
5.4 KiB
PHP
Executable File
<?php
|
|
ini_set('display_errors', 1 );
|
|
switch(@$_POST['act']) {
|
|
|
|
|
|
case 'delimg':
|
|
|
|
|
|
|
|
if (class_exists('DBmysql')) {
|
|
|
|
|
|
$imgs=\DBmysql::getAll("SELECT `filename` FROM `img` WHERE `content_id`=? AND `content_type`=? AND `site`=?", array(
|
|
$_POST['id'], 'tovar', $_SERVER['SERVER_NAME']
|
|
));
|
|
|
|
$c=count($imgs);
|
|
for ($i=0; $i<$c; $i++){
|
|
unlink('img/' . $_SERVER['SERVER_NAME'] . '/tovar/' . $_POST['id'] . '/' . $imgs[$i]['filename'] . '.jpg');
|
|
unlink('cache/img/' . $imgs[$i]['filename'] . '.webp');
|
|
}
|
|
\DBmysql::set("DELETE FROM `img` WHERE `content_id`=? AND `content_type`=? AND `site`=?", array(
|
|
$_POST['id'], 'tovar', $_SERVER['SERVER_NAME']
|
|
));
|
|
|
|
}else{
|
|
|
|
$imgs=\DB::getAll("SELECT `filename` FROM `img` WHERE `content_id`=? AND `content_type`=? AND `site`=?", array(
|
|
$_POST['id'], 'tovar', $_SERVER['SERVER_NAME']
|
|
));
|
|
|
|
$c=count($imgs);
|
|
for ($i=0; $i<$c; $i++){
|
|
unlink('img/' . $_SERVER['SERVER_NAME'] . '/tovar/' . $_POST['id'] . '/' . $imgs[$i]['filename'] . '.jpg');
|
|
unlink('cache/img/' . $imgs[$i]['filename'] . '.webp');
|
|
}
|
|
\DB::set("DELETE FROM `img` WHERE `content_id`=? AND `content_type`=? AND `site`=?", array(
|
|
$_POST['id'], 'tovar', $_SERVER['SERVER_NAME']
|
|
));
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
break;
|
|
|
|
|
|
case 'moveTovar':
|
|
if ($_SERVER["REMOTE_ADDR"]=='90.151.129.251' || $_SERVER["REMOTE_ADDR"]=='46.165.16.184' ) {
|
|
\DB::set("UPDATE `tovar` SET `category`=? WHERE `id`=?", array($_POST['cat_id'], $_POST['id']));
|
|
}
|
|
break;
|
|
|
|
case 'DontPublic':
|
|
if ($_SERVER["REMOTE_ADDR"]=='90.151.129.251' || $_SERVER["REMOTE_ADDR"]=='46.165.16.184' || $_SESSION['dostup']=='a') {
|
|
\DB::set("UPDATE `tovar` SET `status`=? WHERE `id`=?", array($_POST['status'], $_POST['id']));
|
|
}
|
|
break;
|
|
|
|
/* ----------------------------------------------------------------------
|
|
27.02.2023
|
|
Добавляем коментарий
|
|
---------------------------------------------------------------------- */
|
|
case 'addComment':
|
|
if ($_SESSION['user_id'])\DB::add("INSERT INTO `tovar_otzyv` (`user_id`, `txt`, `t`, `tovar_id`) VALUES (?, ?, ?, ?)", array( $_SESSION['user_id'], nl2br( $_POST['txt'] ), time(), $_POST['tovar_id'] ));
|
|
break;
|
|
|
|
/* ----------------------------------------------------------------------
|
|
17.12.2022
|
|
Создаем докмент переоценки + запись в регистр tovar_price_history
|
|
20.12.2022
|
|
Товары идут в двухмерный массив
|
|
---------------------------------------------------------------------- */
|
|
case 'addChangeCena':
|
|
$massiv[0]['tovar_id']=$_POST['id'];
|
|
$massiv[0]['cena']=$_POST['txt'];
|
|
$json=\json::to_j($massiv);
|
|
$insert_id = \DB::add( "INSERT INTO `docs` (`t`, `tip`, `json`, `user_id`, `status`, `comment`) VALUES('" . time() . "', 'pereocenka', ?, ?, 1, 'Документ создан из публичной карточки товара')", array($json, $_SESSION['user_id']) );
|
|
if ($insert_id) \DB::add( "INSERT INTO `tovar_price_history` (`t`, `tovar_id`, `status`, `cena`, `docs_id`) VALUES(?, ?, ?, ?, ?)", array( time(), $_POST['id'], '1', $_POST['txt'], $insert_id ) );
|
|
break;
|
|
/* ----------------------------------------------------------------------
|
|
17.12.2022
|
|
Добавляем товар в корзину
|
|
!!! в JS и ACT переделать pages_id на tovar_id !!!
|
|
---------------------------------------------------------------------- */
|
|
case 'addToCart':
|
|
$cena=\DBmysql::getValue("SELECT `cena` FROM `tovar` WHERE `id`=? LIMIT 1", $_POST['pages_id']);
|
|
if (!$cena)die("Товар без цены");
|
|
$session_id = \core::checkMe();
|
|
//Получаем количество, если есть...
|
|
// echo $session_id;
|
|
$kolvo = \DBmysql::getValue( "SELECT `kolvo` FROM `cart` WHERE `user_id`=? AND `tovar_id`=? AND `order` IS NULL AND `site`=?", [$session_id, $_POST['pages_id'], $_SERVER['SERVER_NAME']] );
|
|
//echo $kolvo;
|
|
if ($kolvo){
|
|
$kolvo+=$_POST['kolvo'];
|
|
\DBmysql::set("UPDATE `cart` SET `kolvo`=? WHERE `user_id`=? AND `tovar_id`=? AND `site`=?", [$kolvo, $session_id, $_POST['pages_id'], $_SERVER['SERVER_NAME'] ]);
|
|
}else{
|
|
$insert_id = \DBmysql::add( "INSERT INTO `cart` (`t`, `tovar_id`, `user_id`, `kolvo`, `site`) VALUES(?, ?, ?, ?, ?)", [time(), $_POST['pages_id'], $session_id, $_POST['kolvo'], $_SERVER['SERVER_NAME']] );
|
|
}
|
|
|
|
|
|
//Суммируем содержимое корзины и выводим в js
|
|
$summ = 0;
|
|
$cart = \DBmysql::getAll( "SELECT `tovar_id`, `kolvo` FROM `cart` WHERE `user_id`=? AND `order` IS NULL AND `site`=?", [$session_id, $_SERVER['SERVER_NAME']] );
|
|
for ( $i=0; $i<count( $cart ); $i++ ){
|
|
$cena = \DBmysql::getValue( "SELECT `cena` FROM `tovar` WHERE `id`=? LIMIT 1", $cart[$i]['tovar_id'] );
|
|
$m = $cena * $cart[$i]['kolvo'];
|
|
$summ += $m;
|
|
}
|
|
echo $summ;
|
|
break;
|
|
default:
|
|
}
|
|
?>
|