Türker Tunalı TurkerTunali
TurkerTunali
/ excel_download_client.js
Created
April 2, 2024 14:46
Excel Create and Download Frappe (ERPNext)
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.')" | |
| }, | |
| { |
TurkerTunali
/ AttachItemFiles.js
Last active
June 13, 2023 02:13
This client script will attach files from the items by types to the current document.
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) => { |
TurkerTunali
/ test1.json
Last active
March 18, 2022 19:01
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" | |
| }, |
TurkerTunali
/ LOGO_SATIS.sql
Created
December 29, 2021 13:39
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ı' |
TurkerTunali
/ test1.xml
Created
December 28, 2021 07:05
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]) |
TurkerTunali
/ Tur rapor.sql
Created
February 27, 2021 07:56
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, |
TurkerTunali
/ ConsolidatedRunningBalance.sql
Last active
July 21, 2020 16:18
Running balance report for customer and suppliers combined by tax id
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. |
TurkerTunali
/ Test2
Created
March 25, 2020 15:22
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