ReddyInfoSoft

Parameterised Stored procedure with select query and output parameter

noreply@blogger.com (Vara) — Tue, 06 Feb 2024 16:14:00 +0000

create proc sp_test_select_output

(

@id int,

@rtnval int output

)

begin

select * from tblCities;

select @rtnval = @@ROWCOUNT;

end

--declare @output int;

--exec sp_test_select_output 0, @output output;

--select @output as 'OUT PUT'

RaspberryPi Remote Desktop windows 10 OR Install XRDP in RaspberryPi

noreply@blogger.com (Vara) — Sun, 12 Apr 2020 18:49:00 +0000

In this Post I will show how to install XRDP in RaspberryPi
or
How to connect RaspberryPi from Windows using Remote Desktop.

Previously I had shown you

OutPut:

Before we install the required package in RaspberryPi, lets update using below command


 sudo apt-get update

To connect RaspberryPi we need to install xrdp.
Xrdp is an open-source implementation of the Microsoft Remote Desktop Protocol (RDP) that allows you to graphically control a remote system.
Install xrdp using below command


 sudo apt-get install xrdp

System.IO.IOException: Failed to bind to address https://127.0.0.1:5001: address already in use.

noreply@blogger.com (Vara) — Fri, 10 Apr 2020 14:14:00 +0000

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...
Before that previously I had shown you

Solution:
In VS Code navigate to .vscode and open launch.json and replace args with below line.


"args": ["urls=http://localhost:5002"]

Unable to configure HTTPS endpoint. No server certificate was specified, and the default developer certificate could not be found or is out of date.

noreply@blogger.com (Vara) — Fri, 10 Apr 2020 13:57:00 +0000

In this post I will show you how to solved the Issue. Here I am using VS Code.
Previously I had shown

To solve this problem I had generated certificates as described in the error message as shown below.
To generate a developer certificate run 'dotnet dev-certs https'.
To trust the certificate (Windows and macOS only) run 'dotnet dev-certs https --trust'.
But no use.

Don't worry there is a solution.

Steps for solution:

Close all browsers, so that they do not cache the certificate because that will cause other issues.
In the command line run


dotnet dev-certs https --clean

Now to trust the Certificates run below command in the Command Prompt


dotnet dev-certs https -t

Now You can then check the certificate with below Command.


dotnet dev-certs https --check

Now run the project. Problem solved.

The entity type '' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.

noreply@blogger.com (Vara) — Fri, 10 Apr 2020 13:27:00 +0000

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()'.

In the previous post I had shown

Source Code
Add [key] attribute to primary key field with namespace System.ComponentModel.DataAnnotations;

Jquery DataTable Custom PDF Export with logo

noreply@blogger.com (Vara) — Mon, 03 Feb 2020 12:32:00 +0000

In this post I 'll show how to Custom PDF Export with logo using Jquery DataTables.
Previously I had shown..

Sample OutPut:

Source Code:


<!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>

Jquery DataTable Custom PDF Export with New Column

noreply@blogger.com (Vara) — Mon, 03 Feb 2020 11:54:00 +0000

In this post I 'll show how to Custom PDF Export with New Column(SNo.) using Jquery DataTables.
Previously I had shown..

Sample OutPut:

Source Code:


<!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>

How to Install RealVNC in RaspberryPI

noreply@blogger.com (Vara) — Thu, 30 Jan 2020 21:31:00 +0000

In this video I will show How to Install RealVNC in RaspberryPI
Previously I had shown..

Video can be shown at the bottom of this post.

How to remove Black Border in RaspberryPi OS

noreply@blogger.com (Vara) — Thu, 30 Jan 2020 21:15:00 +0000

In this video I will show you how to remove Black Border in RaspberryPi OS.

Previously I had shown..

Video and Text can be shown below

Note: This will work on most of the RaspberryPi equipped with raspbian OS!

This will require only a few clicks.

Click on Raspberry Icon in Top Left corner.
Then click preferences, then raspberry pi configurations.
Then Click on Disable "Overscan" and Press OK
It will ask for Reboot. Reboot and
Enjoy not having the ANNOYING black borders.

Video:

Remote Debugging or Development using VSCode & SSH in Raspberry Pi

noreply@blogger.com (Vara) — Tue, 07 Jan 2020 19:22:00 +0000

In this post I will show you, How to create .Net Core Application in Raspberry Pi 3
Previously I had shown..

OutPut:

DotNet Core 3.1 in Raspberry Pi 3

noreply@blogger.com (Vara) — Mon, 06 Jan 2020 19:53:00 +0000

In this post I will show you, How to create .Net Core Application in Raspberry Pi 3
Previously I had shown..

Output:

How to connect mysql remotely in linux

noreply@blogger.com (Vara) — Sun, 05 Jan 2020 11:35:00 +0000

