File: /home/cafsindia/refimac_cafsjobs_com/print_all_26june2018.php
<?php
include('dbconnect.php');
//session_start();
$id=$_REQUEST['number'];
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
//echo $_POST['hiddennvalue']; die;
if($user=="")
header("Location:index.php?get1=4");
$macvalue=$_POST['hiddennvalue'];
//echo $macvalue; die;
if($macvalue!="")
{
//echo $macvalue;
$arrayvalue=explode('^',$macvalue);
foreach ($arrayvalue as $value)
{
$number=$value;
$id=$number;
$numberval=str_replace(',',"','",$number);
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;
}
p {
font-size: 20px;
-webkit-margin-before: 0.3em;
-webkit-margin-after: 0.3em;
font-weight:bold;
}
td {
font-size: 22px;
font-weight: bold;
}
-->
@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: 22px;
}
</style>
</head>
<body >
<?php if($row_fetch['SERVICEMODE_ID']=="1") {?>
<table width="1000" border="0" cellspacing="1" cellpadding="1" style="padding-top: 10px;">
<tr>
<td>
<table width="100%" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td colspan="2"><div align="center" style="
font-size: 26px;
"><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><strong style="
font-size: 24px !important;
">LABOUR ONLY</strong> </p>
<p style="
font-size: 24px !important;
"><strong>Refimac</strong></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 <img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http%3A%2F%2Fwww.refimac.com-AMC-<?php echo date('d-m-Y H:i:s').'/'.$row_fetch['CUSTOMER_CODE'];?>%2F&choe=UTF-8" title="refimac.com" height="120" align="right" style="padding-right:30px"/></p>
<p>NAME : <?php echo $row_fetch['CUSTOMER_NAME']; ?> </p>
<p> <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_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>
<p>Email ID.: </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="90" 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="470" align="center" bgcolor="#E8E8E8" class="style1">Unit Serial No.</td>
<td width="150" align="center" bgcolor="#E8E8E8" class="style1"><strong>RATE PER UNIT</strong></td>
<td width="100" 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 *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval, (select wlamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID");
//echo "SELECT * , make.MAKE_NAME AS MAKE_NAME, model.MODEL_NAME AS MODEL_NAME, service_mode.SERVICE_MODE_NAME AS modeval, amc_model_list.wlamount AS LAMOUNT, purchase.PURCHASE_SERIALNUMBER AS SERIALNOVA FROM sales INNER JOIN service ON sales.SALES_ID = service.SALES_ID INNER JOIN make ON make.MAKE_ID = sales.MAKE_ID INNER JOIN model ON model.MODEL_ID = sales.MODEL_ID INNER JOIN service_mode ON service_mode.SERVICE_MODE_ID = sales.SERVICEMODE_ID INNER JOIN amc_model_list ON amc_model_list.model_list_id = sales.Model_id INNER JOIN purchase ON purchase.PURCHASE_ID = sales.PURCHASE_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc";
//$sql_check=mysql_query("SeLECT *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval,(select wlamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT,(select PURCHASE_SERIALNUMBER from purchase where PURCHASE_ID=sales.PURCHASE_ID) AS SERIALNOVAL FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
//echo "SELECT * , make.MAKE_NAME AS MAKE_NAME, model.MODEL_NAME AS MODEL_NAME, service_mode.SERVICE_MODE_NAME AS modeval, amc_model_list.wlamount AS LAMOUNT, purchase.PURCHASE_SERIALNUMBER AS SERIALNOVA,(select PURCHASE_SERIALNUMBER FROM purchase where purchase.PURCHASE_ID=sales.PURCHASE_ID order by sales.SALES_ID limit 0,1) as SRVSERIALNO FROM sales INNER JOIN service ON sales.SALES_ID = service.SALES_ID INNER JOIN make ON make.MAKE_ID = sales.MAKE_ID INNER JOIN model ON model.MODEL_ID = sales.MODEL_ID INNER JOIN service_mode ON service_mode.SERVICE_MODE_ID = sales.SERVICEMODE_ID INNER JOIN amc_model_list ON amc_model_list.model_list_id = sales.Model_id INNER JOIN purchase ON purchase.PURCHASE_ID = sales.PURCHASE_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc";
$sql_check=mysql_query("SELECT * , make.MAKE_NAME AS MAKE_NAME, model.MODEL_NAME AS MODEL_NAME, service_mode.SERVICE_MODE_NAME AS modeval, amc_model_list.wlamount AS LAMOUNT, purchase.PURCHASE_SERIALNUMBER AS SERIALNOVA,(select PURCHASE_SERIALNUMBER FROM purchase where purchase.PURCHASE_ID=sales.PURCHASE_ID order by sales.SALES_ID limit 0,1) as SRVSERIALNO FROM sales INNER JOIN service ON sales.SALES_ID = service.SALES_ID INNER JOIN make ON make.MAKE_ID = sales.MAKE_ID INNER JOIN model ON model.MODEL_ID = sales.MODEL_ID INNER JOIN service_mode ON service_mode.SERVICE_MODE_ID = sales.SERVICEMODE_ID INNER JOIN amc_model_list ON amc_model_list.model_list_id = sales.Model_id INNER JOIN purchase ON purchase.PURCHASE_ID = sales.PURCHASE_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
//echo "SeLECT *,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID"; die;
$i=1;
$lamount=0;
while($row_fetch=mysql_fetch_array($sql_check))
{
$sqlprice="SELECT * FROM amc_model_list WHERE model_no='".$row_fetch['MODEL_NAME']."' and status='Y'";
$quprice=mysql_query($sqlprice);
$row_price=mysql_fetch_array($quprice);
$servicecount=$row_fetch['NO_OF_SERVICES'];?>
<tr>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MAKE_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MODEL_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['SRVSERIALNO']; ?></td>
<td valign="center" nowrap="nowrap " style="font-size: 17px !important;padding: 10px;">Rs.<?php echo $row_price['lamount']; ?></td>
<td nowrap="nowrap" valign="center" style="font-size: 17px;padding: 10px;"><?php echo $start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +1 day'))." to ".$start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +365 day')) ?></td>
</tr>
<?php $i++; $lamount=$lamount+$row_price['lamount'];}?>
<?php for($i=$i;$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"><div align="left">Rs.<?php if($lamount!=0) echo $lamount;?></div></td>
<td rowspan="4" align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">As per GST service tax is charged at the rate of 18%.</br>(this is inclusive of CGST & SGST)</p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"><div align="left">Rs.<?php if($lamount!=0) echo (($lamount) * (0.18)); ?></div></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"><div align="left">Rs.<?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?></div></td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class=""><div align="left">Payment Terms 100% Advance Cheque in favour of <strong>Refimac</strong> 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>
<tr>
<td align="center" style="
color: darkblue;
font-size: 16px;
">
<strong>AUTHORIZED AIRCONDITIONER DISTRIBUTOR</strong>
</td>
</tr>
<tr>
<td >
</br>
<img src="img/lg.png" width="100" height="75" />
<img src="img/general.png" width="100" height="75" />
<img src="img/dikin.png" width="100" height="75" />
<img src="img/vestar.png" width="100" height="75" />
<img src="img/sam.png" width="150" height="75" />
</td>
</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>
<p>
<p class="classpoints"> 1. Periodical Service <u> 4 </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></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. During this contract if the Air Conditioner required major over hauling it has to be taken to the service station for repair. The transportation it to be borne by client. <br/>
v. Repair replacement of parts like compressor, Electrical Compondents, Thermostart, Gas charging, Selector Switch Filter, Fan/Blower Motor, Sheet Metal Works. <br />
vi. 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., </p>
<p class="points"> <strong>C.</strong></p>
<p class="classpoints"> 1. The annual contract fee is Rs. <?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?> 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.During the periodical servicing, if the premises is found locked, postponement of date of service should be give by the customer.<br />
10. 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 />
</td>
<tr>
</table>
<footer></footer>
<?php
$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);
?>
<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" style="
font-size: 26px;
"><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><strong style="
font-size: 24px !important;
">EXCEPT COMPRESSOR </strong></p>
<p style="
font-size: 24px !important;
"><strong>Refimac</strong></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 <img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http%3A%2F%2Fwww.refimac.com-AMC-<?php echo date('d-m-Y H:i:s').'/'.$row_fetch['CUSTOMER_CODE'];?>%2F&choe=UTF-8" title="refimac.com" height="120" align="right" style="padding-right:30px"/></p>
<p>NAME : <?php echo $row_fetch['CUSTOMER_NAME']; ?> </p>
<p> <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_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>
<p>Email ID.: </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="90" 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="470" 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="150" 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 *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval, (select wexamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT,(select PURCHASE_SERIALNUMBER from purchase where PURCHASE_ID=sales.PURCHASE_ID) AS SERIALNOVAL,(select PURCHASE_SERIALNUMBER FROM purchase where purchase.PURCHASE_ID=sales.PURCHASE_ID order by sales.SALES_ID limit 0,1) as SRVSERIALNO FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
// echo "SeLECT *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval, (select wexamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID"; die;
//echo "SeLECT *,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID"; die;
$i=1;
$lamount=0;
while($row_fetch=mysql_fetch_array($sql_check))
{
$sqlprice="SELECT * FROM amc_model_list WHERE model_no='".$row_fetch['MODEL_NAME']."' and status='Y'";
//echo $sqlprice;
$quprice=mysql_query($sqlprice);
$row_price=mysql_fetch_array($quprice);
$servicecount=$row_fetch['NO_OF_SERVICES'];?>
<tr>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MAKE_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MODEL_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['SRVSERIALNO']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;">Rs.<?php echo $row_price['excomp']; ?></td>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +1 day'))." to ".$start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +365 day')) ?></td>
</tr>
<?php $i++; $lamount=$lamount+$row_price['excomp'];}?>
<?php for($i=$i;$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 } ?>
<?php if($lamount==0 || $lamount=="") $lamount="";?>
<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"><div align="left">Rs.<?php if($lamount!=0) echo $lamount; ?></div></td>
<td rowspan="4" align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">As per GST service tax is charged at the rate of 18%.</br>(this is inclusive of CGST & SGST)</p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"><div align="left">Rs.<?php if($lamount!=0) echo (($lamount) * (0.18)); ?></div></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"><div align="left">Rs.<?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?></div></td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class=""><div align="left">Payment Terms 100% Advance Cheque in favour of<strong> Refimac</strong> 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. <?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?><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>
<tr>
<td align="center" style="
color: darkblue;
font-size: 16px;
">
<strong>AUTHORIZED AIRCONDITIONER DISTRIBUTOR</strong>
</td>
</tr>
<tr>
<td >
</br>
<img src="img/lg.png" width="100" height="75" />
<img src="img/general.png" width="100" height="75" />
<img src="img/dikin.png" width="100" height="75" />
<img src="img/vestar.png" width="100" height="75" />
<img src="img/sam.png" width="150" height="75" />
</td>
</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> 4 </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.</p>
<p class="classpoints"> <br />
<p class="classpoints"> <strong>4.</strong><strong style="
font-size: 21px;
"> <u>PARTS WOULD BE REPLACED FREE OF COST DURING THIS CONTRACT</u></strong> <br />
<p class="classpoints">
Indoor blower wheel/Motor,Outdoor fan blade/Motor,Capacitor service value and in case of refrigent leak welding of condenser and cooling coil if possible then pressure testing, vacummising,reprocessing and transportation. </p>
<p class="classpoints"><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. Attendance to Voltage Stabilizer </br>
v. Replacement of condenser cooling coil which are beyond repairable condition, Compressor, oscilating,swing,step motor,remote,PCB,Indoor/Outdoor thermister's all plastic Parts except fan blade and Blower wheel will be charged. </p>
<p class="points"> <strong>C</strong><br /> </p>
<p class="classpoints">
1. The annual contract fee is Rs. <u><?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?></u>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. </p>
<p class="classpoints">9.During the periodical servicing, if the premises is found locked, postponement of date of service should be give by the customer.<br />
10
. 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 />
<br />
</p></td>
<tr>
</table>
<footer></footer>
<?php
}
else if($row_fetch['SERVICEMODE_ID']=="2")
{ ?>
<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" style="padding-top: 10px;">
<tr>
<td>
<table width="100%" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td colspan="2"><div align="center" style="
font-size: 26px;
"><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><strong style="
font-size: 24px !important;
">LABOUR ONLY </strong></p>
<p style="
font-size: 24px !important;
"><strong>Refimac</strong></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 <img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http%3A%2F%2Fwww.refimac.com-AMC-<?php echo date('d-m-Y H:i:s').'/'.$row_fetch['CUSTOMER_CODE'];?>%2F&choe=UTF-8" title="refimac.com" height="120" align="right" style="padding-right:30px"/></p>
<p>NAME : <?php echo $row_fetch['CUSTOMER_NAME']; ?> </p>
<p> <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_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>
<p>Email ID.: </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="90" height="37" align="center" bgcolor="#E8E8E8" class="style1"><strong>MAKE</strong></td>
<td width="180" align="center" bgcolor="#E8E8E8" class="style1"><strong>MODEL</strong></td>
<td width="470" align="center" bgcolor="#E8E8E8" class="style1">Unit Serial No.</td>
<td width="167" align="center" bgcolor="#E8E8E8" class="style1"><strong>RATE PER UNIT</strong></td>
<td width="100" 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 *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID");
//$sql_check=mysql_query("SeLECT *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval,(select wlamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT,(select SERIALNO from service where SALES_ID=sales.SALES_ID AND COMPLETED='Y' LIMIT 0,1) AS SERIALNOVAL FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
$sql_check=mysql_query("SELECT * , make.MAKE_NAME AS MAKE_NAME, model.MODEL_NAME AS MODEL_NAME, service_mode.SERVICE_MODE_NAME AS modeval, amc_model_list.wlamount AS LAMOUNT, purchase.PURCHASE_SERIALNUMBER AS SERIALNOVA,(select PURCHASE_SERIALNUMBER FROM purchase where purchase.PURCHASE_ID=sales.PURCHASE_ID order by sales.SALES_ID limit 0,1) as SRVSERIALNO FROM sales INNER JOIN service ON sales.SALES_ID = service.SALES_ID INNER JOIN make ON make.MAKE_ID = sales.MAKE_ID INNER JOIN model ON model.MODEL_ID = sales.MODEL_ID INNER JOIN service_mode ON service_mode.SERVICE_MODE_ID = sales.SERVICEMODE_ID INNER JOIN amc_model_list ON amc_model_list.model_list_id = sales.Model_id INNER JOIN purchase ON purchase.PURCHASE_ID = sales.PURCHASE_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
// echo "SeLECT *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID";
//echo "SeLECT *,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID"; die;
$i=1;
$lamount=0;
while($row_fetch=mysql_fetch_array($sql_check))
{
$sqlprice="SELECT * FROM amc_model_list WHERE model_no='".$row_fetch['MODEL_NAME']."' and status='Y'";
//echo $sqlprice;
$quprice=mysql_query($sqlprice);
$row_price=mysql_fetch_array($quprice);
$servicecount=$row_fetch['NO_OF_SERVICES'];?>
<tr>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MAKE_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MODEL_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['SRVSERIALNO']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;">Rs.<?php echo $row_price['lamount']; ?></td>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +1 day'))." to ".$start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +365 day')) ?></td>
</tr>
<?php $i++; $lamount=$lamount+$row_price['lamount'];}?>
<?php for($i=$i;$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 } ?>
<?php if($lamount==0 || $lamount=="") $lamount=0;?>
<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"><div align="left">Rs.<?php if($lamount!=0 ) echo $lamount;?></div></td>
<td rowspan="4" align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">As per GST service tax is charged at the rate of 18%.</br>(this is inclusive of CGST & SGST)</p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"><div align="left">Rs.<?php if($lamount!=0) echo (($lamount) * (0.18)); ?></div></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"><div align="left">Rs.<?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?></div></td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class=""><div align="left">Payment Terms 100% Advance Cheque in favour of<strong> Refimac</strong> 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. <?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?><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>
<tr>
<td align="center" style="
color: darkblue;
font-size: 16px;
">
<strong>AUTHORIZED AIRCONDITIONER DISTRIBUTOR</strong>
</td>
</tr>
<tr>
<td >
</br>
<img src="img/lg.png" width="100" height="75" />
<img src="img/general.png" width="100" height="75" />
<img src="img/dikin.png" width="100" height="75" />
<img src="img/vestar.png" width="100" height="75" />
<img src="img/sam.png" width="150" height="75" />
</td>
</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>
<p>
<p class="classpoints"> 1. Periodical Service <u> <?php echo "4"; ?> </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></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. During this contract if the Air Conditioner required major over hauling it has to be taken to the service station for repair. The transportation it to be borne by client. <br/>
v. Repair replacement of parts like compressor, Electrical Compondents, Thermostart, Gas charging, Selector Switch Filter, Fan/Blower Motor, Sheet Metal Works. <br />
vi. 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></p>
<p class="classpoints"> 1. The annual contract fee is Rs. <?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?> 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 />
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.During the periodical servicing, if the premises is found locked, postponement of date of service should be give by the customer.<br />
10. 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 /> </td>
<tr>
</table>
<footer></footer>
<?php /*?><?php
}
}
?><?php */?>
</div>
</body>
</html>
<?php }
else if($row_fetch['SERVICEMODE_ID']=="3")
{
?>
<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" style="
font-size: 26px;
"><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><strong style="
font-size: 24px !important;
">EXCEPT COMPRESSOR </strong> </p>
<p style="
font-size: 24px !important;
"><strong>Refimac</strong></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 <img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http%3A%2F%2Fwww.refimac.com-AMC-<?php echo date('d-m-Y H:i:s').'/'.$row_fetch['CUSTOMER_CODE'];?>%2F&choe=UTF-8" title="refimac.com" height="120" align="right" style="padding-right:30px"/></p>
<p>NAME : <?php echo $row_fetch['CUSTOMER_NAME']; ?> </p>
<p> <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_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>
<p>Email ID.: </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="90" height="37" align="center" bgcolor="#E8E8E8" class="style1"><strong>MAKE</strong></td>
<td width="180" align="center" bgcolor="#E8E8E8" class="style1"><strong>MODEL</strong></td>
<td width="470" align="center" bgcolor="#E8E8E8" class="style1">Unit Serial No.</td>
<td width="167" align="center" bgcolor="#E8E8E8" class="style1"><strong>RATE PER UNIT</strong></td>
<td width="150" 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 *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID");
//$sql_check=mysql_query("SeLECT *,(select MAKE_NAME from make where MAKE_ID=sales.MAKE_ID) as MAKE_NAME,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval,(select wlamount from amc_model_list where model_list_id=sales.Model_id) as LAMOUNT,(select PURCHASE_SERIALNUMBER from purchase where PURCHASE_ID=sales.PURCHASE_ID) AS SERIALNOVAL FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
$sql_check=mysql_query("SELECT * , make.MAKE_NAME AS MAKE_NAME, model.MODEL_NAME AS MODEL_NAME, service_mode.SERVICE_MODE_NAME AS modeval, amc_model_list.wlamount AS LAMOUNT, purchase.PURCHASE_SERIALNUMBER AS SERIALNOVA,(select PURCHASE_SERIALNUMBER FROM purchase where purchase.PURCHASE_ID=sales.PURCHASE_ID order by sales.SALES_ID limit 0,1) as SRVSERIALNO FROM sales INNER JOIN service ON sales.SALES_ID = service.SALES_ID INNER JOIN make ON make.MAKE_ID = sales.MAKE_ID INNER JOIN model ON model.MODEL_ID = sales.MODEL_ID INNER JOIN service_mode ON service_mode.SERVICE_MODE_ID = sales.SERVICEMODE_ID INNER JOIN amc_model_list ON amc_model_list.model_list_id = sales.Model_id INNER JOIN purchase ON purchase.PURCHASE_ID = sales.PURCHASE_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID order by service.SALES_ID asc");
//echo "SeLECT *,(select MODEL_NAME from model where MODEL_ID=sales.MODEL_ID) as MODEL_NAME,(select SERVICE_MODE_NAME from service_mode where SERVICE_MODE_ID=sales.SERVICEMODE_ID) as modeval FROM sales inner join service on sales.SALES_ID=service.SALES_ID where sales.SALES_ID in ('".$numberval."') GROUP by service.SALES_ID"; die;
$i=1;
$lamount=0;
while($row_fetch=mysql_fetch_array($sql_check))
{
$sqlprice="SELECT * FROM amc_model_list WHERE model_no='".$row_fetch['MODEL_NAME']."' and status='Y'";
$quprice=mysql_query($sqlprice);
$row_price=mysql_fetch_array($quprice);
$servicecount=$row_fetch['NO_OF_SERVICES'];?>
<tr>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MAKE_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['MODEL_NAME']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;"><?php echo $row_fetch['SRVSERIALNO']; ?></td>
<td valign="center" nowrap="nowrap" style="font-size: 17px !important;padding: 10px;">Rs.<?php echo $row_price['excomp']; ?></td>
<td nowrap="nowrap" valign="center" style="font-size: 17px !important;padding: 10px;"><?php echo $start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +1 day'))." to ".$start_date = date('d-m-y', strtotime($row_fetch['MATURITY_DATE'] . ' +365 day')) ?></td>
</tr>
<?php $i++; $lamount=$lamount+$row_price['excomp'];}?>
<?php for($i=$i;$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"><div align="left">Rs.<?php if($lamount!=0 && $lamount!="") echo $lamount; ?></div></td>
<td rowspan="4" align="center" bgcolor="#FFFFFF" class="style1"> </td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><p align="right">As per GST service tax is charged at the rate of 18%.</br>(this is inclusive of CGST & SGST)</p></td>
<td align="center" bgcolor="#FFFFFF" class="style1"><div align="left">Rs.<?php if($lamount!=0) echo (($lamount) * (0.18)); ?></div></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"><div align="left">Rs.<?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?></div></td>
</tr>
<tr>
<td height="37" colspan="5" align="center" bgcolor="#FFFFFF" class=""><div align="left">Payment Terms 100% Advance Cheque in favour of <strong>Refimac</strong> 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. <?php if($lamount!=0) echo round($lamount + (($lamount) * (0.18)) ,0); ?> <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>
<tr>
<td align="center" style="
color: darkblue;
font-size: 16px;
">
<strong>AUTHORIZED AIRCONDITIONER DISTRIBUTOR</strong>
</td>
</tr>
<tr>
<td >
</br>
<img src="img/lg.png" width="100" height="75" />
<img src="img/general.png" width="100" height="75" />
<img src="img/dikin.png" width="100" height="75" />
<img src="img/vestar.png" width="100" height="75" />
<img src="img/sam.png" width="150" height="75" />
</td>
</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> 4 </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.</p>
<p class="classpoints"> <br />
<p class="classpoints"> <strong>4.</strong><strong style="
font-size: 21px;
"> <u>PARTS WOULD BE REPLACED FREE OF COST DURING THIS CONTRACT</u></strong> <br />
<p class="classpoints">
Indoor blower wheel/Motor,Outdoor fan blade/Motor,Capacitor service value and in case of refrigent leak welding of condenser and cooling coil if possible then pressure testing, vacummising,reprocessing and transportation. </p>
<p class="classpoints"><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. Attendance to Voltage Stabilizer </br>
v. Replacement of condenser cooling coil which are beyond repairable condition, Compressor, oscilating,swing,step motor,remote,PCB,Indoor/Outdoor thermister's all plastic Parts except fan blade and Blower wheel will be charged. </p>
<p class="points"> <strong>C</strong><br /> </p>
<p class="classpoints">
1. The annual contract fee is Rs.<u> </u> 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. </p>
<p class="classpoints">9.During the periodical servicing, if the premises is found locked, postponement of date of service should be give by the customer.<br />
10
. 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 />
<br />
</p></td>
<tr>
</table>
<footer></footer>
<?php
}
} }}?>