Leadership

To become a great leader, its always necessary to face defeat.

Get Realtime Date and Time

During the development of my project, I wanted to get the RealTime date and time to user. Code is as under: var myVar=setInterval(function () {showTime()}, 1000); var counter = 0; function showTime() { var date = new Date(); document.getElementById("time").innerHTML = date; span id="time" Time is most powerful thing. Regards Deepak Pandey

Creation of System Parameter/Variables

Application gives you the power to variables/parameters as per your choice. By default, application has System Parameter with id as 1. Remaining can be set up as per choice. Regards Deepak Pandey

Micro Level User Role Management

In application, it has been taken care that clients are able to manage access of application to user level. We are maintaining view at 2 levels > User Group Level : It has permission for application access and assigned to user. > Application Access at User Level: Access level can be modified at user level. With regards Deepak Pandey (Bug Tracking System, Office Automation, Project Management System, Task Activity, Graphs)

User Registration

User Can Simply register themselves by using a simple form and they can start. With regards (Deepak Pandey)

Bug Tracking System

Friends, I am introducing Web Application with below mentioned Key feature: 1- Project Management System 2- N Level Maintenance for Location, Role, Module and Task 3- User Wise Application Control 4- Tracking of Bugs 5- Tracking of Task Status 6- Interactive Graphs ......Continued Further, I will host it soon and help you to manage your project in a minute. With Regards Deepak Pandey

Read value from properties file

To get the value of database connection or fetch labels for JSP, it is better to use properties file. So that if you change at one place, it will be reflected to all places. Code to read properties file and return value import java.io.IOException; import java.io.InputStream; import java.util.Properties; public class ReadLabelProperties { public static String getProperties(String key) throws IOException { InputStream inputStream=ReadLabelProperties.class.getClassLoader().getResourceAsStream("label.properties"); Properties myproperties = new Properties(); myproperties.load(inputStream); return myproperties.getProperty(key); } } label.properties are having entries like below dbserver=jdbc:mysql://localhost:3306/ dbdriver=com.mysql.jdbc.Driver Hope the same is useful while creating web application Deepak

Web Application

After a long time, I got chance to design a web application: Dynamic web application, using JSP and Servlet -Download Java (JDK and JRE) and install -Download Eclipse IDE and install -Download Tomcat and install -Download MySql and install - File - Download - Dynamic Web Project Give Project Name-(Next)-src-(Next)-Click on web.xml (deployment descriptor) web.xml: (file would be like this WebApp1 login.jsp Login LoginServlet LoginServlet /login/* - login.jsp

First Web Application

Login Name
Password

-loginBean.jsp Class: 1- LoginBean public class LoginBean { String userName=""; String password=""; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }2- LoginServlet import javax.servlet.annotation.WebServlet; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import javax.sql.*; import java.sql.*; /** * Servlet implementation class Login */ @WebServlet("/Login") public class Login extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public Login() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.getWriter().append("Server at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //doGet(request, response); response.setContentType("text/html"); PrintWriter out = response.getWriter(); String username=request.getParameter("username").toString(); String userpass=request.getParameter("password").toString(); HttpSession session = request.getSession(true); if(username.equalsIgnoreCase(userpass)) { response.sendRedirect("welcome.jsp"); } else { response.sendRedirect("login.jsp"); } } catch (Exception e) { e.printStackTrace(); } } } - Select Project-Run on Server

Suggestion:When anyone defaults in PSB's repayment, restrictions can be put to utilize the benefit of government schemes(subsidy/(ies), pension, Ayushman...). So that defaulted borrower may not be able to use public funds twice (PSBs loan+ GOI Welfare funds).Since GOI is putting efforts for a better life of people by way of collateral free loans like Mudra, Stand up, small KCC etc. There is a thin line of willful/ actual default, hence there would be something which may motivate the citizens for loan repayment. GoI may relase the restricted funds during default once he repays the loan. https://twitter.com/DeepakP89467637

पुलवामा के सभी शहीदों को शत् शत् नमन

Discontinuation of LoU/Buyer's Credit

The Reserve Bank of India has decided in the month of March-2018 to discontinue issuance of letters of undertaking (LoU) and letters of comfort (LoC) for trade credit for imports into India. Authorised dealer-1 (AD-1) category banks will not be allowed to issue LoCs and LoUs for this line of business, the regulator said in a notification on its website. Banks may continue to issue letters of credit and bank guarantees for trade credit for imports into India as per the current guidelines applicable, the notification added.This is part of a series of moves from the RBI after details of the Nirav Modi scam came to light. In the case, Nirav Modi’s associates approached the domestic branch of Punjab National Bank to issue fraudulent LoUs to foreign branches of other Indian banks through the SWIFT network. These LoUs were not registered in the core banking system for PNB. This means that the bank was virtually unaware of any such transactions taking place. The difference between these products is that LoUs and LoCs were issued by domestic banks at the behest of the importer. The importer would negotiate the right price for these loans from the foreign branches of other Indian banks and then get these letters issued by a domestic bank. The exporter, or seller, would be paid from the nostro account.In the case of letters of credit and bank guarantees, domestic banks issue these in favour of the exporter, or seller’s, bank. Typically in these transactions, the seller would take the foreign exchange cost and would build that into the price of the product. LoUs in itself were a good product and the fraud at PNB was more of a systemic issue. Banking industry is having inherent risk like other segments. Hence Govt/RBI/Banks are required to ensure that transaction happening through any window is genuine rather than closing the window for always. Domestic buyer has to arrange for rupee or foreign currency funds to make the payment on the due date which actually was going to take place after 1 or 3 year.It would not only increase liquidity problems to domestic players but would come with other problems also.

EDPMS: Export Data Processing and Monitoring System RBI has directed AD Category-I Banks to update the EDPMS with data of export proceeds on “as and when realised basis” and, with effect from October 16, 2017 generate Electronic Bank Realisation Certificate (eBRC) only from the data available in EDPMS, to ensure consistency of data in EDPMS and consolidated eBRC. Nice initiatives taken by RBI to monitor export related information on real time basis. Here we need to understand the EDPMS data. There are 2 legs mainly: 1)- Shipping bill is being generated by customs. 2)- That shipping bill is being transferred to RBI EDPMS data. If there is any issue in data related with shipping bill, Exporter need to contact the custom for taking corrective action.For example, that shipping bill status is LEO Cancelled or the same was sample bill and exporter did not submit GR waiver. There may be other cases also. In 2nd case, banks handling the documents need to clear the GR with received payments/ as per RBI guidleines WOFF, extension etc whatever is possible. As observed by me, at present, bills are appearing due to below mentioned reasons: > BRCs has been generated while it is showing pending.: In this, first check the AD code bills appearing in Shipping Bills, and if AD code of other Bank is appearing, transfer the same in your AD and clear the entry with the help of data center or whatever the process is there. Particular in this case, Banks are more responsible to clear the entries as payment has already been received.\ > LEO Cancelled/SAMPLE BILLS (Where GR waiver was not taken): In such case, one of the solution is to make necessary correction at customs and clear the same entry. > In case of non receipt of payment/any other technical reason: Follow the master circular of Export of goods and services dated 01.01.2016 updated on 12.05.2016 for taking corrective action. Basically where payment has been received, Banks who handled the documents has to be more proactive to clear the bills. Above are illustrative and based on while working on EDPMS.

Working in office on holidays/Late Hours.

Working in office on holidays. It seems that bank officials wait for holidays to finish the important tasks. During the 6 year in Bank's service, i worked in various offices/branches and find that whenever there is a long holiday (between 2 to 4 days), management always have some important works and passes the orders to open the office to finish this task. In my view, there may be only below mentioned reasons which I find if any task does not finish on deadlines: > Due to over burden work on staff: Bank may recruit the staff as per their requirement to address the issue. > Staff is not enough to motivate: Consult with reporting authority and make proper counseling. If even after enough counseling, staff does not improve, take stern action as per rules. >Unskilled staff: In such case, either Bank may provide proper training or on the job training, reporting authority (BOSS) either to guide them properly or assign the task according to their skills with a patience. There may be other reason, but i find these reasons more valid. Due to the continuous working in office on holidays/late hours, it is going to only decrease the efficiency and demotivation in major of staff after a certain period . As such condition is not going to work in a long run and would not be able to run a long show.I think that Banks need to address such HR issues appropriately to ensure a more productive working environment at their earliest.

BANK FRAUD MERGER BIPERTIE

As of now everyone is aware about the position of Banking Sector and after the case of NIRAV MODI, everyone is advising PSUs for improvement in working even though they do not know the even ABCD of Bank. Anyway, the only banking industry is responsible for the same due to adopted wrong practices for gaining the short term benifits. I always fail to understand: What is the purpose of Loan Mela. If PSUs would improve their services basically IT enabled services and would focus to reduce TAT for services would more than enough for growth. What happens in Loan Mela is known to everyone. I have never seen the person who defaults is in trouble, its always a banker who has all the worry to ensure the account as standard. Unfortunately, i have also become the part of such worry. There must be a worry to borrower for repayment not the Banker. Since bankers are not GOD or superhuman who will read the intention of borrower while sanctioning loans. They go by the paper and their experience and if finds correct, they go ahead. It is the borrower who has no will to repay the loans due to obvious reasons and RIN MAFI Schemes are one of them. In place of RIN MAFI, there should be other way to help the needy people. As RIN MAAFI always hurts the honest people and developing the tendency of default or make RIN MAFI to all including who paid well in time. Fraud: Today it seems that account turning into NPA is being called as a FRAUD particularly after the case of NIRAV MODI, but that is not right at all. As explained, account turns into NPA when borrower does not pay and sanctioning after the following norms, just due to bad intent of borrower, banks cant be responsible. Fraud may be called where bank's did not comply the guidelines properly and ignored the same due to malafide intention/ give specific benifits to individual.

Trade Credit

As everybody is aware, in any trade transaction, there will be two parties 1- Buyer and 2-Seller In a trade transaction following are type of payment and risk. Type of Payment and Risk: Advance: Seller has no risk while Buyer has to rely on seller (100%). Open A/C: Seller has to rely on buyer while buyer has no risk. D/P Collection:Seller has a risk of non payment of draft while buyer has to depend on seller to supply of goods ordered. Assurance of shipment would be there. D/A Collection: Seller has more risk as non payment of bill of exchange, even though Buyer has the mechandise. While Buyer has minimal risk and may refuse to pay at maturity. Sight L/C:Seller has minimum risk as issuing/conforming bank's obligation to pay if documents conform to lc while buyer has assurance of shipment, but depends on seller to supply goods ordered. Usance L/C:Seller has minimum risk as issuing/conforming bank's obligation to pay if documents conform to lc while buyer has to pay at maturity regardless of product quality. Above are only illustrative purpose only.

Mysql workbench

MySQL workbench:

To download mysql work bench .Click here

Recently i got chance to work on database. and my assignment was to create database and ER diagram. And to complete this assignment, i used MySQL workbench.

About MySQL Workbench

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench is available as a native GUI tool on Windows, Linux and OS X in different editions. See the following link for more information about the editions available.

If you are familier with other gui tools like MySQL query browser and mysql administrator, both features are available in workbench. Other is data modeling, there you can create ER diagram.
Three parts of MySQL workbench:

1) SQL development: You can run your database query. very similar to mysql query browser.

