<?php
ob_start();
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include('includes/function.php');

$formname = "Daily Report";
$file = "dailyrep_fr.php";

$salefile = "salemain";
$purchfile = "purmain";
$crfile = "cashrecp";
$cpfile = "cashpay";
$brfile = "bankrecp";
$bpfile = "bankpay";
$zroot = $_SESSION["zdir"];

$admin = $_SESSION["admin_" . $dbname];
$zdb = $_SESSION["zdbyear_" . $dbname];
$zcomp = $_SESSION["comp_" . $dbname];
$myyear = $_SESSION[$myyear];
mysqli_select_db($conn, $zdb);




if (isset($_POST["view"])) {

    $date = $_POST["date"];


    $getcomp = mysqli_query($conn, "SELECT * FROM $zroot.`company` where code='$zcomp'")or die(mysqli_error($conn));
    $comp = mysqli_fetch_array($getcomp);
//    browse($date);
//////////////////////////////////////////
//    $csale1 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $salefile WHERE vouchdt = '$date' AND `cashcred` = 'C' group by vouchdt") or die(mysqli_error($conn));
//    $cssale = mysqli_fetch_array($csale1);
//
//    $cashsale = $cssale["amt"];

//    $csale2 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $salefile WHERE vouchdt = '$date' AND  `cashcred` != 'C' group by vouchdt") or die(mysqli_error($conn));
//    $crsale = mysqli_fetch_array($csale2);
//
//    $creditsale = $crsale["amt"];
//    
//    $totsale = $cashsale + $creditsale;

    $cpur1 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $purchfile WHERE vouchdt = '$date' AND  `cashcred` = 'C' group by vouchdt") or die(mysqli_error($conn));
    $cspur = mysqli_fetch_array($cpur1);

    $cashpur = $cspur["amt"];

    $cpur2 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $purchfile WHERE vouchdt = '$date' AND  `cashcred` != 'C' group by vouchdt") or die(mysqli_error($conn));
    $cspur = mysqli_fetch_array($cpur2);

    $creditpur = $cspur["amt"];
    $totpur = $cashpur + $creditpur;
    
///////////////////////////////////////////// New Fildes cash sale, Credit Sale /////////////////////


    $cashsale = $credale = $ccsale = $totsale = 0;
    
    $csale1 = mysqli_query($conn, "SELECT SUM(cashamt) AS amt FROM $salefile WHERE vouchdt = '$date' ") or die(mysqli_error($conn));
    $cssale = mysqli_fetch_array($csale1);
    $cashsale = $cssale[amt];

    $csale2 = mysqli_query($conn, "SELECT SUM(credamt) AS amt FROM $salefile WHERE vouchdt = '$date' ") or die(mysqli_error($conn));
    $crsale = mysqli_fetch_array($csale2);
    $creditsale = $crsale["amt"];

    $csale3 = mysqli_query($conn, "SELECT SUM(ccamt) AS amt FROM $salefile WHERE vouchdt = '$date' ") or die(mysqli_error($conn));
    $ccsale = mysqli_fetch_array($csale3);
    $ccsale = $ccsale["amt"];

$totsale =  $cashsale + $creditsale +$ccsale;


/////////////////////////////////////////////
    $crecp2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $crfile WHERE
                      vouchdt = '$date'  order by vouchno ") or die(mysqli_error($conn));

    $cpaid2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $cpfile WHERE
                      vouchdt = '$date' ") or die(mysqli_error($conn));

    $brecp2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $brfile WHERE
                       vouchdt = '$date' ") or die(mysqli_error($conn));

    $bpaid2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $bpfile WHERE
                       vouchdt = '$date' ") or die(mysqli_error($conn));

//////////////

    $crecp = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $crfile WHERE
                      vouchdt = '$date' group by vouchdt") or die(mysqli_error($conn));
    $crget = mysqli_fetch_array($crecp);

    $cramt = $crget["amt"];

    $cpaid = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `cashpay` WHERE
                      vouchdt = '$date' group by vouchdt") or die(mysqli_error($conn));
    $cpget = mysqli_fetch_array($cpaid);

    $cpamt = $cpget["amt"];

    $brecp = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `bankrecp` WHERE
                      vouchdt = '$date' group by vouchdt") or die(mysqli_error($conn));
    $brget = mysqli_fetch_array($brecp);

    $bramt = $brget["amt"];

    $bpaid = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `bankpay` WHERE
                      vouchdt = '$date' group by vouchdt") or die(mysqli_error($conn));
    $bpget = mysqli_fetch_array($bpaid);

    $bpamt = $bpget["amt"];

    include("includes/linkshead.php");
    ?>
    <style>
        .td{
            font-size: 15px;
        }
        @media print {
            .noPrint {
                display:none;
            }
        }

    </style>
    <body>
        <div class="container">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 ">

                    <?php
                    $getcomp = mysqli_query($conn, "SELECT * FROM $zroot.`company` where code='$zcomp'")or die(mysqli_error($conn));
                    $comp = mysqli_fetch_array($getcomp);
                    echo "<label style='font-size:20px;'>$comp[name]</label>"
                    ?>
                </div>
            </div>
            <div class="row">
                <div class="col-lg-7 col-md-11 col-sm-11 col-xs-11 ">

                    <label class="label-control marg"><?php Echo $formname; ?> - </label>
                    <?= date("d-m-Y", strtotime($date)); ?>
                </div>
                <div class="col-lg-1 col-md-1 col-sm-1 col-xs-1 pad">
                    <a onclick="window.close()" class="btn btn-primary noPrint">GO Back</a>
                </div>
            </div>
            <?php
//            include("includes/head_rep.php");
//            echo " ( " . date("d-m-Y", strtotime($date)) . ")";
            ?>
                                <!--<table class="table table-bordered" summary="Ledger - Detail" width='100%' border="0">-->
            <table style="width:70%;" class="table-bordered table table-stripped table-hover" summary="Ledger - Detail">
                <tbody>
                    <tr style ="height:10px;">
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Cash Sale</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">$cashsale</td>";
                        ?>
                        <td class = 'td'   style="text-align:left;" scope="col" width="40"><font size="3px" color=''><b></b></font></td>
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Cash Purchase</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">$cashpur</td>";
                        ?>
                    </tr>
                    <tr style ="height:10px;">
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Credit Sale</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">$creditsale</td>";
                        ?>
                        <td class = 'td'   style="text-align:left;" scope="col" width="40"><font size="3px" color=''><b></b></font></td>
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Credit Purchase</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">$creditpur</td>";
                        ?>
                    </tr>
                    <tr style ="height:10px;">
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>CC Sale</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">$ccsale</td>";
                        ?>
                        <td class = 'td'   style="text-align:left;" scope="col" width="40"><font size="3px" color=''><b></b></font></td>
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b></b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\"></td>";
                        ?>
                    </tr>
                    <tr style ="height:10px;">
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Total Sale</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">" . number_format($totsale, 2) . "</td>";
                        ?>
                        <td class = 'td'   style="text-align:left;" scope="col" width="40"><font size="3px" color=''><b></b></font></td>
                        <td class = 'td'   style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Total Purchase</b></font></td>
                        <?php
                        echo " <td class = 'td'   style=\"text-align:right;\" scope=\"col\" width=\"90\">" . number_format($totpur, 2) . "</td>";
                        ?>
                    </tr>
            </table>  
            <!--<table class="table table-bordered" summary="Ledger - Detail" width='100%' border="0">-->
            <table style="width:70%;" class="table-bordered table table-stripped table-hover" summary="Ledger - Detail">    
                <?php // if ($prntype == 2) {    ?>
                <tr style="height:10px;">
                    <td class = 'td'  style="text-align:left;" scope="col" width="10%"><font size="3px" color=''><b></b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="40%"><font size="3px" color=''><b>Cash Receipt</b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="12%"><font size="3px" color=''><b></b></font></td>

                </tr>
                <tr style="height:10px;">
                    <td class = 'td'  align="left"  color=''><b>Voucher</b></td>
                    <td class = 'td'  align="left"  color=''><b>A/c. Name.</b></td>
                    <td class = 'td'  align="right" color=''><b>Amount</b></td>
                </tr>

                <?php
                $totrecd = 0;
                $totdisc = 0;
                $totclaim = 0;
                $totamt = 0;

                mysqli_select_db($conn, $zdb);
                while ($row = mysqli_fetch_array($crecp2)) {
                    $getname = mysqli_query($conn, "SELECT `name` FROM `accmast` WHERE accode='$row[bankname]'") or die(mysqli_error($conn));
                    $name = mysqli_fetch_array($getname);
                    echo "<tr style='height:10px;'>";
                    echo " <td class = 'td'  align='left' color=''>$row[vouchno]</td>";
                    echo " <td class = 'td'  align='left' color=''>$name[name]</td>";
                    echo " <td class = 'td'  align='right' color=''>$row[amount]</td>";
                    echo "</tr>";

                    $totrecd = $totrecd + $row[recdamt];
                    $totdisc = $totdisc + $row[discount];
                    $totclaim = $totclaim + $row[claim];
                    $totamt = $totamt + $row[amount];
                }
                ?>
                <tr>
                    <td class = 'td'  colspan="1">
                        <?php
                        echo " <td class = 'td'  align='right' color=''>Total</td>";
                        echo " <td class = 'td'  align='right' color=''>" . number_format($totamt, 2) . "</td>";
                        ?>
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  colspan="9">
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  style="text-align:left;" scope="col" width="10"><font size="3px" color=''><b></b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Cash Payment</b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b></b></font></td>
                </tr>
                <tr>
                    <td class = 'td'  align="left" color=''><b>Voucher</b></td>
                    <td class = 'td'  align="left" color=''><b>A/c. Name.</b></td>
                    <td class = 'td'  align="right" color=''><b>Amount</b></td>
                </tr>
                <?php
                $totrecd = 0;
                $totdisc = 0;
                $totclaim = 0;
                $totamt = 0;
                while ($row2 = mysqli_fetch_array($cpaid2)) {

                    $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row2[bankname]'") or die(mysqli_error($conn));
                    $name = mysqli_fetch_array($getname);

                    echo "<tr>";
                    echo " <td class = 'td'  align='left' color=''>$row2[vouchno]</td>";
                    echo " <td class = 'td'  align='left' color=''>$name[name]</td>";
                    echo " <td class = 'td'  align='right' color=''>$row2[amount]</td>";
                    echo "</tr>";

                    $totrecd = $totrecd + $row2[recdamt];
                    $totdisc = $totdisc + $row2[discount];
                    $totclaim = $totclaim + $row2[claim];
                    $totamt = $totamt + $row2[amount];
                }
                ?>
                <tr>
                    <td class = 'td'  colspan="1">
                        <?php
                        echo " <td class = 'td'  align='right' color=''>Total</td>";
                        echo " <td class = 'td'  align='right' color=''>" . number_format($totamt, 2) . "</td>";
                        ?>
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  colspan="9">
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  style="text-align:left;" scope="col" width="10"><font size="3px" color=''><b></b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Bank Receipt</b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b></b></font></td>
                </tr>
                <tr>
                    <td class = 'td'  align="left"  color=''><b>Voucher</b></td>
                    <td class = 'td'  align="left"  color=''><b>A/c Name.</b></td>
                    <td class = 'td'  align="right" color=''><b>Amount</b></td>
                </tr>
                <?php
                /*                 * for bankrecp* */
                $totrecd = 0;
                $totdisc = 0;
                $totclaim = 0;
                $totamt = 0;

                while ($row3 = mysqli_fetch_array($brecp2)) {

                    $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row3[bankname]'") or die(mysqli_error($conn));
                    $name = mysqli_fetch_array($getname);
                    echo "<tr>";
                    echo " <td class = 'td'  align='left' color=''>$row3[vouchno]</td>";
                    echo " <td class = 'td'  align='left' color=''>$name[name]</td>";
                    echo " <td class = 'td'  align='right' color=''>$row3[amount]</td>";
                    echo "</tr>";

                    $totrecd = $totrecd + $row3[recdamt];
                    $totdisc = $totdisc + $row3[discount];
                    $totclaim = $totclaim + $row3[claim];
                    $totamt = $totamt + $row3[amount];
                }
                ?>
                <tr>
                    <td class = 'td'  colspan="1">
                        <?php
                        echo " <td class = 'td'  align='right' color=''>Total</td>";
                        echo " <td class = 'td'  align='right' color=''>" . number_format($totamt, 2) . "</td>";
                        ?>
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  colspan="9">
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  style="text-align:left;" scope="col" width="10"><font size="3px" color=''><b></b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b>Bank Payment</b></font></td>
                    <td class = 'td'  style="text-align:left;" scope="col" width="20"><font size="3px" color=''><b></b></font></td>
                </tr>
                <tr>
                    <td class = 'td'  align="left" color=''><b>Voucher</b></td>
                    <td class = 'td'  align="left" color=''><b>A/c Name.</b></td>
                    <td class = 'td'  align="right" color=''><b>Amount</b></td>
                </tr>
                <?php
                /** for bankpay* */
//                    $bpaid2 = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `bankpay` WHERE
//                                                 vouchdt <= '$date' group by vouchdt") or die(mysqli_error($conn));
                $totrecd = 0;
                $totdisc = 0;
                $totclaim = 0;
                $totamt = 0;
                while ($row4 = mysqli_fetch_array($bpaid2)) {

                    $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row4[bankname]'") or die(mysqli_error($conn));
                    $name = mysqli_fetch_array($getname);
                    echo "<tr>";
                    echo " <td class = 'td'  align='left' color=''>$row4[vouchno]</td>";
                    echo " <td class = 'td'  align='left' color=''>$name[name]</td>";
                    echo " <td class = 'td'  align='right' color=''>$row4[amount]</td>";
                    echo "</tr>";

                    $totrecd = $totrecd + $row4[recdamt];
                    $totdisc = $totdisc + $row4[discount];
                    $totclaim = $totclaim + $row4[claim];
                    $totamt = $totamt + $row4[amount];
                }
                ?>
                <tr>
                    <td class = 'td'  colspan="1">
                        <?php
                        echo " <td class = 'td'  align='right' color=''>Total</td>";
                        echo " <td class = 'td'  align='right' color=''>" . number_format($totamt, 2) . "</td>";
                        ?>
                    </td>
                </tr>
                <tr>
                    <td class = 'td'  colspan="9">
                    </td>
                </tr>
                <?php //}    ?>
                </tbody>
                <tfoot>
                    <tr>
                        <td class = 'td'  colspan="9">
                            <hr style=""/>
                        </td>
                    </tr>
                </tfoot>
            </table>
            <script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
            <script>window.jQuery || document.write('<script src="assets/lib/jquery.min.js"><\/script>')</script> 
            <script src="assets/lib/bootstrap/js/bootstrap.js"></script>
            <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
            <script src="assets/lib/datatables/jquery.dataTables.js"></script>
            <script src="assets/lib/datatables/DT_bootstrap.js"></script>
            <script src="assets/lib/tablesorter/js/jquery.tablesorter.min.js"></script>
            <script src="assets/lib/touch-punch/jquery.ui.touch-punch.min.js"></script>
            <script src="assets/js/main.js"></script>
            <script>

                        $(function () {
                            metisTable();
                            metisSortable();
                        });

            </script>
        </div>

    </body>
    </html>
    <?php
}
//if (isset($_POST["export"])) {
//
//    $csale1 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $salefile WHERE vouchdt <= '$date' AND  type= 'C' group by vouchdt") or die(mysqli_error($conn));
//    $cssale = mysqli_fetch_array($csale1);
//
//    $cashsale = $cssale["amt"];
//
//    $csale2 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $salefile WHERE vouchdt <= '$date' AND  type!= 'C' group by vouchdt") or die(mysqli_error($conn));
//    $crsale = mysqli_fetch_array($csale2);
//
//    $creditsale = $crsale["amt"];
//    $totsale = $cashsale + $creditsale;
//
//    $cpur1 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $purchfile WHERE vouchdt <= '$date' AND  type= 'C' group by vouchdt") or die(mysqli_error($conn));
//    $cspur = mysqli_fetch_array($cpur1);
//
//    $cashpur = $cspur["amt"];
//
//    $cpur2 = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM $purchfile WHERE vouchdt <= '$date' AND  type!= 'C' group by vouchdt") or die(mysqli_error($conn));
//    $cspur = mysqli_fetch_array($cpur2);
//
//    $creditpur = $cspur["amt"];
//    $totpur = $cashpur + $creditpur;
////////////////
//
//
//    $crecp2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $crfile WHERE
//                      vouchdt <= '$date' ") or die(mysqli_error($conn));
//
//    $cpaid2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $cpfile WHERE
//                      vouchdt <= '$date' ") or die(mysqli_error($conn));
//
//    $brecp2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $brfile WHERE
//                       vouchdt <= '$date' ") or die(mysqli_error($conn));
//
//    $bpaid2 = mysqli_query($conn, "SELECT *,  DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $bpfile WHERE
//                       vouchdt <= '$date' ") or die(mysqli_error($conn));
//
////////////////
//
//    $crecp = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM $crfile WHERE
//                      vouchdt <= '$date' group by vouchdt") or die(mysqli_error($conn));
//    $crget = mysqli_fetch_array($crecp);
//
//    $cramt = $crget["amt"];
//
//    $cpaid = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `cashpay` WHERE
//                      vouchdt <= '$date' group by vouchdt") or die(mysqli_error($conn));
//    $cpget = mysqli_fetch_array($cpaid);
//
//    $cpamt = $cpget["amt"];
//
//    $brecp = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `bankrecp` WHERE
//                      vouchdt <= '$date' group by vouchdt") or die(mysqli_error($conn));
//    $brget = mysqli_fetch_array($brecp);
//
//    $bramt = $brget["amt"];
//
//    $bpaid = mysqli_query($conn, "SELECT *, SUM(amount) AS amt, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') as mydt FROM `bankpay` WHERE
//                      vouchdt <= '$date' group by vouchdt") or die(mysqli_error($conn));
//    $bpget = mysqli_fetch_array($bpaid);
//
//    $bpamt = $bpget["amt"];
//
//
//    $contents = "Cash Sale,Cash Purchase,Credit Sale,Credit Purchase,Total Sale,Total Purchase\n";
//
//    $contents.=$cashsale . ",";
//    $contents.=$cashpur . ",";
//    $contents.=$creditsale . ",";
//    $contents.=$creditpur . ",";
//    $contents.=$totsale . ",";
//    $contents.=$totpur . "\n";
//
//    $totamt = $totamt + $row->subtotal;
//    $billamt = $billamt + $row->netamt;
//
//    if ($_POST["dtype"] == 2) {
//
//        $style = "calibri";
//        $size = '2px';
//
//        $contents = " ,Cash Receipt, , , , \n";
//        $contents = "Voucher,A/c. Name,Recd. Amount,Discount,Claim,Amount\n";
//
//
//        $totrecd = 0;
//        $totdisc = 0;
//        $totclaim = 0;
//        $totamt = 0;
//
//        while ($row = mysqli_fetch_array($crecp2)) {
//
//            $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row3[accode]'") or die(mysqli_error($conn));
//            $name = mysqli_fetch_array($getname);
//
//            $ctrdtl++;
//
//            $vouch = $row->vouchno;
//            $part = $name->name;
//            $recd = $row->recdamt;
//            $disc = $row->discount;
//            $claim = $row->claim;
//            $amt = $row->amount;
//
//            $totrecd = $totrecd + $row[recdamt];
//            $totdisc = $totdisc + $row[discount];
//            $totclaim = $totclaim + $row[claim];
//            $totamt = $totamt + $row[amount];
//
//
//
//            $contents.=$vouch . ",";
//            $contents.=$part . ",";
//            $contents.=$recd . ",";
//            $contents.=$disc . ",";
//            $contents.=$claim . ",";
//            $contents.=$amt . "\n";
//        }
//        $contents.="Total" . ",";
//        $contents.=number_format($totrecd, 2) . ",";
//        $contents.=number_format($totdisc, 2) . ",";
//        $contents.=number_format($totclaim, 2) . ",";
//        $contents.=number_format($totamt, 2) . "\n";
//
//
//        $contents.=",Cash Payment, , , , \n";
//        $contents.="Voucher,A/c. Name,Recd. Amount ,Discount ,Claim,Amount \n";
//
//        $totrecd = 0;
//        $totdisc = 0;
//        $totclaim = 0;
//        $totamt = 0;
//        while ($row2 = mysqli_fetch_array($cpaid2)) {
//
//            $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row2[accode]'") or die(mysqli_error($conn));
//            $name = mysqli_fetch_array($getname);
//
//            $ctrdtl++;
//
//            $vouch = $row2->vouchno;
//            $part = $name->name;
//            $recd = $row2->recdamt;
//            $disc = $row2->discount;
//            $claim = $row2->claim;
//            $amt = $row2->amount;
//
//            $totrecd = $totrecd + $row2[recdamt];
//            $totdisc = $totdisc + $row2[discount];
//            $totclaim = $totclaim + $row2[claim];
//            $totamt = $totamt + $row2[amount];
//
//
//
//            $contents.=$vouch . ",";
//            $contents.=$part . ",";
//            $contents.=$recd . ",";
//            $contents.=$disc . ",";
//            $contents.=$claim . ",";
//            $contents.=$amt . "\n";
//        }
//
//        $contents.=",Bank Receipt, , , , \n";
//        $contents.="Voucher,A/c. Name,Recd. Amount ,Discount ,Claim,Amount \n";
//
//        $totrecd = 0;
//        $totdisc = 0;
//        $totclaim = 0;
//        $totamt = 0;
//        while ($row3 = mysqli_fetch_array($brecp2)) {
//
//            $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row3[accode]'") or die(mysqli_error($conn));
//            $name = mysqli_fetch_array($getname);
//
//            $ctrdtl++;
//
//            $vouch = $row3->vouchno;
//            $part = $name->name;
//            $recd = $row3->recdamt;
//            $disc = $row3->discount;
//            $claim = $row3->claim;
//            $amt = $row3->amount;
//
//            $totrecd = $totrecd + $row3[recdamt];
//            $totdisc = $totdisc + $row3[discount];
//            $totclaim = $totclaim + $row3[claim];
//            $totamt = $totamt + $row3[amount];
//
//
//
//            $contents.=$vouch . ",";
//            $contents.=$part . ",";
//            $contents.=$recd . ",";
//            $contents.=$disc . ",";
//            $contents.=$claim . ",";
//            $contents.=$amt . "\n";
//        }
//        $contents.=",Bank Payment, , , , \n";
//        $contents.="Voucher,A/c. Name,Recd. Amount ,Discount ,Claim,Amount \n";
//
//        $totrecd = 0;
//        $totdisc = 0;
//        $totclaim = 0;
//        $totamt = 0;
//        while ($row4 = mysqli_fetch_array($bpaid2)) {
//
//            $getname = mysqli_query($conn, "SELECT * FROM `accmast` WHERE accode='$row4[accode]'") or die(mysqli_error($conn));
//            $name = mysqli_fetch_array($getname);
//
//            $ctrdtl++;
//
//            $vouch = $row4->vouchno;
//            $part = $name->name;
//            $recd = $row4->recdamt;
//            $disc = $row4->discount;
//            $claim = $row4->claim;
//            $amt = $row4->amount;
//
//            $totrecd = $totrecd + $row4[recdamt];
//            $totdisc = $totdisc + $row4[discount];
//            $totclaim = $totclaim + $row4[claim];
//            $totamt = $totamt + $row4[amount];
//
//
//
//            $contents.=$vouch . ",";
//            $contents.=$part . ",";
//            $contents.=$recd . ",";
//            $contents.=$disc . ",";
//            $contents.=$claim . ",";
//            $contents.=$amt . "\n";
//        }
//    }
//    $contents.="Total" . ",";
//    $contents.=number_format($totrecd, 2) . ",";
//    $contents.=number_format($totdisc, 2) . ",";
//    $contents.=number_format($totclaim, 2) . ",";
//    $contents.=number_format($totamt, 2) . "\n";
//
//
//    $contents = strip_tags($contents);
//
////header to make force download the file
//    if ($_POST["dtype"] == 1) {
//        header("Content-Disposition: attachment; filename=SaleOrderRegisterSummary" . date('d-m-Y') . ".csv");
//        print $contents;
//    } else {
//        header("Content-Disposition: attachment; filename=SaleOrderRegisterDetail" . date('d-m-Y') . ".csv");
//        print $contents;
//    }
//}
?>