Пример #1
0
    def show(self, id):
        """Handle the front-page."""
        """GET /bookkeeping/id: Show a specific item"""

        results = OrderedDict()
        for i in ['total' , 'account_code', 'vat_code', 
                    'recs', 'issues']:
            results[i]=None

        # Total                          
        groupby = [Factb2b.booked, Factb2b.closed, 
                    Provenienze, Factb2b.doc_id, Factb2b.doc_date, Factb2b.doc_num]
        query_lst = groupby + FACT_B2B
        fltr = [and_(Factb2b.doc_id==id,
                     Factb2b.supplier_id==Provenienze.numeroprovenienza)]              
        results['total'] = self._datagrid(query_lst, groupby, fltr)                                        
        # Account                            
        groupby = [Factb2b.doc_num,Factb2b.cost_center_code, Factb2b.account_code,
                    Factb2b.account_desc, Factb2b.b2b_vat_code]
        query_lst = groupby + FACT_B2B
        
        fltr = [Factb2b.doc_id==id ]     
        
        
               
        results['account_code'] = self._datagrid(query_lst, groupby, fltr)
                
        # Vat
        groupby = [Factb2b.doc_num, Factb2b.cost_center_code, Factb2b.b2b_vat_code]
        query_lst = groupby + FACT_B2B
        fltr = [Factb2b.doc_id==id]              
        results['vat_code'] = self._datagrid(query_lst, groupby, fltr) 

        # Receipts
        recs = [i[0] for i in DBSession.query(Factb2b.rec_num).filter(
                                Factb2b.doc_id==id).distinct().all()]
        results['recs'] = []
        for rec_num in recs:
            
            groupby = [Factb2b.doc_num, Factb2b.rec_num]
            query_lst = groupby + FACT_B2B
            fltr = [Factb2b.doc_id==id,
                Factb2b.rec_num==rec_num
                 ] 
            results['recs'].append(self._datagrid(query_lst, groupby, fltr)[0]) 

        # Issues
        fltr = [Factb2b.doc_id==id,
                Factb2b.account_id==None ]              
        results['issues'] = DBSession.query(Factb2b).filter(and_(*fltr)).all()
                 
        # Products
        groupby = [Factb2b.doc_num, Factb2b.account_code, 
                   Factb2b.b2b_code, Factb2b.b2b_desc]
        query_lst = groupby + FACT_B2B_PRICE
        fltr =   [Factb2b.doc_id==id]       
        results['products'] = self._datagrid(query_lst, groupby, fltr) 
        
        return dict(page='bookkeeping', results=results, id=id)   
Пример #2
0
    def showreport(self, id, ng=None,nr=None):
        """GET /showreport/id: Show a specific item"""
        doc = DBSession.query(Inventarit).filter(Inventarit.numeroinventario==id).one()
        """
        tables = (
                Inventarirconta, 
                Prodotti, 
                Reparti, 
                Gruppireparti 
                )
        columns = []
        query_args = []
        for m in tables:
            for c in m.__table__.columns:
                if not c in columns:
                    columns.append("%s"%(c))
                    query_args.append(c)
        """            
        totale_costo2 = Inventarirconta.costo2 * Inventarirconta.totale_qta                    
        
        COSTI = [
        
            label('totale_costo', func.sum(totale_costo2)),
        ] 
        fltr_query = [Inventarirconta.numeroinventario==id]
        group = [   Inventarirconta.numeroinventario, 
					Gruppireparti.numerogrupporeparto,
					Gruppireparti.grupporeparto]
        group_tot = [   Inventarirconta.numeroinventario ]
        if ng:
			group = group +[
					Reparti.numeroreparto, 
					Reparti.reparto
				]
			fltr_query = fltr_query + [Gruppireparti.numerogrupporeparto==ng]          
        if nr:
			group = group + [
					Prodotti.numeroprodotto,
					Prodotti.prodotto
			]                        
			fltr_query = fltr_query + [Reparti.numeroreparto==nr]          
        query_args =  group + COSTI
        query_args_tot = group_tot + COSTI
        ret = DBSession.query(*query_args)
        ret_tot = DBSession.query(*query_args_tot)
        fltr = [and_(
                    *fltr_query
                )
                ] 
        ret = ret.filter(*fltr)
        ret_tot = ret_tot.filter(*fltr)	
        ret = self._get_joins(ret)    				
        ret_tot = self._get_joins(ret_tot)
        ret = ret.group_by(*group)     		
        ret_tot = ret_tot.group_by(*group_tot)           
        results = ret.all()        
        totals = ret_tot.all()
        return dict(page='stock', id=id, ng=ng, nr=nr, doc=doc, results=results, totals=totals)
