Python Document.posting_date方法代码示例

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
def create_advance_entry(advance_amount, customer_name, debit_to, company):
	jv = Document('Journal Voucher')
	jv.voucher_type = 'Cash Voucher'
	jv.user_remark = 'Advance Payment'
	jv.fiscal_year = webnotes.conn.get_value('Global Defaults',None,'current_fiscal_year')
	jv.user_remark = "Advance from patient %s"%customer_name
	jv.remark = "User Remark : Advance from patient %s"%customer_name
	jv.company = company
	jv.posting_date = nowdate()
	jv.docstatus=1
	jv.save()

	chld1 = Document('Journal Voucher Detail')
	chld1.parent = jv.name
	chld1.account = debit_to
	chld1.cost_center = webnotes.conn.get_value('Company',company,'cost_center')
	chld1.credit = advance_amount
	chld1.is_advance = 'Yes'
	chld1.save()

	chld2 = Document('Journal Voucher Detail')
	chld2.parent = jv.name
	chld2.account = webnotes.conn.get_value('Company',company,'default_cash_account')
	chld2.cost_center = webnotes.conn.get_value('Company',company,'cost_center')
	chld2.debit = advance_amount
	chld2.save()

	create_gl_entry(jv.name, jv.user_remark, company)

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def make_bank_voucher(self):
		self.set_flag()
		"""
			get default bank account,default salary acount from company
		"""
		#amt = self.get_total_salary()
		com = webnotes.conn.sql("""select default_bank_account, default_expense_account from `tabCompany` 
			where name = '%s'""" % self.doc.company,as_list=1)		

		if not com[0][0] or not com[0][1]:
			msgprint("You can set Default Bank Account in Company master.")
		if not self.doc.jv:
			jv = Document('Journal Voucher')
			jv.voucher_type = 'Bank Voucher'
			jv.user_remark = 'Referrals Payment'
			jv.fiscal_year = '2013-14'
			jv.total_credit = jv.total_debit = self.doc.total_amount
			jv.company = self.doc.company
			jv.posting_date = nowdate()
			jv.save()
		
			jvd = Document('Journal Voucher Detail')
			jvd.account = com and com[0][0] or ''
			jvd.credit =  self.doc.total_amount
			jvd.parent = jv.name
			jvd.save()

			jvd1 = Document('Journal Voucher Detail')
			jvd1.account = com and com[0][1] or ''
			jvd1.debit = self.doc.total_amount
			jvd1.parent = jv.name
			jvd1.save()
		
			self.doc.jv = jv.name	
			self.doc.save()

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
    def upload_accounts_transactions(self):
        import csv

        data = csv.reader(self.get_csv_data().splitlines())

        abbr = sql("select concat(' - ',abbr) as abbr from tabCompany where name=%s", self.doc.company)
        updated = 0
        jv_name = ""
        # 		jv = Document('Journal Voucher')
        global line, jv, name, jv_go
        for line in data:
            if len(line) >= 7:  # Minimum no of fields
                if line[3] != jv_name:  # Create JV
                    if jv_name != "":
                        jv_go = get_obj("Journal Voucher", name, with_children=1)
                        jv_go.validate()
                        jv_go.on_submit()

                    jv_name = line[3]
                    jv = Document("Journal Voucher")
                    jv.voucher_type = line[0]
                    jv.naming_series = line[1]
                    jv.voucher_date = formatdate(line[2])
                    jv.posting_date = formatdate(line[2])
                    # 					jv.name = line[3]
                    jv.fiscal_year = self.doc.fiscal_year
                    jv.company = self.doc.company
                    jv.remark = len(line) == 8 and line[3] + " " + line[7] or line[3] + " Uploaded Record"
                    jv.docstatus = 1
                    jv.save(1)
                    name = jv.name

                    jc = addchild(jv, "entries", "Journal Voucher Detail", 0)
                    jc.account = line[4] + abbr[0][0]
                    jc.cost_center = len(line) == 9 and line[8] or self.doc.default_cost_center
                    if line[5] != "":
                        jc.debit = line[5]
                    else:
                        jc.credit = line[6]
                    jc.save()

                else:  # Create JV Child
                    jc = addchild(jv, "entries", "Journal Voucher Detail", 0)
                    jc.account = line[4] + abbr[0][0]
                    jc.cost_center = len(line) == 9 and line[8] or self.doc.default_cost_center
                    if line[5] != "":
                        jc.debit = line[5]
                    else:
                        jc.credit = line[6]
                    jc.save()
            else:
                msgprint("[Ignored] Incorrect format: %s" % str(line))
        if jv_name != "":
            jv_go = get_obj("Journal Voucher", name, with_children=1)
            jv_go.validate()
            jv_go.on_submit()

        msgprint("<b>%s</b> items updated" % updated)

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
 def allocate_leave(self):
   self.validate_values()
   for d in self.get_employees():
     la = Document('Leave Allocation')
     la.employee = cstr(d[0])
     la.employee_name = webnotes.conn.get_value('Employee',cstr(d[0]),'employee_name')
     la.leave_type = self.doc.leave_type
     la.fiscal_year = self.doc.fiscal_year
     la.posting_date = nowdate()
     la.carry_forward = cint(self.doc.carry_forward)
     la.new_leaves_allocated = flt(self.doc.no_of_days)
     la_obj = get_obj(doc=la)
     la_obj.doc.docstatus = 1
     la_obj.validate()
     la_obj.on_update()
     la_obj.doc.save(1)
   msgprint("Leaves Allocated Successfully")

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def create_gl(self,data):
		for r in data:
			gl=Document("GL Entry")
			gl.account=r['account']
			gl.debit=r['debit']
			gl.credit=r['credit']
			gl.against=r['against']
			gl.against_voucher_type=r['against_voucher_type']
			gl.voucher_type=r['voucher_type']
			gl.against_voucher=r['against_voucher']
			gl.voucher_no=r['voucher_no']
			gl.cost_center=r['cost_center']
			gl.posting_date=nowdate()
			gl.aging_date=nowdate()
			gl.fiscal_year=webnotes.conn.get_value("Global Defaults",None,"current_fiscal_year")
			gl.company='InnoWorth'
			gl.is_opening='No'
			gl.save()

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def make_JV1(self,sum_patient_amt,debit_to,patient_credit_to,company):
		jv=Document('Journal Voucher')
                jv.voucher_type='Bank Voucher'
                jv.posting_date=nowdate()
                jv.user_remark ='Payment Entry against '+self.doc.name
                jv.fiscal_year = '2013-14'
                jv.total_credit = jv.total_debit = sum_patient_amt
                jv.company = company
                jv.save()

                jvd = Document('Journal Voucher Detail')
                jvd.account = debit_to
                jvd.credit =  sum_patient_amt
		jvd.against_invoice=self.doc.name
                jvd.parent = jv.name
                jvd.save()

                jvd1 = Document('Journal Voucher Detail')
                jvd1.account = patient_credit_to
                jvd1.debit = sum_patient_amt
                jvd1.parent = jv.name
                jvd1.save()

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def calculate_variable(self):
		sales_persons=webnotes.conn.sql('select distinct sales_person from `tabSales Team`',as_list=1)
		sp_variable_pay={}
		if sales_persons:
			for person in sales_persons:
				sp_variable_pay[person[0]]=0.0
				fiscal_year=webnotes.conn.sql("select name from `tabFiscal Year`",as_list=1)
				if fiscal_year:
					for year in fiscal_year:
						i=1
						for qtr_month in range(i,5):
							month=self.months.get(cint(qtr_month))
							if month:
								i=i+3
								sales_persons_details=webnotes.conn.sql("""select sum(amount)
									from `tabVariable Pay Summary` where sales_person='%s' and fiscal_year='%s' and quater='%s' 
									and status='False'"""%(person[0],year[0],month),as_list=1)
								if sales_persons_details:
									for total_jv in sales_persons_details:
										target_details=self.target_all_details(person[0],year[0],month)
										if target_details:
											for detail in target_details:
												webnotes.conn.sql("update `tabVariable Pay Summary` set status='True' where sales_person='%s' and fiscal_year='%s' and quater='%s'"%(person[0],year[0],month))
												quater_target_amount=flt(detail[0])*flt(detail[1])/flt(100)
												quater_target_variable_pay=flt(detail[2])*flt(detail[1])/flt(100)
												sp_variable_pay[person[0]]+=flt(total_jv[0])*quater_target_variable_pay/quater_target_amount
				if sp_variable_pay[person[0]]:
					m=cint(self.to_date().month)
					spv=Document('Sales Person Variable Pay')
					spv.sales_person=person[0]
					spv.posting_date=nowdate()
					if self.fiscal_year:
						spv.fiscal_year=self.fiscal_year[0][0]
					spv.variable_pay=sp_variable_pay[person[0]]
					spv.month = '0'+cstr(m) if m in range(1,9) else m
					spv.status='False'
					spv.save()
		webnotes.conn.sql("commit")

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def make_JV(self,amount,referrer_physician_credit_to,referrer_physician_debit_to,company):
		
		jv=Document('Journal Voucher')
		jv.voucher_type='Bank Voucher'
		jv.posting_date=nowdate()
		jv.user_remark = 'Referrals Payment against bill '+ self.doc.name
		jv.fiscal_year = '2013-14'
		jv.total_credit = jv.total_debit = amount
		jv.company = company
		jv.against_bill = self.doc.name
		jv.save()

		jvd = Document('Journal Voucher Detail')
		jvd.account = referrer_physician_credit_to
		jvd.debit =  amount
		jvd.parent = jv.name
		jvd.save()

		jvd1 = Document('Journal Voucher Detail')
		jvd1.account = referrer_physician_debit_to
		jvd1.credit = amount
		jvd1.parent = jv.name
		jvd1.save()

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
def post_jv(data):
	jv = Document('Journal Voucher')
	jv.voucher_type = data.get('voucher_type')
	jv.naming_series = data.get('naming_series')
	jv.voucher_date = data.get('cheque_date')
	jv.posting_date = data.get('cheque_date')
	jv.cheque_no = data.get('cheque_number')
	jv.cheque_date = data.get('cheque_date')
	jv.fiscal_year = data.get('fiscal_year') # To be modified to take care
	jv.company = data.get('company')

	jv.save(1)

	jc = addchild(jv,'entries','Journal Voucher Detail',0)
	jc.account = data.get('debit_account')
	jc.debit = data.get('amount')
	jc.save()

	jc = addchild(jv,'entries','Journal Voucher Detail',0)
	jc.account = data.get('credit_account')
	jc.credit = data.get('amount')
	jc.save()

	return jv.name

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
 def make_ledger(self):
         from webnotes.model.doc import Document
         for d in getlist(self.doclist, 'entries'):
                 check=webnotes.conn.sql("select status from `tabSerial No` where name='"+(d.serial_no).strip()+"'",as_list=1)
                 if check[0][0]=='Available':
                         sle=Document('Stock Ledger Entry')
                         sle.item_code=d.item_code
                         sle.serial_no=d.serial_no
                         sle.posting_date=nowdate()
                         sle.posting_time=nowtime()
                         sle.actual_qty=-d.qty
                         qty_data=webnotes.conn.sql("select b.actual_qty,foo.warehouse from(select item_code,warehouse from `tabSerial No` where name='"+(d.serial_no).strip()+"') as foo,tabBin as b where b.item_code=foo.item_code and b.warehouse=foo.warehouse",as_list=1,debug=1)
                         after_transfer=cstr(flt(qty_data[0][0])-flt(d.qty))
                         update_bin=webnotes.conn.sql("update `tabBin` set actual_qty='"+after_transfer+"', projected_qty='"+after_transfer+"' where item_code='"+d.item_code+"' and warehouse='"+qty_data[0][1]+"'")
                         sle.qty_after_transaction=after_transfer
                         sle.warehouse=qty_data[0][1]
                         sle.voucher_type='Delivery Note'
                         sle.voucher_no='GRN000056'
                         sle.stock_uom=webnotes.conn.get_value("Item",d.item_code,"stock_uom")
                         sle.company='PowerCap'
                         sle.fiscal_year=webnotes.conn.get_value("Global Defaults", None, "current_fiscal_year")
                         update_serial=webnotes.conn.sql("update `tabSerial No` set status='Delivered',warehouse=(select name from tabCustomer where 1=2) where name='"+(d.serial_no).strip()+"'")
                         sle.docstatus=1
                         sle.save()

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
def post_jv(data):
    jv = Document("Journal Voucher")
    jv.voucher_type = data.get("voucher_type")
    jv.naming_series = data.get("naming_series")
    jv.voucher_date = data.get("cheque_date")
    jv.posting_date = data.get("cheque_date")
    jv.cheque_no = data.get("cheque_number")
    jv.cheque_date = data.get("cheque_date")
    jv.fiscal_year = data.get("fiscal_year")  # To be modified to take care
    jv.company = data.get("company")

    jv.save(1)

    jc = addchild(jv, "entries", "Journal Voucher Detail", 0)
    jc.account = data.get("debit_account")
    jc.debit = data.get("amount")
    jc.save()

    jc = addchild(jv, "entries", "Journal Voucher Detail", 0)
    jc.account = data.get("credit_account")
    jc.credit = data.get("amount")
    jc.save()

    return jv.name

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
        def sle(self):
                make_bin=[]
		qry="select sum(actual_qty) from `tabStock Ledger Entry` where item_code='"+self.doc.item+"' and warehouse='Finished Goods - P'"	          
                #ebnotes.errprint(qry)
	        w3=webnotes.conn.sql(qry)
	        qty_after_transaction=cstr(cint(w3[0][0])+cint(self.doc.quantity))
	        actual_qty=self.doc.quantity
                import time
	        tim=time.strftime("%X")	   
                from webnotes.model.doc import Document     
		d = Document('Stock Ledger Entry')
		d.item_code=self.doc.item
		d.batch_no=self.doc.name
		d.stock_uom='Nos'
		d.warehouse='Finished Goods - P'
		d.actual_qty=actual_qty
		d.posting_date=today()
		d.posting_time=tim
                d.voucher_type='Purchase Receipt'
                d.serial_no=self.doc.serial_no.replace('\n','')
		d.qty_after_transaction=qty_after_transaction
		d.is_cancelled = 'No'
                d.company='PowerCap'
		d.docstatus = 1;
		d.name = 'Batch wise item updation'
		d.owner = webnotes.session['user']
		d.fields['__islocal'] = 1 
		d.save(new=1)
                make_bin.append({
                       "doctype": 'b',
                       "sle_id":d.name,
                       "item_code": self.doc.item,
		       			"warehouse": 'Finished Goods - P',
		       			"actual_qty": actual_qty 
		       			
		       })

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
	def set_actual_qty(self):
		from webnotes.utils import get_first_day, get_last_day, add_to_date, nowdate, getdate
        	today = nowdate()


		for p in getlist(self.doclist, 'item_details_table'):
			qr=webnotes.conn.sql(""" select is_asset_item from `tabItem` where item_code=%s""",p.item)
			if qr[0][0] =='No':
				#webnotes.errprint("Is not asset item")

				qry=webnotes.conn.sql("""select sum(actual_qty) from `tabStock Ledger Entry` where item_code=%s
					and warehouse=%s""",
					(p.item,p.warehouse))
				#webnotes.errprint(qry)
				qty_after_transaction=cstr(cint(qry[0][0])-cint(p.quantity))
				actual_qty=cstr(0-cint(p.quantity))
				tim=time.strftime("%X")
				#webnotes.errprint(qty_after_transaction)
	
				if cint(qty_after_transaction) < 0:
				
					webnotes.throw("Not enough quantity available at specified Warehouse for item=" +cstr(p.item))
				else:
					#webnotes.errprint("in stock ledger entry")							
					d = Document('Stock Ledger Entry')
					d.item_code=p.item
					#d.batch_no=p.batch_no
					d.actual_qty=actual_qty
					#webnotes.errprint(actual_qty)
					d.qty_after_transaction=qty_after_transaction
					#webnotes.errprint(d.qty_after_transaction)
					#d.stock_uom=p.product_uom
					d.warehouse=p.warehouse
					d.voucher_type='Project Management'
					#webnotes.errprint(d.voucher_type)
					#d.valuation_rate=p.product_rate
					#d.stock_value=p.quantity
					d.posting_date=today
					#webnotes.errprint(d.posting_date)
					#webnotes.errprint(d.posting_date)
					d.posting_time=tim
					#d.save()
					d.docstatus = 1;
					#d.name = 'SLE/00000008'
					d.owner = webnotes.session['user']
					d.fields['__islocal'] = 1
					d.voucher_no = self.doc.name
					d.voucher_detail_no =p.name
					d.save()
					a=webnotes.conn.sql("select actual_qty,projected_qty from`tabBin` where item_code='"+p.item+"'  and warehouse='"+p.warehouse+"'",as_list=1,debug=1)
					#webnotes.errprint(a)
					#webnotes.errprint(a[0][0])
					#webnotes.errprint(a[0][1])
					if a:

						actual_qty=cstr(cint(a[0][0])-cint(p.quantity))
						projected_qty=cstr(cint(a[0][0])-cint(p.quantity))
						q=webnotes.conn.sql("update `tabBin` set actual_qty=%s,Projected_qty=%s where item_code='"+p.item+"' and warehouse='"+p.warehouse+"'",(actual_qty,projected_qty),debug=1)
					else:
						pass	
					#webnotes.errprint("Updated")
					#make_bin.append({
					#	"doctype": 'pm',
					#	"sle_id":d.name,
					#	"item_code": p.item,
					#	"warehouse": p.warehouse,
					#	"actual_qty": cstr(0-cint(p.quantity))
					#	
					#})
			else:
				pass

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
def create_invoice(auth_key,invoice_type,customer,serial_number,dattime,_type='POST'):
	login =[]
	loginObj = {}
	if len(auth_key[1:-1])<=0 or len(dattime[1:-1])<=0 or len(customer[1:-1])<=0 or len(serial_number[1:-1])<=0 :
		loginObj['status']='401'
		loginObj['error']='Incomplete data to generate Sales Invoice , Please provide token no , Datetime,customer and serial no'
		return loginObj
	qr="select name from `tabauth keys` where auth_key="+auth_key
	res=webnotes.conn.sql(qr)
	rgn=webnotes.conn.sql("select region from `tabFranchise` where contact_email='"+res[0][0]+"'")
	zz=serial_number[1:-1].count(' ')
	xx=serial_number[1:-1].replace('[','').split(' ')
	#xxx=xx.replace(' ','\n')
	yy="select item_code,item_name,description from `tabSerial No` where name='"+cstr(xx[0])+"'"
	zzz=webnotes.conn.sql(yy)
	if not zzz:
          loginObj['status']='402'
          loginObj['error']='Invalid serails no, please try againg'
          return loginObj
	pp="select ref_rate from `tabItem Price` where price_list='Standard Selling' and item_code='"+zzz[0][0]+"'"
	ppp=webnotes.conn.sql(pp)
	if res:
		from webnotes.model.doc import Document
		d = Document('Sales Invoice')
		d.customer=customer[1:-1]
		d.customer_name=customer[1:-1]
		d.region=rgn[0][0]
		d.posting_date=dattime[1:-1]
		d.due_date=dattime[1:-1]
		d.selling_price_list='Standard Selling'
		d.currency='INR'
		d.territory='India'
		if ppp:
			d.net_total_export=ppp[0][0]*zz
			d.grand_total_export=ppp[0][0]*zz
			d.rounded_total_export=ppp[0][0]*zz
			d.outstanding_amount=ppp[0][0]*zz
		d.plc_conversion_rate=1
		from webnotes.utils import nowdate
  		from accounts.utils import get_fiscal_year
   		today = nowdate()
		d.fiscal_year=get_fiscal_year(today)[0]
		d.debit_to=customer[1:-1]+" - P"
		d.is_pos=1
		d.cash_bank_account='Cash - P'
                d.save()
		webnotes.conn.commit()
		e=Document('Sales Invoice Item')
		e.item_code=zzz[0][0]
		e.item_name=zzz[0][1]
		e.description=zzz[0][2]
		e.qty=zz
		e.stock_uom='Nos'
		if ppp:
			e.ref_rate=ppp[0][0]
			e.export_rate=ppp[0][0]
		e.export_amount='0'
		e.income_account='Sales - P'
		e.cost_center='Main - P'
		e.serial_no_=serial_number[1:-1].replace('[','').replace(']','')
		e.parent=d.name
		e.parenttype='Sales Invoice'
		e.parentfield='entries'
		e.save()
		webnotes.conn.commit()
		key={}
		key['invoice_id_id']=d.name
		login.append(key)
		loginObj['status']='200'
		loginObj['invoice']=login
		return loginObj
	else:
		loginObj['status']='401'
		loginObj['error']='invalid token please contact administrator'
		return loginObj

