File: /home/cafsindia/refimac_cafsjobs_com/print_labour.php
<?php
include('dbconnect.php');
//session_start();
$id=$_REQUEST['id'];
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
if($user=="")
header("Location:index.php?get1=4");
if($id!="")
{
$idval=explode(',',$id);
//print $idval;
$id=str_replace(',',"','",$id);
//echo "SeLECT * FROM `customer` inner join sales on customer.CUSTOMER_CODE=sales.CUSTOMER_CODE where SALES_ID='".$idval['0']."'"; die;
$sql_check=mysql_query("SeLECT * FROM `customer` inner join sales on customer.CUSTOMER_CODE=sales.CUSTOMER_CODE where SALES_ID='".$idval['0']."'");
$row_fetch=mysql_fetch_array($sql_check);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>LABOUR ONLY</title>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 22px;
font-weight: bold;
}
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style3 {font-size: 12px; font-family: Arial, Helvetica, sans-serif;}
.style6 {font-size: 14px; font-family: Arial, Helvetica, sans-serif; }
p {
font-size: 20px;
-webkit-margin-before: 0.3em;
-webkit-margin-after: 0.3em;
}
td {
font-size: 22px;
}
-->
@media print {
footer {page-break-after: always;}
}
p.points {
padding-left: 120px;
}
p.classpoints {
padding-left: 167px;
padding-right: 20px;
}
td.fontchange p {
font-size: 23px;
}
</style>
</head>
<body style="margin-top:-10">
<div align="center">
<?php /*?><?php
$id=$_REQUEST['id'];
if($id!="")
{
$sql11="select * from etaapp_callreg where reg_id=".$id." and tech_allocate!=''";
//echo $sql11;
$qu11=mysql_query($sql11);
$n11=mysql_num_rows($qu11);
if($n11==1)
{
$sqln="update etaapp_callreg set print_st='Y' where reg_id=".$id."";
$qun=mysql_query($sqln);
}
$sql="select * from etaapp_callreg where reg_id=".$id."";
$qu=mysql_query($sql);
while($r=mysql_fetch_array($qu))
{
?><?php */?>
<table width="1000" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<table width="100%" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td colspan="2"><div align="center"><strong>PROFORMA INVOICE</strong></div></td>
</tr>
<tr>
<td width="35%"><!--<img src="img/barcode.png" height="120" align="right" style="padding-right:30px" /> --> <p>LABOUR ONLY </p>
<p>Refimac</p>
<p>No.309, Nehru Nagar, OMR, Kottivakkam, Chennai - 600 096 <br />
Service : 2454 3030 / 2454 2626 </p>
<p>Break Down : 2454 0071 / 2454 0234</p></td>
<td width="65%"><p>To </p>
<p>NAME : <?php echo $row_fetch['CUSTOMER_NAME']; ?> </p>
<p> <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_SURROUND_AREA'].','.$row_fetch['CUSTOMER_CITY'].','.$row_fetch['CUSTOMER_PINCODE'].'.'; ?></p>
<p>Phone No.:<?php echo $row_fetch['CUSTOMER_PHONE']; ?> Cell No. :<?php echo $row_fetch['CUSTOMER_MOBILE']; ?></p></td>
</tr>
<tr>
<td height="110" colspan="2"><p><strong>Dear Sir,</strong> <br />
<strong>Sub : Scheduled Preventive Maintenance Service Schedule (SPMS)</strong> </p>
We wish to give you an advance intimation that the Warranty / Contract period for the following Air-conditioners in expiring. We are pleased to quote for Maintenance Service contract enabling your Air-conditioners to give the best year round performance the details of the scheme attached here with.</td>
</tr>
<tr>
</tr>
</table>
</td>
<tr>
<td>
<table cellspacing="2" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td width="108" height="37" align="center" bgcolor="#E8E8E8" class="style1"><strong>MAKE</strong></td>
<td width="174" align="center" bgcolor="#E8E8E8" class="style1"><strong>MODEL</strong></td>
<td width="317" align="center" bgcolor="#E8E8E8" class="style1">Unit Serial No.</td>
<td width="138" align="center" bgcolor="#E8E8E8" class="style1"><strong>RATE PER UNIT</strong></td>
<td width="229" align="center" bgcolor="#E8E8E8" class="style1"><strong>PERIOD FROM - TO</strong></td>
</tr>
<?php
// echo "SeLECT * FROM sales where SALES_ID in ('".$id."')"; die;
$sql_check=mysql_query(" SeLECT * FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in in ('".$id."') GROUP by service.SALES_ID");
$row_fetch=mysql_fetch_array($sql_check);
$i=0;{ ?>
<tr>
<td height="37" bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
</tr>
<?php $i++;} ?>
<?php for($i=1;$i<=11;$i++) { ?>
<tr>
<td height="37" bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
<td bgcolor="#FFFFFF" class="style1" align="center"> </td>
</tr>
<?php } ?>
<tr>
<td height="17" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">As per the Contract Value </p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"> </td>
<td rowspan="4" align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><div align="right">30% Contract Value Rs.......................15% Service Tax</div></td>
<td align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="37" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">70% Contract Value Rs.......................14.5% VAT Component </p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="37" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><div align="right"><strong>TOTAL</strong></div></td>
<td align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class="style1"><div align="left">Payment Terms 100% Advance Cheque in favour of Refimac Only, In case of Tax Deduction please provide TDS Certificate along with the payment.</div></td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class="style1"><p align="center"><strong>Accep</strong><strong>t</strong><strong>ance</strong> </p>
<p align="left">We accept your above Quotation and also the terms and condition Enclosing Please find our Cheque<u> </u> dt.<u> </u> on<u> </u> for Rs.<u> </u> </p>
<p align="left">For <strong><em>REFIMAC</em></strong> </p>
<p align="left"> </p>
<p align="left">Authorised Signatory CUSTOMER’S SIGNATURE</p></td>
</tr>
</table> </td>
</tr>
<tr><td > </td>
</tr>
</tr>
</table>
<footer></footer>
<table width="1000" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td class="fontchange">
<p align="center"><strong>TERMS & CONDITIONS OF CONTRACT</strong> <br /><p>
<p class="points"> <strong>A</strong><strong>. Under the this Scheme we undertake to render the following Services</strong> <br /> <p>
<p class="classpoints"> 1. Periodical Service <u> </u> times in a year. <br />
2. Breakdown attendance of the Air-conditioner when called upon during normal working hours. <br />
3. Overhaul of the unit in our service station as and when required. A service unit may be provided if available. <br />
</p>
<p class="points"> <strong>B</strong><strong>. Following service could be however provided on chargeable basis</strong> <br /> </p>
<p class="classpoints"> i. Any missing parts. <br />
ii. Extra wire or accessories required for the use of Air-conditioner. </br>
iii. Shift of Air-Conditioner <br />
iv. Repair replacement of parts like compressor, Electrical Compondents, Thermostart, Gas charging, Selector Switch Filter, Fan/Blower Motor, Sheet Metal Works. <br />
v. Attendance to Voltage Stabilizer or other accessories if any Cordless Remote, PCB etc vi. Replacement of condenser cooling coil, Grill, Outer Cabinet, Water Tray, Oscillatin, <br />
Louver Motor Etc., <br /></p>
<p class="points"> <strong>C.</strong> <br /> </p>
<p class="classpoints"> 1. The annual contract fee is Rs................................and is payable in advance. The contract will be presumed to be effective only if payment is received. <br />
2. We will have option to terminate the contract in case of change of location without our written consent for any reason whatsoever and in that event proportionate contract fee shall not be refundable. <br />
3. The contract is strictly non-transferable. <br />
4. Once the contract is concluded, the Owner will not have option to unilaterally terminate it prematurely. <br />
5. This agreement will not cover if there is loss or damage due to irregular voltage abuse or misuse, accident, serial number/missing/altered use of any part not supplied by us. <br />
6. Our responsibility under this contract ceases if the air-conditioner is serviced or repaired by any person other than our authorized representative during the contract period. <br />
7. The Air-conditioner should be in normal working Condition before the contract is given effect to in case any repairs/replacements are found necessary such repairs, replacement will be carried out at your cost. <br />
8. Under to circumstances will the services under this contract be available if the Air- Conditioner is shifted to outside the city limits. In this event also the proportionate service contract fee will not be refundable. <br />
9. FORCE MAJOR CLOSURE : We shall not be liable for any break or nor performance or delay in carrying out any of the obligations contained in this maintenance service leaflet including servicing/repairing of the unit as a result of strike, lockout Industrial/ Labour disturbance fire accidental damage restrictions imposed by the Goverment circumstances beyond our control any act of God, Riot any war condition arising from similar causes beyond our extended. <br />
10. During the periodical servicing, if the premises is found locked, postponement of date of service should be give by the customer. <br />
11. If the date is not given by the customer, the service for that month will not be done, nor the contract period will be extended. </p> </td>
<tr>
</table>
<?php /*?><?php
}
}
?><?php */?>
</div>
</body>
</html>
<?php } ?>