@extends('layouts.payrollapp')

@section('content')
<div class="row">&nbsp;</div>
<div class="row">
    <div class="col-md-12">
        <table class=" table table-responsive table-striped">
            <thead>
                <tr>
                    <th>SL No.</th><th>Programs</th><th>Sanction Order</th><th>Bank Summary</th><th>Credit Transfer Order</th><th>Challan</th>
                </tr>
            </thead>
        @php
            $i = 1;
        @endphp
        @foreach($programs AS $value)
        <tr>
        <td>{{$i}}</td><th>{{$value['program_name']}}</th><td><button type="button" class="btn btn-outline-warning waves-effect sanction" data-program="{{$value['program_id']}}"><i class="fa fa-download" aria-hidden="true"></i></button>
            
           </td><td> 
            <button type="button" class="btn btn-outline-secondary waves-effect bank-summary " data-program="{{$value['program_id']}}" data-program_name="{{$value['program_name']}}"><i class="fa fa-download" aria-hidden="true"></i></button>
            </td>
            <td><button type="button" class="btn btn-outline-primary waves-effect credit-transfer" data-program="{{$value['program_id']}}" ><i class="fa fa-download" aria-hidden="true"></i></button></td>
            <td><button type="button" class="btn btn-outline-info waves-effect challan" data-program="{{$value['program_id']}}"><i class="fa fa-download" aria-hidden="true"></i></button></td>
        </tr
        @php
            $i++;
        @endphp
        @endforeach
        </table>
                 
          
        
    </div>
    
</div>
<div class="row">
    <div class="col-md-12" >
        <table id="myTable" hidden>
            <tr>
                <th><b>Month</b></th><td id="month-data"></td>
                <th><b>Year</b></th><td id="year-data"></td>
            </tr>
            <tr>
                <th><b>Program Name</b></th><td id="program-data"></td>
            </tr>
            <tr>
                <th><b>Districts</b></th><td id="district-data"></td>
            </tr>
            <tr>
                <th><b>SL No.</b></th><th><b>No of Employees</b></th><th><b>Designation</b></th><th><b>Rate of Monthly Remuneration</b></th><th><b>Gross Pay</b></th><th><b>Deductions</b></th><th><b>Allowances</b></th><th><b>TDS</b></th><th><b>Total AP Tax</b></th><th><b>Sanctioned Salary<b></th><th><b>Net Salary</b></th>
            </tr>
            <tr id="revised-row">
                <th><b>(A) Remuneration for who have completed more than 2 years</b></th><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
            </tr>
            <tr id="non-revised-row">
                <th><b>(B) Remuneration for who have completed less than 2 years</b></th><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
            </tr>
            
        </table>
    </div>
