My Blog

Tuesday, June 9, 2015

Drug or sales pharma project Log in

public String successLogin(){
        int usrname = 0;

          boolean fg = true;
          con = dbc.connectDB();


           if (con == null) {
               fg = false;
           }



           if (fg) {
               try {

                   st = con.createStatement();
               String query = "SELECT USER_NAME,USER_ID,USER_PASS FROM UB_SYSTEM_USER WHERE USER_ID = '"+userId+"' AND USER_PASS = '"+userPass+"' AND ACTIVATION_FLAG = 1 ";
                   System.out.println(query);

                   ResultSet rs = st.executeQuery(query);

                 while (rs.next()) {
                      usrname = rs.getRow();
                  }


               } catch (SQLException sq) {
                    sq.printStackTrace();
                } finally {
                    try {
                        if (rs != null) {
                            rs.close();
                        }

                        con.close();
                    } catch (SQLException ex) {
                        ex.printStackTrace();
                    }
                }
                }





           if (usrname>0) {

               return "successLogin";
           }else{
            addFieldError("logMsg", "Invalid User ID or Password");
               return "notloginhomePage";
           }

    }

jsp page ::
<div style="color:#FF0000; ">
                                <s:fielderror>
                                    <s:param value="logMsg"/>
                                </s:fielderror>
</div>

java action class :
public class LoadAction extends ActionSupport {
// create method
}

struts2 configure :
<package name="web" extends="jasperreports-default, struts-default, json-default" namespace="/">
</package>

Drug Project need validation required

submit by form ::

<form id="confirmCustomerForm" style="margin: 0px;" action="saveCustomerDataInfoLoad.do">

    <div id="body_content" style="float:left; width:1000px; margin-top:9px;">
       <table width="100%" border="0" cellpadding="1" cellspacing="1" >
<tr>
    <td class="txtAllign">Request By ID :</td>
    <td colspan="4">
    <span><input name="regById" id="regById" type="text" value="" style="width:80px;" placeholder="id" onblur="showUserValue(this.id)" required /></span>    </td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign"> </td>
    <td> </td>
    <td> </td>
    <td class="txtAllign"> </td>
    <td><input name="areaExecId" id="areaExecId" type="hidden" value="" style=""/></td>
    <td> </td>
</tr>
<tr>
    <td width="13%" class="txtAllign">Name : </td>
    <td width="23%"><input name="name" id="name" type="text" value="" style="width:200px;" /></td>
    <td width="5%"> </td>
    <td width="11%" class="txtAllign">Area name :</td>
    <td width="24%"><input name="areaId" id="areaId" type="hidden" value="" style=""/>
    <input name="areaName" id="areaName" type="text" value="" style="width:200px;"/></td>
    <td width="24%"> </td>
</tr>
<tr>
    <td class="txtAllign">User id : </td>
    <td><input name="userId" id="userId" type="text" value="" style="width:200px;"/></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign">User pass : </td>
    <td><input name="userPass" id="userPass" type="text" value="" style="width:200px;"/></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign">Status : </td>
    <td>
    <select name="status" id="status" onChange="getStatusDetails(this);">
    <option value="S">Stop user</option>
    <option value="N">New user</option>
    <option value="R">Replace user</option>
    </select>    </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign" id="details_select">Stop Date</td>
    <td> <input name="statusWiseDate" id="statusWiseDate" type="text" placeholder="mm/dd/yyyy" required /></td>
    <td> </td>
    <td class="txtAllign">Previous name :</td>
     <td><span><input name="previousId" id="previousId" type="text" value="" style="width:50px;" placeholder="id" disabled="true"/> </span>
   <span><input name="previousName" id="previousName" type="text" value="" style="width:100px;" placeholder="previous name" disabled="true"/></span></td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign">Instruction by : </td>
   <td><span><input name="instructionBy" id="instructionBy" type="text" value="" style="width:50px;" placeholder="id" onblur="showInstructionBy(this.id);" required /> </span>
   <span><input name="instructionName" id="instructionName" type="text" value="" style="width:100px;" placeholder="name"/></span></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign">Designation : </td>
    <td><input name="designation" id="designation" type="text" value="" style="width:200px;"/></td>
    <td></td>
    <td class="txtAllign">Instruction Date : </td>
    <td><input name="dateWithTime" id="dateWithTime" type="text" placeholder="mm/dd/yyyy" required/></td>
    <td> </td>
</tr>
<tr>
    <td class="txtAllign">Remarks : </td>
    <td colspan="4"><textarea name="remarks" id="remarks"></textarea></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
</table>
    <table style="text-align:center; padding-left: 70px;">
    <tr >
         <td><input name="" type="submit" value="save" /></td>
         <td><input name="" type="reset" value="clear"/></td>
         <td><input name="" type="button" value="Exit" onclick="showExit();"/></td>
        <td>
            <a href="#mydiv" rel="facebox"><img src="Script//reportView.png"/></a>
        </td>
    </tr>
    </table>
    </div>
    </form>

