function b_show_rmsrv_service($options)
{
global $xoopsDB;
$block = array();
list($num) = $xoopsDB->fetchRow($xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("rmsrv_servicios") . " WHERE inblock='1' AND activo='1'"));
if ($num <= 0) {
return;
}
include_once XOOPS_ROOT_PATH . "/modules/rmservices/include/functions.php";
for ($i = 1; $i <= $options[0]; $i++) {
if ($num > 1) {
$num = $num - 1;
mt_srand((double) microtime() * 1000000);
$snum = mt_rand(0, $num);
} else {
$snum = 0;
}
$sql = "SELECT id_srv, nombre, shortdesc, img, codigo, precio FROM " . $xoopsDB->prefix("rmsrv_servicios") . " WHERE inblock='1' AND activo='1' LIMIT {$snum}, 1";
$result = $xoopsDB->query($sql);
$row = $xoopsDB->fetchArray($result);
$rtn = array();
if ($options[1]) {
$form = FormBuy($row['nombre'], $row['codigo'], $row['precio'], 'srv');
}
$rtn['form'] = $form;
$rtn['nombre'] = $row['nombre'];
if ($options[2]) {
$rtn['desc'] = $row['shortdesc'];
}
$rtn['img'] = $row['img'];
$rtn['id'] = $row['id_srv'];
$block['servicios'][] = $rtn;
}
return $block;
}
function b_show_rmsrv_banners()
{
global $xoopsDB;
$myts =& MyTextSanitizer::getInstance();
$block = array();
list($num) = $xoopsDB->fetchRow($xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("rmsrv_banners")));
if ($num <= 0) {
return;
}
if ($num > 1) {
$num = $num - 1;
mt_srand((double) microtime() * 1000000);
$snum = mt_rand(0, $num);
} else {
$snum = 0;
}
$sql = "SELECT * FROM " . $xoopsDB->prefix("rmsrv_banners") . " LIMIT {$snum}, 1";
$result = $xoopsDB->query($sql);
$row = $xoopsDB->fetchArray($result);
$rtn = array();
include_once XOOPS_ROOT_PATH . "/modules/rmservices/include/functions.php";
if ($row['buy']) {
$form = FormBuy(ServiceData($row['id_srv'], "nombre"), ServiceData($row['id_srv'], "codigo"), ServiceData($row['id_srv'], "precio"), 'srv');
}
$rtn['id'] = $row['id_ban'];
$rtn['img'] = str_replace('{servicio}', $row['id_srv'], $row['img']);
$rtn['desc'] = $myts->makeTareaData4Show($row['desc']);
$rtn['border'] = $row['showborder'];
$rtn['ids'] = $row['id_srv'];
$rtn['form'] = $form;
$block['bann'][] = $rtn;
return $block;
}
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("rmsrv_servicios") . " WHERE id_srv='{$ids}'");
$num = $xoopsDB->getRowsNum($result);
if ($num <= 0) {
redirect_header('index.php', 1, _MM_NOEXIST);
die;
}
$row = $xoopsDB->fetchArray($result);
include XOOPS_ROOT_PATH . "/header.php";
// Precio del producto
if ($row['presupuesto']) {
$p1 = "Requiere Presupuesto";
$form = "<a href='reqpre.php?item=srv&idc={$row['id_srv']}'><img src='images/presu.gif' border='0'></a>";
} else {
setlocale(LC_MONETARY, $xoopsModuleConfig['money']);
$p1 = money_format($xoopsModuleConfig['formatmoney'], $row['precio']);
$form = FormBuy($row['nombre'], $row['codigo'], $row['precio'], 'srv', 1);
}
$xoopsTpl->assign('servicio', array('id' => $row['id_srv'], 'nombre' => $row['nombre'], 'img' => $row['img'], 'precio' => $p1, 'desc' => $myts->makeTareaData4Show($row['longdesc']), 'codigo' => $row['codigo'], 'presup' => $row['presupuesto'], 'curconvert' => "<br><a href='javascript:;' style='font-size: 10px; font-weight: normal;' onClick=\"openWithSelfMain('http://www.xe.com/ecc/input.cgi?Template=sw&Amount={$row['precio']}','convert',600,170)\">" . _MM_CONVERT_CUR . "</a>"));
$xoopsTpl->assign('srvform', $form);
$xoopsTpl->assign('lng_caract', _MM_CARACT);
$xoopsTpl->assign('lng_precio', _MM_PRICE);
$xoopsTpl->assign('buyinfo', $xoopsModuleConfig['buyinfo']);
$xoopsTpl->assign('lng_contact', _MM_CONTACT);
$xoopsTpl->assign('link_contact', $xoopsModuleConfig['linkcontact']);
$xoopsTpl->assign('lng_services', _MM_LNGSERVICES);
$xoopsTpl->assign('lng_lnkpromos', _MM_LNGPROMOS);
$tblcr = $xoopsDB->prefix("rmsrv_carrel");
$tblc = $xoopsDB->prefix("rmsrv_caract");
$result = $xoopsDB->query("SELECT {$tblcr}.*, {$tblc}.* FROM {$tblcr}, {$tblc} WHERE {$tblcr}.id_srv='{$ids}' AND {$tblc}.id_car={$tblcr}.id_car");
while ($row = $xoopsDB->fetchArray($result)) {
if ($row['img'] != '') {
GetBanner();
$xoopsTpl->assign('lng_contact', _MM_CONTACT);
$xoopsTpl->assign('lng_precio', _MM_PRICE);
$xoopsTpl->assign('lng_included', _MM_INCLUDED);
$xoopsTpl->assign('show', 0);
$xoopsTpl->assign('lng_services', _MM_LNGSERVICES);
$xoopsTpl->assign('lng_lnkpromos', _MM_LNGPROMOS);
include XOOPS_ROOT_PATH . "/footer.php";
break;
default:
include XOOPS_ROOT_PATH . "/header.php";
$xoopsOption['template_main'] = 'rmsrv_promos.html';
//Plantilla para esta página
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix('rmsrv_promos') . " ORDER BY nombre");
setlocale(LC_MONETARY, $xoopsModuleConfig['money']);
include_once 'include/functions.php';
include 'include/banners.php';
GetBanner();
while ($row = $xoopsDB->fetchArray($result)) {
$form = FormBuy($row['nombre'], $row['codigo'], $row['precio'], 'promo');
$p1 = money_format($xoopsModuleConfig['formatmoney'], $row['precio']);
$xoopsTpl->append('promos', array('id' => $row['id_promo'], 'nombre' => $row['nombre'], 'desc' => $row['shortdesc'], 'precio' => $p1, 'img' => $row['img'], 'formbuy' => $form, 'curconvert' => "<br><a href='javascript:;' style='font-size: 10px; font-weight: normal;' onClick=\"openWithSelfMain('http://www.xe.com/ecc/input.cgi?Template=sw&Amount={$row['precio']}&From=USD','convert',600,170)\">" . _MM_CONVERT_CUR . "</a>"));
}
$xoopsTpl->assign('lng_list', _MM_LIST);
$xoopsTpl->assign('show', 1);
$xoopsTpl->assign('lng_services', _MM_LNGSERVICES);
$xoopsTpl->assign('lng_lnkpromos', _MM_LNGPROMOS);
$xoopsTpl->assign('lng_precio', _MM_PRICE);
include XOOPS_ROOT_PATH . "/footer.php";
break;
}
