Posts

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="

Heroku Postgres Database Backup

Image
Hi I have Heroku ,And I face lot of problems in upgrading the models based on the changes . http://www.panhidhalyrics.com/ Based on lot of discussions  the migrations of Heroku ,  doing in local and apply them in the remote after pushing not gives me the expected outcome. Rather application ends up in  errors. 1. $ heroku run python manage.py makemigrations panhidhaapp 2. Push the changes to git   3.  $ heroku run python manage.py migrate The other thing we can do it  we change the Model and apply the change in the DB manually trough PgAdmin Frist you need to login and get the db Cardinals https://id.heroku.com/login Navigate to the following location Application >> Addons >> Heroku Postgres :: -- >> Overview Section Open PgAdmin and  give the detail as it is .The value in the database will be given to the maintenance db in pgAdmin.   After login you have to navigate to your own database which does not indicated the access restriction by cros