Пример #3
0
 def update(self, id, *args, **kw):
     """PUT /backoffice/id: Update an existing item"""
     # Forms posted to this method should contain a hidden field:
     #    <input type="hidden" name="_method" value="PUT" />
     # Or using helpers:
     #    h.form(url('stock', id=ID),
     #           method='put')
     # url('stock', id=ID)
     DBSession.query(Factb2b).filter_by(doc_id=id).update(dict(booked=1))
     redirect(url('/bookkeeping/show/%s'%id))
Пример #4
0
    def show(self, id):
        """GET /stocks/id: Show a specific item"""

        doc = DBSession.query(Inventarit).filter(Inventarit.numeroinventario==id).one()
        if not doc.inventariconta:
            Inventarirconta(numeroinventario=doc.numeroinventario)
            DBSession.add(Inventarirconta)
            DBSession.flush()
        result = views.get_stock(id)            
        return dict(page='stock', doc=doc, result=result)            
Пример #5
0
    def updatecost(self, id):
        """GET /stocks/id: Show a specific item"""       
        #result = views.get_stock_cogs(id)
        doc = DBSession.query(Inventarit).filter(Inventarit.numeroinventario==id).one()
        invs = DBSession.query(Inventarirconta).filter(Inventarirconta.numeroinventario==id).all()
        for ic in invs:
		    ic.costo, ic.datacosto = gcogs(ic.numeroprodotto, doc.numeromagazzino ,date=doc.datainventario)
		    if not ic.costo2  or ic.costo2 == 0:
				ic.costo2 = ic.costo
		    DBSession.add(ic)
        redirect('/stock/show/'+id)    
Пример #6
0
 def updatedoc(self, id, doc_num, *args, **kw):
     """PUT /stocks/id: Update an existing item"""
     # Forms posted to this method should contain a hidden field:
     #    <input type="hidden" name="_method" value="PUT" />
     # Or using helpers:
     #    h.form(url('stock', id=ID),
     #           method='put')
     # url('stock', id=ID)
     print [args]
     print [kw]
     DBSession.query(Factb2b).filter_by(inputb2b_id=id,doc_num=doc_num ).update(dict(validated=1))
     redirect(url('/b2b/showdoc/%s/%s'%(id,doc_num))) 
Пример #7
0
    def requestupg(self, id):
        """GET /stocks/id: Show a specific item"""       
    
        date=datetime.now()        
        try:
			obj = DBSession.query(Aggiornaic).filter(Aggiornaic.numeroinventario==id).one()
        except:
            obj = Aggiornaic()
            obj.numeroinventario=id
        obj.richiesta=date
        obj.status = 1
        email = ''
        DBSession.add(obj)
        redirect('/stock/showcost/'+id) 
Пример #8
0
 def qta(cls, doc_id, prod_id):
     """"""
     try:
         ret = DBSession.query(Inventarirconta).filter(
             Inventarirconta.numeroinventario==doc_id,
             Inventarirconta.numeroprodotto==prod_id,
             ).one()
     except:
         ret = Inventarirconta()
         ret.numeroinventario=doc_id
         ret.numeroprodotto=prod_id
         ret.qta=0
         DBSession.add(ret)
     DBSession.flush()
     return ret
Пример #9
0
 def b2b_export(self, id):
     """"""       
     validated = DBSession.query(Factb2b).filter(and_(
         Factb2b.inputb2b_id == id,
         Factb2b.booked != 1
     )).all()
     return dict(page='modal',id=id,validated=validated, result=[id])  
Пример #10
0
 def _datagrid(self, query_lst , groupby, fltr, ordr=None):
     ret = DBSession.query(*query_lst)
     #ret = ret.order_by(Factb2b.row)
     ret = ret.group_by(*groupby).filter(and_(*fltr))
     if ordr:
         ret = ret.order_by(*ordr)      
     return ret.all()    
Пример #11
0
 def show(self, id):
     """GET /stocks/id: Show a specific item"""
     result = views.get_pricelist(id)
     
     ret = DBSession.query(Provenienze).filter(Provenienze.numeroprovenienza==id).one()
        
     return dict(page='stock', ret = ret, result=result)            
Пример #12
0
 def index(self, page=1):
     """Handle the front-page."""
     
              
     results = DBSession.query(Prodotti)
     pags = paginate.Page(results, page, items_per_page=50)        
     return dict(page='item', results=pags.items, pags=pags) 
Пример #13
0
 def product(self, id):
     """"""
     ret = DBSession.query(Prodotti )
     
     ret = ret.filter(Prodotti.numeroprodotto==id)
     ret = ret.one() 
     
     return dict(page='modal',result=ret)  
