AND ( b.transaction_date >= '" + getDay(strDate,15) + "' AND b.transaction_date <= '" + strDate + "' )
LEFT JOIN customer_ledger c ON c.reference_number = a.reference_number
AND c.transaction_date = a.transaction_date
AND c.internal_id = a.internal_id AND (c.transaction_type = a.transaction_type) AND c.transaction_date >= '" + getDay(strDate, 30 + 15) + "'
AND c.transaction_date <= '" + getDay(strDate, 1 + 15) + "'