'' group by follow_up order by value desc"; //echo $sql; $rs = $dbase->db_sql_query($sql); if(count($rs)=='0') { return false; } else { if(count($rs) == count($rs, COUNT_RECURSIVE)) { if($rs=='') return false; else return array($rs); } else return $rs; } } function showfollowup() { global $inputs; $sfid = $inputs->sfid; $html = '

'; $k=0; $rs = getfollowups($sfid); //while($row = mysqli_fetch_array($rs)) if($rs!='') { foreach($rs as $row) { $k++; // Time Taken to wrap count if($k%2==0) $bgsfc = "#F0F0FF"; else $bgsfc = "#FFFFFF"; $folll = str_replace(' ','-',$row[1]); $html.=' '; } } $html.='

Sno	Follow up	Total Profiles
'.$k.'	[ + ] '.$row[1].'	'.$row[0].'

'; return $html; } function tlremarks() { global $inputs,$dbase; $sfid = $inputs->sfid; $pid = $inputs->pid; $fid = $inputs->fid; $rev = $inputs->rev; $srev = $inputs->srev; $sesstaff = $inputs->admuser; if($srev=='1') { $column = 'tl_review'; $column1 = "tl_remarks"; } else if($srev=='2') { $column = 'sup_review'; $column1 = "sup_remarks"; } else { $column = 'sup_review'; $column1 = "sup_remarks"; } if($rev==1) { $sql = "update ".CADB_name.".call_activity_bucket set $column = '$sesstaff' where profileid='$pid' and follow_up = '$fid' and date(act_date) = curdate() and staff_id='$sfid'"; $rs = $dbase->db_sql_query($sql); } else { $sql = "update ".CADB_name.".call_activity_bucket set $column1 = '$rev' where profileid='$pid' and follow_up = '$fid' and date(act_date) = curdate() and staff_id='$sfid'"; $rs = $dbase->db_sql_query($sql); } return $sesstaff; } ?>