Пример #14
0
 def prezzo(self):
     try:
         l=DBSession.query(Listiniprodotti).filter(and_(
         Listiniprodotti.numeroprodotto=="%s"%self.numeroprodotto,
         Listiniprodotti.numerolistino==0
             )).one()
         return l.prezzo
     except:
         return 0
Пример #15
0
Файл: b2b.py Проект: nomed/ebetl
 def show(self, id):
     """GET /b2b/id: Show a specific item"""
     inputb2b = DBSession.query(Inputb2b).filter(Inputb2b.b2b_id==id).one()
     groupby = [Factb2b.booked, Factb2b.validated, Provenienze, Factb2b.doc_date, Factb2b.doc_num]
     query_lst = groupby + FACT_B2B
     fltr = [and_(
                 Provenienze.numeroprovenienza==Factb2b.supplier_id,
                 Factb2b.inputb2b_id == id
             )
             ]            
     results = self._datagrid(query_lst, groupby, fltr)
     return dict(page='b2b', id=id, inputb2b=inputb2b, results=results) 
Пример #16
0
 def update(self, id):
     """PUT /stocks/id: Update an existing item"""
     # Forms posted to this method should contain a hidden field:
     #    <input type="hidden" name="_method" value="PUT" />
     # Or using helpers:
     #    h.form(url('stock', id=ID),
     #           method='put')
     # url('stock', id=ID)
     ret = DBSession.query(Inputb2b).filter(
                                 Inputb2b.b2b_id==id).one()   
     from ebetl.lib.etl.filconad import FilconadObj
     fobj = FilconadObj(config, ret.record)  
     fobj.write_out(inputb2b_id=id)   
     return redirect(url('/b2b/show/%s'%id))
Пример #17
0
Файл: b2b.py Проект: nomed/ebetl
 def index(self):
     """Handle the front-page."""
     results = DBSession.query(Inputb2b).order_by(Inputb2b.processed, Inputb2b.updated).all()
     return dict(page='b2b', results=results) 
Пример #18
0
    def index(self, *args, **kw):
        """Handle the front-page."""
        print kw
        group_by = [Clientifid.codiceclientefid, Clientifid.nome, Clientifid.cognome, Clientifid.email]
        fltr = group_by + MEASURES
        ret = DBSession.query(*fltr)
        
        start = kw.get('start')
        if start:
			start_obj = datetime.datetime.strptime(start, "%Y/%m/%d")
        else:
			start_obj = datetime.datetime.now() 
			kw['start'] = start_obj.strftime("%Y/%m/%d")
        print start_obj
        ret=ret.filter(Movimentit.datadocumento>=start_obj)	 

			
        end = kw.get('end')
        if end:
			end_obj = datetime.datetime.strptime(end, "%Y/%m/%d")			
        else:
			end_obj = datetime.datetime.now() 
			kw['end'] = end_obj.strftime("%Y/%m/%d")
        ret=ret.filter(Movimentit.datadocumento<=end_obj)	 
		    
        produttori = kw.get('produttori')
        if produttori:
			produttori = json.loads(produttori)
        prdlist = []
        if produttori:
			for p in produttori:
				prdlist.append(Produttori.numeroproduttore==p)     
        if prdlist:
			ret=ret.filter(or_(*prdlist))
			
        reparti = kw.get('reparti')
        if reparti:
			reparti = json.loads(reparti)
        replist = []
        if reparti:
			for r in reparti:
				replist.append(Prodotti.numeroreparto==r)     
        if replist:
			ret=ret.filter(or_(*replist))    
        # join on document header table     
        join_condition=Clientifid.numeroclientefid==Ricevutet.numeroclientefid
        ret = ret.join(Ricevutet, join_condition)        
        join_condition=Ricevutet.numeromovimento==Movimentit.numeromovimento
        ret = ret.join(Movimentit, join_condition)        
        join_condition=Movimentit.numeromovimento==Movimentir.numeromovimento
        ret = ret.join(Movimentir, join_condition) 
        join_condition=Prodotti.numeroprodotto==Movimentir.idprodotto
        ret = ret.join(Prodotti, join_condition)
        join_condition=Produttori.numeroproduttore==Prodotti.numeroproduttore
        ret = ret.outerjoin(Produttori, join_condition)        
        results = ret.group_by(*group_by).all()
        #results=[]
		#join_condition=Movimentit.numeromovimento==Movimentir.numeromovimento
        #ret = ret.join(Movimentir, join_condition)    
        columns = [l.key for l in fltr]   
        return dict(page='marketing', columns=columns, results=results, kw=kw) 
