Exemplo n.º 1
0
 function display()
 {
     global $sugar_config, $mod_strings, $app_strings;
     $focus = new RoomBookings();
     $db = DBManagerFactory::getInstance();
     // ONLY LOAD A RECORD IF A RECORD ID IS GIVEN;
     // A RECORD ID IS NOT GIVEN WHEN VIEWING IN LAYOUT EDITOR
     $record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
     $template = file_get_contents('modules/RoomBookings/tpls/export.tpl');
     $sql = "SELECT\r\n            r.hotel_address\r\n            , r.code\r\n            , r.attn_hotel_name\r\n            , r.attn_hotel_phone\r\n            , r.hotel_tel\r\n            , r.hotel_fax\r\n            , r.assigned_user_id\r\n            , r.attn_email\r\n            , r.attn_tel\r\n            , r.attn_fax\r\n            , r.company\r\n            , r.attn_phone\r\n            , r.nationlity\r\n            , r.confirmed\r\n            , r.convention\r\n            , r.date\r\n            , r.deparment\r\n            , r.notes\r\n            , ht.name\r\n            , ht.code as ht_code\r\n            , u.last_name as user\r\n            ,gr.groupprogram_code\r\n            FROM roombookings r INNER JOIN hotels_roombookings_c htr ON r.id =htr.hotels_rooc1a7ookings_idb INNER JOIN hotels ht ON htr.hotels_rooc622shotels_ida = ht.id\r\n            INNER JOIN groupprograroombookings_c grr ON r.id = grr.groupprogr952fookings_idb INNER JOIN groupprograms gr ON grr.groupprogra66erograms_ida = gr.id \r\n            INNER JOIN users u ON r.modified_user_id = u.id\r\n            WHERE r.deleted =0 AND htr.deleted=0 AND ht.deleted =0 AND grr.deleted =0 AND gr.deleted=0 AND r.id = '" . $record . "'";
     $result = $db->query($sql);
     $row = $db->fetchByAssoc($result);
     $template = str_replace("{LBL_TO}", $mod_strings['LBL_TO'], $template);
     $template = str_replace("{LBL_RES_ADDRESS}", $mod_strings['LBL_RES_ADDRESS'], $template);
     $template = str_replace("{LBL_ATTN_HOTEL_NAME}", $mod_strings['LBL_ATTN_HOTEL_NAME'], $template);
     $template = str_replace("{LBL_ATTN_HOTEL_PHONE}", $mod_strings['LBL_ATTN_HOTEL_PHONE'], $template);
     $template = str_replace("{LBL_HOTEL_FAX}", $mod_strings['LBL_HOTEL_FAX'], $template);
     $template = str_replace("{LBL_FROM}", $mod_strings['LBL_FROM'], $template);
     $template = str_replace("{LBL_ATTN_NAME}", $mod_strings['LBL_ATTN_NAME'], $template);
     $template = str_replace("{LBL_EMAIL}", $mod_strings['LBL_EMAIL'], $template);
     $template = str_replace("{LBL_TEL}", $mod_strings['LBL_TEL'], $template);
     $template = str_replace("{LBL_ATTN_FAX}", $mod_strings['LBL_ATTN_FAX'], $template);
     $template = str_replace("{LBL_TITLE}", $mod_strings['LBL_TITLE'], $template);
     $template = str_replace("{LBL_ROOM_RESERVATION}", $mod_strings['LBL_ROOM_RESERVATION'], $template);
     $template = str_replace("{LBL_MADE_TOUR_CODE}", $mod_strings['LBL_MADE_TOUR_CODE'], $template);
     $template = str_replace("{LBL_NATIONLITY}", $mod_strings['LBL_NATIONLITY'], $template);
     $template = str_replace("{LBL_LINE_TYPE}", $mod_strings['LBL_LINE_TYPE'], $template);
     $template = str_replace("{LBL_LINE_QUANTITY}", $mod_strings['LBL_LINE_QUANTITY'], $template);
     $template = str_replace("{LBL_LINE_UNIT_PRICE}", $mod_strings['LBL_LINE_UNIT_PRICE'], $template);
     $template = str_replace("{LBL_LINE_CHECK_IN}", $mod_strings['LBL_LINE_CHECK_IN'], $template);
     $template = str_replace("{LBL_LINE_CHECK_OUT}", $mod_strings['LBL_LINE_CHECK_OUT'], $template);
     $template = str_replace("{LBL_ROOM_CONVENTION}", $mod_strings['LBL_ROOM_CONVENTION'], $template);
     $template = str_replace("{LBL_ROOM_OTHER_SERVICE}", $mod_strings['LBL_ROOM_OTHER_SERVICE'], $template);
     $template = str_replace("{LBL_DATE}", $mod_strings['LBL_DATE'], $template);
     $template = str_replace("{LBL_DEPARMENT}", $mod_strings['LBL_DEPARMENT'], $template);
     $template = str_replace("{LBL_CONFIRM_SERVICE}", $mod_strings['LBL_CONFIRM_SERVICE'], $template);
     $template = str_replace("{LBL_CONFIRM_CARNIVAL}", $mod_strings['LBL_CONFIRM_CARNIVAL'], $template);
     ///////////////
     $template = str_replace("{SITE_URL}", $sugar_config['site_url'], $template);
     $template = str_replace("{HOTEL}", $row['name'], $template);
     $template = str_replace("{ADDRESS}", $row['hotel_address'], $template);
     $template = str_replace("{ATTN_HOTEL_NAME}", $row['attn_hotel_name'], $template);
     $template = str_replace("{ATTN_HOTEL_PHONE}", $row['attn_hotel_phone'], $template);
     $template = str_replace("{HOTEL_TEL}", $row['hotel_tel'], $template);
     $template = str_replace("{HOTEL_FAX}", $row['hotel_fax'], $template);
     $template = str_replace("{FROM}", $row['company'], $template);
     //$template = str_replace("{ATTN_NAME}", $row['attn_name'],$template );
     $user = new User();
     $user->retrieve($row['assigned_user_id']);
     $template = str_replace("{ATTN_NAME}", $user->name, $template);
     $template = str_replace("{ATTN_PHONE}", $row['attn_phone'], $template);
     $template = str_replace("{ATTN_EMAIL}", $row['attn_email'], $template);
     $template = str_replace("{TEL}", $row['attn_tel'], $template);
     $template = str_replace("{FAX}", $row['attn_fax'], $template);
     $template = str_replace("{MADETOUR}", $row['groupprogram_code'], $template);
     if (!empty($row['nationlity'])) {
         $template = str_replace("{NATIONLITY}", translate('countries_dom', '', $row['nationlity']), $template);
     } else {
         $template = str_replace("{NATIONLITY}", '', $template);
     }
     $template = str_replace("{BOOKINGLINE}", $focus->get_bookingroom_detailview($record), $template);
     $template = str_replace("{NOTES}", html_entity_decode(nl2br($row['notes'])), $template);
     $template = str_replace("{CONVENTION}", html_entity_decode(nl2br($row['convention'])), $template);
     $template = str_replace("{SERVICE}", $focus->get_service_detail($record), $template);
     if ($row['confirmed'] == 0) {
         $template = str_replace("{CONFIRM}", 'No', $template);
     } else {
         $template = str_replace("{CONFIRM}", 'Yes', $template);
     }
     $template = str_replace("{DATE}", date("d/m/Y", strtotime($row['date'])), $template);
     $template = str_replace("{DEPARMENT}", $row['deparment'], $template);
     $template = str_replace("{USER}", $row['user'], $template);
     $size = strlen($template);
     $filename = "Room_Booking_" . $row['code'] . "_To_" . $row['ht_code'] . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
 }
