Scribd
Upload
2 views21 pages

Batch Value Data Processing Script

The document outlines a PHP script for calculating and managing batch burden distribution data, including querying various batch values and inserting results into a database. It also includes a section for displaying a report with filters for date ranges and a table layout for presenting batch details. The script handles memory limits and execution time settings to accommodate potentially large data operations.

Uploaded by

satyendrasudershan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views21 pages

Batch Value Data Processing Script

The document outlines a PHP script for calculating and managing batch burden distribution data, including querying various batch values and inserting results into a database. It also includes a section for displaying a report with filters for date ranges and a table layout for presenting batch details. The script handles memory limits and execution time settings to accommodate potentially large data operations.

Uploaded by

satyendrasudershan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Source Code Burden Distribution Model

Data Storage Calculation Backend :-

First 10 Pages: -

<?php

include 'BurdDist_calc.php';

include '[Link]';

set_time_limit(0);

ini_set('memory_limit', '1280000M');

$sql = "SELECT * FROM dbo.BATCH_VALUE ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1
ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BATCH_NO= $row['BATCHNO'];

/* Level-1 Charge No */

$CH_NO=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='1003' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){
$CH_NO= round($row['VAL'],0);

/* Level-1 Charge TIme */

$BH_TIME=0;

$sql = "SELECT * FROM dbo.BATCH_INDEX where BATCHNO ='$BATCH_NO' ORDER BY BATCHNO


desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_TIME=date("d-m-Y H:i:s", strtotime($row['CHARGETIME']));

/* Batch Material */

$BH_MT=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='1' and BATCHNO ='$BATCH_NO' ORDER
BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_MT= round($row['VAL'],0);

}
/* Batch Weight */

$BH_WT=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='13' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_WT= round($row['VAL']/1000,2);

/* Hopper */

$BH_HP=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='32' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_HP= round($row['VAL'],0);

/* Stock_ACT */

$BH_SRA=0;
$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='41' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_SRA= round($row['VAL'],3);

/* Stock_SP */

$BH_SRP=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='42' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_SRP= round($row['VAL'],3);

/* DIST_DIRE */

$BH_DIST=0;

$sql = "SELECT * FROM dbo.BATCH_VALUE where VALUEID ='50' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();
$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_DIST= $row['VAL'];

/* AIM Rotation */

$BH_ROT1=0;

$BH_ROT2=0;

$BH_ROT3=0;

$BH_ROT4=0;

$BH_ROT5=0;

$BH_ROT6=0;

$BH_ROT7=0;

$BH_ROT8=0;

$BH_ROT9=0;

$BH_ROT10=0;

$BH_ROT11=0;

$sql = "SELECT * FROM dbo.BATCH_POSITION where VALUEID ='71' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BH_ROT1=round($row['V01'],0);

$BH_ROT2=round($row['V02'],0);
$BH_ROT3=round($row['V03'],0);

$BH_ROT4=round($row['V04'],0);

$BH_ROT5=round($row['V05'],0);

$BH_ROT6=round($row['V06'],0);

$BH_ROT7=round($row['V07'],0);

$BH_ROT8=round($row['V08'],0);

$BH_ROT9=round($row['V09'],0);

$BH_ROT10=round($row['V10'],0);

$BH_ROT11=round($row['V11'],0);

/* Actual Weight */

$BH_RWT1=0;

$BH_RWT2=0;

$BH_RWT3=0;

$BH_RWT4=0;

$BH_RWT5=0;

$BH_RWT6=0;

$BH_RWT7=0;

$BH_RWT8=0;

$BH_RWT9=0;

$BH_RWT10=0;

$BH_RWT11=0;

$sql = "SELECT * FROM dbo.BATCH_POSITION where VALUEID ='74' and BATCHNO ='$BATCH_NO'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();

