logthis("Inside Quote Save",'debug'); $focus = new Quote(); if(isset($_REQUEST['record'])) { $focus->id = $_REQUEST['record']; $vtlog->logthis("Quote ID ".$focus->id,'debug'); } if(isset($_REQUEST['mode'])) { $focus->mode = $_REQUEST['mode']; $vtlog->logthis("Mode is ".$focus->mode,'debug'); } //$focus->retrieve($_REQUEST['record']); foreach($focus->column_fields as $fieldname => $val) { if(isset($_REQUEST[$fieldname])) { $value = $_REQUEST[$fieldname]; $match = stristr($fieldname,'id'); // adding this to try and set only foreign keys. we dont want ALL blank values set to null // New Lines HERE if(empty($value) && $match != '0') { $value = 'null'; } //echo '
'; //echo $fieldname." ".$value; //echo '
'; $focus->column_fields[$fieldname] = $value; } } $vtlog->logthis("The Field Value Array -----> ".$focus->column_fields ,'debug'); $focus->save("Quotes"); $ext_prod_arr = Array(); if($focus->mode == 'edit') { $query2 = "select * from quotesproductrel where quoteid=".$focus->id; $result2 = $adb->query($query2); $num_rows = $adb->num_rows($result2); for($i=0; $i<$num_rows;$i++) { $pro_id = $adb->query_result($result2,$i,"productid"); $pro_qty = $adb->query_result($result2,$i,"quantity"); $ext_prod_arr[$pro_id] = $pro_qty; } $vtlog->logthis("Deleting from quotesproductrel table ",'debug'); $query1 = "delete from quotesproductrel where quoteid=".$focus->id; //echo $query1; $adb->query($query1); } //Printing the total Number of rows $tot_no_prod = $_REQUEST['totalProductCount']; $vtlog->logthis("The total Product Count is ".$tot_no_prod,'debug'); for($i=1; $i<=$tot_no_prod; $i++) { $product_id_var = 'hdnProductId'.$i; $status_var = 'hdnRowStatus'.$i; $qty_var = 'txtQty'.$i; $list_price_var = 'txtListPrice'.$i; $prod_id = $_REQUEST[$product_id_var]; $prod_status = $_REQUEST[$status_var]; $qty = $_REQUEST[$qty_var]; $listprice = $_REQUEST[$list_price_var]; if($prod_status != 'D') { $query ="insert into quotesproductrel values(".$focus->id.",".$prod_id.",".$qty.",".$listprice.")"; //echo $query; $adb->query($query); //Checking the re-order level and sending mail updateStk($prod_id,$qty,$focus->mode,$ext_prod_arr); } } /* echo 'rowid : '.$_REQUEST[$product_id_var]; echo '
'; echo 'status : '.$_REQUEST['hdnRowStatus1']; echo '
'; echo 'qty : '.$_REQUEST['txtQty1']; echo '
'; echo 'LP: '.$_REQUEST['txtListPrice1']; */ $return_id = $focus->id; if(isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != "") $return_module = $_REQUEST['return_module']; else $return_module = "Quotes"; if(isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != "") $return_action = $_REQUEST['return_action']; else $return_action = "DetailView"; if(isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") $return_id = $_REQUEST['return_id']; $local_log->debug("Saved record with id of ".$return_id); function updateStk($product_id,$qty,$mode,$ext_prod_arr) { global $vtlog; global $adb; global $current_user; $vtlog->logthis("Inside Quote updateStk function.",'debug'); $vtlog->logthis("Product Id is".$product_id,'debug'); $vtlog->logthis("Qty is".$qty,'debug'); $prod_name = getProductName($product_id); $qtyinstk= getPrdQtyInStck($product_id); $vtlog->logthis("Prd Qty in Stock ".$qtyinstk,'debug'); if($mode == 'edit') { if(array_key_exists($product_id,$ext_prod_arr)) { $old_qty = $ext_prod_arr[$product_id]; if($old_qty > $qty) { $diff_qty = $old_qty - $qty; $upd_qty = $qtyinstk+$diff_qty; //Updating the Product Quantity //updateProductQty($product_id, $upd_qty); sendPrdStckMail($product_id,$upd_qty,$prod_name,$qtyinstk,$qty); } elseif($old_qty < $qty) { $diff_qty = $qty - $old_qty; $upd_qty = $qtyinstk-$diff_qty; //updateProductQty($product_id, $upd_qty); sendPrdStckMail($product_id,$upd_qty,$prod_name,$qtyinstk,$qty); } } else { $upd_qty = $qtyinstk-$qty; //updateProductQty($product_id, $upd_qty); sendPrdStckMail($product_id,$upd_qty,$prod_name,$qtyinstk,$qty); } } else { $upd_qty = $qtyinstk-$qty; //updateProductQty($product_id, $upd_qty); sendPrdStckMail($product_id,$upd_qty,$prod_name,$qtyinstk,$qty); } } function sendPrdStckMail($product_id,$upd_qty,$prod_name,$qtyinstk,$qty) { global $current_user; global $adb; global $vtlog; $reorderlevel = getPrdReOrderLevel($product_id); $vtlog->logthis("Prd reorder level ".$reorderlevel,'debug'); if($upd_qty < $reorderlevel) { //send mail to the handler $vtlog->logthis("Sending mail to handler ",'debug'); $handler=getPrdHandler($product_id); $handler_name = getUserName($handler); $vtlog->logthis("Handler Name is ".$handler_name,'debug'); $to_address= getUserEmail($handler); $vtlog->logthis("Handler Email is ".$to_address,'debug'); //Get the email details from database; $query = "select * from inventorynotification where notificationname='QuoteNotification'"; $result = $adb->query($query); $subject = $adb->query_result($result,0,'notificationsubject'); $body = $adb->query_result($result,0,'notificationbody'); $subject = str_replace('{PRODUCTNAME}',$prod_name,$subject); $body = str_replace('{HANDLER}',$handler_name,$body); $body = str_replace('{PRODUCTNAME}',$prod_name,$body); $body = str_replace('{CURRENTSTOCK}',$qtyinstk,$body); $body = str_replace('{QUOTEQUANTITY}',$qty,$body); $body = str_replace('{CURRENTUSER}',$current_user->user_name,$body); SendMailToCustomer($to_address,$current_user->id,$subject,$body); } } function getPrdQtyInStck($product_id) { global $adb; $query1 = "select qtyinstock from products where productid=".$product_id; $result=$adb->query($query1); $qtyinstck= $adb->query_result($result,0,"qtyinstock"); return $qtyinstck; } function getPrdReOrderLevel($product_id) { global $adb; $query1 = "select reorderlevel from products where productid=".$product_id; $result=$adb->query($query1); $reorderlevel= $adb->query_result($result,0,"reorderlevel"); return $reorderlevel; } function getPrdHandler($product_id) { global $adb; $query1 = "select handler from products where productid=".$product_id; $result=$adb->query($query1); $handler= $adb->query_result($result,0,"handler"); return $handler; } function SendMailToCustomer($to,$current_user_id,$subject,$contents) { global $vtlog; $vtlog->logthis("Inside SendMailToCustomer function.",'debug'); require_once("modules/Emails/class.phpmailer.php"); $mail = new PHPMailer(); $mail->Subject = $subject; $mail->Body = nl2br($contents); $mail->IsSMTP(); if($current_user_id != '') { global $adb; $sql = "select * from users where id= ".$current_user_id; $result = $adb->query($sql); $from = $adb->query_result($result,0,'email1'); $initialfrom = $adb->query_result($result,0,'user_name'); } if($mail_server=='') { global $adb; $mailserverresult=$adb->query("select * from systems where server_type='email'"); $mail_server=$adb->query_result($mailserverresult,0,'server'); $_REQUEST['server']=$mail_server; } $mail->Host = $mail_server; $mail->SMTPAuth = true; $mail->Username = $mail_server_username; $mail->Password = $mail_server_password; $mail->From = $from; $mail->FromName = $initialfrom; $mail->AddAddress($to); $mail->AddReplyTo($from); $mail->WordWrap = 50; $mail->IsHTML(true); $mail->AltBody = "This is the body in plain text for non-HTML mail clients"; if(!$mail->Send()) { $errormsg = "Mail Could not be sent..."; } } header("Location: index.php?action=$return_action&module=$return_module&record=$return_id"); ?>