tag:blogger.com,1999:blog-84001532978383021572024-02-07T12:08:21.456+05:30 ReddyInfoSoft we make ITVarahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.comBlogger199125tag:blogger.com,1999:blog-8400153297838302157.post-1842353095118229762024-02-06T21:44:00.001+05:302024-02-06T21:47:03.352+05:30Parameterised Stored procedure with select query and output parameter<div style="text-align: left;"> create proc sp_test_select_output</div><div>(</div><div><span style="white-space: normal;"><span style="white-space: pre;"> </span>@id int,</span></div><div><span style="white-space: normal;"><span style="white-space: pre;"> </span>@rtnval int output</span></div><div>)</div><div>as </div><div>begin</div><div><span style="white-space: normal;"><span style="white-space: pre;"> </span>select * from tblCities;</span></div><div><span style="white-space: normal;"><span style="white-space: pre;"> </span>select @rtnval = @@ROWCOUNT;</span></div><div>end</div><div><br /></div><div>--declare @output int;</div><div>--exec sp_test_select_output 0, @output output;</div><div>--select @output as 'OUT PUT'</div><div><br /></div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgLXG-nAzWWvcqF1bkw8YyS0U-UlMY9bMiuHBf2cs9yjYLQWJE3S0imQPqIlaU7zcCGRyKUzVCp4NbnTNfQfp_hOxpVXOKKUolGnCWUsLHkIwbRWGCviK8dnyiCXex1eDOk8X0N7xdGo4jGDMdH91gVFbhExgPGz5ccaG4SpX1GlHost7WDgjxhDSBo_Pn6" style="margin-left: 1em; margin-right: 1em;"><img data-original-height="579" data-original-width="368" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEgLXG-nAzWWvcqF1bkw8YyS0U-UlMY9bMiuHBf2cs9yjYLQWJE3S0imQPqIlaU7zcCGRyKUzVCp4NbnTNfQfp_hOxpVXOKKUolGnCWUsLHkIwbRWGCviK8dnyiCXex1eDOk8X0N7xdGo4jGDMdH91gVFbhExgPGz5ccaG4SpX1GlHost7WDgjxhDSBo_Pn6=w255-h400" width="255" /></a></div><br /><br /></div>Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-14426017909036789242020-04-13T00:19:00.003+05:302020-04-14T02:25:00.678+05:30RaspberryPi Remote Desktop windows 10 OR Install XRDP in RaspberryPiIn this Post I will show how to install XRDP in RaspberryPi<br />
or<br />
How to connect RaspberryPi from Windows using Remote Desktop.<br />
<br />
Previously I had shown you<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/the-entity-type-requires-primary-key-to.html">The entity type '' requires a primary key to be defined</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/unable-to-configure-https-endpoint-no.html">Unable to configure HTTPS endpoint. No server certificate was specified</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/systemioioexception-failed-to-bind-to.html">Failed to bind to address https://127.0.0.1:5001: address already in use</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with.html">Jquery DataTable Custom PDF Export with New Column</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with_3.html">Jquery DataTable Custom PDF Export with logo</a></li>
</ul>
<b>OutPut:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7HSQpgQL938IVQRxcSwLO0Q-j4RljXZjMkqoFK5YxQgTKWhzbQgmnF_Gg7eb48PcHzLpf7qNTIHqWz_B1_dSI5h7D7WULUmCVgB4HEtfHpCEIqVV681kOOyBAdao3Nrw6RiYzBDfqUys4/s1600/remoteDT.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="824" data-original-width="1600" height="328" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7HSQpgQL938IVQRxcSwLO0Q-j4RljXZjMkqoFK5YxQgTKWhzbQgmnF_Gg7eb48PcHzLpf7qNTIHqWz_B1_dSI5h7D7WULUmCVgB4HEtfHpCEIqVV681kOOyBAdao3Nrw6RiYzBDfqUys4/s640/remoteDT.png" width="640" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<a name='more'></a>Before we install the required package in RaspberryPi, lets update using below command<br />
<pre><code class="bash html hljs">
sudo apt-get update
</code></pre>
To connect RaspberryPi we need to install xrdp.<br />
Xrdp is an open-source implementation of the Microsoft Remote Desktop Protocol (RDP) that allows you to graphically control a remote system.<br />
Install xrdp using below command<br />
<pre><code class="bash html hljs">
sudo apt-get install xrdp
</code></pre>
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/pH2Oh8nrzcM" width="620"></iframe>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-70759916731174256702020-04-10T19:44:00.003+05:302020-04-10T19:44:26.871+05:30System.IO.IOException: Failed to bind to address https://127.0.0.1:5001: address already in use.In this post I will show you how to solve above problem. To solve this problem there are multiple ways in VS Code. some of them are...<br />
Before that previously I had shown you<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with.html">Jquery DataTable Custom PDF Export with New Column</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with_3.html">Jquery DataTable Custom PDF Export with logo</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/the-entity-type-requires-primary-key-to.html">The entity type '' requires a primary key to be defined.</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/unable-to-configure-https-endpoint-no.html">Unable to configure HTTPS endpoint. No server certificate was specified</a></li>
</ul>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0KDzV9ihJ5OMDKWPGjOu4bryqC6DRH67OFys4JFc4oh2WYNuLbXBUi_6wGxPcedmtYHFhPACSUhFSW0jcvKlz_GwZvV-D4yW_iaHp62q3mAy2EAgeSAUST_4cGlLF3JRlWmazdOF01emV/s1600/3.1+run+error+url+bind.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="461" data-original-width="1600" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0KDzV9ihJ5OMDKWPGjOu4bryqC6DRH67OFys4JFc4oh2WYNuLbXBUi_6wGxPcedmtYHFhPACSUhFSW0jcvKlz_GwZvV-D4yW_iaHp62q3mAy2EAgeSAUST_4cGlLF3JRlWmazdOF01emV/s640/3.1+run+error+url+bind.JPG" width="640" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b>Solution:</b>
<br />
<a name='more'></a>In VS Code navigate to <b>.vscode</b> and open <b>launch.json</b> and replace args with below line.<br />
<br />
<pre><code class="bash html hljs">
"args": ["urls=http://localhost:5002"]
</code></pre>
</div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-91527246047751054552020-04-10T19:27:00.001+05:302020-04-10T19:28:32.089+05:30Unable to configure HTTPS endpoint. No server certificate was specified, and the default developer certificate could not be found or is out of date. In this post I will show you how to solved the Issue. Here I am using VS Code.<br />
Previously I had shown<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with.html">Jquery DataTable Custom PDF Export with New Column</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with_3.html">Jquery DataTable Custom PDF Export with logo</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/04/the-entity-type-requires-primary-key-to.html">The entity type '' requires a primary key to be defined.</a></li>
</ul>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqadtc7mqD0f89vQpckiC4rWlKrD9e5gaKwvMYQByxQa23CjGPEwuVzdEdlycaedb7DznC_SJ1imlntS5wHAMd80W1EdYydm1SvujWVtu_aDrPTs6BhFhl-f05RtrvMQPRz6nGhhnCGZ2-/s1600/2+error+run.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="458" data-original-width="1600" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqadtc7mqD0f89vQpckiC4rWlKrD9e5gaKwvMYQByxQa23CjGPEwuVzdEdlycaedb7DznC_SJ1imlntS5wHAMd80W1EdYydm1SvujWVtu_aDrPTs6BhFhl-f05RtrvMQPRz6nGhhnCGZ2-/s640/2+error+run.jpg" width="640" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqadtc7mqD0f89vQpckiC4rWlKrD9e5gaKwvMYQByxQa23CjGPEwuVzdEdlycaedb7DznC_SJ1imlntS5wHAMd80W1EdYydm1SvujWVtu_aDrPTs6BhFhl-f05RtrvMQPRz6nGhhnCGZ2-/s1600/2+error+run.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
To solve this problem I had generated certificates as described in the error message as shown below.<br />
To generate a developer certificate run '<b>dotnet dev-certs https</b>'.<br />
To trust the certificate (Windows and macOS only) run '<b>dotnet dev-certs https --trust</b>'.<br />
But no use.<br />
<br />
Don't worry there is a solution.<br />
<br />
<b>Steps for solution</b>:<br />
<br />
<a name='more'></a>Close all browsers, so that they do not cache the certificate because that will cause other issues.<br />
In the command line run
<br />
<pre><code class="bash html hljs">
dotnet dev-certs https --clean
</code></pre>
Now to trust the Certificates run below command in the Command Prompt
<br />
<pre><code class="bash html hljs">
dotnet dev-certs https -t
</code></pre>
Now You can then check the certificate with below Command.
<br />
<pre><code class="bash html hljs">
dotnet dev-certs https --check
</code></pre>
</div>
Now run the project. Problem solved.Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-22096467715340857312020-04-10T18:57:00.003+05:302020-04-10T19:04:34.342+05:30The entity type '' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.As the title says The entity type '' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.<br />
<br />
In the previous post I had shown<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with.html">Jquery DataTable Custom PDF Export with New Column</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with_3.html">Jquery DataTable Custom PDF Export with logo</a></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYZohkAunM_J8ZCT1gAGyn4KfjM33Yx-satKxVyCwyx1YJdDUF7zZLHcg_JtJQbGuwmidtiA6rv813PkRHavLgXcJrNjl2R9CgmGFfwpInWdbRxCX2JdSqw_cIQTvAhJxtp7h90zP_aJxt/s1600/0+core+3+error.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="552" data-original-width="1600" height="219" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYZohkAunM_J8ZCT1gAGyn4KfjM33Yx-satKxVyCwyx1YJdDUF7zZLHcg_JtJQbGuwmidtiA6rv813PkRHavLgXcJrNjl2R9CgmGFfwpInWdbRxCX2JdSqw_cIQTvAhJxtp7h90zP_aJxt/s640/0+core+3+error.JPG" width="640" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYZohkAunM_J8ZCT1gAGyn4KfjM33Yx-satKxVyCwyx1YJdDUF7zZLHcg_JtJQbGuwmidtiA6rv813PkRHavLgXcJrNjl2R9CgmGFfwpInWdbRxCX2JdSqw_cIQTvAhJxtp7h90zP_aJxt/s1600/0+core+3+error.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<b>Source Code</b>
<a name='more'></a>
<br />
Add <b>[key]</b> attribute to primary key field with namespace <b>System.ComponentModel.DataAnnotations</b>;
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtpSj4MA6lhSxeSyJk9If1IVvhLVjBgea8gUHTSmyA9qHrtucBwoenNxKxi8dQWtu9UvbGn2GvaJ6Y7ASPmziHRHfok5e1zZQUXDXHC5deL8F4PyC4JAq5F3mueGMvznVB9hE7Myxx0FlK/s1600/1+core+3+Add+KEY.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="305" data-original-width="784" height="249" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtpSj4MA6lhSxeSyJk9If1IVvhLVjBgea8gUHTSmyA9qHrtucBwoenNxKxi8dQWtu9UvbGn2GvaJ6Y7ASPmziHRHfok5e1zZQUXDXHC5deL8F4PyC4JAq5F3mueGMvznVB9hE7Myxx0FlK/s640/1+core+3+Add+KEY.JPG" width="640" /></a></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-76649850476320345382020-02-03T18:02:00.000+05:302020-02-04T01:05:13.705+05:30Jquery DataTable Custom PDF Export with logoIn this post I 'll show how to Custom PDF Export with logo using Jquery DataTables.<br />
Previously I had shown..<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/02/jquery-datatable-custom-pdf-export-with.html">Jquery DataTable Custom PDF Export with New Column</a></li>
</ul>
<br />
<b>Sample OutPut:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/iqNLK107Jsg/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/iqNLK107Jsg?feature=player_embedded" width="620"></iframe></div>
<br />
<b>Source Code:</b>
<br />
<a name='more'></a><pre><code class="HTML hljs">
<!DOCTYPE html>
<html lang="en">
<head>
<title>Jquery DataTable Export</title>
</head>
<body>
<table id="tblFeStaging" cellpadding="0" cellspacing="0" border="0" class="display cell-border" style="width:100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>66</td>
<td>2009/01/12</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>22</td>
<td>2012/03/29</td>
<td>$433,060</td>
</tr>
<tr>
<td>Airi Satou</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>33</td>
<td>2008/11/28</td>
<td>$162,700</td>
</tr>
<tr>
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>New York</td>
<td>61</td>
<td>2012/12/02</td>
<td>$372,000</td>
</tr>
<tr>
<td>Herrod Chandler</td>
<td>Sales Assistant</td>
<td>San Francisco</td>
<td>59</td>
<td>2012/08/06</td>
<td>$137,500</td>
</tr>
<tr>
<td>Rhona Davidson</td>
<td>Integration Specialist</td>
<td>Tokyo</td>
<td>55</td>
<td>2010/10/14</td>
<td>$327,900</td>
</tr>
<tr>
<td>Colleen Hurst</td>
<td>Javascript Developer</td>
<td>San Francisco</td>
<td>39</td>
<td>2009/09/15</td>
<td>$205,500</td>
</tr>
<tr>
<td>Sonya Frost</td>
<td>Software Engineer</td>
<td>Edinburgh</td>
<td>23</td>
<td>2008/12/13</td>
<td>$103,600</td>
</tr>
<tr>
<td>Jena Gaines</td>
<td>Office Manager</td>
<td>London</td>
<td>30</td>
<td>2008/12/19</td>
<td>$90,560</td>
</tr>
<tr>
<td>Quinn Flynn</td>
<td>Support Lead</td>
<td>Edinburgh</td>
<td>22</td>
<td>2013/03/03</td>
<td>$342,000</td>
</tr>
<tr>
<td>Charde Marshall</td>
<td>Regional Director</td>
<td>San Francisco</td>
<td>36</td>
<td>2008/10/16</td>
<td>$470,600</td>
</tr>
<tr>
<td>Haley Kennedy</td>
<td>Senior Marketing Designer</td>
<td>London</td>
<td>43</td>
<td>2012/12/18</td>
<td>$313,500</td>
</tr>
<tr>
<td>Tatyana Fitzpatrick</td>
<td>Regional Director</td>
<td>London</td>
<td>19</td>
<td>2010/03/17</td>
<td>$385,750</td>
</tr>
<tr>
<td>Michael Silva</td>
<td>Marketing Designer</td>
<td>London</td>
<td>66</td>
<td>2012/11/27</td>
<td>$198,500</td>
</tr>
<tr>
<td>Paul Byrd</td>
<td>Chief Financial Officer (CFO)</td>
<td>New York</td>
<td>64</td>
<td>2010/06/09</td>
<td>$725,000</td>
</tr>
<tr>
<td>Gloria Little</td>
<td>Systems Administrator</td>
<td>New York</td>
<td>59</td>
<td>2009/04/10</td>
<td>$237,500</td>
</tr>
<tr>
<td>Bradley Greer</td>
<td>Software Engineer</td>
<td>London</td>
<td>41</td>
<td>2012/10/13</td>
<td>$132,000</td>
</tr>
<tr>
<td>Dai Rios</td>
<td>Personnel Lead</td>
<td>Edinburgh</td>
<td>35</td>
<td>2012/09/26</td>
<td>$217,500</td>
</tr>
<tr>
<td>Jenette Caldwell</td>
<td>Development Lead</td>
<td>New York</td>
<td>30</td>
<td>2011/09/03</td>
<td>$345,000</td>
</tr>
<tr>
<td>Yuri Berry</td>
<td>Chief Marketing Officer (CMO)</td>
<td>New York</td>
<td>40</td>
<td>2009/06/25</td>
<td>$675,000</td>
</tr>
<tr>
<td>Caesar Vance</td>
<td>Pre-Sales Support</td>
<td>New York</td>
<td>21</td>
<td>2011/12/12</td>
<td>$106,450</td>
</tr>
<tr>
<td>Doris Wilder</td>
<td>Sales Assistant</td>
<td>Sidney</td>
<td>23</td>
<td>2010/09/20</td>
<td>$85,600</td>
</tr>
<tr>
<td>Angelica Ramos</td>
<td>Chief Executive Officer (CEO)</td>
<td>London</td>
<td>47</td>
<td>2009/10/09</td>
<td>$1,200,000</td>
</tr>
<tr>
<td>Gavin Joyce</td>
<td>Developer</td>
<td>Edinburgh</td>
<td>42</td>
<td>2010/12/22</td>
<td>$92,575</td>
</tr>
<tr>
<td>Jennifer Chang</td>
<td>Regional Director</td>
<td>Singapore</td>
<td>28</td>
<td>2010/11/14</td>
<td>$357,650</td>
</tr>
<tr>
<td>Brenden Wagner</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>28</td>
<td>2011/06/07</td>
<td>$206,850</td>
</tr>
<tr>
<td>Fiona Green</td>
<td>Chief Operating Officer (COO)</td>
<td>San Francisco</td>
<td>48</td>
<td>2010/03/11</td>
<td>$850,000</td>
</tr>
<tr>
<td>Shou Itou</td>
<td>Regional Marketing</td>
<td>Tokyo</td>
<td>20</td>
<td>2011/08/14</td>
<td>$163,000</td>
</tr>
<tr>
<td>Michelle House</td>
<td>Integration Specialist</td>
<td>Sidney</td>
<td>37</td>
<td>2011/06/02</td>
<td>$95,400</td>
</tr>
<tr>
<td>Suki Burks</td>
<td>Developer</td>
<td>London</td>
<td>53</td>
<td>2009/10/22</td>
<td>$114,500</td>
</tr>
<tr>
<td>Prescott Bartlett</td>
<td>Technical Author</td>
<td>London</td>
<td>27</td>
<td>2011/05/07</td>
<td>$145,000</td>
</tr>
<tr>
<td>Gavin Cortez</td>
<td>Team Leader</td>
<td>San Francisco</td>
<td>22</td>
<td>2008/10/26</td>
<td>$235,500</td>
</tr>
<tr>
<td>Martena Mccray</td>
<td>Post-Sales support</td>
<td>Edinburgh</td>
<td>46</td>
<td>2011/03/09</td>
<td>$324,050</td>
</tr>
<tr>
<td>Unity Butler</td>
<td>Marketing Designer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/12/09</td>
<td>$85,675</td>
</tr>
<tr>
<td>Howard Hatfield</td>
<td>Office Manager</td>
<td>San Francisco</td>
<td>51</td>
<td>2008/12/16</td>
<td>$164,500</td>
</tr>
<tr>
<td>Hope Fuentes</td>
<td>Secretary</td>
<td>San Francisco</td>
<td>41</td>
<td>2010/02/12</td>
<td>$109,850</td>
</tr>
<tr>
<td>Vivian Harrell</td>
<td>Financial Controller</td>
<td>San Francisco</td>
<td>62</td>
<td>2009/02/14</td>
<td>$452,500</td>
</tr>
<tr>
<td>Timothy Mooney</td>
<td>Office Manager</td>
<td>London</td>
<td>37</td>
<td>2008/12/11</td>
<td>$136,200</td>
</tr>
<tr>
<td>Jackson Bradshaw</td>
<td>Director</td>
<td>New York</td>
<td>65</td>
<td>2008/09/26</td>
<td>$645,750</td>
</tr>
<tr>
<td>Olivia Liang</td>
<td>Support Engineer</td>
<td>Singapore</td>
<td>64</td>
<td>2011/02/03</td>
<td>$234,500</td>
</tr>
<tr>
<td>Bruno Nash</td>
<td>Software Engineer</td>
<td>London</td>
<td>38</td>
<td>2011/05/03</td>
<td>$163,500</td>
</tr>
<tr>
<td>Sakura Yamamoto</td>
<td>Support Engineer</td>
<td>Tokyo</td>
<td>37</td>
<td>2009/08/19</td>
<td>$139,575</td>
</tr>
<tr>
<td>Thor Walton</td>
<td>Developer</td>
<td>New York</td>
<td>61</td>
<td>2013/08/11</td>
<td>$98,540</td>
</tr>
<tr>
<td>Finn Camacho</td>
<td>Support Engineer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/07/07</td>
<td>$87,500</td>
</tr>
<tr>
<td>Serge Baldwin</td>
<td>Data Coordinator</td>
<td>Singapore</td>
<td>64</td>
<td>2012/04/09</td>
<td>$138,575</td>
</tr>
<tr>
<td>Zenaida Frank</td>
<td>Software Engineer</td>
<td>New York</td>
<td>63</td>
<td>2010/01/04</td>
<td>$125,250</td>
</tr>
<tr>
<td>Zorita Serrano</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>56</td>
<td>2012/06/01</td>
<td>$115,000</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>43</td>
<td>2013/02/01</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>46</td>
<td>2011/12/06</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</td>
<td>47</td>
<td>2011/03/21</td>
<td>$356,250</td>
</tr>
<tr>
<td>Lael Greer</td>
<td>Systems Administrator</td>
<td>London</td>
<td>21</td>
<td>2009/02/27</td>
<td>$103,500</td>
</tr>
<tr>
<td>Jonas Alexander</td>
<td>Developer</td>
<td>San Francisco</td>
<td>30</td>
<td>2010/07/14</td>
<td>$86,500</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2008/11/13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2011/06/27</td>
<td>$183,000</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2011/01/25</td>
<td>$112,000</td>
</tr>
</tbody>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
</table>
</body>
<link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.jqueryui.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/1.6.0/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://code.jquery.com/jquery-3.3.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.jqueryui.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/buttons.html5.min.js" type="text/javascript"></script>
<style>
div.dt-buttons {
position: relative;
float: right !important;
}
</style>
<script type="text/javascript">
$(document).ready(function () {
var logo;
// Function to convert an img URL to data URL
function getBase64FromImageUrl(url) {
var img = new Image();
img.crossOrigin = "anonymous";
img.onload = function () {
var canvas = document.createElement("canvas");
canvas.width = this.width;
canvas.height = this.height;
var ctx = canvas.getContext("2d");
ctx.drawImage(this, 0, 0);
var dataURL = canvas.toDataURL("image/png");
return dataURL.replace(/^data:image\/(png|jpg);base64,/, "");
};
img.src = url;
}
logo = getBase64FromImageUrl('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNDPI5eG9-Ia98ZVY-drcktWtaTTwl10h7xsHjEUoc2voNf-Z-6FDQ0e1TJc74fKv-IvoZRRnM8VeLxBgoLlrF-IfauTFKiEqd71mTSeU8dKAZyYdfgUOb_tHQQlYgnqO8jX2f58fK-xf5/s752/ReddyInfoSoft+Icon+128+Transparent.png');
//logo = getBase64FromImageUrl('https://datatables.net/media/images/logo.png');
//logo = getBase64FromImageUrl('./datatables.png');
//logo = getBase64FromImageUrl('./ReddyInfoSoft.png');
$('#tblFeStaging').DataTable({
"ordering": false,
"pageLength": 25,
dom: 'Blrtip',
buttons: [
{
extend: 'pdfHtml5',
title: "Main Title",
pageSize: 'A4',
exportOptions: {
search: 'applied',
order: 'applied',
stripNewlines: false
},
customize: function (doc) {
var rdoc = doc;
var rcout = doc.content[doc.content.length - 1].table.body.length - 1;
doc.content.splice(0, 1);
var now = new Date();
var jsDate = now.getDate() + '/' + (now.getMonth() + 1) + '/' + now.getFullYear() + ' and Time:' + now.getHours() + ':' + now.getMinutes() + ':' + now.getSeconds();
doc.pageMargins = [30, 90, 30, 30];
doc.defaultStyle.fontSize = 8;
doc.styles.tableHeader.fontSize = 9;
doc.content[doc.content.length - 1].table.headerRows = 2;
for (var i = 0; i < rcout; i++) {
var obj = doc.content[doc.content.length - 1].table.body[i + 1];
doc.content[doc.content.length - 1].table.body[(i + 1)][0] = { text: obj[0].text, style: [obj[0].style], bold: true };
doc.content[doc.content.length - 1].table.body[(i + 1)][3] = {
text: obj[3].text,
style: [obj[3].style],
alignment: 'center',
bold: obj[3].text > 60 ? true : false,
fillColor: obj[3].text > 60 ? 'red' : null
};
}
doc['header'] = (function (page, pages) {
return {
table: {
//widths: ['100%'],
widths: ['auto', 'auto'],
headerRows: 0,
body: [
[
{
//margin: [0, 10, 0, 0],
width: 38,//'auto',
alignment: 'center',
/*ReddyInfoSoft*/
//image: 'data:image/png;base64,' + logo,
image: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAABHNCSVQICAgIfAhkiAAAAF96VFh0UmF3IHByb2ZpbGUgdHlwZSBBUFAxAAAImeNKT81LLcpMVigoyk/LzEnlUgADYxMuE0sTS6NEAwMDCwMIMDQwMDYEkkZAtjlUKNEABZiYm6UBoblZspkpiM8FAE+6FWgbLdiMAAAgAElEQVR4nO29d5hkxXnv/6mqEzrM9OSwOWd2l2VZ2AXBIkSSUbBsBcuWJduPbdm+vtJP93evHK4tWdeWHGSjYGXZukJXEkLJF4EQGQGCBRbYBTbnMDthJ3dPpxOq7h+nz3TvsGSYmbXm+zz1dE9P9+nqer/1pnqrDsxgBtMVH3kXzTd8hORU9+OF8P13oQAx1f14pVBT3YEXQlqTamtlvfAYOt6PN9X9qcVVG2l473W0Hzc0bHuWLGCmuk+vBNZUd+B5IABz7z4GFy+joamZK4Db4tensmPvuIT2kmBxU5olO/dx9MFd7Af0VPbp1WA6awAFcHKY7Nsu47ekYOBoDz1Mkbr98FvpuGANv+KmeWe9y6yefh6843Ge9TzGKn06J83AdCVAPKCyUCDb2UzrdReL32tr556n91NiEgd760XM3bSUD8zqFP/dD8Tqfd387D/u55tHuukhmvm1Y3jOkWC6dlgAstIA1N/8vvWzhB0+++dfNh8mMgOvqznYsooN56/iugWt4r1aCHXvTv29pw/zbwMD9BAJ3QZCIhKYmr6cU77AdPUBamEDpV0Hg6++73r7pg+90+/6/A/5J14HErzrXSSTRa5fPltc3VonrnFdufDRXcG37nzK3HDsFE8TCb6eSOhhzUfPLvyvf2kdybrzOP/8ObR1NmEpSV/XAE/teIZ8+Sk++MGB16rvrxTTWQMIqjNNAe6XPipvvXiDWvfF7/p//o1b+dea974qEvzu25m3ZBa/1dFoXbt8FustIZu2Hw6O3fKw/tv7n+DHwCiQqXxXCARUZ3+sAQAMW7cm+Jv/9Vu0zHmL6rXW2COqXQk7bSWVJQz4XuD7qWDAmy2O4+ijDJ1+Ait8hG9/ewf/+q/lV/M7XgmmKwGgagLsSjNvvYxf/9gfJP53a4vOf++n+tOlE8GnP3EbhVdy8XktzH7vdaya06l+o6OFazcslR0tluU8vDvktif8//PTn5vPdI9yhIh8ikjQPpHwA6qCrxLgn//hci5+26fc3uT5dbo+nWyxsVtslNJIYUCANgK/CN6oxhstU3KCktdM1g9GTpPQ95DvvYv//4NPsPNQ/6scv5eE6UyA2A+wAQeQqRSLb/yf6sa3X5s8rzcXBI8/Wr7llvvMp5OLeOprX8N/vgt9HORbv4r6wq0srHe58N3XiIu0VFfXp9XCebOsVJOlRH4g4NbHytnvPRjecM9TfLNUokRkIkPAozrz4xbPes0f/qHNouUfEJe+92MNJ/S8THOCxHwXlbAQQiBENUgQgDYhaAi1wR8LCQZ8vDFD3tbac4JSuYHj/OKmzzCr42be977s6zO8jPdnOkMQEcAlIoHzO9fzF5/8UP1/nb3MZWg0IDtU7P3FQ8Fdh7rCe5XgyTeu5fSeQUy2D9kzTGNLhiWlkPVbVjsXrL1QrFWOWubatqqvc7ADgckGDJws8aNtpSNf/Zn+h50H+BlVz96rtNqZH6t+AMNb/jDFO678Sztzyf9oPF1y6tc143akIJRgDGiDmZAlEFKArD4aZcBo/NGAoN+nMOiTnZ8JS4nu+3nw9k/RnNnG7/5u6fUa4OmM2A9wgQQgLljOe/7tY+7nNmxqUqQsfO0Thj5al4NSTzB64IgudQ8Y3Z4RYt1ymbDaZcrJuCkCC4TCEhamDEEBrHyZ7Kki37m/uPeGH+pPHO5jG5AkEngJKHMmAWKVX8VffeqP7PPe8/nmXs+qu6ANqzEJgcRoDRqMNrV0wQgQoiJ8FT1KBSgJrkEoCIoBpSNj5AY12RXJQji679/57le+wLe+deD1GODpDkk0+xOAs3AeW274Y+vzb7uuab5sShNaEmVpUBpEiLBMpDM0GF9EI64tTCAwvsGUDboQYhfL+INFvnNf8cjHvhP+VVcfj1IVfp4qAcLKa6amRY7n+9+/Qbz9z37SvK88t+GiudjNaYxv0KHBhAICjYk1QGwwBAgJCIGQICyBUIAUCBuEkkhXYJQhGC5ROFAg50jGltiHze77bmDp3B9y6aWnX6vBna6JoIkQRPZYhB7JdYt446ZV9iwr5RBqAUZhhIUxNjq0Mb6DCRyMtjGBhfbBlMGUNSavUSUP8mVufbQw8vHvhP9wrJsHgDTRbM8DRaozPxY+VIUPkOC/feqf6o5waWZxJ1ZbBl0yGM+gfYP2KmQrR38bP/qfiZ8HoAMDlUcTgAkNVJ4TClTSwpnt4gYa+0ihWXcsvz4ICqu58tIRbvmPg6/FwJ4LeQCoxt0qV2JsYMQUjW/ADzEStDYIHetWokcExkRqWPsaPI0p+ajQoGTAgROl8Mu3hz84eIJ7iGZ+GchRnfk+1TCvFgLQfOCDm2Wu7tfToYvV1oApCYwfQmgigYZAYNDanJkmqlxBiIr9r5gCKQTGBssSYIGxQdkC5UjcOWmsjE3ixBi5sdbrs3PetCncf/jvWbHkc7zKEPhcIEDV24YwDVgKSQiEBqM1okIPIyMCjGtbDWgDnoZyiGUMyjWYMZ9bHwv2P/gkNxMJ1CMSfpEzhX+2wY1CwhUX/E7qlOdYy+aBlhgvRGvA1+iQiABhjfo3NZcSAoOpmIPo0QgBHgSWiMyZBcaSGNtAQSASNoklDVjdeexjY+1DY3wq+P6ty7n/9n/my18+8koH91wgAFTnkG5soWXhLNkkhMAEBoHBSI2RFd0sqp/QBgg1pmywhEElBTgBe58pe3c+qW8rh3RX3p0DCry48CUQctHli4TdfKVjEsiGOkzZYAKN0ZHgTVjRABXBT4wCxi8twIQCYQxamEi1SBEpMGkIpUZXNIJwBNJVyKY0aUsgj40ks2rZHxcufc8Wrv2VT/Krb/3hKxlY+eJvmTbQQJipY/GqBWqx41qElVmGr8ELMV6IKVeaF0I5RJdDlNEoV4BrwAt4cl84eN8OHqTq8NUKPxbd2SABzapVl6kRq1U11ANWZO/Dii2PhR9rgHEiMMEUCDASgcRICyEdkAkQSQxJjE5hwiR+0SHIWvhDAq8vpNTto8s2bkcTjb6goav+fJFr/Srfv/N/snq1U9PPl4RzRQNANHTJjStYP6fNtoUrCUKDOEO11rxbRx9RAixHRJGBMOT7A4506d1hSC+RwGsdvhda168uTtVlLrWzVsLqTIGWaK0r+qky20PzPAyq+CmAkDIKB6RCKgukhbAEVHyC+K3GVMLIUGNCjfE0gacRIkA2tpDWCrGruzmfsj7m/8afLGTvM3/BTV8b4CWmyM8pAsxqZdGVG623tTfZhFogdPT7VI3aH3+oDKCqJFuifxgGhkJ94IQ5CIwQCf7F1H4tAuaubqZp8VJ71BLYbuS51zp6uiL85zh+YrxTkfAtUAph2QhbRmrerjQralHcU3FstcKEClPJTBgviipEex1JkUAeOOyMOfN/z9vSOod58z7CP/31/pcyqOeCCRhfGn7jRn5tWbu1IFWnMIDjCNyEwEoKrESluQJbCSwZEWM8C2uAAPIlbU4OM0Ck+ifm9V+sH5rOhgV49ixpO6CsSOXryMczZ1X1jM96hECIivAtG+E4CFcikiDrQGRANYFqA9UOVjuoFlD1IJOgXINKGmTSoFIGmQBp21jts0iuPZ9M2CGTu+WbaV32Pf7iU1teyuCeCxpAAMHKBWy5co36owtXOJCwsJLRrBkvyYwDthDwDSIUNbOSyizVhD4UvPEUr+bMvP4LIVoXUHqWLMpWkUwghFXxNBn/rudcKBY+Z856bIVwBdIlIkAKRBqkE/XIFCEsQDAGYQ7CMuhQRNFOCIQC7RnwfUTgQehhMm04Q2OYp3rPL61a/C3+9jMf5K8/ct+L/ajpDAno5mYyb75IfOzajW5zYp4LdQqSAtwa9R4v1ZQNeAZ8U1HspuKQAUYgNbSkcYlkFbtoL1bTV13NUapDGiepEkmQKjIBosb9mDj7K6k/ISUoO1L5jkRUfD5ZB6IOpA06B94QeGPgeVH3y+CFdj4bcjJnwkEPrcR4zwkNomxEMmEL4doihS3qMq46ppudvvJSb/nSG/nst36f/+/9dz7fD5vOBBh3Yrau5cPvvsy9bu6aJLTbkFGV9cHYOlT0b0AU8+cFFDRIU53nFTHbQoiWJpqIdMfLqTSOxNrW0Siko6TtgGVBGEah3gQ/JPoFFZsvBEgFygY7Er5IVdU+AXh7DYVhQSEFZSs/EBT3nqRnZxdDp07Se+wEO7Z1cehQ/oweWWjKoTFLVqXMnIUujY1J6prTQbpxAZlFK4W9bJVpbvk67/uTP+PbX/oPoiTXhEtMb5iNy7j+N7aoP918uQsLLEgEYIeVmS8ZX64XslI5IMDW4IjIyiPA6IqlF9SllOzMMJ9obSHPy8ukKWYtaxLSUkg7+k4ROwAT3lnj9EXCdxCx8JMVu94YqfrSM5DVgrFk3wmz5+Z72f3ws+x88igHDg9yZvqZs/Z3794h9u6N6xWijObcuZZZtnY+nQs3suVNi8j2L+AnPzgw8fPTlQAS0KuWsOZ9V8t/eMvVbjuOYfRoAX/E93KDelQmoK5N1tXNc5Juow0ph4gBEhwV/TIrsvvRglB04cYGRUujXAE6SaRIX8qCWEXN4OCm64R0pbAUQkqMkZVr6+hSxlSvKARCVmy+ZVXtfT2IeghPQ3G3ZrRTUvSf3MaX/upG7r5jD5Eg7cpVYs8mNi61pWi1Lm78rQ6QoaurQFfXTuB+Hrm9Ac+14nGlhgTTkQAS0BtXMuvtF4nPvn+rc97gmOGeWwp7v3NXsG1wkJ58mayUkE7S0NJY6nzn1XL1xssSmxeucaExAdggZbS8Mx6iGdCSZFqxoFV2rJynF+07ybGX2KdqiZqyHJSUqEjrCESUxjWSaspPVoUvFShrPMRT6Uj9B8cN+V0BI/PtIDhy80/4ysdvYs/+LqoLdGM8twKpZmH5OX2L7WFMCA3UATbHj2cr13sO2acbAQSgt66ncet68ZkrN9hX3f2Mv+vm+8MfPPgsOwdzDFJNyMQ/Rt3+iG5dv6Sw+kO/WXrLW9/mXeCuTlWyajJyGLWGUIMPwlKsmKPSKxcGW/ed5D7OHLQXRkODjVSOMIqIAJW13Tjhf0a4J0BUhG/JiAApwIXgOOQO+ox2FgfDu//+37npK3czOpojElqByFbX1iHUVh/HqJ31EwkQvx5HOYrxQPhMTCcCCMBsnEVqy2rxyeXz5DtuvN+74eafc3M2S4FqbWD8Y8YJkC3R89BuTu/4hH7m/dvzb/7T93nvWvXWugxOCqQFaQG+gMBAWbFsjmPNb/euAJOGl1FTqHUUyxkVVXHUOHmGWg1AxfbL6PsrRW0iAeGAYWxfmdH2wnB45yc+xzc/fz9V2x3XIbyQ8M+2NF0Ta56hEaCqOc6a65hW9QCb55Jct5H/MbdNXv7te/SHb3mIm8plNBFRDdXUbdxK1OTvvZDi9n08+/Sz+si6ZLC4c6FpFikVVdsoMT6clh9SLvrJQ31mR88A+6iS6vkQZRsSCZuNl19lWbPPT9a3CVWXqpj+2iSAqKj9OMunEE7k9OFBcU+J4cZAhw//45f5t3+5PXqVAtGC1Fjlee2qZC0R4seYFOHz/F37/lrhPyfcnTYEWL0aZ9VS3t2cYtk3f2b+fPdRniEqxZZUInyiwYkHKF63jwdqXL2dGODEzx/Xe+ry3txFs/TsRLuMQraKQpShxirr1GMHgpH9J7iDqnP0fIhCjUTCYsMlVyg578Jkpl3IhjTR2q+pGteaVG9EABFZIwf8Qx5ZrSkP/cdtfP3vv0mhEBefxDY6FnytoM+WWzwbzkh71TyvfYQJ15kOBBCAfMN5rCGk9Ru387VsgRGgkWopdplI4HHzeG7BZm3dnhrKc/oXT7M7VQrmrJ/HfKdDgqXG50U61AyP+OldJ80D2Ty9vLAWiAhQLsPFWy+37AWbEulWqerrI//CVOUjIFL9ykbEnn8CTM5QPBmQdY9288O/+xJ79x6mWoRSa/dfamr6peIFrzMdCMACcEUT1p3b2E5l1Y/qDPA4s0qntjr3bKoxnjVO0WP40QM8q7JBxwVzWOTMlpHzFkgsbbDKfuMj+/XJk6d5mBcOB+MNKgFrzttspZddkki3KdVUHzmXNfISIrL7QlmgJMKNsnzBCZ9Rf0wHx26+he/+24+parTY7k8sN58UTAcCiFEwXb2MEA1yXIsfF2NOtIO1Kq1W5cU2sPZvx/PIPraHXU4pmH1+h1nodlqR564FjcaovkE/+cxB7i4GjFKN9yciLkwt0tmyQbZddEUi3WGrpvrqKpCOzYCoeP4WwhYIBygaCqdK5PTuE/zsi1+k6+TRSl/jErSXuhr5mmOqCVA76yzOjGFr1foLFWlQ87+JRDCA64dktx9mr1sOFq7rNPMSHRZIhW0g4fmt2w7p4z2DPHGWPtX20wF85sxZLRZsuSbhtDlWc0MU+dWYAKRESAusKPaXNvi9IfnRPvzR++7mpq/fTNWZLfD8tYeTgqkmAFTj17MJ8aU4PzFqPx//HT93PI/sjiPsT5tgybq5YrbTEqVy67WxB4f81PbD3OX75Dg7ASRxyDx/0TyxcPO1CdmStpubopyPrpm8QiKUQig1Xp7uncyRC4+Pml0/+N/s2b2j8h15qjuOpuyAielSDzBRndeGNi9HLcbXiTd2FInUbA7QQ6Mc+eKPzefuu6t4iIESJA2ZWQ5XbbQuWT2PN7+E6yrK3rCxw1ETeqB1tMFDVMJvUduiB53X+LkhQnPkCNsefpzKbmemeObHmA4aAM6c6a+FLawNeWqv54zkGThw3Jxa0RpsWDhb1Ys6RYMWVqEYdDy1w9xd4qy+gKCyukBdo80Fl1zjlBrnOK2tiIQCDaLWCVQ2QkWlXWFfgexIlw4HfnEnd996S+VaBaoe/5RiOmUC4c0HHbL7tpBKvxGtlqNIREVxpUFC0YNSpyj1P0tP/5Mc+tCLbaWOQ8g4Yxar9vqnjvLYR78Yfv5fVP4vLru8LtM4z+aq9dbFD1/ivfO2R/hszWdqiRQCCbqOnCZ3alDrxZgwrNRwxVqg8rH40wEEA6P4zsgYXYfiSCMOXV/Mr5kUTBMCbExx6V++VyXa/6ROt67M+LgZg5I6kplnMEUhjGeELtSbYrF+5LS/8h33Uj7xI579ux30XjQInzibKo0F51G7oANi+yHu/cQ3g7Z/TOQ/vHFTSq1b6Ygr1gZ/sPeE/snhLg7xfM5gPl9guOdUkPGMKXsCEpU0kgAjxvf+ARjPEGZH0PX9/Tx4106qBJgWwoepNQHRMC34k04u+ed/bjVLPr4kV5i11DX2wiYpZzcp2psE7Q2S9rQRnSktZlmh7Ax9t7loNSc9tVHYrb8dLPu9K3XzWBrl5Fnydzl6bpq4TXxiJs1Q8X2O9nC4UNLpdZ16Tdt8WzRK0br7ZJDbd5yHeK4JiB1BwbqNK0TTsksTdoulmtLRcrOJLx1lAoUl0KNligMn8YIj27nzB7dwZiJrSm1/jKkiQKReV/7leWL5f/vy7DH9zuUiYMHsOppaXBIJhWWBsgRKGmxb4rrRUm59RtGYUbS6gtayT2Z0dLadWH5tMOe91/nO2DJaL86z9CMDHL+xttqnVvixgraA8v5THGpImUUXLVMLZrdKCnm95Mmj5oHsGKeo+gKi5jMO8xfVi8XnX+eWMkm7ozHS/jpaEhAiLgET6MEx8mPdOvCOPsgjd9/Pc7N9U46pIEA0qAs+0Mmij9w4J1d44/KEoH1WI7ZrY0JNEBoCX+P7IUGgCbUmDKOmtUEKgeMqUhmbxjqb5tAjkxtpcnXbxiCz6a1l3b2Apb99mo3X97LnB7HwJy75GsAJQ0YOneRoJqEvWL9Utcxvlpne0SC1fR+3c6aqjgngMpYvm01b35nINTS4c9sQFtFu4PFQUIAU6L4RCoW+IMzvv4vtDz7KNLP/MPkEqFjHpS6r//yT7V7ynUvckObWZqRShF6AH0ZC9/2QMAgJA01QaWHcQo3W0VYsaUkSaZtM2qZJlcmMjSYtM/eCkj37V4OR/CzmXN3LyR/3Up3JcegVz+pktkj3oW5zenazvvSiJVZCCrPqYI/ZcWqAvVS1QFx/5pAbCbnsqqsdv22e09YOrqzsQ6xUh1YIEPQOUAj7At3/zC08/fjTVLObIdMEk0mAatnkmj+7KqHO++uFupBubW1BSpsgDMeFGwm7MvvDSOg61OjQoINIC+jQREQIYyKAm7Cpq7NoEmXq84WUVIs2F6zWK/SczYqGZQc4/Ysiz10Vk0BiMMuhvhHjrZjHxZcuc5xjw+Hi48f5cbZMsabv1TOLNr9xqbBmX5hwm4Vscmoiej2eCwi7+ykw6JuTj/6Ifbv2USlbZZqof5h8AhjApv23/7RFNr+xM+XgJjLoMCQMDTqcMNvDGtVfEXioKwTQJnoeGrQBbQxGG4SSJFI2mbRDYzBGqkirl9x0dSk5Zw1rPjjEga8c5rmlVQpQx/t4VivdvHmFtX5Ju5pzdCQs7DnGA5xZZBEVpTTWJ82KzW9P5lPCmlMf1YbqmhAQCLr7KKhB32z/0U309ByhmuL+pSRARZU21dN42R+1Ox1LG9N1COWidRgJuDLTwzAWblXYWkcC1uGZj6Gm8r8KGSpHs0glSda5NCQE9YUhafuZFSWRusqf9+YW7MXbGXog1gbx7LaBcNdBnhFuuOqK1dYCMMsO95mH+0c4xZmOoGKwzzJX/PpbEqOJlD27JdrHd4ZxEYSn+iiqQd/84offJZs9TrUsa1rYf5jcVHA00JkVbbbV2mrrIsIowjAkCAxBENbM+GBc+GEYNV3jCMYaItIWAb4f4HkhnhfglwPKXkC5HL2uXIuOznpWtISsDvxZ7cHqj4pFv/l9Lv3eeiJhxMUleUAGMHTTveZTP3rcO3TRYjX3mo18iEp5aeV3RA5csZhFD+8KRAmT02BXM8LjOLNcfGJyaVpg8tcCUuctF6qh3RIB2ghCv8a+j6v3eJXVnKURkUGbcRL4fojvB/hegFcO8coBXtmnXAool300hlRdknltSVanPLWw6F5r1V/2fzn/i+8FAnhXjmh9vgiorn4Ofu8h/eljA6F//QbrbVs28OuV3lcrbAqFIfY/8oSfluihQk2ZasUMGI3BRGfBheHzlmRNNSZbA1gYtcwOdZuSCm1EjYqvqntgXNgx4mX3KgkM2sTk0ZWwUeMHERF8L4g0ghdSLgX4fohlK9ra61nWKFg5WljY0PRrX2frg//C1vc3AUNUizPEY89y37cfCD9r26bu3Vvkh+fUs4wz6w1K7N5+wEv7fpDNVWtvx3ciU10mVqpWL0wrTJYPIMdb/eZfzaRWbG2yElhOfZTqhzOE/VwtKSY0WTl8sVohbsbJpAk14w6iiX2ECoEQgkTSpt4VpMfGHF/N2ZJPda7FP72LkWeOU137Dw/1sKelkYWXrLC2epYWT+3n7krnLMAm2aDMxss2u4VMm93YiHBFdMBThcRh72mKDAcme+RWThw9QnWlctpgMgkgAJfm69/d4M5d3+TWoex6jIlD4sg8nkmEqtCFkJWmKs1CSBsp7Oi5sJDSRggbjCQMDcbEoWQYOYlGj+cCnYRNXcqlrpRD58JlxY7rLg9F8RjDT+wlmuGJMCR/rJ8DizrZeuFStfVQn46riB3AYWykyNrz1lvJ5asdJ4VssCMCAMZodP8gJb8/0OHpu9izcx9VJ3DaYHIJkNjQQcd73t2EWJZJtqKs5LgGeO6sj2a3iPfUo5AyOkVBSgcpE5XmolSy5u+oCeUicMY1QxAEFSJEPkakmSWptEudKSGz5bZ8+/VvCppWjdDz5FOQDYC6XJ6usaLpvXiF+JU5LWLlgQHz09FRhoEkYWiYvaDNLNl4RaKQkFZbqrr8ZAx6YJhiqd9ohh5hx7adnFmzOC0wWQSIvsdevlQ1X/WbzYLOTKodqRzAVNQ5VGf7mTM+EriDlElU3KwklkwiLbeyW8tBqahJy8ZSCZRKoKwUQiUAFe0R9UOCIIgyicYghCSRTlKvQhK5bF02s+Eqf+7FDoM7nsQ/XQQSJ/vZo2zjXLxavatQ0OVdR3mQuE7QEoFZe8k1iXxTnd1eHxmHADAGk81RzvWbUA48w/YHf8HLO49gUjDJGmDBQtV85a81CdFal2xFSofYsY4PVY4PVpZSISqzXckEQiVRKolSLrZtYyuJZQssS2BFB25Q2YOJUqLSJEqqiBxWCikSGOFgdGWdwQ8ItUYIgZtyqXckbm7YLjqLLit1XtxO745thH05wDrUw46FnWbFxSvlb5zoN4/0DnIESDCWDdly2SZLzF5kJ9PIehXtQtIGXSzgn+4VgTV8lMfuu5PXvuT7VWMyooDYW1OUvbwWeiRERiFSJXCuaoD47RYCByldhEqhrHpsOxUJ3pXYLjgJcF1IJCot+TwtFT26CYGbcEkkGnDddizVjNYJisWAsVyRQsFD2C6zW+pZ7g3SHi54v9j0hRuov7ADyJdKDH/nDvM3o2OMvONS8UmgBQjI5wscfeZhL1lGDxSjTUKVo2BlwsXStsDIhZxZlDJtMBkaIC7CsNAJ2zS/4YqMql+WcepRVlz+H79NVJy5SPhSJlEqhWUrLEtgO2A70UxXEkIf/KKmXAwo5TxKYz5B2RCWBToUEfNUrBWifSFKgVQKIRNImcRgEfgevu9htMZyHNIJm4SXQwfNq8Y6L13B2N7tlLoGs0VOl4qme/1S+cFU0vj7jvMgYOMHjr7oTdcmRl3XasvUFLaH+N09lFM5zb7Hvk2xWGQa1AHWYnIJwBDUXfDGtLvsvEY7gXLqqF1tldJCSgul3EjwVgJlyarQVbQTqzCmGR7yOZUXdIWSbq04JWx6pU1fqOj3BUNFGC5APufh5X3CQGEQqGjDbqUppHARJCv+gUcY+ijLIplwSPljmCCzJDf7yvMpdj9D/uDp46fZ39BgEpcsl3/YM2KeOD3MMUSozPmblrv41ZwAABDhSURBVFpi1lLHSSMzFgQCtCbs76dsjwWIwh0c2d9FdUVyWmAyS8IEEOIPjQTCIjAB9jg3THTYBgop7WjmW4nItld2C5QKhnxRkPV8+o1tRh2/WDb7d+ns3gMUT4ww9MgQ/rBH44WNpBbU4S5qkYn5s6TdON8Rze2pAk5Dzsh6EZBJ2KRTBssRKCmwLRffb8Pzknj+CFqXcRIWmYYMC7JZRKl+S9eav/2Sdhs/ysnvPPL9e/jM3Gaz6ZqN8i9PDOgPjPb1neKpux4vX7bx2mBgDLvVjU4uVQqVTqPG3ETQ0LQceHSSx/xFMRmdObMIw5ghXxujjRECgRDVLXlRPJ9EKnfcsdOBYXgUevyAIREWxsShE7r45BMcuPEhBu7vZuKWsKGfx/k4pVFKo+yg9aLWQvvblg/ULV0pk2tWNBUXzW8t2U6TDRlXYyei4+akqkf5Dl45S2Esh5uQpOvqWUAOkXfWn1zyV5/TtvvfOfKNe259wPzZ29/I9zct5o/v2cHfcWT/k+VLuw54pbrlTl4j0hKtFLKuHjFkJRHWykofbaYRJjMKiOZy3cZlVnrDG5qUcFynkfFYX1pRDK9cbFtiOaB9Tf9wwEEhgl62bSv33fB/zIG/uZETNz5C4ViWMzeJxjuIajaLGg/CMoUTI/TffZBTNz9sTt/5SFEN9g4lUnJU1GcKXtINiwalAxxbYNk2QibAWHiehzYhiYRLmhKy6Lfm2q7YZIQ+PNS1/RHbYvSiNfK/9J02u4YOn9rB2nXny8zK1a5xkA0OJhSYUonwdL/0k8N9PPmLH3GWY1qmEpNJgGiPfcOGBTK1cWuTFHWpZEu0i0bIyPFTLkpJbBt0oOkf9DggHH905N9/xLMf/AL9D+zCH43j6Hir+BjV835rzw2YuMc+8s+DoTxDDz5Nz4+3e97+faOu5Q87HQ1FL5U2JYNNiG1bKDuBwCXwozuSOK5LvSgj8l7LaNtlW4wf7jt+8Ilb53WYJcvm8s49h/hJ2NSAWbRhq+vVubIhGZ1JUPIJh/op1+kcuf676Ts1xDRaFZxsDWCwlrTJzOarW6TVlE62IKSDQCGkjVISywaMYXi4zCGVZGT02z/i2T/4KuFYvG2rVuix4GvPDIh3Etc+j2/9ElfjWJhSmdyuo/R874lAH9qXTSUYseY1e14ypbwAV2ps10GqJEEQEgQediJB2niIYrlxdNaWiymNPHHomV23XHAe72xx6Tx4YOA2ve7izRYdc51EGplSEBjCkVFK/ggM7H6Ik8cPV8ZiWjiCk0WAuJIGwpxL4xXXZKymWWk3E2XqhELKKKEjMIwOZTlEHYPeL+7n6d/5AqYwQqTWc5xd6LGA4xlfe3aAV/O/WpNhiHfvZfeeovvmx4Pg2NGRdJszJufOCn3bcoIirutgOSnCUBIEHpZjkTRlKAbNubbNm4LBY3d4o0ce27iS/9p7qrhvdPbSrMksvSxJWsiGBEZI9EiOcn7QNcGpp9i3+3GqgeKUYzIJUMkFjIam8eq1tj1vXaPjCMdJI2Qcn0M5X+R4Abqtk3vY/Qc3UDp8gqrw45kfC772ti615wZMvMVb3PyzfEYTVyvldh1j4I4dZZk9PVK/uL1MW7McGyGhLBw3jTFRzsCyJCldwHiqPddx8frTB3d9z9Y95VUZ8/ajQeLR0sKNq5xyXYvdnEHaCpMr4GeHrKDFHOPR++9jGq0ITiYB4j32AfUXLVCJFZc22wk7la5Dyig+N4FmIFfmOOWRoOvjn6X/p48RCWmM6vk5tbX1ZztGZeKZAbX594mEqC3Tjjz0cKzI8EP7zci2XWOpRkbS5y80hbKdDIrYbgYhHELto5QiqfOYMDFvrGXTou7uHTeuaB5YVe+fbj4xd3XR6NkrEsl6Ieps8HzCkWE8v9/j+DN3kc8PM03MwGQRIE6Q2oCHaplvZba8qcXOJFPJNNISSAHFfInusmHQ23Y/+z/1bSjGBRrx+Tmv5giViaSo1RK1GiQiq3dqkL7bnw3oOplt3LLI81ONdnkYt2K2tNEoJUgEOUKTXppLrK07Pfj0T9bQd+HYnA6GGlZ1usVEymrJIKWF7h+iLLPShH0/5+jRY0wTR3Cyq4Ij1ovmFtF01TWNKtNQn0pj25Iw1AzkPE4G2WH/9L9+ney2nZXPTbyF28s5M+BsiD9fe9pILRni1xX4PqNPHtPZbbtyHeub8s6SBdbYAAmlUHa0JUxJcPwsJdO0aliuyAr/qaeXedsXnFp3RXvQm6l3m5qETNmYoVHKQTGhVe4AT2/fxpkFqVOGqSCABSkRtl+/uU5mFjUk63AcSSHvcSqfZ7C080GO/+ON6EIcyuWpnpwFr+2sqa3Vm0iEqjYonxyi/84nyon6Ui61YbnMjzq2CbHdDFJYKBXi+MMyLzrWdcv5+zsL94/YnVbnQOO6VrfgStWegZJHODSqPNM3zJMP3VH5Tc93JM2kYbIJoIAEeiBL/YVrbWv5ha3JemHbkoHhHCfCsZFg8BtfY+TBHVRPzYyF/3rZy7P5DbWOpAYUYdaj/7adgRo7NdqydYX2dcYNyjhuJspcygDL75c5e/6GnnzdU4u824KhlZsXhoMZx21tQzg2YU8vpQbhU+5+kO7uXn4JCTBeb0di+SzqNl/WrBxXGEXvWJZ+c2g7+z/ylWjJZ9zbj9XyZKDWPIQTnke5jNHHj5ny0f25lovne7q+wy1ncZ0k0q7DNh52qc8atFcsGxvq297afrJ1pH5jix24qNZ69MAQZVGuMyNHdnJ4/05+yQgA1Yygi297uuP6qzNGthhf06V1qTzwg28wet9TRM5erdM32YM00SzEDUCR39vP4MNPFZrXNhXEgoVucVAmLAeVaMCihCoPJoeCRbNVeGxHuKRljsk2uW5bC/ghwcCAE6QLvTz18P28vPsVvC6Yis2hCkgSnBg1HddfmjKNy0I/z2nLO6X3f/QLmOFhqpm8qdpIWXtczdlOHlMEfTn6b3+i3LjMKThrl4vyoJUUBjvZgqXH0OVC/eBos8uiYDiU9c22qJequY7wVDfl9kyS3gP3MXi6jynWAlOxPbxSG4Ck6dI2YS+/TPt5lVUj2zj16Vs4u9c/VZh41lDtvgALUyzT/7OnvYZZfjbzhpWyMOKm0TiJJpQepTw40jAmUp5enbLt09JxZndgRsYol7NtRg1uY9+uXUxxODgVGiDWAi7F4YJufduv6MCky373T+n/7kNUTwadLtuoJ2qDWt/AhiBk4O7d2raGs01XrJblYiqty9iJRhRZUegZqfcXN2mDVq7VIGTaJRzsF36LzDJ08l4GB8tMYTg4FRqgmhX0TxbD1rctMXUrl+nBb/2A0UeeJBrcElM/+2tRSwJT8xgCCrRg+IGDhrG+XPN158lyuS5lfJxEHaLUL4rZnCqvbyFx2ghrVhu6b5BSotzIqQO30H1ygCk0A1N1REx89m6IcY2ee91WDt7wffxj8c0Op8URahMQq+rasDE2CVERSvaJoyYY6so1X71WlAv1KRHiOEkY6hHFViF0Jo2r0whh8EOvQeu+/ex9+qkJ159UTKUGiOoDvEJI53s66PnBo/gnTlTe82K3cZ1qTMwdVDQBFmM7jhvv9LGxlivWinK+ISnBMZKgOEBhfhKr7OLUN6CHRoXXpjQndv+MbPY5d/OaLEwFAeIUaHQEux4o4i7NUtzRS7mrn2oCZrqo/+fDRG0Q99eh8OwpUz59rNB6zXnCKzWkCHGKPvm2AL8+iWvqIZ+n3OA0m/6DD9N17Ai/RBoAqvsRogrZofu6KfcPgz9xhW+6YyIBxs8mpri315T7jhear7vACkp1aa+EIGSsQyJJYckEupBNBcncEZ5+/JGp+gFTeUwcjAs58MGvXZ+fNjVzL4Kz+QXx6xbFfT0mGDyVb7pynVUq1aULeUpzbPyExFUZGB6lvLC9icPb72B0dJRfIg0A1cGbeDj0tNo48RJxtnoEAJvCnm4TjPbkW950gTuSTSVMnvw8FxkmsLRD6Gc7w1brKZ558hmmIBqYDhpg4kJM/Pq5holJo6pPUNzTbYQZLjRcvj41MJTQs0O8lIttkjCcxVvSkOHnt/2QKdB804EA8aOZ8Pe5itqcQQyb/M4u42aKnr1pXaI86ngLQBQVsizwEv5sGtXDHNhziEnWAtPhuPiJQj+XhR9joimI8gS5J0+E6U6jc4tXW81Fy29xsAsWIh9YwSxb8uh9/5dJzgpOBwL8Z8VEv8AGI8g+cTxUnSkZzFthliJFUaBKAr9JtaLyj3D86AkmsV5whgCvL2rNmgZsCAXFXcd1cUGLaF2wyHRqYQ0LjFF14Rx3jMcfvIfqaYOvO2YI8Ppjon9jg6cp7T+pg5ULWD53lvLKqIIWQYPbTL7nPvq6TzNJvsAMASYHEyMDFwoeA3tPmMb1K8zy1mb72Ci6Ptmg29wcOx+5n2ol9etKghkCTA4mOoUSSEA2z6m+Xn3eReuEY6esnrwMFnS2M9jzCAOnupkhwH8aTMwYQiTcJP6pUXK6GL5hywb72KgUyVSrzqQd9jz0M6Lk2OvqC8wQYPJwxinCVFdFXfr39NAwOyOXn7fMOtJHsHT1fPrlQYae3cPrrAVmCDC5mBgaxnslJKf3nwivuGKNlU00y3IhGXYumc2uXXfD0CivoxaYIcDk42ymwKFYKEEhr9dftsnqGrL03I75xpudpee++AZWrwsJZggw9Yi1gE33iQFz3rJWac1fKgpD6I51a9jX+zjh4WOv15fPEGBqUasFbMIwJNc/pC+6+Hw1LDIkC2kjN7TTtftOGKi9dc1rhhkCTB0mrn1Eh2kP9I/Slg5M57rzVW7YMumWxeQzXYw+tPN5rvOqMEOAqUfsD8TH6Fgc399lVi5tE+kFy2RiWGpv/RrGBu+geGiA17h0bIYA0wfVMxT80CPX12fWbzpPmmSzkEGj6W+1GL3rdmYI8J8SE6OCBEODg7S4nmk57wKR8RxZ6Fxoyi3PMrb9APHpmq8BZggwfVAr0OgGlYcPHGXDyg6V6FxFfZiid2Eng9tug2yB18ghnCHA9MHEGe2gtWa494g+b+NGmbBbjGmcy8jsPvL3PcZrdPr4DAGmL2JTkMU2I2bthjcoWU7Q17GQ/kN3QM8Qr4EpmCHA9ELtiiHEJDh24BgrlqfFvIXni6JqNflViuxP7qj5zCvGDAGmJ567VnDiwD6z5vzloq1pPgMti8mlHqf85FFepRaYIcD0RK1Ao1NW8/k8/T3HzOWbLpGZlg5zNJFitPcuOPWqDpuaIcC5gSgqGOjto6FuyGxa+yaG5i6kP/s05Uf3vtoLz2D6ojY3EO2oPnDwBPPaHbl03cXmlJWk/5F7YSzPK4wIZghwbqC6o1r7Ht1H9po3LF4uWy65xhwq7qb42NPMEOA/JWozhDEscrkh8kP7zaXrLye8YDkHtt8Jp7O8AhLMEODcQrWMrKvrOE3BSdZe9ft0c4qhBx7nFawTzBBg+qO2oDSe4VEV0e7de5hf5zDvLb/GfnM7wc6XXT42Q4BzBxPrB6LtY107nmDNpZsJdZqeBx7lZd4MdIYA5ybiWe5SDEbIdu9l1fvfwkjxAGN7+3kZJJghwLmHidvoEwyf6qLcYNO6pJPe+/fyMnyBybh38AxeO9SeqFJ7uzyXIzfeS7giDwvaeBkbSmY0wLmL2vJyCV6RET9P24WKse05zr1jdmbwMhHXELpAqtJc+EAj0SGcU343khnMYAYzmMEMZjCDGcxgBjOYwQxmMIMZTCP8Pzs45kdUAkDrAAAAAElFTkSuQmCC',
//image: './ReddyInfoSoft.png'
},
{
text: 'Sample Main Title', alignment: 'center', fontSize: 14, bold: true, width: 'auto'
//, margin: [0, 10, 0, 0]
}
],
[
{
text:
[
{ text: 'SubTitle1: ', bold: true }, 'Sub title details...1\n',
{ text: 'SubTitle2: ', bold: true }, 'Sub title details...2',
]
}, {}
]
]
},
layout: 'noBorders',
margin: 10
}
});
doc['footer'] = (function (page, pages) {
return {
columns: [
{
alignment: 'left',
text: ['Created Date: ', { text: jsDate.toString() }]
},
{
alignment: 'center',
text: 'Total ' + rcout.toString() + ' rows'
},
{
alignment: 'right',
text: ['page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
}
],
margin: 10
}
});
var objLayout = {};
objLayout['hLineWidth'] = function (i) { return .8; };
objLayout['vLineWidth'] = function (i) { return .5; };
objLayout['hLineColor'] = function (i) { return '#aaa'; };
objLayout['vLineColor'] = function (i) { return '#aaa'; };
objLayout['paddingLeft'] = function (i) { return 5; };
objLayout['paddingRight'] = function (i) { return 35; };
doc.content[doc.content.length - 1].layout = objLayout;
}
}
]
});
});
</script>
</html>
</code></pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-1066844174687054682020-02-03T17:24:00.001+05:302020-02-04T01:17:05.821+05:30Jquery DataTable Custom PDF Export with New ColumnIn this post I 'll show how to Custom PDF Export with New Column(SNo.) using Jquery DataTables.<br />
Previously I had shown..<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-excel-export.html">Jquery DataTable Custom Excel Export</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
</ul>
<br />
<b>Sample OutPut:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/LyMHQ4BQzho/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/LyMHQ4BQzho?feature=player_embedded" width="620"></iframe></div>
<br />
<b>Source Code:</b>
<br />
<a name='more'></a><pre><code class="HTML hljs">
<!DOCTYPE html>
<html lang="en">
<head>
<title>Jquery DataTable Export</title>
</head>
<body>
<table id="tblFeStaging" cellpadding="0" cellspacing="0" border="0" class="display cell-border" style="width:100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>66</td>
<td>2009/01/12</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>22</td>
<td>2012/03/29</td>
<td>$433,060</td>
</tr>
<tr>
<td>Airi Satou</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>33</td>
<td>2008/11/28</td>
<td>$162,700</td>
</tr>
<tr>
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>New York</td>
<td>61</td>
<td>2012/12/02</td>
<td>$372,000</td>
</tr>
<tr>
<td>Herrod Chandler</td>
<td>Sales Assistant</td>
<td>San Francisco</td>
<td>59</td>
<td>2012/08/06</td>
<td>$137,500</td>
</tr>
<tr>
<td>Rhona Davidson</td>
<td>Integration Specialist</td>
<td>Tokyo</td>
<td>55</td>
<td>2010/10/14</td>
<td>$327,900</td>
</tr>
<tr>
<td>Colleen Hurst</td>
<td>Javascript Developer</td>
<td>San Francisco</td>
<td>39</td>
<td>2009/09/15</td>
<td>$205,500</td>
</tr>
<tr>
<td>Sonya Frost</td>
<td>Software Engineer</td>
<td>Edinburgh</td>
<td>23</td>
<td>2008/12/13</td>
<td>$103,600</td>
</tr>
<tr>
<td>Jena Gaines</td>
<td>Office Manager</td>
<td>London</td>
<td>30</td>
<td>2008/12/19</td>
<td>$90,560</td>
</tr>
<tr>
<td>Quinn Flynn</td>
<td>Support Lead</td>
<td>Edinburgh</td>
<td>22</td>
<td>2013/03/03</td>
<td>$342,000</td>
</tr>
<tr>
<td>Charde Marshall</td>
<td>Regional Director</td>
<td>San Francisco</td>
<td>36</td>
<td>2008/10/16</td>
<td>$470,600</td>
</tr>
<tr>
<td>Haley Kennedy</td>
<td>Senior Marketing Designer</td>
<td>London</td>
<td>43</td>
<td>2012/12/18</td>
<td>$313,500</td>
</tr>
<tr>
<td>Tatyana Fitzpatrick</td>
<td>Regional Director</td>
<td>London</td>
<td>19</td>
<td>2010/03/17</td>
<td>$385,750</td>
</tr>
<tr>
<td>Michael Silva</td>
<td>Marketing Designer</td>
<td>London</td>
<td>66</td>
<td>2012/11/27</td>
<td>$198,500</td>
</tr>
<tr>
<td>Paul Byrd</td>
<td>Chief Financial Officer (CFO)</td>
<td>New York</td>
<td>64</td>
<td>2010/06/09</td>
<td>$725,000</td>
</tr>
<tr>
<td>Gloria Little</td>
<td>Systems Administrator</td>
<td>New York</td>
<td>59</td>
<td>2009/04/10</td>
<td>$237,500</td>
</tr>
<tr>
<td>Bradley Greer</td>
<td>Software Engineer</td>
<td>London</td>
<td>41</td>
<td>2012/10/13</td>
<td>$132,000</td>
</tr>
<tr>
<td>Dai Rios</td>
<td>Personnel Lead</td>
<td>Edinburgh</td>
<td>35</td>
<td>2012/09/26</td>
<td>$217,500</td>
</tr>
<tr>
<td>Jenette Caldwell</td>
<td>Development Lead</td>
<td>New York</td>
<td>30</td>
<td>2011/09/03</td>
<td>$345,000</td>
</tr>
<tr>
<td>Yuri Berry</td>
<td>Chief Marketing Officer (CMO)</td>
<td>New York</td>
<td>40</td>
<td>2009/06/25</td>
<td>$675,000</td>
</tr>
<tr>
<td>Caesar Vance</td>
<td>Pre-Sales Support</td>
<td>New York</td>
<td>21</td>
<td>2011/12/12</td>
<td>$106,450</td>
</tr>
<tr>
<td>Doris Wilder</td>
<td>Sales Assistant</td>
<td>Sidney</td>
<td>23</td>
<td>2010/09/20</td>
<td>$85,600</td>
</tr>
<tr>
<td>Angelica Ramos</td>
<td>Chief Executive Officer (CEO)</td>
<td>London</td>
<td>47</td>
<td>2009/10/09</td>
<td>$1,200,000</td>
</tr>
<tr>
<td>Gavin Joyce</td>
<td>Developer</td>
<td>Edinburgh</td>
<td>42</td>
<td>2010/12/22</td>
<td>$92,575</td>
</tr>
<tr>
<td>Jennifer Chang</td>
<td>Regional Director</td>
<td>Singapore</td>
<td>28</td>
<td>2010/11/14</td>
<td>$357,650</td>
</tr>
<tr>
<td>Brenden Wagner</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>28</td>
<td>2011/06/07</td>
<td>$206,850</td>
</tr>
<tr>
<td>Fiona Green</td>
<td>Chief Operating Officer (COO)</td>
<td>San Francisco</td>
<td>48</td>
<td>2010/03/11</td>
<td>$850,000</td>
</tr>
<tr>
<td>Shou Itou</td>
<td>Regional Marketing</td>
<td>Tokyo</td>
<td>20</td>
<td>2011/08/14</td>
<td>$163,000</td>
</tr>
<tr>
<td>Michelle House</td>
<td>Integration Specialist</td>
<td>Sidney</td>
<td>37</td>
<td>2011/06/02</td>
<td>$95,400</td>
</tr>
<tr>
<td>Suki Burks</td>
<td>Developer</td>
<td>London</td>
<td>53</td>
<td>2009/10/22</td>
<td>$114,500</td>
</tr>
<tr>
<td>Prescott Bartlett</td>
<td>Technical Author</td>
<td>London</td>
<td>27</td>
<td>2011/05/07</td>
<td>$145,000</td>
</tr>
<tr>
<td>Gavin Cortez</td>
<td>Team Leader</td>
<td>San Francisco</td>
<td>22</td>
<td>2008/10/26</td>
<td>$235,500</td>
</tr>
<tr>
<td>Martena Mccray</td>
<td>Post-Sales support</td>
<td>Edinburgh</td>
<td>46</td>
<td>2011/03/09</td>
<td>$324,050</td>
</tr>
<tr>
<td>Unity Butler</td>
<td>Marketing Designer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/12/09</td>
<td>$85,675</td>
</tr>
<tr>
<td>Howard Hatfield</td>
<td>Office Manager</td>
<td>San Francisco</td>
<td>51</td>
<td>2008/12/16</td>
<td>$164,500</td>
</tr>
<tr>
<td>Hope Fuentes</td>
<td>Secretary</td>
<td>San Francisco</td>
<td>41</td>
<td>2010/02/12</td>
<td>$109,850</td>
</tr>
<tr>
<td>Vivian Harrell</td>
<td>Financial Controller</td>
<td>San Francisco</td>
<td>62</td>
<td>2009/02/14</td>
<td>$452,500</td>
</tr>
<tr>
<td>Timothy Mooney</td>
<td>Office Manager</td>
<td>London</td>
<td>37</td>
<td>2008/12/11</td>
<td>$136,200</td>
</tr>
<tr>
<td>Jackson Bradshaw</td>
<td>Director</td>
<td>New York</td>
<td>65</td>
<td>2008/09/26</td>
<td>$645,750</td>
</tr>
<tr>
<td>Olivia Liang</td>
<td>Support Engineer</td>
<td>Singapore</td>
<td>64</td>
<td>2011/02/03</td>
<td>$234,500</td>
</tr>
<tr>
<td>Bruno Nash</td>
<td>Software Engineer</td>
<td>London</td>
<td>38</td>
<td>2011/05/03</td>
<td>$163,500</td>
</tr>
<tr>
<td>Sakura Yamamoto</td>
<td>Support Engineer</td>
<td>Tokyo</td>
<td>37</td>
<td>2009/08/19</td>
<td>$139,575</td>
</tr>
<tr>
<td>Thor Walton</td>
<td>Developer</td>
<td>New York</td>
<td>61</td>
<td>2013/08/11</td>
<td>$98,540</td>
</tr>
<tr>
<td>Finn Camacho</td>
<td>Support Engineer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/07/07</td>
<td>$87,500</td>
</tr>
<tr>
<td>Serge Baldwin</td>
<td>Data Coordinator</td>
<td>Singapore</td>
<td>64</td>
<td>2012/04/09</td>
<td>$138,575</td>
</tr>
<tr>
<td>Zenaida Frank</td>
<td>Software Engineer</td>
<td>New York</td>
<td>63</td>
<td>2010/01/04</td>
<td>$125,250</td>
</tr>
<tr>
<td>Zorita Serrano</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>56</td>
<td>2012/06/01</td>
<td>$115,000</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>43</td>
<td>2013/02/01</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>46</td>
<td>2011/12/06</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</td>
<td>47</td>
<td>2011/03/21</td>
<td>$356,250</td>
</tr>
<tr>
<td>Lael Greer</td>
<td>Systems Administrator</td>
<td>London</td>
<td>21</td>
<td>2009/02/27</td>
<td>$103,500</td>
</tr>
<tr>
<td>Jonas Alexander</td>
<td>Developer</td>
<td>San Francisco</td>
<td>30</td>
<td>2010/07/14</td>
<td>$86,500</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2008/11/13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2011/06/27</td>
<td>$183,000</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2011/01/25</td>
<td>$112,000</td>
</tr>
</tbody>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
</table>
</body>
<link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.jqueryui.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/1.6.0/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://code.jquery.com/jquery-3.3.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.jqueryui.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/buttons.html5.min.js" type="text/javascript"></script>
<style>
div.dt-buttons {
position: relative;
float: right !important;
}
</style>
<script type="text/javascript">
$('#tblFeStaging').DataTable({
"ordering": false,
"pageLength": 25,
dom: 'Blrtip',
buttons: [
{
extend: 'pdfHtml5',
title: "Main Title",
pageSize: 'A4',
exportOptions: {
search: 'applied',
order: 'applied',
stripNewlines: false
},
customize: function (doc) {
var rdoc = doc;
var rcout = doc.content[doc.content.length - 1].table.body.length - 1;
doc.content.splice(0, 1);
var now = new Date();
var jsDate = now.getDate() + '/' + (now.getMonth() + 1) + '/' + now.getFullYear() + ' and Time:' + now.getHours() + ':' + now.getMinutes() + ':' + now.getSeconds();
doc.pageMargins = [30, 70, 30, 30];
doc.defaultStyle.fontSize = 8;
doc.styles.tableHeader.fontSize = 9;
doc.content[doc.content.length - 1].table.headerRows = 2;
doc.content[doc.content.length - 1].table.body[0].splice(0, 0, { text: "SNo.", style: "tableHeader" });
var iPlus;
for (var i = 0; i < rcout; i++) {
iPlus = (i + 1);
var obj = doc.content[doc.content.length - 1].table.body[i + 1];
doc.content[doc.content.length - 1].table.body[(i + 1)][0] = { text: obj[0].text, style: [obj[0].style], bold: true };
doc.content[doc.content.length - 1].table.body[(i + 1)][3] = {
text: obj[3].text,
style: [obj[3].style],
alignment: 'center',
bold: obj[3].text > 60 ? true : false,
fillColor: obj[3].text > 60 ? 'red' : null
};
// var cols = [];
// cols[0] = {text: 'Left part', alignment: 'left', margin:[20] };
doc.content[doc.content.length - 1].table.body[iPlus].splice(0, 0, { text: iPlus, style: obj[0].style });
}
doc['header'] = (function (page, pages) {
return {
table: {
widths: ['100%'],
headerRows: 0,
body: [
[{ text: 'Sample Main Title', alignment: 'center', fontSize: 14, bold: true, margin: [0, 10, 0, 0] }],
[
{
text:
[
{ text: 'SubTitle1: ', bold: true }, 'Sub title details...1\n',
{ text: 'SubTitle2: ', bold: true }, 'Sub title details...2',
]
}
]
]
},
layout: 'noBorders',
margin: 10
}
});
doc['footer'] = (function (page, pages) {
return {
columns: [
{
alignment: 'left',
text: ['Created Date: ', { text: jsDate.toString() }]
},
{
alignment: 'center',
text: 'Total ' + rcout.toString() + ' rows'
},
{
alignment: 'right',
text: ['page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
}
],
margin: 10
}
});
var objLayout = {};
objLayout['hLineWidth'] = function (i) { return .8; };
objLayout['vLineWidth'] = function (i) { return .5; };
objLayout['hLineColor'] = function (i) { return '#aaa'; };
objLayout['vLineColor'] = function (i) { return '#aaa'; };
objLayout['paddingLeft'] = function (i) { return 5; };
objLayout['paddingRight'] = function (i) { return 35; };
doc.content[doc.content.length - 1].layout = objLayout;
}
}
]
});
</script>
</html>
</code></pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-657579597934096352020-01-31T03:01:00.000+05:302020-02-03T00:55:31.785+05:30How to Install RealVNC in RaspberryPIIn this video I will show How to Install RealVNC in RaspberryPI<br />
Previously I had shown..<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-create-new-user-and-grant.html">How to create a new user and grant permissions in MySQL</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-connect-mysql-remotely-in-linux.html">How to connect mysql remotely in linux</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/dotnet-core-31-in-raspberry-pi-3.html">DotNet Core 3.1 in Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/remote-debuggingdevelopment-using.html">Remote Debugging or Development using VSCode & SSH in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-remove-black-border-in.html">How to remove Black Border in RaspberryPi OS</a></li>
</ul>
<div>
Video can be shown at the bottom of this post.</div>
<div>
<a name='more'></a><br /></div>
<div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i9.ytimg.com/vi/WTzQsVio8hg/default.jpg?sqp=CIzE3PEF&rs=AOn4CLCcj0m2qB8oJK4UeLoEKslfRRASag" frameborder="0" height="266" src="https://www.youtube.com/embed/WTzQsVio8hg?feature=player_embedded" width="620"></iframe></div>
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-2353831423101632662020-01-31T02:45:00.004+05:302020-01-31T02:45:57.379+05:30How to remove Black Border in RaspberryPi OSIn this video I will show you how to remove Black Border in RaspberryPi OS.<br />
<br />
Previously I had shown..<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-create-new-user-and-grant.html">How to create a new user and grant permissions in MySQL</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-connect-mysql-remotely-in-linux.html">How to connect mysql remotely in linux</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/dotnet-core-31-in-raspberry-pi-3.html">DotNet Core 3.1 in Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/remote-debuggingdevelopment-using.html">Remote Debugging or Development using VSCode & SSH in Raspberry Pi</a></li>
</ul>
<div>
<b>Video and Text can be shown below</b><br />
<br />
<a name='more'></a><br />
<b>Note: </b>This will work on most of the RaspberryPi equipped with raspbian OS!<br />
<br />
This will require only a few clicks.<br />
<ol>
<li>Click on Raspberry Icon in Top Left corner. </li>
<li>Then click preferences, then raspberry pi configurations.</li>
<li>Then Click on Disable "Overscan" and Press OK</li>
<li>It will ask for Reboot. Reboot and</li>
<li>Enjoy not having the ANNOYING black borders.</li>
</ol>
<br />
<b>Video:</b><br />
<br />
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/1nVyErJrkCw/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/1nVyErJrkCw?feature=player_embedded" width="620"></iframe></div>
<div>
<br />
<br />
<br />
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-73737201372077537062020-01-08T00:52:00.001+05:302020-01-08T01:01:05.955+05:30Remote Debugging or Development using VSCode & SSH in Raspberry PiIn this post I will show you, How to create .Net Core Application in Raspberry Pi 3<br />
Previously I had shown..
<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-create-new-user-and-grant.html">How to create a new user and grant permissions in MySQL</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-connect-mysql-remotely-in-linux.html">How to connect mysql remotely in linux</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/dotnet-core-31-in-raspberry-pi-3.html">DotNet Core 3.1 in Raspberry Pi 3</a></li>
</ul>
<div>
<b>OutPut:</b></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/1M2LizPwsTw/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/1M2LizPwsTw?feature=player_embedded" width="620"></iframe></div>
<div>
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-49967600889410445772020-01-07T01:23:00.001+05:302020-01-07T01:28:56.497+05:30DotNet Core 3.1 in Raspberry Pi 3In this post I will show you, How to create .Net Core Application in Raspberry Pi 3<br />
Previously I had shown..
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-create-new-user-and-grant.html">How to create a new user and grant permissions in MySQL</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-connect-mysql-remotely-in-linux.html">How to connect mysql remotely in linux</a></li>
</ul>
<div>
<b>Output:</b></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/4vc5-1R2oxQ/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/4vc5-1R2oxQ?feature=player_embedded" width="620"></iframe></div>
<div>
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-8217229687779363712020-01-05T17:05:00.000+05:302020-01-07T17:12:47.907+05:30How to connect mysql remotely in linuxIn this post I will show you, How to create a new user and grant permissions in MySQL<br />
<br />
Previously I had shown..
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-create-new-user-and-grant.html">How to create a new user and grant permissions in MySQL</a></li>
</ul>
<div>
Config file Paths in different operating systems. Lets check the paths as shown and open in nano using below command</div>
<a name='more'></a><br />
MySQL in Ubuntu 16:
<br />
<pre><code class="bash html hljs">
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
</code></pre>
MariaDB in Raspberry Pi:
<br />
<pre><code class="bash html hljs">
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
</code></pre>
Locate bind-address and change as shown. This will allow to connect with any IP address
<br />
<pre><code class="bash html hljs">
bind-address = 0.0.0.0
</code></pre>
Now restart mysql.
<br />
<pre><code class="bash html hljs">
sudo systemctl restart mysql.service
sudo systemctl restart mariadb.service
</code></pre>
Now login to MySQL with root
<br />
<pre><code class="bash html hljs">
mysql -u root -p
</code></pre>
Now grant permission as shown
<br />
<pre><code class="bash html hljs">
GRANT ALL privileges ON *.* TO username@'%' IDENTIFIED BY 'user_password';
FLUSH PRIVILEGES;
quit;
</code></pre>
Ones again restart MySQL
<br />
<pre><code class="bash html hljs">
sudo systemctl restart mariadb.service
</code></pre>
Now connect with Mysql GUI tools from other computers. Here I'm using HeidiSQL.<br />
<b>[Note:]</b> Hostname/IP = MySQL Installed OS IP Address.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtcOpF58uRUoHpQqrD60sLDlx-rfQs6RO1Ileap4weTO2cZaLXIgm56P5BaXZDkRZCvqxO46dlE1YAY7n6Be1pof_hu39gIT-ITSzOdLCVsZUhzkmfFl96lcMOChgi9yu-k8dc-QH6YRem/s1600/MySQl+GUI+1.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="425" data-original-width="706" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtcOpF58uRUoHpQqrD60sLDlx-rfQs6RO1Ileap4weTO2cZaLXIgm56P5BaXZDkRZCvqxO46dlE1YAY7n6Be1pof_hu39gIT-ITSzOdLCVsZUhzkmfFl96lcMOChgi9yu-k8dc-QH6YRem/s400/MySQl+GUI+1.PNG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJzdXTiFuybtOm3GF0c-SdCnHW6KTo4o_xiVMA2OBXOOMxCmRC1Rv0Y1igJugGGQ8ppjmwEQlTWyIy0InVXgPM97JbH83kOKZ_W8PsnqJ7AbhdCfZcJ7Yr4L3hmlWkBgIRmnr4yPTyfax8/s1600/MySQl+GUI+2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="514" data-original-width="787" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJzdXTiFuybtOm3GF0c-SdCnHW6KTo4o_xiVMA2OBXOOMxCmRC1Rv0Y1igJugGGQ8ppjmwEQlTWyIy0InVXgPM97JbH83kOKZ_W8PsnqJ7AbhdCfZcJ7Yr4L3hmlWkBgIRmnr4yPTyfax8/s400/MySQl+GUI+2.PNG" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Command to connect
<br />
<pre><code class="bash html hljs">
mysql -h mysql server ip -u root -p
Ex: mysql -h 192.168.1.20 -u root -p
</code></pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-73072941974995681382020-01-05T14:19:00.002+05:302020-01-05T14:25:28.928+05:30How to create a new user and grant permissions in MySQLIn this post I will show you, how to create a new user and grant permissions in MySQL<br />
<br />
Previously I had shown..
<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">How to Install MySQL/MariaDB in Raspberry Pi</a></li>
</ul>
<div>
Continuing the previous <a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-mysqlmariadb-in.html">POST</a> login to MySQl from terminal using below command</div>
<pre><code class="bash html hljs">
sudo mysql -u root -p
</code>
</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRdTlmO1MF2dHfAa8ETTVYxl7RSHBcbXXYq4nO3Q3gE31U20VQzaQzO3HaRFZgRsS-OYgFhIeBi6r9OWQhES1ft2294V24NYR9OHmmN5bpCpTtY7ziQ89FMn98B1O9P6O5JDDk7kTp_WA/s1600/2020-01-05-135649_1364x768_scrot.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1364" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRdTlmO1MF2dHfAa8ETTVYxl7RSHBcbXXYq4nO3Q3gE31U20VQzaQzO3HaRFZgRsS-OYgFhIeBi6r9OWQhES1ft2294V24NYR9OHmmN5bpCpTtY7ziQ89FMn98B1O9P6O5JDDk7kTp_WA/s640/2020-01-05-135649_1364x768_scrot.png" width="640" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<a name='more'></a><br />
Create New User using below command
<pre><code class="bash html hljs">
CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'user_password';
</code>
</pre>
Create New DB
<pre><code class="bash html hljs">
create database 'new_DB';
</code>
</pre>
Grant Permissions on a particular DB for user
<pre><code class="bash html hljs">
GRANT ALL PRIVILEGES ON new_DB.* TO 'user_name'@'localhost';
</code>
</pre>
Grant Permissions on all DB'S for user
<pre><code class="bash html hljs">
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'localhost';
</code>
</pre>Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-25899593082641843232020-01-05T13:38:00.003+05:302020-01-05T13:58:26.699+05:30How to Install MySQL/MariaDB in Raspberry PiIn this post I will show you how to Install MySQL/MariaDB in Raspberry Pi<br />
Previously I had shown..
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-add-static-ip-address-in.html">How to ADD static IP Address in Raspberry Pi</a></li>
</ul>
<div>
Before Install Mysql, update Raspberry Pi OS using below commands
<br />
<pre><code class="html bash hljs">
sudo apt-get update
sudo apt-get upgrade
</code>
</pre>
Now Install MySQL using below command
<br />
<a name='more'></a><br />
<pre><code class="html bash hljs">
sudo apt-get install mariadb-server
</code>
</pre>
Ones MySQL is installed, execute below command for configuration
<br />
<pre><code class="html bash hljs">
sudo mysql_secure_installation
</code>
</pre>
and follow the instructions based on your requirements.
After configuration is completed, login to MySQL using below command.
<br />
<pre><code class="html bash hljs">
sudo mysql -u root -p
</code>
</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQk964dRlYQGNJcYx02LBKhChT4t6ZnTVrPZTX8hJJZoM2LBTlyRlpXYPMN-Y-9d7-DwnLpr2MTfTQ3_rOk-V34jTlEb7zTyYGZZ4UAbciK8gyYubPWNRoGOdw8DeQXE0HU9SdT-yf7JKT/s1600/2020-01-05-135649_1364x768_scrot.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1364" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQk964dRlYQGNJcYx02LBKhChT4t6ZnTVrPZTX8hJJZoM2LBTlyRlpXYPMN-Y-9d7-DwnLpr2MTfTQ3_rOk-V34jTlEb7zTyYGZZ4UAbciK8gyYubPWNRoGOdw8DeQXE0HU9SdT-yf7JKT/s640/2020-01-05-135649_1364x768_scrot.png" width="640" /></a></div>
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-17598216829220294892020-01-05T02:50:00.001+05:302020-01-05T03:03:11.005+05:30How to ADD static IP Address in Raspberry PiIn this post I will show you how to ADD static IP Address in Raspberry Pi<br />
Previously I had shown..
<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/ln-failed-to-create-symbolic-link.html">ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists</a></li>
</ul>
<div>
use below command to open <b>dhcpcd.conf</b> in nano file editor</div>
<div>
<a name='more'></a>before that <strong>check whether DHCPCD is activated or not</strong></div>
<pre>If it is not activated, follow below commands</pre>
<pre><code class="html bash hljs">
sudo service dhcpcd start
sudo systemctl enable dhcpcd
</code></pre>
then open file with below command
<pre><code class="html bash hljs">
sudo nano /etc/dhcpcd.conf
</code>
</pre>
eth0 = wired, wlan0 = wireless<br />
<br />
append below lines and save.<br />
<br />
eth0 is the <b>LAN</b> port<br />
<br />
<pre>
<code class="html bash hljs">
interface eth0
static ip_address=192.168.1.20
static routers=192.168.1.1
static domain_name_servers=192.168.1.1
</code>
</pre>
in the same way for <b>Wifi</b> also<br />
wlan0 is the <b>Wifi</b><br />
<pre>
<code class="html bash hljs">
interface wlan0
static ip_address=192.168.1.22
static routers=192.168.1.1
static domain_name_servers=192.168.1.1
</code>
</pre>
<br />
ones done, You can use<br />
remote Desktop,<br />
VNC client<br />
etc....Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-38667180588825413422020-01-05T02:33:00.001+05:302020-01-05T02:35:47.811+05:30ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File existsIn this post I will show you how to solve <b>ln: failed to create symbolic link</b>.<br />
Previously I had shown..
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-net-core-31-on-raspberry.html#more">How to Install .Net Core 3.1 on Raspberry Pi 3</a></li>
</ul>
<div>
<div>
<pre><code class="html bash hljs">
sudo ln -sf "/usr/share/dotnet/dotnet" "/usr/bin/dotnet"
</code>
</pre>
</div>
<div>
<b>To remove Link:</b></div>
<div>
<pre><code class="html bash hljs">
sudo rm -rf /usr/bin/dotnet
sudo ln -s "/usr/share/dotnet/dotnet" "/usr/bin/dotnet"
</code>
</pre>
</div>
</div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-78960364325943754762020-01-05T01:54:00.002+05:302020-01-05T02:27:37.672+05:30How to Install .Net Core 3.1 on Raspberry Pi 3In this post I will show you how to Install .Net Core 3.1 in Raspberry Pi.<br />
Previously I had shown..<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2020/01/how-to-install-linux-on-raspberry-pi-3.html">How to Install Linux on Raspberry Pi 3</a></li>
</ul>
<div>
Download .Net Core from <a href="https://dotnet.microsoft.com/download/dotnet-core/3.1">HERE</a>.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_8WLh9VbBbyKyQKxvoxxdDRNRiPQMnY34AVsh4QK_GtHAgdmXAILszgeUJPWVrni0p1qfYTohr_msTWvr6E629rj9bBWEEP4Fm4Qp2B4b3gcKGCLutfcP0AMLuPmeM4RACmfSnrzsdv5L/s1600/core.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="709" data-original-width="1117" height="406" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_8WLh9VbBbyKyQKxvoxxdDRNRiPQMnY34AVsh4QK_GtHAgdmXAILszgeUJPWVrni0p1qfYTohr_msTWvr6E629rj9bBWEEP4Fm4Qp2B4b3gcKGCLutfcP0AMLuPmeM4RACmfSnrzsdv5L/s640/core.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<a name='more'></a>Before Downloading there is no .Net core Installer or deb file for Raspberry. So download ARM Binary file. </div>
<div>
<br /></div>
<div>
Before that pls check which Binary file is required to Download. </div>
<div>
Check Raspberry Pi 3 processor with below Command
<br />
<pre><code class="html bash hljs">
uname -m
#or
cat /proc/cpuinfo
</code>
</pre>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWZ4OceQWcUAULnaF0UnjbtNT4dHDHMDLr1EoKfyzvCYsCTlWBMZeoelYpZvr-_kEqNVxxrkLw2A8knMk4mUBULQf2zpP2Hg2nLjRbNKvTfm9fr8gB02zMcVUd9vWtmzNilm-zi_RNsTmV/s1600/2020-01-05-015144_1364x768_scrot.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1364" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWZ4OceQWcUAULnaF0UnjbtNT4dHDHMDLr1EoKfyzvCYsCTlWBMZeoelYpZvr-_kEqNVxxrkLw2A8knMk4mUBULQf2zpP2Hg2nLjRbNKvTfm9fr8gB02zMcVUd9vWtmzNilm-zi_RNsTmV/s640/2020-01-05-015144_1364x768_scrot.png" width="640" /></a></div>
<div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
I am using Raspbery PI 3<br />
If processor is 64 then download 64 bit SDK else 32 bit SDK.<br />
<br />
<b>Download .Net Core 3.1 SDK:</b><br />
<b>32 bit:</b> <a href="https://download.visualstudio.microsoft.com/download/pr/67766a96-eb8c-4cd2-bca4-ea63d2cc115c/7bf13840aa2ed88793b7315d5e0d74e6/dotnet-sdk-3.1.100-linux-arm.tar.gz">.Net Core sdk 3.1.100 ARM</a><br />
<b>64 bit:</b> <a href="https://download.visualstudio.microsoft.com/download/pr/5a4c8f96-1c73-401c-a6de-8e100403188a/0ce6ab39747e2508366d498f9c0a0669/dotnet-sdk-3.1.100-linux-arm64.tar.gz">.Net Core sdk 3.1.100 ARM 64bit</a><br />
<br />
<b>Make Directory:</b> sudo mkdir /usr/share/dotnet/<br />
<b>PATH </b><b>For Current Session:</b><br />
export PATH=$PATH:/usr/share/dotnet/dotnet<br />
export DOTNET_ROOT=/usr/share/dotnet/dotnet<br />
<br />
<b>For Permanent Session after ReBoot:</b><br />
For every session use below command based on installed path<br />
sudo ln -s /usr/share/dotnet /usr/bin/dotnet<br />
#OR<br />
sudo ln -s $HOME/dotnet/dotnet /usr/bin/dotnet<br />
<br />
<b>Extract:</b> sudo tar zxf dotnet-sdk-3.1.100-linux-arm.tar.gz -C /usr/share/dotnet/<br />
<b>Confirm Installation:</b> dotnet --info<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2rcFix991yPYjdRjzB4U94fwTaq-WKjhly0R7H45oA1Sn7DVRW7wCDkVcmxebaki3xymDY-GG3edEEarqhDIg3ZeWuwKdTh1YBCrdvhyzarg8_Apv9hyphenhyphen0jALvmrqeDPsnERpAecI-f25V/s1600/2020-01-05-022056_1364x768_scrot.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1364" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2rcFix991yPYjdRjzB4U94fwTaq-WKjhly0R7H45oA1Sn7DVRW7wCDkVcmxebaki3xymDY-GG3edEEarqhDIg3ZeWuwKdTh1YBCrdvhyzarg8_Apv9hyphenhyphen0jALvmrqeDPsnERpAecI-f25V/s640/2020-01-05-022056_1364x768_scrot.png" width="640" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-66465087377284753682020-01-05T01:10:00.001+05:302020-01-30T02:17:46.622+05:30How to Install Linux on Raspberry Pi 3In this post I will inform..<br />
<br />
<b><span style="font-family: "calibri" , "sans-serif"; font-size: 29.0pt; line-height: 115%;">How to Install Linux on Raspberry
Pi 3</span></b><br />
<br />
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 10.0pt;">Hardware Requirements:</span></b></div>
<div class="MsoNormal">
</div>
<ul>
<li><span style="text-indent: -18pt;">Raspberry Pi 3</span></li>
<li><span style="text-indent: -18pt;">SD Card 8GB minimum</span></li>
<li><span style="text-indent: -18pt;">Mobile recharge Adapter min 2Amphs</span></li>
<li><span style="text-indent: -18pt;">Monitor + Keyboard & Mouse</span></li>
<li><span style="text-indent: -18pt;">HDMI Cable</span></li>
</ul>
<div style="text-indent: -24px;">
<b>OutPut:</b></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/oBzyemQcPqk/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/oBzyemQcPqk?feature=player_embedded" width="620"></iframe></div>
<div style="text-indent: -24px;">
<br /></div>
<div style="text-indent: -24px;">
<a name='more'></a></div>
<div style="text-indent: -24px;">
<br /></div>
<br />
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 10.0pt;">Software
Requirements:<o:p></o:p></span></b></div>
<div class="MsoNormal">
</div>
<ul>
<li><span style="text-indent: -18pt;">Download OS from </span><b style="text-indent: -18pt;">https://www.raspberrypi.org/downloads/</b><span style="text-indent: -18pt;"> </span><span style="background: yellow; text-indent: -18pt;">(I'm using Raspbian Buster)</span></li>
<li><span style="text-indent: -18pt;">Download Rufus from </span><span style="text-indent: -18pt;"> </span><b style="text-indent: -18pt;">https://rufus.ie/</b></li>
</ul>
<div style="text-indent: -24px;">
<b><br /></b></div>
<br />
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 10.0pt;">Install Raspbian
on sd card:<o:p></o:p></span></b></div>
<div class="MsoNormal">
</div>
<ul>
<li>Open Rufus, select device & raspberry zip file and press start.</li>
<li>after completing insert SD card in Raspberry Pi 3 and do the
procedure as shown on the screen.</li>
</ul>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-45632058604515926792019-11-17T19:50:00.000+05:302019-11-17T19:51:33.757+05:30Few LINQ Tips that are usefullHere are some tips in LINQ that are usefull in regular<br />
<br />
Here are they...<br />
<br />
<ul>
<li>Joins using Lambada Expressions</li>
<li>Multi select using Lambada Expression</li>
<li>Left join in Linq</li>
<li>How would you do a “not in” query with LINQ?</li>
</ul>
<a name='more'></a><br />
<b>Joins using Lambada Expressions</b><br />
<pre><code class="Linq hljs">
Object AccountObject = _dbContext.Accounts
.Join(_dbContext.Users, acc => acc.AccountId, usr => usr.AccountId, (acc, usr) => new { acc, usr })
.Where(x => x.usr.EmailAddress == key1)
.Where(x => x.usr.Hash == key2)
.Select(x => new { AccountId = x.acc.AccountId, Name = x.acc.Name })
.SingleOrDefault();
</code></pre>
<br />
<b>multi select using lambada expression
</b><br />
<pre><code class="Linq hljs">
Object AccountObject = _dbContext.Accounts
.Join(_dbContext.Users, acc => acc.AccountId, usr => usr.AccountId, (acc, usr) => new { acc, usr })
.Where(x => x.usr.EmailAddress == key1)
.Where(x => x.usr.Hash == key2)
.Select(x => new { AccountId = x.acc.AccountId, Name = x.acc.Name })
.SingleOrDefault();
</code></pre>
<br />
<b>Left Join In Linq
</b>
<br />
<pre><code class="Linq hljs">
var query = from person in people
join pet in pets on person equals pet.Owner into gj
from subpet in gj.DefaultIfEmpty()
select new { person.FirstName, PetName = subpet?.Name ?? String.Empty };
OR
var q =
from c in categories
join p in products on c.Category equals p.Category into ps
from p in ps.DefaultIfEmpty()
select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName };
</code></pre>
<br />
<b>How would you do a “not in” query with LINQ?</b>
<br />
<pre><code class="Linq hljs">
var query = from c in dc.Customers where !(from o in dc.Orders select o.CustomerID)
.Contains(c.CustomerID)
select c;
</code></pre>
<br />Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-37301172926888884452019-11-17T18:51:00.000+05:302019-11-17T18:52:46.635+05:30Jquery DataTable Custom Excel ExportIn this post I will show Custom Excel Export using Jquery DataTable.<br />
Previously I had shown how to<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.com/2019/11/jquery-datatable-custom-pdf-export.html">Jquery DataTable Custom PDF Export</a></li>
</ul>
<div>
<b>Sample OutPut:</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijIu7VNecxHk1E8crzceLTbK_KeTTPDrhYRES7R1V4z8xpFspOI_DAHpajeiZIqJS7eHJsN8yYHCoxsIiZxXgjc6GsmuZRjntP_XeUtfzfZIURlta8l_d6FhbAsZd9HaxG6FzA6M_1khc-/s1600/Jquery+DT+Excel+Export_2019-11-17_184242.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="236" data-original-width="500" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijIu7VNecxHk1E8crzceLTbK_KeTTPDrhYRES7R1V4z8xpFspOI_DAHpajeiZIqJS7eHJsN8yYHCoxsIiZxXgjc6GsmuZRjntP_XeUtfzfZIURlta8l_d6FhbAsZd9HaxG6FzA6M_1khc-/s1600/Jquery+DT+Excel+Export_2019-11-17_184242.gif" /></a></div>
<div>
<br /></div>
<div>
<b>Source Code:</b></div>
<a name='more'></a><br />
<pre><code class="ubuntu hljs">
<!DOCTYPE html>
<html lang="en">
<head>
<title>Jquery DataTable Export</title>
</head>
<body>
<table id="tblFeStaging" cellpadding="0" cellspacing="0" border="0" class="display cell-border" style="width:100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>66</td>
<td>2009/01/12</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>22</td>
<td>2012/03/29</td>
<td>$433,060</td>
</tr>
<tr>
<td>Airi Satou</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>33</td>
<td>2008/11/28</td>
<td>$162,700</td>
</tr>
<tr>
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>New York</td>
<td>61</td>
<td>2012/12/02</td>
<td>$372,000</td>
</tr>
<tr>
<td>Herrod Chandler</td>
<td>Sales Assistant</td>
<td>San Francisco</td>
<td>59</td>
<td>2012/08/06</td>
<td>$137,500</td>
</tr>
<tr>
<td>Rhona Davidson</td>
<td>Integration Specialist</td>
<td>Tokyo</td>
<td>55</td>
<td>2010/10/14</td>
<td>$327,900</td>
</tr>
<tr>
<td>Colleen Hurst</td>
<td>Javascript Developer</td>
<td>San Francisco</td>
<td>39</td>
<td>2009/09/15</td>
<td>$205,500</td>
</tr>
<tr>
<td>Sonya Frost</td>
<td>Software Engineer</td>
<td>Edinburgh</td>
<td>23</td>
<td>2008/12/13</td>
<td>$103,600</td>
</tr>
<tr>
<td>Jena Gaines</td>
<td>Office Manager</td>
<td>London</td>
<td>30</td>
<td>2008/12/19</td>
<td>$90,560</td>
</tr>
<tr>
<td>Quinn Flynn</td>
<td>Support Lead</td>
<td>Edinburgh</td>
<td>22</td>
<td>2013/03/03</td>
<td>$342,000</td>
</tr>
<tr>
<td>Charde Marshall</td>
<td>Regional Director</td>
<td>San Francisco</td>
<td>36</td>
<td>2008/10/16</td>
<td>$470,600</td>
</tr>
<tr>
<td>Haley Kennedy</td>
<td>Senior Marketing Designer</td>
<td>London</td>
<td>43</td>
<td>2012/12/18</td>
<td>$313,500</td>
</tr>
<tr>
<td>Tatyana Fitzpatrick</td>
<td>Regional Director</td>
<td>London</td>
<td>19</td>
<td>2010/03/17</td>
<td>$385,750</td>
</tr>
<tr>
<td>Michael Silva</td>
<td>Marketing Designer</td>
<td>London</td>
<td>66</td>
<td>2012/11/27</td>
<td>$198,500</td>
</tr>
<tr>
<td>Paul Byrd</td>
<td>Chief Financial Officer (CFO)</td>
<td>New York</td>
<td>64</td>
<td>2010/06/09</td>
<td>$725,000</td>
</tr>
<tr>
<td>Gloria Little</td>
<td>Systems Administrator</td>
<td>New York</td>
<td>59</td>
<td>2009/04/10</td>
<td>$237,500</td>
</tr>
<tr>
<td>Bradley Greer</td>
<td>Software Engineer</td>
<td>London</td>
<td>41</td>
<td>2012/10/13</td>
<td>$132,000</td>
</tr>
<tr>
<td>Dai Rios</td>
<td>Personnel Lead</td>
<td>Edinburgh</td>
<td>35</td>
<td>2012/09/26</td>
<td>$217,500</td>
</tr>
<tr>
<td>Jenette Caldwell</td>
<td>Development Lead</td>
<td>New York</td>
<td>30</td>
<td>2011/09/03</td>
<td>$345,000</td>
</tr>
<tr>
<td>Yuri Berry</td>
<td>Chief Marketing Officer (CMO)</td>
<td>New York</td>
<td>40</td>
<td>2009/06/25</td>
<td>$675,000</td>
</tr>
<tr>
<td>Caesar Vance</td>
<td>Pre-Sales Support</td>
<td>New York</td>
<td>21</td>
<td>2011/12/12</td>
<td>$106,450</td>
</tr>
<tr>
<td>Doris Wilder</td>
<td>Sales Assistant</td>
<td>Sidney</td>
<td>23</td>
<td>2010/09/20</td>
<td>$85,600</td>
</tr>
<tr>
<td>Angelica Ramos</td>
<td>Chief Executive Officer (CEO)</td>
<td>London</td>
<td>47</td>
<td>2009/10/09</td>
<td>$1,200,000</td>
</tr>
<tr>
<td>Gavin Joyce</td>
<td>Developer</td>
<td>Edinburgh</td>
<td>42</td>
<td>2010/12/22</td>
<td>$92,575</td>
</tr>
<tr>
<td>Jennifer Chang</td>
<td>Regional Director</td>
<td>Singapore</td>
<td>28</td>
<td>2010/11/14</td>
<td>$357,650</td>
</tr>
<tr>
<td>Brenden Wagner</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>28</td>
<td>2011/06/07</td>
<td>$206,850</td>
</tr>
<tr>
<td>Fiona Green</td>
<td>Chief Operating Officer (COO)</td>
<td>San Francisco</td>
<td>48</td>
<td>2010/03/11</td>
<td>$850,000</td>
</tr>
<tr>
<td>Shou Itou</td>
<td>Regional Marketing</td>
<td>Tokyo</td>
<td>20</td>
<td>2011/08/14</td>
<td>$163,000</td>
</tr>
<tr>
<td>Michelle House</td>
<td>Integration Specialist</td>
<td>Sidney</td>
<td>37</td>
<td>2011/06/02</td>
<td>$95,400</td>
</tr>
<tr>
<td>Suki Burks</td>
<td>Developer</td>
<td>London</td>
<td>53</td>
<td>2009/10/22</td>
<td>$114,500</td>
</tr>
<tr>
<td>Prescott Bartlett</td>
<td>Technical Author</td>
<td>London</td>
<td>27</td>
<td>2011/05/07</td>
<td>$145,000</td>
</tr>
<tr>
<td>Gavin Cortez</td>
<td>Team Leader</td>
<td>San Francisco</td>
<td>22</td>
<td>2008/10/26</td>
<td>$235,500</td>
</tr>
<tr>
<td>Martena Mccray</td>
<td>Post-Sales support</td>
<td>Edinburgh</td>
<td>46</td>
<td>2011/03/09</td>
<td>$324,050</td>
</tr>
<tr>
<td>Unity Butler</td>
<td>Marketing Designer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/12/09</td>
<td>$85,675</td>
</tr>
<tr>
<td>Howard Hatfield</td>
<td>Office Manager</td>
<td>San Francisco</td>
<td>51</td>
<td>2008/12/16</td>
<td>$164,500</td>
</tr>
<tr>
<td>Hope Fuentes</td>
<td>Secretary</td>
<td>San Francisco</td>
<td>41</td>
<td>2010/02/12</td>
<td>$109,850</td>
</tr>
<tr>
<td>Vivian Harrell</td>
<td>Financial Controller</td>
<td>San Francisco</td>
<td>62</td>
<td>2009/02/14</td>
<td>$452,500</td>
</tr>
<tr>
<td>Timothy Mooney</td>
<td>Office Manager</td>
<td>London</td>
<td>37</td>
<td>2008/12/11</td>
<td>$136,200</td>
</tr>
<tr>
<td>Jackson Bradshaw</td>
<td>Director</td>
<td>New York</td>
<td>65</td>
<td>2008/09/26</td>
<td>$645,750</td>
</tr>
<tr>
<td>Olivia Liang</td>
<td>Support Engineer</td>
<td>Singapore</td>
<td>64</td>
<td>2011/02/03</td>
<td>$234,500</td>
</tr>
<tr>
<td>Bruno Nash</td>
<td>Software Engineer</td>
<td>London</td>
<td>38</td>
<td>2011/05/03</td>
<td>$163,500</td>
</tr>
<tr>
<td>Sakura Yamamoto</td>
<td>Support Engineer</td>
<td>Tokyo</td>
<td>37</td>
<td>2009/08/19</td>
<td>$139,575</td>
</tr>
<tr>
<td>Thor Walton</td>
<td>Developer</td>
<td>New York</td>
<td>61</td>
<td>2013/08/11</td>
<td>$98,540</td>
</tr>
<tr>
<td>Finn Camacho</td>
<td>Support Engineer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/07/07</td>
<td>$87,500</td>
</tr>
<tr>
<td>Serge Baldwin</td>
<td>Data Coordinator</td>
<td>Singapore</td>
<td>64</td>
<td>2012/04/09</td>
<td>$138,575</td>
</tr>
<tr>
<td>Zenaida Frank</td>
<td>Software Engineer</td>
<td>New York</td>
<td>63</td>
<td>2010/01/04</td>
<td>$125,250</td>
</tr>
<tr>
<td>Zorita Serrano</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>56</td>
<td>2012/06/01</td>
<td>$115,000</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>43</td>
<td>2013/02/01</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>46</td>
<td>2011/12/06</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</td>
<td>47</td>
<td>2011/03/21</td>
<td>$356,250</td>
</tr>
<tr>
<td>Lael Greer</td>
<td>Systems Administrator</td>
<td>London</td>
<td>21</td>
<td>2009/02/27</td>
<td>$103,500</td>
</tr>
<tr>
<td>Jonas Alexander</td>
<td>Developer</td>
<td>San Francisco</td>
<td>30</td>
<td>2010/07/14</td>
<td>$86,500</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2008/11/13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2011/06/27</td>
<td>$183,000</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2011/01/25</td>
<td>$112,000</td>
</tr>
</tbody>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
</table>
</body>
<link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.jqueryui.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/1.6.0/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://code.jquery.com/jquery-3.3.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.jqueryui.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/buttons.html5.min.js" type="text/javascript"></script>
<style>
div.dt-buttons {
position: relative;
float: right !important;
}
</style>
<script type="text/javascript">
$(document).ready(function () {
var buttonExcel = {
exportOptions: {
format: {
body: function (data, row, column, node) {
var fdata = "";
if (column === 3)
fdata = node.innerText;
else
fdata = node.innerText;
return fdata;
}
}
}
};
$('#tblFeStaging').DataTable({
"ordering": false,
"pageLength": 25,
dom: 'Blrtip',
buttons: [
$.extend(true, {}, buttonExcel, {
extend: 'excelHtml5',
title: "Main Title",
messageTop: 'Sample Message on top of the Table.....',
customize: function (xlsx) {
var sheet = xlsx.xl.worksheets['sheet1.xml'];
$('row:gt(2) c', sheet).attr('s', '55'); //<-- wrapped text
$('row:gt(1) c[r^=A]', sheet).attr('s', '2'); // Bold First Column
$('row:eq(2) c', sheet).attr('s', '32');
}
})
]
});
});
</script>
</html>
</code></pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-71935497304553820432019-11-17T18:26:00.000+05:302019-11-17T18:52:04.058+05:30Jquery DataTable Custom PDF ExportIn this post I 'll show how to Custom PDF Export using Jquery DataTables.<br />
<br />
<b>Sample OutPut:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdFOP9cJygRqsidUjdGwq7SRr4cr8UpS3S4lhugvIyDgOtxm0Gng-XLW0fV7VJscrGXcDdaOkxflo5vf2lj-Wnexf1e96WkwznYUaEWtnRLoDowKlQQmsQ6v_P98ZiWbL_r1P0LaZrjA3H/s1600/Jquery+DT+PDF+Export_2019-11-17_175557.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="236" data-original-width="500" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdFOP9cJygRqsidUjdGwq7SRr4cr8UpS3S4lhugvIyDgOtxm0Gng-XLW0fV7VJscrGXcDdaOkxflo5vf2lj-Wnexf1e96WkwznYUaEWtnRLoDowKlQQmsQ6v_P98ZiWbL_r1P0LaZrjA3H/s1600/Jquery+DT+PDF+Export_2019-11-17_175557.gif" /></a></div>
<br />
<b>Source Code:</b>
<br />
<a name='more'></a><pre><code class="HTML hljs">
<!DOCTYPE html>
<html lang="en">
<head>
<title>Jquery DataTable Export</title>
</head>
<body>
<table id="tblFeStaging" cellpadding="0" cellspacing="0" border="0" class="display cell-border" style="width:100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>66</td>
<td>2009/01/12</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>22</td>
<td>2012/03/29</td>
<td>$433,060</td>
</tr>
<tr>
<td>Airi Satou</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>33</td>
<td>2008/11/28</td>
<td>$162,700</td>
</tr>
<tr>
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>New York</td>
<td>61</td>
<td>2012/12/02</td>
<td>$372,000</td>
</tr>
<tr>
<td>Herrod Chandler</td>
<td>Sales Assistant</td>
<td>San Francisco</td>
<td>59</td>
<td>2012/08/06</td>
<td>$137,500</td>
</tr>
<tr>
<td>Rhona Davidson</td>
<td>Integration Specialist</td>
<td>Tokyo</td>
<td>55</td>
<td>2010/10/14</td>
<td>$327,900</td>
</tr>
<tr>
<td>Colleen Hurst</td>
<td>Javascript Developer</td>
<td>San Francisco</td>
<td>39</td>
<td>2009/09/15</td>
<td>$205,500</td>
</tr>
<tr>
<td>Sonya Frost</td>
<td>Software Engineer</td>
<td>Edinburgh</td>
<td>23</td>
<td>2008/12/13</td>
<td>$103,600</td>
</tr>
<tr>
<td>Jena Gaines</td>
<td>Office Manager</td>
<td>London</td>
<td>30</td>
<td>2008/12/19</td>
<td>$90,560</td>
</tr>
<tr>
<td>Quinn Flynn</td>
<td>Support Lead</td>
<td>Edinburgh</td>
<td>22</td>
<td>2013/03/03</td>
<td>$342,000</td>
</tr>
<tr>
<td>Charde Marshall</td>
<td>Regional Director</td>
<td>San Francisco</td>
<td>36</td>
<td>2008/10/16</td>
<td>$470,600</td>
</tr>
<tr>
<td>Haley Kennedy</td>
<td>Senior Marketing Designer</td>
<td>London</td>
<td>43</td>
<td>2012/12/18</td>
<td>$313,500</td>
</tr>
<tr>
<td>Tatyana Fitzpatrick</td>
<td>Regional Director</td>
<td>London</td>
<td>19</td>
<td>2010/03/17</td>
<td>$385,750</td>
</tr>
<tr>
<td>Michael Silva</td>
<td>Marketing Designer</td>
<td>London</td>
<td>66</td>
<td>2012/11/27</td>
<td>$198,500</td>
</tr>
<tr>
<td>Paul Byrd</td>
<td>Chief Financial Officer (CFO)</td>
<td>New York</td>
<td>64</td>
<td>2010/06/09</td>
<td>$725,000</td>
</tr>
<tr>
<td>Gloria Little</td>
<td>Systems Administrator</td>
<td>New York</td>
<td>59</td>
<td>2009/04/10</td>
<td>$237,500</td>
</tr>
<tr>
<td>Bradley Greer</td>
<td>Software Engineer</td>
<td>London</td>
<td>41</td>
<td>2012/10/13</td>
<td>$132,000</td>
</tr>
<tr>
<td>Dai Rios</td>
<td>Personnel Lead</td>
<td>Edinburgh</td>
<td>35</td>
<td>2012/09/26</td>
<td>$217,500</td>
</tr>
<tr>
<td>Jenette Caldwell</td>
<td>Development Lead</td>
<td>New York</td>
<td>30</td>
<td>2011/09/03</td>
<td>$345,000</td>
</tr>
<tr>
<td>Yuri Berry</td>
<td>Chief Marketing Officer (CMO)</td>
<td>New York</td>
<td>40</td>
<td>2009/06/25</td>
<td>$675,000</td>
</tr>
<tr>
<td>Caesar Vance</td>
<td>Pre-Sales Support</td>
<td>New York</td>
<td>21</td>
<td>2011/12/12</td>
<td>$106,450</td>
</tr>
<tr>
<td>Doris Wilder</td>
<td>Sales Assistant</td>
<td>Sidney</td>
<td>23</td>
<td>2010/09/20</td>
<td>$85,600</td>
</tr>
<tr>
<td>Angelica Ramos</td>
<td>Chief Executive Officer (CEO)</td>
<td>London</td>
<td>47</td>
<td>2009/10/09</td>
<td>$1,200,000</td>
</tr>
<tr>
<td>Gavin Joyce</td>
<td>Developer</td>
<td>Edinburgh</td>
<td>42</td>
<td>2010/12/22</td>
<td>$92,575</td>
</tr>
<tr>
<td>Jennifer Chang</td>
<td>Regional Director</td>
<td>Singapore</td>
<td>28</td>
<td>2010/11/14</td>
<td>$357,650</td>
</tr>
<tr>
<td>Brenden Wagner</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>28</td>
<td>2011/06/07</td>
<td>$206,850</td>
</tr>
<tr>
<td>Fiona Green</td>
<td>Chief Operating Officer (COO)</td>
<td>San Francisco</td>
<td>48</td>
<td>2010/03/11</td>
<td>$850,000</td>
</tr>
<tr>
<td>Shou Itou</td>
<td>Regional Marketing</td>
<td>Tokyo</td>
<td>20</td>
<td>2011/08/14</td>
<td>$163,000</td>
</tr>
<tr>
<td>Michelle House</td>
<td>Integration Specialist</td>
<td>Sidney</td>
<td>37</td>
<td>2011/06/02</td>
<td>$95,400</td>
</tr>
<tr>
<td>Suki Burks</td>
<td>Developer</td>
<td>London</td>
<td>53</td>
<td>2009/10/22</td>
<td>$114,500</td>
</tr>
<tr>
<td>Prescott Bartlett</td>
<td>Technical Author</td>
<td>London</td>
<td>27</td>
<td>2011/05/07</td>
<td>$145,000</td>
</tr>
<tr>
<td>Gavin Cortez</td>
<td>Team Leader</td>
<td>San Francisco</td>
<td>22</td>
<td>2008/10/26</td>
<td>$235,500</td>
</tr>
<tr>
<td>Martena Mccray</td>
<td>Post-Sales support</td>
<td>Edinburgh</td>
<td>46</td>
<td>2011/03/09</td>
<td>$324,050</td>
</tr>
<tr>
<td>Unity Butler</td>
<td>Marketing Designer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/12/09</td>
<td>$85,675</td>
</tr>
<tr>
<td>Howard Hatfield</td>
<td>Office Manager</td>
<td>San Francisco</td>
<td>51</td>
<td>2008/12/16</td>
<td>$164,500</td>
</tr>
<tr>
<td>Hope Fuentes</td>
<td>Secretary</td>
<td>San Francisco</td>
<td>41</td>
<td>2010/02/12</td>
<td>$109,850</td>
</tr>
<tr>
<td>Vivian Harrell</td>
<td>Financial Controller</td>
<td>San Francisco</td>
<td>62</td>
<td>2009/02/14</td>
<td>$452,500</td>
</tr>
<tr>
<td>Timothy Mooney</td>
<td>Office Manager</td>
<td>London</td>
<td>37</td>
<td>2008/12/11</td>
<td>$136,200</td>
</tr>
<tr>
<td>Jackson Bradshaw</td>
<td>Director</td>
<td>New York</td>
<td>65</td>
<td>2008/09/26</td>
<td>$645,750</td>
</tr>
<tr>
<td>Olivia Liang</td>
<td>Support Engineer</td>
<td>Singapore</td>
<td>64</td>
<td>2011/02/03</td>
<td>$234,500</td>
</tr>
<tr>
<td>Bruno Nash</td>
<td>Software Engineer</td>
<td>London</td>
<td>38</td>
<td>2011/05/03</td>
<td>$163,500</td>
</tr>
<tr>
<td>Sakura Yamamoto</td>
<td>Support Engineer</td>
<td>Tokyo</td>
<td>37</td>
<td>2009/08/19</td>
<td>$139,575</td>
</tr>
<tr>
<td>Thor Walton</td>
<td>Developer</td>
<td>New York</td>
<td>61</td>
<td>2013/08/11</td>
<td>$98,540</td>
</tr>
<tr>
<td>Finn Camacho</td>
<td>Support Engineer</td>
<td>San Francisco</td>
<td>47</td>
<td>2009/07/07</td>
<td>$87,500</td>
</tr>
<tr>
<td>Serge Baldwin</td>
<td>Data Coordinator</td>
<td>Singapore</td>
<td>64</td>
<td>2012/04/09</td>
<td>$138,575</td>
</tr>
<tr>
<td>Zenaida Frank</td>
<td>Software Engineer</td>
<td>New York</td>
<td>63</td>
<td>2010/01/04</td>
<td>$125,250</td>
</tr>
<tr>
<td>Zorita Serrano</td>
<td>Software Engineer</td>
<td>San Francisco</td>
<td>56</td>
<td>2012/06/01</td>
<td>$115,000</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>43</td>
<td>2013/02/01</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>46</td>
<td>2011/12/06</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</td>
<td>47</td>
<td>2011/03/21</td>
<td>$356,250</td>
</tr>
<tr>
<td>Lael Greer</td>
<td>Systems Administrator</td>
<td>London</td>
<td>21</td>
<td>2009/02/27</td>
<td>$103,500</td>
</tr>
<tr>
<td>Jonas Alexander</td>
<td>Developer</td>
<td>San Francisco</td>
<td>30</td>
<td>2010/07/14</td>
<td>$86,500</td>
</tr>
<tr>
<td>Shad Decker</td>
<td>Regional Director</td>
<td>Edinburgh</td>
<td>51</td>
<td>2008/11/13</td>
<td>$183,000</td>
</tr>
<tr>
<td>Michael Bruce</td>
<td>Javascript Developer</td>
<td>Singapore</td>
<td>29</td>
<td>2011/06/27</td>
<td>$183,000</td>
</tr>
<tr>
<td>Donna Snider</td>
<td>Customer Support</td>
<td>New York</td>
<td>27</td>
<td>2011/01/25</td>
<td>$112,000</td>
</tr>
</tbody>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
</table>
</body>
<link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/1.10.20/css/dataTables.jqueryui.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/1.6.0/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://code.jquery.com/jquery-3.3.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.jqueryui.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.6.0/js/buttons.html5.min.js" type="text/javascript"></script>
<style>
div.dt-buttons {
position: relative;
float: right !important;
}
</style>
<script type="text/javascript">
$('#tblFeStaging').DataTable({
"ordering": false,
"pageLength": 25,
dom: 'Blrtip',
buttons: [
{
extend: 'pdfHtml5',
title: "Main Title",
pageSize: 'A4',
exportOptions: {
search: 'applied',
order: 'applied',
stripNewlines: false
},
customize: function (doc) {
var rdoc = doc;
var rcout = doc.content[doc.content.length - 1].table.body.length - 1;
doc.content.splice(0, 1);
var now = new Date();
var jsDate = now.getDate() + '/' + (now.getMonth() + 1) + '/' + now.getFullYear() + ' and Time:' + now.getHours() + ':' + now.getMinutes() + ':' + now.getSeconds();
doc.pageMargins = [30, 70, 30, 30];
doc.defaultStyle.fontSize = 8;
doc.styles.tableHeader.fontSize = 9;
doc.content[doc.content.length - 1].table.headerRows = 2;
for (var i = 0; i < rcout; i++) {
var obj = doc.content[doc.content.length - 1].table.body[i + 1];
doc.content[doc.content.length - 1].table.body[(i + 1)][0] = { text: obj[0].text, style: [obj[0].style], bold: true };
doc.content[doc.content.length - 1].table.body[(i + 1)][3] = {
text: obj[3].text,
style: [obj[3].style],
alignment: 'center',
bold: obj[3].text > 60 ? true : false,
fillColor: obj[3].text > 60 ? 'red' : null
};
}
doc['header'] = (function (page, pages) {
return {
table: {
widths: ['100%'],
headerRows: 0,
body: [
[{ text: 'Sample Main Title', alignment: 'center', fontSize: 14, bold: true, margin: [0, 10, 0, 0] }],
[
{
text:
[
{ text: 'SubTitle1: ', bold: true }, 'Sub title details...1\n',
{ text: 'SubTitle2: ', bold: true }, 'Sub title details...2',
]
}
]
]
},
layout: 'noBorders',
margin: 10
}
});
doc['footer'] = (function (page, pages) {
return {
columns: [
{
alignment: 'left',
text: ['Created Date: ', { text: jsDate.toString() }]
},
{
alignment: 'center',
text: 'Total ' + rcout.toString() + ' rows'
},
{
alignment: 'right',
text: ['page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
}
],
margin: 10
}
});
var objLayout = {};
objLayout['hLineWidth'] = function (i) { return .8; };
objLayout['vLineWidth'] = function (i) { return .5; };
objLayout['hLineColor'] = function (i) { return '#aaa'; };
objLayout['vLineColor'] = function (i) { return '#aaa'; };
objLayout['paddingLeft'] = function (i) { return 5; };
objLayout['paddingRight'] = function (i) { return 35; };
doc.content[doc.content.length - 1].layout = objLayout;
}
}
]
});
</script>
</html>
</code></pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-28506635383074413392018-11-17T19:12:00.000+05:302019-11-17T19:13:44.426+05:30Rewrite URLs or Enable with mod_rewrite for Apache2 on Ubuntu 16.04In this POST I will show how to enable mod_rewrite for apache2<br />
<br />
First, we need to install Apache2, Before that Update Ubuntu with below command.<br />
<pre><code class="ubuntu hljs">
sudo apt-get update
</code>
</pre>
Install Apache<br />
<pre><code class="ubuntu hljs">
sudo apt-get install apache2
</code>
</pre>
Now activate mod_rewrite using below command
<br />
<a name='more'></a><pre><code class="ubuntu hljs">
sudo a2enmod rewrite
</code>
</pre>
Restart Apache Server
<br />
<pre><code class="ubuntu hljs">
sudo systemctl restart apache2
or
sudo service apache2 restart
</code>
</pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-68481989007255955572018-07-15T21:43:00.001+05:302018-07-15T21:49:36.270+05:30error unknown filesystem entering rescue mode grub rescue ubuntuIn this POST I will show how to get rid of
<br />
<pre><code class="ubuntu hljs">
error: unknown filesystem.
Entering rescue mode...
grub rescue</code></pre>
Switch on the System, wait untill you get the Grub Rescue Screen.<br />
Type the following commands
<br />
<br />
<br />
<br />
<li>ls</li>
It will display list of partions you had in your system.<br />
You will get something like this <b>(hd0),(hd0,msdos1)(hd0,msdos2)(hd0,msdos3)</b> based on no of partitions
<br />
<br />
<li><b>set prefix= (hd0,msdos1)/boot/grub</b></li>
If it’s not the root drive you will get an error message "unknown filesystem". In that case try the same command with the next partion.<br />
You need to find which drive is Ubuntu root. For that type the following:
<br />
Ex: <b>set prefix=(hd0,msdos2)/boot/grub</b>
<br />
<li>set prefix=(hd0,msdos1)/boot/grub</li>
<li>insmod normal</li>
<li>normal</li>
<li>sudo update-grub</li>
<li>sudo grub-install /dev/sda</li>
<br />
If you are not getting an error: You can proceed to the next command after that:
<br />
Your PC will now boot successfully. Now select Ubuntu & login.
<br />
Open Terminal( Ctr+Alt+T or use the search)<br />
Now the bootloader error is fixed you should be able to boot your System normally & even your data is intact.
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-8042737669441724252018-01-29T22:49:00.000+05:302018-01-30T19:36:39.309+05:30How to get Geolocation with out using domain name or SSL connectionIn this post I will show how to get Geolocation with out using domain name or SSL connection. In the previous <a href="http://reddyinfosoft.blogspot.in/2018/01/how-to-get-geolocation-in-html.html">POST</a> I had shown how to get Geolocation using html.<br />
In the previous post its not possible to get Geolocation with out using SSL connection or Domain Name.<br />
<br />
<ul>
<li><a href="http://reddyinfosoft.blogspot.in/2018/01/how-to-get-geolocation-in-html.html">How to Get Geolocation in HTML</a></li>
</ul>
<div>
<b>OutPut:</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://i67.tinypic.com/2rzfh5d.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://i67.tinypic.com/2rzfh5d.jpg" data-original-height="270" data-original-width="750" height="143" width="400" /></a></div>
<div>
<br /></div>
<div>
<a name='more'></a><br /></div>
Create a html file and pste the below code.
<br />
<pre><code class="html hljs">
<!DOCTYPE html>
<html>
<body>
<div style="width:40%">
<center>
<hr>
<p>Click on the below button to get your coordinates.</p>
<hr>
<button onclick="tryAPIGeolocation()" class="btn btn-primary">Get Location</button>
<hr>
<div id="div_gioloc" style="color:yellow; background-color: green; border-radius: 18px;"></div>
</center>
</div>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script>
var x = document.getElementById("div_gioloc");
x.innerHTML = "Latitude: 0 <br>Longitude: 0";
var apiGeolocationSuccess = function (position) {
x.innerHTML = "Latitude: '" + position.coords.latitude + "' <br>Longitude: '" + position.coords.longitude +
"'";
};
var tryAPIGeolocation = function () {
jQuery.post(
"https://www.googleapis.com/geolocation/v1/geolocate?key=AIzaSyDCa1LUe1vOczX1hO_iGYgyo8p_jYuGOPU",
function (success) {
apiGeolocationSuccess({
coords: {
latitude: success.location.lat,
longitude: success.location.lng
}
});
})
.fail(function (err) {
x.innerHTML = "API Geolocation error! <br><br>" + err;
});
};
var browserGeolocationSuccess = function (position) {
x.innerHTML = "Browser geolocation success!<br><br>Latitude = " + position.coords.latitude +
"<br>Longitude = " + position.coords
.longitude;
};
var browserGeolocationFail = function (error) {
switch (error.code) {
case error.TIMEOUT:
x.innerHTML = "Browser geolocation error !<br><br>Timeout.";
break;
case error.PERMISSION_DENIED:
if (error.message.indexOf("Only secure origins are allowed") == 0) {
tryAPIGeolocation();
}
break;
case error.POSITION_UNAVAILABLE:
// dirty hack for safari
if (error.message.indexOf("Origin does not have permission to use Geolocation service") == 0) {
tryAPIGeolocation();
} else {
x.innerHTML = "Browser geolocation error !<br><br>Position unavailable.";
}
break;
}
};
var tryGeolocation = function () {
if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(
browserGeolocationSuccess,
browserGeolocationFail, {
maximumAge: 50000,
timeout: 20000,
enableHighAccuracy: true
});
}
};
</script>
</body>
</html>
</code>
</pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0tag:blogger.com,1999:blog-8400153297838302157.post-71863087516890737002018-01-29T22:19:00.001+05:302018-01-29T22:21:40.248+05:30How to Get Geolocation in HTMLIn this post I will show how to get Geolocation.<br />
<br />
<b>OutPut:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://i67.tinypic.com/2rzfh5d.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://i67.tinypic.com/2rzfh5d.jpg" data-original-height="270" data-original-width="750" height="143" width="400" /></a></div>
<br />
<br />
<a name='more'></a>Create a HTML file and copy paste the below HTML code.<br />
<br />
<pre><code class="html hljs">
<!DOCTYPE html>
<html>
<body>
<div style="width:40%">
<center>
<hr>
<p>Click on the below button to get your coordinates.</p>
<hr>
<button onclick="getLocation()" class="btn btn-primary">Get Location</button>
<hr>
<div id="div_gioloc" style="color:yellow; background-color: green; border-radius: 18px;"></div>
</center>
</div>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</body>
</html>
</code>
</pre>
Then copy paste the below code after script tag
<br />
<pre><code class="ubuntu hljs">
<script>
var x = document.getElementById("div_gioloc");
x.innerHTML = "Latitude: 0 <br>Longitude: 0";
function getLocation() {
if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(showPosition, showError);
} else {
x.innerHTML = "Geolocation is not supported by this browser.";
}
}
function showPosition(position) {
x.innerHTML = "Latitude: " + position.coords.latitude +
"<br>Longitude: " + position.coords.longitude;
}
function showError(error) {
switch (error.code) {
case error.PERMISSION_DENIED:
x.innerHTML = "User denied the request for Geolocation."
break;
case error.POSITION_UNAVAILABLE:
x.innerHTML = "Location information is unavailable."
break;
case error.TIMEOUT:
x.innerHTML = "The request to get user location timed out."
break;
case error.UNKNOWN_ERROR:
x.innerHTML = "An unknown error occurred."
break;
}
}
</script>
</code>
</pre>
The entire code looks as shown below
<pre>
<code class="ubuntu hljs">
<!DOCTYPE html>
<html>
<body>
<div style="width:40%">
<center>
<hr>
<p>Click on the below button to get your coordinates.</p>
<hr>
<button onclick="getLocation()" class="btn btn-primary">Get Location</button>
<hr>
<div id="div_gioloc" style="color:yellow; background-color: green; border-radius: 18px;"></div>
</center>
</div>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script>
var x = document.getElementById("div_gioloc");
x.innerHTML = "Latitude: 0 <br>Longitude: 0";
function getLocation() {
if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(showPosition, showError);
} else {
x.innerHTML = "Geolocation is not supported by this browser.";
}
}
function showPosition(position) {
x.innerHTML = "Latitude: " + position.coords.latitude +
"<br>Longitude: " + position.coords.longitude;
}
function showError(error) {
switch (error.code) {
case error.PERMISSION_DENIED:
x.innerHTML = "User denied the request for Geolocation."
break;
case error.POSITION_UNAVAILABLE:
x.innerHTML = "Location information is unavailable."
break;
case error.TIMEOUT:
x.innerHTML = "The request to get user location timed out."
break;
case error.UNKNOWN_ERROR:
x.innerHTML = "An unknown error occurred."
break;
}
}
</script>
</body>
</html>
</code>
</pre>
Varahttp://www.blogger.com/profile/05211691176860833881noreply@blogger.com0