function Generate(&$bean, $event, $arguments)
{
global $db;
$worksheet = new Worksheets();
$worksheet->retrieve($bean->groupprogr53b5ksheets_idb);
$temp = base64_decode($worksheet->content);
$noidung = json_decode($temp);
// Tao AirTranBooking:
foreach ($noidung->vemaybay as $chuyenbay) {
if ($this->createAirTrainBooking($bean, $chuyenbay)) {
$GLOBALS['log']->fatal('Mot AirTransBooking da duoc tao thanh cong.');
} else {
$GLOBALS['log']->fatal('Mot AirTransBooking da duoc tao that bai.');
}
}
// Tao TranSportBooking:
foreach ($noidung->vanchuyen as $vanchuyen) {
if ($this->createTransportBooking($bean, $vanchuyen)) {
$GLOBALS['log']->fatal('Mot TransportBooking da duoc tao thanh cong.');
} else {
$GLOBALS['log']->fatal('Mot TransportBooking da duoc tao that bai.');
}
}
// Tao RestaurantBooking:
foreach ($noidung->nhahang as $nhahang) {
if ($this->createRestaurantBooking($bean, $nhahang)) {
$GLOBALS['log']->fatal('Mot RestaurantBooking da duoc tao thanh cong.');
} else {
$GLOBALS['log']->fatal('Mot RestaurantBooking da duoc tao that bai.');
}
}
// Tao RoomBooking:
foreach ($noidung->khachsan as $khachsan) {
if ($this->createRoomBooking($bean, $khachsan)) {
$GLOBALS['log']->fatal('Mot RoomBooking da duoc tao thanh cong.');
} else {
$GLOBALS['log']->fatal('Mot RoomBooking da duoc tao that bai.');
}
}
// Tao ServiceBooking:
foreach ($noidung->dichvu as $dichvu) {
if ($this->createServiceBooking($bean, $dichvu)) {
$GLOBALS['log']->fatal('Mot ServiceBooking da duoc tao thanh cong.');
} else {
$GLOBALS['log']->fatal('Mot ServiceBooking da duoc tao that bai.');
}
}
}
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
if (isset($_POST['tour_id'])) {
global $db, $app_list_strings;
$html = '';
$focus = new Worksheets();
$id = '';
$i = 1;
$j = 1;
$m = 1;
$k = 1;
$l = 1;
$id = isset($_POST['tour_id']) ? htmlspecialchars($_POST['tour_id']) : "";
$type = isset($_POST['type']) ? htmlspecialchars($_POST['type']) : "";
$tour_name = isset($_POST['tour_name']) ? htmlspecialchars($_POST['tour_name']) : "";
$tourcode = isset($_POST['tourcode']) ? htmlspecialchars($_POST['tourcode']) : "";
$duration = isset($_POST['duration']) ? htmlspecialchars($_POST['duration']) : "";
$transport = isset($_POST['transport']) ? htmlspecialchars($_POST['transport']) : "";
$groupprogrd737rograms_ida = isset($_POST['groupprogrd737rograms_ida']) ? htmlspecialchars($_POST['groupprogrd737rograms_ida']) : "";
$groupprograorksheets_name = isset($_POST['groupprograorksheets_name']) ? htmlspecialchars($_POST['groupprograorksheets_name']) : "";
$thuesuathoa = isset($_POST['thuesuathoa']) ? htmlspecialchars($_POST['thuesuathoa']) : "";
$sokhach = isset($_POST['sokhach']) ? htmlspecialchars($_POST['sokhach']) : "";
$tyle = isset($_POST['tyle']) ? htmlspecialchars($_POST['tyle']) : "";
$version = isset($_POST['version']) ? htmlspecialchars($_POST['version']) : "";
$lotrinh = isset($_POST['lotrinh']) ? htmlspecialchars($_POST['lotrinh']) : "";
$focus->retrieve($_POST['record']);
if (!empty($_POST['assigned_user_id']) && $focus->assigned_user_id != $_POST['assigned_user_id'] && $_POST['assigned_user_id'] != $current_user->id) {
$check_notify = TRUE;
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
global $db;
if (isset($_POST['destination']) && isset($_POST['standard'])) {
$destination = isset($_POST['destination']) ? htmlspecialchars($_POST['destination']) : "";
$standard = isset($_POST['standard']) ? htmlspecialchars($_POST['standard']) : "";
$id = isset($_POST['tour_id']) ? htmlspecialchars($_POST['tour_id']) : "";
$idArr = array();
$idArr = Worksheets::getHotelData($id);
$arrID = '';
foreach ($idArr as $val) {
$arrID .= $val['id'] . ',';
}
$sql = "SELECT\r\n DISTINCT\r\n h.id,\r\n h.name,\r\n h.standard,desht.destinatio6fe0nations_ida\r\n FROM hotels h\r\n INNER JOIN destinations_hotels_c desht\r\n ON h.id = desht.destinatiocbebshotels_idb\r\n WHERE h.deleted = 0\r\n AND desht.deleted = 0\r\n AND desht.destinatio6fe0nations_ida = '" . $destination . "' AND h.standard = '" . $standard . "'";
//" AND h.id in ('".$arrID."')";
$result = $db->query($sql);
$hotels = array();
while ($row = $db->fetchByAssoc($result)) {
$hotel = array('id' => $row['id'], 'name' => $row['name']);
$hotels[] = $hotel;
}
echo json_encode($hotels);
} else {
echo json_encode("{error:'Destination not found!'}");
}
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
if (isset($_POST['area']) && isset($_POST['id'])) {
$area = isset($_POST['area']) ? htmlspecialchars($_POST['area']) : "";
$id = isset($_POST['id']) ? htmlspecialchars($_POST['id']) : "";
$costarr = Worksheets::getCostGuide($id, $area);
$key = array_keys($costarr);
$label = getFieldLabel();
$listArr = array();
for ($i = 0; $i < count($key); $i++) {
$listArr[] = array('value' => $costarr[$key[$i]], 'label' => $label[$key[$i]]);
}
echo json_encode($listArr);
} else {
echo 'not found';
}
/**
* Lay label cua cac chi phi
*
*/
function getFieldLabel()
{
$costguide = new CostGuides();
$label = array();
foreach ($costguide->field_defs as $name => $arr) {
if (!(isset($arr['dbType']) && strtolower($arr['dbType']) == 'id' || $arr['type'] == 'id' || $arr['type'] == 'link')) {
if ($arr['vname'] != 'LBL_DELETED') {
$label[$name] = translate($arr['vname'], 'CostGuides');
* Created by (s): Hoc Bui
* Updated date: 07/09/2011
* Update by (s): Hoc Bui
* Notes: draft version
********************************************************************************/
/******** THIET LAP CAN THIET ***********/
require_once "modules/Worksheets/Worksheets.php";
require_once 'modules/Currencies/ListCurrency.php';
global $app_strings;
global $timedate;
global $app_list_strings;
global $mod_strings;
global $current_user;
global $sugar_version, $sugar_config;
global $theme;
$focus = new Worksheets();
$ss = new Sugar_Smarty();
if (empty($_REQUEST['return_id'])) {
if (isset($_SESSION['record'])) {
$_REQUEST['record'] = $_SESSION['record'];
$_REQUEST['return_id'] = $_SESSION['return_id'];
}
}
$ss->assign("MOD", $mod_strings);
$ss->assign("APP", $app_strings);
if (isset($_REQUEST['return_module'])) {
$ss->assign("RETURN_MODULE", $_REQUEST['return_module']);
}
if (isset($_REQUEST['return_action'])) {
$ss->assign("RETURN_ACTION", $_REQUEST['return_action']);
}
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
$focus = new Worksheets();
$focus->retrieve($_REQUEST['record']);
$content = '';
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;
}
}
// PHẦN CHIẾT TÍNH OUTBOUND
if ($focus->type == "Outbound") {
function display()
{
$focus = new Worksheets();
global $app_list_strings;
$template = '';
$record = isset($_GET["record"]) ? htmlspecialchars($_GET["record"]) : '';
global $sugar_config, $current_user;
$focus->retrieve($record);
$temp = base64_decode($focus->content);
$noidung = json_decode($temp);
$tongtamung = 0;
$nhtamung = 0;
if ($focus->type == "DOS") {
$sql = "SELECT gl.name, gl.code\r\n FROM groupprograms AS gp INNER JOIN grouplists_roupprograms_c gpgl ON gp.id = gpgl.grouplistsf242rograms_idb \r\n INNER JOIN grouplists gl ON gl.id = gpgl.grouplists87eduplists_ida WHERE gp.deleted =0 AND gl.deleted =0 AND gpgl.deleted =0 AND gp.id ='" . $focus->groupprogrd737rograms_ida . "'";
$result = $focus->db->query($sql);
$row = $focus->db->fetchByAssoc($result);
$template = file_get_contents('modules/Worksheets/tpls/export/ChiettinhDos_files/sheet001.htm');
$template = str_replace('{TENDOAN}', $row['name'], $template);
$template = str_replace('{MADOAN}', $row['code'], $template);
$template = str_replace('{site_url}', $sugar_config['site_url'], $template);
$template = str_replace('{TOUR_NAME}', $focus->worksheet_tour_name, $template);
$template = str_replace('{TOUR_CODE}', $focus->tourcode, $template);
$template = str_replace('{DURATION}', $focus->duration, $template);
$template = str_replace('{TRANSPORT}', $focus->transport, $template);
$template = str_replace('{THUESUATHOA}', $focus->thuesuathoa, $template);
$template = str_replace('{SOKHACH}', $focus->sokhach, $template);
$template = str_replace('{LOTRINH}', $focus->lotrinh, $template);
$template = str_replace('{NGUOITHUCHIEN}', $current_user->full_name, $template);
$template = str_replace('{DATE}', date('d/m/Y'), $template);
// loading tam ung cua airline ticket
$vemaybay = $noidung->vemaybay;
$airArr = $focus->getAirlineTicket($this->worksheet_tour_id);
if (count($airArr) > 0) {
foreach ($airArr as $val) {
$app_list_strings['list_airlinetiket_dom'][$val['id']] = $val['name'];
}
}
$html = '';
if ($vemaybay) {
$airSum = 0;
foreach ($vemaybay as $vmb) {
if ($vmb->vemaybay_check_tam_ung != 0) {
$html .= "<tr height=21 style='height:15.75pt'>";
$html .= "<td height=21 class=xl84 style='height:15.75pt'>" . translate('list_airlinetiket_dom', '', $vmb->vemaybay) . "</td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vmb->vemaybay_giathamkhao . "</td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vmb->vemaybay_dongia . "</td>";
$html .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $vmb->vemaybay_soluong . "</td>";
$html .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $vmb->nh_songay . " </td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $vmb->vemaybay_thanhtien . " </td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vmb->vemaybay_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$html .= '</tr>';
$airArr += unformat_number($vmb->vemaybay_tamung);
}
}
}
$template = str_replace('{VMBHTML}', $html, $template);
// lay tam ung cho nha hang
$nhahang = $noidung->nhahang;
$nhArr = array();
$nhArr = $focus->getRestaurantData($focus->worksheet_tour_id);
foreach ($nhArr as $arr) {
$app_list_strings['list_restaurant_dom'][$arr['id']] = $arr['name'];
}
if ($nhahang) {
$nhHtml = '';
foreach ($nhahang as $nhval) {
if ($nhval->nh_tamung != 0) {
$nhHtml .= "<tr height=21 style='height:15.75pt'>";
$nhHtml .= "<td height=21 class=xl84 style='height:15.75pt'>" . translate('list_restaurant_dom', '', $nhval->nh_id) . "</td>";
$nhHtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $nhval->nh_giathamkhao . "</td>";
$nhHtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $nhval->nh_dongia . "</td>";
$nhHtml .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $nhval->nh_soluong . "</td>";
$nhHtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $nhval->nh_songay . " </td>";
$nhHtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $nhval->nh_thanhtien . " </td>";
$nhHtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $nhval->nh_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$nhHtml .= "</tr> ";
$nhtamung += unformat_number($nhval->nh_tamung);
}
}
}
$template = str_replace('{NHHTML}', $nhHtml, $template);
// lay tam ung cho khach san
$kshtml = "";
$khachsan = $noidung->khachsan;
$ksArr = array();
$ksArr = $focus->getHotelData($focus->worksheet_tour_id);
foreach ($ksArr as $arrks) {
$app_list_strings['list_khach_san_dom'][$arrks['id']] = $arrks['name'];
}
if (!empty($khachsan)) {
$kstamung = 0;
foreach ($khachsan as $ksval) {
if ($ksval->ks_tamung != 0) {
$kshtml .= "<tr height=21 style='height:15.75pt'>";
$kshtml .= "<td height=21 class=xl84 style='height:15.75pt'>" . $ksval->ks_name . "</td>";
$kshtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $ksval->ks_giathamkhao . "</td>";
$kshtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $ksval->ks_dongia . "</td>";
$kshtml .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $ksval->ks_soluong . "</td>";
$kshtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $ksval->ks_songay . " </td>";
$kshtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $ksval->ks_thanhtien . " </td>";
$kshtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $ksval->ks_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$kshtml .= "</tr> ";
$kstamung += unformat_number($ksval->ks_tamung);
}
}
}
$template = str_replace('{KSHTML}', $kshtml, $template);
// lay du lieu phan van chuyen
$vanchuyen = $noidung->vanchuyen;
$vcArr = array();
$vcArr = $focus->getTransportData($focus->worksheet_tour_id);
foreach ($vcArr as $arrtrans) {
$app_list_strings['list_vanchuyen_dom'][$arrtrans['id']] = 'Xe ' . $arrtrans['name'] . ' chỗ';
}
$vctamung = 0;
$vchtml = "";
if ($vanchuyen) {
foreach ($vanchuyen as $vcval) {
if ($vcval->vanchuyen_tamung != 0) {
$option = $app_list_strings['vanchuyen_dongia_option'][$vcval->dongia_option];
$option = str_replace('/', '', $option);
$vchtml .= "<tr height=21 style='height:15.75pt'>";
$vchtml .= "<td height=21 class=xl84 style='height:15.75pt'>" . translate('list_vanchuyen_dom', '', $vcval->vanchuyen_name) . "</td>";
$vchtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vcval->vanchuyen_giathamkhao . "</td>";
$vchtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vcval->vanchuyen_dongia . "</td>";
$vchtml .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $vcval->vanchuyen_soluong . "</td>";
$vchtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $vcval->vanchuyen_songay . " " . $option . " </td>";
$vchtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $vcval->vanchuyen_thanhtien . " </td>";
$vchtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $vcval->vanchuyen_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$vchtml .= "</tr> ";
$vctamung += unformat_number($vcval->vanchuyen_tamung);
}
}
}
$template = str_replace("{HTMLVANCHUYEN}", $vchtml, $template);
// lay phan tam ung dich vu
$dichvu = $noidung->dichvu;
$dvArr = array();
$dvArr = $focus->getServiceData($focus->worksheet_tour_id);
foreach ($dvArr as $arrsv) {
$app_list_strings['list_dichvu_dom'][$arrsv['id']] = $arrsv['name'];
}
if ($dichvu) {
$dvtamung;
$dvhtml = "";
foreach ($dichvu as $dvVal) {
if ($dvVal->services_tamung != 0) {
$dvhtml .= "<tr height=21 style='height:15.75pt'>";
$dvhtml .= "<td height=21 class=xl84 style='height:15.75pt'>" . translate('list_dichvu_dom', '', $dvVal->services_name) . "</td>";
$dvhtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $dvVal->services_giathamkhao . "</td>";
$dvhtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $dvVal->services_dongia . "</td>";
$dvhtml .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $dvVal->services_soluong . "</td>";
$dvhtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $dvVal->services_songay . " </td>";
$dvhtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $dvVal->services_thanhtien . " </td>";
$dvhtml .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $dvVal->services_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$dvhtml .= "</tr> ";
$dvtamung += unformat_number($dvVal->services_tamung);
}
}
}
$template = str_replace("{DICHVUHTML}", $dvhtml, $template);
// lay tam ung phan tham quan
$thamquan = $noidung->thamquan;
$tqArr = array();
$tqArr = $focus->getSightseeingData($focus->worksheet_tour_id);
foreach ($tqArr as $arrtq) {
$app_list_strings['list_thamquan_dom'][$arrtq['id']] = $arrtq['name'];
}
$tqhtml = "";
$tqtamung = 0;
if ($thamquan) {
foreach ($thamquan as $tqval) {
if ($tqval->thamquan_tamung != 0) {
$tqhtml .= "<tr height=21 style='height:15.75pt'>";
$tqhtml .= "<td height=21 class=xl84 style='height:15.75pt'>" . translate('list_thamquan_dom', '', $tqval->thamquan_name) . "</td>";
$tqhtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_giathamkhao . "</td>";
$tqhtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_dongia . "</td>";
$tqhtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_soluong . "</td>";
$tqhtml .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_songay . " </td>";
$tqhtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_thanhtien . " </td>";
$tqhtml .= "<td class=xl100><span style='mso-spacerun:yes'></span>" . $tqval->thamquan_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$tqhtml .= "</tr> ";
$tqtamung += unformat_number($tqval->thamquan_tamung);
}
}
}
// chi phi khac
$html = '';
$chiphikhac = $noidung->chiphikhac;
if (count($chiphikhac) > 0) {
$sumCPK = 0;
foreach ($chiphikhac as $value) {
if ($value->cpk_check_tam_ung != 0) {
$html .= "<tr height=21 style='height:15.75pt'>";
$html .= "<td height=21 class=xl84 style='height:15.75pt'>" . $value->chiphikhac_loaidichvu . "</td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $value->chiphikhac_giathamkhao . "</td>";
$html .= "<td class=xl84><span style='mso-spacerun:yes'> </span>" . $value->chiphikhac_dongia . "</td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $value->chiphikhac_soluong . "</td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span> </td>";
$html .= "<td class=xl84><span style='mso-spacerun:yes'></span>" . $value->chiphikhac_thanhtien . " </td>";
$html .= "<td class=xl100><span style='mso-spacerun:yes'> </span>" . $value->chiphikhac_tamung . "<span style='mso-spacerun:yes'> </span></td>";
$html .= '</tr>';
$sumCPK += unformat_number($value->chiphikhac_tamung);
}
}
}
$template = str_replace('{CPKHTML}', $html, $template);
$tongtamung = $nhtamung + $kstamung + $vctamung + $dvtamung + $tqtamung + $sumCPK + $airSum;
$template = str_replace("{TONGCONG}", number_format($tongtamung, 2, '.', ','), $template);
$template = str_replace('{THAMQUANHTML}', $tqhtml, $template);
ob_clean();
header("Pragma: cache");
$template = chr(255) . chr(254) . mb_convert_encoding($template, "UTF-16LE", "UTF-8");
header("Content-type: application/x-msdownload");
header("Content-disposition: xls; filename=Tam_Ung_Cho_Tour_" . $focus->tourcode . ".xls; size=" . strlen($template));
echo $template;
exit;
}
}
