$html .= '<th> </th>';
$html .= '<th> </th>';
$html .= '<th><input type="text" size="15" class="center" name="service_tongthanhtien" id="service_tongthanhtien"/></th>';
$html .= '<th> </th>';
$html .= '<th> </th>';
$html .= '<th><input type="text" size="15" class="center" name="service_tongthue" id="service_tongthue"/></th>';
$html .= '<th> </th>';
$html .= '<th> </th>';
$html .= '<th> </th>';
$html .= '</tr>';
$html .= '</tfoot>';
$html .= '</table> </fieldset>';
}
// loading data tham quan
$tqArr = array();
$tqArr = $focus->getSightseeingData($id);
foreach ($tqArr as $arrtq) {
$app_list_strings['list_thamquan_dom'][$arrtq['id']] = $arrtq['name'];
$app_list_strings['list_thamquan_giathamkhao_dom'][$arrtq['id']] = $arrtq['giathamkhao'];
}
if (count($tqArr) > 0) {
$html .= '<fieldset class="tabForm">';
$html .= '<legend> <h3>THAM QUAN</h3></legend>';
$html .= '<table width="100%" class="table_clone" border="1" id="thamquan" cellspacing="0" cellpadding="0" style="border-collapse:collapse">';
$html .= '<thead>';
$html .= '<tr>';
$html .= '<th>Địa điểm tham quan</th>';
$html .= '<th>Giá tham khảo</th>';
$html .= '<th>Đơn giá</th>';
$html .= '<th>Số lượng</th>';
$html .= '<th>Số ngày</th>';
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;
}
}
