PHP NWX_NAVWebX::nwx_dbc_get_last_detail_number Exemples

Exemple #1

Fichier : lgcrud_transaction_save.php Projet : jlo26/Web-Applications

     }
     //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];

Exemple #2

Fichier : test_mysql_property.php Projet : jlo26/Web-Applications

<?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;
 */