<?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'] && $_GET['objectId'] && is_numeric($_GET['objectId'])) {

    $get = clearInputData($_GET);

    $objectId = $get['objectId'];
    $packageId = $get['packageId'];

    $userId = $_SESSION['id'];

    $sqlPackData = "SELECT * from advertising_package WHERE id = $packageId";
    $package = mysql_fetch_assoc(mysql_query($sqlPackData));

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

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

    $logText = "Отправлен на отмену публикации через пакет $package[name] (ID = $packageId)";

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