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

☆ A M B ☆
3,112 Posts

goldsky Reply #31, 16 years, 10 months ago

this is amazing...
you can extend this to make gantt chart, and finally time/project management on this.

Rico
Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!

www.virtudraft.com

Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

Maintainter/contributor of Babel

Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.

5,888 Posts

Bruno17 Reply #32, 16 years, 10 months ago

you can extend this to all what you want.

just create a new project/ and tasks with getdatas.php and your templates.
next generation of this is bloX together with Xedit.

the actual developments on this can you see on github: http://github.com/Bruno17/bloX-Xedit/

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

☆ A M B ☆
3,112 Posts

goldsky Reply #33, 16 years, 10 months ago

i’ll play with it.

Rico
Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!

www.virtudraft.com

Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

Maintainter/contributor of Babel

Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.

5,888 Posts

Bruno17 Reply #34, 16 years, 10 months ago

let me know how you go wink

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

☆ A M B ☆
3,112 Posts

goldsky Reply #35, 16 years, 10 months ago

oh, maannn...

i hope you can use to write all in english first rather than german huh

there are 2 folders in the github. Both of them have bloX snippet. Which one’s the real one?

Rico
Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!

www.virtudraft.com

Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

Maintainter/contributor of Babel

Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.

615 Posts

Sylvaticus Reply #36, 16 years, 10 months ago

Quote from: goldsky at Nov 11, 2009, 11:46 AM

oh, maannn...

i hope you can use to write all in english first rather than german

Until then, you can use Google Translate to get a clue of what’s going on, in English

I think, thererfor I am! But what I am, and why...?

5,888 Posts

Bruno17 Reply #37, 16 years, 10 months ago

all blox-relevant code is in here:

http://github.com/Bruno17/bloX-Xedit/tree/master/snippets/blox/

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #38, 16 years, 10 months ago

I managed to get this to work on a test site, but i’ve completely forgot how.

After installing the snippett and creating the documents etc..

How do I create the required tables in the database? I’m sure this was east but I just forgot.

5,888 Posts

Bruno17 Reply #39, 16 years, 10 months ago

I think it was this sql-query in that file:
http://github.com/Bruno17/bloX-Xedit/blob/master/snippets/blox/projects/custom/fewo/createtable/includes/onsavedatas.php

CREATE TABLE IF NOT EXISTS `modx_belegplan` (
`id` int(10) NOT NULL auto_increment,
`Time` bigint(30) NOT NULL default '0',
`Timeend` bigint(30) NOT NULL,
`category` varchar(50) NOT NULL default '0',
`published` int(1) NOT NULL,
`pagetitle` varchar(250) NOT NULL,
`tpl` varchar(100) NOT NULL,
`class` varchar(20) NOT NULL,
`room_ID` int(10) NOT NULL default '0',
`description` text NOT NULL,
`createdby` int(10) NOT NULL default '0',
`owner_id` int(10) NOT NULL,
`category_ID` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

429 Posts

c-m Reply #40, 16 years, 10 months ago

Thanks.

I notice that the snippet does work with Maxigallery on the same page.

Any I have installed the snippet, but have another problem.

If i fill out the booking form for Fewo1 and immediately i can see that the dates i’ve booked turn to red. Great.

But when i visit Belegplan these dates are not red. The + changes to an o which is good but the dates are not highlighed.

Also I cannot edit the booking. If i click on Belegplan and go to the first date I booked, 1st Dez and click on the o I am taken to the Zimmerreservierung Fewo1 on that calendar i cannot change anything the only date selected is 1st Nov all others are greyed out. Also if i tick Veröffentlicht I get the following error:

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by Time' at line 1 »
      SQL: select id from `marigot-round`.`modx_belegplan` where room_ID= 47 and Time < '943920000' and Timeend > '943920000' and published = '1' and id <> order by Time