Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Pessoal, boa tarde.
Preciso fazer uma contagem de registros, só que com filtros.
Queria saber como fazer sem fazer vários select.
Tipo preciso saber quantos registros tenho com IKS-0, quantos registros IKS-1, e assim vai até IKS-7.
Alguém pode me ajudar?
//**********************************************************************************************
$sql = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' ");
$r = mysql_query($sql);
$total = mysql_num_rows($r);
echo "Total IKS-0: ".$total;
echo "<br>";//**********************************************************************************************
$sql1 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r1 = mysql_query($sql1);
$total1 = mysql_num_rows($r1);
echo "Total IKS-1: ".$total1;
echo "<br>";//**********************************************************************************************
$sql2 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' ");
$r2 = mysql_query($sql2);
$total2 = mysql_num_rows($r2);
echo "Total IKS-2: ".$total2;
echo "<br>";//**********************************************************************************************
$sql3 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r3 = mysql_query($sql3);
$total3 = mysql_num_rows($r3);
echo "Total IKS-3: ".$total3;
echo "<br>";//**********************************************************************************************
$sql4 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' ");
$r4 = mysql_query($sql4);
$total4 = mysql_num_rows($r4);
echo "Total IKS-4: ".$total4;
echo "<br>";//**********************************************************************************************
$sql5 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' ");
$r5 = mysql_query($sql5);
$total5 = mysql_num_rows($r5);
echo "Total IKS-5: ".$total5;
echo "<br>";//**********************************************************************************************
$sql6 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' ");
$r6 = mysql_query($sql6);
$total6 = mysql_num_rows($r6);
echo "Total IKS-6: ".$total6;
echo "<br>";//**********************************************************************************************
$sql7 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' ");
$r7 = mysql_query($sql7);
$total7 = mysql_num_rows($r7);
echo "Total IKS-7: ".$total7;
echo "<br>";Bom dia.
Obrigado por responder.
Vou testar da forma que você passou e volto para responder como ficou.
Obrigado
Bom dia.
Não estou conseguindo usar mais de um select para obter a contagem de cada select independente.
Nunca usei vários selects assim independente. Com union funciona, porém ele une os resultados e os valores não batem.
Erro:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/producao/tabelas/tabdia/scripts/relatorio2.php on line 20
Notice: Undefined variable: iks0_so in /var/www/producao/tabelas/tabdia/scripts/relatorio2.php on line 28
Notice: Undefined variable: iks0_fc in /var/www/producao/tabelas/tabdia/scripts/relatorio2.php on line 29
Notice: Undefined variable: iks0_pr in /var/www/producao/tabelas/tabdia/scripts/relatorio2.php on line 30
Notice: Undefined variable: iks0_mt in /var/www/producao/tabelas/tabdia/scripts/relatorio2.php on line 31
$sql = mysql_query ("(SELECT op, COUNT(*) as t_planejador_so_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'SO'),
(SELECT op, COUNT(*) as t_planejador_fc_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'FC'),
(SELECT op, COUNT(*) as t_planejador_pr_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'PR'),
(SELECT op, COUNT(*) as t_planejador_mt_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'MT')
");while($row = mysql_fetch_array($sql)){
$iks0_so = $row["t_planejador_so_0"];
$iks0_fc = $row["t_planejador_fc_0"];
$iks0_pr = $row["t_planejador_pr_0"];
$iks0_mt = $row["t_planejador_mt_0"];
}
echo $iks0_so."<br>";
echo $iks0_fc."<br>";
echo $iks0_pr."<br>";
echo $iks0_mt."<br>";Tente
$sql = "SELECT op, COUNT(*) as t_planejador_so_0,
(SELECT op, COUNT(*) as t_planejador_fc_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'FC'),
(SELECT op, COUNT(*) as t_planejador_pr_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'PR'),
(SELECT op, COUNT(*) as t_planejador_mt_0 FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'MT')
FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'SO'";se entendi bem, 1 outra possibilidade:
SELECT planejador, count(*) total FROM dia WHERE status = 'A' group by planejador
Pessoal, eu consegui o relatório usando muitos selects.
Provavelmente deve existir uma maneira melhor de fazer isso, economizando centenas de linhas de códigos.
Abaixo segue o código que funciona, porém da maneira errada.
Se alguém souber uma maneira de eu obter esses dados, com menos código, agradeço.
//*** IKS-0 **********************************************************************************
$sql0 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' ");
$r0 = mysql_query($sql0);
$total0 = mysql_num_rows($r0);$sql0_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r0_A = mysql_query($sql0_A);
$total0_A = mysql_num_rows($r0_A);$sql0_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r0_B = mysql_query($sql0_B);
$total0_B = mysql_num_rows($r0_B);$sql0_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r0_C = mysql_query($sql0_C);
$total0_C = mysql_num_rows($r0_C);$sql0_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r0_D = mysql_query($sql0_D);
$total0_D = mysql_num_rows($r0_D);//---------------------------------
// CURVA E
$sql0_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r0_E = mysql_query($sql0_E);
$total0_E = mysql_num_rows($r0_E);//---------------------------------
// CURVA S
$sql0_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r0_S = mysql_query($sql0_S);
$total0_S = mysql_num_rows($r0_S);//**************************************************************************************************
//-------------------------
$sql0_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'SO' ");
$r0_so = mysql_query($sql0_so);
$total0_so = mysql_num_rows($r0_so);$sql0_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'FC' ");
$r0_fc = mysql_query($sql0_fc);
$total0_fc = mysql_num_rows($r0_fc);$sql0_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'PR' ");
$r0_pr = mysql_query($sql0_pr);
$total0_pr = mysql_num_rows($r0_pr);$sql0_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'MT' ");
$r0_mt = mysql_query($sql0_mt);
$total0_mt = mysql_num_rows($r0_mt);echo "IKS-0: ".$total0;
echo "<br>";
echo "CURVA A: ".$total0_A."<br>";
echo "CURVA B: ".$total0_B."<br>";
echo "CURVA C: ".$total0_C."<br>";
echo "CURVA D: ".$total0_D."<br>";
echo "CURVA E: ".$total0_E."<br>";
echo "CURVA S: ".$total0_S."<br>";
echo "Separando(SO): ".$total0_so."<br>";
echo "Separando(FC): ".$total0_fc."<br>";
echo "Separando(PR): ".$total0_pr."<br>";
echo "Separando(MT): ".$total0_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-1 **********************************************************************************
$sql1 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r1 = mysql_query($sql1);
$total1 = mysql_num_rows($r1);// CURVA A
$sql1_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r1_A = mysql_query($sql1_A);
$total1_A = mysql_num_rows($r1_A);$sql1_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r1_B = mysql_query($sql1_B);
$total1_B = mysql_num_rows($r1_B);$sql1_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r1_C = mysql_query($sql1_C);
$total1_C = mysql_num_rows($r1_C);$sql1_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r1_D = mysql_query($sql1_D);
$total1_D = mysql_num_rows($r1_D);//---------------------------------
// CURVA E
$sql1_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r1_E = mysql_query($sql1_E);
$total1_E = mysql_num_rows($r1_E);//---------------------------------
// CURVA S
$sql1_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r1_S = mysql_query($sql1_S);
$total1_S = mysql_num_rows($r1_S);$sql1_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'SO' ");
$r1_so = mysql_query($sql1_so);
$total1_so = mysql_num_rows($r1_so);$sql1_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'FC' ");
$r1_fc = mysql_query($sql1_fc);
$total1_fc = mysql_num_rows($r1_fc);$sql1_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'PR' ");
$r1_pr = mysql_query($sql1_pr);
$total1_pr = mysql_num_rows($r1_pr);$sql1_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'MT' ");
$r1_mt = mysql_query($sql1_mt);
$total1_mt = mysql_num_rows($r1_mt);echo "IKS-1: ".$total1;
echo "<br>";
echo "CURVA A: ".$total1_A."<br>";
echo "CURVA B: ".$total1_B."<br>";
echo "CURVA C: ".$total1_C."<br>";
echo "CURVA D: ".$total1_D."<br>";
echo "CURVA E: ".$total1_E."<br>";
echo "CURVA S: ".$total1_S."<br>";
echo "Separando(SO): ".$total1_so."<br>";
echo "Separando(FC): ".$total1_fc."<br>";
echo "Separando(PR): ".$total1_pr."<br>";
echo "Separando(MT): ".$total1_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-2 **********************************************************************************
$sql2 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' ");
$r2 = mysql_query($sql2);
$total2 = mysql_num_rows($r2);//-------------------------
// CURVA A
$sql2_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r2_A = mysql_query($sql2_A);
$total2_A = mysql_num_rows($r2_A);//-------------------------
// CURVA B
$sql2_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r2_B = mysql_query($sql2_B);
$total2_B = mysql_num_rows($r2_B);//-------------------------
// CURVA C
$sql2_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r2_C = mysql_query($sql2_C);
$total2_C = mysql_num_rows($r2_C);//-------------------------
// CURVA D
$sql2_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r2_D = mysql_query($sql2_D);
$total2_D = mysql_num_rows($r2_D);//-------------------------
// CURVA E
$sql2_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r2_E = mysql_query($sql2_E);
$total2_E = mysql_num_rows($r2_E);//-------------------------
// CURVA S
$sql2_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r2_S = mysql_query($sql2_S);
$total2_S = mysql_num_rows($r2_S);//-------------------------
$sql2_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'SO' ");
$r2_so = mysql_query($sql2_so);
$total2_so = mysql_num_rows($r2_so);$sql2_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'FC' ");
$r2_fc = mysql_query($sql2_fc);
$total2_fc = mysql_num_rows($r2_fc);$sql2_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'PR' ");
$r2_pr = mysql_query($sql2_pr);
$total2_pr = mysql_num_rows($r2_pr);$sql2_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'MT' ");
$r2_mt = mysql_query($sql2_mt);
$total2_mt = mysql_num_rows($r2_mt);echo "IKS-2: ".$total2;
echo "<br>";
echo "CURVA A: ".$total2_A."<br>";
echo "CURVA B: ".$total2_B."<br>";
echo "CURVA C: ".$total2_C."<br>";
echo "CURVA D: ".$total2_D."<br>";
echo "CURVA E: ".$total2_E."<br>";
echo "CURVA S: ".$total2_S."<br>";
echo "Separando(SO): ".$total2_so."<br>";
echo "Separando(FC): ".$total2_fc."<br>";
echo "Separando(PR): ".$total2_pr."<br>";
echo "Separando(MT): ".$total2_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-3 **********************************************************************************
$sql3 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' ");
$r3 = mysql_query($sql3);
$total3 = mysql_num_rows($r3);//-------------------------
// CURVA A
$sql3_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r3_A = mysql_query($sql3_A);
$total3_A = mysql_num_rows($r3_A);//-------------------------
// CURVA B
$sql3_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r3_B = mysql_query($sql3_B);
$total3_B = mysql_num_rows($r3_B);//-------------------------
// CURVA C
$sql3_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r3_C = mysql_query($sql3_A);
$total3_C = mysql_num_rows($r3_C);//-------------------------
// CURVA D
$sql3_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r3_D = mysql_query($sql3_D);
$total3_D = mysql_num_rows($r3_D);//-------------------------
// CURVA E
$sql3_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r3_E = mysql_query($sql3_E);
$total3_E = mysql_num_rows($r3_E);//-------------------------
// CURVA S
$sql3_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r3_S = mysql_query($sql3_S);
$total3_S = mysql_num_rows($r3_S);//--------------------------------------------------
$sql3_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'SO' ");
$r3_so = mysql_query($sql3_so);
$total3_so = mysql_num_rows($r3_so);$sql3_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'FC' ");
$r3_fc = mysql_query($sql3_fc);
$total3_fc = mysql_num_rows($r3_fc);$sql3_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'PR' ");
$r3_pr = mysql_query($sql3_pr);
$total3_pr = mysql_num_rows($r3_pr);$sql3_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'MT' ");
$r3_mt = mysql_query($sql3_mt);
$total3_mt = mysql_num_rows($r3_mt);echo "IKS-3: ".$total3;
echo "<br>";
echo "CURVA A: ".$total3_A."<br>";
echo "CURVA B: ".$total3_B."<br>";
echo "CURVA C: ".$total3_C."<br>";
echo "CURVA D: ".$total3_D."<br>";
echo "CURVA E: ".$total3_E."<br>";
echo "CURVA S: ".$total3_S."<br>";
echo "Separando(SO): ".$total3_so."<br>";
echo "Separando(FC): ".$total3_fc."<br>";
echo "Separando(PR): ".$total3_pr."<br>";
echo "Separando(MT): ".$total3_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-4 **********************************************************************************
$sql4 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' ");
$r4 = mysql_query($sql4);
$total4 = mysql_num_rows($r4);//-------------------------
// CURVA A
$sql4_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r4_A = mysql_query($sql4_A);
$total4_A = mysql_num_rows($r4_A);//-------------------------
// CURVA B
$sql4_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r4_B = mysql_query($sql4_B);
$total4_B = mysql_num_rows($r4_B);//-------------------------
// CURVA C
$sql4_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r4_C = mysql_query($sql4_C);
$total4_C = mysql_num_rows($r4_C);//-------------------------
// CURVA D
$sql4_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r4_D = mysql_query($sql4_D);
$total4_D = mysql_num_rows($r4_D);//-------------------------
// CURVA E
$sql4_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r4_E = mysql_query($sql4_E);
$total4_E = mysql_num_rows($r4_E);//-------------------------
// CURVA S
$sql4_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r4_S = mysql_query($sql4_S);
$total4_S = mysql_num_rows($r4_S);//------------------------------------------------
$sql4_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'SO' ");
$r4_so = mysql_query($sql4_so);
$total4_so = mysql_num_rows($r4_so);$sql4_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'FC' ");
$r4_fc = mysql_query($sql4_fc);
$total4_fc = mysql_num_rows($r4_fc);$sql4_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'PR' ");
$r4_pr = mysql_query($sql4_pr);
$total4_pr = mysql_num_rows($r4_pr);$sql4_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'MT' ");
$r4_mt = mysql_query($sql4_mt);
$total4_mt = mysql_num_rows($r4_mt);echo "IKS-4: ".$total4;
echo "<br>";
echo "CURVA A: ".$total4_A."<br>";
echo "CURVA B: ".$total4_B."<br>";
echo "CURVA C: ".$total4_C."<br>";
echo "CURVA D: ".$total4_D."<br>";
echo "CURVA E: ".$total4_E."<br>";
echo "CURVA S: ".$total4_S."<br>";
echo "Separando(SO): ".$total4_so."<br>";
echo "Separando(FC): ".$total4_fc."<br>";
echo "Separando(PR): ".$total4_pr."<br>";
echo "Separando(MT): ".$total4_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-5 **********************************************************************************
$sql5 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' ");
$r5 = mysql_query($sql5);
$total5 = mysql_num_rows($r5);//-------------------------
// CURVA A
$sql5_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r5_A = mysql_query($sql5_A);
$total5_A = mysql_num_rows($r5_A);//-------------------------
// CURVA B
$sql5_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r5_B = mysql_query($sql5_B);
$total5_B = mysql_num_rows($r5_B);//-------------------------
// CURVA C
$sql5_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r5_C = mysql_query($sql5_C);
$total5_C = mysql_num_rows($r5_C);//-------------------------
// CURVA D
$sql5_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r5_D = mysql_query($sql5_D);
$total5_D = mysql_num_rows($r5_D);//-------------------------
// CURVA E
$sql5_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r5_E = mysql_query($sql5_E);
$total5_E = mysql_num_rows($r5_E);//-------------------------
// CURVA S
$sql5_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r5_S = mysql_query($sql5_S);
$total5_S = mysql_num_rows($r5_S);//--------------------------------------------
$sql5_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'SO' ");
$r5_so = mysql_query($sql5_so);
$total5_so = mysql_num_rows($r5_so);$sql5_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'FC' ");
$r5_fc = mysql_query($sql5_fc);
$total5_fc = mysql_num_rows($r5_fc);$sql5_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'PR' ");
$r5_pr = mysql_query($sql5_pr);
$total5_pr = mysql_num_rows($r5_pr);$sql5_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'MT' ");
$r5_mt = mysql_query($sql5_mt);
$total5_mt = mysql_num_rows($r5_mt);echo "IKS-5: ".$total5;
echo "<br>";
echo "CURVA A: ".$total5_A."<br>";
echo "CURVA B: ".$total5_B."<br>";
echo "CURVA C: ".$total5_C."<br>";
echo "CURVA D: ".$total5_D."<br>";
echo "CURVA E: ".$total5_E."<br>";
echo "CURVA S: ".$total5_S."<br>";
echo "Separando(SO): ".$total5_so."<br>";
echo "Separando(FC): ".$total5_fc."<br>";
echo "Separando(PR): ".$total5_pr."<br>";
echo "Separando(MT): ".$total5_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-6 **********************************************************************************
$sql6 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' ");
$r6 = mysql_query($sql6);
$total6 = mysql_num_rows($r6);//-------------------------
// CURVA A
$sql6_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r6_A = mysql_query($sql6_A);
$total6_A = mysql_num_rows($r6_A);//-------------------------
// CURVA B
$sql6_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r6_B = mysql_query($sql6_B);
$total6_B = mysql_num_rows($r6_B);//-------------------------
// CURVA C
$sql6_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r6_C = mysql_query($sql6_C);
$total6_C = mysql_num_rows($r6_C);//-------------------------
// CURVA D
$sql6_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r6_D = mysql_query($sql6_D);
$total6_D = mysql_num_rows($r6_D);//-------------------------
// CURVA E
$sql6_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r6_E = mysql_query($sql6_E);
$total6_E = mysql_num_rows($r6_E);//-------------------------
// CURVA D
$sql6_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r6_D = mysql_query($sql6_D);
$total6_D = mysql_num_rows($r6_D);//-------------------------
// CURVA E
$sql6_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r6_E = mysql_query($sql6_E);
$total6_E = mysql_num_rows($r6_E);//-------------------------
// CURVA A
$sql6_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r6_S = mysql_query($sql6_S);
$total6_S = mysql_num_rows($r6_S);//-------------------------
$sql6_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'SO' ");
$r6_so = mysql_query($sql6_so);
$total6_so = mysql_num_rows($r6_so);$sql6_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'FC' ");
$r6_fc = mysql_query($sql6_fc);
$total6_fc = mysql_num_rows($r6_fc);$sql6_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'PR' ");
$r6_pr = mysql_query($sql6_pr);
$total6_pr = mysql_num_rows($r6_pr);$sql6_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'MT' ");
$r6_mt = mysql_query($sql6_mt);
$total6_mt = mysql_num_rows($r6_mt);echo "IKS-6: ".$total6;
echo "<br>";
echo "CURVA A: ".$total6_A."<br>";
echo "CURVA B: ".$total6_B."<br>";
echo "CURVA C: ".$total6_C."<br>";
echo "CURVA D: ".$total6_D."<br>";
echo "CURVA E: ".$total6_E."<br>";
echo "CURVA S: ".$total6_S."<br>";
echo "Separando(SO): ".$total6_so."<br>";
echo "Separando(FC): ".$total6_fc."<br>";
echo "Separando(PR): ".$total6_pr."<br>";
echo "Separando(MT): ".$total6_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-7 **********************************************************************************
$sql7 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' ");
$r7 = mysql_query($sql7);
$total7 = mysql_num_rows($r7);//-------------------------
// CURVA A
$sql7_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r7_A = mysql_query($sql7_A);
$total7_A = mysql_num_rows($r7_A);// CURVA B
$sql7_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r7_B = mysql_query($sql7_B);
$total7_B = mysql_num_rows($r7_B);// CURVA C
$sql7_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r7_C = mysql_query($sql7_C);
$total7_C = mysql_num_rows($r7_C);// CURVA D
$sql7_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r7_D = mysql_query($sql7_D);
$total7_D = mysql_num_rows($r7_D);// CURVA E
$sql7_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r7_E = mysql_query($sql7_E);
$total7_E = mysql_num_rows($r7_E);// CURVA S
$sql7_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r7_S = mysql_query($sql7_S);
$total7_S = mysql_num_rows($r7_S);//------------------------------------------
$sql7_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'SO' ");
$r7_so = mysql_query($sql7_so);
$total7_so = mysql_num_rows($r7_so);$sql7_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'FC' ");
$r7_fc = mysql_query($sql7_fc);
$total7_fc = mysql_num_rows($r7_fc);$sql7_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'PR' ");
$r7_pr = mysql_query($sql7_pr);
$total7_pr = mysql_num_rows($r7_pr);$sql7_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'MT' ");
$r7_mt = mysql_query($sql7_mt);
$total7_mt = mysql_num_rows($r7_mt);echo "IKS-7: ".$total7;
echo "<br>";
echo "CURVA A: ".$total7_A."<br>";
echo "CURVA B: ".$total7_B."<br>";
echo "CURVA C: ".$total7_C."<br>";
echo "CURVA D: ".$total7_D."<br>";
echo "CURVA E: ".$total7_E."<br>";
echo "CURVA S: ".$total7_S."<br>";
echo "Separando(SO): ".$total7_so."<br>";
echo "Separando(FC): ".$total7_fc."<br>";
echo "Separando(PR): ".$total7_pr."<br>";
echo "Separando(MT): ".$total7_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";Ainda acho que é possível da maneira que coloquei. Tentou implementar a sugestão do #5?
Boa tarde.
Sim tentei, más não deu certo.
Em quantas tabelas você vai buscar os dados? Tente detalhar um pouco o funcionamento do seu código. Vamos por partes, tentando fazer funcionar com poucos dados inicialmente para depois irmos implementando.
Bom dia.
Na verdade uso 3 tabelas.
Consegui fazer o que queria, porém utilizando vários Select.
Ficou rápido, e o objetivo foi atingido, porém para efeito de aprendizagem e redução do código, gostaria de aprender uma forma para reduzir o código.
Nesse caso, vejo que o fórum correto deveria ser o de SQL e não do PHP.
Abaixo, código completo.
<?php
include "mysql.php";
include "nav.php";
//$sql = mysql_query ("SELECT *, DATEDIFF(now(), data_abertura) AS date_difference FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` INNER JOIN `curva` `udc` ON `u`.`codiks` = `udc`.`curva_codiks` WHERE `u`.`status` = 'A' GROUP BY `u`.`op` ");//*** IKS-0 **********************************************************************************
$sql0 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' ");
$r0 = mysql_query($sql0);
$total0 = mysql_num_rows($r0);$sql0_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r0_A = mysql_query($sql0_A);
$total0_A = mysql_num_rows($r0_A);$sql0_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r0_B = mysql_query($sql0_B);
$total0_B = mysql_num_rows($r0_B);$sql0_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r0_C = mysql_query($sql0_C);
$total0_C = mysql_num_rows($r0_C);$sql0_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r0_D = mysql_query($sql0_D);
$total0_D = mysql_num_rows($r0_D);//---------------------------------
// CURVA E
$sql0_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r0_E = mysql_query($sql0_E);
$total0_E = mysql_num_rows($r0_E);//---------------------------------
// CURVA S
$sql0_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r0_S = mysql_query($sql0_S);
$total0_S = mysql_num_rows($r0_S);//**************************************************************************************************
//-------------------------
$sql0_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'SO' ");
$r0_so = mysql_query($sql0_so);
$total0_so = mysql_num_rows($r0_so);$sql0_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'FC' ");
$r0_fc = mysql_query($sql0_fc);
$total0_fc = mysql_num_rows($r0_fc);$sql0_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'PR' ");
$r0_pr = mysql_query($sql0_pr);
$total0_pr = mysql_num_rows($r0_pr);$sql0_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' AND situacao = 'MT' ");
$r0_mt = mysql_query($sql0_mt);
$total0_mt = mysql_num_rows($r0_mt);/*
echo "IKS-0: ".$total0;
echo "<br>";
echo "CURVA A: ".$total0_A."<br>";
echo "CURVA B: ".$total0_B."<br>";
echo "CURVA C: ".$total0_C."<br>";
echo "CURVA D: ".$total0_D."<br>";
echo "CURVA E: ".$total0_E."<br>";
echo "CURVA S: ".$total0_S."<br>";
echo "Separando(SO): ".$total0_so."<br>";
echo "Separando(FC): ".$total0_fc."<br>";
echo "Separando(PR): ".$total0_pr."<br>";
echo "Separando(MT): ".$total0_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-1 **********************************************************************************
$sql1 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r1 = mysql_query($sql1);
$total1 = mysql_num_rows($r1);// CURVA A
$sql1_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r1_A = mysql_query($sql1_A);
$total1_A = mysql_num_rows($r1_A);$sql1_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r1_B = mysql_query($sql1_B);
$total1_B = mysql_num_rows($r1_B);$sql1_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r1_C = mysql_query($sql1_C);
$total1_C = mysql_num_rows($r1_C);$sql1_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r1_D = mysql_query($sql1_D);
$total1_D = mysql_num_rows($r1_D);//---------------------------------
// CURVA E
$sql1_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-1' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r1_E = mysql_query($sql1_E);
$total1_E = mysql_num_rows($r1_E);//---------------------------------
// CURVA S
$sql1_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-0' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r1_S = mysql_query($sql1_S);
$total1_S = mysql_num_rows($r1_S);$sql1_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'SO' ");
$r1_so = mysql_query($sql1_so);
$total1_so = mysql_num_rows($r1_so);$sql1_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'FC' ");
$r1_fc = mysql_query($sql1_fc);
$total1_fc = mysql_num_rows($r1_fc);$sql1_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'PR' ");
$r1_pr = mysql_query($sql1_pr);
$total1_pr = mysql_num_rows($r1_pr);$sql1_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' AND situacao = 'MT' ");
$r1_mt = mysql_query($sql1_mt);
$total1_mt = mysql_num_rows($r1_mt);echo "IKS-1: ".$total1;
echo "<br>";
echo "CURVA A: ".$total1_A."<br>";
echo "CURVA B: ".$total1_B."<br>";
echo "CURVA C: ".$total1_C."<br>";
echo "CURVA D: ".$total1_D."<br>";
echo "CURVA E: ".$total1_E."<br>";
echo "CURVA S: ".$total1_S."<br>";
echo "Separando(SO): ".$total1_so."<br>";
echo "Separando(FC): ".$total1_fc."<br>";
echo "Separando(PR): ".$total1_pr."<br>";
echo "Separando(MT): ".$total1_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-2 **********************************************************************************
$sql2 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' ");
$r2 = mysql_query($sql2);
$total2 = mysql_num_rows($r2);//-------------------------
// CURVA A
$sql2_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r2_A = mysql_query($sql2_A);
$total2_A = mysql_num_rows($r2_A);//-------------------------
// CURVA B
$sql2_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r2_B = mysql_query($sql2_B);
$total2_B = mysql_num_rows($r2_B);//-------------------------
// CURVA C
$sql2_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r2_C = mysql_query($sql2_C);
$total2_C = mysql_num_rows($r2_C);//-------------------------
// CURVA D
$sql2_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r2_D = mysql_query($sql2_D);
$total2_D = mysql_num_rows($r2_D);//-------------------------
// CURVA E
$sql2_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r2_E = mysql_query($sql2_E);
$total2_E = mysql_num_rows($r2_E);//-------------------------
// CURVA S
$sql2_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-2' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r2_S = mysql_query($sql2_S);
$total2_S = mysql_num_rows($r2_S);//-------------------------
$sql2_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'SO' ");
$r2_so = mysql_query($sql2_so);
$total2_so = mysql_num_rows($r2_so);$sql2_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'FC' ");
$r2_fc = mysql_query($sql2_fc);
$total2_fc = mysql_num_rows($r2_fc);$sql2_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'PR' ");
$r2_pr = mysql_query($sql2_pr);
$total2_pr = mysql_num_rows($r2_pr);$sql2_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' AND situacao = 'MT' ");
$r2_mt = mysql_query($sql2_mt);
$total2_mt = mysql_num_rows($r2_mt);echo "IKS-2: ".$total2;
echo "<br>";
echo "CURVA A: ".$total2_A."<br>";
echo "CURVA B: ".$total2_B."<br>";
echo "CURVA C: ".$total2_C."<br>";
echo "CURVA D: ".$total2_D."<br>";
echo "CURVA E: ".$total2_E."<br>";
echo "CURVA S: ".$total2_S."<br>";
echo "Separando(SO): ".$total2_so."<br>";
echo "Separando(FC): ".$total2_fc."<br>";
echo "Separando(PR): ".$total2_pr."<br>";
echo "Separando(MT): ".$total2_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-3 **********************************************************************************
$sql3 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' ");
$r3 = mysql_query($sql3);
$total3 = mysql_num_rows($r3);//-------------------------
// CURVA A
$sql3_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r3_A = mysql_query($sql3_A);
$total3_A = mysql_num_rows($r3_A);//-------------------------
// CURVA B
$sql3_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r3_B = mysql_query($sql3_B);
$total3_B = mysql_num_rows($r3_B);//-------------------------
// CURVA C
$sql3_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r3_C = mysql_query($sql3_A);
$total3_C = mysql_num_rows($r3_C);//-------------------------
// CURVA D
$sql3_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r3_D = mysql_query($sql3_D);
$total3_D = mysql_num_rows($r3_D);//-------------------------
// CURVA E
$sql3_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r3_E = mysql_query($sql3_E);
$total3_E = mysql_num_rows($r3_E);//-------------------------
// CURVA S
$sql3_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-3' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r3_S = mysql_query($sql3_S);
$total3_S = mysql_num_rows($r3_S);//--------------------------------------------------
$sql3_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'SO' ");
$r3_so = mysql_query($sql3_so);
$total3_so = mysql_num_rows($r3_so);$sql3_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'FC' ");
$r3_fc = mysql_query($sql3_fc);
$total3_fc = mysql_num_rows($r3_fc);$sql3_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'PR' ");
$r3_pr = mysql_query($sql3_pr);
$total3_pr = mysql_num_rows($r3_pr);$sql3_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-3' AND situacao = 'MT' ");
$r3_mt = mysql_query($sql3_mt);
$total3_mt = mysql_num_rows($r3_mt);echo "IKS-3: ".$total3;
echo "<br>";
echo "CURVA A: ".$total3_A."<br>";
echo "CURVA B: ".$total3_B."<br>";
echo "CURVA C: ".$total3_C."<br>";
echo "CURVA D: ".$total3_D."<br>";
echo "CURVA E: ".$total3_E."<br>";
echo "CURVA S: ".$total3_S."<br>";
echo "Separando(SO): ".$total3_so."<br>";
echo "Separando(FC): ".$total3_fc."<br>";
echo "Separando(PR): ".$total3_pr."<br>";
echo "Separando(MT): ".$total3_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-4 **********************************************************************************
$sql4 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' ");
$r4 = mysql_query($sql4);
$total4 = mysql_num_rows($r4);//-------------------------
// CURVA A
$sql4_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r4_A = mysql_query($sql4_A);
$total4_A = mysql_num_rows($r4_A);//-------------------------
// CURVA B
$sql4_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r4_B = mysql_query($sql4_B);
$total4_B = mysql_num_rows($r4_B);//-------------------------
// CURVA C
$sql4_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r4_C = mysql_query($sql4_C);
$total4_C = mysql_num_rows($r4_C);//-------------------------
// CURVA D
$sql4_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r4_D = mysql_query($sql4_D);
$total4_D = mysql_num_rows($r4_D);//-------------------------
// CURVA E
$sql4_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r4_E = mysql_query($sql4_E);
$total4_E = mysql_num_rows($r4_E);//-------------------------
// CURVA S
$sql4_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-4' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r4_S = mysql_query($sql4_S);
$total4_S = mysql_num_rows($r4_S);//------------------------------------------------
$sql4_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'SO' ");
$r4_so = mysql_query($sql4_so);
$total4_so = mysql_num_rows($r4_so);$sql4_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'FC' ");
$r4_fc = mysql_query($sql4_fc);
$total4_fc = mysql_num_rows($r4_fc);$sql4_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'PR' ");
$r4_pr = mysql_query($sql4_pr);
$total4_pr = mysql_num_rows($r4_pr);$sql4_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' AND situacao = 'MT' ");
$r4_mt = mysql_query($sql4_mt);
$total4_mt = mysql_num_rows($r4_mt);echo "IKS-4: ".$total4;
echo "<br>";
echo "CURVA A: ".$total4_A."<br>";
echo "CURVA B: ".$total4_B."<br>";
echo "CURVA C: ".$total4_C."<br>";
echo "CURVA D: ".$total4_D."<br>";
echo "CURVA E: ".$total4_E."<br>";
echo "CURVA S: ".$total4_S."<br>";
echo "Separando(SO): ".$total4_so."<br>";
echo "Separando(FC): ".$total4_fc."<br>";
echo "Separando(PR): ".$total4_pr."<br>";
echo "Separando(MT): ".$total4_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-5 **********************************************************************************
$sql5 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' ");
$r5 = mysql_query($sql5);
$total5 = mysql_num_rows($r5);//-------------------------
// CURVA A
$sql5_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r5_A = mysql_query($sql5_A);
$total5_A = mysql_num_rows($r5_A);//-------------------------
// CURVA B
$sql5_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r5_B = mysql_query($sql5_B);
$total5_B = mysql_num_rows($r5_B);//-------------------------
// CURVA C
$sql5_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r5_C = mysql_query($sql5_C);
$total5_C = mysql_num_rows($r5_C);//-------------------------
// CURVA D
$sql5_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r5_D = mysql_query($sql5_D);
$total5_D = mysql_num_rows($r5_D);//-------------------------
// CURVA E
$sql5_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r5_E = mysql_query($sql5_E);
$total5_E = mysql_num_rows($r5_E);//-------------------------
// CURVA S
$sql5_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-5' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r5_S = mysql_query($sql5_S);
$total5_S = mysql_num_rows($r5_S);//--------------------------------------------
$sql5_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'SO' ");
$r5_so = mysql_query($sql5_so);
$total5_so = mysql_num_rows($r5_so);$sql5_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'FC' ");
$r5_fc = mysql_query($sql5_fc);
$total5_fc = mysql_num_rows($r5_fc);$sql5_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'PR' ");
$r5_pr = mysql_query($sql5_pr);
$total5_pr = mysql_num_rows($r5_pr);$sql5_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' AND situacao = 'MT' ");
$r5_mt = mysql_query($sql5_mt);
$total5_mt = mysql_num_rows($r5_mt);echo "IKS-5: ".$total5;
echo "<br>";
echo "CURVA A: ".$total5_A."<br>";
echo "CURVA B: ".$total5_B."<br>";
echo "CURVA C: ".$total5_C."<br>";
echo "CURVA D: ".$total5_D."<br>";
echo "CURVA E: ".$total5_E."<br>";
echo "CURVA S: ".$total5_S."<br>";
echo "Separando(SO): ".$total5_so."<br>";
echo "Separando(FC): ".$total5_fc."<br>";
echo "Separando(PR): ".$total5_pr."<br>";
echo "Separando(MT): ".$total5_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-6 **********************************************************************************
$sql6 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' ");
$r6 = mysql_query($sql6);
$total6 = mysql_num_rows($r6);//-------------------------
// CURVA A
$sql6_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r6_A = mysql_query($sql6_A);
$total6_A = mysql_num_rows($r6_A);//-------------------------
// CURVA B
$sql6_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r6_B = mysql_query($sql6_B);
$total6_B = mysql_num_rows($r6_B);//-------------------------
// CURVA C
$sql6_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r6_C = mysql_query($sql6_C);
$total6_C = mysql_num_rows($r6_C);//-------------------------
// CURVA D
$sql6_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r6_D = mysql_query($sql6_D);
$total6_D = mysql_num_rows($r6_D);//-------------------------
// CURVA E
$sql6_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r6_E = mysql_query($sql6_E);
$total6_E = mysql_num_rows($r6_E);//-------------------------
// CURVA D
$sql6_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r6_D = mysql_query($sql6_D);
$total6_D = mysql_num_rows($r6_D);//-------------------------
// CURVA E
$sql6_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r6_E = mysql_query($sql6_E);
$total6_E = mysql_num_rows($r6_E);//-------------------------
// CURVA A
$sql6_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-6' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r6_S = mysql_query($sql6_S);
$total6_S = mysql_num_rows($r6_S);//-------------------------
$sql6_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'SO' ");
$r6_so = mysql_query($sql6_so);
$total6_so = mysql_num_rows($r6_so);$sql6_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'FC' ");
$r6_fc = mysql_query($sql6_fc);
$total6_fc = mysql_num_rows($r6_fc);$sql6_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'PR' ");
$r6_pr = mysql_query($sql6_pr);
$total6_pr = mysql_num_rows($r6_pr);$sql6_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' AND situacao = 'MT' ");
$r6_mt = mysql_query($sql6_mt);
$total6_mt = mysql_num_rows($r6_mt);echo "IKS-6: ".$total6;
echo "<br>";
echo "CURVA A: ".$total6_A."<br>";
echo "CURVA B: ".$total6_B."<br>";
echo "CURVA C: ".$total6_C."<br>";
echo "CURVA D: ".$total6_D."<br>";
echo "CURVA E: ".$total6_E."<br>";
echo "CURVA S: ".$total6_S."<br>";
echo "Separando(SO): ".$total6_so."<br>";
echo "Separando(FC): ".$total6_fc."<br>";
echo "Separando(PR): ".$total6_pr."<br>";
echo "Separando(MT): ".$total6_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";//*** IKS-7 **********************************************************************************
$sql7 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' ");
$r7 = mysql_query($sql7);
$total7 = mysql_num_rows($r7);//-------------------------
// CURVA A
$sql7_A = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'A' GROUP BY `u`.`op` ");
$r7_A = mysql_query($sql7_A);
$total7_A = mysql_num_rows($r7_A);// CURVA B
$sql7_B = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'B' GROUP BY `u`.`op` ");
$r7_B = mysql_query($sql7_B);
$total7_B = mysql_num_rows($r7_B);// CURVA C
$sql7_C = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'C' GROUP BY `u`.`op` ");
$r7_C = mysql_query($sql7_C);
$total7_C = mysql_num_rows($r7_C);// CURVA D
$sql7_D = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'D' GROUP BY `u`.`op` ");
$r7_D = mysql_query($sql7_D);
$total7_D = mysql_num_rows($r7_D);// CURVA E
$sql7_E = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'E' GROUP BY `u`.`op` ");
$r7_E = mysql_query($sql7_E);
$total7_E = mysql_num_rows($r7_E);// CURVA S
$sql7_S = ("SELECT * FROM `dia` `u` INNER JOIN `estf004` `ud` ON `ud`.`estf_codiks` = `u`.`codiks` INNER JOIN `dia_falta` `udf` ON `udf`.`id_op` = `u`.`op` WHERE `u`.`status` = 'A' AND `u`.`planejador` = 'IKS-7' AND `ud`.`abc` = 'S' GROUP BY `u`.`op` ");
$r7_S = mysql_query($sql7_S);
$total7_S = mysql_num_rows($r7_S);//------------------------------------------
$sql7_so = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'SO' ");
$r7_so = mysql_query($sql7_so);
$total7_so = mysql_num_rows($r7_so);$sql7_fc = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'FC' ");
$r7_fc = mysql_query($sql7_fc);
$total7_fc = mysql_num_rows($r7_fc);$sql7_pr = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'PR' ");
$r7_pr = mysql_query($sql7_pr);
$total7_pr = mysql_num_rows($r7_pr);$sql7_mt = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' AND situacao = 'MT' ");
$r7_mt = mysql_query($sql7_mt);
$total7_mt = mysql_num_rows($r7_mt);echo "IKS-7: ".$total7;
echo "<br>";
echo "CURVA A: ".$total7_A."<br>";
echo "CURVA B: ".$total7_B."<br>";
echo "CURVA C: ".$total7_C."<br>";
echo "CURVA D: ".$total7_D."<br>";
echo "CURVA E: ".$total7_E."<br>";
echo "CURVA S: ".$total7_S."<br>";
echo "Separando(SO): ".$total7_so."<br>";
echo "Separando(FC): ".$total7_fc."<br>";
echo "Separando(PR): ".$total7_pr."<br>";
echo "Separando(MT): ".$total7_mt."<br>";
echo "<br>";
echo "************************************************************************* <br>";
<tr><td align="center" valign="middle">$total_so = $total0_so + $total1_so + $total2_so + $total3_so + $total4_so + $total5_so + $total6_so + $total7_so;
$total_fc = $total0_fc + $total1_fc + $total2_fc + $total3_fc + $total4_fc + $total5_fc + $total6_fc + $total7_fc;
$total_pr = $total0_pr + $total1_pr + $total2_pr + $total3_pr + $total4_pr + $total5_pr + $total6_pr + $total7_pr;
$total_mt = $total0_mt + $total1_mt + $total2_mt + $total3_mt + $total4_mt + $total5_mt + $total6_mt + $total7_mt;//total curvas
$total_A = $total0_A + $total1_A + $total2_A + $total3_A + $total4_A + $total5_A + $total6_A + $total7_A;
$total_B = $total0_B + $total1_B + $total2_B + $total3_B + $total4_B + $total5_B + $total6_B + $total7_B;
$total_C = $total0_C + $total1_C + $total2_C + $total3_C + $total4_C + $total5_C + $total6_C + $total7_C;
$total_D = $total0_D + $total1_D + $total2_D + $total3_D + $total4_D + $total5_D + $total6_D + $total7_D;
$total_E = $total0_E + $total1_E + $total2_E + $total3_E + $total4_E + $total5_E + $total6_E + $total7_E;
$total_S = $total0_S + $total1_S + $total2_S + $total3_S + $total4_S + $total5_S + $total6_S + $total7_S;//total geral
$geral = $total0 + $total1 + $total2 + $total3 + $total4 + $total5 + $total6 + $total7;
?><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
<title>Ordem de Produção</title>
<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="[https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css](https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css)">
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="//code.jquery.com/jquery-1.12.3.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
<!-- ********************************************************************* -->
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="assets/css/bootstrap-responsive.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="css/styles.css" />
<script src="js/bootstrap.min.js"></script><style type="text/css" class="init">
.container
{
width: 85%;
margin: auto;
}
.table td {
text-align: center;
font-family: verdana;
font-size: 10pt;
}
.table th {
text-align: center;
font-family: verdana;
font-size: 10pt;
}
.total1{
text-align: center;
font-family: verdana;
font-size: 10pt;
font-weight: bold;
background:#FFB90F;
color:#000000;
}.cinza {background:#f9f9f9;}
.preto {background:#000000;}
.branco {color:#AAAAAA;}
.topo {
background:#e6e6e6;
color:#000000;
}
.plan {
background:#B9D3EE;
color:#000000;
}
</style>
<script type="text/javascript">
function goBack() {
window.history.go(-1);
}
</script>
</head>
<body>
<div class="container"><!-- INICIO DO WELL -->
<a href="#" class="btn btn-block btn-primary disabled" ><strong>Relatório de Ordem de Produção</strong></a>
<br>
<div class="well well-small">
<table class="table table-striped table-bordered table-condensed ">
<thead>
<tr heigth>
<th class="plan">Planejador</th>
<th class="plan">Separando (SO)</th>
<th class="plan">Faltando Componente (FC)</th>
<th class="plan">Processo (PR)</th>
<th class="plan">Montando (MT)</th>
<th class="plan" width="3%">A</th>
<th class="plan" width="3%">B</th>
<th class="plan" width="3%">C</th>
<th class="plan" width="3%">D</th>
<th class="plan" width="3%">E</th>
<th class="plan" width="3%">S</th>
<th class="plan">Subtotal</th>
</tr>
</thead>
<tbody>
<tr>
<td class="plan">IKS-0</td>
<td><?= $total0_so ?></td>
<td><?= $total0_fc ?></td>
<td><?= $total0_pr ?></td>
<td><?= $total0_mt ?></td>
<td><?= $total0_A ?></td>
<td><?= $total0_B ?></td>
<td><?= $total0_C ?></td>
<td><?= $total0_D ?></td>
<td><?= $total0_E ?></td>
<td><?= $total0_S ?></td>
<td><?= $total0 ?></td>
</tr>
<tr>
<td class="plan">IKS-1</td>
<td><?= $total1_so ?></td>
<td><?= $total1_fc ?></td>
<td><?= $total1_pr ?></td>
<td><?= $total1_mt ?></td>
<td><?= $total1_A ?></td>
<td><?= $total1_B ?></td>
<td><?= $total1_C ?></td>
<td><?= $total1_D ?></td>
<td><?= $total1_E ?></td>
<td><?= $total1_S ?></td>
<td><?= $total1 ?></td>
</tr>
<tr>
<td class="plan">IKS-2</td>
<td><?= $total2_so ?></td>
<td><?= $total2_fc ?></td>
<td><?= $total2_pr ?></td>
<td><?= $total2_mt ?></td>
<td><?= $total2_A ?></td>
<td><?= $total2_B ?></td>
<td><?= $total2_C ?></td>
<td><?= $total2_D ?></td>
<td><?= $total2_E ?></td>
<td><?= $total2_S ?></td>
<td><?= $total2 ?></td>
</tr>
<tr>
<td class="plan">IKS-3</td>
<td><?= $total3_so ?></td>
<td><?= $total3_fc ?></td>
<td><?= $total3_pr ?></td>
<td><?= $total3_mt ?></td>
<td><?= $total3_A ?></td>
<td><?= $total3_B ?></td>
<td><?= $total3_C ?></td>
<td><?= $total3_D ?></td>
<td><?= $total3_E ?></td>
<td><?= $total3_S ?></td>
<td><?= $total3 ?></td>
</tr>
<tr>
<td class="plan">IKS-4</td>
<td><?= $total4_so ?></td>
<td><?= $total4_fc ?></td>
<td><?= $total4_pr ?></td>
<td><?= $total4_mt ?></td>
<td><?= $total4_A ?></td>
<td><?= $total4_B ?></td>
<td><?= $total4_C ?></td>
<td><?= $total4_D ?></td>
<td><?= $total4_E ?></td>
<td><?= $total4_S ?></td>
<td><?= $total4 ?></td>
</tr>
<tr>
<td class="plan">IKS-5</td>
<td><?= $total5_so ?></td>
<td><?= $total5_fc ?></td>
<td><?= $total5_pr ?></td>
<td><?= $total5_mt ?></td>
<td><?= $total5_A ?></td>
<td><?= $total5_B ?></td>
<td><?= $total5_C ?></td>
<td><?= $total5_D ?></td>
<td><?= $total5_E ?></td>
<td><?= $total5_S ?></td>
<td><?= $total5 ?></td>
</tr>
<tr>
<td class="plan">IKS-6</td>
<td><?= $total6_so ?></td>
<td><?= $total6_fc ?></td>
<td><?= $total6_pr ?></td>
<td><?= $total6_mt ?></td>
<td><?= $total6_A ?></td>
<td><?= $total6_B ?></td>
<td><?= $total6_C ?></td>
<td><?= $total6_D ?></td>
<td><?= $total6_E ?></td>
<td><?= $total6_S ?></td>
<td><?= $total6 ?></td>
</tr>
<tr>
<td class="plan">IKS-7</td>
<td><?= $total7_so ?></td>
<td><?= $total7_fc ?></td>
<td><?= $total7_pr ?></td>
<td><?= $total7_mt ?></td>
<td><?= $total7_A ?></td>
<td><?= $total7_B ?></td>
<td><?= $total7_C ?></td>
<td><?= $total7_D ?></td>
<td><?= $total7_E ?></td>
<td><?= $total7_S ?></td>
<td><?= $total7 ?></td>
</tr>
<tr>
<td class="total1">TOTAL</td>
<td class="total1"><?= $total_so ?></td>
<td class="total1"><?= $total_fc ?></td>
<td class="total1"><?= $total_pr ?></td>
<td class="total1"><?= $total_mt ?></td>
<td class="total1"><?= $total_A ?></td>
<td class="total1"><?= $total_B ?></td>
<td class="total1"><?= $total_C ?></td>
<td class="total1"><?= $total_D ?></td>
<td class="total1"><?= $total_E ?></td>
<td class="total1"><?= $total_S ?></td>
<td class="total1"><?= $geral ?></td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
<center><button onclick="goBack()" class="btn btn-warning">Voltar</button></center>Não adianta você postar o código todo amigo, seja objetivo.
Debugue sua query, veja onde ela não funcione.
Tentou utilizar subconsultas? Acho que é possível.
FROM sua_tabela
WHERE ...";