Recommended programming languages....

**MarkCuering** · 11-25-2008, 09:59 AM

hmm.... how about 100 years from now?

**javapenguin** · 11-25-2008, 10:00 AM

Originally Posted by MarkCuering

hey, are you @ javasphere?

Nope, never been in there before. Na OT na siguro ta?

**javapenguin** · 11-25-2008, 10:10 AM

Originally Posted by MarkCuering

hmm.... how about 100 years from now?

hmm.. naa nay C, C++, C#, so the ultimate C must be

C∞ (C infinity)

**MarkCuering** · 11-25-2008, 10:21 AM

Z++ or Z# ?

**cold_fusion** · 11-25-2008, 03:36 PM

Originally Posted by MarkCuering

hey...i'm serious... if you really manage to write python preferably GUI using wxPython. please send me some of you work... I really can help you. you don't have to work abroad... but I guarantee you will earn dollars.

Really? I do write GUI using tkinter or wxwidgets/wxpython.
But most of my apps are console based and not relying on gui for its not for production.
And I don't have time at the moment. Many projects to be finished. Maybe later...

BTW, I had posted a python program as an answer to a programming challenge in a thread here 7 months ago.
See this https://www.istorya.net/forums/progra...apply-now.html . You could evaluate my coding quality basing on that post.

**MarkCuering** · 11-25-2008, 06:11 PM

cold_fusion, not bad

can you give me some more?

**cold_fusion** · 11-25-2008, 06:45 PM

Ok.

Here's a snippet of a module I created for a python based erp system.

Code:

from osv import osv, fields

import time, datetime
import datetime
import netsvc

import ir
from mx import DateTime
import pooler
from tools import config

from construction.construction import *

