Exemplo n.º 1
0
                }
            }
            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)) {
Exemplo n.º 2
0
                 }
             }
             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)) {
Exemplo n.º 3
0
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']);
Exemplo n.º 4
0
						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 {
Exemplo n.º 5
0
        }
        $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);
Exemplo n.º 6
0
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>&nbsp;</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'] . '&amp;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);
Exemplo n.º 7
0
                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);