initial commit 2

1 files changed, 106 insertions, 0 deletions

diff --git a/addons/membership/report/report_membership.py b/addons/membership/report/report_membership.py
new file mode 100644
index 00000000..bab4b67a
--- /dev/null
+++ b/addons/membership/report/report_membership.py
@@ -0,0 +1,106 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import api, fields, models, tools
+
+STATE = [
+    ('none', 'Non Member'),
+    ('canceled', 'Cancelled Member'),
+    ('old', 'Old Member'),
+    ('waiting', 'Waiting Member'),
+    ('invoiced', 'Invoiced Member'),
+    ('free', 'Free Member'),
+    ('paid', 'Paid Member'),
+]
+
+
+class ReportMembership(models.Model):
+    '''Membership Analysis'''
+
+    _name = 'report.membership'
+    _description = 'Membership Analysis'
+    _auto = False
+    _rec_name = 'start_date'
+
+    start_date = fields.Date(string='Start Date', readonly=True)
+    date_to = fields.Date(string='End Date', readonly=True, help="End membership date")
+    num_waiting = fields.Integer(string='# Waiting', readonly=True)
+    num_invoiced = fields.Integer(string='# Invoiced', readonly=True)
+    num_paid = fields.Integer(string='# Paid', readonly=True)
+    tot_pending = fields.Float(string='Pending Amount', digits=0, readonly=True)
+    tot_earned = fields.Float(string='Earned Amount', digits=0, readonly=True)
+    partner_id = fields.Many2one('res.partner', string='Member', readonly=True)
+    associate_member_id = fields.Many2one('res.partner', string='Associate Member', readonly=True)
+    membership_id = fields.Many2one('product.product', string='Membership Product', readonly=True)
+    membership_state = fields.Selection(STATE, string='Current Membership State', readonly=True)
+    user_id = fields.Many2one('res.users', string='Salesperson', readonly=True)
+    company_id = fields.Many2one('res.company', string='Company', readonly=True)
+    quantity = fields.Integer(readonly=True)
+
+    def init(self):
+        '''Create the view'''
+        tools.drop_view_if_exists(self._cr, self._table)
+        self._cr.execute("""
+        CREATE OR REPLACE VIEW %s AS (
+        SELECT
+        MIN(id) AS id,
+        partner_id,
+        count(membership_id) as quantity,
+        user_id,
+        membership_state,
+        associate_member_id,
+        membership_amount,
+        date_to,
+        start_date,
+        COUNT(num_waiting) AS num_waiting,
+        COUNT(num_invoiced) AS num_invoiced,
+        COUNT(num_paid) AS num_paid,
+        SUM(tot_pending) AS tot_pending,
+        SUM(tot_earned) AS tot_earned,
+        membership_id,
+        company_id
+        FROM
+        (SELECT
+            MIN(p.id) AS id,
+            p.id AS partner_id,
+            p.user_id AS user_id,
+            p.membership_state AS membership_state,
+            p.associate_member AS associate_member_id,
+            p.membership_amount AS membership_amount,
+            p.membership_stop AS date_to,
+            p.membership_start AS start_date,
+            CASE WHEN ml.state = 'waiting'  THEN ml.id END AS num_waiting,
+            CASE WHEN ml.state = 'invoiced' THEN ml.id END AS num_invoiced,
+            CASE WHEN ml.state = 'paid'     THEN ml.id END AS num_paid,
+            CASE WHEN ml.state IN ('waiting', 'invoiced') THEN SUM(aml.price_subtotal) ELSE 0 END AS tot_pending,
+            CASE WHEN ml.state = 'paid' OR p.membership_state = 'old' THEN SUM(aml.price_subtotal) ELSE 0 END AS tot_earned,
+            ml.membership_id AS membership_id,
+            p.company_id AS company_id
+            FROM res_partner p
+            LEFT JOIN membership_membership_line ml ON (ml.partner = p.id)
+            LEFT JOIN account_move_line aml ON (ml.account_invoice_line = aml.id)
+            LEFT JOIN account_move am ON (aml.move_id = am.id)
+            WHERE p.membership_state != 'none' and p.active = 'true'
+            GROUP BY
+              p.id,
+              p.user_id,
+              p.membership_state,
+              p.associate_member,
+              p.membership_amount,
+              p.membership_start,
+              ml.membership_id,
+              p.company_id,
+              ml.state,
+              ml.id
+        ) AS foo
+        GROUP BY
+            start_date,
+            date_to,
+            partner_id,
+            user_id,
+            membership_id,
+            company_id,
+            membership_state,
+            associate_member_id,
+            membership_amount
+        )""" % (self._table,))