Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	closest.php
Содержимое	<?php if (date('d-m-Y') == '22-06-2018') { exit('not today'); } if (php_sapi_name() != 'cli') { exit; } ini_set('error_reporting', E_ALL); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); /** * РљСЂРѕРЅ-С„Р°Р№Р» РїРѕРїСѓР»СЏСЂРЅС‹С… РЅРѕРІРѕСЃС‚РµР№ Р·Р° РЅРµРґРµР»СЋ (РґР°Р№РґР¶РµСЃС‚) / require_once (__DIR__ . '/../../app/commands/autoloader.php'); use app\core\helpers\RuDate; /* * РџРѕРїСѓР»СЏСЂРЅС‹Рµ СЃРѕРѕР±С‰РµРЅРёРµ РЅР° С„РѕСЂСѓРјРµ Р·Р° СЃРµРіРѕРґРЅСЏ Рё РІС‡РµСЂР° c.date_ot = ( CURDATE() + INTERVAL 14 DAY ) OR c.date_ot = ( CURDATE() + INTERVAL 3 DAY ) / $sth = $pdo->prepare(' SELECT a., b.id gid, b.name gname, c.id_org, c.id id_act, b.url as group_url, c.date_ot, c.date_do ndate_to, c.date_do, c.canceled_text, c.begin, c.price, IFNULL(d.name, c.place_text) org_name, c.place_text FROM infostrana.afisha_event a LEFT JOIN infostrana.afisha_groups b ON b.id = a.id_grp LEFT JOIN infoorel.afisha_new c ON c.id_activity = a.id LEFT JOIN infoorel.firma d ON d.id = c.id_org WHERE ( c.date_ot = ( CURDATE() + INTERVAL 7 DAY ) OR c.date_ot = ( CURDATE() + INTERVAL 1 DAY )) AND a.id NOT IN (SELECT afisha_id FROM infostrana.afisha_vk WHERE posted = 1 AND posted_date = CURDATE()) ORDER BY c.date_ot DESC LIMIT 1; '); //$sth = $pdo->prepare(' // SELECT a.*, b.id gid, b.name gname, c.id_org, c.id id_act, b.url as group_url, // c.date_ot, c.date_do ndate_to, c.date_do, c.begin, c.price, IFNULL(d.name, c.place_text) org_name, c.place_text // FROM infostrana.afisha_event a // LEFT JOIN infostrana.afisha_groups b ON b.id = a.id_grp // LEFT JOIN infoorel.afisha_new c ON c.id_activity = a.id // LEFT JOIN infoorel.firma d ON d.id = c.id_org // WHERE a.url = "kupi-menya" //'); $sth->execute(); $afishaItems = $sth->fetchAll(); if (empty($afishaItems)) { exit ('its empty'); } $postContent = ''; $attach = []; $afishaItem = $afishaItems[0]; $imageFilePath = __DIR__ . '/../../' . $afishaItem['image_orig']; $link = $infoorelConfig['baseHost'] . '/afisha/' . $afishaItem['group_url'] . "/" . $afishaItem['url'] . '.html'; if (file_exists($imageFilePath)) { $curl = curl_init('https://api.vk.com/method/photos.getWallUploadServer?v=' . $infoorelConfig['posting']['vk']['version'] . '&group_id=' . abs($infoorelConfig['posting']['vk']['group_id']) . '&access_token=' . $infoorelConfig['posting']['vk']['access_token']); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $response = curl_exec($curl); curl_close($curl); $response = json_decode($response); // echo "<pre>"; // var_dump($response); // echo "</pre>"; // // exit(); $uploadUrl = $response->response->upload_url; // Р·Р°РіСЂСѓР¶Р°РµРј РєР°СЂС‚РёРЅРєСѓ $curl = curl_init($uploadUrl); curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, [ 'photo' => '@' . $imageFilePath ]); curl_setopt($curl, CURLOPT_HTTPHEADER, array("Content-type: multipart/form-data")); $response = curl_exec($curl); curl_close($curl); $response = json_decode($response, true); $hash = $response['hash']; $server = $response['server']; if (isset($response['photo'])) { $photoId = json_decode($response['photo'], true)[0]['photo']; // Р·Р°РіСЂСѓР¶Р°РµРј С„РѕС‚Рѕ ////////////////////////////////// $canceledText = ''; if (empty($afishaItem['canceled_text']) == false) { $canceledText = ' \| ' . $afishaItem['canceled_text']; } $postContent = ""; $postContent .= $afishaItem['name'] . $canceledText . "\r\n" . 'РќРµ Р·Р°Р±С‹РІР°Р№С‚Рµ РїСЂРѕ РјР°СЃРѕС‡РЅС‹Р№ СЂРµР¶РёРј Рё СЃРѕС†РёР°Р»СЊРЅСѓСЋ РґРёСЃС‚Р°РЅС†РёСЋ'. "\r\n\r\n"; $dateOt = $afishaItem['date_ot']; if ($afishaItem['date_ot'] == $afishaItem['date_do']) { $period = RuDate::getDate($dateOt); } else { $dateDo = $afishaItem['date_do']; $period = "c " . RuDate::getDate($dateOt) . " РїРѕ " . RuDate::getDate($dateDo); } $orgName = $afishaItem['org_name']; if ($afishaItem['gid'] == 2) { $postContent .= $afishaItem['org_name'] . ": " . $period . "\r\n"; $postContent .= "РЎРµР°РЅСЃС‹: " . $afishaItem['begin'] . "\r\n"; $postContent .= "Р’СЂРµРјСЏ СЃРµР°РЅСЃРѕРІ СѓС‚РѕС‡РЅСЏР№С‚Рµ РїРѕ С‚РµР»РµС„РѕРЅР°Рј РєРёРЅРѕС‚РµР°С‚СЂРѕРІ." . "\r\n"; } else { // if (mb_strlen($afishaItem['org_name'], 'UTF-8') > 50 && mb_strlen($afishaItem['org_name'], 'UTF-8') <= 75) { // $orgName .= "\r\n"; // } else { // $orgName .= " "; // } $when = ""; if (strlen($afishaItem['begin'])) $when = " РІ " . $afishaItem['begin']; $postContent .= "РљРѕРіРґР°: " . $period . $when . "\r\n" . "Р“РґРµ: " . $orgName . "\r\n"; } $postContent .= "\r\n" . "РџРѕРґСЂРѕР±РЅРµРµ:" . "\r\n"; $postContent .= $link; ///////////////////////////////////////////////////////// $curl = curl_init('https://api.vk.com/method/photos.saveWallPhoto?group_id=' . abs($infoorelConfig['posting']['vk']['group_id']) . '&photo=' . $response['photo'] . '&server=' . $response['server'] . '&hash=' . $response['hash'] . '&caption=' . urlencode($postContent) . '&v=' . $infoorelConfig['posting']['vk']['version'] . '&access_token=' . $infoorelConfig['posting']['vk']['access_token']); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $response = curl_exec($curl); $response = json_decode($response); curl_close($curl); // echo "<pre>"; // var_dump($response); // echo "</pre>"; // // exit(); $afishsVkInsertedId = $pdo->lastInsertId(); $attach[] = 'photo' . $response->response[0]->owner_id . '_' . $response->response[0]->id; $request_params = [ 'access_token' => $infoorelConfig['posting']['vk']['access_token'], 'owner_id' => $infoorelConfig['posting']['vk']['group_id'], 'from_group' => '1', 'message' => $postContent, 'attachments' => implode(',', $attach), 'v' => $infoorelConfig['posting']['vk']['version'] ]; $get_params = http_build_query($request_params); $result = json_decode(file_get_contents('https://api.vk.com/method/wall.post?'. $get_params)); $sth = $pdo ->prepare(' INSERT INTO `infostrana`.`afisha_vk` (afisha_id, posted, posted_date) VALUES (:afisha_id, 1, NOW()) '); $sth->execute([ ':afisha_id' => $afishaItem['id'] ]); } } echo "Afisha sended";

/cron/afisha/

Имя	Дата	Размер
..	2026-10-02
checker.php	2018-06-22	3 кб.
closest.php	2021-09-13	7 кб.
closest.php~	2020-12-21	7 кб.

/cron/afisha