pquery($del_act,array($id, $id)); if($_REQUEST['owner_type'] == 'User') { $count_r = $adb->pquery("select * from vtiger_salesmanactivityrel where smid=? and activityid=?",array($idval, $id)); if($adb->num_rows($count_r) == 0) { $insert = "insert into vtiger_salesmanactivityrel values(?,?)"; $result = $adb->pquery($insert, array($idval, $id)); } } } //Now we have to update the smownerid $sql = "update vtiger_crmentity set modifiedby=?, smownerid=?, modifiedtime=? where crmid=?"; $result = $adb->pquery($sql, array($current_user->id, $idval, $adb->formatDate($date_var, true), $id)); } else { $ids_list[] = $id; } } } elseif(isset($_REQUEST['leadval']) && $_REQUEST['leadval']!='') { foreach($storearray as $id) { if(isPermitted($return_module,'EditView',$id) == 'yes') { if($id != '') { $sql = "update vtiger_leaddetails set leadstatus=? where leadid=?"; $result = $adb->pquery($sql, array($leadstatusval, $id)); $query = "update vtiger_crmentity set modifiedby=?, modifiedtime=? where crmid=?"; $result1 = $adb->pquery($query, array($current_user->id, $adb->formatDate($date_var, true), $id)); } } else { $ids_list[] = $id; } } } if(count($ids_list) > 0) { $ret_owner = getEntityName($return_module,$ids_list); $errormsg = implode(',',$ret_owner); } else { $errormsg = ''; } if($return_action == 'ActivityAjax') { $view = vtlib_purify($_REQUEST['view']); $day = vtlib_purify($_REQUEST['day']); $month = vtlib_purify($_REQUEST['month']); $year = vtlib_purify($_REQUEST['year']); $type = vtlib_purify($_REQUEST['type']); $viewOption = vtlib_purify($_REQUEST['viewOption']); $subtab = vtlib_purify($_REQUEST['subtab']); header("Location: index.php?module=$return_module&action=".$return_action."&type=".$type.$rstart."&view=".$view."&day=".$day."&month=".$month."&year=".$year."&viewOption=".$viewOption."&subtab=".$subtab.$url); } else { header("Location: index.php?module=$return_module&action=".$return_module."Ajax&file=ListView&ajax=changestate".$rstart."&viewname=".$viewid."&errormsg=".$errormsg.$url); } ?>