96 lines
4.8 KiB
PHP
Executable File
96 lines
4.8 KiB
PHP
Executable File
<?php
|
|
ini_set('display_errors', 0 );
|
|
switch(@$_POST['act']) {
|
|
|
|
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' ) {
|
|
\DB::set("UPDATE `tovar` SET `status`=? WHERE `id`=?", array($_POST['status'], $_POST['id']));
|
|
}
|
|
break;
|
|
/* ----------------------------------------------------------------------
|
|
04.02.2024
|
|
Получаем цену
|
|
---------------------------------------------------------------------- */
|
|
case 'getPriceHars':
|
|
echo \DB::getValue("SELECT `cena` FROM `price_hars` WHERE `id`=?", $_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':
|
|
|
|
if ($_COOKIE['token']){
|
|
$token=$_COOKIE['token'];
|
|
}else{
|
|
$token=\core::genpassword(40);
|
|
$tri_mes = time() + 31536000;
|
|
setcookie('token', $token, $tri_mes, '/', $_SERVER['SERVER_NAME']);
|
|
}
|
|
|
|
|
|
$cena=\DB::getValue("SELECT `cena` FROM `tovar` WHERE `id`=? LIMIT 1", $_POST['pages_id']);
|
|
|
|
if (!$cena)die("Товар без цены");
|
|
|
|
|
|
$session_id = \core::checkMe();
|
|
//Получаем количество, если есть...
|
|
$kolvo = \DB::getValue( "SELECT `kolvo` FROM `cart` WHERE `user_id`=? AND `tovar_id`=? AND `order` IS NULL AND `site`=? AND `token`=?", array( $session_id, $_POST['pages_id'], $_SERVER['SERVER_NAME'], $token ) );
|
|
if ($kolvo){
|
|
$kolvo=$kolvo+$_POST['kolvo'];
|
|
\DB::set("UPDATE `cart` SET `kolvo`=? WHERE `user_id`=? AND `tovar_id`=? AND `site`=? AND `token`=?", array( $kolvo, $session_id, $_POST['pages_id'], $_SERVER['SERVER_NAME'], $token ) );
|
|
}else{
|
|
|
|
|
|
|
|
if ($_POST['option'])
|
|
$insert_id = \DB::add( "INSERT INTO `cart` (`t`, `tovar_id`, `user_id`, `kolvo`, `option`, `site`, `token`) VALUES(?, ?, ?, ?, ?, ?, ?)", array(time(), $_POST['pages_id'], $session_id, $_POST['kolvo'], $_POST['option'], $_SERVER['SERVER_NAME'], $token) );
|
|
else
|
|
$insert_id = \DB::add( "INSERT INTO `cart` (`t`, `tovar_id`, `user_id`, `kolvo`, `site`, `token`) VALUES(?, ?, ?, ?, ?, ?)", array(time(), $_POST['pages_id'], $session_id, $_POST['kolvo'], $_SERVER['SERVER_NAME'], $token ) );
|
|
}
|
|
|
|
|
|
//Суммируем содержимое корзины и выводим в js
|
|
$summ = 0;
|
|
$cart = \DB::getAll( "SELECT `tovar_id`, `kolvo` FROM `cart` WHERE `user_id`=? AND `order` IS NULL AND `site`=? AND `token`=?", array($session_id, $_SERVER['SERVER_NAME'], $token) );
|
|
for ( $i=0; $i<count( $cart ); $i++ ){
|
|
$cena = \DB::getValue( "SELECT `cena` FROM `tovar` WHERE `id`=? LIMIT 1", $cart[$i]['tovar_id'] );
|
|
$m = $cena * $cart[$i]['kolvo'];
|
|
$summ = $summ + $m;
|
|
}
|
|
echo $summ;
|
|
break;
|
|
default:
|
|
}
|
|
?>
|