reklame_hitung.py
2.61 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
from sqlalchemy import (
Column, ForeignKey, Integer, String, SmallInteger, func)
from opensipkd.pjdl.models import PjdlPajak
from opensipkd.pjdl.models import PjdlReklameCahaya, PjdlReklamePasang
from . import PAD_TABLE_ARGS, StandarModel, Base, DBSession
from opensipkd.pjdl.models.reklame import (
PjdlReklameCahaya, PjdlReklameNilaiSudutPandang, PjdlReklamePasang,
PjdlReklameStatus, PjdlReklameNilaiSudutPandang)
class PjdlReklameHitung(Base, StandarModel):
__tablename__ = 'pad_rk_hitung'
__table_args__ = PAD_TABLE_ARGS
id = Column(Integer, primary_key=True)
pajak_id = Column(Integer(), ForeignKey(PjdlPajak.id), nullable=False, )
bahan = Column(String(128))
satuan = Column(String(32))
biaya = Column(Integer())
# masapajak = Column(SmallInteger(), nullable=False)
# jatuhtempo = Column(SmallInteger())
# multiple = Column(SmallInteger())
cahaya_id = Column(Integer(), ForeignKey(
PjdlReklameCahaya.id), nullable=False,)
# Cara Pemasangan ditempel ditanam menyebar
pasang_id = Column(SmallInteger(), ForeignKey(
PjdlReklamePasang.id), nullable=False,)
status_id = Column(Integer()) # Status Permanen
@classmethod
def get_bahan(cls, db_session=DBSession):
return db_session.query(func.distinct(cls.bahan).label("bahan"))
@classmethod
def get_nilai(cls, values, db_session=DBSession):
row = cls.query().filter_by(
pajak_id=int(values["pajak_id"]),
bahan=values["bahan"],
cahaya_id=int(values["cahaya_id"]),
status_id=int(values["status_id"]),
pasang_id=int(values["pasang_id"])).first()
return row and row.biaya or None
@classmethod
def query_register(cls, order_field="id"):
return cls.query_from(columns =[PjdlPajak.pajaknm.label('Pajak'),
PjdlReklameCahaya.nama.label('Cahaya'),
PjdlReklamePasang.nama.label('Cara Pasang'),
cls.bahan.label('Bahan'),
cls.biaya.label('Biaya'),
cls.status.label('Status'),
PjdlReklameStatus.nama.label('Permanen')]). \
outerjoin(PjdlPajak, PjdlPajak.id == cls.pajak_id).\
outerjoin(PjdlReklameStatus, PjdlReklameStatus.id == cls.status_id).\
outerjoin(PjdlReklameCahaya, PjdlReklameCahaya.id == cls.cahaya_id).\
outerjoin(PjdlReklamePasang, PjdlReklamePasang.id == cls.pasang_id).\
order_by(getattr(cls, order_field))