uses('tpl');
$tpl = new tpl;
$tpl->newTemplate("../templates/payments_pay.htm");
$error = '';
# Check if payment method = auto
$idhash = $app->db->quote($_GET['id']);
$invoice = $app->db->queryOneRecord("SELECT * FROM invoice WHERE idhash = '$idhash'");
if(!is_array($invoice)) $error .= 'Invalid invoice ID
';
if($invoice['status_paid'] == 'y') $error .= 'This invoice has already been paid.
';
if($invoice['payment_gateway'] == 'none') $error .= 'Payment page has been disabled for this invoice.
';
if($error != '') die($error);
$company = $app->db->queryOneRecord("SELECT * FROM invoice_company WHERE invoice_company_id = ".$invoice['invoice_company_id']);
$invoice_settings = $app->db->queryOneRecord("SELECT * FROM invoice_settings WHERE invoice_settings_id = 1");
$client = $app->db->queryOneRecord("SELECT * FROM client WHERE client_id = ".$invoice['client_id']);
$out = array();
$out['company_logo'] = '../lib/logo/'.$company['company_logo'];
$out['company_name'] = $company['company_name'];
$out['company_street'] = $company['street'];
$out['company_zip'] = $company['zip'];
$out['company_state'] = $company['state'];
$out['company_country'] = $company['country'];
$out['invoice_name'] = $invoice['company_name'];
$out['invoice_street'] = $invoice['street'];
$out['invoice_zip'] = $invoice['zip'];
$out['invoice_state'] = $invoice['state'];
$out['invoice_country'] = $invoice['country'];
$out['invoice_number'] = $invoice['invoice_number'];
$date_parts = explode('-',$invoice['invoice_date']);
$out['invoice_date'] = date($app->lng('conf_format_dateshort'),mktime(0, 0, 0, $date_parts[1] , $date_parts[2], $date_parts[0]));
$out['invoice_amount_formatted'] = $app->functions->currency_format($invoice['invoice_amount'], 'client').' '.$invoice_settings['currency'];
$out['invoice_amount'] = round($invoice['invoice_amount'],2);
$out['invoice_currency'] = $invoice_settings['currency'];
$out['invoice_idhash'] = $invoice['idhash'];
$out['paypal_business'] = $invoice_settings['paypal_business'];
/*
Test: 'https://www.sandbox.paypal.com/cgi-bin/webscr';
Real: 'https://www.paypal.com/cgi-bin/webscr';
*/
$out['paypal_url'] = $invoice_settings['paypal_url'];
$ispconfig_url = $app->functions->get_ispconfig_url();
$out['paypal_notify_url'] = $invoice_settings['paypal_ipn_url'];
$out['paypal_success_url'] = $ispconfig_url.'/billing/payments/success.php';
$out['paypal_cancel_url'] = $ispconfig_url.'/billing/payments/cancel.php';
$out['paypal_visible'] = ($invoice_settings['paypal_active'] == 'y')?1:0;
$tpl->setVar($out);
$wb = array();
if(isset($_SESSION['s']['language'])) {
$language = $_SESSION['s']['language'];
} else {
$language = $client['language'];
}
$lng_file = '../lib/lang/'.$language.'_payments_pay.lng';
if(is_file($lng_file)) include($lng_file);
$tpl->setVar($wb);
echo $tpl->grab();
?>