Monday, June 8, 2015

json value return and show in success function

struts configure:
<struts>

<package name="web" extends="jasperreports-default, struts-default, json-default" namespace="/">
      <action name="*Gsn" class="com.drug.billing.userblock.action.GsnAction" method="{1}">
            <result type="json"></result>
      </action>
    </package>

</struts>

GsnAction.java ::
    private ExecutiveInfo userBlockInfo =new ExecutiveInfo();
    public String userValue(){//use json

        System.out.println("select ist blur user data :");
        UserBlockDao userBlockDao = new UserBlockDao();
        userBlockInfo = userBlockDao.getUserBlockInfoByRegById(regById);

        return Action.SUCCESS;

    }

need jar : gson-2.2.4.jar

<script type="text/javascript">
     function showUserValue(id){
        // alert("kaniz ");
        var regById = document.getElementById(id).value;
        // alert(regById);

        var ajaxURL = "userValueGsn.do?regById="+regById;

        $.ajax({
            async:false,
            url : ajaxURL,
            dataType:'json',
            success : function(result) {
                if(result.userBlockInfo!=null) {
                //alert("kf"+result.userBlockInfo.userId);
                $("#name").val(result.userBlockInfo.userId);

                $("#userId").val(result.userBlockInfo.userId);
                $("#userPass").val(result.userBlockInfo.userPass);
                $("#areaName").val(result.userBlockInfo.areaName);

                $("#areaExecId").val(result.userBlockInfo.areaExecId);
                $("#areaId").val(result.userBlockInfo.areaId);
                }
            },

        });
    }
</script>

Jasper font show as jar that put in Library folder

error type below without jasper font jar :

search :: ( how to install new fonts in jasperreports )
http://www.qualogy.sr/adding-fonts-to-jasper-reports-integration/
http://stackoverflow.com/questions/14831465/how-to-install-new-fonts-in-jasperreports

Adding fonts to Jasper Reports Integration

Read more at:

Monday, May 18, 2015

Modal show using bootstrap 3.3.2

<section class="content">

<div class="col-md-7">
<div class="modal-content cursor-pointer" data-toggle="modal" data-target="#modal-1">
<a href="#" > Click me ! Show Modal </a>
</div>
</div>

<div class="col-md-7">
    <img class="img-modal img-responsive cursor-pointer" data-toggle="modal" data-target="#modal-1" src="www" alt="image">
</div>

<div class="row">
   
<div class="modal fade top-space-0" id="modal-1" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content cursor-pointer" data-toggle="modal" data-target="#modal-1">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="#modal-1">CLOSE ×</button>
                <h1 class="modal-title">Modal Title</h1>
            </div>

            <div class="modal-body">
                <div class="img-center">
                    <img class="img-modal img-responsive" src="wwww" alt="image">
                </div>
            </div>

            <div class="modal-footer">
                <a ="#" class="btn btn-default" data-dismiss="modal">Close</a>
            </div>
        </div>
    </div>
</div>

</div>
</section>

Modal call bootstrap

<div class="row">
        <div class="metro-nav-block nav-block-blue">
            <a data-original-title="" href="#">
                <i class="icon-stethoscope"></i>
                <div class="info">+897</div>
                <div class="status">
                <div style="width:150px;" class="span4 proj-div" data-toggle="modal" data-target="#TRGSCCModal">Test Result</div>
                </div>
            </a>
        </div>
</div>
Now page is according to href link:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<div id="IPDGSCCModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">× </button>
                        <h4 class="modal-title" id="myModalLabel">IPD Request List</h4>
                    </div>
                    <div class="modal-body">
                        ...IPD Request
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                        <button type="button" class="btn btn-primary">Save changes</button>
                    </div>
                    </div>
                </div>
                </div>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

using script :
<script>
   function addRoomFrmmeetingRoomFunc(){ //Start Modal Meeting Room *********
        var ajaxURL = "addRoomFrmmeetingRoomModalMra.do";
        $.ajax({
            async:false,
            url : ajaxURL,
            success : function(result) {
                $("#addRoomAzax_modalPage").html(result);
            },
            complete:function(){
                $("#ARGSCCModal").modal({
                    backdrop:'static',
                    show:true
                });
                //dataTableInitializeMeetingRoomGP();
            }

        });
    }
</script>

<div id="ARGSCCModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" style="width:500px;left:650px;">
<div class="modal-dialog">
    <div id="addRoomAzax_modalPage" class="modal-content" style="width:500px;left:650px;">

    </div>
</div>
</div>

Saturday, May 9, 2015

parse int ( getFst=parseInt(10.30); )

      For float number validation ::

      var getFst = document.getElementById('onestartTime').value;
             var getSnd = document.getElementById('twostartTime').value;

             getFst=parseInt(getFst);

             getSnd=parseInt(getSnd);

            if(getFst==getSnd || getFst>getSnd){

                 alert("start time must be smaller than endtime");
                 return false;

             }

Example:
here , getFst=10.00
getSnd=10.15