if (!empty($_POST['driverlogin'])) {
$data_type1 = '';
$data_type2 = '';
if(!empty($_GET['sort'])) { $sorting = $_GET['sort'];
if($sorting == 'prize') {
$order = 'prize';
$data_type1 = 'ABS(';
$data_type2 = ')';
$sorting_val = 'Цене';
}
if($sorting == 'hum') {
$order = 'hum';
$sorting_val = 'Цене';
}
if($sorting == 'phone') {
$order = 'phone';;
$sorting_val = 'Телефону';
}
if($sorting == 'from') {
$order = 'from';
$sorting_val = 'Месту отправления';
}
if($sorting == 'to') {
$order = 'to';
$sorting_val = 'Месту назначения';
}
if($sorting == 'last') {
$order = 'm_id';
$sorting_val = 'Последней заявке';
}
}
else {
$order = 'm_id';
$sorting_val = 'Последней заявке';
}
if(!empty($_GET['direction'])) { $direction = $_GET['direction'];
if($direction == 'asc') {
$d = 'ASC';
$direction_val = 'В порядке возрастания';
}
if($direction == 'desc') {
$d = 'DESC';
$direction_val = 'В порядке убывания';
}
}
else {
$d = 'DESC';
$direction_val = 'В порядке убывания';
}
if($act == 'home') {
$all_tickets = mysql_query("SELECT * FROM all_tickets a WHERE (a.m_city = '$m_city') AND NOT EXISTS (SELECT * FROM banned_tickets bn WHERE a.m_phone = bn.bn_phone AND bn.bn_login = '$driverlogin') AND NOT EXISTS (SELECT * FROM accepted_tickets at WHERE a.m_m_id = at.ac_m_id AND at.ac_login = '$driverlogin') AND NOT EXISTS (SELECT * FROM archived_tickets ar WHERE a.m_m_id = ar.ar_m_id AND ar.ar_login = '$driverlogin') ORDER BY $data_type1 m_$order $data_type2 $d LIMIT $startTicket, $limit") or
die(mysql_error()); }
if($act == 'accepted') {
$accepted_tickets_order_ac_m_id = mysql_query("SELECT * FROM accepted_tickets ac WHERE ac.ac_login = '$driverlogin' AND NOT EXISTS (SELECT * FROM approved_tickets ap WHERE ac.ac_m_id = ap.ap_m_id AND ap.ap_login = '$driverlogin') ORDER BY $data_type1 ac_$order $data_type2 $d LIMIT $startTicket, $limit") or
die(mysql_error());
if ($ticket['ac_date'] == date('d.m.y')) { $ticket_date = 'Сегодня';
}
$ticket_date = 'Вчера';
}
else {
$ticket_date = $ticket['ac_date'];
}
$ticket_data[] = '
<div class="ticket">
<div class="ticket_lft">
<p><a target="_blank" href="http://maps.yandex.ru/?text='.$ticket['ac_from'].'"><strong>Откуда:</strong> '.$ticket['ac_from'].'</a></p>
<p><a target="_blank" href="http://maps.yandex.ru/?text='.$ticket['ac_to'].'"><strong>Куда:</strong> '.$ticket['ac_to'].'</a></p>
<p><strong>Телефон:</strong> '.$ticket['ac_phone'].'</p>
</div>
<div class="ticket_rt">
<!--a title="Переместить в корзину" class="to_archive" href="">X</a-->
<p>'.$ticket_date.', '.$ticket['ac_time'].'</p>
<p>'.$ticket['ac_prize'].'</p>
<p>'. $ticket['ac_hum'] . pluralForm($ticket['ac_hum'], ' человек', ' человека', ' человек').'</p>
</div>
<div class="clear"></div>
<div class="buttons">
<h3>Вы в списке кандидатов на эту поездку!</h3>
<input type="hidden" name="ac_login" value="'.$driverlogin.'">
<input type="hidden" name="ac_m_id" value="'.$ticket['ac_m_id'].'">
<input type="hidden" name="ac_from" value="'.$ticket['ac_from'].'">
<input type="hidden" name="ac_to" value="'.$ticket['ac_to'].'">
<input type="hidden" name="ac_hum" value="'.$ticket['ac_hum'].'">
<input type="hidden" name="ac_prize" value="'.$ticket['ac_prize'].'">
<input type="hidden" name="ac_phone" value="'.$ticket['ac_phone'].'">
<input type="hidden" name="ac_date" value="'.$ticket['ac_date'].'">
<input type="hidden" name="ac_time" value="'.$ticket['ac_time'].'">
</div>
</div>
';
}
}
if($act == 'approved') {
$approved_tickets_order_ar_m_id = mysql_query("SELECT * FROM approved_tickets WHERE ap_login = '$driverlogin' ORDER BY $data_type1 ap_$order $data_type2 $d LIMIT $startTicket, $limit") or
die(mysql_error()); }
if($act == 'banned') {
$banned_tickets_order_bn_id = mysql_query("SELECT * FROM banned_tickets WHERE bn_login = '$driverlogin' ORDER BY bn_id DESC LIMIT $startTicket, $limit") or
die(mysql_error()); }
if($act == 'trash') {
$archived_tickets_order_ar_m_id = mysql_query("SELECT * FROM archived_tickets WHERE ar_login = '$driverlogin' ORDER BY $data_type1 ar_$order $data_type2 $d LIMIT $startTicket, $limit") or
die(mysql_error()); }
}