public static function get_db($filter_group, $filter_value) { if ($filter_group == 1) { $call_report = call_reportDB::where('customer_id', '=', $filter_value)->orderBy('created_at', 'DESC')->get(); } else { $filter_value = "%" . $filter_value . "%"; $call_report = call_reportDB::where('hashtag', 'LIKE', $filter_value)->orderBy('created_at', 'DESC')->get(); } if (isset($call_report) && $call_report) { $return_data = []; foreach ($call_report as $record) { if (isset($record->assingto->id)) { $assigned = $record->assingto->nickname . " - " . $record->assingto->name . " " . $record->assingto->surname; } else { $assigned = ""; } $return_data[] = ['id' => $record->id, 'company_name' => $record->customer->symbol . " - " . $record->customer->name, 'Hashtag' => $record->hashtag, 'comment' => $record->comment, 'assigned' => $assigned, 'created_by' => $record->createdby->nickname . " - " . $record->createdby->name . " " . $record->createdby->surname, 'created_at' => $record->created_at]; } return $return_data; } }
public static function getdata($id, $method, $value) { $call_report = call_reportDB::where('id', '=', $id)->first(); if (count($call_report) > 0) { switch ($value) { case "customer_id": $returndata = "[" . $call_report->customer->id . "] " . $call_report->customer->symbol . " - " . $call_report->customer->name; break; case "hashtag": $returndata = $call_report->hashtag; break; case "comment": $returndata = $call_report->comment; break; case "assigned_id": if (isset($call_report->assingto->id)) { $returndata = "[" . $call_report->assingto->id . "] " . $call_report->assingto->nickname . " - " . $call_report->assingto->name . " " . $call_report->assingto->surname; } else { $returndata = ""; } break; case "created_by": $returndata = "[" . $call_report->createdby->id . "] " . $call_report->createdby->nickname . " - " . $call_report->createdby->name . " " . $call_report->createdby->surname; break; case "created_at": $returndata = Date_time::convert_to_thai_format($call_report->created_at); break; } return $returndata; } }