Schedule Search (Airline, Aircraft, Arrival, Departure)

[twincessna340a]

Could you post it on github please?

[simpilot]

Could you post it on github please?

It has been added to Github.

[flyalaska]

How can I make the width of the forms smaller?

[simpilot]

How can I make the width of the forms smaller?

You can adjust the width of the select boxes using style with a width attribute applied to the select;

<select name="name" style="width: 300px">
//Options
</select>

[flyalaska]

TY!!

[HighFlyerPL185]

Hi there. I was wondering, how can I replace the icao aircraft name with the full name of it? I've tried this, but it returns an empty list and only shows the "All" option...

{echo '<option value="'.$aircraft->fullname.'">'.$aircraft->fullname.'</option>';}

[Jeff]

I have tried many, many configurations on trying to change it, and also left multiple posts about getting it to work like that. I have even removed the Aircraft search altogether for about 2 months because of the way it looked with what I wanted to achieve, but placed it back. Dave, I hope you can shed some light on this subject, as I am still baffled myself on the calling of the aircraft.

[flyalaska]

echo '<option value="'.$equip->fullname.'">'.$equip->fullname.'</option>';

[flyalaska]

NM, that came up blank too

[simpilot]

You will need to change the functions to look for the aircraft data and search for schedule data in the FrontSchedulesData.class.php file.

  public function findschedules($arricao, $depicao, $airline, $aircraft)   {
    $query = "SELECT phpvms_schedules.*, phpvms_aircraft.fullname AS aircraft, phpvms_aircraft.registration
		    FROM phpvms_schedules, phpvms_aircraft
		    WHERE phpvms_schedules.depicao LIKE '$depicao'
		    AND phpvms_schedules.arricao LIKE '$arricao'
		    AND phpvms_schedules.code LIKE '$airline'
		    AND phpvms_schedules.aircraft LIKE '$aircraft'
		    AND phpvms_aircraft.id LIKE '$aircraft'";
    return DB::get_results($query);
   }


   public function findaircrafttypes() {
    $query = "SELECT DISTINCT fullname
		    FROM phpvms_aircraft";
    return DB::get_results($query);
   }

   public function findaircraft($aircraft) {
    $query = "SELECT id
		    FROM phpvms_aircraft
		    WHERE fullname='$aircraft'";
    return DB::get_results($query);
   }

And on line 33 of airport_search.tpl change it to;

{echo '<option value="'.$aircraft->fullname.'">'.$aircraft->fullname.'</option>';}

[HighFlyerPL185]

Thank you! That worked brilliantly!

[Tylor Eddy]

G'day Simpilot,

I have had some issues with this search function leaving schedules out of the list when it populates the data, quite a few schedules are being missed by the search, and yet display correctly on the admin side, im unsure why but if you have any idea any help would be handy

Tylor

[simpilot]

What do the missing schedules have in common? Day of the week missing, active, etc....

[michael Kraan]

(solved)

(i dont now how i can remove this message)

he,

i have a problem with the schedule search system.

example:

Departure Airfield EGLL

Arrival Airfield EHAM

Than give the system all schedules from EGLL and not only EGLL to EHAM.

when i search on airliner than i have the same problem that the system not search on the one airliner but of all my airliners.

o hope that you can help me.

[Steve Bartlett]

Rather than pointing my browser to this schedule search, I want it to come up when my pilots click on View Schedules in the Pilot Center, in that case, where do I put this?

(echo sight url preferred)/index.php/FrontSchedules .

[Kyle]

Rather than pointing my browser to this schedule search, I want it to come up when my pilots click on View Schedules in the Pilot Center, in that case, where do I put this?

(echo sight url preferred)/index.php/FrontSchedules .

I believe your looking for this...

<a href="<?php echo url('/FrontSchedules');?>">View Flight Schedules</a>

[Steve Bartlett]

I believe your looking for this...

<a href="<?php echo url('/FrontSchedules');?>">View Flight Schedules</a>

Yes, but I need to know where to put it, so that when my pilots click on "View Flight Schedules" from the pilot center, it will go to this schedule system instead of the default.

[simpilot]

