SELECT ORR.*, S.PROPERTY, S.STOCK_CODE, S.BARCOD, S.MANUFACT_CODE, S.IS_INVENTORY, S.IS_PRODUCTION FROM ORDER_ROW ORR, STOCKS S WHERE ORR.ORDER_ID = #attributes.order_id# AND ORR.STOCK_ID = S.STOCK_ID ORDER BY ORR.ORDER_ROW_ID SELECT ASSET_FILE_NAME3 FROM OUR_COMPANY WHERE COMP_ID = #SESSION.EP.COMPANY_ID# COMP_ID = #SESSION.PP.COMPANY# SELECT MONEY_ID, MONEY FROM SETUP_MONEY WHERE COMPANY_ID = #SESSION.EP.COMPANY_ID# SELECT * FROM #dsn3_alias#.ORDERS WHERE ORDER_ID = #attributes.order_id# SELECT RATE1,RATE2,MONEY_TYPE FROM ORDER_MONEY WHERE MONEY_TYPE = '#get_order_detail.other_money#' AND ACTION_ID = #attributes.action_id# SELECT E.EMPLOYEE_NAME, E.EMPLOYEE_SURNAME FROM EMPLOYEES E WHERE E.EMPLOYEE_ID = #get_order_detail.order_employee_id# SELECT D.DEPARTMENT_ID, D.DEPARTMENT_HEAD, S.LOCATION_ID, S.COMMENT, D.BRANCH_ID FROM DEPARTMENT D, STOCKS_LOCATION S WHERE D.DEPARTMENT_ID = S.DEPARTMENT_ID AND D.DEPARTMENT_ID = #get_order_detail.deliver_dept_id# AND S.LOCATION_ID = #get_order_detail.location_id# SELECT PAYMETHOD FROM SETUP_PAYMETHOD WHERE PAYMETHOD_ID = #get_order_detail.paymethod# SELECT CARD_NO FROM CREDITCARD_PAYMENT_TYPE WHERE PAYMENT_TYPE_ID = #get_order_detail.card_paymethod_id# SELECT FULLNAME MEMBER_NAME, COMPANY_ADDRESS MEMBER_ADRESS, SEMT SEMT, COUNTY ILCE_ID, CITY IL_ID, COUNTRY ULKE_ID, COMPANY_TELCODE TELCODE, COMPANY_TEL1 TEL1, COMPANY_FAX FAKS, TAXOFFICE, TAXNO FROM COMPANY WHERE COMPANY_ID = #get_order_detail.company_id# SELECT CONSUMER_NAME + ' ' + CONSUMER_SURNAME MEMBER_NAME, TAX_ADRESS MEMBER_ADRESS, TAX_SEMT SEMT, TAX_COUNTY_ID ILCE_ID, TAX_CITY_ID IL_ID, TAX_COUNTRY_ID ULKE_ID, CONSUMER_WORKTELCODE TELCODE, CONSUMER_WORKTEL TEL1, CONSUMER_FAX FAKS, TAXOFFICE TAXOFFICE, TAXNO TAXNO FROM CONSUMER WHERE CONSUMER_ID = #get_order_detail.consumer_id# SELECT COUNTY_NAME FROM SETUP_COUNTY WHERE COUNTY_ID = #get_member_info.ilce_id# SELECT CITY_NAME FROM SETUP_CITY WHERE CITY_ID = #get_member_info.il_id# SELECT COUNTRY_NAME FROM SETUP_COUNTRY WHERE COUNTRY_ID = #get_member_info.ulke_id# SELECT * FROM ADDRESSBOOK WHERE PARTNER_ID = #get_order_detail.partner_id# SELECT * FROM COMPANY WHERE COMPANY_ID = #get_order_detail.company_id# SELECT COMPANY_PARTNER_NAME, COMPANY_PARTNER_SURNAME FROM COMPANY_PARTNER WHERE COMPANY_ID = #get_order_detail.company_id# SELECT * FROM SHIP_METHOD WHERE SHIP_METHOD_ID = #get_order_detail.ship_method# SELECT CONT_HEAD, CONT_SUMMARY, CONT_BODY FROM CONTENT WHERE CONTENT_ID = 6124 SELECT * FROM EMPLOYEE_POSITIONS WHERE EMPLOYEE_ID = #get_order_detail.order_employee_id# SELECT * FROM EMPLOYEE_POSITIONS WHERE POSITION_CODE = #amir_cek.upper_position_code# sepet_total = 0; sepet_toplam_indirim = 0; sepet_total_tax = 0; sepet_net_total = 0; #icerikten_cek.CONT_BODY#

SİPARİŞ ONAY FORMU

Sipariş No

#get_order_detail.order_number#

Sipariş Tarihi

#dateformat(dateadd('h',session.ep.time_zone,get_order_detail.order_date),'dd/mm/yyyy')#

Teslim Tarihi

#DateFormat(get_order_detail.deliverdate,'dd/mm/yyyy')#

KURUM/KURULUŞ BİLGİLERİ

Sayın;#person_name_cek.AB_NAME# #person_name_cek.AB_SURNAME#

Kurum/Kuruluş

#adamin_adi.MEMBER_CODE# - #fatura_verilen#

Kurum/Kuruluş Adresi

#adres# #semt# #ilce# #sehir#

Teslimat Adresi

#get_order_detail.ship_address#

Telefon

#telefon#

Faks

#faks#

Vergi Dairesi

#vergi_dairesi#

