File: //home/cafsindia/refimac_cafsjobs_com/print_all_single.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 = $_REQUEST['salesids'];
//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>D A SERVICES</strong></p>
<p>Address: NO: 2/164, KALAIMAGAL NAGAR
1ST STREET, OMR,
</p>
<p> KARAPAKKAM,
CHENNAI - 600097., </p>
<p>9841033113,9841063194,9841006692</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.D A SERVICES.com-AMC-<?php echo date('d-m-Y H:i:s') . '/' . $row_fetch['CUSTOMER_CODE']; ?>%2F&choe=UTF-8" title="D A SERVICES.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");
$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,(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 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'];
$newamount = 0;
$newamount = $row_fetch['AMOUNT'];
if ($newamount === "0") {
$newamount = $row_price['lamount'];
}
?>
<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 $newamount; ?></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 + $newamount;
} ?>
<?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>D A
SERVICES</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>D A SERVICES</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/sam.png" width="110" height="60" />
<img src="img/general.png" width="110" height="60" />
<img src="img/dikin.png" width="110" height="60" />
<img src="img/vestar.png" width="110" height="60" />
<img src="img/pana.png" width="110" height="60" />
<img src="img/vidiem.png" width="110" height="60" />
</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>D A SERVICES</strong></p>
<p>Address: NO: 2/164, KALAIMAGAL NAGAR
1ST STREET, OMR,
</p>
<p> KARAPAKKAM,
CHENNAI - 600097., </p>
<p>9841033113,9841063194,9841006692</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.D A SERVICES.com-AMC-<?php echo date('d-m-Y H:i:s') . '/' . $row_fetch['CUSTOMER_CODE']; ?>%2F&choe=UTF-8" title="D A SERVICES.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'";
$quprice = mysql_query($sqlprice);
$row_price = mysql_fetch_array($quprice);
$servicecount = $row_fetch['NO_OF_SERVICES'];
$newamount = 0;
$newamount = $row_fetch['AMOUNT'];
if ($newamount === "0" || $newamount === "") {
$newamount = $row_price['excomp'];
}
?>
<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 $newamount; ?></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 + $newamount;
} ?>
<?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> D A
SERVICES</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>D A SERVICES</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/sam.png" width="110" height="60" />
<img src="img/general.png" width="110" height="60" />
<img src="img/dikin.png" width="110" height="60" />
<img src="img/vestar.png" width="110" height="60" />
<img src="img/pana.png" width="110" height="60" />
<img src="img/vidiem.png" width="110" height="60" />
</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>D A SERVICES</strong></p>
<p>Address: NO: 2/164, KALAIMAGAL NAGAR
1ST STREET, OMR,
</p>
<p> KARAPAKKAM,
CHENNAI - 600097., </p>
<p>9841033113,9841063194,9841006692</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.D A SERVICES.com-AMC-<?php echo date('d-m-Y H:i:s') . '/' . $row_fetch['CUSTOMER_CODE']; ?>%2F&choe=UTF-8" title="D A SERVICES.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, 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 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 * , 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 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";
// GS:: 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";
// 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'];
$newamount = 0;
$newamount = $row_fetch['AMOUNT'];
if ($newamount === 0) {
$newamount = $row_price['lamount'];
}
?>
<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 $newamount; ?></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 + $newamount;
} ?>
<?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> D A
SERVICES</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>D A SERVICES</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/sam.png" width="110" height="60" />
<img src="img/general.png" width="110" height="60" />
<img src="img/dikin.png" width="110" height="60" />
<img src="img/vestar.png" width="110" height="60" />
<img src="img/pana.png" width="110" height="60" />
<img src="img/vidiem.png" width="110" height="60" />
</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>D A SERVICES</strong></p>
<p>Address: NO: 2/164, KALAIMAGAL NAGAR
1ST STREET, OMR,
</p>
<p> KARAPAKKAM,
CHENNAI - 600097., </p>
<p>9841033113,9841063194,9841006692</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.D A SERVICES.com-AMC-<?php echo date('d-m-Y H:i:s') . '/' . $row_fetch['CUSTOMER_CODE']; ?>%2F&choe=UTF-8" title="D A SERVICES.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, 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 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'];
$newamount = 0;
$newamount = $row_fetch['AMOUNT'];
if ($newamount === 0) {
$newamount = $row_price['excomp'];
}
?>
<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 $newamount; ?></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 + $newamount;
} ?>
<?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>D A SERVICES</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>D A SERVICES</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/sam.png" width="110" height="60" />
<img src="img/general.png" width="110" height="60" />
<img src="img/dikin.png" width="110" height="60" />
<img src="img/vestar.png" width="110" height="60" />
<img src="img/pana.png" width="110" height="60" />
<img src="img/vidiem.png" width="110" height="60" />
</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
}
}
}
} ?>