*/
$whmcs = Application::getInstance();
$pid = $whmcs->get_req_var('pid');
$currencyid = $whmcs->get_req_var('currencyid');
// Verify user input for pid exists, is numeric, and as is a valid id
if (is_numeric($pid)) {
$data = Capsule::table('tblproducts')
->where('id', '=', $pid)
->first();
$pid = $data->id;
$paytype = $data->paytype;
} else {
$pid = '';
}
if (!$pid) {
widgetoutput('Product ID Not Found');
}
$currencyid = $whmcs->get_req_var('currency');
// Support for older currencyid variable
if (!$currencyid) {
$currencyid = $whmcs->get_req_var('currencyid');
}
if (!is_numeric($currencyid)) {
$currency = array();
} else {
$currency = getCurrency('', $currencyid);
}
if (!$currency || !is_array($currency) || !isset($currency['id'])) {
$currency = getCurrency();
}
$currencyid = $currency['id'];
$data = Capsule::table('tblpricing')
->where('type', '=', 'product')
->where('currency', '=', $currencyid)
->where('relid', '=', $pid)
->first();
$msetupfee = $data->msetupfee;
$qsetupfee = $data->qsetupfee;
$ssetupfee = $data->ssetupfee;
$asetupfee = $data->asetupfee;
$bsetupfee = $data->bsetupfee;
$tsetupfee = $data->tsetupfee;
$monthly = $data->monthly;
$quarterly = $data->quarterly;
$semiannually = $data->semiannually;
$annually = $data->annually;
$biennially = $data->biennially;
$triennially = $data->triennially;
$configOptionsGroupID = Capsule::table('tblproductconfiglinks')
->where('pid', '=', $pid)
->select('gid')
->first();
$configOptions = Capsule::table('tblproductconfigoptions')
->where('gid', '=', $configOptionsGroupID->gid)
->select('id','qtyminimum')
->get();
foreach($configOptions as $configOption) {
$configOptionSub = Capsule::table('tblproductconfigoptionssub')
->where('configid', '=', $configOption->id)
->select('id')
->first();
$configOptionPrices = Capsule::table('tblpricing')
->where('type', '=', 'configoptions')
->where('relid', '=', $configOptionSub->id)
->where('currency', '=', $currencyid)
->first();
$msetupfee += $configOptionPrices->msetupfee * $configOption->qtyminimum;
$qsetupfee += $configOptionPrices->qsetupfee * $configOption->qtyminimum;
$ssetupfee += $configOptionPrices->ssetupfee * $configOption->qtyminimum;
$asetupfee += $configOptionPrices->asetupfee * $configOption->qtyminimum;
$bsetupfee += $configOptionPrices->bsetupfee * $configOption->qtyminimum;
$tsetupfee += $configOptionPrices->tsetupfee * $configOption->qtyminimum;
$monthly += $configOptionPrices->monthly * $configOption->qtyminimum;
$quarterly += $configOptionPrices->quarterly * $configOption->qtyminimum;
$semiannually += $configOptionPrices->semiannually * $configOption->qtyminimum;
$annually += $configOptionPrices->annually * $configOption->qtyminimum;
$biennially += $configOptionPrices->biennially * $configOption->qtyminimum;
$triennially += $configOptionPrices->triennially * $configOption->qtyminimum;
}
$systemurl = App::getSystemUrl();
if ($paytype=="free") {
$output .= $_LANG['orderfree'];
} elseif ($paytype=="onetime") {
$output .= formatCurrency($monthly);
if ($msetupfee!="0.00") $output .= " + ".formatCurrency($msetupfee)." ".$_LANG['ordersetupfee'];
} elseif ($paytype=="recurring") {
if ($monthly>=0) {
$output .= '';
}
if ($quarterly>=0) {
$output .= '';
}
if ($semiannually>=0) {
$output .= '';
}
if ($annually>=0) {
$output .= '';
}
if ($biennially>=0) {
$output .= '';
}
if ($triennially>=0) {
$output .= '';
}
}
widgetoutput($output);
function widgetoutput($value) {
echo "document.write('".$value."');";
exit;
}