EVOLUTION-NINJA

Edit File: article_master_data1.php

$warpingfinal=$wwresult[1];
$wearingfinal=$wwresult[2];

foreach($getarticledata as $fresults)
{
$finalWarping=$fresults->warpTotalEnds*$warpingfinal;
$finalWearing= $fresults->weftPicks*$wearingfinal;
}
?>
<?php
$warprates=0;
foreach($getwarp as $warprate)
{
$query=mysqli_query($db_conn,"SELECT * FROM import_yarn where yarnName='".$warprate->Warp_Quality."' and yarnDenier='".$warprate->Warp_Denier."' and yarnSpecification='".$warprate->Warp_Specification."' and yarnType='Warp'");
//print_r($query);
 
 while($results=mysqli_fetch_array($query))
{
$warprates=$warprates+$results['rate']*$warprate->Kora_Wt;
}
}
//echo $warprates;

$weftrates=0;
foreach($getweft as $weftrate)
{
$query1=mysqli_query($db_conn,"SELECT * FROM import_yarn where yarnName='".$weftrate->Weft_Quality."' and yarnDenier='".$weftrate->Weft_Denier."' and yarnSpecification='".$weftrate->Weft_Specification."' and yarnType='Weft'");
//print_r($query1);
while($results1=mysqli_fetch_array($query1))
{
$weftrates=$weftrates+$results1['rate']*$weftrate->Kora_Wt;
}
}
//echo $weftrates;
$totalwarpweftrates=$warprates+$weftrates;?>
<div>
<?php if($d->designation == 'Super Admin') { ?> 
<div>
<span style="color:green;font-size:15px !important">Yarn : <?php echo round($totalwarpweftrates,2); ?>, Warping : <?php echo round($finalWarping,2); ?>, Weaving : <?php echo round($finalWearing,2); ?></span><br>
<span style="color:green;font-size:17px !important"><b>Total : <?php echo round($totalwarpweftrates+$finalWarping+$finalWearing,2); ?></b></span>

</div>
<?php } else { ?>

<?php } ?>

<h5><b>Warp Details</b></h5>

<table class="table table-bordered table-hover" id="sample_1">
							<thead>
							<tr>
							
								
								<th>
									Warp Yarn
								</th>
								<th>
									Warp Denier
								</th>
								<th>
									 Warp Specification
								</th>
								<th>
									Warp Final Denier
								</th>
								<th>
									No of Ends
								</th>
								<th>
									Kora Wt
								</th>
								
								<th>
									 Hanks
								</th>
								<th>
									 Dyed Wt
								</th>
								<th>
									 Percentage
								</th>
								<th>
									 Composition
								</th>
								
							<th>
									 Rate
								</th>
                                
								
							
                                
								
								
                            
							</tr>
							</thead>
							<tbody>
                                                        <?php 
                                                if($cWarp==0 && $cWeft==0)
												{
													echo '<tr>';
                                                    echo '<td colspan=4> NO DATA FOUND </td>';
													echo '</tr>';
												}
                                                else 
                                                {
                                                    
                                                    foreach($getwarp as $key=>$warp){
                                                        
                                                            if(empty($get_warp_rate[$key]))
														{
															 echo '<tr>';
                                                            echo '<td> ' . $warp->Warp_Quality . ' </td>
															<td> ' . $warp->Warp_Denier . ' </td>
															<td> ' . $warp->Warp_Specification . ' </td>
															<td> ' . $warp->Warp_Final_Denier . ' </td>
															<td> ' . $warp->No_of_Ends . ' </td>
															<td> ' . $warp->Kora_Wt . ' </td>
															<td> ' . $warp->Hanks . ' </td>
															<td> ' . $warp->Dyed_Wt . ' </td>
															<td> ' . $warp->percentage . ' </td>
															<td> ' . $warp->composition . ' </td>
															
															<td>  </td>';
															echo '</tr>';
														}
														else
														{
															 echo '<tr>';
                                                            echo '<td> ' . $warp->Warp_Quality . ' </td>
															<td> ' . $warp->Warp_Denier . ' </td>
															<td> ' . $warp->Warp_Specification . ' </td>
															<td> ' . $warp->Warp_Final_Denier . ' </td>
															<td> ' . $warp->No_of_Ends . ' </td>
															<td> ' . $warp->Kora_Wt . ' </td>
															<td> ' . $warp->Hanks . ' </td>
															<td> ' . $warp->Dyed_Wt . ' </td>
															<td> ' . $warp->percentage . ' </td>
															<td> ' . $warp->composition . ' </td>
															
															<td> ' . $get_warp_rate[$key]->rate . ' </td>';
															echo '</tr>';
														}
                                                    
                                                    }
                                                }
                                           
                                                 ?>
                                                            
                                                            
                                                            
                                                            
							
							</tbody>
		</table>
		
		
		
		</div>
		<br>	
		<h5><b>Weft Details</b></h5> 
		<table class="table table-bordered table-hover" id="sample_1">
							<thead>
							<tr>

