~technofluid-team/openobject-addons/technofluid_multiple_installations

« back to all changes in this revision

Viewing changes to crm/crm_operators.py

• browse files at revision 1
• compare with another revision
• download diff
• download tarball
• view history from revision 1

Show diffs side-by-side

added

removed

crm/crm_operators.py

 

1

##############################################################################

 

2

#

 

3

# Copyright (c) 2004 TINY SPRL. (http://tiny.be) All Rights Reserved.

 

4

#                    Fabien Pinckaers <fp@tiny.Be>

 

5

#

 

6

# WARNING: This program as such is intended to be used by professional

 

7

# programmers who take the whole responsability of assessing all potential

 

8

# consequences resulting from its eventual inadequacies and bugs

 

9

# End users who are looking for a ready-to-use solution with commercial

 

10

# garantees and support are strongly adviced to contract a Free Software

 

11

# Service Company

 

12

#

 

13

# This program is Free Software; you can redistribute it and/or

 

14

# modify it under the terms of the GNU General Public License

 

15

# as published by the Free Software Foundation; either version 2

 

16

# of the License, or (at your option) any later version.

 

17

#

 

18

# This program is distributed in the hope that it will be useful,

 

19

# but WITHOUT ANY WARRANTY; without even the implied warranty of

 

20

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 

21

# GNU General Public License for more details.

 

22

#

 

23

# You should have received a copy of the GNU General Public License

 

24

# along with this program; if not, write to the Free Software

 

25

# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

 

26

#

 

27

##############################################################################

 

28

 

 

29

import time

 

30

 

 

31

def som(cr, uid, partner_id, args):

 

32

        result = args['som_interval_default']

 

33

        max = args['som_interval_max'] or 4

 

34

        factor = args['som_interval_decrease']

 

35

        date_start=time.time() - args['som_interval']*3600*24*max

 

36

        for i in range(max):

 

37

                next_date = date_start + args['som_interval']*3600*24

 

38

                cr.execute(

 

39

                         '''

 

40

                         select s.factor from res_partner_event e

 

41

                         left join res_partner_som s

 

42

                         on (e.som=s.id) where partner_id=%d and date>=%s and date<%s''', 

 

43

                         (partner_id, 

 

44

                          time.strftime('%Y-%m-%d', time.gmtime(date_start)),

 

45

                          time.strftime('%Y-%m-%d', time.gmtime(next_date))))

 

46

 

 

47

                soms = cr.fetchall()

 

48

                if len(soms):

 

49

                        c = 0

 

50

                        nbr = 0.0

 

51

                        for som in soms:

 

52

                                if som[0]:

 

53

                                        c+=1

 

54

                                        nbr+=som[0]

 

55

                        if c:

 

56

                                avg = nbr/c

 

57

                        else:

 

58

                                avg = result

 

59

                        result = result*(1-factor) + (avg*factor)

 

60

                else:

 

61

                        avg = args['som_interval_default']

 

62

                date_start = next_date

 

63

        return result

 

64

 

 

65

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1