dippy's Replies

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

1 2 →

Author

Posts

September 20, 2014 at 7:41 pm in reply to: grid column with format grid column with format #59813

dippy

Participant

Any help ? Please

September 19, 2014 at 1:38 pm in reply to: grid column with format grid column with format #59782

dippy

Participant

Dear Dimitar,

Thanks for your reply. I have database fields for the 2 computed columns mentioned above, grid displays correct data as % and when commit i can see a value zero value getting committed in alert message. The database also shows zero value. M

Below is the code

updaterow: function (rowid, rowdata, commit)
{	
var data = "update=true&" + $.param(rowdata);
  alert(data);

My problem is it does not show correct % value in the alert message.Other columns values are correct. Do i need to bind the computed data values explicitly.

Please advice.

regards

September 16, 2014 at 9:23 pm in reply to: grid column with format grid column with format #59589

dippy

Participant

Repasting the code

{ text: 'Margin', editable: false, datafield: 'Mgn',width: 65,
                      cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) {
						 if ((parseFloat(rowdata.FinalRSP)>0) && parseFloat(rowdata.EstTerrLndCst)>0)
						 {
						  var FinalRSPNetVat=((parseFloat(rowdata.FinalRSP)*100)/(100+parseFloat(rowdata.VATPer)));
                          var mrgn = ((parseFloat(FinalRSPNetVat)-parseFloat(rowdata.EstTerrLndCst))/parseFloat(FinalRSPNetVat))*100;
						  return "<div class='jqx-right-align'>" + dataAdapter.formatNumber(mrgn, "p2") + "</div>";
                         }						                        
                      }
                  },
				  { text: 'Markup', editable: false, datafield: 'Mup',width: 65,
                      cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) 
					  {
						 if (parseFloat(rowdata.FinalRSP)>0 &&  parseFloat(rowdata.EstTerrLndCst)>0)
						 {
						  var FinalRSPNetVat=((parseFloat(rowdata.FinalRSP)*100)/(100+parseFloat(rowdata.VATPer)));
                          var mrkup = ((parseFloat(FinalRSPNetVat)-parseFloat(rowdata.EstTerrLndCst))/parseFloat(rowdata.EstTerrLndCst))*100;
						  return "<div class='jqx-right-align'>" + dataAdapter.formatNumber(mrkup, "p2") + "</div>";
                         }						                       
                    }

August 25, 2014 at 9:55 pm in reply to: Grid Commit to Database Grid Commit to Database #58751

dippy

Participant

Dear Dimitar,

Thanks for the help. I saw the example illustrated in http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/editrowsrendering.htm?arctic

However the example shows commiting only in case of editing cells.

What I need is a updaterow automatic which will say data to the database as well as on button click “approved”.

While button click I want to want some additional values in the database against each row like a “Apporved flag” in the database table which I am doing in the iteration (above example). This I am doing thru updating/editing a hidden field in the grid. Which is calling the updaterow method again

Can you pls post an example for the something related to same.

regards

August 24, 2014 at 8:32 pm in reply to: Grid Commit to Database Grid Commit to Database #58705

dippy

Participant

Hi any help..?

June 17, 2014 at 8:10 pm in reply to: Can't add or edit grid Can't add or edit grid #55992

dippy

Participant

Hi Harryb1965.

Can you post the final code. Also how are you updating the database with new values thru grid.

please post

June 17, 2014 at 7:59 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55990

dippy

Participant

how can do I update specific field vslues only. also I want the update row to fire only when I click a button. not at every cell editing.

June 17, 2014 at 7:58 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55988

dippy

Participant

Stuck can some one help on whats the best practice to post data changes to database.

June 3, 2014 at 7:27 am in reply to: SyntaxError: invalid character SyntaxError: invalid character #55249

dippy

Participant

Hi Peter,

