Friday, December 20, 2013

ADF - Calculate accumulative value of a Column in a Table

In this post I tried to show how to calculate the accumulative value of salary column in Employee table of oracle HR schema for example, where you can use it in specific scenario
As shown in the images below, Having  AccumulativeSalary transient attribute which it's value represent the sum of salaries of above rows.
1. add transient attribute and generate Employee ViewObjectImpl and ViewObjectRowImp
2.write the following code of get method of AccumulativeSalary transient attribute as the following:-
    /**
     * Gets the attribute value for the calculated attribute AccumulativeSalary.
     * @return the AccumulativeSalary
     */
    public Number getAccumulativeSalary() {
        if (getAttributeInternal(ACCUMULATIVESALARY) == null) {
            EmployeesViewImpl empVo = (EmployeesViewImpl)getViewObject();
//create separate RowSetIterator  of employee viewObject where you can iterate
            RowSetIterator rsi = empVo.createRowSetIterator(null);
            Number temp = getSalary();
            while (rsi.hasNext()) {
                EmployeesViewRowImpl r = (EmployeesViewRowImpl)rsi.next();
                if (r == this) {
                    setAttributeInternal(ACCUMULATIVESALARY, temp);
                    break;
                } else {
                    temp = temp.add(r.getSalary());                        
                }
            }            
            return temp;  
        }
        return (Number)getAttributeInternal(ACCUMULATIVESALARY);
    }
The JDeveloper 11.1.1.7.0 workspace of the sample application can be downloaded from here

Sunday, November 3, 2013

ADF Tree based on self join case, 3 functionality.(drag & drop, delete & move children, delete & delete multiple level children)

In this post I tried to show 3 operation for ADF tree using simple solution.   the drag and drop , delete node and move it's children to up level and delete node and delete multiple level children. 
the drag and drop
As shown in the images below, Having a two level tree. Expanding a node will make all detail nodes appear. drag  node from one level and drop him to another.


In the Model project we just need the  view objects  should be updatable connected with a viewLink based on common attribute ParentId. In the view object we need a bind variable which we also add to the query so that we can execute-with-params.



About delete and node and move it's children node to level up 
through application module method I get select node and update its children parent value by the value of selected root node parent value then delete value
About  delete node and delete multiple level children
  I used the power of sql to get all children for selected root node though customize the query of another updatable view object get multi level children, In the view object we need a bind variable which we also add to the query so that we can execute-with-params
And through application module method I get selected node and delete its multi level children then delete root node


The JDeveloper 11.1.1.7.0 workspace of the sample application and script file for this post can be downloaded from here

Thursday, October 31, 2013

Reorder rows in an ADF table

Reorder rows in an ADF table. As shown in the images below, applying the code in this post will allow you to re-arrange rows within a table using "up and down" buttons Its simply and change rank attribute value of swiped rows and change in the indexing of the iterator. 


Selecting a row and move it to a step up or down ,then will  show it in its new position within the table
and you may commit later


Note that reordering the rows in the table will only have an effect to the DCIteratorBinding (more precise, its an effect to the RowSetIterator it decorates) in the Pagedef file. 

Managed Bean

    /**  The selected row takes the position of the previous row.
     *   synchronize the underlying ADF model I needed to accept a
     *   "flicker" of the table after the action *
     *   @param actionEvent Event passed in from ADF Faces at the end of the action
     *  */

    public void upButton(ActionEvent actionEvent) {
        // Add event code here...
        Row currentRow;
        Row previousRow;
        currentRow =
                ADFUtils.findIterator("TreeTableView1Iterator").getCurrentRow();

        Number tRank = new Number();
        try {
            tRank = (Number)currentRow.getAttribute("Rank");
        } catch (Exception e) {
        }

        if (ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().hasPrevious()) {
            previousRow =
                    ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().previous();

            currentRow.setAttribute("Rank", previousRow.getAttribute("Rank"));
            previousRow.setAttribute("Rank", tRank);
            int indexOfPreviousRow =                ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().getRangeIndexOf(previousRow);
            //remove selected row from collection so it can be added back
            currentRow.removeAndRetain();
            ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().insertRowAtRangeIndex(indexOfPreviousRow,currentRow);
            //make row current in ADF iterator.
            ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().setCurrentRowAtRangeIndex(indexOfPreviousRow);

        }
    }

    /**  The selected row takes the position of the next row.
     *   synchronize the underlying ADF model I needed to accept a
     *   "flicker" of the table after the action *
     *   @param actionEvent Event passed in from ADF Faces at the end of the action
     *  */

    public void downButton(ActionEvent actionEvent) {
        Row currentRow;
        Row nextRow;
        currentRow =
                ADFUtils.findIterator("TreeTableView1Iterator").getCurrentRow();
        System.out.println(currentRow.getAttribute("Rank"));
        Number tRank = new Number();
        try {
            tRank = (Number)currentRow.getAttribute("Rank");
        } catch (Exception e) {
        }

        if (ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().hasNext()) {
            nextRow =
                    ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().next();

            currentRow.setAttribute("Rank", nextRow.getAttribute("Rank"));
            nextRow.setAttribute("Rank", tRank);
            int indexOfSelectedRow =
                ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().getRangeIndexOf(currentRow);
            //remove  selected row from collection so it can be added back
            nextRow.removeAndRetain();
            ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().insertRowAtRangeIndex(indexOfSelectedRow, nextRow);
            //make row current in ADF iterator.
            ADFUtils.findIterator("TreeTableView1Iterator").getViewObject().setCurrentRowAtRangeIndex(indexOfSelectedRow + 1);

        }
    }

