setSuccess(false); $ajaxResponse->setMessage($message); $ajaxResponse->send(); die(); }; function getWmsScheduler ($wmsSchedulerId = null) { $user = new User(Mapbender::session()->get("mb_user_id")); $e = new mb_exception("plugins/mb_wms_scheduler_server.php: mb_user_id: ".$user); $wmsSchedulerIdArray = $user->getOwnedWmsScheduler(); if (!is_null($wmsSchedulerId) && !in_array($wmsSchedulerId, $wmsSchedulerIdArray)) { abort(_mb("You are not allowed to access this schedule settings.")); } return $wmsSchedulerIdArray; } //validate user which sends ajax $user = new User(Mapbender::session()->get("mb_user_id")); switch ($ajaxResponse->getMethod()) { case "getWmsScheduler" : $wmsSchedulerIdArray = getWmsScheduler(); $wmsSchedulerList = implode(",", $wmsSchedulerIdArray); $sql = << array( _mb("Scheduler ID"), _mb("WMS ID"), _mb("WMS title"), _mb("last change"), _mb("last status"), _mb("last monitoring"), _mb("update interval"), _mb("mail notification"), _mb("publish"), _mb("searchable"), _mb("overwrite"), _mb("overwrite categories"), _mb("update status"), _mb("action") ), "data" => array() ); while ($row = db_fetch_row($res)) { // convert NULL to '', NULL values cause datatables to crash $walk = array_walk($row, create_function('&$s', '$s=strval($s);')); $row[] = ""; //if fkey_upload_id is set, format it to date for dataTables $row[5] = $row[5]?date("Y-m-d",$row[5]) : $row[5]; $resultObj["data"][]= $row; } $ajaxResponse->setResult($resultObj); $ajaxResponse->setSuccess(true); break; case "getWmsSchedulerEdit" : $wmsSchedulerId = $ajaxResponse->getParameter("id"); $sql = <<id) ) { $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage(_mb("The user is not allowed to alter the update scheduler.")); break; } $resultObj["wms_owner"] = $row["wms_owner"]; $resultObj["scheduler_interval"] = $row["scheduler_interval"]; $resultObj["scheduler_mail"] = $row["scheduler_mail"]; $resultObj["scheduler_publish"] = $row["scheduler_publish"]; $resultObj["scheduler_overwrite"] = $row["scheduler_overwrite"]; $resultObj["scheduler_overwrite_categories"] = $row["scheduler_overwrite_categories"]; $resultObj["scheduler_searchable"] = $row["scheduler_searchable"]; } $ajaxResponse->setResult($resultObj); $ajaxResponse->setSuccess(true); break; case "insertWmsSchedule" : $data = $ajaxResponse->getParameter("data"); $sql = <<wms_id, $data->scheduler_interval, $data->scheduler_publish, $data->scheduler_searchable, $data->scheduler_overwrite, $data->scheduler_overwrite_categories, $data->scheduler_mail); $t = array('i','s','i','i','i','i','i'); try { $res = db_prep_query($sql,$v,$t); } catch (Exception $e){ $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage(_mb("Could not insert wms scheduling in database!")); $ajaxResponse->send(); die; } $ajaxResponse->setMessage("Scheduling inserted!"); $ajaxResponse->setSuccess(true); break; case "updateWmsSchedule" : $schedulerId = $ajaxResponse->getParameter("schedulerId"); $wmsSchedulerIdArray = $user->getOwnedWmsScheduler(); if (!in_array($schedulerId, $wmsSchedulerIdArray)) { abort(_mb("You are not allowed to access this schedule settings.")); } $data = $ajaxResponse->getParameter("data"); $sql = <<scheduler_interval, $data->scheduler_publish, $data->scheduler_searchable, $data->scheduler_overwrite, $data->scheduler_mail, $data->scheduler_overwrite_categories); $t = array('i','s','i','i','i','i','i'); try { $res = db_prep_query($sql,$v,$t); } catch (Exception $e){ $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage(_mb("Could not update wms scheduling in database!")); $ajaxResponse->send(); die; } $ajaxResponse->setMessage("Scheduling updated!"); $ajaxResponse->setSuccess(true); break; $sql = <<id) ) { $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage(_mb("The user is not allowed to alter the update scheduler.")); break; } $resultObj["wms_owner"] = $row["wms_owner"]; $resultObj["scheduler_interval"] = $row["scheduler_interval"]; $resultObj["scheduler_mail"] = $row["scheduler_mail"]; $resultObj["scheduler_publish"] = $row["scheduler_publish"]; $resultObj["scheduler_overwrite"] = $row["scheduler_overwrite"]; $resultObj["scheduler_overwrite_categories"] = $row["scheduler_overwrite_categories"]; $resultObj["scheduler_searchable"] = $row["scheduler_searchable"]; } $ajaxResponse->setResult($resultObj); $ajaxResponse->setSuccess(true); break; case "deleteWmsSchedule" : $id = $ajaxResponse->getParameter("id"); $sql = <<setSuccess(false); $ajaxResponse->setMessage(_mb("Could not delete wms scheduling in database!")); $ajaxResponse->send(); die; } $ajaxResponse->setMessage("Scheduling deleted!"); $ajaxResponse->setSuccess(true); break; case "getUserWms" : $user = new User(Mapbender::session()->get("mb_user_id")); $wmsSchedulerIdArray = getWmsScheduler(); $wmsSchedulerList = implode(",", $wmsSchedulerIdArray); $wmsIdArray = $user->getOwnedWms(); //$wmsList = implode(",", $wmsIdArray); $sql = << $row['wms_id'], "wmsTitle" => $row['wms_title'] ); } $ajaxResponse->setResult($resultObj); $ajaxResponse->setSuccess(true); break; default: $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage(_mb("An unknown error occured.")); break; } $ajaxResponse->send(); ?>