<?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, 'Вам на почту отправлена презентация');*/