<?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;
$module_type = $_REQUEST['module'];
$module = new Contract();
$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();
$contractvalue = array();
$sql = "SELECT * FROM contract_values WHERE contract_value_id ='" . $module->id . "'and deleted = 0";
$res = $module->db->query($sql);
while ($row = $module->db->fetchByAssoc($res)) {
$contractvalue[$row['id']] = $row['contract_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);
while ($row2 = $module->db->fetchByAssoc($res2)) {
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'modules/Contracts/Contract.php';
require_once 'include/formbase.php';
require_once 'modules/ContractConditions/ContractCondition.php';
require_once 'modules/ContractValues/ContractValue.php';
require_once 'modules/TransportContracts/TransportContracts.php';
require_once 'modules/FITs/CustomerRating.php';
include "config.php";
global $sugar_config;
$focus = new Contract();
$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;
*******************************************************************/
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;
$module_type = $_REQUEST['module'];
$module = new ContractLiquidate();
$module_type_file = strtoupper(ltrim(rtrim($module_type, 's'), ''));
$module_type_low = strtolower($module_type);
$module->retrieve($_REQUEST['contractid']);
//Lay thong tin cua hop dong goc
$contract = new Contract();
$contract->retrieve($module->contract_id);
//End
//Lay thong tin cua made tour
$madetour = new GroupProgram();
$madetour->retrieve($contract->groupprogr4251rograms_ida);
//End
//Lay thong tin cua tour
$tour = new Tour();
$tour->retrieve($madetour->tour_id);
//End
$task = $_REQUEST['task'];
$doc = new clsMsDocGenerator();
$contractliquidatevalue = array();
$sql = "SELECT * FROM contractliquidatevalues WHERE contract_liquidate_id ='" . $module->id . "'and deleted = 0";
$res = $module->db->query($sql);
while ($row = $module->db->fetchByAssoc($res)) {
$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);
while ($row2 = $module->db->fetchByAssoc($res2)) {
$transport_contract[$row2['id']] = $row2['contract_id'];
}
$doc->setFontFamily("Time New Roman");
$template = new AOS_PDF_Templates();
$template->retrieve($_REQUEST['templateID']);
$contract = new Contract();
$contract->retrieve($module->contracts_2225ntracts_ida);
$object_arr = array();
$object_arr[$module_type] = $module->id;
$object_arr['Contracts'] = $contract->id;
$search = array('@<script[^>]*?>.*?</script>@si', '@<[\\/\\!]*?[^<>]*?>@si', '@([\\r\\n])[\\s]+@', '@&(quot|#34);@i', '@&(amp|#38);@i', '@&(lt|#60);@i', '@&(gt|#62);@i', '@&(nbsp|#160);@i', '@&(iexcl|#161);@i', '@&#(\\d+);@e', '@<address[^>]*?>@si');
$replace = array('', '', '\\1', '"', '&', '<', '>', ' ', chr(161), 'chr(\\1)', '<br>');
$header = preg_replace($search, $replace, $template->pdfheader);
$footer = preg_replace($search, $replace, $template->pdffooter);
$text = preg_replace($search, $replace, $template->description);
$text = preg_replace('/\\{DATE\\s+(.*?)\\}/e', "date('\\1')", $text);
$printable = str_replace("\r\n", "<br />", $text);
global $sugar_config;
$firstValue = '';
$firstNum = 0;
$lastValue = '';
$lastNum = 0;
function display()
{
global $sugar_config, $mod_strings, $app_strings;
$focus = new ContractLiquidate();
$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"]) : '';
$focus->retrieve($record);
$template = file_get_contents('modules/ContractLiquidate/tpls/export.tpl');
//$sql = "select * from tours where id ='".$record."' and deleted = 0";
$contract = new Contract();
$contract->retrieve($focus->contract_id);
$template = str_replace("{DAY}", $focus->day, $template);
$template = str_replace("{MONTH}", $focus->month, $template);
$template = str_replace("{YEAR}", $focus->year, $template);
$template = str_replace("{position_a}", translate('position_dom', '', $contract->position_a), $template);
$template = str_replace("{position_b}", translate('position_dom', '', $contract->position_b), $template);
$template = str_replace("{address_a}", $contract->address_a, $template);
$template = str_replace("{phone_a}", $contract->phone_a, $template);
$template = str_replace("{fax_a}", $contract->fax_a, $template);
$template = str_replace("{mst_bena}", $contract->mst_bena, $template);
$template = str_replace("{BENB}", $contract->parent_name, $template);
$template = str_replace("{address_b}", $contract->address_b, $template);
$template = str_replace("{phone_b}", $contract->phone_b, $template);
$template = str_replace("{fax_b}", $contract->fax_b, $template);
$template = str_replace("{mst_benb}", $contract->mst_benb, $template);
$template = str_replace("{TONGCONG_CONTRACT_KEHOACH}", format_number($focus->tongcong_contract_kehoach), $template);
$template = str_replace("{TONGCONG_CONTRACT_THUCTE}", format_number($focus->tongcong_contract_thucte), $template);
$template = str_replace("{TONGCONG_TANG_KEHOACH}", format_number($focus->tongcong_tang_kehoach), $template);
$template = str_replace("{TONGCONG_TANG_THUCTE}", format_number($focus->tongcong_tang_thucte), $template);
$template = str_replace("{TONGCONG_GIAM_KEHOACH}", format_number($focus->tongcong_giam_kehoach), $template);
$template = str_replace("{TONGCONG_GIAM_THUCTE}", format_number($focus->tongcong_giam_thucte), $template);
$template = str_replace("{TONGTIEN_KEHOACH}", format_number($focus->tongtien_kehoach), $template);
$template = str_replace("{TONGTIEN_THUCTE}", format_number($focus->tongtien_thucte), $template);
$template = str_replace("{TIENTHANHTOAN}", format_number($focus->tienthanhtoan), $template);
$template = str_replace("{TIENCONLAI}", format_number($focus->tienconlai), $template);
$template = str_replace("{TIENTRALAI}", format_number($focus->tientralai), $template);
$template = str_replace("{GIATRIHOPDONG}", $focus->giatrihopdong_detail(), $template);
$template = str_replace("{PHATSINHTANG}", $focus->phatsinhtang_detail(), $template);
$template = str_replace("{PHATSINHGIAM}", $focus->phatsinhgiam_detail(), $template);
$template = str_replace("{BANGCHU}", $focus->bangchu, $template);
$template = str_replace("{DAIDIENBENA}", $contract->daidienbena, $template);
$template = str_replace("{DAIDIENBENB}", $contract->daidienbenb, $template);
$template = str_replace("{LBL_TITLE_THANH_LY}", $mod_strings['LBL_TITLE_THANH_LY'], $template);
$template = str_replace("{LBL_BEN_A}", $mod_strings['LBL_BEN_A'], $template);
$template = str_replace("{LBL_COM_NAME}", $mod_strings['LBL_COM_NAME'], $template);
$template = str_replace("{LBL_BEN_A_NAME}", $mod_strings['LBL_BEN_A_NAME'], $template);
$template = str_replace("{LBL_POSITION}", $mod_strings['LBL_POSITION'], $template);
$template = str_replace("{LBL_ADDRESS}", $mod_strings['LBL_ADDRESS'], $template);
$template = str_replace("{LBL_PHONE}", $mod_strings['LBL_PHONE'], $template);
$template = str_replace("{LBL_FAX}", $mod_strings['LBL_FAX'], $template);
$template = str_replace("{LBL_TAX}", $mod_strings['LBL_TAX'], $template);
$template = str_replace("{LBL_BEN_B}", $mod_strings['LBL_BEN_B'], $template);
$template = str_replace("{LBL_BEN_B_NAME}", $mod_strings['LBL_BEN_B_NAME'], $template);
$template = str_replace("{LBL_NOIDUNG_THANH_LY}", $mod_strings['LBL_NOIDUNG_THANH_LY'], $template);
$template = str_replace("{LBL_NOIDUNG}", $mod_strings['LBL_NOIDUNG'], $template);
$template = str_replace("{LBL_KEHOACH}", $mod_strings['LBL_KEHOACH'], $template);
$template = str_replace("{LBL_THUCTE}", $mod_strings['LBL_THUCTE'], $template);
$template = str_replace("{LBL_DONGIA}", $mod_strings['LBL_DONGIA'], $template);
$template = str_replace("{LBL_SL}", $mod_strings['LBL_SL'], $template);
$template = str_replace("{LBL_THANHTIEN}", $mod_strings['LBL_THANHTIEN'], $template);
$template = str_replace("{LBL_TONGGIATRIHD}", $mod_strings['LBL_TONGGIATRIHD'], $template);
$template = str_replace("{LBL_TONGCONG}", $mod_strings['LBL_TONGCONG'], $template);
$template = str_replace("{LBL_CHIPHIPHATSINHTANG}", $mod_strings['LBL_CHIPHIPHATSINHTANG'], $template);
$template = str_replace("{LBL_CHIPHIPHATSINHGIAM}", $mod_strings['LBL_CHIPHIPHATSINHGIAM'], $template);
$template = str_replace("{LBL_TONGTRIGIATOUR}", $mod_strings['LBL_TONGTRIGIATOUR'], $template);
$template = str_replace("{LBL_BENBTHANHTOANBENA}", $mod_strings['LBL_BENBTHANHTOANBENA'], $template);
$template = str_replace("{LBL_BENBNOBENA}", $mod_strings['LBL_BENBNOBENA'], $template);
$template = str_replace("{LBL_BENANOBENB}", $mod_strings['LBL_BENANOBENB'], $template);
$template = str_replace("{LBL_BANGCHU}", $mod_strings['LBL_BANGCHU'], $template);
$template = str_replace("{LBL_THONGTINCHUNG}", $mod_strings['LBL_THONGTINCHUNG'], $template);
$template = str_replace("{LBL_DAIDIENBENA}", $mod_strings['LBL_DAIDIENBENA'], $template);
$template = str_replace("{LBL_DAIDIENBENB}", $mod_strings['LBL_DAIDIENBENB'], $template);
$size = strlen($template);
$filename = $focus->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();
}
