Пример #1
0
    public function Export($param, $indent_stmt, $cust_addr)
    {
        $form_data = explode("::", $param);
        $sdate = $form_data[0];
        $edate = $form_data[1];
        $cust_name = $form_data[2];
        header("Content-type: application/vnd.ms-word");
        header("Content-Disposition: attachment; filename=Indent_statement from " . $sdate . " to " . $edate . ".doc");
        print "<tr>";
        print "<p align='center' style='margin-top:5px;font-size:15pt;font-weight:bold;'>Statements For Indent Sales </p>";
        print "</tr>";
        ?>
	  
<div  style='width:100%;'>
<div style='float:left;margin-top:20px;margin-left:10px;width:40%;'  >
<table  border='0' align='left'  style='border-collapse:collapse;margin-bottom:20px;margin-left:10px;float: left;font-size:10pt;' > 
<tr><td>From</td><td>PRICOL FUEL & LUBE SERVICES,</td></tr>
<tr><td></td><td>SURVEY NO - 318/319, P.N.PALAYAM,</td></tr>
<tr><td></td><td>COIMBATORE - 641020</td></tr>
</table>
</div>
<?php 
        foreach ($cust_addr as $addr) {
            $addrs = explode('%%', $addr['address']);
            $total_bills = $addr["total_bills"];
            $total_payments = $addr["total_payments"];
        }
        foreach ($cust_addr as $names) {
        }
        ?>

<div style='float:left;margin-top:20px;width:20%;'>
<table  border='0'    style='border-collapse:collapse;float: left;font-size:10pt;' >
<tr><td>To</td><td><?php 
        if (isset($names["customer_name"])) {
            echo strtoupper($names["customer_name"]);
        }
        ?>
</td></tr>
<tr><td></td><td><?php 
        if (isset($addrs[0])) {
            echo $addrs[0];
        }
        ?>
</td></tr>
<tr><td></td><td><?php 
        if (isset($addrs[1])) {
            echo $addrs[1];
        }
        ?>
</td></tr>
<tr><td></td><td><?php 
        if (isset($addrs[2])) {
            echo $addrs[2];
        }
        ?>
</td></tr>
</table>
</div>

</div>
<?php 
        print "<p align='justify' style='margin-top:80px;font-size:10pt;class='alt_row';font-weight:bold;margin-bottom:20px;'>Indent Fuels/Lubes Sales Details for the Period {$sdate} To {$edate} </p>";
        print "<table width='%100' align='left' cellpadding='1' cellspacing='1' margin='10px' style='border-collapse:collapse;font-size:9pt;margin-bottom:20px;'>";
        print "<tr bgcolor='#559999' id='hdr_row' style='color:white;border-right:1px solid white; '>";
        print "<td width='12%' align='center'>Bill Date</td>";
        print "<td width='12%' align='center'>Shift</td>";
        print "<td width='12%' align='center'>Indent No</td>";
        print "<td width='12%' align='center'>Reference No</td>";
        print "<td width='12%' align='center'>Bill No</td>";
        print "<td width='20%' align='center'>Type of Product</td>";
        print "<td width='10%' align='center'>Quantity(Ltrs)</td>";
        print "<td width='10%' align='center'>MRP(Rs)</td>";
        print "<td width='12%' align='center'>Amount(Rs)</td>";
        print "</tr>";
        $veh_no = "";
        $ctr = 0;
        $r_tot_amt = 0;
        $t_tot_amt = 0;
        foreach ($indent_stmt as $openrow) {
            if ($veh_no != $openrow["vehicle_number"]) {
                if ($ctr != 0) {
                    print "<tr class='td_rows'>";
                    print "<td width='12%' align='right' colspan='8'></td>";
                    print "<td width='12%' align='center'>" . round($r_tot_amt, 3) . "</td>";
                    print "</tr>";
                }
                $veh_no = $openrow["vehicle_number"];
                $ctr++;
                $r_tot_amt = 0;
                print "<tr class='td_rows'>";
                print "<td width='12%' align='left' colspan='9'>" . $openrow["vehicle_number"] . "</td>";
                print "</tr>";
            }
            $r_tot_amt += round($openrow["value"], 3);
            $t_tot_amt += round($openrow["value"], 3);
            /* print("<tr class='td_rows'>");
            		 print("<td width='12%' align='center'><input type='text'  readonly='readonly' value='".$openrow["billdate"]."' size='10' class='plain_txt' /></td>");
                        print("<td width='12%' align='center'><input type='text'  readonly='readonly' value='".$openrow["shift"]."' size='10' class='plain_txt' /></td>");
                        print("<td width='12%' align='center'><input type='text'  readonly='readonly' value='".$openrow["indent_no"]."' size='8' class='plain_txt' /></td>");
                        print("<td width='12%' align='center'><input type='text' readonly='True' value='".$openrow["bill_number"]."' size='5' class='plain_txt'/></td>");
                        print("<td width='20%' align='center'><input type='text' readonly='True' value='".$openrow["product"]."' size='20' class='plain_txt' /></td>");
                        print("<td width='10%' align='center'><input type='text' readonly='True' value='".$openrow["quantity"]."' size='35' class='plain_txt' /></td>");             
                        print("<td width='10%' align='center'><input type='text' readonly='True' value='".$openrow["rate"]."' size='6' class='plain_txt' /></td>");             
                        print("<td width='12%' align='center'><input type='text' readonly='readonly' value='".$openrow["value"]."' size='8' class='plain_txt' /></td>");
                        
                        print("</tr>");
                        */
            print "<tr class=''>";
            print "<td width='12%' align='center'>" . ($openrow["billdate"] != '0000-00-00' && $openrow["billdate"] != '' ? date('d-m-Y', strtotime($openrow["billdate"])) : '') . "</td>";
            print "<td width='12%' align='center'>" . $openrow["shift"] . "</td>";
            print "<td width='12%' align='center'>" . $openrow["indent_no"] . "</td>";
            print "<td width='12%' align='center'>" . $openrow["reference_no"] . "</td>";
            print "<td width='12%' align='center'>" . $openrow["bill_number"] . "</td>";
            print "<td width='20%' align='center'>" . $openrow["product"] . "</td>";
            print "<td width='10%' align='center'>" . $openrow["quantity"] . "</td>";
            print "<td width='10%' align='center'>" . $openrow["rate"] . "</td>";
            print "<td width='12%' align='center'>" . $openrow["value"] . "</td>";
            print "</tr>";
        }
        if ($ctr != 0) {
            print "<tr class='td_rows'>";
            print "<td width='12%' align='right' colspan='8'></td>";
            print "<td width='12%' align='center'>" . round($r_tot_amt, 3) . "</td>";
            print "</tr>";
            /*print("<tr class='td_rows'>");
            	 print("<td width='12%' align='right' colspan='7'>Total</td>");
                               
                       print("<td width='12%' align='center'>".round($t_tot_amt,3)."</td>");
                       print("</tr>");
                       print("<tr class='td_rows'>");
            	 print("<td width='12%' align='right' colspan='7'>Old Arrears</td>");
            	 if(!isset($old_arrears)){
                       $old_arrears=$total_bills-$total_payments;
            	 }
                       print("<td width='12%' align='center'>".round($old_arrears,3)."</td>");
                       print("</tr>");*/
            print "<tr class='td_rows'>";
            print "<td width='12%' align='right' colspan='8'>Grand Total</td>";
            //$grant_tot=$t_tot_amt+$old_arrears;
            $grant_tot = $t_tot_amt;
            print "<td width='12%' align='center'>" . round($grant_tot, 2) . "</td>";
            print "<input type='hidden' id='grand_tot' name='grand_tot' value='" . round($grant_tot, 2) . "' />";
            // print("<input type='hidden' id='old_arrears' name='old_arrears' value='".round($old_arrears,3)."' />");
            print "</td></tr>";
            print "</table>";
            if ($grant_tot > 0) {
                $tot_arr = explode('.', round($grant_tot, 2));
                print "<p align='center' style='margin-top:80px;font-size:9pt;font-weight:bold;'>";
                if (isset($tot_arr[1]) and $tot_arr[1] != '') {
                    print no_to_word($tot_arr[0], '1') . " " . no_to_word_paise(str_pad($tot_arr[1], 2, "0"));
                } else {
                    print no_to_word($tot_arr[0], '0');
                }
                print "</p>";
            }
        }
    }