Does the content/ syntax which is getting fired looks ok. update=true&LineNo=0&CustomInvoiceNo=CDCRAQA13-021583&AccInvoiceNo=HCQAAECTR13-39717&ItemCode=155125027&ItemDesc=Koala+Bear+5pcs.+Kids+Breakfast+Set+With+Suitcase+Pack&EstTerrLndCst=20.108&SuggRSP=49&FinalRSP=0

June 2, 2014 at 10:41 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55221

dippy

Participant

Hi Peter,
my var data = “update=true&” + $.param(rowdata);

alert(data);
Looks like this

update=true&LineNo=0&CustomInvoiceNo=CDCRAQA13-021583&AccInvoiceNo=HCQAAECTR13-39717&ItemCode=155125027&ItemDesc=Koala+Bear+5pcs.+Kids+Breakfast+Set+With+Suitcase+Pack&EstTerrLndCst=20.108&SuggRSP=49&FinalRSP=49&VATPer=0&Margin=0&Markup=0&uid=0

is this the correct data format for a row update. the $Column is not same as database. So I hope this is will show grid fieldname.
Also I don’t have a uid column in my database.

rest I have columns in data base table.

June 2, 2014 at 4:46 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55202

dippy

Participant

Hi Peter,

Yes it shows the error when In your ALert alert(“ERROR”+errorThrown); I’m trying to resolve the same. Please can you try from your side as well.
Will post if I am able to resolve it.

June 2, 2014 at 12:48 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55187

dippy

Participant

Dear Peter,

What is the best way for the same can you suggest some examples.

regards

June 1, 2014 at 7:51 pm in reply to: SyntaxError: invalid character SyntaxError: invalid character #55160

dippy

Participant

Hi Peter,

The Error comes when I click on the FinalRSP column. It calls the updaterow function which throws error.

If I comment the

updaterow: function (rowid, rowdata, commit)
					{	// synchronize with the server - send update command        
			
					var data = "update=true&FinalRSP=" + rowdata.FinalRSP + "&Margin=" + rowdata.Margin + "&Markup=" + rowdata.Markup;          	
					$.ajax({            
					dataType: "json",            
					url: 'data.php',			
					cache: false,            
					data: data,            
					success: function (data, status, xhr) {				
							// update command is executed.				
							commit(true);
							alert("committed");		
							},			
							error: function(jqXHR, textStatus, errorThrown)
							{	
							alert("ERROR"+errorThrown);									
							commit(false);
							}
							});
					}

code I don’t get the error. There is something wrong I’m doing in the ajax call.

Please can you help.

regards

May 24, 2014 at 4:07 pm in reply to: Master-Detail Grid: Resetting Datasource Master-Detail Grid: Resetting Datasource #54856

dippy

Participant

Hi Csoga,

Please find the oracle data example php page.

<?php
#Include the connect.php file
include('xe.php');
#Connect to the database
//connection String

