Guys, PHP Help ekak one ?

[Chandi_Bandi]

Machanla , multiple invoice tikakata one time payment karanna query ekak kiyala denna puluwanda ? db eke thiyana rows update karanna one balance check kara kara. mama for loop ekaking wade patan gaththa. eth success naha.

ref link - https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

 

[Honey Bunch]

Bump chandi pando

 

[Chandi_Bandi]

bump

thnk you

---

Bump chandi pando

thnk you
------ Post added on Dec 6, 2021 at 7:21 AM

 

[Lakshan-Seram]

Terune na

joins hariyanne nedda?

 

[Mr Robot]

ube prashne pahadili naha

 

[Chandi_Bandi]

Terune na

joins hariyanne nedda?

Mekai case eka, Billing system ekaka pending invoices ( credit ) thiyanawane. mata eka section ekaking e credit customer wa thorala payment ekak karanna.

Menna me wage

mama me details ajax ekakin function ekakata pass kara gannawa.

Mata one payment amount eka total due ekin adu we wi pay wenna.

hithannako total due eka hadila thiyenne invoice 5 kin kiyala. api payment eka karaddi e invoice wala total amount eka payment eken adu we wi yannai mata one.

man kiyana eka wadiya therenne nathuwa athi. me stack eketh dala thiyenne ekamai.

https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

Please Help Guys

---

ube prashne pahadili naha

Mekai case eka, Billing system ekaka pending invoices ( credit ) thiyanawane. mata eka section ekaking e credit customer wa thorala payment ekak karanna.

Menna me wage

mama me details ajax ekakin function ekakata pass kara gannawa.

Mata one payment amount eka total due ekin adu we wi pay wenna.

hithannako total due eka hadila thiyenne invoice 5 kin kiyala. api payment eka karaddi e invoice wala total amount eka payment eken adu we wi yannai mata one.

man kiyana eka wadiya therenne nathuwa athi. me stack eketh dala thiyenne ekamai.

https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

Please Help Guys
------ Post added on Dec 6, 2021 at 8:13 AM

 

[hodakolla]

BUMPER

 

[Honey Bunch]

BUMPER

Hi

 

[hodakolla]

Hi

Hi honey

 

[kavindagk]

Machanla , multiple invoice tikakata one time payment karanna query ekak kiyala denna puluwanda ? db eke thiyana rows update karanna one balance check kara kara. mama for loop ekaking wade patan gaththa. eth success naha.

ref link - https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

Try this, its just high-level code, hope this will be useful, without knowing table structures not possible to help bro

 

[Voldemort Bro]

@PHBhagya

 

[PHBhagya]

@PHBhagya

නමේ ph තිබුණට.. මේ විශයනං මට ග්‍රීක් වගේ...

 

[thedigit2s]

Mekai case eka, Billing system ekaka pending invoices ( credit ) thiyanawane. mata eka section ekaking e credit customer wa thorala payment ekak karanna.

Menna me wage

View attachment 153251

mama me details ajax ekakin function ekakata pass kara gannawa.

Mata one payment amount eka total due ekin adu we wi pay wenna.

hithannako total due eka hadila thiyenne invoice 5 kin kiyala. api payment eka karaddi e invoice wala total amount eka payment eken adu we wi yannai mata one.

man kiyana eka wadiya therenne nathuwa athi. me stack eketh dala thiyenne ekamai.

https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

Please Help Guys

---

Mekai case eka, Billing system ekaka pending invoices ( credit ) thiyanawane. mata eka section ekaking e credit customer wa thorala payment ekak karanna.

Menna me wage

mama me details ajax ekakin function ekakata pass kara gannawa.

Mata one payment amount eka total due ekin adu we wi pay wenna.

hithannako total due eka hadila thiyenne invoice 5 kin kiyala. api payment eka karaddi e invoice wala total amount eka payment eken adu we wi yannai mata one.

man kiyana eka wadiya therenne nathuwa athi. me stack eketh dala thiyenne ekamai.

https://stackoverflow.com/questions/52600381/paid-multiple-invoice-in-one-query

Please Help Guys
------ Post added on Dec 6, 2021 at 8:13 AM

total due ඒක calculte කරගත්ත query ඒක ඉන්ව‌ොයිස් ‌date ඒක‌ෙන් sort කරලා පලව‌ෙනි invoice ඒක select කරග‌ෙන , pay amount ඒක‌ෙන් selected invoice ඒක‌ේ value ඒක අඩු කරන්න. selected invoice ඒකේ total amount ඒකම pay උනා නම් ඒක payed කියලා update කරන්න. pay amount ඒක‌ේ remain value ඒකක් තිය‌ෙනවා නම් next invoice ekta change ව‌ෙන්න. මට ඔක කරන්න පුළුවන් කියලා ද‌ෙන්න ත‌ෙර‌ෙන්න‌ෙ නැ මචන්

 

[kolavari]

Loop karala pay karanawa kiyanne mokakda bn? Nikan payment gateway ekak through card payment ekak wage karanawada?

Ehema nattham okkoma invoice ekathu karala pay karala e rows tika update karanna puluwanne

 

[Lakshan-Seram]

https://stackoverflow.com/questions/38450274/mysql-subtract-from-multiple-rows-in-one-query

this will help