function display() { $focus = new Contract(); $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/Contracts/tpls/export.tpl'); $sql = "select * from contracts where id ='" . $record . "' and deleted = 0"; $result = $db->query($sql); $row = $db->fetchByAssoc($result); $style = '<style> v\\:* {behavior:url(#default#VML);} o\\:* {behavior:url(#default#VML);} w\\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style>'; $style_font = '<style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-unhide:no; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; text-align:justify; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style>'; //$ss=new XTemplate ('modules/Contracts/tpl/export.html'); //$template = str_replace('LOICHAO','chao mung cac ban'); /*$template = str_replace("MOD", $mod_strings); $template = str_replace("APP", $app_strings); $template = str_replace("THEME", $theme); $template = str_replace("GRIDLINE", ($gridline) ? $gridline : 0); $template = str_replace("IMAGE_PATH", $image_path); $template = str_replace("PRINT_URL", "index.php?".$GLOBALS['request_string']);*/ // $template = str_replace("{STYLE}", $style,$template); //$template = str_replace("{STYLE_FONT}", $style_font, $template); $template = str_replace("{ID}", $row['id'], $template); $template = str_replace("{ASSIGNED_TO}", $row['assigned_user_name'], $template); $template = str_replace("{NAME}", $row['name'], $template); $template = str_replace("{NUMBER}", $row['number'], $template); $template = str_replace("{DATE}", $row['date'], $template); $template = str_replace("{MONTH}", $row['month'], $template); $template = str_replace("{YEAR}", $row['year'], $template); if (!empty($row['salutation_a'])) { $template = str_replace("{SALUTATION}", translate('xung_ho_dom', '', $row['salutation_a']), $template); } else { $template = str_replace("{SALUTATION}", '', $template); } $template = str_replace("{DAIDIENBENA}", $row['daidienbena'], $template); $template = str_replace("{DAIDIENBENB}", $row['daidienbenb'], $template); $template = str_replace("{POSITION_A}", translate('position_dom', '', $row['position_a']), $template); $template = str_replace("{ADDRESS_A}", $row['address_a'], $template); $template = str_replace("{PHONE_A}", $row['phone_a'], $template); $template = str_replace("{PHONE_B}", $row['phone_b'], $template); $template = str_replace("{FAX}", $row['fax'], $template); $template = str_replace("{MST_BENA}", $row['mst_bena'], $template); $template = str_replace("{BANK_NAME}", $row['bank_name'], $template); $template = str_replace("{ACCOUNT_NAME}", $row['account_name'], $template); $template = str_replace("{ACCOUNT_VND}", $row['account_vnd'], $template); $template = str_replace("{ACCOUNT_USD}", $row['account_usd'], $template); $template = str_replace("{SWIFT_CODE}", $row['account_usd'], $template); $template = str_replace("{BANK_ADDRESS}", $row['bank_address'], $template); $template = str_replace("{DAIDIENBENB_NAME}", $row['daidienbenb_name'], $template); if (!empty($row['salutation_b'])) { $template = str_replace("{SALUTATION_B}", translate('xung_ho_dom', '', $row['salutation_b']), $template); } else { $template = str_replace("{SALUTATION_B}", "", $template); } if (!empty($row->position_b)) { $template = str_replace("{POSITION_B}", translate('position_dom', '', $row['salutation_b']), $template); } else { $template = str_replace("{POSITION_B}", "", $template); } $template = str_replace("{ADDRESS_B}", $row['address_b'], $template); $template = str_replace("{MST_BENB}", $row['mst_benb'], $template); $template = str_replace("{PHONE_B}", $row['phone_b'], $template); $template = str_replace("{TOUR_NAME}", $row['tour_name'], $template); $template = str_replace("{TOUR_ID}", $row['tour_id'], $template); $template = str_replace("{PURPOSE}", $row['purpose'], $template); $template = str_replace("{KETHOP}", $row['associate'], $template); $template = str_replace("{START_DATE}", $row['start_date_contract'], $template); $template = str_replace("{END_DATE}", $row['end_date_contract'], $template); $template = str_replace("{TREPERCENT}", $row['trepercent'], $template); $template = str_replace("{TREPERCENT_1}", $row['trepercent_1'], $template); $template = str_replace("{NUM_OF_NIGHT}", $row['num_of_night'], $template); $template = str_replace("{NUM_OF_DATE}", $row['num_of_date'], $template); $template = str_replace("{SL_KHACH}", $row['sl_khach'], $template); /*$template = str_replace("DOTUOI", $row->dotuoi); $template = str_replace("TONG_SL_KHACH", $row->tong_sl_khach); $template = str_replace("GIA_TOUR", $row->gia_tour); $template = str_replace("THUE", $row->thue); $template = str_replace("THANHTIEN", $row->thanhtien);*/ $template = str_replace("{CONTRACT_VALUE}", $focus->get_contract_values_detailview($record), $template); $template = str_replace("{TONGTIEN}", number_format($row['tongtien'], '2', ',', '.'), $template); $template = str_replace("{BANGCHU}", $row['bangchu'], $template); $template = str_replace("{SL_KHACH_1}", $row['sl_khach_1'], $template); $template = str_replace("{GIA_TOUR_1}", number_format($row['gia_tour_1'], '2', ',', '.'), $template); $template = str_replace("{TIENTE}", translate('currency_dom', '', $row['tiente']), $template); $template = str_replace("{TIENTE_USD}", translate('currency_dom', '', $row['tiente_usd']), $template); $template = str_replace("{TIENTE_VND}", translate('currency_dom', '', $row['tiente_vnd']), $template); $template = str_replace("{TEN_NGANHANG}", $row['ten_nganhang'], $template); $template = str_replace("{BAOGOM}", html_entity_decode(nl2br($row['baogom'])), $template); $template = str_replace("{KHONGBAOGOM}", html_entity_decode(nl2br($row['khongbaogom'])), $template); $template = str_replace("{DOTTHANHTOAN}", $row['dotthanhtoan'], $template); /*$template = str_replace("SUKIEN", $row->sukien); $template = str_replace("PHANTRAM", $row->phantram); $template = str_replace("TIENTHANHTOAN", $row->tienthanhtoan); $template = str_replace("BANGCHU1", $row->bangchu1);*/ $template = str_replace("{CONTRACT_CONDITION}", $focus->get_contract_condition_detailview($record), $template); $template = str_replace("{SOLANTHANHTOAN}", $row['solanthanhtoan'], $template); $template = str_replace("{NGUOIDAIDIENBENB}", $row['nguoidaidienbenb'], $template); $template = str_replace("{NGUOIDAIDIENBENA}", $row['nguoidaidienbena'], $template); $template = str_replace("{TENSANBAY}", $row['tensanbay'], $template); //$ss->display('modules/Contracts/tpl/export.tpl'); $size = strlen($template); $filename = "CONTRACT_" . $row['number'] . ".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(); /*$ss->parse("main"); $ss->out("main");*/ /*$str = "<script> YAHOO.util.Event.addListener(window, 'load', SUGAR.util.fillShortcuts, $savedSearchSelects); </script>"; echo $str; */ }