function getColumnsTotal($reportid) { // Have we initialized it already? if ($this->_columnstotallist !== false) { return $this->_columnstotallist; } global $adb; global $modules; global $log, $current_user; $query = "select * from vtiger_reportmodules where reportmodulesid =?"; $res = $adb->pquery($query, array($reportid)); $modrow = $adb->fetch_array($res); $premod = $modrow["primarymodule"]; $secmod = $modrow["secondarymodules"]; $coltotalsql = "select vtiger_reportsummary.* from vtiger_report"; $coltotalsql .= " inner join vtiger_reportsummary on vtiger_report.reportid = vtiger_reportsummary.reportsummaryid"; $coltotalsql .= " where vtiger_report.reportid =?"; $result = $adb->pquery($coltotalsql, array($reportid)); while ($coltotalrow = $adb->fetch_array($result)) { $fieldcolname = $coltotalrow["columnname"]; if ($fieldcolname != "none") { $fieldlist = explode(":", $fieldcolname); $field_tablename = $fieldlist[1]; $field_columnname = $fieldlist[2]; $mod_query = $adb->pquery("SELECT distinct(tabid) as tabid from vtiger_field where tablename = ? and columnname=?", array($fieldlist[1], $fieldlist[2])); if ($adb->num_rows($mod_query) > 0) { $module_name = getTabName($adb->query_result($mod_query, 0, 'tabid')); $fieldlabel = trim($fieldlist[3]); if ($module_name) { $field_columnalias = $module_name . "_" . $fieldlist[3]; } else { $field_columnalias = $module_name . "_" . $fieldlist[3]; } } //$field_columnalias = $fieldlist[3]; $field_permitted = false; if (CheckColumnPermission($field_tablename, $field_columnname, $premod) != "false") { $field_permitted = true; } else { $mod = split(":", $secmod); foreach ($mod as $key) { if (CheckColumnPermission($field_tablename, $field_columnname, $key) != "false") { $field_permitted = true; } } } if ($field_permitted == true) { $field = $field_tablename . "." . $field_columnname; if ($field_tablename == 'vtiger_products' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerProduct.actual_unit_price"; } if ($field_tablename == 'vtiger_service' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerService.actual_unit_price"; } if (($field_tablename == 'vtiger_invoice' || $field_tablename == 'vtiger_quotes' || $field_tablename == 'vtiger_purchaseorder' || $field_tablename == 'vtiger_salesorder') && ($field_columnname == 'total' || $field_columnname == 'subtotal' || $field_columnname == 'discount_amount' || $field_columnname == 's_h_amount')) { $field = " {$field_tablename}.{$field_columnname}/{$field_tablename}.conversion_rate "; } if ($fieldlist[4] == 2) { $stdfilterlist[$fieldcolname] = "sum({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 3) { //Fixed average calculation issue due to NULL values ie., when we use avg() function, NULL values will be ignored.to avoid this we use (sum/count) to find average. //$stdfilterlist[$fieldcolname] = "avg(".$fieldlist[1].".".$fieldlist[2].") '".$fieldlist[3]."'"; $stdfilterlist[$fieldcolname] = "(sum({$field})/count(*)) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 4) { $stdfilterlist[$fieldcolname] = "min({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 5) { $stdfilterlist[$fieldcolname] = "max({$field}) '" . $field_columnalias . "'"; } } } } // Save the information $this->_columnstotallist = $stdfilterlist; $log->info("ReportRun :: Successfully returned getColumnsTotal" . $reportid); return $stdfilterlist; }
function getColumnsTotal($reportid, $selectlist = '') { // Have we initialized it already? if ($this->_columnstotallist !== false) { return $this->_columnstotallist; } global $adb, $modules, $log, $current_user; $query = "select * from vtiger_reportmodules where reportmodulesid =?"; $res = $adb->pquery($query, array($reportid)); $modrow = $adb->fetch_array($res); $premod = $modrow["primarymodule"]; $secmod = $modrow["secondarymodules"]; $coltotalsql = "select vtiger_reportsummary.* from vtiger_report"; $coltotalsql .= " inner join vtiger_reportsummary on vtiger_report.reportid = vtiger_reportsummary.reportsummaryid"; $coltotalsql .= " where vtiger_report.reportid =?"; $result = $adb->pquery($coltotalsql, array($reportid)); $seltotalcols = array(); $stdfilterlist = array(); while ($coltotalrow = $adb->fetch_array($result)) { $fieldcolname = $coltotalrow["columnname"]; if ($fieldcolname != "none") { $sckey = $scval = ''; $fieldlist = explode(":", $fieldcolname); $field_tablename = $fieldlist[1]; $field_columnname = $fieldlist[2]; $mod_query = $adb->pquery("SELECT distinct(tabid) as tabid from vtiger_field where tablename = ? and columnname=?", array($fieldlist[1], $fieldlist[2])); if ($adb->num_rows($mod_query) > 0) { $module_name = getTabName($adb->query_result($mod_query, 0, 'tabid')); $fieldlabel = trim($fieldlist[3]); if ($module_name) { $field_columnalias = $module_name . "_" . $fieldlist[3]; } else { $field_columnalias = $module_name . "_" . $fieldlist[3]; } $field_columnalias = decode_html($field_columnalias); $query_columnalias = substr($field_columnalias, 0, strrpos($field_columnalias, '_')); $query_columnalias = str_replace(array(' ', '&'), '_', $query_columnalias); } $sckey = $field_tablename . ':' . $field_columnname . ':' . $query_columnalias . ':' . $field_columnname . ':N'; // vtiger_invoice:subject:Invoice_Subject:subject:V $scval = $field_tablename . '.' . $field_columnname . " AS '" . $query_columnalias . "'"; // vtiger_invoice.subject AS 'Invoice_Subject' $seltotalcols[$sckey] = $scval; $field_permitted = false; if (CheckColumnPermission($field_tablename, $field_columnname, $module_name) != "false") { $field_permitted = true; } /* one call to CheckColumnPermission with $module_name is better than the block below if(CheckColumnPermission($field_tablename,$field_columnname,$premod) != "false"){ $field_permitted = true; } else { $mod = explode(":",$secmod); foreach($mod as $key){ if(CheckColumnPermission($field_tablename,$field_columnname,$key) != "false"){ $field_permitted=true; } } } */ if ($field_permitted == true) { if ($field_tablename == 'vtiger_products' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $query_columnalias = ' actual_unit_price'; $seltotalcols['innerProduct:actual_unit_price:Products_Unit_Price:actual_unit_price:N'] = 'innerProduct.actual_unit_price AS actual_unit_price'; } if ($field_tablename == 'vtiger_service' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $query_columnalias = ' actual_unit_price'; $seltotalcols['innerService:actual_unit_price:Services_Unit_Price:actual_unit_price:N'] = 'innerService.actual_unit_price AS actual_unit_price'; } if (($field_tablename == 'vtiger_invoice' || $field_tablename == 'vtiger_quotes' || $field_tablename == 'vtiger_purchaseorder' || $field_tablename == 'vtiger_salesorder') && ($field_columnname == 'total' || $field_columnname == 'subtotal' || $field_columnname == 'discount_amount' || $field_columnname == 's_h_amount')) { $query_columnalias = " {$query_columnalias}/{$module_name}" . "_Conversion_Rate "; $seltotalcols[$field_tablename . ':conversion_rate:' . $module_name . '_Conversion_Rate:conversion_rate:N'] = "{$field_tablename}.conversion_rate AS {$module_name}" . "_Conversion_Rate "; } if ($fieldlist[4] == 2) { if ($fieldlist[2] == 'totaltime') { $stdfilterlist[$fieldcolname] = "sec_to_time(sum(time_to_sec(" . $query_columnalias . "))) '" . $field_columnalias . "'"; } else { $stdfilterlist[$fieldcolname] = "sum({$query_columnalias}) '" . $field_columnalias . "'"; } } if ($fieldlist[4] == 3) { //Fixed average calculation issue due to NULL values ie., when we use avg() function, NULL values will be ignored.to avoid this we use (sum/count) to find average. //$stdfilterlist[$fieldcolname] = "avg(".$fieldlist[1].".".$fieldlist[2].") '".$fieldlist[3]."'"; if ($fieldlist[2] == 'totaltime') { $stdfilterlist[$fieldcolname] = "sec_to_time(sum(time_to_sec(" . $query_columnalias . "))/count(*)) '" . $field_columnalias . "'"; } else { $stdfilterlist[$fieldcolname] = "(sum({$query_columnalias})/count(*)) '" . $field_columnalias . "'"; } } if ($fieldlist[4] == 4) { if ($fieldlist[2] == 'totaltime') { $stdfilterlist[$fieldcolname] = "sec_to_time(min(time_to_sec(" . $query_columnalias . "))) '" . $field_columnalias . "'"; } else { $stdfilterlist[$fieldcolname] = "min({$query_columnalias}) '" . $field_columnalias . "'"; } } if ($fieldlist[4] == 5) { if ($fieldlist[2] == 'totaltime') { $stdfilterlist[$fieldcolname] = "sec_to_time(max(time_to_sec(" . $query_columnalias . "))) '" . $field_columnalias . "'"; } else { $stdfilterlist[$fieldcolname] = "max({$query_columnalias}) '" . $field_columnalias . "'"; } } } } } // Save the information $this->_columnstotallist = $stdfilterlist; $stc = array_diff($seltotalcols, $selectlist); $this->_columnstotallistaddtoselect = $stc; $log->info("ReportRun :: Successfully returned getColumnsTotal" . $reportid); return $stdfilterlist; }
function getColumnsTotal($reportid) { global $log; $log->debug("Entering ./modules/ITS4YouReports/GenerateObj.php::getColumnsTotal"); global $log; $log->debug("Entering ./modules/ITS4YouReports/GenerateObj.php::getColumnsTotal"); global $log; $log->debug("Entering ./modules/ITS4YouReports/GenerateObj.php::getColumnsTotal"); global $log; $log->debug("Entering ./modules/ITS4YouReports/GenerateObj.php::getColumnsTotal"); // Have we initialized it already? if (isset($this->_columnstotallist) && $this->_columnstotallist !== false) { return $this->_columnstotallist; } $adb = PEARDatabase::getInstance(); global $current_user; $query = "SELECT * FROM its4you_reports4you_modules WHERE reportmodulesid =?"; $res = $adb->pquery($query, array($reportid)); $modrow = $adb->fetch_array($res); $premod = $modrow["primarymodule"]; $premod_name = vtlib_getModuleNameById($premod); $secmod = $modrow["secondarymodules"]; $coltotalsql = "SELECT its4you_reports4you_summary.* FROM its4you_reports4you"; $coltotalsql .= " INNER JOIN its4you_reports4you_summary on its4you_reports4you.reports4youid = its4you_reports4you_summary.reportsummaryid"; $coltotalsql .= " WHERE its4you_reports4you.reports4youid =?"; $result = $adb->pquery($coltotalsql, array($reportid)); while ($coltotalrow = $adb->fetch_array($result)) { $fieldcolname = $coltotalrow["columnname"]; if ($fieldcolname != "none") { $fieldlist = explode(":", $fieldcolname); $field_tablename = $fieldlist[1]; $field_columnname = $fieldlist[2]; $mod_query = $adb->pquery("SELECT distinct(tabid) AS tabid FROM vtiger_field WHERE tablename = ? AND columnname=?", array($fieldlist[1], $fieldlist[2])); if ($adb->num_rows($mod_query) > 0) { $module_name = getTabName($adb->query_result($mod_query, 0, 'tabid')); $fieldlabel = trim($fieldlist[3]); if ($module_name) { $field_columnalias = $module_name . "_" . $fieldlist[3]; } else { $field_columnalias = $module_name . "_" . $fieldlist[3]; } } //$field_columnalias = $fieldlist[3]; $field_permitted = false; if (CheckColumnPermission($field_tablename, $field_columnname, $premod) != "false") { $field_permitted = true; } else { $mod_s = split(":", $secmod); // $premod_name = vtlib_getModuleNameById($premod); foreach ($mod_s as $key) { $mod_arr = explode("x", $key); $mod = $mod_arr[0]; $mod_name = vtlib_getModuleNameById($mod); if (CheckColumnPermission($field_tablename, $field_columnname, $mod_name) != "false") { $field_permitted = true; } } } if ($field_permitted == true) { $field = $field_tablename . "." . $field_columnname; if ($field_tablename == 'vtiger_products' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerProduct.actual_unit_price"; } if ($field_tablename == 'vtiger_service' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerService.actual_unit_price"; } if (($field_tablename == 'vtiger_invoice' || $field_tablename == 'vtiger_quotes' || $field_tablename == 'vtiger_purchaseorder' || $field_tablename == 'vtiger_salesorder') && ($field_columnname == 'total' || $field_columnname == 'subtotal' || $field_columnname == 'discount_amount' || $field_columnname == 's_h_amount')) { $field = " {$field_tablename}.{$field_columnname}/{$field_tablename}.conversion_rate "; } //ITS4YouReports::sshow($fieldlist); if ($fieldlist[4] == 2) { $stdfilterlist[$fieldcolname] = "sum({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 3) { //Fixed average calculation issue due to NULL values ie., when we use avg() function, NULL values will be ignored.to avoid this we use (sum/count) to find average. //$stdfilterlist[$fieldcolname] = "avg(".$fieldlist[1].".".$fieldlist[2].") '".$fieldlist[3]."'"; $stdfilterlist[$fieldcolname] = "(sum({$field})/count(*)) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 4) { $stdfilterlist[$fieldcolname] = "min({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 5) { $stdfilterlist[$fieldcolname] = "max({$field}) '" . $field_columnalias . "'"; } } } } // Save the information $this->_columnstotallist = $stdfilterlist; return $stdfilterlist; }
function getColumnsTotal($reportid) { // Have we initialized it already? if ($this->_columnstotallist !== false) { return $this->_columnstotallist; } global $adb; global $modules; global $log, $current_user; static $modulename_cache = array(); $query = "select * from vtiger_reportmodules where reportmodulesid =?"; $res = $adb->pquery($query, array($reportid)); $modrow = $adb->fetch_array($res); $premod = $modrow["primarymodule"]; $secmod = $modrow["secondarymodules"]; $coltotalsql = "select vtiger_reportsummary.* from vtiger_report"; $coltotalsql .= " inner join vtiger_reportsummary on vtiger_report.reportid = vtiger_reportsummary.reportsummaryid"; $coltotalsql .= " where vtiger_report.reportid =?"; $result = $adb->pquery($coltotalsql, array($reportid)); while ($coltotalrow = $adb->fetch_array($result)) { $fieldcolname = $coltotalrow["columnname"]; if ($fieldcolname != "none") { $fieldlist = explode(":", $fieldcolname); $field_tablename = $fieldlist[1]; $field_columnname = $fieldlist[2]; $cachekey = $field_tablename . ":" . $field_columnname; if (!isset($modulename_cache[$cachekey])) { $mod_query = $adb->pquery("SELECT distinct(tabid) as tabid from vtiger_field where tablename = ? and columnname=?", array($fieldlist[1], $fieldlist[2])); if ($adb->num_rows($mod_query) > 0) { $module_name = getTabName($adb->query_result($mod_query, 0, 'tabid')); $modulename_cache[$cachekey] = $module_name; } } else { $module_name = $modulename_cache[$cachekey]; } $fieldlabel = trim($fieldlist[3]); if ($field_tablename == 'vtiger_inventoryproductrel') { $field_columnalias = $premod . "_" . $fieldlist[3]; } else { if ($module_name) { $field_columnalias = $module_name . "_" . $fieldlist[3]; } else { $field_columnalias = $module_name . "_" . $fieldlist[3]; } } //$field_columnalias = $fieldlist[3]; $field_permitted = false; if (CheckColumnPermission($field_tablename, $field_columnname, $premod) != "false") { $field_permitted = true; } else { $mod = split(":", $secmod); foreach ($mod as $key) { if (CheckColumnPermission($field_tablename, $field_columnname, $key) != "false") { $field_permitted = true; } } } //Calculation fields of "Events" module should show in Calendar related report $secondaryModules = split(":", $secmod); if ($field_permitted === false && ($premod === 'Calendar' || in_array('Calendar', $secondaryModules)) && CheckColumnPermission($field_tablename, $field_columnname, "Events") != "false") { $field_permitted = true; } if ($field_permitted == true) { $field = $field_tablename . "." . $field_columnname; if ($field_tablename == 'vtiger_products' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerProduct.actual_unit_price"; $this->queryPlanner->addTable("innerProduct"); } if ($field_tablename == 'vtiger_service' && $field_columnname == 'unit_price') { // Query needs to be rebuild to get the value in user preferred currency. [innerProduct and actual_unit_price are table and column alias.] $field = " innerService.actual_unit_price"; $this->queryPlanner->addTable("innerService"); } if (($field_tablename == 'vtiger_invoice' || $field_tablename == 'vtiger_quotes' || $field_tablename == 'vtiger_purchaseorder' || $field_tablename == 'vtiger_salesorder') && ($field_columnname == 'total' || $field_columnname == 'subtotal' || $field_columnname == 'discount_amount' || $field_columnname == 's_h_amount' || $field_columnname == 'paid' || $field_columnname == 'balance' || $field_columnname == 'received')) { $field = " {$field_tablename}.{$field_columnname}/{$field_tablename}.conversion_rate "; } if ($field_tablename == 'vtiger_inventoryproductrel') { // Check added so that query planner can prepare query properly for inventory modules $this->lineItemFieldsInCalculation = true; $field = $field_tablename . $premod . '.' . $field_columnname; $itemTableName = 'vtiger_inventoryproductrel' . $premod; $this->queryPlanner->addTable($itemTableName); if ($field_columnname == 'listprice') { $primaryModuleInstance = CRMEntity::getInstance($premod); $field = $field . '/' . $primaryModuleInstance->table_name . '.conversion_rate'; } else { if ($field_columnname == 'discount_amount') { $field = ' CASE WHEN ' . $itemTableName . '.discount_amount is not null THEN ' . $itemTableName . '.discount_amount/' . $primaryModuleInstance->table_name . '.conversion_rate ' . 'WHEN ' . $itemTableName . '.discount_percent IS NOT NULL THEN (' . $itemTableName . '.listprice*' . $itemTableName . '.quantity*' . $itemTableName . '.discount_percent/100/' . $primaryModuleInstance->table_name . '.conversion_rate) ELSE 0 END '; } } } if ($fieldlist[4] == 2) { $stdfilterlist[$fieldcolname] = "sum({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 3) { //Fixed average calculation issue due to NULL values ie., when we use avg() function, NULL values will be ignored.to avoid this we use (sum/count) to find average. //$stdfilterlist[$fieldcolname] = "avg(".$fieldlist[1].".".$fieldlist[2].") '".$fieldlist[3]."'"; $stdfilterlist[$fieldcolname] = "(sum({$field})/count(*)) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 4) { $stdfilterlist[$fieldcolname] = "min({$field}) '" . $field_columnalias . "'"; } if ($fieldlist[4] == 5) { $stdfilterlist[$fieldcolname] = "max({$field}) '" . $field_columnalias . "'"; } $this->queryPlanner->addTable($field_tablename); } } } // Save the information $this->_columnstotallist = $stdfilterlist; $log->info("ReportRun :: Successfully returned getColumnsTotal" . $reportid); return $stdfilterlist; }
* applicable law or agreed to in writing, any software distributed under the License is distributed * on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and limitations under the * License terms of Creative Commons Attribution-NonCommercial-ShareAlike 3.0 (the License). ************************************************************************************************* * Module : cbMap * Version : 5.5.0 * Author : OpenCubed. *************************************************************************************************/ include_once 'modules/cbMap/cbMap.php'; include_once 'include/utils/CommonUtils.php'; include_once 'include/utils/utils.php'; global $log, $app_strings, $mod_strings, $current_language, $currentModule, $theme; $mapInstance = CRMEntity::getInstance('cbMap'); $module1 = intval($_REQUEST['pmodule']); $module2 = getTabName($module1); $focus = CRMEntity::getInstance($module2); $blocks = $mapInstance->getBlocksPortal1($module2, 'edit_view', 'edit', $focus->column_fields, '', '5'); $t2 = array(); foreach ($blocks as $block => $fields) { $fields_ret = array(); foreach ($fields as $field => $arr_field) { foreach ($arr_field as $each_arr_fields => $each_arr_field) { $fldname = $blocks[$block][$field][$each_arr_fields][2][0]; $fldlabel = $blocks[$block][$field][$each_arr_fields][1][0]; if ($fldname != '') { $fields_ret[] = array('name' => $fldname, 'label' => $fldlabel); } } } $t2["{$block}"] = $fields_ret;
$plt->set_var('count', $num); } } elseif ($method == 'datarep') { $plt->set_file('main', $ac . '_' . $method . '.html'); $colarr = array('v', 'n'); $valarr = array(); $rn = 'table'; $plt->set_block('main', 'list_' . $rn, 'rows_' . $rn); $sql = 'SHOW TABLES FROM `' . $MAC['db']['name'] . '`'; $rs = $db->query($sql); while ($row = $db->fetch_array($rs)) { $v = $row['Tables_in_' . $MAC['db']['name']]; for ($i = 0; $i < count($colarr); $i++) { $n = $colarr[$i]; if ($n == 'n') { $v .= ' (' . getTabName($v) . ')'; } //$v = $valarr[$n]; $plt->set_var($n, $v); } $plt->parse('rows_' . $rn, 'list_' . $rn, true); } unset($rs); } elseif ($method == 'datarepexe') { $page = intval($p['pg']); if ($page < 1) { $page = 1; } if ($page == 1) { $table = be('post', 'table'); $field = be('post', 'field');
} $focus = new $object_name(); if ($callInitImport) { $focus->initImport(); } } else { echo "Sorry! Import Option is not provided for this module."; exit; } if (isset($_REQUEST['return_module'])) { $smarty->assign("RETURN_MODULE", $_REQUEST['return_module']); } if (isset($_REQUEST['return_action'])) { $smarty->assign("RETURN_ACTION", $_REQUEST['return_action']); } $smarty->assign("THEME", $theme); $smarty->assign("IMAGE_PATH", $image_path); //$smarty->assign("PRINT_URL", "phprint.php?jt=".session_id().$GLOBALS['request_string']); $smarty->assign("HEADER", $app_strings['LBL_IMPORT'] . " " . $mod_strings['LBL_MODULE_NAME']); $smarty->assign("HAS_HEADER_CHECKED", " CHECKED"); //$smarty->assign("OVERWRITE_CHECKED"," CHECKED"); $smarty->assign("MODULE", getTabName($module) . $_REQUEST['module']); $smarty->assign("SOURCE", $_REQUEST['source']); //we have set this as default. upto 4.2.3 we have Outlook, Act, SF formats. but now CUSTOM is enough to import $lang_key = "CUSTOM"; $smarty->assign("INSTRUCTIONS_TITLE", $mod_strings["LBL_IMPORT_{$lang_key}_TITLE"]); for ($i = 1; isset($mod_strings["LBL_{$lang_key}_NUM_{$i}"]); $i++) { $smarty->assign("STEP_NUM", $mod_strings["LBL_NUM_{$i}"]); $smarty->assign("INSTRUCTION_STEP", $mod_strings["LBL_{$lang_key}_NUM_{$i}"]); } $smarty->display("ImportStepNew1.tpl");