2) Data Modeling: You can create ER diagram.

3)Server: very similar to mysql administrator browser. You acan create backup and restore of your database script.

I installed on windows 7 and vista. It was creating problems in XP. Error was .netframework, i tried but did not complete it.

Thanks
Deepak

Firbug

Firebug:

To download the firbug development tool:
http://getfirebug.com/

Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Features:
Inspect HTML and modify style and layout in real-time: After installing or adding plug-in of firebug, see at the bottom of, an icon image (a worm image), click here,
Use the most advanced JavaScript debugger available for any browser
Accurately analyze network usage and performance

Some very helpful shortcuts and commands when working with firebug. Thanks to Duvet-Dayez for creating this cheat sheet.

Firebug cheat sheet

Deepak

Internationalization in GWT

In my last assignment, i got good assignments on GWT like internationalization, history implementation and maintenance of log.
They are easy, but while you are doing these thing first time specially in GWT,then it is not a simple nut.

So i would like to discuss internationalization here.

First create GWT project. (Here i am creating project name: UsePropertyScreen)

Create 2 interface and 2 properties file with same name like PropertConstant.java and PropertyMessage.java and property files with PropertyConstant.properties and PropertyMessage.properties.

Code for PropertConstant.java
package deepak;
import com.google.gwt.i18n.client.Constants;
public interface PropertConstant extends Constants {

String hello();
//Add more key values here
}

