[snippet] Xett create, edit, display events + calendars + other DB - things.

5,888 Posts

Bruno17 Reply #41, 14 years, 6 months ago

seems there is something wrong with the links and the css. Do you have a link?
You can try comparing the differences in yours and mine source-codes at my little example.
Links to my example: http://modxcms.com/forums/index.php/topic,26825.msg250159.html#msg250159

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #42, 14 years, 6 months ago

I have uploaded an example at:

link removed

The manager usermane is ’’ and the password is ’’

As you can see it certainly istn’t wokring correctly.

you have to excuse the look of the site, its just something i’m messing about with.

5,888 Posts

Bruno17 Reply #43, 14 years, 6 months ago

ok, changed on page ’edit’

[!Xett? &service=`edittime` &config_path=`config`&project_path=`fewo`&includes_path=`createtime/dbincludes`!]

to

[!Xett? &service=`edittime` &config_path=`config`&project_path=`fewo`&includes_path=`edittime/dbincludes`!]

the other problem with colors and so on are css-issues. As said, have a look to my example.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #44, 14 years, 6 months ago

Doh! Thanks for that. [edit: just noticed that the wrong call is actually in the instructions of 0.5 version]

just a point though. How do you cancel a booking?

If i unpublish it in Belegplan, it still shows up in Fewo1. This is same in your example too.

5,888 Posts

Bruno17 Reply #45, 14 years, 6 months ago

in file assets/snippets/xett/projectfiles/fewo/fewoCal/dbincludes/datarowGetdatas.php

change

$tablename = $modx->getFullTableName('belegplan'); 
$query="select *";
$query.=" from ".$tablename;
$query.=" where room_ID= ".$row['room_ID'];
$query.=" and Time <= '$timestampend' ";
$query.= " and Timeend >= '$timestampstart' ";
$query.= " order by Time";
$rs = $modx->db->query($query);
$events = $modx->db->makeArray($rs);

to

$tablename = $modx->getFullTableName('belegplan'); 
$query="select *";
$query.=" from ".$tablename;
$query.=" where room_ID= ".$row['room_ID'];
$query.=" and Time <= '$timestampend' ";
$query.= " and Timeend >= '$timestampstart' ";
$query.= " and published = '1' ";
$query.= " order by Time";
$rs = $modx->db->query($query);
$events = $modx->db->makeArray($rs);

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #46, 14 years, 6 months ago

Thanks.

I’ve started to get somewhere now.

I notice that performance wise it is very slow, sometimes taking over 5 seconds to load the page. If there anything I can do to speed this up?

I have also been translating the German to English. I cannot for the life of me find the document that contains the short months on the Beleglpan. I have done a seach in all the files and replaced Dez for Dec, Okt to Oct etc.. but still this page hasn’t changed. I also can;t find where the word "Belegen" is, this is shown when hovering over the + in the Belegplan.

5,888 Posts

Bruno17 Reply #47, 14 years, 6 months ago

I cannot for the life of me find the document that contains the short months on the Beleglpan.

ok, this is done by the phx-modifier date_ger
try to change [+xett.row.tsmonth:date_ger=`%b %y`+] to [+xett.row.tsmonth:date=`%b %y`+]
in file assets/snippets/xett/projectfiles/fewo/belegplanlong/templates/monthlistTpl.html

I also can;t find where the word "Belegen" is, this is shown when hovering over the + in the Belegplan.

this is in file assets/snippets/xett/projectfiles/fewo/belegplanlong/templates/dayTpl.html

I notice that performance wise it is very slow

there is cache implemented in belegplan, but not yet in fewo_cal
check if the folder assets/snippets/xett/cache is writable.
for fewo_cal we can add cache functionality of course.

it creates cache-files for each month-view, after rendering and uses the cached file as long as you do not book something in that month.
when you book something in a month, the cache file is deleted.
you can see them in this cache-folder if it works.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #48, 14 years, 6 months ago

Thanks for all your help with this.

One last question:

Is is possible to show the short calendar for Fewo1 but the remove the option (the links) for user to actually make a booking? I.e Just show the availability only?

I want to add bookings manually using the Belegplan page, which I will allow only web admins to log into and see.

Sorry about all the questions.

5,888 Posts

Bruno17 Reply #49, 14 years, 6 months ago

no prob,
use the parameter &canedit_webgroups=`yourwebgroupswhichcanedit` and the editor-links should go away.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

5,888 Posts

Bruno17 Reply #50, 14 years, 6 months ago

perhaps it has to do with cache-files. Try to delete them all in the cache-folder.

There is also an admin tool in this fewo-project, where you can list all bookings, delete them, and edit them directly from the list, as far as I know. Have to look on this, if you want this feature.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!