if ($xeconn == False){
	print "can't find $database";
}
// get data and store in a json array
$query = "select * from cps_ainvc_head_test";
if (isset($_GET['accinvoiceno']))
{
	$query = "SELECT Nvl(B.LINE_NO,0)LINE_NO,
		   A.CINVC_NO,
           A.AINVC_NO,
           B.ITEM,
           Initcap(B.ITEM_DESC)ITEM_DESC,
           Round(Nvl(B.EST_UNIT_TERR_LND_CST,0),3)EST_UNIT_TERR_LND_CST,
           Nvl(B.SUG_INIT_PRICE,0)SUG_INIT_PRICE,
           Nvl(B.BUY_FINAL_RSP,0)BUY_FINAL_RSP,
           B.AVG_VAT_RATE           
        FROM CPS_AINVC_HEAD_TEST A,
             CPS_AINVC_DETL_TEST B, 
             DOC_APPROVER_MERCH_HIERARCHY C,
             DOC_APPROVERS D,
             DOC_APPROVER_LVL E,
             DOC_APPROVAL_AUTHORITY F 
        WHERE A.CINVC_NO=B.CINVC_NO
        AND A.AINVC_NO=B.AINVC_NO
		AND A.AINVC_NO='".$_GET['accinvoiceno']."'         	
        AND A.FINAL_TO_WH=B.FINAL_TO_WH
        AND B.DEPT=C.APP_DEPT    
        AND B.DOC_CURR_APP_SEQ_NO=E.APP_FLOW_SEQ_NO
        AND B.RSP_CHANGE_IND IS NULL 
        AND C.APP_CODE=D.APP_CODE
        AND C.APP_CODE=1
        AND E.DOC_TYPE='CPS'
        AND E.DOC_TYPE=F.DOC_TYPE
        AND E.APP_TYPE=F.APP_TYPE
		ORDER BY B.LINE_NO";
		
	$result = oci_parse($xeconn,$query);
	oci_execute($result);
	
	// get data and store in a json array
	while ($row =oci_fetch_array($result, OCI_ASSOC))
	{
		$accInvDetails[] = array(
		'LineNo' => $row['LINE_NO'],		
        'CustomInvoiceNo' => $row['CINVC_NO'],		
        'AccInvoiceNo' => $row['AINVC_NO'],		
		'ItemCode' => $row['ITEM'],		
		'ItemDesc' => $row['ITEM_DESC'],		
		'EstTerrLndCst' => $row['EST_UNIT_TERR_LND_CST'],
		'SuggRSP' => $row['SUG_INIT_PRICE'],
		'FinalRSP' => $row['BUY_FINAL_RSP'],
		'VATPer' => $row['AVG_VAT_RATE'],
      );
	}
    $data[] = array(    
	   'Rows' => $accInvDetails
	);
	echo json_encode($data);    	
}
else
{	
	$query = "select 
				 AINVC_NO,
                 CINVC_NO,           
                 AINVC_DT,
                 FINAL_TO_WH,
                 VOLUME,
                 SUM(AI_VALUE)AI_VALUE,
                 AGEING                 
			  from                 
					(SELECT  A.AINVC_NO,
					A.CINVC_NO,           
					A.AINVC_DT,
					A.FINAL_TO_WH,
					ROUND(A.VOLUME,2)VOLUME,
					ROUND(SUM(B.AI_ITEM_RATE*B.AI_QTY),0)AI_VALUE,
					ROUND((SYSDATE-A.AINVC_DT),0)AGEING					                           
					FROM CPS_AINVC_HEAD_TEST A,
						CPS_AINVC_DETL_TEST B, 
						DOC_APPROVER_MERCH_HIERARCHY C,
						DOC_APPROVERS D,
						DOC_APPROVER_LVL E,
						DOC_APPROVAL_AUTHORITY F 
					WHERE A.CINVC_NO=B.CINVC_NO
					AND A.AINVC_NO=B.AINVC_NO					
					AND A.FINAL_TO_WH=B.FINAL_TO_WH
					AND B.DEPT=C.APP_DEPT    
					AND B.DOC_CURR_APP_SEQ_NO=E.APP_FLOW_SEQ_NO
					AND B.RSP_CHANGE_IND IS NULL 
					AND C.APP_CODE=D.APP_CODE
					AND C.APP_CODE=1
					AND A.APPROVED_STATUS='N'
					AND E.DOC_TYPE='CPS'
					AND E.DOC_TYPE=F.DOC_TYPE
					AND E.APP_TYPE=F.APP_TYPE
				GROUP BY
					A.AINVC_NO,
					A.CINVC_NO,           
					A.AINVC_DT,
					A.FINAL_TO_WH,
					A.VOLUME 
				ORDER BY
					ROUND((SYSDATE-A.AINVC_DT),0) DESC)                                       
				GROUP BY  
				AINVC_NO,
				CINVC_NO,           
				AINVC_DT,
				FINAL_TO_WH,
				VOLUME,
				AGEING";			
				
	$result = oci_parse($xeconn,$query);
	oci_execute($result);
	
	while ($row =oci_fetch_array($result, OCI_ASSOC)) 
	{
		$accInvHead[] = array(
	    'AccInvoiceNo' => $row['AINVC_NO'],	 	
	    'CustomInvoiceNo' => $row['CINVC_NO'],		      	
		'AccInvoiceDate' => $row['AINVC_DT'],		
		'TerrCode' => $row['FINAL_TO_WH'],		
		'Volume' => $row['VOLUME'],
		'AiValue' => $row['AI_VALUE'],
		'Ageing' => $row['AGEING'],		
        );
	}
    $data[] = array(    
	   'Rows' => $accInvHead
	);
	echo json_encode($data);
}
?>

