EVOLUTION-NINJA

Edit File: view_civil_work_order.php

<?php foreach($details as $result){ ?> <?php }?>
		<div class="print" id="print_report" style="padding:10px;">
		
			<table style="width:900px;border-spacing:0;">
					<tr>
					<td colspan="10"></td>
					<td colspan="2"  style="text-align:right;">E-mail: <?php if(!empty($result['email'])) { echo $result['email']; }?></td>					
				</tr>
				<tr>
					<td colspan="10"></td>
					<td colspan="2"  style="text-align:right;">Contact Person: <?php echo $result['contact_person'];?></td>
				</tr>
				<tr>
					<td colspan="10"></td>
					<td colspan="2"  style="text-align:right;">Contact No.: <?php echo $result['contact_number']; ?></td>
				</tr>
				<tr>
					<td colspan="12" style="text-align:center;font-weight:900;font-size:20px;font-style:Akashi;">GSS PROJECT CONSULTANTS PRIVATE LIMITED</td>
				</tr>
				<tr>
					<td colspan="12" style="text-align:center;">Regd.Off:407.8th B MAIN,JAYANAGAR 4th BLOCK,BANGLORE-560011.INDIA</td>
				</tr>
				
				<tr>
					<td colspan="12" style="text-align:center;font-weight:600;text-decoration: underline;">CIVIL WORK ORDER</td>
				</tr>
				<tr>
					<td colspan="12" style="text-align:center;font-weight:600;text-decoration: underline;">GST NO. : 29AAACG3912GIZT</td>
				</tr>
							<tr>
                                        <td colspan="10"></td>
                                        <td colspan="2"  style="text-align:right;"> </td>
                                </tr>
								<tr>
                                        <td colspan="10"></td>
                                        <td colspan="2"  style="text-align:right;"> </td>
                                </tr>
                               <tr>
										
										<td colspan="2"><input type="text" value=" <?php echo $result['vendor']; ?>" style="width: 50 %; border: transparent;" readonly></td>
								</tr>
								<tr>
										
										<td colspan="2" ><textarea rows="3" style="border: transparent;" readonly> <?php echo $result['vendor_address']; ?></textarea></td>
                                </tr>
                                <tr>
                                        <td colspan="10"></td>
                                        <td colspan="2"  style="text-align:right;">WO# : GSS\CIVIL\<?php echo $result['project_name']; ?>\<?php echo '0000';echo $result['po_no']; ?></td>
                                </tr>
                                <tr>        
                                        <td colspan="10"></td>
                                        <td colspan="2"  style="text-align:right;">Date :  <?php echo date("d-m-Y"); ?></td>
                                        
                                </tr>
                                <tr>
                                        <td colspan="10"></td>
                                        <td colspan="2"  style="text-align:right;">Currency :  <?php echo $result['currency']; ?></td>
                                        
                                </tr>