Пример #2
0
               print("<tr class='td_rows'>");
    	 print("<td width='12%' align='right' colspan='7'>Old Arrears</td>");
    	 if(!isset($old_arrears)){
               $old_arrears=$total_bills-$total_payments;
    	 }
               print("<td width='12%' align='center'>".round($old_arrears,3)."</td>");
               print("</tr>");*/
    print "<tr class='td_rows'>";
    print "<td width='12%' align='right' colspan='8'>Grand Total</td>";
    //$grant_tot=$t_tot_amt+$old_arrears;
    $grant_tot = $t_tot_amt;
    print "<td width='12%' align='center'>" . round($grant_tot, 2) . "</td>";
    print "<input type='hidden' id='grand_tot' name='grand_tot' value='" . round($grant_tot, 2) . "' />";
    // print("<input type='hidden' id='old_arrears' name='old_arrears' value='".round($old_arrears,3)."' />");
    print "</td></tr>";
    print "</table>";
    if ($grant_tot > 0) {
        $tot_arr = explode('.', round($grant_tot, 2));
        print "<p align='center' style='margin-top:80px;font-size:9pt;font-weight:bold;'>";
        if (isset($tot_arr[1]) and $tot_arr[1] != '') {
            print no_to_word($tot_arr[0], '1') . " " . no_to_word_paise(str_pad($tot_arr[1], 2, "0"));
        } else {
            print no_to_word($tot_arr[0], '0');
        }
        print "</p>";
        print "<p align='left' style='margin-top:30px;margin-left:30px;font-size:9pt;font-weight:bold;'> Note: This is Computer generated bill. Signature is not required.</p>";
    }
}
?>