98 lines
2.8 KiB
PHP
Executable File
98 lines
2.8 KiB
PHP
Executable File
<?php
|
||
|
||
|
||
|
||
require_once 'api/soft/phpQuery-master/phpQuery/phpQuery.php';
|
||
|
||
function delRub($text){
|
||
|
||
$old1 = array(" руб.", " ");#Ищем вредное ">",, "<"^M
|
||
|
||
$new1 = array("", "");#Меняем на полезное">", , "<"^M
|
||
|
||
$text = str_replace($old1, $new1, $text);#Собсно сама замена =)^M
|
||
|
||
return $text; }#Возвращение результата наших извращений =)^M
|
||
|
||
|
||
|
||
$html_leo = \core::get_page($tovar['donor']);
|
||
$doc = phpQuery::newDocument($html_leo['html']);
|
||
|
||
|
||
$cena1 = $doc->find('.catalog-detail-item-price-current');
|
||
$cena1= trim(delRub( pq($cena1)->text()));
|
||
if ($cena1){
|
||
$cena=round($cena1*1.7, 0);
|
||
|
||
$mydebug['cenasql']="UPDATE `tovar` SET `cena`='" . $cena . "' WHERE `id`=" . $tovar['id'];
|
||
\DB::set($mydebug['cenasql']);
|
||
|
||
$mydebug['cena']=$cena1;
|
||
$mydebug['cenaProdazh']=$cena;
|
||
}else{
|
||
$mydebug['cenasql']="UPDATE `tovar` SET `status`=0 WHERE `id`=" . $tovar['id'];
|
||
\DB::set($mydebug['cenasql']);
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
$img = $doc->find('a.catalog-detail-images');
|
||
$img= 'https://nizhniy-tagil.leader-t.ru' . pq($img)->attr('href');
|
||
//var_dump($img);
|
||
$mydebug['img']= $img;
|
||
|
||
if ($img){$mydebug['imgsql']="UPDATE `tovar` SET `linkimg`='" . $img . "' WHERE `id`=" . $tovar['id'];
|
||
\DB::set($mydebug['imgsql']);
|
||
}
|
||
|
||
//Узнаем, есть загруженная картинка
|
||
$idimg=\DB::getValue("SELECT `id` FROM `tovar_img` WHERE `tovar_id`=?", $tovar['id']);
|
||
if (!$idimg){
|
||
|
||
|
||
$filename=\core::genpassword(30);
|
||
exec("wget " . $img . " -O /home/cloud/core/img/tk-ligat.ru/tovar/" . $filename . ".jpg");
|
||
\DB::add("INSERT INTO `tovar_img` (`filename`,`tovar_id`) VALUES (?,?)", array($filename, $tovar['id']));
|
||
|
||
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
//if ($cena1){
|
||
//$cena1 = round($cena1 * 1.5, 2);
|
||
//$old_cena=$tovar['cena'];
|
||
//if ($cena1<$old_cena) \DB::set("UPDATE `tovar` SET `cena`=?, `old_cena`=?, `status`=1 WHERE `id`=? LIMIT 1", array($cena1, $old_cena, $_GET['id']));
|
||
//if (!$old_cena) \DB::set("UPDATE `tovar` SET `cena`=?, `status`=1 WHERE `id`=? LIMIT 1", array($cena1, $_GET['id']));
|
||
//}else{
|
||
//\DB::set("UPDATE `tovar` SET `status`=0 WHERE `id`=? LIMIT 1", $_GET['id']);
|
||
//}
|
||
//Проверяем наличие картинки
|
||
//$imgID=\DB::getValue("SELECT `id` FROM `tovar_img` WHERE `tovar_id`=?", $_GET['id']);//ОПТИМИЗИРОВАТЬ!!!
|
||
//if (!$imgID){
|
||
//$filename=\core::genpassword(30);
|
||
//exec("wget " . $tovar['linkimg'] . " -O /home/cloud/core/img/tk-ligat.ru/leopak/" . $filename . ".jpg");
|
||
//symlink("/home/cloud/core/img/tk-ligat.ru/leopak/" . $filename . ".jpg", "/home/cloud/core/img/tk-ligat.ru/tovar/" . $filename . ".jpg");
|
||
//\DB::add("INSERT INTO `tovar_img` (`tovar_id`, `filename`) VALUES (?, ?)", array($_GET['id'], $filename));
|
||
//}
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
$smarty->assign('debug', $mydebug);
|
||
?>
|