Exemplo n.º 2
0
 function createRoomBooking($bean, $khachsan = '')
 {
     global $db;
     $sql = "\r\n            SELECT \r\n              a.id \r\n            FROM\r\n              `roombookings` a \r\n              JOIN `hotels_roombookings_c` b \r\n                ON a.`id` = b.`hotels_rooc1a7ookings_idb` \r\n                AND b.`deleted` = 0 \r\n                AND b.`hotels_rooc622shotels_ida` = '{$khachsan->ks_id}' \r\n              JOIN `groupprograroombookings_c` c \r\n                ON c.`groupprogr952fookings_idb` = a.`id` \r\n                AND c.`deleted` = 0 \r\n                AND c.`groupprogra66erograms_ida` = '{$bean->id}' \r\n            WHERE a.`deleted` = 0 \r\n            ";
     $RoomBooking = new RoomBookings();
     $result = $db->query($sql);
     while ($row = $db->fetchByAssoc($result)) {
         $RoomBooking->id = $row['id'];
     }
     $RoomBooking->groupprogrambookings_name = $bean->groupprogram_code;
     $RoomBooking->groupprogra66erograms_ida = $bean->id;
     $hotel = new Hotels();
     $hotel->retrieve($khachsan->ks_id);
     $RoomBooking->hotels_rooc622shotels_ida = $hotel->id;
     $RoomBooking->hotels_roombookings_name = $hotel->name;
     $RoomBooking->hotel_address = $hotel->address;
     $RoomBooking->hotel_tel = $hotel->tel;
     $RoomBooking->hotel_fax = $hotel->fax;
     $RoomBooking->confirm = 0;
     $RoomBooking->name = 'Room Bookings To ' . $hotel->name;
     $RoomBooking->assigned_user_name = $bean->assigned_user_name;
     $RoomBooking->assigned_user_id = $bean->assigned_user_id;
     $return = $RoomBooking->save();
     return $return;
 }
