199 lines
6.4 KiB
PHP
Executable File
199 lines
6.4 KiB
PHP
Executable File
<?php
|
||
ini_set('display_errors', 1);
|
||
//проверяем кто мы
|
||
$access = 0;
|
||
if ($_SESSION['dostup'] == 'a')
|
||
$access = 1;
|
||
if ($_SESSION['dostup'] == 'u')
|
||
$access = 1;
|
||
if ($access == 0)
|
||
die("Нет прав");
|
||
|
||
switch (@$_POST['act']) {
|
||
|
||
|
||
case 'saveArendaPrice':
|
||
|
||
|
||
$id=DBMysql::getValue("SELECT `id` FROM `cenaarendy` WHERE `tovar_id`=? LIMIT 1", $_POST['id']);
|
||
|
||
|
||
if ($id) DBmysql::set("UPDATE `cenaarendy` SET `ch4`=?, `ch8`=?, `sut1`=?, `sut2`=?, `sut3`=?, `sut10`=?, `zalog`=?, `cena`=? WHERE `id`=?", [
|
||
$_POST['ch4'],
|
||
$_POST['ch8'],
|
||
$_POST['sut1'],
|
||
$_POST['sut2'],
|
||
$_POST['sut3'],
|
||
$_POST['sut10'],
|
||
$_POST['zalog'],
|
||
$_POST['cena'],
|
||
$_POST['id']
|
||
]);
|
||
else
|
||
DBmysql::add("INSERT INTO `cenaarendy` (`ch4`, `ch8`, `sut1`, `sut2`, `sut3`, `sut10`, `zalog`, `cena`, `tovar_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?,? )",[
|
||
$_POST['ch4'],
|
||
$_POST['ch8'],
|
||
$_POST['sut1'],
|
||
$_POST['sut2'],
|
||
$_POST['sut3'],
|
||
$_POST['sut10'],
|
||
$_POST['zalog'],
|
||
$_POST['cena'],
|
||
$_POST['id']
|
||
]);
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
break;
|
||
|
||
|
||
|
||
|
||
case 'addHar':
|
||
|
||
$json=DBmysql::getValue("SELECT `json` FROM `tovar` WHERE `id`=?", $_POST['tovar_id']);
|
||
$arr=core::j($json);
|
||
$hars=$arr['hars'];
|
||
$h['har']=$_POST['h'];
|
||
$h['txt']=$_POST['txt'];
|
||
if (is_array($hars)){
|
||
array_push ($hars, $h);
|
||
}else{
|
||
$hars[0]=$h;
|
||
}
|
||
|
||
$arr['hars']=$hars;
|
||
|
||
|
||
// print_r($arr);
|
||
$json=core::j($arr);
|
||
|
||
|
||
|
||
echo $json;
|
||
DBmysql::set("UPDATE `tovar` SET `json`=? WHERE `id`=?",[$json, $_POST['tovar_id']]);
|
||
|
||
|
||
break;
|
||
|
||
|
||
case 'save-h':
|
||
if ($_POST['opt'] == 'h')
|
||
\DB::set("UPDATE `tovar_har` SET `txt`=? WHERE `tovar_id`=? AND `id`=? LIMIT 1", array($_POST['txt'], $_POST['tovar_id'], $_POST['id']));
|
||
else
|
||
\DB::set("UPDATE `tovar_har_sp` SET `txt`=? WHERE `id`=? LIMIT 1", array($_POST['txt'], $_POST['id']));
|
||
break;
|
||
|
||
|
||
/* ----------------------------------------------------------------------
|
||
11.11.2023
|
||
Обновляем прайс лист в Json (характеристики товара)
|
||
---------------------------------------------------------------------- */
|
||
|
||
case 'updatePriceJson':
|
||
print_r($_POST);
|
||
//Получаем весь json и переводим в массив
|
||
/*$json=\DB::getValue("SELECT `json` FROM `tovar` WHERE `id`=? LIMIT 1", $_POST['id']);
|
||
$massiv=\json::from_j($json);
|
||
|
||
$price=$massiv['price'];
|
||
print_r($price);
|
||
$i=0;
|
||
|
||
foreach ($price as $key => $value) {
|
||
echo $i . "<br>";
|
||
$har[$i]=$key;
|
||
$val[$i]=$value;
|
||
if ($i==$_POST['n'] && $_POST['m']=='tipCeny') $har[$i]=$_POST['v'];
|
||
if ($i==$_POST['n'] && $_POST['m']=='cena') $val[$i]=$_POST['v'];
|
||
$res[$har[$i]]=$val[$i];
|
||
$i++;
|
||
}
|
||
if ($_POST['n']>$i){
|
||
echo '111111';
|
||
$res[$_POST['v']]=0;
|
||
}
|
||
|
||
//echo $_POST['v'];
|
||
//print_r($res);
|
||
$massiv['price']=$res;
|
||
$json=\json::to_j($massiv);
|
||
\DB::set("UPDATE `tovar` SET `json`=? WHERE `id`=?", array($json, $_POST['id']));
|
||
|
||
//print_r($price);
|
||
//echo $price[0];*/
|
||
break;
|
||
/* ----------------------------------------------------------------------
|
||
15.10.2023
|
||
установка сезонности товара
|
||
---------------------------------------------------------------------- */
|
||
case 'updateSezon':
|
||
$sezon = \DB::getValue("SELECT `sezon` FROM `tovar` WHERE `id`=? LIMIT 1", $_POST['id']);
|
||
$json = \json::from_j($sezon);
|
||
$json[$_POST['mes']] = $_POST['status'];
|
||
$sezon = \json::to_j($json);
|
||
\DB::set("UPDATE `tovar` SET `sezon`=? WHERE `id`=? LIMIT 1", array($sezon, $_POST['id']));
|
||
|
||
|
||
|
||
|
||
break;
|
||
|
||
|
||
|
||
/* ----------------------------------------------------------------------
|
||
06.09.2022
|
||
Загрузка изображений товара
|
||
!!! сделать сверку по md5 и не давать загружать дубли, вместо это привязывать существующую картинку к товару
|
||
!!! проверить не опубликованное - и опубликовать если есть
|
||
---------------------------------------------------------------------- */
|
||
|
||
case 'upload':
|
||
@mkdir('img', 0700);
|
||
@mkdir('img/tovar', 0700);
|
||
@mkdir('img/tovar/' . $_POST['id'], 0700);
|
||
copy($_FILES['file']['tmp_name'], 'img/tovar/' . $_POST['id'] . '/' . $_FILES['file']['name']);
|
||
include_once 'api/php/thumbs-master/thumbs.php';
|
||
$fm = core::genpassword(30);
|
||
$target_mini = 'img/tovar/' . $_POST['id'] . '/' . $fm . "_" . IMG_PRV_W . "_" . IMG_PRV_H . '.jpg';
|
||
$image = new Thumbs('img/tovar/' . $_POST['id'] . '/' . $_FILES['file']['name']);
|
||
$image->thumb(IMG_PRV_W, IMG_PRV_H);
|
||
$image->saveJPG($target_mini);
|
||
unset($image);
|
||
$image = new Thumbs($target_mini);
|
||
$image->saveWEBP('img/tovar/' . $_POST['id'] . '/' . $fm . "_" . IMG_PRV_W . "_" . IMG_PRV_H . '.webp', 90);
|
||
$json=DBmysql::getValue("SELECT `json` FROM `tovar` WHERE `id`=?", $_POST['id']);
|
||
$arr=core::j($json);
|
||
if (is_array($arr['images']))
|
||
array_push ($arr['images'], 'img/tovar/' . $_POST['id'] . '/' . $fm . "_" . IMG_PRV_W . "_" . IMG_PRV_H . '.webp');
|
||
else
|
||
$arr['images'][0]='img/tovar/' . $_POST['id'] . '/' . $fm . "_" . IMG_PRV_W . "_" . IMG_PRV_H . '.webp';
|
||
$json=core::j($arr);
|
||
DBmysql::set("UPDATE `tovar` SET `json`=? WHERE `id`=?", [$json, $_POST['id']]);
|
||
break;
|
||
|
||
case 'del_page':
|
||
unset($_POST['act']);
|
||
$db->del_id('pages', $_POST['id']);
|
||
break;
|
||
|
||
/* ----------------------------------------------------------------------
|
||
07.09.2022
|
||
Удаление фото товара - снятие с публикации
|
||
---------------------------------------------------------------------- */
|
||
|
||
case 'delImg':
|
||
\DB::set("DELETE FROM `tovar_img` WHERE `id`=?", $_POST['id']);
|
||
break;
|
||
|
||
default:
|
||
|
||
}
|
||
?>
|