class construction_purchase(osv.osv):

    _name = 'construction.purchase'
    
    _description = 'Purchase Order'
    
    def _total_amount(self, cr, uid, ids, field_name, arg, context):
        
        #
        #print "Domain:", self.pool.get('ir.rule').domain_get(cr, uid, 'Confirmed Purchase Orders')
        
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = 0.0
            for line in f.purchase_line:
                res[f.id] += line.amount
            res[f.id] = round(res[f.id] / 0.01) * 0.01
        return res
        
    def _is_due(self, cr, uid, ids, field_name, arg, context):
        now = DateTime.now()
        res = {}
        for f in self.browse(cr, uid, ids):
            due = DateTime.strptime(f.due_date, '%Y-%m-%d')
            #print now, due
            if now > due:
                res[f.id] = True
            else:
                res[f.id] = False
        return res

    def _balance(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.amount - f.paid_amount
        return res

    
    _columns = {

        'category': fields.selection(
            (
                ('labor', 'Labor'), 
                ('material', 'Material'),
            ), 
            'Category', required=True, change_default=True),
    
        'name' : fields.char('Number / Reference', 
            size=100, 
            required=True,
            readonly=True,
            select=1,
            states={
                'draft':[('readonly',False)]
            }),

        'date_ordered':fields.date('Order Date',
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'supplier_id':fields.many2one('construction.suppliers', 'Supplier',
            required=True, 
            readonly=True, 
            select=1,
            states={
                'draft':[('readonly',False)],
            }),

        'project_id':fields.many2one('construction.projectro', 'Project', 
            required=True, 
            readonly=True, 
            select=1,
            domain="[('state','=','confirmed')]",
            states={
                'draft':[('readonly',False)],
            }),

        'created_by':fields.many2one('res.users', 'Created by',
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'date_created':fields.date('Date Created', 
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'purchase_line': fields.one2many('construction.purchase.line', 
            'purchase_id', 
            'Order Lines',
            states={
                'done':[('readonly',True)]
            }),
        
        'note': fields.text('Notes'),

        'state': fields.selection(
            [
                ('draft','Draft'),
                ('done','Released'),
            ], 
            'State'),
            
        'total_amount': fields.function(_total_amount, 
            method=True, string='Total Amount',
            digits=(16, int(config['price_accuracy'])),
            ),
            
        'amount':fields.float('Amount', readonly=True, digits=(16, 2)),
        'paid_amount':fields.float('Payment', readonly=True, digits=(16, 2)),
        'is_paid':fields.boolean('Paid', readonly=True, ),

        'due_date':fields.date('Due Date', 
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),
            
        'release_date':fields.date('Date Released', 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'is_due': fields.function(_is_due, type='boolean',
            method=True, string='Due', 
            ),

        'balance': fields.function(_balance, type='float', digits=(16, 2),
            method=True, string='Balance',
            ),
            
        'for_reimbursement':fields.boolean('For Reimbursement', readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),
            
        'quote_verify':fields.boolean('For Actual Verification', readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'checked_by':fields.many2one('res.users', 'Checked / Verified by',
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),
            
        'date_verified':fields.date('Date Verified', 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

    }
    _defaults = {
        'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'construction.purchase'),
        'state': lambda *a: 'draft',
        'paid_amount': lambda *a: 0,
        'date_created': lambda *a: time.strftime('%Y-%m-%d'),
        'date_ordered': lambda *a: time.strftime('%Y-%m-%d'),
        'due_date': lambda *a: time.strftime('%Y-%m-%d'),
        'created_by' : lambda obj, cr, uid, context: uid,
        'category': lambda *a: 'material',
        'is_paid': lambda *a: False,
        'for_reimbursement': lambda *a: False,
        'quote_verify': lambda *a: False,
    }
    _order = 'name desc'

    def update_req_po_qty(self, cr, uid, ids):
        req_line_ids = []
        for f in self.browse(cr, uid, ids):
            for line in f.purchase_line:
                req_line_ids.append(line.read(cr, uid, line.id,['request_line_id'])['request_line_id'][0])
                
        if req_line_ids:
            sql = "select a.request_line_id, sum(case when b.state='done' then a.quantity else 0 end) as qty"
            sql    += " from construction_purchase_line as a inner join construction_purchase as b on a.purchase_id = b.id"
            sql    += " where a.request_line_id in (" + ",".join(map(str, req_line_ids)) + ")"
            sql    += " group by 1"
            #print(sql)
            cr.execute(sql)
            for rec in cr.fetchall():
                self.pool.get("construction.requests.line").write(cr, uid, rec[0], {'po_quantity' : rec[1]})
    
    def bt_purchase_confirm(self,cr, uid, ids, *args):
        self.write(cr, uid, ids, {'state': 'done'})
        #compute po amount
        self.update_req_po_qty(cr, uid, ids)
        
        for f in self.browse(cr, uid, ids):
            amt = 0
            release_date = f.release_date
            for line in f.purchase_line:
                amt += line.amount
            amt = round(amt / 0.01) * 0.01
        self.write(cr, uid, ids, {'amount': amt})
        
        if not release_date:
            self.write(cr, uid, ids, {'release_date': time.strftime('%Y-%m-%d')})
            
        return True

    def bt_purchase_unconfirm(self,cr, uid, ids, *args):
        if not user_with_rights(self, cr, uid, uid, 'Unconfirm Purchase Order Rights'):
            return False
        
        self.write(cr, uid, ids, {'state': 'draft'})
        self.update_req_po_qty(cr, uid, ids)
        return True
        
    def compute_due_date(self, cr, uid, ids, supplier_id, date_ordered):
        v={}
        #print supplier_id, date_ordered
        if not supplier_id:
            return {}
        if not date_ordered:
            return {}
        supplier=self.pool.get('construction.suppliers').browse(cr,uid,supplier_id)
        due_date = DateTime.strptime(date_ordered, '%Y-%m-%d') + DateTime.RelativeDateTime(days=int(supplier.terms))
        #print date_ordered, due_date, due_date.strftime('%Y-%m-%d')
        v['due_date'] = due_date.strftime('%Y-%m-%d')
        return {'value':v}


construction_purchase()


##


class construction_reqlookup(osv.osv):
    _name = 'construction.reqlookup'
    _inherit = 'construction.requests.line'
    _table = 'construction_requests_line'
    _description = 'Requisitions Lookup'
    _order = 'seq, name'
construction_reqlookup()    





class construction_purchase_line(osv.osv):
    _name = 'construction.purchase.line'
    _description = 'Purchase Order Details'
    
    def onchange_request_line_id(self, cr, uid, ids, request_line_id):
        v={} 
        if request_line_id :
            req_line=self.pool.get('construction.requests.line').browse(cr,uid,request_line_id)
            po_lines = self.browse(cr,uid,ids)
            v['quantity'] = req_line.quantity - req_line.po_quantity
            v['price'] = req_line.price
            v['unit'] = req_line.unit
            v['name'] = req_line.name
        return {'value':v}
    
    def _constraint_po_qty(self, cr, uid, ids):
        for f in self.browse(cr, uid, ids):
            if f.request_line_id:
                cr.execute('select quantity from construction_requests_line where id=%d', (f.request_line_id,))
                req_qty = cr.fetchone()[0]
                cr.execute('select sum(quantity) from construction_purchase_line where request_line_id=%d', (f.request_line_id,))
                po_qty = cr.fetchone()[0]
                #raise osv.except_osv(
                #    'Debug',
                #        'PoQty = %d,  ReqQty=%d' % (po_qty, req_qty))
                
                return (req_qty - po_qty) > -0.001
            else:
                return True
    
    def _amount(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = round((f.price * f.quantity)/0.01) * 0.01
        return res

    def _show_item(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.request_line_id.name
        return res

    def _show_unit(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.request_line_id.unit
        return res
    
    _columns = {
        'purchase_id': fields.many2one('construction.purchase', 'Requisition Ref', 
            required=True),

        'name' : fields.char('Item', size=100),
            
        'request_line_id' : fields.many2one('construction.reqlookup', 'Item',
                domain="[('project_id', '= ', parent.project_id),('quantity','> po_quantity or 1=','0'),('category','=',parent.category)]",
                required=True),
                
        'seq': fields.integer('Sequence', select=False),
        'item': fields.function(_show_item, size=30, type='char', method=True, string='Item'),
        'quantity': fields.float('Quantity', required=True, digits=(16, 2)),
        'unit': fields.function(_show_unit, size=10, type='char', method=True, string='Unit'),
        #'unit': fields.char('Unit', size=10),
        'price': fields.float('Price', required=True, digits=(16, int(config['price_accuracy']))),
        'note': fields.text('Notes'),
        'amount': fields.function(_amount, method=True, string='Amount', digits=(16, int(config['price_accuracy']))),
        
        'received_qty': fields.float('Received Qty', readonly=True, digits=(16, 2)),
        
    }
    _defaults = {
        'seq': lambda *a: 10,
        'quantity': lambda *a: 0,
        'price': lambda *a: 0,
        'received_qty': lambda *a: 0,
    }
    _order = 'seq, id'
    
    _constraints = [
        (_constraint_po_qty,'Error! P.O. quantity is more than requisition quantity.',[])
    ]
    
construction_purchase_line()    


##



class construction_jo_old(osv.osv):
    _name = 'construction.jo'
    _table = 'construction_purchase'
    _description = 'Job Order'
    _inherit = 'construction.purchase'
    _defaults = {
        'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'construction.jo'),
        'category': lambda *a: 'labor',
    }

class construction_jo(osv.osv):

    _name = 'construction.jo'
    _table = 'construction_purchase'
    
    _description = 'Job Order'
    
    def _total_amount(self, cr, uid, ids, field_name, arg, context):
        
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = 0.0
            for line in f.purchase_line:
                res[f.id] += line.amount
            res[f.id] = round(res[f.id] / 0.01) * 0.01
        return res
        
    def _is_due(self, cr, uid, ids, field_name, arg, context):
        now = DateTime.now()
        res = {}
        for f in self.browse(cr, uid, ids):
            due = DateTime.strptime(f.due_date, '%Y-%m-%d')
            #print now, due
            if now > due:
                res[f.id] = True
            else:
                res[f.id] = False
        return res

    def _balance(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.amount - f.paid_amount
        return res

    
    _columns = {

        'category': fields.selection(
            (
                ('labor', 'Labor'), 
                ('material', 'Material'),
            ), 
            'Category', required=True, change_default=True),
    
        'name' : fields.char('Number / Reference', 
            size=100, 
            required=True,
            readonly=True,
            select=1,
            states={
                'draft':[('readonly',False)]
            }),

        'date_ordered':fields.date('Order Date',
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'supplier_id':fields.many2one('construction.suppliers', 'Supplier',
            required=True, 
            readonly=True, 
            select=1,
            states={
                'draft':[('readonly',False)],
            }),

        'project_id':fields.many2one('construction.projectro', 'Project', 
            required=True, 
            readonly=True, 
            select=1,
            domain="[('state','=','confirmed')]",
            states={
                'draft':[('readonly',False)],
            }),

        'created_by':fields.many2one('res.users', 'Created by',
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'date_created':fields.date('Date Created', 
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'purchase_line': fields.one2many('construction.jo.line', 
            'purchase_id', 
            'Order Lines',
            states={
                'done':[('readonly',True)]
            }),
        
        'note': fields.text('Notes'),

        'state': fields.selection(
            [
                ('draft','Draft'),
                ('done','Released'),
            ], 
            'State'),
            
        'total_amount': fields.function(_total_amount, 
            method=True, string='Total Amount',
            digits=(16, int(config['price_accuracy'])),
            ),
            
        'amount':fields.float('Amount', readonly=True, digits=(16, 2)),
        'paid_amount':fields.float('Payment', readonly=True, digits=(16, 2)),
        'is_paid':fields.boolean('Paid', ),

        'due_date':fields.date('Due Date', 
            required=True, 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'release_date':fields.date('Date Released', 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'is_due': fields.function(_is_due, type='boolean',
            method=True, string='Due', 
            ),

        'balance': fields.function(_balance, type='float', digits=(16, 2),
            method=True, string='Balance',
            ),
            
        'for_reimbursement':fields.boolean('For Reimbursement', readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),
            
        'quote_verify':fields.boolean('For Actual Verification', readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

        'checked_by':fields.many2one('res.users', 'Checked / Verified by',
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),
            
        'date_verified':fields.date('Date Verified', 
            readonly=True, 
            states={
                'draft':[('readonly',False)],
            }),

    }
    _defaults = {
        'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'construction.jo'),
        'state': lambda *a: 'draft',
        'paid_amount': lambda *a: 0,
        'date_created': lambda *a: time.strftime('%Y-%m-%d'),
        'date_ordered': lambda *a: time.strftime('%Y-%m-%d'),
        'due_date': lambda *a: time.strftime('%Y-%m-%d'),
        'created_by' : lambda obj, cr, uid, context: uid,
        'category': lambda *a: 'labor',
        'is_paid': lambda *a: False,
        'for_reimbursement': lambda *a: False,
        'quote_verify': lambda *a: False,
    }
    _order = 'name desc'

    def bt_purchase_confirm(self,cr, uid, ids, *args):
        self.write(cr, uid, ids, {'state': 'done'})
        #compute po amount
        #self.update_req_po_qty(cr, uid, ids)
        
        for f in self.browse(cr, uid, ids):
            amt = 0
            release_date = f.release_date
            for line in f.purchase_line:
                amt += line.amount
            amt = round(amt / 0.01) * 0.01
        self.write(cr, uid, ids, {'amount': amt})
        
        if not release_date:
            self.write(cr, uid, ids, {'release_date': time.strftime('%Y-%m-%d')})
            
        return True

    def bt_purchase_unconfirm(self,cr, uid, ids, *args):
        if not user_with_rights(self, cr, uid, uid, 'Unconfirm Purchase Order Rights'):
            return False
        
        self.write(cr, uid, ids, {'state': 'draft'})
        #self.update_req_po_qty(cr, uid, ids)
        return True
        
    def compute_due_date(self, cr, uid, ids, supplier_id, date_ordered):
        v={}
        #print supplier_id, date_ordered
        if not supplier_id:
            return {}
        if not date_ordered:
            return {}
        supplier=self.pool.get('construction.suppliers').browse(cr,uid,supplier_id)
        due_date = DateTime.strptime(date_ordered, '%Y-%m-%d') + DateTime.RelativeDateTime(days=int(supplier.terms))
        #print date_ordered, due_date, due_date.strftime('%Y-%m-%d')
        v['due_date'] = due_date.strftime('%Y-%m-%d')
        return {'value':v}


construction_jo()


class construction_jo_line(osv.osv):
    _name = 'construction.jo.line'
    _table = 'construction_purchase_line'
    
    _description = 'Job Order Details'
    
    def _amount(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = round((f.price * f.quantity)/0.01) * 0.01
        return res

    def _show_item(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.request_line_id.name
        return res

    def _show_unit(self, cr, uid, ids, field_name, arg, context):
        res = {}
        for f in self.browse(cr, uid, ids):
            res[f.id] = f.request_line_id.unit
        return res
    
    _columns = {
        'purchase_id': fields.many2one('construction.purchase', 'Requisition Ref', 
            required=True),

        'name' : fields.char('Item', size=100),
            
        'seq': fields.integer('Sequence', select=False),
        #'item': fields.function(_show_item, size=30, type='char', method=True, string='Item'),
        'quantity': fields.float('Quantity', required=True, digits=(16, 2)),
        #'unit': fields.function(_show_unit, size=10, type='char', method=True, string='Unit'),
        'unit2': fields.char('Unit', size=10),
        'price': fields.float('Price', required=True, digits=(16, int(config['price_accuracy']))),
        'note': fields.text('Notes'),
        'amount': fields.function(_amount, method=True, string='Amount', digits=(16, int(config['price_accuracy']))),
        'received_qty': fields.float('Received Qty', readonly=True, digits=(16, 2)),
    }
    _defaults = {
        'seq': lambda *a: 10,
        'quantity': lambda *a: 1,
        'price': lambda *a: 0,
        'received_qty': lambda *a: 0,
    }
    _order = 'seq, id'
    
    
construction_jo_line()

Here's another. This one is a sniffer log parser

:

Code:

#!/usr/bin/python

import socket, re, sys

conn = {}

def zcomp(x):
    try:
        xx = ""
        for z in x[0].split('.'):
            xx = xx + '.' + z.rjust(3)
        return x[2].rjust(5) + '-' + xx + '-' + x[1]
    except:
        return ""

def parse(data):
    global conn

    if data[0][11:15] != "192.":
        return

    try:
        p = data[0].split(' -> ')
        p[0] = p[0].rstrip(') ').split('(')
        p[1] = p[1].rstrip(') ').split('(')

        ip_from = p[0][0][11:]
        ip_to = p[1][0]
        port = p[1][1]

        b = zcomp([ip_from, ip_to, port])
        conn[b] = [ip_from, ip_to, port, data[1:]]

    except:
        pass


##
try:
    f=open(sys.argv[1])
except:
    f=open("info.gdd")

data = []
for line in f:
    if line[0:10] == "CONNECTION":
        if len(data) > 0:
            parse(data)
        data = []
        data.append(line.rstrip())
    elif line[0:10] != "==========":
        data.append(line.rstrip())

parse(data)
#print conn

#conn.sort(cmp = lambda a, b : cmp(zcomp(a), zcomp(b)))
keys = conn.keys()
keys.sort()

for xi in keys:

    x = conn[xi]

    try:
        n = socket.gethostbyaddr(x[1])
    except:
        n = ['not found...']

    #find username/pwd pair
    username = ""
    password = ""
    if x[2] in ['110','21']:
        for y in x[3]:
            if y[0:4]=='USER':
                username = y.split(' ')[1]
            elif y[0:4]=='PASS':
                password = y.split(' ')[1]
    else:
        for y in x[3]:
            #print y
            username = username + y + "\n"

    print x[0].ljust(16), x[1].ljust(16), x[2].rjust(5), n[0]
    print username + ':' + password
    print

**MarkCuering** · 11-25-2008, 07:31 PM

@cold_fusion, regarding your python based erp system... are you using pkg-terp Koders - Source Code Search Engine project? or came from OpenERP?

in that log parser can you send to me the info.gdd hehehehe..

**cold_fusion** · 11-25-2008, 07:38 PM

Openerp/tinyerp.
This is a custom module which is not included on the package.

This is for a construction company. Most of the existing modules won't fit the user's needs so I recreated 80-90% of the modules but uses only the base system as framework (user access, UI, reporting and database engine).

Sorry I can't send you the "info.gdd"

. It's for my own private use only...hehehe.

**MarkCuering** · 11-25-2008, 07:56 PM

hehehehehe.....

nice work... I'm trying to figure it out...something is missing in here :P

try:
n = socket.gethostbyaddr(x[1])
except:
n = ['not found...']

the construction of your dictionary "conn" give me some clue... but judging on the way you strip the stringlines "data" into incoming and outgoing ip, port, updating it via parse() function, makes me wonder what are you doing in port 110, or 21... especially on that line "for y in x[3]:" which was chunk earlier... as username and password... well..it looks like for viewing purpose I guess.

Thread: Recommended programming languages....

Thread Tools

Search Thread

Advertisement
Sign-in to hide this ad

Similar Threads

what is your favorite programming language?

Cebu web developer's "programming" language of choice

MOVED: what is your favorite programming language?

Any suggestion of a programming language to use in Palm (PDA)?

MOVED: Inquire: Cheap Programming Language Tutor Session

Posting Permissions

about us

follow us

Thread: Recommended programming languages....

Thread Tools

Search Thread

AdvertisementSign-in to hide this ad

Similar Threads

what is your favorite programming language?

Cebu web developer's "programming" language of choice

MOVED: what is your favorite programming language?

Any suggestion of a programming language to use in Palm (PDA)?

MOVED: Inquire: Cheap Programming Language Tutor Session

Posting Permissions

about us

follow us

Advertisement
Sign-in to hide this ad