<?php
require_once 'custom/modules/Realty/send_presentation.php';
$file = GeneratePresentation($_GET['id']);
if (file_exists("{$file}")) {
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . basename("{$file}")) . '"';
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize("{$file}"));
ob_clean();
flush();
readfile("{$file}");
exit;
}
$emails = array();
$realty_id = $_GET['id'];
$realty = new Realty();
$realty->retrieve($realty_id);
$my_user_id = $current_user->id;
$rec = new Request();
$sql_c = "SELECT request_id FROM realty_requests_interest_table WHERE presentation_checked=1 AND realty_id = '" . $realty_id . "' AND deleted = 0";
$result_c = $db->query($sql_c);
while ($row_c = $db->fetchByAssoc($result_c)) {
$rec->retrieve($row_c['request_id']);
$parent_id = $rec->parent_id;
$sqlemail = "SELECT email_addresses.email_address \n\t\t\tFROM email_addresses\n\t\t\tLEFT JOIN email_addr_bean_rel ON email_addr_bean_rel.email_address_id = email_addresses.id AND email_addr_bean_rel.deleted = 0\n\t\t\tWHERE email_addresses.deleted = 0 \n\t\t\tAND bean_id = '{$parent_id}' ";
$resultemail = $db->query($sqlemail);
$rowemail = $db->fetchByAssoc($resultemail);
$emails[] = $rowemail['email_address'];
$pdf = GeneratePresentation($realty_id);
$body = " \n\tС уважением<br/>\n\t{$current_user->last_name} {$current_user->first_name},<br/>\n\tКомпания 'Агентство Недвижимости'<br/>\n\t<br/>\n\tКонтактный тел.<br/>\n\tофисный: 8(945) 1234567;<br/>\n\tмобильный:\t8(945) 1234567;<br/>\n\t{$sugar_config['site_url']}<br/>\n\t<strong style='font-family:Arial,Tahoma,Verdana,sans-serif;font-size:12.800000190734863px;color:red'>Важно! Ответ присылайте на почту:</strong><a target='_blank' href='mailto:{$ass->email1}>{$ass->email1}</a><br/>\n\t";
$nameToSendArr = explode("/", $pdf);
$nameToSend = $nameToSendArr[5];
$file_name = $pdf;
$result2 = sendSugarPHPMail($emails, 'Презентация ', $body, $file_name, $nameToSend, $my_user_id, 'Realty');
//Realty
if ($result2) {
echo "<span style='color: green; font-size: 14px'>Письмо отправлено</span>";
} else {
echo "<span style='color: red; font-size: 14px'>Что-то пошло не так. Обратитесь к администратору!</span>";
}
echo "Ссылка для скачивания презентации - <a href='{$pdf}'>{$pdf}</a><br/>";
$db1 = DBManagerFactory::getInstance();
$sql2 = "UPDATE realty_requests_interest_table\n\t\t\tSET presentation_checked = 0, presentation_text = 'Презентация отправлена'\n\t\t\tWHERE realty_id = '{$realty_id}'";
$db1->query($sql2);
<?php
require_once 'custom/include/fpdf17/fpdf.php';
require_once "custom/send_mail.php";
// require_once('custom/sms/sms.php');
require_once 'custom/Presentation/generate.php';
global $sugar_config, $db;
echo "<h3>Генерация презентации</h3><br/>";
$realty = new Realty();
$realty->retrieve($_GET['id']);
$pdf = GeneratePresentation($_GET['id']);
echo " <br/><b>Ссылка для скачивания презентации - <a href='{$pdf}'>{$pdf}</a></b><br/>";
$sql = "SELECT account_id FROM realty_accounts_m_to_m_table WHERE presentation_checked=1 AND realty_id = '{$_GET['id']}' AND deleted = 0";
$result = $db->query($sql);
while ($row = $db->fetchByAssoc($result)) {
$emails = array();
$account = new Account();
$account->retrieve($row['account_id']);
$assigned_user_id = $account->assigned_user_id;
$ass = new User();
$ass->retrieve($assigned_user_id);
//----- сбор ответственных для аккаунтов
// $j = 0;
// $assigned['accounts'][$j]['email'] = $account->id;
// $assigned['accounts'][$j]['assigned_user_id'] = $account->assigned_user_id;
// $j++;
// --------------------------------------
/*$assigned_user_id = $account->assigned_user_id;
$sms = new sms();
$sms->retrieve_settings();
$resp = $sms->send_message($ass->phone_mobile, 'Презентация отправлена');
$contact = new Contact();
$contact->retrieve($_GET['id']);
$assigned_user_id = $contact->assigned_user_id;
$ass = new User();
$ass->retrieve($assigned_user_id);
$sqlemail = "SELECT email_addresses.email_address \n\t\t\tFROM email_addresses\n\t\t\tLEFT JOIN email_addr_bean_rel ON email_addr_bean_rel.email_address_id = email_addresses.id AND email_addr_bean_rel.deleted = 0\n\t\t\tWHERE email_addresses.deleted = 0 \n\t\t\tAND bean_id = '{$contact->id}' ";
$resultemail = $db->query($sqlemail);
while ($rowemail = $db->fetchByAssoc($resultemail)) {
$emails[] = $rowemail['email_address'];
//$emails[] = '*****@*****.**';
}
$sql = "SELECT realty_id FROM realty_contacts_table WHERE presentation_checked=1 AND contact_id = '" . $contact->id . "' AND deleted = 0";
$result = $db->query($sql);
// echo $sql;
while ($row = $db->fetchByAssoc($result)) {
$pdf = GeneratePresentation($row['realty_id']);
$realty = new Realty();
$realty->retrieve($row['realty_id']);
//$assigned_email = $ass->email1;
/* require_once('custom/sms/sms.php');
$sms = new sms();
//$sms->parent_type = 'Users';
$sms->retrieve_settings();
//$sms->parent_id = $user->id;
//$sms->pname = $user->full_name;
//$type = ($bean->object_name == "Call")?"Вам назначен звонок ":"Вам назначена Встреча ";
$resp = $sms->send_message($ass->phone_mobile, 'Презентация отправлена');
$sms->parent_type="Contacts";
$sms->parent_id=$contact->id;
$sms->pname='Уведомление о презентации';
$resp = $sms->send_message($contact->phone_mobile, 'Вам на почту отправлена презентация');*/