Code for PropertyMessage.java

package deepak;
import com.google.gwt.i18n.client.Messages;
public interface PropertyMessage extends Messages {

String alertMessage();
String alertParameter(String arg);
}

Now Make entries in .property file also. Please provide same key as you gave in java file. i.e function name in java =key value in properties

PropertyConstant.properties
hello=Hello Deepak

PropertyMessage.java
alertMessage=Hello deepak!, welcome
alertParameter= Hello {0}

So if you want to pass more parameter, define function with parameter and in property file use {0} for first parameter and {1} for second parameter etc

Now make samall change in UsePropertyScreen.gwt.xml.file

<inherits name="com.google.gwt.i18n.I18N">

<extend-property name="locale" values="PropertyMessage">

And now use these key value inside client side file. It can't be used server side files.

Screen.java
package deepak;

import com.google.gwt.user.client.ui.RootPanel;
import com.google.gwt.user.client.ui.VerticalPanel;
import com.gwtext.client.widgets.MessageBox;

public class UsePropertyScreen implements {
private final PropertyMessage message=GWT.create(PropertMessage.class);
private final PropertyConstant constant=GWT.create(PropertConstant.class);
public UsePropertyScreen(){
MessageBox.alert(constant.hello());
MessageBOx.alert(message.alertMessage());
MessageBOx.alert(message.alertParameter("Deepak Pandey"));

RootPanel.get().add(new Label(constant.hello()));

}

}

