/** * This function sends a mail to the handler whenever the product reaches the reorder level. * Param $product_id - product id * Param $upd_qty - updated product quantity in no's * Param $prod_name - product name * Param $qtyinstk - quantity in stock * Param $qty - quantity * Param $module - module name * return type void */ function sendPrdStckMail($product_id, $upd_qty, $prod_name, $qtyinstk, $qty, $module) { global $log; $log->debug("Entering sendPrdStckMail(" . $product_id . "," . $upd_qty . "," . $prod_name . "," . $qtyinstk . "," . $qty . "," . $module . ") method ..."); global $current_user; global $adb; $reorderlevel = getPrdReOrderLevel($product_id); $log->debug("Inside sendPrdStckMail function, module=" . $module); $log->debug("Prd reorder level " . $reorderlevel); if ($upd_qty < $reorderlevel) { //send mail to the handler $handler = getRecordOwnerId($product_id); foreach ($handler as $type => $id) { $handler = $id; } $handler_name = getOwnerName($handler); if (vtws_isRecordOwnerUser($handler)) { $to_address = getUserEmail($handler); } else { $to_address = implode(',', getDefaultAssigneeEmailIds($handler)); } //Get the email details from database; if ($module == 'SalesOrder') { $notification_table = 'SalesOrderNotification'; $quan_name = '{SOQUANTITY}'; } if ($module == 'Quotes') { $notification_table = 'QuoteNotification'; $quan_name = '{QUOTEQUANTITY}'; } if ($module == 'Invoice') { $notification_table = 'InvoiceNotification'; } $query = "select * from vtiger_inventorynotification where notificationname=?"; $result = $adb->pquery($query, array($notification_table)); $subject = $adb->query_result($result, 0, 'notificationsubject'); $body = $adb->query_result($result, 0, 'notificationbody'); $status = $adb->query_result($result, 0, 'status'); if ($status == 0 || $status == '') { return false; } $subject = str_replace('{PRODUCTNAME}', $prod_name, $subject); $body = str_replace('{HANDLER}', $handler_name, $body); $body = str_replace('{PRODUCTNAME}', $prod_name, $body); if ($module == 'Invoice') { $body = str_replace('{CURRENTSTOCK}', $upd_qty, $body); $body = str_replace('{REORDERLEVELVALUE}', $reorderlevel, $body); } else { $body = str_replace('{CURRENTSTOCK}', $qtyinstk, $body); $body = str_replace($quan_name, $qty, $body); } $body = str_replace('{CURRENTUSER}', $current_user->user_name, $body); $mail_status = send_mail($module, $to_address, $current_user->user_name, $current_user->email1, decode_html($subject), nl2br(to_html($body))); } $log->debug("Exiting sendPrdStckMail method ..."); }
function vtws_getOwnerType($ownerId) { if (vtws_isRecordOwnerGroup($ownerId) == true) { return 'Groups'; } if (vtws_isRecordOwnerUser($ownerId) == true) { return 'Users'; } throw new WebServiceException(WebServiceErrorCode::$INVALIDID, "Invalid owner of the record"); }
function vtws_getOwnerType($ownerId) { /** Б• 150824ГeГXГg СеМF Б• ******/ return 'Users'; /** Б£ 150824ГeГXГg СеМF Б£ ******/ if (vtws_isRecordOwnerGroup($ownerId) == true) { return 'Groups'; } if (vtws_isRecordOwnerUser($ownerId) == true) { return 'Users'; } //Б°М†МјБ|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б|Б| throw new WebServiceException(WebServiceErrorCode::$INVALIDID, "Invalid owner of the record"); }