getOne($get_notes); return $num_logs; } public function num_notes($table,$id,$db_name = "") { global $database; $get_notes = " SELECT count(id) FROM $db_name"."logs_notes WHERE foreign_id = '$id' AND table_name = '$table' AND action_type = '4'"; $num_notes = $database->getOne($get_notes); return $num_notes; } public function submit_logs($context) { global $database; $table = $context['table']; $foreign_id = $context['foreign_id']; $description = $context['description']; $action_type = $context['action_type']; $submitter = $_SESSION['user']['id']; $current_date_time = date('Y-m-d G:i:s'); $insert = " INSERT INTO logs_notes (`table_name` ,`action_type` ,`foreign_id` ,`description` ,`date_submitted` ,`submitter`) VALUES('$table','$action_type','$foreign_id','$description','$current_date_time','$submitter')"; $query_insert = $database->query($insert); } public function get_logs($context) { global $database; $table = $context['table']; $foreign_id = $context['id']; $database = $context['database']; $user_db = $context['user_db']; $get_notes = " SELECT * FROM logs_notes WHERE foreign_id = '$foreign_id' AND table_name = '$table' ORDER BY date_submitted DESC"; $results = $database->getAll($get_notes); $users = common_users::get_users(); $final_results = array(); if(count($results) > 0) { foreach($results AS $result) { $description = $result['action']; $submitter = $users($result['submitter']); $date = $result['date_submitted']; $id = $result['id']; $date = dates::change_date_time($date); $final_results[] = array( "description" => $description, "submitter" => $submitter, "date" => $date, "id" => $id ); } } return $final_results; } public function show_logs($context) { global $database; $table = $context['table']; $foreign_id = $context['id']; $user_db = $context['user_db']; $get_notes = " SELECT * FROM logs_notes WHERE foreign_id = '$foreign_id' AND table_name = '$table' ORDER BY date_submitted DESC"; $results = $database->getAll($get_notes); //bug::bug_array("results",$results); $users = common_ref_client::get_all_staff(); ?>

0) { foreach($results AS $result) { $id = $result['id']; $action_type = $result['action_type']; $table_name = $result['table_name']; $foreign_id = $result['foreign_id']; $description = $result['description']; $submitter = $result['submitter']; $date_submitted = $result['date_submitted']; $submitter = $users[$result['submitter']]['first_name']." ".$users[$result['submitter']]['last_name']; $date = dates::change_date_time($date_submitted); if($action_type == 4) { $description = nl2br( stripslashes( htmlentities( $result['description'], ENT_QUOTES, 'UTF-8' ) ) ); ?>