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

$zdb = $_SESSION["zdbyear_" . $dbname];
$zyear = right($zdb, 4);
$mfrdate = getzdates($zyear, 'S');
$mtodate = getzdates($zyear, 'E');


$formname = "Multiple Envelope / Label / List Print";
$action = "envprin_multi.php";
//mysqli_select_db($conn, $zdb);

include("includes/linkshead.php");
?>
</head>
<script>
    $(document).ready(function() {
        // $("#cmbto").change(function() {
        //     var frm = $("#cmbfrom").val();
        //     var to = $("#cmbto").val();
        //     if (frm == to) {
        //         alert("From & To Value Canot Be Same");
        //         $('#cmbto').focus();
        //         $('#cmbto').html('');
        //     }

        // });
      
        $('#view1').click(function() {
            $('#repprint').attr('action', 'labels_fr.php');
        });
        $('#view2').click(function() {
            $('#repprint').attr('action', 'envprin_multi.php');
        });
        $('#view3').click(function() {
            $('#repprint').attr('action', 'addbook_print_fr.php');
        });

        $("#sexcel").hide();

    });
</script>

<body>
    <form method='POST' id="repprint" action="<?= $action; ?>">
        <!-- Default box -->

        <div class="col-lg-6 col-md-12 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>
                <div class="panel-body">


                    <div class="row">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                            <label class="label-control marg">Name</label>
                        </div>
                        <div class="col-lg-6 col-md-4 col-sm-6 col-xs-6 pad">
                            <select name="name" class="form-control name select2" style="width:100%">
                                <option value=""></option>
                                <?php
                                $mown4 = mysqli_query($conn, "SELECT `accode`, `name` FROM `address` WHERE accode != '' AND grpcode = '010' ORDER BY name") or die(mysqli_error($conn));
                                while ($trow4 = mysqli_fetch_array($mown4)) {
                                    echo "<option value='$trow4[accode]'>$trow4[name]</option>";
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                            <label class="label-control marg">State</label>
                        </div>
                        <div class="col-lg-4 col-md-4 col-sm-6 col-xs-6 pad">
                            <select name="state" class="form-control state select2" style="width:100%">
                                <option value=""></option>
                                <?php
                                $mstate = mysqli_query($conn, "SELECT state FROM `address` WHERE state != '' AND grpcode = '010' group by state ORDER BY state") or die(mysqli_error($conn));
                                while ($tstate = mysqli_fetch_array($mstate)) {
                                    echo "<option value='$tstate[state]'>$tstate[state]</option>";
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                            <label class="label-control marg">City</label>
                        </div>
                        <div class="col-lg-4 col-md-4 col-sm-6 col-xs-6 pad">
                            <select name="city" class="form-control city select2" style="width:100%">
                                <option value=""></option>
                                <?php
                                $mcity = mysqli_query($conn, "SELECT UPPER(city)AS city FROM `address` WHERE city != '' AND grpcode = '010' group by city ORDER BY city") or die(mysqli_error($conn));
                                while ($tcity = mysqli_fetch_array($mcity)) {
                                    echo "<option value='$tcity[city]'>$tcity[city]</option>";
                                }
                                ?>
                            </select>
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                            <label class="label-control marg">Type</label>
                        </div>
                        <div class="col-lg-3 col-md-4 col-sm-8 col-xs-8 pad">
                            <select class="form-control type select2" name="type">
                                <option value="">All</option>
                                <option value="1">With Address</option>
                                <option value="2">Without Address</option>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="panel-footer text-center">
                    <div class="col-lg-12 col-md-3 col-sm-3 col-xs-3 text-right pad">
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                            <table class="table-condensed" style="margin: 0 auto;">
                                <td class=" buttonform tooltip-bottom" id="ssubmit" style="display: <? echo $savedisabled ?>" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="View">
                                    <button id='view1' type='submit' formtarget="_blank" name='view' class="btn btn-pad btn-square" style="background-image: linear-gradient(135deg, #0acffe 10%, #495aff 100%) !important;border-radius:10px;width:140px;font-size:12px">
                                    <b style="font-family:Arial, Helvetica, sans-serif">Labels Print</b>
                                    </button>
                                </td>
                            </table>
                        </div>
                        <div class="col-lg-6 col-md-4 col-sm-4 col-xs-4 text-right pad">
                            <table class="table-condensed" style="margin: 0 auto;">
                                <td class=" buttonform tooltip-bottom" id="ssubmit" style="display: <? echo $savedisabled ?>" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="View">
                                    <button id='view2' type='submit' formtarget="_blank" name='view' class="btn btn-pad btn-square" style="background-image: linear-gradient(135deg, #97ABFF 10%, #123597 100%) important;border-radius:10px;width:140px;font-size:12px">
                                    <b style="font-family:Arial, Helvetica, sans-serif">Envelope Print</b>
                                    </button>
                                </td>
                            </table>
                        </div>
                        <div class="col-lg-3 col-md-4 col-sm-4 col-xs-4 text-right pad">
                            <table class="table-condensed" style="margin: 0 auto;">
                                <td class=" buttonform tooltip-bottom" id="ssubmit" style="display: <? echo $savedisabled ?>" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="View">
                                    <button id='view3' type='submit' formtarget="_blank" name='view' class="btn btn-pad btn-square" style="background-image: linear-gradient(135deg, #70F570 10%, #49C628 100%) !important;border-radius:10px;width:140px;font-size:12px">
                                        <b style="font-family:Arial, Helvetica, sans-serif">Address List</b>
                                    </button>
                                </td>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </form>
    <?php include("includes/linksfoot.php"); ?>
</body>

</html>