May 21, 2014 at 9:59 am in reply to: One master with two details grids One master with two details grids #54745

dippy

Participant

<?php
 #Include the connect.php file
 include(‘xe.php’);
 #Connect to the database
 //connection String

if ($xeconn == False){
 print “can’t find $database”;
 }
 // get data and store in a json array
 $query = “select * from cps_ainvc_head_test”;
if (isset($_GET['accinvoiceno']))
 {
 //$pagenum = $_GET['pagenum'];
 //$pagesize = $_GET['pagesize'];
 //$pagenum = 1;
 //$pagesize = 6;
 //$start = $pagenum * $pagesize;
 $query = “SELECT count(*) over () found_rows,Nvl(B.LINE_NO,0)LINE_NO,
 A.CINVC_NO,
 A.AINVC_NO AS AINVC_NO_DT,
 B.ITEM,
 Initcap(B.ITEM_DESC)ITEM_DESC,
 Round(Nvl(B.EST_UNIT_TERR_LND_CST,0),3)EST_UNIT_TERR_LND_CST,
 Nvl(B.SUG_INIT_PRICE,0)SUG_INIT_PRICE,
 Nvl(B.BUY_FINAL_RSP,0)BUY_FINAL_RSP,
 B.AVG_VAT_RATE,
 rownum rn
 FROM CPS_AINVC_HEAD_TEST A,
 CPS_AINVC_DETL_TEST B,
 DOC_APPROVER_MERCH_HIERARCHY C,
 DOC_APPROVERS D,
 DOC_APPROVER_LVL E,
 DOC_APPROVAL_AUTHORITY F
 WHERE A.CINVC_NO=B.CINVC_NO
 AND A.AINVC_NO=B.AINVC_NO
 AND A.AINVC_NO=’”.$_GET['accinvoiceno'].”‘
AND A.FINAL_TO_WH=B.FINAL_TO_WH
 AND B.DEPT=C.APP_DEPT
 AND B.DOC_CURR_APP_SEQ_NO=E.APP_FLOW_SEQ_NO
 AND B.RSP_CHANGE_IND IS NULL
 AND C.APP_CODE=D.APP_CODE
 AND C.APP_CODE=1
 AND E.DOC_TYPE=’CPS’
AND E.DOC_TYPE=F.DOC_TYPE
 AND E.APP_TYPE=F.APP_TYPE
 ORDER BY B.LINE_NO”;
 $result = oci_parse($xeconn,$query);
 //$sql = “SELECT count(*)found_rows from CPS_AINVC_DETL_TEST”;
 //$rows = oci_parse($xeconn,$sql);
 //$rows =oci_fetch_assoc($rows);
 //$total_rows = $rows['found_rows'];
 // get data and store in a json array
 while ($row =oci_fetch_array($result, OCI_ASSOC))
 {
 $accInvDetails[] = array(
‘LineNo’ => $row['LINE_NO'],
‘CustomInvoiceNo’ => $row['CINVC_NO'],
‘AccInvoiceNoDtl’ => $row['AINVC_NO_DT'],
‘ItemCode’ => $row['ITEM'],
‘ItemDesc’ => $row['ITEM_DESC'],
‘EstTerrLndCst’ => $row['EST_UNIT_TERR_LND_CST'],
‘SuggRSP’ => $row['SUG_INIT_PRICE'],
‘FinalRSP’ => $row['BUY_FINAL_RSP'],
‘VATPer’ => $row['AVG_VAT_RATE'],
 );
 }
 $data[] = array(
 // ‘TotalRows’ => $total_rows,
‘Rows’ => $accInvDetails
 );
 echo json_encode($data);
 }
 else
 {
 //$pagenum = $_GET['pagenum'];
 //$pagesize = $_GET['pagesize'];

//$pagenum = 1;
 //$pagesize = 6;

//$start = $pagenum * $pagesize;
 $query = “select count(*) over () found_rows,AINVC_NO,
 CINVC_NO,
 AINVC_DT,
 FINAL_TO_WH,
 VOLUME,
 SUM(AI_VALUE)AI_VALUE,
 AGEING
 from
 (SELECT A.AINVC_NO,
 A.CINVC_NO,
 A.AINVC_DT,
 A.FINAL_TO_WH,
 ROUND(A.VOLUME,2)VOLUME,
 ROUND(SUM(B.AI_ITEM_RATE*B.AI_QTY),0)AI_VALUE,
 ROUND((SYSDATE-A.AINVC_DT),0)AGEING
 FROM CPS_AINVC_HEAD_TEST A,
 CPS_AINVC_DETL_TEST B,
 DOC_APPROVER_MERCH_HIERARCHY C,
 DOC_APPROVERS D,
 DOC_APPROVER_LVL E,
 DOC_APPROVAL_AUTHORITY F
 WHERE A.CINVC_NO=B.CINVC_NO
 AND A.AINVC_NO=B.AINVC_NO
 AND A.FINAL_TO_WH=B.FINAL_TO_WH
 AND B.DEPT=C.APP_DEPT
 AND B.DOC_CURR_APP_SEQ_NO=E.APP_FLOW_SEQ_NO
 AND B.RSP_CHANGE_IND IS NULL
 AND C.APP_CODE=D.APP_CODE
 AND C.APP_CODE=1
 AND A.APPROVED_STATUS=’N’
AND E.DOC_TYPE=’CPS’
AND E.DOC_TYPE=F.DOC_TYPE
 AND E.APP_TYPE=F.APP_TYPE
 GROUP BY
 A.AINVC_NO,
 A.CINVC_NO,
 A.AINVC_DT,
 A.FINAL_TO_WH,
 A.VOLUME
 ORDER BY
 ROUND((SYSDATE-A.AINVC_DT),0) DESC)
 gROUP BY
– found_rows,
 AINVC_NO,
 CINVC_NO,
 AINVC_DT,
 FINAL_TO_WH,
 VOLUME,
 AGEING”;

//where rownum between $start and $pagesize
 //$query = “SELECT SQL_CALC_FOUND_ROWS * FROM customers LIMIT $start, $pagesize”;
 $result = oci_parse($xeconn,$query);
 oci_execute($result);
 //$sql = “SELECT count(*)found_rows from CPS_AINVC_HEAD_TEST”;
 //$rows = oci_parse($xeconn,$sql);
 //echo $sql;
 //oci_execute($rows);
 //$rows =oci_fetch_assoc($rows);

//$total_rows = $rows['FOUND_ROWS']; 

while ($row =oci_fetch_array($result, OCI_ASSOC)) {
 $accInvHead[] = array(
‘AccInvoiceNo’ => $row['AINVC_NO'],
‘CustomInvoiceNo’ => $row['CINVC_NO'],
‘AccInvoiceDate’ => $row['AINVC_DT'],
‘TerrCode’ => $row['FINAL_TO_WH'],
‘Volume’ => $row['VOLUME'],
‘AiValue’ => $row['AI_VALUE'],
‘Ageing’ => $row['AGEING'],
 );
 }
 $data[] = array(
 //’TotalRows’ => $total_rows,
‘Rows’ => $accInvHead
 );
 echo json_encode($data);
 }
 ?>

Author

Posts

Viewing 15 posts - 1 through 15 (of 22 total)

1 2 →