My Blog

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

Thursday, April 30, 2015

mysql using JOIN query by three table

mysql using JOIN query by three table :

     SELECT b.`booking_id`, r.`ud_room_id`,r.room_name, u.`name`, u.`contact_no`, u.`designation`, u.`department`, b.`title` , b.`booking_date` , DATE_FORMAT( b.`start_time` , '%H:%i' ) start_time, DATE_FORMAT( b.`end_time` , '%H:%i' ) end_time
    FROM `rbs_room_booking` b
    JOIN `rbs_room` r ON r.`room_id` = b.`room_id`
    JOIN `rbs_user` u ON u.`user_id` = b.`entered_by`
    WHERE b.`booking_date`='2015-04-30'

mysql delete query from 2 table

mysql delete query from 2 table :

DELETE rbs_room_booking , rbs_sc_user FROM rbs_room_booking INNER JOIN rbs_sc_user WHERE rbs_room_booking.booking_id= rbs_sc_user.booking_id AND rbs_room_booking.booking_id = '310'

mysql active status show as Active and Inactive

mysql active status show as Active and Inactive :

rbs_user this table active_status Coloumn Default=N

SELECT user_id,user_name,e_mail,designation,CASE WHEN active_status ='Y' THEN 'Active' ELSE 'Inactive' END activestatus FROM rbs_user

activestatus is allias name

java code:
public String userStatus(){

        System.out.println("kaniz");

        if(statusVal.equalsIgnoreCase("inactive")){
                status ="Y";
            } else {
                status ="N";
            }



        UsersSQL usersSQL = new UsersSQL();
        usersSQL.getUpdateTable(status,unikId); // use for update query


        //userDataList = usersSQL.selectUsersDate();// use for select query

        return "userStatus";

    }

Monday, March 30, 2015

mysql query write using join Not subQuery

mysql query write using join :

two query convert into one query using join

//1st query :
SELECT b.all_users_email,b.room_id FROM rbs_room_booking b WHERE b.booking_id = 277

SELECT b.all_users_email,b.room_id, r.ud_room_id, r.room_name, r.room_type,r.capacity
FROM rbs_room_booking b
JOIN rbs_room r ON r.room_id = b.room_id
WHERE booking_id = 277

//2nd query :
SELECT ud_room_id, room_name, room_type,capacity FROM rbs_room r WHERE room_id = 41