02/07/2020 20:07:34 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->derecho_usuarios MÉTODO->uf_sss_insert_derecho_usuario ERROR->Invalid query: ERROR: insert or update on table "sss_derechos_usuarios" violates foreign key constraint "fk_sss_dere_sss_permi_sss_perm"
DETAIL: Key (codemp, codusu, codsis, codintper)=(0001, ADMINISTRADOR , SSS, ) is not present in table "sss_permisos_internos".
Whole query: INSERT INTO sss_derechos_usuarios (codemp,codusu,codsis,nomven,visible,enabled,leer,incluir,cambiar, eliminar,imprimir,administrativo,anular,ejecutar,codintper) VALUES('0001','ADMINISTRADOR ','SSS','sigesp_sss_d_sistemas.php',0, 1,1,1,1,1,1, 0,1,1,'')
02/07/2020 20:08:13 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->derecho_usuarios MÉTODO->uf_sss_insert_derecho_usuario ERROR->Invalid query: ERROR: insert or update on table "sss_derechos_usuarios" violates foreign key constraint "fk_sss_dere_sss_permi_sss_perm"
DETAIL: Key (codemp, codusu, codsis, codintper)=(0001, ADMINISTRADOR , SSS, ) is not present in table "sss_permisos_internos".
Whole query: INSERT INTO sss_derechos_usuarios (codemp,codusu,codsis,nomven,visible,enabled,leer,incluir,cambiar, eliminar,imprimir,administrativo,anular,ejecutar,codintper) VALUES('0001','ADMINISTRADOR ','SSS','sigesp_sss_d_sistemas.php',0, 1,1,1,1,1,1, 0,1,1,'')
02/07/2020 20:10:08 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->derecho_usuarios MÉTODO->uf_sss_insert_derecho_usuario ERROR->Invalid query: ERROR: insert or update on table "sss_derechos_usuarios" violates foreign key constraint "fk_sss_dere_sss_permi_sss_perm"
DETAIL: Key (codemp, codusu, codsis, codintper)=(0001, ADMINISTRADOR , SSS, ) is not present in table "sss_permisos_internos".
Whole query: INSERT INTO sss_derechos_usuarios (codemp,codusu,codsis,nomven,visible,enabled,leer,incluir,cambiar, eliminar,imprimir,administrativo,anular,ejecutar,codintper) VALUES('0001','ADMINISTRADOR ','SSS','sigesp_sss_d_sistemas.php',0, 1,1,1,1,1,1, 0,1,1,'')
02/07/2020 23:15:59 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR: invalid input syntax for type double precision: "900,00"
LINE 117: ...020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00' ...
^
Whole query: SELECT doc.*,f.*, c.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago,
descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,
tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,c.sc_cuenta as scg_cliente,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
) AS total_cre,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
) AS total_deb,
(
f.total
-
( SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS total_act,
(
f.subtot
-
( SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS subtot_act,
(
f.iva
-
( SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS iva_act,
(
doc.total_doc
-
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
)
) AS saldo_credito,
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
) AS total_aplicado
,0 AS saldoapl FROM cxc_documento doc
INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest
LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
WHERE doc.codemp = '0001'
AND doc.descripdoc ILIKE('%%')
AND doc.fecdoc BETWEEN '2020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00'
ORDER BY doc.numdoc
02/07/2020 23:17:25 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR: invalid input syntax for type double precision: "900,00"
LINE 117: ...020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00' ...
^
Whole query: SELECT doc.*,f.*, c.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago,
descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,
tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,c.sc_cuenta as scg_cliente,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
) AS total_cre,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
) AS total_deb,
(
f.total
-
( SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS total_act,
(
f.subtot
-
( SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS subtot_act,
(
f.iva
-
( SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS iva_act,
(
doc.total_doc
-
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
)
) AS saldo_credito,
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
) AS total_aplicado
,0 AS saldoapl FROM cxc_documento doc
INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest
LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
WHERE doc.codemp = '0001'
AND doc.descripdoc ILIKE('%%')
AND doc.fecdoc BETWEEN '2020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00'
ORDER BY doc.numdoc
02/07/2020 23:18:32 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR: invalid input syntax for type double precision: "900,00"
LINE 117: ...020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00' ...
^
Whole query: SELECT doc.*,f.*, c.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago,
descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,
tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,c.sc_cuenta as scg_cliente,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
) AS total_cre,
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
) AS total_deb,
(
f.total
-
( SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.total_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS total_act,
(
f.subtot
-
( SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.subtot_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS subtot_act,
(
f.iva
-
( SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'NC'
AND anulado_doc = '0'
)
+
(
SELECT COALESCE(SUM(doc.iva_doc),0)
FROM cxc_documento doc
WHERE doc.id_fact = f.id_fact
AND codtipdoc = 'ND'
AND anulado_doc = '0'
)
) AS iva_act,
(
doc.total_doc
-
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
)
) AS saldo_credito,
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
) AS total_aplicado
,0 AS saldoapl FROM cxc_documento doc
INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest
LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
WHERE doc.codemp = '0001'
AND doc.descripdoc ILIKE('%%')
AND doc.fecdoc BETWEEN '2020-01-01' AND '2020-07-02' AND doc.total_doc < '900,00'
ORDER BY doc.numdoc