[4001] | 1 | <?php
|
---|
| 2 | include ('../../../codebase/connector/scheduler_connector.php');
|
---|
| 3 | include ('../../common/config.php');
|
---|
| 4 |
|
---|
| 5 | $res=mysql_connect($server, $user, $pass);
|
---|
| 6 | mysql_select_db($db_name);
|
---|
| 7 |
|
---|
| 8 | function delete_related($action){
|
---|
| 9 | global $scheduler;
|
---|
| 10 |
|
---|
| 11 | $status = $action->get_status();
|
---|
| 12 | $type =$action->get_value("rec_type");
|
---|
| 13 | $pid =$action->get_value("event_pid");
|
---|
| 14 | //when serie changed or deleted we need to remove all linked events
|
---|
| 15 | if (($status == "deleted" || $status == "updated") && $type!=""){
|
---|
| 16 | $scheduler->sql->query("DELETE FROM events_rec WHERE event_pid='".$scheduler->sql->escape($action->get_id())."'");
|
---|
| 17 | }
|
---|
| 18 | if ($status == "deleted" && $pid !=0){
|
---|
| 19 | $scheduler->sql->query("UPDATE events_rec SET rec_type='none' WHERE event_id='".$scheduler->sql->escape($action->get_id())."'");
|
---|
| 20 | $action->success();
|
---|
| 21 | }
|
---|
| 22 |
|
---|
| 23 | }
|
---|
| 24 | function insert_related($action){
|
---|
| 25 | $status = $action->get_status();
|
---|
| 26 | $type =$action->get_value("rec_type");
|
---|
| 27 |
|
---|
| 28 | if ($status == "inserted" && $type=="none")
|
---|
| 29 | $action->set_status("deleted");
|
---|
| 30 | }
|
---|
| 31 |
|
---|
| 32 | $scheduler = new schedulerConnector($res);
|
---|
| 33 | //$scheduler->enable_log("log.txt",true);
|
---|
| 34 | $scheduler->event->attach("beforeProcessing","delete_related");
|
---|
| 35 | $scheduler->event->attach("afterProcessing","insert_related");
|
---|
| 36 | $scheduler->render_table("events_rec","event_id","start_date,end_date,text,rec_type,event_pid,event_length");
|
---|
| 37 | ?> |
---|