object(PDO)#1 (0) {
}
object(PDOStatement)#2 (1) {
["queryString"]=>
string(1726) "SELECT a.NUM_PEDIDO, sum(b.qtd_pecas_solic) as QTD_PECAS_SOLIC, c.COD_ITEM, d.MODELO, d.ESPECIE, c.DEN_ITEM, d.especie[3,3] as MADB, 'c.den_item', 'ajustar' as D, 'c.den_item', 0 as LOTE, d.especie[3,3] as MOD from pedidos a, ped_itens b, item c, sincol_lista d where b.cod_empresa = a.cod_empresa and b.num_pedido = a.num_pedido and c.cod_empresa = a.cod_empresa and c.cod_item = b.cod_item and d.cod_item = c.cod_item and d.cod_item = b.cod_item and a.cod_empresa = '01' and a.num_pedido = '47714' and a.ies_sit_pedido <> '9' and c.gru_ctr_estoq = '4' and b.qtd_pecas_solic - b.qtd_pecas_atend > '0' and c.cod_item not in ('55727','18000','55733','55729','55730','55725','65958','55734','55732','55728','55731','C55729','C55730','C55734','55752','55748','C55748','55749','55746','55745','55753','45174','55761','55757','C55757','55758','C55758','55755','55754','55762','55760','55756','55759','55739','55740','55766','55767','C55767','55763','55771','C55771','55769') and den_item[1,1] = '6' group by 1, 3, 4, 5, 6,7, 9, 10, 11, 12 UNION SELECT a.NUM_PEDIDO, sum(a.qkits*a.qtd_pc) as QTD_PECAS_SOLIC, a.cod_item, a.desc[1,4] as MODELO, e.madb as ESPECIE, b.den_item,a.desc[6,8] as MADB, max(c.desc_compon) as DESC_C, a.desc as D, d.descricao, round(e.lote) as LOTE, especie[3,3] as MOD from sincol_comp_kit as a, item as b, sincol_tab_compon as c, outer sincol_acab_kit as d, sincol_res_kit as e where b.cod_empresa = a.cod_empresa and b.cod_item = a.cod_item and c.cod_compon = a.cod_compon and d.acab = a.acab and e.cod_empresa = a.cod_empresa and e.agrup = a.agrup and e.num_pedido = a.num_pedido and a.cod_empresa = '01' and a.num_pedido = '47714' and c.cod_compon in ('02','12') group by 1, 3, 4, 5, 6,7, 9, 10, 11, 12;"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(3) "1.0"
[1]=>
string(3) "1.0"
["COD_ITEM"]=>
string(25) "60703 "
[2]=>
string(25) "60703 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-165X651X607X33 "
[8]=>
string(120) "607 -97E-165X651X607X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(3) "1.0"
[1]=>
string(3) "1.0"
["COD_ITEM"]=>
string(25) "62369 "
[2]=>
string(25) "62369 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-190X751X707X33 "
[8]=>
string(120) "607 -97E-190X751X707X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(3) "2.0"
[1]=>
string(3) "2.0"
["COD_ITEM"]=>
string(25) "62369 "
[2]=>
string(25) "62369 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-190X851X807X33 "
[8]=>
string(120) "607 -97E-190X851X807X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(3) "6.0"
[1]=>
string(3) "6.0"
["COD_ITEM"]=>
string(25) "62368 "
[2]=>
string(25) "62368 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X2125X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0190-0215X2125X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES "
["D"]=>
string(120) "607 -97E-190X2110X33 "
[8]=>
string(120) "607 -97E-190X2110X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(3) "7.0"
[1]=>
string(3) "7.0"
["COD_ITEM"]=>
string(25) "60701 "
[2]=>
string(25) "60701 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-140X671X627X33 "
[8]=>
string(120) "607 -97E-140X671X627X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(4) "22.0"
[1]=>
string(4) "22.0"
["COD_ITEM"]=>
string(25) "60703 "
[2]=>
string(25) "60703 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-165X671X627X33 "
[8]=>
string(120) "607 -97E-165X671X627X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(4) "30.0"
[1]=>
string(4) "30.0"
["COD_ITEM"]=>
string(25) "60701 "
[2]=>
string(25) "60701 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-140X851X807X33 "
[8]=>
string(120) "607 -97E-140X851X807X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(4) "38.0"
[1]=>
string(4) "38.0"
["COD_ITEM"]=>
string(25) "60703 "
[2]=>
string(25) "60703 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X1000X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES CABECEIRA "
["D"]=>
string(120) "607 -97E-165X851X807X33 "
[8]=>
string(120) "607 -97E-165X851X807X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(4) "74.0"
[1]=>
string(4) "74.0"
["COD_ITEM"]=>
string(25) "60702 "
[2]=>
string(25) "60702 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X2125X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0140-0165X2125X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES "
["D"]=>
string(120) "607 -97E-140X2110X33 "
[8]=>
string(120) "607 -97E-140X2110X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}
array(23) {
["NUM_PEDIDO"]=>
string(7) "47714.0"
[0]=>
string(7) "47714.0"
["QTD_PECAS_SOLIC"]=>
string(5) "122.0"
[1]=>
string(5) "122.0"
["COD_ITEM"]=>
string(25) "60704 "
[2]=>
string(25) "60704 "
["MODELO"]=>
string(5) "607 "
[3]=>
string(5) "607 "
["ESPECIE"]=>
string(3) "97E"
[4]=>
string(3) "97E"
["DEN_ITEM"]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X2125X0033 LAM IMBUIA LINH ENV "
[5]=>
string(120) "607 -97E-BAT.PINUS REG.C/VED.0165-0190X2125X0033 LAM IMBUIA LINH ENV "
["MADB"]=>
string(3) "97E"
[6]=>
string(3) "97E"
[""]=>
NULL
[7]=>
string(120) "BATENTES "
["D"]=>
string(120) "607 -97E-165X2110X33 "
[8]=>
string(120) "607 -97E-165X2110X33 "
[9]=>
NULL
["LOTE"]=>
string(1) "1"
[10]=>
string(1) "1"
["MOD"]=>
string(1) "E"
[11]=>
string(1) "E"
}