<?php

require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");

ini_set('display_errors', 1);
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);

if ($_SESSION['id'] && $_POST['objectId'] && is_numeric($_POST['objectId'])) {

    $post = clearInputData($_POST);

    $objectId = $post['objectId'];
    $userId = $_SESSION['id'];

    $sql = "SELECT count(id) FROM zipal_objects WHERE zipal_id is not null and object_id = $objectId";
    $rez = mysql_query($sql);
    $count = mysql_result($rez,0);

    //если объект уже был отправлен, то распубликовываем, иначе удаляем
    if ($count > 0) {
        $sql = "UPDATE zipal_objects SET sended = 1, published = 1, unpublish = 1, unpublish_user_id = $userId WHERE object_id = $objectId";
        mysql_query($sql);
    } else {
        $sql = "DELETE from zipal_objects WHERE object_id = $objectId";
        mysql_query($sql);
    }

    $sql = "UPDATE objects
            SET use_in_advert = IF(
                    add_to_bn_feed = 0 AND
                    add_to_yandex_feed = 0 AND
                    add_to_domclick_feed = 0 AND
                    add_to_avito_feed = 0 AND
                    add_to_emls_feed = 0 AND
                    add_to_cian_feed = 0, 0, 1),
                add_to_zipal=0,
                is_main = 0
            WHERE id=$objectId";

    mysql_query($sql);

    $logText = "Отправлен на отмену публикации через кнопку С отчетами";

    $sqlLog = "INSERT INTO object_publish_log(object_id, created_at, user_id, log_text) VALUES ('$objectId', NOW(), '$userId', '$logText')";
    mysql_query($sqlLog);
}