<?php 
	session_start();
	
	include('../config/db_connect.php');
	$query  = " call  usp_select_business($_SESSION[b_id])";
 	$result = $mysql->query($query);
 	$business_row = mysqli_fetch_array($result); 
 

//	include('../config/db_connect.php');
//	$query  = " call  usp_select_sales_offer($_REQUEST[element_id], $_SESSION[b_id], 0, 1)";
// 	$result = $mysql->query($query);
//  = mysqli_fetch_array($result); 
 
	$display = "";
	
 	$display .= "<div style='height:20px'></div>";
	$display .= "<div class='show' id='page0' align='left'> ";
	$display .= " <table style='width: 100%;font-family: Verdana' >
        <tr>
            <td style='width: 1in; height: 1in'>
                &nbsp;
            </td>
            <td>
                &nbsp;
            </td>
            <td style='width: 1in; height: 1in'>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;
            </td>
            <td style='font-size: 22px;'>
                 $business_row[business_name]
            </td>
            <td>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td align='right' style='border-bottom:1px solid #000;height:70px; width=5px;' >
				 <table  cellpadding='0' cellspacing='0' border='0' >
						<tr style='font-weight:bold; font-size:18px;' >
							<td align='right'>
								Ensuring power &nbsp;&nbsp;</br> since 1982 &nbsp;&nbsp;
							</td>
							<td style='border-left:2px solid #000;height:70px; width=5px;'>
							&nbsp;&nbsp;
						</td>
							<td>
								  <img  src='../upload_image/business_logo.jpg' width='180px' height='53px' /></td>
						</tr>
					</table>
	 
				  </td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                </td>
            <td style='font-size:18px;'>
			SALES OFFER
			  <hr />
             </td>
            <td>
                &nbsp;</td>
        </tr>
		 <tr>
                     <td style='height:70px;'>
				&nbsp;
                </td>
            <td>
		 		&nbsp;
             </td>
            <td>
                &nbsp;
			</td>
        </tr>
		
		<tr>
            <td>
				&nbsp;
            </td>
            <td>
				 <table style='width:100%' cellpadding='0' cellspacing='0' border='0' >
						<tr>
							<td style='border-top:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							 CLIENT
							</td>
								<td style='border-top:1px solid #000;width:70%; hight:35px;  padding-left:5px; '> [customer]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000;  border-right:1px solid #000; width:30%; height:60px; '>
							 ADDRESS
							</td>
								<td style='border-top:1px solid #000;width:70%; height:60px;  padding-left:5px;'> [address]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							 OUR REFERANCE
							</td>
								<td style='border-top:1px solid #000;width:70%; hight:35px;  padding-left:5px;'> [offer_code]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							 DATE
							</td>
								<td style='border-top:1px solid #000;width:70%; hight:35px;  padding-left:5px; '> [offer_date]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000; border-bottom:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							PROJECT DETAIL
							</td>
						<td style='border-top:1px solid #000; border-bottom:1px solid #000; width:70%; hight:35px;  padding-left:5px;'>
							 SUPPLY OF [kva] KVA PRIME / [skva] STAND BY DIESEL GENERATING
SET

							</td>
							 
						</tr>
					</table>
			 
             </td>
            <td>
             &nbsp;
			</td>
        </tr>
		 <tr>
            <td style='height:150px;'>
				&nbsp;
                </td>
            <td>
		 		&nbsp;
             </td>
            <td>
                &nbsp;
			</td>
        </tr>
		
				<tr>
            <td>
				&nbsp;
            </td>
            <td align='right'>
				 <table style='width:70%' cellpadding='0' cellspacing='0' border='0' >
						<tr>
							<td style='border-top:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							 Submitted by
							</td>
								<td style='border-top:1px solid #000;width:70%; hight:35px;  padding-left:5px; '> [employee]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000;  border-right:1px solid #000; width:30%; height:35px; '>
							 Designation
							</td>
								<td style='border-top:1px solid #000;width:70%; height:35px;  padding-left:5px;'> [designation]
							</td>
							 
						</tr>
						<tr>
							<td style='border-top:1px solid #000; border-right:1px solid #000; width:30%; height:35px;'>
							 Mobile Number
							</td>
								<td style='border-top:1px solid #000;width:70%; hight:35px;  padding-left:5px;'> [cell]
							</td>
							 
						</tr>
						 
						<tr>
							<td  colspan='2' style='border-top:1px solid #000; border-bottom:1px solid #000; width:30%; height:35px;'>
						 
					 
				 
								 $business_row[address] 

							</td>
							 
						</tr>
					</table>
			 
             </td>
            <td>
             &nbsp;
			</td>
        </tr>
 
		<tr><td>&nbsp;</td><td></td><td>&nbsp;</td></tr>
		<tr><td>&nbsp;</td><td></td><td>&nbsp;</td></tr>
		
        <tr>
            <td style='width: 1in; height: 1in'>
                &nbsp;
            </td>
            <td>
                &nbsp;
            </td>
            <td style='height: 1in; width: 1in'>
                &nbsp;
            </td>
        </tr>
    </table>";
	
 
 
	$display .= "</div><input type='hidden' value='page0' id='current_page' />";
	$display .= "<input type='hidden' value='1' id='page_counter' />";
	
	
	echo $display;
?>

<div  style="padding-left:5px; font-size:10px; " ></div>



 
 
 

 