<?php
require_once 'modules/AOS_PDF_Templates/clsMsDocGenerator.php';
require_once 'modules/AOS_PDF_Templates/PDF_Lib/mpdf.php';
require_once 'modules/AOS_PDF_Templates/templateParser.php';
require_once 'modules/AOS_PDF_Templates/sendEmail.php';
require_once 'modules/AOS_PDF_Templates/AOS_PDF_Templates.php';
global $mod_strings;
global $db;
$module_type = $_REQUEST['module'];
$module = new ContractAppendixs();
$module_type_file = strtoupper(ltrim(rtrim($module_type, 's'), ''));
$module_type_low = strtolower($module_type);
$module->retrieve($_REQUEST['contractid']);
$task = $_REQUEST['task'];
$doc = new clsMsDocGenerator();
$contractappendixvalue = array();
$sql = "SELECT * FROM contractappendixvalues WHERE contract_appendixs_value_id ='" . $module->id . "'and deleted = 0";
$res = $module->db->query($sql);
while ($row = $module->db->fetchByAssoc($res)) {
$contractappendixvalue[$row['id']] = $row['contract_appendixs_value_id'];
}
$contract_condition = array();
$sql1 = "SELECT * FROM contract_conditions WHERE contract_condition_id ='" . $module->id . "' AND deleted = 0";
$res1 = $module->db->query($sql1);
while ($row1 = $module->db->fetchByAssoc($res1)) {
$contract_condition[$row1['id']] = $row1['contract_condition_id'];
}
$transport_contract = array();
$sql2 = "SELECT * FROM transportcontracts WHERE contract_id='" . $this->id . "' AND deleted =0";
$res2 = $module->db->query($sql2);
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/ContractAppendixs/ContractAppendixs.php';
require_once 'include/formbase.php';
require_once 'modules/ContractConditions/ContractCondition.php';
require_once 'modules/ContractAppendixValues/ContractAppendixValues.php';
//require_once('modules/TransportContracts/TransportContracts.php');
include "config.php";
global $sugar_config;
global $db;
$focus = new ContractAppendixs();
$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];
// switch ($field) {
// case 'template_ddown_c':
// $value = implode("^,^",$_POST[$field]);
// break;
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/ContractAppendixs/ContractAppendixs.php';
require_once 'modules/ContractAppendixs/Forms.php';
require_once 'modules/Releases/Release.php';
global $db;
global $app_strings;
global $mod_strings;
global $mod_strings;
global $current_user;
global $timedate;
global $sugar_version, $sugar_config;
$focus = new ContractAppendixs();
$contract_condition = new ContractCondition();
$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";
function display()
{
$focus = new ContractAppendixs();
$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/ContractAppendixs/tpls/export.tpl');
$sql = "select * from contractappendixs 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);
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_APPENDIXS_" . $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; */
}