The JDeveloper 11.1.1.7.0 workspace of the sample application and script file for this post can be downloaded from here

Thursday, June 2, 2011

Generate dynamic report in ADF App

DynamicJasperReport fusion web sample application implemented using JDeveloper 11.1.1.5.0 and built on HR schema included Jasper and DynamicJasper lib can be downloaded from HERE.

This example show you how to use DynamicJasper in ADF application, it help you to design, build and export as pdf your jasper report at run time.

You may use it in application which you let end user to add some properties for element in run time to generate it’s report without redeployment, where you can display different metadata and data each time you run it

DynamicJasper (DJ) is an open source free library that hides the complexity of Jasper Reports, it helps developers to save time when designing simple/medium complexity reports generating the layout of the report elements automatically.

DJ creates reports dynamically, defining at runtime the columns, column width (auto width), groups, variables, fonts, charts, crosstabs, sub reports (that can also be dynamic), page size and everything else that you can define at design time

For more information about DynamicJasper

Regards

Karim Hasan

Sunday, June 27, 2010

Defining LOV on Transient attribute and hide foregin key by PL/SQL helper method (ADF Jdev11g)

As mention in Andrejus Baranovskis's blog Defining LOV on reference attribute ,its quite common requirement to have reference attribute shown in LOV, and not its code. I used another way to achieve this by Transient attribute and Pl/Sql helper method and hope it is useful,
Download sample application from Here , sample use Jdev11g ps3 and HR schema
and create PL/Sql Method to get department name as follow
FUNCTION get_DepartmentName(dept NUMBER) RETURN varchar2 as
cursor crs is
select department_name from departments where department_id=dept;
begin
for i in crs loop
return i.department_name;
end loop;
return null;
end;

1. adding transient attribute and make it always updatable and mark "Mapped to Column or SQL" and "Selected in Query" check box ,then write your Pl/SQL method call in the expression section below to be selected in your view object query, to ensure that it will be retrive the department name in browsing mode


2. create LOV on your transient attribute which retrive department_name and department_Id



Monday, February 8, 2010

Handle Soft Delete using Custom Properties (Jdev11g ADF)

I read Generic Handle softdelete At husain dalal's blog and I would like to show another way to handle soft delete using custom property for DeletedFlag attribute using custom properties,
You will notice that DeletedFlag attribute type is Date where it will be entered as new Date("0001-01-01") in Insert operation and will set as system date in delete operation where it will be more better to know the date of delete operation


Now,
1. Create a new Fusion ADF Application and add a new java class that extends oracle.jbo.server.EntityImpl
2. In the CustomEntityImpl override the following methods:
a. remove() - To set the value of column with custom property(DeletedFlag,”YES”) to deleted value.
b. doDML() - During delete, to force an entity object to be updated instead of deleted. And during insert to default the value of column with custom property(DeletedFlag,”YES”) to new Date("0001-01-01").
public int getSoftDeletedColumn() {
int colIndex = -1;
for (AttributeDef def : getEntityDef().getAttributeDefs()) {
if (((AttributeDefImpl)def).getProperty("DeletedFlag") == "YES") {

colIndex = def.getIndex();
}

}
return colIndex;

}

@Override
public void remove() {
int deleteCol = getSoftDeletedColumn();
if (deleteCol != -1) {
setAttribute(deleteCol,
new Date(new Timestamp(System.currentTimeMillis())));
}

super.remove();
}

@Override
protected void doDML(int operation, TransactionEvent transactionEvent) {
int deleteCol = getSoftDeletedColumn();
if (EntityImpl.DML_DELETE == operation && deleteCol != -1) {
operation = DML_UPDATE;
}
if (EntityImpl.DML_INSERT == operation && deleteCol != -1) {

setAttribute(deleteCol, new Date("0001-01-01"));
}
super.doDML(operation, transactionEvent);

}
3. In the Application Navigator, double-click the entity you want to edit.
4. In the overview editor, click the Attributes navigation tab, and double-click the attribute you want to edit.
5. In the Edit Attribute dialog, then click the Custom Properties node add new property of
Name=DeletedFlag, value =YES then add



Download workspace from here but don't forget to generate example table

Thursday, February 4, 2010

Quick translation using GoogleTalk

if you want get quick translation from Arabic to English add this friend to your GoogleTalk friend list
ar2en@bot.talk.google.com
and
if you want get quick translation from English to Arabic add this friend to your GoogleTalk friend list
en2ar@bot.talk.google.com

then chat with
you can change locale letters for different language