Exemplo n.º 3
0
<?php

if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
require_once 'modules/RoomBookings/RoomBookings.php';
require_once 'modules/RoomBookings/Forms.php';
require_once 'data/Tracker.php';
require_once 'modules/Releases/Release.php';
global $db;
global $app_strings;
global $mod_strings;
global $mod_strings;
global $current_user;
global $sugar_version, $sugar_config, $app_list_strings;
$focus = new RoomBookings();
$seedRelease = new Release();
$json = getJSONobj();
$ss = new Sugar_Smarty();
if (isset($_REQUEST['record'])) {
    $focus->retrieve($_REQUEST['record']);
}
if (isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true') {
    $focus->id = "";
    $focus->number = "";
}
// BUILD MODULE TITLE LINE
echo "\n<p>\n";
echo get_module_title($mod_strings['LBL_MODULE_ID'], $mod_strings['LBL_MODULE_NAME'] . ": " . $focus->name, true);
echo "\n</p>\n";
global $theme;
Exemplo n.º 4
0
<?php

if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
require_once 'modules/RoomBookings/RoomBookings.php';
require_once 'include/formbase.php';
require_once 'modules/RoomBookingsLine/RoomBookingsLine.php';
require_once 'modules/RoomBookingsSevice/RoomBookingsSevice.php';
include "config.php";
global $sugar_config, $mod_strings;
$focus = new RoomBookings();
$focus->retrieve($_POST['record']);
if (!$focus->ACLAccess('Save')) {
    ACLController::displayNoAccess(true);
    sugar_cleanup(true);
}
if (!empty($_POST['assigned_user_id']) && $focus->assigned_user_id != $_POST['assigned_user_id'] && $_POST['assigned_user_id'] != $current_user->id) {
    $check_notify = TRUE;
} else {
    $check_notify = FALSE;
}
foreach ($focus->column_fields as $field) {
    if (isset($_POST[$field])) {
        $value = $_POST[$field];
        $focus->{$field} = $value;
    }
}
foreach ($focus->additional_column_fields as $field) {
    if (isset($_POST[$field])) {
        $value = $_POST[$field];