} //end condition break; case C_TRANSACTIONINDEX["SO_CREATE_DETAIL"]: /* New Sales Order Detail */ $A_columnList = array(); $A_aliasPattern = array(); $A_flippedResultSet = array(); $resultSet = array(); $S_commaSeparatedKey = ""; $S_commaSeparatedValue = ""; $salesDocumentNumber = $_POST["pd_salesNumber"]; /*Document Number */ $_POST["CNL_1603"] = $salesDocumentNumber; /*Line Number */ $_POST["CNL_1604"] = $nav_obj->nwx_dbc_get_last_detail_number($salesDocumentNumber); $nav_obj->A_propertyList = $_POST; $salesType = $nav_obj->s_salesType; $latestID = $nav_obj->nwx_dbc_create_sales_detail(); // print_r($latestID); print "X,X[++]" . $latestID . "," . $salesDocumentNumber; break; case C_TRANSACTIONINDEX["SO_UPDATE_HEADER"]: /* Update Sales Order Header */ $nav_obj->A_propertyList = $_POST; $latestID = $nav_obj->nwx_dbc_update_sales_header(); /* if($nav_obj->s_transSucceeded == DBO_SUCCESS_CREATE){ $A_aliasPattern = C_TRANSLATION_DICTIONARY["TR002"]; $A_columnList = $nav_obj->nwx_translate_alias_to_column($A_aliasPattern); $resultSet = $nav_obj->nwx_dbc_get_header_row($latestID,$A_columnList); $resultSet = $resultSet[0];
<?php require_once "../class/NWX_Database.cls.php"; require_once "../class/NWX_NAVWebX.cls.php"; require_once "../config/db.config"; require_once "../config/constant.config"; require_once "../config/setup.config.php"; require_once "../php/uf_utilities.php"; // $db_obj = new NWX_Database($servername,$username,$password,$dbname); $nav_obj = new NWX_NAVWebX($servername, $username, $password, $dbname, C_TABLELIST, C_NWXCOLUMNAMELIST); // $tableDef =$db_obj->nwx_dbc_select("nwx05_sales_header"); // $tableAttrib = 'id="example" class="table table-hover" cellspacing="0" width="100%" border="1"'; // $x = $nav_obj->nwx_dbc_get_col_prop('nwx02_item','n002_item_id'); // $x = $db_obj->nwx_dbc_if_autoincrement('nwx02_item','n002_item_id'); // $x = $db_obj->nwx_dbc_get_table_columns('nwx02_item'); $x = $nav_obj->nwx_generate_sequence('nwx06_sales_line'); print "<pre>"; print_r($nav_obj->nwx_dbc_get_last_detail_number('SN20160121_1')); /* print "<pre>"; $x = $nav_obj->nwx_create_datatable("TBS_06","P001"); print "<pre>"; for($x=1;$x<=15;$x++){ $ind = $x>9?$x:'0'.$x; $index = "CNL_15".$ind; print $index; print C_NWXCOLUMHTMLINPUT_M1[$index]; } print $x; */