Пример #19
0
 def supplier(self):
     return DBSession.query(Provenienze).filter_by(numeroprovenienza=self.supplier_id).one()
Пример #20
0
 def showcost(self, id, *args):
     """GET /stocks/id: Show a specific item"""       
     result = views.get_stock_cogs(id, *args)
     doc = DBSession.query(Inventarit).filter(Inventarit.numeroinventario==id).one()
        
     return dict(page='stock', doc=doc, result=result) 
Пример #21
0
 def listini(self):
     return DBSession.query(Listiniprodotti).filter_by(
                       numeroprodotto=str(self.numeroprodotto)).all()
Пример #22
0
 def udm_view(self):
     return DBSession.query(Unitamisure).filter_by(
                       numerounitamisura=str(self.numeroumvisualizzazione)).one()
Пример #23
0
 def index(self):
     """Handle the front-page."""
     results = DBSession.query(Inventarit).all()
     return dict(page='stock', results=results) 
Пример #24
0
 def index(self):
     """Handle the front-page."""
     results = DBSession.query(Provenienze).filter_by(tipoprovenienza='FOR').all()
     return dict(page='purchase', results=results) 
Пример #25
0
    def post(self, *args, **kw):
        print [args]
        print [kw]

        
        try:
            pk = kw.get('pk')
            value = kw.get('value')
            if not value:
                value = '0'
            value = float(value)
            name = kw.get('name')
            doc_id, prod_id = pk.split('/')
            if name == 'qta' or name == 'qtaconf':
                p = DBSession.query(Prodotti).filter_by(numeroprodotto = prod_id).one()
                d = DBSession.query(Inventarit).filter_by(numeroinventario = doc_id).one()
                try :
                    ic = DBSession.query(Inventarirconta).filter(and_(
                        Inventarirconta.numeroinventario == doc_id,
                        Inventarirconta.numeroprodotto == prod_id
                        )).one()
                except:
                    ic = Inventarirconta(numeroinventario=doc_id, numeroprodotto=prod_id)
                    ic.qta = 0
                    ic.qtaconf = 0
                    #ic.costo = gcogs(prod_id, d.numeromagazzino ,date=d.datainventario)
                    ic.costo2 = 0
                if not ic.costo:
                    ic.costo = 0
                if not ic.qta:
                    ic.qta = 0
                if not ic.qtaconf:
                    ic.qtaconf = 0
                setattr(ic,name,value)    
                pzxc = p.pezzixcollo or 1                
                ic.totale_qta = ic.qta+ic.qtaconf*pzxc
                ic.totale_costo=ic.totale_qta*ic.costo                
                kw['totale_costo'] = todecimal(ic.totale_costo )
                kw['totale_qta']=todecimal(ic.totale_qta )
                kw['costo'] = todecimal(ic.costo)
                DBSession.add(ic)
            elif name == 'costo2':
                p = DBSession.query(Prodotti).filter_by(numeroprodotto = prod_id).one()
                d = DBSession.query(Inventarit).filter_by(numeroinventario = doc_id).one()
                ic = DBSession.query(Inventarirconta).filter(and_(
                        Inventarirconta.numeroinventario == doc_id,
                        Inventarirconta.numeroprodotto == prod_id
                        )).one()
                
                if not ic.costo:
                    ic.costo = 0
                #if not ic.qta:
                #    ic.qta = 0
                #if not ic.qtaconf:
                #    ic.qtaconf = 0
                setattr(ic,name,value)
                print name, value 
                print ic.costo, ic.costo2   
                #pzxc = p.pezzixcollo or 1                
                #ic.totale_qta = ic.qta+ic.qtaconf*pzxc
                ic.totale_costo=ic.totale_qta*ic.costo2                
                kw['totale_costo'] = todecimal(ic.totale_costo )                
                #kw['costo'] = todecimal(ic.costo)
                DBSession.add(ic)                
        except:
            raise
            pylons.response.status = "400 Error"
            return "Not a valid entry"
        """Handle the front-page."""

        import json
        return json.dumps(kw)
Пример #26
0
 def by_user_name(cls, username):
     """Return the user object whose user name is ``username``."""
     return DBSession.query(cls).filter_by(user_name=username).first()
Пример #27
0
 def index(self,  *kw, **args):
     """Handle the front-page."""
     data = DBSession.query(Tipologieprodotti).all()
     
     return dict(data=data)
Пример #28
0
 def index(self,  *kw, **args):
     """Handle the front-page."""
     data = DBSession.query(Produttori).all()
     
     return dict(data=data)        
Пример #29
0
 def by_email_address(cls, email):
     """Return the user object whose email address is ``email``."""
     return DBSession.query(cls).filter_by(email_address=email).first()