In this post I will show you, How to create a new user and grant permissions in MySQL

Previously I had shown..

Config file Paths in different operating systems. Lets check the paths as shown and open in nano using below command

MySQL in Ubuntu 16:


sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

MariaDB in Raspberry Pi:


sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Locate bind-address and change as shown. This will allow to connect with any IP address


bind-address = 0.0.0.0

Now restart mysql.


sudo systemctl restart mysql.service
sudo systemctl restart mariadb.service

Now login to MySQL with root


mysql -u root -p

Now grant permission as shown


GRANT ALL privileges ON *.* TO username@'%' IDENTIFIED BY 'user_password';
FLUSH PRIVILEGES;
quit;

Ones again restart MySQL


sudo systemctl restart mariadb.service

Now connect with Mysql GUI tools from other computers. Here I'm using HeidiSQL.
[Note:] Hostname/IP = MySQL Installed OS IP Address.

Command to connect


mysql -h mysql server ip -u root -p
Ex: mysql -h 192.168.1.20 -u root -p

How to create a new user and grant permissions in MySQL

noreply@blogger.com (Vara) — Sun, 05 Jan 2020 08:49:00 +0000

In this post I will show you, how to create a new user and grant permissions in MySQL

Previously I had shown..

Continuing the previous POST login to MySQl from terminal using below command


sudo mysql -u root -p

Create New User using below command


CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'user_password';

Create New DB


create database 'new_DB';

Grant Permissions on a particular DB for user


GRANT ALL PRIVILEGES ON new_DB.* TO 'user_name'@'localhost';

Grant Permissions on all DB'S for user


GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'localhost';

How to Install MySQL/MariaDB in Raspberry Pi

noreply@blogger.com (Vara) — Sun, 05 Jan 2020 08:08:00 +0000

In this post I will show you how to Install MySQL/MariaDB in Raspberry Pi
Previously I had shown..

Before Install Mysql, update Raspberry Pi OS using below commands


sudo apt-get update
sudo apt-get upgrade

Now Install MySQL using below command


sudo apt-get install mariadb-server

Ones MySQL is installed, execute below command for configuration


sudo mysql_secure_installation

and follow the instructions based on your requirements. After configuration is completed, login to MySQL using below command.


sudo mysql -u root -p

How to ADD static IP Address in Raspberry Pi

noreply@blogger.com (Vara) — Sat, 04 Jan 2020 21:20:00 +0000

In this post I will show you how to ADD static IP Address in Raspberry Pi
Previously I had shown..

use below command to open dhcpcd.conf in nano file editor

before that check whether DHCPCD is activated or not

If it is not activated, follow below commands


sudo service dhcpcd start
sudo systemctl enable dhcpcd

then open file with below command


sudo nano /etc/dhcpcd.conf

eth0 = wired, wlan0 = wireless

append below lines and save.

eth0 is the LAN port


interface eth0
static ip_address=192.168.1.20
static routers=192.168.1.1
static domain_name_servers=192.168.1.1

in the same way for Wifi also
wlan0 is the Wifi


interface wlan0
static ip_address=192.168.1.22
static routers=192.168.1.1
static domain_name_servers=192.168.1.1

ones done, You can use
remote Desktop,
VNC client
etc....

ln: failed to create symbolic link '/usr/bin/dotnet/dotnet': File exists

noreply@blogger.com (Vara) — Sat, 04 Jan 2020 21:03:00 +0000

In this post I will show you how to solve ln: failed to create symbolic link.
Previously I had shown..


sudo ln -sf "/usr/share/dotnet/dotnet" "/usr/bin/dotnet"

To remove Link:


sudo rm -rf /usr/bin/dotnet
sudo ln -s "/usr/share/dotnet/dotnet" "/usr/bin/dotnet"

How to Install .Net Core 3.1 on Raspberry Pi 3

noreply@blogger.com (Vara) — Sat, 04 Jan 2020 20:24:00 +0000

In this post I will show you how to Install .Net Core 3.1 in Raspberry Pi.
Previously I had shown..

How to Install Linux on Raspberry Pi 3

Download .Net Core from HERE.

Before Downloading there is no .Net core Installer or deb file for Raspberry. So download ARM Binary file.

Before that pls check which Binary file is required to Download.

Check Raspberry Pi 3 processor with below Command


 uname -m
 #or
 cat /proc/cpuinfo

I am using Raspbery PI 3
If processor is 64 then download 64 bit SDK else 32 bit SDK.

Download .Net Core 3.1 SDK:
32 bit: .Net Core sdk 3.1.100 ARM
64 bit: .Net Core sdk 3.1.100 ARM 64bit

Make Directory: sudo mkdir /usr/share/dotnet/
PATH For Current Session:
export PATH=$PATH:/usr/share/dotnet/dotnet
export DOTNET_ROOT=/usr/share/dotnet/dotnet

