This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
frappe.ui.form.on('Sevkiyat', { | |
refresh: function(frm) { | |
frm.add_custom_button('Çeki Listesi Oluştur', async function() { | |
let columns = ["Batch", "Item Code", "Roll ID", "Customer", "Sales Order", "Net Weight [Kg]", "Gross Weight [Kg]", "Meter [cm]", "Width [cm]", "Diameter [cm]"]; | |
let data = []; | |
for(let dItemIndex = 0; dItemIndex < frm.doc.shipment_detail.length; dItemIndex++) { | |
let docBatch = await frappe.db.get_doc("Batch", frm.doc.shipment_detail[dItemIndex].batch); | |
console.log(docBatch.reference_name); | |
let docWO = await frappe.db.get_value("Stock Entry", docBatch.reference_name, "work_order"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ "buttons": [ | |
{ | |
"text": "Google", | |
"onPress": "() => alertButtonPressed('Button google pressed.')" | |
}, | |
{ | |
"text": "Facebook", | |
"onPress": "() => alertButtonPressed('Button facebook pressed.')" | |
}, | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function GetFileAttachments(frm, arrItemCode) { | |
//Get files which are added to given items | |
frappe.db.get_list("File", { | |
filters: [ | |
['attached_to_name', 'in', arrItemCode], | |
['attached_to_doctype', '=', "Item"] | |
], | |
fields: ["file_name", "file_url", "folder"], | |
limit: 9999 | |
}).then((data) => { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"$jason": { | |
"head": { | |
"title": "Frappe Mobile" | |
}, | |
"body": { | |
"style": { | |
"border": "none", | |
"background": "#FFFFFF" | |
}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
YEAR(INVOICE.DATE_) Yıl, | |
ITEMS.CODE MLZ_KODU, | |
ITEMS.NAME MLZ_ADI, | |
CASE MONTH(INVOICE.DATE_) | |
WHEN 1 THEN '01.Ocak' WHEN 2 THEN '02.Şubat' WHEN 3 THEN '03.Mart' | |
WHEN 4 THEN '04.Nisan' WHEN 5 THEN '05.Mayıs' WHEN 6 THEN '06.Haziran' | |
WHEN 7 THEN '07.Temmuz' WHEN 8 THEN '08.Ağustos' WHEN 9 THEN '09.Eylül' | |
WHEN 10 THEN '10.Ekim' WHEN 11 THEN '11.Kasım' WHEN 12 THEN '12.Aralık' ELSE '' END AS [Ay], | |
CASE INVOICE.TRCODE WHEN 7 THEN 'Perakende Satış Faturası' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="ISO-8859-9"?> | |
<SALES_DISPATCHES> | |
<DISPATCH DBOP="INS"> | |
<TYPE>8</TYPE> | |
<NUMBER>TKI2021000002450</NUMBER> | |
<DATE>27.12.2021</DATE> | |
<TIME>186843136</TIME> | |
<DOC_NUMBER>TKI2021000002450</DOC_NUMBER> | |
<ARP_CODE>V0006-BUC</ARP_CODE> | |
<SOURCE_WH>2</SOURCE_WH> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
frappe.listview_settings['Purchase Order'] = { | |
button: { | |
show: function(doc) { | |
return true; | |
}, | |
get_label: function() { | |
return __('View'); | |
}, | |
get_description: function(doc) { | |
return __('Print {0}', [doc.name]) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
GEN_DATE.GEN_DATE, | |
LEFT(CUSTOMER.name, 29) AS CUSTOMER_NAME, | |
FORMAT(IFNULL(TGL.bakiye, 0), 2, 'tr_TR') AS BAKIYE, | |
/*PAYMENT_ENTRY.posting_date, | |
SALES_ORDER.transaction_date, | |
DELIVERY_NOTE.posting_date,*/ | |
#COALESCE(PAYMENT_ENTRY.posting_date, SALES_ORDER.transaction_date, DELIVERY_NOTE.posting_date) AS TRANSACTION_DATE, | |
FORMAT(SUM(CASE PAYMENT_ENTRY.mode_of_payment WHEN CONCAT('Kadir Kızıl', ' Nakit') THEN PAYMENT_ENTRY.paid_amount ELSE 0 END), 2, 'tr_TR') AS CASH, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
#LOGEDOSOFT-2019 | |
#Amac: Tedarici ve Satiscilari vergi numarasina gore gruplayarak cari ekstre gosterir | |
#Versiyonlar: | |
#21.12.2019:Alim fatura tarihi ellge girilen tedarikci fatura tarihinden getirildi. Tahsilat yapildiginda kapatilan fatura rakamlari getiriliyordu, direk tahsilat tutarinin getirilmesi saglandi | |
#27.12.2019:Fis turu alani duzgun getirildi. Gereksiz kolonlar kapatildi. | |
#27.12.2019:Satis fatura aciklamasi ozel alan olan aciklama alanindan getirildi(remarks alani kaldirildi) | |
#18.02.2020:Alim fatura aciklamasi getirildi (remarks kaldirildi) | |
#18.02.2020:Ceklerin vade tarihi aciklama alanina getirildi. | |
#25.02.2020:DÜZELTME: Belge Tarihi olarak posting_date, Açıklama da ki tarihe reference_date gelmeli. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/*LOGEDOSOFT 2020 | |
Amac: Alim irsaliyelerinde ambar ve malzeme karti kisitlamasi yapmak. | |
Detay: | |
- Alim irsaliyelerde sadece Ticari ve ham madde urunler gorunmeli. | |
https://app.asana.com/0/1159095102216267/1118662457336759/f | |
- Alim irsaliyelerde sadece Ticari malzeme ise sevk (Merkez, şube) ambarı görünmeli. HM. ise hm (Merkez, şube) ambarı görünmeli. | |
https://app.asana.com/0/1159095102216267/1118662457336758/f | |
*/ | |
frappe.ui.form.on('Purchase Receipt', { |
NewerOlder