EVOLUTION-NINJA
Edit File: article_master_data1.php
<style> .highcharts-container { display:none !important; } </style> <?php $db_conn = mysqli_connect("localhost", "injayblues_injayblues", "x+r3.6apBW+Y", "injayblues_decotextil_new"); $cWarp=count($getwarp); $cWeft=count($getweft); $r="SELECT * FROM warping_wearing"; $getwarpingwearing=mysqli_query($db_conn,$r); $wwresult=mysqli_fetch_array($getwarpingwearing); $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.": ".$total ."<br>"; echo "<h2><b>It is 100% ".$yarn->yarnQuality.".</b></h2>"; break; //} //break; //} } else { echo "<h3><b>".$warpcompo->Warp_Quality.": ".$warpcompo->compo."</b></h3><br>"; echo "<h3><b>".$weftcompo->Weft_Quality.": ".$weftcompo->compo."</b></h3><br>"; } } } }*/ ?>