} } echo implode(', ', $rooms); echo '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_name'] . '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_phone'] . '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_email'] . '</td>' . chr(10); echo ' </tr>' . chr(10); } } echo '</table>' . chr(10); } $filters = array(); $filters = addFilter($filters, 'customer_id', $customer['customer_id']); $filters = addFilter($filters, 'deleted', true); $SQL = genSQLFromFilters($filters, '*') . ' order by time_start'; $Q_next_entries = mysql_query($SQL); if (mysql_num_rows($Q_next_entries)) { echo '<h2>Slettede bookinger knyttet til ' . $customer['customer_name'] . '</h2>' . chr(10); filterLink($filters); echo '<br><br>' . chr(10) . chr(10); echo '<table style="border-collapse: collapse;">' . chr(10); echo ' <tr>' . chr(10); echo ' <td class="border"><b>' . __('Starts') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . __('Name') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . __('Where') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . __('Contact person') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . __('Phone') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . __('E-mail') . '</b></td>' . chr(10); echo ' </tr>' . chr(10); while ($R = mysql_fetch_assoc($Q_next_entries)) {
} } echo implode(', ', $rooms); echo '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_name'] . '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_phone'] . '</td>' . chr(10); echo ' <td class="border">' . $entry['contact_person_email'] . '</td>' . chr(10); echo ' </tr>' . chr(10); } } echo '</table>' . chr(10); } echo '</td>' . '<td>'; $filters = array(); $filters = addFilter($filters, 'customer_id', $customer2['customer_id']); $SQL = genSQLFromFilters($filters, 'entry_id') . ' order by time_start'; $Q_next_entries = mysql_query($SQL); if (!mysql_num_rows($Q_next_entries)) { echo '<i>Ingen</i>' . chr(10); } else { echo '<span style="color:green">Flyttes til kunde 1:</span><br>'; echo '<table style="border-collapse: collapse;">' . chr(10); echo ' <tr>' . chr(10); echo ' <td class="border"><b>' . _('Starts') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . _('Name') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . _('Where') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . _('Contact person') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . _('Phone') . '</b></td>' . chr(10); echo ' <td class="border"><b>' . _('E-mail') . '</b></td>' . chr(10); echo ' </tr>' . chr(10); while ($R_entry = mysql_fetch_assoc($Q_next_entries)) {
GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. */ include_once "glob_inc.inc.php"; filterMakeAlternatives(); if (!isset($_GET['filters'])) { $_GET['filters'] = ''; } $filters = filterGetFromSerialized($_GET['filters']); if (!$filters) { $filters = array(); } $SQL = genSQLFromFilters($filters, 'entry_id'); $SQL .= " order by `time_start`"; $Q = mysql_query($SQL); /* $xml->addAttribute('area', 6); // $area['area_id']); $xml->addAttribute('area_name', 'Vitenfabrikken'); // $area['area_name']); $varer = $xml->addChild('varer'); while($entry = mysql_fetch_assoc($Q)) { if($entry['num_person_child'] > 0) { $vare = $varer->addChild($entry['entry_id'].'_barn'); $vare->addChild('vare_id', '5'); $vare->addChild('tid', $entry['time_start']);
if (top.opener && !top.opener.closed) { top.opener.selectCustomer(id); top.close(); } } </script>'; echo '<table>'; while ($R = mysql_fetch_assoc($Q_customer)) { $customer = getCustomer($R['customer_id']); $filter = addFilter(array(), 'customer_id', $customer['customer_id']); $filters_serialized = filterSerialized($filter); echo ' <tr>' . chr(10); echo ' <td><b>' . '<input type="button" onclick="chooseCustomer(\'' . $customer['customer_id'] . '\'); return false;" value="' . _('Choose this customer') . '"> ' . 'Kundenr ' . $customer['customer_id'] . ', ' . '<a href="customer.php?customer_id=' . $customer['customer_id'] . '">' . iconHTML('group') . ' ' . $customer['customer_name'] . '</a></b></td>' . chr(10); echo ' <td style="vertical-align: middle;">' . ' (<a href="entry_list.php?filters=' . $filters_serialized . '">' . mysql_num_rows(mysql_query(genSQLFromFilters($filter, 'entry_id'))) . ' bookinger</a>)' . '</td>' . chr(10); echo ' </tr>' . chr(10) . chr(10); } echo '</table>'; echo '<br><br>'; echo '<form method="get">'; echo '<input type="hidden" name="customer_name" value="' . $data['customer_name'] . '">'; echo '<input type="hidden" name="customer_add_force" value="yes">'; echo '<input type="submit" value="Nei, jeg vil opprette ny">'; echo '</form>'; echo '</body></html>'; exit; } } } } else {
} $return_to = 'customer_list'; break; case 'deleted': $entry_list_heading = 'Slettede bookinger'; if (!isset($_GET['filters'])) { $_GET['filters'] = ''; } $filters = filterGetFromSerialized($_GET['filters']); if (!$filters) { $filters = array(); $filters = addFilter($filters, 'deleted', true); } break; $return_to = 'customer_list'; break; default: $entry_list_heading = __('Entry list'); if (!isset($_GET['filters'])) { $_GET['filters'] = ''; } $filters = filterGetFromSerialized($_GET['filters']); if (!$filters) { $filters = array(); } $return_to = 'entry_list'; break; } $SQL = genSQLFromFilters($filters, '*'); $SQL .= " order by `time_start`" . $addAdfterSQL; $Q = mysql_query($SQL);
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. */ require "glob_inc.inc.php"; filterMakeAlternatives(); print_header($day, $month, $year, $area); $Q = mysql_query("SELECT customer_id FROM `customer` WHERE `slettet` = '0' ORDER BY customer_name"); echo '<h1>' . _('Customers') . '</h1>' . chr(10); echo '- ' . iconHTML('group_add') . ' <a href="customer_edit.php?returnToCustomerView=1">' . _('Create new customer') . '</a><br><br>' . chr(10); echo '<table>' . chr(10); //echo ' <tr>'.chr(10); //echo ' <td><b>'._('Customer').'</b></td>'.chr(10); //echo ' <td> </td>'.chr(10); //echo ' </tr>'.chr(10).chr(10); while ($R = mysql_fetch_assoc($Q)) { $customer = getCustomer($R['customer_id']); if (count($customer)) { $filter = addFilter(array(), 'customer_id', $customer['customer_id']); $filters_serialized = filterSerialized($filter); echo ' <tr>' . chr(10); echo ' <td><b>' . '<a href="customer.php?customer_id=' . $customer['customer_id'] . '">' . iconHTML('group') . ' ' . $customer['customer_name'] . '</a></b></td>' . chr(10); echo ' <td><font size="1">' . '<a href="customer_edit.php?customer_id=' . $customer['customer_id'] . '&returnToCustomerList=1">' . iconHTML('group_edit') . ' ' . _('Edit') . '</a>' . ' -:- <a href="entry_list.php?filters=' . $filters_serialized . '">' . iconHTML('page_white') . ' ' . _('View entries') . '</a> (' . mysql_num_rows(mysql_query(genSQLFromFilters($filter, 'entry_id'))) . ')' . '</font></td>' . chr(10); echo ' </tr>' . chr(10) . chr(10); } } echo '</table>' . chr(10);
header('Location: invoice_tobemade_ready.php?filters=' . $filters_serialized); break; case 'invoice_tobemade': header('Location: invoice_tobemade.php?filters=' . $filters_serialized); break; case 'invoice_exported': header('Location: invoice_exported.php?filters=' . $filters_serialized); break; default: echo 'Return to not found. Code error.'; break; } exit; } } $SQL = genSQLFromFilters($filters); print_header($day, $month, $year, $area); echo '<h1>' . __('View / Edit filters') . '</h1>' . chr(10) . chr(10); echo '<script language="javascript" src="js/jquery-1.3.2.min.js"></script>' . chr(10); echo 'Velg bookinger hvor:'; echo '<form method="get" name="filters" action="' . $_SERVER['PHP_SELF'] . '">' . chr(10); echo '<table id="filterrows">' . chr(10); $id = -1; $run_after = ''; foreach ($filters as $filter) { $id++; echo '<tr id="row' . $id . '">' . chr(10); echo '<input type="hidden" name="rows[]" value="' . $id . '">' . chr(10); //$run_after = 'selectFilterType('.$id.');'.chr(10); echo '<td>'; echo '<select name="filter[' . $id . ']" onchange="selectFilterType(' . $id . ');" id="filter' . $id . '">' . chr(10);