$where_clause .= sprintf(' AND (date_end < "%s" AND date_end > "%s")', $expire_date, $today_date); } echo '<form action="index.php?sec=customers&sec2=operation/contracts/contract_detail" method="post">'; echo "<table width=99% class='search-table'>"; echo "<tr>"; echo "<td colspan=2>"; echo print_input_text("search_text", $search_text, "", 38, 100, true, __('Search')); echo "</td>"; echo "<td>"; echo print_select(get_company_roles(), 'search_company_role', $search_company_role, '', __('All'), 0, true, false, false, __('Company roles')); echo "</td>"; echo "<td>"; echo print_select(get_contract_status(), 'search_status', $search_status, '', __('Any'), -1, true, false, false, __('Status')); echo "</td>"; echo "<td>"; echo print_select(get_contract_expire_days(), 'search_expire_days', $search_expire_days, '', __('None'), 0, true, false, false, __('Out of date')); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>"; echo print_input_text('search_date_begin_beginning', $search_date_begin_beginning, '', 15, 20, true, __('Begining From')); echo "<a href='#' class='tip'><span>" . __('Date format is YYYY-MM-DD') . "</span></a>"; echo "</td>"; echo "<td>"; echo print_input_text('search_date_end_beginning', $search_date_end_beginning, '', 15, 20, true, __('Begining To')); echo "<a href='#' class='tip'><span>" . __('Date format is YYYY-MM-DD') . "</span></a>"; echo "</td>"; echo "<td>"; echo print_input_text('search_date_begin', $search_date_begin, '', 15, 20, true, __('Ending From')); echo "<a href='#' class='tip'><span>" . __('Date format is YYYY-MM-DD') . "</span></a>"; echo "</td>";
echo "<td colspan=2>"; echo print_input_text ("search_text", $search_text, "", 38, 100, true, __('Search')); echo "</td>"; echo "<td>"; echo print_select (get_company_roles(), 'search_company_role', $search_company_role, '', __('All'), 0, true, false, false, __('Company roles')); echo "</td>"; echo "<td>"; echo print_select (get_contract_status(), 'search_status', $search_status, '', __('Any'), -1, true, false, false, __('Status')); echo "</td>"; echo "<td>"; echo print_select (get_contract_expire_days(), 'search_expire_days', $search_expire_days, '', __('None'), 0, true, false, false, __('Out of date')); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>"; echo print_input_text ('search_date_begin_beginning', $search_date_begin_beginning, '', 15, 20, true, __('Begining From')); echo "<a href='#' class='tip'><span>". __('Date format is YYYY-MM-DD')."</span></a>"; echo "</td>"; echo "<td>"; echo print_input_text ('search_date_end_beginning', $search_date_end_beginning, '', 15, 20, true, __('Begining To')); echo "<a href='#' class='tip'><span>". __('Date format is YYYY-MM-DD')."</span></a>";