Comment modifier le script pour qu'il prenne en compte la variable $year, renseignée avant de lancer la visualisation
Dans ce script, il donne l'état des compte au 31/12/2010 !!!
Merci
SELECT account.id, DATE_FORMAT( balance_date.balance_date, '%d/%m/%Y' ) AS Date, debit, credit,
CASE
WHEN account_type.name IS NOT NULL AND account.category=2 THEN CONCAT(authentication.last_name, ' ', authentication.first_name)
END AS account_name
FROM balance
LEFT JOIN account ON (balance.account_id = account.id)
LEFT JOIN balance_date ON (balance_date.id = balance.balance_date_id)
LEFT JOIN account_type ON (account.account_type = account_type.id AND account.category IN(2,3))
LEFT JOIN authentication ON (account.owner_id = authentication.id AND account.category=2)
LEFT JOIN aircraft ON (account.owner_id = aircraft.id AND account.category=3)
WHERE balance_date_id IN (SELECT MA
balance_date.id) FROM balance_date)