File: /home/pricecom/public_html/plcapp/jobsprint.php
<?php
ob_start();
session_start();
if($_SESSION['user_id']=="") {
header("location: index.php");
}
/* $userName="root";
$password="";
$server="localhost";
$databaseName="plcapp";*/
$userName="pricecom_plcapp";
$password="Pakistan@12345";
$server="localhost";
$databaseName="pricecom_plcapp";
$db=mysql_connect($server,$userName,$password) or die ("I can't Connect the databse because ").mysql_errno();
mysql_select_db($databaseName);
if(isset($_GET['job'])) {
$jid=(int) $_GET['job'];
$qry="Select * from jobs where jid=$jid";
$result=mysql_query($qry);
$records=mysql_fetch_array($result);
$qryTerms="Select * from terms where cid=1";
$resultTerms=mysql_query($qryTerms);
$recordsTerms=mysql_fetch_array($resultTerms);
if($records['productType']==0)
$pType="Desktop";
else if($records['productType']==1)
$pType="Laptop";
else if($records['productType']==2)
$pType="Mobile";
else if($records['productType']==3)
$pType="Tablet";
if($records['wCharger']==0)
$wCharger="No";
else if($records['wCharger']==1)
$wCharger="Yes";
if($records['boughtFrom']==0)
$bFrom="No";
else if($records['boughtFrom']==1)
$bFrom="Yes";
if($records['unerWar']==0)
$uWarr="No";
else if($records['unerWar']==1)
$uWarr="Yes";
if($records['backupRequired']==0)
$backupRe="No";
else if($records['backupRequired']==1)
$backupRe="Yes";
if($records['issueType']==0)
$issueType="Hardware";
else if($records['issueType']==1)
$issueType="Software";
}
?>
<!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=utf-8" />
<title>Priceless Computer Customer Job Application</title>
<style type="text/css" media="print">
body {
font-family:Arial, Helvetica, sans-serif;
font-size: 1em;
color: #333333;
margin-top: 2cm;
margin-right: 2cm;
margin-bottom: 1.5cm;
margin-left: 2cm
}
</style>
</head>
<body>
<table cellpadding="0" cellspacing="0" border="0" width="930px" height="1300px" style="border:4px #333 solid" align="center">
<tr>
<td align="center" valign="top" height="30" colspan="5"><h3>Computer Case Details Sheet</h3></td>
</tr>
<tr>
<td width="20px"></td>
<td colspan="5" valign="top" height="600">
<table cellpadding="5" cellspacing="0" border="0" width="100%" height="600px" style="border:4px #333 solid" align="center" >
<tr>
<Td height="5"></Td>
</tr>
<tr>
<td valign="top" height="50"><img src="images/logo.png" /></td>
<Td align="right" valign="top">
<table cellpadding="0" cellspacing="0" border="0" style="font-size:14px; font-family:Arial, Helvetica, sans-serif; line-height:22px; font-weight:600">
<tr>
<Td valign="top">
<strong>Priceless Computer</strong><br />
6913-B Rosemead Blvd.<Br />
San Gabriel,<Br />
CA 91775</Td>
<td width="20"></td>
<td valign="top">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>Tel:</td>
<td>1 626 237 2020</td>
</tr>
</table>
</td>
<td width="10"></td>
</tr>
</table>
</Td>
</tr>
<tr>
<Td height="40"></Td>
</tr>
<tr>
<td colspan="10" valign="top">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="25"></td>
<Td valign="top">
<table cellpadding="5" cellspacing="0" border="0" width="400" style="font-size:14px; font-family:Arial, Helvetica, sans-serif; line-height:25px;">
<tr>
<Td width="160"><strong>Case Number:</strong></Td>
<Td><?php echo $records['caseno']; ?></Td>
</tr>
<tr>
<Td><strong>Date Opened:</strong></Td>
<Td><?php echo $records['dateOpened']; ?></Td>
</tr>
<tr>
<Td><strong>Customer Name:</strong></Td>
<Td><?php echo $records['customName']; ?></Td>
</tr>
<tr>
<Td><strong>Phone Number:</strong></Td>
<Td><?php echo $records['phoneNo']; ?></Td>
</tr>
<tr>
<Td><strong>At. Phone Number:</strong></Td>
<Td><?php echo $records['altPhoneNo']; ?></Td>
</tr>
<tr>
<Td><strong>Email:</strong></Td>
<Td><?php echo $records['email']; ?></Td>
</tr>
<tr>
<Td><strong>Case Closed:</strong></Td>
<Td><?php echo $records['caseClosed']; ?></Td>
</tr>
<tr>
<Td><strong>Technician Name:</strong></Td>
<Td><?php echo $records['TechName']; ?></Td>
</tr>
<tr>
<Td><strong>Data Backup Required:</strong></Td>
<Td><?php echo $backupRe; ?></Td>
</tr>
</table>
</Td>
<td width="35"></td>
<Td valign="top">
<table cellpadding="5" cellspacing="0" border="0" width="400" style="font-size:14px; font-family:Arial, Helvetica, sans-serif; line-height:25px;">
<tr>
<Td width="150"><strong>System Type:</strong></Td>
<Td><?php echo $pType; ?></Td>
</tr>
<tr>
<Td><strong>Brand:</strong></Td>
<Td><?php echo $records['brand']; ?></Td>
</tr>
<tr>
<Td><strong>Model Number:</strong></Td>
<Td><?php echo $records['modelNumber']; ?></Td>
</tr>
<tr>
<Td><strong>Comes With Charger:</strong></Td>
<Td><?php echo $wCharger; ?></Td>
</tr>
<tr>
<Td><strong>OS:</strong></Td>
<Td><?php echo $records['os']; ?></Td>
</tr>
<tr>
<Td><strong>Bought From Us:</strong></Td>
<Td><?php echo $bFrom; ?></Td>
</tr>
<tr>
<Td ><strong>Under Warranty:</strong></Td>
<Td><?php echo $uWarr; ?></Td>
</tr>
<tr>
<Td><strong>Issue Type:</strong></Td>
<Td><?php echo $issueType; ?></Td>
</tr>
<tr>
<Td><strong>Category:</strong></Td>
<Td><?php echo $records['category']; ?></Td>
</tr>
</table>
</Td>
</tr>
<tr><Td height="20"></Td></tr>
<tr>
<Td></Td>
<Td colspan="10" style="font-size:14px; font-family:Arial, Helvetica, sans-serif"><strong>Description:</strong> <?php echo $records['description']; ?></Td>
<Td></Td>
</tr>
<tr><Td height="20"></Td></tr>
</table>
</td>
</tr>
</table>
</td>
<td width="20px"></td>
</tr>
<tr><Td height="30"></Td></tr>
<tr>
<td width="20px" height="350px"></td>
<td colspan="5" valign="top">
<table cellpadding="5" cellspacing="0" border="0" width="100%" height="350px" style="border:4px #333 solid; font-size:14px; font-family:Arial, Helvetica, sans-serif" align="center" >
<tr>
<Td height="10"></Td>
</tr>
<tr>
<td width="20"></td>
<Td valign="top" height="20"><strong style="font-size:16px">Terms & Conditions</strong></Td>
<td width="20"></td>
</tr>
<tr>
<td></td>
<Td valign="top"><?php echo stripslashes($recordsTerms['termscond']); ?></Td>
<td></td>
</tr>
</table>
</td>
</tr>
<tr>
<Td height="30"></Td>
</tr>
<tr>
<Td></Td>
<Td colspan="5" valign="top">
<table cellpadding="0" cellspacing="0" border="0" style="font-size:16px; font-family:Arial, Helvetica, sans-serif" width="100%">
<tr>
<Td valign="top"><strong>Done</strong></Td>
<Td align="right">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<Td><strong>Dated:</strong></Td>
<td width="100"></td>
</tr>
<tr><Td height="20"></Td></tr>
<tr>
<Td><strong>Customer Signature:</strong></Td>
<td width=""></td>
</tr>
<tr><Td height="75"></Td></tr>
<tr>
<Td><strong>Tested & Pickup:</strong></Td>
<td width=""></td>
</tr>
</table>
</Td>
</tr>
</table>
</Td>
<Td></Td>
</tr>
</table>
</body>
</html>