Okay, Thank you Sir Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora...@yahoo.in> | University Email <f20171...@pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/>
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031 On Fri, Jun 21, 2019 at 9:57 PM Michael Hafen <michael.ha...@washk12.org> wrote: > My guess is that code was looking for outstanding fines rather than > account balance. > > On Thu, Jun 20, 2019 at 9:57 PM RAGHAV ARORA < > f20171...@pilani.bits-pilani.ac.in> wrote: > >> Ok sir, thanks for the clarification. >> >> One last thing, if I need to see the total fine of a patron, I will take >> sum of all the amountoutstanding for that borrowernumber, right? >> At some place I found someone to be taking sum of only the positive >> amountoutstanding, and ignoring the negative amountoutstandings. I couldn't >> understand why. >> >> Regards >> *Raghav Arora* >> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering >> Contact : (+91) 9897597761 >> Personal Email <raghavarora...@yahoo.in> | University Email >> <f20171...@pilani.bits-pilani.ac.in> >> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >> <https://github.com/RAraghavarora/> >> >> >> >> On Thu, Jun 20, 2019 at 10:21 PM Michael Hafen <michael.ha...@washk12.org> >> wrote: >> >>> So that you know what the original amount of the fine is/was. This is >>> especially useful in an ongoing overdue fine, for example. The patron may >>> have some, but still has the book. So the script can look at what the fine >>> is supposed to be, and what it was last time the script ran (the amount >>> column) then add the difference to both the amount and amountoutstanding >>> columns. (Since we can't guarantee that the script is run once, and only >>> once, a day.) >>> >>> On Thu, Jun 20, 2019 at 3:05 AM RAGHAV ARORA < >>> f20171...@pilani.bits-pilani.ac.in> wrote: >>> >>>> Thank you sir, >>>> >>>> Can you please help me understand these tables? >>>> What is the purpose of the 2 tables 'accountlines' and >>>> 'account_offsets'? >>>> >>>> account_offsets is a child of accountlines, which allows 1 accountlines >>>> row to have multiple account_offsets, and the 'account_offsets.amount' is >>>> the total amount debited/credited. What exactly is the >>>> 'amountlines.amount'? >>>> In my database, there is an accountlines row which has 3 >>>> account_offsets rows linked, 2 of them credit $5, and 1 debits $10, making >>>> the amountoutstanding=0, which is expected. But accountlines.amount stores >>>> 10. Why is that so? >>>> >>>> Thanks in advance >>>> Regards >>>> *Raghav Arora* >>>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>>> Engineering >>>> Contact : (+91) 8474975691 >>>> Personal Email <raghavarora...@yahoo.in> | University Email >>>> <f20171...@pilani.bits-pilani.ac.in> >>>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >>>> <https://github.com/RAraghavarora/> >>>> >>>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>>> *Birla Institute of Technology and Science, Pilani* >>>> Pilani campus, >>>> Rajasthan-333031 >>>> >>>> >>>> On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen < >>>> michael.ha...@washk12.org> wrote: >>>> >>>>> Amount is the original amount of the fine/invoice, and >>>>> amountoutstanding is the remaining amount after receiving / sending some >>>>> sort of payment. There should be another row in that table, and a link in >>>>> the accountoffsets table, of those two columns aren't the same, but that's >>>>> probably more than you wanted to know. >>>>> >>>>> On Wed, Jun 19, 2019 at 5:13 AM RAGHAV ARORA < >>>>> f20171...@pilani.bits-pilani.ac.in> wrote: >>>>> >>>>>> Hello everyone, >>>>>> >>>>>> I am currently working on a project on Reports Management and >>>>>> Decision Support System for my institute library that uses Koha as it's >>>>>> ILS. I have a doubt in understanding what is the difference between the >>>>>> fields 'accountlines.amount' and 'accountlines.amountoutstanding'? >>>>>> >>>>>> Could someone help me out with this? >>>>>> >>>>>> Thanks in advance. >>>>>> >>>>>> Regards >>>>>> *Raghav Arora* >>>>>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>>>>> Engineering >>>>>> Contact : (+91) 9897597761 >>>>>> Personal Email <raghavarora...@yahoo.in> | University Email >>>>>> <f20171...@pilani.bits-pilani.ac.in> >>>>>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | >>>>>> GitHub <https://github.com/RAraghavarora/> >>>>>> >>>>>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>>>>> *Birla Institute of Technology and Science, Pilani* >>>>>> Pilani campus, >>>>>> Rajasthan-333031 >>>>>> _______________________________________________ >>>>>> Koha-devel mailing list >>>>>> Koha-devel@lists.koha-community.org >>>>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>>>>> website : http://www.koha-community.org/ >>>>>> git : http://git.koha-community.org/ >>>>>> bugs : http://bugs.koha-community.org/ >>>>> >>>>> >>>>> >>>>> -- >>>>> Michael Hafen >>>>> Washington County School District Technology Department >>>>> Systems Analyst >>>>> >>>>> >>> >>> -- >>> Michael Hafen >>> Washington County School District Technology Department >>> Systems Analyst >>> >>> > > -- > Michael Hafen > Washington County School District Technology Department > Systems Analyst > >
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
