File: /home/cafsindia/refimac_cafsjobs_com/print_call_installation.php
<?php
include('dbconnect.php');
//session_start();
$complaint_no=$_REQUEST['number'];
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
if($user=="")
header("Location:index.php?get1=4");
if($complaint_no!="")
{
$sql_check=mysql_query("select *,(select EMP_NAME from employee where EMP_ID=serviceapp_callreg.tech_name) as tech_name_full from serviceapp_callreg where complaint_no='".$complaint_no."'");
$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>Installation Report</title>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 22px;
font-weight: bold;
}
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style3 {font-size: 12px; font-family: Arial, Helvetica, sans-serif;}
.style6 {font-size: 14px; font-family: Arial, Helvetica, sans-serif; }
p {
font-size: 20px;
-webkit-margin-before: 0.3em;
-webkit-margin-after: 0.3em;
}
td {
font-size: 22px;
}
-->
</style>
</head>
<body style="margin-top:-10">
<div align="center">
<?php /*?><?php
$id=$_REQUEST['id'];
if($id!="")
{
$sql11="select * from etaapp_callreg where reg_id=".$id." and tech_allocate!=''";
//echo $sql11;
$qu11=mysql_query($sql11);
$n11=mysql_num_rows($qu11);
if($n11==1)
{
$sqln="update etaapp_callreg set print_st='Y' where reg_id=".$id."";
$qun=mysql_query($sqln);
}
$sql="select * from etaapp_callreg where reg_id=".$id."";
$qu=mysql_query($sql);
while($r=mysql_fetch_array($qu))
{
?><?php */?>
<table width="1000" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td colspan="2">
<img src="img/refimac.png" style="width: 400px;"/>
<img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http%3A%2F%2Fwww.refimac.com-installation-<?php echo date('d-m-Y H:i:s').'/'.$row_fetch['complaint_no'];?>%2F&choe=UTF-8" title="refimac.com" height="120" align="right" style="padding-right:30px"/>
<!--<img src="img/barcode.png" height="120" align="right" style="padding-right:30px" /> --> </td>
</tr>
<tr>
<td width="69%" height="110"><p>Address: No.309, Nehru Nagar 1st Cross St,
Kottivakkam (OMR), </p>
<p>Chennai – 600096
Phone: 044 24542626, 24542040, 24540071</p></td>
<td width="31%">
<p>Ref No: <?php echo $row_fetch['complaint_no'];?> </p>
<p>Date: <?php echo $row_fetch['complaint_date'];?> </p>
<p>Time: <?php echo $row_fetch['complaint_time'];?></p></td>
</tr>
<tr>
<td height="42" colspan="2" align="center" style="
color: darkblue;
font-size: 24px;
"><strong>AIRCONDITIONER INSTALLATION REPORT</strong></td>
</tr>
<tr>
<td height="143" colspan="2">
<table cellspacing="2" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr> <td height="37" colspan="3"> Customer Name: <?php echo $row_fetch['CUSTOMER_NAME']; ?></td>
</tr>
<tr> <td height="57" colspan="3">Address: <?php echo $row_fetch['CUSTOMER_ADDRESS'].','.$row_fetch['CUSTOMER_AREA'].','.$row_fetch['CUSTOMER_SURROUND_AREA'].','.$row_fetch['CUSTOMER_CITY'].'-'.$row_fetch['CUSTOMER_PINCODE']; ?> </td>
</tr>
<tr>
<td height="37">Cont Person: <?php echo $row_fetch['CUSTOMER_CONTACT_PERSON'];?></td>
<td>Mobile No: <?php echo $row_fetch['CUSTOMER_MOBILE'];?></td>
<td>Service Requested Date: <?php echo $row_fetch['service_req_datetime'];?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<tr>
<td>
<table cellspacing="2" cellpadding="1" border="1px" class="machineta" width="1000" style="border-collapse: collapse;">
<tr>
<td height="37" bgcolor="#E8E8E8" class="style1" align="center">S.No</td>
<td bgcolor="#E8E8E8" class="style1" align="center">Cap/Mode</td>
<td bgcolor="#E8E8E8" class="style1" align="center">Serial No</td>
<td bgcolor="#E8E8E8" class="style1" align="center"> Model No.</td>
<td bgcolor="#E8E8E8" class="style1" align="center">Location of A/C</td>
</tr>
<tr>
<td width="48" nowrap="nowrap" rowspan="2">1</td>
<td width="80" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
<td width="192" height="40" valign="bottom" nowrap="nowrap">O/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
<td width="150" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
</tr>
<tr>
<td width="192" height="42" valign="bottom" nowrap="nowrap">I/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
</tr>
<tr>
<td width="48" nowrap="nowrap" rowspan="2">2</td>
<td width="80" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
<td width="192" height="43" valign="bottom" nowrap="nowrap">O/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
<td width="150" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
</tr>
<tr>
<td width="192" height="41" valign="bottom" nowrap="nowrap">I/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
</tr>
<tr>
<td width="48" nowrap="nowrap" rowspan="2">3</td>
<td width="80" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
<td width="192" height="43" valign="bottom" nowrap="nowrap">O/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
<td width="150" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
</tr>
<tr>
<td width="192" height="40" valign="bottom" nowrap="nowrap">I/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
</tr>
<tr>
<td width="48" nowrap="nowrap" rowspan="2">4</td>
<td width="80" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
<td width="192" height="43" valign="bottom" nowrap="nowrap">O/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </td>
<td width="150" nowrap="nowrap" rowspan="2" valign="bottom"> </td>
</tr>
<tr>
<td width="192" height="41" valign="bottom" nowrap="nowrap">I/D</td>
<td width="167" nowrap="nowrap" valign="bottom"> </strong></p></td>
</tr>
<tr>
<td width="48" nowrap="nowrap" rowspan="2">5</strong></p></td>
<td width="80" nowrap="nowrap" rowspan="2" valign="bottom"> </p></td>
<td width="192" height="43" valign="bottom" nowrap="nowrap">O/D</strong></p></td>
<td width="167" nowrap="nowrap" valign="bottom"> </strong></p></td>
<td width="150" nowrap="nowrap" rowspan="2" valign="bottom"> </p></td>
</tr>
<tr>
<td width="192" height="42" valign="bottom" nowrap="nowrap">I/D</strong></p></td>
<td width="167" nowrap="nowrap" valign="bottom"> </strong></p></td>
</tr>
</table> </td>
</tr>
</br>
<tr>
<td>
<table cellspacing="1" cellpadding="1" border="1" class="machineta" width="1000" style="border-collapse: collapse;">
<tr> <td height="86" colspan="3">Technician Report: </td>
</tr>
<tr> <td height="47" colspan="3">Install the above --------------------- A/C Tested and found in Good working condition. </td>
<tr> <td height="47" >Angle Install Yes/No </td>
<td height="47" >Copper Pipe Extra ------------- Mtr </td>
<td height="47" >Site Installation report photo uploaded Yes/No</td>
</tr>
<tr> <td height="41">Time In: </td>
<td>Time Out: </td><td>Technician Name: <?php echo $row_fetch['tech_name_full']; ?></td></tr>
</table>
</td>
</tr>
<tr>
<td height="74">
<p>Customer Remarks: </p>
</td>
</tr>
<tr>
<!--<tr>
<td height="34">
<p>Customer Ratings :- <input name="star1" type="checkbox" value="" /> <input name="star2" type="checkbox" value="" /><input name="star3" type="checkbox" value="" /><input name="star4" type="checkbox" value="" /> <input name="star5" type="checkbox" value="" /></p>
</td>
</tr>-->
<tr>
<td height="53" align="right" style="padding-right:50px">
<p>Customer Signature: </p>
</td>
</tr>
<tr>
<td align="center" style="
color: darkblue;
font-size: 22px;
">
<strong>AUTHORIZED AIRCONDITIONER DISTRIBUTOR</strong>
</td>
</tr>
<tr>
<td >
</br>
<img src="img/lg.png" width="175" height="75" />
<img src="img/general.png" width="175" height="75" />
<img src="img/dikin.png" width="175" height="75" />
<img src="img/vestar.png" width="175" height="75" />
</td>
</tr>
</tr>
</table>
</td>
</tr>
</table>
<?php /*?><?php
}
}
?><?php */?>
</div>
</body>
</html>
<?php } ?>