# 需要导入模块: from webnotes.model.doc import Document [as 别名]
# 或者: from webnotes.model.doc.Document import posting_date [as 别名]
def create_in(data,_type='POST'):
	from webnotes.model.doc import Document
	from webnotes.utils import nowdate,add_months
        data1=json.loads(data)	
        auth_key=data1['token']
        invoice_type=data1['invoice_type']
        customer=data1['customer']
        dattime=data1['datetime']
        item_details=data1['item_details']
        login =[]
        loginObj = {}
	amt=0
        qt=0
        srl=''
        cc=''
        zz=''
	#return data
        if len(auth_key[1:-1]) <=0 or len(dattime[1:-1]) <=0 or len(customer[1:-1])<=0 :
                loginObj['status']='401'
                loginObj['error']='Incomplete data to generate Sales Invoice , Please provide token no , Datetime,customer and serial no'
                return loginObj
 	
        for ff in item_details:
                   a=ff['barcode']
                   c="select item_code,warehouse from `tabSerial No` where name='"+a[:-1]+"'"
                   cc=webnotes.conn.sql(c)
		   #webnotes.errprint(c)
		   #webnotes.errprint(cc)
                   amt=cint(amt)+cint(ff['rate'])
                   qt+=1
                   srl+=a[:-2].replace(',','\n')
		   #return cc
                   if cc :
			qr="select name from `tabauth keys` where auth_key='"+auth_key+"'"
			#return qr
			res=webnotes.conn.sql(qr)
			if res :
		           rr="select region from `tabFranchise` where contact_email='"+res[0][0]+"'"
                           r1=webnotes.conn.sql(rr)
			   if r1[0][0]==cc[0][1] :
				#webnotes.errprint("same")
				pass
			   else:
				#webnotes.errprint("different warehouse")
				pass
				
                        zz+="'"+a[:-1].replace(',','')+"',"
                   else:
                   	if invoice_type=='CUSTOMER':
				l = Document('Customer Details',customer)
		                l.customer_name=customer
		                l.save()
		                webnotes.conn.commit()
				for ll in item_details:
				   m = Document('Customer Data')
				   m.serial_no=a[:-1]
		                   m.parent=l.name
		                   m.parenttype='Customer Details'
		                   m.parentfield='customer_data'
			           m.save(new=1)
				   webnotes.conn.commit()			
			qrt="select name from `tabauth keys` where auth_key='"+auth_key+"'"
		        res=webnotes.conn.sql(qrt)
        		net=0
		        if res:
                		a="select name from tabCustomer where name='"+customer+"'"
		                b=webnotes.conn.sql(a)
		                if b:
		                        a=''
		                else:
                		        d = Document('Customer')
                		        d.customer_name=customer
		                        d.name=customer
                		        d.save(new=1)
                		        webnotes.conn.commit()
               		qr="select name from `tabauth keys` where auth_key='"+auth_key+"'"
               		#webnotes.errprint(qr)
			res=webnotes.conn.sql(qr)
			rgn=''
			if res :
		           rr="select region from `tabFranchise` where contact_email='"+res[0][0]+"'"
		           #webnotes.errprint(qr)
                           r1=webnotes.conn.sql(rr,as_list=1)
                           #webnotes.errprint(r1[0][0])			   
                	d = Document('Sales Invoice')
	                d.customer=customer
	                d.customer_name=customer
        	        d.posting_date=dattime[1:-1]
        	        d.due_date=dattime[1:-1]
        	        d.remarks='Invalid QR code'
        	        d.selling_price_list='Standard Selling'
        	        d.currency='INR'
        	        if r1:
        	        	d.territory=r1[0][0]
        	        	d.region=r1[0][0]
        	        d.net_total_export=0
        	        d.grand_total_export=0
        	        d.rounded_total_export=0
        	        d.plc_conversion_rate=1			
        	        from webnotes.utils import nowdate
#.........这里部分代码省略.........