<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/RestaurantBookings/RestaurantBookings.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 RestaurantBookings();
$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;
$theme_path = "themes/" . $theme . "/";
function display()
{
global $sugar_config, $mod_strings, $app_strings;
$focus = new RestaurantBookings();
$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/RestaurantBookings/tpls/export.tpl');
/* Delete by Hieu Nguyen 270712
//$sql = "select * from tours where id ='".$record."' and deleted = 0";
$sql = " SELECT
srv.res_address
, srv.code
, srv.attn_res_name
, srv.attn_res_phone
, srv.res_tel
, srv.res_fax
, srv.company
, srv.attn_name
, srv.attn_phone
, srv.attn_id
, srv.attn_email
, srv.attn_tel
, srv.attn_fax
, srv.nationlity
, srv.notes
, srv.confirm
, srv.date
, srv.deparment
, srv.date_time
, srv.operating_date
, srv.quantity_pax
, srv.guide
, srv.guide_id
, srv.guide_phone
,res.name
,res.code as res_code
,grp.groupprogram_code
FROM
restaurantbookings srv LEFT JOIN restaurantsrantbookings_c ressvr ON srv.id = ressvr.restaurantd663ookings_idb LEFT JOIN restaurants res
ON ressvr.restaurant437baurants_ida = res.id LEFT JOIN groupprograrantbookings_c grpsrv ON srv.id = grpsrv.groupprogre72bookings_idb
LEFT JOIN groupprograms grp ON grpsrv.groupprogr880erograms_ida =grp.id
WHERE srv.deleted = 0 AND ressvr.deleted = 0 AND res.deleted = 0 AND grpsrv.deleted = 0 AND grp.deleted =0 AND srv.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_RES_NAME}", $mod_strings['LBL_ATTN_RES_NAME'], $template);
$template = str_replace("{LBL_RES_TEL}", $mod_strings['LBL_RES_TEL'], $template);
$template = str_replace("{LBL_RES_FAX}", $mod_strings['LBL_RES_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_TITLE}", $mod_strings['LBL_TITLE'], $template);
$template = str_replace("{LBL_OPERATING_DATE}", $mod_strings['LBL_OPERATING_DATE'], $template);
$template = str_replace("{LBL_MADE_TOUR}", $mod_strings['LBL_MADE_TOUR'], $template);
$template = str_replace("{LBL_NATIONLITY}", $mod_strings['LBL_NATIONLITY'], $template);
$template = str_replace("{LBL_QUANTITY_PAX}", $mod_strings['LBL_QUANTITY_PAX'], $template);
$template = str_replace("{LBL_GUIDE}", $mod_strings['LBL_GUIDE'], $template);
$template = str_replace("{LBL_TIME}", $mod_strings['LBL_TIME'], $template);
$template = str_replace("{LBL_QUANTITY}", $mod_strings['LBL_QUANTITY'], $template);
$template = str_replace("{LBL_UNIT_PRICE}", $mod_strings['LBL_UNIT_PRICE'], $template);
$template = str_replace("{LBL_MENU}", $mod_strings['LBL_MENU'], $template);
$template = str_replace("{LBL_NOTES}", $mod_strings['LBL_NOTES'], $template);
$template = str_replace("{LBL_CONFIRM_SERVICE}", $mod_strings['LBL_CONFIRM_SERVICE'], $template);
$template = str_replace("{LBL_DATE}", $mod_strings['LBL_DATE'], $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("{RES}", $this->bean->restaurantstbookings_name, $template);
$template = str_replace("{ADDRESS}", $this->bean->res_address, $template);
$template = str_replace("{ATTN_RES_NAME}", $this->bean->attn_res_name, $template);
$template = str_replace("{ATTN_RES_PHONE}", $this->bean->attn_res_phone, $template);
$template = str_replace("{RES_TEL}", $this->bean->res_tel, $template);
$template = str_replace("{RES_FAX}", $this->bean->res_fax, $template);
$template = str_replace("{FROM}", $this->bean->company, $template);
//$template = str_replace("{ATTN_NAME}", $this->bean->attn_name,$template );
$template = str_replace("{ATTN_NAME}", $this->bean->assigned_user_name, $template);
$template = str_replace("{ATTN_PHONE}", $this->bean->attn_phone, $template);
$template = str_replace("{ATTN_EMAIL}", $this->bean->attn_email, $template);
$template = str_replace("{TEL}", $this->bean->attn_tel, $template);
$template = str_replace("{FAX}", $this->bean->attn_fax, $template);
$template = str_replace("{DATE_TIME}", $this->bean->date_time, $template);
$template = str_replace("{OPERATING_DATE}", $this->bean->operating_date, $template);
$template = str_replace("{QUANTITY_PAX}", $this->bean->quantity_pax, $template);
$template = str_replace("{GUIDE}", $this->bean->guide, $template);
$template = str_replace("{GUIDE_PHONE}", $this->bean->guide_phone, $template);
// Lay ra code cua MadeTour
$made_tour = new GroupProgram();
$made_tour->retrieve($this->bean->groupprogr880erograms_ida);
$template = str_replace("{MADETOUR}", $made_tour->groupprogram_code, $template);
// fix bug 1487
if (!empty($this->bean->nationlity)) {
$template = str_replace("{NATIONLITY}", translate('countries_dom', '', $this->bean->nationlity), $template);
} else {
$template = str_replace("{NATIONLITY}", '', $template);
}
$template = str_replace("{BOOKINGLINE}", $focus->get_servicebooking_detailview($record), $template);
$template = str_replace("{NOTES}", html_entity_decode(nl2br($this->bean->notes)), $template);
if ($this->bean->confirm == 0) {
$template = str_replace("{CONFIRM}", 'No', $template);
} else {
$template = str_replace("{CONFIRM}", 'Yes', $template);
}
$template = str_replace("{DATE}", $this->bean->date, $template);
$template = str_replace("{DEPARMENT}", $this->bean->deparment, $template);
$size = strlen($template);
$filename = "Restaurant_Booking_" . strtoupper($this->bean->code) . "_To_" . mb_strtoupper($this->bean->restaurantstbookings_name, 'UTF-8') . ".doc";
// fix issue 1485
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();
}
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/RestaurantBookings/RestaurantBookings.php';
require_once 'include/formbase.php';
require_once 'modules/RestaurantBookingsLine/RestaurantBookingsLine.php';
include "config.php";
global $sugar_config, $mod_strings;
$focus = new RestaurantBookings();
$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];
$focus->{$field} = $value;
function createRestaurantBooking($bean, $nhahang = '')
{
global $db;
$sql = "\r\n SELECT \r\n a.id \r\n FROM\r\n `restaurantbookings` a \r\n JOIN `restaurantsrantbookings_c` b \r\n ON a.`id` = b.`restaurantd663ookings_idb` \r\n AND b.`deleted` = 0 \r\n AND b.`restaurant437baurants_ida` = '{$nhahang->nh_id}' \r\n JOIN `groupprograrantbookings_c` c \r\n ON c.`groupprogre72bookings_idb` = a.`id` \r\n AND c.`deleted` = 0 \r\n AND c.`groupprogr880erograms_ida` = '{$bean->id}' \r\n WHERE a.`deleted` = 0 \r\n ";
$RestaurantBooking = new RestaurantBookings();
$result = $db->query($sql);
while ($row = $db->fetchByAssoc($result)) {
$RestaurantBooking->id = $row['id'];
}
$RestaurantBooking->groupprogratbookings_name = $bean->groupprogram_code;
$RestaurantBooking->groupprogr880erograms_ida = $bean->id;
$restaurant = new Restaurants();
$restaurant->retrieve($nhahang->nh_id);
$RestaurantBooking->restaurant437baurants_ida = $restaurant->id;
$RestaurantBooking->restaurantstbookings_name = $restaurant->name;
$RestaurantBooking->res_address = $restaurant->address;
$RestaurantBooking->res_tel = $restaurant->tel;
$RestaurantBooking->res_fax = $restaurant->fax;
$RestaurantBooking->confirm = 0;
$RestaurantBooking->name = 'Restaurant Bookings To ' . $restaurant->name;
$RestaurantBooking->assigned_user_name = $bean->assigned_user_name;
$RestaurantBooking->assigned_user_id = $bean->assigned_user_id;
$return = $RestaurantBooking->save();
return $return;
}
