Kalendar / KOHA

Mobile - Settings - Register - Help

Home

Quick jump: What's new - Weblogs

Print
Tools

V

6

Tags

{"maxCount":18,"tags":[{"page_count":18,"count":null,"name":"Welcome"},{"page_count":17,"count":null,"name":"for:dpavlin"},{"page_count":15,"count":null,"name":"sysadmin"},{"page_count":9,"count":null,"name":"Koha Weblog"},{"page_count":9,"count":null,"name":"sadr\u017eaj"},{"page_count":9,"count":null,"name":"posudba"},{"page_count":8,"count":null,"name":"Migracija Weblog"},{"page_count":7,"count":null,"name":"katalogizacija"},{"page_count":5,"count":null,"name":"korisnici"},{"page_count":5,"count":null,"name":"ldap"},{"page_count":5,"count":null,"name":"upgrade"},{"page_count":4,"count":null,"name":"katalozi"},{"page_count":4,"count":null,"name":"RFID"},{"page_count":4,"count":null,"name":"signature"},{"page_count":4,"count":null,"name":"cirkulacija"},{"page_count":3,"count":null,"name":"fotokopirke"},{"page_count":3,"count":null,"name":"framework"},{"page_count":3,"count":null,"name":"zatvoreno spremi\u0161te"},{"page_count":3,"count":null,"name":"javni katalog"},{"page_count":3,"count":null,"name":"mysql"},{"page_count":2,"count":null,"name":"korisni\u010dke kartice"},{"page_count":2,"count":null,"name":"instalacija"},{"page_count":2,"count":null,"name":"plan"},{"page_count":2,"count":null,"name":"SafeQ"},{"page_count":2,"count":null,"name":"primjerci"},{"page_count":2,"count":null,"name":"rok posudbe"},{"page_count":2,"count":null,"name":"implementacija"},{"page_count":2,"count":null,"name":"razvoj"},{"page_count":2,"count":null,"name":"zakasnine"},{"page_count":2,"count":null,"name":"ovlasti"},{"page_count":2,"count":null,"name":"Z39.50"},{"page_count":2,"count":null,"name":"printanje"},{"page_count":2,"count":null,"name":"rezervacije"},{"page_count":2,"count":null,"name":"upute"},{"page_count":1,"count":null,"name":"obnova \u010dlanstva"},{"page_count":1,"count":null,"name":"prinove"},{"page_count":1,"count":null,"name":"\u010dlanski broj"},{"page_count":1,"count":null,"name":"globalni parametri"},{"page_count":1,"count":null,"name":"kalendar"},{"page_count":1,"count":null,"name":"RIFD"},{"page_count":1,"count":null,"name":"unos podataka"},{"page_count":1,"count":null,"name":"MARC21"},{"page_count":1,"count":null,"name":"prilagodba"},{"page_count":1,"count":null,"name":"polja u bazi"},{"page_count":1,"count":null,"name":"vrste gra\u0111e"},{"page_count":1,"count":null,"name":"migracija"},{"page_count":1,"count":null,"name":"backup"},{"page_count":1,"count":null,"name":"Vivainfo"},{"page_count":1,"count":null,"name":"Koha community"},{"page_count":1,"count":null,"name":"zebra"},{"page_count":1,"count":null,"name":"sortiranje"},{"page_count":1,"count":null,"name":"WebPAC2"},{"page_count":1,"count":null,"name":"procjena"},{"page_count":1,"count":null,"name":"UTF-8"},{"page_count":1,"count":null,"name":"klasifikacija"},{"page_count":1,"count":null,"name":"SLF"},{"page_count":1,"count":null,"name":"SIP2"},{"page_count":1,"count":null,"name":"xslt"},{"page_count":1,"count":null,"name":"restore"},{"page_count":1,"count":null,"name":"stare zadu\u017enice"},{"page_count":1,"count":null,"name":"prijevod"},{"page_count":1,"count":null,"name":"standrd"},{"page_count":1,"count":null,"name":"nabava"},{"page_count":1,"count":null,"name":"preuzimanje zapisa"},{"page_count":1,"count":null,"name":"hardver"},{"page_count":1,"count":null,"name":"holdings"},{"page_count":1,"count":null,"name":"integracija"},{"page_count":1,"count":null,"name":"bilje\u0161ke"},{"page_count":1,"count":null,"name":"\u010dasopisi"},{"page_count":1,"count":null,"name":"odr\u017eavanje"},{"page_count":1,"count":null,"name":"OP"},{"page_count":1,"count":null,"name":"kronologija"},{"page_count":1,"count":null,"name":"normativa"},{"page_count":1,"count":null,"name":"VMWare"},{"page_count":1,"count":null,"name":"edukacija"},{"page_count":1,"count":null,"name":"promjena lozinke"},{"page_count":1,"count":null,"name":"AAI ra\u010dun"},{"page_count":1,"count":null,"name":"migracija podataka"},{"page_count":0,"count":null,"name":"Naslovnica"},{"page_count":0,"count":null,"name":"ispravci"},{"page_count":0,"count":null,"name":"bolje\u0161ke"},{"page_count":0,"count":null,"name":"kopirke"},{"page_count":0,"count":null,"name":"printer"},{"page_count":0,"count":null,"name":"Koha zajednica korisnika"},{"page_count":0,"count":null,"name":"Random Weblog"},{"page_count":0,"count":null,"name":"intranet katalog"},{"page_count":0,"count":null,"name":"katalogizacija vi\u0161erazinci"},{"page_count":0,"count":null,"name":"formalno signiranje"},{"page_count":0,"count":null,"name":"upis"},{"page_count":0,"count":null,"name":"katalogizacija sadr\u017eaj"},{"page_count":0,"count":null,"name":"korisnici posudba"},{"page_count":0,"count":null,"name":"enkonding"},{"page_count":0,"count":null,"name":"povijest"},{"page_count":0,"count":null,"name":"sysadmin instalacija"},{"page_count":0,"count":null,"name":"obrada primjeraka"},{"page_count":0,"count":null,"name":"katalog"},{"page_count":0,"count":null,"name":"dokumentacija"},{"page_count":0,"count":null,"name":"iskaznice"},{"page_count":0,"count":null,"name":"pravilnik"},{"page_count":0,"count":null,"name":"predlo\u0161ci"},{"page_count":0,"count":null,"name":",ysql"}]}

