<?php
require_role(ROLE_CUSTOMER);
function get_orderprocessing_contract()
{
$args = [
"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_output_html($kunde['address'] . "\n" . $kunde['country'] . '-' . $kunde['zip'] . ' ' . $kunde['city']));
$name = filter_output_html($kunde['name']);
if ($kunde['company']) {
$name = filter_output_html($kunde['company']) . "<br />" . filter_output_html($kunde['name']);
}
$email = filter_output_html($kunde['email']);
$address = "<strong>$name</strong>$adresse</p><p>E-Mail-Adresse: $email";
$date = date('d.m.Y');
$DIR = realpath(dirname(__FILE__) . '/..');
$vertrag = file_get_contents($DIR . '/vertrag.html');
$vertrag = str_replace('((ADRESSE))', $address, $vertrag);