def deletePanen(id):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "DELETE FROM panen WHERE id_panen = "+str(id)
#print(query)
mycursor.execute(query)
conn.commit()
print("Data Deleted")
def getDataGreenBeanSorter(id_gabahK):
query = "SELECT berat_kg,biaya FROM biaya JOIN sorter ON biaya.id_biaya = sorter.id_biaya JOIN green_bean ON green_bean.id_bean = sorter.id_bean WHERE id_gabahK = "+str(id_gabahK)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getDataGabahBasahJemur(id_cherry):
query = "SELECT berat_kg,biaya FROM biaya JOIN jemurB ON biaya.id_biaya = jemurB.id_biaya JOIN gabah_basah ON gabah_basah.id_gabahB = jemurB.id_gabahB WHERE id_cherry = "+str(id_cherry)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getWetMill(id_cherry):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT * FROM wetmill WHERE id_cherry ="+str(id_cherry)
mycursor.execute(query)
try :
result = mycursor.fetchone()
return result
except:
return 0
def getDataWetMill(id_cherry):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT berat_kg,biaya FROM biaya JOIN wetmill ON biaya.id_biaya = wetmill.id_biaya JOIN cherry ON wetmill.id_cherry = cherry.id_cherry WHERE cherry.id_cherry = "+str(id_cherry)
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getGreenBean(id_cherry):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT * FROM green_bean JOIN gabah_kering ON green_bean.id_gabahK = gabah_kering.id_gabahK JOIN gabah_basah ON gabah_basah.id_gabahB = gabah_kering.id_gabahB WHERE id_cherry = "+str(id_cherry)
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getAllPanen():
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT DATE_FORMAT(tanggal,'%d/%m/%Y'),blok,varietas,tipe_proses,status,jumlah_kg,harga_kg,id_cherry,panen.id_panen FROM panen JOIN cherry ON panen.id_panen = cherry.id_panen "
mycursor.execute(query)
try :
result = mycursor.fetchall()
return result
except:
return 0
def getGabahBasah(id_cherry):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT * FROM gabah_basah WHERE id_cherry="+str(id_cherry)
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getDataGreenBeanHandPick(id_gabahK):
query = "SELECT berat_kg,biaya,tanggal FROM biaya JOIN hand_pick ON biaya.id_biaya = hand_pick.id_biaya JOIN green_bean ON green_bean.id_bean = hand_pick.id_bean WHERE id_gabahK = "+str(id_gabahK)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getDataGabahKeringJemur(id_gabahB):
query = "SELECT berat_kg,biaya FROM biaya JOIN jemurK ON biaya.id_biaya = jemurK.id_biaya JOIN gabah_kering ON gabah_kering.id_gabahK = jemurK.id_gabahK WHERE id_gabahB = "+str(id_gabahB)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def getPanen(tanggal,blok,varietas,tipe_proses):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "SELECT id_cherry,panen.id_panen,status,jumlah_kg,harga_kg FROM panen JOIN cherry ON cherry.id_panen = panen.id_panen WHERE tanggal='{}' AND blok = '{}' AND varietas='{}' AND tipe_proses='{}'".format(tanggal,blok,varietas,tipe_proses)
#query = "SELECT * from cherry WHERE id_panen =({})".format(sub_query)
#query = "SELECT DATE_FORMAT(waktu,'%d/%m/%Y') as 'tanggal' FROM biji_kopi HAVING tanggal BETWEEN '25/04/2020' AND '30/04/2020' "
print(query)
mycursor.execute(query)
try :
result = mycursor.fetchone()
return result
except:
return 0
def getTanggalTerakhir(id_panen):
query = """SELECT DATE_FORMAT(biaya.tanggal,'%d/%m/%Y') FROM biaya
JOIN hand_pick ON hand_pick.id_biaya = biaya.id_biaya
JOIN green_bean ON green_bean.id_bean = hand_pick.id_bean
JOIN gabah_kering ON gabah_kering.id_gabahK = green_bean.id_gabahK
JOIN gabah_basah ON gabah_basah.id_gabahB = gabah_kering.id_gabahB
JOIN cherry ON cherry.id_cherry = gabah_basah.id_cherry
WHERE cherry.id_panen = {} """.format(id_panen)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
try:
result = mycursor.fetchone()
return result
except:
return 0
def inputPanen(tanggal,blok,varietas,tipe_proses,berat,biaya):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "INSERT INTO panen (tanggal,blok,varietas,tipe_proses) VALUES (%s,%s,%s,%s)"
val = (tanggal,blok,varietas,tipe_proses)
mycursor.execute(query,val)
conn.commit()
if mycursor.rowcount == 1:
query = "INSERT INTO cherry (id_panen,jumlah_kg,harga_kg) VALUES (%s,%s,%s)"
val = (mycursor.lastrowid,berat,biaya)
mycursor.execute(query,val)
conn.commit()
if mycursor.rowcount == 1:
print("Data Added")
else:
print("FAILED")
else:
print("FAILED")
def inputGabahBasahJemur(id_gabahB,berat,harga,tanggal,id_panen):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "INSERT INTO biaya (berat_kg,biaya,tanggal) VALUES (%s,%s,%s)"
val = (berat,harga,tanggal)
try:
mycursor.execute(query,val)
if mycursor.rowcount == 1:
id_biaya = mycursor.lastrowid
query = "INSERT INTO jemurB (id_gabahB,id_biaya) VALUES (%s,%s)"
val = (id_gabahB,id_biaya)
mycursor.execute(query,val)
if mycursor.rowcount == 1:
query = "UPDATE panen SET status='gb_jemur' WHERE id_panen = "+str(id_panen)
mycursor.execute(query)
conn.commit()
print("DATA ADDED")
except mysql.connector.Error as err:
print(err)
def inputWetMill(id_cherry,berat,harga,tanggal,id_panen):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "INSERT INTO biaya (berat_kg,biaya,tanggal) VALUES (%s,%s,%s)"
val = (berat,harga,tanggal)
try:
mycursor.execute(query,val)
if mycursor.rowcount == 1:
query = "INSERT INTO wetmill (id_cherry,id_biaya) VALUES (%s,%s)"
val = (str(id_cherry),str(mycursor.lastrowid))
mycursor.execute(query,val)
if mycursor.rowcount == 1:
print("WETMILL SUKSES")
query = "UPDATE panen SET status='wetmill' WHERE id_panen = "+str(id_panen)
mycursor.execute(query)
conn.commit()
print("Data Added")
except mysql.connector.Error as err:
print(err)
def inputTransport(id_cherry,berat,harga,tanggal,id_panen):
conn = connection.koneksi()
mycursor = conn.cursor()
query = "INSERT INTO biaya (berat_kg,biaya,tanggal) VALUES (%s,%s,%s)"
val = (berat,harga,tanggal)
try:
mycursor.execute(query,val)
if mycursor.rowcount == 1:
id_biaya = mycursor.lastrowid
query = "INSERT INTO gabah_basah (id_cherry) VALUES ({})".format(id_cherry)
mycursor.execute(query)
if mycursor.rowcount == 1:
query = "INSERT INTO transport (id_gabahB,id_biaya) VALUES (%s,%s)"
val = (mycursor.lastrowid,id_biaya)
mycursor.execute(query,val)
if mycursor.rowcount == 1:
query = "UPDATE panen SET status='transport' WHERE id_panen = "+str(id_panen)
mycursor.execute(query)
conn.commit()
print("DATA ADDED")
except mysql.connector.Error as err:
print(err)
def getDataSubProcess(status,tipe_proses,id_panen,focus):
if focus:
query = """SELECT `biaya`.`berat_kg`, `biaya`.`biaya`"""
else :
query = """SELECT SUM(`biaya`.`berat_kg`) AS 'berat total', SUM(`biaya`.`biaya`) AS 'Total Biaya' """
if status == "cherry":
query += """
FROM `biaya`
WHERE berat_kg = 0"""
#print(query,"KA")
elif status == "wetmill":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
WHERE (`panen`.`id_panen` = {})
AND (`biaya`.`id_biaya` = `wetmill`.`id_biaya`)""".format(id_panen)
print(query)
elif status == "transport":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`))""".format(id_panen)
elif status == "bongkar":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`))""".format(id_panen)
elif status == "gb_jemur":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`))""".format(id_panen)
elif status == "gk_hull":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`))""".format(id_panen)
elif status == "gk_jemur":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `jemurK` ON (`jemurK`.`id_gabahK`= `gabah_kering`.`id_gabahK`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurK`.`id_biaya`))""".format(id_panen)
elif status == "green_suton":
if tipe_proses != "Wet Hull" or tipe_proses != "Natural Wet Hull" or tipe_proses != "Honey Wet Hull":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`))""".format(id_panen)
else:
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `jemurK` ON (`jemurK`.`id_gabahK`= `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurK`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`))""".format(id_panen)
elif status == "green_grading":
if tipe_proses != "Wet Hull" or tipe_proses != "Natural Wet Hull" or tipe_proses != "Honey Wet Hull":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)) """.format(id_panen)
else:
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `jemurK` ON (`jemurK`.`id_gabahK`= `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurK`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)) """.format(id_panen)
elif status == "green_color":
if tipe_proses != "Wet Hull" or tipe_proses != "Natural Wet Hull" or tipe_proses != "Honey Wet Hull":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
JOIN `sorter` ON (`sorter`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)
OR (`biaya`.`id_biaya` = `sorter`.`id_biaya`)) """.format(id_panen)
else:
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
JOIN `sorter` ON (`sorter`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurK`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)
OR (`biaya`.`id_biaya` = `sorter`.`id_biaya`)) """.format(id_panen)
elif status == "green_hand_pick":
if tipe_proses != "Wet Hull" or tipe_proses != "Natural Wet Hull" or tipe_proses != "Honey Wet Hull":
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
JOIN `sorter` ON (`sorter`.`id_bean` = `green_bean`.`id_bean`)
JOIN `hand_pick` ON (`hand_pick`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)
OR (`biaya`.`id_biaya` = `sorter`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hand_pick`.`id_biaya`)) """.format(id_panen)
else:
query += """
FROM `biaya`
JOIN `panen`
JOIN `cherry` ON (`cherry`.`id_panen` = `panen`.`id_panen`)
JOIN `wetmill` ON (`cherry`.`id_cherry` = `wetmill`.`id_cherry`)
JOIN `gabah_basah` ON (`gabah_basah`.`id_cherry` = `cherry`.`id_cherry`)
JOIN `transport` ON (`transport`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `bongkar` ON (`bongkar`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `jemurB` ON (`jemurB`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `gabah_kering` ON (`gabah_kering`.`id_gabahB` = `gabah_basah`.`id_gabahB`)
JOIN `hull` ON (`hull`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `jemurK` ON (`jemurK`.`id_gabahK`= `gabah_kering`.`id_gabahK`)
JOIN `green_bean` ON (`green_bean`.`id_gabahK` = `gabah_kering`.`id_gabahK`)
JOIN `suton` ON (`suton`.`id_bean` = `green_bean`.`id_bean`)
JOIN `grading` ON (`grading`.`id_bean` = `green_bean`.`id_bean`)
JOIN `sorter` ON (`sorter`.`id_bean` = `green_bean`.`id_bean`)
JOIN `hand_pick` ON (`hand_pick`.`id_bean` = `green_bean`.`id_bean`)
WHERE (`panen`.`id_panen` = {})
AND ((`biaya`.`id_biaya` = `wetmill`.`id_biaya`)
OR (`biaya`.`id_biaya` = `transport`.`id_biaya`)
OR (`biaya`.`id_biaya` = `bongkar`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurB`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hull`.`id_biaya`)
OR (`biaya`.`id_biaya` = `jemurK`.`id_biaya`)
OR (`biaya`.`id_biaya` = `suton`.`id_biaya`)
OR (`biaya`.`id_biaya` = `grading`.`id_biaya`)
OR (`biaya`.`id_biaya` = `sorter`.`id_biaya`)
OR (`biaya`.`id_biaya` = `hand_pick`.`id_biaya`)) """.format(id_panen)
#print(query)
conn = connection.koneksi()
mycursor = conn.cursor()
mycursor.execute(query)
if focus :
try:
result = mycursor.fetchall()
return result
except:
return 0
else:
try:
result = mycursor.fetchone()
return result
except:
return 0