$members = $query->fetchAll(PDO::FETCH_ASSOC);
if(!empty($members)){

foreach($members as $row){

$BH_RWT1=round($row['V01'] / 1000,2);

$BH_RWT2=round($row['V02'] / 1000,2);

$BH_RWT3=round($row['V03'] / 1000,2);

$BH_RWT4=round($row['V04'] / 1000,2);

$BH_RWT5=round($row['V05'] / 1000,2);

$BH_RWT6=round($row['V06'] / 1000,2);

$BH_RWT7=round($row['V07'] / 1000,2);

$BH_RWT8=round($row['V08'] / 1000,2);

$BH_RWT9=round($row['V09'] / 1000,2);

$BH_RWT10=round($row['V10'] / 1000,2);

$BH_RWT11=round($row['V11'] / 1000,2);

$MAT_TYPE=0;

if($BH_MT == 1)

$MAT_TYPE='C';

if($BH_MT == 2 && $BH_RWT1 == 0 )

$MAT_TYPE='FERROUS';

if($BH_MT == 2 && $BH_WT < 20 )

$MAT_TYPE='SS';
}

if($BH_MT == 2 && $BH_WT > 18 && $BH_RWT1 > 0 && $BH_RWT3 > 0 )

$MAT_TYPE='C';

if($BH_MT == 4)

$MAT_TYPE='C3';

$DIST_DIR=0;

if($BH_DIST == 0)

$DIST_DIR='WTC';

if($BH_DIST == 1)

$DIST_DIR='CTW';

$query = "insert into batch_track (BATCH_NO, Charge_No, Charge_Time, BH_TYPE, HP_NO,


TOTAL_WT, STOCK_SET, STOCK_ACT, DIST_DIR,

ROT1, ROT2, ROT3, ROT4, ROT5, ROT6, ROT7, ROT8, ROT9, ROT10, ROT11,

RWT1, RWT2, RWT3, RWT4, RWT5, RWT6, RWT7, RWT8, RWT9, RWT10, RWT11)

