News arrow Forum
Home    Contacts
Forum Dolibarr
Welcome, Guest
Please Login or Register.    Lost Password?
Re:commande fournisseur (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:commande fournisseur
#9662
sladame (User)
Expert Boarder
Posts: 117
graphgraph
User Offline Click here to see the profile of this user
Gender: Male mon site (joomla) Location: lyon Birthdate: 1984-05-13
commande fournisseur 2008/08/06 09:27 Karma: 1  
bonjour,
j'ai un petit problème:
-je créé un fournisseur => ok
-je créé un produit => ok
-j'ajoute un prix fournisseur => ok

et la au moment de créer la commande fournisseur il y a un problème aucun produit dans la liste des produits fournisseur. j'oublie quelque chose ou il y a un bug ?


Code:
2008-08-06 09:16:30 INFO 192.168.1.181 ??? Session name=DOLSESSID_dolibarr Session id()=9sdct9upt04lcj54cvemn36d46, _SESSION['dol_login']=sladame 2008-08-06 09:16:30 DEBUG 192.168.1.181 ??? User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, 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, unix_timestamp(u.datec) as datec, unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u WHERE u.login = 'sladame' 2008-08-06 09:16:30 INFO 192.168.1.181 sladame This is an already logged session. _SESSION['dol_login']=sladame 2008-08-06 09:16:30 INFO 192.168.1.181 sladame Access to /fourn/commande/fiche.php 2008-08-06 09:16:30 DEBUG 192.168.1.181 sladame 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 ur.fk_user= 1 AND r.perms IS NOT NULL 2008-08-06 09:16:31 DEBUG 192.168.1.181 sladame 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 2008-08-06 09:16:31 DEBUG 192.168.1.181 sladame BEGIN Transaction 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Fournisseur::Create_Commande 2008-08-06 09:16:31 INFO 192.168.1.181 sladame CommandeFournisseur::Create soc id=3009 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Interfaces::run_triggers Triggers for file 'interface_modLdap_Ldapsynchro.class.php' need module to be enabled 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Interfaces::run_triggers Triggers for file 'interface_modPhenix_Phenixsynchro.class.php' need module to be enabled 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Interfaces::run_triggers Triggers for file 'interface_modNotification_Notification.class.php' need module to be enabled 2008-08-06 09:16:31 INFO 192.168.1.181 sladame CommandeFournisseur::Create : Success 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Fournisseur::Create_Commande : Success 2008-08-06 09:16:31 DEBUG 192.168.1.181 sladame COMMIT Transaction 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url, m.langs, m.perms, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.type = 'top' AND m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position 2008-08-06 09:16:31 INFO 192.168.1.181 sladame Menubase::menuLeftCharger sql=SELECT m.rowid, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.target, m.mainmenu, m.leftmenu, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position, m.rowid 2008-08-06 09:16:31 DEBUG 192.168.1.181 sladame CommandeFournisseur::fetch sql=SELECT c.rowid, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva, unix_timestamp(c.date_commande) as date_commande, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_methode_commande, c.note, c.note_public, c.model_pdf, cm.libelle as methode_commande FROM llx_commande_fournisseur as c LEFT JOIN llx_c_methode_commande_fournisseur as cm ON cm.rowid = c.fk_methode_commande WHERE c.rowid = 17 2008-08-06 09:16:31 DEBUG 192.168.1.181 sladame User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, 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, unix_timestamp(u.datec) as datec, unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u WHERE u.rowid = 1 2008-08-06 09:16:32 INFO 192.168.1.181 sladame get_default_tva vendeur_assujeti=reel pays_vendeur=FR, seller in cee=1, pays_acheteur=FR, buyer in cee=1, taux_produit(deprecated)=, idprod=0 2008-08-06 09:16:32 DEBUG 192.168.1.181 sladame Form::select_produits_fournisseurs_do sql=SELECT p.rowid, p.label, p.ref, p.price, p.duration, pf.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.quantity, pfp.unitprice, s.nom FROM llx_product as p LEFT JOIN llx_product_fournisseur as pf ON p.rowid = pf.fk_product LEFT JOIN llx_societe as s ON pf.fk_soc = s.rowid LEFT JOIN llx_product_fournisseur_price as pfp ON pf.rowid = pfp.fk_product_fournisseur WHERE p.envente = 1 AND pf.fk_soc = 3009 AND p.fk_product_type=2 ORDER BY pf.ref_fourn DESC 2008-08-06 09:16:32 INFO 192.168.1.181 sladame files.lib.php::dol_dir_list /var/www/html/dolibarr/documents/fournisseur/commande/(PROV17)
peut être un problème avec fk_product_type ... dans la base de donnée 0 ou 1 et la requete sql : p.fk_product_type=2
 
Logged Logged  
 
Last Edit: 2008/08/06 09:41 By sladame.
 
  The administrator has disabled public write access.
#9668
eldy (Admin)
Admin
Posts: 1681
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Site web personnel eldy10 ldestailleur@hotmail.com Location: Montigny-le-Bretonneux (St-Quentin en Yvelines) Birthdate: 1972-10-10
Re:commande fournisseur 2008/08/06 15:06 Karma: 40  
Exact.
Corrigé en CVS.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop