<?php
require_role(ROLE_CUSTOMER);
function get_orderprocessing_contract()
{
$args = array(
"cid" => (int) $_SESSION['customerinfo']['customerno']);
$result = db_query("SELECT id, signed, type, startdate, enddate FROM kundendaten.contract WHERE customer=:cid AND type='orderprocessing' AND (enddate IS NULL OR enddate < CURDATE())", $args);
if ($result->rowCount() == 0) {
return null;
}
$line = $result->fetch();
return $line;
}
function contract_html()
{
use_module('contacts');
require_once('contacts.php');
$kundenkontakte = get_kundenkontakte();
$kunde = get_contact($kundenkontakte['kunde']);
$adresse = nl2br("\n".filter_input_general($kunde['address'])."\n".filter_input_general($kunde['country']).'-'.filter_input_general($kunde['zip']).' '.filter_input_general($kunde['city']));
$name = filter_input_general($kunde['name']);
if ($kunde['company']) {
$name = filter_input_general($kunde['company'])."<br />".filter_input_general($kunde['name']);
}
$email = filter_input_general($kunde['email']);
$address = "<strong>$name</strong>$adresse</p><p>E-Mail-Adresse: $email";
$date = date('d.m.Y');
$DIR=realpath(dirname(__FILE__).'/..');