Wednesday, 25 April 2018

Update Column With Random predefined word list in PostgreSQL


   Update Column With Random  enum word list in PostgreSQL ?
   How to Update Column With Random word ?

    UPDATE stock
    SET shape = (
              (
               ARRAY['CS','CM','RN','EM','AS','PR','OV','HT','BG','Round','MQ','PC']
              )          [floor(random()*12)+1]
           );

Update Date Column With RANDOM date in PostgreSQL



Random Dates and Numbers in PostgreSQL with the RANDOM() Function



select NOW() + (random() * (NOW()+'90 days' - NOW())) + '30 days';

UPDATE stock SET trans_date = NOW() + (random() * (NOW()+'90 days' - NOW())) + '30 days';



Monday, 23 April 2018

How to Flush/Clean DNS cache in Ubuntu 16.04



In Windows, we useipconfig /flushdnsin Ubuntu 16.04  run this command to flush dns cache:
sudo /etc/init.d/dns-clean restart

or use:

sudo /etc/init.d/networking force-reload


Friday, 13 April 2018

SURAT: India's first district cooperative bank built on the green concept

 SURAT: India's first district cooperative bank built on the green concept will be inaugurated in the diamond city by Chief Minister Vijay Rupani on Friday
Established in 1909, the 109-year-old Surat district cooperative bank  has become the first among the 370 district banks in India and 18 district banks in Gujarat for constructing its new headquarter in the diamond city’s Majura Gate on the green building concept. Constructed on 45,000 square feet, the bank took just 15 months for completition at the cost of Rs 34 crore.


The terrace of the district bank is installed with rooftop solar plant for generating 36 kilowatts of electricity for its in-house needs. The solar panels have been so designed that the electricity requirements would be met even during the monsoon season.

The five-storey bank building has green patches for gardening at each of the floors. The entry of the building has a green landscape with lush garden for providing a different feeling to the customers visiting the bank. Each floor has the facility of toilets and reception, mineral RO plants for clean drinking water etc.

Watch a New Surat district cooperative bank in 360 degree.


SURAT district cooperative bank entrance gate


Saturday, 24 February 2018

Install Latest and update Node js in Ubuntu


On Ubuntu 16.04 LTS the easier way is
1 Install npm:
sudo apt-get install npm
2.Install n
sudo npm install n -g
3 Get latest version of node
sudo n latest
If you prefer to install a specific version of `node you can
4 List available node versions
n ls
5 and the install a specific version

sudo n 4.5.0



Friday, 1 December 2017

Benefit of virtual reality



Many industries are now reaping the benefits of integrating virtual reality devices into their day-to-day work.



VR makes it possible for engineers and manufacturers to experience their creations before they’re builtMark Miles, managing director, RenderMedia

many business sectors are use a virtual reality for
presenting their product,office, showrooms.

In Surat, India  one of a  young entrepreneur start a virtual reality base startup could 360eye.in
and they already cover a many  business sectors like a Event And Function,
Restaurants And Hotels,Showrooms,Real Estate,industries,Tourist Places
Hospital And Clinic.
If we even imagine sitting in  room and actually experiencing the sound and life of a Event And Function on the virtual reality headset, we get goosebumps. Entertainment to health, to psychology, to business: the benefits of virtual reality are approaching infinity, and it will really take the world to new places.
some real example by 360 eye virtual tour
Real Estate
RealEstate Virtual Tour Solitaire Sangini Group
Restaurants And Hotels
Hotels Hari Champa Resort Surat

Main Website 
http://360eye.in



Thursday, 8 September 2016

Html Table Export To excel Using Javascript


Note : this Code is working Only Google Chrome
Note : only 2 MB data Uri in Exported  ( 1500 Record and 35 Columns ) Tested.


$("#btnExport").click(function(e) {
       //getting values of current time for generating the file name
       var dt = new Date();
       var day = dt.getDate();
       var month = dt.getMonth() + 1;
       var year = dt.getFullYear();
       var hour = dt.getHours();
       var mins = dt.getMinutes();
       var postfix = day + "." + month + "." + year + "_" + hour + "." + mins;
       //creating a temporary HTML link element (they support setting file names)
       var a = document.createElement('a');
       //getting data from our div that contains the HTML table
       var data_type = 'data:application/vnd.ms-excel';
       var table_div = document.getElementById('tableDiv');
       var table_html = table_div.outerHTML.replace(/ /g, '%20');
       a.href = data_type + ', ' + table_html;
       //setting the file name
       a.download = 'exported_table_' + postfix + '.xls';
       //triggering the function
       a.click();
       //just in case, prevent default behaviour
       e.preventDefault();
});