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.'); } } }
$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; } else { $check_notify = FALSE; } $html = ''; $html .= '<script type="text/javascript">'; // $html .= ''; $html .= '$("#record").val($("#worksheet_id").val()); '; $html .= '$("#return_id").val($("#worksheet_id").val()); '; $html .= ' $(".center").val("0"); $(".ghichu").val("Ghi chú"); $(".center").focus(function(){ if($(this).val()== 0){
if (isset($focus->currency_id) && !empty($focus->currency_id)) { $selectCurrency = $currency->getSelectOptions($focus->currency_id); $ss->assign("CURRENCY", $selectCurrency); } else { if ($current_user->getPreference('currency') && !isset($focus->id)) { $selectCurrency = $currency->getSelectOptions($current_user->getPreference('currency')); $ss->assign("CURRENCY", $selectCurrency); } else { $selectCurrency = $currency->getSelectOptions(); $ss->assign("CURRENCY", $selectCurrency); } } echo $currency->getJavascript(); $seps = get_number_seperators(); $ss->assign("NUM_GRP_SEP", $seps[0]); $ss->assign("DEC_SEP", $seps[1]); //Edit record //if(isset($_POST['record']) && $_POST['record'] != '') { // if($focus->retrieve($_REQUEST['record'])){ if ($focus->retrieve($_REQUEST['record'])) { $ss->assign('TYPE', $focus->type); require_once "modules/Worksheets/{$focus->type}.php"; } else { //new record $type = $_REQUEST['type']; if ($type == '') { $type = 'home'; } $ss->assign('TYPE', $type); require_once "modules/Worksheets/{$type}.php"; }
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; } }