</div>
@endsection
@section('scripts')
<script src="https://unpkg.com/docx@5.0.2/build/index.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/1.3.8/FileSaver.js"></script>
<script>
    $(document).on('click','.sanction',function(){
        $.get("{{route('program_sanction')}}",{
            program:$(this).data("program")
        },function(j){
            var inWord = inWords(j[1].sanction);
            var programSalary = [
                numberSystem(j[1].employee_count),
                numberSystem(j[1].sanction),
                numberSystem(j[1].net),
                numberSystem( j[1].ap_tax),
                j[1].commissioner,
                j[1].fao,
                j[1].program,
                j[1].month,
                j[1].year,
                j[1].file_number,
                numberSystem( j[1].other_deduction),
                numberSystem( j[1].allowance_amount),
				numberSystem( j[1].tds),
            ];
            generate($(this).data("program"),programSalary,inWord);
        });
        
    });

    $(document).on('click','.credit-transfer',function(){
        $.get("{{route('program_sanction')}}",{
            program:$(this).data("program")
        },function(j){
           var inWordNet = inWords(j[1].net);
            var programSalary = [
                numberSystem(j[1].employee_count),
                numberSystem(j[1].sanction),
                numberSystem(j[1].net),
                numberSystem( j[1].ap_tax),
                j[1].commissioner,
                j[1].fao,
                j[1].program,
                j[1].month,
                j[1].year,
                j[1].file_number
            ];
            generateCreditTransfer($(this).data("program"),programSalary,inWordNet);
        });
        
    });

    $(document).on('click','.challan',function(){
        $.get("{{route('program_sanction')}}",{
            program:$(this).data("program")
        },function(j){
            var inWordAPT = inWords(j[1].ap_tax);
            var programSalary = [
                j[1].employee_count-1,
                numberSystem(j[1].sanction),
                numberSystem(j[1].net),
                numberSystem(j[1].ap_tax),
                j[1].commissioner,
                j[1].fao,
                j[1].program,
                j[1].month,
                j[1].year,
                j[1].file_number,
                j[1].challan_file_number
            ];
            generateChalan($(this).data("program"),programSalary,inWordAPT);
        });
        
    });

    function generateChalan(program,programSalary,inWord){
        const doc = new docx.Document({
                styles: {
                paragraphStyles: [ 
                    {
                        id: "Heading1",
                    name: "Heading 1",
                    basedOn: "Normal",
                    next: "Normal",
                    quickFormat: true,
                    paragraph: {
                    
                    indent: {
                        left: 720,
                    },
                },
                    }
                ],
            }
            });
            
            doc.addSection({
    properties: {},
    children: [
        new docx.Paragraph({
            children: [
                new docx.TextRun({
                    text: "Assam Schedule-III(Sec-1 Form No. 64)",
                    color:"000000",
                    bold: true,
                }).break(),
                new docx.TextRun({
                    text: "(P.72/42)",
                    color:"000000",
                    bold: true,
                }).break(),

                
                new docx.TextRun({
                    text: "Challan No.",
                    color:"000000",
                    bold: true,
                }).break(),

                new docx.TextRun({
                    text: "Treasury/Sub-Treasury",
                    color:"000000",
                    bold: true,
                }).break(),

                new docx.TextRun({
                    text: "Challan of cash paid into the Dispur Treasury at Guwahati",
                    color:"000000",
                    bold: true,
                }).break(),

                new docx.TextRun({
                    text: "State Bank of India",
                    color:"000000",
                    bold: true,
                }).break(),
               

            ],
            alignment: docx.AlignmentType.CENTER,
            
        }),

        new docx.Table({
    rows: [
        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "By Whom Tendered",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Name (or Designation) and address of the person or whose behalf money paid",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Full particulars of the remittance and of authority(if any)",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Amount (Rs)",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Head of account",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Order of the Bank",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
            ],
        }),
        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "1",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "2",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "3",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "4",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "5",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "6",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),

                
            ],

        }),

        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Commissioner, P&RD",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "1.	and "+programSalary[0]+" others.",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Assam Professional Tax for the month of "+programSalary[7]+", "+programSalary[8]+". P.Tax vide Order No. "+programSalary[9]+"....... dtd.........",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: programSalary[3]+"/-",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),

                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "0028 other taxes income & expenditure-107- Taxes on Professional Trader Calling & Employment",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),

                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Date correct received & grant Signature full designation of the ofce ordering the money to be paid in",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
            ],
        }),

        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Cheque No. ......................",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Total:-",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: programSalary[3]+"/-",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "",
                    color:"000000",
                }).break(),
                        ]
                    })],
                }),

                
            ],
        }),

        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "(Rupees "+inWord+" only)",
                    color:"000000",
                }).break().break(),
                new docx.TextRun({
                    text: "Signature",
                    color:"000000",
                }).break().break().break().break().break().break().break(),
                new docx.TextRun({
                    text: "Date",
                    color:"000000",
                }).break().break(),
                        ]
                    })],
                    columnSpan:3,
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "To be used in case of remittance to Bank though an officer to the Govt.",
                    color:"000000",
                }).break(),

                new docx.TextRun({
                    text: "Signature of Departmental Office",
                    color:"000000",
                }).break().break().break().break(),
                        ]
                    })],
                    columnSpan:3,
                }),
               

                
            ],
        }),

        new docx.TableRow({
            children: [
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Received payment",
                    color:"000000",
                }).break().break(),
                new docx.TextRun({
                    text: "Treasury",
                    color:"000000",
                }).break().break().break().break().break().break().break(),
                
                        ]
                    })],
                    columnSpan:3,
                }),
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Date",
                    color:"000000",
                }).break(),

                new docx.TextRun({
                    text: "Accountant",
                    color:"000000",
                }).break().break().break().break(),
                        ]
                    })],
                    
                }),
                
                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "",
                    color:"000000",
                }).break(),

                new docx.TextRun({
                    text: "",
                    color:"000000",
                }).break().break().break().break(),
                        ]
                    })],
                    
                }),

                new docx.TableCell({
                    children: [new docx.Paragraph({
                        children:[
                            new docx.TextRun({
                    text: "Treasury Officer",
                    color:"000000",
                }).break().break().break().break().break().break().break().break().break().break().break().break(),

                new docx.TextRun({
                    text: "Agent",
                    color:"000000",
                }).break().break(),
                        ]
                    })],
                    
                }),
            ],
        }),
    ],
}),


        
    ],
});


            

            docx.Packer.toBlob(doc).then(blob => {
                console.log(blob);
                saveAs(blob,programSalary[6]+"-"+programSalary[7]+"-"+programSalary[8]+".docx");
                console.log("Document created successfully");
            });
    }
    function generateCreditTransfer(program,programSalary,inWord){
        const doc = new docx.Document({
                styles: {
                paragraphStyles: [ 
                    {
                        id: "Heading1",
                    name: "Heading 1",
                    basedOn: "Normal",
                    next: "Normal",
                    quickFormat: true,
                    paragraph: {
                    
                    indent: {
                        left: 720,
                    },
                },
                    }
                ],
            }
            });
            
            doc.addSection({
    properties: {},
    children: [
        new docx.Paragraph({
            children: [
                new docx.TextRun({
                    text: "GOVERNMENT OF ASSAM",
                    color:"000000",
                }).break(),
                new docx.TextRun({
                    text: "OFFICE OF THE COMMISIONER-PANCHYAT & RURAL DEVELOPMENT",
                    color:"000000",
                }).break(),

                new docx.TextRun({
                    text: "PANJABARI::::::JURIPAR::::::GUWAHATI::::::37",
                    color:"000000",
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                }).break(),
               
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.CENTER,
            
        }),

        new docx.Paragraph({
            children: [
                new docx.TextRun({
                    text: programSalary[9]+"\t",
                    color:"000000",
                }).break(),
                new docx.TextRun({
                    text: "Dated: /10/2020.",
                    color:"000000",
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                    
                    
                }),
               
               
            ],
            style: "Heading1",
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.RIGHT,
            
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "To : The Branch Manager",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Bank of Boroda,",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Dispur, Guwahati-06",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.LEFT,
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Sub : Transfer credit through NEFT/RTGS",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.LEFT,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Ref : Sanction order no "+programSalary[9]+"........... Dated.................",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.LEFT,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Sir,",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.LEFT,
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "\tWith the reference to the above, I am to request you kindly to transfer credit an amount of Rs "+programSalary[2]+" (Rupees "+inWord+" ) only to the Contractual Employees Remuneration for the month of "+programSalary[7]+", "+programSalary[8]+" working under "+programSalary[6]+" from the ACCOUNT NO. 801901011000935 of Commissioner Panchayat and Rural Development, Assam under Remuneration of Contractual Staff against cheque no................... dated................. enclosed herewith. The payment may be made through NEFT/RTGS as per C.D enclosed herewith",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Yours faithfully",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.RIGHT,
        }),
        new docx.Paragraph({
            children:[
                
                new docx.TextRun({
                    text: "("+programSalary[5]+")\t\t("+programSalary[4]+")",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Sr. Finance & Account Officer, \t\t Commissioner",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Panchayat & Rural Dev. Assam \t\t Panchayat & Rural Dev. Assam",
                    color:"000000",
                    italics: false,
                    underline: {
                         color: "000000",
                    },
                }).break(),
                new docx.TextRun({
                    text: "Panjabari, Juripar, Guwahati-37  \t\t Panjabari, Juripar, Guwahati-37 ",
                    color:"000000",
                    italics: false,
                    underline: {
                        color: "000000",
                    },
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.CENTER,
        }),

        
    ],
});


            

            docx.Packer.toBlob(doc).then(blob => {
                console.log(blob);
                saveAs(blob,programSalary[6]+"-"+programSalary[7]+"-"+programSalary[8]+".docx");
                console.log("Document created successfully");
            });
    }

    function generate(program,programSalary,inWord) {
            const doc = new docx.Document({
                styles: {
                paragraphStyles: [ 
                    {
                        id: "Heading1",
                    name: "Heading 1",
                    basedOn: "Normal",
                    next: "Normal",
                    quickFormat: true,
                    paragraph: {
                    
                    indent: {
                        left: 720,
                    },
                },
                    }
                ],
            }
            });
            
            doc.addSection({
    properties: {},
    children: [
        new docx.Paragraph({
            children: [
                new docx.TextRun({
                    text: "GOVERNMENT OF ASSAM",
                    color:"000000",
                }).break(),
                new docx.TextRun({
                    text: "OFFICE OF THE COMMISIONER-PANCHYAT & RURAL DEVELOPMENT",
                    color:"000000",
                }).break(),

                new docx.TextRun({
                    text: "PANJABARI::::::JURIPAR::::::GUWAHATI::::::37",
                    color:"000000",
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                }).break(),

                new docx.TextRun({
                    text: "OFFICE ORDER",
                    color:"000000",
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                    
                }).break().break(),
               
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.CENTER,
            
        }),

        new docx.Paragraph({
            children: [
                new docx.TextRun({
                    text: programSalary[9],
                    color:"000000",
                }).break(),
                new docx.TextRun({
                    text: "Dated: /10/2020.",
                    color:"000000",
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                    
                    
                }).break(),
               
               
            ],
            style: "Heading1",
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.RIGHT,
            
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "\tSanction is here by accorded for release of fund amounting to Rs."+programSalary[1]+"/- (Rupees "+inWord+")only for payment of remuneration to "+programSalary[0]+" nos. of contractual employees working under "+programSalary[6]+" for the month of "+programSalary[7]+", "+programSalary[8]+".",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "\tOut of the sanctioned amount of Rs."+programSalary[1]+"/-,Rs. "+programSalary[3]+"/- being the Assam P. Tax,Rs."+programSalary[10]+"/- being deductions, Rs."+programSalary[12]+"/- being tds, Rs.  "+programSalary[11]+"/- being allowances, and Rs.  "+programSalary[2]+"/- is for remuneration purposes.",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "\tThe order is made purely temporary to facilitate the remuneration of "+programSalary[6]+" employees only.",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "\tThe expenditure is debitable against available fund of Administrative Expenditure under "+programSalary[6]+", kept in Bank of Baroda.",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),
        new docx.Paragraph({
            children:[
                new docx.TextRun({
                   text: "Sd/-",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "("+programSalary[4]+")",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Commissioner",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Panchayat & Rural Dev. Assam",
                    color:"000000",
                    italics: false,
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.RIGHT,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Memo No."+programSalary[9]+"				Dated................",
                    color:"000000",
                    italics: false,
                    
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                    text: "Copy to :-",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "1. The Principal Secretary to the Govt. of Assam, Panchayat & Rural Development Deptt.Dispur for favour of information.",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "2. All Deputy Commissioner & D.P.C "+programSalary[6]+" for information.",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "3. All Chief Executive Officers of Zila Parisad for information and necessary action. ",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "4. All Project Directors of DRDAs for information and necessary action.",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "5.The Cashier of this Commissionerate for information and necessary action.",
                    color:"000000",
                    italics: false,
                    
                }).break()

            ],
            heading: docx.HeadingLevel.HEADING_3,
        }),

        new docx.Paragraph({
            children:[
                new docx.TextRun({
                   text: "Sd/-",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "("+programSalary[5]+", AFS),",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "Sr. Finance & Accounts Officer",
                    color:"000000",
                    italics: false,
                    
                }).break(),
                new docx.TextRun({
                    text: "O/o Commissioner, Panchayat & Rural Dev. Assam.",
                    color:"000000",
                    italics: false,
                    underline: {
                        type: docx.UnderlineType.SINGLE,
                        color: "000000",
                    },
                }).break()
            ],
            heading: docx.HeadingLevel.HEADING_3,
            alignment: docx.AlignmentType.RIGHT,
        }),
    ],
});


            

            docx.Packer.toBlob(doc).then(blob => {
                console.log(blob);
                saveAs(blob,programSalary[6]+"-"+programSalary[7]+"-"+programSalary[8]+".docx");
                console.log("Document created successfully");
            });
        }
function numberSystem(number){
    var x=number;
    x=x.toString();
    var afterPoint = '';
    if(x.indexOf('.') > 0)
       afterPoint = x.substring(x.indexOf('.'),x.length);
    x = Math.floor(x);
    x=x.toString();
    var lastThree = x.substring(x.length-3);
    var otherNumbers = x.substring(0,x.length-3);
    if(otherNumbers != '')
        lastThree = ',' + lastThree;
    var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree + afterPoint;
    return res;
}


function inWords (num) {
    var a = ['','One ','Two ','Three ','Four ', 'Five ','Six ','Seven ','Eight ','Nine ','Ten ','Eleven ','Twelve ','Thirteen ','Fourteen ','Fifteen ','Sixteen ','Seventeen ','Eighteen ','Nineteen '];
    var b = ['', '', 'Twenty','Thirty','Forty','Fifty', 'Sixty','Seventy','Eighty','Ninety'];

    if ((num = num.toString()).length > 9) return 'overflow';
    n = ('000000000' + num).substr(-9).match(/^(\d{2})(\d{2})(\d{2})(\d{1})(\d{2})$/);
    if (!n) return; var str = '';
    str += (n[1] != 0) ? (a[Number(n[1])] || b[n[1][0]] + ' ' + a[n[1][1]]) + 'Crore ' : '';
    str += (n[2] != 0) ? (a[Number(n[2])] || b[n[2][0]] + ' ' + a[n[2][1]]) + 'Lakh ' : '';
    str += (n[3] != 0) ? (a[Number(n[3])] || b[n[3][0]] + ' ' + a[n[3][1]]) + 'Thousand ' : '';
    str += (n[4] != 0) ? (a[Number(n[4])] || b[n[4][0]] + ' ' + a[n[4][1]]) + 'Hundred ' : '';
    str += (n[5] != 0) ? ((str != '') ? 'and ' : '') + (a[Number(n[5])] || b[n[5][0]] + ' ' + a[n[5][1]]) + '' : '';
    return str;
}
</script>
<script src="//cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script> 
    $(document).on('click','.bank-summary',function(){
        $('.temp-row').remove();
        var programName = $(this).data("program_name");
        $.get("{{route('program_summary')}}",{
            program_id:$(this).data("program")
        },function(j){
            var revisedRow = "";
            var employeeCount = 0;
            var salarySum = 0;
            var grossSum = 0;
            var deductionSum = 0;
            var allowanceSum = 0;
            var apTaxSum = 0;
            var netSum = 0;
			var tdsSum = 0;
            var non_revisedRow = "";
            var non_revised_employeeCount = 0;
            var non_revised_salarySum = 0;
            var non_revised_grossSum = 0;
            var non_revised_deductionSum = 0;
            var non_revised_allowanceSum = 0;
            var non_revised_apTaxSum = 0;
            var non_revised_netSum = 0;
			var non_revised_tdsSum = 0;
			var nonRevisedSanction = 0;
			var revisedSanction = 0;
			var nonRevisedSanctionSum = 0;
			var revisedSanctionSum = 0;
			var nonRevisedNet = 0;
			var revisedNet = 0;
			var nonRevisedNetSum = 0;
			var revisedNetSum = 0;
            for(var i = 0; i < j[1].revised.length; i++){
				employeeCount += j[1].revised[i].employee_count;
                salarySum = j[1].revised[i].employee_count*j[1].revised[i].gross;
                grossSum += (j[1].revised[i].employee_count*j[1].revised[i].gross);
                deductionSum += j[1].revised[i].deduction;
                allowanceSum += j[1].revised[i].allowance;
                apTaxSum += j[1].revised[i].ap_tax;
				tdsSum += Number(j[1].revised[i].tds);
				revisedSanction = (j[1].revised[i].employee_count*j[1].revised[i].gross)+j[1].revised[i].allowance-j[1].revised[i].deduction;
				revisedSanctionSum += revisedSanction;
                revisedNet = (j[1].revised[i].employee_count*j[1].revised[i].gross)+j[1].revised[i].allowance-j[1].revised[i].ap_tax-j[1].revised[i].tds-j[1].revised[i].deduction;
				revisedNetSum += revisedNet;
                revisedRow += "<tr class='temp-row'><td>"+(i+1)+"</td>"+
                "<td>"+j[1].revised[i].employee_count+"</td>"+
                "<td>"+j[1].revised[i].designation_name+"</td>"+
                "<td>"+j[1].revised[i].gross+"</td>"+
                "<td>"+(j[1].revised[i].employee_count*j[1].revised[i].gross)+"</td>"+
                "<td>"+j[1].revised[i].deduction+"</td>"+
                "<td>"+j[1].revised[i].allowance+"</td>"+
                "<td>"+j[1].revised[i].tds+"</td>"+
                "<td>"+j[1].revised[i].ap_tax+"</td>"+
                "<td>"+revisedSanction+"</td>"+
                "<td>"+revisedNet+"</td>"+
                "</tr>";
            }
			
            for(var i = 0; i < j[1].non_revised.length; i++){
				non_revised_employeeCount += j[1].non_revised[i].employee_count;
                non_revised_salarySum = j[1].non_revised[i].employee_count*j[1].non_revised[i].gross;
                non_revised_grossSum += (j[1].non_revised[i].employee_count*j[1].non_revised[i].gross);
                non_revised_deductionSum += j[1].non_revised[i].deduction;
                non_revised_allowanceSum += j[1].non_revised[i].allowance;
                non_revised_apTaxSum += j[1].non_revised[i].ap_tax;
				non_revised_tdsSum += Number(j[1].non_revised[i].tds);
				nonRevisedSanction = (j[1].non_revised[i].employee_count*j[1].non_revised[i].gross)+j[1].non_revised[i].allowance-j[1].non_revised[i].deduction;
				nonRevisedSanctionSum += nonRevisedSanction;
                non_revised_netSum += (j[1].non_revised[i].employee_count*j[1].non_revised[i].gross-j[1].non_revised[i].deduction-j[1].non_revised[i].ap_tax+j[1].non_revised[i].allowance-j[1].non_revised[i].tds);
				
				
				nonRevisedNet = (j[1].non_revised[i].employee_count*j[1].non_revised[i].gross)+j[1].non_revised[i].allowance-j[1].non_revised[i].ap_tax-j[1].non_revised[i].tds-j[1].non_revised[i].deduction;
				
				nonRevisedNetSum += nonRevisedNet;
				
                non_revisedRow += "<tr class='temp-row'><td>"+(i+1)+"</td>"+
                "<td>"+j[1].non_revised[i].employee_count+"</td>"+
                "<td>"+j[1].non_revised[i].designation_name+"</td>"+
                "<td>"+j[1].non_revised[i].gross+"</td>"+
                "<td>"+(j[1].non_revised[i].employee_count*j[1].non_revised[i].gross)+"</td>"+
                "<td>"+j[1].non_revised[i].deduction+"</td>"+
                "<td>"+j[1].non_revised[i].allowance+"</td>"+
                "<td>"+j[1].non_revised[i].tds+"</td>"+
                "<td>"+j[1].non_revised[i].ap_tax+"</td>"+
                "<td>"+nonRevisedSanction+"</td>"+
                "<td>"+nonRevisedNet+"</td>"+
                "</tr>";
            }
			
            revisedRow += "<tr class='temp-row'><td><b>Total(A)</b></td>"+
                "<td><b>"+employeeCount+"</b></td>"+
                "<td><b></b></td>"+
                "<td><b></b></td>"+
                "<td><b>"+grossSum+"</b></td>"+
                "<td><b>"+deductionSum+"</b></td>"+
                "<td><b>"+allowanceSum+"</b></td>"+
                "<td><b>"+Number(tdsSum)+"</b></td>"+
                "<td><b>"+apTaxSum+"</b></td>"+
                "<td><b>"+revisedSanctionSum+"</b></td>"+
                "<td><b>"+revisedNetSum+"</b></td>"+
                "</tr>";
            non_revisedRow += "<tr id='b-row' class='temp-row'><td><b>Total(B)</b></td>"+
                "<td><b>"+non_revised_employeeCount+"</b></td>"+
                "<td><b></b></td>"+
                "<td><b></b></td>"+
                "<td><b>"+non_revised_grossSum+"</b></td>"+
                "<td><b>"+non_revised_deductionSum+"</b></td>"+
                "<td><b>"+non_revised_allowanceSum+"</b></td>"+
                "<td><b>"+Number(non_revised_tdsSum)+"</b></td>"+
                "<td><b>"+non_revised_apTaxSum+"</b></td>"+
                "<td><b>"+nonRevisedSanctionSum+"</b></td>"+
                "<td><b>"+nonRevisedNetSum+"</b></td>"+
                "</tr>";
				
            var abRow =  "<tr class='temp-row'><td><b>Total(A+B)</b></td>"+
                "<td><b>"+(employeeCount+non_revised_employeeCount)+"</b></td>"+
                "<td><b></b></td>"+
                "<td><b></b></td>"+
                "<td><b>"+(grossSum+non_revised_grossSum)+"</b></td>"+
                "<td><b>"+(deductionSum+non_revised_deductionSum)+"</b></td>"+
                "<td><b>"+(allowanceSum+non_revised_allowanceSum)+"</b></td>"+
                "<td><b>"+(Number(tdsSum)+Number(non_revised_tdsSum))+"</b></td>"+
                "<td><b>"+(apTaxSum+non_revised_apTaxSum)+"</b></td>"+
                "<td><b>"+(revisedSanctionSum+nonRevisedSanctionSum)+"</b></td>"+
                "<td><b>"+(nonRevisedNetSum+revisedNetSum)+"</b></td>"+
                "</tr>";
            var districtNames = "";
            for(var i = 0; i < j[1].districts.length; i++){
                districtNames += " "+j[1].districts[i].district_name;
            }
            $('#district-data').text(districtNames);
            $( "#revised-row" ).after( revisedRow );
            $( "#non-revised-row" ).after( non_revisedRow );
            $( "#b-row" ).after( abRow );
            $('#month-data').text(j[1].month);
            $('#year-data').text(j[1].year);
            $('#program-data').text(programName);
            $("#myTable").table2excel({ 
          name: "Backup file for HTML content", 

          //  include extension also 
          filename: programName+"_"+j[1].month+"bank_summary.xls", 

// 'True' is set if background and font colors preserved 
          preserveColors: false  
        });    
        });
        
    });
</script>
@endsection