values('$BATCH_NO','$CH_NO','$BH_TIME','$MAT_TYPE','$BH_HP','$BH_WT','$BH_SRP','$BH_SRA','
$DIST_DIR',
'$BH_ROT1','$BH_ROT2','$BH_ROT3','$BH_ROT4','$BH_ROT5','$BH_ROT6','$BH_ROT7','$BH_ROT8','
$BH_ROT9','$BH_ROT10','$BH_ROT11',

'$BH_RWT1','$BH_RWT2','$BH_RWT3','$BH_RWT4','$BH_RWT5','$BH_RWT6','$BH_RWT7','$BH_RW
T8','$BH_RWT9','$BH_RWT10','$BH_RWT11')";

$result=mysqli_query($connl2,$query);

echo memory_get_usage();

/* Batch Update Query */

$batch_update=0;

$sql="Select * from batch_track Where Charge_Time ='01-01-1970 01:00:00' order by id desc Limit
1";

$res_data = mysqli_query($connl2,$sql);

while ($row = mysqli_fetch_array($res_data))

$batch_update=$row['BATCH_NO'];

/* AIM Rotation */

$BHU_ROT1=0;

$BHU_ROT2=0;

$BHU_ROT3=0;

$BHU_ROT4=0;

$BHU_ROT5=0;

$BHU_ROT6=0;

$BHU_ROT7=0;

$BHU_ROT8=0;

$BHU_ROT9=0;

$BHU_ROT10=0;

$BHU_ROT11=0;

$sql = "SELECT * FROM dbo.BATCH_POSITION where VALUEID ='71' and BATCHNO ='$batch_update'
ORDER BY BATCHNO desc OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY;";

$query = $connBFL2->prepare($sql);

$query->execute();
$members = $query->fetchAll(PDO::FETCH_ASSOC);

if(!empty($members)){

foreach($members as $row){

$BHU_ROT1=round($row['V01'],0);

$BHU_ROT2=round($row['V02'],0);

$BHU_ROT3=round($row['V03'],0);

$BHU_ROT4=round($row['V04'],0);

$BHU_ROT5=round($row['V05'],0);

$BHU_ROT6=round($row['V06'],0);

$BHU_ROT7=round($row['V07'],0);

$BHU_ROT8=round($row['V08'],0);

$BHU_ROT9=round($row['V09'],0);

$BHU_ROT10=round($row['V10'],0);

$BHU_ROT11=round($row['V11'],0);

/* Actual Weight */

$BHU_RWT1=0;

$BHU_RWT2=0;

$BHU_RWT3=0;

$BHU_RWT4=0;

$BHU_RWT5=0;

$BHU_RWT6=0;

$BHU_RWT7=0;

$BHU_RWT8=0;

$BHU_RWT9=0;

$BHU_RWT10=0;

$BHU_RWT11=0;
Last 10 Pages :-
<?php

include '[Link]';

include '[Link]';

include '[Link]';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

$date= $_POST['date'];

$date1=$_POST['date1'];

$sql= "SELECT * FROM batch_track WHERE STR_TO_DATE(LEFT(Charge_Time,LOCATE('


',Charge_Time)),'%d-%m-%Y') between '$date' AND '$date1' order by id desc";

$res_data = mysqli_query($connl2,$sql);

else

$sql= "SELECT * FROM batch_track order by id desc Limit 120 ";

$res_data = mysqli_query($connl2,$sql);

$ring_wt='Weight';

$ring_rt='Rotation';

?>

<style>

tr {

font-size: 10px;

th {

font-size: 14px !important;

td {
font-size: 14px !important;

</style>

<meta http-equiv="refresh" content="45">

<div class=main>

<div class="container-fluid">

<div class="row-fluid">

<div class="col-lg-12 col-md-12" style=" margin: 0; padding: 0;border: 0;">

<button class="btns">FURNACE TOP BURDEN DISTRIBUTION REPORT</button>

<div class="table-responsive">

<table id="example" class="table table-striped table-bordered table-sm">

<tr>

<form name="f1" action="" method="post">

<tr>

<td colspan="8"></td>

<td><button class="btns1">From :</button>

<td colspan="2"><input type="date" name="date" id="date" ></td>

<td><button class="btns1">To :</button></td>

<td colspan="2"><input type="date" name="date1" id="date1">

</td>

<td colspan="3"><input type="submit" name="submit" value="Submit"></td>

<td colspan="8"></td>

</tr>

</form>

</tr>

<tr>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center; vertical-align:


middle;"><center>Charge No</center></th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center; vertical-align:


middle;">Dump Time</th>
<th bgcolor="#0D315A" rowspan="2" style="text-align: center;
vertical-align: middle;">Mat Type</th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center;


vertical-align: middle;">Hopper No</th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center;


vertical-align: middle;">Total Weight</th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center;


vertical-align: middle;">Stockline_SV</th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center;


vertical-align: middle;">Stockline_PV</th>

<th bgcolor="#0D315A" rowspan="2" style="text-align: center;


vertical-align: middle;">Dist._Dir.</th>

<th bgcolor="#0D315A" colspan="12" style="text-align: center;


vertical-align: middle;">Ring Distribution</th>

</tr>

<tr>

<th bgcolor="#0D315A" style="text-align: center; vertical-align:


middle;">Event</th>

<th bgcolor="#0D315A">1</th>

<th bgcolor="#0D315A">2</th>

<th bgcolor="#0D315A">3</th>

<th bgcolor="#0D315A">4</th>

<th bgcolor="#0D315A">5</th>

<th bgcolor="#0D315A">6</th>

<th bgcolor="#0D315A">7</th>

<th bgcolor="#0D315A">8</th>

<th bgcolor="#0D315A">9</th>

<th bgcolor="#0D315A">10</th>

<th bgcolor="#0D315A">11</th>

</tr>

<?php

$no = 1;

$total = 0;
while ($row = mysqli_fetch_array($res_data))

echo '<tr>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['Charge_No'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['Charge_Time'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['BH_TYPE'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['HP_NO'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['TOTAL_WT'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.$row['STOCK_SET'].'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align:


center; vertical-align: middle;">'.round($row['STOCK_ACT'],2).'</td>

<td bgcolor="#C5F8FB" rowspan="2" style="text-align: center;


vertical-align: middle;">'.$row['DIST_DIR'].'</td>

<td bgcolor="#F2D7D5" style="text-align: center; vertical-


align: middle;">'.$ring_wt.'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT1'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT2'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT3'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT4'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT5'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT6'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT7'].'</td>
<td bgcolor="#F5EEF8" style="text-align: center; vertical-
align: middle;">'.$row['RWT8'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT9'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT10'].'</td>

<td bgcolor="#F5EEF8" style="text-align: center; vertical-


align: middle;">'.$row['RWT11'].'</td>

</tr>';

echo '<tr>

<td bgcolor="#D1F2EB" style="text-align: center; vertical-


align: middle;">'.$ring_rt.'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT1'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT2'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT3'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT4'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT5'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT6'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT7'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT8'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT9'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT10'].'</td>

<td bgcolor="#EBF5FB" style="text-align: center; vertical-


align: middle;">'.$row['ROT11'].'</td>

</tr>';
$no++;

}?>

</table>

</div>

</div>

</div>

</div>

</div>

</body>

<div class="footer">

<p class="copyright">

<p> All rights reserved | Design & Developed by Computer & Automation Department, SAIL-ISP
Burnpur</a></p>

</p>

</div>

</html>

<?php

include '[Link]';

include '[Link]';

error_reporting(E_ERROR | E_PARSE);

$i=0;

$sql1 = "SELECT * FROM batch_track WHERE BH_TYPE like 'C' order by id desc Limit 30";

$res_data1 = mysqli_query($connl2,$sql1);

while ($row = mysqli_fetch_array($res_data1))

$bdck_chno=$row['Charge_No'];
$ntch1= round($row['RWT1'],2);

$ntch2= round($row['RWT2'],2);

$ntch3= round($row['RWT3'],2);

$ntch4= round($row['RWT4'],2);

$ntch5= round($row['RWT5'],2);

$ntch6= round($row['RWT6'],2);

$ntch7= round($row['RWT7'],2);

$ntch8= round($row['RWT8'],2);

$ntch9= round($row['RWT9'],2);

$ntch10= round($row['RWT10'],2);

$ntch11= round($row['RWT11'],2);

$a1[$i]="[$ntch1]";

$a2[$i]="[$ntch2]";

$a3[$i]="[$ntch3]";

$a4[$i]="[$ntch4]";

$a5[$i]="[$ntch5]";

$a6[$i]="[$ntch6]";

$a7[$i]="[$ntch7]";

$a8[$i]="[$ntch8]";

$a9[$i]="[$ntch9]";

$a10[$i]="[$ntch10]";

$a11[$i]="[$ntch11]";

$ckn[$i]="[$bdck_chno]";

$ra1[$i]="$ntch1";

$ra2[$i]="$ntch2";

$ra3[$i]="$ntch3";

$ra4[$i]="$ntch4";

$ra5[$i]="$ntch5";

$ra6[$i]="$ntch6";

$ra7[$i]="$ntch7";

$ra8[$i]="$ntch8";
$ra9[$i]="$ntch9";

$ra10[$i]="$ntch10";

$ra11[$i]="$ntch11";

$rckn[$i]="$bdck_chno";

$i= ($i+1);

$j=0;

$sql2 = "SELECT * FROM batch_track WHERE BH_TYPE like 'FERROUS' order by id desc Limit 30";

$res_data2 = mysqli_query($connl2,$sql2);

while ($row = mysqli_fetch_array($res_data2))

$bdfs_chno=$row['Charge_No'];

$fntch1= round($row['RWT1'],2);

$fntch2= round($row['RWT2'],2);

$fntch3= round($row['RWT3'],2);

$fntch4= round($row['RWT4'],2);

$fntch5= round($row['RWT5'],2);

$fntch6= round($row['RWT6'],2);

$fntch7= round($row['RWT7'],2);

$fntch8= round($row['RWT8'],2);

$fntch9= round($row['RWT9'],2);

$fntch10= round($row['RWT10'],2);

$fntch11= round($row['RWT11'],2);

$fa1[$j]="[$fntch1]";

$fa2[$j]="[$fntch2]";

$fa3[$j]="[$fntch3]";

$fa4[$j]="[$fntch4]";

$fa5[$j]="[$fntch5]";

$fa6[$j]="[$fntch6]";

$fa7[$j]="[$fntch7]";
$fa8[$j]="[$fntch8]";

$fa9[$j]="[$fntch9]";

$fa10[$j]="[$fntch10]";

$fa11[$j]="[$fntch11]";

$rfa1[$j]="$fntch1";

$rfa2[$j]="$fntch2";

$rfa3[$j]="$fntch3";

$rfa4[$j]="$fntch4";

$rfa5[$j]="$fntch5";

$rfa6[$j]="$fntch6";

$rfa7[$j]="$fntch7";

$rfa8[$j]="$fntch8";

$rfa9[$j]="$fntch9";

$rfa10[$j]="$fntch10";

$rfa11[$j]="$fntch11";

$ckn1[$j]="[$bdfs_chno]";

$j= ($j+1);

$m=0;

$sql3 = "SELECT * FROM batch_track WHERE BH_TYPE like 'SS' order by id desc Limit 30";

$res_data3 = mysqli_query($connl2,$sql3);

while ($row = mysqli_fetch_array($res_data3))

$bdfss_chno=$row['Charge_No'];

$fsntch1= round($row['RWT1'],2);

$fsntch2= round($row['RWT2'],2);
$fsntch3= round($row['RWT3'],2);

$fsntch4= round($row['RWT4'],2);

$fsntch5= round($row['RWT5'],2);

$fsntch6= round($row['RWT6'],2);

$fsntch7= round($row['RWT7'],2);

$fsntch8= round($row['RWT8'],2);

$fsntch9= round($row['RWT9'],2);

$fsntch10= round($row['RWT10'],2);

$fsntch11= round($row['RWT11'],2);

$fsa1[$m]="[$fsntch1]";

$fsa2[$m]="[$fsntch2]";

$fsa3[$m]="[$fsntch3]";

$fsa4[$m]="[$fsntch4]";

$fsa5[$m]="[$fsntch5]";

$fsa6[$m]="[$fsntch6]";

$fsa7[$m]="[$fsntch7]";

$fsa8[$m]="[$fsntch8]";

$fsa9[$m]="[$fsntch9]";

$fsa10[$m]="[$fsntch10]";

$fsa11[$m]="[$fsntch11]";

$ckns1[$m]="[$bdfss_chno]";

$rfsa1[$m]="$fsntch1";

$rfsa2[$m]="$fsntch2";

$rfsa3[$m]="$fsntch3";

$rfsa4[$m]="$fsntch4";

$rfsa5[$m]="$fsntch5";

$rfsa6[$m]="$fsntch6";

$rfsa7[$m]="$fsntch7";

$rfsa8[$m]="$fsntch8";

$rfsa9[$m]="$fsntch9";
$rfsa10[$m]="$fsntch10";

$rfsa11[$m]="$fsntch11";

$m= ($m+1);

$n=0;

$sql3 = "SELECT * FROM batch_track WHERE BH_TYPE like 'C3' order by id desc Limit 30";

$res_data3 = mysqli_query($connl2,$sql3);

while ($row = mysqli_fetch_array($res_data3))

$bdfsc_chno=$row['Charge_No'];

$cokecent= round($row['RWT11'],2);

$bdcokecent[$n]="[$cokecent]";

$rbdcokecent[$n]="$cokecent";

$ckn1c3[$n]="[$bdfsc_chno]";

$n= ($n+1);

?>

You might also like