0

Hi
I have a issue in print data directly from clicking print button.
Below is my code and working fine. if click print button system sends the data to another page not to printer directly. pls help me

HTML page

<style type="text/css"></style>
<?php
include '../templete/header.php';
?>

<Script Language="javascript">
function change_action()
    {
        var frm_obj=document.getElementById("frm");
        frm_obj.action="data.php";
    }
</Script>



<table class="tbl_table" align="center">
<form action="" method="POST" id="frm" >
    <tr>
        <td class="td_title" colspan="2"><strong>Outstanding Balance Report</strong></td>
    </tr>
      <tr>
        <td class="td_class_right">Until:</td>
        <td><input class="textdesign" type="text" id="datepicker1" name="datefrom" /></td>
      </tr>

        <tr>
        <td class="td_button" colspan="2">
            <input class="buttondesign"   type="submit" value="Search" name="search" onclick="change_action()">
            <input class="buttondesign"   type="submit" value="print" name="print" onclick="change_action()">
        </td>
    </tr>  

</form>
</table>

data.php

<?php
include_once '../inc/connection.inc.php';
?>
<?php
if (isset($_POST['search']) && $_POST['search']  != "" )
    {
        $datefrom=$_POST["datefrom"];
        $s = $dbh->prepare("EXECUTE usp_OutStanding_Balance ?");
        $s->bindParam(1, $datefrom, PDO::PARAM_STR);
        $stmt = $s->execute();

        $stmt = $dbh->query("SELECT * FROM vw_OutStanding_Balance ORDER BY MVName");  
        $stmt->setFetchMode(PDO::FETCH_ASSOC);  
        include 'view.html.php';
     }


?>

<?php
if (isset($_POST['print']) && $_POST['print']  != "" )
    {
        $datefrom=$_POST["datefrom"];
        $s = $dbh->prepare("EXECUTE usp_OutStanding_Balance ?");
        $s->bindParam(1, $datefrom, PDO::PARAM_STR);
        $stmt = $s->execute();

        $stmt = $dbh->query("SELECT * FROM vw_OutStanding_Balance ORDER BY MVName");  
        $stmt->setFetchMode(PDO::FETCH_ASSOC);  
        include 'print.html.php';
     }


?>

print.html.php

<?php
include '../templete/print_head.php';

?>

<?php  
$groupby = '';
$displaySubTotal = FALSE;

$subTotal = 0;
$grandTotal = 0;

$sub_debit=0;  // maideen
$grn_debit=0;  // maideen

$sub_credit=0;  // maideen
$grn_credit=0;  // maideen

$sub_bal=0;  // maideen
$grn_bal=0;  // maideen


?>
<div class="title">Outstanding Report</div>
    <table width="100%" align="center" cellpadding="4" cellspacing="1" class=tbl_table">
        <tr><td colspan="6"><hr /></td></tr>
        <tr>
            <td class="tdempty"></td>
            <td class="tbl_header">MV CODE</td>
            <td class="tbl_header">MV NAME</td>
            <td class="tbl_header_right">DEBIT</td>
            <td class="tbl_header_right">CREDIT</td>
            <td class="tbl_header_right">BALANCE</td>
            <td class="tdempty"></td>


        </tr>
        <tr><td colspan="6"><hr /></td></tr>
        <?php if(isset($stmt))
        {
        while($row = $stmt->fetch()): 
              if($groupby!=$row['MVName']):

                if($displaySubTotal): ?>

               <?php 


                     $grn_debit += $sub_debit;
                     $sub_debit=0;

                     $grn_credit += $sub_credit;
                     $sub_credit=0;

                     $grn_bal += $sub_bal;
                     $sub_bal=0;
                else: 
                      $displaySubTotal = TRUE;
                endif; 
                      $groupby = $row['MVName']; 

                endif; 
                ?>
            <tr>
                <td class="tdempty"></td>
                <td class="tbl_content"><?php echo $row['MVcode'];?></td>
                <td class="tbl_content"><?php echo $row['MVName'];?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Debit'],2) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Credit'],2) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Balance'],2) ;?></td>
                <td class="tdempty"></td>
             </td>

            <?php 

                 $sub_debit += $row['Debit'];
                 $sub_credit += $row['Credit'];
                 $sub_bal += $row['Balance'];

                 endwhile; 

                 $grn_debit += $sub_debit;
                 $grn_credit += $sub_credit;
                 $grn_bal += $sub_bal;
            ?>

        <tr><td colspan="6"><hr /></td></tr>
        <tr>
            <td colspan="2">
            <td class="tbl_subtotal_left"><b>Grand Total</b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_debit,2); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_credit,2); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_bal,2); ?></b></td>

        </tr>
        <tr><td colspan="6"><hr /></td></tr>
        <?php }?>
    </table>
   <?php unset($dbh); unset($stmt); ?>

Pls help me

Maideen

2
Contributors
1
Reply
21
Views
4 Years
Discussion Span
Last Post by IIM
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.