[pgrouting-dev] About Darp Brach and openvrp

guigra_guigra · December 5, 2011, 10:39am

Hello

I compile and running pgrouting darp branch on my ubuntu linux. I download Openvrp demos too.

I have some problems integrating openvrp and darp functions.

I have problems with some params: depot_id, depot_position_id and penalty query for darp function. I don´t understand depot_position_id .

Can send me some samples to integrate openvrp and darp branch?

darp function signature:


CREATE OR REPLACE FUNCTION darp(orders_sql text, vehicles_sql text, distance_sql text, depot_id integer, depot_point_id integer, penalties_sql text)

        RETURNS SETOF itinerary
        AS '$libdir/librouting_darp'

        LANGUAGE 'C' IMMUTABLE STRICT;

openvrp call to darp function on  darp.php file:

 function calculate()
        {
                $data = array(
                        'depot_id' => $this->input->post('depot_id')
,
                        'nearest'  => $this->input->post('nearest'),

                        'method'   => $this->input->post('method')
                );

                $sql = "SELECT b.*, [a.id](http://a.id/), a.order_id, vehicle_id,pick_up, to_char(at, 'YYYY-MM-DD HH24:MI:SS'::text) AS at

                                        FROM darp(
                                                'SELECT * FROM darp_orders WHERE depot_id IN (0,".$data['depot_id'].")',
                                                'SELECT * FROM darp_vehicles WHERE depot_id = ".$data['depot_id']."',

                                                '".$distance = $this->_getdistances($data)."',
 
                                        ) a LEFT JOIN (SELECT * FROM 
darp_report WHERE depot_id IN (0,".$data['depot_id'].")) AS b ON 
(a.order_id = [b.id](http://b.id/));";

                $query = $this->db->query($sql);
                $this->output->set_output($this->_encode($query));
            }

Thank's in advance

guigra_guigra · December 8, 2011, 3:47pm