Incoming Links

Posudba

Attachments

KOHA

Kalendar

https://koha.rot13.org:8443/cgi-bin/koha/tools/holidays.pl

http://koha.org/documentation/manual/3.0/tools/calendar-and-holidays

2009-07-2?

Dorja unjela praznike i kolektivni godišnji u kalendar. (kad?).
Prilikom računanja datuma povratka knjige Koha koristi kalendar i preskače datume koji su označeni kao neradni.

2009-08-10

Retrogradno se stvar naravno ne računa pa je Marijana ručno promijenila datume posudbe u bazi, ovako:

update issues join borrowers on issues.borrowernumber=borrowers.borrowernumber set date_due = '2009-09-09' where borrowers.categorycode = 'S1' and date_due = '2009-08-15' ;

23.7.	17.8.
24.7.	18.8.
25.7.	19.8.
27.7.	21.8.
28.7.	22.8.
29.7.	23.8.
30.7.	24.8.
31.7.	25.8.
2.8.	27.8.
3.8.	28.8.
4.8.	29.8.
5.8.	30.8.
6.8.	31.8.
7.8.	1.9.
8.8.	2.9.
9.8.	3.9.
10.8.	4.9.
11.8.	5.9.
12.8.	6.9.
13.8.	7.9.
14.8.	8.9.
15.8.	9.9.

