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

$formname = "Bank Reconcillation";

//$action = "bankrecon_fr.php";

$maindb = 'actran';

$admin = $_SESSION["admin_" . $dbname];
$zdb = $_SESSION["zdbyear_" . $dbname];

$zyear = right($zdb, 4);
$mfrdate = getzdates($zyear, 'S');
$mtodate = getzdates($zyear, 'E');

$myyear = $_SESSION[$myyear];
mysqli_select_db($conn,$zdb);

if (isset($_POST["submit"])) {
    $a = 1;
    if ($a == 1) {


        $a = 1;
        $count = $_POST["count"];
//    browse($count);
        $mvouch = $qvouch;
        $cnt = 0;
        for ($i = 0; $i <= $count; $i++) {

            $code = $_POST["code_$i"];
            $vouchno = $_POST["vouchno_$i"];
            $source = $_POST["source_$i"];
            $clrdate = $_POST["clrdate_$i"];
            $chqno = $_POST["chqno_$i"];
            

//            if (!empty($clrdate)) {
                mysqli_query($conn,"UPDATE `$maindb` SET  `clrdate`='$clrdate' WHERE `accode`='$code' and `vouchno`='$vouchno' and `source`='$source'") or die(mysqli_error($conn));
//            }
        }

        updmess();
        header("Refresh: 1; bankrecon.php");
    }
}

$senable = "";
$cenable = "";

include("includes/linkshead.php");
?>
<script>
    $(document).ready(function () {
        $(".savetabl").hide();


        $("#proceed").click(function () {
            var acname1 = $('.acname').val();

            if (acname1 == "") {
                alert("Bank cannot be empty");
            } else {



                var acname = $('.acname').val();
                var frmdate = $('.frmdate').val();
                var todate = $('.todate').val();
                var dtype = $('.dtype').val();
                var scope = $('.scope').val();

                $.ajax({
                    type: "POST",
                    url: "bankrecon_fr.php",
                    data: {acname: acname, frmdate: frmdate, todate: todate, dtype: dtype, scope: scope},
                    success: function (result) {
                        if (result != '') {
                            $(".savetabl").show();
                            $(".proctabl").hide();
                        } else {
                            $(".proctabl").show();
                        }
                        $("#data").html(result);

                    }
                });
            }
        });


//        $('#submit').click(function () {
//
//            $('#bill').submit();
//        });

    });

</script>
</head>
<body>
    <form method='POST' action="">
        <!-- Default box -->
        <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12  pad">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <h3 class="panel-title"><?php Echo $formname; ?></h3>
                    <div class="actions pull-right">
                        <i class="fa fa-chevron-down"></i>
                        <i class="fa fa-times"></i>
                    </div>
                </div>
                <div class="panel-body">
                    <div class="row proctabl">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right">
                            <label class="control-label marg">Bank</label>
                        </div>
                        <div class="col-lg-8 col-md-8 col-sm-8 col-xs-8 pad">
                            <select class="form-control acname" name='acname' required>
                                <option value=""></option>
                                <?php
                                $mown1 = mysqli_query($conn,"SELECT accode, bankinit, name FROM `accmast` where grpcode = '001' ORDER BY `name`") or die(mysqli_error($conn));
                                while ($trow1 = mysqli_fetch_array($mown1)) {
                                    echo "<option value='$trow1[accode]'>$trow1[name]</option>";
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <div class="row proctabl">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right">
                            <label class="control-label marg">From Date</label>
                        </div>
                        <div class="col-lg-5 col-md-5 col-sm-5 col-xs-5 pad">
                            <input type="date" size="" name="frmdate" value="<?php echo "$mfrdate"; ?>" required class="form-control frmdate"/>
                        </div>
                    </div>
                    <div class="row proctabl">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right">
                            <label class="control-label marg">To Date</label>
                        </div>
                        <div class="col-lg-5 col-md-5 col-sm-5 col-xs-5 pad">
                            <input type="date" size="" name="todate" value="<?php echo "$mtodate"; ?>" required class="form-control todate"/>
                        </div>
                    </div>
                    <div class="row proctabl">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right">
                            <label class="control-label marg">Type</label>
                        </div>
                        <div class="col-lg-5 col-md-5 col-sm-5 col-xs-5 pad">
                            <select id="cmbtype" name="dtype" class="form-control dtype">
                                <option value=""></option>   
                                <option value="BR">Receipt</option>   
                                <option value="BP">Payment</option>   
                                <option value="TR">Contra</option>   
                            </select>
                        </div>
                    </div>
                    <div class="row proctabl">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right">
                            <label class="control-label marg">Scope</label>
                        </div>
                        <div class="col-lg-5 col-md-5 col-sm-5 col-xs-5 pad">
                            <select id="prinnar" name="scope" class="form-control scope">
                                <option value=""></option>   
                                <option value="A">All</option>   
                                <option value="C">Cleared</option>   
                                <option value="N">Not Cleared</option>   
                            </select>
                        </div>
                    </div>
                    <div class='panel-footer'>



                        <div style="overflow: auto; ">
                            <table class="table-condensed proctabl" style="margin: 0 auto;">
                                <tr>
                                    <td>
                                        <input id="proceed" type='button' name='proceed'  value='Proceed' class="btn btn-success">

                                    </td>
                                    <td>
                                        <input class="btn btn-danger" type="button" onClick="window.location.href = '<?= 'default.php' ?>'" value="Exit   " />
                                </tr>
                            </table>
                            <table class="table-condensed savetabl"  style="margin: 0 auto;">
                                <tr>
                                    <td>
                                        <input id="submit" type='submit' name='submit'  value='Save' class="btn btn-success">
                                    </td>
                                    <td>
                                        <input class="btn btn-danger" type="button" onClick="window.location.href = '<?= $file ?>'" value="Exit   " />
                                    </td>
                                </tr>
                            </table>
                        </div>
                    </div>
                    <div class="col-lg-12" id="data" style="overflow-x: scroll;height:500px;">

                    </div>
                </div>
            </div>
        </div>
    </form>


    <?php include("includes/linksfoot.php"); ?>
</body>
</html>


