Posts

Showing posts from January, 2017

Excel PDF CSV Export for jQuery Datatable

Image
The Jquery Data-table has PDF ,CSV ,Excel support which  reduce lot of cording by integrating other open source libraries .  https://datatables.net/extensions/buttons/examples/initialisation/export.html Here I have indicated step by step guide for the integration . Step 1 . JS Imports  dataTables.buttons.min.js  //Provided in \DataTables-1.10.13\extensions\Buttons buttons.flash.min.js            //Provided in \DataTables-1.10.13\extensions\Buttons buttons.html5.min.js          //Provided in \DataTables-1.10.13\extensions\Buttons buttons.print.min.js           //Provided in \DataTables-1.10.13\extensions\Buttons jszip.min.js                       //Please download from http://stuk.github.io/jszip/ pdfmake.min.js                //Please Download from https://github.com/bpampuch/pdfmake vfs_fonts.js                     //Please Download from https://github.com/bpampuch/pdfmake CSS imports  buttons.dataTables.min.css          //Provided in \DataTables-1.10.13\exten

DataTables warning: table id=table - Cannot reinitialise DataTable. For more information about this error,

I have gone trough following error number of time when I'm using Jquery Data table. DataTables warning: table id=table - Cannot reinitialise DataTable. For more information about this error,  I have a combo box in the page which lead re bind the Jquary Datatable ,while  table is already bind with data. Flowing solutions are possible to resolve the issue. Destroy the table before re bind it . $("#table").dataTable().fnDestroy();  If condition                                    if ( $.fn.dataTable.isDataTable('#table') ) { table = $('#table').DataTable(); } else { table = $('#table').DataTable( { } );

jQuery Datatable with the ajax Json String

Image
You  can integrate  jQuery Datatable with the ajax source in following way. Download Realse Packages  https://datatables.net/download/ Import JS and CSS <script src="public/js/jquery.dataTables.min.js" type="text/javascript"></script>  <link href="public/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css"/> HTML    <div class="col-md-12 table-responsive">                        <!-- <table id="table" class="table  table-bordered table-striped ">-->    <table id="table" class="table table-striped table-hover dt-responsive display nowrap" width="100%" cellspacing="0" >                             <thead>                                 <tr>                                                   <th> Id</th>                                             <th>Na

Oracle SQL Developer 'Enter value for action:'

Image
I have given the following prompt message in SQL Developer wile executing quarries like below Insert into MENU (MENUID,MENUNAME,MENULINK)  values  (64,'Add - e','index.php?controller= product & action=changePage') ; The for the prompt message is & sign indicated which expect a value as a parameter.  This will tell the story : https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:4549764300346084350  In Order Bypass the prompt  you need to indicate   set define off at the beginning of the code.

Create Radio Button Group - PHP

In here you can crate a radio button  group dynamically. I have used the Array List Object which has the ID and FULL_NAME columan. <?php $i=0; foreach ($this->approverList as $key => $category) { if($i==0){ echo("<input type='radio'  . name='Group' value='" . $category->ID . "' checked>" . $category->FULL_NAME . " <br>"); }else{ echo("<input type='radio'  name='Group' value='" . $category->ID . "'>" . $category->FULL_NAME . " <br>"); } $i++; } ?> In order to set the Checked value dynamically .Use the following method. <input disabled type="radio" name="carrytype"  value="EMPLOYEE" <?php echo ([DBValue From Object]=='EMPLOYEE' ? 'checked' : '');?> > Employee                     

JQuery Time Picker

Image
This is a good Easy Time  picker Given By  http://timepicker.co/# Interrogate With your Page :  Need To Download Following Files : https://github.com/wvega/timepicker/releases   https://cdnjs.cloudflare.com/ajax/libs/timepicker/1.3.5/jquery.timepicker.min.css https://cdnjs.cloudflare.com/ajax/libs/timepicker/1.3.5/jquery.timepicker.min.js Header Section :   Load two Files  <script src="public/js/jquery.timepicker.min.js" type="text/javascript"></script>  <link href="public/css/jquery.timepicker.min.css" rel="stylesheet" type="text/css"/> Page  : HTML:  <div class="col-md-2 col-sm-6 col-xs-8" >                            <div class='input-group date' id='divtimeFrom' value="" >                                     <input type='text' class="form-control" id="timeFrom" name="