Now run this application.

YOu will get 3 alert,
First with : "Hello Deepak"
Second with : "Hello Deepak!, welcome"
Third with : Hello Deepak Pandey

By default it will take above files. But if you want to change propert file according to your language. Create property file in following manner:
PropertyMessage_hi.properties
and select Hindi language or use hi in url address. So you are able to identify.
and change in UsePropertyScreen.gwt.xml,
<extend-property name="locale" values="hi">

cheers!

Google Web Toolkit: Jar not loaded

When a Google Web Toolkit (GWT) web application is deployed to Tomcat web server,
you may encounter a warning message as follows.
org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(<$webAppsFolder$>\WEB-INF\lib\gwt-user.jar) - jar not loaded.
See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class

This raises just because WebappClassLoader has loaded the servlet.jar already. The gwt-user.jar already contain the content of the servlet.jar file. Even though this message can be ignored, this warning message can be avoided just by replacing the gwt-user.jar file with gwt-servlet.jar (which comes with Google Web Toolkit (GWT) download).

gwt-servlet.jar has been created by removing the content of the servlet.jar from the gwt-user.jar, so this change will not have any impact on your project.

Rs symol

Hello friends,

Indian rupee had got its sign like $ etc. and i hope that currency will receive greater international recognition with the launch of a new symbol for the currency.


Following is the link from where you can download Foradian.ttf font.
http://blog.foradian.com/

After downloading,paste fordian.ttf into control panel-->Font folder.
Now select font Rupee foradian in your document.
And use (~) key just below the Esc key.

Image of symbol:



Feel proud to be an Indian.
"Sare jahan se achha Hindostan hamara"