Try to run this requests :
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 1, 'AC_TEL', 'system', 'Phone call'
,NULL, 2);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 2, 'AC_FAX', 'system', 'Send Fax'
,NULL, 3);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 3, 'AC_PROP', 'system', 'Send commercial
proposal by email' ,'propal', 10);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 4, 'AC_EMAIL', 'system', 'Send Email'
,NULL, 4);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 5, 'AC_RDV', 'system', 'Rendez-vous'
,NULL, 1);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 8, 'AC_COM', 'system', 'Send customer order
by email' ,'order', 8);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 9, 'AC_FAC', 'system', 'Send customer
invoice by email' ,'invoice', 6);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 10, 'AC_SHIP', 'system', 'Send shipping by
email' ,'shipping', 11);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 30, 'AC_SUP_ORD', 'system', 'Send supplier order
by email' ,'order_supplier', 9);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values (31, 'AC_SUP_INV', 'system', 'Send supplier
invoice by email' ,'invoice_supplier', 7);
insert into llx_c_actioncomm (id, code, type, libelle, module,
position) values ( 50, 'AC_OTH', 'system', 'Other'
,NULL, 5);
Le 25/10/2011 10:09, [ATNObUG] a écrit :
Bonjour Régis,
Dans Dictionnaires - Liste des types d'événements de l'agenda,
j'ai uniquement ceci :
AC_CLO Clôture system 0 Toujours actif
AC_SHIP Envoi bon d'expédition par mail system 11
Toujours actif
Sinon ta réponse est tronquée, je suppose qu'il faut décocher
"BILL_VALIDATE Validation facture client" dans la configuration de
l'agenda ?
--
[ATNObUG]
1 Rue des Écoles 59780 Willems
Tél / Fax : 03 20 61 44 35
http://www.atnobug.fr
En application de l'article 22 de la loi du 21 juin 2004
pour la confiance dans l’économie numérique, l'adresse
mail address@hidden
ou les coordonnées téléphoniques ne peuvent être utilisées
à des fins publicitaires ou de prospection.
De même, nous nous opposons à toute collecte de ces
coordonnées.
La précédente mention acte le refus de consentement
préalable à toute prospection quelque soit le vecteur :
télécopie, automate d’appel, courrier électronique ou
autre dispositif électronique et sans limitation.
|
Le mardi 25 octobre 2011 à 01:53 +0200, Laurent Destailleur (eldy)
a écrit :
Vérifie dans accueil - config - dictionnaire - type d'evennement
agenda, que tu as une ligne avec pour code "AC_OTH"
Va dans la config du module agenda, est décoche la casLe
24/10/2011 12:09, [ATNObUG] a écrit :
Bonjour Régis,
En effet, en désactivant le module Agenda,cela fonctionne à
nouveau mais en le réactivant le module,
la validation ne fonctionne plus.
--
[ATNObUG]
1 Rue des Écoles 59780 Willems
Tél / Fax : 03 20 61 44 35
http://www.atnobug.fr
En application de l'article 22 de la loi du 21 juin
2004 pour la confiance dans l’économie numérique,
l'adresse mail address@hidden
ou les coordonnées téléphoniques ne peuvent être
utilisées à des fins publicitaires ou de prospection.
De même, nous nous opposons à toute collecte de ces
coordonnées.
La précédente mention acte le refus de consentement
préalable à toute prospection quelque soit le vecteur
: télécopie, automate d’appel, courrier électronique
ou autre dispositif électronique et sans limitation.
|
Le lundi 24 octobre 2011 à 11:51 +0200, Régis Houssin a
écrit :
Bonjour
essai en désactivant le module agenda
puis essai à nouveau en le réactivant
Le 24/10/11 11:46, [ATNObUG] a écrit :
Bonjour à tous,
Suite à la migration vers la version Debian/Ubuntu de
Dolibarr 3.0 vers 3.1 avec dolibarr_3.1.0-1.1_all.deb,
la validation de facture ne fonctionne pas.
J'ai essayé à partir d'un poste Windows, Linux avec
Firefox, IE etc mais en aucun cas la facture est validée
et reste en provisoire.
Dolibarr est installé sur un Debian Squeeze 2.6.32-5-amd64
#1 SMP Mon Oct 3 05:45:56 UTC 2011 x86_64 avec
Apache/2.2.16 (Debian), Php 5.3.3-7+squeeze3 et MySQL
5.1.49
voici la partie du log de dolibarr concernée (j'ai
remplacé le login par xxxxxxxxxxx):
2011-10-24 11:24:51 INFO 10.1.1.1 nologin facture
This is an already logged session.
_SESSION['dol_login']=xxxxxxxxxx
2011-10-24 11:24:51 DEBUG 10.1.1.1 nologin facture
User::Fetch sql=SELECT u.rowid, u.name, u.firstname,
u.email, u.signature, u.office_phone, u.office_fax,
u.user_mobile, u.admin, u.login, u.webcal_login,
u.phenix_login, u.phenix_pass, u.note, u.pass,
u.pass_crypted, u.pass_temp, u.fk_societe, u.fk_socpeople,
u.fk_member, u.ldap_sid, u.statut, u.lang, u.entity,
u.datec as datec, u.tms as datem, u.datelastlogin as
datel, u.datepreviouslogin as datep, u.photo as photo,
u.openid as openid FROM llx_user as u WHERE u.entity IN
(0,1) AND u.login = 'xxxxxxxxxx'
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::getRights sql=SELECT r.module, r.perms,
r.subperms FROM llx_user_rights as ur, llx_rights_def as r
WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.fk_user= 1
AND r.perms IS NOT NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::getRights sql=SELECT r.module, r.perms,
r.subperms FROM llx_usergroup_rights as gr,
llx_usergroup_user as gu, llx_rights_def as r WHERE r.id =
gr.fk_id AND gr.fk_usergroup = gu.fk_usergroup AND
gu.fk_user = 1 AND r.perms IS NOT NULL AND r.entity = 1
AND gu.entity IN (0,1)
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture --- Access to /dolibarr/compta/facture.php
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::Fetch sql=SELECT
f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva,
f.localtax1, f.localtax2,
f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,
f.datef as df, f.date_lim_reglement as dlr, f.datec as
datec, f.date_valid as datev, f.tms as datem, f.note,
f.note_public, f.fk_statut, f.paye, f.close_code,
f.close_note, f.fk_user_author, f.fk_user_valid,
f.model_pdf, f.fk_facture_source, f.fk_mode_reglement,
f.fk_cond_reglement, f.fk_projet, p.code as
mode_reglement_code, p.libelle as mode_reglement_libelle,
c.code as cond_reglement_code, c.libelle as
cond_reglement_libelle, c.libelle_facture as
cond_reglement_libelle_doc, el.fk_source FROM llx_facture
as f LEFT JOIN llx_c_payment_term as c ON
f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as
p ON f.fk_mode_reglement = p.id LEFT JOIN
llx_element_element as el ON el.fk_target = f.rowid AND
el.targettype = 'facture' WHERE f.entity = 1 AND
f.rowid=204
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::fetch_lines sql=SELECT l.rowid,
l.fk_product, l.fk_parent_line, l.description,
l.product_type, l.price, l.qty, l.tva_tx, l.localtax1_tx,
l.localtax2_tx, l.remise, l.remise_percent,
l.fk_remise_except, l.subprice, l.rang, l.special_code,
l.date_start as date_start, l.date_end as date_end,
l.info_bits, l.total_ht, l.total_tva, l.total_localtax1,
l.total_localtax2, l.total_ttc, l.fk_code_ventilation,
l.fk_export_compta, p.ref as product_ref,
p.fk_product_type as fk_product_type, p.label as label,
p.description as product_desc FROM llx_facturedet as l
LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE
l.fk_facture = 204 ORDER BY l.rang
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture Menubase::menuLeftCharger sql=SELECT m.rowid,
m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms,
m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu
as m WHERE m.entity = 1 AND m.menu_handler
in('eldy','all') AND m.usertype in (0,2) ORDER BY
m.position, m.rowid
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture Menubase::menuLeftCharger sql=SELECT m.rowid,
m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms,
m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu
as m WHERE m.entity = 1 AND m.menu_handler
in('eldy','all') AND m.usertype in (0,2) ORDER BY
m.position, m.rowid
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::Fetch sql=SELECT
f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva,
f.localtax1, f.localtax2,
f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,
f.datef as df, f.date_lim_reglement as dlr, f.datec as
datec, f.date_valid as datev, f.tms as datem, f.note,
f.note_public, f.fk_statut, f.paye, f.close_code,
f.close_note, f.fk_user_author, f.fk_user_valid,
f.model_pdf, f.fk_facture_source, f.fk_mode_reglement,
f.fk_cond_reglement, f.fk_projet, p.code as
mode_reglement_code, p.libelle as mode_reglement_libelle,
c.code as cond_reglement_code, c.libelle as
cond_reglement_libelle, c.libelle_facture as
cond_reglement_libelle_doc, el.fk_source FROM llx_facture
as f LEFT JOIN llx_c_payment_term as c ON
f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as
p ON f.fk_mode_reglement = p.id LEFT JOIN
llx_element_element as el ON el.fk_target = f.rowid AND
el.targettype = 'facture' WHERE f.entity = 1 AND
f.rowid=204
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::fetch_lines sql=SELECT l.rowid,
l.fk_product, l.fk_parent_line, l.description,
l.product_type, l.price, l.qty, l.tva_tx, l.localtax1_tx,
l.localtax2_tx, l.remise, l.remise_percent,
l.fk_remise_except, l.subprice, l.rang, l.special_code,
l.date_start as date_start, l.date_end as date_end,
l.info_bits, l.total_ht, l.total_tva, l.total_localtax1,
l.total_localtax2, l.total_ttc, l.fk_code_ventilation,
l.fk_export_compta, p.ref as product_ref,
p.fk_product_type as fk_product_type, p.label as label,
p.description as product_desc FROM llx_facturedet as l
LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE
l.fk_facture = 204 ORDER BY l.rang
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::getSommePaiement sql=SELECT sum(amount)
as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getSumCreditNotesUsed sql=SELECT
sum(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc, llx_facture as f WHERE
rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND
f.type = 2
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getSumDepositsUsed sql=SELECT
sum(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc, llx_facture as f WHERE
rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND
f.type = 3
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getAvailableDiscounts sql=SELECT
SUM(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc WHERE (rc.fk_facture IS
NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 155
AND fk_facture_source IS NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getAvailableDiscounts sql=SELECT
SUM(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc WHERE (rc.fk_facture IS
NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 155
AND fk_facture_source IS NOT NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::Fetch sql=SELECT u.rowid, u.name,
u.firstname, u.email, u.signature, u.office_phone,
u.office_fax, u.user_mobile, u.admin, u.login,
u.webcal_login, u.phenix_login, u.phenix_pass, u.note,
u.pass, u.pass_crypted, u.pass_temp, u.fk_societe,
u.fk_socpeople, u.fk_member, u.ldap_sid, u.statut, u.lang,
u.entity, u.datec as datec, u.tms as datem,
u.datelastlogin as datel, u.datepreviouslogin as datep,
u.photo as photo, u.openid as openid FROM llx_user as u
WHERE u.entity IN (0,1) AND u.rowid = 2
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture mod_facture_terre::getNextValue sql=SELECT
MAX(SUBSTRING(facnumber FROM 8)) as max FROM llx_facture
WHERE facnumber LIKE 'FA____-%' AND entity = 1
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture mod_facture_terre::getNextValue return FA1110-0184
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::fetch sql=SELECT sr.rowid,
sr.fk_soc, sr.fk_user, sr.amount_ht, sr.amount_tva,
sr.amount_ttc, sr.tva_tx, sr.fk_facture_line,
sr.fk_facture, sr.fk_facture_source, sr.description,
sr.datec, f.facnumber as ref_facture_source FROM
llx_societe_remise_except as sr LEFT JOIN llx_facture as f
ON sr.fk_facture_source = f.rowid WHERE
sr.fk_facture_source=204
2011-10-24 11:24:51 DEBUG 10.1.1.1 xxxxxxxxxx
facture Form::load_cache_conditions_paiements sql=SELECT
rowid, code, libelle FROM llx_c_payment_term WHERE
active=1 ORDER BY sortorder
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture files.lib.php::dol_dir_list
path=/usr/share/dolibarr/documents/facture/(PROV204)
types=files recursive=0 filter= excludefilter=\.meta$
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture CommonObject::fetchObjectLink sql=SELECT
fk_source, sourcetype, fk_target, targettype FROM
llx_element_element WHERE (fk_source = '204' AND
sourcetype = 'facture') OR (fk_target = '204' AND
targettype = 'facture')
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture ActionComm::getActions sql=SELECT a.id FROM
llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element =
204 AND a.elementtype = 'invoice'
2011-10-24 11:24:51 INFO 10.1.1.1 xxxxxxxxxx
facture --- End access to /dolibarr/compta/facture.php
2011-10-24 11:24:53 INFO 10.1.1.1 nologin facture
This is an already logged session.
_SESSION['dol_login']=xxxxxxxxxx
2011-10-24 11:24:53 DEBUG 10.1.1.1 nologin facture
User::Fetch sql=SELECT u.rowid, u.name, u.firstname,
u.email, u.signature, u.office_phone, u.office_fax,
u.user_mobile, u.admin, u.login, u.webcal_login,
u.phenix_login, u.phenix_pass, u.note, u.pass,
u.pass_crypted, u.pass_temp, u.fk_societe, u.fk_socpeople,
u.fk_member, u.ldap_sid, u.statut, u.lang, u.entity,
u.datec as datec, u.tms as datem, u.datelastlogin as
datel, u.datepreviouslogin as datep, u.photo as photo,
u.openid as openid FROM llx_user as u WHERE u.entity IN
(0,1) AND u.login = 'xxxxxxxxxx'
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::getRights sql=SELECT r.module, r.perms,
r.subperms FROM llx_user_rights as ur, llx_rights_def as r
WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.fk_user= 1
AND r.perms IS NOT NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::getRights sql=SELECT r.module, r.perms,
r.subperms FROM llx_usergroup_rights as gr,
llx_usergroup_user as gu, llx_rights_def as r WHERE r.id =
gr.fk_id AND gr.fk_usergroup = gu.fk_usergroup AND
gu.fk_user = 1 AND r.perms IS NOT NULL AND r.entity = 1
AND gu.entity IN (0,1)
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture --- Access to /dolibarr/compta/facture.php
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::Fetch sql=SELECT
f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva,
f.localtax1, f.localtax2,
f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,
f.datef as df, f.date_lim_reglement as dlr, f.datec as
datec, f.date_valid as datev, f.tms as datem, f.note,
f.note_public, f.fk_statut, f.paye, f.close_code,
f.close_note, f.fk_user_author, f.fk_user_valid,
f.model_pdf, f.fk_facture_source, f.fk_mode_reglement,
f.fk_cond_reglement, f.fk_projet, p.code as
mode_reglement_code, p.libelle as mode_reglement_libelle,
c.code as cond_reglement_code, c.libelle as
cond_reglement_libelle, c.libelle_facture as
cond_reglement_libelle_doc, el.fk_source FROM llx_facture
as f LEFT JOIN llx_c_payment_term as c ON
f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as
p ON f.fk_mode_reglement = p.id LEFT JOIN
llx_element_element as el ON el.fk_target = f.rowid AND
el.targettype = 'facture' WHERE f.entity = 1 AND
f.rowid=204
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::fetch_lines sql=SELECT l.rowid,
l.fk_product, l.fk_parent_line, l.description,
l.product_type, l.price, l.qty, l.tva_tx, l.localtax1_tx,
l.localtax2_tx, l.remise, l.remise_percent,
l.fk_remise_except, l.subprice, l.rang, l.special_code,
l.date_start as date_start, l.date_end as date_end,
l.info_bits, l.total_ht, l.total_tva, l.total_localtax1,
l.total_localtax2, l.total_ttc, l.fk_code_ventilation,
l.fk_export_compta, p.ref as product_ref,
p.fk_product_type as fk_product_type, p.label as label,
p.description as product_desc FROM llx_facturedet as l
LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE
l.fk_facture = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture BEGIN Transaction
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::fetch_lines sql=SELECT l.rowid,
l.fk_product, l.fk_parent_line, l.description,
l.product_type, l.price, l.qty, l.tva_tx, l.localtax1_tx,
l.localtax2_tx, l.remise, l.remise_percent,
l.fk_remise_except, l.subprice, l.rang, l.special_code,
l.date_start as date_start, l.date_end as date_end,
l.info_bits, l.total_ht, l.total_tva, l.total_localtax1,
l.total_localtax2, l.total_ttc, l.fk_code_ventilation,
l.fk_export_compta, p.ref as product_ref,
p.fk_product_type as fk_product_type, p.label as label,
p.description as product_desc FROM llx_facturedet as l
LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE
l.fk_facture = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture mod_facture_terre::getNextValue sql=SELECT
MAX(SUBSTRING(facnumber FROM 8)) as max FROM llx_facture
WHERE facnumber LIKE 'FA____-%' AND entity = 1
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture mod_facture_terre::getNextValue return FA1110-0184
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture CommonObject::update_price sql=SELECT qty,
total_ht, total_tva as total_tva, total_localtax1 as
total_localtax1, total_localtax2 as total_localtax2,
total_ttc, tva_tx as vatrate FROM llx_facturedet WHERE
fk_facture = 204 AND product_type <> 9
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture CommonObject::update_price sql=UPDATE llx_facture
SET total='65', tva='0', localtax1='0', localtax2='0',
total_ttc='65' WHERE rowid = 204
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Facture::validate sql=UPDATE llx_facture SET
facnumber='FA1110-0184', fk_statut = 1, fk_user_valid = 1
WHERE rowid = 204
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Triggers for file
'interface_modPaypal_PaypalWorkflow.class.php' need module
to be enabled
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Triggers for file
'interface_modWorkflow_WorkflowManager.class.php' need
module to be enabled
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Launch triggers for file
'interface_modLdap_Ldapsynchro.class.php'
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Triggers for file
'interface_modNotification_Notification.class.php' need
module to be enabled
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Launch triggers for file
'interface_all_Logevents.class.php'
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Launch triggers for file
'interface_modAgenda_ActionsAuto.class.php'
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Trigger 'ActionsAuto' for action 'BILL_VALIDATE'
launched by
/usr/share/dolibarr/htdocs/includes/triggers/interface_modAgenda_ActionsAuto.class.php.
id=204
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:53 ERROR 10.1.1.1 xxxxxxxxxx
facture interface_modAgenda_ActionsAuto.class.php: Failed
to insert :
2011-10-24 11:24:53 ERROR 10.1.1.1 xxxxxxxxxx
facture Interfaces::run_triggers action=""
Files found: 6, Files launched: 3, Done: 0, Failed: 1
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture ROLLBACK Transaction
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Menubase::menuLeftCharger sql=SELECT m.rowid,
m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms,
m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu
as m WHERE m.entity = 1 AND m.menu_handler
in('eldy','all') AND m.usertype in (0,2) ORDER BY
m.position, m.rowid
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Menubase::menuLeftCharger sql=SELECT m.rowid,
m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms,
m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu
as m WHERE m.entity = 1 AND m.menu_handler
in('eldy','all') AND m.usertype in (0,2) ORDER BY
m.position, m.rowid
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::Fetch sql=SELECT
f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva,
f.localtax1, f.localtax2,
f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,
f.datef as df, f.date_lim_reglement as dlr, f.datec as
datec, f.date_valid as datev, f.tms as datem, f.note,
f.note_public, f.fk_statut, f.paye, f.close_code,
f.close_note, f.fk_user_author, f.fk_user_valid,
f.model_pdf, f.fk_facture_source, f.fk_mode_reglement,
f.fk_cond_reglement, f.fk_projet, p.code as
mode_reglement_code, p.libelle as mode_reglement_libelle,
c.code as cond_reglement_code, c.libelle as
cond_reglement_libelle, c.libelle_facture as
cond_reglement_libelle_doc, el.fk_source FROM llx_facture
as f LEFT JOIN llx_c_payment_term as c ON
f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as
p ON f.fk_mode_reglement = p.id LEFT JOIN
llx_element_element as el ON el.fk_target = f.rowid AND
el.targettype = 'facture' WHERE f.entity = 1 AND
f.rowid=204
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::fetch_lines sql=SELECT l.rowid,
l.fk_product, l.fk_parent_line, l.description,
l.product_type, l.price, l.qty, l.tva_tx, l.localtax1_tx,
l.localtax2_tx, l.remise, l.remise_percent,
l.fk_remise_except, l.subprice, l.rang, l.special_code,
l.date_start as date_start, l.date_end as date_end,
l.info_bits, l.total_ht, l.total_tva, l.total_localtax1,
l.total_localtax2, l.total_ttc, l.fk_code_ventilation,
l.fk_export_compta, p.ref as product_ref,
p.fk_product_type as fk_product_type, p.label as label,
p.description as product_desc FROM llx_facturedet as l
LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE
l.fk_facture = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture Societe::fetch SELECT s.rowid, s.nom as name,
s.entity, s.ref_ext, s.ref_int, s.address, s.datec as
datec, s.prefix_comm, s.status, s.price_level, s.tms as
date_update, s.tel, s.fax, s.email, s.url, s.cp as zip,
s.ville as town, s.note, s.client, s.fournisseur, s.siren,
s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code,
s.code_client, s.code_fournisseur, s.code_compta,
s.code_compta_fournisseur, s.parent, s.gencod,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client,
s.mode_reglement, s.cond_reglement, s.tva_assuj,
s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel,
s.default_lang, s.logo, s.import_key, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as
pays_code, p.libelle as pays, d.code_departement as
departement_code, d.nom as departement, st.libelle as
stcomm, te.code as typent_code FROM llx_societe as s LEFT
JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN
llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN
llx_c_forme_juridique as fj ON s.fk_forme_juridique =
fj.code LEFT JOIN llx_c_departements as d ON
s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON
s.fk_typent = te.id WHERE s.rowid = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::getSommePaiement sql=SELECT sum(amount)
as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getSumCreditNotesUsed sql=SELECT
sum(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc, llx_facture as f WHERE
rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND
f.type = 2
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getSumDepositsUsed sql=SELECT
sum(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc, llx_facture as f WHERE
rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND
f.type = 3
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getAvailableDiscounts sql=SELECT
SUM(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc WHERE (rc.fk_facture IS
NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 155
AND fk_facture_source IS NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::getAvailableDiscounts sql=SELECT
SUM(rc.amount_ttc) as amount FROM
llx_societe_remise_except as rc WHERE (rc.fk_facture IS
NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 155
AND fk_facture_source IS NOT NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture User::Fetch sql=SELECT u.rowid, u.name,
u.firstname, u.email, u.signature, u.office_phone,
u.office_fax, u.user_mobile, u.admin, u.login,
u.webcal_login, u.phenix_login, u.phenix_pass, u.note,
u.pass, u.pass_crypted, u.pass_temp, u.fk_societe,
u.fk_socpeople, u.fk_member, u.ldap_sid, u.statut, u.lang,
u.entity, u.datec as datec, u.tms as datem,
u.datelastlogin as datel, u.datepreviouslogin as datep,
u.photo as photo, u.openid as openid FROM llx_user as u
WHERE u.entity IN (0,1) AND u.rowid = 2
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture DiscountAbsolute::fetch sql=SELECT sr.rowid,
sr.fk_soc, sr.fk_user, sr.amount_ht, sr.amount_tva,
sr.amount_ttc, sr.tva_tx, sr.fk_facture_line,
sr.fk_facture, sr.fk_facture_source, sr.description,
sr.datec, f.facnumber as ref_facture_source FROM
llx_societe_remise_except as sr LEFT JOIN llx_facture as f
ON sr.fk_facture_source = f.rowid WHERE
sr.fk_facture_source=204
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Form::load_cache_conditions_paiements sql=SELECT
rowid, code, libelle FROM llx_c_payment_term WHERE
active=1 ORDER BY sortorder
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture DolEditor::DolEditor htmlname=dp_desc tool=
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture get_default_tva: seller use vat=0, seller
country=FR, seller in cee=1, buyer country=FR, buyer in
cee=1, idprod=0, SERVICE_ARE_ECOMMERCE_200238EC=
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Form::select_produits_do search product
sql=SELECT p.rowid, p.label, p.ref, p.fk_product_type,
p.price, p.price_ttc, p.price_base_type, p.duration,
p.stock FROM llx_product as p WHERE p.entity IN (0,1) AND
p.tosell = 1 ORDER BY p.ref LIMIT 100
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture DolEditor::DolEditor htmlname=np_desc tool=
2011-10-24 11:24:53 DEBUG 10.1.1.1 xxxxxxxxxx
facture Facture::getSommePaiement sql=SELECT sum(amount)
as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture files.lib.php::dol_dir_list
path=/usr/share/dolibarr/documents/facture/(PROV204)
types=files recursive=0 filter= excludefilter=\.meta$
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture CommonObject::fetchObjectLink sql=SELECT
fk_source, sourcetype, fk_target, targettype FROM
llx_element_element WHERE (fk_source = '204' AND
sourcetype = 'facture') OR (fk_target = '204' AND
targettype = 'facture')
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture ActionComm::getActions sql=SELECT a.id FROM
llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element =
204 AND a.elementtype = 'invoice'
2011-10-24 11:24:53 INFO 10.1.1.1 xxxxxxxxxx
facture --- End access to /dolibarr/compta/facture.php
Quelqu'un aurait-il une idée pour résoudre le problème ?
Merci d'avance
JY
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
Cordialement,
--
Régis Houssin
---------------------------------------------------------
Cap-Networks
30, quai de Verdun
71700 Tournus
FRANCE
VoIP: +33 1 83 62 40 03
GSM: +33 6 33 02 07 97
Web: http://www.cap-networks.com/
Email: address@hidden
Dolibarr developer: address@hidden
Web Portal: http://www.dolibarr.fr/
SaaS offers: http://www.dolibox.fr/
Shop: http://www.dolistore.com/
Development platform: https://doliforge.org/
---------------------------------------------------------
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
--
Eldy (Laurent Destailleur).
---------------------------------------------------------------
EMail: address@hidden
Web: http://www.destailleur.fr
Dolibarr (Project leader): http://www.dolibarr.org
To make a donation for Dolibarr project via Paypal: address@hidden
AWStats (Author) : http://awstats.sourceforge.net
To make a donation for AWStats project via Paypal: address@hidden
AWBot (Author) : http://awbot.sourceforge.net
CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
--
Eldy (Laurent Destailleur).
---------------------------------------------------------------
EMail: address@hidden
Web: http://www.destailleur.fr
Dolibarr (Project leader): http://www.dolibarr.org
To make a donation for Dolibarr project via Paypal: address@hidden
AWStats (Author) : http://awstats.sourceforge.net
To make a donation for AWStats project via Paypal: address@hidden
AWBot (Author) : http://awbot.sourceforge.net
CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
|