function sendMail($sbSolCoId, $bnSupAnou) { $arNombTab = array(1 => 'opalo_cotizaciones_items'); $arSelFiel = array(0 => "opalo_cotizaciones_items.name "); $arWhereFi = array(0 => "opalo_cotizaciones_items.parent_type", 1 => "opalo_cotizaciones_items.parent_id"); $arWhereVa = array(0 => "opalo_solicitudes_cotizacion", 1 => $sbSolCoId); $arJoinFi1 = array(); $arJoinFi2 = array(); $arFielDes = FnCrm::getFields($arNombTab, $arSelFiel, $arWhereFi, $arWhereVa, $arJoinFi1, $arJoinFi2, 0); $arNombTab = array(1 => 'opalo_proveedores_opalo_solicitudes_cotizacion_1_c'); $arSelFiel = array(0 => "opalo_prova919eedores_ida "); $arWhereFi = array(0 => "opalo_prov5077izacion_idb", 1 => "deleted"); $arWhereVa = array(0 => $sbSolCoId, 1 => '0'); $arJoinFi1 = array(); $arJoinFi2 = array(); $arSupplId = FnCrm::getFields($arNombTab, $arSelFiel, $arWhereFi, $arWhereVa, $arJoinFi1, $arJoinFi2, 0); foreach ($arFielDes as $key => $item) { $arFielDes[$key]['proveedores'] = $arSupplId; } $sbAsuntEm = $bnSupAnou->sbMsjHead; $arFromEma['from'] = "*****@*****.**"; $arFromEma['from_name'] = "Juan"; $sbContent = $bnSupAnou->sbMsjBody; FnCrm::sendEmailWithItems(1, $arFielDes, $sbAsuntEm, $sbContent, $arFromEma); }
function sendMail($sbSolCoId) { $arNombTab = array(1 => 'opalo_cotizaciones_items'); $arSelFiel = array(0 => "opalo_cotizaciones_items.name ", 1 => "opalo_cotizaciones_items.proveedor_seleccionado"); $arWhereFi = array(0 => "opalo_cotizaciones_items.parent_type", 1 => "opalo_cotizaciones_items.parent_id"); $arWhereVa = array(0 => "opalo_solicitudes_cotizacion", 1 => $sbSolCoId); $arJoinFi1 = array(); $arJoinFi2 = array(); $arFielDes = FnCrm::getFields($arNombTab, $arSelFiel, $arWhereFi, $arWhereVa, $arJoinFi1, $arJoinFi2, 0); // foreach ($arFielDes as $key => $value) { $arFielDes[$key]['proveedores'][]['opalo_prova919eedores_ida'] = $value['proveedor_seleccionado']; unset($arFielDes[$key]['proveedor_seleccionado']); } $sbAsuntEm = "Usted fue seleccionado"; $arFromEma['from'] = "*****@*****.**"; $arFromEma['from_name'] = "Juan"; $sbContent = "\n Buenos dias, \n el correo es para informarle que usted fue seleccionado para suministrar los items:\n "; FnCrm::sendEmailWithItems(1, $arFielDes, $sbAsuntEm, $sbContent, $arFromEma); }