public function modify_custom($ticket_id, $custom_input)
{
$ticket_customs = $this->get_all_custom($ticket_id);
$ticket_columns = array();
foreach ($ticket_customs as $row) {
$ticket_columns[$row['column_name']] = $row;
}
foreach ($custom_input as $key => $value) {
if (!empty($ticket_columns[$key]['detail']) || !empty($value)) {
if (is_null($ticket_columns[$key]['detail'])) {
$custom_detail = new Model_TicketColumnDetail();
$custom_detail->ticket_id = $ticket_id;
$custom_detail->column_id = $ticket_columns[$key]['column_id'];
$custom_detail->detail = !empty($value) ? $value : '';
$custom_detail->updated_at = date("Y-m-d H:i:s");
$custom_detail->save();
$c_id = $custom_detail->id;
} else {
$dao = Model_TicketColumnDetail::data_access();
$custom_detail = $dao->find_by_pk($ticket_columns[$key]['id']);
$custom_detail->detail = !empty($value) ? $value : '';
$custom_detail->updated_at = date("Y-m-d H:i:s");
$custom_detail->save();
$c_id = $custom_detail->id;
}
}
}
return $c_id;
}
public function get_ticket_custom($ticket_id)
{
$dao = Model_TicketColumnDetail::data_access();
$custom = $dao->filter(Model_TicketColumnDetail::TicketID, $ticket_id);
$custom = $custom->find();
return $counter;
}
