public static function GetInstance() { if (self::$instance == null) { self::$instance = new PDFMaker_Debugger_Model(); } return self::$instance; }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DETAIL") == false) { $PDFMaker->DieDuePermission(); } $viewer = $this->getViewer($request); if ($request->has('templateid') && !$request->isEmpty('templateid')) { $pdftemplateResult = $PDFMaker->GetDetailViewData($_REQUEST['templateid']); $viewer->assign("TEMPLATEID", $pdftemplateResult["templateid"]); $viewer->assign("MODULENAME", getTranslatedString($pdftemplateResult["module"])); $viewer->assign("BODY", decode_html($pdftemplateResult["body"])); $viewer->assign("HEADER", decode_html($pdftemplateResult["header"])); $viewer->assign("FOOTER", decode_html($pdftemplateResult["footer"])); } $version_type = $PDFMaker->GetVersionType(); $viewer->assign("VERSION", $version_type . " " . PDFMaker_Version_Helper::$version); if ($PDFMaker->CheckPermissions("EDIT") && $PDFMaker->GetVersionType() != "deactivate") { $viewer->assign("EDIT", "permitted"); } $category = getParentTab(); $viewer->assign("CATEGORY", $category); $viewer->view('Detail.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $rel_module = $request->get('pdfmodule'); $this->relblockid = $request->get('record'); $name = $request->get('blockname'); $module = $request->get('primarymodule'); $secmodule = $request->get('secondarymodule'); $block = $request->get('relatedblock'); $standardFilter = $request->get('standard_fiter'); $advancedFilter = $request->get('advanced_filter'); $advancedGroupFilterConditions = $request->get('advanced_group_condition'); $sortFields = $request->get('selected_sort_fields'); if ($this->relblockid != "") { $sql = "UPDATE vtiger_pdfmaker_relblocks SET name=?, block=? WHERE relblockid=?"; $adb->pquery($sql, array($name, $block, $this->relblockid)); } else { $this->relblockid = $adb->getUniqueID('vtiger_pdfmaker_relblocks'); $sql = "INSERT INTO vtiger_pdfmaker_relblocks (relblockid, name, module, secmodule, block) VALUES (?,?,?,?,?)"; $adb->pquery($sql, array($this->relblockid, $name, $module, $secmodule, $block)); $selectedFields = $request->get('selected_fields'); $this->saveSelectedFields($selectedFields); } $this->saveAdvancedFilters($advancedFilter); $this->saveSortFields($sortFields); echo "<script>window.opener.PDFMaker_EditJs.refresh_related_blocks_array('" . $this->relblockid . "');\n self.close();\n </script>"; }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $viewer = $this->getViewer($request); $currentLanguage = Vtiger_Language_Handler::getLanguage(); list($oLabels, $languages) = $PDFMaker->GetCustomLabels(); $currLang = array(); foreach ($languages as $langId => $langVal) { if ($langVal["prefix"] == $currentLanguage) { $currLang["id"] = $langId; $currLang["name"] = $langVal["name"]; $currLang["label"] = $langVal["label"]; $currLang["prefix"] = $langVal["prefix"]; break; } } $viewLabels = array(); foreach ($oLabels as $lblId => $oLabel) { $viewLabels[$lblId]["key"] = $oLabel->GetKey(); $viewLabels[$lblId]["lang_values"] = $oLabel->GetLangValsArr(); } $viewer->assign("LABELS", $viewLabels); $viewer->assign("LANGUAGES", $languages); $viewer->assign("CURR_LANG", $currLang); $viewer->view('CustomLabels.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $viewer = $this->getViewer($request); $mode = $request->get('mode'); $viewer->assign("MODE", $mode); $viewer->view('Uninstall.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DELETE") == false) { $PDFMaker->DieDuePermission(); } $adb = PearDatabase::getInstance(); $id_array = array(); if ($request->has('templateid') && !$request->isEmpty('templateid')) { $templateid = $request->get('templateid'); $checkSql = "select module from vtiger_pdfmaker where templateid=?"; $checkRes = $adb->pquery($checkSql, array($templateid)); $checkRow = $adb->fetchByAssoc($checkRes); //if we are trying to delete template that is not allowed for current user then die because user should not be able to see the template //$PDFMaker->CheckTemplatePermissions($checkRow["module"], $templateid); $Template_Permissions_Data = $PDFMaker->returnTemplatePermissionsData($checkRow["module"], $templateid); if ($Template_Permissions_Data["delete"] === false) { $this->DieDuePermission(); } $sql = "delete from vtiger_pdfmaker where templateid=?"; $adb->pquery($sql, array($templateid)); $sql = "delete from vtiger_pdfmaker_settings where templateid=?"; $adb->pquery($sql, array($templateid)); } else { $idlist = $request->get('idlist'); $id_array = explode(';', $idlist); $checkSql = "select templateid, module from vtiger_pdfmaker where templateid IN (" . generateQuestionMarks($id_array) . ")"; $checkRes = $adb->pquery($checkSql, $id_array); $checkArr = array(); while ($checkRow = $adb->fetchByAssoc($checkRes)) { $checkArr[$checkRow["templateid"]] = $checkRow["module"]; } for ($i = 0; $i < count($id_array) - 1; $i++) { //if we are trying to delete template that is not allowed for current user then die because user should not be able to see the template //$PDFMaker->CheckTemplatePermissions($checkArr[$id_array[$i]], $id_array[$i]); $Template_Permissions_Data = $PDFMaker->returnTemplatePermissionsData($checkArr[$id_array[$i]], $id_array[$i]); if ($Template_Permissions_Data["delete"] === false) { $this->DieDuePermission(); } $sql = "delete from vtiger_pdfmaker where templateid=?"; $adb->pquery($sql, array($id_array[$i])); $sql = "delete from vtiger_pdfmaker_settings where templateid=?"; $adb->pquery($sql, array($id_array[$i])); } } $ajaxDelete = $request->get('ajaxDelete'); $listViewUrl = "index.php?module=PDFMaker&view=List"; if ($ajaxDelete) { $response = new Vtiger_Response(); $response->setResult($listViewUrl); return $response; } else { header("Location: {$listViewUrl}"); } }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $viewer = $this->getViewer($request); $mode = $request->get('mode'); $viewer->assign("MODE", $mode); $viewer->assign("LICENSE", $PDFMaker->GetLicenseKey()); $viewer->assign("VERSION_TYPE", $PDFMaker->GetVersionType()); $viewer->view('License.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $viewer = $this->getViewer($request); $currentLanguage = Vtiger_Language_Handler::getLanguage(); $sql = "SELECT * FROM vtiger_pdfmaker_productbloc_tpl"; $result = $adb->pquery($sql, array()); while ($row = $adb->fetchByAssoc($result)) { $templates[$row["id"]]["name"] = $row["name"]; $templates[$row["id"]]["body"] = html_entity_decode($row["body"], ENT_QUOTES); } $viewer->assign("PB_TEMPLATES", $templates); $viewer->view('ProductBlocks.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DETAIL") == false) { $PDFMaker->DieDuePermission(); } $viewer = $this->getViewer($request); if ($request->has('templateid') && !$request->isEmpty('templateid')) { $pdftemplateResult = $PDFMaker->GetDetailViewData($_REQUEST['templateid']); $viewer->assign("FILENAME", $pdftemplateResult["filename"]); $viewer->assign("DESCRIPTION", $pdftemplateResult["description"]); $viewer->assign("TEMPLATEID", $pdftemplateResult["templateid"]); $viewer->assign("MODULENAME", getTranslatedString($pdftemplateResult["module"])); $viewer->assign("BODY", decode_html($pdftemplateResult["body"])); $viewer->assign("HEADER", decode_html($pdftemplateResult["header"])); $viewer->assign("FOOTER", decode_html($pdftemplateResult["footer"])); $viewer->assign("IS_ACTIVE", $pdftemplateResult["is_active"]); $viewer->assign("IS_DEFAULT", $pdftemplateResult["is_default"]); $viewer->assign("ACTIVATE_BUTTON", $pdftemplateResult["activateButton"]); $viewer->assign("DEFAULT_BUTTON", $pdftemplateResult["defaultButton"]); } $version_type = $PDFMaker->GetVersionType(); $viewer->assign("VERSION", $version_type . " " . PDFMaker_Version_Helper::$version); if ($pdftemplateResult["permissions"]["edit"]) { //if ($PDFMaker->CheckPermissions("EDIT")) { $viewer->assign("EXPORT", "yes"); } if ($PDFMaker->GetVersionType() != "deactivate") { if ($pdftemplateResult["permissions"]["edit"]) { //if ($PDFMaker->CheckPermissions("EDIT") && $PDFMaker->GetVersionType() != "deactivate") { $viewer->assign("EDIT", "permitted"); $viewer->assign("IMPORT", "yes"); } if ($pdftemplateResult["permissions"]["delete"]) { $viewer->assign("DELETE", "permitted"); } } //$tool_buttons = Button_Check('PDFMaker'); //$viewer->assign('CHECK', $tool_buttons); $category = getParentTab(); $viewer->assign("CATEGORY", $category); $viewer->view('Detail.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $PDFMaker = new PDFMaker_PDFMaker_Model(); //Debugger::GetInstance()->Init(); $viewer = $this->getViewer($request); $permissions = $PDFMaker->GetProfilesPermissions(); $profilesActions = $PDFMaker->GetProfilesActions(); $actionEDIT = getActionid($profilesActions["EDIT"]); $actionDETAIL = getActionid($profilesActions["DETAIL"]); $actionDELETE = getActionid($profilesActions["DELETE"]); $actionEXPORT_RTF = getActionid($profilesActions["EXPORT_RTF"]); $mode = $request->get('mode'); $viewer->assign("MODE", $mode); $permissionNames = array(); foreach ($permissions as $profileid => $subArr) { $permissionNames[$profileid] = array(); $profileName = $this->getProfileName($profileid); foreach ($subArr as $actionid => $perm) { $permStr = $perm == "0" ? 'checked="checked"' : ""; switch ($actionid) { case $actionEDIT: $permissionNames[$profileid][$profileName]["EDIT"]["name"] = 'priv_chk_' . $profileid . '_' . $actionEDIT; $permissionNames[$profileid][$profileName]["EDIT"]["checked"] = $permStr; break; case $actionDETAIL: $permissionNames[$profileid][$profileName]["DETAIL"]["name"] = 'priv_chk_' . $profileid . '_' . $actionDETAIL; $permissionNames[$profileid][$profileName]["DETAIL"]["checked"] = $permStr; break; case $actionDELETE: $permissionNames[$profileid][$profileName]["DELETE"]["name"] = 'priv_chk_' . $profileid . '_' . $actionDELETE; $permissionNames[$profileid][$profileName]["DELETE"]["checked"] = $permStr; break; case $actionEXPORT_RTF: $permissionNames[$profileid][$profileName]["EXPORT_RTF"]["name"] = 'priv_chk_' . $profileid . '_' . $actionEXPORT_RTF; $permissionNames[$profileid][$profileName]["EXPORT_RTF"]["checked"] = $permStr; break; } } } $viewer->assign("PERMISSIONS", $permissionNames); $viewer->view('ProfilesPrivilegies.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $viewer = $this->getViewer($request); $extensions = array(); $link = "index.php?module=PDFMaker&action=IndexAjax&mode=downloadFile&parenttab=Tools&extid="; $extname = "CustomerPortal"; $extensions[$extname]["label"] = "LBL_CUSTOMERPORTAL"; $extensions[$extname]["desc"] = "LBL_CUSTOMERPORTAL_DESC"; $extensions[$extname]["exinstall"] = "LBL_CP_EXPRESS_INSTAL_EXT"; $extensions[$extname]["manual"] = $link . $extname . "&type=manual"; $extensions[$extname]["download"] = $link . $extname . "&type=download"; $extensions[$extname]["install"] = ""; $extname = "Workflow"; $extensions[$extname]["label"] = "LBL_WORKFLOW"; $extensions[$extname]["desc"] = "LBL_WORKFLOW_DESC"; $extensions[$extname]["exinstall"] = ""; $extensions[$extname]["manual"] = ""; $extensions[$extname]["download"] = ""; $PDFMaker = new PDFMaker_PDFMaker_Model(); $control = $PDFMaker->controlWorkflows(); if ($control) { $extensions[$extname]["install_info"] = vtranslate("LBL_WORKFLOWS_ARE_ALREADY_INSTALLED", "PDFMaker"); $extensions[$extname]["install"] = ""; } else { $extensions[$extname]["install_info"] = ""; $extensions[$extname]["install"] = $link . $extname . "&type=install"; } $viewer->assign("EXTENSIONS_ARR", $extensions); $download_error = $request->get('download_error'); if (isset($download_error) && $download_error != "") { $viewer->assign("ERROR", "true"); } $viewer->view('Extensions.tpl', 'PDFMaker'); }
function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); //parent::process($request); $viewer = $this->getViewer($request); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("EDIT")) { $viewer->assign("EXPORT", "yes"); if ($PDFMaker->GetVersionType() != "deactivate") { $viewer->assign("IMPORT", "yes"); } } if ($request->get('from_view') == 'Detail' && !$request->isEmpty('from_templateid')) { $viewer->assign('ALLOW_SET_AS', 'yes'); $pdftemplateResult = $PDFMaker->GetDetailViewData($request->get('from_templateid')); $viewer->assign("IS_ACTIVE", $pdftemplateResult["is_active"]); $viewer->assign("IS_DEFAULT", $pdftemplateResult["is_default"]); $viewer->assign("ACTIVATE_BUTTON", $pdftemplateResult["activateButton"]); $viewer->assign("DEFAULT_BUTTON", $pdftemplateResult["defaultButton"]); $viewer->assign("TEMPLATEID", $request->get('from_templateid')); } //print_r($_REQUEST); $viewer->view('TemplateTools.tpl', 'PDFMaker'); }
public function getList(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DETAIL") == false) { $PDFMaker->DieDuePermission(); } $viewer = $this->getViewer($request); $orderby = "templateid"; $dir = "asc"; if (isset($_REQUEST["dir"]) && $_REQUEST["dir"] == "desc") { $dir = "desc"; } if (isset($_REQUEST["orderby"])) { switch ($_REQUEST["orderby"]) { case "name": $orderby = "filename"; break; case "module": $orderby = "module"; break; case "description": $orderby = "description"; break; case "order": $orderby = "order"; break; default: $orderby = $_REQUEST["orderby"]; break; } } $version_type = $PDFMaker->GetVersionType(); $license_key = $PDFMaker->GetLicenseKey(); $viewer->assign("VERSION_TYPE", $version_type); $viewer->assign("VERSION", ucfirst($version_type) . " " . PDFMaker_Version_Helper::$version); $viewer->assign("LICENSE_KEY", $license_key); // $to_update = "false"; // $smarty->assign("TO_UPDATE",$to_update); if ($PDFMaker->CheckPermissions("EDIT")) { $viewer->assign("EXPORT", "yes"); } if ($PDFMaker->CheckPermissions("EDIT") && $PDFMaker->GetVersionType() != "deactivate") { $viewer->assign("EDIT", "permitted"); $viewer->assign("IMPORT", "yes"); } if ($PDFMaker->CheckPermissions("DELETE") && $PDFMaker->GetVersionType() != "deactivate") { $viewer->assign("DELETE", "permitted"); } $notif = $PDFMaker->GetReleasesNotif(); $viewer->assign("RELEASE_NOTIF", $notif); $php_version = phpversion(); $notif = false; $max_in_vars = ini_get("max_input_vars"); if ($max_in_vars <= 1000 && $php_version >= "5.3.9") { $notif = true; } $test = ini_set("memory_limit", "256M"); $memory_limit = ini_get("memory_limit"); if (substr($memory_limit, 0, -1) <= 128) { $notif = true; } $max_exec_time = ini_get("max_execution_time"); if ($max_exec_time <= 60) { $notif = true; } if (extension_loaded('suhosin')) { $request_max_vars = ini_get("suhosin.request.max_vars"); $post_max_vars = ini_get("suhosin.post.max_vars"); if ($request_max_vars <= 1000) { $notif = true; } if ($post_max_vars <= 1000) { $notif = true; } } if ($notif === true) { //$notif = '<a href="index.php?module=PDFMaker&action=Debugging&parenttab=Settings" title="' . vtranslate("LBL_GOTO_DEBUG","PDFMaker") . '" style="color:red;">' . vtranslate("LBL_DBG_NOTIF","PDFMaker") . '</a>'; //$viewer->assign("DEBUG_NOTIF", $notif); } $viewer->assign("MOD", $mod_strings); $viewer->assign("APP", $app_strings); $viewer->assign("THEME", $theme); $viewer->assign("PARENTTAB", getParentTab()); $viewer->assign("IMAGE_PATH", $image_path); $viewer->assign("ORDERBY", $orderby); $viewer->assign("DIR", $dir); $return_data = $PDFMaker->GetListviewData($orderby, $dir); $viewer->assign("PDFTEMPLATES", $return_data); $category = getParentTab(); $viewer->assign("CATEGORY", $category); if (is_admin($current_user)) { $viewer->assign('IS_ADMIN', '1'); } //$tool_buttons = Button_Check($currentModule); //$viewer->assign('CHECK', $tool_buttons); $linkParams = array('MODULE' => $moduleName, 'ACTION' => $request->get('view')); $linkModels = $PDFMaker->getListViewLinks($linkParams); $viewer->assign('LISTVIEW_MASSACTIONS', $linkModels['LISTVIEWMASSACTION']); $viewer->assign('LISTVIEW_LINKS', $linkModels); $tpl = "ListPDFTemplates"; if ($request->get('ajax') == "true") { $tpl .= "Contents"; } $viewer->view($tpl . ".tpl", 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("EDIT") == false) { $PDFMaker->DieDuePermission(); } $viewer = $this->getViewer($request); if ($request->has('templateid') && !$request->isEmpty('templateid')) { $templateid = $request->get('templateid'); $pdftemplateResult = $PDFMaker->GetEditViewData($templateid); $select_module = $pdftemplateResult["module"]; $select_format = $pdftemplateResult["format"]; $select_orientation = $pdftemplateResult["orientation"]; } else { $templateid = ""; if ($request->has("return_module") && !$request->isEmpty("return_module")) { $select_module = $request->get("return_module"); } else { $select_module = ""; } $select_format = "A4"; $select_orientation = "portrait"; } $PDFMaker->CheckTemplatePermissions($select_module, $templateid); $viewer->assign("EMODE", "edit"); $viewer->assign("TEMPLATEID", $templateid); $viewer->assign("MODULENAME", vtranslate($select_module, $select_module)); $viewer->assign("SELECTMODULE", $select_module); $viewer->assign("BODY", $pdftemplateResult["body"]); $cu_model = Users_Record_Model::getCurrentUserModel(); $this->cu_language = $cu_model->get('language'); $viewer->assign("THEME", $theme); $viewer->assign("IMAGE_PATH", $image_path); $app_strings_big = Vtiger_Language_Handler::getModuleStringsFromFile($this->cu_language); $app_strings = $app_strings_big['languageStrings']; $viewer->assign("APP", $app_strings); $viewer->assign("PARENTTAB", getParentTab()); $modArr = $PDFMaker->GetAllModules(); $Modulenames = $modArr[0]; $ModuleIDS = $modArr[1]; // ****************************************** Company and User information: ********************************** $CUI_BLOCKS["Account"] = vtranslate("LBL_COMPANY_INFO", 'PDFMaker'); $CUI_BLOCKS["Assigned"] = vtranslate("LBL_USER_INFO", 'PDFMaker'); $CUI_BLOCKS["Logged"] = vtranslate("LBL_LOGGED_USER_INFO", 'PDFMaker'); $viewer->assign("CUI_BLOCKS", $CUI_BLOCKS); $adb = PearDatabase::getInstance(); $sql = "SELECT * FROM vtiger_organizationdetails"; $result = $adb->pquery($sql, array()); $organization_logoname = decode_html($adb->query_result($result, 0, 'logoname')); $organization_header = decode_html($adb->query_result($result, 0, 'headername')); $organization_stamp_signature = $adb->query_result($result, 0, 'stamp_signature'); global $site_URL; $path = $site_URL . "/test/logo/"; if (isset($organization_logoname)) { $organization_logo_img = "<img src=\"" . $path . $organization_logoname . "\">"; $viewer->assign("COMPANYLOGO", $organization_logo_img); } if (isset($organization_stamp_signature)) { $organization_stamp_signature_img = "<img src=\"" . $path . $organization_stamp_signature . "\">"; $viewer->assign("COMPANY_STAMP_SIGNATURE", $organization_stamp_signature_img); } if (isset($organization_header)) { $organization_header_img = "<img src=\"" . $path . $organization_header . "\">"; $viewer->assign("COMPANY_HEADER_SIGNATURE", $organization_header_img); } $Acc_Info = array('' => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "COMPANY_NAME" => vtranslate("LBL_COMPANY_NAME", 'PDFMaker'), "COMPANY_LOGO" => vtranslate("LBL_COMPANY_LOGO", 'PDFMaker'), "COMPANY_ADDRESS" => vtranslate("LBL_COMPANY_ADDRESS", 'PDFMaker'), "COMPANY_CITY" => vtranslate("LBL_COMPANY_CITY", 'PDFMaker'), "COMPANY_STATE" => vtranslate("LBL_COMPANY_STATE", 'PDFMaker'), "COMPANY_ZIP" => vtranslate("LBL_COMPANY_ZIP", 'PDFMaker'), "COMPANY_COUNTRY" => vtranslate("LBL_COMPANY_COUNTRY", 'PDFMaker'), "COMPANY_PHONE" => vtranslate("LBL_COMPANY_PHONE", "PDFMaker"), "COMPANY_FAX" => vtranslate("LBL_COMPANY_FAX", 'PDFMaker'), "COMPANY_WEBSITE" => vtranslate("LBL_COMPANY_WEBSITE", 'PDFMaker')); $viewer->assign("ACCOUNTINFORMATIONS", $Acc_Info); $sql_user_block = "SELECT blockid, blocklabel FROM vtiger_blocks WHERE tabid=29 ORDER BY sequence ASC"; $res_user_block = $adb->query($sql_user_block); $user_block_info_arr = array(); while ($row_user_block = $adb->fetch_array($res_user_block)) { $sql_user_field = "SELECT fieldid, uitype FROM vtiger_field WHERE block=" . $row_user_block['blockid'] . " and (displaytype != 3 OR uitype = 55) ORDER BY sequence ASC"; $res_user_field = $adb->query($sql_user_field); $num_user_field = $adb->num_rows($res_user_field); if ($num_user_field > 0) { $user_field_id_array = array(); while ($row_user_field = $adb->fetch_array($res_user_field)) { $user_field_id_array[] = $row_user_field['fieldid']; // print_r($user_field_id_array); } $user_block_info_arr[$row_user_block['blocklabel']] = $user_field_id_array; } } $user_mod_strings = $this->getModuleLanguageArray("Users"); $b = 0; foreach ($user_block_info_arr as $block_label => $block_fields) { $b++; if (isset($user_mod_strings[$block_label]) and $user_mod_strings[$block_label] != "") { $optgroup_value = $user_mod_strings[$block_label]; } else { $optgroup_value = vtranslate($block_label, 'PDFMaker'); } if (count($block_fields) > 0) { $field_ids = implode(",", $block_fields); $sql1 = "SELECT * FROM vtiger_field WHERE fieldid IN (" . $field_ids . ")"; $result1 = $adb->query($sql1); while ($row1 = $adb->fetchByAssoc($result1)) { $fieldname = $row1['fieldname']; $fieldlabel = $row1['fieldlabel']; $option_key = strtoupper("Users" . "_" . $fieldname); if (isset($current_mod_strings[$fieldlabel]) and $current_mod_strings[$fieldlabel] != "") { $option_value = $current_mod_strings[$fieldlabel]; } elseif (isset($app_strings[$fieldlabel]) and $app_strings[$fieldlabel] != "") { $option_value = $app_strings[$fieldlabel]; } else { $option_value = $fieldlabel; } $User_Info[$optgroup_value][$option_key] = $option_value; $Logged_User_Info[$optgroup_value]["R_" . $option_key] = $option_value; } } //variable RECORD ID added if ($b == 1) { $option_value = "Record ID"; $option_key = strtoupper("USERS_CRMID"); $User_Info[$optgroup_value][$option_key] = $option_value; $Logged_User_Info[$optgroup_value]["R_" . $option_key] = $option_value; } //end } // ****************************************** END: Company and User information ********************************** $viewer->assign("USERINFORMATIONS", $User_Info); $viewer->assign("LOGGEDUSERINFORMATION", $Logged_User_Info); $Invterandcon = array("" => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "TERMS_AND_CONDITIONS" => vtranslate("LBL_TERMS_AND_CONDITIONS", 'PDFMaker')); $viewer->assign("INVENTORYTERMSANDCONDITIONS", $Invterandcon); //labels $global_lang_labels = @array_flip($app_strings); $global_lang_labels = @array_flip($global_lang_labels); asort($global_lang_labels); $viewer->assign("GLOBAL_LANG_LABELS", $global_lang_labels); $module_lang_labels = array(); if ($select_module != "") { $mod_lang = $this->getModuleLanguageArray($select_module); $module_lang_labels = @array_flip($mod_lang); $module_lang_labels = @array_flip($module_lang_labels); asort($module_lang_labels); } else { $module_lang_labels[""] = vtranslate("LBL_SELECT_MODULE_FIELD", 'PDFMaker'); } $viewer->assign("MODULE_LANG_LABELS", $module_lang_labels); $Header_Footer_Strings = array("" => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "PAGE" => $app_strings["Page"], "PAGES" => $app_strings["Pages"]); $viewer->assign("HEADER_FOOTER_STRINGS", $Header_Footer_Strings); //PDF FORMAT SETTINGS $Formats = array("A3" => "A3", "A4" => "A4", "A5" => "A5", "A6" => "A6", "Letter" => "Letter", "Legal" => "Legal", "Custom" => "Custom"); // ITS4YOU VlZa $viewer->assign("FORMATS", $Formats); if (strpos($select_format, ";") > 0) { $tmpArr = explode(";", $select_format); $select_format = "Custom"; $custom_format["width"] = $tmpArr[0]; $custom_format["height"] = $tmpArr[1]; $viewer->assign("CUSTOM_FORMAT", $custom_format); } $viewer->assign("SELECT_FORMAT", $select_format); //PDF ORIENTATION SETTINGS $Orientations = array("portrait" => vtranslate("portrait", 'PDFMaker'), "landscape" => vtranslate("landscape", 'PDFMaker')); $viewer->assign("ORIENTATIONS", $Orientations); $viewer->assign("SELECT_ORIENTATION", $select_orientation); //PDF MARGIN SETTINGS if ($request->has("templateid") && !$request->isEmpty("templateid")) { $Margins = array("top" => $pdftemplateResult["margin_top"], "bottom" => $pdftemplateResult["margin_bottom"], "left" => $pdftemplateResult["margin_left"], "right" => $pdftemplateResult["margin_right"]); $Decimals = array("point" => $pdftemplateResult["decimal_point"], "decimals" => $pdftemplateResult["decimals"], "thousands" => $pdftemplateResult["thousands_separator"] != "sp" ? $pdftemplateResult["thousands_separator"] : " "); } else { $Margins = array("top" => "2", "bottom" => "2", "left" => "2", "right" => "2"); $Decimals = array("point" => ",", "decimals" => "2", "thousands" => " "); } $viewer->assign("MARGINS", $Margins); $viewer->assign("DECIMALS", $Decimals); //PDF HEADER / FOOTER $header = ""; $footer = ""; if ($request->has("templateid") && !$request->isEmpty("templateid")) { $header = $pdftemplateResult["header"]; $footer = $pdftemplateResult["footer"]; } $viewer->assign("HEADER", $header); $viewer->assign("FOOTER", $footer); $hfVariables = array("##PAGE##" => vtranslate("LBL_CURRENT_PAGE", 'PDFMaker'), "##PAGES##" => vtranslate("LBL_ALL_PAGES", 'PDFMaker'), "##PAGE##/##PAGES##" => vtranslate("LBL_PAGE_PAGES", 'PDFMaker')); $viewer->assign("HEAD_FOOT_VARS", $hfVariables); $dateVariables = array("##DD.MM.YYYY##" => vtranslate("LBL_DATE_DD.MM.YYYY", 'PDFMaker'), "##DD-MM-YYYY##" => vtranslate("LBL_DATE_DD-MM-YYYY", 'PDFMaker'), "##MM-DD-YYYY##" => vtranslate("LBL_DATE_MM-DD-YYYY", 'PDFMaker'), "##YYYY-MM-DD##" => vtranslate("LBL_DATE_YYYY-MM-DD", 'PDFMaker')); $viewer->assign("DATE_VARS", $dateVariables); $cmod = $this->getModuleLanguageArray("Settings"); //$cmod = return_specified_module_language($current_language, "Settings"); $viewer->assign("CMOD", $cmod); //Ignored picklist values $pvsql = "SELECT value FROM vtiger_pdfmaker_ignorepicklistvalues"; $pvresult = $adb->query($pvsql); $pvvalues = ""; while ($pvrow = $adb->fetchByAssoc($pvresult)) { $pvvalues .= $pvrow["value"] . ", "; } $viewer->assign("IGNORE_PICKLIST_VALUES", rtrim($pvvalues, ", ")); $More_Fields = array("CURRENCYNAME" => vtranslate("LBL_CURRENCY_NAME", 'PDFMaker'), "CURRENCYSYMBOL" => vtranslate("LBL_CURRENCY_SYMBOL", 'PDFMaker'), "CURRENCYCODE" => vtranslate("LBL_CURRENCY_CODE", 'PDFMaker'), "TOTALWITHOUTVAT" => vtranslate("LBL_VARIABLE_SUMWITHOUTVAT", 'PDFMaker'), "TOTALDISCOUNT" => vtranslate("LBL_VARIABLE_TOTALDISCOUNT", 'PDFMaker'), "TOTALDISCOUNTPERCENT" => vtranslate("LBL_VARIABLE_TOTALDISCOUNT_PERCENT", 'PDFMaker'), "TOTALAFTERDISCOUNT" => vtranslate("LBL_VARIABLE_TOTALAFTERDISCOUNT", 'PDFMaker'), "VAT" => vtranslate("LBL_VARIABLE_VAT", 'PDFMaker'), "VATPERCENT" => vtranslate("LBL_VARIABLE_VAT_PERCENT", 'PDFMaker'), "VATBLOCK" => vtranslate("LBL_VARIABLE_VAT_BLOCK", 'PDFMaker'), "TOTALWITHVAT" => vtranslate("LBL_VARIABLE_SUMWITHVAT", 'PDFMaker'), "SHTAXTOTAL" => vtranslate("LBL_SHTAXTOTAL", 'PDFMaker'), "SHTAXAMOUNT" => vtranslate("LBL_SHTAXAMOUNT", 'PDFMaker'), "ADJUSTMENT" => vtranslate("LBL_ADJUSTMENT", 'PDFMaker'), "TOTAL" => vtranslate("LBL_VARIABLE_TOTALSUM", 'PDFMaker')); //formatable VATBLOCK content $vatblock_table = '<table border="1" cellpadding="3" cellspacing="0" style="border-collapse:collapse;"> <tr> <td>' . $app_strings["Name"] . '</td> <td>' . vtranslate("LBL_VATBLOCK_VAT_PERCENT", 'PDFMaker') . '</td> <td>' . vtranslate("LBL_VATBLOCK_SUM", 'PDFMaker') . '</td> <td>' . vtranslate("LBL_VATBLOCK_VAT_VALUE", 'PDFMaker') . '</td> </tr> <tr> <td colspan="4">#VATBLOCK_START#</td> </tr> <tr> <td>$VATBLOCK_LABEL$</td> <td>$VATBLOCK_VALUE$</td> <td>$VATBLOCK_NETTO$</td> <td>$VATBLOCK_VAT$</td> </tr> <tr> <td colspan="4">#VATBLOCK_END#</td> </tr> </table>'; $vatblock_table = str_replace(array("\r\n", "\r", "\n", "\t"), "", $vatblock_table); $vatblock_table = ereg_replace(" {2,}", ' ', $vatblock_table); $viewer->assign("VATBLOCK_TABLE", $vatblock_table); $ModCommentsModules = array(); foreach ($ModuleIDS as $module => $IDS) { if ($module == 'Calendar') { $sql1 = "SELECT blockid, blocklabel FROM vtiger_blocks WHERE tabid IN (9,16) ORDER BY sequence ASC"; } elseif ($module == "Quotes" || $module == "Invoice" || $module == "SalesOrder" || $module == "PurchaseOrder" || $module == "Issuecards" || $module == "Receiptcards" || $module == "Creditnote" || $module == "StornoInvoice") { $sql1 = "SELECT blockid, blocklabel FROM vtiger_blocks WHERE tabid=" . $IDS . " AND blocklabel != 'LBL_DETAILS_BLOCK' AND blocklabel != 'LBL_ITEM_DETAILS' ORDER BY sequence ASC"; } else { $sql1 = "SELECT blockid, blocklabel FROM vtiger_blocks WHERE tabid=" . $IDS . " ORDER BY sequence ASC"; } $res1 = $adb->query($sql1); $block_info_arr = array(); while ($row = $adb->fetch_array($res1)) { if ($row['blockid'] == '41' && $row['blocklabel'] == '') { $row['blocklabel'] = 'LBL_EVENT_INFORMATION'; } $sql2 = "SELECT fieldid, uitype, columnname, fieldlabel\n FROM vtiger_field\n WHERE block=" . $row['blockid'] . "\n AND (displaytype != 3 OR uitype = 55)\n ORDER BY sequence ASC"; $res2 = $adb->query($sql2); $num_rows2 = $adb->num_rows($res2); if ($num_rows2 > 0) { $field_id_array = array(); while ($row2 = $adb->fetch_array($res2)) { $field_id_array[] = $row2['fieldid']; $tmpArr = array($row2["columnname"], $row2["fieldlabel"]); switch ($row2['uitype']) { case "51": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Accounts"); break; case "57": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Contacts"); break; case "58": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Campaigns"); break; case "59": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Products"); break; case "73": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Accounts"); break; case "75": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Vendors"); break; case "81": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Vendors"); break; case "76": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Potentials"); break; case "78": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Quotes"); break; case "80": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "SalesOrder"); break; case "68": $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Accounts"); $All_Related_Modules[$module][] = array_merge($tmpArr, (array) "Contacts"); break; case "10": $fmrs = $adb->query('SELECT relmodule FROM vtiger_fieldmodulerel WHERE fieldid=' . $row2['fieldid']); while ($rm = $adb->fetch_array($fmrs)) { $All_Related_Modules[$module][] = array_merge($tmpArr, (array) $rm['relmodule']); } break; } } // ITS4YOU MaJu //$block_info_arr[$row['blocklabel']] = $field_id_array; if (!empty($block_info_arr[$row['blocklabel']])) { foreach ($field_id_array as $field_id_array_value) { $block_info_arr[$row['blocklabel']][] = $field_id_array_value; } } else { $block_info_arr[$row['blocklabel']] = $field_id_array; } // ITS4YOU-END } } if ($module == "Quotes" || $module == "Invoice" || $module == "SalesOrder" || $module == "PurchaseOrder") { $block_info_arr["LBL_DETAILS_BLOCK"] = array(); } //ModComments support //if (in_array($module, $ModCommentsModules)) { // $block_info_arr["TEMP_MODCOMMENTS_BLOCK"] = array(); //} $ModuleFields[$module] = $block_info_arr; } //Permissions are taken into consideration when dealing with realted modules $AllowedRelMods = array(); if (count($All_Related_Modules) > 0) { foreach ($All_Related_Modules as $Mod => $RelMods) { foreach ($RelMods as $RelModKey => $RelMod) { $RelModName = $RelMod[2]; if (isPermitted($RelModName, '') == "yes") { $AllowedRelMods[$Mod][$RelModKey] = $RelMod; } } } } $All_Related_Modules = $AllowedRelMods; // Fix of emtpy selectbox in case of selected module does not have any related modules foreach ($Modulenames as $key => $value) { if (!isset($All_Related_Modules[$key])) { $All_Related_Modules[$key] = array(); } } $viewer->assign("ALL_RELATED_MODULES", $All_Related_Modules); if ($select_module != "" && count($All_Related_Modules[$select_module]) > 0) { foreach ($All_Related_Modules[$select_module] as $RelModArr) { $Related_Modules[$RelModArr[2] . "|" . $RelModArr[0]] = vtranslate($RelModArr[2]) . " (" . $RelModArr[1] . ")"; } } $viewer->assign("RELATED_MODULES", $Related_Modules); $tacModules = array(); $tac4you = is_numeric(getTabId("Tac4you")); if ($tac4you == true) { $sql = "SELECT tac4you_module FROM vtiger_tac4you_module WHERE presence = 1"; $result = $adb->query($sql); while ($row = $adb->fetchByAssoc($result)) { $tacModules[$row["tac4you_module"]] = $row["tac4you_module"]; } } $desc4youModules = array(); $desc4you = is_numeric(getTabId("Descriptions4you")); if ($desc4you == true) { $sql = "SELECT b.name FROM vtiger_links AS a\n INNER JOIN vtiger_tab AS b USING (tabid)\n WHERE linktype = 'DETAILVIEWWIDGET'\n AND linkurl = 'block://ModDescriptions4you:modules/Descriptions4you/ModDescriptions4you.php'"; $result = $adb->query($sql); while ($row = $adb->fetchByAssoc($result)) { $desc4youModules[$row["name"]] = $row["name"]; } } $Settings_Profiles_Record_Model = new Settings_Profiles_Record_Model(); foreach ($ModuleFields as $module => $Blocks) { $Optgroupts = array(); $current_mod_strings = $this->getModuleLanguageArray($module); $moduleModel = Vtiger_Module_Model::getInstance($module); $b = 0; if ($module == 'Calendar') { $b++; $Optgroupts[] = '"' . vtranslate('Calendar') . '","' . $b . '"'; $Convert_ModuleFields['Calendar|1'] .= ',"Record ID","CALENDAR_CRMID"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"] = "Record ID"; $EventModel = Vtiger_Module_Model::getInstance('Events'); } foreach ($Blocks as $block_label => $block_fields) { $b++; $Options = array(); if ($block_label != "TEMP_MODCOMMENTS_BLOCK") { $optgroup_value = vtranslate($block_label, $module); if ($optgroup_value == $block_label) { $optgroup_value = vtranslate($block_label, 'PDFMaker'); } } else { $optgroup_value = vtranslate("LBL_MODCOMMENTS_INFORMATION", 'PDFMaker'); } $Optgroupts[] = '"' . $optgroup_value . '","' . $b . '"'; if (count($block_fields) > 0) { $field_ids = implode(",", $block_fields); $sql1 = "SELECT * FROM vtiger_field WHERE fieldid IN (" . $field_ids . ")"; $result1 = $adb->query($sql1); while ($row1 = $adb->fetchByAssoc($result1)) { $fieldname = $row1['fieldname']; $fieldlabel = $row1['fieldlabel']; $fieldModel = Vtiger_Field_Model::getInstance($fieldname, $moduleModel); if (!$fieldModel || !$fieldModel->getPermissions('readonly')) { if ($module == 'Calendar') { $eventFieldModel = Vtiger_Field_Model::getInstance($fieldname, $EventModel); if (!$eventFieldModel || !$eventFieldModel->getPermissions('readonly')) { continue; } } else { continue; } } $option_key = strtoupper($module . "_" . $fieldname); if (isset($current_mod_strings[$fieldlabel]) and $current_mod_strings[$fieldlabel] != "") { $option_value = $current_mod_strings[$fieldlabel]; } elseif (isset($app_strings[$fieldlabel]) and $app_strings[$fieldlabel] != "") { $option_value = $app_strings[$fieldlabel]; } else { $option_value = $fieldlabel; } if ($module == 'Calendar') { if ($option_key == 'CALENDAR_ACTIVITYTYPE' || $option_key == 'CALENDAR_DUE_DATE') { $Convert_ModuleFields['Calendar|1'] .= ',"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')][$option_key] = $option_value; continue; } elseif (!isset($Existing_ModuleFields[$option_key])) { $Existing_ModuleFields[$option_key] = $optgroup_value; } else { $Convert_ModuleFields['Calendar|1'] .= ',"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')][$option_key] = $option_value; $Unset_Module_Fields[] = '"' . $option_value . '","' . $option_key . '"'; unset($SelectModuleFields['Calendar'][$Existing_ModuleFields[$option_key]][$option_key]); continue; } } $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } } //variable RECORD ID added if ($b == 1) { $option_value = "Record ID"; $option_key = strtoupper($module . "_CRMID"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; $option_value = vtranslate('Created Time') . ' (' . vtranslate('Due Date & Time') . ')'; $option_key = strtoupper($module . "_CREATEDTIME_DATETIME"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; $option_value = vtranslate('Modified Time') . ' (' . vtranslate('Due Date & Time') . ')'; $option_key = strtoupper($module . "_MODIFIEDTIME_DATETIME"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } //end if ($block_label == "LBL_TERMS_INFORMATION" && isset($tacModules[$module])) { $option_value = vtranslate("LBL_TAC4YOU", 'PDFMaker'); $option_key = strtoupper($module . "_TAC4YOU"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } if ($block_label == "LBL_DESCRIPTION_INFORMATION" && isset($desc4youModules[$module])) { $option_value = vtranslate("LBL_DESC4YOU", 'PDFMaker'); $option_key = strtoupper($module . "_DESC4YOU"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } //ModComments support if ($block_label == "TEMP_MODCOMMENTS_BLOCK" && in_array($module, $ModCommentsModules) == true) { $option_value = vtranslate("LBL_MODCOMMENTS", 'PDFMaker'); $option_key = strtoupper($module . "_MODCOMMENTS"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } $Convert_RelatedModuleFields[$module . "|" . $b] = implode(",", $Options); $OptionsRelMod = array(); if (($block_label == "LBL_DETAILS_BLOCK" || $block_label == "LBL_ITEM_DETAILS") && ($module == "Quotes" || $module == "Invoice" || $module == "SalesOrder" || $module == "PurchaseOrder" || $module == "Issuecards" || $module == "Receiptcards" || $module == "Creditnote" || $module == "StornoInvoice")) { foreach ($More_Fields as $variable => $variable_name) { $variable_key = strtoupper($variable); $Options[] = '"' . $variable_name . '","' . $variable_key . '"'; $SelectModuleFields[$module][$optgroup_value][$variable_key] = $variable_name; if ($variable_key != "VATBLOCK") { $OptionsRelMod[] = '"' . $variable_name . '","' . strtoupper($module) . '_' . $variable_key . '"'; } } } //this concatenation is because of need to have extra Details block in Inventory modules which are as related modules $Convert_RelatedModuleFields[$module . "|" . $b] .= implode(',', $OptionsRelMod); $Convert_ModuleFields[$module . "|" . $b] = implode(",", $Options); } if ($module == 'Calendar') { $Convert_ModuleFields['Calendar|1'] = str_replace(',"Record ID","CALENDAR_CRMID",', "", $Convert_ModuleFields['Calendar|1']); $Convert_ModuleFields['Calendar|1'] .= ',"Record ID","CALENDAR_CRMID"'; unset($SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"]); $SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"] = "Record ID"; } $Convert_ModuleBlocks[$module] = implode(",", $Optgroupts); } foreach ($Convert_ModuleFields as $cmf_key => $cmf_value) { if (substr($cmf_key, 0, 9) == 'Calendar|' && $cmf_key != 'Calendar|1') { foreach ($Unset_Module_Fields as $to_unset) { $cmf_value = str_replace($to_unset, '', $cmf_value); $cmf_value = str_replace(",,", ',', $cmf_value); $Convert_ModuleFields[$cmf_key] = trim($cmf_value, ','); } } } $viewer->assign("MODULE_BLOCKS", $Convert_ModuleBlocks); $viewer->assign("RELATED_MODULE_FIELDS", $Convert_RelatedModuleFields); $viewer->assign("MODULE_FIELDS", $Convert_ModuleFields); //Product block fields start // Product bloc templates $sql = "SELECT * FROM vtiger_pdfmaker_productbloc_tpl"; $result = $adb->query($sql); $Productbloc_tpl[""] = vtranslate("LBL_PLS_SELECT", 'PDFMaker'); while ($row = $adb->fetchByAssoc($result)) { $Productbloc_tpl[$row["body"]] = $row["name"]; } $viewer->assign("PRODUCT_BLOC_TPL", $Productbloc_tpl); $ProductBlockFields = $PDFMaker->GetProductBlockFields(); foreach ($ProductBlockFields as $viewer_key => $pbFields) { $viewer->assign($viewer_key, $pbFields); } //Product block fields end $viewer->assign("SELECT_MODULE_FIELD", $SelectModuleFields[$select_module]); $smf_filename = $SelectModuleFields[$select_module]; unset($smf_filename["Details"]); $viewer->assign("SELECT_MODULE_FIELD_FILENAME", $smf_filename); $version_type = ucfirst($PDFMaker->GetVersionType()); $viewer->assign("VERSION", $version_type . " " . PDFMaker_Version_Helper::$version); $category = getParentTab(); $viewer->assign("CATEGORY", $category); $viewer->view('Edit.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("EDIT") == false) { $PDFMaker->DieDuePermission(); } $viewer = $this->getViewer($request); $emode = ""; $template = array(); $tplid = $request->get('tplid'); $mode = $request->get('mode'); if (isset($tplid) && $tplid != "") { $adb = PearDatabase::getInstance(); $sql = "SELECT * FROM vtiger_pdfmaker_productbloc_tpl WHERE id=?"; $result = $adb->pquery($sql, array($tplid)); $row = $adb->fetchByAssoc($result); if ($mode != "duplicate") { $template["id"] = $row["id"]; } $template["name"] = $row["name"]; $template["body"] = $row["body"]; $emode = "edit"; } //if no ID is specified then it is create view $viewer->assign("EDIT_TEMPLATE", $template); //PROPERTIES tab $ProductBlockFields = $PDFMaker->GetProductBlockFields(); foreach ($ProductBlockFields as $smarty_key => $pbFields) { $viewer->assign($smarty_key, $pbFields); } //LABELS //global lang $cu_model = Users_Record_Model::getCurrentUserModel(); $this->cu_language = $cu_model->get('language'); $app_strings_big = Vtiger_Language_Handler::getModuleStringsFromFile($this->cu_language); $app_strings = $app_strings_big['languageStrings']; $global_lang_labels = array_flip($app_strings); $global_lang_labels = array_flip($global_lang_labels); asort($global_lang_labels); $viewer->assign("GLOBAL_LANG_LABELS", $global_lang_labels); //custom lang list($custom_labels, $languages) = $PDFMaker->GetCustomLabels(); $currLangId = ""; foreach ($languages as $langId => $langVal) { if ($langVal["prefix"] == $current_language) { $currLangId = $langId; break; } } $vcustom_labels = array(); if (count($custom_labels) > 0) { foreach ($custom_labels as $oLbl) { $currLangVal = $oLbl->GetLangValue($currLangId); if ($currLangVal == "") { $currLangVal = $oLbl->GetFirstNonEmptyValue(); } $vcustom_labels[$oLbl->GetKey()] = $currLangVal; } asort($vcustom_labels); } else { $vcustom_labels = $mod_strings["LBL_SELECT_MODULE_FIELD"]; } $viewer->assign("CUSTOM_LANG_LABELS", $vcustom_labels); //VIEW HELPERS if ($PDFMaker->GetVersionType() == "professional") { $type = "professional"; } else { $type = "basic"; } $viewer->assign("TYPE", $type); $viewer->assign("EMODE", $emode); $viewer->assign("MODE", $mode); $viewer->view('EditProductBlock.tpl', 'PDFMaker'); }
public function getList(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DETAIL") == false) $PDFMaker->DieDuePermission(); $viewer = $this->getViewer($request); $orderby = "templateid"; $dir = "asc"; if (isset($_REQUEST["dir"]) && $_REQUEST["dir"] == "desc") $dir = "desc"; if (isset($_REQUEST["orderby"])) { switch ($_REQUEST["orderby"]) { case "name": $orderby = "filename"; break; case "module": $orderby = "module"; break; case "description": $orderby = "description"; break; case "order": $orderby = "order"; break; default: $orderby = $_REQUEST["orderby"]; break; } } $version_type = $PDFMaker->GetVersionType(); $license_key = $PDFMaker->GetLicenseKey(); $viewer->assign("VERSION_TYPE", $version_type); $viewer->assign("VERSION", ucfirst($version_type) . " " . PDFMaker_Version_Helper::$version); if ($PDFMaker->CheckPermissions("EDIT")) { $viewer->assign("EDIT", "permitted"); } $notif = $PDFMaker->GetReleasesNotif(); $viewer->assign("RELEASE_NOTIF", $notif); $php_version = phpversion(); $notif = false; $max_in_vars = ini_get("max_input_vars"); if ($max_in_vars <= 1000 && $php_version >= "5.3.9") $notif = true; $test = ini_set("memory_limit", "256M"); $memory_limit = ini_get("memory_limit"); if (substr($memory_limit, 0, -1) <= 128) $notif = true; $max_exec_time = ini_get("max_execution_time"); if ($max_exec_time <= 60) $notif = true; if (extension_loaded('suhosin')) { $request_max_vars = ini_get("suhosin.request.max_vars"); $post_max_vars = ini_get("suhosin.post.max_vars"); if ($request_max_vars <= 1000) $notif = true; if ($post_max_vars <= 1000) $notif = true; } $viewer->assign("MOD", $mod_strings); $viewer->assign("APP", $app_strings); $viewer->assign("THEME", $theme); $viewer->assign("PARENTTAB", getParentTab()); $viewer->assign("IMAGE_PATH", $image_path); $return_data = $PDFMaker->GetListviewData($orderby, $dir); $viewer->assign("PDFTEMPLATES", $return_data); $category = getParentTab(); $viewer->assign("CATEGORY", $category); if (is_admin($current_user)) { $viewer->assign('IS_ADMIN', '1'); } $linkModels = $PDFMaker->getListViewLinks($linkParams); $viewer->assign('LISTVIEW_LINKS', $linkModels); $tpl = "ListPDFTemplates"; if ($request->get('ajax') == "true") $tpl .= "Contents"; $viewer->view($tpl.".tpl", 'PDFMaker'); }
function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $checkGenerate = new PDFMaker_checkGenerate_Model(); $checkGenerate->generate($request); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $current_user = Users_Record_Model::getCurrentUserModel(); $viewer = $this->getViewer($request); global $current_language; $step = $request->get('step'); if ($step == "") { $step = "1"; } $mode = $request->get('mode'); $record = $request->get('record'); if (isset($mode) && $mode == "Delete") { $sql1 = "SELECT module FROM vtiger_pdfmaker_relblocks WHERE relblockid = ?"; $rel_module = $adb->query_result($adb->pquery($sql1, array($record)), 0, "module"); $sql2 = "DELETE FROM vtiger_pdfmaker_relblocks WHERE relblockid = ?"; $result = $adb->pquery($sql2, array($record)); header("Location:index.php?module=PDFMaker&action=PDFMakerAjax&file=ListRelatedBlocks&parenttab=Tools&pdfmodule=" . $rel_module); exit; } if (isset($mode) && $mode == "add") { $sql = "SELECT * FROM vtiger_pdfmaker_relblocks WHERE relblockid = ?"; $result = $adb->pquery($sql, array($record)); $Blockdata = $adb->fetchByAssoc($result, 0); $body = $Blockdata["block"]; $body = str_replace("RELBLOCK_START", "RELBLOCK" . $record . "_START", $body); $body = str_replace("RELBLOCK_END", "RELBLOCK" . $record . "_END", $body); //echo $body; exit; echo "<div id='block' style='display:none;'>" . $body . "</div>"; echo "<script> \n\t\tvar oEditor = window.opener.CKEDITOR.instances.body; \n\t\t\n\t\tcontent = document.getElementById('block').innerHTML;\n\t\t\n\t\toEditor.insertHtml(content); \n\t\tself.close();\n\t\t</script>"; exit; } $viewer->assign("PARENTTAB", getParentTab()); $viewer->assign("DATEFORMAT", $current_user->get('date_format')); $viewer->assign("JS_DATEFORMAT", parse_calendardate(vtranslate('NTC_DATE_FORMAT'))); $RelatedBlock = new PDFMaker_RelatedBlock_Model(); $columns1 = ""; if ($record) { $sql = "SELECT * FROM vtiger_pdfmaker_relblocks WHERE relblockid = ?"; $result = $adb->pquery($sql, array($record)); $Blockdata = $adb->fetchByAssoc($result, 0); $rel_module = $Blockdata["module"]; $sec_module = $Blockdata["secmodule"]; $blockname = $Blockdata["name"]; $block = $Blockdata["block"]; $sql2 = "SELECT * FROM vtiger_pdfmaker_relblockdatefilter WHERE datefilterid = ?"; $result2 = $adb->pquery($sql2, array($record)); $num_rows2 = $adb->num_rows($result2); if ($num_rows2 > 0) { $datecolumnname = $adb->query_result($result2, 0, "datecolumnname"); $stdselectedfilter = $adb->query_result($result2, 0, "datefilter"); $startdate = $adb->query_result($result2, 0, "startdate"); $enddate = $adb->query_result($result2, 0, "enddate"); if ($startdate != "" && $startdate != "0000-00-00") { $viewer->assign("STARTDATE_STD", getValidDisplayDate($startdate)); } if ($enddate != "" && $startdate != "0000-00-00") { $viewer->assign("ENDDATE_STD", getValidDisplayDate($enddate)); } } $module_list = $RelatedBlock->getModuleList($sec_module); $options1 = $RelatedBlock->getStdCriteriaByModule($sec_module, $module_list, $current_user); if (count($options1) > 0) { foreach ($options1 as $value => $label) { if ($value == $datecolumnname) { $sel = "selected"; } else { $sel = ""; } $columns1 .= "<option value='" . $value . "' " . $sel . ">" . $label . "</option>"; } } $columns2 = ""; foreach ($module_list as $blockid => $optgroup) { $options2 = $RelatedBlock->getColumnsListbyBlock($sec_module, $blockid, $rel_module, $current_user); if (count($options2) > 0) { $columns2 .= "<optgroup label='" . $optgroup . "'>"; foreach ($options2 as $value => $label) { $columns2 .= "<option value='" . $value . "'>" . $label . "</option>"; } $columns2 .= "</optgroup>"; } } $selected_columns = $this->getSelectedColumnsList($rel_module, $sec_module, $record, $current_user); list($sortCols, $sortOrder) = $this->getSortColumns($record, $selected_columns); $step = 3; $mode = 'edit'; $RelatedBlock->setId($record); $reportModel = Reports_Record_Model::getCleanInstance(''); $reportModel->setPrimaryModule($rel_module); $RelatedBlock->setPrimaryModule($rel_module); if (!empty($sec_module)) { $RelatedBlock->setSecondaryModule($sec_module); $reportModel->setSecondaryModule($sec_module); } $viewer->assign('SELECTED_ADVANCED_FILTER_FIELDS', $RelatedBlock->transformToNewAdvancedFilter()); $viewer->assign('PRIMARY_MODULE', $primaryModule); $recordStructureInstance = Vtiger_RecordStructure_Model::getInstanceFromRecordModel($reportModel); $primaryModuleRecordStructure = $recordStructureInstance->getPrimaryModuleRecordStructure(); $secondaryModuleRecordStructures = $recordStructureInstance->getSecondaryModuleRecordStructure(); $viewer->assign('PRIMARY_MODULE_RECORD_STRUCTURE', $primaryModuleRecordStructure); $viewer->assign('SECONDARY_MODULE_RECORD_STRUCTURES', $secondaryModuleRecordStructures); $viewer->assign('ADVANCED_FILTER_OPTIONS', Vtiger_Field_Model::getAdvancedFilterOptions()); $viewer->assign('ADVANCED_FILTER_OPTIONS_BY_TYPE', Vtiger_Field_Model::getAdvancedFilterOpsByFieldType()); $dateFilters = Vtiger_Field_Model::getDateFilterTypes(); foreach ($dateFilters as $comparatorKey => $comparatorInfo) { $comparatorInfo['startdate'] = DateTimeField::convertToUserFormat($comparatorInfo['startdate']); $comparatorInfo['enddate'] = DateTimeField::convertToUserFormat($comparatorInfo['enddate']); $comparatorInfo['label'] = vtranslate($comparatorInfo['label'], $module); $dateFilters[$comparatorKey] = $comparatorInfo; } $viewer->assign('DATE_FILTERS', $dateFilters); $viewer->assign('PRIMARY_MODULE_FIELDS', $reportModel->getPrimaryModuleFields()); $viewer->assign('SECONDARY_MODULE_FIELDS', $reportModel->getSecondaryModuleFields()); $viewer->assign('SELECTED_SORT_FIELDS', $RelatedBlock->getSelectedSortFields()); } else { $primaryModule = $request->get('primarymodule'); $secondaryModules = $request->get('secondarymodule'); $rel_module = $_REQUEST["pdfmodule"]; $block = ""; $record = ""; $blockname = ""; $columns = ""; $columns2 = ""; $selected_columns = ""; $sortCols = ""; $sortOrder = ""; $stdselectedfilter = ""; $mode = 'create'; } $viewer->assign("MODE", $mode); $viewer->assign("RECORD", $record); $viewer->assign("BLOCKNAME", $blockname); $Related_Modules = PDFMaker_RelatedBlock_Model::getRelatedModulesList($rel_module); if ($record == "") { $sec_module = $Related_Modules[0]; } $viewer->assign("SEC_MODULE", $sec_module); $viewer->assign("RELATED_MODULES", $Related_Modules); $version = PDFMaker_Version_Helper::$version; $viewer->assign("VERSION", $version); $viewer->assign("REL_MODULE", $rel_module); $viewer->assign("RELATEDBLOCK", $block); $viewer->assign("STEP", $step); $viewer->view('EditRelatedBlock.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { $moduleName = $request->getModule(); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $for_module = $request->get('return_module'); $recordIds = $this->getRecordsListFromRequest($request); $adb = PearDatabase::getInstance(); PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); if ($PDFMaker->CheckPermissions("DETAIL") == false) { $close_img = vimage_path('close.gif'); $output = ' <table border=0 cellspacing=0 cellpadding=5 width=100% class=layerHeadingULine> <tr> <td width="90%" align="left" class="genHeaderSmall" id="PDFListViewDivHandle" style="cursor:move;">' . vtranslate("LBL_PDF_ACTIONS", "PDFMaker") . ' </td> <td width="10%" align="right"> <a href="javascript:fninvsh(\'PDFListViewDiv\');"><img title="' . vtranslate("LBL_CLOSE") . '" alt="' . vtranslate("LBL_CLOSE") . '" src="' . $close_img . '" border="0" align="absmiddle" /></a> </td> </tr> </table> <table border=0 cellspacing=0 cellpadding=5 width=100% align=center> <tr><td class="small"> <table border=0 cellspacing=0 cellpadding=5 width=100% align=center bgcolor=white> <tr> <td class="dvtCellInfo" style="width:100%;border-top:1px solid #DEDEDE;text-align:center;"> <strong>' . vtranslate("LBL_PERMISSION_DENIED") . '</strong> </td> </tr> <tr> <td class="dvtCellInfo" style="width:100%;" align="center"> <input type="button" class="crmbutton small cancel" value="' . vtranslate("LBL_CANCEL") . '" onclick="fninvsh(\'PDFListViewDiv\');" /> </td> </tr> </table> </td></tr> </table> '; die($output); } $_REQUEST['idslist'] = implode(";", $recordIds); $request->set('idlist', $_REQUEST['idslist']); //$language = $_SESSION['authenticated_user_language']; $current_language = Vtiger_Language_Handler::getLanguage(); $templates = $PDFMaker->GetAvailableTemplates($for_module, true); $options = ""; foreach ($templates as $templateid => $valArr) { if ($valArr["is_default"] == "2" || $valArr["is_default"] == "3") { $selected = ' selected="selected" '; } else { $selected = ""; } $options .= '<option value="' . $templateid . '"' . $selected . '>' . $valArr['templatename'] . '</option>'; } $template_output = ""; $language_output = ""; $generate_pdf = ""; if ($options != "") { $template_output = ' <tr> <td class="dvtCellInfo" style="width:100%;border-top:1px solid #DEDEDE;"> <select name="use_common_template" id="use_common_template" class="detailedViewTextBox" multiple style="width:90%;" size="5"> ' . $options . ' </select> </td> </tr> '; $templates_select = '<select name="use_common_template" id="use_common_template" style="display: none;" id="fieldList" class="select2 row-fluid" multiple="true" size="5" data-validation-engine="validate[required]"> ' . $options . ' </select>'; $temp_res = $adb->pquery("SELECT label, prefix FROM vtiger_language WHERE active=?", array("1")); while ($temp_row = $adb->fetchByAssoc($temp_res)) { $template_languages[$temp_row["prefix"]] = $temp_row["label"]; } //LANGUAGES BLOCK if (count($template_languages) > 1) { $options = ""; foreach ($template_languages as $prefix => $label) { if ($current_language != $prefix) { $options .= '<option value="' . $prefix . '">' . $label . '</option>'; } else { $options .= '<option value="' . $prefix . '" selected="selected">' . $label . '</option>'; } } $language_output = ' <tr> <td class="dvtCellInfo" style="width:100%;"> <select name="template_language" id="template_language" class="detailedViewTextBox" style="width:90%;" size="1"> ' . $options . ' </select> </td> </tr>'; $languages_select = '<select name="template_language" id="template_language" class="select2 row-fluid" style="display: none;"> ' . $options . ' </select>'; } else { foreach ($template_languages as $prefix => $label) { $languages_select .= '<input type="hidden" name="template_language" id="template_language" value="' . $prefix . '"/>'; } } } else { $template_output = '<tr> <td class="dvtCellInfo" style="width:100%;border-top:1px solid #DEDEDE;"> ' . vtranslate("CRM_TEMPLATES_DONT_EXIST", "PDFMaker"); // if(isPermitted("PDFMaker","EditView") == 'yes') if ($PDFMaker->CheckPermissions("EDIT")) { $template_output .= '<br />' . vtranslate("CRM_TEMPLATES_ADMIN", "PDFMaker") . ' <a href="index.php?module=PDFMaker&action=EditPDFTemplate&return_module=' . $request->get("return_module") . '&parenttab=Tools" class="webMnu">' . vtranslate("TEMPLATE_CREATE_HERE", "PDFMaker") . '</a>'; } $template_output .= '</td></tr>'; } $viewer = $this->getViewer($request); //$viewer->assign('MODULE', $relmodule); //$viewer->assign('ID', $record); $viewer->assign('templates_select', $templates_select); $viewer->assign('languages_select', $languages_select); $viewer->assign('idslist', $_REQUEST['idslist']); $viewer->assign('relmodule', $request->get('return_module')); $viewer->view("ListViewSelect.tpl", 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $viewer = $this->getViewer($request); if ($request->has('templateid') && !$request->isEmpty('templateid')) { $templateid = $request->get('templateid'); $pdftemplateResult = $PDFMaker->GetEditViewData($templateid); $select_module = $pdftemplateResult["module"]; $select_format = $pdftemplateResult["format"]; $select_orientation = $pdftemplateResult["orientation"]; $nameOfFile = $pdftemplateResult["file_name"]; $is_portal = $pdftemplateResult["is_portal"]; $is_listview = $pdftemplateResult["is_listview"]; $is_active = $pdftemplateResult["is_active"]; $is_default = $pdftemplateResult["is_default"]; $order = $pdftemplateResult["order"]; $owner = $pdftemplateResult["owner"]; $sharingtype = $pdftemplateResult["sharingtype"]; $sharingMemberArray = $PDFMaker->GetSharingMemberArray($templateid); $disp_header = $pdftemplateResult["disp_header"]; $disp_footer = $pdftemplateResult["disp_footer"]; if (!$pdftemplateResult["permissions"]["edit"]) { $PDFMaker->DieDuePermission(); } } else { $templateid = ""; if ($request->has("return_module") && !$request->isEmpty("return_module")) { $select_module = $request->get("return_module"); } else { $select_module = ""; } $select_format = "A4"; $select_orientation = "portrait"; //$select_encoding = "utf-8"; $nameOfFile = ""; $is_portal = "0"; $is_listview = "0"; $is_active = "1"; $is_default = "0"; $order = "1"; $owner = $cu_model->id; $sharingtype = "public"; $sharingMemberArray = array(); $disp_header = "3"; $disp_footer = "7"; $PDFMaker->CheckTemplatePermissions($select_module, $templateid); } if ($PDFMaker->GetVersionType() == "professional") { $type = "professional"; } else { $type = "basic"; } $viewer->assign("TYPE", $type); if ($request->has("isDuplicate") && $request->get("isDuplicate") == "true") { $viewer->assign("FILENAME", ""); $viewer->assign("DUPLICATE_FILENAME", $pdftemplateResult["filename"]); } else { $viewer->assign("FILENAME", $pdftemplateResult["filename"]); } $viewer->assign("DESCRIPTION", $pdftemplateResult["description"]); if (!$request->has("isDuplicate") or $request->has("isDuplicate") && $request->get("isDuplicate") != "true") { $viewer->assign("SAVETEMPLATEID", $templateid); } if ($templateid != "") { $viewer->assign("EMODE", "edit"); } $viewer->assign("TEMPLATEID", $templateid); $viewer->assign("MODULENAME", vtranslate($select_module, $select_module)); $viewer->assign("SELECTMODULE", $select_module); $viewer->assign("BODY", $pdftemplateResult["body"]); $cu_model = Users_Record_Model::getCurrentUserModel(); $this->cu_language = $cu_model->get('language'); $viewer->assign("THEME", $theme); $viewer->assign("IMAGE_PATH", $image_path); $app_strings_big = Vtiger_Language_Handler::getModuleStringsFromFile($this->cu_language); $app_strings = $app_strings_big['languageStrings']; $viewer->assign("APP", $app_strings); $viewer->assign("PARENTTAB", getParentTab()); $modArr = $PDFMaker->GetAllModules(); $Modulenames = $modArr[0]; $ModuleIDS = $modArr[1]; $viewer->assign("MODULENAMES", $Modulenames); // ****************************************** Company and User information: ********************************** $CUI_BLOCKS["Account"] = vtranslate("LBL_COMPANY_INFO", 'PDFMaker'); $CUI_BLOCKS["Assigned"] = vtranslate("LBL_USER_INFO", 'PDFMaker'); $CUI_BLOCKS["Logged"] = vtranslate("LBL_LOGGED_USER_INFO", 'PDFMaker'); $viewer->assign("CUI_BLOCKS", $CUI_BLOCKS); $adb = PearDatabase::getInstance(); $sql = "SELECT * FROM vtiger_organizationdetails"; $result = $adb->pquery($sql, array()); $organization_logoname = decode_html($adb->query_result($result, 0, 'logoname')); $organization_header = decode_html($adb->query_result($result, 0, 'headername')); $organization_stamp_signature = $adb->query_result($result, 0, 'stamp_signature'); global $site_URL; $path = $site_URL . "/test/logo/"; if (isset($organization_logoname)) { $organization_logo_img = "<img src=\"" . $path . $organization_logoname . "\">"; $viewer->assign("COMPANYLOGO", $organization_logo_img); } if (isset($organization_stamp_signature)) { $organization_stamp_signature_img = "<img src=\"" . $path . $organization_stamp_signature . "\">"; $viewer->assign("COMPANY_STAMP_SIGNATURE", $organization_stamp_signature_img); } if (isset($organization_header)) { $organization_header_img = "<img src=\"" . $path . $organization_header . "\">"; $viewer->assign("COMPANY_HEADER_SIGNATURE", $organization_header_img); } $Acc_Info = array('' => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "COMPANY_NAME" => vtranslate("LBL_COMPANY_NAME", 'PDFMaker'), "COMPANY_LOGO" => vtranslate("LBL_COMPANY_LOGO", 'PDFMaker'), "COMPANY_ADDRESS" => vtranslate("LBL_COMPANY_ADDRESS", 'PDFMaker'), "COMPANY_CITY" => vtranslate("LBL_COMPANY_CITY", 'PDFMaker'), "COMPANY_STATE" => vtranslate("LBL_COMPANY_STATE", 'PDFMaker'), "COMPANY_ZIP" => vtranslate("LBL_COMPANY_ZIP", 'PDFMaker'), "COMPANY_COUNTRY" => vtranslate("LBL_COMPANY_COUNTRY", 'PDFMaker'), "COMPANY_PHONE" => vtranslate("LBL_COMPANY_PHONE", "PDFMaker"), "COMPANY_FAX" => vtranslate("LBL_COMPANY_FAX", 'PDFMaker'), "COMPANY_WEBSITE" => vtranslate("LBL_COMPANY_WEBSITE", 'PDFMaker')); $viewer->assign("ACCOUNTINFORMATIONS", $Acc_Info); if (getTabId('MultiCompany4you') && vtlib_isModuleActive('MultiCompany4you')) { $MultiAcc_info = array('' => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "MULTICOMPANY_COMPANYNAME" => vtranslate("LBL_COMPANY_NAME", 'MultiCompany4you'), "MULTICOMPANY_STREET" => vtranslate("Street", 'MultiCompany4you'), "MULTICOMPANY_CITY" => vtranslate("City", 'MultiCompany4you'), "MULTICOMPANY_CODE" => vtranslate("Code", 'MultiCompany4you'), "MULTICOMPANY_STATE" => vtranslate("State", 'MultiCompany4you'), "MULTICOMPANY_COUNTRY" => vtranslate("Country", 'MultiCompany4you'), "MULTICOMPANY_PHONE" => vtranslate("phone", 'MultiCompany4you'), "MULTICOMPANY_FAX" => vtranslate("Fax", 'MultiCompany4you'), "MULTICOMPANY_EMAIL" => vtranslate("email", 'MultiCompany4you'), "MULTICOMPANY_WEBSITE" => vtranslate("Website", 'MultiCompany4you'), "MULTICOMPANY_LOGO" => vtranslate("Logo", 'MultiCompany4you'), "MULTICOMPANY_STAMP" => vtranslate("Stamp", 'MultiCompany4you'), "MULTICOMPANY_BANKNAME" => vtranslate("BankName", 'MultiCompany4you'), "MULTICOMPANY_BANKACCOUNTNO" => vtranslate("BankAccountNo", 'MultiCompany4you'), "MULTICOMPANY_IBAN" => vtranslate("IBAN", 'MultiCompany4you'), "MULTICOMPANY_SWIFT" => vtranslate("SWIFT", 'MultiCompany4you'), "MULTICOMPANY_REGISTRATIONNO" => vtranslate("RegistrationNo", 'MultiCompany4you'), "MULTICOMPANY_VATNO" => vtranslate("VATNo", 'MultiCompany4you'), "MULTICOMPANY_TAXID" => vtranslate("TaxId", 'MultiCompany4you'), "MULTICOMPANY_ADDITIONALINFORMATIONS" => vtranslate("AdditionalInformations", 'MultiCompany4you')); $viewer->assign("MULTICOMPANYINFORMATIONS", $MultiAcc_info); $viewer->assign("LBL_MULTICOMPANY", vtranslate('MultiCompany', 'MultiCompany4you')); } $sql_user_block = "SELECT blockid, blocklabel FROM vtiger_blocks WHERE tabid = ? ORDER BY sequence ASC"; $res_user_block = $adb->pquery($sql_user_block, array('29')); $user_block_info_arr = array(); while ($row_user_block = $adb->fetch_array($res_user_block)) { $sql_user_field = "SELECT fieldid, uitype FROM vtiger_field WHERE block = ? and (displaytype != ? OR uitype = ?) ORDER BY sequence ASC"; $res_user_field = $adb->pquery($sql_user_field, array($row_user_block['blockid'], '3', '55')); $num_user_field = $adb->num_rows($res_user_field); if ($num_user_field > 0) { $user_field_id_array = array(); while ($row_user_field = $adb->fetch_array($res_user_field)) { $user_field_id_array[] = $row_user_field['fieldid']; } $user_block_info_arr[$row_user_block['blocklabel']] = $user_field_id_array; } } $user_mod_strings = $this->getModuleLanguageArray("Users"); $b = 0; foreach ($user_block_info_arr as $block_label => $block_fields) { $b++; if (isset($user_mod_strings[$block_label]) and $user_mod_strings[$block_label] != "") { $optgroup_value = $user_mod_strings[$block_label]; } else { $optgroup_value = vtranslate($block_label, 'PDFMaker'); } if (count($block_fields) > 0) { $sql1 = "SELECT * FROM vtiger_field WHERE fieldid IN (" . generateQuestionMarks($block_fields) . ")"; $result1 = $adb->pquery($sql1, $block_fields); while ($row1 = $adb->fetchByAssoc($result1)) { $fieldname = $row1['fieldname']; $fieldlabel = $row1['fieldlabel']; $option_key = strtoupper("Users" . "_" . $fieldname); if (isset($current_mod_strings[$fieldlabel]) and $current_mod_strings[$fieldlabel] != "") { $option_value = $current_mod_strings[$fieldlabel]; } elseif (isset($app_strings[$fieldlabel]) and $app_strings[$fieldlabel] != "") { $option_value = $app_strings[$fieldlabel]; } else { $option_value = $fieldlabel; } $User_Info[$optgroup_value][$option_key] = $option_value; $Logged_User_Info[$optgroup_value]["R_" . $option_key] = $option_value; } } //variable RECORD ID added if ($b == 1) { $option_value = "Record ID"; $option_key = strtoupper("USERS_CRMID"); $User_Info[$optgroup_value][$option_key] = $option_value; $Logged_User_Info[$optgroup_value]["R_" . $option_key] = $option_value; } //end } // ****************************************** END: Company and User information ********************************** $viewer->assign("USERINFORMATIONS", $User_Info); $viewer->assign("LOGGEDUSERINFORMATION", $Logged_User_Info); $Invterandcon = array("" => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "TERMS_AND_CONDITIONS" => vtranslate("LBL_TERMS_AND_CONDITIONS", 'PDFMaker')); $viewer->assign("INVENTORYTERMSANDCONDITIONS", $Invterandcon); //custom functions $customFunctions = $this->getCustomFunctionsList(); $viewer->assign("CUSTOM_FUNCTIONS", $customFunctions); //labels $global_lang_labels = @array_flip($app_strings); $global_lang_labels = @array_flip($global_lang_labels); asort($global_lang_labels); $viewer->assign("GLOBAL_LANG_LABELS", $global_lang_labels); $module_lang_labels = array(); if ($select_module != "") { $mod_lang = $this->getModuleLanguageArray($select_module); $module_lang_labels = @array_flip($mod_lang); $module_lang_labels = @array_flip($module_lang_labels); asort($module_lang_labels); } else { $module_lang_labels[""] = vtranslate("LBL_SELECT_MODULE_FIELD", 'PDFMaker'); } $viewer->assign("MODULE_LANG_LABELS", $module_lang_labels); list($custom_labels, $languages) = $PDFMaker->GetCustomLabels(); $currLangId = ""; foreach ($languages as $langId => $langVal) { if ($langVal["prefix"] == $current_language) { $currLangId = $langId; break; } } $vcustom_labels = array(); if (count($custom_labels) > 0) { foreach ($custom_labels as $oLbl) { $currLangVal = $oLbl->GetLangValue($currLangId); if ($currLangVal == "") { $currLangVal = $oLbl->GetFirstNonEmptyValue(); } $vcustom_labels[$oLbl->GetKey()] = $currLangVal; } asort($vcustom_labels); } else { $vcustom_labels = vtranslate("LBL_SELECT_MODULE_FIELD", 'PDFMaker'); } $viewer->assign("CUSTOM_LANG_LABELS", $vcustom_labels); $Header_Footer_Strings = array("" => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "PAGE" => $app_strings["Page"], "PAGES" => $app_strings["Pages"]); $viewer->assign("HEADER_FOOTER_STRINGS", $Header_Footer_Strings); //PDF FORMAT SETTINGS $Formats = array("A3" => "A3", "A4" => "A4", "A5" => "A5", "A6" => "A6", "Letter" => "Letter", "Legal" => "Legal", "Custom" => "Custom"); // ITS4YOU VlZa $viewer->assign("FORMATS", $Formats); if (strpos($select_format, ";") > 0) { $tmpArr = explode(";", $select_format); $select_format = "Custom"; $custom_format["width"] = $tmpArr[0]; $custom_format["height"] = $tmpArr[1]; $viewer->assign("CUSTOM_FORMAT", $custom_format); } $viewer->assign("SELECT_FORMAT", $select_format); //PDF ORIENTATION SETTINGS $Orientations = array("portrait" => vtranslate("portrait", 'PDFMaker'), "landscape" => vtranslate("landscape", 'PDFMaker')); $viewer->assign("ORIENTATIONS", $Orientations); $viewer->assign("SELECT_ORIENTATION", $select_orientation); //PDF STATUS SETTINGS $Status = array("1" => $app_strings["Active"], "0" => vtranslate("Inactive", 'PDFMaker')); $viewer->assign("STATUS", $Status); $viewer->assign("IS_ACTIVE", $is_active); if ($is_active == "0") { $viewer->assign("IS_DEFAULT_DV_CHECKED", 'disabled="disabled"'); $viewer->assign("IS_DEFAULT_LV_CHECKED", 'disabled="disabled"'); } elseif ($is_default > 0) { $is_default_bin = str_pad(base_convert($is_default, 10, 2), 2, "0", STR_PAD_LEFT); $is_default_lv = substr($is_default_bin, 0, 1); $is_default_dv = substr($is_default_bin, 1, 1); if ($is_default_lv == "1") { $viewer->assign("IS_DEFAULT_LV_CHECKED", 'checked="checked"'); } if ($is_default_dv == "1") { $viewer->assign("IS_DEFAULT_DV_CHECKED", 'checked="checked"'); } } $viewer->assign("ORDER", $order); if ($is_portal == "1") { $viewer->assign("IS_PORTAL_CHECKED", 'checked="checked"'); } if ($is_listview == "1") { $viewer->assign("IS_LISTVIEW_CHECKED", 'checked="checked"'); } //PDF MARGIN SETTINGS if ($request->has("templateid") && !$request->isEmpty("templateid")) { $Margins = array("top" => $pdftemplateResult["margin_top"], "bottom" => $pdftemplateResult["margin_bottom"], "left" => $pdftemplateResult["margin_left"], "right" => $pdftemplateResult["margin_right"]); $Decimals = array("point" => $pdftemplateResult["decimal_point"], "decimals" => $pdftemplateResult["decimals"], "thousands" => $pdftemplateResult["thousands_separator"] != "sp" ? $pdftemplateResult["thousands_separator"] : " "); } else { $Margins = array("top" => "2", "bottom" => "2", "left" => "2", "right" => "2"); $Decimals = array("point" => ",", "decimals" => "2", "thousands" => " "); } $viewer->assign("MARGINS", $Margins); $viewer->assign("DECIMALS", $Decimals); //PDF HEADER / FOOTER $header = ""; $footer = ""; if ($request->has("templateid") && !$request->isEmpty("templateid")) { $header = $pdftemplateResult["header"]; $footer = $pdftemplateResult["footer"]; } $viewer->assign("HEADER", $header); $viewer->assign("FOOTER", $footer); $hfVariables = array("##PAGE##" => vtranslate("LBL_CURRENT_PAGE", 'PDFMaker'), "##PAGES##" => vtranslate("LBL_ALL_PAGES", 'PDFMaker'), "##PAGE##/##PAGES##" => vtranslate("LBL_PAGE_PAGES", 'PDFMaker')); $viewer->assign("HEAD_FOOT_VARS", $hfVariables); $dateVariables = array("##DD.MM.YYYY##" => vtranslate("LBL_DATE_DD.MM.YYYY", 'PDFMaker'), "##DD-MM-YYYY##" => vtranslate("LBL_DATE_DD-MM-YYYY", 'PDFMaker'), "##MM-DD-YYYY##" => vtranslate("LBL_DATE_MM-DD-YYYY", 'PDFMaker'), "##YYYY-MM-DD##" => vtranslate("LBL_DATE_YYYY-MM-DD", 'PDFMaker')); $viewer->assign("DATE_VARS", $dateVariables); //PDF FILENAME FIELDS $filenameFields = array("#TEMPLATE_NAME#" => vtranslate("LBL_PDF_NAME", 'PDFMaker'), "#DD-MM-YYYY#" => vtranslate("LBL_CURDATE_DD-MM-YYYY", 'PDFMaker'), "#MM-DD-YYYY#" => vtranslate("LBL_CURDATE_MM-DD-YYYY", 'PDFMaker'), "#YYYY-MM-DD#" => vtranslate("LBL_CURDATE_YYYY-MM-DD", 'PDFMaker')); $viewer->assign("FILENAME_FIELDS", $filenameFields); $viewer->assign("NAME_OF_FILE", $nameOfFile); //Sharing $template_owners = get_user_array(false); $viewer->assign("TEMPLATE_OWNERS", $template_owners); $viewer->assign("TEMPLATE_OWNER", $owner); $sharing_types = array("public" => vtranslate("PUBLIC_FILTER", 'PDFMaker'), "private" => vtranslate("PRIVATE_FILTER", 'PDFMaker'), "share" => vtranslate("SHARE_FILTER", 'PDFMaker')); $viewer->assign("SHARINGTYPES", $sharing_types); $viewer->assign("SHARINGTYPE", $sharingtype); $cmod = $this->getModuleLanguageArray("Settings"); //$cmod = return_specified_module_language($current_language, "Settings"); $viewer->assign("CMOD", $cmod); //Constructing the Role Array $roleDetails = getAllRoleDetails(); $i = 0; $roleIdStr = ""; $roleNameStr = ""; $userIdStr = ""; $userNameStr = ""; $grpIdStr = ""; $grpNameStr = ""; foreach ($roleDetails as $roleId => $roleInfo) { if ($i != 0) { if ($i != 1) { $roleIdStr .= ", "; $roleNameStr .= ", "; } $roleName = $roleInfo[0]; $roleIdStr .= "'" . $roleId . "'"; $roleNameStr .= "'" . addslashes(decode_html($roleName)) . "'"; } $i++; } //Constructing the User Array $l = 0; $userDetails = getAllUserName(); foreach ($userDetails as $userId => $userInfo) { if ($l != 0) { $userIdStr .= ", "; $userNameStr .= ", "; } $userIdStr .= "'" . $userId . "'"; $userNameStr .= "'" . $userInfo . "'"; $l++; } //Constructing the Group Array $parentGroupArray = array(); $m = 0; $grpDetails = getAllGroupName(); foreach ($grpDetails as $grpId => $grpName) { if (!in_array($grpId, $parentGroupArray)) { if ($m != 0) { $grpIdStr .= ", "; $grpNameStr .= ", "; } $grpIdStr .= "'" . $grpId . "'"; $grpNameStr .= "'" . addslashes(decode_html($grpName)) . "'"; $m++; } } $viewer->assign("ROLEIDSTR", $roleIdStr); $viewer->assign("ROLENAMESTR", $roleNameStr); $viewer->assign("USERIDSTR", $userIdStr); $viewer->assign("USERNAMESTR", $userNameStr); $viewer->assign("GROUPIDSTR", $grpIdStr); $viewer->assign("GROUPNAMESTR", $grpNameStr); if (count($sharingMemberArray) > 0) { $outputMemberArr = array(); foreach ($sharingMemberArray as $setype => $shareIdArr) { foreach ($shareIdArr as $shareId) { switch ($setype) { case "groups": $groupInfo = getGroupName($shareId); $memberName = $groupInfo[0]; $memberDisplay = "Group::"; break; case "roles": $memberName = getRoleName($shareId); $memberDisplay = "Roles::"; break; case "rs": $memberName = getRoleName($shareId); $memberDisplay = "RoleAndSubordinates::"; break; case "users": $memberName = getUserName($shareId); $memberDisplay = "User::"; break; } $outputMemberArr[] = $setype . "::" . $shareId; $outputMemberArr[] = $memberDisplay . $memberName; } } $viewer->assign("MEMBER", array_chunk($outputMemberArr, 2)); } //Ignored picklist values $pvsql = "SELECT value FROM vtiger_pdfmaker_ignorepicklistvalues"; $pvresult = $adb->pquery($pvsql, array()); $pvvalues = ""; while ($pvrow = $adb->fetchByAssoc($pvresult)) { $pvvalues .= $pvrow["value"] . ", "; } $viewer->assign("IGNORE_PICKLIST_VALUES", rtrim($pvvalues, ", ")); $More_Fields = array("CURRENCYNAME" => vtranslate("LBL_CURRENCY_NAME", 'PDFMaker'), "CURRENCYSYMBOL" => vtranslate("LBL_CURRENCY_SYMBOL", 'PDFMaker'), "CURRENCYCODE" => vtranslate("LBL_CURRENCY_CODE", 'PDFMaker'), "TOTALWITHOUTVAT" => vtranslate("LBL_VARIABLE_SUMWITHOUTVAT", 'PDFMaker'), "TOTALDISCOUNT" => vtranslate("LBL_VARIABLE_TOTALDISCOUNT", 'PDFMaker'), "TOTALDISCOUNTPERCENT" => vtranslate("LBL_VARIABLE_TOTALDISCOUNT_PERCENT", 'PDFMaker'), "TOTALAFTERDISCOUNT" => vtranslate("LBL_VARIABLE_TOTALAFTERDISCOUNT", 'PDFMaker'), "VAT" => vtranslate("LBL_VARIABLE_VAT", 'PDFMaker'), "VATPERCENT" => vtranslate("LBL_VARIABLE_VAT_PERCENT", 'PDFMaker'), "VATBLOCK" => vtranslate("LBL_VARIABLE_VAT_BLOCK", 'PDFMaker'), "TOTALWITHVAT" => vtranslate("LBL_VARIABLE_SUMWITHVAT", 'PDFMaker'), "SHTAXTOTAL" => vtranslate("LBL_SHTAXTOTAL", 'PDFMaker'), "SHTAXAMOUNT" => vtranslate("LBL_SHTAXAMOUNT", 'PDFMaker'), "ADJUSTMENT" => vtranslate("LBL_ADJUSTMENT", 'PDFMaker'), "TOTAL" => vtranslate("LBL_VARIABLE_TOTALSUM", 'PDFMaker')); //formatable VATBLOCK content $vatblock_table = '<table border="1" cellpadding="3" cellspacing="0" style="border-collapse:collapse;"> <tr> <td>' . $app_strings["Name"] . '</td> <td>' . vtranslate("LBL_VATBLOCK_VAT_PERCENT", 'PDFMaker') . '</td> <td>' . vtranslate("LBL_VATBLOCK_SUM", 'PDFMaker') . '</td> <td>' . vtranslate("LBL_VATBLOCK_VAT_VALUE", 'PDFMaker') . '</td> </tr> <tr> <td colspan="4">#VATBLOCK_START#</td> </tr> <tr> <td>$VATBLOCK_LABEL$</td> <td>$VATBLOCK_VALUE$</td> <td>$VATBLOCK_NETTO$</td> <td>$VATBLOCK_VAT$</td> </tr> <tr> <td colspan="4">#VATBLOCK_END#</td> </tr> </table>'; $vatblock_table = str_replace(array("\r\n", "\r", "\n", "\t"), "", $vatblock_table); $vatblock_table = ereg_replace(" {2,}", ' ', $vatblock_table); $viewer->assign("VATBLOCK_TABLE", $vatblock_table); $ModCommentsModules = array(); /* $ModComments = is_numeric(getTabId("ModComments")); if ($ModComments == true) { $sql = "SELECT relmodule FROM vtiger_fieldmodulerel WHERE module='ModComments' AND relmodule != 'ModComments'"; $result = $adb->pquery($sql,array()); while ($row = $adb->fetchByAssoc($result)) $ModCommentsModules[$row["relmodule"]] = $row["relmodule"]; } */ foreach ($ModuleIDS as $module => $module_id) { $this->getModuleFields($module, $module_id); } //Permissions are taken into consideration when dealing with realted modules $AllowedRelMods = array(); if (count($this->All_Related_Modules) > 0) { foreach ($this->All_Related_Modules as $Mod => $RelMods) { foreach ($RelMods as $RelModKey => $RelMod) { $RelModName = $RelMod[2]; if (isPermitted($RelModName, '') == "yes") { $AllowedRelMods[$Mod][$RelModKey] = $RelMod; } } } } $this->All_Related_Modules = $AllowedRelMods; // Fix of emtpy selectbox in case of selected module does not have any related modules foreach ($Modulenames as $key => $value) { if (!isset($this->All_Related_Modules[$key])) { $this->All_Related_Modules[$key] = array(); } } $viewer->assign("ALL_RELATED_MODULES", $this->All_Related_Modules); if ($select_module != "" && count($this->All_Related_Modules[$select_module]) > 0) { foreach ($this->All_Related_Modules[$select_module] as $RelModArr) { $Related_Modules[$RelModArr[2] . "|" . $RelModArr[0]] = vtranslate($RelModArr[2]) . " (" . $RelModArr[1] . ")"; } } $viewer->assign("RELATED_MODULES", $Related_Modules); $tacModules = array(); $tac4you = is_numeric(getTabId("Tac4you")); if ($tac4you == true) { $sql = "SELECT tac4you_module FROM vtiger_tac4you_module WHERE presence = ?"; $result = $adb->pquery($sql, array('1')); while ($row = $adb->fetchByAssoc($result)) { $tacModules[$row["tac4you_module"]] = $row["tac4you_module"]; } } $desc4youModules = array(); $desc4you = is_numeric(getTabId("Descriptions4you")); if ($desc4you == true) { $sql = "SELECT b.name FROM vtiger_links AS a INNER JOIN vtiger_tab AS b USING (tabid) WHERE linktype = ? AND linkurl = ?"; $result = $adb->pquery($sql, array('DETAILVIEWWIDGET', 'block://ModDescriptions4you:modules/Descriptions4you/ModDescriptions4you.php')); while ($row = $adb->fetchByAssoc($result)) { $desc4youModules[$row["name"]] = $row["name"]; } } $Settings_Profiles_Record_Model = new Settings_Profiles_Record_Model(); foreach ($this->ModuleFields as $module => $Blocks) { $Optgroupts = array(); $current_mod_strings = $this->getModuleLanguageArray($module); $moduleModel = Vtiger_Module_Model::getInstance($module); $b = 0; if ($module == 'Calendar') { $b++; $Optgroupts[] = '"' . vtranslate('Calendar') . '","' . $b . '"'; $Convert_ModuleFields['Calendar|1'] .= ',"Record ID","CALENDAR_CRMID"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"] = "Record ID"; $EventModel = Vtiger_Module_Model::getInstance('Events'); } foreach ($Blocks as $block_label => $block_fields) { $b++; $Options = array(); if ($block_label != "TEMP_MODCOMMENTS_BLOCK") { $optgroup_value = vtranslate($block_label, $module); if ($optgroup_value == $block_label) { $optgroup_value = vtranslate($block_label, 'PDFMaker'); } } else { $optgroup_value = vtranslate("LBL_MODCOMMENTS_INFORMATION", 'PDFMaker'); } $Optgroupts[] = '"' . $optgroup_value . '","' . $b . '"'; if (count($block_fields) > 0) { $sql1 = "SELECT * FROM vtiger_field WHERE fieldid IN (" . generateQuestionMarks($block_fields) . ")"; $result1 = $adb->pquery($sql1, $block_fields); while ($row1 = $adb->fetchByAssoc($result1)) { $fieldname = $row1['fieldname']; $fieldlabel = $row1['fieldlabel']; $fieldModel = Vtiger_Field_Model::getInstance($fieldname, $moduleModel); if (!$fieldModel || !$fieldModel->getPermissions('readonly')) { if ($module == 'Calendar') { $eventFieldModel = Vtiger_Field_Model::getInstance($fieldname, $EventModel); if (!$eventFieldModel || !$eventFieldModel->getPermissions('readonly')) { continue; } } else { continue; } } $option_key = strtoupper($module . "_" . $fieldname); if (isset($current_mod_strings[$fieldlabel]) and $current_mod_strings[$fieldlabel] != "") { $option_value = $current_mod_strings[$fieldlabel]; } elseif (isset($app_strings[$fieldlabel]) and $app_strings[$fieldlabel] != "") { $option_value = $app_strings[$fieldlabel]; } else { $option_value = $fieldlabel; } $option_value = nl2br($option_value); if ($module == 'Calendar') { if ($option_key == 'CALENDAR_ACTIVITYTYPE' || $option_key == 'CALENDAR_DUE_DATE') { $Convert_ModuleFields['Calendar|1'] .= ',"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')][$option_key] = $option_value; continue; } elseif (!isset($Existing_ModuleFields[$option_key])) { $Existing_ModuleFields[$option_key] = $optgroup_value; } else { $Convert_ModuleFields['Calendar|1'] .= ',"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields['Calendar'][vtranslate('Calendar')][$option_key] = $option_value; $Unset_Module_Fields[] = '"' . $option_value . '","' . $option_key . '"'; unset($SelectModuleFields['Calendar'][$Existing_ModuleFields[$option_key]][$option_key]); continue; } } $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } } //variable RECORD ID added if ($b == 1) { $option_value = "Record ID"; $option_key = strtoupper($module . "_CRMID"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; $option_value = vtranslate('Created Time') . ' (' . vtranslate('Due Date & Time') . ')'; $option_key = strtoupper($module . "_CREATEDTIME_DATETIME"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; $option_value = vtranslate('Modified Time') . ' (' . vtranslate('Due Date & Time') . ')'; $option_key = strtoupper($module . "_MODIFIEDTIME_DATETIME"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } //end if ($block_label == "LBL_TERMS_INFORMATION" && isset($tacModules[$module])) { $option_value = vtranslate("LBL_TAC4YOU", 'PDFMaker'); $option_key = strtoupper($module . "_TAC4YOU"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } if ($block_label == "LBL_DESCRIPTION_INFORMATION" && isset($desc4youModules[$module])) { $option_value = vtranslate("LBL_DESC4YOU", 'PDFMaker'); $option_key = strtoupper($module . "_DESC4YOU"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } //ModComments support if ($block_label == "TEMP_MODCOMMENTS_BLOCK" && in_array($module, $ModCommentsModules) == true) { $option_value = vtranslate("LBL_MODCOMMENTS", 'PDFMaker'); $option_key = strtoupper($module . "_MODCOMMENTS"); $Options[] = '"' . $option_value . '","' . $option_key . '"'; $SelectModuleFields[$module][$optgroup_value][$option_key] = $option_value; } $Convert_RelatedModuleFields[$module . "|" . $b] = implode(",", $Options); $OptionsRelMod = array(); if (($block_label == "LBL_DETAILS_BLOCK" || $block_label == "LBL_ITEM_DETAILS") && ($module == "Quotes" || $module == "Invoice" || $module == "SalesOrder" || $module == "PurchaseOrder" || $module == "Issuecards" || $module == "Receiptcards" || $module == "Creditnote" || $module == "StornoInvoice")) { $Set_More_Fields = $More_Fields; if ($module == "Invoice") { $Set_More_Fields[strtoupper($module) . "_RECEIVED"] = vtranslate("Received", $module); } if ($module == "Invoice" || $module == "PurchaseOrder") { $Set_More_Fields[strtoupper($module) . "_BALANCE"] = vtranslate("Balance", $module); } foreach ($Set_More_Fields as $variable => $variable_name) { $variable_key = strtoupper($variable); $Options[] = '"' . $variable_name . '","' . $variable_key . '"'; $SelectModuleFields[$module][$optgroup_value][$variable_key] = $variable_name; if ($variable_key != "VATBLOCK") { $OptionsRelMod[] = '"' . $variable_name . '","' . strtoupper($module) . '_' . $variable_key . '"'; } } } //this concatenation is because of need to have extra Details block in Inventory modules which are as related modules $Convert_RelatedModuleFields[$module . "|" . $b] .= implode(',', $OptionsRelMod); $Convert_ModuleFields[$module . "|" . $b] = implode(",", $Options); } if ($module == 'Calendar') { $Convert_ModuleFields['Calendar|1'] = str_replace(',"Record ID","CALENDAR_CRMID",', "", $Convert_ModuleFields['Calendar|1']); $Convert_ModuleFields['Calendar|1'] .= ',"Record ID","CALENDAR_CRMID"'; unset($SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"]); $SelectModuleFields['Calendar'][vtranslate('Calendar')]["CALENDAR_CRMID"] = "Record ID"; } $Convert_ModuleBlocks[$module] = implode(",", $Optgroupts); } foreach ($Convert_ModuleFields as $cmf_key => $cmf_value) { if (substr($cmf_key, 0, 9) == 'Calendar|' && $cmf_key != 'Calendar|1') { foreach ($Unset_Module_Fields as $to_unset) { $cmf_value = str_replace($to_unset, '', $cmf_value); $cmf_value = str_replace(",,", ',', $cmf_value); $Convert_ModuleFields[$cmf_key] = trim($cmf_value, ','); } } } $viewer->assign("MODULE_BLOCKS", $Convert_ModuleBlocks); $viewer->assign("RELATED_MODULE_FIELDS", $Convert_RelatedModuleFields); $viewer->assign("MODULE_FIELDS", $Convert_ModuleFields); //Product block fields start // Product bloc templates $sql = "SELECT * FROM vtiger_pdfmaker_productbloc_tpl"; $result = $adb->pquery($sql, array()); $Productbloc_tpl[""] = vtranslate("LBL_PLS_SELECT", 'PDFMaker'); while ($row = $adb->fetchByAssoc($result)) { $Productbloc_tpl[$row["body"]] = $row["name"]; } $viewer->assign("PRODUCT_BLOC_TPL", $Productbloc_tpl); $ProductBlockFields = $PDFMaker->GetProductBlockFields($select_module); foreach ($ProductBlockFields as $viewer_key => $pbFields) { $viewer->assign($viewer_key, $pbFields); } //Product block fields end //Related block postprocessing $Related_Blocks = $PDFMaker->GetRelatedBlocks($select_module); $viewer->assign("RELATED_BLOCKS", $Related_Blocks); //Related blocks end if ($templateid != "" || $select_module != "") { $viewer->assign("SELECT_MODULE_FIELD", $SelectModuleFields[$select_module]); $smf_filename = $SelectModuleFields[$select_module]; if ($select_module == "Invoice" || $select_module == "Quotes" || $select_module == "SalesOrder" || $select_module == "PurchaseOrder" || $select_module == "Issuecards" || $select_module == "Receiptcards" || $select_module == "Creditnote" || $select_module == "StornoInvoice") { unset($smf_filename["Details"]); } $viewer->assign("SELECT_MODULE_FIELD_FILENAME", $smf_filename); } // header / footer display settings $disp_optionsArr = array("DH_FIRST", "DH_OTHER"); $disp_header_bin = str_pad(base_convert($disp_header, 10, 2), 2, "0", STR_PAD_LEFT); for ($i = 0; $i < count($disp_optionsArr); $i++) { if (substr($disp_header_bin, $i, 1) == "1") { $viewer->assign($disp_optionsArr[$i], 'checked="checked"'); } } if ($disp_header == "3") { $viewer->assign("DH_ALL", 'checked="checked"'); } $disp_optionsArr = array("DF_FIRST", "DF_LAST", "DF_OTHER"); $disp_footer_bin = str_pad(base_convert($disp_footer, 10, 2), 3, "0", STR_PAD_LEFT); for ($i = 0; $i < count($disp_optionsArr); $i++) { if (substr($disp_footer_bin, $i, 1) == "1") { $viewer->assign($disp_optionsArr[$i], 'checked="checked"'); } } if ($disp_footer == "7") { $viewer->assign("DF_ALL", 'checked="checked"'); } $ListView_Block = array("" => vtranslate("LBL_PLS_SELECT", 'PDFMaker'), "LISTVIEWBLOCK_START" => vtranslate("LBL_ARTICLE_START", 'PDFMaker'), "LISTVIEWBLOCK_END" => vtranslate("LBL_ARTICLE_END", 'PDFMaker'), "CRIDX" => vtranslate("LBL_COUNTER", 'PDFMaker')); $viewer->assign("LISTVIEW_BLOCK_TPL", $ListView_Block); $version_type = ucfirst($PDFMaker->GetVersionType()); $viewer->assign("VERSION", $version_type . " " . PDFMaker_Version_Helper::$version); $category = getParentTab(); $viewer->assign("CATEGORY", $category); $viewer->view('Edit.tpl', 'PDFMaker'); }
public function deleteProductBlocks(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $sql = "DELETE FROM vtiger_pdfmaker_productbloc_tpl WHERE id IN ("; $params = array(); foreach ($_REQUEST as $key => $val) { if (substr($key, 0, 4) == "chx_" && $val == "on") { list($dump, $id) = explode("_", $key, 2); if (is_numeric($id)) { $sql .= "?,"; array_push($params, $id); } } } if (count($params) > 0) { $sql = rtrim($sql, ",") . ")"; $adb->pquery($sql, $params); } header("Location:index.php?module=PDFMaker&view=ProductBlocks"); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $cu_model = Users_Record_Model::getCurrentUserModel(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $S_Data = $request->getAll(); $filename = $request->get('filename'); $modulename = $request->get('modulename'); $templateid = $request->get('templateid'); $description = $request->get('description'); $body = $S_Data['body']; $pdf_format = $request->get('pdf_format'); $pdf_orientation = $request->get('pdf_orientation'); $owner = $request->get('template_owner'); $sharingtype = $request->get('sharing'); //vtiger_pdfmaker_user_status $is_active = $request->get('is_active'); $is_default_dv = $request->get('is_default_dv'); $is_default_lv = $request->get('is_default_lv'); $is_portal = $request->get('is_portal'); $is_listview = $request->get('is_listview'); if ($is_default_dv != "") { $is_default_dv = "1"; } else { $is_default_dv = "0"; } if ($is_default_lv != "") { $is_default_lv = "1"; } else { $is_default_lv = "0"; } if ($is_portal != "") { $is_portal = "1"; } else { $is_portal = "0"; } if ($is_listview != "") { $is_listview = "1"; } else { $is_listview = "0"; } $order = $request->get('tmpl_order'); $dh_first = $request->get('dh_first'); $dh_other = $request->get('dh_other'); $df_first = $request->get('df_first'); $df_last = $request->get('df_last'); $df_other = $request->get('df_other'); if ($dh_first != "") { $dh_first = "1"; } else { $dh_first = "0"; } if ($dh_other != "") { $dh_other = "1"; } else { $dh_other = "0"; } if ($df_first != "") { $df_first = "1"; } else { $df_first = "0"; } if ($df_last != "") { $df_last = "1"; } else { $df_last = "0"; } if ($df_other != "") { $df_other = "1"; } else { $df_other = "0"; } if (isset($templateid) && $templateid != '') { $sql = "update vtiger_pdfmaker set filename =?, module =?, description =?, body =? where templateid =?"; $params = array($filename, $modulename, $description, $body, $templateid); $adb->pquery($sql, $params); $sql2 = "DELETE FROM vtiger_pdfmaker_settings WHERE templateid =?"; $params2 = array($templateid); $adb->pquery($sql2, $params2); $sql21 = "DELETE FROM vtiger_pdfmaker_userstatus WHERE templateid=? AND userid=?"; $adb->pquery($sql21, array($templateid, $cu_model->id)); } else { $templateid = $adb->getUniqueID('vtiger_pdfmaker'); $sql3 = "insert into vtiger_pdfmaker (filename,module,description,body,deleted,templateid) values (?,?,?,?,?,?)"; $params3 = array($filename, $modulename, $description, $body, 0, $templateid); $adb->pquery($sql3, $params3); } $margin_top = $request->get('margin_top'); if ($margin_top < 0) { $margin_top = 0; } $margin_bottom = $request->get('margin_bottom'); if ($margin_bottom < 0) { $margin_bottom = 0; } $margin_left = $request->get('margin_left'); if ($margin_left < 0) { $margin_left = 0; } $margin_right = $request->get('margin_right'); if ($margin_right < 0) { $margin_right = 0; } $dec_point = $request->get('dec_point'); $dec_decimals = $request->get('dec_decimals'); $dec_thousands = $request->get('dec_thousands'); if ($dec_thousands == " ") { $dec_thousands = "sp"; } $header = $S_Data['header_body']; $footer = $S_Data['footer_body']; $encoding = $request->get('encoding'); if ($encoding == "") { $encoding = "auto"; } $nameOfFile = $request->get('nameOfFile'); // ITS4YOU-CR VlZa //in case of allowed module make sure that only one template from that module is set for portal if (($modulename == "Invoice" || $modulename == "Quotes") && $is_portal == "1") { $sql4a = "UPDATE vtiger_pdfmaker_settings \n INNER JOIN vtiger_pdfmaker \n USING(templateid)\n SET is_portal = '0' \n WHERE is_portal = '1'\n AND module=?"; $params4a = array($modulename); $adb->pquery($sql4a, $params4a); } if ($pdf_format == "Custom") { $pdf_cf_width = $request->get('pdf_format_width'); $pdf_cf_height = $request->get('pdf_format_height'); $pdf_format = $pdf_cf_width . ";" . $pdf_cf_height; } $disp_header = base_convert($dh_first . $dh_other, 2, 10); $disp_footer = base_convert($df_first . $df_last . $df_other, 2, 10); $sql4 = "INSERT INTO vtiger_pdfmaker_settings (templateid, margin_top, margin_bottom, margin_left, margin_right, format, orientation, \n decimals, decimal_point, thousands_separator, header, footer, encoding, file_name, is_portal,\n is_listview, owner, sharingtype, disp_header, disp_footer)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; $params4 = array($templateid, $margin_top, $margin_bottom, $margin_left, $margin_right, $pdf_format, $pdf_orientation, $dec_decimals, $dec_point, $dec_thousands, $header, $footer, $encoding, $nameOfFile, $is_portal, $is_listview, $owner, $sharingtype, $disp_header, $disp_footer); $adb->pquery($sql4, $params4); // ITS4YOU-END //ignored picklist values $adb->pquery("DELETE FROM vtiger_pdfmaker_ignorepicklistvalues", array()); $ignore_picklist_values = $request->get('ignore_picklist_values'); $pvvalues = explode(",", $ignore_picklist_values); foreach ($pvvalues as $value) { $adb->pquery("INSERT INTO vtiger_pdfmaker_ignorepicklistvalues(value) VALUES(?)", array(trim($value))); } // end ignored picklist values //unset the former default template because only one template can be default per user x module $is_default_bin = $is_default_lv . $is_default_dv; $is_default_dec = intval(base_convert($is_default_bin, 2, 10)); // convert binary format xy to decimal; where x stands for is_default_lv and y stands for is_default_dv if ($is_default_dec > 0) { $sql5 = "UPDATE vtiger_pdfmaker_userstatus\n INNER JOIN vtiger_pdfmaker USING(templateid)\n SET is_default=?\n WHERE is_default=? AND userid=? AND module=?"; switch ($is_default_dec) { // in case of only is_default_dv is checked case 1: $adb->pquery($sql5, array("0", "1", $cu_model->id, $modulename)); $adb->pquery($sql5, array("2", "3", $cu_model->id, $modulename)); break; // in case of only is_default_lv is checked // in case of only is_default_lv is checked case 2: $adb->pquery($sql5, array("0", "2", $cu_model->id, $modulename)); $adb->pquery($sql5, array("1", "3", $cu_model->id, $modulename)); break; // in case of both is_default_* are checked // in case of both is_default_* are checked case 3: $sql5 = "UPDATE vtiger_pdfmaker_userstatus\n INNER JOIN vtiger_pdfmaker USING(templateid)\n SET is_default=?\n WHERE is_default > ? AND userid=? AND module=?"; $adb->pquery($sql5, array("0", "0", $cu_model->id, $modulename)); } } $sql6 = "INSERT INTO vtiger_pdfmaker_userstatus(templateid, userid, is_active, is_default, sequence) VALUES(?,?,?,?,?)"; $adb->pquery($sql6, array($templateid, $cu_model->id, $is_active, $is_default_dec, $order)); //SHARING $sql7 = "DELETE FROM vtiger_pdfmaker_sharing WHERE templateid=?"; $adb->pquery($sql7, array($templateid)); $selected_col_string = $request->get('sharingSelectedColumnsString'); if ($sharingtype == "share" && $selected_col_string != "") { $member_array = explode(';', $selected_col_string); $groupMemberArray = self::constructSharingMemberArray($member_array); $sql8a = "INSERT INTO vtiger_pdfmaker_sharing(templateid, shareid, setype) VALUES "; $sql8b = ""; $params8 = array(); foreach ($groupMemberArray as $setype => $shareIdArr) { foreach ($shareIdArr as $shareId) { $sql8b .= "(?, ?, ?),"; $params8[] = $templateid; $params8[] = $shareId; $params8[] = $setype; } } if ($sql8b != "") { $sql8b = rtrim($sql8b, ","); $sql8 = $sql8a . $sql8b; $adb->pquery($sql8, $params8); } } $PDFMaker->AddLinks($modulename); $redirect = $request->get('redirect'); if ($redirect == "false") { $redirect_url = "index.php?module=PDFMaker&view=Edit&parenttab=Tools&applied=true&templateid=" . $templateid; $return_module = $request->get('return_module'); $return_view = $request->get('return_view'); if ($return_module != "") { $redirect_url .= "&return_module=" . $return_module; } if ($return_view != "") { $redirect_url .= "&return_view=" . $return_view; } header("Location:" . $redirect_url); } else { header("Location:index.php?module=PDFMaker&view=Detail&parenttab=Tools&templateid=" . $templateid); } }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $simple_html_dom_file = $this->getSimpleHtmlDomFile(); require_once $simple_html_dom_file; $default_charset = vglobal('default_charset'); $adb = PearDatabase::getInstance(); $relmodule = $request->get("formodule"); $viewer = $this->getViewer($request); // get ids if ($request->get("idslist") != "") { //generating from listview $Records = explode(";", rtrim($request->get("idslist"), ";")); } elseif ($request->get('record') != '') { $Records = array($request->get("record")); } elseif ($request->get('return_id') != '') { $Records = array($request->get("return_id")); } $viewer->assign("RECORDS", implode(';', $Records)); // get selected templates id array $commontemplateids = trim($request->get("commontemplateid"), ";"); $Templateids = explode(";", $commontemplateids); $viewer->assign("COMMONTEMPLATEIDS", $commontemplateids); // get selected templates array $sql = "SELECT * FROM vtiger_pdfmaker WHERE templateid IN (" . generateQuestionMarks($Templateids) . ")"; $result = $adb->pquery($sql, $Templateids); $num_rows = $adb->num_rows($result); $template_select = ''; if ($num_rows > 1) { $template_select .= "<select onChange='changeTemplate(this.value);'>"; while ($row = $adb->fetchByAssoc($result)) { if ($st == "") { $st = $row['templateid']; } $template_select .= "<option value='" . $row['templateid'] . "'>" . $row['filename'] . "</option>"; } $template_select .= "</select>"; } else { $st = $adb->query_result($result, 0, "templateid"); $template_select .= $adb->query_result($result, 0, "filename"); } $viewer->assign("TEMPLATE_SELECT", $template_select); $viewer->assign("ST", $st); // get content of templates $PDFMaker = new PDFMaker_PDFMaker_Model('PDFMaker'); $PDFContents = array(); //require_once("modules/PDFMaker/InventoryPDF.php"); foreach ($Records as $record) { $record_model = Vtiger_Record_Model::getInstanceById($record); $focus = $record_model->entity; foreach ($Templateids as $templateid) { $PDFContent = new PDFMaker_PDFContent_Model($templateid, $relmodule, $focus, $request->get("language")); $pdf_content = $PDFContent->getContent(); $body_html = $pdf_content["body"]; $body_html = str_replace("#LISTVIEWBLOCK_START#", "", $body_html); $body_html = str_replace("#LISTVIEWBLOCK_END#", "", $body_html); $PDFContents[$templateid]["header"] = $pdf_content["header"]; $PDFContents[$templateid]["body"] = $body_html; $PDFContents[$templateid]["footer"] = $pdf_content["footer"]; } } $pdf_divs = ''; foreach ($PDFContents as $templateid => $templatedata) { $sections = array("body", "header", "footer"); foreach ($sections as $val) { if ($templatedata[$val] != "") { /* $html = str_get_html($templatedata[$val]); $textTags = $html->find('text'); foreach ($textTags as $text) { $text->outertext = str_replace(" ", " ", $text->outertext); $text->outertext = str_replace(" ", " ", $text->outertext); } $templatedata[$val] = htmlentities($html->save(), ENT_QUOTES, $default_charset); */ $templatedata[$val] = htmlentities($templatedata[$val], ENT_QUOTES, $default_charset); } } $pdf_divs .= '<div style="display:none;" id="body_div' . $templateid . '"> <textarea name="body' . $templateid . '" id="body' . $templateid . '" style="width:90%;height:700px" class=small tabindex="5">' . $templatedata["body"] . '</textarea> </div> <div style="display:none;" id="header_div' . $templateid . '"> <textarea name="header' . $templateid . '" id="header' . $templateid . '" style="width:90%;height:700px" class=small tabindex="5">' . $templatedata["header"] . '</textarea> </div> <div style="display:none;" id="footer_div' . $templateid . '"> <textarea name="footer' . $templateid . '" id="footer' . $templateid . '" style="width:90%;height:700px" class=small tabindex="5">' . $templatedata["footer"] . '</textarea> </div>'; $pdf_divs .= '<script type="text/javascript"> jQuery(document).ready(function(){ CKEDITOR.replace( \'body' . $templateid . '\', {height: \'300\'}); CKEDITOR.replace( \'header' . $templateid . '\', {height: \'300\'}); CKEDITOR.replace( \'footer' . $templateid . '\', {height: \'300\'}); }) </script>'; } $viewer->assign("PDF_DIVS", $pdf_divs); $language = Vtiger_Language_Handler::getLanguage(); $mod_strings = Vtiger_Language_Handler::getModuleStringsFromFile($language, "Documents"); $pdf_strings = Vtiger_Language_Handler::getModuleStringsFromFile($language, "PDFMaker"); $sql = "select foldername,folderid from vtiger_attachmentsfolder order by foldername"; $res = $adb->pquery($sql, array()); $options = ""; for ($i = 0; $i < $adb->num_rows($res); $i++) { $fid = $adb->query_result($res, $i, "folderid"); $fldr_name = $adb->query_result($res, $i, "foldername"); $options .= '<option value="' . $fid . '">' . $fldr_name . '</option>'; } $viewer->assign("FOLDER_OPTIONS", $options); $viewer->view('EditAndExport.tpl', 'PDFMaker'); }
public function process(Vtiger_Request $request) { PDFMaker_Debugger_Model::GetInstance()->Init(); $adb = PearDatabase::getInstance(); $cu_model = Users_Record_Model::getCurrentUserModel(); $PDFMaker = new PDFMaker_PDFMaker_Model(); $S_Data = $request->getAll(); $modulename = $request->get('modulename'); $templateid = $request->get('templateid'); $filename = $modulename; $description = ""; $body = $S_Data['body']; $pdf_format = $request->get('pdf_format'); $pdf_orientation = $request->get('pdf_orientation'); if (!$templateid) { $result = $adb->pquery("SELECT templateid FROM vtiger_pdfmaker WHERE module =?", array($modulename)); $templateid = $adb->query_result($result, 0, "templateid"); } if (isset($templateid) && $templateid != '') { $sql = "update vtiger_pdfmaker set filename =?, description =?, body =? where module =?"; $params = array($filename, $description, $body, $modulename); $adb->pquery($sql, $params); $sql2 = "DELETE FROM vtiger_pdfmaker_settings WHERE templateid =?"; $params2 = array($templateid); $adb->pquery($sql2, $params2); } else { $templateid = $adb->getUniqueID('vtiger_pdfmaker'); $sql3 = "insert into vtiger_pdfmaker (filename,module,description,body,deleted,templateid) values (?,?,?,?,?,?)"; $params3 = array($filename, $modulename, $description, $body, 0, $templateid); $adb->pquery($sql3, $params3); } $margin_top = $request->get('margin_top'); if ($margin_top < 0) { $margin_top = 0; } $margin_bottom = $request->get('margin_bottom'); if ($margin_bottom < 0) { $margin_bottom = 0; } $margin_left = $request->get('margin_left'); if ($margin_left < 0) { $margin_left = 0; } $margin_right = $request->get('margin_right'); if ($margin_right < 0) { $margin_right = 0; } $dec_point = $request->get('dec_point'); $dec_decimals = $request->get('dec_decimals'); $dec_thousands = $request->get('dec_thousands'); if ($dec_thousands == " ") { $dec_thousands = "sp"; } $header = $S_Data['header_body']; $footer = $S_Data['footer_body']; $encoding = $request->get('encoding'); if ($encoding == "") { $encoding = "auto"; } if ($pdf_format == "Custom") { $pdf_cf_width = $request->get('pdf_format_width'); $pdf_cf_height = $request->get('pdf_format_height'); $pdf_format = $pdf_cf_width . ";" . $pdf_cf_height; } $sql4 = "INSERT INTO vtiger_pdfmaker_settings (templateid, margin_top, margin_bottom, margin_left, margin_right, format, orientation, \n decimals, decimal_point, thousands_separator, header, footer, encoding, file_name, is_portal,\n is_listview, owner, sharingtype, disp_header, disp_footer)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; $params4 = array($templateid, $margin_top, $margin_bottom, $margin_left, $margin_right, $pdf_format, $pdf_orientation, $dec_decimals, $dec_point, $dec_thousands, $header, $footer, $encoding, "", 0, 0, "", "", "3", "7"); $adb->pquery($sql4, $params4); //ignored picklist values $adb->pquery("DELETE FROM vtiger_pdfmaker_ignorepicklistvalues", array()); $ignore_picklist_values = $request->get('ignore_picklist_values'); $pvvalues = explode(",", $ignore_picklist_values); foreach ($pvvalues as $value) { $adb->pquery("INSERT INTO vtiger_pdfmaker_ignorepicklistvalues( value ) VALUES ( ? )", array(trim($value))); } // end ignored picklist values //unset the former default template because only one template can be default per user x module $redirect = $request->get('redirect'); if ($redirect == "false") { $redirect_url = "index.php?module=PDFMaker&view=Edit&parenttab=Tools&applied=true&templateid=" . $templateid; $return_module = $request->get('return_module'); $return_view = $request->get('return_view'); if ($return_module != "") { $redirect_url .= "&return_module=" . $return_module; } if ($return_view != "") { $redirect_url .= "&return_view=" . $return_view; } header("Location:" . $redirect_url); } else { header("Location:index.php?module=PDFMaker&view=Detail&parenttab=Tools&templateid=" . $templateid); } }