D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
www
/
html
/
crsys
/
adm
/
vendor
/
api
/
Filename :
debug_lerOrcamento_log.txt
back
Copy
[2026-06-26 13:21:20] ================================ [2026-06-26 13:21:20] INÍCIO REQUEST [2026-06-26 13:21:20] GET RECEBIDO: Array ( [tipo_usu] => [id_usu] => 1 [empr_id] => 1 [orca_id] => 2 [num_rev] => 0 [tipo] => O [material] => 0 ) [2026-06-26 13:21:20] PARAMETROS TRATADOS: [2026-06-26 13:21:20] tipo_usu= | id_usu=1 | orca_id=2 | num_rev=0 | tipo=O | empr_id=1 | material=0 [2026-06-26 13:23:29] ================================ [2026-06-26 13:23:29] INÍCIO REQUEST [2026-06-26 13:23:29] GET RECEBIDO: Array ( [tipo_usu] => [id_usu] => 1 [empr_id] => 1 [orca_id] => 2 [num_rev] => 0 [tipo] => O [material] => 0 ) [2026-06-26 13:23:29] PARAMETROS TRATADOS: [2026-06-26 13:23:29] tipo_usu= | id_usu=1 | orca_id=2 | num_rev=0 | tipo=O | empr_id=1 | material=0 [2026-06-26 13:23:29] ULTIMA REVISAO: Array ( ) [2026-06-26 13:23:29] QUERY PRINCIPAL: [2026-06-26 13:23:29] SELECT c.*, max_orc.max_rev, max_stat.max_status_id, case when c.vlr_base_total > 0 then ROUND(((c.vlr_semdesc / c.vlr_base_total) - 1) * 100 + 100, 2) else 100 end AS ajuste, CASE WHEN LENGTH(c.telefone_obra) < 11 THEN MASK(LPAD(c.telefone_obra,10,'0'), '(##) ####-####') ELSE MASK(LPAD(c.telefone_obra,11,'0'), '(##) #####-####') END AS telefone_obra, MASK(LPAD(c.tel_vend,11,'0'), '(##) #####-####') AS cel, MASK(LPAD(c.tel_vend,11,'0'), '(##) #####-####') AS tel_vend, MASK(LPAD(c.cep_obra,8,'0'), '#####-###') AS cep, DATE_FORMAT(c.data, '%d/%m/%Y') AS data, DATE_FORMAT(c.data_ult_rev, '%d/%m/%Y') AS data_ult_rev, c.endereco_obra AS rua, c.numero_obra, c.municipio_obra AS municipio, c.uf_obra AS uf, (select sum(i.m2) from gre_item_orcamento i where i.orca_id = c.orca_id and i.num_revisao = c.num_revisao and i.empr_id = c.empr_id) m2, stat.nome AS nome_stat, cr.cor AS cor_cr FROM gre_cab_orcamento c INNER JOIN gre_status stat ON stat.id = c.status_id INNER JOIN adms_cors cr ON cr.id = stat.cor_id LEFT JOIN gre_arquitetos a ON a.id = c.arquiteto_id LEFT JOIN ( SELECT orca_id, empr_id, MAX(num_revisao) AS max_rev FROM gre_cab_orcamento GROUP BY orca_id, empr_id ) AS max_orc ON max_orc.orca_id = c.orca_id AND max_orc.empr_id = c.empr_id LEFT JOIN ( SELECT orca_id, empr_id, MAX(status_id) AS max_status_id FROM gre_cab_orcamento WHERE status_id < 88 GROUP BY orca_id, empr_id ) AS max_stat ON max_stat.orca_id = c.orca_id AND max_stat.empr_id = c.empr_id WHERE c.orca_id = :orca_id_main AND c.num_revisao = :num_rev_main AND c.empr_id = :empr_id_main and c.status_id < 88 [2026-06-26 13:23:29] PARAMS: [2026-06-26 13:23:29] Array ( [:orca_id_main] => 2 [:num_rev_main] => 0 [:empr_id_main] => 1 ) [2026-06-26 13:23:29] RESULTADO DADOS: Array ( [0] => Array ( [empr_id] => 1 [orca_id] => 2 [num_revisao] => 0 [data] => [data_ult_rev] => [cliente_id] => 14 [nome_cliente] => Adriana Fuga [vend] => 3 [obra_id] => 2 [obra] => CM Informática Ltda [tel_vend] => (11) 99622-5252 [contato_obra] => Silvio Silveira [email_vend] => crmarques1402@gmail.com [telefone_obra] => (11) 3882-8299 [orcamentista_id] => 4 [orcamentista] => Bruno [email_obra] => crmarques1402@gmail.com [arquiteto_id] => 2 [arquiteto] => Silvio Silveira [rt] => 10.00 [cep_obra] => 4612080 [endereco_obra] => Rua Félix de Sousa [numero_obra] => 200 [complemento] => Cj 127 [bairro] => Vila Congonhas [municipio_obra] => São Paulo [uf_obra] => SP [obs_obra] => [cep_cobra] => [endereco_cobra] => [numero_cobra] => [complemento_cobra] => [bairro_cobra] => [municipio_cobra] => [uf_cobra] => [municipio_id_cobra] => [celular_cobra] => [vlr_base_total] => 9844.78 [vlr_semdesc] => 9844.78 [vlr_frete] => 108.30 [vlr_desc] => [perc_sp] => [perc_desc_sp] => 8.00 [vlr_sp] => 0.00 [vlr_insumo] => 718.27 [vlr_total] => 15453.43 [vlr_dife_revisao] => -3159.55 [perc_comis] => 3.00 [vlr_comis] => 350.22 [forma_pgto] => 35,00% de Entrada mais 4 Parcelas [num_ped] => 1 [tipo_pgto_entrada] => 2 [tipo_pgto_parcela] => 1 [perc_entrada] => 35.00 [valor_entrada] => 2688.05 [num_parcelas] => 4 [valor_parcela] => 1248.02 [data_parcela] => 2026-06-10 [ult_contra_entrega] => 1 [distancia] => 19 [chave] => [data_envio_aceite] => 2026-06-22 12:08:15 [email_envio_aceite] => crmarques@uol.com.br [data_retorno_aceite] => 2026-06-22 12:11:32 [retorno_aceite] => S [num_contrato] => 1219 [data_contrato] => 2026-06-02 13:35:48 [data_email_contrato] => 2026-06-22 12:15:21 [data_agenda_medicao] => [data_limite_medicao] => 2026-06-10 [data_medicao] => [data_limite_liberar] => [medidor_id] => [dias_entrega] => 35 [status_id] => 23 [status_real] => 7 [created] => 2026-06-02 12:05:18 [usu_created] => 1 [modified] => 2026-06-22 12:45:50 [usu_modified] => 0 [max_rev] => 0 [max_status_id] => 23 [ajuste] => 100.00 [cel] => (11) 99622-5252 [cep] => 04612-080 [rua] => Rua Félix de Sousa [municipio] => São Paulo [uf] => SP [m2] => 7.79 [nome_stat] => Confirmar Revisão [cor_cr] => warning ) ) [2026-06-26 13:23:29] ITENS: Array ( [0] => Array ( [id] => 4 [empr_id] => 1 [item] => 4 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.80 [prof] => 0.60 [alt_fron_esq] => 0.00 [larg_fron_esq] => 0.00 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.00 [larg_fron_fun] => 0.00 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.15 [larg_saia_esq] => 0.60 [alt_saia_dir] => 0.15 [larg_saia_dir] => 0.60 [alt_saia_fun] => 0.00 [larg_saia_fun] => 1.80 [alt_saia_fren] => 0.15 [larg_saia_fren] => 1.80 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => [acabFun] => 1 [fronDir] => [fronEsq] => [fronFren] => [fronFun] => [saiaDir] => 1 [saiaEsq] => 1 [saiaFren] => 1 [saiaFun] => [acab_topo_frontao] => [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => 1 [servico] => [qtde_serv] => 0 [material_id] => 178 [material] => Ardósia Cinza Polido [benef_id] => 6 [vlr_unit_acab] => 125.00 [vlr_unit_mat] => 811.00 [vlr_unit_prod] => 180.00 [vlr_unit_serv] => 0.00 [ambiente_id] => 26 [descricao] => Banco medindo (1,80 x 0,60 m) - Saia Fren H: 0,15 - Saia Dir H: 0,15 - Saia Esq H: 0,15 - Acabamento Reto - Acabamento em 1/2 esquadria, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Banco medindo (1,80 x 0,60 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 0.00 [vlr_total_mat] => 1240.83 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 276.12 [vlr_total] => 7017.30 [base_total] => 1516.95 [m2] => 1.53 [ml] => 2.40 [produto] => 109 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:52:35 [usu_created] => 0 [modified] => 2026-06-22 12:44:27 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => 4 [vlr_dife_item] => 0.00 [vlr_total_ant] => 7017.30 [valorTotal] => 7017.30 [nome_ambiente] => Área Externa ) [1] => Array ( [id] => 5 [empr_id] => 1 [item] => 5 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.20 [prof] => 0.70 [alt_fron_esq] => 0.00 [larg_fron_esq] => 0.00 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.15 [larg_fron_fun] => 1.20 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.15 [larg_saia_esq] => 0.70 [alt_saia_dir] => 0.15 [larg_saia_dir] => 0.70 [alt_saia_fun] => 0.00 [larg_saia_fun] => 1.20 [alt_saia_fren] => 0.15 [larg_saia_fren] => 1.20 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => [acabFun] => [fronDir] => [fronEsq] => [fronFren] => [fronFun] => 1 [saiaDir] => 1 [saiaEsq] => 1 [saiaFren] => 1 [saiaFun] => [acab_topo_frontao] => 1 [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => [servico] => [qtde_serv] => 0 [material_id] => 767 [material] => Ascale Cosmopolita Gray Bruto [benef_id] => 14 [vlr_unit_acab] => 0.00 [vlr_unit_mat] => 4406.00 [vlr_unit_prod] => 127.30 [vlr_unit_serv] => 0.00 [ambiente_id] => 26 [descricao] => Aparador medindo (1,20 x 0,70 m) - Fron H: 0,15 - Saia Fren H: 0,15 - Saia Dir H: 0,15 - Saia Esq H: 0,15 - Acabamento em 1/2 esquadria - Acb. reto no Frontão, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Aparador medindo (1,20 x 0,70 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 829.78 [vlr_total_mat] => 6212.46 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 254.46 [vlr_total] => 7296.70 [base_total] => 7296.70 [m2] => 1.41 [ml] => 1.90 [produto] => 46 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:55:59 [usu_created] => 0 [modified] => 2026-06-22 12:45:50 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => 5 [vlr_dife_item] => -3159.55 [vlr_total_ant] => 10456.25 [valorTotal] => 7296.70 [nome_ambiente] => Área Externa ) [2] => Array ( [id] => 6 [empr_id] => 1 [item] => 6 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.20 [prof] => 0.40 [alt_fron_esq] => 0.15 [larg_fron_esq] => 0.40 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.15 [larg_fron_fun] => 1.20 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.00 [larg_saia_esq] => 0.40 [alt_saia_dir] => 0.20 [larg_saia_dir] => 0.40 [alt_saia_fun] => 0.20 [larg_saia_fun] => 1.20 [alt_saia_fren] => 0.00 [larg_saia_fren] => 1.20 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => 1 [acabFun] => [fronDir] => [fronEsq] => 1 [fronFren] => [fronFun] => 1 [saiaDir] => 1 [saiaEsq] => [saiaFren] => [saiaFun] => 1 [acab_topo_frontao] => 1 [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => 1 [servico] => [qtde_serv] => 0 [material_id] => 178 [material] => Ardósia Cinza Polido [benef_id] => 6 [vlr_unit_acab] => 125.00 [vlr_unit_mat] => 811.00 [vlr_unit_prod] => 178.00 [vlr_unit_serv] => 0.00 [ambiente_id] => 6 [descricao] => Lavatório medindo (1,20 x 0,40 m) - Fron H: 0,15 - Saia Fun H: 0,20 - Saia Dir H: 0,20 - Acabamento Reto - Acabamento em 1/2 esquadria - Acb. reto no Frontão, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Lavatório medindo (1,20 x 0,40 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 0.00 [vlr_total_mat] => 843.44 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 187.69 [vlr_total] => 1031.13 [base_total] => 1031.13 [m2] => 1.04 [ml] => 1.60 [produto] => 68 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:58:35 [usu_created] => 0 [modified] => 2026-06-09 17:59:30 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => [vlr_dife_item] => [vlr_total_ant] => [valorTotal] => 1031.13 [nome_ambiente] => Banho 1 ) ) [2026-06-26 13:23:29] OBRAS: Array ( [0] => Array ( [codigo] => 1 [nome] => Carlos Roberto Marques ) [1] => Array ( [codigo] => 2 [nome] => CM Informática Ltda ) ) [2026-06-26 13:23:29] FINALIZADO COM SUCESSO [2026-06-26 13:23:50] ================================ [2026-06-26 13:23:50] INÍCIO REQUEST [2026-06-26 13:23:50] GET RECEBIDO: Array ( [tipo_usu] => [id_usu] => 1 [empr_id] => 1 [orca_id] => 2 [num_rev] => 0 [tipo] => O [material] => 0 ) [2026-06-26 13:23:50] PARAMETROS TRATADOS: [2026-06-26 13:23:50] tipo_usu= | id_usu=1 | orca_id=2 | num_rev=0 | tipo=O | empr_id=1 | material=0 [2026-06-26 13:23:50] ULTIMA REVISAO: Array ( ) [2026-06-26 13:23:50] QUERY PRINCIPAL: [2026-06-26 13:23:50] SELECT c.*, max_orc.max_rev, max_stat.max_status_id, case when c.vlr_base_total > 0 then ROUND(((c.vlr_semdesc / c.vlr_base_total) - 1) * 100 + 100, 2) else 100 end AS ajuste, CASE WHEN LENGTH(c.telefone_obra) < 11 THEN MASK(LPAD(c.telefone_obra,10,'0'), '(##) ####-####') ELSE MASK(LPAD(c.telefone_obra,11,'0'), '(##) #####-####') END AS telefone_obra, MASK(LPAD(c.tel_vend,11,'0'), '(##) #####-####') AS cel, MASK(LPAD(c.tel_vend,11,'0'), '(##) #####-####') AS tel_vend, MASK(LPAD(c.cep_obra,8,'0'), '#####-###') AS cep, DATE_FORMAT(c.data, '%d/%m/%Y') AS data, DATE_FORMAT(c.data_ult_rev, '%d/%m/%Y') AS data_ult_rev, c.endereco_obra AS rua, c.numero_obra, c.municipio_obra AS municipio, c.uf_obra AS uf, (select sum(i.m2) from gre_item_orcamento i where i.orca_id = c.orca_id and i.num_revisao = c.num_revisao and i.empr_id = c.empr_id) m2, stat.nome AS nome_stat, cr.cor AS cor_cr FROM gre_cab_orcamento c INNER JOIN gre_status stat ON stat.id = c.status_id INNER JOIN adms_cors cr ON cr.id = stat.cor_id LEFT JOIN gre_arquitetos a ON a.id = c.arquiteto_id LEFT JOIN ( SELECT orca_id, empr_id, MAX(num_revisao) AS max_rev FROM gre_cab_orcamento GROUP BY orca_id, empr_id ) AS max_orc ON max_orc.orca_id = c.orca_id AND max_orc.empr_id = c.empr_id LEFT JOIN ( SELECT orca_id, empr_id, MAX(status_id) AS max_status_id FROM gre_cab_orcamento WHERE status_id < 88 GROUP BY orca_id, empr_id ) AS max_stat ON max_stat.orca_id = c.orca_id AND max_stat.empr_id = c.empr_id WHERE c.orca_id = :orca_id_main AND c.num_revisao = :num_rev_main AND c.empr_id = :empr_id_main and c.status_id < 88 [2026-06-26 13:23:50] PARAMS: [2026-06-26 13:23:50] Array ( [:orca_id_main] => 2 [:num_rev_main] => 0 [:empr_id_main] => 1 ) [2026-06-26 13:23:50] RESULTADO DADOS: Array ( [0] => Array ( [empr_id] => 1 [orca_id] => 2 [num_revisao] => 0 [data] => [data_ult_rev] => [cliente_id] => 14 [nome_cliente] => Adriana Fuga [vend] => 3 [obra_id] => 2 [obra] => CM Informática Ltda [tel_vend] => (11) 99622-5252 [contato_obra] => Silvio Silveira [email_vend] => crmarques1402@gmail.com [telefone_obra] => (11) 3882-8299 [orcamentista_id] => 4 [orcamentista] => Bruno [email_obra] => crmarques1402@gmail.com [arquiteto_id] => 2 [arquiteto] => Silvio Silveira [rt] => 10.00 [cep_obra] => 4612080 [endereco_obra] => Rua Félix de Sousa [numero_obra] => 200 [complemento] => Cj 127 [bairro] => Vila Congonhas [municipio_obra] => São Paulo [uf_obra] => SP [obs_obra] => [cep_cobra] => [endereco_cobra] => [numero_cobra] => [complemento_cobra] => [bairro_cobra] => [municipio_cobra] => [uf_cobra] => [municipio_id_cobra] => [celular_cobra] => [vlr_base_total] => 9844.78 [vlr_semdesc] => 9844.78 [vlr_frete] => 108.30 [vlr_desc] => [perc_sp] => [perc_desc_sp] => 8.00 [vlr_sp] => 0.00 [vlr_insumo] => 718.27 [vlr_total] => 15453.43 [vlr_dife_revisao] => -3159.55 [perc_comis] => 3.00 [vlr_comis] => 350.22 [forma_pgto] => 35,00% de Entrada mais 4 Parcelas [num_ped] => 1 [tipo_pgto_entrada] => 2 [tipo_pgto_parcela] => 1 [perc_entrada] => 35.00 [valor_entrada] => 2688.05 [num_parcelas] => 4 [valor_parcela] => 1248.02 [data_parcela] => 2026-06-10 [ult_contra_entrega] => 1 [distancia] => 19 [chave] => [data_envio_aceite] => 2026-06-22 12:08:15 [email_envio_aceite] => crmarques@uol.com.br [data_retorno_aceite] => 2026-06-22 12:11:32 [retorno_aceite] => S [num_contrato] => 1219 [data_contrato] => 2026-06-02 13:35:48 [data_email_contrato] => 2026-06-22 12:15:21 [data_agenda_medicao] => [data_limite_medicao] => 2026-06-10 [data_medicao] => [data_limite_liberar] => [medidor_id] => [dias_entrega] => 35 [status_id] => 23 [status_real] => 7 [created] => 2026-06-02 12:05:18 [usu_created] => 1 [modified] => 2026-06-22 12:45:50 [usu_modified] => 0 [max_rev] => 0 [max_status_id] => 23 [ajuste] => 100.00 [cel] => (11) 99622-5252 [cep] => 04612-080 [rua] => Rua Félix de Sousa [municipio] => São Paulo [uf] => SP [m2] => 7.79 [nome_stat] => Confirmar Revisão [cor_cr] => warning ) ) [2026-06-26 13:23:50] ITENS: Array ( [0] => Array ( [id] => 4 [empr_id] => 1 [item] => 4 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.80 [prof] => 0.60 [alt_fron_esq] => 0.00 [larg_fron_esq] => 0.00 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.00 [larg_fron_fun] => 0.00 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.15 [larg_saia_esq] => 0.60 [alt_saia_dir] => 0.15 [larg_saia_dir] => 0.60 [alt_saia_fun] => 0.00 [larg_saia_fun] => 1.80 [alt_saia_fren] => 0.15 [larg_saia_fren] => 1.80 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => [acabFun] => 1 [fronDir] => [fronEsq] => [fronFren] => [fronFun] => [saiaDir] => 1 [saiaEsq] => 1 [saiaFren] => 1 [saiaFun] => [acab_topo_frontao] => [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => 1 [servico] => [qtde_serv] => 0 [material_id] => 178 [material] => Ardósia Cinza Polido [benef_id] => 6 [vlr_unit_acab] => 125.00 [vlr_unit_mat] => 811.00 [vlr_unit_prod] => 180.00 [vlr_unit_serv] => 0.00 [ambiente_id] => 26 [descricao] => Banco medindo (1,80 x 0,60 m) - Saia Fren H: 0,15 - Saia Dir H: 0,15 - Saia Esq H: 0,15 - Acabamento Reto - Acabamento em 1/2 esquadria, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Banco medindo (1,80 x 0,60 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 0.00 [vlr_total_mat] => 1240.83 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 276.12 [vlr_total] => 7017.30 [base_total] => 1516.95 [m2] => 1.53 [ml] => 2.40 [produto] => 109 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:52:35 [usu_created] => 0 [modified] => 2026-06-22 12:44:27 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => 4 [vlr_dife_item] => 0.00 [vlr_total_ant] => 7017.30 [valorTotal] => 7017.30 [nome_ambiente] => Área Externa ) [1] => Array ( [id] => 5 [empr_id] => 1 [item] => 5 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.20 [prof] => 0.70 [alt_fron_esq] => 0.00 [larg_fron_esq] => 0.00 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.15 [larg_fron_fun] => 1.20 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.15 [larg_saia_esq] => 0.70 [alt_saia_dir] => 0.15 [larg_saia_dir] => 0.70 [alt_saia_fun] => 0.00 [larg_saia_fun] => 1.20 [alt_saia_fren] => 0.15 [larg_saia_fren] => 1.20 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => [acabFun] => [fronDir] => [fronEsq] => [fronFren] => [fronFun] => 1 [saiaDir] => 1 [saiaEsq] => 1 [saiaFren] => 1 [saiaFun] => [acab_topo_frontao] => 1 [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => [servico] => [qtde_serv] => 0 [material_id] => 767 [material] => Ascale Cosmopolita Gray Bruto [benef_id] => 14 [vlr_unit_acab] => 0.00 [vlr_unit_mat] => 4406.00 [vlr_unit_prod] => 127.30 [vlr_unit_serv] => 0.00 [ambiente_id] => 26 [descricao] => Aparador medindo (1,20 x 0,70 m) - Fron H: 0,15 - Saia Fren H: 0,15 - Saia Dir H: 0,15 - Saia Esq H: 0,15 - Acabamento em 1/2 esquadria - Acb. reto no Frontão, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Aparador medindo (1,20 x 0,70 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 829.78 [vlr_total_mat] => 6212.46 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 254.46 [vlr_total] => 7296.70 [base_total] => 7296.70 [m2] => 1.41 [ml] => 1.90 [produto] => 46 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:55:59 [usu_created] => 0 [modified] => 2026-06-22 12:45:50 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => 5 [vlr_dife_item] => -3159.55 [vlr_total_ant] => 10456.25 [valorTotal] => 7296.70 [nome_ambiente] => Área Externa ) [2] => Array ( [id] => 6 [empr_id] => 1 [item] => 6 [orca_id] => 2 [num_revisao] => 0 [larg] => 1.20 [prof] => 0.40 [alt_fron_esq] => 0.15 [larg_fron_esq] => 0.40 [alt_fron_dir] => 0.00 [larg_fron_dir] => 0.00 [alt_fron_fun] => 0.15 [larg_fron_fun] => 1.20 [alt_fron_fren] => 0.00 [larg_fron_fren] => 0.00 [alt_saia_esq] => 0.00 [larg_saia_esq] => 0.40 [alt_saia_dir] => 0.20 [larg_saia_dir] => 0.40 [alt_saia_fun] => 0.20 [larg_saia_fun] => 1.20 [alt_saia_fren] => 0.00 [larg_saia_fren] => 1.20 [tpo_duplo] => [em_curva] => 0 [polir_duplo] => 0 [acab_id] => [acabDir] => [acabEsq] => [acabFren] => 1 [acabFun] => [fronDir] => [fronEsq] => 1 [fronFren] => [fronFun] => 1 [saiaDir] => 1 [saiaEsq] => [saiaFren] => [saiaFun] => 1 [acab_topo_frontao] => 1 [esqua] => 1 [utiliza_insumo] => 1 [acabamento] => 1 [servico] => [qtde_serv] => 0 [material_id] => 178 [material] => Ardósia Cinza Polido [benef_id] => 6 [vlr_unit_acab] => 125.00 [vlr_unit_mat] => 811.00 [vlr_unit_prod] => 178.00 [vlr_unit_serv] => 0.00 [ambiente_id] => 6 [descricao] => Lavatório medindo (1,20 x 0,40 m) - Fron H: 0,15 - Saia Fun H: 0,20 - Saia Dir H: 0,20 - Acabamento Reto - Acabamento em 1/2 esquadria - Acb. reto no Frontão, com colocação, mais insumo [id_tabela] => P1 [descricao_tabela] => Lavatório medindo (1,20 x 0,40 m) [qtde_pecas] => 1 [unid_prod] => ml [base_mo] => [base_mat] => [vlr_total_mo] => 0.00 [vlr_total_mat] => 843.44 [vlr_total_col] => [vlr_total_acab_fron] => [vlr_total_serv] => 0.00 [vlr_total_acab] => [vlr_insumo] => 187.69 [vlr_total] => 1031.13 [base_total] => 1031.13 [m2] => 1.04 [ml] => 1.60 [produto] => 68 [obra_id] => 0 [obra] => CM Informática Ltda [ajuste] => 0 [fornecedor_id] => [data_pedido] => [data_medicao] => [data_desenho] => [data_aprovacao] => [data_os] => [data_entrega] => [data_inicio] => [data_Fim] => [colocadorId] => [num_os] => 0 [observacao] => [created] => 2026-06-02 10:58:35 [usu_created] => 0 [modified] => 2026-06-09 17:59:30 [usu_modified] => 0 [num_Pedido] => 0 [percentual] => 0.00 [larg_aa] => [prof_aa] => [data_ult_rev] => [conj] => [status_id] => 0 [escolheu_rev] => [material_dife] => 0 [item_rev_id] => [vlr_dife_item] => [vlr_total_ant] => [valorTotal] => 1031.13 [nome_ambiente] => Banho 1 ) ) [2026-06-26 13:23:50] OBRAS: Array ( [0] => Array ( [codigo] => 1 [nome] => Carlos Roberto Marques ) [1] => Array ( [codigo] => 2 [nome] => CM Informática Ltda ) ) [2026-06-26 13:23:50] FINALIZADO COM SUCESSO