"; echo ""; echo ""; echo ""; echo ""; echo ""; } public function select_creator($dash_type, $dash_size, $dash_data, $condition, $title) { $item = new DASHBOARD; switch ($dash_type) { case 'create_graph': // echo'Graph'; $item->create_graph($dash_size, $dash_data, $condition, $title); break; case 'create_details': // echo'Details'; $item->create_details($dash_size, $dash_data, $condition, $title); break; default: echo "Error: Invalid Dashboard Type"; } } private function create_graph($dash_size, $dash_data, $condition, $title) { if (isset($condition)) { $new_con = "AND" . $condition; } $db = new db_safeguard(); $results = $db->select_query("{$dash_data}", '*', "user_id_assigned = {$_SESSION['user_id']} {$new_con}"); switch ($dash_size) { case 'small': $result = $results->num_rows(); echo "{$result}"; echo "Small Graph Created"; break; case 'medium': echo "Medium Graph Created"; break; case 'large': echo "Large Graph Created"; break; default: echo "Error: Invalid Dashboard Size"; } } private function create_details($dash_size, $dash_data, $condition, $title) { if (isset($condition)) { $new_con = " AND " . $condition; } // echo "select_query('{$dash_data}', '*', 'user_id_assigned = {$_SESSION['user_id']} {$new_con}');"; $db = new db_safeguard(); $results = $db->select_query("{$dash_data}", '*', "user_id_assigned = {$_SESSION['user_id']} {$new_con}"); switch ($dash_size) { case 'small': $result = $results->num_rows; echo "

{$title}

{$result}

"; // echo "Small details Created"; break; case 'medium': $result = $results->num_rows; echo "

{$title}

{$result}

"; while ($row = $results->fetch_assoc()) { // $clients = $db->select_query("clients", '*', "record_id = {$row[]} {$new_con}"); } ; echo "

"; // echo "Medium details Created"; break; case 'large': echo "Large details Created"; break; } } }