For Permanent Session after ReBoot:
For every session use below command based on installed path
sudo ln -s /usr/share/dotnet /usr/bin/dotnet
#OR
sudo ln -s $HOME/dotnet/dotnet /usr/bin/dotnet

Extract: sudo tar zxf dotnet-sdk-3.1.100-linux-arm.tar.gz -C /usr/share/dotnet/
Confirm Installation: dotnet --info

How to Install Linux on Raspberry Pi 3

noreply@blogger.com (Vara) — Sat, 04 Jan 2020 19:40:00 +0000

In this post I will inform..

How to Install Linux on Raspberry Pi 3

Hardware Requirements:

Raspberry Pi 3
SD Card 8GB minimum
Mobile recharge Adapter min 2Amphs
Monitor + Keyboard & Mouse
HDMI Cable

OutPut:

Software Requirements:

Download OS from https://www.raspberrypi.org/downloads/ (I'm using Raspbian Buster)
Download Rufus from https://rufus.ie/

Install Raspbian on sd card:

Open Rufus, select device & raspberry zip file and press start.
after completing insert SD card in Raspberry Pi 3 and do the procedure as shown on the screen.

Few LINQ Tips that are usefull

noreply@blogger.com (Vara) — Sun, 17 Nov 2019 14:20:00 +0000

Here are some tips in LINQ that are usefull in regular

Here are they...

Joins using Lambada Expressions
Multi select using Lambada Expression
Left join in Linq
How would you do a “not in” query with LINQ?

Joins using Lambada Expressions


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();

multi select using lambada expression


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();

Left Join In Linq


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 };

How would you do a “not in” query with LINQ?


var query =  from c in dc.Customers where !(from o in dc.Orders select o.CustomerID)
             .Contains(c.CustomerID)    
             select c;

Jquery DataTable Custom Excel Export

noreply@blogger.com (Vara) — Sun, 17 Nov 2019 13:21:00 +0000

In this post I will show Custom Excel Export using Jquery DataTable.
Previously I had shown how to

Jquery DataTable Custom PDF Export

Sample OutPut:

Source Code:


<!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>

Jquery DataTable Custom PDF Export

noreply@blogger.com (Vara) — Sun, 17 Nov 2019 12:56:00 +0000

In this post I 'll show how to Custom PDF Export using Jquery DataTables.

Sample OutPut:

Source Code:


<!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>

Rewrite URLs or Enable with mod_rewrite for Apache2 on Ubuntu 16.04

noreply@blogger.com (Vara) — Sat, 17 Nov 2018 13:42:00 +0000

In this POST I will show how to enable mod_rewrite for apache2

First, we need to install Apache2, Before that Update Ubuntu with below command.


sudo apt-get update

Install Apache


sudo apt-get install apache2

Now activate mod_rewrite using below command


sudo a2enmod rewrite

Restart Apache Server


sudo systemctl restart apache2
or
sudo service apache2 restart

error unknown filesystem entering rescue mode grub rescue ubuntu

noreply@blogger.com (Vara) — Sun, 15 Jul 2018 16:13:00 +0000

In this POST I will show how to get rid of


error: unknown filesystem.
Entering rescue mode...
grub rescue

Switch on the System, wait untill you get the Grub Rescue Screen.
Type the following commands

It will display list of partions you had in your system.
You will get something like this (hd0),(hd0,msdos1)(hd0,msdos2)(hd0,msdos3) based on no of partitions

set prefix= (hd0,msdos1)/boot/grub

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.
You need to find which drive is Ubuntu root. For that type the following:
Ex: set prefix=(hd0,msdos2)/boot/grub

set prefix=(hd0,msdos1)/boot/grub

insmod normal

normal

sudo update-grub

sudo grub-install /dev/sda

If you are not getting an error: You can proceed to the next command after that:
Your PC will now boot successfully. Now select Ubuntu & login.
Open Terminal( Ctr+Alt+T or use the search)
Now the bootloader error is fixed you should be able to boot your System normally & even your data is intact.

How to get Geolocation with out using domain name or SSL connection

noreply@blogger.com (Vara) — Mon, 29 Jan 2018 17:19:00 +0000

In this post I will show how to get Geolocation with out using domain name or SSL connection. In the previous POST I had shown how to get Geolocation using html.
In the previous post its not possible to get Geolocation with out using SSL connection or Domain Name.

How to Get Geolocation in HTML

OutPut:

Create a html file and pste the below code.


<!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>

How to Get Geolocation in HTML

noreply@blogger.com (Vara) — Mon, 29 Jan 2018 16:49:00 +0000

In this post I will show how to get Geolocation.

OutPut:

Create a HTML file and copy paste the below HTML code.


<!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>

Then copy paste the below code after script tag


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

The entire code looks as shown below


<!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>