Re: [Koha-devel] Doubt in Koha Database Schema

[RAGHAV ARORA]

Okay, Thank you Sir

Regards
*Raghav Arora*
Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering
Contact : (+91) 9897597761
Personal Email  | University Email

LinkedIn  |  GitHub


▄
*Birla Institute of Technology and Science, Pilani*
Pilani campus,
Rajasthan-333031


On Fri, Jun 21, 2019 at 9:57 PM Michael Hafen 
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  | University Email
>> 
>> LinkedIn  |  GitHub
>> 
>>
>>
>>
>> On Thu, Jun 20, 2019 at 10:21 PM Michael Hafen 
>> 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  | University Email
 
 LinkedIn  |  GitHub
 

 ▄
 *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  | University Email
>> 
>> LinkedIn  |
>> GitHub 
>>
>> ▄
>> *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
> 

Re: [Koha-devel] Doubt in Koha Database Schema

[Michael Hafen]

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  | University Email
> 
> LinkedIn  |  GitHub
> 
>
>
>
> On Thu, Jun 20, 2019 at 10:21 PM Michael Hafen 
> 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  | University Email
>>> 
>>> LinkedIn  |  GitHub
>>> 
>>>
>>> ▄
>>> *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  | University Email
> 
> LinkedIn  |
> GitHub 
>
> ▄
> *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/

Re: [Koha-devel] Doubt in Koha Database Schema

[RAGHAV ARORA]

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  | University Email

LinkedIn  |  GitHub




On Thu, Jun 20, 2019 at 10:21 PM Michael Hafen 
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  | University Email
>> 
>> LinkedIn  |  GitHub
>> 
>>
>> ▄
>> *Birla Institute of Technology and Science, Pilani*
>> Pilani campus,
>> Rajasthan-333031
>>
>>
>> On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen 
>> 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  | University Email
 
 LinkedIn  |  GitHub
 

 ▄
 *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
>
>
___
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/

Re: [Koha-devel] Doubt in Koha Database Schema

[Michael Hafen]

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  | University Email
> 
> LinkedIn  |  GitHub
> 
>
> ▄
> *Birla Institute of Technology and Science, Pilani*
> Pilani campus,
> Rajasthan-333031
>
>
> On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen 
> 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  | University Email
>>> 
>>> LinkedIn  |  GitHub
>>> 
>>>
>>> ▄
>>> *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
___
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/

Re: [Koha-devel] Doubt in Koha Database Schema

[RAGHAV ARORA]

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  | University Email

LinkedIn  |  GitHub


▄
*Birla Institute of Technology and Science, Pilani*
Pilani campus,
Rajasthan-333031


On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen 
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  | University Email
>> 
>> LinkedIn  |  GitHub
>> 
>>
>> ▄
>> *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
>
>
___
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/

Re: [Koha-devel] Doubt in Koha Database Schema

[Michael Hafen]

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  | University Email
> 
> LinkedIn  |  GitHub
> 
>
> ▄
> *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
___
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/