Yes, but I need to know where to put it, so that when my pilots click on "View Flight Schedules" from the pilot center, it will go to this schedule system instead of the default.

You need to replace the link in your template that is in place for the default schedules with this one.

[Steve Bartlett]

Okay, thank you sir! It worked.

[simonecatalano]

I have one problem ... NOT VIEW THE SCHEDULE "Not routes"

Why?

[Remington Box]

Is there a way to get the search form and the schedule results on the same page? I tried

 $this->set('allroutes', $routes);
 $this->show('airport_search.tpl');
 $this->show('schedule_results.tpl');

}

but the form comes up totally empty after the first search is completed.

http://www.spark-jet.com/index.php/FrontSchedules

[HighFlyerPL185]

Is there a way to get the search form and the schedule results on the same page? I tried

$this->set('allroutes', $routes);
$this->show('airport_search.tpl');
$this->show('schedule_results.tpl');

}

but the form comes up totally empty after the first search is completed.

http://www.spark-jet.../FrontSchedules

I'd love to know as well.

[simpilot]

Are you filling the variables with the data needed for the form?

[Omerr01]

Module creates a schedule search form that includes the ability to choose the airline, aircraft type, arrival field, and departure field. You can choose one or all of the parameters to find what you are looking for in your schedule database.

To install

Download and unzip

Place the files in the proper paths as structured in the download

No new sql tables or anything needed.

Point your browser to mysite/index.php/FrontSchedules and start searching.

Enjoy!

Code hosted on Github - Link In Signature.

hello sir ..

i have this moudle but all pilots can do "add to bid" .

and i don't want becuse i have There are restrictions on ranks .

Example:

Pilot to 50 hours can not fly for heavy aircraft like 747 777 767 ..

but now all pilot can do add to bid .

how i can do they can make the bid only by their rank.

As usual schedule search .

please help me ..

[simpilot]

You just need to make the same adjustments to the schedule results as you did in the default schedule results.

[Ashj24uk]

was wondering if it would be possible to add a new field etc for flight length?

[RocketRod]

I really like this module. It works out of the box. I have read the posts in the thread, and done other searches in the forums and haven't found the info I seek. Is it possible with this module, or anything else for a pilot, to search for routes by their assigned hub? All pilots are assigned to a hub, but schedules are not in anyway that I see linked to a hub. Some reading of posts in the forums suggest that is correct. There are mods for hub stats, hub transfers and others. So when a pilot is assigned to a hub, and searches either through the pilot center or through a link to this mod, the departure is their assigned hub, and the arrival is those airports from the schedule table. That was the way we originally built our schedules that were a manual process of selection. Can what I want be done or has anyone else done something like that?

[RocketRod]

I have done some more research on searching by assigned hub. That problem is compounded by not having a column in the schedule table that identifies the depicao as a hub. I also saw this post for a mod, http://forum.phpvms....l__+sort +order but don't think I will do that. What looks to be a better solution is to put the hubs at the top of the depicao & arricao list. So i have re-odered my airport db table to show the hubs first, then all other airports. Yet it doesn't display that when you call the airport_search.tpl. Looking at the FrontSchedulesData.class.php I don't see where it instructs the search to be alphabetic by icao (which I don't want). I want it to display the depicao and arricao as I have them in the db table. Any help would be appreciated.

Not the solution I wanted, but this works for now;

http://forum.phpvms.net/topic/5309-modified-simpilots-frontschedule-search/page__hl__%2Bsort+%2Border

[Toyuko]

Hello i am attempting to get your Flight Search module up onto my pilot center using this code:

<?php Template::Show('airport_search.tpl'); ?>

However all i get is this when it comes up:

Is there a fix for this issue? All the field are of 'all' when there is suppose to be data there.

Thanks

[simpilot]

@toyuko - Using that is just going to load the template with out any data. In your controller for your pilot center add these;

$this->set('airports', OperationsData::GetAllAirports());
$this->set('airlines', OperationsData::getAllAirlines());
$this->set('aircrafts', FrontSchedulesData::findaircrafttypes());
$this->set('countries', FrontSchedulesData::findcountries());