function createAirTrainBooking($bean, $chuyenbay = '')
{
global $db;
$sql = "\r\n SELECT \r\n a.id \r\n FROM\r\n `airlinestickets` a \r\n JOIN `airlines_ailinestickets_c` b \r\n ON a.`id` = b.`airlines_a1d09tickets_idb` \r\n AND b.`deleted` = 0 \r\n AND b.`airlines_a476cirlines_ida` = '{$chuyenbay->vemaybay}' \r\n JOIN `groupprogralinestickets_c` c \r\n ON a.`id` = c.`groupprogr8400tickets_idb` \r\n AND c.`deleted` = 0 \r\n AND c.`groupprogr0fd9rograms_ida` = '{$bean->id}' \r\n WHERE a.`deleted` = 0 \r\n ";
$airTrainBooking = new AirlinesTickets();
$result = $db->query($sql);
while ($row = $db->fetchByAssoc($result)) {
$airTrainBooking->id = $row['id'];
}
$airTrainBooking->groupprograestickets_name = $bean->name;
$airTrainBooking->groupprogr0fd9rograms_ida = $bean->id;
$airTrainBooking->airlines_a476cirlines_ida = $chuyenbay->vemaybay;
$airline = new Airline();
$getname_input = array('name' => 'id', 'value' => $chuyenbay->vemaybay);
$airTrainBooking->airlines_aiestickets_name = getName($airline->table_name, $getname_input);
$airTrainBooking->name = $airTrainBooking->groupprograestickets_name . ' - ' . $airTrainBooking->airlines_aiestickets_name;
$airTrainBooking->assigned_user_name = $bean->assigned_user_name;
$airTrainBooking->assigned_user_id = $bean->assigned_user_id;
$return = $airTrainBooking->save();
return $return;
}