<tr>
					<td colspan="2" style="padding-top: 1%;">Sir / Madam,</td>
					
					<td colspan="8"></td>
				</tr>
				<tr>
					<td colspan="12">
						<p style="padding-left:5%;padding-top: 1%;">We request you to supply the following materials as per the terms mentioned here below. kindly mention our WO No in your invoice.</p>
					</td>
				</tr>
			</table>
		<table border="1" style="width:900px;border-spacing:0;margin-top: 1%;" cellpadding="4px">
				<thead>
								<tr>
						<th>SL No.</th>
						<th>PARTICULARS</th>
						<th>INDENTS</th>
						<th>PROJECT</th>
						
						<?php if($result['currency'] == 'INR')
						{  ?>
						<th>RATE IN INR</th>
						
					<?php } else if($result['currency'] == 'CHF') { ?>
							
						<th>RATE IN CHF</th>
						
						
						<?php } else if($result['currency'] == 'EUR') { ?>

<th>RATE IN GBP</th>
						
						<?php } else if($result['currency'] == 'USD') { ?>
						<th>RATE IN USD</th>
						
						
						<?php } ?>
					
						<th>CGST</th>
						<th>CGST Value </th>
						<th>SGST</th>
						<th>SGST Value </th>
						<th>IGST</th>
						<th>IGST Value </th>
						<th>Total Value</th>
						
						
					</tr>
				</thead>
				<tbody>
				<?php $a=0;$b=0;$c=1; foreach($fetch_details as $fetch_add){?>
					<tr >
						<td><?php echo $c; ?></td>
						<td style="text-transform: uppercase !important;"><?php echo $fetch_add->product_name; ?></td>
						<td style="text-transform: uppercase !important;"><?php echo $fetch_add->indent; ?></td>
						<td style="text-transform: uppercase !important;"><?php echo $fetch_add->project_name; ?></td>
						<td><?php echo round($fetch_add->inr_value); ?></td>
						
						<td><?php echo $fetch_add->cgst; ?></td>
						<td><?php echo round($fetch_add->cgst*$fetch_add->inr_value)/100; ?></td>
						<td><?php echo $fetch_add->sgst; ?></td>
						<td><?php echo round($fetch_add->sgst*$fetch_add->inr_value)/100; ?></td>
						<td><?php echo $fetch_add->igst; ?></td>
						<td><?php echo round($fetch_add->igst*$fetch_add->inr_value)/100; ?></td>
						<td><?php  echo round($fetch_add->total_value); ?></td>
						
			
			
					</tr>
				<?php $a=$a+$fetch_add->inr_value;  $c++; }
				if($fetch_add->ot_total_value != ""){?>
				
					<tr>
						<td></td>
						<td><?php echo $fetch_add->ot_charges; ?></td>
						<td></td>
						<td></td>

<td><?php echo round($fetch_add->ot_inr_value); ?></td>
						<td><?php echo $fetch_add->ot_cgst; ?></td>
                       <td><?php echo round((float)$fetch_add->ot_cgst * (float)$fetch_add->inr_value / 100, 2); ?></td>

<td><?php echo $fetch_add->ot_sgst; ?></td>
				<td><?php echo round((float)$fetch_add->ot_sgst * (float)$fetch_add->inr_value / 100, 2); ?></td>

<td><?php echo $fetch_add->ot_igst; ?></td>
					<td><?php echo round((float)$fetch_add->ot_igst * (float)$fetch_add->inr_value / 100, 2); ?></td>

<td><?php echo round($fetch_add->ot_total_value); ?></td>
						
					</tr>
					<?php $b=$fetch_add->ot_inr_value;}?>
					
					<tr>
					
						<td colspan="8" style="border-bottom:1px solid transparent !important;"> 	<textarea rows="1" id="note" name="note"  style="width: 100%; border: transparent; " placeholder="NOTE : " readonly><?php echo $fetch_add->note; ?></textarea>
						</td>
						
						
							
						<td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">Total in Rs</td>
					 	
							
							<td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo $fetch_add->total_amt; ?></td>
					
					</tr>
					<tr>
					
						<td colspan="8" style="border-bottom:1px solid transparent !important;">
						</td>
						
						
							
						<td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">Discount@<?php if(!empty($fetch_add)){echo $fetch_add->discount; }?>%</td>
					 	
							
							<td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo ((($a+$b) * $fetch_add->discount)/100);?></td>
					
					</tr>
					<tr>
					
						<td colspan="8" style="border-bottom:1px solid transparent !important;">
						</td>
						
						
							
						<td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">TDS@<?php if(!empty($fetch_add)){echo $fetch_add->tds; }?>%</td>
					 	
							
							<td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo ((($a+$b) * $fetch_add->tds)/100);?></td>
					
					</tr>
					
				
					<tr>
					
						<td colspan="8" style="border-bottom:1px solid transparent !important;">
						</td>
						
						
							
						<td colspan="3" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in Rs</td>
					 	
							<td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php $gd_tot=($fetch_add->total_amt - ((($a+$b) * $fetch_add->discount)/100) - ((($a+$b) * $fetch_add->tds)/100)) ; echo round($gd_tot);?></td>
							
					</tr>
				
					
				
				</tbody>
			</table>
			<table style="width:900px;margin-top:10px;">
				<tr>
					<td>Material Delivery :<span style="text-transform: uppercase !important;"> <?php echo $fetch_add->material_delivery;  ?></span></td>			
				</tr>
				<tr>
					<td>GST No. :<span style="text-transform: uppercase !important;"><?php echo $fetch_add->gst_no;  ?></span> </td>			
				</tr>
				<tr>
					<td>Terms of payment :<span style="text-transform: uppercase !important;"> <?php echo $fetch_add->terms_of_payment;  ?></span></td>			
				</tr>
				<tr>
					<td>TDS @ :<?php echo $fetch_add->tds; ?> % On Total Value.<br/>

</tr>
				<tr>				
					<td>Bank Details :<span style="text-transform: uppercase !important;"> <?php echo $fetch_add->bank_details; ?></span></td>					
				</tr>
							
			</table>
			
		</div>

</div> 
</div>
<script>

$(document).ready(function(){
	$("#booking_print").click(function(){
		 var divToPrint=document.getElementById("print_report");
				newWin= window.open("");
				newWin.document.write(divToPrint.outerHTML);
				newWin.print();
				newWin.close();	
				});

});

</script>