Učinjena je i kontrola produživanja roka posudbe, jer je uočeno da su neki korisnici produžili rok posudbe isti dan kad su i posudili knjigu.
Prije nego je uključena opcija prema kojoj se rok vračanja nakon produživanja računa od datuma posude umjesto od datuma kad je produživanje učinjeno, to je rezultiralo time da je datum vračanja ostao isti kao i datum pusudne, a jedno produženje je potrošeno.

Izlistati korisnike koji su knjigu produžili isti dan kad su ju i zadužili.

select issues.borrowernumber, issues.itemnumber, date_due, lastreneweddate, renewals, issues.timestamp, issuedate from issues join borrowers on issues.borrowernumber=borrowers.borrowernumber where borrowers.categorycode = 'S1' and  issuedate = lastreneweddate and date(timestamp) < '2009-08-10'  order by issuedate desc ;

Upload Files

Click "Browse" to find the file you want to upload. When you click "Upload file" your file will be uploaded and added to the list of attachments for this page.

Maximum file size: 50MB

Add a link to the attachment at the top of the page? Images will appear in the page.

Expand zip archive and attach individual files to the page

Done

	File Name	Author	Date Uploaded	Size

Close

Delete Selected Files

Upload Files

Click "Browse" to find the file you want to upload. When you click "Add file" this file will be added to the list of attachments for this page, and uploaded when you save the page.

Add a link to the attachment at the top of the page? Images will appear in the page when the page is saved.

Expand zip archive and attach individual files to the page

Done

Add file

Add Tags

Enter a tag and click "Add tag". The tag will be saved when you save the page.

Tag:

Suggestions:

Done

Add tag

* https://koha.rot13.org:8443/cgi-bin/koha/tools/holidays.pl

* http://koha.org/documentation/manual/3.0/tools/calendar-and-holidays

^^ 2009-07-2?

Dorja unjela praznike i kolektivni godišnji u kalendar. (kad?).
Prilikom računanja datuma povratka knjige Koha koristi kalendar i preskače datume koji su označeni kao neradni.

^^ 2009-08-10

Retrogradno se stvar naravno ne računa pa je Marijana ručno promijenila datume posudbe u bazi, ovako:

.pre
update issues join borrowers on issues.borrowernumber=borrowers.borrowernumber set date_due = '2009-09-09' where borrowers.categorycode = 'S1' and date_due = '2009-08-15' ;
.pre

| 23.7. | 17.8. |
| 24.7. | 18.8. |
| 25.7. | 19.8. |
| 27.7. | 21.8. |
| 28.7. | 22.8. |
| 29.7. | 23.8. |
| 30.7. | 24.8. |
| 31.7. | 25.8. |
| 2.8. | 27.8. |
| 3.8. | 28.8. |
| 4.8. | 29.8. |
| 5.8. | 30.8. |
| 6.8. | 31.8. |
| 7.8. | 1.9. |
| 8.8. | 2.9. |
| 9.8. | 3.9. |
| 10.8. | 4.9. |
| 11.8. | 5.9. |
| 12.8. | 6.9. |
| 13.8. | 7.9. |
| 14.8. | 8.9. |
| 15.8. | 9.9. |

Učinjena je i kontrola produživanja roka posudbe, jer je uočeno da su neki korisnici produžili rok posudbe isti dan kad su i posudili knjigu.
Prije nego je uključena opcija prema kojoj se rok vračanja nakon produživanja računa od datuma posude umjesto od datuma kad je produživanje učinjeno, to je rezultiralo time da je datum vračanja ostao isti kao i datum pusudne, a jedno produženje je potrošeno.

Izlistati korisnike koji su knjigu produžili isti dan kad su ju i zadužili.

.pre
select issues.borrowernumber, issues.itemnumber, date_due, lastreneweddate, renewals, issues.timestamp, issuedate from issues join borrowers on issues.borrowernumber=borrowers.borrowernumber where borrowers.categorycode = 'S1' and  issuedate = lastreneweddate and date(timestamp) < '2009-08-10'  order by issuedate desc ;
.pre

Help - Community
Socialtext, the Enterprise Wiki v2.19.0.2