action en masse suite à coche des contrats dans la liste : erreur SQL
http://localhost/dlb7/htdocs/custom/extendedcontract/invoicescontractlist.php
Sélection d'un seul contrat et lancement de la facturation.
Type gestionnaire de base de données: mysqli Requête dernier accès en base en erreur: SELECT c.rowid, c.ref, c.datec as date_creation, c.tms as date_update, c.date_contrat, c.statut, c.ref_customer, c.ref_supplier, c.note_private, c.note_public, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, IF(COUNT(cd.rowid) > 0,CAST(SUM(IF(cd.statut=0,1,0)) * COUNT(DISTINCT cd.rowid) / COUNT(cd.rowid) AS SIGNED),0) as nb_initial, IF(COUNT(cd.rowid) > 0,CAST(SUM(IF(cd.statut=4 AND (cd.date_fin_validite IS NULL OR cd.date_fin_validite >= '2019-10-18 11:22:53'),1,0)) * COUNT(DISTINCT cd.rowid) / COUNT(cd.rowid) AS SIGNED),0) as nb_running, IF(COUNT(cd.rowid) > 0,CAST(SUM(IF(cd.statut=4 AND (cd.date_fin_validite IS NOT NULL AND cd.date_fin_validite < '2019-10-18 11:22:53'),1,0)) * COUNT(DISTINCT cd.rowid) / COUNT(cd.rowid) AS SIGNED),0) as nb_expired, IF(COUNT(cd.rowid) > 0,CAST(SUM(IF(cd.statut=4 AND (cd.date_fin_validite IS NOT NULL AND cd.date_fin_validite < '2019-10-18 11:22:53'),1,0)) * COUNT(DISTINCT cd.rowid) / COUNT(cd.rowid) AS SIGNED),0) as nb_late, IF(COUNT(cd.rowid) > 0,CAST(SUM(IF(cd.statut=5,1,0)) * COUNT(DISTINCT cd.rowid) / COUNT(cd.rowid) AS SIGNED),0) as nb_closed,ef.ec_initial_amount as options_ec_initial_amount,ef.ec_amount as options_ec_amount,ef.ec_initial_value_installation as options_ec_initial_value_installation,ef.ec_current_value_installation as options_ec_current_value_installation,ef.ec_signature_date as options_ec_signature_date,ef.ec_effective_date as options_ec_effective_date,ef.ec_duration_months as options_ec_duration_months,ef.ec_tacit_renewal as options_ec_tacit_renewal,ef.ec_termination_period_months as options_ec_termination_period_months,ef.ec_des_term_date as options_ec_des_term_date,ef.ec_eff_term_date as options_ec_eff_term_date,ef.ec_billing_due as options_ec_billing_due,ef.ec_billing_begin_period as options_ec_billing_begin_period,ef.ec_billing_frequency as options_ec_billing_frequency,ef.ec_payment_condition as options_ec_payment_condition,ef.ec_payment_mode as options_ec_payment_mode,ef.ec_account as options_ec_account,ef.ec_revaluation_index as options_ec_revaluation_index,ef.ec_enable_to_revaluation_date as options_ec_enable_to_revaluation_date,ef.ec_revaluation_date as options_ec_revaluation_date,ef.ec_month_for_new_revaluation_index as options_ec_month_for_new_revaluation_index,ef.ec_initial_revaluation_index_used as options_ec_initial_revaluation_index_used,ef.ec_last_revaluation_index_used as options_ec_last_revaluation_index_used,ef.ec_revaluation_calculation_base as options_ec_revaluation_calculation_base,ef.ec_fixed_amount_not_revaluable as options_ec_fixed_amount_not_revaluable,ef.ec_unauthorized_deflation as options_ec_unauthorized_deflation FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_contrat as c LEFT JOIN ( SELECT ee.fk_source AS contract_id, f.facnumber AS invoice_ref, f.total AS invoice_total_ht, f.tva AS invoice_total_vat, f.total_ttc as invoice_total_ttc FROM llx_facture AS f LEFT JOIN llx_element_element AS ee ON ee.sourcetype = 'contrat' AND ee.fk_target = f.rowid AND ee.targettype = 'facture' WHERE f.fk_statut = 0 ) as ci ON (ci.contract_id = c.rowid) LEFT JOIN llx_contrat_extrafields as ef on (c.rowid = ef.fk_object) LEFT JOIN llx_contratdet as cd ON c.rowid = cd.fk_contrat WHERE c.fk_soc = s.rowid AND c.entity IN (1) AND cd.statut = 4 AND () AND () AND () GROUP BY c.rowid,ef.ec_initial_amount,ef.ec_amount,ef.ec_initial_value_installation,ef.ec_current_value_installation,ef.ec_signature_date,ef.ec_effective_date,ef.ec_duration_months,ef.ec_tacit_renewal,ef.ec_termination_period_months,ef.ec_des_term_date,ef.ec_eff_term_date,ef.ec_billing_due,ef.ec_billing_begin_period,ef.ec_billing_frequency,ef.ec_payment_condition,ef.ec_payment_mode,ef.ec_account,ef.ec_revaluation_index,ef.ec_enable_to_revaluation_date,ef.ec_revaluation_date,ef.ec_month_for_new_revaluation_index,ef.ec_initial_revaluation_index_used,ef.ec_last_revaluation_index_used,ef.ec_revaluation_calculation_base,ef.ec_fixed_amount_not_revaluable,ef.ec_unauthorized_deflation ORDER BY c.ref DESC LIMIT 26 Code retour dernier accès en base en erreur: DB_ERROR_SYNTAX Information sur le dernier accès en base en erreur: Erreur de syntaxe près de ') AND () AND () GROUP BY c.rowid,ef.ec_initial_amount,ef.ec_amount,ef.ec_initial' à la ligne 1