function createTransportBooking($bean, $vanchuyen = '')
{
global $db;
$sql = "\r\n SELECT \r\n a.id \r\n FROM\r\n `transportbookings` a \r\n JOIN `transports_portbookings_c` b \r\n ON a.`id` = b.`transportsc2aeookings_idb` \r\n AND b.`deleted` = 0 \r\n JOIN `cars` c \r\n ON c.`transport_id` = b.`transports6e65nsports_ida` \r\n AND c.`deleted` = 0 \r\n AND c.`id` = '{$vanchuyen->vanchuyen_name}' \r\n JOIN `groupprograportbookings_c` d \r\n ON d.`groupprogrdcceookings_idb` = a.`id` \r\n AND d.`groupprogrd5earograms_ida` = '{$bean->id}' \r\n AND d.`deleted` = 0 \r\n WHERE a.`deleted` = 0 \r\n ";
$TransportBooking = new TransportBookings();
$result = $db->query($sql);
while ($row = $db->fetchByAssoc($result)) {
$TransportBooking->id = $row['id'];
}
$TransportBooking->groupprogratbookings_name = $bean->name;
$TransportBooking->groupprogrd5earograms_ida = $bean->id;
$sql = "\r\n SELECT \r\n a.* \r\n FROM\r\n `transports` a \r\n JOIN cars b \r\n ON b.`transport_id` = a.`id` \r\n AND b.`deleted` = 0 \r\n AND b.`id` = '{$vanchuyen->vanchuyen_name}' \r\n WHERE a.`deleted` = 0\r\n ";
$result = $db->query($sql);
$row = $db->fetchByAssoc($result);
$TransportBooking->transports6e65nsports_ida = $row['id'];
$TransportBooking->transports_tbookings_name = $row['name'];
$TransportBooking->address = $row['address'];
$TransportBooking->tel_to = $row['phone'];
$TransportBooking->confirm = 0;
$TransportBooking->name = 'Transport Bookings To ' . $row['name'];
$TransportBooking->assigned_user_name = $bean->assigned_user_name;
$TransportBooking->assigned_user_id = $bean->assigned_user_id;
$return = $TransportBooking->save();
return $return;
}
function display()
{
global $sugar_config, $mod_strings, $app_strings, $timedate;
$focus = new TransportBookings();
$ss = new Sugar_Smarty();
$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/TransportBookings/tpls/Export.tpl');
$sql = "SELECT \r\n tb.address\r\n ,tb.code\r\n ,tb.assigned_user_id\r\n ,tb.attn_from_phone\r\n ,tb.attn_to_name\r\n ,tb.attn_to_phone\r\n ,tb.confirm\r\n ,tb.date\r\n ,tb.email\r\n ,tb.from_co\r\n ,tb.fax_to\r\n ,tb.operator\r\n ,tb.tel_from\r\n ,tb.fax_from\r\n ,tb.tel_to\r\n ,tb.fax_to\r\n ,tb.vat\r\n ,tb.require_transports\r\n ,t.name\r\n ,t.code as t_code\r\n ,g.groupprogram_code\r\n FROM\r\n transportbookings tb INNER JOIN transports_portbookings_c ttb ON tb.id = ttb.transportsc2aeookings_idb \r\n INNER JOIN transports t ON ttb.transports6e65nsports_ida = t.id INNER JOIN groupprograportbookings_c gtb\r\n ON tb.id = gtb.groupprogrdcceookings_idb INNER JOIN groupprograms g ON g.id = gtb.groupprogrd5earograms_ida\r\n WHERE tb.deleted = 0 AND ttb.deleted = 0 AND t.deleted = 0 AND g.deleted = 0 AND gtb.deleted = 0 AND tb.id = '" . $record . "'";
$result = $db->query($sql);
$row = $db->fetchByAssoc($result);
$template = str_replace("{LBL_TO}", $mod_strings['LBL_TRANSPORT'], $template);
$template = str_replace("{LBL_ADDRESS}", $mod_strings['LBL_ADDRESS'], $template);
$template = str_replace("{LBL_ATTN}", $mod_strings['LBL_ATTN'], $template);
$template = str_replace("{LBL_TEL}", $mod_strings['LBL_TEL'], $template);
$template = str_replace("{LBL_FAX}", $mod_strings['LBL_FAX'], $template);
$template = str_replace("{LBL_FROM}", $mod_strings['LBL_FROM_CO'], $template);
$template = str_replace("{LBL_ATTN}", $mod_strings['LBL_ATTN'], $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_ROUTE}", $mod_strings['LBL_NAMELINE'], $template);
$template = str_replace("{LBL_DATELINE}", $mod_strings['LBL_DATELINE'], $template);
$template = str_replace("{LBL_UNITPRICE}", $mod_strings['LBL_UNITPRICELINE'], $template);
$template = str_replace("{LBL_TYPE}", $mod_strings['LBL_TYPELINE'], $template);
$template = str_replace("{LBL_CONTENTLINE}", $mod_strings['LBL_CONTENTLINE'], $template);
$template = str_replace("{LBL_REQUIRE}", $mod_strings['LBL_REQUIRE'], $template);
$template = str_replace("{LBL_VAT1}", $mod_strings['LBL_VAT1'], $template);
$template = str_replace("{LBL_VAT2}", $mod_strings['LBL_VAT2'], $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_OPERATOR}", $mod_strings['LBL_OPERATOR'], $template);
$template = str_replace("{LBL_CONFIRM_CARNIVAL}", $mod_strings['LBL_CONFIRM_CARNIVAL'], $template);
//////////
$template = str_replace("{TRANSPORTS}", $row['name'], $template);
$template = str_replace("{SITE_URL}", $sugar_config['site_url'], $template);
$template = str_replace("{ADDRESS}", $row['address'], $template);
$template = str_replace("{ATTN_TO_NAME}", $row['attn_to_name'], $template);
$template = str_replace("{ATTN_TO_PHONE}", $row['attn_to_phone'], $template);
$template = str_replace("{TEL_TO}", $row['tel_to'], $template);
$template = str_replace("{FAX_TO}", $row['fax_to'], $template);
$template = str_replace("{FROM_CO}", $row['from_co'], $template);
//$template = str_replace("{ATTN_FROM_NAME}", $row['attn_from_name'],$template);
$user = new User();
$user->retrieve($row['assigned_user_id']);
$template = str_replace("{ATTN_FROM_NAME}", $user->name, $template);
$template = str_replace("{ATTN_FROM_PHONE}", $row['attn_from_phone'], $template);
$template = str_replace("{EMAIL}", $row['email'], $template);
$template = str_replace("{TEL_FROM}", $row['tel_from'], $template);
$template = str_replace("{FAX_FROM}", $row['fax_from'], $template);
$template = str_replace("{VAT}", $row['vat'], $template);
$template = str_replace("{REQUIRE}", html_entity_decode(nl2br($row['require_transports'])), $template);
if ($row['confirm'] == 0) {
$template = str_replace("{CONFIRM}", 'No', $template);
} else {
$template = str_replace("{CONFIRM}", 'Yes', $template);
}
$date = $timedate->to_display_date($row['date'], true);
$template = str_replace("{DATE}", $date, $template);
$template = str_replace("{OPERATOR}", $row['operator'], $template);
$template = str_replace("{TRANSPORTSBOOKING_LINE}", $focus->get_transportBookings_export($record), $template);
$size = strlen($template);
$filename = "Transport_Booking_" . $row['code'] . "_To_" . $row['t_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();
}
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/TransportBookings/TransportBookings.php';
require_once 'include/formbase.php';
require_once 'modules/TransportBookingsLine/TransportBookingsLine.php';
include "config.php";
global $sugar_config;
$focus = new TransportBookings();
$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;
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/TransportBookings/TransportBookings.php';
// require_once('modules/TransportBookings/Forms.php');
require_once 'modules/Releases/Release.php';
global $db;
global $app_strings;
global $mod_strings;
global $current_user;
global $sugar_version, $sugar_config;
$focus = new TransportBookings();
$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 . "/";
$image_path = $theme_path . "images/";
