import('Database'); $entry = $this->entries[0]; $objPageLink = $this->Database->prepare("SELECT id FROM tl_page WHERE taxonomyid=?;")->execute($entry['data']['category_new']['raw']); // get customer data $objCustomer = NULL; $objCustomer = $this->Database->prepare("SELECT cu.* FROM catalog_best_web AS ca JOIN tl_dag_customers cu ON( cu.id=ca.customer_id ) WHERE ca.id=?")->limit(1)->execute($entry['id']); if( $objCustomer->next() ) { if( $objCustomer->firstname && $objCustomer->lastname ) $entry['data']['operator']['raw'] = empty($entry['data']['operator']['raw']) ? $objCustomer->firstname.' '.$objCustomer->lastname : $entry['data']['operator']['raw']; if( $objCustomer->company ) $entry['data']['operator']['raw'] = empty($entry['data']['operator']['raw']) ? $objCustomer->company : $entry['data']['operator']['raw']; if( $objCustomer->street ) $entry['data']['street']['raw'] = empty($entry['data']['street']['raw']) ? $objCustomer->street : $entry['data']['street']['raw']; if( $objCustomer->postal ) $entry['data']['postal']['raw'] = empty($entry['data']['postal']['raw']) ? $objCustomer->postal : $entry['data']['postal']['raw']; if( $objCustomer->city ) $entry['data']['city']['raw'] = empty($entry['data']['city']['raw']) ? $objCustomer->city : $entry['data']['city']['raw']; if( $objCustomer->country ) $entry['data']['country']['raw'] = empty($entry['data']['country']['raw']) ? $objCustomer->country : $entry['data']['country']['raw']; if( $objCustomer->phone ) $entry['data']['phone']['raw'] = empty($entry['data']['phone']['raw']) ? $objCustomer->phone : $entry['data']['phone']['raw']; if( $objCustomer->fax ) $entry['data']['fax']['raw'] = empty($entry['data']['fax']['raw']) ? $objCustomer->fax : $entry['data']['fax']['raw']; if( $objCustomer->email ) $entry['data']['email']['raw'] = empty($entry['data']['email']['raw']) ? $objCustomer->email : $entry['data']['email']['raw']; } ?>

Hier geht es zum Shop
  Zurück zur Shop-Übersicht