Ajuda com Select Count

empirerock · Novembro 3, 2016

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>";
//**********************************************************************************************

manolegal · Novembro 3, 2016

Tentou utilizar subconsultas? Acho que é possível.

"SELECT seu_campo1, seu_campo2,

    (SELECT COUNT(seu_campo) FROM sua_tabela WHERE uma condição...) as total_alguma_coisa,

    (SELECT COUNT(seu_campo) FROM sua_tabela WHERE outra condição...) as total_outra_coisa

FROM sua_tabela
WHERE ...";

empirerock · Novembro 4, 2016

Bom dia.

Obrigado por responder.

Vou testar da forma que você passou e volto para responder como ficou.

Obrigado

empirerock · Novembro 4, 2016

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>";

manolegal · Novembro 4, 2016

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'";

Fernando C · Novembro 4, 2016

se entendi bem, 1 outra possibilidade:

SELECT planejador, count(*) total FROM dia WHERE status = 'A' group by planejador

empirerock · Novembro 4, 2016

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);
//-------------------------
// CURVA A
$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);
//-------------------------
// CURVA B
$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);
//---------------------------------
// CURVA C
$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);
//---------------------------------
// CURVA D
$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);
//-------------------------
// CURVA B
$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);
//---------------------------------
// CURVA C
$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);
//---------------------------------
// CURVA D
$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>";

manolegal · Novembro 4, 2016

Ainda acho que é possível da maneira que coloquei. Tentou implementar a sugestão do #5?

empirerock · Novembro 4, 2016

Boa tarde.

Sim tentei, más não deu certo.

manolegal · Novembro 5, 2016

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.

empirerock · Novembro 7, 2016

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);
//-------------------------
// CURVA A
$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);
//-------------------------
// CURVA B
$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);
//---------------------------------
// CURVA C
$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);
//---------------------------------
// CURVA D
$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);
//-------------------------
// CURVA B
$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);
//---------------------------------
// CURVA C
$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);
//---------------------------------
// CURVA D
$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 situacao
$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">
	

	<!-- 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>

Mateus Silva · Novembro 7, 2016

Não adianta você postar o código todo amigo, seja objetivo.

Debugue sua query, veja onde ela não funcione.

Arquivado

Ajuda com Select Count

Recommended Posts

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

manolegal 12

Compartilhar este post

Link para o post

Compartilhar em outros sites

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

manolegal 12

Compartilhar este post

Link para o post

Compartilhar em outros sites

Fernando C 128

Compartilhar este post

Link para o post

Compartilhar em outros sites

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

manolegal 12

Compartilhar este post

Link para o post

Compartilhar em outros sites

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

manolegal 12

Compartilhar este post

Link para o post

Compartilhar em outros sites

empirerock 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mateus Silva 64

Compartilhar este post

Link para o post

Compartilhar em outros sites

PHP+Codeigniter - Dúvida em Relação a Teclas

Conexão mysql com outro domínio

[Resolvido] JavaScript - Exibir logo dentro da Tabela html

Conteúdo Similar

Fóruns

Tempo Real

Informação importante