function pbuild_make_link(&$p2p_links, $ends, $dist = FALSE) { global $wpdb; $rec = reset($ends); $name = clb_val('', $rec, RF_NODES_TYPE) . ': ' . clb_val('', $rec, RF_NODES_NAME); $lat1 = clb_val(0, $rec, 'lat'); $lng1 = clb_val(0, $rec, 'lng'); $pnum1 = clb_val(0, $rec, RF_LINKS_KEY); $rec = next($ends); $name .= clb_val('', $rec, RF_NODES_TYPE) . ': ' . clb_val('', $rec, RF_NODES_NAME); $lat2 = clb_val(0, $rec, 'lat'); $lng2 = clb_val(0, $rec, 'lng'); $pnum2 = clb_val(0, $rec, RF_LINKS_KEY); //checking for existing links, and specifically any existing walk link $linkpnum = ''; $makelink = TRUE; if (isset($p2p_links['nodes'][$pnum1]) && isset($p2p_links['nodes'][$pnum2])) { //get the list of link_pnums for both nodes and intersect to see if they are already connected $connections = array_intersect(explode(',', $p2p_links['nodes'][$pnum1]), explode(',', $p2p_links['nodes'][$pnum2])); $makelink = count($connections) <= 0; //dont make a link if there is already a direct link //if there are links see if one of them is a walk link in which case we may want to update it if the ends have moved. foreach ($connections as $ref) { if (isset($p2p_links['links'][$ref]['ptype']) && $p2p_links['links'][$ref]['ptype'] == 'walk') { $linkpnum = $ref; $makelink = TRUE; //comment this out if dont want to update walk links if (isset($p2p_links['links'][$ref]['pt_count']) && $p2p_links['links'][$ref]['pt_count'] > 2) { $makelink = FALSE; } //if the walk link has more than 2 points then break; } } if (count($connections) > 1 && $linkpnum) { qlog(__LINE__, 'walk link and other link types', $pnum1, $pnum2, $connections); } } /* $p2p_links may not include existing "walk" interchanges if there were no routes involving the stops but to prevent creating duplicates do a search and do nothing if a walk exists */ if ($makelink && !$linkpnum) { $pair = clb_join(array($pnum1, $pnum2), TRUE); $query = 'SELECT ' . RF_LINKS_KEY . ' FROM ' . RF_LINKS_FROM . ' WHERE ' . RF_LINKS_TYPE . '="walk" AND ' . RF_LINKS_END1 . ' IN ' . $pair . ' AND ' . RF_LINKS_END2 . ' IN ' . $pair; $check = $wpdb->get_results($query, ARRAY_A); if (is_array($check) && clb_val('', reset($check), RF_LINKS_KEY)) { $makelink = FALSE; } } if ($makelink) { if ($dist === FALSE) { $dist = pline_surface_dist($lat1, $lng1, $lat2, $lng2); } $processed = clb_now_utc(); $query = ''; $query .= ', ' . RF_LINKS_DIST . '=' . $dist * 2; //double the distance so this is not chosen over actual tracks $query .= ', ' . RF_LINKS_TIME . '=' . ceil($dist / 80); //80 meters per minute is about 3 miles per hour $query .= ', ' . RF_LINKS_MODIFIED . '=' . clb_escape($processed); $query .= ', ' . RF_LINKS_NAME . '=' . clb_escape($name); $query .= ', lat=' . round(($lat1 + $lat2) / 2, PT_PRECISION); $query .= ', lng=' . round(($lng1 + $lng2) / 2, PT_PRECISION); $points = array(); $points[] = array($lat1, $lng1, 0); $points[] = array($lat2, $lng2, 0); if ($polyline = pline_make($points, array('color' => '#00FF00'))) { $query .= ', ' . RF_LINKS_LINE . '=' . clb_escape(clb_join($polyline, '', '&', '=')); $query .= ', ' . RF_LINKS_POINTS . '=' . clb_escape(clb_blob_enc($points)); } if ($linkpnum) { $query = 'UPDATE ' . RF_LINKS_FROM . ' SET ' . trim($query, ', ') . ' WHERE ' . RF_LINKS_KEY . '=' . clb_escape($linkpnum); } else { $linkpnum = pbuild_new_pnum(RF_LINKS_FROM, RF_LINKS_KEY); $query .= ', ' . RF_LINKS_KEY . '=' . clb_escape($linkpnum); $query .= ', ' . RF_LINKS_CREATED . '=' . clb_escape($processed); $query .= ', ' . RF_LINKS_END1 . '=' . clb_escape($pnum1); $query .= ', ' . RF_LINKS_END2 . '=' . clb_escape($pnum2); $query .= ', ' . RF_LINKS_TYPE . '=' . clb_escape('walk'); $query = 'INSERT INTO ' . RF_LINKS_FROM . ' SET ' . trim($query, ', '); } // qlog(__LINE__, $query); $wpdb->query($query); } return $makelink; }
function pfind_routes($waypoints, $links, $prop, $type_names) { global $wpdb; //convert lat/lng to nearest station(s) $metric = clb_val('', $prop, 'units') == 'km'; $get_steps = clb_val(TRUE, $prop, 'getSteps'); $get_plyline = clb_val(TRUE, $prop, 'getPolyline'); $dist_only = clb_val(TRUE, $prop, 'dist_only'); $trip_meters = 0; clb_timing(__LINE__); $result = array(); $result['error'] = 200; //start optimistically $result['error_str'] = 'no errors'; $html = ''; $bounds = array(); $polyline = ''; $aoe_data = array(); $markers = array_fill(0, count($waypoints), FALSE); //initialise the markers array with a false for each waypoint $marker_path = 'http://chart.apis.google.com/chart?chst=d_map_xpin_letter&chld=pin|%|65BA4A|000000|000000'; $tab_style = 'margin-top: 10px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: silver; border-right-color: silver; border-bottom-color: silver; border-left-color: silver; background-color: rgb(238, 238, 238); border-collapse: collapse; color: rgb(0, 0, 0); width: 100%;'; $has_route = FALSE; //gets set when we have some sort of route between waypoints /* **** currently the route between waypoints is found, processed and then the next waypoint is handled if there are multiple nodes in an intermediate waypoint then the chosen route to and route from the way point may not pick the same nodes this case could be hanlded by adding a walk step at the beginning of the following step to go between the two chosen nodes or all intermediate routes could be processed and then ones with matching intermedite nodes chosen which would probably be harder to code. */ $orig = FALSE; $way_no = 0; foreach ($waypoints as $route_no => $sel) { $dest = array(); foreach ($sel as $key => $val) { //waypoints can be array(pnum => array(place record)) or array(pnum, pnum), hence the choice below $pnum = is_array($val) ? $key : $val; //check each pnum and see if it needs to be split into platforms, but not if dist only if (!$dist_only && isset($links['stat2plat'][$pnum])) { $dest = array_merge($dest, $links['stat2plat'][$pnum]); } else { $dest[] = $pnum; } } if (clb_count($orig)) { $candidates = pfind_steps($orig, $dest, $links, $type_names, $dist_only); //<= ****** call to shortest path //qlog(__LINE__, $waypoints, count($candidates), $candidates); //sift though candidates and choose best switch (clb_val('best', $prop, 'opto')) { case 'time': $pick_fld = 'duration'; break; case 'changes': $pick_fld = 'minchanges'; break; case 'dist': $pick_fld = 'meters'; break; case 'best': default: $pick_fld = 'best'; break; } $pick_rec = FALSE; $pick_val = FALSE; foreach ($candidates as $no => $option) { if ($pick_fld == 'best') { $test = $option['scores']['meters'] + 1000 * $option['scores']['minchanges']; } else { $test = $option['scores'][$pick_fld]; } if ($pick_val === FALSE || $test < $pick_val) { $pick_rec = $no; $pick_val = $test; } } if ($pick_rec === FALSE) { //no routes found $result['error'] = 604; $result['error_str'] = 'no connecting routes found'; $result['Routes'][] = FALSE; //maintain place for numbering } else { $pnum1 = FALSE; if (!clb_val(FALSE, $markers, $way_no - 1)) { $place = clb_val(FALSE, $candidates, $pick_rec, 'orig'); $pnum1 = clb_val('', $place, 'pnum'); $icon = str_replace('%', substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $way_no - 1, 1), $marker_path); $markers[$way_no - 1] = array('url' => $icon, 'lat' => clb_val(0, $place, 'lat'), 'lng' => clb_val(0, $place, 'lng'), 'name' => clb_val('', $place, RF_NODES_NAME), 'desc' => clb_val('', $place, RF_NODES_DESC)); $ptype = clb_val('', $place, 'ptype'); $orig_detials = clb_val('', $type_names, $ptype, 'label') . ': ' . clb_val('', $place, RF_NODES_NAME) . ' / ' . clb_val('', $place, RF_NODES_DESC); if ($get_steps) { $row = ''; $row .= clb_tag('td', '', clb_tag('img/', '', '', array('src' => $icon)), array('style' => 'cursor:pointer')); $row .= clb_tag('td', $orig_detials, '', array('style' => 'vertical-align: middle;width: 100%')); $html .= clb_tag('table', '', clb_tag('tbody', '', clb_tag('tr', '', $row, array('style' => 'cursor:pointer'))), array('style' => $tab_style)); } } $has_route = TRUE; //signals we have a route to return //add the points for this route into the array for the polyline if ($get_plyline) { $temp = FALSE; if (function_exists('pline_splice')) { $temp = pline_splice($wpdb, $candidates[$pick_rec]['links'], $pnum1); } //pnum1 added 2/8/2009 if (clb_count($temp)) { $aoe_data = $temp; } //array_merge($aoe_data, $temp); } $steps = $candidates[$pick_rec]['steps']; $meters = $candidates[$pick_rec]['scores']['meters']; $trip_meters += $meters; $summary = $metric ? pfind_kilo($meters) : pfind_miles($meters); //string with units $place = clb_val(FALSE, $candidates, $pick_rec, 'dest'); $ptype = clb_val('', $place, 'ptype'); $dest_detials = clb_val('', $type_names, $ptype, 'label') . ': ' . clb_val('', $place, RF_NODES_NAME) . ' / ' . clb_val('', $place, RF_NODES_DESC); $icon = str_replace('%', substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $way_no, 1), $marker_path); $markers[$way_no] = array('url' => $icon, 'lat' => clb_val(0, $place, 'lat'), 'lng' => clb_val(0, $place, 'lng'), 'name' => clb_val('', $place, RF_NODES_NAME), 'desc' => clb_val('', $place, RF_NODES_DESC)); $step_list = array(); if ($get_steps) { $table = ''; foreach ($steps as $s => $pt) { $row = ''; $row .= clb_tag('td', $s + 1, '', array('style' => 'vertical-align:top;border-top: 1px solid #cdcdcd;padding:0.3em 3px 0.3em 3px;margin: 0px;text-align:right;')); $row .= clb_tag('td', '', clb_val('', $pt, 'desc'), array('style' => 'vertical-align:top;border-top: 1px solid #cdcdcd;padding:0.3em 3px 0.3em 3px;margin: 0px;width:100%;')); $dist = clb_val(0, $pt, 'dist'); $dist = $metric ? pfind_kilo($dist) : pfind_miles($dist); $row .= clb_tag('td', '', $dist, array('style' => 'vertical-align:top;border-top: 1px solid #cdcdcd;padding-top:0.3em;padding-right:3px;padding-bottom:0.3em;padding-left:0.5em;margin: 0px;text-align:right;')); $table .= clb_tag('tr', '', $row); $step_meters = clb_val(0, $pt, 'dist'); $step_list[] = array('lat' => clb_val(0, $pt, 'lat'), 'lng' => clb_val(0, $pt, 'lng'), 'PolylineIndex' => 0, 'DescriptionHtml' => clb_val('', $pt, 'desc'), 'Distance' => array('meters' => $step_meters, 'miles' => pfind_miles($step_meters, FALSE), 'html' => $metric ? pfind_kilo($meters) : pfind_miles($meters)), 'Duration' => array()); } $html .= clb_tag('table', '', clb_tag('tbody', '', $table)); //add end marker on each route $row = ''; $row .= clb_tag('td', '', clb_tag('img/', '', '', array('src' => $icon)), array('style' => 'cursor:pointer')); $row .= clb_tag('td', $dest_detials, '', array('style' => 'vertical-align: middle;width: 100%')); $html .= clb_tag('table', '', clb_tag('tbody', '', clb_tag('tr', '', $row, array('style' => 'cursor:pointer'))), array('style' => $tab_style)); } $route = array(); $route['NumSteps'] = count($step_list); /* geocodes are Placemark type values with the top level fields: address, AddressDetails, Point we dont have the address details breakdown so just providing the address if we have it and the Point data */ $m = $markers[$route_no - 1]; $route['StartGeocode'] = array('address' => clb_val('', $m, 'addr'), 'Point' => array('coordinates' => array(clb_val('', $m, 'lat'), clb_val('', $m, 'lng'), 0))); $m = $markers[$route_no]; $route['EndGeocode'] = array('address' => clb_val('', $m, 'addr'), 'Point' => array('coordinates' => array(clb_val('', $m, 'lat'), clb_val('', $m, 'lng'), 0))); if (isset($candidates[$no]['EndLatLng'])) { $pt = preg_split('/\\s*,\\s*/', $candidates[$no]['EndLatLng']); $route['EndLatLng'] = array('lat' => clb_val(0, $pt, 0), 'lng' => clb_val(0, $pt, 1)); } else { $route['EndLatLng'] = $route['EndGeocode']['Point']; } $route['SummaryHtml'] = $summary; $route['Distance'] = array('meters' => $meters, 'miles' => pfind_miles($meters, FALSE), 'html' => $summary); $route['Duration'] = array(); $route['Steps'] = $step_list; $result['Routes'][] = $route; } } $orig = $dest; $way_no++; } if ($has_route) { if (clb_count($aoe_data) && $get_plyline) { $attr = array('color' => clb_val('#0000FF', $prop, 'color'), 'weight' => clb_val(5, $prop, 'stroke'), 'opacity' => clb_val(0.5, $prop, 'opacity'), 'pregran' => TRUE, 'do_bounds' => TRUE, 'max_pts' => 1000, 'calc_len' => FALSE, 'split' => TRUE); $batch = FALSE; if (function_exists('pline_make')) { $batch = pline_make($aoe_data, $attr); } if (is_array($batch)) { $bounds = array_shift($batch); //first element of a batch is the bounds $polyline = array(); foreach ($batch as $no => $line) { //dont use the variable $bounds here as we want to keep the value from above $seg_bounds = clb_val(FALSE, $line, 'bounds'); if ($seg_bounds) { unset($line['bounds']); } $polyline[] = array('ident' => 'seg' . $no, 'pline' => $line); } // $txt = clb_json($polyline); // qlog(__LINE__, $txt); } //qlog(__LINE__, count($batch), $polyline); } $summary = $metric ? pfind_kilo($trip_meters) : pfind_miles($trip_meters); //string with units $html = clb_tag('div', $summary, '', array('style' => 'text-align:right;padding-bottom:0.3em;')) . $html; $result['Bounds'] = $bounds; $result['Polylines'] = $polyline; $result['html'] = $html; $result['NumRoutes'] = 1; //routes between waypoints so waypoints-1 $result['NumGeocodes'] = 2; //number of waypoints with coords $result['CopyrightsHtml'] = '©' . htmlentities('2008' . ' Logoriph Ltd'); $result['SummaryHtml'] = $summary; $result['Distance'] = array('meters' => $meters, 'miles' => pfind_miles($meters, FALSE), 'html' => $summary); $result['Duration'] = array(); $result['Markers'] = $markers; $result['querytime'] = clb_timing('querytime'); qlog(__LINE__, 'package result', $result['querytime']); } return $result; }
function ajax_request() { global $editor_types, $editor_tables; $xml = ''; $msg = ''; $rec_count = 0; $db = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $pnum = clb_val(FALSE, $_REQUEST, 'pnum'); if ($new_mark = preg_match('/^b(\\w{7})(\\w{7})/', $pnum, $m)) { $_REQUEST['lat'] = hexdec($m[1]) / 100000 - 180; $_REQUEST['lng'] = hexdec($m[2]) / 100000 - 180; $_REQUEST['coords'] = clb_b64e($_REQUEST['lat']) . clb_b64e($_REQUEST['lng']); } $ptype = clb_val(FALSE, $_REQUEST, 'ptype'); //if the ptype is cust, default to the first table and type in the definitions that does or does not have a polyline if ($ptype == 'cust' && $new_mark) { foreach ($editor_types as $ptype => $spec) { if (clb_val(FALSE, $spec, 'polyline') == isset($_REQUEST['polyline'])) { break; } } } $table = FALSE; $prefixes = clb_column($editor_tables, 'prefix'); if ($pnum && preg_match('/^(\\w+)_\\w+$/', $pnum, $m)) { $table = array_search($m[1], $prefixes); } else { if ($ptype) { $table = clb_val(FALSE, $editor_types, $ptype, 'table'); } } $spec = clb_val(FALSE, $editor_tables, $table); $ajax = clb_val(FALSE, $_REQUEST, 'ajax'); qlog(__LINE__, '>>>>', $ajax, $pnum, $ptype, $table, $new_mark ? 'new' : 'old'); //, $spec); switch ($ajax) { case 'show': $sel = FALSE; if ($spec) { $select = clb_val(FALSE, $spec, 'select'); $query = 'SELECT ' . clb_join($select, '`') . ' FROM ' . $table . ' WHERE pnum=' . clb_escape($pnum); $sel = $db->get_results($query, ARRAY_A); } //if not found via pnum, try title in each table. if (!$sel) { foreach ($editor_tables as $table => $spec) { if (($select = clb_val(FALSE, $spec, 'select')) && in_array('title', $select)) { $query = 'SELECT ' . clb_join($select, '`') . ' FROM ' . $table . ' WHERE title like ' . clb_escape($pnum . '%'); $sel = $db->get_results($query, ARRAY_A); if ($sel) { break; } } } } if (!$sel) { $msg = 'No matches found for: ' . $pnum; } else { $titles = clb_column($sel, 'title'); $msg = count($sel) . ' matches found: ' . join(', ', $titles); $rec = reset($sel); $pnum = clb_val(FALSE, $rec, 'pnum'); $xml .= clb_tag('response', '', '', array_merge(array('type' => 'centre'), array_intersect_key($rec, array('lat' => 0, 'lng' => 0)))) . "\n"; $xml .= refesh_marker($db, $table, $pnum); $xml .= marker_bubble($db, $spec, $table, $pnum); } break; case 'route_list': //shows bubble on station showing list of routes $html = ''; //find the route table and which field(s) hold the stop list $route_flds = ''; foreach ($editor_tables as $route_tab => $info) { if ($route_flds = clb_val(FALSE, $info, 'routes')) { break; } } if (!$route_flds) { break; } $route_flds = explode('/', $route_flds); //can be more than one field with '/' as a separator //build query to get route list $select = clb_val(FALSE, $editor_tables, $route_tab, 'select'); $where = array(); foreach ($route_flds as $fld) { $where[] = ' (`' . $fld . '` LIKE ' . clb_escape('%' . $pnum . '%') . ')'; } $query = 'SELECT ' . clb_join(array_merge($select, $route_flds), '`') . ' FROM ' . $route_tab . ' WHERE ' . join(' OR ', $where); $sel = $db->get_results($query, ARRAY_A); if (clb_count($sel) == 0) { $msg = 'There are no routes for node: ' . $pnum; } else { $list = ''; $alt = 0; foreach ($sel as $rec) { foreach ($route_flds as $pos => $fld) { $rnum = reset($rec); $route_key = key($rec); $script = 'map_ajax(the_map, \'show_route\', {\'pnum\':\'' . $rnum . '\',\'fld\':\'' . $fld . '\', \'stop\':\'' . $pnum . '\'});'; $name = $rnum . ':' . $pos . ': ' . clb_val(FALSE, $rec, 'title'); $list .= clb_tag('li', '', clb_tag('a', $name, '', array('onclick' => $script, 'href' => 'javascript:void(0);')), array('class' => 'alt' . $alt++ % 2)); } } $html .= clb_tag('ul', '', $list, array('class' => 'route_list')) . "\n"; $form = clb_tag('form', '', $html, array('id' => 'info_win', 'action' => '', 'method' => 'get', 'onsubmit' => 'return false;')) . "\n"; $xml .= clb_tag('response', '', htmlspecialchars($form), array('type' => 'bubble', 'pnum' => $pnum)) . "\n"; } break; case 'new_route': //create new route //create new route case 'route_stop': //add stop to route //add stop to route case 'route_unstop': //remove stop from route //remove stop from route case 'show_route': //show route // qlog(__LINE__, $table, $pnum, $spec); require_once CODE_DIR . 'pline_lib.php'; //scan tables to find routes foreach ($editor_tables as $table => $info) { if ($routes = clb_val(FALSE, $info, 'routes')) { break; } } if (!$routes) { break; } //did not find route table $routes = explode('/', $routes); $route_tab = $table; $select = clb_val(FALSE, $editor_tables, $route_tab, 'select'); $route_key = reset($select); $stops = FALSE; $new_route = 'new_route' == $ajax; if ($new_route) { $fld = reset($routes); $newstop = $pnum; $stopindex = 0; $list = ''; $title = clb_val(FALSE, $_REQUEST, 'title'); $pnum = new_pnum($db, $table, $route_key); $ajax = 'route_stop'; } else { $stopindex = clb_val(FALSE, $_REQUEST, 'stopindex'); //this only come with route_stop and route_unstop $newstop = clb_val(FALSE, $_REQUEST, 'newstop'); //this only come with route_stop $fld = clb_val(FALSE, $_REQUEST, 'fld'); $select = array_merge($select, $routes); //select route record $query = 'SELECT ' . clb_join($select, '`') . ' FROM ' . $route_tab . ' WHERE ' . $route_key . '=' . clb_escape($pnum); $sel = $db->get_results($query, ARRAY_A); $rec = clb_count($sel) ? reset($sel) : FALSE; $list = clb_val(FALSE, $rec, $fld); $ptype = clb_val(FALSE, $rec, 'ptype'); $title = clb_val(FALSE, $rec, 'title'); //if (empty($list) && (reset($routes) == $fld) && ($fld if (empty($list)) { $newstop = clb_val(FALSE, $_REQUEST, 'stop'); $stopindex = 0; $ajax = 'route_stop'; } } if (preg_match_all('/^(\\w+)\\s+(.*)/m', $list, $m)) { $stops = $m[1]; } if (in_array($ajax, array('route_stop', 'route_unstop')) && is_numeric($stopindex)) { if (!$stops) { $stops = array(FALSE); } //ensure loop runs at least once $new = ''; foreach ($stops as $i => $stop_pnum) { if ('route_unstop' == $ajax && $i == $stopindex) { continue; } //skip the stop that is to be deleted //add the stop on this line if ($stop_pnum) { $new .= $m[1][$i] . ' ' . trim($m[2][$i]) . "\n"; } //add new station if this is the right position if ('route_stop' == $ajax && $i == $stopindex && $newstop) { //find maker table via ptype $table = clb_val(FALSE, $editor_types, $ptype, 'table'); $query = 'SELECT lat, lng, pnum, ptype, title FROM ' . $table . ' WHERE pnum=' . clb_escape($newstop); $sel = $db->get_results($query, ARRAY_A); if ($sel) { $new .= $newstop . ' ' . clb_val('', reset($sel), 'title') . "\n"; } } } if (preg_match_all('/^(\\w+)\\s+(.*)/m', $new, $m)) { $stops = $m[1]; } //if forward direction and changing last item update orig, dest and title $rename = ''; if (reset($routes) == $fld && clb_count($stops) <= $stopindex + 2) { $orig = reset($m[2]); $dest = end($m[2]); $rename .= ', title=' . clb_escape($orig . ' - ' . $dest); $rename .= ', orig=' . clb_escape($orig); $rename .= ', dest=' . clb_escape($dest); } if ($new_route) { $query = 'SELECT area, count(*) AS c FROM ' . $route_tab . ' WHERE ptype=' . clb_escape($ptype) . ' GROUP BY area'; $sel = $db->get_results($query, ARRAY_A); $area = is_array($sel) ? clb_val('', reset($sel), 'area') : ''; $query = ''; $query .= ', ' . $route_key . '=' . clb_escape($pnum); $query .= ', area=' . clb_escape($area); $query .= ', ptype=' . clb_escape($ptype); $query .= ', ' . $fld . '=' . clb_escape($new); $query .= ', created=' . clb_escape(clb_now_utc()); $query = 'INSERT INTO ' . $route_tab . ' SET ' . trim($query, ', ') . $rename; } else { $query = 'UPDATE ' . $route_tab . ' SET ' . $fld . '=' . clb_escape($new) . $rename . ' WHERE ' . $route_key . '=' . clb_escape($pnum); } $db->query($query); } if ($stops) { $index = array_search(clb_val(FALSE, $_REQUEST, 'stop'), $stops); //index of the stop we opened route from if (is_numeric($stopindex)) { $index = Min($stopindex + ($newstop ? 1 : 0), clb_count($stops) - 1); } //use new index if provided and add one if new stop if (preg_match('/^(\\w+)_\\w+$/', reset($stops), $m)) { $table = array_search($m[1], $prefixes); $spec = clb_val(FALSE, $editor_tables, $table); $points = array(); $names = array(); $pnums = array(); $query = 'SELECT lat, lng, pnum, ptype, title FROM ' . $table . ' WHERE pnum IN ' . clb_join($stops, TRUE); $sel = $db->get_results($query, ARRAY_A); //in theory could be multiple stop instances and need to give points in order so loop on $stops and look up record via xref $xref = clb_column($sel, 'pnum'); if (clb_count($sel)) { foreach ($stops as $stop_pnum) { $rec = clb_val(FALSE, $sel, array_search($stop_pnum, $xref)); $points[] = array($rec['lat'], $rec['lng'], 0); $names[] = str_replace('|', ',', $rec['title']); $pnums[] = $rec['pnum']; $rec['type'] = 'marker'; $xml .= clb_tag('response', '', '', $rec) . "\n"; $rec_count++; } } foreach ($points as $i => $pt) { if (!is_array($pt)) { unset($points[$i]); } } //remove non points if there are any $line = pline_make($points, array('color' => '#FF0000')); $line['names'] = join('|', $names); $line['pnums'] = join('|', $pnums); if ($line) { $line = clb_join($line, '', '&', '='); } $attr = array('type' => 'route_pline', 'pnum' => $pnum, 'title' => $title, 'fld' => $fld, 'ptype' => $ptype, 'index' => $index); if ($line) { $xml .= clb_tag('response', '', htmlspecialchars($line), $attr) . "\n"; } } } else { $msg = 'This route (in this direction) has no stops. '; } break; case 'overlays': if (clb_val(FALSE, $_REQUEST, 'zm') < 9) { $msg = 'Zoom in to get markers to download.'; } else { $rect = array(); $rect[] = 'lat >= ' . clb_val(FALSE, $_REQUEST, 'bot'); $rect[] = 'lng >= ' . clb_val(FALSE, $_REQUEST, 'lft'); $rect[] = 'lat <= ' . clb_val(FALSE, $_REQUEST, 'top'); $rect[] = 'lng <= ' . clb_val(FALSE, $_REQUEST, 'rgt'); $qtypes = preg_split('/;/', clb_val(FALSE, $_REQUEST, 'types'), -1, PREG_SPLIT_NO_EMPTY); $tables = array(); foreach ($qtypes as $ptype) { $tables[clb_val('bad', $editor_types, $ptype, 'table')][] = $ptype; } if (!count($qtypes)) { $msg = 'No marker types selected.'; } else { foreach ($tables as $table => $list) { if ($table != 'bad' && count($list)) { $prefix = clb_val(FALSE, $editor_tables, $table, 'prefix'); $types = preg_replace('/\\w+_/', '', clb_join($list, TRUE)); $query = ''; $query .= 'SELECT lat, lng, pnum, ptype, title FROM ' . $table . ' WHERE '; $query .= ' ptype IN ' . $types . ' AND (' . join(' AND ', $rect) . ') '; $sel = $db->get_results($query, ARRAY_A); if (clb_count($sel)) { foreach ($sel as $rec) { $rec['type'] = 'marker'; if (!in_array($rec['ptype'], $list)) { $rec['ptype'] = $prefix . '_' . $rec['ptype']; } $xml .= clb_tag('response', '', '', $rec) . "\n"; $rec_count++; } } } } } $msg = $rec_count ? count($sel) . ' markers loaded' : 'No markers found.'; if ('purge' == clb_val(FALSE, $_REQUEST, 'purge')) { $xml .= clb_tag('response', '', '', array('type' => 'purge')) . "\n"; } } break; case 'saveline': require_once CODE_DIR . 'pline_lib.php'; //fall through //fall through case 'save': //no real validation so just save and close if (!$spec) { $msg = 'could not identify the marker type.'; break; } //('polyline'=>'line', 'select'=>' lat, lng, pnum, ptype, title, line, aoe_data') if ($new_mark) { $pnum = new_pnum($db, $table); } //get field names and types $def = array(); $sel = $db->get_results('describe ' . $table, ARRAY_A); foreach ($sel as $rec) { $def[$rec['Field']] = $rec['Type']; } /* normally save line is handled by the normal save but if we are saving a cut line, we need to save off the first part and then use the normal save to create the latter part as a new record dont cut on first or last point of line */ $points = FALSE; if ('saveline' == $ajax) { $points = pline_pts_arr(clb_val(FALSE, $_REQUEST, 'polyline')); //the rest of this is only for cutting a line if (($cut = clb_val(FALSE, $_REQUEST, 'cut')) && $cut + 1 < clb_count($points)) { $first = array_slice($points, 0, $cut + 1); //keep points up to and including cut $points = array_slice($points, $cut); //reduce points on and after cut for new record $query = save_line_query($first, $spec); $query .= '`' . 'lat' . '`=' . clb_escape($_REQUEST['lat']) . ','; $query .= '`' . 'lng' . '`=' . clb_escape($_REQUEST['lng']) . ','; $query .= '`' . 'end1' . '`=' . clb_escape($_REQUEST['end1']) . ','; //adjusts mid point $query .= '`' . 'end2' . '`=' . clb_escape($_REQUEST['end2']) . ','; if ($new_mark) { $query .= '`' . 'pnum' . '`=' . clb_escape($pnum) . ','; $query .= '`' . 'ptype' . '`=' . clb_escape($ptype) . ','; if (isset($def['created'])) { $query .= '`' . 'created' . '`=' . clb_escape(clb_now_utc()) . ','; } $query = 'INSERT INTO ' . $table . ' SET ' . trim($query, ', '); } else { $query = 'UPDATE ' . $table . ' SET ' . trim($query, ', ') . ' WHERE pnum=' . clb_escape($pnum); } $res = $db->query($query); $xml .= refesh_marker($db, $table, $pnum, $pnum); unset($_REQUEST['pnum']); //clear this so that the new marker does not remove the repositioned marker $pnum = new_pnum($db, $table); //new pnum for marker $new_mark = TRUE; } } $query = ''; if ('saveline' == $ajax && is_array($points)) { $query .= save_line_query($points, $spec); } foreach ($def as $fld => $type) { switch ($fld) { case 'pnum': if ($new_mark) { $query .= '`' . $fld . '`=' . clb_escape($pnum) . ','; } break; case 'created': if ($new_mark) { $query .= '`' . $fld . '`=' . clb_escape(clb_now_utc()) . ','; } break; case 'ptype': $query .= '`' . $fld . '`=' . clb_escape($ptype) . ','; break; default: if (isset($_REQUEST[$fld])) { $query .= '`' . $fld . '`=' . clb_escape($_REQUEST[$fld]) . ','; } break; } } qlog(__LINE__, $query); if ($new_mark) { $query = 'INSERT INTO ' . $table . ' SET ' . trim($query, ', '); } if (!$new_mark) { $query = 'UPDATE ' . $table . ' SET ' . trim($query, ', ') . ' WHERE pnum=' . clb_escape($pnum); } $res = $db->query($query); //when saving a marker remember the type to be used as the default for next new marker. $name = clb_val(FALSE, $spec, 'polyline') ? 'type_line' : 'type_mark'; $xml .= clb_tag('response', '', $ptype, array('type' => 'state', 'pnum' => $name)) . "\n"; //pnum is the "id" name is the "id" of the state we are setting $xml .= refesh_marker($db, $table, $pnum, clb_val(FALSE, $_REQUEST, 'pnum')); //want to fall through to show a bubble if saving a line //so break when either condition fails if ('saveline' == $ajax) { $xml .= marker_bubble($db, $spec, $table, $pnum); } break; case 'bubble': if (!$spec || !$pnum) { $msg = 'could not identify the marker type.'; break; } $xml .= marker_bubble($db, $spec, $table, $pnum); break; case 'delete': $query = 'DELETE FROM ' . $table . ' WHERE pnum=' . clb_escape($pnum); $sel = $db->query($query); //remove old marker, which closes info box $xml .= clb_tag('response', '', '', array('type' => 'remove', 'pnum' => $_REQUEST['pnum'])) . "\n"; break; } if ($ajax) { if ($msg) { $xml .= clb_tag('response', $msg, '', array('type' => 'info')) . "\n"; } if (!$xml) { $xml .= clb_tag('response', '', '', array('type' => 'null')) . "\n"; } // qlog(__LINE__, $xml); clb_response('xml', $xml); } }