Vergi Numarası

#vergi_no#

Açıklama

#get_order_detail.order_detail#

Kayıt Saati	#timeformat(dateadd('h',session.ep.time_zone,get_order_detail.record_date),'HH:MM')#	Depo	#UCase(get_store.department_head)#	Ödeme Yöntemi	#get_paymethod_name.paymethod# #get_card_paymethod_name.card_no#
Fatura Kuru	#get_money.rate1# / #TLFormat(get_money.rate2,4)# (TL) #get_money.rate1# / #TLFormat(get_money.rate2,4)#	Vade Tarihi	#dateformat(get_order_detail.due_date,'dd/mm/yyyy')#	Sevk Yöntemi	#sip_metod.ship_method#

SİPARİŞE ESAS ÜRÜN VE HİZMETLER

Stok Kodu

Ürün

Miktar

B.Fiyat

Toplam

SİPARİŞİ HAZIRLAYAN #satis_yapan# İmza ve Kaşe	SİPARİŞİ ONAYLAYAN #amirin_adini_cek.employee_name# #amirin_adini_cek.employee_surname# #satis_yapan# İmza ve Kaşe	MÜŞTERİ ONAYI #person_name_cek.AB_NAME# #person_name_cek.AB_SURNAME# İmza ve Kaşe
Sayfa pageNumberText/#totalPageNumber#

if (not len(QUANTITY)) QUANTITY = 1; if (not len(PRICE)) price = 0; tax_percent = TAX; if (not len(discount_1)) indirim1 = 0; else indirim1 = discount_1; if (not len(discount_2)) indirim2 = 0; else indirim2 = discount_2; if (not len(discount_3)) indirim3 = 0; else indirim3 = discount_3; if (not len(discount_4)) indirim4 = 0; else indirim4 = discount_4; if (not len(discount_5)) indirim5 = 0; else indirim5 = discount_5; indirim6 = 0; indirim7 = 0; indirim8 = 0; indirim9 = 0; indirim10 = 0; indirim_carpan = (100-indirim1) * (100-indirim2) * (100-indirim3) * (100-indirim4) * (100-indirim5); other_money_value = price_other; other_money_price = OTHER_MONEY_VALUE; net_maliyet = COST_PRICE; marj = MARJ; if(len(price_other)) other_money_rowtotal = price_other; else other_money_rowtotal = price; row_total = QUANTITY * price; row_nettotal = wrk_round((row_total/10000000000) * indirim_carpan); row_taxtotal = wrk_round(row_nettotal * (tax_percent/100)); row_lasttotal = row_nettotal + row_taxtotal; sepet_total = sepet_total + row_total; //subtotal_ sepet_toplam_indirim = sepet_toplam_indirim + wrk_round(row_total) - wrk_round(row_nettotal); //discount_ sepet_total_tax = sepet_total_tax + row_taxtotal; //totaltax_ sepet_net_total = sepet_net_total + row_lasttotal; //nettotal_ Sayfa Toplamı #TLFORMAT(sepet_total/get_money.rate2)# TL #get_order_row.other_money# Toplam #TLFORMAT(sepet_total/get_money.rate2)# TL #get_order_row.other_money# İskonto #TLFORMAT(sepet_toplam_indirim/get_money.rate2)# TL #get_order_row.other_money# Ara Toplam #TLFORMAT((sepet_total/get_money.rate2) - (sepet_toplam_indirim/get_money.rate2))# TL #get_order_row.other_money# KDV %20 #TLFORMAT(sepet_total_tax/get_money.rate2)# TL #get_order_row.other_money# Genel Toplam #TLFORMAT(sepet_net_total/get_money.rate2)# TL #get_order_row.other_money# #pageHeader# #pageRowHeader# SELECT MULTIPLIER FROM PRODUCT_UNIT WHERE PRODUCT_ID = #get_order_row.product_id# AND ADD_UNIT = 'Koli' ORDER BY PRODUCT_UNIT_ID DESC #STOCK_CODE# #PRODUCT_NAME# #QUANTITY# #UNIT# #TLFORMAT(PRICE/get_money.rate2)# TL #other_money# #TLFORMAT(row_nettotal/get_money.rate2)# TL #other_money# #documentTotal# #documentContent# #pageFooterReal# #pageHeader# #pageRowHeader# SELECT MULTIPLIER FROM PRODUCT_UNIT WHERE PRODUCT_ID = #get_order_row.product_id# AND ADD_UNIT = 'Koli' ORDER BY PRODUCT_UNIT_ID DESC #STOCK_CODE# #PRODUCT_NAME# #QUANTITY# #UNIT# #TLFORMAT(PRICE/get_money.rate2)# TL #other_money# #TLFORMAT(row_nettotal/get_money.rate2)# TL #other_money# #pageRowEmpty# #pageTotal# #pageFooterReal# #pageRowEmpty# #pageTotal# #pageFooterReal# #pageHeader# #pageRowHeader# SELECT MULTIPLIER FROM PRODUCT_UNIT WHERE PRODUCT_ID = #get_order_row.product_id# AND ADD_UNIT = 'Koli' ORDER BY PRODUCT_UNIT_ID DESC #STOCK_CODE# #PRODUCT_NAME# #QUANTITY# #UNIT# #TLFORMAT(PRICE/get_money.rate2)# TL #other_money# #TLFORMAT(row_nettotal/get_money.rate2)# TL #other_money# #documentTotal# #documentContent# #pageFooterReal#