https://webapps.mandela.ac.za/Laundryst




http://dev.nmmu.ac.za/Zanomzi/transportTest





Select * from NMU_TRANSPORT_VEHICLESELECT
   
   select
    schedule_id,
    name,
    schedule_description,
    period_fromdate,
    period_todate,
    area,
    area_description,
    date_schedule_created,
    route_id,
    is_active
FROM
  delete  from  nmu_transport_schedule
  where schedule_id =44
    
    select nmu_transport_route
    
    select * from NMU_TRANSPORT_SCHEDULE_ROUTE
    

select * from  NMU_TRANSPORT_SCHEDULE_ROUTE

    
    SELECT
    route_id,
    route_name,
    route_description,
    area,
    area_description
FROM
    nmu_transport_route;
    
    
    21
61
62
    
    
    
    
    
    SELECT
    route_stop_id,
    route_id,
    pickup_point_id,
    time,
    stop_interval,
    stop_sequence,
    additional_info,
    schedule_id,
    arrive_time
FROM
    nmu_transport_route_stops;
    
    
    select * from schedule 
    
    
    
    select * from NMU_TRANSPORT_ROUTE_STOPS
    
    
    
    
    
    
    
    
    delete from NMU_TRANSPORT_SCHEDULE
    where schedule_id=44
    
     delete from NMU_TRANSPORT_SCHEDULE_ROUTE
    where schedule_id=44
    
   delete  NMU_TRANSPORT_ROUTE_STOPS
 where schedule_id=44
    
delete  NMU_TRANSPORT_SCHEDULE_VEHICLE
where schedule_id=44
    
    
select * from NMU_TRANSPORT_SCHEDULE
where schedule_id ='21'
select * from NMU_TRANSPORT_SCHEDULE_ROUTE;

select st.route_stop_id As RouteID, tpp.description As Description ,st.time As Time ,st.stop_sequence As Seq,st.additional_info As AdditionalInfo from NMU_TRANSPORT_ROUTE_STOPS st,nmu_transport_pickup_points tpp
where st.pickup_point_id =tpp.id  and  st.schedule_id ='21'
order by st.route_stop_id

select * from nmu_transport_pickup_points
select * from NMU_TRANSPORT_ROUTE_STOPS

select * from NMU_TRANSPORT_SCHEDULE_VEHICLE

select ntsv.schedule_id As Id  ,ntsv.vehicle As Registration, ntsr.route_name As RoutName  from NMU_TRANSPORT_SCHEDULE_VEHICLE ntsv,NMU_TRANSPORT_ROUTE ntsr
WHERE  ntsv.route_id = ntsr.route_id
and ntsv.schedule_id =21
    
    select * from NMU_TRANSPORT_SCHEDULE_VEHICLE NMTSV,
    WHERE NMTSV.ROUTE_ID =