<th>
									Weft Yarn
								</th>
								<th>
									Weft Denier
								</th>
								<th>
									 Weft Specification
								</th>
								<th>
									Weft Final Denier
								</th>
								<th>
									PPC
								</th>
								<th>
									Kora Wt
								</th>
								
								<th>
									 Hanks
								</th>
								<th>
									 Dyed Wt
								</th>
								<th>
									 Percentage
								</th>
								<th>
									 Composition
								</th>
								<th>
									 Rate
								</th>
							
                                
							
                                
								
								
                            
							</tr>
							</thead>
							<tbody>
                                                        <?php 
                                                //echo '<pre>';print_r($getsmwarp);exit;
												if($cWarp==0 && $cWeft==0)
												{
													echo '<tr>';
                                                    echo '<td colspan=4> NO DATA FOUND </td>';
													echo '</tr>';
												}
                                                else
                                                {
                                                	//print_r($getweft);
                                                    foreach($getweft as $key=>$weft){
                                                        
                                                        
                                                           if(empty($get_weft_rate[$key]))
														{
															echo '<tr>';
                                                            echo '<td> ' . $weft->Weft_Quality . ' </td>
															<td> ' . $weft->Weft_Denier . ' </td>
															<td> ' . $weft->Weft_Specification . ' </td>
															<td> ' . $weft->Weft_Final_Denier . ' </td>
															<td> ' . $weft->PPC . ' </td>
															<td> ' . $weft->Kora_Wt . ' </td>
															<td> ' . $weft->Hanks . ' </td>
															<td> ' . $weft->Dyed_Wt . ' </td>
															<td> ' . $weft->percentage . ' </td>
															<td> ' . $weft->composition . ' </td>
															<td> </td>';
															echo '</tr>';
														}
														else
														{
															echo '<tr>';
                                                            echo '<td> ' . $weft->Weft_Quality . ' </td>
															<td> ' . $weft->Weft_Denier . ' </td>
															<td> ' . $weft->Weft_Specification . ' </td>
															<td> ' . $weft->Weft_Final_Denier . ' </td>
															<td> ' . $weft->PPC . ' </td>
															<td> ' . $weft->Kora_Wt . ' </td>
															<td> ' . $weft->Hanks . ' </td>
															<td> ' . $weft->Dyed_Wt . ' </td>
															<td> ' . $weft->percentage . ' </td>
															<td> ' . $weft->composition . ' </td>
															<td> ' . $get_weft_rate[$key]->rate . ' </td>';
															echo '</tr>';
														}
                                                      
                                                    }
                                                }
                                           
                                                 ?>
                                                            
                                                            
                                                            
                                                            
							
							</tbody>
		</table>
		
		<?php 
		 
		/* foreach($warpcompo as $warpcompo){
			
		  foreach($weftcompo as $weftcompo){
		  	foreach($yarn as $yarn)
		  		{
		  			if($yarn->yarnName==$warpcompo->Warp_Quality || $yarn->yarnName==$weftcompo->Weft_Quality)
		  			{
		  		$total=$warpcompo->compo+ $weftcompo->compo;
		  		
		  		//echo $warpcompo->Warp_Quality.":&nbsp".$total ."<br>";
		  				echo "<h2><b>It is 100% ".$yarn->yarnQuality.".</b></h2>";
		  				break;
					//}
					//break;
				//}
		  	}
		  	else
		  	{

echo "<h3><b>".$warpcompo->Warp_Quality.":&nbsp".$warpcompo->compo."</b></h3><br>";
		  	
			echo "<h3><b>".$weftcompo->Weft_Quality.":&nbsp".$weftcompo->compo."</b></h3><br>";
		  	}
		} } }*/ ?>