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;
}
}
